_docs/_input/db/class_exportXML.inc.php

<?php

abstract class ExportXML
{
    function field($name, $array) {
        $xml = "\t<".$name.">\n";
        foreach ($array as $key => $value) {

            // TODO: If $value is already in utf8 do not encode it
            $value = utf8_encode($value);
            $value = htmlspecialchars($value);

            $xml .= "\t\t<".$key.">".$value."</".$key.">\n";
        }
        $xml .= "\t</".$name.">\n";
        return $xml;
    }

    abstract function doExport();
}

class NetOfficeExport extends ExportXML
{
    var $dbh;
    var $prefix;
    var $streber_ver = '0.048';
    var $person_keys;
    var $company_keys;
    var $project_keys;
    var $task_keys;

    function NetOfficeExport($dbres, $prefix) {
        $this->dbh = $dbres;
        $this->prefix = $prefix;
        $this->person_keys = array( 'nickname',
                                    'password',
                                    'name',
                                    'office_email',
                                    'personal_email',
                                    'office_phone',
                                    'personal_phone',
                                    'mobile_phone',
                                    'office_fax',
                                    'comments',
                                    'profile');

        $this->company_keys = array('name',
                                    'street',
                                    'zipcode',
                                    'phone',
                                    'fax',
                                    'homepage',
                                    'email',
                                    'comments');

        $this->project_keys = array('prio',
                                    'status',
                                    'name',
                                    'description');

        $this->task_keys = array(   'prio',
                                    'status',
                                    'name',
                                    'description',
                                    'date_start',
                                    'date_closed');

    }

    function doExport() {
        $xml = "<streber>\n";
        $xml .= $this->xml_version();
        $xml .= $this->xml_person();
        $xml .= $this->xml_company();
        $xml .= $this->xml_project();
        $xml .= $this->xml_projectperson();
        $xml .= $this->xml_task();
        $xml .= $this->xml_taskperson();
        $xml .= $this->xml_effort();
        $xml .= "</streber>\n";
        return $xml;
    }

    function xml_version() {
        return parent::field('database', array('version' => $this->streber_ver));
    }

    function xml_person() {
        $query = "SELECT * FROM {$this->prefix}members";
        $result = mysql_query($query, $this->dbh);

        $xml = '';
        while ($row = mysql_fetch_assoc($result)) {
            // Don't export admin account
            if (    "1" != $row['id']) {
                $xml .= parent::field('person', array(
//                  'id'            => $row['id'],
//                  '??'            => $row['organization'],
                    'nickname'      => $row['login'],
                    'password'      => $row['password'],
                    'name'          => $row['name'],
//                  '??'            => $row['title'],
                    'office_email'  => $row['email_work'],
                    'personal_email'=> $row['email_home'],
                    'office_phone'  => $row['phone_work'],
                    'personal_phone'=> $row['phone_home'],
                    'mobile_phone'  => $row['mobile'],
                    'office_fax'    => $row['fax'],
                    'comments'      => $row['comments'],
                    'profile'       => $row['profil'],
//                  '??'            => $row['created'],
//                  '??'            => $row['logout_time'],
//                  '??'            => $row['last_page'],
//                  '??'            => $row['timezone'],
                    'can_login'     => '1'));
            }
        }
        return $xml;
    }

    function xml_company() {
        $query = "SELECT * FROM {$this->prefix}organizations";
        $result = mysql_query($query, $this->dbh);

        $xml = '';
        while ($row = mysql_fetch_assoc($result)) {
            $xml .= parent::field('company', array(
//              'id'            => $row['id'],
                'name'          => $row['name'],
                'street'        => $row['address1'],
//              '??'            => $row['address2'],
                'zipcode'       => $row['zip_code'],
//              '??'            => $row['city'],
//              '??'            => $row['country'],
                'phone'         => $row['phone'],
                'fax'           => $row['fax'],
                'homepage'      => $row['url'],
                'email'         => $row['email'],
                'comments'      => $row['comments']
//              '??'            => $row['created'],
//              '??'            => $row['extension_logo'],
//              '??'            => $row['owner'],
            ));
        }
        return $xml;
    }

    function xml_project() {
        $query = "SELECT * FROM {$this->prefix}projects";
        $result = mysql_query($query, $this->dbh);

        $xml = '';
        while ($row = mysql_fetch_assoc($result)) {
            $company_sql = $this->sql_company_query($row['organization']);

            $xml .= parent::field('project', array(
//              'id' => $row['id'],
                'company_sql' => $company_sql,
//              '??' => $row['owner'],
                'prio' => $row['priority'],
                'status' => $row['status'],
                'name' => $row['name'],
                'description' => $row['description'],
//              '??' => $row['url_dev'],
//              '??' => $row['url_prod'],
//              '??' => $row['created'],
//              '??' => $row['modified'],
//              '??' => $row['published'],
//              '??' => $row['upload_max'],
//              '??' => $row['phase_set'],
//              '??' => $row['type'],
            ));
        }
        return $xml;
    }

    function xml_projectperson() {
        $query = "SELECT * FROM {$this->prefix}teams";
        $result = mysql_query($query, $this->dbh);

        $xml = '';
        while ($row = mysql_fetch_assoc($result)) {
            $person_sql = $this->sql_person_query($row['member']);
            $project_sql = $this->sql_project_query($row['project']);

            $xml .= parent::field('projectperson', array(
//              'id'            => $row['id'],
                'project_sql'   => $project_sql,
                'person_sql'    => $person_sql
            ));
        }
        return $xml;
    }

    function xml_task() {
        $query = "SELECT * FROM {$this->prefix}tasks";
        $result = mysql_query($query, $this->dbh);

        $xml = '';
        while ($row = mysql_fetch_assoc($result)) {
            $xml .= parent::field('task', array(
                'prio'          => $row['priority'],
                'status'        => $row['status'],
                'name'          => $row['name'],
//              'description'   => $row['description'],
                'description'   => $row['description'],
                'date_start'    => $row['start_date'],
                'date_closed'   => $row['due_date']
            ));
        }
        return $xml;
    }

    function xml_taskperson() {
        $query = "SELECT id, assigned_to, comments FROM {$this->prefix}tasks";
        $result = mysql_query($query, $this->dbh);

        $xml = '';
        while ($row = mysql_fetch_assoc($result)) {
            $person_sql = $this->sql_person_query($row['assigned_to']);
            $task_sql = $this->sql_task_query($row['id']);

            $xml .= parent::field('taskperson', array(
                'person_sql'    => $person_sql,
                'task_sql'      => $task_sql,
                'comment'       => $row['comments']
            ));

        }
        return $xml;
    }

    function xml_effort() {
        $query = "SELECT * FROM {$this->prefix}tasks_time";
        $result = mysql_query($query, $this->dbh);

        $xml = '';
        while ($row = mysql_fetch_assoc($result)) {
            $project_sql = $this->sql_project_query($row['project']);
            $task_sql = $this->sql_task_query($row['task']);
            $person_sql = $this->sql_person_query($row['owner']);

            $t = strtotime($row['created'])-($row['hours']*60*60);
            $time_start = date("Y-m-d H:i", $t);
            $xml .= parent::field('effort', array(
                'project_sql'   => $project_sql,
                'task_sql'      => $task_sql,
                'person_sql'    => $person_sql,
                'time_start'    => $time_start,
                'time_end'      => $row['created']
//              'as_duration'   => $row['hours']
            ));

        }
        return $xml;
    }

    function array_combine( $keys, $vals ) {
        $keys = array_values( (array) $keys );
        $vals = array_values( (array) $vals );
        $n = max( count( $keys ), count( $vals ) );
        $r = array();

        for( $i=0; $i<$n; $i++ ) {
            $r[ $keys[$i] ] = $vals[$i];
        }
        return $r;
    }

    function sql_company_query($id) {
        $company = mysql_query("SELECT name, address1, zip_code, phone, fax, url, email, comments FROM {$this->prefix}organizations WHERE id = '{$id}'", $this->dbh);

        $company_sql = '';
        if ($company) {
            $res = mysql_fetch_assoc($company);
            $company_values = array(addslashes($res['name']),
                                    addslashes($res['address1']),
                                    addslashes($res['zip_code']),
                                    addslashes($res['phone']),
                                    addslashes($res['fax']),
                                    addslashes($res['url']),
                                    addslashes($res['email']),
                                    addslashes($res['comments']));

            $arr = $this->array_combine($this->company_keys, $company_values);
            $i = 0;
            foreach ($arr as $key => $val) {
                $company_sql .= $key." = '".$val."'";
                if ($i++ < count($arr) - 1) $company_sql .= " AND ";
            }
        }
        return $company_sql;
    }

    function sql_person_query($id) {
        $person = mysql_query("SELECT login, password, name, email_work, email_home, phone_work, phone_home, mobile, fax, comments, profil FROM {$this->prefix}members WHERE id = '{$id}'", $this->dbh);

        $person_sql = '';
        if ($person) {
            $res = mysql_fetch_assoc($person);
            $person_values = array( addslashes($res['login']),
                                    addslashes($res['password']),
                                    addslashes($res['name']),
                                    addslashes($res['email_work']),
                                    addslashes($res['email_home']),
                                    addslashes($res['phone_work']),
                                    addslashes($res['phone_home']),
                                    addslashes($res['mobile']),
                                    addslashes($res['fax']),
                                    addslashes($res['comments']),
                                    addslashes($res['profil']));

            if ($res['login'] == "admin") {
                $person_sql = "nickname = 'admin'";
            } else {
                $arr = $this->array_combine($this->person_keys, $person_values);
                $i = 0;
                foreach ($arr as $key => $val) {
                    $person_sql .= $key." = '".$val."'";
                    if ($i++ < count($arr) - 1) $person_sql .= " AND ";
                }
            }
        }
        return $person_sql;
    }

    function sql_project_query($id) {
        $project = mysql_query("SELECT priority, status, name, description FROM {$this->prefix}projects WHERE id = '{$id}'", $this->dbh);

        $project_sql = '';
        if ($project) {
            $res = mysql_fetch_assoc($project);
            $project_values = array(addslashes($res['priority']),
                                    addslashes($res['status']),
                                    addslashes($res['name']),
                                    addslashes($res['description']));

            $arr = $this->array_combine($this->project_keys, $project_values);
            $i = 0;
            foreach ($arr as $key => $val) {
                $project_sql .= $key." = '".$val."'";
                if ($i++ < count($arr) - 1) $project_sql .= " AND ";
            }
        }
        return $project_sql;
    }

    function sql_task_query($id) {
        $task = mysql_query("SELECT priority, status, name, description, start_date, due_date FROM {$this->prefix}tasks WHERE id = '{$id}'", $this->dbh);

        $task_sql = '';
        if ($task) {
            $res = mysql_fetch_assoc($task);

            if ($res['start_date'] == "--") $res['start_date'] = "0000-00-00";
            if ($res['due_date'] == "--") $res['due_date'] = "0000-00-00";

            $task_values = array(   addslashes($res['priority']),
                                    addslashes($res['status']),
                                    addslashes($res['name']),
                                    addslashes($res['description']),
                                    addslashes($res['start_date']),
                                    addslashes($res['due_date']));

            $arr = $this->array_combine($this->task_keys, $task_values);
            $i = 0;
            foreach ($arr as $key => $val) {
                $task_sql .= $key." = '".$val."'";
                if ($i++ < count($arr) - 1) $task_sql .= " AND ";
            }
        }
        return $task_sql;
    }
}
?>

---