EVOLUTION-NINJA

Edit File: yarn_raw_billing_grid.php

text-transform: uppercase !important;

}
.ui-jqgrid tr.jqgrow td{ 
text-transform: uppercase !important;
}
</style>
<div class="page-content-wrapper">
<div class="page-content">

<h3 class="page-title">
		Yarn Billing Details
			</h3>
<?php // echo $this->load->view('templates/nav_menu'); ?>

<div class="page-bar">
		<ul class="page-breadcrumb">
			<li><i class="fa fa-home"></i> <a href="<?php echo base_url();?>dashboard">Home</a> <i
			class="fa fa-angle-right"></i> <a href="#" > Billing </a></li>
		</ul>
	</div>

<?php if(empty($access_row))
{
}
else 
{
if($access_row->insert_id == '1') { ?>

<form action="<?php echo base_url(); ?>packing_list/yarn_raw_details" method="post" class="form-horizontal">
<b>To insert data click here:</b>
<input type="submit" name="Insert" value="Insert" /><br><br>
</form>
<?php  } else { ?>

<?php  } }?>

<input type="hidden" id="preview_id" class="preview_id" value="<?php if(empty($access_row)){ } else { echo $access_row->preview_id; } ?>" >
<input type="hidden" id="edit_id" class="edit_id" value="<?php if(empty($access_row)){ } else { echo $access_row->edit_id; } ?>" >
<input type="hidden" id="delete_id" class="delete_id" value="<?php if(empty($access_row)){ } else { echo $access_row->delete_id; } ?>" >
<input type="hidden" id="approval_id" class="approval_id" value="<?php if(empty($access_row)){ } else { echo $access_row->approval_id; } ?>" >

<div id = "jaytab" class="jaytab" style="width:100% !important;">
	<table id="list2" ></table>
	<div id="pager2"></div>
	<div id="dialogSelectRow" title="Warning" style="display:none">
		<p>Please select row</p>
	</div>									
</div>

</div>
</div>
</div>

<link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>">
<script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" />

.well-sm {
    padding: 3px !important;
	border-radius: 0px !important;
}
input[type="file"] {
    padding-bottom: 28px !important;
    height: 25px !important;
    color:transparent;
}
.portlet.box.blue-madison {
    border: 1px solid #fff !important;
    border-top: 0;
    background:#fff !important;
}
#table_approved_indent
{
	//display:none;
}
#refresh_list3
{
	display:none !important;
}
@media only screen and (min-width:320px) and (max-width:640px) {
}
</style> 
			
			
			
			<script>
function getDesignAndQuality(articleNo) {
	
    $.ajax({
        type: "post",
        url: "<?php echo base_url(); ?>marketing/getDesignAndQuality",
        data: "articleNo=" + articleNo,
        success: function (data) {
            var objData = jQuery.parseJSON(data);
           document.getElementById("design").value = objData.design;
            document.getElementById("quality").value = objData.quality;
        }
    });
}
</script>

 
				    
		<link href="<?php echo base_url('assets/css/sweetalert2.min.css');?>" rel="stylesheet"/>
<script src="<?php echo base_url('assets/js/sweetalert2.min.js');?>"></script>

label {
    font-weight: normal;
    text-align: left;
}
.hr-line{
	border-top: 1px solid #465A81;
}

input[type=file] {
    display: none;
}
.ui-jqgrid .ui-jqgrid-caption {
    text-align: left;
    background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar {
    padding: .1em .1em;
    min-height: 35px;
     background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar-close span {
    display: block;
    margin: -9px;
}
#sData
{
	 height: 27px;
}
#cData
{
	 height: 27px;
}
#dData
{
	 height: 27px;
}
#eData
{
	 height: 27px;
}
.coledit
{	cursor:pointer;
	
padding-right: 22px !important;
padding-left: 23px !important;
margin-top: 4px !important;
color:bold !important;
}

</style>

<script>
 
	
	
  $(document).ready(function (){
	//var l=$("#loc").val();
	  //alert(l);
		jQuery("#list2").jqGrid({
			url:"<?php echo base_url('billing/yarn_details_fetch')?>",	 
			 mtype : "post", 	 
			datatype: "json", 
		    colNames:['Id','Billing No.','Vendor','Date','Currency','Total Amount','Yarn Type','Created By','Preview'],
				
			colModel:[
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
					  {name:'billing_no',index:'billing_no', width:50,editable:false,width:100},
					  {name:'vendor_name',index:'vendor_name',editable:true,hidden:true, width:100},
					  {name:'date',index:'date',editable:true,editrules:{required: true},editoptions: {size:10, maxlength: 10}, width:100},
					  {name:'currency',index:'currency',editable:true,editrules:{required: true}, width:100},
					   {name:'total_amt',index:'total_amt',editable:true,editrules:{required: true}, width:100},
					  {name:'yarn_type',index:'yarn_type',editable:true,editrules:{required: true}, width:100},
					  {name:'created_by',index:'created_by',editable:true,editrules:{required: true}, width:140},
					   {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	    return ' onclick="fun_billing_preview($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
                                return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>";
						  }}
					],
						height: 'auto',
		      	 rowNum:50,
		      	rowTotal: 200000000000000000000000000,
		      	rowList : [50,100,200,300,500,1000,5000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager2", 
		      	sortname:'id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		       	loadonce:true,
					caption:"Yarn Billing Details",
				 subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
         var subgrid_table_id;
	  //alert(row_id);
	   swan_id=row_id;
	   //alert(swan_id);
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
       jQuery("#"+subgrid_table_id).jqGrid({
	
     url:"<?php echo base_url('billing/yarn_result_fetch')?>/s"+row_id+"/",	
		
		
			  mtype : "get", 	 
			datatype: "json", 
         colNames:['Id','Yarn Name','Lot / Issue #','Bale','Billing Net / Dyed Weight','Unit Price','INR Value','SGST','CGST','IGST','Total Value'],
				
         colModel:[
					{name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
					{name:'yarnname',index:'yarnname',editable:true,editrules:{required: true}, width:220},
					{name:'lot',index:'lot',editable:true,editrules:{required: true}, width:120},
					{name:'bale',index:'bale',editable:true,editrules:{required: true}, width:120},
					{name:'bill_netwt',index:'bill_netwt',edittype:'text',editable:true,editrules:{required: true}, width:100},
					{name:'unitprice',index:'unitprice',edittype:'text',editable:true,editrules:{required: true}, width:100},
					{name:'inr_val',index:'inr_val',editable:true,editrules:{required: true}, width:60},
					{name:'sgst',index:'sgst',editable:true,editrules:{required: true}, width:100},
					{name:'cgst',index:'cgst',editable:true,editrules:{required: true}, width:60},
					{name:'igst',index:'igst',editable:true,editrules:{required: true}, width:60},
					{name:'totalvalue',index:'totalvalue',editable:true,editrules:{required: true}, width:60},
					 
					],
			height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc"
       });
   }
  });

//$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	jQuery("#list2").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
	 	
	 		$("#list2").jqGrid('navGrid','#pager2',
				{edit:false,add:false,del:false,search:false,refreshstate:"current"},
				{ },
		        { },
		        { }, 
				{
			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
			        closeOnEscape: true, 
			        	multipleSearch: true, 
			         	closeAfterSearch: true }
			);
 			
			// $("#list2").navButtonAdd('#pager2',
					// { 	caption:"Delete", 
						// buttonicon:"ui-icon-trash", 
						// onClickButton: deleteRow,
						// position: "last", 
						// title:"", 
						// cursor: "pointer",
						// id:"client_delete"
					// } 
				// );

});
	function fun_billing_preview(rowId)
		{
			var v=$('#preview_id').val();
			if(v == 1)
			{
				var id = rowId.closest('tr').attr('id'); 
		var as=id;

$.ajax({
				type:'post',
				url:'<?php echo base_url("billing/billing_preview"); ?>',
				data:{'as':as},
				async:false,
				success:function()
				{
					
					window.location.href  = '<?php echo base_url('billing/billing_preview');?>/'+ '?id='+as;
				}
				 
			});
			}
	 else
	{
		 swal({
			title: "You Don't Have Access For This Preview",
		text: "",
			});
	}
	}
</script>
	
<style>
.preview
{
	padding-bottom:3px !important;
	padding-top:3px !important;
}
.preview
{
	padding-bottom:3px !important;
	padding-top:3px !important;
}
.tablediv
{
	width: auto !important;
   // overflow: scroll !important;
}
.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td {
    overflow: hidden;
    white-space: pre;
   
	
}
</style>

</script>
	<style>
#jaytab{
	width:100%;
	//overflow:auto;

}
	#search_list2
{
	display:none !important;
}
	#list2_122_t
	{
		height:0px !important;
	}

.list2_136_t
{
	height:12px !important;
}
.scroll 
{
	height:12px !important;
}
.ui-jqgrid-btable
{
	
}
.ui-common-table
{
	height:12px !important;
}
#refresh_list2
{
	display:none !important;
}
#client_edit
{
	padding-right:12px !important;
}

#gbox_list2 {
    //width: 1300px !important;
	//height: auto !important;
}
#gview_list2 {
    //width: 1300px !important;
	//height: auto !important;
}

@media only screen and (min-width:320px) and (max-width:640px){
    		.ui-jqgrid {
    			margin-left: 1px !important;
    		}
    		.radio-list {
    			margin-left:7% !important;
    		}
    		
            #table_pending_indent{
    	        overflow-x: scroll;
            }
    		#jaytab{
    			margin-top: 0 !important;
    			margin-left: 0 !important;
    			overflow-x: scroll;
    			//width: 600px !important;
    			padding-left: 0 !important;
    		}
    		#jaytab1 {
    			margin-top: 0 !important;
    			margin-left: 0 !important;
    			overflow-x: scroll;
    			//width: 300px !important;
    			padding-left: 0 !important;
    		}
    		
    		#editmodlist2
    		{
    			//width:90% !important;
    		}
    		#sData span, #cData span {
    			margin-left: 0 !important;
    		}
    		#list2 {
            	width: 1300px !important;
            }
            #pager2 {
                width: 1300px !important;
            }
            #gbox_list2 {
                width: 1300px !important;
            }
            #gview_list2 {
                width: 1300px !important;
            }
		}
		@media only screen and (min-width:641px) and (max-width:991px){
			.ui-jqgrid {
			    margin-left: 1px !important;
			}
			#jaytab{
				margin-top: 0 !important;
				margin-left: 0 !important;
				overflow-x: scroll;
				width: 100% !important;
				padding-left:0 !important;
				padding-right:9px !important;
			}
			#list2 {
            	width: 1300px !important;
            }
            #pager2 {
                width: 1300px !important;
            }
            #gbox_list2 {
                width: 1300px !important;
            }
            #gview_list2 {
                width: 1300px !important;
            }
		}
		@media only screen and (min-width:992px) and (max-width:1258px){
		    #list2 {
            	width: 1300px !important;
            }
            #pager2 {
                width: 1300px !important;
            }
            #gbox_list2 {
                width: 1300px !important;
            }
            #gview_list2 {
                width: 1300px !important;
            }
		}
		
		
#sData span, #cData span 
{
    margin-left: 3px;
}
#sData {
    height: 29px;
}
#cData {
    height: 29px;
}

.jqgfirstrow
{
	    height: 0px !important;
}

/*#list2 {
	width: 1300px !important;
}
#pager2 {
    width: 1300px !important;
}
#gbox_list2 {
    width: 1300px !important;
}
#gview_list2 {
    width: 1300px !important;
}*/

#list3 {
	//width: 1300px !important;
}
#pager3 {
    //width: 1300px !important;
}
#gbox_list3 {
    //width: 1300px !important;
}
#gview_list3 {
    //width: 1300px !important;
}

/*.ui-jqgrid-hdiv {
    width: 1300px !important;
}
.ui-jqgrid-htable {
    width: 1300px !important;
}
.ui-jqgrid-bdiv {     
    width: 1300px !important;
}*/

.subgrid-data {
    overflow-x: scroll;
}
.jaytab {
		overflow-x:scroll;
}

@media only screen and (min-width:641px) and (max-width:991px) {
	.jaytab {
		overflow-x:scroll;
	}
}
@media only screen and (min-width:992px) and (max-width:1258px) {
	.jaytab {
		overflow-x:scroll;
	}
}

</style>

$("#jaytab1").hide();

$(".radio2").click(function(){
    $("#jaytab").hide();
    $("#jaytab1").show();
});

$(".radio1").click(function(){
    $("#jaytab1").hide();
    $("#jaytab").show();
});

</script>