public function uplevelog()
{
$map['uid'] = $this->uid;
$map['type'] = 2;
$list = getMoneyLog($map, 100);
$this->assign("list", $list['list']);
$data['html'] = $this->fetch();
exit(json_encode($data));
}
public function promotionlog()
{
$map['uid'] = $this->uid;
$map['type'] = array("in", "1,13");
$list = getMoneyLog($map, 15);
$totalR = M('member_moneylog')->where("uid={$this->uid} AND type in(1,13)")->sum('affect_money');
$this->assign("totalR", $totalR);
$this->assign("CR", M('members')->getFieldById($this->uid, 'reward_money'));
$this->assign("list", $list['list']);
$this->assign("pagebar", $list['page']);
$data['html'] = $this->fetch();
exit(json_encode($data));
}
public function index()
{
$ucLoing = de_xie($_COOKIE['LoginCookie']);
setcookie('LoginCookie', '', time() - 10 * 60, "/");
$this->assign("uclogin", $ucLoing);
$this->assign("unread", $read = M("inner_msg")->where("uid={$this->uid} AND status=0")->count('id'));
$this->assign("mstatus", M('members_status')->field(true)->find($this->uid));
$minfo = getMinfo($this->uid, true);
$pin_pass = $minfo['pin_pass'];
$has_pin = empty($pin_pass) ? "no" : "yes";
$this->assign("has_pin", $has_pin);
$this->assign("memberinfo", M('members')->find($this->uid));
$this->assign("memberdetail", M('member_info')->find($this->uid));
$this->assign("minfo", $minfo);
$this->assign('benefit', get_personal_benefit($this->uid));
$this->assign('out', get_personal_out($this->uid));
$this->assign("bank", M('member_banks')->field('bank_num')->find($this->uid));
$info = getMemberDetail($this->uid);
$this->assign("info", $info);
$this->assign("kflist", get_admin_name());
$list = array();
$pre = C('DB_PREFIX');
$rule = M('ausers u')->field('u.id,u.qq,u.phone')->join("{$pre}members m ON m.customer_id=u.id")->where("u.is_kf =1 and m.customer_id=0")->select();
//m.customer_id={$minfo['customer_id']}
foreach ($rule as $key => $v) {
$list[$key]['qq'] = $v['qq'];
$list[$key]['phone'] = $v['phone'];
}
$this->assign("kfs", $list);
$_SX = M('investor_detail')->field('deadline,interest,capital')->where("investor_uid = {$this->uid} AND status=7")->order("deadline ASC")->find();
$lastInvest['gettime'] = $_SX['deadline'];
$lastInvest['interest'] = $_SX['interest'];
$lastInvest['capital'] = $_SX['capital'];
$this->assign("lastInvest", $lastInvest);
$_SX = "";
$_SX = M('investor_detail')->field('deadline,sum(interest) as interest,sum(capital) as capital')->where("borrow_uid = {$this->uid} AND status=7")->group("borrow_id,sort_order")->order("deadline ASC")->find();
$lastBorrow['gettime'] = $_SX['deadline'];
$lastBorrow['interest'] = $_SX['interest'];
$lastBorrow['capital'] = $_SX['capital'];
$this->assign("lastBorrow", $lastBorrow);
$map = array();
$map['uid'] = $this->uid;
$Log_list = getMoneyLog($map, 4);
$this->assign("Log_list", $Log_list['list']);
$this->assign("list", get_personal_count($this->uid));
$this->assign("uid", $map['uid']);
$this->display();
}
public function promotionlog($re = 0)
{
$map['uid'] = $this->uid;
$map['type'] = array("in", "1,13");
$list = getMoneyLog($map, $re ? $re : 15);
$totalR = M('member_moneylog')->where("uid={$this->uid} AND type in(1,13)")->sum('affect_money');
$this->assign("totalR", $totalR);
$this->assign("CR", M('members')->getFieldById($this->uid, 'reward_money'));
$this->assign("list", $list['list']);
$this->assign("pagebar", $list['page']);
if ($re > 0) {
$dpage = array();
$dpage['numpage'] = $list['count'] ? ceil($list['count'] / 5) : 1;
$dpage['curpage'] = (int) $_GET['p'] ? (int) $_GET['p'] : 1;
$this->assign("dpage", $dpage);
return $list['list'];
}
$data['html'] = $this->fetch();
exit(json_encode($data));
}
public function export()
{
import("ORG.Io.Excel");
$map = array();
$map['uid'] = $this->uid;
if ($_GET['start_time'] && $_GET['end_time']) {
$_GET['start_time'] = strtotime($_GET['start_time'] . " 00:00:00");
$_GET['end_time'] = strtotime($_GET['end_time'] . " 23:59:59");
if ($_GET['start_time'] < $_GET['end_time']) {
$map['add_time'] = array("between", "{$_GET['start_time']},{$_GET['end_time']}");
$search['start_time'] = $_GET['start_time'];
$search['end_time'] = $_GET['end_time'];
}
}
if (!empty($_GET['log_type'])) {
$map['type'] = intval($_GET['log_type']);
$search['log_type'] = intval($_GET['log_type']);
}
$list = getMoneyLog($map, 100000);
$logtype = C('MONEY_LOG');
$row = array();
$row[0] = array('序号', '发生日期', '类型', '影响金额', '可用余额', '冻结金额', '待收金额', '说明');
$i = 1;
foreach ($list['list'] as $v) {
$row[$i]['i'] = $i;
$row[$i]['uid'] = date("Y-m-d H:i:s", $v['add_time']);
$row[$i]['card_num'] = $v['type'];
$row[$i]['card_pass'] = $v['affect_money'];
$row[$i]['card_mianfei'] = $v['account_money'];
$row[$i]['card_mianfei0'] = $v['freeze_money'];
$row[$i]['card_mianfei1'] = $v['collect_money'];
$row[$i]['card_mianfei2'] = $v['info'];
$i++;
}
$xls = new Excel_XML('UTF-8', false, 'moneyLog');
$xls->addArray($row);
$xls->generateXML("moneyLog");
}
public function tradinglogadd()
{
$jsoncode = file_get_contents("php://input");
$arr = array();
$arr = json_decode($jsoncode, true);
if (intval($arr['uid']) != $this->uid) {
ajaxmsg("用户错误！", 0);
}
if (!is_array($arr) || empty($arr) || empty($arr['id'])) {
ajaxmsg("查询错误！", 0);
}
$id = $arr['id'];
$map['id'] = array('lt', $id);
$map['uid'] = $this->uid;
$list = getMoneyLog($map, 15);
if (is_array($list) && !empty($list)) {
$loglist = $list['list'];
foreach ($loglist as $key => $v) {
$_list[$key]['id'] = $v['id'];
$_list[$key]['add_time'] = date("Y-m-d", $v['add_time']);
$_list[$key]['affect_money'] = $v['affect_money'];
$_list[$key]['info'] = $v['info'];
$_list[$key]['type'] = $v['type'];
}
$m_list['list'] = $_list;
}
if (is_array($_list) && !empty($_list)) {
echo ajaxmsg($m_list);
} else {
echo ajaxmsg("暂无交易纪录", 0);
}
}
/**
* 资金记录
*/
public function records()
{
$logtype = C('MONEY_LOG');
$this->assign('log_type', $logtype);
$map['uid'] = $this->uid;
$list = getMoneyLog($map, 15);
$this->assign("list", $list['list']);
$this->assign("pagebar", $list['page']);
$this->assign("query", http_build_query($search));
$this->display();
}
public function index()
{
// $this->duizhang();
$ucLoing = de_xie($_COOKIE['LoginCookie']);
setcookie('LoginCookie', '', time() - 10 * 60, "/");
$this->assign("uclogin", $ucLoing);
$this->assign("unread", $read = M("inner_msg")->where("uid={$this->uid} AND status=0")->count('id'));
$this->assign("mstatus", M('members_status')->field(true)->find($this->uid));
$danbao = M('borrow_investor')->where("borrow_uid=" . $this->uid)->sum("guar_fee");
$this->assign("danbao", $danbao);
//die(M()->getlastsql());
//echo $danbao;exit;
//查询会员状态
$vip_status = M("members_status as ms")->field("ms.phone_status,ms.id_status,ms.email_status,ms.safequestion_status,lmb.uid")->join("left join lzh_member_banks as lmb on ms.uid=lmb.uid")->where('ms.uid=' . $this->uid)->find();
$this->vip = $vip_status;
$minfo = getMinfo($this->uid, true);
$pin_pass = $minfo['pin_pass'];
$has_pin = empty($pin_pass) ? "no" : "yes";
$this->assign("has_pin", $has_pin);
$this->assign("memberinfo", M('members')->find($this->uid));
$this->assign("memberdetail", M('member_info')->find($this->uid));
$this->assign("minfo", $minfo);
//加上新手标的利息 2015-09-18
$benefit = get_personal_benefit($this->uid);
//dump($benefit);
//查询新手标的代收利息
$newbieinterest = M('newbie_record')->field('interest')->where('investid=' . $this->uid . ' and status=4')->find();
//echo M()->getLastSql();
$benefit['interest_collection'] = $benefit['interest_collection'] + $newbieinterest['interest'];
$this->assign('benefit', $benefit);
//var_dump(get_personal_benefit($this->uid));
$this->assign('out', get_personal_out($this->uid));
$this->assign("bank", M('member_banks')->field('bank_num')->find($this->uid));
$info = getMemberDetail($this->uid);
$this->assign("info", $info);
$this->assign("kflist", get_admin_name());
$list = array();
$pre = C('DB_PREFIX');
$rule = M('ausers u')->field('u.id,u.qq,u.phone')->join("{$pre}members m ON m.customer_id=u.id")->where("u.is_kf =1 and m.customer_id={$minfo['customer_id']}")->select();
foreach ($rule as $key => $v) {
$list[$key]['qq'] = $v['qq'];
$list[$key]['phone'] = $v['phone'];
}
$this->assign("kfs", $list);
$_SX = M('investor_detail')->field('deadline,interest,capital')->where("investor_uid = {$this->uid} AND status=7")->order("deadline ASC")->find();
$lastInvest['gettime'] = $_SX['deadline'];
$lastInvest['interest'] = $_SX['interest'];
$lastInvest['capital'] = $_SX['capital'];
$this->assign("lastInvest", $lastInvest);
$_SX = "";
$_SX = M('investor_detail')->field('deadline,sum(interest) as interest,sum(capital) as capital')->where("borrow_uid = {$this->uid} AND status=7")->group("borrow_id,sort_order")->order("deadline ASC")->find();
$lastBorrow['gettime'] = $_SX['deadline'];
$lastBorrow['interest'] = $_SX['interest'];
$lastBorrow['capital'] = $_SX['capital'];
$this->assign("lastBorrow", $lastBorrow);
$map = array();
$map['uid'] = $this->uid;
$Log_list = getMoneyLog($map, 4);
$this->assign("Log_list", $Log_list['list']);
$this->assign("list", get_personal_count($this->uid));
//以下是我的投资详细
$zwmap['investor_uid'] = $this->uid;
$zwmap['status'] = 4;
$zwmap['Borrow.borrow_type'] = array('neq', 9);
$zwlist = getTenderList($zwmap, 1);
//显示真实姓名
if (is_array($zwlist['list'])) {
foreach ($zwlist['list'] as $zwkey => $zwval) {
$borrow_uid = $zwval['borrow_uid'];
$zwmap = " uid = {$borrow_uid} ";
$real_name = M("member_info")->field('real_name')->where($zwmap)->limit(1)->select();
$zwlist['list'][$zwkey]['real_name'] = $real_name[0]['real_name'];
unset($real_name);
}
}
//曲线走势图
$result = M("month_detail")->where("user_id=" . $this->uid)->find();
//去掉前三个
$res = array_slice($result, 3);
foreach ($res as $key => $value) {
$arr[] = $value;
}
if (max($arr) >= 10000) {
foreach ($arr as $key => $value) {
$brr[] = $value / 10000;
}
$this->char = "万元";
} else {
if (max($arr) >= 1000) {
foreach ($arr as $key => $value) {
$brr[] = $value / 1000;
}
$this->char = "千元";
} else {
if (max($arr) >= 100) {
foreach ($arr as $key => $value) {
$brr[] = $value / 100;
}
$this->char = "百元";
} else {
foreach ($arr as $key => $value) {
$brr[] = $value;
}
$this->char = "元";
}
}
}
if (count($brr) == 0) {
$brr = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$this->char = "元";
}
$brr = json_encode($brr);
$this->arr = $brr;
//传输到前端
//日历数据 具体日期具体还款
$month = date('m');
$firstday = date('Y-' . $month . '-01 00:00:00');
$firstsec = strtotime(date('Y-' . $month . '-01 00:00:00'));
//零点零分零秒
$lastsec = strtotime(date('Y-m-d 23:59:59', strtotime($firstday . "+1 month -1 day")));
//要查询的月末
$investor_uid = $this->uid;
//借款编号 借款者id 应收本金 应收利息 利息管理费 标的状态 还款时间 逾期罚金 借款者真实姓名
$caldata = M('investor_detail as lid')->field('lid.capital,lid.interest,lid.interest_fee,lid.deadline,lid.expired_money')->join("LEFT JOIN lzh_member_info as lmi on lid.borrow_uid = lmi.uid")->where("lid.investor_uid=" . $investor_uid . " and lid.repayment_time = '0' and lid.deadline>" . $firstsec . " and lid.deadline<" . $lastsec)->order('lid.deadline')->select();
foreach ($caldata as $key => $value) {
$calender[] = array(date('md', $value['deadline']), $value['capital'] + $value['interest'] + $value['expired_money'] - $value['interest_fee']);
}
$temp = array();
foreach ($calender as $key => $value) {
$key = $value['0'];
$temp[$key] = isset($temp[$key]) ? $value['1'] + $temp[$key] : $value['1'];
}
foreach ($temp as $key => $value) {
//$result[] = array('date' => $key, 'money' => $value);
$result[] = array($key => $value);
}
$res = array_slice($result, 15);
foreach ($res as $key => $value) {
foreach ($value as $k => $v) {
$ali[] = $k . '&' . $v;
}
}
$this->ali = json_encode($ali);
//最新日历数据遍历
// echo "<pre/>";var_dump($ali);
//日历结束
//推荐项目
//正在进行的贷款
$searchMap = array();
$searchMap['Borrow.borrow_status'] = array("eq", '2');
$searchMap['Borrow.is_tuijian'] = array("in", '0,1');
$searchMap['Borrow.borrow_type'] = array("neq", 9);
$searchMap['Borrow.is_new'] = array("eq", 0);
$listBorrow = getBorrowList($searchMap, 3);
$this->listBorrow = $listBorrow;
$this->assign("list", $zwlist['list']);
$this->assign("pagebar", $zwlist['page']);
$this->assign('uid', $this->uid);
//我的投资结束
$this->display();
}
public function jiangjin()
{
$jsoncode = file_get_contents("php://input");
// alogsm("jiangjin",0,1,session("u_id").$jsoncode);
$map['uid'] = $this->uid;
$map['type'] = array("in", "1,13");
$list = getMoneyLog($map, 10);
foreach ($list['list'] as $key => $v) {
$_list[$key]['add_time'] = date("Y-m-d", $v['add_time']);
$_list[$key]['affect_money'] = $v['affect_money'];
$_list[$key]['info'] = $v['info'];
}
$m_list['list'] = $_list;
if (is_array($_list) && !empty($_list)) {
echo ajaxmsg($m_list);
} else {
echo ajaxmsg("暂无奖金纪录", 0);
}
//$this->assign("list",$list['list']);
//$this->assign("pagebar",$list['page']);
//$data['html'] = $this->display();
}
public function index()
{
$ucLoing = de_xie($_COOKIE['LoginCookie']);
setcookie('LoginCookie', '', time() - 10 * 60, "/");
$this->assign("uclogin", $ucLoing);
$this->assign("unread", $read = M("inner_msg")->where("uid={$this->uid} AND status=0")->count('id'));
$this->assign("mstatus", M('members_status')->field(true)->find($this->uid));
//注册奖励，投了月标才可以得到
$get_data = M('global')->field("text")->where("code = 'is_reward'")->find();
$is_new = $get_data['text'];
if ($is_new == '1') {
$reward = M('borrow_investor')->field("borrow_id")->where("investor_uid = {$this->uid}")->select();
foreach ($reward as $key => $v) {
$borrow_type = M('borrow_info')->where("id = {$v['borrow_id']}")->find();
if ($borrow_type['borrow_type'] != 3) {
$rewards = M('members')->field("reward_zhuce")->where("id = {$this->uid} and is_new = 1")->find();
if ($rewards['reward_zhuce'] == 0.0) {
$get_data = M('global')->field("text")->where("code = 'nomb_reward'")->find();
$data['reward_zhuce'] = $get_data['text'];
//$data['is_new'] = 2;
$status = M('members')->where("id = {$this->uid} and is_new = 1")->save($data);
if ($status) {
$member_money = M("member_money")->where("uid = {$this->uid}")->find();
$members_money['account_money'] = $member_money['account_money'] + $data['reward_zhuce'];
$result = M("member_money")->where("uid = {$this->uid}")->save($members_money);
}
if ($result) {
$logs = M("member_money")->where("uid = {$this->uid}")->find();
$log['uid'] = $this->uid;
$log['type'] = 49;
$log['affect_money'] = $data['reward_zhuce'];
$log['account_money'] = $logs['account_money'];
$log['back_money'] = $logs['back_money'];
$log['collect_money'] = $logs['money_collect'];
$log['freeze_money'] = $logs['money_freeze'];
$log['info'] = "新用户注册奖励";
$log['add_time'] = time();
$log['add_ip'] = get_client_ip();
$log['target_uid'] = 0;
$log['target_uname'] = "手投网平台";
$rn = M('member_moneylog')->add($log);
break;
}
}
}
}
}
$reward_zhuce = M("members")->field("reward_zhuce")->where("id = {$this->uid}")->find();
$this->assign("reward_zhuce", $reward_zhuce['reward_zhuce']);
$minfo = getMinfo($this->uid, true);
$pin_pass = $minfo['pin_pass'];
$has_pin = empty($pin_pass) ? "no" : "yes";
$this->assign("has_pin", $has_pin);
$this->assign("memberinfo", M('members')->find($this->uid));
$this->assign("memberdetail", M('member_info')->find($this->uid));
$this->assign("minfo", $minfo);
$this->assign('benefit', get_personal_benefit($this->uid));
$this->assign('out', get_personal_out($this->uid));
$this->assign("bank", M('member_banks')->field('bank_num')->find($this->uid));
$info = getMemberDetail($this->uid);
$this->assign("info", $info);
$this->assign("kflist", get_admin_name());
$list = array();
$pre = C('DB_PREFIX');
$rule = M('ausers u')->field('u.id,u.qq,u.phone')->join("{$pre}members m ON m.customer_id=u.id")->where("u.is_kf =1 and m.customer_id={$minfo['customer_id']}")->select();
foreach ($rule as $key => $v) {
$list[$key]['qq'] = $v['qq'];
$list[$key]['phone'] = $v['phone'];
}
$this->assign("kfs", $list);
$_SX = M('investor_detail')->field('deadline,interest,capital')->where("investor_uid = {$this->uid} AND status=7")->order("deadline ASC")->find();
$lastInvest['gettime'] = $_SX['deadline'];
$lastInvest['interest'] = $_SX['interest'];
$lastInvest['capital'] = $_SX['capital'];
$this->assign("lastInvest", $lastInvest);
$_SX = "";
$_SX = M('investor_detail')->field('deadline,sum(interest) as interest,sum(capital) as capital')->where("borrow_uid = {$this->uid} AND status=7")->group("borrow_id,sort_order")->order("deadline ASC")->find();
$lastBorrow['gettime'] = $_SX['deadline'];
$lastBorrow['interest'] = $_SX['interest'];
$lastBorrow['capital'] = $_SX['capital'];
$this->assign("lastBorrow", $lastBorrow);
if (ListMobile()) {
if ($this->uid && M('members')->where('id=' . $this->uid . ' and ent=1')->count()) {
$redbag = M('redbag')->order('id desc')->where('status=1')->find();
//判断活动是否存在
$rid = $redbag['id'];
if ($rid) {
$usered = M('redbag_list')->where('uid=' . $this->uid . ' and pid=' . $rid)->count();
//判断是否领过红包
if (!$usered) {
$redinfo = M('redbag_list')->order('id asc')->where('uid=0 and pid=' . $rid . ' and status=1')->find();
//判断是否还有剩余红包
if ($redinfo) {
$this->assign('isredbag', true);
}
}
}
}
}
$map = array();
$map['uid'] = $this->uid;
$Log_list = getMoneyLog($map, 4);
$this->assign("Log_list", $Log_list['list']);
$this->assign("list", get_personal_count($this->uid));
$this->display();
}
