public function getCirHistorys($criteria = null, $con = null) { include_once 'lib/model/om/BaseCirHistoryPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collCirHistorys === null) { if ($this->isNew()) { $this->collCirHistorys = array(); } else { $criteria->add(CirHistoryPeer::COL_STATUS_ID, $this->getId()); CirHistoryPeer::addSelectColumns($criteria); $this->collCirHistorys = CirHistoryPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(CirHistoryPeer::COL_STATUS_ID, $this->getId()); CirHistoryPeer::addSelectColumns($criteria); if (!isset($this->lastCirHistoryCriteria) || !$this->lastCirHistoryCriteria->equals($criteria)) { $this->collCirHistorys = CirHistoryPeer::doSelect($criteria, $con); } } } $this->lastCirHistoryCriteria = $criteria; return $this->collCirHistorys; }
public function getJobCategory($criteria = null, $con = null) { $c = new Criteria(); $c->add(CirHistoryPeer::MEMBER_ID, $this->getId()); return CirHistoryPeer::doSelect($c); }
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(CirHistoryPeer::ID, $pks, Criteria::IN); $objs = CirHistoryPeer::doSelect($criteria, $con); } return $objs; }
public function executeTest() { $criteria = new Criteria(); $criteria->addAsColumn("jumlah", 'COUNT(' . CirHistoryPeer::MEMBER_ID . ')'); $criteria->addGroupByColumn(CirHistoryPeer::MEMBER_ID); $criteria->setLimit(10); $data = CirHistoryPeer::doSelect($criteria); foreach ($data as $d) { var_dump($d->toArray()); echo '<hr />'; } die; }
public function executeTransaction() { $this->returnModule = 'visitor_list'; $this->returnAction = 'transaction'; $member = MemberPeer::retrieveByPk($this->getRequestParameter('member_id')); $this->forward404Unless($member); $this->member = $member; $actions2 = array(array('name' => '<span>Sirkulasi Koleksi</span>', 'url' => 'visitor_list/transaction?member_id=' . $member->getId(), 'color' => 'sun', 'type' => 'direct')); array_unshift($actions2, array('name' => '<span>Daftar Kunjungan</span>', 'url' => 'visitor_list/list', 'color' => 'sky')); $this->actions2 = $actions2; $code = trim($this->getRequestParameter('code')); if ($code != null && $code != '') { $c = new Criteria(); $c->add(ColItemPeer::INDEX_NO, $code); $ci = ColItemPeer::doSelectOne($c); $c = new Criteria(); $c->add(CirRegulationPeer::DEPARTMENT_ID, $ci->getColLocation()->getDepartmentId()); $c->add(CirRegulationPeer::MEMBER_TYPE_ID, $member->getType()); $c->add(CirRegulationPeer::CAT_CATEGORY_ID, $ci->getCatalog()->getCatCategoryId()); $regulation = CirRegulationPeer::doSelectOne($c); if ($regulation->getCanLoan() === true) { $this->can_loan = true; $this->length = $regulation->getLoanLength(); } $c = new Criteria(); $c->add(CirHistoryPeer::MEMBER_ID, $member->getId()); $c->add(CirHistoryPeer::RETURN_DATE, null); $c->addJoin(CirHistoryPeer::COL_ITEM_ID, ColItemPeer::ID); $c->addJoin(ColItemPeer::CATALOG_ID, CatalogPeer::ID); $c->add(CatalogPeer::CAT_CATEGORY_ID, $regulation->getCatCategoryId()); $cir_hist_array = CirHistoryPeer::doSelect($c); if ($regulation->getMaxLoan() <= count($cir_hist_array)) { $this->max_loan_limit = true; } if ($code != null && $code != '' && $ci != null) { $this->item = $ci; $this->member = $member; $this->regulation = $regulation; $this->_title = 'LoanOrder'; $this->setTemplate('order'); } else { $this->getRequest()->setParameter('code', ''); $this->err_title = 'ERROR_IN_CHECK_OUT'; $this->err_msg = 'ITEM_NOT_FOUND'; } } }
public function executeOrderMember() { $this->returnModule = 'catalog'; $this->returnAction = 'showMemberNondigital?id=' . $this->getRequestParameter('catalog_id'); $member_id = $this->getUser()->getAttribute('user_id', null, 'bo'); $member = MemberPeer::retrieveByPK($member_id); $id = $this->getRequestParameter('id'); $item = ColItemPeer::retrieveByPk($id); $this->forward404Unless($item); $this->forward404Unless($member); $c = new Criteria(); $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c->add(CirRegulationPeer::DEPARTMENT_ID, $dept->getChildRecurs(), Criteria::IN); $c->add(CirRegulationPeer::MEMBER_TYPE_ID, $member->getType()); $c->add(CirRegulationPeer::CAT_CATEGORY_ID, $item->getCatalog()->getCatCategoryId()); $regulation = CirRegulationPeer::doSelectOne($c); if (!$regulation) { $this->forward($this->returnModule, $this->returnAction); } $c = new Criteria(); $c->add(CirHistoryPeer::MEMBER_ID, $member->getId()); $c->add(CirHistoryPeer::RETURN_DATE, null); $c->addJoin(CirHistoryPeer::COL_ITEM_ID, ColItemPeer::ID); $c->addJoin(ColItemPeer::CATALOG_ID, CatalogPeer::ID); $c->add(CatalogPeer::CAT_CATEGORY_ID, $regulation->getCatCategoryId()); $cir_hist_array = CirHistoryPeer::doSelect($c); $this->subtitle = ' ' . $item->toString() . ' - judul:' . $item->getCatalog()->getTitle() . ' (' . $item->getId() . ')'; $this->member = $member; $this->item = $item; $this->regulation = $regulation; $this->can_loan = true; $this->max_loan_limit = false; if ($regulation->getCanLoan() !== true) { $this->can_loan = false; } if ($regulation->getMaxLoan() <= count($cir_hist_array)) { $this->max_loan_limit = true; } }
public function executeOrder() { $this->returnModule = 'catalog'; $this->returnAction = 'listItem'; $this->_title = 'LoanOrder'; $member = MemberPeer::retrieveByCode($this->getRequestParameter('code')); $id = $this->getRequestParameter('id'); $item = ColItemPeer::retrieveByPk($id); $this->forward404Unless($item); $this->forward404Unless($member); $c = new Criteria(); #$dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c->add(CirRegulationPeer::DEPARTMENT_ID, $item->getColLocation()->getDepartmentId()); $c->add(CirRegulationPeer::MEMBER_TYPE_ID, $member->getType()); $c->add(CirRegulationPeer::CAT_CATEGORY_ID, $item->getCatalog()->getCatCategoryId()); $regulation = CirRegulationPeer::doSelectOne($c); if (!$regulation) { $this->forward($this->returnModule, $this->returnAction); } $c = new Criteria(); $c->add(CirHistoryPeer::MEMBER_ID, $member->getId()); $c->add(CirHistoryPeer::RETURN_DATE, null); $c->addJoin(CirHistoryPeer::COL_ITEM_ID, ColItemPeer::ID); $c->addJoin(ColItemPeer::CATALOG_ID, CatalogPeer::ID); $c->add(CatalogPeer::CAT_CATEGORY_ID, $regulation->getCatCategoryId()); $cir_hist_array = CirHistoryPeer::doSelect($c); $this->member = $member; $this->item = $item; $this->regulation = $regulation; $this->can_loan = true; $this->max_loan_limit = false; if ($regulation->getCanLoan() !== true) { $this->can_loan = false; } if ($regulation->getMaxLoan() <= count($cir_hist_array)) { $this->max_loan_limit = true; } }