/**
* getSignFilter
*
* prepares a comparison operator based statement, reading the operator
* value from the incoming request
*
* @param array $filters
* a filter array to add values to
* @param array $rparams
* incoming request filters
* @param string $alias
* object alias to use when building the statement
* @param string $pttype
* object type
* @param string $datatype
* data type
* @param string $defaultvalue
* default value
*
* @return array
* comparison statement
*/
function getSignFilter($filters, $rparams, $alias, $pttype, $datatype = NULL, $defaultvalue = NULL)
{
$novalue = !isset($rparams[$pttype]) || empty($rparams[$pttype]);
if ($novalue) {
return $filters;
}
$value = $rparams[$pttype];
if (!isset($value->sign) || empty($value->sign)) {
return $filters;
}
$sign = intval($value->sign);
if ($sign == '10') {
return $filters;
}
$sign = EasyContactFormsDB::getSign($sign);
return EasyContactFormsDB::getFilter($filters, $rparams, $alias, $pttype, $sign, $datatype, $defaultvalue);
}
/**
* getDetailedMainView
*
* prepares the view data and finally passes it to the html template
*
* @param array $viewmap
* request data
*/
function getDetailedMainView($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::getFilter($viewfilters, $rparams, 'CustomFormsEntries.', 'CustomForms', '=', 'int');
$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.', '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-customformsentriesdetailedmainview.php';
}
/**
* getDetailedMainView
*
* prepares the view data and finally passes it to the html template
*
* @param array $viewmap
* request data
*/
function getDetailedMainView($viewmap)
{
$orderby = ' ORDER BY CustomFormEntryStatistics.CustomForms, CustomFormEntryStatistics.PageName';
$rparams = $this->getFilter($viewmap);
$viewfilters = array();
$viewfilters = EasyContactFormsDB::getFilter($viewfilters, $rparams, 'CustomFormEntryStatistics.', 'IncludeIntoReporting', '=', 'boolean', (object) array('values' => array(FALSE)));
$viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormEntryStatistics.', 'PageName');
$viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormEntryStatistics.', 'CustomForms', 'int');
$query = "SELECT\n\t\t\t\tCustomFormEntryStatistics.id,\n\t\t\t\tCustomFormEntryStatistics.CustomForms,\n\t\t\t\tCustomFormEntryStatistics.PageName,\n\t\t\t\tCustomFormEntryStatistics.Impressions,\n\t\t\t\tCustomFormEntryStatistics.TotalEntries,\n\t\t\t\tCustomFormEntryStatistics.TotalEntries/CustomFormEntryStatistics.Impressions*100 AS Conversion,\n\t\t\t\tCustomFormEntryStatistics.IncludeIntoReporting,\n\t\t\t\tCustomForms.Description AS CustomFormsDescription\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_customformentrystatistics AS CustomFormEntryStatistics\n\t\t\t\tINNER JOIN(\n\t\t\t\tSELECT\n\t\t\t\t\tCustomForms.id AS id,\n\t\t\t\t\tCustomForms.Description AS Description\n\t\t\t\tFROM\n\t\t\t\t\t#wp__easycontactforms_customforms AS CustomForms\n\t\t\t\tWHERE\n\t\t\t\t\tCustomForms.IncludeIntoReporting=TRUE) AS CustomForms\n\t\t\t\t\tON\n\t\t\t\t\t\tCustomFormEntryStatistics.CustomForms=CustomForms.id";
$resultset = EasyContactFormsDB::select($query, $viewfilters, $orderby);
$this->CustomForms = $this->getCustomFormsList();
$obj = $this;
?>
<input type='hidden' name='t' id='t' value='CustomFormEntryStatistics'><?php
require_once 'views/easy-contact-forms-customformentrystatisticsdetailedmainview.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';
}
/**
* getDetailedMainView
*
* prepares the view data and finally passes it to the html template
*
* @param array $viewmap
* request data
*/
function getDetailedMainView($viewmap)
{
$spar = $this->getOrder($viewmap);
$orderby = EasyContactFormsDB::getOrderBy(array('id', 'Description', 'CustomFormsEntriesDescription'), $spar, "CustomFormEntryFiles.Description");
$rparams = $this->getFilter($viewmap);
$viewfilters = array();
$viewfilters = EasyContactFormsDB::getFilter($viewfilters, $rparams, 'CustomFormEntryFiles.', 'CustomFormsEntries', '=', 'int');
EasyContactFormsRoot::mDelete('CustomFormEntryFiles', $viewmap);
$query = "SELECT\n\t\t\t\tCustomFormEntryFiles.id,\n\t\t\t\tCustomFormEntryFiles.Description,\n\t\t\t\tCustomFormsEntries.Description AS CustomFormsEntriesDescription,\n\t\t\t\tCustomFormEntryFiles.CustomFormsEntries AS CustomFormsEntries\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_customformentryfiles AS CustomFormEntryFiles\n\t\t\tLEFT JOIN\n\t\t\t\t#wp__easycontactforms_customformsentries AS CustomFormsEntries\n\t\t\t\t\tON\n\t\t\t\t\t\tCustomFormEntryFiles.CustomFormsEntries=CustomFormsEntries.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->mdeleteconfig = '{messageText:"' . EasyContactFormsT::get('ItwillDeleteRecordsAndFilesAreYouSure') . '"}';
$obj = $this;
?>
<input type='hidden' name='t' id='t' value='CustomFormEntryFiles'><?php
require_once 'views/easy-contact-forms-customformentryfilesdetailedmainview.php';
}
/**
* getDetailedMainView
*
* prepares the view data and finally passes it to the html template
*
* @param array $viewmap
* request data
*/
function getDetailedMainView($viewmap)
{
$rparams = $this->getFilter($viewmap);
$viewfilters = array();
$viewfilters = EasyContactFormsDB::getFilter($viewfilters, $rparams, 'CustomFormFields.', 'CustomForms', '=', 'int');
$viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormFields.', 'Description');
$viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormFields.', 'Type', 'int');
$viewfilters = EasyContactFormsDB::getSignFilter($viewfilters, $rparams, 'CustomFormFields.', 'FieldSet', 'int');
EasyContactFormsRoot::mDelete('CustomFormFields', $viewmap);
$query = "SELECT\n\t\t\t\tCustomFormFields.id,\n\t\t\t\tCustomFormFields.Description,\n\t\t\t\tCustomFormFields.ListPosition,\n\t\t\t\tCustomFormFields.CssClass,\n\t\t\t\tCustomFormFields.TypeDescription,\n\t\t\t\tCustomFormFields.FieldSet,\n\t\t\t\tCustomFormFields.CustomForms,\n\t\t\t\tCustomFormFields.Type,\n\t\t\t\tCustomFormFields.FieldSetListPosition,\n\t\t\t\tCustomFormFields.Container\n\t\t\t\tFROM(\n\t\t\t\tSELECT\n\t\t\t\t\tCustomFormFields.id,\n\t\t\t\t\tCustomFormFields.Description,\n\t\t\t\t\tCustomFormFields.ListPosition,\n\t\t\t\t\tCustomFormFieldTypes.CssClass,\n\t\t\t\t\tCustomFormFieldTypes.Description AS TypeDescription,\n\t\t\t\t\tCustomFormFields.FieldSet,\n\t\t\t\t\tCustomFormFields.CustomForms,\n\t\t\t\t\tCustomFormFields.Type,\n\t\t\t\t\tFieldSetListPosition.ListPosition AS FieldSetListPosition,\n\t\t\t\t\tIF(CustomFormFields.Type=1\n\t\t\t\t\t\tOR CustomFormFields.Type=2,\n\t\t\t\t\t\t1,\n\t\t\t\t\t\t0) AS Container\n\t\t\t\tFROM\n\t\t\t\t\t#wp__easycontactforms_customformfields AS CustomFormFields\n\t\t\t\tLEFT JOIN\n\t\t\t\t\t#wp__easycontactforms_customformfieldtypes AS CustomFormFieldTypes\n\t\t\t\t\t\tON\n\t\t\t\t\t\t\tCustomFormFields.Type=CustomFormFieldTypes.id\n\t\t\t\t\tLEFT JOIN(\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tCustomFormFields.id,\n\t\t\t\t\t\tCustomFormFields.ListPosition\n\t\t\t\t\tFROM\n\t\t\t\t\t\t#wp__easycontactforms_customformfields AS CustomFormFields) AS FieldSetListPosition\n\t\t\t\t\t\tON\n\t\t\t\t\t\t\tFieldSetListPosition.id=CustomFormFields.FieldSet\n\t\t\t\tORDER BY\n\t\t\t\t\tFieldSetListPosition,\n\t\t\t\t\tContainer DESC,\n\t\t\t\t\tListPosition) AS CustomFormFields";
$this->start = isset($viewmap['start']) ? intval($viewmap['start']) : 0;
$this->limit = isset($viewmap['limit']) ? intval($viewmap['limit']) : 500;
$this->rowCount = EasyContactFormsDB::getRowCount($query, $viewfilters);
$resultset = EasyContactFormsDB::select($query, $viewfilters, NULL, $this);
$params = array();
$params['CustomForms'] = $rparams['CustomForms']->values[0];
$this->FieldSet = $this->getFieldSetList($params);
$obj = $this;
?>
<input type='hidden' name='t' id='t' value='CustomFormFields'><?php
include 'views/easy-contact-forms-customformfieldsdetailedmainview.php';
}
