EVOLUTION-NINJA

Edit File: outstanding_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 Outstanding 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>

<script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
    
    <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
    
    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" />
    
    <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');?>">News</a></li> &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp	
					<?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> &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp
					<?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');?>" class="active">News</a></li> &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp
					<?php }elseif($details->department == 7) {?>
					<li><a href="<?php echo site_url('controller/news_upload');?>" class="active">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> &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp  &nbsp	
						<?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>
	
	
	
	<div class="outstanding-banner"> </div>

<div class="middle_work_hedding">
		<div class="container">
			<h3><em>Outstanding Statement Import</em></h3>		
		</div>
	</div>
	
	
	
	<div class="mid-inventory-improt">
		<div class="container">
			<form action="<?php echo site_url('controller/imported'); ?>" method="post"  class="file-uploader"name="upload_excel" enctype="multipart/form-data">
				<a href="<?php echo site_url("controller/download2"); ?>" 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>
	
		
	<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>

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/outstanding_delete');?>",
			             type:"POST",
			             data:{'id':row},
			                 async:false,
			                 success:function(data){
			                 if(data==""){
			                  alert('Successfully Deleted.'); 
			                 }
			                 else
				             {
			                     	alert('Successfully Deleted');
			                    	$("#delmodlist2").remove();
			                    	 window.location.reload();
			                    
			                 }
			             }
			         });
			    },
				closeAfterEdit: true,
				reloadAfterSubmit:false,
				afterSubmit : false 
				
			});

else $( "#dialogSelectRow" ).dialog();
}

</script>
		
	<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>
	
		
	<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>

//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>