public static function CreateSifLogEvents($header, $category, $code, $desc)
{
$db = Zend_Registry::get('my_db');
$xml = XmlHelper::buildSifLogEvent(Utility::createMessageId(), Utility::createTimestamp(), $header, $category, $code, $desc);
$xml = str_replace('xmlns="http://www.sifinfo.org/uk/infrastructure/2.x"', '', $xml);
$xml = str_replace('xmlns="http://www.sifinfo.org/infrastructure/2.x"', '', $xml);
$xml = str_replace('xmlns="http://www.sifinfo.org/infrastructure/1.x"', '', $xml);
$dataObject = new DataObject('sif_logentry');
$query = "select\r\n\t\t\t\t \tagent_registered.agent_id,\r\n\t\t\t\t\tagent_registered.agent_mode_id,\r\n agent_registered.context_id,\r\n agent_registered.zone_id\r\n\t\t\t\t from \r\n\t\t\t\t \t" . DBConvertor::convertCase('agent_registered') . " \r\n\t\t\t\t where \r\n\t\t\t\t \tagent_registered.context_id = " . $_SESSION["CONTEXT_ID"] . " \r\n\t\t\t\t\tand agent_registered.zone_id = " . $_SESSION["ZONE_ID"] . "\r\n\t\t\t\t\tand agent_registered.unregister_timestamp is null";
$result = $db->fetchAll($query);
foreach ($result as $row) {
switch (DB_TYPE) {
case 'mysql':
$agentId = intval($row->agent_id);
$agentModeId = intval($row->agent_mode_id);
$zoneId = intval($row->zone_id);
$contextId = intval($row->context_id);
break;
case 'oci8':
$agentId = intval($row->AGENT_ID);
$agentModeId = intval($row->AGENT_MODE_ID);
$zoneId = intval($row->ZONE_ID);
$contextId = intval($row->CONTEXT_ID);
break;
}
$data = array('event_timestamp' => new Zend_Db_Expr(DBConvertor::convertCurrentTime()), 'agent_id_sender' => intval(0), 'agent_id_rec' => $agentId, 'event_data' => $xml, 'object_id' => $dataObject->objectId, 'action_id' => intval(1), 'zone_id' => $zoneId, 'context_id' => $contextId, 'agent_mode_id' => $agentModeId);
/*
* $db->insert('event', $data);
*/
}
}
