Server : LiteSpeed System : Linux premium163.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64 User : infihsqw ( 644) PHP Version : 8.1.29 Disable Function : NONE Directory : /home/infihsqw/futtaim-uae.store/old/controlPanel/ |
<?php
include 'Database.php';
$db = new Database();
$user = $_GET['id'];
$query = "SELECT * FROM `orders` WHERE user = '$user'";
$result = $db->dbQuery($query);
if ($db->dbNumRows($result)) {
$rows = $db->dbFetchResult($result);
foreach ($rows as $row) {
$name = $row['name'];
$phone = $row['phone'];
$location = $row['location'] . '-' . $row['street'];
$payment = $row['first_batch'];
$CashOrBatch = $row['CashOrBatch'] != 0 ? $row['CashOrBatch'] : 'نقدا';
$country = $row['country'];
$city = $row['city'];
$street = $row['street'];
$home = $row['home'];
$zip = $row['zip'];
}
}
$query = "SELECT * FROM users WHERE id = 2";
$result = $db->dbQuery($query);
if ($db->dbNumRows($result)) {
$rows = $db->dbFetchResult($result);
foreach ($rows as $row) {
$Whatsapp = $row['Whatsapp'];
$email = $row['email'];
}
}
$currentDate = date('Y/m/d');
?>
<html lang="ar" dir="rtl">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title> طباعة الفاتورة </title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.10.1/html2pdf.bundle.min.js"></script>
<script>
function pafD() {
let filePDF = this.document.getElementById('main');
html2pdf().from(filePDF).save();
setTimeout(function() {
window.history.back();
}, 1000);
}
</script>
<style>
@import url('https://fonts.googleapis.com/css2?family=Tajawal:wght@200;300;400;500;700;800;900&display=swap');
* {
padding: 0;
margin: 0;
box-sizing: border-box;
font-family: 'Tajawal', sans-serif;
font-size: 12px;
font-weight: 500;
}
:root {
--main-color: #643543
}
body {
padding: 20px;
--main-color: #000
}
.page_invoce {
/* width: 550px; */
margin: 0 auto;
height: auto;
background-color: #fff;
padding: 10px 20px;
}
.Heading_info img {
width: 50px;
}
.flex {
display: flex;
align-items: center;
justify-content: space-between;
}
.center {
display: flex;
align-items: center;
gap: 10px;
}
.NameSite,
.Date {
color: var(--main-color);
font-weight: bold;
font-size: 15px;
}
.info_customer {
margin-top: 20px;
border: 1px solid #989898;
padding: 15px 10px;
border-radius: 10px;
}
.info_customer span,
.text_info_table span {
color: #777;
font-weight: bold;
}
.info_customer div,
.text_info_table div {
color: var(--main-color);
font-weight: bold;
}
.table table {
margin-top: 15px;
border-collapse: collapse;
width: 100%;
}
.table thead tr {
background-color: var(--main-color);
color: #fff;
}
.table thead tr th {
padding: 7px;
}
.table thead tr th {
background-color: #1fa2d8;
color: #fff;
height: 25px;
padding: 0 5px;
line-height: 3;
}
tbody tr {
/*background-color: #e3e3e3;*/
color: var(--main-color);
font-size: 17px;
border-top: 1px solid #fff;
}
tbody tr td {
padding: 7px;
text-align: center;
}
tbody tr:nth-child(even) {
/*background-color: #f2f2f2;*/
}
.table td,
.table th {
padding: .75rem;
vertical-align: top;
border-top: 1px solid #dee2e6;
}
footer {
padding: 10px;
background-color: var(--main-color) !important;
margin-top: 10px;
}
footer div {
color: #fff;
}
.row {
--bs-gutter-x: 1.5rem;
--bs-gutter-y: 0;
display: flex;
flex-wrap: wrap;
margin-top: calc(-1 * var(--bs-gutter-y));
margin-left: calc(-0.5 * var(--bs-gutter-x));
margin-right: calc(-0.5 * var(--bs-gutter-x));
}
.col-6 {
flex: 0 0 auto;
width: 50%;
}
</style>
</head>
</head>
<body>
<!-- <pre></pre> -->
<button onclick="pafD()" style="width: 100px; height: 40px; background-color: #00a8ff; border: 1px solid; color: #ffffff; font-size: 15px;">تحميل</button>
<div id="main" style="padding: 5px;max-width:80%;margin:auto;">
<div class="page_invoce" style="border: 1px solid #000;border-radius: 10px;padding: 30px;">
<div class="Heading_info flex">
<div class="Logo center"><span class="NameSite"><?= $db->get_setting('website_name')?> </span> </div>
<div class="Logo center"><img style="width: 100px;" src="../uploads/<?= $db->get_setting('web_logo')?>"></div>
<div class="Logo center"><span class="NameSite"><?= $db->get_setting('website_name_en')?></span> </div>
</div>
<div class="info_customer flex" style="align-items: flex-start;">
<div class="info_cus">
<div style="color: #f00;"><span>رقم الفاتورة : </span> <?= $user?># </div>
<div><span>اسم العميل : </span> <?= $name ?> </div>
<div><span>رقم الهاتف : </span> <?= $phone ?> </div>
<div><span>البريد الاكتورني : </span> <?= $email ?> </div>
<div><span>رقم الواتس اب : </span> <?= $phone ?> </div>
<div><span>الدولة : </span> <?= $country ?> </div>
<div><span>المدينة : </span> <?= $city ?> </div>
</div>
<div class="info_cus">
<div style="text-align: right;"><span>التاريخ : </span> <?= $currentDate ?></div>
<div style="text-align: right;"><span>العنوان : </span> <?= $location ?> </div>
<div><span>اسم العميل : </span> <?= $name ?> </div>
<div><span>رقم الهاتف : </span> <?= $phone ?> </div>
<div><span>الحي : </span> <?= $location ?> </div>
<div><span>الشارع : </span> <?= $street ?> </div>
<div><span>البيت : </span> <?= $home ?> </div>
<div><span>الرمز البريدي : </span> <?= $zip ?> </div>
</div>
</div>
<hr style="margin-top: 40px;">
<div class="table" style="margin-top: 10px;">
<h4 style="text-align: center;">تفاصيل الطلب</h4>
<div class="table_Res">
<table class="table">
<thead>
<tr>
<th>#</th>
<th>اسم المنتج </th>
<th>الكمية</th>
<th>السعر</th>
</tr>
</thead>
<tbody>
<?php
$totel_price = 0;
$query = "SELECT product_id,quantity FROM `cart` WHERE user = $user";
$result = $db->dbQuery($query);
$count = 0;
if($db->dbNumRows( $result)){
$rows = $db->dbFetchResult($result);
foreach($rows as $row){
$product_id = $row['product_id'];
$query = "SELECT * FROM `products` WHERE product_id = $product_id";
$result = $db->dbQuery($query);
if($db->dbNumRows($result)){
$rows = $db->dbFetchResult($result);
foreach($rows as $rowp){
$count += 1;
if ($rowp['dec'] == 0) {
$totel_price += $rowp['price'] * $row['quantity'];
}else {
$totel_price += $rowp['price']-$rowp['dec'] * $row['quantity'];
}
?>
<tr>
<td><?= $count ?></td>
<td> <?= $rowp['name'] ?> </td>
<td> <?= $row['quantity'] ?> </td>
<td> <?= $rowp['dec'] == 0 ? $rowp['price'] * $row['quantity'] : $rowp['price']-$rowp['dec'] * $row['quantity']?> </td>
</tr>
<?php }
}
}
}
?>
</tbody>
</table>
</div>
</div>
<div class="table" style="margin-top: 10px;">
<div class="text_info_table flex" style="align-items: flex-start;">
<div>
<div style="text-align: right;"><span>مدة الأقساط : </span> <?= $CashOrBatch ?> </div>
<div style="text-align: right; color: #f00"><span>المبلغ الكلي : </span> <?= $totel_price ?> <?= $db->get_setting('currancy')?></div>
</div>
<div>
<div style="text-align: right;"><span>الدفعة الأولى : </span> <?= $payment ?> <?= $db->get_setting('currancy')?></div>
<div style="text-align: right;dispaly:block;margin-top:10px;"><span>الختم : </span> </div>
</div>
</div>
</div>
<div class="table" style="margin-top: 10px;margin-bottom:20px;">
<div>
<div style="text-align: left;"><img style="width: 60px;margin: -15px 13px;transform: rotate(-20deg);" src="../uploads/<?= $db->get_setting('segnature')?>"> </div>
</div>
</div>
<?php if($CashOrBatch != '0'){
?>
<div>
<?php if($CashOrBatch >= 13){?>
<div class="row">
<div class="col-6">
<div>
<table class="table" style="width:100%;margin-top:10px;">
<thead>
<tr>
<th>#</th>
<th>المبلغ</th>
<th>تاريخ الاستحقاق</th>
</tr>
</thead>
<tbody>
<tr>
<th>1</th>
<th><?php print($payment) ?></th>
<th><?php print($currentDate) ?></th>
</tr>
<?php
$first = $CashOrBatch;
$toootal = $totel_price - $payment;
$ee = $toootal / ($first - 1);
$formatted_number = number_format($ee, 2);
for ($i = 1; $i < 12; $i++) {
$new_date = date("Y/m/d", strtotime($currentDate . " +$i months"));;
?>
<tr>
<th><?php print($i + 1) ?></th>
<th><?php print($formatted_number) ?></th>
<th><?php echo "$new_date<br>" ?></th>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
<div class="col-6">
<div>
<table class="table" style="width:100%;margin-top:10px;">
<thead>
<tr>
<th>#</th>
<th>المبلغ</th>
<th>تاريخ الاستحقاق</th>
</tr>
</thead>
<tbody>
<?php
$firstt = $CashOrBatch -13;
$toootal = $totel_price - $payment;
$ee = $toootal / ($first - 1);
$formatted_number = number_format($ee, 2);
for ($i = 0; $i <= $firstt; $i++) {
$nn = $i+ 12;
$new_date = date("Y/m/d", strtotime($currentDate . " +$nn months"));;
?>
<tr>
<th><?php print($i + 13) ?></th>
<th><?php print($formatted_number) ?></th>
<th><?php echo "$new_date<br>" ?></th>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<?php }else{?>
<table class="table" style="width:100%;margin-top:10px;">
<thead>
<tr>
<th>#</th>
<th>المبلغ</th>
<th>تاريخ الاستحقاق</th>
</tr>
</thead>
<tbody>
<tr>
<th>1</th>
<th><?php print number_format($payment,2) ?></th>
<th><?php print($currentDate)?></th>
</tr>
<?php
$first = $CashOrBatch ;
$toootal = $totel_price - $payment;
$ee = $toootal/($first-1);
$formatted_number = number_format($ee, 2);
for ($i = 1; $i < $first; $i++) {
$new_date = date("Y/m/d", strtotime($currentDate . " +$i months"));
;
?>
<tr>
<th><?php print($i +1) ?></th>
<th><?php print($formatted_number) ?></th>
<th><?php echo "$new_date<br>"?></th>
</tr>
<?php } ?>
</tbody>
</table>
<?php }?>
</div>
<?php } ?>
<div class="info_customer flex" style="align-items: flex-start;">
<div class="info_cus" style="border-left: 1px solid #919191;width: 50%;">
<div><span>التوصيل من خلال شركة ارامكس خلال 24 ساعة من تاريخ الفاتورة</span></div>
</div>
<div class="info_cus" style="width: 50%;">
<div style="text-align: left;"><span>Ihave recived the above devive in good<br>
condition with all collected accessories
</span></div>
</div>
</div>
</div>
<br>
<hr>
<footer class="flex">
<div>
<span> <?= $Whatsapp ?> </span>
</div>
<div>
<span> <?= $email ?> </span>
</div>
</footer>
<!-- <div> -->
</div>
<script>
let tbody = document.querySelector(".Table_Tackset table tbody");
let ini = document.getElementById("by").value;
let firstpay = document.getElementById("firstpay").value;
let toatl = document.getElementById("toatl").value;
let cur = document.getElementById("cur").value;
let Resultpay = parseFloat(toatl) - parseFloat(firstpay);
let valFirstpay = Resultpay / ini;
let numpay = 1;
var Toatalpay = parseFloat(firstpay);
var d = new Date();
for(let x = 0 ; x <ini ; x++ )
{
Toatalpay+=valFirstpay;
d.setMonth(d.getMonth() + 1);
var strDate = d.getFullYear() + "/" + (d.getMonth()+1) + "/" + d.getDate();
let temp = `<tr> <td>الدفعة ${x + 1}</td> <td>${strDate}</td> <td>${valFirstpay.toFixed(2)}</td> <td class = "Toatl">${Toatalpay.toFixed(2)}</td> </tr>`;
tbody.innerHTML += temp;
}
</script>
</body>
</html>