public function get_account_infor($account_name)
{
$db = core::db()->getConnect('DTS');
$account_name = addslashes($account_name);
$sql = sprintf("SELECT * FROM %s WHERE partner_name='%s' LIMIT 1", $this->tbl, $account_name);
return $db->query($sql, 'array');
}
/**
* 资产信息
* @param id $user_id
* return Array
*/
public function get_capital($user_id)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf("SELECT * FROM %s WHERE uid='%s' LIMIT 1", $this->tbl, $user_id);
$capital = $db->query($sql, 'array');
$data = array();
if (empty($capital)) {
$data['account_money'] = 0.0;
$data['back_money'] = 0.0;
$data['all_money'] = 0.0;
$data['money_freeze'] = 0.0;
$data['money_collect'] = 0.0;
$data['wait_interest'] = 0.0;
return $data;
}
//$interest_collection = M('investor_detail') sum(interest) as interest $transfer_interest_collection = M('transfer_investor_detail')
//$benefit['interest_collection'] = $interest_collection['interest']+ $transfer_interest_collection['interest']-$transfer_interest_collection['fee'];//dai shou ben xi
$sql2 = sprintf("SELECT sum(interest) as interest FROM %s WHERE investor_uid= %s and status in (6,7) ", $this->tbli, $user_id);
$interst = $db->query($sql2, 1);
$data['account_money'] = floatval($capital['account_money'] + $capital['back_money']);
//帐户余额
$data['back_money'] = (double) $capital['back_money'];
//累计收益
$data['all_money'] = floatval($capital['account_money'] + $capital['back_money'] + $capital['money_collect'] + $capital['freeze_money']);
//总资产
$data['money_freeze'] = (double) $capital['money_freeze'];
//冻结金额
$data['money_collect'] = (double) $capital['money_collect'];
//待收总额
$data['wait_interest'] = (double) $interst;
//待收利息,还没算出来
return $data;
}
public function setApplicationBorrow($data)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf('INSERT INTO `%s`(`user_phone`,`borrow_use`,`borrow_duration`,`borrow_money`) VALUES("%s","%s","%s","%s")', $this->tbl, $data['user_phone'], $data['borrow_use'], $data['borrow_duration'], $data['borrow_money']);
$db->query($sql);
return mysql_insert_id();
}
public static function send($event)
{
$conf = core::conf();
$db = core::db();
// Поиск шаблона письма по имени события
$template = $db->Execute(sprintf("SELECT `subject`,`text`,`tags` FROM {$conf->db_prefix}mail WHERE `event`='%s' AND `active`='1'", $event))->fields;
$subject = htmlspecialchars_decode($template['subject']);
$message = htmlspecialchars_decode($template['text']);
$tags = explode(',', $template['tags']);
// Замена тегов в письме на значения переменных
foreach ($tags as $tag) {
$tag = explode('.', $tag);
if (is_array($GLOBALS[$tag[0]])) {
$value = $GLOBALS[$tag[0]][$tag[1]];
} elseif (is_object($GLOBALS[$tag[0]])) {
$value = $GLOBALS[$tag[0]]->{$tag}[1];
} else {
$value = $GLOBALS[$tag[0]];
}
$subject = str_replace('{' . $tag[0] . '.' . $tag[1] . '}', $value, $subject);
$message = str_replace('{' . $tag[0] . '.' . $tag[1] . '}', $value, $message);
}
$mail_to = $user->email;
$mail_from = $conf->site_mail;
// Отправка письма
if ($subject != '' && $message != '') {
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
$headers .= 'To: ' . $user->name . ' <' . $mail_to . '>' . "\r\n";
$headers .= 'From: ' . $conf->site_name . ' <' . $mail_from . '>' . "\r\n";
mail($mail_to, $subject, $message, $headers);
}
}
public function getBorrowInvest($bid)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf("SELECT m.user_name,bi.investor_capital,bi.add_time LEFT JOIN %s AS m ON (m.id=bi.investor_uid) FROM %s AS bi WHERE bi.borrow_id = %s", $this->table1, $this->table, $bid);
$zw = $db->query($sql, 1);
return $zw;
}
public function getUserBank($userId)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf("SELECT m.bank_name,m.bank_num FROM %s AS m where m.uid='%s' ", $this->tbl, $userId);
$zw = $db->query($sql, 'array');
return $zw;
//
}
public function log($mobiles, $content, $response, $report_id = '', $send_status = '')
{
$send_time = date('Y-m-d H:i:s');
$sms_supplier = 'dream';
$db = core::db()->getConnect('SMS');
$sql = sprintf("insert into tbl_log_qunfa set send_time='%s',mobiles='%s',`content`='%s',reponse_data='%s',sms_supplier='%s',report_id='%s',send_status='%s'", $send_time, $mobiles, $content, $response, $sms_supplier, $report_id, $send_status);
$db->query($sql);
}
private function changePwd($mobile, $pwd)
{
if (empty($mobile)) {
return false;
}
$sql = sprintf("update `%s` set user_pass='******' where user_phone='%s';", $this->numberTab, $pwd, $mobile);
$number = core::db()->getConnect('CAILAI');
$cnt = $number->query($sql);
}
private function isRegisted($mobile)
{
if (empty($mobile)) {
return false;
}
$sql = sprintf("select user_phone from `%s` where user_phone='%s';", $this->numberTab, $mobile);
$number = core::db()->getConnect('CAILAI');
$cnt = $number->query($sql);
return $cnt;
}
public function get_banner($latest_time)
{
$db = core::db()->getConnect('DTS', true);
$sql = sprintf("SELECT pic_url,`desc`,`link`,`need_update` FROM %s ", $this->tbl);
$ret = $db->query($sql);
while ($row = $db->fetchArray($ret)) {
$data[] = $row;
}
return $data;
}
/**
* 更新响应日志
* @param unknown_type $log_id
* @param unknown_type $response_data
*/
public static function update($log_id, $response_data, $wdu_id = '')
{
$db = core::db()->getConnect('DTS');
$response_time = date('Y-m-d H:i:s');
if (get_magic_quotes_gpc()) {
$sql = sprintf("update %s set request_md5='%s', response_time='%s',response_data='%s' where message_id='%d' limit 1", self::$log_tbl, $wdu_id, $response_time, $response_data, $log_id);
} else {
$sql = sprintf("update %s set request_md5='%s', response_time='%s',response_data='%s' where message_id='%d' limit 1", self::$log_tbl, $wdu_id, $response_time, addslashes($response_data), $log_id);
}
$db->query($sql);
}
public function getDealRecord($userId, $offset, $pageSize)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf("SELECT type,affect_money,collect_money,info,add_time,account_money,back_money FROM %s WHERE uid='%s' and `type`!=23 ORDER BY id DESC limit %s,%s ", $this->tbl, $userId, $offset, $pageSize);
$zw = $db->query($sql);
while ($row = $db->fetchArray($zw)) {
$data['type'] = moneyType($row['type']);
$data['affect_money'] = (double) $row['affect_money'];
$data['collect_money'] = (double) $row['collect_money'];
$data['desc'] = $row['info'];
$data['account_money'] = (double) ($row['account_money'] + $row['back_money']);
$data['date'] = date('Y-m-d H:i:s', $row['add_time']);
$result[] = $data;
}
if (empty($result)) {
return $result = (array) array();
}
return $result;
}
public function dealRed($redata)
{
$db = core::db()->getConnect('CAILAI', true);
$redid = $redata['redid'];
$borrow_id = $redata['borrow_id'];
$usetime = $redata['usetime'];
//$is_used=$redata['is_used'];
$transamt = $redata['transamt'];
$orderno = $redata['orderno'];
file_put_contents('/tmp/zw2.txt', date('m-d H:i:s') . "\$redarr " . print_r($redarr, true) . "\n", FILE_APPEND);
if (is_array($redid)) {
foreach ($redid as $key => $value) {
file_put_contents('/tmp/zw2.txt', date('m-d H:i:s') . "\$redarr " . print_r($redid, true) . "\n", FILE_APPEND);
$sql = sprintf("update %s set borrow_id=%s,usetime=%s,transamt=%s,orderno=%s WHERE id = %s", $this->active_redpacket, $borrow_id, $usetime, $transamt, $orderno, $value);
$zw = $db->query($sql);
}
}
return $zw;
}
public function event($event_name)
{
$conf = core::conf();
$db = core::db();
// Поиск действий, связанных с данным событием
$result = $db->execute("SELECT `module`,`action` FROM {$conf->db_prefix}monitor WHERE `event`='?' ORDER BY `weight`", $event_name);
while ($result && !$result->EOF) {
$action = $result->fields['action'];
$module = $result->fields['module'];
$module_group = $db->execute("SELECT `module_group` FROM {$conf->db_prefix}modules WHERE `name`='?'", $module)->fields['group'];
// Запуск действия
$action_path = $conf->root_dir . '/' . $module_group . '/modules/' . $module . '/class.' . $module . '.php';
if (file_exists($action_path)) {
require_once $action_path;
call_user_func($module . '::' . $action, $event_name);
}
$result->MoveNext();
}
}
public function getArea($idno)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf("SELECT lmi.uid,lmi.cell_phone,lmi.idcard,lmi.real_name,lmi.age,lmi.address,m.reg_time From %s as lmi left join %s as m on lmi.uid=m.id where lmi.idcard like '%s%s%s' order by m.reg_time desc", $this->table_lmi, $this->table_m, '%', $idno, '%');
$zw = $db->query($sql);
$data = array();
while ($row = $db->fetchArray($zw)) {
$data['uid'] = $row['uid'];
$data['cell_phone'] = $row['cell_phone'];
$data['idcard'] = $row['idcard'];
$data['real_name'] = $row['real_name'];
$data['age'] = $row['age'];
$data['address'] = $row['address'];
$data['reg_time'] = $row['reg_time'];
$result[] = $data;
}
if (empty($result)) {
return $result = (array) array();
}
return $result;
}
public function setUserChannelId($data)
{
$db = core::db()->getConnect('CAILAIPUSH', true);
$_sql = sprintf('SELECT * FROM `%s` WHERE channel_id="%s"', $this->tbl_device, $data['channel_id']);
//判断是否存在，已经存在则不存库；如果channel_id存在，member_id不同，则更新；
// return $data;
$row = $db->query($_sql, 2);
if ($row['channel_id'] != $data['channel_id'] && $row['member_id'] != $data['member_id']) {
$sql = sprintf('INSERT INTO `%s`(`member_id`,`member_phone`,`channel_id`,`is_app`,`device_type`) VALUES("%s","%s","%s","%s","%s")', $this->tbl_device, $data['member_id'], $data['member_phone'], $data['channel_id'], IS_APP, $data['device_type']);
$db->query($sql);
return mysql_insert_id();
} else {
if ($row['channel_id'] == $data['channel_id'] && $row['member_id'] == $data['member_id']) {
return "已经存在";
} else {
if ($row['channel_id'] == $data['channel_id'] && $row['member_id'] != $data['member_id']) {
$sql = sprintf("UPDATE %s SET member_id='%s',member_phone='%s' WHERE channel_id='%s'", $this->tbl_device, $data['member_id'], $data['member_phone'], $data['channel_id']);
$db->query($sql);
return "更新成功";
}
}
}
}
public function auth()
{
$conf = core::conf();
$db = core::db();
$time = time();
// пользователь авторизован
if (!empty($_SESSION['user_login']) && !empty($_SESSION['user_hash'])) {
$input_login = $_SESSION['user_login'];
$input_hash = $_SESSION['user_hash'];
} elseif (isset($_POST['user_login']) && isset($_POST['user_hash'])) {
$input_login = $_POST['user_login'];
$input_hash = $_POST['user_hash'];
} else {
return false;
}
$data = $this->repository->findOneBy(array('login' => $input_login));
$hash = md5($user_data['id'] . ':' . $input_login . ':' . $input_hash . ':' . $user_data['salt']);
if ($user_data['hash'] == $hash) {
$db->Execute(sprintf("UPDATE {$conf->db_prefix}users SET `time_l`='%d' WHERE `id`='%d'", time(), $user_data['id']));
$_SESSION['user_login'] = $input_login;
$_SESSION['user_hash'] = $input_hash;
return true;
} else {
unset($_SESSION['user_hash']);
return false;
}
}
function addMemberRedpacket($map)
{
// file_put_contents('/tmp/app',date('H:i:s').': '.print_r($map,true),FILE_APPEND);
$db = core::db()->getConnect('CAILAI', true);
$ssql = sprintf("SELECT id FROM lzh_members WHERE user_name=%s", $map['usrid']);
$res = $db->query($ssql, 1);
//
// file_put_contents('/tmp/app',date('H:i:s').': '.print_r($res,true),FILE_APPEND);
// file_put_contents('/tmp/app',date('H:i:s').': '.print_r($ssql,true),FILE_APPEND);
$sql = sprintf("insert into %s set addtime='%s',rednum='%s',shelftime='%s',facevalue='%s',overtime='%s',owner='%s',is_success='%s',is_used='%s',note='%s'", 'lzh_active_redpacket', $map['addtime'], $map['rednum'], $map['shelftime'], $map['facevalue'], $map['overtime'], $res, $map['is_success'], $map['is_used'], $map['note']);
// file_put_contents('/tmp/app',date('H:i:s').': '.print_r($sql,true),FILE_APPEND);
$result = $db->query($sql);
return mysql_insert_id();
}
public function get_privilege($account_name)
{
$accounts = (include "config/config.interface.php");
if (in_array($account_name, array_keys($accounts))) {
return $accounts[$account_name];
} else {
$db = core::db()->getConnect('DTS');
$account_name = addslashes($account_name);
$sql = sprintf("SELECT * FROM %s WHERE partner_name='%s' LIMIT 1", 'dts_account', $account_name);
return $db->query($sql, 'array');
}
}
public function connect($db)
{
$this->_db_read = core::db()->getConnect($db, true);
$this->_db_write = core::db()->getConnect($db);
return $this;
}
public function reds($userId)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf("SELECT * from %s where owner=%s", $this->table_red, $userId);
$lj = $db->query($sql);
$data = array();
while ($row = $db->fetchArray($lj)) {
$result[] = $row;
}
if (empty($result)) {
return $result = (array) array();
}
return $result;
}
/**
*执行其他SQL操作
*/
function execSQL($sql, $flag)
{
//$db = & $GLOBALS['_DSN']->getConnect($this->DBFlag,$flag);
$db = core::db()->getConnect($this->DBFlag);
$db->query($sql);
}
<?php
require_once dirname(__FILE__) . '/../../www/header.php';
//用于官方统计
$objDb = core::db()->getConnect('CAILAI');
//首页统计
$sql = "SELECT SUM(investor_capital) as sum FROM `lzh_borrow_investor`";
$res = $objDb->query($sql, 'array');
$get_money = $res['sum'];
//累计帮助企业和个人融资
$sql2 = "SELECT SUM(investor_interest) as sum FROM `lzh_borrow_investor`";
$res2 = $objDb->query($sql2, 'array');
$make_money = $res2['sum'];
//为投资人赚取收益
//$sql3 = "select sum(capital+interest) as sum from lzh_investor_detail where repayment_time=0";//待收余额
$date = date('Y-m-d', strtotime(" -1 day"));
$date_start = strtotime($date . ' 00:00:00');
$date_end = strtotime($date . ' 23:59:59');
$sql3 = "SELECT SUM(borrow_money) as sum FROM `lzh_borrow_info` where add_time>{$date_start} and add_time<{$date_end}";
$res3 = $objDb->query($sql3, 'array');
$needgot_money = $res3['sum'] ? $res3['sum'] : 0;
//昨日交易额
//首页统计入库
$sql4 = "truncate `lzh_home_tongji`";
$objDb->query($sql4);
$sql4 = "insert into `lzh_home_tongji` set get_money='{$get_money}',make_money='{$make_money}',needgot_money='{$needgot_money}'";
$objDb->query($sql4);
//投资榜
$sql5 = "truncate `lzh_amount_top`";
$objDb->query($sql5);
$before_30 = strtotime(date('Y-m-d H:i:s', strtotime('- 30 day')));
public function getBorrowDebtTotal()
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf("SELECT count(*) AS total FROM %s WHERE status NOT IN (3,99)", 'lzh_invest_detb');
$zw = $db->query($sql, 1);
return $zw;
}
public function getPact($bid)
{
$db = core::db()->getConnect('CAILAI', true);
$sql = sprintf('SELECT `id`,`borrow_use`,`borrow_duration`,`borrow_money`,`first_verify_time`,`borrow_interest_rate`,`second_verify_time`,`repayment_type`,`manage_rate`,`borrow_uid`,`borrow_fee` FROM %s where `id`=%s limit 1', $this->table, $bid);
$ht = $db->query($sql);
$row = $db->fetchArray($ht);
$sqli = sprintf('SELECT `borrow_uid`,`investor_uid` ,`investor_capital`,`receive_capital` FROM %s WHERE `borrow_id`=%s', $this->tablebi, $bid);
$ht = $db->query($sqli);
$i = 0;
while ($v = $db->fetchArray($ht)) {
$row['investor'][$i]['capital'] = $v['investor_capital'] + $v['receive_capital'];
$sqlp = sprintf('SELECT `cell_phone` FROM %s WHERE `uid`=%s limit 1', $this->tablemi, $v["investor_uid"]);
$up = $db->query($sqlp, 1);
$row['investor'][$i]['phone'] = $up;
++$i;
}
$row['aged1_30'] = '0.05';
$row['agedm1_30'] = '0.3';
$row['aged30'] = '0.1';
$row['agedm30'] = '0.5';
$sqlp = sprintf('SELECT `cell_phone` FROM %s WHERE `uid`=%s limit 1', $this->tablemi, $row["borrow_uid"]);
$row['PacePhone'] = $db->query($sqlp, 1);
return $row;
}
public function _initiativetenderAct()
{
$money = $_POST['TransAmt'];
$m = date('m', time());
$d = date('d', time());
$mi = date('H:i', time());
if (strcmp($_POST['RespCode'], "000") == 0) {
$subOrdId = $_POST['OrdId'];
$db_user = core::db()->getConnect('CAILAI');
$sql = "update lzh_active_redpacket set is_success='1' where orderno=" . "'" . $subOrdId . "'";
$rs = $db_user->query($sql);
file_put_contents('/tmp/debugs', date('m-d H:i:s') . "\\siyuan" . print_r($_POST, true) . "\n", FILE_APPEND);
file_put_contents('/tmp/debugs', date('m-d H:i:s') . "\\siyuansql" . print_r($sql, true) . "\n", FILE_APPEND);
file_put_contents('/tmp/debugs', date('m-d H:i:s') . "\\siyuanrs" . print_r($rs, true) . "\n", FILE_APPEND);
$realName = realNameGet($_POST['UsrCustId']);
$userName = $realName['real_name'];
$url = HOST_NAME . 'Style/H/images/apppic.jpg';
$word = "<b>尊敬的财来网投资人{$userName}</b>您于{$m}月{$d}号 {$mi}分投资 <span> {$money} </span>元,资金已冻结，将于满标复审后开始计息。<br/>详情请咨询客户经理或致电400-079-8558";
} else {
$huifuerror = (require_once 'huifuerror.php');
$errorms = $_POST['RespCode'];
$backerror = $huifuerror[$errorms];
$url = HOST_NAME . 'Style/H/images/appshib.jpg';
$word = "<span class='error'>" . $backerror . "</span>";
}
$this->view->assign("url", $url);
$this->view->assign("word", $word);
$this->view->assign("money", $money);
}
