BonusController.php 45 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: leo
  5. * Date: 2018/2/24
  6. * Time: 下午12:48
  7. */
  8. namespace frontendApi\modules\v1\controllers;
  9. use common\helpers\Cache;
  10. use common\helpers\Date;
  11. use common\helpers\Tool;
  12. use common\helpers\user\Info;
  13. use common\helpers\user\Perf;
  14. use common\models\CalcBonus;
  15. use common\models\CalcBonusBT;
  16. use common\models\CalcBonusFL;
  17. use common\models\DealType;
  18. use common\models\FlowBonus;
  19. use common\models\FlowCF;
  20. use common\models\FlowLX;
  21. use common\models\FlowReconsumePoints;
  22. use common\models\FlowWallet;
  23. use common\models\PerfMonth;
  24. use common\models\Period;
  25. use common\models\DecRole;
  26. use common\models\EmployLevel;
  27. use common\models\FlowExchangePoints;
  28. use common\models\PerfMonthPrepare;
  29. use common\models\ScoreMonth;
  30. use common\models\UserBonus;
  31. use common\models\UserRelation;
  32. use common\models\UserWallet;
  33. use frontendApi\modules\v1\models\User;
  34. class BonusController extends BaseController {
  35. public $modelClass = CalcBonus::class;
  36. /**
  37. * 我的账户
  38. * @return mixed
  39. * @throws \yii\web\HttpException
  40. */
  41. public function actionIndex() {
  42. $userId = \Yii::$app->user->id;
  43. $data = UserBonus::findUseSlaves()->select('BONUS,RECONSUME_POINTS,EXCHANGE_POINTS')->where('USER_ID=:USER_ID', [':USER_ID' => $userId])->asArray()->one();
  44. if (!$data) {
  45. $data = [
  46. 'BONUS' => 0,
  47. 'RECONSUME_POINTS' => 0,
  48. 'EXCHANGE_POINTS' => 0,
  49. ];
  50. }
  51. $data['CASH'] = 0;
  52. $cashWallet = UserWallet::findOneAsArray('USER_ID=:USER_ID', [':USER_ID'=>$userId], 'CASH');
  53. if($cashWallet){
  54. $data['CASH'] = $cashWallet['CASH'];
  55. }
  56. //是否显示车房领袖
  57. // $showCFLX = true;
  58. // if ($data['CF'] <= 0 && $data['LX'] <= 0) {
  59. // $showCFLX = false;
  60. // //查看历史最高聘级是否到过五钻
  61. // if (EmployLevel::getSortById(Info::getHighEmpLv($userId)) >= 7) {
  62. // $showCFLX = true;
  63. // }
  64. // }
  65. $wallet[] = ['walletType' => 'bonus', 'walletName' => '会员奖金', 'amount' => Tool::formatPrice($data['BONUS'])];
  66. $wallet[] = ['walletType' => 'cash', 'walletName' => '会员余额', 'amount' => Tool::formatPrice($data['CASH'])];
  67. $wallet[] = ['walletType' => 'point', 'walletName' => '会员积分', 'amount' => Tool::formatPrice($data['RECONSUME_POINTS'])];
  68. $wallet[] = ['walletType' => 'exchange', 'walletName' => '兑换积分', 'amount' => Tool::formatPrice($data['EXCHANGE_POINTS'])];
  69. // if ($showCFLX) {
  70. // $wallet[] = ['walletType' => 'cf', 'walletName' => '福利积分一', 'amount' => Tool::formatPrice($data['CF'])];
  71. // $wallet[] = ['walletType' => 'lx', 'walletName' => '福利积分二', 'amount' => Tool::formatPrice($data['LX'])];
  72. // }
  73. //是否显示报单中心
  74. // $showBt = true;
  75. // $showFl = true;
  76. // $userInfo = User::getEnCodeInfo(\Yii::$app->user->id);
  77. // if ($userInfo['IS_DEC'] != 1) {
  78. // $showBt = false;
  79. // $showFl = false;
  80. // }else{
  81. // $sysConfig = Cache::getSystemConfig();
  82. // if(!$sysConfig['openBT']['VALUE']&&!$sysConfig['openPROD']['VALUE']) $showBt = false;
  83. // if(!$sysConfig['openFL']['VALUE']) $showFl = false;
  84. // $decRole = DecRole::find()->where('1=1')->indexBy('ID')->asArray()->all()[$userInfo['DEC_ROLE_ID']];
  85. // if ($decRole['GOODS_SUBSIDY'] <= 0) $showFl = false;
  86. // }
  87. $dealSwitch = isset(Cache::getSystemConfig()['dealSwitch']) ? Cache::getSystemConfig()['dealSwitch']['VALUE'] : '';
  88. return static::notice(['wallet' => $wallet,'dealSwitch'=>$dealSwitch]);
  89. }
  90. /**
  91. * 团队查询
  92. * @return mixed
  93. * @throws \yii\web\HttpException
  94. */
  95. public function actionTeams() {
  96. $userId = \Yii::$app->user->id;
  97. $period = Period::instance();
  98. $periodNum = $period->getNowPeriodNum();
  99. $month = $period->getNowYearMonth();
  100. // 判断是否是周日,并且是否是月结节点
  101. // 判断是否是月节点
  102. $isCalcMonth = $period->isCalcMonth($periodNum);
  103. $w = date('w', time());
  104. // if ($w != '0' || $isCalcMonth != 1) {
  105. // return static::notice(['user' => [],'team'=>[]]);
  106. // }
  107. // 达标规则,小组底下有一个大于等于一万.或者个人情况里的合计大于等于一万
  108. $month = '202203';
  109. $data = PerfMonthPrepare::getMonthPerfPrepare($userId, $month);
  110. // PV_PCS 个人业绩 PV_PSS 月新增团队业绩 PV_PSS_TOTAL月累计团队业绩
  111. // 其中页面使用的是月新增团队业绩
  112. // 获取用信息
  113. $userInfo = User::getEnCodeInfo($userId);
  114. $user[0] = [
  115. 'number' => $userInfo['USER_NAME'],
  116. 'name' => $userInfo['REAL_NAME'],
  117. 'perf_status' => '0', // 0 未达标 1为已达标
  118. 'perf_status_name' => '不达标',
  119. 'user_perf' => 0, // 个人业绩
  120. 'team_perf' => 0, // 团队新增累计业绩
  121. 'total_perf' => 0 // 合计业绩
  122. ];
  123. if (!empty($data)) {
  124. $user[0]['user_perf'] = Tool::formatPreparePerf($data['PV_PCS']);
  125. $user[0]['team_perf'] = Tool::formatPreparePerf($data['PV_PSS']);
  126. $user[0]['total_perf'] = Tool::formatPreparePerf($data['PV_PCS']+$data['PV_PSS']);
  127. $userCheck = PerfMonthPrepare::checkPrepareStatus($user[0]['total_perf']);
  128. if ($userCheck) {
  129. $user[0]['perf_status'] = '1';
  130. $user[0]['perf_status_name'] = '达标';
  131. }
  132. }
  133. $teamInfo = [];
  134. // 查询此用户的推荐(开拓)团队一级信息
  135. $relation = UserRelation::getChildrenWithDeepAndLayer($userId, 1, 1, $periodNum);
  136. $userStatusFlag = false;
  137. if ($relation) {
  138. // 循环一级开拓用户
  139. foreach($relation as $k=>$v) {
  140. // 获取此用户预计算月业绩
  141. $relationPerf = PerfMonthPrepare::getMonthPerfPrepare($v['USER_ID'], $month);
  142. if (empty($relationPerf)) {
  143. $relationPerf['PV_PCS'] = 0;
  144. $relationPerf['PV_PSS'] = 0;
  145. }
  146. $relationCheck = PerfMonthPrepare::checkPrepareStatus($relationPerf['PV_PCS']+$relationPerf['PV_PSS']);
  147. $teamInfo[]['perf_status'] = $relationCheck ? 1 : 0;
  148. if ($relationCheck) {
  149. $userStatusFlag = true; // 只要有一个达标,则个人就达标
  150. $teamInfo[$k]['number'] = '';
  151. $teamInfo[$k]['name'] = '';
  152. $teamInfo[$k]['user_perf'] = '';
  153. $teamInfo[$k]['team_perf'] = '';
  154. $teamInfo[$k]['total_perf'] = '';
  155. $teamInfo[$k]['perf_status'] = '1';
  156. $teamInfo[$k]['perf_status_name'] = '达标';
  157. } else {
  158. $teamInfo[$k]['number'] = $v['USER_NAME'];
  159. $teamInfo[$k]['name'] = $v['REAL_NAME'];
  160. $teamInfo[$k]['user_perf'] = Tool::formatPreparePerf($relationPerf['PV_PCS']);
  161. $teamInfo[$k]['team_perf'] = Tool::formatPreparePerf($relationPerf['PV_PSS']);
  162. $teamInfo[$k]['total_perf'] = Tool::formatPreparePerf($relationPerf['PV_PCS']+$relationPerf['PV_PSS']);
  163. $teamInfo[$k]['perf_status'] = '0';
  164. $teamInfo[$k]['perf_status_name'] = '不达标';
  165. }
  166. }
  167. }
  168. if ($userStatusFlag === true) {
  169. $user[0]['perf_status'] = 1;
  170. $user[0]['perf_status_name'] = '达标';
  171. }
  172. return static::notice(['user' => $user,'team'=>$teamInfo]);
  173. }
  174. /**
  175. * 交易记录
  176. * @return mixed
  177. * @throws \yii\web\HttpException
  178. */
  179. public function actionWalletFlow(){
  180. $walletType = \Yii::$app->request->get('walletType');
  181. if(!in_array($walletType,['bonus','point','cash','exchange'])) return static::notice('错误的账户类型',400);
  182. $dealType = \Yii::$app->request->get('dealType');
  183. $createAt = \Yii::$app->request->get('createAt');
  184. $remark = \Yii::$app->request->get('remark');
  185. //获取可以查看几期流水
  186. $showFlowPeriodNum = Cache::getSystemConfig()['showFlowPeriodNum']['VALUE'];
  187. $periodArr = Period::getNearlyPeriodNum($showFlowPeriodNum);
  188. $condition = ' AND USER_ID=:USER_ID AND PERIOD_NUM>=:PERIOD_NUM_MIN AND PERIOD_NUM<=:PERIOD_NUM_MAX';
  189. $params = [':USER_ID' => \Yii::$app->user->id,':PERIOD_NUM_MIN' => min($periodArr), ':PERIOD_NUM_MAX'=> max($periodArr)];
  190. if($dealType){
  191. if($dealType==1){//增加
  192. $condition.=' AND IS_INCR=1 AND DEAL_TYPE_IS_PRESET=0';
  193. }elseif ($dealType==2){//扣除
  194. $condition.=' AND IS_INCR=0 AND DEAL_TYPE_IS_PRESET=0';
  195. }else{
  196. $condition.=' AND DEAL_TYPE_ID=:DEAL_TYPE';
  197. $params[':DEAL_TYPE'] = $dealType;
  198. }
  199. }
  200. if ($createAt) {
  201. $condition .= " AND CREATED_AT>:CREATED_START AND CREATED_AT<:CREATED_END";
  202. $params[':CREATED_START'] = Date::utcToTime($createAt[0]);
  203. $params[':CREATED_END'] = Date::utcToTime($createAt[1])+86399;
  204. }
  205. if($remark){
  206. $condition .= " AND REMARK LIKE :REMARK";
  207. $params[':REMARK'] = '%'.$remark.'%';
  208. }
  209. $data = [];
  210. $dealLists=[];
  211. $dealTypes=[];
  212. if($walletType == 'bonus') {
  213. $dealLists = FlowBonus::find()->groupBy('DEAL_TYPE_ID')->select('DEAL_TYPE_ID')->where('USER_ID=:USER_ID',[':USER_ID'=>\Yii::$app->user->id])->asArray()->all();
  214. $data = FlowBonus::lists($condition, $params, [
  215. 'useSlaves' => true,
  216. 'select' => 'AMOUNT,TOTAL,IS_INCR,REMARK,REMARK_IS_SHOW,PERIOD_NUM,CALC_MONTH,CREATED_AT,DEAL_TYPE_ID,DEAL_TYPE_IS_PRESET',
  217. 'orderBy' => 'CREATED_AT DESC,SORT DESC',
  218. ]);
  219. }elseif ($walletType == 'point'){
  220. $dealLists = FlowReconsumePoints::find()->groupBy('DEAL_TYPE_ID')->select('DEAL_TYPE_ID')->where('USER_ID=:USER_ID',[':USER_ID'=>\Yii::$app->user->id])->asArray()->all();
  221. $data = FlowReconsumePoints::lists($condition, $params, [
  222. 'useSlaves' => true,
  223. 'select' => 'AMOUNT,TOTAL,IS_INCR,REMARK,REMARK_IS_SHOW,PERIOD_NUM,CALC_MONTH,CREATED_AT,DEAL_TYPE_ID,DEAL_TYPE_IS_PRESET',
  224. 'orderBy' => 'CREATED_AT DESC',
  225. ]);
  226. }elseif ($walletType == 'cash'){
  227. $data = FlowWallet::lists($condition, $params, [
  228. 'select' => 'AMOUNT,TOTAL,IS_INCR,REMARK,PERIOD_NUM,CALC_MONTH,CREATED_AT',
  229. 'orderBy' => 'CREATED_AT DESC',
  230. ]);
  231. }else if ($walletType == 'exchange') {
  232. $dealLists = FlowExchangePoints::find()->groupBy('DEAL_TYPE_ID')->select('DEAL_TYPE_ID')->where('USER_ID=:USER_ID',[':USER_ID'=>\Yii::$app->user->id])->asArray()->all();
  233. $data = FlowExchangePoints::lists($condition, $params, [
  234. 'useSlaves' => true,
  235. 'select' => 'AMOUNT,TOTAL,IS_INCR,REMARK,REMARK_IS_SHOW,PERIOD_NUM,CALC_MONTH,CREATED_AT,DEAL_TYPE_ID,DEAL_TYPE_IS_PRESET',
  236. 'orderBy' => 'CREATED_AT DESC',
  237. ]);
  238. }
  239. if($data) {
  240. if($walletType != 'cash') {
  241. foreach ($data['list'] as $key => $value) {
  242. if ($value['DEAL_TYPE_IS_PRESET'] == 0) {
  243. $data['list'][$key]['DEAL_TYPE_NAME'] = $value['AMOUNT'] > 0 ? '增加' : '减少';
  244. } else {
  245. $data['list'][$key]['DEAL_TYPE_NAME'] = DealType::getAllTypesForShow()[$value['DEAL_TYPE_ID']]['TYPE_NAME'] ?? '';
  246. }
  247. if ($value['REMARK_IS_SHOW'] == 0) $data['list'][$key]['REMARK'] = '';
  248. $data['list'][$key]['REMARK'] = str_replace("车房养老奖", "福利积分一", $data['list'][$key]['REMARK']);
  249. $data['list'][$key]['REMARK'] = str_replace("领袖分红奖", "福利积分二", $data['list'][$key]['REMARK']);
  250. $data['list'][$key]['REMARK'] = str_replace("车房养老", "福利积分一", $data['list'][$key]['REMARK']);
  251. $data['list'][$key]['REMARK'] = str_replace("领袖分红", "福利积分二", $data['list'][$key]['REMARK']);
  252. }
  253. }
  254. }
  255. if($dealLists){
  256. foreach ($dealLists as $key=>$value){
  257. if(!$value['DEAL_TYPE_ID']) continue;
  258. $dealType = DealType::getAllTypesForShow()[$value['DEAL_TYPE_ID']];
  259. if($dealType['IS_PRESET']==0){
  260. $dealTypes['1'] = '增加';
  261. $dealTypes['2'] = '扣除';
  262. }else{
  263. $dealLists[$key]['DEAL_TYPE_NAME'] = $dealType['TYPE_NAME']??'';
  264. $dealTypes[$value['DEAL_TYPE_ID']] = $dealLists[$key]['DEAL_TYPE_NAME'];
  265. }
  266. }
  267. }
  268. $data['dealTypes'] = $dealTypes;
  269. unset($dealTypes);
  270. return static::notice($data);
  271. }
  272. /**
  273. * 最新奖金
  274. * @return mixed
  275. * @throws \yii\db\Exception
  276. * @throws \yii\web\HttpException
  277. */
  278. public function actionNew(){
  279. if(!$periodNum = \Yii::$app->request->get('periodNum')) {
  280. $periodNum = Period::sentMaxPeriodNum();
  281. }
  282. //是否近期期数
  283. $showFlowPeriodNum = Cache::getSystemConfig()['showFlowPeriodNum']['VALUE'];
  284. $periodArr = Period::getNearlySendPeriodNum($showFlowPeriodNum);
  285. if(!in_array($periodNum,$periodArr)) return static::notice('该期不能查看',400);
  286. //增加明细开关控制(0 只显示总奖金 1 全部显示)
  287. $flowBonusSwitch = Cache::getSystemConfig()['flowBonusSwitch']['VALUE'];
  288. $data = $this->_periodBonus($periodNum,$flowBonusSwitch);
  289. if(!$data) return static::notice('当期无奖金记录',400);
  290. return static::notice($data);
  291. }
  292. /**
  293. * 期数对应的奖金
  294. * @param $periodNum
  295. * @param $detailSwitch
  296. * @return array
  297. * @throws \yii\db\Exception
  298. */
  299. private function _periodBonus($periodNum,$detailSwitch=1) {
  300. $period = Period::instance();
  301. $yearMonth = $period->getYearMonth($periodNum);
  302. if(!$calcBonus = CalcBonus::find()->yearMonth($yearMonth)->where('USER_ID=:USER_ID AND PERIOD_NUM=:PERIOD_NUM',[':USER_ID'=>\Yii::$app->user->id,':PERIOD_NUM'=>$periodNum])->asArray()->one()){
  303. return [
  304. ];
  305. }
  306. $sysConfig = Cache::getSystemConfig();
  307. if($detailSwitch) {
  308. $data[] = ['name' => '期数', 'value' => $periodNum];
  309. $data[] = ['name' => '级别', 'value' => Cache::getDecLevelConfig()[$calcBonus['LAST_DEC_LV']]['LEVEL_NAME']];
  310. $data[] = ['name' => '荣誉', 'value' => Cache::getEmpLevelConfig()[$calcBonus['LAST_EMP_LV']]['LEVEL_NAME']];
  311. if ($sysConfig['openTG']['VALUE']) {
  312. // 销售奖金 就是 原来的推广奖
  313. $data[] = ['name' => '销售奖金', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_TG'])];
  314. }
  315. if ($sysConfig['openQY']['VALUE']) {
  316. // 业绩奖金 就是原来的团队奖 并将业绩奖金改成绩效奖金
  317. // $data[] = ['name' => '团队奖', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_QY'])];
  318. $data[] = ['name' => '绩效奖金', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_QY'])];
  319. }
  320. // 管理奖金 就是新的蓝星奖
  321. $data[] = ['name' => '管理奖金', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_BS'])];
  322. if ($sysConfig['openGX']['VALUE']) {
  323. $data[] = ['name' => '共享奖金', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_GX'])];
  324. }
  325. if ($sysConfig['openFW']['VALUE']) {
  326. $data[] = ['name' => '服务奖金', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_BD'])];
  327. }
  328. $data[] = ['name' => '总奖金', 'value' => Tool::formatPrice($calcBonus['BONUS_TOTAL'])];
  329. $data[] = ['name' => '管理费', 'value' => Tool::formatPrice($calcBonus['MANAGE_TAX'])];
  330. $data[] = ['name' => '实发奖金', 'value' => Tool::formatPrice($calcBonus['BONUS_REAL'])];
  331. $data[] = ['name' => '复消积分', 'value' => Tool::formatPrice($calcBonus['RECONSUME_POINTS'])];
  332. $data[] = ['name' => '兑换积分', 'value' => Tool::formatPrice($calcBonus['EXCHANGE_POINTS'])];
  333. $data[] = ['name' => '一市场新增业绩', 'value' => Tool::formatFrontPerf($calcBonus['PV_1L'])];
  334. $data[] = ['name' => '二市场新增业绩', 'value' => Tool::formatFrontPerf($calcBonus['PV_2L'])];
  335. $data[] = ['name' => '三市场新增业绩', 'value' => Tool::formatFrontPerf($calcBonus['PV_3L'])];
  336. $data[] = ['name' => '一市场结余业绩', 'value' => Tool::formatFrontPerf($calcBonus['SURPLUS_1L'])];
  337. $data[] = ['name' => '二市场结余业绩', 'value' => Tool::formatFrontPerf($calcBonus['SURPLUS_2L'])];
  338. $data[] = ['name' => '三市场结余业绩', 'value' => Tool::formatFrontPerf($calcBonus['SURPLUS_3L'])];
  339. // if ($sysConfig['openYC']['VALUE']) {
  340. // $data[] = ['name' => '荣衔奖', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_YC'])];
  341. // }
  342. // if ($sysConfig['openVIP']['VALUE']) {
  343. // $data[] = ['name' => 'VIP奖', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_VIP'])];
  344. // }
  345. // if ($sysConfig['openXF']['VALUE']) {
  346. // $data[] = ['name' => '消费奖', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_XF'])];
  347. // }
  348. // if ($sysConfig['openYJ']['VALUE']) {
  349. // $data[] = ['name' => '业绩奖', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_YJ'])];
  350. // }
  351. // if ($sysConfig['openGL']['VALUE']) {
  352. // $data[] = ['name' => '管理奖', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_GL'])];
  353. // }
  354. // if ($sysConfig['openJXS']['VALUE']) {
  355. // $data[] = ['name' => '团队成长奖', 'value' => Tool::formatPrice($calcBonus['ORI_BONUS_STANDARD'])];
  356. // }
  357. // if($sysConfig['openLS']['VALUE']) {
  358. // $data[] = ['name' => '零售奖', 'value' => Tool::formatPrice($calcBonus['BONUS_LS'])];
  359. // }
  360. // $data[]=['name'=>'责任业绩扣除','value'=>Tool::formatPrice($calcBonus['DEDUCT_ZR'])];
  361. // $data[]=['name'=>'总奖金','value'=>Tool::formatPrice($calcBonus['BONUS_TOTAL'])];
  362. // if($sysConfig['openLX']['VALUE']) {
  363. // $data[] = ['name' => '福利积分二', 'value' => Tool::formatPrice($calcBonus['BONUS_LX'])];
  364. // }
  365. // $data[]=['name'=>'四市场新增业绩','value'=>Tool::formatFrontPerf($calcBonus['PV_4L'])];
  366. // $data[]=['name'=>'五市场新增业绩','value'=>Tool::formatFrontPerf($calcBonus['PV_5L'])];
  367. // $data[]=['name'=>'虚拟市场新增业绩','value'=>Tool::formatFrontPerf($calcBonus['PV_LS_TOUCH'])];
  368. //查看剩余区域是哪个区
  369. // $surplusArr=[$calcBonus['SURPLUS_1L'],$calcBonus['SURPLUS_2L'],$calcBonus['SURPLUS_3L']];
  370. // $bigLocation = array_search(max($surplusArr), $surplusArr);
  371. // $bigLocationName = ['一市场','二市场','三市场'][$bigLocation];
  372. // $data[]=['name'=>'剩余业绩市场','value'=>$bigLocationName];
  373. // $data[]=['name'=>'剩余业绩','value'=>Tool::formatFrontPerf($surplusArr[$bigLocation])];
  374. }else{
  375. $data[] = ['name' => '总奖金', 'value' => Tool::formatPrice($calcBonus['BONUS_TOTAL'])];
  376. }
  377. return $data;
  378. }
  379. /**
  380. * 往期奖金
  381. * @return mixed
  382. * @throws \yii\web\HttpException
  383. */
  384. public function actionOther(){
  385. //获取可以查看几期奖金
  386. $showBonusPeriodNum = Cache::getSystemConfig()['showBonusPeriodNum']['VALUE'];
  387. $calcBonus = CalcBonus::find()->where('USER_ID=:USER_ID AND IS_SENT=1', [':USER_ID' => \Yii::$app->user->id])
  388. ->select('PERIOD_NUM,ORI_BONUS_QY,ORI_BONUS_YC,ORI_BONUS_VIP,ORI_BONUS_STANDARD,ORI_BONUS_BD,ORI_BONUS_TG,
  389. ORI_BONUS_XF,BONUS_TOTAL,MANAGE_TAX,BONUS_REAL,BONUS_INCOME,ORI_BONUS_YJ,ORI_BONUS_GX,ORI_BONUS_GL,RECONSUME_POINTS,
  390. LAST_DEC_LV,LAST_EMP_LV,EXCHANGE_POINTS,ORI_BONUS_BS')
  391. ->limit($showBonusPeriodNum)
  392. ->orderBy('PERIOD_NUM DESC')
  393. ->asArray()
  394. ->all();
  395. $sysConfig = Cache::getSystemConfig();
  396. //增加明细开关控制(0 只显示总奖金 1 全部显示)
  397. $flowBonusSwitch = Cache::getSystemConfig()['flowBonusSwitch']['VALUE'];
  398. foreach ($calcBonus as $key => $data) {
  399. if($flowBonusSwitch) {
  400. $calcBonus[$key]['PERIOD_NUM'] = ['name' => '期数', 'value' => $calcBonus[$key]['PERIOD_NUM']];
  401. $calcBonus[$key]['LAST_DEC_NAME'] = ['name' => '级别', 'value' => Cache::getDecLevelConfig()[$calcBonus[$key]['LAST_DEC_LV']]['LEVEL_NAME']];
  402. $calcBonus[$key]['LAST_EMP_NAME'] = ['name' => '聘级', 'value' => Cache::getEmpLevelConfig()[$calcBonus[$key]['LAST_EMP_LV']]['LEVEL_NAME']];
  403. // 销售奖金,就是原来的推广奖金
  404. if ($sysConfig['openTG']['VALUE']) {
  405. $calcBonus[$key]['BONUS_TG'] = ['name' => '销售奖金', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_TG'])];
  406. }
  407. // 业绩奖金,就是原来的团队奖 并将业绩奖金改成绩效奖金
  408. if ($sysConfig['openQY']['VALUE']) {
  409. $calcBonus[$key]['BONUS_QY'] = ['name' => '绩效奖金', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_QY'])];
  410. }
  411. // 管理奖金 就是新的蓝星奖金
  412. $calcBonus[$key]['BONUS_BS'] = ['name' => '管理奖金', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_BS'])];
  413. //共享奖
  414. if ($sysConfig['openGX']['VALUE']) {
  415. $calcBonus[$key]['BONUS_GX'] = ['name' => '共享奖金', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_GX'])];
  416. }
  417. //服务奖
  418. if ($sysConfig['openFW']['VALUE']) {
  419. $calcBonus[$key]['BONUS_BD'] = ['name' => '服务奖金', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_BD'])];
  420. }
  421. // 总奖金
  422. $calcBonus[$key]['BONUS_TOTAL'] = ['name' => '总奖金', 'value' => Tool::formatPrice($calcBonus[$key]['BONUS_TOTAL'])];
  423. $calcBonus[$key]['RECONSUME_POINTS'] = ['name' => '复销积分', 'value' => Tool::formatPrice($calcBonus[$key]['RECONSUME_POINTS'])];
  424. $calcBonus[$key]['EXCHANGE_POINTS'] = ['name' => '兑换积分', 'value' => Tool::formatPrice($calcBonus[$key]['EXCHANGE_POINTS'])];
  425. $calcBonus[$key]['MANAGE_TAX'] = ['name' => '管理费', 'value' => Tool::formatPrice($calcBonus[$key]['MANAGE_TAX'])];
  426. $calcBonus[$key]['BONUS_REAL'] = ['name' => '实发奖金', 'value' => Tool::formatPrice($calcBonus[$key]['BONUS_REAL'])];
  427. // if ($sysConfig['openYC']['VALUE']) {
  428. // $calcBonus[$key]['BONUS_YC'] = ['name' => '荣衔奖', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_YC'])];
  429. // }
  430. // if ($sysConfig['openVIP']['VALUE']) {
  431. // $calcBonus[$key]['BONUS_VIP'] = ['name' => 'VIP奖', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_VIP'])];
  432. // }
  433. // if ($sysConfig['openXF']['VALUE']) {
  434. // $calcBonus[$key]['BONUS_XF'] = ['name' => '消费奖', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_XF'])];
  435. // }
  436. // if ($sysConfig['openYJ']['VALUE']) {
  437. // $calcBonus[$key]['BONUS_YJ'] = ['name' => '业绩奖', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_YJ'])];
  438. // }
  439. // if ($sysConfig['openGL']['VALUE']) {
  440. // $calcBonus[$key]['BONUS_GL'] = ['name' => '管理奖', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_GL'])];
  441. // }
  442. // if ($sysConfig['openJXS']['VALUE']) {
  443. // $calcBonus[$key]['BONUS_STANDARD'] = ['name' => '团队成长奖', 'value' => Tool::formatPrice($calcBonus[$key]['ORI_BONUS_STANDARD'])];
  444. // }
  445. }else{
  446. $calcBonus[$key]['BONUS_TOTAL'] = ['name' => '总奖金', 'value' => Tool::formatPrice($calcBonus[$key]['BONUS_TOTAL'])];
  447. }
  448. }
  449. if($flowBonusSwitch) {
  450. $tableKey[] = 'PERIOD_NUM';
  451. if ($sysConfig['openTG']['VALUE']) {
  452. $tableKey[] = 'BONUS_TG';
  453. }
  454. if ($sysConfig['openQY']['VALUE']) {
  455. $tableKey[] = 'BONUS_QY';
  456. }
  457. $tableKey[] = 'BONUS_BS';
  458. if ($sysConfig['openGX']['VALUE']) {
  459. $tableKey[] = 'BONUS_GX';
  460. }
  461. // if ($sysConfig['openYC']['VALUE']) {
  462. // $tableKey[] = 'BONUS_YC';
  463. // }
  464. // if ($sysConfig['openVIP']['VALUE']) {
  465. // $tableKey[] = 'BONUS_VIP';
  466. // }
  467. if ($sysConfig['openFW']['VALUE']) {
  468. $tableKey[] = 'BONUS_BD';
  469. }
  470. // if ($sysConfig['openXF']['VALUE']) {
  471. // $tableKey[] = 'BONUS_XF';
  472. // }
  473. // if ($sysConfig['openYJ']['VALUE']) {
  474. // $tableKey[] = 'BONUS_YJ';
  475. // }
  476. // if ($sysConfig['openGL']['VALUE']) {
  477. // $tableKey[] = 'BONUS_GL';
  478. // }
  479. // if ($sysConfig['openJXS']['VALUE']) {
  480. // $tableKey[] = 'BONUS_STANDARD';
  481. // }
  482. $tableKey[] = 'BONUS_TOTAL';
  483. $tableKey[] = 'RECONSUME_POINTS';
  484. $tableKey[] = 'EXCHANGE_POINTS';
  485. $tableKey[] = 'MANAGE_TAX';
  486. $tableKey[] = 'BONUS_REAL';
  487. }else{
  488. $tableKey[] = 'BONUS_TOTAL';
  489. }
  490. return static::notice(['tableData' => $calcBonus, 'tableKey' => $tableKey]);
  491. }
  492. /**
  493. * 实时业绩
  494. * @return mixed
  495. * @throws \yii\web\HttpException
  496. */
  497. public function actionRealTimePerf() {
  498. $userId = \Yii::$app->user->id;
  499. $period = Period::instance();
  500. $newPerf = Perf::getPeriodNewPerf($userId);
  501. $weekData = [['PV_1L' => Tool::formatFrontPerf($newPerf['PV_1L']), 'PV_2L' => Tool::formatFrontPerf($newPerf['PV_2L']), 'PV_3L' => Tool::formatFrontPerf($newPerf['PV_3L'])]];
  502. $monthPerf = Perf::getMonthPerf($userId);
  503. $monthData = [['PV_1L' => Tool::formatFrontPerf($monthPerf['PV_1L']), 'PV_2L' => Tool::formatFrontPerf($monthPerf['PV_2L']), 'PV_3L' => Tool::formatFrontPerf($monthPerf['PV_3L'])]];
  504. $lastMonth = PerfMonth::getMonthPerf($period->getLastMonth()['yearMonth'], $userId);
  505. $lastData = [['PV_1L' => Tool::formatFrontPerf($lastMonth['PV_1L_TOTAL']), 'PV_2L' => Tool::formatFrontPerf($lastMonth['PV_2L_TOTAL']), 'PV_3L' => Tool::formatFrontPerf($lastMonth['PV_3L_TOTAL'])]];
  506. //是否合格
  507. // $lastChkStatus = '';
  508. // $lastMonthPerfChk = Cache::getSystemConfig()['lastMonthPerfChk']['VALUE'];
  509. // $lastArr = [$lastMonth['PV_1L_TOTAL'], $lastMonth['PV_2L_TOTAL'], $lastMonth['PV_3L_TOTAL'], $lastMonth['PV_4L_TOTAL'], $lastMonth['PV_5L_TOTAL']];
  510. // if (array_sum($lastArr) >= $lastMonthPerfChk) {
  511. // $lastChkStatus = '已合格';
  512. // }
  513. //判断大区
  514. // $bigLocation = array_search(max($lastArr), $lastArr) + 1;
  515. return static::notice(['weekData' => $weekData, 'monthData' => $monthData, 'lastData' => $lastData]);
  516. }
  517. /**
  518. * 近十期已挂网的期数
  519. * @return mixed
  520. * @throws \yii\web\HttpException
  521. */
  522. public function actionDecPeriod() {
  523. $showDecPeriodNum = Cache::getSystemConfig()['showDecPeriodNum']['VALUE'];
  524. $data = Period::find()->where('IS_SENT=:IS_SENT',[':IS_SENT' => Period::SEND_FINISH])->select('PERIOD_NUM,END_TIME')->limit($showDecPeriodNum)->orderBy('PERIOD_NUM DESC')->asArray()->all();
  525. return static::notice($data);
  526. }
  527. /**
  528. * 报单中心补助明细
  529. * @return mixed
  530. * @throws \yii\web\HttpException
  531. */
  532. public function actionFlowBt() {
  533. $periodNum = \Yii::$app->request->get('periodNum');
  534. $condition = '';
  535. $params = [];
  536. if (!$periodNum) {
  537. return static::notice('请选择期数',400);
  538. }
  539. if ($periodNum) {
  540. $showDecPeriodNum = Cache::getSystemConfig()['showDecPeriodNum']['VALUE'];
  541. $periodNums = Period::find()->where('IS_SENT=:IS_SENT',[':IS_SENT' => Period::SEND_FINISH])->select('PERIOD_NUM')->limit($showDecPeriodNum)->orderBy('PERIOD_NUM DESC')->asArray()->all();
  542. if(!in_array($periodNum,array_column($periodNums,'PERIOD_NUM'))){
  543. return static::notice('该期无法查看',400);
  544. }
  545. $condition .= ' AND PERIOD_NUM=:PERIOD_NUM';
  546. $params[':PERIOD_NUM'] = $periodNum;
  547. }
  548. $condition .= ' AND USER_ID=:USER_ID';
  549. $params[':USER_ID'] = \Yii::$app->user->id;
  550. $data = CalcBonusBT::lists($condition, $params, [
  551. 'select' => 'BT_TYPE,FROM_ORDER_SN,ORDER_TIME,PAY_PV,DELIVERY_AT,TRANSFER_AMOUNT,TRANSFER_AT,AMOUNT',
  552. 'from' => CalcBonusBT::tableName(),
  553. 'orderBy' => 'CREATED_AT DESC',
  554. ]);
  555. if ($data['list']) {
  556. foreach ($data['list'] as $key => $value) {
  557. $data['list'][$key]['BT_TYPE_NAME'] = CalcBonusBT::TYPE_NAME[$value['BT_TYPE']];
  558. foreach ($value as $k=>$item){
  559. if($item==0) $data['list'][$key][$k] ='';
  560. }
  561. }
  562. }
  563. return static::notice($data);
  564. }
  565. /**
  566. * 报单中心货补追溯
  567. * @return mixed
  568. * @throws \yii\web\HttpException
  569. */
  570. public function actionTraceFl() {
  571. $periodNum = \Yii::$app->request->get('periodNum');
  572. $condition = '';
  573. $params = [];
  574. if (!$periodNum) {
  575. return static::notice('请选择期数',400);
  576. }
  577. if ($periodNum) {
  578. $showDecPeriodNum = Cache::getSystemConfig()['showDecPeriodNum']['VALUE'];
  579. $periodNums = Period::find()->where('IS_SENT=:IS_SENT',[':IS_SENT' => Period::SEND_FINISH])->select('PERIOD_NUM')->limit($showDecPeriodNum)->orderBy('PERIOD_NUM DESC')->asArray()->all();
  580. if(!in_array($periodNum,array_column($periodNums,'PERIOD_NUM'))){
  581. return static::notice('该期无法查看',400);
  582. }
  583. $condition .= ' AND PERIOD_NUM=:PERIOD_NUM';
  584. $params[':PERIOD_NUM'] = $periodNum;
  585. }
  586. $condition .= ' AND USER_ID=:USER_ID';
  587. $params[':USER_ID'] = \Yii::$app->user->id;
  588. $data = CalcBonusFL::lists($condition, $params, [
  589. 'select' => 'DEC_SN,DEC_AT,DEC_PV,AMOUNT',
  590. 'from' => CalcBonusFL::tableName(),
  591. 'orderBy' => 'CREATED_AT DESC',
  592. ]);
  593. return static::notice($data);
  594. }
  595. /**
  596. * 查看所传期数的各项奖金
  597. * @return mixed
  598. * @throws \yii\db\Exception
  599. * @throws \yii\web\HttpException
  600. */
  601. public function actionBonusDetail() {
  602. $periodNum = \Yii::$app->request->get('periodNum');
  603. $period = Period::instance();
  604. $periodInfo = $period->setPeriodNum($periodNum);
  605. $yearMonth = $period->getYearMonth($periodNum);
  606. if (!$period->isSent($periodNum)) {
  607. return static::notice('该期不能查看',400);
  608. }
  609. $data = CalcBonus::findUseSlaves()->yearMonth($yearMonth)->select('BONUS_QY,BONUS_YC,BONUS_FX,BONUS_LS,BONUS_CF,BONUS_LX,BONUS_FL')->where('PERIOD_NUM=:PERIOD_NUM AND USER_ID=:USER_ID', [':PERIOD_NUM' => $periodNum, ':USER_ID' => \Yii::$app->user->id])->asArray()->one();
  610. return static::notice(['period' => $periodInfo, 'bonus' => $data]);
  611. }
  612. /**
  613. * 奖金流水
  614. * @return mixed
  615. * @throws \yii\web\HttpException
  616. */
  617. public function actionFlowBonus() {
  618. $yearMonth = \Yii::$app->request->get('yearMonth');
  619. if ($yearMonth) {
  620. if (!Date::isYearMonth($yearMonth)) {
  621. return static::notice('无效参数', 400);
  622. }
  623. } else {
  624. $period = Period::instance();
  625. $yearMonth = $period->getNowYearMonth();
  626. }
  627. $data = FlowBonus::lists(' AND USER_ID=:USER_ID', [':USER_ID' => \Yii::$app->user->id], [
  628. 'useSlaves' => true,
  629. 'select' => 'AMOUNT,TOTAL,IS_INCR,REMARK,REMARK_IS_SHOW,PERIOD_NUM,CALC_MONTH,CREATED_AT',
  630. 'yearMonth' => $yearMonth,
  631. 'orderBy' => 'CREATED_AT DESC',
  632. ]);
  633. foreach ($data['list'] as $key => $value) {
  634. if($value['REMARK_IS_SHOW']==0) $data['list'][$key]['REMARK'] = '';
  635. }
  636. return static::notice($data);
  637. }
  638. /**
  639. * 提现列表
  640. * @return mixed
  641. * @throws \yii\base\Exception
  642. * @throws \yii\web\HttpException
  643. */
  644. public function actionWithdraw() {
  645. $yearMonth = \Yii::$app->request->get('yearMonth');
  646. if ($yearMonth) {
  647. if (!Date::isYearMonth($yearMonth)) {
  648. return static::notice('无效参数', 400);
  649. }
  650. } else {
  651. $period = Period::instance();
  652. $yearMonth = $period->getNowYearMonth();
  653. }
  654. $data = Withdraw::lists('AND W.USER_ID=:USER_ID', [':USER_ID' => \Yii::$app->user->id], [
  655. 'useSlaves' => true,
  656. 'select' => 'W.ID,W.USER_ID,W.IS_AUTO_WITHDRAW,W.AMOUNT,W.AUDIT_STATUS,W.CREATED_AT,W.PAID_AT,W.PAY_TYPE,W.PAID_FAIL_REMARK,W.INVOICE_ID,IA.AMOUNT INVOICE_AMOUNT,IA.AUDIT_STATUS INVOICE_AUDIT_STATUS,IA.UPLOAD_ID',
  657. 'from' => Withdraw::tableName() . ' AS W',
  658. 'join' => [
  659. ['LEFT JOIN', InvoiceAudit::tableName() . ' AS IA', 'W.ID=IA.WITHDRAW_ID'],
  660. ],
  661. 'yearMonth' => $yearMonth,
  662. 'orderBy' => 'W.CREATED_AT DESC',
  663. //'with' => 'openBank',
  664. ]);
  665. $auditStatus = array_column(\Yii::$app->params['auditStatus'], null, 'value');
  666. foreach ($data['list'] as $key => $value) {
  667. $baseInfo = Info::baseInfo($value['USER_ID']);
  668. $data['list'][$key]['USER_NAME'] = $baseInfo['USER_NAME'];
  669. $data['list'][$key]['REAL_NAME'] = $baseInfo['REAL_NAME'];
  670. $data['list'][$key]['STATUS_NAME'] = Withdraw::STATUS_NAME[$value['AUDIT_STATUS']];
  671. $data['list'][$key]['INVOICE_STATUS_NAME'] = isset($value['INVOICE_AUDIT_STATUS'])?$auditStatus[$value['INVOICE_AUDIT_STATUS']]['label']:'未传发票';
  672. }
  673. return static::notice($data);
  674. }
  675. /**
  676. * 提交提现申请
  677. * @return mixed
  678. * @throws \yii\db\Exception
  679. * @throws \yii\web\HttpException
  680. */
  681. public function actionWithdrawAdd() {
  682. if (\Yii::$app->request->isPost) {
  683. $formModel = new WithdrawForm();
  684. $formModel->scenario = 'addByUser';
  685. if ($formModel->load(\Yii::$app->request->post(), '') && $formModel->add()) {
  686. return static::notice('提现申请已提交,请等待审核');
  687. } else {
  688. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  689. }
  690. } else {
  691. return static::notice('非法请求', 400);
  692. }
  693. }
  694. /**
  695. * 提现退回
  696. * @return mixed
  697. * @throws \yii\db\Exception
  698. * @throws \yii\web\HttpException
  699. */
  700. public function actionWithdrawBack() {
  701. if (\Yii::$app->request->isPost) {
  702. $formModel = new WithdrawForm();
  703. $formModel->scenario = 'backByUser';
  704. if ($formModel->load(\Yii::$app->request->post(), '') && $formModel->backByUser()) {
  705. return static::notice('提现已退回');
  706. } else {
  707. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  708. }
  709. } else {
  710. return static::notice('非法请求', 400);
  711. }
  712. }
  713. /**
  714. * 判断并获取提现的会员信息
  715. * @return mixed
  716. * @throws \yii\web\HttpException
  717. */
  718. public function actionChkWithdrawUser() {
  719. $uid = \Yii::$app->user->id;
  720. if (!Info::isVerified($uid)) {
  721. return static::notice('未实名验证无法提现', 400);
  722. }
  723. $userInfo = UserInfo::findOneAsArray('USER_ID=:USER_ID', [':USER_ID' => $uid], 'IS_BIND,IS_BIND_MAIN,IS_AUTO_WITHDRAW,REG_TYPE,TRANSFER_PROP');
  724. if ($userInfo['IS_BIND'] == 1 && $userInfo['IS_BIND_MAIN'] == 0) {
  725. return static::notice('附属会员无法提现', 400);
  726. }
  727. if ($userInfo['IS_AUTO_WITHDRAW'] == 1) {
  728. return static::notice('已开启自动提现,如需手动提现请关闭自动提现', 400);
  729. }
  730. if (!Withdraw::allowWithdraw()) {
  731. return static::notice('未到提现日期,请在每月挂网后第一周申请提现', 400);
  732. }
  733. if (Withdraw::hasThisMonthWithdraw($uid)) {
  734. return static::notice('提现失败,每月只可以提现一次', 400);
  735. }
  736. if (Withdraw::existWaitAudit($uid)) {
  737. return static::notice('提现失败,您存在未审核的提现记录', 400);
  738. }
  739. //是否显示服务协议
  740. $regType = RegType::findOneAsArray('ID=:ID', [':ID' => $userInfo['REG_TYPE']], 'IS_PACT');
  741. $path = \Yii::getAlias('@common/runtime/datas/pact.php');
  742. if (!file_exists($path)) {
  743. $oneData = '';
  744. } else {
  745. $oneData = include $path;
  746. }
  747. $isCanTransferProp = Cache::getSystemConfig()['isCanTransferProp']['VALUE'];
  748. if ($isCanTransferProp == 0) {
  749. $userInfo['WITHDRAW_PROP'] = 100;
  750. } else {
  751. $userInfo['WITHDRAW_PROP'] = 100 - $userInfo['TRANSFER_PROP'];
  752. }
  753. return static::notice(['userInfo' => $userInfo, 'isPact' => $regType['IS_PACT'], 'content' => $oneData['CONTENT']]);
  754. }
  755. /**
  756. * 归集附属会员奖金
  757. * @return mixed
  758. * @throws \yii\db\Exception
  759. * @throws \yii\web\HttpException
  760. */
  761. public function actionCollectBind() {
  762. $transferBonusForm = new TransferBonusForm();
  763. if ($totals=$transferBonusForm->collectBind(\Yii::$app->user->id)) {
  764. return static::notice('归集完成,归集金额'.$totals);
  765. } else {
  766. if($totals==0){
  767. return static::notice('归集完成,归集金额'.$totals);
  768. }else{
  769. return static::notice(Form::formatErrorsForApi($transferBonusForm->getErrors()), 400);
  770. }
  771. }
  772. }
  773. /**
  774. * 上传发票之前
  775. * @return mixed
  776. * @throws \yii\web\HttpException
  777. */
  778. public function actionInvoiceBeforeAdd() {
  779. $id = \Yii::$app->request->get('id');
  780. $withdraw = Withdraw::findOneAsArray('ID=:ID', [':ID' => $id]);
  781. if (!$withdraw) {
  782. return static::notice('数据不存在', 400);
  783. }
  784. $uploadInvoiceTip = Cache::getSystemConfig()['uploadInvoiceTip']['VALUE'];
  785. if ($withdraw['AUDIT_STATUS'] == Withdraw::STATUS_APPLIED) {
  786. return static::notice(['addInvoiceTips' => $uploadInvoiceTip]);
  787. } else {
  788. return static::notice('该提现记录无法上传发票', 400);
  789. }
  790. }
  791. /**
  792. * 上传发票
  793. * @return mixed
  794. * @throws \yii\db\Exception
  795. * @throws \yii\web\HttpException
  796. */
  797. public function actionInvoiceAdd() {
  798. $id = \Yii::$app->request->get('id');
  799. $withdraw = Withdraw::findOneAsArray('ID=:ID', [':ID' => $id]);
  800. if (!$withdraw) {
  801. return static::notice('数据不存在', 400);
  802. }
  803. if (\Yii::$app->request->isPost) {
  804. $formModel = new UploadForm();
  805. $formModel->scenario = 'invoiceFront';
  806. $formModel->file = UploadedFile::getInstanceByName('file');
  807. $formModel->withdrawId = $withdraw['ID'];
  808. $formModel->remark = '提现'.$withdraw['SN'].'发票';
  809. //$formModel->token = \Yii::$app->request->post('uploadToken');
  810. $formModel->token = \Yii::$app->request->request('uploadToken');
  811. if ($formModel->file && $formModel->upload()) {
  812. return static::notice('上传成功');
  813. } else {
  814. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  815. }
  816. }
  817. }
  818. /**
  819. * 显示上传的发票
  820. * @return mixed
  821. * @throws \yii\web\HttpException
  822. */
  823. public function actionInvoiceShow() {
  824. $id = \Yii::$app->request->get('id');
  825. $uploads = Uploads::findOneAsArray('ID=:ID', [':ID' => $id],'URL');
  826. if (!$uploads) {
  827. return static::notice('数据不存在', 400);
  828. }
  829. return static::notice($uploads['URL']);
  830. }
  831. /**
  832. * 获取可用余额
  833. * @return mixed
  834. * @throws \yii\web\HttpException
  835. */
  836. public function actionAvailableBalance() {
  837. return static::notice(Balance::getAvailableBalance(\Yii::$app->user->id));
  838. }
  839. /**
  840. * 查看业绩
  841. * @return mixed
  842. * @throws \yii\web\HttpException
  843. */
  844. public function actionPerf() {
  845. $yearMonth = \Yii::$app->request->get('yearMonth');
  846. if ($yearMonth) {
  847. if (!Date::isYearMonth($yearMonth)) {
  848. return static::notice('无效参数', 400);
  849. }
  850. } else {
  851. $period = Period::instance();
  852. $yearMonth = $period->getNowYearMonth();
  853. }
  854. $data = PerfPeriod::lists('AND P.USER_ID=:USER_ID AND PN.IS_SENT=1', [':USER_ID' => \Yii::$app->user->id], [
  855. 'select' => 'P.*',
  856. 'yearMonth' => $yearMonth,
  857. 'from' => PerfPeriod::tableName() . ' AS P',
  858. 'join' => [
  859. ['LEFT JOIN', Period::tableName() . ' AS PN', 'P.PERIOD_NUM=PN.PERIOD_NUM']
  860. ],
  861. 'orderBy' => 'P.PERIOD_NUM DESC',
  862. ]);
  863. $data['request']['yearMonth'] = $yearMonth;
  864. return static::notice($data);
  865. }
  866. /**
  867. * 转账列表
  868. * @return mixed
  869. * @throws \yii\web\HttpException
  870. */
  871. public function actionTransferList() {
  872. $type = \Yii::$app->request->get('type', 'out');
  873. if ($type == 'out') {
  874. $condition = ' AND T.FROM_UID=:USER_ID';
  875. } else {
  876. $condition = ' AND T.TO_UID=:USER_ID';
  877. }
  878. $params = [
  879. ':USER_ID' => \Yii::$app->user->id,
  880. ];
  881. $data = Transfer::lists($condition, $params, [
  882. 'select' => 'FUI.USER_NAME AS FROM_USER_NAME, TUI.USER_NAME AS TO_USER_NAME, T.AMOUNT, T.PERIOD_NUM, T.CREATED_AT',
  883. 'from' => Transfer::tableName() . ' AS T',
  884. 'join' => [
  885. ['LEFT JOIN', UserInfo::tableName() . ' AS FUI', 'FUI.USER_ID=T.FROM_UID'],
  886. ['LEFT JOIN', UserInfo::tableName() . ' AS TUI', 'TUI.USER_ID=T.TO_UID'],
  887. ],
  888. ]);
  889. return static::notice($data);
  890. }
  891. /**
  892. * 转账
  893. * @throws \yii\db\Exception
  894. * @throws \yii\web\HttpException
  895. */
  896. public function actionTransferAdd() {
  897. if (\Yii::$app->request->isPost) {
  898. $formModel = new TransferForm();
  899. if ($formModel->load(\Yii::$app->request->post(), '') && $formModel->transfer()) {
  900. return static::notice('转账成功');
  901. } else {
  902. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  903. }
  904. }
  905. }
  906. /**
  907. * 检查转账资格
  908. * @return mixed
  909. * @throws \yii\web\HttpException
  910. */
  911. public function actionChkTransferUser() {
  912. $uid = \Yii::$app->user->id;
  913. if (!Info::isVerified($uid)) {
  914. return static::notice('未实名验证无法转账', 400);
  915. }
  916. $userInfo = UserInfo::findOneAsArray('USER_ID=:USER_ID', [':USER_ID' => $uid], 'ALLOW_TRANSFER,TRANSFER_PROP');
  917. if($userInfo['ALLOW_TRANSFER']==0){
  918. return static::notice('您不允许转账', 400);
  919. }
  920. $isCanTransferProp = Cache::getSystemConfig()['isCanTransferProp']['VALUE'];
  921. if($isCanTransferProp==0){
  922. $userInfo['TRANSFER_PROP']=100;
  923. }
  924. return static::notice(['userInfo' => $userInfo]);
  925. }
  926. /**
  927. * 房产积分列表
  928. * @return mixed
  929. * @throws \yii\web\HttpException
  930. */
  931. public function actionFcPoint() {
  932. $condition = ' AND USER_ID=:USER_ID';
  933. $params = [':USER_ID' => \Yii::$app->user->id];
  934. $yearMonth = \Yii::$app->request->get('yearMonth');
  935. if ($yearMonth) {
  936. if (!Date::isYearMonth($yearMonth)) {
  937. return static::notice('无效参数', 400);
  938. }
  939. $condition .= ' AND CALC_MONTH=:CALC_MONTH';
  940. $params['CALC_MONTH'] = $yearMonth;
  941. }
  942. $data = ScoreMonth::lists($condition, $params, [
  943. 'from' => ScoreMonth::tableName(),
  944. 'orderBy' => 'ID DESC',
  945. ]);
  946. return static::notice($data);
  947. }
  948. }