public function genupdAction() { $generic = new Model_Generic(); $table = $this->_getParam('tbl'); $key_name = $this->_getParam('kn'); $key_value = $this->_getParam('kv'); $knkv = array('kn' => $key_name, 'kv' => $key_value, 'tbl' => $table); $this->view->knkv = $knkv; $cond = $key_name . "=" . $key_value; $data = $generic->getData($table, $cond); $this->view->data = $data; $this->view->table_properties = $generic->tableProperties($table); // if form is submiited if ($_POST) { $newdata = $_POST; $key = $cond; // update data $genupd = $generic->updateData($table, $newdata, $key); $this->_redirect('/encoder/genform/tbl/' . $table); } }
private function categories() { $generic = new Model_Generic(); return $generic->getData('Category', '', 'Name'); }
private function getProductAttributes($product_id) { $generic = new Model_Generic(); $product_attributes = $generic->getData('ProductAttributes', 'ProductID=' . $product_id); $data = array(); foreach ($product_attributes as $row => $val) { //print_r( $row); $data[$val['Name']] = $val; } return $data; }
public function signupAction() { $this->_helper->layout()->setLayout('redesign-2014'); //redirect logged in users if ($this->isLoggedIn()) { $this->_redirect('/profile/'); } $this->view->msg = ''; $this->view->success = 0; $generic = new Model_Generic(); $this->view->states = $generic->getData("Shipping", "", "State asc"); if ($_POST) { $user = new Model_User(); $new_user = $user->registerUser($_POST); if (!is_array($new_user) && $new_user > 0) { $this->view->success = 1; $this->view->msg = 'Thank you for signing up. You can now <a href="/login/">login</a> as ' . $_POST['SiteUsername']; } else { foreach ($_POST as $field => $val) { $this->view->{$field} = $val; } $this->view->msg = $new_user['msg']; } } }
public function menuAction() { $isAdmin = $this->isAdmin(); $generic = new Model_Generic(); $this->view->menus = $generic->getData("Menu"); $menu_id = isset($_GET['mid']) ? $_GET['mid'] : 0; $this->view->menu_id = $menu_id; $menu_items = $generic->getData("MenuItems", "MenuID=" . $menu_id, "CustomOrder"); $this->view->menu_items = $menu_items; if ($_POST) { if (isset($_POST['MenuEdit'])) { $menu_id = $_POST['MenuID']; $data = array(); foreach ($_POST['Name'] as $row => $val) { $data[$row]['MenuID'] = $menu_id; $data[$row]['Name'] = $val; } foreach ($_POST['Link'] as $row => $val) { $data[$row]['Link'] = $val; } foreach ($_POST['CustomOrder'] as $row => $val) { $data[$row]['CustomOrder'] = $val; } $delete = $generic->oldSkul("delete from MenuItems where MenuID = " . $menu_id, false); foreach ($data as $updatemenu) { $generic->insertData("MenuItems", $updatemenu); } $this->_redirect('/page/menu/?mid=' . $_POST['MenuID']); } if (isset($_POST['MenuAdd'])) { unset($_POST['MenuAdd']); $save = $generic->insertData("MenuItems", $_POST); if ($save) { $this->_redirect('/page/menu/?mid=' . $_POST['MenuID']); } } } if (isset($_GET['mitid'])) { $generic->oldSkul("delete from MenuItems where ID = " . $_GET['mitid'], false); $this->_redirect('/page/menu/?mid=' . $menu_id); } }