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));
}
