+ if (count($users) > 0) {
+ fwrite($this->file, $this->indentation." <users>\n");
+ foreach ($users as $user_item) {
+ $role_id = $user_item['rank'] == 512 ? 0 : $this->roleMap[$user_item['role_id']]; // Special role_id 0 (not null) for top manager.
+ $user_part = $this->indentation.' '."<user id=\"".$this->userMap[$user_item['id']]."\"";
+ $user_part .= " name=\"".htmlspecialchars($user_item['name'])."\"";
+ $user_part .= " login=\"".htmlspecialchars($user_item['login'])."\"";
+ $user_part .= " password=\"".$user_item['password']."\"";
+ $user_part .= " role_id=\"".$role_id."\"";
+ $user_part .= " client_id=\"".$this->clientMap[$user_item['client_id']]."\"";
+ $user_part .= " rate=\"".$user_item['rate']."\"";
+ $user_part .= " quota_percent=\"".$user_item['quota_percent']."\"";
+ $user_part .= " email=\"".$user_item['email']."\"";
+ $user_part .= " status=\"".$user_item['status']."\"";
+ $user_part .= "></user>\n";
+ fwrite($this->file, $user_part);
+ }
+ fwrite($this->file, $this->indentation." </users>\n");
+ unset($users);
+ unset($user_part);
+ }
+
+ // Write user to project binds.
+ $user_binds = ttTeamHelper::getUserToProjectBinds($this->group_id);
+ if (count($user_binds) > 0) {
+ fwrite($this->file, $this->indentation." <user_project_binds>\n");
+ foreach ($user_binds as $bind) {
+ $user_id = $this->userMap[$bind['user_id']];
+ $project_id = $this->projectMap[$bind['project_id']];
+ $bind_part = $this->indentation.' '."<user_project_bind user_id=\"".$user_id."\"";
+ $bind_part .= " project_id=\"".$project_id."\"";
+ $bind_part .= " rate=\"".$bind['rate']."\"";
+ $bind_part .= " status=\"".$bind['status']."\"";
+ $bind_part .= "></user_project_bind>\n";
+ fwrite($this->file, $bind_part);
+ }
+ fwrite($this->file, $this->indentation." </user_project_binds>\n");
+ unset($user_binds);
+ unset($bind_part);
+ }
+
+ // Write timesheets.
+ if (count($timesheets) > 0) {
+ fwrite($this->file, $this->indentation." <timesheets>\n");
+ foreach ($timesheets as $timesheet_item) {
+ $timesheet_part = $this->indentation.' '."<timesheet id=\"".$this->timesheetMap[$timesheet_item['id']]."\"";
+ $timesheet_part .= " user_id=\"".$this->userMap[$timesheet_item['user_id']]."\"";
+ $timesheet_part .= " client_id=\"".$this->clientMap[$timesheet_item['client_id']]."\"";
+ $timesheet_part .= " project_id=\"".$this->projectMap[$timesheet_item['project_id']]."\"";
+ $timesheet_part .= " name=\"".htmlspecialchars($timesheet_item['name'])."\"";
+ $timesheet_part .= " comment=\"".htmlspecialchars($timesheet_item['comment'])."\"";
+ $timesheet_part .= " start_date=\"".$timesheet_item['start_date']."\"";
+ $timesheet_part .= " end_date=\"".$timesheet_item['end_date']."\"";
+ $timesheet_part .= " submit_status=\"".$timesheet_item['submit_status']."\"";
+ $timesheet_part .= " approve_status=\"".$timesheet_item['approve_status']."\"";
+ $timesheet_part .= " approve_comment=\"".htmlspecialchars($timesheet_item['approve_comment'])."\"";
+ $timesheet_part .= " status=\"".$timesheet_item['status']."\"";
+ $timesheet_part .= "></timesheet>\n";
+ fwrite($this->file, $timesheet_part);
+ }
+ fwrite($this->file, $this->indentation." </timesheets>\n");
+ unset($timesheets);
+ unset($timesheet_part);
+ }
+
+ // Write invoices.
+ if (count($invoices) > 0) {
+ fwrite($this->file, $this->indentation." <invoices>\n");
+ foreach ($invoices as $invoice_item) {
+ $invoice_part = $this->indentation.' '."<invoice id=\"".$this->invoiceMap[$invoice_item['id']]."\"";
+ $invoice_part .= " name=\"".htmlspecialchars($invoice_item['name'])."\"";
+ $invoice_part .= " date=\"".$invoice_item['date']."\"";
+ $invoice_part .= " client_id=\"".$this->clientMap[$invoice_item['client_id']]."\"";
+ $invoice_part .= " status=\"".$invoice_item['status']."\"";
+ $invoice_part .= "></invoice>\n";
+ fwrite($this->file, $invoice_part);
+ }
+ fwrite($this->file, $this->indentation." </invoices>\n");
+ unset($invoices);
+ unset($invoice_part);
+ }
+
+ // Write time log entries and build logMap at the same time.
+ // TODO: big data sets get us out of memory error.
+ // We need to optimize this by working on smaller result sets at a time.
+ // tt_log is one potentially large table, but so may be others.
+ // Refactor this during next round of work here.
+ $records = $this->getRecordsFromTable('tt_log');
+ if (count($records) > 0) {
+ fwrite($this->file, $this->indentation." <log>\n");
+ $key = 0;
+ foreach ($records as $record) {
+ $key++;
+ $this->logMap[$record['id']] = $key;
+ $log_part = $this->indentation.' '."<log_item id=\"$key\"";
+ $log_part .= " user_id=\"".$this->userMap[$record['user_id']]."\"";
+ $log_part .= " date=\"".$record['date']."\"";
+ $log_part .= " start=\"".$record['start']."\"";
+ $log_part .= " duration=\"".$record['duration']."\"";
+ $log_part .= " client_id=\"".$this->clientMap[$record['client_id']]."\"";
+ $log_part .= " project_id=\"".$this->projectMap[$record['project_id']]."\"";
+ $log_part .= " task_id=\"".$this->taskMap[$record['task_id']]."\"";
+ $log_part .= " timesheet_id=\"".$this->timesheetMap[$record['timesheet_id']]."\"";
+ $log_part .= " invoice_id=\"".$this->invoiceMap[$record['invoice_id']]."\"";
+ $log_part .= " comment=\"".$this->encodeLineBreaks($record['comment'])."\"";
+ $log_part .= " billable=\"".$record['billable']."\"";
+ $log_part .= " approved=\"".$record['approved']."\"";
+ $log_part .= " paid=\"".$record['paid']."\"";
+ $log_part .= " status=\"".$record['status']."\"";
+ $log_part .= "></log_item>\n";
+ fwrite($this->file, $log_part);
+ }
+ fwrite($this->file, $this->indentation." </log>\n");
+ unset($records);
+ unset($log_part);
+ }
+
+ // Write custom fields.
+ if (count($custom_fields) > 0) {
+ fwrite($this->file, $this->indentation." <custom_fields>\n");
+ foreach ($custom_fields as $custom_field) {
+ $custom_field_part = $this->indentation.' '."<custom_field id=\"".$this->customFieldMap[$custom_field['id']]."\"";
+ $custom_field_part .= " type=\"".$custom_field['type']."\"";
+ $custom_field_part .= " label=\"".htmlspecialchars($custom_field['label'])."\"";
+ $custom_field_part .= " required=\"".$custom_field['required']."\"";
+ $custom_field_part .= " status=\"".$custom_field['status']."\"";
+ $custom_field_part .= "></custom_field>\n";
+ fwrite($this->file, $custom_field_part);
+ }
+ fwrite($this->file, $this->indentation." </custom_fields>\n");
+ unset($custom_fields);
+ unset($custom_field_part);
+ }
+
+ // Write custom field options.
+ if (count($custom_field_options) > 0) {
+ fwrite($this->file, $this->indentation." <custom_field_options>\n");
+ foreach ($custom_field_options as $option) {
+ $custom_field_option_part = $this->indentation.' '."<custom_field_option id=\"".$this->customFieldOptionMap[$option['id']]."\"";
+ $custom_field_option_part .= " field_id=\"".$this->customFieldMap[$option['field_id']]."\"";
+ $custom_field_option_part .= " value=\"".htmlspecialchars($option['value'])."\"";
+ $custom_field_option_part .= "></custom_field_option>\n";
+ fwrite($this->file, $custom_field_option_part);
+ }
+ fwrite($this->file, $this->indentation." </custom_field_options>\n");
+ unset($custom_field_options);
+ unset($custom_field_option_part);
+ }
+
+ // Write custom field log.
+ $custom_field_log = ttTeamHelper::getCustomFieldLog($this->group_id);
+ if (count($custom_field_log) > 0) {
+ fwrite($this->file, $this->indentation." <custom_field_log>\n");
+ foreach ($custom_field_log as $entry) {
+ $custom_field_log_part = $this->indentation.' '."<custom_field_log_entry log_id=\"".$this->logMap[$entry['log_id']]."\"";
+ $custom_field_log_part .= " field_id=\"".$this->customFieldMap[$entry['field_id']]."\"";
+ $custom_field_log_part .= " option_id=\"".$this->customFieldOptionMap[$entry['option_id']]."\"";
+ $custom_field_log_part .= " value=\"".htmlspecialchars($entry['value'])."\"";
+ $custom_field_log_part .= " status=\"".$entry['status']."\"";
+ $custom_field_log_part .= "></custom_field_log_entry>\n";
+ fwrite($this->file, $custom_field_log_part);
+ }
+ fwrite($this->file, $this->indentation." </custom_field_log>\n");
+ unset($custom_field_log);
+ unset($custom_field_log_part);
+ }
+
+ // Write expense items.
+ $expense_items = ttTeamHelper::getExpenseItems($this->group_id);
+ if (count($expense_items) > 0) {
+ fwrite($this->file, $this->indentation." <expense_items>\n");
+ foreach ($expense_items as $expense_item) {
+ $expense_item_part = $this->indentation.' '."<expense_item date=\"".$expense_item['date']."\"";
+ $expense_item_part .= " user_id=\"".$this->userMap[$expense_item['user_id']]."\"";
+ $expense_item_part .= " client_id=\"".$this->clientMap[$expense_item['client_id']]."\"";
+ $expense_item_part .= " project_id=\"".$this->projectMap[$expense_item['project_id']]."\"";
+ $expense_item_part .= " name=\"".$this->encodeLineBreaks($expense_item['name'])."\"";
+ $expense_item_part .= " cost=\"".$expense_item['cost']."\"";
+ $expense_item_part .= " invoice_id=\"".$this->invoiceMap[$expense_item['invoice_id']]."\"";
+ $expense_item_part .= " approved=\"".$expense_item['approved']."\"";
+ $expense_item_part .= " paid=\"".$expense_item['paid']."\"";
+ $expense_item_part .= " status=\"".$expense_item['status']."\"";
+ $expense_item_part .= "></expense_item>\n";
+ fwrite($this->file, $expense_item_part);
+ }
+ fwrite($this->file, $this->indentation." </expense_items>\n");
+ unset($expense_items);
+ unset($expense_item_part);