EVOLUTION-NINJA
Edit File: stock_analysis.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> #refresh_list6 { display:none !important; } #refresh_list4 { display:none !important; } #refresh_list5 { display:none !important; } .ui-jqgrid { text-transform: capitalize !important; } .tablediv { text-transform: uppercase !important; } .ui-jqgrid tr.jqgrow td{ text-transform: uppercase !important; } table, th, td { border:1px solid black; } </style> <div class="page-content-wrapper"> <div class="page-content"> <!-- BEGIN PAGE HEADER--> <h3 class="page-title"> Yarn - Raw Stock Details </h3> <div class="page-bar"> <ul class="page-breadcrumb"> <li><i class="fa fa-home"></i> <a href="<?php echo base_url(); ?>dashboard/dashboard_fun">Home</a> <i class="fa fa-angle-right"></i> <a href="#" > Stock Value Analysis </a></li> </ul> </div> <input type="hidden" id="preview_id" class="preview_id" value="<?php if(empty($access_row)){ } else { echo $access_row->preview_id; } ?>" > <input type="hidden" id="edit_id" class="edit_id" value="<?php if(empty($access_row)){ } else { echo $access_row->edit_id; } ?>" > <input type="hidden" id="edit_row_id" class="edit_row_id" value="<?php if(empty($user_type_id)){ } else { echo $user_type_id; } ?>" > <?php function writeamout($amount) { $formatter = new NumberFormatter('en_IN', NumberFormatter::CURRENCY); $formattedAmount = $formatter->formatCurrency($amount, 'INR'); echo $formattedAmount; } writeamout(322333); //function writeamout($amount){ // setlocale(LC_MONETARY, 'en_IN'); //$amount = money_format('%!i', $amount); // echo $amount; //} // writeamout('322333') ?> <div class="row"> <label>CONSOLIDATED</label> <table style="width:100%"> <th> Type </th> <th> Quantity </th> <th> Value In INR </th> <th> Total Quantity </th> <th> Total Value In INR </th> <?php $total_fabric_value = 0; $total_fabric_quantity = 0; $total_raw_value = 0; $total_raw_quantity = 0; $total_twisting_value = 0; $total_twisting_quantity = 0; $total_dyed_yarn_value = 0; $total_dyed_yarn_quantity = 0; $total_sdyed_yarn_value = 0; $total_sdyed_yarn_quantity = 0; ?> <tr> <td> FABRIC </td> <td> <?php $total_fabric_value += $fabric_2020[0]->val; $total_fabric_value += $fabric_2021[0]->val; $total_fabric_value += $fabric_2022[0]->val; $total_fabric_value += $fabric_2023[0]->val; $total_fabric_value += $fabric_2024[0]->val; $total_fabric_quantity += $fabric_2020[0]->qty; $total_fabric_quantity += $fabric_2021[0]->qty; $total_fabric_quantity += $fabric_2022[0]->qty; $total_fabric_quantity += $fabric_2023[0]->qty; $total_fabric_quantity += $fabric_2024[0]->qty; ?> </td> <td> </td> </tr> <tr> <td> Older Than 2020 </td> <td> <?php $j = $fabric[0]->qty - $total_fabric_quantity; $k = number_format(($j), 2, '.', ''); echo writeamout($k). ' Mtrs'; ?> </td> <td> <?php $i = $fabric[0]->val - $total_fabric_value; $k = number_format(($i), 2, '.', ''); echo writeamout($k); ?> </td> </tr> <tr> <td> 2020 </td> <td> <?php echo writeamout(number_format((float)$fabric_2020[0]->qty, 2, '.', '')).' Mtrs';?> </td> <td> <?php echo writeamout(number_format((float)$fabric_2020[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2021 </td> <td> <?php echo writeamout(number_format((float)$fabric_2021[0]->qty, 2, '.', '')).' Mtrs';?> </td> <td> <?php echo writeamout(number_format((float)$fabric_2021[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2022 </td> <td> <?php echo writeamout(number_format((float)$fabric_2022[0]->qty, 2, '.', '')).' Mtrs';?> </td> <td> <?php echo writeamout(number_format((float)$fabric_2022[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2023 </td> <td> <?php echo writeamout(number_format((float)$fabric_2023[0]->qty, 2, '.', '')).' Mtrs';?> </td> <td> <?php echo writeamout(number_format((float)$fabric_2023[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2024 </td> <td> <?php echo writeamout(number_format((float)$fabric_2024[0]->qty, 2, '.', '')).' Mtrs';?> </td> <td> <?php echo writeamout(number_format((float)$fabric_2024[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> <?php echo writeamout(number_format((float)$fabric[0]->qty, 2, '.', '')).' Mtrs';?> </td> <td> <?php echo writeamout(number_format((float)$fabric[0]->val, 2, '.', '')); ?> </td> </tr> <tr> <td colspan = "5">----------------------------------</td> </tr> <td> YARN RAW </td> <td> <?php $total_raw_value += $yarn_raw_2020[0]->val; $total_raw_value += $yarn_raw_2021[0]->val; $total_raw_value += $yarn_raw_2022[0]->val; $total_raw_value += $yarn_raw_2023[0]->val; $total_raw_value += $yarn_raw_2024[0]->val; $total_raw_quantity += $yarn_raw_2020[0]->qty; $total_raw_quantity += $yarn_raw_2021[0]->qty; $total_raw_quantity += $yarn_raw_2022[0]->qty; $total_raw_quantity += $yarn_raw_2023[0]->qty; $total_raw_quantity += $yarn_raw_2024[0]->qty; ?> </td> <td> </td> </tr> <tr> <td> Older Than 2020 </td> <td> <?php $j = $yarn_raw[0]->qty - $total_raw_quantity; echo writeamout(number_format($j, 2, '.', '')).' Kgs';?> </td> <td> <?php $i = $yarn_raw[0]->val - $total_raw_value; echo writeamout(number_format($i, 2, '.', ''));?> </td> </tr> <tr> <td> 2020 </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2020[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2020[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2021 </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2021[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2021[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2022 </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2022[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2022[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2023 </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2023[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2023[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2024 </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2024[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_raw_2024[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> <?php echo writeamout(number_format((float)$yarn_raw[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_raw[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td colspan = "5">----------------------------------</td> </tr> <td> YARN Twisting </td> <td> <?php $total_twisting_value += $yarn_twisting_2020[0]->val; $total_twisting_value += $yarn_twisting_2021[0]->val; $total_twisting_value += $yarn_twisting_2022[0]->val; $total_twisting_value += $yarn_twisting_2023[0]->val; $total_twisting_value += $yarn_twisting_2024[0]->val; $total_twisting_quantity += $yarn_twisting_2020[0]->qty; $total_twisting_quantity += $yarn_twisting_2021[0]->qty; $total_twisting_quantity += $yarn_twisting_2022[0]->qty; $total_twisting_quantity += $yarn_twisting_2023[0]->qty; $total_twisting_quantity += $yarn_twisting_2024[0]->qty; ?> </td> <td> </td> </tr> <tr> <td> Older Than 2020 </td> <td> <?php $j = $yarn_twisting[0]->qty - $total_twisting_quantity; echo writeamout(number_format($j, 2, '.', '')).' Kgs';?> </td> <td> <?php $i = $yarn_twisting[0]->val - $total_twisting_value; echo writeamout(number_format($i, 2, '.', ''));?> </td> </tr> <tr> <td> 2020 </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2020[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2020[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2021 </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2021[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2021[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2022 </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2022[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2022[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2023 </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2023[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2023[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2024 </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2024[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting_2024[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$yarn_twisting[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td colspan = "5">----------------------------------</td> </tr> <td> YARN DYED </td> <td> <?php $total_dyed_yarn_value += $dyed_yarn_2020[0]->val; $total_dyed_yarn_value += $dyed_yarn_2021[0]->val; $total_dyed_yarn_value += $dyed_yarn_2022[0]->val; $total_dyed_yarn_value += $dyed_yarn_2023[0]->val; $total_dyed_yarn_value += $dyed_yarn_2024[0]->val; $total_dyed_yarn_quantity += $dyed_yarn_2020[0]->qty; $total_dyed_yarn_quantity += $dyed_yarn_2021[0]->qty; $total_dyed_yarn_quantity += $dyed_yarn_2022[0]->qty; $total_dyed_yarn_quantity += $dyed_yarn_2023[0]->qty; $total_dyed_yarn_quantity += $dyed_yarn_2024[0]->qty; ?> </td> <td> </td> </tr> <tr> <td> Older Than 2020 </td> <td> <?php $j = $dyed_yarn[0]->qty - $total_dyed_yarn_quantity; echo writeamout(number_format($j, 2, '.', '')).' Kgs';?> </td> <td> <?php $i = $dyed_yarn[0]->val - $total_dyed_yarn_value; echo writeamout(number_format($i, 2, '.', ''));?> </td> </tr> <tr> <td> 2020 </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2020[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2020[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2021 </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2021[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2021[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2022 </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2022[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2022[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2023 </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2023[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2023[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2024 </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2024[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn_2024[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$dyed_yarn[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td colspan = "5">----------------------------------</td> </tr> <td> SWAN YARN DYED </td> <td> <?php $total_sdyed_yarn_value += $swan_yarn_dyed_2020[0]->val; $total_sdyed_yarn_value += $swan_yarn_dyed_2021[0]->val; $total_sdyed_yarn_value += $swan_yarn_dyed_2022[0]->val; $total_sdyed_yarn_value += $swan_yarn_dyed_2023[0]->val; $total_sdyed_yarn_value += $swan_yarn_dyed_2024[0]->val; $total_sdyed_yarn_quantity += $swan_yarn_dyed_2020[0]->qty; $total_sdyed_yarn_quantity += $swan_yarn_dyed_2021[0]->qty; $total_sdyed_yarn_quantity += $swan_yarn_dyed_2022[0]->qty; $total_sdyed_yarn_quantity += $swan_yarn_dyed_2023[0]->qty; $total_sdyed_yarn_quantity += $swan_yarn_dyed_2024[0]->qty; ?> </td> <td> </td> </tr> <tr> <td> Older Than 2020 </td> <td> <?php $j = $swan_yarn_dyed[0]->qty - $total_sdyed_yarn_quantity; echo writeamout(number_format($j, 2, '.', '')).' Kgs';?> </td> <td> <?php $i = $swan_yarn_dyed[0]->val - $total_sdyed_yarn_value; echo writeamout(number_format($i, 2, '.', ''));?> </td> </tr> <tr> <td> 2020 </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2020[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2020[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2021 </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2021[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2021[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2022 </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2022[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2022[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2023 </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2023[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2023[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> 2024 </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2024[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed_2024[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed[0]->qty, 2, '.', '')).' Kgs';?> </td> <td> <?php echo writeamout(number_format((float)$swan_yarn_dyed[0]->val, 2, '.', ''));?> </td> </tr> <tr> <td></td> <td></td> <td>GRAND TOTAL</td> <td><?php echo writeamout(number_format(( (float)$fabric[0]->qty + (float) $yarn_raw[0]->qty + (float) $yarn_twisting[0]->qty + (float) $dyed_yarn[0]->qty + (float)$swan_yarn_dyed[0]->qty), 2, '.', ''));?> </td> <td><?php echo writeamout(number_format(( (float)$fabric[0]->val + (float) $yarn_raw[0]->val + + (float) $yarn_twisting[0]->val + (float) $dyed_yarn[0]->val +(float)$swan_yarn_dyed[0]->val), 2, '.', ''));?> </td> </tr> </table> </div> <br><br> <!--<input type="text" id="location" class="location" name="location" value="all" >--> <input type="hidden" id="yarn_type" class="yarn_type" name="yarn_type" value="raw_yarn"> <input type="hidden" id="location" class="location" name="location" value="all" > <input type="hidden" id="yarn_type" class="yarn_type" name="yarn_type" value="raw_yarn"> </div> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="export_table" class="export_table"></table></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'); ?>" /> <!-- End BEGIN CONTAINER --> <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); $(".formids").submit(); }); function export_page() { id = jQuery("#list3").jqGrid('getDataIDs'); var type= $('#type').val(); $.ajax({ type : 'post', url:"<?php echo base_url('out_source/fetch_yarn_raw_data')?>", data : {id:id}, success:function(data){ response=jQuery.parseJSON(data); //alert(d); console.log(response); var count =1; $('.export_table').empty(); var received_qty=0; rec_weight =0; issue_net_weight=0; issue_gross_weight=0; variance_mtrs=0; var content = ''; content +='<thead><tr><th><b>SL NO.</b></th><th><b>Purpose</b></th><th><b>Yarn Details</b></th> <th><b>Yarn Denier</b></th> <th><b>Yarn Specification</b></th> <th><b>SSL Shade</b></th> <th><b>Shade</b></th><th><b>Lot</b></th> <th><b>Bale</b></th> <th><b>Gross Weight</b></th> <th><b>Net Weight</b></th> <th><b>PO#</b></th> <th><b>Rate</b></th><th><b>Location</b></th><th><b>Received Date</b></th></tr></thead>'; $.each(response,function(key,vas){ issue_gross_weight +=parseFloat(vas.issue_gross_weight); issue_net_weight +=parseFloat(vas.issue_net_weight); content +='<tr><td>'+count+'</td> <td>'+vas.purpose+'</td> <td>'+vas.yarnname+'</td> <td>'+vas.yarndenier+'</td> <td>'+vas.yarnspecification+'</td><td>'+vas.ssl_shade+'</td> <td>'+vas.shades+'</td><td>'+vas.lot+'</td> <td>'+vas.bale+'</td><td>'+vas.issue_gross_weight+'</td><td>'+vas.issue_net_weight+'</td><td>'+vas.po_no+'</td><td>'+vas.unit+'</td><td>'+vas.consumed_at+'</td><td>'+vas.rec_date+'</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>'+issue_gross_weight+'</b></th><th><b>'+issue_net_weight+'</b></th><th></th><th></th><th></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 || ('Yarn - Raw 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 export_page_list() { id = jQuery("#list3").jqGrid('getDataIDs'); var type= $('#type').val(); $.ajax({ type : 'post', url:"<?php echo base_url('out_source/fetch_yarn_raw_data')?>", data : {id:id}, success:function(data){ response=jQuery.parseJSON(data); //alert(d); console.log(response); var count =1; $('.export_table').empty(); var received_qty=0; rec_weight =0; issue_net_weight=0; issue_gross_weight=0; variance_mtrs=0; var content = ''; content +='<thead><tr><th><b>SL NO.</b></th><th><b>Purpose</b></th><th><b>Yarn Details</b></th> <th><b>Yarn Denier</b></th> <th><b>Yarn Specification</b></th> <th><b>SSL Shade</b></th> <th><b>Shade</b></th><th><b>Lot</b></th> <th><b>Bale</b></th> <th><b>Gross Weight</b></th> <th><b>Net Weight</b></th> <th><b>Location</b></th><th><b>Received Date</b></th></tr></thead>'; $.each(response,function(key,vas){ issue_gross_weight +=parseFloat(vas.issue_gross_weight); issue_net_weight +=parseFloat(vas.issue_net_weight); content +='<tr><td>'+count+'</td> <td>'+vas.purpose+'</td> <td>'+vas.yarnname+'</td> <td>'+vas.yarndenier+'</td> <td>'+vas.yarnspecification+'</td><td>'+vas.ssl_shade+'</td> <td>'+vas.shades+'</td><td>'+vas.lot+'</td> <td>'+vas.bale+'</td><td>'+vas.issue_gross_weight+'</td><td>'+vas.issue_net_weight+'</td><td>'+vas.consumed_at+'</td><td>'+vas.rec_date+'</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>'+issue_gross_weight+'</b></th><th><b>'+issue_net_weight+'</b></th><th></th><th></th></tr>'; $('.export_table').append(content); export_data(); pdf_download(); } }); } function export_data() { //alert(); $("#export_table").table2excel({ exclude: ".noExl", name: "Excel Document Name", filename: "Yarn - Raw Stock Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } // function pdf_download() // { // alert(); // var options = { // }; // var pdf = new jsPDF('p', 'pt', 'a4'); // pdf.addHTML($("#export_table"), 0, 0, options, function() { // pdf.save('inspected_fabric.pdf'); // }); // } $("#export").on("click", function(){ $("#list3").jqGrid("exportToHtml",{ includeLabels : true, includeGroupHeader : true, includeFooter: true, autoPrint : true }); }); $(function(){ $(".from_delivery_date_required_on").datepicker({ dateFormat: 'dd-mm-yy', }).on('changeDate', function(ev){ $('.from_delivery_date_required_on').datepicker('hide'); }); }); $('.from_delivery_date_required_on').on('change', function(){ var date = $(this).val(); $('.to_delivery_date_required_on').datepicker({ dateFormat: 'dd-mm-yy', minDate: date, }); }); </script> <script> </script> <style> #ui-datepicker-div { z-index: 1000 !important; } .date_row { padding-bottom: 3%; } .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; } @media only screen and (min-width:320px) and (max-width:640px) { } </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; padding-right: 22px !important; padding-left: 23px !important; margin-top: 4px !important; color:bold !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> <!----------------------------------access controll -------------------------------> </script> <style> #refresh_list4,#refresh_list5 { display:none !important; } .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'); ?>', }); }); $(document).ready(function() { var user=$("#edit_row_id").val(); if(user > 2) { $("#list3").hideCol("myac"); } }); 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> #jaytab{ width:100%; overflow:auto; } } #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; } .radio-list { margin-left:7% !important; } #table_pending_indent{ overflow-x: scroll; } #jaytab{ margin-top: 0 !important; margin-left: 0 !important; overflow-x: scroll; width: 600px !important; padding-left: 0 !important; } #jaytab1 { margin-top: 0 !important; margin-left: 0 !important; overflow-x: scroll; width: 300px !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>