[Noalyss-commit] [noalyss] 07/23: ANCGL : export CSV add the date of payment

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 8e4aa4654374e803c16b73857bb7c08224251a13
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Thu Nov 12 18:00:34 2020 +0100

    ANCGL : export CSV add the date of payment
---
 include/class/anc_grandlivre.class.php | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/include/class/anc_grandlivre.class.php 
b/include/class/anc_grandlivre.class.php
index d8d7991..f6f8aad 100644
--- a/include/class/anc_grandlivre.class.php
+++ b/include/class/anc_grandlivre.class.php
@@ -116,6 +116,7 @@ class Anc_GrandLivre extends Anc_Print
         $array=$this->db->get_array("  select
        po_name,
        to_char(oa_date,'DD.MM.YYYY') as oa_date,
+        to_char(jr_date_paid,'DD.MM.YY') as strdate_paid,
        case when j_poste is null and b.f_id is not null then
         (select ad_value from fiche_detail where fiche_detail.f_id=b.f_id and 
ad_id=".ATTR_DEF_ACCOUNT.")
             when j_poste is not null then
@@ -343,6 +344,7 @@ class Anc_GrandLivre extends Anc_Print
         $aheader=array();
         $aheader[]=array("title"=>'Imp. Analytique','type'=>'string');
         $aheader[]=array("title"=>'Date','type'=>'string');
+        $aheader[]=array("title"=>'Date Pay','type'=>'string');
         $aheader[]=array("title"=>'Poste','type'=>'string');
         $aheader[]=array("title"=>'Quick_Code','type'=>'string');
         $aheader[]=array("title"=>'libelle','type'=>'string');