From f512b0475560ed449f936e0b7a27ba197e6bafe5 Mon Sep 17 00:00:00 2001
From: IPC-610 <IPC-610@DESKTOP-6LEOOS3>
Date: 星期四, 26 九月 2024 15:16:08 +0800
Subject: [PATCH] Merge branch 'master' of https://gitee.com/liudongl/jc24-wms
---
HTML/views/StatisticalReport/PeriodicReport.html | 340 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 340 insertions(+), 0 deletions(-)
diff --git a/HTML/views/StatisticalReport/PeriodicReport.html b/HTML/views/StatisticalReport/PeriodicReport.html
index e69de29..15e6823 100644
--- a/HTML/views/StatisticalReport/PeriodicReport.html
+++ b/HTML/views/StatisticalReport/PeriodicReport.html
@@ -0,0 +1,340 @@
+<!DOCTYPE html>
+<html>
+ <head>
+ <meta charset="utf-8">
+ <title>骞村害鎶ヨ〃</title>
+ <meta name="renderer" content="webkit">
+ <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
+ <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
+ <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
+ <link rel="stylesheet" href="../../css/public.css" media="all">
+ <style type="text/css">
+ .layui-form-item .layui-inline {
+ margin-bottom: 1px;
+ margin-right: 1px;
+ }
+
+ </style>
+ <script>
+ // 杩欓噷鏄渶瑕佸湪椤甸潰娓叉煋涔嬪墠鎵ц鐨勪唬鐮�
+ document.addEventListener("DOMContentLoaded", function() {
+ //鑾峰彇table榛樿鏄剧ず鏁�
+ pageCntFirst();
+ //鍒ゆ柇鏄惁寮�鍚痶able鍒楄〃鍒楀璋冩暣鍔熻兘銆�
+ GetIsSetColW();
+ });
+ </script>
+
+ </head>
+ <body id="body">
+ <div class="layui-fluid" style="padding-bottom: 0;">
+ <div class="layui-card">
+ <div class="layui-form layui-card-header layuiadmin-card-header-auto" id="top">
+ <div class="layui-form-item" style="margin-bottom: 0px;">
+ <div class="layui-inline">
+ <label class="layui-form-label">寮�濮嬫棩鏈�</label>
+ <div class="layui-input-inline">
+ <input type="text" autocomplete="off" name="StartTime" id="StartTime" class="layui-input"
+ placeholder="寮�濮嬫棩鏈�">
+ </div>
+ </div>
+ <!-- <div class="layui-inline">
+ <label class="layui-form-label">缁撴潫鏃ユ湡</label>
+ <div class="layui-input-inline">
+ <input type="text" autocomplete="off" name="EndTime" id="EndTime" class="layui-input"
+ placeholder="缁撴潫鏃ユ湡">
+ </div>
+ </div> -->
+ <div class="layui-inline sousuo">
+ <button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit lay-filter="LAY-app-contlist-search">
+ <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>鎼滅储
+ </button>
+ <button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit
+ lay-filter="daochu">
+ <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>瀵煎嚭
+ </button>
+ </div>
+
+
+ </div>
+ </div>
+
+ <div id="center"></div>
+ <div class="layui-card-body">
+ <div style="position: relative;">
+ <div class="layui-tab layui-tab-brief" lay-filter="docDemoTabBrief">
+ <div id="center">
+ </div>
+
+ <div class="layui-tab-content">
+ <!-- 鍗曟嵁鎬昏〃 -->
+ <div class="position-relative"><!-- class="position-relative" --><!-- 鑷畾涔夎〃澶村姞涓� -->
+ <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table>
+
+ <!-- #region 鑷畾涔夎〃澶� -->
+ <div class="headerSetIcon">
+ <button class="layui-btn layui-btn-primary layui-btn-sm" data-type="customCols">
+ <i class="layui-icon"></i>
+ </button>
+ </div>
+ <!-- #endregion -->
+
+ <script type="text/html" id="SituationButton">
+ {{# if(d.IsQualified=='0'){ }}
+ <p>婊¤冻</p>
+ {{# } else if(d.IsQualified=='1'){ }}
+ <p>涓嶆弧瓒�</p>
+ {{# } }}
+ </script>
+ <script type="text/html" id="CreateTimeButton">
+ {{# console.log(d.CreateTime);
+ return formatDate(d.CreateTime);
+ }}
+ </script>
+ <script type="text/html" id="UpdateTimeButton">
+ {{# console.log(d.CreateTime);
+ return formatDate(d.CreateTime);
+ }}
+ </script>
+
+ </div>
+ </div>
+ </div>
+
+ </div>
+
+ </div>
+ </div>
+ </div>
+
+ <script src="../../layuiadmin/layui/layui.js"></script>
+ <script src="../../js/public.js"></script>
+ <script src="../../js/jquery-3.5.1.min.js"></script>
+ <script src="../../js/jquery.cookie.js"></script>
+ <script>
+ var uid = $.cookie('userId');
+ layui.config({
+ base: '../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
+ }).extend({
+ index: 'lib/index' //涓诲叆鍙ｆā鍧�
+ }).use(['index', 'table', 'laypage', 'layer','element','laydate'], function() {
+ var table = layui.table,
+ form = layui.form,
+ laypage = layui.laypage,
+ layer = layui.layer;
+ element = layui.element;
+ laydate = layui.laydate;
+
+
+ laydate.render({
+ elem: '#StartTime',
+ format: 'yyyy-MM-dd' //鍙换鎰忕粍鍚�
+ });
+ laydate.render({
+ elem: '#EndTime',
+ format: 'yyyy-MM-dd' //鍙换鎰忕粍鍚�
+ });
+ //鑾峰彇褰撳墠鏃堕棿
+ function getNowTime() {
+ var date = new Date();
+ //骞� getFullYear()锛氬洓浣嶆暟瀛楄繑鍥炲勾浠�
+ var year = date.getFullYear(); //getFullYear()浠ｆ浛getYear()
+ //鏈� getMonth()锛�0 ~ 11
+ var month = date.getMonth() + 1;
+ //鏃� getDate()锛�(1 ~ 31)
+ var day = date.getDate();
+ //鏃� getHours()锛�(0 ~ 23)
+ var hour = date.getHours();
+ //鍒� getMinutes()锛� (0 ~ 59)
+ var minute = date.getMinutes();
+ //绉� getSeconds()锛�(0 ~ 59)
+ var second = date.getSeconds();
+
+ var time = year + addZero(month) + addZero(day) + addZero(hour) + addZero(minute) + addZero(second);
+ return time;
+
+ //灏忎簬10鐨勬嫾鎺ヤ笂0瀛楃涓�
+
+ };
+ function addZero(s) {
+ return s < 10 ? ('0' + s) : s;
+ };
+
+ // 琛ㄥ崟闇�瑕佺殑鍙橀噺
+ var infoOptions;
+
+ var myDate = new Date();
+ // console.log(myDate.getFullYear()+'-'+(myDate.getMonth() + 1)+'-'+myDate.getDate()+' 00:00:00')
+ myDate.getFullYear(); //鑾峰彇瀹屾暣鐨勫勾浠�(4浣�,1970-????)
+ myDate.getMonth(); //鑾峰彇褰撳墠鏈堜唤(0-11,0浠ｈ〃1鏈�)
+ myDate.getDate(); //鑾峰彇褰撳墠鏃�(1-31)
+ // 姣忔棩鍒濆鏃堕棿
+ var chudate = myDate.getFullYear()+'-'+(myDate.getMonth() + 1)+'-'+myDate.getDate()+' 00:00:00'
+ var jiedate = myDate.getFullYear()+'-'+(myDate.getMonth() + 1)+'-'+myDate.getDate()+' 23:59:59'
+ var $ = layui.$;
+
+
+ var h1 = GetTableHeight();
+ refreshTable("",);
+ //鑾峰彇鍑哄叆搴撴�婚噺
+ function refreshTable(StartTime,EndTime) {
+ //#region 鑷畾涔夎〃澶�
+ var colsJson
+ var param1={
+ Href:'Statistical/GetDataStockInfo'
+ };
+ sendData(IP + "/Sys/GetTableColsByUserId", param1, 'post', function(res) {
+ if (res.code == 0){
+ if(res.data=='' || res.data==undefined || res.data==null){
+ colsJson=TotalColsArr
+ }else{
+ colsJson= eval(res.data);
+ }
+ }else{
+ colsJson=TotalColsArr
+ }
+ console.log('h1:',h1)
+ infoOptions = {
+ elem: '#LAY-app-content-list',
+ height: h1,
+ id: 'LAY-app-content-list',
+ page: true,
+ limit: pageCnt,
+ limits: pageLimits,
+ even: true,
+ cellMinWidth: 80, //鍏ㄥ眬瀹氫箟甯歌鍗曞厓鏍肩殑鏈�灏忓搴︼紝layui 2.2.1 鏂板
+ done: function(){
+ //鑷畾涔夊垪瀹�
+ SetTableColW('LAY-app-content-list','Statistical/GetDataStockInfo',TotalColsSysArr);
+ },
+ cols:colsJson
+ };
+
+ var param = {
+ StartTime:$("#StartTime").val(),
+ };
+ sendData(IP + "/Statistical/GetDataStockInfo", param, 'get', function(res) {
+ //console.log(res)
+ if (res.code == 0) { //鎴愬姛
+ var list = res.data;
+ $.extend(infoOptions, {
+ data: list
+ });
+ infoOptions.page = {
+ curr: 1
+ }
+ tableIns = table.render(infoOptions);
+ }
+ else { //涓嶆垚鍔�
+ layer.msg('鑾峰彇搴撳瓨淇℃伅澶辫触', {
+ icon: 2,
+ time: 2000 //2绉掑叧闂紙濡傛灉涓嶉厤缃紝榛樿鏄�3绉掞級
+ }, function() {});
+ }
+ });
+ });
+ //#endregion
+
+ }
+ //#region 鑷畾涔夎〃澶�
+ var TotalColsArr = [[
+ {field: '',title: '搴忓彿',type:'numbers',align: 'center',fixed: 'left', "disabled": true},
+ {field: 'SkuNo', title: '鐗╂枡缂栫爜', align: 'center'},
+ {field: 'SkuName', title: '鐗╂枡鍚嶇О', align: 'center',},
+ {field: 'Standard', title: '瑙勬牸', align: 'center',},
+ {field: 'Unit', title: '鍗曚綅', align: 'center'},
+ {field: 'LastMonthQty', title: '涓婃湀缁撳瓨鏁伴噺', align: 'center'},
+ {field: 'LastMonthFoldedQty', title: '涓婃湀缁撳瓨鎶樹欢', align: 'center'},
+ {field: 'ArrDayQty', title: '鍏ュ簱鏃ユ暟閲�', align: 'center'},
+ {field: 'ArrDayFoldedQty', title: '鍏ュ簱鏃ユ姌浠�', align: 'center'},
+ {field: 'ArrMonthQty', title: '鍏ュ簱鏈堟暟閲�', align: 'center'},
+ {field: 'ArrMonthFoldedQty', title: '鍏ュ簱鏈堟姌浠�', align: 'center'},
+ {field: 'ArrYearQty', title: '鍏ュ簱骞存暟閲�', align: 'center'},
+ {field: 'ArrYearFoldedQty', title: '鍏ュ簱骞存姌浠�', align: 'center'},
+ {field: 'SoDayQty', title: '鍑哄簱鏃ユ暟閲�', align: 'center'},
+ {field: 'SoDayFoldedQty', title: '鍑哄簱鏃ユ姌浠�', align: 'center'},
+ {field: 'SoMonthQty', title: '鍑哄簱鏈堟暟閲�', align: 'center'},
+ {field: 'SoMonthFoldedQty', title: '鍑哄簱鏈堟姌浠�', align: 'center'},
+ {field: 'SoYearQty', title: '鍑哄簱骞存暟閲�', align: 'center'},
+ {field: 'SoYearFoldedQty', title: '鍑哄簱骞存姌浠�', align: 'center'},
+ {field: 'MonthQty', title: '褰撴湀缁撳瓨鏁伴噺', align: 'center'},
+ {field: 'MonthFoldedQty', title: '褰撴湀缁撳瓨鎶樹欢', align: 'center'},
+ {field: 'DepositQty', title: '瀵勫瓨鏁伴噺', align: 'center'},
+ {field: 'Qty', title: '鏈湀搴撳瓨鏁伴噺', align: 'center'},
+ {field: 'SecurityQty', title: '瀹夊叏搴撳瓨', align: 'center'},
+ {field: 'Situation', title: '瀹夊叏搴撳瓨鎯呭喌', align: 'center' , templet: '#SituationButton',},
+ {field: 'CreateTime', title: '鍒涘缓鏃ユ湡', align: 'center' , templet: '#CreateTimeButton',},
+ {field: 'UpdateTime', title: '鏇存柊鏃ユ湡', align: 'center', templet: '#UpdateTimeButton',},
+ ]];
+ var TotalColsSysArr=encodeURIComponent(encodeURIComponent(JSON.stringify(TotalColsArr)))//灏嗚〃澶存暟鎹繘琛寀rl缂栫爜
+ //#endregion
+
+
+ //鐩戝惉鎼滅储
+ form.on('submit(LAY-app-contlist-search)', function(data) {
+
+ var StartTime = $("#StartTime").val();
+ refreshTable(StartTime);
+
+ });
+
+ form.on('submit(daochu)', function () {
+ layer.confirm('纭畾瀵煎嚭褰撳墠鏁版嵁鍚楋紵', function(index) {
+ var param = {
+ StartTime:$("#StartTime").val(),
+ };
+ sendData(IP + "/Statistical/GetDataStockInfo", param, 'get', function (res) {
+ //console.log(res);
+ if (res.code == 0) { //鎴愬姛
+ var list = res.data;
+ list.forEach(item => {
+ if (item.SkuName.split(','))
+ {
+ item.SkuName = '"'+item.SkuName+'"'
+ }
+
+ });
+ table.exportFile(tableIns.config.id, list,'xls',"搴撳瓨淇℃伅"+getNowTime(),); //data 涓鸿瀹炰緥涓殑浠绘剰鏁伴噺鐨勬暟鎹�
+ layer.msg('瀵煎嚭鎴愬姛锛�', {
+ icon: 1,
+ time: 2000 //2绉掑叧闂紙濡傛灉涓嶉厤缃紝榛樿鏄�3绉掞級
+ }, function () {
+
+ });
+
+ } else { //涓嶆垚鍔�
+ layer.msg('鑾峰彇淇℃伅澶辫触锛�', {
+ icon: 2,
+ time: 2000 //2绉掑叧闂紙濡傛灉涓嶉厤缃紝榛樿鏄�3绉掞級
+ }, function () { });
+ }
+ });
+ });
+ });
+
+ //#region 鑷畾涔夎〃澶�
+ //鑷畾涔夎〃澶�
+ active = {
+ customCols: function(){
+ layer.open({
+ type: 2,
+ title: '鑷畾涔夊垪',
+ content: '../SystemSettings/HeaderSetting.html?Href=Statistical/GetDataStockInfo&ColsSysArr='+TotalColsSysArr,
+ maxmin: false,
+ resize: false,
+ area: ['970px', '650px']
+ });
+ },
+ };
+ $('.layui-btn').on('click', function() {
+ var type = $(this).data('type');
+ active[type] ? active[type].call(this) : '';
+ });
+ //#endregion
+
+
+ });
+ </script>
+ </body>
+</html>
--
Gitblit v1.8.0