public function dashboard()
{
if (!Auth::user()->is_admin) {
return Redirect::to('/');
}
//produits de la boutique
$products = Product::all();
// récupérer les dates ou il y a eu des commandes donc achats
$cmds = DB::select(DB::raw('SELECT DATE(orders.date) AS date FROM orders GROUP BY DATE(orders.date) ORDER BY orders.date DESC'));
//récupérer les achats par date
$cmdsByDate = array();
foreach ($cmds as $key => $cmd) {
$cmdsByDate[$cmd->date] = Orderitem::whereRaw('DATE(orders.date) = \'' . $cmd->date . '\'')->leftJoin('orders', 'order_items.order_id', '=', 'orders.id')->leftJoin('users', 'orders.user_id', '=', 'users.id')->leftJoin('products', 'order_items.item_id', '=', 'products.id')->select('order_items.*', 'orders.date AS date', 'users.email AS user_email', 'users.first_name AS user_first', 'users.last_name AS user_last', 'products.name AS item_name')->orderBy('orders.date', 'DESC')->get();
}
//list des commandes par mois
return View::make('admin/show', array('products' => $products, 'cmdsbydate' => $cmdsByDate));
}
