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.filePathfromaccessheaderinner joinaccessdetailonaccessheader.id=accessdetail.accessIdwhereaccessdetail.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