<? include $_SERVER["DOCUMENT_ROOT"] . "/common/classes/ApiBase.php" ;?>
<?

if (! class_exists("ApiBoard"))
{

	class ApiBoard extends ApiBase
	{

		function __construct($req)
		{
			parent::__construct($req);
		}

		//공지사항 리스트
		function getListOfNotice(){
			$sql="
				SELECT *
				FROM tblNotice
				ORDER BY noticeNo DESC
			";
			return json_encode($this->getArray($sql));
			
			return makeResultJson(1, "aa");
		}
		
		//공지사항 정보
		function getInfoOfNotice(){
			$noticeNo=$this->req["no"];
			
			$sql="
				SELECT *
				FROM tblNotice
				WHERE noticeNo='{$noticeNo}'
			";
			return json_encode($this->getArray($sql));
				
		}
		
		//이벤트 리스트
		function getListOfEvent(){
			$sql="
				SELECT *
				FROM tblEvent
				ORDER BY eventNo DESC
			";
			return json_encode($this->getArray($sql));
		}
		
		//이벤트 정보
		function getInfoOfEvent(){
			$eventNo=$this->req["no"];
			$sql="
				SELECT *
				FROM tblEvent
				WHERE eventNo='{$eventNo}'
			";
			return json_encode($this->getArray($sql));
		}
		
		//자유게시판 리스트
		function getListOfBoard(){
			$sql="
				SELECT COUNT(*) 
				FROM tblBoard
				WHERE status='Y'
				ORDER BY boardNo DESC
			";
			$this->rownum = $this->getValue($sql, "rn");
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT *
				FROM tblBoard
				WHERE status='Y'
				ORDER BY boardNo DESC
				LIMIT {$this->startNum}, {$this->endNum}
			";
			$list=$this->getArray($sql);
			
			if (sizeof($list) > 0)
				return $this->makeResultJson("1", "", $list);
			else
				return $this->makeResultJson("-1000", "내역이 없습니다.");
		}
		
		//게시물 정보
		function getInfoOfBoard(){
			$boardNo = $this->req["no"];
			$sql="
				SELECT *
				FROM tblBoard
				WHERE boardNo='{$boardNo}' AND status='Y'
				LIMIT 1
			";
			$result=$this->getRow($sql);
			
			if($result != null){
				$sql="
					SELECT C.*, U.userID
					FROM tblComment C
					JOIN tblUser U ON C.userFk=U.userNo
					WHERE targetFk='{$boardNo}' AND commentType='FB'
					ORDER BY C.commentGroup ASC, C.gOrder ASC
				";
				$commentList=$this->getArray($sql);
				
				return $this->makeResultJson("1", "", $result, Array(
						"commentList" => $commentList
						));
			}
			else{
				return $this->makeResultJson("-1000", "내역이 없습니다.");
			}		
		}

		//고객센터 게시물 리스트
		function getListOfCS(){
			$sql="
				SELECT COUNT(*)
				FROM tblCustomerService
				WHERE status='Y'
				ORDER BY csNo DESC
			";
			$this->rownum = $this->getValue($sql, "rn");
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT *
				FORM tblCustomerService
				WHERE status='Y'
				ORDER BY csNo DESC
				LIMIT {$this->startNum}, {$this->endNum}
			";
			$list=$this->getArray($sql);
			
			if(sizeof($list)>0)
				return $this->makeResultJson("1", "", $list);
			else 
				return $this->makeResultJson("1000", "내역이 없습니다.");
		}
		
		//고객센터 게시물 내용
		function getInfoOfCS(){
			$csNo=$this->req["no"];
			$sql="
				SELECT *
				FROM tblCustomerService
				WHERE csNo='{$csNo}' AND status='Y'
				LIMIT 1
			";
			$result=$this->getRow($sql);
			
			if($result != null){
				$sql="
				SELECT
				FROM tblComment C
				JOIN tblUser U ON C.userFk=U.userNo
				WHERE targetFk='{$csNo}' AND commentType='CS'
				ORDER BY C.commentGroup ASC, C.gOrder ASC
				";
					
				$commentList=$this->getArray($sql);
				
				return $this->makeResultJson("1", "", $result, Array(
						"commentList" => $commentList
				));
			}
			else{
				return $this->makeResultJson("-1000", "내역이 없습니다.");
			}
		}
		
		//AS 엄체 리스트
		function getListOfCompany(){
			$sql="
				SELECT COUNT(*)
				FROM tblCompany
				WHERE status='Y'
				ORDER BY companyNo DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT *
				FROM tblCompany
				WHERE status='Y'
				ORDER BY companyNo DESC
				LIMIT {$this->startNum}, {$this->endNum}
			";
			$list=$this->getArray($sql);
			
			if(sizeof($list)>0)
				return $this->makeResultJson("1", "", $list);
			else 
				return $this->makeResultJson("-1000", "내역이 없습니다.");
		}
		
		function getInfoOfCompany(){
			$companyNo=$this->req["no"];
			
			$sql="
				SELECT *
				FROM tblCompany
				WHERE companyNo='{$companyNo}' AND status='Y'
				LIMIT 1
			";
			$result=$this->getRow($sql);
			
			if($result != null){
				$sql="
					SELECT 
					FROM tblComment C
					JOIN tblUser U ON C.userFk=U.userNo
					WHERE targetFk='{$companyNo}' AND commentType='CP'
					ORDER BY commentNo DESC
				";
				$commentList=$this->getArray($sql);
				
				return $this->makeResultJson("1", "", $result, Array(
						"commentList" => $commentList
				));
			}
			else{
				return $this->makeResultJson("-1000", "내역이 없습니다.");
			}
		}
		
		//댓글 저장
		function saveComment(){								
			$commentType=$this->req["commentType"];
			$targetFk=$this->req["targetFk"];
			$userFk=$this->req["userFk"];
			$content=$this->req["content"];
			$parentGroup=$this->req["parentGroup"];		//부모 댓글의 기본키
			$commentNo=$this->
			$sql="
				INSERT INTO tblComment(userFk, targetFk, commentGroup, gOrder, depth, content, commentType)
				VALUES
				(
					'{$userFk}', 
					'{$targetFk}',
					IFNULL(SELECT commentGroup FROM tblComment WHERE commentType='{$commentType}' AND commentGroup='{$parentGroup}' AND depth=0, '{$this->mysql_insert_id()}'),		
					IFNULL(SELECT gOrder FROM tblComment WHERE commentType='{$commentType}' AND commentGroup='{$parentGroup}', -1)+1,
					IFNULL(SELECT depth FROM tblComment WHERE commentType='{$commentType}' AND commentGroup='{$parentGroup}', -1)+1,
					'{$content}',
					'{$commentType}'
				)
			";
			
		}
		
		
		
		
		
	} // 클래스 종료
}
?>