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