request->param('user_id')) $where = "user_id = '{$this->request->param('user_id')}'"; $list = M('users')->where($where)->select(); $this->assign('list',$list); return $this->fetch(); } /** * 分销商列表 */ public function distributor_list(){ $condition['is_distribut'] = 1; $nickname = I('nickname'); if(!empty($nickname)){ $condition['nickname'] = array('like',"%$nickname%"); } $count = M('users')->where($condition)->count(); $Page = new Page($count,10); $show = $Page->show(); $user_list = M('users')->where($condition)->order('distribut_money DESC')->limit($Page->firstRow.','.$Page->listRows)->select(); foreach ($user_list as $k=>$val){ $user_list[$k]['fisrt_leader'] = M('users')->where(array('first_leader'=>$val['user_id']))->count(); $user_list[$k]['second_leader'] = M('users')->where(array('second_leader'=>$val['user_id']))->count(); $user_list[$k]['third_leader'] = M('users')->where(array('third_leader'=>$val['user_id']))->count(); $user_list[$k]['lower_sum'] = $user_list[$k]['fisrt_leader'] +$user_list[$k]['second_leader'] + $user_list[$k]['third_leader']; } $this->assign('page',$show); $this->assign('pager',$Page); $this->assign('user_list',$user_list); return $this->fetch(); } /** * 分销设置 */ public function set(){ header("Location:".U('Admin/System/index',array('inc_type'=>'distribut'))); exit; } public function goods_list(){ $GoodsLogic = new GoodsLogic(); $brandList = $GoodsLogic->getSortBrands(); $categoryList = $GoodsLogic->getSortCategory(); $this->assign('categoryList',$categoryList); $this->assign('brandList',$brandList); $where = ' commission > 0 '; $cat_id = I('cat_id/d'); $bind = array(); if($cat_id > 0) { $grandson_ids = getCatGrandson($cat_id); $where .= " and cat_id in(". implode(',', $grandson_ids).") "; // 初始化搜索条件 } $key_word = I('key_word') ? trim(I('key_word')) : ''; if($key_word) { $where = "$where and (goods_name like :key_word1 or goods_sn like :key_word2)" ; $bind['key_word1'] = "%$key_word%"; $bind['key_word2'] = "%$key_word%"; } $brand_id = I('brand_id'); if($brand_id){ $where = "$where and brand_id = :brand_id"; $bind['brand_id'] = $brand_id; } $model = M('Goods'); $count = $model->where($where)->bind($bind)->count(); $Page = new Page($count,10); $show = $Page->show(); $goodsList = $model->where($where)->bind($bind)->order('sales_sum desc')->limit($Page->firstRow.','.$Page->listRows)->select(); $catList = D('goods_category')->select(); $catList = convert_arr_key($catList, 'id'); $this->assign('catList',$catList); $this->assign('pager',$Page); $this->assign('goodsList',$goodsList); $this->assign('page',$show); return $this->fetch(); } /** * 分成记录 */ public function rebate_log() { $model = M("rebate_log"); $status = I('status'); $user_id = I('user_id'); $order_sn = I('order_sn'); $create_time = I('create_time'); $create_time = $create_time ? $create_time : date('Y-m-d',strtotime('-1 year')).' - '.date('Y-m-d',strtotime('+1 day')); $create_time2 = explode(' - ',$create_time); $where = " create_time >= '".strtotime($create_time2[0])."' and create_time <= '".strtotime($create_time2[1])."' "; if($status === '0' || $status > 0) $where .= " and status = $status "; $user_id && $where .= " and user_id = $user_id "; $order_sn && $where .= " and order_sn like '%{$order_sn}%' "; $count = $model->where($where)->count(); $Page = new Page($count,16); $list = $model->where($where)->order("`id` desc")->limit($Page->firstRow.','.$Page->listRows)->select(); $this->assign('create_time',$create_time); $show = $Page->show(); $this->assign('show',$show); $this->assign('list',$list); C('TOKEN_ON',false); return $this->fetch(); } /** * 获取某个人下级元素 */ public function ajax_lower() { $id = $this->request->param('id'); $list = M('users')->where("first_leader =".$id)->select(); $this->assign('list',$list); return $this->fetch(); } /** * 修改编辑 分成 */ public function editRebate(){ $id = I('id'); $rebate_log = DB::name('rebate_log')->where('id',$id)->find(); if (IS_POST) { $data = I('post.'); // 如果是确定分成 将金额打入分佣用户余额 if ($data['status'] == 3 && $rebate_log['status'] != 3) { accountLog($data['user_id'], $rebate_log['money'], 0, "订单:{$rebate_log['order_sn']}分佣", $rebate_log['money']); } DB::name('rebate_log')->update($data); $this->success("操作成功!!!", U('Admin/Distribut/rebate_log')); exit; } $user = M('users')->where("user_id = {$rebate_log[user_id]}")->find(); if($user['nickname']) $rebate_log['user_name'] = $user['nickname']; elseif($user['email']) $rebate_log['user_name'] = $user['email']; elseif($user['mobile']) $rebate_log['user_name'] = $user['mobile']; $this->assign('user',$user); $this->assign('rebate_log',$rebate_log); return $this->fetch(); } }