GET api/Data/Gett_vendor_items/{id}
This is to get food vendor items by vendor id
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Vendor id |
integer |
Required |
Body Parameters
None.
Response Information
Resource Description
List of items
t_vendor_items| Name | Description | Type | Additional 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_vendors | t_vendors |
None. |
|
| t_item_details | Collection of t_item_details |
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-04-04T00:23:56.0588645+00:00",
"dateofexpiry": "2025-04-04T00:23:56.0588645+00:00",
"frontpage": true,
"displayorder": 1,
"barcode": "sample string 10",
"subtag": "sample string 11",
"inventory": true,
"seq": 13,
"tpcode": "sample string 14",
"dateupdated": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"vendorid": 4,
"schoolid": 5,
"adminnotes": "sample string 6",
"createby": "sample string 7",
"update_by": "sample string 8",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"seq": 9,
"invno": "sample string 10",
"customerid": 11,
"duedate": "2025-04-04T00:23:56.0588645+00:00",
"terms": "sample string 12",
"createdate": "2025-04-04T00:23:56.0588645+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_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-04-04T00:23:56.0588645+00:00",
"enddate": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+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",
"t_moe_vendors": [
{
"$id": "6",
"id": 1,
"moeid": 1,
"vendorid": 2,
"active": true,
"t_moe": {
"$id": "7",
"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-04-04T00:23:56.0588645+00:00",
"status": "sample string 10",
"startdate": "2025-04-04T00:23:56.0588645+00:00",
"enddate": "2025-04-04T00:23:56.0588645+00:00",
"poc": "sample string 11",
"email_group": "sample string 12",
"notify_newsignups": true,
"supportemail": "sample string 13",
"privacy_policy": "sample string 14",
"t_moe_schools": [
{
"$id": "8",
"id": 1,
"moeid": 1,
"schoolid": 1,
"active": true,
"t_moe": {
"$ref": "7"
},
"t_schools": {
"$id": "9",
"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",
"t_class_teachers": [
{
"$id": "10",
"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": "11",
"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": "10"
},
{
"$ref": "10"
}
],
"t_schools": {
"$ref": "9"
},
"t_childs": [
{
"$id": "12",
"id": 1,
"schoolid": 2,
"classid": 3,
"name": "sample string 4",
"qrcode": "sample string 5",
"code": "sample string 6",
"upn": "sample string 7",
"dob": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"deletedate": "2025-04-04T00:23:56.0588645+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",
"t_carts": [
{
"$id": "13",
"id": 1,
"cartid": "sample string 2",
"prodid": 3,
"qty": 4.0,
"datecreated": "2025-04-04T00:23:56.0588645+00:00",
"price": 6.0,
"ilc": "sample string 7",
"description": "sample string 8",
"pic": "sample string 9",
"saveforlater": true,
"scheduledate": "2025-04-04T00:23:56.0588645+00:00",
"childid": 1,
"checkout": 1,
"tag": "sample string 11",
"vendorid": 12,
"subtag": "sample string 13",
"t_childs": {
"$ref": "12"
}
},
{
"$ref": "13"
}
],
"t_school_childs": [
{
"$id": "14",
"childid": 1,
"schoolid": 1,
"id": 1,
"t_schools": {
"$ref": "9"
},
"t_childs": {
"$ref": "12"
}
},
{
"$ref": "14"
}
],
"t_standing_orders": [
{
"$id": "15",
"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-04-04T00:23:56.0588645+00:00",
"createby": "sample string 7",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 8",
"t_standing_orderentry": [
{
"$id": "16",
"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": "15"
},
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "16"
}
],
"t_vendors": {
"$ref": "5"
},
"t_childs": {
"$ref": "12"
}
},
{
"$ref": "15"
}
],
"t_childs1": {
"$ref": "12"
},
"t_childs2": {
"$ref": "12"
},
"t_school_classes": {
"$ref": "11"
},
"t_schools": {
"$ref": "9"
},
"t_orders": [
{
"$id": "17",
"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-04-04T00:23:56.0588645+00:00",
"dos": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"reason": "sample string 15",
"createby": "sample string 16",
"show_parents": true,
"balance_reminders": true,
"cancelled_date": "2025-04-04T00:23:56.0588645+00:00",
"update_by": "sample string 19",
"updatedate": "2025-04-04T00:23:56.0588645+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": "12"
},
"t_order_payments": [
{
"$id": "18",
"id": 1,
"orderid": 1,
"amount": 2.0,
"narration": "sample string 3",
"trandate": "2025-04-04T00:23:56.0588645+00:00",
"tranby": "sample string 4",
"pm": "sample string 5",
"change": 6.0,
"t_orders": {
"$ref": "17"
}
},
{
"$ref": "18"
}
],
"t_orderentry": [
{
"$id": "19",
"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": "17"
},
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "19"
}
],
"t_users": {
"$id": "20",
"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-04-04T00:23:56.0588645+00:00",
"displayname": "sample string 9",
"low_bal_point": 1.0,
"createdate": "2025-04-04T00:23:56.0588645+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": "21",
"id": 1,
"moeid": 1,
"userid": 1,
"t_moe": {
"$ref": "7"
},
"t_users": {
"$ref": "20"
}
},
{
"$ref": "21"
}
],
"t_user_cards": [
{
"$id": "22",
"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-04-04T00:23:56.0588645+00:00",
"updated_at": "2025-04-04T00:23:56.0588645+00:00",
"card_type": "sample string 6",
"expiry": "sample string 7",
"is_deleted": true,
"currency": "sample string 8",
"t_users": {
"$ref": "20"
}
},
{
"$ref": "22"
}
],
"t_user_childs": [
{
"$id": "23",
"child_id": 1,
"user_id": 2,
"id": 3,
"relationship": "sample string 4",
"court_order": "sample string 5",
"t_users": {
"$ref": "20"
},
"t_childs": {
"$ref": "12"
}
},
{
"$ref": "23"
}
],
"t_notification": [
{
"$id": "24",
"id": 1,
"device_token": "sample string 2",
"message": "sample string 3",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 4",
"type": "sample string 5",
"userid": 1,
"subject": "sample string 6",
"unread": true,
"updateby": "sample string 8",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"t_users": {
"$ref": "20"
}
},
{
"$ref": "24"
}
],
"t_vendor_users": [
{
"$id": "25",
"id": 1,
"vendorid": 1,
"userid": 1,
"password": "QEA=",
"first_name": "sample string 2",
"last_name": "sample string 3",
"t_vendors": {
"$ref": "5"
},
"t_users": {
"$ref": "20"
}
},
{
"$ref": "25"
}
],
"t_orders": [
{
"$ref": "17"
},
{
"$ref": "17"
}
],
"t_item_reviews": [
{
"$id": "26",
"id": 1,
"comment": "sample string 2",
"createdby": "sample string 3",
"createddate": "2025-04-04T00:23:56.0588645+00:00",
"parentid": 1,
"itemid": 1,
"userid": 1,
"rating": 4.0,
"approved": true,
"t_item_reviews1": [
{
"$ref": "26"
},
{
"$ref": "26"
}
],
"t_item_reviews2": {
"$ref": "26"
},
"t_users": {
"$ref": "20"
},
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "26"
}
]
},
"t_vendors": {
"$ref": "5"
},
"t_user_wallet": [
{
"$id": "27",
"id": 1,
"amount": 2.0,
"narration": "sample string 3",
"type": "sample string 4",
"trandate": "2025-04-04T00:23:56.0588645+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": "17"
}
},
{
"$ref": "27"
}
]
},
{
"$ref": "17"
}
],
"t_user_childs": [
{
"$ref": "23"
},
{
"$ref": "23"
}
],
"t_child_pickup_dropoff": [
{
"$id": "28",
"id": 1,
"childid": 1,
"pddate": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 8",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"schoolid": 1,
"classid": 1,
"sign_by": "sample string 9",
"photo": "sample string 10",
"t_childs": {
"$ref": "12"
},
"t_school_classes": {
"$ref": "11"
},
"t_schools": {
"$ref": "9"
}
},
{
"$ref": "28"
}
]
},
{
"$ref": "12"
}
],
"t_child_pickup_dropoff": [
{
"$ref": "28"
},
{
"$ref": "28"
}
]
},
"t_schools": {
"$ref": "9"
}
},
{
"$ref": "10"
}
],
"t_moe_schools": [
{
"$ref": "8"
},
{
"$ref": "8"
}
],
"t_school_childs": [
{
"$ref": "14"
},
{
"$ref": "14"
}
],
"t_school_classes": [
{
"$ref": "11"
},
{
"$ref": "11"
}
],
"t_waitlist": [
{
"$id": "29",
"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-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"vendorid": 1,
"t_vendors": {
"$ref": "5"
},
"t_schools": {
"$ref": "9"
}
},
{
"$ref": "29"
}
],
"t_vendor_schools": [
{
"$id": "30",
"id": 1,
"schoolid": 2,
"vendorid": 3,
"active": 1,
"t_vendors": {
"$ref": "5"
},
"t_schools": {
"$ref": "9"
}
},
{
"$ref": "30"
}
],
"t_childs": [
{
"$ref": "12"
},
{
"$ref": "12"
}
],
"t_child_pickup_dropoff": [
{
"$ref": "28"
},
{
"$ref": "28"
}
]
}
},
{
"$ref": "8"
}
],
"t_moe_staffs": [
{
"$id": "31",
"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": "7"
}
},
{
"$ref": "31"
}
],
"t_moe_users": [
{
"$ref": "21"
},
{
"$ref": "21"
}
],
"t_moe_vendors": [
{
"$ref": "6"
},
{
"$ref": "6"
}
]
},
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "6"
}
],
"t_vendor_devices": [
{
"$id": "32",
"id": 1,
"vendorid": 2,
"device_token": "sample string 3",
"doe": "2025-04-04T00:23:56.0588645+00:00",
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "32"
}
],
"t_vendor_schools": [
{
"$ref": "30"
},
{
"$ref": "30"
}
],
"t_vendor_users": [
{
"$ref": "25"
},
{
"$ref": "25"
}
],
"t_standing_orders": [
{
"$ref": "15"
},
{
"$ref": "15"
}
],
"t_vendor_terms": [
{
"$id": "33",
"id": 1,
"description": "sample string 2",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 3",
"updateby": "sample string 4",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"vendorid": 1,
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "33"
}
],
"t_waitlist": [
{
"$ref": "29"
},
{
"$ref": "29"
}
],
"t_agency_terms": [
{
"$id": "34",
"id": 1,
"description": "sample string 2",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 3",
"updateby": "sample string 4",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"vendorid": 1,
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "34"
}
],
"t_orders": [
{
"$ref": "17"
},
{
"$ref": "17"
}
],
"t_customers": [
{
"$ref": "4"
},
{
"$ref": "4"
}
],
"t_invoices": [
{
"$ref": "3"
},
{
"$ref": "3"
}
],
"t_staff_payroll": [
{
"$id": "35",
"id": 1,
"from_date": "2025-04-04T00:23:56.0588645+00:00",
"to_date": "2025-04-04T00:23:56.0588645+00:00",
"payroll_date": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 2",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 3",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"seq": 4,
"num": "sample string 5",
"status": "sample string 6",
"notes": "sample string 7",
"vendorid": 8,
"finyr": "sample string 9",
"t_vendors": {
"$ref": "5"
},
"t_staff_payrollentry": [
{
"$id": "36",
"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": "35"
},
"t_vendor_staffs": {
"$id": "37",
"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-04-04T00:23:56.0588645+00:00",
"dob": "2025-04-04T00:23:56.0588645+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": "38",
"id": 1,
"staff_id": 1,
"fromdate": "2025-04-04T00:23:56.0588645+00:00",
"todate": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"createby": "sample string 8",
"upadatedate": "2025-04-04T00:23:56.0588645+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": "37"
}
},
{
"$ref": "38"
}
],
"t_staffs_reminders": [
{
"$id": "39",
"id": 1,
"name": "sample string 2",
"description": "sample string 3",
"createby": "sample string 4",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 5",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"active": true,
"enddate": "2025-04-04T00:23:56.0588645+00:00",
"staff_id": 1,
"start_date": "2025-04-04T00:23:56.0588645+00:00",
"duedate": "2025-04-04T00:23:56.0588645+00:00",
"emp_dept_section": "sample string 6",
"pic": "sample string 7",
"vendorid": 8,
"t_vendor_staffs": {
"$ref": "37"
}
},
{
"$ref": "39"
}
],
"t_staffs_shifts": [
{
"$id": "40",
"id": 1,
"staff_id": 2,
"start_time": "sample string 3",
"end_time": "sample string 4",
"deleted_at": "2025-04-04T00:23:56.0588645+00:00",
"created_at": "2025-04-04T00:23:56.0588645+00:00",
"updated_at": "2025-04-04T00:23:56.0588645+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": "41",
"id": 1,
"staff_shift_id": 2,
"start_time": "sample string 3",
"end_time": "sample string 4",
"order_count": 5,
"created_at": "2025-04-04T00:23:56.0588645+00:00",
"updated_at": "2025-04-04T00:23:56.0588645+00:00",
"deleted_at": "2025-04-04T00:23:56.0588645+00:00",
"type": "sample string 6",
"reason": "sample string 7",
"t_staffs_shifts": {
"$ref": "40"
}
},
{
"$ref": "41"
}
],
"t_vendor_staffs": {
"$ref": "37"
}
},
{
"$ref": "40"
}
],
"t_vendors": {
"$ref": "5"
},
"t_staff_roster": [
{
"$id": "42",
"id": 1,
"staffid": 1,
"dos": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"vendorid": 8,
"notes": "sample string 9",
"reason": "sample string 10",
"t_vendor_routes": {
"$id": "43",
"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": "42"
},
{
"$ref": "42"
}
]
},
"t_vendor_staffs": {
"$ref": "37"
}
},
{
"$ref": "42"
}
],
"t_staff_payrollentry": [
{
"$ref": "36"
},
{
"$ref": "36"
}
]
}
},
{
"$ref": "36"
}
]
},
{
"$ref": "35"
}
],
"t_vendor_staffs": [
{
"$ref": "37"
},
{
"$ref": "37"
}
],
"t_pohdr": [
{
"$id": "44",
"id": 1,
"pon": "sample string 2",
"seq": 3,
"supplierid": 1,
"podate": "2025-04-04T00:23:56.0588645+00:00",
"duedate": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"invoiceno": "sample string 9",
"currency": "sample string 10",
"roe": 11.0,
"createby": "sample string 12",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 13",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"shipto": 1,
"t_poentry": [
{
"$id": "45",
"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": "44"
},
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "45"
}
],
"t_vendor_shipto": {
"$id": "46",
"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": "44"
},
{
"$ref": "44"
}
],
"t_vendors": {
"$ref": "5"
}
},
"t_suppliers": {
"$id": "47",
"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": "44"
},
{
"$ref": "44"
}
]
},
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "44"
}
],
"t_vendor_shipto": [
{
"$ref": "46"
},
{
"$ref": "46"
}
],
"t_blogs": [
{
"$id": "48",
"id": 1,
"vendorid": 1,
"description": "sample string 2",
"pic": "sample string 3",
"tagline": "sample string 4",
"active": true,
"createby": "sample string 6",
"credatedate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 7",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"display_order": 8,
"publicid": "sample string 9",
"t_blog_comments": [
{
"$id": "49",
"id": 1,
"blogid": 1,
"description": "sample string 2",
"active": true,
"createby": "sample string 4",
"credatedate": "2025-04-04T00:23:56.0588645+00:00",
"t_blogs": {
"$ref": "48"
}
},
{
"$ref": "49"
}
],
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "48"
}
],
"t_events": [
{
"$id": "50",
"id": 1,
"subject": "sample string 2",
"details": "sample string 3",
"vdo_url": "sample string 4",
"pic_url": "sample string 5",
"start_date": "2025-04-04T00:23:56.0588645+00:00",
"end_date": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 7",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"vendorid": 1,
"status": "sample string 8",
"type": "sample string 9",
"publicid": "sample string 10",
"t_event_enrollments": [
{
"$id": "51",
"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-04-04T00:23:56.0588645+00:00",
"createby": "sample string 7",
"t_events": {
"$ref": "50"
}
},
{
"$ref": "51"
}
],
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "50"
}
],
"t_quiz": [
{
"$id": "52",
"id": 1,
"starttime": "2025-04-04T00:23:56.0588645+00:00",
"endtime": "2025-04-04T00:23:56.0588645+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": "53",
"id": 1,
"name": "sample string 2",
"details": "sample string 3",
"video_link": "sample string 4",
"create_date": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 5",
"update_date": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 6",
"lang": "sample string 7",
"type": "sample string 8",
"token": "382a86c7-763c-457f-b79f-b377cc5b8f60",
"passing_score": 9.0,
"min_quiz_question": 10,
"active": true,
"vendorid": 1,
"t_assesment_enrollments": [
{
"$id": "54",
"id": 1,
"assid": 1,
"price": 1.0,
"email": "sample string 2",
"access_code": "sample string 3",
"access_code_expiry": "2025-04-04T00:23:56.0588645+00:00",
"status": "sample string 4",
"start_date": "2025-04-04T00:23:56.0588645+00:00",
"completion_date": "2025-04-04T00:23:56.0588645+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-04-04T00:23:56.0588645+00:00",
"vendorid": 1,
"t_assesment": {
"$ref": "53"
},
"t_assesment1": {
"$ref": "53"
},
"t_quiz": [
{
"$ref": "52"
},
{
"$ref": "52"
}
]
},
{
"$ref": "54"
}
],
"t_assesment_enrollments1": [
{
"$ref": "54"
},
{
"$ref": "54"
}
],
"t_assesment_resources": [
{
"$id": "55",
"id": 1,
"assid": 1,
"type": "sample string 2",
"name": "sample string 3",
"details": "sample string 4",
"create_date": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 5",
"update_date": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 6",
"display_order": 7,
"t_assesment": {
"$ref": "53"
},
"t_assesment1": {
"$ref": "53"
}
},
{
"$ref": "55"
}
],
"t_assesment_resources1": [
{
"$ref": "55"
},
{
"$ref": "55"
}
],
"t_assesment_sections": [
{
"$id": "56",
"id": 1,
"assid": 1,
"name": "sample string 2",
"details": "sample string 3",
"video_link": "sample string 4",
"create_date": "2025-04-04T00:23:56.0588645+00:00",
"createby": "sample string 5",
"update_date": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 6",
"display_order": 7,
"t_assesment": {
"$ref": "53"
},
"t_assesment1": {
"$ref": "53"
}
},
{
"$ref": "56"
}
],
"t_assesment_sections1": [
{
"$ref": "56"
},
{
"$ref": "56"
}
],
"t_quiz": [
{
"$ref": "52"
},
{
"$ref": "52"
}
],
"t_quiz1": [
{
"$ref": "52"
},
{
"$ref": "52"
}
]
},
"t_assesment1": {
"$ref": "53"
},
"t_assesment_enrollments": {
"$ref": "54"
},
"t_vendors": {
"$ref": "5"
},
"t_quiz_attempts": [
{
"$id": "57",
"id": 1,
"quizid": 1,
"starttime": "2025-04-04T00:23:56.0588645+00:00",
"endtime": "2025-04-04T00:23:56.0588645+00:00",
"duration": "00:00:00.1234567",
"score": 2.0,
"results": "sample string 3",
"t_quiz": {
"$ref": "52"
}
},
{
"$ref": "57"
}
],
"t_quiz_question": [
{
"$id": "58",
"id": 1,
"quizid": 1,
"questionid": 1,
"score": 2.0,
"t_question": {
"$id": "59",
"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": "60",
"id": 1,
"answertext": "sample string 2",
"question_id": 1,
"t_question": {
"$ref": "59"
}
},
{
"$ref": "60"
}
],
"t_answerchoice": [
{
"$id": "61",
"id": 1,
"choices": "sample string 2",
"question_id": 1,
"t_question": {
"$ref": "59"
}
},
{
"$ref": "61"
}
],
"t_quiz_question": [
{
"$ref": "58"
},
{
"$ref": "58"
}
]
},
"t_quiz": {
"$ref": "52"
}
},
{
"$ref": "58"
}
]
},
{
"$ref": "52"
}
],
"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_banners": [
{
"$id": "63",
"id": 1,
"vendorid": 1,
"file_url": "sample string 2",
"createby": "sample string 3",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "63"
}
],
"t_vendor_blocked_dates": [
{
"$id": "64",
"id": 1,
"vendorid": 2,
"dateblocked": "2025-04-04T00:23:56.0588645+00:00",
"reason": "sample string 4",
"tbl_id": 1,
"t_tables": {
"$id": "65",
"id": 1,
"code": "sample string 2",
"name": "sample string 3",
"createby": "sample string 4",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 5",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"location": "sample string 6",
"active": true,
"vendorid": 1,
"max_capacity": 8,
"min_capacity": 9,
"routeid": 1,
"t_vendor_blocked_dates": [
{
"$ref": "64"
},
{
"$ref": "64"
}
],
"t_vendor_blocked_time_slots": [
{
"$id": "66",
"id": 1,
"vendorid": 2,
"ondate": "2025-04-04T00:23:56.0588645+00:00",
"hrs": 1.0,
"reason": "sample string 4",
"tbl_id": 1,
"t_tables": {
"$ref": "65"
},
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "66"
}
]
},
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "64"
}
],
"t_vendor_blocked_time_slots": [
{
"$ref": "66"
},
{
"$ref": "66"
}
],
"t_vendor_discount_structures": [
{
"$id": "67",
"id": 1,
"spend_upto": 1.0,
"discount": 1.0,
"vendorid": 1,
"orderby": 1,
"t_vendors": {
"$ref": "5"
}
},
{
"$ref": "67"
}
],
"t_vendor_items": [
{
"$ref": "1"
},
{
"$ref": "1"
}
]
},
"t_invoices": [
{
"$ref": "3"
},
{
"$ref": "3"
}
]
},
"t_vendors": {
"$ref": "5"
},
"t_invoiceentry": [
{
"$ref": "2"
},
{
"$ref": "2"
}
]
},
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "2"
}
],
"t_item_addons": [
{
"$id": "68",
"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": "68"
}
],
"t_item_addons1": [
{
"$ref": "68"
},
{
"$ref": "68"
}
],
"t_item_bins": [
{
"$id": "69",
"id": 1,
"itemid": 1,
"vendorid": 2,
"cnt": 1.0,
"binid": 1,
"t_binlocations": {
"$id": "70",
"id": 1,
"code": "sample string 2",
"description": "sample string 3",
"active": true,
"createby": "sample string 4",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 5",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"vendorid": 6,
"lvl": "sample string 7",
"sec": "sample string 8",
"bintype": "sample string 9",
"t_item_transactions": [
{
"$id": "71",
"id": 1,
"itemid": 1,
"qty": 2.0,
"refno": "sample string 3",
"txndate": "2025-04-04T00:23:56.0588645+00:00",
"tranby": "sample string 4",
"txntype": "sample string 5",
"notes": "sample string 6",
"binid": 1,
"uom": "sample string 7",
"t_binlocations": {
"$ref": "70"
},
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "71"
}
],
"t_item_bins": [
{
"$ref": "69"
},
{
"$ref": "69"
}
]
},
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "69"
}
],
"t_item_categories": {
"$id": "72",
"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,
"t_vendor_items": [
{
"$ref": "1"
},
{
"$ref": "1"
}
]
},
"t_item_pics": [
{
"$id": "73",
"id": 1,
"url": "sample string 2",
"createby": "sample string 3",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 4",
"updatedate": "2025-04-04T00:23:56.0588645+00:00",
"active": true,
"itemid": 1,
"display_order": 6,
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "73"
}
],
"t_item_pricinglog": [
{
"$id": "74",
"id": 1,
"itemid": 1,
"cost": 1.0,
"price": 1.0,
"doe": "2025-04-04T00:23:56.0588645+00:00",
"eby": "sample string 2",
"notes": "sample string 3",
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "74"
}
],
"t_item_reviews": [
{
"$ref": "26"
},
{
"$ref": "26"
}
],
"t_item_timings": [
{
"$id": "75",
"id": 1,
"itemid": 1,
"dayavail": "sample string 2",
"startdate": "2025-04-04T00:23:56.0588645+00:00",
"enddate": "2025-04-04T00:23:56.0588645+00:00",
"hideprice": true,
"displayorder": 1,
"t_vendor_items": {
"$ref": "1"
}
},
{
"$ref": "75"
}
],
"t_item_transactions": [
{
"$ref": "71"
},
{
"$ref": "71"
}
],
"t_orderentry": [
{
"$ref": "19"
},
{
"$ref": "19"
}
],
"t_poentry": [
{
"$ref": "45"
},
{
"$ref": "45"
}
],
"t_standing_orderentry": [
{
"$ref": "16"
},
{
"$ref": "16"
}
],
"t_vendors": {
"$ref": "5"
},
"t_item_details": [
{
"$id": "76",
"id": 1,
"display_order": 2,
"createby": "sample string 3",
"createdate": "2025-04-04T00:23:56.0588645+00:00",
"updateby": "sample string 4",
"updatedate": "2025-04-04T00:23:56.0588645+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": "76"
}
]
}