<?

//=========================================//
function  cardetail($carFrameNo){


$cars="select * from CarList  where carFrameNo='$carFrameNo'  ";

//echo"$cars  ";
$excar=mssql_query($cars);
$rocar=mssql_fetch_array($excar);

$carId=$rocar["carId"];
$carFrameNo=trim($rocar["carFrameNo"]);
$carEngineNo=$rocar["carEngineNo"];
$carRegNo=trim($rocar["carRegNo"]);
$carBrandId=$rocar["carBrandId"];
					$checkbrand="select * from KeyCarBrand where keyId='$carBrandId' ";
					$exxbrand=mssql_query($checkbrand); $res=mssql_fetch_array($exxbrand);  $carBrandId=$res["keyValue"];

$carModelMajorId=$rocar["carModelMajorId"];
                    $checkModel="select * from KeyCarModelMajor where keyId='$carModelMajorId' ";
					$exxModel=mssql_query($checkModel); $reModel=mssql_fetch_array($exxModel);  $carModelMajorId=$reModel["keyValue"];
					
$carModelMinorId=$rocar["carModelMinorId"];
					$checkModelm="select * from KeyCarModelMinor where keyId='$carModelMinorId' ";
					$exxModelm=mssql_query($checkModelm); $reModelm=mssql_fetch_array($exxModelm);  $carModelMinorId=$reModelm["keyValue"];
					
$carFuelId=$rocar["carFuelId"];
					$checkFuel="select * from KeyCarFuel where keyId='$carFuelId' ";
					$exxFuel=mssql_query($checkFuel); $reFuel=mssql_fetch_array($exxFuel);  $carFuelId=$reFuel["keyValue"];
					
$carEngineSize=$rocar["carEngineSize"];
$carGearType=$rocar["carGearType"];
                   if($carGearType=='M'){ $carGearType="MANUAL";}
				    if($carGearType=='A'){ $carGearType="AUTOMATIC";}

$carColorId=$rocar["carColorId"];
					$check="select * from KeyCarColor where keyId='$carColorId' ";
					$exx=mssql_query($check); $res=mssql_fetch_array($exx);  $carColorId=$res["keyValue"];
					
$carDriveId=$rocar["carDriveId"];
					$check="select * from KeyCarDrive where keyId='$carDriveId' ";
					$exx=mssql_query($check); $res=mssql_fetch_array($exx);  $carDriveId=$res["keyValue"];
					
$carSeatCount=$rocar["carSeatCount"];


$carYear=$rocar["carYear"];
$carTypes=$rocar["carTypes"];

if($carTypes==1){$carTypes="รถเก๊ง";}
if($carTypes==2){$carTypes="รถกระบะ";}
if($carTypes==3){$carTypes="รถตู้";}
if($carTypes==4){$carTypes="รถSUV";}
if($carTypes==5){$carTypes="รถโดยสาร";}

$carTypeRent=$rocar["carTypeRent"];
$carTypeReg=$rocar["carTypeReg"];
$carFreeInsure=$rocar["carFreeInsure"];
$carPriceNoTax=$rocar["carPriceNoTax"];
$carPriceTax=$rocar["carPriceTax"];
$carPriceBody=$rocar["carPriceBody"];
$carAverage=$rocar["carAverage"];
$carRemark=$rocar["carRemark"];


$carEngineSizeDef=$rocar["carEngineSizeDef"];
$rubberBrand=$rocar["rubberBrand"];
$rubberModel=$rocar["rubberModel"];
$rubberF_L=$rocar["rubberF_L"];
$rubberF_R=$rocar["rubberF_R"];
$rubberB_L=$rocar["rubberB_L"];
$rubberB_R=$rocar["rubberB_R"];
$rubberReserve=$rocar["rubberReserve"];

$rubberF_L_Depth=$rocar["rubberF_L_Depth"];
$rubberF_R_Depth=$rocar["rubberF_R_Depth"];
$rubberB_L_Depth=$rocar["rubberB_L_Depth"];
$rubberB_R_Depth=$rocar["rubberB_R_Depth"];
$rubberReserve_Depth=$rocar["rubberReserve_Depth"];
$carModelId=$rocar["carModelId"];

$cpId=$rocar["cpId"];

$namecon="select  cpId,cpname_sub  from ContactPerson where cpId='$cpId' ";
$excon=mssql_query($namecon); $rocon=mssql_fetch_array($excon);
$cpname_sub=$rocon["cpname_sub"];


$carStatus=$rocar["carStatus"];

if($carStatus==1){$carStatus="Stock In";}
if($carStatus==2){$carStatus="กำลังส่ง่";}
if($carStatus==3){$carStatus="อยู่ที่ีลูกค้า่";}


$cardet="$carBrandId $carModelMajorId $carModelMinorId";


return $cardet;
}// end function cardetail
	
//============================//
function  cusNames($nameId){
	$showname="select * from serviceCenterCar where serviceCenId='$nameId' ";
	$esname=mssql_query($showname);
	$roname=mssql_fetch_array($esname);
	$serviceCenName=$roname["serviceCenName"];
	$serviceBranch=$roname["serviceBranch"];
	$naem="$serviceCenName  $serviceBranch";
	return $naem;
	}
//================================//
function signnumber($signId){

$signcus="select * from List_Sign where signId='$signId'  order by signId desc";
$exsign=mssql_query($signcus);
$rocusinsign=mssql_fetch_array($exsign);
$siSignId=$rocusinsign["siSignId"];

return $siSignId;
}


//================================//
function cusInsign($carFrameNo){
$signcar="select * from List_Car_Sign_In where clCarFrameNo='$carFrameNo' ";

$excarss=mssql_query($signcar);
$rosignid=mssql_fetch_array($excarss);
$signid=$rosignid["siId"];
//====================================//
$signcus="select * from List_Sign where signId='$signid'  order by signId desc";
$exsign=mssql_query($signcus);
$rocusinsign=mssql_fetch_array($exsign);
$siNameCus=$rocusinsign["siNameCus"];
//====================================//
	$showname="select * from serviceCenterCar where serviceCenId='$siNameCus' ";
	$esname=mssql_query($showname);
	$roname=mssql_fetch_array($esname);
	$serviceCenName=$roname["serviceCenName"];
	$serviceBranch=$roname["serviceBranch"];
	$naem="$serviceCenName  $serviceBranch";
	
	return $naem;
}	
//=======================================//
function singnNumberCar($carFrameNo){
$signcar="select * from List_Car_Sign_In where clCarFrameNo='$carFrameNo' ";

$excarss=mssql_query($signcar);
$rosignid=mssql_fetch_array($excarss);
$signid=$rosignid["siId"];
//====================================//
$signcus="select * from List_Sign where signId='$signid'  order by signId desc";
$exsign=mssql_query($signcus);
$rocusinsign=mssql_fetch_array($exsign);
$siSignId=$rocusinsign["siSignId"];

	
	return $siSignId;
}	



//=======================================//
function signEndDate($carFrame){

$signcar="select * from List_Car_Sign_In where clCarFrameNo='$carFrame' ";
$excarss=mssql_query($signcar);
$rosignid=mssql_fetch_array($excarss);
$signid=$rosignid["siId"];
//====================================//
$signcus="select * from List_Sign where signId='$signid'  order by signId desc";
$exsign=mssql_query($signcus);
$rocusinsign=mssql_fetch_array($exsign);
$siNameCus=$rocusinsign["siNameCus"];
$siDateEnd=$rocusinsign["siDateEnd"];

return  $siDateEnd;
}

//======================================//
function conmunth($m){
if($m==1){$munth="มกราคม";}
if($m==2){$munth="กุมภาพันธ์";}
if($m==3){$munth="มีนาคม";}
if($m==4){$munth="เมษายน";}
if($m==5){$munth="พฤษภาคม";}
if($m==6){$munth="มิถุนายน";}
if($m==7){$munth="กรกฏาคม";}
if($m==8){$munth="สิงหาคม";}
if($m==9){$munth="กันยายน";}
if($m==10){$munth="ตุราคม";}
if($m==11){$munth="พฤศจิกายน";}
if($m==12){$munth="ธันวาคม";}

return  $munth ;

}
//======================//
function conyear($y){
$Yth=$y+543;

return  $Yth;
}

//=======================//
function carpark($carFrameNo){

$carpark="select * from Car_Send_Recive where carFramNo='$carFrameNo' ";
$expark=mssql_query($carpark);
$ropark=mssql_fetch_array($expark);
$endContactArea=$ropark["endContactArea"];

return  $endContactArea;
}
//==============refresh page===============//
function refreshPage(){
return (
    echo "<script language=\"JavaScript\">";
	echo JS::RefreshOpener(1);
    //echo JS::WinClose();
    echo "</script>";
);

}

?>