X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttImportHelper.class.php;h=9b1aad2ac771a637e6114cc58dab603f20e4531e;hb=11cfcc792a4c3578abce0ef3f1b933f3858b5c1d;hp=753dc1654f1184118f763dee12ec92864383e59e;hpb=a0b1d0a4dfd23d96f60c2fe03c9b3682df2fe88f;p=timetracker.git diff --git a/WEB-INF/lib/ttImportHelper.class.php b/WEB-INF/lib/ttImportHelper.class.php index 753dc165..9b1aad2a 100644 --- a/WEB-INF/lib/ttImportHelper.class.php +++ b/WEB-INF/lib/ttImportHelper.class.php @@ -126,11 +126,11 @@ class ttImportHelper { 'project_required' => $this->teamData['PROJECT_REQUIRED'], 'task_required' => $this->teamData['TASK_REQUIRED'], 'record_type' => $this->teamData['RECORD_TYPE'], - 'uncompleted_indicators' => $this->teamData['UNCOMPLETED_INDICATORS'], 'bcc_email' => $this->teamData['BCC_EMAIL'], 'plugins' => $this->teamData['PLUGINS'], 'lock_spec' => $this->teamData['LOCK_SPEC'], - 'workday_hours' => $this->teamData['WORKDAY_HOURS'])); + 'workday_minutes' => $this->teamData['WORKDAY_MINUTES'], + 'config' => $this->teamData['CONFIG'])); if ($team_id) { $this->team_id = $team_id; foreach ($this->users as $key=>$user_item) { @@ -216,7 +216,7 @@ class ttImportHelper { } if ($name == 'MONTHLY_QUOTA' && $this->canImport) { - $this->insertMonthlyQuota($this->team_id, $this->currentElement['YEAR'], $this->currentElement['MONTH'], $this->currentElement['QUOTA']); + $this->insertMonthlyQuota($this->team_id, $this->currentElement['YEAR'], $this->currentElement['MONTH'], $this->currentElement['MINUTES']); } if ($name == 'LOG_ITEM' && $this->canImport) { @@ -273,6 +273,7 @@ class ttImportHelper { 'name' => $this->currentElement['NAME'], 'cost' => $this->currentElement['COST'], 'invoice_id' => $this->invoiceMap[$this->currentElement['INVOICE_ID']], + 'paid' => $this->currentElement['PAID'], 'status' => $this->currentElement['STATUS'])); } @@ -295,18 +296,19 @@ class ttImportHelper { 'period' => $this->currentElement['PERIOD'], 'from' => $this->currentElement['PERIOD_START'], 'to' => $this->currentElement['PERIOD_END'], - 'chclient' => $this->currentElement['SHOW_CLIENT'], - 'chinvoice' => $this->currentElement['SHOW_INVOICE'], - 'chproject' => $this->currentElement['SHOW_PROJECT'], - 'chstart' => $this->currentElement['SHOW_START'], - 'chduration' => $this->currentElement['SHOW_DURATION'], - 'chcost' => $this->currentElement['SHOW_COST'], - 'chtask' => $this->currentElement['SHOW_TASK'], - 'chfinish' => $this->currentElement['SHOW_END'], - 'chnote' => $this->currentElement['SHOW_NOTE'], - 'chcf_1' => $this->currentElement['SHOW_CUSTOM_FIELD_1'], + 'chclient' => (int) $this->currentElement['SHOW_CLIENT'], + 'chinvoice' => (int) $this->currentElement['SHOW_INVOICE'], + 'chpaid' => (int) $this->currentElement['SHOW_PAID'], + 'chproject' => (int) $this->currentElement['SHOW_PROJECT'], + 'chstart' => (int) $this->currentElement['SHOW_START'], + 'chduration' => (int) $this->currentElement['SHOW_DURATION'], + 'chcost' => (int) $this->currentElement['SHOW_COST'], + 'chtask' => (int) $this->currentElement['SHOW_TASK'], + 'chfinish' => (int) $this->currentElement['SHOW_END'], + 'chnote' => (int) $this->currentElement['SHOW_NOTE'], + 'chcf_1' => (int) $this->currentElement['SHOW_CUSTOM_FIELD_1'], 'group_by' => $this->currentElement['GROUP_BY'], - 'chtotalsonly' => $this->currentElement['SHOW_TOTALS_ONLY'])); + 'chtotalsonly' => (int) $this->currentElement['SHOW_TOTALS_ONLY'])); } $this->currentTag = ''; } @@ -408,9 +410,9 @@ class ttImportHelper { } // insertMonthlyQuota - a helper function to insert a monthly quota. - private function insertMonthlyQuota($team_id, $year, $month, $quota) { + private function insertMonthlyQuota($team_id, $year, $month, $minutes) { $mdb2 = getConnection(); - $sql = "INSERT INTO tt_monthly_quotas (team_id, year, month, quota) values ($team_id, $year, $month, $quota)"; + $sql = "INSERT INTO tt_monthly_quotas (team_id, year, month, minutes) values ($team_id, $year, $month, $minutes)"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); }