EVOLUTION-NINJA
Edit File: Add_indents.php
<?php $this->load->view('includes/header.php')?> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/grid_style.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/jqgrid/css/ui.jqgrid-bootstrap-ui.css'); ?>" /> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <script type="text/ecmascript" src="<?php echo base_url('assets/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <div class="content-wrapper"> <div class="row"> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <form action="<?php echo site_url('add-indent-details'); ?>" method="post" class="form-horizontal"> <b>To insert data click here:</b> <input type="submit" name="Insert" value="Insert" /><br><br> </form> <div class="radio-list" style="margin-left: 2%;"> <label class="radio-inline"> <input type="radio" name="planningorder" id="planningorder" checked="checked" onclick="planningtypes('indent_pending_tax')" /> Pending Tax Indent </label> <label class="radio-inline"> <input type="radio" name="planningorder" id="planningorder" onclick="planningtypes('approved_indent_tax')" /> Approved Tax Indent</label> <label class="radio-inline"> <input type="radio" name="planningorder" id="planningorder" onclick="planningtypes('indent_pending_no_tax')" /> Pending Tax-free Indent </label> <label class="radio-inline"> <input type="radio" name="planningorder" id="planningorder" onclick="planningtypes('approved_indent_no_tax')" /> Approved Tax-free Indent</label> </div><br> <div id="table_pending_indent_tax"> <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 id="table_approved_indent_tax"> <div id = "jaytab1" class="jaytab"> <table id="list3"></table> <div id="pager3"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <div id="table_pending_indent_no_tax"> <div id = "jaytab2" class="jaytab"> <table id="list4"></table> <div id="pager4"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <div id="table_approved_indent_no_tax"> <div id = "jaytab3" class="jaytab"> <table id="list5"></table> <div id="pager5"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> </div> </div> </div> </div> <input type="hidden" id="selected_ids"/> <button type="button" id="select_ids" class="btn btn-primary get_site_grid" onclick="getSelectedRow()" >Submit</button> </div> <style type="text/css"> #table_approved_indent_tax { display:none; } #table_pending_indent_no_tax { display:none; } #table_approved_indent_no_tax { display:none; } #btn{ border: none; background:none; } </style> <script type="text/javascript"> function planningtypes(str) { if(str=="indent_pending_tax") { $('#table_pending_indent_tax').show(); $('#table_approved_indent_tax').hide(); $('#table_pending_indent_no_tax').hide(); $('#table_approved_indent_no_tax').hide(); $('#select_ids').show(); } else if(str=="approved_indent_tax") { $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#table_approved_indent_tax').show(); $('#table_pending_indent_tax').hide(); $('#table_pending_indent_no_tax').hide(); $('#table_approved_indent_no_tax').hide(); $('#select_ids').hide(); } else if(str=="indent_pending_no_tax") { $("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#table_pending_indent_no_tax').show(); $('#table_pending_indent_tax').hide(); $('#table_approved_indent_tax').hide(); $('#table_approved_indent_no_tax').hide(); $('#select_ids').show(); } else if(str=="approved_indent_no_tax") { $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#table_approved_indent_no_tax').show(); $('#table_pending_indent_tax').hide(); $('#table_approved_indent_tax').hide(); $('#table_pending_indent_no_tax').hide(); $('#select_ids').hide(); } } ///pending indent details-------------------------// CallGrid(); function CallGrid() { $(document).ready(function (){ var currids =[]; jQuery("#list2").jqGrid({ url:"<?php echo site_url('get-indent-list')?>", datatype: "json", colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'], colModel:[ {name:'id',index:'id',hidden:true, editable:true,width:200}, {name:'indent_no',index:'indent_no', width:250,editable:false}, //{name:'department_name',index:'department_name', width:250,editable:true,editrules:{required: true}}, {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}}, {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}}, {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:300}, {name:'created_at',index:'created_at', formatter: 'date',formatoptions: { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'},editable:true,editrules:{required: true},width:270}, {name:'name',index:'name', editable:true,editrules:{required: true},width:150}, {name:'preview',index:'preview',align: "center",editable:false,search:false,editrules:{required: true}, width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { // return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>"; return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>"; }} ], 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:"Pending Tax Indent Details", subGrid: true, subGridRowExpanded: function(subgrid_id, row_id) { var subgrid_table_id; //alert(row_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 site_url('subgrid-indent-details');?>/"+row_id, mtype : "get", datatype: "json", colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Action','Delete'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}}, {name:'product_group_name',index:'product_group_name', width:150,editable:true,editrules:{required: true}}, {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:80}, {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:80}, {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}}, {name:'required_on_or_before',index:'required_on_or_before',formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'}, editable:true,editrules:{required: true},width:100}, /*{name:'approval',index:'approval',editable:false,align:'center', classes: 'check',editrules:{required: true},search:false, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="fun_approve('+rawObject.id+')"'; },formatter:function (cellvalue, options, rowObject) { if(cellvalue == 'APPROVED') return "<input type='checkbox' value='APPROVE' checked readonly \>"; else if(cellvalue == 'NOT_APPROVED') return "<input type='checkbox' value='APPROVE' \>"; }},*/ {name:'edit',index:'edit',align: "center",editable:false,seach:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="fun_edit($(this))"'; },formatter:function (cellvalue, options, rowObject) { // return "<input type='button' class='fa fa-eye' value='SELECT' \>"; return "<button type='button' id='select'><i class='fa fa-hand-pointer-o fa-lg' aria-hidden='true'></i></button>"; }}, {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="fun_delete($(this))"'; },formatter:function (cellvalue, options, rowObject) { // return "<input type='button' class='fa fa-eye' value='DELETE' \>"; return "<button type='button' id='delete'><i class='fa fa-trash fa-lg' aria-hidden='true'></i></button>"; }}, ], height: 'auto', rowNum:20000000, sortname: 'num', sortorder: "asc", multiselect: true, onSelectRow: function(ids) { //fun_approve(ids); var sub_id=jQuery("#"+subgrid_table_id).jqGrid('getGridParam','selrow'); currids.push(sub_id); var result = []; $.each(currids, function(i, e) { if ($.inArray(e, result) == -1) result.push(e); }); $("#selected_ids").val(currids); }, onSelectAll:function(ids) { fun_approve_all(ids); }, }); } }); 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 getSelectedRow() { var sub_ids=$("#selected_ids").val(); swal({ title: "Are you sure?", text: "You want to Approve this?", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : "<?php echo site_url('indent-approval');?>", data : {'indent_sub_ids':sub_ids}, success:function(response) { response=jQuery.parseJSON(response); // alert(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } else { toastr["error"](response.message); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } }); } function fun_edit(rowId) { var id = rowId.closest('tr').attr('id'); window.location.href = '<?php echo site_url('edit-indent');?>/'+id; } function checkBox(obj) { alert(obj); $('.check').prop('checked', obj.checked); } function fun_delete(rowId) { var id = rowId.closest('tr').attr('id'); swal({ title: "Are you sure of deleting?", text: "You will not be able to recover this data!", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes, delete it!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : "<?php echo site_url('delete-indent');?>", data : {'indent_id':id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1){ toastr["success"](response.message); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } // function fun_approve(id) // { // swal({ // title: "Are you sure?", // text: "You want to Approve this?", // type: "warning", showCancelButton: true, // confirmButtonColor: "#DD6B55", // confirmButtonText: "Yes!", // cancelButtonText: "No, cancel plz!", // closeOnConfirm: false, // closeOnCancel: false // }, // function(isConfirm){ // if (isConfirm) { // $(".sweet-alert").hide(); // $(".sweet-overlay").hide(); // $.ajax({ // type : 'post', // url : "<?php echo site_url('indent-approval');?>", // data : {'indent_id':id}, // success:function(response) { // response=jQuery.parseJSON(response); // console.log(response); // if(response.result==1) // { // toastr["success"](response.message); // $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); // $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); // } // else // { // toastr["error"](response.message); // $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); // $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); // } // } // }); // } // else // { // $(".sweet-alert").hide(); // $(".sweet-overlay").hide(); // $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); // } // }); // } function fun_approve_all(id) { swal({ title: "Are you sure?", text: "You want to Approve this?", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : "<?php echo site_url('indent-approvalall');?>", data : {'indent_id':id}, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } else { toastr["error"](response.message); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); } }); } function fun_preview(rowId,grid_from_id) { var id = rowId.closest('tr').attr('id'); window.location.href = '<?php echo site_url('indent-preview');?>/'+id; } function fun_preview_approve(rowId,grid_from_id) { var id = rowId.closest('tr').attr('id'); window.location.href = '<?php echo site_url('indent-preview-approve');?>/'+id; } //------------------------approved-details----------------------------// $(document).ready(function (){ $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); jQuery("#list3").jqGrid({ url:"<?php echo site_url('approved-indent-details')?>", datatype: "json", colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'], colModel:[ {name:'id',index:'id',hidden:true, editable:true,width:200}, {name:'indent_no',index:'indent_no', width:200,editable:false}, // {name:'department_name',index:'department_name', width:300,editable:true,editrules:{required: true}}, {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}}, {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}}, {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:250}, {name:'created_at',index:'created_at',formatter: 'date',formatoptions: { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'}, editable:true,editrules:{required: true},width:270}, {name:'name',index:'name', editable:true,editrules:{required: true},width:150}, {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview_approve($(this))" '; },formatter:function (cellvalue, options, rowObject) { //return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>"; return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>"; }} ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Approved Tax Indent 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 site_url('indent-approved-subgrid');?>/"+row_id, //data:{'sub_id':123}, mtype : "get", datatype: "json", colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Approved','Approved By'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}}, {name:'product_group_name',index:'product_group_name', width:150,editable:true,editrules:{required: true}}, {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:80}, {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:80}, {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}}, {name:'required_on_or_before',index:'required_on_or_before',formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'}, editable:true,editrules:{required: true},width:150}, {name:'approval',index:'approval',editable:false,align:'center',editrules:{required: true},search:false, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="fun_approve('+rawObject.id+')"'; },formatter:function (cellvalue, options, rowObject) { if(cellvalue == 'APPROVED') return "<input type='checkbox' value='APPROVE' checked readonly \>"; else if(cellvalue == 'NOT_APPROVED') return "<input type='checkbox' value='APPROVE' \>"; }}, {name:'name',index:'name', width:100,editable:true,editrules:{required: true}}, ], height: 'auto', rowNum:20000000, sortname: 'num', sortorder: "asc" }); } }); jQuery("#list3").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list3").jqGrid('navGrid','#pager3', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); }); /*--------------------------Pending Indent Tax-free---------------------------------*/ $(document).ready(function (){ var currids =[]; jQuery("#list4").jqGrid({ url:"<?php echo site_url('get-tax-free-indent-list')?>", datatype: "json", colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'], colModel:[ {name:'id',index:'id',hidden:true, editable:true,width:200}, {name:'indent_no',index:'indent_no', width:250,editable:false}, {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}}, {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}}, {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:300}, {name:'created_at',index:'created_at', formatter: 'date',formatoptions: { srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'},editable:true,editrules:{required: true},width:250}, {name:'name',index:'name', editable:true,editrules:{required: true},width:150}, {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { // return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>"; return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>"; }} ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager4", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Pending Tax-free Indent Details", subGrid: true, subGridRowExpanded: function(subgrid_id, row_id) { var subgrid_table_id; //alert(row_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 site_url('subgrid-tax-free-indent-details');?>/"+row_id, mtype : "get", datatype: "json", colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Action','Delete'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}}, {name:'product_group_name',index:'product_group_name', width:110,editable:true,editrules:{required: true}}, {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:60}, {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:50}, {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}}, {name:'required_on_or_before',index:'required_on_or_before',formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'}, editable:true,editrules:{required: true},width:80}, // {name:'approval',index:'approval',editable:false,align:'center',editrules:{required: true},search:false, width:120,cellattr: function (rowId, tv, rawObject, cm, rdata) // { // return 'onclick="fun_approve('+rawObject.id+')"'; // },formatter:function (cellvalue, options, rowObject) { // if(cellvalue == 'APPROVED') // return "<input type='checkbox' value='APPROVE' checked readonly \>"; // else if(cellvalue == 'NOT_APPROVED') // return "<input type='checkbox' value='APPROVE' \>"; // }}, {name:'edit',index:'edit',align: "center",search:false,editable:false,editrules:{required: true}, width:70,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="fun_edit($(this))"'; },formatter:function (cellvalue, options, rowObject) { // return "<input type='button' class='fa fa-eye' value='SELECT' \>"; return "<button type='button' id='select'><i class='fa fa-hand-pointer-o fa-lg' aria-hidden='true'></i></button>"; }}, {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:70,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="fun_delete($(this))"'; },formatter:function (cellvalue, options, rowObject) { // return "<input type='button' class='fa fa-eye' value='DELETE' \>"; return "<button type='button' id='delete'><i class='fa fa-trash fa-lg' aria-hidden='true'></i></button>"; }}, ], height: 'auto', rowNum:20000000, sortname: 'num', sortorder: "asc", multiselect: true, onSelectRow: function(ids) { //fun_approve(ids); var sub_id=jQuery("#"+subgrid_table_id).jqGrid('getGridParam','selrow'); currids.push(sub_id); var result = []; $.each(currids, function(i, e) { if ($.inArray(e, result) == -1) result.push(e); }); $("#selected_ids").val(currids); }, onSelectAll:function(ids) { fun_approve_all(ids); }, }); } }); jQuery("#list4").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list4").jqGrid('navGrid','#pager4', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); }); /*------------------------------------Approved Indent Tax-free------------------------*/ $(document).ready(function (){ $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); jQuery("#list5").jqGrid({ url:"<?php echo site_url('approved-tax-free-indent-details')?>", datatype: "json", colNames:['Id','Indent No','Layout','Site/Home','Consumed At','Created At','Created By','Preview'], colModel:[ {name:'id',index:'id',hidden:true, editable:true,width:200}, {name:'indent_no',index:'indent_no', width:200,editable:false}, // {name:'department_name',index:'department_name', width:300,editable:true,editrules:{required: true}}, {name:'layout',index:'layout',width:200,editable:true,editrules:{required: true}}, {name:'site_home',index:'site_home',width:200,editable:true,editrules:{required: true}}, {name:'consumed',index:'consumed', editable:true,editrules:{required: true},width:250}, {name:'created_at',index:'created_at',formatter: 'date',formatoptions:{ srcformat: 'ISO8601Long', newformat: 'd/m/Y g:ia'}, editable:true,editrules:{required: true},width:250}, {name:'name',index:'name', editable:true,editrules:{required: true},width:150}, {name:'preview',index:'preview',align: "center",editable:false,editrules:{required: true},search:false,width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview_approve($(this))" '; },formatter:function (cellvalue, options, rowObject) { // return "<input type='button' class='fa fa-eye' value='PREVIEW' onclick='some_function' classes='preview' \>"; return "<button type='button' id='btn'><i class='fa fa-eye' aria-hidden='true'></i></button>"; }} ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager5", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Approved Tax-free Indent 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 site_url('indent-approved-tax-free-subgrid');?>/"+row_id, //data:{'sub_id':123}, mtype : "get", datatype: "json", colNames:['Id','Product','Product Type','Quantity','Unit','Reason','Required On','Approved','Approved By'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'product_name',index:'product_name', width:150,editable:true,editrules:{required: true}}, {name:'product_group_name',index:'product_group_name', width:110,editable:true,editrules:{required: true}}, {name:'quantity',index:'quantity', editable:true,editrules:{required: true},width:60}, {name:'unit_name',index:'unit_name', editable:true,editrules:{required: true},width:50}, {name:'prod_reason',index:'prod_reason', width:150,editable:true,editrules:{required: true}}, {name:'required_on_or_before',index:'required_on_or_before', formatter: 'date',formatoptions: { srcformat: 'Y/m/d', newformat: 'd/m/Y'},editable:true,editrules:{required: true},width:80}, {name:'approval',index:'approval',editable:false,align:'center',editrules:{required: true},search:false, width:120,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="fun_approve('+rawObject.id+')"'; },formatter:function (cellvalue, options, rowObject) { if(cellvalue == 'APPROVED') return "<input type='checkbox' value='APPROVE' checked readonly \>"; else if(cellvalue == 'NOT_APPROVED') return "<input type='checkbox' value='APPROVE' \>"; }}, {name:'name',index:'name', width:100,editable:true,editrules:{required: true}}, ], height: 'auto', rowNum:20000000, sortname: 'num', sortorder: "asc" }); } }); jQuery("#list5").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list5").jqGrid('navGrid','#pager5', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); }); </script> <?php $this->load->view('includes/footer.php')?> <style type="text/css"> #delete{ color: red; border: none; background:none; } #select{ color:#405189; border: none; background:none; } #gbox_list3{ width: 1050px !important; } #gbox_list4, #gbox_list5{ width: 1050px !important; } </style>