Laravel 5请求类

Question

在Laracast中，特别是Laravel 5基础中，Jeffrey提到了使用相同的请求类来创建和更新模型。我已经尝试过了，但得到了一个错误：

这是我的RequestClass

<?php namespace CRM\Http\Requests;

use CRM\Http\Requests\Request;

class ClientRequest extends Request {

    /**
     * Determine if the user is authorized to make this request.
     *
     * @return bool
     */
    public $rules = [
            'company'   => 'required|min:3',
            'firstname' => 'required|min:3',
            'lastname'  => 'required|min:3',
            'email'     => 'required|email|unique:clients,email',
            'phone'     => 'required|min:6|phone|unique:clients,phone',
            'address'   => 'required|min:3'
        ];

    public function authorize()
    {
        return true;
    }

    /**
     * Get the validation rules that apply to the request.
     *
     * @return array
     */
    public function rules()
    {
        if($clients = $this->clients){

            $this->rules['email'] .= ','.$clients ;
            $this->rules['phone'] .= ','.$clients ;
        }

        return $this->rules;
    }

    public function messages()
    {
        return ['phone' => 'The phone number is not valid. Please confirm and try again.'];
    }

}

当我创建一条新记录时，它工作得很好，但是当我更新一条记录时，它抛出一个错误。

以下是错误消息

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company:"BWA"' in 'where clause' (SQL: select count(*) as aggregate from `clients` where `email` = support@example.co.ke and `company:"BWA"` <> {"id":1 and `firstname:"richard"` = lastname:"keep" and `email:"support@example`.`co`.`ke"` = phone:"+27521341661" and `address:"test address"` = deleted_at:null and `created_at:"2015-04-15 08:46:45"` = updated_at:"2015-04-15 09:24:55"})

下面是我的控制器方法

   /**
     * Update the specified resource in storage.
     *
     * @param  int  $id
     * @return Response
     */
    public function update(Client $client, ClientRequest $request)
    {
        $client->update($request->all());

        return redirect('clients')->with('success', 'Client Updated Successfully');
    }

有谁知道这是怎么回事吗？

Answer 1

在编辑记录时，需要在唯一性规则中传递当前记录的id。对于您的案例，编辑记录的规则可以这样编写

public $rules = [
        'company'   => 'required|min:3',
        'firstname' => 'required|min:3',
        'lastname'  => 'required|min:3',
        'email'     => 'required|email|unique:clients,email',
        'phone'     => 'required|min:6|phone|unique:clients,phone,id',
        'address'   => 'required|min:3'
];

此外，您还必须为编辑和插入大小写编写单独的规则。

用于处理同一请求类中的多个规则的代码示例

public function rules()
{
$user = User::find($this->users);
switch($this->method())
{
    case 'GET':
    case 'DELETE':
    {
        return [];
    }
    case 'POST':
    {
        return [
            'user.name.first' => 'required',
            'user.name.last'  => 'required',
            'user.email'      => 'required|email|unique:users,email',
            'user.password'   => 'required|confirmed',
        ];
    }
    case 'PUT':
    case 'PATCH':
    {
        return [
            'user.name.first' => 'required',
            'user.name.last'  => 'required',
            'user.email'      => 'required|email|unique:users,email,'.$user->id,
            'user.password'   => 'required|confirmed',
        ];
    }
    default:break;
}
}

Answer 2

我设法解决了这个问题。我换掉了

    if($clients = $this->clients){

        $this->rules['email'] .= ','.$clients ;
        $this->rules['phone'] .= ','.$clients ;
    }

使用

if($this->method == "PUT"){
       $this->rules['email'] .= ','.$this->clients->id ;
       $this->rules['phone'] .= ','.$this->clients->id ;
}