Esempio n. 1
0
 public static function getCasesNumRec($userUid)
 {
     $cnn = Propel::getConnection("workflow");
     $stmt = $cnn->createStatement();
     //Number of records active
     $criteria = new Criteria("workflow");
     //SELECT
     $criteria->addSelectColumn(CaseConsolidatedCorePeer::CON_STATUS);
     //FROM
     //WHERE
     $criteria->add(CaseConsolidatedCorePeer::CON_STATUS, "ACTIVE");
     $activeNumRec = CaseConsolidatedCorePeer::doCount($criteria);
     //Number of records
     $numRec = 0;
     $sql = "SELECT COUNT(APP_CACHE_VIEW.TAS_UID) AS NUMREC\n                FROM   CASE_CONSOLIDATED\n                       LEFT JOIN APP_CACHE_VIEW ON (CASE_CONSOLIDATED.TAS_UID = APP_CACHE_VIEW.TAS_UID)\n                WHERE  APP_CACHE_VIEW.USR_UID = '{$userUid}' AND\n                       APP_CACHE_VIEW.DEL_THREAD_STATUS = 'OPEN' AND\n                       APP_CACHE_VIEW.APP_STATUS = 'TO_DO'";
     $rsSql = $stmt->executeQuery($sql, ResultSet::FETCHMODE_ASSOC);
     while ($rsSql->next()) {
         $row = $rsSql->getRow();
         $numRec = $row["NUMREC"];
     }
     $numRec = $activeNumRec > 0 ? $numRec : 0;
     return $numRec;
 }
<?php

$action = isset($_REQUEST["action"]) ? $_REQUEST["action"] : "consolidated";
$oCriteria = new Criteria("workflow");
$oCriteria->addSelectColumn(CaseConsolidatedCorePeer::CON_STATUS);
$oCriteria->add(CaseConsolidatedCorePeer::CON_STATUS, "ACTIVE");
$activeNumRows = CaseConsolidatedCorePeer::doCount($oCriteria);
G::LoadClass("BasePeer");
G::LoadClass("configuration");
G::loadClass("pmFunctions");
$headPublisher =& headPublisher::getSingleton();
//cambiar esto por PROPEL //CASE_CONSOLIDATED   TASK
$usrUid = $_SESSION["USER_LOGGED"];
$oCriteria = new Criteria("workflow");
$oCriteria->addSelectColumn("*");
$oCriteria->addSelectColumn(CaseConsolidatedCorePeer::TAS_UID);
$oCriteria->addJoin(CaseConsolidatedCorePeer::TAS_UID, ContentPeer::CON_ID, Criteria::LEFT_JOIN);
$oCriteria->addJoin(CaseConsolidatedCorePeer::TAS_UID, TaskPeer::TAS_UID, Criteria::LEFT_JOIN);
$oCriteria->addAnd(ContentPeer::CON_CATEGORY, "TAS_TITLE");
$oCriteria->addAnd(ContentPeer::CON_LANG, "en");
$params = array();
//This will be filled with the parameters
$sql = BasePeer::createSelectSql($oCriteria, $params);
$oDataset = CaseConsolidatedCorePeer::doSelectRS($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
//$oDataset->next();
while ($oDataset->next()) {
    $aRow = $oDataset->getRow();
    //$aTaskConsolidated [] = $aRow;
}
$query = "SELECT *\n          FROM   CASE_CONSOLIDATED LEFT JOIN CONTENT ON\n                 (CASE_CONSOLIDATED.TAS_UID = CONTENT.CON_ID) LEFT JOIN TASK ON (CASE_CONSOLIDATED.TAS_UID = TASK.TAS_UID)\n          WHERE  CONTENT.CON_CATEGORY='TAS_TITLE' AND CONTENT.CON_LANG='en'";