public static function isValidContext($contextDesc)
{
$db = Zend_Registry::get('my_db');
$context = new Contexts($db);
$where = "lower(context_desc) = lower('{$contextDesc}')";
$result = $context->fetchAll($where);
if ($result->count() > 0) {
return true;
} else {
return false;
}
}
public static function checkContextExist($contextName)
{
$db = Zend_Registry::get('my_db');
$c = new Contexts($db);
$quotedName = $db->quote($contextName);
$result = $c->fetchAll("upper(context_desc) = upper({$quotedName})");
$rows = $result->count();
if ($rows == 0) {
return false;
} else {
switch (DB_TYPE) {
case 'mysql':
$_SESSION['CONTEXT_ID'] = $result[0]->context_id;
break;
case 'oci8':
$_SESSION['CONTEXT_ID'] = $result[0]->CONTEXT_ID;
break;
}
return true;
}
}
private function buildContexts($domElement, $dom)
{
$db = ZitDBAdapter::getDBAdapter();
$contexts = new Contexts($db);
// $query = "select context_desc from context";
// $result = $db->fetchAll($query);
$result = $contexts->fetchAll();
foreach ($result as $row) {
$contextNode = $dom->createElement('SIF_Context');
switch (DB_TYPE) {
case 'mysql':
$contextNode->appendChild($dom->createTextNode($row->context_desc));
break;
case 'oci8':
$contextNode->appendChild($dom->createTextNode($row->CONTEXT_DESC));
break;
}
$domElement->appendChild($contextNode);
}
return $domElement;
}
