/** * 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]); }