Add support to return sugggested shipping method

[dixitdeepak]

Evaluate Shipping Method and Transit Time to Suggest Appropriate Shipping Method:

• Condition 1 (STANDARD):
  • If smt.PARENT_TYPE_ID is 'STANDARD' or smt.SHIPMENT_METHOD_TYPE_ID is 'STANDARD' and cpcm.GROUND_TRANSIT_TIME is less than or equal to 8 days, the suggested shipping method will be STANDARD.
• Condition 2 (NEXT_DAY <= 1):
  • If smt.PARENT_TYPE_ID is 'NEXT_DAY' or smt.SHIPMENT_METHOD_TYPE_ID is 'NEXT_DAY' and cpcm.GROUND_TRANSIT_TIME is less than or equal to 1 day, the suggested shipping method will be STANDARD.
• Condition 3 (NEXT_DAY > 1):
  • If smt.PARENT_TYPE_ID is 'NEXT_DAY' or smt.SHIPMENT_METHOD_TYPE_ID is 'NEXT_DAY' and cpcm.GROUND_TRANSIT_TIME is greater than 1 day, the suggested shipping method will be NEXT_DAY.
• Condition 4 (SECOND_DAY <= 2):
  • If smt.PARENT_TYPE_ID is 'SECOND_DAY' or smt.SHIPMENT_METHOD_TYPE_ID is 'SECOND_DAY' and cpcm.GROUND_TRANSIT_TIME is less than or equal to 2 days, the suggested shipping method will be STANDARD.
• Condition 5 (SECOND_DAY > 2):
  • If smt.PARENT_TYPE_ID is 'SECOND_DAY' or smt.SHIPMENT_METHOD_TYPE_ID is 'SECOND_DAY' and cpcm.GROUND_TRANSIT_TIME is greater than 2 days, the suggested shipping method will be SECOND_DAY.
• Condition 6 (THIRD_DAY <= 3):
  • If smt.PARENT_TYPE_ID is 'THIRD_DAY' or smt.SHIPMENT_METHOD_TYPE_ID is 'THIRD_DAY' and cpcm.GROUND_TRANSIT_TIME is less than or equal to 3 days, the suggested shipping method will be STANDARD.
• Condition 7 (THIRD_DAY > 3):
  • If smt.PARENT_TYPE_ID is 'THIRD_DAY' or smt.SHIPMENT_METHOD_TYPE_ID is 'THIRD_DAY' and cpcm.GROUND_TRANSIT_TIME is greater than 3 days, the suggested shipping method will be THIRD_DAY.
• Output:
  The final suggested shipping method (suggested_ship_method) will be one of STANDARD, NEXT_DAY, SECOND_DAY, or THIRD_DAY based on the above conditions.