function setExpenseAsImported($id)
{
$database = new ExpensesDB();
$database->exec(sprintf("UPDATE expenses SET imported = 1 WHERE id = %s", $id));
}
$data = array();
$i = 0;
if (($handle = fopen($filename, 'r')) !== FALSE) {
while (($row = fgetcsv($handle)) !== FALSE) {
if (!$header) {
$header = $row;
} else {
$data[] = array_combine($header, $row);
}
$i++;
}
fclose($handle);
}
return $data;
}
$expenses_payload = csv_to_array('expenses.csv');
$expenses = [];
foreach ($expenses_payload as $expense_payload) {
$expense = new Expense(DateTime::createFromFormat('Y-m-d', $expense_payload['date']), array_map('strtolower', explode(' ', $expense_payload['tag'])), floatval($expense_payload['amount']));
array_push($expenses, $expense);
// echo $expense->getInsertStatement() . "\n";
}
unset($expenses_payload);
unset($expense_payload);
$database = new ExpensesDB();
foreach ($expenses as $expense) {
if ($expense->amount > 0) {
$database->exec(sprintf("INSERT INTO expenses %s", $expense->getInsertStatement()));
echo ".";
}
}