Index.php 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473
  1. <?php
  2. namespace app\admin\controller;
  3. use FormBuilder\Json;
  4. use think\facade\Config;
  5. use app\admin\model\system\{SystemConfig, SystemMenus, SystemRole};
  6. use app\admin\model\user\{User, UserExtract as UserExtractModel, User as UserModel};
  7. /**
  8. * 首页控制器
  9. * Class Index
  10. * @package app\admin\controller
  11. *
  12. */
  13. class Index extends AuthController
  14. {
  15. public function index()
  16. {
  17. //获取当前登录后台的管理员信息
  18. $adminInfo = $this->adminInfo->toArray();
  19. $roles = explode(',', $adminInfo['roles']);
  20. $site_logo = SystemConfig::getOneConfig('menu_name', 'site_logo')->toArray();
  21. $this->assign([
  22. 'menuList' => SystemMenus::menuList(),
  23. 'site_logo' => json_decode($site_logo['value'], true),
  24. 'new_order_audio_link' => sys_config('new_order_audio_link'),
  25. 'role_name' => SystemRole::where('id', $roles[0])->field('role_name')->find(),
  26. 'workermanPort' => Config::get('workerman.admin.port')
  27. ]);
  28. return $this->fetch();
  29. }
  30. //后台首页内容
  31. public function main()
  32. {
  33. /*首页第一行统计*/
  34. $now_month = strtotime(date('Y-m'));//本月
  35. $pre_month = strtotime(date('Y-m', strtotime('-1 month')));//上月
  36. $now_day = strtotime(date('Y-m-d'));//今日
  37. $pre_day = strtotime(date('Y-m-d', strtotime('-1 day')));//昨天时间戳
  38. $beforyester_day = strtotime(date('Y-m-d', strtotime('-2 day')));//前天时间戳
  39. //待发货数量
  40. //新粉丝->日
  41. $now_day_user = User::where('add_time', '>', $now_day)->count();
  42. $pre_day_user = User::where('add_time', '>', $pre_day)->where('add_time', '<', $now_day)->count();
  43. $pre_day_user = $pre_day_user ? $pre_day_user : 0;
  44. $first_line['day'] = [
  45. 'data' => $now_day_user ? $now_day_user : 0,
  46. 'percent' => abs($now_day_user - $pre_day_user),
  47. 'is_plus' => $now_day_user - $pre_day_user > 0 ? 1 : ($now_day_user - $pre_day_user == 0 ? -1 : 0)
  48. ];
  49. //新粉丝->月
  50. $now_month_user = User::where('add_time', '>', $now_month)->count();
  51. $pre_month_user = User::where('add_time', '>', $pre_month)->where('add_time', '<', $now_month)->count();
  52. $first_line['month'] = [
  53. 'data' => $now_month_user ? $now_month_user : 0,
  54. 'percent' => abs($now_month_user - $pre_month_user),
  55. 'is_plus' => $now_month_user - $pre_month_user > 0 ? 1 : ($now_month_user - $pre_month_user == 0 ? -1 : 0)
  56. ];
  57. $this->assign([
  58. 'first_line' => $first_line,
  59. ]);
  60. return $this->fetch();
  61. }
  62. /**
  63. * 订单图表
  64. */
  65. public function orderchart()
  66. {
  67. header('Content-type:text/json');
  68. $cycle = $this->request->param('cycle') ?: 'thirtyday';//默认30天
  69. $datalist = [];
  70. switch ($cycle) {
  71. case 'thirtyday':
  72. $datebefor = date('Y-m-d', strtotime('-30 day'));
  73. $dateafter = date('Y-m-d');
  74. //上期
  75. $pre_datebefor = date('Y-m-d', strtotime('-60 day'));
  76. $pre_dateafter = date('Y-m-d', strtotime('-30 day'));
  77. for ($i = -30; $i < 0; $i++) {
  78. $datalist[date('m-d', strtotime($i . ' day'))] = date('m-d', strtotime($i . ' day'));
  79. }
  80. $order_list = [];
  81. if (empty($order_list)) return Json::fail('无数据');
  82. foreach ($order_list as $k => &$v) {
  83. $order_list[$v['day']] = $v;
  84. }
  85. $cycle_list = [];
  86. foreach ($datalist as $dk => $dd) {
  87. if (!empty($order_list[$dd])) {
  88. $cycle_list[$dd] = $order_list[$dd];
  89. } else {
  90. $cycle_list[$dd] = ['count' => 0, 'day' => $dd, 'price' => ''];
  91. }
  92. }
  93. $chartdata = [];
  94. $data = [];//临时
  95. $chartdata['yAxis']['maxnum'] = 0;//最大值数量
  96. $chartdata['yAxis']['maxprice'] = 0;//最大值金额
  97. foreach ($cycle_list as $k => $v) {
  98. $data['day'][] = $v['day'];
  99. $data['count'][] = $v['count'];
  100. $data['price'][] = round($v['price'], 2);
  101. if ($chartdata['yAxis']['maxnum'] < $v['count'])
  102. $chartdata['yAxis']['maxnum'] = $v['count'];//日最大订单数
  103. if ($chartdata['yAxis']['maxprice'] < $v['price'])
  104. $chartdata['yAxis']['maxprice'] = $v['price'];//日最大金额
  105. }
  106. $chartdata['legend'] = ['订单金额', '订单数'];//分类
  107. $chartdata['xAxis'] = $data['day'];//X轴值
  108. //,'itemStyle'=>$series
  109. $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
  110. $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['price']];//分类1值
  111. $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['count']];//分类2值
  112. //统计总数上期
  113. $pre_total = null;
  114. if ($pre_total) {
  115. $chartdata['pre_cycle']['count'] = [
  116. 'data' => $pre_total['count'] ?: 0
  117. ];
  118. $chartdata['pre_cycle']['price'] = [
  119. 'data' => $pre_total['price'] ?: 0
  120. ];
  121. }
  122. //统计总数
  123. $total = null;
  124. if ($total) {
  125. $cha_count = intval($pre_total['count']) - intval($total['count']);
  126. //$pre_total['count'] = $pre_total['count'] == 0 ? 1 : $pre_total['count'];
  127. $chartdata['cycle']['count'] = [
  128. 'data' => $total['count'] ?: 0,
  129. 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
  130. 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
  131. ];
  132. $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
  133. //$pre_total['price'] = $pre_total['price'] == 0 ? 1 : $pre_total['price'];
  134. $chartdata['cycle']['price'] = [
  135. 'data' => $total['price'] ?: 0,
  136. 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
  137. 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
  138. ];
  139. }
  140. return app('json')->success('ok', $chartdata);
  141. break;
  142. case 'week':
  143. $weekarray = array(['周日'], ['周一'], ['周二'], ['周三'], ['周四'], ['周五'], ['周六']);
  144. $datebefor = date('Y-m-d', strtotime('-1 week Monday'));
  145. $dateafter = date('Y-m-d', strtotime('-1 week Sunday'));
  146. $order_list = [];
  147. //数据查询重新处理
  148. $new_order_list = [];
  149. foreach ($order_list as $k => $v) {
  150. $new_order_list[$v['day']] = $v;
  151. }
  152. $now_datebefor = date('Y-m-d', (time() - ((date('w') == 0 ? 7 : date('w')) - 1) * 24 * 3600));
  153. $now_dateafter = date('Y-m-d', strtotime("+1 day"));
  154. $now_order_list = [];
  155. //数据查询重新处理 key 变为当前值
  156. $new_now_order_list = [];
  157. foreach ($now_order_list as $k => $v) {
  158. $new_now_order_list[$v['day']] = $v;
  159. }
  160. foreach ($weekarray as $dk => $dd) {
  161. if (!empty($new_order_list[$dk])) {
  162. $weekarray[$dk]['pre'] = $new_order_list[$dk];
  163. } else {
  164. $weekarray[$dk]['pre'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
  165. }
  166. if (!empty($new_now_order_list[$dk])) {
  167. $weekarray[$dk]['now'] = $new_now_order_list[$dk];
  168. } else {
  169. $weekarray[$dk]['now'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
  170. }
  171. }
  172. $chartdata = [];
  173. $data = [];//临时
  174. $chartdata['yAxis']['maxnum'] = 0;//最大值数量
  175. $chartdata['yAxis']['maxprice'] = 0;//最大值金额
  176. foreach ($weekarray as $k => $v) {
  177. $data['day'][] = $v[0];
  178. $data['pre']['count'][] = $v['pre']['count'];
  179. $data['pre']['price'][] = round($v['pre']['price'], 2);
  180. $data['now']['count'][] = $v['now']['count'];
  181. $data['now']['price'][] = round($v['now']['price'], 2);
  182. if ($chartdata['yAxis']['maxnum'] < $v['pre']['count'] || $chartdata['yAxis']['maxnum'] < $v['now']['count']) {
  183. $chartdata['yAxis']['maxnum'] = $v['pre']['count'] > $v['now']['count'] ? $v['pre']['count'] : $v['now']['count'];//日最大订单数
  184. }
  185. if ($chartdata['yAxis']['maxprice'] < $v['pre']['price'] || $chartdata['yAxis']['maxprice'] < $v['now']['price']) {
  186. $chartdata['yAxis']['maxprice'] = $v['pre']['price'] > $v['now']['price'] ? $v['pre']['price'] : $v['now']['price'];//日最大金额
  187. }
  188. }
  189. $chartdata['legend'] = ['上周金额', '本周金额', '上周订单数', '本周订单数'];//分类
  190. $chartdata['xAxis'] = $data['day'];//X轴值
  191. //,'itemStyle'=>$series
  192. $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
  193. $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['pre']['price']];//分类1值
  194. $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['now']['price']];//分类1值
  195. $chartdata['series'][] = ['name' => $chartdata['legend'][2], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['pre']['count']];//分类2值
  196. $chartdata['series'][] = ['name' => $chartdata['legend'][3], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['now']['count']];//分类2值
  197. //统计总数上期
  198. $pre_total =[];
  199. if ($pre_total) {
  200. $chartdata['pre_cycle']['count'] = [
  201. 'data' => $pre_total['count'] ?: 0
  202. ];
  203. $chartdata['pre_cycle']['price'] = [
  204. 'data' => $pre_total['price'] ?: 0
  205. ];
  206. }
  207. //统计总数
  208. $total =[];
  209. if ($total) {
  210. $cha_count = intval($pre_total['count']) - intval($total['count']);
  211. //$pre_total['count'] = $pre_total['count'] == 0 ? 1 : $pre_total['count'];
  212. $chartdata['cycle']['count'] = [
  213. 'data' => $total['count'] ?: 0,
  214. 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
  215. 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
  216. ];
  217. $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
  218. //$pre_total['price'] = $pre_total['price'] == 0 ? 1 : $pre_total['price'];
  219. $chartdata['cycle']['price'] = [
  220. 'data' => $total['price'] ?: 0,
  221. 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
  222. 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
  223. ];
  224. }
  225. return app('json')->success('ok', $chartdata);
  226. break;
  227. case 'month':
  228. $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']);
  229. $datebefor = date('Y-m-01', strtotime('-1 month'));
  230. $dateafter = date('Y-m-d', strtotime(date('Y-m-01')));
  231. $order_list = [];
  232. //数据查询重新处理
  233. $new_order_list = [];
  234. foreach ($order_list as $k => $v) {
  235. $new_order_list[$v['day']] = $v;
  236. }
  237. $now_datebefor = date('Y-m-01');
  238. $now_dateafter = date('Y-m-d', strtotime("+1 day"));
  239. $now_order_list = [];
  240. //数据查询重新处理 key 变为当前值
  241. $new_now_order_list = [];
  242. foreach ($now_order_list as $k => $v) {
  243. $new_now_order_list[$v['day']] = $v;
  244. }
  245. foreach ($weekarray as $dk => $dd) {
  246. if (!empty($new_order_list[$dk])) {
  247. $weekarray[$dk]['pre'] = $new_order_list[$dk];
  248. } else {
  249. $weekarray[$dk]['pre'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
  250. }
  251. if (!empty($new_now_order_list[$dk])) {
  252. $weekarray[$dk]['now'] = $new_now_order_list[$dk];
  253. } else {
  254. $weekarray[$dk]['now'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
  255. }
  256. }
  257. $chartdata = [];
  258. $data = [];//临时
  259. $chartdata['yAxis']['maxnum'] = 0;//最大值数量
  260. $chartdata['yAxis']['maxprice'] = 0;//最大值金额
  261. foreach ($weekarray as $k => $v) {
  262. $data['day'][] = $v[0];
  263. $data['pre']['count'][] = $v['pre']['count'];
  264. $data['pre']['price'][] = round($v['pre']['price'], 2);
  265. $data['now']['count'][] = $v['now']['count'];
  266. $data['now']['price'][] = round($v['now']['price'], 2);
  267. if ($chartdata['yAxis']['maxnum'] < $v['pre']['count'] || $chartdata['yAxis']['maxnum'] < $v['now']['count']) {
  268. $chartdata['yAxis']['maxnum'] = $v['pre']['count'] > $v['now']['count'] ? $v['pre']['count'] : $v['now']['count'];//日最大订单数
  269. }
  270. if ($chartdata['yAxis']['maxprice'] < $v['pre']['price'] || $chartdata['yAxis']['maxprice'] < $v['now']['price']) {
  271. $chartdata['yAxis']['maxprice'] = $v['pre']['price'] > $v['now']['price'] ? $v['pre']['price'] : $v['now']['price'];//日最大金额
  272. }
  273. }
  274. $chartdata['legend'] = ['上月金额', '本月金额', '上月订单数', '本月订单数'];//分类
  275. $chartdata['xAxis'] = $data['day'];//X轴值
  276. //,'itemStyle'=>$series
  277. $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
  278. $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['pre']['price']];//分类1值
  279. $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['now']['price']];//分类1值
  280. $chartdata['series'][] = ['name' => $chartdata['legend'][2], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['pre']['count']];//分类2值
  281. $chartdata['series'][] = ['name' => $chartdata['legend'][3], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['now']['count']];//分类2值
  282. //统计总数上期
  283. $pre_total = null;
  284. if ($pre_total) {
  285. $chartdata['pre_cycle']['count'] = [
  286. 'data' => $pre_total['count'] ?: 0
  287. ];
  288. $chartdata['pre_cycle']['price'] = [
  289. 'data' => $pre_total['price'] ?: 0
  290. ];
  291. }
  292. //统计总数
  293. $total = null;
  294. if ($total) {
  295. $cha_count = intval($pre_total['count']) - intval($total['count']);
  296. //$pre_total['count'] = $pre_total['count'] == 0 ? 1 : $pre_total['count'];
  297. $chartdata['cycle']['count'] = [
  298. 'data' => $total['count'] ?: 0,
  299. 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
  300. 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
  301. ];
  302. $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
  303. //$pre_total['price'] = $pre_total['price'] == 0 ? 1 : $pre_total['price'];
  304. $chartdata['cycle']['price'] = [
  305. 'data' => $total['price'] ?: 0,
  306. 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
  307. 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
  308. ];
  309. }
  310. return app('json')->success('ok', $chartdata);
  311. break;
  312. case 'year':
  313. $weekarray = array('01' => ['一月'], '02' => ['二月'], '03' => ['三月'], '04' => ['四月'], '05' => ['五月'], '06' => ['六月'], '07' => ['七月'], '08' => ['八月'], '09' => ['九月'], '10' => ['十月'], '11' => ['十一月'], '12' => ['十二月']);
  314. $datebefor = date('Y-01-01', strtotime('-1 year'));
  315. $dateafter = date('Y-12-31', strtotime('-1 year'));
  316. $order_list = [];
  317. //数据查询重新处理
  318. $new_order_list = [];
  319. foreach ($order_list as $k => $v) {
  320. $new_order_list[$v['day']] = $v;
  321. }
  322. $now_datebefor = date('Y-01-01');
  323. $now_dateafter = date('Y-m-d');
  324. $now_order_list = [];
  325. //数据查询重新处理 key 变为当前值
  326. $new_now_order_list = [];
  327. foreach ($now_order_list as $k => $v) {
  328. $new_now_order_list[$v['day']] = $v;
  329. }
  330. foreach ($weekarray as $dk => $dd) {
  331. if (!empty($new_order_list[$dk])) {
  332. $weekarray[$dk]['pre'] = $new_order_list[$dk];
  333. } else {
  334. $weekarray[$dk]['pre'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
  335. }
  336. if (!empty($new_now_order_list[$dk])) {
  337. $weekarray[$dk]['now'] = $new_now_order_list[$dk];
  338. } else {
  339. $weekarray[$dk]['now'] = ['count' => 0, 'day' => $weekarray[$dk][0], 'price' => '0'];
  340. }
  341. }
  342. $chartdata = [];
  343. $data = [];//临时
  344. $chartdata['yAxis']['maxnum'] = 0;//最大值数量
  345. $chartdata['yAxis']['maxprice'] = 0;//最大值金额
  346. foreach ($weekarray as $k => $v) {
  347. $data['day'][] = $v[0];
  348. $data['pre']['count'][] = $v['pre']['count'];
  349. $data['pre']['price'][] = round($v['pre']['price'], 2);
  350. $data['now']['count'][] = $v['now']['count'];
  351. $data['now']['price'][] = round($v['now']['price'], 2);
  352. if ($chartdata['yAxis']['maxnum'] < $v['pre']['count'] || $chartdata['yAxis']['maxnum'] < $v['now']['count']) {
  353. $chartdata['yAxis']['maxnum'] = $v['pre']['count'] > $v['now']['count'] ? $v['pre']['count'] : $v['now']['count'];//日最大订单数
  354. }
  355. if ($chartdata['yAxis']['maxprice'] < $v['pre']['price'] || $chartdata['yAxis']['maxprice'] < $v['now']['price']) {
  356. $chartdata['yAxis']['maxprice'] = $v['pre']['price'] > $v['now']['price'] ? $v['pre']['price'] : $v['now']['price'];//日最大金额
  357. }
  358. }
  359. $chartdata['legend'] = ['去年金额', '今年金额', '去年订单数', '今年订单数'];//分类
  360. $chartdata['xAxis'] = $data['day'];//X轴值
  361. //,'itemStyle'=>$series
  362. $series = ['normal' => ['label' => ['show' => true, 'position' => 'top']]];
  363. $chartdata['series'][] = ['name' => $chartdata['legend'][0], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['pre']['price']];//分类1值
  364. $chartdata['series'][] = ['name' => $chartdata['legend'][1], 'type' => 'bar', 'itemStyle' => $series, 'data' => $data['now']['price']];//分类1值
  365. $chartdata['series'][] = ['name' => $chartdata['legend'][2], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['pre']['count']];//分类2值
  366. $chartdata['series'][] = ['name' => $chartdata['legend'][3], 'type' => 'line', 'itemStyle' => $series, 'data' => $data['now']['count']];//分类2值
  367. //统计总数上期
  368. $pre_total = null;
  369. if ($pre_total) {
  370. $chartdata['pre_cycle']['count'] = [
  371. 'data' => $pre_total['count'] ?: 0
  372. ];
  373. $chartdata['pre_cycle']['price'] = [
  374. 'data' => $pre_total['price'] ?: 0
  375. ];
  376. }
  377. //统计总数
  378. $total = null;
  379. if ($total) {
  380. $cha_count = intval($pre_total['count']) - intval($total['count']);
  381. //$pre_total['count'] = $pre_total['count'] == 0 ? 1 : $pre_total['count'];
  382. $chartdata['cycle']['count'] = [
  383. 'data' => $total['count'] ?: 0,
  384. 'percent' => intval($pre_total['count']) == 0 ? 100 : round((abs($cha_count) / intval($pre_total['count']) * 100), 2),
  385. 'is_plus' => $cha_count > 0 ? -1 : ($cha_count == 0 ? 0 : 1)
  386. ];
  387. $cha_price = round($pre_total['price'], 2) - round($total['price'], 2);
  388. //$pre_total['price'] = $pre_total['price'] == 0 ? 1 : $pre_total['price'];
  389. $chartdata['cycle']['price'] = [
  390. 'data' => $total['price'] ?: 0,
  391. 'percent' => (intval($pre_total['price']) == 0 || !$pre_total['price'] || $pre_total['price'] == 0.00) ? 100 : round(abs($cha_price) / $pre_total['price'] * 100, 2),
  392. 'is_plus' => $cha_price > 0 ? -1 : ($cha_price == 0 ? 0 : 1)
  393. ];
  394. }
  395. return app('json')->success('ok', $chartdata);
  396. break;
  397. default:
  398. break;
  399. }
  400. }
  401. /**
  402. * 用户图表
  403. */
  404. public function userchart()
  405. {
  406. header('Content-type:text/json');
  407. $starday = date('Y-m-d', strtotime('-30 day'));
  408. $yesterday = date('Y-m-d');
  409. $user_list = UserModel::where('add_time', 'between time', [$starday, $yesterday])
  410. ->field("FROM_UNIXTIME(add_time,'%m-%e') as day,count(*) as count")
  411. ->group("FROM_UNIXTIME(add_time, '%Y%m%e')")
  412. ->order('add_time asc')
  413. ->select()->toArray();
  414. $chartdata = [];
  415. $data = [];
  416. $chartdata['legend'] = ['用户数'];//分类
  417. $chartdata['yAxis']['maxnum'] = 0;//最大值数量
  418. $chartdata['xAxis'] = [date('m-d')];//X轴值
  419. $chartdata['series'] = [0];//分类1值
  420. if (!empty($user_list)) {
  421. foreach ($user_list as $k => $v) {
  422. $data['day'][] = $v['day'];
  423. $data['count'][] = $v['count'];
  424. if ($chartdata['yAxis']['maxnum'] < $v['count'])
  425. $chartdata['yAxis']['maxnum'] = $v['count'];
  426. }
  427. $chartdata['xAxis'] = $data['day'];//X轴值
  428. $chartdata['series'] = $data['count'];//分类1值
  429. }
  430. return app('json')->success('ok', $chartdata);
  431. }
  432. /**
  433. * 待办事统计
  434. * @param int $newTime
  435. * @return false|string
  436. */
  437. public function Jnotice($newTime = 30)
  438. {
  439. header('Content-type:text/json');
  440. $data = [];
  441. $data['ordernum'] = 0;//待发货
  442. $replenishment_num = sys_config('store_stock') > 0 ? sys_config('store_stock') : 2;//库存预警界限
  443. $data['inventory'] = 0;//库存
  444. $data['commentnum'] = 0;//评论
  445. $data['reflectnum'] = UserExtractModel::where('status', 0)->count();;//提现
  446. $data['msgcount'] = intval($data['ordernum']) + intval($data['inventory']) + intval($data['commentnum']) + intval($data['reflectnum']);
  447. //新订单提醒
  448. $data['newOrderId'] = [];
  449. // if (count($data['newOrderId'])) StoreOrderModel::where('order_id', 'in', $data['newOrderId'])->update(['is_remind' => 1]);
  450. return app('json')->success('ok', $data);
  451. }
  452. }