letter_prop.php

Go to the documentation of this file.

<?php
//This file is part of NOALYSS and is under GPL 
//see licence.txt
?><?php
 
$gDossier=dossier::id();
if ( count($this->content) == 0 ) :
?>
  <h2 class="error"><?php echo _('Désolé aucun résultat trouvé')?></h2>
 
    <?php
  else :
if (DEBUGNOALYSS>1) {
    echo Noalyss\Dbg::hidden_info("linked ",$this->linked);
    echo Noalyss\Dbg::hidden_info("content",$this->content);
}
$delta=0;
?>
<table class="result">
<tr>
<th>
</th>
<th>
   <?php echo _('Lettrage')?>
</th>
<th>
   <?php echo _('Date')?>
</th>
<th>
   <?php echo _('Ref')?>
</th>
<th>
   <?php echo _('Internal')?>
</th>    
<th>
   <?php echo _('Description')?>
</th>
<th style="text-align:right">
   <?php echo _('Débit')?>
</th>
<th style="text-align:right">
   <?php echo _('Crédit')?>
</th>
<th style="text-align:center">
  <?php echo _('Op. concernée')?>
</th>
</tr>
 
<?php
// ???
// $this->content=array_merge($this->linked,$this->content);
$amount_deb=($j_debit=='t')?$amount_init:0;
$amount_cred=($j_debit=='f')?$amount_init:0;
 
$linked_limit=count($this->linked);
 
for ($i=0;$i<count($this->content);$i++):
  $class="";
$class= ( ($i % 2) == 0 ) ? "odd":"even";
if ( $i < $linked_limit ) $class="even";
if ($linked_limit != 0 && $i==$linked_limit)
{
        ?>
<tr>
<th>
</th>
<th>
   <?php echo _('Lettrage')?>
</th>
<th>
   <?php echo _('Date')?>
</th>
<th>
   <?php echo _('Ref')?>
</th>
<th>
   <?php echo _('Internal')?>
</th> 
<th>
   <?php echo _('Description')?>
</th>
<th style="text-align:right">
   <?php echo _('Débit')?>
</th>
<th style="text-align:right">
   <?php echo _('Crédit')?>
</th>
<th style="text-align:center">
  <?php echo _('Op. concernée')?>
</th>
</tr>
<?php 
 
}
?>
  <tr <?php echo "class=\"$class\""; ?> >
<td>
<?php
 
   if ($this->content[$i]['j_id']==$p_jid) continue;
if ( $jnt_id == $this->content[$i]['letter'] && $i >= $linked_limit) continue;
 
$check=new ICheckbox('ck[]',$this->content[$i]['j_id']);
if ( $jnt_id == $this->content[$i]['letter'] && $i < $linked_limit) $check->selected=true; else $check->selected=false;
 
if ( $this->content[$i]['letter'] < 0 ||  $check->selected == true )
        echo $check->input();
echo HtmlInput::hidden('letter_j_id[]',$this->content[$i]['j_id']);
?>
</td>
<td>
<?php
$letter=($this->content[$i]['letter']< 0)?" ":strtoupper(base_convert($this->content[$i]['letter'],10,36));
?>
<?php echo $letter?>
</td>
<td> <?php echo smaller_date($this->content[$i]['j_date_fmt'])?> </td>
<td> <?php echo h($this->content[$i]['jr_pj_number']);?> </td>
<?php
$r=sprintf('<A class="detail" style="text-decoration:underline"  HREF="javascript:viewOperation(\'%s\',\'%s\')" >%s</A>',
           $this->content[$i]['jr_id'], $gDossier,  $this->content[$i]['jr_internal']);
?>
<td> <?php echo $r?> </td>
 
<td> <?php echo h($this->content[$i]['jr_comment'])?> </td>
 <?php if ($this->content[$i]['j_debit']=='t') : ?>
  <td style="text-align:right"> <?php echo nb($this->content[$i]['j_montant'])?> </td>
  <td></td>
  <?php else : ?>
  <td></td>
  <td style="text-align:right"> <?php echo nb($this->content[$i]['j_montant'])?> </td>
  <?php endif ?>
<td style="text-align:center">
<?php
    // Rapprochement
    $rec=new Acc_Reconciliation($this->db);
    $rec->set_jr_id($this->content[$i]['jr_id']);
    $a=$rec->get();
    if ( $a != null ) {
      foreach ($a as $key => $element)
      {
        $operation=new Acc_Operation($this->db);
        $operation->jr_id=$element;
        $l_amount=$this->db->get_value("select jr_montant from jrn ".
                                         " where jr_id=$element");
        echo "<A class=\"detail\" HREF=\"javascript:viewOperation('".$element."',".$gDossier.")\" > ".$operation->get_internal()." [ ".nbm($l_amount,2)." &euro; ]</A>";
      }//for
    }// if ( $a != null ) {
 
?>
</td>
 
</tr>
<?php
if ($i<$linked_limit)
{
  $amount_deb+=( $jnt_id == $this->content[$i]['letter'] && $this->content[$i]['j_debit']=='t')?$this->content[$i]['j_montant']:0;
  $amount_cred+=( $jnt_id == $this->content[$i]['letter'] && $this->content[$i]['j_debit']=='f')?$this->content[$i]['j_montant']:0;
}
    endfor;
$delta = bcsub($amount_deb, $amount_cred,2);
$side = _('Créditeur');
if ($delta < 0 ) {
$side = _("Débiteur");
$delta = abs($delta);
} elseif ($delta==0) {
    $side="";
}
?>
</TABLE>
  <h3 class="title"> <?php echo _("Total lettré")?></h3>
<span style="display:block;font-size:14px"><?php echo _('Total Debit')?>   <?php echo nbm($amount_deb,2)?></span>
<span style="display:block;font-size:14px"><?php echo _('Total Credit')?>   <?php echo nbm($amount_cred,2)?></span>
<span style="display:block;font-size:14px"><?php echo _('Différence ')." ".$side?>   <?php echo nbm($delta,2)?></span>
 
<?php endif;?>
<?php echo HtmlInput::button('check_all',_('Sélectionner tout'),' onclick="select_checkbox(\'letter_form\')"');?>
<?php echo HtmlInput::button('check_none',_('Tout Désélectionner'),' onclick="unselect_checkbox(\'letter_form\')"');?>