411 lines
20 KiB
PHP
Executable File
411 lines
20 KiB
PHP
Executable File
<?php
|
|
require_once('../../../fixed/config/go_con.php');
|
|
|
|
$data = $_POST['data'];
|
|
|
|
$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_note = mysqli_real_escape_string($db, $_POST['card_note']);
|
|
|
|
$tretment_id = mysqli_real_escape_string($db, $_POST['tretment_id']);
|
|
$br_id = mysqli_real_escape_string($db, $_POST['br_id']);
|
|
$day_date = mysqli_real_escape_string($db, $_POST['day_date']);
|
|
|
|
$trans_pay = mysqli_real_escape_string($db, $_POST['trans_pay']);
|
|
$trans_type = mysqli_real_escape_string($db, $_POST['trans_type']);
|
|
$trans_date = mysqli_real_escape_string($db, $_POST['trans_date']);
|
|
$trans_note = mysqli_real_escape_string($db, $_POST['trans_note']);
|
|
|
|
// fix values
|
|
if (empty($cash_pay)) {
|
|
$cash_pay = 0;
|
|
}
|
|
if (empty($card_pay)) {
|
|
$card_pay = 0;
|
|
}
|
|
if (empty($trans_pay)) {
|
|
$trans_pay = 0;
|
|
}
|
|
// fix values
|
|
|
|
$money_stuck = round($data['money_stuck'],2);
|
|
|
|
$book_id = '';
|
|
for ($i=0; $i < count($data['serv']); $i++) {
|
|
$book_id .= $data['serv'][$i]['book_id'] . ',';
|
|
}
|
|
$book_ids = rtrim($book_id, ",");
|
|
$get_invoices_sql = mysqli_query($db, "SELECT * FROM `invoices_has_book` WHERE `book_id` IN ($book_ids)");
|
|
|
|
if (mysqli_num_rows($get_invoices_sql) <= 0) {
|
|
|
|
$total = round($data['total'],2);
|
|
$total_discount = $data['total_discount'];
|
|
$total_add = $data['total_add'];
|
|
$reason = $data['reason'];
|
|
if ($total_discount > 0) {
|
|
$total = round($data['total'] - $total_discount,2);
|
|
}
|
|
if ($total_add > 0) {
|
|
$total = round($data['total'] + $total_add,2);
|
|
}
|
|
if (!empty($vat)) {
|
|
$total_discount = round($total_discount / (($vat/100)+1), 2);
|
|
}
|
|
$payments = round($cash_pay + $card_pay + $trans_pay + $money_stuck,2);
|
|
|
|
$branch_id = $br_id;
|
|
|
|
switch ($branch_id) {
|
|
case '1':
|
|
echo"
|
|
<script>
|
|
swalfun('LR259-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
|
|
case '2': case '3': case '4': case '6':
|
|
$branch_id = 7;
|
|
break;
|
|
|
|
case '5': case '12': case '13':
|
|
$branch_id = 8;
|
|
break;
|
|
|
|
default:
|
|
echo"
|
|
<script>
|
|
swalfun('LR259-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
|
|
|
|
$get_commercial_register_sql = mysqli_query($db, "SELECT
|
|
`branch`.`id`,
|
|
`commercial_register`.`word_tag`
|
|
|
|
FROM `book_details` AS `dd`
|
|
LEFT JOIN `branch` ON `dd`.`branch_id` = `branch`.`id`
|
|
LEFT JOIN `commercial_register` ON `branch`.`commercial_register_id` = `commercial_register`.`id`
|
|
|
|
WHERE `dd`.`book_id` IN ($book_ids)
|
|
AND `dd`.`id` IN (SELECT MAX(`id`) FROM `book_details` WHERE `book_id` = `dd`.`book_id`)
|
|
GROUP BY `commercial_register`.`word_tag`"
|
|
);
|
|
|
|
if (mysqli_num_rows($get_commercial_register_sql) == 1) {
|
|
$row_commercial_register = mysqli_fetch_assoc($get_commercial_register_sql);
|
|
$number_style = date('y', strtotime($date_time)) . "V";
|
|
$get_invoices_sql = mysqli_query($db, "SELECT
|
|
`number`,
|
|
`number_style`
|
|
FROM `invoices`
|
|
WHERE `number_style` LIKE '$number_style%'
|
|
AND `number` IN (SELECT MAX(`number`) FROM `invoices` WHERE `number_style` LIKE '$number_style%')"
|
|
);
|
|
|
|
$number = '';
|
|
if (mysqli_num_rows($get_invoices_sql) > 0) {
|
|
$row_invoices = mysqli_fetch_assoc($get_invoices_sql);
|
|
$number = $row_invoices['number'] + 1;
|
|
$number_style = date('y', strtotime($date_time)) . "V" . str_pad($number, 7, '0', STR_PAD_LEFT);
|
|
} else {
|
|
$number_style = date('y', strtotime($date_time)) . "V" . "0000001";
|
|
$number = 1;
|
|
}
|
|
|
|
|
|
if ($total == $payments) {
|
|
|
|
if(mysqli_query(
|
|
$db,
|
|
"INSERT INTO `invoices`(`number`, `number_style`, `price`,`price_cut`, `invoices_page_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$number','$number_style','$total','$total','1', '$date_time','$admin_id','2')"
|
|
)) {
|
|
$last_id = mysqli_insert_id($db);
|
|
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `invoices_details`(`invoices_id`, `pay`, `branch_id`, `invoices_status_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id','$total','$branch_id','1','$date_time','$admin_id','2')"
|
|
)) {
|
|
|
|
$last_id_2 = mysqli_insert_id($db);
|
|
|
|
if ($total_discount > 0) {
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `invoices_discount`(`discount`, `invoices_details_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$total_discount', '$last_id_2', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
$last_id_3 = mysqli_insert_id($db);
|
|
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `invoices_discount_details`(`discount`, `reason`, `invoices_discount_id`, `services_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$total_discount', '$reason', '$last_id_3','0', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
$last_id_4 = mysqli_insert_id($db);
|
|
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `visits_add_or_desc_reason`(`price`, `reason`, `invoices_id`, `visits_status_inv_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$total_discount', '$reason', '$last_id', '2', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
$last_id_5 = mysqli_insert_id($db);
|
|
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `invoices_discount_details_has_db_tables`(`invoices_discount_details_id`, `db_tables_id`, `db_tables_id_to_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id_4', '16','$last_id_5', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LO425-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LO475-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LO825-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LR225-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
}
|
|
|
|
if ($total_add > 0) {
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `invoices_add`(`add`, `invoices_details_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$total_add', '$last_id_2', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
$last_id_3 = mysqli_insert_id($db);
|
|
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `invoices_add_details`(`add`, `reason`, `invoices_add_id`, `services_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$total_add', '$reason', '$last_id_3','0', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
$last_id_4 = mysqli_insert_id($db);
|
|
|
|
if(mysqli_query($db,
|
|
"INSERT INTO `visits_add_or_desc_reason`(`price`, `reason`, `invoices_id`, `visits_status_inv_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$total_add', '$reason', '$last_id', '2', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
$last_id_5 = mysqli_insert_id($db);
|
|
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `invoices_add_details_has_db_tables`(`invoices_add_details_id`, `db_tables_id`, `db_tables_id_to_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id_4', '16','$last_id_5', '$date_time', '$admin_id', '2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LA425-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LA475-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LA825-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LR225-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
}
|
|
|
|
foreach ($data['serv'] as $one_serv) {
|
|
|
|
// contnue
|
|
$book_id_temp = $one_serv['book_id'];
|
|
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `invoices_has_book`(`invoices_id`, `book_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id','$book_id_temp','$date_time','$admin_id','2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LR220-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
//exit;
|
|
}
|
|
if($total == 0){
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `book_details`(`day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id`, `status_id`, `book_id`, `date_time`, `user_id`, `activation_id`)
|
|
SELECT `book_details`.`day_date`, `book_details`.`day_time`, `book_details`.`services_id`, `book_details`.`branch_id`, `book_details`.`emplyee_id`, '13', `book_details`.`book_id`, '$date_time','$admin_id','2'
|
|
FROM `book_details`
|
|
|
|
WHERE `book_details`.`book_id` = '$book_id_temp'
|
|
AND `book_details`.`id` IN (SELECT MAX(`id`) FROM `book_details` WHERE `book_id` = '$book_id_temp')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LR240-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
} else {
|
|
if(!mysqli_query($db,
|
|
"INSERT INTO `book_details`(`day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id`, `status_id`, `book_id`, `date_time`, `user_id`, `activation_id`)
|
|
SELECT `book_details`.`day_date`, `book_details`.`day_time`, `book_details`.`services_id`, `book_details`.`branch_id`, `book_details`.`emplyee_id`, '12', `book_details`.`book_id`, '$date_time','$admin_id','2'
|
|
FROM `book_details`
|
|
|
|
WHERE `book_details`.`book_id` = '$book_id_temp'
|
|
AND `book_details`.`id` IN (SELECT MAX(`id`) FROM `book_details` WHERE `book_id` = '$book_id_temp')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LR210-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
if (!empty($cash_pay)) {
|
|
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')"
|
|
);
|
|
}
|
|
if (!empty($card_pay)) {
|
|
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')"
|
|
);
|
|
}
|
|
if (!empty($trans_pay)) {
|
|
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','$trans_type','$trans_pay','$trans_note','$date_time','$admin_id','2')"
|
|
);
|
|
}
|
|
if (!empty($money_stuck)) {
|
|
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','4','$money_stuck','','$date_time','$admin_id','2')"
|
|
);
|
|
mysqli_query($db,
|
|
"INSERT INTO `tretment_use_money`(`invoices_details_has_how_pay_invoices_details_id`, `price`, `notes`, `tretment_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id_2','-$money_stuck','','$tretment_id','$date_time','$admin_id','2')"
|
|
);
|
|
}
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LR672-9','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
|
|
require_once('add_to_book_temp_ajax.php');
|
|
echo"
|
|
<script>
|
|
window.open('print.php?inv_id=".$last_id."&p=1');
|
|
window.location.href = 'book_visits?date=".$day_date."';
|
|
</script>
|
|
";
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LA030-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('يرجى التحقق','مدخلات الدفع غير مطابقه المبلغ المستحق','info');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
} else if (mysqli_num_rows($get_commercial_register_sql) > 1) {
|
|
echo"
|
|
<script>
|
|
swalfun('لا يمكن اصدار فاتورة بسبب اختلاف القسم في احد حجوزات العميل','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LQ012-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalthen('تم سداد هذه الجلسة مسبقا','هل تريد الانتقال لصفحة الحجوزات؟','error','book_visits');
|
|
</script>
|
|
";
|
|
}
|
|
|
|
?>
|
|
|