public function tabs(Plan $plan)
{
// Take a business plan and create a tsv representation
$tsv = "Type\tDescription\tDue\tOwner\tLead\tCollaborators\tStatus\tSuccess Measures\r\n";
foreach ($plan->goals()->orderBy('body', 'asc')->get() as $goal) {
$tsv .= "Goal\t" . $goal->body . str_repeat("\t", 6) . "\r\n";
if (count($goal->objectives->all()) > 0) {
foreach ($goal->objectives()->orderBy('body', 'asc')->get() as $objective) {
$tsv .= "Objective\t" . $objective->body . str_repeat("\t", 6) . "\r\n";
if (count($objective->actions->all()) > 0) {
foreach ($objective->actions()->orderBy('body', 'asc')->get() as $action) {
$tsv .= "Action\t" . $action->body . "\t" . $action->date . "\t" . $action->owner . "\t" . $this->split_username_delimiters($action->lead) . "\t" . $this->split_username_delimiters($action->collaborators) . "\t" . $action->status . "\t" . $action->success . "\r\n";
if (count($action->tasks->all()) > 0) {
foreach ($action->tasks()->orderBy('body', 'asc')->get() as $task) {
$tsv .= "Task\t" . $task->body . "\t" . $task->date . "\t" . $task->owner . "\t" . $this->split_username_delimiters($task->lead) . "\t" . $this->split_username_delimiters($task->collaborators) . "\t" . $task->status . "\t" . $task->success . "\r\n";
}
}
}
}
}
}
}
file_put_contents("bp.tsv", $tsv);
return view('export.tsv');
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create(Zona $zona, Plan $plan, Cocina $cocina)
{
//
$zonas = $zona->get();
$planes = $plan->get();
$cocinas = $cocina->get();
return view('crear_restaurantes', compact('zonas', 'planes', 'cocinas'));
}
public function create(Request $request)
{
$plan = new Plan();
$plan->subject = $request->input('name');
$plan->save();
$drills = $request->input('drill');
foreach ($drills as $drill) {
$drill = Drill::where('name', '=', $drill)->get()->first();
$plan->drills()->attach($drill->id);
}
$drills = Drill::orderBy('created_at', 'asc')->get();
return view('design/plan', ['drills' => $drills]);
}
public function run()
{
DB::table('plans')->delete();
\App\Plan::create(['content' => 'Free content', 'description' => 'Crovv Free', 'price' => '0', 'title' => 'Free']);
\App\Plan::create(['content' => 'Expert content ', 'description' => 'Crovv Expert', 'price' => '10', 'title' => 'Expert']);
\App\Plan::create(['content' => 'Pro content ', 'description' => 'Crovv Pro', 'price' => '10', 'title' => 'Pro']);
}
/**
* Create a new controller instance.
*
* @return void
*/
public function __construct()
{
$this->middleware('auth');
$this->viewData['user_id'] = (int) Auth::User()->id;
$this->viewData['controller_heading'] = 'Initiatives';
$this->viewData['controller_name'] = $this->controller;
$this->viewData['whatisit'] = 'Initiative';
$this->viewData['plans'] = Plan::where('user_id', $this->viewData['user_id'])->where('status', 0)->orderBy('name')->lists('name', 'id');
$this->viewData['currentPlan'] = NULL;
if (!empty($_GET['plan_id'])) {
$this->viewData['currentPlan'] = Plan::find($_GET['plan_id']);
} else {
if (!empty($this->viewData['plans'])) {
$this->viewData['currentPlan'] = Plan::where('user_id', $this->viewData['user_id'])->where('status', 0)->orderBy('name')->get()->first();
}
}
$this->viewData['dimensions'] = Dimension::leftJoin('plans', 'plans.id', '=', 'dimensions.plan_id')->where('plans.user_id', $this->viewData['user_id'])->where('dimensions.plan_id', $this->viewData['currentPlan']->id)->where('dimensions.status', 0)->orderBy('dimensions.name')->select('dimensions.*')->lists('dimensions.name', 'dimensions.id');
$this->viewData['currentDimension'] = NULL;
if (!empty($_GET['dimension_id'])) {
$this->viewData['currentDimension'] = Dimension::find($_GET['dimension_id']);
} else {
if (!empty($this->viewData['dimensions'])) {
$this->viewData['currentDimension'] = Dimension::where('dimensions.plan_id', $this->viewData['currentPlan']->id)->where('dimensions.status', 0)->orderBy('dimensions.name')->get()->first();
}
}
$this->viewData['currentDimensionId'] = !empty($this->viewData['currentDimension']) ? $this->viewData['currentDimension']->id : '';
$this->viewData['objectives'] = Objective::leftJoin('dimensions', 'dimensions.id', '=', 'objectives.dimension_id')->leftJoin('plans', 'plans.id', '=', 'dimensions.plan_id')->where('plans.user_id', '=', $this->viewData['user_id'])->where('objectives.dimension_id', '=', $this->viewData['currentDimensionId'])->where('objectives.status', 0)->orderBy('objectives.name')->select('objectives.*')->lists('objectives.name', 'objectives.id');
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function getIndex()
{
$title = 'Dashboard';
$user = $this->user;
$plans = Plan::all();
return view('home.index', compact('title', 'user', 'plans'));
}
public function mfInsertUserDataIntoDB()
{
if (Request::ajax()) {
parse_str(Input::get('formData'), $formFields);
$domicilio = new Domicilio();
$domicilio->calle01 = $formFields['calle01'];
$domicilio->calle02 = $formFields['calle02'];
$domicilio->ciudad = $formFields['ciudadDomicilio'];
$domicilio->codigoPostal = $formFields['codigoPostal'];
$domicilio->save();
$plan = new Plan();
$plan->gas = array_key_exists('gas', $formFields) ? 1 : 0;
$plan->luz = array_key_exists('luz', $formFields) ? 1 : 0;
$plan->cable = array_key_exists('cable', $formFields) ? 1 : 0;
$plan->internet = array_key_exists('internet', $formFields) ? 1 : 0;
$plan->telefono = array_key_exists('phone', $formFields) ? 1 : 0;
$plan->estacionamiento = array_key_exists('estacionamiento', $formFields) ? 1 : 0;
$plan->comidas = array_key_exists('comidas', $formFields) ? 1 : 0;
$plan->lavanderia = array_key_exists('lavanderia', $formFields) ? 1 : 0;
$plan->limpieza = array_key_exists('limpieza', $formFields) ? 1 : 0;
$plan->save();
$hogar = new Hogar();
$hogar->idDomicilio = $domicilio->id;
$hogar->idPlan = $plan->id;
$hogar->nombre = $formFields['nombreHogar'];
$hogar->costo = $formFields['costoHogar'];
$hogar->clave = Hash::make($formFields['accesoHogar']);
$hogar->save();
$residente = new Residente();
$residente->idHogar = $hogar->id;
$residente->idUser = Auth::id();
$residente->nombre = $formFields['nombreResidente'];
$residente->fechaNacimiento = $formFields['fechaNacimiento'];
$residente->ciudadOrigen = $formFields['ciudadResidente'];
$residente->ocupacion = $formFields['ocupacion'];
$residente->intereses = $formFields['intereses'];
$residente->telefono = $formFields['telefono'];
$residente->imagen = $formFields['imagen'];
$residente->save();
Mail::send('myEmailViews.welcome-mail', ['user' => $residente->nombre, 'home' => $hogar->nombre, 'code' => $formFields['accesoHogar']], function ($message) {
$message->from('*****@*****.**', 'Roomity');
$message->to(Auth::user()->email);
$message->subject('Welcome to Roomity!');
});
return array('title' => 'Welcome, ' . $residente->nombre . '!', 'text' => $hogar->nombre . ' is now registered!', 'type' => 'success');
}
}
public function show($id)
{
$plan = Plan::getByKey($id);
if (!$plan) {
App::abort(404);
}
return $plan;
}
public function run()
{
DB::table('planes')->delete();
$C = App\Cobertura::where('nombre', 'like', '%OSDE%')->first();
App\Plan::create(["nombre" => "210", "cobertura_id" => $C->id]);
App\Plan::create(["nombre" => "310", "cobertura_id" => $C->id]);
App\Plan::create(["nombre" => "410", "cobertura_id" => $C->id]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
// $this->call(UserTableSeeder::class);
Model::reguard();
$userTest = User::create(['name' => 'userTest', 'email' => '*****@*****.**', 'password' => bcrypt('userTest'), 'height_inches' => 70]);
$workout1 = Workout::create(['user_id' => $userTest->id, 'title' => 'Push', 'note' => 'This is a note']);
$workout2 = Workout::create(['user_id' => $userTest->id, 'title' => 'Pull', 'note' => 'This is a note']);
$workout3 = Workout::create(['user_id' => $userTest->id, 'title' => 'Legs', 'note' => 'This is a note']);
$exercise1 = Exercise::create(['user_id' => $userTest->id, 'title' => 'Barbell Bench Press', 'max_one_rep_max' => 190, 'type' => 'Weighted', 'category' => 'Chest']);
$exercise2 = Exercise::create(['user_id' => $userTest->id, 'title' => 'Overhead Press', 'max_one_rep_max' => 100, 'type' => 'Weighted', 'category' => 'Shoulders']);
$exercise3 = Exercise::create(['user_id' => $userTest->id, 'title' => 'One Arm Row', 'max_one_rep_max' => 75, 'type' => 'Weighted', 'category' => 'Back']);
$exercise4 = Exercise::create(['user_id' => $userTest->id, 'title' => 'Pulldown', 'max_one_rep_max' => 200, 'type' => 'Weighted', 'category' => 'Back']);
$exercise5 = Exercise::create(['user_id' => $userTest->id, 'title' => 'Squats', 'max_one_rep_max' => 225, 'type' => 'Weighted', 'category' => 'Legs']);
$exercise6 = Exercise::create(['user_id' => $userTest->id, 'title' => 'Deadlifts', 'max_one_rep_max' => 200, 'type' => 'Weighted', 'category' => 'Legs']);
$session1 = Session::create(['user_id' => $userTest->id, 'exercise_id' => $exercise1->id, 'session_date' => Carbon::now()]);
$session2 = Session::create(['user_id' => $userTest->id, 'exercise_id' => $exercise2->id, 'session_date' => Carbon::now()]);
$session3 = Session::create(['user_id' => $userTest->id, 'exercise_id' => $exercise3->id, 'session_date' => Carbon::now()]);
$session4 = Session::create(['user_id' => $userTest->id, 'exercise_id' => $exercise4->id, 'session_date' => Carbon::now()]);
$session5 = Session::create(['user_id' => $userTest->id, 'exercise_id' => $exercise5->id, 'session_date' => Carbon::now()]);
$session6 = Session::create(['user_id' => $userTest->id, 'exercise_id' => $exercise6->id, 'session_date' => Carbon::now()]);
$sessionSet1 = SessionSet::create(['session_id' => $session1->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet2 = SessionSet::create(['session_id' => $session1->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet3 = SessionSet::create(['session_id' => $session1->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet4 = SessionSet::create(['session_id' => $session2->id, 'number_of_reps' => 8, 'weight_lifted' => 95, 'one_rep_max' => 100, 'failed' => false]);
$sessionSet5 = SessionSet::create(['session_id' => $session2->id, 'number_of_reps' => 8, 'weight_lifted' => 95, 'one_rep_max' => 100, 'failed' => false]);
$sessionSet6 = SessionSet::create(['session_id' => $session2->id, 'number_of_reps' => 8, 'weight_lifted' => 95, 'one_rep_max' => 100, 'failed' => false]);
$sessionSet7 = SessionSet::create(['session_id' => $session3->id, 'number_of_reps' => 8, 'weight_lifted' => 65, 'one_rep_max' => 80, 'failed' => false]);
$sessionSet8 = SessionSet::create(['session_id' => $session3->id, 'number_of_reps' => 8, 'weight_lifted' => 65, 'one_rep_max' => 80, 'failed' => false]);
$sessionSet9 = SessionSet::create(['session_id' => $session3->id, 'number_of_reps' => 8, 'weight_lifted' => 65, 'one_rep_max' => 80, 'failed' => false]);
$sessionSet10 = SessionSet::create(['session_id' => $session4->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet11 = SessionSet::create(['session_id' => $session4->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet12 = SessionSet::create(['session_id' => $session4->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet13 = SessionSet::create(['session_id' => $session5->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet14 = SessionSet::create(['session_id' => $session5->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet15 = SessionSet::create(['session_id' => $session5->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet16 = SessionSet::create(['session_id' => $session6->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet17 = SessionSet::create(['session_id' => $session6->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$sessionSet18 = SessionSet::create(['session_id' => $session6->id, 'number_of_reps' => 8, 'weight_lifted' => 180, 'one_rep_max' => 190, 'failed' => false]);
$plan1 = Plan::create(['user_id' => $userTest->id, 'title' => '5/3/1', 'start_date' => Carbon::now(), 'end_date' => Carbon::now()->addWeeks(4)]);
$planWorkout1 = PlanWorkout::create(['plan_id' => $plan1->id, 'workout_id' => $workout1->id]);
$planWorkout2 = PlanWorkout::create(['plan_id' => $plan1->id, 'workout_id' => $workout2->id]);
$planWorkout3 = PlanWorkout::create(['plan_id' => $plan1->id, 'workout_id' => $workout3->id]);
$planDate1 = PlanDate::create(['plan_workout_id' => $planWorkout1->id, 'planned_date' => Carbon::tomorrow()]);
$planDate2 = PlanDate::create(['plan_workout_id' => $planWorkout1->id, 'planned_date' => Carbon::tomorrow()->addDays(5)]);
$planDate3 = PlanDate::create(['plan_workout_id' => $planWorkout2->id, 'planned_date' => Carbon::tomorrow()->addDay()]);
$planDate4 = PlanDate::create(['plan_workout_id' => $planWorkout2->id, 'planned_date' => Carbon::tomorrow()->addDays(6)]);
$planExercise1 = PlanExercise::create(['plan_workout_id' => $planWorkout1->id, 'exercise_id' => $exercise1->id, 'weight_to_add_for_success' => 5, 'weight_to_sub_for_fail' => 5]);
$planExercise2 = PlanExercise::create(['plan_workout_id' => $planWorkout1->id, 'exercise_id' => $exercise2->id, 'weight_to_add_for_success' => 5, 'weight_to_sub_for_fail' => 5]);
$planSet1 = PlanSet::create(['plan_exercise_id' => $planExercise1->id, 'expected_reps' => 10, 'expected_weight' => 100]);
$planSet2 = PlanSet::create(['plan_exercise_id' => $planExercise1->id, 'expected_reps' => 10, 'expected_weight' => 100]);
}
public function planes(Request $request)
{
$planes = Plan::orderBy('nombre')->get();
$enterprises = new Enterprise();
$order = $request->input('order') == 'asc' ? 'ASC' : 'DESC';
if ($request->input('sort') == 'razon_social') {
$enterprises = Enterprise::orderBy('razon_social', $order);
} elseif ($request->input('sort') == 'created_at') {
$enterprises = Enterprise::orderBy('created_at', $order);
} elseif ($request->input('sort') == 'plan') {
$enterprises = Enterprise::select('enterprises.*', 'planes.created_at AS created_date', 'planes.id AS plan_id')->leftJoin('planes', 'planes.id', '=', 'enterprises.plan_id')->orderBy('planes.nombre', $order);
} elseif ($request->input('sort') == 'totals') {
$enterprises = Enterprise::select('enterprises.*', 'planes.created_at AS created_date', 'planes.id AS plan_id', \DB::raw('(select SUM(so.total) from sale_orders as so where so.enterprise_id = enterprises.id) AS total_sales'))->leftJoin('planes', 'planes.id', '=', 'enterprises.plan_id')->orderBy('total_sales', $order);
}
//Filters
$filtros = array();
$monto_plan = $planObj = null;
if ($request->input('tipo_plan')) {
$enterprises = $enterprises->where('plan_id', $request->input('tipo_plan'));
$filtros['tipo_plan'] = $request->input('tipo_plan');
$planObj = Plan::find($request->input('tipo_plan'));
$monto_plan = Enterprise::select(\DB::raw('SUM(payment_orders.monto) AS total_sales'))->where('plan_id', $request->input('tipo_plan'))->leftJoin('payment_orders', 'payment_orders.enterprise_id', '=', 'enterprises.id')->first();
}
if ($request->input('fecha_inic') != '' && $request->input('fecha_fin') != '') {
$inic_arr = explode('/', $request->input('fecha_inic'));
$inic = $inic_arr[2] . "-" . $inic_arr[1] . "-" . $inic_arr[0] . " 00:00:00";
$fin_arr = explode('/', $request->input('fecha_fin'));
$fin = $fin_arr[2] . "-" . $fin_arr[1] . "-" . $fin_arr[0] . " 11:59:59";
$enterprises = $enterprises->whereBetween('created_at', [$inic, $fin]);
$filtros['fecha_inic'] = $request->input('fecha_inic');
$filtros['fecha_fin'] = $request->input('fecha_fin');
} elseif ($request->input('fecha_inic') != '' && $request->input('fecha_fin') == '') {
$inic_arr = explode('/', $request->input('fecha_inic'));
$inic = $inic_arr[2] . "-" . $inic_arr[1] . "-" . $inic_arr[0] . " 00:00:00";
$enterprises = $enterprises->where('created_at', '>', $inic);
$filtros['fecha_fin'] = $request->input('fecha_fin');
} elseif ($request->input('fecha_inic') == '' && $request->input('fecha_fin') != '') {
$fin_arr = explode('/', $request->input('fecha_fin'));
$fin = $fin_arr[2] . "-" . $fin_arr[1] . "-" . $fin_arr[0] . " 11:59:59";
$enterprises = $enterprises->where('created_at', '<', $fin);
$filtros['fecha_inic'] = $request->input('fecha_inic');
}
$enterprises = $enterprises->paginate(10);
//Log::info($lastQuery);
$order_colunm = $order == 'ASC' ? 'desc' : 'asc';
$param_nombre = array_merge(['sort' => 'razon_social', 'order' => $order_colunm], $filtros);
$param_date = array_merge(['sort' => 'created_at', 'order' => $order_colunm], $filtros);
$param_plan = array_merge(['sort' => 'plan', 'order' => $order_colunm], $filtros);
$param_total = array_merge(['sort' => 'totals', 'order' => $order_colunm], $filtros);
return view('report.index', compact('enterprises', 'order_colunm', 'planes', 'filtros', 'param_nombre', 'param_date', 'param_plan', 'param_total', 'monto_plan', 'planObj'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$this->viewData['success'] = true;
$this->viewData['content'] = [];
$plan = _MODEL::find($id);
// plan
if (empty($plan)) {
$this->viewData['success'] = false;
return response()->json($this->viewData);
}
$this->viewData['content']['plan'] = $plan;
$this->viewData['content']['plan']['dimensions'] = $plan->dimensions;
return response()->json($this->viewData);
}
public function changePlan(Request $request, $id)
{
$user = User::findOrFail($id);
if ($user->id != Auth::user()->id) {
abort(403);
}
$plan = Plan::getByKey($request->get('plan_id'));
if (!$plan) {
App::abort(404);
}
if ($plan['id'] != $user->stripe_plan) {
$user->changePlan($plan, $request->get('token'));
}
return $user;
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
$plan = Plan::find($this->plans);
switch ($this->method()) {
case 'GET':
case 'DELETE':
return [];
case 'POST':
return ['curriculum_id' => 'required', 'course_id' => 'required', 'number_year' => 'integer|max:10', 'number_semester' => 'integer|max:5'];
case 'PUT':
case 'PATCH':
return ['curriculum_id' => 'required', 'course_id' => 'required', 'number_year' => 'integer|max:10', 'number_semester' => 'integer|max:5'];
default:
break;
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (!empty(Input::get('plan_id'))) {
$this->viewData['currentPlan'] = Plan::find(Input::get('plan_id'));
}
$list = _MODEL::leftJoin('plans', 'plans.id', '=', 'dimensions.plan_id')->where('plans.user_id', '=', $this->viewData['user_id'])->where('plans.id', '=', $this->viewData['currentPlan']->id)->select('dimensions.*')->get();
foreach ($list as $row) {
$row->AVERAGE = 0;
// get objectives list related to dimension
$objectives = Objective::where('objectives.dimension_id', '=', (int) $row->id)->select('*')->get();
$objective_AVERAGE = 0;
$objective_count = 0;
foreach ($objectives as $objective) {
//get initiatives related to objective
$initiatives = Initiative::where('initiatives.objective_id', '=', (int) $objective->id)->select('*')->get();
$initiative_AVERAGE = 0;
$initiative_count = 0;
foreach ($initiatives as $initiative) {
//get measures related to initiative
$measures = Measure::where('measures.initiative_id', '=', (int) $initiative->id)->select('*')->get();
$measure_count = 0;
$percent = 0;
foreach ($measures as $measure) {
$measure->actual = ActualMeasure::where('actual_measures.measure_id', '=', (int) $measure->id)->sum('actual_measures.actual_measure');
if ($measure->target != 0) {
$percent += $measure->actual / $measure->target * 100;
}
$measure_count++;
}
//end measures
if ($measure_count != 0) {
$initiative_AVERAGE += $percent / $measure_count;
}
$initiative_count++;
}
//end initiative
if ($initiative_count != 0) {
$objective_AVERAGE += $initiative_AVERAGE / $initiative_count;
}
$objective_count++;
}
if ($objective_count != 0) {
$row->AVERAGE = $objective_AVERAGE / $objective_count;
}
}
return view($this->controller . '.index', compact('list'), $this->viewData);
}
public function doSearch(PlanSearchRequest $request)
{
$mr = $request->mr;
$planSearchResult = [];
$leaveRequestSearchResult = [];
$from = $request->date_from;
$to = $request->date_to;
$allSearchedPlan = Plan::where('mr_id', $mr)->where('date', '>=', $from)->where('date', '<=', $to)->approved()->get();
$allSearchLeaveRequest = LeaveRequest::where('mr_id', $mr)->where('date', '>=', $from)->where('date', '<=', $to)->approved()->get();
foreach ($allSearchedPlan as $singleReport) {
$planSearchResult[] = $singleReport;
}
foreach ($allSearchLeaveRequest as $singleLeaveRequest) {
$leaveRequestSearchResult[] = $singleLeaveRequest;
}
$dataView = ['planSearchResult' => $planSearchResult, 'leaveRequestSearchResult' => $leaveRequestSearchResult];
\Session::flash('emp', $mr);
\Session::flash('date_from', $from);
\Session::flash('date_to', $to);
\Session::flash('planSearchResult', $planSearchResult);
\Session::flash('leaveRequestSearchResult', $leaveRequestSearchResult);
return view('admin.search.plans.result', $dataView);
}
public function newPlan(Request $request)
{
$newplan = Plan::create($request->all());
$newplan->save();
return view('plans.addgoals')->with('plan', $newplan);
}
/**
* @return \Illuminate\View\View
*/
public function getPlans()
{
$title = 'Plans';
$plans = Plan::all();
return view('admin.plans', compact('title', 'plans'));
}
public function cancelPlan()
{
return $this->changePlan(Plan::free());
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$empresa = Enterprise::find($id);
$planes = Plan::lists('nombre', 'id');
return view('enterprise.edit', compact('planes', 'empresa'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index(Plan $plan)
{
//
return Response::json($plan->get());
}
public function pricing()
{
$title = 'Pricing';
$plans = Plan::all();
return view('pages.pricing', compact('title', 'plans'));
}
public function index()
{
$dataView = ['productsCount' => Product::count(), 'plansCount' => Plan::where('month', \Config::get('app.current_month'))->count(), 'reportsCount' => Report::where('month', \Config::get('app.current_month'))->count(), 'customersCount' => Customer::count(), 'employeesCount' => Employee::count()];
return view('admin.index', $dataView);
}
public function doSearch(PlanSearchRequest $request)
{
$mrs[] = $request->mrs;
$planSearchResult = [];
$leaveRequestSearchResult = [];
$from = $request->date_from;
$to = $request->date_to;
$allSearchedPlan = Plan::whereIn('mr_id', $mrs)->where('date', '>=', $from)->where('date', '<=', $to)->approved()->get();
$allSearchLeaveRequest = SMLeaveRequest::whereIn('sm_id', $mrs)->where('date', '>=', $from)->where('date', '<=', $to)->approved()->get();
foreach ($allSearchedPlan as $singleReport) {
$planSearchResult[] = $singleReport;
}
foreach ($allSearchLeaveRequest as $singleLeaveRequest) {
$leaveRequestSearchResult[] = $singleLeaveRequest;
}
$dataView = ['planSearchResult' => $planSearchResult, 'leaveRequestSearchResult' => $leaveRequestSearchResult];
return view('sm.search.plans.result', $dataView);
}
public function createPlan(Request $request)
{
//Create the plan
$plan = new Plan();
$plan->startdate = Carbon::create($request->startdate, 1, 1, 0, 0, 0);
$plan->enddate = Carbon::create($request->enddate, 1, 1, 0, 0, 0);
$plan->save();
//Add Goal 1
$goal1 = new Goal();
$goal1->body = $request->goal1;
$plan->goals()->save($goal1);
//Add Goal 2
$goal2 = new Goal();
$goal2->body = $request->goal2;
$plan->goals()->save($goal2);
//Add Objective 1
$obj1 = new Objective();
$obj1->body = $request->obj1;
$goal1->objectives()->save($obj1);
//Add Objective 2
$obj2 = new Objective();
$obj2->body = $request->obj2;
$goal1->objectives()->save($obj2);
//Add Objective 3
$obj3 = new Objective();
$obj3->body = $request->obj3;
$goal2->objectives()->save($obj3);
//Add Objective 4
$obj4 = new Objective();
$obj4->body = $request->obj4;
$goal2->objectives()->save($obj4);
//Add Action 1
$action1 = new Action();
$action1->body = $request->action1;
if ($request->dateA1 != null) {
$action1->date = Carbon::createFromFormat('Y-m-d', $request->dateA1);
} else {
$action1->date = "";
}
$action1->owner = $request->ownerA1;
$action1->lead = implode('__,__', $request->leadA1);
$action1->collaborators = implode('__,__', $request->collabA1);
$action1->status = $request->statusA1;
$action1->success = $request->successA1;
$obj1->actions()->save($action1);
//Add Action 2
$action2 = new Action();
$action2->body = $request->action2;
if ($request->dateA2 != null) {
$action1->date = Carbon::createFromFormat('Y-m-d', $request->dateA2);
} else {
$action1->date = "";
}
$action2->owner = $request->ownerA2;
$action2->lead = implode('__,__', $request->leadA2);
$action2->collaborators = implode('__,__', $request->collabA2);
$action2->status = $request->statusA2;
$action2->success = $request->successA2;
$obj1->actions()->save($action2);
//Add Action 3
$action3 = new Action();
$action3->body = $request->action3;
if ($request->dateA3 != null) {
$action3->date = Carbon::createFromFormat('Y-m-d', $request->dateA3);
} else {
$action3->date = "";
}
$action3->owner = $request->ownerA3;
$action3->lead = implode('__,__', $request->leadA3);
$action3->collaborators = implode('__,__', $request->collabA3);
$action3->status = $request->statusA3;
$action3->success = $request->successA3;
$obj2->actions()->save($action3);
//Add Action 4
$action4 = new Action();
$action4->body = $request->action4;
if ($request->dateA4 != null) {
$action4->date = Carbon::createFromFormat('Y-m-d', $request->dateA4);
} else {
$action4->date = "";
}
$action4->owner = $request->ownerA4;
$action4->lead = implode('__,__', $request->leadA4);
$action4->collaborators = implode('__,__', $request->collabA4);
$action4->status = $request->statusA4;
$action4->success = $request->successA4;
$obj2->actions()->save($action4);
//Add Action 5
$action5 = new Action();
$action5->body = $request->action5;
if ($request->dateA5 != null) {
$action5->date = Carbon::createFromFormat('Y-m-d', $request->dateA5);
} else {
$action5->date = "";
}
$action5->owner = $request->ownerA5;
$action5->lead = implode('__,__', $request->leadA5);
$action5->collaborators = implode('__,__', $request->collabA5);
$action5->status = $request->statusA5;
$action5->success = $request->successA5;
$obj3->actions()->save($action5);
//Add Action 6
$action6 = new Action();
$action6->body = $request->action6;
if ($request->dateA6 != null) {
$action6->date = Carbon::createFromFormat('Y-m-d', $request->dateA6);
} else {
$action6->date = "";
}
$action6->owner = $request->ownerA6;
$action6->lead = implode('__,__', $request->leadA5);
$action6->collaborators = implode('__,__', $request->collabA6);
$action6->status = $request->statusA6;
$action6->success = $request->successA6;
$obj3->actions()->save($action6);
//Add Action 7
$action7 = new Action();
$action7->body = $request->action7;
if ($request->dateA7 != null) {
$action7->date = Carbon::createFromFormat('Y-m-d', $request->dateA7);
} else {
$action7->date = "";
}
$action7->owner = $request->ownerA7;
$action7->lead = implode('__,__', $request->leadA7);
$action7->collaborators = implode('__,__', $request->collabA7);
$action7->status = $request->statusA7;
$action7->success = $request->successA7;
$obj4->actions()->save($action7);
//Add Action 4
$action8 = new Action();
$action8->body = $request->action8;
if ($request->dateA8 != null) {
$action8->date = Carbon::createFromFormat('Y-m-d', $request->dateA8);
} else {
$action8->date = "";
}
$action8->owner = $request->ownerA8;
$action8->lead = implode('__,__', $request->leadA8);
$action8->collaborators = implode('__,__', $request->collabA8);
$action8->status = $request->statusA8;
$action8->success = $request->successA8;
$obj4->actions()->save($action8);
//Tasks
//Add Task 1
$task1 = new Task();
$task1->body = $request->task1;
if ($request->dateT1 != null) {
$task1->date = Carbon::createFromFormat('Y-m-d', $request->dateT1);
} else {
$task1->date = "";
}
$task1->owner = $request->ownerT1;
$task1->lead = implode('__,__', $request->leadT1);
$task1->collaborators = implode('__,__', $request->collabT1);
$task1->status = $request->statusT1;
$task1->success = $request->successT1;
$action1->tasks()->save($task1);
//Add Task 2
$task2 = new Task();
$task2->body = $request->task2;
if ($request->dateT2 != null) {
$task2->date = Carbon::createFromFormat('Y-m-d', $request->dateT2);
} else {
$task2->date = "";
}
$task2->owner = $request->ownerT2;
$task2->lead = implode('__,__', $request->leadT2);
$task2->collaborators = implode('__,__', $request->collabT2);
$task2->status = $request->statusT2;
$task2->success = $request->successT2;
$action1->tasks()->save($task2);
//Add Task 3
$task3 = new Task();
$task3->body = $request->task3;
if ($request->dateT3 != null) {
$task3->date = Carbon::createFromFormat('Y-m-d', $request->dateT3);
} else {
$task3->date = "";
}
$task3->owner = $request->ownerT3;
$task3->lead = implode('__,__', $request->leadT3);
$task3->collaborators = implode('__,__', $request->collabT3);
$task3->status = $request->statusT3;
$task3->success = $request->successT3;
$action2->tasks()->save($task3);
//Add Task 4
$task4 = new Task();
$task4->body = $request->task4;
if ($request->dateT4 != null) {
$task4->date = Carbon::createFromFormat('Y-m-d', $request->dateT4);
} else {
$task4->date = "";
}
$task4->owner = $request->ownerT4;
$task4->lead = implode('__,__', $request->leadT4);
$task4->collaborators = implode('__,__', $request->collabT4);
$task4->status = $request->statusT4;
$task4->success = $request->successT4;
$action2->tasks()->save($task4);
//Add Task 5
$task5 = new Task();
$task5->body = $request->task5;
if ($request->dateT5 != null) {
$task5->date = Carbon::createFromFormat('Y-m-d', $request->dateT5);
} else {
$task5->date = "";
}
$task5->owner = $request->ownerT5;
$task5->lead = implode('__,__', $request->leadT5);
$task5->collaborators = implode('__,__', $request->collabT5);
$task5->status = $request->statusT5;
$task5->success = $request->successT5;
$action3->tasks()->save($task5);
//Add Task 6
$task6 = new Task();
$task6->body = $request->task6;
if ($request->dateT6 != null) {
$task6->date = Carbon::createFromFormat('Y-m-d', $request->dateT6);
} else {
$task6->date = "";
}
$task6->owner = $request->ownerT6;
$task6->lead = implode('__,__', $request->leadT6);
$task6->collaborators = implode('__,__', $request->collabT6);
$task6->status = $request->statusT6;
$task6->success = $request->successT6;
$action3->tasks()->save($task6);
//Add Task 7
$task7 = new Task();
$task7->body = $request->task7;
if ($request->dateT7 != null) {
$task7->date = Carbon::createFromFormat('Y-m-d', $request->dateT7);
} else {
$task7->date = "";
}
$task7->owner = $request->ownerT7;
$task7->lead = implode('__,__', $request->leadT7);
$task7->collaborators = implode('__,__', $request->collabT7);
$task7->status = $request->statusT7;
$task7->success = $request->successT7;
$action4->tasks()->save($task7);
//Add Task 8
$task8 = new Task();
$task8->body = $request->task8;
if ($request->dateT8 != null) {
$task8->date = Carbon::createFromFormat('Y-m-d', $request->dateT8);
} else {
$task8->date = "";
}
$task8->owner = $request->ownerT8;
$task8->lead = implode('__,__', $request->leadT8);
$task8->collaborators = implode('__,__', $request->collabT8);
$task8->status = $request->statusT8;
$task8->success = $request->successT8;
$action4->tasks()->save($task8);
//Add Task 9
$task9 = new Task();
$task9->body = $request->task9;
if ($request->dateT9 != null) {
$task9->date = Carbon::createFromFormat('Y-m-d', $request->dateT9);
} else {
$task9->date = "";
}
$task9->owner = $request->ownerT9;
$task9->lead = implode('__,__', $request->leadT9);
$task9->collaborators = implode('__,__', $request->collabT9);
$task9->status = $request->statusT9;
$task9->success = $request->successT9;
$action5->tasks()->save($task9);
//Add Task 10
$task10 = new Task();
$task10->body = $request->task10;
if ($request->dateT10 != null) {
$task10->date = Carbon::createFromFormat('Y-m-d', $request->dateT10);
} else {
$task10->date = "";
}
$task10->owner = $request->ownerT10;
$task10->lead = implode('__,__', $request->leadT10);
$task10->collaborators = implode('__,__', $request->collabT10);
$task10->status = $request->statusT10;
$task10->success = $request->successT10;
$action5->tasks()->save($task10);
//Add Task 11
$task11 = new Task();
$task11->body = $request->task11;
if ($request->dateT11 != null) {
$task11->date = Carbon::createFromFormat('Y-m-d', $request->dateT11);
} else {
$task11->date = "";
}
$task11->owner = $request->ownerT11;
$task11->lead = implode('__,__', $request->leadT11);
$task11->collaborators = implode('__,__', $request->collabT11);
$task11->status = $request->statusT11;
$task11->success = $request->successT11;
$action6->tasks()->save($task11);
//Add Task 4
$task12 = new Task();
$task12->body = $request->task12;
if ($request->dateT12 != null) {
$task12->date = Carbon::createFromFormat('Y-m-d', $request->dateT12);
} else {
$task12->date = "";
}
$task12->owner = $request->ownerT12;
$task12->lead = implode('__,__', $request->leadT12);
$task12->collaborators = implode('__,__', $request->collabT12);
$task12->status = $request->statusT12;
$task12->success = $request->successT12;
$action6->tasks()->save($task12);
//Add Task 13
$task13 = new Task();
$task13->body = $request->task13;
if ($request->dateT13 != null) {
$task13->date = Carbon::createFromFormat('Y-m-d', $request->dateT13);
} else {
$task13->date = "";
}
$task13->owner = $request->ownerT13;
$task13->lead = implode('__,__', $request->leadT13);
$task13->collaborators = implode('__,__', $request->collabT13);
$task13->status = $request->statusT13;
$task13->success = $request->successT13;
$action7->tasks()->save($task13);
//Add Task 14
$task14 = new Task();
$task14->body = $request->task14;
if ($request->dateT14 != null) {
$task14->date = Carbon::createFromFormat('Y-m-d', $request->dateT14);
} else {
$task14->date = "";
}
$task14->owner = $request->ownerT14;
$task14->lead = implode('__,__', $request->leadT14);
$task14->collaborators = implode('__,__', $request->collabT14);
$task14->status = $request->statusT14;
$task14->success = $request->successT14;
$action7->tasks()->save($task14);
//Add Task 15
$task15 = new Task();
$task15->body = $request->task15;
if ($request->dateT15 != null) {
$task15->date = Carbon::createFromFormat('Y-m-d', $request->dateT15);
} else {
$task15->date = "";
}
$task15->owner = $request->ownerT15;
$task15->lead = implode('__,__', $request->leadT15);
$task15->collaborators = implode('__,__', $request->collabT15);
$task15->status = $request->statusT15;
$task15->success = $request->successT15;
$action8->tasks()->save($task15);
//Add Task 16
$task16 = new Task();
$task16->body = $request->task16;
if ($request->dateT16 != null) {
$task16->date = Carbon::createFromFormat('Y-m-d', $request->dateT16);
} else {
$task16->date = "";
}
$task16->owner = $request->ownerT16;
$task16->lead = implode('__,__', $request->leadT16);
$task16->collaborators = implode('__,__', $request->collabT16);
$task16->status = $request->statusT16;
$task16->success = $request->successT16;
$action8->tasks()->save($task16);
return view('createDone');
}
public function plans($type)
{
$plans = Plan::where('month', \config('app.current_month'))->where('mr_id', \Auth::user()->id)->get();
\Excel::create('plans', function ($excel) use($plans) {
$excel->sheet('plans', function ($sheet) use($plans) {
$sheet->setAllBorders('thin');
$sheet->loadView('mr.export.plans')->with('plans', $plans);
});
})->export($type);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$plan = Plan::find($id);
if (count($plan->enterprises) > 0) {
return redirect()->route('admin.plan.index')->with('message', '<div class="alert alert-warning" style="margin-top:15px">Este plan contiene empresas asociadas por ende no puede ser eliminado</div>');
} else {
$plan->delete();
}
return redirect()->route('admin.plan.index')->with('message', '<div class="alert alert-success" style="margin-top:15px">Plan eliminado con Éxito</div>');
}
});
// Route for displaying the page
Route::get('plan', 'PlanController@plan');
Route::post('plan/{plan}/goals', 'PlanController@addNewGoal');
Route::post('plan/{plan}/goal/objective', 'PlanController@addNewObjective');
Route::post('plan/{plan}/goal/objective/action', 'PlanController@addNewAction');
Route::post('plan/{plan}/goal/objective/action/task', 'PlanController@addNewTask');
Route::post('get/objective', 'PlanController@getObjectives');
Route::post('get/actions', 'PlanController@getActions');
Route::get('addUser', 'RegisterController@register');
Route::post('addUser', 'RegisterController@addNewUser');
Route::get('manage', 'ManageController@manage');
Route::get('tasks/{task}', 'TasksController@show');
Route::post('tasks/{task}/notes', 'NotesController@store');
Route::get('sort/{plan}/{option}', function ($plan, $option) {
return view('sort')->with('option', $option)->with('plan', Plan::findOrFail($plan));
});
Route::get('sort/{plan}/dept/{dept}', function ($dept) {
return view('filterbyteamdept')->with('dept', $dept);
});
Route::get('sort/{plan}/team/{dept}', function ($dept) {
return view('filterbyteamdept')->with('dept', $dept);
});
Route::get('notes/show/{note}', 'NotesController@show');
Route::get('goals/show/{goal}', 'GoalsController@show');
Route::get('departments/show/{department}', 'DepartmentsController@show');
Route::get('actions/show/{action}', 'ActionsController@show');
Route::get('tasks/show/{task}', 'TasksController@show');
Route::get('teams/show/{team}', 'TeamsController@show');
Route::get('users/show/{id}', 'ProfileController@show');
Route::get('objectives/show/{objective}', 'ObjsController@show');
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Plan::destroy($id);
return redirect()->route('admin.plan.index')->with('message', '<div class="alert alert-success" style="margin-top:15px">Plan eliminado con Éxito</div>');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$plan = Plan::findOrFail($id);
$plan->delete();
return redirect()->action('PlanController@index');
}
