GET api/Data/Gett_vendor_items/{id}

This is to get food vendor items by vendor id

Request Information

URI Parameters

NameDescriptionTypeAdditional information
id

Vendor id

integer

Required

Body Parameters

None.

Response Information

Resource Description

List of items

t_vendor_items
NameDescriptionTypeAdditional information
id

integer

None.

vendorid

integer

None.

categoryid

integer

None.

name

string

None.

description

string

None.

pic

string

None.

status

string

None.

ingredients

string

None.

cost

decimal number

None.

price

decimal number

None.

addedby

string

None.

dateadded

date

None.

dateofexpiry

date

None.

frontpage

boolean

None.

displayorder

integer

None.

barcode

string

None.

subtag

string

None.

inventory

boolean

None.

seq

integer

None.

tpcode

string

None.

dateupdated

date

None.

updateby

string

None.

color

string

None.

style

string

None.

gender

string

None.

minqty

decimal number

None.

maxqty

decimal number

None.

reorderqty

decimal number

None.

uom

string

None.

pref

integer

None.

t_invoiceentry

Collection of t_invoiceentry

None.

t_item_addons

Collection of t_item_addons

None.

t_item_addons1

Collection of t_item_addons

None.

t_item_bins

Collection of t_item_bins

None.

t_item_categories

t_item_categories

None.

t_item_pics

Collection of t_item_pics

None.

t_item_pricinglog

Collection of t_item_pricinglog

None.

t_item_reviews

Collection of t_item_reviews

None.

t_item_timings

Collection of t_item_timings

None.

t_item_transactions

Collection of t_item_transactions

None.

t_orderentry

Collection of t_orderentry

None.

t_poentry

Collection of t_poentry

None.

t_standing_orderentry

Collection of t_standing_orderentry

None.

t_item_details

Collection of t_item_details

None.

t_vendors

t_vendors

None.

Response Formats

application/json, text/json

Sample:
{
  "id": 1,
  "vendorid": 2,
  "categoryid": 3,
  "name": "sample string 4",
  "description": "sample string 5",
  "pic": "sample string 6",
  "status": "sample string 7",
  "ingredients": "sample string 8",
  "cost": 1.0,
  "price": 1.0,
  "addedby": "sample string 9",
  "dateadded": "2025-07-06T06:48:27.0363417+00:00",
  "dateofexpiry": "2025-07-06T06:48:27.0363417+00:00",
  "frontpage": true,
  "displayorder": 1,
  "barcode": "sample string 10",
  "subtag": "sample string 11",
  "inventory": true,
  "seq": 13,
  "tpcode": "sample string 14",
  "dateupdated": "2025-07-06T06:48:27.0363417+00:00",
  "updateby": "sample string 15",
  "color": "sample string 16",
  "style": "sample string 17",
  "gender": "sample string 18",
  "minqty": 19.0,
  "maxqty": 20.0,
  "reorderqty": 21.0,
  "uom": "sample string 22",
  "pref": 23,
  "t_invoiceentry": [
    {
      "$id": "2",
      "id": 1,
      "itemid": 1,
      "description": "sample string 2",
      "qty": 3.0,
      "price": 4.0,
      "invoiceid": 1,
      "discount": 5.0,
      "uom": "sample string 6",
      "t_invoices": {
        "$id": "3",
        "id": 1,
        "status": "sample string 2",
        "notes": "sample string 3",
        "invoicedate": "2025-07-06T06:48:27.0363417+00:00",
        "vendorid": 4,
        "schoolid": 5,
        "adminnotes": "sample string 6",
        "createby": "sample string 7",
        "update_by": "sample string 8",
        "updatedate": "2025-07-06T06:48:27.0363417+00:00",
        "seq": 9,
        "invno": "sample string 10",
        "customerid": 11,
        "duedate": "2025-07-06T06:48:27.0363417+00:00",
        "terms": "sample string 12",
        "createdate": "2025-07-06T06:48:27.0363417+00:00",
        "updateby": "sample string 13",
        "orderref": "sample string 14",
        "currency": "sample string 15",
        "t_customers": {
          "$id": "4",
          "id": 1,
          "name": "sample string 2",
          "email": "sample string 3",
          "address": "sample string 4",
          "phone": "sample string 5",
          "vendorid": 1,
          "active": true,
          "t_invoices": [
            {
              "$ref": "3"
            },
            {
              "$ref": "3"
            }
          ],
          "t_vendors": {
            "$id": "5",
            "id": 1,
            "business_name": "sample string 2",
            "address": "sample string 3",
            "city": "sample string 4",
            "phone": "sample string 5",
            "email": "sample string 6",
            "logo": "sample string 7",
            "api_key": "sample string 8",
            "status": "sample string 9",
            "startdate": "2025-07-06T06:48:27.0519392+00:00",
            "enddate": "2025-07-06T06:48:27.0519392+00:00",
            "terms": "sample string 10",
            "type": "sample string 11",
            "showprice": true,
            "currency": "sample string 12",
            "posscreensections": 1,
            "supportemail": "sample string 13",
            "orderbcc": "sample string 14",
            "ordercc": "sample string 15",
            "transubline": "sample string 16",
            "intraip": "sample string 17",
            "postransubline": "sample string 18",
            "online_pay": true,
            "pnp_account": "sample string 19",
            "pnp_password": "sample string 20",
            "pnp_url": "sample string 21",
            "pnp_email": "sample string 22",
            "pnp_site_key": "sample string 23",
            "country": "sample string 24",
            "posthemecolor": "sample string 25",
            "ItemAccountRef": "sample string 26",
            "ClassRef": "sample string 27",
            "qb_invoice_note": "sample string 28",
            "navbarBgColor": "sample string 29",
            "navbarTxtColor": "sample string 30",
            "online_member_signup": true,
            "change_pos_login": true,
            "qb_statement_note": "sample string 31",
            "signupdate": "2025-07-06T06:48:27.0519392+00:00",
            "guest_memberid": 1,
            "print_receipt": true,
            "print_receipt_confirmation": true,
            "docurl": "sample string 34",
            "weburl": "sample string 35",
            "enable_daily_limit": 36,
            "open_food_item": 1,
            "head_chief_email": "sample string 37",
            "notify_production_summary": true,
            "notify_distribution_summary": true,
            "posubline": "sample string 39",
            "notify_payment_summary": true,
            "notify_query_summary": true,
            "tag_line": "sample string 40",
            "about": "sample string 41",
            "online_sale": true,
            "inventory": true,
            "payment_instructions": "sample string 44",
            "mobiledeliverysubline": "sample string 45",
            "delivertstart": 46,
            "deliveryend": 47,
            "deliveryreqcountperslot": 48,
            "deliveryslotmis": 49,
            "bookingstart": 50,
            "bookingend": 51,
            "bookingreqcountperslot": 52,
            "bookingslotmins": 53,
            "minbookingvalue": 54.0,
            "gratuaty": 55.0,
            "show_tbl": true,
            "thank_you_msg": "sample string 57",
            "menu_notes1": "sample string 58",
            "menu_notes2": "sample string 59",
            "website_keywords": "sample string 60",
            "website_metatags": "sample string 61",
            "paystub_message": "sample string 62",
            "enable_vendor_announcements": true,
            "client_ip": "sample string 64",
            "publicid": "sample string 65",
            "time_stamp": "2025-07-06T06:48:27.0519392+00:00",
            "verified": true,
            "poc": "sample string 68",
            "enable_parent_menu": true,
            "t_agency_terms": [
              {
                "$id": "6",
                "id": 1,
                "description": "sample string 2",
                "createdate": "2025-07-06T06:48:27.0519392+00:00",
                "createby": "sample string 3",
                "updateby": "sample string 4",
                "updatedate": "2025-07-06T06:48:27.0519392+00:00",
                "vendorid": 1,
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "6"
              }
            ],
            "t_blogs": [
              {
                "$id": "7",
                "id": 1,
                "vendorid": 1,
                "description": "sample string 2",
                "pic": "sample string 3",
                "tagline": "sample string 4",
                "active": true,
                "createby": "sample string 6",
                "credatedate": "2025-07-06T06:48:27.0519392+00:00",
                "updateby": "sample string 7",
                "updatedate": "2025-07-06T06:48:27.0519392+00:00",
                "display_order": 8,
                "publicid": "sample string 9",
                "t_blog_comments": [
                  {
                    "$id": "8",
                    "id": 1,
                    "blogid": 1,
                    "description": "sample string 2",
                    "active": true,
                    "createby": "sample string 4",
                    "credatedate": "2025-07-06T06:48:27.0519392+00:00",
                    "t_blogs": {
                      "$ref": "7"
                    }
                  },
                  {
                    "$ref": "8"
                  }
                ],
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "7"
              }
            ],
            "t_customers": [
              {
                "$ref": "4"
              },
              {
                "$ref": "4"
              }
            ],
            "t_events": [
              {
                "$id": "9",
                "id": 1,
                "subject": "sample string 2",
                "details": "sample string 3",
                "vdo_url": "sample string 4",
                "pic_url": "sample string 5",
                "start_date": "2025-07-06T06:48:27.0519392+00:00",
                "end_date": "2025-07-06T06:48:27.0519392+00:00",
                "createby": "sample string 7",
                "createdate": "2025-07-06T06:48:27.0519392+00:00",
                "vendorid": 1,
                "status": "sample string 8",
                "type": "sample string 9",
                "publicid": "sample string 10",
                "t_event_enrollments": [
                  {
                    "$id": "10",
                    "id": 1,
                    "eventid": 1,
                    "name": "sample string 2",
                    "email": "sample string 3",
                    "phone": "sample string 4",
                    "address": "sample string 5",
                    "status": "sample string 6",
                    "createdate": "2025-07-06T06:48:27.0519392+00:00",
                    "createby": "sample string 7",
                    "t_events": {
                      "$ref": "9"
                    }
                  },
                  {
                    "$ref": "10"
                  }
                ],
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "9"
              }
            ],
            "t_invoices": [
              {
                "$ref": "3"
              },
              {
                "$ref": "3"
              }
            ],
            "t_moe_vendors": [
              {
                "$id": "11",
                "id": 1,
                "moeid": 1,
                "vendorid": 2,
                "active": true,
                "t_moe": {
                  "$id": "12",
                  "id": 1,
                  "name": "sample string 2",
                  "avatar": "sample string 3",
                  "email": "sample string 4",
                  "phone": "sample string 5",
                  "api_key": "sample string 6",
                  "address": "sample string 7",
                  "city": "sample string 8",
                  "country": "sample string 9",
                  "signupdate": "2025-07-06T06:48:27.0519392+00:00",
                  "status": "sample string 10",
                  "startdate": "2025-07-06T06:48:27.0519392+00:00",
                  "enddate": "2025-07-06T06:48:27.0519392+00:00",
                  "poc": "sample string 11",
                  "email_group": "sample string 12",
                  "notify_newsignups": true,
                  "supportemail": "sample string 13",
                  "privacy_policy": "sample string 14",
                  "client_ip": "sample string 15",
                  "publicid": "sample string 16",
                  "time_stamp": "2025-07-06T06:48:27.0519392+00:00",
                  "verified": true,
                  "t_moe_announcements": [
                    {
                      "$id": "13",
                      "id": 1,
                      "moeid": 1,
                      "description": "sample string 2",
                      "heading": "sample string 3",
                      "display_order": 4,
                      "active": true,
                      "createby": "sample string 6",
                      "createdate": "2025-07-06T06:48:27.0519392+00:00",
                      "updateby": "sample string 7",
                      "updatedate": "2025-07-06T06:48:27.0519392+00:00",
                      "t_moe": {
                        "$ref": "12"
                      }
                    },
                    {
                      "$ref": "13"
                    }
                  ],
                  "t_moe_schools": [
                    {
                      "$id": "14",
                      "id": 1,
                      "moeid": 1,
                      "schoolid": 1,
                      "active": true,
                      "t_schools": {
                        "$id": "15",
                        "id": 1,
                        "name": "sample string 2",
                        "description": "sample string 3",
                        "poc": "sample string 4",
                        "email": "sample string 5",
                        "phone": "sample string 6",
                        "address": "sample string 7",
                        "active": true,
                        "menu_file": "sample string 8",
                        "isschool": true,
                        "allow_preordering": true,
                        "type": "sample string 9",
                        "logo": "sample string 10",
                        "primary_breakfast_limit": 1.0,
                        "primary_lunch_limit": 1.0,
                        "primary_snacks_limit": 1.0,
                        "primary_beverages_limit": 1.0,
                        "secondary_breakfast_limit": 1.0,
                        "secondary_lunch_limit": 1.0,
                        "secondary_snacks_limit": 1.0,
                        "secondary_beverages_limit": 1.0,
                        "code": "sample string 11",
                        "application_form_file": "sample string 12",
                        "tution_fee_schedule_file": "sample string 13",
                        "infant_supply_list_file": "sample string 14",
                        "toddler_supply_list_file": "sample string 15",
                        "preschooler_supply_list_file": "sample string 16",
                        "kg_supply_list_file": "sample string 17",
                        "grade_supply_list_file": "sample string 18",
                        "school_calender_file": "sample string 19",
                        "yr": "sample string 20",
                        "waitlist_form_file": "sample string 21",
                        "primary_dinner_limit": 22.0,
                        "secondary_dinner_limit": 23.0,
                        "nursery_dinner_limit": 24.0,
                        "nursery_morning_snacks_limit": 25.0,
                        "nursery_afternoon_snacks_limit": 26.0,
                        "nursery_beverages_limit": 27.0,
                        "nursery_breakfast_limit": 28.0,
                        "nursery_lunch_limit": 29.0,
                        "snacks_split": true,
                        "t_class_teachers": [
                          {
                            "$id": "16",
                            "id": 1,
                            "classid": 2,
                            "code": "sample string 3",
                            "name": "sample string 4",
                            "email": "sample string 5",
                            "phone": "sample string 6",
                            "schoolid": 1,
                            "position_title": "sample string 7",
                            "gender": "sample string 8",
                            "childid": 1,
                            "t_school_classes": {
                              "$id": "17",
                              "id": 1,
                              "code": "sample string 2",
                              "name": "sample string 3",
                              "description": "sample string 4",
                              "poc": "sample string 5",
                              "schoolid": 6,
                              "building": "sample string 7",
                              "floor": "sample string 8",
                              "room": "sample string 9",
                              "active": true,
                              "type": "sample string 10",
                              "note": "sample string 11",
                              "yr": "sample string 12",
                              "t_class_teachers": [
                                {
                                  "$ref": "16"
                                },
                                {
                                  "$ref": "16"
                                }
                              ],
                              "t_schools": {
                                "$ref": "15"
                              },
                              "t_childs": [
                                {
                                  "$id": "18",
                                  "id": 1,
                                  "schoolid": 2,
                                  "classid": 3,
                                  "name": "sample string 4",
                                  "qrcode": "sample string 5",
                                  "code": "sample string 6",
                                  "upn": "sample string 7",
                                  "dob": "2025-07-06T06:48:27.0519392+00:00",
                                  "gender": "sample string 8",
                                  "dadcell": "sample string 9",
                                  "dadworkphone": "sample string 10",
                                  "dadworkemail": "sample string 11",
                                  "dadpersonalemail": "sample string 12",
                                  "momcell": "sample string 13",
                                  "momworkphone": "sample string 14",
                                  "momworkemail": "sample string 15",
                                  "mompersonalemail": "sample string 16",
                                  "healthconditions": "sample string 17",
                                  "pic": "sample string 18",
                                  "active": true,
                                  "notes": "sample string 19",
                                  "lastupdated": "2025-07-06T06:48:27.0519392+00:00",
                                  "updateby": "sample string 20",
                                  "free_meal": true,
                                  "breakfast_limit": 1.0,
                                  "lunch_limit": 1.0,
                                  "snacks_limit": 1.0,
                                  "beverages_limit": 1.0,
                                  "signupdate": "2025-07-06T06:48:27.0519392+00:00",
                                  "deletedate": "2025-07-06T06:48:27.0519392+00:00",
                                  "deleteby": "sample string 21",
                                  "moeid": 1,
                                  "old_upn": "sample string 22",
                                  "del_id": 1,
                                  "school_email": "sample string 23",
                                  "daily_limit": 24.0,
                                  "first_name": "sample string 25",
                                  "last_name": "sample string 26",
                                  "snacks_split": true,
                                  "dinner_limit": 28.0,
                                  "morning_snacks_limit": 29.0,
                                  "afternoon_snacks_limit": 30.0,
                                  "t_school_childs": [
                                    {
                                      "$id": "19",
                                      "childid": 1,
                                      "schoolid": 1,
                                      "id": 1,
                                      "t_schools": {
                                        "$ref": "15"
                                      },
                                      "t_childs": {
                                        "$ref": "18"
                                      }
                                    },
                                    {
                                      "$ref": "19"
                                    }
                                  ],
                                  "t_standing_orders": [
                                    {
                                      "$id": "20",
                                      "id": 1,
                                      "childid": 1,
                                      "vendorid": 1,
                                      "notes": "sample string 2",
                                      "delivery_instructions": "sample string 3",
                                      "status": "sample string 4",
                                      "notify_parent": true,
                                      "recurr_pattern": "sample string 5",
                                      "standing_days": "sample string 6",
                                      "createdate": "2025-07-06T06:48:27.0675777+00:00",
                                      "createby": "sample string 7",
                                      "updatedate": "2025-07-06T06:48:27.0675777+00:00",
                                      "updateby": "sample string 8",
                                      "t_standing_orderentry": [
                                        {
                                          "$id": "21",
                                          "id": 1,
                                          "itemid": 1,
                                          "description": "sample string 2",
                                          "qty": 1.0,
                                          "price": 1.0,
                                          "orderid": 1,
                                          "discount": 3.0,
                                          "pic": "sample string 4",
                                          "tag": "sample string 5",
                                          "subtag": "sample string 6",
                                          "uom": "sample string 7",
                                          "t_standing_orders": {
                                            "$ref": "20"
                                          },
                                          "t_vendor_items": {
                                            "$ref": "1"
                                          }
                                        },
                                        {
                                          "$ref": "21"
                                        }
                                      ],
                                      "t_childs": {
                                        "$ref": "18"
                                      },
                                      "t_vendors": {
                                        "$ref": "5"
                                      }
                                    },
                                    {
                                      "$ref": "20"
                                    }
                                  ],
                                  "t_childs1": {
                                    "$ref": "18"
                                  },
                                  "t_childs2": {
                                    "$ref": "18"
                                  },
                                  "t_school_classes": {
                                    "$ref": "17"
                                  },
                                  "t_schools": {
                                    "$ref": "15"
                                  },
                                  "t_orders": [
                                    {
                                      "$id": "22",
                                      "id": 1,
                                      "schoolid": 2,
                                      "status": "sample string 3",
                                      "notes": "sample string 4",
                                      "type": "sample string 5",
                                      "pm": "sample string 6",
                                      "origin": "sample string 7",
                                      "payrefid": "sample string 8",
                                      "paynotes": "sample string 9",
                                      "paycurrency": "sample string 10",
                                      "paidtotal": 1.0,
                                      "emailsent": true,
                                      "dor": "2025-07-06T06:48:27.0675777+00:00",
                                      "dos": "2025-07-06T06:48:27.0675777+00:00",
                                      "childid": 1,
                                      "vendorid": 11,
                                      "staffid": 1,
                                      "token": "sample string 12",
                                      "classid": 1,
                                      "wallet_amt": 1.0,
                                      "change": 1.0,
                                      "adminnotes": "sample string 13",
                                      "credit_authrized": true,
                                      "cancelledby": "sample string 14",
                                      "datecancelled": "2025-07-06T06:48:27.0675777+00:00",
                                      "reason": "sample string 15",
                                      "createby": "sample string 16",
                                      "show_parents": true,
                                      "balance_reminders": true,
                                      "cancelled_date": "2025-07-06T06:48:27.0675777+00:00",
                                      "update_by": "sample string 19",
                                      "updatedate": "2025-07-06T06:48:27.0675777+00:00",
                                      "userid": 1,
                                      "mergeto": 1,
                                      "seq": 20,
                                      "orderref": "sample string 21",
                                      "email": "sample string 22",
                                      "guest_phone": "sample string 23",
                                      "guest_email": "sample string 24",
                                      "guest_name": "sample string 25",
                                      "tbl_id": 1,
                                      "t_childs": {
                                        "$ref": "18"
                                      },
                                      "t_order_payments": [
                                        {
                                          "$id": "23",
                                          "id": 1,
                                          "orderid": 1,
                                          "amount": 2.0,
                                          "narration": "sample string 3",
                                          "trandate": "2025-07-06T06:48:27.0675777+00:00",
                                          "tranby": "sample string 4",
                                          "pm": "sample string 5",
                                          "change": 6.0,
                                          "t_orders": {
                                            "$ref": "22"
                                          }
                                        },
                                        {
                                          "$ref": "23"
                                        }
                                      ],
                                      "t_orderentry": [
                                        {
                                          "$id": "24",
                                          "id": 1,
                                          "itemid": 1,
                                          "description": "sample string 2",
                                          "qty": 3.0,
                                          "price": 4.0,
                                          "orderid": 1,
                                          "pic": "sample string 5",
                                          "tag": "sample string 6",
                                          "subtag": "sample string 7",
                                          "oldorderid": 1,
                                          "discount": 8.0,
                                          "uom": "sample string 9",
                                          "t_orders": {
                                            "$ref": "22"
                                          },
                                          "t_vendor_items": {
                                            "$ref": "1"
                                          }
                                        },
                                        {
                                          "$ref": "24"
                                        }
                                      ],
                                      "t_users": {
                                        "$id": "25",
                                        "id": 1,
                                        "email": "sample string 2",
                                        "phone": "sample string 3",
                                        "password": "QEA=",
                                        "name": "sample string 4",
                                        "address": "sample string 5",
                                        "notes": "sample string 6",
                                        "type": "sample string 7",
                                        "notifyorders": true,
                                        "notifypromo": true,
                                        "notifylowbal": true,
                                        "status": "sample string 8",
                                        "lastlogin": "2025-07-06T06:48:27.0675777+00:00",
                                        "displayname": "sample string 9",
                                        "low_bal_point": 1.0,
                                        "createdate": "2025-07-06T06:48:27.0675777+00:00",
                                        "createby": "sample string 10",
                                        "avatar": "sample string 11",
                                        "token": "sample string 12",
                                        "device_token": "sample string 13",
                                        "device_id": "sample string 14",
                                        "device_type": "sample string 15",
                                        "mobile_notifications": true,
                                        "tpcode": "sample string 17",
                                        "seq": 18,
                                        "t_moe_users": [
                                          {
                                            "$id": "26",
                                            "id": 1,
                                            "moeid": 1,
                                            "userid": 1,
                                            "t_users": {
                                              "$ref": "25"
                                            },
                                            "t_moe": {
                                              "$ref": "12"
                                            }
                                          },
                                          {
                                            "$ref": "26"
                                          }
                                        ],
                                        "t_user_cards": [
                                          {
                                            "$id": "27",
                                            "id": 1,
                                            "user_id": 2,
                                            "card_holder": "sample string 3",
                                            "card_hash": "sample string 4",
                                            "card_id": "sample string 5",
                                            "is_default": 1,
                                            "created_at": "2025-07-06T06:48:27.0675777+00:00",
                                            "updated_at": "2025-07-06T06:48:27.0675777+00:00",
                                            "card_type": "sample string 6",
                                            "expiry": "sample string 7",
                                            "is_deleted": true,
                                            "currency": "sample string 8",
                                            "t_users": {
                                              "$ref": "25"
                                            }
                                          },
                                          {
                                            "$ref": "27"
                                          }
                                        ],
                                        "t_user_childs": [
                                          {
                                            "$id": "28",
                                            "child_id": 1,
                                            "user_id": 2,
                                            "id": 3,
                                            "relationship": "sample string 4",
                                            "court_order": "sample string 5",
                                            "t_users": {
                                              "$ref": "25"
                                            },
                                            "t_childs": {
                                              "$ref": "18"
                                            }
                                          },
                                          {
                                            "$ref": "28"
                                          }
                                        ],
                                        "t_notification": [
                                          {
                                            "$id": "29",
                                            "id": 1,
                                            "device_token": "sample string 2",
                                            "message": "sample string 3",
                                            "createdate": "2025-07-06T06:48:27.0675777+00:00",
                                            "createby": "sample string 4",
                                            "type": "sample string 5",
                                            "userid": 1,
                                            "subject": "sample string 6",
                                            "unread": true,
                                            "updateby": "sample string 8",
                                            "updatedate": "2025-07-06T06:48:27.0675777+00:00",
                                            "t_users": {
                                              "$ref": "25"
                                            }
                                          },
                                          {
                                            "$ref": "29"
                                          }
                                        ],
                                        "t_vendor_users": [
                                          {
                                            "$id": "30",
                                            "id": 1,
                                            "vendorid": 1,
                                            "userid": 1,
                                            "password": "QEA=",
                                            "first_name": "sample string 2",
                                            "last_name": "sample string 3",
                                            "t_users": {
                                              "$ref": "25"
                                            },
                                            "t_vendors": {
                                              "$ref": "5"
                                            }
                                          },
                                          {
                                            "$ref": "30"
                                          }
                                        ],
                                        "t_orders": [
                                          {
                                            "$ref": "22"
                                          },
                                          {
                                            "$ref": "22"
                                          }
                                        ],
                                        "t_item_reviews": [
                                          {
                                            "$id": "31",
                                            "id": 1,
                                            "comment": "sample string 2",
                                            "createdby": "sample string 3",
                                            "createddate": "2025-07-06T06:48:27.0675777+00:00",
                                            "parentid": 1,
                                            "itemid": 1,
                                            "userid": 1,
                                            "rating": 4.0,
                                            "approved": true,
                                            "t_item_reviews1": [
                                              {
                                                "$ref": "31"
                                              },
                                              {
                                                "$ref": "31"
                                              }
                                            ],
                                            "t_item_reviews2": {
                                              "$ref": "31"
                                            },
                                            "t_users": {
                                              "$ref": "25"
                                            },
                                            "t_vendor_items": {
                                              "$ref": "1"
                                            }
                                          },
                                          {
                                            "$ref": "31"
                                          }
                                        ]
                                      },
                                      "t_user_wallet": [
                                        {
                                          "$id": "32",
                                          "id": 1,
                                          "amount": 2.0,
                                          "narration": "sample string 3",
                                          "type": "sample string 4",
                                          "trandate": "2025-07-06T06:48:27.0675777+00:00",
                                          "tranby": "sample string 6",
                                          "pm": "sample string 7",
                                          "payref": "sample string 8",
                                          "currency": "sample string 9",
                                          "userid": 1,
                                          "vendorid": 1,
                                          "orderid": 1,
                                          "t_orders": {
                                            "$ref": "22"
                                          }
                                        },
                                        {
                                          "$ref": "32"
                                        }
                                      ],
                                      "t_vendors": {
                                        "$ref": "5"
                                      }
                                    },
                                    {
                                      "$ref": "22"
                                    }
                                  ],
                                  "t_user_childs": [
                                    {
                                      "$ref": "28"
                                    },
                                    {
                                      "$ref": "28"
                                    }
                                  ],
                                  "t_child_pickup_dropoff": [
                                    {
                                      "$id": "33",
                                      "id": 1,
                                      "childid": 1,
                                      "pddate": "2025-07-06T06:48:27.0675777+00:00",
                                      "type": "sample string 2",
                                      "sign_url": "sample string 3",
                                      "notes": "sample string 4",
                                      "admin_notes": "sample string 5",
                                      "status": "sample string 6",
                                      "createby": "sample string 7",
                                      "createdate": "2025-07-06T06:48:27.0675777+00:00",
                                      "updateby": "sample string 8",
                                      "updatedate": "2025-07-06T06:48:27.0675777+00:00",
                                      "schoolid": 1,
                                      "classid": 1,
                                      "sign_by": "sample string 9",
                                      "photo": "sample string 10",
                                      "t_childs": {
                                        "$ref": "18"
                                      },
                                      "t_school_classes": {
                                        "$ref": "17"
                                      },
                                      "t_schools": {
                                        "$ref": "15"
                                      }
                                    },
                                    {
                                      "$ref": "33"
                                    }
                                  ],
                                  "t_carts": [
                                    {
                                      "$id": "34",
                                      "id": 1,
                                      "cartid": "sample string 2",
                                      "prodid": 3,
                                      "qty": 4.0,
                                      "datecreated": "2025-07-06T06:48:27.0675777+00:00",
                                      "price": 6.0,
                                      "ilc": "sample string 7",
                                      "description": "sample string 8",
                                      "pic": "sample string 9",
                                      "saveforlater": true,
                                      "scheduledate": "2025-07-06T06:48:27.0675777+00:00",
                                      "childid": 1,
                                      "checkout": 1,
                                      "tag": "sample string 11",
                                      "vendorid": 12,
                                      "subtag": "sample string 13",
                                      "t_childs": {
                                        "$ref": "18"
                                      }
                                    },
                                    {
                                      "$ref": "34"
                                    }
                                  ]
                                },
                                {
                                  "$ref": "18"
                                }
                              ],
                              "t_child_pickup_dropoff": [
                                {
                                  "$ref": "33"
                                },
                                {
                                  "$ref": "33"
                                }
                              ]
                            },
                            "t_schools": {
                              "$ref": "15"
                            }
                          },
                          {
                            "$ref": "16"
                          }
                        ],
                        "t_moe_schools": [
                          {
                            "$ref": "14"
                          },
                          {
                            "$ref": "14"
                          }
                        ],
                        "t_school_childs": [
                          {
                            "$ref": "19"
                          },
                          {
                            "$ref": "19"
                          }
                        ],
                        "t_school_classes": [
                          {
                            "$ref": "17"
                          },
                          {
                            "$ref": "17"
                          }
                        ],
                        "t_vendor_schools": [
                          {
                            "$id": "35",
                            "id": 1,
                            "schoolid": 2,
                            "vendorid": 3,
                            "active": 1,
                            "t_schools": {
                              "$ref": "15"
                            },
                            "t_vendors": {
                              "$ref": "5"
                            }
                          },
                          {
                            "$ref": "35"
                          }
                        ],
                        "t_childs": [
                          {
                            "$ref": "18"
                          },
                          {
                            "$ref": "18"
                          }
                        ],
                        "t_child_pickup_dropoff": [
                          {
                            "$ref": "33"
                          },
                          {
                            "$ref": "33"
                          }
                        ],
                        "t_item_categories": [
                          {
                            "$id": "36",
                            "id": 1,
                            "name": "sample string 2",
                            "description": "sample string 3",
                            "pic": "sample string 4",
                            "displayorder": 1,
                            "active": true,
                            "type": "sample string 5",
                            "vendorid": 6,
                            "parent_id": 1,
                            "schoolid": 1,
                            "t_vendor_items": [
                              {
                                "$ref": "1"
                              },
                              {
                                "$ref": "1"
                              }
                            ],
                            "t_schools": {
                              "$ref": "15"
                            }
                          },
                          {
                            "$ref": "36"
                          }
                        ],
                        "t_waitlist": [
                          {
                            "$id": "37",
                            "id": 1,
                            "schoolid": 1,
                            "referred": true,
                            "referred_by": "sample string 2",
                            "first_name": "sample string 3",
                            "last_name": "sample string 4",
                            "initial": "sample string 5",
                            "dob": "2025-07-06T06:48:27.0675777+00:00",
                            "sex": "sample string 6",
                            "fulltime": true,
                            "meals": true,
                            "grade": "sample string 7",
                            "parent_name": "sample string 8",
                            "parent_email": "sample string 9",
                            "parent_phone": "sample string 10",
                            "parent_address": "sample string 11",
                            "parent_country": "sample string 12",
                            "createby": "sample string 13",
                            "createdate": "2025-07-06T06:48:27.0675777+00:00",
                            "vendorid": 1,
                            "client_ip": "sample string 14",
                            "time_stamp": "2025-07-06T06:48:27.0675777+00:00",
                            "verified": true,
                            "publicid": "sample string 17",
                            "t_schools": {
                              "$ref": "15"
                            },
                            "t_vendors": {
                              "$ref": "5"
                            }
                          },
                          {
                            "$ref": "37"
                          }
                        ]
                      },
                      "t_moe": {
                        "$ref": "12"
                      }
                    },
                    {
                      "$ref": "14"
                    }
                  ],
                  "t_moe_staffs": [
                    {
                      "$id": "38",
                      "id": 1,
                      "name": "sample string 2",
                      "avatar": "sample string 3",
                      "email": "sample string 4",
                      "phone": "sample string 5",
                      "password": "QEA=",
                      "token": "sample string 6",
                      "moeid": 7,
                      "status": "sample string 8",
                      "pospin": "sample string 9",
                      "t_moe": {
                        "$ref": "12"
                      }
                    },
                    {
                      "$ref": "38"
                    }
                  ],
                  "t_moe_users": [
                    {
                      "$ref": "26"
                    },
                    {
                      "$ref": "26"
                    }
                  ],
                  "t_moe_vendors": [
                    {
                      "$ref": "11"
                    },
                    {
                      "$ref": "11"
                    }
                  ]
                },
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "11"
              }
            ],
            "t_orders": [
              {
                "$ref": "22"
              },
              {
                "$ref": "22"
              }
            ],
            "t_pohdr": [
              {
                "$id": "39",
                "id": 1,
                "pon": "sample string 2",
                "seq": 3,
                "supplierid": 1,
                "podate": "2025-07-06T06:48:27.0833388+00:00",
                "duedate": "2025-07-06T06:48:27.0833388+00:00",
                "terms": "sample string 4",
                "notes": "sample string 5",
                "vendorid": 1,
                "status": "sample string 6",
                "type": "sample string 7",
                "receivedby": "sample string 8",
                "receiveddate": "2025-07-06T06:48:27.0833388+00:00",
                "invoiceno": "sample string 9",
                "currency": "sample string 10",
                "roe": 11.0,
                "createby": "sample string 12",
                "createdate": "2025-07-06T06:48:27.0833388+00:00",
                "updateby": "sample string 13",
                "updatedate": "2025-07-06T06:48:27.0833388+00:00",
                "shipto": 1,
                "t_poentry": [
                  {
                    "$id": "40",
                    "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_pohdr": {
                      "$ref": "39"
                    },
                    "t_vendor_items": {
                      "$ref": "1"
                    }
                  },
                  {
                    "$ref": "40"
                  }
                ],
                "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_pohdr": [
                    {
                      "$ref": "39"
                    },
                    {
                      "$ref": "39"
                    }
                  ],
                  "t_vendors": {
                    "$ref": "5"
                  }
                },
                "t_suppliers": {
                  "$id": "42",
                  "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": "39"
                    },
                    {
                      "$ref": "39"
                    }
                  ]
                },
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "39"
              }
            ],
            "t_quiz": [
              {
                "$id": "43",
                "id": 1,
                "starttime": "2025-07-06T06:48:27.0833388+00:00",
                "endtime": "2025-07-06T06:48:27.0833388+00:00",
                "duration": "00:00:00.1234567",
                "score": 2.0,
                "assid": 1,
                "trainee": "sample string 3",
                "status": "sample string 4",
                "enrollement_id": 1,
                "enrollement_trainee_id": 1,
                "results": "sample string 5",
                "vendorid": 1,
                "t_assesment": {
                  "$id": "44",
                  "id": 1,
                  "name": "sample string 2",
                  "details": "sample string 3",
                  "video_link": "sample string 4",
                  "create_date": "2025-07-06T06:48:27.0833388+00:00",
                  "createby": "sample string 5",
                  "update_date": "2025-07-06T06:48:27.0833388+00:00",
                  "updateby": "sample string 6",
                  "lang": "sample string 7",
                  "type": "sample string 8",
                  "token": "156ea9d8-3595-4108-a117-b7b0e4660322",
                  "passing_score": 9.0,
                  "min_quiz_question": 10,
                  "active": true,
                  "vendorid": 1,
                  "t_assesment_enrollments": [
                    {
                      "$id": "45",
                      "id": 1,
                      "assid": 1,
                      "price": 1.0,
                      "email": "sample string 2",
                      "access_code": "sample string 3",
                      "access_code_expiry": "2025-07-06T06:48:27.0833388+00:00",
                      "status": "sample string 4",
                      "start_date": "2025-07-06T06:48:27.0833388+00:00",
                      "completion_date": "2025-07-06T06:48:27.0833388+00:00",
                      "name": "sample string 5",
                      "public_token": "sample string 6",
                      "lang": "sample string 7",
                      "discount_code": "sample string 8",
                      "type": "sample string 9",
                      "createdate": "2025-07-06T06:48:27.0833388+00:00",
                      "vendorid": 1,
                      "t_assesment": {
                        "$ref": "44"
                      },
                      "t_assesment1": {
                        "$ref": "44"
                      },
                      "t_quiz": [
                        {
                          "$ref": "43"
                        },
                        {
                          "$ref": "43"
                        }
                      ]
                    },
                    {
                      "$ref": "45"
                    }
                  ],
                  "t_assesment_enrollments1": [
                    {
                      "$ref": "45"
                    },
                    {
                      "$ref": "45"
                    }
                  ],
                  "t_assesment_resources": [
                    {
                      "$id": "46",
                      "id": 1,
                      "assid": 1,
                      "type": "sample string 2",
                      "name": "sample string 3",
                      "details": "sample string 4",
                      "create_date": "2025-07-06T06:48:27.0833388+00:00",
                      "createby": "sample string 5",
                      "update_date": "2025-07-06T06:48:27.0833388+00:00",
                      "updateby": "sample string 6",
                      "display_order": 7,
                      "t_assesment": {
                        "$ref": "44"
                      },
                      "t_assesment1": {
                        "$ref": "44"
                      }
                    },
                    {
                      "$ref": "46"
                    }
                  ],
                  "t_assesment_resources1": [
                    {
                      "$ref": "46"
                    },
                    {
                      "$ref": "46"
                    }
                  ],
                  "t_assesment_sections": [
                    {
                      "$id": "47",
                      "id": 1,
                      "assid": 1,
                      "name": "sample string 2",
                      "details": "sample string 3",
                      "video_link": "sample string 4",
                      "create_date": "2025-07-06T06:48:27.0833388+00:00",
                      "createby": "sample string 5",
                      "update_date": "2025-07-06T06:48:27.0833388+00:00",
                      "updateby": "sample string 6",
                      "display_order": 7,
                      "t_assesment": {
                        "$ref": "44"
                      },
                      "t_assesment1": {
                        "$ref": "44"
                      }
                    },
                    {
                      "$ref": "47"
                    }
                  ],
                  "t_assesment_sections1": [
                    {
                      "$ref": "47"
                    },
                    {
                      "$ref": "47"
                    }
                  ],
                  "t_quiz": [
                    {
                      "$ref": "43"
                    },
                    {
                      "$ref": "43"
                    }
                  ],
                  "t_quiz1": [
                    {
                      "$ref": "43"
                    },
                    {
                      "$ref": "43"
                    }
                  ]
                },
                "t_assesment1": {
                  "$ref": "44"
                },
                "t_assesment_enrollments": {
                  "$ref": "45"
                },
                "t_quiz_attempts": [
                  {
                    "$id": "48",
                    "id": 1,
                    "quizid": 1,
                    "starttime": "2025-07-06T06:48:27.0833388+00:00",
                    "endtime": "2025-07-06T06:48:27.0833388+00:00",
                    "duration": "00:00:00.1234567",
                    "score": 2.0,
                    "results": "sample string 3",
                    "t_quiz": {
                      "$ref": "43"
                    }
                  },
                  {
                    "$ref": "48"
                  }
                ],
                "t_quiz_question": [
                  {
                    "$id": "49",
                    "id": 1,
                    "quizid": 1,
                    "questionid": 1,
                    "score": 2.0,
                    "t_question": {
                      "$id": "50",
                      "id": 1,
                      "questiontext": "sample string 2",
                      "multiple_choice": true,
                      "score": 4.0,
                      "assesment_types": "sample string 5",
                      "vendorid": 1,
                      "lang": "sample string 6",
                      "t_answer": [
                        {
                          "$id": "51",
                          "id": 1,
                          "answertext": "sample string 2",
                          "question_id": 1,
                          "t_question": {
                            "$ref": "50"
                          }
                        },
                        {
                          "$ref": "51"
                        }
                      ],
                      "t_answerchoice": [
                        {
                          "$id": "52",
                          "id": 1,
                          "choices": "sample string 2",
                          "question_id": 1,
                          "t_question": {
                            "$ref": "50"
                          }
                        },
                        {
                          "$ref": "52"
                        }
                      ],
                      "t_quiz_question": [
                        {
                          "$ref": "49"
                        },
                        {
                          "$ref": "49"
                        }
                      ]
                    },
                    "t_quiz": {
                      "$ref": "43"
                    }
                  },
                  {
                    "$ref": "49"
                  }
                ],
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "43"
              }
            ],
            "t_staff_payroll": [
              {
                "$id": "53",
                "id": 1,
                "from_date": "2025-07-06T06:48:27.0833388+00:00",
                "to_date": "2025-07-06T06:48:27.0833388+00:00",
                "payroll_date": "2025-07-06T06:48:27.0833388+00:00",
                "createby": "sample string 2",
                "createdate": "2025-07-06T06:48:27.0833388+00:00",
                "updateby": "sample string 3",
                "updatedate": "2025-07-06T06:48:27.0833388+00:00",
                "seq": 4,
                "num": "sample string 5",
                "status": "sample string 6",
                "notes": "sample string 7",
                "vendorid": 8,
                "finyr": "sample string 9",
                "t_staff_payrollentry": [
                  {
                    "$id": "54",
                    "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,
                    "adj": 16.0,
                    "sick_hrs": 17.0,
                    "vacation_hrs": 18.0,
                    "reimbursement": 19.0,
                    "t_staff_payroll": {
                      "$ref": "53"
                    },
                    "t_vendor_staffs": {
                      "$id": "55",
                      "id": 1,
                      "name": "sample string 2",
                      "avatar": "sample string 3",
                      "email": "sample string 4",
                      "phone": "sample string 5",
                      "password": "QEA=",
                      "token": "sample string 6",
                      "vendorid": 7,
                      "status": "sample string 8",
                      "pospin": "sample string 9",
                      "mop": "sample string 10",
                      "pic": "sample string 11",
                      "bio": "sample string 12",
                      "show_on_website": true,
                      "job_title": "sample string 14",
                      "paidoffdaysperyr": 1,
                      "paidsickdaysperyr": 1,
                      "inout": "sample string 15",
                      "emp_code": "sample string 16",
                      "regular_pay_rate": 17.0,
                      "overtime_pay_rate": 18.0,
                      "health_insurance_total": 19.0,
                      "health_insurance_num": "sample string 20",
                      "health_insurance_company": "sample string 21",
                      "health_insurnace_per_payroll": 22.0,
                      "work_permit_holder": true,
                      "work_permit_num": "sample string 24",
                      "work_permit_expiry": "2025-07-06T06:48:27.0833388+00:00",
                      "dob": "2025-07-06T06:48:27.0833388+00:00",
                      "dept": "sample string 25",
                      "pension": true,
                      "health_insurnace_contri_type": "sample string 27",
                      "health_insurance_pay_schedule": "sample string 28",
                      "health_insurnace_vendor_contri": 29.0,
                      "health_insurnace_staff_contri": 30.0,
                      "pension_contri_type": "sample string 31",
                      "pension_vendor_contri": 32.0,
                      "pension_staff_contri": 33.0,
                      "shift_id": 1,
                      "pension_num": "sample string 34",
                      "pension_company": "sample string 35",
                      "health_insurance_dep_contri": 36.0,
                      "reimburse_health_insurance": true,
                      "pay_type": "sample string 38",
                      "compulsory_hrs": 39.0,
                      "address": "sample string 40",
                      "country": "sample string 41",
                      "t_leaves": [
                        {
                          "$id": "56",
                          "id": 1,
                          "staff_id": 1,
                          "fromdate": "2025-07-06T06:48:27.0833388+00:00",
                          "todate": "2025-07-06T06:48:27.0833388+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-07-06T06:48:27.0833388+00:00",
                          "createby": "sample string 8",
                          "upadatedate": "2025-07-06T06:48:27.0833388+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_vendor_staffs": {
                            "$ref": "55"
                          }
                        },
                        {
                          "$ref": "56"
                        }
                      ],
                      "t_staffs_reminders": [
                        {
                          "$id": "57",
                          "id": 1,
                          "name": "sample string 2",
                          "description": "sample string 3",
                          "createby": "sample string 4",
                          "createdate": "2025-07-06T06:48:27.0988144+00:00",
                          "updateby": "sample string 5",
                          "updatedate": "2025-07-06T06:48:27.0988144+00:00",
                          "active": true,
                          "enddate": "2025-07-06T06:48:27.0988144+00:00",
                          "staff_id": 1,
                          "start_date": "2025-07-06T06:48:27.0988144+00:00",
                          "duedate": "2025-07-06T06:48:27.0988144+00:00",
                          "emp_dept_section": "sample string 6",
                          "pic": "sample string 7",
                          "vendorid": 8,
                          "t_vendor_staffs": {
                            "$ref": "55"
                          }
                        },
                        {
                          "$ref": "57"
                        }
                      ],
                      "t_staffs_shifts": [
                        {
                          "$id": "58",
                          "id": 1,
                          "staff_id": 2,
                          "start_time": "sample string 3",
                          "end_time": "sample string 4",
                          "deleted_at": "2025-07-06T06:48:27.0988144+00:00",
                          "created_at": "2025-07-06T06:48:27.0988144+00:00",
                          "updated_at": "2025-07-06T06:48:27.0988144+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,
                          "lat": "sample string 12",
                          "lng": "sample string 13",
                          "shiftid": 1,
                          "t_staffs_shift_timings": [
                            {
                              "$id": "59",
                              "id": 1,
                              "staff_shift_id": 2,
                              "start_time": "sample string 3",
                              "end_time": "sample string 4",
                              "order_count": 5,
                              "created_at": "2025-07-06T06:48:27.0988144+00:00",
                              "updated_at": "2025-07-06T06:48:27.0988144+00:00",
                              "deleted_at": "2025-07-06T06:48:27.0988144+00:00",
                              "type": "sample string 6",
                              "reason": "sample string 7",
                              "t_staffs_shifts": {
                                "$ref": "58"
                              }
                            },
                            {
                              "$ref": "59"
                            }
                          ],
                          "t_vendor_staffs": {
                            "$ref": "55"
                          }
                        },
                        {
                          "$ref": "58"
                        }
                      ],
                      "t_staff_roster": [
                        {
                          "$id": "60",
                          "id": 1,
                          "staffid": 1,
                          "dos": "2025-07-06T06:48:27.0988144+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-07-06T06:48:27.0988144+00:00",
                          "vendorid": 8,
                          "notes": "sample string 9",
                          "reason": "sample string 10",
                          "t_vendor_routes": {
                            "$id": "61",
                            "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_staff_roster": [
                              {
                                "$ref": "60"
                              },
                              {
                                "$ref": "60"
                              }
                            ]
                          },
                          "t_vendor_staffs": {
                            "$ref": "55"
                          }
                        },
                        {
                          "$ref": "60"
                        }
                      ],
                      "t_staff_payrollentry": [
                        {
                          "$ref": "54"
                        },
                        {
                          "$ref": "54"
                        }
                      ],
                      "t_vendors": {
                        "$ref": "5"
                      }
                    }
                  },
                  {
                    "$ref": "54"
                  }
                ],
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "53"
              }
            ],
            "t_standing_orders": [
              {
                "$ref": "20"
              },
              {
                "$ref": "20"
              }
            ],
            "t_vendor_accomplishment": [
              {
                "$id": "62",
                "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": "5"
                }
              },
              {
                "$ref": "62"
              }
            ],
            "t_vendor_announcements": [
              {
                "$id": "63",
                "id": 1,
                "vendorid": 1,
                "description": "sample string 2",
                "heading": "sample string 3",
                "display_order": 4,
                "active": true,
                "createby": "sample string 6",
                "createdate": "2025-07-06T06:48:27.0988144+00:00",
                "updateby": "sample string 7",
                "updatedate": "2025-07-06T06:48:27.0988144+00:00",
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "63"
              }
            ],
            "t_vendor_banners": [
              {
                "$id": "64",
                "id": 1,
                "vendorid": 1,
                "file_url": "sample string 2",
                "createby": "sample string 3",
                "createdate": "2025-07-06T06:48:27.0988144+00:00",
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "64"
              }
            ],
            "t_vendor_blocked_dates": [
              {
                "$id": "65",
                "id": 1,
                "vendorid": 2,
                "dateblocked": "2025-07-06T06:48:27.0988144+00:00",
                "reason": "sample string 4",
                "tbl_id": 1,
                "t_tables": {
                  "$id": "66",
                  "id": 1,
                  "code": "sample string 2",
                  "name": "sample string 3",
                  "createby": "sample string 4",
                  "createdate": "2025-07-06T06:48:27.0988144+00:00",
                  "updateby": "sample string 5",
                  "updatedate": "2025-07-06T06:48:27.0988144+00:00",
                  "location": "sample string 6",
                  "active": true,
                  "vendorid": 1,
                  "max_capacity": 8,
                  "min_capacity": 9,
                  "routeid": 1,
                  "t_vendor_blocked_dates": [
                    {
                      "$ref": "65"
                    },
                    {
                      "$ref": "65"
                    }
                  ],
                  "t_vendor_blocked_time_slots": [
                    {
                      "$id": "67",
                      "id": 1,
                      "vendorid": 2,
                      "ondate": "2025-07-06T06:48:27.0988144+00:00",
                      "hrs": 1.0,
                      "reason": "sample string 4",
                      "tbl_id": 1,
                      "t_tables": {
                        "$ref": "66"
                      },
                      "t_vendors": {
                        "$ref": "5"
                      }
                    },
                    {
                      "$ref": "67"
                    }
                  ]
                },
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "65"
              }
            ],
            "t_vendor_blocked_time_slots": [
              {
                "$ref": "67"
              },
              {
                "$ref": "67"
              }
            ],
            "t_vendor_devices": [
              {
                "$id": "68",
                "id": 1,
                "vendorid": 2,
                "device_token": "sample string 3",
                "doe": "2025-07-06T06:48:27.0988144+00:00",
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "68"
              }
            ],
            "t_vendor_discount_structures": [
              {
                "$id": "69",
                "id": 1,
                "spend_upto": 1.0,
                "discount": 1.0,
                "vendorid": 1,
                "orderby": 1,
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "69"
              }
            ],
            "t_vendor_items": [
              {
                "$ref": "1"
              },
              {
                "$ref": "1"
              }
            ],
            "t_vendor_schools": [
              {
                "$ref": "35"
              },
              {
                "$ref": "35"
              }
            ],
            "t_vendor_shipto": [
              {
                "$ref": "41"
              },
              {
                "$ref": "41"
              }
            ],
            "t_vendor_staffs": [
              {
                "$ref": "55"
              },
              {
                "$ref": "55"
              }
            ],
            "t_vendor_terms": [
              {
                "$id": "70",
                "id": 1,
                "description": "sample string 2",
                "createdate": "2025-07-06T06:48:27.0988144+00:00",
                "createby": "sample string 3",
                "updateby": "sample string 4",
                "updatedate": "2025-07-06T06:48:27.0988144+00:00",
                "vendorid": 1,
                "t_vendors": {
                  "$ref": "5"
                }
              },
              {
                "$ref": "70"
              }
            ],
            "t_vendor_users": [
              {
                "$ref": "30"
              },
              {
                "$ref": "30"
              }
            ],
            "t_waitlist": [
              {
                "$ref": "37"
              },
              {
                "$ref": "37"
              }
            ]
          }
        },
        "t_invoiceentry": [
          {
            "$ref": "2"
          },
          {
            "$ref": "2"
          }
        ],
        "t_vendors": {
          "$ref": "5"
        }
      },
      "t_vendor_items": {
        "$ref": "1"
      }
    },
    {
      "$ref": "2"
    }
  ],
  "t_item_addons": [
    {
      "$id": "71",
      "id": 1,
      "main_itemid": 2,
      "itemid": 3,
      "price": 1.0,
      "maxallowed": 1,
      "minallowed": 1,
      "active": true,
      "pos_only": true,
      "t_vendor_items": {
        "$ref": "1"
      },
      "t_vendor_items1": {
        "$ref": "1"
      }
    },
    {
      "$ref": "71"
    }
  ],
  "t_item_addons1": [
    {
      "$ref": "71"
    },
    {
      "$ref": "71"
    }
  ],
  "t_item_bins": [
    {
      "$id": "72",
      "id": 1,
      "itemid": 1,
      "vendorid": 2,
      "cnt": 1.0,
      "binid": 1,
      "t_binlocations": {
        "$id": "73",
        "id": 1,
        "code": "sample string 2",
        "description": "sample string 3",
        "active": true,
        "createby": "sample string 4",
        "createdate": "2025-07-06T06:48:27.0988144+00:00",
        "updateby": "sample string 5",
        "updatedate": "2025-07-06T06:48:27.0988144+00:00",
        "vendorid": 6,
        "lvl": "sample string 7",
        "sec": "sample string 8",
        "bintype": "sample string 9",
        "t_item_transactions": [
          {
            "$id": "74",
            "id": 1,
            "itemid": 1,
            "qty": 2.0,
            "refno": "sample string 3",
            "txndate": "2025-07-06T06:48:27.0988144+00:00",
            "tranby": "sample string 4",
            "txntype": "sample string 5",
            "notes": "sample string 6",
            "binid": 1,
            "uom": "sample string 7",
            "t_binlocations": {
              "$ref": "73"
            },
            "t_vendor_items": {
              "$ref": "1"
            }
          },
          {
            "$ref": "74"
          }
        ],
        "t_item_bins": [
          {
            "$ref": "72"
          },
          {
            "$ref": "72"
          }
        ]
      },
      "t_vendor_items": {
        "$ref": "1"
      }
    },
    {
      "$ref": "72"
    }
  ],
  "t_item_categories": {
    "$ref": "36"
  },
  "t_item_pics": [
    {
      "$id": "75",
      "id": 1,
      "url": "sample string 2",
      "createby": "sample string 3",
      "createdate": "2025-07-06T06:48:27.0988144+00:00",
      "updateby": "sample string 4",
      "updatedate": "2025-07-06T06:48:27.0988144+00:00",
      "active": true,
      "itemid": 1,
      "display_order": 6,
      "t_vendor_items": {
        "$ref": "1"
      }
    },
    {
      "$ref": "75"
    }
  ],
  "t_item_pricinglog": [
    {
      "$id": "76",
      "id": 1,
      "itemid": 1,
      "cost": 1.0,
      "price": 1.0,
      "doe": "2025-07-06T06:48:27.0988144+00:00",
      "eby": "sample string 2",
      "notes": "sample string 3",
      "t_vendor_items": {
        "$ref": "1"
      }
    },
    {
      "$ref": "76"
    }
  ],
  "t_item_reviews": [
    {
      "$ref": "31"
    },
    {
      "$ref": "31"
    }
  ],
  "t_item_timings": [
    {
      "$id": "77",
      "id": 1,
      "itemid": 1,
      "dayavail": "sample string 2",
      "startdate": "2025-07-06T06:48:27.0988144+00:00",
      "enddate": "2025-07-06T06:48:27.0988144+00:00",
      "hideprice": true,
      "displayorder": 1,
      "t_vendor_items": {
        "$ref": "1"
      }
    },
    {
      "$ref": "77"
    }
  ],
  "t_item_transactions": [
    {
      "$ref": "74"
    },
    {
      "$ref": "74"
    }
  ],
  "t_orderentry": [
    {
      "$ref": "24"
    },
    {
      "$ref": "24"
    }
  ],
  "t_poentry": [
    {
      "$ref": "40"
    },
    {
      "$ref": "40"
    }
  ],
  "t_standing_orderentry": [
    {
      "$ref": "21"
    },
    {
      "$ref": "21"
    }
  ],
  "t_item_details": [
    {
      "$id": "78",
      "id": 1,
      "display_order": 2,
      "createby": "sample string 3",
      "createdate": "2025-07-06T06:48:27.0988144+00:00",
      "updateby": "sample string 4",
      "updatedate": "2025-07-06T06:48:27.0988144+00:00",
      "active": true,
      "itemid": 1,
      "detail_type": "sample string 6",
      "detail_type_hdr": "sample string 7",
      "detail_type_val": "sample string 8",
      "t_vendor_items": {
        "$ref": "1"
      }
    },
    {
      "$ref": "78"
    }
  ],
  "t_vendors": {
    "$ref": "5"
  }
}