function handler_default(&$page)
{
- global $globals;
-
$page->changeTpl('trezo/index.tpl');
require_once 'money/trezo.inc.php';
//| debit | decimal(10,2) | | | 0.00 | |
//+--------+---------------+------+-----+------------+----------------+
- $annee_sel = Env::get('annee', date('y'));
- $mois_sel = Env::get('mois', sprintf('%02u', date('m') - (intval(date('m') - 1) % 3)));
+ $annee_sel = Env::v('annee', date('y'));
+ $mois_sel = Env::v('mois', sprintf('%02u', date('m') - (intval(date('m') - 1) % 3)));
$mois_sel_fin = sprintf('%02u',$mois_sel + 2);
$from_date = "$annee_sel-$mois_sel-01";
$page->assign('mon_sel', $mon_sel);
$page->assign_by_ref('month_arr', $trim_fr);
- $page->assign('ops', $globals->xdb->iterator(
+ $page->assign('ops', XDB::iterator(
"SELECT date, label, credit, debit
FROM money_trezo WHERE date >= {?} and date <= {?} order by date",
$from_date, $to_date));
-
- return PL_OK;
}
- function handler_op(&$page)
+ function handler_operation(&$page)
{
- global $globals;
-
$page->changeTpl('trezo/gere_operations.tpl');
require_once 'money/trezo.inc.php';
switch($action) {
case "edit":
if ($op_id) {
- $res = $globals->xdb->query("SELECT date,label,credit,debit FROM money_trezo WHERE id={?}", $op_id);
+ $res = XDB::query("SELECT date,label,credit,debit FROM money_trezo WHERE id={?}", $op_id);
list($op_date,$op_label,$op_credit,$op_debit) = $res->fetchOneRow();
}
break;
if ($op_debit) { $sql .= ',debit='.$op_debit; }
if ($op_id) { $sql .= ",id='$op_id'"; }
- $globals->xdb->execute($sql);
+ XDB::execute($sql);
break;
case "del":
if ($op_id) {
- $globals->xdb->execute("DELETE FROM money_trezo WHERE id={?}", $op_id);
+ XDB::execute("DELETE FROM money_trezo WHERE id={?}", $op_id);
}
break;
}
$page->assign('from_solde', solde_until($from_date));
$page->assign('to_solde', solde_until($to_date));
$page->assign('month_arr', $mois_fr);
- $page->assign('ops', $globals->xdb->iterator(
+ $page->assign('ops', XDB::iterator(
"SELECT id, date, label, credit, debit FROM money_trezo
WHERE date >= {?} and date <= {?} ORDER BY date",
$from_date, $to_date));
-
- return PL_OK;
}
}