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