EVOLUTION-NINJA
Edit File: marking_grid_old.php
<script src="<?php echo base_url('assets/js/jquery.table2excel.js');?>"></script> <script src="<?php echo base_url('assets/js/jspdf.debug.js');?>"></script> <script src="<?php echo base_url('assets/js/jspdf.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/shim.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/xlsx.full.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/Blob.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/FileSaver.js');?>"></script> <style> .ui-jqgrid { text-transform: capitalize !important; } .tablediv { text-transform: uppercase !important; } .ui-jqgrid tr.jqgrow td{ text-transform: uppercase !important; } </style> <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.min.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.min.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.min.css'); ?>" /> <script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script> <script> </script> <div class="page-content-wrapper"> <div class="page-content"> <!-- BEGIN PAGE HEADER--> <h3 class="page-title"> Marking Details </h3> <?php // echo $this->load->view('templates/nav_menu'); ?> <div class="page-bar"> <ul class="page-breadcrumb"> <li><i class="fa fa-home"></i> <a href="http://deco-textil.com/dashboard">Home</a> <i class="fa fa-angle-right"></i> <a href="<?php echo base_url('packing_list/madeups_list_data?prop_id=1'); ?>" > Packing List Madeups </a></li> </ul> </div> <div class="row"> <div class="col-md-3"> <button type="button" onclick="export_page();" style="padding-top: 4px;padding-bottom: 4px;" class="btn btn-primary">Export </button> </div> </div> <input type="submit" id="generate_submit" value="Submit" class="generate_submit" style="float: right; !important;margin-right: 22px;"/> <button type="button" style="float: right; !important;margin-right: 10px;"/><a href="<?php echo base_url('packing_list/madeups_data'); ?>" style="color: #516373 !important; text-decoration: none;">Back </a></button> <input type="hidden" id="delete_id" class="delete_id" value="<?php if(empty($access_row)){ } else { echo $access_row->delete_id; } ?>" > <input type="hidden" id="preview_id" class="preview_id" value="<?php if(empty($access_row)){ } else { echo $access_row->preview_id; } ?>" > <form action="<?php echo base_url('packing_list/madeups_details'); ?>" method="post" class="form"> <input type="hidden" id="checked_ids" name="checked_ids" class="checked_ids"> </form> <input type="hidden" id="p_id" class="p_id" value="<?php echo $p_id; ?>" > <div id="table_all"> <div id = "jaytab" class="jaytab"> <table id="list6"></table> <div id="pager6"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> </div> </div> </div> <!-- End BEGIN CONTAINER --> <!-- BEGIN FOOTER --> <!-- BEGIN FOOTER --> <link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>"> <script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" /> <style> .ss{ padding-right: 0 !important; padding-left: 0 !important; } .form-control { width:65% !important; height:27px !important; padding: 3px 12px !important; border-radius: 0px !important; //margin-bottom:15px; } label { font-weight: normal; text-align: left; } .hr-line{ border-top: 1px solid #465A81; } .well-sm { padding: 3px !important; border-radius: 0px !important; } input[type="file"] { padding-bottom: 28px !important; height: 25px !important; color:transparent; } .portlet.box.blue-madison { border: 1px solid #fff !important; border-top: 0; background:#fff !important; } #table_approved_indent { display:none; } #refresh_list3 { display:none !important; } </style> <script> </script> <!-----------------datepicker-------------> <!-- The link to the CSS that the grid needs --> <link href="<?php echo base_url('assets/css/sweetalert2.min.css');?>" rel="stylesheet"/> <script src="<?php echo base_url('assets/js/sweetalert2.min.js');?>"></script> <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.min.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <!-- 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.min.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap.min.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap-ui.min.css'); ?>" /> <link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>"> <script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" /> <style type="text/css"> .ss{ padding-right: 0 !important; padding-left: 0 !important; } label { font-weight: normal; text-align: left; } .hr-line{ border-top: 1px solid #465A81; } .well-sm { padding: 3px !important; border-radius: 0px !important; } input[type="file"] { padding-bottom: 28px !important; height: 25px !important; color:transparent; } .portlet.box.blue-madison { border: 1px solid #fff !important; border-top: 0; background:#fff !important; } input[type=file] { display: none; } .ui-jqgrid .ui-jqgrid-caption { text-align: left; background: rgb(72,91,127); color: white; } .ui-jqdialog .ui-jqdialog-titlebar { padding: .1em .1em; min-height: 35px; background: rgb(72,91,127); color: white; } .ui-jqdialog .ui-jqdialog-titlebar-close span { display: block; margin: -9px; } #sData { height: 27px; } #cData { height: 27px; } #dData { height: 27px; } #eData { height: 27px; } .coledit { cursor:pointer; text-align: right; padding-right: 33px !important; padding-left: 33px !important; } .ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td { overflow: hidden; white-space: pre; } </style> <!-----------------datepicker-------------> <!-- The link to the CSS that the grid needs --> <script> <!----------------------------------------------------all location----------------------------------------> $(document).ready(function (){ var p_id = $('#p_id').val(); var currids =[]; jQuery("#list6").jqGrid({ url:"<?php echo base_url('packing_list/marking_list_grid')?>/"+p_id+"/", datatype: "json", colNames:['Id','Customer Order #','Invoice','Buyer Product Name','Box #','SKU','Desc','Qty','NET Wt','Gross Wt','Size','Aricle','Shade','Box Dimension','Order Type'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'batch_no',index:'batch_no', width:50,editable:false,width:130}, {name:'invoice',index:'invoice',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'invoice_description',index:'invoice_description',editable:true, width:130}, {name:'box_id',index:'box_id',editable:true, width:120}, {name:'skuno',index:'skuno', editable:true,editrules:{required: true},width:200}, {name:'invoice_description',index:'invoice_description', width:50,editable:false,width:130}, {name:'received_qty',index:'received_qty', width:50,editable:false,width:100}, {name:'exp_wt',index:'exp_wt', width:50,editable:false,width:100}, {name:'bal_qty',index:'bal_qty',hidden:false,editable:true, width:120}, {name:'size',index:'size', editable:true,editrules:{required: true},width:100}, {name:'article',index:'article', editable:true,editrules:{required: true},width:100}, {name:'shades',index:'shades', editable:true,editrules:{required: true},width:100}, {name:'box_dimension',index:'box_dimension', editable:true,editrules:{required: true},width:100}, {name:'order_type',index:'order_type', editable:true,editrules:{required: true},sorttype:'int',width:100}, /* {name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], height: 'auto', rowNum:1000, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager6", sortname:'sequence', viewrecords: true, gridview: true, autowidth: true, multiselect: true, sortorder:"asc", loadonce:true, caption:"Marking list", //footerrow: true, footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list6").jqGrid('getCol','received_qty',false,'sum'); var sumOfPrice_net_weight = jQuery("#list6").jqGrid('getCol','exp_wt',false,'sum'); var sumOfPrice_gross_weight = jQuery("#list6").jqGrid('getCol','bal_qty',false,'sum'); jQuery("#list6").jqGrid('footerData', 'set', { skuno: 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2), exp_wt: sumOfPrice_net_weight.toFixed(2), bal_qty: sumOfPrice_gross_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required jQuery("#list6").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list6").jqGrid('navGrid','#pager6', {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 export_page() { //id = jQuery("#list3").jqGrid('getDataIDs'); //var type= $('#type').val(); var p_id = $('#p_id').val(); $.ajax({ type : 'get', url:"<?php echo base_url('packing_list/marking_list_grid_table')?>", data : {id:p_id}, success:function(data){ response=jQuery.parseJSON(data); console.log(response); var count =1; $('.export_table').empty(); var rec_g=0; rec_weight =0; inspected_mtrs=0; rejected_mtrs=0; variance_mtrs=0; var content = ''; content +='<thead><tr><th><b>SL No.</b></th><th><b>Vendor Name / Factory</b></th> <th><b>PO# / OSL No.</b></th> <th><b>SSL Piece No</b></th> <th><b>Supplier Piece No</b></th> <th><b>Article(PRODUCT)</b></th> <th><b>Width</b></th> <th><b>Design</b></th> <th><b>Shade</b></th><th><b>Received Weight</b></th><th><b>Actual Quantity </b></th><th><b>Rejected Mtrs</b></th><th><b>Variance Mtrs</b></th><th><b>Received Date</b></th><th><b>Location></b></th></tr></thead>'; $.each(response,function(key,vas){ content +='<tr><td>'+count+'</td> <td>'+vas.invoice+'</td></tr>'; count++; }); content +='<tr></tr>'; //content +='<tr><th><b>TOTAL</b></th><th></th> <th></th> <th></th> <th></th> <th></th> <th></th> <th></th> <th></th><th><b>'+rec_weight+'</b></th><th><b>'+rec_g+'</b></th><th><b>'+rejected_mtrs+'</b></th><th><b>'+variance_mtrs+'</b></th><th></th></tr>'; $('.export_table').append(content); doit('xlsx'); // doit(type, fn, dl); // export_data(); // pdf_download(); } }); } function doit(type, fn, dl) { var elt = document.getElementById('export_table'); var wb = XLSX.utils.table_to_book(elt, {sheet:"Sheet JS"}); return dl ? XLSX.write(wb, {bookType:type, bookSST:true, type: 'base64'}) : XLSX.writeFile(wb, fn || ('Fabric Stock Report.' + (type || 'xlsx'))); } function tableau(pid, iid, fmt, ofile) { if(typeof Downloadify !== 'undefined') Downloadify.create(pid,{ swf: 'downloadify.swf', downloadImage: 'download.png', width: 100, height: 30, filename: ofile, data: function() { return doit(fmt, ofile, true); }, transparent: false, append: false, dataType: 'base64', onComplete: function(){ alert('Your File Has Been Saved!'); }, onCancel: function(){ alert('You have cancelled the saving of this file.'); }, onError: function(){ alert('You must put something in the File Contents or there will be nothing to save!'); } }); else document.getElementById(pid).innerHTML = ""; } tableau('biff8btn', 'xportbiff8', 'biff8', 'test.xls'); tableau('odsbtn', 'xportods', 'ods', 'test.ods'); tableau('fodsbtn', 'xportfods', 'fods', 'test.fods'); tableau('xlsbbtn', 'xportxlsb', 'xlsb', 'test.xlsb'); tableau('xlsxbtn', 'xportxlsx', 'xlsx', 'test.xlsx'); function fun_preview(rowId) { var id = rowId.closest('tr').attr('id'); var as=id; // var v=$('#preview_id').val(); // if(v == 1) // { $.ajax({ type:'post', url:'<?php echo base_url("stock_history_details/madeups_stock_preview"); ?>', data:{'id':as}, async:false, success:function() { window.location.href = '<?php echo base_url('stock_history_details/madeups_stock_preview');?>/'+ '?id='+as; } }); // } // else // { // swal({ // title: "You Don't Have Access For This Preview", // text: "", // }); // } } <!------------------------ Ho ------------------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list2").jqGrid({ url:"<?php echo base_url('packing_list/ho_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /* {name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], 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, multiselect: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list2").jqGrid('getCol','received_qty',false,'sum'); // var sumOfPrice_balanced_mtrs = jQuery("#list2").jqGrid('getCol','balanced_mtrs',false,'sum'); //var sumOfPrice_var_mtrs = jQuery("#list2").jqGrid('getCol','variance_mtrs',false,'sum'); jQuery("#list2").jqGrid('footerData', 'set', { batch_no: 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required 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 } ); }); <!----------------------------------peenya access controll -------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list3").jqGrid({ url:"<?php echo base_url('packing_list/dyeing_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /*{name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], 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, multiselect: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list3").jqGrid('getCol','received_qty',false,'sum'); //var sumOfPrice_balanced_mtrs = jQuery("#list3").jqGrid('getCol','balanced_mtrs',false,'sum'); //var sumOfPrice_var_mtrs = jQuery("#list3").jqGrid('getCol','variance_mtrs',false,'sum'); //var s=sumOfPrice_rec_weight.toFixed(2); jQuery("#list3").jqGrid('footerData', 'set', { batch_no : 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required 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 } ); }); <!----------------------------------nandi access controll -------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list4").jqGrid({ url:"<?php echo base_url('packing_list/nandi_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /* {name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], 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, multiselect: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list4").jqGrid('getCol','received_qty',false,'sum'); // var sumOfPrice_balanced_mtrs = jQuery("#list4").jqGrid('getCol','balanced_mtrs',false,'sum'); // var sumOfPrice_var_mtrs = jQuery("#list4").jqGrid('getCol','variance_mtrs',false,'sum'); //var s=sumOfPrice_rec_weight.toFixed(2); jQuery("#list4").jqGrid('footerData', 'set', { batch_no : 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required 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 } ); }); <!----------------------------------tailoring access controll -------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list5").jqGrid({ url:"<?php echo base_url('packing_list/tailoring_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /*{name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager5", sortname:'id', viewrecords: true, multiselect: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list5").jqGrid('getCol','received_qty',false,'sum'); // var sumOfPrice_balanced_mtrs = jQuery("#list5").jqGrid('getCol','balanced_mtrs',false,'sum'); //var sumOfPrice_var_mtrs = jQuery("#list5").jqGrid('getCol','variance_mtrs',false,'sum'); //var s=sumOfPrice_rec_weight.toFixed(2); jQuery("#list5").jqGrid('footerData', 'set', { batch_no : 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required 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 } ); }); <!----------------------------------BYATRANPURA access controll -------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list8").jqGrid({ url:"<?php echo base_url('packing_list/byatranpura_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /* {name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager8", sortname:'id', viewrecords: true, multiselect: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list8").jqGrid('getCol','received_qty',false,'sum'); //var sumOfPrice_balanced_mtrs = jQuery("#list8").jqGrid('getCol','balanced_mtrs',false,'sum'); //var sumOfPrice_var_mtrs = jQuery("#list8").jqGrid('getCol','variance_mtrs',false,'sum'); //var s=sumOfPrice_rec_weight.toFixed(2); jQuery("#list8").jqGrid('footerData', 'set', { batch_no : 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required jQuery("#list8").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list8").jqGrid('navGrid','#pager8', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); }); <!----------------------------------VIJAYAPURA access controll -------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list9").jqGrid({ url:"<?php echo base_url('packing_list/vijayapura_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /* {name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager9", sortname:'id', viewrecords: true, multiselect: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list9").jqGrid('getCol','received_qty',false,'sum'); //var sumOfPrice_balanced_mtrs = jQuery("#list9").jqGrid('getCol','balanced_mtrs',false,'sum'); // var sumOfPrice_var_mtrs = jQuery("#list9").jqGrid('getCol','variance_mtrs',false,'sum'); //var s=sumOfPrice_rec_weight.toFixed(2); jQuery("#list9").jqGrid('footerData', 'set', { batch_no : 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required jQuery("#list9").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list9").jqGrid('navGrid','#pager9', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); }); <!----------------------------------DODDAJALA access controll -------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list10").jqGrid({ url:"<?php echo base_url('packing_list/doddajala_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /* {name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }}, */ ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager10", sortname:'id', viewrecords: true, multiselect: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list10").jqGrid('getCol','received_qty',false,'sum'); //var sumOfPrice_balanced_mtrs = jQuery("#list10").jqGrid('getCol','balanced_mtrs',false,'sum'); //var sumOfPrice_var_mtrs = jQuery("#list10").jqGrid('getCol','variance_mtrs',false,'sum'); //var s=sumOfPrice_rec_weight.toFixed(2); jQuery("#list10").jqGrid('footerData', 'set', { batch_no : 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required jQuery("#list10").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list10").jqGrid('navGrid','#pager10', {edit:false,add:false,del:false,search:false,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); }); <!------------------------------------kumara park----------------------------------> $(document).ready(function (){ var osl=$('#osl_no').val(); jQuery("#list7").jqGrid({ url:"<?php echo base_url('packing_list/kumara_madeups_stock')?>/"+osl+"/", datatype: "json", colNames:['Id','DTL No','Order Type','Size','Article','Description','Design','Shade','DTL Shade','Batch No','Received Qty','Received Wt','Sequence'/*'Received Date','Location','Received By','Preview'*/], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl',index:'osl', width:50,editable:false,width:130}, {name:'order_type',index:'order_type',edittype:'text',editable:true,editrules:{required: true}, width:120}, {name:'size',index:'size',editable:true, width:130}, {name:'article',index:'article',editable:true, width:120}, {name:'description',index:'description', editable:true,editrules:{required: true},width:200}, {name:'design',index:'design', width:50,editable:false,width:130}, {name:'shade',index:'shade', width:50,editable:false,width:100}, {name:'ssl_shade',index:'ssl_shade', width:50,editable:false,width:100}, {name:'batch_no',index:'batch_no',hidden:false,editable:true, width:120}, {name:'received_qty',index:'received_qty', editable:true,editrules:{required: true},width:100}, {name:'received_wt',index:'received_wt', editable:true,editrules:{required: true},width:100}, {name:'sequence',index:'sequence', editable:true,editrules:{required: true},width:100}, /* {name:'rec_date',index:'rec_date', width:50,editable:false,width:100}, {name:'location',index:'location',hidden:false,editable:true, width:100}, {name:'rec_by',index:'rec_by',hidden:false,editable:true, width:120}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='some_function' \>"; }},*/ ], height: 'auto', rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager7", sortname:'id', viewrecords: true, multiselect: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Madeups Stock Details", footerrow: true, loadComplete: function () { var sumOfPrice_rec_weight = jQuery("#list7").jqGrid('getCol','received_qty',false,'sum'); // var sumOfPrice_balanced_mtrs = jQuery("#list7").jqGrid('getCol','balanced_mtrs',false,'sum'); //var sumOfPrice_var_mtrs = jQuery("#list7").jqGrid('getCol','variance_mtrs',false,'sum'); //var s=sumOfPrice_rec_weight.toFixed(2); jQuery("#list7").jqGrid('footerData', 'set', { batch_no : 'Total:', received_qty: sumOfPrice_rec_weight.toFixed(2) }); }, }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required jQuery("#list7").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list7").jqGrid('navGrid','#pager7', {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> <link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>"> <script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" /> <script> $("#generate_submit").on('click', function () { var id=''; $("input[type=checkbox]:checked").each(function() { id += $(this).closest('tr').attr('id') + "|"; }); //alert(); $(".checked_ids").val(''); $(".checked_ids").val(id); // $(".checked_ids_val").val(id); var check_values=$(".checked_ids").val(); //alert(check_values); $.ajax({ url:"<?php echo base_url('packing_list/check_box_checked_madeups_values')?>", dataType: "json", data:{'check_values':check_values}, type:"POST", async:true, success:function(data) { //var obj = jQuery.parseJSON(data); //alert(obj.invoice); //alert(obj.invoice_num); var confirmMsg= confirm("Do You Want To Add One More Stock.!"); if (confirmMsg==true) { $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list6").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list7").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list8").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list9").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list10").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } else if (confirmMsg==false) { $(".form").submit(); // window.location.href = '<?php echo base_url('fabric/issue_fabric_datas');?>'; } } }); }); </script> <style> .preview { padding-bottom:3px !important; padding-top:3px !important; } </style> <link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>"> <script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" /> <script> $(document).ready(function() { $( "#customer" ).autocomplete({ source: '<?php echo base_url('request/auto_sea'); ?>', }); }); function searchname() { var customer = document.getElementById('customer').value; $.ajax({ url:"<?php echo base_url('request/search_by_fetch')?>", dataType: "json", data:{'customer':customer}, type:"POST", async:true, success:function(data) { // alert('hai'); var obj=JSON.parse(data); document.getElementById('customer_id').value=obj[0].customerID; } }); } </script> <style> #search_list2 { display:none !important; } #list2_122_t { height:0px !important; } list2_136_t { height:12px !important; } .scroll { height:12px !important; } .ui-jqgrid-btable { } .ui-common-table { height:12px !important; } #refresh_list2 { display:none !important; } #client_edit { padding-right:12px !important; } #list2 { width: 1050px; height: 0px !important; } #gbox_list2 { height: auto !important; } #gview_list2 { 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; } #editmodlist2 { 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> <style> @media only screen and (min-width:320px) and (min-height:640px){ #gbox_list2{ width:1052px !important; } #gview_list2{ width:100% !important; } .ui-jqgrid-hdiv{ width:100% !important; } .ui-jqgrid-htable{ width:100% !important; } #list2{ width:100% !important; } } </style>