pears.NetCandidateShifts

CREATE PROCEDURE "pears"."NetCandidateShifts"( IN "pWebUserID" CHAR(20),IN "pPersonID" CHAR(20) ) 
RESULT( "TempShiftPlanID" CHAR(20),"ShiftDate" DATE,"TimeFrom" TIME,"TimeTo" CHAR(20),"Description" CHAR(250),"Location" CHAR(100) ) 
BEGIN
  SET "pPersonID" = "NetCandidateValidPersonID"("pWebUserID","pPersonID");
  SELECT "p"."tempshiftplanid","p"."shiftdate","p"."timefrom","p"."timeto","string"("vacancy"."position",' - ',"p"."description"),"isnull"("vacancy"."town","company"."town")
    FROM "IQXNetCandidateShifts" AS "x" KEY JOIN "tempshiftplan" AS "p" KEY JOIN "vacancy" KEY JOIN "employment" KEY JOIN "company"
    WHERE "x"."personid" = "pPersonID"
    ORDER BY "shiftdate" ASC,"timefrom" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateShifts" IS 
{CREATE PROCEDURE pears."NetCandidateShifts"(IN pWebUserID CHAR(20), pPersonID CHAR(20) )
RESULT(TempShiftPlanID CHAR(20), ShiftDate DATE, TimeFrom TIME, TimeTo CHAR(20), Description CHAR(250), Location CHAR(100) )
BEGIN
SET pPersonID=NetCandidateValidPersonID(pWebUserID, pPersonID);
 
SELECT p.tempshiftplanid, p.shiftdate, p.timefrom, p.timeto, string(vacancy.position, ' - ', p.description), isnull(vacancy.town,company.town)
  FROM IQXNetCandidateShifts x KEY JOIN tempshiftplan p KEY JOIN vacancy KEY JOIN employment KEY JOIN company
  WHERE x.personid=pPersonID
  ORDER BY shiftdate,timefrom;
 
END
}