welcome.php,welcome.php

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);

});

欢迎用户：

<?php echo $_SESSION['user_cname'] ?>！当前时间:

id="nowTime">

数据统计

lay-arrow="none" style="width: 100%; height: 90px;">

• 衣服款式数目(在售)

• 今日入库数

• 今日出库数

• 仓库库存数

一键复制

编辑

Web IDE

原始数据

按行查看

历史