EVOLUTION-NINJA
Edit File: po_view.php
<?php $this->load->view('includes/admin_dashboard_header');?> <div id="wrapper"> <!-- Navigation --> <?php $this->load->view('includes/admin_menu');?> <div id="page-wrapper"> <div class="container-fluid"> <section class="admin_heading"> <div class="col-sm-12"> <h3>PO-Acknowledgements</h3> </div> <div class="col-sm-12"> <div id = "jaytab" style="width: 100%; margin-top:1%;"> <p>Last Updated Date and Time 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> </section> <?php $ci =& get_instance(); $base_url = base_url(); ?> <!-- /.row end--> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> <?php $this->load->view('includes/admin_dashboard_footer');?> <style> @media only screen and (min-width:320px) and (max-width:641px){ .ui-jqgrid { margin-left: 1px !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; } .text_color a{ color:white !important; } </style> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.js'); ?>"></script> <!-- This is the Javascript file of jqGrid --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <script> $(document).ready(function (){ //var l=$("#loc").val(); //alert(l); jQuery("#list2").jqGrid({ url:"<?php echo site_url('controller/po_view_insert');?>", mtype : "post", datatype: "json", colNames:['po_id','Partner Code','PO Number','Acknowledgement'], colModel:[ {name:'po_id',index:'po_id', width:100, align:'center',key:true,editable:true,hidden:true}, //{name:'stock_id', index:'stock_id', align:'center',editable:true, width:100}, {name:'partner_code', index:'partner_code', width:100, align:'center', sortable:false,editable:true,edittype:'text'}, {name:'po_number', index:'po_number', width:100, align:'center', sortable:false,editable:true,edittype:'text'}, // {name:'reference_code', index:'reference_code', width:100, align:'center',editable:true,edittype:'text'}, {name:'acknowledgement', index:'acknowledgement', width:150, align:'center', sortable:false,editable:true,edittype:'text'}, // {name:'createdate', index:'createdate', width:100, align:'center', sortable:false,editable:true,edittype:'text',hidden:true} ], rowNum:50, rowTotal: 2000, rowList : [50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager2", sortname:'po_id', viewrecords: true, loadonce:true, gridview: true, autowidth: true, sortorder:"desc", caption:"PO Acknowledgement" }); $("#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" } ); $('#pager2').css("height", "auto"); $("#list2").navButtonAdd('#pager2', { caption:"Add", buttonicon:"ui-icon-plus", onClickButton: addRow, position: "last", title:"", cursor:"pointer", id:"client_add" } ); $("#list2").navButtonAdd('#pager2', { caption:"Edit", buttonicon:"ui-icon-pencil", onClickButton: editRow, position: "last", title:"", cursor: "pointer", id:"client_edit" } ); $("#list2").navButtonAdd('#pager2', { caption:"Delete", buttonicon:"ui-icon-trash", onClickButton: deleteRow, position: "last", title:"", cursor: "pointer", id:"client_delete" } ); }); function addRow() { // Get the currently selected row $("#list2").jqGrid('editGridRow','new', { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var po_id = $("#po_id").val(); var partner_code = $("#partner_code").val(); var po_number = $("#po_number").val(); //var date = $("#date").val(); var acknowledgement = $("#acknowledgement").val(); //var createdate = $("#createdate").val(); $.ajax({ url:"<?php echo site_url('controller/po_info_insert_add');?>", type:"POST", data:{'po_id':po_id,'partner_code':partner_code,'po_number':po_number,'acknowledgement':acknowledgement}, async:false, success:function(data){ alert('Successfully Added.'); $("#editmodlist2").remove(); window.location.reload(); $("#list2").trigger("reloadGrid"); } }); }, closeAfterAdd: true, reloadAfterSubmit:false, closeOnEscape:true, clearAfterAdd: true, afterSubmit :false }); } function deleteRow() { // Get the currently selected row var row = $("#list2").jqGrid('getGridParam','selrow'); // $("#po_id").val(row); if( row != null ) $("#list2").jqGrid('editGridRow',row, { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var po_id = $("#po_id").val(); // //var stock_id = $("#stock_id").val(); // var po_number = $("#po_number").val(); // //var date = $("#date").val(); // var acknowledgement = $("#acknowledgement").val(); // var createdate = $("#createdate").val(); $.ajax({ url:"<?php echo site_url('controller/po_info_insert_delete');?>", type:"POST", data:{'po_id':po_id}, async:false, success:function(data){ if(data==""){ alert('Successfully Deleted.'); //$("#editmodlist2").remove(); $("#list2").trigger("reloadGrid"); jQuery('#list2').jqGrid('editRow',po_id,true,reload()); // $("#clientcode").attr("aria-expanded","false"); // $("#cname").attr("aria-expanded","false"); } else{ alert('Successfully Deleted.'); $("#editmodlist2").remove(); window.location.reload(); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } function editRow() { // Get the currently selected row var row = $("#list2").jqGrid('getGridParam','selrow'); if( row != null ) $("#list2").jqGrid('editGridRow',row, { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var po_id = $("#po_id").val(); var partner_code = $("#partner_code").val(); var po_number = $("#po_number").val(); //var date = $("#date").val(); var acknowledgement = $("#acknowledgement").val(); //var createdate = $("#createdate").val(); $.ajax({ url:"<?php echo site_url('controller/po_info_insert_edit');?>", type:"POST", data:{'po_id':po_id,'partner_code':partner_code,'po_number':po_number,'acknowledgement':acknowledgement}, async:false, success:function(data){ if(data==""){ alert('Successfully Updated.'); //$("#editmodlist2").remove(); $("#list2").trigger("reloadGrid"); jQuery('#list2').jqGrid('editRow',po_id,true,reload()); // $("#clientcode").attr("aria-expanded","false"); // $("#cname").attr("aria-expanded","false"); } else{ alert('Successfully Updated.'); $("#editmodlist2").remove(); window.location.reload(); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } </script> <!-- Bootstrap Core JavaScript --> <script src="<?php echo base_url('admin_assets/js/bootstrap.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/js/plugins/morris/raphael.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris-data.js');?>"></script>