EVOLUTION-NINJA

Edit File: stock_updates.php

<div class="content-wrapper">
	<div class="middle_work_hedding">
		<div class="container-fluid">
			<h3><em>Inventory / Stock Report</em></h3>		
		</div>
	</div>
	
	
	
	<div class="middle_work_table">
		<div class="container-fluid">
			
			
			
			<div class="table-responsive">	
			
		<div id = "jaytab" style="width: 100%;">
			<p>Last Updated Date and Time is : <?php  if(empty($time)) {  echo "Data not found"; }else{ echo $time->createdate;  }  ?></p>
			<p><b>Please Note: Standard Lead time is valid for Forecasted Quantities based on 6 months rolling forecast.</b></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>
	</div> 
	</div> 
	</div> 
	<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','Standard LT in Days','Stock/Make to Order','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>