EVOLUTION-NINJA

Edit File: update_purchse_order.php

<div class="page-content-wrapper">
	<div class="page-content">
	<?php if(isset($fetch_data)) {?>
	<h3 class="page-title">Edit Purchase Order</h3>
	<?php } else {?>
	<h3 class="page-title">Purchase Order</h3><?php } ?>
		
		<?php  $this->load->view('templates/nav_menu'); ?>
		
		<form action="<?php echo base_url('vendor/insert_purchase_order_data');?>" method="post"  id="land_owner" class="form-inline">
		<?php if(isset($fetch_data)) { ?>
			<div class="row" style="padding-bottom:15px;">
				<div class="form-group col-sm-4 col-md-3">
					<label class="col-sm-4 col-xs-5">PO. No.</label>
					<?php  if(isset($sl_no)) { ?>
					<input type="text" class="col-sm-8 col-xs-7" id="sl_no" name="sl_no" value="<?php echo $fetch_data->sl_no; ?>" disabled>
					<input type="hidden" class="col-sm-8 col-xs-7" id="id" name="id" value="<?php echo $fetch_data->id; ?>" disabled>
					<input type="hidden" class="col-sm-8 col-xs-7" id="sl_indent_no" name="sl_indent_no" value="<?php echo $fetch_data->sl_indent_no; ?>" disabled>
					<?php } ?>
					
					
				</div>
				<div class="form-group col-sm-4 col-md-3">
					<label class="col-sm-5 col-xs-5" style="padding-right: 0 !important;">Indent No.</label>
					
					<input type="text" onkeyup="searchname()" onfocusout="myFunction()" id="indent_no" name="indent_no" class="col-sm-7 col-xs-7" value="<?php echo $fetch_data->indent_no; ?>" required> 
				</div>
				
				<div class="form-group col-sm-4 col-md-6">
					<label class="col-sm-3 col-xs-5">Approved By</label>
					<input type="text" class="col-sm-9 col-xs-7" id="remark" name="remark" value="<?php echo $fetch_data->approved_by; ?>" >
				</div>
				
				
			</div> 
			
			<div class="row" style="padding-bottom:15px;">
			
				<div class="form-group col-sm-12 col-md-6">
					<label class="col-sm-3 col-xs-5">Vendor Name</label>
					<input type="text" class="col-sm-9 col-xs-7" id="supplier_name" name="supplier_name" value="<?php echo $fetch_data->supplier_name; ?>" required>
				</div>
				
				<div class="form-group col-sm-12 col-md-6">
					<label class="col-sm-3 col-xs-5">Instructions</label>
					
						<textarea class="col-sm-9 col-xs-7" rows="2" id="comment" name="comment" value="<?php echo $fetch_data->comment; ?>" required><?php echo $fetch_data->comment; ?></textarea>
					
					
				</div>
			</div> 
			
			<div class="clr"></div>
			
			<div class="row" style="padding-bottom:15px;">
				<div class="form-group col-sm-12 col-md-6">
					<label class="col-sm-3 col-xs-5">Rate In INR</label>
					<input type="text" class="col-sm-9 col-xs-7" id="rate_in_inr"  name="rate_in_inr" value="<?php echo $fetch_data->rate_inr; ?>" required>
				</div>
				<div class="form-group col-sm-12 col-md-6">
					<label class="col-sm-3 col-xs-5">Value in INR</label>
					<input type="text" class="col-sm-9 col-xs-7" id="value_in_inr"  name="value_in_inr" value="<?php echo $fetch_data->value_inr; ?>" required>
				</div>
			</div> 
			
			<div class="row land_owner_a">
				<div class="col-sm-4 col-md-4"></div>
				<div class="col-sm-4 col-md-4">
				 <?php if($fetch_data->confirm == 'Yes') { ?>
					 <button name="update_approved" id="update_approved" value="Submit" class="btn center-block submit" >Update</button>
					  <button  value="Submit" class="btn center-block submit" disabled>Approved</button>
					 <a href="<?php echo base_url(); ?>vendor/received_details" class="btn default" style=" width:20%;">Cancel</a>
				 <?php } else {?>
				 <button name="update" id="update" value="Submit" class="btn center-block submit" >Update</button>
					  <button name="approve" id="approve" value="Submit" class="btn center-block submit" >Approve</button>
					 <a href="<?php echo base_url(); ?>vendor/purchase_order_List" class="btn default" style=" width:20%;">Cancel</a>
				 <?php } ?>
				</div>
				<div class="col-sm-4 col-md-4"></div>													
			</div> 
		<?php }  else { ?>
		
		<div class="row" style="padding-bottom:15px;">
		<?php if(empty($rec_sl_no)) { ?>
				<div class="form-group col-sm-4 col-md-3">
					<label class="col-sm-6 col-xs-5">PO. No.</label>
					<?php  if(isset($sl_no)) { ?>
					<input type="text" class="col-sm-6 col-xs-7" id="sl_no" name="sl_no"  value="<?php echo $sl_no; ?>" readonly>
					<?php } ?>
		
				</div>
		<?php } else {?>
				<div class="form-group col-sm-4 col-md-3">
					<label class="col-sm-4 col-xs-5">PO. No.</label>
					<input type="text" class="col-sm-8 col-xs-7" id="sl_no" name="sl_no"  value="<?php echo $rec_sl_no; ?>" readonly >
					
		
				</div>
			<?php } ?>
			<?php if(isset($fetch_order_data)) { ?>
			<div class="form-group col-sm-4 col-md-3">
					<label class="col-sm-5 col-xs-5" style="padding-right: 0 !important;">Indent No.</label>
					
					<input type="text" onkeyup="searchname()" onfocusout="myFunction()" id="indent_no" name="indent_no" class="col-sm-7 col-xs-7" value="<?php echo $fetch_order_data->indent_no; ?>" required> 
					<input type="hidden" onkeyup="searchname()" onfocusout="myFunction()" id="sl_indent_no" name="sl_indent_no" class="col-sm-7 col-xs-7" value="<?php echo $fetch_order_data->sl_indent_no; ?>" required>
				</div>
				
			<?php } elseif(isset($fecth_no_data)) {?>
			<div class="form-group col-sm-4 col-md-3">
					<label class="col-sm-5 col-xs-5" style="padding-right: 0 !important;">Indent No.</label>
					
					<input type="text" onkeyup="searchname()" onfocusout="myFunction()" id="indent_no" name="indent_no" class="col-sm-7 col-xs-7" value="<?php echo $fecth_no_data->indent_no; ?>" required>

<input type="hidden" onkeyup="searchname()" onfocusout="myFunction()" id="indent_no" name="indent_no" class="col-sm-7 col-xs-7" value="<?php echo $fecth_no_data->sl_indent_no; ?>" required> 					
				</div>
			<?php } else {	?>
				<div class="form-group col-sm-4 col-md-3">
					<label class="col-sm-5 col-xs-5" style="padding-right: 0 !important;">Indent No.</label>
					
					<input type="text" onkeyup="searchname()" onfocusout="myFunction()" id="indent_no" name="indent_no" class="col-sm-7 col-xs-7"  required> 
				</div>
			<?php } ?>
				<div class="form-group col-sm-4 col-md-6">
					<label class="col-sm-3 col-xs-5">Vendor Name</label>
					<input type="text" class="col-sm-9 col-xs-7" id="supplier_name" name="supplier_name" required>
				</div>
			</div> 
			
			<div class="row" style="padding-bottom:15px;">
				<div class="form-group col-sm-12 col-md-12">
					<label class="col-sm-1 col-xs-4" style="width: 117px;">Instructions</label>
					<div class="col-sm-7 col-xs-8" style="padding-left:4px;">
						<textarea class="" rows="2" id="comment" name="comment" style="width:66%;" required></textarea>
					</div>
					<div class="col-sm-2 col-xs-0"></div>
				</div>
			</div> 
			
			<div class="clr"></div>
			
			<div class="row" style="padding-bottom:15px;">
				<div class="form-group col-sm-12 col-md-6">
					<label class="col-sm-3 col-xs-5">Rate In INR</label>
					<input type="text" class="col-sm-9 col-xs-7" style="margin-left: -10px;" id="rate_in_inr"  name="rate_in_inr" required>
				</div>
				<div class="form-group col-sm-12 col-md-6">
					<label class="col-sm-3 col-xs-5">Value in INR</label>
					<input type="text" class="col-sm-9 col-xs-7" id="value_in_inr"  name="value_in_inr" required>
				</div>
			</div> 
			
			<div class="row land_owner_a">
				<div class="col-sm-4 col-md-4"></div>
				<div class="col-sm-4 col-md-4">
					 <button type="submit" value="Submit" class="btn center-block submit" >Create PO</button>
					 <button  name="add_new" id="add_new" class="btn center-block submit">Add New</button>
					 <a href="<?php echo base_url(); ?>vendor/purchase_order_details" class="btn default" style=" width:20%;">Cancel</a>
				</div>
				<div class="col-sm-4 col-md-4"></div>													
			</div> 
		<?php } ?>
		</form><br/><br/>
<div id = "jaytab" class="jaytab">
			<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> 
<style>
.btn{
	    float: left;
}
</style>
<script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script>
<link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" >
<script type="text/javascript">
	$(document).ready(function() {
		//alert();
		$( "#supplier_name" ).autocomplete({   
		source: '<?php echo base_url('vendor/auto_complete_vendor_name'); ?>',
		});
	});
	
	$("#add_new").click(function(e) {
		e.preventDefault();
		//alert();
		$.ajax({
		url:"<?php echo base_url('vendor/get_indent_no1')?>",
		dataType: "json",
		type:"POST",
		async:true,
		success:function(data)
		  {   
		// alert('hai');
		var obj=JSON.parse(data);
	//	alert(obj);
		document.getElementById("sl_no").value =obj;  
	
	}
	});
	});
	</script>
<script type="text/javascript">
	
	$("#add").click(function(e) {
		e.preventDefault();
		
		var sl_no =$('#sl_no').val();
		var indent_no =$('#indent_no').val();
		var supplier_name =$('#supplier_name').val();
		var comment =$('#comment').val();
		var rate_in_inr =$('#rate_in_inr').val();
		var value_in_inr =$('#value_in_inr').val();
		if(sl_no != '' && indent_no != '' && supplier_name != '' && comment != '' )
		{				
		$.ajax({
            url:"<?php echo base_url('vendor/insert_purchase_order_data');?>",

type:"POST",
           
				data:{'sl_no':sl_no,'indent_no':indent_no,'supplier_name':supplier_name,'comment':comment,'rate_in_inr':rate_in_inr,'value_in_inr':value_in_inr},

async:false,

success:function(data)
				 {
		              // swal({
					 // title: "Successfully Added",
					  // text: "",
					 
					// });
					$('#sl_no').val('');
					$('#indent_no').val('');
					$('#supplier_name').val('');
					$('#comment').val('');
					$('#rate_in_inr').val('');
					$('#value_in_inr').val('');
					window.location.reload();
				 }

});
				
				
		}
				else{
					
	              swal({
				 title: "Please Fill All The Fields",
				  text: "",
				 
				});
				}
});
$(document).ready(function() {
		
		$( "#indent_no" ).autocomplete({   
		source: '<?php echo base_url('vendor/auto_complete'); ?>',
		});
	});

$("#update").click(function(e) {
		e.preventDefault();
		var id =$('#id').val();
		var sl_no =$('#sl_no').val();
		var indent_no =$('#indent_no').val();
		var supplier_name =$('#supplier_name').val();
		var remark=$('#remark').val();
		var comment =$('#comment').val();
		var rate_in_inr =$('#rate_in_inr').val();
		var value_in_inr =$('#value_in_inr').val();
		if(sl_no != '' && indent_no != '' && supplier_name != '' && comment != '' )
		{				
		$.ajax({
            url:"<?php echo base_url('vendor/update_purchase_order_data');?>",

type:"POST",
           
				data:{'id':id,'sl_no':sl_no,'indent_no':indent_no,'supplier_name':supplier_name,'remark':remark,'comment':comment,'rate_in_inr':rate_in_inr,'value_in_inr':value_in_inr},

async:false,

success:function(data)
				 {
		            
					window.location.href  = '<?php echo base_url('vendor/purchase_order_List');?>';
				 }

});
				
				
		}
				else{
					
	              swal({
				 title: "Please Fill All The Fields",
				  text: "",
				 
				});
				}
});
</script>
		    
		<link href="<?php echo base_url('assets/css/sweetalert2.min.css');?>" rel="stylesheet"/>
<script src="<?php echo base_url('assets/js/sweetalert2.min.js');?>"></script>

</script>
	<style type="text/css">
			
		.ss{
	padding-right: 0 !important;
	padding-left: 0 !important;
}

label {
    font-weight: normal;
    text-align: left;
}
.hr-line{
	border-top: 1px solid #465A81;
}

.well-sm {
    padding: 3px !important;
	border-radius: 0px !important;
}
input[type="file"] {
    padding-bottom: 28px !important;
    height: 25px !important;
    color:transparent;
}
.portlet.box.blue-madison {
    border: 1px solid #fff !important;
    border-top: 0;
    background:#fff !important;
}

input[type=file] {
    display: none;
}
.ui-jqgrid .ui-jqgrid-caption {
    text-align: left;
    background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar {
    padding: .1em .1em;
    min-height: 35px;
     background: rgb(72,91,127);
    color: white;
}
.ui-jqdialog .ui-jqdialog-titlebar-close span {
    display: block;
    margin: -9px;
}
#sData
{
	 height: 27px;
}
#cData
{
	 height: 27px;
}
#dData
{
	 height: 27px;
}
#eData
{
	 height: 27px;
}
.coledit
{	cursor:pointer;
	text-align: right;
padding-right: 24px !important;
padding-left: 24px !important;

}
.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td {
    overflow: hidden;
    white-space: pre;
   
	
}
#gbox_list2
{
	margin-left:12px !important;
}
	</style>

<style>

</style> 

 
					    
<script>
$("#approve").click(function(e) {
		e.preventDefault();
		var id =$('#id').val();
		swal({
			  title: 'Remarks',
			  input: 'text',
			  showCancelButton: true,
			  confirmButtonText: 'Submit',
			  showLoaderOnConfirm: true,
			 }).then(function (email) {
				  $.ajax({
	        //alert(email);
	        url:"<?php echo base_url('vendor/purchase_order_yes_confirmation')?>",
	        type:"POST",
	        data:{'id':id,'remarks':email},
		                 success:function(data){
				                 if(data==""){
				                
				                    $("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
				                    $("#jaytab").trigger("reloadGrid");
				                    $("#jqGrid").trigger("reloadGrid");
				                  
				              window.location.href  = '<?php echo base_url('vendor/purchase_order_List');?>';
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
		
			})
			});
  $(document).ready(function (){
	var l=$("#sl_no").val();
	 // alert(l);
		jQuery("#list2").jqGrid({
			url:"<?php echo base_url('vendor/update_purchase_order_grid_details');?>/s"+l+"/",
		//	url:"<?php echo base_url('vendor/add_purchase_grid_details')?>",	 
			datatype: "json", 
		   colNames:['Id','Indent No','Product','Quantity','Rate In INR','Value In INR',],
				
			colModel:[
					  {name:'id',index:'id',hidden:true, width:50,editable:true,width:100},
					  {name:'indent_no',index:'indent_no', width:170,editable:true,editrules:{required: true}},
					  {name:'add_product',index:'add_product', editable:true,editrules:{required: true},width:170},
					  {name:'quantity',index:'quantity', width:170,editable:true,editrules:{required: true}},
					  {name:'rate_inr',index:'rate_inr', editable:true,editrules:{required: true},width:170},
					  {name:'value_inr',index:'value_inr', width:170,editable:true,editrules:{required: true}},
					   // {	
	                    // name: 'confirm', index: 'confirm', width: 100, align: 'center',
	                         // formatter: 'checkbox', editoptions: { value: '1:0' },
	                         // formatoptions: { disabled: false },
	                         // cellattr: function (rowId, tv, rawObject, cm, rdata) 
									// {
	                        	     // return ' onclick="fun($(this))" ';
	                        		// }
						// },
					  // {name:'edit',index:'edit',align: "right",editable:true,style:'cursor:pointer',editrules:{required: true},width:85,classes:'coledit',formatter:'showlink',formatoptions:{baseLinkUrl:'<?php echo base_url('vendor/purchase_id')?>'}},
					  ],
			 rowNum:50,
		      	rowTotal: 200000000000000000000000000,
		      	rowList : [50,100,200,300,500,1000,5000],
			rownumbers: true,
			pager: '#pager2', 
			sortname:'id', 
			viewrecords: true, 
				loadonce:true,
			gridview: true,
			sortorder:"desc", 
			caption:"Purchase Order Details",
//  				 multiselect: true,
// 					 onPaging : function(but) {
// 				     alert("Button: "+but + " is clicked");
// 					}
			
			}); 
	//$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required
	jQuery("#list2").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" });
	 	
	$("#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"
	 }
		);
      
	
});
function fun(rowId)
	{
		// var rowid = 123;
        var id = rowId.closest('tr').attr('id'); 
		//alert(id);
		 var confirmMsg= confirm("Do You Want To Confirm!");

if (confirmMsg==true)
         {

$.ajax({
	        
	        url:"<?php echo base_url('vendor/purchase_order_yes_confirmation')?>",
	        type:"POST",
	        data:{'id':id},
		                 success:function(data){
				                 if(data==""){
				                
				                    $("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
				                    $("#jaytab").trigger("reloadGrid");
				                    $("#jqGrid").trigger("reloadGrid");
				                  
				               window.location.reload();
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
		}
		 else if (confirmMsg==false)
         {
			    $.ajax({
	        
	        url:"<?php echo base_url('vendor/purchase_order_no_confirmation')?>",
	        type:"POST",
	        data:{'id':id},
		                 success:function(data){
				                 if(data==""){
				                
				                    $("#editmodlist2").remove();
				                    $("#list2").trigger("reloadGrid");
				                   
				                    window.location.reload();
				                   
				                 }
				                 else{
				                  
				                     
				                 }
				             }
		            });  
		}
	}
	$("#update_approved").click(function(e) {
	e.preventDefault();
		  swal({
	 title: "This PO is already Approved",
	  text: "",
	 
	});
	});
</script>