public function index()
{
global $f;
$f = new FuncControllers();
$bio = array("54.100", "54.105", "54.335", "54.120", "54.440", "54.445", "54.130", "54.110", "54.115", "54.420", "54.125", "54.185", "54.205", "54.210", "54.215", "54.220", "54.225", "54.151", "54.206", "54.230", "54.265", "54.250", "54.255", "54.260", "54.245", "54.130", "54.300");
if (\Session::has("clientid")) {
$this->clientid = \Session::get("clientid");
}
if (Input::has("folderno")) {
$this->folderno = Input::get("folderno");
}
$exc = array("37", "95", "169", "199", "266", "284", "285", "301", "320", "324", "328", "329", "332", "370", "380", "382", "389", "397", "405", "407", "440", "93", "327", "1327", "345", "346", "387", "70");
$debug = 0;
if (Input::has("delete")) {
if (Input::has("panels")) {
$p = substr($_GET["panels"], 0, -1);
$p = explode(";", $p);
foreach ($p as $panel) {
$vsql = "EXECUTE PROCEDURE DEL_PANEL ('" . m_quotes($_GET["folderno"]) . "', '" . m_quotes($panel) . "', 'LIMS')";
$stmt = $this->DBquery->query($vsql);
if ($stmt === false) {
echo "Error in executing query.</br>";
} else {
echo "<b>Панель была успешно удалена из заявки.</b>";
}
}
} else {
$vsql = "EXECUTE PROCEDURE DEL_PANEL ('" . $f->m_quotes($_GET["folderno"]) . "', '" . $f->m_quotes($_GET["panel_id"]) . "', 'LIMS')";
$stmt = $this->DBquery->query($vsql);
if ($stmt === false) {
echo "Error in executing query.</br>";
} else {
echo "<b>Панель была успешно удалена из заявки.</b>";
}
}
} else {
if (\Input::has("save")) {
if (Input::has("panels")) {
$panels = $f->m_quotes(substr(Input::get('panels'), 0, -1));
}
if (Input::has("surname")) {
$surname = $f->strtoupper_utf8($f->m_quotes(Input::get("surname")));
// $surname = preg_replace("/([\s\x{0}\x{0B}]+)/i", " ", trim($surname));
}
if (Input::has("name")) {
$name = $f->strtoupper_utf8($f->m_quotes(Input::get("name")));
// $name = preg_replace("/([\s\x{0}\x{0B}]+)/i", " ", trim($name));
}
if (Input::has("namepatr")) {
$namepatr = $f->strtoupper_utf8($f->m_quotes(Input::get("namepatr")));
// $namepatr = preg_replace("/([\s\x{0}\x{0B})+)/i", " ", trim($namepatr));
} else {
$namepatr = '';
}
if (Input::has("doctor")) {
$doctor = $f->strtoupper_utf8($f->m_quotes(Input::get("doctor")));
} else {
$doctor = '';
}
if (Input::has("policy")) {
$policy = $f->strtoupper_utf8($f->m_quotes(Input::get("policy")));
} else {
$policy = '';
}
if (Input::has("insurer")) {
$insurer = $f->strtoupper_utf8($f->m_quotes(Input::get("insurer")));
}
if (!isset($insurer) || $insurer == "") {
$insurer = "N/A";
}
if (Input::has("insurerid")) {
$insurerid = $f->strtoupper_utf8($f->m_quotes(Input::get("insurerid")));
}
if (isset($insurerid) && $insurerid == "") {
$insurerid = "6";
}
if (Input::has("gender")) {
$gender = $f->m_quotes(Input::get("gender"));
switch ($gender) {
case -1:
$gender = "";
break;
case 1:
$gender = "M";
break;
case 2:
$gender = "F";
break;
}
} else {
$gender = '';
}
if (Input::has("cito")) {
$cito = $f->m_quotes(Input::get("cito"));
} else {
$cito = '';
}
if (Input::has("preg")) {
$pregnancy = $f->m_quotes(Input::get("preg"));
} else {
$pregnancy = '';
}
switch ($pregnancy) {
case -1:
$pregnancy = "";
break;
}
if (Input::has("phase")) {
$phase = $f->m_quotes(Input::get("phase"));
switch ($phase) {
case "-1":
$phase = "";
break;
}
} else {
$phase = '';
}
if (Input::has("dt_bday")) {
$dt_bday = $f->m_quotes(date("Y/n/j", strtotime(Input::get("dt_bday"))));
} else {
$dt_bday = '';
}
if (Input::has("comments")) {
$comments = $f->m_quotes(Input::get("comments"));
} else {
$comments = '';
}
if (Input::has("dt_catched")) {
$dt_take = $f->m_quotes(date("Y/n/j G:i", strtotime(Input::get("dt_catched"))));
} else {
$dt_take = '';
}
if (Input::has("diagnosis")) {
$diagnosis = $f->m_quotes(Input::get("diagnosis"));
} else {
$diagnosis = '';
}
if (Input::has("phone")) {
$phone = $f->m_quotes(Input::get("phone"));
} else {
$phone = '';
}
if (Input::has("diuresis")) {
$diuresis = $f->m_quotes(trim(Input::get("diuresis")) * 1.0);
} else {
$diuresis = '';
}
if (Input::has("antibio")) {
$antibiot = "Y";
if (Input::has("antibiotics")) {
$antibiotics = $f->m_quotes(Input::get("antibiotics"));
} else {
$antibiotics = '';
}
if (Input::has("dt_biostart")) {
$dt_biostart = $f->m_quotes(date("Y/n/j", strtotime(Input::get("dt_biostart"))));
} else {
$dt_biostart = '';
}
if (Input::has("dt_bioend")) {
$dt_bioend = $f->m_quotes(date("Y/n/j", strtotime(Input::get("dt_bioend"))));
} else {
$dt_bioend = '';
}
} else {
$antibiot = '';
$antibiotics = '';
$dt_biostart = '';
$dt_bioend = '';
}
if (Input::has("passport_series")) {
$passport_series = $f->m_quotes(Input::get("passport_series"));
} else {
$passport_series = '';
}
if (Input::has("passport_number")) {
$passport_number = $f->m_quotes(Input::get("passport_number"));
} else {
$passport_number = '';
}
if (Input::has("email")) {
$email = $f->m_quotes(Input::get("email"));
} else {
$email = '';
}
if (Input::has("department")) {
$department = $f->m_quotes(Input::get("department"));
} else {
$department = '';
}
if (Input::has("address")) {
$address = $f->m_quotes(Input::get("address"));
} else {
$address = '';
}
if (Input::has("weight")) {
$weight = $f->m_quotes(Input::get("weight"));
} else {
$weight = '';
}
if (Input::has("height")) {
$height = $f->m_quotes(Input::get("height"));
} else {
$height = '';
}
if (Input::has("tube")) {
$tube = $f->m_quotes(Input::get("tube"));
} else {
$tube = '';
}
if (Input::has("glass")) {
$glass = $f->m_quotes(Input::get("glass"));
} else {
$glass = '';
}
if (Input::has("card")) {
$card = $f->m_quotes(Input::get("card"));
} else {
$card = '';
}
if (Input::has("aisorder") && trim(Input::has("aisorder")) !== '') {
$aisorder = $f->m_quotes(Input::get("aisorder"));
} else {
$aisorder = $this->folderno;
}
if (Input::has("organisation")) {
$organisation = $f->m_quotes(Input::get("organisation"));
} else {
$organisation = '';
}
//if($organisation == "") $organisation = 'null';
$a = $cito . "|" . $surname . "|" . $name . "|" . $namepatr . "|" . $gender . "|" . $dt_take . "|" . $dt_bday . "|" . $phase . "|" . $pregnancy . "|" . $this->clientid . "|" . $doctor . "|" . $policy . "|" . $insurer . "|" . $diagnosis . "|" . $address . "|" . $comments . "|" . $tube . "|" . $phone . "|" . $email . "|" . $passport_series . "|" . $passport_number . "|" . \Session::get("valid_user") . "|" . date("d.m.Y H:i") . "|" . $this->folderno;
$f->writeFoldersAudit($a);
$vsql = "update folders set CARD = '" . $card . "', URGENT = '" . $cito . "', SURNAME = '" . $surname . "', NAME = '" . $name . "', PATRONIMIC = '" . $namepatr . "', GENDER = '" . $gender . "', DATE_COLLECTED = '" . $dt_take . "', DATE_BIRTH = '" . $dt_bday . "', PHASE = '" . $phase . "', PREGNANCY = '" . $pregnancy . "', CLIENTID = " . $this->clientid . ", DOCTOR = '" . $doctor . "', POLICY = '" . $policy . "', INSURER = '" . $insurer . "', DIURESIS = '" . $diuresis . "', DIAGNOSIS = '" . $diagnosis . "', ANTIB = '" . $antibiot . "', ANTIBIOTICS = '" . $antibiotics . "', ANTIB_START = '" . $dt_biostart . "', ANTIB_END = '" . $dt_bioend . "', ADDRESS = '" . $address . "', COMMENTS = '" . $comments . "', GLASS = '" . $glass . "', TUBE = '" . $tube . "', PHONE = '" . $phone . "', EMAIL = '" . $email . "', WEIGHT = '" . $weight . "', HEIGHT = '" . $height . "', PASSPORT_SERIES = '" . $passport_series . "', PASSPORT_NUMBER = '" . $passport_number . "', DEPARTMENT = '" . $department . "', ORGANISATION = '" . $organisation . "', AISORDER = '" . $aisorder . "' WHERE FOLDERNO = '" . $this->folderno . "'";
$vsql = str_replace("''", "null", $vsql);
$stmt = $this->DBquery->query($vsql);
if ($stmt === false) {
echo "Error in executing query.</br>";
}
$_panels = explode(",", $panels);
foreach ($_panels as $panel) {
$vsql = "EXECUTE PROCEDURE ADD_PANEL ('" . $this->folderno . "', '" . $panel . "', 'LIMS')";
$stmt = $this->DBquery->query3($vsql);
$stmt = (array) json_decode($stmt);
if (!$stmt['status'] == "success") {
echo "Error in executing query.</br>";
}
if (Input::has(str_replace(".", "_", $panel))) {
$vsql = "select fc.id from foldercontainers fc inner join orders ord on ord.folderno = fc.folderno " . "inner join ordtask o on o.containerid = fc.id and ord.id = o.ordersid " . "inner join panels p on p.id = ord.panelid " . "where fc.folderno ='" . $this->folderno . "' AND p.code = '" . $panel . "'";
$stmt = $this->DBquery->query($vsql);
if ($stmt === false) {
echo "Error in executing query.</br>";
}
$row = $stmt[0];
$row = (array) $row;
$vsql = "update foldercontainers set mattypeid = '" . Input::get(str_replace(".", "_", $panel)) . "' WHERE id = '" . $row[0] . "'";
$stmt = ib_query($vsql);
if ($stmt === false) {
echo "Error in executing query.</br>";
}
}
}
if ($debug == 1) {
echo "-------------- ОТЛАДОЧНАЯ ИНФОРМАЦИЯ --------------<br/>";
echo "Дата сбора: " . $dt_take . "<br/>";
echo "Фамилия: " . $surname . "<br/>";
echo "Имя: " . $name . "<br/>";
echo "Отчество: " . $namepatr . "<br/>";
echo "Доктор: " . $doctor . "<br/>";
echo "Полис: " . $policy . "<br/>";
echo "Страховая: " . $insurerid . "<br/>";
echo "Пол: " . $gender . "<br/>";
echo "Срочность: " . $cito . "<br/>";
echo "Срок беременности: " . $pregnancy . "<br/>";
echo "Фаза: " . $phase . "<br/>";
echo "Дата рождения: " . $dt_bday . "<br/>";
echo "Комментарий: " . $comments . "<br/>";
echo "Диагноз: " . $diagnosis . "<br/>";
echo "Телефон: " . $phone . "<br/>";
echo "Диурез: " . $diuresis . "<br/>";
echo "Антибиотики начало: " . $dt_biostart . "<br/>";
echo "Антибиотики конец: " . $dt_bioend . "<br/>";
echo "Серия паспорта: " . $passport_series . "<br/>";
echo "Номер паспорта: " . $passport_number . "<br/>";
echo "E-mail: " . $email . "<br/>";
echo "Препарат: " . $antibiotics . "<br/>";
echo "Отделение: " . $department . "<br/>";
echo "Адрес: " . $address . "<br/>";
echo "КОД ЛПУ: " . $this->clientid . "<br/>";
echo "ПАНЕЛИ: " . $panels . "<br/>";
echo "Вес: " . $weight . "<br/>";
echo "Рост: " . $height . "<br/>";
echo "-------------- ОТЛАДОЧНАЯ ИНФОРМАЦИЯ --------------<br/><br/>";
}
echo "<script>\$('#folderno').html('" . $this->folderno . "');</script>";
echo "<img style=\"vertical-align: inherit; padding-right: 15px; margin:0px; border:0\" src=\"images/ok.jpg\" /><b>Ваши изменения были успешно сохранены</b>";
} else {
$this->editReg();
// var_dump($this->arr);
// var_dump($this->rowf);
return \View::make('regEdit')->with(['folderno' => $this->folderno, 'rowf' => $this->rowf, 'arr' => $this->arr]);
}
}
}
if (isset($_GET["t"]) && $_GET["t"] !== "") {
// AUTOCOMPLETE -----> // ДЛЯ ЕНТЕРА 1 ЗАПИСЬ
if (isset($_GET["term"]) && $_GET["term"] !== "") {
$useprice = false;
if (getUsePrice($clientcode)) {
$rs = query("select ps.panelid, p.PANEL as \"title\", p.ID as \"id\", p.CODE as \"code\", p.IMG_SRC from prices ps inner join pricelists pl on pl.id = ps.pricelistid inner join panels p on p.id = ps.panelid where CODE = '" . m_quotes(str_replace(",", ".", $_GET["term"])) . "' AND clientid = '" . $clientid . "' and pl.status = 'A' AND p.PANELCATID is not NULL and p.STATUS = 'A'");
$useprice = true;
} else {
$rs = query("SELECT p.PANEL as \"panel\", p.ID as \"id\", p.CODE as \"code\", '' as \"color\", p.IMG_SRC, p.PANELCATID as \"panelcatid\" FROM PANELS p WHERE CODE = '" . m_quotes(str_replace(",", ".", $_GET["term"])) . "' AND STATUS = 'A' AND PANELCATID is not NULL");
}
$resp = getRespS($rs, $useprice);
echo $resp;
}
} else {
if (isset($_GET["i"]) && $_GET["i"] !== "") {
// AUTOCOMPLETE -----> INSURERS
if (isset($_GET["term"]) && $_GET["term"] !== "") {
$rs = query("SELECT ID as \"id\", INSURER as \"label\" FROM INSURERS WHERE INSURER CONTAINING '" . m_quotes($_GET["term"]) . "'");
$resp = "[";
foreach ($rs as $row) {
$row = (array) $row;
$resp .= "{ \"id\" : \"" . $row["id"] . "\", \"label\": \"" . $row["label"] . "\", \"value\": \"" . $row["label"] . "\" },";
}
if (strlen($resp) > 1) {
echo substr($resp, 0, -1) . "]";
}
}
}
}
}
}
function getBio($code, $id)
{
global $bio, $mt_otherid;
// if (!in_array($code,$bio)) return false;
$code = m_quotes($code);
$rs = query("SELECT MAT_TYPES FROM PANELS WHERE CODE = '" . $code . "'");
if ($code[0] . $code[1] == "14") {
$b = "Соскоб получен:";
} else {
$b = "Биоматериал:";
}
$mat = "<span id='additional%s' style='margin-left:35px; display:none'>" . "<table class='bio'>" . "<tr><td colspan='2'>" . $b . "<br/>%s </td></tr>" . "</table>" . "</span>";
$mat1 = "<select disabled='disabled' style='width:300px;' id='m" . $id . "' name='" . $code . "' onchange='setBio( this.value , " . $id . " )' >";
$mat1 .= "<option value='70'></option>";
foreach ($rs as $row) {
$row = (array) $row;
if ($row["MAT_TYPES"] && !empty($row["MAT_TYPES"])) {
$arr = explode(";", $row["MAT_TYPES"]);
foreach ($arr as $val) {
$rs2 = query("SELECT ID, MATTYPE FROM MATTYPES WHERE ID = '" . $val . "'");
$row2 = (array) $rs2[0];
if ($row2["ID"] == $mt_otherid) {
$mat1 .= "<option value='" . $row2["ID"] . "'>" . $row2["MATTYPE"] . " (укажите в комментарии)</option>";
} else {
$mat1 .= "<option value='" . $row2["ID"] . "'>" . $row2["MATTYPE"] . "</option>";
}
}
} else {
return false;
}
}
$mat1 .= "</select>";
return sprintf($mat, $id, $mat1);
}
