From 30f5a25ad17ee7e780a43efdb90737dc9ff7572b Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Mon, 9 Feb 2004 16:17:43 +0000
Subject: [PATCH] commit au mauvais endroit (grrrrrr mv sur un CVS/ ...)

---
 htdocs/trezo/gere_operations.php | 99 ++++++++++++++++++++++++++++++++++++++++
 htdocs/trezo/index.php           | 48 +++++++++++++++++++
 2 files changed, 147 insertions(+)
 create mode 100644 htdocs/trezo/gere_operations.php
 create mode 100644 htdocs/trezo/index.php

diff --git a/htdocs/trezo/gere_operations.php b/htdocs/trezo/gere_operations.php
new file mode 100644
index 0000000..5c09152
--- /dev/null
+++ b/htdocs/trezo/gere_operations.php
@@ -0,0 +1,99 @@
+<?php
+require('auto.prepend.inc.php');
+require("trezo.inc.php");
+new_admin_page('trezo/gere_operations.tpl');
+
+//Table operations :
+//+--------+---------------+------+-----+------------+----------------+
+//| Field  | Type          | Null | Key | Default    | Extra          |
+//+--------+---------------+------+-----+------------+----------------+
+//| id     | int(11)       |      | PRI | NULL       | auto_increment |
+//| date   | date          |      |     | 0000-00-00 |                |
+//| label  | varchar(80)   |      |     |            |                |
+//| credit | decimal(10,2) |      |     | 0.00       |                |
+//| debit  | decimal(10,2) |      |     | 0.00       |                |
+//+--------+---------------+------+-----+------------+----------------+
+
+$action = clean_request('action');
+$annee_sel = clean_request('annee');
+$mois_sel = clean_request('mois');
+$operation_id = clean_request('operation_id');
+$operation_date = clean_request('operation_date');
+$operation_label = clean_request('operation_label');
+$operation_credit = clean_request('operation_credit');
+$operation_debit = clean_request('operation_debit');
+
+//selection mois et date
+if (!$annee_sel) $annee_sel = date("Y");
+    
+if ($mois_sel) {
+    $from_date = $annee_sel."-".$mois_sel."-01";
+    $to_date = $annee_sel."-".$mois_sel."-31";
+    $mon_sel = $mois_fr[$mois_sel]." ".$annee_sel;
+} else {
+    $from_date = date("Y-m")."-01";
+    $to_date = date("Y-m")."-31";
+    $mon_sel = $mois_fr[date("m")]." ".date("Y");
+}
+
+switch($action) {
+    case "edit":
+        if ($operation_id) {
+            $res=mysql_query("select date,label,credit,debit from trezo.operations where id='$operation_id'");
+            list($operation_date,$operation_label,$operation_credit,$operation_debit)=mysql_fetch_row($res);
+        }
+    break;
+    case "update":
+        $operation_date = clean_request('operation_date');
+        $operation_label = clean_request('operation_label');
+        $operation_credit = clean_request('operation_credit');
+        $operation_debit = clean_request('operation_debit');
+        $sql_add = "";
+
+        if ($operation_credit)
+            $sql_add = ',credit='.$operation_credit;
+        if ($operation_debit)
+            $sql_add = $sql_add.",debit=".$operation_debit;
+
+        if (isDate($operation_date)){
+            $mydatefr = explode("/",$operation_date);
+            $mydate = $mydatefr[2]."-".$mydatefr[1]."-".$mydatefr[0];
+        }else{
+            $mydate = date("Y-m-d");
+        }
+
+        if ($operation_id) {
+            $sql = "update trezo.operations set date='".$mydate."',label='".$operation_label."'".$sql_add." where id='".$operation_id."'";
+        } else { 
+            $sql = "insert into trezo.operations set date='".$mydate."',label='".$operation_label."'".$sql_add;
+        }
+    break;
+    case "del":
+        if ($operation_id) {
+            mysql_query("delete from trezo.operations where id='".$operation_id."'");
+        }
+    break;
+
+} // $action
+
+$page->assign('operation_id', $operation_id);
+$page->assign('annee_sel', $annee_sel);
+$page->assign('mois_sel', $mois_sel);
+$page->assign('operation_date', $operation_date);
+$page->assign('operation_label', $operation_label);
+$page->assign('operation_debit', $operation_debit);
+$page->assign('operation_credit', $operation_credit);
+$page->assign('mon_sel', $mon_sel);
+
+$page->assign('from_solde', solde_until($from_date));
+$page->assign('to_solde', solde_until($to_date));
+$page->assign_by_ref('month_arr', $mois_fr);
+
+$sql = "SELECT id,date,label,credit,debit 
+        FROM trezo.operations
+        WHERE date >= '$from_date' AND date <= '$to_date' 
+        ORDER BY date";
+$page->mysql_assign($sql, 'ops');
+
+$page->display();
+?>
diff --git a/htdocs/trezo/index.php b/htdocs/trezo/index.php
new file mode 100644
index 0000000..7b98a3a
--- /dev/null
+++ b/htdocs/trezo/index.php
@@ -0,0 +1,48 @@
+<?php
+require("auto.prepend.inc.php");
+require("trezo.inc.php");
+new_admin_page('trezo/index.tpl');
+
+//Table operations :
+//+--------+---------------+------+-----+------------+----------------+
+//| Field  | Type          | Null | Key | Default    | Extra          |
+//+--------+---------------+------+-----+------------+----------------+
+//| id     | int(11)       |      | PRI | NULL       | auto_increment |
+//| date   | date          |      |     | 0000-00-00 |                |
+//| label  | varchar(80)   |      |     |            |                |
+//| credit | decimal(10,2) |      |     | 0.00       |                |
+//| debit  | decimal(10,2) |      |     | 0.00       |                |
+//+--------+---------------+------+-----+------------+----------------+
+
+$annee_sel = clean_request('annee');
+$mois_sel = clean_request('mois');
+
+if(isset($_REQUEST['action']) && $_REQUEST['action']=='lister') {
+    if (!$annee_sel)
+        $annee_sel = date("Y");
+    $mois_sel_fin = sprintf("%02u",$mois_sel + 2);
+
+    $from_date = $annee_sel."-".$mois_sel."-01";
+    $to_date = $annee_sel."-".$mois_sel_fin."-31";
+    $mon_sel = $trim_fr[$mois_sel]." ".$annee_sel;
+} else {
+    $mois_sel = sprintf("%02u", date("m") - (date("m")%3) + 1);
+    $mois_sel_fin = sprintf("%02u",$mois_sel + 2);
+
+    $from_date = date("Y")."-".$mois_sel."-01";
+    $to_date = date("Y")."-".$mois_sel_fin."-31";
+    $mon_sel = $trim_fr[$mois_sel]." ".date("Y");
+}
+
+$page->assign('from_solde', solde_until($from_date));
+$page->assign('to_solde', solde_until($to_date));
+$page->assign('mon_sel', $mon_sel);
+$page->assign_by_ref('month_arr', $trim_fr);
+
+$sql = "SELECT date,label,credit,debit FROM trezo.operations 
+        WHERE date >= '$from_date' and date <= '$to_date'
+        ORDER BY date";
+$page->mysql_assign($sql,'ops');
+
+$page->display();
+?>
-- 
2.1.4