Hello Again, thank you for this update. It is not working for the update I get an error "This value of company code already exists."
Additionally, how would i pass the actual value of the id to the rule? and in my case the primaryKey is account_id not id and it could be different from one Model to another.
Here is my current Rule
public function rules()
{
return [
'account_name' => 'required|min:5|max:100',
'legal_name' => 'max:100',
'company_code' => 'required|composite_unique:accounts,client_id,account_id=1',
'client_id' => 'required|min:1',
];
}
Here is my CustomValidationRule.php
<?php
namespace App\Classes\Validator;
use Illuminate\Validation\Validator;
use DB;
use Request;
class CustomValidationRules extends Validator
{
/**
* composite_unique validation rule
*
* Usage:
*
* When creating:
*
* 'column1' => 'composite_unique:table,column1,column2'
* 'column1' => 'composite_unique:table,column1,column2,column3'
*
* When Updating, use a number or an expression with an equal sign as the
* last parameter
*
* 'column1' => 'composite_unique:table,column1,column2,10'
* 'column1' => 'composite_unique:table,column1,column2,primaryField = 10'
*
* IMPORTANT: note that the current column should be added again in the rule, this
* permits the attribute name being validated to be different than the database column.
*
* Additionally:
* Laravel uses this convention to look for validation rules, this function will be triggered
* for composite_unique
*/
public function validateCompositeUnique( $attribute, $value, $parameters, $validator )
{
// data being validated
$data = $validator->getData();
// remove whitespaces
$parameters = array_map( 'trim', $parameters );
// remove first parameter and assume it is the table name
$table = array_shift( $parameters );
// remove last parameter to check for except condition
$lastParameter = array_pop( $parameters );
// start building the query
$query = DB::table( $table )->select( DB::raw( 1 ) );
// add the field being validated as a condition
// IMPORTANT: skipping it for improved consistency, see
// note in the function's comment
// $query->where( $attribute, $value );
// iterates over the parameters and add as where clauses
while ($field = array_shift( $parameters )) {
$query->where( $field, array_get( $data, $field ) );
}
// check $lastParameter for except condition. Uses a regular
// expression to check if $lastParameter contains only numbers
// or an equal sign
if (preg_match( '/^(?:\d+|.+?=.+)$/', $lastParameter )) {
// is except condition
if (preg_match( '/^\d+$/', $lastParameter )) {
// only numbers, assume primary key is called 'id' rewrite $lastParameter
$lastParameter = sprintf( '%s.account_id = %s', $table, $lastParameter );
}
// negate condition
$exceptField = sprintf( '(NOT %s)', $lastParameter );
$query->whereRaw( $exceptField );
} else {
// is not except condition, add as a normal where
$query->where( $lastParameter, array_get( $data, $lastParameter ) );
}
// get the result from DB
$result = $query->first();
return empty( $result ); // true if no result was found
}
}
Here is the code for my ValidationServiceProvider
<?php
namespace App\Providers;
use Illuminate\Support\ServiceProvider;
use App\Classes\Validator\CustomValidationRules;
use DB;
use Validator;
class ValidationServiceProvider extends ServiceProvider
{
/**
* Bootstrap the application services.
*
* @return void
*/
public function boot()
{
//
Validator::resolver(
function ( $translator, $data, $rules, $messages, $customAttributes ) {
return new CustomValidationRules( $translator, $data, $rules, $messages, $customAttributes );
}
);
}
/**
* Register the application services.
*
* @return void
*/
public function register()
{
//
}
}
