function AddItemToSql($values)
{
if ($values['name'] == "") {
throw new Exception("Musite vyplnit nazov");
}
$sequence = dibi::fetchSingle("SELECT MAX(sequence) as max FROM menu_item WHERE parent=%i", $values['parent'], " ORDER BY sequence") + 1;
if ($values['slug'] == "") {
$values['slug'] = $values['name'];
}
$values['slug'] = $this->url_identifier($values['slug'], '');
if ($values['parent'] == NULL) {
$values['parent'] = 0;
} else {
// $parent_url = self::getUrlIdentifier($values['parent']);
}
$collums = Tools::getCollum('menu_item');
foreach ($values as $k => $v) {
if (!in_array($k, $collums)) {
unset($values[$k]);
}
}
$values['id_menu'] = $this->id_menu;
dibi::query("INSERT INTO menu_item", $values);
$id_menu_item = dibi::insertId();
// self::doSequence($values ['parent']);
$this->repairUrls();
$this->pageModel->invalidateCache();
return $id_menu_item;
}