/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->string('name', 64)->change();
$table->string('email', 64)->nullable()->change();
$table->string('password', 64)->nullable()->change();
$table->char('locale', 5);
$table->char('currency', 3);
$table->integer('joined')->unsigned();
$table->integer('last_login')->unsigned();
$table->tinyInteger('notifications')->unsigned();
$table->renameColumn('id', 'user_id');
$table->renameColumn('name', 'username');
$table->dropColumn('created_at');
$table->dropColumn('updated_at');
});
Schema::create('categories', function (Blueprint $table) {
$table->mediumInteger('category_id', true)->unsigned();
$table->mediumInteger('parent_category_id')->nullable()->unsigned();
$table->string('name', 128);
$table->string('slug', 32);
$table->tinyInteger('sort')->unsigned();
$table->foreign('parent_category_id')->references('category_id')->on('categories');
$table->unique(['parent_category_id', 'slug']);
});
Schema::create('item_conditions', function (Blueprint $table) {
$table->mediumInteger('item_condition_id', true)->unsigned();
$table->string('name', 64);
$table->tinyInteger('sort')->unsigned();
});
Schema::create('listing_durations', function (Blueprint $table) {
$table->mediumInteger('listing_duration_id', true)->unsigned();
$table->integer('duration')->unsigned();
$table->tinyInteger('sort')->unsigned();
});
Schema::create('items', function (Blueprint $table) {
$table->integer('item_id')->unsigned();
$table->string('name', 128);
$table->mediumInteger('item_condition_id')->unsigned();
$table->integer('user_id')->unsigned();
$table->text('description');
$table->boolean('auction');
$table->integer('quantity')->unsigned();
$table->decimal('start_price', 8, 2)->nullable()->unsigned();
$table->decimal('reserve_price', 8, 2)->nullable()->unsigned();
$table->decimal('bidding_price', 8, 2)->nullable()->unsigned();
$table->decimal('fixed_price', 8, 2)->nullable()->unsigned();
$table->decimal('commission', 5, 2)->unsigned();
$table->integer('winning_bid_id')->nullable()->unsigned();
$table->integer('duration')->unsigned();
$table->integer('start_date')->unsigned();
$table->integer('end_date')->unsigned();
$table->integer('created')->unsigned();
$table->string('collection_location')->nullable();
$table->boolean('payment_other');
$table->tinyInteger('returns_period')->nullable()->unsigned();
$table->primary('item_id');
$table->foreign('user_id')->references('user_id')->on('users');
$table->foreign('item_condition_id')->references('item_condition_id')->on('item_conditions');
});
Schema::create('item_categories', function (Blueprint $table) {
$table->integer('item_id')->unsigned();
$table->mediumInteger('category_id')->unsigned();
$table->primary(['item_id', 'category_id']);
$table->foreign('item_id')->references('item_id')->on('items');
$table->foreign('category_id')->references('category_id')->on('categories');
});
Schema::create('delivery_options', function (Blueprint $table) {
$table->integer('delivery_option_id', true)->unsigned();
$table->integer('item_id')->unsigned();
$table->string('name', 64);
$table->float('price', 5, 2)->unsigned();
$table->tinyInteger('min_arrival_time')->unsigned();
$table->tinyInteger('max_arrival_time')->unsigned();
$table->foreign('item_id')->references('item_id')->on('items');
});
Schema::create('failed_jobs', function (Blueprint $table) {
$table->increments('failed_job_id');
$table->text('connection');
$table->text('queue');
$table->text('payload');
$table->timestamp('failed_at');
});
Schema::create('watched_items', function (Blueprint $table) {
$table->integer('item_id')->unsigned();
$table->integer('user_id')->unsigned();
$table->integer('added')->unsigned();
$table->primary(['item_id', 'user_id']);
$table->foreign('item_id')->references('item_id')->on('items');
$table->foreign('user_id')->references('user_id')->on('users');
});
$conditions = ['New', 'Used', 'Refurbished', 'Faulty / Spares'];
foreach ($conditions as $condition) {
$item_condition = new ItemCondition();
$item_condition->name = $condition;
$item_condition->save();
}
$durations = [86400, 86400 * 3, 86400 * 7, 86400 * 14, 86400 * 28];
foreach ($durations as $duration) {
$listing_duration = new ListingDuration();
$listing_duration->duration = $duration;
$listing_duration->save();
}
}
/**
* Create an item condition.
*
* @return \Illuminate\Http\RedirectResponse
*/
public function createItemCondition(Request $request)
{
$this->validate($request, ['name' => 'required']);
$item_condition = new ItemCondition();
$item_condition->name = $request->input('name');
$item_condition->save();
return redirect()->back()->withStatus(trans('mustard::admin.item_condition_created'));
}
