Ignore:
Timestamp:
08/26/24 16:17:04 (4 months ago)
Author:
bube-ristovska <ristovska725@…>
Branches:
main
Parents:
5372778
Message:

Refactored duplicate code

File:
1 edited

Legend:

Unmodified
Added
Removed
  • app/Http/Controllers/CrimeCaseController.php

    r5372778 r3c89e27  
    99class CrimeCaseController extends Controller
    1010{
     11    private function policeStationIsPoliceman()
     12    {
     13        return DB::table('police_station')
     14            ->where('p_id', Session::get('p_id'))
     15            ->get();
     16    }
     17    private function policeStationIsOfficer()
     18    {
     19        return DB::table('police_station')
     20            ->where('pe_id', Session::get('pe_id'))
     21            ->get();
     22    }
    1123    function cases(){
    1224        if(Session::get('pe_id') == null) {
     
    1426        }
    1527
    16 
    1728        if(Session::get('is_policeman')){
    18             $police_station = DB::select('select * from police_station where p_id=:p_id;',['p_id'=>  Session::get('p_id')]);
     29            $police_station = $this->policeStationIsPoliceman();
    1930        } else {
    20             $police_station = DB::select('select * from police_station where pe_id=:pe_id;',['pe_id'=>  Session::get('pe_id')]);
     31            $police_station = $this->policeStationIsOfficer();
    2132        }
    2233
    23         $cases = DB::select('select * from crime_case where p_id=:p_id;',['p_id'=> $police_station[0]->p_id]);
    24 
     34        $cases = DB::table('crime_case')
     35            ->where('p_id', $police_station[0]->p_id)
     36            ->get();
    2537
    2638        return view('cases', [
     
    4456            'incident_place'=>'required'
    4557        ]);
    46         $statement["statement_date"] = Carbon::now()->format('Y-m-d');
    47         $covek = DB::select('select pe_id from people where embg=:embg;',['embg'=> $statement["embg"]]);
     58         $statement["statement_date"] = Carbon::now()->format('Y-m-d');
     59         $covek = DB::select('select pe_id from people where embg=:embg;',['embg'=> $statement["embg"]]);
    4860         $s_id_b = DB::select('select MAX(s_id) from statements');
    4961         $s_id = $s_id_b[0]->max;
    50         $s_id = $s_id +1 ;
    51         $policaec =  DB::select('select pe_id from policeman where badge_no=:badge_no;',['badge_no'=> Session::get("badge_no")]);
     62         $s_id = $s_id +1 ;
     63         $policaec =  DB::select('select pe_id from policeman where badge_no=:badge_no;',['badge_no'=> Session::get("badge_no")]);
    5264
    5365        if ($role === 'witness') {
     
    8496    }
    8597    function finished_cases(){
    86 
    8798        if(Session::get('is_policeman')){
    88             $police_station = DB::select('select * from police_station where p_id=:p_id;',['p_id'=>  Session::get('p_id')]);
     99            $police_station = $this->policeStationIsPoliceman();
    89100        } else {
    90             $police_station = DB::select('select * from police_station where pe_id=:pe_id;',['pe_id'=>  Session::get('pe_id')]);
     101            $police_station = $this->policeStationIsOfficer();
    91102        }
    92103
    93         $cases = DB::select('select * from crime_case where p_id=:p_id and c_status=\'Z\';', ['p_id' => $police_station[0]->p_id]);
    94 
     104        $cases = DB::table('crime_case')
     105            ->where('p_id', $police_station[0]->p_id)
     106            ->where('c_status', 'Z')
     107            ->get();
    95108        return view('archive', [
    96109            'cases' => $cases,
     
    100113    function case($wildcard){
    101114        Session::put('c_id', $wildcard);
    102         $case = DB::select('select * from crime_case where c_id=:c_id;',['c_id'=> $wildcard]);
    103         $p_address = DB::select('select p_address from police_station where p_id=:p_id;',['p_id'=> $case[0]->p_id]);
    104         $statements = DB::select('select * from statements where c_id=:c_id;',['c_id'=> $wildcard]);
    105 
     115        $case = DB::table('crime_case')
     116            ->where('c_id', $wildcard)
     117            ->get();
     118        $p_address = DB::table('police_station')
     119            ->where('p_id', $case[0]->p_id)
     120            ->value('p_address');
     121        $statements = DB::table('statements')
     122            ->where('c_id', $wildcard)
     123            ->get();
    106124
    107125        $victims=[];
     
    110128        $evidence = [];
    111129        foreach ($statements as $statement) {
    112             $evidence_id = DB::select('select * from mentions_evidence where s_id=:s_id;',['s_id'=> $statement->s_id]);
    113             if (!empty($evidence_id)) { // Check if $evidence_id is not empty
    114                 $evidence_id[] = $evidence_id[0];
    115             }
     130            $evidence_id = DB::table('mentions_evidence')
     131                ->where('s_id', $statement->s_id)
     132                ->get();
     133//            if (!empty($evidence_id)) { // Check if $evidence_id is not empty
     134//                $evidence_id[] = $evidence_id[0];
     135//            }
    116136        }
    117137         $evidence_id=collect($evidence_id)->unique();
    118138        foreach ($evidence_id as $e) {
    119             $evidence = DB::select('select * from evidence where e_id=:e_id;',['e_id'=> $e->e_id]);
    120             $evidence[] = $evidence[0];
     139            $evidence = DB::table('evidence')
     140                ->where('e_id', $e->e_id)->get();
     141
    121142        }
    122143        foreach ($statements as $st){
    123144            if (!($st->victim_pe_id)==NULL){
    124                 $victim=DB::select('select * from people where pe_id=:pe_id;',['pe_id'=> $st->victim_pe_id]);
     145                $victim = DB::table('people')
     146                    ->where('pe_id', $st->victim_pe_id)->get();
    125147                $victims[] = $victim[0];
    126148            }
     
    128150        foreach ($statements as $st){
    129151            if (!($st->witness_pe_id)==NULL) {
    130                 $witnes = DB::select('select * from people where pe_id=:pe_id;', ['pe_id' => $st->witness_pe_id]);
     152                $witnes = DB::table('people')
     153                    ->where('pe_id', $st->witness_pe_id)->get();
    131154                $witness[] = $witnes[0];
    132155            }
    133156        }
    134157
    135 
    136158        return view('case', [
    137159            'case' => $case[0],
    138             'p_address'=>$p_address[0]->p_address,
     160            'p_address'=>$p_address,
    139161            'statements'=>$statements,
    140162            'evidence'=>$evidence,
Note: See TracChangeset for help on using the changeset viewer.