X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Ftrezo.php;h=6181ce0f6266858ea8e6ac3a3c5d81cd2bc946b2;hb=2c0315bc77abc3c53b5891d2a8c5d4943fd27143;hp=b0fd027317f33f3ca377c3916f29750a6b5c698c;hpb=fd8f77de8bc10d40395990e3f8e96e0b4a186b46;p=platal.git diff --git a/modules/trezo.php b/modules/trezo.php index b0fd027..6181ce0 100644 --- a/modules/trezo.php +++ b/modules/trezo.php @@ -31,8 +31,6 @@ class TrezoModule extends PLModule function handler_default(&$page) { - global $globals; - $page->changeTpl('trezo/index.tpl'); require_once 'money/trezo.inc.php'; @@ -48,8 +46,8 @@ class TrezoModule extends PLModule //| 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"; @@ -63,7 +61,7 @@ class TrezoModule extends PLModule $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)); @@ -71,8 +69,6 @@ class TrezoModule extends PLModule function handler_operation(&$page) { - global $globals; - $page->changeTpl('trezo/gere_operations.tpl'); require_once 'money/trezo.inc.php'; @@ -96,7 +92,7 @@ class TrezoModule extends PLModule 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; @@ -115,12 +111,12 @@ class TrezoModule extends PLModule 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; } @@ -137,7 +133,7 @@ class TrezoModule extends PLModule $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));