public function listFiles($target, $target_action, $target_id)
{
$resource_type = 'App\\Models\\' . ucfirst(str_singular($target));
$uploader_id = Auth::user()->active_contact->id;
if ($target == "posts") {
if ($target_action == "create") {
$post = Post::where('author_id', $uploader_id)->where("status_id", "=", POST_DRAFT_STATUS_ID)->where("ticket_id", $target_id)->first();
} elseif ($target_action == "edit") {
$post = Post::where("id", $target_id)->first();
}
$id = isset($post->id) ? $post->id : null;
} elseif ($target == "tickets") {
if ($target_action == "create") {
$ticket = Ticket::where('status_id', TICKET_DRAFT_STATUS_ID)->where('creator_id', $uploader_id)->first();
} else {
$ticket = Ticket::where("id", $target_id)->first();
}
$id = isset($ticket->id) ? $ticket->id : null;
} elseif ($target == "people") {
$target_id = is_null($target_id) ? Auth::user()->owner->id : $target_id;
$person = Person::find($target_id);
$id = $person->id;
}
$files = is_null($id) ? [] : File::where('resource_type', $resource_type)->where("resource_id", $id)->get();
foreach ($files as $file) {
$file->size = filesize(RESOURCES . DS . $file->file_path . DS . $file->file_name);
}
return $files;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$filecount = \App\Models\File::where('file_type_id', $id)->count();
if ($filecount > 0) {
return back()->withMsg('There are files in the category');
}
FileType::findOrFail($id)->delete();
return back();
}
public function delete(Request $request, $banqueId, $fileId)
{
// verify request inputs
if (is_null($fileId)) {
return response()->json(['error' => 'Bad request'], HttpResponse::HTTP_BAD_REQUEST);
} else {
$item = File::where('id_File', '=', $fileId)->delete();
return is_null($item) ? response()->json(['error' => 'Bad request'], HttpResponse::HTTP_BAD_REQUEST) : $item;
}
}
public function index()
{
$fields = Field::all();
$fileTitles = File::distinct()->groupBy('parsed_title')->select('parsed_title')->get();
$fileArray = [];
foreach ($fileTitles as $title) {
$file = File::where('parsed_title', '=', $title->parsed_title)->select('parsed_date', 'full_title')->orderBy('parsed_date', 'desc');
$fileData = $file->get();
foreach ($file->get() as $multiFile) {
$fileArray[$title->parsed_title][] = $multiFile;
}
}
return view("home.index")->with('fileArray', $fileArray);
}
/**
* API - get list of files, optionally filtered by category
*/
public function APIindex($category = null)
{
// get all files of this category
if ($category) {
if ($category == 'newest') {
// Recently added files
$files = File::orderBy('id', 'desc')->paginate(18);
} else {
$files = File::where('file_category_id', $category)->paginate(18);
}
} else {
$files = File::paginate(18);
}
return response()->json($files);
}
public function addComments(Request $request)
{
$name = $request->name;
$end = isset($request->end) ? strtotime($request->end) : time();
$start = isset($request->start) ? strtotime($request->start) : $end - 86400 * 180;
$site = isset($request->site) ? $request->site : '';
$mode = isset($request->mode) ? $request->mode : '';
$f = $s = 0;
if (empty($name) || empty($site) || empty($mode)) {
return AJAX::argumentError();
}
$file = File::where(array('name' => $name))->first();
if (empty($file) || empty($file->path)) {
return AJAX::notExist();
}
$list = $this->getFileContents($file->path);
switch ($mode) {
case 'insertComments':
$result = $this->checkCommentsFile($list, 4);
break;
case 'insertCommentsWithTid':
$result = $this->checkCommentsFile($list, 5);
break;
default:
$result['code'] = 500;
$result['data'] = 'arguments error';
break;
}
if ($result['code'] != 200) {
return AJAX::badData(array('message' => $result['message']));
}
$commentModule = new CommentModule($site);
foreach ($list as $line) {
$comment_time = $this->getCommentRandTime($start, $end);
$res = $commentModule->addCommentByLine($line, $comment_time, $mode);
if ($res['code'] != 200) {
Log::error($site . ':' . $name . $res['message']);
$f++;
continue;
}
$s++;
}
return AJAX::success(array('success' => $s, 'fail' => $f));
}
public function detail($banqueId = null)
{
if (is_null($banqueId)) {
// display the hole banque
return view('banque', ['banqueItems' => Banque::all(), 'contexteItems' => Contexte::all(), 'critereItems' => Critere::all(), 'domaineItems' => Domaine::all(), 'systemeItems' => Systeme::all(), 'competenceItems' => Competence::all(), 'enseignantList' => Enseignant::all()]);
} else {
// display specific banque
$banque = $this->gestSession->getBanque($banqueId);
$items = Item::join('TitreGItem', 'TitreGItem.id_TitreGItem', '=', 'Item.id_TitreGItem')->where('Item.id_Banque', '=', $banqueId)->join('Competence', 'Item.id_Competence', '=', 'Competence.id_Competence')->get();
$auteurs = Banque_Enseignant::where('id_Banque', '=', $banqueId)->get();
$files = File::where('id_Banque', '=', $banqueId)->get();
return view("banqueDetail")->with("banque", $banque)->with("items", $items)->with("files", $files)->with("auteurs", $auteurs);
}
}
public function getFilesByTypeId($id)
{
$file = File::where('file_type_id', $id)->get();
return response()->json($file);
}
public function files($user)
{
$files = File::where("folder_id", $this->id)->where("created_by", $user->id)->orderBy("name")->get();
return $files;
}
/**
* Function Remove
* Process Delete the Brand Data
*
* @return \Illuminate\Http\JsonResponse
*/
public function onDelete()
{
$id = Input::get('id');
$Model = \App\Models\File::select(['id', 'name'])->where('id', $id)->first();
$path = base_path() . '/public/uploads/';
if ($Model) {
File::delete($path . $Model->name);
\App\Models\File::where('id', $id)->delete();
\App\Models\FileUser::where('file_id', $id)->delete();
$param['message'] = Lang::get('message.has deleted');
$param['error'] = false;
} else {
$param['message'] = Lang::get('message.has error');
$param['error'] = true;
}
return json_encode($param);
}
