Export Employee Budget spentSELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8242))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8243))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8244))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8245))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8246))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8247))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8248))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8249))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax0SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8250))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
[0] => stdClass Object
(
[order_id] => 110201
[item_count] => 4
[total_qty] => 7
[total_amount] => 280.127273
)
)
spent_amount_final280.127273
spent_amount_final_with_tax308.1400003SELECT
wp_woocommerce_order_items.order_id,
COUNT(wp_woocommerce_order_items.order_item_id) AS item_count,
SUM(CAST(meta_qty.meta_value AS SIGNED)) AS total_qty,
SUM(meta_order_amount.meta_value) AS total_amount
FROM
wp_woocommerce_order_items
INNER JOIN wp_woocommerce_order_itemmeta AS meta_employee ON (
wp_woocommerce_order_items.order_item_id = meta_employee.order_item_id
AND meta_employee.meta_key = 'associate_employee_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_product ON (
wp_woocommerce_order_items.order_item_id = meta_product.order_item_id
AND meta_product.meta_key = '_product_id'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_qty ON (
wp_woocommerce_order_items.order_item_id = meta_qty.order_item_id
AND meta_qty.meta_key = '_qty'
)
INNER JOIN wp_woocommerce_order_itemmeta AS meta_order_amount ON (
wp_woocommerce_order_items.order_item_id = meta_order_amount.order_item_id
AND meta_order_amount.meta_key = '_line_total'
)
WHERE
1=1
AND (wp_woocommerce_order_items.order_item_type = 'line_item')
AND (meta_employee.meta_value IN (8251))
AND wp_woocommerce_order_items.order_id IN (
SELECT
wp_posts.ID
FROM
wp_posts
WHERE
(wp_posts.post_date > '2024-04-01' AND wp_posts.post_date < '2024-04-01 00:00:00')
AND wp_posts.post_type IN ('shop_order', 'shop_order_refund')
AND (
wp_posts.post_status IN (
'wc-processing',
'wc-completed',
'wc-delivered',
'wc-shipped',
'wc-picked-packed',
'wc-in-production',
'wc-incomingstack',
'wc-moreinformation',
'wc-forpayment'
)
)
)
GROUP BY
wp_woocommerce_order_items.order_id
ORDER BY
MAX(meta_product.meta_value) DESC
Array
(
)
spent_amount_final0
spent_amount_final_with_tax010Array
(
[0] => Array
(
[employee_id] => 8242
[firstname] => DAVID
[lastname] => ALABAKIS
[user_name] => 3102
[email] =>
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 505.13
[budget_spent] => 0
[remaining_budget] => 505.13
[employee_no] =>
[phone] =>
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] => DAVID
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[1] => Array
(
[employee_id] => 8243
[firstname] => ROBERT
[lastname] => ANDREW
[user_name] => 3251
[email] =>
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 508.46
[budget_spent] => 0
[remaining_budget] => 508.46
[employee_no] =>
[phone] =>
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[2] => Array
(
[employee_id] => 8244
[firstname] => SHAUN
[lastname] => ATTARD
[user_name] => 3242
[email] =>
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 542.5
[budget_spent] => 0
[remaining_budget] => 542.5
[employee_no] =>
[phone] =>
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[3] => Array
(
[employee_id] => 8245
[firstname] => ERMAN
[lastname] => BAGDAS
[user_name] => 3221
[email] => erman.bagdas@hotmail.com
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 500.85
[budget_spent] => 0
[remaining_budget] => 500.85
[employee_no] =>
[phone] => 0422386321
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[4] => Array
(
[employee_id] => 8246
[firstname] => RICHARD
[lastname] => BARKER
[user_name] => 3208
[email] =>
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 527.5
[budget_spent] => 0
[remaining_budget] => 527.5
[employee_no] =>
[phone] =>
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[5] => Array
(
[employee_id] => 8247
[firstname] => MARK
[lastname] => BATES
[user_name] => 3004
[email] =>
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 542.5
[budget_spent] => 0
[remaining_budget] => 542.5
[employee_no] =>
[phone] =>
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[6] => Array
(
[employee_id] => 8248
[firstname] => WAYNE
[lastname] => BAXTER
[user_name] => 3058
[email] =>
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 542.5
[budget_spent] => 0
[remaining_budget] => 542.5
[employee_no] =>
[phone] =>
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[7] => Array
(
[employee_id] => 8249
[firstname] => TEARIKI
[lastname] => BENNION
[user_name] => 3158
[email] => 3158@metcash.com
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 500.96
[budget_spent] => 0
[remaining_budget] => 500.96
[employee_no] =>
[phone] => 0383686352
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
[8] => Array
(
[employee_id] => 8250
[firstname] => ADAM
[lastname] => BESIMOVSKI
[user_name] =>
[email] => adem.besimovski@outlook.com
[role_display_name] =>
[parent_id] => 8534
[budget_amount] =>
[budget_spent] => 308.14
[remaining_budget] => -308.14
[employee_no] =>
[phone] => 0426770959
[budget_start] =>
[budget_renewal] =>
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] =>
[comments] =>
)
[9] => Array
(
[employee_id] => 8251
[firstname] => MARK
[lastname] => BOLUCH
[user_name] => 3066
[email] =>
[role_display_name] => Metcash ALM VIC employees
[parent_id] => 8534
[budget_amount] => 506.4
[budget_spent] => 0
[remaining_budget] => 506.4
[employee_no] =>
[phone] =>
[budget_start] => 2024-04-01
[budget_renewal] => yearly
[site_title] =>
[department_title] =>
[clothing_size] =>
[boot_size] =>
[can_order] => 1
[comments] =>
)
)