EVOLUTION-NINJA

Edit File: yarn_pending.php

<?php   //include("menu.php"); 
error_reporting(E_ALL); ?>
<script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>

function planningtypes(str)
{       
	 if(str=="yarn_raw")
	  {
	
	  $('#table_yarn_raw').show();
		$('#table_yarn_twisted').hide();
		$('#table_yarn_dyed').hide();
			   
	  }
	  else if(str=="yarn_twisted")
	  { 
		$('#table_yarn_raw').hide();
		$('#table_yarn_twisted').show();
		$('#table_yarn_dyed').hide();
		
	  }
	  else if(str=="yarn_dyed")
	  {

$('#table_yarn_raw').hide();
		$('#table_yarn_twisted').hide();
		$('#table_yarn_dyed').show();
		
	  }
	  
}
</script>
<script>
function displaycustomer(str)
{
$.ajax({
  type:"post",
  url:"<?php echo base_url(); ?>display_data/testingcustomer",
  data:"id="+str,
  success:function(data) {
  document.getElementById("dynamicdatamster").innerHTML=data;
  }
  });
}
</script> 
<script>
    $(function () {
        $("#orderDate").datepicker({
            dateFormat: "d-m-yy",
            changeMonth: true,
            changeYear: true
        });
    });
  
</script>
<?php  //include("menu.php");
?>
 
 <div class="page-content-wrapper">
		<div class="page-content">
			
			
			<h3 class="page-title">
			Pending Purchased Yarns From Suppliers
			</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="#" > Yarn Stock History </a></li>
		</ul>
	</div>  
	
			 <?php $this->load->view('import_module/masters_data_display'); ?>
	<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="edit_id" class="edit_id" value="<?php echo $user_type_id;  ?>" >
	
	<div class="radio-list radio_raw" style="margin-left: 2%;">
	
	<label class="radio-inline">
	  
		  <input type="radio" checked="checked"  name="planningorder" id="planningorder"  onclick="planningtypes('yarn_raw')" />
		 Purchase-Yarn - Raw</label><span class="badge"><?php echo "   ".$yarn_raw; ?></span>
		 	<label class="radio-inline"></label>
	<label class="radio-inline">
		<input type="radio"  name="planningorder" id="planningorder"  onclick="planningtypes('yarn_twisted')" />
	   	Purchase-Yarn - Twisted </label><span class="badge"><?php echo "   ".$yarn_twisted; ?></span>
	   <label class="radio-inline"></label>
	 <label class="radio-inline">
		<input type="radio"  name="planningorder" id="planningorder"  onclick="planningtypes('yarn_dyed')" />
	   Purchase-Yarn - Dyed</label><span class="badge"><?php echo "   ".$yarn_dyed; ?></span>
	   
	
	 
 </div><br>	
						
<input type="hidden" id="checked_ids" class="checked_ids"/>
	<div id="myModall" class="modal fade" role="dialog" style="color:#000;">
		<div class="modal-dialog" style="width:80%" >
							
							    
			<div class="modal-content">
				<div class="modal-header">
					<button type="button" class="close" data-dismiss="modal">&times;</button>
					<h4 class="modal-title">Weaving Fabric Details</h4>
				</div>
				<div class="modal-body">
							     
					<fieldset>
						<div >
							<input type="hidden" id="row_id" name="row_id" >
							<div class="row">
							    <div class="col-md-8">
								    <div class="form-group">
									    <label class="control-label col-md-3">Status :</label>
									    <div class="col-md-9 ">
										    <select name="statuss" id="statuss" class="form-control statuss">
    											<option value="Select">Select</option>
    											<option value="NOT YET">NOT YET</option>
    											<option value="PARTLY">PARTLY</option>
    											<option value="COMPLETED">COMPLETED</option>
    											
										    </select>
									    </div>
								    </div>
							    </div><br/>
						    </div> 	<br/>	
							    <button  id="generate" class="btn btn-primary generate" value="Generate" style="margin-left:40% !important;" data-dismiss="modal" onclick="update_tb()">Submit</button>
							       
						</div>
				
                </div>
            </div> 
        </div>
    </div>					
	
					
<div id="table_yarn_raw" class="table-responsive">						
				<div id = "jaytab" class="jaytab">
					<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 id="table_yarn_twisted">	
				<div id = "jaytab" class="jaytab">
					<table id="list4"></table>
					<div id="pager4"></div>
					<div id="dialogSelectRow" title="Warning" style="display:none">
						<p>Please select row</p>
					</div>									
				</div>	
</div>
	
						<div id="table_yarn_dyed"> 
				<div id = "jaytab" class="jaytab">
					<table id="list5"></table>
					<div id="pager5"></div>
					<div id="dialogSelectRow" title="Warning" style="display:none">
						<p>Please select row</p>
					</div>									
				</div>	
				</div>				
			
			
			
			
	</div>
</div>
</div>

<script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script>
<link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" >			    

<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>
 
<script>
	$(document).ready(function() {
		$( "#customer" ).autocomplete({   
		source: '<?php echo base_url('request/auto_sea'); ?>',
		});
	});

</script>

</script>	
<script>
	function adddetails()
	{
		
		var customer=$("#customer").val();
		var date=$("#date").val();
		var product_type=$("#product_type").val();
		var description=$("#description").val();
		var size=$("#size").val();
       var min_quality=$("#min_quality").val();
       var customer_id=$("#customer_id").val();
       var currency= $("#currency").val();
       var article=$("#article").val();
       var design=$("#design").val();
       var price=$("#price").val();
       var image=$("#image").val();
       var reference= $("#reference").val();
       var terms=$("#terms").val();
       var quality= $("#quality").val();
       var color=$("#color").val();
       var composition=$("#composition").val();
       var note=$("#note").val();
       $.ajax({
	        
	        url:"<?php echo base_url('request/customer_insert')?>",
	        type:"POST",
	        data:{'customer':customer,'date':date,'product_type':product_type,'description':description,'size':size,'min_quality':min_quality,'customer_id':customer_id,'currency':currency,'article':article,'design':design,'price':price,'image':image,'reference':reference,'terms':terms,'quality':quality,'color':color,'composition':composition,'note':note},
		                 async:false,
		                 success:function(data){
		                   
		                   alert('Successfully Added.');
		                   	//$("#editmodlist2").remove();
		                    window.location.reload();
		                   	
		                }
		            });
	}

</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;
}

.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 !important;
}   
.ui-jqdialog .ui-jqdialog-titlebar-close span {
    display: block;
    margin: -9px !important;
}
#sData
{
	 height: 27px;
}
#cData
{
	 height: 27px;
}
#dData
{
	 height: 27px;
}
#eData
{
	 height: 27px;
}
			</style> 
			
			
			
<script>

</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('jqgrid/css/ui.jqgrid.min.css'); ?>" />
		<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap.min.css'); ?>" />
		<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap-ui.min.css'); ?>" />
    
	
    <link rel="stylesheet" type="text/css" href="<?php  echo base_url();?>assets/css/bootstrap-datepicker.min.css"/>
	<script src="<?php  echo base_url();?>assets/js/bootstrap-datepicker.min.js"></script>
	<script>
		$('.datepicker').datepicker({
			format: 'yyyy/mm/dd',
		   });

</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;
	text-align: right;
padding-right: 24px !important;
padding-left: 24px !important;

}
.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td {
    overflow: hidden;
    white-space: pre;
   
	
}
#gview_list4
{
	//width:1072px !important;
}
#gview_list5
{
	//width:1100px !important;
}
	</style>

<style>

</style> 

 
				    
	
<script>
  $(document).ready(function (){
	//var l=$("#loc").val();
	  //alert(l);
		jQuery("#list2").jqGrid({
			url:"<?php echo base_url('vendor/fabric_stock_confirmed_po_list_raw1')?>",	 
			datatype: "json", 
		   colNames:['Id','PO No','Indent','Vendor Name','Yarn Name','Required_on','Order Qty','Rec Qty','Vari Qty','Purpose/OSL#','Status','Preview'],
				
			colModel:[
    					  {name:'id',index:'id',hidden:true, width:50,editable:true},
    					  {name:'po_no',index:'po_no', width:100,editable:false},
    					  {name:'indent_no',index:'indent_no', width:95,editable:false},
    					  {name:'vendor_name',index:'vendor_name', editable:true,editrules:{required: true},width:140},
    					  {name:'product_name',index:'product_name', editable:true,editrules:{required: true},width:140},
    					  {name:'required_on',index:'required_on', width:85,editable:false},
    					  {name:'quantity',index:'quantity', width:60,editable:true,editrules:{required: true}},
    					  {name:'net_weight',index:'net_weight', width:50,editable:true,editrules:{required: true}},
    					  {name:'balanced_quantity',index:'balanced_quantity', width:50,editable:true,editrules:{required: true}},
    					  {name:'purpose',index:'purpose', width:142,editable:true,editrules:{required: true}},
    					  {name:'quantity_approval',index:'quantity_approval',editable:true,editrules:{required: true}, classes:'colCell',width:50, align: 'center',
	                         formatter: 'text', editoptions: { value: '1:0' },
	                         formatoptions: { disabled: false },
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="update_status('+rawObject.id+')" ';
	                        		}
						  },
						  {name:' ',index:' ',align: "center",editable:false,editrules:{required: true}, width:50,cellattr: function (rowId, tv, rawObject, cm, rdata) 
							{
							 return ' onclick="yarn_raw_preview('+rawObject.id+')" ';
							},formatter:function (cellvalue, options, rowObject) {    
							return "<input type='button' value='GRN' onclick='some_function'  \>";
					  }},
						  
					
				    ],
					    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:"Pending Yarn - Raw Details",
        				footerrow: true,
                        loadComplete: function () {
            				var sumOfqnty = jQuery("#list2").jqGrid('getCol','quantity',false,'sum');
            				 sumOfqnty = sumOfqnty.toFixed(2);
                            var sumOfvalue = jQuery("#list2").jqGrid('getCol','net_weight',false,'sum');
                             sumOfvalue = sumOfvalue.toFixed(2);
                            var sumOfindian = jQuery("#list2").jqGrid('getCol','balanced_quantity',false,'sum');
                            sumOfindian=sumOfindian.toFixed(2);
                            jQuery("#list2").jqGrid('footerData', 'set', { required_on: 'Total:',  quantity: sumOfqnty, net_weight:sumOfvalue, balanced_quantity:sumOfindian});
                        },
				// subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
       var subgrid_table_id;
	   swan_id=row_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('vendor/raw_yarn_goods_subgrid_details');?>/s"+row_id+"/",
					
					//data:{'sub_id':123},
						  mtype : "get", 	 
						datatype: "json", 
			            colNames:['Id','Yarn Name','Received Date','Invoice','Date','LOT','BALE','Gross Weight','Net Weight','Tare Weight','Mill','Grade','Location','Received By'],
						colModel:[
    								  {name:'id',index:'id',hidden:true, width:50,editable:true},
    								  {name:'yarnname',index:'yarnname', width:150,editable:true,editrules:{required: true}},
									  {name:'rec_date',index:'rec_date', width:90,editable:true,editrules:{required: true}},
    								  {name:'invoice',index:'invoice', width:80,editable:true,editrules:{required: true}},
    								  {name:'received_date',index:'received_date', editable:true,editrules:{required: true},width:90},
    								  {name:'lot',index:'lot', width:80,editable:true,editrules:{required: true}},
    								  {name:'bale',index:'bale', width:80,editable:true,editrules:{required: true}},
    								  {name:'gross_weight',index:'gross_weight', width:80,editable:true,editrules:{required: true}},
    								  {name:'net_weight',index:'net_weight', width:80,editable:true,editrules:{required: true}},
    								  {name:'tare_weight',index:'tare_weight', width:80,editable:true,editrules:{required: true}},
    								  {name:'mill',index:'mill', width:80,editable:true,editrules:{required: true}},
    								  {name:'grade',index:'grade', width:80,editable:true,editrules:{required: true}},
    								  {name:'consumed_at',index:'consumed_at', width:95,editable:true,editrules:{required: true}},
    								  {name:'rec_by',index:'rec_by', width:93,editable:false},
								  ],
                        		    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:true,refreshstate:"current"},
				{ },
		        { },
		        { }, 
				{
			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
			        closeOnEscape: true, 
			        	multipleSearch: true, 
			         	closeAfterSearch: true,
	 					multipleGroup:true,
						caption:"search"
	 }
		);
      
		
			$("#list2").navButtonAdd('#pager2',
					{ 	caption:"Delete", 
						buttonicon:"ui-icon-trash", 
						onClickButton: deleteRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
			);	
			
			
});
function fun(key)
	{
		// var rowid = 123;
        // var id = rowId.closest('tr').attr('id'); 
         var id = key;
		//alert(id);
		 var confirmMsg= confirm("Do You Want To Confirm!");

if (confirmMsg==true)
         {
				
			swal({
			  title: 'Remarks',
			  input: 'text',
			  showCancelButton: true,
			  confirmButtonText: 'Submit',
			  showLoaderOnConfirm: true,
			 }).then(function (email) {
				  $.ajax({
	        //alert(email);
	         url:"<?php echo base_url('vendor/purchase_order_list_yes_confirmation')?>",
	        type:"POST",
	        data:{'id':id,'remarks':email},
		 success:function(data){
				                 if(data==""){
				                    $("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
				                    $("#jaytab").trigger("reloadGrid");
				                    $("#jqGrid").trigger("reloadGrid");
				                    window.location.reload();
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
			  swal({
				type: 'success',
				// title: 'Approved By',
				// html: '' + email
			  })
			})
			
				///alert(email);
			   
		}
		 else if (confirmMsg==false)
         {
				                    $("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
		 }
	}
	function yarn_raw_preview(key)
		{
	var id=key; 
//	alert(id);
	var as=id;
	
	$.ajax({
			type:'post',
			url:'<?php echo base_url("new_stores/yarn_raw_preview"); ?>',
			data:{'id':as},
			async:false,
			success:function()
			{
				window.open('<?php echo base_url('new_stores/yarn_raw_preview');?>/'+ '?id='+as+'&&type=1');
			}
			 
		});

}
function deleteRow() {
			// Get the currently selected row
	var v=$('#delete_id').val();
			if(v == 1)
			{			
			var row = $("#list2").jqGrid('getGridParam','selrow'); 
			 $("#id").val(row);
			if( row != null ) 
				$("#list2").jqGrid('delGridRow',row,
					{	 
						modal:true,jqModal:true,
				        recreateForm: true,		        
				        beforeSubmit: function(postdata,formid){
					       
					    	 $.ajax({
					             
					             url:"<?php echo base_url('vendor/purchase_order_delete');?>",
					             type:"POST",
					            data:{'id':row},
					                 async:false,
					                 success:function(data){
					                 if(data==""){
					                   alert('Successfully Deleted');
					                     $("#delmodlist2").remove();
						                 $("#list2").trigger("reloadGrid");
										  window.location.reload();
					                  
					                 }
					                 else{
					                     alert('Successfully Deleted');
					                     $("#delmodlist2").remove();
						                 $("#list2").trigger("reloadGrid");
										  window.location.reload();
					                 }
					             }
					         });
					    },
						closeAfterEdit: true,
						reloadAfterSubmit:false,
						afterSubmit : false 
						
					});

else $( "#dialogSelectRow" ).dialog();
			}
		
	 else
	 {
		 swal({
			title: "You Don't Have Access For This Delete",
			text: "",
	 		});
	 }
		}

</script>
			
			
			
<script>
  $(document).ready(function (){

$('#table_yarn_raw').show();
		$('#table_yarn_twisted').hide();
		$('#table_yarn_dyed').hide();
	//var l=$("#loc").val();
	  //alert(l);
		jQuery("#list4").jqGrid({
			url:"<?php echo base_url('vendor/fabric_stock_confirmed_po_list_twisted1')?>",	 
			datatype: "json", 
		   colNames:['Id','PO No','Indent','Vendor Name','Yarn Name','Required_on','Shade','Order Qty','Rec Qty','Vari Qty','Purpose/OSL#','Status','Preview'],
				
			colModel:[
					  {name:'id',index:'id',hidden:true, width:50,editable:true},
					  {name:'po_no',index:'po_no', width:90,editable:false},
					  {name:'indent_no',index:'indent_no', width:90,editable:false},
					   {name:'vendor_name',index:'vendor_name', editable:true,editrules:{required: true},width:140},
					   {name:'product_name',index:'product_name', editable:true,editrules:{required: true},width:160},
					   {name:'required_on',index:'required_on', width:75,editable:false},
					   {name:'shades',index:'shades', editable:true,editrules:{required: true},width:50},
					   {name:'quantity',index:'quantity', width:60,editable:true,editrules:{required: true}},
					    {name:'net_weight',index:'net_weight', width:50,editable:true,editrules:{required: true}},
					 {name:'balanced_quantity',index:'balanced_quantity', width:50,editable:true,editrules:{required: true}},
					 {name:'purpose',index:'purpose', width:100,editable:true,editrules:{required: true}},
					 {name:'quantity_approval',index:'quantity_approval',editable:true,editrules:{required: true}, classes:'colCell',width:50, align: 'center',
	                         formatter: 'text', editoptions: { value: '1:0' },
	                         formatoptions: { disabled: false },
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="update_status('+rawObject.id+')" ';
	                        		}
						},
						{name:' ',index:' ',align: "center",editable:false,editrules:{required: true}, width:50,cellattr: function (rowId, tv, rawObject, cm, rdata) 
							{
							 return ' onclick="yar_twisted_preview('+rawObject.id+')" ';
							},formatter:function (cellvalue, options, rowObject) {    
							return "<input type='button' value='GRN' onclick='some_function'  \>";
					  }},
						
					 /* {name:'g_date',index:'g_date', width:110,editable:true,editrules:{required: true}},
					  {name:'currency',index:'currency', editable:true,editrules:{required: true},width:90},
					  {	
	                    name: 'confirm', index: 'confirm', width: 100, align: 'center',
	                         formatter: 'checkbox', editoptions: { value: '1:0' },
	                         formatoptions: { disabled: false },
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun1($(this))" ';
	                        		}
						},
						 {name:'approved_by',index:'approved_by', width:100,editable:true,editrules:{required: true}},
						 {name:'remark',index:'remark', width:90,editable:true,editrules:{required: true}},*/
						
				 ],
					height: 'auto',
		       rowNum:50,
		      	rowTotal: 200000000000000000000000000,
		      	rowList : [50,100,200,300,500,1000,5000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager4", 
		      	sortname:'id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		       	loadonce:true,
				caption:"Pending Yarn - Twisted Details",
				footerrow: true,
                        loadComplete: function () {
            				var sumOfqnty = jQuery("#list4").jqGrid('getCol','quantity',false,'sum');
            				 sumOfqnty = sumOfqnty.toFixed(2);
                            var sumOfvalue = jQuery("#list4").jqGrid('getCol','net_weight',false,'sum');
                             sumOfvalue = sumOfvalue.toFixed(2);
                            var sumOfindian = jQuery("#list4").jqGrid('getCol','balanced_quantity',false,'sum');
                            sumOfindian=sumOfindian.toFixed(2);
                            jQuery("#list4").jqGrid('footerData', 'set', { shades: 'Total:',  quantity: sumOfqnty, net_weight:sumOfvalue, balanced_quantity:sumOfindian});
                        },
				// 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('vendor/twisting_yarn_goods_details_subgrid');?>/s"+row_id+"/",
					
					//data:{'sub_id':123},
						  mtype : "get", 	 
						datatype: "json", 
			       colNames:['Id','Yarn Name','Received Date','Invoice','Date','LOT','BALE','Gross Weight','Net Weight','Tare Weight','Mill','Grade','Location','Received By'],
						colModel:[
								  {name:'id',index:'id',hidden:true, width:50,editable:true},
								  {name:'yarnname',index:'yarnname', width:170,editable:true,editrules:{required: true}},
								
								  
									 {name:'rec_date',index:'rec_date', width:90,editable:true,editrules:{required: true}},
								   {name:'invoice',index:'invoice', width:70,editable:true,editrules:{required: true}},
								  {name:'received_date',index:'received_date', editable:true,editrules:{required: true},width:90},
								  {name:'lot',index:'lot', width:60,editable:true,editrules:{required: true}},
								  {name:'bale',index:'bale', width:70,editable:true,editrules:{required: true}},
								   {name:'gross_weight',index:'gross_weight', width:80,editable:true,editrules:{required: true}},
								   {name:'net_weight',index:'net_weight', width:80,editable:true,editrules:{required: true}},
								    {name:'tare_weight',index:'tare_weight', width:80,editable:true,editrules:{required: true}},
								   {name:'mill',index:'mill', width:70,editable:true,editrules:{required: true}},
								    {name:'grade',index:'grade', width:70,editable:true,editrules:{required: true}},
								   {name:'consumed_at',index:'consumed_at', width:120,editable:true,editrules:{required: true}},
								  {name:'rec_by',index:'rec_by', width:100,editable:false},
								  
								  ],
			height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc"
       });
   }
  }); 
	//$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	jQuery("#list4").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
	 	
	$("#list4").jqGrid('navGrid','#pager4',
				{edit:false,add:false,del:false,search:true,refreshstate:"current"},
				{ },
		        { },
		        { }, 
				{
			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
			        closeOnEscape: true, 
			        	multipleSearch: true, 
			         	closeAfterSearch: true,
	 					multipleGroup:true,
						caption:"search"
	 }
		);
      
		
			$("#list4").navButtonAdd('#pager4',
					{ 	caption:"Delete", 
						buttonicon:"ui-icon-trash", 
						onClickButton: deleteRow1,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
			);	
			
			
});
function fun1(key)
	{
		// var rowid = 123;
        // var id = rowId.closest('tr').attr('id'); 
       var id=key
		//alert(id);
		 var confirmMsg= confirm("Do You Want To Confirm!");

if (confirmMsg==true)
         {
				
			swal({
			  title: 'Remarks',
			  input: 'text',
			  showCancelButton: true,
			  confirmButtonText: 'Submit',
			  showLoaderOnConfirm: true,
			 }).then(function (email) {
				  $.ajax({
	        //alert(email);
	        url:"<?php echo base_url('vendor/purchase_order_list_yes_confirmation')?>",
	        type:"POST",
	        data:{'id':id,'remarks':email},
		                 success:function(data){
				                 if(data==""){
				                
				                    $("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
				                    $("#jaytab").trigger("reloadGrid");
				                    $("#jqGrid").trigger("reloadGrid");
				                  
				              window.location.reload();
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
			  swal({
				type: 'success',
				// title: 'Approved By',
				// html: '' + email
			  })
			})
			
				///alert(email);
			   
		}
		 else if (confirmMsg==false)
         {
			    
				                
				                    $("#editmodlist4").remove();
				                    $("#list4").trigger("reloadGrid");
				 
		}
	}
	function yar_twisted_preview(key)
		{
	var id =key; 
	alert(id);
	var as=id;
	
	$.ajax({
			type:'post',
			url:'<?php echo base_url("new_stores/yarn_raw_preview"); ?>',
			data:{'id':as},
			async:false,
			success:function()
			{
				window.open('<?php echo base_url('new_stores/yarn_raw_preview');?>/'+ '?id='+as+'&&type=2');
				}
			 
		});

}
function deleteRow1() {
			// Get the currently selected row
		var v=$('#delete_id').val();
			if(v == 1)
			{		
			var row = $("#list4").jqGrid('getGridParam','selrow'); 
			 $("#id").val(row);
			if( row != null ) 
				$("#list4").jqGrid('delGridRow',row,
					{	 
						modal:true,jqModal:true,
				        recreateForm: true,		        
				        beforeSubmit: function(postdata,formid){
					       
					    	 $.ajax({
					             
					             url:"<?php echo base_url('vendor/purchase_order_delete');?>",
					             type:"POST",
					            data:{'id':row},
					                 async:false,
					                 success:function(data){
					                 if(data==""){
					                   alert('Successfully Deleted');
					                     $("#delmodlist4").remove();
						                 $("#list4").trigger("reloadGrid");
										  window.location.reload();
					                  
					                 }
					                 else{
					                     alert('Successfully Deleted');
					                     $("#delmodlist4").remove();
						                 $("#list4").trigger("reloadGrid");
										  window.location.reload();
					                 }
					             }
					         });
					    },
						closeAfterEdit: true,
						reloadAfterSubmit:false,
						afterSubmit : false 
						
					});

else $( "#dialogSelectRow" ).dialog();
				}
		
	 else
	 {
		 swal({
			title: "You Don't Have Access For This Delete",
			text: "",
	 		});
	 }
		}

</script>
			
			
			
<script>
  $(document).ready(function (){
	//var l=$("#loc").val();
	  //alert(l);
		jQuery("#list5").jqGrid({
			url:"<?php echo base_url('vendor/fabric_stock_confirmed_po_list_dyed1')?>",	 
			datatype: "json", 
		   colNames:['Id','PO No','Indent','Vendor Name','Yarn Name','Required_on','Shades','Color Code','DTL Shade','Order Qty','Rec Qty','Vari Qty','Purpose/OSL#','Status','Preview'],
				
			colModel:[
					  {name:'id',index:'id',hidden:true, width:50,editable:true,},
					  {name:'po_no',index:'po_no', width:90,editable:false},
					    {name:'indent_no',index:'indent_no', width:90,editable:false},
					   {name:'vendor_name',index:'vendor_name', editable:true,editrules:{required: true},width:148},
					   {name:'product_name',index:'product_name', editable:true,editrules:{required: true},width:148},
					   {name:'required_on',index:'required_on', width:80,editable:false},
					    {name:'shades',index:'shades', width:80,editable:true,editrules:{required: true}},
						   {name:'color_code',index:'color_code', width:80,editable:true,editrules:{required: true}},
						    {name:'yarn_dyed_shade',index:'yarn_dyed_shade', width:80,editable:true,editrules:{required: true}},
					   {name:'quantity',index:'quantity', width:60,editable:true,editrules:{required: true}},
					    {name:'net_weight',index:'net_weight', width:50,editable:true,editrules:{required: true}},
					 {name:'balanced_quantity',index:'balanced_quantity', width:50,editable:true,editrules:{required: true}},
					  {name:'purpose',index:'purpose', width:90,editable:true,editrules:{required: true}},
					  {name:'quantity_approval',index:'quantity_approval',editable:true,editrules:{required: true}, classes:'colCell',width:60, align: 'center',
	                         formatter: 'text', editoptions: { value: '1:0' },
	                         formatoptions: { disabled: false },
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="update_status('+rawObject.id+')" ';
	                        		}
						},
						
						{name:' ',index:' ',align: "center",editable:false,editrules:{required: true}, width:50,cellattr: function (rowId, tv, rawObject, cm, rdata) 
							{
							 return ' onclick="yar_dyed_preview('+rawObject.id+')" ';
							},formatter:function (cellvalue, options, rowObject) {    
							return "<input type='button' value='GRN' onclick='some_function'  \>";
					  }},
						
					  /*{name:'g_date',index:'g_date', width:100,editable:true,editrules:{required: true}},
					  {name:'currency',index:'currency', editable:true,editrules:{required: true},width:100},
					  {	
	                    name: 'confirm', index: 'confirm', width: 100, align: 'center',
	                         formatter: 'checkbox', editoptions: { value: '1:0' },
	                         formatoptions: { disabled: false },
	                         cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun2($(this))" ';
	                        		}
						},
						 {name:'approved_by',index:'approved_by', width:100,editable:true,editrules:{required: true}},
						 {name:'remark',index:'remark', width:90,editable:true,editrules:{required: true}},*/
						 
						   
				 ],
					height: 'auto',
		   rowNum:50,
		      	rowTotal: 200000000000000000000000000,
		      	rowList : [50,100,200,300,500,1000,5000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager5", 
		      	sortname:'id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		       	loadonce:true,
				caption:"Pending Yarn - Dyed Details",
				footerrow: true,
                        loadComplete: function () {
            				var sumOfqnty = jQuery("#list5").jqGrid('getCol','quantity',false,'sum');
            				sumOfqnty = sumOfqnty.toFixed(2);
                            var sumOfvalue = jQuery("#list5").jqGrid('getCol','net_weight',false,'sum');
                             sumOfvalue = sumOfvalue.toFixed(2);
                            var sumOfindian = jQuery("#list5").jqGrid('getCol','balanced_quantity',false,'sum');
                            sumOfindian=sumOfindian.toFixed(2);
                            jQuery("#list5").jqGrid('footerData', 'set', { yarn_dyed_shade: 'Total:',  quantity: sumOfqnty, net_weight:sumOfvalue, balanced_quantity:sumOfindian});
                        },
				// 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('vendor/twisting_yarn_goods_details_subgrid');?>/s"+row_id+"/",
					
					//data:{'sub_id':123},
						  mtype : "get", 	 
						datatype: "json", 
			       colNames:['Id','Yarn Name','Received Date','Invoice','Date','LOT','BALE','Gross Weight','Net Weight','Tare Weight','Mill','Grade','Location','Received By'],
						colModel:[
								  {name:'id',index:'id',hidden:true, width:50,editable:true},
								  {name:'yarnname',index:'yarnname', width:150,editable:true,editrules:{required: true}},
								
								  
									 {name:'rec_date',index:'rec_date', width:90,editable:true,editrules:{required: true}},
								   {name:'invoice',index:'invoice', width:80,editable:true,editrules:{required: true}},
								  {name:'received_date',index:'received_date', editable:true,editrules:{required: true},width:90},
								  
								  {name:'lot',index:'lot', width:80,editable:true,editrules:{required: true}},
								  {name:'bale',index:'bale', width:80,editable:true,editrules:{required: true}},
								   {name:'gross_weight',index:'gross_weight', width:80,editable:true,editrules:{required: true}},
								   {name:'net_weight',index:'net_weight', width:80,editable:true,editrules:{required: true}},
								    {name:'tare_weight',index:'tare_weight', width:80,editable:true,editrules:{required: true}},
								   {name:'mill',index:'mill', width:80,editable:true,editrules:{required: true}},
								    {name:'grade',index:'grade', width:80,editable:true,editrules:{required: true}},
								   {name:'consumed_at',index:'consumed_at', width:95,editable:true,editrules:{required: true}},
								  {name:'rec_by',index:'rec_by', width:93,editable:false},
								  
								  ],
			height: 'auto',
          rowNum:20000000,
          sortname: 'num',
          sortorder: "asc"
       });
   }
  }); 
	//$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	jQuery("#list5").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
	 	
	$("#list5").jqGrid('navGrid','#pager5',
				{edit:false,add:false,del:false,search:true,refreshstate:"current"},
				{ },
		        { },
		        { }, 
				{
			    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
			        closeOnEscape: true, 
			        	multipleSearch: true, 
			         	closeAfterSearch: true,
	 					multipleGroup:true,
						caption:"search"
	 }
		);
      
		
			$("#list5").navButtonAdd('#pager5',
					{ 	caption:"Delete", 
						buttonicon:"ui-icon-trash", 
						onClickButton: deleteRoww,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
			);	
			
			
});
function fun2(key)
	{
		// var rowid = 123;
        var id = key; 
		//alert(id);
		 var confirmMsg= confirm("Do You Want To Confirm!");

if (confirmMsg==true)
         {
				
			swal({
			  title: 'Remarks',
			  input: 'text',
			  showCancelButton: true,
			  confirmButtonText: 'Submit',
			  showLoaderOnConfirm: true,
			 }).then(function (email) {
				  $.ajax({
	        //alert(email);
	        url:"<?php echo base_url('vendor/purchase_order_list_yes_confirmation')?>",
	        type:"POST",
	        data:{'id':id,'remarks':email},
		                 success:function(data){
				                 if(data==""){
				                
				                    $("#editmodlist5").remove();
				                    $("#list5").trigger("reloadGrid");
				                    $("#jaytab").trigger("reloadGrid");
				                    $("#jqGrid").trigger("reloadGrid");
				                  
				              window.location.reload();
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
			  swal({
				type: 'success',
				// title: 'Approved By',
				// html: '' + email
			  })
			})
			
				///alert(email);
			   
		}
		 else if (confirmMsg==false)
         {
			    
				                
				                    $("#editmodlist5").remove();
				                    $("#list5").trigger("reloadGrid");
				 
		}
	}
	function yar_dyed_preview(key)
		{
	var id = key; 
//	alert(id);
	var as=id;
	
	$.ajax({
			type:'post',
			url:'<?php echo base_url("new_stores/yarn_raw_preview"); ?>',
			data:{'id':as},
			async:false,
			success:function()
			{
				window.open('<?php echo base_url('new_stores/yarn_raw_preview');?>/'+ '?id='+as+'&&type=3');
				}
			 
		});

}
function deleteRoww() {
			// Get the currently selected row
			var v=$('#delete_id').val();
			if(v == 1)
			{	
			var row = $("#list5").jqGrid('getGridParam','selrow'); 
			 $("#id").val(row);
			if( row != null ) 
				$("#list5").jqGrid('delGridRow',row,
					{	 
						modal:true,jqModal:true,
				        recreateForm: true,		        
				        beforeSubmit: function(postdata,formid){
					       
					    	 $.ajax({
					             
					             url:"<?php echo base_url('vendor/purchase_order_delete');?>",
					             type:"POST",
					            data:{'id':row},
					                 async:false,
					                 success:function(data){
					                 if(data==""){
					                   alert('Successfully Deleted');
					                     $("#delmodlist5").remove();
						                 $("#list5").trigger("reloadGrid");
										  window.location.reload();
					                  
					                 }
					                 else{
					                     alert('Successfully Deleted');
					                     $("#delmodlist5").remove();
						                 $("#list5").trigger("reloadGrid");
										  window.location.reload();
					                 }
					             }
					         });
					    },
						closeAfterEdit: true,
						reloadAfterSubmit:false,
						afterSubmit : false 
						
					});

else $( "#dialogSelectRow" ).dialog();
				}
		
	 else
	 {
		 swal({
			title: "You Don't Have Access For This Delete",
			text: "",
	 		});
	 }
		}

</script>

</script>
<script>
	var form = document.getElementById('formID'); // form has to have ID: <form id="formID">
	form.noValidate = true;
	form.addEventListener('submit', function(event) { // listen for form submitting
	        if (!event.target.checkValidity()) {
	            event.preventDefault(); // dismiss the default functionality
	            alert('Please, fill the form'); // error message
	        }
	    }, false);
	
	</script>
<script>
$(document).ready(function(){	
	   $('#min_quality').on('change keyup', function() {
		  var sanitized = $(this).val().replace(/[^0-9]/g, '');
		  $(this).val(sanitized);
		});
	});		
	$(document).ready(function(){	
				   $('#customer').on('change keyup', function() {
					  var sanitized = $(this).val().replace(/[^a-zA-Z -]+$/,'');
					  $(this).val(sanitized);
					});
				});	
</script> 	
	<style>
	#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:18px !important;
}

@media only screen and (min-width:320px) and (max-width:641px){
			.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;
			}
			
			#editmodlist2
			{
				width:90% !important;
			}
			#sData span, #cData span {
				margin-left: 0 !important;
	                }
                        .radio_raw {
                                margin-left:5% !important;
                        }
		}
		@media only screen and (min-width:642px) 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;
			}

}
		.tablediv
{

text-transform: uppercase !important;

}
.ui-jqgrid tr.jqgrow td{ 
text-transform: uppercase !important;
}
#search_list4
{
	display:none !important;
}
#refresh_list4
{
	display:none !important;
}
#search_list5
{
	display:none !important;
}
#refresh_list5
{
	display:none !important;
}
.ui-jqgrid-titlebar {
        //width:1253px;
}
@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;
}
}

#jaytab {
    overflow-x:scroll;
}
#list2 {
	width: 1300px !important;
}
#pager2 {
    width: 1300px !important;
}
#gbox_list2 {
    width: 1300px !important;
}
#gview_list2 {
    width: 1300px !important;
}
#list4 {
	width: 1300px !important;
}
#pager4 {
    width: 1300px !important;
}
#gbox_list4 {
    width: 1300px !important;
}
#gview_list4 {
    width: 1300px !important;
}

#list5 {
	width: 1300px !important;
}
#pager5 {
    width: 1300px !important;
}
#gbox_list5 {
    width: 1300px !important;
}
#gview_list5 {
    width: 1300px !important;
}

.ui-jqgrid-hdiv {
    width: 1300px !important;
}
.ui-jqgrid-htable {
    width: 1300px !important;
}
.ui-jqgrid-bdiv {     
    width: 1300px !important;
}
</style>    
	
<script>
function remove()
{
	var customer=$("#customer").val('');
	var date=$("#date").val('');
	var product_type=$("#product_type").val('');
	var description=$("#description").val('');
	var size=$("#size").val('');
   var min_quality=$("#min_quality").val('');
   var customer_id=$("#customer_id").val('');
   var currency= $("#currency").val('');
   var article=$("#article").val('');
   var design=$("#design").val('');
   var price=$("#price").val('');
   var image=$("#image").val('');
   var reference= $("#reference").val('');
   var terms=$("#terms").val('');
   var quality= $("#quality").val('');
   var color=$("#color").val('');
   var composition=$("#composition").val('');
   var note=$("#note").val('');
}
</script>