*/ final class NewsArticleMapper extends DataMapperFactory { /** * Columns. * * @var array * @since 1.0.0 */ public const COLUMNS = [ 'news_id' => ['name' => 'news_id', 'type' => 'int', 'internal' => 'id'], 'news_publish' => ['name' => 'news_publish', 'type' => 'DateTime', 'internal' => 'publish'], 'news_title' => ['name' => 'news_title', 'type' => 'string', 'internal' => 'title'], 'news_plain' => ['name' => 'news_plain', 'type' => 'string', 'internal' => 'plain'], 'news_content' => ['name' => 'news_content', 'type' => 'string', 'internal' => 'content'], 'news_lang' => ['name' => 'news_lang', 'type' => 'string', 'internal' => 'language'], 'news_status' => ['name' => 'news_status', 'type' => 'int', 'internal' => 'status'], 'news_type' => ['name' => 'news_type', 'type' => 'int', 'internal' => 'type'], 'news_featured' => ['name' => 'news_featured', 'type' => 'bool', 'internal' => 'isFeatured'], 'news_comment_list' => ['name' => 'news_comment_list', 'type' => 'int', 'internal' => 'comments'], 'news_unit' => ['name' => 'news_unit', 'type' => 'int', 'internal' => 'unit'], 'news_app' => ['name' => 'news_app', 'type' => 'int', 'internal' => 'app'], 'news_created_at' => ['name' => 'news_created_at', 'type' => 'DateTimeImmutable', 'internal' => 'createdAt', 'readonly' => true], 'news_created_by' => ['name' => 'news_created_by', 'type' => 'int', 'internal' => 'createdBy', 'readonly' => true], ]; /** * Has one relation. * * @var array * @since 1.0.0 */ public const OWNS_ONE = [ 'comments' => [ 'mapper' => CommentListMapper::class, 'external' => 'news_comment_list', ], ]; /** * Belongs to. * * @var array * @since 1.0.0 */ public const BELONGS_TO = [ 'createdBy' => [ 'mapper' => AccountMapper::class, 'external' => 'news_created_by', ], ]; /** * Has many relation. * * @var array * @since 1.0.0 */ public const HAS_MANY = [ 'tags' => [ 'mapper' => TagMapper::class, 'table' => 'news_tag', 'self' => 'news_tag_dst', 'external' => 'news_tag_src', ], 'files' => [ 'mapper' => MediaMapper::class, 'table' => 'news_media', 'external' => 'news_media_dst', 'self' => 'news_media_src', ], ]; /** * Primary table. * * @var string * @since 1.0.0 */ public const TABLE = 'news'; /** * Primary field name. * * @var string * @since 1.0.0 */ public const PRIMARYFIELD = 'news_id'; }