<? 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(*) AS rn
				FROM tblNotice
				WHERE status=1
				ORDER BY noticeNo DESC
			";
			
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT noticeNo, title
				FROM tblNotice
				WHERE status=1
				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(*) AS rn
				FROM tblEvent
				WHERE status=1
				ORDER BY eventNo DESC
			";
			$this->rownum=$this->getValue($sql, "rn");
			$this->initPage();
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT eventNo, title
				FROM tblEvent
				WHERE status=1
				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);
			
			if($result != null){
				$sql="
					SELECT C.*, U.userID, U.userNo
					FROM tblComment C
					JOIN tblUser U ON C.userFk=U.userNo
					WHERE targetFk='{$eventNo}' AND commentType='EV'
					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 getListCountBoard(){
			$sql="SELECT COUNT(*) AS rn FROM tblBoard WHERE status=1";
			$result=$this->getValue($sql, "rn");
			return $this->makeResultJson("1", "", $result);
		}
		
		function getListCountCS(){
			$sql="SELECT COUNT(*) AS rn FROM tblCustomerService WHERE status=1";
			$result=$this->getValue($sql, "rn");
			return $this->makeResultJson("1", "", $result);
		}
		
		
		//자유게시판 게시물 작성
		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(*) AS rn
				FROM tblBoard B
				JOIN tblUser U ON B.userFk=U.userNo
				{$where}
				ORDER BY boardNo DESC
			";
			$this->initPage();
			$this->rownum = $this->getValue($sql, "rn");
			
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT B.boardNo, B.title, 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 modifyBoard(){			//미완성
			$boardNo=$this->req["boardNo"];
			$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="
			UPDATE tblBoard 
			SET
			title='{$title}',
			imgPathBoard1='{$imgPathBoard1}',
			imgPathBoard2='{$imgPathBoard2}',
			imgPathBoard3='{$imgPathBoard3}',
			imgPathBoard4='{$imgPathBoard4}',
			imgPathBoard5='{$imgPathBoard5}',
			content='{$content}'
			WHERE boardNo='{$boardNo}' AND status=1
			";
			$this->update($sql);
			return $this->makeResultJson("1", "저장되었습니다");
		}
		
		function delBoard(){
			$boardNo=$this->req["boardNo"];
			
			$sql="UPDATE tblBoard SET status=0 WHERE boardNo='{$boardNo}'";
			$this->update($sql);
			return $this->makeResultJson("1", "삭제되었습니다");
		}
		
		//고객센터 게시물 저장
		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 modifyCS(){			//미완성
			$csNo=$this->req["csNo"];
			$imgResult = $this->inFn_Common_fileSave($_FILES);
		
			$title=$this->req["title"];
			$targetType=$this->req["targetType"];
			//$userFk = $this->appUser["no"];
			$userFk=$this->req["userFk"];
			$content=$this->req["content"];
			
			$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"];
				
		
			
		
			$sql="
			UPDATE tblCustomerService
			SET
			title='{$title}',
			targetType='{$targetType}',
			imgPathCS1='{$imgPathCS1}',
			imgPathCS2='{$imgPathCS2}',
			imgPathCS3='{$imgPathCS3}',
			imgPathCS4='{$imgPathCS4}',
			imgPathCS5='{$imgPathCS5}',
			content='{$content}'
			WHERE csNo='{$csNo}' AND status=1
			";
			$this->update($sql);
			return $this->makeResultJson("1", "저장되었습니다");
		}
		
		function delCS(){
			$csNo=$this->req["csNo"];
				
			$sql="UPDATE tblCustomerService SET status=0 WHERE csNo='{$csNo}'";
			$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(*) AS rn
				FROM tblCustomerService CS
				JOIN tblUser U ON CS.userFk=U.userNo
				WHERE CS.status=1
				ORDER BY csNo DESC
			";
			$this->initPage();
			$this->rownum = $this->getValue($sql, "rn");
			
			$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"];
			$productNumber=$this->req["productNumber"];
			$searchText=$this->req["searchText"];
			
			$where="WHERE status=1";
			
			if(!empty($provinceNumber)){
				$where.=" AND provinceCode='{$provinceNumber}'";
			}
			
			if(!empty($productNumber)){
				$where.=" AND productCode='{$productNumber}'";
			}
			if(!empty($searchText)){
				$where.=" AND name LIKE '%{$searchText}%'";
			}
			
			$sql="
				SELECT COUNT(*) AS rn
				FROM tblCompany
				{$where}
				ORDER BY companyNo DESC
			";
			$this->initPage();
			$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"];
			$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 getInfoOfComment(){
			$commentNo=$this->req["commentNo"];
			$sql="
				SELECT *
				FROM tblComment
				WHERE commentNo='{$commentNo}'
			";
			$result=$this->getRow($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function modifyComment(){
			$commentNo=$this->req["commentNo"];
			$content=$this->req["content"];
			$sql="
				UPDATE tblComment
				SET content='$content'
				WHERE commentNo='{$commentNo}'
			";
			$this->update($sql);
		}
		
		function delComment(){
			$commentNo=$this->req["commentNo"];
			
			$sql="
				UPDATE tblComment
				SET status=0
				WHERE commentNo='{$commentNo}' OR (
				commentGroup=(SELECT commentGroup FROM (SELECT * FROM tblComment) AS c WHERE commentNo='{$commentNo}') 
				AND depth > (SELECT depth FROM (SELECT * FROM tblComment) AS c WHERE commentNo='{$commentNo}'))
			";
		}
		
		//제작사양서 저장
		function saveProductionSpec(){
			//$userFk = $this->appUser["no"];
			$userFk = $this->req["userFk"];
			$requestDate=$this->req["requestDate"];
			$customerName=$this->req["customerName"];
			$companyName=$this->req["companyName"];
			$vehicleTON=$this->req["vehicleTON"];
			$vehicleText=$this->req["vehicleText"];
			$vehicleType=$this->req["vehicleType"];
			$productName=$this->req["productName"];
			$telephone=$this->req["telephone"];
			$type=$this->req["type"];
			$typeValue=$this->req["typeValue"];
			$internalLength=$this->req["internalLength"];
			$internalHeight=$this->req["internalHeight"];
			$internalWidth=$this->req["internalWidth"];
			$alCoil=$this->req["alCoil"];
			$alCoilValue=$this->req["alCoilValue"];
			$floor=$this->req["floor"];
			$floorValueT=$this->req["floorValueT"];
			$floorValueText=$this->req["floorValueText"];
			$tent=$this->req["tent"];
			$sideBoard=$this->req["sideBoard"];
			$sideBoardValue=$this->req["sideBoardValue"];
			$windStopper=$this->req["windStopper"];
			$windStopperValue=$this->req["windStopperValue"];
			$freezer=$this->req["freezer"];
			$freezerValue=$this->req["freezerValue"];
			$gateType=$this->req["gateType"];
			$gateSize=$this->req["gateSize"];
			$gateValue=$this->req["gateValue"];
			$load=$this->req["load"];
			$frontBack=$this->req["frontBack"];
			$eTrackGate=$this->req["eTrackGate"];
			$eTrackWing=$this->req["eTrackWing"];
			$eTrackValue=$this->req["eTrackValue"];
			$toolBucket=$this->req["toolBucket"];
			$toolBucketValue=$this->req["toolBucketValue"];
			$bumperFootHold=$this->req["bumperFootHold"];
			$wingProtector=$this->req["wingProtector"];
			$axis=$this->req["axis"];
			$axisValue=$this->req["axisValue"];
			$balance=$this->req["balance"];
			$specialAddition=$this->req["specialAddition"];
			
			if(empty($requestDate) || empty($customerName) || empty($companyName) || empty($productName) || empty($telephone) || empty($userFk) || empty($balance) || empty($type) || empty($alCoil) || empty($floor) || empty($tent) || empty($sideBoard)
					|| empty($windStopper) || empty($freezer) || empty($gateType) || empty($gateSize) || empty($load) || empty($frontBack) || empty($eTrackGate) || empty($eTrackWing) || empty($toolBucket) || empty($bumperFootHold) || empty($wingProtector) 
					|| empty($axis)){
				return $this->makeResultJson("-1", "저장오류");
			}
			
			$sql="
				INSERT INTO tblProductionSpec(
					userFk, 
					requestDate,
					customerName,
					companyName, 
					vehicleTON, 
					vehicleText, 
					vehicleType, 
					productName, 
					telephone, 
					`type`,
					typeValue,
					internalLength, 
					internalHeight, 
					internalWidth, 
					alCoil,
					alCoilValue,
					`floor`, 
					floorValueT,
					floorValueText,
					tent, 
					sideBoard, 
					sideBoardValue,
					windStopper, 
					windStopperValue,
					freezer, 
					freezerValue,
					gateType,
					gateSize,
					gateValue,
					`load`, 
					frontBack,
					eTrackGate, 
					eTrackWing, 
					eTrackValue,
					toolBucket, 
					toolBucketValue,
					bumperFootHold,
					wingProtector, 
					axis, 
					axisValue, 
					balance,
					specialAddition, 
					status, 
					regDate
				)
				VALUES
				(
					'{$userFk}',
					'{$requestDate}',
					'{$customerName}',
					'{$companyName}',
					'{$vehicleTON}',
					'{$vehicleText}',
					'{$vehicleType}',
					'{$productName}',
					'{$telephone}',
					'{$type}',
					'{$typeValue}',
					'{$internalLength}',
					'{$internalHeight}',
					'{$internalWidth}',
					'{$alCoil}',
					'{$alCoilValue}',
					'{$floor}',
					'{$floorValueT}',
					'{$floorValueText}',
					'{$tent}',
					'{$sideBoard}',
					'{$sideBoardValue}',
					'{$windStopper}',
					'{$windStopperValue}',
					'{$freezer}',
					'{$freezerValue}',
					'{$gateType}',
					'{$gateSize}',
					'{$gateValue}',
					'{$load}',
					'{$frontBack}',
					'{$eTrackGate}',
					'{$eTrackWing}',
					'{$eTrackValue}',
					'{$toolBucket}',
					'{$toolBucketValue}',
					'{$bumperFootHold}',
					'{$wingProtector}',
					'{$axis}',
					'{$axisValue}',
					'{$balance}',
					'{$specialAddition}',
					1,
					NOW()
				)
			";
			$this->update($sql);
			return $this->makeResultJson("1", "저장되었습니다");
		}
		
		//내 제작사양서
		function getListOfMyProductionSpec(){
			//$userFk=$this->appUser["no"];
			$userFk=1;
			
			$sql="
				SELECT COUNT(*) AS rn
				FROM tblProductionSpec
				WHERE userFk='{$userFk}' AND status=1
				ORDER BY productionNo DESC
			";
			$this->initPage();
			$this->rownum=$this->getValue($sql, "rn");
			
			$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"];
			$userFk=$this->req["userFk"];

			$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($userFk)){
				$where .= " AND userFk='{$userFk}'";
			}
			
			$sql="
				SELECT COUNT(*) AS rn
				FROM tblProductionSpec
				{$where}
				ORDER BY productionNo DESC
			";
			$this->initPage();
			$this->rownum=$this->getValue($sql, "rn");
			
			$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(){
			$userNo=$this->appUser["userNo"];
			$productionNo=$this->req["productionNo"];
			$productionNo=3;
			$sql="
				SELECT PS.*, U.userNo, U.userName, IFNULL((SELECT userNo FROM tblLike WHERE userNo='{$userNo}' AND productionNo='{$productionNo}'), 0) AS likeStatus
				FROM tblProductionSpec PS
				JOIN tblUser U ON PS.userFk=U.userNo
				WHERE productionNo='{$productionNo}'
			";
			$info=$this->getRow($sql);
			
			if($userNo == $info["userNo"])
				$info["balance"] = null;
			
			return $this->makeResultJson("1", "", $info);
		}

		
		//좋아요
		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(*) AS rn
				FROM tblProductionSpec PS
				JOIN tblLike L ON PS.productionNo=L.productionNo
				WHERE L.userNo='{$userNo}' AND PS.status=1
				ORDER BY regDate DESC
			";
			$this->initPage();
			$this->rownum=$this->getValue($sql, "rn");
			
			$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);
		}
		
		function getListOfProductionPortrait(){
			$sql="
				SELECT COUNT(*) AS rn
				FROM tblProductionPortrait
				WHERE status=1
				ORDER BY regDate DESC
			";
			$this->initPage();
			$this->rownum=$this->getValue($sql, "rn");
			
			$this->setPageForDevice($this->rownum);
			
			$sql="
				SELECT ppNo, title, regDate
				FROM tblProductionPortrait
				WHERE status=1
				ORDER BY regDate DESC
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function getInfoOfProductionPortrait(){
			$ppNo=$this->req["ppNo"];
			
			$sql="
				SELECT *
				FROM tblProductionPortrait
				WHERE ppNo='{$ppNo}'
				LIMIT 0, 1
			";
		}
		
		
		
	} // 클래스 종료
}
?>