/**
* report for Medcenter
* @param integer $firm
*/
public function actionStatreport($firm)
{
$this->layout = 'main';
$results = [];
$firm_model = \app\models\Firms::find()->where(['id' => $firm])->one();
$patients = Patients::find()->where(['firm_id' => $firm])->all();
if ($patients) {
$results = $this->_reportStat($patients);
}
\app\models\Functions::statreportExcel('stat', 'report.ods', $results);
return $this->render('statreport', ['firm' => $firm_model->firm, 'res' => $this->statreportHtml($results), 'css' => file_get_contents('../web/css/print.css')]);
}
public function actionName()
{
$assort_array = ['Уважаемый', 'Уважаемая', 'Уважаемый'];
print Functions::accostName($assort_array, 'Пукась Анна Андреевич');
}
/**
* Creates a new UrQuestions model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new UrQuestions();
$model->user_id = \Yii::$app->user->identity->id;
$UrRecords = Ur::find()->orderBy('name');
if (\Yii::$app->user->identity->status == 2) {
$UrRecords = $UrRecords->Where(['regional_id' => \Yii::$app->user->identity->id]);
}
if (\Yii::$app->user->identity->status == 3) {
// $UrRecords = $UrRecords->Where(['pi_id' => \Yii::$app->user->identity->id]);
}
$UrRecords = $UrRecords->all();
//->where(['pi_id' => $user])
if (Yii::$app->request->isPost) {
// print_r($model->qfile);
$model->qfile = UploadedFile::getInstances($model, 'qfile');
if (!empty($model->qfile)) {
$model->qfiles = "";
foreach ($model->qfile as $file) {
$fileName = 'files/qfile/' . Functions::str2url($file->baseName) . rand(555, 99999) . '.' . $file->extension;
$model->qfiles .= $fileName . "|";
$file->saveAs($fileName);
}
$model->qfiles = substr($model->qfiles, 0, -1);
}
}
if ($model->load(Yii::$app->request->post()) && ($id = $model->save())) {
$info = UrQuestions::getInfo($model->id);
Word::ur_questions($info);
return $this->redirect(['index']);
} else {
return $this->render('create', ['model' => $model, 'UrRecords' => $UrRecords]);
}
}
public static function titlePdfName($name)
{
$assort_array = ['Уважаемый', 'Уважаемая', 'Уважаемый руководитель Аптечной организации'];
$return = Functions::accostName($assort_array, $name);
if ($return != 'Уважаемый руководитель Аптечной организации') {
$return .= " " . Functions::namePatronymic($name);
}
return $return;
}
public function update_table(Request $request)
{
if ($request->action == 'update') {
try {
$fun = Functions::where('ID', $request->col0)->update(['NAME' => $request->col1, 'PARENT' => $request->col2, 'LINK' => $request->col3, 'DESCRIPTION' => $request->col4]);
Log::info($fun);
if ($fun) {
return response(array('sukses bisa bro!!', $request->all()), 200)->header('Content-Type', 'application/json');
} else {
return response('There is no data changes!!', 400)->header('Content-Type', 'application/json');
}
} catch (PDOException $exception) {
Log::info($exception->getMessage());
return response('Proses Gagal!!', 400)->header('Content-Type', 'application/json');
}
}
if ($request->action == 'insert') {
try {
$fun = new Functions();
$fun->NAME = $request->col1;
$fun->PARENT = $request->col2;
$fun->LINK = $request->col3;
$fun->DESCRIPTION = $request->col4;
if ($fun->save()) {
$request->merge(array('col0' => $fun->id));
return response(array('sukses bisa bro!!', $request->all()), 200)->header('Content-Type', 'application/json');
} else {
return response('There is no data changes!!', 400)->header('Content-Type', 'application/json');
}
} catch (PDOException $exception) {
Log::info($exception->getMessage());
return response('Proses Gagal!!', 400)->header('Content-Type', 'application/json');
}
}
if ($request->action == 'delete') {
try {
$fun = Functions::where('ID', $request->col0);
if ($fun->delete()) {
return response(array('sukses bisa bro!!', $request->all()), 200)->header('Content-Type', 'application/json');
} else {
return response('There is no data changes!!', 400)->header('Content-Type', 'application/json');
}
} catch (PDOException $exception) {
Log::info($exception->getMessage());
return response('Proses Gagal!!', 400)->header('Content-Type', 'application/json');
}
}
//return response(array('sukses bisa bro!!'), 200)
return response('Proses Gagal!!', 400)->header('Content-Type', 'application/json');
}
/**
* загрузка файла с данными
* @return type
*/
public function actionUpload()
{
$model = new UploadForm();
if (Yii::$app->request->isPost) {
$model->file = UploadedFile::getInstance($model, 'file');
if (!$model->file || !in_array($model->file->extension, ['xls', 'ods'])) {
return $this->render('upload', ['model' => $model]);
}
$datetime = new \DateTime();
$filename = $datetime->format('Y_m_d_H_i_s') . '.' . $model->file->extension;
if ($model->validate() && $model->file->saveAs('/tmp/' . $filename)) {
$result = Functions::loadData('/tmp/' . $filename, $model->talon);
if (is_int($result)) {
$model->file->saveAs('../uploads/' . $filename);
unlink('/tmp/' . $filename);
$this->redirect(['//firms/view', 'id' => $result]);
} else {
unlink('/tmp/' . $filename);
$model->addError('file', $result);
}
}
}
return $this->render('upload', ['model' => $model]);
}
