123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276 |
- <?php
- namespace app\admin\controller;
- use app\admin\model\Admin;
- use app\admin\model\User;
- use app\common\controller\Backend;
- use app\common\model\Attachment;
- use fast\Date;
- use think\Cache;
- use think\Db;
- class Statistics extends Backend
- {
-
- public function index()
- {
- ini_set("memory_limit","256M");
- $start = strtotime(date('Y-m-d'));
- $end = $start + 86399;
- $mt_user_gold_log = Db::name('user_gold_log');
-
- $total_gold = Db::name('user_wallet')->sum('gold');
-
- $total_recharge_money = Db::name('user_wallet')->sum('pay_money');
-
- $today_recharge_gold = $mt_user_gold_log->where(['log_type' => ['in', [1, 10]], 'change_value' => ['gt', 0], 'createtime' => ['egt', $start]])->sum('change_value');
-
- $yesterday_recharge_gold = $mt_user_gold_log->where(['log_type' => ['in', [1, 10]], 'change_value' => ['gt', 0], 'createtime' => ['between', [$start - 86400, $start - 1]]])->sum('change_value');
-
- $today_use_gold = $mt_user_gold_log->where(['change_value' => ['lt', 0], 'createtime' => ['egt', $start]])->sum('change_value');
- $today_use_gold = abs($today_use_gold);
-
- $yesterday_use_gold = $mt_user_gold_log->where(['change_value' => ['lt', 0], 'createtime' => ['between', [$start - 86400, $start - 1]]])->sum('change_value');
- $yesterday_use_gold = abs($yesterday_use_gold);
-
- $total_use_gold = $mt_user_gold_log->where(['change_value' => ['lt', 0]])->sum('change_value');
- $total_use_gold = abs($total_use_gold);
-
- $today_withdraw = Db::name('take_cash')->where(['status' => 1, 'createtime' => ['egt', $start]])->sum('number');
- $today_withdraw_ava = Db::name('take_cash')->where(['status' => 1, 'createtime' => ['egt', $start]])->sum('money');
-
- $yesterday_withdraw = Db::name('take_cash')->where(['status' => 1, 'createtime' => ['between', [$start - 86400, $start - 1]]])->sum('number');
- $yesterday_withdraw_ava = Db::name('take_cash')->where(['status' => 1, 'createtime' => ['between', [$start - 86400, $start - 1]]])->sum('money');
-
- $total_withdraw = Db::name('take_cash')->where(['status' => 1])->sum('number');
- $total_withdraw_ava = Db::name('take_cash')->where(['status' => 1])->sum('money');
-
- $today_exchange_gold = $mt_user_gold_log->where(['log_type' => 19, 'createtime' => ['egt', $start]])->sum('change_value');
-
- $yesterday_exchange_gold = $mt_user_gold_log->where(['log_type' => 19, 'createtime' => ['between', [$start - 86400, $start - 1]]])->sum('change_value');
-
- $total_exchange_gold = $mt_user_gold_log->where(['log_type' => 19])->sum('change_value');
-
-
-
- $man_num = Db::name('user')->where(['gender' => 1])->count('id');
-
- $today_man_num = Db::name('user')->where(['gender' => 1, 'createtime' => ['egt', $start]])->count('id');
-
- $yesterday_man_num = Db::name('user')->where(['gender' => 1, 'createtime' => ['between', [$start - 86400, $start - 1]]])->count('id');
-
-
- $from_man_num = Db::name('user')->where(['gender' => 1, 'register_from' => ['neq', '']])->count('id');
-
- $ios_from_man_num = Db::name('user')->where(['gender' => 1, 'register_from' => 'iOS'])->count('id');
-
- $android_from_man_num = $from_man_num - $ios_from_man_num;
-
-
- $woman_num = Db::name('user')->where(['gender' => 0])->count('id');
-
- $today_woman_num = Db::name('user')->where(['gender' => 0, 'createtime' => ['egt', $start]])->count('id');
-
- $yesterday_woman_num = Db::name('user')->where(['gender' => 0, 'createtime' => ['between', [$start - 86400, $start - 1]]])->count('id');
-
-
- $from_woman_num = Db::name('user')->where(['gender' => 0, 'register_from' => ['neq', '']])->count('id');
-
- $ios_from_woman_num = Db::name('user')->where(['gender' => 0, 'register_from' => 'iOS'])->count('id');
-
- $android_from_woman_num = $from_woman_num - $ios_from_woman_num;
-
- $today = day_now();
- $yesterday = day_yesterday();
-
- $userMoneyLog = Db::name('user_money_log');
- $inviteWhere['log_type'] = 68;
- $inviteTotal = $userMoneyLog->where($inviteWhere)->sum('change_value');
- $inviteNow = $userMoneyLog->where($inviteWhere)->where(['createtime' => ['between', [$today[0],$today[1]]]])->sum('change_value');
- $inviteYesterday = $userMoneyLog->where($inviteWhere)->where(['createtime' => ['between', [$yesterday[0],$yesterday[1]]]])->sum('change_value');
-
- $inviteRechargeWhere['log_type'] = 65;
- $inviteRechargeTotal = $userMoneyLog->where($inviteRechargeWhere)->sum('change_value');
- $inviteRechargeNow = $userMoneyLog->where($inviteRechargeWhere)->where(['createtime' => ['between', [$today[0],$today[1]]]])->sum('change_value');
- $inviteRechargeYesterday = $userMoneyLog->where($inviteRechargeWhere)->where(['createtime' => ['between', [$yesterday[0],$yesterday[1]]]])->sum('change_value');
-
-
-
-
- $goldTaskWhere['g.log_type'] = ['in',[14,17,20,41,101]];
- $goldTaskField = 'g.id,u.gender,g.change_value,g.log_type,g.createtime';
-
- $goldModelObj = Cache::remember('admin_statis_gold_log',function () use ($mt_user_gold_log,$goldTaskField,$goldTaskWhere){
- return $mt_user_gold_log->alias('g')->field($goldTaskField)->join('user u','u.id = g.user_id','LEFT')->where($goldTaskWhere)->select();
- },20);
- $manGoldTaskTotal = $manGoldTaskNow = $manGoldTaskYesterday = $manGoldTotal = $goldTotal = 0;
- $manGoldRechargeTotal = $manGoldRechargeNow = $manGoldRechargeYesterday = 0;
- $manGoldSignTotal = $manGoldSignNow = $manGoldSignYesterday = 0;
- $womanGoldTaskTotal = $womanGoldTaskNow = $womanGoldTaskYesterday = $womanGoldTotal = 0;
- $womanGoldRechargeTotal = $womanGoldRechargeNow = $womanGoldRechargeYesterday = 0;
- $womanGoldSignTotal = $womanGoldSignNow = $womanGoldSignYesterday = 0;
- if (!empty($goldModelObj)) {
- foreach ($goldModelObj as $goldKey =>$goldValue) {
- if ($goldValue['gender'] == 1) {
- if (in_array($goldValue['log_type'],[20])) {
- if ($goldValue['createtime'] >= $today[0] && $goldValue['createtime'] < $today[1]) {
- $manGoldTaskNow = bcadd($manGoldTaskNow,$goldValue['change_value']);
- } elseif ($goldValue['createtime'] >= $yesterday[0] && $goldValue['createtime'] < $yesterday[1]) {
- $manGoldTaskYesterday = bcadd($manGoldTaskYesterday,$goldValue['change_value']);
- }
- $manGoldTaskTotal = bcadd($manGoldTaskTotal,$goldValue['change_value']);
- } elseif (in_array($goldValue['log_type'],[14,17,101])) {
- if ($goldValue['createtime'] >= $today[0] && $goldValue['createtime'] < $today[1]) {
- $manGoldRechargeNow = bcadd($manGoldRechargeNow,$goldValue['change_value']);
- } elseif ($goldValue['createtime'] >= $yesterday[0] && $goldValue['createtime'] < $yesterday[1]) {
- $manGoldRechargeYesterday = bcadd($manGoldRechargeYesterday,$goldValue['change_value']);
- }
- $manGoldRechargeTotal = bcadd($manGoldRechargeTotal,$goldValue['change_value']);
- } elseif (in_array($goldValue['log_type'],[41])) {
- if ($goldValue['createtime'] >= $today[0] && $goldValue['createtime'] < $today[1]) {
- $manGoldSignNow = bcadd($manGoldSignNow,$goldValue['change_value']);
- } elseif ($goldValue['createtime'] >= $yesterday[0] && $goldValue['createtime'] < $yesterday[1]) {
- $manGoldSignYesterday = bcadd($manGoldSignYesterday,$goldValue['change_value']);
- }
- $manGoldSignTotal = bcadd($manGoldSignTotal,$goldValue['change_value']);
- }
- $manGoldTotal = bcadd($manGoldTotal,$goldValue['change_value']);
- } elseif ($goldValue['gender'] == 0) {
- if (in_array($goldValue['log_type'],[20])) {
- if ($goldValue['createtime'] >= $today[0] && $goldValue['createtime'] < $today[1]) {
- $womanGoldTaskNow = bcadd($womanGoldTaskNow, $goldValue['change_value']);
- } elseif ($goldValue['createtime'] >= $yesterday[0] && $goldValue['createtime'] < $yesterday[1]) {
- $womanGoldTaskYesterday = bcadd($womanGoldTaskYesterday, $goldValue['change_value']);
- }
- $womanGoldTaskTotal = bcadd($womanGoldTaskTotal, $goldValue['change_value']);
- } elseif (in_array($goldValue['log_type'],[14,17,101])) {
- if ($goldValue['createtime'] >= $today[0] && $goldValue['createtime'] < $today[1]) {
- $womanGoldRechargeNow = bcadd($womanGoldRechargeNow,$goldValue['change_value']);
- } elseif ($goldValue['createtime'] >= $yesterday[0] && $goldValue['createtime'] < $yesterday[1]) {
- $womanGoldRechargeYesterday = bcadd($womanGoldRechargeYesterday,$goldValue['change_value']);
- }
- $womanGoldRechargeTotal = bcadd($womanGoldRechargeTotal,$goldValue['change_value']);
- } elseif (in_array($goldValue['log_type'],[41])) {
- if ($goldValue['createtime'] >= $today[0] && $goldValue['createtime'] < $today[1]) {
- $womanGoldSignNow = bcadd($womanGoldSignNow,$goldValue['change_value']);
- } elseif ($goldValue['createtime'] >= $yesterday[0] && $goldValue['createtime'] < $yesterday[1]) {
- $womanGoldSignYesterday = bcadd($womanGoldSignYesterday,$goldValue['change_value']);
- }
- $womanGoldSignTotal = bcadd($womanGoldSignTotal,$goldValue['change_value']);
- }
- $womanGoldTotal = bcadd($womanGoldTotal,$goldValue['change_value']);
- }
- }
- }
- $goldTotal = bcadd($manGoldTotal,$womanGoldTotal);
-
-
-
- $wechatTotal = $wechatNow = $wechatYesterday = 0.00;
- $payOrder = Db::name('pay_order');
- $payOrderWhere['status'] = 1;
- $payOrderWhere['type'] = 'recharge_gold';
- $payOrderWhere['payment_class'] = 'wechat';
- $wechatTotal = $payOrder->where($payOrderWhere)->sum('money');
- $wechatNow = $payOrder->where($payOrderWhere)->where(['createtime' => ['between', [$today[0],$today[1]]]])->sum('money');
- $wechatYesterday = $payOrder->where($payOrderWhere)->where(['createtime' => ['between', [$yesterday[0],$yesterday[1]]]])->sum('money');
-
-
- $payOrder = Db::name('pay_order');
- $payOrderWhere['status'] = 1;
- $payOrderWhere['type'] = 'recharge_gold';
- $payOrderWhere['payment_class'] = 'alipay';
- $alipayTotal = $payOrder->where($payOrderWhere)->sum('money');
- $alipayNow = $payOrder->where($payOrderWhere)->where(['createtime' => ['between', [$today[0],$today[1]]]])->sum('money');
- $alipayYesterday = $payOrder->where($payOrderWhere)->where(['createtime' => ['between', [$yesterday[0],$yesterday[1]]]])->sum('money');
- $statistics = [
- 'invite_total' => $inviteTotal,
- 'invite_now' => $inviteNow,
- 'invite_yesterday' => $inviteYesterday,
- 'invite_recharge_total' => $inviteRechargeTotal,
- 'invite_recharge_now' => $inviteRechargeNow,
- 'invite_recharge_yesterday' => $inviteRechargeYesterday,
- 'man_gold_task_total' => $manGoldTaskTotal,
- 'man_gold_task_now' => $manGoldTaskNow,
- 'man_gold_task_yesterday' => $manGoldTaskYesterday,
- 'man_gold_recharge_total' => $manGoldRechargeTotal,
- 'man_gold_recharge_now' => $manGoldRechargeNow,
- 'man_gold_recharge_yesterday' => $manGoldRechargeYesterday,
- 'man_gold_sign_total' => $manGoldSignTotal,
- 'man_gold_sign_now' => $manGoldSignNow,
- 'man_gold_sign_yesterday' => $manGoldSignYesterday,
- 'man_gold_total' => $manGoldTotal,
- 'woman_gold_task_total' => $womanGoldTaskTotal,
- 'woman_gold_task_now' => $womanGoldTaskNow,
- 'woman_gold_task_yesterday' => $womanGoldTaskYesterday,
- 'woman_gold_recharge_total' => $womanGoldRechargeTotal,
- 'woman_gold_recharge_now' => $womanGoldRechargeNow,
- 'woman_gold_recharge_yesterday' => $womanGoldRechargeYesterday,
- 'woman_gold_sign_total' => $womanGoldSignTotal,
- 'woman_gold_sign_now' => $womanGoldSignNow,
- 'woman_gold_sign_yesterday' => $womanGoldSignYesterday,
- 'woman_gold_total' => $womanGoldTotal,
- 'gold_total' => $goldTotal,
- 'wechat_total' => $wechatTotal,
- 'wechat_now' => $wechatNow,
- 'wechat_yesterday' => $wechatYesterday,
- 'alipay_total' => $alipayTotal,
- 'alipay_now' => $alipayNow,
- 'alipay_yesterday' => $alipayYesterday,
- ];
- $this->assign('total_gold', $total_gold);
- $this->assign('total_recharge_money', $total_recharge_money);
- $this->assign('today_recharge_gold', $today_recharge_gold);
- $this->assign('yesterday_recharge_gold', $yesterday_recharge_gold);
- $this->assign('today_use_gold', $today_use_gold);
- $this->assign('yesterday_use_gold', $yesterday_use_gold);
- $this->assign('total_use_gold', $total_use_gold);
- $this->assign('today_withdraw', $today_withdraw);
- $this->assign('today_withdraw_ava', $today_withdraw_ava);
- $this->assign('yesterday_withdraw', $yesterday_withdraw);
- $this->assign('yesterday_withdraw_ava', $yesterday_withdraw_ava);
- $this->assign('total_withdraw', $total_withdraw);
- $this->assign('total_withdraw_ava', $total_withdraw_ava);
- $this->assign('today_exchange_gold', $today_exchange_gold);
- $this->assign('yesterday_exchange_gold', $yesterday_exchange_gold);
- $this->assign('total_exchange_gold', $total_exchange_gold);
- $this->assign('man_num', $man_num);
- $this->assign('today_man_num', $today_man_num);
- $this->assign('yesterday_man_num', $yesterday_man_num);
- $this->assign('android_from_man_num', $android_from_man_num);
- $this->assign('ios_from_man_num', $ios_from_man_num);
- $this->assign('woman_num', $woman_num);
- $this->assign('today_woman_num', $today_woman_num);
- $this->assign('yesterday_woman_num', $yesterday_woman_num);
- $this->assign('android_from_woman_num', $android_from_woman_num);
- $this->assign('ios_from_woman_num', $ios_from_woman_num);
- $this->assign($statistics);
- return $this->view->fetch();
- }
- }
|