/** * Updates an existing ValidationParams model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $model = $this->findModel($id); $main = ValidationMain::find()->all(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['index', 'id' => $model->id]); } else { return $this->render('update', ['model' => $model, 'main' => $main]); } }
public static function generateTablePdf($id) { $mains = ValidationMain::find()->orderBy('npp')->all(); $html1 = ""; $html1 .= "\n<style>\nbody{\n\n \n font-size: 16px;\n font-family: 'open', sans-serif;\n\n\n \n\n}\n\nspan{\nfont-size: 17px;\nfont-family: 'roboto', sans-serif;\n}\n\ntd{\nbackground-color:#fff;\nfont-size: 14px;\nfont-family: 'open', sans-serif;\n\n}\n.main td{\nbackground-color:#64b5f6;\nfont-size: 15px;\nfont-family: 'roboto', sans-serif;\n}\n.main2 td{\nbackground-color:#87cefa;\n}\n.header{\nline-height:30px;\n}\nh1,h2,h3,h4{\nfont-family: 'roboto', sans-serif;\n color: #c62828;\n\n\n}\n\n</style>\n\n<body>\n<div id=\"background\">\n<div align='center'><img src=\"http://sojuzpharma.ru/images/logo_04.jpg\"></div><br>"; $table = ""; $priceAll = 0; // $table.= "<pagebreak />"; foreach ($mains as $main) { $params = ValidationParams::find()->where(['validation_main_id' => $main['id']])->all(); $table2 = ''; foreach ($params as $param) { $err = null; //$violations = Validationviolation::find()->where(['validation_params_id' => $param['id']])->all(); $query = new Query(); $query->select('validation_violation.name,validation_violation.price'); $query->InnerJoin('validation_report_violation', 'validation_report_violation.`violation_id`=validation_violation.id'); $query->where(['report_id' => $id]); $query->andWhere(['validation_params_id' => $param['id']]); $query->from('validation_violation'); $val = $query->all(); if (count($val) > 0) { $table2 .= ""; $table2 .= "<tr>"; $table2 .= "<td rowspan='" . count($val) . "' width=10.5%>" . $param['name'] . "</td>"; $table2 .= "<td width='15%'>" . $val[0]['name'] . "</td>"; if ($val[0]['price'] == "") { $table2 .= "<td rowspan='" . count($val) . "' align='center'><b>" . $param['price'] . "</b></td>"; $priceAll = $priceAll + $param['price']; } else { $table2 .= "<td align='center'><b>" . $val[0]['price'] . "<b></td>"; $priceAll = $priceAll + $val[0]['price']; } $table2 .= "<td rowspan='" . count($val) . "' valign=top>" . $param['nd'] . "</td>"; $table2 .= "<td rowspan='" . count($val) . "' valign=top width=45%>" . $param['sankcii'] . "</td>"; $table2 .= "</tr>\n"; $n = 0; foreach ($val as $violation) { if ($n != 0) { $table2 .= "<tr nobr=\"false\">"; $table2 .= "<td>" . $violation['name'] . "</td>"; if ($violation['price'] != "") { $table2 .= "<td align='center'><b>" . $violation['price'] . "</b></td>"; $priceAll = $priceAll + $violation['price']; } $table2 .= "</tr>\n"; } $n++; } $err = 1; } } if ($table2) { $table .= ""; $table .= "<h4 align='center'>" . $main['name'] . "</h4>"; $table .= "<table border='1' cellpadding='3' cellspacing='0' width='100%'>"; $table .= "<thead><tr align='center' class='main'>"; $table .= "<td align='center'>Проверяемый параметр</td>"; $table .= "<td align='center'>Выявленные нарушения</td>"; $table .= "<td align='center'>Риск применения санкций для юр.лица (max)</td>"; $table .= "<td align='center'>п. НД, регламентирующий указанное в колонке 2 требование</td>"; $table .= "<td align='center'>Риск применения санкций возможный контролирующий орган, ст. КоАП и др…</td>"; $table .= "</tr></thead>\n\n"; $table .= "<tr align='center' class='main2'>"; //$table .= "<td colspan='5'>" . $main['name'] . "</td>"; $table .= "</tr>"; $table .= $table2; $table .= "</table>"; } } $table .= "</div></body>"; $query = new Query(); $query->select('validation_report.`created_at`,ur_l.`name`,apteki.`address`,users.`username`'); $query->InnerJoin('apteki', 'apteki.id = validation_report.`apteka_id` '); $query->InnerJoin('ur_l', 'apteki.ur_l_id = ur_l.id'); $query->LeftJoin('users', 'users.id = validation_report.user_id'); $query->where(['validation_report.id' => $id]); $query->from('validation_report'); $val = $query->one(); $dat = new \DateTime($val['created_at']); $dat2 = $dat->format('d.m.Y'); $html2 = ""; $html2 .= "<h1 align='CENTER'>АКТ ОБСЛЕДОВАНИЯ АПТЕЧНОГО УЧРЕЖДЕНИЯ </h1>"; $html2 .= "<h4 align='CENTER'>В РАМКАХ ПРОЕКТА ФАРМОПЕКА (конфиденциально, только для внутреннего пользования) </h4>"; $html2 .= "<br><br><div class='header'>"; $html2 .= "<span>Дата проверки: </span>" . $dat2; $html2 .= "<br><br>"; $html2 .= "<span>Юридическое лицо: </span>" . $val['name']; $html2 .= "<br>"; $html2 .= "<span>Адрес объекта:</span> " . $val['address']; $html2 .= "<br>"; $html2 .= "<span>ФИО инспектирующего лица: </span>" . $val['username']; $html2 .= "<br>"; $html2 .= "<br><br><br><br>"; $html2 .= "<span>Выявлены несоответствия (графа 2) в соблюдение лицензионных условий и фармацевтического порядка на сумму <b>" . \number_format($priceAll, 0) . "</b> руб.</span>"; $html2 .= "</div>"; $html = $html1 . $html2 . $table; return $html; }
/* @var $searchModel app\models\ValidationSearch */ /* @var $dataProvider yii\data\ActiveDataProvider */ $this->title = 'Проверяемые параметры'; $this->params['breadcrumbs'][] = ['label' => 'Обследование аптечного учреждения', 'url' => ['/validation/index']]; $this->params['breadcrumbs'][] = $this->title; ?> <div class="validation-params-index"> <?php // echo $this->render('_search', ['model' => $searchModel]); ?> <div align="center"> <?php $drop = ValidationMain::find()->select(['name', 'id'])->indexBy('id')->orderBy('npp')->column(); echo Html::dropdownList('region', $main, $drop, ['class' => 'form-control', 'id' => 'main', 'prompt' => 'Модуль']); ?> </div> <script> $(document).ready(function () { $('#main').change(function () { window.location.href = '?main=' + this.value; }); }); </script>
/** * Finds the ValidationMain model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return ValidationMain the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = ValidationMain::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }