/**
* Fetch Hulpverleners which references this AanvraagOverleg. Will return null in case reference is invalid.
* `aanvraag_overleg`.`id_organisator` -> `hulpverleners`.`id`
*
* @param PDO $db a PDO Database instance
* @param array $sort array of DSC instances
* @return Hulpverleners
*/
public function fetchHulpverleners(PDO $db, $sort = null)
{
$filter = array(Hulpverleners::FIELD_ID => $this->getIdOrganisator());
$result = Hulpverleners::findByFilter($db, $filter, true, $sort);
return empty($result) ? null : $result[0];
}
/**
* Fetch Hulpverleners's which this Persoon references.
* `persoon`.`id` -> `hulpverleners`.`id`
*
* @param PDO $db a PDO Database instance
* @param array $sort array of DSC instances
* @return Hulpverleners[]
*/
public function fetchHulpverlenersCollection(PDO $db, $sort = null)
{
$filter = array(Hulpverleners::FIELD_ID => $this->getId());
return Hulpverleners::findByFilter($db, $filter, true, $sort);
}
/**
* get single Hulpverleners instance from a DOMElement
*
* @param DOMElement $node
* @return Hulpverleners
*/
public static function fromDOMElement(DOMElement $node)
{
$o = new Hulpverleners();
$o->assignByHash(self::domNodeToHash($node, self::$FIELD_NAMES, self::$DEFAULT_VALUES, self::$FIELD_TYPES));
$o->notifyPristine();
return $o;
}
public function getPatientToewijzing($id, $getobject = false)
{
$patient = self::startPatient();
$patient->setId($id);
$result = Patient::findByExample(self::$db, $patient);
if (count($result) < 1) {
return 0;
} else {
$pat = $result[0];
if ($getobject) {
return $pat;
}
//patient object returnen
switch ($pat->getToegewezenGenre()) {
case "gemeente":
return 1;
break;
case "rdc":
case "psy":
ecpimport("database.organisatie", "class");
$org = new Organisatie();
$org->setId($pat->getToegewezenId());
$coresult = Organisatie::findByExample(self::$db, $org);
if (count($coresult) < 1) {
return null;
} else {
return $coresult[0]->getNaam();
}
break;
default:
ecpimport("database.hulpverleners", "class");
$hulp = new Hulpverleners();
$hulp->setId($pat->getToegewezenId());
$huresult = Hulpverleners::findByExample(self::$db, $hulp);
if (count($huresult) < 1) {
return null;
} else {
return $huresult[0]->getNaam();
}
break;
}
}
}
