Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_rsmembership/helpers/export.php

Назад
<?php /** * @package RSMembership! * @copyright (c) 2009 - 2016 RSJoomla! * @link https://www.rsjoomla.com * @license GNU General Public License http://www.gnu.org/licenses/gpl-3.0.en.html */ defined('_JEXEC') or die('Restricted access'); class RSMembershipExport { public static function buildCSV($type, $data, $fileHash = '', $customFields = null) { require_once JPATH_COMPONENT.'/helpers/helper.php'; $rows = ''; if ($fileHash == '') { // Build header switch($type) { case 'subscribers': $headers = array( JText::_('COM_RSMEMBERSHIP_SUBSCRIBER_ID'), JText::_('COM_RSMEMBERSHIP_ENABLED'), JText::_('COM_RSMEMBERSHIP_NAME'), JText::_('COM_RSMEMBERSHIP_USERNAME'), JText::_('COM_RSMEMBERSHIP_EMAIL') ); if ($customFields) { foreach ($customFields as $id => $properties) { $headers[] = JText::_($properties->label); } } $headers[] = JText::_('COM_RSMEMBERSHIP_ACTIVE_SUBSCRIPTIONS'); $headers[] = JText::_('COM_RSMEMBERSHIP_TOTAL_SUBSCRIPTIONS'); break; case 'subscriptions': $headers = array( JText::_('COM_RSMEMBERSHIP_MEMBERSHIP'), JText::_('COM_RSMEMBERSHIP_CATEGORY_NAME'), JText::_('COM_RSMEMBERSHIP_MEMBERSHIP_EXTRAS'), JText::_('COM_RSMEMBERSHIP_USERNAME'), JText::_('COM_RSMEMBERSHIP_EMAIL'), JText::_('COM_RSMEMBERSHIP_STATUS'), JText::_('COM_RSMEMBERSHIP_NOTIFIED'), JText::_('COM_RSMEMBERSHIP_START_DATE'), JText::_('COM_RSMEMBERSHIP_START_END'), JText::_('JPUBLISHED') ); break; } // Add header to rows $rows .= '"'.implode('","', $headers).'"'."\n"; } $cache = RSMembershipHelper::getCache(); // Add the data to rows foreach ($data as $i => $entry) { $row = (array) $entry; switch($type) { case 'subscribers': $row['block'] = $row['block'] ? JText::_('JNO') : JText::_('JYES'); break; case 'subscriptions': if (empty($row['category_id'])) { $row['category_name'] = JText::_('COM_RSMEMBERSHIP_NO_CATEGORY'); } unset($row['category_id']); unset($row['membership_id']); unset($row['id']); unset($row['user_id']); $row['membership_start'] = RSMembershipHelper::showDate($row['membership_start']); $row['membership_end'] = ($row['membership_end'] != '0000-00-00 00:00:00' ? RSMembershipHelper::showDate($row['membership_end']) : ' - '); $row['notified'] = ($row['notified'] != '0000-00-00 00:00:00' ? RSMembershipHelper::showDate($row['notified']) : ' - '); $row['status'] = JText::_('COM_RSMEMBERSHIP_STATUS_'.$row['status']); $row['published'] = $row['published'] ? JText::_('JYES') : JText::_('JNO'); if ($entry->extras) { $row['extras'] = array(); $entry->extras = explode(',', $entry->extras); foreach ($entry->extras as $value) { if (isset($cache->extra_values[$value])) { $row['extras'][] = $cache->extra_values[$value]; } } $row['extras'] = implode(', ', $row['extras']); } break; } array_walk($row, array('RSMembershipExport', 'fixValue')); $rows .= '"'.implode('","',$row).'"'; $rows .="\n"; } return $rows; } public static function fixValue(&$string, $key) { if (strlen($string) && in_array($string[0], array('=', '+', '-', '@'))) { $string = ' ' . $string; } } public static function writeCSV($type, $query, $totalItems, $from, $fileHash = '', $filename, $customFields = null) { if (!is_writable(JFactory::getConfig()->get('tmp_path'))) { throw new Exception(JText::sprintf('COM_RSMEMBERSHIP_TMP_PATH_NOT_WRITABLE', JFactory::getConfig()->get('tmp_path'))); } $db = JFactory::getDbo(); $db->setQuery($query, $from, 10); $data = $db->loadObjectList(); $fileContent = RSMembershipExport::buildCSV($type, $data, $fileHash, $customFields); // build the file hash if not already created if (!$fileHash) { $now = JHtml::date('now','D, d M Y H:i:s'); $date = JHtml::date('now','Y-m-d_H-i-s'); $filename = $filename.'-'.$date.'.csv'; $fileHash = md5($filename.$now); } // create or append the hashed file and put content if ($fileContent) { if (!file_put_contents(self::getTmpPath($fileHash), $fileContent, FILE_APPEND)) { throw new Exception(JText::sprintf('COM_RSMEMBERSHIP_COULD_NOT_EXPORT_CSV_PATH', self::getTmpPath($fileHash))); } } else { throw new Exception(JText::_('COM_RSMEMBERSHIP_EXPORT_NO_DATA')); } $newFrom = ($from + 10); $checkRemaining = $totalItems - $newFrom; return (object) array( 'newFrom' => ($checkRemaining > 0 ? $newFrom : $totalItems), 'fileHash' => $fileHash ); } public static function getCSV($fileHash) { $file = self::getTmpPath($fileHash); $content = is_file($file) ? file_get_contents($file) : ''; return $content; } protected static function getTmpPath($fileHash) { return JFactory::getConfig()->get('tmp_path').'/'.$fileHash; } public static function buildCSVHeaders($filename) { // disable caching $now = JHtml::date('now','D, d M Y H:i:s'); $date = JHtml::date('now','Y-m-d_H-i-s'); $filename = $filename.'-'.$date.'.csv'; header("Expires: Tue, 03 Jul 2001 06:00:00 GMT"); header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate"); header("Last-Modified: ".$now." GMT"); // force download header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); // disposition / encoding on response body header("Content-Disposition: attachment;filename=".$filename); header("Content-Transfer-Encoding: binary"); } }

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка