/** *Auther:langxi * * 前台用户提现 * @param $member_id * @param $money * @throws ErrorException */ public static function withdraw($member_id, $money) { ini_set('max_execution_time', 60); $member_id = (int) $member_id; //判断是否为公司员工,若是取新浪余额,使网站余额与新浪余额保持一致 $is_company = Catmiddle::find()->where(['uid' => $member_id])->andWhere(['or', 'cid=1', 'cid=2'])->asArray()->one(); if ($is_company) { $sina_withdraw = sinapay::querySinaBalance($member_id); //获取用户新浪余额 if ($sina_withdraw['errorNum']) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); $result = array('errorNum' => '1', 'errorMsg' => '新浪查询余额' . $sina_withdraw['errorMsg'], 'data' => null); return $result; } $info = Info::find()->select(['balance'])->where(['member_id' => $member_id])->asArray()->one(); $balance = $info['balance']; if ($balance < $sina_withdraw) { $info = Info::findOne($member_id); $info->balance = $sina_withdraw['data']['available_balance']; $info = $info->save(); if (!$info) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); $result = array('errorNum' => '1', 'errorMsg' => '更新公司员工账户余额失败', 'data' => null); return $result; } } } //判断用户是否可进行提现操作 $is_go = Info::find()->select(['status'])->where(['member_id' => $member_id])->asArray()->one(); if ($is_go['status'] > 0) { $result = array('errorNum' => '1', 'errorMsg' => '处理中,请稍后再试', 'data' => null); return $result; } Info::updateAll(['status' => Info::GO_FOUR], ['member_id' => $member_id]); //进行操作,状态变为提现处理中 //检测用户状态 $checkMember = self::checkMember($member_id); if ($checkMember) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); return $checkMember; } //检测提现次数,提现金额 $check_balance = self::check_balance($member_id, $money); if ($check_balance) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); return $check_balance; } $blance = self::showBlance($member_id); //账户余额 if ($blance < $money) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); $result = array('errorNum' => '1', 'errorMsg' => '提现金额大于余额,请重新输入', 'data' => null); return $result; } $asset = Info::find()->where(['member_id' => $member_id])->asArray()->one(); $bank_card = $asset['bank_card']; //将信息传输给第三方,新浪用户账户余额查询接口 $sina_withdraw = sinapay::withdraw($member_id, $money); if ($sina_withdraw['errorNum']) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); $result = array('errorNum' => '1', 'errorMsg' => '新浪查询余额' . $sina_withdraw['errorMsg'], 'data' => null); return $result; } //事物回滚 $transaction = \Yii::$app->db->beginTransaction(); try { //再次检测余额是否满足提现要求 $info = Info::find()->where(['member_id' => $member_id])->asArray()->one(); if ($info['balance'] < $money) { throw new ErrorException('可提现金额不足'); } $asset = Info::findOne($member_id); $asset->balance = $asset['balance'] - $money; $asset->freeze = $asset['freeze'] + $money; $asset = $asset->save(); if (!$asset) { throw new ErrorException('提现失败', 4003); } //消除冻结金额 $asset = Info::findOne($member_id); $asset->freeze = $asset['freeze'] - $money; $asset->save(); //提现成功进行提现记录 $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $money; $assetlog->action = 'Withdrawals/withdraw'; $assetlog->status = self::WSUCCEED; //4为提现成功 $assetlog->bankcard = $bank_card; $assetlog->remark = '提现成功'; $assetlog->save(); //.网站账户提现余额:$sina_withdraw['data']['money_site'];新浪赎回金额:$sina_withdraw['data']['money_sina'], //新浪用户标识:$sina_withdraw['data']['identity_id'] 中间用于信息获取的订单号$sina_withdraw['data']['out_trade_no'] //调用新浪提现接口,进行用户账户余额提现到银行卡 // $sina_sinawithdraw = sinapay::sianWithdrawOnly($member_id, $money); // if ($sina_sinawithdraw['errorNum']) { // throw new ErrorException('新浪提现失败:' . $sina_sinawithdraw['errorMsg'], 7003); // } //T+0操作 $immediate_withdraw = sinapay::immediate_withdraw($member_id, $money); if ($immediate_withdraw['errorNum']) { throw new ErrorException('新浪提现失败:' . $immediate_withdraw['errorMsg'], 7003); } Log::updateAll(['trade_no' => $immediate_withdraw['data']['trade_no']], ['id' => $assetlog['id']]); //T+0测试 // $immediate_array = array('44','72','74','73','79','77'); // if(in_array($member_id,$immediate_array)){ // $immediate_withdraw = sinapay::immediate_withdraw($member_id,$money); // if ($immediate_withdraw['errorNum']) { // throw new ErrorException('新浪提现失败:' . $immediate_withdraw['errorMsg'], 7003); // } // Log::updateAll(['trade_no' => $immediate_withdraw['data']['trade_no']],['id' => $assetlog['id']]); // }else{ // // 不是T+0操作 // //调用新浪提现接口,进行用户账户余额提现到银行卡 // $sina_sinawithdraw = sinapay::sianWithdrawOnly($member_id,$money); // if ($sina_sinawithdraw['errorNum']) { // throw new ErrorException('新浪提现失败:' . $sina_sinawithdraw['errorMsg'], 7003); // } // Log::updateAll(['trade_no' => $sina_sinawithdraw['data']['trade_no']],['id' => $assetlog['id']]); // } $transaction->commit(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); $result = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => null); return $result; } catch (\Exception $e) { $transaction->rollBack(); //对提现失败信息进行记录 $remark = $e->getMessage(); $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->step = $money; $assetlog->action = 'Withdrawals/withdraw'; $assetlog->status = self::WERROR; //-4为提现失败 $assetlog->bankcard = $bank_card; $assetlog->remark = $remark; $assetlog = $assetlog->save(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); $result = array('errorNum' => '1', 'errorMsg' => $remark, 'data' => null); return $result; } }
/** * Auther:langxi * $member_id:用户id,$product_id:项目id,$money:用户投资钱数 * 用户投资 */ public static function invest($member_id, $product_id, $money) { ini_set('max_execution_time', 60); $member_id = (int) $member_id; $product_id = (int) $product_id; $money = (double) $money; //判断用户是否可进行提现操作 $is_go = Info::find()->select(['status'])->where(['member_id' => $member_id])->asArray()->one(); if ($is_go['status'] > 0) { throw new ErrorException('处理中,请稍后再试'); } Info::updateAll(['status' => Info::GO_TWO], ['member_id' => $member_id]); //进行操作,状态变为投资处理中 //检测用户投资资金,次数 $check_invest = self::check_invest($member_id, $product_id, $money); if ($check_invest) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); throw new ErrorException($check_invest); } //检测用户账户余额是否满足投资金额 $card = Info::find()->where(['member_id' => $member_id])->asArray()->one(); if ($card['balance'] < $money) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); throw new ErrorException('账户金额不足,请进行充值', 6001); } //检测投资金额是否满足项目的每次投资最大最小额度限制 $checkMoney = self::checkMoney($product_id, $money); if ($checkMoney) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); throw new ErrorException($checkMoney); } //检测用户状态 $checkMember = self::checkMember($member_id); if ($checkMember) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); throw new ErrorException($checkMember); } //检测项目状态 $checkProduct = self::checkProduct($product_id, $money); if ($checkProduct) { Info::updateAll(['status' => '0'], ['member_id' => $member_id]); throw new ErrorException($checkProduct); } $asset = Info::find()->where(['member_id' => $member_id])->asArray()->one(); $bank_card = $asset['bank_card']; //用户银行卡 $product = Product::find()->where(['id' => $product_id])->asArray()->one(); $end_at = $product['end_at']; //项目投资终止时间 //事物回滚 $transaction = \Yii::$app->db->beginTransaction(); try { //将账户中的钱取出,放入冻结金额中 $asset = Info::findOne($member_id); $asset->balance = $asset['balance'] - $money; $asset->freeze = $asset['freeze'] + $money; $asset = $asset->save(); if (!$asset) { throw new ErrorException('投资失败', 6002); } if ($product['type'] == Product::TYPE_THIRD) { //进行投资将钱放入order中 债权转让项目订单(一对多) $order = new Order(); $order->member_id = $member_id; //用户id $order->product_id = $product_id; //投资项目id $order->type = Product::TYPE_THIRD; //投资项目类型 $order->money = $money; //剩余投资金额 $order->start_money = $money; //最初投资金额 $order->status = Order::STATUS_ACTIVE; //订单状态 $order->start_at = time(); //订单生效时间 $order->end_at = $end_at; $order = $order->save(); if (!$order) { throw new ErrorException('投资失败', 6002); } } else { //进行投资将钱放入order中 type=0债权项目(一对一) $order = new Order(); $order->member_id = $member_id; //用户id $order->product_id = $product_id; //投资项目id $order->type = Product::TYPE_PRO; //投资项目类型 $order->money = $money; //剩余投资金额 $order->start_money = $money; //最初投资金额 $order->status = Order::STATUS_ACTIVE; //订单状态 $order->start_at = time(); //订单生效时间 $order->end_at = $end_at; $order = $order->save(); if (!$order) { throw new ErrorException('投资失败', 6002); } } //检测用户是否投资过该项目,进行项目投资人数加一处理,项目已投金额增长 $check_people = self::check_people($member_id, $product_id); if ($check_people) { $product = Product::find()->where(['id' => $product_id])->asArray()->one(); $product_money = $product['invest_sum'] + $money; $total_money = $product['amount']; if ($product_money > $total_money) { throw new ErrorException('您投资的金额大于该项目剩余的额度', 6001); } $product = Product::findOne($product_id); $product->invest_sum = $product['invest_sum'] + $money; if ($product['invest_sum'] == $product['amount']) { $product->status = Product::STATUS_OUT; } $product->invest_people = $product['invest_people'] + 1; $res = $product->save(); if (!$res) { throw new ErrorException('项目已投金额、投资人数增加失败', 6002); } } else { $product = Product::find()->where(['id' => $product_id])->asArray()->one(); $product_money = $product['invest_sum'] + $money; $total_money = $product['amount']; if ($product_money > $total_money) { throw new ErrorException('您投资的金额大于该项目剩余的额度', 6001); } $product = Product::findOne($product_id); $product->invest_sum = $product['invest_sum'] + $money; if ($product['invest_sum'] == $product['amount']) { $product->status = Product::STATUS_OUT; } $res = $product->save(); if (!$res) { throw new ErrorException('项目已投金额增加失败', 6002); } } //type=Product::TYPE_THIRD为一对多项目债权转让 //获取用户此次投资此项目的债权字典 $thirdArr = self::creditor_dic($product_id, $money); //按照生成的债权字典,将钱分配给债权表 $setthird = self::set_Third($thirdArr, $member_id); if (!$setthird) { throw new ErrorException('资金分配到债权失败', 6002); } //删减用户账户冻结金额 $asset = Info::find()->where(['member_id' => $member_id])->asArray()->one(); $freeze = $asset['freeze']; //获取用户账户新的冻结金额 $asset = Info::findOne($member_id); $asset->freeze = $freeze - $money; $asset->invest = $asset['invest'] + $money; $asset->total_invest = $asset['total_invest'] + $money; //网站投资流程完成,增加用户累计投资额 $asset = $asset->save(); if (!$asset) { throw new ErrorException('删减冻结金额失败', 6002); } //投资成功进行投资记录 $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->product_id = $product_id; $assetlog->step = $money; $assetlog->action = 'Invest/invest'; $assetlog->status = self::INVESTSUCCEED; //2标识投资成功 $assetlog->bankcard = $bank_card; $assetlog->remark = '网站投资成功'; $assetlog->save(); //处理债权字典,生成用于第三方代收的数据字典,键值为用户id,值为钱数 , $sina_pay为第三方代收函数需要的参数 $sina_dic = array(); foreach ($thirdArr as $v) { $sina_dic['m' . $v['maxcreditor']][] = array($v['mcmoney'], $v['maxcreditor']); $sina_dic['c' . $v['creditor']][] = array($v['ocmoney'], $v['creditor']); } $sina_pay = array(); foreach ($sina_dic as $key => $val) { foreach ($val as $k => $v) { if (!isset($sina_pay[$v['1']])) { $sina_pay[$v['1']] = $v['0']; } else { $sina_pay[$v['1']] += $v['0']; } } } //过滤掉金额为空的数组,得到第三方代收函数需要的参数,$sina_pay foreach ($sina_pay as $key => $value) { if (empty($value)) { unset($sina_pay[$key]); } } //调用封装好的第三方接口 $sina_invest = sinapay::invest((string) $member_id, (string) $product_id, (string) $money); //托管代收接口 if ($sina_invest['errorNum']) { throw new ErrorException($sina_invest['errorMsg'], 7001); } //更新网站交易记录 Log::updateAll(['trade_no' => $sina_invest['data']['out_trade_no'], 'remark' => '用户投资,新浪代收成功'], ['id' => $assetlog['id']]); $sina_peyee = sinapay::batchPay($sina_pay, $sina_invest['data']['out_trade_no']); //托管批量代付接口 if ($sina_peyee['errorNum']) { $sina_refund = sinapay::hostingRefund($sina_invest['data']['identity_id'], $sina_invest['data']['out_trade_no'], $sina_invest['data']['money']); if ($sina_refund['errorNum']) { throw new ErrorException($sina_refund['errorMsg'], 7001); } throw new ErrorException($sina_peyee['errorMsg'], 7001); } //更新网站交易记录 Log::updateAll(['remark' => '用户投资成功'], ['id' => $assetlog['id']]); //总投资记录 self::total_log($member_id, $money); $transaction->commit(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); return true; } catch (\Exception $e) { $transaction->rollBack(); //对投资失败信息进行记录 $remark = $e->getMessage(); $assetlog = new Log(); $assetlog->member_id = $member_id; $assetlog->product_id = $product_id; $assetlog->step = $money; $assetlog->action = 'Invest/Invest'; $assetlog->status = self::INVESTERROR; //-2标识投资失败 $assetlog->bankcard = $bank_card; $assetlog->remark = $remark; $assetlog->save(); Info::updateAll(['status' => '0'], ['member_id' => $member_id]); throw new ErrorException($remark, 6002); } }