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); */ } }