PermissionBindingController.class.php.bak.2021-08-09 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. <?php
  2. namespace Home\Controller;
  3. use Think\Controller;
  4. class PermissionBindingController extends ComController
  5. {
  6. //权限绑定列表
  7. public function getPermissionBindingList(){
  8. $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");
  9. $res['msg'] = '操作成功';
  10. $res['flag'] = true;
  11. $res['data'] = $openid_data;
  12. echo json_encode($res);
  13. }
  14. public function getphoneList(){
  15. $phone_data = M()->query("select phone from sp_wx_customuser");
  16. $res['msg'] = '操作成功';
  17. $res['flag'] = true;
  18. $res['data'] = $phone_data;
  19. echo json_encode($res);
  20. }
  21. public function setPermissionBinding()
  22. {
  23. $Data = I();
  24. $phone = $Data['phone'];
  25. $name = $Data['name'];
  26. $power = $Data['power'];
  27. $company_code = $Data['company_code'];
  28. if (empty($phone) && empty($name) && empty($power) && empty($company_code)) {
  29. $res['msg'] = '操作失败,缺少重要参数';
  30. $res['flag'] = false;
  31. echo json_encode($res);
  32. exit();
  33. }
  34. $openid_data = M()->query("select * from sp_wx_customuser where phone='" . $phone . "'");
  35. $data['owner_code'] = $company_code;
  36. $data['username'] = $name;
  37. $data['status'] = 0;
  38. $data['types'] = 3;
  39. $data['phone'] = $phone;
  40. $data['time'] = date('Y-m-d H:i:s', time());
  41. $data['data1'] = $openid_data[0]['openid'];
  42. $data['data2'] = "1,2,3,4,5,6,7,8,9,a";
  43. $data['sfsg'] = 0;
  44. $data['statusid'] = $power;
  45. $R = M("owner_phone")->add($data);
  46. if ($R){
  47. $res['msg'] = '操作成功';
  48. $res['flag'] = true;
  49. echo json_encode($res);
  50. }else{
  51. $res['msg'] = '操作失败';
  52. $res['flag'] = false;
  53. echo json_encode($res);
  54. }
  55. }
  56. }