/**
* 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()]);
}
