PHP CaseConsolidatedPeer::doSelectRS Beispiele

Beispiel #1

Datei: casesConsolidatedListExtJs.php Projekt: hpx2206/processmaker-1

//cambiar esto por PROPEL //CASE_CONSOLIDATED   TASK
$usrUid = $_SESSION["USER_LOGGED"];

$oCriteria = new Criteria("workflow");
$oCriteria->addSelectColumn("*");
$oCriteria->addSelectColumn(CaseConsolidatedPeer::TAS_UID);
$oCriteria->addJoin(CaseConsolidatedPeer::TAS_UID,ContentPeer::CON_ID, Criteria::LEFT_JOIN);
$oCriteria->addJoin(CaseConsolidatedPeer::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 = CaseConsolidatedPeer::doSelectRS($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
//$oDataset->next();
while ($oDataset->next()) {
    $aRow = $oDataset->getRow();
    //$aTaskConsolidated [] = $aRow;
}

$query = "SELECT *
          FROM   CASE_CONSOLIDATED LEFT JOIN CONTENT ON
                 (CASE_CONSOLIDATED.TAS_UID = CONTENT.CON_ID) LEFT JOIN TASK ON (CASE_CONSOLIDATED.TAS_UID = TASK.TAS_UID)
          WHERE  CONTENT.CON_CATEGORY='TAS_TITLE' AND CONTENT.CON_LANG='en'";
$aTaskConsolidated = executeQuery($query);

$conf = new Configurations();