Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2014
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.56 KB | None | 0 0
  1. <table>
  2. <thead>
  3. <tr>
  4. <th>Week #</th>
  5. <th>Date</th>
  6. <th>Time</th>
  7. <?php foreach($educators as $educator): ?>
  8. <th><?php echo $educator->First_Name.' '.$educator->Last_Name; ?></th>
  9. <?php endforeach; ?>
  10. </tr>
  11. </thead>
  12.  
  13. <tbody>
  14.  
  15. <?php
  16. $i = 0;
  17. foreach($weeks as $key => $week):
  18. $class_date= $class_dates[$key];
  19. $week = $weeks[$key];
  20. $master_schedule = $master_schedules[$key];
  21. $educator_schedule = $educator_schedules[$key];
  22. $educator_availability = $educator_availabilities[$key];
  23. $week_day_id = $i + 1;
  24. ?>
  25. <tr>
  26. <td>Week <?php echo $week_day_id; ?></td>
  27. <td><?php echo $class_date; ?></td>
  28. <td><?php echo $opportunity->First_Preferred_Start_Time.' - '.$opportunity->First_Preferred_End_Time; ?></td>
  29.  
  30. <?php foreach($educators as $educator): ?>
  31. <td>
  32. <?php if($week->Count == 1): echo 'Class Conflict'; endif; ?>
  33. <?php if($master_schedule->Count == 1): echo $master_schedule->Title; endif; ?>
  34. <?php if($educator_schedule->Count == 1): echo $educator_schedule->Title; endif; ?>
  35. <?php if($educator_availability->Count == 1): echo 'Not Scheduled'; endif; ?>
  36. </td>
  37. <?php endforeach; ?>
  38. </tr>
  39. <?php if($i ++ == 7) break; endforeach; ?>
  40. </tbody>
  41. </table>
  42.  
  43. function schedule_opportunity($Opportunity_Id) {
  44. //retrieve opportunity details
  45. $this->data['opportunity'] = $this->ion_auth_model->get_opportunity($Opportunity_Id)->row();
  46. $opportunity = $this->ion_auth_model->get_opportunity($Opportunity_Id)->row();
  47.  
  48. $Curricula_Id = $opportunity->Curricula_Id;
  49. $Preferred_Start_Time = $opportunity->First_Preferred_Start_Time;
  50. $Preferred_End_Time = $opportunity->First_Preferred_End_Time;
  51. $Preferred_Start_Date = $opportunity->First_Preferred_Start_Date;
  52.  
  53. //find available educators
  54. $this->data['educators'] = $this->ion_auth_model->available_educators($Curricula_Id);
  55. $educators = $this->ion_auth_model->available_educators($Curricula_Id);
  56.  
  57. foreach($educators as $educator):
  58. $Educator_Id = $educator->Educator_Id;
  59.  
  60. for($i=0; $i < 8; $i++):
  61. $Date = strtotime("+$i week", strtotime($Preferred_Start_Date));
  62. $Class_Date = date("Y-m-d", $Date);
  63.  
  64. $this->data['class_dates'][] = date("Y-m-d", $Date);
  65. $this->data['weeks'][] = $this->ion_auth_model->week($Educator_Id, $Class_Date, $Preferred_Start_Time, $Preferred_End_Time)->row();
  66. $this->data['master_schedules'][] = $this->ion_auth_model->master_schedule_check($Class_Date, $Preferred_Start_Time, $Preferred_End_Time)->row();
  67. $this->data['educator_schedules'][] = $this->ion_auth_model->educator_schedule_check($Educator_Id, $Class_Date, $Preferred_Start_Time, $Preferred_End_Time)->row();
  68. $this->data['educator_availabilities'][] = $this->ion_auth_model->educator_availability_check($Educator_Id, $Class_Date, $Preferred_Start_Time, $Preferred_End_Time)->row();
  69. endfor;
  70. endforeach;
  71.  
  72. $this->data['main_content'] = 'schedule_opportunity';
  73. $this->load->view('./_blocks/template', $this->data);
  74. }
  75.  
  76. function educator_schedule_check($Educator_Id, $Class_Date, $Preferred_Start_Time, $Preferred_End_Time) {
  77. $Date = "('$Class_Date' BETWEEN Start_Date AND End_Date AND All_Day = 1 AND Educator_Id = '$Educator_Id' OR '$Class_Date' BETWEEN Start_Date AND End_Date AND (Start_Time BETWEEN '$Preferred_Start_Time' AND '$Preferred_End_Time' OR End_Time BETWEEN '$Preferred_Start_Time' AND '$Preferred_End_Time'))";
  78.  
  79. $this->db->select("Count(*) AS Count, Title")->from('Educators_Schedule')->where($Date)->where('Educator_Id', $Educator_Id);
  80. return $this->db->get();
  81. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement