pears.NetClientCurrentRequirement

CREATE PROCEDURE "pears"."NetClientCurrentRequirement"( IN "pWebUserID" CHAR(20) ) 
RESULT( "RowID" CHAR(20),"StartDate" CHAR(20),"CombinedTime" CHAR(20),"IsShift" SMALLINT,"Position" CHAR(50),"ShiftDescription" CHAR(50),
  "CompanyName" CHAR(60),"ContactName" CHAR(60),"Consultant" CHAR(60),"OurRef" CHAR(20),"ContractRef" CHAR(20),"ShiftRef" CHAR(20),
  "FilledBy" CHAR(250),"StartTime" CHAR(15),"FinishTime" CHAR(15),
  "FinishDate" CHAR(30),"LongDescription" long VARCHAR,"PersonID" CHAR(20),
  "TextStatus" CHAR(100),"CreatedBy" CHAR(255),"CancelState" CHAR(50),"ReqDescription" CHAR(10),"ClientNote" CHAR(50),
  "VacancyNotes" long VARCHAR,"TextStatusFull" CHAR(100) ) 
BEGIN
  SELECT *
    FROM "NetClientRequirementList"("pWebUserID" = 
      "pWebUserID","pSlice" = 
      0,"pSliceSize" = 
      20,"pStartDate" = 
      "dateformat"(CURRENT date-7,'dd/mm/yyyy'),"pEndDate" = 
      "dateformat"(CURRENT DATE,'dd/mm/yyyy'))
    ORDER BY "StartDate" ASC
END /* DOC
2017-05-18 PC Doc
2017-07-13 PC modified date format
2018-05-30 PC IW-588 add liststatus and detailstatus columns
2018-06-06 MHS changed result set to match NetClientRequirementList, sorted 
date format, reduced slice to 20. But this produced odd results, perhaps because
of reversing the sort order so this function is NOT currently in use:
NetClientRequirementList is called directly by the client home page.  
 
 
Wrapper for NetClientRequirementList. Takes a short sample of current requirements for a dashboard widget.
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientCurrentRequirement" IS 
{CREATE PROCEDURE pears."NetClientCurrentRequirement"(pWebUserID CHAR(20))
RESULT( RowID CHAR(20),StartDate CHAR(20),CombinedTime CHAR(20),IsShift SMALLINT,POSITION CHAR(50),ShiftDescription CHAR(50),
CompanyName CHAR(60),ContactName CHAR(60),Consultant CHAR(60),OurRef CHAR(20),ContractRef CHAR(20),ShiftRef CHAR(20),
FilledBy CHAR(250),StartTime CHAR(15),FinishTime CHAR(15),
FinishDate CHAR(30),LongDescription long VARCHAR, PersonID CHAR(20),
TextStatus CHAR(100),CreatedBy CHAR(255),CancelState CHAR(50), ReqDescription CHAR(10), ClientNote CHAR(50),
 VacancyNotes Long VARCHAR, TextStatusFull CHAR(100) )
BEGIN
    SELECT *
    FROM 
    "NetClientRequirementList"(
        "pWebUserID" = pWebUserID,
        "pSlice" = 0,
        "pSliceSize" = 20,
        "pStartDate" = dateformat(CURRENT date-7, 'dd/mm/yyyy'),
        "pEndDate" = dateformat(CURRENT DATE, 'dd/mm/yyyy')
    )
    ORDER BY
        StartDate ASC
END
 
/* DOC
2017-05-18 PC Doc
2017-07-13 PC modified date format
2018-05-30 PC IW-588 add liststatus and detailstatus columns
2018-06-06 MHS changed result set to match NetClientRequirementList, sorted 
  date format, reduced slice to 20. But this produced odd results, perhaps because
  of reversing the sort order so this function is NOT currently in use:
  NetClientRequirementList is called directly by the client home page.  
 
 
Wrapper for NetClientRequirementList. Takes a short sample of current requirements for a dashboard widget.
 
*/
}