public function setup()
{
$this->setWidgets(array('AgendaTelefonicaDadesID' => new sfWidgetFormInputHidden(), 'AgendaTelefonica_AgendaTelefonicaID' => new sfWidgetFormPropelChoice(array('model' => 'Agendatelefonica', 'add_empty' => false, 'method' => 'hola')), 'Tipus' => new sfWidgetFormChoice(array('choices' => AgendatelefonicadadesPeer::select())), 'Dada' => new sfWidgetFormInputText(), 'Notes' => new sfWidgetFormInputText()));
$this->setValidators(array('AgendaTelefonicaDadesID' => new sfValidatorPropelChoice(array('model' => 'Agendatelefonicadades', 'column' => 'AgendaTelefonicaDadesID', 'required' => false)), 'AgendaTelefonica_AgendaTelefonicaID' => new sfValidatorPropelChoice(array('model' => 'Agendatelefonica', 'column' => 'AgendaTelefonicaID')), 'Tipus' => new sfValidatorString(array('required' => false)), 'Dada' => new sfValidatorString(array('required' => false)), 'Notes' => new sfValidatorString(array('required' => false))));
$this->widgetSchema->setNameFormat("agendatelefonicadades[%s]");
$this->widgetSchema->setFormFormatterName('Span');
$this->errorSchema = new sfValidatorErrorSchema($this->validatorSchema);
unset($this['AgendaTelefonica_AgendaTelefonicaID']);
// parent::setup();
}
/**
* Returns the number of related Agendatelefonicadades objects.
*
* @param Criteria $criteria
* @param boolean $distinct
* @param PropelPDO $con
* @return int Count of related Agendatelefonicadades objects.
* @throws PropelException
*/
public function countAgendatelefonicadadess(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(AgendatelefonicaPeer::DATABASE_NAME);
} else {
$criteria = clone $criteria;
}
if ($distinct) {
$criteria->setDistinct();
}
$count = null;
if ($this->collAgendatelefonicadadess === null) {
if ($this->isNew()) {
$count = 0;
} else {
$criteria->add(AgendatelefonicadadesPeer::AGENDATELEFONICA_AGENDATELEFONICAID, $this->agendatelefonicaid);
$count = AgendatelefonicadadesPeer::doCount($criteria, false, $con);
}
} else {
// criteria has no effect for a new object
if (!$this->isNew()) {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return count of the collection.
$criteria->add(AgendatelefonicadadesPeer::AGENDATELEFONICA_AGENDATELEFONICAID, $this->agendatelefonicaid);
if (!isset($this->lastAgendatelefonicadadesCriteria) || !$this->lastAgendatelefonicadadesCriteria->equals($criteria)) {
$count = AgendatelefonicadadesPeer::doCount($criteria, false, $con);
} else {
$count = count($this->collAgendatelefonicadadess);
}
} else {
$count = count($this->collAgendatelefonicadadess);
}
}
return $count;
}
'<input style="width:10px" type="button" onClick="esborraLinia('+id+');" id="mesmaterial" value="-"></input>' +
'</span>' +
'</div>' +
'</div>';
}
function creaNovaDada()
{
var id = $("#id").val();
id = (parseInt(id) + parseInt(1));
$("#id").val(id);
var select = '<?php
echo AgendatelefonicadadesPeer::getSelectHTML();
?>
';
$("#taula").append(linia(id, 1,'','',select, 0));
}
function creaNovaDadaVella(t, d, n, s, idA)
{
var id = $("#id").val();
id = (parseInt(id) + parseInt(1));
$("#id").val(id);
$("#taula").append(linia(id, t, d, n, s, idA));
public function executeGAgenda($request)
{
$this->setLayout('gestio');
$this->IDS = $this->getUser()->getSessionPar('idS');
//Netegem cerca
if ($request->getParameter('accio') == 'C') {
$this->CERCA = $this->getUser()->setSessionPar('cerca', array('text' => ''));
}
//Inicialitzem les variables
$this->CERCA = $this->getUser()->ParReqSesForm($request, 'cerca', array('text' => ""));
$this->accio = $request->getParameter('accio', 'C');
$this->MODE = "";
$this->P = $request->getParameter('P', 1);
//Tractem el formulari de cerca
$this->FCerca = new CercaForm();
$this->FCerca->bind($this->CERCA);
//Definim l'acció segons el botó premut
if ($this->getRequest()->hasParameter('BNOU')) {
$this->accio = 'N';
}
if ($this->getRequest()->hasParameter('BSAVE')) {
$this->accio = 'S';
}
if ($this->getRequest()->hasParameter('BDELETE')) {
$this->accio = 'D';
}
if ($this->getRequest()->hasParameter('BCERCA')) {
$this->accio = 'L';
}
$this->getUser()->setSessionPar('accio', $this->accio);
switch ($this->accio) {
case 'C':
$this->getUser()->addLogAction('inside', 'gAgenda');
$this->AGENDES = AgendatelefonicadadesPeer::doSearch($this->CERCA['text'], $this->IDS, $this->P);
break;
case 'N':
$this->MODE = 'NOU';
$this->FAgenda = AgendatelefonicaPeer::initialize(0, $this->IDS);
break;
case 'E':
$this->MODE = 'EDICIO';
$AID = $request->getParameter('AID');
$this->FAgenda = AgendatelefonicaPeer::initialize($AID, $this->IDS);
$OAT = $this->FAgenda->getObject();
$this->DADES = $OAT->getAgendatelefonicadadesActiu();
break;
case 'S':
$RA = $request->getParameter('agendatelefonica');
$AID = $RA['AgendaTelefonicaID'];
$this->FAgenda = AgendatelefonicaPeer::initialize($AID, $this->IDS);
$this->FAgenda->bind($RA);
if ($this->FAgenda->isValid()) {
$this->FAgenda->save();
$this->getUser()->addLogAction($this->accio, 'gAgenda', $this->FAgenda->getObject());
myUser::addLogTimeline('alta', 'agenda', $this->getUser()->getSessionPar('idU'), $this->IDS, $this->FAgenda->getObject()->getAgendatelefonicaId());
$this->AID = $this->FAgenda->getObject()->getAgendatelefonicaid();
AgendatelefonicadadesPeer::update($request->getParameter('Dades'), $this->AID, $this->IDS);
//Actualitzem també les dades relacionades
$this->MISSATGE = "El registre s'ha modificat correctament.";
$this->redirect('gestio/gAgenda?accio=L');
} else {
$this->DADES = $this->FAgenda->getObject()->getAgendatelefonicadadess();
$this->MODE = 'EDICIO';
}
break;
case 'D':
$RA = $request->getParameter('agendatelefonica');
$this->AID = $RA['AgendaTelefonicaID'];
$this->FAgenda = AgendatelefonicaPeer::initialize($this->AID, $this->IDS);
if (!$this->FAgenda->isNew()) {
$this->FAgenda->getObject()->setInactiu();
$this->getUser()->addLogAction($this->accio, 'gAgenda', $this->FAgenda->getObject());
myUser::addLogTimeline('baixa', 'agenda', $this->getUser()->getSessionPar('idU'), $this->IDS, $this->FAgenda->getObject()->getAgendatelefonicaId());
}
break;
default:
$this->AGENDES = AgendatelefonicadadesPeer::doSearch($this->CERCA['text'], $this->IDS, $this->P);
break;
}
if (!empty($this->CERCA)) {
$this->AGENDES = AgendatelefonicadadesPeer::doSearch($this->CERCA['text'], $this->IDS, $this->P);
} else {
$this->AGENDES = array();
}
}
public function getTipusString()
{
return AgendatelefonicadadesPeer::getTipus($this->tipus);
}
/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
* BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
* The default key type is the column's phpname (e.g. 'AuthorId')
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = AgendatelefonicadadesPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setAgendatelefonicadadesid($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setAgendatelefonicaAgendatelefonicaid($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setTipus($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setDada($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setNotes($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setSiteId($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setActiu($arr[$keys[6]]);
}
}
/**
* This is a method for emulating ON DELETE CASCADE for DBs that don't support this
* feature (like MySQL or SQLite).
*
* This method is not very speedy because it must perform a query first to get
* the implicated records and then perform the deletes by calling those Peer classes.
*
* This method should be used within a transaction if possible.
*
* @param Criteria $criteria
* @param PropelPDO $con
* @return int The number of affected rows (if supported by underlying database driver).
*/
protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con)
{
// initialize var to track total num of affected rows
$affectedRows = 0;
// first find the objects that are implicated by the $criteria
$objects = AgendatelefonicaPeer::doSelect($criteria, $con);
foreach ($objects as $obj) {
// delete related Agendatelefonicadades objects
$criteria = new Criteria(AgendatelefonicadadesPeer::DATABASE_NAME);
$criteria->add(AgendatelefonicadadesPeer::AGENDATELEFONICA_AGENDATELEFONICAID, $obj->getAgendatelefonicaid());
$affectedRows += AgendatelefonicadadesPeer::doDelete($criteria, $con);
}
return $affectedRows;
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(AgendatelefonicadadesPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(AgendatelefonicadadesPeer::DATABASE_NAME);
$criteria->add(AgendatelefonicadadesPeer::AGENDATELEFONICADADESID, $pks, Criteria::IN);
$objs = AgendatelefonicadadesPeer::doSelect($criteria, $con);
}
return $objs;
}
<?php
if (empty($AGENDES)) {
echo '<TR><TD class="LINIA" colspan="3">No s\'ha trobat cap resultat d\'entre ' . AgendatelefonicaPeer::getLinies($IDS) . ' disponibles.</TD></TR>';
} else {
$i = 0;
foreach ($AGENDES as $A) {
$SPAN = '<SPAN>';
foreach ($A->getAgendatelefonicadadesActiu() as $ATD) {
$SPAN .= AgendatelefonicadadesPeer::getTipus($ATD->getTipus()) . ': ' . $ATD->getDada() . ' - ' . $ATD->getNotes() . '<BR />';
}
$SPAN .= '</SPAN>';
$PAR = ParImpar($i++);
echo '<TR>
<TD class="' . $PAR . '"><a href="' . url_for('gestio/gAgenda?accio=E&AID=' . $A->getAgendatelefonicaid()) . '" class="tt2" >' . image_tag('template/doc_text_image.png') . $SPAN . '</TD>
<TD class="' . $PAR . '"><a href="' . url_for('gestio/gAgenda?accio=E&AID=' . $A->getAgendatelefonicaid()) . '" class="tt2" >' . $A->getNom() . $SPAN . '</TD>
<TD class="' . $PAR . '">' . $A->getEntitat() . '</TD>
<TD class="' . $PAR . '">' . $A->getTags() . '<TD>
</TR>';
}
}
/*
function ParImpar($i)
{
if($i % 2 == 0) return "PAR";
else return "IPAR";
}
*/
public function getAgendatelefonicadadesActiu()
{
$C = new Criteria();
$C = AgendatelefonicadadesPeer::getCriteriaActiu($C, $this->getSiteId());
return $this->getAgendatelefonicadadess($C);
}
