Dashboard.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\Admin;
  4. use app\admin\model\User;
  5. use app\common\controller\Backend;
  6. use app\common\model\Attachment;
  7. use fast\Date;
  8. use think\Db;
  9. /**
  10. * 控制台
  11. *
  12. * @icon fa fa-dashboard
  13. * @remark 用于展示当前系统中的统计数据、统计报表及重要实时数据
  14. */
  15. class Dashboard extends Backend
  16. {
  17. /**
  18. * 查看
  19. */
  20. public function index()
  21. {
  22. try {
  23. \think\Db::execute("SET @@sql_mode='';");
  24. } catch (\Exception $e) {
  25. }
  26. $column = [];
  27. $starttime = Date::unixtime('day', -6);
  28. $endtime = Date::unixtime('day', 0, 'end');
  29. $joinlist = Db("user")->where('jointime', 'between time', [$starttime, $endtime])
  30. ->field('jointime, status, COUNT(*) AS nums, DATE_FORMAT(FROM_UNIXTIME(jointime), "%Y-%m-%d") AS join_date')
  31. ->group('join_date')
  32. ->select();
  33. for ($time = $starttime; $time <= $endtime;) {
  34. $column[] = date("Y-m-d", $time);
  35. $time += 86400;
  36. }
  37. $userlist = array_fill_keys($column, 0);
  38. foreach ($joinlist as $k => $v) {
  39. $userlist[$v['join_date']] = $v['nums'];
  40. }
  41. $dbTableList = Db::query("SHOW TABLE STATUS");
  42. $addonList = get_addon_list();
  43. $totalworkingaddon = 0;
  44. $totaladdon = count($addonList);
  45. foreach ($addonList as $index => $item) {
  46. if ($item['state']) {
  47. $totalworkingaddon += 1;
  48. }
  49. }
  50. $this->view->assign([
  51. 'totaluser' => User::count(),
  52. 'totaladdon' => $totaladdon,
  53. 'totaladmin' => Admin::count(),
  54. 'totalcategory' => \app\common\model\Category::count(),
  55. 'todayusersignup' => User::whereTime('jointime', 'today')->count(),
  56. 'todayuserlogin' => User::whereTime('logintime', 'today')->count(),
  57. 'sevendau' => User::whereTime('jointime|logintime|prevtime', '-7 days')->count(),
  58. 'thirtydau' => User::whereTime('jointime|logintime|prevtime', '-30 days')->count(),
  59. 'threednu' => User::whereTime('jointime', '-3 days')->count(),
  60. 'sevendnu' => User::whereTime('jointime', '-7 days')->count(),
  61. 'dbtablenums' => count($dbTableList),
  62. 'dbsize' => array_sum(array_map(function ($item) {
  63. return $item['Data_length'] + $item['Index_length'];
  64. }, $dbTableList)),
  65. 'totalworkingaddon' => $totalworkingaddon,
  66. 'attachmentnums' => Attachment::count(),
  67. 'attachmentsize' => Attachment::sum('filesize'),
  68. 'picturenums' => Attachment::where('mimetype', 'like', 'image/%')->count(),
  69. 'picturesize' => Attachment::where('mimetype', 'like', 'image/%')->sum('filesize'),
  70. ]);
  71. $this->assignconfig('column', array_keys($userlist));
  72. $this->assignconfig('userdata', array_values($userlist));
  73. return $this->view->fetch();
  74. }
  75. /**
  76. * 订单统计笔数
  77. */
  78. public function order(){
  79. $starttime = strtotime(date('Y-m-d',strtotime("-30 day"))); //默认30天前
  80. $endtime = strtotime(date('Y-m-d')) - 1;
  81. //接收
  82. $choicedatetime = input('choicedatetime','');
  83. if(!empty($choicedatetime)){
  84. $choicedatetime = explode(' - ',$choicedatetime);
  85. $starttime = strtotime($choicedatetime[0]);
  86. $endtime = strtotime($choicedatetime[1]) + 86399;
  87. }
  88. $this->view->assign('defaultdatetime',date('Y-m-d',$starttime).' - '.date('Y-m-d',$endtime));
  89. //dump($starttime);
  90. //dump($endtime);
  91. //过去30天
  92. $ec_date = [];
  93. $ec_ordernum = [];
  94. // $ec_orderfee = [];
  95. $whereop = $this->whereop('company_id');
  96. $whereop['status'] = 3;
  97. for($i=$starttime;$i<$endtime;$i+=86400){
  98. $starttime_i = $i;
  99. $endtime_i = $i + 86399;
  100. //dump($starttime);
  101. //日历
  102. $ec_date[] = date('Y-m-d',$starttime_i);
  103. //下单人数
  104. $whereop['finish_time'] = ['between',[$starttime_i,$endtime_i]];
  105. $ec_ordernum[] = Db::name('order')->where($whereop)->count('id');
  106. //下单金额
  107. // $ec_orderfee[] = Db::name('order')->where(['createtime'=>['between',[$starttime_i,$endtime_i]]])->sum('pay_fee');
  108. }
  109. $this->assignconfig('ec_date', $ec_date);
  110. $this->assignconfig('ec_ordernum', $ec_ordernum);
  111. // $this->assignconfig('ec_orderfee', $ec_orderfee);
  112. return $this->view->fetch();
  113. }
  114. /**
  115. * 订单统计各类型
  116. */
  117. public function orderservicetype(){
  118. $starttime = strtotime(date('Y-m-d',strtotime("-30 day"))); //默认30天前
  119. $endtime = strtotime(date('Y-m-d')) - 1;
  120. //接收
  121. $choicedatetime = input('choicedatetime','');
  122. if(!empty($choicedatetime)){
  123. $choicedatetime = explode(' - ',$choicedatetime);
  124. $starttime = strtotime($choicedatetime[0]);
  125. $endtime = strtotime($choicedatetime[1]) + 86399;
  126. }
  127. $this->view->assign('defaultdatetime',date('Y-m-d',$starttime).' - '.date('Y-m-d',$endtime));
  128. //饼图
  129. $whereop = $this->whereop('company_id');
  130. $whereop['status'] = 3;
  131. $whereop['finish_time'] = ['between',[$starttime,$endtime]];
  132. $servicetype = Db::name('servicetype')->field('id,title as name')->select();
  133. $all_count = Db::name('order')->where($whereop)->count('id');
  134. foreach($servicetype as $key => &$val){
  135. $whereop['servicetype_id'] = $val['id'];
  136. $val['value'] = Db::name('order')->where($whereop)->count('id');
  137. $val['name'] = $val['name'] . bcdiv($val['value'],$all_count,4)*100 . '%';
  138. unset($val['id']);
  139. }
  140. $this->assignconfig('servicetype', $servicetype);
  141. return $this->view->fetch();
  142. }
  143. /**
  144. * 客户统计
  145. */
  146. public function datacentertwo(){
  147. $whereop = $this->whereop('company_id');
  148. $usernumber = Db::name('user_wallet')->where($whereop)->count();//充卡客户数量
  149. $summoney = Db::name('user_wallet')->where($whereop)->sum('money');//充卡余额
  150. //客户类别
  151. $comefrom_config = ['线下新客','老带新','平台引流','自然进店'];
  152. $comefrom_array = [];
  153. foreach($comefrom_config as $key => $val){
  154. $number = Db::name('user_wallet')->where($whereop)->where('comefrom',$val)->count();
  155. $comefrom_array[] = ['name'=>$val . bcdiv($number,$usernumber,4)*100 . '%','value'=>$number];
  156. }
  157. //
  158. $this->assign('usernumber', $usernumber);
  159. $this->assign('summoney', $summoney);
  160. $this->assignconfig('comefrom_array', $comefrom_array);
  161. return $this->view->fetch();
  162. }
  163. /**
  164. * 七日销售金额数据统计
  165. */
  166. public function datacenterthree(){
  167. $servicetype = Db::name('servicetype')->field('id,title as name')->select();
  168. $this->assignconfig('servicetype',array_column($servicetype,'name'));
  169. //七日
  170. $starttime = strtotime(date('Y-m-d')) - 518400;
  171. $endtime = strtotime(date('Y-m-d')) + 86399;
  172. $ec_date = [];
  173. $map = [
  174. 'company_id' => $this->auth->company_id,
  175. 'status' => 3,
  176. ];
  177. /*if($this->auth->type == 2){
  178. $map['staff_id'] = $this->auth->id;
  179. }*/
  180. for($i=$starttime;$i<$endtime;$i+=86400){
  181. $starttime_i = $i;
  182. $endtime_i = $i + 86399;
  183. //日历
  184. $ec_date[] = date('d',$starttime_i).'日';
  185. }
  186. $this->assignconfig('ec_date',$ec_date);
  187. foreach($servicetype as $key => &$val){
  188. $val['type'] = 'bar';
  189. if($key == 0){
  190. $val['barGap'] = 0;
  191. }
  192. $val['label'] = 'labelOption';
  193. $val['emphasis'] = ['focus'=>'series'];
  194. $val['data'] = [];
  195. $map['servicetype_id'] = $val['id'];
  196. for($i=$starttime;$i<$endtime;$i+=86400){
  197. $starttime_i = $i;
  198. $endtime_i = $i + 86399;
  199. //销售金额
  200. $map['finish_time'] = ['between',[$starttime_i,$endtime_i]];
  201. $val['data'][] = Db::name('order')->where($map)->sum('total_fee');
  202. }
  203. unset($val['id']);
  204. }
  205. $this->assignconfig('servicetype',$servicetype);
  206. return $this->view->fetch();
  207. }
  208. /**
  209. * 半年销售金额数据统计
  210. */
  211. public function datacenter_three2(){
  212. $servicetype = Db::name('servicetype')->field('id,title as name')->select();
  213. $thismonth = strtotime(date('Y-m-01'));
  214. $ec_date = [];
  215. $map = [
  216. 'company_id' => $this->auth->company_id,
  217. 'status' => 3,
  218. ];
  219. if($this->auth->type == 2){
  220. $map['staff_id'] = $this->auth->id;
  221. }
  222. for($i=5;$i>=0;$i--){
  223. $starttime_i = strtotime("-".$i." month",$thismonth);
  224. $endtime_i = strtotime("-".($i+1) ." month",$thismonth) - 1;
  225. //日历
  226. $ec_date[] = date('m',$starttime_i).'月';
  227. //dump(date('Y-m-d H:i:s',$starttime_i));
  228. //dump(date('Y-m-d H:i:s',$endtime_i));
  229. }
  230. foreach($servicetype as $key => &$val){
  231. $map['servicetype_id'] = $val['id'];
  232. $val['data'] = [];
  233. $val['textColor'] = '#FFFFFF';
  234. for($i=5;$i>=0;$i-=1){
  235. $starttime_i = strtotime("-".$i." month",$thismonth);
  236. $endtime_i = strtotime("-".($i+1) ." month",$thismonth) - 1;
  237. //销售金额
  238. $map['finish_time'] = ['between',[$starttime_i,$endtime_i]];
  239. $val['data'][] = Db::name('order')->where($map)->sum('total_fee');
  240. }
  241. unset($val['id']);
  242. }
  243. $result = [
  244. 'ec_data' => $ec_date,
  245. 'ec_totalfee' => $servicetype,
  246. ];
  247. $this->success(1,$result);
  248. }
  249. /**
  250. * 业绩统计笔数
  251. */
  252. public function datacenterfour(){
  253. $starttime = strtotime(date('Y-m-d',strtotime("-30 day"))); //默认30天前
  254. $endtime = strtotime(date('Y-m-d')) - 1;
  255. //接收
  256. $choicedatetime = input('choicedatetime','');
  257. if(!empty($choicedatetime)){
  258. $choicedatetime = explode(' - ',$choicedatetime);
  259. $starttime = strtotime($choicedatetime[0]);
  260. $endtime = strtotime($choicedatetime[1]) + 86399;
  261. }
  262. $this->view->assign('defaultdatetime',date('Y-m-d',$starttime).' - '.date('Y-m-d',$endtime));
  263. $staff = Db::name('company_staff')->field('id,truename')->where('type',2)->where('company_id',$this->auth->company_id)->select();
  264. //柱状图
  265. $ec_date = [];
  266. $ec_ordernum = [];
  267. $map = [
  268. 'company_id' => $this->auth->company_id,
  269. 'status' => 3,
  270. 'finish_time' => ['between',[$starttime,$endtime]],
  271. ];
  272. foreach($staff as $key => $val){
  273. //日历
  274. $ec_date[] = $val['truename'];
  275. //下单人数
  276. $map['staff_id'] = $val['id'];
  277. $ec_ordernum[] = Db::name('order')->where($map)->count('id');
  278. }
  279. $this->assignconfig('ec_date', $ec_date);
  280. $this->assignconfig('ec_ordernum', $ec_ordernum);
  281. return $this->view->fetch();
  282. }
  283. /**
  284. * 业绩统计金额
  285. */
  286. public function datacenterfive(){
  287. $starttime = strtotime(date('Y-m-d',strtotime("-30 day"))); //默认30天前
  288. $endtime = strtotime(date('Y-m-d')) - 1;
  289. //接收
  290. $choicedatetime = input('choicedatetime','');
  291. if(!empty($choicedatetime)){
  292. $choicedatetime = explode(' - ',$choicedatetime);
  293. $starttime = strtotime($choicedatetime[0]);
  294. $endtime = strtotime($choicedatetime[1]) + 86399;
  295. }
  296. $this->view->assign('defaultdatetime',date('Y-m-d',$starttime).' - '.date('Y-m-d',$endtime));
  297. $staff = Db::name('company_staff')->field('id,truename')->where('type',2)->where('company_id',$this->auth->company_id)->select();
  298. //柱状图
  299. $ec_date = [];
  300. $ec_ordernum = [];
  301. $map = [
  302. 'company_id' => $this->auth->company_id,
  303. 'status' => 3,
  304. 'finish_time' => ['between',[$starttime,$endtime]],
  305. ];
  306. foreach($staff as $key => $val){
  307. //日历
  308. $ec_date[] = $val['truename'];
  309. //下单人数
  310. $map['staff_id'] = $val['id'];
  311. $ec_ordernum[] = Db::name('order')->where($map)->sum('total_fee');
  312. }
  313. $this->assignconfig('ec_date', $ec_date);
  314. $this->assignconfig('ec_ordernum', $ec_ordernum);
  315. return $this->view->fetch();
  316. }
  317. }