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