gpc = $gpc; $pindex = I('request.page', 1); $psize = 20; $keyword = I('request.keyword'); $this->keyword = $keyword; if (!empty($keyword)) { $condition .= ' and username like '.'"%' . $keyword . '%"'; } $level_id = I('request.level_id',0); if( isset($level_id) && !empty($level_id) ) { if($level_id == 'default') { $level_id = 0; } $condition .= ' and level_id = '.$level_id; } $this->level_id = $level_id; $groupid = I('request.groupid'); $this->groupid = $groupid; //groupid/default if( isset($groupid) && !empty($groupid) && $groupid != 'default' ) { $condition .= ' and groupid = '.$groupid; } $list = M()->query('SELECT * FROM ' .C('DB_PREFIX') . "lionfish_comshop_member \r\n WHERE 1=1 " . $condition . ' order by member_id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); $total = M('lionfish_comshop_member')->where("1=1 ". $condition )->count(); $level_list = M('lionfish_comshop_member_level')->order('level asc')->select(); $keys_level = array(); foreach($level_list as $vv) { $keys_level[$vv['id']] = $vv['levelname']; } $this->level_list = $level_list; $group_list = M('lionfish_comshop_member_group')->order('id asc')->select(); $keys_group = array(); if( !empty($group_list) ) { foreach($group_list as $vv) { $keys_group[$vv['id']] = $vv['groupname']; } } $this->group_list = $group_list; foreach( $list as $key => $val ) { //ims_ lionfish_comshop_order 1 2 4 6 11 $ordercount = M('lionfish_comshop_order')->where( array('order_status_id' => array('in','1,2,4,6,11,14,12,13'),'member_id' => $val['member_id'] ) )->count(); $ordermoney = M('lionfish_comshop_order')->where( array('order_status_id' => array('in','1,2,4,6,11,14,12,13'),'member_id' => $val['member_id']) )->sum('total'); if(empty($val['share_id'] )){ $share_name['username'] = 0 ; }else{ $share_name = M('lionfish_comshop_member')->where( array('member_id' => $val['share_id'] ) )->find(); } // lionfish_community_history $community_history = M('lionfish_community_history')->field('head_id')->where( array('member_id' => $val['member_id'] ) )->order('addtime desc')->find(); if( !empty($community_history) ) { $cur_community_info = M('lionfish_community_head')->where( array('id' => $community_history['head_id'] ) )->find(); $val['cur_communityname'] = $cur_community_info['community_name']; } else{ $val['cur_communityname'] = '无'; } $val['levelname'] = empty($val['level_id']) ? '普通会员':$keys_level[$val['level_id']]; $val['groupname'] = empty($val['groupid']) ? '默认分组':$keys_group[$val['groupid']]; $has_shopinfo = M('lionfish_comshop_member_shopinfo')->where( array('member_id' => $val['member_id']) )->find(); if( !empty($has_shopinfo) ) { $val['has_shopinfo'] = $has_shopinfo; }else{ $val['has_shopinfo'] = array(); } $val['ordercount'] = $ordercount; $val['ordermoney'] = $ordermoney; $val['share_name'] = $share_name['username']; $list[$key] = $val; } $is_get_formdata = D('Home/Front')->get_config_by_name('is_get_formdata'); $this->is_get_formdata = $is_get_formdata; $pager = pagination2($total, $pindex, $psize); $this->pager = $pager; $this->list = $list; $commiss_level = D('Home/Front')->get_config_by_name('commiss_level'); if( empty($commiss_level) ) { $commiss_level = 0; } $this->commiss_level = $commiss_level; $this->display(); } public function shopinfo() { $member_id = I('get.id'); $shop_info = M('lionfish_comshop_member_shopinfo')->where( array('member_id' => $member_id ) )->find(); $level_list = M('lionfish_comshop_member_level')->order('level asc ')->select(); if( !empty($shop_info['imggroup']) ) { $shop_info['imggroup'] = explode(',' , $shop_info['imggroup']); } if( !empty($shop_info['otherimggroup']) ) { $shop_info['otherimggroup'] = explode(',' , $shop_info['otherimggroup']); } $this->shop_info = $shop_info; $this->member_id = $member_id; $list = array( array('id' => 'default', 'level_money'=>'0','discount'=>'100' ,'level'=>0,'levelname' => '普通会员', 'membercount' => $membercount ) ); if( empty($level_list) ) { $level_list = array(); } //$level_list = array_merge($list, $level_list); $this->level_list = $level_list; $this->display(); } public function chose_community() { $_GPC = I('request.'); $member_id = $_GPC['s_member_id']; $head_id = $_GPC['head_id']; D('Seller/community')->in_community_history($member_id, $head_id); //load_model_class('community')->in_community_history($member_id, $head_id); echo json_encode( array('code' => 0) ); die(); } public function lvconfig () { $_GPC = I('request.'); if (IS_POST) { $data = ((is_array($_GPC['data']) ? $_GPC['data'] : array())); D('Seller/Config')->update($data); show_json(1); } $data = D('Seller/Config')->get_all_config(); $this->display(); } public function recharge_flow () { $_GPC = I('request.'); $member_id = $_GPC['id']; $condition = ' and member_id='.$member_id.' and state >0 '; $pindex = max(1, intval($_GPC['page'])); $psize = 20; $list = M()->query('SELECT * FROM ' . C('DB_PREFIX'). "lionfish_comshop_member_charge_flow \r\n WHERE 1 " . $condition . ' order by id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize ); $total_arr = M()->query('SELECT count(id) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_member_charge_flow WHERE 1 ' . $condition ); $total = $total_arr[0]['count']; foreach( $list as $key => $val ) { $val['add_time'] = date('Y-m-d H:i:s',$val['add_time'] ); if($val['state'] == 3 || $val['state'] == 4) { $od_info = M('lionfish_comshop_order')->field('order_num_alias')->where( array('order_id' => $val['trans_id'] ) )->find(); if( !empty($od_info) ) { $val['trans_id'] = $od_info['order_num_alias']; } } $list[$key] = $val; } $pager = pagination2($total, $pindex, $psize); $this->list = $list; $this->pager = $pager; $this->display(); } public function integral_flow () { $_GPC = I('request.'); $member_id = $_GPC['id']; $condition = ' and member_id='.$member_id.' and type >0 '; $pindex = max(1, intval($_GPC['page'])); $psize = 20; $list = M()->query('SELECT * FROM ' . C('DB_PREFIX'). "lionfish_comshop_member_integral_flow WHERE 1 " . $condition . ' order by id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize ); $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX'). 'lionfish_comshop_member_integral_flow WHERE 1 ' . $condition ); $total = $total_arr[0]['count']; foreach( $list as $key => $val ) { $val['add_time'] = date('Y-m-d H:i:s',$val['add_time'] ); if($val['type'] == 'goodsbuy' || $val['type'] == 'refundorder' || $val['type'] == 'orderbuy') { $od_info = M('lionfish_comshop_order')->field('order_num_alias')->where( array('order_id' => $val['order_id'] ) )->find(); if( !empty($od_info) ) { $val['order_id'] = $od_info['order_num_alias']; } } $list[$key] = $val; } $pager = pagination2($total, $pindex, $psize); $this->list = $list; $this->pager = $pager; $this->display(); } public function editshopinfo() { $post_data = I('post.'); $up_data = array(); $up_data['shop_name'] = $post_data['shop_name']; $up_data['shop_mobile'] = $post_data['shop_mobile']; $up_data['state'] = $post_data['state']; M('lionfish_comshop_member_shopinfo')->where( array('member_id' => $post_data['member_id'] ) )->save($up_data); //oscshop_ lionfish_comshop_member_shopinfo if($post_data['state'] == 1) { M('lionfish_comshop_member')->where( array('member_id' =>$post_data['member_id'] ) )->save( array('level_id' => $post_data['level_id'] ) ); } show_json(1, array('url' => $_SERVER['HTTP_REFERER'] )); } //user.changelevel public function changelevel() { $_GPC = I('request.'); $level = $_GPC['level']; $ids_arr = $_GPC['ids']; $toggle = $_GPC['toggle']; $ids = implode(',', $ids_arr); if($toggle == 'group') { M('lionfish_comshop_member')->where( "member_id in ({$ids})" )->save( array('groupid' => $level ) ); }else if($toggle == 'level'){ M('lionfish_comshop_member')->where( "member_id in ({$ids})" )->save( array('level_id' =>$level ) ); } show_json(1, array('url' => $_SERVER['HTTP_REFERER'] )); } public function config() { if (IS_POST) { $data = I('request.data'); D('Seller/Config')->update($data); show_json(1, array('url' => $_SERVER['HTTP_REFERER'])); } $data = D('Seller/Config')->get_all_config(); $this->data = $data; $this->display(); } public function usergroup() { $_GPC = I('request.'); $membercount = M('lionfish_comshop_member')->where( array('groupid' => 0) )->count(); $list = array( array('id' => 'default', 'groupname' => '默认分组', 'membercount' => $membercount ) ); $condition = ' '; $params = array(':uniacid' => $_W['uniacid']); $keyword= ''; if (!(empty($_GPC['keyword']))) { $_GPC['keyword'] = trim($_GPC['keyword']); $condition .= ' and ( groupname like "%'.$_GPC['keyword'].'%")'; $keyword = $_GPC['keyword']; } $alllist = M('lionfish_comshop_member_group')->where( '1'. $condition )->order('id asc')->select(); foreach ($alllist as &$row ) { $membercount_arr = M()->query('select count(*) as count from ' . C('DB_PREFIX') . 'lionfish_comshop_member where groupid='.$row['id'].' '); $row['membercount'] = $membercount_arr[0]['count']; } unset($row); if (empty($_GPC['keyword'])) { $list = array_merge($list, $alllist); } else { $list = $alllist; } $this->keyword = $keyword; $this->list = $list; $this->display(); } public function user() { } public function userjia() { $_GPC = I('request.'); $condition = '1'; $pindex = max(1, intval($_GPC['page'])); $psize = 20; if (!empty($_GPC['keyword'])) { $_GPC['keyword'] = trim($_GPC['keyword']); $condition .= ' and username like "%' . $_GPC['keyword'] . '%"'; } $list = M('lionfish_comshop_jiauser')->where( $condition )->order('id desc ')->limit( (($pindex - 1) * $psize) . ',' . $psize )->select(); $total = M('lionfish_comshop_jiauser')->where($condition)->count(); $pager = pagination2($total, $pindex, $psize); $this->list = $list; $this->pager = $pager; $this->gpc = $_GPC; $this->display(); } public function userlevel() { $_GPC = I('request.'); $membercount = M('lionfish_comshop_member')->where( array('level_id' => 0) )->count(); $list = array( array('id' => 'default', 'level_money'=>'0','discount'=>'100' ,'level'=>0,'levelname' => '普通会员', 'membercount' => $membercount ) ); $condition = ' 1 '; if (!(empty($_GPC['keyword']))) { $_GPC['keyword'] = trim($_GPC['keyword']); $condition .= ' and ( levelname like "%'.$_GPC['keyword'].'%" )'; } $alllist = M('lionfish_comshop_member_level')->where( $condition )->order('id asc')->select(); foreach ($alllist as &$row ) { $row['membercount'] = M('lionfish_comshop_member')->where( "find_in_set(".$row['id'].",level_id)" )->count(); } unset($row); if (empty($_GPC['keyword'])) { if( empty($alllist) ) { $alllist = array(); } $list = array_merge($list, $alllist); } else { $list = $alllist; } $this->gpc = $_GPC; $this->list = $list; $this->display(); } public function adduserlevel() { $_GPC = I('request.'); //ims_ $id = intval($_GPC['id']); $group = M('lionfish_comshop_member_level')->where( array('id' => $id ) )->find(); if (IS_POST) { $data = array('logo' => trim($_GPC['logo']),'discount' => trim($_GPC['discount']),'level_money' => trim($_GPC['level_money']),'levelname' => trim($_GPC['levelname']), 'level' => trim($_GPC['level']), 'is_auto_grade' => $_GPC['is_auto_grade'] ); if (!(empty($id))) { M('lionfish_comshop_member_level')->where(array('id' => $id))->save( $data ); } else { $id = M('lionfish_comshop_member_level')->add( $data ); } show_json(1, array('url' => U('user/userlevel', array('op' => 'display')))); } $this->id = $id; $this->gpc = $_GPC; $this->group = $group; $this->display(); } public function adduserjia() { $_GPC = I('request.'); $id = intval($_GPC['id']); $group = array(); if( $id > 0 ) { $group = M('lionfish_comshop_jiauser')->where( array('id' => $id) )->find(); } if (IS_POST) { $data = array('avatar' => trim($_GPC['avatar']), 'username' => trim($_GPC['username']),'mobile' => trim($_GPC['mobile']) ); if (!(empty($id))) { M('lionfish_comshop_jiauser')->where( array('id' => $id) )->save( $data ); } else { $id = M('lionfish_comshop_jiauser')->add($data); } show_json(1, array('url' => U('user/userjia', array('op' => 'display')))); } $this->group = $group; $this->display(); } //--begin public function zhenquery_commission() { $_GPC = I('request.'); $kwd = trim($_GPC['keyword']); $is_not_hexiao = isset($_GPC['is_not_hexiao']) ? intval($_GPC['is_not_hexiao']):0; $is_ajax = isset($_GPC['is_ajax']) ? intval($_GPC['is_ajax']) : 0; $this->kwd = $kwd; $this->is_not_hexiao = $is_not_hexiao; $this->is_ajax = $is_ajax; $condition = ' and comsiss_flag=1 and comsiss_state=1 '; if (!empty($kwd)) { $condition .= ' AND ( `username` LIKE "%'.$kwd.'%" or `telephone` like "%'.$kwd.'%" )'; } if( $is_not_hexiao == 1 ) { $condition .= " and pickup_id= 0 "; } /** 分页开始 **/ $page = isset($_GPC['page']) ? intval($_GPC['page']) : 1; $page = max(1, $page); $page_size = 10; /** 分页结束 **/ $ds = M()->query('SELECT * FROM ' . C('DB_PREFIX'). 'lionfish_comshop_member WHERE 1 ' . $condition . ' order by member_id asc' .' limit ' . (($page - 1) * $page_size) . ',' . $page_size ); $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_member WHERE 1 ' . $condition ); $total = $total_arr[0]['count']; foreach ($ds as &$value) { $value['nickname'] = htmlspecialchars($value['username'], ENT_QUOTES); $value['id'] = $value['member_id']; if($is_ajax == 1) { $ret_html .= '