/** * Responds to requests to */ public function getPage($id = null) { if ($id != null) { // find the item in the added_items table $item = \App\AddedItem::where('id', '=', $id)->find($id); $itemAsArray = $item->toArray(); // update the added_items table if ($itemAsArray) { $item->make_public = TRUE; // save changes $item->save(); \Session::flash('flash_message', 'You successfully made ' . $item->item . ' public for sale!'); } // add the item to the public_items table $publicItem = new \App\PublicItem(); $publicItem->item = $itemAsArray['item']; $publicItem->category = $itemAsArray['category']; $publicItem->one_line_description = $itemAsArray['one_line_description']; $publicItem->price = $itemAsArray['price']; $publicItem->detailed_description = $itemAsArray['detailed_description']; $publicItem->user_id = \Auth::id(); $publicItem->save(); } // fetch the items from the public_items table $items = \App\PublicItem::where('bought', '=', 0)->get(); //dump($items->toArray()); $itemsArray = $items->toArray(); //dump($itemsArray); return view('pongo.browse_items')->with('items', $itemsArray); }
/** * Responds to requests to */ public function getPage($id = null) { // update the public_items table and mark the item as bought $item = \App\PublicItem::where('id', '=', $id)->find($id); //dump($item->toArray()); $price = null; // make sure the item isn't one that is posted by the user $user_id = $item['user_id']; if ($user_id == \Auth::id()) { \Session::flash('flash_message', 'You cannot purchase an item that you posted!'); // fetch the items from the public_items table $items = \App\PublicItem::where('bought', '=', 0)->get(); //dump($items->toArray()); $itemsArray = $items->toArray(); //dump($itemArray->toArray()); // calculate the tax and total return view('pongo.browse_items')->with('items', $itemsArray); } $price = $item['price']; //echo $price; $tax = round($price * 0.1, 2); //echo $tax; $total = $price + $tax; //echo $total; // update the item as bought $item->bought = TRUE; $item->save(); // update the transaction table for the user who buys the product $transactionBuy = new \App\Transaction(); $transactionBuy->transaction_type = "BUY"; $transactionBuy->public_item_id = $id; $transactionBuy->user_id = \Auth::id(); $transactionBuy->tax = $tax; $transactionBuy->total = $total; $transactionBuy->save(); //dump($transactionBuy->toArray()); $transactionBuyObject = (object) $transactionBuy->toArray(); $itemAsArray = $item->toArray(); $itemObject = (object) $itemAsArray; // send an email to the user who made the purchase \Mail::send(['html' => 'pongo.sales_receipt_email'], array('item' => $itemObject, 'transactionBuy' => $transactionBuyObject), function ($message) { $message->to(\Auth::user()->email, \Auth::user()->name)->subject('You made a puchase on Pongo!'); }); // update the transaction table for user who sold the product $transactionSell = new \App\Transaction(); $transactionSell->transaction_type = "SELL"; $transactionSell->public_item_id = $id; $transactionSell->user_id = $user_id; $transactionSell->tax = $tax; $transactionSell->total = $total; $transactionSell->save(); // delete the item from the added_items $addedItem = \App\AddedItem::where('one_line_description', '=', $item->one_line_description)->get(); //dump($publicItem[0]); $addedItem[0]->delete(); \Session::flash('flash_message', 'You successfully purchased the ' . $itemObject->item . '!'); return view('pongo.receipt_details')->with(['item' => $itemObject, 'transactionBuy' => $transactionBuyObject]); }
/** * Responds to requests to */ public function getPage($id = null) { //echo $id; // get the item $item = \App\PublicItem::where('id', '=', $id)->get(); $itemAsArray = $item->toArray(); //dump($itemAsArray[0]); $itemObject = (object) $itemAsArray[0]; //dump($itemObject); return view('pongo.details')->with('item', $itemObject); }
/** * Run the database seeds. * * @return void */ public function run() { // $public_item_id = \App\PublicItem::where('item', '=', 'Coffee Mug')->pluck('id'); DB::table('transactions')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'transaction_type' => 'BUY', 'public_item_id' => $public_item_id, 'user_id' => 1, 'tax' => 2.4, 'total' => 26.39]); $public_item_id = \App\PublicItem::where('item', '=', 'Coffee Mug')->pluck('id'); DB::table('transactions')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'transaction_type' => 'SELL', 'public_item_id' => $public_item_id, 'user_id' => 3, 'tax' => 2.4, 'total' => 26.39]); $public_item_id = \App\PublicItem::where('item', '=', 'Binder')->pluck('id'); DB::table('transactions')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'transaction_type' => 'BUY', 'public_item_id' => $public_item_id, 'user_id' => 2, 'tax' => 1.2, 'total' => 13.19]); $public_item_id = \App\PublicItem::where('item', '=', 'Binder')->pluck('id'); DB::table('transactions')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'transaction_type' => 'SELL', 'public_item_id' => $public_item_id, 'user_id' => 4, 'tax' => 1.2, 'total' => 13.19]); }
/** * Responds to requests to */ public function getPage($id = null) { // find the item to delete $item = \App\AddedItem::find($id); //dump($item); $item->delete(); //dump($item->make_public); // if it was made public, delete it from the public_items table if ($item->make_public) { $publicItem = \App\PublicItem::where('one_line_description', '=', $item->one_line_description)->get(); //dump($publicItem[0]); $publicItem[0]->delete(); } \Session::flash('flash_message', $item->item . ' was deleted.'); return redirect('/myspace'); }