PHP acymailing_getDate函数代码示例

 function formatString(&$replaceme, $mytag)
 {
     if (!empty($mytag->part)) {
         $parts = explode(' ', $replaceme);
         if ($mytag->part == 'last') {
             $replaceme = count($parts) > 1 ? end($parts) : '';
         } else {
             $replaceme = reset($parts);
         }
     }
     if (!empty($mytag->type)) {
         if (empty($mytag->format)) {
             $mytag->format = JText::_('DATE_FORMAT_LC3');
         }
         if ($mytag->type == 'date') {
             $replaceme = acymailing_getDate(acymailing_getTime($replaceme), $mytag->format);
         } elseif ($mytag->type == 'time') {
             $replaceme = acymailing_getDate($replaceme, $mytag->format);
         }
     }
     if (!empty($mytag->lower)) {
         $replaceme = strtolower($replaceme);
     }
     if (!empty($mytag->upper)) {
         $replaceme = strtoupper($replaceme);
     }
     if (!empty($mytag->ucwords)) {
         $replaceme = ucwords($replaceme);
     }
     if (!empty($mytag->ucfirst)) {
         $replaceme = ucfirst($replaceme);
     }
     if (!empty($mytag->urlencode)) {
         $replaceme = urlencode($replaceme);
     }
     if (!empty($mytag->maxheight) || !empty($mytag->maxwidth)) {
         $pictureHelper = acymailing_get('helper.acypict');
         $pictureHelper->maxHeight = empty($mytag->maxheight) ? 999 : $mytag->maxheight;
         $pictureHelper->maxWidth = empty($mytag->maxwidth) ? 999 : $mytag->maxwidth;
         $replaceme = $pictureHelper->resizePictures($replaceme);
     }
 }

 function scheduleone()
 {
     if (!$this->isAllowed('newsletters', 'schedule')) {
         return;
     }
     $mailid = JRequest::getInt('mailid');
     $subid = JRequest::getInt('subid');
     $senddate = JRequest::getString('senddate', '');
     $sendhours = JRequest::getString('sendhours', '');
     $sendminutes = JRequest::getString('sendminutes', '');
     $senddateComplete = $senddate . ' ' . $sendhours . ':' . $sendminutes;
     $app = JFactory::getApplication();
     JRequest::checkToken() && !empty($mailid) && !empty($subid) or die('Invalid Token');
     $realSendDate = acymailing_getTime($senddateComplete);
     if ($realSendDate < time()) {
         acymailing_display(JText::_('DATE_FUTURE'), 'warning');
         if ($app->isAdmin()) {
             return $this->addqueue();
         } else {
             $frontSubController = acymailing_get('controller.frontsubscriber');
             return $frontSubController->addqueue();
         }
     }
     $mailClass = acymailing_get('class.mail');
     $myNewsletter = $mailClass->get($mailid);
     $queueEntry = new stdClass();
     $queueEntry->mailid = $myNewsletter->mailid;
     $queueEntry->subid = $subid;
     $queueEntry->senddate = $realSendDate;
     $queueEntry->priority = 1;
     $db = JFactory::getDBO();
     $status = $db->insertObject('#__acymailing_queue', $queueEntry);
     if ($status) {
         acymailing_display(JText::sprintf('AUTOSEND_DATE', '<b><i>' . $myNewsletter->subject . '</i></b>', acymailing_getDate($realSendDate)), 'success');
     } else {
         acymailing_display(array(JText::_('ERROR_SAVING'), $db->getErrorMsg()), 'error');
         if ($app->isAdmin()) {
             return $this->addqueue();
         } else {
             $frontSubController = acymailing_get('controller.frontsubscriber');
             return $frontSubController->addqueue();
         }
     }
 }

            ?>
</a></span>
							<?php 
        }
    }
    ?>
					</td>
					<td>
						<?php 
    $subjectLine = acymailing_dispSearch($row->subject, $this->pageInfo->search);
    echo acymailing_tooltip('<b>' . JText::_('JOOMEXT_ALIAS') . ' : </b>' . acymailing_dispSearch($row->alias, $this->pageInfo->search), ' ', '', $subjectLine, acymailing_completeLink(($this->app->isAdmin() ? '' : 'front') . 'newsletter&task=edit&mailid=' . $row->mailid));
    ?>
					</td>
					<td align="center" style="text-align:center">
						<?php 
    echo acymailing_getDate($row->senddate);
    if (!empty($row->countqueued) && acymailing_isAllowed($this->config->get('acl_queue_delete', 'all'))) {
        ?>
							<br/>
							<button class="acymailing_button"
									onclick="if(confirm('<?php 
        echo str_replace("'", "\\'", JText::sprintf('ACY_VALID_DELETE_FROM_QUEUE', $row->countqueued));
        ?>
')){ window.location.href = '<?php 
        echo JURI::base();
        ?>
index.php?option=com_acymailing&ctrl=<?php 
        if (!JFactory::getApplication()->isAdmin()) {
            echo 'front';
        }
        ?>

    echo acymailing_getDate(@$this->mail->created);
    ?>
				</td>
			</tr>
		<?php 
    if (!empty($this->mail->senddate)) {
        ?>
				<tr>
					<td class="key" id="senddatekey">
						<?php 
        echo JText::_('SEND_DATE');
        ?>
					</td>
					<td id="senddateinput">
						<?php 
        echo acymailing_getDate(@$this->mail->senddate);
        ?>
					</td>
					<td class="key" id="sentbykey">
						<?php 
        if (!empty($this->mail->sentby)) {
            echo JText::_('SENT_BY');
        }
        ?>
					</td>
					<td id="sentbyinput">
						<?php 
        echo @$this->sentbyname;
        ?>
					</td>
				</tr>

 function doexport()
 {
     if (!$this->isAllowed('subscriber', 'export')) {
         return;
     }
     JRequest::checkToken() or die('Invalid Token');
     acymailing_increasePerf();
     $filtersExport = JRequest::getVar('exportfilter');
     $listsToExport = JRequest::getVar('exportlists');
     $fieldsToExport = JRequest::getVar('exportdata');
     $inseparator = JRequest::getString('exportseparator');
     $inseparator = str_replace(array('semicolon', 'colon', 'comma'), array(';', ',', ','), $inseparator);
     $exportFormat = JRequest::getString('exportformat');
     if (!in_array($inseparator, array(',', ';'))) {
         $inseparator = ';';
     }
     $exportLists = array();
     if (!empty($filtersExport['subscribed'])) {
         foreach ($listsToExport as $listid => $checked) {
             if (!empty($checked)) {
                 $exportLists[] = (int) $listid;
             }
         }
     }
     $exportFields = array();
     foreach ($fieldsToExport as $fieldName => $checked) {
         if (!empty($checked)) {
             $exportFields[] = acymailing_secureField($fieldName);
         }
     }
     $config = acymailing_config();
     $newConfig = new stdClass();
     $newConfig->export_fields = implode(',', $exportFields);
     $newConfig->export_lists = implode(',', $exportLists);
     $newConfig->export_separator = JRequest::getString('exportseparator');
     $newConfig->export_format = $exportFormat;
     $config->save($newConfig);
     $where = array();
     if (empty($exportLists)) {
         $querySelect = 'SELECT s.`' . implode('`,s.`', $exportFields) . '` FROM ' . acymailing_table('subscriber') . ' as s';
     } else {
         $querySelect = 'SELECT DISTINCT s.`' . implode('`,s.`', $exportFields) . '` FROM ' . acymailing_table('listsub') . ' as a JOIN ' . acymailing_table('subscriber') . ' as s on a.subid = s.subid';
         $where[] = 'a.listid IN (' . implode(',', $exportLists) . ')';
         $where[] = 'a.status = 1';
     }
     if (!empty($filtersExport['confirmed'])) {
         $where[] = 's.confirmed = 1';
     }
     if (!empty($filtersExport['registered'])) {
         $where[] = 's.userid > 0';
     }
     if (!empty($filtersExport['enabled'])) {
         $where[] = 's.enabled = 1';
     }
     if (JRequest::getInt('sessionvalues') and !empty($_SESSION['acymailing']['exportusers'])) {
         $where[] = 's.subid IN (' . implode(',', $_SESSION['acymailing']['exportusers']) . ')';
     }
     if (JRequest::getInt('sessionquery')) {
         $currentSession = JFactory::getSession();
         $exportQuery = $currentSession->get('acyexportquery');
         if (!empty($exportQuery)) {
             $where[] = 's.subid IN (' . $exportQuery . ')';
         }
     }
     $query = $querySelect;
     if (!empty($where)) {
         $query .= ' WHERE (' . implode(') AND (', $where) . ')';
     }
     $db = JFactory::getDBO();
     $db->setQuery($query);
     $allData = $db->loadAssocList();
     $encodingClass = acymailing_get('helper.encoding');
     $exportHelper = acymailing_get('helper.export');
     $exportHelper->addHeaders('acymailingexport');
     $eol = "\r\n";
     $before = '"';
     $separator = '"' . $inseparator . '"';
     $after = '"';
     echo $before . implode($separator, $exportFields) . $after . $eol;
     for ($i = 0, $a = count($allData); $i < $a; $i++) {
         if (!empty($allData[$i]['created'])) {
             $allData[$i]['created'] = acymailing_getDate($allData[$i]['created'], '%Y-%m-%d %H:%M:%S');
         }
         echo $before . $encodingClass->change(implode($separator, $allData[$i]), 'UTF-8', $exportFormat) . $after . $eol;
     }
     exit;
 }

//.........这里部分代码省略.........
                }
                $js .= "while(!document.getElementById('" . $datatype . "type{$num}')){" . $jsFunction . "();}\r\n\t\t\t\t\t\tdocument.getElementById('" . $datatype . "type{$num}').value= '{$oneType}';\r\n\t\t\t\t\t\tupdate" . ucfirst($datatype) . "({$num});";
                if (empty($filter->{$datatype}[$num][$oneType])) {
                    continue;
                }
                foreach ($filter->{$datatype}[$num][$oneType] as $key => $value) {
                    if (is_array($value)) {
                        $js .= "try{";
                        foreach ($value as $subkey => $subval) {
                            $js .= "document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}][{$subkey}]'].value = '" . addslashes(str_replace(array("\n", "\r"), ' ', $subval)) . "';";
                            $js .= "if(document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}][{$subkey}]'].type && document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}][{$subkey}]'].type == 'checkbox'){ document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}][{$subkey}]'].checked = 'checked'; }";
                        }
                        $js .= "}catch(e){}";
                    }
                    $myVal = is_array($value) ? implode(',', $value) : $value;
                    $js .= "try{";
                    $js .= "document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}]'].value = '" . addslashes(str_replace(array("\n", "\r"), ' ', $myVal)) . "';";
                    $js .= "if(document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}]'].type && document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}]'].type == 'checkbox'){ document.adminForm.elements['" . $datatype . "[{$num}][{$oneType}][{$key}]'].checked = 'checked'; }";
                    $js .= "}catch(e){}";
                }
                $js .= "\n" . " if(typeof(onAcyDisplay" . ucfirst($datatype) . "_" . $oneType . ") == 'function'){\r\n\t\t\t\t\ttry{ onAcyDisplay" . ucfirst($datatype) . "_" . $oneType . "({$num}); }catch(e){alert('Error in the onAcyDisplay" . ucfirst($datatype) . "_" . $oneType . " function : '+e); }\r\n\t\t\t\t}";
                if ($datatype == 'filter') {
                    $js .= " countresults({$num});";
                }
            }
        }
        $listid = JRequest::getInt('listid');
        if (!empty($listid)) {
            $js .= "document.getElementById('actiontype0').value = 'list'; updateAction(0); document.adminForm.elements['action[0][list][selectedlist]'].value = '" . $listid . "';";
        }
        $doc->addScriptDeclaration("window.addEvent('domready', function(){ {$js} });");
        $triggers = array();
        $triggers['daycron'] = JText::_('AUTO_CRON_FILTER');
        $nextDate = $config->get('cron_plugins_next');
        $listHours = array();
        $listMinutess = array();
        for ($i = 0; $i < 24; $i++) {
            $listHours[] = JHTML::_('select.option', $i, $i < 10 ? '0' . $i : $i);
        }
        $hours = JHTML::_('select.genericlist', $listHours, 'triggerhours', 'class="inputbox" size="1" style="width:60px;"', 'value', 'text', acymailing_getDate($nextDate, 'H'));
        for ($i = 0; $i < 60; $i += 5) {
            $listMinutess[] = JHTML::_('select.option', $i, $i < 10 ? '0' . $i : $i);
        }
        $defaultMin = floor(acymailing_getDate($nextDate, 'i') / 5) * 5;
        $minutes = JHTML::_('select.genericlist', $listMinutess, 'triggerminutes', 'class="inputbox" size="1" style="width:60px;"', 'value', 'text', $defaultMin);
        $this->assign('hours', $hours);
        $this->assign('minutes', $minutes);
        $this->assign('nextDate', !empty($nextDate) ? ' (' . JText::_('NEXT_RUN') . ' : ' . acymailing_getDate($nextDate, '%d %B %Y  %H:%M') . ')' : '');
        $triggers['allcron'] = JText::_('ACY_EACH_TIME');
        $triggers['subcreate'] = JText::_('ON_USER_CREATE');
        $triggers['subchange'] = JText::_('ON_USER_CHANGE');
        $this->dispatcher->trigger('onAcyDisplayTriggers', array(&$triggers));
        $name = empty($filter->name) ? '' : ' : ' . $filter->name;
        if (JRequest::getCmd('tmpl', '') != 'component') {
            $acyToolbar = acymailing::get('helper.toolbar');
            $acyToolbar->custom('filterDisplayUsers', JText::_('FILTER_VIEW_USERS'), 'user', false, '');
            $acyToolbar->custom('process', JText::_('PROCESS'), 'process', false, '');
            $acyToolbar->divider();
            if (acymailing_level(3)) {
                $acyToolbar->save();
                if (!empty($filter->filid)) {
                    $acyToolbar->link(acymailing_completeLink('filter&task=edit&filid=0'), JText::_('ACY_NEW'), 'new');
                }
            }
            $acyToolbar->link(acymailing_completeLink('dashboard'), JText::_('ACY_CLOSE'), 'cancel');
            $acyToolbar->divider();
            $acyToolbar->help('filter');
            $acyToolbar->setTitle(JText::_('ACY_MASS_ACTIONS') . $name, 'filter&task=edit&filid=' . $filid);
            $acyToolbar->display();
        } else {
            acymailing_setPageTitle(JText::_('ACY_MASS_ACTIONS') . $name);
        }
        $subid = JRequest::getString('subid');
        if (!empty($subid)) {
            $subArray = explode(',', trim($subid, ','));
            JArrayHelper::toInteger($subArray);
            $db->setQuery('SELECT `name`,`email` FROM `#__acymailing_subscriber` WHERE `subid` IN (' . implode(',', $subArray) . ')');
            $users = $db->loadObjectList();
            if (!empty($users)) {
                $this->assignRef('users', $users);
                $this->assignRef('subid', $subid);
            }
        }
        $this->assignRef('typevaluesFilters', $typevaluesFilters);
        $this->assignRef('typevaluesActions', $typevaluesActions);
        $this->assignRef('outputFilters', $outputFilters);
        $this->assignRef('outputActions', $outputActions);
        $this->assignRef('filter', $filter);
        $this->assignRef('triggers', $triggers);
        if (JRequest::getCmd('tmpl') == 'component') {
            $doc->addStyleSheet(ACYMAILING_CSS . 'frontendedition.css?v=' . filemtime(ACYMAILING_MEDIA . 'css' . DS . 'frontendedition.css'));
        }
        if (acymailing_level(3) and JRequest::getCmd('tmpl') != 'component') {
            $db->setQuery('SELECT * FROM #__acymailing_filter ORDER BY `published` DESC, `filid` DESC');
            $filters = $db->loadObjectList();
            $toggleClass = acymailing_get('helper.toggle');
            $this->assignRef('toggleClass', $toggleClass);
            $this->assignRef('filters', $filters);
        }
    }

    ?>
</legend>
			<table class="adminlist table table-striped" cellspacing="1" align="center">
			<tbody>
		<?php 
    $k = 0;
    foreach ($this->nextqueue as $mailid => $row) {
        ?>
					<tr class="<?php 
        echo "row{$k}";
        ?>
">
						<td>
							<?php 
        echo JText::sprintf('EMAIL_READY', $row->mailid, $row->subject, $row->nbsub);
        echo '<br />' . JText::sprintf('QUEUE_NEXT_SCHEDULE', acymailing_getDate($row->senddate));
        ?>
						</td>
					</tr>
					<?php 
        $k = 1 - $k;
    }
    ?>
				</tbody>
			</table>
		</fieldset>
	<?php 
}
?>
	</div>
	<div class="clr"></div>

    ?>
					</td>
					<td align="center" style="text-align:center" >
						<?php 
    echo $row->html ? JText::_('HTML') : JText::_('JOOMEXT_TEXT');
    ?>
					</td>
					<td align="center" style="text-align:center" >
						<?php 
    echo $row->open;
    ?>
					</td>
					<td align="center" style="text-align:center" >
						<?php 
    if (!empty($row->opendate)) {
        echo acymailing_getDate($row->opendate);
    }
    ?>
					</td>
					<?php 
    if (acymailing_level(3)) {
        ?>
					<td align="center" style="text-align:center" >
						<?php 
        if ($row->bounce == 0) {
            echo $row->bounce;
        } else {
            $text = empty($row->bouncerule) ? JText::_('NO_RULE_SAVED') : $row->bouncerule;
            echo acymailing_tooltip($text, JText::_('ACY_RULE'), '', $row->bounce);
        }
        ?>

	function saveReport(){
		$config = acymailing_config();
		$saveReport = $config->get('cron_savereport');
		if(empty($saveReport)) return;

		$reportPath = JPath::clean(ACYMAILING_ROOT.trim(html_entity_decode($config->get('cron_savepath'))));
		acymailing_createDir(dirname($reportPath),true,true);

		file_put_contents($reportPath, "\r\n"."\r\n".str_repeat('*',150)."\r\n".str_repeat('*',20).str_repeat(' ',5).acymailing_getDate(time()).str_repeat(' ',5).str_repeat('*',20)."\r\n".implode("\r\n",$this->messages), FILE_APPEND);
		if($saveReport == 2 AND !empty($this->detailMessages)){
			@file_put_contents($reportPath, "\r\n"."---- Details ----"."\r\n".implode("\r\n",$this->detailMessages), FILE_APPEND);
		}
	}

				</td>
				<td>
					<?php 
echo $this->emaildrop;
?>
				</td>
			</tr>
			<tr>
				<td class="acykey">
					<?php 
echo JText::_('SEND_DATE');
?>
				</td>
				<td>
					<?php 
echo JHTML::_('calendar', acymailing_getDate(time(), '%Y-%m-%d'), 'senddate', 'senddate', '%Y-%m-%d', array('style' => 'width:80px'));
echo '&nbsp; @ ' . $this->hours . ' : ' . $this->minutes;
?>
				</td>
			</tr>
			<tr>
				<td>
				</td>
				<td>
					<button class="btn btn-primary" type="submit"><?php 
echo JText::_('SCHEDULE');
?>
</button>
				</td>
			</tr>
		</table>

//.........这里部分代码省略.........
     $exportHelper = acymailing_get('helper.export');
     $fileName = 'export_' . date('Y-m-d');
     if (!empty($exportLists)) {
         $fileName = '';
         $db->setQuery('SELECT name FROM #__acymailing_list WHERE listid IN (' . implode(',', $exportLists) . ')');
         $allExportedLists = $db->loadObjectList();
         foreach ($allExportedLists as $oneList) {
             $fileName .= '__' . $oneList->name;
         }
         $fileName = trim($fileName, '__');
     }
     $exportHelper->addHeaders($fileName);
     acymailing_displayErrors();
     $eol = "\r\n";
     $before = '"';
     $separator = '"' . $inseparator . '"';
     $after = '"';
     $allFields = array_merge($exportFields, $exportFieldsOthers);
     if (!empty($exportFieldsList)) {
         $allFields = array_merge($allFields, $exportFieldsList);
         $selectFields = 'l.`' . implode('`, l.`', $exportFieldsList) . '`';
         $selectFields = str_replace('listname', 'name', $selectFields);
     }
     if (!empty($exportFieldsGeoloc)) {
         $allFields = array_merge($allFields, $exportFieldsGeoloc);
     }
     $titleLine = $before . implode($separator, $allFields) . $after . $eol;
     $titleLine = str_replace('listid', 'listids', $titleLine);
     echo $titleLine;
     if (acymailing_bytes(ini_get('memory_limit')) > 150000000) {
         $nbExport = 50000;
     } elseif (acymailing_bytes(ini_get('memory_limit')) > 80000000) {
         $nbExport = 15000;
     } else {
         $nbExport = 5000;
     }
     if (!empty($exportFieldsList)) {
         $nbExport = 500;
     }
     $valDep = 0;
     $dateFields = array('created', 'confirmed_date', 'lastopen_date', 'lastclick_date', 'lastsent_date', 'userstats_opendate', 'userstats_senddate', 'urlclick_date', 'hist_date');
     do {
         $db->setQuery($query . ' LIMIT ' . $valDep . ', ' . $nbExport);
         $valDep += $nbExport;
         $allData = $db->loadAssocList('subid');
         if ($allData === false) {
             echo $eol . $eol . 'Error : ' . $db->getErrorMsg();
         }
         if (empty($allData)) {
             break;
         }
         foreach ($allData as $subid => &$oneUser) {
             if (!in_array('subid', $exportFields)) {
                 unset($allData[$subid]['subid']);
             }
             foreach ($dateFields as &$fieldName) {
                 if (isset($allData[$subid][$fieldName])) {
                     $allData[$subid][$fieldName] = acymailing_getDate($allData[$subid][$fieldName], '%Y-%m-%d %H:%M:%S');
                 }
             }
         }
         if (!empty($exportFieldsList) && !empty($allData)) {
             $queryList = 'SELECT ' . $selectFields . ', ls.subid FROM #__acymailing_listsub as ls JOIN #__acymailing_list as l ON ls.listid=l.listid JOIN #__acymailing_subscriber as s on ls.subid = s.subid WHERE (ls.status = 1) and ls.subid IN (' . implode(',', array_keys($allData)) . ')';
             if (!empty($exportLists)) {
                 $queryList .= ' AND ls.listid IN (' . implode(',', $exportLists) . ')';
             }
             $db->setQuery($queryList);
             $resList = $db->loadObjectList();
             foreach ($resList as &$listsub) {
                 if (in_array('listid', $exportFieldsList)) {
                     $allData[$listsub->subid]['listid'] = empty($allData[$listsub->subid]['listid']) ? $listsub->listid : $allData[$listsub->subid]['listid'] . ' - ' . $listsub->listid;
                 }
                 if (in_array('listname', $exportFieldsList)) {
                     $allData[$listsub->subid]['listname'] = empty($allData[$listsub->subid]['listname']) ? $listsub->name : $allData[$listsub->subid]['listname'] . ' - ' . $listsub->name;
                 }
             }
             unset($resList);
         }
         if (!empty($exportFieldsGeoloc) && !empty($allData)) {
             $orderGeoloc = JRequest::getCmd('exportgeolocorder');
             if (strtolower($orderGeoloc) !== 'desc') {
                 $orderGeoloc = 'asc';
             }
             $db->setQuery('SELECT geolocation_subid,' . implode(', ', $exportFieldsGeoloc) . ' FROM (SELECT * FROM #__acymailing_geolocation WHERE geolocation_subid IN (' . implode(',', array_keys($allData)) . ') ORDER BY geolocation_id ' . $orderGeoloc . ') as geoloc GROUP BY geolocation_subid');
             $resGeol = $db->loadObjectList();
             foreach ($resGeol as $geolData) {
                 foreach ($exportFieldsGeoloc as $geolField) {
                     $allData[$geolData->geolocation_subid][$geolField] = $geolField == 'geolocation_created' ? acymailing_getDate($geolData->{$geolField}, '%Y-%m-%d %H:%M:%S') : $geolData->{$geolField};
                 }
             }
             unset($resGeol);
         }
         foreach ($allData as $subid => &$oneUser) {
             $dataexport = implode($separator, $oneUser);
             echo $before . $encodingClass->change($dataexport, 'UTF-8', $exportFormat) . $after . $eol;
         }
         unset($allData);
     } while (true);
     exit;
 }

 function exportglobal()
 {
     $nlCondition = '';
     $cids = JRequest::getVar('cid');
     JArrayHelper::toInteger($cids);
     if (!empty($cids)) {
         $nlCondition = ' WHERE a.mailid IN (' . implode(', ', $cids) . ') ';
     }
     $db = JFactory::getDBO();
     $query = 'SELECT b.subject, a.senddate, a.* , a.bouncedetails FROM #__acymailing_stats as a JOIN #__acymailing_mail as b on a.mailid = b.mailid ' . $nlCondition . ' ORDER BY a.senddate desc';
     $db->setQuery($query);
     $mydata = $db->loadObjectList();
     $exportHelper = acymailing_get('helper.export');
     $config = acymailing_config();
     $encodingClass = acymailing_get('helper.encoding');
     $exportHelper->addHeaders('globalStatistics_' . date('m_d_y'));
     $eol = "\r\n";
     $before = '"';
     $separator = '"' . str_replace(array('semicolon', 'comma'), array(';', ','), $config->get('export_separator', ';')) . '"';
     $exportFormat = $config->get('export_format', 'UTF-8');
     $after = '"';
     $forwardEnabled = $config->get('forward', 0);
     $titles = array(JText::_('JOOMEXT_SUBJECT'), JText::_('SEND_DATE'), JText::_('OPEN_UNIQUE'), JText::_('OPEN_TOTAL'), JText::_('OPEN') . ' (%)');
     if (acymailing_level(1)) {
         array_push($titles, JTEXT::_('UNIQUE_HITS'), JTEXT::_('TOTAL_HITS'), JText::_('CLICKED_LINK') . ' (%)');
     }
     array_push($titles, JText::_('UNSUBSCRIBE'), JText::_('UNSUBSCRIBE') . ' (%)');
     if (acymailing_level(1) && $forwardEnabled == 1) {
         array_push($titles, JText::_('FORWARDED'));
     }
     array_push($titles, JText::_('SENT_HTML'), JText::_('SENT_TEXT'));
     if (acymailing_level(3)) {
         array_push($titles, JText::_('BOUNCES'), JText::_('BOUNCES') . ' (%)');
     }
     array_push($titles, JText::_('FAILED'), JText::_('ACY_ID'));
     $titleLine = $before . implode($separator, $titles) . $after . $eol;
     echo $titleLine;
     foreach ($mydata as $nl) {
         $line = $nl->subject . $separator;
         $line .= acymailing_getDate($nl->senddate) . $separator;
         $line .= $nl->openunique . $separator;
         $line .= $nl->opentotal . $separator;
         $cleanSent = $nl->senthtml + $nl->senttext;
         if (acymailing_level(3)) {
             $cleanSent = $cleanSent - $nl->bounceunique;
         }
         $prct = !empty($cleanSent) ? round($nl->openunique / $cleanSent * 100, 2) : '-';
         $line .= $prct . '%' . $separator;
         if (acymailing_level(1)) {
             $line .= $nl->clickunique . $separator;
             $line .= $nl->clicktotal . $separator;
             $prct = !empty($cleanSent) ? round($nl->clickunique / $cleanSent * 100, 2) : '-';
             $line .= $prct . '%' . $separator;
         }
         $line .= $nl->unsub . $separator;
         $prct = !empty($cleanSent) ? round($nl->unsub / $cleanSent * 100, 2) : '-';
         $line .= $prct . '%' . $separator;
         if (acymailing_level(1) && $forwardEnabled == 1) {
             $line .= $nl->forward . $separator;
         }
         $line .= $nl->senthtml . $separator;
         $line .= $nl->senttext . $separator;
         if (acymailing_level(3)) {
             $line .= $nl->bounceunique . $separator;
             $prct = !empty($nl->senthtml) ? round($nl->bounceunique / ($nl->senthtml + $nl->senttext) * 100, 2) : '-';
             $line .= $prct . '%' . $separator;
         }
         $line .= $nl->fail . $separator;
         $line .= $nl->mailid;
         $line = $before . $encodingClass->change($line, 'UTF-8', $exportFormat) . $after . $eol;
         echo $line;
     }
     exit;
 }

		google.setOnLoadCallback(drawClic);
		google.setOnLoadCallback(drawUnsub);
		google.setOnLoadCallback(drawForward);

		function showData(typeGraph){
			if(document.getElementById('exporteddata_' + typeGraph).style.display == 'none'){
				document.getElementById('exporteddata_' + typeGraph).style.display = '';
			}else{
				document.getElementById('exporteddata_' + typeGraph).style.display = 'none';
			}
		}
	</script>

	<div id="iframedoc"></div>
	<?php 
echo JText::_('SEND_DATE') . ' : <span class="statnumber">' . acymailing_getDate($this->mailing->senddate);
?>
</span><br/>

	<div class="acychart mailingListChart" width="350px" height="350px">
		<div id="chartMailSent"></div>
		<img style="position:relative;cursor:pointer;margin-top:-30px;" onclick="showData('sent');" class="donotprint" src="<?php 
echo ACYMAILING_IMAGES . 'smallexport.png';
?>
" alt="<?php 
echo JText::_('VIEW_DETAILS', true);
?>
" title="<?php 
echo JText::_('VIEW_DETAILS', true);
?>
" width="30px"/>

<script language="JavaScript" type="text/javascript">
     function statsusers(){
		var dataTable = new google.visualization.DataTable();
		dataTable.addRows(<?php 
echo count($this->statsusers);
?>
);
		dataTable.addColumn('string');
		dataTable.addColumn('number','<?php 
echo JText::_('USERS', true);
?>
');
		<?php 
$i = count($this->statsusers) - 1;
foreach ($this->statsusers as $oneResult) {
    echo "dataTable.setValue({$i}, 0, '" . addslashes(acymailing_getDate(acymailing_getTime($oneResult->subday), JText::_('DATE_FORMAT_LC3'))) . "'); ";
    echo "dataTable.setValue({$i}, 1, " . intval(@$oneResult->total) . "); ";
    if ($i-- == 0) {
        break;
    }
}
?>
        var vis = new google.visualization.ColumnChart(document.getElementById('statsusers'));
        var options = {
        	width:document.documentElement.clientWidth/2,
          height: 300,
          legend:'none'
        };
        vis.draw(dataTable, options);
	}
	google.load("visualization", "1", {packages:["corechart"]});

            echo JText::_('STATISTICS', true);
            ?>
" /></a></span>
							<?php 
        }
        ?>
						<?php 
    }
    ?>
					</td>
					<?php 
    if ($this->values->show_senddate) {
        ?>
					<td align="center" nowrap="nowrap">
						<?php 
        echo acymailing_getDate($row->senddate, JText::_('DATE_FORMAT_LC3'));
        ?>
					</td>
					<?php 
    }
    ?>
					<?php 
    if ($this->values->show_receiveemail) {
        ?>
					<td align="center" nowrap="nowrap" class="receiveviaemail">
						<input onclick="changeReceiveEmail(this.checked)" type="checkbox" name="receivemail[]" value="<?php 
        echo $row->mailid;
        ?>
" id="receive_<?php 
        echo $row->mailid;
        ?>