?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
use Mail;
use App\Mail\FollowerUpdateMail;
use Request;
use App\Services\ContentModerationService;
class Updates extends Model {
protected $guarded = array();
public $timestamps = false;
protected static function booted()
{
static::creating(function ($post) {
if (!empty($post->content)) {
$moderation = new ContentModerationService();
$result = $moderation->check($post->content);
if ($result['blocked']) {
// Puedes cambiar esto por status = review si prefieres
throw new \Exception(
"Content blocked due to prohibited term: " . $result['word']
);
}
}
});
}
public function getUser()
{
return $this->belongsTo(User::class, 'user_id');
}
public function getTotalPost($start_date, $end_date)
{
return Updates::whereDate('date', '=', $start_date)->count();
// return self::whereRaw('DATE(date) BETWEEN ? AND ?', [$start_date, $end_date])->count();
}
public function user() {
return $this->belongsTo('App\Models\User')->first();
}
public function media() {
return $this->hasMany('App\Models\Media')->where('status', 'active')->orderBy('id','asc');
}
public function likes() {
return $this->hasMany('App\Models\Like')->where('status', '1');
}
public function comments() {
return $this->hasMany('App\Models\Comments');
}
public function bookmarks() {
return $this->belongsToMany('App\Models\User', 'bookmarks','updates_id','user_id');
}
static public function getGiftUserCount($gift_user_id, $user_id)
{
return UserGiftModel::countUser($gift_user_id, $user_id);
}
public function getProfile()
{
return $this->hasMany('App\Models\UpdatesProfile', 'update_id')
->join('users','users.id', '=', 'updates_profile.user_id')
->limit(2);
}
static public function getTodayCreatedPost()
{
$return = Updates::select('updates.*')
->join('users', 'users.id', '=', 'updates.user_id');
if(!empty(Request::get('gender_id')))
{
$return = $return->where('users.gender', '=', Request::get('gender_id'));
}
if(!empty(Request::get('category_id')))
{
$return = $return->where('users.categories_id', 'like', '%'.Request::get('category_id').'%');
}
if(!empty(Request::get('country_id')))
{
$return = $return->where('users.countries_id', '=', Request::get('country_id'));
}
$return = $return->whereDate('updates.date', '=', date('Y-m-d'))
->groupBy('updates.user_id')
->orderBy('updates.id', 'desc')
->get();
return $return;
}
static public function SendFollowesEmail($id)
{
$getPost = Updates::find($id);
if(!empty($getPost))
{
$MyFollow = FollowerModel::MyFollowAllUser($getPost->user_id);
foreach ($MyFollow as $value)
{
if(!empty($value->FollowingUser) && !empty($value->FollowingUser->email))
{
try {
Mail::to($value->FollowingUser->email)
->send(new FollowerUpdateMail($value->FollowingUser, $getPost));
} catch (\Exception $e) {
}
}
}
}
}
}
Error 500