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