public static function paintPolitico($id) { $c = new Criteria(); $c->add(SfReviewTypeEntityPeer::ENTITY_ID, $id); $c->add(SfReviewTypeEntityPeer::VALUE, 1); $c->addAscendingOrderByColumn(SfReviewTypeEntityPeer::DATE); $elements = SfReviewTypeEntityPeer::doSelect($c); $sparkline = new Sparkline_Line(); $sparkline->SetDebugLevel(DEBUG_NONE); $sparkline->SetColorHtml('background', '#e0e0e0'); $sparkline->SetColorBackground('background'); $i = 0; foreach ($elements as $element) { $i++; $sparkline->SetData($i, $element->getSum()); } $sparkline->SetYMin(0); $sparkline->SetLineSize(4); $sparkline->RenderResampled(100, 15); $sparkline->Output(); }
/** * Gets an array of SfReviewTypeEntity objects which contain a foreign key that references this object. * * If this collection has already been initialized with an identical Criteria, it returns the collection. * Otherwise if this SfReviewType has previously been saved, it will retrieve * related SfReviewTypeEntitys from storage. If this SfReviewType is new, it will return * an empty collection or the current collection, the criteria is ignored on a new object. * * @param PropelPDO $con * @param Criteria $criteria * @return array SfReviewTypeEntity[] * @throws PropelException */ public function getSfReviewTypeEntitys($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(SfReviewTypePeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collSfReviewTypeEntitys === null) { if ($this->isNew()) { $this->collSfReviewTypeEntitys = array(); } else { $criteria->add(SfReviewTypeEntityPeer::SF_REVIEW_TYPE_ID, $this->id); SfReviewTypeEntityPeer::addSelectColumns($criteria); $this->collSfReviewTypeEntitys = SfReviewTypeEntityPeer::doSelect($criteria, $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 the collection. $criteria->add(SfReviewTypeEntityPeer::SF_REVIEW_TYPE_ID, $this->id); SfReviewTypeEntityPeer::addSelectColumns($criteria); if (!isset($this->lastSfReviewTypeEntityCriteria) || !$this->lastSfReviewTypeEntityCriteria->equals($criteria)) { $this->collSfReviewTypeEntitys = SfReviewTypeEntityPeer::doSelect($criteria, $con); } } } $this->lastSfReviewTypeEntityCriteria = $criteria; return $this->collSfReviewTypeEntitys; }
/** * Retrieve object using using composite pkey values. * @param int $sf_review_type_id * @param int $entity_id * @param string $date * @param int $value * @param PropelPDO $con * @return SfReviewTypeEntity */ public static function retrieveByPK($sf_review_type_id, $entity_id, $date, $value, PropelPDO $con = null) { $key = serialize(array((string) $sf_review_type_id, (string) $entity_id, (string) $date, (string) $value)); if (null !== ($obj = SfReviewTypeEntityPeer::getInstanceFromPool($key))) { return $obj; } if ($con === null) { $con = Propel::getConnection(SfReviewTypeEntityPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $criteria = new Criteria(SfReviewTypeEntityPeer::DATABASE_NAME); $criteria->add(SfReviewTypeEntityPeer::SF_REVIEW_TYPE_ID, $sf_review_type_id); $criteria->add(SfReviewTypeEntityPeer::ENTITY_ID, $entity_id); $criteria->add(SfReviewTypeEntityPeer::DATE, $date); $criteria->add(SfReviewTypeEntityPeer::VALUE, $value); $v = SfReviewTypeEntityPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }