123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587 |
- <?php
- namespace app\admin\controller;
- use FormBuilder\Json;
- use think\facade\Config;
- use app\admin\model\order\StoreOrder as StoreOrderModel;
- use app\admin\model\system\{SystemConfig, SystemMenus, SystemRole};
- use app\admin\model\user\{User, UserExtract as UserExtractModel, User as UserModel};
- use app\admin\model\store\{StoreProduct, StoreProductReply as StoreProductReplyModel, StoreProduct as ProductModel};
- class Index extends AuthController
- {
- public function index()
- {
-
- $adminInfo = $this->adminInfo->toArray();
- $roles = explode(',', $adminInfo['roles']);
- $site_logo = SystemConfig::getOneConfig('menu_name', 'site_logo')->toArray();
- $this->assign([
- 'menuList' => SystemMenus::menuList(),
- 'site_logo' => json_decode($site_logo['value'], true),
- 'new_order_audio_link' => sys_config('new_order_audio_link'),
- 'role_name' => SystemRole::where('id', $roles[0])->field('role_name')->find(),
- 'workermanPort' => Config::get('workerman.admin.port')
- ]);
- return $this->fetch();
- }
-
- public function main()
- {
-
- $now_month = strtotime(date('Y-m'));
- $pre_month = strtotime(date('Y-m', strtotime('-1 month')));
- $now_day = strtotime(date('Y-m-d'));
- $pre_day = strtotime(date('Y-m-d', strtotime('-1 day')));
- $beforyester_day = strtotime(date('Y-m-d', strtotime('-2 day')));
-
- $topData['orderDeliveryNum'] = StoreOrderModel::where('status', 0)
- ->where('paid', 1)
- ->where('refund_status', 0)
- ->where('shipping_type', 1)
- ->where('is_del', 0)
- ->count();
-
- $topData['orderRefundNum'] = StoreOrderModel::where('paid', 1)
- ->where('refund_status', 'IN', '1')
- ->count();
-
- $replenishment_num = sys_config('store_stock') > 0 ? sys_config('store_stock') : 20;
- $topData['stockProduct'] = StoreProduct::where('stock', '<=', $replenishment_num)->where('is_show', 1)->where('is_del', 0)->count();
-
- $topData['treatedExtract'] = UserExtractModel::where('status', 0)->count();
-
- $now_day_order_p = StoreOrderModel::where('paid', 1)->whereTime('pay_time', 'yesterday')->count();
- $pre_day_order_p = StoreOrderModel::where('paid', 1)->where('pay_time', '>', $pre_day)->where('pay_time', '<', $now_day)->count();
- $first_line['d_num'] = [
- 'data' => $now_day_order_p ? $now_day_order_p : 0,
- 'percent' => abs($now_day_order_p - $pre_day_order_p),
- 'is_plus' => $now_day_order_p - $pre_day_order_p > 0 ? 1 : ($now_day_order_p - $pre_day_order_p == 0 ? -1 : 0)
- ];
-
- $now_month_order_p = StoreOrderModel::where('paid', 1)->whereTime('pay_time', 'yesterday')->sum('pay_price');
- $pre_month_order_p = StoreOrderModel::where('paid', 1)->where('pay_time', '>', $beforyester_day)->where('pay_time', '<', $pre_day)->sum('pay_price');
- $first_line['d_price'] = [
- 'data' => $now_month_order_p > 0 ? $now_month_order_p : 0,
- 'percent' => abs($now_month_order_p - $pre_month_order_p),
- 'is_plus' => $now_month_order_p - $pre_month_order_p > 0 ? 1 : ($now_month_order_p - $pre_month_order_p == 0 ? -1 : 0)
- ];
-
- $now_month_order_p = StoreOrderModel::where('paid', 1)->whereTime('pay_time', 'month')->sum('pay_price');
- $pre_month_order_p = StoreOrderModel::where('paid', 1)->where('pay_time', '>', $pre_month)->where('pay_time', '<', $now_month)->value('sum(pay_price)');
- $first_line['m_price'] = [
- 'data' => $now_month_order_p > 0 ? $now_month_order_p : 0,
- 'percent' => abs($now_month_order_p - $pre_month_order_p),
- 'is_plus' => $now_month_order_p - $pre_month_order_p > 0 ? 1 : ($now_month_order_p - $pre_month_order_p == 0 ? -1 : 0)
- ];
-
- $now_day_user = User::where('add_time', '>', $now_day)->count();
- $pre_day_user = User::where('add_time', '>', $pre_day)->where('add_time', '<', $now_day)->count();
- $pre_day_user = $pre_day_user ? $pre_day_user : 0;
- $first_line['day'] = [
- 'data' => $now_day_user ? $now_day_user : 0,
- 'percent' => abs($now_day_user - $pre_day_user),
- 'is_plus' => $now_day_user - $pre_day_user > 0 ? 1 : ($now_day_user - $pre_day_user == 0 ? -1 : 0)
- ];
-
- $now_month_user = User::where('add_time', '>', $now_month)->count();
- $pre_month_user = User::where('add_time', '>', $pre_month)->where('add_time', '<', $now_month)->count();
- $first_line['month'] = [
- 'data' => $now_month_user ? $now_month_user : 0,
- 'percent' => abs($now_month_user - $pre_month_user),
- 'is_plus' => $now_month_user - $pre_month_user > 0 ? 1 : ($now_month_user - $pre_month_user == 0 ? -1 : 0)
- ];
-
- $now_order_info_c = StoreOrderModel::where('add_time', '>', $now_month)->count();
- $pre_order_info_c = StoreOrderModel::where('add_time', '>', $pre_month)->where('add_time', '<', $now_month)->count();
- $order_info['first'] = [
- 'data' => $now_order_info_c ? $now_order_info_c : 0,
- 'percent' => abs($now_order_info_c - $pre_order_info_c),
- 'is_plus' => $now_order_info_c - $pre_order_info_c > 0 ? 1 : ($now_order_info_c - $pre_order_info_c == 0 ? -1 : 0)
- ];
-
- $second_now_month = strtotime(date('Y-m', strtotime('-1 month')));
- $second_pre_month = strtotime(date('Y-m', strtotime('-2 month')));
- $now_order_info_c = StoreOrderModel::where('add_time', '>', $pre_month)->where('add_time', '<', $now_month)->count();
- $pre_order_info_c = StoreOrderModel::where('add_time', '>', $second_pre_month)->where('add_time', '<', $second_now_month)->count();
- $order_info["second"] = [
- 'data' => $now_order_info_c ? $now_order_info_c : 0,
- 'percent' => abs($now_order_info_c - $pre_order_info_c),
- 'is_plus' => $now_order_info_c - $pre_order_info_c > 0 ? 1 : ($now_order_info_c - $pre_order_info_c == 0 ? -1 : 0)
- ];
- $second_line['order_info'] = $order_info;
- $this->assign([
- 'first_line' => $first_line,
- 'second_line' => $second_line,
- 'topData' => $topData,
- ]);
- return $this->fetch();
- }
-
- public function orderchart()
- {
- header('Content-type:text/json');
- $cycle = $this->request->param('cycle') ?: 'thirtyday';
- $datalist = [];
- switch ($cycle) {
- case 'thirtyday':
- $datebefor = date('Y-m-d', strtotime('-30 day'));
- $dateafter = date('Y-m-d');
-
- $pre_datebefor = date('Y-m-d', strtotime('-60 day'));
- $pre_dateafter = date('Y-m-d', strtotime('-30 day'));
- for ($i = -30; $i < 0; $i++) {
- $datalist[date('m-d', strtotime($i . ' day'))] = date('m-d', strtotime($i . ' day'));
- }
- $order_list = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("FROM_UNIXTIME(add_time,'%m-%d') as day,count(*) as count,sum(pay_price) as price")
- ->group("FROM_UNIXTIME(add_time, '%Y%m%d')")
- ->order('add_time asc')
- ->select()->toArray();
- if (empty($order_list)) return Json::fail('无数据');
- foreach ($order_list as $k => &$v) {
- $order_list[$v['day']] = $v;
- }
- $cycle_list = [];
- foreach ($datalist as $dk => $dd) {
- if (!empty($order_list[$dd])) {
- $cycle_list[$dd] = $order_list[$dd];
- } else {
- $cycle_list[$dd] = ['count' => 0, 'day' => $dd, 'price' => ''];
- }
- }
- $chartdata = [];
- $data = [];
- $chartdata['yAxis']['maxnum'] = 0;
- $chartdata['yAxis']['maxprice'] = 0;
- foreach ($cycle_list as $k => $v) {
- $data['day'][] = $v['day'];
- $data['count'][] = $v['count'];
- $data['price'][] = round($v['price'], 2);
- if ($chartdata['yAxis']['maxnum'] < $v['count'])
- $chartdata['yAxis']['maxnum'] = $v['count'];
- if ($chartdata['yAxis']['maxprice'] < $v['price'])
- $chartdata['yAxis']['maxprice'] = $v['price'];
- }
- $chartdata['legend'] = ['订单金额', '订单数'];
- $chartdata['xAxis'] = $data['day'];
-
- $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
- $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['price']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['count']];
-
- $pre_total = StoreOrderModel::where('add_time', 'between time', [$pre_datebefor, $pre_dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($pre_total) {
- $chartdata['pre_cycle']['count'] = [
- 'data' => $pre_total['count'] ?: 0
- ];
- $chartdata['pre_cycle']['price'] = [
- 'data' => $pre_total['price'] ?: 0
- ];
- }
-
- $total = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($total) {
- $cha_count = intval($pre_total['count']) - intval($total['count']);
-
- $chartdata['cycle']['count'] = [
- 'data' => $total['count'] ?: 0,
- 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
- 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
- ];
- $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
-
- $chartdata['cycle']['price'] = [
- 'data' => $total['price'] ?: 0,
- 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
- 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
- ];
- }
- return app('json')->success('ok', $chartdata);
- break;
- case 'week':
- $weekarray = array(['周日'], ['周一'], ['周二'], ['周三'], ['周四'], ['周五'], ['周六']);
- $datebefor = date('Y-m-d', strtotime('-1 week Monday'));
- $dateafter = date('Y-m-d', strtotime('-1 week Sunday'));
- $order_list = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("FROM_UNIXTIME(add_time,'%w') as day,count(*) as count,sum(pay_price) as price")
- ->group("FROM_UNIXTIME(add_time, '%Y%m%e')")
- ->order('add_time asc')
- ->select()->toArray();
-
- $new_order_list = [];
- foreach ($order_list as $k => $v) {
- $new_order_list[$v['day']] = $v;
- }
- $now_datebefor = date('Y-m-d', (time() - ((date('w') == 0 ? 7 : date('w')) - 1) * 24 * 3600));
- $now_dateafter = date('Y-m-d', strtotime("+1 day"));
- $now_order_list = StoreOrderModel::where('add_time', 'between time', [$now_datebefor, $now_dateafter])
- ->field("FROM_UNIXTIME(add_time,'%w') as day,count(*) as count,sum(pay_price) as price")
- ->group("FROM_UNIXTIME(add_time, '%Y%m%e')")
- ->order('add_time asc')
- ->select()->toArray();
-
- $new_now_order_list = [];
- foreach ($now_order_list as $k => $v) {
- $new_now_order_list[$v['day']] = $v;
- }
- foreach ($weekarray as $dk => $dd) {
- if (!empty($new_order_list[$dk])) {
- $weekarray[$dk]['pre'] = $new_order_list[$dk];
- } else {
- $weekarray[$dk]['pre'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
- }
- if (!empty($new_now_order_list[$dk])) {
- $weekarray[$dk]['now'] = $new_now_order_list[$dk];
- } else {
- $weekarray[$dk]['now'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
- }
- }
- $chartdata = [];
- $data = [];
- $chartdata['yAxis']['maxnum'] = 0;
- $chartdata['yAxis']['maxprice'] = 0;
- foreach ($weekarray as $k => $v) {
- $data['day'][] = $v[0];
- $data['pre']['count'][] = $v['pre']['count'];
- $data['pre']['price'][] = round($v['pre']['price'], 2);
- $data['now']['count'][] = $v['now']['count'];
- $data['now']['price'][] = round($v['now']['price'], 2);
- if ($chartdata['yAxis']['maxnum'] < $v['pre']['count'] || $chartdata['yAxis']['maxnum'] < $v['now']['count']) {
- $chartdata['yAxis']['maxnum'] = $v['pre']['count'] > $v['now']['count'] ? $v['pre']['count'] : $v['now']['count'];
- }
- if ($chartdata['yAxis']['maxprice'] < $v['pre']['price'] || $chartdata['yAxis']['maxprice'] < $v['now']['price']) {
- $chartdata['yAxis']['maxprice'] = $v['pre']['price'] > $v['now']['price'] ? $v['pre']['price'] : $v['now']['price'];
- }
- }
- $chartdata['legend'] = ['上周金额', '本周金额', '上周订单数', '本周订单数'];
- $chartdata['xAxis'] = $data['day'];
-
- $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
- $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['pre']['price']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['now']['price']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][2], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['pre']['count']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][3], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['now']['count']];
-
- $pre_total = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($pre_total) {
- $chartdata['pre_cycle']['count'] = [
- 'data' => $pre_total['count'] ?: 0
- ];
- $chartdata['pre_cycle']['price'] = [
- 'data' => $pre_total['price'] ?: 0
- ];
- }
-
- $total = StoreOrderModel::where('add_time', 'between time', [$now_datebefor, $now_dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($total) {
- $cha_count = intval($pre_total['count']) - intval($total['count']);
-
- $chartdata['cycle']['count'] = [
- 'data' => $total['count'] ?: 0,
- 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
- 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
- ];
- $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
-
- $chartdata['cycle']['price'] = [
- 'data' => $total['price'] ?: 0,
- 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
- 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
- ];
- }
- return app('json')->success('ok', $chartdata);
- break;
- case 'month':
- $weekarray = array('01' => ['1'], '02' => ['2'], '03' => ['3'], '04' => ['4'], '05' => ['5'], '06' => ['6'], '07' => ['7'], '08' => ['8'], '09' => ['9'], '10' => ['10'], '11' => ['11'], '12' => ['12'], '13' => ['13'], '14' => ['14'], '15' => ['15'], '16' => ['16'], '17' => ['17'], '18' => ['18'], '19' => ['19'], '20' => ['20'], '21' => ['21'], '22' => ['22'], '23' => ['23'], '24' => ['24'], '25' => ['25'], '26' => ['26'], '27' => ['27'], '28' => ['28'], '29' => ['29'], '30' => ['30'], '31' => ['31']);
- $datebefor = date('Y-m-01', strtotime('-1 month'));
- $dateafter = date('Y-m-d', strtotime(date('Y-m-01')));
- $order_list = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("FROM_UNIXTIME(add_time,'%d') as day,count(*) as count,sum(pay_price) as price")
- ->group("FROM_UNIXTIME(add_time, '%Y%m%e')")
- ->order('add_time asc')
- ->select()->toArray();
-
- $new_order_list = [];
- foreach ($order_list as $k => $v) {
- $new_order_list[$v['day']] = $v;
- }
- $now_datebefor = date('Y-m-01');
- $now_dateafter = date('Y-m-d', strtotime("+1 day"));
- $now_order_list = StoreOrderModel::where('add_time', 'between time', [$now_datebefor, $now_dateafter])
- ->field("FROM_UNIXTIME(add_time,'%d') as day,count(*) as count,sum(pay_price) as price")
- ->group("FROM_UNIXTIME(add_time, '%Y%m%e')")
- ->order('add_time asc')
- ->select()->toArray();
-
- $new_now_order_list = [];
- foreach ($now_order_list as $k => $v) {
- $new_now_order_list[$v['day']] = $v;
- }
- foreach ($weekarray as $dk => $dd) {
- if (!empty($new_order_list[$dk])) {
- $weekarray[$dk]['pre'] = $new_order_list[$dk];
- } else {
- $weekarray[$dk]['pre'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
- }
- if (!empty($new_now_order_list[$dk])) {
- $weekarray[$dk]['now'] = $new_now_order_list[$dk];
- } else {
- $weekarray[$dk]['now'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
- }
- }
- $chartdata = [];
- $data = [];
- $chartdata['yAxis']['maxnum'] = 0;
- $chartdata['yAxis']['maxprice'] = 0;
- foreach ($weekarray as $k => $v) {
- $data['day'][] = $v[0];
- $data['pre']['count'][] = $v['pre']['count'];
- $data['pre']['price'][] = round($v['pre']['price'], 2);
- $data['now']['count'][] = $v['now']['count'];
- $data['now']['price'][] = round($v['now']['price'], 2);
- if ($chartdata['yAxis']['maxnum'] < $v['pre']['count'] || $chartdata['yAxis']['maxnum'] < $v['now']['count']) {
- $chartdata['yAxis']['maxnum'] = $v['pre']['count'] > $v['now']['count'] ? $v['pre']['count'] : $v['now']['count'];
- }
- if ($chartdata['yAxis']['maxprice'] < $v['pre']['price'] || $chartdata['yAxis']['maxprice'] < $v['now']['price']) {
- $chartdata['yAxis']['maxprice'] = $v['pre']['price'] > $v['now']['price'] ? $v['pre']['price'] : $v['now']['price'];
- }
- }
- $chartdata['legend'] = ['上月金额', '本月金额', '上月订单数', '本月订单数'];
- $chartdata['xAxis'] = $data['day'];
-
- $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
- $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['pre']['price']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['now']['price']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][2], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['pre']['count']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][3], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['now']['count']];
-
- $pre_total = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($pre_total) {
- $chartdata['pre_cycle']['count'] = [
- 'data' => $pre_total['count'] ?: 0
- ];
- $chartdata['pre_cycle']['price'] = [
- 'data' => $pre_total['price'] ?: 0
- ];
- }
-
- $total = StoreOrderModel::where('add_time', 'between time', [$now_datebefor, $now_dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($total) {
- $cha_count = intval($pre_total['count']) - intval($total['count']);
-
- $chartdata['cycle']['count'] = [
- 'data' => $total['count'] ?: 0,
- 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
- 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
- ];
- $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
-
- $chartdata['cycle']['price'] = [
- 'data' => $total['price'] ?: 0,
- 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
- 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
- ];
- }
- return app('json')->success('ok', $chartdata);
- break;
- case 'year':
- $weekarray = array('01' => ['一月'], '02' => ['二月'], '03' => ['三月'], '04' => ['四月'], '05' => ['五月'], '06' => ['六月'], '07' => ['七月'], '08' => ['八月'], '09' => ['九月'], '10' => ['十月'], '11' => ['十一月'], '12' => ['十二月']);
- $datebefor = date('Y-01-01', strtotime('-1 year'));
- $dateafter = date('Y-12-31', strtotime('-1 year'));
- $order_list = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("FROM_UNIXTIME(add_time,'%m') as day,count(*) as count,sum(pay_price) as price")
- ->group("FROM_UNIXTIME(add_time, '%Y%m')")
- ->order('add_time asc')
- ->select()->toArray();
-
- $new_order_list = [];
- foreach ($order_list as $k => $v) {
- $new_order_list[$v['day']] = $v;
- }
- $now_datebefor = date('Y-01-01');
- $now_dateafter = date('Y-m-d');
- $now_order_list = StoreOrderModel::where('add_time', 'between time', [$now_datebefor, $now_dateafter])
- ->field("FROM_UNIXTIME(add_time,'%m') as day,count(*) as count,sum(pay_price) as price")
- ->group("FROM_UNIXTIME(add_time, '%Y%m')")
- ->order('add_time asc')
- ->select()->toArray();
-
- $new_now_order_list = [];
- foreach ($now_order_list as $k => $v) {
- $new_now_order_list[$v['day']] = $v;
- }
- foreach ($weekarray as $dk => $dd) {
- if (!empty($new_order_list[$dk])) {
- $weekarray[$dk]['pre'] = $new_order_list[$dk];
- } else {
- $weekarray[$dk]['pre'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
- }
- if (!empty($new_now_order_list[$dk])) {
- $weekarray[$dk]['now'] = $new_now_order_list[$dk];
- } else {
- $weekarray[$dk]['now'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
- }
- }
- $chartdata = [];
- $data = [];
- $chartdata['yAxis']['maxnum'] = 0;
- $chartdata['yAxis']['maxprice'] = 0;
- foreach ($weekarray as $k => $v) {
- $data['day'][] = $v[0];
- $data['pre']['count'][] = $v['pre']['count'];
- $data['pre']['price'][] = round($v['pre']['price'], 2);
- $data['now']['count'][] = $v['now']['count'];
- $data['now']['price'][] = round($v['now']['price'], 2);
- if ($chartdata['yAxis']['maxnum'] < $v['pre']['count'] || $chartdata['yAxis']['maxnum'] < $v['now']['count']) {
- $chartdata['yAxis']['maxnum'] = $v['pre']['count'] > $v['now']['count'] ? $v['pre']['count'] : $v['now']['count'];
- }
- if ($chartdata['yAxis']['maxprice'] < $v['pre']['price'] || $chartdata['yAxis']['maxprice'] < $v['now']['price']) {
- $chartdata['yAxis']['maxprice'] = $v['pre']['price'] > $v['now']['price'] ? $v['pre']['price'] : $v['now']['price'];
- }
- }
- $chartdata['legend'] = ['去年金额', '今年金额', '去年订单数', '今年订单数'];
- $chartdata['xAxis'] = $data['day'];
-
- $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
- $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['pre']['price']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['now']['price']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][2], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['pre']['count']];
- $chartdata['series'][] = ['name' => $chartdata['legend'][3], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['now']['count']];
-
- $pre_total = StoreOrderModel::where('add_time', 'between time', [$datebefor, $dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($pre_total) {
- $chartdata['pre_cycle']['count'] = [
- 'data' => $pre_total['count'] ?: 0
- ];
- $chartdata['pre_cycle']['price'] = [
- 'data' => $pre_total['price'] ?: 0
- ];
- }
-
- $total = StoreOrderModel::where('add_time', 'between time', [$now_datebefor, $now_dateafter])
- ->field("count(*) as count,sum(pay_price) as price")
- ->find();
- if ($total) {
- $cha_count = intval($pre_total['count']) - intval($total['count']);
-
- $chartdata['cycle']['count'] = [
- 'data' => $total['count'] ?: 0,
- 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
- 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
- ];
- $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
-
- $chartdata['cycle']['price'] = [
- 'data' => $total['price'] ?: 0,
- 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
- 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
- ];
- }
- return app('json')->success('ok', $chartdata);
- break;
- default:
- break;
- }
- }
-
- public function userchart()
- {
- header('Content-type:text/json');
- $starday = date('Y-m-d', strtotime('-30 day'));
- $yesterday = date('Y-m-d');
- $user_list = UserModel::where('add_time', 'between time', [$starday, $yesterday])
- ->field("FROM_UNIXTIME(add_time,'%m-%e') as day,count(*) as count")
- ->group("FROM_UNIXTIME(add_time, '%Y%m%e')")
- ->order('add_time asc')
- ->select()->toArray();
- $chartdata = [];
- $data = [];
- $chartdata['legend'] = ['用户数'];
- $chartdata['yAxis']['maxnum'] = 0;
- $chartdata['xAxis'] = [date('m-d')];
- $chartdata['series'] = [0];
- if (!empty($user_list)) {
- foreach ($user_list as $k => $v) {
- $data['day'][] = $v['day'];
- $data['count'][] = $v['count'];
- if ($chartdata['yAxis']['maxnum'] < $v['count'])
- $chartdata['yAxis']['maxnum'] = $v['count'];
- }
- $chartdata['xAxis'] = $data['day'];
- $chartdata['series'] = $data['count'];
- }
- return app('json')->success('ok', $chartdata);
- }
-
- public function Jnotice($newTime = 30)
- {
- header('Content-type:text/json');
- $data = [];
- $data['ordernum'] = StoreOrderModel::statusByWhere(1)->count();
- $replenishment_num = sys_config('store_stock') > 0 ? sys_config('store_stock') : 2;
- $data['inventory'] = ProductModel::where('stock', '<=', $replenishment_num)->where('is_show', 1)->where('is_del', 0)->count();
- $data['commentnum'] = StoreProductReplyModel::where('is_reply', 0)->count();
- $data['reflectnum'] = UserExtractModel::where('status', 0)->count();;
- $data['msgcount'] = intval($data['ordernum']) + intval($data['inventory']) + intval($data['commentnum']) + intval($data['reflectnum']);
-
- $data['newOrderId'] = StoreOrderModel::statusByWhere(1)->where('is_remind', 0)->column('order_id', 'id');
- if (count($data['newOrderId'])) StoreOrderModel::where('order_id', 'in', $data['newOrderId'])->update(['is_remind' => 1]);
- return app('json')->success('ok', $data);
- }
- }
|