-
Notifications
You must be signed in to change notification settings - Fork 0
/
import_to_toshl.php
71 lines (63 loc) · 1.88 KB
/
import_to_toshl.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?php
require "vendor/autoload.php";
use GuzzleHttp\Client;
use GuzzleHttp\Psr7\Request;
use ToshlImporter\Expense;
use ToshlImporter\ExpensesDB;
$client = new Client([
// Base URI is used with relative requests
'base_uri' => 'https://api.toshl.com',
]);
$token = '732fb6f8-4ea4-411f-b663-575fd9e01fa71470a18792ed4b0a7dc4034226df8e0d';
function getAllExpenses() {
$database = new ExpensesDB;
$results = $database->query('SELECT * FROM expenses');
$expenses = [];
while ($row = $results->fetchArray()) {
array_push($expenses, $row);
}
return $expenses;
}
function getRemaningExpenses() {
$database = new ExpensesDB;
$results = $database->query('SELECT * FROM expenses WHERE imported = 0');
$expenses = [];
while ($row = $results->fetchArray()) {
array_push($expenses, $row);
}
return $expenses;
}
function setExpenseAsImported($id) {
$database = new ExpensesDB;
$database->exec(sprintf("UPDATE expenses SET imported = 1 WHERE id = %s", $id));
}
$expenses = getRemaningExpenses();
$count = 0;
foreach($expenses as $expense) {
$payload = [
'headers' => ['Authorization' => sprintf('Bearer %s', $token)],
'form_params' => [
"currency" => "ARS",
"amount" => $expense['amount'],
"date" => $expense['date'],
"tags" => explode(',', $expense['tags']),
"extra" => ['imported'=>true]
]
];
try {
$response = $client->request(
'POST',
'expenses',
$payload
);
if($response->getStatusCode() == 200 or $response->getStatusCode() == 201) {
setExpenseAsImported($expense['id']);
$count++;
}
echo ".";
} catch (Exception $e) {
var_dump($expense);
echo sprintf("\nStoped after %d with %s", $count, $e->getmessage());
exit;
}
}