/**
* Join products and their URLs
*
* @param Criteria $query
*/
protected function addJoinProduct(Criteria &$query)
{
// Join RewritingURL with Product to have only visible products
$join = new Join();
$join->addExplicitCondition(RewritingUrlTableMap::TABLE_NAME, 'VIEW_ID', null, ProductTableMap::TABLE_NAME, 'ID', null);
$join->setJoinType(Criteria::INNER_JOIN);
$query->addJoinObject($join, 'productJoin');
// Get only visible products
$query->addJoinCondition('productJoin', ProductTableMap::VISIBLE, 1, Criteria::EQUAL, \PDO::PARAM_INT);
}
public function testCreateSelectSqlPart()
{
Propel::getServiceContainer()->setAdapter('oracle', new OracleAdapter());
$db = Propel::getServiceContainer()->getAdapter();
$c = new Criteria();
$c->addSelectColumn(BookTableMap::COL_ID);
$c->addAsColumn('book_ID', BookTableMap::COL_ID);
$fromClause = [];
$selectSql = $db->createSelectSqlPart($c, $fromClause);
$this->assertEquals('SELECT book.id, book.id AS book_ID', $selectSql, 'createSelectSqlPart() returns a SQL SELECT clause with both select and as columns');
$this->assertEquals(['book'], $fromClause, 'createSelectSqlPart() adds the tables from the select columns to the from clause');
}
public function testDoInsert()
{
try {
$c = new Criteria();
$c->setPrimaryTableName(BookTableMap::TABLE_NAME);
$c->add(BookTableMap::AUTHOR_ID, 'lkhlkhj');
$c->doInsert(Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME));
$this->fail('Missing expected exception on BAD SQL');
} catch (PropelException $e) {
$this->assertContains('[INSERT INTO `book` (`AUTHOR_ID`) VALUES (:p1)]', $e->getMessage(), 'SQL query is written in the exception message');
}
}
public function testAppendPsToCreatesAnInConditionUsingATableAlias()
{
$c = new Criteria();
$c->addAlias('bar_alias', 'bar');
$cton = new InCriterion($c, 'bar_alias.COL', array('foo'));
$params = array();
$ps = '';
$cton->appendPsTo($ps, $params);
$this->assertEquals('bar_alias.COL IN (:p1)', $ps);
$expected = array(array('table' => 'bar', 'column' => 'COL', 'value' => 'foo'));
$this->assertEquals($expected, $params);
}
public function testClonedCriteriaNotAffected2()
{
$this->c->addCond('cond1', "INVOICE.COST1", "1000", Criteria::GREATER_EQUAL);
$this->c->addCond('cond2', "INVOICE.COST2", "2000", Criteria::LESS_EQUAL);
$this->c->combine(['cond1', 'cond2'], Criteria::LOGICAL_AND, 'cond12');
$this->c->addCond('cond3', "INVOICE.COST3", "8000", Criteria::GREATER_EQUAL);
$this->c->addCond('cond4', "INVOICE.COST4", "9000", Criteria::LESS_EQUAL);
$this->c->combine(['cond3', 'cond4'], Criteria::LOGICAL_AND, 'cond34');
$clonedCriteria = clone $this->c;
$expect1 = $this->getSql("SELECT FROM ");
$params1 = [];
$result1 = $this->c->createSelectSql($params1);
$this->assertEquals($expect1, $result1);
$this->c->addCond('cond5', "INVOICE.COST5", "5000", Criteria::GREATER_EQUAL);
$this->c->combine(['cond34', 'cond5'], Criteria::LOGICAL_AND);
$expect2 = $this->getSql("SELECT FROM INVOICE WHERE ((INVOICE.COST3>=:p1 AND INVOICE.COST4<=:p2) AND INVOICE.COST5>=:p3)");
$expect_params2 = [['table' => 'INVOICE', 'column' => 'COST3', 'value' => '8000'], ['table' => 'INVOICE', 'column' => 'COST4', 'value' => '9000'], ['table' => 'INVOICE', 'column' => 'COST5', 'value' => '5000']];
$params2 = [];
$result2 = $this->c->createSelectSql($params2);
$this->assertEquals($expect2, $result2);
$this->assertEquals($expect_params2, $params2);
// Cloned criteria should not be affected by the combine of cond34 above
// we should still be able to use it in the clone for another combine
$clonedCriteria->combine(['cond12', 'cond34'], Criteria::LOGICAL_OR);
$expect3 = $this->getSql("SELECT FROM INVOICE WHERE ((INVOICE.COST1>=:p1 AND INVOICE.COST2<=:p2) OR (INVOICE.COST3>=:p3 AND INVOICE.COST4<=:p4))");
$expect_params3 = [['table' => 'INVOICE', 'column' => 'COST1', 'value' => '1000'], ['table' => 'INVOICE', 'column' => 'COST2', 'value' => '2000'], ['table' => 'INVOICE', 'column' => 'COST3', 'value' => '8000'], ['table' => 'INVOICE', 'column' => 'COST4', 'value' => '9000']];
$params3 = [];
$result3 = $clonedCriteria->createSelectSql($params3);
$this->assertEquals($expect3, $result3);
$this->assertEquals($expect_params3, $params3);
}
/**
* @param Criteria $criteria
* @param string $alias
*/
public function addSelectFields(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectField(AuthorEntityMap::COL_ID);
$criteria->addSelectField(AuthorEntityMap::COL_FIRSTNAME);
$criteria->addSelectField(AuthorEntityMap::COL_LASTNAME);
$criteria->addSelectField(AuthorEntityMap::COL_EMAIL);
} else {
$criteria->addSelectField($alias . '.id');
$criteria->addSelectField($alias . '.firstName');
$criteria->addSelectField($alias . '.lastName');
$criteria->addSelectField($alias . '.email');
}
}
public function testDoInsert()
{
$con = Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME);
try {
$c = new Criteria();
$c->setPrimaryTableName(BookTableMap::TABLE_NAME);
$c->add(BookTableMap::AUTHOR_ID, 'lkhlkhj');
$db = Propel::getServiceContainer()->getAdapter($c->getDbName());
$c->doInsert($con);
$this->fail('Missing expected exception on BAD SQL');
} catch (PropelException $e) {
if ($db->isGetIdBeforeInsert()) {
$this->assertContains($this->getSql('[INSERT INTO book (AUTHOR_ID,ID) VALUES (:p1,:p2)]'), $e->getMessage(), 'SQL query is written in the exception message');
} else {
$this->assertContains($this->getSql('[INSERT INTO `book` (`AUTHOR_ID`) VALUES (:p1)]'), $e->getMessage(), 'SQL query is written in the exception message');
}
}
}
public function testDoSelectOrderByRank()
{
$c = new Criteria();
$c->add(SortableTable12TableMap::SCOPE_COL, 1);
$objects = SortableTable12Query::doSelectOrderByRank($c)->getArrayCopy();
$oldRank = 0;
while ($object = array_shift($objects)) {
$this->assertTrue($object->getRank() > $oldRank);
$oldRank = $object->getRank();
}
$c = new Criteria();
$c->add(SortableTable12TableMap::SCOPE_COL, 1);
$objects = SortableTable12Query::doSelectOrderByRank($c, Criteria::DESC)->getArrayCopy();
$oldRank = 10;
while ($object = array_shift($objects)) {
$this->assertTrue($object->getRank() < $oldRank);
$oldRank = $object->getRank();
}
}
/**
* Init some properties with the help of outer class
* @param Criteria $criteria The outer class
*/
public function init(Criteria $criteria)
{
try {
$db = Propel::getServiceContainer()->getAdapter($criteria->getDbName());
$this->setAdapter($db);
} catch (\Exception $e) {
// we are only doing this to allow easier debugging, so
// no need to throw up the exception, just make note of it.
Propel::log("Could not get a AdapterInterface, sql may be wrong", Propel::LOG_ERR);
}
// init $this->realtable
$realtable = $criteria->getTableForAlias($this->table);
$this->realtable = $realtable ? $realtable : $this->table;
}
public function testCombineDirtyOperators()
{
$this->c->addCond('cond1', "INVOICE.COST1", "1000", Criteria::GREATER_EQUAL);
$this->c->addCond('cond2', "INVOICE.COST2", "2000", Criteria::LESS_EQUAL);
$this->c->combine(['cond1', 'cond2'], 'AnD', 'cond12');
$this->c->addCond('cond3', "INVOICE.COST3", "8000", Criteria::GREATER_EQUAL);
$this->c->addCond('cond4', "INVOICE.COST4", "9000", Criteria::LESS_EQUAL);
$this->c->combine(['cond3', 'cond4'], 'aNd', 'cond34');
$this->c->combine(['cond12', 'cond34'], 'oR');
$expect = $this->getSql("SELECT FROM INVOICE WHERE ((INVOICE.COST1>=:p1 AND INVOICE.COST2<=:p2) OR (INVOICE.COST3>=:p3 AND INVOICE.COST4<=:p4))");
$expect_params = [['table' => 'INVOICE', 'column' => 'COST1', 'value' => '1000'], ['table' => 'INVOICE', 'column' => 'COST2', 'value' => '2000'], ['table' => 'INVOICE', 'column' => 'COST3', 'value' => '8000'], ['table' => 'INVOICE', 'column' => 'COST4', 'value' => '9000']];
$params = [];
$result = $this->c->createSelectSql($params);
$this->assertEquals($expect, $result);
$this->assertEquals($expect_params, $params);
}
/**
* @inheritdoc
*/
public function toCriteria()
{
$criteria = new Criteria();
if ($this->filterTransfer->getLimit() !== null) {
$criteria->setLimit($this->filterTransfer->getLimit());
}
if ($this->filterTransfer->getOffset() !== null) {
$criteria->setOffset($this->filterTransfer->getOffset());
}
if ($this->filterTransfer->getOrderBy() !== null) {
if ($this->filterTransfer->getOrderDirection() === 'ASC') {
$criteria->addAscendingOrderByColumn($this->filterTransfer->getOrderBy());
} elseif ($this->filterTransfer->getOrderDirection() === 'DESC') {
$criteria->addDescendingOrderByColumn($this->filterTransfer->getOrderBy());
}
}
return $criteria;
}
/**
* Join products and their URLs
*
* @param Criteria $query
*/
protected function addJoinProductI18n(Criteria &$query)
{
// Join RewritingURL with Product to have only visible products
$join = new Join();
$join->addExplicitCondition(RewritingUrlTableMap::TABLE_NAME, 'VIEW_ID', null, ProductTableMap::TABLE_NAME, 'ID', null);
$join->setJoinType(Criteria::INNER_JOIN);
$query->addJoinObject($join, 'productJoin');
$query->addJoinCondition('productJoin', ProductTableMap::VISIBLE, 1, Criteria::EQUAL, \PDO::PARAM_INT);
// Join RewritingURL with ProductI18n to have product title for it's image
$joinI18n = new Join();
$joinI18n->addExplicitCondition(RewritingUrlTableMap::TABLE_NAME, 'VIEW_ID', null, ProductI18nTableMap::TABLE_NAME, 'ID', null);
$joinI18n->addExplicitCondition(RewritingUrlTableMap::TABLE_NAME, 'VIEW_LOCALE', null, ProductI18nTableMap::TABLE_NAME, 'LOCALE', null);
$joinI18n->setJoinType(Criteria::INNER_JOIN);
$query->addJoinObject($joinI18n);
// Join RewritingURL with ProductImage to have image file
$joinImage = new Join();
$joinImage->addExplicitCondition(RewritingUrlTableMap::TABLE_NAME, 'VIEW_ID', null, ProductImageTableMap::TABLE_NAME, 'PRODUCT_ID', null);
$joinImage->setJoinType(Criteria::INNER_JOIN);
$query->addJoinObject($joinImage, 'productImageJoin');
$query->addJoinCondition('productImageJoin', ProductImageTableMap::VISIBLE, 1, Criteria::EQUAL, \PDO::PARAM_INT);
}
/**
* Builds a Criteria object containing the primary key for this object.
*
* Unlike buildCriteria() this method includes the primary key values regardless
* of whether or not they have been modified.
*
* @return Criteria The Criteria object containing value(s) for primary key(s).
*/
public function buildPkeyCriteria()
{
$criteria = new Criteria(CustomerTitleI18nTableMap::DATABASE_NAME);
$criteria->add(CustomerTitleI18nTableMap::ID, $this->id);
$criteria->add(CustomerTitleI18nTableMap::LOCALE, $this->locale);
return $criteria;
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(WishlistProductTableMap::DATABASE_NAME);
if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_PRODUCT_ID)) {
$criteria->add(WishlistProductTableMap::COL_WISHLIST_PRODUCT_ID, $this->wishlist_product_id);
}
if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_ID)) {
$criteria->add(WishlistProductTableMap::COL_WISHLIST_ID, $this->wishlist_id);
}
if ($this->isColumnModified(WishlistProductTableMap::COL_PRODUCT_ID)) {
$criteria->add(WishlistProductTableMap::COL_PRODUCT_ID, $this->product_id);
}
if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_PRODUCT_COMMENT)) {
$criteria->add(WishlistProductTableMap::COL_WISHLIST_PRODUCT_COMMENT, $this->wishlist_product_comment);
}
if ($this->isColumnModified(WishlistProductTableMap::COL_CREATED_AT)) {
$criteria->add(WishlistProductTableMap::COL_CREATED_AT, $this->created_at);
}
if ($this->isColumnModified(WishlistProductTableMap::COL_UPDATED_AT)) {
$criteria->add(WishlistProductTableMap::COL_UPDATED_AT, $this->updated_at);
}
return $criteria;
}
public function testCreateSelectSqlPartAliasAll()
{
$db = Propel::getServiceContainer()->getAdapter(BookTableMap::DATABASE_NAME);
$c = new Criteria();
$c->addSelectColumn(BookTableMap::COL_ID);
$c->addAsColumn('book_id', BookTableMap::COL_ID);
$fromClause = [];
$selectSql = $db->createSelectSqlPart($c, $fromClause, true);
$this->assertEquals('SELECT book.id AS book_id_1, book.id AS book_id', $selectSql, 'createSelectSqlPart() aliases all columns if passed true as last parameter');
$this->assertEquals([], $fromClause, 'createSelectSqlPart() does not add the tables from an all-aliased list of select columns');
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(FileTableMap::DATABASE_NAME);
if ($this->isColumnModified(FileTableMap::COL_FILE_ID)) {
$criteria->add(FileTableMap::COL_FILE_ID, $this->file_id);
}
if ($this->isColumnModified(FileTableMap::COL_FILE_TYPE_ID)) {
$criteria->add(FileTableMap::COL_FILE_TYPE_ID, $this->file_type_id);
}
if ($this->isColumnModified(FileTableMap::COL_FILE_PATH)) {
$criteria->add(FileTableMap::COL_FILE_PATH, $this->file_path);
}
if ($this->isColumnModified(FileTableMap::COL_CREATED_AT)) {
$criteria->add(FileTableMap::COL_CREATED_AT, $this->created_at);
}
if ($this->isColumnModified(FileTableMap::COL_UPDATED_AT)) {
$criteria->add(FileTableMap::COL_UPDATED_AT, $this->updated_at);
}
return $criteria;
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(EntityTypeTableMap::DATABASE_NAME);
if ($this->isColumnModified(EntityTypeTableMap::COL_ID)) {
$criteria->add(EntityTypeTableMap::COL_ID, $this->id);
}
if ($this->isColumnModified(EntityTypeTableMap::COL_NAME)) {
$criteria->add(EntityTypeTableMap::COL_NAME, $this->name);
}
return $criteria;
}
public function doTestReplaceNames(Criteria $c, $tableMap, $origClause, $columnPhpName = false, $modifiedClause)
{
$c->replaceNames($origClause);
$columns = $c->replacedColumns;
if ($columnPhpName) {
$this->assertEquals(array($tableMap->getColumnByPhpName($columnPhpName)), $columns);
}
$this->assertEquals($modifiedClause, $origClause);
}
/**
* Performs a DELETE on the database, given a ModuleImage or Criteria object OR a primary key value.
*
* @param mixed $values Criteria or ModuleImage object or primary key or array of primary keys
* which is used to create the DELETE statement
* @param ConnectionInterface $con the connection to use
* @return int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows
* if supported by native driver or if emulated using Propel.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doDelete($values, ConnectionInterface $con = null)
{
if (null === $con) {
$con = Propel::getServiceContainer()->getWriteConnection(ModuleImageTableMap::DATABASE_NAME);
}
if ($values instanceof Criteria) {
// rename for clarity
$criteria = $values;
} elseif ($values instanceof \Thelia\Model\ModuleImage) {
// it's a model object
// create criteria based on pk values
$criteria = $values->buildPkeyCriteria();
} else {
// it's a primary key, or an array of pks
$criteria = new Criteria(ModuleImageTableMap::DATABASE_NAME);
$criteria->add(ModuleImageTableMap::ID, (array) $values, Criteria::IN);
}
$query = ModuleImageQuery::create()->mergeWith($criteria);
if ($values instanceof Criteria) {
ModuleImageTableMap::clearInstancePool();
} elseif (!is_object($values)) {
// it's a primary key, or an array of pks
foreach ((array) $values as $singleval) {
ModuleImageTableMap::removeInstanceFromPool($singleval);
}
}
return $query->delete($con);
}
/**
* Performs a DELETE on the database, given a DiaporamaVersion or Criteria object OR a primary key value.
*
* @param mixed $values Criteria or DiaporamaVersion object or primary key or array of primary keys
* which is used to create the DELETE statement
* @param ConnectionInterface $con the connection to use
* @return int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows
* if supported by native driver or if emulated using Propel.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doDelete($values, ConnectionInterface $con = null)
{
if (null === $con) {
$con = Propel::getServiceContainer()->getWriteConnection(DiaporamaVersionTableMap::DATABASE_NAME);
}
if ($values instanceof Criteria) {
// rename for clarity
$criteria = $values;
} elseif ($values instanceof \Diaporamas\Model\DiaporamaVersion) {
// it's a model object
// create criteria based on pk values
$criteria = $values->buildPkeyCriteria();
} else {
// it's a primary key, or an array of pks
$criteria = new Criteria(DiaporamaVersionTableMap::DATABASE_NAME);
// primary key is composite; we therefore, expect
// the primary key passed to be an array of pkey values
if (count($values) == count($values, COUNT_RECURSIVE)) {
// array is not multi-dimensional
$values = array($values);
}
foreach ($values as $value) {
$criterion = $criteria->getNewCriterion(DiaporamaVersionTableMap::ID, $value[0]);
$criterion->addAnd($criteria->getNewCriterion(DiaporamaVersionTableMap::VERSION, $value[1]));
$criteria->addOr($criterion);
}
}
$query = DiaporamaVersionQuery::create()->mergeWith($criteria);
if ($values instanceof Criteria) {
DiaporamaVersionTableMap::clearInstancePool();
} elseif (!is_object($values)) {
// it's a primary key, or an array of pks
foreach ((array) $values as $singleval) {
DiaporamaVersionTableMap::removeInstanceFromPool($singleval);
}
}
return $query->delete($con);
}
/**
* Builds a Criteria object containing the primary key for this object.
*
* Unlike buildCriteria() this method includes the primary key values regardless
* of whether or not they have been modified.
*
* @return Criteria The Criteria object containing value(s) for primary key(s).
*/
public function buildPkeyCriteria()
{
$criteria = new Criteria(CommentTableMap::DATABASE_NAME);
$criteria->add(CommentTableMap::ID, $this->id);
return $criteria;
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(ApplicationTableMap::DATABASE_NAME);
if ($this->isColumnModified(ApplicationTableMap::COL_ID)) {
$criteria->add(ApplicationTableMap::COL_ID, $this->id);
}
if ($this->isColumnModified(ApplicationTableMap::COL_STUDENT_ID)) {
$criteria->add(ApplicationTableMap::COL_STUDENT_ID, $this->student_id);
}
if ($this->isColumnModified(ApplicationTableMap::COL_SUBJECT_ID)) {
$criteria->add(ApplicationTableMap::COL_SUBJECT_ID, $this->subject_id);
}
if ($this->isColumnModified(ApplicationTableMap::COL_PERIOD_ID)) {
$criteria->add(ApplicationTableMap::COL_PERIOD_ID, $this->period_id);
}
if ($this->isColumnModified(ApplicationTableMap::COL_SCHOOL_YEAR_ID)) {
$criteria->add(ApplicationTableMap::COL_SCHOOL_YEAR_ID, $this->school_year_id);
}
if ($this->isColumnModified(ApplicationTableMap::COL_APPLICATION_DATE)) {
$criteria->add(ApplicationTableMap::COL_APPLICATION_DATE, $this->application_date);
}
if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_DATE)) {
$criteria->add(ApplicationTableMap::COL_EXAM_DATE, $this->exam_date);
}
if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_TIME)) {
$criteria->add(ApplicationTableMap::COL_EXAM_TIME, $this->exam_time);
}
if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_SCORE)) {
$criteria->add(ApplicationTableMap::COL_EXAM_SCORE, $this->exam_score);
}
if ($this->isColumnModified(ApplicationTableMap::COL_CREATED_AT)) {
$criteria->add(ApplicationTableMap::COL_CREATED_AT, $this->created_at);
}
if ($this->isColumnModified(ApplicationTableMap::COL_UPDATED_AT)) {
$criteria->add(ApplicationTableMap::COL_UPDATED_AT, $this->updated_at);
}
return $criteria;
}
public function testModifiedObjectsRemainInTheCollection()
{
$c = new Criteria();
$c->add(BookTableMap::ID, $this->books[0]->getId());
$books = BookQuery::create(null, $c)->joinWithAuthor()->find();
$books[0]->setTitle('Modified');
$books2 = $books[0]->getAuthor()->getBooks();
$this->assertEquals(2, count($books2));
$this->assertEquals(2, $books2[0]->getAuthor()->countBooks());
$this->assertEquals('Modified', $books2[0]->getTitle());
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(StudentTableMap::DATABASE_NAME);
if ($this->isColumnModified(StudentTableMap::COL_ID)) {
$criteria->add(StudentTableMap::COL_ID, $this->id);
}
if ($this->isColumnModified(StudentTableMap::COL_IDENTIFICATION_NUMBER)) {
$criteria->add(StudentTableMap::COL_IDENTIFICATION_NUMBER, $this->identification_number);
}
if ($this->isColumnModified(StudentTableMap::COL_SCHOOL_YEAR_ID)) {
$criteria->add(StudentTableMap::COL_SCHOOL_YEAR_ID, $this->school_year_id);
}
if ($this->isColumnModified(StudentTableMap::COL_COURSE_ID)) {
$criteria->add(StudentTableMap::COL_COURSE_ID, $this->course_id);
}
if ($this->isColumnModified(StudentTableMap::COL_FIRST_NAME)) {
$criteria->add(StudentTableMap::COL_FIRST_NAME, $this->first_name);
}
if ($this->isColumnModified(StudentTableMap::COL_LAST_NAME)) {
$criteria->add(StudentTableMap::COL_LAST_NAME, $this->last_name);
}
if ($this->isColumnModified(StudentTableMap::COL_BIRTH_PLACE)) {
$criteria->add(StudentTableMap::COL_BIRTH_PLACE, $this->birth_place);
}
if ($this->isColumnModified(StudentTableMap::COL_BIRTHDAY)) {
$criteria->add(StudentTableMap::COL_BIRTHDAY, $this->birthday);
}
if ($this->isColumnModified(StudentTableMap::COL_PHONE_NUMBER)) {
$criteria->add(StudentTableMap::COL_PHONE_NUMBER, $this->phone_number);
}
if ($this->isColumnModified(StudentTableMap::COL_CREATED_AT)) {
$criteria->add(StudentTableMap::COL_CREATED_AT, $this->created_at);
}
if ($this->isColumnModified(StudentTableMap::COL_UPDATED_AT)) {
$criteria->add(StudentTableMap::COL_UPDATED_AT, $this->updated_at);
}
return $criteria;
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(JaCategoriasTableMap::DATABASE_NAME);
if ($this->isColumnModified(JaCategoriasTableMap::COL_ID)) {
$criteria->add(JaCategoriasTableMap::COL_ID, $this->id);
}
if ($this->isColumnModified(JaCategoriasTableMap::COL_TITULO)) {
$criteria->add(JaCategoriasTableMap::COL_TITULO, $this->titulo);
}
if ($this->isColumnModified(JaCategoriasTableMap::COL_SLUG)) {
$criteria->add(JaCategoriasTableMap::COL_SLUG, $this->slug);
}
return $criteria;
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(JaPaginaCategoriasTableMap::DATABASE_NAME);
if ($this->isColumnModified(JaPaginaCategoriasTableMap::COL_ID)) {
$criteria->add(JaPaginaCategoriasTableMap::COL_ID, $this->id);
}
if ($this->isColumnModified(JaPaginaCategoriasTableMap::COL_ID_PAGINA)) {
$criteria->add(JaPaginaCategoriasTableMap::COL_ID_PAGINA, $this->id_pagina);
}
if ($this->isColumnModified(JaPaginaCategoriasTableMap::COL_ID_CATEGORIA)) {
$criteria->add(JaPaginaCategoriasTableMap::COL_ID_CATEGORIA, $this->id_categoria);
}
return $criteria;
}
/**
* Gets all the versions of this object, in incremental order
*
* @param ConnectionInterface $con the connection to use
*
* @return ObjectCollection A list of ChildContentVersion objects
*/
public function getAllVersions($con = null)
{
$criteria = new Criteria();
$criteria->addAscendingOrderByColumn(ContentVersionTableMap::VERSION);
return $this->getContentVersions($criteria, $con);
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(SessionTableMap::DATABASE_NAME);
if ($this->isColumnModified(SessionTableMap::COL_TOKEN)) {
$criteria->add(SessionTableMap::COL_TOKEN, $this->token);
}
if ($this->isColumnModified(SessionTableMap::COL_USER_ID)) {
$criteria->add(SessionTableMap::COL_USER_ID, $this->user_id);
}
if ($this->isColumnModified(SessionTableMap::COL_IP)) {
$criteria->add(SessionTableMap::COL_IP, $this->ip);
}
if ($this->isColumnModified(SessionTableMap::COL_USER_AGENT)) {
$criteria->add(SessionTableMap::COL_USER_AGENT, $this->user_agent);
}
if ($this->isColumnModified(SessionTableMap::COL_BROWSER)) {
$criteria->add(SessionTableMap::COL_BROWSER, $this->browser);
}
if ($this->isColumnModified(SessionTableMap::COL_DEVICE)) {
$criteria->add(SessionTableMap::COL_DEVICE, $this->device);
}
if ($this->isColumnModified(SessionTableMap::COL_OS)) {
$criteria->add(SessionTableMap::COL_OS, $this->os);
}
if ($this->isColumnModified(SessionTableMap::COL_LOCATION)) {
$criteria->add(SessionTableMap::COL_LOCATION, $this->location);
}
if ($this->isColumnModified(SessionTableMap::COL_CREATED_AT)) {
$criteria->add(SessionTableMap::COL_CREATED_AT, $this->created_at);
}
if ($this->isColumnModified(SessionTableMap::COL_UPDATED_AT)) {
$criteria->add(SessionTableMap::COL_UPDATED_AT, $this->updated_at);
}
return $criteria;
}
/**
* Builds a Criteria object containing the primary key for this object.
*
* Unlike buildCriteria() this method includes the primary key values regardless
* of whether or not they have been modified.
*
* @return Criteria The Criteria object containing value(s) for primary key(s).
*/
public function buildPkeyCriteria()
{
$criteria = new Criteria(CouponVersionTableMap::DATABASE_NAME);
$criteria->add(CouponVersionTableMap::ID, $this->id);
$criteria->add(CouponVersionTableMap::VERSION, $this->version);
return $criteria;
}
/**
* Build a Criteria object containing the values of all modified columns in this object.
*
* @return Criteria The Criteria object containing all modified values.
*/
public function buildCriteria()
{
$criteria = new Criteria(DataTableMap::DATABASE_NAME);
if ($this->isColumnModified(DataTableMap::COL_ID)) {
$criteria->add(DataTableMap::COL_ID, $this->id);
}
if ($this->isColumnModified(DataTableMap::COL__FORCONTRIBUTION)) {
$criteria->add(DataTableMap::COL__FORCONTRIBUTION, $this->_forcontribution);
}
if ($this->isColumnModified(DataTableMap::COL__FORTEMPLATEFIELD)) {
$criteria->add(DataTableMap::COL__FORTEMPLATEFIELD, $this->_fortemplatefield);
}
if ($this->isColumnModified(DataTableMap::COL__CONTENT)) {
$criteria->add(DataTableMap::COL__CONTENT, $this->_content);
}
if ($this->isColumnModified(DataTableMap::COL__ISJSON)) {
$criteria->add(DataTableMap::COL__ISJSON, $this->_isjson);
}
if ($this->isColumnModified(DataTableMap::COL___USER__)) {
$criteria->add(DataTableMap::COL___USER__, $this->__user__);
}
if ($this->isColumnModified(DataTableMap::COL___CONFIG__)) {
$criteria->add(DataTableMap::COL___CONFIG__, $this->__config__);
}
if ($this->isColumnModified(DataTableMap::COL___SPLIT__)) {
$criteria->add(DataTableMap::COL___SPLIT__, $this->__split__);
}
if ($this->isColumnModified(DataTableMap::COL___PARENTNODE__)) {
$criteria->add(DataTableMap::COL___PARENTNODE__, $this->__parentnode__);
}
if ($this->isColumnModified(DataTableMap::COL___SORT__)) {
$criteria->add(DataTableMap::COL___SORT__, $this->__sort__);
}
return $criteria;
}
