{

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

/**

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

{

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

}

/**

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

{

if ($criteria instanceof ChildSalesReportQuery) {

return $criteria;

}

$query = new ChildSalesReportQuery();

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(SalesReportTableMap::DATABASE_NAME);

}

$criteria = $this;

// Set the correct dbName

$criteria->setDbName(SalesReportTableMap::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

SalesReportTableMap::removeInstanceFromPool($criteria);

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

SalesReportTableMap::clearRelatedInstancePool();

return $affectedRows;

});

}

/**

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

{

if (null === $con) {

$con = Propel::getServiceContainer()->getWriteConnection(SalesReportTableMap::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).

SalesReportTableMap::clearInstancePool();

SalesReportTableMap::clearRelatedInstancePool();

return $affectedRows;

});

}

/**

public function filterByDefault($default = null, ?string $comparison = null)

{

if (\is_array($default)) {

$useMinMax = false;

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

$this->addUsingAlias(SalesReportTableMap::COL_DEFAULT, $default['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

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

$this->addUsingAlias(SalesReportTableMap::COL_DEFAULT, $default['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(SalesReportTableMap::COL_DEFAULT, $default, $comparison);

return $this;

}

/**

public function filterByDisplay($display = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($display)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(SalesReportTableMap::COL_DISPLAY, $display, $comparison);

return $this;

}

/**

public function filterByFilterRowSource($filterRowSource = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($filterRowSource)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(SalesReportTableMap::COL_FILTER_ROW_SOURCE, $filterRowSource, $comparison);

return $this;

}

/**

public function filterByGroupBy($groupBy = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($groupBy)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(SalesReportTableMap::COL_GROUP_BY, $groupBy, $comparison);

return $this;

}

/**

public function filterByPrimaryKey($key)

{

$this->addUsingAlias(SalesReportTableMap::COL_GROUP_BY, $key, Criteria::EQUAL);

return $this;

}

/**

public function filterByPrimaryKeys($keys)

{

$this->addUsingAlias(SalesReportTableMap::COL_GROUP_BY, $keys, Criteria::IN);

return $this;

}

/**

public function filterByTitle($title = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($title)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(SalesReportTableMap::COL_TITLE, $title, $comparison);

return $this;

}

/**

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

{

if (null === $key) {

return null;

}

if (null === $con) {

$con = Propel::getServiceContainer()->getReadConnection(SalesReportTableMap::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 = SalesReportTableMap::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($salesReport = null)

{

if ($salesReport) {

$this->addUsingAlias(SalesReportTableMap::COL_GROUP_BY, $salesReport->getGroupBy(), 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 group_by, display, title, filter_row_source, default FROM sales_report WHERE group_by = :p0';

try {

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

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

$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 ChildSalesReport $obj */

$obj = new ChildSalesReport();

$obj->hydrate($row);

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

}

$stmt->closeCursor();

return $obj;

}