<?php
require_once('wp-load.php');

$csv_file='/home/carcaren/public_html/carcreditnation-2.csv';//'test.csv';//

$ftp_ip='jtzimages.com';//'209.159.154.250';//
$ftp_username='carcredit@jtzimages.com';//'penta1cl';//
$ftp_userpass='Cars2Web';//'eee0cf69';//
$local_file='carcreditnation-2.csv';
$local_file2='/home/carcaren/public_html/carcreditnation-2.csv';
$remote_file='carcreditnation.csv';//'/public_html/sampletest/carcreditnation.csv';


$header = array(array('dealer_ID','vin','year','make','model','trim','body_style','transmission','mileage','exterior_color','interior_color','safety_features','leather_interior','power_windows','power_door_locks','sun_roof','down_payment','weekly_payment','biweekly_payment','monthly_payment','price','disclaimer','description','promo_message','stock_number','other_options','video','image_url1','image_url2','image_url3','image_url4','image_url5','image_url6','image_url7','image_url8','image_url9','image_url10','image_url11','image_url12','image_url13','image_url14','image_url15','image_url16','image_url17','image_url18','image_url19','image_url20','image_url21','image_url22','image_url23','image_url24','image_url25','image_url26','image_url27','image_url28','image_url29','image_url30','image_url31','image_url32','image_url33','image_url34','image_url35','image_url36','image_url37','image_url38','image_url39','image_url40','image_url41','image_url42','image_url43','image_url44','image_url45','image_url46','image_url47','image_url48','image_url49','image_url50'));

$fp = fopen($csv_file, 'w');
foreach ($header as $fields) {
    fputcsv($fp, $fields);
}
$datalist = data_to_csv($fp);
write_csv($datalist,$fp);
//chmod($csv_file, 0777); 
fclose($fp);


if (file_exists($local_file2)) {

	ftp_upload_to_remote_server($ftp_ip,$ftp_username,$ftp_userpass,$local_file,$remote_file);
}

function data_to_csv($file){
	$args = array('post_type'=>'gtcd' ,'posts_per_page'=>-1 ,'post_status'=>'publish','meta_query' => array(
				array(
					'key'     => '_statustag',
					'value'   => 'Sold',
					'compare' => '!=',
					),
					),
				);

	$myposts = get_posts( $args );
	foreach ( $myposts as $mypost ) {	
				
						$args = array(
						'numberposts' => 50,
						'order' => 'ASC',
						'post_mime_type' => 'image',
						'post_parent' => $mypost->ID,
						'post_status' => null,
						'post_type' => 'attachment',
					);

				$attachments = get_children( $args );
				$images =array();
				if ( $attachments ) {
					foreach ( $attachments as $attachment ) {
						$image_attributes = wp_get_attachment_image_src( $attachment->ID, 'full' );
						$images[]=$image_attributes[0];
					}
				}

				$vehicle=array();
				$mod1 =	get_post_meta($mypost->ID,'mod1',true);
				$mod2 = get_post_meta($mypost->ID, 'mod2', true); 
				$mod3 = get_post_meta($mypost->ID, 'mod3', true); 	
				$mod4 = get_post_meta($mypost->ID, 'mod4', true); 	
				$mod5 = get_post_meta($mypost->ID, 'mod5', true); 	
				
				if(is_serialized($mod1))
					$mod1=unserialize($mod1);
				if(is_serialized($mod2))
					$mod2=unserialize($mod2);
				if(is_serialized($mod3))
					$mod3=unserialize($mod3);	
				if(is_serialized($mod4))
					$mod4=unserialize($mod4);	
				if(is_serialized($mod5))
					$mod5=unserialize($mod5);		
				//$makemodel=get_the_terms($mypost->ID, 'makemodel' );
				

				//echo "<pre>";print_r($mod2);echo "</pre>";
				
				//var_dump($mod2);exit;
				if(isset($mod1['VIN']))
					$vin1= $mod1['VIN'];
				else
					$vin1= $mod1['vin'];
					
				$down_payment	=	(get_post_meta($mypost->ID, 'wp_text_1', true))?get_post_meta($mypost->ID, 'wp_text_1', true):'0';		
				$weekly_payment	=	(get_post_meta($mypost->ID, 'wp_text_2', true))? get_post_meta($mypost->ID, 'wp_text_2', true):'0';	
				$price			=	(get_post_meta($mypost->ID, 'wp_text_4', true))?get_post_meta($mypost->ID, 'wp_text_4', true):'0';	

				$vehicle[0]	=	($mod4['ID'])?$mod4['ID']:'';//dealer
				$vehicle[1]	=	$vin1;
				$vehicle[2]	= 	($mod1['year'])?$mod1['year']:'';
				$vehicle[3]	= 	($mod5['make'])?$mod5['make']:'';
				$vehicle[4]	= 	($mod5['model'])?$mod5['model']:'';
				$vehicle[5]	=	($mod5['TrimLevel'])?$mod5['TrimLevel']:'';
				$vehicle[6]	=	'';//$mod3['VEHICLE_STYLE'];//body style
				$vehicle[7]	=	$mod1['transmission'];	
				$vehicle[8]	=	($mod1['miles'])?$mod1['miles']:'';		
				$vehicle[9]	=	($mod1['exterior'])?$mod1['exterior']:'';	
				$vehicle[10]=	($mod1['interior'])?$mod1['interior']:'';	
				$vehicle[11]=	'';	//safety_fetaures	
				$vehicle[12]=	'';	//leather_interior	
				$vehicle[13]=	'';	//power_windows	
				$vehicle[14]=	($mod3['POWER_DOOR_LOCKS'])? "Y" : "" ;
				$vehicle[15]=	'';	//sun roof	
				$vehicle[16]=	($down_payment>0)?$down_payment:''; //down_payment
				$vehicle[17]=	($weekly_payment>0)?$weekly_payment:''; 		//weekly_payment
				$vehicle[18]=	 '';//'NULL';		//biweekly_payment	
				$vehicle[19]=	 '';//'NULL';		//monthly_payment	
				$vehicle[20]=	 ($price>0)?$price:'';//price		
				$vehicle[21]=	''; //disclaimer		
				$vehicle[22]=	($mod1['comment_area'])?$mod1['comment_area']:''; //description	
				$vehicle[23]=	''; //promo_message	
				$vehicle[24]=	($mod1['stock'])?$mod1['stock']:''; //stock		
				$vehicle[25]=	($mod5['Options'])?$mod5['Options']:''; //other_options	
				$vehicle[26]=	get_post_meta($mypost->ID, 'video_meta_box_videoid', true); //video url	
				$img_start	=	27;
				foreach($images as $url)		
					{		
						$vehicle[$img_start]=$url;
						$img_start++;
					}
				
				

				$data[]=array($vehicle);
			
		}
		return $data;
	
}
function write_csv($datalist,$file){

	for ($i=0;$i<count($datalist);$i++){	
		foreach ($datalist[$i] as $line)
		{
					fputcsv($file,$line);

		}
	}
}

function ftp_upload_to_remote_server($ftp_ip,$ftp_username,$ftp_userpass,$local_file,$remote_file){
		// connect and login to FTP server
			$ftp_server 	= $ftp_ip;
			//$ftp_conn 		= ftp_connect($ftp_server) or die("Could not connect to $ftp_server");
		
			$ftp_conn 		= ftp_ssl_connect($ftp_server) or die("Could not connect to $ftp_server");
			$login 			= ftp_login($ftp_conn, $ftp_username, $ftp_userpass);

			 $file = '/home/carcaren/public_html/'.$local_file;

			ftp_pasv($ftp_conn, true);
		// upload file
			if (ftp_put($ftp_conn, $remote_file, $file, FTP_ASCII))
			  {
			  echo "Successfully uploaded: $file. at $ftp_conn ";
			  }
			else
			  {
			  echo "Error uploading $file.".$ftp_conn;
			  }

			// close connection
			ftp_close($ftp_conn);
}
?>