EVOLUTION-NINJA
Edit File: overdue_statement.php
<!DOCTYPE HTML> <html lang="en-US"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <title>Yaskawa Overdue Statement Import</title> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/main.css');?>" /> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/bootstrap.min.css');?>" /> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/font-awesome.min.css');?>" /> <link href="https://fonts.googleapis.com/css?family=Roboto" rel="stylesheet"> <script type="text/javascript" src="<?php echo base_url('assets/js/jquery-2.2.4.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/bootstrap.min.js');?>"></script> <!-- This is the Javascript file of jqGrid --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc. <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('ui.jqgrid-bootstrap-ui.css'); ?>" /> <script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <style type="text/css"> .form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus { border-color: #FF0000; box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6); } #editmodlist2 { //height: 232px !important; width: 326px !important; } #FrmGrid_list2 { width: 100% !important; } .ui-jqdialog .ui-jqdialog-titlebar { height: 29px !important; background-color: green; color: white; padding-left: 10px; } .fm-button { height: 21px !important; padding: 1px; margin-right: 10px !important; height: 21px !important; width: 43%; margin-top: -7px !important; } .ui-jqdialog-content td.navButton { padding-top: 12px !important; } .ui-jqgrid .ui-jqgrid-titlebar { height: 27px !important; background-color: #2A4474 !important; color:white !important; } .ui-jqgrid-bdiv { height: 232px !important; } .ui-widget-overlay { z-index:0 !important; } </style> </head> <body> <header class="cf"> <div class="container"> <div class="logo col-md-4"> <a href="" class="hidden-xs hidden-sm"><img src="<?php echo base_url('assets/img/yaskawa_logo.png');?>" class="img-responsive"></a> <a href="" class="hidden-md hidden-lg"><img src="<?php echo base_url('assets/img/yaskawa_logo2.png');?>" class="img-responsive center-block"></a> </div> <div class="navigation col-md-8"> <nav> <a href="javascript:void(0)" class="smobitrigger ion-navicon-round"><span>Menu</span></a> <ul class="mobimenu"> <?php if($details->role == 2) { if($details->department == 4) {?> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Information <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/inventory_import');?>">Stock Updates</a></li> <li><a href="<?php echo site_url('controller/po_import');?>">PO Acknowledgemets</a></li> </ul> </li> <li><a href="<?php echo site_url('controller/news');?>" class="active">News</a></li>                       <?php }elseif($details->department == 5) {?> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown" class="active">Financials <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/outstanding_statement');?>">Outstanding Statement</a></li> <li><a href="<?php echo site_url('controller/overdue_statement');?>">Overdue Statement</a></li> <li><a href="<?php echo site_url('controller/c_forms');?>">C forms</a></li> </ul> </li> <li><a href="<?php echo site_url('controller/news');?>" class="active">News</a></li>                       <?php }elseif($details->department == 6) {?> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Technical Support <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/drive_mannual_upload');?>">Drive Catalogues</a></li> <li><a href="<?php echo site_url('controller/case_stories_upload');?>">Case Stories</a></li> </ul> </li> <li><a href="<?php echo site_url('controller/news');?>" >News</a></li>                       <?php }elseif($details->department == 7) {?> <li><a href="<?php echo site_url('controller/news_upload');?>">News</a></li> <?php } } elseif ($details->role == 3) {?> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Information <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/stock_updates');?>">Stock Updates</a></li> <li><a href="<?php echo site_url('controller/po_acknowledgemets');?>">PO Acknowledgemets</a></li> </ul> </li> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown" class="active">Financials <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/outstanding_statements_display');?>">Outstanding Statement</a></li> <li><a href="<?php echo site_url('controller/overdue_statements_display');?>">Overdue Statement</a></li> <li><a href="<?php echo site_url('controller/c_forms_display');?>">C forms</a></li> </ul> </li> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Technical Support <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/drive_catalogues');?>">Drive Catalogues</a></li> <li><a href="<?php echo site_url('controller/case_stories');?>">Case Stories</a></li> </ul> </li> <li><a href="<?php echo site_url('controller/news');?>">News</a></li>                       <?php }?> <ul class="navbar-right"> <li><a href="<?php echo site_url('controller/profile');?>">Profile</a></li> <li><a href="<?php echo site_url('controller/logout');?>">Logout</a></li> </ul> </ul> </nav> </div> </div> </header> <!---- Nav END -----------------------------------------------------------------------------> <div class="outstanding-banner"> </div> <!---- Banner END -----------------------------------------------------------------------------> <div class="middle_work_hedding"> <div class="container"> <h3><em>Overdue Statement Import</em></h3> </div> </div> <!---- middle_work_hedding END ----------------------------------------------------------------------------> <div class="mid-inventory-improt"> <div class="container"> <form action="<?php echo site_url('controller/importie'); ?>" method="post" class="file-uploader"name="upload_excel" enctype="multipart/form-data"> <a href="<?php echo site_url("controller/download3"); ?>" style="padding-left:20px" >Download .XLS file format</a> <div class="file-uploader__message-area"> <p>Import CSV/Excel File</p> </div> <div class="file-chooser"> <input type="file" name="file" id="file" class="file-chooser__input"> </div> <button type="submit" id="submit" name="import" class="btn btn-primary button-loading file-uploader__submit-button button-loading">Upload</button> </form> </div> </div> <div class="middle_work_table"> <div class="container"> <div class="col-lg-12 table-responsive"> <div id = "jaytab" style="width: 1100px; margin-top:3%;"> <p>Last Updated Date and Time is : <?php if(empty($time)) { echo "Data not found"; }else{ echo $time->createdate; } ?></p> <table id="list2"></table> <div id="pager2"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> <div class="row" style="padding-bottom:20px;"></div> </div> </div> </div> <!---- middle_work_table END ----------------------------------------------------------------------------> <div class="height-50"></div> <footer class=" navbar-fixed-bottom"> <div class="top-bg"> <div class="container"> <ul class="top_marqu"> <li><a href="tel:+91-9731676611"><i class="fa fa-mobile" aria-hidden="true"></i> : +91 9731676611</a></li> <li><a href="mailto:services@yaskawa.in"><i class="fa fa-envelope-o" aria-hidden="true"></i> : services@yaskawa.in</a></li> <li><a href=""> | </a></li> <li><a href="tel:+91-9711351351">North <i class="fa fa-mobile" aria-hidden="true"></i> : +91 9711351351</a></li> <li><a href="tel:+91-9620512399">South <i class="fa fa-mobile" aria-hidden="true"></i> : +91 9620512399</a></li> </ul> </div> </div> </footer> </body> </html> <script> $(document).ready(function (){ //var l=$("#loc").val(); //alert(l); jQuery("#list2").jqGrid({ url:"<?php echo site_url('controller/overdue_insert');?>", datatype: "json", colNames:['SI','Partner Code','Partner Name', 'Invoice Number','Invoice Ref. No','Invoice Date','Invoice Value (INR)','Due Date'], colModel:[ {name:'id',index:'id', width:150, hidden:true,key:true,editable:true}, {name:'partner_code',index:'partner_code', width:150,editable:true,editoptions:{size:25}}, {name:'partner_name',index:'partner_name', width:250,editable:true,editoptions:{size:25}}, {name:'invoice_number',index:'invoice_number', width:200,editable:true,editrules:{required:true},editoptions:{size:25}}, {name:'invoice_ref_no',index:'invoice_ref_no', width:150,editable:true,editoptions:{size:50}}, {name:'invoicedate',index:'invoicedate', width:150,editable:true,editoptions:{size:25}}, {name:'invoice_value',index:'invoice_value', width:150,editable:true,editoptions:{size:25}}, {name:'due_date',index:'due_date', width:150,editable:true,editoptions:{size:25}}, ], rowNum:50, rowTotal: 2000, rowList : [50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager2", sortname:'id', viewrecords: true, loadonce:true, gridview: true, autowidth: true, sortorder:"desc", caption:"Overdue Statement" }); $("#list2").jqGrid('filterToolbar',{searchOperators : false});//for multisearch code,remove if not required $("#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" } ); // $('#pager2').css("height", "auto"); // $("#list2").navButtonAdd('#pager2', // { caption:"Add", // buttonicon:"ui-icon-plus", // onClickButton: addRow, // position: "last", // title:"", // cursor:"pointer", // id:"client_add" // } // ); // $("#list2").navButtonAdd('#pager2', // { caption:"Edit", // buttonicon:"ui-icon-pencil", // onClickButton: editRow, // position: "last", // title:"", // cursor: "pointer", // id:"client_edit" // } // ); // $("#list2").navButtonAdd('#pager2', // { caption:"Delete", // buttonicon:"ui-icon-trash", // onClickButton: deleteRow, // position: "last", // title:"", // cursor: "pointer", // id:"client_delete" // } // ); }); function addRow() { // Get the currently selected row $("#list2").jqGrid('editGridRow','new', { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var partner_code = $("#partner_code").val(); var partner_name = $("#partner_name").val(); var invoice_number = $("#invoice_number").val(); var invoice_ref_no = $("#invoice_ref_no").val(); var invoicedate = $("#invoicedate").val(); var invoice_value = $("#invoice_value").val(); var due_date = $("#due_date").val(); $.ajax({ url:"<?php echo site_url('controller/overdue_add');?>", type:"POST", data:{'partner_code':partner_code,'partner_name':partner_name,'invoice_number':invoice_number,'invoice_ref_no':invoice_ref_no,'invoicedate':invoicedate,'invoice_value':invoice_value,'due_date':due_date}, async:false, success:function(data){ alert('Successfully Added.'); $("#editmodlist2").remove(); window.location.reload(); } }); }, closeAfterAdd: true, reloadAfterSubmit:false, closeOnEscape:true, clearAfterAdd: true, afterSubmit :false }); } function editRow() { // Get the currently selected row var row = $("#list2").jqGrid('getGridParam','selrow'); if( row != null ) $("#list2").jqGrid('editGridRow',row, { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ var id = $("#id").val(); var partner_code = $("#partner_code").val(); var partner_name = $("#partner_name").val(); var invoice_number = $("#invoice_number").val(); var invoice_ref_no = $("#invoice_ref_no").val(); var invoicedate = $("#invoicedate").val(); var invoice_value = $("#invoice_value").val(); var due_date = $("#due_date").val(); $.ajax({ url:"<?php echo site_url('controller/overdue_edit');?>", type:"POST", data:{'id':id,'partner_code':partner_code,'partner_name':partner_name,'invoice_number':invoice_number,'invoice_ref_no':invoice_ref_no,'invoicedate':invoicedate,'invoice_value':invoice_value,'due_date':due_date}, async:false, success:function(data){ if(data==""){ alert(' .'); } else{ alert('Successfully Updated.'); $("#editmodlist2").remove(); window.location.reload(); //$("#list2").trigger("reloadGrid"); jQuery('#list2').jqGrid('editRow',id,true,reload()); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } 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 site_url('controller/overdue_delete');?>", type:"POST", data:{'id':row}, async:false, success:function(data){ if(data==""){ alert('.'); } else{ alert('Successfully Deleted'); $("#delmodlist2").remove(); window.location.reload(); $("#list2").trigger("reloadGrid"); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } </script> <!---------- Navigation -----------------------> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" type="text/css" href="http://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css"> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/simpleMobileMenu.css');?>" /> <script src="<?php echo base_url('assets/js/simpleMobileMenu.js');?>"></script> <script type="text/javascript"> jQuery(document).ready(function($) { $('.smobitrigger').smplmnu(); }); </script> <!---------------- Menu Drodown ---------------------> <script type="text/javascript"> jQuery(document).ready(function($) { $('.mobimenu li.dropdown').hover(function() { $(this).find('.dropdown-menu').stop(true, true).delay(200).fadeIn(500); }, function() { $(this).find('.dropdown-menu').stop(true, true).delay(200).fadeOut(500); }); }); </script> <!------------------file-upload----------------------------> <script> (function( $ ) { $.fn.uploader = function( options ) { var settings = $.extend({ MessageAreaText: "No files selected.", MessageAreaTextWithFiles: "File List:", DefaultErrorMessage: "Unable to open this file.", BadTypeErrorMessage: "We cannot accept this file type at this time.", acceptedFileTypes: ['csv', 'rtf', 'xls', 'xlsx'] }, options ); var uploadId = 1; //update the messaging $('.file-uploader__message-area p').text(options.MessageAreaText || settings.MessageAreaText); //create and add the file list and the hidden input list var fileList = $('<ul class="file-list"></ul>'); var hiddenInputs = $('<div class="hidden-inputs hidden"></div>'); $('.file-uploader__message-area').after(fileList); $('.file-list').after(hiddenInputs); //when choosing a file, add the name to the list and copy the file input into the hidden inputs $('.file-chooser__input').on('change', function(){ var file = $('.file-chooser__input').val(); var fileName = (file.match(/([^\\\/]+)$/)[0]); //clear any error condition $('.file-chooser').removeClass('error'); $('.error-message').remove(); //validate the file var check = checkFile(fileName); if(check === "valid") { // move the 'real' one to hidden list $('.hidden-inputs').append($('.file-chooser__input')); //insert a clone after the hiddens (copy the event handlers too) $('.file-chooser').append($('.file-chooser__input').clone({ withDataAndEvents: true})); //add the name and a remove button to the file-list $('.file-list').append('<li style="display: none;"><span class="file-list__name">' + fileName + '</span><button class="removal-button" data-uploadid="'+ uploadId +'"></button></li>'); $('.file-list').find("li:last").show(800); //removal button handler $('.removal-button').on('click', function(e){ e.preventDefault(); //remove the corresponding hidden input $('.hidden-inputs input[data-uploadid="'+ $(this).data('uploadid') +'"]').remove(); //remove the name from file-list that corresponds to the button clicked $(this).parent().hide("puff").delay(10).queue(function(){$(this).remove();}); //if the list is now empty, change the text back if($('.file-list li').length === 0) { $('.file-uploader__message-area').text(options.MessageAreaText || settings.MessageAreaText); } }); //so the event handler works on the new "real" one $('.hidden-inputs .file-chooser__input').removeClass('file-chooser__input').attr('data-uploadId', uploadId); //update the message area $('.file-uploader__message-area').text(options.MessageAreaTextWithFiles || settings.MessageAreaTextWithFiles); uploadId++; } else { //indicate that the file is not ok $('.file-chooser').addClass("error"); var errorText = options.DefaultErrorMessage || settings.DefaultErrorMessage; if(check === "badFileName") { errorText = options.BadTypeErrorMessage || settings.BadTypeErrorMessage; } $('.file-chooser__input').after('<p class="error-message">'+ errorText +'</p>'); } }); var checkFile = function(fileName) { var accepted = "invalid", acceptedFileTypes = this.acceptedFileTypes || settings.acceptedFileTypes, regex; for ( var i = 0; i < acceptedFileTypes.length; i++ ) { regex = new RegExp("\\." + acceptedFileTypes[i] + "$", "i"); if ( regex.test(fileName) ) { accepted = "valid"; break; } else { accepted = "badFileName"; } } return accepted; }; }; }( jQuery )); //init $(document).ready(function(){ $('.fileUploader').uploader({ MessageAreaText: "No files selected. Please select a file." }); }); </script>