* @Time:2012-5-4
* @Version:V9.0
*/
session_start();
// 输出Excel文件头，可把user.csv换成你要的文件名
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="contact.csv"');
header('Cache-Control: max-age=0');
require '../config/config.php';
//调用数据库配置文件
require '../include/class/mysql_class.php';
/* 载入MYSQL,初始化 */
$mysql = new MYSQL($db_host, $db_user, $db_pass, $db_name);
/**获取为分组ID*/
$sqls = "select * from zy_contact_list where company_id=" . $_SESSION['user']['customer']->company_id . " ORDER BY contact_list_id ASC";
$contact_list_id = $mysql->select($sqls);
/**获取值*/
$group = $_POST['contact_list_id'];
/**连接数据库 用户名 密码*/
$lnk = mysql_connect($db_host, $db_user, $db_pass) or die('Not connected : ' . mysql_error());
/**连接所需要的数据库*/
mysql_select_db($db_name, $lnk) or die('Can\'t use zy-sms : ' . mysql_error());
if (!empty($group)) {
for ($i = 0; $i < count($group); $i++) {
$link = $group[$i];
$links .= "or contact_list like '%[{$link}]%' ";
}
} else {
$link = $contact_list_id[0]->contact_list_id;
}
$sql = 'select contact_id,contact_first_name, contact_surname, contact_email, contact_mobile,contact_phone,contact_title,' . 'contact_birth_date,contact_address,contact_remark from zy_contact where contact_list like ' . "'%[{$link}]%'" . ' ' . $links . ' and company_id=' . $_SESSION['user']['customer']->company_id;
