/**
* Dashboard Details
*
*
*/
public function dashboard()
{
$products = Product::all()->count();
$orders = Order::all()->count();
$users = User::all()->count();
return view('admin.dashboard', compact('products', 'orders', 'users'));
}
public function index()
{
$users = Order::all();
$orders = Order::orderBy('id', 'desc')->paginate(5);
//dd($orders);
return view('admin.order.index', compact('orders', 'users'));
}
public function index()
{
$users = User::all();
$orders = Order::all();
$usersTotal = count($users);
$ordersTotal = count($orders);
$coffee1 = DB::table('coffees')->where('id', 1)->first();
$coffee2 = DB::table('coffees')->where('id', 2)->first();
$coffee3 = DB::table('coffees')->where('id', 3)->first();
$coffee4 = DB::table('coffees')->where('id', 4)->first();
$coffee5 = DB::table('coffees')->where('id', 5)->first();
$pastry1 = DB::table('pastries')->where('id', 1)->first();
$pastry2 = DB::table('pastries')->where('id', 2)->first();
$pastry3 = DB::table('pastries')->where('id', 3)->first();
$pastry4 = DB::table('pastries')->where('id', 4)->first();
$pastry5 = DB::table('pastries')->where('id', 5)->first();
$sum = 0;
foreach ($orders as $order) {
for ($i = 1; $i < 6; $i++) {
$total = $order->{'coffee' . $i} * ${'coffee' . $i}->price + $order->{'pastry' . $i} * ${'pastry' . $i}->price;
$sum = $sum + $total;
}
}
$profit = 0;
foreach ($orders as $order) {
for ($i = 1; $i < 6; $i++) {
$sales = $order->{'coffee' . $i} * (${'coffee' . $i}->price - ${'coffee' . $i}->cost) + $order->{'pastry' . $i} * (${'pastry' . $i}->price - ${'pastry' . $i}->cost);
$profit = $profit + $sales;
}
}
$rate = round($sum / $profit * 100, 2);
return view('admin.dashboard', compact('usersTotal', 'ordersTotal', 'sum', 'rate'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$orders = Order::all();
return view('order.history', array('orders' => $orders));
// $order = Order::find($id);
// return view('order.show', array('order' => $order));
}
public function getAll()
{
$orders = Order::all();
$pageData = self::orderPageData('pending', 0, 1, 1, 1);
$pageData['table'] = $orders;
return view('panel.orders', $pageData);
}
public function postCheckout()
{
$order_count = count(Order::all()) + 2;
$order_number = "MEI-" . date('mdY') . "-" . $order_count;
$product_ids = Session::get("pro_ids");
$price = Session::get("price");
$duration = Session::get("duration");
$quantity = Input::get("quantity");
$total_price_sum = Input::get("total-price-sum");
$subtotal_price_sum = Input::get("subtotal-price-sum");
foreach ($product_ids as $product_id) {
$pro = Product::find($product_id);
$order = new Order(array('product_id' => $product_id, 'order_number' => $order_number, 'quantity' => $quantity[$product_id], 'subtotal' => $subtotal_price_sum[$product_id], 'duration' => $duration[$product_id], 'price' => $price[$product_id]));
$order->save();
}
$order_confirmed = new ConfirmOrders(array('order_number' => $order_number, 'total' => $total_price_sum, 'user_id' => Auth::user()->id));
$order_confirmed->save();
$order_confirmed = ConfirmOrders::find($order_confirmed->id);
$user_order = $order_confirmed->user;
$order_details = Order::where('order_number', $order_confirmed->order_number)->get();
Mail::send(['html' => 'order-received'], ['order_details' => $order_details, 'order_confirmed' => $order_confirmed, 'user_order' => $user_order], function ($message) use($user_order) {
$message->from('*****@*****.**', 'MEI - Student Rental');
$message->to($user_order->email)->subject('MEI - Student Rental Order');
$message->bcc(['*****@*****.**']);
// $message->bcc('*****@*****.**')->subject('MEI - Student Rental Order');
});
Session::forget('pro_ids');
Session::forget('price');
Session::forget('duration');
return redirect('cart')->with('order_placed', 'Thank you for contacting us. We have received your enquiry and will respond to you soon. For urgent enquiries please call us on +9714 2659533.');
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$orders = Order::all();
foreach ($orders as $order) {
echo $order->name . " Ordered by: " . $order->customer->name . "<br/>";
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//$customers = Customer::has('orders')->get();
$users = User::all();
$orders = Order::all();
$articles = Articles::all();
return view('admin.index', compact('users', 'orders', 'articles'));
}
/**
* Display a list of all of the user's orders.
*
* @param Request $request
* @return Response
*/
public function index(Request $request)
{
// return view('orders.index', [
// 'orders' => $this->orders->forUser($request->user()),
// ]);
$orders = Order::all();
return view('orders.index', ['orders' => $orders]);
}
public function orders()
{
$orders = Order::all();
foreach ($orders as $order) {
$customer = Customer::find($order->customer_id);
echo "Ordered by: " . $order->customer->name . "<br />";
echo $order->name . "<p />";
}
}
public function getAllOrders()
{
$orders = Order::all()->toArray();
foreach ($orders as $order) {
$orderProducts = Orderdetail::where(['OrderID' => $order->OrderID])->get(['ProductID'])->toArray();
$order = array_add($order, 'products', $orderProducts);
}
return $orders;
}
public function admin()
{
$output = array();
$i = 0;
$orders = Order::all();
foreach ($orders as $order) {
$pivots = OrderProduct::where('order_id', $order->id)->get();
foreach ($pivots as $pivot) {
$prod = Product::findOrFail($pivot['product_id']);
$output[$i]['order'] = $order;
$p = ['prod' => $prod, 'count' => $pivot['count'], 'cost_all' => (int) $pivot['count'] * (int) $prod->cost];
$output[$i]['product'][] = $p;
}
$i++;
}
return view('admin', ['data' => $output]);
}
public function testNotificationStatus()
{
// Given
$this->startSession();
$order = new Order(['customer_name' => 'Marsellus Wallace', 'phone_number' => '+15551231234']);
$order->save();
$order = $order->fresh();
$this->assertCount(1, Order::all());
$this->assertEquals('Ready', $order->status);
$this->assertEquals('None', $order->notification_status);
// When
$response = $this->call('POST', route('order.notification.status', ['id' => $order->id, 'MessageStatus' => 'sent']), ['_token' => csrf_token()]);
// Then
$order = $order->fresh();
$this->assertEquals('Ready', $order->status);
$this->assertEquals('sent', $order->notification_status);
}
public function index()
{
$orders = Order::all();
$sales = null;
$taxes = null;
foreach ($orders as $order) {
$sales = $sales + $order->total;
$taxes = $taxes + $order->sub_total;
}
$taxes = $sales - $taxes;
$temperatures = Lava::DataTable();
$temperatures->addDateColumn('Date')->addNumberColumn('Last period')->addNumberColumn('This period')->addRow(array('2015-11-1', 4524, 3503))->addRow(array('2015-11-2', 2332, 3880))->addRow(array('2015-11-3', 4700, 2130))->addRow(array('2015-11-4', 4200, 3100))->addRow(array('2015-11-5', 4302, 3500))->addRow(array('2015-11-6', 4130, 2332))->addRow(array('2015-11-7', 4820, 3200))->addRow(array('2015-11-8', 2504, 3500))->addRow(array('2015-11-9', 4500, 3500))->addRow(array('2015-11-10', 3350, 3500))->addRow(array('2015-11-11', 3350, 3100))->addRow(array('2015-11-12', 4500, 3555))->addRow(array('2015-11-13', 4500, 3330))->addRow(array('2015-11-14', 3350, 3200))->addRow(array('2015-11-15', 4500, 3500))->addRow(array('2015-11-16', 3350, 3500))->addRow(array('2015-11-17', 4500, 4500))->addRow(array('2015-11-18', 4500, 3500));
$linechart = Lava::LineChart('Temps')->dataTable($temperatures)->title('Sales');
//
/// dd(Lava::BackgroundColor());
$viewBag = array('permission' => \Auth::user()->permission->name, 'orders' => $orders, 'orders_active' => Order::where('trash', '=', 0)->orderBy('created_at', 'desc')->take(5)->get(), 'sales' => $sales, 'taxes' => $taxes, 'products' => Product::where('trash', '=', 0)->get(), 'products_amount' => Product::where('stock', '=', 'N')->get(), 'users' => User::where('trash', '=', 0)->get(), 'categories' => Category::where('trash', '=', 0)->get());
return \View::make('backend.index', $viewBag);
}
/**
* Run the database seeds.
*/
public function run()
{
$faker = Faker\Factory::create();
$orders = Order::all();
$products = Product::all()->toArray();
foreach ($orders as $order) {
$used = [];
for ($i = 0; $i < rand(1, 5); ++$i) {
$product = $faker->randomElement($products);
if (!in_array($product['id'], $used)) {
$id = $product['id'];
$price = $product['price'];
$quantity = $faker->numberBetween(1, 3);
ItemOrder::create(['order_id' => $order->id, 'product_id' => $id, 'price' => $price, 'qty' => $quantity]);
$used[] = $product['id'];
}
}
}
}
public function run()
{
$faker = $this->getFaker();
$orders = Order::all();
$equipment = Equipment::all()->toArray();
foreach ($orders as $order) {
$used = [];
for ($i = 0; $i < rand(1, 5); $i++) {
$product = $faker->randomElement($equipment);
if (!in_array($equipment["id"], $used)) {
$id = $equipment["id"];
$price = $equipment["price"];
$quantity = rand(1, 3);
OrderItem::create(["order_id" => $order->id, "equipment_id" => $id, "price" => $price, "quantity" => $quantity]);
$used[] = $equipment["id"];
}
}
}
}
public function __construct()
{
View::share('pros', Product::take(8)->Where('status', 1)->orderBy('created_at', 'DESC')->get());
View::share('customs', Product::take(8)->Where('type', 0)->orderBy('created_at', 'DESC')->get());
View::share('products', Product::take(8)->Where('status', 1)->orderBy('created_at', 'DESC')->get());
View::share('cus', Product::take(8)->Where('status', 1)->orderBy('created_at', 'ASC')->get());
View::share('categories', Category::all());
View::share('cart_content', Cart::content());
View::share('count', Cart::count());
View::share('total', Cart::total());
View::share('set', Setting::find(1));
View::share('tos', Cart::tos());
View::share('transactions', Transaction::orderBy('created_at', 'desc')->paginate(10));
View::share('settings', Setting::find(1));
View::share('caty', Category::take(5)->orderBy('created_at', 'DESC')->get());
View::share('payments', Payment::Where('status', 1)->get());
View::share('customers', Customer::all());
View::share('orders', Order::all());
View::share('cat', Category::all());
View::share('db', Product::take(6)->Where('status', 1)->orderBy('created_at', 'ASC')->get());
}
public function getIndex()
{
$now = Carbon::now('Asia/Kuala_Lumpur');
$monthStart = $now->startOfMonth();
$monthEnd = $now->endOfMonth();
$tempahan = Order::orderBy('created_at', $monthStart);
// where('created_at', '>=', Carbon::now()->startOfMonth())->get()
$kato = Category::whereHas('transaction', function ($query) {
$query->where('qty', '>', 0);
$query->where('created_at', '>=', Carbon::now('Asia/Kuala_Lumpur')->startOfYear());
})->get();
$katoo = Category::whereHas('transaction', function ($query) {
$query->where('qty', '>', 0);
$query->where('created_at', '>=', Carbon::now('Asia/Kuala_Lumpur')->startOfMonth());
})->get();
$overall = Transaction::select('id', 'created_at', 'month', DB::raw('sum(qty) as total'))->groupBy(DB::raw('MONTH(month)'))->orderBy('created_at', 'asc')->where('created_at', '>=', Carbon::now('Asia/Kuala_Lumpur')->startOfYear())->get();
$testo = Transaction::select('id', 'month')->groupBy(DB::raw('MONTH(month)'))->orderBy('month', 'asc');
$tahun = Carbon::now('Asia/Kuala_Lumpur')->startOfYear();
$tran = Transaction::all();
$tops = Transaction::orderBy('qty', 'desc')->groupBy('product_id')->limit(5)->where('created_at', '>=', Carbon::now('Asia/Kuala_Lumpur')->startOfWeek())->get();
return view('a.index', compact('kato', 'katoo', 'tops', 'overall', 'tahun', 'testo'))->with('tempahan', $tempahan)->with('trans', $tran)->with('args', Order::all())->with('ris', Order::sum('total_purchase'))->with('name', $kato->lists('name'))->with('namo', $katoo->lists('name'));
}
public function getIndex()
{
$orders = Order::all()->take(15);
return response()->json($orders->toArray());
}
/**
* Создание нового заказа
*/
public function postNewOrder(Request $request)
{
// DESC Проверка на временную отсечку
$this->validate($request, array('customer' => 'required|integer', 'operator' => 'required|integer'));
$year = date('y');
$order = Order::all()->last();
if (empty($order)) {
$id = "0000";
} else {
$id = substr($order->ident, -4, 4);
if (substr($order->ident, 0, 2) != date('y')) {
$id = "0000";
}
}
$ident = $year . "07" . $id;
$ident++;
$order = Order::create(array('ident' => $ident, 'user_id' => $this->user->id, 'customer' => $request->input('customer'), 'operator' => $request->input('operator'), 'phones' => $request->input('phones'), 'order_to_airport' => $request->input('order_to_airport'), 'order_from_airport' => $request->input('order_from_airport'), 'departure_time' => date("Y-m-d H:i:s", strtotime($request->input('departure_time'))), 'departure_passengers' => $request->input('departure_passengers'), 'departure_airport' => $request->input('departure_airport'), 'departure_order_type' => $request->input('departure_order_type'), 'arrivals_time' => date("Y-m-d H:i:s", strtotime($request->input('arrivals_time'))), 'arrivals_passengers' => $request->input('arrivals_passengers'), 'arrivals_airport' => $request->input('arrivals_airport'), 'arrivals_order_type' => $request->input('arrivals_order_type'), 'arrivals_flight_num' => $request->input('arrivals_flight_num'), 'amount' => $request->input('amount'), 'comment' => $request->input('comment')));
if ($order) {
return redirect()->action('OrderController@getOrderDoc', $ident);
} else {
$this->SetErrorNotifyMessage('Ошибка выполнения операции.');
return redirect()->back();
}
}
public static function listOrderAdmin()
{
return Order::all();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$orders = Order::all();
return view('orders.all')->with('orders', $orders);
}
public function index()
{
$orders = Order::all();
return response()->json($orders);
}
public function index()
{
return view('index', ['orders' => Order::all()]);
}
public function dashboard()
{
$orders = Order::all();
return view()->make('admin.dashboard', compact('orders'));
}
public function getIndex()
{
$data = array('orders' => Order::all());
return view('pages.order', $data);
}
public function getShow(Request $request, $id = null)
{
$user = $request->user();
if ($id == null && $user->isAdmin()) {
//No ID means list all orders (for admins)
$orders = Order::all();
$orderData = array();
foreach ($orders as $order) {
$tmpOrder = array();
$tmpOrder['id'] = $order->id;
$tmpOrder['fullname'] = $order->user->fullname;
$tmpOrder['total'] = 0.0;
foreach ($order->items as $orderItem) {
$tmpOrder['total'] += $orderItem['price'] * $orderItem['weight'];
}
$tmpOrder['addr'] = $order->addr;
$tmpOrder['phone'] = $order->phone;
$tmpOrder['fulfilled'] = $order->fulfilled;
$orderData[] = $tmpOrder;
}
return view('admin_order', ['orders' => $orderData]);
}
$order = Order::findOrFail($id);
if ($user->id == $order->user_id || $user->isAdmin()) {
$total = 0.0;
$items = array();
$orderItems = $order->items;
foreach ($orderItems as $orderItem) {
$item = array();
$item['id'] = $orderItem->product->id;
$item['name'] = $orderItem->product->name;
$item['price'] = $orderItem->price;
$item['count'] = $orderItem->weight;
$item['total'] = $orderItem->price * $item['count'];
$total += $item['total'];
$items[] = $item;
}
$data = ['order' => $order, 'items' => $items, 'total' => $total];
return view('order_show', $data);
} else {
//User not orderer or admin
return redirect('/');
}
}
public function index()
{
$files = File::with('client', 'technicien', 'laststatus.code')->get();
$repairs = Repair::with('device')->get();
$orders = Order::all();
$leftmenu['files'] = 'active';
return view('/files/index', ['leftmenu' => $leftmenu, 'files' => $files, 'repairs' => $repairs, 'orders' => $orders]);
}
public function index()
{
$orders = Order::all();
return view('order.dashboard', compact('orders'));
}
public function getAllOrders()
{
return Order::all();
}
