belongsTo( 'App\User', 'user_id', 'id' );
}
public function getSaleStatusAttribute() {
//1 - đang diễn ra
// 0 - đã kết thúc
// 2 - sắp diễn ra
if ( ! empty( $this->start_date ) && empty( $this->end_date ) ) {
if ( Carbon::now()->greaterThanOrEqualTo( $this->start_date->startOfDay() ) ) {
return self::SALE_ONGOING;
} else {
return self::SALE_SOON;
}
}
if ( empty( $this->start_date ) && ! empty( $this->end_date ) ) {
if ( Carbon::now()->lessThanOrEqualTo( $this->end_date->endOfDay() ) ) {
return self::SALE_ONGOING;
} else {
return self::SALE_END;
}
}
if ( ! empty( $this->start_date ) && ! empty( $this->end_date ) ) {
if ( Carbon::now()->lessThanOrEqualTo( $this->end_date->endOfDay() ) && Carbon::now()->greaterThanOrEqualTo( $this->start_date->startOfDay() ) ) {
return self::SALE_ONGOING;
}
if ( Carbon::now()->lessThan( $this->start_date->startOfDay() ) ) {
return self::SALE_SOON;
} else {
return self::SALE_END;
}
}
return self::SALE_NO_TIME;
}
public function getStatusTextAttribute() {
$type = $this->attributes['status'];
if ( $type == true ) {
return '';
} else if ( $type == false ) {
return '';
}
return 'Chưa rõ';
}
public function getCategoryFirstAttribute() {
$id = $this->attributes['id'];
$cats = \DB::table( 'blog_categories' )->join( 'categories', 'blog_categories.category_id', '=', 'categories.id' )
->where( 'blog_categories.blog_id', $id )->first();
if ( ! empty( $cats ) ) {
return $cats;
}
return null;
}
public function getCategoriesTextAttribute() {
$id = $this->attributes['id'];
$cats = \DB::table( 'blog_categories' )->join( 'categories', 'blog_categories.category_id', '=', 'categories.id' )
->where( 'blog_categories.blog_id', $id )->pluck( 'categories.name' )->toArray();
$cnt = count( $cats );
if ( $cnt == 1 ) {
return $cats[0];
} else if ( $cnt < 1 ) {
return '';
} else {
$message = '';
foreach ( $cats as $cat ) {
$message .= $cat . ', ';
}
$message = rtrim( $message, ', ' );
return $message;
}
}
public function getImageTextAttribute() {
$item = $this->attributes['image'];
if ( ! empty( $item ) ) {
return '
';
}
return '
';
}
public function getImageUrlAttribute() {
$item = $this->attributes['image'];
if ( ! empty( $item ) ) {
return '/files/' . $item;
}
return '/frontend3/assets/img/placeholder.png';
}
public function scopePublish( $q ) {
$q->where( 'status', true );
}
public function scopeFeatured( $q ) {
$q->where( 'is_featured', true );
}
}