EVOLUTION-NINJA

Edit File: outstanding_statements_display.php

<div class="content-wrapper">
	<div class="middle_work_hedding">
		<div class="container-fluid">
			<h3><em>Outstanding Statements</em></h3>
			<div id = "jaytab" style="width: 100%;">
	            <p>Last Updated Time and date is : <?php  if(empty($time)) {  echo "Data not found"; }else{ echo $time->createdate;  }  ?></p>
				<table id="list2"></table>
				<div id="pager2"></div>
			
				<div id="dialogSelectRow" title="Warning" style="display:none">
					<p>Please select row</p>
				</div>									
			</div>
			<div class="row" style="padding-bottom:20px;"></div>
		</div>
	</div>

</div>
<script>
$(document).ready(function (){
	jQuery("#list2").jqGrid({
		url:"<?php echo site_url('controller/outstanding_display_insert');?>",
		mtype : "post",
		datatype: "json", 
		 colNames:['SI','Partner Code','Partner Name', 'Invoice Number','Invoice ref. No','Invoice Date','Invoice Value (INR)','Due Date'],
			colModel:[
                   {name:'id',index:'id',hidden:true, width:150,editable:true,editoptions:{size:25}},
		      	   {name:'partner_code',index:'partner_code', width:150,editable:true,editoptions:{size:25}},
		      	   {name:'partner_name',index:'partner_name', width:150,editable:true,editoptions:{size:25}},
		      	   {name:'invoice_number',index:'invoice_number', width:150,editable:true,editrules:{required:true},editoptions:{size:25}},
		      	   {name:'invoice_ref_no',index:'invoice_ref_no', width:150,editable:true,editoptions:{size:50}},
		      	   {name:'invoicedate',index:'invoicedate', width:150,editable:true,editoptions:{size:25}},
		      	   {name:'invoice_value',index:'invoice_value', width:150,editable:true,editoptions:{size:25}},
		      	   {name:'due_date',index:'due_date', width:150,editable:true,editoptions:{size:25}},
		      	    ],
		rowNum:50,
        rowTotal: 2000,
        rowList : [50,100,500,1000],
		rownumbers: true,
        rownumWidth: 40,
		pager:"#pager2", 
		sortname:'id', 
		viewrecords: true,
		loadonce:true,
		gridview: true,
		autowidth: true,
		sortorder:"desc", 
		caption:"Outstanding Statement"
		}); 
   $("#list2").jqGrid('filterToolbar',{searchOperators : false});//for multisearch code,remove if not required

$("#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"
	 }
	);
});
</script>