从模型中的 Laravel 表单设置空值

Question

在我的客户模型中，我有以下两个函数，用于处理创建新客户时为空的字段：

public function setCustPstAttribute($custpst)
{
    $this->attributes['CustPST'] = trim($custpst) == '' ? 0 : trim($custpst);
}
    public function setCustSicAttribute($custsiccode){
    $this->attributes['CustSicCode'] = trim($custsiccode) == '' ? 0 : trim($custsiccode);
}

函数setCustPstAttribute($custpst(工作正常，你可以看到上面的0值。setCustSicAttribute($custsiccode( 函数根本不会被访问/输入，我尝试退出该函数，但它永远不会被访问。 唯一的区别是变量类型，$custpst是varchar，$custsiccode是int。sql 插入正在查找一个整数，但得到一个空字符串。

QueryException {#363 ▼
  #sql: "insert into `customers` (`CustCompanyName`, `CustSicCode`, `FOBLocation`, `CustPST`, `CustGenerator`, `CustStatus`, `CustLastUpdate`, `CustStartDate`) values (?, ?, ?, ?, ?, ?, ?, ?)"
  #bindings: array:8 [▼
    0 => "Test"
    1 => ""
    2 => "Selkirk"
    3 => 0
    4 => ""
    5 => "Active"
    6 => "2017-02-10 14:12:48"
    7 => "2017-02-10 14:12:48"
  ]
  #message: "SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'CustSicCode' at row 1 (SQL: insert into `customers` (`CustCompanyName`, `CustSicCode`, `FOBLocation`, `CustPST`, `CustGenerator`, `CustStatus`, `CustLastUpdate`, `CustStartDate`) values (fgfgf, , Selkirk, 0, , Active, 2017-02-10 14:12:48, 2017-02-10 14:12:48))"
  #code: "22007"
  #file: "/var/www/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
  #line: 770
  -previous: PDOException {#364 ▶}
  +errorInfo: array:3 [▼
    0 => "22007"
    1 => 1366
    2 => "Incorrect integer value: '' for column 'CustSicCode' at row 1"
  ]
  +"previous": PDOException {#364 ▶}
  -trace: {▶}
}

Answer 1

函数的名称(在 set 和 Attribute 之间(必须与数据库中的列名完全相同。 设置CustSicCodeAttribute。更新后它起作用了。谢谢