@@ -13,7 +13,7 @@ |
||
| 13 | 13 | */ |
| 14 | 14 | public function up() |
| 15 | 15 | { |
| 16 | - Schema::create('exports', function (Blueprint $table) { |
|
| 16 | + Schema::create('exports', function(Blueprint $table) { |
|
| 17 | 17 | $table->increments('id'); |
| 18 | 18 | $table->string('file', 255)->nullable(); |
| 19 | 19 | $table->string('type', 10); |
@@ -13,7 +13,7 @@ |
||
| 13 | 13 | */ |
| 14 | 14 | public function up() |
| 15 | 15 | { |
| 16 | - Schema::create('imports', function (Blueprint $table) { |
|
| 16 | + Schema::create('imports', function(Blueprint $table) { |
|
| 17 | 17 | $table->increments('id'); |
| 18 | 18 | $table->string('file', 255); |
| 19 | 19 | $table->integer('file_rows'); |
@@ -13,7 +13,7 @@ |
||
| 13 | 13 | */ |
| 14 | 14 | public function up() |
| 15 | 15 | { |
| 16 | - Schema::create('import_export_logs', function (Blueprint $table) { |
|
| 16 | + Schema::create('import_export_logs', function(Blueprint $table) { |
|
| 17 | 17 | $table->increments('id'); |
| 18 | 18 | $table->integer('op_id'); |
| 19 | 19 | $table->longText('data'); |
@@ -19,28 +19,28 @@ discard block |
||
| 19 | 19 | |
| 20 | 20 | protected $import; |
| 21 | 21 | |
| 22 | - protected function setUp () |
|
| 22 | + protected function setUp() |
|
| 23 | 23 | { |
| 24 | 24 | parent::setUp(); |
| 25 | 25 | |
| 26 | 26 | Route::middleware('web')->group(function() { |
| 27 | 27 | |
| 28 | - Route::get('ticket/import', ['as' => 'ticket.import', 'uses' => 'Ladybirdweb\ImportExport\Import@showImportForm'] ); |
|
| 29 | - Route::post('ticket/import', ['as' => 'ticket.import', 'uses' => 'Ladybirdweb\ImportExport\Import@uploadImportFile'] ); |
|
| 28 | + Route::get('ticket/import', ['as' => 'ticket.import', 'uses' => 'Ladybirdweb\ImportExport\Import@showImportForm']); |
|
| 29 | + Route::post('ticket/import', ['as' => 'ticket.import', 'uses' => 'Ladybirdweb\ImportExport\Import@uploadImportFile']); |
|
| 30 | 30 | |
| 31 | - Route::get('/ticket/import/{id}/map', [ 'as' => 'ticket.import.show.map', 'uses' => 'Ladybirdweb\ImportExport\Import@showColumnsMapForm']); |
|
| 32 | - Route::post('/ticket/import/{id}', [ 'as' => 'ticket.import.map', 'uses' => 'Ladybirdweb\ImportExport\Import@storeColumnsMap']); |
|
| 31 | + Route::get('/ticket/import/{id}/map', ['as' => 'ticket.import.show.map', 'uses' => 'Ladybirdweb\ImportExport\Import@showColumnsMapForm']); |
|
| 32 | + Route::post('/ticket/import/{id}', ['as' => 'ticket.import.map', 'uses' => 'Ladybirdweb\ImportExport\Import@storeColumnsMap']); |
|
| 33 | 33 | |
| 34 | - Route::get( '/import/{id}/progress', [ 'as' => 'ladybirdweb.import.ajax.progress', 'uses' => 'Ladybirdweb\ImportExport\Import@returnImportProgress']); |
|
| 34 | + Route::get('/import/{id}/progress', ['as' => 'ladybirdweb.import.ajax.progress', 'uses' => 'Ladybirdweb\ImportExport\Import@returnImportProgress']); |
|
| 35 | 35 | |
| 36 | 36 | }); |
| 37 | 37 | |
| 38 | - Storage::putFileAs('imports', new File( storage_path( 'test/test.csv' ) ), 'test.csv'); |
|
| 38 | + Storage::putFileAs('imports', new File(storage_path('test/test.csv')), 'test.csv'); |
|
| 39 | 39 | |
| 40 | 40 | $this->import = ModelImport::create([ |
| 41 | 41 | 'file' => 'imports/test.csv', |
| 42 | 42 | 'file_rows' => 104, |
| 43 | - 'db_cols' => [ 'name', 'email', 'password'], |
|
| 43 | + 'db_cols' => ['name', 'email', 'password'], |
|
| 44 | 44 | 'model_map' => ['email', 'name', 'password'] |
| 45 | 45 | ]); |
| 46 | 46 | } |
@@ -54,7 +54,7 @@ discard block |
||
| 54 | 54 | |
| 55 | 55 | $response = $this->get('ticket/import'); |
| 56 | 56 | |
| 57 | - $response->assertSee( 'importer' ); |
|
| 57 | + $response->assertSee('importer'); |
|
| 58 | 58 | } |
| 59 | 59 | |
| 60 | 60 | /** |
@@ -64,13 +64,13 @@ discard block |
||
| 64 | 64 | { |
| 65 | 65 | Storage::fake('file'); |
| 66 | 66 | |
| 67 | - $response = $this->json( 'POST', '/ticket/import', [ |
|
| 67 | + $response = $this->json('POST', '/ticket/import', [ |
|
| 68 | 68 | 'file' => UploadedFile::fake()->create('file.csv', 100) |
| 69 | 69 | ]); |
| 70 | 70 | |
| 71 | 71 | $response->assertStatus(200); |
| 72 | 72 | |
| 73 | - $response->assertJsonFragment( ['status' => 'ready'] ); |
|
| 73 | + $response->assertJsonFragment(['status' => 'ready']); |
|
| 74 | 74 | } |
| 75 | 75 | |
| 76 | 76 | /** |
@@ -80,15 +80,15 @@ discard block |
||
| 80 | 80 | { |
| 81 | 81 | Storage::fake('file'); |
| 82 | 82 | |
| 83 | - $response = $this->json( 'POST', '/ticket/import', [ |
|
| 83 | + $response = $this->json('POST', '/ticket/import', [ |
|
| 84 | 84 | 'file' => UploadedFile::fake()->image('file.jpg') |
| 85 | 85 | ]); |
| 86 | 86 | |
| 87 | 87 | $response->assertStatus(200); |
| 88 | 88 | |
| 89 | - $response->assertJsonFragment( ['status' => 'failed'] ); |
|
| 89 | + $response->assertJsonFragment(['status' => 'failed']); |
|
| 90 | 90 | |
| 91 | - $this->assertArrayHasKey( 'errors', Import::getImportErrors() ); |
|
| 91 | + $this->assertArrayHasKey('errors', Import::getImportErrors()); |
|
| 92 | 92 | } |
| 93 | 93 | |
| 94 | 94 | /** |
@@ -100,11 +100,11 @@ discard block |
||
| 100 | 100 | |
| 101 | 101 | $id = $this->import->id; |
| 102 | 102 | |
| 103 | - $response = $this->get('/ticket/import/' . $id . '/map'); |
|
| 103 | + $response = $this->get('/ticket/import/'.$id.'/map'); |
|
| 104 | 104 | |
| 105 | 105 | $response->assertStatus(200); |
| 106 | 106 | |
| 107 | - $response->assertSee( 'Confirm Import' ); |
|
| 107 | + $response->assertSee('Confirm Import'); |
|
| 108 | 108 | } |
| 109 | 109 | |
| 110 | 110 | /** |
@@ -114,13 +114,13 @@ discard block |
||
| 114 | 114 | { |
| 115 | 115 | $id = $this->import->id; |
| 116 | 116 | |
| 117 | - $response = $this->post( '/ticket/import/' . $id, [ |
|
| 117 | + $response = $this->post('/ticket/import/'.$id, [ |
|
| 118 | 118 | 'db_column' => ['email', 'name', 'password'] |
| 119 | - ] ); |
|
| 119 | + ]); |
|
| 120 | 120 | |
| 121 | 121 | $response->assertStatus(200); |
| 122 | 122 | |
| 123 | - $response->assertSessionMissing( 'errors' ); |
|
| 123 | + $response->assertSessionMissing('errors'); |
|
| 124 | 124 | } |
| 125 | 125 | |
| 126 | 126 | /** |
@@ -130,13 +130,13 @@ discard block |
||
| 130 | 130 | { |
| 131 | 131 | $id = $this->import->id; |
| 132 | 132 | |
| 133 | - $response = $this->post( '/ticket/import/' . $id, [ |
|
| 133 | + $response = $this->post('/ticket/import/'.$id, [ |
|
| 134 | 134 | 'db_column' => ['name', 'name', 'name'] |
| 135 | - ] ); |
|
| 135 | + ]); |
|
| 136 | 136 | |
| 137 | 137 | $response->assertStatus(302); |
| 138 | 138 | |
| 139 | - $response->assertSessionHas( 'errors' ); |
|
| 139 | + $response->assertSessionHas('errors'); |
|
| 140 | 140 | } |
| 141 | 141 | |
| 142 | 142 | /** |
@@ -148,7 +148,7 @@ discard block |
||
| 148 | 148 | |
| 149 | 149 | Queue::fake(); |
| 150 | 150 | |
| 151 | - Import::dispatchImportJob( FakeJob::class, $import ); |
|
| 151 | + Import::dispatchImportJob(FakeJob::class, $import); |
|
| 152 | 152 | |
| 153 | 153 | Queue::assertPushedOn('importing', FakeJob::class); |
| 154 | 154 | } |
@@ -158,12 +158,12 @@ discard block |
||
| 158 | 158 | */ |
| 159 | 159 | public function check_import_progress() |
| 160 | 160 | { |
| 161 | - $response = $this->json( 'GET', '/import/1/progress' ); |
|
| 161 | + $response = $this->json('GET', '/import/1/progress'); |
|
| 162 | 162 | |
| 163 | 163 | $response->assertStatus(200); |
| 164 | 164 | |
| 165 | - $response->assertJsonFragment( ['status' => 200] ); |
|
| 165 | + $response->assertJsonFragment(['status' => 200]); |
|
| 166 | 166 | |
| 167 | - $response->assertJsonFragment( ['progress'] ); |
|
| 167 | + $response->assertJsonFragment(['progress']); |
|
| 168 | 168 | } |
| 169 | 169 | } |
@@ -20,23 +20,23 @@ discard block |
||
| 20 | 20 | |
| 21 | 21 | protected $export; |
| 22 | 22 | |
| 23 | - protected function setUp () |
|
| 23 | + protected function setUp() |
|
| 24 | 24 | { |
| 25 | 25 | parent::setUp(); |
| 26 | 26 | |
| 27 | 27 | Route::middleware('web')->group(function() { |
| 28 | 28 | |
| 29 | - Route::get('/ticket/export/{id}', [ 'as' => 'ticket.export.progress', 'uses' => 'Ladybirdweb\ImportExport\Export@showExportStatus']); |
|
| 29 | + Route::get('/ticket/export/{id}', ['as' => 'ticket.export.progress', 'uses' => 'Ladybirdweb\ImportExport\Export@showExportStatus']); |
|
| 30 | 30 | |
| 31 | - Route::get( '/export/{id}/download', [ 'as' => 'ladybirdweb.export.download', 'uses' => 'Ladybirdweb\ImportExport\Export@downloadExportedFile']); |
|
| 31 | + Route::get('/export/{id}/download', ['as' => 'ladybirdweb.export.download', 'uses' => 'Ladybirdweb\ImportExport\Export@downloadExportedFile']); |
|
| 32 | 32 | |
| 33 | 33 | }); |
| 34 | 34 | |
| 35 | - Storage::putFileAs('exports', new File( storage_path( 'test/test.csv' ) ), 'test.xls'); |
|
| 35 | + Storage::putFileAs('exports', new File(storage_path('test/test.csv')), 'test.xls'); |
|
| 36 | 36 | |
| 37 | 37 | $this->export = ModelExport::create([ |
| 38 | 38 | 'file' => 'test.xls', |
| 39 | - 'query' => \App\Models\User::select([ 'name', 'email', 'created_at' ])->getModel(), |
|
| 39 | + 'query' => \App\Models\User::select(['name', 'email', 'created_at'])->getModel(), |
|
| 40 | 40 | 'type' => 'xls' |
| 41 | 41 | ]); |
| 42 | 42 | } |
@@ -48,9 +48,9 @@ discard block |
||
| 48 | 48 | { |
| 49 | 49 | Queue::fake(); |
| 50 | 50 | |
| 51 | - $export = Export::export( \App\Models\User::select([ 'name', 'email', 'created_at' ]), 'xls' ); |
|
| 51 | + $export = Export::export(\App\Models\User::select(['name', 'email', 'created_at']), 'xls'); |
|
| 52 | 52 | |
| 53 | - $this->assertInstanceOf( ModelExport::class, $export ); |
|
| 53 | + $this->assertInstanceOf(ModelExport::class, $export); |
|
| 54 | 54 | |
| 55 | 55 | Queue::assertPushedOn('exporting', ExportJob::class); |
| 56 | 56 | } |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | */ |
| 61 | 61 | public function see_export_progress_page() |
| 62 | 62 | { |
| 63 | - $response = $this->get('/ticket/export/' . $this->export->id); |
|
| 63 | + $response = $this->get('/ticket/export/'.$this->export->id); |
|
| 64 | 64 | |
| 65 | 65 | $response->assertStatus(200); |
| 66 | 66 | |
@@ -72,13 +72,13 @@ discard block |
||
| 72 | 72 | */ |
| 73 | 73 | public function check_export_progress_ajax() |
| 74 | 74 | { |
| 75 | - $response = $this->json( 'GET', '/export/' . $this->export->id . '/progress'); |
|
| 75 | + $response = $this->json('GET', '/export/'.$this->export->id.'/progress'); |
|
| 76 | 76 | |
| 77 | 77 | $response->assertStatus(200); |
| 78 | 78 | |
| 79 | - $response->assertJsonFragment( ['status' => 200] ); |
|
| 79 | + $response->assertJsonFragment(['status' => 200]); |
|
| 80 | 80 | |
| 81 | - $response->assertJsonFragment( ['progress'] ); |
|
| 81 | + $response->assertJsonFragment(['progress']); |
|
| 82 | 82 | } |
| 83 | 83 | |
| 84 | 84 | /** |
@@ -86,9 +86,9 @@ discard block |
||
| 86 | 86 | */ |
| 87 | 87 | public function try_download_exported_file() |
| 88 | 88 | { |
| 89 | - $response = $this->get('/export/' . $this->export->id . '/download'); |
|
| 89 | + $response = $this->get('/export/'.$this->export->id.'/download'); |
|
| 90 | 90 | |
| 91 | - $response->assertHeader( 'content-disposition', 'attachment; filename="test.xls"'); |
|
| 91 | + $response->assertHeader('content-disposition', 'attachment; filename="test.xls"'); |
|
| 92 | 92 | |
| 93 | 93 | $response->assertStatus(200); |
| 94 | 94 | } |
@@ -98,7 +98,7 @@ discard block |
||
| 98 | 98 | */ |
| 99 | 99 | public function fail_download_exported_file() |
| 100 | 100 | { |
| 101 | - $response = $this->get('/export/' . rand(1, 100) . '/download'); |
|
| 101 | + $response = $this->get('/export/'.rand(1, 100).'/download'); |
|
| 102 | 102 | |
| 103 | 103 | $response->assertStatus(404); |
| 104 | 104 | } |
@@ -15,14 +15,14 @@ discard block |
||
| 15 | 15 | |
| 16 | 16 | protected $import; |
| 17 | 17 | |
| 18 | - protected function setUp () |
|
| 18 | + protected function setUp() |
|
| 19 | 19 | { |
| 20 | 20 | parent::setUp(); |
| 21 | 21 | |
| 22 | 22 | $this->import = Import::create([ |
| 23 | 23 | 'file' => 'imports/import-1530262997.csv', |
| 24 | 24 | 'file_rows' => 104, |
| 25 | - 'db_cols' => [ 'name', 'email', 'password'], |
|
| 25 | + 'db_cols' => ['name', 'email', 'password'], |
|
| 26 | 26 | 'model_map' => ['email', 'name', 'password'] |
| 27 | 27 | ]); |
| 28 | 28 | } |
@@ -34,9 +34,9 @@ discard block |
||
| 34 | 34 | { |
| 35 | 35 | $import = $this->import; |
| 36 | 36 | |
| 37 | - $result = ImportExportLog::logImportError( $import, ['data' => 'this is test data'], 'This is not expected' ); |
|
| 37 | + $result = ImportExportLog::logImportError($import, ['data' => 'this is test data'], 'This is not expected'); |
|
| 38 | 38 | |
| 39 | - $this->assertInstanceOf( ModelImportExportLog::class, $result ); |
|
| 39 | + $this->assertInstanceOf(ModelImportExportLog::class, $result); |
|
| 40 | 40 | } |
| 41 | 41 | |
| 42 | 42 | /** |
@@ -46,14 +46,14 @@ discard block |
||
| 46 | 46 | { |
| 47 | 47 | $import = $this->import; |
| 48 | 48 | |
| 49 | - $log = ImportExportLog::logImportError( $import, ['data' => 'this is test data'], 'This is not expected' ); |
|
| 49 | + $log = ImportExportLog::logImportError($import, ['data' => 'this is test data'], 'This is not expected'); |
|
| 50 | 50 | |
| 51 | - $log_in_db = ImportExportLog::getLogs( $log->id ); |
|
| 51 | + $log_in_db = ImportExportLog::getLogs($log->id); |
|
| 52 | 52 | |
| 53 | - $this->assertInternalType( 'array', $log_in_db ); |
|
| 53 | + $this->assertInternalType('array', $log_in_db); |
|
| 54 | 54 | |
| 55 | - $this->assertArrayHasKey( 'data', $log_in_db[0] ); |
|
| 55 | + $this->assertArrayHasKey('data', $log_in_db[0]); |
|
| 56 | 56 | |
| 57 | - $this->assertArrayHasKey( 'message', $log_in_db[0] ); |
|
| 57 | + $this->assertArrayHasKey('message', $log_in_db[0]); |
|
| 58 | 58 | } |
| 59 | 59 | } |
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | */ |
| 17 | 17 | public function import() |
| 18 | 18 | { |
| 19 | - return $this->belongsTo( \Ladybirdweb\ImportExport\Models\Import::class ); |
|
| 19 | + return $this->belongsTo(\Ladybirdweb\ImportExport\Models\Import::class); |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | |
@@ -29,7 +29,7 @@ discard block |
||
| 29 | 29 | */ |
| 30 | 30 | public function getDataAttribute($value) |
| 31 | 31 | { |
| 32 | - return unserialize( $value ); |
|
| 32 | + return unserialize($value); |
|
| 33 | 33 | } |
| 34 | 34 | |
| 35 | 35 | |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | */ |
| 43 | 43 | public function setDataAttribute($value) |
| 44 | 44 | { |
| 45 | - $this->attributes['data'] = serialize( $value ); |
|
| 45 | + $this->attributes['data'] = serialize($value); |
|
| 46 | 46 | } |
| 47 | 47 | |
| 48 | 48 | |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | */ |
| 56 | 56 | public function getMessageAttribute($value) |
| 57 | 57 | { |
| 58 | - return unserialize( $value ); |
|
| 58 | + return unserialize($value); |
|
| 59 | 59 | } |
| 60 | 60 | |
| 61 | 61 | |
@@ -68,6 +68,6 @@ discard block |
||
| 68 | 68 | */ |
| 69 | 69 | public function setMessageAttribute($value) |
| 70 | 70 | { |
| 71 | - $this->attributes['message'] = serialize( $value ); |
|
| 71 | + $this->attributes['message'] = serialize($value); |
|
| 72 | 72 | } |
| 73 | 73 | } |
@@ -6,7 +6,7 @@ discard block |
||
| 6 | 6 | |
| 7 | 7 | class Export extends Model |
| 8 | 8 | { |
| 9 | - protected $fillable = [ 'file', 'type', 'query', 'result_rows']; |
|
| 9 | + protected $fillable = ['file', 'type', 'query', 'result_rows']; |
|
| 10 | 10 | |
| 11 | 11 | /** |
| 12 | 12 | * Query accessor |
@@ -17,7 +17,7 @@ discard block |
||
| 17 | 17 | */ |
| 18 | 18 | public function getQueryAttribute($value) |
| 19 | 19 | { |
| 20 | - return unserialize( $value ); |
|
| 20 | + return unserialize($value); |
|
| 21 | 21 | } |
| 22 | 22 | |
| 23 | 23 | |
@@ -30,6 +30,6 @@ discard block |
||
| 30 | 30 | */ |
| 31 | 31 | public function setQueryAttribute($value) |
| 32 | 32 | { |
| 33 | - $this->attributes['query'] = serialize( $value ); |
|
| 33 | + $this->attributes['query'] = serialize($value); |
|
| 34 | 34 | } |
| 35 | 35 | } |
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | */ |
| 17 | 17 | public function importLogs() |
| 18 | 18 | { |
| 19 | - return $this->hasMany( \Ladybirdweb\ImportExport\Models\ImportExportLog::class, 'op_id' ); |
|
| 19 | + return $this->hasMany(\Ladybirdweb\ImportExport\Models\ImportExportLog::class, 'op_id'); |
|
| 20 | 20 | } |
| 21 | 21 | |
| 22 | 22 | |
@@ -29,7 +29,7 @@ discard block |
||
| 29 | 29 | */ |
| 30 | 30 | public function getModelMapAttribute($value) |
| 31 | 31 | { |
| 32 | - return unserialize( $value ); |
|
| 32 | + return unserialize($value); |
|
| 33 | 33 | } |
| 34 | 34 | |
| 35 | 35 | |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | */ |
| 43 | 43 | public function setModelMapAttribute($value) |
| 44 | 44 | { |
| 45 | - $this->attributes['model_map'] = serialize( $value ); |
|
| 45 | + $this->attributes['model_map'] = serialize($value); |
|
| 46 | 46 | } |
| 47 | 47 | |
| 48 | 48 | |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | */ |
| 56 | 56 | public function getDbColsAttribute($value) |
| 57 | 57 | { |
| 58 | - return unserialize( $value ); |
|
| 58 | + return unserialize($value); |
|
| 59 | 59 | } |
| 60 | 60 | |
| 61 | 61 | |
@@ -68,6 +68,6 @@ discard block |
||
| 68 | 68 | */ |
| 69 | 69 | public function setDbColsAttribute($value) |
| 70 | 70 | { |
| 71 | - $this->attributes['db_cols'] = serialize( $value ); |
|
| 71 | + $this->attributes['db_cols'] = serialize($value); |
|
| 72 | 72 | } |
| 73 | 73 | } |