package zy.cloud.wms.manager.controller;
|
|
import com.core.common.Arith;
|
import com.core.common.Cools;
|
import com.core.common.R;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RestController;
|
import zy.cloud.wms.common.web.BaseController;
|
|
import java.util.ArrayList;
|
import java.util.Collections;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* Created by vincent on 2021/8/28
|
*/
|
@RestController
|
@RequestMapping("datav")
|
public class DatavController extends BaseController {
|
|
@Autowired
|
private JdbcTemplate jdbcTemplate;
|
|
/**
|
* 页面头部数据
|
* 入库总量 出库总量 在库数量 订单数量 商品总量 货位总数 客户数量 用户数量 操作次数
|
*/
|
@RequestMapping(value = "/head/auth")
|
public R head(){
|
// 入库量
|
Integer pakin = jdbcTemplate.queryForObject("select ISNULL(sum(anfme),0) from man_pakin", Integer.class);
|
// 出库量
|
Integer pakout = jdbcTemplate.queryForObject("select ISNULL(sum(anfme),0) from man_pakout", Integer.class);
|
// 在库数量
|
Integer locDetl = jdbcTemplate.queryForObject("select ISNULL(sum(anfme),0) from man_loc_detl", Integer.class);
|
// 订单数量
|
Integer order = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from man_order", Integer.class);
|
// 商品总量
|
Integer mat = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from man_mat", Integer.class);
|
// 货位总数
|
Integer node = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from man_node where type = 3", Integer.class);
|
// 客户数量
|
Integer cstmr = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from man_cstmr", Integer.class);
|
// 用户数量
|
Integer user = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from sys_user", Integer.class);
|
// 操作次数
|
Integer opt = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from sys_operate_log", Integer.class);
|
return R.ok().add(Cools
|
.add("pakin", pakin)
|
.add("pakout", pakout)
|
.add("locDetl", locDetl)
|
.add("order", order)
|
.add("mat", mat)
|
.add("node", node)
|
.add("cstmr", cstmr)
|
.add("user", user)
|
.add("opt", opt)
|
);
|
}
|
|
/**
|
* 页面左侧数据
|
* 库存倒叙排序
|
*/
|
@RequestMapping(value = "/left/auth")
|
public R left(){
|
List<Map<String, Object>> result = jdbcTemplate.queryForList("select top 9 * from (\n" +
|
"select \n" +
|
"distinct matnr, maktx as name,\n" +
|
"ISNULL(sum(anfme),0) as value\n" +
|
"from man_loc_detl\n" +
|
"where 1=1\n" +
|
"group by matnr, maktx\n" +
|
") r\n" +
|
"order by value desc");
|
return R.ok().add(result);
|
}
|
|
/**
|
* 订单出库商品倒叙占比图 - 饼图
|
*/
|
@RequestMapping(value = "/rose/chart/auth")
|
public R matOutOrderSort(){
|
List<Map<String, Object>> result = jdbcTemplate.queryForList("select\n" +
|
"top 9 \n" +
|
"matnr as name1,\n" +
|
"maktx as name,\n" +
|
"ISNULL(sum(anfme),0) as value\n" +
|
"from man_pakout\n" +
|
"where 1=1\n" +
|
"and wrk_sts = 3\n" +
|
"group by matnr,maktx\n" +
|
"order by value desc");
|
for (Map<String, Object> map : result) {
|
map.put("name", String.valueOf(map.get("name")).substring(0, 5));
|
}
|
// 随机打乱
|
Collections.shuffle(result);
|
return R.ok().add(result);
|
}
|
|
/**
|
* 水占比数据
|
*/
|
@RequestMapping(value = "/water/level/auth")
|
public R waterLevel(){
|
// 已使用库位
|
Integer usedNode = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from (select distinct node_id from man_loc_detl) t\n", Integer.class);
|
// 货位总数
|
int node = jdbcTemplate.queryForObject("select ISNULL(count(1),0) from man_node where type = 3", Integer.class);
|
double percentage;
|
if (node == 0) {
|
percentage = 0.0D;
|
} else {
|
// 占比
|
percentage = Arith.divides(3, usedNode, node);
|
}
|
percentage = Arith.multiplys(1, percentage, 100);
|
return R.ok().add(Cools
|
.add("usedNode", usedNode)
|
.add("node", node)
|
.add("percentage", new Double[]{percentage})
|
);
|
}
|
|
/**
|
* 最新操作记录
|
*/
|
@RequestMapping(value = "/opt/latest/auth")
|
public R optLatest(){
|
List<Map<String, Object>> result = jdbcTemplate.queryForList("select top 10 * from (\n" +
|
"\tselect create_time, matnr, maktx, anfme, '入库' as type from man_pakin where 1=1 \n" +
|
"\tunion\n" +
|
"\tselect create_time, matnr, maktx, anfme, '出库' as type from man_pakout where 1=1 \n" +
|
") t order by create_time desc");
|
List<List<String>> res = new ArrayList<>();
|
for (Map<String, Object> map : result) {
|
List<String> list = new ArrayList<>();
|
list.add(String.valueOf(map.get("create_time")).substring(0, 19));
|
// list.add(String.valueOf(map.get("matnr")));
|
list.add(String.valueOf(map.get("maktx")));
|
list.add(String.valueOf((int)Double.parseDouble(String.valueOf(map.get("anfme")))));
|
list.add(String.valueOf(map.get("type")));
|
res.add(list);
|
}
|
return R.ok().add(res);
|
}
|
|
/**
|
* 底部订单卡片排序
|
*/
|
@RequestMapping(value = "/order/card/auth")
|
public R orderCard(){
|
List<Map<String, Object>> orders = jdbcTemplate.queryForList("select \n" +
|
"top 5\n" +
|
"order_id,\n" +
|
"sum(anfme) as count\n" +
|
"from man_order_detl\n" +
|
"group by order_id\n" +
|
"order by count desc");
|
for (Map<String, Object> map : orders) {
|
|
}
|
return R.ok().add(orders);
|
}
|
|
|
}
|
