コード例 #1
0
 public function executeDdl2argomenti()
 {
     $this->tags = array();
     $c = new Criteria();
     $c->clearSelectColumns();
     $c->addSelectColumn(TaggingPeer::TAG_ID);
     $c->addAsColumn("numtag", "COUNT(" . TaggingPeer::TAG_ID . ")");
     $c->addJoin(TaggingPeer::TAGGABLE_ID, OppAttoPeer::ID);
     $c->add(TaggingPeer::TAGGABLE_MODEL, 'OppAtto');
     $c->add(OppAttoPeer::TIPO_ATTO_ID, 1);
     $c->add(OppAttoPeer::LEGISLATURA, $this->leg);
     if ($this->approvato == true) {
         $c->addJoin(OppAttoPeer::ID, OppAttoHasIterPeer::ATTO_ID);
         $c->add(OppAttoHasIterPeer::ITER_ID, 16);
     }
     $c->addGroupByColumn("TAG_ID");
     $c->addDescendingOrderByColumn("numtag");
     $rs = TaggingPeer::doSelectRS($c);
     while ($rs->next()) {
         $this->tags[] = array($rs->getInt(1), $rs->getInt(2));
     }
 }
コード例 #2
0
ファイル: BaseTaggingPeer.php プロジェクト: sgrove/cothinker
 public static function doCountJoinAll(Criteria $criteria, $distinct = false, $con = null)
 {
     $criteria = clone $criteria;
     $criteria->clearSelectColumns()->clearOrderByColumns();
     if ($distinct || in_array(Criteria::DISTINCT, $criteria->getSelectModifiers())) {
         $criteria->addSelectColumn(TaggingPeer::COUNT_DISTINCT);
     } else {
         $criteria->addSelectColumn(TaggingPeer::COUNT);
     }
     foreach ($criteria->getGroupByColumns() as $column) {
         $criteria->addSelectColumn($column);
     }
     $criteria->addJoin(TaggingPeer::TAG_ID, TagPeer::ID);
     $rs = TaggingPeer::doSelectRS($criteria, $con);
     if ($rs->next()) {
         return $rs->getInt(1);
     } else {
         return 0;
     }
 }