<? include $_SERVER["DOCUMENT_ROOT"] . "/common/classes/ApiBase.php" ;?>
<?
if (! class_exists("ApiStatic")){
	class ApiStatic extends ApiBase{
		
		function __construct($req)
		{
			parent::__construct($req);
		}
		
		//회사소개
		function getKCSpecialVehicleInfo(){
			$sql="
				SELECT *
				FROM tblKCSpecialVehicleInfo
				ORDER BY infoNo DESC
				LIMIT 1
			";
			$payload = $this->getRow($sql);
			return $this->makeResultJson("1", "", $payload);
		}
		
		//기관인증
		function getOrganizationCert(){
			$sql="
				SELECT *
				FROM tblOrganizationCert
				ORDER BY certNo DESC
			";
			$list=$this->getArray($sql);
			return $this->makeResultJson("1", "", $list);
		}
		
		function getMainImage(){
			$sql="
				SELECT imgPathMain, imgPathBuiltIn, imgPathInsulation, imgPathFreezerV, imgPathSpecial, imgPathPowerGate, imgPathWingBody, imgPathFreezerC
				FROM tblMain
				LIMIT 1
			";
			$result=$this->getRow($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function getMainPhrase(){
			$sql="
				SELECT phrase1, phrase2
				FROM tblMain
				LIMIT 1
			";
		}
		
		//메인페이지 공지사항
		function getLatestNotice(){
			$sql="
				SELECT title
				FROM tblNotice
				ORDER BY noticeNo DESC
				LIMIT 1
			";
			$result=$this->getRow($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		//메인페이지 이벤트
		function getLatestEvent(){
			$sql="
				SELECT title
				FROM tblEvent
				ORDER BY eventNo DESC
				LIMIT 1
			";
			$result=$this->getRow($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function getKCBriefInfo(){
			$sql="
				SELECT address, telephone, fax, eMail
				FROM tblKCSpecialVehicleInfo
			";
		}
		
		function getListOfVehicle(){
			$vehicleType=$this->req["vehicleType"];
			
			$sql="
				SELECT name, imgPathVehicle
				FROM tblVehicle
				WHERE vehicleType='{$vehicleType}' AND status=1
				ORDER BY regDate DESC
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function getInfoOfVehicle(){
			$vehicleNo=$this->req["vehicleNo"];
			
			$sql="
				SELECT *
				FROM tblVehicle
				WHERE vehicleNo='{$vehicleNo}'
			";
			$reusult=$this->getRow($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function getListOfProvince(){
			$sql="
				SELECT `provinceNumber`, `desc`, `abbreviation`
				FROM tblZipProvince
				ORDER BY provinceNumber ASC
			";	
			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
		}
		
		function getListOfCity(){
			$provinceNumber=$this->req["provinceNumber"];
			
			$sql="
				SELECT `cityNumber`, `desc`, `abbreviation`
				FROM tblZipCity
				ORDER BY cityNumber ASC
			";
			$result=$this->getArray($sql);
			return $this->makeResultJson("1", "", $result);
		}
		

	}
}

?>