public function loadModel($id)
{
$model = SurgeryRecord::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* 匯出手術記錄
*/
public function actionSurgeryRecords()
{
$dataProvider = new SurgeryRecord('search');
$dataProvider->unsetAttributes();
if (isset($_GET['SurgeryRecord'])) {
$dataProvider->attributes = $_GET['SurgeryRecord'];
$surgeryRecords = SurgeryRecord::model()->findAll($dataProvider->search()->getCriteria());
$fields = array('病歷號' => 'patientId', '姓名' => 'patientName', '手術日期' => 'date', '給付' => 'payType', '術前診斷' => 'icd', '術式' => 'surgical_methods', '3D' => 'three_dimensional', '矯正牙科醫師' => 'dentistName', '手術醫師' => 'plasticSurgeonName', '備註' => 'memo', '是否手術優先' => 'isSurgicalPriority', '是否院外牙科' => 'isOutsideDentist');
$content = implode("\t", array_keys($fields)) . "\n";
foreach ($surgeryRecords as $surgeryRecord) {
foreach ($fields as $field) {
$content .= '"' . $surgeryRecord->{$field} . '"' . "\t";
}
$content .= "\n";
}
$this->_downloadExcel('手術記錄-' . date('Y-m-d-His'), $content);
}
exit;
}
