public function fillDocument($request)
{
Storage::makeDirectory(DOCUMENTS_LOCATION);
if ($request->date === '') {
$this->init_at = null;
} else {
$this->init_at = $request->date;
}
if (!$this->public_code) {
$this->public_code = $this->createPublicCode();
}
$this->public = true;
if ($request->file('file')) {
if ($this->file) {
$this->file->delete();
}
$file = new UploadedFile();
$file->storeFile(DOCUMENTS_LOCATION, $request->file('file'));
$this->file()->associate($file);
}
foreach (\Config::get('app.all_locales') as $locale) {
$this->translateOrNew($locale)->title = $request->get('title')[$locale];
}
$this->save();
}
public function setAll($request)
{
$this->date = $request->get('date');
if ($request->get('report_type') === "") {
$this->report_type = 0;
}
$this->report_type = $request->get('report_type');
if (!$this->public_code) {
$this->public_code = $this->createPublicCode();
}
if ($request->file('document_file')) {
if ($this->file) {
$this->file()->delete();
}
$DocumentFile = new UploadedFile();
$DocumentFile->storeFile(REPORT_LOCATION, $request->file('document_file'));
$this->file()->associate($DocumentFile);
}
foreach (\Config::get('app.all_locales') as $locale) {
$this->translateOrNew($locale)->title = $request->get('title')[$locale];
$this->translateOrNew($locale)->description = $request->get('description')[$locale];
}
$this->public = $request->public == true;
$this->save();
if (!$request->get('domains_connected')) {
$domains_connected = [];
} else {
$domains_connected = $request->get('domains_connected');
}
$this->domains()->sync($domains_connected);
}
public function setAll($request)
{
$this->photo_source = $request->photo_source;
$this->name = $request->get('name');
$this->type = $request->get('type');
$this->site = $request->get('site');
$this->email = $request->get('email');
$this->telephone = $request->get('telephone');
$this->published = $request->get('published') == true;
if (!$this->public_code) {
$this->public_code = $this->createPublicCode();
}
if ($request->file('cv_file')) {
if ($this->fileCv) {
$this->fileCv()->delete();
}
$cvFile = new UploadedFile();
$cvFile->storeFile(CV_LOCATION, $request->file('cv_file'));
$this->fileCv()->associate($cvFile);
}
if ($request->file('poza_file')) {
if ($this->filePoza) {
$this->filePoza()->delete();
}
$pozaFile = new UploadedFile();
$pozaFile->storeFile(POZA_LOCATION, $request->file('poza_file'));
$this->filePoza()->associate($pozaFile);
}
foreach (\Config::get('app.all_locales') as $locale) {
$this->translateOrNew($locale)->address = $request->get('address')[$locale];
$this->translateOrNew($locale)->other_details = $request->get('other_details')[$locale];
$this->translateOrNew($locale)->profile = $request->get('profile')[$locale];
$this->translateOrNew($locale)->position = $request->get('position')[$locale];
$this->translateOrNew($locale)->org_name = $request->get('org_name')[$locale];
}
$this->save();
// Refresh connected stakeholders
if (!$request->get('stakeholders_connected')) {
$stakeholders_connected = [];
} else {
$stakeholders_connected = $request->get('stakeholders_connected');
}
// Detach connected stakeholders
foreach ($this->stakeholdersConnectedOfThem as $scof) {
$this->stakeholdersConnectedOfThem()->detach($scof->id);
}
$this->stakeholdersConnectedOfMine()->sync($stakeholders_connected);
}
public function setAll($request)
{
$this->date = $request->get('date');
$this->link = $request->get('link');
if (!$this->public_code) {
$this->public_code = $this->createPublicCode();
}
if ($request->file('document_file')) {
if ($this->fileDocument) {
$this->fileDocument()->delete();
}
$DocumentFile = new UploadedFile();
$DocumentFile->storeFile(DOCUMENT_LOCATION, $request->file('document_file'));
$this->fileDocument()->associate($DocumentFile);
}
foreach (\Config::get('app.all_locales') as $locale) {
$this->translateOrNew($locale)->title = $request->get('title')[$locale];
$this->translateOrNew($locale)->description = $request->get('description')[$locale];
}
$this->save();
if (!$request->get('stakeholders_connected')) {
$stakeholders_connected = [];
} else {
$stakeholders_connected = $request->get('stakeholders_connected');
}
$this->connectedStakeholders()->sync($stakeholders_connected);
if (!$request->get('domains_connected')) {
$domains_connected = [];
} else {
$domains_connected = $request->get('domains_connected');
}
$this->connectedDomains()->sync($domains_connected);
if (!$request->get('issues_connected')) {
$issues_connected = [];
} else {
$issues_connected = $request->get('issues_connected');
}
$this->connectedIssues()->sync($issues_connected);
if (!$request->get('tags_connected')) {
$tags_connected = [];
} else {
$tags_connected = $request->get('tags_connected');
}
$this->connectedTags()->sync($tags_connected);
}
public function storeFile($directory, $uploadedFile)
{
Storage::makeDirectory($directory);
if (!$uploadedFile) {
return false;
}
do {
$this->file_name = str_random(40);
} while (UploadedFile::where('file_name', $this->file_name)->count() > 0);
$this->folder = $directory;
$this->original_file_name = $uploadedFile->getClientOriginalName();
$uploadedFile->move(storage_path() . $directory, $this->file_name);
$this->mime_type = File::mimeType(storage_path() . $directory . $this->file_name);
$this->save();
return true;
}
/**
* 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 downloadFile($fileName)
{
$entry = UploadedFile::where('file_name', $fileName)->firstOrFail();
return response()->download(storage_path() . $entry->folder . $entry->file_name, $entry->original_file_name);
}
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;
}
