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