コード例 #1
0
ファイル: SiteController.php プロジェクト: wuwenhan/huoqiwang
 public function actionIndex()
 {
     $betime = strtotime(date('Y-m-d' . ' 00:00:00', time()));
     $endtime = strtotime(date('Y-m-d' . ' 23:59:59', time()));
     $order = Order::find()->andWhere(['between', 'start_at', $betime, $endtime])->asArray()->count();
     $payment = SinaDeposit::find()->andWhere(['status' => SinaDeposit::STATUS_SUCCESS])->andWhere(['between', 'create_at', $betime, $endtime])->asArray()->count();
     $withdraw = SinaWithdraw::find()->andWhere(['status' => SinaWithdraw::STATUS_SINA_SUCCESS])->andWhere(['between', 'create_at', $betime, $endtime])->asArray()->count();
     $product = Thirdproduct::find()->andWhere(['status' => Thirdproduct::STATUS_ACTIVE])->andWhere(['intent' => Thirdproduct::INTENT_CHECK])->andWhere(['create_user_id' => Yii::$app->user->identity->getId()])->asArray()->all();
     $user = UcenterMember::find()->andWhere(['between', 'created_at', $betime, $endtime])->asArray()->count();
     $log = TradeLog::find()->orderBy('t_date desc');
     $pages = new Pagination(['totalCount' => $log->count(), 'pageSize' => '10']);
     $log = $log->offset($pages->offset)->limit($pages->limit)->all();
     AloneMethod::trade_log();
     $cur_recharge = TradeLog::find()->sum('t_recharge');
     $cur_invest = TradeLog::find()->sum('t_invest');
     $cur_redeem = TradeLog::find()->sum('t_redeem');
     $cur_withdraw = TradeLog::find()->sum('t_withdraw');
     $cur_profit = TradeLog::find()->sum('t_profit');
     $cur_glod = TradeLog::find()->sum('t_gold');
     $cur_red = TradeLog::find()->sum('t_red');
     $ret_msg = '当前总额: 充值【' . $cur_recharge . '】 投资【' . $cur_invest . '】 赎回【' . $cur_redeem . '】 提现【' . $cur_withdraw . '】 在投【' . $cur_profit . '】 体验金收益【' . $cur_glod . '】 红包【' . $cur_red . '】';
     return $this->render('index', ['withdraw' => $withdraw, 'payment' => $payment, 'order' => $order, 'user' => $user, 'product' => $product, 'log' => $log, 'pages' => $pages, 'ret_msg' => $ret_msg]);
 }
コード例 #2
0
ファイル: _upform.php プロジェクト: wuwenhan/huoqiwang
 * @time: 2015年7月14日 11:36:26
 * 
 */
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
use kartik\file\FileInput;
use dosamigos\datetimepicker\DateTimePicker;
use common\models\fund\FundProductThirdproduct;
use common\models\base\fund\Thirdproduct;
$id = $model->id;
$thirdfundModel = [];
$modelmid = FundProductThirdproduct::find()->where(['product_id' => $id])->asArray()->all();
if ($modelmid) {
    foreach ($modelmid as $v) {
        array_push($thirdfundModel, Thirdproduct::find()->select('id')->where(['id' => $v['thirdproduct_id']])->asArray()->one());
    }
    $newth = [];
    foreach ($thirdfundModel as $k => $v) {
        array_push($newth, $v['id']);
    }
}
/* @var $this yii\web\View */
/* @var $model common\models\base\fund\product */
/* @var $form yii\widgets\ActiveForm */
?>

<div class="product-form">

    <?php 
$form = ActiveForm::begin(['options' => ['enctype' => 'multipart/form-data']]);
コード例 #3
0
ファイル: Withdrawals.php プロジェクト: wuwenhan/huoqiwang
 /**
  * Auther:langxi
  * 根据赎回债权字典进行赎回操作
  * @param $Redeem
  */
 private static function Set_redeem($Redeem)
 {
     foreach ($Redeem as $k => $v) {
         //order表金额赎回
         $order = Order::findOne($v['order_id']);
         $order->money = $order['money'] - $v['thirdmoney'];
         if ($order['money'] == '0') {
             $order->status = Order::STATUS_DELETE;
         }
         $order = $order->save();
         if (!$order) {
             $result = array('errorNum' => '1', 'errorMsg' => '转让债权赎回失败', 'data' => null);
             return $result;
         }
         //thirdorder表金额赎回
         $thirdorder = Thirdorder::findOne($v['thirdorder_id']);
         $thirdorder->money = $thirdorder['money'] - $v['thirdmoney'];
         if ($thirdorder['money'] == '0') {
             $thirdorder->status = Thirdorder::STATUS_DELETED;
         }
         $thirdorder->mcmoney = $thirdorder['mcmoney'] + $v['thirdmoney'];
         //记录最大债权增加
         $thirdorder->ocmoney = $thirdorder['ocmoney'] - $v['thirdmoney'];
         //记录原始债权金额减少
         $thirdorder = $thirdorder->save();
         if (!$thirdorder) {
             $result = array('errorNum' => '1', 'errorMsg' => '第三方转让债权失败', 'data' => null);
             return $result;
         }
         //thirdproduct第三方债权已投金额减少
         $thirdproduct = Thirdproduct::findOne($v['thirdproduct_id']);
         $thirdproduct->invest_sum = $thirdproduct['invest_sum'] - $v['thirdmoney'];
         $thirdproduct->mcmoney = $thirdproduct['mcmoney'] + $v['thirdmoney'];
         //赎回导致最大债权人金额增加
         $thirdproduct = $thirdproduct->save();
         if (!$thirdproduct) {
             $result = array('errorNum' => '1', 'errorMsg' => '赎回第三方债权已投金额失败', 'data' => null);
             return $result;
         }
         //获取债权的最大债权人id,将用户赎回的钱从最大债权人的账户中减去
         $maxcreditor = Thirdproduct::find()->select(['maxcreditor'])->where(['id' => $v['thirdproduct_id']])->asArray()->one();
         $maxcreditor = $maxcreditor['maxcreditor'];
         $is_max = Catmiddle::find()->where(['cid' => '1', 'uid' => $maxcreditor])->asArray()->one();
         if (!$is_max) {
             $result = array('errorNum' => '1', 'errorMsg' => '最大债权人异常', 'data' => null);
             return $result;
         }
         $max_info = Info::findOne($maxcreditor);
         $max_info->balance = $max_info['balance'] - $v['thirdmoney'];
         $max_info = $max_info->save();
         if (!$max_info) {
             $result = array('errorNum' => '1', 'errorMsg' => '消减最大债权人账户金额失败', 'data' => null);
             return $result;
         }
         //写入职员账户记录表中
         $member_id = Order::find()->select(['member_id'])->where(['id' => $v['order_id']])->asArray()->one();
         $member_id = $member_id['member_id'];
         $clerk = new ClerkLog();
         $clerk->member_id = $member_id;
         $clerk->clerk_id = $maxcreditor;
         $clerk->behav = ClerkLog::CLERK_BEHAV_TWO;
         $clerk->step = $v['thirdmoney'];
         $clerk->remark = '最大债权人';
         $clerk = $clerk->save();
         if (!$clerk) {
             throw new ErrorException('写入职员账户记录失败');
         }
     }
     return true;
 }
コード例 #4
0
ファイル: Invest.php プロジェクト: wuwenhan/huoqiwang
 /**
  * Auther:langxi
  *
  * 将投资的金额按照生成的债权数据字典,分散加入债权表
  */
 private static function set_Third($thirdArr, $member_id)
 {
     //债权表中无需写入购买人数,没有意义
     foreach ($thirdArr as $vo) {
         //获取thirdproduct中的原始债权人id,最大债权人id,并检查其是否为公司员工,并判断资金应支付给债权人还是原始债权人,
         $thirdproduct = Thirdproduct::find()->select(['creditor', 'maxcreditor'])->where(['id' => $vo['id']])->asArray()->one();
         if ($vo['ocmoney'] > 0) {
             //将钱支付给原始债权人(网站)
             $creditor = $thirdproduct['creditor'];
             $is_yuan = Catmiddle::find()->where(['cid' => '2', 'uid' => $creditor])->asArray()->one();
             if (!$is_yuan) {
                 $result = array('errorNum' => '1', 'errorMsg' => '原始债权人异常', 'data' => null);
                 return $result;
             }
             $yuan_info = Info::findOne($creditor);
             $yuan_info->balance = $yuan_info['balance'] + $vo['ocmoney'];
             $yuan_info = $yuan_info->save();
             if (!$yuan_info) {
                 $result = array('errorNum' => '1', 'errorMsg' => '资金放入原始债权人账户失败', 'data' => null);
                 return $result;
             }
             //写入职员账户记录表中
             $clerk = new ClerkLog();
             $clerk->member_id = $member_id;
             $clerk->clerk_id = $creditor;
             $clerk->behav = ClerkLog::CLERK_BEHAV_ONE;
             $clerk->step = $vo['ocmoney'];
             $clerk->remark = '原始债权人';
             $clerk = $clerk->save();
             if (!$clerk) {
                 $result = array('errorNum' => '1', 'errorMsg' => '写入职员账户记录失败', 'data' => null);
                 return $result;
             }
         }
         if ($vo['mcmoney'] > 0) {
             //将钱支付给最大债权人(网站)
             $maxcreditor = $thirdproduct['maxcreditor'];
             $is_max = Catmiddle::find()->where(['cid' => '1', 'uid' => $maxcreditor])->asArray()->one();
             if (!$is_max) {
                 $result = array('errorNum' => '1', 'errorMsg' => '最大债权人异常', 'data' => null);
                 return $result;
             }
             $max_info = Info::findOne($maxcreditor);
             $max_info->balance = $max_info['balance'] + $vo['mcmoney'];
             $max_info = $max_info->save();
             if (!$max_info) {
                 $result = array('errorNum' => '1', 'errorMsg' => '资金放入最大债权人账户失败', 'data' => null);
                 return $result;
             }
             //写入职员账户记录表中
             $clerk = new ClerkLog();
             $clerk->member_id = $member_id;
             $clerk->clerk_id = $maxcreditor;
             $clerk->behav = ClerkLog::CLERK_BEHAV_ONE;
             $clerk->step = $vo['mcmoney'];
             $clerk->remark = '最大债权人';
             $clerk = $clerk->save();
             if (!$clerk) {
                 $result = array('errorNum' => '1', 'errorMsg' => '写入职员账户记录失败', 'data' => null);
                 return $result;
             }
         }
         //按用户id和订单时间获取上面生成的订单id值
         $order = Order::find()->where(['member_id' => $member_id])->orderBy('start_at desc')->asArray()->one();
         $thirdorder = new Thirdorder();
         $thirdorder->member_id = $member_id;
         $thirdorder->thirdproduct_id = $vo['id'];
         $thirdorder->order_id = $order['id'];
         $thirdorder->money = $vo['mcmoney'] + $vo['ocmoney'];
         $thirdorder->ocmoney = $vo['ocmoney'];
         $thirdorder->mcmoney = $vo['mcmoney'];
         $thirdorder->start_money = $vo['mcmoney'] + $vo['ocmoney'];
         $thirdorder->status = Thirdorder::STATUS_ACTIVE;
         $thirdorder->start_at = time();
         $thirdorder->end_at = $order['end_at'];
         $thirdorder = $thirdorder->save();
         if (!$thirdorder) {
             $result = array('errorNum' => '1', 'errorMsg' => '债权数据字典写入债权订单表失败', 'data' => null);
             return $result;
         }
         //将资金分配给债权表
         $thirdproduct = Thirdproduct::findOne($vo['id']);
         $thirdproduct->ocmoney = $thirdproduct['ocmoney'] - $vo['ocmoney'];
         $thirdproduct->mcmoney = $thirdproduct['mcmoney'] - $vo['mcmoney'];
         $thirdproduct->invest_sum = $thirdproduct['invest_sum'] + $vo['ocmoney'] + $vo['mcmoney'];
         $thirdproduct = $thirdproduct->save();
         if (!$thirdproduct) {
             $result = array('errorNum' => '1', 'errorMsg' => '资金写入债权表失败', 'data' => null);
             return $result;
         }
     }
     return false;
 }
コード例 #5
0
ファイル: Invest.php プロジェクト: wuwenhan/huoqiwang
 /**
  * Auther:langxi
  *
  * 将再投资的金额按照生成的在投资债权数据字典,分散加入债权表
  */
 private static function reset_Third($thirdArr, $member_id, $order_id)
 {
     //将软删除的订单的金额,从thirdproduct表中的已投金额中减去
     $thirdorder = (new \yii\db\Query())->select(['thirdproduct_id', 'money'])->from('fund_thirdorder')->where(['member_id' => $member_id, 'order_id' => $order_id])->all();
     foreach ($thirdorder as $key => $val) {
         $thirdproduct = Thirdproduct::findOne($val['thirdproduct_id']);
         $thirdproduct->invest_sum = $thirdproduct['invest_sum'] - $val['money'];
         $thirdproduct = $thirdproduct->save();
     }
     //债权表中无需写入购买人数,没有意义
     foreach ($thirdArr as $vo) {
         //将债权数据字典连同订单号写入到thirdorder中
         //按用户id和订单时间获取上面生成的订单id值
         $order = Order::find()->where(['member_id' => $member_id, 'id' => $order_id])->asArray()->one();
         $thirdorder = new Thirdorder();
         $thirdorder->member_id = $member_id;
         $thirdorder->thirdproduct_id = $vo['id'];
         $thirdorder->order_id = $order['id'];
         $thirdorder->money = $vo['t_money'];
         $thirdorder->start_money = $vo['t_money'];
         $thirdorder->status = Thirdorder::STATUS_ACTIVE;
         $thirdorder->start_at = time();
         $thirdorder->end_at = $order['end_at'];
         $thirdorder = $thirdorder->save();
         if (!$thirdorder) {
             throw new ErrorException('债权数据字典写入债权订单表失败', 6002);
         }
         //将资金分配给债权表
         $thirdproduct = Thirdproduct::findOne($vo['id']);
         $thirdproduct->invest_sum = $thirdproduct['invest_sum'] + $vo['t_money'];
         $thirdproduct = $thirdproduct->save();
         if (!$thirdproduct) {
             throw new ErrorException('资金写入债权表失败', 6002);
         }
     }
     return true;
 }
コード例 #6
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function addsearch($params)
 {
     $user = User::find()->where(['id' => \App::$app->user->identity->getId()])->one();
     if ($user->role == 'admin') {
         $query = Thirdproduct::find()->orderBy('id DESC');
     } else {
         $query = Thirdproduct::find()->andWhere(['create_user_id' => Yii::$app->user->identity->getId()])->orderBy('id DESC');
     }
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $ucmember = new UcenterMember();
     $user = new User();
     $creditor = $ucmember->find()->andWhere(['username' => $this->creditor])->one();
     $maxcreditor = $ucmember->find()->andWhere(['username' => $this->maxcreditor])->one();
     $user = $user->find()->andWhere(['username' => $this->create_user_id])->one();
     $oid = $creditor ? $creditor->id : '';
     $mid = $maxcreditor ? $maxcreditor->id : '';
     $uid = $user ? $user->id : '';
     $query->andFilterWhere(['id' => $this->id, 'amount' => $this->amount, 'start_at' => $this->start_at, 'end_at' => $this->end_at, 'rate' => $this->rate, 'invest_people' => $this->invest_people, 'invest_sum' => $this->invest_sum, 'create_at' => $this->create_at, 'update_at' => $this->update_at, 'status' => $this->status, 'create_user_id' => $uid, 'check_user_id' => $this->check_user_id, 'ocreditor' => $oid, 'maxcreditor' => $mid]);
     $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'intro', $this->intro])->andFilterWhere(['like', 'source', $this->source])->andFilterWhere(['like', 'creditor', $this->creditor])->andFilterWhere(['like', 'contract', $this->contract])->andFilterWhere(['like', 'remarks', $this->remarks]);
     return $dataProvider;
 }