public function member() { $utype = C('XMEMBER_TYPE'); $area = get_Area_list(); $uid = intval($_GET['id']); $vo = M('members m')->field("m.user_email,m.customer_name,m.user_phone,m.id,m.credits,m.is_ban,m.user_type,m.user_name,m.integral,m.active_integral,mi.*,mm.*,mb.*")->join("{$this->pre}member_info mi ON mi.uid=m.id")->join("{$this->pre}member_money mm ON mm.uid=m.id")->join("{$this->pre}member_banks mb ON mb.uid=m.id")->where("m.id={$uid}")->find(); $vo['province'] = $area[$vo['province']]; $vo['city'] = $area[$vo['city']]; $vo['area'] = $area[$vo['area']]; $vo['province_now'] = $area[$vo['province_now']]; $vo['city_now'] = $area[$vo['city_now']]; $vo['area_now'] = $area[$vo['area_now']]; $vo['is_ban'] = $vo['is_ban'] == 0 ? "未冻结" : "<span style='color:red'>已冻结</span>"; $vo['user_type'] = $utype[$vo['user_type']]; //$vo['money_collect'] = M('investor_detail')->where(" investor_uid={$uid} AND status =7 ")->sum("capital+interest-interest_fee"); //$vo['money_need'] = M('investor_detail')->where(" borrow_uid={$uid} AND status in(4,7) ")->sum("capital+interest"); //$vo['money_all'] = $vo['account_money'] + $vo['money_freeze'] + $vo['money_collect'] - $vo['money_need']; $this->assign("capitalinfo", getMemberBorrowScan($uid)); $this->assign("wc", getUserWC($uid)); $this->assign("credit", getCredit($uid)); $this->assign("vo", $vo); $this->assign("user", $vo['user_name']); //*******2013-11-23************* $minfo = getMinfo($uid, true); $this->assign("minfo", $minfo); $this->assign('benefit', get_personal_benefit($uid)); //收益相关 $this->assign('out', get_personal_out($uid)); //支出相关 $this->assign('pcount', get_personal_count($uid)); $this->display(); }
/** +---------------------------------------------------------- * 默认操作 +---------------------------------------------------------- */ public function member() { $utype = C('XMEMBER_TYPE'); $area = get_Area_list(); $uid = intval($_GET['id']); $vo = M('members m')->field("m.user_email,m.customer_name,m.user_phone,m.id,m.credits,m.is_ban,m.user_type,m.user_name,mi.*,mm.*,mb.*,mci.address c_address, mci.tel c_tel")->join("left join {$this->pre}member_info mi ON mi.uid=m.id")->join("left join {$this->pre}member_money mm ON mm.uid=m.id")->join("left join {$this->pre}member_banks mb ON mb.uid=m.id")->join("left join {$this->pre}member_contact_info mci ON mci.uid=m.id")->where("m.id={$uid}")->find(); $vo['province'] = $area[$vo['province']]; $vo['city'] = $area[$vo['city']]; $vo['area'] = $area[$vo['area']]; $vo['province_now'] = $area[$vo['province_now']]; $vo['city_now'] = $area[$vo['city_now']]; $vo['area_now'] = $area[$vo['area_now']]; $vo['is_ban'] = $vo['is_ban'] == 0 ? "未冻结" : "<span style='color:red'>已冻结</span>"; $vo['user_type'] = $utype[$vo['user_type']]; $vo['money_all'] = $vo['account_money'] + $vo['money_freeze'] + $vo['money_collect']; $this->assign("capitalinfo", getMemberBorrowScan($uid)); $this->assign("wc", getUserWC($uid)); $this->assign("vo", $vo); $this->assign("user", $vo['user_name']); $this->display(); }