65 lines
2.3 KiB
PHP
Executable File
65 lines
2.3 KiB
PHP
Executable File
<?php
|
|
require_once('fixed/config/go_con.php');
|
|
access(50);
|
|
|
|
$today = date("Y-m-d");
|
|
if (!empty($_GET['date'])) {
|
|
$today = $_GET['date'];
|
|
if (DateTime::createFromFormat('Y-m-d', $today) == false) {
|
|
$today = date("Y-m-d");
|
|
}
|
|
}
|
|
|
|
$get_my_books_sql = mysqli_query($db,
|
|
"SELECT
|
|
RIGHT(`bd`.`number`,2) AS `last_2_num`,
|
|
`bd`.`day_time`,
|
|
`bd`.`emplyee_id`,
|
|
`bd`.`status_id`,
|
|
`bd`.`date_time`,
|
|
`bd`.`book_id`,
|
|
`bd`.`name`,
|
|
`bd`.`tr_name`
|
|
FROM `books_for_table` AS `bd`
|
|
WHERE `bd`.`day_date`='2022-09-17'
|
|
AND `bd`.`emplyee_id`='6'
|
|
AND `bd`.`status_id` IN (6)
|
|
|
|
GROUP BY `bd`.`day_time`
|
|
ORDER BY `bd`.`day_time` ASC, `bd`.`date_time`
|
|
LIMIT 1
|
|
");
|
|
$get_my_books = mysqli_fetch_assoc($get_my_books_sql)
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="en" dir="rtl">
|
|
<?php require_once('fixed/head/go.php'); ?>
|
|
<body class="rtl">
|
|
<link rel="stylesheet" href="//cdn.jsdelivr.net/npm/@mdi/font@6.5.95/css/materialdesignicons.min.css">
|
|
<?php require_once('fixed/loader/go.php'); ?>
|
|
<div class="page-wrapper" id="pageWrapper">
|
|
<?php require_once('fixed/header/go.php'); ?>
|
|
<div class="page-body-wrapper">
|
|
<?php require_once('fixed/sidebar/go.php'); ?>
|
|
<div class="page-body">
|
|
<div class="container-fluid">
|
|
<div class="row">
|
|
<div class="col-12">
|
|
<div class="card">
|
|
<div class="card-body new-user order-list" style="height: 100vh;">
|
|
<iframe style="width: 100%;height: 100%;" src="https://docs.google.com/spreadsheets/d/14S89cwtT5oSzwcYHJgdAMiaWevnVy-1sqRqadNv5Hlo/edit?usp=sharing?widget=true&headers=false"></iframe>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php require_once('fixed/footer/go.php'); ?>
|
|
</div>
|
|
</div>
|
|
<?php require_once('fixed/js/go.php'); ?>
|
|
</body>
|
|
</html>
|
|
|