50 lines
1.7 KiB
PHP
Executable File
50 lines
1.7 KiB
PHP
Executable File
<?php
|
|
require_once('../../../fixed/config/go_con.php');
|
|
|
|
$emp_id = mysqli_real_escape_string($db, $_POST['emp_id']);
|
|
$branch_id = mysqli_real_escape_string($db, $_POST['branch_id']);
|
|
|
|
$radio = mysqli_real_escape_string($db, $_POST['radio']);
|
|
$dateS = mysqli_real_escape_string($db, date($_POST['dateS']));
|
|
$dateE = mysqli_real_escape_string($db, date($_POST['dateE']));
|
|
$timeS = mysqli_real_escape_string($db, $_POST['cortimeS']);
|
|
$timeE = mysqli_real_escape_string($db, $_POST['cortimeE'] + 1);
|
|
|
|
$s = date('Y-m-d', strtotime($dateS));
|
|
$e = date('Y-m-d', strtotime('+1 day', strtotime($dateE)));
|
|
$ts = $timeS;
|
|
$te = $timeE . ":00:00";
|
|
|
|
|
|
|
|
while ($s != $e) {
|
|
|
|
$ts = $timeS;
|
|
$te = $timeE . ":00:00";
|
|
while ($ts != $te) {
|
|
if ($ts < 10) {
|
|
$ts = $ts . ":00:00";
|
|
} else {
|
|
$ts = $ts . ":00:00";
|
|
}
|
|
if($radio != 0) {
|
|
if (mysqli_query($db, "INSERT INTO `table`(`day_date`, `day_time`, `date_time`, `branch_id`, `emplyee_id`, `status_id`, `user_id`, `activation_id`)
|
|
VALUES ('$s', '$ts', '$date_time', '$branch_id', '$emp_id', '$radio', '$admin_id', '2')"
|
|
)) {}
|
|
} else {
|
|
if (mysqli_query($db, "UPDATE `table` SET `activation_id`= 1 WHERE `day_date` = '$s' AND `day_time` = '$ts' AND `user_id` = '$admin_id' AND `emplyee_id` = '$emp_id'"
|
|
)) {}
|
|
}
|
|
$ts = ($ts[0] . $ts[1]) + 1;
|
|
}
|
|
$s = date('Y-m-d', strtotime('+1 day', strtotime($s)));
|
|
}
|
|
|
|
echo "
|
|
<script>
|
|
swalfun('تمت العملية بنجاح','', 'success');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
?>
|