public function loadModel($id) { $Model = Venue::model()->findByPk($id); if ($Model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $Model; }
?> <tr> <td><?php print $row->and_choice ? 'and' : 'or'; ?> </td> <td> <?php print $row->bool_choice ? $Question->positiveLang : $Question->negativeLang; ?> <?php print $Question->question; switch ($Question->option_id) { case QueryQuestion::OPTION_VENUE: if (is_null($Venues)) { $Venues = Venue::model()->findAll(array('condition' => 'active = 1', 'index' => 'id')); } print ' ' . $Venues[$row->query_option]; break; case QueryQuestion::OPTION_ORGANISATION: if (is_null($Organisations)) { $Organisations = Organisation::model()->findAll(array('condition' => 'active = 1', 'index' => 'id')); } print ' ' . $Organisations[$row->query_option]->title; break; case QueryQuestion::OPTION_INVITE: if (is_null($InviteQueries)) { $InviteQueries = Query::model()->findAll(array('condition' => 'invite = 1', 'index' => 'id')); } print ' ' . $InviteQueries[$row->query_option]->name; break;
<span> <?php switch ($Question->option_id) { // Venue case QueryQuestion::OPTION_VENUE: $Venue = Venue::model()->findByPk($query_option); print $Venue->title; break; // Organisation // Organisation case QueryQuestion::OPTION_ORGANISATION: $Organisation = Organisation::model()->findByPk($query_option); print $Organisation->title; break; // Invite // Invite case QueryQuestion::OPTION_INVITE: $InviteQuery = Query::model()->findByPk($query_option); print $InviteQuery->name; break; // Culture Segment // Culture Segment case QueryQuestion::OPTION_CS: $CultureSegment = CultureSegment::model()->findByPk($query_option); print $CultureSegment->name; break; // Artforms // Artforms case QueryQuestion::OPTION_ARTFORM: $Artforms = Artform::model()->findByPk($query_option); print $Artform->title;
<select class="form-control query_option" name="<?php print $rowNumber ? 'current' : 'new'; ?> [query_option]<?php print $rowNumber ? '[' . $rowNumber . ']' : ''; ?> " > <?php //we need to add the venues from database if the option chosen is VENUE switch ($Question->option_id) { // Venue case QueryQuestion::OPTION_VENUE: ?> <option>Select Venue...</option> <?php $Venues = Venue::model()->findAll(array('condition' => 'active = 1', 'order' => 'title ASC')); foreach ($Venues as $Venue) { ?> <option data-id="<?php echo $Venue->id; ?> " value="<?php echo $Venue->id; ?> " <?php if ($query_option == '' . $Venue->id) { echo 'selected="selected"'; } ?> ><?php echo $Venue->title;
<div class="form-group"> <?php echo $form->labelEx($Venue, 'active', array()); ?> <?php echo $form->dropDownList($Venue, 'active', array(1 => 'Active', 0 => 'Archived'), array('class' => 'form-control')); ?> </div> <div class="form-group"> <?php echo $form->labelEx($Venue, 'organisation_id', array()); ?> <?php $options = Venue::model()->organisationOptions(); ?> <?php echo $form->dropDownList($Venue, 'organisation_id', $options, array('class' => 'form-control')); ?> </div> <div class="form-actions"> <?php echo CHtml::submitButton($Venue->isNewRecord ? 'Create' : 'Save', array('class' => 'btn')); ?> </div> </div>
public function actionStepSix() { $this->inAccession = true; $Accession = $this->getAccessionRecord(); $this->checkStep($Accession, 6); $this->pageTitle = 'Visited Venues | Step Six | Accession'; $Venues = Venue::model()->findAll(); if (isset($_POST['submit-venues'])) { if (sizeof($_POST['Venues']) < sizeof($Venues)) { $Accession->addError('id', 'You must answer all the questions'); } else { foreach ($_POST['Venues'] as $venue_id => $visited) { // Record already exists? $Contact2Venue = Contact2Venue::model()->find(array('condition' => 'accession_id = :accession_id AND venue_id = :venue_id', 'params' => array(':accession_id' => $Accession->id, ':venue_id' => $venue_id))); if (!is_null($Contact2Venue)) { // Update the exisiting record $Contact2Venue->visited = $visited; $Contact2Venue->save(true, array('visited')); } else { $Contact2Venue = new Contact2Venue(); $Contact2Venue->accession_id = $Accession->id; $Contact2Venue->venue_id = $venue_id; $Contact2Venue->visited = $visited; $Contact2Venue->save(); } } $this->updateStep($Accession, 6); $this->redirect(array('accession/stepSeven', 'accessionhash' => $Accession->accession_hash)); } $visitedVenues = $_POST['Venues']; } else { // Get existing choices $Contact2Venues = Contact2Venue::model()->findAll(array('condition' => 'accession_id = :accession_id', 'params' => array(':accession_id' => $Accession->id))); $visitedVenues = array(); foreach ($Contact2Venues as $visitedVenue) { $visitedVenues[$visitedVenue->venue_id] = $visitedVenue->visited; } } $this->render('step6', array('Accession' => $Accession, 'progress' => 6, 'Venues' => $Venues, 'visitedVenues' => $visitedVenues)); }