/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($code)
{
if (Gate::denies('show-document')) {
abort(403);
}
$document = Document::getByPublicCode($code);
return $this->edit($document);
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
view()->composer('frontend.layout.header', function ($view) {
$view->with('user', Auth::user());
});
view()->composer('frontend.partials.domainsTree', function ($view) {
$domains = Domain::getCurrentDomains();
$tree = Domain::getTree(Domain::getDomainsForTree($domains));
$view->with(['tree' => $tree, 'domains' => $tree[1]['subdomains']]);
});
view()->composer('frontend.partials.domainsTreeForReports', function ($view) {
$domains = Domain::getCurrentDomains();
$tree = Domain::getTree(Domain::getDomainsForTree($domains));
$view->with(['tree' => $tree, 'domains' => $tree[1]['subdomains']]);
});
Document::deleted(function ($document) {
$fileToDelete = UploadedFile::where('id', '=', $document['uploaded_file_id'])->get();
$fileToDelete = $fileToDelete[0]['file_name'];
File::delete(storage_path() . '/documents/' . $fileToDelete);
$document->file()->delete();
return true;
});
}
public function queryDocument(Request $request)
{
$queryDocumentName = $request->input('name');
$documentIds = DocumentTranslation::where('title', 'like', '%' . $queryDocumentName . '%')->where('locale', \App::getLocale())->lists('document_id');
$documents = Document::whereIn('id', $documentIds)->get();
$result = [];
foreach ($documents as $document) {
$result[] = ['id' => $document->id, 'title' => $document->title, 'file' => $document->file->original_file_name, 'data' => $document->init_at ? $document->init_at->format('d-m-Y') : '-', 'file_name' => $document->file->file_name];
}
return $result;
}
protected function importRemainingDocuments()
{
$initDocuments = Document::count();
$lostDocuments = [];
$documentsForExtendedIssues = [];
$pathToFiles = sprintf('%s/var/www/andr_v2/uploads/reldocs/propid_/stepid_', storage_path());
$dbPathToFile = '/var/www/andr_v2/uploads/reldocs/propid_/stepid_/';
$oldDocuments = DB::connection('oldissue')->select('select * from relateddoc
where propid > 120 and stepid <> 0
');
$getFileNamesFromFolder = array_diff(scandir($pathToFiles), ['.', '..']);
foreach ($oldDocuments as $document) {
if (!$document->filepaths) {
continue;
}
if (strpos($document->filepaths, $dbPathToFile) === 0) {
$lostDocuments[] = $document;
}
}
foreach ($lostDocuments as $document) {
$fullPathToFile = $document->filepaths;
$file = str_replace($dbPathToFile, '', $fullPathToFile);
if (!in_array($file, $getFileNamesFromFolder)) {
continue;
}
do {
$randomName = str_random(40);
} while (UploadedFile::where('file_name', $randomName)->count() > 0);
do {
$codPublic = str_random(40);
} while (Document::where('public_code', $codPublic)->count() > 0);
$uploadedFileData = ['file_name' => $randomName, 'folder' => '/documents/', 'original_file_name' => $file];
$this->moveFile(storage_path() . $fullPathToFile, $uploadedFileData['file_name']);
$doc = factory(Document::class)->create(['public' => 1, 'uploaded_file_id' => factory(UploadedFile::class)->create($uploadedFileData)->id, 'public_code' => $codPublic, 'init_at' => $document->initat]);
$translatableData = ['ro' => ['title' => $document->content ? $document->content : ''], 'en' => ['title' => $document->encontent ? $document->encontent : '']];
$doc->fill($translatableData);
$doc->save();
try {
$doc->steps()->attach($document->stepid);
} catch (\Exception $e) {
print_r("Shiit! O relatie Document - FlowStep nu s-a putut importa.\n");
}
}
echo sprintf("Au fost recuperate %s documente salvate la comun intr-un folder.\n", $count = Document::count() - $initDocuments);
return true;
}
