EVOLUTION-NINJA

Edit File: pending_current_month_delivery_list.php

<?php
    //echo $usertype;
    //die();
?>
<script src="<?php echo base_url('assets/js/jquery.table2excel.js');?>"></script>
<script src="<?php echo base_url('assets/js/jspdf.debug.js');?>"></script>
<script src="<?php echo base_url('assets/js/jspdf.min.js');?>"></script>

text-transform: uppercase !important;

}
.ui-jqgrid tr.jqgrow td{ 
text-transform: uppercase !important;
}
</style>
<script>
function back_func()
{
	window.location.href = "<?php echo base_url('reports/inspected_fabric'); ?>"
}

</script>
<div class="page-content-wrapper">
<div class="page-content">

<h3 class="page-title">
Order List
</h3>
<div class="page-bar">
		<ul class="page-breadcrumb">
			<li><i class="fa fa-home"></i> <a href="<?php echo base_url(); ?>dashboard/dashboard_fun">Home</a> <i
			class="fa fa-angle-right"></i> <a href="<?php echo base_url(); ?>dashboard/dashboard_fun" > Dashboard </a></li>
		</ul>
	</div>

<input type="button" name="co" onclick="orders_preview()" value="Order Details" />
<input type="button" name="co" onclick="recent_shipment()" value="Recent Shipment" />
<input type="button" name="co" onclick="dtl_shipment()" value="DTL Shipment" />
<input type="button" name="co" onclick="buyer()" value="DTL Fabric Stock" />
<input type="button" name="co" onclick="customer()" value="Buyer Fabric Stock " />
<br/>
 <!-- <script>
function select_month()
{
var l=$('#select_month_id').val();
var d=$('#datepicker').val();
window.open("<?php echo base_url('marketing/get_month_wise_osl_delivery_list')?>/s"+l+"/"+d, '_blank');
}

</script> -->

<input type="hidden" id="usertype" class="usertype" value="<?php echo $usertype; ?>" >
<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="insert_id" class="insert_id" value="<?php if(empty($access_row)){ } else { echo $access_row->insert_id; } ?>" >
<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="approval_id" class="approval_id" value="<?php if(empty($access_row)){ } else { echo $access_row->approval_id; } ?>" >
<input type="hidden" value="<?php echo $ref; ?>" id="ref_id" >
	      <input type="hidden" value="<?php echo  $url_val; ?>" id="url_ref" style="width: 230px;" >

<div  style="margin-top:0%;margin-left: 28px;" id="fabric_material">
        <div  class="jaytab">
    		<div class="row">
              	<input type="radio" name="shipping"  onclick="pending()" checked /><lable>Orders Due to Ship</lable>
                <input type="radio"  name="shipping" class="full" onclick="full()" /><lable>Fully Shipped</lable>
          	</div>
        </div>
    </div>
	<div id = "jaytab3" style="margin-top:0%;margin-left: -28px;" class="col-sm-12 grid"><br/>
        <div class="grid_div"></div><table id="list3"></table>
            <div id="pager3"></div>
            <div id="dialogSelectRow3" title="Warning" style="display:none">
            <p>Please select row</p>
        </div>
    </div>
    <div id = "jaytab4" style="margin-top:0%;margin-left: -28px;" class="col-sm-12 grid"><br/>
        <div class="grid_div"></div><table id="list4"></table>
            <div id="pager4"></div>
            <div id="dialogSelectRow3" title="Warning" style="display:none">
            <p>Please select row</p>
        </div>
    </div>
				
</div>
</div>
</div>
<div style="display:none;"><table  border="1" style="border-spacing: 0px !important;" id="export_table" class="export_table"></table></div>
	<div style="display:none;">
		<table  border="1" style="border-spacing: 0px !important;" id="print_table" class="print_table"></table>
		</div>			
		<script>
// $("#datepicker").datepicker({
//     format: "yyyy",
//     viewMode: "years", 
//     minViewMode: "years"
// });
			function print_page1()
			{  
				
				var divToPrint=document.getElementById('print_table');
					newWin= window.open("");
					newWin.document.write('<html><head><title></title>');
					newWin.document.write('</head>');
					newWin.document.write(divToPrint.outerHTML);
					newWin.document.write('</html>');
					newWin.print();
					document.getElementById('print_table').style.display='';
					newWin.close();
					location.reload();
			}
			</script>

<script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	    
	    <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.min.js'); ?>"></script>
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" />
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.min.css'); ?>" />
						
		<script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script>
	
<script type="text/javascript">
CallGrid();
var v = $('#usertype').val();
//alert(v);
if((v == 4) || (v == 3) || (v == 9)){
     $("#list3").hideCol("value");
     $("#list3").hideCol("currency");
     $("#list3").hideCol("indian");
     $("#list3").hideCol("contractType");
     
     $("#list4").hideCol("value");
     $("#list4").hideCol("currency");
     $("#list4").hideCol("indian");
     $("#list4").hideCol("contractType");
}
function CallGrid()
{
		$.ajax({
            type : 'get',
			url:"<?php echo base_url('dashboard/pending_order_list_details')?>",	 
           success:function(response) {
           response=jQuery.parseJSON(response);
            console.log(response);
			jQuery('#list3').jqGrid('clearGridData');
            jQuery('#list3').jqGrid('setGridParam', {data: response});
        	jQuery('#list3').trigger('reloadGrid');

}
    	});
		jQuery("#list3").jqGrid({
			data:'',
			mtype:'get',
			datatype: "local", 
		   	colNames:['Id','Select','OSL No','File No', 'Party Order No','Qty','Order Type','Terms','Value','Currency','INR','Delivery Date','Change Del Date','Proforma Invoice','Order Confirmation','Status','Plan status','Ship Status','Shipped'],
   			colModel:[
		
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:50},
					  { name: 'select', label: 'select', width: 30,align: 'center',cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_radio_val($(this))" ';
	                        		},
                         formatter: function radio(cellValue, option) {
                             return '<input type="radio" name="radio_' + option.id +       '"  />';
                         } 
					  },
					  {name:'oslNo',index:'oslNo',editable:true,width:80},
					  {name:'fileNo',index:'fileNo',editable:true, width:50},
				// 	  {name:'orderMode',index:'orderMode',editable:true,editrules:{required: true},editoptions: {size:10, maxlength: 10}, width:120},
					  {name:'orderNo',index:'orderNo',edittype:'text',editable:true,editrules:{required: true}, width:100},
					  {name:'qnty',index:'qnty',edittype:'text',editable:true,editrules:{required: true}, width:50},
                      {name:'orders_Type',index:'orders_Type',edittype:'text',editable:true,editrules:{required: true}, width:70},
                      {name:'contractType',index:'contractType',edittype:'text',editable:true,editrules:{required: true}, width:105},
	                  {name:'value',index:'value',edittype:'text',editable:true,editrules:{required: true}, width:72},
	                  {name:'currency',index:'currency',edittype:'text',editable:true,editrules:{required: true}, width:58},
	                  {name:'indian',index:'indian',edittype:'text',editable:true,editrules:{required: true}, width:98},
					  {name:'deliveryDate',index:'deliveryDate',edittype:'text', width:85,editrules:{required: true},formatter: 'date', formatoptions: { newformat: 'd-m-Y'}},
                      {name:'',index:'',align: "center",editable:false,editrules:{required: true}, hidden:true,width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="change_delievery($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='Change Del Date'  \>";
						  }}, 
					{name:'preview1',index:'preview1',hidden:true,align: "center",editable:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_preview1($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='PREVIEW'  \>";
						  }},    	
						{name:'preview2',index:'preview2',hidden:true,align: "center",editable:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_preview2($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='PREVIEW'  \>";
						  }}, 
   		{name:'confirm_status',index:'confirm_status',edittype:'text',editable:true,editrules:{required: true}, width:80},
		
		{name:'planningStatus',index:'planningStatus',edittype:'text',editable:true,editrules:{required: true}, width:70},
		{name:'shipping_name',index:'shipping_name',edittype:'text',editable:true,editrules:{required: true}, width:70},
		
		{name: 'shipped_fun', index: 'shipped_fun', width:55, align: 'center',
             formatter: 'checkbox', editoptions: { value: '1:0' },
             formatoptions: { disabled: false },
             cellattr: function (rowId, tv, rawObject, cm, rdata) 
					{
                  	        return ' onclick="shipped_fun($(this))" ';
            	   
					}
		},

],          
				 height: 'auto',
	      	  rowNum:50,
		      	rowTotal: 20000000000000,
		      	rowList : [10,20,30,50,100,500,1000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager3", 
		      	sortname:'owner_id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	shrinkToFit: false,
		      	
		      	 emptyrecords: 'No records to display',
		       //  multiselect: true,
		         // multiboxonly: true,
		      	loadonce:true,
				caption:"Pending List Of Orders Details",
				footerrow: true,
                loadComplete: function () {
                
                var sumOfqnty = jQuery("#list3").jqGrid('getCol','qnty',false,'sum');
                var sumOfvalue = jQuery("#list3").jqGrid('getCol','value',false,'sum');
                var sumOfindian = jQuery("#list3").jqGrid('getCol','indian',false,'sum');
                sumOfindian = '₹ '+ (sumOfindian.toFixed(2));
                 console.log(sumOfindian);
                 //= 'Rs'.sumOfindian;
                /*var res=sumOfmaintainance_amount.toString().split(".");
                                        //Comma-fies the first part
                                         res[0] = res[0].replace(/(\d)(?=(\d\d)+\d$)/g, "$1,");
                                         var sumOfmaintainance_amount_res=res.join(".");
                                         var sumOfmaintainance_amount_res = sumOfmaintainance_amount_res+'/-';

$('#total_maintain_amount').html('Total Amount : '+sumOfmaintainance_amount_res);*/
               
                jQuery("#list3").jqGrid('footerData', 'set', { orderNo: 'Total:',  qnty: sumOfqnty, value:sumOfvalue, indian:sumOfindian});  
                
                
                },
				subGrid: true,
				
    subGridRowExpanded: function(subgrid_id, row_id) {
    // we pass two parameters
    // subgrid_id is a id of the div tag created within a table
    // the row_id is the id of the row
    // If we want to pass additional parameters to the url we can use
    // the method getRowData(row_id) - which returns associative array in type name-value
    // here we can easy construct the following
       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('marketing/pending_subgrid1');?>/s"+row_id+"/",
		
		//data:{'sub_id':123},
			  mtype : "get", 	 
			datatype: "json", 
			colNames: ['Id','orderID','Article No','Unit','Width','Sub Order Type','Shade','Description','Qty','Price','Total Value','Created By','Order Confirm','Confirm By','Shipping Status','Shipped By','Change Status','Edit','Delete'],
			colModel: [
						{name:'id',index:'id',hidden:true, width:50,editable:true},
						{name:'orderID',index:'orderID',width:50,editable:true},
						
						{name:'articleNo',index:'articleNo', width:50,height:12},
						//{name:'buyerShade',index:'buyerShade', width:80,height:12},
						{name:'unit',index:'unit', width:60,height:12},
						{name:'width',index:'width', width:50,height:12},
						{name:'subOrderType',index:'subOrderType', width:50,height:12},
						{name:'ourShade',index:'ourShade', width:70,height:12},
						{name:'description',index:'description', width:50,height:12},
						{name:'quantity',index:'quantity', width:50,height:12},
				// 		{name:'totalQuantity',index:'totalQuantity', width:50,height:12},
						{name:'unitPrice',index:'unitPrice', width:50,height:12},
						{name:'foreignValue',index:'foreignValue', width:50,height:12},
						{name:'created_by',index:'created_by', width:50,height:12},
						{name: 'orderConfirm', index: 'orderConfirm', width:80, align: 'center',
                        formatter: 'checkbox', editoptions: { value: '1:0' },
                         formatoptions: { disabled: true },
                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
								{
                              	        return ' onclick="fun($(this))" ';
                        	   
								}
							},
							{name:'confirm_by',index:'confirm_by', width:50,height:12},
							{name:'shipping_status',index:'shipping_status',width:100,height:12},
							{name:'shipped_by',index:'shipped_by',width:100,height:12},
							// {name:'rowId',index:'rowId',width:100,height:12},
							{name:'shippingstatus_edit',index:'',align: "center",editable:false,editrules:{required: true}, width:100,
							formatter:function (cellvalue, options, rowId) {    
    							// return "<input type='button' class='fa fa-eye' value='Remnant' onclick='some_function' classes='preview' \>";
								// var myGrid = $("#shipping_status");
								// var selectedRowId = myGrid.jqGrid("getGridParam", 'selrow');
								// var selectedRowData = myGrid.getRowData(selectedRowId)	
								  var ship="<select id='shipping_status"+rowId.id+"' onchange='ship1($(this))'><option>Select</option><option value='Pending'>Pending</option ><option value='Partially Shipped'>Partially Shipped</option><option value='Fully Shipped'>Fully Shipped</option>";
								  return ship;
							  }},
							{name:'edit',index:'edit',hidden:true,align: "center",editable:false,editrules:{required: true}, width:100,editable: true, formatter:vehicalFmatter,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_edit($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
									return "<input type='button'  id='edit_before_planned' value='EDIT'  \>";
						  	}},    
						  	{name:'delete',index:'delete',hidden:true,align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_delete($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
									return "<input type='button'  value='DELETE'  \>";
						  	}},

],
			
			
		  loadonce : true,
		  viewrecords: true,
		  height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc",
		
		
		  
       });
	
   }

});

$("#list3").jqGrid("setLabel", "rn", "SL");

$("#list3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list3").jqGrid('navGrid','#pager3',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		).navButtonAdd('#pager3',
 				{ 	caption:"Print", 
					buttonicon:"ui-icon-print", 
 					onClickButton:print_page,
 					position: "last", 
					title:"", 
 					cursor: "pointer",
					id:"client_delete_new"
 				} 
		);	
 		$("#list3").navButtonAdd('#pager3',
				{ 	caption:"Export", 
					buttonicon:"", 
					onClickButton: export_page_list,
					position: "last", 
					title:"", 
					cursor: "pointer",
					id:"client_delete"
				} 
		);
}

function CallGrid1()
{
		$.ajax({
            type : 'get',
			url:"<?php echo base_url('dashboard/completed_order_list_details')?>",	 
           success:function(response) {
           response=jQuery.parseJSON(response);
            console.log(response);
			jQuery('#list4').jqGrid('clearGridData');
            jQuery('#list4').jqGrid('setGridParam', {data: response});
        	jQuery('#list4').trigger('reloadGrid');

}
    	});
		jQuery("#list4").jqGrid({
			data:'',
			mtype:'get',
			datatype: "local", 
		   	colNames:['Id','Select','OSL No','File No', 'Party Order No','Qty','Order Type','Terms','Value','Currency','INR','Delivery Date','Change Del Date','Proforma Invoice','Order Confirmation','Status','Plan status','Shipped'],
   			colModel:[
		
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:50},
					  { name: 'select', label: 'select', width: 30,align: 'center',cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_radio_val($(this))" ';
	                        		},
                         formatter: function radio(cellValue, option) {
                             return '<input type="radio" name="radio_' + option.id +       '"  />';
                         } 
					  },
					  {name:'oslNo',index:'oslNo',editable:true,width:80},
					  {name:'fileNo',index:'fileNo',editable:true, width:50},
				// 	  {name:'orderMode',index:'orderMode',editable:true,editrules:{required: true},editoptions: {size:10, maxlength: 10}, width:120},
					  {name:'orderNo',index:'orderNo',edittype:'text',editable:true,editrules:{required: true}, width:100},
					  {name:'qnty',index:'qnty',edittype:'text',editable:true,editrules:{required: true}, width:50},
                      {name:'orders_Type',index:'orders_Type',edittype:'text',editable:true,editrules:{required: true}, width:70},
                      {name:'contractType',index:'contractType',edittype:'text',editable:true,editrules:{required: true}, width:105},
	                  {name:'value',index:'value',edittype:'text',editable:true,editrules:{required: true}, width:72},
	                  {name:'currency',index:'currency',edittype:'text',editable:true,editrules:{required: true}, width:58},
	                  {name:'indian',index:'indian',edittype:'text',editable:true,editrules:{required: true}, width:98},
					  {name:'deliveryDate',index:'deliveryDate',edittype:'text', width:85,editrules:{required: true},formatter: 'date', formatoptions: { newformat: 'd-m-Y'}},
                      {name:'',index:'',align: "center",editable:false,editrules:{required: true}, hidden:true,width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="change_delievery($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='Change Del Date'  \>";
						  }}, 
					{name:'preview1',index:'preview1',hidden:true,align: "center",editable:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_preview1($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='PREVIEW'  \>";
						  }},    	
						{name:'preview2',index:'preview2',hidden:true,align: "center",editable:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_preview2($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='PREVIEW'  \>";
						  }}, 
   		{name:'confirm_status',index:'confirm_status',edittype:'text',editable:true,editrules:{required: true}, width:80},
		
		{name:'planningStatus',index:'planningStatus',edittype:'text',editable:true,editrules:{required: true}, width:70},
		
		{name: 'shipped_fun', index: 'shipped_fun', width:55, align: 'center',
             formatter: 'checkbox', editoptions: { value: '1:0' },
             formatoptions: { disabled: false },
             cellattr: function (rowId, tv, rawObject, cm, rdata) 
					{
                  	        return ' onclick="shipped_fun($(this))" ';
            	   
					}
		},

],          
				 height: 'auto',
	      	  rowNum:50,
		      	rowTotal: 20000000000000,
		      	rowList : [10,20,30,50,100,500,1000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager4", 
		      	sortname:'owner_id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	shrinkToFit: false,
		      	
		      	 emptyrecords: 'No records to display',
		       //  multiselect: true,
		         // multiboxonly: true,
		      	loadonce:true,
				caption:"Completed List Of Orders Details",
				footerrow: true,
                loadComplete: function () {
                
                var sumOfqnty = jQuery("#list4").jqGrid('getCol','qnty',false,'sum');
                var sumOfvalue = jQuery("#list4").jqGrid('getCol','value',false,'sum');
                var sumOfindian = jQuery("#list4").jqGrid('getCol','indian',false,'sum');
                sumOfindian = '₹ '+ (sumOfindian.toFixed(2));
                 console.log(sumOfindian);
                 //= 'Rs'.sumOfindian;
                /*var res=sumOfmaintainance_amount.toString().split(".");
                                        //Comma-fies the first part
                                         res[0] = res[0].replace(/(\d)(?=(\d\d)+\d$)/g, "$1,");
                                         var sumOfmaintainance_amount_res=res.join(".");
                                         var sumOfmaintainance_amount_res = sumOfmaintainance_amount_res+'/-';

$('#total_maintain_amount').html('Total Amount : '+sumOfmaintainance_amount_res);*/
               
                jQuery("#list4").jqGrid('footerData', 'set', { orderNo: 'Total:',  qnty: sumOfqnty, value:sumOfvalue, indian:sumOfindian});  
                
                
                },
				subGrid: true,
				
    subGridRowExpanded: function(subgrid_id, row_id) {
    // we pass two parameters
    // subgrid_id is a id of the div tag created within a table
    // the row_id is the id of the row
    // If we want to pass additional parameters to the url we can use
    // the method getRowData(row_id) - which returns associative array in type name-value
    // here we can easy construct the following
       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('marketing/completed_subgrid1');?>/s"+row_id+"/",
		
		//data:{'sub_id':123},
			  mtype : "get", 	 
			datatype: "json", 
			colNames: ['Id','orderID','Article No','Unit','Width','Sub Order Type','Shade','Description','Qty','Price','Total Value','Created By','Order Confirm','Confirm By','Shipping Status','Shipped By','Change Status','Edit','Delete'],
			colModel: [
						{name:'id',index:'id',hidden:true, width:50,editable:true},
						{name:'orderID',index:'orderID',width:50,editable:true},
						
						{name:'articleNo',index:'articleNo', width:50,height:12},
						//{name:'buyerShade',index:'buyerShade', width:80,height:12},
						{name:'unit',index:'unit', width:60,height:12},
						{name:'width',index:'width', width:50,height:12},
						{name:'subOrderType',index:'subOrderType', width:50,height:12},
						{name:'ourShade',index:'ourShade', width:70,height:12},
						{name:'description',index:'description', width:50,height:12},
						{name:'quantity',index:'quantity', width:50,height:12},
				// 		{name:'totalQuantity',index:'totalQuantity', width:50,height:12},
						{name:'unitPrice',index:'unitPrice', width:50,height:12},
						{name:'foreignValue',index:'foreignValue', width:50,height:12},
						{name:'created_by',index:'created_by', width:50,height:12},
						{name: 'orderConfirm', index: 'orderConfirm', width:80, align: 'center',
                        formatter: 'checkbox', editoptions: { value: '1:0' },
                         formatoptions: { disabled: true },
                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
								{
                              	        return ' onclick="fun($(this))" ';
                        	   
								}
							},
							{name:'confirm_by',index:'confirm_by', width:50,height:12},
							{name:'shipping_status',index:'shipping_status',width:100,height:12},
							{name:'shipped_by',index:'shipped_by',width:100,height:12},
							// {name:'rowId',index:'rowId',width:100,height:12},
							{name:'shippingstatus_edit',index:'',align: "center",editable:false,editrules:{required: true}, width:100,
							formatter:function (cellvalue, options, rowId) {    
    							// return "<input type='button' class='fa fa-eye' value='Remnant' onclick='some_function' classes='preview' \>";
								// var myGrid = $("#shipping_status");
								// var selectedRowId = myGrid.jqGrid("getGridParam", 'selrow');
								// var selectedRowData = myGrid.getRowData(selectedRowId)	
								  var ship="<select id='shipping_status"+rowId.id+"' onchange='ship1($(this))'><option>Select</option><option value='Pending'>Pending</option ><option value='Partially Shipped'>Partially Shipped</option><option value='Fully Shipped'>Fully Shipped</option>";
								  return ship;
							  }},
							{name:'edit',index:'edit',hidden:true,align: "center",editable:false,editrules:{required: true}, width:100,editable: true, formatter:vehicalFmatter,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_edit($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
									return "<input type='button'  id='edit_before_planned' value='EDIT'  \>";
						  	}},    
						  	{name:'delete',index:'delete',hidden:true,align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_delete($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
									return "<input type='button'  value='DELETE'  \>";
						  	}},

],
			
			
		  loadonce : true,
		  viewrecords: true,
		  height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc",
		
		
		  
       });
	
   }

});

$("#list4").jqGrid("setLabel", "rn", "SL");

$("#list4").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list4").jqGrid('navGrid','#pager3',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		).navButtonAdd('#pager4',
 				{ 	caption:"Print", 
					buttonicon:"ui-icon-print", 
 					onClickButton:print_page,
 					position: "last", 
					title:"", 
 					cursor: "pointer",
					id:"client_delete_new"
 				} 
		);	
 		$("#list4").navButtonAdd('#pager4',
				{ 	caption:"Export", 
					buttonicon:"", 
					onClickButton: export_page_list,
					position: "last", 
					title:"", 
					cursor: "pointer",
					id:"client_delete"
				} 
		);
}
 		
// var lastsel2;

function export_page() {
	
	id = jQuery("#list3").jqGrid('getDataIDs');
	var type= $('#type').val();
	  var l=$('#get_months').val();
var d=$('#datepicker').val();
	$.ajax({
        type   : 'post',
    url:"<?php echo base_url('dashboard/getcurrent_month_details')?>/s"+l+"/"+d,
        data   : {id:id},
                                  
          success:function(data){
          response=jQuery.parseJSON(data);
		  
		  
		  //alert(d);
          console.log(response);
         var count =1;
         $('.export_table').empty();
		
                var content = '';
                content +='<thead><tr><th><b>SL No.</b></th><th><b>OSL #</b></th> <th><b>File No</b></th> <th><b>Mode Of Order</b></th> <th><b>Party Order No</b></th> <th><b>Quantity</b></th> <th><b>Order Type</b></th> <th><b>Value</b></th> <th><b>Currency</b></th> <th><b>INR</b></th> <th><b>Delivery Date</b></th> <th><b>Status</b></th> <th><b>Plan status</b></th></tr></thead>';
                 $.each(response,function(key,vas){

content +='<tr><td>'+count+'</td> <td>'+vas.oslNo+'</td> <td>'+vas.fileNo+'</td> <td>'+vas.orderMode+'</td> <td>'+vas.orderNo+'</td> <td>'+vas.qnty+'</td><td>'+vas.orders_Type+'</td>  <td>'+vas.value+'</td> <td>'+vas.currency+'</td> <td>'+vas.indian+'</td><td>'+vas.deliveryDate+'</td><td>'+vas.confirm_status+'</td><td>'+vas.planningStatus+'</td></tr>';
						count++;
             
                });
				 
                 $('.export_table').append(content);
                 
                  doit('xlsx');
               //  doit(type, fn, dl);
                // export_data();
				// pdf_download();
          			}
				 });
				
}

function export_page_list() {
	 id = jQuery("#list3").jqGrid('getDataIDs');
	var type= $('#type').val();
	  var l=$('#get_months').val();
var d=$('#datepicker').val();
	$.ajax({
        type   : 'post',
    url:"<?php echo base_url('dashboard/getcurrent_month_details')?>/s"+l+"/"+d,
        data   : {id:id},
                                  
          success:function(data){
          response=jQuery.parseJSON(data);
		  
		  
		  //alert(d);
          console.log(response);
         var count =1;
         
		$('.export_table').empty();
                var contents = '';
                 contents +='<thead><tr><th><b>SL No.</b></th><th><b>OSL #</b></th> <th><b>File No</b></th> <th><b>Mode Of Order</b></th> <th><b>Party Order No</b></th> <th><b>Quantity</b></th> <th><b>Order Type</b></th> <th><b>Value</b></th> <th><b>Currency</b></th> <th><b>INR</b></th> <th><b>Delivery Date</b></th> <th><b>Status</b></th> <th><b>Plan status</b></th></tr></thead>';
                 $.each(response,function(key,vas){

contents +='<tr><td>'+count+'</td> <td>'+vas.oslNo+'</td> <td>'+vas.fileNo+'</td> <td>'+vas.orderMode+'</td> <td>'+vas.orderNo+'</td> <td>'+vas.qnty+'</td><td>'+vas.orders_Type+'</td>  <td>'+vas.value+'</td> <td>'+vas.currency+'</td> <td>'+vas.indian+'</td><td>'+vas.deliveryDate+'</td><td>'+vas.confirm_status+'</td><td>'+vas.planningStatus+'</td></tr>';
						count++;
             
                });
				 
                 $('.export_table').append(contents);
                 
                 export_data();
				// pdf_download();
          			}
				 });
				
}

if (confirmMsg==true)
         {
			    $.ajax({
	        
	        url:"<?php echo base_url('marketing/add_confirmation')?>",
	        type:"POST",
	        data:{'id':id},
		                 success:function(data){
				                 if(data==""){
				                
				                    $("#editmodlist2").remove();
				                    $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
				                   
				                
				                   
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
		}
		 else if (confirmMsg==false)
         {
			    $.ajax({
	        
	        url:"<?php echo base_url('marketing/add')?>",
	        type:"POST",
	        data:{'id':id},
		                 success:function(data){
				                 if(data==""){
				                
				                    $("#editmodlist2").remove();
				                     $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
				                   
				                    
				                   
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
		}
		}
	else
	{
		
			
		swal({
			title: "You Don't Have Access For This Approval",
			text: "",
	 		});
		 $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
	}		
	}
	function editRow() {
		// Get the currently selected row

else $( "#dialogSelectRow" ).dialog();
	}
function deleteRow() {
	var v=$('#delete_id').val();
			if(v == 1)
			{			
		// Get the currently selected row
	    var row = $("#list2").jqGrid('getGridParam','selrow');
	   
	   $("#id").val(row);
	   
	    // A pop-up dialog will appear to confirm the selected action
	    if( row != null ) 
			$("#list2").jqGrid( 'delGridRow', row,
	          	{ 
							modal:true,jqModal:true,
							recreateForm: true,
				             beforeSubmit:  function(postdata,formid){
				            	
								$.ajax({
					             
									 url:"<?php echo base_url('marketing/customer_delete')?>",
					             type:"POST",
					             data:{'id':row},
					             async:false,
					             success:function(data){
					                 if(data==""){
					                  //alert('Successfully Updated.'); 
					                    $("#delmodlist2").remove();
					                   $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
					                    //$("#list2").trigger("reloadGrid");
					                 }
					                 else{
					                    // alert('Successful');
					                     $("#delmodlist2").remove();
					                    $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
						               //  $("#list2").trigger("reloadGrid"); 
					                 }
					             }
					         });
				            }, 
				           	reloadAfterSubmit:false,
	          				closeAfterDelete: true,
	          				afterSubmit : function(response, postdata) 
							{ 
				              
							}
	          	});
		 else $( "#dialogSelectRow" ).dialog();
		 }
		
	 else
	 {
		 swal({
			title: "You Don't Have Access For This Delete",
			text: "",
	 		});
	 }
	}
	
</script>

.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 type="text/javascript">

$(document).ready(function(){

$("#sites_print").click(function(){
        var divToPrint=document.getElementById("print_sites_report");
		   newWin= window.open("");
		   newWin.document.write(divToPrint.outerHTML);
		   newWin.print();
		   newWin.close();	
		 });
		    
		   $("#sites_export").click(function(){
         $(".sites_table_print").table2excel({
					exclude: ".noExl",
					name: "Excel Document Name",
					filename: "Broker List",
					fileext: ".xls",
					exclude_img: true,
					exclude_links: true,
					exclude_inputs: true
				});						   
		    });		
		  
});

</script>
<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'); ?>" />
<script>
$(function(){

$(".from_delivery_date_required_on").datepicker({

dateFormat: 'dd-mm-yy',

}).on('changeDate', function(ev){

$('.from_delivery_date_required_on').datepicker('hide');

});

});
$('.from_delivery_date_required_on').on('change', function(){
    var date = $(this).val();
    $('.to_delivery_date_required_on').datepicker({
            dateFormat: 'dd-mm-yy',
            minDate: date,
    });  
});

function fun_radio_val(rowId)
{
	    var id = rowId.closest('tr').attr('id'); 
		var as=id;
		var m=$('#ref_id').val(as);
		
}

function orders_preview()
{
		var as= $('#ref_id').val();
		//alert(as);
		if(as == 'indent')
		{
		    alert("Plese select Order#");
// 			swal({
// 				title: "Plese select Invoice",
// 				text: "",
// 			});

}
		else
		{
			var as= $('#ref_id').val();
			var v=$('#preview_id').val();
			//alert(v);
			if(v == 1)
			{
    				$.ajax({
    				type:'post',
    				url:'<?php echo base_url("marketing/orderinput"); ?>',
    				data:{'as':as},
    				async:false,
    				success:function()
    				{
    					
    					var url_r=$('#url_ref').val();
    				    
    					if(url_r == '1')
    					{
    					//	window.location.href  = '<?php echo base_url('marketing/orderinput');?>/'+ '?id='+as;
    						window.open('<?php echo base_url('marketing/orderinput');?>/'+ '?id='+as,'_blank');
    					}
    					else if(url_r == '2')
    					{
    						//window.location.href  = '<?php echo base_url('marketing/orderinput_preview');?>/'+ '?id='+as;
    						window.open('<?php echo base_url('marketing/orderinput_preview');?>/'+ '?id='+as,'_blank');
    					}
    					else if(url_r == '3')
    					{
    						//window.location.href  = '<?php echo base_url('marketing/order_input');?>/'+ '?id='+as;
    						window.open('<?php echo base_url('marketing/order_input');?>/'+ '?id='+as,'_blank');
    					}
    					else if(url_r == '4')
    					{
    						//window.location.href  = '<?php echo base_url('marketing/order_input_preview');?>/'+ '?id='+as;
    						window.open('<?php echo base_url('marketing/order_input_preview');?>/'+ '?id='+as,'_blank');
    					}
    					
    					}
    				 
    			});
			}
    	 else
    	 {
    	     alert("You Don't Have Access For This Preview");
    // 		 swal({
    // 			title: "You Don't Have Access For This Preview",
    // 			text: "",
    // 	 		});
    		}
		}	
}

$("#full").hide();
function pending(){
      $("#list3").show();
      $("#jaytab3").show();
      
      $("#list4").hide();
      $("#jaytab4").hide();
      CallGrid();
      
      var v = $('#usertype').val();
    //alert(v);
    if((v == 4) || (v == 3) || (v == 9)){
         $("#list3").hideCol("value");
         $("#list3").hideCol("currency");
         $("#list3").hideCol("indian");
         $("#list3").hideCol("contractType");
         
         $("#list4").hideCol("value");
         $("#list4").hideCol("currency");
         $("#list4").hideCol("indian");
         $("#list4").hideCol("contractType");
    }

}
function full(){
      $("#list4").show();
      $("#jaytab4").show();
      
      $("#list3").hide();
      $("#jaytab3").hide();
      CallGrid1();
      
      var v = $('#usertype').val();
//alert(v);
    if((v == 4) || (v == 3) || (v == 9)){
         $("#list3").hideCol("value");
         $("#list3").hideCol("currency");
         $("#list3").hideCol("indian");
         $("#list3").hideCol("contractType");
         
         $("#list4").hideCol("value");
         $("#list4").hideCol("currency");
         $("#list4").hideCol("indian");
         $("#list4").hideCol("contractType");
    }

}
</script>
<style type="text/css">
			
		.ss{
	padding-right: 0 !important;
	padding-left: 0 !important;
}

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;
}
.ui-jqgrid .ui-jqgrid-bdiv {
overflow:hidden;
}

.col_delete
{
	padding-left:8px !important;
    padding-right:7px !important;
	 padding-bottom: 6px !important;
}
.col_pre
{
	   display: inline;
	padding-left: 32px !important;
    padding-right: 33px !important;
	margin-top:5px !important;
	 padding-bottom: 6px !important;
}
	</style>

#jaytab1{
	width:100% !important;
	overflow-x:scroll !important;
}
.tablediv {
       overflow-x:scroll !important;
}

#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;
}
#list2
{
	//width: 1050px;
height: 0px !important;
}
#gbox_list2
{

height: auto !important;
}
#gview_list2
{

height: auto !important;
}

@media only screen and (min-width:320px) and (max-width:641px){
		.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;
				}
		}
		@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;
			}

}
		
		
#sData span, #cData span 
{
    margin-left: 3px;
}
#sData {
    height: 29px;
}
#cData {
    height: 29px;
}
#edit_list3,#search_list3,#client_delete_new
{
display:none;
}

.jqgfirstrow
	{
		    height: 0px !important;
	}
	.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>