/** * * The implementation method for update 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 updateResponse($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_response " . "SET response = ?, datetime_response= ?, \r\n level= ?, parent_response= ?, fk_id_consultation= ?, fk_id_query_area= ?, \r\n fk_id_educational_role= ?, resp_fk_id_deputy_director= ?, \r\n resp_fk_id_psychologist= ?, resp_fk_id_headmaster= ?, \r\n resp_fk_id_board_directors= ?, resp_fk_id_student= ?, \r\n resp_fk_id_holder= ?, resp_fk_id_teacher= ?, state_satisfaction= ?, " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_response = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateLevelMainCourse($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_level_main_course " . "SET level_description = ? , \r\n order_hierarchy = ? , \r\n level_state = ? , \r\n status_level_main_course = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_level_main_course = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateAttendanceClass($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_attendance_class " . "SET observation = ?,\r\n fk_id_attendance_status = ?,\r\n fk_id_planification_activity = ?, \r\n fk_id_assign_student_course_hd = ?,\r\n fk_id_hcourse_matter_teacher= ?, " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_attendance_class = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * * The implementation method for update 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 updatePlanificationActivity($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_planification_activity " . "SET activity=?,\r\n activity_start_datetime=?,\r\n activity_end_datetime=?,\r\n activity_description=?,\r\n fk_id_type_planification_activity=?,\r\n fk_id_hcourse_matter_teacher=?, " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_planification_activity = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updatePerson($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_person " . "SET name = ? , " . "last_name = ? , " . "maternal_name = ? , " . "married_name = ? , " . "fk_id_gender = ? , " . "fk_id_marital_status = ? , " . "blood_type = ? , " . "birthday = ? , " . "birth_city = ? , " . "country_birth = ? , " . "locality_birth = ? , " . "foto = ? , " . "ext_file_foto = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_person = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateTypeStructureNotes($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_teacher " . "SET teacher_status = ? ,\r\n fk_id_person = ? ,\r\n data_1 = ? ,\r\n data_2 = ? ,\r\n data_3 = ? ,\r\n data_4 = ? ,\r\n data_5 = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "' " . "WHERE pk_id_teacher = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for delete 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 deleteAssignPersonDirection($data, $idTransaction) { $this->setAditionalDataDelete($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_assign_person_contact " . "SET registration_status = 'I', " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_person_direction = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0013: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateStudentTaskFile($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_student_task_file " . "SET description_file_contents = ? , " . " fk_id_student_task = ? , " . " fk_id_file = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "' " . " last_user_transaction = " . $this->lastUserTransaction . ", " . " last_transaction = " . $this->lastTransaction . " " . " WHERE pk_id_student_task_file = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateKindBrother($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_kind_brother " . " SET names = ? , " . " birthday = ? , " . " school = ? , " . " university = ? , " . " work = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE fk_id_membership_app_form = ? " . " and type_kind_brother = ? \r\n and pk_id_kind_brother = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateApplicationParents($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_application_parents " . "SET names = ? , " . "last_name = ? , " . "maternal_name = ? , " . "identify_document = ? , " . "type_identify_document = ? , " . "city_expedition = ? , " . "country_expedition = ? , " . "bithday = ? , " . "profession = ? , " . "grade_education = ? , " . "occupation = ? , " . "works = ? , " . "home_address = ? , " . "phone_address_address = ? , " . "work_address = ? , " . "phone_address_job = ? , " . "email = ? , " . " cell_phone = ? , " . " marital_status = ? , " . " is_an_alumnus = ? , " . " year_is_an_alumnus = ? , " . " religious_association = ? , " . " which_religious_association = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . " last_transaction = " . $this->lastTransaction . " " . " WHERE fk_id_membership_app_form = ? " . " and type_application_parents = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateMainCourse($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_main_course " . "SET name = ? ,\r\n course_code = ? ,\r\n description= ? ,\r\n is_abstract_course= ? ,\r\n is_course_configuration = ?,\r\n status_main_course = ?,\r\n data_1= ? ,\r\n data_2= ? ,\r\n data_3= ? ,\r\n data_4= ? ,\r\n data_5= ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . " last_transaction = " . $this->lastTransaction . " " . " WHERE pk_id_main_course = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateSupervisorAdmissionArea($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_supervisor_admission_area " . "SET fk_id_admission_area = ? , " . " fk_id_person = ? , " . " datetime_assign = CURRENT_TIMESTAMP, " . " status_supervisor_admission_area = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_supervisor_admission_area = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateAdmissionProcess($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_admission_process " . "SET fk_id_membership_app_form = ? , " . " fk_id_admission_area = ? , " . " fk_id_supervisor_admission_area = ? , " . " start_datetime_area_process = ? , " . " end_datetime_area_process = ? , " . " observation_status = ? , " . " status_admission_process = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_admission_process = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateAssignStudentCourseHard($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_assign_student_course_hard " . "SET datetime_assign = ? ,\r\n fk_id_course_hard = ? ,\r\n fk_id_student = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_assign_student_course_hd = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateUser($dataUser, $dataRol) { $resultUser = null; $resultRolUser = null; $queryUser = null; $queryRolUser = null; try { $queryUser = "******" . "SET usuario = ? , llave = ?, fk_id_empleado = ?, " . " transaccion_modificacion = ? , fecha_tran = sysdate, usuario_tran = ? " . "WHERE pk_id_usuario = ? "; $queryRolUser = "******" . "SET fk_id_usuario = ? , fk_id_rol = ?, " . " transaccion_modificacion = ?, fecha_tran = sysdate, usuario_tran = ? " . "WHERE pk_id_usuario_rol = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $resultUser = DataBase::getExecuteDML($queryUser, $dataUser, $this->instanceDataBase); $resultRolUser = DataBase::getExecuteDML($queryRolUser, $dataRol, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0074: ' . $e->getMessage(); } return $resultRolUser; }
/** * The implementation method for update 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 updateNote($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_student " . "SET student_code = ? , " . " student_status = ? , " . " fk_id_person = ? , " . " data_1 = ? , " . " data_2 = ? , " . " data_3 = ? , " . " data_4 = ? , " . " data_5 = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "' " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_student = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateSchooling($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_schooling " . "SET previous_school = ? , " . " place = ? , " . " grades_reached = ? , " . " year = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE fk_id_membership_app_form = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
/** * The implementation method for update 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 updateKinship($data, $idTransaction) { $this->setAditionalDataUpdate($idTransaction); $result = null; $query = null; try { $query = "UPDATE mac_kinship " . "SET kinship = ? , " . " datetime_last_transaction = '" . $this->datetimeLastTransaction . "', " . " last_user_transaction = " . $this->lastUserTransaction . ", " . "last_transaction = " . $this->lastTransaction . " " . "WHERE pk_id_kinship = ? "; DataBase::getBeginTransaction($this->instanceDataBase); $result = DataBase::getExecuteDML($query, $data, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0014: ' . $e->getMessage(); } return $result; }
public function deleteUser($dataUser) { $resultUser = null; $resultRolUser = null; $queryUser = null; $queryRolUser = null; try { $queryUser = "******"; DataBase::getBeginTransaction($this->instanceDataBase); $resultUser = DataBase::getExecuteDML($queryUser, $dataUser, $this->instanceDataBase); DataBase::getCommitTransaction($this->instanceDataBase); } catch (PDOException $e) { echo 'Error JF-Model-0074: ' . $e->getMessage(); } return $resultUser; }