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/billingdemobcode

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewpurchases.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
if(isset($_REQUEST['reject']) && $_REQUEST['reject']=="yes") {
	mysqli_query($con,"update `purchase_header` set `pur_st`='0' where `pur_id`='".$_REQUEST['id']."'");
	$res=mysqli_query($con,"select * from `purchase_item` where `pur_id`='".$_REQUEST['id']."'");
	while($row=mysqli_fetch_array($res)) {
		$rowstk=mysqli_fetch_array(mysqli_query($con,"select * from `stock_table` where `pro_code`='".$row['pro_code']."' and `batch`='".$row['batch']."'"));
		$qty=$rowstk['qty']-$row['qty'];
		mysqli_query($con,"update `stock_table` set `qty`='".$qty."' where `stc_id`='".$rowstk['stc_id']."'");
	}
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']="Purchase is rejected successfully.";
	header("Location:viewpurchases.php#".$got);
	exit();
}
if($_GET['pg']) {
	$pg=$_GET['pg'];
} else {
	$pg=1;
}
$upper=25;
$lower=$upper*($pg-1);
$sql="select * from `purchase_header` where 1";
if(isset($_REQUEST['prno']) && $_REQUEST['prno']!="") {
	$sql.=" and `pur_preqno` like '".$_REQUEST['prno']."%'";
}
if(isset($_REQUEST['invno']) && $_REQUEST['invno']!="") {
	$sql.=" and `pur_invno` like '".$_REQUEST['invno']."%'";
}
if(isset($_REQUEST['invdate']) && $_REQUEST['invdate']!="") {
	$sql.=" and `pur_invdt`='".$_REQUEST['invdate']."'";
}
if(isset($_REQUEST['party']) && $_REQUEST['party']!="") {
	$sql.=" and `pur_sup`='".$_REQUEST['party']."'";
}
$res=mysqli_query($con,$sql);
$num=mysqli_num_rows($res);
$pgno=intval($num/$upper);
if($num%$upper!=0) {
	$pgno=$pgno+1;
}
include("includes/headermain.php"); 
?>
<script language="javascript" type="text/javascript">
function approve(id,got) {
	location.href="viewpurchases.php?id="+id+"&got="+got+"&approve=yes";
}
function reject(id,got) {
	location.href="viewpurchases.php?id="+id+"&got="+got+"&reject=yes";
}
</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-inner">
			
			<div> 
				<div class="col-lg-12 mt-4">
					<div class="card">
						<div class="card-body">
							<h4 class="header-title">List of Purchases</h4>
							<form action="#" method="post">
								<div class="form-group col-md-3 floatleft">
									
									<input class="form-control" type="text" name="prno" id="prno" value="<?php print $_REQUEST['prno']; ?>" placeholder="By P. Req. No.">
								</div>
								<div class="form-group col-md-3 floatleft">
									
									<input class="form-control" type="text" name="invno" id="invno" value="<?php print $_REQUEST['invno']; ?>" placeholder="By Invoice No.">
								</div>
								<div class="form-group col-md-3 floatleft">
									
									<input class="form-control" type="date" name="invdate" id="invdate" value="<?php print $_REQUEST['invdate']; ?>" placeholder="By Invoice Date">
								</div>
								<div class="form-group col-md-3 floatleft">
									
									<select class="form-control" name="party" id="party">
										<option value="">By Party/Supplier
										<?php
										$resp=mysqli_query($con,"select `p_id`, `company_name` from `party_master` where `st`='1'");
										while($rowp=mysqli_fetch_object($resp)) {
										?>
											<option value="<?php print $rowp->p_id; ?>" <?php if($_REQUEST['party']==$rowp->p_id) { ?>selected<?php } ?>><?php print $rowp->company_name ?>
										<?php } ?>
									</select>
								</div>
								<div class="cleaner"></div>
								<button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
							</form>	
							<button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
							<div class="cleaner h20"></div>
							<?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 } ?>
							<table class="table text-center">
								<thead class="text-uppercase bg-primary">
									<tr class="text-white">
										<td align="left">Sl.</td>
										<td align="left">P. Req. No.</td>
										<td align="left">Dates</td>
										<td align="left">Inv No.</td>
										<td align="left">Tran. Cost</td>
										<td align="left">Supplier</td>
										<td align="left">Payment Mode</td>
										<td align="left">Options</td>
									</tr>
								</thead>
								<tbody>
									<?php
									if($lower==0) {
										$flag=0;
									} else {
										$flag=$lower;
									}
									$sql="select * from `purchase_header` where 1";
									if(isset($_REQUEST['prno']) && $_REQUEST['prno']!="") {
										$sql.=" and `pur_preqno` like '".$_REQUEST['prno']."%'";
									}
									if(isset($_REQUEST['invno']) && $_REQUEST['invno']!="") {
										$sql.=" and `pur_invno` like '".$_REQUEST['invno']."%'";
									}
									if(isset($_REQUEST['invdate']) && $_REQUEST['invdate']!="") {
										$sql.=" and `pur_invdt`='".$_REQUEST['invdate']."'";
									}
									if(isset($_REQUEST['party']) && $_REQUEST['party']!="") {
										$sql.=" and `pur_sup`='".$_REQUEST['party']."'";
									}
									$sql.=" order by `pur_id` desc limit $lower,$upper";
									$res=mysqli_query($con,$sql);
									if(mysqli_num_rows($res)>=1) {
										while($row=mysqli_fetch_assoc($res)) {
											$flag++;
											$rowsup=mysqli_fetch_assoc(mysqli_query($con,"select `company_name` from `party_master` where `p_id`='".$row['pur_sup']."'"))
									?>
											<tr <?php if($row['pur_st']=="0") { ?>class="bg-red"<?php } ?> id="go<?php print $row['pur_id']; ?>">
												<td align="left"><?php print $flag; ?></td>
												<td align="left"><?php print $row['pur_preqno']; ?></td>
												<td align="left">
													Inv Date: <?php print dtconvert($row['pur_invdt']); ?><br>
													Rcv Date: <?php print dtconvert($row['pur_rcvdt']); ?>
												</td>
												<td align="left"><?php print $row['pur_invno']; ?></td>
												<td align="left"><?php print $row['pur_tcost']; ?></td>
												<td align="left"><?php print $rowsup['company_name']; ?></td>
												<td align="left">
													<?php print $row['pur_pmode']; ?>
													<?php if($row['pur_pmodeoth']!="") { ?>
														<br>(<?php print $row['pur_pmodeoth']; ?>)
													<?php } ?>
												</td>
												<td align="left">
													<a href="addpurchase.php?action=Edit&editid=<?php print $row['pur_id']; ?>">Edit</a>
													<br><a href="javascript:void();" data-toggle="modal" data-target="#exampleModalLong<?php print $flag; ?>">Details</a>
													<?php if($row['pur_st']=="1") { ?>
														<br><a href="#" onClick="reject(<?php print $row['pur_id']; ?>','<?php print $flag; ?>');return false;">Reject</a>
													<?php } else { ?>	
														<br>Rejected
													<?php } ?>
													
													<div class="modal fade" id="exampleModalLong<?php print $flag; ?>">
														<div class="modal-dialog">
															<div class="modal-content">
																<div class="modal-header">
																	<h5 class="modal-title">Details of Purchase</h5>
																	<button type="button" class="close" data-dismiss="modal"><span>&times;</span></button>
																</div>
																<div class="modal-body">
																	<div style="widtrh: 100%;overflow: auto;">
																		<table width="1000px" border="0" cellpadding="5" cellspacing="1" class="detabl">
																			<tr>
																				<th align="left" colspan="13">View Details</th>
																			</tr>
																			<tr>
																				<th align="left">Sl.</th>
																				<th align="left">Product</th>
																				<th align="left">Expiry Date</th>
																				<th align="left">Batch</th>
																				<th align="left">Qty</th>
																				<th align="left">Free</th>
																				<th align="left">Purchase Rate</th>
																				<th align="left">Discount</th>
																				<th align="left">Discounted Value</th>
																				<th align="left">Purchase Value</th>
																				<th align="left">ROT</th>
																				<th align="left">ED</th>
																				<th align="left">MRP</th>
																			</tr>
																			<tbody>
																				<?php
																				$c=1;
																				$sqlde="select * from `purchase_header` ph, `purchase_item` pi where ph.pur_id=pi.pur_id and ph.pur_id='".$row['pur_id']."'";
																				$resde=mysqli_query($con,$sqlde);
																				while($rowde=mysqli_fetch_array($resde)) {
																					$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product_master` where `pro_code`='".$rowde['pro_code']."'"));
																				?>
																					<tr>
																						<td align='left'><?php print $c; ?></td>
																						<td align='left'><?php print $rowpro['pro_code']; ?><div class="cleaner"></div><?php print $rowpro['pro_name']; ?></td>
																						<td align='left'><?php print $rowde['pur_expdate']; ?></td>
																						<td align='left'><?php print $rowde['batch']; ?></td>
																						<td align='left'><?php print $rowde['qty']; ?></td>
																						<td align='left'><?php print $rowde['purchase_free']; ?></td>
																						<td align='left'><?php print $rowde['purchase_rate']; ?></td>
																						<td align='left'>
																							<?php if($rowde['discount1']) { ?>Dis 1: <?php print $rowde['discount1']; ?>%<?php } ?>
																							<?php if($rowde['discount2']) { ?><br>Dis 2: <?php print $rowde['discount2']; ?>%<?php } ?>
																						</td>
																						<td align='left'><?php print $rowde['discounted']; ?></td>
																						<td align='left'><?php print $rowde['purchase_val']; ?></td>
																						<td align='left'><?php print $rowde['purchase_rot']; ?>%</td>
																						<td align='left'><?php print $rowde['purchase_ed']; ?></td>
																						<td align='left'><?php print $rowde['purchase_mrp']; ?></td>
																					</tr>
																				<?php
																					$c++;
																				}
																				?>
																			</tbody>
																		</table>
																	</div>	
																</div>
																<div class="modal-footer">
																	<button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
																	
																</div>
															</div>
														</div>
													</div>		
												</td>
											</tr>
									<?php }  } else { ?>
										<tr>
											<td colspan="8">Sorry, nothing found.</</td>
										</tr>
									<?php } ?>	
								</tbody>
							</table>
							<?php if($num>=1) { ?>
								<div class="cleaner h20"></div>
								        
								<?php include("includes/pagination.php"); ?>
								    
							<?php } ?>
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewpurchases.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation