<?php
require_once("config/global_variable.php");
header('Content-Type: application/json');

function getNewsTopic(){
	$cacheKey = 'getFinTopic.php';
	$result = array();
	$cacheData = apc_fetch($cacheKey);
	if (!$cacheData) {
		$db = new DB_Sql;
		$newsDb = new DB_Sql;
		
		$sql = "SELECT * from CMS_topic WHERE active = 1 ORDER BY rank";
		
		$db->query($sql);
		
		if($db->num_rows()){
			while($db->next_record()) {
				$row = array(
					'topic_id' 			=> $db->Record['topic_id'],
					'topic_name'		=> $db->Record['topic_name'],
					'image1'			=> $db->Record['image1'],
					'image2'			=> $db->Record['image2'],
					'image3'			=> $db->Record['image3'],
					'image4'			=> $db->Record['image4'],
					'image5'			=> $db->Record['image5'],
					'image6'			=> $db->Record['image6'],
					'image7'			=> $db->Record['image7'],
					'image8'			=> $db->Record['image8'],
					'image9'			=> $db->Record['image9'],
					'publish_time'		=> $db->Record['publish_time'],
					'unpublish_time'	=> $db->Record['unpublish_time'],
					'last_news_time'	=> null,
					'rank'				=> $db->Record['rank'],
					'last_modify_date'	=> $db->Record['last_modify_date'],
					'tags'				=> null,
					'recent_conut'		=> 0,
					'active'			=> $db->Record['active'],
					'last_news'			=> null
				);
				
				$tags = $db->Record['tags'];
				$sqlTag = array();
				if($tags != ''){
					$row['tags'] = explode(',', $tags);
					if($row['tags'] && count($row['tags'])){
						foreach ($row['tags'] as $tags) {
							$sqlTag[] = '\'' . mysql_escape_string($tags) . '\'';
						}
						
						$newsSql = sprintf('SELECT * FROM `CMS_newslist` WHERE `program_name` in (%s) AND active = 1 ORDER BY `publish_date` DESC Limit 1', implode(', ', $sqlTag) );
						
						$newsDb->query($newsSql);
						if($newsDb->num_rows()){
							$newsDb->next_record();
							$row['last_news_time'] = $newsDb->Record['publish_date'];
							
							$row['last_news'] = array(
								'news_id' 	=> $newsDb->Record['news_id'],
								'title' 	=> $newsDb->Record['title'],
								'image' 	=> $newsDb->Record['image'],
								'leading' 	=> $newsDb->Record['leading'],
								'publish_date' 	=> $newsDb->Record['publish_date']
							);
							
							//$today = date('Y-m-d 00:00:00', 1355314323);
							$today = date('Y-m-d H:i:s', strtotime('-1 day'));
							$newsSql = sprintf('SELECT count(*) as recent_conut FROM `CMS_newslist` WHERE `program_name` in (%s) AND active = 1 AND publish_date between \'%s\' and now()', implode(', ', $sqlTag), $today);
							
							$newsDb->query($newsSql);
							if($newsDb->num_rows()){
								$newsDb->next_record();
								$row['recent_conut'] = (int)$newsDb->Record['recent_conut'];
							}
						}
					}
				}
				
				$result[] = $row;
			}

			apc_store($cacheKey, $result, 15*60);
		}
	} else {
		$result = $cacheData;
	}
	
	return json_encode($result);
}

echo getNewsTopic();