=== Comprehensive Direct Delivery Inventory Fix === Properly syncing DD-202511-0006 with project inventory... Step 1: Resetting laptop inventory for project 15... Deleted existing laptop inventory record Step 2: Creating initial laptop inventory (500 units from previous deliveries)... Created initial inventory: 500 laptops Step 3: Processing DD-202511-0006 delivery to project inventory... KCG-UAE
Internal Server Error

Error

Call to a member function items() on null

LARAVEL 12.31.1
PHP 8.2.29
UNHANDLED
CODE 0
GET
https://kcguae.com/wms/public

Overview

DATE
2025/12/08 13:54:53.820 UTC
STATUS CODE
500
METHOD
GET

Exception trace

comprehensive_dd_inventory_fix.php
comprehensive_dd_inventory_fix.php:49 
44
45    // Step 3: Process the direct delivery to add to project inventory
46    echo PHP_EOL . "Step 3: Processing DD-202511-0006 delivery to project inventory..." . PHP_EOL;
47
48    $dd = DirectDelivery::where('delivery_number', 'DD-202511-0006')->first();
49    $laptopDeliveryItem = $dd->items()->where('item_id', 1)->first();
50
51    if ($laptopDeliveryItem && $laptopDeliveryItem->received_quantity > 0) {
52        $projectInventory = ProjectInventory::where('project_id', 15)
53            ->where('item_id', 1)
54            ->first();
55
56        if ($projectInventory) {
57            $oldQuantity = $projectInventory->quantity_available;
58            $projectInventory->updateQuantity($laptopDeliveryItem->received_quantity, 'add');
59            $newQuantity = $projectInventory->quantity_available;
60
61

Queries

mysql 
select * from `project_inventory` where `project_id` = 15 and `item_id` = 1 limit 1
0.93ms
mysql 
delete from `project_inventory` where `id` = 9
0.73ms
mysql 
insert into `project_inventory` (`project_id`, `item_id`, `quantity_available`, `allocated_quantity`, `unit_price`, `total_value`, `updated_at`, `created_at`) values (15, 1, 500, 0, 1500, 750000, '2025-12-08 13:54:53', '2025-12-08 13:54:53')
0.74ms
mysql 
select * from `direct_deliveries` where `delivery_number` = 'DD-202511-0006' limit 1
1.21ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.8ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
1.27ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.27ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.27ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.22ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.39ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.7ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.32ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.2ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.19ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.19ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.24ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.38ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
1.28ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.43ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.2ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.25ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.2ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.27ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.39ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.69ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.34ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.25ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.26ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.28ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.28ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.38ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.4ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.25ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.27ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.27ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.24ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.37ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.37ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.27ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.91ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.32ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.36ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.2ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.37ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.81ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.4ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.2ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.19ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.23ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.2ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.21ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.19ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.32ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.44ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.24ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.22ms

Headers

host
kcguae.com
user-agent
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept
*/*
accept-language
en-us,en;q=0.5
accept-charset
ISO-8859-1,utf-8;q=0.7,*;q=0.7
x-real-ip
216.73.216.3
x-forwarded-server
wms.kcguae.com
x-forwarded-proto
https
x-forwarded-port
443
x-forwarded-host
wms.kcguae.com
x-forwarded-for
216.73.216.3

Body

// No request body

Routing

// No routing context

Routing parameters

// No routing parameters