EVOLUTION-NINJA
Edit File: weaving_fabric_data.php
<div class="page-content-wrapper"> <div class="page-content"> <h3 class="page-title">Weaving Fabric Goods Received Details</h3> <?php $this->load->view('templates/nav_menu'); ?> <form id="land_owner" class="form-inline" enctype="multipart/form-data" method="post"> <div class="row" style="padding-bottom:15px;"> <div class="form-group col-sm-12 col-md-6"> <div class="row" style="padding-left:20px;padding-right:20px;"> <label class="col-sm-4 col-xs-5">OSL. No.</label> <input type="text" class="col-sm-8 col-xs-7" name="osl_no" id="osl_no"> </div> </div> <div class="form-group col-sm-12 col-md-6"> <button id="search" name="search" class="btn add" style="padding:3px 24px !important;">Search</button> </div> </div> <!-- row 1---> <div class="row select_product"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">OSL. No.</label> <input type="text" class="col-sm-8 col-xs-7" id="osl_num" name="osl_num" style="text-transform: uppercase !important" readonly> <input type="hidden" class="col-sm-8 col-xs-7" name="panel_id" id="panel_id"> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Party Name</label> <input type="text" class="col-sm-8 col-xs-7" id="party_ref" name="party_ref" style="text-transform: uppercase !important" readonly> </div> </div> <!-- row 2---> <div class="row select_product"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Delivery Date </label> <input type="text" class="col-sm-8 col-xs-7" name="delivery_date" id="delivery_date" readonly> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-5 col-xs-5" style="padding-right: 0 !important;">Mode of Order</label> <input type="text" class="col-sm-7 col-xs-7" name="order_mode" id="order_mode" style="text-transform: uppercase !important" readonly> </div> </div> <!-- row 3---> <div class="row select_product"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Approved By</label> <input type="text" class="col-sm-8 col-xs-7" name="approved_by" id="approved_by" style="text-transform: uppercase !important"> </div> </div> <!-- row 4---> </form> <div id="myModal" class="modal fade"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title">Goods Details</h4> </div> <div class="modal-body"> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">OSL No :</label> <div class="col-md-7"> <input type="text" class="form-control" id="modal_oslno" name="modal_oslno" class="modal_oslno" readonly> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Article :</label> <div class="col-md-7"> <input type="text" class="form-control" id="article" name="article" readonly> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Width :</label> <div class="col-md-7"> <input type="text" class="form-control" id="width" name="width" readonly> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Design :</label> <div class="col-md-7"> <input type="text" class="form-control" id="design" name="design" readonly> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Shade :</label> <div class="col-md-7"> <input type="text" class="form-control" id="shade" name="shade" readonly> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Factory:</label> <div class="col-md-7"> <input type="text" class="form-control" id="factory" name="factory" class="factory" readonly> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Finished Weight:</label> <div class="col-md-7"> <input type="text" class="form-control" id="fin_weight" name="fin_weight" class="fin_weight" readonly> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Ordered Mtrs :</label> <div class="col-md-7"> <input type="text" class="form-control" id="ord_mtrs" name="ord_mtrs" readonly="readonly" > </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Received Mtrs :</label> <div class="col-md-7"> <input type="text" class="form-control" id="rec_weight" name="rec_weight" > <input type="hidden" class="form-control" id="rec_mtrs" name="rec_mtrs" > </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Received Weight :</label> <div class="col-md-7"> <input type="text" class="form-control" id="rec_wt" name="rec_wt" > </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Received Date :</label> <div class="col-md-7"> <input type="text" class="form-control" id="received_date" name="received_date" data-provide="datepicker" value="<?php echo date("d-m-Y"); ?>"> </div> </div> </div> </div> <!-- row -3--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Location :</label> <div class="col-md-7"> <select class="form-control" id="consumed_at" name="consumed_at" style="height:26px;" > <option value="">Select</option> <?php if(isset($consumed_at)) { foreach($consumed_at as $consumed_at) { ?> <option value="<?php echo $consumed_at->consumed_at; ?>"><?php echo $consumed_at->consumed_at; ?></option> <?php }} ?> </select> </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Piece No. :</label> <div class="col-md-7"> <input type="text" class="form-control" id="piece_no" name="piece_no" > </div> </div> </div> </div> <!-- row -2--> <div class="row"> <div class="col-md-12"> <div class="form-group"> <select class="control-label col-md-3" id="in_dc_no" name="in_dc_no" style="height:26px;border: transparent;" > <option value="Invoice No.">Invoice No.</option> <option value="Dc No.">DC No.</option> </select> <div class="col-md-7"> <input type="text" class="form-control" id="in_dc_val" name="in_dc_val" > </div> </div> </div> </div> <!-- row -2--> <input type="hidden" class="form-control" id="tr_id" name="tr_id" class="tr_id" > <div class="row"> <div class="col-md-12"> <div class="form-group"> <label class="control-label col-md-3">Received By :</label> <div class="col-md-7"> <input type="text" class="form-control" id="received_by" name="received_by" value="<?php echo $approved_by; ?>" value="text-transform: uppercase !important" readonly > </div> </div> </div> </div> <!-- row -5--> </div> <div class="modal-footer"> <button class="btn btn-default" data-dismiss="modal">Close</button> <button id="submit_weaving_modal" name="submit" class="btn btn-primary">Submit</button> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <div class="col-sm-12"> <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> <!-- page-content --> </div> <!-- page-content-wrapper --> <script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script> <link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" > <script src="<?php echo base_url(); ?>assets/js/rowedex3.min.js" type="text/javascript"></script> <style> #submit { display:none; } </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(){ $('#rec_weight').on('change keyup', function() { var sanitized = $(this).val().replace(/[^0-9.]/g, ''); $(this).val(sanitized); }); }); $(document).ready(function(){ $('#rec_wt').on('change keyup', function() { var sanitized = $(this).val().replace(/[^0-9.]/g, ''); $(this).val(sanitized); }); }); $(document).ready(function() { $( "#osl_no" ).autocomplete({ source: '<?php echo base_url('out_source/auto_sea_pono'); ?>', }); }); $("#search").click(function(e) { e.preventDefault(); var osl_no =$('#osl_no').val(); // osl_no=document.getElementById("osl_no").value; //alert(osl_no); $.ajax({ url:"<?php echo base_url('out_source/fetch_osl_recived_data');?>", type:"POST", data: {osl_no:osl_no}, success: function (data) { // alert('hai'); var objData = jQuery.parseJSON(data); // alert('hello'); $('#panel_id').val(objData.osl_no.id); $('#osl_num').val(objData.osl_no.osl_no); $('#party_ref').val(objData.osl_no.party_ref); $('#delivery_date').val(objData.osl_no.delivery_date); $('#order_mode').val(objData.osl_no.order_mode); $('#approved_by').val(objData.osl_no.approved_by); grid(); } }); }); </script> <style type="text/css"> .select_product label{ background: #485b7f; color: white; height: 23px; padding-top: 2px; margin-bottom:0; } .select_product input{ background: #e8ecf2; border: transparent; height: 25px; border-bottom: 2px solid white; } @media only screen and (min-width:320px) and (max-width:640px) { .add{ margin-left: 40%; margin-top: 10px; } } </style> <!-- The link to the CSS that the grid needs --> <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'); ?>" /> <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; } .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: 24px !important; padding-left: 24px !important; } .ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td { overflow: hidden; white-space: pre; } .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; } .form-control { height: 29px !important; margin-bottom: 14px; } #search_list2 { display:none; } </style> <script> $(function () { $("#received_date").datepicker({ dateFormat: "dd/mm/yy", changeMonth: true, changeYear: true }); }); </script> <script> function grid(){ var l=$("#panel_id").val(); // alert(l); var ll; jQuery("#list2").jqGrid({ url:"<?php echo base_url('out_source/weaving_goods_details');?>/s"+l+"/", //url:"<?php echo base_url('vendor/vendor_goods_details')?>/s"+l+"/", datatype: "json", colNames:['Id','OSL','Article','Width','Reed','Reed Width','PPC','Quality','Design','Shade','Warp Planned Mtr','Weft Planned Mtr','Weaving Factory','Finished Weight Per Mtr','Piece Length','Ordered Mtrs','Action'], colModel:[ {name:'id',index:'id',hidden:true, editable:true,width:70}, {name:'osl_no',index:'osl_no', width:70,editable:false}, {name:'article',index:'article', width:60,editable:false,editrules:{required: true}}, {name:'width',index:'width', editable:false,editrules:{required: true},width:70}, {name:'reed',index:'reed',editable:false,width:70}, {name:'reed_width',index:'reed_width', width:60,editable:false}, {name:'ppc',index:'ppc', width:60,editable:false,editrules:{required: true}}, {name:'quality',index:'quality', editable:false,editrules:{required: true},width:60}, {name:'design',index:'design', editable:false,width:70}, {name:'shade',index:'shade', width:60,editable:false}, {name:'warp_pland_mtr',index:'warp_pland_mtr', width:60,editable:false}, {name:'weft_pland_mtr',index:'weft_pland_mtr', width:60,editable:false}, {name:'weaving_factory',index:'weaving_factory', editable:false,width:60}, {name:'finished_weight',index:'finished_weight', width:60,editable:false,editrules:{required: true}}, {name:'piece_length',index:'piece_length', editable:false,editrules:{required: true},width:70}, {name:'ordered_mtrs',index:'ordered_mtrs', width:60,editable:false}, {name:'modal',index:'modal',editable:false,editrules:{required: true}, width:90,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='Add Stock' style='margin-left:5px'\>"; }}, ], rowNum:50, rowTotal: 20000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, pager: '#pager2', sortname:'id', viewrecords: true, loadonce:true, gridview: true, onSelectRow: function(id){ if(id && id!==ll){ jQuery('#list2').jqGrid('restoreRow',ll); jQuery('#list2').jqGrid('editRow',id,true); ll=id; } }, editurl: "<?php echo base_url('vendor/edit_received_goods_details');?>", sortorder:"desc", caption:"Weaving Fabric 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 base_url('out_source/weaving_subgrid');?>/s"+row_id+"/", //data:{'sub_id':123}, mtype : "get", datatype: "json", colNames:['Id','Finished Weight','Weaving Factory','Ordered Mtrs','Received Mtrs','Received Date','Location','Piece No.','Invoice/DC','Invoice/DC No.','Received By'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'finished_weight',index:'finished_weight', width:130,editable:true,editrules:{required: true}}, {name:'factory',index:'factory', width:100,editable:true,editrules:{required: true}}, {name:'ordered_mtrs',index:'ordered_mtrs', editable:true,editrules:{required: true},width:100}, {name:'received_mtrs',index:'received_mtrs', editable:true,editrules:{required: true},width:70}, {name:'rec_date', index:'rec_date', width:100,editable:true,editrules:{required: true}}, {name:'location',index:'location', editable:true,editrules:{required: true},width:100}, {name:'piece_no',index:'piece_no', width:102,editable:true,editrules:{required: true}}, {name:'in_dc_no',index:'in_dc_no', width:100,editable:true,editrules:{required: true}}, {name:'in_dc_val',index:'in_dc_val', width:102,editable:true,editrules:{required: true}}, {name:'rec_by',index:'rec_by', width:100,editable:true,editrules:{required: true}}, ], height: 'auto', rowNum:2000000000000000000, sortname: 'num', sortorder: "asc" }); } }); //$("#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:true,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, multipleGroup:true, caption:"search" } ); $("#list2").navButtonAdd('#pager2', { caption:"Delete", buttonicon:"ui-icon-trash", onClickButton: deleteRow, position: "last", title:"", cursor: "pointer", id:"client_delete" } ); } function fun(rowId) { var id = rowId.closest('tr').attr('id'); $('#tr_id').val(id); $.ajax({ url:"<?php echo base_url('out_source/weaving_receive_yarn_quantity')?>", type:"POST", data:{'id':id}, success:function(data){ var objData = jQuery.parseJSON(data); //var obj=objData.work_order_no.dyed_id; var obj1=objData.quantity; var obj2=objData.we_quantity; // //var obj2=objData.material_issue_no; $('#modal_oslno').val(obj1.osl_no); $('#fin_weight').val(obj1.finished_weight); $('#factory').val(obj1.weaving_factory); $('#ord_mtrs').val(obj1.ordered_mtrs); $('#article').val(obj1.article); $('#width').val(obj1.width); $('#shade').val(obj1.shade); $('#design').val(obj1.design); $('#rec_mtrs').val(obj2.received_mtrs); // $('#tr_id').val(obj1.id); // $('#work_order').val(obj1.work_order); // $('#color_code').val(obj1.warp_color); // $('#vendor').val(obj1.vendor); // $('#issue_dyed_qua').val(obj2.issue_net_weight); $('#myModal').modal('show'); } }); } function deleteRow() { // Get the currently selected row var row = $("#list2").jqGrid('getGridParam','selrow'); $("#id").val(row); if( row != null ) $("#list2").jqGrid('delGridRow',row, { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ $.ajax({ url:"<?php echo base_url('vendor/receive_details_delete');?>", type:"POST", data:{'id':row}, async:false, success:function(data){ if(data==""){ alert('Successfully Deleted'); $("#delmodlist2").remove(); $("#list2").trigger("reloadGrid"); window.location.reload(); } else{ alert('Successfully Deleted'); $("#delmodlist2").remove(); $("#list2").trigger("reloadGrid"); window.location.reload(); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } </script> <script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script> <link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" > <script type="text/javascript"> $("#submit_weaving_modal").click(function(e) { e.preventDefault(); //alert(); var modal_oslno =$('#modal_oslno').val(); var fin_weight =$('#fin_weight').val(); var ord_mtrs =$('#ord_mtrs').val(); // alert(ord_mtrs); var rec_mtrs =$('#rec_mtrs').val(); //alert(rec_mtrs); var rec_weight =$('#rec_weight').val(); var received_date =$('#received_date').val(); var consumed_at =$('#consumed_at').val(); var received_by =$('#received_by').val(); var tr_id =$('#tr_id').val(); var factory =$('#factory').val(); var piece_no =$('#piece_no').val(); var in_dc_no =$('#in_dc_no').val(); var article =$('#article').val(); var width =$('#width').val(); var shade =$('#shade').val(); var design =$('#design').val(); var in_dc_val =$('#in_dc_val').val(); var rec_wt =$('#rec_wt').val(); if(rec_mtrs == '') { var r=0; } else { var r=rec_mtrs; } //alert(r); var v=parseFloat(ord_mtrs) - parseFloat(r); // alert(v); //var c=parseFloat(rec_mtrs); if(rec_weight <= v) { $.ajax({ url:"<?php echo base_url('out_source/add_weaving_fabric_details');?>", type:"POST", data:{'design':design,'article':article,'width':width,'shade':shade,'rec_wt':rec_wt,'modal_oslno':modal_oslno,'fin_weight':fin_weight,'ord_mtrs':ord_mtrs,'rec_weight':rec_weight,'received_date':received_date,'consumed_at':consumed_at,'received_by':received_by,'tr_id':tr_id,'factory':factory,'piece_no':piece_no,'in_dc_no':in_dc_no,'in_dc_val':in_dc_val,'rec_mtrs':rec_mtrs}, async:false, success:function(data) { window.location.href = '<?php echo base_url('out_source/weaving_fabric');?>'; //alert('hai'); } }); } else { swal({ title: "Received Mtrs Exceeded", text: "", }); } }); </script> <style> #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; } .ui-jqgrid { text-transform: capitalize !important; } .tablediv { text-transform: uppercase !important; } .ui-jqgrid tr.jqgrow td{ text-transform: uppercase !important; } .jqgfirstrow { height: 0px !important; } </style> <style> @media only screen and (min-width:320px) and (min-height:640px){ #gbox_list2{ width:1100px !important; } #gview_list2{ width:100% !important; } .ui-jqgrid-hdiv{ width:100% !important; } .ui-jqgrid-htable{ width:100% !important; } #list2{ width:100% !important; } } </style>