pears.NetReportProvTimesheetLines

CREATE PROCEDURE "pears"."NetReportProvTimesheetLines"( IN "pWebUserID" CHAR(20),IN "pProvTimesheetID" CHAR(20) ) 
RESULT( "Pay_Type" CHAR(100),"Unit" CHAR(100),"Units__R" DOUBLE,"Rate__MR" DOUBLE,"Total__MR" DOUBLE ) 
-- 20121003 NetReportTimesheets modified for Current timesheets
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 "tempprovtimesheetline" AS "l" KEY JOIN "temppayband" AS "b"
    WHERE "l"."tempprovtimesheetid" = "pProvTimesheetID"
    ORDER BY "b"."sortorder" ASC,"b"."description" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetReportProvTimesheetLines" IS 
{CREATE PROCEDURE pears."NetReportProvTimesheetLines"( IN "pWebUserID" CHAR(20),IN "pProvTimesheetID" CHAR(20) ) 
RESULT( "Pay_Type" CHAR(100),"Unit" CHAR(100),"Units__R" DOUBLE,"Rate__MR" DOUBLE,"Total__MR" DOUBLE ) 
-- 20121003 NetReportTimesheets modified for Current timesheets
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 "tempprovtimesheetline" AS "l" KEY JOIN "temppayband" AS "b"
    WHERE "l"."tempprovtimesheetid" = "pProvTimesheetID"
    ORDER BY "b"."sortorder" ASC,"b"."description" ASC
END
}