{

protected $entityNotFoundExceptionClass = '\\Propel\\Runtime\\Exception\\EntityNotFoundException';

/**

public function __construct($dbName = 'default', $modelName = '\\SOB\\Propel2\\Customer', $modelAlias = null)

{

parent::__construct($dbName, $modelName, $modelAlias);

}

/**

public static function create(?string $modelAlias = null, ?Criteria $criteria = null) : Criteria

{

if ($criteria instanceof ChildCustomerQuery) {

return $criteria;

}

$query = new ChildCustomerQuery();

if (null !== $modelAlias) {

$query->setModelAlias($modelAlias);

}

if ($criteria instanceof Criteria) {

$query->mergeWith($criteria);

}

return $query;

}

/**

public function delete(?ConnectionInterface $con = null) : int

{

if (null === $con) {

$con = Propel::getServiceContainer()->getWriteConnection(CustomerTableMap::DATABASE_NAME);

}

$criteria = $this;

// Set the correct dbName

$criteria->setDbName(CustomerTableMap::DATABASE_NAME);

// use transaction because $criteria could contain info

// for more than one table or we could emulating ON DELETE CASCADE, etc.

return $con->transaction(function() use ($con, $criteria) {

$affectedRows = 0; // initialize var to track total num of affected rows

CustomerTableMap::removeInstanceFromPool($criteria);

$affectedRows += parent::delete($con);

CustomerTableMap::clearRelatedInstancePool();

return $affectedRows;

});

}

/**

public function doDeleteAll(?ConnectionInterface $con = null) : int

{

if (null === $con) {

$con = Propel::getServiceContainer()->getWriteConnection(CustomerTableMap::DATABASE_NAME);

}

// use transaction because $criteria could contain info

// for more than one table or we could emulating ON DELETE CASCADE, etc.

return $con->transaction(function() use ($con) {

$affectedRows = 0; // initialize var to track total num of affected rows

$affectedRows += parent::doDeleteAll($con);

// Because this db requires some delete cascade/set null emulation, we have to

// clear the cached instance *after* the emulation has happened (since

// instances get re-added by the select statement contained therein).

CustomerTableMap::clearInstancePool();

CustomerTableMap::clearRelatedInstancePool();

return $affectedRows;

});

}

/**

public function filterByAddress($address = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($address)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_ADDRESS, $address, $comparison);

return $this;

}

/**

public function filterByAttachments($attachments = null, ?string $comparison = null)

{

$this->addUsingAlias(CustomerTableMap::COL_ATTACHMENTS, $attachments, $comparison);

return $this;

}

/**

public function filterByBusinessPhone($businessPhone = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($businessPhone)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_BUSINESS_PHONE, $businessPhone, $comparison);

return $this;

}

/**

public function filterByCity($city = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($city)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_CITY, $city, $comparison);

return $this;

}

/**

public function filterByCompany($company = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($company)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_COMPANY, $company, $comparison);

return $this;

}

/**

public function filterByCountryRegion($countryRegion = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($countryRegion)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_COUNTRY_REGION, $countryRegion, $comparison);

return $this;

}

/**

public function filterByCustomerId($customerId = null, ?string $comparison = null)

{

if (\is_array($customerId)) {

$useMinMax = false;

if (isset($customerId['min'])) {

$this->addUsingAlias(CustomerTableMap::COL_CUSTOMER_ID, $customerId['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($customerId['max'])) {

$this->addUsingAlias(CustomerTableMap::COL_CUSTOMER_ID, $customerId['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_CUSTOMER_ID, $customerId, $comparison);

return $this;

}

/**

public function filterByEmailAddress($emailAddress = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($emailAddress)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_EMAIL_ADDRESS, $emailAddress, $comparison);

return $this;

}

/**

public function filterByFaxNumber($faxNumber = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($faxNumber)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_FAX_NUMBER, $faxNumber, $comparison);

return $this;

}

/**

public function filterByFirstName($firstName = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($firstName)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_FIRST_NAME, $firstName, $comparison);

return $this;

}

/**

public function filterByHomePhone($homePhone = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($homePhone)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_HOME_PHONE, $homePhone, $comparison);

return $this;

}

/**

public function filterByJobTitle($jobTitle = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($jobTitle)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_JOB_TITLE, $jobTitle, $comparison);

return $this;

}

/**

public function filterByLastName($lastName = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($lastName)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_LAST_NAME, $lastName, $comparison);

return $this;

}

/**

public function filterByMobilePhone($mobilePhone = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($mobilePhone)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_MOBILE_PHONE, $mobilePhone, $comparison);

return $this;

}

/**

public function filterByNotes($notes = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($notes)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_NOTES, $notes, $comparison);

return $this;

}

/**

public function filterByPrimaryKey($key)

{

$this->addUsingAlias(CustomerTableMap::COL_CUSTOMER_ID, $key, Criteria::EQUAL);

return $this;

}

/**

public function filterByPrimaryKeys($keys)

{

$this->addUsingAlias(CustomerTableMap::COL_CUSTOMER_ID, $keys, Criteria::IN);

return $this;

}

/**

public function filterByStateProvince($stateProvince = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($stateProvince)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_STATE_PROVINCE, $stateProvince, $comparison);

return $this;

}

/**

public function filterByWebPage($webPage = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($webPage)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_WEB_PAGE, $webPage, $comparison);

return $this;

}

/**

public function filterByZipPostalCode($zipPostalCode = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($zipPostalCode)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(CustomerTableMap::COL_ZIP_POSTAL_CODE, $zipPostalCode, $comparison);

return $this;

}

/**

public function findPk($key, ?ConnectionInterface $con = null)

{

if (null === $key) {

return null;

}

if (null === $con) {

$con = Propel::getServiceContainer()->getReadConnection(CustomerTableMap::DATABASE_NAME);

}

$this->basePreSelect($con);

if (

$this->formatter || $this->modelAlias || $this->with || $this->select

|| $this->selectColumns || $this->asColumns || $this->selectModifiers

|| $this->map || $this->having || $this->joins

) {

return $this->findPkComplex($key, $con);

}

if ((null !== ($obj = CustomerTableMap::getInstanceFromPool(null === $key || \is_scalar($key) || \is_callable([$key, '__toString']) ? (string)$key : $key)))) {

// the object is already in the instance pool

return $obj;

}

return $this->findPkSimple($key, $con);

}

/**

public function findPks($keys, ?ConnectionInterface $con = null)

{

if (null === $con) {

$con = Propel::getServiceContainer()->getReadConnection($this->getDbName());

}

$this->basePreSelect($con);

$criteria = $this->isKeepQuery() ? clone $this : $this;

$dataFetcher = $criteria

->filterByPrimaryKeys($keys)

->doSelect($con);

return $criteria->getFormatter()->init($criteria)->format($dataFetcher);

}

/**

public function prune($customer = null)

{

if ($customer) {

$this->addUsingAlias(CustomerTableMap::COL_CUSTOMER_ID, $customer->getCustomerId(), Criteria::NOT_EQUAL);

}

return $this;

}

/**

protected function findPkComplex($key, ConnectionInterface $con)

{

// As the query uses a PK condition, no limit(1) is necessary.

$criteria = $this->isKeepQuery() ? clone $this : $this;

$dataFetcher = $criteria

->filterByPrimaryKey($key)

->doSelect($con);

return $criteria->getFormatter()->init($criteria)->formatOne($dataFetcher);

}

/**

protected function findPkSimple($key, ConnectionInterface $con)

{

$sql = 'SELECT customer_id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments FROM customer WHERE customer_id = :p0';

try {

$stmt = $con->prepare($sql);

$stmt->bindValue(':p0', $key, PDO::PARAM_INT);

$stmt->execute();

} catch (Exception $e) {

Propel::log($e->getMessage(), Propel::LOG_ERR);

throw new PropelException(\sprintf('Unable to execute SELECT statement [%s]', $sql), 0, $e);

}

$obj = null;

if ($row = $stmt->fetch(\PDO::FETCH_NUM)) {

/** @var ChildCustomer $obj */

$obj = new ChildCustomer();

$obj->hydrate($row);

CustomerTableMap::addInstanceToPool($obj, null === $key || \is_scalar($key) || \is_callable([$key, '__toString']) ? (string)$key : $key);

}

$stmt->closeCursor();

return $obj;

}