PHP TaskPeer::doCount方法代码示例

 /**
  * 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'] . "'";