/** * */ public function preparePage() { $this->P = new \HaaseIT\HCSF\CorePage($this->serviceManager); $this->P->cb_pagetype = 'content'; $this->P->cb_subnav = 'admin'; $this->P->cb_customcontenttemplate = 'shop/itemadmin'; if (isset($this->get["action"]) && $this->get["action"] == 'insert_lang') { $aItemdata = $this->admin_getItem(); if (isset($aItemdata["base"]) && !isset($aItemdata["text"])) { $aData = ['itml_pid' => $aItemdata["base"]['itm_id'], 'itml_lang' => HelperConfig::$lang]; $sql = DBTools::buildInsertQuery($aData, 'item_lang'); $this->db->exec($sql); header('Location: /_admin/itemadmin.html?itemno=' . $this->get["itemno"] . '&action=showitem'); die; } } $this->P->cb_customdata["searchform"] = $this->admin_prepareItemlistsearchform(); if (isset($this->get["action"])) { if ($this->get["action"] == 'search') { $this->P->cb_customdata["searchresult"] = true; if ($aItemlist = $this->admin_getItemlist()) { if (count($aItemlist["data"]) == 1) { $aItemdata = $this->admin_getItem($aItemlist["data"][0]['itm_no']); $this->P->cb_customdata["item"] = $this->admin_prepareItem($aItemdata); } else { $this->P->cb_customdata["itemlist"] = $this->admin_prepareItemlist($aItemlist); } } } elseif (isset($this->post["doaction"]) && $this->post["doaction"] == 'edititem') { $this->admin_updateItem(\HaaseIT\HCSF\Helper::getPurifier('item')); $this->P->cb_customdata["itemupdated"] = true; $aItemdata = $this->admin_getItem(); $this->P->cb_customdata["item"] = $this->admin_prepareItem($aItemdata); } elseif ($this->get["action"] == 'showitem') { $aItemdata = $this->admin_getItem(); $this->P->cb_customdata["item"] = $this->admin_prepareItem($aItemdata); } elseif ($this->get["action"] == 'additem') { $aErr = []; if (isset($this->post["additem"]) && $this->post["additem"] == 'do') { if (strlen($this->post["itemno"]) < 4) { $aErr["itemnotooshort"] = true; } else { $sql = 'SELECT itm_no FROM item_base WHERE itm_no = \''; $sql .= \trim(\filter_input(INPUT_POST, 'itemno', FILTER_SANITIZE_SPECIAL_CHARS)) . "'"; $hResult = $this->db->query($sql); $iRows = $hResult->rowCount(); if ($iRows > 0) { $aErr["itemnoalreadytaken"] = true; } else { $aData = ['itm_no' => trim(\filter_input(INPUT_POST, 'itemno', FILTER_SANITIZE_SPECIAL_CHARS))]; $sql = DBTools::buildInsertQuery($aData, 'item_base'); $this->db->exec($sql); $iInsertID = $this->db->lastInsertId(); $sql = 'SELECT itm_no FROM item_base WHERE itm_id = ' . $iInsertID; $hResult = $this->db->query($sql); $aRow = $hResult->fetch(); header('Location: /_admin/itemadmin.html?itemno=' . $aRow['itm_no'] . '&action=showitem'); die; } } } $this->P->cb_customdata["showaddform"] = true; $this->P->cb_customdata["err"] = $aErr; } } }
public function insert($iParentID) { $aData = ['cl_cb' => $iParentID, 'cl_lang' => HelperConfig::$lang]; $sql = DBTools::buildInsertQuery($aData, 'content_lang'); $this->serviceManager->get('db')->exec($sql); }
/** * @param $sKey * @return mixed */ public function addTextKey($sKey) { $aData = ['tc_key' => trim(filter_var($sKey, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW))]; $sql = \HaaseIT\DBTools::buildInsertQuery($aData, 'textcat_base'); $this->DB->exec($sql); $iId = $this->DB->lastInsertId(); return $iId; }