public function getReservationsByDate($start, $end) { $result = array(); if ($this->model->getId() > 0) { $sql = sprintf(" SELECT distinct r.src_id FROM `object_relations_11` r join object_query_11 o on o.oo_id=r.src_id WHERE r.`dest_id` = '%d' AND o.`start`>= '%e' AND o.`start`<= '%f' AND r.`fieldname` = 'serving' ", $this->model->getId(), $start, $end); $data = $this->db->FetchAll($sql); } foreach ($data as $key => $row) { $loc = \Object\Reservation::getById($row["src_id"]); if ($loc instanceof \Object\Reservation) { $result[] = $loc; } } return $result; }
public function replace($data = array()) { try { if ($this->model->getId() > 0) { $object = $this->model; } elseif ($data['id'] > 0 and $data['id'] != "") { $object = \Object\Reservation::getById($data['id']); } elseif ($data['o_id'] > 0 and $data['o_id'] != "") { $object = \Object\Reservation::getById($data['o_id']); } else { $object = $this->model; $date = new \Zend_Date(); $object->setCreationDate($date->get()); $object->setUserOwner(1); $object->setUserModification(1); if (method_exists($object, "setDateregister")) { $object->setDateregister($date->get()); } $object->setPublished(1); } if ($object instanceof \Object\Reservation) { $object->setValues($data); $date = new \Zend_Date(); $object->setModificationDate($date); if (!$object->getO_key()) { $folder = $this->getFolderDay(); $object->setParent($folder); $key1 = $this->model->getClassName(); $numero = $date->get(\Zend_Date::TIMESTAMP); $object_key = $this->correctClassname($key1) . '-' . $numero; $object->setO_key(strtolower($object_key)); } return $object; } else { \Logger::warning("Erreur : Classe de l'objet erronnée"); return false; } } catch (\Exception $e) { \Logger::warning($e->getMessage()); return false; } }