The followings are the available columns in table 'subspecialty':
public function actionApplications()
{
$date_from = date(Helper::NHS_DATE_FORMAT, strtotime('-1 year'));
$date_to = date(Helper::NHS_DATE_FORMAT);
if (isset($_GET['yt0'])) {
$firm = null;
if (@$_GET['firm_id'] && (int) $_GET['firm_id']) {
$firm_id = (int) $_GET['firm_id'];
if (!($firm = Firm::model()->findByPk($firm_id))) {
throw new CException("Unknown firm {$firm_id}");
}
}
if (@$_GET['date_from'] && date('Y-m-d', strtotime($_GET['date_from']))) {
$date_from = date('Y-m-d', strtotime($_GET['date_from']));
}
if (@$_GET['date_to'] && date('Y-m-d', strtotime($_GET['date_to']))) {
$date_to = date('Y-m-d', strtotime($_GET['date_to']));
}
$results = $this->getApplications($date_from, $date_to, $firm);
$filename = 'therapyapplication_report_' . date('YmdHis') . '.csv';
$this->sendCsvHeaders($filename);
echo $this->array2Csv($results);
} else {
$subspecialty = Subspecialty::model()->find('ref_spec=:ref_spec', array(':ref_spec' => 'MR'));
$context = array('firms' => Firm::model()->getList($subspecialty->id), 'date_from' => $date_from, 'date_to' => $date_to);
$this->render('applications', $context);
}
}
public function down()
{
$subspecialty = \Subspecialty::model()->findByAttributes(array('name' => 'Cataract'));
foreach ($this->defaultCataractComplications as $defaultCataractComplication) {
$complication = \OEModule\OphCiExamination\models\OphCiExamination_PostOpComplications::model()->findByAttributes(array('code' => $defaultCataractComplication['code']));
$where = "complication_id = '" . $complication->id . "' AND subspecialty_id = '" . $subspecialty->id . "'";
$this->delete('ophciexamination_postop_complications_subspecialty', $where);
}
}
/**
* Init the edit admin page, because we have a custom save URL, so we need to use
* Admin in more then 1 function.
*
* @param bool $id
*
* @return Admin
*/
protected function initAdmin($id = false)
{
$admin = new Admin(DrugSet::model(), $this);
if ($id) {
$admin->setModelId($id);
}
$element = Element_OphDrPrescription_Details::model();
$admin->setCustomSaveURL('/OphDrPrescription/DrugSetAdmin/SaveDrugSet');
$admin->setCustomCancelURL('/OphDrPrescription/DrugSetAdmin/DrugSets');
$admin->setEditFields(array('active' => 'checkbox', 'name' => 'text', 'subspecialty' => array('widget' => 'DropDownList', 'options' => CHtml::listData(Subspecialty::model()->findAll(), 'id', 'name'), 'htmlOptions' => null, 'hidden' => false, 'layoutColumns' => null), 'setItems' => array('widget' => 'CustomView', 'viewName' => '/default/form_Element_OphDrPrescription_Details', 'viewArguments' => array('element' => $element))));
return $admin;
}
public function actionList()
{
$search = $this->request->getParam("search");
$session = new CHttpSession();
$session->open();
$firmId = $this->request->getParam("firm_id");
$subspecialtyId = $this->request->getParam("subspecialty_id");
if ($firmId > 0 && (isset($search['filterid']['subspecialty_id']['value']) && $search['filterid']['subspecialty_id']['value'] > 0)) {
$session['lastSubspecialtyId'] = $search['filterid']['subspecialty_id']['value'];
$this->redirect('/oeadmin/LeafletSubspecialtyFirm/list?search[filterid][firm_id][value]=' . $firmId . '&subspecialty_id=' . $search['filterid']['subspecialty_id']['value']);
}
$lastSubspecialtyId = $session['lastSubspecialtyId'];
// check if it's been already set
if (!($lastSubspecialtyId > 0)) {
if (isset($search['filterid']['subspecialty_id']['value'])) {
$session['lastSubspecialtyId'] = $search['filterid']['subspecialty_id']['value'];
} else {
$session['lastSubspecialtyId'] = Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id;
}
}
// || ($this->request->getParam("subspecialty_id")!=$session['lastSubspecialtyId'] && $search['filterid']['firm_id']['value']=="")
if ($subspecialtyId > 0 && $subspecialtyId != $session['lastSubspecialtyId'] && isset($search['filterid']['firm_id']['value']) || $subspecialtyId == $session['lastSubspecialtyId'] && $search['filterid']['firm_id']['value'] == "") {
$session['lastSubspecialtyId'] = "";
$this->redirect('/oeadmin/LeafletSubspecialtyFirm/list?search[filterid][subspecialty_id][value]=' . $subspecialtyId);
}
if (isset($search['filterid']['firm_id']['value']) && $search['filterid']['firm_id']['value'] > 0) {
$excludeSubspecialty = true;
$excludeFirm = false;
$admin = new AdminListAutocomplete(OphTrConsent_Leaflet_Firm::model(), $this);
$admin->setCustomDeleteURL('/oeadmin/LeafletSubspecialtyFirm/deleteFirm');
} else {
$excludeSubspecialty = false;
$excludeFirm = true;
$admin = new AdminListAutocomplete(OphTrConsent_Leaflet_Subspecialty::model(), $this);
$admin->setCustomDeleteURL('/oeadmin/LeafletSubspecialtyFirm/deleteSubspecialty');
}
$admin->setListFields(array('id', 'leaflet.name'));
$admin->setCustomSaveURL('/oeadmin/LeafletSubspecialtyFirm/add');
$admin->setModelDisplayName('Leaflet-Subspecialty-Firm Assignment');
if ($subspecialtyId > 0) {
$defaultSubspecialty = $subspecialtyId;
} else {
$defaultSubspecialty = Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id;
}
$admin->setFilterFields(array(array('label' => 'Subspecialty', 'dropDownName' => 'subspecialty_id', 'defaultValue' => $defaultSubspecialty, 'listModel' => Subspecialty::model(), 'listIdField' => 'id', 'listDisplayField' => 'name', 'excludeSearch' => $excludeSubspecialty), array('label' => 'Firm', 'dropDownName' => 'firm_id', 'defaultValue' => null, 'listModel' => Firm::model(), 'listIdField' => 'id', 'listDisplayField' => 'name', 'emptyLabel' => '-- All --', 'dependsOnFilterName' => 'subspecialty_id', 'dependsOnDbFieldName' => 'subspecialty_id', 'dependsOnJoinedTable' => 'serviceSubspecialtyAssignment', 'excludeSearch' => $excludeFirm)));
// we set default search options
if ($this->request->getParam('search') == '') {
$admin->getSearch()->initSearch(array('filterid' => array('subspecialty_id' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id)));
}
$admin->setAutocompleteField(array('fieldName' => 'leaflet_id', 'allowBlankSearch' => 1, 'jsonURL' => '/oeadmin/LeafletSubspecialtyFirm/search', 'placeholder' => 'search for leaflets'));
//$admin->searchAll();
$admin->listModel();
}
public function actionList()
{
$admin = new AdminListAutocomplete(OphTrConsent_Leaflet_Subspecialty::model(), $this);
$admin->setListFields(array('id', 'leaflet.name'));
$admin->setCustomDeleteURL('/oeadmin/LeafletSubspecialty/delete');
$admin->setCustomSaveURL('/oeadmin/LeafletSubspecialty/add');
$admin->setModelDisplayName('Leaflet-Subspecialty Assignment');
$admin->setFilterFields(array(array('label' => 'Subspecialty', 'dropDownName' => 'subspecialty_id', 'defaultValue' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id, 'listModel' => Subspecialty::model(), 'listIdField' => 'id', 'listDisplayField' => 'name')));
// we set default search options
if ($this->request->getParam('search') == '') {
$admin->getSearch()->initSearch(array('filterid' => array('subspecialty_id' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id)));
}
$admin->setAutocompleteField(array('fieldName' => 'leaflet_id', 'jsonURL' => '/oeadmin/LeafletSubspecialty/search', 'placeholder' => 'search for leaflets'));
//$admin->searchAll();
$admin->listModel();
}
public function actionList()
{
$admin = new AdminListAutocomplete(SiteSubspecialtyAnaestheticAgentDefault::model(), $this);
$admin->setListFields(array('id', 'agents.name'));
$admin->setCustomDeleteURL('/oeadmin/AnaestheticAgentDefaults/delete');
$admin->setCustomSaveURL('/oeadmin/AnaestheticAgentDefaults/add');
$admin->setModelDisplayName('Operation Note Anaesthetic Agent Defaults');
$admin->setFilterFields(array(array('label' => 'Site', 'dropDownName' => 'site_id', 'defaultValue' => Yii::app()->session['selected_site_id'], 'listModel' => Site::model(), 'listIdField' => 'id', 'listDisplayField' => 'short_name'), array('label' => 'Subspecialty', 'dropDownName' => 'subspecialty_id', 'defaultValue' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id, 'listModel' => Subspecialty::model(), 'listIdField' => 'id', 'listDisplayField' => 'name')));
// we set default search options
if ($this->request->getParam('search') == '') {
$admin->getSearch()->initSearch(array('filterid' => array('subspecialty_id' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id, 'site_id' => Yii::app()->session['selected_site_id'])));
}
$admin->setAutocompleteField(array('fieldName' => 'anaesthetic_agent_id', 'allowBlankSearch' => 1, 'jsonURL' => '/oeadmin/AnaestheticAgentDefaults/search', 'placeholder' => 'search for adding anaesthetic agent'));
//$admin->searchAll();
$admin->listModel();
}
public function actionList()
{
$admin = new AdminListAutocomplete(SiteSubspecialtyDrug::model(), $this);
$admin->setListFields(array('id', 'drugs.name', 'drugs.dose_unit'));
$admin->setCustomDeleteURL('/OphDrPrescription/admin/commondrugsdelete');
$admin->setCustomSaveURL('/OphDrPrescription/admin/commondrugsadd');
$admin->setModelDisplayName('Common Drugs List');
$admin->setFilterFields(array(array('label' => 'Site', 'dropDownName' => 'site_id', 'defaultValue' => Yii::app()->session['selected_site_id'], 'listModel' => Site::model(), 'listIdField' => 'id', 'listDisplayField' => 'short_name'), array('label' => 'Subspecialty', 'dropDownName' => 'subspecialty_id', 'defaultValue' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id, 'listModel' => Subspecialty::model(), 'listIdField' => 'id', 'listDisplayField' => 'name')));
// we set default search options
if ($this->request->getParam('search') == '') {
$admin->getSearch()->initSearch(array('filterid' => array('site_id' => Yii::app()->session['selected_site_id'], 'subspecialty_id' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id)));
}
$admin->setAutocompleteField(array('fieldName' => 'drug_id', 'jsonURL' => '/OphDrPrescription/default/DrugList', 'placeholder' => 'search for drugs'));
//$admin->searchAll();
$admin->listModel();
}
public function actionList()
{
$admin = new AdminListAutocomplete(OphTrOperationnote_PostopSiteSubspecialtyDrug::model(), $this);
$admin->setListFields(array('id', 'postopdrugs.name', 'default'));
$admin->setCustomDeleteURL('/oeadmin/PostOpDrugMappings/delete');
$admin->setCustomSaveURL('/oeadmin/PostOpDrugMappings/add');
$admin->setCustomSetDefaultURL('/oeadmin/PostOpDrugMappings/setDefault');
$admin->setCustomRemoveDefaultURL('/oeadmin/PostOpDrugMappings/RemoveDefault');
$admin->setModelDisplayName('Per-operative Drugs Mapping');
$admin->setFilterFields(array(array('label' => 'Site', 'dropDownName' => 'site_id', 'defaultValue' => Yii::app()->session['selected_site_id'], 'listModel' => Site::model(), 'listIdField' => 'id', 'listDisplayField' => 'short_name'), array('label' => 'Subspecialty', 'dropDownName' => 'subspecialty_id', 'defaultValue' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id, 'listModel' => Subspecialty::model(), 'listIdField' => 'id', 'listDisplayField' => 'name')));
// we set default search options
if ($this->request->getParam('search') == '') {
$admin->getSearch()->initSearch(array('filterid' => array('subspecialty_id' => Firm::model()->findByPk(Yii::app()->session['selected_firm_id'])->serviceSubspecialtyAssignment->subspecialty_id, 'site_id' => Yii::app()->session['selected_site_id'])));
}
$admin->setAutocompleteField(array('fieldName' => 'drug_id', 'jsonURL' => '/oeadmin/PostOpDrugMappings/search', 'placeholder' => 'search for adding per op drug'));
//$admin->searchAll();
$admin->listModel();
}
<div class="column large-8">
<input type="text" id="date_to" name="date_to" class="datepicker filter-field"
value="<?php
echo array_key_exists('date_to', $list_filter) ? $list_filter['date_to'] : '';
?>
" />
</div>
</div>
</div>
<div class="column large-3">
<div class="row">
<div class="column large-4 text-right"><label for="subspecialty_id">Subspecialty:</label></div>
<div class="column large-8">
<?php
echo CHtml::dropDownList('subspecialty_id', array_key_exists('subspecialty_id', $list_filter) ? $list_filter['subspecialty_id'] : null, Subspecialty::model()->getList(), array('class' => 'filter-field', 'empty' => 'All specialties'));
?>
</div>
<div class="column large-4 text-right"><label for="site_id">Site:</label></div>
<div class="column large-8">
<?php
echo CHtml::dropDownList('site_id', array_key_exists('site_id', $list_filter) ? $list_filter['site_id'] : null, Site::model()->getListForCurrentInstitution(), array('class' => 'filter-field', 'empty' => 'All sites'));
?>
</div>
</div>
</div>
<div class="column large-1 text-right"><label for="consultants">Consultant(s):</label></div>
<div class="column large-2"><?php
$this->widget('zii.widgets.jui.CJuiAutoComplete', array('id' => 'consultant_auto_complete', 'name' => 'consultant_auto_complete', 'value' => '', 'source' => "js:function(request, response) {\n var existing = [];\n \$('#consultant_list').children('li').map(function() {\n existing.push(String(\$(this).data('id')));\n });\n\n \$.ajax({\n 'url': '" . Yii::app()->createUrl('user/autocomplete') . "',\n 'type':'GET',\n 'data':{'term': request.term},\n 'success':function(data) {\n data = \$.parseJSON(data);\n\n var result = [];\n\n for (var i = 0; i < data.length; i++) {\n var index = \$.inArray(data[i].id, existing);\n if (index == -1) {\n result.push(data[i]);\n }\n }\n\n response(result);\n }\n });\n }", 'options' => array('minLength' => '3', 'select' => "js:function(event, ui) {\n addConsultantToList(ui.item);\n \$('#consultant_auto_complete').val('');\n return false;\n }"), 'htmlOptions' => array('placeholder' => 'type to search for users')));
?>
echo $form->dropDownList($rule, 'rule_type_id', 'OphTrOperationbooking_Admission_Letter_Warning_Rule_Type', array('empty' => '- Rule type -'));
?>
<?php
echo $form->dropDownList($rule, 'parent_rule_id', CHtml::listData(OphTrOperationbooking_Admission_Letter_Warning_Rule::model()->getListAsTree(), 'id', 'treeName'), array('empty' => '- None -'));
?>
<?php
echo $form->textField($rule, 'rule_order', array(), array(), array('field' => 2));
?>
<?php
echo $form->dropDownList($rule, 'site_id', Site::model()->getListForCurrentInstitution('name'), array('empty' => '- Not set -'));
?>
<?php
echo $form->dropDownList($rule, 'firm_id', Firm::model()->getListWithSpecialties(), array('empty' => '- Not set -'));
?>
<?php
echo $form->dropDownList($rule, 'subspecialty_id', CHtml::listData(Subspecialty::model()->findAllByCurrentSpecialty(), 'id', 'name'), array('empty' => '- Not set -'));
?>
<?php
echo $form->dropDownList($rule, 'theatre_id', 'OphTrOperationbooking_Operation_Theatre', array('empty' => '- Not set -'));
?>
<?php
echo $form->dropDownList($rule, 'is_child', array('' => '- Not set -', '1' => 'Child', '0' => 'Adult'));
?>
<?php
echo $form->radioBoolean($rule, 'show_warning');
?>
<?php
echo $form->textArea($rule, 'warning_text', array('rows' => 5));
?>
<?php
echo $form->radioBoolean($rule, 'emphasis');
<div class="row field-row">
<div class="large-4 column"><h3>OR Add new:</h3></div>
</div>
<div class="row field-row">
<div class="large-2 column"><label for="set_name">Set name:</label></div>
<div class="large-4 column">
<?php
echo CHtml::textField('set_name');
?>
</div>
<div class="large-2 column"><label for="site_id">Subspeciality:</label></div>
<div class="large-4 column end">
<?php
// $selectedsubspecialty
echo CHtml::dropDownList('subspecialty_id', '', CHtml::listData(Subspecialty::model()->findAll(), 'id', 'name'), array('empty' => '-- Select --'));
?>
</div>
</div>
<section class="element" id="drugsetdata">
<?php
$this->renderPartial('/default/form_Element_OphDrPrescription_Details', array('form' => $form, 'element' => $element));
//$this->displayErrors($errors, true);
?>
<div class="box-header">
<div class="box-actions">
<button class="small" type="submit" id="save_set_data" name="save_set_data">
Save this set
</button>
</div>
</div>
public function actionGetFirmsForSubspecialty()
{
if (!($subspecialty = \Subspecialty::model()->findByPk(@$_GET['subspecialty_id']))) {
throw new Exception('Subspecialty not found: ' . @$_GET['subspecialty_id']);
}
echo \CHtml::dropDownList('firm-id', '', \Firm::model()->getList($subspecialty->id), array('empty' => 'All firms'));
}
<?php
/**
* OpenEyes.
*
* (C) Moorfields Eye Hospital NHS Foundation Trust, 2008-2011
* (C) OpenEyes Foundation, 2011-2013
* This file is part of OpenEyes.
* OpenEyes is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
* OpenEyes is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
* You should have received a copy of the GNU General Public License along with OpenEyes in a file titled COPYING. If not, see <http://www.gnu.org/licenses/>.
*
* @link http://www.openeyes.org.uk
*
* @author OpenEyes <*****@*****.**>
* @copyright Copyright (c) 2008-2011, Moorfields Eye Hospital NHS Foundation Trust
* @copyright Copyright (c) 2011-2013, OpenEyes Foundation
* @license http://www.gnu.org/licenses/gpl-3.0.html The GNU General Public License V3.0
*/
?>
<div class="element-fields">
<?php
$subspecialty = Subspecialty::model()->find('ref_spec=:ref_spec', array(':ref_spec' => 'MR'));
echo $form->dropDownList($element, 'consultant_id', Firm::model()->getList($subspecialty->id, $element->consultant_id), array('empty' => '- Please select -'), false, array('field' => 3));
echo $form->dropDownList($element, 'site_id', Site::model()->getListForCurrentInstitution(), array('empty' => '- Please select -'), false, array('field' => 3));
echo $form->radioBoolean($element, 'patient_sharedata_consent');
?>
</div>
* @author OpenEyes <*****@*****.**>
* @copyright Copyright (C) 2013, OpenEyes Foundation
* @license http://www.gnu.org/licenses/gpl-3.0.html The GNU General Public License V3.0
*/
?>
<div id="episode-summary" class="box admin">
<div id="draggablelist">
<h2>Custom episode summaries</h2>
<?php
echo CHtml::beginForm(array('/admin/updateEpisodeSummary'), 'post');
?>
<?php
echo CHtml::label('Subspecialty', 'subspecialty_id');
?>
<?php
echo CHtml::dropDownList('subspecialty_id', $subspecialty_id, CHtml::listData(Subspecialty::model()->findAll(), 'id', 'name', 'specialty.name'), array('empty' => 'Default'));
?>
<?php
echo CHtml::hiddenField('item_ids');
?>
<div id="draggablelist-items" class="row">
<div class="large-6 column">
<h2>Enabled items</h2>
<?php
$this->renderPartial('_episodeSummaries_table', array('id' => 'draggablelist-items-enabled', 'items' => $enabled_items));
?>
<div class="right">
<button class="small" type="submit">Save</button>
<button id="draggablelist-cancel" class="small warning" type="button">Cancel</button>
</div>
</div>
<div class="box admin">
<h2>Edit macro</h2>
<?php
echo $this->renderPartial('_form_errors', array('errors' => $errors));
?>
<?php
$form = $this->beginWidget('BaseEventTypeCActiveForm', array('id' => 'adminform', 'enableAjaxValidation' => false, 'focus' => '#username', 'layoutColumns' => array('label' => 2, 'field' => 4)));
?>
<?php
echo $form->dropDownList($macro, 'type', array('site' => 'Site', 'subspecialty' => 'Subspecialty', 'firm' => 'Firm'), array('empty' => '- Type -'));
?>
<?php
echo $form->dropDownList($macro, 'site_id', Site::model()->getListForCurrentInstitution(), array('empty' => '- Site -', 'div-class' => 'typeSite'), $macro->type != 'site');
?>
<?php
echo $form->dropDownList($macro, 'subspecialty_id', CHtml::listData(Subspecialty::model()->findAll(array('order' => 'name asc')), 'id', 'name'), array('empty' => '- Subspecialty -', 'div-class' => 'typeSubspecialty'), $macro->type != 'subspecialty');
?>
<?php
echo $form->dropDownList($macro, 'firm_id', Firm::model()->getListWithSpecialties(true), array('empty' => '- Firm -', 'div-class' => 'typeFirm'), $macro->type != 'firm');
?>
<?php
echo $form->textField($macro, 'name', array('autocomplete' => Yii::app()->params['html_autocomplete']));
?>
<?php
echo $form->radioButtons($macro, 'recipient_id', CHtml::listData(LetterRecipient::model()->findAll(array('order' => 'display_order asc')), 'id', 'name'), null, false, false, false, false, array('empty' => 'None', 'empty-after' => true));
?>
<?php
echo $form->checkBox($macro, 'cc_patient', array('text-align' => 'right'));
?>
<?php
echo $form->checkBox($macro, 'cc_doctor', array('text-align' => 'right'));
public function actionManageClinicOutcomesStatus()
{
$extra_fields = array(array('field' => 'episode_status_id', 'type' => 'lookup', 'model' => 'EpisodeStatus'), array('field' => 'subspecialties', 'type' => 'multilookup', 'noSelectionsMessage' => 'All Subspecialties', 'htmlOptions' => array('empty' => '- Please Select -', 'nowrapper' => true), 'options' => \CHtml::listData(\Subspecialty::model()->findAll(), 'id', 'name')), array('field' => 'followup', 'type' => 'boolean'));
if (Yii::app()->moduleAPI->get('PatientTicketing')) {
$extra_fields[] = array('field' => 'patientticket', 'type' => 'boolean');
}
$this->genericAdmin('Edit Clinical Outcome Statuses', 'OEModule\\OphCiExamination\\models\\OphCiExamination_ClinicOutcome_Status', array('extra_fields' => $extra_fields));
}
<table class="grid">
<thead>
<tr>
<th>Service:</th>
<th>Firm:</th>
<th>Next letter due:</th>
<th>Site:</th>
<th>Hospital no:</th>
<th> </th>
</tr>
</thead>
<tbody>
<tr>
<td>
<?php
echo CHtml::dropDownList('subspecialty-id', @$_POST['subspecialty-id'], Subspecialty::model()->getList(), array('empty' => 'All specialties', 'ajax' => array('type' => 'POST', 'data' => array('subspecialty_id' => 'js:this.value', 'YII_CSRF_TOKEN' => Yii::app()->request->csrfToken), 'url' => Yii::app()->createUrl('/OphTrOperationbooking/waitingList/filterFirms'), 'success' => "js:function(data) {\n\t\t\t\t\t\t\t\t\t\t\tif (\$('#subspecialty-id').val() != '') {\n\t\t\t\t\t\t\t\t\t\t\t\t\$('#firm-id').attr('disabled', false);\n\t\t\t\t\t\t\t\t\t\t\t\t\$('#firm-id').html(data);\n\t\t\t\t\t\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\t\t\t\t\t\t\$('#firm-id').attr('disabled', true);\n\t\t\t\t\t\t\t\t\t\t\t\t\$('#firm-id').html(data);\n\t\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t\t}")));
?>
</td>
<td>
<?php
echo CHtml::dropDownList('firm-id', @$_POST['firm-id'], $this->getFilteredFirms(@$_POST['subspecialty-id']), array('empty' => 'All firms', 'disabled' => !@$_POST['firm-id']));
?>
</td>
<td>
<?php
echo CHtml::dropDownList('status', @$_POST['status'], Element_OphTrOperationbooking_Operation::getLetterOptions());
?>
</td>
<td>
<?php
echo CHtml::dropDownList('site_id', @$_POST['site_id'], Site::model()->getListForCurrentInstitution(), array('empty' => 'All sites'));
/**
* Cache wrapper for searching and retrieving subspecialty by ref spec code
*
* @param $code
* @return Subspecialty|null
*/
protected function getSubspecialty($code)
{
if (!array_key_exists($code, $this->subspecialty)) {
$this->subspecialty[$code] = Subspecialty::model()->findByAttributes(array('ref_spec' => $code));
}
return $this->subspecialty[$code];
}
?>
<div class="admin box">
<h2>Display Context For <?php
echo $display_context->worklist_definition->name;
?>
</h2>
<?php
echo $this->renderPartial('//admin/_form_errors', array('errors' => $errors));
?>
<?php
$form = $this->beginWidget('BaseEventTypeCActiveForm', array('id' => 'display-context-form', 'enableAjaxValidation' => false, 'focus' => '#site_id', 'layoutColumns' => array('label' => 2, 'field' => 5)));
?>
<?php
echo $form->dropDownList($display_context, 'site_id', Site::model()->getListForCurrentInstitution(), array('empty' => '- Any -'));
?>
<?php
echo $form->dropDownList($display_context, 'subspecialty_id', Subspecialty::model()->getList(), array('empty' => '- Any -'));
?>
<?php
echo $form->dropDownList($display_context, 'firm_id', Firm::model()->getListWithSpecialties(), array('empty' => '- Any -'));
?>
<?php
echo $form->formActions(array('cancel-uri' => '/worklistAdmin/definitionDisplayContexts/' . $display_context->worklist_definition->id));
?>
<?php
$this->endWidget();
?>
</div>
/**
* Return all the subspecialties that can be selected for this rule (including the current one if it is set already).
*
* @return Subspecialty[]
*/
public function getSubspecialtyOptions()
{
$kls = get_class($this);
if ($this->id) {
$all_rules = $kls::model()->findAll('id != ?', $this->id);
} else {
$all_rules = $kls::model()->findAll();
}
$current_subspecialties = array();
foreach ($all_rules as $r) {
$current_subspecialties[] = $r->subspecialty_id;
}
$criteria = new CDbCriteria();
$criteria->addNotInCondition('id', $current_subspecialties);
return Subspecialty::model()->findAll($criteria);
}
public function actionManageFindings()
{
$this->genericAdmin('Findings', 'Finding', array('extra_fields' => array(array('field' => 'subspecialties', 'type' => 'multilookup', 'noSelectionsMessage' => 'All Subspecialties', 'htmlOptions' => array('empty' => '- Please Select -', 'nowrapper' => true), 'options' => \CHtml::listData(\Subspecialty::model()->findAll(), 'id', 'name')), array('field' => 'requires_description', 'type' => 'boolean'))));
}
Test:
</legend>
<div class="row field-row">
<div class="large-2 column">
<?php
echo CHtml::dropDownList('lcr_rule_type_id', '', CHtml::listData(OphTrOperationbooking_Admission_Letter_Warning_Rule_Type::model()->findAll(), 'id', 'name'), array('empty' => '- Rule -'));
?>
</div>
<div class="large-2 column">
<?php
echo CHtml::dropDownList('lcr_site_id', '', Site::model()->getListForCurrentInstitution('name'), array('empty' => '- Site -'));
?>
</div>
<div class="large-2 column">
<?php
echo CHtml::dropDownList('lcr_subspecialty_id', '', CHtml::listData(Subspecialty::model()->findAllByCurrentSpecialty(), 'id', 'name'), array('empty' => '- Subspecialty -'));
?>
</div>
<div class="large-2 column">
<?php
echo CHtml::dropDownList('lcr_firm_id', '', array(), array('empty' => '- Firm -'));
?>
</div>
<div class="large-2 column">
<?php
echo CHtml::dropDownList('lcr_theatre_id', '', array(), array('empty' => '- Theatre -'));
?>
</div>
<div class="large-2 column">
<?php
echo CHtml::dropDownList('lcr_is_child', '', array('' => '- Child/adult -', '1' => 'Child', '0' => 'Adult'));
if ($queueset->filter_priority) {
?>
<td>
<?php
$this->widget('application.widgets.MultiSelectList', array('auto_data_order' => true, 'field' => 'priority-ids', 'default_options' => @$_POST['priority-ids'], 'options' => CHtml::listData(OEModule\PatientTicketing\models\Priority::model()->findAll(), 'id', 'name'), 'htmlOptions' => array('empty' => '- Please Select -', 'nowrapper' => true), 'noSelectionsMessage' => 'All Priorities'));
?>
</td>
<?php
}
?>
<?php
if ($queueset->filter_subspecialty) {
?>
<td>
<?php
echo CHtml::dropDownList('subspecialty-id', @$_POST['subspecialty-id'], Subspecialty::model()->getList(), array('empty' => 'All specialties', 'disabled' => @$_POST['emergency_list'] == 1 ? 'disabled' : ''));
?>
</td>
<?php
}
?>
<?php
if ($queueset->filter_firm) {
?>
<td>
<?php
if (!@$_POST['subspecialty-id']) {
?>
<?php
echo CHtml::dropDownList('firm-id', '', array(), array('empty' => 'All firms', 'disabled' => 'disabled'));
?>
/**
* Calculate the EROD for this operation - the firm used to determine the service can be overridden by providing a firm.
* (Note that this handles the emergency list by having a firm placeholder object that does not have an id - at this time,
* no sessions are assigned to A&E firms, having the effect that no EROD can be calculated for emergency bookings).
*
* @param Firm $firm
*
* @return OphTrOperationbooking_Operation_EROD|null
*
* @throws Exception
*/
public function calculateEROD($firm = null)
{
$criteria = new CDbCriteria();
$criteria->params[':one'] = 1;
//consultant required
if ($this->consultant_required) {
$criteria->addCondition('`t`.consultant = :one');
}
//anaesthetic requirements
if ($this->anaesthetist_required || $this->anaesthetic_type->code == 'GA') {
$criteria->addCondition('`t`.anaesthetist = :one and `t`.general_anaesthetic = :one');
}
// child conditions
$patient = $this->getPatient();
if ($patient->isChild()) {
// need to get the point at which patient becomes an adult. All sessions up to that point need the pediatric flag
$criteria->params[':adult_date'] = $patient->getBecomesAdultDate();
$criteria->addCondition('(`t`.date < :adult_date AND `t`.paediatric = :one) OR `t`.date >= :adult_date');
}
// if their are firms that are set for the subspecialty of the episode, use their sessions
if ($rule = OphTrOperationbooking_Operation_EROD_Rule::model()->find('subspecialty_id=?', array($this->getFirm()->getSubspecialtyID()))) {
$firm_ids = array();
foreach ($rule->items as $item) {
if ($item->item_type == 'firm') {
$firm_ids[] = $item->item_id;
}
}
$criteria->addInCondition('firm.id', $firm_ids);
} else {
// otherwise, use the given firm to define the set of valid sessions by subspecialty
if (!$firm) {
$firm = $this->event->episode->firm;
}
if (!$firm->id) {
// booking into the emergency list
if (!($subspecialty = Subspecialty::model()->find('ref_spec=?', array('AE')))) {
throw new Exception('A&E subspecialty not found');
}
if (!($service_subspecialty_assignment = ServiceSubspecialtyAssignment::model()->find('subspecialty_id=?', array($subspecialty->id)))) {
throw new Exception('A&E service_subspecialty_assignment not found');
}
$service_subspecialty_assignment_id = $service_subspecialty_assignment->id;
} else {
if (!($service_subspecialty_assignment_id = $firm->service_subspecialty_assignment_id)) {
throw new Exception('Firm must have service_subspecialty_assignment for EROD calculation');
}
}
$criteria->addCondition('service_subspecialty_assignment_id = :serviceSubspecialtyAssignmentId');
$criteria->params[':serviceSubspecialtyAssignmentId'] = $service_subspecialty_assignment_id;
}
// session must be available
$criteria->addCondition('`t`.available = :one');
// work out the lead date
$lead_decision_date = strtotime($this->decision_date);
if ($lead_weeks = Yii::app()->params['erod_lead_time_weeks']) {
$lead_decision_date += 86400 * 7 * $lead_weeks;
}
$lead_current_date = time();
if ($lead_days = Yii::app()->params['erod_lead_current_date_days']) {
$lead_current_date += 86400 * $lead_days;
}
$lead_time_date = $lead_decision_date > $lead_current_date ? date('Y-m-d', $lead_decision_date) : date('Y-m-d', $lead_current_date);
$criteria->addCondition('`t`.date > :leadTimeDate');
$criteria->params[':leadTimeDate'] = $lead_time_date;
$criteria->order = '`t`.date, `t`.start_time';
foreach (OphTrOperationbooking_Operation_Session::model()->with(array('firm' => array('joinType' => 'JOIN')))->findAll($criteria) as $session) {
$available_time = $session->availableMinutes;
if ($available_time < $this->total_duration) {
continue;
}
if ($session->max_procedures > 0 && $this->getProcedureCount() > $session->getAvailableProcedureCount()) {
continue;
}
$erod = new OphTrOperationbooking_Operation_EROD();
$erod->session_id = $session->id;
$erod->session_date = $session->date;
$erod->session_start_time = $session->start_time;
$erod->session_end_time = $session->end_time;
$erod->firm_id = $session->firm_id;
$erod->consultant = $session->consultant;
$erod->paediatric = $session->paediatric;
$erod->anaesthetist = $session->anaesthetist;
$erod->general_anaesthetic = $session->general_anaesthetic;
$erod->session_duration = $session->duration;
$erod->total_operations_time = $session->bookedMinutes;
// Note that I have not subtracted the duration of this operation from the available time when storing this
// as it is now being generated before the booking is made. When the booking is made, it will have been saved
// before the EROD is calculated, so the available time will reflect the same value as in the prior calculations
$erod->available_time = $available_time;
return $erod;
}
}
$form = $this->beginWidget('BaseEventTypeCActiveForm', array('id' => 'adminform', 'enableAjaxValidation' => false, 'focus' => '#username', 'layoutColumns' => array('label' => 2, 'field' => 5)));
?>
<?php
echo $form->textField($firm, 'pas_code', array('autocomplete' => Yii::app()->params['html_autocomplete']));
?>
<?php
echo $form->textField($firm, 'name', array('autocomplete' => Yii::app()->params['html_autocomplete']));
?>
<div id="div_Firm_subspecialty_id" class="row field-row">
<div class="large-2 column">
<label for="Firm_subspecialty_id">Subspecialty:</label>
</div>
<div class="large-5 column end">
<?php
echo CHtml::dropDownList('Firm[subspecialty_id]', $firm->serviceSubspecialtyAssignment ? $firm->serviceSubspecialtyAssignment->subspecialty_id : null, CHtml::listData(Subspecialty::model()->findAll(array('order' => 'name')), 'id', 'name'), array('empty' => '- None -'));
?>
</div>
</div>
<div id="div_Firm_consultant_id" class="row field-row">
<div class="large-2 column">
<label for="Firm_consultant_id">Consultant:</label>
</div>
<div class="large-5 column end">
<?php
echo CHtml::dropDownList('Firm[consultant_id]', $firm->consultant_id, CHtml::listData(User::model()->findAll(array('order' => 'first_name,last_name')), 'id', 'fullName'), array('empty' => '- None -'));
?>
</div>
</div>
<div id="div_Firm_consultant_id" class="row field-row">
<div class="large-2 column">
public function findAllByCurrentSpecialty()
{
if (!isset(Yii::app()->params['institution_specialty'])) {
throw new Exception("institution_specialty code is not set in params");
}
if (!($specialty = Specialty::model()->find('code=?', array(Yii::app()->params['institution_specialty'])))) {
throw new Exception("Specialty not found: " . Yii::app()->params['institution_specialty']);
}
$criteria = new CDbCriteria();
$criteria->addCondition('specialty_id = :specialty_id');
$criteria->params[':specialty_id'] = $specialty->id;
$criteria->order = 'name asc';
return Subspecialty::model()->findAll($criteria);
}
* @copyright Copyright (c) 2011-2015, OpenEyes Foundation
* @license http://www.gnu.org/licenses/gpl-3.0.html The GNU General Public License V3.0
*/
?>
<div id="postop-complications" class="box admin">
<div id="draggablelist">
<h2>Common Post-Operative Complications</h2>
<?php
echo CHtml::beginForm(array('/OphCiExamination/admin/updatePostOpComplications'), 'post');
?>
<?php
echo CHtml::label('Subspecialty', 'subspecialty_id');
?>
<?php
echo CHtml::dropDownList('subspecialty_id', $subspecialty_id, CHtml::listData(Subspecialty::model()->findAll(), 'id', 'name', 'specialty.name'));
?>
<?php
echo CHtml::hiddenField('item_ids');
?>
<div id="draggablelist-items" class="row">
<div class="large-6 column">
<h2>Currently assigned to</h2>
<?php
$this->renderPartial('_postOpComplications_table', array('id' => 'draggablelist-items-enabled', 'items' => $enabled_items));
?>
<div class="right">
<button class="small" type="submit">Save</button>
<button id="draggablelist-cancel" class="small warning" type="button">Cancel</button>
</div>
</div>
</div>
<form id="admin_sessions_filters" class="panel">
<div class="row field-row">
<div class="large-2 column">
<?php
echo CHtml::dropDownList('type', '', array('site' => 'Site', 'subspecialty' => 'Subspecialty', 'firm' => 'Firm'), array('empty' => '- Type -'));
?>
</div>
<div class="large-2 column typeSite" style="display: none">
<?php
echo CHtml::dropDownList('site_id', @$_GET['site_id'], Site::model()->getListForCurrentInstitution(), array('empty' => '- Site -'));
?>
</div>
<div class="large-2 column typeSubspecialty" style="display: none">
<?php
echo CHtml::dropDownList('subspecialty_id', @$_GET['subspecialty_id'], CHtml::listData(Subspecialty::model()->findAll(array('order' => 'name asc')), 'id', 'name'), array('empty' => '- Subspecialty -'));
?>
</div>
<div class="large-2 column typeFirm" style="display: none">
<?php
echo CHtml::dropDownList('firm_id', @$_GET['firm_id'], Firm::model()->getListWithSpecialties(), array('empty' => '- Firm -'));
?>
</div>
<div class="large-2 column">
<?php
echo CHtml::dropDownList('name', @$_GET['name'], $unique_names, array('empty' => '- Name -'));
?>
</div>
<div class="large-2 column end">
<?php
echo CHtml::dropDownList('episode_status_id', @$_GET['episode_status_id'], $episode_statuses, array('empty' => '- Episode status -'));
