moneyEchart

 SELECT IFNULL(SUM(b.money),0) as moneyCount, IFNULL(SUM(b.weight),0) as weightCount FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info c ON a.order_id = c.order_id
    LEFT JOIN xzx_order_item_info b ON a.order_id=b.order_id
    WHERE a.order_type=1 AND a.order_status in (4,5,7)
    @if(!isEmpty(startTime)){
        AND c.complete_time BETWEEN #startTime# AND #endTime#
    @}

storageEchart

SELECT IFNULL(SUM(b.money),0) as storageMoneyCount, IFNULL(SUM(b.weight),0) as storageWeightCount,
a.sys_storage_id as sysStorageId FROM 
xzx_order_storage_info a 
LEFT JOIN xzx_order_storage_detail b ON a.storage_id = b.storage_id AND b.flag=1
@if(!isEmpty(startTime)){
    AND a.storage_time BETWEEN #startTime# AND #endTime#
@}
GROUP BY a.sys_storage_id;

orderEchart

SELECT IFNULL(COUNT(a.order_id),0) AS orderCount 
FROM xzx_order_info a,xzx_order_detail_info b  
WHERE a.order_type=1 AND a.order_status in (4,5,7) 
  AND a.order_id = b.order_id 
    @if(!isEmpty(startTime)){
        AND IFNULL(b.complete_time,a.create_time) BETWEEN #startTime# AND #endTime#
    @}

orderEchartTemp

 SELECT IFNULL(COUNT(*),0) as orderCount FROM xzx_order_info a WHERE a.order_type=1 AND a.order_status in (4,5) 
    @if(!isEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
    @}         

userEchart

SELECT IFNULL(COUNT(*),0) as userCount FROM (
    SELECT * FROM xzx_user_info a WHERE del_flag=0
    @if(!isEmpty(startTime)){
        AND a.regist_time BETWEEN #startTime# AND #endTime#
    @}
     GROUP BY a.mobile_phone
) x

insertEchart

INSERT INTO `xzx_charts_data`(`money_by_order`, `weight_by_order`, `order_sum`, `money_by_storage`, `weight_by_storage`, `user_sum`, `visit_sum`, `create_time`, `date_hours`, `sys_storage_id`) 
VALUES 
(#moneyCount#, #weightCount#, #orderCount#, #storageMoneyCount#, #storageWeightCount#, #userCount#, #visitCount#, #createTime#, #dateHours#, #sysStorageId#);

queryOrderDayCount

select ifnull(count(order_id),0) from xzx_order_info 
where del_flag=0
@if(!isEmpty(startTime)){
    and a.create_time BETWEEN #startTime# AND #endTime#
@}
and order_status in ('1','2','3','4','5','7')

queryData

SELECT SUM(a.money_by_storage) as storageMoneyCount, 
        (SELECT visit_sum FROM xzx_charts_data
            @if(!isEmpty(startTime)){
                 WHERE a.create_time BETWEEN #startTime# AND #endTime#
            @}
            GROUP BY create_time DESC LIMIT 1
        ) as visitCount, 
        SUM(a.user_sum) as userCount, 
        SUM(a.order_sum) as orderCount, 
        SUM(a.weight_by_storage) as storageWeightCount,
        SUM(a.money_by_order) as moneyCount, 
        SUM(a.weight_by_order) as weightCount
FROM xzx_charts_data a 
@if(!isEmpty(startTime)){
    WHERE a.create_time BETWEEN #startTime# AND #endTime#
@}

queryUserDayCount

SELECT DATE_FORMAT(login_time, '%Y-%m-%d') AS dateHours,IFNULL(count(user_id),0) AS visitCount
  FROM xzx_user_login_info 
 WHERE login_time IS NOT null 
   AND DATE_FORMAT(login_time, '%Y-%m-%d')=DATE_FORMAT(CURDATE()-1, '%Y-%m-%d')
 GROUP BY dateHours ORDER BY login_id DESC 

haveVisitLog

  select IF(count(user_id),count(user_id),'') from xzx_user_login_info
  where 1=1  and login_time is not null
    AND DATE_FORMAT(login_time, '%Y-%m-%d') <= #endTime#
    AND DATE_FORMAT(login_time, '%Y-%m-%d') >= #startTime#
   limit 1

weekVistNum

  SELECT count(*) AS visitCount
      FROM xzx_user_login_info 
     WHERE login_time is not null 
          AND DATE_FORMAT(login_time, '%Y-%m-%d') <= #endTime#
           AND DATE_FORMAT(login_time, '%Y-%m-%d') >= #startTime#
     GROUP BY user_id ORDER BY login_id DESC        

queryDataByStorageId

SELECT IFNULL(SUM(a.money_by_storage), 0) as storageMoneyCount,  IFNULL(SUM(a.weight_by_storage),0) as storageWeightCount, b.storage_name as sysStorageId
FROM xzx_sys_storage b 
    LEFT JOIN xzx_charts_data a ON a.sys_storage_id=b.id 
    @if(!isEmpty(startTime)){
        WHERE a.create_time BETWEEN #startTime# AND #endTime#
    @}
    GROUP BY b.id limit 0, 10000

queryItemtype

SELECT SUM(b.money) as storageMoney, SUM(b.weight) as storageWeight,a.title as itemName
FROM xzx_sys_environmental_info a
LEFT JOIN xzx_order_item_info b ON a.item_type = b.item_type
LEFT JOIN xzx_order_info c ON b.order_id = c.order_id and c.order_status IN ( '4', '5', '7' )
left JOIN xzx_order_detail_info d on c.order_id=d.order_id
WHERE a.parent_id is NOT NULL and a.del_flag=0
@if(!isEmpty(startTime)){
AND d.receive_time BETWEEN #startTime# AND #endTime#
@}

GROUP BY a.item_type

queryItemtypeEmpty

SELECT '0.00' as storageMoney, '0.00' as storageWeight,a.title as itemName
FROM xzx_sys_environmental_info a
LEFT JOIN xzx_order_item_info b ON a.item_type = b.item_type
WHERE a.parent_id is NOT NULL and a.del_flag=0
GROUP BY a.item_type

querySumReclayMoney

SELECT sum(b.money) FROM xzx_order_info a
INNER JOIN xzx_order_item_info b on a.order_id=b.order_id
WHERE a.order_status in ('4','5','7')

query15daydata

SELECT left(date_hours, 10) as createTime, 
    SUM(money_by_order) as moneyCount, 
    SUM(weight_by_order) as weightCount,
    SUM(order_sum) as orderCount,
    SUM(money_by_storage) as storageMoneyCount,
    SUM(weight_by_storage) as storageWeightCount, 
    SUM(user_sum) as userCount
FROM xzx_charts_data 
    WHERE date_hours BETWEEN #startTime# AND #endTime#
    GROUP BY left(date_hours, 10)

queryModel

SELECT create_time as createTime FROM xzx_charts_data ORDER BY create_time ASC LIMIT 1

queryOrder

SELECT b.complete_time as createTime 
FROM xzx_order_info a
left join xzx_order_detail_info b on a.order_id=b.order_id
where a.del_flag=0
 ORDER BY create_time ASC LIMIT 1

qeuryConfigInfo

SELECT config_value FROM xzx_sys_config_info WHERE config_type_code=#configTypeCode#

updateConfigInfo

UPDATE xzx_sys_config_info SET config_value=0 WHERE config_type_code=#configTypeCode#

queryTime

    SELECT create_time as createTime FROM xzx_charts_data ORDER BY create_time desc LIMIT 1

queryDbTime

SELECT date_format(now(), '%Y-%m-%d %H:%i:%s') as dbTime FROM dual