ethar

@maaz thx, but noti_to is field in db

i try to do this but not working

            ->when('noti_to',3,function ($q) use ($user_id){
                $q->orWhere('user_id',$user_id);
            })

i have notification table, (id, txt, noti_to, user_id)

i want to get notifications if(noti_to=1, noti_to=2, but if noti_to=3 i want to select where user_id=$id);

    public function notifications($user_id,$gender){
        return showNotificationResource::collection(Notification::select(
            'id',
            'title',
            'body',
            'created_at'
        ))
            ->where('noti_to',1)
            ->orWhere('noti_to',$gender)
            ->orWhere('noti_to', 3)// if noti_to=3, how to add where('user_id',$user_id)
            ->get();
    }

how to add where('user_id',$user_id) if noti_to=3

i try to get articles, and some articles have dublicated title i want to groub by title

        $articles=Article::select(
            'id',
            'img',
            'created_at',
            'title_ar',
        )->groupBy('title_ar')->limit(6)->get();

but i got this error

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mhpss.articles.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select `id`, `img`, `created_at`, `title_ar` from `articles` group by `title_ar` limit 6)

i have author table, books table, and pivot table author_book. data saved successfully and displayed successfully.

but in edit i want to get all books and if author have spesific book must marked as checked

i try this code but not work

//eloquent
        $author=Author::with('Books')->findOrFail(1);
        $books=Book::select('id','name')->get();
        return view('author',compact('author','books'));

//blade

@foreach($books as $book)
       <div class="form-check">
          <input  type="checkbox" {{ in_array($author->books->id,$book->id) ? "checked" : "" }} value="{{ $book->id }}" >
          <label >{{ $book->name }}</label>
      </div>
@endforeach

how can add some data after paragraph number n in laravel blade

thaks

no i want to open url in sendMsg function without using return

i use this way to open external url and send msg

    public function sendMsg($dialCode, $phone, $pin)
    {
        $to_phone_number = $dialCode . $phone; // who are you sending to?
        $url = "http://sms.htd.ps/API/SendSMS&to=".$to_phone_number."&msg=Your Code is $pin";
        return Redirect::intended($url);
    }

i want to open url without using return cause i want to go to next step

if ($user) {
        $this->sendMsg($request->country_dial_code, $request->phone, $user->pin_code);
        return new showUserResource($user);
 }

no i got last 3 books for last author, not last 3 book for every author

->latest

cant determinant number of books, it get all books

i have authors table, and books table every author have many books

i want to get authors with last 3 book add

i try this but i got books for last author

    public function index(){
        $authors=Author::with(['book' => function ($q) {
            $q->select('id', 'author_id','title')
                ->orderby('id', 'DESC')->take(3);
        }])->get();
        return $authors;
    }

relation ship

    public function book(){
        return $this->hasMany('App\Models\Book','author_id');
    }

i use filepond to upload file

field name is avatar

file uploaded successfully

but when send data to the controller and make dd($request->avatar)

i got this data , so i cant reach file name

""" Picture.png<script t ▶

Sfdump = window.Sfdump || (function (doc) { var refStyle = doc.createElement('style'), rxEsc = /([.*+?^${}()|\[\]\/\\])/g, idRx = /\bsf-dump-\d+-ref[01 ▶ but when make return $request->avatar i get file name Picture.png

solved after run

Artisan::call('route:clear');

but how can i make a cache route in shared host

@automica nothing exist , empty file

i run this command on my shared Host

    public function cacheControll(){
        Artisan::call('cache:clear');
        Artisan::call('config:clear');
        Artisan::call('config:cache');
        Artisan::call('view:clear');
        Artisan::call('route:clear');
        Artisan::call('route:cache');
        return 'done';
    }

but after run it all routes not work, but redirect me to 404 error page.

no its not working

@michaloravec your are correct, but why subquery not working

i try to get users order by phone number, the problem is (asc,desc) not working but get the same order

the relation is hasOne

        $users=User::query()
            ->orderBy(Phone::select('phone')
                ->whereColumn('user_id','users.id')
                ->orderBy('phone','DESC')
                ->take(1)
            )
            ->with('phone')
            ->get();

please how can make cache for this code

View::composer(['front.index','front.history'],function($view){
            $view->with('education',Education::select(
                'title_' . LaravelLocalization::setLocale() . ' as title',
                'tags_' . LaravelLocalization::setLocale() . ' as tags',
                'text_' . LaravelLocalization::setLocale() . ' as text',
                'from_date',
                'to_date'
            )->where('active',1)->get());
        });

thanks @michaloravec can you help me to cache composer

        View::composer(['front.index','front.history'],function($view){
            $view->with('education',Education::select(
                'title_' . LaravelLocalization::setLocale() . ' as title',
                'tags_' . LaravelLocalization::setLocale() . ' as tags',
                'text_' . LaravelLocalization::setLocale() . ' as text',
                'from_date',
                'to_date'
            )->where('active',1)->get());
        });

i have this share in appServiceProvider.php

View::share('settings', Settings::select( '' . $name_site . ' as site_name', ''.$desc_site.' as site_desc', ''.$keyword.' as site_keyword')->first());

how can make cache?

hi i try to cache data,

        $snipp = cache()->remember('single_snipp',60 * 60 *60,function (){
            return Snippet::select(
                'text_' . LaravelLocalization::setLocale() . ' as text',
            )->where('id',$id)
                ->firstOrFail();
        });

but i got an error cause i must pass $id to where, how can i pass id?

i have field named arrive_location arrive location have just two value (exist, new)

in eloquent

        $orders = Orders::select('id', 'users_id', 'arrive_location')
            ->with('users:id,fname,lname,telno')

i want if arrive_location == new, to make another query to get data

UserOrderArriveAddress::select('order_id','addresse_id');

thx @charizard

i receive a POST Request from another website, but the problem in CSRF Token, I exception in VerifyCsrfToken but not work

class VerifyCsrfToken extends BaseVerifier
{
    /**
     * The URIs that should be excluded from CSRF verification.
     *
     * @var array
     */
    protected $except = [
        'responseCredit'
    ];
}

responseCard is a function/URL where I must read post data

any help

@bugsysha thanx solved

    <form method="post" name="paymentForm" id="paymentForm" action="{{ $actionTo }}">
        <input type="hidden" name="Version" value="{{ $version }}"><br>
        <input type="hidden" name="MerID" value="{{ $merchantId }}"><br>
    </form>
    <script type="text/javascript">
                document.forms["paymentForm"].submit();
    </script>

@bugsysha Thanks It must be redirected me to the payment page with form input values,

your way not working

i want to auto submit form when visit page, but the following code is not working, plz any help

<form method="post" onload="autoSubmit();" name="paymentForm" id="paymentForm" action="{{ $actionTo }}">
        <input type="hidden" name="Version" value="{{ $version }}"><br>
        <input type="hidden" name="MerID" value="{{ $merchantId }}"><br>
        <input type="hidden" name="AcqID" value="{{ $acquireId }}"><br>
    </form>
    <script type="text/javascript">

            function autoSubmit() {
                document.forms["paymentForm"].submit();
            }

    </script>

i want to redirecto to another controller & and read the parameter from reciver controller

redirect

if($request->payament_method == 4){
      return \Redirect::route('creditCard',['oid'=>$order->id]);
 }

web.php

Route::get('/creditCard', '[email protected]')->name('creditCard');

PayamentController

class PayamentController extends Controller
{
    public function creditCard(){
	//How can read paramete here
	}
}

@tray2 thanks, can you help me, how we can do this in validation

i have this table

users=>name, country_code, phone_number

how can make (country_code, phone_number) as unique, in migration and validation.

when remove unique:users,phone',

its return hellow kitty

but when add unique:users,phone', its return index page

i copy your code and put it on my code

but when add unique:users,phone

its return default laravel index page

@newbie360

still not working validation for phone

'phone'=>'required|min:10|max:15|unique:users,phone',

users DB

    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('phone')->unique();
        });
    }

I make this request file validation

class RegisterRequest extends FormRequest {

    public function authorize() {
        return true;
    }

    public function rules() {
        return [
            'name'=>'required',
            'phone'=>'required|unique|min:10|max:15',
            'gender'=>'required|integer',
            'marital_status'=>'required|integer',
            'birth_date'=>'required|date',
        ];
    }

    public function messages(){
        return [
            'name.required'=>'الرجاء إدخال الإسم',
            'phone.required'=>'الرجاء إدخال رقم الهاتف',
            'phone.unique'=>'رقم الهاتف موجود مسبقاً، بإمكانك تسجيل الدخول بإستخدام رقم الهاتف.',
            'phone.min:10'=>'الرجاء إدخال رقم هاتف صحيح',
            'phone.max:15'=>'الرجاء إدخال رقم هاتف صحيح',
            'gender.required'=>'الرجاء إختيار الجنس',
            'marital_status.required'=>'الرجاء إختيار الحالة الإجتماعية',
            'birth_date.required'=>'الرجاء إدخال تاريخ الميلاد',
        ];
    }
}

in eloquent my code is, i use RegisterRequest instead of Request

    public function store(RegisterRequest $request)
    {
        $user= new User();
        $user->name = $request->name;
        $user->phone = $request->phone;
        $user->gender = $request->gender;
        $user->martial_status = $request->marital_status;
        $user->birth_date = $request->birth_date;
        $user->pin_code = mt_rand(100000, 999999);
        $user->save();
        if($user){
            return $this->successMsg($user);
        }
    }

but custom error message not returned, I got default MySQL error msg, not messages defined in RegisterRequest.

e.g if try to register with an existing phone number I got this MySQL error

Integrity constraint violation: 1062 Duplicate entry '0599888999' for key

not custome error

I work with API, when printing $request echo $request , i got this

flutter: POST /api/confirmPurchase HTTP/1.1
Accept-Encoding: gzip
Content-Length:  460
Content-Type:    text/plain; charset=utf-8
Host:            www.mhpss.test
User-Agent:      Dart/2.10 (dart:io)
{
   "data":[
      {
         "id":21,
         "pid":3,
         "artitle":"hand bag",
         "price":20,
         "size":" LG",
         "color":"#DFA590",
         "pic":"/images/products/bag_1_3.png",
         "qty":1
      },
      {
         "id":20,
         "pid":3,
         "artitle":"tshirt",
         "price":20,
         "size":" XS ",
         "color":"#8B8586",
         "pic":"/images/products/bag_1_3.png",
         "qty":1
      },
   ]
}

when try to print data echo $request->data i got nothing.

any way to read this data and insert it to db.

i have chat_msgs table it contains ( body, type, from_id, to_id, )

i want to group by from_id, my Eloquent

    public function index()
    {
        $chatMsgs=ChatMsg::select('id','body','from_id','to_id')
            ->where('to_id',Auth()->user()->id)
            ->with('user:id,name')
            ->groupBy('from_id')
            ->get();
        return $chatMsgs;
    }

but I got this error SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mhpss.chat_msgs.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select id, body, from_id, to_id from chat_msgs where to_id = 1 group by from_id)

I try to use

public function index()
{
    $chatMsgs=ChatMsg::select('id','body','from_id','to_id')
        ->where('to_id',Auth()->user()->id)
        ->with('user:id,name')
        ->groupBy('from_id','id')
        ->get();
    return $chatMsgs;
}

but I got all record without groubing

i have this mutator, check if value is True , insert 1 to db, if not insert 0

    public function setHiddenNameAttribute($value)
    {
        if($value == True){
            $this->attributes['hidden_name'] = 1;
        }else if($value == False){
            $this->attributes['hidden_name'] = 0;
        }
    }

eloquent

$ques->hidden_name = $request->display_name;

but aways 1 is inserted to db, eloquent ignore mutators

@tykus i got this error

Trying to get property 'day' of non-object (View: /Library/WebServer/Documents/mhpss/resources/views/admin/clinics/indexclinics.blade.php)

@cristache nothing

i have this model

class Clinic extends Model
{
    public function clinkDay(){
        return $this->hasOne('App\Models\ClinkDay');
    }
}

and another model to specify days of clinic

class ClinkDay extends Model
{
    public function clinic(){
        return $this->belongsTo('App\Models\Clinic');
    }
}

in eloquent

        $clinics=Clinic::select('id','title','admin_id','active','doctor_id','created_at')
            ->with('admin:id,name')
            ->with('doctor:id,name_ar,major_ar,thumb')
            ->with('clinkDay:clinic_id,day,from,to')
            ->orderBy('id','DESC')
            ->paginate(13);

in eloquent everything is ok,

but in Clinik Model I want to reach the day field that exist in ClinkDay

i try to use this

    public function getDay()
    {
        return $this->day;
    }

but doesn't work

any way to reach day field in clinkDay

@vincent15000 not working i got this error ErrorException: Non-static method Illuminate\Database\Eloquent\Model::only()

i have this CatResource

return [
    'id' => $this->id,
    'title' => $this->title,
    'desc' => $this->desc,
    'active' => $this->getActive(),
    'admin'=> $this->admin,
    'tags'=> $this->tags,
    'created_at' => $this->created_at->toDateString(),
];

in query i use

return CatResource::collection(
    Cat::with('admin:id,name')
        ->orderBy('id','DESC')
        ->paginate(13)
);

i get this array

{
    "data": [
        {
            "id": 22,
            "title": "Omnis quia nihil lab",
            "desc": "Quibusdam tempore q",
            "active": "<span class=\"text-success\">مفعل</span>",
            "admin": {
                "id": 1,
                "name": "إيثار"
            },
            "tags": "Ullamco qui enim des",
            "created_at": "2020-11-28"
        },
    ]
}

until know every thing is ok. but in some case i wat to return just

{
    "data": [
        {
            "id": 22,
            "title": "Omnis quia nihil lab",
        },
    ]
}

the question of how can do that get just a specific field not all key in the resource file, without creating a new resource file

i have this active value in vue js

data(){
        return{
            fields:{
                active:'',
            }
        }
    },

i want if active = 1 to print this

<select class="form-control" required="" v-model="fields.active">
          <option value="1">active</option>
           <option value="0">in active</option>
</select>

but if active = 0

 <select class="form-control" required="" v-model="fields.active">
              <option value="0">in active</option>
              <option value="1">active</option>
</select>

@michaloravec after refactoring i got this error

BadMethodCallException
Call to undefined method App\Models\Admin::mapInto()
http://www.vuecms.test/api/cats

i want to get cat with admin who create the cat

in catController

    public function index()
    {
        $cats=Cat::with(['admin.cat'])->get();
        return CatResource::collection($cats->paginate(13));
    }

in catModel

    public function admin(){
        return $this->belongsTo('App\Models\Admins');
    }

in adminModel

    public function cat(){
        return $this->hasMany('App\Models\Cat');
    }

in catResource

    public function toArray($request)
    {
        return [
            'id' => $this->id,
            'title' => $this->title,
            'desc' => $this->desc,
            'active' => $this->getActive(),
            'admin'=> AdminResource::collection($this->whenLoaded('admin')),
            'created_at' => $this->created_at,
        ];
    }

in adminResource

    public function toArray($request)
    {
        return [
            'id' => $this->id,
            'name' => $this->name,
            'cat' => CatResource::collection($this->whenLoaded('cat')),
        ];
    }

but i got this error

Illuminate\Database\QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cats.admins_id' in 'where clause' (SQL: select * from `cats` where `cats`.`admins_id` in (1))

why in select cats.admins_id it must be cats.admin_id

i reanamed admins Model to admin bu i got this error

BadMethodCallException
Call to undefined method App\Models\Admin::mapInto()
http://www.vuecms.test/api/cats

Not Working

same problem, i use laravel 8

i use apiResource to submit data but i got an error

in api.php

Route::apiResource('posts', PostController::class);

in vuejs file create.vue

    methods:{
        submitData(){
            axios.post('api/posts',this.fields).then(res=>{
                this.$router.push('/');
            });
        }
    }

but i got this error

{message: "", exception: "Symfony\Component\HttpKernel\Exception\NotFoundHttpException",…}
exception: "Symfony\Component\HttpKernel\Exception\NotFoundHttpException"
file: "/Library/WebServer/Documents/LaraVue/vendor/laravel/framework/src/Illuminate/Routing/AbstractRouteCollection.php"
line: 43
message: ""

@rodrigo.pedra another question how can register component locally