private function createNewDelivery()
{
$faker = $this->getFakeGenerator();
Delivery::create(array('store_id' => $this->getRandomStoreId(), 'user_id' => $this->getRandomUserId(), 'closing_time' => $faker->dateTimeBetween('-2 hours', '+2 hours')));
}
public function add_delivery()
{
$id1 = Input::get('ordID');
$id2 = Input::get('dlvID');
//$orderproducts = OrderProduct::where('strOPOrdersID', '=', $id1)->get();
$orderproducts = DB::table('tblOrderedProducts as a')->join('tblProducts as b', 'b.strProdID', '=', 'a.strOPProdID')->join('tblOrders as c', 'c.strOrdersID', '=', 'a.strOPOrdersID')->where('strOPOrdersID', '=', $id1)->get();
$delivery = Delivery::create(array('strDlvryID' => Input::get('dlvID'), 'dtDlvryDate' => Input::get('dtDelv'), 'strOrdDlvry' => Input::get('ordID'), 'strDlvryRecBy' => Session::get('empID')));
$delivery->save();
return View::make('deliveryDetails')->with('orderproducts', $orderproducts)->with('id1', $id1)->with('id2', $id2);
}
