// | 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."; } ?>