div class="input-block__grp">
<input
class="input-block__field input-block__field-weight-tn_js"
autocomplete="off"
type="text"
value=""
readonly
/>
</div><div class="crm-form-calc__table-cell">
<span class="table-cell-inner-span"></span>
</div>select * from `crmAmoUser` where `crmAmoUser`.`crmCompanyID` is null and `amoID` = ? and `crmCompanyID` = ?"
class AmoUser extends BaseCRM
{
protected $table = 'crmAmoUser';
protected $casts = [
'created' => 'datetime',
'updated' => 'datetime',
'name' => 'string',
'amoID' => 'int',
'crmCompanyID' => 'int',
];
protected $fillable = [
'name',
'amoID',
'crmCompanyID' //если закомментировать сьтрочку, то работает.
];
public function Company(){
return $this->belongsTo(Company::class, 'crmCompanyID');
}
}class Company extends BaseCRM
{
protected $table = 'crmCompany';
public static $checkChangelog = false;
protected $casts = [
'created' => 'datetime',
'updated' => 'datetime',
'active' => 'boolean',
];
protected $fillable = [
'active'
];
public function AmoUsers()
{
return $this->hasMany(AmoUser::class, "crmCompanyID");
}
}if ($companyID==="" || $companyID===null|| empty($companyID)){
echo "errorst\n"; // не вывело
}
var_dump($companyID); // выводит int(1)
echo $companyID; //выводит 1
echo $mainUserField ; //выводит 11198626
$amoUserEntity = AmoUser::where('amoID', $mainUserField)->where('crmCompanyID',$companyID)->first();
if ($amoUserEntity===null){
Но попало сюда, несмотря на то что юзер в бд есть
var_dump($companyID); //вывело int(1)
echo $companyID; //вывело 1
$amoUserEntity=new AmoUser();
$amoUserEntity->amoID=$mainUserField;
$amoUserEntity->crmCompanyID=1; // вот тут, грубо присваиваю 1.
$amoUserEntity->save(); // и тут выдало ошибку Illuminate\Database\QueryException : SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'crmCompanyID' cannot be null (SQL: insert into `crmAmoUser` (`crmCompanyID`, `amoID`, `updated`, `created`) values (, 11198626, 2025-01-07 19:25:50, 2025-01-07 19:25:50)
}if ($companyID==="" || $companyID===null|| empty($companyID)){
echo "errorst\n"; // не вывело
}
$amoUserEntity = AmoUser::where('amoID', $mainUserField)->where('crmCompanyID',$companyID)->first();
if ($amoUserEntity===null){
Но попало сюда, несмотря на то что юзер в бд есть
var_dump($companyID); //вывело int(1)
echo $companyID; //вывело 1
$amoUserEntity=new AmoUser();
$amoUserEntity->amoID=$mainUserField;
$amoUserEntity->crmCompanyID=$companyID;
$amoUserEntity->save(); // и тут выдало ошибку Illuminate\Database\QueryException : SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'crmCompanyID' cannot be null (SQL: insert into `crmAmoUser` (`crmCompanyID`, `amoID`, `updated`, `created`) values (, 11198626, 2025-01-07 19:25:50, 2025-01-07 19:25:50)
}public static function import($datas, $companyID, $constants=[])
protected $fillable = [
'name',
'amoID',
// 'crmCompanyID'
];