Beispiel #1
0
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();
 }
Beispiel #11
0
 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();
 }
Beispiel #14
0
 /**
 +----------------------------------------------------------
 * 默认操作
 +----------------------------------------------------------
 */
 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();
 }
Beispiel #15
0
 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));
 }
Beispiel #16
0
 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));
 }
Beispiel #20
0
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']) . '&nbsp;&nbsp;<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));
 }
Beispiel #29
0
 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();
 }