/**
* 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;
}
/**
* The implementation method for insert data to the instance data Base.
*
* @throws None.
*
* @access public
* @static No.
* @see None.
* @since Available from the version 1.0 01-01-2010.
* @deprecated No.
*/
public function insertUser($dataUser, $dataRol)
{
$resultUser = null;
$resultRolUser = null;
$queryUser = null;
$queryRolUser = null;
$query = null;
$resultAux = null;
$aux = null;
try {
$query = "SELECT SEQ_SEG_USUARIO.NEXTVAL AS ID FROM DUAL";
$resultAux = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
$aux = $resultAux[0];
$queryUser = "******" . "(pk_id_usuario, usuario, llave, cnf_base, estado, transaccion_creacion, " . "transaccion_modificacion, fk_id_empleado, fecha_tran, usuario_tran) " . "VALUES (" . $aux['ID'] . ",?, ?, 'NOBASE', 'A', ?, ?, ?, sysdate, ?)";
$resultUser = $aux['ID'];
$query = "SELECT SEQ_SEG_USUARIO_ROL.NEXTVAL AS ID FROM DUAL";
$resultAux = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
$aux = $resultAux[0];
$queryRolUser = "******" . "(pk_id_usuario_rol, fk_id_usuario, fk_id_rol, estado, transaccion_creacion, transaccion_modificacion, fecha_tran, usuario_tran) " . "VALUES (" . $aux['ID'] . " ,?, ?, 'A', ?, ?, sysdate, ?)";
DataBase::getBeginTransaction($this->instanceDataBase);
DataBase::getExecuteDML($queryUser, $dataUser, $this->instanceDataBase);
$resultRolUser = DataBase::getExecuteDML($queryRolUser, array($resultUser, $dataRol["rol"], $dataRol["transaccion"], $dataRol["transaccion"], $dataRol["usuario_tran"]), $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0072: ' . $e->getMessage();
}
return $resultRolUser;
}
/**
* 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 getListDebtShareStudentHolder($idStudent = parent::ALL)
{
$result = null;
$query = null;
try {
$query = " SELECT pk_id_debt_share id ,\r\n fk_id_type_debt_share ,\r\n a.fk_id_student ,\r\n concat(concat(c.name,' '),c.last_name) student_name,\r\n a.fk_id_father ,\r\n concat(concat(d.name,' '),d.last_name) holder_name,\r\n a.concept ,\r\n a.detail ,\r\n a.amount ,\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.last_transaction ,\r\n a.company\r\n from mac_debt_share a, mac_student b, mac_person c, mac_person d, mac_holder e\r\n where a.registration_status = 'A'\r\n and b.fk_id_person=c.pk_id_person\r\n and a.fk_id_father=e.pk_id_holder\r\n and e.fk_id_person=d.pk_id_person\r\n ";
if ($idStudent != parent::ALL) {
$query = $query . " and a.fk_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;
}
/**
* 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 getListHolderStudent($idPerson = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "select e.pk_id_student id,\r\n d.pk_id_assign_holder_student,\r\n c.period,\r\n e.student_code,\r\n concat(concat(concat(p.name,' '),p.last_name),' ') student_name, \r\n g.pk_id_main_course, \r\n g.course_code, \r\n g.name course_name, \r\n g.description,\r\n concat(concat(concat(h.name,' '),h.last_name),' ') holder_name\r\n FROM mac_holder a, \r\n mac_course_hard b,\r\n mac_period c, \r\n mac_assign_holder_student d, \r\n mac_student e,\r\n mac_assign_student_course_hard f, \r\n mac_main_course g,\r\n mac_person p,\r\n mac_person h\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 c.current_period = 39\r\n and a.pk_id_holder = d.fk_id_father\r\n and e.pk_id_student = d.fk_id_student\r\n and b.fk_id_period = c.pk_id_period\r\n and e.pk_id_student = f.fk_id_student\r\n and f.fk_id_course_hard = b.pk_id_course_hard\r\n and b.fk_id_main_course = g.pk_id_main_course\r\n and e.fk_id_person= p.pk_id_person\r\n and a.fk_id_person=h.pk_id_person ";
if ($idPerson != parent::ALL) {
$query = $query . " and a.fk_id_person = ? ";
$result = DataBase::getArrayListQuery($query, array($idPerson), $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 insert data 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 getListActivityByStudentCourseHard($fk_id_course_hard, $type = 'ALL')
{
$result = null;
$query = null;
try {
$query = "select c.fk_id_person,\r\n c.pk_id_teacher,\r\n b.fk_id_course_hard,\r\n b.fk_id_main_course_matter,\r\n a.pk_id_planification_activity,\r\n a.activity,\r\n a.activity_start_datetime,\r\n a.activity_end_datetime,\r\n a.activity_description,\r\n a.fk_id_type_planification_activity,\r\n f.type_planification_activity, \r\n a.fk_id_hcourse_matter_teacher,\r\n e.pk_id_matter,\r\n e.matter,\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.last_transaction,\r\n a.company\r\n from mac_planification_activity a, \r\n mac_assign_hcourse_matter_teacher b,\r\n mac_teacher c,\r\n mac_assign_main_course_matter d,\r\n mac_matter e\t ,\r\n mac_type_planification_activity f \r\n where a.fk_id_hcourse_matter_teacher=b.pk_id_hcourse_matter_teacher\r\n and b.fk_id_teacher=c.pk_id_teacher\r\n and b.fk_id_main_course_matter=d.pk_id_main_course_matter\r\n and d.fk_id_matter=e.pk_id_matter\r\n and f.pk_id_type_planification_activity=a.fk_id_type_planification_activity\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 e.registration_status='A'\r\n and f.registration_status='A' \r\n and b.fk_id_course_hard = ? \r\n ";
if ($type != 'ALL') {
$query = $query . " and a.fk_id_type_planification_activity = ? ";
$result = DataBase::getArrayListQuery($query, array($fk_id_course_hard, $type), $this->instanceDataBase);
} else {
$result = DataBase::getArrayListQuery($query, array($fk_id_course_hard), $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 getListSchoolingForm($idForm)
{
$result = null;
$query = null;
try {
$query = "select pk_id_schooling id, \r\n previous_school, \r\n place,\r\n grades_reached,\r\n year, \r\n registration_status, \r\n DATE_FORMAT(datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \r\n DATE_FORMAT(datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register, \r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company " . "from mac_schooling " . "where registration_status = 'A' \r\n AND fk_id_membership_app_form = ? ";
$result = DataBase::getArrayListQuery($query, array($idForm), $this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0011: ' . $e->getMessage();
}
return $result;
}
public function getListAssignCourseMatterByCourseHard($id)
{
$result = null;
$query = null;
try {
if ($id == 0) {
$query = "select c.pk_id_main_course_matter , mm.pk_id_matter, concat(mm.matter,' - ',a.name_course) matter\r\n from mac_course_hard a, \r\n\t\t\t\t\t\t\t\tmac_relation_main_course b, \r\n\t\t\t\t\t\t\t\tmac_assign_main_course_matter c,\r\n\t\t\t\t\t\t\t\tmac_matter mm\r\n where a.fk_id_main_course = b.main_course\r\n and c.fk_id_main_course = b.main_course_father\r\n and mm.pk_id_matter = c.fk_id_matter; ";
$result = DataBase::getArrayListQuery($query, array(), $this->instanceDataBase);
} else {
$query = "select c.pk_id_main_course_matter , mm.pk_id_matter, mm.matter\r\n from mac_course_hard a, mac_relation_main_course b, mac_assign_main_course_matter c, mac_matter mm\r\n where a.pk_id_course_hard= ? \r\n and a.fk_id_main_course = b.main_course\r\n and c.fk_id_main_course = b.main_course_father\r\n and mm.pk_id_matter = c.fk_id_matter ";
$result = DataBase::getArrayListQuery($query, array($id), $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 getListRelationLevelMainCourse($idRelationLevelMainCourse = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "select pk_id_rel_level_main_course,\r\n datetime_assign,\r\n level,\r\n level_father,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n user_transaction,\r\n transaction,\r\n company " . "from mac_relation_level_main_course " . "where registration_status = 'A' ";
if ($idRelationLevelMainCourse != parent::ALL) {
$query = $query . " AND pk_id_rel_level_main_course = ?";
$result = DataBase::getArrayListQuery($query, array($idRelationLevelMainCourse), $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 getListLevelMainCourse($idLevelMainCourse = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "select pk_id_level_main_course id, \r\n level_description,\r\n (select description from mac_sys_catalog where pk_id_catalog=a.status_level_main_course) status_level_main_course,\t\t \r\n order_hierarchy,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n company \r\n from mac_level_main_course a\r\n where registration_status = 'A' ";
if ($idLevelMainCourse != parent::ALL) {
$query = $query . " AND pk_id_level_main_course = ?";
$result = DataBase::getArrayListQuery($query, array($idLevelMainCourse), $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 getListAdmissionPeriod($idAdmissionPeriod = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "select pk_id_admission_period id,\r\n school_period ,\r\n DATE_FORMAT(start_datetime_admission,'%d/%m/%Y') start_datetime_admission ,\r\n DATE_FORMAT(end_datetime_admission,'%d/%m/%Y') end_datetime_admission ,\r\n registration_status, \r\n DATE_FORMAT(datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \r\n DATE_FORMAT(datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register, \r\n creation_user_transaction, \r\n last_user_transaction, \r\n case when now() between start_datetime_admission and ADDDATE(end_datetime_admission, INTERVAL 1 DAY ) then 1 \r\n else 0 end periodo_vigente,\r\n creation_transaction, \r\n last_transaction, \r\n company " . "from mac_admission_period " . "where registration_status = 'A' ";
if ($idAdmissionPeriod != parent::ALL) {
$query = $query . " AND pk_id_admission_period = ?";
$result = DataBase::getArrayListQuery($query, array($idAdmissionPeriod), $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 getListAssignHolderFamily($idAssignHolderFamily = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "select pk_id_assign_holder_family,\r\n datetime_assign,\r\n fk_id_holder,\r\n fk_id_parents, \r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register,\r\n user_transaction,\r\n transaction,\r\n company " . "from mac_assign_holder_family " . "where registration_status = 'A' ";
if ($idAssignHolderFamily != parent::ALL) {
$query = $query . " AND pk_id_assign_holder_family = ?";
$result = DataBase::getArrayListQuery($query, array($idAssignHolderFamily), $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 getListAdmissionArea($idAdmissionArea = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "select pk_id_admission_area id,\r\n \t admission_area name,\r\n next_admision_area,\r\n base,\r\n registration_status, \r\n sequential,\r\n DATE_FORMAT(datetime_last_transaction,'%d/%m/%Y %H:%i:%s') datetime_last_transaction, \r\n DATE_FORMAT(datetime_creation_register,'%d/%m/%Y %H:%i:%s') datetime_creation_register, \r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, \r\n company " . "from mac_admission_area " . "where registration_status = 'A' ";
if ($idAdmissionArea != parent::ALL) {
$query = $query . " AND pk_id_admission_area = ? order by sequential asc ";
$result = DataBase::getArrayListQuery($query, array($idAdmissionArea), $this->instanceDataBase);
} else {
$query = $query . " order by sequential asc ";
$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 getListNoteMatterRegister($data)
{
$result = null;
$query = null;
try {
$query = "select g.numerical_note, g.text_note, h.column_name, h.columns_order\r\n from mac_period a, \r\n mac_course_hard b, \r\n mac_course_notes_ballot c, \r\n mac_student d, \r\n mac_main_course e, \r\n mac_matter f, \r\n mac_note g, \r\n mac_evaluations_settings h\r\n where a.registration_status='A'\r\n and current_period = 39\r\n and b.fk_id_period = a.pk_id_period\r\n and b.registration_status = 'A'\r\n and c.fk_id_course_hard = b.pk_id_course_hard\r\n and c.registration_status = 'A'\r\n and c.fk_id_student = d.pk_id_student\r\n and d.registration_status = 'A'\r\n and b.fk_id_main_course = e.pk_id_main_course\r\n and e.registration_status = 'A'\r\n and c.pk_id_course_notes_ballot = g.fk_id_course_notes_ballot\r\n and g.registration_status = 'A'\r\n and g.fk_id_matter = f.pk_id_matter\r\n and f.registration_status = 'A'\r\n and g.fk_id_evaluations_settings = h.pk_id_evaluations_settings\r\n and h.registration_status = 'A' ";
$query = $query . " and d.pk_id_student = ? and f.pk_id_matter = ? and h.columns_order=? ";
//and h.fk_id_type_structure_notes=?
$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 getListTypeStructureNotes($id = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "SELECT t.pk_id_type_structure_notes id_type_notes, \r\n\t\t t.type_structure_notes,\r\n\t\t t.status_structure_notes,\r\n\t\t (select description \r\n\t\t from mac_sys_catalog \r\n\t\t where pk_id_catalog=t.status_structure_notes\r\n\t\t\tand catalog='TYPE_STRUCTURE_NOTES') status_structure_notes,\r\n t.fk_id_type_note,\r\n n.type_note \r\n FROM mac_type_structure_notes t, mac_type_note n\r\n where t.fk_id_type_note=n.pk_id_type_note\r\n and t.registration_status='A'\r\n and n.registration_status='A' ";
if ($id != parent::ALL) {
$query = $query . " AND t.pk_id_type_structure_notes = ?";
$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 getListKinship($idKinship = parent::ALL)
{
$result = null;
$query = null;
try {
$query = "select pk_id_kinship id,\r\n kinship name, \r\n registration_status, \r\n datetime_last_transaction, \r\n datetime_creation_register, \r\n creation_user_transaction, \r\n last_user_transaction, \r\n creation_transaction, \r\n last_transaction, company " . "from mac_kinship " . "where registration_status = 'A' ";
if ($idKinship != parent::ALL) {
$query = $query . " AND pk_id_kinship = ?";
$result = DataBase::getArrayListQuery($query, array($idKinship), $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 getMCourseStructureNotesId($data)
{
$result = null;
$query = null;
$item = null;
try {
$query = " select pk_id_mcourse_structure_notes id\r\n from mac_mcourse_structure_notes \r\n where registration_status='A' \r\n and fk_id_main_course= ? \r\n and fk_id_type_structure_notes= ?";
$result = DataBase::getArrayListQuery($query, $data, $this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0011: ' . $e->getMessage();
}
$item = $result[0];
return $item['id'];
}
