ldc-crm/app/Models/Question.php

127 lines
3.3 KiB
PHP
Raw Permalink Normal View History

2021-08-10 12:09:49 +02:00
<?php
namespace App\Models;
use App\Enums\QuestionType;
2023-10-06 15:00:42 +02:00
use App\Traits\Models\ActivityLog;
2021-08-10 12:09:49 +02:00
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
2025-08-04 14:50:03 +02:00
use Illuminate\Support\Facades\Cache;
2021-08-10 12:09:49 +02:00
/**
* @property integer $id Id.
* @property integer $brand_id Foreign key Brand.
* @property string $question Question.
* @property \App\Enums\QuestionType $type Type de question.
* @property-read \Illuminate\Support\Carbon $created_at Created date.
* @property-read \Illuminate\Support\Carbon $updated_at Updated date.
*
2025-04-17 11:32:43 +02:00
* @property-read \Illuminate\Support\Collection $answers Answer hasMany relation.
* @property-read \App\Models\Brand $brand Brand BelongsTo relation.
*/
2021-08-10 12:09:49 +02:00
class Question extends Model
{
2023-10-06 15:00:42 +02:00
use ActivityLog;
2021-08-10 12:09:49 +02:00
use HasFactory;
Version 3.0.0 This removes api authentification with token in favor of signature method. Refactorize code and clean up. It add more unit test plus code coverage in test/converage. - Added config.api.timestampTimeout - Added Helper::signRequest This calculates the request signature - Added more unit tests and extend code coverage. - Added rate limiter for web routes - Added RemoveSpaces Sanitizer on api requests - Added stress test suite - Changed AuthServiceProvider api-token to api-hmac - Changed CustomerSeeder to have at least of customer activated (for unit tests) - Changed used transation for saveing multiple models - Changed, in ServiceController generateApiToken to generateServicePassword - Changed, timestamp has to be send in request with a DateTime format, it also has to a UTC value - Composer added brianium/paratest - Composer update - Fixed case where removing single optin could be the wrong one (not for the good service) - Fixed customer delete - Fixed customer would not be resolved by brand. - Fixed Really check that request is json checking body content, preventing sending malformed requests - Remove ApiError::needAuth - Removed api_token - Removed ApiController::authenticate - Removed config.api.tokenTimeout - Removed Header check or usage because of HAProxy doing weird stuff - Removed lock files from gitignore - Removed memcached dependency - Removed unused questions resources api routes - Removed workspace file Migrations - Added unique index on services.bearer_token - Changed customer_id on customer_answer is nullable - Changed services.bearer_pwd length to 312 (the size of the token) - Dropped services.api_token and service.api_token_date
2021-12-19 15:57:24 +01:00
/**
* The attributes that are mass assignable.
*
* @var array<int, string>
Version 3.0.0 This removes api authentification with token in favor of signature method. Refactorize code and clean up. It add more unit test plus code coverage in test/converage. - Added config.api.timestampTimeout - Added Helper::signRequest This calculates the request signature - Added more unit tests and extend code coverage. - Added rate limiter for web routes - Added RemoveSpaces Sanitizer on api requests - Added stress test suite - Changed AuthServiceProvider api-token to api-hmac - Changed CustomerSeeder to have at least of customer activated (for unit tests) - Changed used transation for saveing multiple models - Changed, in ServiceController generateApiToken to generateServicePassword - Changed, timestamp has to be send in request with a DateTime format, it also has to a UTC value - Composer added brianium/paratest - Composer update - Fixed case where removing single optin could be the wrong one (not for the good service) - Fixed customer delete - Fixed customer would not be resolved by brand. - Fixed Really check that request is json checking body content, preventing sending malformed requests - Remove ApiError::needAuth - Removed api_token - Removed ApiController::authenticate - Removed config.api.tokenTimeout - Removed Header check or usage because of HAProxy doing weird stuff - Removed lock files from gitignore - Removed memcached dependency - Removed unused questions resources api routes - Removed workspace file Migrations - Added unique index on services.bearer_token - Changed customer_id on customer_answer is nullable - Changed services.bearer_pwd length to 312 (the size of the token) - Dropped services.api_token and service.api_token_date
2021-12-19 15:57:24 +01:00
*/
2021-08-10 12:09:49 +02:00
protected $fillable = [
'question',
'type',
2023-09-04 13:08:34 +02:00
'brand_id',
];
/**
* The attributes that should be cast to native types.
2023-09-04 13:08:34 +02:00
*
* @var array<string, mixed>
2023-09-04 13:08:34 +02:00
*/
protected $casts = [
'type' => QuestionType::class,
2021-08-10 12:09:49 +02:00
];
2025-08-04 14:50:03 +02:00
/**
* Perform any actions required after the model boots.
*
* @return void
*/
protected static function booted(): void
{
static::created(function (self $model) {
self::resetCache($model->getKey());
2025-08-04 14:50:03 +02:00
});
static::updated(function (self $model) {
self::resetCache($model->getKey());
2025-08-04 14:50:03 +02:00
});
static::deleted(function (self $model) {
self::resetCache($model->getKey());
2025-08-04 14:50:03 +02:00
});
}
// * METHODS
/**
* Get all questions associated to the band.
*
* @param integer $brandModelKey
* @return \Illuminate\Database\Eloquent\Collection
*/
public static function getAllModelsFromBrand(int $brandModelKey): \Illuminate\Database\Eloquent\Collection
{
return self::getQuestions()->filter(
fn($model) => $model->brand->getKey() === $brandModelKey
)->values();
}
/**
* Reset all cache elements related to this model.
*
* @param integer $modelKey
2025-08-04 14:50:03 +02:00
* @return void
*/
private static function resetCache(int $modelKey): void
2025-08-04 14:50:03 +02:00
{
Cache::forget('questions');
Cache::forget("question-{$modelKey}-answers");
2025-08-04 14:50:03 +02:00
self::getQuestions();
}
/**
* Get all questions.
*
* @return \Illuminate\Database\Eloquent\Collection
*/
public static function getQuestions(): \Illuminate\Database\Eloquent\Collection
{
return Cache::remember('questions', 86400, function () {
return self::query()->orderBy('question', 'ASC')->get();
});
}
Version 3.0.0 This removes api authentification with token in favor of signature method. Refactorize code and clean up. It add more unit test plus code coverage in test/converage. - Added config.api.timestampTimeout - Added Helper::signRequest This calculates the request signature - Added more unit tests and extend code coverage. - Added rate limiter for web routes - Added RemoveSpaces Sanitizer on api requests - Added stress test suite - Changed AuthServiceProvider api-token to api-hmac - Changed CustomerSeeder to have at least of customer activated (for unit tests) - Changed used transation for saveing multiple models - Changed, in ServiceController generateApiToken to generateServicePassword - Changed, timestamp has to be send in request with a DateTime format, it also has to a UTC value - Composer added brianium/paratest - Composer update - Fixed case where removing single optin could be the wrong one (not for the good service) - Fixed customer delete - Fixed customer would not be resolved by brand. - Fixed Really check that request is json checking body content, preventing sending malformed requests - Remove ApiError::needAuth - Removed api_token - Removed ApiController::authenticate - Removed config.api.tokenTimeout - Removed Header check or usage because of HAProxy doing weird stuff - Removed lock files from gitignore - Removed memcached dependency - Removed unused questions resources api routes - Removed workspace file Migrations - Added unique index on services.bearer_token - Changed customer_id on customer_answer is nullable - Changed services.bearer_pwd length to 312 (the size of the token) - Dropped services.api_token and service.api_token_date
2021-12-19 15:57:24 +01:00
// * RELATIONS
2021-08-10 12:09:49 +02:00
/**
* Brand belongs to relation.
2021-08-10 12:09:49 +02:00
*
* @return \Illuminate\Database\Eloquent\Relations\BelongsTo
*/
public function brand(): \Illuminate\Database\Eloquent\Relations\BelongsTo
2021-08-10 12:09:49 +02:00
{
return $this->belongsTo(Brand::class);
}
/**
* Answer has many relation.
2021-08-10 12:09:49 +02:00
*
* @return \Illuminate\Database\Eloquent\Relations\HasMany
*/
public function answers(): \Illuminate\Database\Eloquent\Relations\HasMany
2021-08-10 12:09:49 +02:00
{
return $this->hasMany(Answer::class);
}
}