request->isAjax) { if (\Yii::$app->request->isGet) { $get = \Yii::$app->request->get(); $where[] = ['mall_id' => $this->mall_id]; $where[] = ['mch_id' => $this->mch_id]; if (!empty($get['keyword'])) { $user_list = User::lists(['where' => [['mall_id' => $this->mall_id], [ 'or', ['like', 'username', trim($get['keyword'])], ['like', 'nickname', trim($get['keyword'])], ['like', 'mobile', trim($get['keyword'])] ]], 'select' => 'id']); $where[] = ['user_id' => array_column($user_list, 'id')]; } if (!empty($get['user_id'])) $where[] = ['user_id' => $get['user_id']]; if (!empty($get['order_no'])) $where[] = ['order_no' => $get['order_no']]; if (isset($get['is_settlement']) && $get['is_settlement'] != -1) $where[] = ['is_settlement' => $get['is_settlement']]; $store = Mch::findOne(['id' => $this->mch_id]); $total_expenses = $store_balance = $unsettled_amount = 0; if (!empty($store)) { $total_expenses = $store['total_expenses']; $store_balance = $store['balance'] + $store['unsettled_amount']; $unsettled_amount = $store['unsettled_amount']; } $time = time(); $where[] = ['>=', 'created_at', $time - 365 * 24 * 3600]; $list = MchStatistics::lists(['where' => $where, 'index' => 'date_time']); $month = date('m', $time); $monty_int = intval($month); $year = date('Y', $time); $chart_time_arr = []; $settle_income_arr = []; if ($monty_int < 12) { $front_year = $year - 1; for ($i = $monty_int; $i <= 12; $i++) { if ($i < 10) { $month_time = $front_year . '-0' . $i; } else { $month_time = $front_year . '-' . $i; } $settle_income_arr[] = $list[$month_time]['income_money'] ?? 0; $chart_time_arr[] = $month_time; } for ($i = 1; $i <= $monty_int; $i++) { if ($i < 10) { $month_time = $year . '-0' . $i; } else { $month_time = $year . '-' . $i; } $chart_time_arr[] = $month_time; $settle_income_arr[] = $list[$month_time]['income_money'] ?? 0; } } $order_total_arr = []; $order_total_arr['store_balance'] = ['type' => 'store_balance', 'name' => '店铺余额(元)', 'value' => $store_balance, 'prompt' => '']; $order_total_arr['unsettled_amount'] = ['type' => 'unsettled_amount', 'name' => '包含待结算店铺余额(元)', 'value' => $unsettled_amount, 'prompt' => '']; $order_total_arr['total_expenses'] = ['type' => 'total_expenses', 'name' => '已提现(元)', 'value' => $total_expenses, 'prompt' => '']; $data['order_total_arr'] = $order_total_arr; $data['chart_time_arr'] = $chart_time_arr; $data['settle_income_arr'] = $settle_income_arr; return $this->success('ok', $data); } } return $this->render($this->action->id); } /** * 收入明细 * @Author bing * @DateTime 2022-04-26 18:04:25 * @return void * @copyright: Copyright (c) 2022 广东七件事集团 */ public function actionIncomeLog() { if (\Yii::$app->request->isAjax) { if (\Yii::$app->request->isGet) { $get = \Yii::$app->request->get(); $where[] = ['mall_id' => $this->mall_id]; $where[] = ['mch_id' => $this->mch_id]; $where[] = ['status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]]; if (!empty($get['keyword'])) { $user_list = User::lists(['where' => [['mall_id' => $this->mall_id], [ 'or', ['like', 'username', trim($get['keyword'])], ['like', 'nickname', trim($get['keyword'])], ['like', 'mobile', trim($get['keyword'])] ]], 'select' => 'id']); $where[] = ['user_id' => array_column($user_list, 'id')]; } if (!empty($get['user_id'])) $where[] = ['user_id' => $get['user_id']]; if (!empty($get['order_no'])) $where[] = ['order_no' => $get['order_no']]; if (isset($get['is_settlement']) && $get['is_settlement'] !== '') $where[] = ['is_settlement' => $get['is_settlement']]; $params = [ 'where' => $where, 'order' => 'id desc', 'with' => ['user'] ]; $store = Mch::findOne(['id' => $this->mch_id]); $page_data = MchCommission::listPage($params); if ($page_data === false) return $this->error(MchCommission::getStaticError()); $total_num = $total_order_money = $total_settled_amount = $unsettled_amount = 0; if (!empty($store)) { $total_num = $store['total_num']; $total_order_money = $store['total_order_money']; $total_settled_amount = $store['total_settled_amount']; $unsettled_amount = $store['unsettled_amount']; } if (!empty($page_data['list'])) { $user_id_arr = array_column($page_data['list'], 'user_id'); $user_list = User::lists(['where' => [['id' => $user_id_arr]], 'index' => 'id']); foreach ($page_data['list'] as &$item) { $item['nickname'] = $item['mobile'] = $item['avatar_url'] = ''; if (isset($user_list[$item['user_id']])) { $item['nickname'] = $user_list[$item['user_id']]['nickname']; $item['mobile'] = $user_list[$item['user_id']]['mobile']; $item['avatar_url'] = $user_list[$item['user_id']]['avatar_url']; } if ($item['type'] == 2) { if (isset($store_cashier_order_list[$item['order_no']])) { $addons_bonus = 0; $extra = json_decode($store_cashier_order_list[$item['order_no']]['extra'], true); foreach ($extra as $k => $v) { if (in_array($k, ['agent_commission', 'distribution_commission'])) $addons_bonus += $v; } $item['addons_bonus'] = $addons_bonus; } } } } $order_total_arr = []; $order_total_arr[] = ['type' => 'total_num', 'name' => '总数', 'value' => $total_num, 'prompt' => '']; $order_total_arr[] = ['type' => 'total_order_money', 'name' => '订单总金额', 'value' => $total_order_money, 'prompt' => '']; $order_total_arr[] = ['type' => 'total_settled_amount', 'name' => '提成已结算总金额', 'value' => $total_settled_amount, 'prompt' => '']; $order_total_arr[] = ['type' => 'unsettled_amount', 'name' => '提成未结算总金额', 'value' => $unsettled_amount, 'prompt' => '']; $page_data['order_total_arr'] = $order_total_arr; return $this->success('ok', $page_data); } } return $this->render($this->action->id); } /** * 提现申请 * @Author bing * @DateTime 2022-04-26 18:04:50 * @return void * @copyright: Copyright (c) 2022 广东七件事集团 */ public function actionWithdrawal() { if (\Yii::$app->request->isAjax) { if (\Yii::$app->request->isGet) { $mch = Mch::getOne([['id' => $this->mch_id]], true, [], false, 'id,user_id,balance'); $user = User::getOne([['id' => $mch['user_id']]], true, [], false, 'id,nickname,avatar_url,mobile'); $mch_banks = MchBank::lists(['where' => [['mch_id' => $mch['id']], ['status' => StatusEnum::ENABLED]], 'id,mall_id,mch_id,username,bank,card_no']); $mch_setting = MchSettings::getOne([['mch_id' => $this->mch_id]], true, [], false, 'id,balance_cash_service_fee,is_balance_cash_service_fee'); $mch['balance_cash_service_fee'] = $this->getBalanceCashServiceFee($this->mall_id,$mch_setting);; $is_show_join_pay = 0; $payment = \Yii::$app->services->setting->mall->get($this->mall_id, 'withdraw_balance'); $balance_cash_type = []; if(!empty($payment['balance_cash_type'])) { $balance_cash_type = json_decode($payment['balance_cash_type'],true); } $join_pay_banks = []; if(MallAddons::isInstall($this->mall_id,'JoinPay')&&in_array('joinpay',$balance_cash_type)){ $is_show_join_pay = 1; $bank_card_list = JoinPayUserBankcard::lists([ 'where'=>[ ['mall_id'=>$this->mall_id], ['user_id'=>$user['id']], ['status'=>StatusEnum::ENABLED], ], 'select'=>'id,payer_name,bank_card_no,bank_name,card_id,is_sign' ]); if(!empty($bank_card_list)){ $cardIds = array_column($bank_card_list,'card_id'); $user_bank_card_list = UserBankCard::lists(['where'=>[['id'=>$cardIds]],'index'=>'id']); foreach ($bank_card_list as &$item){ $item['bank_account_type'] = 1; if(isset($user_bank_card_list[$item['card_id']])) $item['bank_account_type'] = $user_bank_card_list[$item['card_id']]['bank_account_type']; } $join_pay_banks = $bank_card_list; } } $cash_type_name = $this->getCashTypeName($mch['user_id']); sort($cash_type_name); array_unshift($cash_type_name,['name'=>'余额提现','type'=>'balance']); return $this->success('ok', ['user' => $user, 'mch' => $mch, 'store_banks' => $mch_banks, 'join_pay_banks' => $join_pay_banks, 'is_show_join_pay'=>$is_show_join_pay, 'cash_type_name'=>$cash_type_name, ]); } else { $params = \Yii::$app->request->post('form'); if (empty($params['withdrawal_type'])) return $this->error('请选择提现方式'); if (empty($params['withdrawal_money'])) return $this->error('请输入金额'); if ($params['withdrawal_money'] < 0) return $this->error('输入金额必须大于0'); $mch = Mch::getOne([['id' => $this->mch_id]], false, [], false, 'id,mall_id,user_id,balance'); $mch_setting = MchSettings::getOne([['mch_id' => $this->mch_id]], true, [], false, 'id,balance_cash_service_fee,is_balance_cash_service_fee'); if ($params['withdrawal_money'] > $mch['balance']) return $this->error('输入金额大于可提现金额'); $params['mall_id'] = $this->mall_id; $params['mch_id'] = $this->mch_id; $params['balance_cash_service_fee'] = $this->getBalanceCashServiceFee($this->mall_id,$mch_setting); if(empty($params['remark']))$params['remark'] = ''; $res = MchWithdrawLog::withdrawApply($params); if (empty($res)) return $this->error(MchWithdrawLog::getStaticError()); $res['withdrawal_type'] = $params['withdrawal_type']; return $this->success('操作成功',$res); } } return $this->render($this->action->id); } protected function getBalanceCashServiceFee($mall_id,$mch_setting){ if(!empty($mch_setting['is_balance_cash_service_fee'])){ $balance_cash_service_fee = $mch_setting['balance_cash_service_fee']??0; }else{ $basic = \Yii::$app->services->setting->addons->get($mall_id, MchEnum::ADDONS_NAME, 'basic'); if(isset($basic['balance_cash_service_fee'])){ $balance_cash_service_fee = $basic['balance_cash_service_fee']; }else{ $balance_cash_service_fee = \Yii::$app->services->setting->mall->get($mall_id, 'withdraw_balance.balance_cash_service_fee'); } } return $balance_cash_service_fee; } public function getCashTypeName($user_id){ $cash_type_name = []; $payment = \Yii::$app->services->setting->mall->get($this->mall_id, 'withdraw_balance'); if (!$payment) return $cash_type_name; $cashType = $payment['balance_cash_type']; if(!empty($cashType)) { $cash_type = Json::decode($cashType); $default_withdraw_way = WithdrawWayEnum::getDefaultWithDrawWayMap(WithdrawWayEnum::WITHDRAW_TYPE_2); $extension_withdraw_way = GlobalInvoke::exec(GlobalInvoke::INVOKE_GET_WITHDRAW_EXTENSION_WAY, $this->mall_id, ['mall_id' => $this->mall_id]); $all_withdraw = array_merge($default_withdraw_way, $extension_withdraw_way); $cash_type_keys = array_keys($all_withdraw); $get_system_setting = PlatformSetting::getConfByGroup('system', true); $bank_card_list = []; if (in_array('bank', $cash_type_keys) || in_array('joinpay', $cash_type_keys)) { $bank_card_list = UserBankCard::getUserCardList($user_id, $this->mall_id); } foreach ($cash_type as $i => $item) { if(in_array($item,['alipay_tax'])) continue; if (isset($all_withdraw[$item])) { $taxFee = 0; $name = ''; if (isset($all_withdraw[$item])) { if (is_array($all_withdraw[$item])) { $name = $all_withdraw[$item]['name'] ?? ''; $taxFee = $all_withdraw[$item]['taxFee'] ?? 0; } else { $name = $all_withdraw[$item]; } } $cash_type_name[$i]['type'] = $item; $cash_type_name[$i]['taxFee'] = $taxFee; $cash_type_name[$i]['name'] = $name; $cash_type_name[$i]['img'] = $get_system_setting['api_url']['value'] . '/resources/img/payment/' . $item . '.png'; if ('bank' == $item || 'joinpay' == $item || 'yunfast_pay' == $item) { $cash_type_name[$i]['bank_card_list'] = $bank_card_list; } } } } return $cash_type_name; } //编辑银行卡 public function actionEditStoreBank() { if (\Yii::$app->request->isPost) { $params = \Yii::$app->request->post('form'); $params['mall_id'] = $this->mall_id; $params['mch_id'] = $this->mch_id; $res = MchBank::setData($params); if ($res == false) $this->error('操作失败'); return $this->success(); } else { $params = \Yii::$app->request->get(); $store_bank_info = MchBank::getOne([['id' => $params['id']], ['mall_id' => $this->mall_id], ['mch_id' => $this->mch_id]], true); return $this->success('ok', ['store_bank_info' => $store_bank_info]); } } //删除银行卡 public function actionDelStoreBank() { $params = \Yii::$app->request->get(); $params['mall_id'] = $this->mall_id; $params['mch_id'] = $this->mch_id; $params['status'] = StatusEnum::DELETE; $res = MchBank::setData($params); if ($res == false) $this->error('操作失败'); return $this->success(); } /** * 提现日志 * @Author bing * @DateTime 2022-04-26 18:04:50 * @return void * @copyright: Copyright (c) 2022 广东七件事集团 */ public function actionWithdrawalLog() { if (\Yii::$app->request->isAjax) { if (\Yii::$app->request->isGet) { $params = \Yii::$app->request->get(); $where[] = ['mall_id' => $this->mall_id]; $where[] = ['mch_id' => $this->mch_id]; if (!empty($params['start'])) $where[] = ['>=', 'created_at', strtotime($params['start'])]; if (!empty($params['end'])) $where[] = ['<=', 'created_at', strtotime($params['end'])]; if (isset($params['withdraw_status']) && $params['withdraw_status'] !== '') $where[] = ['withdraw_status' => $params['withdraw_status']]; $params['where'] = $where; $params['order'] = 'id desc'; $page_data = MchWithdrawLog::listPage($params); if ($page_data === false) return $this->error(MchWithdrawLog::getStaticError()); if (!empty($page_data['list'])) { foreach ($page_data['list'] as &$item) { if($item['type']=='balance'){ $item['poundage_num'] = 0; } $item['extra'] = json_decode($item['extra'], true); } } return $this->success('ok', $page_data); } } } //编辑汇聚银行卡 public function actionEditStoreBankPay() { if (\Yii::$app->request->isPost) { $post = \Yii::$app->request->post('form'); $rules = [ [['bank_card_no', 'id_no', 'payer_name', 'mobile_no','bank_account_type'], 'required'], ['bank_card_no', 'string', 'max' => 64], [['id_no', 'payer_name',], 'string', 'max' => 255], [['mobile_no'], 'string', 'max' => 32], ]; $res = \Yii::$app->services->validate->validate($post, $rules); if ($res === false) return $this->error(\Yii::$app->services->validate->getErrorMessage()); $post['mall_id'] = $this->mall_id; $obj = new BankCardHelper(); $bank_info = $obj->bankInfo($post['bank_card_no']); if(empty($bank_info)) return $this->error('银行卡号有问题'); $bank_info_arr = explode('-',$bank_info); $bankShortList = json_decode($obj->getBankShortList(),true); $bank_code = ''; $bank_name = ''; foreach ($bankShortList as $k=>$v){ if(strpos($v,$bank_info_arr[0])!==false){ $bank_code = $k; $bank_name = $v; break; } } if(empty($bank_name)||empty($bank_code)) return $this->error('无法识别的银行卡号的银行简码'); $post['bank_code'] = $bank_code; $post['bank_name'] = $bank_name; $post['id_type'] = 1; switch ($bank_info_arr[2]){ case '借记卡': $card_type = 'dc'; $card_type_name = '储蓄卡'; break; case '贷记卡': $card_type = 'cc'; $card_type_name = '信用卡'; break; default: return $this->error('无法识别的银行卡号'); } $mch = Mch::findOne(['id'=>$this->mch_id,'status'=>StatusEnum::ENABLED]); if(empty($mch)) return $this->error('商户不存在'); $post['user_id'] = $mch['user_id']; $post['card_type'] = $card_type; $post['card_type_name'] = $card_type_name; $bank_card_info = UserBankCard::findOne(['mall_id'=>$this->mall_id,'bank_card_no' => $post['bank_card_no'], 'status' => StatusEnum::ENABLED]); if (!empty($bank_card_info)) { return $this->error('银行卡已经被绑定'); } $card_id = MchBank::addJoinPayBankCard($this->mall_id,$post); try { //调用汇聚接口:发送签约短信 $settings = \Yii::$app->services->setting->addons->get($this->mall_id, AddonsEnum::ADDONS_NAME_JOIN_PAY, 'basic'); $fast_pay_class = new JoinPayFastPay($settings); $fast_pay_class->sendSignSms($card_id); return $this->success('操作成功', ['card_id' => $card_id]); } catch (\Exception $e) { return $this->error($e->getMessage()); } } else { $params = \Yii::$app->request->get(); $mch_bank_info = MchBank::getOne([['id' => $params['id']], ['mall_id' => $this->mall_id], ['mch_id' => $this->mch_id]], true); return $this->success('ok', ['mch_bank_info' => $mch_bank_info],ApiStatusEnum::CODE_SUCCESS,0); } } public function actionGetSmsCode(){ try { $post = \Yii::$app->request->post(); $rules = [ [['card_id'], 'required'], [['card_id'], 'integer'], ]; $res = \Yii::$app->services->validate->validate($post, $rules); if ($res === false) return $this->error(\Yii::$app->services->validate->getErrorMessage()); $mch = Mch::findOne(['id'=>$this->mch_id,'status'=>StatusEnum::ENABLED]); if(empty($mch)) return $this->error('商户不存在'); $model = UserBankCard::findOne(['id'=>$post['card_id'],'user_id'=>$mch['user_id']]); if(empty($model)) return $this->error('用户银行卡不存在'); //调用汇聚接口:发送签约短信 $settings = \Yii::$app->services->setting->addons->get($this->mall_id, AddonsEnum::ADDONS_NAME_JOIN_PAY, 'basic'); $fast_pay_class = new JoinPayFastPay($settings); $fast_pay_class->sendSignSms($model->id); return $this->success('操作成功', ['card_id' => $model->id]); } catch (\Exception $e) { return $this->error($e->getMessage()); } } //签约 public function actionSignContract() { if (!\Yii::$app->request->isPost) { return $this->error('请求方式错误'); } $post = \Yii::$app->request->post(); $rules = [ [['card_id', 'sms_code'], 'required'], [['card_id'], 'integer'], ['sms_code', 'string'], ]; $res = \Yii::$app->services->validate->validate($post, $rules); if ($res === false) return $this->error(\Yii::$app->services->validate->getErrorMessage()); $mch = Mch::findOne(['id'=>$this->mch_id,'status'=>StatusEnum::ENABLED]); if(empty($mch)) return $this->error('商户不存在'); $post['user_id'] = $mch['user_id']; $card_info = UserBankCard::findOne([ 'mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED, 'id' => $post['card_id'], 'user_id' => $mch['user_id'], ]); if (empty($card_info)) return $this->error('银行卡不存在'); $joinpay_card_info = JoinPayUserBankcard::findOne([ 'mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED, 'card_id' => $post['card_id'], 'user_id' => $mch['user_id'], ]); if (empty($joinpay_card_info)) { return $this->error('银行卡数据异常'); } if ($joinpay_card_info->is_sign == 1) { return $this->error('银行卡已经签约'); } try { // 签约快捷支付 $settings = \Yii::$app->services->setting->addons->get($this->mall_id, AddonsEnum::ADDONS_NAME_JOIN_PAY, 'basic'); $fast_pay_class = new JoinPayFastPay($settings); $fast_pay_class->sign($post['card_id'], $post['sms_code']); $card_info = ArrayHelper::toArray($card_info); $card_info['is_sign'] = 1; $card_info['is_auth'] = true; $card_info['icon'] = UserBankCard::getBankPicture($card_info['bank_code'], 'icon'); unset($card_info['cvv'], $card_info['sign_no'], $card_info['payer_name'], $card_info['id_no']); return $this->success('签约成功', ['card_info' => $card_info], ApiStatusEnum::CODE_SUCCESS, 0); } catch (\Exception $e) { return $this->error($e->getMessage()); } } //解约 public function actionContractRelieve() { if (!\Yii::$app->request->isPost) { return $this->error('请求方式错误'); } $post = \Yii::$app->request->post(); $rules = [ [['card_id'], 'required'], [['card_id'], 'integer'], ]; $mch = Mch::findOne(['id'=>$this->mch_id,'status'=>StatusEnum::ENABLED]); if(empty($mch)) return $this->error('商户不存在'); $res = \Yii::$app->services->validate->validate($post, $rules); if ($res === false) return $this->error(\Yii::$app->services->validate->getErrorMessage()); $card_info = UserBankCard::findOne([ 'mall_id' => $this->mall_id, 'id' => $post['card_id'], 'status' => StatusEnum::ENABLED, 'user_id' => $mch['user_id'], ]); $joinpay_card_info = JoinPayUserBankcard::findOne([ 'mall_id' => $this->mall_id, 'user_id' => $mch['user_id'], 'card_id' => $post['card_id'], 'status' => StatusEnum::ENABLED, 'is_sign' => 1, ]); if (empty($card_info) || empty($joinpay_card_info)) { return $this->error('银行卡不存在或者已经解除签约'); }; try { // 解除快捷支付签约 $settings = \Yii::$app->services->setting->addons->get($this->mall_id, AddonsEnum::ADDONS_NAME_JOIN_PAY, 'basic'); $fast_pay_class = new JoinPayFastPay($settings); $fast_pay_class->unsign($joinpay_card_info); return $this->success('解约成功'); } catch (\Exception $e) { return $this->error($e->getMessage()); } } }