BonusController.php 45 KB

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