/**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     //        $user_id = 1;
     //        $productsCount = Products::count();
     //        $product = Products::get();
     //        $ordersCount = DB::select('select count(*) as say from orders where cast(created_at as DATE) = ?', array(Carbon::now()->format('Y-m-d')));
     //
     //        if ($productsCount != ($ordersCount[0]->say)) {
     //            foreach ($product as $key => $pro) {
     ////                $ordersCount = DB::select('select count(*) as say from orders where cast(created_at as DATE) = ? and ProductName = ? ', array(Carbon::now()->format('Y-m-d'), $pro->Name));
     ////dd(Carbon::now()->format('Y-m-d h:i:s'));
     ////                dd(Carbon::now());
     //                $today = Carbon::now()->format('Y-m-d h:n:s');
     //                $ifnotinsert = DB::insert(DB::raw("INSERT INTO orders (ProductName,CustomerId,CustomerName,quantity,Alish,Satish,Income,created_at,updated_at,user_id)
     //SELECT * FROM (SELECT '$pro->Name' as name, '$pro->CustomerId' as cusid, '$pro->CustomerId'  as cusname, 0 as quantity , '$pro->Alish' as alish , '$pro->Satish'  as satish, '$pro->Income'  as income, '$today'  as created_at, '$today' as updated_at,0 as user_id) AS tmp
     //WHERE NOT EXISTS (
     //    SELECT * FROM orders WHERE ProductName = '$pro->Name' and CustomerId = '$pro->CustomerId' and Format(Alish,2) = Format('$pro->Alish',2) AND
     //Format(Satish,2)= Format('$pro->Satish',2)) LIMIT 1"));
     //
     //            }
     //        }
     $CustomerName = Customers::lists('name', 'id');
     $CategoryName = Categories::lists('name', 'id');
     return view('orders.newAlish', compact('CustomerName', $CustomerName), compact('CategoryName'));
 }
 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     $CategoryName = Categories::lists('name', 'id');
     $CustomerName = Customers::lists('name', 'id');
     return view('products.create', compact('CustomerName', $CustomerName), compact('CategoryName'));
 }
 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function create()
 {
     $CustomerName = Customers::lists('name', 'id');
     //        dd($CustomerName);
     return view('purchase.create', compact('CustomerName'));
 }