pears.NetReportTimesheetLines

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL

CREATE PROCEDURE "pears"."NetReportTimesheetLines"( IN "pWebUserID" CHAR(20),IN "pTimesheetID" CHAR(20) ) 
RESULT( "Pay_Type" CHAR(100),"Unit" CHAR(100),"Units__R" DOUBLE,"Rate__MR" DOUBLE,"Total__MR" DOUBLE ) 
BEGIN
  DECLARE "userClass" CHAR(20);
  SET "userClass" = (SELECT FIRST "iqxnetuserclassid" FROM "iqxnetuser" WHERE "iqxnetuserid" = "pWebUserID");
  SELECT "b"."description",
    "b"."unit",
    (IF "userclass" = 'CLIENT' THEN "l"."unitscharged" ELSE "l"."unitspaid" endif),
    (IF "userclass" = 'CLIENT' THEN "l"."chargerate" ELSE "l"."payrate" endif),
    (IF "userclass" = 'CLIENT' THEN "l"."unitscharged"*"l"."chargerate" ELSE "l"."unitspaid"*"l"."payrate" endif)
    FROM "temptimesheetline" AS "l" KEY JOIN "temppayband" AS "b"
    WHERE "l"."temptimesheetid" = "pTimesheetID"
    ORDER BY "b"."sortorder" ASC,"b"."description" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetReportTimesheetLines" IS 
{CREATE PROCEDURE pears.NetReportTimesheetLines(IN pWebUserID CHAR(20),IN pTimesheetID CHAR(20))
RESULT(Pay_Type CHAR(100),Unit CHAR(100),Units__R DOUBLE,Rate__MR DOUBLE,Total__MR DOUBLE)
BEGIN
  DECLARE userClass CHAR(20);
  SET userClass=(SELECT FIRST iqxnetuserclassid FROM iqxnetuser WHERE iqxnetuserid = pWebUserID);
  SELECT b.description,
    b.unit,
    (IF userclass = 'CLIENT' THEN l.unitscharged ELSE l.unitspaid
    endif),(IF userclass = 'CLIENT' THEN l.chargerate ELSE l.payrate
    endif),(IF userclass = 'CLIENT' THEN l.unitscharged*l.chargerate ELSE l.unitspaid*l.payrate
    endif) FROM temptimesheetline AS l KEY JOIN temppayband AS b
    WHERE l.temptimesheetid = pTimesheetID ORDER BY
    b.sortorder ASC,b.description ASC
END
}