EVOLUTION-NINJA

Edit File: stock_updates_view.php

<!DOCTYPE html>
<html lang="en">

<head>

<title>Yaskawa</title>
	<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 href="<?php echo base_url('admin_assets/css/bootstrap.min.css');?>" rel="stylesheet">

<link href="<?php echo base_url('admin_assets/css/sb-admin.css');?>" rel="stylesheet">

<link href="<?php echo base_url('admin_assets/css/plugins/morris.css');?>" rel="stylesheet">

<link href="<?php echo base_url('admin_assets/font-awesome/css/font-awesome.min.css');?>" rel="stylesheet" type="text/css">
	<script type="text/javascript" src="<?php echo base_url('assets/js/jquery-2.2.4.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>
	
	<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>

<nav class="navbar navbar-inverse navbar-fixed-top menu-a" role="navigation">
            
            <div class="navbar-header">
                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
                    <span class="sr-only">Toggle navigation</span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                </button>
                <a class="navbar-brand my_logo" href="<?php echo site_url('controller/product');?>"><img  class="img-responsive" src="<?php echo base_url('admin_assets/img/yaskawa_logo2.png');?>"></a>
            </div>
            
            <ul class="nav navbar-right top-nav">
               
                <li class="dropdown">
                    <a href="<?php echo site_url('controller/admin');?>" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-user"></i> Admin</a>
                   
					<li>
						<a href="<?php echo site_url('controller/logout');?>"><i class="fa fa-fw fa-power-off"></i> Log Out</a>
					</li>
                </li>
            </ul>
            
            <div class="collapse navbar-collapse navbar-ex1-collapse">
                <ul class="nav navbar-nav side-nav my-nav">
                     
					    
					 <li class="active">
                        <a href="javascript:;" data-toggle="collapse" data-target="#demo1"> Manage Users  <i class="fa fa-fw fa-caret-down"></i></a>
                        <ul id="demo1" class="collapse">
                            <li>
                                <a href="<?php echo site_url('controller/supervisor_view');?>">Supervisor</a>
                            </li>
                            <li>
                                <a href="<?php echo site_url('controller/abp_view');?>">ABP</a>
                            </li>
                             <li>
                                <a href="<?php echo site_url('controller/region_view');?>">Regional Manager</a>
                            </li>
                        </ul>
                    </li>
					  
                    <li>
                        <a href="javascript:;" data-toggle="collapse" data-target="#demo2"> Information <i class="fa fa-fw fa-caret-down"></i></a>
                        <ul id="demo2" class="collapse">
                            <li>
                                <a href="<?php echo site_url('controller/stock_updates_view');?>">Stock Updates</a>
                            </li>
                            <li>
                                <a href="<?php echo site_url('controller/po_view');?>">PO Acknowledgemets</a>
                            </li>
                        </ul>
                    </li>
					    
					<li>
                        <a href="javascript:;" data-toggle="collapse" data-target="#demo3"> Financials<i class="fa fa-fw fa-caret-down"></i></a>
                        <ul id="demo3" class="collapse">
                            <li>
                                <a href="<?php echo site_url('controller/outstanding_view');?>">Outstanding Statement</a>
                            </li>
                            <li>
                                <a href="<?php echo site_url('controller/overdue_view');?>">Overdue Statement</a>
                            </li>
							<li>
                                <a href="<?php echo site_url('controller/cform_view');?>">C forms</a>
                            </li>
                        </ul>
                    </li>
					 
					<li>
                        <a href="javascript:;" data-toggle="collapse" data-target="#demo4"> Technical Support<i class="fa fa-fw fa-caret-down"></i></a>
                        <ul id="demo4" class="collapse">
                            <li>
                                <a href="<?php echo site_url('controller/drive_catalogues_view');?>">Drive Catalogues</a>
                            </li>
                            <li>
                                <a href="<?php echo site_url('controller/case_stories_view');?>">Case Stories</a>
                            </li>
                        </ul>
                    </li>
					   
					<li>
						<a href="<?php echo site_url('controller/news_view');?>">News</a>
					</li>
					 <li class="divider"></li>     
                   <li>
						<a href="<?php echo site_url('controller/product');?>">Add Product and Category</a>
					</li>
					 <li class="divider"></li> 
					 <li>
						<a href="<?php echo site_url('controller/add_product');?>">Add New Product</a>
					</li>
					 <li class="divider"></li> 
					 <li>
						<a href="<?php echo site_url('controller/product_list');?>">Product List</a>
					</li>
					 <li class="divider"></li> 
                </ul>    
                   
                </ul>
            </div>
            
        </nav>

<div class="row">
                    <div class="col-lg-12">
                       
                    </div>
                </div>

<div class="row">    	
		
			<section class="row">
				
				<div class="col-sm-8">
                <h1 style="margin-left:15%">
                  Stock Updates                     
                 </h1>     
				</div>
				<div class="col-sm-2"></div>
             </section>
			<div class="row">
		
			<div class="col-sm-12">
				<div id = "jaytab"  style="width:1000px;margin-top:3%;margin-left:5%">
					<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>
 <?php
        $ci =& get_instance();
        $base_url = base_url();
    ?>

</div>
            
        </div>

<!-- jQuery 
    <script src="<?php echo base_url('admin_assets/js/jquery.js');?>"></script>

<!-- Bootstrap Core JavaScript 
    <script src="<?php echo base_url('admin_assets/js/bootstrap.min.js');?>"></script>

</body>

</html>
<script>
  $(document).ready(function (){
	
		jQuery("#list2").jqGrid({
			url:"<?php echo site_url('controller/stock_updates_view_insert');?>",
			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,hidden:true,editable: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:"asc", 
				caption:"Stock Updates"
				}); 
		   $("#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-pencil", 
// 						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 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,'partner_code':partner_code,'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,'partner_code':partner_code,'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,'partner_code':partner_code,'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>

<script src="<?php echo base_url('admin_assets/js/bootstrap.min.js');?>"></script>
<script src="<?php echo base_url('admin_assets/js/plugins/morris/raphael.min.js');?>"></script>
    <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris.min.js');?>"></script>
    <script src="<?php echo base_url('admin_assets/js/plugins/morris/morris-data.js');?>"></script>