require './extr/db_connect.php';
session_start();
if (!isset($_SESSION['username'])) {
header('Location:./login.html');
}
$beginToday = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
$endToday = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;
$sql_clothes = "select count(id) as count from clothes_name where is_del=0";
$sql_in = "select COALESCE(sum(clothes_num),0) as sum from info where action='入库' and action_time between $beginToday and $endToday ";
$sql_out = "select COALESCE(sum(clothes_num),0) as sum from info where action='出库' and action_time between $beginToday and $endToday ";
$sql_sum_in = "select COALESCE(sum(clothes_num),0) as sum from info where action='入库'";
$sql_sum_out = "select COALESCE(sum(clothes_num),0) as sum from info where action='出库'";
$result_clothes = $db->query($sql_clothes);
$result_in = $db->query($sql_in);
$result_out = $db->query($sql_out);
$result_sum_in = $db->query($sql_sum_in);
$result_sum_out = $db->query($sql_sum_out);
?>
欢迎页面function nowTime() {
var times = parseInt(Date.now() / 1000)
times = timestampToTime(times);
$('#nowTime').text(times);
}
$(function() {
setInterval(function() {
nowTime()
}, 1000);
});