/**
* 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';
}
/**
* getRowCount
*
* returns a count of rows
*
* @param string $rcsql
* a statement to return a count of rows for
* @param array $filters
* a set of applied filters
*
* @return int
* row count
*/
function getRowCount($rcsql, $filters = NULL)
{
list($first, $second) = explode('FROM', $rcsql, 2);
$rcquery = 'SELECT COUNT(*) AS c FROM ' . $second;
$rcresult = EasyContactFormsDB::select($rcquery, $filters);
return $rcresult[0]->c;
}
/**
* 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', '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';
}
/**
* 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';
}
/**
* moveRow
*
* moves a row up and down
*
* @param string $mrtype
* a type of object to move
* @param array $viewmap
* request values
* @param array $mrfilters
* optional filter values
* @param string $alias
* an alias to use when building a query
*/
function moveRow($mrtype, $viewmap, $mrfilters = array(), $alias = '')
{
if (!isset($viewmap['a'])) {
return;
}
$a = json_decode(stripslashes($viewmap['a']));
if (!isset($a->m) || $a->m != 'moveRow') {
return;
}
$mrrowid = intval($a->lpi);
$mr_direction = intval($a->lpd);
$lpsort = isset($a->srt) ? $a->srt : 'ASC';
$sort_direction = $lpsort == 'DESC' ? -1 : 1;
if ($mr_direction == $sort_direction) {
$func_name = "MAX";
$mrsign = "<";
} else {
$func_name = "MIN";
$mrsign = ">";
}
$obj = EasyContactFormsClassLoader::getObject($mrtype);
$t_name = $obj->getTableName();
$query = "SELECT ListPosition FROM {$t_name} WHERE id = '{$mrrowid}'";
$l_pos = EasyContactFormsDB::getValue($query);
$dot = $alias == '' ? '' : '.';
$as = $alias == '' ? '' : 'AS';
$mrfilters['fnames'][] = $alias . $dot . "ListPosition {$mrsign} :_l_pos";
$mrfilters['fvalues'][':_l_pos'] = $l_pos;
$query = "SELECT {$func_name}(ListPosition) AS lp FROM {$t_name} {$as} {$alias}";
$rs = EasyContactFormsDB::select($query, $mrfilters);
if (count($rs) > 0 && !empty($rs[0]->lp)) {
$c_pos = $rs[0]->lp;
$query = "SELECT id FROM {$t_name} WHERE ListPosition = {$c_pos}";
$c_oid = EasyContactFormsDB::getValue($query);
$valuemap['ListPosition'] = $c_pos;
EasyContactFormsDB::update($valuemap, $obj->type, $mrrowid);
$valuemap = array();
$valuemap['ListPosition'] = $l_pos;
EasyContactFormsDB::update($valuemap, $obj->type, $c_oid);
}
}
/**
* deletedocfile
*
* deletes a file accosiated with a particular object
*
* @param array $map
* request data
*/
function deletedocfile($map)
{
$values = array();
$values[':docid'] = intval($map['oid']);
$values[':docfield'] = $map['fld'];
$values[':doctype'] = $map['t'];
$query = "SELECT\n\t\t\t\tid\n\t\t\tFROM\n\t\t\t\t#wp__easycontactforms_files\n\t\t\tWHERE\n\t\t\t\tDocid=:docid\n\t\t\t\tAND Docfield=:docfield\n\t\t\t\tAND Doctype=:doctype";
$fileid = EasyContactFormsDB::select($query, array('fvalues' => $values));
if (count($fileid) == 0) {
return;
}
$fileid = $fileid[0]->id;
EasyContactFormsFiles::deletefile($fileid);
$query = "DELETE FROM #wp__easycontactforms_files WHERE id='{$fileid}';";
EasyContactFormsDB::query($query);
}
/**
* 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';
}
/**
* 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';
}
/**
* getBasicASList
*
* prepares data for ajax suggest lists
*
* @param array $_asmap
* request data
* @param string $query
* an sql statement to execute
*
* @return array
* array containing values prepared to be send via json
*/
function getBasicASList($_asmap, $query)
{
$values = array();
$_result = array();
$asinput = EasyContactFormsUtils::getASInput($_asmap);
if ($asinput) {
$values['fvalues'][':input'] = "%{$asinput->input}%";
$_limit = $asinput->limit;
$query = $query . ' ' . $_limit;
}
$_items = EasyContactFormsDB::select($query, $values);
foreach ($_items as $record) {
$_resultitem = array();
$_resultitem['id'] = $record->id;
$_resultitem['value'] = trim($record->Description);
$_resultitem['info'] = $this->getObjectASForm($record->id);
$_result[] = (object) $_resultitem;
}
return $_result;
}
/**
* 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';
}
