public function index()
{
$user_id = $this->user->id;
$ownership = Projects::where('project_owner', $user_id)->where('status', '1')->get()->toArray();
$membership = DB::select("SELECT * FROM projects WHERE find_in_set({$user_id}, project_members) <> 0 AND status = 1");
return view('dashboard.index', compact('ownership', 'membership'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$scenario = Scenarios::select('scenarios.*', 'context_scenario_ideal_way.context_name', 'context_scenario_ideal_way.full_name')->leftJoin('context_scenario_ideal_way', 'context_scenario_ideal_way.id', '=', 'scenarios.context_id')->where('scenarios.id', $id)->first();
$project = Projects::find($scenario->project_id);
$requirements = Requirements::leftJoin('users', 'users.id', '=', 'requirements.user_id')->select('requirements.*', 'users.name as created_by')->where('scenario_id', $id)->latest()->get();
$breadcrumbs = array('Projects' => '/projects', 'Scenarios' => "/projects/{$scenario->project_id}");
return view('scenarios.details', compact('scenario', 'project', 'requirements', 'breadcrumbs'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$empactive = "class=active";
$title = 'Employees Page';
$cnt = 1;
$employee = $this->employee->get();
$projects = Projects::get();
return view('employee.index', compact('title', 'employee', 'cnt', 'projects', 'empactive'));
}
public function portfolio()
{
$portfolio = Projects::all();
$image_array = [];
foreach ($portfolio as $images) {
$image_array["{$images->id}"] = explode(",", $images->imgpath);
}
//dd($image_array);
return view('main.portfolio', ['model' => $portfolio, 'images' => $image_array]);
}
public function project(Request $request)
{
sleep(10);
$project = Projects::where('projectsId', '=', $request->projectsId)->first();
array_add($project, 'slug', Handler::createSlug($project->title, '-'));
if (count($project->movie) > 0) {
foreach ($project->movie as $movie) {
array_add($movie, 'embed', ProjectsMovie::embedVideo($movie->url));
}
}
$project->tags = str_replace(',', ', ', $project->tags);
return view('website.project')->with(compact('project'));
}
public function index(Request $request)
{
if ($request->getRequestUri() != '/') {
$buttonClick = $request->getUri();
}
//WEBSITE SETTINGS
$websiteSettings = Handler::readFile("websiteSettings.json");
$projects = Projects::orderBy('sortorder', 'asc')->get();
$lastProject = 0;
foreach ($projects as $key => $project) {
array_add($project, 'bootstrapColumn', Projects::bootstrapColumns($key));
array_add($project, 'imagePrefixName', Projects::imagePrefixName($key));
array_add($project, 'slug', Handler::createSlug($project->title, '-'));
$lastProject = $project->sortorder;
}
return view('website.index')->with(compact('websiteSettings', 'projects', 'lastProject', 'buttonClick'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Projects::where('id', $id)->delete();
return back()->withSuccess('Project deleted successfully!');
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($project_id, $id)
{
$task = Tasks::findOrFail($id);
$taskUsers = DB::table('taskUser')->join('users', 'users.id', '=', 'taskUser.user_id')->where('task_id', '=', $id)->get();
$projectInfo = Projects::findOrFail($project_id);
$teams = DB::table('teams')->get();
$usersTask = DB::table('users')->get();
return view('admin.task.edit', ['projectInfo' => $projectInfo, 'teams' => $teams, 'usersTask' => $usersTask, 'task' => $task, 'taskUsers' => $taskUsers]);
}
public function store()
{
if (Request::ajax()) {
$inputData = Request::get('form#createProject');
parse_str($inputData, $formFields);
$projectData = array('code' => $formFields['projectCode'], 'name' => $formFields['projectName'], 'version' => $formFields['projectVersion'], 'startDate' => $formFields['projectStartDate'], 'endDate' => $formFields['projectEndDate']);
$rules = array('code' => 'required|min:3|alpha_num', 'name' => 'required|min:3', 'version' => 'required|min:1', 'startDate' => 'required|date', 'endDate' => 'required|date');
$validator = Validator::make($projectData, $rules);
if ($validator->fails()) {
return Response::json(array('fail' => true, 'errors' => withErrors($validator)));
} else {
Projects::create($projectData);
$response = array('status' => 'success', 'msg' => 'Setting created successfully');
return Response::json($response);
}
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$data = Projects::findOrFail($id);
$data->delete();
return redirect('project')->with('status', 'Delete Complete');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$project = Projects::findOrFail($id);
$projectTask = Projects::findOrFail($id)->taskProject()->count();
if ($projectTask > 0) {
return redirect('admin/project')->withErrors("Sorry. You can't DELETE this project. You must DELETE all task of project");
} else {
File::delete(base_path() . '/public/' . $project->projectCharter);
$project->delete();
return redirect('admin/project')->withErrors("DELETED Project Done");
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$project = Projects::findOrFail($id);
if ($project->project_owner != $this->user['id']) {
Session::flash('flash_message_warning', 'Sorry, you do not have enough privilege to make this change!');
return redirect('projects');
}
$project->delete();
Session::flash('flash_message', 'Project successfully deleted!');
return redirect("projects");
}
public function posteditportfolio(Request $request)
{
if (empty($request->input('updateid'))) {
$model = new Projects();
if ($request->hasFile('image')) {
$files = $request->file('image');
$medias = [];
$errors = [];
foreach ($files as $file) {
$destenition = public_path() . "/img/";
$extension = $file->getClientOriginalExtension();
$fileName = rand(11111, 99999) . '.' . $extension;
$file->move($destenition, $fileName);
array_push($medias, $fileName);
$images = implode(",", $medias);
}
}
$model->name = $request->input('name');
$model->description = $request->input('description');
$model->additional_description = $request->input('additional_description');
$model->url = $request->input('url');
if (isset($images)) {
$model->imgpath = $images;
}
if ($model->save()) {
return redirect('/admin');
}
} else {
$model = Projects::find($request->input('updateid'));
if ($request->hasFile('image')) {
$files = $request->file('image');
$medias = [];
foreach ($files as $file) {
$destenition = public_path() . "/img/";
$extension = $file->getClientOriginalExtension();
$fileName = rand(11111, 99999) . '.' . $extension;
$file->move($destenition, $fileName);
array_push($medias, $fileName);
$images = implode(",", $medias);
}
}
$model->name = $request->input('name');
$model->description = $request->input('description');
$model->additional_description = $request->input('additional_description');
$model->url = $request->input('url');
if (isset($images)) {
$model->imgpath = $images;
}
if ($model->save()) {
return redirect('/admin');
}
}
}
public function projects()
{
$projects = Projects::all();
return view('page.projects')->with('projects', $projects);
}
public function review(Request $request)
{
$requirement_id = $request->segment(2);
$requirement = Requirements::find($requirement_id);
$project = Projects::find($requirement->project_id);
DB::enableQueryLog();
$context = ContextScenarioUserAppInteraction::leftJoin('users', 'users.id', '=', 'context_scenario_user_app_interaction.user_id')->leftJoin('context_scenario_ideal_way AS context', 'context.id', '=', 'context_scenario_user_app_interaction.context_id')->leftJoin('context_ratings as CR', 'CR.context_id', '=', 'context_scenario_user_app_interaction.id')->select('context_scenario_user_app_interaction.*', 'users.name AS user_name', 'context.context_name', 'context.full_name', DB::raw('avg(CR.rating) AS avg_rating,
count(CR.id) AS rating_count'))->where('requirement_id', $requirement_id)->groupBy('context_scenario_user_app_interaction.id')->get()->toArray();
$context_voting = ContextScenarioUserAppInteraction::leftJoin('ways_of_interaction_voting as WOIV', 'WOIV.context_id', '=', 'context_scenario_user_app_interaction.id')->select('context_scenario_user_app_interaction.id', DB::raw('sum(WOIV.accompanying) as accompanying_count,
sum(WOIV.intermittent) as intermittent_count,
sum(WOIV.interrupting) as interrupting_count'))->where('requirement_id', $requirement_id)->groupBy('context_scenario_user_app_interaction.id')->get()->toArray();
foreach ($context as &$value1) {
foreach ($context_voting as $value2) {
if ($value1['id'] == $value2['id']) {
$value1 = array_merge($value1, $value2);
}
}
}
usort($context, function ($i, $j) {
$a = $i['avg_rating'];
$b = $j['avg_rating'];
if ($a == $b) {
return 0;
} elseif ($a > $b) {
return 1;
} else {
return -1;
}
});
$context = array_reverse($context);
$breadcrumbs = array('Projects' => '/projects', 'All Requirements' => "/projects/{$requirement->project_id}");
return view('requirements.review', compact('requirement', 'context', 'project', 'breadcrumbs'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$issues = Projects::lists('title', 'id');
$file = Modules::findOrFail($id);
return view('modules.edit', compact('file', 'issues'));
}
public function delete(Request $request)
{
if (!ACL::hasPermission('projects', 'delete')) {
return redirect(route('projects'))->withErrors(['You don\'t have permission for delete the projects.']);
}
//DELETE FOLDER BEFORE DELETE IN DATABASE
$directory = $this->folder . $request->get('projectsId');
File::deleteDirectory($directory);
ProjectsGallery::deleteGalleryByProject($request->get('projectsId'));
ProjectsMovie::deleteMoviesByProject($request->get('projectsId'));
Projects::find($request->get('projectsId'))->delete();
$success = "Project deleted successfully.";
return redirect(route('projects'))->with(compact('success'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function public_modules($id)
{
$projectName = Projects::where('id', '=', $id)->pluck('title');
$moduleDara = Modules::whereproject_id($id)->get();
return view('public_journal.public_modules', compact('projectName', 'moduleDara'));
}
