PHP DataBase::getCommitTransaction方法代码示例

 /**
  * 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;
 }