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/ccadmultiservices.com/public_html/admin

Free Space:

1.92 TB

🔧 Quick Actions

✏️ Editing: orderindexmbdcn.php

<?php
ob_start();
session_start();
error_reporting(0);
include("includes/inall.php"); 
$sort=$_REQUEST['sort']=="desc"?"asc":"desc";
$orst=$_REQUEST['st'];
foreach($orst as $k=>$val) {
	if($k==0) {
		$orstatus="'".$val."'";
	} else {
		$orstatus.=",'".$val."'";
	}
}
$sql="select * from `orderp` where ((`or_date`<='2022-12-31' and `paymentstatus`='Done') or `or_date`>='2023-01-01') and `medibuddy`='Yes' and `orderstatus`='Order Cancelled'";
if($_REQUEST['fdate']) {
	$sql.=" and `or_date`>='".$_REQUEST['fdate']."'";
}
if($_REQUEST['tdate']) {
	$sql.=" and `or_date`<='".$_REQUEST['tdate']."'";
}
if($_REQUEST['pystatus']) {
	$sql.=" and `paymentstatus`='".$_REQUEST['pystatus']."'";
}
if($_REQUEST['st']) {
	$sql.=" and `orderstatus` in (".$orstatus.")";
}
if($_REQUEST['kwrd']) {
	$sql.=" and `or_id`='$_REQUEST[kwrd]'";
}
$sql.=" order by `order_id` ".$sort;
$res=mysqli_query($con,$sql);
$num=mysqli_num_rows($res);
if(isset($_REQUEST['asbut']) && $_REQUEST['asbut']=="Assign") {
	$ordids=$_POST['ord'];
	$assgdto=$_POST['assgdto'];
	$ordst=$_POST['ordst'];
	$pymst=$_POST['pymst'];
	foreach($ordids as $val) {
		mysqli_query($con,"update `orderp` set `stkpoint`='".$assgdto."' where `or_id`='".$val."'");
		if(isset($ordst) && $ordst!="") {
			mysqli_query($con,"update `orderp` set `orderstatus`='".$ordst."' where `or_id`='".$val."'");
		}
		if(isset($pymst) && $pymst!="") {
			mysqli_query($con,"update `orderp` set `paymentstatus`='".$pymst."' where `or_id`='".$val."'");
		}
	}
	header("location:orderindexmd.php");
	exit();
}
if(isset($_REQUEST['ornoc']) && $_REQUEST['ornoc']!="" && $_REQUEST['cancel']=="true") {
	mysqli_query($con,"update `orderp` set `orderstatus`='Order Cancelled' where `or_id`='".$_REQUEST['ornoc']."'");
	$roword=mysqli_fetch_array(mysqli_query($con,"select * from `orderp` where `or_id`='".$_GET['ornoc']."'"));
	mysqli_query($con,"update `orderpro` set `status`='Order Cancelled' where `orderpro_ref`='".$roword['order_id']."'");
	$resy=mysqli_query($con,"select * from `orderp` where `or_id`='".$_REQUEST['ornoc']."'");
	$rowy=mysqli_fetch_array($resy);
	$resya=mysqli_query($con,"select * from `orderpro` where `orderpro_ref`='".$rowy['order_id']."'");
	while($rowya=mysqli_fetch_array($resya)) { 
		$resyb=mysqli_query($con,"select * from `products` where `pro_id`='".$rowya['orderpro_pro']."'");
		$rowyb=mysqli_fetch_array($resyb);
		$cstock=$rowyb['instock'];
		$sto=$cstock+$rowya['orderpro_qty'];
		mysqli_query($con,"update `products` set `instock`='".$sto."' where `pro_id`='".$rowya['orderpro_pro']."'");
	}
	header("location:orderindexmd.php");
	exit();
}
if(isset($_REQUEST['ornoc']) && $_REQUEST['ornoc']!="" && $_REQUEST['delete']=="true") {
	/*$resya=mysqli_query($con,"select * from `orderpro` where `orderpro_ref`='".$_REQUEST['ornoc']."'");
	while($rowya=mysqli_fetch_array($resya)) { 
		$resyb=mysqli_query($con,"select * from `products` where `pro_id`='".$rowya['orderpro_pro']."'");
		$rowyb=mysqli_fetch_array($resyb);
		$cstock=$rowyb['instock'];
		$sto=$cstock+$rowya['orderpro_qty'];
		mysqli_query($con,"update `products` set `instock`='".$sto."' where `pro_id`='".$rowya['orderpro_pro']."'");
	}*/
	mysqli_query($con,"delete from `orderp` where `order_id`='".$_REQUEST['ornoc']."'");
	mysqli_query($con,"delete from `orderpro` where `orderpro_ref`='".$_REQUEST['ornoc']."'");
	$_SESSION['msg']="Order is deleted.";
	header("location:orderindexmd.php");
	exit();
}
include("includes/headermain.php");
?>
<script language="javascript" type="text/javascript">
function del(id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href="myleads.php?id="+id+"&delete=yes";
	}	
}
function approve(id,got) {
	location.href="myleads.php?id="+id+"&got="+got+"&approve=yes";
}
function reject(id,got) {
	location.href="myleads.php?id="+id+"&got="+got+"&reject=yes";
}
</script>
<body class="body-bg">


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


<div class="horizontal-main-wrapper">
	<?php include("includes/header.php"); ?>
	
	<div class="main-content">
	 	<div class="main-content-inner">
			
			<div> 
				<div class="col-lg-12 mt-5">
					<div class="card">
						<div class="card-body">
							<form method="get" action="orderindexmd.php">
								<table class="ordtbl">
									<tbody>
										<tr>
											<td colspan="4">&nbsp;<strong>Select Date</strong></td>
										</tr>
										<tr>
											<td align="right">
												&nbsp;From&nbsp;
												<input type="date" name="fdate" id="fdate" value="<?php print $_REQUEST['fdate']; ?>">
											</td>
											<td align="left">
												To&nbsp;
												<input type="date" name="tdate" id="tdate" class="inputvalue" value="<?php print $_REQUEST['tdate']; ?>">
											</td>
											<td align="right"></td>
											<td align="left">
												<select class="form-control wd200 floatleft" name="pystatus" id="pystatus" style="height: 45px;">
													<option value="">Select
													<option value="Done" <?php if($_REQUEST['pystatus']=="Done") { ?>selected<?php } ?>>Payment Done
													<option value="Not Done" <?php if($_REQUEST['pystatus']=="Not Done") { ?>selected<?php } ?>>Payment Not Done
												</select>
											</td>
										</tr>
										<tr>
											<td colspan="4">&nbsp;</td>
										</tr>
										<tr>
											<td height="10" class="button" colspan="4" align="center">
												<input type="Submit" name="butt" value="Search" class="btn btn-primary pr-4 pl-4">
											</td>
										</tr>
										<tr>
											<td colspan="4" height="10"></td>
										</tr>
									</tbody>    
								</table>
							</form>	
							<form method="post" action="#">
							<table class="ordtbl">
								<tbody>
									<?php /* ?><tr>
										<td colspan="9">
											<span id="OPC">Order in status <?php print $_REQUEST['st'] ?></span>
											&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
											<a href="excelorder.php?st=<?php print $orstatus; ?>&fdate=<?php print $_REQUEST['fdate']; ?>&tdate=<?php print $_REQUEST['tdate']; ?>" target="_blank">Export to Exccel</a>
										</td>
									</tr><?php */ ?>
									<tr>
										<td colspan="20"><?php if($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg']; $_SESSION['msg']=""; ?></span><div class="cleaner h10"></div><?php } ?></td>
									</tr>
									<tr>
										<td align="center">Sl.</td>
										<td align="left">Order Number</td>
										<td align="left">Status</td>
										<td align="center">Assigned To</td>
										<td align="left">Payment Status</td>
										<td align="left">Customer Name</td>
										<td align="center"><a href="orderindexmd.php?sort=<?php print $sort; ?>">Order Date</a></td>
										<td align="center">Qty</td>
										<td align="left">Discount</td>
										<td align="left">Amount</td>
										<td align="left">Options</td>
										<td align="left">Ag ID</td>
										<td align="left">Ag Name</td>
										<td align="left" width="20%">Remarks</td>
									</tr>
									<?php 
									$count=1;
									$total=0;
									if (mysqli_num_rows($res)>=1) {
										while($row=mysqli_fetch_array($res)) {
											$total+=$row['or_net'];
											$rowadd=mysqli_fetch_array(mysqli_query($con,"select `cusid`, `fname`, `lname`, `addedby` from `medibuddy` where `reg_id`='".$row['cusid']."'"));$reschk=mysqli_query($con,"select * from `orderpro` where `orderpro_ref`='".$row['order_id']."' order by `orderpro_id` desc");
											$rowstk=mysqli_fetch_array(mysqli_query($con,"select `cusid`, `fname`, `mname`, `lname` from `registration` where `reg_id`='".$row['stkpoint']."'"));
											$rowag=mysqli_fetch_array(mysqli_query($con,"select `cusid`, `fname`, `lname` from `registration` where `cusid`='".$rowadd['addedby']."'"));
									?>
											<tr>
												<td align="center">
													<?php print $count; ?>
												</td>
												<td align="left">
													<input type="checkbox" name="ord[]" value="<?php print $row['or_id']; ?>">
													<a href="orderdetails.php?orno=<?php print $row['or_id']; ?>">
														<?php print $row['or_id']; ?>
													</a>
													<br>(<?php print $row['or_inv_no']; ?>)
												</td>
												<td align="left">
													<?php print $row['orderstatus']; ?>
												</td>
												<td align="center">
													<?php print $rowstk['fname']; ?> <?php print $rowstk['lname']; ?><br>
													<?php if($row['assgdto']!="") { ?>
														(<?php print $rowstk['cusid']; ?>)
													<?php } ?>
												</td>
												<td align="left">
													<?php print $row['paymentstatus']; ?>
													<?php if($row['paymode']=="Cash") { ?>
														<br>(Cash, Ref No. <?php print $row['prefno']; ?>)<?php if($row['pscrimg']!="") { ?>&nbsp;<a href="products/<?php print $row['pscrimg']; ?>" target="_blank">Receipt</a><?php } ?>
													<?php } if($row['paymentstatus']=="Cash") { ?>
														<br>Online
													<?php } ?>
												</td>
												<td align="left">
													<?php print $rowadd['fname']; ?> <?php print $rowadd['mname']; ?> <?php print $rowadd['lname']; ?> (<?php print $rowadd['cusid']; ?>)
												</td>
												<td align="center">
													<?php print dtconvert($row['or_date']); ?>
												</td>
												<td align="center">
													<?php print mysqli_num_rows($reschk); ?>
												</td>
												<td align="left"><?php if($row['or_discount']!="") { ?>Rs. <?php print $row['or_discount']; ?><?php } ?></td>
												<td align="left">Rs.
													<?php print $row['or_net']; ?>
												</td>
												<td align="left">
													<a href="orderdetails.php?ornoc=<?php print $row['order_id']; ?>&delete=true">Delete</a>
												</td>
												<td align="center">
													<?php print $rowag['cusid']; ?>
												</td>
												<td align="center">
													<?php print $rowag['fname']; ?> <?php print $rowag['lname']; ?>
												</td>
												<td align="left">
													<?php print $row['remarks']; ?>
												</td>
											</tr>
									<?php 
											$count++; 
										} 
									?>
										<tr>
											<td align="right" colspan="9"><strong>Total</strong></td>
											<td align="left" colspan="5"><strong>Rs. <?php print $total; ?></strong></td>
										</tr>
									<?php	
									} 
									if(mysqli_num_rows($res)<1) { 
									?>
										<tr>
											<td align="center" colspan="20">Sorry, Nothing Found.</td>
										</tr>
									<?php } ?>
									<tr>
										<td colspan="15">&nbsp;</td>
									</tr>
								</tbody>
							</table>
							</form>
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>


<script src="assets/js/vendor/jquery-2.2.4.min.js"></script>

<script src="assets/js/popper.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/metisMenu.min.js"></script>
<script src="assets/js/jquery.slimscroll.min.js"></script>
<script src="assets/js/jquery.slicknav.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.2/Chart.min.js"></script>

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>

<script src="https://www.amcharts.com/lib/3/amcharts.js"></script>
<script src="https://www.amcharts.com/lib/3/ammap.js"></script>
<script src="https://www.amcharts.com/lib/3/maps/js/worldLow.js"></script>
<script src="https://www.amcharts.com/lib/3/serial.js"></script>
<script src="https://www.amcharts.com/lib/3/plugins/export/export.min.js"></script>
<script src="https://www.amcharts.com/lib/3/themes/light.js"></script>

<script src="assets/js/line-chart.js"></script>

<script src="assets/js/pie-chart.js"></script>

<script src="assets/js/bar-chart.js"></script>

<script src="assets/js/maps.js"></script>

<script src="assets/js/plugins.js"></script>
<script src="assets/js/scripts.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: orderindexmbdcn.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation