<?
include ('pub/main.php');
require_once('pub/db.class.php');
include ("pub/pub_func.php");
$smarty = new Template();
//DB--------------------------------------------------------------------
$dao = new db_class;
if (!$dao->connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, true)) 
$dao->print_last_error(false);
//DB--------------------------------------------------------------------
include ("pub/top_menu.php");

//list-------------------------------------------------------------------
//1.熱門影片(Popular)
$Popular_Sql="select ZM_Id,ZM_Subject,ZM_PicUrl,ZM_PicExt,ZM_MUrl,ZL_AllId from Zyshow_Movies";
$Popular_Sql.=" where ZM_DelFlag='N' and ZM_Flag='Y'  order by ZM_Id desc limit 0,20";
$dao->select($Popular_Sql);
		if ( $dao->row_count !='0' ) {
			while ( $row = $dao->getRecord() ) {
			 $Popular_Pic=$row['ZM_PicUrl'].$row['ZM_PicExt'];
			 $Popular_data[]=array("ZM_Id"=>$row['ZM_Id'],
						 	 "ZM_Subject"=>$row['ZM_Subject'],
						 	 "ZM_PicUrl"=>$row['ZM_PicUrl'],
						 	 "ZM_PicExt"=>$row['ZM_PicExt'],
							 "ZM_Pic"=>$Popular_Pic,
						 	 "ZM_MUrl"=>$row['ZM_MUrl'],
				  	  	 	 "ZL_AllId"=>$row['ZL_AllId']);
			}
		}
//2.焦點影片(Focus)
$Focus_Sql="select ZM_Id,ZM_Subject,ZM_PicUrl,ZM_PicExt,ZM_MUrl,ZL_AllId from Zyshow_Movies";
$Focus_Sql.=" where ZM_DelFlag='N' and ZM_Flag='Y'  order by ZM_Point desc,ZM_Id desc limit 0,20";
$dao->select($Focus_Sql);
		if ( $dao->row_count !='0' ) {
			while ( $row = $dao->getRecord() ) {
			 $Focus_Pic=$row['ZM_PicUrl'].$row['ZM_PicExt'];
			 $Focus_data[]=array("ZM_Id"=>$row['ZM_Id'],
							 	 "ZM_Subject"=>$row['ZM_Subject'],
							 	 "ZM_PicUrl"=>$row['ZM_PicUrl'],
							 	 "ZM_PicExt"=>$row['ZM_PicExt'],
								 "ZM_Pic"=>$Focus_Pic,
							 	 "ZM_MUrl"=>$row['ZM_MUrl'],
					  	  	 	 "ZL_AllId"=>$row['ZL_AllId']);
			}
		}
//3.講師(Teacher)
$Teacher_Sql="select ZT_Id,ZT_Name,ZT_Class,ZT_PicMUrl,ZT_PicMExt from Zyshow_Teacher";
$Teacher_Sql.=" where ZT_DelFlag='N' and ZT_Flag='Y' order by ZT_Sort  limit 0,20";
$dao->select($Teacher_Sql);
		if ( $dao->row_count !='0' ) {
			while ( $row = $dao->getRecord() ) {
		   	$Teacher_Pic=$row['ZT_PicMUrl'].$row['ZT_PicMExt']; //中-175 x 110
		   	$Teacher_data[]=array("ZT_Id"=>$row['ZT_Id'],
							 	 "ZT_Name"=>$row['ZT_Name'],
							 	 "ZT_Class"=>$row['ZT_Class'],
							 	 "ZT_PicMUrl"=>$row['ZT_PicMUrl'],
							 	 "ZT_PicMExt"=>$row['ZT_PicMExt'],
								 "ZT_PicM"=>$Teacher_Pic);
			}
		}
//4.廣告區
$Ads_Sql="select ZA_Id,ZA_Name,ZA_PicSUrl,ZA_PicSExt,ZA_Url from Zyshow_Ads where ZA_DelFlag='N' and ZA_Flag='Y' order by ZA_Id desc limit 0,1";
$dao->select($Ads_Sql);
		if ( $dao->row_count !='0' ) {
			while ( $row = $dao->getRecord() ) {
			$Ads_Pic=$row['ZA_PicSUrl'].$row['ZA_PicSExt']; //小-220 x 180
			$Ads_data[]=array("ZA_Id"=>$row['ZA_Id'],
							 	 "ZA_Name"=>$row['ZA_Name'],
								 "ZA_Url"=>$row['ZA_Url'],
							 	 "ZA_Pic"=>$Ads_Pic,
							 	 "ZA_PicSUrl"=>$row['ZA_PicSUrl'],
							 	 "ZA_PicSExt"=>$row['ZA_PicSExt']);
			}
		}
//list-------------------------------------------------------------------
$dao->end_db;
//DB--------------------------------------------------------------------
$smarty->assign('Label_Count', @$Labeldata); //3.熱門標籤
$smarty->assign('Popular_Count', @$Popular_data); 	//1.熱門影片(Popular)
$smarty->assign('Focus_Count', @$Focus_data); 		//2.焦點影片(Focus)
$smarty->assign('Teacher_Count', @$Teacher_data); 	//3.講師(Teacher)
$smarty->assign('Ads_Count', @$Ads_data);			//4.廣告(Ads)


$smarty->display('index.html');
?>