EVOLUTION-NINJA
Edit File: purchase_po_genereted_list_form (2).php
<?php $this->load->view('includes/header');?> <link href="<?php echo base_url('assets/admin_dashboard/css/jquery-ui.css');?>" rel="stylesheet"> <script src="<?php echo base_url('assets/js/jquery-ui.js');?>"></script> <script src="<?php echo base_url('assets/admin_dashboard/js/jquery.table2excel.js');?>"></script> <section class="content-header"> <h1>Purchase Order List</h1> </section> <section class="content"> <div class="row"> <form id="land_owner" method="post" class="form-inline po_form_project_wise"> <div class="row land_owner_a"> <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">PO 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 style="display:none;"> <table border="1" style="border-spacing: 0px !important;" id="print_table" class="print_table"></table> </div> </div> </section> <!-- This is the Javascript file of jqGrid --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc. <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.css'); ?>" /> <script src="<?php echo base_url('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> <script type="text/javascript"> $(function(){ $(".from_date_picker").datepicker({ 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(){ 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("#list1").jqGrid({ url:"<?php echo site_url('work_order_po_generated_list')?>?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_cancel1($(this))" '; }}, {name:'edit',index:'edit',align: "center",editable:false,search:false,editrules:{required: true}, width:100,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:100,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:100,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:"#pager1", 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:"PO 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('gss/po_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" }); } }); $("#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-purchase-order-po');?>?id="+id; } function fun_view(rowId) { var id = rowId.closest('tr').attr('id'); window.location.href = "<?php echo site_url('view-purchase-order-po');?>?id="+id; } 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 PO?", 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-po")?>', 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 PO?", 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-po")?>', 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({ title: "Are you sure?", text: "Do you want to cancel this PO?", 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-po")?>', 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 PO?", 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-po")?>', 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_po_mail(rowId) { //alert(); var id = rowId.closest('tr').attr('id'); //alert(id); // var po_no = $("#po_no").val(); $.ajax({ type : 'post', url : '<?php echo site_url("gss/send_mail")?>', 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_purchase_order');?>?from="+from+"&to="+to+"&project="+project+"&po_no="+po_no, type : "GET", data : {id:id}, success:function(data){ response=jQuery.parseJSON(data); console.log(response); var count =1; var content = ''; content +='<thead><tr><th>Sl No</th><th>PO 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: "PO 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_purchase_order');?>?from="+from+"&to="+to+"&project="+project+"&po_no="+po_no, type : "GET", data : {id:id}, success:function(data){ response=jQuery.parseJSON(data); console.log(response); var count =1; var content = ''; content +='<thead><tr><th>Sl No</th><th>PO NO</th><th>Vendor Name</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.po_no+'</td><td>'+va.vendor+'</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-po")?>', 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.po_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(); } } }); } $('.po_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('purchase_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:"PO 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('gss/po_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" } ); }); $('.po_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('purchase_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:"PO 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('gss/po_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" } ); }); </script> <!-- <link href="http://code.jquery.com/ui/1.10.4/themes/ui-lightness/jquery-ui.css" rel="stylesheet"> --> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript">google.load('visualization', '1.0', {'packages': ['corechart']});</script> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <style> #ui-datepicker-div{ z-index:999 !important; } </style> <style> #jaytab3 { overflow-x: scroll !important; } </style> <style> #search_list6 { display:none !important; } #list6_122_t { height:0px !important; } .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 $this->load->view('includes/footer');?>