|
title_preffix ?> |
|
name ?> |
|
surname ?> |
|
title_suffix ?> |
id;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
else {
$db_row = mysql_fetch_row($db_result);
$this->id = $db_row[0];
$this->name = $db_row[1];
$this->surname = $db_row[2];
$this->nickname = $db_row[3];
$this->gender = $db_row[4];
$this->title_preffix = $db_row[5];
$this->title_suffix = $db_row[6];
}
}
/****************************************************************************************/
public function data_insert() {
db_connect();
$db_query = "INSERT INTO c_person (" .
($this->id > 0? "pk_c_person, " : "").
"name, ".
"surname, ".
"title_preffix, ".
"title_suffix ".
") VALUES (".
($this->id > 0? "'" . $this->id . "', ": "").
"'". $this->name . "', ".
"'". $this->surname . "', ".
"'". $this->title_preffix . "', ".
"'". $this->title_suffix . "')";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
else $this->id = mysql_insert_id();
return true;
}
/****************************************************************************************/
public function data_update() {
db_connect();
$db_query = "UPDATE c_person SET " .
"name='". $this->name . "', ".
"surname='". $this->surname . "', ".
"title_preffix='". $this->title_preffix . "', ".
"title_suffix='". $this->title_suffix . "' ".
"WHERE pk_c_person='". $this->id ."'";
if ($this->id > 0) $db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************************************************************************************/
public function data_delete() {
db_connect();
$db_query = "DELETE FROM c_person " .
"WHERE pk_c_person='". $this->id ."'";
$db_result = false;
if ($this->id > 0) $db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************************************************************************************/
/****************** RELATION COMPANY ****************************************************/
/****************************************************************************************/
public function employ($p_id_company,$p_id_department,$p_note) {
db_connect();
$db_query = "INSERT INTO c_join_employ (" .
"fk_c_company, ".
"fk_c_person, ".
"fk_c_department, ".
"note ".
") VALUES (".
"'". $p_id_company . "', ".
"'". $this->id . "', ".
"'". $p_id_department . "', ".
"'". $p_note . "')";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************************************************************************************/
/****************** RELATION PHONE ******************************************************/
/****************************************************************************************/
public function print_list_phone() {
db_connect();
$db_query = "SELECT ".
"pk_c_phone, ".
"priority, ".
"note, " .
"number " .
"FROM c_phone ".
"INNER JOIN c_join_person_phone ON pk_c_phone=fk_c_phone " .
"WHERE fk_c_person=" . $this->id . " " .
"ORDER BY priority";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " . $db_query);
else if (mysql_num_rows($db_result)>0) {
?>
id . " " .
"ORDER BY priority";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " . $db_query);
else if (mysql_num_rows($db_result)>0) {
?>
id ."',".
"'". $l_id_phone ."',".
"'". $p_priority ."',".
"'". $p_note ."')";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
}
return true;
}
/****************** RELATION PHONE ******************************************************/
public function data_delete_relation_phone($p_id_join_phone) {
db_connect();
$db_query = "DELETE FROM c_join_person_phone WHERE pk_c_join_person_phone=". $p_id_join_phone;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************** RELATION PHONE ******************************************************/
public function data_update_relation_phone($p_id_join_phone, $p_note, $p_priority) {
db_connect();
if ($p_priority == "P") {
$db_query = "UPDATE c_join_person_phone SET priority='S' ".
"WHERE fk_c_person=". $this->id;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
}
$db_query = "UPDATE c_join_person_phone SET " .
"note='". $p_note . "', ".
"priority='". $p_priority . "' ".
"WHERE pk_c_join_person_phone=". $p_id_join_phone;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************************************************************************************/
/****************** RELATION EMAIL ******************************************************/
/****************************************************************************************/
public function print_list_email() {
db_connect();
$db_query = "SELECT ".
"pk_c_email,".
"priority, ".
"note, " .
"url " .
"FROM c_email ".
"INNER JOIN c_join_person_email ON pk_c_email=fk_c_email " .
"WHERE fk_c_person=" . $this->id . " " .
"ORDER BY priority";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " . $db_query);
else if (mysql_num_rows($db_result)>0) {
?>
id . " " .
"ORDER BY priority";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " . $db_query);
else if (mysql_num_rows($db_result)>0) {
?>
id ."',".
"'". $l_id_email ."',".
"'". $p_priority ."',".
"'". $p_note ."')";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
}
return true;
}
/****************** RELATION EMAIL ******************************************************/
public function data_delete_relation_email($p_id_join_email) {
db_connect();
$db_query = "DELETE FROM c_join_person_email WHERE pk_c_join_person_email=". $p_id_join_email;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************** RELATION EMAIL ******************************************************/
public function data_update_relation_email($p_id_join_email, $p_note, $p_priority) {
db_connect();
if ($p_priority == "P") {
$db_query = "UPDATE c_join_person_email SET priority='S' ".
"WHERE fk_c_person=". $this->id;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
}
$db_query = "UPDATE c_join_person_email SET " .
"note='". $p_note . "', ".
"priority='". $p_priority . "' ".
"WHERE pk_c_join_person_email=". $p_id_join_email;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************************************************************************************/
/****************** RELATION WEB ********************************************************/
/****************************************************************************************/
public function print_list_web() {
db_connect();
$db_query = "SELECT ".
"pk_c_web,".
"priority, ".
"note, " .
"url " .
"FROM c_web ".
"INNER JOIN c_join_person_web ON pk_c_web=fk_c_web " .
"WHERE fk_c_person=" . $this->id . " " .
"ORDER BY priority";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " . $db_query);
else if (mysql_num_rows($db_result)>0) {
?>
id . " " .
"ORDER BY priority";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " . $db_query);
else if (mysql_num_rows($db_result)>0) {
?>
id ."',".
"'". $l_id_web ."',".
"'". $p_priority ."',".
"'". $p_note ."')";
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
}
return true;
}
/****************** RELATION WEB ********************************************************/
public function data_delete_relation_web($p_id_join_web) {
db_connect();
$db_query = "DELETE FROM c_join_person_web WHERE pk_c_join_person_web=". $p_id_join_web;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
/****************** RELATION WEB ********************************************************/
public function data_update_relation_web($p_id_join_web, $p_note, $p_priority) {
db_connect();
if ($p_priority == "P") {
$db_query = "UPDATE c_join_person_web SET priority='S' ".
"WHERE fk_c_person=". $this->id;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
}
$db_query = "UPDATE c_join_person_web SET " .
"note='". $p_note . "', ".
"priority='". $p_priority . "' ".
"WHERE pk_c_join_person_web=". $p_id_join_web;
$db_result = mysql_query($db_query);
if (!$db_result) die (MSG_ERROR_SQL . mysql_error() . " " .$db_query);
return true;
}
}
/****************************************************************************************/
/****************** LIST FUNCTION *****************************************************/
/****************************************************************************************/
function print_list_person($p_link) {
db_connect();
$db_query = "SELECT ".
"c_person.pk_c_person, ".
"c_person.name, " .
"c_person.surname, ".
"c_person.title_preffix, ".
"c_person.title_suffix, ".
"c_phone.number, ".
"c_email.url, ".
"c_web.url ".
"FROM ".
"c_person ".
"LEFT JOIN c_join_person_phone ON pk_c_person=c_join_person_phone.fk_c_person ".
"LEFT JOIN c_phone ON pk_c_phone=fk_c_phone ".
"LEFT JOIN c_join_person_email ON pk_c_person=c_join_person_email.fk_c_person ".
"LEFT JOIN c_email ON pk_c_email=fk_c_email ".
"LEFT JOIN c_join_person_web ON pk_c_person=c_join_person_web.fk_c_person ".
"LEFT JOIN c_web ON pk_c_web=fk_c_web ".
"GROUP BY pk_c_person ".
"ORDER BY c_person.surname,c_person.name";
$db_result = mysql_query($db_query);
if (!$db_result) die ('Chyba SQL: ' . mysql_error() . " " . $db_query);
else if (mysql_num_rows($db_result)>0) {
?>