meetchandan

# RO: Replenishment Order
class RO:
  id_ro int
  ro_nr string uq
  wh_code
  po_nr
  status # pending_approval, approved, rejected, cancelled, sent_to_vendor (should design allowed status transitions)
  created_by
  updated_by
  

meetchandan

{
  "canCancel": false,
  "cancelationReasons": [
    {
      "code": "cust_bought_by_mistake",
      "desc": "Bought by mistake"
    },
    {
      "code": "cust_changed_mind",
      "desc": "Change of mind"

meetchandan

WITH base AS (
            SELECT
                id_partner,
                pbarcode_canonical,
                psku_code,
                LOWER(country_code) AS country_code,
                qty,
                allocated_unit_cost_lcy
            FROM
                `noonbicedata.cogs_v3.txlog_cogs_output`

meetchandan

insert into instant_order.instant_event(action_code, data, is_processed, schedule_at, backoff_config)
values
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECAH165R5NBKQ2WA"}', 0, current_timestamp(), '{}'),
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECBD1479PN9MYQ1A"}', 0, current_timestamp(), '{}'),
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECB91478321I4PRA"}', 0, current_timestamp(), '{}'),
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECAF146VRG5G6EYA"}', 0, current_timestamp(), '{}'),
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECAB3919TAMOKFNA"}', 0, current_timestamp(), '{}'),
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECAD166QS6301UCA"}', 0, current_timestamp(), '{}'),
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECAB391ZDXHDYV0A"}', 0, current_timestamp(), '{}'),
('CALCULATE_ADJUSTMENTS', '{"order_nr": "IAECB5124FPHO69NUA"}', 0, current_timestamp(), '{}'),

meetchandan

// the below we will have to store in offer or offer stock table - a new column modifiers
[
   {
    "modifier_group_code" : "group",
    "name_en": "name en",
    "name_ar": "name ar",
    "min": 1,
    "max": 10,
    "modifiers": [
      {

meetchandan

{"mainVideos":[{"id":"1683033798231","title":"Match Stream: GT v DC, Tata IPL 2023, Match 44","timestamp":"1683033798231","imageUrl":"https://a.nooncdn.com/cms/pages/20230405/c3f185a35a6964f0b0e9be794d0fdc15/IPL_match-44.png","videoUrl":"https://livestream.noon.com/hls/live/2098770/66320/master.m3u8","adTag":null,"durationStr":null,"videoType":"MatchStream","matchId":"66320","isLive":true,"isFree":false,"assetKey":null},{"id":"1683035356179","title":"GT vs DC, 44th Match, TOSS","timestamp":"1683035356179","imageUrl":"https://livestream.noon.com/hls/vods/5945/66320/GT_DC_02-05-2023_T20_TOSS/thumbnail.jpg","videoUrl":"https://livestream.noon.com/hls/vods/5945/66320/GT_DC_02-05-2023_T20_TOSS/master.m3u8","adTag":"https://pubads.g.doubleclick.net/gampad/live/ads?iu=/22809011232/noon_vod_uae&description_url=https%3A%2F%2Fnoon.com&tfcd=0&npa=0&sz=640x480&pp=noon_dai_IPL_profile&gdfp_req=1&output=vast&unviewed_position_start=1&env=vp&impl=s&correlator=&vad_type=linear&ad_rule=0&vpos=preroll&max_ad_duration=20000&vpa

meetchandan

I1-M1-2
I2-M2-1

/set-qty 
{
"item_code": "I2",
"modifiers": "M1",
"qty": 2
}
I1-M1-4

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAED8C123FHFCVNSDA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::ae::iaed8c123fhfcvnsda-1",
      "entity_to": "entity::customer_address::ae::6312c7c3af7767f479cb3dbb6930ee54::2",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAED8F123CA975JZKA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::ae::9411",
      "entity_to": "entity::customer_address::ae::6312c7c3af7767f479cb3dbb6930ee54::2",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAED9A1514PEB0IOSA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::ae::16527",
      "entity_to": "entity::customer_address::ae::6064d15bfeeb21b168495aca706a32c9::4",