openinfra
/
openstackid-resources
Code Issues Proposed changes

added export event types csv 

GET /api/v1/summits/{id}/event-types/csv

Change-Id: I0f62c4d18d19c7a6777183f925f380e04558747a
This commit is contained in:
Sebastian Marcet 2018-02-20 14:13:43 -03:00
parent 51b5ab7b63
commit d5a5a651fd
9 changed files with 193 additions and 24 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

19
app/Http/Controllers/Apis/Protected/Summit/EventTypeValidationRulesFactory.php
View File

@ -63,15 +63,16 @@ final class EventTypeValidationRulesFactory
case PresentationType::ClassName:
{
$specific_rules = [
'use_speakers' => 'sometimes|boolean',
'are_speakers_mandatory' => 'sometimes|boolean|required_with:use_speakers',
'min_speakers' => 'sometimes|integer|required_with:use_speakers',
'max_speakers' => 'sometimes|integer|required_with:use_speakers|greater_than_field:max_speakers',
'use_moderator' => 'sometimes|boolean',
'is_moderator_mandatory' => 'sometimes|boolean|required_with:use_moderator',
'min_moderators' => 'sometimes|integer|required_with:use_moderator',
'max_moderators' => 'sometimes|integer|required_with:use_moderator|greater_than_field:min_moderators',
'moderator_label' => 'sometimes|string'
'use_speakers' => 'sometimes|boolean',
'are_speakers_mandatory' => 'sometimes|boolean|required_with:use_speakers',
'min_speakers' => 'sometimes|integer|required_with:use_speakers',
'max_speakers' => 'sometimes|integer|required_with:use_speakers|greater_than_field:max_speakers',
'use_moderator' => 'sometimes|boolean',
'is_moderator_mandatory' => 'sometimes|boolean|required_with:use_moderator',
'min_moderators' => 'sometimes|integer|required_with:use_moderator',
'max_moderators' => 'sometimes|integer|required_with:use_moderator|greater_than_field:min_moderators',
'should_be_available_on_cfp' => 'sometimes|boolean',
'moderator_label' => 'sometimes|string'
];
}
break;

2
app/Http/Controllers/Apis/Protected/Summit/OAuth2SummitPromoCodesApiController.php
View File

@ -236,7 +236,7 @@ final class OAuth2SummitPromoCodesApiController extends OAuth2ProtectedControlle
public function getAllBySummitCSV($summit_id){
$values = Input::all();
$rules = [
];
];
try {

122
app/Http/Controllers/Apis/Protected/Summit/OAuth2SummitsEventTypesApiController.php
View File

@ -11,6 +11,8 @@
* See the License for the specific language governing permissions and
* limitations under the License.
**/
use App\Http\Utils\BooleanCellFormatter;
use App\Http\Utils\EpochCellFormatter;
use App\Services\Model\ISummitEventTypeService;
use Illuminate\Support\Facades\Request;
use App\Models\Foundation\Summit\Events\SummitEventTypeConstants;
@ -73,6 +75,7 @@ final class OAuth2SummitsEventTypesApiController extends OAuth2ProtectedControll
}
return $valid;
}
/**
* @param $summit_id
* @return mixed
@ -182,6 +185,125 @@ final class OAuth2SummitsEventTypesApiController extends OAuth2ProtectedControll
}
}
/**
* @param $summit_id
* @return mixed
*/
public function getAllBySummitCSV($summit_id){
$values = Input::all();
$rules = [
];
try {
$summit = SummitFinderStrategyFactory::build($this->summit_repository, $this->resource_server_context)->find($summit_id);
if (is_null($summit)) return $this->error404();
$validation = Validator::make($values, $rules);
if ($validation->fails()) {
$ex = new ValidationException();
throw $ex->setMessages($validation->messages()->toArray());
}
// default values
$page = 1;
$per_page = PHP_INT_MAX;
if (Input::has('page')) {
$page = intval(Input::get('page'));
$per_page = intval(Input::get('per_page'));
}
$filter = null;
if (Input::has('filter')) {
$filter = FilterParser::parse(Input::get('filter'), [
'name' => ['=@', '=='],
'class_name' => ['=='],
'is_default' => ['=='],
'black_out_times' => ['=='],
'use_sponsors' => ['=='],
'are_sponsors_mandatory' => ['=='],
'allows_attachment' => ['=='],
'use_speakers' => ['=='],
'are_speakers_mandatory' => ['=='],
'use_moderator' => ['=='],
'is_moderator_mandatory' => ['=='],
'should_be_available_on_cfp' => ['=='],
]);
}
$order = null;
if (Input::has('order'))
{
$order = OrderParser::parse(Input::get('order'), [
'id',
'name',
]);
}
if(is_null($filter)) $filter = new Filter();
if($filter->hasFilter("class_name") && !$this->validateClassName($filter->getFilter("class_name"))){
throw new ValidationException(
sprintf
(
"class_name filter has an invalid value ( valid values are %s",
implode(", ", SummitEventTypeConstants::$valid_class_names)
)
);
}
$data = $this->repository->getBySummit($summit, new PagingInfo($page, $per_page), $filter, $order);
$filename = "event-types-" . date('Ymd');
$list = $data->toArray();
return $this->export
(
'csv',
$filename,
$list['data'],
[
'created' => new EpochCellFormatter,
'last_edited' => new EpochCellFormatter,
'is_default' => new BooleanCellFormatter,
'black_out_times' => new BooleanCellFormatter,
'use_sponsors' => new BooleanCellFormatter,
'are_sponsors_mandatory' => new BooleanCellFormatter,
'allows_attachment' => new BooleanCellFormatter,
'use_speakers' => new BooleanCellFormatter,
'are_speakers_mandatory' => new BooleanCellFormatter,
'use_moderator' => new BooleanCellFormatter,
'is_moderator_mandatory' => new BooleanCellFormatter,
'should_be_available_on_cfp' => new BooleanCellFormatter,
]
);
}
catch (ValidationException $ex1)
{
Log::warning($ex1);
return $this->error412(array( $ex1->getMessage()));
}
catch (EntityNotFoundException $ex2)
{
Log::warning($ex2);
return $this->error404(array('message' => $ex2->getMessage()));
}
catch(\HTTP401UnauthorizedException $ex3)
{
Log::warning($ex3);
return $this->error401();
}
catch (Exception $ex) {
Log::error($ex);
return $this->error500($ex);
}
}
/**
* @param $summit_id
* @return mixed

1
app/Http/routes.php
View File

@ -295,6 +295,7 @@ Route::group([
// event types
Route::group(['prefix' => 'event-types'], function () {
Route::get('', 'OAuth2SummitsEventTypesApiController@getAllBySummit');
Route::get('csv', 'OAuth2SummitsEventTypesApiController@getAllBySummitCSV');
Route::post('', [ 'middleware' => 'auth.user:administrators|summit-front-end-administrators', 'uses' => 'OAuth2SummitsEventTypesApiController@addEventTypeBySummit']);
Route::group(['prefix' => '{event_type_id}'], function () {
Route::put('', [ 'middleware' => 'auth.user:administrators|summit-front-end-administrators', 'uses' => 'OAuth2SummitsEventTypesApiController@updateEventTypeBySummit']);

21
app/ModelSerializers/Summit/Presentation/PresentationTypeSerializer.php
View File

@ -16,19 +16,20 @@
* Class PresentationEventTypeSerializer
* @package ModelSerializers
*/
class PresentationTypeSerializer extends SummitEventTypeSerializer
final class PresentationTypeSerializer extends SummitEventTypeSerializer
{
protected static $array_mappings = [
'MaxSpeakers' => 'max_speakers:json_int',
'MinSpeakers' => 'min_speakers:json_int',
'MaxModerators' => 'max_moderators:json_int',
'MinModerators' => 'min_moderators:json_int',
'UseSpeakers' => 'use_speakers:json_boolean',
'AreSpeakersMandatory' => 'are_speakers_mandatory:json_boolean',
'UseModerator' => 'use_moderator:json_boolean',
'ModeratorMandatory' => 'is_moderator_mandatory:json_boolean',
'ModeratorLabel' => 'moderator_label:json_string',
'MaxSpeakers' => 'max_speakers:json_int',
'MinSpeakers' => 'min_speakers:json_int',
'MaxModerators' => 'max_moderators:json_int',
'MinModerators' => 'min_moderators:json_int',
'UseSpeakers' => 'use_speakers:json_boolean',
'AreSpeakersMandatory' => 'are_speakers_mandatory:json_boolean',
'UseModerator' => 'use_moderator:json_boolean',
'ModeratorMandatory' => 'is_moderator_mandatory:json_boolean',
'ModeratorLabel' => 'moderator_label:json_string',
'isShouldBeAvailableOnCfp' => 'should_be_available_on_cfp:json_boolean',
];
/**

9
app/Models/Foundation/Summit/Events/Presentations/PresentationType.php
View File

@ -285,9 +285,10 @@ SQL;
public function __construct()
{
parent::__construct();
$this->are_speakers_mandatory = false;
$this->use_speakers = false;
$this->use_moderator = false;
$this->is_moderator_mandatory = false;
$this->are_speakers_mandatory = false;
$this->use_speakers = false;
$this->use_moderator = false;
$this->is_moderator_mandatory = false;
$this->should_be_available_on_cfp = false;
}
}

4
app/Models/Foundation/Summit/Factories/SummitEventTypeFactory.php
View File

@ -90,6 +90,10 @@ final class SummitEventTypeFactory
if(isset($data['moderator_label'])) {
$event_type->setModeratorLabel(trim($data['moderator_label']));
}
if(isset($data['should_be_available_on_cfp'])) {
$event_type->setShouldBeAvailableOnCfp(boolval($data['should_be_available_on_cfp']));
}
}
}
break;

9
database/seeds/ApiEndpointsSeeder.php
View File

@ -546,6 +546,15 @@ class ApiEndpointsSeeder extends Seeder
sprintf(SummitScopes::ReadAllSummitData, $current_realm)
],
],
[
'name' => 'get-event-types-csv',
'route' => '/api/v1/summits/{id}/event-types/csv',
'http_method' => 'GET',
'scopes' => [
sprintf(SummitScopes::ReadSummitData, $current_realm),
sprintf(SummitScopes::ReadAllSummitData, $current_realm)
],
],
[
'name' => 'add-event-type',
'route' => '/api/v1/summits/{id}/event-types',

30
tests/OAuth2EventTypesApiTest.php
View File

@ -49,6 +49,36 @@ final class OAuth2EventTypesApiTest extends ProtectedApiTest
return $event_types;
}
public function testGetEventTypesByClassNameCSV(){
$params = [
'id' => 23,
'page' => 1,
'per_page' => 10,
'filter' => 'class_name==EVENT_TYPE',
'order' => '+name'
];
$headers = [
"HTTP_Authorization" => " Bearer " . $this->access_token,
"CONTENT_TYPE" => "application/json"
];
$response = $this->action(
"GET",
"OAuth2SummitsEventTypesApiController@getAllBySummitCSV",
$params,
[],
[],
[],
$headers
);
$csv = $response->getContent();
$this->assertResponseStatus(200);
$this->assertTrue(!empty($csv));
}
public function testGetEventTypesDefaultOnes(){
$params = [