/**
* 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';
}
