# Foodman Slotting Release

## Foodman Slotting
- core:
- migration
- public.core_user
- public.order_ordermeta
- oms.currency_settings

		     ALTER TABLE "oms"."currency_settings" ADD COLUMN "slotting_commission_rate" jsonb;

- image: harbor.pathaointernal.com/food/core:4.24.0
- dispatcher:
- pr: https://magic.pathao.com/food/dispatcher-v2/-/merge_requests/55
- consul

	   app:
  	     city_wise_dispatch:
		    3:
	          order_accept_timeout: 20 # secs

- migrations:
- order_details table
- image: harbor.pathaointernal.com/food/dispatcher-v2:2.4.0
- queue
- image: harbor.pathaointernal.com/food/queue:3.12.0
- registry:
- release branch: https://magic.pathao.com/food/aam-jonota/-/tree/release/1.0.5
- aam jonota:
- release branch: https://magic.pathao.com/food/aam-jonota/-/tree/release/1.0.5
- karagar:
- release branch: https://magic.pathao.com/food/karagar/-/tree/release/1.0.0
- setup consul configurations
- Create esb listner creds secret
- Run db migrations
- Create db trigger functions
- Creat views
- Create driver category
- `INSERT INTO "driver_category" ("id", "name") VALUES (1, 'A');`
- Create zone and subzones [shudipta]
- Create kong mapping
- Add food minio expiration date karagar bucket: mc ilm add --expiry-days 30 stage/karagar
- event table clean up script

- kong mapping:

    GET "/api/v1/users/\S+/zones" GetZonesByCityID
    GET "/api/v1/users/\S+/zones/\S+" GetZone
    GET "/api/v1/users/\S+/zones/\S+/subzones" GetSubzonesByZoneID
    GET "/api/v1/users/\S+/subzones/\S+" GetSubzone


    GET "/api/v1/users/\S+/time-slots/today" GetDriversTodaysTimeSlots	

    GET "/api/v1/users/\S+/time-slots/\S+/stats" GetDriverTimeSlotDetails

    POST "/api/v1/users/\S+/time-slots/\S+/issue-report" TimeSlotIssueReport

    GET "/api/v1/users/\S+/booked/time-slots" ListDriverBookedTimeSlots

    POST "/api/v1/users/\S+/time-slots" RequestTimeSlotBooking

    GET "/api/v1/users/\S+/subzones/\S+/time-slots" GetDriverAllocableTimeSlots