Guest User

Untitled

a guest
Jan 22nd, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. // Quick and dirty example
  2. switch($nextId % 6) {
  3. case 0:
  4. $salesperson = 'SalesA';
  5. break;
  6. case 1:
  7. case 2:
  8. $salesperson = 'SalesB';
  9. break;
  10. case 3:
  11. $salesperson = 'SalesC';
  12. break;
  13. case 4:
  14. $salesperson = 'SalesD';
  15. break;
  16. case 5:
  17. $salesperson = 'SalesE';
  18. break;
  19. }
  20.  
  21. teams
  22.  
  23. id title ratio
  24. 1 TeamA 1
  25. 2 TeamB 2
  26. 3 TeamC 1
  27. 4 TeamD 1
  28. 5 TeamE 1
  29.  
  30. enquiries
  31.  
  32. id team_id enquiry
  33. 1 1 something
  34. 2 2 something else
  35. 3 2 something
  36. 4 3 something else
  37.  
  38. SELECT e.id AS enquiry_id, e.enquiry, t.title
  39. FROM enquiries e
  40. JOIN teams t
  41. ON t.id=e.team_id
  42.  
  43. enquiries
  44.  
  45. id enquiry
  46. 1 something
  47. 2 something else
  48. 3 something
  49.  
  50. $teams = array();
  51.  
  52. $query = "SELECT id, title, ratio FROM teams";
  53. $sql = $mysqli->query($query);
  54. while($row = $sql->fetch_assoc()) {
  55. $teams[] = $row;
  56. }
  57.  
  58. $query = "SELECT * FROM enquiries";
  59. $sql = $mysqli->query($query);
  60.  
  61. $team = 0;
  62. $i = 0;
  63. while($row = $sql->fetch_assoc()) {
  64. if($i >= $teams[$team]['ratio']) {
  65. $team = $team == count($teams) ? 0 : ($team + 1);
  66.  
  67. $i = 0;
  68. }
  69.  
  70. $teams[$team]['enquiries'][] = $row;
  71. $i++;
  72. }
  73.  
  74. print_r($teams);
Add Comment
Please, Sign In to add comment