BonusController.php 44 KB

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