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

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 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	13000.88 KB	0644	🗑️ ⬇️ ✏️

Editing: display.php

<?php

$itemsPerPage = 10;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$offset = ($page - 1) * $itemsPerPage;

$realsql = "SELECT COUNT(*) AS total from orders WHERE pay_status='paid'  ORDER BY date DESC,updatedTime DESC";
$sql = "SELECT * from orders WHERE pay_status='paid' ORDER BY date DESC,updatedTime DESC LIMIT $offset, $itemsPerPage";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
$order_phone=$row['number'];

$ord=$row['orderid'];
$dem=$row['date'];
$payment=$row['payment'];
$status=$row['status'];
$total=$row['total_amount'];
$type=$row['type'];
$state=$row['delivery_state'];
$fee=$row['deliveryfee'];
$pricing=$row['pricing'];
$c_name=$row['staff'];
$c_phone=$row['number'];
$c_mail=$row['email'];  
$cashier=$row['cashier']; 
$banks=$row['bank_amount'];
$cashs=$row['cash_amount'];
$pos=$row['pos_amount'];
$gifts=$row['gift_amount'];
$cards=$row['card_amount'];
$wallets=$row['wallet_amount'];

$order_discount=0;
$per_discount="";
$checkEmail = mysqli_query($con, "SELECT * FROM discount_orders WHERE orderid='$ord'");
if(mysqli_num_rows($checkEmail) > 0 ) {
$sqls = "SELECT * from discount_orders WHERE orderid='$ord'";
$sql2s = mysqli_query($con,$sqls);
while ($rows = mysqli_fetch_array($sql2s)) {
$order_discount=$rows['discount'];
$per_discount= $order_discount.'%';
}}

// Calculate total amount of all items
$producttotal = 0;
$sqls = "SELECT COALESCE(SUM(price), 0) FROM stock_orders WHERE orderid='$ord' AND status='yes'";
$sql2s = mysqli_query($con, $sqls);
$rows = mysqli_fetch_array($sql2s);
$producttotal = $rows[0];

$order_discount = $producttotal * ($order_discount/100);
$paid_now=$banks+$cashs+$pos+$gifts+$cards+$wallets;
$paid_left=$total-$paid_now;
$waiver="";

// Set default value for notes if empty
$notes = $notes ?: "None";

$cancel = "";
if ($stat == "superadmin" && $status == "yes") {
$cancel = "<td><p><button data-toggle='modal' data-target='#cancel$ord' class='btn btn-sm btn-primary shadow-sm'>Cancel Order</button></p></td>";
} else {
$cancel = "<td>Null</td>";
}

$balancebtn="<button data-toggle='modal' data-target='#balance".$ord."' class='dropdown-item'>View Accounts</button>";
               
               
               
               
echo "
   <tr bgcolor='#fff'>
   <td width='200px' >" . $ord . " <br> 
   <div class='dropdown'>
   <button class='btn btn-primary btn-sm dropdown-toggle' type='button' id='dropdownMenuButton1' data-toggle='dropdown' $disableothers> Actions </button>
    <div class='dropdown-menu dropdown-menu-right'>
    <h6 class='dropdown-header'>Actions</h6>
   <form action='editorders.php' method='post'>
   <input type='text' name='orderid' value='" . $ord . "' required hidden>  
   <button type='submit' class='dropdown-item'  type='submit' name='submi' value='Edit' class='btn btn-sm btn-primary shadow-sm'>Edit Order</button></form>
   $balancebtn
   </div>
   </div>
  </td>
  <td width='200px'>$c_name<br>$c_phone<br>$c_mail</td>
   <td width='200px' >" . $row['method'] . "</td>
   <td width='200px'>" . $row['date'] ."</td>
   <td width='200px'>&#8358;" . formatNumber($total)."</td>
   <td width='200px'>" . $row['cashier'] . "</td>
   <td width='200px'>" . $notes . "</td>
   <td width='200px'>" . $payment . "</td>
   
    <div class='modal fade' id='cancel$ord' role='dialog'  tabindex='-1'>
    <div class='modal-dialog modal-dialog-scrollable  modal-dialog-centered'>
    <div class='modal-content'>
    <div class='modal-header'>
    <h6 class='modal-title w-100 text-center' style='color:black;'>Cancel Order?</h6>
    </div>
        <div class='modal-body w-100 text-center' style='color:#FFFFFF;'>
        <p style='color:black; font-weight:500;'>Are you sure you want to cancel this order by(" . $row['staff'] . ")</p>
	    <p><form action='' method='get' >
        <input type='text' name='orderid' value='". $row['orderid'] . "' required hidden />  
        <button style='background-color:#FF339A;' value='cancel' class='btn btn-sm btn-primary shadow-sm' type='submit' name='cancelorder'>Yes,Cancel Order</button></p></form>	
        
        <p><button class='btn btn-sm btn-primary shadow-sm' data-dismiss='modal'>No,stop action</button></p>
      </div></div></div></div>

<style>

@media print {
  .con {
    display: none;
  }

@page {
    size: 80mm 297mm;
    margin:none;
  }

body * {
    visibility: hidden;
    margin: none;
   overflow: hidden;
   font-size:14px;
   font-weight:600;
   page-break-after: always;
                                                
  }

.print-section {
   page-break-after: always;
  }

#modal".$ord.", #modal".$ord." * {
    visibility: visible;
  }

.head{
        width:0px;
        display: none;
   }   
  .no-page-break {
    page-break-inside: avoid;
  }

html, body {
    height:100%; 
    overflow: hidden;
    }
  
  
  /* Set the width of the content area to match the receipt width */
  #modal".$ord." {
    width: 110mm;
    margin: 0;
    padding: 5px 0;
    box-sizing: border-box;
    overflow: hidden;
    height: 1122px;
  }
}

</style>

<td><button class='btn btn-sm btn-primary shadow-sm' style='font-size:10px;' type='button' data-toggle='modal' data-target='#modal".$ord."'>
   VIEW TRANSACTION</button>
   
<div class='modal fade ReModal print-section' id='modal".$ord."' tabindex='-1' data-bs-backdrop='false'>
<div class='modal-dialog' role='document'>
<div class='modal-content'>
<div class='modal-body' style='color:black;'>
<p style='text-align:center; font-size:10px;'>
<img src='https://chbluxuries.com/img/luxury.png' width='60px' height='60px' /><br>
<b>CHBLUXURY EMPIRE</b><br> 
Wholesale & retail beauty supply store<br> 
No 19 olowu street off awolowo way Ikeja, lagos<br>
Tel: 0913-394-1333, 0902-557-2552</p>

<p style='text-align:left;'>
<span >Invoice No : $ord
<br>Invoice Date: ".$dem."</span>
<br>Bill To: ".$c_name." Phone: $c_phone
<br>Processed By: $cashier
</p>

.kayd td, .kayd th {
    border: none ;
    height:10px;
}
}

.kayd td, .kayd th {
    border: none ;
}
</style>";
 
include "transact.php";
 
echo"
<p style='text-align:center; font-size:7px; text-transform:uppercase;'>
Goods Return & exchange policy <br>
For hygiene reasons, we do not offer exchanges or returns except in cases of deflective goods and such goods can only be returned within 48 hours of purchased. 
Goods must be returned intact, as supplied in their original packs<br>
No cash refund<br>
Sales invoice must be tendered at the time of return<br>
No Return Based on Price Compliants<br>
<center><span style='font-size:7px;'><i>Thanks for your patronage. Please come again</i></span></center></p> 
 
</div>
<div class='modal-footer'>
<button class='btn btn-sm btn-primary shadow-sm' data-dismiss='modal'>Close Popup</button>
<form method='post' action='printinvoice.php'><button type='submit' value='$ord' name='printinvoice' class='btn btn-sm btn-primary shadow-sm con'>Print Invoice</button></form>
<button type='button' class='btn btn-sm btn-primary shadow-sm con' onclick='functionPrint()' data-dismiss='modal'>Print Receipt</button>
<form id='myForms' action='a4reciept.php'  method='get' target='_blank'><input type='hidden' name='btns' value='$ord' /> <button type='submit'  onclick='submitForms()' class='btn btn-sm btn-primary shadow-sm con'>Print A4 Reciept</button></form>
<form method='post' action='printdetails.php'><button type='submit' value='$ord' name='printship' class='btn btn-sm btn-primary shadow-sm con'>Print Shipping Details</button></form>
</div>
    </div>
  </div>
</div>";

<div class="modal fade" id="balance<?php echo $ord; ?>">
  <div class="modal-dialog modal-dialog-scrollable modal-dialog-centered">
    <div class="modal-content">
      <div class="modal-header">
        <h6 style="color:black;">Order Account <?php echo $ord; ?></h6>
      </div>
      <div class="modal-body">
          <form action='' method="post">
          <input type="hidden" name="productrow" value="<?php echo $ord; ?>">
          <input type="hidden" name="totalnow" class="totalNow" value="">
          <label>Total Product Amount</label><input type="number" class="form-control total-input" min="0" value="<?php echo $producttotal; ?>" name="total" required><br>
          <label>Delivery Fee</label><input type="number" class="form-control total-input" min="0" value="<?php echo $fee; ?>" name="fee" required><br>
          <label>Bank Amount</label><input type="number" class="form-control payment-input" min="0" value="<?php echo $banks; ?>" name="bank" required><br>
          <label>Cash Amount</label><input type="number" class="form-control payment-input" min="0" value="<?php echo $cashs; ?>" name="cash" required><br>
          <label>POS Amount</label><input type="number" class="form-control payment-input" min="0" value="<?php echo $pos; ?>" name="pos" required><br>
          <label>Card Amount</label><input type="number" class="form-control payment-input" min="0" value="<?php echo $cards; ?>" name="card" required readonly><br>
          <label>Giftcard Amount</label><input type="number" class="form-control payment-input" min="0" value="<?php echo $gifts; ?>" name="gift" required readonly><br>
          <label>Wallet Amount</label><input type="number" class="form-control payment-input" min="0" value="<?php echo $wallets; ?>" name="wallet" required readonly><br>
          <label>Apply Waiver</label><input type="number" value="0" class="form-control waiver-input" min="0" max="100" name="waiver" required><br>
          <button name="addaccount" class="btn btn-sm btn-primary" type="submit" value="ModifyPrice">Update Account</button>
          <button class='btn btn-sm btn-danger shadow-sm' data-dismiss='modal'>Close Popup</button><br><br>
          <div class="text-primary">
          <p>Total Product Amount after Waiver: <span class="totalAfterWaiverDisplay"><?php echo $producttotal; ?>.00</span></p>
          <p>Total Paid: <span class="totalPaidDisplay"><?php echo $paid_now; ?>.00</span></p></form>
        </div>
      </div>
    </div>
  </div>
</div>

<?php echo"</td>$cancel</tr>"; }?>

if (waiverInput) {
      var waiverPercentage = parseFloat(waiverInput.value);
    } else {
      console.error("Waiver input not found!");
      return;
    }

// Calculate total after waiver
      var totalAfterWaiver = totalAmount - (totalAmount * (waiverPercentage / 100));

// Update displayed total after waiver
    form.querySelector(".totalAfterWaiverDisplay").innerText = totalAfterWaiver.toLocaleString("en-US", { style: "currency", currency: "NGN" });
    form.querySelector(".totalNow").value = totalAfterWaiver;

// Update total paid (sum of payment methods)
    updateTotalPaid(form);
  }

function updateTotalPaid(form) {
    var totalPaid = 0;
    form.querySelectorAll(".payment-input").forEach(function(input) {
      totalPaid += parseFloat(input.value);
    });
    // Update displayed total paid
    form.querySelector(".totalPaidDisplay").innerText = totalPaid.toLocaleString("en-US", { style: "currency", currency: "NGN" });

}

// Select all modal forms
  var modalForms = document.querySelectorAll(".modal.fade form");

// Add event listeners to each form individually
  modalForms.forEach(function(form) {
    form.querySelectorAll(".total-input, .waiver-input").forEach(function(input) {
      input.addEventListener("input", function() {
        calculateTotal(form); // Update total amount after waiver
      });
    });

// Add event listeners to payment input fields
    form.querySelectorAll(".payment-input").forEach(function(input) {
      input.addEventListener("input", function() {
        updateTotalPaid(form); // Update total paid
      });
    });

});
});

function calculateTotal(form) {
    var totalAmount = parseFloat(form.querySelector(".total-input").value); // Get total amount
    var waiverInput = form.querySelector(".waiver-input");

if (waiverInput) {
      var waiverPercentage = parseFloat(waiverInput.value);
    } else {
      console.error("Waiver input not found!");
      return;
    }

// Calculate total after waiver
      var totalAfterWaiver = totalAmount - (totalAmount * (waiverPercentage / 100));

// Update total paid (sum of payment methods)
    updateTotalPaid(form);
  }

}
  
function recalculateForNewForm(form) {
    calculateTotal(form);
    updateTotalPaid(form);
 
  // Select all modal forms
  var modalForms = document.querySelectorAll(".modal.fade form");

});
}
</script>

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

Editing: display.php

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