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