EVOLUTION-NINJA

Edit File: po_genereted_list.php

<?php echo view('includes/header');?>
<link href="<?php echo base_url('public/assets/admin_dashboard/css/jquery-ui.css');?>" rel="stylesheet">
<script src="<?php echo base_url('public/assets/js/jquery-ui.js');?>"></script>
<script src="<?php echo base_url('public/assets/admin_dashboard/js/jquery.table2excel.js');?>"></script>

<section class="content-header">
	<h1>Work Order List</h1>
</section>

<div class="form-group col-sm-12 col-md-4">
								<label class="col-sm-4 ">Project</label>
								<select class="form-control col-sm-8 project_list" name="project" id="sel1">
									<option value="all">Select</option>
									<?php 
									foreach($project as $val)
									{
									?>
										<option value="<?php echo $val->project_name;?>"><?php echo $val->project_name;?></option>
									<?php
									}
									?>
								</select>
							</div>
							
								<div class="form-group col-sm-12 col-md-4">
									<label class="col-sm-4 col-xs-4">WO NO</label>
									<select class="form-control col-sm-5 po_no" name="po_no" id="sel1">
									
									
									</select>
								</div>
								
								<div class="form-group col-sm-12 col-md-4">
									<label class="col-sm-4 ">From date</label>
									<input type="text" class="form-control col-sm-8 from_date_picker bg_from" id="po_from" name="from_date">
								</div>
					</div>
								
						<div class="row land_owner_a">		
					 		<div class="form-group col-sm-12 col-md-4">
								<label class="col-sm-4">To date</label>
								<input type="text" class="form-control col-sm-5 to_date_picker bg_to" id="po_to" name="to_date">
							</div>										
						</div>

<div class="row land_owner_a">	
								<div class="form-group col-sm-12 col-md-4">
									<label class="col-sm-4"></label>
									<button type="submit" id="booking_submit" style="margin-top: 0px !important;" class="btn btn-primary center-block submit">Submit</button>
								</div>
						</div>

</form>
		</div>	
			<div id="total_div"></div>	
			
		<div id="menu1" class="tab-pane col-sm-12 col-md-12 ">
    
			<div id="jaytab1" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid1">
				<div class="grid_div1"></div><table id="list1"></table>
				  <div id="pager1"></div>
				 <div id="dialogSelectRow1" title="Warning" style="display:none">
				 <p>Please select row</p>
			  </div>
			</div>

</div>
		
		<div id="menu1" class="tab-pane col-sm-12 col-md-12 ">
    
			<div id="jaytab3" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid">
				<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>
  	<div style="display:none;"><table  border="1" style="border-spacing: 0px !important;" id="export_table" class="export_table"></table></div>

</div>
</section>
    
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	    
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" />
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" />
						
		<script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script>
<style type="text/css">
			
				.form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus {
				  border-color: #FF0000;
				  box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6);
				}
				#FrmGrid_list2
				{
					width: 100% !important;
				}
				.ui-jqdialog .ui-jqdialog-titlebar
				{
					height: 29px !important;
					background-color: #001a00;
					color: white;
					padding-left: 10px;
				}
				.fm-button
				{
					height: 21px !important;
					padding: 1px;					
					margin-right: 10px !important;
					height: 21px !important;				    
				    width: 50%;
				    margin-top: -7px !important;
				}
				.ui-jqdialog-content td.navButton {
					padding-top: 12px !important;
				}
				.ui-jqgrid .ui-jqgrid-titlebar
				{
					height: 27px !important;
					background:#AF0100 !important;
					color:white !important;
				}
				.ui-jqgrid-bdiv
				{
					//height: 232px !important;
					height: auto !important;
				}
				.ui-widget-overlay
				{
					z-index:0 !important;
				}
				.ui-widget-header
				{
				background: #1e7ad7 !important;
				}
				.ui-jqgrid-hdiv ui-state-default
				{
				width: 873px !important; cursor: default!important
				}
				ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight 
				{
				border: 1px solid #fed22f;
				background: #ffe45c;
			   }
			   .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default
			   {
					font-weight: bold;
					color: black;
				}
			.ui-jqgrid .ui-jqgrid-bdiv {
				overflow-y: scroll;
				//overflow-x: hidden;
				}
				
				
			</style>
<style type="text/css">
.calendar-table thead{
background: #fff !important;
color:#777 !important;
}
#print_booking_report{
	display:none;
}

#print_enquiry_report{
	display:none;
}

#print_associate_report{
	display:none;
}

#print_cancellation_report{
	display:none;
}

#booking_contacts_export{
	display:none;
}

#booking_email_export
{
	display:none;
}

#cancellation_contacts_export{
	display:none;
}

#cancellation_email_export{
	display:none;
}

#associate_contacts_export{
	display:none;
}

#associate_email_export{
	display:none;
}

#enquiry_contacts_export{
	display:none;
}

#enquiry_email_export{
	display:none;
}

#print_payment_report{
	display:none;
}
#payment_contacts_export{
	display:none;
}
#payment_email_export{
	display:none;	
}
#print_client_report{
	display:none;
}
#print_sites_report{
	display:none;
}
#print_loans_report{
	display:none;
}
#print_reception_report{
	display:none;
}
#myTab li.active a{
	background:#af0100;
	color:white;
}

</style>

dateFormat: 'dd-mm-yy',

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

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

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

changeMonth:true,
		changeYear:true,
	    yearRange: "2000:c",
	    //dateFormat: 'yy-mm-dd' 
	    dateFormat: 'dd-mm-yy'

});
$(document).ready(function(){

$('.wo_form_project_wise')[0].reset();

height: 'auto',
				rowNum:20,
				sortname: 'num',
				sortorder: "asc"
       });
   }
});

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

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

$("#list1").jqGrid('navGrid','#pager1',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	closeOnEscape: true, closeAfterSearch: true, ignoreCase: true, multipleSearch: false, multipleGroup: false, showQuery: false,
        sopt: ['cn', 'eq', 'ne'],
        defaultSearch: 'cn'
    }).navButtonAdd('#pager1',
 				{ 	caption:"Print", 
					buttonicon:"ui-icon-print", 
 					onClickButton:print_page,
 					position: "last", 
					title:"", 
 					cursor: "pointer",
					id:"client_delete_new"
 				} 
		);	
 		$("#list1").navButtonAdd('#pager1',
				{ 	caption:"Export", 
					buttonicon:"", 
					onClickButton: export_page,
					position: "last", 
					title:"", 
					cursor: "pointer",
					id:"client_delete"
				}

);

$("#list1").navButtonAdd('#pager1',
					{ 	caption:"Edit", 
						buttonicon:"ui-icon-pencil", 
						onClickButton: editRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_edit"
					} 
			);		
			$("#list1").navButtonAdd('#pager1',
					{ 	caption:"Delete", 
						buttonicon:"ui-icon-trash", 
						onClickButton: deleteRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
			);

});

function fun_edit(rowId)
{
 var id = rowId.closest('tr').attr('id'); 
 window.location.href = "<?php echo site_url('edit-work-order-po');?>?id="+id;
}

function fun_view(rowId)
{
 var id = rowId.closest('tr').attr('id'); 
 window.location.href = "<?php echo site_url('view-work-order-wo');?>?id="+id;
}

function genarate_po() {
	id = jQuery("#list3").jqGrid('getGridParam','selarrrow');
	var row = $("#list3").jqGrid('getGridParam','selrow'); 
	if(row != null )
	{
		window.location.href = "<?php echo site_url('generate-po');?>?id="+id;
	}
	else $( "#dialogSelectRow3" ).dialog();

}

function fun_cancel1(rowId)
{
	
	 var id = rowId.closest('tr').attr('id');
	 var app = $("#list1").jqGrid('getRowData',id);
	 app=app.cancel_status;
	if(app=="CANCEL")
	{
	swal({

title: "Are you sure?",
        text: "Do you want to cancel this WO?",
        type: "warning",   showCancelButton: true,
        confirmButtonColor: "#DD6B55",
        confirmButtonText: "Yes,proceed!",
        cancelButtonText: "No, cancel plz!",
        closeOnConfirm: false,
        closeOnCancel: false 
        },

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
            $(".sweet-overlay").hide();
//             test.attr('disabled', 'disabled');
//             test.text("Updating...");
                $.ajax({          
                        type   : 'post',
                        url    : '<?php echo site_url("cancel-wo")?>',
                        data   : {management_id:id},

success:function(response) {
                        // response=jQuery.parseJSON(response);
								console.log(response);

if(response.result == 1) 
                            {
                               toastr["success"](response.message);
                               location.reload();
                            }
                        }
                    });

} 
                        else {

$(".sweet-alert").hide();
                        $(".sweet-overlay").hide();
                    }

});
	}
	else
	{
		swal({

title: "Are you sure?",
            text: "Do you want to uncancel this WO?",
            type: "warning",   showCancelButton: true,
            confirmButtonColor: "#DD6B55",
            confirmButtonText: "Yes,proceed!",
            cancelButtonText: "No, cancel plz!",
            closeOnConfirm: false,
            closeOnCancel: false 
            },

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
                $(".sweet-overlay").hide();
//                 test.attr('disabled', 'disabled');
//                 test.text("Updating...");
                    $.ajax({          
                            type   : 'post',
                            url    : '<?php echo site_url("cancelled-wo")?>',
                            data   : {management_id:id},

success:function(response) {
                            // response=jQuery.parseJSON(response);
									console.log(response);

if(response.result == 1) 
                                {
                                   toastr["success"](response.message);
                                   location.reload();
                                }
                            }
                        });

} 
                            else {

$(".sweet-alert").hide();
                            $(".sweet-overlay").hide();
                        }

});
	}
}

function fun_cancel(rowId)
{
	
	 var id = rowId.closest('tr').attr('id');
	 var app = $("#list3").jqGrid('getRowData',id);
	 app=app.cancel_status;
	if(app=="CANCEL")
	{
	swal({

function(isConfirm){

if (isConfirm) {

success:function(response) {
                        // response=jQuery.parseJSON(response);
								console.log(response);

} 
                        else {

$(".sweet-alert").hide();
                        $(".sweet-overlay").hide();
                    }

});
	}
	else
	{
		swal({

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
                $(".sweet-overlay").hide();
//                 test.attr('disabled', 'disabled');
//                 test.text("Updating...");
                    $.ajax({          
                            type   : 'post',
                            url    : '<?php echo site_url("cancelled-wo")?>',
                            data   : {management_id:id},

success:function(response) {
                            // response=jQuery.parseJSON(response);
									console.log(response);

if(response.result == 1) 
                                {
                                   toastr["success"](response.message);
                                   location.reload();
                                }
                            }
                        });

} 
                            else {

$(".sweet-alert").hide();
                            $(".sweet-overlay").hide();
                        }

});
	}
}

function send_wo_mail(rowId)
{
	 // alert();
	 var id = rowId.closest('tr').attr('id');
	//alert(id);
	
	 $.ajax({

type   : 'post',
        url    : '<?php echo site_url("gss/send_email")?>',
        data   : {'id':id},
		 async:false,
		
		 success:function()
		 {
			 // alert('success');
		 }
		
	  });
	 
}

function export_page() {
	$('.export_table').empty();
		id = jQuery("#list3").jqGrid('getDataIDs');

var from= $("#po_from").val();

var to= $("#po_to").val();

var project=$('select[name=project]').val();

var po_no=$('select[name=po_no]').val();
		$.ajax({
		url:"<?php echo base_url('export_print_work_order');?>?from="+from+"&to="+to+"&project="+project+"&po_no="+po_no,
	    type : "GET", 	
        data   : {id:id},
                                  
          success:function(response){
        //   response=jQuery.parseJSON(data);
          console.log(response);
          var count =1;
         
                var content = '';
                content +='<thead><tr><th>Sl No</th><th>WO NO</th><th>Vendor Name</th><th>Date</th><th>Project</th><th>Grand Total</th></tr></thead>';
                 $.each(response,function(key,va){

//$.each(vas,function(key,va){
                	
                		content +='<tr><td>'+count+'</td><td>'+va.po_no+'</td><td>'+va.vendor+'</td><td>'+va.date+'</td><td>'+va.project_name+'</td><td>'+va.grand_total+'</td></tr>';
        				count++;
               // });
                });
                 $('.export_table').append(content);
                 export_data();
          			}
				 });
				
				}

function export_data(){
		$("#export_table").table2excel({
		exclude: ".noExl",
		name: "Excel Document Name",
		filename: "WO List",
		fileext: ".xls",
		exclude_img: true,
		exclude_links: true,
		exclude_inputs: true
		});						   
		}

function print_page() {
			id = jQuery("#list3").jqGrid('getDataIDs');
			var from= $("#po_from").val();

var to= $("#po_to").val();
	
			var project=$('select[name=project]').val();
	
			var po_no=$('select[name=po_no]').val();
		
		$.ajax({
			url:"<?php echo base_url('export_print_work_order');?>?from="+from+"&to="+to+"&project="+project+"&po_no="+po_no,
			type : "GET", 	
			data   : {id:id},
                                  
			  success:function(response){
			 // response=jQuery.parseJSON(data);
			 // console.log(response);
			  var count =1;
              var content = '';
                content +='<thead><tr><th>Sl No</th><th>Vendor Name</th><th>WO NO</th><th>Date</th><th>Project</th><th>Grand Total</th></tr></thead>';
                 $.each(response,function(key,va){

content +='<tr><td>'+count+'</td><td>'+va.vendor+'</td><td>'+va.po_no+'</td><td>'+va.date+'</td><td>'+va.project_name+'</td><td>'+va.grand_total+'</td></tr>';
        				count++;

});
	          
	                 $('.print_table').append(content);
					print_page1();
	          		}
				});
			}

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();
			}

$(".project_list").change(function(){

var project = $('.project_list :selected').val();
		
		//CallAjax(project_id);
		Sites(project);

});
		function Sites(project){

$.ajax({
                type   : 'post',
                url    : '<?php echo site_url("single-project-wo")?>',
                data   : {project:project},
                                          
                  success:function(response){
                //   response=jQuery.parseJSON(response);
                //   console.log(response);

if(response.result==1)
                    {
                    	var options = '';

options += '<option value="all">All</option>';

$.each(response.wo_no,function(idx,vx){

options += '<option value="'+vx.po_no+'">'+vx.po_no+'</option>';
                    	});

$(".po_no").html(options);

$(".po_no").change(function(){
 
                    		var projectid   = $(".project_list :selected").val();
                    		var site_number = $(this).val();
							// alert(site_number);
							
							 // $.ajax({
									 // type   : 'post',
									 // url    : '<?php echo site_url("single-follow-up-project-details")?>',
									 // data   : {site_number:site_number},
															  
									   // success:function(response){
										  
									  // }

});

}   
                	else
                	{
                		$(".sites_list").empty();  
                	}
                }             
         });	
	}	
	
$('.wo_form_date_wise').submit(function(e){    
    e.preventDefault();
		
			$('#jaytab1').hide();
		
			var from= $("#po_from").val();
		
			var to= $("#po_to").val();
	
			var project=$('select[name=project]').val();
	
			var po_no=$('select[name=po_no]').val();
	
      	  jQuery("#list3").jqGrid({
		
	 	url:"<?php echo site_url('work_order_date_wise')?>?from="+from+"&to="+to,	 
		 mtype : "post", 	 
		datatype: "json", 
		colNames:['SI','Vendor','PO NO','Date','Currency','Vendor Address','CANCEL','EDIT','VIEW','MAIL'],
		colModel:[
					{name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
					{name:'vendor',index:'vendor', width:150, editable:false},
					{name:'po_no',index:'po_no', width:150,editable:false},
					{name:'date',index:'date', width:150, editable:false},
					{name:'currency',index:'currency', width:150, editable:false},
					{name:'vendor_address',index:'vendor_address', width:150, editable:false},
					{name:'cancel_status',index:'cancel_status',classes:'agr_appr',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
		        	     return ' onclick="fun_cancel($(this))" ';
					
				}},	
										
					{name:'edit',index:'edit',align: "center",editable:false,search:false,editrules:{required: true}, width:90,cellattr: function (rowId, tv, rawObject, cm, rdata) 
					      {
					                      return ' onclick="fun_edit($(this))" ';
					                  },formatter:function (cellvalue, options, rowObject) {    
					      return "<input type='button'  value='EDIT'  \>";
					     }},
					     {name:'view',index:'view',align: "center",editable:false,search:false,editrules:{required: true}, width:90,cellattr: function (rowId, tv, rawObject, cm, rdata) 
					      {
					                      return ' onclick="fun_view($(this))" ';
					                  },formatter:function (cellvalue, options, rowObject) {    
					      return "<input type='button'  value='VIEW'  \>";
					     }},
						  {name:'po_mail',index:'po_mail',align: "center",editable:false,search:false,editrules:{required: true}, width:90,cellattr: function (rowId, tv, rawObject, cm, rdata) 
					      {
					                      return ' onclick="send_po_mail($(this))" ';
					                  },formatter:function (cellvalue, options, rowObject) {    
					      return "<input type='button'  value='SEND'  \>";
					     }},
					     
	      	    ],
	      	  rowNum:20,
		      	rowTotal: 2000,
		      	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:"WO generated List",
			
		subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
         var subgrid_table_id;
		 //alert(row_id);
		id=row_id;
		 //alert(id);
		subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
       jQuery("#"+subgrid_table_id).jqGrid({	
		//alert(id);
		url:"<?php echo site_url('wo_subgrid');?>?id="+id,	   
		 mtype : "get", 	 
			datatype: "json", 
	    colNames:['SI','Product Name','Description','Indent','Project','Purpose','Quantity','Unit Price','Value','SGST','CGST','IGST','Total Value'],
	    colModel:[
					 {name:'id',index:'id', width:50, hidden:true,editable:false,key:true},
					{name:'product_name',index:'product_name', width:100, editable:false},
					{name:'description',index:'description', width:150, editable:false},
					{name:'indent',index:'indent', width:100, editable:false},
					{name:'project_name',index:'project_name', width:150, editable:false},
					{name:'purpose_no',index:'purpose_no', width:100, editable:false},
					{name:'quentity',index:'quentity', width:70, editable:false},
					{name:'unit_price',index:'unit_price', width:70, editable:false},
					{name:'inr_value',index:'inr_value', width:70, editable:false},
					{name:'sgst',index:'sgst', width:70, editable:false},
					{name:'cgst',index:'cgst', width:70,editable:false},
					{name:'igst',index:'igst', width:70, editable:false},
					{name:'total_value',index:'total_value', width:100, editable:false},
					
				],

height: 'auto',
				rowNum:20,
				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"},
			{ },
	        { },
	        { }, 
			{
		    	closeOnEscape: true, closeAfterSearch: true, ignoreCase: true, multipleSearch: false, multipleGroup: false, showQuery: false,
        sopt: ['cn', 'eq', 'ne'],
        defaultSearch: 'cn'
    }).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,
					position: "last", 
					title:"", 
					cursor: "pointer",
					id:"client_delete"
				}

);

$("#list3").navButtonAdd('#pager3',
					{ 	caption:"Edit", 
						buttonicon:"ui-icon-pencil", 
						onClickButton: editRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_edit"
					} 
			);		
			$("#list3").navButtonAdd('#pager3',
					{ 	caption:"Delete", 
						buttonicon:"ui-icon-trash", 
						onClickButton: deleteRow,
						position: "last", 
						title:"", 
						cursor: "pointer",
						id:"client_delete"
					} 
			);

});

$('.wo_form_project_wise').submit(function(e){    
    e.preventDefault();
		
			$('#jaytab1').hide();
		
			var from= $("#po_from").val();
		
			var to= $("#po_to").val();
	
			var project=$('select[name=project]').val();
	
			var po_no=$('select[name=po_no]').val();
	
      	  jQuery("#list3").jqGrid({
		
	 	url:"<?php echo site_url('work_order_project_wise')?>?from="+from+"&to="+to+"&project="+project+"&po_no="+po_no,	 
		 mtype : "post", 	 
		datatype: "json", 
		colNames:['SI','Vendor','PO NO','Date','Currency','Vendor Address','CANCEL','EDIT','VIEW','MAIL'],
		colModel:[
					{name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
					{name:'vendor',index:'vendor', width:150, editable:false},
					{name:'po_no',index:'po_no', width:150,editable:false},
					{name:'date',index:'date', width:150, editable:false},
					{name:'currency',index:'currency', width:150, editable:false},
					{name:'vendor_address',index:'vendor_address', width:150, editable:false},
					{name:'cancel_status',index:'cancel_status',classes:'agr_appr',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
		        	     return ' onclick="fun_cancel($(this))" ';
					
				}},	
										
					{name:'edit',index:'edit',align: "center",editable:false,search:false,editrules:{required: true}, width:90,cellattr: function (rowId, tv, rawObject, cm, rdata) 
					      {
					                      return ' onclick="fun_edit($(this))" ';
					                  },formatter:function (cellvalue, options, rowObject) {    
					      return "<input type='button'  value='EDIT'  \>";
					     }},
					     {name:'view',index:'view',align: "center",editable:false,search:false,editrules:{required: true}, width:90,cellattr: function (rowId, tv, rawObject, cm, rdata) 
					      {
					                      return ' onclick="fun_view($(this))" ';
					                  },formatter:function (cellvalue, options, rowObject) {    
					      return "<input type='button'  value='VIEW'  \>";
					     }},
						  {name:'po_mail',index:'po_mail',align: "center",editable:false,search:false,editrules:{required: true}, width:90,cellattr: function (rowId, tv, rawObject, cm, rdata) 
					      {
					                      return ' onclick="send_po_mail($(this))" ';
					                  },formatter:function (cellvalue, options, rowObject) {    
					      return "<input type='button'  value='SEND'  \>";
					     }},
					     
	      	    ],
	      	  rowNum:20,
		      	rowTotal: 2000,
		      	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:"WO generated List",
			
		subGrid: true,
    subGridRowExpanded: function(subgrid_id, row_id) {
         var subgrid_table_id;
		 //alert(row_id);
		id=row_id;
		 //alert(id);
		subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
       jQuery("#"+subgrid_table_id).jqGrid({	
		//alert(id);
		url:"<?php echo site_url('wo_subgrid');?>?id="+id,	   
		 mtype : "get", 	 
			datatype: "json", 
	    colNames:['SI','Product Name','Description','Indent','Project','Purpose','Quantity','Unit Price','Value','SGST','CGST','IGST','Total Value'],
	    colModel:[
					 {name:'id',index:'id', width:50, hidden:true,editable:false,key:true},
					{name:'product_name',index:'product_name', width:100, editable:false},
					{name:'description',index:'description', width:150, editable:false},
					{name:'indent',index:'indent', width:100, editable:false},
					{name:'project_name',index:'project_name', width:150, editable:false},
					{name:'purpose_no',index:'purpose_no', width:100, editable:false},
					{name:'quentity',index:'quentity', width:70, editable:false},
					{name:'unit_price',index:'unit_price', width:70, editable:false},
					{name:'inr_value',index:'inr_value', width:70, editable:false},
					{name:'sgst',index:'sgst', width:70, editable:false},
					{name:'cgst',index:'cgst', width:70,editable:false},
					{name:'igst',index:'igst', width:70, editable:false},
					{name:'total_value',index:'total_value', width:100, editable:false},
					
				],

height: 'auto',
				rowNum:20,
				sortname: 'num',
				sortorder: "asc"
       });
   }
});

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

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

);

});
</script>

.scroll 
{
	height:12px !important;
}
#gbox_list6_251_t
{
	height:auto !important;
}

#list6
{
	width: 1050px;
height: 0px !important;
}
#gbox_list6
{

height: auto !important;
}
#gview_list6
{

height: auto !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;
			}
			
			#editmodlist6
			{
				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>   
<?php echo view('includes/footer');?>