Skip to main content

Posts

Showing posts from March, 2021

Laravel Request Validator json response example

 Step 1 :  php artisan make : request  StoreArticleRequest Step 2 : <?php namespace App\Http\Requests; use Illuminate\Foundation\Http\FormRequest; use Illuminate\Http\JsonResponse; use Illuminate\Contracts\Validation\Validator; use Illuminate\Http\Exceptions\HttpResponseException; class StoreArticleRequest extends FormRequest { /** * Determine if the user is authorized to make this request. * * @return bool */ public function authorize () { return true ; } /** * Get the validation rules that apply to the request. * * @return array */ public function rules () { return [ 'title' => 'required' ]; } protected function failedValidation (Validator $validator ) { if ($this -> wantsJson () || $this -> ajax ()) { throw new HttpResponseException( response () -> json ([ 'status' => '

followers with following flag

$followers=DB::table('user_followers as f')->join('users as u', 'u.id', '=', 'f.follower_id')             ->leftJoin('user_followers AS b', function($join){                 $join->on('b.follower_id', '=', 'f.leader_id')                      ->on('b.leader_id', '=', 'u.id');             })             ->selectRaw(DB::raw("u.user_id,u.full_name,u.username,u.avatar,             case when b.follower_id is null then 0                 when b.follower_id is not null and  b.status=1 then 1             else 2             end as isFollowing,             case when b.follower_id is null then 'Follow'                 when b.follower_id is not null and  b.status=1 then 'Pending'             else 'Following'             end as isFollowing             "))             ->where("f.leader_id",$authUserId)