示例#1
0
 function buildQuickForm()
 {
     CRM_Utils_System::setTitle('Afternoon SignIn - Extended Care');
     require_once 'SFS/Utils/ExtendedCare.php';
     $term = SFS_Utils_ExtendedCare::getTerm($term);
     $sql = "\n( \nSELECT     c.id as contact_id, c.display_name as display_name, s.name as course_name, v.grade as grade,\n           0 as sout_id, 0 as signout_time, e.location as course_location\nFROM       civicrm_contact c\nINNER JOIN civicrm_value_school_information v ON v.entity_id = c.id\nINNER JOIN civicrm_value_extended_care s ON ( s.entity_id = c.id AND s.has_cancelled = 0 AND s.day_of_week = '{$this->_dayOfWeek}' )\nINNER JOIN sfschool_extended_care_source e ON ( s.session = e.session AND s.name = e.name AND s.term = e.term AND s.day_of_week = e.day_of_week ) \nWHERE      v.subtype = 'Student'\nAND        v.grade_sis >= 1\nAND        e.is_active = 1\nAND        s.term = %3\n)\nUNION\n(\nSELECT     c.id as contact_id, c.display_name as display_name, sout.class as course_name, v.grade as grade,\n           sout.id as sout_id, sout.signout_time as signout_time, e.location as course_location\nFROM       civicrm_contact c\nINNER JOIN civicrm_value_school_information v ON v.entity_id = c.id\nINNER JOIN civicrm_value_extended_care_signout sout ON sout.entity_id = c.id\nINNER JOIN sfschool_extended_care_source e ON ( sout.class = e.name )\nWHERE      v.subtype = 'Student'\nAND        v.grade_sis >= 1\nAND        ( sout.is_morning = 0 OR sout.is_morning IS NULL )\nAND        DATE( sout.signin_time ) = %1\nAND        e.is_active = 1\nAND        e.day_of_week = %2\n)\nUNION\n(\nSELECT     c.id as contact_id, c.display_name as display_name, sout.class as course_name, v.grade as grade,\n           -1 as sout_id, 0 as signout_time, e.location as course_location\nFROM       civicrm_contact c\nINNER JOIN civicrm_value_school_information v ON v.entity_id = c.id\nINNER JOIN civicrm_value_extended_care_signout sout ON sout.entity_id = c.id\nINNER JOIN sfschool_extended_care_source e ON ( sout.class = e.name )\nWHERE      v.subtype = 'Student'\nAND        v.grade_sis >= 1\nAND        ( sout.is_morning = 0 OR sout.is_morning IS NULL )\nAND        DAYNAME( sout.signin_time ) = %2\nAND        DATE_ADD( sout.signin_time, INTERVAL 8 DAY ) > '{$this->_date}'\nAND        e.is_active = 1\nAND        e.day_of_week = %2\nGROUP BY   c.id\nORDER BY   id DESC\n)\nORDER BY contact_id, sout_id DESC, course_name, display_name, signout_time\n";
     $params = array(1 => array($this->_date, 'String'), 2 => array($this->_dayOfWeek, 'String'), 3 => array($term, 'String'));
     $dao = CRM_Core_DAO::executeQuery($sql, $params);
     $someSignedIn = false;
     $studentDetails = array();
     while ($dao->fetch()) {
         if (array_key_exists($dao->contact_id, $studentDetails)) {
             continue;
         }
         $courseName = $dao->sout_class ? $dao->sout_class : $dao->course_name;
         if (empty($courseName)) {
             $courseName = $dao->grade <= 5 ? 'Yard Play' : 'Homework';
         }
         $studentDetails[$dao->contact_id] = array('display_name' => $dao->display_name, 'course_name' => $courseName, 'course_location' => $dao->course_location, 'grade' => $dao->grade, 'contact_id' => $dao->contact_id, 'is_marked' => $dao->sout_id > 0 ? 1 : 0, 'signout_block' => self::signoutBlock($dao->signout_time));
         if ($dao->sout_id > 0) {
             $someSignedIn = true;
         }
     }
     $this->assign('studentDetails', $studentDetails);
     $this->assign('someSignedIn', $someSignedIn);
     require_once 'SFS/Utils/Query.php';
     $students = array('' => '- Select Student -') + SFS_Utils_Query::getStudentsByGrade(true, false, true, '');
     $this->add('select', "student_id", ts('Student'), $students);
     $this->add('select', "student_id_top", ts('Student'), $students);
     $classes = array('' => '- Select Class -') + SFS_Utils_Query::getClasses();
     $this->add('select', "course_name", ts('Course'), $classes);
     $this->add('select', "course_name_top", ts('Course'), $classes);
     $timeSlots = array('' => '- Select Time -', 1 => 'Before 3:30 pm', 2 => '3:30 - 4:30 pm', 3 => '4:30 - 5:15 pm', 4 => '5:15 - 6:00 pm', 5 => 'After  6:00 pm');
     $this->add('select', "signout_time", ts('Signout Time'), $timeSlots);
     $this->add('select', "signout_time_top", ts('Signout Time'), $timeSlots);
 }
示例#2
0
 public function buildQuickForm()
 {
     if ($this->_action & CRM_Core_Action::DELETE) {
         $buttonLabel = ts('Delete');
     } else {
         require_once 'SFS/Utils/Query.php';
         $buttonLabel = ts('Save');
         $students = SFS_Utils_Query::getStudentsByGrade(true, false, true, '');
         $this->add('select', 'entity_id', ts('Student'), array('' => '--select--') + $students, true);
         if ($this->_action & CRM_Core_Action::UPDATE) {
             $this->freeze('entity_id');
         }
         if ($this->_object == 'fee') {
             $sql = "SELECT cf.column_name as column_name, cf.option_group_id as option_group_id\n                         FROM civicrm_custom_field cf\n                         INNER JOIN  civicrm_custom_group cg ON cf.custom_group_id = cg.id\n                         WHERE cg.table_name = %1";
             $params = array(1 => array($this->_tableName, 'String'));
             $dao = CRM_Core_DAO::executeQuery($sql, $params);
             $options = array();
             while ($dao->fetch()) {
                 if ($dao->option_group_id) {
                     $options[$dao->column_name] = CRM_Core_OptionGroup::valuesByID($dao->option_group_id);
                 }
             }
             $this->add('select', 'fee_type', ts('Fee Type'), array('' => '--select--') + $options['fee_type'], true);
             $this->add('select', 'category', ts('Category'), array('' => '--select--') + $options['category'], true);
             $this->add('text', 'description', ts('Description'), null, true);
             $this->addDate('fee_date', ts('Fee Date'), CRM_Core_SelectValues::date('custom', 1, 1));
             $this->add('text', 'total_blocks', ts('Total Blocks'), null, true);
             $this->addRule('total_blocks', ts('Please enter valid Total Blocks'), 'positiveInteger');
         } else {
             $classes = SFS_Utils_Query::getClasses();
             $this->add('text', 'pickup_person_name', ts('Pickup Person:'));
             $this->addDateTime('signin_time', ts('Signin'), CRM_Core_SelectValues::date('custom', 10, 2));
             $this->addDateTime('signout_time', ts('Signout'), CRM_Core_SelectValues::date('custom', 10, 2));
             $this->add('select', 'class', ts('Class'), array('' => '--select--') + $classes, true);
             $this->add('checkbox', 'is_morning', ts('Is morning?'));
             $this->add('checkbox', 'at_school_meeting', ts('At School Meeting?'));
         }
     }
     $this->addButtons(array(array('type' => 'next', 'name' => $buttonLabel, 'spacing' => '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;', 'isDefault' => true), array('type' => 'cancel', 'name' => ts('Cancel'))));
 }