public function getItemStatus() { $status = array(); $c = new Criteria(); $c->add(ColItemPeer::CATALOG_ID, $this->getCatalogId(), Criteria::EQUAL); $status[0] = ColItemPeer::doCount($c); $c->add(ColItemPeer::COL_STATUS_ID, ColStatus::AVAILABLE, Criteria::EQUAL); $status[1] = ColItemPeer::doCount($c); $c->remove(ColItemPeer::COL_STATUS_ID); $c->add(ColItemPeer::COL_STATUS_ID, ColStatus::READ, Criteria::EQUAL); $status[2] = ColItemPeer::doCount($c); $c->remove(ColItemPeer::COL_STATUS_ID); $c->add(ColItemPeer::COL_STATUS_ID, ColStatus::LOAN, Criteria::EQUAL); $status[3] = ColItemPeer::doCount($c); return $status; }
</tr> <?php } ?> <tr class='fo_cat_title_cont'> <td style="width: 18%; text-align: left;"><label><?php echo __('Copies'); ?> </label></td> <td style="width: 2%; text-align:center;">:</td> <td style="width: 80%; text-align: left;"> <?php $c = new Criteria(); $c->add(ColItemPeer::CATALOG_ID, $catalog->getId()); $copies = ColItemPeer::doCount($c); echo $copies . ' eksemplar'; ?> </td> </tr> <tr class='fo_cat_title_cont_odd'> <td style="width: 18%; text-align: left;"><label><?php echo __('Available'); ?> </label></td> <td style="width: 2%; text-align:center;">:</td> <td style="width: 80%; text-align: left;"> <?php $status = $catalog->getItemStatus(); echo $status[1] . ' eksemplar'; ?>
public function countColItems($criteria = null, $distinct = false, $con = null) { include_once 'lib/model/om/BaseColItemPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(ColItemPeer::CATALOG_ID, $this->getId()); return ColItemPeer::doCount($criteria, $distinct, $con); }
echo $cat_category->getName() ? $cat_category->toString() : '-'; ?> </td> <td align="left"> <?php $c = new Criteria(); $c->add(CatalogPeer::CAT_CATEGORY_ID, $cat_category->getId()); $count_title = CatalogPeer::doCount($c); echo $count_title > 0 ? $count_title : '-'; ?> </td> <td align="left"> <?php $cw = new Criteria(); $cw->add(CatalogPeer::CAT_CATEGORY_ID, $cat_category->getId()); $cw->addJoin(ColItemPeer::CATALOG_ID, CatalogPeer::ID); $count_copies = ColItemPeer::doCount($cw); echo $count_copies > 0 ? $count_copies : '-'; ?> </td> </tr> <?php } ?> <?php } ?> </tbody> </table> </center>
public function executePrintLabel() { $c = new Criteria(); $c->add(TempTablePeer::EMPLOYEE_ID, 1112); $c->addJoin(ColItemPeer::ID, TempTablePeer::COUNSELING_ID); $c->addDescendingOrderByColumn(ColItemPeer::ID); $col_items = ColItemPeer::doSelect($c); $total = ColItemPeer::doCount($c); $this->forward404Unless($col_items); $this->col_items = $col_items; $this->total = $total; $this->orientation = 'landscape'; $this->papersize = 'label'; $this->setViewClass('sfDomPDF'); }