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