public function save()
{
if ($_SESSION['verify'] != md5($_POST['txt_check'])) {
$this->error('验证码错误');
}
$_POST = textPost($_POST);
$model = M('rongzi');
if (false === $model->create()) {
$this->error($model->getError());
}
unset($model->status);
//$model->msg = "借款金额：".text($_POST['money'])." ".$model->msg;
$model->add_time = time();
$model->ip = get_client_ip();
//保存当前数据对象
if ($result = $model->add()) {
//保存成功
//成功提示
$this->assign('jumpUrl', __APP__ . "/rongzi/index");
$this->success('反馈成功');
} else {
//失败提示
$this->error('反馈失败，请重试');
}
}
public function doedit()
{
$model = D('Auto_borrow');
$_X = array('my_friend', 'not_black', 'borrow_credit_status', 'apr_status', 'award_status');
foreach ($_X as $ve) {
if (!isset($_POST[$ve])) {
$_POST[$ve] = 0;
}
}
$savedata = textPost($_POST);
$savedata['uid'] = $this->uid;
if (false === $model->create($savedata)) {
$this->error($model->getError());
} elseif ($result = $model->save()) {
$this->success("修改成功", __URL__ . "/index.html");
} else {
$this->assign("waitSecond", 10000);
$this->error("修改失败");
}
}
public function editensure()
{
$model = M('member_ensure_info');
if (!$_POST) {
$vo = $model->find($this->uid);
if (!is_array($vo)) {
$model->add(array('uid' => $this->uid));
} else {
$this->assign('vo', $vo);
}
$json['html'] = $this->fetch();
exit(json_encode($json));
}
$savedata = textPost($_POST);
$savedata['uid'] = $this->uid;
if (false === $model->create($savedata)) {
$this->error($model->getError());
} elseif ($result = $model->save()) {
if ($nid) {
$json['message'] = "修改成功";
} else {
$json['message'] = "修改成功";
}
$json['status'] = 1;
exit(json_encode($json));
} else {
if ($nid) {
$json['message'] = "修改失败或者资料没有改动";
} else {
$json['message'] = "修改失败或者资料没有改动";
}
$json['status'] = 0;
exit(json_encode($json));
}
}
public function index()
{
static $newpars;
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
$per = C('DB_PREFIX');
//$vminfo = M('members')->field("user_leve,time_limit")->find($this->uid);
$vminfo = M('members')->field("user_leve,time_limit")->find($this->uid);
$mstatus = M('members_status')->field(true)->find($this->uid);
if (!($vminfo['user_leve'] > 0 && $vminfo['time_limit'] > time())) {
$this->error("请先通过VIP审核再投资", __APP__ . "/member/vip");
//return;
}
if ($mstatus['phone_status'] != 1) {
$this->error("请先通过手机认证!", __APP__ . "/member/verify#fragment-2");
//return;
}
//推荐的贷款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['is_tuijian'] = 1;
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 1;
$parm['orderby'] = "b.id DESC";
$listBorrowtj = getBorrowList($parm);
$this->assign("listBorrow_tj", $listBorrowtj);
//推荐的贷款
//可投标的借款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '2');
$parm = array();
$parm['map'] = $searchMap;
$this->assign("doingnum", getBorrowList($parm, true));
//可投标的借款
$urlArr = array('borrow_name', 'borrow_status', 'repayment_type', 'borrow_use', 'money', 'borrow_duration', 'is_reward', 'province', 'city', 'area');
$maprow = array();
$searchMap = array();
foreach ($urlArr as $vs) {
$maprow[$vs] = textPost($_POST[$vs]);
}
$maprow["borrow_status"] = $_GET["_URL_"][3];
//searchMap
if (in_array($maprow['borrow_status'], array(2, 3, 4, 6, 7, 8, 9))) {
if ($maprow['borrow_status'] == 9) {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
} else {
$searchMap['borrow_status'] = $maprow['borrow_status'];
}
} else {
$searchMap['borrow_status'] = array("in", '2,4');
}
if (!empty($maprow['borrow_name'])) {
$searchMap['b.borrow_name'] = array("like", "%{$maprow['borrow_name']}%");
}
if (!empty($maprow['repayment_type'])) {
$searchMap['b.repayment_type'] = array("in", array_map(intval, $maprow['repayment_type']));
}
if (!empty($maprow['borrow_use'])) {
$searchMap['b.borrow_use'] = array("in", array_map(intval, $maprow['borrow_use']));
}
if (!empty($maprow['money'])) {
$moneyarr = explode("-", $maprow['money']);
if (count($moneyarr) > 0) {
if (!empty($moneyarr[1])) {
$searchMap['b.borrow_money'] = array("between", array_map(intval, $moneyarr));
} else {
$searchMap['b.borrow_money'] = array("egt", intval($moneyarr[0]));
}
}
}
if (!empty($maprow['borrow_duration'])) {
$searchMap['b.borrow_duration'] = intval($maprow['borrow_duration']);
}
if (!empty($maprow['is_reward'])) {
$searchMap['b.reward_type'] = array("in", array_map(intval, $maprow['is_reward']));
}
if (!empty($maprow['province'])) {
$searchMap['b.province'] = intval($maprow['province']);
}
if (!empty($maprow['city'])) {
$searchMap['b.city'] = intval($maprow['city']);
}
if (!empty($maprow['area'])) {
$searchMap['b.area'] = intval($maprow['area']);
}
//searchMap
//if(is_array($searchMap['borrow_status'])) $searchMap['collect_time']=array('gt',time());
if ($maprow['borrow_status'] == '') {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
}
date_default_timezone_set('Asia/Shanghai');
$ntime = date('Y-m-d H:i:s');
$searchMap['schedular_time'] = array("LT", $ntime);
$parm['map'] = $searchMap;
$parm['pagesize'] = 12;
//排序
strtolower($_GET['sort']) == "asc" ? $sort = "desc" : ($sort = "asc");
unset($surl['orderby'], $surl['sort']);
$orderUrl = http_build_query($surl);
if ($_GET['orderby']) {
if (strtolower($_GET['orderby']) == "credits") {
$parm['orderby'] = "m.credits " . text($_GET['sort']);
} elseif (strtolower($_GET['orderby']) == "rate") {
$parm['orderby'] = "b.borrow_interest_rate " . text($_GET['sort']);
} elseif (strtolower($_GET['orderby']) == "borrow_money") {
$parm['orderby'] = "b.borrow_money " . text($_GET['sort']);
} else {
$parm['orderby'] = "b.id DESC";
}
} else {
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
}
$Sorder['Corderby'] = strtolower(text($_GET['orderby']));
$Sorder['Csort'] = strtolower(text($_GET['sort']));
$Sorder['url'] = $orderUrl;
$Sorder['sort'] = $sort;
$Sorder['orderby'] = text($_GET['orderby']);
//排序
$list = getBorrowList($parm);
$this->assign("Sorder", $Sorder);
$this->assign("searchMap", $maprow);
$this->assign("Bconfig", $Bconfig);
$this->assign("list", $list);
if ($maprow['borrow_status'] == 10) {
//逾期黑名单列表
$map = array();
//$map['_string'] = ' (d.repayment_time=0 AND d.deadline<'.time().' AND d.status=7) ';
$map['_string'] = ' (d.repayment_time=0 AND d.status=7) ';
//分页处理
import("ORG.Util.Page");
$xcount = M('investor_detail d')->field("d.id")->where($map)->group('d.borrow_uid')->buildSql();
$newxsql = M()->query("select count(*) as tc from {$xcount} as t");
$count = $newxsql[0]['tc'];
$p = new Page($count, C('ADMIN_PAGE_SIZE'));
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
$field = "count(*) as num,sum(d.capital) as capital_all,d.borrow_uid,d.status,d.total,d.borrow_id,sum(d.interest) as interest,sum(d.substitute_money) as substitute_money,d.deadline";
$buildSql = M('investor_detail d')->field($field)->where($map)->group('d.sort_order,d.borrow_id')->buildSql();
$list = M()->query("select m.user_name,m.credits,m.id as uid,info.real_name,info.sex,info.idcard,info.zy,m.user_email,m.user_phone,b.province,b.city,b.area,count(*) as tc,t.deadline,sum(t.capital_all) as total_expired,t.interest,t.borrow_uid as id,t.borrow_id from {$buildSql} as t left join lzh_members m ON m.id=t.borrow_uid left join lzh_member_info info ON m.id=info.uid left join lzh_borrow_info b ON b.id=t.borrow_id group by t.borrow_uid limit {$Lsql}");
$list = $this->_tendlist($list);
$this->assign("tendbreak", $list);
}
$this->assign("maprow", $maprow);
$this->display();
}
