public function storePlanEstrategico()
{
if (Auth::guest()) {
return view('login');
} else {
//obtenemos planes para redirección a index
$planes = \Ermtool\Strategic_plan::all();
DB::transaction(function () {
//primero, debemos asegurarnos de cambiar el status a todos los planes estratégicos existentes para la misma organización
DB::table('strategic_plans')->where('organization_id', '=', $_POST['organization_id'])->update(['status' => 0]);
if (isset($_POST['comments']) && $_POST['comments'] != '') {
$comments = $_POST['comments'];
} else {
$comments = NULL;
}
//seteamos fecha de expiracion
$initial_date = explode('-', $_POST['initial_date']);
$final_date = $initial_date[0] + $_POST['duration'] . '-' . $initial_date[1] . '-' . $initial_date[2];
DB::table('strategic_plans')->insert(['name' => $_POST['name'], 'comments' => $_POST['comments'], 'initial_date' => $_POST['initial_date'], 'final_date' => $final_date, 'created_at' => date('Y-m-d'), 'updated_at' => date('Y-m-d'), 'status' => 1, 'organization_id' => $_POST['organization_id']]);
if (Session::get('languaje') == 'en') {
Session::flash('message', 'Strategic plan was successfully created');
} else {
Session::flash('message', 'Plan estratégico fue generado correctamente');
}
});
return Redirect::to('plan_estrategico?organizacion=' . $_POST['organization_id']);
}
}
