Author: josx Date: 2007-04-25 12:07:43 -0300 (Wed, 25 Apr 2007) New Revision: 4566 Added: prosistem/alba/trunk/alba/lib/model/Evento.php prosistem/alba/trunk/alba/lib/model/EventoPeer.php prosistem/alba/trunk/alba/lib/model/map/EventoMapBuilder.php prosistem/alba/trunk/alba/lib/model/om/BaseEvento.php prosistem/alba/trunk/alba/lib/model/om/BaseEventoPeer.php Modified: prosistem/alba/trunk/alba/apps/principal/modules/calendario/actions/actions.class.php prosistem/alba/trunk/alba/config/schema.xml prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql prosistem/alba/trunk/alba/data/sql/schema.sql Log: Se agrego la tabla eventos Modified: prosistem/alba/trunk/alba/apps/principal/modules/calendario/actions/actions.class.php =================================================================== --- prosistem/alba/trunk/alba/apps/principal/modules/calendario/actions/actions.class.php 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/apps/principal/modules/calendario/actions/actions.class.php 2007-04-25 15:07:43 UTC (rev 4566) @@ -657,5 +657,4 @@ } } - ?> \ No newline at end of file Modified: prosistem/alba/trunk/alba/config/schema.xml =================================================================== --- prosistem/alba/trunk/alba/config/schema.xml 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/config/schema.xml 2007-04-25 15:07:43 UTC (rev 4566) @@ -716,12 +716,12 @@ </foreign-key> </table> <table name="tipoasistencia" idMethod="native"> - <column name="id" type="integer" size="11" required="true" autoIncrement="true" primaryKey="true"/> - <column name="nombre" type="varchar" size="10" required="true"/> - <column name="descripcion" type="varchar" size="255" required="false" default=""/> - <column name="valor" type="decimal" size="4,2" required="true" default="1"/> - <column name="grupo" type="varchar" size="30" required="false" default=""/> - <column name="defecto" type="boolean" required="true" default="0"/> + <column name="id" type="INTEGER" size="11" required="true" autoIncrement="true" primaryKey="true"/> + <column name="nombre" type="VARCHAR" size="10" required="true"/> + <column name="descripcion" type="VARCHAR" size="255" required="false" default=""/> + <column name="valor" type="DECIMAL" size="4,2" required="true" default="1"/> + <column name="grupo" type="VARCHAR" size="30" required="false" default=""/> + <column name="defecto" type="BOOLEAN" required="true" default="0"/> </table> <table name="rol_responsable" idMethod="native"> <column name="id" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"/> @@ -729,4 +729,15 @@ <column name="descripcion" type="VARCHAR" size="255" default=""/> <column name="activo" type="BOOLEAN" required="true" default="true"/> </table> + <table name="evento" idMethod="native"> + <column name="id" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"/> + <column name="fecha_inicio" type="TIMESTAMP" required="true"/> + <column name="fecha_fin" type="TIMESTAMP" required="true"/> + <column name="tipo" type="INTEGER" required="true" default="0"/> + <column name="frecuencia" type="INTEGER" required="true" default="0"/> + <column name="frecuencia_intervalo" type="INTEGER" required="true" default="0"/> + <column name="recurrencia_fin" type="VARCHAR" size="16" required="false" default=""/> + <column name="recurrencia_dias" type="INTEGER" required="true" default="0"/> + <column name="estado" type="INTEGER" required="true" default="0"/> + </table> </database> \ No newline at end of file Modified: prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql =================================================================== --- prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/data/sql/actualizacion_1.0rc_a_1.0.sql 2007-04-25 15:07:43 UTC (rev 4566) @@ -6,8 +6,6 @@ '96', 'Biblioteca de contenidos', 'sfMediaLibrary', 'informes', '9', '0', '' ); -SET FOREIGN_KEY_CHECKS = 1; - CREATE TABLE `rol_responsable` ( `id` INTEGER NOT NULL AUTO_INCREMENT, @@ -16,3 +14,21 @@ `activo` INTEGER default 1 NOT NULL, PRIMARY KEY (`id`) )Type=InnoDB; + +CREATE TABLE `evento` +( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `fecha_inicio` DATETIME NOT NULL, + `fecha_fin` DATETIME NOT NULL, + `tipo` INTEGER default 0 NOT NULL, + `frecuencia` INTEGER default 0 NOT NULL, + `frecuencia_intervalo` INTEGER default 0 NOT NULL, + `recurrencia_fin` VARCHAR(16) default '', + `recurrencia_dias` INTEGER default 0 NOT NULL, + `estado` INTEGER default 0 NOT NULL, + PRIMARY KEY (`id`) +)Type=InnoDB; + +SET FOREIGN_KEY_CHECKS = 1; + + Modified: prosistem/alba/trunk/alba/data/sql/schema.sql =================================================================== --- prosistem/alba/trunk/alba/data/sql/schema.sql 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/data/sql/schema.sql 2007-04-25 15:07:43 UTC (rev 4566) @@ -1375,5 +1375,42 @@ PRIMARY KEY (`id`) )Type=InnoDB; +#----------------------------------------------------------------------------- +#-- rol_responsable +#----------------------------------------------------------------------------- + +DROP TABLE IF EXISTS `rol_responsable`; + + +CREATE TABLE `rol_responsable` +( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `nombre` VARCHAR(128) default '' NOT NULL, + `descripcion` VARCHAR(255) default '', + `activo` INTEGER default 1 NOT NULL, + PRIMARY KEY (`id`) +)Type=InnoDB; + +#----------------------------------------------------------------------------- +#-- evento +#----------------------------------------------------------------------------- + +DROP TABLE IF EXISTS `evento`; + + +CREATE TABLE `evento` +( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `fecha_inicio` DATETIME NOT NULL, + `fecha_fin` DATETIME NOT NULL, + `tipo` INTEGER default 0 NOT NULL, + `frecuencia` INTEGER default 0 NOT NULL, + `frecuencia_intervalo` INTEGER default 0 NOT NULL, + `recurrencia_fin` VARCHAR(16) default '', + `recurrencia_dias` INTEGER default 0 NOT NULL, + `estado` INTEGER default 0 NOT NULL, + PRIMARY KEY (`id`) +)Type=InnoDB; + # This restores the fkey checks, after having unset them earlier SET FOREIGN_KEY_CHECKS = 1; Added: prosistem/alba/trunk/alba/lib/model/Evento.php =================================================================== --- prosistem/alba/trunk/alba/lib/model/Evento.php 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/lib/model/Evento.php 2007-04-25 15:07:43 UTC (rev 4566) @@ -0,0 +1,12 @@ +<?php + +/** + * Subclass for representing a row from the 'evento' table. + * + * + * + * @package lib.model + */ +class Evento extends BaseEvento +{ +} Property changes on: prosistem/alba/trunk/alba/lib/model/Evento.php ___________________________________________________________________ Name: svn:keywords + "Id Author URL Date Rev" Added: prosistem/alba/trunk/alba/lib/model/EventoPeer.php =================================================================== --- prosistem/alba/trunk/alba/lib/model/EventoPeer.php 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/lib/model/EventoPeer.php 2007-04-25 15:07:43 UTC (rev 4566) @@ -0,0 +1,12 @@ +<?php + +/** + * Subclass for performing query and update operations on the 'evento' table. + * + * + * + * @package lib.model + */ +class EventoPeer extends BaseEventoPeer +{ +} Property changes on: prosistem/alba/trunk/alba/lib/model/EventoPeer.php ___________________________________________________________________ Name: svn:keywords + "Id Author URL Date Rev" Added: prosistem/alba/trunk/alba/lib/model/map/EventoMapBuilder.php =================================================================== --- prosistem/alba/trunk/alba/lib/model/map/EventoMapBuilder.php 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/lib/model/map/EventoMapBuilder.php 2007-04-25 15:07:43 UTC (rev 4566) @@ -0,0 +1,54 @@ +<?php + + + +class EventoMapBuilder { + + + const CLASS_NAME = 'lib.model.map.EventoMapBuilder'; + + + private $dbMap; + + + public function isBuilt() + { + return ($this->dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('alba'); + + $tMap = $this->dbMap->addTable('evento'); + $tMap->setPhpName('Evento'); + + $tMap->setUseIdGenerator(true); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + $tMap->addColumn('FECHA_INICIO', 'FechaInicio', 'int', CreoleTypes::TIMESTAMP, true); + + $tMap->addColumn('FECHA_FIN', 'FechaFin', 'int', CreoleTypes::TIMESTAMP, true); + + $tMap->addColumn('TIPO', 'Tipo', 'int', CreoleTypes::INTEGER, true); + + $tMap->addColumn('FRECUENCIA', 'Frecuencia', 'int', CreoleTypes::INTEGER, true); + + $tMap->addColumn('FRECUENCIA_INTERVALO', 'FrecuenciaIntervalo', 'int', CreoleTypes::INTEGER, true); + + $tMap->addColumn('RECURRENCIA_FIN', 'RecurrenciaFin', 'string', CreoleTypes::VARCHAR, false, 16); + + $tMap->addColumn('RECURRENCIA_DIAS', 'RecurrenciaDias', 'int', CreoleTypes::INTEGER, true); + + $tMap->addColumn('ESTADO', 'Estado', 'int', CreoleTypes::INTEGER, true); + + } +} \ No newline at end of file Property changes on: prosistem/alba/trunk/alba/lib/model/map/EventoMapBuilder.php ___________________________________________________________________ Name: svn:keywords + "Id Author URL Date Rev" Added: prosistem/alba/trunk/alba/lib/model/om/BaseEvento.php =================================================================== --- prosistem/alba/trunk/alba/lib/model/om/BaseEvento.php 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/lib/model/om/BaseEvento.php 2007-04-25 15:07:43 UTC (rev 4566) @@ -0,0 +1,593 @@ +<?php + + +abstract class BaseEvento extends BaseObject implements Persistent { + + + + protected static $peer; + + + + protected $id; + + + + protected $fecha_inicio; + + + + protected $fecha_fin; + + + + protected $tipo = 0; + + + + protected $frecuencia = 0; + + + + protected $frecuencia_intervalo = 0; + + + + protected $recurrencia_fin = ''; + + + + protected $recurrencia_dias = 0; + + + + protected $estado = 0; + + + protected $alreadyInSave = false; + + + protected $alreadyInValidation = false; + + + public function getId() + { + + return $this->id; + } + + + public function getFechaInicio($format = 'Y-m-d H:i:s') + { + + if ($this->fecha_inicio === null || $this->fecha_inicio === '') { + return null; + } elseif (!is_int($this->fecha_inicio)) { + $ts = strtotime($this->fecha_inicio); + if ($ts === -1 || $ts === false) { throw new PropelException("Unable to parse value of [fecha_inicio] as date/time value: " . var_export($this->fecha_inicio, true)); + } + } else { + $ts = $this->fecha_inicio; + } + if ($format === null) { + return $ts; + } elseif (strpos($format, '%') !== false) { + return strftime($format, $ts); + } else { + return date($format, $ts); + } + } + + + public function getFechaFin($format = 'Y-m-d H:i:s') + { + + if ($this->fecha_fin === null || $this->fecha_fin === '') { + return null; + } elseif (!is_int($this->fecha_fin)) { + $ts = strtotime($this->fecha_fin); + if ($ts === -1 || $ts === false) { throw new PropelException("Unable to parse value of [fecha_fin] as date/time value: " . var_export($this->fecha_fin, true)); + } + } else { + $ts = $this->fecha_fin; + } + if ($format === null) { + return $ts; + } elseif (strpos($format, '%') !== false) { + return strftime($format, $ts); + } else { + return date($format, $ts); + } + } + + + public function getTipo() + { + + return $this->tipo; + } + + + public function getFrecuencia() + { + + return $this->frecuencia; + } + + + public function getFrecuenciaIntervalo() + { + + return $this->frecuencia_intervalo; + } + + + public function getRecurrenciaFin() + { + + return $this->recurrencia_fin; + } + + + public function getRecurrenciaDias() + { + + return $this->recurrencia_dias; + } + + + public function getEstado() + { + + return $this->estado; + } + + + public function setId($v) + { + + if ($this->id !== $v) { + $this->id = $v; + $this->modifiedColumns[] = EventoPeer::ID; + } + + } + + public function setFechaInicio($v) + { + + if ($v !== null && !is_int($v)) { + $ts = strtotime($v); + if ($ts === -1 || $ts === false) { throw new PropelException("Unable to parse date/time value for [fecha_inicio] from input: " . var_export($v, true)); + } + } else { + $ts = $v; + } + if ($this->fecha_inicio !== $ts) { + $this->fecha_inicio = $ts; + $this->modifiedColumns[] = EventoPeer::FECHA_INICIO; + } + + } + + public function setFechaFin($v) + { + + if ($v !== null && !is_int($v)) { + $ts = strtotime($v); + if ($ts === -1 || $ts === false) { throw new PropelException("Unable to parse date/time value for [fecha_fin] from input: " . var_export($v, true)); + } + } else { + $ts = $v; + } + if ($this->fecha_fin !== $ts) { + $this->fecha_fin = $ts; + $this->modifiedColumns[] = EventoPeer::FECHA_FIN; + } + + } + + public function setTipo($v) + { + + if ($this->tipo !== $v || $v === 0) { + $this->tipo = $v; + $this->modifiedColumns[] = EventoPeer::TIPO; + } + + } + + public function setFrecuencia($v) + { + + if ($this->frecuencia !== $v || $v === 0) { + $this->frecuencia = $v; + $this->modifiedColumns[] = EventoPeer::FRECUENCIA; + } + + } + + public function setFrecuenciaIntervalo($v) + { + + if ($this->frecuencia_intervalo !== $v || $v === 0) { + $this->frecuencia_intervalo = $v; + $this->modifiedColumns[] = EventoPeer::FRECUENCIA_INTERVALO; + } + + } + + public function setRecurrenciaFin($v) + { + + if ($this->recurrencia_fin !== $v || $v === '') { + $this->recurrencia_fin = $v; + $this->modifiedColumns[] = EventoPeer::RECURRENCIA_FIN; + } + + } + + public function setRecurrenciaDias($v) + { + + if ($this->recurrencia_dias !== $v || $v === 0) { + $this->recurrencia_dias = $v; + $this->modifiedColumns[] = EventoPeer::RECURRENCIA_DIAS; + } + + } + + public function setEstado($v) + { + + if ($this->estado !== $v || $v === 0) { + $this->estado = $v; + $this->modifiedColumns[] = EventoPeer::ESTADO; + } + + } + + public function hydrate(ResultSet $rs, $startcol = 1) + { + try { + + $this->id = $rs->getInt($startcol + 0); + + $this->fecha_inicio = $rs->getTimestamp($startcol + 1, null); + + $this->fecha_fin = $rs->getTimestamp($startcol + 2, null); + + $this->tipo = $rs->getInt($startcol + 3); + + $this->frecuencia = $rs->getInt($startcol + 4); + + $this->frecuencia_intervalo = $rs->getInt($startcol + 5); + + $this->recurrencia_fin = $rs->getString($startcol + 6); + + $this->recurrencia_dias = $rs->getInt($startcol + 7); + + $this->estado = $rs->getInt($startcol + 8); + + $this->resetModified(); + + $this->setNew(false); + + return $startcol + 9; + } catch (Exception $e) { + throw new PropelException("Error populating Evento object", $e); + } + } + + + public function delete($con = null) + { + if ($this->isDeleted()) { + throw new PropelException("This object has already been deleted."); + } + + if ($con === null) { + $con = Propel::getConnection(EventoPeer::DATABASE_NAME); + } + + try { + $con->begin(); + EventoPeer::doDelete($this, $con); + $this->setDeleted(true); + $con->commit(); + } catch (PropelException $e) { + $con->rollback(); + throw $e; + } + } + + + public function save($con = null) + { + if ($this->isDeleted()) { + throw new PropelException("You cannot save an object that has been deleted."); + } + + if ($con === null) { + $con = Propel::getConnection(EventoPeer::DATABASE_NAME); + } + + try { + $con->begin(); + $affectedRows = $this->doSave($con); + $con->commit(); + return $affectedRows; + } catch (PropelException $e) { + $con->rollback(); + throw $e; + } + } + + + protected function doSave($con) + { + $affectedRows = 0; if (!$this->alreadyInSave) { + $this->alreadyInSave = true; + + + if ($this->isModified()) { + if ($this->isNew()) { + $pk = EventoPeer::doInsert($this, $con); + $affectedRows += 1; + $this->setId($pk); + $this->setNew(false); + } else { + $affectedRows += EventoPeer::doUpdate($this, $con); + } + $this->resetModified(); } + + $this->alreadyInSave = false; + } + return $affectedRows; + } + + protected $validationFailures = array(); + + + public function getValidationFailures() + { + return $this->validationFailures; + } + + + public function validate($columns = null) + { + $res = $this->doValidate($columns); + if ($res === true) { + $this->validationFailures = array(); + return true; + } else { + $this->validationFailures = $res; + return false; + } + } + + + protected function doValidate($columns = null) + { + if (!$this->alreadyInValidation) { + $this->alreadyInValidation = true; + $retval = null; + + $failureMap = array(); + + + if (($retval = EventoPeer::doValidate($this, $columns)) !== true) { + $failureMap = array_merge($failureMap, $retval); + } + + + + $this->alreadyInValidation = false; + } + + return (!empty($failureMap) ? $failureMap : true); + } + + + public function getByName($name, $type = BasePeer::TYPE_PHPNAME) + { + $pos = EventoPeer::translateFieldName($name, $type, BasePeer::TYPE_NUM); + return $this->getByPosition($pos); + } + + + public function getByPosition($pos) + { + switch($pos) { + case 0: + return $this->getId(); + break; + case 1: + return $this->getFechaInicio(); + break; + case 2: + return $this->getFechaFin(); + break; + case 3: + return $this->getTipo(); + break; + case 4: + return $this->getFrecuencia(); + break; + case 5: + return $this->getFrecuenciaIntervalo(); + break; + case 6: + return $this->getRecurrenciaFin(); + break; + case 7: + return $this->getRecurrenciaDias(); + break; + case 8: + return $this->getEstado(); + break; + default: + return null; + break; + } } + + + public function toArray($keyType = BasePeer::TYPE_PHPNAME) + { + $keys = EventoPeer::getFieldNames($keyType); + $result = array( + $keys[0] => $this->getId(), + $keys[1] => $this->getFechaInicio(), + $keys[2] => $this->getFechaFin(), + $keys[3] => $this->getTipo(), + $keys[4] => $this->getFrecuencia(), + $keys[5] => $this->getFrecuenciaIntervalo(), + $keys[6] => $this->getRecurrenciaFin(), + $keys[7] => $this->getRecurrenciaDias(), + $keys[8] => $this->getEstado(), + ); + return $result; + } + + + public function setByName($name, $value, $type = BasePeer::TYPE_PHPNAME) + { + $pos = EventoPeer::translateFieldName($name, $type, BasePeer::TYPE_NUM); + return $this->setByPosition($pos, $value); + } + + + public function setByPosition($pos, $value) + { + switch($pos) { + case 0: + $this->setId($value); + break; + case 1: + $this->setFechaInicio($value); + break; + case 2: + $this->setFechaFin($value); + break; + case 3: + $this->setTipo($value); + break; + case 4: + $this->setFrecuencia($value); + break; + case 5: + $this->setFrecuenciaIntervalo($value); + break; + case 6: + $this->setRecurrenciaFin($value); + break; + case 7: + $this->setRecurrenciaDias($value); + break; + case 8: + $this->setEstado($value); + break; + } } + + + public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) + { + $keys = EventoPeer::getFieldNames($keyType); + + if (array_key_exists($keys[0], $arr)) $this->setId($arr[$keys[0]]); + if (array_key_exists($keys[1], $arr)) $this->setFechaInicio($arr[$keys[1]]); + if (array_key_exists($keys[2], $arr)) $this->setFechaFin($arr[$keys[2]]); + if (array_key_exists($keys[3], $arr)) $this->setTipo($arr[$keys[3]]); + if (array_key_exists($keys[4], $arr)) $this->setFrecuencia($arr[$keys[4]]); + if (array_key_exists($keys[5], $arr)) $this->setFrecuenciaIntervalo($arr[$keys[5]]); + if (array_key_exists($keys[6], $arr)) $this->setRecurrenciaFin($arr[$keys[6]]); + if (array_key_exists($keys[7], $arr)) $this->setRecurrenciaDias($arr[$keys[7]]); + if (array_key_exists($keys[8], $arr)) $this->setEstado($arr[$keys[8]]); + } + + + public function buildCriteria() + { + $criteria = new Criteria(EventoPeer::DATABASE_NAME); + + if ($this->isColumnModified(EventoPeer::ID)) $criteria->add(EventoPeer::ID, $this->id); + if ($this->isColumnModified(EventoPeer::FECHA_INICIO)) $criteria->add(EventoPeer::FECHA_INICIO, $this->fecha_inicio); + if ($this->isColumnModified(EventoPeer::FECHA_FIN)) $criteria->add(EventoPeer::FECHA_FIN, $this->fecha_fin); + if ($this->isColumnModified(EventoPeer::TIPO)) $criteria->add(EventoPeer::TIPO, $this->tipo); + if ($this->isColumnModified(EventoPeer::FRECUENCIA)) $criteria->add(EventoPeer::FRECUENCIA, $this->frecuencia); + if ($this->isColumnModified(EventoPeer::FRECUENCIA_INTERVALO)) $criteria->add(EventoPeer::FRECUENCIA_INTERVALO, $this->frecuencia_intervalo); + if ($this->isColumnModified(EventoPeer::RECURRENCIA_FIN)) $criteria->add(EventoPeer::RECURRENCIA_FIN, $this->recurrencia_fin); + if ($this->isColumnModified(EventoPeer::RECURRENCIA_DIAS)) $criteria->add(EventoPeer::RECURRENCIA_DIAS, $this->recurrencia_dias); + if ($this->isColumnModified(EventoPeer::ESTADO)) $criteria->add(EventoPeer::ESTADO, $this->estado); + + return $criteria; + } + + + public function buildPkeyCriteria() + { + $criteria = new Criteria(EventoPeer::DATABASE_NAME); + + $criteria->add(EventoPeer::ID, $this->id); + + return $criteria; + } + + + public function getPrimaryKey() + { + return $this->getId(); + } + + + public function setPrimaryKey($key) + { + $this->setId($key); + } + + + public function copyInto($copyObj, $deepCopy = false) + { + + $copyObj->setFechaInicio($this->fecha_inicio); + + $copyObj->setFechaFin($this->fecha_fin); + + $copyObj->setTipo($this->tipo); + + $copyObj->setFrecuencia($this->frecuencia); + + $copyObj->setFrecuenciaIntervalo($this->frecuencia_intervalo); + + $copyObj->setRecurrenciaFin($this->recurrencia_fin); + + $copyObj->setRecurrenciaDias($this->recurrencia_dias); + + $copyObj->setEstado($this->estado); + + + $copyObj->setNew(true); + + $copyObj->setId(NULL); + } + + + public function copy($deepCopy = false) + { + $clazz = get_class($this); + $copyObj = new $clazz(); + $this->copyInto($copyObj, $deepCopy); + return $copyObj; + } + + + public function getPeer() + { + if (self::$peer === null) { + self::$peer = new EventoPeer(); + } + return self::$peer; + } + +} \ No newline at end of file Property changes on: prosistem/alba/trunk/alba/lib/model/om/BaseEvento.php ___________________________________________________________________ Name: svn:keywords + "Id Author URL Date Rev" Added: prosistem/alba/trunk/alba/lib/model/om/BaseEventoPeer.php =================================================================== --- prosistem/alba/trunk/alba/lib/model/om/BaseEventoPeer.php 2007-04-25 13:33:48 UTC (rev 4565) +++ prosistem/alba/trunk/alba/lib/model/om/BaseEventoPeer.php 2007-04-25 15:07:43 UTC (rev 4566) @@ -0,0 +1,403 @@ +<?php + + +abstract class BaseEventoPeer { + + + const DATABASE_NAME = 'alba'; + + + const TABLE_NAME = 'evento'; + + + const CLASS_DEFAULT = 'lib.model.Evento'; + + + const NUM_COLUMNS = 9; + + + const NUM_LAZY_LOAD_COLUMNS = 0; + + + + const ID = 'evento.ID'; + + + const FECHA_INICIO = 'evento.FECHA_INICIO'; + + + const FECHA_FIN = 'evento.FECHA_FIN'; + + + const TIPO = 'evento.TIPO'; + + + const FRECUENCIA = 'evento.FRECUENCIA'; + + + const FRECUENCIA_INTERVALO = 'evento.FRECUENCIA_INTERVALO'; + + + const RECURRENCIA_FIN = 'evento.RECURRENCIA_FIN'; + + + const RECURRENCIA_DIAS = 'evento.RECURRENCIA_DIAS'; + + + const ESTADO = 'evento.ESTADO'; + + + private static $phpNameMap = null; + + + + private static $fieldNames = array ( + BasePeer::TYPE_PHPNAME => array ('Id', 'FechaInicio', 'FechaFin', 'Tipo', 'Frecuencia', 'FrecuenciaIntervalo', 'RecurrenciaFin', 'RecurrenciaDias', 'Estado', ), + BasePeer::TYPE_COLNAME => array (EventoPeer::ID, EventoPeer::FECHA_INICIO, EventoPeer::FECHA_FIN, EventoPeer::TIPO, EventoPeer::FRECUENCIA, EventoPeer::FRECUENCIA_INTERVALO, EventoPeer::RECURRENCIA_FIN, EventoPeer::RECURRENCIA_DIAS, EventoPeer::ESTADO, ), + BasePeer::TYPE_FIELDNAME => array ('id', 'fecha_inicio', 'fecha_fin', 'tipo', 'frecuencia', 'frecuencia_intervalo', 'recurrencia_fin', 'recurrencia_dias', 'estado', ), + BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, ) + ); + + + private static $fieldKeys = array ( + BasePeer::TYPE_PHPNAME => array ('Id' => 0, 'FechaInicio' => 1, 'FechaFin' => 2, 'Tipo' => 3, 'Frecuencia' => 4, 'FrecuenciaIntervalo' => 5, 'RecurrenciaFin' => 6, 'RecurrenciaDias' => 7, 'Estado' => 8, ), + BasePeer::TYPE_COLNAME => array (EventoPeer::ID => 0, EventoPeer::FECHA_INICIO => 1, EventoPeer::FECHA_FIN => 2, EventoPeer::TIPO => 3, EventoPeer::FRECUENCIA => 4, EventoPeer::FRECUENCIA_INTERVALO => 5, EventoPeer::RECURRENCIA_FIN => 6, EventoPeer::RECURRENCIA_DIAS => 7, EventoPeer::ESTADO => 8, ), + BasePeer::TYPE_FIELDNAME => array ('id' => 0, 'fecha_inicio' => 1, 'fecha_fin' => 2, 'tipo' => 3, 'frecuencia' => 4, 'frecuencia_intervalo' => 5, 'recurrencia_fin' => 6, 'recurrencia_dias' => 7, 'estado' => 8, ), + BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, ) + ); + + + public static function getMapBuilder() + { + include_once 'lib/model/map/EventoMapBuilder.php'; + return BasePeer::getMapBuilder('lib.model.map.EventoMapBuilder'); + } + + public static function getPhpNameMap() + { + if (self::$phpNameMap === null) { + $map = EventoPeer::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(EventoPeer::TABLE_NAME.'.', $alias.'.', $column); + } + + + public static function addSelectColumns(Criteria $criteria) + { + + $criteria->addSelectColumn(EventoPeer::ID); + + $criteria->addSelectColumn(EventoPeer::FECHA_INICIO); + + $criteria->addSelectColumn(EventoPeer::FECHA_FIN); + + $criteria->addSelectColumn(EventoPeer::TIPO); + + $criteria->addSelectColumn(EventoPeer::FRECUENCIA); + + $criteria->addSelectColumn(EventoPeer::FRECUENCIA_INTERVALO); + + $criteria->addSelectColumn(EventoPeer::RECURRENCIA_FIN); + + $criteria->addSelectColumn(EventoPeer::RECURRENCIA_DIAS); + + $criteria->addSelectColumn(EventoPeer::ESTADO); + + } + + const COUNT = 'COUNT(evento.ID)'; + const COUNT_DISTINCT = 'COUNT(DISTINCT evento.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(EventoPeer::COUNT_DISTINCT); + } else { + $criteria->addSelectColumn(EventoPeer::COUNT); + } + + foreach($criteria->getGroupByColumns() as $column) + { + $criteria->addSelectColumn($column); + } + + $rs = EventoPeer::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 = EventoPeer::doSelect($critcopy, $con); + if ($objects) { + return $objects[0]; + } + return null; + } + + public static function doSelect(Criteria $criteria, $con = null) + { + return EventoPeer::populateObjects(EventoPeer::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; + EventoPeer::addSelectColumns($criteria); + } + + $criteria->setDbName(self::DATABASE_NAME); + + return BasePeer::doSelect($criteria, $con); + } + + public static function populateObjects(ResultSet $rs) + { + $results = array(); + + $cls = EventoPeer::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 EventoPeer::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(EventoPeer::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(EventoPeer::ID); + $selectCriteria->add(EventoPeer::ID, $criteria->remove(EventoPeer::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(EventoPeer::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(EventoPeer::DATABASE_NAME); + } + + if ($values instanceof Criteria) { + $criteria = clone $values; } elseif ($values instanceof Evento) { + + $criteria = $values->buildPkeyCriteria(); + } else { + $criteria = new Criteria(self::DATABASE_NAME); + $criteria->add(EventoPeer::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(Evento $obj, $cols = null) + { + $columns = array(); + + if ($cols) { + $dbMap = Propel::getDatabaseMap(EventoPeer::DATABASE_NAME); + $tableMap = $dbMap->getTable(EventoPeer::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(EventoPeer::DATABASE_NAME, EventoPeer::TABLE_NAME, $columns); + if ($res !== true) { + $request = sfContext::getInstance()->getRequest(); + foreach ($res as $failed) { + $col = EventoPeer::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(EventoPeer::DATABASE_NAME); + + $criteria->add(EventoPeer::ID, $pk); + + + $v = EventoPeer::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(EventoPeer::ID, $pks, Criteria::IN); + $objs = EventoPeer::doSelect($criteria, $con); + } + return $objs; + } + +} +if (Propel::isInit()) { + try { + BaseEventoPeer::getMapBuilder(); + } catch (Exception $e) { + Propel::log('Could not initialize Peer: ' . $e->getMessage(), Propel::LOG_ERR); + } +} else { + require_once 'lib/model/map/EventoMapBuilder.php'; + Propel::registerMapBuilder('lib.model.map.EventoMapBuilder'); +} Property changes on: prosistem/alba/trunk/alba/lib/model/om/BaseEventoPeer.php ___________________________________________________________________ Name: svn:keywords + "Id Author URL Date Rev"