<?php
include "../include.inc.php";
include INCLUDE_PATH."/include.eat.inc";

$dbh = new CMyDBH(true);

$sql="select A.eat_id,A.eat_namejp,A.eat_namecn,A.eat_nameen,A.logoimg1,A.logoimg2,A.coment1,A.address,
	  A.addresscross,A.tel,A.url,A.creditcard,A.language,A.businesstime_start,A.businesstime_end,A.offday,A.subway,
	  B.condition_name as area_name,C.condition_name as type_name,D.condition_name as price_name from eat_info A 
	  left join searchcondition B on A.area=B.condition_id and B.flag='6' 
	  left join searchcondition C on A.eattype=C.condition_id and C.flag='7' 
	  left join searchcondition D on A.price=D.condition_id and D.flag='8' where A.eat_id='".$eat_id."'";
$result=$dbh->select_all($sql);
$result[0][logoimg1]="upload_img/".$result[0][logoimg1];
$result[0][logoimg2]="upload_img/".$result[0][logoimg2];
$smarty->assign('result',$result);
$arrcreditcard=array();
$arrlanguage=array();
for($i=0;$i< count($arrCreditcardImg);$i++)
{
	if(substr($result[0][creditcard],$i,1)=="1")
	{
		$arrcreditcard[$i]["value"]=IMAGEPATH.$arrCreditcardImg[$i];
	}
	else
	{
		$arrcreditcard[$i]["value"]="";
	}
}
$smarty->assign('arrcreditcard',$arrcreditcard);
for($i=0;$i< count($arrLanguageImg);$i++)
{
	//echo substr($result[0][language],$i,1)."******************************".$result[0][language];
	if(substr($result[0][language],$i,1)=="1")
	{
		$arrlanguage[$i]["value"]=IMAGEPATH.$arrLanguageImg[$i];
		//echo $arrlanguage[$i]["value"];
	}
	else
	{
		$arrlanguage[$i]["value"]="";
	}
}
$smarty->assign('arrlanguage',$arrlanguage);

$sql="select * from eat_menu where eat_id='".$eat_id."' order by menu_id";
$result_menu=$dbh->select_all($sql);
$smarty->assign('result_menu',$result_menu);
$smarty->assign('count_menu',count($result_menu));

$sql="select * from report1 where report_id='".$eat_id."' and flag='2' ";
$result1=$dbh->select_all($sql);
$smarty->assign('count1',count($result1));
$smarty->assign('report1_title1',$result1[0][title1]);
$smarty->assign('report1_coment1',$result1[0][coment1]);
$smarty->assign('report1_title2',$result1[0][title2]);
$smarty->assign('report1_coment2',$result1[0][coment2]);
$smarty->assign('report1_title3',$result1[0][title3]);
$smarty->assign('report1_coment3',$result1[0][coment3]);
$smarty->assign('report1_image1',"upload_img/".$result1[0][image1]);
$smarty->assign('report1_image2',"upload_img/".$result1[0][image2]);
$smarty->assign('report1_image3',"upload_img/".$result1[0][image3]);

$sql="select * from report2 where report_id='".$eat_id."' and flag='2' ";
$result2=$dbh->select_all($sql);
$smarty->assign('count2',count($result2));
$smarty->assign('report2_title1',$result2[0][title1]);
$smarty->assign('report2_coment1',$result2[0][coment1]);
$smarty->assign('report2_title2',$result2[0][title2]);
$smarty->assign('report2_coment2',$result2[0][coment2]);
$smarty->assign('report2_title3',$result2[0][title3]);
$smarty->assign('report2_coment3',$result2[0][coment3]);
$smarty->assign('report2_title4',$result2[0][title4]);
$smarty->assign('report2_coment4',$result2[0][coment4]);
$smarty->assign('report2_image1',"upload_img/".$result2[0][image1]);
$smarty->assign('report2_image2',"upload_img/".$result2[0][image2]);
$smarty->assign('report2_image3',"upload_img/".$result2[0][image3]);
$smarty->assign('report2_image4',"upload_img/".$result2[0][image4]);
$smarty->assign('report2_image5',"upload_img/".$result2[0][image5]);
$smarty->assign('report2_image6',"upload_img/".$result2[0][image6]);
$smarty->assign('report2_image7',"upload_img/".$result2[0][image7]);
$smarty->assign('report2_image8',"upload_img/".$result2[0][image8]);
$smarty->assign('report2_image9',"upload_img/".$result2[0][image9]);
$smarty->assign('report2_image10',"upload_img/".$result2[0][image10]);
$smarty->assign('report2_image11',"upload_img/".$result2[0][image11]);
$smarty->assign('report2_image12',"upload_img/".$result2[0][image12]);
$smarty->assign('report2_image13',"upload_img/".$result2[0][image13]);

$sql="select * from report3 where report_id='".$eat_id."' and flag='2' ";
$result3=$dbh->select_all($sql);
$smarty->assign('count3',count($result3));
$smarty->assign('report3_coment',$result3[0][coment]);
$smarty->assign('report3_image1',"upload_img/".$result3[0][image1]);
$smarty->assign('report3_image2',"upload_img/".$result3[0][image2]);
$smarty->assign('report3_image3',"upload_img/".$result3[0][image3]);

$sql="select * from report4 where report_id='".$eat_id."' and flag='2' ";
$result_report4=$dbh->select_all($sql);
for($i=0;$i<count($result_report4);$i++)
{
	$result_report4[$i][image]="upload_img/".$result_report4[$i][image];
}
$smarty->assign('count4',count($result_report4));
$smarty->assign('result_report4',$result_report4);
$searchmainflg="2";
$smarty->assign('searchmainflg',$searchmainflg);
$smarty->assign('serverpath',SERVERPATH);
$smarty->assign('eatserverpath',EATSERVERPATH);
$smarty->assign('imagepath',IMAGEPATH);
setIncludeJsFile("getIncludeJsFile",&$smarty);
$smarty->display('eat_detail.tmpl');
$dbh->disconnect();

?>