/**
* 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 insertTypeStructureNotes($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_teacher`(datetime_assign,\r\n 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,\r\n registration_status,\r\n datetime_last_transaction,\r\n datetime_creation_register, \r\n company) " . " values(?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n ?,\r\n 'A',\r\n '" . $this->datetimeLastTransaction . "',\r\n '" . $this->datetimeCreationRegister . "', \r\n '" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertDebtShare($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_debt_share`(fk_id_type_debt_share ,\r\n fk_id_student ,\r\n fk_id_father ,\r\n concept ,\r\n detail ,\r\n amount,\r\n registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertSeatReservation($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_seat_reservation`\r\n (fk_id_seat_reservation_period, \r\n fk_id_assign_holder_student,\r\n datetime_assign,\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, \r\n company) " . " values(?,\r\n ?,\r\n CURRENT_TIMESTAMP,\r\n 'A', \r\n '" . $this->datetimeLastTransaction . "',\r\n '" . $this->datetimeCreationRegister . "',\r\n '" . $this->creationUserTransaction . "',\r\n '" . $this->lastUserTransaction . "',\r\n '" . $this->creationTransaction . "',\r\n '" . $this->lastTransaction . "',\r\n '" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertSchooling($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_schooling`(previous_school, \r\n place,\r\n grades_reached,\r\n year,\r\n fk_id_membership_app_form, \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, \r\n company) " . " values(?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertStudentTaskFile($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_student_task_file`(description_file_contents,\r\n fk_id_student_task,\r\n fk_id_file, \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, \r\n company) " . " values(?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertPerson($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = 0;
$query = null;
try {
$query = "insert into `mac_person`(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,registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,?,?,?,?,?,?,?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $e->getMessage();
$result = 0;
}
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 insertKindBrother($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_kind_brother`(\r\n fk_id_membership_app_form,\r\n type_kind_brother,\r\n names, \r\n birthday,\r\n school,\r\n university,\r\n work,\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, \r\n company) " . " values(?,?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertAssignHCourseHardMatterTeacher($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_assign_hcourse_matter_teacher`(datetime_assign,\r\n fk_id_teacher, fk_id_main_course_matter, fk_id_course_hard,\r\n registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(now(),?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertAdmissionProcess($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_admission_process`(fk_id_membership_app_form, \r\n fk_id_admission_area,\r\n fk_id_supervisor_admission_area,\r\n start_datetime_area_process,\r\n end_datetime_area_process,\r\n observation_status,\r\n status_admission_process,\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, \r\n company) " . " values(?,?,?,now(),now(),?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertMainCourse($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_main_course`(\r\n 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, \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, \r\n company) " . " values(?,?,?,?,?,?,?,?,?,?,?,'A','" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertAssignPersonIdentifyDoc($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_assign_person_identify_doc`(identify_document,description,date_assign,city_expedition,fk_id_person,fk_id_type_identify_doc,fk_id_country,registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,?,now(),?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 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 insertCourseApplyPeriod($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_course_apply_period`( \r\n datetime_assign ,\r\n fk_id_admission_period ,\r\n fk_id_main_course ,\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, \r\n company) " . " values('" . $this->datetimeCreationRegister . "',?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertPlanificationActivity($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_planification_activity`(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,\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, \r\n company) " . " values(?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertMembershipAppForm($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_membership_app_form`( \r\n form_registration_date ,\r\n a_partner ,\r\n name_student ,\r\n last_name_student ,\r\n maternal_name_student ,\r\n rude ,\r\n identify_doc_student ,\r\n type_identify_doc_student ,\r\n city_expedition_student ,\r\n country_expedition_student ,\r\n gender_student ,\r\n birthday_student ,\r\n blood_type_student ,\r\n lives_with ,\r\n religion ,\r\n previous_school ,\r\n expired_last_year ,\r\n course_that_postulates ,\r\n cause_of_separation ,\r\n years_spent_in_our_school ,\r\n years_away_from_our_school ,\r\n school_choice_motivation_1 ,\r\n school_choice_motivation_2 ,\r\n school_choice_motivation_3 ,\r\n active_partner_names_1 ,\r\n active_partner_phone_1 ,\r\n active_partner_cell_phone_1 ,\r\n active_partner_email_1 ,\r\n active_partner_names_2 ,\r\n active_partner_phone_2 ,\r\n active_partner_cell_phone_2 ,\r\n active_partner_email_2 ,\r\n names_partner ,\r\n last_name_partner ,\r\n maternal_name_partner ,\r\n identify_document ,\r\n type_identify_document_partner ,\r\n city_expedition_partner ,\r\n country_expedition_partner ,\r\n person_school_affairs ,\r\n invoice_name ,\r\n nit ,\r\n disease ,\r\n accidents ,\r\n allergies ,\r\n surgeries ,\r\n vaccines ,\r\n medication ,\r\n alia ,\r\n games_practice ,\r\n hobbies ,\r\n form_filling_contact ,\r\n direction_contact ,\r\n phone_address_contact ,\r\n work_phone_contact ,\r\n cell_phone_contact ,\r\n status_admission ,\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, \r\n company) " . " values(CURRENT_TIMESTAMP,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,36,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertResponse($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = 0;
$query = null;
try {
$query = "insert into `mac_response`(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,\r\n registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,now(),?,?,?,?,?,?,?,?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertApplicationParents($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_application_parents`(fk_id_membership_app_form,\r\n type_application_parents,\r\n names ,\r\n last_name,\r\n maternal_name,\r\n identify_document,\r\n type_identify_document,\r\n city_expedition,\r\n country_expedition,\r\n bithday,\r\n profession,\r\n grade_education,\r\n occupation,\r\n works,\r\n home_address,\r\n phone_address_address,\r\n work_address,\r\n phone_address_job,\r\n email,\r\n cell_phone,\r\n marital_status,\r\n is_an_alumnus,\r\n year_is_an_alumnus,\r\n religious_association,\r\n which_religious_association,\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, \r\n company) " . " values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertNote($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_note`(numerical_note,\r\n text_note,\r\n fk_id_course_notes_ballot,\r\n fk_id_evaluations_settings,\r\n fk_id_matter ,\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, \r\n company) " . " values(?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertConsultations($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_consultations`(subject, consultation, datetime_consultation,\r\n fk_id_hcourse_matter_teacher, fk_id_flow_type_query, \r\n fk_id_educational_role, cons_fk_id_teacher, cons_fk_id_holder, \r\n cons_fk_id_student, fk_id_response_area, satisfy_fk_id_response,\r\n registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,?,now(),?,?,?,?,?,?,?,?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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 insertKinship($data, $idTransaction)
{
$this->setAditionalDataInsert($idTransaction);
$result = null;
$query = null;
try {
$query = "insert into `mac_kinship`(kinship,registration_status,datetime_last_transaction,datetime_creation_register, creation_user_transaction, last_user_transaction, creation_transaction, last_transaction, company) " . " values(?,'A', '" . $this->datetimeLastTransaction . "','" . $this->datetimeCreationRegister . "','" . $this->creationUserTransaction . "','" . $this->lastUserTransaction . "','" . $this->creationTransaction . "','" . $this->lastTransaction . "','" . $this->company . "')";
DataBase::getBeginTransaction($this->instanceDataBase);
$result = DataBase::getExecuteDmlAndGetLastInsertId($query, $data, $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} catch (PDOException $e) {
echo 'Error JF-Model-0012: ' . $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($user, $pass, $fk_id_person, $pk_id_user, $fk_id_roles)
{
$result = false;
try {
$result1 = true;
$result2 = true;
$result3 = true;
$result4 = true;
if ($pass != '' && $pass != null) {
$queryUser = "******";
DataBase::getBeginTransaction($this->instanceDataBase);
$result1 = DataBase::getExecuteDML($queryUser, array($user, $pass, $fk_id_person, $pk_id_user), $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
} else {
$queryUser = "******";
DataBase::getBeginTransaction($this->instanceDataBase);
$result2 = DataBase::getExecuteDML($queryUser, array($user, $fk_id_person, $pk_id_user), $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
}
$queryUser = "******";
DataBase::getBeginTransaction($this->instanceDataBase);
$result3 = DataBase::getExecuteDML($queryUser, array($pk_id_user), $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
foreach ($fk_id_roles as $fk_id_role) {
$queryRolUser = "******";
DataBase::getBeginTransaction($this->instanceDataBase);
$result4 = DataBase::getExecuteDmlAndGetLastInsertId($queryRolUser, array($pk_id_user, $fk_id_role, 'A'), $this->instanceDataBase);
DataBase::getCommitTransaction($this->instanceDataBase);
}
$result = $result1 && $result2 && $result3 && $result4;
} catch (PDOException $e) {
echo 'Error JF-Model-0074: ' . $e->getMessage();
}
return $result;
}
