array ('PaymentId', 'OrdersId', 'PaymentNumber', 'PaymentName', 'PaymentAmount', 'PaymentType', 'DatePosted', 'LastModified', 'PurchaseOrderId', ), BasePeer::TYPE_COLNAME => array (SoPaymentsPeer::PAYMENT_ID, SoPaymentsPeer::ORDERS_ID, SoPaymentsPeer::PAYMENT_NUMBER, SoPaymentsPeer::PAYMENT_NAME, SoPaymentsPeer::PAYMENT_AMOUNT, SoPaymentsPeer::PAYMENT_TYPE, SoPaymentsPeer::DATE_POSTED, SoPaymentsPeer::LAST_MODIFIED, SoPaymentsPeer::PURCHASE_ORDER_ID, ), BasePeer::TYPE_FIELDNAME => array ('payment_id', 'orders_id', 'payment_number', 'payment_name', 'payment_amount', 'payment_type', 'date_posted', 'last_modified', 'purchase_order_id', ), BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, ) ); private static $fieldKeys = array ( BasePeer::TYPE_PHPNAME => array ('PaymentId' => 0, 'OrdersId' => 1, 'PaymentNumber' => 2, 'PaymentName' => 3, 'PaymentAmount' => 4, 'PaymentType' => 5, 'DatePosted' => 6, 'LastModified' => 7, 'PurchaseOrderId' => 8, ), BasePeer::TYPE_COLNAME => array (SoPaymentsPeer::PAYMENT_ID => 0, SoPaymentsPeer::ORDERS_ID => 1, SoPaymentsPeer::PAYMENT_NUMBER => 2, SoPaymentsPeer::PAYMENT_NAME => 3, SoPaymentsPeer::PAYMENT_AMOUNT => 4, SoPaymentsPeer::PAYMENT_TYPE => 5, SoPaymentsPeer::DATE_POSTED => 6, SoPaymentsPeer::LAST_MODIFIED => 7, SoPaymentsPeer::PURCHASE_ORDER_ID => 8, ), BasePeer::TYPE_FIELDNAME => array ('payment_id' => 0, 'orders_id' => 1, 'payment_number' => 2, 'payment_name' => 3, 'payment_amount' => 4, 'payment_type' => 5, 'date_posted' => 6, 'last_modified' => 7, 'purchase_order_id' => 8, ), BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, ) ); public static function getMapBuilder() { include_once 'lib/model/map/SoPaymentsMapBuilder.php'; return BasePeer::getMapBuilder('lib.model.map.SoPaymentsMapBuilder'); } public static function getPhpNameMap() { if (self::$phpNameMap === null) { $map = SoPaymentsPeer::getTableMap(); $columns = $map->getColumns(); $nameMap = array(); foreach ($columns as $column) { $nameMap[$column->getPhpName()] = $column->getColumnName(); } self::$phpNameMap = $nameMap; } return self::$phpNameMap; } static public function translateFieldName($name, $fromType, $toType) { $toNames = self::getFieldNames($toType); $key = isset(self::$fieldKeys[$fromType][$name]) ? self::$fieldKeys[$fromType][$name] : null; if ($key === null) { throw new PropelException("'$name' could not be found in the field names of type '$fromType'. These are: " . print_r(self::$fieldKeys[$fromType], true)); } return $toNames[$key]; } static public function getFieldNames($type = BasePeer::TYPE_PHPNAME) { if (!array_key_exists($type, self::$fieldNames)) { throw new PropelException('Method getFieldNames() expects the parameter $type to be one of the class constants TYPE_PHPNAME, TYPE_COLNAME, TYPE_FIELDNAME, TYPE_NUM. ' . $type . ' was given.'); } return self::$fieldNames[$type]; } public static function alias($alias, $column) { return str_replace(SoPaymentsPeer::TABLE_NAME.'.', $alias.'.', $column); } public static function addSelectColumns(Criteria $criteria) { $criteria->addSelectColumn(SoPaymentsPeer::PAYMENT_ID); $criteria->addSelectColumn(SoPaymentsPeer::ORDERS_ID); $criteria->addSelectColumn(SoPaymentsPeer::PAYMENT_NUMBER); $criteria->addSelectColumn(SoPaymentsPeer::PAYMENT_NAME); $criteria->addSelectColumn(SoPaymentsPeer::PAYMENT_AMOUNT); $criteria->addSelectColumn(SoPaymentsPeer::PAYMENT_TYPE); $criteria->addSelectColumn(SoPaymentsPeer::DATE_POSTED); $criteria->addSelectColumn(SoPaymentsPeer::LAST_MODIFIED); $criteria->addSelectColumn(SoPaymentsPeer::PURCHASE_ORDER_ID); } const COUNT = 'COUNT(so_payments.PAYMENT_ID)'; const COUNT_DISTINCT = 'COUNT(DISTINCT so_payments.PAYMENT_ID)'; public static function doCount(Criteria $criteria, $distinct = false, $con = null) { $criteria = clone $criteria; $criteria->clearSelectColumns()->clearOrderByColumns(); if ($distinct || in_array(Criteria::DISTINCT, $criteria->getSelectModifiers())) { $criteria->addSelectColumn(SoPaymentsPeer::COUNT_DISTINCT); } else { $criteria->addSelectColumn(SoPaymentsPeer::COUNT); } foreach($criteria->getGroupByColumns() as $column) { $criteria->addSelectColumn($column); } $rs = SoPaymentsPeer::doSelectRS($criteria, $con); if ($rs->next()) { return $rs->getInt(1); } else { return 0; } } public static function doSelectOne(Criteria $criteria, $con = null) { $critcopy = clone $criteria; $critcopy->setLimit(1); $objects = SoPaymentsPeer::doSelect($critcopy, $con); if ($objects) { return $objects[0]; } return null; } public static function doSelect(Criteria $criteria, $con = null) { return SoPaymentsPeer::populateObjects(SoPaymentsPeer::doSelectRS($criteria, $con)); } public static function doSelectRS(Criteria $criteria, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } if (!$criteria->getSelectColumns()) { $criteria = clone $criteria; SoPaymentsPeer::addSelectColumns($criteria); } $criteria->setDbName(self::DATABASE_NAME); return BasePeer::doSelect($criteria, $con); } public static function populateObjects(ResultSet $rs) { $results = array(); $cls = SoPaymentsPeer::getOMClass(); $cls = Propel::import($cls); while($rs->next()) { $obj = new $cls(); $obj->hydrate($rs); $results[] = $obj; } return $results; } public static function getTableMap() { return Propel::getDatabaseMap(self::DATABASE_NAME)->getTable(self::TABLE_NAME); } public static function getOMClass() { return SoPaymentsPeer::CLASS_DEFAULT; } public static function doInsert($values, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } if ($values instanceof Criteria) { $criteria = clone $values; } else { $criteria = $values->buildCriteria(); } $criteria->remove(SoPaymentsPeer::PAYMENT_ID); $criteria->setDbName(self::DATABASE_NAME); try { $con->begin(); $pk = BasePeer::doInsert($criteria, $con); $con->commit(); } catch(PropelException $e) { $con->rollback(); throw $e; } return $pk; } public static function doUpdate($values, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $selectCriteria = new Criteria(self::DATABASE_NAME); if ($values instanceof Criteria) { $criteria = clone $values; $comparison = $criteria->getComparison(SoPaymentsPeer::PAYMENT_ID); $selectCriteria->add(SoPaymentsPeer::PAYMENT_ID, $criteria->remove(SoPaymentsPeer::PAYMENT_ID), $comparison); } else { $criteria = $values->buildCriteria(); $selectCriteria = $values->buildPkeyCriteria(); } $criteria->setDbName(self::DATABASE_NAME); return BasePeer::doUpdate($selectCriteria, $criteria, $con); } public static function doDeleteAll($con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $affectedRows = 0; try { $con->begin(); $affectedRows += BasePeer::doDeleteAll(SoPaymentsPeer::TABLE_NAME, $con); $con->commit(); return $affectedRows; } catch (PropelException $e) { $con->rollback(); throw $e; } } public static function doDelete($values, $con = null) { if ($con === null) { $con = Propel::getConnection(SoPaymentsPeer::DATABASE_NAME); } if ($values instanceof Criteria) { $criteria = clone $values; } elseif ($values instanceof SoPayments) { $criteria = $values->buildPkeyCriteria(); } else { $criteria = new Criteria(self::DATABASE_NAME); $criteria->add(SoPaymentsPeer::PAYMENT_ID, (array) $values, Criteria::IN); } $criteria->setDbName(self::DATABASE_NAME); $affectedRows = 0; try { $con->begin(); $affectedRows += BasePeer::doDelete($criteria, $con); $con->commit(); return $affectedRows; } catch (PropelException $e) { $con->rollback(); throw $e; } } public static function doValidate(SoPayments $obj, $cols = null) { $columns = array(); if ($cols) { $dbMap = Propel::getDatabaseMap(SoPaymentsPeer::DATABASE_NAME); $tableMap = $dbMap->getTable(SoPaymentsPeer::TABLE_NAME); if (! is_array($cols)) { $cols = array($cols); } foreach($cols as $colName) { if ($tableMap->containsColumn($colName)) { $get = 'get' . $tableMap->getColumn($colName)->getPhpName(); $columns[$colName] = $obj->$get(); } } } else { } $res = BasePeer::doValidate(SoPaymentsPeer::DATABASE_NAME, SoPaymentsPeer::TABLE_NAME, $columns); if ($res !== true) { $request = sfContext::getInstance()->getRequest(); foreach ($res as $failed) { $col = SoPaymentsPeer::translateFieldname($failed->getColumn(), BasePeer::TYPE_COLNAME, BasePeer::TYPE_PHPNAME); $request->setError($col, $failed->getMessage()); } } return $res; } public static function retrieveByPK($pk, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $criteria = new Criteria(SoPaymentsPeer::DATABASE_NAME); $criteria->add(SoPaymentsPeer::PAYMENT_ID, $pk); $v = SoPaymentsPeer::doSelect($criteria, $con); return !empty($v) > 0 ? $v[0] : null; } public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(SoPaymentsPeer::PAYMENT_ID, $pks, Criteria::IN); $objs = SoPaymentsPeer::doSelect($criteria, $con); } return $objs; } } if (Propel::isInit()) { try { BaseSoPaymentsPeer::getMapBuilder(); } catch (Exception $e) { Propel::log('Could not initialize Peer: ' . $e->getMessage(), Propel::LOG_ERR); } } else { require_once 'lib/model/map/SoPaymentsMapBuilder.php'; Propel::registerMapBuilder('lib.model.map.SoPaymentsMapBuilder'); }