public function genformAction()
{
$generic = new Model_Generic();
$table = $this->_getParam('tbl');
/***$protected_tables = array("users","merchandisers","outlets","agents","activity_logs","users_access");
if(in_array($table,$protected_tables) && $authsession->user_access != 1){
$this->_redirect('/index/');
//$this->view->disable_input = 1;
}
if(in_array($table,$protected_tables)){
$this->view->disable_input = 1;
}***/
//process form
if ($_POST) {
$data = $_POST;
$save = $generic->insertData($table, $data);
$this->view->saveMsg = array('success', 'Successfully Saved.');
$this->_redirect('/encoder/genform/tbl/' . $table);
}
$list = $generic->getData($table, null, "ID", null);
$paginator = Zend_Paginator::factory($list);
$curPage = $this->_getParam('page', 1);
$paginator->setItemCountPerPage(10);
$paginator->setCurrentPageNumber($curPage);
$this->view->list = $paginator;
$this->view->table = $table;
$generic_call = $generic->genericForm($table);
$this->view->genform = $generic_call;
}
public function userdisplayAction()
{
$user = new Model_User();
$generic = new Model_Generic();
if ($_POST) {
$advdep = str_replace(array('-', '+'), '', $_POST['StoreCredits']);
unset($_POST['StoreCredits']);
if (is_numeric($advdep) && $advdep != 0) {
$advdep = isset($_POST['selAD']) && $_POST['selAD'] == 'add' ? $advdep : $advdep * -1;
$AdvanceDepositUsageHistoryData = array();
$AdvanceDepositUsageHistoryData['EventDate'] = date('Y-m-d H:i:s');
$AdvanceDepositUsageHistoryData['Event'] = 'Advance Deposit';
$AdvanceDepositUsageHistoryData['Amount'] = $advdep;
$AdvanceDepositUsageHistoryData['TransactionID'] = 'N/A';
$AdvanceDepositUsageHistoryData['SiteUserID'] = $_POST['UserID'];
$generic->insertData('AdvanceDepositUsageHistory', $AdvanceDepositUsageHistoryData);
$_POST['StoreCredits'] = $_POST['StoreCreditsBeforeSubmit'] + $advdep;
}
unset($_POST['StoreCreditsBeforeSubmit']);
unset($_POST['selAD']);
$user->updateUserInfo($_POST);
$user_id = $_POST['UserID'];
$this->_redirect("/admin/userdisplay/ID/" . $user_id . '/?sysmsg=success');
}
if ($this->_getParam('ID')) {
$user_id = isset($_POST['UserID']) ? $_POST['UserID'] : $this->_getParam('ID');
$data = $user->oldSkul("select * from SiteUsers left join ResellerApplications on ResellerApplications.SiteUserID = SiteUsers.ID where SiteUsers.ID=" . $user_id . " and anAdmin != 1");
$this->view->data = isset($data[0]) ? $data[0] : 0;
$this->view->advanceDepositHistory = $generic->oldSkul("select * from AdvanceDepositUsageHistory where SiteUserID=" . $user_id . " order by EventDate");
}
$states = $user->getData('Shipping', '', 'State');
$states_fin = array();
foreach ($states as $row) {
$states_fin[$row['ID']] = $row['State'];
}
$this->view->States = $states_fin;
}
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);
}
}