public function actionEdit($id) { if (Yii::$app->request->post()) { Ot::Update($id); } $apteka = Ur::find()->where(['id' => $id])->one(); $regionId = Ur::getRegionId($id); $db = new Query(); $db->from('preparats'); $db->where(['is_active' => 1, 'region_id' => $regionId]); $preparats = $db->all(); return $this->render('edit', ['preparats' => $preparats, 'id_apteka' => $id, 'apteka' => $apteka]); }
?> <table class="table"> <thead> <tr> <th> Препарат</th> <th> Производитель</th> <th> Наличие</th> <th> Закупка (уп.)</th> <th> Продажа (уп.)</th> </tr> </thead> <?php foreach ($preparats as $preparat) { $ot = Ot::Edit($apteka[id], $preparat['id']); print "<tr>"; print "<td>" . $preparat['name'] . "</td>"; print "<td>" . $preparat['manuf'] . "</td>"; print "<td>" . Html::checkbox("nal[{$preparat['id']}]", $ot['nal'] ? true : false) . "</td>"; print "<td>" . Html::input("text", "zakupka[{$preparat['id']}]", $ot['zakupka'], ['size' => '4']) . "</td>"; print "<td>" . Html::input("text", "prodaja[{$preparat['id']}]", $ot['prodaja'], ['size' => '4']) . "</td>"; print "</tr>"; } print "</table>"; print "<br><br>"; print Html::submitButton('Сохранить', ['class' => 'btn btn btn-success']); print "<pre>"; print_r($_POST); print "</pre>"; ?>
/** * Вывод отчетов EXCEL */ public function actionExcel($id = 11, $date = null) { $region_id = $id; $model = Ot::ListAptekiAnsverXml($region_id, $date); Excel::export(['models' => $model, 'headers' => ['rname' => 'Регион', 'username' => "Провизор-информатор", 'uname' => "Юридическое лицо", 'name' => "Ассортимент", 'nal' => 'Наличие', 'zakupka' => 'Закупка', 'prodaja' => 'Продажа'], 'columns' => ['rname', 'username', 'uname', 'name', 'nal', 'zakupka', 'prodaja']]); }