<?
$filename = 'newsletter.csv'; 

	Define( "_vStrRootPath" , "" );

	Include( _vStrRootPath . "_libraries/_config_front-end.php" );
	Include( _vStrRootPath . _vStrDirGlobal . "/_config_front-end_session.php" );
	Include( _vStrRootPath . _vStrDirGlobal . "/_config_front-end_session.shop.php" );

	/***** Check Session ต้องตรวจสอบก่อน เพราะต้องมีการส่งค่าให้ Include ถัดไป *****/
	Include( _vStrRootPath . _vStrDirGlobal . "/global_shop_profile.php" );
	Customer_Shop_Login( $vStrSessionID , $vStrSessionUsername , $vStrSessionShopID , $vStrSessionShopDir , $vStrSessionShopType , $vStrSessionShopLanguage , _vStrRootPath . "member/my" );
	/***** End *****/

	Include( _vStrRootPath . _vStrDirGlobal . "/constant_front-end_member.shop_" . $vStrShopTypeInclude . ".php" );


	$SQL = "Select * ".
							"From " . _MySQLDbPrefix . "shop_email_list ".
							"Where spf_id_pk = " . $vStrSessionShopID;
//echo  $vStrSessionShopID;

	$Conn = MySQL_Connect( _MySQLServer , _MySQLUser , _MySQLPass ) Or Die ( _MySQLDieConn );
	MySQL_Select_Db( _MySQLDb , $Conn ) Or Die ( _MySQLDieDb );

		$RS = MySQL_Query( $SQL , $Conn ) Or Die ( _MySQLDieSQL . MySQL_Error() );
		$vIntTotal = MySQL_Num_Rows( $RS );

		MySQL_Free_Result( $RS );

	MySQL_Close( $Conn );


	If ( $vIntTotal == 0 ) {
		
		$vStrCode = "";

	} Else {

							
								$header  = 'E-Mail, Date'."\n"; 
							

		$SQL = "Select sel_email , ".
									" sel_date_time ".
							"From " . _MySQLDbPrefix . "shop_email_list ".
							"Where spf_id_pk = " . $vStrSessionShopID . " ".
							"Order By sel_email ";
//echo $SQL ;
		$Conn = MySQL_Connect( _MySQLServer , _MySQLUser , _MySQLPass ) Or Die ( _MySQLDieConn );
		MySQL_Select_Db( _MySQLDb , $Conn ) Or Die ( _MySQLDieDb );

			$RS = MySQL_Query( $SQL , $Conn ) Or Die ( _MySQLDieSQL . MySQL_Error() );

				$vStrCodeFor = "";

				While ( $DbArr = MySql_Fetch_Array( $RS ) ) {
							/*
						  $line = '';
						      foreach( $DbArr as $value )
								{                                            
									if ( ( !isset( $value ) ) || ( $value == "" ) ) 
									{
										$value = ",";
									} 
									else 
									{
										$value = str_replace( '"' , '""' , $value );
										$value = '"' . $value . '"' . ",";
									}
									$line .= $value;
								}*/
								$data .= $DbArr[sel_email].','.$DbArr[sel_date_time]. "\n";
				}

//$data = str_replace( "\r" , "" , $data );
			
if ( $data == "" ) 
{
    $data = "\n(0) Records Found!\n";                        
}


$data = $header.$data;
header("Content-type: application/x-msexcel"); 
header("Content-disposition: attachment; filename=".$filename); 
header("Pragma: no-cache"); 
header("Expires: 0"); 

print $data;
	
				
				MySQL_Free_Result( $RS );

			MySQL_Close( $Conn );	

	}

exit; 

?>