function getMemberInfoList($search = array(), $size = '') { $pre = C('DB_PREFIX'); $map = array(); $map = array_merge($map, $search); //分页处理 import("ORG.Util.Page"); $count = M('members m')->where($map)->count('m.id'); $p = new \Org\Util\Page($count, $size); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $field = "m.id,m.id as uid,m.user_name,mbank.uid as mbank_id,mi.uid as mi_id,mci.uid as mci_id,mhi.uid as mhi_id,mdpi.uid as mdpi_id,mei.uid as mei_id,mfi.uid as mfi_id"; $list = M('members m')->field($field)->join("{$pre}member_banks mbank ON m.id=mbank.uid")->join("{$pre}member_contact_info mci ON m.id=mci.uid")->join("{$pre}member_department_info mdpi ON m.id=mdpi.uid")->join("{$pre}member_house_info mhi ON m.id=mhi.uid")->join("{$pre}member_ensure_info mei ON m.id=mei.uid")->join("{$pre}member_info mi ON m.id=mi.uid")->join("{$pre}member_financial_info mfi ON m.id=mfi.uid")->where($map)->limit($Lsql)->order('m.id DESC')->select(); foreach ($list as $key => $v) { $is_data = M('member_data_info')->where("uid={$v['uid']}")->count("id"); $list[$key]['mbank'] = $v['mbank_id'] > 0 ? "<span style='color:green'>已填写</span>" : "<span style='color:black'>未填写</span>"; $list[$key]['mci'] = $v['mci_id'] > 0 ? "<span style='color:green'>已填写</span>" : "<span style='color:black'>未填写</span>"; $list[$key]['mdi'] = $is_data > 0 ? "<span style='color:green'>已填写(<a href='" . U('/admin/memberdata/index') . "?uid={$v['uid']}'>查看</a>)</span>" : "<span style='color:black'>未填写</span>"; $list[$key]['mhi'] = $v['mhi_id'] > 0 ? "<span style='color:green'>已填写</span>" : "<span style='color:black'>未填写</span>"; $list[$key]['mdpi'] = $v['mdpi_id'] > 0 ? "<span style='color:green'>已填写</span>" : "<span style='color:black'>未填写</span>"; $list[$key]['mei'] = $v['mei_id'] > 0 ? "<span style='color:green'>已填写</span>" : "<span style='color:black'>未填写</span>"; $list[$key]['mfi'] = $v['mfi_id'] > 0 ? "<span style='color:green'>已填写</span>" : "<span style='color:black'>未填写</span>"; $list[$key]['mi'] = $v['mi_id'] > 0 ? "<span style='color:green'>已填写</span>" : "<span style='color:black'>未填写</span>"; } $row = array(); $row['list'] = $list; $row['page'] = $page; return $row; }
/** +---------------------------------------------------------- * 默认操作 待审核提现 +---------------------------------------------------------- */ public function index() { $map = array(); if ($_REQUEST['uid'] && $_REQUEST['uname']) { $map['w.uid'] = $_REQUEST['uid']; $search['uid'] = $map['w.uid']; $search['uname'] = urldecode($_REQUEST['uname']); } if ($_REQUEST['uname'] && !$search['uid']) { $map['m.user_name'] = array("like", urldecode($_REQUEST['uname']) . "%"); $search['uname'] = urldecode($_REQUEST['uname']); } if ($_REQUEST['realname']) { $map['mi.real_name'] = urldecode($_REQUEST['realname']); $search['realname'] = $map['mi.real_name']; } if ($_REQUEST['deal_user']) { $map['w.deal_user'] = urldecode($_REQUEST['deal_user']); $search['deal_user'] = $map['w.deal_user']; } if (!empty($_REQUEST['bj']) && !empty($_REQUEST['money'])) { $map['w.withdraw_money'] = array($_REQUEST['bj'], $_REQUEST['money']); $search['bj'] = $_REQUEST['bj']; $search['money'] = $_REQUEST['money']; } if (!empty($_REQUEST['start_time']) && !empty($_REQUEST['end_time'])) { $timespan = strtotime(urldecode($_REQUEST['start_time'])) . "," . strtotime(urldecode($_REQUEST['end_time'])); $map['w.add_time'] = array("between", $timespan); $search['start_time'] = urldecode($_REQUEST['start_time']); $search['end_time'] = urldecode($_REQUEST['end_time']); } elseif (!empty($_REQUEST['start_time'])) { $xtime = strtotime(urldecode($_REQUEST['end_time'])); $map['w.add_time'] = array("gt", $xtime); $search['start_time'] = $xtime; } elseif (!empty($_REQUEST['end_time'])) { $xtime = strtotime(urldecode($_REQUEST['end_time'])); $map['w.add_time'] = array("lt", $xtime); $search['end_time'] = $xtime; } //if(session('admin_is_kf')==1) $map['m.customer_id'] = session('admin_id'); //分页处理 import("ORG.Util.Page"); $map['w.withdraw_status'] = 0; $count = M('member_withdraw w')->join("{$this->pre}members m ON m.id=w.uid ")->join("lzh_member_info mi ON w.uid=mi.uid")->where($map)->count('w.id'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $field = 'w.*,m.user_name,mi.real_name,w.id,w.uid,(mm.account_money+mm.back_money) all_money'; $list = M('member_withdraw w')->field($field)->join("lzh_members m ON w.uid=m.id")->join("lzh_member_info mi ON w.uid=mi.uid")->join("lzh_member_money mm on w.uid = mm.uid")->where($map)->order(' w.id DESC ')->limit($Lsql)->select(); $listType = C('WITHDRAW_STATUS'); unset($listType[1], $listType[2], $listType[3]); $this->assign("bj", array("gt" => '大于', "eq" => '等于', "lt" => '小于')); $this->assign("list", $list); $this->assign("status", $listType); $this->assign("pagebar", $page); $this->assign("search", $search); $this->assign("query", http_build_query($search)); $this->display(); }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { import("ORG.Util.Page"); $AdminU = M('ausers'); $page_size = $page_szie == 0 ? C('ADMIN_PAGE_SIZE') : $page_szie; $count = $AdminU->count(); // 查询满足要求的总记录数 $Page = new \Org\Util\Page($count, $page_size); // 实例化分页类传入总记录数和每页显示的记录数 $show = $Page->show(); // 分页显示输出 $fields = "id,user_name,u_group_id,real_name,is_ban,area_name,is_kf,qq,phone,user_word"; $order = "id DESC,u_group_id DESC"; $list = $AdminU->field($fields)->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $AdminUserList = $list; $GroupArr = get_group_data(); foreach ($AdminUserList as $key => $v) { $AdminUserList[$key]['groupname'] = $GroupArr[$v['u_group_id']]['groupname']; } $this->assign('position', '管理员管理'); $this->assign('pagebar', $show); $this->assign('admin_list', $AdminUserList); $this->assign('group_list', $GroupArr); $this->display(); }
public function files() { if (!isAdmin()) { exit(L('all.notlogin')); } $folders = F('folders'); $foldersoption = F('foldersoption'); $folderrow = $folders[I('get.folderid')]; import('ORG.Util.Page'); $attach = D('attachments'); $count = $attach->where($map)->count(); $Page = new \Org\Util\Page($count, 10); $Page->rollPage = 5; $show = $Page->show(); // 进行分页数据查询 $page = intval(I('get.page')); $nowPage = isset($page) ? $page : 1; $list = $attach->order('uploadtime DESC')->where('folderid=' . I('get.folderid'))->page($nowPage . ',' . $Page->listRows)->select(); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->assign('folderrow', $folderrow); $this->assign('foldersoption', $foldersoption); $this->display(); // 输出模板 }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { $this->pre = C('DB_PREFIX'); $map = array(); if (!empty($_REQUEST['runame'])) { $ruid = M("members")->getFieldByUserName(text($_REQUEST['runame']), 'id'); $map['m.recommend_id'] = $ruid; } else { $map['m.recommend_id'] = array('NEQ', '0'); } if ($_REQUEST['uname']) { $map['m.user_name'] = array("like", urldecode($_REQUEST['uname']) . "%"); $search['uname'] = urldecode($_REQUEST['uname']); } if (!empty($_REQUEST['start_time']) && !empty($_REQUEST['end_time'])) { $timespan = strtotime(urldecode($_REQUEST['start_time'])) . "," . strtotime(urldecode($_REQUEST['end_time'])); $map['bi.add_time'] = array("between", $timespan); $search['start_time'] = urldecode($_REQUEST['start_time']); $search['end_time'] = urldecode($_REQUEST['end_time']); } elseif (!empty($_REQUEST['start_time'])) { $xtime = strtotime(urldecode($_REQUEST['start_time'])); $map['bi.add_time'] = array("gt", $xtime); $search['start_time'] = $xtime; } elseif (!empty($_REQUEST['end_time'])) { $xtime = strtotime(urldecode($_REQUEST['end_time'])); $map['bi.add_time'] = array("lt", $xtime); $search['end_time'] = $xtime; } if (session('admin_is_kf') == 1 && m . customer_id != 0) { $map['m.customer_id'] = session('admin_id'); } //分页处理 import("ORG.Util.Page"); $xcount = M('borrow_investor bi')->field('id,reward_money', true)->join("{$this->pre}members m ON m.id = bi.investor_uid")->where($map)->group('bi.investor_uid')->buildSql(); // $xcount =M('borrow_investor bi')->join("{$this->pre}members m ON m.id = bi.investor_uid")->where($map)->group('bi.investor_uid')->select(); // debug($xcount); $newxsql = M()->query("select count(*) as tc from {$xcount} as t"); $count = $newxsql[0]['tc']; // $count = count($xcount); // debug($count); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $field = ' sum(bi.investor_capital) investor_capital,count(bi.id) total,bi.investor_uid,m.recommend_id,m.id,m.user_name'; $list = M('borrow_investor bi')->join("{$this->pre}members m ON m.id = bi.investor_uid")->field($field)->where($map)->group('bi.investor_uid')->limit($Lsql)->select(); $tfield = ' sum(bi.investor_capital) investor_capital,count(bi.id) total,bi.investor_uid,m.recommend_id,m.id,m.user_name'; $tlist = M('transfer_borrow_investor bi')->join("{$this->pre}members m ON m.id = bi.investor_uid")->field($tfield)->where($map)->group('bi.investor_uid')->limit($Lsql)->find(); foreach ($list as $key => $v) { $list[$key]['investor_capital'] = $v['investor_capital'] + $tlist['investor_capital']; $list[$key]['total'] = $v['total'] + $tlist['total']; } $list = $this->_listFilter($list); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("search", $search); $this->assign("query", http_build_query($search)); $this->display(); }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { $map = array(); if ($_REQUEST['uid'] && $_REQUEST['uname']) { $map['l.uid'] = $_REQUEST['uid']; $search['uid'] = $map['l.uid']; $search['uname'] = urldecode($_REQUEST['uname']); } if ($_REQUEST['uname'] && !$search['uid']) { $map['m.user_name'] = array("like", urldecode($_REQUEST['uname']) . "%"); $search['uname'] = urldecode($_REQUEST['uname']); } if ($_REQUEST['target_uname']) { $map['l.target_uname'] = urldecode($_REQUEST['target_uname']); $search['target_uname'] = $map['l.target_uname']; } if (isset($_REQUEST['type']) && $_REQUEST['type'] != '') { $map['l.type'] = intval($_REQUEST['type']); $search['type'] = $map['l.type']; } if (!empty($_REQUEST['bj']) && !empty($_REQUEST['money'])) { $map['l.affect_money'] = array($_REQUEST['bj'], $_REQUEST['money']); $search['bj'] = $_REQUEST['bj']; $search['money'] = $_REQUEST['money']; } if (!empty($_REQUEST['start_time']) && !empty($_REQUEST['end_time'])) { $timespan = strtotime(urldecode($_REQUEST['start_time'])) . "," . strtotime(urldecode($_REQUEST['end_time'])); $map['l.add_time'] = array("between", $timespan); $search['start_time'] = urldecode($_REQUEST['start_time']); $search['end_time'] = urldecode($_REQUEST['end_time']); } elseif (!empty($_REQUEST['start_time'])) { $xtime = strtotime(urldecode($_REQUEST['start_time'])); $map['l.add_time'] = array("gt", $xtime); $search['start_time'] = $xtime; } elseif (!empty($_REQUEST['end_time'])) { $xtime = strtotime(urldecode($_REQUEST['end_time'])); $map['l.add_time'] = array("lt", $xtime); $search['end_time'] = $xtime; } //if(session('admin_is_kf')==1) $map['m.customer_id'] = session('admin_id'); //分页处理 import("ORG.Util.Page"); $count = M('member_moneylog l')->join("{$this->pre}members m ON m.id=l.uid")->where($map)->count('l.id'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $field = 'l.id,l.add_time,m.user_name,l.affect_money,l.freeze_money,l.collect_money,(l.account_money+l.back_money) account_money,l.target_uname,l.type,l.info'; $order = "l.id DESC"; $list = M('member_moneylog l')->field($field)->join("{$this->pre}members m ON m.id=l.uid")->where($map)->limit($Lsql)->order($order)->select(); $this->assign("bj", array("gt" => '大于', "eq" => '等于', "lt" => '小于')); $this->assign("type", C('MONEY_LOG')); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("search", $search); $this->assign("query", http_build_query($search)); $this->display(); }
public function getTendBacking() { import("ORG.Util.Page"); $map = "(investor_uid={$this->uid} or debt_uid={$this->uid}) and status=4"; $count = M("borrow_investor")->where($map)->count("id"); $Page = new \Org\Util\Page($count, 14); $list['list'] = M("borrow_investor i")->join(C('DB_PREFIX') . "borrow_info b ON i.borrow_id=b.id")->join(C('DB_PREFIX') . "members m ON i.investor_uid=m.id")->join(C('DB_PREFIX') . "invest_detb d ON i.id=d.invest_id")->field("i.borrow_id, b.borrow_name, m.user_name as borrow_user, \n i.investor_capital, b.borrow_interest_rate, i.receive_interest, i.receive_capital,\n b.total, b.has_pay, i.id, d.period, d.status, i.debt_uid")->where("(i.investor_uid={$this->uid} or i.debt_uid={$this->uid}) and i.status=4")->limit($Page->firstRow . ',' . $Page->listRows)->select(); $list['page'] = $Page->show(); return $list; }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { $map = array(); if ($_REQUEST['uname']) { $map['m.user_name'] = array("like", urldecode($_REQUEST['uname']) . "%"); $search['uname'] = urldecode($_REQUEST['uname']); } if ($_REQUEST['realname']) { $map['mi.real_name'] = urldecode($_REQUEST['realname']); $search['realname'] = $map['mi.real_name']; } if (!empty($_REQUEST['bj']) && !empty($_REQUEST['lx']) && !empty($_REQUEST['money'])) { if ($_REQUEST['lx'] == 'allmoney') { if ($_REQUEST['bj'] == 'gt') { $bj = '>'; } else { if ($_REQUEST['bj'] == 'lt') { $bj = '<'; } else { if ($_REQUEST['bj'] == 'eq') { $bj = '='; } } } $map['_string'] = "(mm.account_money+mm.back_money) " . $bj . $_REQUEST['money']; } else { $map[$_REQUEST['lx']] = array($_REQUEST['bj'], $_REQUEST['money']); } $search['bj'] = $_REQUEST['bj']; $search['lx'] = $_REQUEST['lx']; $search['money'] = $_REQUEST['money']; } if (isset($_REQUEST['status']) && $_REQUEST['status'] != '') { $map['v.apply_status'] = $_REQUEST['status']; $search['status'] = $map['v.apply_status']; } //if(session('admin_is_kf')==1) $map['m.customer_id'] = session('admin_id'); //分页处理 import("ORG.Util.Page"); $count = M('video_apply v')->join("{$this->pre}members m ON m.id=v.uid")->join("{$this->pre}member_money mm ON mm.uid=m.id")->join("{$this->pre}member_info mi ON mi.uid=m.id")->where($map)->count('m.id'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $field = 'v.id,v.add_time,v.uid,v.apply_status,m.user_phone,m.reg_time,m.user_name,mi.real_name,mm.money_freeze,mm.money_collect,(mm.account_money+mm.back_money) account_money'; $list = M('video_apply v')->field($field)->join("{$this->pre}members m ON m.id=v.uid")->join("{$this->pre}member_money mm ON mm.uid=m.id")->join("{$this->pre}member_info mi ON mi.uid=m.id")->where($map)->limit($Lsql)->order('v.id DESC')->select(); $this->assign("status", array('待审核', '已通过审核', '未通过审核')); $this->assign("bj", array("gt" => '大于', "eq" => '等于', "lt" => '小于')); $this->assign("lx", array("allmoney" => '可用余额', "mm.money_freeze" => '冻结金额', "mm.money_collect" => '待收金额')); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("search", $search); $this->assign("query", http_build_query($search)); $this->display(); }
public function message() { $Messages = D('messages'); $totalRows = $Messages->count(); import("Org.Util.Page"); $Page = new \Org\Util\Page($totalRows, '15'); $show = $Page->show(); $messages = $Messages->order("time desc,id")->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('messages', $messages); $this->assign('pageStr', $show); $this->display(); }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { $pre = C('DB_PREFIX'); $field = true; $map = array(); if ($_REQUEST['status']) { $map['s.id_status'] = intval($_REQUEST['status']); $search['status'] = $map['s.id_status']; } else { $map['s.id_status'] = array("in", "1,3"); } if ($_REQUEST['uname']) { $map['m.user_name'] = text($_REQUEST['uname']); $search['uname'] = $map['m.user_name']; } if ($_REQUEST['realname']) { $map['mi.real_name'] = urldecode($_REQUEST['realname']); $search['real_name'] = $map['mi.real_name']; } if ($_REQUEST['idcard']) { $map['mi.idcard'] = urldecode($_REQUEST['idcard']); $search['idcard'] = $map['mi.idcard']; } if (!empty($_REQUEST['start_time']) && !empty($_REQUEST['end_time'])) { $timespan = strtotime(urldecode($_REQUEST['start_time'])) . "," . strtotime(urldecode($_REQUEST['end_time'])); $map['mi.up_time'] = array("between", $timespan); $search['start_time'] = urldecode($_REQUEST['start_time']); $search['end_time'] = urldecode($_REQUEST['end_time']); } elseif (!empty($_REQUEST['start_time'])) { $xtime = strtotime(urldecode($_REQUEST['start_time'])); $map['mi.up_time'] = array("gt", $xtime); $search['start_time'] = $xtime; } elseif (!empty($_REQUEST['end_time'])) { $xtime = strtotime(urldecode($_REQUEST['end_time'])); $map['mi.up_time'] = array("lt", $xtime); $search['end_time'] = $xtime; } //if(session('admin_is_kf')==1) $map['m.customer_id'] = session('admin_id'); import("ORG.Util.Page"); $count = M('members_status s')->join("{$pre}members m ON m.id=s.uid")->join("{$pre}member_info mi ON mi.uid=s.uid")->where($map)->count('s.uid'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; $list = M('members_status s')->field('s.uid,s.id_status,mi.up_time,mi.card_img,mi.card_back_img,mi.real_name,mi.idcard,m.user_name')->join("{$pre}members m ON m.id=s.uid")->join("{$pre}member_info mi ON mi.uid=s.uid")->where($map)->order("mi.up_time DESC")->limit($Lsql)->select(); $this->assign("status", array("1" => '已认证', "3" => '待认证')); $this->assign("search", $search); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("query", http_build_query($search)); $this->display(); }
public function photos() { $pid = I('get.pid', 1); $catamodel = M('catagory'); $catalist = $catamodel->field('id,name')->select(); $projmodel = M('project'); $preview = $projmodel->where(array('id' => $pid))->getField('preview'); $projphotomodel = M('projectphoto'); $projphotomodelmap = array('pid' => $pid); $count = $projphotomodel->where($projphotomodelmap)->count(); $p = new \Org\Util\Page($count, 9); $p->setConfig('prev', '<img src="' . SITE_PATH . 'Public/Img/GC/prev_button.png"></img>'); $p->setConfig('next', '<img src="' . SITE_PATH . 'Public/Img/GC/next_button.png"></img>'); $p->setConfig('last', 'the last Page'); $p->setConfig('first', 'the first Page'); $p->setConfig('theme', '%upPage% %first% %prePage% %linkPage% %downPage% %nextPage% %end%'); $list = $projphotomodel->where($projphotomodelmap)->order('`id` DESC')->limit($p->firstRow . "," . $p->listRows)->select(); $show = $p->show(); $this->assign("show", $show); $this->assign('catalist', $catalist); $this->assign('photolist', $list); $this->assign('preview', $preview); $this->assign('pid', $pid); $this->assign('refurl', 'Public/Img/GC/banners/banner_clientlist.png'); $this->display('index'); }
public function index() { if ($_GET['user_name']) { $search['user_name'] = text($_GET['user_name']); } else { $search = array(); } import("ORG.Util.Page"); $count = M('member_remark')->where($search)->count(); $p = new \Org\Util\Page($count, $size); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; $list = M('member_remark')->where($search)->limit($Lsql)->order('id DESC')->select(); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("search", $search); $this->display(); }
public function index() { $map = array(); if ($_REQUEST['se_type'] != "") { $map['mf.type'] = intval($_REQUEST['se_type']); $search['type'] = $map['mf.type']; } if ($_REQUEST['status'] != "") { $map['mf.status'] = intval($_REQUEST['status']); } if (!empty($_REQUEST['uname']) && !$_REQUEST['uid']) { $uid = M("members")->getFieldByUserName(text($_REQUEST['uname']), 'id'); $map['mf.uid'] = $uid; $search['uname'] = $_REQUEST['uname']; } if (!empty($_REQUEST['uid'])) { $map['mf.uid'] = intval($_REQUEST['uid']); $search['uid'] = $map['mf.uid']; $search['uname'] = $_REQUEST['uname']; } if ($_REQUEST['customer_id'] && $_REQUEST['customer_name']) { $map['m.customer_id'] = $_REQUEST['customer_id']; $search['customer_id'] = $map['m.uid']; $search['customer_name'] = urldecode($_REQUEST['customer_name']); } if ($_REQUEST['customer_name'] && !$search['customer_id']) { $cusname = urldecode($_REQUEST['customer_name']); $kfid = M('ausers')->getFieldByUserName($cusname, 'id'); $map['m.customer_id'] = $kfid; $search['customer_name'] = $cusname; $search['customer_id'] = $kfid; } import("ORG.Util.Page"); $count = M('member_data_info mf')->join("{$this->pre}members m ON m.id=mf.uid")->where($map)->count('mf.uid'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; $list = M('member_data_info mf')->field('mf.*,au.real_name,m.user_name as uname,m.customer_name')->join("{$this->pre}members m ON m.id=mf.uid")->join("{$this->pre}ausers au ON au.id=mf.deal_user")->where($map)->limit($Lsql)->order("mf.id DESC")->select(); $list = $this->_listFilter($list); $this->assign('search', $search); $this->assign('list', $list); $this->assign('pagebar', $page); $this->display(); }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { import("ORG.Util.Page"); $Acl = M('acl'); $page_size = $page_szie == 0 ? C('ADMIN_PAGE_SIZE') : $page_szie; $count = $Acl->count(); // 查询满足要求的总记录数 $Page = new \Org\Util\Page($count, $page_size); // 实例化分页类传入总记录数和每页显示的记录数 $show = $Page->show(); // 分页显示输出 $fields = "group_id as id,groupname"; $order = "id DESC"; $list = $Acl->field($fields)->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $AclList = $list; $this->assign('position', '用户组权限'); $this->assign('pagebar', $show); $this->assign('acl_list', $AclList); $this->display(); }
public function sysmsg() { $map['uid'] = $this->uid; //分页处理 import("ORG.Util.Page"); $count = M('inner_msg')->where($map)->count('id'); $p = new \Org\Util\Page($count, 15); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $list = M('inner_msg')->where($map)->order('id DESC')->limit($Lsql)->select(); $read = M("inner_msg")->where("uid={$this->uid} AND status=1")->count('id'); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("read", $read); $this->assign("unread", $count - $read); $this->assign("count", $count); $data['html'] = $this->fetch(); exit(json_encode($data)); }
public function getkf() { $map['is_kf'] = 1; $count = M('ausers')->where($map)->count('id'); if ($count == 0) { unset($map['area_id']); } //分页处理 import("ORG.Util.Page"); $count = M('ausers')->where($map)->count('id'); $p = new \Org\Util\Page($count, $size); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $list = M('ausers')->where($map)->limit($Lsql)->select(); $this->assign("list", $list); $this->assign("count", $count); $this->assign("page", $page); $data['html'] = $this->fetch(); ajaxmsg($data); }
public function index() { //网站公告 $parm['type_id'] = 1; $parm['limit'] = 8; $this->assign("noticeList", getArticleList($parm)); $per = C('DB_PREFIX'); $page_size = C('HOME_SHOP_PAGE_SIZE'); $Market = M('market_goods'); import("Org.Util.Page"); $condition = "is_sys=1"; $count = $Market->where($condition)->count(); $Page = new \Org\Util\Page($count, $page_size); $show = $Page->show(); $list = M('market_goods')->where($condition)->order("order_sn DESC")->limit($Page->firstRow . ', ' . $Page->listRows)->select(); $list_log = M('market_log l')->field("l.*,m.user_name")->join("{$per}members m ON m.id=l.uid")->where("l.type=1")->order("l.price DESC")->limit(10)->select(); //dump($list_log);exit; $this->assign("list", $list); $this->assign("list_log", $list_log); $this->assign('pagebar', $show); $this->display(); }
public function manage() { $cid = intval(I('get.cid')); $keyword = trim(I('get.k')); $orderby = I('get.orderby'); $orderby = empty($orderby) ? "ordernum,id" : $orderby; $orderbystr = ''; $keyword = str_replace("*", "%", $keyword); if (!empty($cid)) { $cond .= "cid={$cid}"; } if (!empty($keyword)) { if ($cond != "") { $cond .= " and "; } $cond .= "(title like '%{$keyword}%' or content like '%{$keyword}%')"; } if (in_array($orderby, array('ordernum,aid', 'posttime', 'hits'))) { $orderbystr = $orderby . ' desc'; } $Articles = D('articles'); $totalRows = $Articles->count(); import("Org.Util.Page"); $Page = new \Org\Util\Page($totalRows, '18'); $Page->setConfig('theme', '<ul class="pagination"><li><a href="javascript:;">%totalRow% %header% %nowPage%/%totalPage% 页</a></li><li> %upPage%</li><li>%downPage%</li><li>%first%</li><li>%prePage%</li>%linkPage%<li>%nextPage%</li><li>%end%</li></ul>'); $show = $Page->show(); $articles = $Articles->where($cond)->order($orderbystr)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $cache_artcates = F('artcates_option'); $artcates = F('artcates'); $this->assign('artcates', $artcates); $this->assign('options', $cache_artcates); $this->assign('articles', $articles); $this->assign('pageStr', $show); $this->assign('cid', $cid); $this->assign('keyword', $keyword); $this->assign('orderby', $orderby); $this->display(); }
public function applylog() { $Binfo = (require C("APP_ROOT") . "Conf/borrow_config.php"); $size = 10; $map['uid'] = $this->uid; //分页处理 import("ORG.Util.Page"); $count = M('member_apply')->where($map)->count('id'); $p = new \Org\Util\Page($count, $size); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $status_arr = array('待审核', '审核通过', '审核未通过'); $list = M('member_apply')->where($map)->order('id DESC')->limit($Lsql)->select(); foreach ($list as $key => $v) { $list[$key]['status'] = $status_arr[$v['apply_status']]; } $this->assign("aType", $Binfo['APPLY_TYPE']); $this->assign("list", $list); $this->assign("pagebar", $page); $json['html'] = $this->fetch(); exit(json_encode($json)); }
function getAreaArticleList($parm) { if (empty($parm['type_id'])) { return; } $map['type_id'] = $parm['type_id']; $Osql = "id DESC"; $field = "id,title,art_set,art_time,art_url,area_id"; //查询条件 if ($parm['pagesize']) { //分页处理 import("ORG.Util.Page"); $count = M('article_area')->where($map)->count('id'); $p = new \Org\Util\Page($count, $parm['pagesize']); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 } else { $page = ""; $Lsql = "LIMIT {$parm['limit']}"; } $data = M('article_area')->field($field)->where($map)->order($Osql)->limit($Lsql)->select(); $suffix = C("URL_HTML_SUFFIX"); $typefix = get_type_leve_area_nid($map['type_id'], $parm['area_id']); $typeu = implode("/", $typefix); foreach ($data as $key => $v) { if ($v['art_set'] == 1) { $data[$key]['arturl'] = stripos($v['art_url'], "http://") === false ? "http://" . $v['art_url'] : $v['art_url']; } else { $data[$key]['arturl'] = MU("Home/{$typeu}", "article", array("id" => "id-" . $v['id'], "suffix" => $suffix)); } } $row = array(); $row['list'] = $data; $row['page'] = $page; return $row; }
public function index() { //列出产品、分页 $cid = intval(I('get.cid', 0)); $pagecid = ''; //分页用 $cond = ''; //新闻查询条件 $cate_id = 0; if ($cid) { $pagecid = '/cid/' . $cid; $cond = 'cid=' . $cid; $artcate = M('artcates')->where("cid=%d", $cid)->find(); if ($artcate['pid'] != '0') { $cate_id = $artcate['pid']; } } $this->assign('cid', $cid); $this->assign('cate_id', $cate_id); $totalRows = M('articles')->where($cond)->count(); import("Org.Util.Page"); $listcount = M('setting')->find(); $Page = new \Org\Util\Page($totalRows, $listcount['list_news'], '', 'article/index' . $pagecid); //分页语种自定义 $Page->setConfig('header', ''); $Page->setConfig('first', '<<'); $Page->setConfig('last', '>>'); $Page->setConfig('theme', '<ul class="pagination"><li>%header%</li><li>%first%</li><li>%prePage%</li>%linkPage%<li>%nextPage%</li><li>%end%</li></ul>'); $show = $Page->show(); $articles = M('articles')->where($cond)->field("aid,cid,posttime,title,author,content")->order("ordernum,aid")->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('articles', $articles); $this->assign('pageStr', $show); //seo信息 $seo = M('channels')->where("name='article'")->field('title,seotitle,metakeywords,metadesc')->find(); $this->assign('seo', $seo); //location位置信息 if ($cid) { if ($artcate['seotitle']) { $seo['seotitle'] = $artcate['seotitle']; } if ($artcate['metakeywords']) { $seo['metakeywords'] = $artcate['metakeywords']; } if ($artcate['metadesc']) { $seo['metadesc'] = $artcate['metadesc']; } $location = "<li><a href='/article.html'>" . $seo['title'] . "</a></li><li class='active'>" . $artcate['title'] . "</li>"; } else { $location = "<li class='active'>" . $seo['title'] . "</li>"; } $this->assign('location', $location); $this->display('list'); }
public function index() { //列出产品、分页 $Cases = D('cases'); $catetype = 0; $catequery = "protype=all"; $pagecid = ""; if (I('get.protype')) { $cond = intval(I('get.protype')); $this->assign('activetype', $cond); $cond = "protype={$cond}"; $catequery = $cond; $pagecid = "/protype/" . I("get.protype"); } elseif (I('get.areatype')) { $cond = intval(I('get.areatype')); $this->assign('activetype', $cond); $cond = "areatype={$cond}"; $catequery = $cond; $catetype = 1; $pagecid = "/areatype/" . I("get.areatype"); } $this->assign('catequery', $catequery); $this->assign('catetype', $catetype); $totalRows = $Cases->where($cond)->count(); import("Org.Util.Page"); $Page = new \Org\Util\Page($totalRows, 36, "", "cases/index{$pagecid}"); //分页语种自定义 $Page->setConfig('header', ''); $Page->setConfig('first', '<<'); $Page->setConfig('last', '>>'); $Page->setConfig('theme', '<ul class="pagination"><li>%header%</li><li>%first%</li><li>%prePage%</li>%linkPage%<li>%nextPage%</li><li>%end%</li></ul>'); $show = $Page->show(); $cases = $Cases->where($cond)->field("caseid,protype,areatype,posttime,title,picpath")->order('posttime desc,caseid')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('cases', $cases); $this->assign('pageStr', $show); //左侧产品分类 $Procates = D('Procates'); $pars = $Procates->where('pid=0')->order('ordernum,cid')->select(); $this->assign('procates', $pars); //seo信息 $seo = D('channels')->where("name='case'")->field('title,seotitle,metakeywords,metadesc')->find(); $this->assign('seo', $seo); //location位置信息 $location = "<li class='active'><a href='/cases.html'>工程案例</a></li>"; $this->assign('location', $location); $this->display('list', 'utf-8'); }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { $map = array(); if ($_REQUEST['uname']) { $map['m.user_name'] = array("like", urldecode($_REQUEST['uname']) . "%"); $search['uname'] = urldecode($_REQUEST['uname']); } if ($_REQUEST['realname']) { $map['mi.real_name'] = urldecode($_REQUEST['realname']); $search['realname'] = $map['mi.real_name']; } if ($_REQUEST['is_vip'] == 'yes') { $map['m.user_leve'] = 1; $map['m.time_limit'] = array('gt', time()); $search['is_vip'] = 'yes'; } elseif ($_REQUEST['is_vip'] == 'no') { $map['_string'] = 'm.user_leve=0 OR m.time_limit<' . time(); $search['is_vip'] = 'no'; } if ($_REQUEST['is_transfer'] == 'yes') { $map['m.is_transfer'] = 1; } elseif ($_REQUEST['is_transfer'] == 'no') { $map['m.is_transfer'] = 0; } //if(session('admin_is_kf')==1){ // $map['m.customer_id'] = session('admin_id'); //}else{ if ($_REQUEST['customer_name']) { $map['m.customer_id'] = $_REQUEST['customer_id']; $search['customer_id'] = $map['m.customer_id']; $search['customer_name'] = urldecode($_REQUEST['customer_name']); } if ($_REQUEST['customer_name']) { $cusname = urldecode($_REQUEST['customer_name']); $kfid = M('ausers')->getFieldByUserName($cusname, 'id'); $map['m.customer_id'] = $kfid; $search['customer_name'] = $cusname; $search['customer_id'] = $kfid; } //} if (!empty($_REQUEST['bj']) && !empty($_REQUEST['lx']) && !empty($_REQUEST['money'])) { if ($_REQUEST['lx'] == 'allmoney') { if ($_REQUEST['bj'] == 'gt') { $bj = '>'; } else { if ($_REQUEST['bj'] == 'lt') { $bj = '<'; } else { if ($_REQUEST['bj'] == 'eq') { $bj = '='; } } } $map['_string'] = "(mm.account_money+mm.back_money) " . $bj . $_REQUEST['money']; } else { $map[$_REQUEST['lx']] = array($_REQUEST['bj'], $_REQUEST['money']); } $search['bj'] = $_REQUEST['bj']; $search['lx'] = $_REQUEST['lx']; $search['money'] = $_REQUEST['money']; } if (!empty($_REQUEST['start_time']) && !empty($_REQUEST['end_time'])) { $timespan = strtotime(urldecode($_REQUEST['start_time'])) . "," . strtotime(urldecode($_REQUEST['end_time'])); $map['m.reg_time'] = array("between", $timespan); $search['start_time'] = urldecode($_REQUEST['start_time']); $search['end_time'] = urldecode($_REQUEST['end_time']); } elseif (!empty($_REQUEST['start_time'])) { $xtime = strtotime(urldecode($_REQUEST['start_time'])); $map['m.reg_time'] = array("gt", $xtime); $search['start_time'] = $xtime; } elseif (!empty($_REQUEST['end_time'])) { $xtime = strtotime(urldecode($_REQUEST['end_time'])); $map['m.reg_time'] = array("lt", $xtime); $search['end_time'] = $xtime; } //分页处理 import("ORG.Util.Page"); $count = M('members m')->join("{$this->pre}member_money mm ON mm.uid=m.id")->join("{$this->pre}member_info mi ON mi.uid=m.id")->where($map)->count('m.id'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $field = 'm.id,m.user_phone,m.reg_time,m.user_name,m.customer_name,m.user_leve,m.time_limit,mi.real_name,mm.money_freeze,mm.money_collect,(mm.account_money+mm.back_money) account_money,m.user_email,m.recommend_id,m.is_borrow,m.is_vip'; $list = M('members m')->field($field)->join("{$this->pre}member_money mm ON mm.uid=m.id")->join("{$this->pre}member_info mi ON mi.uid=m.id")->where($map)->limit($Lsql)->order('m.id DESC')->select(); $list = $this->_listFilter($list); $this->assign("bj", array("gt" => '大于', "eq" => '等于', "lt" => '小于')); $this->assign("lx", array("allmoney" => '可用余额', "mm.money_freeze" => '冻结金额', "mm.money_collect" => '待收金额')); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("search", $search); $this->assign("query", http_build_query($search)); $this->display(); }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function index() { if (!empty($_REQUEST['status']) && $_REQUEST['status'] > -1) { $map['status'] = intval($_REQUEST['status']); $search['status'] = $map['status']; } else { $search['status'] = -1; } if (!empty($_REQUEST['way'])) { if ($_REQUEST['way'] == '线下充值') { $map['way'] = 'off'; //$_REQUEST['way']; } else { $map['way'] = $_REQUEST['way']; } } //if(!empty($_REQUEST['uname'])){ // $uid = M("members")->getFieldByUserName(text(urldecode($_REQUEST['uname'])),'id'); // $map['uid'] = $uid; // $search['uid'] = $map['uid']; //} if ($_REQUEST['uname']) { $map['m.user_name'] = array("like", urldecode($_REQUEST['uname']) . "%"); $search['uname'] = urldecode($_REQUEST['uname']); } if ($_REQUEST['realname']) { $map['mi.real_name'] = urldecode($_REQUEST['realname']); $search['realname'] = $map['mi.real_name']; } if (!empty($_REQUEST['dealuser'])) { $map['deal_user'] = text(urldecode($_REQUEST['dealuser'])); $search['dealuser'] = $map['deal_user']; } if (!empty($_REQUEST['uid'])) { $map['uid'] = intval($_REQUEST['uid']); $search['uid'] = $map['uid']; } if (!empty($_REQUEST['start_time']) && !empty($_REQUEST['end_time'])) { $start_time = strtotime($_REQUEST['start_time'] . " 00:00:00"); $end_time = strtotime($_REQUEST['end_time'] . " 23:59:59"); $map['add_time'] = array("between", "{$start_time},{$end_time}"); $search['start_time'] = $_REQUEST['start_time']; $search['end_time'] = $_REQUEST['end_time']; $xtime['start_time'] = $_REQUEST['start_time']; $xtime['end_time'] = $_REQUEST['end_time']; } /*$this->assign('search',$search); $listType = C('PAYLOG_TYPE'); $listType[-1]="不限制"; $this->assign('type_list',$listType); $field= 'id,uid,status,money,add_time,tran_id,way,off_bank,off_way,deal_user'; $this->_list(D('Paylog'),$field,$map,'id','DESC',$xtime); $this->display();*/ import("ORG.Util.Page"); $count = M('member_payonline w')->where($map)->count('w.id'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; $listType = C('PAYLOG_TYPE'); $listType[-1] = "不限制"; $this->assign('type_list', $listType); $field = 'w.id,w.uid,w.status,w.money,w.add_time,w.tran_id,w.way,w.off_bank,w.off_way,w.deal_user,m.user_name,mi.real_name'; $list = M('member_payonline w')->field($field)->join("lzh_members m ON w.uid=m.id")->join("lzh_member_info mi ON w.uid=mi.uid")->where($map)->order(' w.id DESC ')->limit($Lsql)->select(); $list = $this->_listFilter($list); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("search", $search); $this->display(); }
public function lottery() { //分页处理 import("ORG.Util.Page"); $count = M('market_jifenlist')->count('id'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; $list = M('market_jifenlist')->limit($Lsql)->select(); foreach ($list as $key => $v) { if ($v['category'] == '1') { $list[$key]['category'] = '礼金'; } elseif ($v['category'] == '2') { $list[$key]['category'] = '积分'; } elseif ($v['category'] == '3') { $list[$key]['category'] = '奖品'; } if ($v['is_sys'] == '1') { $list[$key]['is_sys'] = '正在抽奖'; } else { $list[$key]['is_sys'] = '已下架'; } } $this->assign("list", $list); $this->assign("pagebar", $page); $this->display(); }
public function msg() { if ($this->isAjax()) { $id = $this->_get('id'); $msg = M('inner_msg')->field('msg')->where('id=' . $id . ' and uid=' . $this->uid)->find(); if (count($msg)) { M('inner_msg')->where('id=' . $id)->save(array('status' => 1)); echo $msg['msg']; } else { echo '<font color=\'red\'>读取错误</font>'; } } else { $map['uid'] = $this->uid; //分页处理 import("ORG.Util.Page"); $count = M('inner_msg')->where($map)->count('id'); $p = new \Org\Util\Page($count, 15); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $list = M('inner_msg')->where($map)->order('status asc,id DESC')->limit($Lsql)->select(); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("count", $count); $this->display(); } }
public function investRecord($borrow_id = 0) { isset($_GET['borrow_id']) && ($borrow_id = intval($_GET['borrow_id'])); $Page = D('Page'); import("ORG.Util.Page"); $count = M("borrow_investor")->where('borrow_id=' . $borrow_id)->count('id'); $Page = new \Org\Util\Page($count, 10); $show = $Page->ajax_show(); $this->assign('page', $show); if ($_GET['borrow_id']) { $list = M("borrow_investor as b")->join(C(DB_PREFIX) . "members as m on b.investor_uid = m.id")->join(C(DB_PREFIX) . "borrow_info as i on b.borrow_id = i.id")->field('i.borrow_interest_rate, i.repayment_type, b.investor_capital, b.add_time, b.is_auto, m.user_name')->where('b.borrow_id=' . $borrow_id)->order('b.id')->limit($Page->firstRow . ',' . $Page->listRows)->select(); /*foreach($list as $k=>$v){ $relult=$k%2; if(!$relult){ $string .= "<tr style='background-color: rgb(255, 255, 255);' class='borrowlist3'> <td width='148' class='txtC'>".hidecard($v['user_name'],5)."</td> <td width='148' class='txtC'>"; }else{ $string .= "<tr style='background-color: rgb(236, 249, 255);' class='borrowlist5'> <td width='148' class='txtC'>".hidecard($v['user_name'],5)."</td> <td width='148' class='txtC'>"; } $string .= $v['is_auto']?'自动':'手动'; $string .= "</td> <td width='128' class='txtRight pr30'>".Fmoney($v['investor_capital'])."元</td> <td width='198' class='txtC'>".date("Y-m-d H:i",$v['add_time'])."</td> <td></td></tr>"; }*/ foreach ($list as $k => $v) { echo '<div class="c_jilu">'; echo '<div class="c_tbjl01">' . hidecard($v['user_name'], 4) . '</div>'; echo '<div class="c_tbjl02">' . $v['borrow_interest_rate'] . '%</div>'; echo '<div class="c_tbjl03">' . Fmoney($v['investor_capital']) . '</div>'; echo '<div class="c_tbjl04">' . date("Y-m-d", $v['add_time']) . ' <span>' . date("H:i", $v['add_time']) . '</span></div>'; echo '<div class="c_tbjl05">'; echo $v['is_auto'] ? '自动' : '手动'; echo '</div>'; echo '<div class="c_tbjl06"><img src="/Style/H/images/images/wancheng2.png" width="21" height="21" /></div>'; echo '<div class="clear"></div>'; echo '</div>'; } } }
public function finanzData() { $per = C('DB_PREFIX'); $site = intval($_GET['site']); switch ($site) { case 2: $map = ' d.repayment_time=0 AND d.deadline<' . time() . ' AND d.status in(3,5,7) '; $field = "sum(d.capital)+sum(d.interest) as capital_all,d.borrow_uid,m.user_name,d.borrow_id,b.borrow_name,sum(d.interest) as interest,d.repayment_time,d.deadline"; //分页处理 import("ORG.Util.Page"); $xcount = M('investor_detail d')->field("d.id")->where($map)->group('d.sort_order,d.borrow_id')->buildSql(); $newxsql = M()->query("select count(*) as tc from {$xcount} as t"); $count = $newxsql[0]['tc']; $p = new \Org\Util\Page($count, 10); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $lately = M('investor_detail d')->field($field)->join("{$per}members m ON m.id=d.borrow_uid")->join("{$per}borrow_info b ON b.id=d.borrow_id")->where($map)->group('d.sort_order,d.borrow_id')->order("d.deadline asc")->limit($Lsql)->select(); $this->assign("page", $page); $this->assign("tendlately", $lately); $data['html'] = $this->fetch('finanz_res1'); exit(json_encode($data)); break; case 3: $map = ' b.status in(4,5) AND b.investor_uid <> 1'; // $field = " b.investor_uid,sum((b.deadline-b.add_time)*investor_capital/3600/24/30) as money_all,b.investor_uid,m.user_name "; $field = " b.investor_uid,sum(investor_capital) as money_all,b.investor_uid,m.user_name "; //分页处理 import("ORG.Util.Page"); $xcount = M('borrow_investor b')->field("b.investor_uid")->where($map)->group('b.investor_uid')->buildSql(); $newxsql = M()->query("select count(*) as tc from {$xcount} as t"); $count = $newxsql[0]['tc']; $p = new \Org\Util\Page($count, 10); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $lately = M('borrow_investor b')->field($field)->join("{$per}members m ON m.id=b.investor_uid")->where($map)->group('b.investor_uid')->order("money_all desc")->limit($Lsql)->select(); foreach ($lately as $k => $v) { $lately[$k]['money_all'] = Fmoney($v['money_all']); } $this->assign("page", $page); $this->assign("tenddata", $lately); $data['html'] = $this->fetch('finanz_res2'); exit(json_encode($data)); break; case 4: $map = ' b.status in(4,5) AND b.borrow_uid <> 1'; // $field = " b.borrow_uid,sum((b.deadline-b.add_time)*investor_capital/3600/24/30) as money_all,b.borrow_uid,m.user_name "; $field = " b.borrow_uid,sum(investor_capital) as money_all,b.borrow_uid,m.user_name "; //分页处理 import("ORG.Util.Page"); $xcount = M('borrow_investor b')->field("b.investor_uid")->where($map)->group('b.investor_uid')->buildSql(); $newxsql = M()->query("select count(*) as tc from {$xcount} as t"); $count = $newxsql[0]['tc']; $p = new \Org\Util\Page($count, 10); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $lately = M('borrow_investor b')->field($field)->join("{$per}members m ON m.id=b.borrow_uid")->where($map)->group('b.borrow_uid')->order("money_all desc")->limit($Lsql)->select(); foreach ($lately as $k => $v) { $lately[$k]['money_all'] = Fmoney($v['money_all']); } $this->assign("page", $page); $this->assign("tenddata", $lately); $data['html'] = $this->fetch('finanz_res2'); exit(json_encode($data)); break; case 1: default: $time = strtotime(date("Y-m-d")); $map = ' d.deadline> ' . $time . ' AND d.deadline< ' . ($time + 3600 * 24 * 7) . ' AND d.status in(1,2,7) '; $field = "sum(d.capital)+sum(d.interest) as capital_all,d.borrow_uid,m.user_name,d.borrow_id,b.borrow_name,sum(d.interest) as interest,d.repayment_time,d.deadline"; //分页处理 import("ORG.Util.Page"); $xcount = M('investor_detail d')->field("d.id")->where($map)->group('d.sort_order,d.borrow_id')->buildSql(); $newxsql = M()->query("select count(*) as tc from {$xcount} as t"); $count = $newxsql[0]['tc']; $p = new \Org\Util\Page($count, 10); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $lately = M('investor_detail d')->field($field)->join("{$per}members m ON m.id=d.borrow_uid")->join("{$per}borrow_info b ON b.id=d.borrow_id")->where($map)->group('d.sort_order,d.borrow_id')->order("d.deadline asc")->limit($Lsql)->select(); $this->assign("page", $page); $this->assign("tendlately", $lately); $data['html'] = $this->fetch('finanz_res1'); exit(json_encode($data)); break; } $data['html'] = "无相关记录"; exit(json_encode($data)); }
public function tel() { import('ORG.Util.Page'); $Qq = M('qq'); $page_size = $page_size == 0 ? C('ADMIN_PAGE_SIZE') : $page_size; if (empty($search)) { $condition = "1"; } else { $condition = $search; } $count = $Qq->where($condition)->count(); $Page = new \Org\Util\Page($count, $page_size); $show = $Page->show(); $fields = $fields == "" ? "*" : $fields; $order = $order == "" ? 'qq_order DESC' : $order; $list = $Qq->field($fields)->where("{$condition} and type = 2")->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $QqList = $list; foreach ($QqList as $key => $v) { foreach ($v as $key_s => $v_s) { if ($key_s == 'is_show') { if ($v_s == 1) { $v_s = "是"; } else { $v_s = "否"; } } $QqList[$key][$key_s] = $v_s; } } $this->assign('qq_list', $QqList); $this->assign('pagebar', $show); $this->assign('position', "客服电话"); $this->display(); }
public function repayment() { $map['b.is_show'] = 0; $map['b.borrow_status'] = 2; $map['b.is_jijin'] = 1; //分页处理 import("ORG.Util.Page"); $count = M('transfer_borrow_info b')->join("{$this->pre}members m ON m.id=b.borrow_uid")->where($map)->count('b.id'); $p = new \Org\Util\Page($count, C('ADMIN_PAGE_SIZE')); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 $field = 'b.id,b.borrow_name,b.borrow_uid,b.borrow_duration,b.borrow_money,b.borrow_fee,b.borrow_interest_rate,b.repayment_type,b.transfer_out,b.transfer_total,b.add_time,m.user_name,b.level_can,b.borrow_max,progress,b.is_tuijian'; $list = M('transfer_borrow_info b')->field($field)->join("{$this->pre}members m ON m.id=b.borrow_uid")->where($map)->limit($Lsql)->order("b.id DESC")->select(); $list = $this->_listFilter($list); $this->assign("list", $list); $this->assign("pagebar", $page); $this->assign("xaction", ACTION_NAME); $this->display(); }