Using dot in column keys

[webysther]

SQL fail using 'channel.name' as column. 'channel.name' is a HTML form with format channel[name]:

return [
    'channel.name' => [
        'required',
        'min:3',
        'max:255',
       'unique_with:channels,name,product_id,'.$this->route('channel')
    ],
    'channel.product_id' => 'required',
];

[felixkiss]

@webysther Please help test out #73 and give feedback if possible. It is based on version 3.0.0, so you need to upgrade (Usually only thing necessary is to update the service provider class in your config/app.php, which has been renamed)

[webysther]

Hi @felixkiss works partially, the problem of SQL is fine, but now search works but dont check all columns, example:

For rule:

unique_with:search_filters,search.name = name, search.user_id = user_id

Return the message:

This combination of search.name, search.user id already exists.

And the SQL executed is by validation:

select count(*) as aggregate from `search_filters` where `name` = 'teste'

My create statment:

CREATE TABLE `search_filters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `filter` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(10) unsigned DEFAULT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_search_filters` (`user_id`,`name`,`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Rows in table:

# id, user_id, name, filter, created_at, updated_at, deleted_at, created_by, updated_by, deleted_by
'2', '20', 'teste', 'action-search=&period=&product_id=&requester_auto_complete=&requester_id=&search_term=&status=pending', '2017-02-22 17:55:10', '2017-02-22 17:55:19', '2017-02-22 17:55:19', '20', '20', NULL
'3', '20', 'teste', 'action-search=&period=&product_id=&requester_auto_complete=&requester_id=&search_term=&status=pending', '2017-02-22 18:05:41', '2017-02-22 18:05:41', '0000-00-00 00:00:00', '20', '20', NULL

[webysther]

@felixkiss maybe is related to laravel/framework#1820
On my case check null not work, i need set value '0000-00-00 00:00:00'

[felixkiss]

I just tried it myself. I had the exact same problem as you until I noticed that I wasn't using the dot-validation branch. What does your composer.json look like? Should be something like

{
    "require": {
        "felixkiss/uniquewith-validator": "dev-dot-validation"
    }
}

[felixkiss]

As for the deleted_at problem: Just set the value to ignore (in your case 0000-00-00 00:00:00) in the validator data array like so:

$data = [
    'search' => [
        'name' => 'foo',
        'user_id' => 2,
    ],
    'deleted_at' => '0000-00-00 00:00:00',
];

$rules = [
    'search.name' => 'required|unique_with:search_filters, search.name = name, search.user_id = user_id, deleted_at',
    'search.user_id' => 'required',
];

$validator = Validator::make($data, $rules);

[webysther]

Now works! 👍