/**
* bool Query_Theme(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_Theme($dsn = null)
{
$this->_table = "theme_tbl";
$this->_primaryKey = array("id_theme");
$this->_map = array('id_theme' => array('mutator' => 'setId'), 'theme_name' => array('mutator' => 'setName'), 'css_file' => array('mutator' => 'setCssFile'), 'row_count' => array('mutator' => 'setCount'));
return parent::Query($dsn);
}
/**
* bool Query_History(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_History($dsn = null)
{
$this->_table = "history_tbl";
$this->_primaryKey = array("id_patient");
$this->_map = array('id_patient' => array('mutator' => 'setIdPatient'), 'birth_growth' => array('mutator' => 'setBirthGrowth'), 'growth_sexuality' => array('mutator' => 'setGrowthSexuality'), 'feed' => array('mutator' => 'setFeed'), 'habits' => array('mutator' => 'setHabits'), 'peristaltic_conditions' => array('mutator' => 'setPeristalticConditions'), 'psychological' => array('mutator' => 'setPsychological'), 'children_complaint' => array('mutator' => 'setChildrenComplaint'), 'venereal_disease' => array('mutator' => 'setVenerealDisease'), 'accident_surgical_operation' => array('mutator' => 'setAccidentSurgicalOperation'), 'medicinal_intolerance' => array('mutator' => 'setMedicinalIntolerance'), 'mental_illness' => array('mutator' => 'setMentalIllness'), 'parents_status_health' => array('mutator' => 'setParentsStatusHealth'), 'brothers_status_health' => array('mutator' => 'setBrothersStatusHealth'), 'spouse_childs_status_health' => array('mutator' => 'setSpouseChildsStatusHealth'), 'family_illness' => array('mutator' => 'setFamilyIllness'));
return parent::Query($dsn);
}
/**
* bool Query_Staff(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_Staff($dsn = null)
{
$this->_table = "staff_tbl";
$this->_primaryKey = array("id_member");
$this->_map = array('id_member' => array('mutator' => 'setIdMember'), 'member_type' => array('mutator' => 'setMemberType'), 'collegiate_number' => array('mutator' => 'setCollegiateNumber'), 'nif' => array('mutator' => 'setNIF'), 'first_name' => array('mutator' => 'setFirstName'), 'surname1' => array('mutator' => 'setSurname1'), 'surname2' => array('mutator' => 'setSurname2'), 'address' => array('mutator' => 'setAddress'), 'phone_contact' => array('mutator' => 'setPhone'), 'login' => array('mutator' => 'setLogin'), 'id_user' => array('mutator' => 'setIdUser'));
return parent::Query($dsn);
}
/**
* bool Query_Test(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_Test($dsn = null)
{
$this->_table = "medical_test_tbl";
$this->_primaryKey = array("id_test");
$this->_map = array('id_test' => array('mutator' => 'setIdTest'), 'id_problem' => array('mutator' => 'setIdProblem'), 'document_type' => array('mutator' => 'setDocumentType'), 'path_filename' => array('mutator' => 'setPathFilename'));
return parent::Query($dsn);
}
/**
* bool Query_Setting(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
public function Query_Setting($dsn = null)
{
$this->_table = "setting_tbl";
$this->_primaryKey = null;
$this->_map = array('clinic_name' => array('mutator' => 'setClinicName'), 'clinic_hours' => array('mutator' => 'setClinicHours'), 'clinic_address' => array('mutator' => 'setClinicAddress'), 'clinic_phone' => array('mutator' => 'setClinicPhone'), 'clinic_url' => array('mutator' => 'setClinicUrl'), 'session_timeout' => array('mutator' => 'setSessionTimeout'), 'items_per_page' => array('mutator' => 'setItemsPerPage'), 'version' => array('mutator' => 'setVersion'), 'language' => array('mutator' => 'setLanguage'), 'id_theme' => array('mutator' => 'setIdTheme'));
return parent::Query($dsn);
}
/**
* bool Query_User(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_User($dsn = null)
{
$this->_table = "user_tbl";
$this->_primaryKey = array("id_user");
$this->_map = array('id_user' => array('mutator' => 'setIdUser'), 'id_member' => array('mutator' => 'setIdMember'), 'login' => array('mutator' => 'setLogin'), 'pwd' => array('mutator' => 'setPwd'), 'email' => array('mutator' => 'setEmail'), 'actived' => array('mutator' => 'setActived'), 'id_theme' => array('mutator' => 'setIdTheme'), 'id_profile' => array('mutator' => 'setIdProfile'));
return parent::Query($dsn);
}
/**
* bool Query_LogStats(string $table, array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_LogStats($table, $dsn = null)
{
if ($table != 'access' && $table != 'record') {
$table = 'access';
}
$this->_table = $table . '_log_tbl';
return parent::Query($dsn);
}
/**
* bool Query_DelPatient(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_DelPatient($dsn = null)
{
$this->_table = "deleted_patient_tbl";
$this->_primaryKey = null;
return parent::Query($dsn);
}
/**
* Constructor method.
*
* $sql is the SQL query you wish to execute with this object.
* $conn is the database connection resource to be queried.
*
* @access public
* @param string $sql
* @param resource $conn
*
*/
function PgSQL_Query($sql = '', &$conn, $cache = 0)
{
parent::Query($sql, $conn, $cache);
}
/**
* bool Query_Connection(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_Connection($dsn = null)
{
$this->_table = "connection_problem_tbl";
$this->_primaryKey = array("id_problem", "id_connection");
return parent::Query($dsn);
}
/**
* bool Query_Relative(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_Relative($dsn = null)
{
$this->_table = "relative_tbl";
return parent::Query($dsn);
}
/**
* bool Query_Session(array $dsn = null)
*
* Constructor function
*
* @param array $dsn (optional) Data Source Name
* @return boolean returns false, if error occurs
* @access public
*/
function Query_Session($dsn = null)
{
$this->_table = "session_tbl";
return parent::Query($dsn);
}
