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
12	protected $table = 'tbl_ongoing_jobs';
13
14	public $timestamps = false;
15
16	protected $fillable = [
17	'quotation_id',
18	'quote_id',
19	'company_id',
20	'customer_type_id',
21	'segment_id',
22	'budget_type_id',
23	'client',
24	'client_type',
25	'issue_date',
26	'order_number',
27	'acceptance_date',
28	'amount',
29	'invoice_amount',
30	'expected_completion_date',
31	'actual_end_date',
32	'actual_job_start_date',
33	'expected_start_date_of_work',
34	'created_at',
35	'created_by',
36	'updated_at',
37	'updated_by',
38	'responsible_for_work',
39	'work_status_id',
40	'cost_for_client',
41	'people_assigned_to_the_job',
42	'duration_of_job_in_days',
43	'estimated_cost_of_materials',
44	'cost_of_labor',
45	'total_cost_of_job',
46	'invoice_margin',
47	'margin_for_the_company',
48	'margin_on_invoice_per_day_per_worker',
49	'revenue_per_date_per_worked',
50	'gross_margin',
51	'labor_percentage',
52	'pending_to_be_invoiced',
53	'to_be_invoiced_this_month',
54	'to_be_invoiced_after_this_month',
55	'for_approval',
56	'comments',
57	'approved_at',
58	'approved_by',
59	'rejected_at',
60	'rejected_by',
61	];
62	}