Advertisement
Guest User

Untitled

a guest
Sep 19th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. case 'readHomeCustomers':
  2. $id = $_GET['id'];
  3.  
  4.  
  5. $readHome = $db->select('SELECT * FROM home WHERE client_id = '.$id.'');
  6.  
  7. if($readHome){
  8. $arrHome = array();
  9. $arrToPlace = array();
  10. $arrNamePlace = array();
  11.  
  12. foreach ($readHome as $user):
  13.  
  14. $arrHome[] = $user;
  15. $idPlace = $user['id'];
  16. $readToPlace = $db->select('SELECT * FROM item_clianing_to_place WHERE home_id = '.$idPlace.'');
  17.  
  18. foreach($readToPlace as $toPlace){
  19.  
  20. $arrToPlace[] = $toPlace;
  21. $idName = $toPlace['item_cleaning_id'];
  22. $readNamePlace = $db->select('SELECT * FROM item_clianing WHERE id = '.$idName.'');
  23.  
  24. foreach($readNamePlace as $namePlace){
  25.  
  26. $group = $namePlace['name'];
  27. $groupHome = $user['nome'];
  28. $groupToplace = $toPlace['id'];
  29.  
  30.  
  31.  
  32.  
  33. $arrNamePlace[$groupHome][$groupToplace][$group][] = $namePlace;
  34. }
  35.  
  36.  
  37. }
  38.  
  39. //$res = array('error' => false,'users' => $arrHome);
  40.  
  41. endforeach;
  42.  
  43. $group = $Home['nome'][0];
  44.  
  45. $arrHome[$group][] = $Home;
  46.  
  47. $res = array('error' => false, 'namePlace' => $arrNamePlace);
  48.  
  49.  
  50. }else{
  51.  
  52. $res = array('error' => true,'message' => 'Não existem users no sistema.');
  53. }
  54.  
  55. echo json_encode($res);
  56.  
  57. break;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement