BonusController.php 45 KB

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