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>