FunctionForPatient_specialist_diagnoz.Php

<?

function patientOfSpecialistAndDiagnoz($connect, $diagnozTitle, $specialistTitle){

$textQueryPatiientFilter = "select `patient`.*, count(*) as `count_patient` from

((`personal` inner join `specialization` on `personal`.`specialization` = `specialization`.`id`)

inner join `result` on `personal`.`id` = `result`.`id_doc` inner join `patient` on `result`.`id_patient`=`patient`.`id`)

where `result`.`id_diagnoz` in (select `diagnoz`.`id` from `diagnoz` where `diagnoz`.`title` = '".$diagnozTitle."') and

`specialization`.`title` = '".$specialistTitle."' group by `result`.`id_patient`";

if($queryPatiientFilter = mysql_query($textQueryPatiientFilter, $connect))

return $queryPatiientFilter;

else

return false;

}

?>

FunctionForPersonal.Php

<?

function is_personal($connect){

$textQueryIsPersonal = "select count(`id`) as `is` from `personal`";

if($queryIsPersonal = mysql_query($textQueryIsPersonal, $connect)){

$resultIsPersonal = mysql_fetch_array($queryIsPersonal);

if($resultIsPersonal['is'] == 0)

return false;

else

return true;

}

}

function personalList($connect){

$textQueryPersonalList = "SELECT `personal` . * , `position`.`title` AS `position_title` , `specialization`.`title` AS `specialization_title` ,

CONCAT( `personal`.`lastname`, space(1), LEFT( `personal`.`name` , 1 ) , '. ', LEFT( `personal`.`father` , 1 ) , '.' ) AS `pib`

FROM ((`personal` INNER JOIN `position` ON `personal`.`position` = `position`.`id`)

INNER JOIN `specialization` ON `personal`.`specialization` = `specialization`.`id`)";

if($queryPersonalList = mysql_query($textQueryPersonalList, $connect)){

return $queryPersonalList;

}

}

function selectAllInfoPersonal($page, $connect){

$start = 0;

$finish = 10;

if($page > 1){

$start = ($page-1)*$finish;

$finish = $page*$finish;

}

$textQueryViewPersonal = "select `personal`.*, `position`.`title` as `position_title`, `specialization`.`title` as `specialization_title`

from ((`personal` inner join `position` on `personal`.`position` = `position`.`id`)

inner join `specialization` on `personal`.`specialization` = `specialization`.`id`) LIMIT ".$start." , ".$finish;

if($queryViewPersonal = mysql_query($textQueryViewPersonal)){

return $queryViewPersonal;

}

}

function selectIdInfoPersonal($id, $connect){

$textQueryViewPersonal = "select `personal`.*, `position`.`title` as `position_title`, `specialization`.`title` as `specialization_title`

from ((`personal` inner join `position` on `personal`.`position` = `position`.`id`)

inner join `specialization` on `personal`.`specialization` = `specialization`.`id`) WHERE `personal`.`id` = ".$id;

if($queryViewPersonal = mysql_query($textQueryViewPersonal)){

return $queryViewPersonal;

}

}

function insertPersonal($connect, $name, $lastname, $father, $position, $specialization){

$name = upperLowerStr($name);

$lastname = upperLowerStr($lastname);

$father = upperLowerStr($father);

$textQueryInsertPersonal = "insert into `personal` values(null, ".$position.",".$specialization.", '".$name."', '".$lastname."', '".$father."')";

if(mysql_query($textQueryInsertPersonal, $connect))

alert("Дані занесено успішно");

else

alert("Помилка при занесенні даних");

redirect($_SERVER['HTTP_REFERER']);

}

function updatePersonal($connect, $src, $id, $name, $lastname, $father, $position, $specialization){

$name = upperLowerStr($name);

$lastname = upperLowerStr($lastname);

$father = upperLowerStr($father);

$textQueryUpdatePersonal = "UPDATE `personal` SET `name`='".$name."', `lastname`='".$lastname."', `father`='".$father."', `position`='".$position."', `specialization`='".$specialization."' WHERE `id`=".$id;

if(!mysql_query($textQueryUpdatePersonal, $connect)){

alert('Помилка при оновленні даних');

}

redirect($src);

}

function deletePersonal($connect, $id){

$textQueryDeletePersonal = "delete from `personal` where `id` = ".$id;

if(!mysql_query($textQueryDeletePersonal, $connect)){

alert("Помилка при видаленні з таблиці 'Персонал'");

}

redirect($_SERVER['HTTP_REFERER']);

}

?>