Conditions | 1 |
Paths | 1 |
Total Lines | 12 |
Code Lines | 7 |
Lines | 0 |
Ratio | 0 % |
Changes | 1 | ||
Bugs | 0 | Features | 1 |
1 | <?php |
||
14 | public function query(): Builder |
||
15 | { |
||
16 | return Company::selectRaw(' |
||
17 | companies.id, companies.name, companies.fiscal_code, people.name as mandatary, |
||
18 | companies.email, companies.website, companies.bank, companies.pays_vat, |
||
19 | companies.phone, companies.status, companies.is_tenant, companies.created_at |
||
20 | ')->leftJoin( |
||
21 | 'company_person', |
||
22 | fn ($join) => $join |
||
23 | ->on('companies.id', '=', 'company_person.company_id') |
||
24 | )->leftJoin('people', 'company_person.person_id', '=', 'people.id') |
||
25 | ->where('company_person.person_id', Auth::user()->person_id); |
||
|
|||
26 | } |
||
33 |