Elep

<?php
	require_once "pageBase.php";
	require_once "bin/web/repeater.php";
	require_once "dal/bookDAL.php";
	require_once "dal/book_categoryDAL.php";

class _book extends pageBase{
		private $dalC;
		public function load(){
			$this->dalC = new book_categoryDAL();
			$this->loadData();
			parent::loadTemplateFile("templates/".$this->registry->webTemplates."/book.html");
			parent::load();
		}
		public function loadData(){
			//橫幅廣告
			$this->picturetype = "80";

////logo
			parent::addParameter("fbImage",$this->NoPicImage);

//宣告
			$dal = new bookDAL();
			$dalC2 = new book_categoryDAL();
			$dalC3 = new book_categoryDAL();
			$p = parent::getGet("p", "1");
			$pz = $this->registry->bookPageSize;
			if($pz == "0" || !preg_match("/^\d+$/", $pz)) $pz = "20";
			$p = (int)$p;
			$pz = (int)$pz;
			$rang = 10;

$intoAry = array();
			$filter = "a.`Visible`=1 AND a.`Disable`=0 AND b.`Visible`=1 AND b.`Disable`=0 AND (b.`ParentID`=0 OR c.`Visible`=1 OR c.`Disable`=0) AND (b.`ParentID`=0 OR c.`ParentID`=0 OR d.`Visible`=1 OR d.`Disable`=0)";
			$orderExp = "";
			$aryR = array();
			if($this->registry->webLinkType == "2"){
				$this->dalC->TwPathName = parent::getGet("c", "", 2);
			}else{
				$this->dalC->CategoryID = parent::getGet("id");
			}
			if($this->dalC->TwPathName != "" || $this->dalC->CategoryID != ""){
				$this->dalC->loadRecord();
				if($this->dalC->Visible != "1" || ($this->dalC->ParentID != "0" && $this->dalC->ParentVisible != "1") || ($this->dalC->ParentID != "0" && $this->dalC->GrandID != "0" && $this->dalC->GrandVisible != "1")){
					$this->alertMsg = "找不到指定的頁面!";
					$this->locationHref = "/";
					return false;
				}
				$id = $this->dalC->CategoryID;
				$categoryName = $this->dalC->CategoryName;
				$categoryLink = parent::linkBookList($this->dalC->CategoryID);
				$categoryDescription = $this->dalC->Description;
				$styleCD = ($categoryDescription == "")?" style='display:none;'":"";
				$aryR[] = array("Name"=>$categoryName, "Link"=>$categoryLink);
				if($this->dalC->ParentID != "0"){
					$aryR[] = array("Name"=>$this->dalC->ParentName, "Link"=>parent::linkBookList($this->dalC->ParentID));
					if($this->dalC->GrandID != "0"){
						$aryR[] = array("Name"=>$this->dalC->GrandName, "Link"=>parent::linkBookList($this->dalC->GrandID));
					}
				}
				$aryR = array_reverse($aryR);
				$intoAry[] = parent::addArray(":categoryID", $id, "int");
				$intoAry[] = parent::addArray(":parentID", $id, "int");
				$intoAry[] = parent::addArray(":grandID", $id, "int");
				$filter .= " AND (a.`CategoryID`=:categoryID OR b.`ParentID`=:parentID OR c.`ParentID`=:grandID)";
				if($this->dalC->OGTitle != "") parent::addParameter("ogTitle", $this->dalC->OGTitle);
				if($this->dalC->OGDescription != "") parent::addParameter("ogDescription", $this->dalC->OGDescription);
				if($this->dalC->OGImage != "" && parent::image_exists($this->dalC->OGImage)){
					$ogImage = $this->dalC->OGImage;
					if(preg_match("/^\/\//", $ogImage)) $ogImage = $this->protocol.":".$ogImage;
					if(!preg_match("/^https?:\/\//", $ogImage)) $ogImage = $this->protocol."://".$_SERVER["HTTP_HOST"].$ogImage;
					parent::addParameter("ogImage", $ogImage);
				}
				if($this->dalC->WebTitle != "") parent::addParameter("webTitle", $this->dalC->WebTitle);
				if($this->dalC->WebKeyword != "") parent::addParameter("webKeyword", $this->dalC->WebKeyword);
				if($this->dalC->WebDescription != "") parent::addParameter("webDescription", $this->dalC->WebDescription);
				if($this->dalC->BannerImage != "" && parent::image_exists($this->dalC->BannerImage)){
					$this->bannerImage = $this->dalC->BannerImage;
					$this->bannerTitle = $this->dalC->BannerTitle;
					$this->bannerLink = $this->dalC->BannerLink;
					$this->bannerColor = $this->dalC->BannerColor;
					$this->bannerDesc = $this->dalC->BannerDesc;
				}else{
					if($this->dalC->ParentID != "0"){
						$dalC2->CategoryID = $this->dalC->ParentID;
						$dalC2->loadRecord();
						if($dalC2->BannerImage != "" && parent::image_exists($dalC2->BannerImage)){
							$this->bannerImage = $dalC2->BannerImage;
							$this->bannerTitle = $dalC2->BannerTitle;
							$this->bannerLink = $dalC2->BannerLink;
							$this->bannerColor = $dalC2->BannerColor;
							$this->bannerDesc = $dalC2->BannerDesc;
						}else{
							if($dalC2->ParentID != "0"){
								$dalC3->CategoryID = $dalC2->ParentID;
								$dalC3->loadRecord();
								if($dalC3->BannerImage != "" && parent::image_exists($dalC3->BannerImage)){
									$this->bannerImage = $dalC3->BannerImage;
									$this->bannerTitle = $dalC3->BannerTitle;
									$this->bannerLink = $dalC3->BannerLink;
									$this->bannerColor = $dalC3->BannerColor;
									$this->bannerDesc = $dalC3->BannerDesc;
								}
							}
						}
					}
				}
				parent::addParameter("CategoryName", $this->dalC->CategoryName);
			}else{
				$id = "0";
				$categoryName = "相本";
				parent::addParameter("CategoryName", '相本');
				$categoryLink = parent::linkBookList();
				$categoryDescription = "";
				$styleCD = " style='display:none;'";
				if($this->registry->bookTitle != "") parent::addParameter("webTitle", $this->registry->bookTitle);
				if($this->registry->bookKeyword != "") parent::addParameter("webKeyword", $this->registry->bookKeyword);
				if($this->registry->bookDescription != "") parent::addParameter("webDescription", $this->registry->bookDescription);
			}
			parent::addParameter("CategoryDescription", $categoryDescription);
			parent::addParameter("styleCD", $styleCD);
			$listR = new repeater();
			$listR->id = "listR";
			$listR->dataSource = $aryR;
			parent::addControl($listR);

$rows = $dal->countRecordset($intoAry, $filter);
			$pMax = ceil($rows / $pz);
			if($p > $pMax) $p = $pMax;
			if($p < 1) $p = 1;
			$start = ($p - 1) * $pz;

$data = $dal->execute2Recordset($intoAry, $filter, $orderExp, $start, $pz);
			$data = $this->formatBook($data);
			$list = new repeater();
			$list->id = "list";
			$list->dataSource = $data;
			parent::addControl($list);

//相本分類列表
			$dataC = $this->dalC->executeRecordset(array(), "a.`ParentID`=0 AND a.`Visible`=1 AND a.`Disable`=0");
			$dataC = $this->formatCategory($dataC,$id);
			$listC = new repeater();
			$listC->id = "listC";
			$listC->dataSource = $dataC;
			parent::addControl($listC);

//頁導航
			if($id == "") $id = 0;
			if($rows > 0){
				$pr = ceil($p / $rang) - 1;
				$pu = ($p == 1)?1:($p - 1);
				$pd = ($p == $pMax)?$pMax:($p + 1);

$pagtxt = '<a href="'.parent::linkBookList($id, $pu).'"><i class="fa fa-angle-double-left"></i></a>';
				for($i=1;$i<11;$i++){
					$nm = $pr * $rang + $i;
					$pagtxt .= ($nm == $p)?'<strong class="number_hit">'.$nm.'</strong>':'<a href="'.parent::linkBookList($id, $nm).'">'.$nm.'</a>';
					if($nm == $pMax) break;
				}
				$pagtxt .= '<a href="'.parent::linkBookList($id, $pd).'" class="next"><i class="fa fa-angle-double-right"></i></a>';
			}else{
				$pagtxt = '沒有資料';
			}
			parent::addParameter("pagtxt",$pagtxt);
			
			//結構化資料
			$GoogleSearch = "";
			if($id != "" && $id != "0") $GoogleSearch = parent::seoGoogleSearch("10",$id,"0");
			parent::addParameter("GoogleSearch", $GoogleSearch);

//父類方法蘋果也界有限公司
			parent::loadData();
		}
		private function formatCategory($data=array(),$id){
			$iLabel = "<b data-action='sideOpen'><i class='fa fa-plus' aria-hidden='true'></i></b>";
			$iLabel2 = "<b data-action='sideOpen'><i class='fa fa-minus' aria-hidden='true'></i></b>";
			$this->dalC->CategoryID = $id;
			$this->dalC->loadRecord();
			for($i=0;$i<count($data);$i++){
				$data[$i]["link"] = parent::linkBookList($data[$i]["CategoryID"]);
				$data[$i]["iLabel"] = "";
				$data[$i]["SubList"] = "";
				$data[$i]["className"] = "";
				$intoAry = array();
				$intoAry[] = parent::addArray(":parentID", $data[$i]["CategoryID"], "int");
				$dataS = $this->dalC->executeRecordset($intoAry, "a.`ParentID`=:parentID AND a.`Visible`=1 AND a.`Disable`=0");
				if(count($dataS) > 0){
					if($data[$i]["CategoryID"] == $id){
						$data[$i]["className"] = " class='action'";
						$data[$i]["iLabel"] = $iLabel2;
					}else{
						if($this->dalC->ParentID == $data[$i]["CategoryID"]){
							$data[$i]["className"] = " class='action'";
							$data[$i]["iLabel"] = $iLabel2;
						}else{
							if($this->dalC->GrandID == $data[$i]["CategoryID"]){
								$data[$i]["className"] = " class='action'";
								$data[$i]["iLabel"] = $iLabel2;
							}else{
								$data[$i]["iLabel"] = $iLabel;
							}
						}
					}
					$data[$i]["SubList"] .= "<ul class='subUL'>";
					foreach($dataS as $rows){
						$into2Ary = array();
						$into2Ary[] = parent::addArray(":parentID", $rows["CategoryID"], "int");
						$dataS2 = $this->dalC->executeRecordset($into2Ary, "a.`ParentID`=:parentID AND a.`Visible`=1 AND a.`Disable`=0");
						$data[$i]["SubList"] .= "<li";
						if($rows["CategoryID"] == $id || $rows["CategoryID"] == $this->dalC->ParentID){
							$data[$i]["SubList"] .= " class='action'";
						}
						$data[$i]["SubList"] .= "><div class='subULHead'><p><a href='".parent::linkBookList($rows["CategoryID"])."'>".$rows["CategoryName"]."</a></p>";
						if(count($dataS2) > 0){
							if($rows["CategoryID"] == $id || $rows["CategoryID"] == $this->dalC->ParentID){
								$data[$i]["className"] = " class='action'";
								$data[$i]["SubList"] .= $iLabel2."</div>";
							}else{
								$data[$i]["SubList"] .= $iLabel."</div>";
							}
							$data[$i]["SubList"] .= "<ul class='sub2UL'>";
							foreach($dataS2 as $rows2){
								$data[$i]["SubList"] .= "<li";
								if($rows2["CategoryID"] == $id){
									$data[$i]["SubList"] .= " class='action'";
								}
								$data[$i]["SubList"] .= "><div class='sub2ULHead'><p><a href='".parent::linkBookList($rows2["CategoryID"])."'>".$rows2["CategoryName"]."</a></p></div></li>";
							}
							$data[$i]["SubList"] .= "</ul>";
						}else{
							$data[$i]["SubList"] .= "</div>";
						}
						$data[$i]["SubList"] .= "</li>";
					}
					$data[$i]["SubList"] .= "</ul>";
				}else{
					if($data[$i]["CategoryID"] == $id){
						$data[$i]["className"] = " class='action'";
					}
				}
			}
			return $data;
		}
		private function formatBook($data=array()){
			for($i=0;$i<count($data);$i++){
				$data[$i]["link"] = parent::linkBookDetail($data[$i]["BookID"]);
				$data[$i]["linkC"] = parent::linkBookList($data[$i]["CategoryID"]);
				$data[$i]["imageStyle"] = "";
				if($data[$i]["BookImage"] == "" || !parent::image_exists($data[$i]["BookImage"])){
					$data[$i]["BookImage"] = $this->NoPicImage;
					$data[$i]["imageStyle"] = " style='display:none;'";
				}
			}
			return $data;
		}
	}

$page = new _book();
	$page->load();
	$page->render();
?>