function impvuz_exec($Frm, $Err)
{
if (!$Err) {
$v = $Frm->GetValue(0);
if (!strpos($v["type"], "ms-excel")) {
$Frm->_gui->informer->ERR("Неправильный тип файла");
page_reloadSubSec();
} else {
$s = "";
if ($Frm->GetValue(1)) {
db::truncate(TABLE_VUZ);
$s = "Таблица очищена. ";
}
include_once "ext/Excel/reader.php";
$data = new Spreadsheet_Excel_Reader($v["tmp_name"]);
if ($data->sheets[0]['numCols'] != 3) {
$Frm->_gui->informer->ERR("В таблице должно быть 3 колонки");
page_reloadSubSec();
return;
}
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
VUZ::create(array('name' => htmlspecialchars($data->sheets[0]['cells'][$i][1]), 'sname' => htmlspecialchars($data->sheets[0]['cells'][$i][2]), 'addr' => htmlspecialchars($data->sheets[0]['cells'][$i][3])));
}
$Frm->_gui->informer->OK($s . "Добавлено " . $data->sheets[0]['numRows'] . " строк");
page_reloadSubSec();
}
}
}
$r->DoSort = true;
$r->Key = "id";
$r = $tbl->NewColumn();
$r->Caption = "Наименование";
$r->DoSort = true;
$r->Key = "sname";
$r->Align = "left";
$r = $tbl->NewColumn();
$r->Caption = "Полное наименование";
$r->DoSort = true;
$r->Key = "name";
$r->Align = "left";
$r = $tbl->NewColumn();
$r->Caption = "Адрес";
$r->DoSort = true;
$r->Key = "addr";
$r->Align = "left";
$r = $tbl->NewColumn();
$r->Caption = "";
$r->Process = "tp_vuz_cmds";
foreach (VUZ::findAll() as $d) {
$tbl->AddRow($d, "id");
}
$tbl->InlineSort(true);
if (user_can($GUI->mmenu->selected->id, $GUI->mmenu->selected->selected->id, $_SESSION["user"]["data"]["group_id"], "Добавить")) {
$GUI->cmdmenu->AddItem("Добавить", "?section=sprav&subsection=4&add");
}
if (user_can($GUI->mmenu->selected->id, $GUI->mmenu->selected->selected->id, $_SESSION["user"]["data"]["group_id"], "Импорт Excel")) {
$GUI->cmdmenu->AddItem("Импорт Excel", "?section=sprav&subsection=4&imp");
}
}
/**
* @deprecated
* @param $vuz_id
* @return array
*/
function get_vuz_name($vuz_id)
{
if ($vuz_id == 0) {
return array('name' => 'не определен', 'sname' => '');
}
return VUZ::find($vuz_id);
}
