Symfony实体管理员拒绝插入一列

Question

我正在尝试将一个新实体持久化并刷新到我的数据库中。但是，一列tblCompaniesServicesId不会与其他数据一起插入，从而导致SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'tbl_companies_services_id' cannot be null响应。

当我在持久化新实体后dd($entityManager->getUnitOfWork()->getScheduledEntityInsertions());时，我得到的是：(注意，tblCompaniesServicesId的值为12。(

array:1 [
"0000000013992b51000000003eb8a5e6" => TblCompaniesServicesContracts {#1500
-tblCompaniesServicesContractsId: null
-tblCompaniesServicesId: 12
-tblCompaniesServicesDiscountsId: null
-tblCompaniesId: 9999
-tblCompaniesLocationsId: null
-tblCompaniesCustomersId: 9999
-contractOrdernr: null
-contractName: "yeetus"
-contractDate: null
-contractPrice: null
-contractPricetax: null
-contractTax: null
-contractPayed: "0"
-contractUntil: null
-contractActive: "1"
-contractMonths: null
-contractReminder: "0"
-discountTitle: null
-discountPrice: null
-discountPercentage: null
-discountPriceStartup: null
-discountPercentageStartup: null
-transactionId: null
-responseId: null
-responseStatus: null
-responseStatusNl: null
-responseCheck: null
-responseTransactionid: null
-responseAmount: null
-responseCurrency: null
-responsePayed: null
-responseCustname: null
-responseCustaccount: null
-responseCustcity: null
-contractMemo: null
-contractAmountPerPeriod: "0.00"
-contractPeriodInMonths: "1"
-contractContractInMonths: "12"
-contractTerminateWithinContract: "1"
-contractNoticePeriodInMonths: "1"
-contractExtendInMonths: "12"
-contractStartupAmount: "0.00"
-contractPayInOnce: "1"
-contractPayInOnceDiscount: "10"
-contractTerminated: "0"
-contractTerminatedDate: null
-contractPaymentDay: "1"
-contractPaymentDayNextmonth: null
-contractReversalFee: null
-contractSignature: null
-contractEmail: null
-contractIban: null
-contractIbanName: null
-contractCredits: "0.00"
-contractApproved: "0"
-contractMd5: null
-payproInstallmentId: null
-pdfHash: null
-createdAt: null
-guardianFirstname: null
-guardianLastname: null
-guardianEmail: null
-guardianBirthdate: null
-guardianSignature: null
-signupValue: null
-service: null
-customer: null
-contractAffiliateId: null
-serviceAmountFirstmonth: null
}
]

我得到的回应是：(现在tblCompaniesServicesId没有值了。( An exception occurred while executing 'INSERT INTO tbl_companies_services_contracts (tbl_companies_services_id, tbl_companies_services_discounts_id, tbl_companies_id, tbl_companies_locations_id, tbl_companies_customers_id, contract_ordernr, contract_name, contract_date, contract_price, contract_pricetax, contract_tax, contract_payed, contract_until, contract_active, contract_months, contract_reminder, discount_title, discount_price, discount_percentage, discount_price_startup, discount_percentage_startup, transaction_id, response_id, response_status, response_status_nl, response_check, response_transactionid, response_amount, response_currency, response_payed, response_custname, response_custaccount, response_custcity, contract_memo, contract_amount_per_period, contract_period_in_months, contract_contract_in_months, contract_terminate_within_contract, contract_notice_period_in_months, contract_extend_in_months, contract_startup_amount, contract_pay_in_once, contract_pay_in_once_discount, contract_terminated, contract_terminated_date, contract_payment_day, contract_payment_day_nextmonth, contract_reversal_fee, contract_signature, contract_email, contract_iban, contract_iban_name, contract_credits, contract_approved, contract_md5, paypro_installment_id, pdf_hash, contract_created_at, guardian_firstname, guardian_lastname, guardian_email, guardian_birthdate, guardian_signature, signup_value, contract_affiliate_id, service_amount_firstmonth) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [null, null, 9999, null, null, null, "yeetus", null, null, null, null, "0", null, "1", null, "0", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "0.00", "1", "12", "1", "1", "12", "0.00", "1", "10", "0", null, "1", null, null, null, null, null, null, "0.00", "0", null, null, null, null, null, null, null, null, null, null, null, null]:nnSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'tbl_companies_services_id' cannot be null

我请求的正文：

{
"tblCompaniesServicesId": 12,
"tblCompaniesCustomersId": 9999,
"contractName": "yeetus"
}

TblCompaniesServicesContracts实体(只有相关的属性和方法，由于字符限制，您可以从上面发布的转储中看到这个实体有多大(：

<?php
namespace AppEntity;
use DateTime;
use DoctrineORMMapping as ORM;
/**
* TblCompaniesServicesContracts
*
* @ORMTable(name="tbl_companies_services_contracts")
* @ORMEntity(repositoryClass="AppRepositoryTblCompaniesServicesContractsRepository")
*/
class TblCompaniesServicesContracts implements JsonSerializable
{
/**
* @var int
*
* @ORMColumn(name="tbl_companies_services_id", type="integer", nullable=false)
*/
private $tblCompaniesServicesId;
public function getTblCompaniesServicesId(): ?int
{
return $this->tblCompaniesServicesId;
}
public function setTblCompaniesServicesId(int $tblCompaniesServicesId): self
{
$this->tblCompaniesServicesId = $tblCompaniesServicesId;
return $this;
}
}

我的控制器中的相关功能：(再次，字符限制(

public function addCompaniesServicesContracts(Request $request, EntityManagerInterface $entityManager, TblCompaniesServicesContractsRepository $tblCompaniesServicesContractsRepository, TokenStorageInterface $tokenStorageInterface, JWTTokenManagerInterface $jwtManager, TblCompaniesUsersRepository $tblCompaniesUsersRepository)
{
try {
$decodedJwtToken = $jwtManager->decode($tokenStorageInterface->getToken());
$user = $tblCompaniesUsersRepository->findOneByUsername($decodedJwtToken["username"]);
$request = $this->transformJsonBody($request);
$tblCompaniesServicesContracts = new TblCompaniesServicesContracts();
$parameters = $request->request->all();
if ($user->getCompany() == null) { // check if contract company id is same as company id of the user who requested
throw new Exception(403);
}
if ($user->getSuperAdmin() != true) { // check if user authorisation level is high enough
throw new Exception(403);
}
while ($parameter = current($parameters)) {
if (key($parameters) == "tblCompaniesId") {
throw new Exception(422);
}
else {
$newValue = $this->setContractValues($tblCompaniesServicesContracts, key($parameters), $parameter);
if (is_numeric($newValue)) {
throw new Exception($newValue);
}
else {
$tblCompaniesServicesContracts = $newValue;
}
}
next($parameters);
}
if ($tblCompaniesServicesContracts->getTblCompaniesServicesId() == null) {
throw new Exception(422);
}
$tblCompaniesServicesContracts->setTblCompaniesId($user->getCompany());
$entityManager->persist($tblCompaniesServicesContracts);
//dd($entityManager->getUnitOfWork()->getScheduledEntityInsertions());
$entityManager->flush();

$data = [
'status' => 200,
'success' => "contract added",
'companiesServicesContractsId' => $tblCompaniesServicesContracts->getTblCompaniesServicesContractsId(),
];
return $this->response($data);
}
catch (Exception $e) {
switch ($e->getMessage()) {
case 403:
$data = [
'status' => 403,
'errors' => "You shall not pass! Forbidden, access denied.",
];
return $this->response($data, 422);
break;
case 422:
$data = [
'status' => 422,
'errors' => "Data not valid",
];
return $this->response($data, 422);
break;
default:
$data = [
'status' => $e->getMessage(),
'errors' => "The foxes are on the loose, unknown error!",
];
return $this->response($data, 422);
break;
}
}
}

Answer 1

仍然不知道为什么会出错，但一个需要另一个实体的函数应该修复它。并且应该调用该函数，而不是您期望使用的函数。

/**
* @ORMManyToOne(targetEntity="AppEntityTblCompaniesServices", inversedBy="contracts")
* @ORMJoinColumn(name="tbl_companies_services_id", referencedColumnName="tbl_companies_services_id", nullable=true)
*/
private $service;
public function setService(?TblCompaniesServices $service): self
{
$this->service = $service;
return $this;
}