public function getValues($suppressArrayNotation = false) { $values = parent::getValues($suppressArrayNotation); // Return a data structure with headers and data parsed for use $parsed = array('header' => array(), 'data' => array()); $createHeader = function ($rows) { $header = array(); $c = 'A'; for ($i = 0; $i < count($rows[0]); $i++) { $header[] = $c; // Make use of PHP's string incrementing behavior to make // spreadsheet-like column headers // // http://php.net/manual/en/language.operators.increment.php $c++; } return $header; }; if ((bool) $values['has_header']) { $parsed['header'] = array_slice($this->rawArray, 0, 1); $parsed['header'] = $parsed['header'][0]; $parsed['data'] = array_slice($this->rawArray, 1); } else { $parsed['header'] = $createHeader($this->rawArray); $parsed['data'] = $this->rawArray; } $values['parsed'] = $parsed; return $values; }
public function isValid($data) { if (!parent::isValid($data)) { return false; } $startDate = new DateTime($data['start']); $endDate = new DateTime($data['end']); if ($startDate > $endDate) { $this->start->addError($this->getTranslator()->translate('The start date must be on or before the end date.')); $this->end->addError($this->getTranslator()->translate('The end date must be on or after the start date.')); return false; } $facilityGroup = $this->em->find('Tillikum\\Entity\\FacilityGroup\\FacilityGroup', $data['facilitygroup_id']); $qb = $this->em->createQueryBuilder()->select('c.start, c.end')->from('Tillikum\\Entity\\FacilityGroup\\Config\\Config', 'c')->where('c.start <= :proposedEnd')->andWhere('c.end >= :proposedStart')->andWhere('c.facility_group = :facilityGroup')->setParameter('facilityGroup', $facilityGroup)->setParameter('proposedStart', $startDate)->setParameter('proposedEnd', $endDate); if ($this->entity && isset($this->entity->id)) { $qb->andWhere('c != :entity')->setParameter('entity', $this->entity); } if (count($rows = $qb->getQuery()->getResult()) > 0) { foreach ($rows as $row) { $errorMessage = sprintf($this->getTranslator()->translate('An existing configuration from %s to %s overlaps your intended configuration.'), $row['start']->format('Y-m-d'), $row['end']->format('Y-m-d')); $this->start->addError($errorMessage); $this->end->addError($errorMessage); } return false; } return true; }
public function init() { parent::init(); $id = new \Zend_Form_Element_Hidden('id', array('decorators' => array('ViewHelper'))); $through = new \Tillikum_Form_Element_Date('through', array('label' => 'Billed through')); $this->addElements(array($id, $through, $this->createSubmitElement(array('label' => 'Next...')))); }
public function isValid($data) { $dissolvedData = $data; if ($this->isArray()) { $dissolvedData = $this->_dissolveArrayValue($data, $this->getElementsBelongTo()); } $skipDetailedValidation = true; foreach (array('rule_id', 'start', 'end') as $member) { if (!empty($dissolvedData[$member])) { $skipDetailedValidation = false; $this->rule_id->setRequired(true); $this->start->setRequired(true); $this->end->setRequired(true); } } if (!parent::isValid($data)) { return false; } if ($skipDetailedValidation) { return true; } $data = $dissolvedData; $startDate = new DateTime($data['start']); $endDate = new DateTime($data['end']); if ($startDate > $endDate) { $this->start->addError($this->getTranslator()->translate('The start date must be on or before the end date.')); $this->end->addError($this->getTranslator()->translate('The end date must be on or after the start date.')); return false; } return true; }
public function init() { parent::init(); $username = new \Zend_Form_Element_Text('username', array('label' => 'User name', 'required' => true)); $password = new \Zend_Form_Element_Password('password', array('label' => 'Password', 'required' => true)); $this->addElements(array($username, $password, $this->createSubmitElement(array('label' => 'Log in')))); }
public function init() { parent::init(); $identity = new \Zend_Form_Element_Hidden('identity', array('decorators' => array('ViewHelper'))); $isDryRun = new \Zend_Form_Element_Checkbox('is_dry_run', array('attribs' => array('checked' => 'checked'), 'description' => 'The job will run normally, but avoid making' . ' permanent changes to your data.', 'label' => 'Is this a "dry run"?')); $this->setMethod('POST')->addElements(array($identity, $isDryRun, $this->createSubmitElement(array('label' => 'Run job', 'order' => PHP_INT_MAX)))); }
public function init() { parent::init(); $id = new \Zend_Form_Element_Hidden('id', array('decorators' => array('ViewHelper'))); $facilityGroup = new \Zend_Form_Element_Select('facility_group', array('description' => 'Building names listed here are from the latest' . ' building configuration.', 'label' => 'Which building is this facility a member of?', 'multiOptions' => array())); $this->addElements(array($id, $facilityGroup, $this->createSubmitElement(array('label' => 'Save')))); }
public function init() { parent::init(); $typeId = new \Zend_Form_Element_Select('type_id', array('label' => 'Email type', 'multiOptions' => array(), 'required' => true)); $value = new \Zend_Form_Element_Text('value', array('filters' => array('StringTrim'), 'label' => 'Email address', 'required' => true, 'validators' => array('EmailAddress'))); $isPrimary = new \Zend_Form_Element_Checkbox('is_primary', array('label' => 'Is this the person’s primary email address?')); $this->addElements(array($typeId, $value, $isPrimary)); }
public function init() { parent::init(); $id = new \Zend_Form_Element_Text('id', array('label' => 'Tag ID', 'required' => true)); $name = new \Zend_Form_Element_Text('name', array('label' => 'Tag name', 'required' => true)); $isActive = new \Zend_Form_Element_Checkbox('is_active', array('description' => 'Deactivating tags will hide them from menus' . ' around the application, but do not affect' . ' users who are currently tagged.', 'label' => 'Is this tag active?', 'value' => true)); $warning = new \Zend_Form_Element_Text('warning', array('description' => 'The text entered here, if any, will appear' . ' when a person is tagged with this tag.', 'label' => 'Warning text')); $this->addElements(array($id, $name, $isActive, $warning, $this->createSubmitElement(array('label' => 'Save')))); }
public function init() { parent::init(); $name = new Zend_Form_Element_Text('name', array('label' => 'Name')); $capacity = new Zend_Form_Element_Text('capacity', array('label' => 'Capacity', 'validators' => array(new Zend_Validate_Int()))); $type = new Zend_Form_Element_Select('ftype', array('label' => 'Facility Type', 'required' => true, 'multiOptions' => array('building' => 'Building', 'community' => 'Community', 'floor' => 'Floor', 'homestay' => 'Homestay Family', 'room' => 'Room', 'suite' => 'Suite', 'wing' => 'Wing'))); $submit = new Tillikum_Form_Element_Submit('submit'); $this->addElements(array($name, $capacity, $type, $submit)); }
public function init() { parent::init(); $input = new Zend_Form_Element_Textarea('textinput', array('label' => 'Tab-separated input', 'description' => 'This input is generated automatically if you perform a copy-paste operation from most spreadsheet software.', 'required' => true)); $is_include_header = new Zend_Form_Element_Checkbox('is_include_header', array('label' => 'Does the spreadsheet include column headers?')); $submit = new Tillikum_Form_Element_Submit('submit'); $submit->setLabel('Next…'); $this->setMethod('POST')->addElements(array($input, $is_include_header, $submit)); }
public function init() { parent::init(); $ruleId = new \Zend_Form_Element_Select('rule_id', array('label' => 'Rule', 'required' => true)); $currency = new \Zend_Form_Element_Hidden('currency', array('decorators' => array('ViewHelper'), 'required' => true, 'value' => 'USD')); $amount = new \Tillikum_Form_Element_Number('amount', array('attribs' => array('min' => '-9999.99', 'max' => '9999.99', 'step' => '0.01', 'title' => 'Value must be precise to no more than 2' . ' decimal places'), 'label' => 'Amount', 'required' => true, 'validators' => array('Float', new \Zend_Validate_Between(-9999.99, 9999.99)))); $effective = new \Tillikum_Form_Element_Date('effective', array('label' => 'Effective date', 'required' => true, 'value' => date('Y-m-d'))); $description = new \Zend_Form_Element_Textarea('description', array('attribs' => array('class' => 'short'), 'label' => 'Description', 'required' => true, 'filters' => array('StringTrim'))); $this->setMethod('POST')->addElements(array($ruleId, $currency, $amount, $effective, $description, $this->createSubmitElement(array('label' => 'Create')))); }
public function init() { parent::init(); $personId = new \Zend_Form_Element_Hidden('person_id', array('decorators' => array('ViewHelper'), 'required' => true)); $contractId = new \Zend_Form_Element_Select('contract_id', array('label' => 'Contract', 'required' => true)); $signedAt = new \Tillikum_Form_Element_Date('signed_at', array('description' => 'Determines age at time of signing. Leave blank for today’s date.', 'label' => 'When was the contract originally signed?')); $isCosigned = new \Zend_Form_Element_Checkbox('is_cosigned', array('label' => 'Is the contract cosigned?')); $isCancelled = new \Zend_Form_Element_Checkbox('is_cancelled', array('label' => 'Is the contract cancelled?')); $this->addElements(array($personId, $contractId, $signedAt, $isCosigned, $isCancelled, $this->createSubmitElement(array('label' => 'Sign')))); }
public function init() { parent::init(); $strategy = new \Zend_Form_Element_Select('strategy', array('label' => 'Strategy', 'multiOptions' => array(), 'required' => true)); $code = new \Zend_Form_Element_Text('code', array('required' => true, 'label' => 'Code', 'filters' => array('StringTrim'))); $description = new \Zend_Form_Element_Text('description', array('label' => 'Description', 'filters' => array('StringTrim'))); $start = new \Tillikum_Form_Element_Date('start', array('label' => 'Start date', 'required' => true)); $end = new \Tillikum_Form_Element_Date('end', array('label' => 'End date', 'required' => true)); $this->addElements(array($strategy, $code, $description, $start, $end)); }
public function init() { parent::init(); $id = new \Zend_Form_Element_Hidden('id', array('decorators' => array('ViewHelper'))); $mealplanId = new \Zend_Form_Element_Select('mealplan_id', array('label' => 'Meal plan', 'multiOptions' => array(), 'required' => true)); $start = new \Tillikum_Form_Element_Date('start', array('label' => 'Start date', 'required' => true)); $end = new \Tillikum_Form_Element_Date('end', array('label' => 'End date', 'required' => true)); $note = new \Zend_Form_Element_Textarea('note', array('attribs' => array('class' => 'short'), 'label' => 'Notes')); $this->addElements(array($id, $mealplanId, $start, $end, $note, $this->createSubmitElement(array('label' => 'Next...')))); }
public function init() { parent::init(); $date = new \Tillikum_Form_Element_Date('date', array('label' => 'Facility configuration date', 'required' => true)); $facilityGroupIds = new \Zend_Form_Element_Multiselect('facilitygroup_ids', array('label' => 'Facility group', 'multiOptions' => array())); $gender = new \Zend_Form_Element_Text('gender', array('label' => 'Gender')); $capacity = new \Tillikum_Form_Element_Number('capacity', array('attribs' => array('min' => 0), 'label' => 'Capacity')); $availableSpace = new \Tillikum_Form_Element_Number('available_space', array('attribs' => array('min' => 0), 'label' => 'Spaces available (at minimum)')); $tags = new \Zend_Form_Element_Multiselect('tags', array('label' => 'Tags', 'multiOptions' => array())); $this->addElements(array($date, $facilityGroupIds, $gender, $capacity, $availableSpace, $tags, $this->createSubmitElement(array('label' => 'Search')))); }
public function isValid($data) { if (!parent::isValid($data)) { return false; } $startDate = new DateTime($data['start']); $endDate = new DateTime($data['end']); if ($startDate > $endDate) { $this->start->addError($this->getTranslator()->translate('The start date must be on or before the end date.')); $this->end->addError($this->getTranslator()->translate('The end date must be on or after the start date.')); return false; } $facility = $this->em->find('Tillikum\\Entity\\Facility\\Facility', $data['facility_id']); $holdQueryBuilder = $this->em->createQueryBuilder()->select('h')->from('Tillikum\\Entity\\Facility\\Hold\\Hold', 'h')->where('h.start <= :proposedEnd')->andWhere('h.end >= :proposedStart')->andWhere('h.facility = :facility')->orderBy('h.start')->setParameter('facility', $facility)->setParameter('proposedStart', $startDate)->setParameter('proposedEnd', $endDate); if ($this->entity && isset($this->entity->id)) { $holdQueryBuilder->andWhere('h != :entity')->setParameter('entity', $this->entity); } $holds = $holdQueryBuilder->getQuery()->getResult(); $bookings = $this->em->createQueryBuilder()->select('b')->from('Tillikum\\Entity\\Booking\\Facility\\Facility', 'b')->where('b.start <= :proposedEnd')->andWhere('b.end >= :proposedStart')->andWhere('b.facility = :facility')->orderBy('b.start')->setParameter('facility', $facility)->setParameter('proposedStart', $startDate)->setParameter('proposedEnd', $endDate)->getQuery()->getResult(); $configs = $this->em->createQueryBuilder()->select('c')->from('Tillikum\\Entity\\Facility\\Config\\Config', 'c')->where('c.facility = :facility')->orderBy('c.start')->setParameter('facility', $facility)->getQuery()->getResult(); if (count($holds) > 0) { foreach ($holds as $hold) { $errorMessage = sprintf($this->getTranslator()->translate('An existing hold from %s to %s overlaps your intended hold.'), $hold->start->format('Y-m-d'), $hold->end->format('Y-m-d')); $this->start->addError($errorMessage); $this->end->addError($errorMessage); } return false; } $occupancyInputs = array(new OccupancyInput($startDate, $data['space'] * -1, sprintf('start of the hold you specified from %s to %s', $startDate->format('Y-m-d'), $endDate->format('Y-m-d'))), new OccupancyInput(date_modify(clone $endDate, '+1 day'), $data['space'], sprintf('end of the hold you specified from %s to %s', $startDate->format('Y-m-d'), $endDate->format('Y-m-d')))); foreach ($bookings as $booking) { $occupancyInputs[] = new OccupancyInput($booking->start, -1, sprintf('start of a booking from %s to %s', $booking->start->format('Y-m-d'), $booking->end->format('Y-m-d'))); $occupancyInputs[] = new OccupancyInput(date_modify(clone $booking->end, '+1 day'), 1, sprintf('end of a booking from %s to %s', $booking->start->format('Y-m-d'), $booking->end->format('Y-m-d'))); } $currentConfigSpace = 0; foreach ($configs as $config) { $occupancyInputs[] = new OccupancyInput($config->start, $config->capacity - $currentConfigSpace, sprintf('start of a facility configuration from %s to %s', $config->start->format('Y-m-d'), $config->end->format('Y-m-d'))); $currentConfigSpace = $config->capacity; } foreach ($holds as $hold) { $occupancyInputs[] = new OccupancyInput($hold->start, $hold->space * -1, sprintf('start of a hold from %s to %s', $hold->start->format('Y-m-d'), $hold->end->format('Y-m-d'))); $occupancyInputs[] = new OccupancyInput(date_modify(clone $hold->end, '+1 day'), $hold->space, sprintf('end of a hold from %s to %s', $hold->start->format('Y-m-d'), $hold->end->format('Y-m-d'))); } $occupancyEngine = new OccupancyEngine($occupancyInputs); $occupancyResult = $occupancyEngine->run(); if (!$occupancyResult->getIsSuccess()) { $errorMessage = sprintf($this->getTranslator()->translate('There is no available space in this facility to add another ' . 'hold during the specified time period. The problem occurred ' . 'at the %s.'), $occupancyResult->getCulprit()->getDescription()); $this->start->addError($errorMessage); $this->end->addError($errorMessage); return false; } return true; }
public function init() { parent::init(); $id = new \Zend_Form_Element_Hidden('id', array('decorators' => array('ViewHelper'))); $givenName = new \Zend_Form_Element_Text('given_name', array('filters' => array('StringTrim'), 'label' => 'Given name')); $middleName = new \Zend_Form_Element_Text('middle_name', array('filters' => array('StringTrim'), 'label' => 'Middle name')); $familyName = new \Zend_Form_Element_Text('family_name', array('filters' => array('StringTrim'), 'label' => 'Family name')); $displayName = new \Zend_Form_Element_Text('display_name', array('description' => 'This should be used if the person’s name' . ' should not be formatted' . ' “family, given middle”.', 'filters' => array('StringTrim'), 'label' => 'Display name')); $gender = new \Zend_Form_Element_Text('gender', array('filters' => array('StringTrim'), 'label' => 'Gender')); $tags = new \Zend_Form_Element_Multiselect('tags', array('label' => 'Tags', 'multiOptions' => array())); $note = new \Zend_Form_Element_Textarea('note', array('attribs' => array('class' => 'short'), 'filters' => array('StringTrim'), 'label' => 'Notes')); $this->addElements(array($id, $givenName, $middleName, $familyName, $displayName, $gender, $tags, $note, $this->createSubmitElement(array('label' => 'Save')))); }
public function isValid($data) { $isValid = parent::isValid($data); if (!$isValid) { return $isValid; } foreach ($this->requiredElements as $element) { if (!in_array($element, $data['map'])) { $this->getSubForm('map')->addError("Missing required element ({$element})"); $isValid = false; } } return $isValid; }
public function init() { parent::init(); $name = new \Tillikum_Form_Element_Search('name', array('attribs' => array('placeholder' => 'Type the name of a facility'), 'description' => 'A facility is anything that can be booked,' . ' such as a room.', 'label' => 'Facility name')); $this->addElements(array($name)); }
public function checkMappedData($map, $rows) { $personGateway = new \TillikumX\Model\PersonGateway(); $identity = \Zend_Auth::getInstance()->hasIdentity() ? Zend_Auth::getInstance()->getIdentity() : '_system'; $rowNum = 1; $this->data = $rangesByFacility = array(); foreach ($rows as $row) { $person = $personGateway->fetch($row[$map['id']]); if (null === $person) { return array('result' => false, 'reason' => sprintf('The person with ID %s does not exist.', $row[$map['id']]), 'row' => $rowNum); } $bookingInput = array('facility' => $row[$map['booking_facility']], 'start' => $row[$map['booking_start']], 'end' => $row[$map['booking_end']]); $rates = array(); for ($i = 0; $i < 3; $i++) { $mapOffset = $i + 1; if (!isset($map["booking_rate{$mapOffset}_id"]) || !isset($row[$map["booking_rate{$mapOffset}_id"]])) { continue; } $rate = array('rate' => $row[$map["booking_rate{$mapOffset}_id"]]); if (isset($map["booking_rate{$mapOffset}_start"])) { $rate['start'] = $row[$map["booking_rate{$mapOffset}_start"]]; } if (isset($map["booking_rate{$mapOffset}_end"])) { $rate['end'] = $row[$map["booking_rate{$mapOffset}_end"]]; } $bookingInput['rates'][] = $rate; } if (isset($map['booking_billing_effective'])) { $bookingInput['billing_effective'] = $row[$map['booking_billing_effective']]; } if (isset($map['booking_billing_through'])) { $bookingInput['billing_through'] = $row[$map['booking_billing_through']]; } $mealplanInput = array(); if (isset($map['mealplan_plan'])) { $mealplanInput['plan'] = $row[$map['mealplan_plan']]; } if (isset($map['mealplan_start'])) { $mealplanInput['start'] = $row[$map['mealplan_start']]; } if (isset($map['mealplan_end'])) { $mealplanInput['end'] = $row[$map['mealplan_end']]; } for ($i = 0; $i < 1; $i++) { $mapOffset = $i + 1; if (!isset($map["mealplan_rate{$mapOffset}_id"]) || !isset($row[$map["mealplan_rate{$mapOffset}_id"]])) { continue; } $rate = array('rate' => $row[$map["mealplan_rate{$mapOffset}_id"]]); if (isset($map["mealplan_rate{$mapOffset}_start"])) { $rate['start'] = $row[$map["mealplan_rate{$mapOffset}_start"]]; } if (isset($map["mealplan_rate{$mapOffset}_end"])) { $rate['end'] = $row[$map["mealplan_rate{$mapOffset}_end"]]; } $mealplanInput['rates'][] = $rate; } if (isset($map['mealplan_billing_effective'])) { $mealplanInput['billing_effective'] = $row[$map['mealplan_billing_effective']]; } if (isset($map['mealplan_billing_through'])) { $mealplanInput['billing_through'] = $row[$map['mealplan_billing_through']]; } // Set up our form $bookingForm = new \Tillikum_Form(); $bookingForm->setElementsBelongTo('booking'); $facilitySubForm = new \Tillikum\Form\Booking\Facility(); $facilitySubForm->setElementsBelongTo('facility'); $facilitySubForm->setPerson($person); $bookingForm->addSubForm($facilitySubForm, 'facility'); $mealplanSubForm = new \Tillikum\Form\Booking\Mealplan(); $mealplanSubForm->setElementsBelongTo('mealplan'); $mealplanSubForm->setPerson($person); $mealplanSubForm->plan->setRequired(false); $mealplanSubForm->start->setRequired(false); $mealplanSubForm->end->setRequired(false); $bookingForm->addSubForm($mealplanSubForm, 'mealplan'); if (array_key_exists($bookingInput['facility'], $rangesByFacility)) { foreach ($rangesByFacility[$bookingInput['facility']] as $range) { $facilitySubForm->addExtraDateRange($range); } } $massInput = array('facility' => $bookingInput, 'mealplan' => $mealplanInput); if (!$bookingForm->isValid($massInput)) { $it = new RecursiveArrayIterator($bookingForm->getMessages()); $itit = new RecursiveIteratorIterator($it); foreach ($itit as $message) { return array('result' => false, 'reason' => $message, 'row' => $rowNum); } } $values = $bookingForm->getValues(true); $facilityBooking = $values['facility']['booking']; $facilityBooking->created_by = $identity; $facilityBooking->updated_by = $identity; $ffnHelper = Zend_Controller_Action_HelperBroker::getStaticHelper('FullFacilityName'); $view = Zend_Controller_Action_HelperBroker::getStaticHelper('ViewRenderer')->view; $facilityNameArray = $ffnHelper->fullFacilityName($facilityBooking->facility, null, $facilityBooking->start); if ($facilityBooking->billing) { $bookingCharges = $facilityBooking->processCharges($view->fullFacilityName($facilityNameArray)); foreach ($bookingCharges as $charge) { $charge->created_by = $identity; $this->data[$person->id]['charges'][] = $charge; } } $this->data[$person->id]['bookings'][] = $facilityBooking; $mealplanBooking = $values['mealplan']['booking']; if (null !== $mealplanBooking) { $mealplanBooking->created_by = $identity; $mealplanBooking->updated_by = $identity; if ($mealplanBooking->billing) { $mealplanCharges = $mealplanBooking->processCharges($mealplanBooking->plan); foreach ($mealplanCharges as $charge) { $charge->created_by = $identity; $this->data[$person->id]['charges'][] = $charge; } } $this->data[$person->id]['mealplans'][] = $mealplanBooking; } $rangesByFacility[$bookingInput['facility']][] = new \Vo\DateRange($facilityBooking->start, $facilityBooking->end); } return array('result' => true); }
public function init() { parent::init(); $format = new \Zend_Form_Element_Select('format', array('label' => 'In which format do you want to see the report data?', 'multiOptions' => array('csv' => 'CSV (download a file, open with spreadsheet software)', 'html' => 'HTML (view report in a table in your browser)'), 'required' => true)); $this->setMethod('GET')->addElements(array($format, $this->createSubmitElement(array('label' => 'Generate report', 'order' => PHP_INT_MAX)))); }
public static function setDefaultOptions(array $options) { self::$defaultOptions = $options; }
public function isValid($data) { if (!parent::isValid($data)) { return false; } $startDate = new DateTime($data['start']); $endDate = new DateTime($data['end']); if ($startDate > $endDate) { $this->start->addError($this->getTranslator()->translate('The start date must be on or before the end date.')); $this->end->addError($this->getTranslator()->translate('The end date must be on or after the start date.')); return false; } $configRange = new DateRange($startDate, $endDate); $facility = $this->em->find('Tillikum\\Entity\\Facility\\Facility', $data['facility_id']); $bookings = $this->em->createQueryBuilder()->select('b')->from('Tillikum\\Entity\\Booking\\Facility\\Facility', 'b')->where('b.start <= :proposedEnd')->andWhere('b.end >= :proposedStart')->andWhere('b.facility = :facility')->orderBy('b.start')->setParameter('facility', $facility)->setParameter('proposedStart', $configRange->getStart())->setParameter('proposedEnd', $configRange->getEnd())->getQuery()->getResult(); $qb = $this->em->createQueryBuilder()->select('c')->from('Tillikum\\Entity\\Facility\\Config\\Config', 'c')->where('c.facility = :facility')->orderBy('c.start')->setParameter('facility', $this->entity->facility); if ($this->entity && isset($this->entity->id)) { $qb->andWhere('c != :entity')->setParameter('entity', $this->entity); } $configs = $qb->getQuery()->getResult(); $overlappingQueryBuilder = $this->em->createQueryBuilder()->select('c')->from('Tillikum\\Entity\\Facility\\Config\\Config', 'c')->where('c.start <= :proposedStart')->andWhere('c.end >= :proposedEnd')->andWhere('c.facility = :facility')->setParameter('proposedStart', $configRange->getStart())->setParameter('proposedEnd', $configRange->getEnd())->setParameter('facility', $this->entity->facility); if ($this->entity && isset($this->entity->id)) { $overlappingQueryBuilder->andWhere('c != :entity')->setParameter('entity', $this->entity); } $overlappingConfigs = $overlappingQueryBuilder->getQuery()->getResult(); $holds = $this->em->createQueryBuilder()->select('h')->from('Tillikum\\Entity\\Facility\\Hold\\Hold', 'h')->where('h.start <= :proposedEnd')->andWhere('h.end >= :proposedStart')->andWhere('h.facility = :facility')->orderBy('h.start')->setParameter('facility', $facility)->setParameter('proposedStart', $configRange->getStart())->setParameter('proposedEnd', $configRange->getEnd())->getQuery()->getResult(); if (count($overlappingConfigs) > 0) { foreach ($overlappingConfigs as $config) { $errorMessage = sprintf($this->getTranslator()->translate('An existing configuration from %s to %s overlaps your intended configuration.'), $config->start->format('Y-m-d'), $config->end->format('Y-m-d')); $this->start->addError($errorMessage); $this->end->addError($errorMessage); } return false; } $occupancyInputs = array(new OccupancyInput($configRange->getStart(), $data['capacity'], sprintf('start of the facility configuration you specified from %s to %s', $configRange->getStart()->format('Y-m-d'), $configRange->getEnd()->format('Y-m-d')))); foreach ($configs as $config) { $occupancyInputs[] = new OccupancyInput($config->start, $config->capacity, sprintf('start of a facility configuration from %s to %s', $config->start->format('Y-m-d'), $config->end->format('Y-m-d'))); if (!empty($data['suite'])) { $suiteConfigs = $this->em->createQueryBuilder()->select('c')->from('Tillikum\\Entity\\Facility\\Config\\Room\\Room', 'c')->join('c.suite', 's')->where('c.start <= :proposedEnd')->andWhere('c.end >= :proposedStart')->andWhere('s.id = :suiteId')->setParameter('proposedStart', $configRange->getStart())->setParameter('proposedEnd', $configRange->getEnd())->setParameter('suiteId', $data['suite'])->getQuery()->getResult(); foreach ($suiteConfigs as $suiteConfig) { if (!empty($suiteConfig->gender)) { $suiteGenderSpec = isset($suiteGenderSpec) ? $suiteGenderSpec->andSpec(new GenderMatchSpecification($suiteConfig->gender)) : new GenderMatchSpecification($suiteConfig->gender); } } } } // We need to re-sort since the user-specified input will not be sorted usort($occupancyInputs, function ($a, $b) { if ($a->getDate() == $b->getDate()) { return 0; } return $a->getDate() < $b->getDate() ? -1 : 1; }); // Actually calculate moments after re-sorting $currentConfigSpace = 0; foreach ($occupancyInputs as $idx => $input) { $oldValue = $input->getValue(); $occupancyInputs[$idx] = new OccupancyInput($input->getDate(), $input->getValue() - $currentConfigSpace, $input->getDescription()); $currentConfigSpace = $oldValue; } foreach ($bookings as $booking) { $occupancyInputs[] = new OccupancyInput($booking->start, -1, sprintf('start of a booking from %s to %s', $booking->start->format('Y-m-d'), $booking->end->format('Y-m-d'))); $occupancyInputs[] = new OccupancyInput(date_modify(clone $booking->end, '+1 day'), 1, sprintf('end of a booking from %s to %s', $booking->start->format('Y-m-d'), $booking->end->format('Y-m-d'))); if (!empty($booking->person->gender)) { $bookingGenderSpec = isset($bookingGenderSpec) ? $bookingGenderSpec->andSpec(new GenderMatchSpecification($booking->person->gender)) : new GenderMatchSpecification($booking->person->gender); } } foreach ($holds as $hold) { $occupancyInputs[] = new OccupancyInput($hold->start, $hold->space * -1, sprintf('start of a hold from %s to %s', $hold->start->format('Y-m-d'), $hold->end->format('Y-m-d'))); $occupancyInputs[] = new OccupancyInput(date_modify(clone $hold->end, '+1 day'), $hold->space, sprintf('end of a hold from %s to %s', $hold->start->format('Y-m-d'), $hold->end->format('Y-m-d'))); if (!empty($hold->gender)) { $holdGenderSpec = isset($holdGenderSpec) ? $holdGenderSpec->andSpec(new GenderMatchSpecification($hold->gender)) : new GenderMatchSpecification($hold->gender); } } $occupancyEngine = new OccupancyEngine($occupancyInputs); $occupancyResult = $occupancyEngine->run(); if (!$occupancyResult->getIsSuccess()) { $this->capacity->addError(sprintf($this->getTranslator()->translate('There are too many claims on space in this facility ' . 'to change the capacity of this configuration. The ' . 'problem occurred at the %s.'), $occupancyResult->getCulprit()->getDescription())); return false; } if (isset($holdGenderSpec) && !$holdGenderSpec->isSatisfiedBy($data['gender'])) { $this->addWarning(sprintf($this->getTranslator()->translate('The desired configuration gender does not meet the' . ' gender requirements of an overlapping facility hold.'))); } if (isset($bookingGenderSpec) && !$bookingGenderSpec->isSatisfiedBy($data['gender'])) { $this->addWarning(sprintf($this->getTranslator()->translate('The desired configuration gender does not meet the' . ' gender requirements of an overlapping booking.'))); } if (isset($suiteGenderSpec) && !$suiteGenderSpec->isSatisfiedBy($data['gender'])) { $this->addWarning(sprintf($this->getTranslator()->translate('The desired configuration gender does not meet the' . ' gender requirements of an overlapping booking in a' . ' related suite.'))); } return true; }
public function init() { parent::init(); $search = new \Tillikum_Form_Element_Search('search', array('attribs' => array('placeholder' => 'Person’s name or identifier'), 'label' => 'Search')); $this->setMethod('GET')->addElements(array($search, $this->createSubmitElement(array('label' => 'Search')))); }
public function init() { parent::init(); $description = new \Zend_Form_Element_Text('description', array('label' => 'Description', 'required' => true)); $this->setMethod('POST')->addElements(array($description, $this->createSubmitElement(array('label' => 'Save', 'order' => PHP_INT_MAX)))); }
public function init() { parent::init(); $name = new \Tillikum_Form_Element_Search('name', array('attribs' => array('placeholder' => 'Type the name of a facility group'), 'description' => 'A facility group is a container for facilities,' . ' such as a building.', 'label' => 'Find a facility group')); $this->addElements(array($name)); }
public function init() { parent::init(); $type = new \Zend_Form_Element_Select('type', array('label' => 'Which type of facility configuration do you want to add?', 'multiOptions' => self::$typeOptions, 'required' => true)); $this->addElements(array($type, $this->createSubmitElement(array('label' => 'Next...')))); }
public function isValid($data) { if (!parent::isValid($data)) { return false; } if ($this->isArray()) { $data = $this->_dissolveArrayValue($data, $this->getElementsBelongTo()); } $startDate = new DateTime($data['start']); $endDate = new DateTime($data['end']); if ($startDate > $endDate) { $this->start->addError($this->getTranslator()->translate('The start date must be on or before the end date.')); $this->end->addError($this->getTranslator()->translate('The end date must be on or after the start date.')); return false; } $bookingRange = new DateRange($startDate, $endDate); $bookingFacility = $this->em->find('Tillikum\\Entity\\Facility\\Facility', $data['facility_id']); $person = $this->booking->person; $bookings = $this->em->createQueryBuilder()->select('b')->from('Tillikum\\Entity\\Booking\\Facility\\Facility', 'b')->where('b.start <= :proposedEnd')->andWhere('b.end >= :proposedStart')->andWhere('b.facility = :facility')->andWhere('b.person != :person')->orderBy('b.start')->setParameter('facility', $bookingFacility)->setParameter('person', $person)->setParameter('proposedStart', $bookingRange->getStart())->setParameter('proposedEnd', $bookingRange->getEnd())->getQuery()->getResult(); $configs = $this->em->createQueryBuilder()->select('c')->from('Tillikum\\Entity\\Facility\\Config\\Config', 'c')->where('c.facility = :facility')->orderBy('c.start')->setParameter('facility', $bookingFacility)->getQuery()->getResult(); $holds = $this->em->createQueryBuilder()->select('h')->from('Tillikum\\Entity\\Facility\\Hold\\Hold', 'h')->where('h.start <= :proposedEnd')->andWhere('h.end >= :proposedStart')->andWhere('h.facility = :facility')->orderBy('h.start')->setParameter('facility', $bookingFacility)->setParameter('proposedStart', $bookingRange->getStart())->setParameter('proposedEnd', $bookingRange->getEnd())->getQuery()->getResult(); $occupancyInputs = array(new OccupancyInput($bookingRange->getStart(), -1, sprintf('start of the booking range you specified from %s to %s', $bookingRange->getStart()->format('Y-m-d'), $bookingRange->getEnd()->format('Y-m-d'))), new OccupancyInput(date_modify(clone $bookingRange->getEnd(), '+1 day'), 1, sprintf('end of the booking range you specified from %s to %s', $bookingRange->getStart()->format('Y-m-d'), $bookingRange->getEnd()->format('Y-m-d')))); foreach ($bookings as $booking) { $occupancyInputs[] = new OccupancyInput($booking->start, -1, sprintf('start of a booking from %s to %s', $booking->start->format('Y-m-d'), $booking->end->format('Y-m-d'))); $occupancyInputs[] = new OccupancyInput(date_modify(clone $booking->end, '+1 day'), 1, sprintf('end of a booking from %s to %s', $booking->start->format('Y-m-d'), $booking->end->format('Y-m-d'))); if (!empty($booking->person->gender)) { $bookingGenderSpec = isset($bookingGenderSpec) ? $bookingGenderSpec->andSpec(new GenderMatchSpecification($booking->person->gender)) : new GenderMatchSpecification($booking->person->gender); } } $currentConfigSpace = 0; foreach ($configs as $config) { $occupancyInputs[] = new OccupancyInput($config->start, $config->capacity - $currentConfigSpace, sprintf('start of a facility configuration from %s to %s', $config->start->format('Y-m-d'), $config->end->format('Y-m-d'))); $currentConfigSpace = $config->capacity; if (!empty($config->gender)) { $facilityGenderSpec = isset($facilityGenderSpec) ? $facilityGenderSpec->andSpec(new GenderMatchSpecification($config->gender)) : new GenderMatchSpecification($config->gender); } if (!empty($config->suite)) { $suiteConfigs = $this->em->createQueryBuilder()->select('c')->from('Tillikum\\Entity\\Facility\\Config\\Room\\Room', 'c')->where('c.start <= :proposedEnd')->andWhere('c.end >= :proposedStart')->andWhere('c.suite = :suite')->setParameter('proposedStart', $bookingRange->getStart())->setParameter('proposedEnd', $bookingRange->getEnd())->setParameter('suite', $config->suite)->getQuery()->getResult(); foreach ($suiteConfigs as $suiteConfig) { if (!empty($suiteConfig->gender)) { $suiteGenderSpec = isset($suiteGenderSpec) ? $suiteGenderSpec->andSpec(new GenderMatchSpecification($suiteConfig->gender)) : new GenderMatchSpecification($suiteConfig->gender); } } } } foreach ($holds as $hold) { $occupancyInputs[] = new OccupancyInput($hold->start, $hold->space * -1, sprintf('start of a hold from %s to %s', $hold->start->format('Y-m-d'), $hold->end->format('Y-m-d'))); $occupancyInputs[] = new OccupancyInput(date_modify(clone $hold->end, '+1 day'), $hold->space, sprintf('end of a hold from %s to %s', $hold->start->format('Y-m-d'), $hold->end->format('Y-m-d'))); if (!empty($hold->gender)) { $holdGenderSpec = isset($holdGenderSpec) ? $holdGenderSpec->andSpec(new GenderMatchSpecification($hold->gender)) : new GenderMatchSpecification($hold->gender); } } $occupancyEngine = new OccupancyEngine($occupancyInputs); $occupancyResult = $occupancyEngine->run(); if (!$occupancyResult->getIsSuccess()) { $this->facility_name->addError(sprintf($this->getTranslator()->translate('There is no available space in this facility to book another' . ' resident during the specified time period. The problem' . ' occurred at the %s.'), $occupancyResult->getCulprit()->getDescription())); return false; } if (isset($bookingGenderSpec) && !$bookingGenderSpec->isSatisfiedBy($person->gender)) { $this->addWarning(sprintf($this->getTranslator()->translate('The person you are booking with gender %s did not meet' . ' the gender requirements of the other people booked' . ' to this facility for the desired time period.'), $person->gender)); } if (isset($facilityGenderSpec) && !$facilityGenderSpec->isSatisfiedBy($person->gender)) { $this->addWarning(sprintf($this->getTranslator()->translate('The person you are booking with gender %s did not meet' . ' the gender requirements of the configurations for this' . ' facility for the desired time period.'), $person->gender)); } if (isset($holdGenderSpec) && !$holdGenderSpec->isSatisfiedBy($person->gender)) { $this->addWarning(sprintf($this->getTranslator()->translate('The person you are booking with gender %s did not meet' . ' the gender requirements of the holds on this facility' . ' for the desired time period.'), $person->gender)); } if (isset($suiteGenderSpec) && !$suiteGenderSpec->isSatisfiedBy($person->gender)) { $this->addWarning(sprintf($this->getTranslator()->translate('The person you are booking with gender %s did not meet' . ' the gender requirements of the other people booked to' . ' this suite for the specified time period.'), $person->gender)); } return true; }
public function init() { $options = $this->getOptions(); \Tillikum_Form::setDefaultOptions($options); return $this; }