public function actionAllocDoctorCase()
{
$this->authenUser();
$formAllocDoctorCase = new formAllocDoctorCase();
if (isset($_REQUEST['caseId'])) {
$caseId = $_REQUEST['caseId'];
if (!is_numeric($caseId)) {
$this->redirect($statusCode = 404);
} else {
if (isset($_POST['formAllocDoctorCase'])) {
$doctorId = $_POST['formAllocDoctorCase']['doctors'];
echo $doctorId;
// Yii::app ()->end();
$criteria = new CDbCriteria();
$criteria->condition = "doctor_did=" . $doctorId . " AND hms_patient_case_cid=" . $caseId;
if (DoctorHasHmsPatient::model()->find($criteria) == null) {
$addDoctAllocPat = new DoctorHasHmsPatient();
$addDoctAllocPat->doctor_did = $doctorId;
$addDoctAllocPat->appointment_date = $_POST['formAllocDoctorCase']['appointment_date'];
$addDoctAllocPat->hms_patient_case_cid = $caseId;
$addDoctAllocPat->save();
$this->redirect(array('manage/selectPatient'));
} else {
Yii::app()->end();
}
}
}
}
$getDoctorsAndSpeciality = $this->getDoctorAndSpeciality();
$this->render('allocDoctorCase', array('formAllocDoctorCase' => $formAllocDoctorCase, 'doctorAndSpeciality' => $getDoctorsAndSpeciality));
}
public function actionView()
{
$this->authenUser();
$caseId = null;
$patientId = 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 (isset($_REQUEST['patientId'])) {
$patientId = $_REQUEST['patientId'];
if (!is_numeric($patientId)) {
$this->redirect($statusCode = 404);
}
// invalid request redirected to 404 not found page
}
if ($patientId != NULL) {
$patientData = Patient::model()->find('pid=?', array($patientId));
}
if ($caseId != Null) {
$caseData = PatientCase::model()->find('cid=?', array($caseId));
$criteria = new CDbCriteria();
$criteria->condition = "doctor_did=" . $this->userId . " AND hms_patient_case_cid=" . $caseId;
if (DoctorHasHmsPatient::model()->find($criteria) == null) {
$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));
}
$formAddCaseResponse = new formAddCaseResponse();
$this->render('view', array('patientData' => $patientData, 'caseData' => $caseData, 'caseResponses' => $caseResponses, 'caseMedData' => $caseMedData, 'formAddCaseResponse' => $formAddCaseResponse));
}
