/** * Return the item listings view. * * @return \Illuminate\View\View */ public function getIndex(Request $request, $path = null) { $items = Item::active(); if ($request->input('q')) { $items->keywords($request->input('q')); } // Handle root if (is_null($path)) { $category = null; } else { $tree = explode('/', $path); $category = Category::findBySlug(array_slice($tree, -1)[0]); $items->whereHas('categories', function ($query) use($category) { $query->whereIn('categories.category_id', array_merge($category->getDescendantIds(), [$category->getKey()])); }); } $table = new ListingItems($items, $request); $table->with('categories'); if (mustard_loaded('auctions')) { $table->with('bids'); } if (mustard_loaded('media')) { $table->with('photos'); } return view('mustard::listings.list', ['categories' => Category::roots()->with('children')->orderBy('sort', 'asc')->orderBy('name', 'asc')->get(), 'table' => $table, 'items' => $table->paginate(), 'view_category' => $category]); }
/** * Return the inventory bought items view. * * @return \Illuminate\View\View */ public function getBought() { $items = Item::join('seller')->leftJoin('purchases')->where('purchases.user_id', Auth::user()->userId); if (mustard_loaded('auctions')) { $items->leftJoin('winningBid')->orWhere('bids.user_id', Auth::user()->userId); } $table = new InventoryBought($items); return view('mustard::inventory.bought', ['table' => $table, 'items' => $table->paginate()]); }
/** * Return the inventory bidding items view. * * @return \Illuminate\View\View */ public function getBidding() { $items = Item::typeAuction()->active()->whereHas('bids', function ($query) { return $query->where('user_id', Auth::user()->userId); }); $items = Item::typeAuction()->active()->leftJoin('bids')->where('bids.user_id', Auth::user()->userId)->addSelect(DB::raw('max(`bids`.`amount`) as `max_bid`'))->addSelect(DB::raw('count(`bids`.`bid_id`) as `bid_count`'))->groupBy('items.item_id'); $table = new InventoryBidding($items); return view('mustard::inventory.bidding', ['table' => $table, 'items' => $table->paginate()]); }
/** * Watch an item. * * @param \Illuminate\Http\Request $request * * @return \Illuminate\Http\RedirectResponse */ public static function endedAuctionsAdmin() { $items = Item::has('bids')->where('auction', true)->whereRaw('`reserve_price` <= `bidding_price`')->where('user_ended', 0)->where('winning_bid_id', 0)->where('end_date', '<', time())->get(); foreach ($items as $item) { $item->end(); $item->winningBid->bidder->sendEmail('You won an item', 'emails.item.won', ['item_id' => $item->itemId, 'item_name' => $item->name, 'item_price' => $item->biddingPrice, 'bid_amount' => $item->winningBid->amount, 'bid_placed' => $item->winningBid->placed]); } }
/** * Unwatch an item. * * @param \Illuminate\Http\Request $request * * @return \Illuminate\Http\RedirectResponse */ public function postUnwatch(Request $request) { $item = Item::findOrFail($request->input('item_id')); if (!Auth::user()->watching->contains($item)) { return redirect()->back()->withErrors(["You aren't watching this item."]); } Auth::user()->watching()->detach($item); return redirect()->back()->withStatus($item->name . ' has been removed from your watched items.'); }
/** * Checkout an item. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\RedirectResponse */ public function postCheckout(Request $request) { $item = Item::findOrFail($request->input('item_id')); if ($item->seller->userId == Auth::user()->userId) { return redirect($item->url)->withStatus('You cannot purchase your own items.'); } // Check for unpaid item if ($unpaid = $item->purchases()->where('user_id', Auth::user()->userId)->where('paid', 0)->first()) { return redirect('/pay/' . $unpaid->purchaseId); } if (!$item->auction && $item->isEnded()) { return redirect()->back()->withErrors(['You can no longer can no longer continue with this purchase because the item has ended.']); } if (!$item->auction && $request->input('quantity') > $item->quantity) { return redirect()->back()->withErrors(['You cannot purchase more than the available stock.']); } if ($item->auction && !$item->isEnded()) { return redirect()->back()->withErrors(['You must win an auction before you can pay for it.']); } if ($item->auction && !$item->winningBid) { return redirect()->back()->withErrors(['Please wait while this auction is processed.']); } if ($item->auction && $item->winningBid->bidder != Auth::user()) { return redirect()->back()->withErrors(["You can only pay for an auction you've won."]); } if ($item->auction && $item->isEnded() && $item->purchases->count()) { return redirect('/pay/' . $item->purchases->first()->purchaseId); } $validator = \Validator::make(\Input::all(), ['delivery_option' => 'required', 'quantity' => 'integer', 'postal_address' => 'required_if:delivery_option,collection', 'name' => 'required_if:postal_address,add', 'street1' => 'required_if:postal_address,add', 'city' => 'required_if:postal_address,add', 'county' => 'required_if:postal_address,add', 'postcode' => 'required_if:postal_address,add', 'country' => 'required_if:postal_address,add']); if ($validator->fails()) { return redirect()->back()->withErrors($validator); } $purchase = new Purchase(); $purchase->created = time(); $purchase->item()->associate($item); $purchase->buyer()->associate(Auth::user()); if ($request->input('delivery_option') != 'collection') { if (!($delivery_option = DeliveryOption::find($request->input('delivery_option')))) { return redirect()->back()->withErrors(['delivery_option' => 'Please select a valid delivery option.']); } $purchase->deliveryOption()->associate($delivery_option); if ($request->input('postal_address') == 'add') { $postal_address = new PostalAddress(); $postal_address->name = $request->input('name'); $postal_address->street1 = $request->input('street1'); $postal_address->street2 = $request->input('street2'); $postal_address->city = $request->input('city'); $postal_address->county = $request->input('county'); $postal_address->country = $request->input('country'); $postal_address->postcode = $request->input('postcode'); $postal_address->user()->associate(Auth::user()); if (!Iso3166::exists($postal_address->country)) { return redirect()->back()->withErrors(['country' => 'Please select a valid country.']); } if ($request->input('remember')) { $postal_address->save(); } } elseif (!($postal_address = PostalAddress::find($request->input('postal_address')))) { return redirect()->back()->withErrors(['postal_address' => 'Please select a valid postal address.']); } elseif ($postal_address->user != Auth::user()) { return redirect()->back()->withErrors(['postal_address' => 'You can only select your own postal addresses.']); } $purchase->useAddress($postal_address); } if ($item->auction && !$item->isActive()) { $purchase->unitPrice = $purchase->total = $item->biddingPrice; $purchase->quantity = 1; } else { $purchase->unitPrice = $item->fixedPrice; $purchase->quantity = $request->input('quantity') ?: 1; $purchase->total = round($purchase->unitPrice * $purchase->quantity, 2); $item->quantity -= $purchase->quantity; $item->save(); } $purchase->save(); return redirect("/pay/{$purchase->purchaseId}"); }
/** * Run the seeder. * * @return void */ public function run() { $this->faker = FakerFactory::create('en_GB'); // Returns a random element from an array function mt_rand_arr($array, $exclude = []) { if ($exclude) { $array = array_diff($array, $exclude); } return $array[mt_rand(0, count($array) - 1)]; } DB::connection()->disableQueryLog(); $this->now = time(); $this->itemConditions = ItemCondition::all(); $this->listingDurations = ListingDuration::all(); $this->command->info('Adding categories'); for ($i = 1; $i <= self::TOTAL_CATEGORIES; $i++) { $category = new Category(); $category->name = implode(' ', $this->faker->words(2)); $category->slug = str_slug($category->name); $category->sort = mt_rand(0, 10); $category->save(); $this->categories[] = $category; } foreach ($this->categories as $category) { if (mt_rand(0, 1)) { continue; } $category->parentCategoryId = mt_rand_arr($this->categories)->categoryId; $category->save(); } $this->command->info('Adding users'); for ($i = 1; $i <= self::TOTAL_USERS; $i++) { $user = new User(); $user->username = $this->faker->userName; while (User::findByEmail($user->email = $this->faker->email)) { } $user->password = Hash::make('password'); $user->verified = true; $user->joined = mt_rand($this->now - mt_rand(0, 86400 * 200), $this->now); $user->locale = $this->faker->locale; $user->currency = $this->faker->currencyCode; $user->lastLogin = mt_rand($user->joined, $this->now); $user->save(); //if ($i == 1) $user->grantAdmin(); $this->users[] = $user; } if (mustard_loaded('commerce')) { $this->command->info('Adding postal addresses'); foreach ($this->users as $user) { for ($i = 0; $i <= mt_rand(1, 3); $i++) { $postal_address = new \Hamjoint\Mustard\Commerce\PostalAddress(); $postal_address->user()->associate($user); $postal_address->name = $user->username; $postal_address->street1 = $this->faker->secondaryAddress; $postal_address->street2 = $this->faker->streetAddress; $postal_address->city = $this->faker->city; $postal_address->county = $this->faker->county; $postal_address->postcode = $this->faker->postcode; $postal_address->country = $this->faker->countryCode; $postal_address->save(); } } } $this->command->info('Adding items'); for ($i = 1; $i <= self::TOTAL_ITEMS; $i++) { $item = new Item(); $item->seller()->associate(mt_rand_arr($this->users)); $item->condition()->associate($this->itemConditions->random()); $item->name = implode(' ', $this->faker->words(mt_rand(2, 5))); $item->description = implode("\n\n", $this->faker->paragraphs(2)); $item->auction = mustard_loaded('auctions') ? (bool) mt_rand(0, 1) : false; $item->quantity = !$item->auction ? mt_rand(1, 100) : 1; $item->startPrice = $item->biddingPrice = mt_rand(50, 500000) / 100; $item->reservePrice = mt_rand($item->startPrice * 100, 500000) / 100; $item->fixedPrice = !$item->auction || !mt_rand(0, 3) ? $item->startPrice + mt_rand(50, 500000) / 100 : 0; $item->commission = 0.07000000000000001; $item->duration = $this->listingDurations->random()->duration; $item->created = mt_rand($item->seller->joined, $this->now); $item->startDate = mt_rand($item->created, $this->now + 86400 * 14); $item->endDate = $item->getEndDate(); $item->collectionLocation = $this->faker->city; $item->paymentOther = mt_rand(0, 1); $item->returnsPeriod = mt_rand(7, 21); $item->save(); // Add to categories for ($ii = 0; $ii < mt_rand(1, 3); $ii++) { $category = Category::leaves()->get()->random(); try { $item->categories()->save($category); } catch (\Exception $e) { // } } // Add delivery options for ($ii = 0; $ii < mt_rand(0, 3); $ii++) { $delivery_option = new \Hamjoint\Mustard\DeliveryOption(); $delivery_option->name = implode(' ', $this->faker->words(3)); $delivery_option->price = mt_rand(50, 1000) / 100; $delivery_option->min_arrival_time = mt_rand(2, 10); $delivery_option->max_arrival_time = mt_rand($delivery_option->min_arrival_time, $delivery_option->min_arrival_time + 20); $delivery_option->item()->associate($item); $delivery_option->save(); } $watchers = []; // Add watchers for ($ii = 0; $ii < mt_rand(0, 3); $ii++) { $watchers[] = mt_rand_arr($this->users); } foreach (array_unique($watchers) as $watcher) { $item->watchers()->save($watcher, ['added' => mt_rand($item->startDate, $item->endDate)]); } } if (mustard_loaded('auctions')) { $this->command->info('Adding bids'); foreach (Item::where('auction', true)->where('start_date', '<=', $this->now)->get() as $item) { $bid_amount = $item->startPrice; $bid_time = $item->startDate; $end_time = $item->endDate < $this->now ? $item->endDate : $this->now; for ($i = 0; $i < mt_rand(0, 10); $i++) { if ($bid_time == $end_time) { break; } $bid = new \Hamjoint\Mustard\Auctions\Bid(); do { $user = mt_rand_arr($this->users); } while ($user->userId == $item->seller->userId); $bid->bidder()->associate($user); $minimum_bid = \Hamjoint\Mustard\Auctions\BidIncrement::getMinimumNextBid($bid_amount); $bid->amount = $bid_amount = $i == 0 ? $item->startPrice : mt_rand($minimum_bid * 100, ($minimum_bid + $bid_amount) * 100) / 100; $bid->placed = $bid_time = mt_rand($bid_time, $end_time); $item->bids()->save($bid); } $last_bids = $item->bids()->orderBy('placed', 'desc')->take(2)->get(); if ($last_bids->count()) { $item->biddingPrice = \Hamjoint\Mustard\Auctions\BidIncrement::getMinimumNextBid($last_bids->last()->amount); } if (!$item->isActive()) { $bid = $item->bids()->where('amount', DB::raw('(select max(`amount`) from `bids` where `item_id` = ' . $item->itemId . ')'))->first(); if ($bid) { $item->winningBid()->associate($bid); } } $item->save(); } } if (mustard_loaded('commerce')) { $this->command->info('Adding purchases'); foreach (Item::all() as $item) { if ($item->auction && $item->isEnded()) { $item->end(); } if (!$item->isStarted() || mustard_loaded('auctions') && $item->auction && !$item->winningBid) { continue; } if (mt_rand(0, 5)) { $purchase = new \Hamjoint\Mustard\Commerce\Purchase(); $purchase->item()->associate($item); $purchase->buyer()->associate(mustard_loaded('auctions') && $item->auction ? $item->winningBid->bidder : mt_rand_arr($this->users)); if ($item->deliveryOptions->count() && ($delivery_option = $item->deliveryOptions->random())) { $purchase->deliveryOption()->associate($delivery_option); } $purchase->useAddress($purchase->buyer->postalAddresses->random()); $purchase->created = mt_rand($item->startDate, min($item->endDate, $this->now)); $purchase->unitPrice = $purchase->total = $item->biddingPrice; $purchase->quantity = 1; if (mt_rand(0, 5)) { $purchase->received = $purchase->grandTotal; $purchase->paid = mt_rand($purchase->created, $this->now); if (mt_rand(0, 2)) { $purchase->dispatched = mt_rand($purchase->paid, $this->now); if (mt_rand(0, 2)) { $purchase->trackingNumber = str_random(16); } if (mt_rand(0, 1)) { $purchase->refunded = mt_rand($purchase->dispatched, $this->now); if (mt_rand(0, 1)) { $purchase->refundedAmount = $purchase->grandTotal; } else { $purchase->refundedAmount = mt_rand(1, $purchase->grandTotal); } } } } $purchase->save(); } } } if (mustard_loaded('feedback')) { $this->command->info('Adding feedback'); foreach (\Hamjoint\Mustard\Commerce\Purchase::all() as $purchase) { for ($i = 0; $i < 1; $i++) { if (!mt_rand(0, 5)) { continue; } $rater = $purchase->buyer; $subject = $purchase->item->seller; if ($i) { list($rater, $subject) = [$subject, $rater]; } $feedback = new \Hamjoint\Mustard\Feedback\UserFeedback(); $feedback->rating = mt_rand(0, 10) - 5; $feedback->message = $this->faker->sentence; $feedback->placed = mt_rand($purchase->created, $this->now); $feedback->rater()->associate($rater); $feedback->subject()->associate($subject); $feedback->purchase()->associate($purchase); $feedback->save(); } } } if (mustard_loaded('messaging')) { $this->command->info('Adding messages'); foreach (User::all() as $user) { for ($i = 0; $i < mt_rand(5, 50); $i++) { $message = new \Hamjoint\Mustard\Messaging\Message(); $message->subject = $this->faker->sentence; $message->body = implode("\n\n", $this->faker->paragraphs(2)); $recipient = mt_rand_arr($this->users, [$user]); $sender = $user; $message->sent = mt_rand(max($sender->joined, $recipient->joined), $this->now); $message->read = (bool) mt_rand(0, 1); $message->recipient()->associate($recipient); $message->sender()->associate($sender); $message->user()->associate($sender); $recipient_copy = clone $message; $recipient_copy->user()->associate($recipient); $recipient_copy->save(); $message->save(); } } } }
/** * Return the admin items view. * * @return \Illuminate\View\View */ public function showItemsTable() { $table = new AdminItems(Item::query()); $table->with('seller'); if (mustard_loaded('feedback')) { $table->with('seller.feedbackReceived'); } return view('mustard::admin.items', ['table' => $table, 'items' => $table->paginate()]); }