PHP DataBase::getArrayListQuery方法代码示例

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListAssingPersonDirection($idAssignPersonDirection = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select a.pk_id_person_direction, \r\n                             DATE_FORMAT(a.date_assign,'%d/%m/%Y %H:%i:%s') date_assign,  \r\n                             a.fk_id_person, \r\n                             b.pk_id_direction, \r\n                             b.direction, \r\n                             b.fk_id_location,\r\n                             c.pk_id_type_direction, \r\n                             c.type_direction, \r\n                             a.registration_status, \r\n                             DATE_FORMAT(a.datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \r\n                             DATE_FORMAT(a.datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register, \r\n                             a.creation_user_transaction, \r\n                             a.last_user_transaction, \r\n                             a.creation_transaction, \r\n                             a.last_transaction, \r\n                             a.company  \r\n                             from mac_assign_person_direction a, \r\n                             mac_direction b,  \r\n                             mac_type_direction c \r\n                             where a.pk_id_person_direction=b.pk_id_direction \r\n                             and b.fk_id_type_direction=c.pk_id_type_direction\r\n                             and a.registration_status='A' \r\n                             and b.registration_status='A' \r\n                             and c.registration_status='A'";
         if ($idAssignPersonDirection != parent::ALL) {
             $query = $query . " AND a.fk_id_person = ?";
             $result = DataBase::getArrayListQuery($query, array($idAssignPersonDirection), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  * lista de estudiantes inscritos a un hard course por id_course_hard
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListByCourseHard($idCourseHard = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = " SELECT a.pk_id_assign_student_course_hd, \r\n                        a.fk_id_course_hard, \r\n                        (select name_course \r\n\t\t\t   from mac_course_hard \r\n\t\t\t  where pk_id_course_hard=a.fk_id_course_hard) name_course,\r\n                        a.fk_id_student,                 \r\n\t\t\tconcat(concat(concat(concat(c.name,' '),c.last_name),' '),c.maternal_name) name_student                       \r\n                        FROM mac_assign_student_course_hard a, \r\n                            mac_student b,\r\n                            mac_person c\r\n                        where a.registration_status = 'A' \r\n                        and b.registration_status='A'\r\n                        and c.registration_status='A'\r\n                        and a.fk_id_student=b.pk_id_student\r\n                        and b.fk_id_person=c.pk_id_person\r\n                         and a.fk_id_course_hard = ?";
         $result = DataBase::getArrayListQuery($query, array($idCourseHard), $this->instanceDataBase);
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListStudentTaskFile($id = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select a.pk_id_student id ,\r\n                                 b.name,\r\n                                 b.last_name,\r\n                                 b.maternal_name,\r\n                                  a.student_code,\r\n                                  a.datetime_assign,\r\n                                  a.student_status,\r\n                                  (select description \r\n                                     from mac_sys_catalog \r\n                                    where catalog='STUDENT_STATUS' \r\n                                      and pk_id_catalog=a.student_status) estado,\r\n                                  a.fk_id_person,\r\n                                  a.data_1,\r\n                                  a.data_2,\r\n                                  a.data_3,\r\n                                  a.data_4,\r\n                                  a.data_5,\r\n                                  a.registration_status, \r\n                                  DATE_FORMAT(a.datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \r\n                                  DATE_FORMAT(a.datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register,                                 \r\n                                  a.company  \r\n                             from mac_student a, mac_person b\r\n                             where  a.fk_id_person=b.pk_id_person\r\n                             and a.registration_status = 'A'  ";
         if ($idStudent != parent::ALL) {
             $query = $query . " AND pk_id_student = ?";
             $result = DataBase::getArrayListQuery($query, array($idStudent), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 public function reviewAssignStudentFamily($fk_id_family, $fk_id_student)
 {
     $result = null;
     $query = null;
     try {
         $query = " select pk_id_holder_family,\r\n                                datetime_assign,\r\n                                fk_id_family,\r\n                                fk_id_student,                               \r\n                                registration_status,\r\n                                datetime_last_transaction,\r\n                                datetime_creation_register\r\n                        from mac_assign_student_family \r\n                        where registration_status = 'A' ";
         $query = $query . " AND fk_id_family = ?  AND fk_id_student = ?";
         $result = DataBase::getArrayListQuery($query, array($fk_id_family, $fk_id_student), $this->instanceDataBase);
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

$v_route_edit_preview = 'index.php?page=course/level';
// Simplificar el ruteo de insert
$v_route_insert = '?page=course/level';
// Simplificar el ruteo de lista
$v_route_list = 'index.php?page=course/level_admin';
switch ($action) {
    case 'INSERT':
        $transaction = new Transaction($registry[$nameDataBase]);
        Teacher::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Teacher::$business, Teacher::$insert, Teacher::$descriptionBusiness));
        $query = null;
        $dateTimeNowRow = null;
        $dateTimeNow = null;
        try {
            $query = "select DATE_FORMAT(CURRENT_TIMESTAMP(),'%Y-%m-%d %H:%i:%s') datetime";
            $result = DataBase::getArrayListQuery($query, array(), $registry[$nameDataBase]);
            $dateTimeNowRow = $result[0];
            $dateTimeNow = $dateTimeNowRow['datetime'];
        } catch (PDOException $e) {
            echo 'Error JF-Model-0011: ' . $e->getMessage();
        }
        $data = array($dateTimeNow, $_POST['TEACHER_STATUS'], $_POST['pk_id_person'], $_POST['data_1'], $_POST['data_2'], $_POST['data_3'], $_POST['data_4'], $_POST['data_5']);
        //validar que la persona no exista ya registrada como persona
        $resval = $catalog->validateTeacher($_POST['pk_id_person']);
        if ($resval == 0) {
            $statusTransactionDB = $catalog->insertTeacher($data, $idTransaction);
            $msg_err = $v_label["DETAIL_MESSAGE_NOOK_NEW"];
        } else {
            $statusTransactionDB = 0;
            $msg_err = 'El Profesor que Intenta Registrar ya Existe!';
        }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getEvaluationsSettingsId($data)
 {
     $result = null;
     $query = null;
     $item = array();
     try {
         $query = "select pk_id_evaluations_settings id                            \r\n                            from mac_evaluations_settings t\r\n                            where registration_status='A' \r\n                            and fk_id_type_structure_notes = ?\r\n                             and columns_order = ? ";
         $result = DataBase::getArrayListQuery($query, $data, $this->instanceDataBase);
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     $item = $result[0];
     return $item['id'];
 }

 public function getListResponseByConsultation($idConsultation)
 {
     $result = null;
     $query = null;
     try {
         $query = "select pk_id_response, response, datetime_response,fk_id_educational_role,\r\n                        educational_role, fk_id_person, (select concat(name,' ',last_name,' ', maternal_name) from mac_person where pk_id_person = a.fk_id_person) persona\r\n                        from (select b.pk_id_response, b.response, b.datetime_response, b.fk_id_educational_role,\r\n                                (select educational_role from mac_educational_role where pk_id_educational_role = b.fk_id_educational_role ) educational_role,\r\n                                case (select educational_role from mac_educational_role where pk_id_educational_role = b.fk_id_educational_role )\r\n                                when 'TEACHER' then (select fk_id_person from mac_teacher where pk_id_teacher = b.resp_fk_id_teacher )\r\n                                when 'HOLDER' then (select fk_id_person from mac_holder where pk_id_holder = b.resp_fk_id_holder )\r\n                                when 'STUDENT' then (select fk_id_person from mac_student where pk_id_student = b.resp_fk_id_student )\r\n                                when 'BOARD_DIRECTORS' then (select fk_id_person from mac_board_directors where pk_id_board_directors = b.resp_fk_id_board_directors )\r\n                                when 'HEADMASTER' then (select fk_id_person from mac_headmaster where pk_id_headmaster = b.resp_fk_id_headmaster )\r\n                                when 'PSYCHOLOGIST' then (select fk_id_person from mac_psychologist where pk_id_psychologist = b.resp_fk_id_psychologist )\r\n                                when 'DEPUTY_DIRECTOR' then (select fk_id_person from mac_deputy_director where pk_id_deputy_director = b.resp_fk_id_deputy_director )\r\n                                else 0\r\n                                end fk_id_person\r\n                                FROM  mac_consultations a, mac_response b\r\n                                where a.registration_status = 'A'\r\n                                and b.registration_status = 'A'\r\n                                and a.pk_id_consultation = b.fk_id_consultation\r\n                                and a.pk_id_consultation = ?) a";
         $result = DataBase::getArrayListQuery($query, array($idConsultation), $this->instanceDataBase);
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListProfession($idProfession = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "\n                        select pk_id_profession id, \n                                 profession name, \n                                 base, \n                                 registration_status, \n                                 DATE_FORMAT(datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \n                                 DATE_FORMAT(datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register, \n                                 creation_user_transaction, \n                                 last_user_transaction, \n                                 creation_transaction, \n                                 last_transaction, \n                                 company \n                        from mac_profession \n                        where registration_status = 'A' ";
         if ($idProfession != parent::ALL) {
             $query = $query . " AND pk_id_profession = ?";
             $result = DataBase::getArrayListQuery($query, array($idProfession), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListAttendanceStatus($id = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select a.pk_id_attendance_status,\r\n                                    a.attendance_status,\r\n                                    a.state_abbreviation,\r\n                                    a.registration_status,\r\n                                    a.datetime_last_transaction,\r\n                                    a.datetime_creation_register,\r\n                                    a.creation_user_transaction,\r\n                                    a.last_user_transaction,\r\n                                    a.creation_transaction,\r\n                                    a.company\r\n                                    from mac_attendance_status a\r\n                                    where a.registration_status='A' ";
         if ($id != parent::ALL) {
             $query = $query . " and a.pk_id_attendance_status = ?   ";
             $result = DataBase::getArrayListQuery($query, array($id), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListStudentTask($data)
 {
     $result = null;
     $query = null;
     try {
         $query = "select * from \r\n                                    (select a.pk_id_student_task,\r\n                                                     concat(e.name,e.last_name,e.maternal_name) student_name,\r\n                                                     e.pk_id_person,\r\n                                                     d.pk_id_student,\r\n                                                     c.fk_id_course_hard,\r\n                                                     a.response_task,\r\n                                                     a.score_achieved,\r\n                                                     a.delivery_datetime,\r\n                                                     a.fk_id_matter_task,\r\n                                                     a.fk_id_assign_student_course_hd,\r\n                                                     b.title_task,\r\n                                                     b.description_task,\r\n                                                     b.maximum_score,\r\n                                                     b.maximum_delivery_datetime,\r\n                                                     b.fk_id_hcourse_matter_teacher,\r\n                                                     b.fk_id_planification_activity\t\t  \r\n                                    from mac_student_task a, \r\n                                         mac_matter_task b,\r\n                                         mac_assign_student_course_hard c,\r\n                                         mac_student d,\r\n                                         mac_person e\r\n                                    where a.fk_id_matter_task=b.pk_id_matter_task\r\n                                    and a.fk_id_assign_student_course_hd=c.pk_id_assign_student_course_hd\r\n                                    and c.fk_id_student=d.pk_id_student\r\n                                    and d.fk_id_person= e.pk_id_person\r\n                                    and a.registration_status='A'     \r\n                                    and b.registration_status='A'\r\n                                    and c.registration_status='A'\r\n                                    and d.registration_status='A'\r\n                                    and c.fk_id_course_hard= ?\r\n                                    and a.fk_id_matter_task= ? ) ax left outer join (select \r\n                                                                               bb.pk_id_student_task_file,\r\n                                                                                bb.fk_id_student_task,\r\n                                                                                cc.pk_id_file,\r\n                                                                                bb.description_file_contents,\r\n                                                                                cc.title,\r\n                                                                                cc.description,\r\n                                                                                cc.file_name,\r\n                                                                                cc.file_type,\r\n                                                                                cc.file_ext,\r\n                                                                                cc.file_usage_group\r\n                                                                         from \r\n                                                                          mac_student_task_file bb,\r\n                                                                          mac_file cc\r\n                                                                          where bb.registration_status='A'\r\n                                                                                   and cc.registration_status='A'\r\n                                                                                  and cc.pk_id_file = bb.fk_id_file\t\t   \r\n                                                                          ) ft ON  ax.pk_id_student_task=ft.fk_id_student_task\r\n                                     ";
         $result = DataBase::getArrayListQuery($query, $data, $this->instanceDataBase);
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListSeatReservation($id = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select a.pk_id_city id, \r\n                                a.city name,  \r\n                                a.fk_id_country, \r\n                                b.name country, \r\n                                a.base, \r\n                                a.registration_status, \r\n                                DATE_FORMAT(a.datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \r\n                                DATE_FORMAT(a.datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register, \r\n                                a.creation_user_transaction, \r\n                                a.last_user_transaction, \r\n                                a.creation_transaction, \r\n                                a.last_transaction, \r\n                                a.company  " . "from mac_city a, mac_country b " . "where a.fk_id_country = b.pk_id_country AND   a.registration_status = 'A' AND   b.registration_status = 'A' ";
         if ($id != parent::ALL) {
             $query = $query . " AND pk_id_city = ?";
             $result = DataBase::getArrayListQuery($query, array($id), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListSystemCatalog($systemCatalog = parent::ALL, $idSystemCatalog = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select pk_id_catalog, description, catalog, applies_to_table_main, cnf_base, registration_status, datetime_last_transaction, datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company \r\n                          from mac_sys_catalog \r\n                          where registration_status = 'A' ";
         if ($systemCatalog != parent::ALL && $idSystemCatalog != parent::ALL) {
             $query = $query . " AND catalog = ? AND pk_id_catalog = ? ";
             $result = DataBase::getArrayListQuery($query, array($systemCatalog, $idSystemCatalog), $this->instanceDataBase);
         } else {
             if ($systemCatalog != parent::ALL && $idSystemCatalog == parent::ALL) {
                 $query = $query . " AND catalog = ? \r\n                            order by description asc";
                 $result = DataBase::getArrayListQuery($query, array($systemCatalog), $this->instanceDataBase);
             } else {
                 if ($systemCatalog == parent::ALL && $idSystemCatalog != parent::ALL) {
                     $query = $query . " AND pk_id_catalog = ? ";
                     $result = DataBase::getArrayListQuery($query, array($idSystemCatalog), $this->instanceDataBase);
                 } else {
                     $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
                 }
             }
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListMatterTaskByActivity($id = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select * from (\r\n                        select a.pk_id_matter_task,\r\n                            a.title_task,\r\n                            a.description_task,\r\n                            a.maximum_score,\r\n                            a.maximum_delivery_datetime,\r\n                            a.fk_id_hcourse_matter_teacher,\r\n                            a.fk_id_planification_activity,\r\n                            a.registration_status,\r\n                            ft.pk_id_matter_task_file,\r\n                            ft.fk_id_matter_task,\r\n                            ft.pk_id_file,\r\n                            ft.description_file_contents,\r\n                            ft.title  title_file,\r\n                            ft.description description_file,\r\n                            ft.file_name,\r\n                            ft.file_type,\r\n                            ft.file_ext,\r\n                            ft.file_usage_group\r\n                            from mac_matter_task a left outer join (select \r\n                                           b.pk_id_matter_task_file,\r\n                                            b.fk_id_matter_task,\r\n                                            c.pk_id_file,\r\n                                            b.description_file_contents,\r\n                                            c.title,\r\n                                            c.description,\r\n                                            c.file_name,\r\n                                            c.file_type,\r\n                                            c.file_ext,\r\n                                            c.file_usage_group\r\n                                     from \r\n                                      mac_matter_task_file b,\r\n                                      mac_file c\r\n                                      where b.registration_status='A'\r\n                                               and c.registration_status='A'\r\n                                              and c.pk_id_file = b.fk_id_file\t\t   \r\n                                      ) ft ON  a.pk_id_matter_task=ft.fk_id_matter_task ) ds\r\n\t                      where  ds.registration_status='A'";
         if ($id != parent::ALL) {
             $query = $query . " AND ds.fk_id_planification_activity = ?";
             $result = DataBase::getArrayListQuery($query, array($id), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListSeatReservationPeriod($id = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select sp.pk_id_seat_reservation_period,                                \r\n                                DATE_FORMAT(sp.start_datetime_seat_reservation,'%d/%m/%Y %H:%i:%s') start_datetime_seat_reservation, \r\n                                DATE_FORMAT(sp.end_datetime_seat_reservation,'%d/%m/%Y %H:%i:%s') end_datetime_seat_reservation, \r\n                                sp.seat_reservation_period,\r\n                                p.period,\r\n                                sp.registration_status, \r\n                                DATE_FORMAT(sp.datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \r\n                                DATE_FORMAT(sp.datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register, \r\n                                sp.creation_user_transaction, \r\n                                sp.last_user_transaction, \r\n                                sp.creation_transaction, \r\n                                sp.last_transaction, \r\n                                sp.company\r\n                               from mac_period p, \r\n                              mac_seat_reservation_period  sp\r\n                              where p.pk_id_period=sp.seat_reservation_period\r\n                              and p.date_start >= CURRENT_PERIOD\r\n                              AND   p.registration_status = 'A' \r\n                              AND   sp.registration_status = 'A' \r\n                               ";
         if ($id != parent::ALL) {
             $query = $query . "and sp.seat_reservation_period = ?";
             $result = DataBase::getArrayListQuery($query, array($id), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }

 /**
  * The implementation method for query to the instance data Base.
  *
  * @throws None.
  *
  * @access     public
  * @static     No.
  * @see        None.
  * @since      Available from the version  1.0 01-01-2013.
  * @deprecated No.
  */
 public function getListAttendanceClassByActivity($idActivity = parent::ALL)
 {
     $result = null;
     $query = null;
     try {
         $query = "select a.pk_id_attendance_class, \r\n                                g.pk_id_person,\r\n                                concat(concat(concat(concat(g.name,' '),g.last_name),' '),g.maternal_name) name_student,\r\n                                h.pk_id_course_hard,\r\n                                h.name_course,\r\n                                b.fk_id_teacher,\t\t \r\n                                b.fk_id_main_course_matter,\r\n                                a.fk_id_planification_activity,\t\t \r\n                                c.pk_id_assign_student_course_hd,\r\n                                a.fk_id_hcourse_matter_teacher,\r\n                                i.pk_id_attendance_status,\r\n                                a.observation\t\t \r\n                    from mac_attendance_class a, \r\n                              mac_assign_hcourse_matter_teacher b, \r\n                              mac_assign_student_course_hard c,\r\n                              mac_student d, \r\n                              mac_planification_activity e, \r\n                              mac_attendance_status f,\r\n                              mac_person g,\r\n                              mac_course_hard h,\r\n                              mac_attendance_status i\r\n                    where a.registration_status = 'A'\r\n                    and b.registration_status='A'\r\n                    and c.registration_status='A'\r\n                    and d.registration_status='A'\r\n                    and e.registration_status='A'\r\n                    and f.registration_status='A'\r\n                    and g.registration_status='A'\r\n                    and h.registration_status='A'\r\n                    and i.registration_status='A'\r\n                    and a.fk_id_hcourse_matter_teacher = b.pk_id_hcourse_matter_teacher\r\n                    and a.fk_id_assign_student_course_hd = c.pk_id_assign_student_course_hd\r\n                    and a.fk_id_planification_activity = e.pk_id_planification_activity\r\n                    and a.fk_id_attendance_status = f.pk_id_attendance_status\r\n                    and d.fk_id_person=g.pk_id_person\r\n                    and c.fk_id_course_hard=h.pk_id_course_hard\r\n                    and a.fk_id_attendance_status=i.pk_id_attendance_status\r\n                    and c.fk_id_student=d.pk_id_student ";
         //actividad tipo clase
         if ($idActivity != parent::ALL) {
             $query = $query . " and a.fk_id_planification_activity = ?";
             $result = DataBase::getArrayListQuery($query, array($idActivity), $this->instanceDataBase);
         } else {
             $result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
         }
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     return $result;
 }