public function getCategoriaByNombre()
{
$table = new \apf\db\mysql5\Table($this->_table);
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id", "nombre"));
$where = array(array("field" => "nombre", "value" => $this->_nombre));
$select->where($where);
$res = $select->execute();
if (!sizeof($res)) {
throw new \Exception("No se encontro la categoria " . $this->_nombre);
}
$this->setId($res["id"]);
}
public function getPaisById()
{
$table = new \apf\db\mysql5\Table($this->_table);
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id", "nombre"));
$where = array(array("field" => "id", "value" => $this->_id));
$select->where($where);
$res = $select->execute($smartMode = TRUE);
if (!$res) {
return FALSE;
}
$this->setId($res["id"]);
$this->setNombre($res["nombre"]);
}
public function existeOfertaEnUbicacion()
{
$table = new \apf\db\mysql5\Table("ofertas_ubicacion");
$select = new \apf\db\mysql5\Select($table);
$fields = array("id_oferta", "id_localidad", "id_barrio");
$select->fields($fields);
$localidades = array();
if (sizeof($this->_localidades) && !sizeof($this->_barrios)) {
foreach ($this->_localidades as $localidad) {
$localidades[] = $localidad->getId();
}
}
$barrios = array();
if (sizeof($this->_barrios)) {
foreach ($this->_barrios as $barrio) {
$idBarrio = $barrio->getId();
if (!is_null($idBarrio)) {
$barrios[] = $barrio->getId();
}
}
}
$where = array(array("field" => "id_oferta", "value" => $this->_id));
if (sizeof($localidades)) {
if (sizeof($localidades) == 1) {
$operator = '=';
$localidades = $localidades[0];
} else {
$operator = 'IN';
}
$where[] = array("operator" => "AND");
$where[] = array("field" => "id_localidad", "operator" => $operator, "value" => $localidades);
}
if (sizeof($barrios)) {
if (sizeof($barrios) == 1) {
$operator = '=';
$barrios = $barrios[0];
} else {
$operator = "IN";
}
$where[] = array("operator" => "AND");
$where[] = array("field" => "id_barrio", "operator" => $operator, "value" => $barrios);
}
$select->where($where);
$res = $select->execute();
if ($res) {
return TRUE;
}
return FALSE;
}
public function existeCategoriaUsuario($id_categoria)
{
$table = new \apf\db\mysql5\Table("usuarios_categorias");
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id_usuario"));
$where = array(array("field" => "id_usuario", "value" => $this->getId()), array("operator" => "AND"), array("field" => "id_categoria", "value" => $id_categoria));
$select->where($where);
$select->limit(array(1));
$res = $select->execute();
if (!sizeof($res)) {
return FALSE;
}
return true;
}
public function exists()
{
$table = new \apf\db\mysql5\Table($this->_table);
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id"));
$where = array(array("field" => "uri", "value" => $this->_uri), array("operator" => "AND"), array("field" => "categoria", "value" => $this->_categoria), array("operator" => "AND"), array("field" => "provincia", "value" => $this->_provincia));
$select->where($where);
$res = $select->execute();
if ($res) {
return TRUE;
}
return FALSE;
}
public function getLocalidadById()
{
$table = new \apf\db\mysql5\Table($this->_table);
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id", "id_provincia", "nombre"));
$where = array(array("field" => "id", "value" => $this->_id));
$select->where($where);
try {
$res = $select->execute();
$provincia = new Provincia(NULL, $res["id_provincia"]);
$this->setProvincia($provincia);
$this->setId($res["id"]);
$this->setNombre($res["nombre"]);
} catch (\Exception $e) {
$msg = $e->getMessage();
throw new \Exception("No se encontro la localidad con el id " . $this->_id);
}
}
public function getProvinciaById()
{
$table = new \apf\db\mysql5\Table($this->_table);
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id", "id_pais", "nombre"));
$where = array(array("field" => "id", "value" => $this->_id));
$select->where($where);
try {
$res = $select->execute();
$pais = new Pais($res["id_pais"]);
$this->setPais($pais);
$this->setNombre($res["nombre"]);
} catch (\Exception $e) {
throw new \Exception("No se pudo encontrar la provincia con el id " . $this->_id);
}
}
public function existe()
{
$table = new \apf\db\mysql5\Table($this->_table);
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id"));
$where = array(array("field" => "nombre", "value" => $this->_nombre));
$select->where($where);
return $select->execute();
}
public function getBarrioById()
{
$table = new \apf\db\mysql5\Table($this->_table);
$select = new \apf\db\mysql5\Select($table);
$select->fields(array("id", "nombre"));
$where = array(array("field" => "id_localidad", "value" => $this->_localidad->getId()), array("operator" => "AND"), array("field" => "id", "value" => $this->_id));
$select->where($where);
$res = $select->execute();
if (!sizeof($res)) {
throw new \Exception("No se encontro el barrio " . $this->_nombre . " para la localidad " . $this->_localidad->getNombre());
}
$this->setNombre($res["nombre"]);
}
