pears.NetTimesheetHeader

CREATE PROCEDURE "pears"."NetTimesheetHeader"( IN "pWebUserID" CHAR(20),IN "pTempTimesheetID" CHAR(20) ) 
RESULT( "temptimesheetid" CHAR(20),"serialnumber" CHAR(20),"tempname" CHAR(60),"position" CHAR(60),"companyname" CHAR(60),"weekenddate" DATE,"timesheettype" CHAR(1),"timesheettotal" DOUBLE ) 
BEGIN
  SELECT "s"."tempshiftid","s"."shiftdate","s"."timefrom","s"."timeto","s"."breakminutes",
    "p"."description","weekmonthenddate"("t"."period","t"."periodlength") AS "weekenddate"
    FROM "tempshift" AS "s" KEY JOIN "temptimesheet" AS "t"
      ,"tempshift" AS "s" KEY LEFT OUTER JOIN "tempshiftplan" AS "p"
      ,"temptimesheet" AS "t" KEY JOIN "person"
    WHERE "t"."temptimesheetid" = "pTempTimesheetID"
    AND "s"."shiftdate" BETWEEN "weekenddate"-6 AND "weekenddate"
    ORDER BY "s"."shiftdate" ASC,"s"."timefrom" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetTimesheetHeader" IS 
{CREATE PROCEDURE pears."NetTimesheetHeader"( IN "pWebUserID" CHAR(20),IN "pTempTimesheetID" CHAR(20) ) 
RESULT( "temptimesheetid" CHAR(20),"serialnumber" CHAR(20),"tempname" CHAR(60),"position" CHAR(60),"companyname" CHAR(60),"weekenddate" DATE,"timesheettype" CHAR(1),"timesheettotal" DOUBLE ) 
BEGIN
  SELECT "s"."tempshiftid","s"."shiftdate","s"."timefrom","s"."timeto","s"."breakminutes",
    "p"."description","weekmonthenddate"("t"."period","t"."periodlength") AS "weekenddate"
    FROM "tempshift" AS "s" KEY JOIN "temptimesheet" AS "t"
      ,"tempshift" AS "s" KEY LEFT OUTER JOIN "tempshiftplan" AS "p"
      ,"temptimesheet" AS "t" KEY JOIN "person"
    WHERE "t"."temptimesheetid" = "pTempTimesheetID"
    AND "s"."shiftdate" BETWEEN "weekenddate"-6 AND "weekenddate"
    ORDER BY "s"."shiftdate" ASC,"s"."timefrom" ASC
END
}