View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000250NOALYSSBugpublic2011-04-12 19:492011-06-02 01:19
Reporterdanydb Assigned Todanydb  
PrioritynormaleSeveritymineurReproducibilitynon essayé
Status ferméResolutioncorrigé 
Product Version5.5 
Target Version5.6Fixed in Version5.6 
Summary0000250: Problème export CSV historique sans le signe moins pour financier
DescriptionProblème export CSV des journaux sans le signe moins pour financier

Quand on regarde l'historique des opérations et qu'on exporte en CSV, le signe moins disparait

Ajouter test Acc_Ledger::list_operation
=================
00797 // Check ledger type :
00798 if ( $row['jrn_def_type'] == 'FIN' )
00799 {
00800 $positive = $this->db->get_value("select qf_amount from quant_fin where jr_id=$1",
00801 array($row['jr_id']));
Ajouter if ($this->db->count() == 0 )
                $positive == 0
        else

00802 $positive=($positive < 0)?1:0;
00803 }

changer dans impress_jrn.inc.php
=================================
00266 if ( $line['jrn_def_type'] == 'FIN' )
00267 {
-00268 $positive = $cn->count_sql("select * from jrn inner join jrnx on jr_grpt_id=j_grpt ".
-00269 " where jr_id=".$line['jr_id']." and $sql_fin ".
-00270 " and j_debit='f'");
+ $positive = $this->db->get_value("select qf_amount from quant_fin where jr_id=$1",
+ array($row['jr_id']));
+ if ($this->db->count() == 0 )
+ $positive == 0
+ else
+ $positive=($positive < 0)?1:0;
00271
00272 echo "<TD align=\"right\">";
00273 echo ( $positive != 0 )?"<font color=\"red\"> - ".nbm($line['montant'])."</font>":nbm($line['montant']);
00274 echo "</TD>";
00275 }
00276 else
00277 {
00278 echo "<TD align=\"right\">".nbm($line['montant'])."</TD>";
00279 }




+ ajouter signe dans histo_csv
==============================
dans 59 -> retrouver toutes les lignes en une fois sera p-e difficile ?

$cn->prepare('get_from_fin','select qf_amount from quant_fin where jr_id=$1');

+$amount=$res[$i]['jr_montant'];
+if ( $res[$i]['jrn_def_type'] == 'FIN')
+{
+//$this->db->get_value("select qf_amount from quant_fin where jr_id=$1",
+$positive = $cn->execute('get_from_fin',array($row['jr_id']));
+ if ( $this->db->count() == 1) $amount=$positive;
+}
00078 printf('%s',nb($amount));

TagsNo tags attached.
Extension Noalyss

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2011-04-12 19:49 danydb New Issue
2011-04-12 19:49 danydb Status new => assigned
2011-04-12 19:49 danydb Assigned To => danydb
2011-04-12 21:14 danydb Status assigned => resolved
2011-04-12 21:14 danydb Fixed in Version => 5.5
2011-04-12 21:14 danydb Resolution open => fixed
2011-05-25 23:20 danydb Target Version 5.5 => 5.6
2011-05-25 23:20 danydb Fixed in Version 5.5 => 5.6
2011-06-02 01:19 danydb Status resolved => closed