// | description      | varchar(250) |      |     |            |                |
// | payment_method   | varchar(60)  |      |     |            |                |
// | amount           | float(10,2)  |      |     | 0.00       |                |
// +------------------+--------------+------+-----+------------+----------------+
$do_import_expense = new DataObject($GLOBALS['conx']);
$do_import_expense->setTable("expense_import");
$do_import_expense->query("select * from expense_import order by debit_date desc limit 1");
if ($do_import_expense->getNumRows() > 0) {
    $do_expense = new DataObject($GLOBALS['conx']);
    $do_expense->setTable("expense");
    $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->prepareForm();
    $do_expense->form->event->addEvent("accounting.import_expense_manualy", 1010);
    $do_expense->form->event->addParam("idexpense_import", $do_import_expense->idexpense_import);
    //$do_expense->form->setSubmit("");
    $e_skip = new Event("accounting.import_expense_manualy");
    $e_skip->addParam("idexpense_import", $do_import_expense->idexpense_import);
    $e_skip->addParam("doSave", "yes");
    $e_skip->addParam("insertid", 1);
    echo $e_skip->getLink("Do not import this expense");
    $do_expense->form();
} else {
    echo "No more expenses to import.";
}
?>