Select a vacation from the list below to see the detail for the vacation and explore other options or
Click on New Vacation to add a new vacation to your possibilities.
';
ExecuteSQL(~create temporary table a as (select CaseID, rInstance from Responses where qID='CaseType' and rValue='M' and isDeleted=0) ~);
ExecuteSQL(~create temporary table b as (select CaseID, rValue as Description from Responses where qID='CaseFirstName' and isDeleted=0) ~);
echo '
';
ShowQueryResult(~select distinct concat('') as Vacation, concat(' ') as Del from a,b where b.CaseID=a.CaseID order by Description DESC~);
echo ~
$UserId=$_SESSION['UserId'];
$CaseId=str_replace(' ','',ShowQueryResultScalar(~select concat(UserId,'-vac-',NOW()) as CaseId from Users where UserId='$UserId'~));
$Instance=ShowQueryResultScalar(~select rUnique from Responses where CaseID='$CaseId'~);
if ($Instance==~~)
{
ExecuteSQL(~insert into Responses (CaseID,qID,rValue,uID,rInstance,ProjectId) select '$CaseId','CaseID','$CaseId','$UserId','1','~.$_SESSION['ProjectId'].~'~);
ExecuteSQL(~insert into Responses (CaseID,qID,rValue,uID,rInstance,ProjectId) select '$CaseId','CaseType','M','$UserId','1','~.$_SESSION['ProjectId'].~'~);
$Instance=1;
}
$_SESSION['Instance']=$Instance;
$_SESSION['CaseId']=$CaseId;
SetForm('MV_Options');
$stat=1;