<?php

function getGraphData($lastdata) {
	global $myDB;
	$rc = (array("rc" => "__OK__", "counter" => 0, "lastdata" => $lastdata));
	$qrySel = "\tSELECT COUNT(*) counter, TO_CHAR(sysdate, 'DD-MM-YYYY HH24:MI:SS') lastdata\n\t\t\t\t\t\t\tFROM passages";
	if ($lastdata == "") {
		$qrySel .= " WHERE passagets > sysdate";
	}
	 else  {
		$qrySel .= " WHERE passagets > TO_DATE('" . $lastdata . "','DD/MM/YYYY HH24:MI:SS')";
	}
	$retSel = $myDB->execute($qrySel);
	if ($retSel && ($recSel = $myDB->fetchArray($retSel))) {
		$rc = (array("rc" => "__OK__", "counter" => $recSel["COUNTER"] + rand(4, 200), "lastdata" => $recSel["LASTDATA"]));
	}
	return my_json_encode($rc);
}

function checkCardRead($codiceFiscale, $cognome, $nome, $scadenza, $dataNascita, $sesso, $luogoNascita, $luogoResidenza, $indirizzoResidenza, $dataEmittente, $docImgSrc, $useBase64) {
	global $myDB;
	$fullname = $cognome . " " . $nome;
	$documenttype = 0;
	$document = $codiceFiscale;
	$qrySel = "\tSELECT p.persoid, p.fullname, p.persontype,\n\t\t\t\t\t\t\t\tpd.personalemailaddress, pd.cellularnumber\n\t\t\t\t\t\t\tFROM person p\n\t\t\t\t\t\t\t\tLEFT OUTER JOIN personaldata pd ON p.persoid = pd.persoid\n\t\t\t\t\t\t\tWHERE pd.taxnumber = '" . $codiceFiscale . "'";
	$retSel = $myDB->execute($qrySel);
	if ($retSel && ($recSel = $myDB->fetchArray($retSel))) {
		$persontype = $recSel["PERSONTYPE"];
		if ($persontype == 0 || $persontype == 2) {
			$p = (array("persoid" => $recSel["PERSOID"], "fullname" => $fullname));
			return my_json_encode(array("rc" => $persontype == 0 ? "__OK_EMPLOYEE__" : "__OK_ADVISOR__", "p" => $p));
		}
		 else  {
			$objArr = LoadlastVisitData($recSel["PERSOID"], $docImgSrc, $useBase64);
			$myVisitor = new Visitor($recSel["PERSOID"]);
			$myVisitor->setFullname($fullname);
			$myVisitor->setFirstname($nome);
			$myVisitor->setLastname($cognome);
			$myVisitor->setGender($sesso == "M" ? 1 : ($sesso == "F" ? 2 : 0));
			if ($scadenza != "") {
				$myVisitor->setEnddate($scadenza . " 23:59:59");
			}
			$myVisitor->save();
			if ($objArr == null) {
				$p = (array("persoid" => $recSel["PERSOID"], "fullname" => $fullname));
			}
			 else  {
				$p = (array("persoid" => $recSel["PERSOID"], "fullname" => $fullname, "email" => $objArr["PERSONALEMAILADDRESS"], "mobile" => $objArr["CELLULARNUMBER"], "document" => $objArr["DOCUMENT"], "documenttype" => $objArr["DOCUMENTTYPE"], "imglink" => $objArr["DOCUMENTIMGURL"], "imgbase64" => $objArr["DOCUMENTIMGBASE64"], "informativeviewdate" => $objArr["INFORMATIVEVIEWDATE"]));
			}
			return json_encode(array("rc" => "__OK_UPDATED__", "p" => $p));
		}
	}
	 else  {
		$myVisitor = new Visitor();
		$myVisitor->setFullname($fullname);
		$myVisitor->setFirstname($nome);
		$myVisitor->setLastname($cognome);
		$myVisitor->setGender($sesso == "M" ? 1 : ($sesso == "F" ? 2 : 0));
		if ($scadenza != "") {
			$myVisitor->setEnddate($scadenza . " 23:59:59");
		}
		$myVisitor->save();
		$myVisitor->loadPersonalData();
		$myVisitor->PersonalData->setDocument(substr($document, 0, 15));
		$myVisitor->PersonalData->setDocumenttype($documenttype);
		if ($scadenza != "") {
			$myVisitor->PersonalData->setDocumentexpdate($scadenza . " 23:59:59");
		}
		if ($dataEmittente != "") {
			$myVisitor->PersonalData->setDocumentdate($dataEmittente . " 00:00:00");
		}
		$myVisitor->PersonalData->setTaxnumber($codiceFiscale);
		$myVisitor->PersonalData->setAddress($indirizzoResidenza);
		$myVisitor->PersonalData->setCity($luogoResidenza);
		$myVisitor->PersonalData->setBirthplace($luogoNascita);
		if ($dataNascita != "") {
			$myVisitor->PersonalData->setBirthday($dataNascita . " 00:00:00");
		}
		$myVisitor->PersonalData->save();
		$p = (array("persoid" => $myVisitor->getKey(), "fullname" => $fullname, "email" => "", "mobile" => "", "document" => $document, "documenttype" => $documenttype, "imgLink" => ""));
		return my_json_encode(array("rc" => "__OK_SAVED__", "p" => $p));
	}
	return my_json_encode(array("rc" => "__OK__", "msg" => $orderNameUsed, "query" => $query));
}

function isOrderNameUsed($name, $id = 0) {
	global $myDB;
	$idCond = $id ? (" AND orderid != '" . $id . "'") : "";
	$query = "\n\t\tSELECT COUNT(orderid) AS counto\n\t\tFROM orders\n\t\tWHERE name = '" . $name . "' " . $idCond . "\n\t";
	$ret = $myDB->execute($query);
	$orderNameUsed = false;
	if ($rec = $myDB->fetchArray($ret)) {
		$orderNameUsed = 0 < $rec["COUNTO"];
	}
	return my_json_encode(array("rc" => "__OK__", "msg" => $orderNameUsed, "query" => $query));
}

function getEpLinkedElements($epId) {
	global $myDB;
	$Lang = vamLanguage();
	$wsgs = getWsgConnected($epId);
	$tr = "";
	if (count($wsg)) {
		$wsgsHtmlList = "";
		$i = 0;
		foreach ($wsgs as $wsg) {
			$wsgsHtmlList .= "<option value=\"" . $i . "\">" . $wsg["name"] . "</option>";
			continue;
		}
		$tr = "<tr>\n    <td>\n    " . $Lang->get("N_WSGROUP") . "\n    </td>\n    <td>\n    <select class=\"SELECT\" size=\"1\">\n  " . $wsgsHtmlList . "\n  </select>  \n    </td>\n    </tr>";
	}
	$query = "\n\t\tSELECT count(distinct persoid)\n\t\tFROM epauthorization epa\n\t\tWHERE\tepa.kind != 1\n\t\t\tAND epa.startdate <= sysdate\n\t\t\tAND epa.enddate >= sysdate\n\t\t\tAND epa.entrancepointid = " . $epId;
	$res = $myDB->execute($query);
	if ($rec = $myDB->fetchRow($res)) {
		$epAuthPeople = $rec[0];
	}
	$query = "\n\t\tSELECT count(distinct epsa.persoid)\n\t\tFROM epsauthorization epsa \n\t\tJOIN epeps epeps ON epsa.entrancepointsetid = epeps.entrancepointsetid \n    JOIN entrancepoints ep ON ep.entrancepointid = epeps.entrancepointid\n\t\tWHERE epsa.kind != 1\n\t\t\tAND epsa.startdate <= sysdate\n\t\t\tAND epsa.enddate >= sysdate\n\t\t\tAND epeps.entrancepointid = " . $epId . "\n      AND (epsa.nareaid IS NULL or ep.nareaid IN (\n        SELECT nareaid\n                FROM n_area\n                CONNECT BY PRIOR nareaid = parentid\n                START WITH nareaid = epsa.nareaid\n        ))";
	$res = $myDB->execute($query);
.........................................................
......................
.........