325 lines
14 KiB
PHP
Executable File
325 lines
14 KiB
PHP
Executable File
<?php
|
|
require_once('../../../fixed/config/go_con.php');
|
|
|
|
$booking_id = mysqli_real_escape_string($db, $_POST['booking_id']); // to cancle a brevise book
|
|
if (true) {
|
|
|
|
if (!empty($booking_id)) {
|
|
$get_booking_sql = mysqli_query($db, "SELECT `day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id` FROM `book_details` WHERE `book_id` = '$booking_id' ORDER BY `date_time` DESC LIMIT 1");
|
|
if (mysqli_num_rows($get_booking_sql) == 1) {
|
|
$row = mysqli_fetch_assoc($get_booking_sql);
|
|
$day_date = $row['day_date'];
|
|
$day_time = $row['day_time'];
|
|
$the_service = $row['services_id'];
|
|
$emplyee_id = $row['emplyee_id'];
|
|
$branch_id = $row['branch_id'];
|
|
$why = "-";
|
|
|
|
mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_details`(`day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id`, `notes`, `status_id`, `user_id`, `activation_id`, `date_time`, `book_id`)
|
|
VALUES ('$day_date','$day_time','$the_service','$branch_id','$emplyee_id','$why','25','$admin_id','2','$date_time','$booking_id')"
|
|
);
|
|
}
|
|
}
|
|
|
|
$tretment_id = mysqli_real_escape_string($db, $_POST['tretment_id']); // in booking_ajax.php
|
|
$booking_the_service = mysqli_real_escape_string($db, $_POST['theService']);
|
|
$booking_notes = mysqli_real_escape_string($db, $_POST['booking_notes']);
|
|
$emp_id = mysqli_real_escape_string($db, $_POST['emp_id']);
|
|
$booking_day_date = mysqli_real_escape_string($db, $_POST['booking_day_date']);
|
|
$booking_day_time = mysqli_real_escape_string($db, $_POST['booking_day_time']);
|
|
$branch_id = mysqli_real_escape_string($db, $_POST['branch_id']);
|
|
$bundle_id = mysqli_real_escape_string($db, $_POST['bundle_id']);
|
|
$how_hear = mysqli_real_escape_string($db, $_POST['how_hear']);
|
|
|
|
|
|
//sms
|
|
$just_U = 'LkjgHJKLGjklHLJKhgjklGHHJKLghjkGKLU';
|
|
|
|
if (!in_array(65, $rolls)) {
|
|
if ((strtotime($date_time) - (3600*14)) > strtotime($booking_day_date .' '. $booking_day_time)) {
|
|
echo "
|
|
<script>
|
|
swalfun('حدث خطأ', 'لا يمكن الحجز بوقت سابق', 'error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
} else {
|
|
if ((strtotime($date_time) - (3600*14)) > strtotime($booking_day_date .' '. $booking_day_time)) {
|
|
$just_U = 'dont_send';
|
|
}
|
|
}
|
|
|
|
//sms
|
|
$tretmentNumber = mysqli_real_escape_string($db, $_POST['tretmentNumber']);
|
|
$tretmentName = explode(" ",mysqli_real_escape_string($db, $_POST['tretmentName']));
|
|
$emp_name = mysqli_real_escape_string($db, $_POST['emp_name']);
|
|
|
|
if ((strtotime($date_time) + 3600) > strtotime($booking_day_date .' '. $booking_day_time)) {
|
|
$just_U = 'dont_send';
|
|
}
|
|
|
|
$Day = date('D', strtotime($booking_day_date));
|
|
function Day_ar()
|
|
{
|
|
global $Day;
|
|
$find = array("Sat", "Sun", "Mon", "Tue", "Wed", "Thu", "Fri");
|
|
$replace = array("السبت", "الأحد", "الإثنين", "الثلاثاء", "الأربعاء", "الخميس", "الجمعة");
|
|
$ar_day_format = $Day;
|
|
$Day_ar = str_replace($find, $replace, $ar_day_format);
|
|
|
|
return $Day_ar;
|
|
}
|
|
$branch_url = '';
|
|
switch ($branch_id) {
|
|
case '2':
|
|
$branch_url = 'مخرج 15: a-q.cc/15';
|
|
break;
|
|
case '3':
|
|
$branch_url = 'مخرج 7: a-q.cc/7';
|
|
break;
|
|
case '4':
|
|
$branch_url = 'مخرج 29: a-q.cc/29';
|
|
break;
|
|
case '5':
|
|
$branch_url = 'مخرج 6: a-q.cc/6';
|
|
break;
|
|
}
|
|
$m_time = date((date("H", strtotime($booking_day_time)) > 11) ? 'h:i \م' : 'h:i \ص', strtotime($booking_day_time));
|
|
|
|
$sms_start = '';
|
|
$sms_start2 = '';
|
|
switch ($commercial_register_id) {
|
|
case '2':
|
|
$sms_start = 'عزيزي';
|
|
$sms_start2 = 'الفني';
|
|
break;
|
|
case '3':
|
|
$sms_start = 'عزيزتي';
|
|
$sms_start2 = 'الفنية';
|
|
break;
|
|
default:
|
|
$sms_start = 'عزيزي';
|
|
$sms_start2 = 'الفني';
|
|
break;
|
|
}
|
|
|
|
$m_body =
|
|
''.$sms_start.' '.$tretmentName[0].'
|
|
موعدك '.Day_ar().' الموافق '.$booking_day_date.'
|
|
الوقت: '.$m_time.'
|
|
مع '.$sms_start2.' '.$emp_name.'
|
|
'.$branch_url.'
|
|
عدم مجيئك بعد الموعد ب 15 دقيقة يلغي حقك بالدخول
|
|
علما ان دخولك قد يتاثر بجاهزية '.$sms_start2.' والغرف
|
|
للإلغاء :
|
|
aqdamy.com
|
|
0508997755
|
|
0112301110';
|
|
|
|
$check_booking = mysqli_query($db, "SELECT
|
|
`id`
|
|
|
|
FROM `book_details`
|
|
|
|
WHERE `day_date` = '$booking_day_date'
|
|
AND `day_time` = '$booking_day_time'
|
|
AND `branch_id` = '$branch_id'
|
|
AND `emplyee_id` = '$emp_id'
|
|
AND `status_id` BETWEEN 3 AND 19
|
|
AND `book_details`.`id` IN (
|
|
SELECT MAX(`ww`.`id`)
|
|
FROM `book_details` AS `ww`
|
|
WHERE `ww`.`book_id` IN (
|
|
SELECT MAX(`tb`.`book_id`)
|
|
FROM `book_details` AS `tb`
|
|
WHERE `tb`.`day_date` = '$booking_day_date'
|
|
AND `tb`.`day_time` = '$booking_day_time'
|
|
)
|
|
)
|
|
|
|
LIMIT 1"
|
|
);
|
|
|
|
if (mysqli_num_rows($check_booking) == 0) {
|
|
|
|
if (!empty($tretment_id)) {
|
|
$check_timer = mysqli_query(
|
|
$db,
|
|
"SELECT `maxmum` FROM `services`
|
|
WHERE `id` = '$booking_the_service'
|
|
LIMIT 1"
|
|
);
|
|
|
|
if (mysqli_num_rows($check_timer) > 0) {
|
|
$check_timer_res = mysqli_fetch_assoc($check_timer);
|
|
if ($check_timer_res['maxmum'] > 60) {
|
|
$timestamp = strtotime($booking_day_time) + 60*60;
|
|
$booking_day_time_temp = date('H:i:s', $timestamp);
|
|
$check_booking_timer = mysqli_query(
|
|
$db,
|
|
"SELECT `id` FROM `book_details`
|
|
WHERE `day_date` = '$booking_day_date'
|
|
AND `day_time` = '$booking_day_time_temp'
|
|
AND `branch_id` = '$branch_id'
|
|
AND `emplyee_id` = '$emp_id'
|
|
AND `status_id` BETWEEN 3 AND 15
|
|
AND `book_details`.`id` IN (
|
|
SELECT MAX(`tb`.`id`) FROM `book_details` AS `tb`
|
|
WHERE `tb`.`day_date` = '$booking_day_date'
|
|
AND `tb`.`emplyee_id` = '$emp_id'
|
|
GROUP BY `tb`.`day_time`
|
|
)
|
|
LIMIT 1"
|
|
);
|
|
if (mysqli_num_rows($check_booking_timer) == 0) {
|
|
if (mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book`(`tretment_id`, `notes`, `user_id`, `date_time`, `activation_id`)
|
|
VALUES ('$tretment_id', '$booking_notes', '$admin_id', '$date_time', '2')"
|
|
)) {
|
|
$last_id = mysqli_insert_id($db);
|
|
|
|
mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_has_how_to_hear`(`book_id`, `how_to_hear_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id','$how_hear','$date_time','$admin_id','2')"
|
|
);
|
|
|
|
//sms
|
|
require_once('../../../fixed/sms/send_message.php');
|
|
|
|
if (mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_details`(`day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id`, `notes`, `status_id`, `user_id`, `date_time`, `book_id`, `activation_id`)
|
|
VALUES ('$booking_day_date','$booking_day_time','$booking_the_service','$branch_id','$emp_id','$booking_notes','4','$admin_id','$date_time','$last_id', '2')"
|
|
)) {
|
|
if ($bundle_id > 0) {
|
|
$last_id_2 = mysqli_insert_id($db);
|
|
if (!mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_details_has_bundle_services`(`book_details_id`, `bundle_services_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id_2','$bundle_id','$date_time','$admin_id', '2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LF285-9','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
$timestamp = strtotime($booking_day_time) + 60*60;
|
|
$booking_day_time = date('H:i:s', $timestamp);
|
|
mysqli_query($db, "INSERT INTO `table`(`day_date`, `day_time`, `notes`, `branch_id`, `emplyee_id`, `status_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$booking_day_date', '$booking_day_time', '', '$branch_id', '$emp_id', '1', '$date_time', '$admin_id', '2')");
|
|
}
|
|
require_once('add_to_book_temp_ajax.php');
|
|
|
|
?>
|
|
<script type='text/javascript'>
|
|
window.location.href = 'book.php?branch=<?=$branch_id?>&date=' + <?= json_encode($booking_day_date) ?>;
|
|
</script>
|
|
<?php
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('', 'لا يمكن حجز هاذه الخدمة بسبب مدتها', 'warning');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
} else {
|
|
if (mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book`(`tretment_id`, `notes`, `user_id`, `date_time`, `activation_id`)
|
|
VALUES ('$tretment_id', '$booking_notes', '$admin_id', '$date_time', '2')"
|
|
)) {
|
|
$last_id = mysqli_insert_id($db);
|
|
|
|
mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_has_how_to_hear`(`book_id`, `how_to_hear_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id','$how_hear','$date_time','$admin_id','2')"
|
|
);
|
|
|
|
//sms
|
|
require_once('../../../fixed/sms/send_message.php');
|
|
|
|
|
|
if(mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_details`(`day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id`, `notes`, `status_id`, `user_id`, `date_time`, `book_id`, `activation_id`)
|
|
VALUES ('$booking_day_date','$booking_day_time','$booking_the_service','$branch_id','$emp_id','$booking_notes','4','$admin_id','$date_time','$last_id', '2')"
|
|
)) {
|
|
if ($bundle_id > 0) {
|
|
$last_id_2 = mysqli_insert_id($db);
|
|
if (!mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_details_has_bundle_services`(`book_details_id`, `bundle_services_id`, `date_time`, `user_id`, `activation_id`)
|
|
VALUES ('$last_id_2','$bundle_id','$date_time','$admin_id', '2')"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LT245-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
require_once('add_to_book_temp_ajax.php');
|
|
|
|
?>
|
|
<script type='text/javascript'>
|
|
window.location.href = 'book.php?branch=<?=$branch_id?>&date=' + <?= json_encode($booking_day_date) ?>;
|
|
</script>
|
|
<?
|
|
}
|
|
} else {
|
|
echo"
|
|
<script>
|
|
swalfun('LF245-7','','error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('حدث خطأ', 'يرجى تحديد العميل', 'error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('تنبية', 'يوجد حجز لعميل على نفس التاريخ والوقت', 'warning');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('لا يمكن الحجز', 'يرجى التواصل مع قسم الدعم', 'error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
?>
|