/**
* 获取正在进行的投标列表
*/
function get_deal_list($limit = "", $cate_id = 0, $where = '', $orderby = '', $user_name = '', $user_pwd = '', $is_all = false)
{
$time = TIME_UTC;
$count_sql = "select count(*) from " . DB_PREFIX . "deal where 1=1 ";
if ($is_all == false) {
$count_sql .= " and is_effect = 1 and is_delete = 0 ";
}
if (es_cookie::get("shop_sort_field") == "ulevel") {
$extfield = ",(SELECT u.level_id FROM fanwe_user u WHERE u.id=user_id ) as ulevel";
}
$sql = "select *,start_time as last_time,(load_money/borrow_amount*100) as progress_point,(start_time + enddate*24*3600 - " . $time . ") as remain_time {$extfield} from " . DB_PREFIX . "deal where 1 = 1 ";
if ($is_all == false) {
$sql .= " and is_effect = 1 and is_delete = 0 ";
}
if ($cate_id > 0) {
$ids = load_auto_cache("deal_sub_parent_cate_ids", array("cate_id" => $cate_id));
$sql .= " and cate_id in (" . implode(",", $ids) . ")";
$count_sql .= " and cate_id in (" . implode(",", $ids) . ")";
}
if ($where != '') {
$sql .= " and " . $where;
$count_sql .= " and " . $where;
}
if ($orderby == '') {
$sql .= " order by sort desc ";
} else {
$sql .= " order by " . $orderby;
}
if ($limit != "") {
$sql .= " limit " . $limit;
}
$deals_count = $GLOBALS['db']->getOne($count_sql);
if ($deals_count > 0) {
$deals = $GLOBALS['db']->getAll($sql);
//echo $sql;
if ($deals) {
foreach ($deals as $k => $deal) {
format_deal_item($deal, $user_name, $user_pwd);
$deals[$k] = $deal;
}
}
} else {
$deals = array();
}
return array('list' => $deals, 'count' => $deals_count);
}
/**
* 满标放款
* $type 0 普通 1代表 第三方
* $is_loan 0 不返款， 1 返款
*/
function do_loans($id, $repay_start_time, $type = 0)
{
$return = array("status" => 0, "info" => "");
if ($id == 0) {
$return['info'] = "放款失败，借款不存在";
return $return;
}
require_once APP_ROOT_PATH . "app/Lib/deal.php";
syn_deal_status($id);
$deal_info = get_deal($id);
if ($deal['cate_id'] == 6) {
// 体验金
$is_ty = 1;
} else {
$is_ty = 0;
}
if (!$deal_info) {
$return['info'] = "放款失败，借款不存在";
return $return;
}
if (!in_array($deal_info['deal_status'], array(2, 4, 5))) {
$return['info'] = "放款失败，借款不是满标状态";
return $return;
}
if ($type == 0) {
$loan_data['repay_start_time'] = $repay_start_time == '' ? 0 : to_timespan(to_date(to_timespan($repay_start_time), "Y-m-d"), "Y-m-d");
} else {
$loan_data['repay_start_time'] = $repay_start_time;
}
if ($loan_data['repay_start_time'] == 0) {
$return['info'] = "放款失败，时间没选择";
return $return;
}
if ($type == 0 && $deal_info['ips_bill_no'] != "") {
$return['status'] = 2;
$return['info'] = "";
$return['jump'] = APP_ROOT . "/index.php?ctl=collocation&act=Transfer&pTransferType=1&deal_id=" . $id . "&ref_data=" . $loan_data['repay_start_time'];
return $return;
}
if ($loan_data['repay_start_time'] > 0) {
$deal_info['next_repay_time'] = $loan_data['next_repay_time'] = next_replay_month($loan_data['repay_start_time']);
}
$deal_info['deal_status'] = $loan_data['deal_status'] = 4;
$deal_info['is_has_loans'] = $loan_data['is_has_loans'] = 1;
$deal_info['repay_start_time'] = $loan_data['repay_start_time'];
format_deal_item($deal_info);
//放款给用户
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal", $loan_data, "UPDATE", "id=" . $id);
if ($GLOBALS['db']->affected_rows() > 0) {
require_once APP_ROOT_PATH . "system/libs/user.php";
if ($type == 0) {
modify_account(array("money" => $deal_info['borrow_amount']), $deal_info['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],招标成功", 3, $is_ty);
//扣除服务费
$services_fee = $deal_info['borrow_amount'] * floatval(trim($deal_info['services_fee'])) / 100;
modify_account(array("money" => -$services_fee), $deal_info['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],服务费", 14, $is_ty);
}
$load_list = $GLOBALS['db']->getAll("SELECT id,user_id,`money`,`is_old_loan`,`rebate_money`,`rebid_money` FROM " . DB_PREFIX . "deal_load where deal_id=" . $id . " and is_rebate = 0 and is_rebid = 0 ");
foreach ($load_list as $lk => $lv) {
//扣除冻结资金
if ($lv['is_old_loan'] == 0 && $type == 0) {
modify_account(array("lock_money" => -$lv['money']), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],投标成功", 2, $is_ty);
}
//返利给用户
if (floatval($lv["rebate_money"]) != 0) {
$GLOBALS['db']->query("UPDATE " . DB_PREFIX . "deal_load SET is_rebate =1 WHERE id=" . $lv['id'] . " AND is_rebate = 0 AND user_id=" . $lv['user_id'], $is_ty);
if ($GLOBALS['db']->affected_rows()) {
modify_account(array("money" => $lv['rebate_money']), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],返利", 24, $is_ty);
}
}
//续投奖励
if (floatval($lv["rebid_money"]) != 0) {
$GLOBALS['db']->query("UPDATE " . DB_PREFIX . "deal_load SET is_rebid =1 WHERE id=" . $lv['id'] . " AND is_rebid = 0 AND user_id=" . $lv['user_id']);
if ($GLOBALS['db']->affected_rows()) {
modify_account(array("money" => $lv['rebid_money']), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],续投奖励", 24, $is_ty);
}
}
}
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_load", array("is_has_loans" => 1), "UPDATE", "deal_id=" . $id);
make_repay_plan($deal_info);
//发借款成功邮件
send_deal_success_mail_sms($id, $deal_info);
//发借款成功站内信
send_deal_success_site_sms($id, $deal_info);
$return['status'] = 1;
$return['info'] = "放款成功";
return $return;
} else {
$return['info'] = "放款失败";
return $return;
}
}
/**
* 满标放款
* $type 0 普通 1代表 第三方
* $is_loan 0 不返款， 1 返款
*/
function do_loans($id, $repay_start_time, $type = 0)
{
$return = array("status" => 0, "info" => "");
if ($id == 0) {
$return['info'] = "放款失败，借款不存在";
return $return;
}
require_once APP_ROOT_PATH . "app/Lib/deal.php";
$deal_info = get_deal($id);
if (!$deal_info) {
$return['info'] = "放款失败，借款不存在";
return $return;
}
if (!in_array($deal_info['deal_status'], array(2, 4, 5))) {
$return['info'] = "放款失败，借款不是满标状态";
return $return;
}
if ($type == 0) {
$loan_data['repay_start_time'] = $repay_start_time == '' ? 0 : to_timespan(to_date(to_timespan($repay_start_time), "Y-m-d"), "Y-m-d");
} else {
$loan_data['repay_start_time'] = $repay_start_time;
}
if ($loan_data['repay_start_time'] == 0) {
$return['info'] = "放款失败，时间没选择";
return $return;
}
if ($type == 0 && $deal_info['ips_bill_no'] != "") {
$return['status'] = 2;
$return['info'] = "";
$return['jump'] = APP_ROOT . "/index.php?ctl=collocation&act=Transfer&pTransferType=1&deal_id=" . $id . "&ref_data=" . $loan_data['repay_start_time'];
return $return;
}
if ($loan_data['repay_start_time'] > 0) {
$deal_info['next_repay_time'] = $loan_data['next_repay_time'] = next_replay_month($loan_data['repay_start_time']);
}
$deal_info['deal_status'] = $loan_data['deal_status'] = 4;
$deal_info['is_has_loans'] = $loan_data['is_has_loans'] = 1;
$loan_data['repay_start_date'] = to_date($loan_data['repay_start_time'], "Y-m-d");
//放款给用户
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal", $loan_data, "UPDATE", "id=" . $id . " AND is_has_loans=0 ");
$deal_info['repay_start_time'] = $loan_data['repay_start_time'];
if ($GLOBALS['db']->affected_rows() > 0) {
format_deal_item($deal_info);
require_once APP_ROOT_PATH . "system/libs/user.php";
if ($type == 0) {
modify_account(array("money" => $deal_info['borrow_amount']), $deal_info['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],招标成功", 3);
//扣除服务费
$services_fee = $deal_info['borrow_amount'] * floatval(trim($deal_info['services_fee'])) / 100;
modify_account(array("money" => -$services_fee), $deal_info['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],服务费", 14);
}
//积分
if ($deal_info['score'] != 0) {
modify_account(array("score" => $deal_info['score']), $deal_info['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],招标成功", 3);
}
$load_list = $GLOBALS['db']->getAll("SELECT id,user_id,`money`,`is_old_loan`,`rebate_money`,`bid_score`,`is_winning`,`income_type`,`income_value` FROM " . DB_PREFIX . "deal_load where deal_id=" . $id . " and is_rebate = 0 ");
foreach ($load_list as $lk => $lv) {
//扣除冻结资金
if ($type == 0) {
$GLOBALS['db']->query("UPDATE " . DB_PREFIX . "deal_load SET is_has_loans =1 WHERE id=" . $lv['id'] . " AND is_has_loans = 0 AND user_id=" . $lv['user_id']);
if ($GLOBALS['db']->affected_rows()) {
if ($lv['is_old_loan'] == 0) {
modify_account(array("lock_money" => -$lv['money']), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],投标成功", 2);
}
}
}
//返利给用户
if (floatval($lv["rebate_money"]) != 0 || intval($lv["bid_score"]) != 0) {
$GLOBALS['db']->query("UPDATE " . DB_PREFIX . "deal_load SET is_rebate =1 WHERE id=" . $lv['id'] . " AND is_rebate = 0 AND user_id=" . $lv['user_id']);
if ($GLOBALS['db']->affected_rows()) {
//返利
if (floatval($lv["rebate_money"]) != 0) {
modify_account(array("money" => $lv['rebate_money']), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],投资返利", 24);
}
//积分
if (intval($lv["bid_score"]) != 0) {
modify_account(array("score" => $lv['bid_score']), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],投资返积分", 2);
}
//VIP奖励
if (((int) $lv['income_type'] == 1 || (int) $lv['income_type'] == 2 || (int) $lv['income_type'] == 3 || (int) $lv['income_type'] == 4) && $lv['is_winning'] == 1) {
$user_msg_conf = get_user_msg_conf($lv['user_id']);
//发放奖励
if ($lv['income_type'] == 1) {
//红包记录 增加用户金额与不可提现金额
$red_envelope_date['user_id'] = $lv['user_id'];
$red_envelope_date['deal_id'] = $id;
$red_envelope_date['load_id'] = $lv['id'];
$red_envelope_date['reward_name'] = "投标收益奖励";
$red_envelope_date['gift_type'] = 1;
$redmoney = $GLOBALS['db']->getOne("SELECT money FROM " . DB_PREFIX . "vip_red_envelope WHERE id='" . (int) $lv['income_value'] . "'");
$red_envelope_date['gift_value'] = $redmoney;
$red_envelope_date['status'] = 1;
$red_envelope_date['generation_date'] = to_date(TIME_UTC, "Y-m-d");
$red_envelope_date['release_date'] = to_date(TIME_UTC, "Y-m-d");
$is_send_mail = $user_msg_conf['mail_redenvelope'];
$is_send_sms = $user_msg_conf['sms_redenvelope'];
$TPL_MAIL_NAME = "TPL_MAIL_RED_ENVELOPE";
$TPL_SMS_NAME = "TPL_SMS_RED_ENVELOPE";
$gift_value = $redmoney;
if ($redmoney != 0 && $redmoney != "") {
$GLOBALS['db']->autoExecute(DB_PREFIX . "gift_record", $red_envelope_date);
//插入
modify_account(array('money' => $redmoney, 'nmc_amount' => $redmoney), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],的投标收益奖励 红包现金", 28);
}
} elseif ($lv['income_type'] == 2) {
//收益率
$rate_date['user_id'] = $lv['user_id'];
$rate_date['deal_id'] = $id;
$rate_date['load_id'] = $lv['id'];
$rate_date['reward_name'] = "投标收益奖励";
$rate_date['gift_type'] = 2;
$loadinfo = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal_load_repay WHERE load_id='" . $lv['id'] . "'");
$interest_money = $loadinfo['repay_money'] - $loadinfo['self_money'];
$gift_value = $interest_money * (double) $lv['income_value'] * 0.01;
$rate_date['reward_money'] = $gift_value;
$rate_date['gift_value'] = $lv['income_value'];
$rate_date['status'] = 1;
$rate_date['generation_date'] = to_date(TIME_UTC, "Y-m-d");
$rate_date['release_date'] = to_date(TIME_UTC, "Y-m-d");
$GLOBALS['db']->autoExecute(DB_PREFIX . "gift_record", $rate_date);
//插入
} elseif ($lv['income_type'] == 3) {
//积分
$score = (int) $lv['income_value'];
$score_date['user_id'] = $lv['user_id'];
$score_date['deal_id'] = $id;
$score_date['load_id'] = $lv['id'];
$score_date['reward_name'] = "投标收益奖励";
$score_date['gift_type'] = 3;
$score_date['gift_value'] = (int) $lv['income_value'];
$score_date['status'] = 1;
$score_date['generation_date'] = to_date(TIME_UTC, "Y-m-d");
$score_date['release_date'] = to_date(TIME_UTC, "Y-m-d");
$GLOBALS['db']->autoExecute(DB_PREFIX . "gift_record", $score_date);
//插入
$is_send_mail = $user_msg_conf['mail_integral'];
$is_send_sms = $user_msg_conf['sms_integral'];
$TPL_MAIL_NAME = "TPL_MAIL_INTEGRAL";
$TPL_SMS_NAME = "TPL_SMS_INTEGRAL";
$gift_value = (int) $lv['income_value'];
if ($score != 0) {
modify_account(array("score" => $score), $lv['user_id'], "[<a href='" . $deal_info['url'] . "' target='_blank'>" . $deal_info['name'] . "</a>],的投标收益奖励 积分", 28);
}
} elseif ($lv['income_type'] == 4) {
//礼品记录
$gift_date['user_id'] = $lv['user_id'];
$gift_date['deal_id'] = $id;
$gift_date['load_id'] = $lv['id'];
$gift_date['reward_name'] = "投标收益奖励";
$gift_date['gift_type'] = 4;
$gift_date['gift_value'] = (int) $lv['income_value'];
$gift_date['status'] = 1;
$gift_date['generation_date'] = to_date(TIME_UTC, "Y-m-d");
$gift_date['release_date'] = to_date(TIME_UTC, "Y-m-d");
$GLOBALS['db']->autoExecute(DB_PREFIX . "gift_record", $gift_date);
//插入
$is_send_mail = $user_msg_conf['mail_gift'];
$is_send_sms = $user_msg_conf['sms_gift'];
$TPL_MAIL_NAME = "TPL_MAIL_GIFT";
$TPL_SMS_NAME = "TPL_SMS_GIFT";
$gift_value = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "vip_gift where id = " . $gift_date['gift_value']);
}
$user_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $lv['user_id']);
$deal_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "deal where id = " . $id);
//邮件
if ($is_send_mail == 1 && app_conf("MAIL_ON") == 1) {
$tmpl = $GLOBALS['db']->getRowCached("select * from " . DB_PREFIX . "msg_template where name = '" . $TPL_MAIL_NAME . "'");
$tmpl_content = $tmpl['content'];
$notice['user_name'] = $user_info['user_name'];
$notice['deal_name'] = $deal_name;
$notice['release_date'] = to_date(TIME_UTC, "Y-m-d");
$notice['site_name'] = app_conf("SHOP_TITLE");
$notice['gift_value'] = $gift_value;
$GLOBALS['tmpl']->assign("notice", $notice);
$msg = $GLOBALS['tmpl']->fetch("str:" . $tmpl_content);
$msg_data['dest'] = $user_info['email'];
$msg_data['send_type'] = 1;
$msg_data['title'] = "投标奖励邮件通知";
$msg_data['content'] = addslashes($msg);
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = TIME_UTC;
$msg_data['user_id'] = $user_info['id'];
$msg_data['is_html'] = $tmpl['is_html'];
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
//短信
if ($is_send_sms == 1 && app_conf("SMS_ON") == 1) {
$tmpl = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "msg_template where name = '" . $TPL_SMS_NAME . "'");
$tmpl_content = $tmpl['content'];
$notice['user_name'] = $user_info['user_name'];
$notice['deal_name'] = $deal_name;
$notice['release_date'] = to_date(TIME_UTC, "Y-m-d");
$notice['site_name'] = app_conf("SHOP_TITLE");
$notice['gift_value'] = $gift_value;
$GLOBALS['tmpl']->assign("notice", $notice);
$msg = $GLOBALS['tmpl']->fetch("str:" . $tmpl_content);
$msg_data['dest'] = $user_info['mobile'];
$msg_data['send_type'] = 0;
$msg_data['title'] = "投标奖励短信通知";
$msg_data['content'] = addslashes($msg);
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = TIME_UTC;
$msg_data['user_id'] = $user_info['id'];
$msg_data['is_html'] = $tmpl['is_html'];
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
}
}
}
}
//$GLOBALS['db']->autoExecute(DB_PREFIX."deal_load",array("is_has_loans"=>1),"UPDATE","deal_id=".$id);
make_repay_plan($deal_info);
//发借款成功邮件
send_deal_success_mail_sms($id, $deal_info);
//发借款成功站内信
send_deal_success_site_sms($id, $deal_info);
$return['status'] = 1;
$return['info'] = "放款成功";
return $return;
} else {
$return['info'] = "放款失败";
return $return;
}
}
public function loan()
{
$authorized_info = $this->checkLogin();
$user_id = intval($_REQUEST['u_id']);
$auth = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = {$user_id} and pid = " . $authorized_info["id"]);
if ($user_id && !$auth) {
showErr("非法访问", 0);
}
require APP_ROOT_PATH . "app/Lib/deal_func.php";
require APP_ROOT_PATH . "app/Lib/page.php";
$status = intval($_REQUEST['status']);
$GLOBALS['tmpl']->assign("status", $status);
//输出借款记录
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE");
$deal_status = 4;
if ($status == 1) {
$deal_status = 5;
}
$time = TIME_UTC;
$count_sql = "select count(*) from " . DB_PREFIX . "deal d LEFT JOIN " . DB_PREFIX . "user u on d.user_id = u.id where deal_status in (4,5) and u.pid ='" . $authorized_info["id"] . "' ";
if ($is_all == false) {
$count_sql .= " and d.is_effect = 1 and d.is_delete = 0 ";
}
$sql = "select *,d.id as did,start_time as last_time,(load_money/borrow_amount*100) as progress_point,(start_time + enddate*24*3600 - " . $time . ") as remain_time {$extfield} from " . DB_PREFIX . "deal d left join " . DB_PREFIX . "user u on d.user_id = u.id where deal_status in (2,4,5) and u.pid ='" . $authorized_info["id"] . "' ";
if ($is_all == false) {
$sql .= " and d.is_effect = 1 and d.is_delete = 0 ";
}
if ($where != '') {
$sql .= " and " . $where;
$count_sql .= " and " . $where;
}
if ($user_id) {
$sql .= " and user_id = " . $user_id;
$count_sql .= " and user_id = " . $user_id;
}
if ($orderby == '') {
$sql .= " order by d.id desc ";
} else {
$sql .= " order by " . $orderby;
}
if ($limit != "") {
$sql .= " limit " . $limit;
}
$result["count"] = $GLOBALS['db']->getOne($count_sql);
if ($result["count"] > 0) {
$result["list"] = $GLOBALS['db']->getAll($sql);
if ($result["list"]) {
foreach ($result["list"] as $k => $deal) {
format_deal_item($deal, $user_name, $user_pwd);
$result["list"][$k] = $deal;
}
}
} else {
$result["list"] = array();
}
$deal_ids = array();
foreach ($result['list'] as $k => $v) {
if ($v['repay_progress_point'] >= $v['generation_position']) {
$result['list'][$k]["can_generation"] = 1;
}
$deal_ids[] = $v['id'];
}
if ($deal_ids) {
$temp_ids = $GLOBALS['db']->getAll("SELECT `deal_id`,`status` FROM " . DB_PREFIX . "generation_repay_submit WHERE deal_id in(" . implode(",", $deal_ids) . ") ");
$deal_g_ids = array();
foreach ($temp_ids as $k => $v) {
$deal_g_ids[$v['deal_id']] = $v;
}
foreach ($result['list'] as $k => $v) {
$result['list'][$k]["ll_key"] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal_repay where user_id = " . $v["user_id"] . " and deal_id = " . $v["did"]);
$result['list'][$k]["status_format"] = $v["deal_status"] == 5 ? "已还清" : "还款中";
}
}
$GLOBALS['tmpl']->assign("deal_list", $result['list']);
$page = new Page($result['count'], app_conf("PAGE_SIZE"));
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
$GLOBALS['tmpl']->assign("page_title", "客户借款列表");
$GLOBALS['tmpl']->assign("inc_file", "authorized/authorized_borrowed.html");
$GLOBALS['tmpl']->display("authorized/a_m.html");
}
