public function loadFromSqlResultQuery($rq)
{
$this->id = $rq[$this->PRIMARY_KEY_DB_NAME];
if (isset($rq[$this->SOFTWARE_NUMERO_SERIE]) && !SoftwareDTO::isEmpty($rq[$this->SOFTWARE_NUMERO_SERIE])) {
$this->softwareNumeroSerie = $this->scapeString($rq[$this->SOFTWARE_NUMERO_SERIE]);
} else {
$this->softwareNumeroSerie = null;
}
if (isset($rq[$this->SOFTWARE_NOMBRE]) && !SoftwareDTO::isEmpty($rq[$this->SOFTWARE_NOMBRE])) {
$this->softwareNombre = $this->scapeString($rq[$this->SOFTWARE_NOMBRE]);
} else {
$this->softwareNombre = null;
}
if (isset($rq[$this->SOFTWARE_VERSION]) && !SoftwareDTO::isEmpty($rq[$this->SOFTWARE_VERSION])) {
$this->softwareVersion = $this->scapeString($rq[$this->SOFTWARE_VERSION]);
} else {
$this->softwareVersion = null;
}
if (isset($rq[$this->SOFTWARE_FECHA_CADUCIDAD]) && !SoftwareDTO::isEmpty($rq[$this->SOFTWARE_FECHA_CADUCIDAD])) {
$this->softwareFechaCaducidad = $this->scapeString($rq[$this->SOFTWARE_FECHA_CADUCIDAD]);
} else {
$this->softwareFechaCaducidad = null;
}
if (isset($rq[$this->SOFTWARE_FECHA_AQUISICION]) && !SoftwareDTO::isEmpty($rq[$this->SOFTWARE_FECHA_AQUISICION])) {
$this->softwareFechaAquisicion = $this->scapeString($rq[$this->SOFTWARE_FECHA_AQUISICION]);
} else {
$this->softwareFechaAquisicion = null;
}
if (isset($rq[$this->SOFTWARE_EQUIPOS_PERMITIDOS]) && !SoftwareDTO::isEmpty($rq[$this->SOFTWARE_EQUIPOS_PERMITIDOS])) {
$this->softwareEquiposPermitidos = $this->scapeString($rq[$this->SOFTWARE_EQUIPOS_PERMITIDOS]);
} else {
$this->softwareEquiposPermitidos = null;
}
if (isset($rq[$this->SOFTWARE_COMENTARIOS]) && !SoftwareDTO::isEmpty($rq[$this->SOFTWARE_COMENTARIOS])) {
$this->softwareComentarios = $this->scapeString($rq[$this->SOFTWARE_COMENTARIOS]);
} else {
$this->softwareComentarios = null;
}
}
public static function loadFromXML($xmlDaos)
{
$daos = array();
$doc = new DOMDocument('1.0', 'utf-8');
$doc->loadXML($xmlDaos);
$nodes = $doc->getElementsByTagName("Software");
foreach ($nodes as $node) {
$dao = new SoftwareDTO();
$data = $node->getElementsByTagName("Software_Id");
if ($data->length > 0) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setId($data);
$data = $node->getElementsByTagName("softwareNumeroSerie");
if ($data->length > 0 && !SoftwareDTO::isEmpty($data->item(0)->nodeValue)) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setSoftwareNumeroSerie($data);
$data = $node->getElementsByTagName("softwareNombre");
if ($data->length > 0 && !SoftwareDTO::isEmpty($data->item(0)->nodeValue)) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setSoftwareNombre($data);
$data = $node->getElementsByTagName("softwareVersion");
if ($data->length > 0 && !SoftwareDTO::isEmpty($data->item(0)->nodeValue)) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setSoftwareVersion($data);
$data = $node->getElementsByTagName("softwareFechaCaducidad");
if ($data->length > 0 && !SoftwareDTO::isEmpty($data->item(0)->nodeValue)) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setSoftwareFechaCaducidad($data);
$data = $node->getElementsByTagName("softwareFechaAquisicion");
if ($data->length > 0 && !SoftwareDTO::isEmpty($data->item(0)->nodeValue)) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setSoftwareFechaAquisicion($data);
$data = $node->getElementsByTagName("softwareEquiposPermitidos");
if ($data->length > 0 && !SoftwareDTO::isEmpty($data->item(0)->nodeValue)) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setSoftwareEquiposPermitidos($data);
$data = $node->getElementsByTagName("softwareComentarios");
if ($data->length > 0 && !SoftwareDTO::isEmpty($data->item(0)->nodeValue)) {
$data = $data->item(0)->nodeValue;
} else {
$data = null;
}
$dao->setSoftwareComentarios($data);
$daos[] = $dao;
}
return $daos;
}
