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'";