<?
require_once("require_user.php");

class ExPage extends User {


  protected function main($const,$util,&$db,&$smarty,&$form) {

		$list = $this->get_list($db,$form);
		$smarty->assign("list",$list);		

		$list2 = $this->get_list2($db,$form);
		$smarty->assign("list2",$list2);		

	}
	function get_list($db,$form) {
		$sql = "SELECT A.*
				FROM wp_posts A
				WHERE A.post_type ='example1' and A.post_status ='publish' 
				order by A.post_date DESC 
				limit 3
				";
		$list = $db->get_all($sql);

		$column7="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column7' 
					";
			$column7 = $db->get_one($sql);
			$list[$i]["column7"]=$column7;
		}


		$column8="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column8' 
					";
			$column8 = $db->get_one($sql);
			$list[$i]["column8"]=$column8;
		}

		$column9="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column9' 
					";
			$column9 = $db->get_one($sql);
			$list[$i]["column9"]=$column9;
		}

		$column10="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column10' 
					";
			$column10 = $db->get_one($sql);
			$list[$i]["column10"]=$column10;
		}

		$column11="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column11' 
					";
			$column11 = $db->get_one($sql);
			$list[$i]["column11"]=$column11;
		}

		$column12="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column12' 
					";
			$column12 = $db->get_one($sql);
			$list[$i]["column12"]=$column12;
		}

		for($i=0;$i<count($list);$i++) {
			
			$list[$i]["total"]=$list[$i]["column9"]+$list[$i]["column10"]+$list[$i]["column11"]+$list[$i]["column12"];
			
		}	

		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column_image3' 
					";
			$image1 = $db->get_one($sql);
			$list[$i]["image1"]=$image1;
		}

		return $list;
	}
	function get_list2($db,$form) {
		$sql = "SELECT A.*
				FROM wp_posts A
				WHERE A.post_type ='example2' and A.post_status ='publish' 
				order by A.post_date DESC 
				limit 4
				";
		$list = $db->get_all($sql);

		$image1="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'image2_1' 
					";
			$image1 = $db->get_one($sql);
			$list[$i]["image1"]=$image1;
		}
		$column2_3="";
		for($i=0;$i<count($list);$i++) {
			$sql = "SELECT meta_value
					FROM wp_postmeta
					WHERE post_id  =" . $list[$i]["ID"] .
					"  and meta_key = 'column2_3' 
					";
			$column2_3 = $db->get_one($sql);
			$len=mb_strlen($column2_3);
			if($len>=25) {
				$column2_3=mb_substr($column2_3,0,24);
				$column2_3.="…";
			}
			
			$list[$i]["column2_3"]=$column2_3;
		}

		return $list;
	}

}

new ExPage();

?>