mardi 18 octobre 2016

Query Exception after running composer update

I want to add import/export feature so, I did composer update to install maatwebsite but suddenly I got this

QueryException in Connection.php line 651: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accessdetail.targetUserId' in 'where clause' (SQL: select accessheader.filePath from accessheader inner join accessdetail on accessheader.id = accessdetail.accessId where accessdetail.targetUserId = 2)

I tried with "composer require" and it still gives the same result. Before running composer update, it went well though. So, I curious why.

FileController.php

public function index(Request $request)
    {
        $folder = $request::get('folder');

        //return Storage::disk('local')->directories("/");

        $data = $this->manager->folderInfo($folder);

        $login = auth()->user();

        /*
         * Base Folder?
         * */

        $ownedFolder = '';

        if (!is_null($login->staffId)) {
            $ownedFolder = AccessHeader::where('name',$login->staffs['position'])->first();
        } elseif (!is_null($login->pengurusId)) {
            $ownedFolder = AccessHeader::where('name',$login->pengurus['department'])->first();
        }

        $baseFolder = $ownedFolder['filePath'];                              // /Media/

        $baseFolder = substr($baseFolder, 0, strlen($baseFolder) - 1);          // /Media
        $ownedFolder = Str::is($baseFolder,$folder);
        $baseFolder = Str::is($baseFolder . '*',$folder);                    // 1

        /*if($folder == $baseFolder){
            $baseFolder = 1;
        }else if($folder != $baseFolder){
            $baseFolder = 0;
        };*/


        /*
         * Others Folder?
         * */
        //return $data['folder'];

        $nowFolder = AccessHeader::where('filePath','like',$data['folder'].'%')->first();

        $sharedFolder = AccessDetail::where('accessId',$nowFolder['id'])->get();

        $baseSharedFolder = $othersFolder = $othersBaseFolder = '';

        if($sharedFolder->isEmpty()){
            $sharedFolder = AccessDetail::where('accessId',$nowFolder['parentAccessId'])->get();
            if(!$sharedFolder->isEmpty()){
                if($nowFolder['userId'] == $login->id && $nowFolder['parentAccessId'] == null) {
                    $othersFolder = 0;
                }else {
                    $othersFolder = 1;
                }
            }else{

                $othersFolder = 0;
                if($nowFolder['parentAccessId'] != null) {
                    $baseSharedFolder = 0;
                }else{
                    $baseSharedFolder = 1;
                }
            }
        }

        /**
         * Klo tidak empty
        */

        else{
            if($nowFolder['userId'] == $login->id && $nowFolder['parentAccessId'] == null){ //folderkita
                $othersFolder = 0;
                $baseSharedFolder = 1;
/*                if($othersFolder['accessParentId'] == null){
                    $baseSharedFolder = 1;
                }else{
                    $baseSharedFolder = 0;
                }*/
            }else{
                $othersFolder = 1;
            }
        }

        $accessh = '';

        $flag[0] = 2;
        $flag[1] = 2;
        $loginArray = '';

        if (!is_null($login->staffId)) {
            $loginArray[] = $login->staffs->position;
        }elseif(!is_null($login->pengurusId)){
            $loginArray[] = $login->pengurus->department;
        }

        //foreach ($data['subfolders'] as $path) {
            //$accessh = AccessHeader::where('filePath', $path . '/')->first()['userId'];
            $aheadsFolder = AccessHeader::select('filePath')
                ->where('userId', $login->id)
                ->where('type', 'folder')
                ->whereNotIn('name',$loginArray)
                ->get();

            $aheadsFile = AccessHeader::select('filePath')
                ->where('userId', $login->id)
                ->where('type', 'file')
                ->get();

        $shareTo = AccessHeader::where('filePath',$folder.'/');

        $sharedToSekretarisJenderal = $sharedToWakilSekretarisJenderal = $sharedToSekretaris = $sharedToFundraiser
        = $sharedToKeuangan = $sharedToLiteratur = $sharedToMedia = $sharedToUmum
        = $sharedToPengurusHarianNasional = $sharedToBadanPengurusNasional
            = $sharedToBadanPembina = $sharedToBadanPengawas =  0;

        if(!$shareTo->get()->isEmpty()) {
            if (!$shareTo->first()->accessDetails->where('shareTo','Badan Pembina')->isEmpty()){
                $sharedToBadanPembina = 1;
            };

            if (!$shareTo->first()->accessDetails->where('shareTo','Badan Pengawas')->isEmpty()){
                $sharedToBadanPengawas = 1;
            };

            if (!$shareTo->first()->accessDetails->where('shareTo','Pengurus Harian Nasional')->isEmpty()){
                $sharedToPengurusHarianNasional = 1;
            };

            if (!$shareTo->first()->accessDetails->where('shareTo','Badan Pengurus Nasional')->isEmpty()){
                $sharedToBadanPengurusNasional = 1;
            };

            if (!$shareTo->first()->accessDetails->where('shareTo','Wakil Sekretaris Jenderal')->isEmpty()){
                $sharedToWakilSekretarisJenderal = 1;
            }

            ;if (!$shareTo->first()->accessDetails->where('shareTo','Sekretaris Jenderal')->isEmpty()){
                $sharedToSekretarisJenderal = 1;
            };

            if (!$shareTo->first()->accessDetails->where('shareTo','Sekretaris')->isEmpty()){
                $sharedToSekretaris = 1;
            }

            if (!$shareTo->first()->accessDetails->where('shareTo','Keuangan')->isEmpty()){
                $sharedToKeuangan = 1;
            }

            if (!$shareTo->first()->accessDetails->where('shareTo','Fundraiser')->isEmpty()){
                $sharedToFundraiser = 1;
            }

            if (!$shareTo->first()->accessDetails->where('shareTo','Media')->isEmpty()){
                $sharedToMedia = 1;
            }

            if (!$shareTo->first()->accessDetails->where('shareTo','Umum')->isEmpty()){
                $sharedToUmum = 1;
            }

            if (!$shareTo->first()->accessDetails->where('shareTo','Literatur')->isEmpty()){
                $sharedToLiteratur = 1;
            }
        }

        return view('file.file_lists',$data,compact(
            'sharedToBadanPembina',
            'sharedToBadanPengawas',
            'sharedToPengurusHarianNasional',
            'sharedToBadanPengurusNasional',
            'sharedToSekretarisJenderal',
            'sharedToWakilSekretarisJenderal',
            'sharedToSekretaris',
            'sharedToKeuangan',
            'sharedToFundraiser',
            'sharedToUmum',
            'sharedToLiteratur',
            'sharedToMedia',
            'myFolder','login','aheadsFolder','aheadsFile','baseFolder','accessh','flag','othersFolder','baseSharedFolder'));
    }



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire