The followings are the available columns in table 'unique_codes':
/**
* Edits or adds a Procedure.
*
* @param bool|int $id
*
* @throws CHttpException
*/
public function actionEdit($id = false)
{
$admin = new Admin(UniqueCodes::model(), $this);
if ($id) {
$admin->setModelId($id);
}
$admin->setModelDisplayName('Unique Codes');
$admin->setEditFields(array('code' => 'label', 'active' => 'checkbox'));
$admin->editModel();
}
public function generateUniqueCodeWithChecksum($uniqueCodeId)
{
$uniqueCode = UniqueCodes::model()->findByPk($uniqueCodeId)->code;
$salt = isset(Yii::app()->params['portal']['credentials']['client_id']) ? Yii::app()->params['portal']['credentials']['client_id'] : '';
$check_digit1 = new CheckDigitGenerator(Yii::app()->params['institution_code'] . $uniqueCode, $salt);
$check_digit2 = new CheckDigitGenerator($uniqueCode . Yii::app()->user->id, $salt);
$finalUniqueCode = Yii::app()->params['institution_code'] . $check_digit1->generateCheckDigit() . '-' . $uniqueCode . '-' . $check_digit2->generateCheckDigit();
return $finalUniqueCode;
}
/**
* @param $event
*/
public function getUniqueCodeForCviEvent($event)
{
$eventUniqueCodeId = \UniqueCodeMapping::model()->findAllByAttributes(array('event_id' => $event->id));
$eventUniqueCode = \UniqueCodes::model()->findByPk($eventUniqueCodeId[0]->unique_code_id);
$salt = isset(\Yii::app()->params['portal']['credentials']['client_id']) ? \Yii::app()->params['portal']['credentials']['client_id'] : '';
$check_digit1 = new \CheckDigitGenerator(\Yii::app()->params['institution_code'] . $eventUniqueCode->code, $salt);
$check_digit2 = new \CheckDigitGenerator($eventUniqueCode->code . $event->episode->patient->dob, $salt);
$finalEventUniqueCode = \Yii::app()->params['institution_code'] . $check_digit1->generateCheckDigit() . '-' . $eventUniqueCode->code . '-' . $check_digit2->generateCheckDigit();
return $finalEventUniqueCode;
}
/**
* @param $id
*
* @return array
*
* @throws CHttpException
* @throws Exception
*/
protected function replaceEvent($eventQuery)
{
$creator = new \OEModule\OphCiExamination\components\ExaminationCreator();
$data = $eventQuery->examination_data;
$examination = json_decode($data, true);
$eventType = EventType::model()->find('name = "Examination"');
$portalUserId = $creator->getPortalUser();
$refractionType = \OEModule\OphCiExamination\models\OphCiExamination_Refraction_Type::model()->find('name = "Ophthalmologist"');
$eyeIds = $creator->getEyes();
$uidArray = explode('-', $examination['patient']['unique_identifier']);
$uniqueCode = $uidArray[1];
$opNoteEvent = UniqueCodes::model()->eventFromUniqueCode($uniqueCode);
if (UniqueCodes::model()->examinationEventCheckFromUniqueCode($uniqueCode, $eventType['id'])) {
$this->createExamination($eventQuery, $opNoteEvent->episode_id, $creator, $portalUserId, $examination, $eventType, $eyeIds, $refractionType, $opNoteEvent->id);
}
}
public function lock()
{
Yii::app()->db->createCommand('LOCK TABLES `' . UniqueCodes::model()->tableName() . '` READ, `' . UniqueCodes::model()->tableName() . '` AS `' . UniqueCodes::model()->getTableAlias() . '` READ, `' . $this->tableName() . '` WRITE,`' . $this->tableName() . '` as `' . $this->getTableAlias() . '` READ ')->execute();
}
