public function actionEditProcess()
{
try {
$post = StringHelper::filterArrayString($_POST);
$result = Letters::model()->edit($_POST);
if ($result == 1) {
Yii::app()->user->setFlash('success', 'Cập nhật dữ liệu thành công !');
$this->redirect(Yii::app()->createUrl('letter/edit', array('id' => $post['id'])));
} else {
if ($result == 2) {
Yii::app()->user->setFlash('error', 'Cập nhật dữ liệu thất bại !');
$this->redirect(Yii::app()->createUrl('letter/edit', array('id' => $post['id'])));
} else {
Yii::app()->user->setFlash('error', 'Không tồn tại tài liệu !');
$this->redirect(Yii::app()->createUrl('letter/edit', array('id' => $post['id'])));
}
}
} catch (Exception $ex) {
var_dump($ex->getMessage());
}
}
public function searchByCondition($attr, $cnt = null, $pagination = 1)
{
$criteria = new CDbCriteria();
if (!empty($attr['date_start']) && !empty($attr['date_end'])) {
$date_start = strtotime($attr['date_start']);
$date_end = strtotime($attr['date_end']);
$criteria->addBetweenCondition('signed_date', $date_start, $date_end, 'OR');
$criteria->addBetweenCondition('signed_recieve', $date_start, $date_end, 'OR');
}
if (!empty($attr['assignee'])) {
$assignee = $attr['assignee'];
$criteria->addSearchCondition('staff_assigned', $assignee);
}
if (!empty($attr['keyword'])) {
$keyword = $attr['keyword'];
$criteria->addSearchCondition('content', $keyword, true, "OR", "LIKE");
$criteria->addSearchCondition('staff_assigned', $keyword, true, "OR", "LIKE");
$criteria->addSearchCondition('verification_period', $keyword, true, "OR", "LIKE");
$criteria->addSearchCondition('decided_assigned', $keyword, true, "OR", "LIKE");
$criteria->addSearchCondition('letter_created', $keyword, true, "OR", "LIKE");
}
$count = Letters::model()->count($criteria);
if (!empty($cnt)) {
return $count;
}
if ($pagination != 1) {
$result = Letters::model()->findAll($criteria);
return $result;
}
$pages = new CPagination($count);
// results per page
$pages->pageSize = Yii::app()->params['limit'];
$pages->applyLimit($criteria);
$result = Letters::model()->findAll($criteria);
return array('models' => $result, 'pages' => $pages);
}
public function actionPrintArea()
{
$documentary = Documentary::model()->searchByCondition($_GET, null, 2);
$wanted_abroad = WantedAbroad::model()->searchByCondition($_GET, null, 2);
$letters = Letters::model()->searchByCondition($_GET, null, 2);
$cases = Cases::model()->searchByCondition($_GET, null, 2);
$cases_abroad = CasesAbroadOther::model()->searchByCondition($_GET, null, 2);
$opinion = Opinion::model()->searchByCondition($_GET, null, 2);
$documentary_recieve = DocumentaryRecieve::model()->searchByCondition($_GET, null, 2);
$documentary_abroad = DocumentaryAbroad::model()->searchByCondition($_GET, null, 2);
$guide = Guide::model()->searchByCondition($_GET, null, 2);
$result = array('documentary' => $documentary, 'wanted_abroad' => $wanted_abroad, 'letters' => $letters, 'cases' => $cases, 'cases_abroad' => $cases_abroad, 'opinion' => $opinion, 'documentary_recieve' => $documentary_recieve, 'documentary_abroad' => $documentary_abroad, 'guide' => $guide);
$this->render('printArea', $result);
}
public function actionStatusUpdate($id)
{
$model=Letters::model()->findByPk($id);
if($model->status==0){
$model->updateByPk($id, array('status' => '1'));
}
Yii::app()->end();
}
<?php
/**
* Created by PhpStorm.
* User: Dushyant
* Date: 2016-01-12
* Time: 9:13 AM
*/
require_once '../../../Local/Classes/Letters.php';
extract($_GET);
$rxLater = new Letters();
//get doctor info to print
$doctorInfo = $rxLater->selectDoctorInfo($DoctorID);
$doctorInfo = mysqli_fetch_array($doctorInfo);
//Get patient details
$patientDetails = $rxLater->selectPatient($PateintID);
$patientDetails = mysqli_fetch_array($patientDetails);
//get exam details for print
$examDetails = $rxLater->selectExam($ExamID);
$examDetails = mysqli_fetch_array($examDetails);
$examLocation = $rxLater->getLocationName($ExamID);
//diagnosis
$rxDetails = $rxLater->selectDiagnosis($ExamID);
$rxDetails = mysqli_fetch_array($rxDetails);
?>
<html>
<head>
<title>Prescription</title>
<script src="../../../Local/Resources/ckeditor/ckeditor.js"></script>
</head>
<body>
<?php
/**
* Created by PhpStorm.
* User: Dushyant
* Date: 2016-01-12
* Time: 9:13 AM
*/
require_once '../../../Local/Classes/Letters.php';
extract($_GET);
$rxLater = new Letters();
//get doctor info to print
$doctorInfo = $rxLater->selectDoctorInfo($DoctorID);
$doctorInfo = mysqli_fetch_array($doctorInfo);
//Get patient details
$patientDetails = $rxLater->selectPatient($PateintID);
$patientDetails = mysqli_fetch_array($patientDetails);
//get exam details for print
$rxDetails = $rxLater->selectDiagnosis($ExamID);
$rxDetails = mysqli_fetch_array($rxDetails);
?>
<html>
<head>
<title>Prescription</title>
<script src="../../../Local/Resources/ckeditor/ckeditor.js"></script>
</head>
<body>
<form id="frm" method="get">
<div id="txtPrescription" style="height: 80%">
<div style="text-align: center">
