/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('artists', function (Blueprint $table) {
$table->dropColumn('bandcamp');
$table->dropColumn('patreon');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('novels');
Schema::drop('chapters');
Schema::drop('configs');
Schema::drop('mails');
}
/**
* Fetch the collection of site permissions.
*
* @return \Illuminate\Database\Eloquent\Collection
*/
protected function getPermissions()
{
if (!Schema::hasTable('roles')) {
return new Collection();
}
return Permission::with('roles')->get();
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('oauth_auth_codes', function (Blueprint $t) {
$t->dropForeign('oauth_auth_codes_session_id_foreign');
});
Schema::drop('oauth_auth_codes');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('oauth_refresh_tokens', function (Blueprint $table) {
$table->dropForeign('oauth_refresh_tokens_access_token_id_foreign');
});
Schema::drop('oauth_refresh_tokens');
}
/**
* Reverse the migrations.
*/
public function down()
{
Schema::drop('account_modules', function (Blueprint $table) {
$table->dropForeign('account_module_to_account');
$table->dropForeign('account_module_to_module');
});
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
if ($this->confirm("Clear database? [Yes|no]", "Yes")) {
$this->info('Clear database start');
if (config('database.default') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=0');
} else {
if (config('database.default') == 'sqlite') {
DB::statement('PRAGMA foreign_keys = OFF');
}
}
$tableNames = Schema::getConnection()->getDoctrineSchemaManager()->listTableNames();
foreach ($tableNames as $v) {
Schema::drop($v);
$this->info('Dropped: ' . $v);
}
$this->info('Clear database end');
if (config('database.default') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=1');
} else {
if (config('database.default') == 'sqlite') {
DB::statement('PRAGMA foreign_keys = ON');
}
}
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('finds', function (Blueprint $table) {
$table->dropColumn('icon');
$table->dropColumn('color');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('artist_tracks', function (Blueprint $table) {
$table->dropColumn('display_order');
$table->dropColumn('title_romanized');
});
}
/**
* @return array
*/
public function getDatabaseConfig()
{
if (Schema::hasTable('options')) {
$table = $this->app['db']->table('options');
return $this->changeConfigWithHelpers($table->where('type', 'config')->lists('value', 'key'));
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('user_meta', function (Blueprint $table) {
$table->dropForeign('user_meta_user_id_foreign');
});
Schema::drop('user_meta');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
//
$table->string('password')->nullable(false)->change();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('profesor', function (Blueprint $table) {
$table->integer('pro_tipo');
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
// Oh my word! Cant rename any columns in a table that has an
// enum. o_0
//
// Apply the hacky workaround seen here:
// https://github.com/laravel/framework/issues/1186#issuecomment-248853309
Schema::getConnection()->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
// Define the tables and columns that need to be changed
$integer_tables_and_columns = ['character_bookmarks' => ['itemID'], 'eve_conquerable_station_lists' => ['stationID'], 'character_character_sheets' => ['homeStationID'], 'character_contact_lists' => ['labelMask'], 'character_contact_list_labels' => ['labelID'], 'character_contact_list_alliances' => ['labelMask'], 'character_contact_list_alliance_labels' => ['labelID'], 'character_contact_list_corporates' => ['labelMask'], 'character_contact_list_corporate_labels' => ['labelID'], 'character_contracts' => ['startStationID', 'endStationID'], 'character_industry_jobs' => ['stationID', 'blueprintLocationID', 'outputLocationID'], 'character_market_orders' => ['stationID'], 'character_wallet_journals' => ['argID1'], 'character_wallet_transactions' => ['stationID'], 'corporation_bookmarks' => ['itemID'], 'corporation_contact_list_labels' => ['labelID'], 'corporation_contact_lists' => ['labelMask'], 'corporation_contact_list_alliances' => ['labelMask'], 'corporation_contact_list_alliance_labels' => ['labelID'], 'corporation_contracts' => ['startStationID', 'endStationID'], 'corporation_member_securities' => ['roleID'], 'corporation_sheets' => ['stationID'], 'corporation_industry_jobs' => ['stationID', 'blueprintLocationID', 'outputLocationID'], 'corporation_market_orders' => ['stationID'], 'corporation_wallet_journals' => ['argID1'], 'corporation_wallet_transactions' => ['stationID']];
// Loop over the changes defined in the above array.
foreach ($integer_tables_and_columns as $table => $columns) {
Schema::table($table, function (Blueprint $table) use($columns) {
// Loop over the columns that are passed in and change them
foreach ($columns as $column) {
$table->bigInteger($column)->change();
}
});
}
// Fix some Wallet values for the industry jobs tables.
Schema::table('character_industry_jobs', function (Blueprint $table) {
$table->decimal('cost', 30, 2)->change();
});
Schema::table('corporation_industry_jobs', function (Blueprint $table) {
$table->decimal('cost', 30, 2)->change();
});
}
public function search($input)
{
$query = BarcodeProcess::query();
$query->select('barcode_processes.*');
$query->leftJoin('shelves', 'barcode_processes.shelf_id', '=', 'shelves.id');
$columns = Schema::getColumnListing('barcode_processes');
$attributes = array();
foreach ($columns as $attribute) {
$attributes[$attribute] = null;
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
}
}
/**
* Filter
*/
$this->filter($input, $query);
/**
* Get count
*/
$total = $query->count();
/**
* Pagination
*/
$this->pagination($input, $query);
/**
* Order
*/
$this->order($input, $query);
return [$query->get(), $attributes, 'total' => $total];
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('first_name');
$table->dropColumn('last_name');
});
}
public function search($input)
{
$query = User::query();
$columns = Schema::getColumnListing('users');
$attributes = array();
foreach ($columns as $attribute) {
$attributes[$attribute] = null;
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
}
}
/*
** Filter
*/
$this->filter($input, $query);
/*
** Get count
*/
$total = $query->count();
/*
** Pagination
*/
$this->pagination($input, $query);
/*
** Order
*/
$this->order($input, $query);
return [$query->get(), $attributes, 'total' => $total];
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('administrators', function ($table) {
$table->dropForeign('administrators_user_id_foreign');
});
Schema::drop('administrators');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('oauth_client_endpoints', function (Blueprint $table) {
$table->dropForeign('oauth_client_endpoints_client_id_foreign');
});
Schema::drop('oauth_client_endpoints');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
$tables = ['attached', 'attaches'];
foreach ($tables as $table) {
Schema::dropIfExists($table);
}
}
public function translate(Request $request)
{
$data = $request->only('word', 'src_language', 'trans_language');
$validator = Validator::make($data, array('word' => 'required', 'src_language' => 'required', 'trans_language' => 'required'));
if ($validator->passes()) {
$columns = Schema::getColumnListing('translation');
// users table
if (!in_array($data['src_language'], $columns)) {
return response()->json(array('error' => 1, 'labels' => 'Source language is not available'));
} else {
if (!in_array($data['trans_language'], $columns)) {
return response()->json(array('error' => 1, 'labels' => 'Translation language is available'));
} else {
$tra = Translation::where($data['src_language'], $data['word'])->first();
if (!$tra) {
return response()->json(array('error' => 1, 'labels' => 'This word is not available in our source language'));
} else {
$data = array('word' => $data['word'], 'source' => $data['src_language'], 'target' => $data['trans_language'], 'result' => $tra->{$data}['trans_language']);
return response()->json(array('error' => 0, 'data' => $data, 'errors' => array()));
}
}
}
} else {
return response()->json(array('error' => 1, 'labels' => $validator->messages()));
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('third_party_logins', function (Blueprint $table) {
$table->dropForeign('third_party_logins_user_id_foreign');
});
Schema::drop('third_party_logins');
}
/**
* Ensures the migrations ran and tables exist in the database.
*/
public function test_tables_exist()
{
$expectedTables = ['users', 'password_resets', 'email_addresses', 'phone_numbers', 'addresses'];
foreach ($expectedTables as $table) {
$this->assertTrue(Schema::hasTable($table));
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('permission_role');
Schema::drop('role_user');
Schema::drop('permissions');
Schema::drop('roles');
}
public function createSchema()
{
if (!DbSchema::hasTable('sessions')) {
try {
DbSchema::create('sessions', function ($table) {
$table->string('id')->unique();
$table->longText('payload');
$table->integer('last_activity');
});
} catch (QueryException $e) {
}
}
$exec = $this->getSystemSchemas();
$builder = new DbUtils();
foreach ($exec as $data) {
// Creates the schema
if (!method_exists($data, 'get')) {
break;
}
$schemaArray = $data->get();
if (!is_array($schemaArray)) {
break;
}
foreach ($schemaArray as $table => $columns) {
$builder->build_table($table, $columns);
}
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('posts', function (Blueprint $table) {
$table->dropForeign('posts_topic_id_foreign');
});
Schema::drop('topics');
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('languages', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->string('short_two');
$table->string('short_three');
$table->timestamps();
});
Schema::create('groups', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->integer('group_id')->nullable()->comment('Refer to self for multidimensional groups');
$table->timestamps();
});
Schema::create('names', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->integer('group_id');
$table->timestamps();
});
Schema::create('values', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->integer('language_id');
$table->integer('name_id');
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('administradors', function (Blueprint $table) {
$table->integer('adm_tipo');
$table->timestamps();
});
}
/**
* Bootstrap the application services.
*
* @return void
*/
public function boot()
{
if (Schema::hasTable('categories')) {
$categories = Category::getAllFromCache();
view()->share('categories', $categories);
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table("contacts", function (Blueprint $table) {
$table->dropForeign("contacts_partnership_id_foreign");
});
Schema::drop("contacts");
}