* @package Laravue * @version 1.0 */ namespace App\Http\Controllers; use App\Laravue\Models\WxUser; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; use Illuminate\Http\Resources\Json\ResourceCollection; use Illuminate\Support\Arr; use Illuminate\Support\Facades\Hash; use Validator; class WxuserController extends Controller { //获取wx用户列表 public function wxlist(Request $request){ /* * get请求返回wx用户列表 * */ $limit = $request->input('limit'); $pagenNum = $limit * ($request->input('page')-1);//页数 if($pagenNum === '' || $limit == ''){ return $this->jsonErrorData(105,'页数或limit不能为空'); } $cont = WxUser::count(); $Wxuser = WxUser::select('nickname','id','openid','sex','province','city','mobile','country','headimgurl','created_at','state') ->offset($pagenNum) ->orderBy('id', 'desc') ->limit($limit) ->get(); $data = ['Wxuser'=>$Wxuser,'cont'=>$cont]; if ($Wxuser){ return $this->jsonSuccessData($data); }else{ return $this->jsonErrorData('105','获取数据失败'); } } //用户搜索 public function seek (Request $request){ $keys = $request->all(); foreach ($keys as $key => $val) { if ($key == 'page') { unset($keys[$key]); } elseif ($key == 'limit'){ unset($keys[$key]); } } foreach ($keys as $k => $v) { if($k == 'sex'){ if ($v == '男'){ $v = 1; }else if ($v == '女'){ $v =2; } }else if ($k == 'state'){ if ($v == '正常'){ $v = 2; }else if ($v == '禁用'){ $v = 1; } } $keys[$key] && DB::table('wx_user')->where($k, 'like', '%' . $v . '%'); } $datas = DB::table('wx_user')->get(); $cont = DB::table('wx_user')->count(); $data = ['Wxuser'=>$datas,'cont'=>$cont]; return $this->jsonSuccessData($data); } }