$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);