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'); }