/**
* 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 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 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 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 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 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 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 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 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 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 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 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 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 insertTransaction($data)
{
$query = null;
$idTransaction = null;
$idUser = null;
$company = null;
try {
if (isset($_SESSION['authenticated_id_user'])) {
$idUser = $_SESSION['authenticated_id_user'];
} else {
$idUser = 1;
}
if (isset($_SESSION['id_company'])) {
$company = $_SESSION['id_company'];
} else {
$company = 1;
}
$query = "INSERT INTO sec_transaction( " . "business, operation, description_aplication, datetime_last_transaction, user_transaction, company) " . " VALUES ( ?,?,?, CURRENT_TIMESTAMP(), " . $idUser . "," . $company . ")";
DataBase::getBeginTransaction($this->instanceDataBase);
$idTransaction = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0072: ' . $e->getMessage();
}
return $idTransaction;
}
/**
* 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;
}
