liufumingren e8605149c0 初始化
2026-08-06 17:04:35 +08:00

217 lines
7.0 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
namespace app\admin\controller\shopro;
use app\common\controller\Backend;
use think\Config;
/**
* 控制台
*
* @icon fa fa-dashboard
* @remark 用于展示当前系统中的统计数据、统计报表及重要实时数据
*/
class Dashboard extends Backend
{
/**
* 查看
*/
public function index()
{
if ($this->request->isAjax()) {
//如果发送的来源是Selectpage,则转发到Selectpage
$datetimerange = explode(' - ', $this->request->request('datetimerange'));
$startTime = strtotime($datetimerange[0]);
$endTime = strtotime($datetimerange[1]);
$this->model = new \app\admin\model\shopro\order\Order;
$where = [
'createtime' => ['between', [$startTime, $endTime]]
];
$list = $this->model
->where($where)
->with('item')
->order('id')
->select();
$data = $this->getTotalData($list);
// 商品列表
$goodsList = \addons\shopro\model\Goods::limit(5)->order('sales', 'desc')->select();
foreach ($goodsList as $key => $goods) {
$result = \app\admin\model\shopro\order\OrderItem::field('sum(goods_num * goods_price) as sale_total_money')->where('goods_id', $goods['id'])
->whereExists(function ($query) use ($goods) {
$order_table_name = $this->model->getQuery()->getTable();
$table_name = (new \app\admin\model\shopro\order\OrderItem())->getQuery()->getTable();
$query->table($order_table_name)->where('order_id=' . $order_table_name . '.id')
->where('status', '>', \app\admin\model\shopro\order\Order::STATUS_NOPAY); // 已支付的订单
})->find();
$goods['sale_total_money'] = $result['sale_total_money'] ? : 0;
}
$data['goodsList'] = $goodsList;
extract($this->orderScale($list));
$data['orderFinish'] = $orderFinish;
$data['payedFinish'] = $payedFinish;
$this->success('数据中心', '', $data);
}
return $this->view->fetch();
}
private function orderScale ($list) {
$total = count($list);
$total_money = array_sum(array_column($list, 'total_fee'));
$data['orderFinish'] = [
'order_scale' => 0,
'order_user' => 0
];
$data['payedFinish'] = [
'payed_scale' => 0,
'payed_money' => 0
];
// 支付单数
$payed_num = 0;
// 支付金额
$payed_money = 0;
// 支付的用户 id
$payed_user_ids = [];
foreach ($list as $key => $order) {
if ($order['status'] > 0) {
$payed_num++;
$payed_money = bcadd($payed_money, $order['total_fee'], 2);
$payed_user_ids[] = $order['user_id'];
}
}
$orderFinish = [
'order_scale' => $total ? round(($payed_num / $total), 2) : 0,
'order_payed' => $payed_num,
];
$payedFinish = [
'payed_scale' => $total_money ? round(($payed_money / $total_money), 2) : 0,
'payed_money' => round($payed_money, 2)
];
return compact("orderFinish", "payedFinish");
}
private function getTotalData($list) {
// 支付订单
$data['payOrderNum'] = 0;
$data['payOrderArr'] = [];
//支付金额
$data['payAmountNum'] = 0;
$data['payAmountArr'] = [];
// 代发货
$data['noSentNum'] = 0;
$data['noSentArr'] = [];
//支付人数
$data['orderNum'] = count($list);
$data['orderArr'] = [];
//售后维权
$data['aftersaleNum'] = 0;
$data['aftersaleArr'] = [];
//退款订单
$data['refundNum'] = 0;
$data['refundArr'] = [];
//所有下单金额
$data['totalAmount'] = 0;
$data['tranPeople'] = [];
$data['wechatPay'] = 0;
$data['alipayPay'] = 0;
$data['walletPay'] = 0;
$data['allTypePay'] = 0;
foreach ($list as $key => $order) {
$data['orderArr'][] = [
'counter' => 1,
'createtime' => $order['createtime'] * 1000,
'user_id' => $order['user_id']
];
$data['totalAmount'] = bcadd($data['totalAmount'], $order['pay_fee'], 2); // 这里可能要使用 total_fee
if ($order['status'] > 0) {
$data['payOrderNum']++;
$data['payOrderArr'][] = [
'counter' => 1,
'createtime' => $order['createtime'] * 1000,
'user_id' => $order['user_id']
];
$data['payAmountNum'] = bcadd($data['payAmountNum'], $order['pay_fee'], 2);
$data['payAmountArr'][] = [
'counter' => $order['pay_fee'],
'createtime' => $order['createtime'] * 1000,
];
$data['tranPeople']++;
$flagnoSent = false;
$flagaftersale = false;
$flagrefund = false;
foreach ($order['item'] as $k => $item) {
if (!$flagnoSent && $item['dispatch_status'] == 0 && $item['refund_status'] == 0) {
$data['noSentNum']++;
$data['noSentArr'][] = [
'counter' => 1,
'createtime' => $order['createtime'] * 1000,
];
$flagnoSent = true;
}
if (!$flagaftersale && $item['aftersale_status'] > 0) {
$data['aftersaleNum']++;
$data['aftersaleArr'][] = [
'counter' => 1,
'createtime' => $order['createtime'] * 1000,
];
$flagaftersale = true;
}
if (!$flagrefund && $item['refund_status'] > 0) {
$data['refundNum']++;
$data['refundArr'][] = [
'counter' => 1,
'createtime' => $order['createtime'] * 1000,
];
$flagrefund = true;
}
}
$data['allTypePay']++;
if ($order['pay_type'] == 'wechat') {
$data['wechatPay']++;
}
if ($order['pay_type'] == 'alipay') {
$data['alipayPay']++;
}
if ($order['pay_type'] == 'wallet') {
$data['walletPay']++;
}
}
}
return $data;
}
}