export.php

<?php
if (!defined('sugarEntry') || !sugarEntry) {
    die('Not A Valid Entry Point');
}
/**
 *
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
 *
 * SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
 * Copyright (C) 2011 - 2018 SalesAgility Ltd.
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for technical reasons, the Appropriate Legal Notices must
 * display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 */

//Bug 30094, If zlib is enabled, it can break the calls to header() due to output buffering. This will only work php5.2+
ini_set('zlib.output_compression', 'Off');

ob_start();
require_once('include/export_utils.php');
global $sugar_config;
global $current_user;
global $app_list_strings;
global $db;
global $beanList;
global $log;

$the_module = clean_string($_REQUEST['module']);

if (empty($current_user) || empty($current_user->id)) {
    die($GLOBALS['app_strings']['ERR_EXPORT_DISABLED']);
}

if ($sugar_config['disable_export'] 	|| (!empty($sugar_config['admin_export_only']) && !(is_admin($current_user) || (ACLController::moduleSupportsACL($the_module)  && ACLAction::getUserAccessLevel($current_user->id, $the_module, 'access') == ACL_ALLOW_ENABLED &&
    (ACLAction::getUserAccessLevel($current_user->id, $the_module, 'admin') == ACL_ALLOW_ADMIN ||
     ACLAction::getUserAccessLevel($current_user->id, $the_module, 'admin') == ACL_ALLOW_ADMIN_DEV))))) {
    die($GLOBALS['app_strings']['ERR_EXPORT_DISABLED']);
}

if (empty($beanList[$_REQUEST['module']])) {
    $log->security("export: trying to access an invalid module '" . $_REQUEST['module'] . "'");
    throw new RuntimeException('Unexpected error. See logs.');
}

$bean = $beanList[$_REQUEST['module']];

//check to see if this is a request for a sample or for a regular export
if (!empty($_REQUEST['sample'])) {
    //call special method that will create dummy data for bean as well as insert standard help message.
    $content = exportSample($the_module);
} else {
    if (!empty($_REQUEST['uid'])) {
        $ids = explode(',', $_REQUEST['uid']);
    } else {
        $ids = array();
        $bean = BeanFactory::getBean($the_module);
        $currentQuery = generateSearchWhere($the_module, $_REQUEST['current_post']);
        if (!empty($currentQuery['where'])) {
            // handle select all queries with filters
            $query = $bean->create_new_list_query(
                "",
                $currentQuery['where'],
                array(),
                array(),
                0,
                '',
                false,
                $bean,
                true,
                true
            );
            $result = $db->query($query, true);
        } else {
            // handle default select all
            $result = $db->query("SELECT id FROM $bean->table_name WHERE deleted=0;");
        }

        while ($val = $db->fetchByAssoc($result, false)) {
            $ids[] = $val['id'];
        }

        unset($result, $bean);
    }

    $idChunks = array_chunk($ids, 1000, true);
    $content = '';
    $displayHeaders = true;
    foreach($idChunks as $chunk) {
        $content .= export($the_module, implode(",", $chunk), isset($_REQUEST['members']) ? $_REQUEST['members'] : false, false, $displayHeaders);
        $displayHeaders = false;
    }
}
$filename = $_REQUEST['module'];
//use label if one is defined
if (!empty($app_list_strings['moduleList'][$_REQUEST['module']])) {
    $filename = $app_list_strings['moduleList'][$_REQUEST['module']];
}

if (!empty($_REQUEST['members'])) {
    $filename .= '_'.'members';
}
///////////////////////////////////////////////////////////////////////////////
////	BUILD THE EXPORT FILE

ob_clean();
printCSV($content, $filename);
sugar_cleanup(true);