public function run()
{
DB::table('menus')->delete();
DB::table('dish_menu')->delete();
DB::table('recommendations')->delete();
$menu = new Menu();
$menu->menu_date = "2014-03-30";
$menu->save();
foreach (Dish::all() as $dish) {
$menu->dishes()->save($dish);
}
$menu = new Menu();
$menu->menu_date = "2014-04-23";
$menu->save();
foreach (Dish::all() as $dish) {
$menu->dishes()->save($dish);
}
$recommendation = new Recommendation();
$recommendation->menu_id = 1;
$recommendation->recommendation = "Today, we has abcxyz for menu 1";
$recommendation->save();
$recommendation = new Recommendation();
$recommendation->menu_id = 2;
$recommendation->recommendation = "Today, we has abcxyz for menu 2";
$recommendation->save();
}
public function postCreateMenu()
{
/* validate input */
$validator = Validator::make(Input::all(), array("menu_date" => "required|date_format:Y-m-d", "dishes" => "required", "recommendation" => "required"));
/* if validated */
if ($validator->passes()) {
/* get input */
$menu = new Menu();
$menu->menu_date = Input::get("menu_date");
$menu->save();
$recommendation = new Recommendation();
$recommendation->menu_id = $menu->id;
$recommendation->recommendation = Input::get("recommendation");
$recommendation->save();
foreach (Input::get('dishes') as $dishId) {
$menu->dishes()->save(Dish::find((int) $dishId));
}
return Redirect::to('admin/menu/create_menu')->with('message', 'Menu added!');
} else {
return Redirect::to('admin/menu/create_menu')->withErrors($validator);
}
// end validation
}
public function recommendationsUpload()
{
$recommendation = new Recommendation();
$active_principle = new ActivePrinciple();
$columns = $recommendation->columns();
$foreign_key = array_pop($columns);
// retrieve FK column
$input = Input::All();
$header = array_shift($input);
// retrieve header row
if (!$this->checkHeader($header, $columns)) {
return Response::json(array("success" => false, "info" => "Cabeceras del Excel no coincide con la base de datos.\n No se procederá a modificar la base de datos."));
}
DB::table($recommendation->getTableName())->delete();
try {
$errors = "";
foreach ($input as $row) {
$row = $this->readRow($row, $header);
$recommendation = new Recommendation($row);
$active_principle_found = DB::table($active_principle->getTableName())->select("id", "principio_activo")->where("principio_activo", "=", $recommendation->principio_activo)->first();
if ($active_principle_found != NULL) {
$recommendation->active_principle_id = $active_principle_found->id;
$recommendation->save();
} else {
$errors .= "\nRecomendación para un principio activo: " . $active_principle->principio_activo . " inexistente";
}
}
} catch (Exception $ex) {
return Response::json(array("success" => false, "info" => "Ha habido algún problema cargando el Excel en la base de datos." . "\n" . $ex->getMessage()));
}
return Response::json(array("success" => true, "info" => "Se ha cargado el excel en la base de datos correctamente.", "errors" => $errors));
}
if (!$_SESSION['user']) {
die('You need to login to send recommendations');
}
require_once('../database/config.php');
$conn = Doctrine_Manager :: connection(DSN);
$current_user_id = $_SESSION['user']['user_id'];
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
//we are posting to the web server, so save the recommendation
$recommendation = new Recommendation();
$recommendation['note'] = $_POST['message'];
$recommendation['from_user_id'] = $_SESSION['user']['user_id'];
$recommendation['to_user_id'] = $_POST['to_user_id'];
$recommendation['album_id'] = $_POST['album_id'];
$recommendation->save();
$send = true;
}else if (isset($_GET['search_username'])) {
//Search for all the usernames that match the criteria
$search = Doctrine::getTable('User')
->getTemplate('Doctrine_Template_Searchable')
->getPlugin();
$results = $search->search($_GET['search_username']);
foreach($results as $result) {
$user_ids[] = (int) $result['user_id'];
}
if (count($user_ids) > 0) {
$users = Doctrine_Query::create()
->from('User u')
