Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Quick and dirty example
- switch($nextId % 6) {
- case 0:
- $salesperson = 'SalesA';
- break;
- case 1:
- case 2:
- $salesperson = 'SalesB';
- break;
- case 3:
- $salesperson = 'SalesC';
- break;
- case 4:
- $salesperson = 'SalesD';
- break;
- case 5:
- $salesperson = 'SalesE';
- break;
- }
- teams
- id title ratio
- 1 TeamA 1
- 2 TeamB 2
- 3 TeamC 1
- 4 TeamD 1
- 5 TeamE 1
- enquiries
- id team_id enquiry
- 1 1 something
- 2 2 something else
- 3 2 something
- 4 3 something else
- SELECT e.id AS enquiry_id, e.enquiry, t.title
- FROM enquiries e
- JOIN teams t
- ON t.id=e.team_id
- enquiries
- id enquiry
- 1 something
- 2 something else
- 3 something
- $teams = array();
- $query = "SELECT id, title, ratio FROM teams";
- $sql = $mysqli->query($query);
- while($row = $sql->fetch_assoc()) {
- $teams[] = $row;
- }
- $query = "SELECT * FROM enquiries";
- $sql = $mysqli->query($query);
- $team = 0;
- $i = 0;
- while($row = $sql->fetch_assoc()) {
- if($i >= $teams[$team]['ratio']) {
- $team = $team == count($teams) ? 0 : ($team + 1);
- $i = 0;
- }
- $teams[$team]['enquiries'][] = $row;
- $i++;
- }
- print_r($teams);
Add Comment
Please, Sign In to add comment