PHP acymailing_getColumns函数代码示例

		function getInput() {
			$fields = acymailing_getColumns('#__virtuemart_userinfos');

			$dropdown = array();
			foreach($fields as $oneField => $fieldType){
				$dropdown[] = JHTML::_('select.option', $oneField,$oneField);
			}
			return JHTML::_('select.genericlist', $dropdown, $this->name , 'size="1"', 'value', 'text', $this->value);
		}

 function export()
 {
     $listClass = acymailing_get('class.list');
     $db = JFactory::getDBO();
     $fields = acymailing_getColumns('#__acymailing_subscriber');
     $config = acymailing_config();
     $selectedFields = explode(',', $config->get('export_fields', 'email,name'));
     $selectedLists = explode(',', $config->get('export_lists'));
     acymailing_setTitle(JText::_('ACY_EXPORT'), 'acyexport', 'data&task=export');
     $bar = JToolBar::getInstance('toolbar');
     JToolBarHelper::custom('doexport', 'acyexport', '', JText::_('ACY_EXPORT'), false);
     $bar->appendButton('Link', 'cancel', JText::_('ACY_CANCEL'), acymailing_completeLink('subscriber'));
     JToolBarHelper::divider();
     $bar->appendButton('Pophelp', 'data-export');
     $charsetType = acymailing_get('type.charset');
     $this->assignRef('charset', $charsetType);
     $lists = $listClass->getLists();
     $this->assignRef('lists', $lists);
     $this->assignRef('fields', $fields);
     $this->assignRef('selectedfields', $selectedFields);
     $this->assignRef('selectedlists', $selectedLists);
     $this->assignRef('config', $config);
     $whereSubscribers = '';
     if (JRequest::getInt('sessionvalues') and !empty($_SESSION['acymailing']['exportusers'])) {
         $i = 1;
         $subids = array();
         foreach ($_SESSION['acymailing']['exportusers'] as $subid) {
             $subids[] = (int) $subid;
             $i++;
             if ($i > 10) {
                 break;
             }
         }
         $whereSubscribers = implode(',', $subids);
     }
     if (JRequest::getInt('sessionquery')) {
         $currentSession = JFactory::getSession();
         $exportQuery = $currentSession->get('acyexportquery');
         if (!empty($exportQuery)) {
             $whereSubscribers = $exportQuery;
         }
     }
     if (!empty($whereSubscribers)) {
         $db->setQuery('SELECT `name`,`email` FROM `#__acymailing_subscriber` WHERE `subid` IN (' . $whereSubscribers . ') LIMIT 10');
         $users = $db->loadObjectList();
         $this->assignRef('users', $users);
     }
 }

    function acymailingtagcb_show()
    {
        ?>

		<script language="javascript" type="text/javascript">
			function applyTag(tagname){
				var string = '{cbtag:'+tagname;
				for(var i=0; i < document.adminForm.typeinfo.length; i++){
					 if (document.adminForm.typeinfo[i].checked){ string += '|info:'+document.adminForm.typeinfo[i].value; }
				}
				string += '}';
				setTag(string);
				insertTag();
			}
		</script>
	<?php 
        $typeinfo = array();
        $typeinfo[] = JHTML::_('select.option', "receiver", JText::_('RECEIVER_INFORMATION'));
        $typeinfo[] = JHTML::_('select.option', "sender", JText::_('SENDER_INFORMATIONS'));
        echo JHTML::_('acyselect.radiolist', $typeinfo, 'typeinfo', '', 'value', 'text', 'receiver');
        $text = '<table class="adminlist table table-striped table-hover" cellpadding="1">';
        $db = JFactory::getDBO();
        $fields = acymailing_getColumns('#__comprofiler');
        $db->setQuery('SELECT name,type FROM #__comprofiler_fields');
        $fieldType = $db->loadObjectList('name');
        $k = 0;
        $text .= '<tr style="cursor:pointer" class="row1" onclick="applyTag(\'thumb\');" ><td class="acytdcheckbox"></td><td>Thumb Avatar</td></tr>';
        foreach ($fields as $fieldname => $oneField) {
            $type = '';
            if (strpos(strtolower($oneField), 'date') !== false) {
                $type = '|type:date';
            }
            if (!empty($fieldType[$fieldname]) and $fieldType[$fieldname]->type == 'image') {
                $type = '|type:image';
            }
            $text .= '<tr style="cursor:pointer" class="row' . $k . '" onclick="applyTag(\'' . $fieldname . $type . '\');" ><td class="acytdcheckbox"></td><td>' . $fieldname . '</td></tr>';
            $k = 1 - $k;
        }
        $db->setQuery("SELECT * FROM #__comprofiler_fields WHERE tablecolumns = '' AND published = 1");
        $otherFields = $db->loadObjectList();
        foreach ($otherFields as $oneField) {
            $text .= '<tr style="cursor:pointer" class="row' . $k . '" onclick="applyTag(\'cbapi_' . $oneField->name . '\');" ><td class="acytdcheckbox"></td><td>' . $oneField->name . '</td></tr>';
            $k = 1 - $k;
        }
        $text .= '</table>';
        echo $text;
    }

echo $this->escape($this->config->get('zoho_cv'));
?>
">
		</td>
	</tr>
</table>
</fieldset>

<fieldset class="adminform">
	<legend><?php 
echo JText::_('FIELD');
?>
</legend>
<?php 
$db = JFactory::getDBO();
$subfields = acymailing_getColumns('#__acymailing_subscriber');
$acyfields = array();
$acyfields[] = JHTML::_('select.option', '', ' - - - ');
if (!empty($subfields)) {
    foreach ($subfields as $oneField => $typefield) {
        if (in_array($oneField, array('subid', 'confirmed', 'enabled', 'key', 'userid', 'accept', 'html', 'created', 'zohoid', 'zoholist', 'email'))) {
            continue;
        }
        $acyfields[] = JHTML::_('select.option', $oneField, $oneField);
    }
}
?>
	<table class="admintable table" cellspacing="1">
<?php 
echo '<tr><td class="key">' . JText::_('ACY_LOADZOHOFIELDS') . '</td><td>';
if (!ACYMAILING_J30) {

}
$fieldAssignment = array();
$fieldAssignment[] = JHTML::_('select.option', "0", '- - -');
$fieldAssignment[] = JHTML::_('select.option', "1", JText::_('ACY_IGNORE'));
if (acymailing_isAllowed($this->config->get('acl_extra_fields_import', 'all'))) {
    $createField = JHTML::_('select.option', "2", JText::_('ACY_CREATE_FIELD'));
    if (!acymailing_level(3)) {
        $createField->disable = true;
        $createField->text .= ' (' . JText::_('ONLY_FROM_ENTERPRISE') . ')';
    }
    $fieldAssignment[] = $createField;
}
$separator = JHTML::_('select.option', "3", '-------------------------------------');
$separator->disable = true;
$fieldAssignment[] = $separator;
$fields = array_keys(acymailing_getColumns('#__acymailing_subscriber'));
$fields[] = 'listids';
$fields[] = 'listname';
foreach ($fields as $oneField) {
    $fieldAssignment[] = JHTML::_('select.option', $oneField, $oneField);
}
$fields[] = '1';
echo '<tr class="row0"><td align="center" valign="top"><strong>' . acymailing_tooltip(JText::_('ACY_ASSIGN_COLUMNS_DESC'), null, null, JText::_('ACY_ASSIGN_COLUMNS')) . '</strong>' . ($nbColumns > 5 ? '<br/><a style="text-decoration:none;" href="#" onclick="ignoreAllOthers();">' . JText::_('ACY_IGNORE_UNASSIGNED') . '</a>' : '') . '</td>';
$alreadyFound = array();
foreach ($columnNames as $key => &$oneColumn) {
    $oneColumn = strtolower(trim($oneColumn, '\'" '));
    $customValue = '';
    $default = JRequest::getCmd('fieldAssignment' . $key);
    if (empty($default) && $default !== 0) {
        $default = in_array($oneColumn, $fields) ? $oneColumn : '0';
        if (!$default && !empty($firstValueLine)) {

 function onAcyDisplayFilters(&$type, $context = "massactions")
 {
     if ($this->params->get('displayfilter_' . $context, true) == false) {
         return;
     }
     $db = JFactory::getDBO();
     $fields = acymailing_getColumns('#__users');
     if (empty($fields)) {
         return;
     }
     $type['joomlafield'] = JText::_('JOOMLA_FIELD');
     $type['joomlagroup'] = JText::_('ACY_GROUP');
     $field = array();
     foreach ($fields as $oneField => $fieldType) {
         $field[] = JHTML::_('select.option', $oneField, $oneField);
     }
     if (ACYMAILING_J16) {
         $db->setQuery('SELECT DISTINCT `profile_key` FROM `#__user_profiles`');
         $extraFields = $db->loadObjectList();
         if (!empty($extraFields)) {
             foreach ($extraFields as $oneField) {
                 $field[] = JHTML::_('select.option', 'customfield_' . $oneField->profile_key, $oneField->profile_key);
             }
         }
     }
     $operators = acymailing_get('type.operators');
     $operators->extra = 'onchange="countresults(__num__)"';
     $return = '<div id="filter__num__joomlafield">' . JHTML::_('select.genericlist', $field, "filter[__num__][joomlafield][map]", 'class="inputbox" size="1" onchange="countresults(__num__)"', 'value', 'text');
     $return .= ' ' . $operators->display("filter[__num__][joomlafield][operator]") . ' <input onchange="countresults(__num__)" class="inputbox" type="text" name="filter[__num__][joomlafield][value]" style="width:200px" value=""></div>';
     if (!ACYMAILING_J16) {
         $acl = JFactory::getACL();
         $groups = $acl->get_group_children_tree(null, 'USERS', false);
     } else {
         $db = JFactory::getDBO();
         $db->setQuery('SELECT a.*, a.title as text, a.id as value  FROM #__usergroups AS a ORDER BY a.lft ASC');
         $groups = $db->loadObjectList('id');
         foreach ($groups as $id => $group) {
             if (isset($groups[$group->parent_id])) {
                 $groups[$id]->level = intval(@$groups[$group->parent_id]->level) + 1;
                 $groups[$id]->text = str_repeat('- - ', $groups[$id]->level) . $groups[$id]->text;
             }
         }
     }
     $inoperator = acymailing_get('type.operatorsin');
     $inoperator->js = 'onchange="countresults(__num__)"';
     $return .= '<div id="filter__num__joomlagroup">' . $inoperator->display("filter[__num__][joomlagroup][type]") . ' ' . JHTML::_('select.genericlist', $groups, "filter[__num__][joomlagroup][group]", 'class="inputbox" size="1" onchange="countresults(__num__)"', 'value', 'text') . '</div>';
     return $return;
 }

 function onAcyDisplayActions(&$type)
 {
     $type['acymailingfield'] = JText::_('BOUNCE_ACTION');
     $status = array();
     $status[] = JHTML::_('select.option', 'confirm', JText::_('CONFIRM_USERS'));
     $status[] = JHTML::_('select.option', 'unconfirm', JText::_('ACY_ACTION_UNCONFIRM'));
     $status[] = JHTML::_('select.option', 'enable', JText::_('ENABLE_USERS'));
     $status[] = JHTML::_('select.option', 'block', JText::_('BLOCK_USERS'));
     $status[] = JHTML::_('select.option', 'delete', JText::_('DELETE_USERS'));
     $content = '<div id="action__num__acymailingfield">' . JHTML::_('select.genericlist', $status, "action[__num__][acymailingfield][action]", 'class="inputbox" size="1"', 'value', 'text') . '</div>';
     if (!acymailing_level(3)) {
         return $content;
     }
     $db = JFactory::getDBO();
     $fields = acymailing_getColumns('#__acymailing_subscriber');
     if (empty($fields)) {
         return $content;
     }
     $field = array();
     $field[] = JHTML::_('select.option', 0, '- - -');
     foreach ($fields as $oneField => $fieldType) {
         if (in_array($oneField, array('name', 'email', 'subid', 'created', 'ip'))) {
             continue;
         }
         $field[] = JHTML::_('select.option', $oneField, $oneField);
     }
     $jsOnChange = "if(document.getElementById('action__num__acymailingfieldvalvalue')!= undefined){ currentVal=document.getElementById('action__num__acymailingfieldvalvalue').value;} else{currentVal='';}\n\t\t\tdisplayCondFilter('displayFieldPossibleValues', 'toChangeAction__num__',__num__,'map='+document.getElementById('action__num__acymailingfieldvalmap').value+'&value='+currentVal); ";
     $content .= '<div id="action__num__acymailingfieldval">' . JHTML::_('select.genericlist', $field, "action[__num__][acymailingfieldval][map]", 'onchange="' . $jsOnChange . '" class="inputbox" size="1"', 'value', 'text');
     $content .= ' = <span id="toChangeAction__num__"><input class="inputbox" type="text" id="action__num__acymailingfieldvalvalue" name="action[__num__][acymailingfieldval][value]" style="width:200px" value=""></span></div>';
     $type['acymailingfieldval'] = JText::_('SET_SUBSCRIBER_VALUE');
     return $content;
 }

 function onAcyDisplayActions(&$type)
 {
     $type['acymailingfield'] = JText::_('BOUNCE_ACTION');
     $status = array();
     $status[] = JHTML::_('select.option', 'confirm', JText::_('CONFIRM_USERS'));
     $status[] = JHTML::_('select.option', 'enable', JText::_('ENABLE_USERS'));
     $status[] = JHTML::_('select.option', 'block', JText::_('BLOCK_USERS'));
     $status[] = JHTML::_('select.option', 'delete', JText::_('DELETE_USERS'));
     $content = '';
     if (acymailing_level(3)) {
         $db = JFactory::getDBO();
         $fields = acymailing_getColumns('#__acymailing_subscriber');
         if (empty($fields)) {
             return;
         }
         $field = array();
         foreach ($fields as $oneField => $fieldType) {
             if (in_array($oneField, array('name', 'email', 'confirmed', 'subid', 'created', 'ip'))) {
                 continue;
             }
             $field[] = JHTML::_('select.option', $oneField, $oneField);
         }
         $content .= '<div id="action__num__acymailingfieldval">' . JHTML::_('select.genericlist', $field, "action[__num__][acymailingfieldval][map]", 'class="inputbox" size="1"', 'value', 'text');
         $content .= ' = <input class="inputbox" type="text" name="action[__num__][acymailingfieldval][value]" style="width:200px" value=""></div>';
         $type['acymailingfieldval'] = JText::_('SET_SUBSCRIBER_VALUE');
     }
     $content .= '<div id="action__num__acymailingfield">' . JHTML::_('select.genericlist', $status, "action[__num__][acymailingfield][action]", 'class="inputbox" size="1"', 'value', 'text') . '</div>';
     return $content;
 }

 function export()
 {
     $listClass = acymailing_get('class.list');
     $db = JFactory::getDBO();
     $fields = acymailing_getColumns('#__acymailing_subscriber');
     $fieldsList = array();
     $fieldsList['listid'] = 'smallint unsigned';
     $fieldsList['listname'] = 'varchar';
     $config = acymailing_config();
     $selectedFields = explode(',', $config->get('export_fields', 'email,name'));
     $selectedLists = explode(',', $config->get('export_lists'));
     $selectedFilters = explode(',', $config->get('export_filters', 'subscribed'));
     $app = JFactory::getApplication();
     if ($app->isAdmin()) {
         acymailing_setTitle(JText::_('ACY_EXPORT'), 'acyexport', 'data&task=export');
         $bar = JToolBar::getInstance('toolbar');
         JToolBarHelper::custom('doexport', 'acyexport', '', JText::_('ACY_EXPORT'), false);
         $bar->appendButton('Link', 'cancel', JText::_('ACY_CANCEL'), acymailing_completeLink('subscriber'));
         JToolBarHelper::divider();
         $bar->appendButton('Pophelp', 'data-export');
     }
     $charsetType = acymailing_get('type.charset');
     $this->assignRef('charset', $charsetType);
     if ($app->isAdmin()) {
         $lists = $listClass->getLists();
     } else {
         $lists = $listClass->getFrontendLists();
     }
     $this->assignRef('lists', $lists);
     $this->assignRef('fields', $fields);
     $this->assignRef('fieldsList', $fieldsList);
     $this->assignRef('selectedfields', $selectedFields);
     $this->assignRef('selectedlists', $selectedLists);
     $this->assignRef('selectedFilters', $selectedFilters);
     $this->assignRef('config', $config);
     $whereSubscribers = '';
     if (JRequest::getInt('sessionvalues')) {
         if (!empty($_SESSION['acymailing']['exportusers'])) {
             $i = 1;
             $subids = array();
             foreach ($_SESSION['acymailing']['exportusers'] as $subid) {
                 $subids[] = (int) $subid;
                 $i++;
                 if ($i > 10) {
                     break;
                 }
             }
             if (!empty($subids)) {
                 $db->setQuery('SELECT `name`,`email` FROM `#__acymailing_subscriber` WHERE `subid` IN (' . implode(',', $subids) . ') LIMIT 10');
                 $users = $db->loadObjectList();
                 $this->assignRef('users', $users);
             }
         } elseif (!empty($_SESSION['acymailing']['exportlist'])) {
             $filterList = $_SESSION['acymailing']['exportlist'];
             $this->assignRef('exportlist', $filterList);
         }
     }
     if (JRequest::getInt('sessionquery')) {
         $currentSession = JFactory::getSession();
         $exportQuery = $currentSession->get('acyexportquery');
         if (!empty($exportQuery)) {
             $db->setQuery('SELECT s.`name`,s.`email` ' . $exportQuery . ' LIMIT 10');
             $users = $db->loadObjectList();
             $this->assignRef('users', $users);
             if (strpos($exportQuery, 'userstats')) {
                 $otherFields = array('userstats.senddate', 'userstats.open', 'userstats.opendate', 'userstats.bounce', 'userstats.ip', 'userstats.html', 'userstats.fail', 'userstats.sent');
                 $this->assignRef('otherfields', $otherFields);
             }
             if (strpos($exportQuery, 'urlclick')) {
                 $otherFields = array('url.name', 'url.url', 'urlclick.date', 'urlclick.ip', 'urlclick.click');
                 $this->assignRef('otherfields', $otherFields);
             }
             if (strpos($exportQuery, 'history')) {
                 $otherFields = array('hist.data', 'hist.date');
                 $this->assignRef('otherfields', $otherFields);
             }
         }
     }
     if (acymailing_level(3)) {
         $geolocFields = acymailing_getColumns('#__acymailing_geolocation');
         $this->assign('geolocfields', $geolocFields);
     }
 }

 function zohocrm($action = '')
 {
     $app = JFactory::getApplication();
     $db = JFactory::getDBO();
     $zohoHelper = acymailing_get('helper.zoho');
     $listClass = acymailing_get('class.list');
     $subscriberClass = acymailing_get('class.subscriber');
     $tableInfos = array_keys(acymailing_getColumns('#__acymailing_subscriber'));
     $config =& acymailing_config();
     if (!in_array('zohoid', $tableInfos)) {
         $query = 'ALTER TABLE #__acymailing_subscriber ADD COLUMN zohoid VARCHAR(255)';
         $db->setQuery($query);
         $db->query();
     }
     if (!in_array('zoholist', $tableInfos)) {
         $query = 'ALTER TABLE #__acymailing_subscriber ADD COLUMN zoholist CHAR(1)';
         $db->setQuery($query);
         $db->query();
     }
     if ($action == 'update') {
         $lists = unserialize($config->get('zoho_lists'));
         $zohoHelper->authtoken = $authtoken = $config->get('zoho_apikey');
         $fields = unserialize($config->get('zoho_fields'));
         $confirmedUsers = $config->get('zoho_confirmed');
         $delete = $config->get('zoho_delete');
         $importlists = array();
     } else {
         $lists = JRequest::getVar('zoho_lists');
         $fields = JRequest::getVar('zoho_fields');
         $zohoHelper->authtoken = $authtoken = JRequest::getVar('zoho_apikey');
         $importlists = JRequest::getVar('importlists');
         $overwrite = JRequest::getVar('zoho_overwrite');
         $confirmedUsers = JRequest::getVar('zoho_confirmed');
         $delete = JRequest::getVar('zoho_delete');
         $newConfig = new stdClass();
         $newConfig->zoho_fields = serialize($fields);
         $newConfig->zoho_lists = serialize($lists);
         $newConfig->zoho_apikey = $zohoHelper->authtoken;
         $newConfig->zoho_overwrite = $overwrite;
         $newConfig->zoho_confirmed = $confirmedUsers;
         $newConfig->zoho_delete = $delete;
         $config->save($newConfig);
     }
     if ($config->get('zoho_overwrite', false)) {
         $this->overwrite = true;
     }
     if (empty($authtoken)) {
         $app->enqueueMessage('Pleaser enter a valid API key', 'notice');
         return false;
     }
     $done = false;
     foreach ($lists as $list => $listid) {
         if (empty($listid)) {
             continue;
         }
         $done = true;
         $this->allSubid = array();
         $res = $zohoHelper->sendInfo($list);
         if (!empty($zohoHelper->conn)) {
             $zohoHelper->close();
         }
         if ($res != false) {
             $zohoUsers = $zohoHelper->parseXML($res, $list, $fields, $confirmedUsers);
         }
         if (empty($zohoUsers)) {
             continue;
         }
         $this->_insertUsers($zohoUsers);
         $affectedUsers = $zohoHelper->subscribe($listid, $list);
         if (empty($this->subscribedUsers[$listid])) {
             $this->subscribedUsers[$listid] = $listClass->get($listid);
         }
         $this->subscribedUsers[$listid]->nbusers += $affectedUsers;
         foreach ($importlists as $importlistid => $selected) {
             if ($selected == '1') {
                 $importUserInLists[] = $importlistid;
             }
         }
         $this->_subscribeUsers();
         if (JRequest::getInt('zoho_delete') == '1') {
             $zohoHelper->deleteAddress($this->allSubid, $list);
         } else {
             $query = 'SELECT DISTINCT b.subid FROM #__acymailing_subscriber AS a JOIN #__acymailing_subscriber AS b ON a.zohoid = b.zohoid WHERE a.zohoid IS NOT NULL AND b.subid < a.subid';
             $db->setQuery($query);
             $result = acymailing_loadResultArray($db);
             $subscriberClass->delete($result);
         }
     }
     $this->_displaySubscribedResult();
     if ($done == false) {
         $app->enqueueMessage('Please select at least one list to import your Zoho users', 'notice');
     }
     if (!empty($zohoHelper->error)) {
         $app->enqueueMessage(JText::sprintf($zohoHelper->error), 'notice');
     }
 }

 function onAcyProcessAction_acymailingfieldval($cquery, $action, $num)
 {
     $value = is_array($action['value']) ? implode(',', $action['value']) : $action['value'];
     $replace = array('{year}', '{month}', '{weekday}', '{day}');
     $replaceBy = array(date('Y'), date('m'), date('N'), date('d'));
     $value = str_replace($replace, $replaceBy, $value);
     if (empty($action['operator'])) {
         $action['operator'] = '=';
     }
     preg_match_all('#(?:{|%7B)field:(.*)(?:}|%7D)#Ui', $value, $tags);
     $fields = array_keys(acymailing_getColumns('#__acymailing_subscriber'));
     if (!in_array($action['map'], $fields)) {
         return 'Unexisting field: ' . $action['map'] . ' | The available fields are: ' . implode(', ', $fields);
     }
     if (in_array($action['operator'], array('+', '-'))) {
         if (empty($tags) || empty($tags[1])) {
             $value = intval($value);
         } else {
             if (count($tags[1]) > 1 || substr($value, 0, 1) != '{' || substr($value, strlen($value) - 1, 1) != '}') {
                 return 'You can\'t use more than one tag for the + and - operators (you also can\'t add or remove a value from the inserted tag for these two operators)';
             }
             if (!in_array($tags[1][0], $fields)) {
                 return 'Unexisting field: ' . $tags[1][0] . ' | The available fields are: ' . implode(', ', $fields);
             }
             $value = 'sub.`' . acymailing_secureField($tags[1][0]) . '`';
         }
     } else {
         $value = $cquery->db->Quote($value);
         if (!empty($tags)) {
             foreach ($tags[1] as $i => $oneField) {
                 if (!in_array($oneField, $fields)) {
                     return 'Unexisting field: ' . $oneField . ' | The available fields are: ' . implode(', ', $fields);
                 }
                 $value = str_replace($tags[0][$i], "', sub.`" . acymailing_secureField($oneField) . "`, '", $value);
             }
             $value = "CONCAT(" . $value . ")";
         }
     }
     $query = 'UPDATE #__acymailing_subscriber AS sub';
     if (!empty($cquery->join)) {
         $query .= ' JOIN ' . implode(' JOIN ', $cquery->join);
     }
     if (!empty($cquery->leftjoin)) {
         $query .= ' LEFT JOIN ' . implode(' LEFT JOIN ', $cquery->leftjoin);
     }
     if ($action['operator'] == '=') {
         $newValue = $value;
     } elseif (in_array($action['operator'], array('+', '-'))) {
         $newValue = "sub.`" . acymailing_secureField($action['map']) . "` " . $action['operator'] . " " . $value;
     } elseif ($action['operator'] == 'addend') {
         $newValue = "CONCAT(sub.`" . acymailing_secureField($action['map']) . "`, " . $value . ")";
     } elseif ($action['operator'] == 'addbegin') {
         $newValue = "CONCAT(" . $value . ", sub.`" . acymailing_secureField($action['map']) . "`)";
     } else {
         return 'Non existing operator: ' . $action['operator'];
     }
     $query .= " SET sub.`" . acymailing_secureField($action['map']) . "` = " . $newValue;
     if (!empty($cquery->where)) {
         $query .= ' WHERE (' . implode(') AND (', $cquery->where) . ')';
     }
     $cquery->db->setQuery($query);
     $cquery->db->query();
     $nbAffected = $cquery->db->getAffectedRows();
     return JText::sprintf('NB_MODIFIED', $nbAffected);
 }

 function zohocrm($action = '')
 {
     $db = JFactory::getDBO();
     $zohoHelper = acymailing_get('helper.zoho');
     $subscriberClass = acymailing_get('class.subscriber');
     $tableInfos = array_keys(acymailing_getColumns('#__acymailing_subscriber'));
     $config =& acymailing_config();
     if (!in_array('zohoid', $tableInfos)) {
         $query = 'ALTER TABLE #__acymailing_subscriber ADD COLUMN zohoid VARCHAR(255)';
         $db->setQuery($query);
         $db->query();
         $qery = 'ALTER TABLE `#__acymailing_subscriber` ADD INDEX(`zohoid`)';
         $db->setQuery($query);
         $db->query();
     }
     if (!in_array('zoholist', $tableInfos)) {
         $query = 'ALTER TABLE #__acymailing_subscriber ADD COLUMN zoholist CHAR(1)';
         $db->setQuery($query);
         $db->query();
     }
     if ($action == 'update') {
         $list = $config->get('zoho_list');
         $zohoHelper->authtoken = $authtoken = $config->get('zoho_apikey');
         $zohoHelper->customView = $config->get('zoho_cv');
         $fields = unserialize($config->get('zoho_fields'));
         $confirmedUsers = $config->get('zoho_confirmed');
         $delete = $config->get('zoho_delete');
         $generateName = $config->get('zoho_generate_name', 'fromemail');
         $importnew = $config->get('zoho_importnew', 0);
     } else {
         $list = JRequest::getVar('zoho_list');
         $fields = JRequest::getVar('zoho_fields');
         $zohoHelper->authtoken = $authtoken = JRequest::getVar('zoho_apikey');
         $zohoHelper->customView = JRequest::getVar('zoho_cv');
         $overwrite = JRequest::getVar('zoho_overwrite');
         $confirmedUsers = JRequest::getVar('zoho_confirmed');
         $delete = JRequest::getVar('zoho_delete');
         $newConfig = new stdClass();
         $newConfig->zoho_fields = serialize($fields);
         $newConfig->zoho_list = $list;
         $newConfig->zoho_apikey = $zohoHelper->authtoken;
         $newConfig->zoho_cv = $zohoHelper->customView;
         $newConfig->zoho_overwrite = $overwrite;
         $newConfig->zoho_confirmed = $confirmedUsers;
         $newConfig->zoho_delete = $delete;
         $newConfig->zoho_generate_name = $generateName = JRequest::getVar('zoho_generate_name', 'fromemail');
         $newConfig->zoho_importnew = $importnew = JRequest::getVar('zoho_importnew', 0);
         $newConfig->zoho_importdate = date('Y-m-d H:i:s');
         $config->save($newConfig);
     }
     if ($config->get('zoho_overwrite', false)) {
         $this->overwrite = true;
     }
     if (empty($authtoken)) {
         acymailing_enqueueMessage('Pleaser enter a valid API key', 'notice');
         return false;
     }
     $this->allSubid = array();
     $indexDec = 200;
     $res = $zohoHelper->sendInfo($list);
     while (!empty($res)) {
         $zohoUsers = $zohoHelper->parseXML($res, $list, $fields, $confirmedUsers, $generateName);
         if (empty($zohoUsers) && $zohoHelper->nbUserRead == 0) {
             break;
         }
         $this->_insertUsers($zohoUsers);
         if ($zohoHelper->nbUserRead < 200) {
             break;
         }
         // No further iteration needed
         $zohoUsers = array();
         $zohoHelper->fromIndex = $zohoHelper->fromIndex + $indexDec;
         $zohoHelper->toIndex = $zohoHelper->toIndex + $indexDec;
         if (!empty($zohoHelper->conn)) {
             $zohoHelper->close();
         }
         $res = $zohoHelper->sendInfo($list);
     }
     $this->_subscribeUsers();
     if (JRequest::getInt('zoho_delete') == '1') {
         $zohoHelper->deleteAddress($this->allSubid, $list);
     } else {
         $query = 'SELECT DISTINCT b.subid FROM #__acymailing_subscriber AS a JOIN #__acymailing_subscriber AS b ON a.zohoid = b.zohoid WHERE a.zohoid IS NOT NULL AND b.subid < a.subid';
         $db->setQuery($query);
         $result = acymailing_loadResultArray($db);
         $subscriberClass->delete($result);
     }
     if (!empty($zohoHelper->conn)) {
         $zohoHelper->close();
     }
     $this->_displaySubscribedResult();
     if (!empty($zohoHelper->error)) {
         acymailing_enqueueMessage(JText::sprintf($zohoHelper->error), 'notice');
     }
 }

    function doexport()
    {
        if (!$this->isAllowed('subscriber', 'export')) {
            return;
        }
        JRequest::checkToken() or die('Invalid Token');
        acymailing_increasePerf();
        $filtersExport = JRequest::getVar('exportfilter', array(), '', 'array');
        $listsToExport = JRequest::getVar('exportlists');
        $fieldsToExport = JRequest::getVar('exportdata');
        $tableFields = acymailing_getColumns('#__acymailing_subscriber');
        $notAllowedFields = array_diff_key($fieldsToExport, $tableFields);
        if (!empty($notAllowedFields)) {
            die('The field ' . implode(', ', array_keys($notAllowedFields)) . ' is not in the allowed fields: ' . implode(', ', array_keys($tableFields)));
        }
        $fieldsToExportList = JRequest::getVar('exportdatalist');
        $notAllowedFields = array_diff(array_keys($fieldsToExportList), array('listid', 'listname'));
        if (!empty($notAllowedFields)) {
            die('The field ' . implode(', ', $notAllowedFields) . ' is not in the allowed fields: listid, listname');
        }
        $fieldsToExportOthers = JRequest::getVar('exportdataother');
        $fieldsToExportGeoloc = JRequest::getVar('exportdatageoloc');
        $tableFields = acymailing_getColumns('#__acymailing_geolocation');
        $notAllowedFields = array_diff_key($fieldsToExportGeoloc, $tableFields);
        if (!empty($notAllowedFields)) {
            die('The field ' . implode(', ', array_keys($notAllowedFields)) . ' is not in the allowed fields: ' . implode(', ', array_keys($tableFields)));
        }
        $inseparator = JRequest::getString('exportseparator');
        $inseparator = str_replace(array('semicolon', 'colon', 'comma'), array(';', ',', ','), $inseparator);
        $exportFormat = JRequest::getString('exportformat');
        if (!in_array($inseparator, array(',', ';'))) {
            $inseparator = ';';
        }
        $exportUnsubLists = array();
        $exportWaitLists = array();
        $exportLists = array();
        if (!empty($filtersExport['subscribed'])) {
            foreach ($listsToExport as $listid => $status) {
                if ($status == -1) {
                    $exportUnsubLists[] = (int) $listid;
                } elseif ($status == 2) {
                    $exportWaitLists[] = (int) $listid;
                } elseif (!empty($status)) {
                    $exportLists[] = (int) $listid;
                }
            }
        }
        $app = JFactory::getApplication();
        if (!$app->isAdmin() && (empty($filtersExport['subscribed']) || empty($exportLists) && empty($exportUnsubLists) && empty($exportWaitLists))) {
            $listClass = acymailing_get('class.list');
            $frontLists = $listClass->getFrontendLists();
            foreach ($frontLists as $frontList) {
                $exportLists[] = (int) $frontList->listid;
            }
        }
        $exportFields = array();
        $exportFieldsList = array();
        $exportFieldsOthers = array();
        $exportFieldsGeoloc = array();
        foreach ($fieldsToExport as $fieldName => $checked) {
            if (!empty($checked)) {
                $exportFields[] = acymailing_secureField($fieldName);
            }
        }
        foreach ($fieldsToExportList as $fieldName => $checked) {
            if (!empty($checked)) {
                $exportFieldsList[] = acymailing_secureField($fieldName);
            }
        }
        if (!empty($fieldsToExportOthers)) {
            foreach ($fieldsToExportOthers as $fieldName => $checked) {
                if (!empty($checked)) {
                    $exportFieldsOthers[] = acymailing_secureField($fieldName);
                }
            }
        }
        if (!empty($fieldsToExportGeoloc)) {
            foreach ($fieldsToExportGeoloc as $fieldName => $checked) {
                if (!empty($checked)) {
                    $exportFieldsGeoloc[] = acymailing_secureField($fieldName);
                }
            }
        }
        $selectFields = 's.`' . implode('`, s.`', $exportFields) . '`';
        $config = acymailing_config();
        $newConfig = new stdClass();
        $newConfig->export_fields = implode(',', array_merge($exportFields, $exportFieldsOthers, $exportFieldsList, $exportFieldsGeoloc));
        $newConfig->export_lists = implode(',', $exportLists);
        $newConfig->export_separator = JRequest::getString('exportseparator');
        $newConfig->export_format = $exportFormat;
        $filterActive = array();
        foreach ($filtersExport as $filterKey => $value) {
            if ($value == 1) {
                $filterActive[] = $filterKey;
            }
        }
        $newConfig->export_filters = implode(',', $filterActive);
        $config->save($newConfig);
        $where = array();
        if (empty($exportLists) && empty($exportUnsubLists) && empty($exportWaitLists)) {
//.........这里部分代码省略.........

 function onAcyDisplayFilters(&$type, $context = 'massactions')
 {
     if (!$this->loadAcymailing()) {
         return '';
     }
     if ($this->params->get('displayfilter_' . $context, true) == false) {
         return '';
     }
     $this->db->setQuery("SELECT `product_id` as value, CONCAT(`product_name`,' ( ',`product_code`,' ) ') as text FROM " . acymailing_table('hikashop_product', false) . " ORDER BY `product_code` ASC LIMIT 1000");
     $allProducts = $this->db->loadObjectList();
     if (!empty($allProducts)) {
         $selectOne = new stdClass();
         $selectOne->value = 0;
         $selectOne->text = JText::_('ACY_ONE_PRODUCT');
         array_unshift($allProducts, $selectOne);
     }
     $hikaBuy = array();
     $hikaBuy[] = JHTML::_('select.option', '1', JText::_('ACY_BOUGHT'));
     $hikaBuy[] = JHTML::_('select.option', '0', JText::_('ACY_DIDNOTBOUGHT'));
     $hikaGroupsParams = acymailing_get('type.operatorsin');
     $hikaGroupsParams->js = 'onchange="countresults(__num__)"';
     $operators = acymailing_get('type.operators');
     $operators->extra = 'onchange="countresults(__num__)"';
     $fields = acymailing_getColumns('#__hikashop_user');
     $hikaFields = array();
     if (!empty($fields)) {
         foreach ($fields as $oneField => $fieldType) {
             $hikaFields[] = JHTML::_('select.option', $oneField, $oneField);
         }
     }
     $return = '';
     $return .= '<div id="filter__num__hikaallorders">';
     $return .= $hikaGroupsParams->display("filter[__num__][hikaallorders][type]") . ' ';
     $category = hikashop_get('type.categorysub');
     $category->type = 'status';
     $return .= $category->display("filter[__num__][hikaallorders][status]", '', 'size="1" onchange="countresults(__num__)" ', false);
     $payment = hikashop_get('type.payment');
     $payment->extra = 'onchange="countresults(__num__)"';
     $return .= $payment->display("filter[__num__][hikaallorders][payment]", '', false);
     $return .= '<br/> <input onclick="displayDatePicker(this,event)" name="filter[__num__][hikaallorders][cdateinf]" type="text" onchange="countresults(__num__)" /> < ' . JText::_('CREATED_DATE') . ' < <input onclick="displayDatePicker(this,event)" type="text" name="filter[__num__][hikaallorders][cdatesup]" onchange="countresults(__num__)"  />';
     $return .= '<br/> <input onclick="displayDatePicker(this,event)" name="filter[__num__][hikaallorders][mdateinf]" type="text" onchange="countresults(__num__)" /> < ' . JText::_('MODIFIED_DATE') . ' < <input onclick="displayDatePicker(this,event)" type="text" name="filter[__num__][hikaallorders][mdatesup]" onchange="countresults(__num__)" />';
     $return .= '<br/> <input onclick="displayDatePicker(this,event)" name="filter[__num__][hikaallorders][idateinf]" type="text" onchange="countresults(__num__)" /> < ' . JText::_('INVOICE_DATE') . ' < <input onclick="displayDatePicker(this,event)" type="text" name="filter[__num__][hikaallorders][idatesup]" onchange="countresults(__num__)" />';
     $return .= '</div>';
     $type['hikaallorders'] = 'HikaShop ' . JText::_('ORDERS');
     if (!empty($allProducts)) {
         $dateFilters = array();
         $dateFilters[] = JHTML::_('select.option', 'order_created', JText::_('CREATED_DATE'));
         $dateFilters[] = JHTML::_('select.option', 'order_modified', JText::_('MODIFIED_DATE'));
         $dateFilters[] = JHTML::_('select.option', 'order_invoice_created', JText::_('INVOICE_DATE'));
         $return .= '<div id="filter__num__hikaorder">' . JHTML::_('select.genericlist', $hikaBuy, "filter[__num__][hikaorder][type]", 'class="inputbox" size="1" onchange="countresults(__num__)" ', 'value', 'text') . ' ';
         $return .= JHTML::_('select.genericlist', $allProducts, "filter[__num__][hikaorder][product]", 'class="inputbox" style="max-width:200px" size="1" onchange="countresults(__num__)" ', 'value', 'text');
         $this->db->setQuery('SELECT `category_id` AS value, `category_name` AS text FROM ' . acymailing_table('hikashop_category', false) . ' WHERE `category_type` = "product" ORDER BY `category_name` ASC LIMIT 1000');
         $allCats = $this->db->loadObjectList();
         if (!empty($allCats)) {
             $selectOne = new stdClass();
             $selectOne->value = 0;
             $selectOne->text = JText::_('ACY_ANY_CATEGORY');
             array_unshift($allCats, $selectOne);
         }
         $return .= ' ' . JHTML::_('select.genericlist', $allCats, "filter[__num__][hikaorder][cat]", 'class="inputbox" style="max-width:200px" size="1" onchange="countresults(__num__)" ', 'value', 'text');
         $return .= '<br/> <input onclick="displayDatePicker(this,event)" type="text" name="filter[__num__][hikaorder][creationdateinf]" onchange="countresults(__num__)" /> < ' . JHTML::_('select.genericlist', $dateFilters, "filter[__num__][hikaorder][datefield]", 'class="inputbox" size="1" onchange="countresults(__num__)" ', 'value', 'text') . ' < <input onclick="displayDatePicker(this,event)" type="text" name="filter[__num__][hikaorder][creationdatesup]" onchange="countresults(__num__)" />';
         $return .= '</div>';
         $type['hikaorder'] = 'HikaShop ' . JText::_('CUSTOMERS');
     }
     if (!empty($hikaFields)) {
         $return .= '<div id="filter__num__hikafield">' . JHTML::_('select.genericlist', $hikaFields, "filter[__num__][hikafield][map]", 'class="inputbox" onchange="countresults(__num__)" size="1"', 'value', 'text');
         $return .= ' ' . $operators->display("filter[__num__][hikafield][operator]") . ' <input class="inputbox" type="text" name="filter[__num__][hikafield][value]" size="50" value="" onchange="countresults(__num__)" />';
         $return .= '</div>';
         $type['hikafield'] = 'HikaShop ' . JText::_('FIELD');
     }
     $this->db->setQuery("SELECT `zone_namekey` AS value, CONCAT(`zone_name`,' ( ',`zone_name_english`,' )') AS text FROM " . acymailing_table('hikashop_zone', false) . " WHERE `zone_type` = 'country' ORDER BY `zone_name_english` ASC LIMIT 1000");
     $allCountries = $this->db->loadObjectList();
     $selectOne = new stdClass();
     $selectOne->value = 0;
     $selectOne->text = JText::_('COUNTRYCAPTION');
     array_unshift($allCountries, $selectOne);
     $jsOnChange = "displayCondFilter('displayStates', 'toChange__num__',__num__,'country='+this.value); ";
     $return .= '<div id="filter__num__hikaaddress">';
     $return .= $hikaGroupsParams->display("filter[__num__][hikaaddress][type]") . ' ';
     $return .= JHTML::_('select.genericlist', $allCountries, "filter[__num__][hikaaddress][country]", 'class="inputbox" onchange="' . $jsOnChange . 'countresults(__num__)" size="1"', 'value', 'text');
     $return .= ' <span id="toChange__num__"></span>';
     $return .= '</div>';
     $type['hikaaddress'] = 'HikaShop ' . JText::_('ADDRESSCAPTION');
     $return .= '<div id="filter__num__hikareminder">';
     $val = '<input class="inputbox" type="text" name="filter[__num__][hikareminder][nbdays]" style="width:50px" value="1" onchange="countresults(__num__)" />';
     $return .= JText::sprintf('DAYS_AFTER_ORDERING', $val) . '</br>';
     $payment = hikashop_get('type.payment');
     $payment->extra = 'onchange="countresults(__num__)"';
     $return .= $payment->display("filter[__num__][hikareminder][payment]", '', false);
     $return .= '</div>';
     $type['hikareminder'] = 'HikaShop Reminder';
     $acyconfig = acymailing_config();
     if (version_compare($acyconfig->get('version'), '4.9.4', '<')) {
         echo 'Please update AcyMailing, the HikaShop plugin may not work properly with this version';
     }
     return $return;
 }

 function saveForm()
 {
     $app = JFactory::getApplication();
     $field = new stdClass();
     $field->fieldid = acymailing_getCID('fieldid');
     $formData = JRequest::getVar('data', array(), '', 'array');
     foreach ($formData['fields'] as $column => $value) {
         acymailing_secureField($column);
         if (is_array($value)) {
             if (isset($value['day']) || isset($value['month']) || isset($value['year'])) {
                 $value = (empty($value['year']) ? '0000' : intval($value['year'])) . '-' . (empty($value['month']) ? '00' : intval($value['month'])) . '-' . (empty($value['day']) ? '00' : intval($value['day']));
             } else {
                 $value = implode(',', $value);
             }
         }
         $field->{$column} = strip_tags($value);
     }
     $fieldValues = JRequest::getVar('fieldvalues', array(), '', 'array');
     if (!empty($fieldValues)) {
         $field->value = array();
         foreach ($fieldValues['title'] as $i => $title) {
             $title = trim(strip_tags($title));
             $value = trim(strip_tags($value));
             if (strlen($title) < 1 and strlen($fieldValues['value'][$i]) < 1) {
                 continue;
             }
             $value = strlen($fieldValues['value'][$i]) < 1 ? $title : $fieldValues['value'][$i];
             $extra = '';
             if (!empty($fieldValues['disabled'][$i])) {
                 $extra .= '::disabled';
             }
             $field->value[] = $title . '::' . $value . $extra;
         }
         $field->value = implode("\n", $field->value);
     }
     $fieldsOptions = JRequest::getVar('fieldsoptions', array(), '', 'array');
     foreach ($fieldsOptions as $column => $value) {
         if (!in_array($value, array('<', '<='))) {
             $fieldsOptions[$column] = strip_tags($value);
         } else {
             $fieldsOptions[$column] = $value;
         }
     }
     if ($field->type == "customtext") {
         $fieldsOptions['customtext'] = JRequest::getVar('fieldcustomtext', '', '', 'string', JREQUEST_ALLOWHTML);
         if (empty($field->fieldid)) {
             $field->namekey = 'customtext_' . date('z_G_i_s');
         }
     }
     if ($field->type == 'category') {
         if (empty($field->fieldid)) {
             $field->namekey = 'category_' . date('z_G_i_s');
         }
     }
     if (in_array($field->type, array('birthday', 'date')) && !empty($fieldsOptions['format']) && strpos($fieldsOptions['format'], '%') === false) {
         $app->enqueueMessage('Invalid Format: "' . $fieldsOptions['format'] . '"<br /><br />Please use a combination of:<br /> - %d (which will be replaced by days)<br /> - %m (which will be replaced by months)<br /> - %Y (which will be replaced by years)', 'notice');
         $fieldsOptions['format'] = '';
     }
     $field->options = serialize($fieldsOptions);
     if (empty($field->fieldid) && !in_array($field->type, array('customtext', 'category'))) {
         if (empty($field->namekey)) {
             $field->namekey = $field->fieldname;
         }
         $field->namekey = substr(preg_replace('#[^a-z0-9_]#i', '', strtolower($field->namekey)), 0, 50);
         if (empty($field->namekey) || !preg_match('#^[a-z]#', $field->namekey)) {
             $this->errors[] = 'Please specify a valid Column Name';
             return false;
         }
         $columns = acymailing_getColumns('#__acymailing_subscriber');
         if (isset($columns[$field->namekey])) {
             $this->errors[] = 'The field "' . $field->namekey . '" already exists';
             return false;
         }
         if ($field->type == 'textarea') {
             $query = 'ALTER TABLE `#__acymailing_subscriber` ADD `' . $field->namekey . '` TEXT NOT NULL DEFAULT ""';
         } else {
             $query = 'ALTER TABLE `#__acymailing_subscriber` ADD `' . $field->namekey . '` VARCHAR ( 250 ) NOT NULL DEFAULT ""';
         }
         $this->database->setQuery($query);
         if (!$this->database->query()) {
             return false;
         }
     }
     $fieldid = $this->save($field);
     if (!$fieldid) {
         return false;
     }
     if (empty($field->fieldid)) {
         $orderClass = acymailing_get('helper.order');
         $orderClass->pkey = 'fieldid';
         $orderClass->table = 'fields';
         $orderClass->reOrder();
     }
     JRequest::setVar('fieldid', $fieldid);
     return true;
 }