/**
 * Created by PhpStorm.
 * User: matedealer
 * Date: 3/23/16
 * Time: 7:29 PM
 */
function users_export_controller($type)
{
    if (isset($_REQUEST['key']) && preg_match("/^[0-9a-f]{32}\$/", $_REQUEST['key'])) {
        $key = $_REQUEST['key'];
    } else {
        die("Missing key.");
    }
    $user = User_by_api_key($key);
    if ($user === false) {
        die("Unable to find user.");
    }
    if ($user == null) {
        die("Key invalid.");
    }
    if (!in_array('admin_user', privileges_for_user($user['UID']))) {
        die("No privilege for export users.");
    }
    if ($type == 'csv') {
        export_csv();
    } elseif ($type == 'mail') {
        export_mail();
    }
}

}
db_connect($db_server, $db_name, $db_user, $db_pass);
if ($db_charset && 'mysql' == $db_driver) {
    db_exe("SET NAMES {$db_charset}");
}
if (isset($_GET['dump_all']) && 1 == $_GET['dump_all']) {
    dump_all($data = false);
}
if (isset($_GET['dump_all']) && 2 == $_GET['dump_all']) {
    dump_all($data = true);
}
if (isset($_GET['dump_table']) && $_GET['dump_table']) {
    dump_table($_GET['dump_table']);
}
if (isset($_GET['export']) && 'csv' == $_GET['export']) {
    export_csv(base64_decode($_GET['query']), $_GET['separator']);
}
if (isset($_POST['sqlfile']) && $_POST['sqlfile']) {
    $files = sql_files_assoc();
    if (!isset($files[$_POST['sqlfile']])) {
        exit('File not found. md5 = ' . $_POST['sqlfile']);
    }
    $sqlfile = $files[$_POST['sqlfile']];
    layout();
    echo '<div>Importing: <b>' . $sqlfile . '</b> (' . size(filesize($sqlfile)) . ')</div>';
    echo '<div>Database: <b>' . $db_name . '</b></div>';
    flush();
    import($sqlfile, post('ignore_errors'), post('transaction'), post('force_myisam'), post('query_start', 'int'));
    exit;
}
if (isset($_POST['drop_table']) && $_POST['drop_table']) {

 * the Free Software Foundation, either version 3 of the License, or (at
 * your option) any later version.
 * 
 * allocPSA 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 allocPSA. If not, see <http://www.gnu.org/licenses/>.
*/
// Get an exported representation of something (at the moment, only a project)
// Call as: get_export.php?entity=project&id=1&format=planner
require_once "../alloc.php";
if (isset($_GET["id"]) && isset($_GET["entity"])) {
    switch ($_GET["entity"]) {
        case "project":
            switch ($_GET["format"]) {
                case "planner":
                    header('Content-Type: application/xml');
                    header('Content-Disposition: attachment; filename="allocProject.planner"');
                    echo export_gnome_planner(intval($_GET["id"]));
                    break;
                case "csv":
                    header('Content-Type: text/plain');
                    header('Content-Disposition: attachment; filename="allocProject.csv"');
                    echo export_csv(intval($_GET["id"]));
            }
            break;
    }
}

    case "weight_chart":
        $sth = $conn->prepare("SELECT strftime('%s',date)*1000 AS datetime, hiveweight, hiverawweight FROM allhivedata WHERE date > datetime('now','{$sqlperiod}') ORDER BY datetime");
        $sth->execute();
        $result = $sth->fetchAll(PDO::FETCH_ASSOC);
        foreach ($result as $r) {
            $out[] = array((double) $r['datetime'], (double) $r['hiveweight']);
        }
        break;
    case "weight_data":
        $sth = $conn->prepare("SELECT hiveid, date, hiveweight, hiverawweight FROM allhivedata WHERE date > datetime('now','{$sqlperiod}') ORDER BY date");
        $sth->execute();
        break;
}
switch ($output) {
    case "csv":
        export_csv($sth, $type, $period);
        break;
    case "json":
        export_json($sth);
        break;
    case "highcharts":
        export_highcharts($out);
        break;
}
#echo "Period is $sqlperiod";
#echo "Type is $type";
// Get Weather/Hive Data First - from a DB view, this may be very slow
function export_highcharts($out)
{
    //?type=temp&period=month&output=highcharts'
    // Convert time to Unix EPOCH, output one value only.

 */
include "../functions/functions.export.php";
if (isset($_GET['data'])) {
    export_fixed_width(intval($_GET['data']));
    exit;
}
if (isset($_GET['ddi'])) {
    export_ddi(intval($_GET['ddi']));
    exit;
}
if (isset($_GET['csv'])) {
    export_csv(intval($_GET['csv']));
    exit;
}
if (isset($_GET['csvl'])) {
    export_csv(intval($_GET['csvl']), true, true);
    exit;
}
if (isset($_GET['pspp'])) {
    export_pspp(intval($_GET['pspp']));
    exit;
}
if (isset($_GET['psppn'])) {
    export_pspp(intval($_GET['psppn']), false);
    exit;
}
xhtml_head(T_("Export Data"), true, array("../css/table.css"), array("../js/display.js"));
$data_id = 0;
if (isset($_GET['data_id'])) {
    $data_id = intval($_GET['data_id']);
}

$interbreadcrumb[] = array("url" => "index.php", "name" => get_lang('MySpace'));
Display::display_header($nameTools);
// Database Table Definitions
$tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
$tbl_user = Database::get_main_table(TABLE_MAIN_USER);
$tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
$tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
$tbl_track_exercice = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
/*
 	MAIN CODE
*/
$sql_course = "SELECT title, code, id FROM {$tbl_course} as course ORDER BY title ASC";
$result_course = Database::query($sql_course);
if (Database::num_rows($result_course) > 0) {
    if (isset($_POST['export'])) {
        $export_result = export_csv($header, $data, 'test.csv');
        // TODO: There is no data for exporting yet.
        Display::display_error_message($export_result);
    }
    echo '<table class="data_table"><tr><th>' . get_lang('Course') . '</th><th>' . get_lang('TempsFrequentation') . '</th><th>' . get_lang('Progression') . '</th><th>' . get_lang('MoyenneTest') . '</th></tr>';
    $header = array(get_lang('Course', ''), get_lang('TempsFrequentation', ''), get_lang('Progression', ''), get_lang('MoyenneTest', ''));
    while ($a_course = Database::fetch_array($result_course)) {
        // TODO: This query is to be checked, there are no HotPotatoes tests results.
        $sql_moy_test = "SELECT exe_result,exe_weighting\n\t\t\tFROM {$tbl_track_exercice}\n\t\t\tWHERE c_id = " . $a_course['id'];
        $result_moy_test = Database::query($sql_moy_test);
        $result = 0;
        $weighting = 0;
        while ($moy_test = Database::fetch_array($result_moy_test)) {
            $result = $result + $moy_test['exe_result'];
            $weighting = $weighting + $moy_test['exe_weighting'];
        }

function _wpr_export()
{
    $nid = $_POST['newsletter'];
    export_csv($nid);
    exit;
}

if (!defined('SYSTEM_ROOT')) {
    die('Insufficient Permissions');
}
function export_csv($filename, $data)
{
    header("Content-type:text/csv");
    header("Content-Disposition:attachment;filename=" . $filename);
    header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
    header('Expires:0');
    header('Pragma:public');
    echo $data;
}
if (isset($_REQUEST['e'])) {
    global $m;
    $m->query('TRUNCATE TABLE `' . DB_NAME . '`.`' . DB_PREFIX . 'fyy_errorlog`');
    Redirect(SYSTEM_URL . 'index.php?mod=admin:tools&ok');
} elseif (isset($_REQUEST['d'])) {
    global $m;
    $csv = $m->query('SELECT * FROM `' . DB_NAME . '`.`' . DB_PREFIX . 'fyy_errorlog` ORDER BY `time`');
    $str = "错误信息,时间,种类,路径,行数\n";
    $str = iconv('utf-8', 'gb2312', $str);
    while ($row = $m->fetch_array($csv)) {
        $row['error'] = iconv('utf-8', 'gb2312', $row['error']);
        $row['type'] = iconv('utf-8', 'gb2312', $row['type']);
        $row['file'] = iconv('utf-8', 'gb2312', $row['file']);
        $row['line'] = iconv('utf-8', 'gb2312', $row['line']);
        $str .= $row['error'] . "," . $row['time'] . "," . $row['type'] . "," . $row['file'] . "," . $row['line'] . "\n";
    }
    $filename = '错误信息' . date('Ymd') . '.csv';
    export_csv($filename, $str);
}

            //print _T('None', 'msc')." ".$verb[0]." ";
        } elseif ($ss[0] == '1') {
            print _T('One', 'msc') . " " . $verb[0] . " ";
        } else {
            print $ss[0] . " " . $verb[1] . " ";
        }
        if ($ss[0] != '0') {
            print $sl[1];
        }
        if (count($sl) == 4 and $ss[0] != '0') {
            print " " . sprintf($sl[3], $status[$l[0]][$sl[2]][0]);
        }
        if ($ss[0] == 0) {
            //print "</td><td><img src='modules/msc/graph/nocsv.png' alt='no csv export possible'/></td></tr>";
        } else {
            print "</td>" . export_csv($cmd_id, $_GET['bundle_id'], $sl[0]) . "</tr>";
        }
    }
}
/*
 *  bundle treatment:
 *  -----------------
 *
 *  machines can be stored in more than one status (one package can be success, and another in fail state)
 *
 *  If one package is failed, bundle is in fail status
 *  If no failed, but one running package, bundle is in running status
 *  For package paused => running status
 *  For package stopped => failed status
 */
if (strlen($_GET['bundle_id']) and !isset($_GET['tab'])) {

if (!isset($_SESSION['username']) || !isset($_SESSION['password'])) {
    header("Location: ../../login.php");
}
$ini_array = parse_ini_file("../../config/cmdb.conf");
$dbhost = $ini_array['db_host'];
$dbport = $ini_array['db_port'];
$dbuser = $ini_array['db_user'];
$dbpass = $ini_array['db_pass'];
$dbname = $ini_array['db_name'];
$conn = mysql_connect("{$dbhost}:{$dbport}", $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db($dbname);
include_once '../../classes/Contact.php';
$file_name = trim($_GET['report_name']) . ".csv";
header("Content-type:text/octect-stream");
header("Content-Disposition:attachment;filename=\"{$file_name}\"");
$csv_data = export_csv();
print $csv_data;
function export_csv()
{
    if (isset($_GET['report_name']) && $_GET['report_name'] != '') {
        $name = $_GET['report_name'];
    } else {
        return "<b>Sorry invalid report name " . $_GET['report_name'] . "</b>";
    }
    $query = "select accounting_reports.id, accounting_reports.profile_id, accounting_reports.report_name, \n\t\t\taccounting_reports.date1, accounting_reports.date2, \n\t\t\taccounting_reports.avg_in, accounting_reports.avg_out, \n\t\t\taccounting_reports.max_in, accounting_reports.max_out,95_in as in95,\n\t\t\taccounting_reports.95_out as out95 , accounting_reports.tot_in, accounting_reports.tot_out,\n\t\t\taccounting_reports.sample_date1,   accounting_reports.sample_date2, \n\t\t\taccounting_reports.traffic_cap, accounting_profiles.client_id\n\t\t\tfrom \n\t\t\taccounting_reports, accounting_profiles where report_name = '{$name}'\n\t\t\tAND accounting_profiles.profile_id =  accounting_reports.profile_id";
    $result = mysql_query($query);
    if (!$result) {
        return "failed to execute query {$query}<br>";
    }
    $heading = array("Client", "Accounting Profile", "Report Name", "Start date", "End date", "Average In (b/s)", "Average out (b/s)", "Max In (b/s)", "Max out (b/s)", "95% In (b/s)", "95% out (b/s)", "95% Billing (b/s)", "95% Billing (Mb/s)", "Committed Traffic (b/s)", "Commitment Status", "Total In (Bytes)", "Total out (Bytes)", "First Sample date", "Last Sample date");
    $content = implode(",", $heading);

        }
        $data .= "\n";
        foreach ($items as $item) {
            foreach ($data_field as $key => $value) {
                $item[$key] = str_replace(" ", " ", $item[$key]);
                $item[$key] = htmlspecialchars_decode($item[$key]);
                //$item[$key] = str_replace(',', ' ', $item[$key]);
                $item[$key] = preg_replace("/[\r\n]+/", ' ', $item[$key]);
                $data .= '"' . $item[$key] . '"' . ',';
            }
            $data .= "\n";
        }
        return $data;
    } else {
        return 'no data';
    }
}
if ($_GET['active'] == 'true') {
    $user_data = get_data($activity_id, true);
} else {
    $user_data = get_data($activity_id, false);
}
$user_data = mb_convert_encoding($user_data, 'GBK', 'UTF-8');
if ($_GET['active'] == 'true') {
    $filename = 'actived_user-' . date('Ymd') . '.csv';
} else {
    $filename = 'processing_user-' . date('Ymd') . '.csv';
}
$filename = iconv('UTF-8', 'GBK', $filename);
export_csv($filename, $user_data);

 */
include "../config.inc.php";
/**
 * XHTML functions
 */
include "../functions/functions.xhtml.php";
/**
 * DB functions
 */
include "../db.inc.php";
/**
 * Export functions
 */
include "../functions/functions.export.php";
if (isset($_GET['download']) && isset($_GET['data_id']) && isset($_GET['code_column']) && isset($_GET['text_column'])) {
    export_csv(intval($_GET['data_id']), true, false, false, array(intval($_GET['code_column']), intval($_GET['text_column'])), false);
    exit;
}
xhtml_head(T_("Export code keyword correspondence"), true, array("../css/table.css"), array("../js/display.js"));
$data_id = 0;
if (isset($_GET['data_id'])) {
    $data_id = intval($_GET['data_id']);
}
//Select a data file to export data from
$sql = "SELECT data_id as value,description, CASE WHEN data_id = '{$data_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\tFROM data";
print "<div>" . T_("Select data file: ");
display_chooser($db->GetAll($sql), 'data_id', 'data_id');
print "</div>";
if ($data_id != 0) {
    $code_column = 0;
    if (isset($_GET['code_column'])) {

// Database Table Definitions
$tbl_course 		= Database :: get_main_table(TABLE_MAIN_COURSE);
$tbl_user 			= Database :: get_main_table(TABLE_MAIN_USER);
$tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
$tbl_session 		= Database :: get_main_table(TABLE_MAIN_SESSION);
$tbl_track_exercice = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);

/*
 	MAIN CODE
*/
$sql_course = "SELECT title,code FROM $tbl_course as course ORDER BY title ASC";
$result_course = Database::query($sql_course);

if (Database::num_rows($result_course) > 0) {
	if (isset($_POST['export'])) {
		$export_result = export_csv($header, $data, 'test.csv'); // TODO: There is no data for exporting yet.
		Display :: display_error_message($export_result);
	}
	echo '<table class="data_table"><tr><th>'.get_lang('Course').'</th><th>'.get_lang('TempsFrequentation').'</th><th>'.get_lang('Progression').'</th><th>'.get_lang('MoyenneTest').'</th></tr>';
	$header = array(get_lang('Course', ''), get_lang('TempsFrequentation', ''), get_lang('Progression', ''), get_lang('MoyenneTest', ''));
	while ($a_course = Database::fetch_array($result_course)) {
		// TODO: This query is to be checked, there are no HotPotatoes tests results.
		$sql_moy_test = "SELECT exe_result,exe_weighting
			FROM $tbl_track_exercice
			WHERE exe_cours_id = '".$a_course['code']."'";
		$result_moy_test = Database::query($sql_moy_test);
		$result = 0;
		$weighting = 0;
		while ($moy_test = Database::fetch_array($result_moy_test)) {
			$result = $result + $moy_test['exe_result'];
			$weighting = $weighting + $moy_test['exe_weighting'];

<?php

$mysqli = new mysqli("localhost", "skostyukovich", "mansion471", "u95648_instat");
if (mysqli_connect_errno()) {
    echo "Подключение невозможно: " . mysqli_connect_error();
}
$mysqli->set_charset('utf8');
function export_csv($table, $afields, $filename, $delim = ',', $enclosed = '"', $escaped = '\\', $lineend = '\\r\\n')
{
    $q_export = "SELECT " . implode(',', $afields) . "   INTO OUTFILE '" . $_SERVER['DOCUMENT_ROOT'] . $filename . "' " . "FIELDS TERMINATED BY '" . $delim . "' ENCLOSED BY '" . $enclosed . "' " . "    ESCAPED BY '" . $escaped . "' " . "LINES TERMINATED BY '" . $lineend . "' " . "FROM " . $table;
    // Если файл существует, при экспорте будет выдана ошибка
    if (file_exists($_SERVER['DOCUMENT_ROOT'] . $filename)) {
        unlink($_SERVER['DOCUMENT_ROOT'] . $filename);
    }
    return mysql_query($q_export);
}
$table = "request";
$afields = array('authorization', 'source', 'goal');
$filename = "file3.csv";
var_dump(export_csv($table, $afields, $filename, $delim = ',', $enclosed = '"', $escaped = '\\', $lineend = '\\r\\n'));

        exit("Ошибка " . mysql_error());
    }
    if (mysql_num_rows($kar)) {
        $fd = fopen('../files/' . $file_name, "w");
        $header = array('id', 'iditem', 'name', 'space1', 'space2', 'price', 'manufected', 'category', 'keywords', 'image', 'vip', 'levl', 'public', 'chpu', 'h1', 'title', 'description', 'rating', 'share', 'view');
        fputcsv($fd, $header, $delimiter = ';');
        while ($kart = mysql_fetch_array($kar)) {
            $query = "SELECT name FROM manufekted WHERE id='" . $kart['manufekted'] . "'";
            $result = mysql_query($query);
            $res = mysql_fetch_row($result);
            $query = "SELECT name FROM catecory WHERE id='" . $kart['category'] . "'";
            $result = mysql_query($query);
            $res1 = mysql_fetch_row($result);
            // перекодировка и запись в файл для того что бы читалось в exel
            $order = mb_convert_encoding(str_replace('"', ' ', $kart['id']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding($kart['iditem'], "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['name']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding('', "Windows-1251", "UTF-8") . ";" . mb_convert_encoding('', "Windows-1251", "UTF-8") . ";" . mb_convert_encoding($kart['price'], "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $res[0]), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $res1[0]), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['keywords']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['image']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['vip']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['levl']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['publick']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['chpu']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['h1']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['title']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['description']), "Windows-1251", "UTF-8") . ";" . mb_convert_encoding(str_replace($search, ' ', $kart['rating']), "Windows-1251", "UTF-8") . ";" . str_replace($search, ' ', $kart['share']) . ";" . str_replace($search, ' ', $kart['view']) . "\r\n";
            fwrite($fd, $order);
        }
        fclose($fd);
    }
    return 1;
}
$db = mysql_connect("localhost", "garantma_user", "crKAyqBMMaEq");
mysql_select_db("garantma_db", $db);
//$db=mysql_connect("localhost", "root", "");
//mysql_select_db("garantmarket", $db);
$afields[] = 'name';
$afields[] = 'id';
$f_name = 'garant-' . date('dmY_G.i') . '.csv';
if (export_csv($f_name)) {
    echo $f_name;
}

                    echo '<tr><th>' . get_lang('LastName') . '</th><th>' . get_lang('FirstName') . '</th><th>' . get_lang('Email') . '</th></tr>';
                }
            }
        } else {
            $css_class = "row_even";
        }
        $i++;
        if (api_is_western_name_order()) {
            echo "<tr class=" . $css_class . "><td>{$firstname}</td><td>{$lastname}</td><td><a href='mailto:" . $email . "'>{$email}</a></td></tr>";
        } else {
            echo "<tr class=" . $css_class . "><td>{$lastname}</td><td>{$firstname}</td><td><a href='mailto:" . $email . "'>{$email}</a></td></tr>";
        }
        if (api_is_western_name_order(PERSON_NAME_DATA_EXPORT)) {
            $data[$user_id]["firstname"] = $firstname;
            $data[$user_id]["lastname"] = $lastname;
        } else {
            $data[$user_id]["lastname"] = $lastname;
            $data[$user_id]["firstname"] = $firstname;
        }
        $data[$user_id]["email"] = $email;
    }
} else {
    // No results
    echo '<tr><td colspan="3">' . get_lang('NoResults') . '</td></tr>';
}
echo '</table>';
if (isset($_POST['export'])) {
    export_csv($header, $data, 'administrators.csv');
}
echo "\n    <br /><br />\n    <form method='post' action='admin.php'>\n        <button type='submit' class='save' name='export' value='" . get_lang('ExportExcel') . "'>\n            " . get_lang('ExportExcel') . "\n        </button>\n    <form>\n";
Display::display_footer();

                break;
            }
            $tempRe .= $uItem['DEST_IP'] . "(" . $uItem['TOTALBYTES'] . "MB)  ";
            $i++;
        }
    }
    $item['REMARKS'] = $tempRe;
    foreach ($userLoginTimes as $tItem) {
        if ($uname == $tItem['VPN_USER']) {
            $item['TOTALTIME'] = $tItem['TIMES'];
            break;
        }
    }
}
$list = array_reverse($list);
export_csv($list);
function export_csv($list)
{
    $filename = date('YmdHis') . ".csv";
    //文件名
    header("Content-type:text/csv");
    header("Content-Disposition:attachment;filename=" . $filename);
    header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
    header('Expires:0');
    header('Pragma:public');
    echo array_to_string($list);
}
function array_to_string($result)
{
    $data = i('用户名,时长（分钟）,流入（MB）,流出（MB）,总流量（MB）,主要流量分布' . "\n");
    //栏目名称

 function lzwg_output()
 {
     $awardtype = I('award_type');
     $uid = $map['uid'] = $this->mid;
     if ($awardtype == 2 || $awardtype == 1) {
         if ($awardtype == 2) {
             $awardtype = 0;
         }
         $award_ids = D('sport_award')->where(array('award_type' => $awardtype, 'uid' => $uid))->getFields('id');
         $award_ids = implode(',', $award_ids);
         if (!empty($award_ids)) {
             $map['award_id'] = array('exp', ' in (' . $award_ids . ') ');
         } else {
             $map['award_id'] = 0;
         }
     }
     $search = I('search');
     if ($search) {
         $this->assign('search', $search);
         $map1['name'] = array('like', '%' . htmlspecialchars($search) . '%');
         $map1['uid'] = $uid;
         $award_ids = D('sport_award')->where($map1)->getFields('id');
         $award_ids = implode(',', $award_ids);
         $map2['truename'] = array('like', '%' . htmlspecialchars($search) . '%');
         $map3['mobile'] = array('like', '%' . htmlspecialchars($search) . '%');
         $mobile_follow_ids = $truename_follow_ids = D('user')->where($map2)->getFields('uid');
         $truename_follow_ids = implode(',', $truename_follow_ids);
         $mobile_follow_ids = implode(',', $mobile_follow_ids);
         if (!empty($award_ids)) {
             $map['award_id'] = array('exp', ' in (' . $award_ids . ') ');
         } else {
             if (!empty($truename_follow_ids)) {
                 $map['follow_id'] = array('exp', ' in (' . $truename_follow_ids . ') ');
             } else {
                 if (!empty($mobile_follow_ids)) {
                     $map['follow_id'] = array('exp', ' in (' . $mobile_follow_ids . ') ');
                 } else {
                     $map['id'] = 0;
                 }
             }
         }
     }
     $awardid = I('award');
     if ($awardid) {
         $map['award_id'] = $awardid;
     }
     if (I('lzwg_id')) {
         $map['draw_id'] = I('lzwg_id');
     }
     empty($map) || session('common_condition', $map);
     $list_data['list_data'] = M('lucky_follow')->field('id')->where($map)->select();
     // 		$type = I ( 'type' );
     // 		$flag = I ( 'flag' );
     $dao = D('LuckyFollow');
     foreach ($list_data['list_data'] as $vo) {
         $dd = $dao->getLzwgLuckyFollowInfo($vo['id']);
         $datas['nickname2'] = $dd['nickname2'];
         $datas['mobile'] = $dd['mobile'];
         $datas['truename'] = $dd['truename'];
         $datas['award_id'] = $dd['award_id'];
         $datas['sport_id'] = $dd['sport_id'];
         $datas['zjtime'] = time_format($dd['zjtime']);
         $datas['djtime'] = time_format($dd['djtime']);
         // 			$datas ['drum_count'] = $dd ['drum_count'];
         $allDatas[] = $datas;
     }
     $fieldArr = array('nickname2' => '昵称', 'mobile' => '手机号', 'truename' => '姓名', 'award_id' => '中奖奖品', 'sport_id' => '中奖活动', 'zjtime' => '中奖时间', 'djtime' => '兑奖时间');
     foreach ($fieldArr as $k => $vv) {
         $fields[] = $k;
         $titleArr[] = $vv;
     }
     $dataArr[] = $titleArr;
     foreach ($allDatas as $v) {
         $dataArr[] = $v;
     }
     vendor('out-csv');
     export_csv($dataArr, 'LuckyFollow_lzwg_output');
 }

            $pname .= $pinfo->fields['products_name'] . '×' . $pinfo->fields['products_quantity'] . '；';
            $pnum += $pinfo->fields['products_quantity'];
            $pinfo->MoveNext();
        }
    }
    $rs[$i]['pname'] = trim(str_replace('"', '', $pname), '；');
    $rs[$i]['pnum'] = $pnum;
    $new_cid = max($new_cid, $result->fields['customers_id']);
    $new_oid = max($new_oid, $result->fields['orders_id']);
    $result->MoveNext();
    $i++;
}
//print_r($rs);
$csv_str = array_to_string($rs);
if (!empty($_REQUEST['export'])) {
    export_csv($csv_str);
    //导出后记录当前cid和oid
    $new_cid = !empty($new_cid) ? intval($new_cid) : 0;
    $new_oid = !empty($new_oid) ? intval($new_oid) : 0;
    cache_write($cache_file, array('cid' => $new_cid, 'oid' => $new_oid, 'ptime' => time()));
    exit;
} elseif (!empty($_REQUEST['json'])) {
    //json格式输出用于通过接口获取
    echo json_encode($rs);
    exit;
} elseif (!empty($_REQUEST['uplogo'])) {
    //更新日志
    $new_cid = !empty($new_cid) ? intval($new_cid) : 0;
    $new_oid = !empty($new_oid) ? intval($new_oid) : 0;
    cache_write($cache_file, array('cid' => $new_cid, 'oid' => $new_oid, 'ptime' => time()));
} else {

			        <td>' . $lastname . '</td><td>' . $firstname . '</td>
			        <td>' . $s_connection_time . '</td>
			        <td>
			            <a href="course.php?type=coach&user_id=' . $id_coach . '">
			            <img src="' . api_get_path(WEB_IMG_PATH) . '2rightarrow.gif" border="0" /></a></td>
                    <td>
                        <a href="student.php?type=coach&user_id=' . $id_coach . '">
                        <img src="' . api_get_path(WEB_IMG_PATH) . '2rightarrow.gif" border="0" /></a>
                    </td>
                    </tr>';
        }
        if (api_is_western_name_order(PERSON_NAME_DATA_EXPORT)) {
            $data[$id_coach]["firstname"] = $firstname;
            $data[$id_coach]["lastname"] = $lastname;
        } else {
            $data[$id_coach]["lastname"] = $lastname;
            $data[$id_coach]["firstname"] = $firstname;
        }
        $data[$id_coach]["connection_time"] = $s_connection_time;
    }
} else {
    // No results
    echo '<tr><td colspan="5">' . get_lang("NoResult") . '</td></tr>';
}
echo '</table>';
if (isset($_POST['export'])) {
    export_csv($header, $data, 'coaches.csv');
}
echo "<br /><br />";
echo "<form method='post' action='coaches.php'>\n        <button type='submit' class='save' name='export' value='" . get_lang('exportExcel') . "'>" . get_lang('exportExcel') . "</button><form>";
Display::display_footer();