where(['mall_id' => $this->mall_id, 'user_id' => $this->user_id, 'status' => StatusEnum::ENABLED]) ->one(); if (empty($store)) { \Yii::$app->response->data = ['code' => 1, 'msg' => '您非门店身份']; \Yii::$app->response->send(); return; } $this->store_id = $store->id; return $action; } /** * 门店订单列表 * @return void */ public function actionOrderList() { $param = \Yii::$app->request->get(); $order_status_list = OrderStatusEnum::getMap(); $payment_type_list = PayTypeEnum::getMap(); $shipping_type_list = ShippingTypeEnum::getMap(); $rules = [ [['order_status'], 'in', 'range' => array_keys($order_status_list)], //[['payment_type'], 'in', 'range' => array_keys($payment_type_list)], //[['shipping_type'], 'in', 'range' => array_keys($shipping_type_list)], //[['start', 'end'], 'datetime', 'format' => 'php:Y-m-d H:i:s'], //[['order_no', 'mobile', 'order_id'], 'safe'], [['keyword','type'], 'string'], // ['mobile', 'match', 'pattern' => '/^1\d{10}$/', 'message' => '请输入正确的手机号码'], ]; $res = Yii::$app->services->validate->validate($param, $rules); if (!$res) return $this->error(Yii::$app->services->validate->getErrorMessage()); $where[] = ['mall_id' => $this->mall_id]; $where[] = ['store_id' => $this->store_id]; if (isset($param['order_status']) && $param['order_status'] != 999) { $where[] = ['order_status' => $param['order_status']]; } if (isset($param['keyword']) && $param['keyword']) { switch (trim($param['type'])){ case 'order_no': $where[] = ['order_no' => $param['keyword']]; break; case 'mobile': $where[] = ['mobile' => $param['keyword']]; break; case 'express': $express = OrderExpress::findOne(['express_no' => $param['keyword']]); if($express){ $order = Order::findOne(['id' => $express->order_id,'mall_id' => $this->mall_id,'store_id' => $this->store_id]); $order && $where[] = ['order_no' => $order->order_no]; } break; } } $where[] = ['=', 'supplier_type', 0]; $where[] = ['>=', 'status', StatusEnum::DISABLED]; $with = ['base_user', 'detail']; $order = "id desc"; $params = compact('where', 'with', 'order'); $page_data = StoreOrder::listPage($params, false, true); if ($page_data === false) return $this->error(Goods::getStaticError()); $compact_params = array_keys($page_data); extract($page_data); //订单数量:未付款,待发货,待收货 $stat = StoreOrder::find()->select('count(id) as num ,order_status')->where(['mall_id' => $this->mall_id, 'store_id' => $this->store_id ])->groupBy('order_status')->asArray()->all(); $stat = array_column($stat, 'num', 'order_status'); //$stat_tab = []; $stat_tab[] = [ 'order_status' => 999, 'num' => 0 , 'order_status_text' => '全部' ]; foreach ($order_status_list as $key => $value) { if (!in_array($key, [OrderStatusEnum::NOT_PAY, OrderStatusEnum::PAY, OrderStatusEnum::SHIPMENTS])) continue; $stat_tab[] = [ 'order_status' => $key, 'num' => $stat[$key] ?? 0, 'order_status_text' => $value ]; } return $this->success('操作成功', compact($compact_params, 'order_status_list', 'payment_type_list', 'shipping_type_list', 'export_list', 'marketing_type_map','stat_tab')); } /** * 售后订单列表 * @return void */ public function actionRefundList() { $param = Yii::$app->request->get(); $refund_status_list = RefundStatusEnum::getMap(); $refund_type_list = RefundTypeEnum::getMap(); $rules = [ [['keyword'], 'string'], [['keyword', 'refund_status'], 'safe'], ]; $res = Yii::$app->services->validate->validate($param, $rules); if ($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); $where = [['mall_id' => $this->mall_id]]; $where[] = ['=', 'store_id', $this->store_id]; $where[] = ['=', 'status', StatusEnum::ENABLED]; if (isset($param['keyword']) && $param['keyword']) { //关键词 订单号:st202212161912558027820701 if (substr($param['keyword'], 0, 2) == 'st') { //商城订单号搜索,查询对应订单id $search_order = OrderRefund::getOidByOrderNo($this->mall_id, $param['order_no']); if ($search_order) { $where[] = ['in', 'order_id', $search_order]; } } else { preg_match('/^1\d{10}$/', $param['keyword'], $match); if ($match) { $where[] = OrderRefund::searchByKeyword($this->mall_id, 'mobile', $param['keyword']); } else { //快递单号查询不了 } } } if (isset($param['refund_status']) && $param['refund_status'] != 999 ) { if($param['refund_status'] == RefundStatusEnum::HANDEL){ //售后中 $where[] = ['in', 'refund_status', [ RefundStatusEnum::HANDEL, RefundStatusEnum::RETURN_GOODS, RefundStatusEnum::EXCHANGE_GOODS]]; }else{ $where[] = ['=', 'refund_status', $param['refund_status']]; } } else { $where[] = ['in', 'refund_status', [RefundStatusEnum::APPLY, RefundStatusEnum::HANDEL, RefundStatusEnum::FINISH, RefundStatusEnum::RETURN_GOODS, RefundStatusEnum::EXCHANGE_GOODS, RefundStatusEnum::REFUSE]]; } $with = ['base_user', 'orderDetail', 'order']; $select = 'id,order_id,order_detail_id,reason,remark,refund_price,refund_status,user_id'; $order = "id desc"; $params = compact('where', 'with', 'order', 'select'); $page_data = OrderRefund::listPage($params, false, true); if ($page_data === false) return $this->error(OrderRefund::getStaticError()); $compact_params = array_keys($page_data); extract($page_data); foreach ($list as &$order) { foreach ($order['orderDetail'] as &$detail) { if (!empty($detail['attr_groups_format'])) { //规格 $attr_groups_format = Json::decode($detail['attr_groups_format'], true); $attr_list = $attr_groups_format[$detail['sign_id']]; $attr_group_name_list = array_column($attr_list, 'attr_group_name'); $attr_name_list = array_column($attr_list, 'attr_name'); $detail['attr_list'] = []; foreach ($attr_group_name_list as $index => $attr_group_name) { $detail['attr_list'][] = $attr_group_name . ':' . $attr_name_list[$index]; } } } } //导航栏售后状态-数量 $stat = OrderRefund::find()->select('count(id) as num ,refund_status') ->where(['mall_id' => $this->mall_id, 'store_id' => $this->store_id ])->groupBy('refund_status')->asArray()->all(); $stat = array_column($stat, 'num', 'refund_status'); //$stat_tab = []; $stat_tab[] = [ 'refund_status' => 999, 'num' => 0 , 'refund_status_text' => '全部' ]; foreach ($refund_status_list as $key => $value) { if (!in_array($key, [RefundStatusEnum::APPLY, RefundStatusEnum::HANDEL, RefundStatusEnum::FINISH])) continue; $stat_tab[] = [ 'refund_status' => $key, 'num' => $stat[$key] ?? 0, 'refund_status_text' => $value ]; } return $this->success('操作成功', compact($compact_params, 'refund_status_list', 'refund_type_list', 'stat_tab')); } /** * 订单详情 * @return void */ public function actionOrderDetail() { $get = Yii::$app->request->get(); $rules = [[['id'], 'required']]; $res = Yii::$app->services->validate->validate($get, $rules); if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); $order_status_list = OrderStatusEnum::getMap(); $payment_type_list = PayTypeEnum::getMap(); $shipping_type_list = ShippingTypeEnum::getMap(); $where = [['mall_id' => $this->mall_id]]; $where[] = ['=', 'id', $get['id']]; $where[] = ['=', 'store_id', $this->store_id]; $where[] = ['>=', 'status', StatusEnum::DISABLED]; $with = [ 'base_user', 'detail' ]; $params = compact('where', 'with'); $order = StoreOrder::getOne($where, true, $with); if ($order === false) return $this->error(StoreOrder::getStaticError()); $main_order = Order::getOne([['order_no'=>$order['order_no']]],true,['express','express_log']); $express_log = []; $order['order_type_text'] = '普通订单'; //佣金分红 $order['commission_total'] = 0; //服务费 $order['service_fee'] = 0; //商家实收: $order['amount_received'] = 0; $store_commission = StoreCommission::findOne(['store_id'=>$this->store_id,'order_no' =>$order['order_no']]); if($store_commission){ $order['service_fee'] = $store_commission->service_charge; $order['commission_total'] = $store_commission->addons_bonus; $order['amount_received'] = $store_commission->amount_received; } $order_setting = Yii::$app->services->setting->mall->get($this->mall_id, 'order'); $order['payment_expire_time'] = $order_setting['payment_expire_time'] ?? 30; $order['auto_receiving_time'] = $order_setting['auto_receiving_time'] ?? 14; if (!empty($order['detail'])) { foreach ($order['detail'] as &$detail) { if (!empty($detail['attr_groups_format'])) { $attr_groups_format = json_decode($detail['attr_groups_format'], true); $attr_list = $attr_groups_format[$detail['sign_id']]; $attr_group_name_list = array_column($attr_list, 'attr_group_name'); $attr_name_list = array_column($attr_list, 'attr_name'); $detail['attr_list'] = []; foreach ($attr_group_name_list as $index => $attr_group_name) { $detail['attr_list'][] = $attr_group_name . ':' . $attr_name_list[$index]; } } } } $shipping_type_text = ShippingTypeEnum::getShippingType($order['shipping_type']); $step_arr = StoreEnum::setpArrMap($order['order_status'], $shipping_type_text);// 订单状态跟踪 $order_action = OrderAction::getOrderAction([['order_id' => $main_order['id']]]); $stepArr[] = ['title' => '买家下单', 'created_at' => '0', 'is_step' => 0]; $stepArr[] = ['title' => '买家付款', 'created_at' => '0', 'is_step' => 0,]; $stepArr[] = ['title' => $shipping_type_text, 'created_at' => '0', 'is_step' => 0,]; $stepArr[] = ['title' => '交易完成', 'created_at' => '0', 'is_step' => 0,]; $store = Store::getOne([['id' => $order['store_id']]], true); return $this->success('操作成功', compact('order', 'stepArr', 'order_status_list', 'payment_type_list', 'shipping_type_list', 'step_arr', 'order_action', 'store')); } /** * 售后订单详情 * @return mixed|void */ public function actionRefundDetail() { $get = Yii::$app->request->get(); $rules = [[['id'], 'required']]; $res = Yii::$app->services->validate->validate($get, $rules); if ($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); $order_status_list = OrderStatusEnum::getMap(); $address_list = StoreRefundAddress::lists([ 'where' => [ ['store_id' => $this->store_id], ['status' => StatusEnum::ENABLED] ], 'select' => 'address,mobile,name, refund_name as consignee', ]); $where = [['mall_id' => $this->mall_id], ['store_id' => $this->store_id]]; $where[] = ['=', 'id', $get['id']]; $where[] = ['>=', 'status', StatusEnum::DISABLED]; $with = ['base_user', 'order', 'orderDetail', 'marketing', 'step']; $params = compact('where', 'with'); $refund = OrderRefund::getOne($where, true, $with); if ($refund === false) return $this->error(OrderRefund::getStaticError()); $main_order = Order::findOne(['id' => $refund['order_id']]); $store_order = StoreOrder::findOne(['order_no' => $main_order['order_no'] ?? 0]); $store_order_credit = StoreOrderCredit::find()->where(['type' => 1, 'order_id' => $store_order['id'] ?? 0]) ->andWhere(['>', 'pay_time', 0])->one(); $refund['orderDetail']['credit_money'] = 0; if (!empty($store_order_credit['extra'])) { $goods_id = $refund['orderDetail']['goods_id']; $extra = json_decode($store_order_credit['extra'], true); if (!empty($extra[$goods_id]['credit_money'])) { $refund['orderDetail']['goods_price'] = bcadd($refund['orderDetail']['goods_price'], $extra[$goods_id]['credit_money'], 2); $refund['orderDetail']['credit_money'] = $extra[$goods_id]['credit_money']; } } foreach ($refund['orderDetail'] as $key => $detail) { if (!empty($detail['attr_groups_format'])) { $attr_groups_format = Json::decode($detail['attr_groups_format'], true); $attr_list = $attr_groups_format[$detail['sign_id']]; $attr_group_name_list = array_column($attr_list, 'attr_group_name'); $attr_name_list = array_column($attr_list, 'attr_name'); $detail['attr_list'] = []; } } // 返还优惠内容 if (!empty($refund['marketing'])) { $discount = []; $marketing = $refund['marketing']; if (!empty($marketing['deduct_score'])) { $score_name = Yii::$app->services->setting->mall->get($this->mall_id, 'score.score_name'); $discount[] = floatval($marketing['deduct_score']) . $score_name; } $refund['discount'] = implode('+', $discount); } $step_status = $refund['step'][0]['step_status'] ?? 0; $step_arr = RefundStatusEnum::stepNumArr(in_array($step_status, [RefundStatusEnum::STEP_NEGATIVE_1, RefundStatusEnum::STEP_NEGATIVE_2]) ? 1 : $refund['type']);// 进度条 $step_text = RefundStatusEnum::getStepStatusText($step_status); $refund_type_text = RefundTypeEnum::getMap(); $refund_status_text = RefundStatusEnum::getMap(); $refund['type_text'] = $refund_type_text[$refund['type']] ?? ''; $refund['refund_status_text'] = $refund_status_text[$refund['refund_status']] ?? ''; //关闭时间 $refund['finish_at'] = 0; if($refund['status'] == RefundStatusEnum::FINISH){ //售后完成 $refund['finish_at'] = $refund['updated_at']; } return $this->success('操作成功', compact('refund', 'order_status_list', 'step_arr', 'address_list', 'step_text')); } /** * 资产 * @return mixed|void */ public function actionFinance() { $store = Store::findOne(['id' => $this->store_id]); // $balance_cash_service_fee = \Yii::$app->services->setting->mall->get($this->mall_id, 'withdraw_balance.balance_cash_service_fee'); $user = User::getOne([['id' => $store->user_id]], true, [], false, 'id,nickname,avatar_url,mobile'); $finance = \Yii::$app->services->setting->addons->get($this->mall_id, StoreEnum::ADDONS_NAME, 'finance'); $storeSetting = StoreSettings::findOne(['store_id' => $this->store_id]); $freeze_is_enable = 0; $finance_name = '资产'; if(!empty($finance)){ if(!empty($finance['freeze_is_enable'])){ $freeze_is_enable = $finance['freeze_is_enable']; } if(!empty($finance['finance_name'])){ $finance_name = $finance['finance_name']; } } //提现条件 if(isset($finance['balance_cash_type'])){ $cashType = json_decode($finance['balance_cash_type'],true); }else{ //默认银行卡/余额提现 $cashType = ['balance','bank']; } $balance_cash_service_fee = 0; $balance_cash_service_fee_limit = 0; $balance_cash_service_fee_month = 0; if (!empty($storeSetting->is_enable_withdraw_setting)) { $finance['balance_cash_service_fee_limit'] = $storeSetting->balance_cash_service_fee_limit; $finance['balance_cash_service_fee_month'] = $storeSetting->balance_cash_service_fee_month; $finance['balance_cash_service_fee_diff'] = $storeSetting->balance_cash_service_fee_diff; $finance['balance_cash_service_fee'] = $storeSetting->balance_cash_service_fee; } if(!empty($finance['balance_cash_service_fee_limit'])){ $balance_cash_service_fee_limit = $finance['balance_cash_service_fee_limit']; $balance_cash_service_fee_month = $finance['balance_cash_service_fee_month']; $balance_cash_service_fee = $finance['balance_cash_service_fee_diff'] ?? 0; }else{ if(isset($finance['balance_cash_service_fee'])){ $balance_cash_service_fee = $finance['balance_cash_service_fee'] ?? 0; }else{ $balance_cash_service_fee = \Yii::$app->services->setting->mall->get($this->mall_id, 'withdraw_balance.balance_cash_service_fee'); } } if (!$cashType) { return $this->error('系统未设置提现方式'); } $cash__type_name = []; $get_system_setting = PlatformSetting::getConfByGroup('system', true); if (!empty($cashType)) { $cash_type = $cashType; $cash__type_name = []; $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); if (in_array('bank', $cash_type_keys) || in_array('joinpay', $cash_type_keys)) { $bank_card_list = StoreBank::lists(['where' => [['store_id' => $this->store_id], ['status' => StatusEnum::ENABLED]], 'select' => 'id,mall_id,store_id,username,bank as bank_name,card_no as bank_card_no']); } foreach ($cash_type as $i => $item) { 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) { $cash__type_name[$i]['bank_card_list'] = $bank_card_list; } } } } $return = [ 'balance' => $store->balance, //可提现金额 'unsettled_amount' => $store->unsettled_amount,//待结算金额 // 'store_banks' => $store_banks, 'balance_cash_service_fee' => $balance_cash_service_fee, 'balance_cash_service_fee_limit' => $balance_cash_service_fee_limit, 'balance_cash_service_fee_month' => $balance_cash_service_fee_month, 'freeze_is_enable' => $freeze_is_enable, 'finance_name' => $finance_name, 'user' => $user, 'cash_type_name' => $cash__type_name, ]; return $this->success('操作成功', $return,ApiStatusEnum::CODE_SUCCESS,JSON_UNESCAPED_UNICODE); } /** * 添加银行卡 * @return void */ public function actionAddBankCard() { try { $params = \Yii::$app->request->post(); $res = \Yii::$app->services->validate->validate($params, [ [['username', 'bank', 'card_no'], 'required'], ['card_no', 'string', 'max' => 64], [['username'], 'string', 'max' => 50], [['bank'], 'string', 'max' => 255], ]); if ($res === false) return $this->error(\Yii::$app->services->validate->getErrorMessage()); $bank_card_info = StoreBank::findONe(['mall_id' => $this->mall_id, 'card_no' => $params['card_no'], 'store_id' => $this->store_id, 'status' => StatusEnum::ENABLED]); if (!empty($bank_card_info)) { throw new \Exception('银行卡已经被绑定'); } $params['mall_id'] = $this->mall_id; $params['store_id'] = $this->store_id; $res = StoreBank::setData($params); if (!$res) throw new \Exception(StoreBank::getStaticError()); return $this->success('添加成功'); } catch (\Exception $exception) { return $this->error('操作失败:' . $exception->getMessage()); } } /** * 提现 * @throws \Exception */ public function actionWithdraw() { $params = \Yii::$app->request->post(); $need_auth = GlobalInvoke::exec(GlobalInvoke::REAL_AUTH, $this->mall_id, ['user_id' => $this->user_id,'mall_id' => $this->mall_id,'type' => 'cash']); if($need_auth === true){ //需要先进行实名认证 return $this->error('请先进行实名认证',[],ApiStatusEnum::CODE_ERROR_NEED_REAL_AUTH); } $form = new StoreWithdrawLog(); $params['mall_id'] = $this->mall_id; $params['user_id'] = $this->user_id; $params['store_id'] = $this->store_id; $form->attributes = $params; $data = $form->saveRecord($params); if ($data['state']) { return $this->success('操作成功', $data['data']); } else { return $this->error($data['msg']); } } }