/** * getMainView * * prepares the view data and finally passes it to the html template * * @param array $viewmap * request data */ function getMainView($viewmap) { $spar = $this->getOrder($viewmap); $orderby = EasyContactFormsDB::getOrderBy(array('id', 'Description'), $spar, "ContactTypes.Description"); $rparams = $this->getFilter($viewmap); $viewfilters = array(); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'ContactTypes.', 'id', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'ContactTypes.', 'Description'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'ContactTypes.', 'Notes'); EasyContactFormsRoot::mDelete('ContactTypes', $viewmap); $query = "SELECT\n\t\t\t\tContactTypes.id,\n\t\t\t\tContactTypes.Description\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_contacttypes AS ContactTypes"; $this->start = isset($viewmap['start']) ? intval($viewmap['start']) : 0; $this->limit = isset($viewmap['limit']) ? intval($viewmap['limit']) : 10; $this->rowCount = EasyContactFormsDB::getRowCount($query, $viewfilters); $resultset = EasyContactFormsDB::select($query, $viewfilters, $orderby, $this); $obj = $this; ?> <input type='hidden' name='t' id='t' value='ContactTypes'><?php require_once 'views/easy-contact-forms-contacttypesmainview.php'; }
/** * getMainView * * prepares the view data and finally passes it to the html template * * @param array $viewmap * request data */ function getMainView($viewmap) { $spar = $this->getOrder($viewmap); $sortfields = array('id', 'Date', 'CustomFormsDescription', 'UsersDescription', 'PageName', 'SiteUser'); $orderby = EasyContactFormsDB::getOrderBy($sortfields, $spar, "CustomFormsEntries.id DESC"); $rparams = $this->getFilter($viewmap); $viewfilters = array(); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'id', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'Date', 'date'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'Content'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'CustomForms', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'Users', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'SiteUser', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'PageName'); EasyContactFormsRoot::mDelete('CustomFormsEntries', $viewmap); $query = "SELECT\n\t\t\t\tCustomFormsEntries.id,\n\t\t\t\tCustomFormsEntries.Date,\n\t\t\t\tCustomFormsEntries.PageName,\n\t\t\t\tCustomFormsEntries.SiteUser,\n\t\t\t\tCustomForms.Description AS CustomFormsDescription,\n\t\t\t\tCustomFormsEntries.CustomForms AS CustomForms,\n\t\t\t\tCONCAT(Users.Description, ' ', Users.Name) AS UsersDescription,\n\t\t\t\tCustomFormsEntries.Users AS Users\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_customformsentries AS CustomFormsEntries\n\t\t\tLEFT JOIN\n\t\t\t\t#wp__easycontactforms_customforms AS CustomForms\n\t\t\t\t\tON\n\t\t\t\t\t\tCustomFormsEntries.CustomForms=CustomForms.id\n\t\t\tLEFT JOIN\n\t\t\t\t#wp__easycontactforms_users AS Users\n\t\t\t\t\tON\n\t\t\t\t\t\tCustomFormsEntries.Users=Users.id"; $this->start = isset($viewmap['start']) ? intval($viewmap['start']) : 0; $this->limit = isset($viewmap['limit']) ? intval($viewmap['limit']) : 10; $this->rowCount = EasyContactFormsDB::getRowCount($query, $viewfilters); $resultset = EasyContactFormsDB::select($query, $viewfilters, $orderby, $this); $this->Users = (object) array(); $this->Users->view = $this; $this->Users->field = 'Users'; $this->Users->filter = TRUE; $this->Users->config['m2'] = 'getUserASList'; $this->Users->config['t'] = 'Users'; $this->Users->asparams['listItemClass'] = 'ufo-user-list-item'; $this->Users->inpstyle = " style='width:130px;'"; $this->SiteUser = (object) array(); $this->SiteUser->view = $this; $this->SiteUser->field = 'SiteUser'; $this->SiteUser->filter = TRUE; $this->SiteUser->config['t'] = 'Users'; $this->SiteUser->config['m2'] = 'getEUserASList'; $this->SiteUser->inpstyle = " style='width:130px;'"; $this->mdeleteconfig = '{messageText:"' . EasyContactFormsT::get('ItwillDeleteRecordsAndFilesAreYouSure') . '"}'; $obj = $this; ?> <input type='hidden' name='t' id='t' value='CustomFormsEntries'><?php include 'views/easy-contact-forms-customformsentriesmainview.php'; }
/** * getUsersMainView * * prepares the view data and finally passes it to the html template * * @param array $viewmap * request data */ function getUsersMainView($viewmap) { $spar = $this->getOrder($viewmap); $orderby = EasyContactFormsDB::getOrderBy(array('id', 'CustomFormsDescription'), $spar); $rparams = $this->getFilter($viewmap); $viewfilters = array(); $viewfilters = EasyContactFormsDB::getFilter($viewfilters, $rparams, 'CustomForms_MailingLists.', 'Contacts', '=', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomForms_MailingLists.', 'CustomForms', 'int'); EasyContactFormsRoot::mDelete('CustomForms_MailingLists', $viewmap); $query = "SELECT\n\t\t\t\tCustomForms_MailingLists.id,\n\t\t\t\tCustomForms.Description AS CustomFormsDescription,\n\t\t\t\tCustomForms_MailingLists.CustomForms AS CustomForms\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_customforms_mailinglists AS CustomForms_MailingLists\n\t\t\tLEFT JOIN\n\t\t\t\t#wp__easycontactforms_customforms AS CustomForms\n\t\t\t\t\tON\n\t\t\t\t\t\tCustomForms_MailingLists.CustomForms=CustomForms.id"; $this->start = isset($viewmap['start']) ? intval($viewmap['start']) : 0; $this->limit = isset($viewmap['limit']) ? intval($viewmap['limit']) : 10; $this->rowCount = EasyContactFormsDB::getRowCount($query, $viewfilters); $resultset = EasyContactFormsDB::select($query, $viewfilters, $orderby, $this); $this->objid = $rparams['Contacts']->values[0]; $obj = $this; ?> <input type='hidden' name='t' id='t' value='CustomForms_MailingLists'><?php include 'views/easy-contact-forms-customforms_mailinglistsusersmainview.php'; }
/** * getManageMainView * * prepares the view data and finally passes it to the html template * * @param array $viewmap * request data */ function getManageMainView($viewmap) { $spar = $this->getOrder($viewmap); $orderby = EasyContactFormsDB::getOrderBy(array('id', 'Description', 'Name'), $spar, "Users.Description"); $rparams = $this->getFilter($viewmap); $viewfilters = array(); $viewfilters = EasyContactFormsDB::getMTMFilter($viewmap, $viewfilters, 'Users'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'Users.', 'id', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'Users.', 'Description'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'Users.', 'Name'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'Users.', 'ContactType', 'int'); $query = "SELECT\n\t\t\t\tUsers.id,\n\t\t\t\tUsers.Description,\n\t\t\t\tUsers.Name\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_users AS Users"; $this->start = isset($viewmap['start']) ? intval($viewmap['start']) : 0; $this->limit = isset($viewmap['limit']) ? intval($viewmap['limit']) : 10; $this->rowCount = EasyContactFormsDB::getRowCount($query, $viewfilters); $resultset = EasyContactFormsDB::select($query, $viewfilters, $orderby, $this); $this->showlist = FALSE; $obj = $this; ?> <input type='hidden' name='t' id='t' value='Users'><?php include 'views/easy-contact-forms-usersmanagemainview.php'; }
/** * getMainView * * prepares the view data and finally passes it to the html template * * @param array $viewmap * request data */ function getMainView($viewmap) { $spar = $this->getOrder($viewmap); $sortfields = array('id', 'Date', 'CustomFormsDescription', 'CustomFormsEntriesDescription', 'Description'); $orderby = EasyContactFormsDB::getOrderBy($sortfields, $spar, "DataSource.id DESC"); $rparams = $this->getFilter($viewmap); $viewfilters = array(); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'DataSource.', 'id', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'DataSource.', 'Description'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'DataSource.', 'Date', 'date'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'DataSource.', 'CustomFormsEntries', 'int'); $viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'DataSource.', 'CustomForms', 'int'); EasyContactFormsRoot::mDelete('CustomFormEntryFiles', $viewmap); $query = "SELECT\n\t\t\t\tDataSource.id,\n\t\t\t\tDataSource.CustomFormsEntries,\n\t\t\t\tDataSource.CustomFormsEntriesDescription,\n\t\t\t\tDataSource.Description,\n\t\t\t\tDataSource.Date,\n\t\t\t\tDataSource.CustomForms,\n\t\t\t\tDataSource.CustomFormsDescription\n\t\t\tFROM(\n\t\t\t\tSELECT\n\t\t\t\t\tCustomFormEntryFiles.id AS id,\n\t\t\t\t\tCustomFormEntryFiles.CustomFormsEntries AS CustomFormsEntriesDescription,\n\t\t\t\t\tCustomFormEntryFiles.CustomFormsEntries AS CustomFormsEntries,\n\t\t\t\t\tCustomFormEntryFiles.Description AS Description,\n\t\t\t\t\tCustomFormEntryFiles.Date AS Date,\n\t\t\t\t\tCustomForms.id AS CustomForms,\n\t\t\t\t\tCustomForms.Description AS CustomFormsDescription\n\t\t\t\tFROM\n\t\t\t\t\t#wp__easycontactforms_customformentryfiles AS CustomFormEntryFiles\n\t\t\t\tLEFT JOIN\n\t\t\t\t\t#wp__easycontactforms_customformsentries AS CustomFormsEntries\n\t\t\t\tLEFT JOIN\n\t\t\t\t\t#wp__easycontactforms_customforms AS CustomForms\n\t\t\t\t\t\tON\n\t\t\t\t\t\t\tCustomFormsEntries.CustomForms=CustomForms.id\n\t\t\t\t\t\tON\n\t\t\t\t\t\t\tCustomFormEntryFiles.CustomFormsEntries=CustomFormsEntries.id) AS DataSource"; $this->start = isset($viewmap['start']) ? intval($viewmap['start']) : 0; $this->limit = isset($viewmap['limit']) ? intval($viewmap['limit']) : 10; $this->rowCount = EasyContactFormsDB::getRowCount($query, $viewfilters); $resultset = EasyContactFormsDB::select($query, $viewfilters, $orderby, $this); $this->mdeleteconfig = '{messageText:"' . EasyContactFormsT::get('ItwillDeleteRecordsAndFilesAreYouSure') . '"}'; $obj = $this; ?> <input type='hidden' name='t' id='t' value='CustomFormEntryFiles'><?php require_once 'views/easy-contact-forms-customformentryfilesmainview.php'; }