Uploaded image for project: 'OSCAR'
  1. OSCAR
  2. OS-9117

Development & Unit testing :OS-7794 - Add Super Filter - Primary MOT

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Enabler
    • Resolution: Completed
    • Medium
    • None
    • None
    • IO
    • None

    Description

      Steps to complete:

      • add Primary MOT to Parameter drop down list
      • get Primary MOT opinions from the backend and show them in Value fields
      • add logic into filter

      Possible options:

      AIR
      OCEAN
      ROAD
      ROAD/OCEAN

      Work to be done:

      • Oscar-Web App
        • Update SuperSearch.component.html to support new parameters and values - done
        • Update PIRFilters.Entity - done
        • Add Primary MOT column into sr.config.ts alertIOColsDef (hidden by default) - done
        • add to selected filters - done
      • Oscar App
        • Update PIRFiltersLogic to add new filters:
          • Modify GetPIRFiltersMapper - done
          • Update PIRFilter entity model - done
          • Modify the WEB.SP02_001_SR_GetPIRFilters_OnDemand.sql SP to get values from the table: - all done
            • add view for fetching the data
            • modify the SP to get the data from the view
            • cannot complete this point without OS-11528
        • Update PIRFilters to support adding new user views: - all done
          • update Util.GeneratePIRFilter to pass the value
          • update GetUserViewFiltersMapper to get the values
          • Modify the WEB.SP02_015_SR_GetUserViewSettings_OnDemand SP to get the values
      • Microservices
        • Modify GeneratePIRFilter to reflect new filter - done
        • Update PIRFilter entiry model - done
        • Update GetAlertsMapper in PIRFilterRepository - done
        • Modify the WEB.SP02_002_SR_GetAlerts_OnDemand_IO SP to reflect new filters: - all done 
          • add extraction of value from XML
          • add the columne to tmp and result page
          • Add the select in both quesries for finished goods (SR_ALETRS table) and semifinihsed goods (SR_ALERTS_APIPD table)

      Changes for all the widgets:

      • Microservices
        • Modify all SPs which fetches data for widgets (eg. WEB.SP23_001_LAP_GetCOPalletConversionChart) in order to reflect new filter: - done
          • WEB.SP23_036_LAP-GenerateDynamicQueryResultWithXML and it updates below: 
            • WEB.SP23_001_LAP_GetCOPalletConversionChart
            • WEB.SP23_002_LAP_GetCOWithoutPalletConversionChart
            • WEB.SP23_003_LAP_GetMDOPalletConversionChart
            • WEB.SP23_005_LAP_GetMOPalletBasedOnMOTChart
            • WEB.SP23_006_LAP_GetMOTopLanesByPalletsChart
            • web.SP23_016_LAP_GetNodalCapacityPlanChart
            • WEB.SP23_023_LAP_GetNodalCapacityDetail
            • web.SP23_015_LAP_GetTCLExceptionChart
            • WEB.SP23_024_LAP_GetTCLExceptionDetail
            • web.SP23_034_LAP_GetRoutingInfo
            • web.SP23_031_LAP_GetContactInfo
            • web.SP23_017_LAP_GetRoutingExceptionChart
            • WEB.SP23_025_LAP_GetRoutingExceptionDetail

      Attachments

        Issue Links

          Activity

            People

              kisiea02 kisiea02
              KHANS167 Khan, Sufiya
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 3 days Original Estimate - 3 days
                  3d
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 days, 3 hours
                  3d 3h