Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/systemuniq

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: addpurchase.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$action=isset($_REQUEST['action'])?$_REQUEST['action']:'Add';
$editid=isset($_REQUEST['editid'])?$_REQUEST['editid']:'';
if(isset($_POST['submitin']) && $_POST['submitin']=="Add") {
	$dc=date("Y-m-d");
	$total=0;
	$gstval=0;
	$cessval=0;
	$net=0;
    $pur_preqno=isset($_POST['pur_preqno']) ? addslashes($_POST['pur_preqno']) : '';
	$pur_invdt=isset($_POST['pur_invdt']) ? addslashes($_POST['pur_invdt']) : '';
	$pur_rcvdt=isset($_POST['pur_rcvdt']) ? addslashes($_POST['pur_rcvdt']) : '';
	$pur_invno=isset($_POST['pur_invno']) ? addslashes($_POST['pur_invno']) : '';
	$pur_tcost=isset($_POST['pur_tcost']) ? addslashes($_POST['pur_tcost']) : '';
	$pur_sup=isset($_POST['pur_sup']) ? addslashes($_POST['pur_sup']) : '';
	$pur_pmode=isset($_POST['pur_pmode']) ? addslashes($_POST['pur_pmode']) : '';
	$pur_pmodeoth=isset($_POST['pur_pmodeoth']) ? addslashes($_POST['pur_pmodeoth']) : '';
	$igst=$_POST['pur_pmodeoth'];
	$sql="insert into `purchase_header` (`pur_date`,`pur_preqno`,`pur_invdt`,`pur_rcvdt`,`pur_invno`,`pur_tcost`,`pur_sup`,`pur_pmode`,`pur_pmodeoth`,`pur_igst`,`pur_st`) values ('".$dc."','".$pur_preqno."','".$pur_invdt."','".$pur_rcvdt."','".$pur_invno."','".$pur_tcost."','".$pur_sup."','".$pur_pmode."','".$pur_pmodeoth."','".$igst."','1')";
	//print $sql;exit();
    $ins_query=mysqli_query($con,$sql);
	$ref=mysqli_insert_id($con);;
	$norows=$_POST['norows'];
	for($i=1;$i<=$norows;$i++) {
		$one="product_ref".$i;
		$two="vol".$i;
		$three="qty".$i;
		$four="purchase_rate".$i;
		$five="discount".$i;
		$six="discounted".$i;
		$seven="purchase_val".$i;
	
		$product_ref=$_POST[$one];
		$prorefarr=explode(" -*- ",$product_ref);
		$product_ref=trim($prorefarr['1']);
		$vol=$_POST[$two];
		$qty=$_POST[$three];
		$purchase_rate=$_POST[$four];
		$discount=$_POST[$five];
		$discounted=round($_POST[$six],2);
		$purchase_val=round($_POST[$seven],2);

$ref=$editid;
	mysqli_query($con,"delete from `purchase_item` where `pur_id`='".$editid."'");
	mysqli_query($con,"delete from `stock_master` where `pur_ref`='".$editid."'");
	$norows=$_POST['norows'];
	for($i=1;$i<=$norows;$i++) {
		$one="product_ref".$i;
		$two="vol".$i;
		$three="qty".$i;
		$four="purchase_rate".$i;
		$five="discount".$i;
		$six="discounted".$i;
		$seven="purchase_val".$i;
	
		$product_ref=$_POST[$one];
		$prorefarr=explode(" -*- ",$product_ref);
		$product_ref=trim($prorefarr['1']);
		$vol=$_POST[$two];
		$qty=$_POST[$three];
		$purchase_rate=$_POST[$four];
		$discount=$_POST[$five];
		$discounted=round($_POST[$six],2);
		$purchase_val=round($_POST[$seven],2);

if($ref!="" && $product_ref!="" && $qty!="") {
			$sql="insert into `purchase_item` (`pur_id`,`pro_code`,`qty`,`purchase_rate`,`discount`,`discounted`,`purchase_val`,`purchase_gst`) values ('".$ref."','".$product_ref."','".$qty."','".$purchase_rate."','".$discount."','".$discounted."','".$purchase_val."','".$gst."')";
    		$ins_query=mysqli_query($con,$sql);
		}
		if($product_ref != "") {
            mysqli_query($con,"INSERT INTO `stock_master` (`pur_ref`,`pro_code`,`in_qty`,`last_update_date`) VALUES ('".$ref."','".addslashes($product_ref)."','".$qty."','".$dc."')");
        }
	}
	$gstval=round($gstval,2);
	$cessval=round($cessval,2);
	$net=$total+$gstval+$cessval;
	$sql="update `purchase_header` set `pur_total`='".$total."', `pur_gst`='".$gstval."', `pur_net`='".round($net)."' where `pur_id`='".$ref."'";
	$ins_query=mysqli_query($con,$sql);
	$flag="go".$editid;
	if($ins_query) {
		$_SESSION['msg']="Successfully Updated.";
		header("location:viewpurchases.php#".$flag);
		exit();
	}
	else {
	    $_SESSION['msg']="Some Error Occured.";
		header("location:viewpurchases.php#".$flag);
		exit();
	}
}
if($_POST['submitin']=="" && $action=="Edit") {
	$rowm=mysqli_fetch_array(mysqli_query($con,"select * from `purchase_header` where `pur_id`='".$editid."'"));
}
include("includes/headermain.php"); 
?>
<script language="javascript">
function addRow(tableID) {
	var table=document.getElementById(tableID);
	var rowCount=table.rows.length;
	var rowCounta=document.getElementById("norows").value;
	var rcount=parseInt(rowCounta)+1;
	var row=table.insertRow(rowCount);
	var colCount=table.rows[0].cells.length;
   for(var i=0;i<colCount;i++) {
		if(i==0) {
			var tname="chk"+rcount;
			var newcell=row.insertCell(i);newcell.innerHTML=table.rows[0].cells[i].innerHTML;
			switch(newcell.childNodes[0].type) { 
				case"text":newcell.childNodes[0].value="";break;
				case"checkbox":newcell.childNodes[0].checked=false;break;
				case"select-one":newcell.childNodes[0].selectedIndex=0;break; 
			}
			newcell.childNodes[0].name=tname; 
		}
		if(i==1) {
			var tname="product_ref"+rcount;
			var newcell=row.insertCell(i);newcell.innerHTML=table.rows[0].cells[i].innerHTML;
			switch(newcell.childNodes[0].type) { 
				case"text":newcell.childNodes[0].value="";break;
				case"checkbox":newcell.childNodes[0].checked=false;break;
				case"select-one":newcell.childNodes[0].selectedIndex=0;break; 
			}
			newcell.childNodes[0].name=tname; 
			newcell.childNodes[0].id=tname; 
		}
		if(i==2) {
			var tname="qty"+rcount;
			var newcell=row.insertCell(i);newcell.innerHTML=table.rows[0].cells[i].innerHTML;
			switch(newcell.childNodes[0].type) { 
				case"text":newcell.childNodes[0].value="";break;
				case"checkbox":newcell.childNodes[0].checked=false;break;
				case"select-one":newcell.childNodes[0].selectedIndex=0;break; 
			}
			newcell.childNodes[0].name=tname; 
			newcell.childNodes[0].id=tname; 
		}
		if(i==3) {
			var tname="purchase_rate"+rcount;
			var newcell=row.insertCell(i);newcell.innerHTML=table.rows[0].cells[i].innerHTML;
			switch(newcell.childNodes[0].type) { 
				case"text":newcell.childNodes[0].value="";break;
				case"checkbox":newcell.childNodes[0].checked=false;break;
				case"select-one":newcell.childNodes[0].selectedIndex=0;break; 
			}
			newcell.childNodes[0].name=tname; 
			newcell.childNodes[0].id=tname; 
		}
		if(i==4) {
			var tname="discount"+rcount;
			var newcell=row.insertCell(i);newcell.innerHTML=table.rows[0].cells[i].innerHTML;
			switch(newcell.childNodes[0].type) { 
				case"text":newcell.childNodes[0].value="";break;
				case"checkbox":newcell.childNodes[0].checked=false;break;
				case"select-one":newcell.childNodes[0].selectedIndex=0;break; 
			}
			newcell.childNodes[0].name=tname; 
			newcell.childNodes[0].id=tname;
		}
		if(i==5) {
			var tname="discounted"+rcount;
			var newcell=row.insertCell(i);newcell.innerHTML=table.rows[0].cells[i].innerHTML;
			switch(newcell.childNodes[0].type) { 
				case"text":newcell.childNodes[0].value="";break;
				case"checkbox":newcell.childNodes[0].checked=false;break;
				case"select-one":newcell.childNodes[0].selectedIndex=0;break; 
			}
			newcell.childNodes[0].name=tname; 
			newcell.childNodes[0].id=tname; 
		}
		if(i==6) {
			var tname="purchase_val"+rcount;
			var newcell=row.insertCell(i);newcell.innerHTML=table.rows[0].cells[i].innerHTML;
			switch(newcell.childNodes[0].type) { 
				case"text":newcell.childNodes[0].value="";break;
				case"checkbox":newcell.childNodes[0].checked=false;break;
				case"select-one":newcell.childNodes[0].selectedIndex=0;break; 
			}
			newcell.childNodes[0].name=tname; 
			newcell.childNodes[0].id=tname; 
		}
	}
    document.getElementById("norows").value=rcount;
}
function deleteRow(tableID) {
	try {
		var table=document.getElementById(tableID);
		var rowCount=table.rows.length;
		for(var i=0;i<rowCount;i++) {
		   var row=table.rows[i];
		   var chkbox=row.cells[0].childNodes[0];
		   if(null!=chkbox&&true==chkbox.checked) {
			 if(rowCount<=1) {
			 	alert("Cannot delete all the rows.");break;
			 }
			 var fr=row.cells[1].childNodes[0].value;
			 var done_mat_code=document.getElementById('done_mat_code').value;
			 var mat=done_mat_code.replace(fr, "");
			 document.getElementById('done_mat_code').value=mat;
			 table.deleteRow(i);rowCount--;i--;
		   } 
		} 
		document.getElementById("norows").value=rowCount;
	}
	catch(e) { alert(e); }
	calculatetota(); 
}
</script>
<body>


<div id="preloader">
	<div class="loader"></div>
</div>


<div class="page-container">
	
	<?php include("includes/leftmenu.php"); ?>
	
	
	<div class="main-content">
		
		<?php include("includes/header.php"); ?>
		
	 	<div class="main-content-innera">
			
			<div> 
				<div class="col-lg-12 mt-5">
					<div class="card">
						<div class="card-body">
							<h4 class="header-title">Add Purchase</h4>
							<form action="#" method="post" name="rform" enctype="multipart/form-data">
								<input type="hidden" name="submitin" value="<?php print $action; ?>">
								<?php if($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr']; $_SESSION['msgerr']=""; ?></span><div class="cleaner h10"></div><?php } ?>
								<?php if($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg']; $_SESSION['msg']=""; ?></span><div class="cleaner h10"></div><?php } ?>
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">Purchase Req. No.</label>
									<input class="form-control" type="text" name="pur_preqno" id="pur_preqno" required value="<?php print $rowm['pur_preqno']; ?>">
								</div>
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">Invoice Date</label>
									<input class="form-control" type="date" name="pur_invdt" id="pur_invdt" required value="<?php print $rowm['pur_invdt']; ?>">
								</div>
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">Receiving Date</label>
									<input class="form-control" type="date" name="pur_rcvdt" id="pur_rcvdt" required value="<?php print $rowm['pur_rcvdt']; ?>">
								</div>
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">Invoice No.</label>
									<input class="form-control" type="text" name="pur_invno" id="pur_invno" required value="<?php print $rowm['pur_invno']; ?>">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">Party/Supplier</label>
									<select class="form-control" name="pur_sup" id="pur_sup">
										<option value="">Select
										<?php
										$resp=mysqli_query($con,"select `p_id`, `company_name` from `party_master` where `status`='1'");
										while($rowp=mysqli_fetch_object($resp)) {
										?>
											<option value="<?php print $rowp->p_id; ?>" <?php if($rowm['pur_sup']==$rowp->p_id) { ?>selected<?php } ?>><?php print $rowp->company_name ?>
										<?php } ?>
									</select>
								</div>
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">Transport Cost</label>
									<input class="form-control" type="number" name="pur_tcost" id="pur_tcost" step="0.001" value="<?php print $rowm['pur_tcost']; ?>">
								</div>
								
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">Payment Mode</label>
									<select class="form-control" name="pur_pmode" id="pur_pmode">
										<option value="">Select
										<option value="Cash" <?php if($rowm['pur_pmode']=="Cash") { ?>selected<?php } ?>>Cash
										<option value="Credit" <?php if($rowm['pur_pmode']=="Credit") { ?>selected<?php } ?>>Credit
										<option value="UPI" <?php if($rowm['pur_pmode']=="UPI") { ?>selected<?php } ?>>UPI
										<option value="Others" <?php if($rowm['pur_pmode']=="Others") { ?>selected<?php } ?>>Others
									</select>	
								</div>
								<div class="form-group col-3 floatleft">
									<label for="example-text-input" class="col-form-label">If Others (Payment Mode)</label>
									<input class="form-control" type="text" name="pur_pmodeoth" id="pur_pmodeoth" value="<?php print $rowm['pur_pmodeoth']; ?>">	
								</div>
								<div class="cleaner h40"></div>
								<table width="100%" border="0">
									<tr>
										<td colspan="9" align="center">
										   <input type="button" class="btn btn-primary" value="+" onClick="addRow(&#39;dataTable&#39;)">
										   <input type="button" class="btn btn-primary" value="-" onClick="deleteRow(&#39;dataTable&#39;);">
										</td>
									</tr>
									<tr>
										<th width="3%" class="pd0">Chk</th>
										<th width="31%" class="pd0">Product</th>
										<th width="11%" class="pd0">Qty</th>
										<th width="11%" class="pd0">Purchase Rate</th>
										<th width="11%" class="pd0">Dis%</th>
										<th width="11%" class="pd0">Discounted</th>
										<th width="11%" class="pd0">Purchase Val</th>
									</tr>
								</table>	  
								<table id="dataTable" width="100%" border="0">
									<?php 
									if($action=="Add") { 
									?>
										<tr>
											<td width="3%" class="pd0"><input type="checkbox" name="chk1"></td>
											<td width="31%" class="pd0"><input type="text" name="product_ref1" id="product_ref1" class="form-control" style="width: 200px;" onClick="fetchpro(this.name);" required readonly="true"></td>
											<td width="11%" class="pd0"><input type="number" name="qty1" id="qty1" class="form-control inputwide" required step="0.001"  min="0" autocomplete="off" onKeyUp="calculatetot(this.name,3);" onKeyDown="calculatetot(this.name,3);" onBlur="calculatetot(this.name,3);"></td>
											<td width="11%" class="pd0"><input type="text" name="purchase_rate1" id="purchase_rate1" class="form-control inputwide" required onKeyUp="calculatetot(this.name,13);" onKeyDown="calculatetot(this.name,13);" onBlur="calculatetot(this.name,13);" autocomplete="off"></td>
											<td width="11%" class="pd0"><input type="text" name="discount1" id="discount1" class="form-control inputwide" onKeyUp="calculatetot(this.name,8);" onKeyDown="calculatetot(this.name,8);" onBlur="calculatetot(this.name,8);" autocomplete="off"></td>
											<td width="11%" class="pd0"><input type="text" name="discounted1" id="discounted1" class="form-control inputwide"></td>
											<td width="11%" class="pd0"><input type="text" name="purchase_val1" id="purchase_val1" class="form-control inputwide" required></td> 
										</tr>
									<?php 
									} else { 
										$count=1;
										$done_mat_code="";
										$totalitemval=0;
										$totaldiscval=0;
										$totaltaxval=0;
										$netval=0;
										$respi=mysqli_query($con,"select * from `purchase_item` where `pur_id`='".$editid."'");
										while($rowpi=mysqli_fetch_array($respi)) {
											$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product_master` where `pro_id`='".$rowpi['pro_code']."'"));
											if($count==1) {
												$done_mat_code=$rowpi['pro_code'];
											} else {	
												$done_mat_code=",".$rowpi['pro_code'];
											}
									?>
											<tr>
												<td width="3%"><input type="checkbox" name="chk<?php print $count; ?>"></td>
												<td width="31%"><input type="text" name="product_ref<?php print $count; ?>" id="product_ref<?php print $count; ?>"class="form-control" style="width: 200px;" onClick="fetchpro(this.name);" required readonly="true" value="<?php print stripslashes(stripslashes($rowpro['proname']))." -*- ".$rowpi['pro_code']; ?>"></td>
												<td width="11%"><input type="text" name="vol<?php print $count; ?>" id="vol<?php print $count; ?>" class="form-control inputwide" value="<?php print $rowpi['volume']; ?>"></td> 
												<td width="11%"><input type="number" name="qty<?php print $count; ?>" id="qty<?php print $count; ?>" class="form-control inputwide" required step="0.001"  min="0" autocomplete="off" onKeyUp="calculatetot(this.name,3);" onKeyDown="calculatetot(this.name,3);" onBlur="calculatetot(this.name,3);" value="<?php print $rowpi['qty']; ?>"></td>
												<td width="11%"><input type="text" name="purchase_rate<?php print $count; ?>" id="purchase_rate<?php print $count; ?>" class="form-control inputwide" required onKeyUp="calculatetot(this.name,13);" onKeyDown="calculatetot(this.name,13);" onBlur="calculatetot(this.name,13);" autocomplete="off" value="<?php print $rowpi['purchase_rate']; ?>"></td>
												<td width="11%"><input type="text" name="discount<?php print $count; ?>" id="discount<?php print $count; ?>" class="form-control inputwide" onKeyUp="calculatetot(this.name,8);" onKeyDown="calculatetot(this.name,8);" onBlur="calculatetot(this.name,8);" autocomplete="off" value="<?php print $rowpi['discount']; ?>"></td>
												<td width="11%"><input type="text" name="discounted<?php print $count; ?>" id="discounted<?php print $count; ?>" class="form-control inputwide" value="<?php print $rowpi['discounted']; ?>"></td>
												<td width="11%"><input type="text" name="purchase_val<?php print $count; ?>" id="purchase_val<?php print $count; ?>" class="form-control inputwide" required value="<?php print $rowpi['purchase_val']; ?>"></td> 
											</tr>
										<?php $count++; } ?>
										<tr>
											<td width="3%"><input type="checkbox" name="chk<?php print $count; ?>"></td>
											<td width="31%"><input type="text" name="product_ref<?php print $count; ?>" id="product_ref<?php print $count; ?>" class="form-control" style="width: 200px;" onClick="fetchpro(this.name);" required readonly="true"></td>
											<td width="11%"><input type="text" name="vol<?php print $count; ?>" id="vol<?php print $count; ?>" class="form-control inputwide"></td> 
											<td width="11%"><input type="number" name="qty<?php print $count; ?>" id="qty<?php print $count; ?>" class="form-control inputwide" required step="0.001"  min="0" autocomplete="off" onKeyUp="calculatetot(this.name,3);" onKeyDown="calculatetot(this.name,3);" onBlur="calculatetot(this.name,3);"></td>
											<td width="11%"><input type="text" name="purchase_rate<?php print $count; ?>" id="purchase_rate<?php print $count; ?>" class="form-control inputwide" required onKeyUp="calculatetot(this.name,13);" onKeyDown="calculatetot(this.name,13);" onBlur="calculatetot(this.name,13);" autocomplete="off"></td>
											<td width="11%"><input type="text" name="discount<?php print $count; ?>" id="discount<?php print $count; ?>" class="form-control inputwide" onKeyUp="calculatetot(this.name,8);" onKeyDown="calculatetot(this.name,8);" onBlur="calculatetot(this.name,8);" autocomplete="off"></td>
											<td width="11%"><input type="text" name="discounted<?php print $count; ?>" id="discounted<?php print $count; ?>" class="form-control inputwide" ></td>
											<td width="11%"><input type="text" name="purchase_val<?php print $count; ?>" id="purchase_val<?php print $count; ?>" class="form-control inputwide" required></td>  
										</tr>
									<?php } ?>	
								</table>
								<?php if($action=="Add") { ?>
									<div class="cleaner h40"></div>
									<div class="form-group col-md-12 pd0 floatleft lrgtxt ftbld" id="totalval"></div>	
									<div class="cleaner"></div>
									<input type="hidden" name="norows" id="norows" value="1">
									<input type="hidden" name="done_mat_code" id="done_mat_code">
									<input type="hidden" name="totalitemgross" id="totalitemgross" value="0">
									<input type="hidden" name="totalitemgst" id="totalitemgst" value="0">
									<input type="hidden" name="totalitemdis" id="totalitemdis" value="0">
									<input type="hidden" name="totalitemval" id="totalitemval" value="0">
								<?php } else { ?>
									<div class="cleaner h20"></div>
									<?php /* ?><div class="form-group col-md-12 pd0 floatleft lrgtxt ftbld" id="totalval">Gross Amount:&nbsp;<?php print $totalitemval; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Discount:&nbsp;<?php print $totaldiscval; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GST:&nbsp;<?php print $totaltaxval; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Net Amount:&nbsp;<?php print $netval; ?></div><?php */ ?>
									<div class="cleaner"></div>
									<input type="hidden" name="norows" id="norows" value="<?php print $count; ?>">
									<input type="hidden" name="done_mat_code" id="done_mat_code" value="<?php print $done_mat_code; ?>">
									<input type="hidden" name="totalitemgross" id="totalitemgross" value="0">
									<input type="hidden" name="totalitemgst" id="totalitemgst" value="0">
									<input type="hidden" name="totalitemdis" id="totalitemdis" value="0">
									<input type="hidden" name="totalitemval" id="totalitemval" value="<?php print $totalitemval; ?>">
								<?php } ?>	
								<div class="cleaner"></div>
								<input type="checkbox" name="igst" id="igst" value="Yes" <?php if($rowm['pur_igst']=="Yes") { ?>checked<?php } ?>>&nbsp;<strong>IGST</strong><br>
								<button type="submit" class="btn btn-primary mt-4 pr-4 pl-4">Submit</button>
							</form>	
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addpurchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation