Overview
The Order model represents repair orders in ElectroFix. It tracks equipment repairs, symptoms, technician assignments, AI-powered diagnostics, cost estimates, and repair status. This is a core model that integrates AI capabilities for automated diagnostics.
Properties
Fillable Attributes
Foreign key to the Company this order belongs to
Foreign key to the Customer who owns the equipment
Foreign key to the Equipment being repaired
Name of the assigned technician
Description of the equipment problems and symptoms
Current order status (e.g., ‘pending’, ‘in_progress’, ‘completed’, ‘cancelled’)
Manual cost estimate for the repair
AI-generated list of potential causes for the equipment failure
AI-estimated time required to complete the repair
AI-generated list of suggested replacement parts
AI-generated technical advice and repair instructions
Timestamp when AI diagnosis was performed
Number of AI tokens consumed for this diagnosis
AI provider used (e.g., ‘openai’, ‘anthropic’)
Specific AI model used for diagnosis (e.g., ‘gpt-4’, ‘claude-3’)
ai_requires_parts_replacement
AI determination of whether parts replacement is needed
AI-estimated cost for labor
ai_cost_replacement_parts
AI-estimated cost for replacement parts
ai_cost_replacement_total
AI-estimated total cost (labor + parts)
Casts
protected function casts(): array
{
return [
'estimated_cost' => 'decimal:2',
'ai_potential_causes' => 'array',
'ai_suggested_parts' => 'array',
'ai_diagnosed_at' => 'datetime',
'ai_requires_parts_replacement' => 'boolean',
'ai_cost_repair_labor' => 'decimal:2',
'ai_cost_replacement_parts' => 'decimal:2',
'ai_cost_replacement_total' => 'decimal:2',
];
}
- Decimal fields are cast with 2 decimal precision for accurate cost tracking
ai_potential_causes and ai_suggested_parts are automatically serialized/deserialized as arraysai_diagnosed_at is cast to Carbon datetime instanceai_requires_parts_replacement is cast to boolean
Relationships
company()
Type: BelongsTo
Returns the company this order belongs to.
public function company(): BelongsTo
{
return $this->belongsTo(Company::class);
}
customer()
Type: BelongsTo
Returns the customer who owns the equipment being repaired.
public function customer(): BelongsTo
{
return $this->belongsTo(Customer::class);
}
equipment()
Type: BelongsTo
Returns the equipment being repaired in this order.
public function equipment(): BelongsTo
{
return $this->belongsTo(Equipment::class);
}
billingItems()
Type: HasMany
Returns all billing line items associated with this order.
public function billingItems(): HasMany
{
return $this->hasMany(BillingDocumentItem::class);
}
aiUsages()
Type: HasMany
Returns all AI usage records for this order.
public function aiUsages(): HasMany
{
return $this->hasMany(CompanyAiUsage::class);
}
Usage Examples
Creating a New Order
$order = Order::create([
'company_id' => 1,
'customer_id' => 5,
'equipment_id' => 12,
'technician' => 'John Smith',
'symptoms' => 'Device not turning on, no LED indicators',
'status' => 'pending',
]);
Storing AI Diagnosis Results
$order->update([
'ai_potential_causes' => [
'Power supply failure',
'Faulty motherboard',
'Blown capacitors',
],
'ai_suggested_parts' => [
'Power supply unit (PSU-500W)',
'Replacement capacitors (100μF 25V)',
],
'ai_technical_advice' => 'Test power supply voltage first. Check for bulging capacitors on motherboard.',
'ai_estimated_time' => '2-3 hours',
'ai_diagnosed_at' => now(),
'ai_tokens_used' => 1250,
'ai_provider' => 'openai',
'ai_model' => 'gpt-4',
'ai_requires_parts_replacement' => true,
'ai_cost_repair_labor' => 150.00,
'ai_cost_replacement_parts' => 75.50,
'ai_cost_replacement_total' => 225.50,
]);
Querying Orders with Relationships
// Get all pending orders with customer and equipment details
$pendingOrders = Order::where('status', 'pending')
->with(['customer', 'equipment', 'company'])
->orderBy('created_at', 'desc')
->get();
// Get orders with AI diagnosis
$aiOrders = Order::whereNotNull('ai_diagnosed_at')
->where('company_id', $companyId)
->get();
Working with AI Data
// Display AI potential causes
foreach ($order->ai_potential_causes as $cause) {
echo "- {$cause}\n";
}
// Display suggested parts
foreach ($order->ai_suggested_parts as $part) {
echo "- {$part}\n";
}
// Check if parts replacement needed
if ($order->ai_requires_parts_replacement) {
$totalCost = $order->ai_cost_replacement_total;
echo "Estimated repair cost: $" . number_format($totalCost, 2);
}
Updating Order Status
// Start working on order
$order->update([
'status' => 'in_progress',
'technician' => 'Jane Doe',
]);
// Complete order
$order->update([
'status' => 'completed',
]);
Filtering by Status
// Get orders for a specific company and status
$inProgressOrders = Order::where('company_id', $companyId)
->where('status', 'in_progress')
->with('equipment.customer')
->get();
Cost Analysis
// Calculate total AI-estimated costs for all orders
$totalEstimated = Order::where('company_id', $companyId)
->whereNotNull('ai_cost_replacement_total')
->sum('ai_cost_replacement_total');
// Compare AI estimate vs manual estimate
if ($order->estimated_cost && $order->ai_cost_replacement_total) {
$difference = abs($order->estimated_cost - $order->ai_cost_replacement_total);
$percentDiff = ($difference / $order->estimated_cost) * 100;
}
AI Usage Tracking
// Get total tokens used by company
$totalTokens = Order::where('company_id', $companyId)
->sum('ai_tokens_used');
// Get orders by AI provider
$openAIOrders = Order::where('ai_provider', 'openai')
->where('company_id', $companyId)
->count();
Creating Billing from Order
// Use AI cost estimates to create billing document
$billingDocument = BillingDocument::create([
'company_id' => $order->company_id,
'customer_id' => $order->customer_id,
'subtotal' => $order->ai_cost_replacement_total,
'source' => 'order',
// ... other billing fields
]);
Source Reference
Model file: /home/daytona/workspace/source/app/Models/Order.php