TYPE=VIEW
query=select `s`.`id` AS `id`,`s`.`supply_code` AS `supply_code`,`s`.`supply_name` AS `supply_name`,`s`.`category_id` AS `category_id`,`s`.`unit` AS `unit`,`s`.`quantity_in_stock` AS `quantity_in_stock`,`s`.`min_stock_level` AS `min_stock_level`,`s`.`average_unit_price` AS `average_unit_price`,`s`.`total_value` AS `total_value`,`s`.`description` AS `description`,`s`.`created_at` AS `created_at`,`s`.`updated_at` AS `updated_at`,`s`.`status` AS `status`,`c`.`category_name` AS `category_name`,coalesce(`s`.`average_unit_price`,0) AS `current_unit_price`,coalesce(`s`.`total_value`,0) AS `current_total_value`,(select count(0) from `supply_system`.`supply_batches` `sb` where ((`sb`.`supply_id` = `s`.`id`) and (`sb`.`status` = \'active\') and (`sb`.`quantity_remaining` > 0))) AS `active_batches_count`,(select min(`sb`.`received_date`) from `supply_system`.`supply_batches` `sb` where ((`sb`.`supply_id` = `s`.`id`) and (`sb`.`status` = \'active\') and (`sb`.`quantity_remaining` > 0))) AS `oldest_batch_date` from (`supply_system`.`supplies` `s` join `supply_system`.`categories` `c` on((`s`.`category_id` = `c`.`id`)))
md5=ad9b993fee3f644e4430a0ed7d51cc11
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-10-29 12:44:31
create-version=1
source=select `s`.`id` AS `id`,`s`.`supply_code` AS `supply_code`,`s`.`supply_name` AS `supply_name`,`s`.`category_id` AS `category_id`,`s`.`unit` AS `unit`,`s`.`quantity_in_stock` AS `quantity_in_stock`,`s`.`min_stock_level` AS `min_stock_level`,`s`.`average_unit_price` AS `average_unit_price`,`s`.`total_value` AS `total_value`,`s`.`description` AS `description`,`s`.`created_at` AS `created_at`,`s`.`updated_at` AS `updated_at`,`s`.`status` AS `status`,`c`.`category_name` AS `category_name`,coalesce(`s`.`average_unit_price`,0) AS `current_unit_price`,coalesce(`s`.`total_value`,0) AS `current_total_value`,(select count(0) from `supply_batches` `sb` where ((`sb`.`supply_id` = `s`.`id`) and (`sb`.`status` = \'active\') and (`sb`.`quantity_remaining` > 0))) AS `active_batches_count`,(select min(`sb`.`received_date`) from `supply_batches` `sb` where ((`sb`.`supply_id` = `s`.`id`) and (`sb`.`status` = \'active\') and (`sb`.`quantity_remaining` > 0))) AS `oldest_batch_date` from (`supplies` `s` join `categories` `c` on((`s`.`category_id` = `c`.`id`)))
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `s`.`id` AS `id`,`s`.`supply_code` AS `supply_code`,`s`.`supply_name` AS `supply_name`,`s`.`category_id` AS `category_id`,`s`.`unit` AS `unit`,`s`.`quantity_in_stock` AS `quantity_in_stock`,`s`.`min_stock_level` AS `min_stock_level`,`s`.`average_unit_price` AS `average_unit_price`,`s`.`total_value` AS `total_value`,`s`.`description` AS `description`,`s`.`created_at` AS `created_at`,`s`.`updated_at` AS `updated_at`,`s`.`status` AS `status`,`c`.`category_name` AS `category_name`,coalesce(`s`.`average_unit_price`,0) AS `current_unit_price`,coalesce(`s`.`total_value`,0) AS `current_total_value`,(select count(0) from `supply_system`.`supply_batches` `sb` where ((`sb`.`supply_id` = `s`.`id`) and (`sb`.`status` = \'active\') and (`sb`.`quantity_remaining` > 0))) AS `active_batches_count`,(select min(`sb`.`received_date`) from `supply_system`.`supply_batches` `sb` where ((`sb`.`supply_id` = `s`.`id`) and (`sb`.`status` = \'active\') and (`sb`.`quantity_remaining` > 0))) AS `oldest_batch_date` from (`supply_system`.`supplies` `s` join `supply_system`.`categories` `c` on((`s`.`category_id` = `c`.`id`)))