<? 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 COUNT(*)
				FROM tblNotice
				ORDER BY noticeNo DESC
			";
			
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT *
				FROM tblNotice
				ORDER BY noticeNo DESC
			";

			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		//공지사항 정보
		function getInfoOfNotice(){
			$noticeNo=$this->req["no"];
			
			$sql="
				SELECT *
				FROM tblNotice
				WHERE noticeNo='{$noticeNo}'
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
				
		}
		
		//이벤트 리스트
		function getListOfEvent(){
			$sql="
				SELECT COUNT(*)
				FROM tblEvent
				ORDER BY eventNo DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT *
				FROM tblEvent
				ORDER BY eventNo DESC
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		//이벤트 정보
		function getInfoOfEvent(){
			$eventNo=$this->req["no"];
			$sql="
				SELECT *
				FROM tblEvent
				WHERE eventNo='{$eventNo}'
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function getListCountBoard(){
			$sql="SELECT COUNT(*) FROM tblBoard WHERE status=1";
			$result=$this->getValue($sql, "rn");
			return $this->makeResultJson("1", "", $result);
		}
		
		function getListCountCS(){
			$sql="SELECT COUNT(*) FROM tblCustomerService WHERE status=1";
		}
		
		
		//자유게시판 게시물 작성
		function saveBoard(){
			$imgResult = $this->inFn_Common_fileSave($_FILES);
			
			$title=$this->req["title"];
			//$userFk = $this->appUser["no"];
			$userFk=$this->req["userFk"];
			
			$imgPathBoard1 = $imgResult["imgPathBoard1"]["saveURL"] != null ? $imgResult["imgPathBoard1"]["saveURL"] : $this->req["imgPathBoard1"];
			$imgPathBoard2 = $imgResult["imgPathBoard2"]["saveURL"] != null ? $imgResult["imgPathBoard2"]["saveURL"] : $this->req["imgPathBoard2"];
			$imgPathBoard3 = $imgResult["imgPathBoard3"]["saveURL"] != null ? $imgResult["imgPathBoard3"]["saveURL"] : $this->req["imgPathBoard3"];
			$imgPathBoard4 = $imgResult["imgPathBoard4"]["saveURL"] != null ? $imgResult["imgPathBoard4"]["saveURL"] : $this->req["imgPathBoard4"];
			$imgPathBoard5 = $imgResult["imgPathBoard5"]["saveURL"] != null ? $imgResult["imgPathBoard5"]["saveURL"] : $this->req["imgPathBoard5"];
				
			
			$content=$this->req["content"];
			
			$sql="
				INSERT INTO tblBoard(userFk, title, imgPathBoard1, imgPathBoard2, imgPathBoard3, imgPathBoard4, imgPathBoard5, content, status, regDate)
				VALUES
				(
					'{$userFk}', 
					'{$title}',
					'{$imgPathBoard1}',
					'{$imgPathBoard2}',
					'{$imgPathBoard3}',
					'{$imgPathBoard4}',
					'{$imgPathBoard5}',
					'{$content}',
					1,
					NOW()
				)
			";
			$this->update($sql);
			return $this->makeResultJson("1", "저장되었습니다");
		}
		
		//자유게시판 리스트
		function getListOfBoard(){
			$searchText=$this->req["searchText"];
			$searchType=$this->req["searchType"];
			
			$where="WHERE B.status=1";
			
			if(!empty($searchText)){
				if(empty($search_type)){
					$where.=" AND (U.userID LIKE '%{$searchText}%' OR B.title LIKE '%{$searchText}%')";
				}
				else if($searchType=="작성자"){
					$where.=" AND U.userID LIKE '%{$searchText}%'";
				}
				else if($searchType=="제목"){
					$where.=" AND B.title LIKE '%{$searchText}%'";	
				}
			}
			
			
			$sql="
				SELECT COUNT(*) 
				FROM tblBoard B
				JOIN tblUser U ON B.userFk=U.userNo
				{$where}
				ORDER BY boardNo DESC
			";
			$this->rownum = $this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT B.*, U.userID, U.userNo
				FROM tblBoard B
				JOIN tblUser U ON B.userFk=U.userNo
				{$where}
				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"];
			$boardNo=1;
			$sql="
				SELECT B.*, U.userID, U.userName
				FROM tblBoard B
				JOIN tblUser U ON B.userFk=U.userNo
				WHERE boardNo='{$boardNo}' AND B.status=1
				LIMIT 1
			";
			$result=$this->getRow($sql);
			
			if($result != null){
				$sql="
					SELECT C.*, U.userID, U.userNo
					FROM tblComment C
					JOIN tblUser U ON C.userFk=U.userNo
					WHERE targetFk='{$boardNo}' AND commentType='FB'
					ORDER BY C.commentGroup DESC, C.gOrder ASC
				";
				$commentList=$this->getArray($sql);
				
				return $this->makeResultJson("1", "", $result, Array(
						"commentList" => $commentList
						));
			}
			else{
				return $this->makeResultJson("-1000", "내역이 없습니다.");
			}		
		}
		
		//고객센터 게시물 저장
		function saveCS(){
			$imgResult = $this->inFn_Common_fileSave($_FILES);
			$imgPathCS1 = $imgResult["imgPathCS1"]["saveURL"] != null ? $imgResult["imgPathCS1"]["saveURL"] : $this->req["imgPathCS1"];
			$imgPathCS2 = $imgResult["imgPathCS2"]["saveURL"] != null ? $imgResult["imgPathCS2"]["saveURL"] : $this->req["imgPathCS2"];
			$imgPathCS3 = $imgResult["imgPathCS3"]["saveURL"] != null ? $imgResult["imgPathCS3"]["saveURL"] : $this->req["imgPathCS3"];
			$imgPathCS4 = $imgResult["imgPathCS4"]["saveURL"] != null ? $imgResult["imgPathCS4"]["saveURL"] : $this->req["imgPathCS4"];
			$imgPathCS5 = $imgResult["imgPathCS5"]["saveURL"] != null ? $imgResult["imgPathCS5"]["saveURL"] : $this->req["imgPathCS5"];
			
			$title=$this->req["title"];
			//$userFk = $this->appUser["no"];
			$userFk=$this->req["userFk"];
			$targetType=$this->req["targetType"];
			$content=$this->req["content"];
			
			$sql="
				INSERT INTO tblCustomerService(userFk, title, targetType, imgPathCS1, imgPathCS2, imgPathCS3, imgPathCS4, imgPathCS5, content, status, regDate)
				VALUES
				(
					'{$userFk}',
					'{$title}',
					'{$targetType}',
					'{$imgPathCS1}',
					'{$imgPathCS2}',
					'{$imgPathCS3}',
					'{$imgPathCS4}',
					'{$imgPathCS5}',
					'{$content}',
					1,
					NOW()
				)
			";
			$this->update($sql);
			return $this->makeResultJson("1", "저장되었습니다");
			
		}

		//고객센터 게시물 리스트
		function getListOfCS(){
			$searchText=$this->req["searchText"];
			$searchType=$this->req["searchType"];
				
			$where="CS.status=1 AND targetType = 1";
				
			if(!empty($searchText)){
				if(empty($search_type)){
					$where.=" AND (U.userID LIKE '%{$searchText}%' OR CS.title LIKE '%{$searchText}%')";
				}
				else if($searchType=="작성자"){
					$where.=" AND U.userID LIKE '%{$searchText}%'";
				}
				else if($searchType=="제목"){
					$where.=" AND CS.title LIKE '%{$searchText}%'";
				}
			}
			
			
			$sql="
				SELECT COUNT(*)
				FROM tblCustomerService CS
				JOIN tblUser U ON CS.userFk=U.userNo
				WHERE CS.status=1
				ORDER BY csNo DESC
			";
			$this->rownum = $this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT CS.*, U.userID, U.userNo
				FROM tblCustomerService CS
				JOIN tblUser U ON CS.userFk=U.userNo
				WHERE CS.status=1
				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"];
			$csNo=2;
			$sql="
				SELECT CS.*, U.userID, U.userName
				FROM tblCustomerService CS
				JOIN tblUser U ON CS.userFk=U.userNo
				WHERE csNo='{$csNo}' AND CS.status=1
				LIMIT 1
			";
			$result=$this->getRow($sql);
			
			if($result != null){
				$sql="
				SELECT U.userNo, U.userID, C.*
				FROM tblComment C
				JOIN tblUser U ON C.userFk=U.userNo
				WHERE targetFk='{$csNo}' AND commentType='CS'
				ORDER BY C.commentGroup DESC, C.gOrder ASC
				";
					
				$commentList=$this->getArray($sql);
				
				return $this->makeResultJson("1", "", $result, Array(
						"commentList" => $commentList
				));
			}
			else{
				return $this->makeResultJson("-1000", "내역이 없습니다.");
			}
		}
		

		//AS엄체 리스트
		function getListOfCompany(){
			$provinceNumber=$this->req["provinceNumber"];
			$cityNumber=$this->req["cityNumber"];
			$searchText=$this->req["searchText"];
			
			$where="WHERE status=1";
			
			if(!empty($provinceNumber)){
				$where.=" AND address LIKE (SELECT abbreviation FROM tblZipProvince WHERE provinceNumber='{$provinceNumber}')";
			}
			
			if(!empty($cityNumber)){
				$where.=" AND address LIKE (SELECT abbreviation FROM tblZipCity WHERE provinceNumber='{$provinceNumber}')";
			}
			if(!empty($searchText)){
				$where.=" AND name LIKE '%{$searchText}%'";
			}
			
			$sql="
				SELECT COUNT(*)
				FROM tblCompany
				{$where}
				ORDER BY companyNo DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT companyNo, name, telephone
				FROM tblCompany
				{$where}
				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", "내역이 없습니다.");
		}
		
		//AS업체 상세
		function getInfoOfCompany(){
			//$companyNo=$this->req["no"];
			$companyNo=1;
			
			$sql="
				SELECT C.*
				FROM tblCompany C
				WHERE companyNo='{$companyNo}' AND C.status=1
				LIMIT 1
			";
			$result=$this->getRow($sql);
			
			if($result != null){
				$sql="
					SELECT U.userNo, U.userID, C.*
					FROM tblComment C
					JOIN tblUser U ON C.userFk=U.userNo
					WHERE targetFk='{$companyNo}' AND commentType='CP'
					ORDER BY C.commentGroup DESC, C.gOrder ASC
				";
				$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->appUser["no"];;
			$userFk=$this->req["userFk"];
			$content=$this->req["content"];
			$parentNo=$this->req["parentNo"];		//부모 댓글의 기본키
			
			if(empty($parentNo)){		//부모가 없을 때
				$sql="
					INSERT INTO tblComment(userFk, targetFk, commentGroup, gOrder, depth, content, commentType, status, regDate)
					VALUES
					(
						'{$userFk}',
						'{$targetFk}',
						0,
						1,
						1,
						'{$content}',
						'{$commentType}',
						1,
						NOW()
					)
				";
				$this->update($sql);
				
				$currentNo=$this->mysql_insert_id();
				$sql="
					UPDATE tblComment
					SET commentGroup='{$currentNo}'
					WHERE commentNo='{$currentNo}'
				";
				$this->update($sql);
				
				return $this->makeResultJson("1", "저장되었습니다");
			}
			else{			//부모 있을 때
				$sql="
					SELECT gOrder, commentGroup, depth
					FROM tblComment
					WHERE commentNo='{$parentNo}'
				";
				$parent=$this->getRow($sql);
				
				$parentGOrder=$parent["gOrder"];
				$parentCommentGroup=$parent["commentGroup"];
				$parentDepth=$parent["depth"];

				$sql="
					UPDATE tblComment
					SET gOrder=gOrder+1
					WHERE commentGroup='{$parentCommentGroup}' AND gOrder>'{$parentGOrder}'
				";
				$this->update($sql);
				
				$sql="
					INSERT INTO tblComment(userFk, targetFk, commentGroup, gOrder, depth, content, commentType, status, regDate)
					VALUES
					(
						'{$userFk}',
						'{$targetFk}',
						'{$parentCommentGroup}',
						'{$parentGOrder}' + 1,
						'{$parentDepth}' + 1,
						'{$content}',
						'{$commentType}',
						1,
						NOW()
					)
				";
				$this->update($sql);
				
				return $this->makeResultJson("1", "저장되었습니다");
			}
		}
		
		//제작사양서 저장
		function saveProductionSpec(){
			//$userFk = $this->appUser["no"];
			$userFk = $this->req["userFk"];
			$requestDate=$this->req["requestDate"];
			$companyName=$this->req["companyName"];
			$vehicleTON=$this->req["vehicleTON"];
			$vehicleText=$this->req["vehicleText"];
			$vehicleType=$this->req["vehicleType"];
			$productName=$this->req["productName"];
			$telephone=$this->req["telephone"];
			$managerFk=$this->req["managerFk"];
			$type=$this->req["type"];
			$internalLength=$this->req["internalLength"];
			$internalHeight=$this->req["internalHeight"];
			$internalWidth=$this->req["internalWidth"];
			$alCoil=$this->req["alCoil"];
			$floor=$this->req["floor"];
			$floorValue=$this->req["floorValue"];
			$tent=$this->req["tent"];
			$sideBoard=$this->req["sideBoard"];
			$windStopper=$this->req["windStopper"];
			$freezer=$this->req["freezer"];
			$gate=$this->req["gate"];
			$load=$this->req["load"];
			$eTrackGate=$this->req["eTrackGate"];
			$eTrackWing=$this->req["eTrackWing"];
			$turnBuckle=$this->req["turnBuckle"];
			$toolBucket=$this->req["toolBucket"];
			$bumperFootHold=$this->req["bumperFootHold"];
			$wingProtector=$this->req["wingProtector"];
			$axis=$this->req["axis"];
			$axisValue=$this->req["axisValue"];
			$specialAddition=$this->req["specialAddition"];
			
			$sql="
				INSERT INTO tblProductionSpec(userFk, requestDate, companyName, vehicleTON, vehicleText, vehicleType, productName, telephone, managerFk, `type`, internalLength, internalHeight, internalWidth, alCoil,
					`floor`, floorValue, tent, sideBoard, windStopper, freezer, gate, `load`, eTrackGate, eTrackWing, turnBuckle, toolBucket, bumperFootHold, wingProtector, axis, axisValue, specialAddition, status, regDate)
				VALUES
				(
					'{$userFk}',
					'{$requestDate}',
					'{$companyName}',
					'{$vehicleTON}',
					'{$vehicleText}',
					'{$vehicleType}',
					'{$productName}',
					'{$telephone}',
					'{$managerFk}',
					'{$type}',
					'{$internalLength}',
					'{$internalHeight}',
					'{$internalWidth}',
					'{$alCoil}',
					'{$floor}',
					'{$floorValue}',
					'{$tent}',
					'{$sideBoard}',
					'{$windStopper}',
					'{$freezer}',
					'{$gate}',
					'{$load}',
					'{$eTrackGate}',
					'{$eTrackWing}',
					'{$turnBuckle}',
					'{$toolBucket}',
					'{$bumperFootHold}',
					'{$wingProtector}',
					'{$axis}',
					'{$axisValue}',
					'{$specialAddition}',
					1,
					NOW()
				)
			";
			$this->update($sql);
			return $this->makeResultJson("1", "저장되었습니다");
		}
		
		//내 제작사양서
		function getListOfMyProductionSpec(){
			//$userFk=$this->appUser["no"];
			$userFk=1;
			
			$sql="
				SELECT COUNT(*)
				FROM tblProductionSpec
				WHERE userFk='{$userFk}' AND status=1
				ORDER BY productionNo DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT productionNo, companyName, requestDate
				FROM tblProductionSpec 
				WHERE userFk='{$userFk}' AND status=1
				ORDER BY productionNo DESC
			";
			$list=$this->getArray($sql);
			
			if(sizeof($list)>0)
				return $this->makeResultJson("1", "", $list);
			else
				return $this->makeResultJson("-1000", "내역이 없습니다.");
		}
		
		//제작사양서 리스트(검색) 
		function getListOfProductionSpec(){
			$dateFormer=$this->req["dateFormer"];
			$dateLatter=$this->req["dateLatter"];
			$managerFk=$this->req["managerFk"];

			$where="WHERE status=1";
			if(!empty($dateFormer)){
				$where .= " AND DATE_FORMAT(requestDate, '%Y%m%d') >= DATE_FORMAT('{$dateFormer}', '%Y%m%d')";
			}
			if(!empty($dateLatter)){
				$where .= " AND DATE_FORMAT(requestDate, '%Y%m%d') <= DATE_FORMAT('{$dateLatter}', '%Y%m%d')";
			}
			if(!empty($managerFk)){
				$where .= " AND managerFk='{$managerFk}'";
			}
			
			$sql="
				SELECT COUNT(*)
				FROM tblProductionSpec
				{$where}
				ORDER BY productionNo DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			
			$sql="
				SELECT productionNo, companyName, requestDate
				FROM tblProductionSpec
				{$where}
				ORDER BY productionNo DESC
			";
			$list=$this->getArray($sql);
			
			if(sizeof($list)>0)
				return $this->makeResultJson("1", "", $list);
			else
				return $this->makeResultJson("-1000", "내역이 없습니다.");
		}
		
		//제작사양서  상세정보
		function getInfoOfProductionSpec(){
			$productionNo=$this->req["productionNo"];
			$productionNo=3;
			$sql="
				SELECT *
				FROM tblProductionSpec
				WHERE productionNo='{$productionNo}'
			";
			$info=$this->getRow($sql);
			return $this->makeResultJson("1", "", $info);
		}
		
		//담당자 리스트
		function getListOfManager(){
			$sql="
				SELECT managerNo, name
				FROM tblManager
				WHERE status=1
				ORDER BY name ASC
			";
			$list=$this->getArray($sql);
			if(sizeof($list)>0)
				return $this->makeResultJson("1", "", $list);
			else 
				return $this->makeResultJson("-1000", "내역이 없습니다");
		}
		
		//좋아요
		function productionLike(){
			$userNo=$this->appUser["userNo"];
			$productionNo=$this->req["productionNo"];
			
			$sql="
				INSERT INTO tblLike(userNo, productionNo, regDate)
				VALUES('{$userNo}', '{$productionNo}', NOW())
			";
			$this->update($sql);
			return $this->makeResultJson("1", "등록되었습니다");
		}
		
		//좋아요 취소
		function productionLikeCancel(){
			$userNo=$this->req["userNo"];
			$productionNo=$this->req["productionNo"];
			
			$sql="DELETE FROM tblLike WHERE userNo='{$userNo}' AND productionNo='{$productionNo}'";
			$this->update($sql);
			return $this->makeResultJson("1", "취소되었습니다");
		}
		
		//제작사양서 보관함 리스트(좋아요 리스트)
		function productionLikeList(){
			$userNo=$this->appUser["no"];
			
			$sql="
				SELECT COUNT(*)
				FROM tblProductionSpec PS
				JOIN tblLike L ON PS.productionNo=L.productionNo
				WHERE L.userNo='{$userNo}' AND PS.status=1
				ORDER BY regDate DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT PS.productionNo, companyName, requestDate
				FROM tblProductionSpec PS
				JOIN tblLike L ON PS.productionNo=L.productionNo
				WHERE L.userNo='{$userNo}' AND PS.status=1
				ORDER BY regDate DESC
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1","", $result);
		}
		
		
		
		
		
		
		
	} // 클래스 종료
}
?>