Example #1
0
 public function index()
 {
     $key = $_GET['key'];
     $arg = file_get_contents($this->updir . "config.txt");
     $arga = explode("|", $arg);
     $rate = intval($arga[1]);
     if ($key != $arga[2]) {
         exit("fail|密钥错误");
     }
     $total = 0;
     if ($rate > 0) {
         $list = M("member_money")->field("uid,account_money")->where("account_money>0")->select();
         $i = 0;
         foreach ($list as $v) {
             $amoney = getFloatValue($v['account_money'] * $rate / 10000, 2);
             $re = memberMoneyLog($v['uid'], 32, $amoney, date("Y年m月d日") . "利息");
             if ($re) {
                 $i++;
                 $total += $amoney;
             }
         }
         $all = count($list);
         $str = "共{$all}人需要发布利息,共成功对{$i}人发放共计{$total}元利息";
         echo "success|{$str}";
     } else {
         echo "success|利率为0,不返利";
     }
     echo "\r\n" . date("Y-m-d H:i:s", time());
     exit;
 }
 public function actupleve()
 {
     $money = intval($_POST['upmoney']);
     $vo = M('members')->field('user_leve,account_money,time_limit,recommend_id')->find($this->uid);
     $levemoney = $vo['account_money'] - $money;
     if ($levemoney < 0) {
         ajaxmsg("帐户余额不足", 0);
     }
     $vo['time_limit'] > time() ? $oldtime = $vo['time_limit'] : ($oldtime = time());
     if ($money == 25) {
         $time_limit = strtotime(date("Y-m-d", strtotime("+1 months", $oldtime)) . " 23:59:59");
     } elseif ($money == 100) {
         $time_limit = strtotime(date("Y-m-d", strtotime("+6 months", $oldtime)) . " 23:59:59");
     } elseif ($money == 150) {
         $time_limit = strtotime(date("Y-m-d", strtotime("+12 months", $oldtime)) . " 23:59:59");
     }
     $res = memberMoneyLog($this->uid, 2, $money, "会员特权延长至" . date("Y-m-d", $time_limit) . "到期");
     if ($res) {
         $xmoney = M('members')->getFieldById($vo['recommend_id'], 'reward_money');
         memberMoneyLog($vo['recommend_id'], 13, 5, session('u_user_name') . "升级特权会员奖励");
         $sdata['id'] = $this->uid;
         $sdata['time_limit'] = $time_limit;
         $sdata['user_leve'] = 1;
         $newid = M('members')->save($sdata);
         if ($newid) {
             ajaxmsg();
         } else {
             ajaxmsg("升级出错,请重试", 0);
         }
     } else {
         ajaxmsg("帐户余额处理出错,请重试", 0);
     }
 }
 public function face()
 {
     if (!$this->uid) {
         ajaxmsg("请先登陆", 0);
     }
     $vs = M('members_status')->getFieldByUid($this->uid, 'face_status');
     if ($vs == 1) {
         ajaxmsg("您已通过现场认证,无需再次认证", 0);
     }
     $vxs = M('face_apply')->where("uid={$this->uid} AND apply_status=0")->count('id');
     if ($vxs >= 1) {
         ajaxmsg("您已经提交申请,请等待客服人员处理", 0);
     }
     $newid = memberMoneyLog($this->uid, 26, -$this->glo['fee_face'], $info = "申请现场认证");
     if ($newid) {
         $save['uid'] = $this->uid;
         $save['add_time'] = time();
         $save['add_ip'] = get_client_ip();
         $save['apply_status'] = 0;
         $newidx = M('face_apply')->add($save);
         if ($newidx) {
             ajaxmsg("申请成功,请等待客服与您联系");
         } else {
             ajaxmsg("申请失败,请重试");
         }
     } else {
         ajaxmsg("申请失败,请重试");
     }
 }
Example #4
0
 public function doEdit()
 {
     $id = intval($_POST['id']);
     $status = intval($_POST['status']);
     $tran_id = text($_POST['tran_id']);
     $statusx = M('member_payonline')->getFieldById($id, "status");
     if ($statusx != 0) {
         $this->error("请不要重复提交表单");
     }
     if ($status == 1) {
         if (empty($tran_id)) {
             $this->error("如充值成功,请输入相应支付平台的对账订单号!");
             return;
         }
         $tran_counts = M('member_payonline')->where(array("tran_id" => $tran_id))->count("1");
         if ($tran_counts > 0) {
             $this->error("该对账订单号已经存在!");
             return;
         }
         $vo = M('member_payonline')->field('money,fee,uid,way')->find($id);
         $newid = memberMoneyLog($vo['uid'], 27, $vo['money'] - $vo['fee'], "管理员手动审核充值");
         if ($newid) {
             $save['deal_user'] = session('adminname');
             $save['deal_uid'] = $this->admin_id;
             $save['status'] = 1;
             $save['tran_id'] = $tran_id;
             M('member_payonline')->where("id={$id}")->save($save);
             $vx = M('members')->field("user_name,user_phone")->find($vo['uid']);
             if ($vo['way'] == "off") {
                 SMStip("payoffline", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $vo['money']), null, array($vo['uid']));
             } else {
                 SMStip("payonline", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $vo['money']), null, array($vo['uid']));
             }
             $this->success("处理成功");
         } else {
             $this->error("处理失败");
         }
     } else {
         $save['deal_user'] = session('adminname');
         $save['deal_uid'] = $this->admin_id;
         $save['status'] = 3;
         $newid = M('member_payonline')->where("id={$id}")->save($save);
         if ($newid) {
             $this->success("处理成功");
         } else {
             $this->error("处理失败");
         }
     }
 }
 protected function payDone()
 {
     if ($this->locked) {
         return false;
     }
     $this->locked = true;
     $newid = memberMoneyLog($this->orderInfo['uid'], 3, $this->orderInfo['money'], "充值订单号:" . $this->orderInfo['pay_no'], 0, '@网站管理员@');
     //更新成功才充值,避免重复充值
     $this->locked = false;
     $this->okLog($newid, $this->orderInfo['pay_no'] . '金额发放', __METHOD__, $this->orderInfo['uid']);
     M('member_payonline')->where(array('pay_no' => $this->orderInfo['pay_no']))->save(array('payres' => $newid));
     if ($newid) {
         $vx = M('members')->find($this->orderInfo['uid']);
         SMStip("payonline", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $this->orderInfo['money']));
     }
     return $newid;
 }
 public function _doEditFilter($m)
 {
     $m->deal_time = time();
     $m->deal_user = session('adminname');
     $vox = M("member_withdraw")->field(true)->find($m->id);
     if ($vox['withdraw_status'] != 3 && $m->withdraw_status == 3) {
         $lm = M('members')->getFieldById($vox['uid'], 'account_money');
         addInnerMsg($uid, "您的提现申请审核未通过", "您的提现申请审核未通过");
         memberMoneyLog($vox['uid'], 12, $vox['withdraw_money'], "提现未通过,返还");
     } elseif ($vox['withdraw_status'] != 2 && $m->withdraw_status == 2) {
         $um = M('members')->field("user_name,user_phone")->find($vox['uid']);
         addInnerMsg($uid, "您的提现已完成", "您的提现已完成");
         memberMoneyLog($vox['uid'], 29, -$vox['withdraw_money'], "提现成功,减去冻结资金,到帐金额" . ($vox['withdraw_money'] - intval($_POST['withdraw_fee'])));
         SMStip("withdraw", $um['user_phone'], array("#USERANEM#", "#MONEY#"), array($um['user_name'], $vox['withdraw_money'] - intval($_POST['withdraw_fee'])), null, array($vox['uid']));
     } elseif ($vox['withdraw_status'] != 1 && $m->withdraw_status == 1) {
         addInnerMsg($uid, "您的提现申请已通过", "您的提现申请已通过,正在处理中");
     }
     return $m;
 }
Example #7
0
 public function withdraw()
 {
     import("ORG.Loan.Escrow");
     $loan = new Escrow();
     if ($loan->withdrawVerify($_POST)) {
         $orders = $_POST['OrderNo'];
         $id = substr($orders, 12);
         $vo = M('member_withdraw')->field('uid,withdraw_money,withdraw_fee,withdraw_status, loanno')->where("id={$id}")->find();
         $uid = $vo['uid'];
         if ($_POST['ResultCode'] == '88' && !$vo['withdraw_status']) {
             // 成功
             $FreeLimit = $_POST['FreeLimit'];
             $FeeWithdraws = $_POST['FeeWithdraws'];
             $Amount = $_POST['Amount'];
             $updata['withdraw_status'] = 1;
             $updata['second_fee'] = $_POST['FeeWithdraws'];
             $updata['withdraw_fee'] = $FeeWithdraws;
             $updata['loanno'] = $_POST['LoanNo'];
             $xid = M('member_withdraw')->where("uid={$vo['uid']} AND id={$id}")->save($updata);
             if ($xid) {
                 $amoney = $_POST['Amount'] - $_POST['FeeWithdraws'];
                 memberMoneyLog($uid, 29, $_POST['Amount'], "提现成功,扣除实际手续费" . $FeeWithdraws . "元,到帐金额" . $amoney . "元", '0', '@网站管理员@', 0);
                 MTip('chk6', $uid);
                 echo "SUCCESS";
                 notifyMsg('提现', $_POST, 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'], 'SUCCESS');
                 exit;
             }
         } elseif ($_POST['ResultCode'] == '89' && $vo['withdraw_status'] == 1) {
             //退回资金
             $updata['withdraw_status'] = 2;
             $xid = M('member_withdraw')->where("uid={$uid} AND id={$id}")->save($updata);
             if ($xid) {
                 memberMoneyLog($uid, 5, $_POST['Amount'], "提现退回资金{$_POST['Amount']}元", '0', '@网站管理员@', 0);
                 notifyMsg('提现退回', $_POST, 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'], 'SUCCESS');
                 echo "SUCCESS";
                 exit;
             }
         }
         notifyMsg('提现', $_POST, 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'], '');
     }
 }
 public function ajaxredbag()
 {
     if (!$this->uid) {
         ajaxmsg('未登录不能领取', 0);
     } else {
         //认证 后才能投标
         $pre = C('DB_PREFIX');
         $memberstatus = M("members m")->field("m.id,m.user_leve,m.time_limit,m.pin_pass,s.id_status,s.phone_status,s.email_status,s.video_status,s.face_status,m.user_phone")->join("{$pre}members_status s ON s.uid=m.id")->where("m.id={$this->uid}")->find();
         $rooturl = __ROOT__;
         if ($memberstatus['id_status'] != 1 && empty($memberstatus['user_phone'])) {
             ajaxmsg('进行手机、实名认证后才能领取!', 2);
             exit;
         } else {
             if (empty($memberstatus['user_phone'])) {
                 ajaxmsg('进行手机认证后才能领取!', 2);
                 exit;
             } else {
                 if ($memberstatus['id_status'] != 1) {
                     ajaxmsg('进行实名认证后才能领取!', 3);
                     exit;
                 }
             }
         }
         //$vphone = M('members')->field('user_phone')->find($this->uid);
         //if(empty($vphone['user_phone'])){
         //	ajaxmsg('进行手机认证后才能领取!',2);
         //}
     }
     $redbag = M('redbag')->order('id desc')->where('status=1')->find();
     //判断活动是否存在
     $id = $redbag['id'];
     if (!$id) {
         ajaxmsg('活动不存在', 0);
     }
     $usered = M('redbag_list')->where('uid=' . $this->uid . ' and pid=' . $id)->count();
     //判断是否领过红包
     //已经领取过了
     if ($usered) {
         ajaxmsg('您已经领过了', 0);
     }
     $redinfo = M('redbag_list')->order('id asc')->where('uid=0 and pid=' . $id . ' and status=1')->find();
     //判断是否还有剩余红包
     if ($redbag['prize_num']) {
         $num = M('redbag_list')->where(' pid=' . $id . ' and redtype=1')->count();
         if ($redbag['prize_num'] > $num) {
             if (rand(1, $redbag['bonus_count']) <= $redbag['prize_num']) {
                 $newid = memberMoneyLog($this->uid, 49, $redbag['prize_max'], '领取wap注册红包' . $redbag['prize_max'] . '元');
                 if ($newid) {
                     M('redbag_list')->add(array('money' => $redbag['prize_max'], 'pid' => $id, 'status' => 2, 'redtype' => 1, 'addtime' => time(), 'usetime' => time(), 'uid' => $this->uid));
                     ajaxmsg($redbag['prize_max']);
                 }
             }
         }
     }
     if (!$redinfo) {
         M('redbag')->where('id=' . $id)->save(array('status' => 2));
         ajaxmsg('红包已被抢光', 0);
     }
     $prize = floatval($redinfo['money']);
     $newid = memberMoneyLog($this->uid, 49, $prize, '领取wap注册红包' . $prize . '元');
     if ($newid) {
         M('redbag_list')->where('id=' . $redinfo['id'])->save(array('uid' => $this->uid, 'usetime' => time(), 'status' => 2));
         if (!M('redbag_list')->where('uid=0')->count()) {
             M('redbag')->where('id=' . $id)->save(array('status' => 2));
         }
         ajaxmsg($redinfo['money']);
     } else {
         ajaxmsg('领取失败,请刷新后重试');
     }
 }
 public function doEdit()
 {
     $model = D("member_withdraw");
     $status = intval($_POST['withdraw_status']);
     $id = intval($_POST['id']);
     $deal_info = $_POST['deal_info'];
     $secondfee = floatval($_POST['withdraw_fee']);
     $info = $model->field('add_time')->where("id={$id} and (withdraw_status!=0)")->find();
     if ($info['add_time']) {
         $this->error("此提现初审已处理过,请不要重复处理!");
     }
     if (false === $model->create()) {
         $this->error($model->getError());
     }
     //保存当前数据对象
     $model->withdraw_status = $status;
     $model->deal_info = $deal_info;
     $model->deal_time = time();
     $model->deal_user = session('adminname');
     ////////////////////////
     $field = 'w.*,w.id,w.uid,(mm.account_money+mm.back_money) all_money';
     $vo = M("member_withdraw w")->field($field)->join("lzh_member_money mm on w.uid = mm.uid")->find($id);
     $um = M('members')->field("user_name,user_phone")->find($vo['uid']);
     if ($vo['withdraw_status'] != 3 && $status == 3) {
         addInnerMsg($vo['uid'], "您的提现申请审核未通过", "您的提现申请审核未通过,处理说明:" . $deal_info);
         SMStip("nowithdraw", $um['user_phone'], array("#USERANEM#", "#MONEY#"), array($um['user_name'], $vo['withdraw_money']));
         //memberMoneyLog($vo['uid'],12,$vo['withdraw_money'],"提现未通过,返还",'0','@网站管理员@');
         memberMoneyLog($vo['uid'], 12, $vo['withdraw_money'], "提现未通过,返还", '0', '@网站管理员@', 0, $vo['withdraw_back_money']);
         $model->success_money = 0;
     } else {
         if ($vo['withdraw_status'] != 2 && $status == 2) {
             addInnerMsg($vo['uid'], "您的提现已完成", "您的提现已完成");
             // 统一为;都从当笔提现中扣减手续费
             /*if( ($vo['all_money'] - $vo['second_fee'])<0 ){
             			memberMoneyLog($vo['uid'],29,-($vo['withdraw_money']-$vo['second_fee']),"提现成功,扣除实际手续费".$vo['second_fee']."元,减去冻结资金,到帐金额".($vo['withdraw_money']-$vo['second_fee'])."元",'0','@网站管理员@',0,-$vo['second_fee']);
             			$model->success_money = $vo['withdraw_money'];
             			//SMStip("withdraw",$um['user_phone'],array("#USERANEM#","#MONEY#"),array($um['user_name'],($vo['withdraw_money']-$vo['second_fee'])));
             		}else{
             			memberMoneyLog($vo['uid'],29,-($vo['withdraw_money']),"提现成功,扣除实际手续费".$vo['second_fee']."元,减去冻结资金,到帐金额".($vo['withdraw_money'])."走下",'0','@网站管理员@');
             			$model->success_money = $vo['withdraw_money'];
             			//SMStip("withdraw",$um['user_phone'],array("#USERANEM#","#MONEY#"),array($um['user_name'],$vo['withdraw_money']));
             		}*/
             memberMoneyLog($vo['uid'], 29, -($vo['withdraw_money'] - $vo['second_fee']), "提现成功,扣除手续费" . $vo['second_fee'] . "元,实到帐金额" . ($vo['withdraw_money'] - $vo['second_fee']) . "元", '0', '@网站管理员@', 0, -$vo['second_fee']);
             $model->success_money = $vo['withdraw_money'];
         } elseif ($vo['withdraw_status'] != 1 && $status == 1) {
             addInnerMsg($vo['uid'], "您的提现申请已通过", "您的提现申请已通过,正在处理中");
             // 统一为;都从当笔提现中扣减手续费
             /*if($vo['all_money']  <=$secondfee ){
             			memberMoneyLog($vo['uid'],36,-($vo['withdraw_money']),"提现申请已通过,扣除实际手续费".$secondfee."元,到帐金额".($vo['withdraw_money']-$secondfee)."元",'0','@网站管理员@',-$secondfee);
             			$model->success_money = $vo['withdraw_money']-$secondfee;
             		}else{
             			memberMoneyLog($vo['uid'],36,-$vo['withdraw_money'],"提现申请已通过,扣除实际手续费".$secondfee."元,到帐金额".($vo['withdraw_money'])."元",'0','@网站管理员@',-$secondfee);
             			$model->success_money = $vo['withdraw_money'];
             		}*/
             memberMoneyLog($vo['uid'], 36, -$secondfee, "提现申请已通过,扣除手续费" . $secondfee . "元,到帐金额" . ($vo['withdraw_money'] - $secondfee) . "元", '0', '@网站管理员@', -$secondfee);
             $model->success_money = $vo['withdraw_money'] - $secondfee;
             $model->withdraw_fee = $vo['withdraw_fee'];
             $model->second_fee = $secondfee;
         }
     }
     //////////////////////////
     $result = $model->save();
     if ($result) {
         //保存成功
         alogs("withdraw", $id, $status, $deal_info);
         //管理员操作日志
         //成功提示
         $this->assign('jumpUrl', __URL__);
         $this->success(L('修改成功'));
     } else {
         alogs("withdraw", $id, $status, '提现处理操作失败!');
         //管理员操作日志
         //$this->assign("waitSecond",10000);
         //失败提示
         $this->error(L('修改失败'));
     }
     $vm = M("member_moneylog")->field("info")->where("uid = {$vo['uid']} and type=36")->limit(1)->order('id desc')->select();
     if (!empty($um['user_phone'])) {
         //	sendsms($um['user_phone'],$vm[0]['info']."【友情提醒】");
     }
 }
 protected function lotteryLog($good)
 {
     $log = array();
     $log['uid'] = $this->uid;
     $log['type'] = 2;
     $log['gid'] = $good['id'];
     $log['name'] = $good['title'];
     $log['price'] = $good['value'];
     $log['cost'] = $this->glo['lottery_cost'];
     $log['num'] = 1;
     $log['info'] = "积分抽奖抽中";
     $log['add_ip'] = get_client_ip();
     $log['add_time'] = time();
     $log['status'] = 2;
     //已领取
     $log['way'] = 0;
     //直接领取
     if ($good['category'] == '1') {
         //抽中的是礼金
         memberMoneyLog($this->uid, 45, $good['value'], "积分抽奖抽中‘{$good['title']}’一份");
         //抽中投资礼金
     } else {
         if ($good['category'] == '2') {
             memberIntegralLog($this->uid, 4, $good['value'], "积分抽奖抽中‘{$good['title']}’一份");
             //抽中积分
         } else {
             $log['status'] = 0;
             //未领取
             $log['way'] = 2;
             //快递
         }
     }
     addInnerMsg($this->uid, "积分抽奖抽中‘{$good['title']}’一份", "积分抽奖抽中‘{$good['title']}’一份");
     M("market_log")->add($log);
     //更新奖品列表
     $data = array();
     if ($good['last_num'] - 1 >= 0) {
         $data['last_num'] = $good['last_num'] - 1;
         $data['hits'] = $good['hits'] + 1;
     } else {
         $data['last_num'] = 0;
         $data['hits'] = $good['num'];
         $data['is_sys'] = 0;
     }
     M("market_jifenlist")->where("id={$good['id']}")->save($data);
     return true;
 }
Example #11
0
function investMoney($uid, $borrow_id, $money, $_is_auto = 0, $invest_info_id, $reqext = 0)
{
    //2015-09-30 lj 红包最后一笔扣不了钱
    // require_once('config/config.db.php');
    $pre = DB_PREFIX;
    $done = false;
    $datag = get_global_setting();
    //$fee_invest_manage = explode("|",$datag['fee_invest_manage']);
    /////////////////////////////锁表  zhang 2015-5-5////////////////////////////////////////////////
    $bdb = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PWD);
    $bdb->beginTransaction();
    $bId = $borrow_id;
    $sql = "SELECT suo FROM lzh_borrow_info_lock WHERE id = ? FOR UPDATE";
    $stmt1 = $bdb->prepare($sql);
    $stmt1->bindParam(1, $bId);
    //绑定第一个参数值
    $stmt1->execute();
    /////////////////////////////锁表   zhang 2015-5-5////////////////////////////////////////////////
    $sqlbi = 'SELECT borrow_uid,borrow_money,borrow_interest_rate,borrow_type,borrow_duration,repayment_type,has_borrow,reward_money,money_collect,manage_rate,danbao FROM lzh_borrow_info WHERE id = ? limit 1';
    $stmt2 = $bdb->prepare($sqlbi);
    $stmt2->bindParam(1, $borrow_id);
    $stmt2->execute();
    while ($rowbi = $stmt2->fetch(PDO::FETCH_ASSOC)) {
        $binfo = $rowbi;
    }
    //新加入了奖金reward_money到资金总额里
    $sql = "SELECT m.user_leve,m.time_limit,mm.account_money,mm.back_money,mm.money_collect FROM {$pre}members AS m LEFT JOIN {$pre}member_money mm ON mm.uid=m.id WHERE m.id= ? limit 1";
    $stmt = $bdb->prepare($sql);
    $stmt->bindParam(1, $uid);
    //绑定第一个参数值
    $stmt->execute();
    //        var_dump($stmt2->queryString);
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $vminfo = $row;
    }
    //	$vminfo = getMinfo($uid,'m.user_leve,m.time_limit,mm.account_money,mm.back_money,mm.money_collect');
    //	if(($vminfo['account_money']+$vminfo['back_money']+$binfo['reward_money'])<$money) {
    //		return "您当前的可用金额为:".($vminfo['account_money']+$vminfo['back_money']+$binfo['reward_money'])." 对不起,可用余额不足,不能投标";
    //	}
    //
    //	////////////新增投标时检测会员的待收金额是否大于标的设置的代收金额限制,大于就可投标,小于就不让投标 2013-08-26 fan//////////////
    //
    //	if($binfo['money_collect']>0){//判断是否设置了投标待收金额限制
    //		if($vminfo['money_collect']<$binfo['money_collect']){
    //			return "对不起,此标设置有投标待收金额限制,您当前的待收金额为".$vminfo['money_collect']."元,小于该标设置的待收金额限制".$binfo['money_collect']."元。";
    //		}
    //	}
    ////////////新增投标时检测会员的待收金额是否大于标的设置的代收金额限制,大于就可投标,小于就不让投标 2013-08-26 fan//////////////
    //不同会员级别的费率
    //($vminfo['user_leve']==1 && $vminfo['time_limit']>time())?$fee_rate=($fee_invest_manage[1]/100):$fee_rate=($fee_invest_manage[0]/100);
    $fee_rate = $datag['fee_invest_manage'] / 100;
    //投入的钱
    $havemoney = $binfo['has_borrow'];
    //	if(($binfo['borrow_money'] - $havemoney -$money)<0)
    //	{
    //		return "对不起,此标还差".($binfo['borrow_money'] - $havemoney)."元满标,您最多投标".($binfo['borrow_money'] - $havemoney)."元";
    //	}
    $sql = "SELECT SUM(investor_capital) AS investor_capital FROM {$pre}borrow_investor WHERE borrow_id = ? LIMIT 1";
    $stmt = $bdb->prepare($sql);
    $stmt->bindParam(1, $borrow_id);
    $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $borrow_invest = $row;
    }
    //	$borrow_invest = M("borrow_investor")->where('borrow_id = {$borrow_id}')->sum('investor_capital');//新加投资金额检测
    /***获取积分比率****/
    //        $fee = M('members')->where("id=".$uid)->getField('integral');
    $sql = "SELECT integral FROM {$pre}members WHERE id=? limit 1";
    $stmt = $bdb->prepare($sql);
    $stmt->bindParam(1, $uid);
    $stmt->execute();
    //
    //        file_put_contents('/tmp/444',date('m-d H:i:s')."monthDataDetail".print_r($sql,true)."\n",FILE_APPEND);
    //
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $fee = $row;
    }
    $fs = $fs = (require_once 'config/config.leveinvestconfig.php');
    foreach ($fs as $val) {
        if ($fee > $val['start'] && $fee < $val['end']) {
            $rate = floatval($val['rate']) / 100;
            break;
        }
    }
    /***获取积分比率结束****/
    $investinfo['status'] = 1;
    //等待复审
    $investinfo['borrow_id'] = $borrow_id;
    $investinfo['investor_uid'] = $uid;
    //投资者
    $investinfo['borrow_uid'] = $binfo['borrow_uid'];
    //借款者
    $investinfo['investor_fee'] = $binfo['manage_rate'] * $money;
    //管理费
    if ($binfo['danbao'] != 0) {
        //			$guarrate=M("member_guarrate")->field("guarrate")->where("uid={$binfo['danbao']}")->find();//担保费率
        $sql = "SELECT guarrate FROM {$pre}member_guarrate WHERE uid=? limit 1";
        $stmt = $bdb->prepare($sql);
        $stmt->bindParam(1, $binfo['danbao']);
        $stmt->execute();
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $fee = $row;
        }
        $investinfo['guar_fee'] = $guarrate['guarrate'] * $money / 100;
    }
    /////////////////////////////////////新加投资金额检测/////////////////////////////////////////////
    if ($borrow_invest['investor_capital'] > $binfo['borrow_money']) {
        $investinfo['investor_capital'] = $binfo['borrow_money'] - $binfo['has_borrow'];
    } else {
        $investinfo['investor_capital'] = $money;
    }
    /////////////////////////////////////新加投资金额检测/////////////////////////////////////////////
    $investinfo['is_auto'] = $_is_auto;
    $investinfo['add_time'] = time();
    //还款详细公共信息START
    $handler = mysql_connect(DB_HOST, DB_USER, DB_PWD);
    mysql_select_db(DB_NAME);
    mysql_query("SET AUTOCOMMIT=0");
    //设置为不自动提交,因为MYSQL默认立即执行
    mysql_query("START TRANSACTION");
    //开始事务定义
    //还款概要公共信息START
    $savedetail = array();
    switch ($binfo['repayment_type']) {
        case 1:
            //按天到期还款
            //还款概要START
            $investinfo['investor_interest'] = getFloatValue($binfo['borrow_interest_rate'] / 360 * $investinfo['investor_capital'] * $binfo['borrow_duration'] / 100, 4);
            $investinfo['invest_fee'] = getFloatValue($fee_rate * $investinfo['investor_interest'] * (1 - $rate), 4);
            //修改投资人的天标利息管理费2013-03-19 fan
            $investinfo['invest_fee_yh'] = getFloatValue($fee_rate * $investinfo['investor_interest'], 4);
            //修改投资人的天标利息管理费2013-03-19 fan
            //$invest_info_id = M('borrow_investor')->add($investinfo);
            //				M('borrow_investor')->where("id=".$invest_info_id)->save($investinfo);
            foreach ($investinfo as $key => $val) {
                $upSql .= "{$key}={$val},";
            }
            $upSql = rtrim($upSql, ",");
            $sql = sprintf("UPDATE %s SET {$upSql} where id=%s", "{$pre}borrow_investor", $invest_info_id);
            $rtype = mysql_query($sql);
            //还款概要END
            $investdetail['borrow_id'] = $borrow_id;
            $investdetail['invest_id'] = $invest_info_id;
            $investdetail['investor_uid'] = $uid;
            $investdetail['borrow_uid'] = $binfo['borrow_uid'];
            $investdetail['capital'] = $investinfo['investor_capital'];
            $investdetail['interest'] = $investinfo['investor_interest'];
            $investdetail['interest_fee'] = $fee_rate * $investinfo['invest_fee'] * (1 - $rate);
            $investdetail['interest_fee_yh'] = $fee_rate * $investinfo['invest_fee'];
            $investdetail['status'] = 0;
            $investdetail['sort_order'] = 1;
            $investdetail['total'] = 1;
            $savedetail[] = $investdetail;
            break;
        case 2:
            //每月还款
            //还款概要START
            $monthData['type'] = "all";
            $monthData['money'] = $investinfo['investor_capital'];
            $monthData['year_apr'] = $binfo['borrow_interest_rate'];
            $monthData['duration'] = $binfo['borrow_duration'];
            $repay_detail = EqualMonth($monthData);
            $investinfo['investor_interest'] = $repay_detail['repayment_money'] - $investinfo['investor_capital'];
            $investinfo['invest_fee'] = getFloatValue($fee_rate * $investinfo['investor_interest'] * (1 - $rate), 4);
            $investinfo['invest_fee_yh'] = getFloatValue($fee_rate * $investinfo['investor_interest'], 4);
            //$invest_info_id = M('borrow_investor')->add($investinfo);
            //				M('borrow_investor')->where("id=".$invest_info_id)->save($investinfo);
            foreach ($investinfo as $key => $val) {
                $upSql .= "{$key}={$val},";
            }
            $upSql = rtrim($upSql, ",");
            $sql = sprintf("UPDATE %s SET {$upSql} where id=%s", "{$pre}borrow_investor", $invest_info_id);
            $rtype = mysql_query($sql);
            //还款概要END
            $monthDataDetail['money'] = $investinfo['investor_capital'];
            $monthDataDetail['year_apr'] = $binfo['borrow_interest_rate'];
            $monthDataDetail['duration'] = $binfo['borrow_duration'];
            $repay_list = EqualMonth($monthDataDetail);
            $i = 1;
            //file_put_contents(C('WEB_ROOT').'a.txt', json_encode($repay_list));exit;
            foreach ($repay_list as $key => $v) {
                $investdetail['borrow_id'] = $borrow_id;
                $investdetail['invest_id'] = $invest_info_id;
                $investdetail['investor_uid'] = $uid;
                $investdetail['borrow_uid'] = $binfo['borrow_uid'];
                $investdetail['capital'] = $v['capital'];
                $investdetail['interest'] = $v['interest'];
                $investdetail['interest_fee'] = getFloatValue($fee_rate * $v['interest'] * (1 - $rate), 4);
                $investdetail['interest_fee_yh'] = getFloatValue($fee_rate * $v['interest'], 4);
                $investdetail['status'] = 0;
                $investdetail['sort_order'] = $i;
                $investdetail['total'] = $binfo['borrow_duration'];
                $i++;
                $savedetail[] = $investdetail;
            }
            break;
        case 3:
            //按季分期还款
            //还款概要START
            $monthData['month_times'] = $binfo['borrow_duration'];
            $monthData['account'] = $investinfo['investor_capital'];
            $monthData['year_apr'] = $binfo['borrow_interest_rate'];
            $monthData['type'] = "all";
            $repay_detail = EqualSeason($monthData);
            $investinfo['investor_interest'] = $repay_detail['repayment_money'] - $investinfo['investor_capital'];
            $investinfo['invest_fee'] = getFloatValue($fee_rate * $investinfo['investor_interest'] * (1 - $rate), 4);
            $investinfo['invest_fee_yh'] = getFloatValue($fee_rate * $investinfo['investor_interest'], 4);
            //$invest_info_id = M('borrow_investor')->add($investinfo);
            //				M('borrow_investor')->where("id=".$invest_info_id)->save($investinfo);
            foreach ($investinfo as $key => $val) {
                $upSql .= "{$key}={$val},";
            }
            $upSql = rtrim($upSql, ",");
            $sql = sprintf("UPDATE %s SET {$upSql} where id=%s", "{$pre}borrow_investor", $invest_info_id);
            $rtype = mysql_query($sql);
            //还款概要END
            $monthDataDetail['month_times'] = $binfo['borrow_duration'];
            $monthDataDetail['account'] = $investinfo['investor_capital'];
            $monthDataDetail['year_apr'] = $binfo['borrow_interest_rate'];
            $repay_list = EqualSeason($monthDataDetail);
            $i = 1;
            foreach ($repay_list as $key => $v) {
                $investdetail['borrow_id'] = $borrow_id;
                $investdetail['invest_id'] = $invest_info_id;
                $investdetail['investor_uid'] = $uid;
                $investdetail['borrow_uid'] = $binfo['borrow_uid'];
                $investdetail['capital'] = $v['capital'];
                $investdetail['interest'] = $v['interest'];
                $investdetail['interest_fee'] = getFloatValue($fee_rate * $v['interest'] * (1 - $rate), 4);
                $investdetail['interest_fee_yh'] = getFloatValue($fee_rate * $v['interest'], 4);
                $investdetail['status'] = 0;
                $investdetail['sort_order'] = $i;
                $investdetail['total'] = $binfo['borrow_duration'];
                $i++;
                $savedetail[] = $investdetail;
            }
            break;
        case 4:
            //每月还息到期还本
            $monthData['month_times'] = $binfo['borrow_duration'];
            $monthData['account'] = $investinfo['investor_capital'];
            $monthData['year_apr'] = $binfo['borrow_interest_rate'];
            $monthData['type'] = "all";
            $repay_detail = EqualEndMonth($monthData);
            $investinfo['investor_interest'] = $repay_detail['repayment_account'] - $investinfo['investor_capital'];
            $investinfo['invest_fee'] = getFloatValue($fee_rate * $investinfo['investor_interest'] * (1 - $rate), 4);
            $investinfo['invest_fee_yh'] = getFloatValue($fee_rate * $investinfo['investor_interest'], 4);
            //$invest_info_id = M('borrow_investor')->add($investinfo);
            foreach ($investinfo as $key => $val) {
                $upSql .= "{$key}={$val},";
            }
            $upSql = rtrim($upSql, ",");
            $sql = sprintf("UPDATE %s SET {$upSql} where id=%s", "{$pre}borrow_investor", $invest_info_id);
            $rtype = mysql_query($sql);
            //				M('borrow_investor')->where("id=".$invest_info_id)->save($investinfo);
            //还款概要END
            $monthDataDetail['month_times'] = $binfo['borrow_duration'];
            $monthDataDetail['account'] = $investinfo['investor_capital'];
            $monthDataDetail['year_apr'] = $binfo['borrow_interest_rate'];
            //file_put_contents('/tmp/abc',date('m-d H:i:s')."monthDataDetail".print_r($monthDataDetail,true)."\n",FILE_APPEND);
            $repay_list = EqualEndMonthBYWHH($monthDataDetail);
            //file_put_contents('/tmp/abc',date('m-d H:i:s')."repay_list".print_r($repay_list,true)."\n",FILE_APPEND);
            $i = 1;
            foreach ($repay_list as $key => $v) {
                $investdetail['borrow_id'] = $borrow_id;
                $investdetail['invest_id'] = $invest_info_id;
                $investdetail['investor_uid'] = $uid;
                $investdetail['borrow_uid'] = $binfo['borrow_uid'];
                $investdetail['capital'] = $v['capital'];
                $investdetail['interest'] = $v['interest'];
                $investdetail['interest_fee'] = getFloatValue($fee_rate * $v['interest'] * (1 - $rate), 4);
                $investdetail['interest_fee_yh'] = getFloatValue($fee_rate * $v['interest'], 4);
                $investdetail['status'] = 0;
                $investdetail['sort_order'] = $i;
                $investdetail['total'] = $binfo['borrow_duration'];
                $i++;
                $savedetail[] = $investdetail;
            }
            //	file_put_contents('/tmp/abc',date('m-d H:i:s')."savedetail".print_r($savedetail,true)."\n",FILE_APPEND);
            break;
        case 5:
            //一次性还款
            $monthData['month_times'] = $binfo['borrow_duration'];
            $monthData['account'] = $investinfo['investor_capital'];
            $monthData['year_apr'] = $binfo['borrow_interest_rate'];
            $monthData['type'] = "all";
            $repay_detail = EqualEndMonthOnly($monthData);
            $investinfo['investor_interest'] = $repay_detail['repayment_account'] - $investinfo['investor_capital'];
            $investinfo['invest_fee'] = getFloatValue($fee_rate * $investinfo['investor_interest'] * (1 - $rate), 4);
            $investinfo['invest_fee_yh'] = getFloatValue($fee_rate * $investinfo['investor_interest'], 4);
            //$invest_info_id = M('borrow_investor')->add($investinfo);
            $sql = sprintf("UPDATE %s SET investor_interest =%s,invest_fee =%s,invest_fee_yh=%s where id=%s", "{$pre}borrow_investor", $investinfo['investor_interest'], $investinfo['invest_fee'], $investinfo['invest_fee_yh'], $invest_info_id);
            $rtype = mysql_query($sql);
            //				M('borrow_investor')->where("id=".$invest_info_id)->save($investinfo);
            //还款概要END
            $monthDataDetail['month_times'] = $binfo['borrow_duration'];
            $monthDataDetail['account'] = $investinfo['investor_capital'];
            $monthDataDetail['year_apr'] = $binfo['borrow_interest_rate'];
            $monthDataDetail['type'] = "all";
            $repay_list = EqualEndMonthOnly($monthDataDetail);
            $investdetail['borrow_id'] = $borrow_id;
            $investdetail['invest_id'] = $invest_info_id;
            $investdetail['investor_uid'] = $uid;
            $investdetail['borrow_uid'] = $binfo['borrow_uid'];
            $investdetail['capital'] = $repay_list['capital'];
            $investdetail['interest'] = $repay_list['interest'];
            $investdetail['interest_fee'] = getFloatValue($fee_rate * $repay_list['interest'] * (1 - $rate), 4);
            $investdetail['interest_fee_yh'] = getFloatValue($fee_rate * $repay_list['interest'], 4);
            $investdetail['status'] = 0;
            $investdetail['sort_order'] = 1;
            $investdetail['total'] = 1;
            $savedetail[] = $investdetail;
            break;
    }
    foreach ($savedetail as $key => $val) {
        //			$invest_defail_id = M('investor_detail')->add($val);//保存还款详情
        $vol = ' (' . implode(',', array_keys($val)) . ')';
        $vlaue = ' (' . implode(',', $val) . ')';
        $invest_defail_id = mysql_query("INSERT INTO {$pre}investor_detail {$vol} VALUES {$vlaue}");
    }
    //		$last_have_money = M("borrow_info")->getFieldById($borrow_id,"has_borrow");
    $result = mysql_query("SELECT has_borrow FROM {$pre}borrow_info WHERE id = {$borrow_id}  LIMIT 1");
    while ($row = mysql_fetch_assoc($result)) {
        $last_have_money = $row['has_borrow'];
    }
    //                $last_have_money = $last_have_money['has_borrow'];
    $lasthavemoney = $last_have_money + $money;
    $sql = "update {$pre}borrow_info set `has_borrow`= {$lasthavemoney},borrow_times=borrow_times+1 WHERE `id`={$borrow_id}";
    $upborrow_res = mysql_query($sql);
    //更新投标进度
    if ($invest_defail_id && $rtype && $upborrow_res) {
        //还款概要和详情投标进度都保存成功
        $bdb->commit();
        mysql_query("COMMIT");
        //执行事务
        //		$investMoney->commit();
        file_put_contents('/tmp/4.txt', date('m-d H:i:s') . " comminvest::" . print_r($reqext, true) . "\n", FILE_APPEND);
        $res = memberMoneyLog($uid, 6, -($money - $reqext), "对{$borrow_id}号标进行投标", $binfo['borrow_uid']);
        //($uid,$type,$amoney,$info="",$target_uid="",$target_uname="",$fee=0,$reqext=0){
        $today_reward = explode("|", $datag['today_reward']);
        if ($binfo['repayment_type'] == '1') {
            //如果是天标,则执行1个月的续投奖励利率
            $reward_rate = floatval($today_reward[0]);
        } else {
            if ($binfo['borrow_duration'] == 1) {
                $reward_rate = floatval($today_reward[0]);
            } else {
                if ($binfo['borrow_duration'] == 2) {
                    $reward_rate = floatval($today_reward[1]);
                } else {
                    $reward_rate = floatval($today_reward[2]);
                }
            }
        }
        ////////////////////////////////////////回款续投奖励规则 fan 2013-07-20////////////////////////////
        //$reward_rate = floatval($datag['today_reward']);//floatval($datag['today_reward']);//当日回款续投奖励利率
        if ($binfo['borrow_type'] != 3) {
            //如果是秒标(borrow_type==3),则没有续投奖励这一说
            $vd['add_time'] = array("lt", time());
            $vd['investor_uid'] = $uid;
            //$borrow_invest_count = M("borrow_investor")->where($vd)->count('id');//检测是否投过标且大于一次
            $sqlbic = sprintf("SELECT count(id) AS total FROM %s WHERE investor_uid=%s AND add_time<%s", "{$pre}borrow_investor", $uid, time());
            //                        $borrow_invest_count = mysql_query("SELECT count(id) FROM {$pre}borrow_investor WHERE investor_uid")
            $resultbic = mysql_query($sqlbic);
            while ($rowbic = mysql_fetch_assoc($resultbic)) {
                $borrow_invest_count = $rowbic['total'];
            }
            if ($reward_rate > 0 && $vminfo['back_money'] > 0 && $borrow_invest_count > 0) {
                //首次投标不给续投奖励
                if ($money > $vminfo['back_money']) {
                    //如果投标金额大于回款资金池金额,有效续投奖励以回款金额资金池总额为标准,否则以投标金额为准
                    $reward_money_s = $vminfo['back_money'];
                } else {
                    $reward_money_s = $money;
                }
                $save_reward['borrow_id'] = $borrow_id;
                $save_reward['reward_uid'] = $uid;
                $save_reward['invest_money'] = $reward_money_s;
                //如果投标金额大于回款资金池金额,有效续投奖励以回款金额资金池总额为标准,否则以投标金额为准
                $save_reward['reward_money'] = $reward_money_s * $reward_rate / 1000;
                //续投奖励
                $save_reward['reward_status'] = 0;
                $save_reward['add_time'] = time();
                $save_reward['add_ip'] = get_client_ip();
                //$newidxt = M("today_reward")->add($save_reward);
                $vol = ' (' . implode(',', array_keys($save_reward)) . ')';
                $vlaue = ' (' . implode(',', $save_reward) . ')';
                $invest_defail_id = mysql_query("INSERT INTO {$pre}today_reward {$vol} VALUES {$vlaue}");
            } else {
                $result = true;
            }
        }
        /////////////////////////回款续投奖励结束 2013-05-10 Dqsy///////////////////////////////
        //////////////////////邀请奖励开始////////////////////////////////////////
        $sqlm = sprintf("SELECT user_name,recommend_id,usrid FROM %s WHERE id = %s LIMIT 1", "{$pre}members", $uid);
        $result = mysql_query($sqlm);
        $vo = mysql_fetch_assoc($result);
        //			$vo = M('members')->field('user_name,recommend_id,usrid')->find($uid);
        $sql = sprintf("SELECT usrid FROM %s WHERE id = %s LIMIT 1 ", "{$pre}members", $vo['recommend_id']);
        $result = mysql_query($sql);
        $recommend_usrid = mysql_fetch_assoc($result);
        //			$recommend_usrid = M('members')->field("usrid")->where("id = {$vo['recommend_id']}")->find();
        $_rate = $datag['award_invest'] / 1000;
        //推广奖励
        $jiangli = getFloatValue($_rate * $investinfo['investor_capital'], 2);
        if ($vo['recommend_id'] != 0) {
            $obj = core::Singleton('huifu.huifu');
            $obj->transfer($jiangli, $recommend_usrid['usrid']);
            memberMoneyLog($vo['recommend_id'], 13, $jiangli, $vo['user_name'] . "对{$borrow_id}号标投资成功,你获得推广奖励" . $jiangli . "元。", $uid);
        }
        /////////////////////邀请奖励结束/////////////////////////////////////////
        //$aaa = M('investor_detail')->where('invest_id =2629')->count();
        //if($aaa !=3 ){
        //	exit('aaaaa');
        //}
        if ($lasthavemoney == $binfo['borrow_money']) {
            borrowFull($borrow_id, $binfo['borrow_type']);
            //满标,标记为还款中,更新相关数据
        }
        if (!$res) {
            //没有正常记录和扣除帐户余额的话手动回滚
            //	M('investor_detail')->where("invest_id={$invest_info_id}")->delete();
            //	M('borrow_investor')->where("id={$invest_info_id}")->delete();
            //更新投标进度
            //	$upborrowsql = "update `{$pre}borrow_info` set ";
            //	$upborrowsql .= "`has_borrow`=".$havemoney.",`borrow_times`=`borrow_times`-1";
            //	$upborrowsql .= " WHERE `id`={$borrow_id}";
            //	$upborrow_res = M()->execute($upborrowsql);
            //更新投标进度
            $done = false;
        } else {
            $done = true;
        }
    } else {
        mysql_query("ROOLBACK");
    }
    mysql_query("SET AUTOCOMMIT=1");
    mysql_close($handler);
    return $done;
}
 public function doEdit()
 {
     $id = intval($_POST['id']);
     $status = intval($_POST['status']);
     $statusx = M('member_payonline')->getFieldById($id, "status");
     if ($statusx != 0) {
         $this->error("请不要重复提交表单");
     }
     if ($status == 1) {
         $vo = M('member_payonline')->field('money,fee,uid,way')->find($id);
         $newid = memberMoneyLog($vo['uid'], 27, $vo['money'] - $vo['fee'], "管理员手动审核充值");
         if ($newid) {
             ////////////////////////////
             if ($vo['way'] == "off") {
                 $tqfee = explode("|", $this->glo['offline_reward']);
                 $fee[0] = explode("-", $tqfee[0]);
                 $fee[2] = explode("-", $tqfee[2]);
                 $fee[1] = floatval($tqfee[1]);
                 $fee[3] = floatval($tqfee[3]);
                 $fee[4] = floatval($tqfee[4]);
                 $fee[5] = floatval($tqfee[5]);
                 if ($vo['money'] >= $fee[0][0] && $vo['money'] <= $fee[0][1]) {
                     $fee_rate = 0 < $fee[1] ? $fee[1] / 1000 : 0;
                 } else {
                     if ($vo['money'] >= $fee[2][0] && $vo['money'] <= $fee[2][1]) {
                         $fee_rate = 0 < $fee[3] ? $fee[3] / 1000 : 0;
                     } else {
                         if ($vo['money'] >= $fee[4]) {
                             $fee_rate = 0 < $fee[5] ? $fee[5] / 1000 : 0;
                         } else {
                             $fee_rate = 0;
                         }
                     }
                 }
                 $newidx = memberMoneyLog($vo['uid'], 32, $vo['money'] * $fee_rate, "线下充值奖励");
             }
             /////////////////////////////
             /*
             				$offline_reward = explode("|",$this->glo['offline_reward']);
             				if($vo['money']>$offline_reward[0]){
             					$fee_rate = 0<$offline_reward[1]?($offline_reward[1]/1000):0;
             					$newidx = memberMoneyLog($vo['uid'],32,$vo['money']*$fee_rate,"线下充值奖励");
             				}*/
             $save['deal_user'] = session('adminname');
             $save['deal_uid'] = $this->admin_id;
             $save['status'] = 1;
             M('member_payonline')->where("id={$id}")->save($save);
             $vx = M('members')->field("user_name,user_phone")->find($vo['uid']);
             if ($vo['way'] == "off") {
                 SMStip("payoffline", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $vo['money']));
             } else {
                 SMStip("payonline", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $vo['money']));
             }
             alogs("Paylog", 0, 1, '执行了管理员手动审核充值操作!');
             //管理员操作日志
             $this->success("处理成功");
         } else {
             alogs("Paylog", 0, 1, '执行管理员手动审核充值操作失败!');
             //管理员操作日志
             $this->error("处理失败");
         }
     } else {
         $save['deal_user'] = session('adminname');
         $save['deal_uid'] = $this->admin_id;
         $save['status'] = 3;
         $newid = M('member_payonline')->where("id={$id}")->save($save);
         if ($newid) {
             $this->success("处理成功");
         } else {
             $this->error("处理失败");
         }
     }
 }
Example #13
0
 /**
  * 充值
  * @param unknown_type $post
  */
 public function net_save($post)
 {
     $usrid = $post['UsrCustId'];
     $db = core::Singleton('comm.db.activeRecord');
     $db->connect('CAILAI');
     $info = $db->get_one(array('usrid' => $usrid), '', 'lzh_huifulog');
     $nowtime = time();
     $data = array();
     $data['uid'] = $info['uid'];
     //用户UID
     $data['username'] = $info['username'];
     //用户名
     $data['rescode'] = $post['RespCode'];
     //返回码
     $data['cmdid'] = $post['CmdId'];
     //消息类型
     $data['usrid'] = $post['UsrCustId'];
     //用户客户号
     $data['ordid'] = $post['OrdId'];
     //订单号
     $data['orddate'] = $post['OrdDate'];
     //订单日期
     $data['trxid'] = $post['TrxId'];
     //交易流水号
     $data['addtime'] = $nowtime;
     //记录时间
     $condition['uid'] = $data['uid'];
     $condition['ordid'] = $data['ordid'];
     $num = $db->count_all($condition, 'lzh_huifulog');
     if ($num === 0) {
         $db->insert($data, 'lzh_huifulog');
     }
     if (strcmp($post['RespCode'], "000") == 0) {
         //member_paylog表记录充值日志
         $paylog = array();
         $paylog['uid'] = $info['uid'];
         //用户UID
         $paylog['usrid'] = $post['UsrCustId'];
         //用户客户号
         $paylog['ordid'] = $post['OrdId'];
         //订单号
         $paylog['orddate'] = $post['OrdDate'];
         //订单日期
         $paylog['transamt'] = $post['TransAmt'];
         //充值金额
         $paylog['trxid'] = $post['TrxId'];
         //交易流水号
         $paylog['feeamt'] = $post['FeeAmt'];
         //充值手续费
         $paylog['feecustid'] = $post['FeeCustId'];
         //手续费扣款客户号
         $paylog['feeacctid'] = $post['FeeAcctId'];
         //手续费扣款子账户号
         $paylog['addtime'] = $nowtime;
         //记录时间
         $condition['uid'] = $paylog['uid'];
         $condition['ordid'] = $paylog['ordid'];
         $num = $db->count_all($condition, 'lzh_member_paylog');
         //$num = M("member_paylog")->where($condition)->count();
         //----------------如果用户通过快捷支付的方式,那么相当于绑卡了, by whh 2015-03-05-------------
         if (trim($post['GateBusiId']) == 'QP') {
             $bankdata['uid'] = $info['uid'];
             $bankdata['bank_num'] = $post['CardId'];
             //开户银行帐号
             $bankdata['bank_name'] = $post['GateBankId'];
             //开户银行代号
             $bankdata['add_ip'] = '';
             $bankdata['add_time'] = time();
             //M('member_banks')->add($bankdata);
             $db->insert($bankdata, 'lzh_member_banks');
             unset($bankdata);
         }
         //--------------------------------------------------------------------------------------------
         if ($num == 0) {
             //M("member_paylog")->add($paylog);
             $db->insert($paylog, 'lzh_member_paylog');
             //file_put_contents('/tmp/deal',date('m-d H:i:s')." uid : ".print_r($paylog['uid'],true)."\n",FILE_APPEND);
             //file_put_contents('/tmp/deal',date('m-d H:i:s')." TransAmt : ".print_r(str2val_money($post['TransAmt']),true)."\n",FILE_APPEND);
             //file_put_contents('/tmp/deal',date('m-d H:i:s')." ordid : ".print_r("充值订单号:".$paylog['ordid'],true)."\n",FILE_APPEND);
             //require_once('function/function.comm.php');
             memberMoneyLog($paylog['uid'], 3, str2val_money($post['TransAmt']), "充值订单号:" . $paylog['ordid'], 0, '');
             //                                $info = $db->get_one(array('uid' => $info['uid']), '', 'lzh_member_info');
             //
             $bdb = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PWD);
             $sql = "SELECT real_name FROM lzh_member_info WHERE uid = ? limit 1 ";
             $stmt1 = $bdb->prepare($sql);
             $stmt1->bindParam(1, $info['uid']);
             //绑定第一个参数值
             $stmt1->execute();
             while ($memberd = $stmt1->fetch(PDO::FETCH_ASSOC)) {
                 $memberInfo = $memberd;
             }
             $bdb = null;
             $timeT = date('Y-m-d H:i');
             $sendms = "尊敬的财来网投资人{$memberInfo['real_name']},您于{$timeT}分,在财来网汇付宝充值{$post['TransAmt']}元已到账。请关注投资标的信息。详情请咨询客户经理,或致电400-079-8558";
             //取现成功发送短信
             sendsms($info['username'], $sendms);
             file_put_contents('/tmp/chongzhi.txt', "{$info['username']}:" . print_r($sendms, true) . "\n", FILE_APPEND);
         }
     }
 }
 public function doMoneyEdit()
 {
     $id = intval($_POST['id']);
     $uid = $id;
     $info = text($_POST['info']);
     $done = false;
     if (floatval($_POST['account_money']) != 0) {
         $done = memberMoneyLog($uid, 71, floatval($_POST['account_money']), $info);
     }
     if (floatval($_POST['money_freeze']) != 0) {
         $done = false;
         $done = memberMoneyLog($uid, 72, floatval($_POST['money_freeze']), $info);
     }
     if (floatval($_POST['money_collect']) != 0) {
         $done = false;
         $done = memberMoneyLog($uid, 73, floatval($_POST['money_collect']), $info);
     }
     //记录
     $this->assign('jumpUrl', __URL__ . "/index" . session('listaction'));
     if ($done) {
         alogs("Members", 0, 1, '成功执行了会员余额调整的操作!');
         //管理员操作日志
         $this->success("操作成功");
     } else {
         alogs("Members", 0, 0, '执行会员余额调整的操作失败!');
         //管理员操作日志
         $this->error("操作失败");
     }
 }
Example #15
0
 private function payDone($status, $nid, $oid)
 {
     $done = false;
     $Moneylog = D('member_payonline');
     if ($this->locked) {
         return false;
     }
     $this->locked = true;
     switch ($status) {
         case 1:
             $updata['status'] = $status;
             $updata['tran_id'] = text($oid);
             $vo = M('member_payonline')->field('uid,money,fee,status')->where("nid='{$nid}'")->find();
             //if($vo['status']!=0 || !is_array($vo)) return;
             if (!is_array($vo)) {
                 return false;
             } else {
                 if ($vo['status'] == 1) {
                     return true;
                 }
             }
             $xid = $Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             $tmoney = floatval($vo['money'] - $vo['fee']);
             if ($xid) {
                 $newid = memberMoneyLog($vo['uid'], 3, $tmoney, "充值订单号:" . $oid, 0, '@网站管理员@');
             }
             //更新成功才充值,避免重复充值
             //if(!$newid){
             //	$updata['status'] = 0;
             //	$Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             //	return false;
             //}
             $vx = M("members")->field("user_phone,user_name")->find($vo['uid']);
             SMStip("payonline", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $vo['money']));
             break;
         case 2:
             $updata['status'] = $status;
             $updata['tran_id'] = text($oid);
             $xid = $Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             break;
         case 3:
             $updata['status'] = $status;
             $xid = $Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             break;
     }
     if ($status > 0) {
         if ($xid) {
             $done = true;
         }
     }
     $this->locked = false;
     return $done;
 }
Example #16
0
File: uc.php Project: GStepOne/CI
 function synlogin($get, $post)
 {
     $uid = $get['uid'];
     $username = $get['username'];
     if (!API_SYNLOGIN) {
         return API_RETURN_FORBIDDEN;
     }
     $vo = M("members")->field("id,user_name")->where("user_name='{$username}'")->find();
     if (is_array($vo)) {
         //登陆
         foreach ($vo as $key => $v) {
             session("u_{$key}", $v);
         }
         $up['uid'] = $vo['id'];
         $up['add_time'] = time();
         $up['ip'] = get_client_ip();
         M('member_login')->add($up);
     } else {
         //注册
         require DISCUZ_ROOT . "uc_client/client.php";
         $dataUc = uc_get_user($username);
         $data['user_name'] = text($username);
         $data['user_pass'] = text($get['password']);
         $data['user_email'] = text($dataUc[2]);
         $count = M('members')->where("user_email = '{$data['user_email']}' OR user_name='{$data['user_name']}'")->count('id');
         if ($count > 0) {
             exit;
         }
         $data['reg_time'] = time();
         $data['reg_ip'] = get_client_ip();
         $data['lastlog_time'] = time();
         $data['lastlog_ip'] = get_client_ip();
         $newid = M('members')->add($data);
         if ($newid) {
             session('u_id', $newid);
             session('u_user_name', $data['user_name']);
             Notice(1, $newid);
             memberMoneyLog($newid, 1, $this->glo['award_reg'], "注册奖励");
         }
     }
     header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"');
     _setcookie('Example_auth', _authcode($uid . "\t" . $username, 'ENCODE'));
 }
Example #17
0
/**
* @param intval $uid  用户id
* @param flaot $money 提现金额
* @param string $paypass 支付密码
*/
function checkCash($uid, $money, $paypass)
{
    $pre = C('DB_PREFIX');
    $uid = intval($uid);
    if (!$money && !$paypass) {
        die('数据不完整');
    }
    $paypass = md5($paypass);
    $vo = M('members m')->field('mm.account_money,mm.back_money,(mm.account_money+mm.back_money) all_money,m.user_leve,m.time_limit')->join("{$pre}member_money mm on mm.uid = m.id")->where("m.id={$uid} AND m.pin_pass='******'")->find();
    if (!is_array($vo)) {
        return '支付密码不正确';
    }
    $datag = get_global_setting();
    if ($vo['all_money'] < $money) {
        return "提现额大于帐户余额";
    }
    $start = strtotime(date("Y-m-d", time()) . " 00:00:00");
    $end = strtotime(date("Y-m-d", time()) . " 23:59:59");
    $wmap['uid'] = $uid;
    $wmap['withdraw_status'] = array("neq", 3);
    $wmap['add_time'] = array("between", "{$start},{$end}");
    $today_time = M('member_withdraw')->where($wmap)->count('id');
    $today_money = M('member_withdraw')->where($wmap)->sum('withdraw_money');
    $tqfee = explode("|", $datag['fee_tqtx']);
    $fee[0] = explode("-", $tqfee[0]);
    $fee[1] = explode("-", $tqfee[1]);
    $fee[2] = explode("-", $tqfee[2]);
    $one_limit = $fee[2][0] * 10000;
    $today_limit = $fee[2][1] / $fee[2][0];
    if ($money < 100 || $money > $one_limit) {
        return "单笔提现金额限制为100-{$one_limit}元";
    }
    if ($today_time >= $today_limit) {
        return "一天最多只能提现{$today_limit}次";
    }
    if ($vo['user_leve'] > 0 && $vo['time_limit'] > time()) {
        if ($today_money + $money > $fee[2][1] * 10000) {
            return "单日提现上限为{$fee[2][1]}万元。您今日已经申请提现金额:{$today_money}元,当前申请金额为:{$money}元,已超出单日上限,请您修改申请金额或改日再申请提现";
        }
        $itime = strtotime(date("Y-m", time()) . "-01 00:00:00") . "," . strtotime(date("Y-m-", time()) . date("t", time()) . " 23:59:59");
        $wmapx['uid'] = $uid;
        $wmapx['withdraw_status'] = array("neq", 3);
        $wmapx['add_time'] = array("between", "{$itime}");
        $times_month = M("member_withdraw")->where($wmapx)->count("id");
        $tqfee1 = explode("|", $datag['fee_tqtx']);
        $fee1[0] = explode("-", $tqfee1[0]);
        $fee1[1] = explode("-", $tqfee1[1]);
        if ($money - $vo['back_money'] >= 0) {
            $maxfee1 = ($money - $vo['back_money']) * $fee1[0][0] / 1000;
            if ($maxfee1 >= $fee1[0][1]) {
                $maxfee1 = $fee1[0][1];
            }
            $maxfee2 = $vo['back_money'] * $fee1[1][0] / 1000;
            if ($maxfee2 >= $fee1[1][1]) {
                $maxfee2 = $fee1[1][1];
            }
            $fee = $maxfee1 + $maxfee2;
            $money = $money - $vo['back_money'];
        } else {
            $fee = $vo['back_money'] * $fee1[1][0] / 1000;
            if ($fee >= $fee1[1][1]) {
                $fee = $fee1[1][1];
            }
        }
        if ($vo['all_money'] - $money - $fee < 0) {
            $moneydata['withdraw_money'] = $money;
            $moneydata['withdraw_fee'] = $fee;
            $moneydata['second_fee'] = $fee;
            $moneydata['withdraw_status'] = 0;
            $moneydata['uid'] = $uid;
            $moneydata['add_time'] = time();
            $moneydata['add_ip'] = get_client_ip();
            $newid = M('member_withdraw')->add($moneydata);
            if ($newid) {
                memberMoneyLog($uid, 4, -$money, "提现,默认自动扣减手续费" . $fee . "元", '0', '@网站管理员@', 0);
                MTip('chk6', $uid);
                return 'TRUE';
            }
        } else {
            $moneydata['withdraw_money'] = $money;
            $moneydata['withdraw_fee'] = $fee;
            $moneydata['second_fee'] = $fee;
            $moneydata['withdraw_status'] = 0;
            $moneydata['uid'] = $uid;
            $moneydata['add_time'] = time();
            $moneydata['add_ip'] = get_client_ip();
            $newid = M('member_withdraw')->add($moneydata);
            if ($newid) {
                memberMoneyLog($uid, 4, -$money, "提现,默认自动扣减手续费" . $fee . "元", '0', '@网站管理员@');
                MTip('chk6', $uid);
                return 'TRUE';
            }
        }
    }
    return '申请失败,请重试';
}
Example #18
0
 public function backwithdraw()
 {
     $id = intval($_GET['id']);
     $map['withdraw_status'] = 0;
     $map['uid'] = $this->uid;
     $map['id'] = $id;
     $vo = M('member_withdraw')->where($map)->find();
     if (!is_array($vo)) {
         ajaxmsg('', 0);
     }
     $newid = M('member_withdraw')->where($map)->delete();
     $lm = M('members')->getFieldById($this->uid, 'account_money');
     if ($newid) {
         $res = memberMoneyLog($this->uid, 5, $vo['withdraw_money'], "撤消提现");
     }
     if ($res) {
         ajaxmsg();
     } else {
         ajaxmsg("", 0);
     }
 }
Example #19
0
 public function doEdit()
 {
     $status = intval($_POST['status']);
     $uid = intval($_POST['id']);
     $uif = $_POST['deal_info'];
     if ($status == 1) {
         memberCreditsLog($uid, 2, intval($this->glo["real_score"]), "实名认证通过经验奖励");
         memberScoresLog($uid, 2, intval($this->glo["real_score"]), "实名认证通过积分奖励");
         memberMoneyLog($uid, 25, -$this->glo['fee_idcard'], $info = "实名认证通过");
         $newxid = M("members_status")->where("uid={$uid}")->setField('id_status', 1);
         $dealInfo = M("member_info")->where("uid={$uid}")->setField('deal_info', $uif);
         //deal_info字段存在member_info表
         addInnerMsg($uid, "您的实名认证申请已经通过", "您的实名认证申请已经通过");
     } else {
         $newxid = M("members_status")->where("uid={$uid}")->setField('id_status', 0);
         addInnerMsg($uid, "您的实名认证申请未能通过", "未通过原因:" . $uif);
     }
     if ($newxid) {
         $this->success("审核成功", __URL__ . "/index" . session('listaction'));
     } else {
         $this->error("审核失败");
     }
 }
Example #20
0
 public function doMoneyEdit()
 {
     $id = intval($_POST['id']);
     $uid = $id;
     $info = text($_POST['info']);
     $done = false;
     $token = intval($_POST['token']);
     if ($_SESSION["token"] != $token) {
         $this->error("操作失败,请不要重复提交");
         exit;
     }
     if (floatval($_POST['account_money']) != 0) {
         $done = memberMoneyLog($uid, 71, floatval($_POST['account_money']), $info);
     }
     if (floatval($_POST['money_freeze']) != 0) {
         $done = false;
         $done = memberMoneyLog($uid, 72, floatval($_POST['money_freeze']), $info);
     }
     if (floatval($_POST['money_collect']) != 0) {
         $done = false;
         $done = memberMoneyLog($uid, 73, floatval($_POST['money_collect']), $info);
     }
     //记录
     $_SESSION["token"] = "";
     $this->assign('jumpUrl', __URL__ . "/index" . session('listaction'));
     if ($done) {
         $this->success("操作成功");
     } else {
         $this->error("操作失败");
     }
 }
Example #21
0
 public function doEdit()
 {
     // echo $_POST[deal_info];
     // echo "<br/>";
     $model = D(ucfirst($this->getActionName()));
     if (false === $model->create()) {
         $this->error($model->getError());
     }
     //保存当前数据对象
     if ($result = $model->save()) {
         //保存成功
         if ($_POST['status'] == 1) {
             $vx = M('vip_apply')->field("uid,kfid,deal_info")->find(intval($_POST['id']));
             $uid = $vx['uid'];
             $dealInfo = $vx['deal_info'];
             $datag = get_global_setting();
             $aUser = get_admin_name();
             $newx = memberMoneyLog($uid, 14, -$datag['fee_vip'], "升级VIP成功");
             memberLimitLog($uid, 11, $this->glo['limit_vip'], "VIP审核通过");
             memberCreditsLog($uid, 9, intval($this->glo["vip_exp"]), "VIP审核通过经验奖励");
             memberScoresLog($uid, 9, intval($this->glo["vip_score"]), "VIP审核通过积分奖励");
             addInnerMsg($uid, "您的VIP申请审核已通过", "您的VIP申请审核已通过.");
             $vo = M("members")->field("user_phone,user_name,account_money,recommend_id")->where("id = {$uid}")->find();
             SMStip("vip", $vo['user_phone'], array("#USERANEM#"), array($vo['user_name']), null, array($uid));
             if ($newx) {
                 $xmoney = M('members')->getFieldById($vo['recommend_id'], 'reward_money');
                 memberMoneyLog($vo['recommend_id'], 13, $datag['reward_vip_money'], $vo['user_name'] . "获得被邀请会员VIP升级奖励");
                 $vmo = M('members')->field("user_leve,time_limit,delicated_customer")->find($vx['uid']);
                 $savex['customer_id'] = $vx['kfid'];
                 $savex['customer_name'] = $aUser[$vx['kfid']];
                 $savex['user_leve'] = 1;
                 if (empty($vmo["delicated_customer"])) {
                     $savex['delicated_customer'] = $vx['kfid'];
                 }
                 if ($vmo['time_limit'] > time()) {
                     $savex['time_limit'] = strtotime("+1 year", $vmo['time_limit']);
                 } else {
                     $savex['time_limit'] = strtotime("+1 year");
                 }
                 M('members')->where("id={$uid}")->save($savex);
             }
         } else {
             $vx = M('vip_apply')->field("uid,kfid,deal_info")->find(intval($_POST['id']));
             $uid = $vx['uid'];
             $dealInfo = $vx['deal_info'];
             addInnerMsg($uid, "您的VIP申请审核未通过", "未通过原因:" . $dealInfo);
         }
         //成功提示
         $this->assign('jumpUrl', __URL__ . "/" . session('listaction'));
         $this->success(L('修改成功'));
     } else {
         //失败提示
         $this->error(L('修改失败'));
     }
 }
 private function withdrawDone($status, $nid, $oid)
 {
     $done = false;
     $withdrawlog = D('member_withdraw');
     if ($this->locked) {
         return false;
     }
     $this->locked = true;
     switch ($status) {
         case 1:
             $updata['status'] = $status;
             $updata['tran_id'] = text($oid);
             $vo = M('member_withdraw')->field('uid,money,fee,status')->where("nid='{$nid}'")->find();
             if ($vo['status'] != 0 || !is_array($vo)) {
                 return;
             }
             $xid = $withdrawlog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             $tmoney = floatval($vo['money'] - $vo['fee']);
             memberMoneyLog($this->uid, 4, -$withdraw_money, "提现,默认自动扣减手续费" . $fee . "元", '0', '@网站管理员@', 0);
             MTip('chk6', $this->uid);
             //if(!$newid){
             //	$updata['status'] = 0;
             //	$Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             //	return false;
             //}
             //$vx = M("members")->field("user_phone,user_name")->find($vo['uid']);
             //SMStip("payonline",$vx['user_phone'],array("#USERANEM#","#MONEY#"),array($vx['user_name'],$vo['money']));
             break;
         case 2:
             $updata['status'] = $status;
             $updata['tran_id'] = text($oid);
             $xid = $withdrawlog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             break;
         case 3:
             $updata['status'] = $status;
             $xid = $withdrawlog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             break;
     }
     if ($status > 0) {
         if ($xid) {
             $done = true;
         }
     }
     $this->locked = false;
     return $done;
 }
Example #23
0
function borrowApproved($borrow_id)
{
    $pre = C('DB_PREFIX');
    $done = false;
    $borrowInvestor = D('borrow_investor');
    $binfo = M("borrow_info")->field("borrow_name,borrow_type,reward_type,reward_num,borrow_fee,borrow_money,borrow_uid,borrow_duration,repayment_type")->find($borrow_id);
    $investorList = $borrowInvestor->field('id,investor_uid,investor_capital,investor_interest')->where("borrow_id={$borrow_id}")->select();
    $endTime = strtotime(date("Y-m-d", time()) . " 23:59:59");
    if ($binfo['repayment_type'] == 1) {
        $deadline_last = strtotime("+{$binfo['borrow_duration']} day", $endTime);
    } else {
        $deadline_last = strtotime("+{$binfo['borrow_duration']} month", $endTime);
    }
    $borrowInvestor->startTrans();
    //更新投资概要
    $_investor_num = count($investorList);
    foreach ($investorList as $key => $v) {
        if ($binfo['reward_type'] > 0) {
            if ($binfo['reward_type'] == 1) {
                $_reward_money = getFloatValue($v['investor_capital'] * $binfo['reward_num'] / 100, 4);
            } elseif ($binfo['reward_type'] == 2) {
                $_reward_money = getFloatValue($binfo['reward_num'] / $_investor_num, 4);
            }
        }
        $investorList[$key]['reward_money'] = floatval($_reward_money);
        MTip('chk14', $v['investor_uid'], $borrow_id);
        //sss
        $saveinfo = array();
        $saveinfo['id'] = $v['id'];
        $saveinfo['reward_money'] = floatval($_reward_money);
        $saveinfo['deadline'] = $deadline_last;
        $saveinfo['status'] = 4;
        //还款中
        $upsummary_res = $borrowInvestor->save($saveinfo);
    }
    //邮件提醒
    $subject = "您投标的借款[" . $binfo['borrow_name'] . "]成功了";
    $link = '<br /><a href="http://' . $_SERVER['HTTP_HOST'] . '/invest/' . $borrow_id . '.html" style="color:#91273d">点击查看[' . $binfo['borrow_name'] . ']</a>';
    investEmail($subject, $subject . $link, 'chk14', "investsuccess_2", $borrow_id);
    //更新投资概要
    //更新借款信息
    $upborrow_res = M()->execute("update `{$pre}borrow_info` set `deadline`={$deadline_last} WHERE `id`={$borrow_id}");
    //更新借款信息
    //更新投资详细
    switch ($binfo['repayment_type']) {
        case 2:
            //每月还款
        //每月还款
        case 3:
            //每季还本
        //每季还本
        case 4:
            //期未还本
            for ($i = 1; $i <= $binfo['borrow_duration']; $i++) {
                $deadline = 0;
                $deadline = strtotime("+{$i} month", $endTime);
                $updetail_res = M()->execute("update `{$pre}investor_detail` set `deadline`={$deadline},`status`=7 WHERE `borrow_id`={$borrow_id} AND `sort_order`={$i}");
            }
            break;
        case 1:
            //按天一次性还款
            $deadline = 0;
            $deadline = $deadline_last;
            $updetail_res = M()->execute("update `{$pre}investor_detail` set `deadline`={$deadline},`status`=7 WHERE `borrow_id`={$borrow_id}");
            break;
    }
    //更新投资详细
    if ($updetail_res !== false && $upsummary_res !== false && $upborrow_res !== false) {
        $done = true;
        $borrowInvestor->commit();
        //借款者帐户
        $_P_fee = get_global_setting();
        $_borraccount = memberMoneyLog($binfo['borrow_uid'], 17, $binfo['borrow_money'], "第{$borrow_id}号标复审通过,借款金额入帐");
        //借款入帐
        if (!$_borraccount) {
            return false;
        }
        //借款者帐户处理出错
        $_borrfee = memberMoneyLog($binfo['borrow_uid'], 18, -$binfo['borrow_fee'], "第{$borrow_id}号标借款成功,扣除借款管理费");
        //借款
        if (!$_borrfee) {
            return false;
        }
        //借款者帐户处理出错
        $_freezefee = memberMoneyLog($binfo['borrow_uid'], 19, -$binfo['borrow_money'] * $_P_fee['money_deposit'] / 100, "第{$borrow_id}号标借款成功,冻结{$_P_fee['money_deposit']}%的保证金");
        //冻结保证金
        if (!$_freezefee) {
            return false;
        }
        //借款者帐户处理出错
        //借款者帐户
        //投资者帐户
        $_investor_num = count($investorList);
        $_remoney_do = true;
        foreach ($investorList as $v) {
            //投标奖励
            if ($v['reward_money'] > 0) {
                $_remoney_do = false;
                $_reward_m = memberMoneyLog($v['investor_uid'], 20, $v['reward_money'], "第{$borrow_id}号标复审通过,获取投标奖励", $binfo['borrow_uid']);
                $_reward_m_give = memberMoneyLog($binfo['borrow_uid'], 21, -$v['reward_money'], "第{$borrow_id}号标复审通过,支付投标奖励", $v['investor_uid']);
                if ($_reward_m && $_reward_m_give) {
                    $_remoney_do = true;
                }
            }
            //投标奖励
            $remcollect = memberMoneyLog($v['investor_uid'], 15, $v['investor_capital'], "第{$borrow_id}号标复审通过,冻结本金成为待收金额", $binfo['borrow_uid']);
            $reinterestcollect = memberMoneyLog($v['investor_uid'], 28, $v['investor_interest'], "第{$borrow_id}号标复审通过,应收利息成为待收金额", $binfo['borrow_uid']);
            //////////////////////邀请奖励开始////////////////////////////////////////
            /*
            $vo = M('members')->field('user_name,recommend_id')->find($v['investor_uid']);
            $_rate = $_P_fee['award_invest']/1000;//推广奖励
            if($vo['recommend_id']!=0){
            	if(($binfo['borrow_type']=='1' || $binfo['borrow_type']=='2' || $binfo['borrow_type']=='5' || $binfo['borrow_type']=='6') ){
            		if($binfo['repayment_type']!='1')$jiangli = round($_rate * $v['investor_capital'],2);
            		else $jiangli = round($_rate * $v['investor_capital'] * $binfo['borrow_duration'] / 30, 2);
            		memberMoneyLog($vo['recommend_id'],13,$jiangli,$vo['user_name']."对{$borrow_id}号标投资成功,你获得推广奖励".$jiangli."元。",$v['investor_uid']);
            	}
            }
            */
            /////////////////////邀请奖励结束/////////////////////////////////////////
            //投标经验跟积分
            memberCreditsLog($v['investor_uid'], 10, $v['investor_capital'], "投资经验奖励", "borrow_investor" . "_" . $v["id"]);
            memberScoresLog($v['investor_uid'], 10, $v['investor_capital'] / 10, "投资积分奖励", "borrow_investor" . "_" . $v["id"]);
        }
        if (!$_remoney_do || !$remcollect || !$reinterestcollect) {
            return false;
        }
        //投资者帐户处理出错
        //投资者帐户
    } else {
        $borrowInvestor->rollback();
    }
    return $done;
}
Example #24
0
 private function payDone($status, $nid, $oid, $payResult = "")
 {
     $done = false;
     $Moneylog = M('member_payonline');
     if ($this->locked) {
         return false;
     }
     $this->locked = true;
     $Moneylog->startTrans();
     $vo = $Moneylog->lock(true)->field('uid,money,fee,status')->where("nid='{$nid}'")->find();
     if (!is_array($vo) || $vo['status'] == 1) {
         $Moneylog->commit();
         return $done;
     }
     switch ($status) {
         case 1:
             $updata['status'] = $status;
             $updata['tran_id'] = text($oid);
             $updata['pay_result'] = $payResult;
             $xid = $Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             $tmoney = floatval($vo['money'] - $vo['fee']);
             if ($xid) {
                 $newid = memberMoneyLog($vo['uid'], 3, $tmoney, "充值订单号:" . $oid);
             }
             //更新成功才充值,避免重复充值
             if (!$newid) {
                 $updata['status'] = 0;
                 $Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
                 $Moneylog->commit();
                 return false;
             }
             MTip("payonline", $vo['uid'], $vo['money']);
             break;
         case 2:
             $updata['status'] = $status;
             $updata['tran_id'] = text($oid);
             $updata['pay_result'] = $payResult;
             $xid = $Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             break;
         case 3:
             $updata['status'] = $status;
             $updata['pay_result'] = $payResult;
             $xid = $Moneylog->where("uid={$vo['uid']} AND nid='{$nid}'")->save($updata);
             break;
     }
     if ($status > 0) {
         if ($xid) {
             $done = true;
         }
     }
     $Moneylog->commit();
     $this->locked = false;
     return $done;
 }
 public function editalipay()
 {
     if ($this->isPost()) {
         $savedata['id'] = $this->_post("id");
         $savedata['status'] = $this->_post("status");
         if ($savedata['status'] == 2) {
             $alimodel = M("member_alipay");
             $alipay = $alimodel->find($savedata['id']);
             memberMoneyLog($alipay['uid'], 54, $alipay['money'], "支付宝充值");
             $ret = $alimodel->save($savedata);
             $offl['uid'] = $alipay['uid'];
             $offl['nid'] = 'alipay';
             $offl['money'] = $alipay['money'];
             $offl['fee'] = 0;
             $offl['way'] = 'alipay';
             $offl['status'] = '1';
             $offl['add_time'] = time();
             $offl['add_ip'] = get_client_ip();
             $offl['tran_id'] = "";
             $offl['off_bank'] = "";
             $offl['off_way'] = "";
             $offl['deal_user'] = "";
             $offl['deal_user'] = session('adminname');
             $offl['deal_uid'] = $this->admin_id;
             $offl['payimg'] = "";
             M("member_payonline")->add($offl);
             if ($ret) {
                 $vx = M('members')->field("user_name,user_phone")->find($offl['uid']);
                 SMStip("alipay", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $offl['money']));
                 //					$info = '您在手投网股票配资平台支付宝充值'.$offl['money'].'元已充值成功!【手投网】';
                 //					$ret = sendsms($vx['user_phone'],$info);
                 $this->success("操作成功!");
             } else {
                 $this->error("操作失败!");
             }
         } else {
             $ret = M("member_alipay")->save($savedata);
             $alimodel = M("member_alipay");
             $alipay = $alimodel->find($savedata['id']);
             $offl['uid'] = $alipay['uid'];
             $offl['nid'] = 'alipay';
             $offl['money'] = $alipay['money'];
             $offl['fee'] = 0;
             $offl['way'] = 'alipay';
             $offl['status'] = 3;
             $offl['add_time'] = time();
             $offl['add_ip'] = get_client_ip();
             $offl['tran_id'] = "";
             $offl['off_bank'] = "";
             $offl['off_way'] = "";
             $offl['deal_user'] = "";
             $offl['deal_user'] = session('adminname');
             $offl['deal_uid'] = $this->admin_id;
             $offl['payimg'] = "";
             M("member_payonline")->add($offl);
             if ($ret) {
                 $vx = M('members')->field("user_name,user_phone")->find($offl['uid']);
                 SMStip("noalipay", $vx['user_phone'], array("#USERANEM#", "#MONEY#"), array($vx['user_name'], $offl['money']));
                 $this->success("操作成功!");
             } else {
                 $this->error("操作失败!");
             }
         }
     } else {
         $this->display();
     }
 }
 public function buya($paypass, $invest_id)
 {
     $check_result = $this->checkBuya($paypass, $invest_id);
     //dump($check_result);die;
     if ($check_result === 'TRUE') {
         $debt_info = $this->Model->field("transfer_price, sell_uid, money")->where("invest_id={$invest_id}")->find();
         $buy_user = M("member_money")->field("account_money, back_money, money_collect")->where("uid={$this->uid}")->find();
         $sell_user = M("member_money")->field("account_money, money_collect")->where("uid={$debt_info['sell_uid']}")->find();
         if ($debt_info['transfer_price'] > $buy_user['account_money'] + $buy_user['back_money']) {
             return 'insufficient_account_balance';
         }
         $buy_user['back_money'] = $buy_user['back_money'] - $debt_info['transfer_price'];
         if ($buy_user['back_money'] < 0) {
             $buy_user['account_money'] = $buy_user['account_money'] + $buy_user['back_money'];
             $buy_user['back_money'] = 0;
         }
         $buy_user['money_collect'] += $debt_info['money'];
         // 转让手续费扣除
         $datag = get_global_setting();
         $debt_fee = $datag['debt_fee'];
         // 百分比
         $fee = round($debt_info['transfer_price'] * $debt_fee / 100, 2);
         //转让方增加资金
         $sell_user['account_money'] += $debt_info['transfer_price'] - $fee;
         $sell_user['money_collect'] = $sell_user['money_collect'] - $debt_info['money'];
         // 减去待收
         // 转让序列号
         $serial = "ZQZR-" . date("YmdHis") . mt_rand(1000, 9999);
         $serialid_count = $this->Model->where("serialid>{$serial}")->count();
         $serialid = $serial + $serialid_count + 1;
         $debt = array('buy_time' => time(), 'buy_uid' => $this->uid, 'status' => 1, 'serialid' => $serialid);
         $this->Model->startTrans();
         //$investor_status = M("borrow_investor")->where("id={$invest_id}")->save(array('debt_uid'=>$this->uid));
         //$detail_status = M("investor_detail")->where("invest_id={$invest_id} and status in (6,7,0)")->save(array('investor_uid'=>$this->uid));
         $debt_status = $this->Model->where("invest_id={$invest_id}")->save($debt);
         $sell_user_status = M("member_money")->where("uid={$debt_info['sell_uid']}")->save($sell_user);
         $buy_user_status = M("member_money")->where("uid={$this->uid}")->save($buy_user);
         if ($debt_status && $sell_user_status && $buy_user_status) {
             $this->Model->commit();
             $this->moneyLog($this->uid, 46, -$debt_info['transfer_price'], $debt_info['money'], "购买{$serialid}号债权", $debt_info['sell_uid']);
             $this->moneyLog($debt_info['sell_uid'], 47, $debt_info['transfer_price'], $debt_info['money'], "转让{$serialid}号债权", $this->uid);
             memberMoneyLog($debt_info['sell_uid'], 48, -$fee, "转让{$serialid}号债权手续费(转让金额的{$debt_fee}%)");
             //return 'TRUE';
             return '购买成功';
         } else {
             $this->Model->rollback();
             //return 'buy_error';
             return '购买失败';
         }
     } else {
         return $check_result;
     }
 }
 protected function sendPrize($vo, $dd)
 {
     $vo['prize'] = floatval($vo['prize']);
     $newid = memberMoneyLog($vo['uid'], 55, $vo['prize'], $vo['adesc']);
     if ($newid) {
         $data = array();
         $data['username'] = $vo['name'];
         $data['uid'] = $vo['uid'];
         $data['dateline'] = time();
         $data['prize'] = $vo['prize'];
         $data['art_info'] = $vo['adesc'];
         $data['pid'] = $dd['id'];
         M('activity_diy_log')->add($data);
         //SMStip("diyactivity",$vo['phone'],array("#ITEMNAME#,#USERANEM#","#MONEY#"),array($dd['art_title'],$vo['name'],$vo['prize']));
         alogs("Paylog", 0, 1, '执行了管理员发放活动奖励!' . $dd['art_title']);
         //管理员操作日志
         return true;
     } else {
         alogs("Paylog", 0, 1, '执行了管理员发放活动奖励!');
         //管理员操作日志
         return false;
     }
 }
Example #28
0
 public function loansreturn()
 {
     file_put_contents('/tmp/debugwhh', date('m-d H:i:s') . "\$_POST:" . print_r($_POST, true) . "\n", FILE_APPEND);
     if (strcmp($_POST['RespCode'], "000") == 0) {
         $mem = new Memcache();
         $mem->connect("127.0.0.1", 11211);
         $key = 'loansreturn-' . $_POST['CmdId'] . '-' . $_POST['OutCustId'];
         $has = $mem->get($key);
         if ($has) {
             sleep(1);
             //return ;
         } else {
             //设置4秒
             $mem->set($key, 1, 0, 1);
         }
         unset($mem, $has, $key);
     }
     $usrid = $_POST['OutCustId'];
     $info = M("huifulog")->distinct(true)->field("uid,username")->where("usrid=" . $usrid)->find();
     $data = array();
     $data['uid'] = $info['uid'];
     //用户UID
     $data['username'] = $info['username'];
     //用户名
     $data['rescode'] = $_POST['RespCode'];
     //返回码
     $data['cmdid'] = $_POST['CmdId'];
     //消息类型
     $data['usrid'] = $_POST['OutCustId'];
     //用户客户号(出账人客户号)
     $data['ordid'] = $_POST['OrdId'];
     //订单号
     $data['orddate'] = $_POST['OrdDate'];
     //订单日期
     $data['trxid'] = "";
     $data['merpriv'] = $_POST['MerPriv'];
     $data['addtime'] = time();
     //记录时间
     //解冻金额是否减掉
     $reqext = 0;
     $reqext = $_POST['RespExt'];
     //代金券的内容json字符串
     $reqext = json_decode(urldecode($reqext), 1);
     $reqext = $reqext['LoansVocherAmt'];
     file_put_contents('/tmp/debugwhh', date('m-d H:i:s') . "reqext:" . print_r($reqext, true) . "\n", FILE_APPEND);
     $condition['uid'] = $data['uid'];
     $condition['ordid'] = $data['ordid'];
     $num = M("huifulog")->where($condition)->count();
     $md = M()->getLastSql();
     file_put_contents('/tmp/debugwhh', date('m-d H:i:s') . "\\md:" . print_r($md, true) . "\n", FILE_APPEND);
     if ($num == 0) {
         M("huifulog")->add($data);
         if (strcmp($_POST['RespCode'], "000") == 0) {
             $temp = base64_decode($data['merpriv']);
             $pos1 = strpos($temp, '{');
             $pos2 = strpos($temp, '}');
             $len = $pos2 - $pos1 + 1;
             $merpriv = substr($temp, $pos1, $len);
             $merpriv = json_decode($merpriv, true);
             $borrowid = $merpriv['borrowid'];
             //标ID
             $investid = $merpriv['investid'];
             //投资ID
             $binfo = M("borrow_info")->field("borrow_type,reward_type,reward_num,borrow_fee,borrow_money,borrow_uid,borrow_duration,repayment_type,manage_rate")->find($borrowid);
             //还款时间
             $endTime = strtotime(date("Y-m-d", time()) . " 23:59:59");
             //逾期时刻
             if ($binfo['borrow_type'] == 3 || $binfo['repayment_type'] == 1) {
                 $deadline = strtotime("+{$binfo['borrow_duration']} day", $endTime);
                 //天标或秒标
             } else {
                 $deadline = strtotime("+{$binfo['borrow_duration']} month", $endTime);
                 //月标
             }
             //更新投资信息
             $investinfo = array();
             $investinfo['deadline'] = $deadline;
             $investinfo['status'] = 4;
             //复审通过,还款中
             M("borrow_investor")->where("id=" . $investid)->save($investinfo);
             //更新还款信息
             switch ($binfo['repayment_type']) {
                 case 2:
                     //每月还款
                 //每月还款
                 case 3:
                     //每季还本
                 //每季还本
                 case 4:
                     //期未还本
                     for ($i = 1; $i <= $binfo['borrow_duration']; $i++) {
                         $repaymentinfo = array();
                         $deadlines = strtotime("+{$i} month", $endTime);
                         //月还款时间
                         $repaymentinfo['deadline'] = $deadlines;
                         $repaymentinfo['status'] = 7;
                         //复审通过,还款中
                         M("investor_detail")->where("invest_id={$investid} AND  `sort_order` ={$i}")->save($repaymentinfo);
                     }
                     break;
                 case 1:
                     //按天一次性还款
                 //按天一次性还款
                 case 5:
                     //一次性还款
                     $repaymentinfo = array();
                     $repaymentinfo['deadline'] = $deadline;
                     //一次性还款时间
                     $repaymentinfo['status'] = 7;
                     //复审通过,还款中
                     M("investor_detail")->where("invest_id=" . $investid)->save($repaymentinfo);
                     break;
             }
             //解冻保证金要减去代金券 20150831
             if ($reqext) {
                 $investor_capital = str2val_money($_POST['TransAmt'] - $reqext);
                 $tip = "第{$borrowid}号标复审通过,冻结本金成为待收金额.使用代金券{$reqext}元";
             } else {
                 $investor_capital = str2val_money($_POST['TransAmt']);
                 $tip = "第{$borrowid}号标复审通过,冻结本金成为待收金额.";
             }
             //因为要给代收金额加上代金券的钱 所以要添加一个变量。20150831 by lj
             memberMoneyLog($data['uid'], 15, $investor_capital, $tip, $binfo['borrow_uid'], '', 0, $reqext);
             file_put_contents('/tmp/debugwhh', date('m-d H:i:s') . "is_null_req:" . print_r($reqext, true) . "\n", FILE_APPEND);
             $daishou = M('investor_detail')->field('interest')->where("investor_uid = {$data['uid']} and borrow_id = {$borrowid} and invest_id ={$investid}")->sum('interest');
             memberMoneyLog($data['uid'], 28, $daishou, "第{$borrowid}号标复审通过,应收利息成为待收利息", $binfo['borrow_uid']);
             //memberMoneyLog($vo['recommend_id'],13,$jiangli,$vo['user_name']."对{$borrow_id}号标投资成功,你获得推广奖励".$jiangli."元。",$v['investor_uid']);
             $id = M("borrow_investor")->field('id')->where("borrow_id=" . $borrowid)->order('id desc')->find();
             if ($id['id'] == $investid) {
                 $borrowinfo = array();
                 $borrowinfo['deadline'] = $deadline;
                 $borrowinfo['borrow_status'] = 6;
                 M("borrow_info")->where("id=" . $borrowid)->save($borrowinfo);
                 //更新借款信息
                 //投标代金券放入客户代收金额*/
                 memberMoneyLog($binfo['borrow_uid'], 17, $binfo['borrow_money'], "第{$borrowid}号标复审通过,借款金额入帐");
                 //投标代金券放入客户代收金额结束*/
                 $total = M("borrow_info")->field("danbao,borrow_money")->where("id=" . $borrowid)->find();
                 //如果担保公司存在
                 if ($total['danbao'] != 0) {
                     $Guar = M('members')->field("usrid,id")->where("id = " . $total['danbao'])->find();
                     $guar_rate = M('member_guarrate')->where("uid = " . $total['danbao'])->find();
                     //担保费率
                     $rates_fee = $guar_rate['guarrate'] * $binfo['borrow_money'] / 100;
                     memberMoneyLog($binfo['borrow_uid'], 104, -$rates_fee, "第{$borrowid}号标借款成功,扣除担保费");
                     //借款者付出担保费
                     memberMoneyLog($Guar['id'], 105, $rates_fee, "第{$borrowid}号标借款成功,获得担保费");
                     //担保者获得担保费
                 }
                 memberMoneyLog($binfo['borrow_uid'], 18, -$binfo['borrow_fee'], "第{$borrowid}号标借款成功,扣除借款管理费");
                 //借款保证金
                 $_P_fee = get_global_setting();
                 $info1 = M("members")->field("usrid")->find($binfo['borrow_uid']);
                 $usrid = $info1['usrid'];
                 $transamt = $_P_fee['money_deposit'] * $total['borrow_money'] / 100;
                 import("ORG.Huifu.Huifu");
                 $huifu = new Huifu();
                 $huifu->usrFreezeBg($usrid, $transamt, $borrowid);
             }
         }
         echo "RECV_ORD_ID_" . $_POST['OrdId'];
     }
 }
 public function backwithdraw()
 {
     $id = intval($_GET['id']);
     $map['withdraw_status'] = 0;
     $map['uid'] = $this->uid;
     $map['id'] = $id;
     $vo = M('member_withdraw')->where($map)->find();
     if (!is_array($vo)) {
         ajaxmsg('', 0);
     }
     ///////////////////////////////////////////////
     $field = "(mm.account_money+mm.back_money) all_money,mm.account_money,mm.back_money";
     $m = M('member_money mm')->field($field)->where("mm.uid={$this->uid}")->find();
     ////////////////////////////////////////////////////
     $newid = M('member_withdraw')->where($map)->delete();
     if ($newid) {
         $res = memberMoneyLog($this->uid, 5, $vo['withdraw_money'], "撤消提现", '0', '@网站管理员@');
     }
     if ($res) {
         ajaxmsg();
     } else {
         ajaxmsg("", 0);
     }
 }
 public function doEdit()
 {
     $model = D(ucfirst($this->getActionName()));
     $info = $model->field('deal_time')->where('id=' . intval($_POST['id']))->find();
     if ($info['deal_time']) {
         $this->error("此申请已处理过,请不要重复提交!");
     }
     if (false === $model->create()) {
         $this->error($model->getError());
     }
     $model->deal_time = time();
     $model->deal_user = session('admin_id');
     //保存当前数据对象
     if ($result = $model->save()) {
         //保存成功
         if ($_POST['status'] == 1) {
             $vx = M('vip_apply')->field("uid,kfid")->find(intval($_POST['id']));
             $uid = $vx['uid'];
             $datag = get_global_setting();
             $aUser = get_admin_name();
             $result = memberMoneyLog($uid, 14, -$datag['fee_vip'], "升级VIP成功");
             $newx = setMemberStatus($uid, 'vip', $_POST['status'], 13, 'vip');
             memberLimitLog($uid, 11, $this->glo['limit_vip'], "VIP审核通过");
             addInnerMsg($uid, "您的VIP申请审核已通过", "您的VIP申请审核已通过");
             $vo = M("members")->field("user_phone,user_name,recommend_id")->where("id = {$uid}")->find();
             SMStip("vip", $vo['user_phone'], array("#USERANEM#"), array($vo['user_name']));
             if ($newx) {
                 $vmo = M('members')->field("user_leve,time_limit")->find($vx['uid']);
                 $savex['customer_id'] = $vx['kfid'];
                 $savex['customer_name'] = $aUser[$vx['kfid']];
                 $savex['user_leve'] = 1;
                 if ($vmo['time_limit'] > time()) {
                     $savex['time_limit'] = strtotime("+1 year", $vmo['time_limit']);
                 } else {
                     $savex['time_limit'] = strtotime("+1 year");
                 }
                 M('members')->where("id={$uid}")->save($savex);
             }
             alogs("Vipapply", 0, 1, 'VIP申请审核通过!');
             //管理员操作日志
         } else {
             addInnerMsg($uid, "您的VIP申请审核未通过", "您的VIP申请审核未通过");
             alogs("Vipapply", 0, 0, 'VIP申请审核未通过!');
             //管理员操作日志
         }
         //成功提示
         $this->assign('jumpUrl', __URL__);
         $this->success(L('修改成功'));
     } else {
         //失败提示
         $this->error(L('修改失败'));
     }
 }