115 lines
5.5 KiB
PHP
Executable File
115 lines
5.5 KiB
PHP
Executable File
<?php
|
|
/**
|
|
* Niushop商城系统 - 团队十年电商经验汇集巨献!
|
|
* =========================================================
|
|
* Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
|
|
* ----------------------------------------------
|
|
* 官方网址: https://www.niushop.com
|
|
* =========================================================
|
|
*/
|
|
|
|
namespace app\shopapi\controller;
|
|
|
|
use app\dict\order_refund\OrderRefundDict;
|
|
use app\model\order\Order;
|
|
use app\model\shop\Shop as ShopModel;
|
|
use app\model\shop\ShopReopen as ShopReopenModel;
|
|
use app\model\system\Stat;
|
|
use app\model\web\Notice as NoticeModel;
|
|
use Carbon\Carbon;
|
|
use app\model\web\WebSite as WebsiteModel;
|
|
use app\model\goods\Goods as GoodsModel;
|
|
use app\model\system\User as ShopUser;
|
|
use app\model\order\OrderCommon;
|
|
use app\model\order\OrderRefund as OrderRefundModel;
|
|
use app\model\member\Member;
|
|
|
|
class Index extends BaseApi
|
|
{
|
|
|
|
public function __construct()
|
|
{
|
|
//执行父类构造函数
|
|
parent::__construct();
|
|
$token = $this->checkToken();
|
|
if ($token[ 'code' ] < 0) {
|
|
echo json_encode($token);
|
|
exit;
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 首页
|
|
* @return mixed
|
|
*/
|
|
public function index()
|
|
{
|
|
//店铺基础信息
|
|
$data[ 'shop_info' ] = $this->shop_info;
|
|
|
|
//基础统计信息
|
|
$stat_shop_model = new Stat();
|
|
$today = Carbon::now();
|
|
$yesterday = Carbon::yesterday();
|
|
// $stat_today = $stat_shop_model->getStatShop($this->site_id, $today->year, $today->month, $today->day);
|
|
// $stat_yesterday = $stat_shop_model->getStatShop($this->site_id, $yesterday->year, $yesterday->month, $yesterday->day);
|
|
$stat_today = $stat_shop_model->getShopStatSum($this->site_id, $today->startOfDay()->timestamp, $today->endOfDay()->timestamp);
|
|
$stat_yesterday = $stat_shop_model->getShopStatSum($this->site_id, $yesterday->startOfDay()->timestamp, $yesterday->endOfDay()->timestamp);
|
|
|
|
|
|
$data[ 'stat_day' ] = $stat_today[ 'data' ];
|
|
$data[ 'stat_yesterday' ] = $stat_yesterday[ 'data' ];
|
|
// $data[ 'today' ] = $today;
|
|
|
|
//日同比
|
|
$day_rate[ 'order_pay_count' ] = diff_rate($stat_today[ 'data' ][ 'order_pay_count' ], $stat_yesterday[ 'data' ][ 'order_pay_count' ]);
|
|
$day_rate[ 'order_total' ] = diff_rate($stat_today[ 'data' ][ 'order_total' ], $stat_yesterday[ 'data' ][ 'order_total' ]);
|
|
$day_rate[ 'collect_goods' ] = diff_rate($stat_today[ 'data' ][ 'collect_goods' ], $stat_yesterday[ 'data' ][ 'collect_goods' ]);
|
|
$day_rate[ 'visit_count' ] = diff_rate($stat_today[ 'data' ][ 'visit_count' ], $stat_yesterday[ 'data' ][ 'visit_count' ]);
|
|
$day_rate[ 'member_count' ] = diff_rate($stat_today[ 'data' ][ 'member_count' ], $stat_yesterday[ 'data' ][ 'member_count' ]);
|
|
$data[ 'day_rate' ] = $day_rate;
|
|
|
|
//获取总数
|
|
$shop_stat_sum = $stat_shop_model->getShopStatSum($this->site_id);
|
|
$goods_model = new GoodsModel();
|
|
$shop_stat_sum[ 'data' ][ 'goods_count' ] = $goods_model->getGoodsTotalCount([ [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ] ])[ 'data' ];
|
|
$shop_stat_sum[ 'data' ]['member_count'] = (new Member())->getMemberCount([ [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ] ])[ 'data' ];
|
|
$order = new Order();
|
|
$shop_stat_sum[ 'data' ][ 'order_pay_count' ] = $order->getOrderCount([ [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ], [ 'pay_status', '=', 1 ] ])['data'];
|
|
$shop_stat_sum[ 'data' ][ 'order_total' ] = $order->getOrderMoneySum([ [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ], [ 'pay_status', '=', 1 ] ], 'pay_money')['data'];
|
|
$data[ 'shop_stat_sum' ] = $shop_stat_sum[ 'data' ];
|
|
|
|
//数据信息统计
|
|
$order = new OrderCommon();
|
|
$waitpay = $order->getOrderCount([ [ 'order_status', '=', 0 ], [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ], ['order_scene', '=', 'online'] ]);
|
|
$waitsend = $order->getOrderCount([ [ 'order_status', '=', 1 ], [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ] ]);
|
|
$order_refund_model = new OrderRefundModel();
|
|
$refund_num = $order_refund_model->getRefundOrderGoodsCount([
|
|
[ "site_id", "=", $this->site_id ],
|
|
[ "refund_status", "not in", [ OrderRefundDict::REFUND_NOT_APPLY, OrderRefundDict::REFUND_COMPLETE,OrderRefundDict::PARTIAL_REFUND ] ]
|
|
]);
|
|
|
|
//商品预警数
|
|
$goods_stock_alarm = $goods_model->getGoodsStockAlarm($this->site_id);
|
|
|
|
//商品总数
|
|
$goods_total = $goods_model->getGoodsTotalCount([ [ 'goods_state', '=', 1 ], [ 'site_id', '=', $this->site_id ], [ 'is_delete', '=', 0 ] ]);
|
|
|
|
$num_data = [
|
|
'waitpay' => $waitpay[ 'data' ],
|
|
'waitsend' => $waitsend[ 'data' ],
|
|
'refund' => $refund_num[ 'data' ],
|
|
'goods_stock_alarm' => is_array($goods_stock_alarm[ 'data' ]) ? count($goods_stock_alarm[ 'data' ]) : 0,
|
|
'goods_total' => $goods_total[ 'data' ]
|
|
];
|
|
$data[ 'num_data' ] = $num_data;
|
|
|
|
$notice = new NoticeModel();
|
|
$notice_list = $notice->getNoticePageList([ [ 'receiving_type', 'like', '%shop%' ] ], 1, 3, 'is_top desc,create_time desc', 'id, title');
|
|
$notice_list = $notice_list[ 'data' ][ 'list' ];
|
|
$data[ 'notice_list' ] = $notice_list;
|
|
|
|
return $this->response($this->success($data));
|
|
}
|
|
|
|
} |