public function getProjectData($slug)
{
// get the current project by slug
$currentProject = collect();
$projectID = \App\Project::getCurrentProjectBySlug($slug)->id;
$fullData = \App\Project::getFullProjectData($projectID);
$relatedProjects = \App\Project::getRelatedProjects($fullData);
// dump($fullData);
return view('cosplaydesign.pages.progetto', array('currentProject' => $fullData, 'related' => $relatedProjects));
}
public function getMemberData($slug)
{
$userdata = \App\User::getAllUserDataBySlug($slug);
$_projects = \App\User::getUsersProjects($userdata->id);
$friends = \App\Friends::getFriendsByUser($userdata->id);
// dump($friends);
$projects = collect();
foreach ($_projects as $project) {
$project = \App\Project::getFullProjectData($project->id);
$projects->push($project);
}
//dump($projects);
return view('cosplaydesign.pages.profile', array("userdata" => $userdata, "projects" => $projects, "friends" => $friends));
}
public static function getRelatedProjects($currentProject)
{
//dump($currentProject);
$idcategoria = $currentProject->category->id;
$categoriaSlug = $currentProject->category->slug;
$idgenere = $currentProject->gender[0]->id;
$genereSlug = $currentProject->gender[0]->slug;
$baseProjects = \App\Project::where("serie_id", "=", $currentProject->serie_id)->where("id", "!=", $currentProject->id)->where('published_at', '<=', 'NOW()')->where('is_published', '=', true)->orderByRaw('RAND()')->paginate(4);
if (count($baseProjects) === 0) {
$baseProjects = \App\Project::where("macro_category_id", "=", $currentProject->macro_category_id)->where("id", "!=", $currentProject->id)->where('published_at', '<=', 'NOW()')->where('is_published', '=', true)->orderByRaw('RAND()')->paginate(4);
}
$projectsComplete = collect();
foreach ($baseProjects as $project) {
$progetto = \App\Project::getFullProjectData($project->id);
$projectsComplete->push($progetto);
}
return $projectsComplete;
}
