EVOLUTION-NINJA

Edit File: out_source_grid.php

<h3 class="page-title">
Twisting Work Order Details
</h3>
<div class="page-bar">
		<ul class="page-breadcrumb">
			<li><i class="fa fa-home"></i> <a href="https://swansilk.co/dashboard/dashboard_fun">Home</a> <i
			class="fa fa-angle-right"></i> <a href="#" > Twisting </a></li>
		</ul>
	</div>

<?php if(empty($access_row))
{
}
else 
{
if($access_row->insert_id == '1') { ?>
<form action="<?php echo base_url(); ?>out_source/work_order" 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" value="<?php echo $ref; ?>" id="ref_id" >
<input type="hidden" value="<?php echo $url_val; ?>" id="url_ref" style="width: 230px;" >
	    
<div id="table_pending_indent" 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>
</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'); ?>" />

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

#refresh_list3
{
	display:none !important;
}
			</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;
	text-align: right;
padding-right: 33px !important;
padding-left: 33px !important;

}
.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td {
    overflow: hidden;
    white-space: pre;
   
	
}
	</style>

<script>
  $(document).ready(function (){
	var l=$("#ref_id").val();
		jQuery("#list2").jqGrid({
			url:"<?php echo base_url('out_source/work_order_grid_details')?>/s"+l+"/",	 
			datatype: "json", 
		  
			colNames:['Id','Work Order','Vendor Name','Process Type','Note','Req Yarn Name','Yarn Stage','Date','Delivery Date','Total Issue Wt','Rate Inr','Value Inr','WO Preview','GRN Preview','Status'],
				
			colModel:[
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
					  {name:'work_order_no',index:'work_order_no', width:100,editable:false},
					  
					  {name:'vendor_name',index:'vendor_name', width:150,editable:true,editrules:{required: true}},
					  
					  {name:'process_type',index:'process_type', width:100,editable:false},
					  {name:'sys_note',index:'sys_note', width:100,editable:false},
					  {name:'yarn_name',index:'yarn_name',width:150,editable:true,editrules:{required: true}},
					  {name:'yarn_stage',index:'yarn_stage',width:150,editable:true,editrules:{required: true}},
					  {name:'date',index:'date', editable:true,editrules:{required: true},width:70},
					  {name:'delivery_date',index:'delivery_date', editable:true,editrules:{required: true},width:70},
					  {name:'net',index:'net',editable:true,editrules:{required: true},width:70},
					  {name:'rate_inr',index:'rate_inr',editable:true,editrules:{required: true},width:70},
					  {name:'value_inr',index:'value_inr',editable:true,editrules:{required: true},width:70},
					   {name:' ',index:' ',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_preview($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
    return "<input type='button' value='PREVIEW' onclick='some_function'  \>";
						  }},
						   {name:' ',index:' ',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
									{
	                        	     return ' onclick="fun_grn_preview($(this))" ';
	                        		},formatter:function (cellvalue, options, rowObject) {    
    return "<input type='button' value='PREVIEW' onclick='some_function'  \>";
						  }},
						  {name:'quantity_approval',index:'quantity_approval',editable:true,editrules:{required: true},width:70},
					 
				 ],
						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:"Work Order 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('out_source/material_subgrid');?>/s"+row_id+"/",
		
		//data:{'sub_id':123},
			  mtype : "get", 	 
			datatype: "json", 
        colNames:['Id','Yarn Name','Yarn Denier','Yarn Specification','Gross Weight','Net Weight','Issued Gross Weight','Issued Net Weight','Balanced Gross Weight','Balanced Net Weight','Variance Kgs'],
			colModel:[
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
					   {name:'material_yarnname',index:'material_yarnname', width:150,editable:true,editrules:{required: true}},
					   {name:'material_yarndenier',index:'material_yarndenier',hidden:true, width:100,editable:true,editrules:{required: true}},
					  {name:'material_yarnspecification',index:'material_yarnspecification',hidden:true, editable:true,editrules:{required: true},width:120},
					
					{name:'material_gross_weight',index:'material_gross_weight', editable:true,editrules:{required: true},width:100},
					  {name:'material_net_weight',index:'material_net_weight', editable:true,editrules:{required: true},width:100},
					  
					  {name:'issued_gross_Weight',index:'issued_gross_Weight', editable:true,editrules:{required: true},width:120},
					  {name:'issued_net_weight',index:'issued_net_weight', editable:true,editrules:{required: true},width:120},
					  {name:'m_balanced_gross_Weight',index:'m_balanced_gross_Weight', editable:true,editrules:{required: true},width:125},
					  {name:'m_balanced_net_Weight',index:'m_balanced_net_weight', editable:true,editrules:{required: true},width:120},
					  {name:'material_variance_kgs',index:'material_variance_kgs', editable:true,editrules:{required: true},width:95,formatter: 'number',
                      formatoptions: { decimalSeparator: ".", thousandsSeparator: " ", decimalPlaces: 2, defaultValue: '0.0000' }},
					   
					],
	
			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 }
			);
 			
			}); 
function fun_preview(rowId)
		{
	 var id = rowId.closest('tr').attr('id'); 
		var as=id;
var v=$('#preview_id').val();
			if(v == 1)
			{
	$.ajax({
				type:'post',
				url:'<?php echo base_url("out_source/outsource_preview"); ?>',
				data:{'as':as},
				async:false,
				success:function()
				{
						var url_r=$('#url_ref').val();
				    
					if(url_r == '1')
					{
						window.open('<?php echo base_url('out_source/outsource_preview');?>/'+ '?id='+as);
					}
					else if(url_r == '2')
					{
						window.location.href  = '<?php echo base_url('out_source/work_order_outsource_preview');?>/'+ '?id='+as;
					}
					else if(url_r == '3')
					{
						window.location.href  = '<?php echo base_url('out_source/outsource_view');?>/'+ '?id='+as;
					}
					else if(url_r == '4')
					{
						window.location.href  = '<?php echo base_url('out_source/outsource_work_order_dyeing_preview');?>/'+ '?id='+as;
					}
				
				}
				 
			});
		}
	 else
	 {
		 swal({
			title: "You Don't Have Access For This Preview",
			text: "",
	 		});
	 }
			}

</script>

</script>
	<style>
	#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;
}

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

.jqgfirstrow
	{
		    height: 0px !important;
	}

</style>    
<style>
#list2 {
//	width: 1300px !important;
}
#pager2 {
   // width: 1300px !important;
}
#gbox_list2 {
    width: 1300px !important;
}
#gview_list2 {
    //width: 1300px !important;
}
.ui-jqgrid-hdiv {
   // width: 1300px !important;
}
.ui-jqgrid-htable {
    //width: 1300px !important;
}
.ui-jqgrid-bdiv {     
   // width: 1300px !important;
}
#gbox_list2_139_t {
    //width: 1300px !important;
}
#gview_list2_139_t {
    //width: 1300px !important;
}
@media only screen and (min-width:320px) and (min-height:640px){
	#gbox_list2{
		//width:1052px !important;
	}
	#gview_list2{
		//width:100% !important;
	}
	.ui-jqgrid-hdiv{
		//width:100% !important;
	}
	.ui-jqgrid-htable{
		//width:100% !important;
	}
	#list2{
		//width:100% !important;
	}
}
</style>