EVOLUTION-NINJA

Edit File: stock_updates.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 Stock Updates</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.js'); ?>"></script>
				      
	 <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
				    <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	<script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></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'); ?>" />
	<style>
		.right
		{
			text-transform: uppercase;
			font-family:Roboto;
			font-weight:bold;
			color:#00a859;
		}
	</style>
	<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:#2A4474 !important;
					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">
				<a href="" class="hidden-xs hidden-sm"><img src="<?php echo base_url('assets/img/yaskawa_logo.png');?>" class="img-responsive center-block"></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">
				<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">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');?>" class="active">News</a></li> 
					<?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">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');?>" class="active">News</a></li>	
						<?php }?>
									
						  <li><a href="<?php echo site_url('controller/create_po');?>">PO Generate </a></li> 
						<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>
				</nav>
			</div>
		</div>
	</header>
	
	
	<div class="stock_update-banner"> </div>

<div class="middle_work_hedding">
		<div class="container">
			<h3><em>Inventory / Stock Report</em></h3>		
		</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 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>
		
	<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>
	
	<script>
  $(document).ready(function (){
	//var l=$("#loc").val();
	  //alert(l);
		jQuery("#list2").jqGrid({
			url:"<?php echo site_url('controller/stock_updates_display_abp');?>",
			mtype : "post",
			datatype: "json", 
			 colNames:['Stock Id','Material','Material Description','Quantity In Stock','Open Po','In Transit Stock','Month Planned Qty','Remarks'],
			colModel:[
		      	   {name:'stock_id',index:'stock_id', width:100, align:'center',key:true,editable:true,hidden:true},
      //{name:'partner_code', index:'partner_code', align:'center',editable:true, width:100},
      {name:'material', index:'material', width:100, align:'center', sortable:false,editable:true,edittype:'text'},
      {name:'material_description', index:'material_description', width:250, align:'center',editable:true,edittype:'text'},
      {name:'quantity_in_stock', index:'quantity_in_stock', width:100, align:'center', sortable:false,editable:true,edittype:'text'},
      {name:'open_po', index:'open_po', width:100, align:'center', sortable:false,editable:true,edittype:'text'},
      {name:'in_transit_stock', index:'in_transit_stock', width:100, align:'center', sortable:false,editable:true,edittype:'text'},
	 {name:'month_planned_qty', index:'month_planned_qty', width:100, align:'center', sortable:false,editable:true,edittype:'text'},
				{name:'remarks', index:'remarks', width:100, align:'center', sortable:false,editable:true,edittype:'text'}
	
		      	    ],
			rowNum:50,
        rowTotal: 2000,
        rowList : [50,100,500,1000],
			rownumbers: true,
        rownumWidth: 40,
			pager:"#pager2", 
			sortname:'stock_id', 
			viewrecords: true,
			loadonce:true,
			gridview: true,
			autowidth: true,
			sortorder:"desc", 
			//caption:"supervisor"
			}); 
	   $("#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");
	 
	
  });
	  function addRow() {
					// Get the currently selected row
				    $("#list2").jqGrid('editGridRow','new',
				    		{ 	
				    			modal:true,jqModal:true,
							    recreateForm: true,			    
							    beforeSubmit: function(postdata,formid){
							  
							    	var stock_id = $("#stock_id").val();
							    	
							    //	var partner_code = $("#partner_code").val();
							    	var material = $("#material").val();
									var material_description = $("#material_description").val();
							    	var quantity_in_stock = $("#quantity_in_stock").val();
							    	var open_po = $("#open_po").val();
									var in_transit_stock = $("#in_transit_stock").val();
							    	var month_planned_qty = $("#month_planned_qty").val();
							    	var remarks = $("#remarks").val();
							    	
							    	//var pcs = $("#pcs").val();
							     // alert(kg+ton+pcs);
							    	
							    	$.ajax({
							            
							            url:"<?php echo site_url('controller/stock_info_insert_add');?>",
							            type:"POST",
							            data:{'stock_id':stock_id,'material':material,'material_description':material_description,'quantity_in_stock':quantity_in_stock,'open_po':open_po,'in_transit_stock':in_transit_stock,'month_planned_qty':month_planned_qty,'remarks':remarks},
							                 async:false,
							                success:function(data){
							                   
							                   	alert('Successfully Added.');
								               
							                   	$("#editmodlist2").remove();
							                   	//jqtab();
							                   	$("#list2").trigger("reloadGrid");
							                   	
							                }
							            });
							      },
								closeAfterAdd: true,
								reloadAfterSubmit:false,
								closeOnEscape:true,
								clearAfterAdd: true,
								afterSubmit :false
								
				    		});
				    
				    
				}
	 function deleteRow() {
					// 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 stock_id = $("#stock_id").val();
							    	
							    	//var partner_code = $("#partner_code").val();
							    	var material = $("#material").val();
									var material_description = $("#material_description").val();
							    	var quantity_in_stock = $("#quantity_in_stock").val();
							    	var open_po = $("#open_po").val();
									var in_transit_stock = $("#in_transit_stock").val();
							    	var month_planned_qty = $("#month_planned_qty").val();
							    	var remarks = $("#remarks").val();
							    	 $.ajax({
							             
							             url:"<?php echo site_url('controller/stock_info_insert_delete');?>",
							             type:"POST",
							            data:{'stock_id':stock_id,'material':material,'material_description':material_description,'quantity_in_stock':quantity_in_stock,'open_po':open_po,'in_transit_stock':in_transit_stock,'month_planned_qty':month_planned_qty,'remarks':remarks},
		
							                 async:false,
							             success:function(data){
							                 if(data==""){
							                  alert('Successfully Deleted.'); 
							                
							                 
							                    //$("#editmodlist2").remove();
							                    $("#list2").trigger("reloadGrid");
							                    jQuery('#list2').jqGrid('editRow',stock_id,true,reload());
							                   // $("#clientcode").attr("aria-expanded","false");
							                   // $("#cname").attr("aria-expanded","false");

}
							                 else{
							                     //alert('Unsuccessful');
							                     
							                 }
							             }
							         });
							         
							         
							     
							    	 
							    },
								closeAfterEdit: true,
								reloadAfterSubmit:false,
								afterSubmit : false 
								
							});

else $( "#dialogSelectRow" ).dialog();
				}
	 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 stock_id = $("#stock_id").val();
							    	
							    	//var partner_code = $("#partner_code").val();
							    	var material = $("#material").val();
									var material_description = $("#material_description").val();
							    	var quantity_in_stock = $("#quantity_in_stock").val();
							    	var open_po = $("#open_po").val();
									var in_transit_stock = $("#in_transit_stock").val();
							    	var month_planned_qty = $("#month_planned_qty").val();
							    	var remarks = $("#remarks").val();
							    	 $.ajax({
							             
							             url:"<?php echo site_url('controller/stock_info_insert_edit');?>",
							             type:"POST",
							            data:{'stock_id':stock_id,'material':material,'material_description':material_description,'quantity_in_stock':quantity_in_stock,'open_po':open_po,'in_transit_stock':in_transit_stock,'month_planned_qty':month_planned_qty,'remarks':remarks},
		
							                 async:false,
							             success:function(data){
							                 if(data==""){
							                  alert('Successfully Updated.'); 
							                
							                 
							                    //$("#editmodlist2").remove();
							                    $("#list2").trigger("reloadGrid");
							                    jQuery('#list2').jqGrid('editRow',stock_id,true,reload());
							                   // $("#clientcode").attr("aria-expanded","false");
							                   // $("#cname").attr("aria-expanded","false");

else $( "#dialogSelectRow" ).dialog();
				}
</script>