query("select a.id,a.id,a.username,a.phone,b.owner_name,a.statusid from sp_owner_phone as a join sp_owner_company as b on a.owner_code=b.owner_id ORDER BY a.time desc LIMIT ".$statur.",".$number); // $openid_data = M()->query("select a.id,a.id,a.username,a.phone,b.owner_name,a.statusid from sp_owner_phone as a join sp_owner_company as b on a.owner_code=b.owner_id ORDER BY a.time desc"); $res['msg'] = '操作成功'; $res['flag'] = true; $res['data'] = $openid_data; echo json_encode($res); } public function getphoneList(){ $phone_data = M()->query("select phone from sp_wx_customuser"); $res['msg'] = '操作成功'; $res['flag'] = true; $res['data'] = $phone_data; echo json_encode($res); } public function setPermissionBinding() { $Data = I(); $phone = $Data['phone']; $name = $Data['name']; $power = $Data['power']; $company_code = $Data['company_code']; if (empty($phone) && empty($name) && empty($power) && empty($company_code)) { $res['msg'] = '操作失败,缺少重要参数'; $res['flag'] = false; echo json_encode($res); exit(); } $openid_data = M()->query("select * from sp_wx_customuser where phone='" . $phone . "'"); $data['owner_code'] = $company_code; $data['username'] = $name; $data['status'] = 0; $data['types'] = 3; $data['phone'] = $phone; $data['time'] = date('Y-m-d H:i:s', time()); $data['data1'] = $openid_data[0]['openid']; $data['data2'] = "1,2,3,4,5,6,7,8,9,a"; $data['sfsg'] = 0; $data['statusid'] = $power; $R = M("owner_phone")->add($data); if ($R){ $res['msg'] = '操作成功'; $res['flag'] = true; echo json_encode($res); }else{ $res['msg'] = '操作失败'; $res['flag'] = false; echo json_encode($res); } } }