* @version 0.1 * Write XML for sofia.conf */ class sofia_conf extends fs_configuration { public function sofia_conf() { $this -> fs_configuration(); } public function main() { $profiles = $this -> get_profiles(); $this -> write_config($profiles); } /** * Pull the sofia profiles from the db * @return array */ private function get_profiles() { $query = "SELECT * FROM sofia_conf"; $profiles = $this -> db -> queryAll($query); if (FS_PDO::isError($profiles)) { $this -> comment($query); $this -> comment($this -> db -> getMessage()); $this -> file_not_found(); } return $profiles; } /** * Write aliases for current sofia * @param integer $profile_id id of the sofia profile in sofia_conf */ private function write_aliases($profile_id) { $query = "SELECT * FROM sofia_aliases WHERE sofia_id=$profile_id "; $aliases_array = $this -> db -> queryAll($query); $aliases_count = count($aliases_array); if (FS_PDO::isError($aliases_array)) { $this -> comment($query); $this -> comment($this -> db -> getMessage()); return ; } if ($aliases_count < 1) { return ; } $this -> xmlw -> startElement('aliases'); for ($i=0; $i<$aliases_count; $i++) { //$this -> comment_array($aliases_array[$i]); $this -> xmlw -> startElement('alias'); $this -> xmlw -> writeAttribute('name', $aliases_array[$i]['alias_name']); $this -> xmlw -> endElement();// } $this -> xmlw -> endElement(); } /** * Write the for the current profile * @param integer $profile_id id of the sofia profile in sofia_conf */ private function write_settings($profile_id) { $query = "SELECT * FROM sofia_settings WHERE sofia_id=$profile_id " . "ORDER BY sofia_id, param_name"; $settings_array = $this -> db -> queryAll($query); $settings_count = count($settings_array); if (FS_PDO::isError($settings_array)) { $this -> comment($query); $this -> comment($this -> db -> getMessage()); return ; } if ($settings_count < 1) { return ; } $this -> xmlw -> startElement('settings'); for ($i=0; $i<$settings_count; $i++) { //$this -> comment_array($settings_array[$i]); $this -> xmlw -> startElement('param'); $this -> xmlw -> writeAttribute('name', $settings_array[$i]['param_name']); $this -> xmlw -> writeAttribute('value', $settings_array[$i]['param_value']); $this -> xmlw -> endElement();// } $this -> xmlw -> endElement(); } /** * Write XML for current profile * @param integer $profile_id id of the sofia profile in sofia_conf */ private function write_gateways($profile_id) { $query = "SELECT * FROM sofia_gateways WHERE sofia_id=$profile_id " . "ORDER BY gateway_name, gateway_param"; $gateway_array = $this -> db -> queryAll($query); $gateway_count = count($gateway_array); //$this -> comment_array($gateway_array); if (FS_PDO::isError($gateway_array)) { $this -> comment($query); $this -> comment($this -> db -> getMessage()); return ; } if ($gateway_count < 1) { return ; } $this -> xmlw -> startElement('gateways'); for ($i=0; $i<$gateway_count; $i++) { $this_gateway = $gateway_array[$i]['gateway_name']; if (!array_key_exists($i-1, $gateway_array) || $this_gateway != $gateway_array[$i-1]['gateway_name']) { $this -> xmlw -> startElement('gateway'); $this -> xmlw -> writeAttribute('name', $this_gateway); } $this -> xmlw -> startElement('param'); $this -> xmlw -> writeAttribute('name', $gateway_array[$i]['gateway_param']); $this -> xmlw -> writeAttribute('value', $gateway_array[$i]['gateway_value']); $this -> xmlw -> endElement(); if (!array_key_exists($i+1, $gateway_array) || $this_gateway != $gateway_array[$i+1]['gateway_name']) { $this -> xmlw -> endElement(); } $last_gateway = $this_gateway; } $this -> xmlw -> endElement(); // } /** * Write XML for current sofia profile * @param integer $profile_id id of sofia profile in sofia_conf */ private function write_domains($profile_id) { $query = "SELECT * FROM sofia_domains WHERE sofia_id=$profile_id"; $domain_array = $this -> db -> queryAll($query); $domain_count = count($domain_array); if (FS_PDO::isError($domain_array)) { $this -> comment($query); $this -> comment($this -> db -> getMessage()); return ; } if ($domain_count < 1) { return ; } $this -> xmlw -> startElement('domains'); for ($i=0; $i<$domain_count; $i++) { $this -> xmlw -> startElement('domain'); $this -> xmlw -> writeAttribute('name', $domain_array[$i]['domain_name']); $this -> xmlw -> writeAttribute( 'alias', ($domain_array[$i]['alias'] == 1 ? 'true' : 'false') ); $this -> xmlw -> writeAttribute( 'parse', ($domain_array[$i]['parse'] == 1 ? 'true' : 'false') ); $this -> xmlw -> endElement(); } $this -> xmlw -> endElement(); } /** * Write XML for single sofia profile (including all subsections) * This method opens and closes the as well as calling * other methods to complete the other subsections of the XML * @param array $profile array of the current profile */ private function write_single_profile($profile) { $this -> xmlw -> startElement('profile'); $this -> xmlw -> writeAttribute('name', $profile['profile_name']); $this -> write_aliases($profile['id']); $this -> write_domains($profile['id']); $this -> write_gateways($profile['id']); $this -> write_settings($profile['id']); $this -> xmlw -> endElement(); } /** * Iterate over the profiles and write the corresponding XML via other methods * @param array $profiles multi-dimentional array from get_profiles */ private function write_config($profiles) { $profile_count = count($profiles); $this -> xmlw -> startElement('configuration'); $this -> xmlw -> writeAttribute('name', basename(__FILE__, '.php')); $this -> xmlw -> writeAttribute('description', 'Sofia SIP Endpoint'); $this -> xmlw -> startElement('profiles'); for ($i=0; $i<$profile_count; $i++) { $this -> write_single_profile($profiles[$i]); } $this -> xmlw -> endElement(); $this -> xmlw -> endElement(); } } ?>