public function index()
{
$countHousesByCities = $this->houseModel->countHousesByCities();
$numberHousesSell = $this->houseModel->getCountHousesSell();
$numberHousesRent = $this->houseModel->getCountHousesRent();
$numberProjects = $this->projectModel->getCountProjects();
$numberDesigns = $this->designModel->getCountDesigns();
$numberResources = $numberHousesSell + $numberHousesRent + $numberProjects + $numberDesigns;
$ratioHousesSell = \Kan\Core\Num::ratio($numberHousesSell, $numberResources);
$ratioHousesRent = \Kan\Core\Num::ratio($numberHousesRent, $numberResources);
$ratioProjects = \Kan\Core\Num::ratio($numberProjects, $numberResources);
$ratioDesigns = \Kan\Core\Num::ratio($numberDesigns, $numberResources);
$countCitiesByQuantityAndHousesSell = $this->houseModel->getCountCitiesByQuantityAndHousesSell();
$countCitiesByQuantityAndHousesRent = $this->houseModel->getCountCitiesByQuantityAndHousesRent();
$countCitiesByQuantityAndProjects = $this->projectModel->getCountCitiesByQuantityAndProjects();
$countCitiesByQuantityAndDesigns = $this->designModel->getCountCitiesByQuantityAndDesigns();
return view('charts.index')->with('countHousesByCities', json_encode($countHousesByCities))->with('countResourcesByQuantity', json_encode([$numberHousesSell, $numberHousesRent, $numberProjects, $numberDesigns]))->with('ratioResourceByQuantity', json_encode([$ratioHousesSell, $ratioHousesRent, $ratioProjects, $ratioDesigns]))->with('countCitiesByQuantityAndHousesSell', json_encode($countCitiesByQuantityAndHousesSell))->with('countCitiesByQuantityAndHousesRent', json_encode($countCitiesByQuantityAndHousesRent))->with('countCitiesByQuantityAndProjects', json_encode($countCitiesByQuantityAndProjects))->with('countCitiesByQuantityAndDesigns', json_encode($countCitiesByQuantityAndDesigns));
}
public function getTotalAmount($projectId)
{
$project = Project::findOrFail($projectId);
$dailyLaborSets = $project->dailyLabors->groupBy('pivot.daily_labor_id');
$totalAmountSet = $dailyLaborSets->map(function ($dailyLabors) {
return $dailyLabors->sum('pivot.amount');
});
return response()->json(['total_amount' => $totalAmountSet]);
}
public function store($projectId, Request $request)
{
$project = Project::findOrFail($projectId);
$dailyRecord = $project->dailyRecords()->whereDate((new DailyRecord())->getTable() . '.created_at', '=', new Carbon('today'))->first();
if ($dailyRecord) {
$dailyRecord->update(['inspection_record' => $request->input('inspection_record'), 'important_record' => $request->input('important_record')]);
} else {
$project->dailyRecords()->create(['inspection_record' => $request->input('inspection_record'), 'important_record' => $request->input('important_record')]);
}
return response()->json();
}
/**
* Remove the specified resource from storage.
* DELETE /users/{id}
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
// Delete everything related to the user
Task::where('user_id', Auth::id())->delete();
Credential::where('user_id', Auth::id())->delete();
Project::where('user_id', Auth::id())->delete();
Client::where('user_id', Auth::id())->delete();
User::where('id', Auth::id())->delete();
// Logout and redirect back to home page
Auth::logout();
return Redirect::to('/');
}
public function projectCart($slug, Project $project)
{
$this->data['project'] = $project->getBySlug($slug);
return view('pages.project_cart', $this->data);
}
public function getBouncesByProject($projectId, Request $request)
{
$project = Project::findOrFail($projectId);
$query = $project->costEstimations();
if ($request->has('cost_estimation_id')) {
$costEstimation = $project->costEstimations()->findOrFail($request->input('cost_estimation_id'));
$query->whereDate('settled_at', '<=', $costEstimation->settled_at);
}
$costEstimations = $query->with('bounces')->get();
$results = $costEstimations->map(function ($costEstimation) {
return $costEstimation->bounces;
})->collapse()->map($this->getJsonTransformer());
return response()->json(['cost_estimation_bounces' => $results]);
}
public function show($projectId, $checklistId)
{
$project = Project::findOrFail($projectId);
$checklist = ProjectChecklist::findOrFail($checklistId);
return view('project-checklists.show')->withProject($project)->withChecklist($checklist);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response*/
public function edit($id)
{
$data['district'] = $district = District::find($id);
if ($district) {
$data['projects'] = Project::orderby('name', 'asc')->lists('name', 'id');
$data['cancelbtn'] = Permission::hasPermission('districts.index');
return view('districts.edit', $data);
} else {
Session::flash('danger', Lang::get('ruban.district.notfound'));
return Redirect::route('ruban.districts.index');
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy(Project $project)
{
$project->delete();
return Redirect::route('projects.index')->with('message', 'Project deleted.');
}
