nekooee

no no, HasManyThrough is only for one to one and one to many relations but can't use for many to many and polymorphic relations. I found a solution: https://stackoverflow.com/questions/58310885/how-to-define-a-convenient-shortcut-for-accessing-distant-relations-between-on

I have three models: "Article", "ArticleTranslation", Tag".

Article translations in different languages are stored in the ArticleTranslation.

The "Article" model has a one-to-many relationship with the "ArticleTranslation" model and the "ArticleTranslation" model has a many-to-many polymorphic relationship with the "Tag" model. I need to define a convenient shortcut to easily gather all article tags for a given article and I need to define a convenient shortcut to easily gather all the articles that have the given tag.

for translate article I use laravel-translatable package.

tables of this relationships: articles:

id - integer

article_translations:

id - integer
article_id - integer
locale - string
title - string
slug - string

tags:

id - integer
slug - string

taggables:

tag_id - integer
taggable_id - integer
taggable_type - string

Article Model:

class Article extends Model
{
    use Translatable;
    public $translatedAttributes = ['title', 'slug', 'description', 'body'];
}

ArticleTranslation Model:

class ArticleTranslation extends Model
{
    use Sluggable;
    public $timestamps = false;
    protected $fillable = ['title', 'slug', 'description', 'body'];

    public function sluggable()
    {
        return [
            'slug' => [
                'source' => 'title',
            ],
        ];
    }
   
    public function tags()
    {
        return $this->morphToMany(Tag::class, 'taggable');
    }
}

Tag Model:

lass Tag extends Model
{
    use Sluggable;
    protected $fillable = ['name'];
    public function sluggable()
    {
        return [
            'slug' => [
                'source' => 'name',
            ],
        ];
    }

    public function articleTranslate()
    {
        return $this->morphedByMany(ArticleTranslation::class, 'taggable');
    }
}

Is there anyone who can help me?

@snapey no no, On the front there are several inputs for the title. like this:

 <div v-if="languages.length > 0" v-for="lang in languages" v-bind:key="lang.locale">
<input type="text" v-model="formContent.title[lang.locale]" >
</div>

after submitting this form server get this request:

array:3 [
  "title" => array:3 [
    "fa" => "دسته جدید"
    "en" => "new category"
    "ar" => "فئة جديدة"
  ]
  "status" => true
  "parent_id" => 2
]

titles to be unique in its locale. (per input one locale)

thanks @snapey If I use Rule, it checks in all locale, because in my code I use 'title.*' and the language fields are dynamic. But I need titles to be unique in its locale. If I use "where", how can I select locale for each title?

for sample in this code only check 'en' locale for all language!

  $request->validate([
            'title.*' => ['required', 
Rule::unique('article_category_translations')->where('locale', 'en'),
        ]

I have a category table that relates to itself for nested. And it has a relation with the translations table (article_category_translations). sample ajax request has:

array:3 [
  "title" => array:3 [
    "fa" => "دسته جدید"
    "en" => "new category"
    "ar" => "فئة جديدة"
  ]
  "status" => true
  "parent_id" => 2
]

I use this code for validation now:

$request->validate([
            'title.*' => ['max:30', 'required', 'unique:article_category_translations,title']
        ], [
            'title.*.max' => 'Title may not exceed 30 characters.',
            'title.*.required' => 'title required',
            'title.*.unique' => 'Title cannot be a duplicate.',
        ]);

This code checks titles to be unique in all categories and all languages. But I need titles to be unique in its locale and in its category. translate table (article_category_translations)

@NOMGUY - in this way you only return message, But I do not want to return a message. and I need to insert error message in my object. in front I used vue. and this object bind to form. if each field have error in object, Easily show it. On the other hand, the number of fields is dynamic and based on the number of languages that should be raised in the loop. Because we do not know how many fields we have! Also, if I use the star for the field name, it is not recognizable at the front which error is for which field! Of course, I might do something else than return an error in the object. So, I need to be able to execute the code for each error, except for returning a message.

example:

{  
   "id":1,
   "mediaFullName":"10032-simple-business-card-moc.jpg",
   "mediaType":"image/jpeg",
   "mediaUrl":"/storage/2019/05/10032-simple-business-card-moc.jpg",
   "user":{  
      "id":1,
      "name":"Armin Nekooee"
   },
   "translations":[  
      {  
         "id":1,
         "media_id":1,
         "locale":"en",
         "mediaTitle":"",
         "mediaAlT":"",
         "errors":{  
            "mediaTitle":{  
               "0":"Title is Required",
               "1":"The number of characters allowed is 32 characters."
            }
         },
            "mediaAlt":{  
               "0":"Alt is Required",
               "1":"The number of characters allowed is 32 characters."
            }
         }
      }     
   ]
}

if ($validator->fails()) {
     $returnedFormContent['translations'][$key]['errors']['mediaTitle'][$i] = 'The number of characters allowed is 32 characters.';
     $errors = true;
  }

 if ($errors) {
            return response()->json([
                'success' => false,
                'returnedFormContent' => $returnedFormContent,
            ], 400);
        }

if I simple return custom message in front I can't find each error for whats feild and language.

Does anybody can help me?

my field name is dynamic and for each language, the fields are repeated with a suffix. I need to insert a value into custom my code for any field if validation failed ! for example:

 foreach ($languages as $key=>$language) {
         $validator = Validator::make($request->all(), [
                       'somthing1'  => 'required'
                    ]);
                    if ($validator->fails()) {
                      //my own code 1
                    }

  $validator = Validator::make($request->all(), [
                     $validator = Validator::make($request->all(), [
                       'somthing1'  => 'max:32'
                    ]);
                    if ($validator->fails()) {
                      //my own code 2
                    }
}


  $validator = Validator::make($request->all(), [
                       $validator = Validator::make($request->all(), [
                       'somthing2'  => 'required'
                    ]);
                    if ($validator->fails()) {
                      //my own code 3
                    }
}

this way work fine but the validation are repeated many times!! How can this code be optimized?

@topvillas I used this Route for all: Route::get('/{any?}', '[email protected]')->where('any', '.*');

But with this route, I can not do get userslist, updates, store, and delete operations. So I had to write another route before this route:

Route::resource('/users', 'UserController');
Route::resource('/articles', 'ArticleController');
Route::get('/{any?}', '[email protected]')->where('any', '.*');

Is this the right way? Or another solution?