151 lines
6.2 KiB
PHP
Executable File
151 lines
6.2 KiB
PHP
Executable File
<?php
|
|
require_once('../../../fixed/config/go_con.php');
|
|
|
|
$book_id = mysqli_real_escape_string($db, $_POST['book_id']);
|
|
|
|
|
|
$add_on = mysqli_real_escape_string($db, $_POST['add_on']);
|
|
$add_on_note = mysqli_real_escape_string($db, $_POST['add_on_note']);
|
|
$price = mysqli_real_escape_string($db, $_POST['price']);
|
|
|
|
|
|
$cash_pay = mysqli_real_escape_string($db, $_POST['cash_pay']);
|
|
$cash_note = mysqli_real_escape_string($db, $_POST['cash_note']);
|
|
|
|
$card_pay = mysqli_real_escape_string($db, $_POST['card_pay']);
|
|
$card_type = mysqli_real_escape_string($db, $_POST['card_type']);
|
|
$card_approval_number = mysqli_real_escape_string($db, $_POST['card_approval_number']);
|
|
if (empty($card_approval_number)) {
|
|
$card_approval_number = 0;
|
|
}
|
|
$card_note = mysqli_real_escape_string($db, $_POST['card_note']);
|
|
|
|
// fix values
|
|
if (empty($cash_pay)) {
|
|
$cash_pay = 0;
|
|
}
|
|
if (empty($card_pay)) {
|
|
$card_pay = 0;
|
|
}
|
|
// fix values
|
|
|
|
$get_add_on_product_sql = mysqli_query($db, "SELECT `id`, `name`, `price` FROM `add_on_product` WHERE `id`= '$add_on' AND `activation_id` = 2 LIMIT 1");
|
|
if (mysqli_num_rows($get_add_on_product_sql) > 0) {
|
|
$row_add_on_product = mysqli_fetch_assoc($get_add_on_product_sql);
|
|
if (!empty($vat)) {
|
|
$pack_price_from_db = round($row_add_on_product['price'] + (($row_add_on_product['price']*$vat)/100),2);
|
|
} else {
|
|
$pack_price_from_db = round($row_add_on_product['price'],2);
|
|
}
|
|
$current_price = $price;
|
|
$payments = $cash_pay + $card_pay;
|
|
if ($current_price == $pack_price_from_db && $pack_price_from_db == $payments) {
|
|
|
|
$get_invoice_sql = mysqli_query($db, "SELECT
|
|
`invoices_id`
|
|
FROM `invoices_has_book`
|
|
WHERE `activation_id` = 2
|
|
AND `book_id` = $book_id"
|
|
);
|
|
|
|
$number = '';
|
|
if (mysqli_num_rows($get_invoice_sql) > 0) {
|
|
$row_invoice = mysqli_fetch_assoc($get_invoice_sql);
|
|
$inv_id = $row_invoice['invoices_id'];
|
|
|
|
if(mysqli_query(
|
|
$db,
|
|
"UPDATE `invoices` SET `price`=(`price` + $payments),`price_cut`=(`price_cut` + $payments) WHERE `id` = $inv_id"
|
|
)) {
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `invoices_details`(`pay`, `invoices_id`, `invoices_status_id`, `branch_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$payments','$inv_id','2','$admin_branch_id','$date_time','$admin_id','2')"
|
|
)) {
|
|
$last_id_2 = mysqli_insert_id($db);
|
|
if (!empty($cash_pay)) {
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `invoices_details_has_how_pay`(`invoices_details_id`, `how_pay_id`, `pay`, `notes`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id_2','1','$cash_pay','$cash_note','$date_time','$admin_id','2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LS210-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
}
|
|
if (!empty($card_pay)) {
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `invoices_details_has_how_pay`(`invoices_details_id`, `how_pay_id`, `pay`, `notes`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id_2','2','$card_pay','$card_note','$date_time','$admin_id','2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LC210-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
}
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `book_has_add_on_product`(`book_id`, `add_on_product_id`, `note`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$book_id','$add_on','$add_on_note','$date_time','$admin_id','2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('FC210-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
echo "
|
|
<script type='text/javascript'>
|
|
window.location.href = 'book.php';
|
|
</script>
|
|
";
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LI210-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LA030-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LM122-8','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('يرجى التحقق','مدخلات الدفع غير مطابقه المبلغ المستحق','info');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LQ332-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
?>
|
|
|