public function processCopyToUserRemoveAction() { $dateStart = date('Y-m-d', strtotime($this->_getParam('dateStart'))); $dateEnd = date('Y-m-d', strtotime($this->_getParam('dateEnd'))); $providerId = (int) $this->_getParam('providerId'); $roomId = (int) $this->_getParam('roomId'); $start = $dateStart . ' 00:00:00'; $end = $dateEnd . ' 23:59:59'; $data = ScheduleEvent::getNumberOfEvents($providerId, $roomId, $start, $end); $scheduleEvent = new ScheduleEvent(); $scheduleEvent->providerId = $providerId; $scheduleEvent->roomId = $roomId; $scheduleEvent->start = $start; $scheduleEvent->end = $end; $scheduleEvent->deleteByDateRange(); // remove any existing data $json = Zend_Controller_Action_HelperBroker::getStaticHelper('json'); $json->suppressExit = true; $json->direct($data); }
public function processCopyToUserAddAction() { $dateStart = date('Y-m-d', strtotime($this->_getParam('dateStart'))); $dateEnd = date('Y-m-d', strtotime($this->_getParam('dateEnd'))); $providerIdTo = (int) $this->_getParam('providerIdTo'); $roomIdTo = (int) $this->_getParam('roomIdTo'); $providerIdFrom = (int) $this->_getParam('providerIdFrom'); $roomIdFrom = (int) $this->_getParam('roomIdFrom'); $start = $dateStart . ' 00:00:00'; $end = $dateEnd . ' 23:59:59'; $scheduleEvent = new ScheduleEvent(); $scheduleEvent->providerId = $providerIdTo; $scheduleEvent->roomId = $roomIdTo; $scheduleEvent->start = $start; $scheduleEvent->end = $end; $scheduleEvent->deleteByDateRange(); // remove any existing data $data = 0; $providerId = $providerIdFrom; $roomId = $roomIdFrom; $start = $dateStart . ' 00:00:00'; $end = $dateEnd . ' 23:59:59'; $stmt = $this->_stmtScheduleEvents($providerId, $roomId, $start, $end); while ($event = $stmt->fetch()) { $row = new ScheduleEvent(); $row->populateWithArray($event); $row->scheduleEventId = 0; $row->providerId = $providerIdTo; $row->roomId = $roomIdTo; $row->persist(); $data++; } $json = Zend_Controller_Action_HelperBroker::getStaticHelper('json'); $json->suppressExit = true; $json->direct($data); }