1	<?php
2
3	namespace App\Models;
4
5	use Illuminate\Database\Eloquent\Factories\HasFactory;
6	use Illuminate\Database\Eloquent\Model;
7
8	class TblOngoingJobs extends Model
9	{
10	use HasFactory;
11	protected $table = 'tbl_ongoing_jobs';
12	public $timestamps = false;
13	protected $fillable = [
14	'quotation_id',
15	'quote_id',
16	'company_id',
17	'customer_type_id',
18	'segment_id',
19	'budget_type_id',
20	'client',
21	'client_type',
22	'issue_date',
23	'order_number',
24	'acceptance_date',
25	'amount',
26	'invoice_amount',
27	'expected_completion_date',
28	'actual_end_date',
29	'actual_job_start_date',
30	'expected_start_date_of_work',
31	'created_at',
32	'created_by',
33	'updated_at',
34	'updated_by',
35	'responsible_for_work',
36	'work_status_id',
37	'cost_for_client',
38	'people_assigned_to_the_job',
39	'duration_of_job_in_days',
40	'estimated_cost_of_materials',
41	'cost_of_labor',
42	'total_cost_of_job',
43	'invoice_margin',
44	'margin_for_the_company',
45	'margin_on_invoice_per_day_per_worker',
46	'revenue_per_date_per_worked',
47	'gross_margin',
48	'labor_percentage',
49	'pending_to_be_invoiced',
50	'to_be_invoiced_this_month',
51	'to_be_invoiced_after_this_month',
52	'for_approval',
53	'comments',
54	'approved_at',
55	'approved_by',
56	'rejected_at',
57	'rejected_by'
58	];
59	}