pears.GetWorkPatternWeeklyHours

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."GetWorkPatternWeeklyHours" IS 
{CREATE FUNCTION GetWorkPatternWeeklyHours 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN placid CHAR(20), IN pstartdate DATE, IN penddate DATE)
RETURNS DOUBLE
BEGIN
DECLARE Absense  INTEGER;
DECLARE Hours  DOUBLE;
DECLARE Days  INTEGER;
DECLARE WeekHours  DOUBLE;
SELECT
(SELECT COUNT(state) FROM TempShift WHERE shiftdate BETWEEN pStartDate AND pEndDate AND tempshift.state IN ('H','U') AND tempshift.personid = employment.personid) AS Absense,
Placement.WorkNormalHours AS Hours,
(isnull(Placement.WorkMonday,0) +
isnull(Placement.WorkTuesday,0) +
isnull(Placement.WorkWednesday,0) +
isnull(Placement.WorkThursday,0) +
isnull(Placement.WorkFriday,0) +
isnull(Placement.WorkSaturday,0) +
isnull(Placement.WorkSunday,0) )  - Absense AS Days,
(IF Days > 0 THEN Days * Hours ELSE 0 endif) AS WeekHours
INTO Absense, Hours, Days, WeekHours
FROM placement KEY JOIN employment WHERE placementid = placid;
RETURN isnull(weekhours,0);
END
}