POST api/Orders/Postt_clone

Request Information

URI Parameters

None.

Body Parameters

CloneOrder
NameDescriptionTypeAdditional information
id

integer

None.

dos

date

None.

tos

time interval

None.

vendorid

integer

None.

createby

string

None.

pon

string

None.

Request Formats

application/json, text/json

Sample:
{
  "id": 1,
  "dos": "2025-12-31T01:34:30.9388377+00:00",
  "tos": "00:00:00.1234567",
  "vendorid": 2,
  "createby": "sample string 3",
  "pon": "sample string 4"
}

Response Information

Resource Description

t_orders
NameDescriptionTypeAdditional information
id

integer

None.

user_id

integer

None.

dor

date

None.

dos

date

None.

tos

time interval

None.

type

string

None.

origin

string

None.

address_id

integer

None.

dod

date

None.

customersign

string

None.

deliveredby

string

None.

feedback

string

None.

emailsent

boolean

None.

vendorid

integer

None.

createby

string

None.

token

string

None.

customer_notes

string

None.

delivery_notes

string

None.

driver_instructions

string

None.

status

string

None.

routeid

integer

None.

staff_id

integer

None.

public_id

string

None.

pon

string

None.

ackby

string

None.

dept

string

None.

qbrefno

string

None.

building

string

None.

floor_room

string

None.

point_of_contact

string

None.

standing_order

boolean

None.

notify_user

boolean

None.

standing_days

string

None.

qbsynctime

date

None.

discount_type

string

None.

discount

decimal number

None.

seq

integer

None.

eos

time interval

None.

guest_email

string

None.

guest_phone

string

None.

guest_name

string

None.

tbl_id

integer

None.

t_order_files

Collection of t_order_files

None.

t_order_timings

Collection of t_order_timings

None.

t_orderentry

Collection of t_orderentry

None.

t_routes

t_routes

None.

t_staffs

t_staffs

None.

t_user_addresss

t_user_addresss

None.

t_users

t_users

None.

t_vendors

t_vendors

None.

t_user_payments

Collection of t_user_payments

None.

t_tables

t_tables

None.

Response Formats

application/json, text/json

Sample:
{
  "id": 1,
  "user_id": 1,
  "dor": "2025-12-31T01:34:30.9388377+00:00",
  "dos": "2025-12-31T01:34:30.9388377+00:00",
  "tos": "00:00:00.1234567",
  "type": "sample string 2",
  "origin": "sample string 3",
  "address_id": 1,
  "dod": "2025-12-31T01:34:30.9388377+00:00",
  "customersign": "sample string 4",
  "deliveredby": "sample string 5",
  "feedback": "sample string 6",
  "emailsent": true,
  "vendorid": 7,
  "createby": "sample string 8",
  "token": "sample string 9",
  "customer_notes": "sample string 10",
  "delivery_notes": "sample string 11",
  "driver_instructions": "sample string 12",
  "status": "sample string 13",
  "routeid": 1,
  "staff_id": 1,
  "public_id": "sample string 14",
  "pon": "sample string 15",
  "ackby": "sample string 16",
  "dept": "sample string 17",
  "qbrefno": "sample string 18",
  "building": "sample string 19",
  "floor_room": "sample string 20",
  "point_of_contact": "sample string 21",
  "standing_order": true,
  "notify_user": true,
  "standing_days": "sample string 22",
  "qbsynctime": "2025-12-31T01:34:30.9388377+00:00",
  "discount_type": "sample string 23",
  "discount": 1.0,
  "seq": 24,
  "eos": "00:00:00.1234567",
  "guest_email": "sample string 25",
  "guest_phone": "sample string 26",
  "guest_name": "sample string 27",
  "tbl_id": 1,
  "t_order_files": [
    {
      "$id": "2",
      "id": 1,
      "order_id": 1,
      "file_name": "sample string 2",
      "createby": "sample string 3",
      "createdate": "2025-12-31T01:34:30.9388377+00:00",
      "type": "sample string 4",
      "t_orders": {
        "$ref": "1"
      }
    },
    {
      "$ref": "2"
    }
  ],
  "t_order_timings": [
    {
      "$id": "3",
      "id": 1,
      "order_id": 2,
      "status": "sample string 3",
      "created_at": "2025-12-31T01:34:30.9388377+00:00",
      "updated_at": "2025-12-31T01:34:30.9388377+00:00",
      "createby": "sample string 4",
      "t_orders": {
        "$ref": "1"
      }
    },
    {
      "$ref": "3"
    }
  ],
  "t_orderentry": [
    {
      "$id": "4",
      "id": 1,
      "itemid": 1,
      "description": "sample string 2",
      "qty": 1.0,
      "qtydelivered": 1.0,
      "price": 1.0,
      "orderid": 1,
      "pic": "sample string 3",
      "notes": "sample string 4",
      "discount": 5.0,
      "uom": "sample string 6",
      "category": "sample string 7",
      "subcategory": "sample string 8",
      "t_items": {
        "$id": "5",
        "id": 1,
        "vendorid": 2,
        "ilc": "sample string 3",
        "name": "sample string 4",
        "description": "sample string 5",
        "ingredients": "sample string 6",
        "size_tag": "sample string 7",
        "alias": "sample string 8",
        "pic": "sample string 9",
        "cost": 1.0,
        "price": 1.0,
        "frontpage": true,
        "displayorder": 1,
        "categoryid": 1,
        "subcategoryid": 1,
        "type": "sample string 10",
        "minorderqty": 1,
        "maxorderqty": 1,
        "status": "sample string 11",
        "createby": "sample string 12",
        "createdate": "2025-12-31T01:34:30.9388377+00:00",
        "discount": 13.0,
        "apply_discount": true,
        "order_cutoff_time": "00:00:00.1234567",
        "qb_code": "sample string 14",
        "qb_account": "sample string 15",
        "uom": "sample string 16",
        "tv_code": "sample string 17",
        "seq": 18,
        "qb_class": "sample string 19",
        "sides": true,
        "max_sides": 20,
        "routeid": 1,
        "inventory": true,
        "minqty": 22.0,
        "maxqty": 23.0,
        "reorderqty": 24.0,
        "pref": 25,
        "tpcode": "sample string 26",
        "t_carts": [
          {
            "$id": "6",
            "id": 1,
            "cartid": "sample string 2",
            "itemid": 3,
            "description": "sample string 4",
            "qty": 5.0,
            "price": 6.0,
            "pic": "sample string 7",
            "notes": "sample string 8",
            "discount": 9.0,
            "vendorid": 1,
            "datecreated": "2025-12-31T01:34:30.9388377+00:00",
            "saveforlater": true,
            "scheduledate": "2025-12-31T01:34:30.9388377+00:00",
            "t_items": {
              "$ref": "5"
            },
            "t_cart_addons": [
              {
                "$id": "7",
                "id": 1,
                "cart_id": 2,
                "item_addon_id": 3,
                "price": 4.0,
                "notes": "sample string 5",
                "created_at": "2025-12-31T01:34:30.9388377+00:00",
                "updated_at": "2025-12-31T01:34:30.9388377+00:00",
                "deleted_at": "2025-12-31T01:34:30.9388377+00:00",
                "qty": 1,
                "t_carts": {
                  "$ref": "6"
                },
                "t_item_addons": {
                  "$id": "8",
                  "id": 1,
                  "main_item_id": 2,
                  "item_id": 3,
                  "price": 1.0,
                  "maxallowed": 1,
                  "minallowed": 1,
                  "active": true,
                  "pos_only": true,
                  "t_items": {
                    "$ref": "5"
                  },
                  "t_items1": {
                    "$ref": "5"
                  },
                  "t_order_addons": [
                    {
                      "$id": "9",
                      "id": 1,
                      "order_entry_id": 2,
                      "item_addon_id": 3,
                      "description": "sample string 4",
                      "quantity": 5,
                      "price": 6.0,
                      "notes": "sample string 7",
                      "created_at": "2025-12-31T01:34:30.9388377+00:00",
                      "updated_at": "2025-12-31T01:34:30.9388377+00:00",
                      "deleted_at": "2025-12-31T01:34:30.9388377+00:00",
                      "uom": "sample string 8",
                      "t_orderentry": {
                        "$ref": "4"
                      },
                      "t_item_addons": {
                        "$ref": "8"
                      }
                    },
                    {
                      "$ref": "9"
                    }
                  ],
                  "t_cart_addons": [
                    {
                      "$ref": "7"
                    },
                    {
                      "$ref": "7"
                    }
                  ]
                }
              },
              {
                "$ref": "7"
              }
            ]
          },
          {
            "$ref": "6"
          }
        ],
        "t_categories": {
          "$id": "10",
          "id": 1,
          "name": "sample string 2",
          "description": "sample string 3",
          "pic": "sample string 4",
          "displayorder": 1,
          "active": true,
          "type": "sample string 5",
          "parentid": 1,
          "vendorid": 6,
          "ops": true,
          "driver": true,
          "pos": true,
          "catering": true,
          "notes": "sample string 7",
          "notes1": "sample string 8",
          "qbaccount": "sample string 9",
          "qbclass": "sample string 10",
          "minorderqty": 11,
          "maxorderqty": 12,
          "routeid": 1,
          "t_categories1": [
            {
              "$ref": "10"
            },
            {
              "$ref": "10"
            }
          ],
          "t_categories2": {
            "$ref": "10"
          },
          "t_items": [
            {
              "$ref": "5"
            },
            {
              "$ref": "5"
            }
          ],
          "t_items1": [
            {
              "$ref": "5"
            },
            {
              "$ref": "5"
            }
          ],
          "t_routes": {
            "$id": "11",
            "id": 1,
            "name": "sample string 2",
            "description": "sample string 3",
            "code": "sample string 4",
            "vendorid": 5,
            "contact": "sample string 6",
            "email": "sample string 7",
            "address": "sample string 8",
            "t_orders": [
              {
                "$ref": "1"
              },
              {
                "$ref": "1"
              }
            ],
            "t_standing_orders": [
              {
                "$id": "12",
                "id": 1,
                "user_id": 1,
                "tos": "00:00:00.1234567",
                "type": "sample string 2",
                "address_id": 1,
                "vendorid": 3,
                "createby": "sample string 4",
                "customer_notes": "sample string 5",
                "driver_instructions": "sample string 6",
                "status": "sample string 7",
                "routeid": 1,
                "dept": "sample string 8",
                "notify_user": true,
                "standing_days": "sample string 9",
                "create_date": "2025-12-31T01:34:30.9388377+00:00",
                "t_routes": {
                  "$ref": "11"
                },
                "t_standing_orderentry": [
                  {
                    "$id": "13",
                    "id": 1,
                    "itemid": 1,
                    "description": "sample string 2",
                    "qty": 1.0,
                    "price": 1.0,
                    "orderid": 1,
                    "discount": 3.0,
                    "uom": "sample string 4",
                    "category": "sample string 5",
                    "subcategory": "sample string 6",
                    "t_items": {
                      "$ref": "5"
                    },
                    "t_standing_orders": {
                      "$ref": "12"
                    }
                  },
                  {
                    "$ref": "13"
                  }
                ],
                "t_users": {
                  "$id": "14",
                  "id": 1,
                  "vendorid": 2,
                  "email": "sample string 3",
                  "phone": "sample string 4",
                  "name": "sample string 5",
                  "code": "sample string 6",
                  "displayname": "sample string 7",
                  "notifyorders": true,
                  "notifypromo": true,
                  "notifylowbal": true,
                  "islocked": true,
                  "status": "sample string 8",
                  "lastlogin": "2025-12-31T01:34:30.9388377+00:00",
                  "notes": "sample string 9",
                  "type": "sample string 10",
                  "creditlimit": 1.0,
                  "createdate": "2025-12-31T01:34:30.9388377+00:00",
                  "createby": "sample string 11",
                  "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                  "updateby": "sample string 12",
                  "device_token": "sample string 13",
                  "device_id": "sample string 14",
                  "device_type": "sample string 15",
                  "uuid": "sample string 16",
                  "publictoken": "sample string 17",
                  "billcopy": true,
                  "sms_notify": true,
                  "email_notify": true,
                  "password": "QEA=",
                  "pic": "sample string 18",
                  "allow_portal": true,
                  "account_notes": "sample string 19",
                  "routeid": 1,
                  "qb_name": "sample string 20",
                  "secondary_email": "sample string 21",
                  "secondary_phone": "sample string 22",
                  "is_wholesale": true,
                  "tnb": "sample string 23",
                  "school": true,
                  "address": "sample string 24",
                  "landmark": "sample string 25",
                  "street": "sample string 26",
                  "zip": "sample string 27",
                  "town": "sample string 28",
                  "discount_type": "sample string 29",
                  "discount": 1.0,
                  "dob": "2025-12-31T01:34:30.9388377+00:00",
                  "anniversary_date": "2025-12-31T01:34:30.9388377+00:00",
                  "tpcode": "sample string 30",
                  "t_orders": [
                    {
                      "$ref": "1"
                    },
                    {
                      "$ref": "1"
                    }
                  ],
                  "t_routes": {
                    "$ref": "11"
                  },
                  "t_standing_orders": [
                    {
                      "$ref": "12"
                    },
                    {
                      "$ref": "12"
                    }
                  ],
                  "t_user_addresss": [
                    {
                      "$id": "15",
                      "id": 1,
                      "user_id": 1,
                      "landmark": "sample string 2",
                      "street": "sample string 3",
                      "zip": "sample string 4",
                      "town": "sample string 5",
                      "createdate": "2025-12-31T01:34:30.9388377+00:00",
                      "createby": "sample string 6",
                      "updateby": "sample string 7",
                      "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                      "active": true,
                      "gmap_address": "sample string 8",
                      "latitude": 9.0,
                      "longitude": 10.0,
                      "is_primary_address": true,
                      "t_orders": [
                        {
                          "$ref": "1"
                        },
                        {
                          "$ref": "1"
                        }
                      ],
                      "t_standing_orders": [
                        {
                          "$ref": "12"
                        },
                        {
                          "$ref": "12"
                        }
                      ],
                      "t_users": {
                        "$ref": "14"
                      }
                    },
                    {
                      "$ref": "15"
                    }
                  ],
                  "t_user_cards": [
                    {
                      "$id": "16",
                      "id": 1,
                      "user_id": 2,
                      "card_holder": "sample string 3",
                      "last_four": "sample string 4",
                      "card_id": "sample string 5",
                      "is_default": 6,
                      "created_at": "2025-12-31T01:34:30.9388377+00:00",
                      "updated_at": "2025-12-31T01:34:30.9388377+00:00",
                      "card_type": "sample string 7",
                      "expiry": "sample string 8",
                      "is_deleted": true,
                      "vendorid": 1,
                      "t_users": {
                        "$ref": "14"
                      }
                    },
                    {
                      "$ref": "16"
                    }
                  ],
                  "t_user_payments": [
                    {
                      "$id": "17",
                      "id": 1,
                      "user_id": 1,
                      "orderid": 1,
                      "amount": 2.0,
                      "narration": "sample string 3",
                      "trandate": "2025-12-31T01:34:30.9388377+00:00",
                      "tranby": "sample string 4",
                      "pm": "sample string 5",
                      "proofofpayment": "sample string 6",
                      "t_orders": {
                        "$ref": "1"
                      },
                      "t_users": {
                        "$ref": "14"
                      }
                    },
                    {
                      "$ref": "17"
                    }
                  ],
                  "t_user_waitlist": [
                    {
                      "$id": "18",
                      "id": 1,
                      "vendorid": 1,
                      "user_id": 1,
                      "party_size": 1,
                      "experience": "sample string 2",
                      "req_dates": "sample string 3",
                      "service": "sample string 4",
                      "guest_name": "sample string 5",
                      "guest_email": "sample string 6",
                      "guest_phone": "sample string 7",
                      "status": "sample string 8",
                      "createby": "sample string 9",
                      "createdate": "2025-12-31T01:34:30.9388377+00:00",
                      "updateby": "sample string 10",
                      "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                      "notes": "sample string 11",
                      "t_users": {
                        "$ref": "14"
                      },
                      "t_vendors": {
                        "$id": "19",
                        "id": 1,
                        "name": "sample string 2",
                        "address": "sample string 3",
                        "city": "sample string 4",
                        "phone": "sample string 5",
                        "email": "sample string 6",
                        "logo": "sample string 7",
                        "status": "sample string 8",
                        "startdate": "2025-12-31T01:34:30.9388377+00:00",
                        "enddate": "2025-12-31T01:34:30.9388377+00:00",
                        "terms": "sample string 9",
                        "type": "sample string 10",
                        "showprice": true,
                        "currency": "sample string 11",
                        "posscreensections": 1,
                        "supportemail": "sample string 12",
                        "orderbcc": "sample string 13",
                        "ordercc": "sample string 14",
                        "transubline": "sample string 15",
                        "intraip": "sample string 16",
                        "postransubline": "sample string 17",
                        "minordervalue": 1.0,
                        "pnp": "sample string 18",
                        "pnp_pwd": "sample string 19",
                        "pnp_email": "sample string 20",
                        "fcm_key": "sample string 21",
                        "fcm_sender": "sample string 22",
                        "email_notifications": true,
                        "api_url": "sample string 23",
                        "api_key": "sample string 24",
                        "mobiledeliverysubline": "sample string 25",
                        "delivertstart": 26,
                        "deliveryend": 27,
                        "deliveryreqcountperslot": 28,
                        "deliveryslothours": 29,
                        "qb_token": "sample string 30",
                        "country": "sample string 31",
                        "special_category": 32,
                        "doc_url": "sample string 33",
                        "web_url": "sample string 34",
                        "guest_userid": 1,
                        "guest_address": 1,
                        "print_receipt": true,
                        "print_receipt_confirmation": true,
                        "brief": "sample string 37",
                        "user_tips": "sample string 38",
                        "bookingstart": 39,
                        "bookingend": 40,
                        "bookingreqcountperslot": 41,
                        "bookingslotmins": 42,
                        "minbookingvalue": 1.0,
                        "gratuaty": 43.0,
                        "default_user_profile": "sample string 44",
                        "short_details": "sample string 45",
                        "show_tbl": true,
                        "thank_you_msg": "sample string 47",
                        "website_keywords": "sample string 48",
                        "website_metatags": "sample string 49",
                        "ItemAccountRef": "sample string 50",
                        "ClassRef": "sample string 51",
                        "qb_invoice_note": "sample string 52",
                        "t_orders": [
                          {
                            "$ref": "1"
                          },
                          {
                            "$ref": "1"
                          }
                        ],
                        "t_staffs": [
                          {
                            "$id": "20",
                            "id": 1,
                            "name": "sample string 2",
                            "avatar": "sample string 3",
                            "email": "sample string 4",
                            "phone": "sample string 5",
                            "password": "QEA=",
                            "islocked": true,
                            "envmode": "sample string 6",
                            "token": "sample string 7",
                            "vendorid": 8,
                            "status": "sample string 9",
                            "pospin": "sample string 10",
                            "notes": "sample string 11",
                            "qb_token": "sample string 12",
                            "payrateperhr": 1.0,
                            "salary": 1.0,
                            "hrsperweek": 1,
                            "paidoffdaysperyr": 1,
                            "paidsickdaysperyr": 1,
                            "startdate": "2025-12-31T01:34:30.9388377+00:00",
                            "enddate": "2025-12-31T01:34:30.9388377+00:00",
                            "routeid": 1,
                            "inout": "sample string 13",
                            "binid": 1,
                            "device_token": "sample string 14",
                            "emp_code": "sample string 15",
                            "qb_name": "sample string 16",
                            "designation": "sample string 17",
                            "dept": "sample string 18",
                            "sec": "sample string 19",
                            "passport": "sample string 20",
                            "driver_licese_no": "sample string 21",
                            "driver_licese_group": "sample string 22",
                            "driver_license_exp_date": "sample string 23",
                            "alt_contact_no": "sample string 24",
                            "dob": "2025-12-31T01:34:30.9388377+00:00",
                            "bio": "sample string 25",
                            "show_on_website": true,
                            "job_title": "sample string 27",
                            "regular_pay_rate": 28.0,
                            "overtime_pay_rate": 29.0,
                            "health_insurance_total": 30.0,
                            "health_insurance_num": "sample string 31",
                            "health_insurance_company": "sample string 32",
                            "health_insurnace_per_payroll": 33.0,
                            "work_permit_holder": true,
                            "work_permit_num": "sample string 35",
                            "work_permit_expiry": "2025-12-31T01:34:30.9388377+00:00",
                            "pension": true,
                            "health_insurnace_contri_type": "sample string 37",
                            "health_insurance_pay_schedule": "sample string 38",
                            "health_insurnace_vendor_contri": 39.0,
                            "health_insurnace_staff_contri": 40.0,
                            "pension_contri_type": "sample string 41",
                            "pension_vendor_contri": 42.0,
                            "pension_staff_contri": 43.0,
                            "pension_num": "sample string 44",
                            "pension_company": "sample string 45",
                            "health_insurance_dep_contri": 46.0,
                            "reimburse_health_insurance": true,
                            "pay_type": "sample string 48",
                            "compulsory_hrs": 49.0,
                            "address": "sample string 50",
                            "country": "sample string 51",
                            "t_binlocations": {
                              "$id": "21",
                              "id": 1,
                              "code": "sample string 2",
                              "description": "sample string 3",
                              "active": true,
                              "createby": "sample string 4",
                              "createdate": "2025-12-31T01:34:30.9388377+00:00",
                              "updateby": "sample string 5",
                              "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                              "vendorid": 6,
                              "store": 1,
                              "ailse": "sample string 7",
                              "bay": "sample string 8",
                              "lvl": "sample string 9",
                              "sec": "sample string 10",
                              "bintype": "sample string 11",
                              "forsale": true,
                              "default4receiving": true,
                              "routeid": 1,
                              "t_item_bins": [
                                {
                                  "$id": "22",
                                  "id": 1,
                                  "item_id": 1,
                                  "vendorid": 2,
                                  "cnt": 1.0,
                                  "binid": 1,
                                  "t_binlocations": {
                                    "$ref": "21"
                                  },
                                  "t_items": {
                                    "$ref": "5"
                                  }
                                },
                                {
                                  "$ref": "22"
                                }
                              ],
                              "t_item_transactionentries": [
                                {
                                  "$id": "23",
                                  "id": 1,
                                  "tranid": 1,
                                  "itemid": 1,
                                  "binid": 1,
                                  "count": 1.0,
                                  "notes": "sample string 2",
                                  "t_binlocations": {
                                    "$ref": "21"
                                  },
                                  "t_item_transactions": {
                                    "$id": "24",
                                    "id": 1,
                                    "type": 1,
                                    "createdate": "2025-12-31T01:34:30.9388377+00:00",
                                    "createby": "sample string 2",
                                    "notes": "sample string 3",
                                    "tran_class": "sample string 4",
                                    "refid": 1,
                                    "closed": true,
                                    "vendorid": 6,
                                    "t_item_transactionentries": [
                                      {
                                        "$ref": "23"
                                      },
                                      {
                                        "$ref": "23"
                                      }
                                    ]
                                  },
                                  "t_items": {
                                    "$ref": "5"
                                  }
                                },
                                {
                                  "$ref": "23"
                                }
                              ],
                              "t_staffs": [
                                {
                                  "$ref": "20"
                                },
                                {
                                  "$ref": "20"
                                }
                              ],
                              "t_routes": {
                                "$ref": "11"
                              }
                            },
                            "t_leaves": [
                              {
                                "$id": "25",
                                "id": 1,
                                "staff_id": 1,
                                "fromdate": "2025-12-31T01:34:30.9388377+00:00",
                                "todate": "2025-12-31T01:34:30.9388377+00:00",
                                "type": "sample string 2",
                                "status": "sample string 3",
                                "reason": "sample string 4",
                                "halfday1": true,
                                "addressduringleave": "sample string 5",
                                "phoneduringleave": "sample string 6",
                                "managernotes": "sample string 7",
                                "createdate": "2025-12-31T01:34:30.9388377+00:00",
                                "createby": "sample string 8",
                                "upadatedate": "2025-12-31T01:34:30.9388377+00:00",
                                "updateby": "sample string 9",
                                "backupduringleave": "sample string 10",
                                "vendorid": 11,
                                "approvedby": "sample string 12",
                                "tlp": 1.0,
                                "halfday2": true,
                                "approvedbymanager": true,
                                "approvedbyhr": true,
                                "hrnotes": "sample string 13",
                                "manager": "sample string 14",
                                "t_staffs": {
                                  "$ref": "20"
                                }
                              },
                              {
                                "$ref": "25"
                              }
                            ],
                            "t_orders": [
                              {
                                "$ref": "1"
                              },
                              {
                                "$ref": "1"
                              }
                            ],
                            "t_staffs_reminders": [
                              {
                                "$id": "26",
                                "id": 1,
                                "name": "sample string 2",
                                "description": "sample string 3",
                                "createby": "sample string 4",
                                "createdate": "2025-12-31T01:34:30.9388377+00:00",
                                "updateby": "sample string 5",
                                "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                                "active": true,
                                "enddate": "2025-12-31T01:34:30.9388377+00:00",
                                "staff_id": 1,
                                "start_date": "2025-12-31T01:34:30.9388377+00:00",
                                "duedate": "2025-12-31T01:34:30.9388377+00:00",
                                "emp_dept_section": "sample string 6",
                                "pic": "sample string 7",
                                "vendorid": 8,
                                "t_staffs": {
                                  "$ref": "20"
                                }
                              },
                              {
                                "$ref": "26"
                              }
                            ],
                            "t_staffs_shifts": [
                              {
                                "$id": "27",
                                "id": 1,
                                "staff_id": 2,
                                "start_time": "sample string 3",
                                "end_time": "sample string 4",
                                "deleted_at": "2025-12-31T01:34:30.9388377+00:00",
                                "created_at": "2025-12-31T01:34:30.9388377+00:00",
                                "updated_at": "2025-12-31T01:34:30.9388377+00:00",
                                "status": "sample string 5",
                                "manager_notes": "sample string 6",
                                "hr_notes": "sample string 7",
                                "qbrefno": "sample string 8",
                                "updateby": "sample string 9",
                                "tag": "sample string 10",
                                "vendorid": 11,
                                "opening_bal": 1.0,
                                "closing_bal": 1.0,
                                "t_staffs": {
                                  "$ref": "20"
                                },
                                "t_staffs_shift_timings": [
                                  {
                                    "$id": "28",
                                    "id": 1,
                                    "staff_shift_id": 2,
                                    "start_time": "sample string 3",
                                    "end_time": "sample string 4",
                                    "order_count": 5,
                                    "created_at": "2025-12-31T01:34:30.9388377+00:00",
                                    "updated_at": "2025-12-31T01:34:30.9388377+00:00",
                                    "deleted_at": "2025-12-31T01:34:30.9388377+00:00",
                                    "type": "sample string 6",
                                    "reason": "sample string 7",
                                    "t_staffs_shifts": {
                                      "$ref": "27"
                                    }
                                  },
                                  {
                                    "$ref": "28"
                                  }
                                ]
                              },
                              {
                                "$ref": "27"
                              }
                            ],
                            "t_vendors": {
                              "$ref": "19"
                            },
                            "t_staff_payrollentry": [
                              {
                                "$id": "29",
                                "id": 1,
                                "payrollid": 1,
                                "staffid": 1,
                                "regular_hrs": 2.0,
                                "overtime_hrs": 3.0,
                                "regular_pay_rate": 4.0,
                                "overtime_pay_rate": 5.0,
                                "tips": 6.0,
                                "pension_staff": 7.0,
                                "pension_vendor": 8.0,
                                "health_insurance_staff": 9.0,
                                "health_insurance_vendor": 10.0,
                                "payment_ref": "sample string 11",
                                "notes": "sample string 12",
                                "net_pay": 13.0,
                                "regular_pay": 14.0,
                                "overtime_pay": 15.0,
                                "t_staff_payroll": {
                                  "$id": "30",
                                  "id": 1,
                                  "from_date": "2025-12-31T01:34:30.9388377+00:00",
                                  "to_date": "2025-12-31T01:34:30.9388377+00:00",
                                  "payroll_date": "2025-12-31T01:34:30.9388377+00:00",
                                  "createby": "sample string 2",
                                  "createdate": "2025-12-31T01:34:30.9388377+00:00",
                                  "updateby": "sample string 3",
                                  "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                                  "seq": 4,
                                  "num": "sample string 5",
                                  "status": "sample string 6",
                                  "notes": "sample string 7",
                                  "vendorid": 8,
                                  "t_staff_payrollentry": [
                                    {
                                      "$ref": "29"
                                    },
                                    {
                                      "$ref": "29"
                                    }
                                  ],
                                  "t_vendors": {
                                    "$ref": "19"
                                  }
                                },
                                "t_staffs": {
                                  "$ref": "20"
                                }
                              },
                              {
                                "$ref": "29"
                              }
                            ],
                            "t_staff_roster": [
                              {
                                "$id": "31",
                                "id": 1,
                                "staffid": 1,
                                "dos": "2025-12-31T01:34:30.9388377+00:00",
                                "start_time": "00:00:00.1234567",
                                "end_time": "00:00:00.1234567",
                                "role": "sample string 5",
                                "role_category": "sample string 6",
                                "routeid": 1,
                                "createby": "sample string 7",
                                "createdate": "2025-12-31T01:34:30.9388377+00:00",
                                "vendorid": 8,
                                "notes": "sample string 9",
                                "reason": "sample string 10",
                                "t_routes": {
                                  "$ref": "11"
                                },
                                "t_staffs": {
                                  "$ref": "20"
                                }
                              },
                              {
                                "$ref": "31"
                              }
                            ]
                          },
                          {
                            "$ref": "20"
                          }
                        ],
                        "t_userinroles": [
                          {
                            "$id": "32",
                            "id": 1,
                            "email": "sample string 2",
                            "role": "sample string 3",
                            "active": true,
                            "vendorid": 4,
                            "t_vendors": {
                              "$ref": "19"
                            }
                          },
                          {
                            "$ref": "32"
                          }
                        ],
                        "t_vendor_blocked_dates": [
                          {
                            "$id": "33",
                            "id": 1,
                            "vendorid": 2,
                            "dateblocked": "2025-12-31T01:34:30.9388377+00:00",
                            "reason": "sample string 4",
                            "tbl_id": 1,
                            "t_vendors": {
                              "$ref": "19"
                            },
                            "t_tables": {
                              "$id": "34",
                              "id": 1,
                              "code": "sample string 2",
                              "name": "sample string 3",
                              "createby": "sample string 4",
                              "createdate": "2025-12-31T01:34:30.9388377+00:00",
                              "updateby": "sample string 5",
                              "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                              "location": "sample string 6",
                              "active": true,
                              "vendorid": 1,
                              "max_capacity": 8,
                              "min_capacity": 9,
                              "routeid": 1,
                              "t_orders": [
                                {
                                  "$ref": "1"
                                },
                                {
                                  "$ref": "1"
                                }
                              ],
                              "t_vendor_blocked_dates": [
                                {
                                  "$ref": "33"
                                },
                                {
                                  "$ref": "33"
                                }
                              ],
                              "t_vendor_blocked_time_slots": [
                                {
                                  "$id": "35",
                                  "id": 1,
                                  "vendorid": 2,
                                  "ondate": "2025-12-31T01:34:30.9388377+00:00",
                                  "hrs": 1.0,
                                  "reason": "sample string 4",
                                  "tbl_id": 1,
                                  "t_tables": {
                                    "$ref": "34"
                                  },
                                  "t_vendors": {
                                    "$ref": "19"
                                  }
                                },
                                {
                                  "$ref": "35"
                                }
                              ]
                            }
                          },
                          {
                            "$ref": "33"
                          }
                        ],
                        "t_vendor_devices": [
                          {
                            "$id": "36",
                            "id": 1,
                            "vendorid": 2,
                            "device_token": "sample string 3",
                            "doe": "2025-12-31T01:34:30.9388377+00:00",
                            "t_vendors": {
                              "$ref": "19"
                            }
                          },
                          {
                            "$ref": "36"
                          }
                        ],
                        "t_vendor_accomplishment": [
                          {
                            "$id": "37",
                            "id": 1,
                            "vendorid": 1,
                            "name": "sample string 2",
                            "pic": "sample string 3",
                            "yr": 1,
                            "link": "sample string 4",
                            "link_name": "sample string 5",
                            "t_vendors": {
                              "$ref": "19"
                            }
                          },
                          {
                            "$ref": "37"
                          }
                        ],
                        "t_vendor_details": [
                          {
                            "$id": "38",
                            "id": 1,
                            "vendorid": 1,
                            "description": "sample string 2",
                            "t_vendors": {
                              "$ref": "19"
                            }
                          },
                          {
                            "$ref": "38"
                          }
                        ],
                        "t_vendor_banners": [
                          {
                            "$id": "39",
                            "id": 1,
                            "vendorid": 1,
                            "file_url": "sample string 2",
                            "createby": "sample string 3",
                            "createdate": "2025-12-31T01:34:30.9388377+00:00",
                            "t_vendors": {
                              "$ref": "19"
                            }
                          },
                          {
                            "$ref": "39"
                          }
                        ],
                        "t_vendor_discount_structures": [
                          {
                            "$id": "40",
                            "id": 1,
                            "spend_upto": 1.0,
                            "discount": 1.0,
                            "vendorid": 1,
                            "orderby": 1,
                            "t_vendors": {
                              "$ref": "19"
                            }
                          },
                          {
                            "$ref": "40"
                          }
                        ],
                        "t_user_waitlist": [
                          {
                            "$ref": "18"
                          },
                          {
                            "$ref": "18"
                          }
                        ],
                        "t_vendor_blocked_time_slots": [
                          {
                            "$ref": "35"
                          },
                          {
                            "$ref": "35"
                          }
                        ],
                        "t_vendor_shipto": [
                          {
                            "$id": "41",
                            "id": 1,
                            "name": "sample string 2",
                            "email": "sample string 3",
                            "address": "sample string 4",
                            "phone": "sample string 5",
                            "vendorid": 1,
                            "active": true,
                            "t_vendors": {
                              "$ref": "19"
                            },
                            "t_pohdr": [
                              {
                                "$id": "42",
                                "id": 1,
                                "pon": "sample string 2",
                                "seq": 3,
                                "supplierid": 1,
                                "podate": "2025-12-31T01:34:30.9388377+00:00",
                                "duedate": "2025-12-31T01:34:30.9388377+00:00",
                                "terms": "sample string 4",
                                "notes": "sample string 5",
                                "vendorid": 6,
                                "status": "sample string 7",
                                "type": "sample string 8",
                                "receivedby": "sample string 9",
                                "receiveddate": "2025-12-31T01:34:30.9388377+00:00",
                                "invoiceno": "sample string 10",
                                "currency": "sample string 11",
                                "roe": 12.0,
                                "createby": "sample string 13",
                                "createdate": "2025-12-31T01:34:30.9388377+00:00",
                                "updateby": "sample string 14",
                                "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                                "shipto": 1,
                                "t_poentry": [
                                  {
                                    "$id": "43",
                                    "id": 1,
                                    "hdrid": 1,
                                    "itemid": 1,
                                    "code": "sample string 2",
                                    "description": "sample string 3",
                                    "cost": 4.0,
                                    "qty": 5.0,
                                    "receivedqty": 6.0,
                                    "uom": "sample string 7",
                                    "t_items": {
                                      "$ref": "5"
                                    },
                                    "t_pohdr": {
                                      "$ref": "42"
                                    }
                                  },
                                  {
                                    "$ref": "43"
                                  }
                                ],
                                "t_vendor_shipto": {
                                  "$ref": "41"
                                },
                                "t_suppliers": {
                                  "$id": "44",
                                  "id": 1,
                                  "name": "sample string 2",
                                  "email": "sample string 3",
                                  "address": "sample string 4",
                                  "phone": "sample string 5",
                                  "vendorid": 1,
                                  "active": true,
                                  "t_pohdr": [
                                    {
                                      "$ref": "42"
                                    },
                                    {
                                      "$ref": "42"
                                    }
                                  ]
                                },
                                "t_vendors": {
                                  "$ref": "19"
                                }
                              },
                              {
                                "$ref": "42"
                              }
                            ]
                          },
                          {
                            "$ref": "41"
                          }
                        ],
                        "t_pohdr": [
                          {
                            "$ref": "42"
                          },
                          {
                            "$ref": "42"
                          }
                        ],
                        "t_staff_payroll": [
                          {
                            "$ref": "30"
                          },
                          {
                            "$ref": "30"
                          }
                        ],
                        "t_invoices": [
                          {
                            "$id": "45",
                            "id": 1,
                            "status": "sample string 2",
                            "notes": "sample string 3",
                            "invoicedate": "2025-12-31T01:34:30.9388377+00:00",
                            "vendorid": 4,
                            "schoolid": 5,
                            "adminnotes": "sample string 6",
                            "createby": "sample string 7",
                            "update_by": "sample string 8",
                            "updatedate": "2025-12-31T01:34:30.9388377+00:00",
                            "seq": 9,
                            "invno": "sample string 10",
                            "userid": 11,
                            "duedate": "2025-12-31T01:34:30.9388377+00:00",
                            "terms": "sample string 12",
                            "createdate": "2025-12-31T01:34:30.9388377+00:00",
                            "updateby": "sample string 13",
                            "orderref": "sample string 14",
                            "currency": "sample string 15",
                            "t_invoiceentry": [
                              {
                                "$id": "46",
                                "id": 1,
                                "itemid": 1,
                                "description": "sample string 2",
                                "qty": 3.0,
                                "price": 4.0,
                                "invoiceid": 1,
                                "discount": 5.0,
                                "uom": "sample string 6",
                                "t_items": {
                                  "$ref": "5"
                                },
                                "t_invoices": {
                                  "$ref": "45"
                                }
                              },
                              {
                                "$ref": "46"
                              }
                            ],
                            "t_users": {
                              "$ref": "14"
                            },
                            "t_vendors": {
                              "$ref": "19"
                            }
                          },
                          {
                            "$ref": "45"
                          }
                        ]
                      }
                    },
                    {
                      "$ref": "18"
                    }
                  ],
                  "t_item_reviews": [
                    {
                      "$id": "47",
                      "id": 1,
                      "comment": "sample string 2",
                      "createdby": "sample string 3",
                      "createddate": "2025-12-31T01:34:30.9388377+00:00",
                      "parentid": 1,
                      "itemid": 1,
                      "userid": 1,
                      "rating": 4.0,
                      "approved": true,
                      "t_item_reviews1": [
                        {
                          "$ref": "47"
                        },
                        {
                          "$ref": "47"
                        }
                      ],
                      "t_item_reviews2": {
                        "$ref": "47"
                      },
                      "t_items": {
                        "$ref": "5"
                      },
                      "t_users": {
                        "$ref": "14"
                      }
                    },
                    {
                      "$ref": "47"
                    }
                  ],
                  "t_invoices": [
                    {
                      "$ref": "45"
                    },
                    {
                      "$ref": "45"
                    }
                  ]
                },
                "t_user_addresss": {
                  "$ref": "15"
                }
              },
              {
                "$ref": "12"
              }
            ],
            "t_users": [
              {
                "$ref": "14"
              },
              {
                "$ref": "14"
              }
            ],
            "t_categories": [
              {
                "$ref": "10"
              },
              {
                "$ref": "10"
              }
            ],
            "t_items": [
              {
                "$ref": "5"
              },
              {
                "$ref": "5"
              }
            ],
            "t_staff_roster": [
              {
                "$ref": "31"
              },
              {
                "$ref": "31"
              }
            ],
            "t_binlocations": [
              {
                "$ref": "21"
              },
              {
                "$ref": "21"
              }
            ]
          }
        },
        "t_categories1": {
          "$ref": "10"
        },
        "t_item_bins": [
          {
            "$ref": "22"
          },
          {
            "$ref": "22"
          }
        ],
        "t_item_pricinglog": [
          {
            "$id": "48",
            "id": 1,
            "item_id": 1,
            "cost": 1.0,
            "price": 1.0,
            "doe": "2025-12-31T01:34:30.9388377+00:00",
            "eby": "sample string 2",
            "notes": "sample string 3",
            "t_items": {
              "$ref": "5"
            }
          },
          {
            "$ref": "48"
          }
        ],
        "t_item_timings": [
          {
            "$id": "49",
            "id": 1,
            "item_id": 1,
            "dayavail": "sample string 2",
            "startdate": "2025-12-31T01:34:30.9388377+00:00",
            "enddate": "2025-12-31T01:34:30.9388377+00:00",
            "hideprice": true,
            "displayorder": 1,
            "t_items": {
              "$ref": "5"
            }
          },
          {
            "$ref": "49"
          }
        ],
        "t_item_transactionentries": [
          {
            "$ref": "23"
          },
          {
            "$ref": "23"
          }
        ],
        "t_orderentry": [
          {
            "$ref": "4"
          },
          {
            "$ref": "4"
          }
        ],
        "t_standing_orderentry": [
          {
            "$ref": "13"
          },
          {
            "$ref": "13"
          }
        ],
        "t_item_addons": [
          {
            "$ref": "8"
          },
          {
            "$ref": "8"
          }
        ],
        "t_item_addons1": [
          {
            "$ref": "8"
          },
          {
            "$ref": "8"
          }
        ],
        "t_item_pics": [
          {
            "$id": "50",
            "id": 1,
            "url": "sample string 2",
            "createby": "sample string 3",
            "createdate": "2025-12-31T01:34:30.9388377+00:00",
            "updateby": "sample string 4",
            "updatedate": "2025-12-31T01:34:30.9388377+00:00",
            "active": true,
            "item_id": 1,
            "display_order": 5,
            "t_items": {
              "$ref": "5"
            }
          },
          {
            "$ref": "50"
          }
        ],
        "t_item_details": [
          {
            "$id": "51",
            "id": 1,
            "idt": 1,
            "idth": 1,
            "description": "sample string 2",
            "display_order": 3,
            "createby": "sample string 4",
            "createdate": "2025-12-31T01:34:30.9388377+00:00",
            "updateby": "sample string 5",
            "updatedate": "2025-12-31T01:34:30.9388377+00:00",
            "active": true,
            "item_id": 1,
            "t_item_detail_type_hdrs": {
              "$id": "52",
              "id": 1,
              "idt": 1,
              "description": "sample string 2",
              "t_item_details": [
                {
                  "$ref": "51"
                },
                {
                  "$ref": "51"
                }
              ],
              "t_item_detail_types": {
                "$id": "53",
                "id": 1,
                "description": "sample string 2",
                "t_item_detail_type_hdrs": [
                  {
                    "$ref": "52"
                  },
                  {
                    "$ref": "52"
                  }
                ],
                "t_item_details": [
                  {
                    "$ref": "51"
                  },
                  {
                    "$ref": "51"
                  }
                ]
              }
            },
            "t_item_detail_types": {
              "$ref": "53"
            },
            "t_items": {
              "$ref": "5"
            }
          },
          {
            "$ref": "51"
          }
        ],
        "t_item_reviews": [
          {
            "$ref": "47"
          },
          {
            "$ref": "47"
          }
        ],
        "t_routes": {
          "$ref": "11"
        },
        "t_poentry": [
          {
            "$ref": "43"
          },
          {
            "$ref": "43"
          }
        ],
        "t_invoiceentry": [
          {
            "$ref": "46"
          },
          {
            "$ref": "46"
          }
        ]
      },
      "t_orders": {
        "$ref": "1"
      },
      "t_order_addons": [
        {
          "$ref": "9"
        },
        {
          "$ref": "9"
        }
      ]
    },
    {
      "$ref": "4"
    }
  ],
  "t_routes": {
    "$ref": "11"
  },
  "t_staffs": {
    "$ref": "20"
  },
  "t_user_addresss": {
    "$ref": "15"
  },
  "t_users": {
    "$ref": "14"
  },
  "t_vendors": {
    "$ref": "19"
  },
  "t_user_payments": [
    {
      "$ref": "17"
    },
    {
      "$ref": "17"
    }
  ],
  "t_tables": {
    "$ref": "34"
  }
}