<? 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
			";

			$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 *
				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 saveBoard(){
			$title=$this->req["title"];
			$userFk = $this->appUser["no"];
			$imgPathBoard1=$this->req["imgPathBoard1"];
			$imgPathBoard2=$this->req["imgPathBoard2"];
			$imgPathBoard3=$this->req["imgPathBoard3"];
			$content=$this->req["content"];
			
			$sql="
				INSERT INTO tblBoard(userFk, title, imgPathBoard1, imgPathBoard2, imgPathBoard3, content, status, regDate)
				VALUES
				(
					'{$userFk}',, 
					'{$title}',
					'{$imgPathBoard1}',
					'{$imgPathBoard2}',
					'{$imgPathBoard3}',
					'{$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 *
				FROM tblBoard
				WHERE boardNo='{$boardNo}' AND 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 ASC, C.gOrder ASC
				";
				$commentList=$this->getArray($sql);
				
				return $this->makeResultJson("1", "", $result, Array(
						"commentList" => $commentList
						));
			}
			else{
				return $this->makeResultJson("-1000", "내역이 없습니다.");
			}		
		}
		
		//고객센터 게시물 저장
		function saveCS(){
			$title=$this->req["title"];
			$userFk = $this->appUser["no"];
			$targetType=$this->req["targetType"];
			$imgPathCS1=$this->req["imgPathCS1"];
			$imgPathCS2=$this->req["imgPathCS2"];
			$imgPathCS3=$this->req["imgPathCS3"];
			$content=$this->req["content"];
			
			$sql="
				INSERT INTO tblCustomerService(userFk, title, targetType, imgPathCS1, imgPathCS2, imgPathCS3, content, status, regDate)
				VALUES
				(
					'{$userFk}',
					'{$title}',
					'{$targetType}',
					'{$imgPathCS1}',
					'{$imgPathCS2}',
					'{$imgPathCS3}',
					'{$content}',
					1,
					NOW()
				)
			";
			$this->update($sql);
			return $this->makeResultJson("1", "저장되었습니다");
			
		}

		//고객센터 게시물 리스트
		function getListOfCS(){
			$searchText=$this->req["searchText"];
			$searchType=$this->req["searchType"];
				
			$where="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.no
				WHERE status=1
				ORDER BY csNo DESC
			";
			$this->rownum = $this->getValue($sql, "rn");
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT CS.*, U.userID, U.userNo
				FORM tblCustomerService CS
				JOIN tblUser U ON CS.userFk=U.no
				WHERE 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"];
			$sql="
				SELECT *
				FROM tblCustomerService
				WHERE csNo='{$csNo}' AND 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 ASC, 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="status=1";
			
			if(!empty($provinceNumber)){
				$where.=" AND address LIKE (SELECT abbreviation FROM tblZipProvince WHERE provinceNumber='{$provinceNumber}')";
			}
			
			$sql="
				SELECT COUNT(*)
				FROM tblCompany
				{$where}
				ORDER BY companyNo DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$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"];
			
			$sql="
				SELECT *
				FROM tblCompany
				WHERE companyNo='{$companyNo}' AND 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.ommentGroup ASC, 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 *
				FROM tblComment
				WHERE commentType='{$commentType}'
				AND commentGroup=(SELECT commentGroup FROM tblComment WHERE commentType='{$commentType}' AND commentNo='{$parentNo}' AND status=1)
				AND gOrder=(SELECT gOrder + 1 FROM tblComment WHERE commentType='{$commentType}' AND commentNo='{$parentNo}' AND status=1)
				AND depth=(SELECT depth+1 FROM tblComment WHERE commentType='{$commentType}' AND commentNo='{$parentNo}' AND status=1)
				ORDER BY gOrder DESC
				LIMIT 0, 1
				";
				$child=$this->getRow($sql);
				$childNo=$child["commentNo"];
				$childGroup=$child["commentGroup"];
				$childOrder=$child["gOrder"];
				$childDepth=$child["depth"]; 
					
				if(!empty($childNo)){		//부모에게 자식이 있을 때
					echo "child exists";
					$sql="
						INSERT INTO tblComment(userFk, targetFk, commentGroup, gOrder, depth, content, commentType, status, regDate)
						VALUES
						(
						'{$userFk}',
						'{$targetFk}',
						'{$childGroup}',
						'{$childOrder}' + 1,
						'{$childDepth}',
						'{$content}',
						'{$commentType}',
						1,
						NOW()
						)
					";
					$this->update($sql);
					
					$sql="
						UPDATE tblComment
						SET gOrder=gOrder+1
						WHERE commentGroup='{$childGroup}' AND gOrder > '{$childOrder}' + 1 AND status=1
					";
					$this->update($sql);
					return $this->makeResultJson("1", "저장되었습니다");
				}
				else{		//부모에게 자식이 없을 때
					echo "no child";
					$sql="
					INSERT INTO tblComment(userFk, targetFk, commentGroup, gOrder, depth, content, commentType, status, regDate)
					VALUES
					(
					'{$userFk}',
					'{$targetFk}',
					(SELECT commentGroup FROM (SELECT * FROM tblComment) AS tblComment WHERE commentNo='{$parentNo}' AND status=1),				
					(SELECT gOrder + 1 FROM (SELECT * FROM tblComment) AS tblComment WHERE commentNo='{$parentNo}' AND status=1),			
					(SELECT depth + 1 FROM (SELECT * FROM tblComment) AS tblComment WHERE commentNo='{$parentNo}' AND status=1),		
					'{$content}',
					'{$commentType}',
					1,
					NOW()
					)
					";
					$this->update($sql);
					
					$currentNo=$this->mysql_insert_id();
			
					$sql="SELECT commentGroup FROM tblComment WHERE commentNo='{$parentNo}' AND status=1";
					$commentGroup=$this->getValue($sql, "commentGroup");
					
					$sql="SELECT gOrder + 1 FROM tblComment WHERE commentNo='{$parentNo}' AND status=1";
					$gOrder=$this->getValue($sql, "gOrder + 1");
					
					$sql="
						UPDATE tblComment
						SET gOrder=gOrder+1
						WHERE commentGroup='{$commentGroup}' AND gOrder >= '{$gOrder}' AND commentNo <> '{$currentNo}' AND status=1
					";
					$this->update($sql);
					return $this->makeResultJson("1", "저장되었습니다");
				}
				
			}

			
		}
		
		//제작사양서 저장
		function saveProductionSpec(){
			$userFk = $this->appUser["no"];
			$requestDate=$this->req["requestDate"];
			$companyName=$this->req["companyName"];
			$vehicleTON=$this->req["vehicleTON"];
			$vehicleText=$this->req["vehicleText"];
			$vehicleType=$this->req["vehicleType"];
			$productName=$thie->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)
				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"];
			$sql="
				SELECT productionNo, companyName, requestDate
				FROM tblProductionSpec
				WHERE userFk='{$userFk}'
				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="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 productionNo, companyName, requestDate
				FROM tblProduntionSpec
				{$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"];
			$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);
			return $this->makeResultJson("1", "", $list);
		}
		
		//좋아요
		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 productionNo, companyName, requestDate
				FROM tblProductionSpec PS
				JOIN tblLike L ON PS.productionNo=L.productionNo
				WHERE L.userNo='{$userNo}'
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1","", $result);
		}
		
		
		
		
		
		
		
	} // 클래스 종료
}
?>