/** * Returns the number of related Task objects. * * @param Criteria $criteria * @param boolean $distinct * @param PropelPDO $con * @return int Count of related Task objects. * @throws PropelException */ public function countTasks(Criteria $criteria = null, $distinct = false, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(StatusPeer::DATABASE_NAME); } else { $criteria = clone $criteria; } if ($distinct) { $criteria->setDistinct(); } $count = null; if ($this->collTasks === null) { if ($this->isNew()) { $count = 0; } else { $criteria->add(TaskPeer::STATUS_ID, $this->id); $count = TaskPeer::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(TaskPeer::STATUS_ID, $this->id); if (!isset($this->lastTaskCriteria) || !$this->lastTaskCriteria->equals($criteria)) { $count = TaskPeer::doCount($criteria, false, $con); } else { $count = count($this->collTasks); } } else { $count = count($this->collTasks); } } return $count; }
public function countTasks($criteria = null, $distinct = false, $con = null) { include_once 'lib/model/om/BaseTaskPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(TaskPeer::PROJECT_ID, $this->getId()); return TaskPeer::doCount($criteria, $distinct, $con); }
$oCriteria->addSelectColumn(AppDelegationPeer::TAS_UID); $oCriteria->addSelectColumn(AppDelegationPeer::DEL_INIT_DATE); $oCriteria->addSelectColumn(AppDelegationPeer::DEL_FINISH_DATE); $oDataset = AppDelegationPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow = $oDataset->getRow()) { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(TaskPeer::TAS_UID); $oCriteria->add(TaskPeer::TAS_UID, $aRow['TAS_UID']); $oDataseti = TaskPeer::doSelectRS($oCriteria); $oDataseti->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataseti->next(); $b = 0; while ($aRows = $oDataseti->getRow()) { if (TaskPeer::doCount($oCriteria) == 1) { $b = 1; } $oDataseti->next(); } if ($b == 1) { if ($aRow['DEL_INIT_DATE'] != null && $aRow['DEL_FINISH_DATE'] != null) { $fDuration = $oDates->calculateDuration($aRow['DEL_INIT_DATE'], $aRow['DEL_FINISH_DATE'], null, null, $aRow['TAS_UID']); $oCriteria = new Criteria('workflow'); $sql = "UPDATE APP_DELEGATION SET DEL_DURATION='" . $fDuration . "' \n \t\t\t\t\t\t\t\tWHERE APP_UID='" . $aRow['APP_UID'] . "' AND DEL_INDEX='" . $aRow['DEL_INDEX'] . "'"; $con = Propel::getConnection("workflow"); $stmt = $con->prepareStatement($sql); $rs = $stmt->executeQuery(); } else { $oCriteria = new Criteria('workflow'); $sql = "UPDATE APP_DELEGATION SET DEL_DURATION=0 \n \t\t\t\t\t\t\t\tWHERE APP_UID='" . $aRow['APP_UID'] . "' AND DEL_INDEX='" . $aRow['DEL_INDEX'] . "'";