EVOLUTION-NINJA
Edit File: dc_weaving_work_order_grid.php
<style> .ui-jqgrid { text-transform: capitalize !important; } .tablediv { text-transform: uppercase !important; } .ui-jqgrid tr.jqgrow td{ text-transform: uppercase !important; } </style> <div class="page-content-wrapper"> <div class="page-content"> <!-- BEGIN PAGE HEADER--> <h3 class="page-title"> Weaving Work Order Details </h3> <?php $this->load->view('templates/nav_menu'); ?> <?php if(empty($access_row)) { } else { if($access_row->insert_id == '1') { ?> <form action="<?php echo base_url(); ?>out_source/create_weaving_work_order" method="post" class="form-horizontal"> <b>To insert data click here:</b> <input type="submit" name="Insert" value="Insert" /><br><br> </form> <?php } else { ?> <?php } }?> <input type="hidden" id="preview_id" class="preview_id" value="<?php if(empty($access_row)) { } else { echo $access_row->preview_id; } ?>" > <!--<div class="radio-list" style="margin-left: 2%;"> <label class="radio-inline"> <input type="radio" checked="checked" name="planningorder" id="planningorder" onclick="planningtypes('indent_pending')" /> Pending Indent </label> <label class="radio-inline"> <input type="radio" name="planningorder" id="planningorder" onclick="planningtypes('approved_indent')" /> Approved Indent</label> </div><br>--> <div id="table_approved_indent"> <div id = "jaytab" class="jaytab"> <table id="list3"></table> <div id="pager3"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <!--<div id="table_approved_indent"> <div id = "jaytab" class="jaytab"> <table id="list3"></table> <div id="pager3"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div>--> </div> <!-- modal content Modal --> <div id="content_modal" class="modal fade"> <div class="modal-dialog"> <div class="modal-content" class="workorder_application"> <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# :</label> <div class="col-md-7"> <input type="text" class="form-control" id="osl_num" name="osl_num" class="osl_num" style="margin-bottom: 12px;" 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">Issued Number :</label> <div class="col-md-7"> <input type="text" class="form-control" id="issued_num" name="issued_num" class="issued_num" style="margin-bottom: 12px;" 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">Yarn Quality :</label> <div class="col-md-7"> <input type="text" class="form-control" id="yarn_qua" name="yarn_qua" class="yarn_qua" style="margin-bottom: 12px;" 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">Yarn Name :</label> <div class="col-md-7"> <input type="text" class="form-control" id="yarn_name" name="yarn_name" class="yarn_name" style="margin-bottom: 12px;" 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">Yarn Denier :</label> <div class="col-md-7"> <input type="text" class="form-control" id="yarn_den" name="yarn_den" class="yarn_den" style="margin-bottom: 12px;" 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">Yarn Specification :</label> <div class="col-md-7"> <input type="text" class="form-control" id="yarn_spec" name="yarn_spec" class="yarn_spec" style="margin-bottom: 12px;" 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">Color Code :</label> <div class="col-md-7"> <input type="text" class="form-control" id="color_code" name="color_code" class="color_code" style="margin-bottom: 12px;" 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">Dyed Weight :</label> <div class="col-md-7"> <input type="text" class="form-control" id="dyed_wt" name="dyed_wt" class="dyed_wt" style="margin-bottom: 12px;" readonly> <input type="hidden" class="form-control" id="stock_id" name="stock_id" style="margin-bottom: 12px;" class="stock_id" 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">Bag # :</label> <div class="col-md-7"> <input type="text" class="form-control" id="bag" name="bag" style="margin-bottom: 12px;" class="bag" > </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">Remnant :</label> <div class="col-md-7"> <input type="text" class="form-control" id="rec_rements" name="rec_rements" style="margin-bottom: 12px;" class="rec_rements" > </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">Location :</label> <div class="col-md-7"> <select id="location" name="location" style="width: 197px; padding-top: 4px; padding-bottom: 5px; font-size: 14px; font-weight: normal; color: #333; background-color: #fff; border: 1px solid #e5e5e5; box-shadow: none; transition: border-color ease-in-out .15s, box-shadow ease-in-out .15s;"> <option value="">Select Location</option> <?php if(isset($consumed_at)) { foreach($consumed_at as $consumed_at) { ?> <option value="<?php echo $consumed_at->consumed_at; ?>" <?php if($consumed_at->consumed_at == 'NANDI') {echo "selected";}?>><?php echo $consumed_at->consumed_at; ?></option> <?php }} ?> </select> </div> </div> </div> </div> <!-- row -2--> </div> <div class="modal-footer"> <button class="btn btn-default" data-dismiss="modal">Close</button> <button id="submit_modal" name="submit" onclick="rements_submit_function()" class="btn btn-primary">Submit</button> </div> </div> <!-- /.modal-content --> </div> </div> </div> </div> <!-- End BEGIN CONTAINER --> <!-- BEGIN FOOTER --> <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" > <!-- The link to the CSS that the grid needs --> <!-- 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; } #refresh_list3 { display:none !important; } </style> <script> function getDesignAndQuality(articleNo) { $.ajax({ type: "post", url: "<?php echo base_url(); ?>marketing/getDesignAndQuality", data: "articleNo=" + articleNo, success: function (data) { var objData = jQuery.parseJSON(data); document.getElementById("design").value = objData.design; document.getElementById("quality").value = objData.quality; } }); } </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> $(document).ready(function (){ //var l=$("#loc").val(); //alert(l); jQuery("#list3").jqGrid({ url:"<?php echo base_url('out_source/work_order_weaving_grid_details')?>", datatype: "json", colNames:['Id','Work Order','Vendor Name','Date','Comment','Preview','Confirm','Status'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'work_order_num',index:'work_order_num', width:210,editable:false}, {name:'vendor',index:'vendor', width:210,editable:true,editrules:{required: true}}, {name:'date',index:'date', editable:true,editrules:{required: true},width:210}, {name:'comment',index:'comment', editable:true,editrules:{required: true},width:210}, {name:' ',index:' ',align: "center",editable:false,editrules:{required: true}, width:175,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_deying_preview($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='PREVIEW' onclick='' \>"; }}, {name: 'confirm_check', index: 'confirm_check', width: 115, align: 'center', formatter: 'checkbox', editoptions: { value: '1:0' }, formatoptions: { disabled: false }, cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="confirm_fun($(this))" '; } }, {name:'confirm_status',index:'confirm_status', editable:true,editrules:{required: true},width:210}, ], height: 'auto', rowNum:50, rowTotal: 20000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, rownumWidth: 40, pager:"#pager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", loadonce:true, caption:"Work Order 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_material_subgrid');?>/s"+row_id+"/", //data:{'sub_id':123}, mtype : "get", datatype: "json", colNames:['Id','OSL Number','Issued Number','Yarn Quality','Yarn Name','Yarn Denier','Yarn Specification','Color Code','Dyed Weight','Created By','Remnants'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'osl_no',index:'osl_no', width:100,editable:true,editrules:{required: true}}, {name:'issue_no',index:'issue_no', width:100,editable:true,editrules:{required: true}}, // {name:'yarn_type',index:'yarn_type', width:90,editable:true,editrules:{required: true}}, {name:'yarn_quality',index:'yarn_quality', width:152,editable:true,editrules:{required: true}}, {name:'yarn_name',index:'yarn_name', width:100,editable:true,editrules:{required: true}}, {name:'yarn_denier',index:'yarn_denier', width:100,editable:true,editrules:{required: true}}, {name:'yarn_specification',index:'yarn_specification', editable:true,editrules:{required: true},width:130}, {name:'color_code',index:'color_code', editable:true,editrules:{required: true},width:100}, {name:'dyed_weight',index:'dyed_weight', editable:true,editrules:{required: true},width:100}, {name:'created_by',index:'created_by', editable:true,editrules:{required: true},width:100}, {name:'',index:'',align: "center",editable:false,editrules:{required: true}, width:200,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="fun_rements($(this))" '; },formatter:function (cellvalue, options, rowObject) { return "<input type='button' class='fa fa-eye' value='Remnants' \>"; }}, ], height: 'auto', rowNum:2000000000000000, sortname: 'num', sortorder: "asc" }); } }); //$("#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 } ); }); function fun_deying_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("out_source/weaving_deying_preview"); ?>', data:{'as':as}, async:false, success:function() { window.location.href = '<?php echo base_url('out_source/weaving_deying_preview');?>/'+ '?id='+as; } }); } else { swal({ title: "You Don't Have Access For This Preview", text: "", }); } } function fun(rowId) { var id = rowId.closest('tr').attr('id'); var as=id; //alert(as); $.ajax({ type:'post', url:'<?php echo base_url("out_source/outsource_deying_addstock"); ?>', data:{'as':as}, async:false, success:function() { window.location.href = '<?php echo base_url('out_source/outsource_deying_addstock');?>/'+ '?id='+as; } }); } function fun_rements(rowId) { var id = rowId.closest('tr').attr('id'); var as=id; $.ajax({ type:'post', url:'<?php echo base_url("out_source/fetch_yarn_remnants"); ?>', data:{'as':as}, async:false, success: function (data) { var obj = jQuery.parseJSON(data); if(obj.res == 1) { swal({ title: "This Status Is Already Completed, You Can't Add Remnants", text: "", }); } else { var objData = obj.results; $('#osl_num').val(objData.osl_no); $('#issued_num').val(objData.issue_no); $('#yarn_qua').val(objData.yarn_quality); $('#yarn_name').val(objData.yarn_name); $('#yarn_den').val(objData.yarn_denier); $('#yarn_spec').val(objData.yarn_specification); $('#color_code').val(objData.color_code); $('#dyed_wt').val(objData.dyed_weight); $('#stock_id').val(objData.id); $('#rec_rements').val(objData.remnants); $('#location').val(objData.rem_location); $('#bag').val(objData.bag); //var bag=$('#bag').val(''); $('#content_modal').modal('show'); } } }); } function confirm_fun(rowId) { // var v=$('#approval_id').val(); // if(v == 1) // { var id = rowId.closest('tr').attr('id'); //alert(id); var confirmMsg= confirm("Do You Want To Confirm!"); if (confirmMsg==true) { swal({ title: 'Remarks', input: 'text', showCancelButton: true, confirmButtonText: 'Submit', showLoaderOnConfirm: true, }).then(function (email) { $.ajax({ //alert(email); url:"<?php echo base_url('out_source/outsource_add_yes_confirmation')?>", type:"POST", data:{'id':id,'remarks':email}, success:function(data){ if(data==""){ $("#editmodlist3").remove(); $("#list3").trigger("reloadGrid"); $("#jaytab").trigger("reloadGrid"); $("#jqGrid").trigger("reloadGrid"); //window.location.reload(); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } else{ $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); swal({ type: 'success', // title: 'Approved By', // html: '' + email }) }) } else if (confirmMsg==false) { $.ajax({ url:"<?php echo base_url('out_source/outsource_add_no_confirmation')?>", type:"POST", data:{'id':id}, success:function(data){ if(data==""){ $("#editmodlist3").remove(); $("#list3").trigger("reloadGrid"); //window.location.reload(); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } else{ $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); } // } // else // { // swal({ // title: "You Don't Have Access For This Approval", // text: "", // }); // $( ".check" ).prop( "checked", false ); // $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); // } } </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> $(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> <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> function rements_submit_function() { var stock_id=$('#stock_id').val(); var bag=$('#bag').val(); var rec_rements=$('#rec_rements').val(); var location=$('#location').val(); if(bag == '') { swal({ title: "Please Enter Bag Feild", text: "", }); $('#content_modal').modal('toggle'); } else { $.ajax({ url:"<?php echo base_url('out_source/insert_rements_outsource_data');?>", type:"POST", data:{'location':location,'stock_id':stock_id,'rec_rements':rec_rements,'bag':bag}, async:false, success:function(data){ $('#content_modal').modal('toggle'); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } }); } } </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_list3{ width:1052px !important; } #gview_list3{ width:100% !important; } .ui-jqgrid-hdiv{ width:100% !important; } .ui-jqgrid-htable{ width:100% !important; } #list3{ width:100% !important; } } </style>