/** * 满标放款 * $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; } }