<?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']);
    $driver = mysqli_real_escape_string($db, $_POST['driver']);
    $send_sms = mysqli_real_escape_string($db, $_POST['send_sms']);
    
    
    //sms
    $just_U = 'LkjgHJKLGjklHLJKhgjklGHHJKLghjkGKLU';
    if ($send_sms != 2) {
        $just_U = 'dont_send';
    } 
    $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']);

    $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;
    }
    
    $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.'
للإلغاء :
aqdamy.com
0552363366
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);

                            //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','10','$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;
                                    }
                                }
                                if (!mysqli_query(
                                    $db,
                                    "INSERT INTO `book_has_driver_for_points`(`book_id`, `emplyee_id`, `services_id`, `date_time`, `user_id`, `activation_id`)
                                    VALUES ('$last_id','$driver','$booking_the_service','$date_time','$admin_id', '2')"
                                )) {
                                    echo"
                                        <script>
                                            swalfun('LF265-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_visits?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);

                        //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','10','$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;
                                }
                            }
                            if (!mysqli_query(
                                $db,
                                "INSERT INTO `book_has_driver_for_points`(`book_id`, `emplyee_id`, `services_id`, `date_time`, `user_id`, `activation_id`)
                                VALUES ('$last_id','$driver','$booking_the_service','$date_time','$admin_id', '2')"
                            )) {
                                echo"
                                    <script>
                                        swalfun('LF265-9','','error');
                                        click = 0;
                                    </script>
                                ";
                                exit;
                            }
                        }
                    }
                    require_once('add_to_book_temp_ajax.php');

?>
<script type='text/javascript'>
    window.location.href = 'book_visits?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>
    ";
}

?>