$category = 35;
$suplier = 53;
}
if (eregi("TRAFFICSWARM", $do_import_expense->description)) {
$category = 16;
}
if (eregi("DELL", $do_import_expense->description)) {
$category = 13;
$suplier = 73;
}
if (eregi("T-MOBILE", $do_import_expense->description)) {
$category = 12;
$category = 119;
}
if ($category != 0) {
$do_expense->newRecord();
$do_expense->num = $do_import_expense->idexpense_import;
$do_expense->description = $do_import_expense->description;
$do_expense->datepayed = $do_import_expense->debit_date;
$do_expense->daterecieve = $do_import_expense->debit_date;
$do_expense->amount = $do_import_expense->amount;
$do_expense->type = $category;
if ($suplier != 0) {
$do_expense->suplier = $suplier;
}
$do_expense->add();
$do_import_expense->delete();
}
}
$disp = new Display($goto);
$disp->addParam("message", "Import completed");
{
list($month, $day, $year) = explode("/", $sheet_date);
return "20" . $year . "-" . $month . "-" . $day;
}
function money2float($money_string)
{
$money_float = str_replace("\$", "", $money_string);
$money_float = str_replace(",", "", $money_float);
return $money_float;
}
if (file_exists($import_file)) {
$fp = fopen($import_file, "r");
$i = 0;
$total = 0;
while ($fields = fgetcsv($fp)) {
$i++;
$do_expense_import->newRecord();
$do_expense_import->category = $fields[0];
$do_expense_import->debit_date = format_sql_date($fields[1]);
$do_expense_import->description = $fields[3];
$do_expense_import->payment_method = $fields[4];
$do_expense_import->amount = money2float($fields[5]);
$do_expense_import->add();
$total += money2float($fields[5]);
$this->setLog("\n insert with: " . $do_expense_import->getSqlQuery());
}
}
$this->setLog("\n imported a total of: " . $total);
$disp = new Display($goto);
$disp->addParam("message", "Import completed");
$this->setDisplayNext($disp);
