public function actionView() { $this->authenUser(); $caseId = null; $caseData = null; $patientData = null; $caseResponses = null; $caseMedData = NULL; if (isset($_REQUEST['caseId'])) { $caseId = $_REQUEST['caseId']; if (!is_numeric($caseId)) { $this->redirect($statusCode = 404); } // invalid request redirected to 404 not found page } if ($caseId != Null) { $caseData = PatientCase::model()->find('cid=?', array($caseId)); if ($caseData->hms_patient_pid != $this->userId) { $this->redirect($statusCode = 404); } // invalid request redirected to 404 not found page $dbConnection = Yii::app()->db; $command = $dbConnection->createCommand("SELECT id,response,name,rec_date FROM hms_patient_case_doc_responses , hms_doctor WHERE \n hms_patient_case_cid=" . $caseId . " \n AND hms_doctor_did=did ORDER BY rec_date DESC "); $caseResponses = $command->queryAll(); $caseMedData = PatientCaseMed::model()->findAll('patient_case_cid=?', array($caseId)); } $this->render('view', array('patientData' => $patientData, 'caseData' => $caseData, 'caseResponses' => $caseResponses, 'caseMedData' => $caseMedData)); }
public function actionAddCase() { $this->authenUser(); $patientId; $formAddCase = new formAddCase(); $patientData; if (isset($_REQUEST['patientId'])) { $patientId = $_REQUEST['patientId']; if (!is_numeric($patientId)) { $this->redirect($statusCode = 404); } else { $test; $patientData = Patient::model()->find('pid=?', array($patientId)); if ($patientData == null) { $this->redirect($statusCode = 404); } // invalid request redirected to 404 not found page $caseData = PatientCase::model()->find('hms_patient_pid=?', array($patientId)); if (isset($_POST['formAddCase'])) { $addPatientCase = new PatientCase(); $addPatientCase->attributes = $_POST['formAddCase']; $addPatientCase->hms_patient_pid = $patientId; $addPatientCase->recDate(); $addPatientCase->save(); //Yii::app()->end(); } } } else { $this->redirect($statusCode = 404); } // invalid request redirected to 404 not found page $this->render('addCase', array('formAddCase' => $formAddCase, 'patientData' => $patientData)); }