[Phpcompta-dev] r5490 - in phpcompta/trunk/include: . template

[phpcompta-dev]

Author: danydb
Date: 2013-10-12 22:04:39 +0200 (Sat, 12 Oct 2013)
New Revision: 5490

Modified:
   phpcompta/trunk/include/class_acc_reconciliation.php
   phpcompta/trunk/include/template/impress_reconciliation.php
Log:
task #0000891: Impression des op?\195?\169rations ainsi que les 
op?\195?\169rations rapproch?\195?\169es

Modified: phpcompta/trunk/include/class_acc_reconciliation.php
===================================================================
--- phpcompta/trunk/include/class_acc_reconciliation.php        2013-10-12 
18:00:42 UTC (rev 5489)
+++ phpcompta/trunk/include/class_acc_reconciliation.php        2013-10-12 
20:04:39 UTC (rev 5490)
@@ -255,7 +255,7 @@
     }
     /**
      address@hidden return array of not-reconciled operation
-
+    * Prepare and put in memory the SQL detail_quant
     */
     function get_not_reconciled()
     {
@@ -270,7 +270,7 @@
             $this->jr_id=$array[$i]['jr_id'];
             $ret[$i]['first']=$this->fill_info();
         }
-
+        $this->db->prepare('detail_quant','select * from v_quant_detail where 
jr_id=$1');
         return $ret;
     }
     /**
@@ -302,6 +302,7 @@
     }
     /**
      address@hidden return array of reconciled operation
+     * Prepare and put in memory the SQL detail_quant
      address@hidden
      address@hidden
      address@hidden
@@ -330,10 +331,12 @@
                 $ret[$i]['depend'][$e]=$this->fill_info();
             }
         }
+        $this->db->prepare('detail_quant','select * from v_quant_detail where 
jr_id=$1');
         return $ret;
     }
     /**
      address@hidden
+     * Prepare and put in memory the SQL detail_quant
      address@hidden
      address@hidden
      address@hidden
@@ -389,6 +392,18 @@
       return $sql;
 
     }
+    function show_detail($p_ret)
+    {
+        if (Database::num_row($p_ret)> 0)
+        {
+            echo '<tr class="odd">';
+            echo '<td></td>';
+            echo '<td colspan="5" style="border:1px solid black;width:auto">';
+            include 'template/impress_reconciliation_detail.php';
+            echo '</td>';
+            echo '</tr>';
+        }
+    }
     static function test_me()
     {
         $cn=new Database(dossier::id());

Modified: phpcompta/trunk/include/template/impress_reconciliation.php
===================================================================
--- phpcompta/trunk/include/template/impress_reconciliation.php 2013-10-12 
18:00:42 UTC (rev 5489)
+++ phpcompta/trunk/include/template/impress_reconciliation.php 2013-10-12 
20:04:39 UTC (rev 5490)
@@ -21,6 +21,7 @@
 </tr>
 <?php 
 for ($i=0;$i<count($array);$i++) {
+        
        $r='';
        $r.=td($i);
        $r.=td(format_date($array[$i]['first']['jr_date']));
@@ -31,6 +32,9 @@
        $r.=td($array[$i]['first']['jr_comment']);
        
$r.=td(nbm($array[$i]['first']['jr_montant']),'style="text-align:right"');
        echo tr($r);
+        // check if operation does exist in v_detail_quant
+        
$ret=$a->db->execute('detail_quant',array($array[$i]['first']['jr_id']));
+        $a->show_detail($ret);
        if ( isset($array[$i]['depend']) )
        {
                $limit=count($array[$i]['depend'])-1;
@@ -48,7 +52,10 @@
                                echo '<tr style="border-bottom: 1px solid  
#4f4f7d;">'.$r.'</tr>';
                        else
                                echo tr($r);
+                        
$ret=$a->db->execute('detail_quant',array($array[$i]['depend'][$e]['jr_id']));
+                        $a->show_detail($ret);
                        }
+                         
        }
 }
 ?>



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu