function display_html()
{
$idx = 0;
$r = "";
//---Html
$array = $this->load();
if (is_array($array) == false || empty($array)) {
return 0;
}
$r .= '<table class="result" style="width=100%">';
$r .= '<tr>' . '<th>' . _('Date') . '</th>' . '<th>' . _('Poste') . '</th>' . '<th>' . _('Quick_code') . '</th>' . '<th>' . _('Analytique') . '</th>' . th(_('Description')) . '<th>' . _('libelle') . '</th>' . '<th>' . _('Num.interne') . '</th>' . '<th>' . _('Montant') . '</th>' . '<th>' . _('D/C') . '</th>' . '</tr>';
foreach ($array as $row) {
$class = $idx % 2 == 0 ? 'even' : 'odd';
$idx++;
$r .= '<tr class="' . $class . '">';
$detail = $row['jr_id'] != null ? HtmlInput::detail_op($row['jr_id'], $row['jr_internal']) : '';
$post_detail = $row['j_poste'] != null ? HtmlInput::history_account($row['j_poste'], $row['j_poste']) : '';
$card_detail = $row['f_id'] != null ? HtmlInput::history_card($row['f_id'], $row['qcode']) : '';
$r .= '<td>' . $row['oa_date'] . '</td>' . td($post_detail) . td($card_detail) . '<td>' . h($row['po_name']) . '</td>' . '<td>' . h($row['oa_description']) . '</td>' . td($row['jr_comment']) . '<td>' . $detail . '</td>' . '<td class="num">' . nbm($row['oa_amount']) . '</td>' . '<td>' . ($row['oa_debit'] == 'f' ? 'CREDIT' : 'DEBIT') . '</td>';
$r .= '</tr>';
}
$r .= '</table>';
return $r;
}
/**
*@brief export the ledger in PDF
*/
function export()
{
bcscale(2);
$a_jrn = $this->ledger->get_operation($_GET['from_periode'], $_GET['to_periode']);
if ($a_jrn == null) {
return;
}
for ($i = 0; $i < count($a_jrn); $i++) {
/* initialize tva */
for ($f = 0; $f < count($this->a_Tva); $f++) {
$l = $this->a_Tva[$f]['tva_id'];
$atva_amount[$l] = 0;
}
// retrieve info from ledger
$aAmountVat = $this->ledger->vat_operation($a_jrn[$i]['jr_grpt_id']);
// put vat into array
for ($f = 0; $f < count($aAmountVat); $f++) {
$l = $aAmountVat[$f]['tva_id'];
$atva_amount[$l] = bcadd($atva_amount[$l], $aAmountVat[$f]['sum_vat']);
$this->tp_tva[$l] = bcadd($this->tp_tva[$l], $aAmountVat[$f]['sum_vat']);
$this->rap_tva[$l] = bcadd($this->rap_tva[$l], $aAmountVat[$f]['sum_vat']);
}
$row = $a_jrn[$i];
$this->LongLine(15, 5, $row['pj'], 0);
$this->Cell(10, 5, $row['date_fmt'], 0, 0);
$this->Cell(13, 5, $row['internal'], 0, 0);
list($qc, $name) = $this->get_tiers($row['id'], $this->jrn_type);
$this->LongLine(40, 5, "[" . $qc . "]" . $name, 0, 'L');
$this->LongLine(65, 5, mb_substr($row['comment'], 0, 150), 0, 'L');
/* get other amount (without vat, total vat included, private, ND */
$other = $this->ledger->get_other_amount($a_jrn[$i]['jr_grpt_id']);
$this->tp_htva = bcadd($this->tp_htva, $other['price']);
$this->tp_tvac = bcadd($this->tp_tvac, $other['price'] + $other['vat']);
$this->tp_tva_np = bcadd($this->tp_tva_np, $other['tva_np']);
$this->tp_priv = bcadd($this->tp_priv, $other['priv']);
$this->tp_nd = bcadd($this->tp_nd, $other['tva_nd']);
$this->rap_htva = bcadd($this->rap_htva, $other['price']);
$this->rap_tvac = bcadd($this->rap_tvac, bcadd($other['price'], bcsub($other['vat'], $other['tva_np'])));
$this->rap_priv = bcadd($this->rap_priv, $other['priv']);
$this->rap_nd = bcadd($this->rap_nd, $other['tva_nd']);
$this->rap_tva_np = bcadd($this->rap_tva_np, $other['tva_np']);
$this->Cell(15, 5, nbm($other['price']), 0, 0, 'R');
if ($this->jrn_type != 'VEN') {
$this->Cell(15, 5, nbm($other['priv']), 0, 0, 'R');
$this->Cell(15, 5, nbm($other['tva_nd']), 0, 0, 'R');
}
$this->Cell(15, 5, nbm($other['tva_np']), 0, 0, 'R');
foreach ($atva_amount as $row_atva_amount) {
$this->Cell(15, 5, nbm($row_atva_amount), 0, 0, 'R');
}
$l_tvac = bcadd($other['price'], bcsub($other['vat'], $other['tva_np']));
$l_tvac = bcadd($l_tvac, $other['tva_nd']);
$this->Cell(15, 5, nbm($l_tvac), 0, 0, 'R');
$this->Ln(5);
}
}
header('Content-type: application/csv');
header('Content-Disposition: attachment;filename="stock-summary-list.csv"', FALSE);
?>
"Depot";"Adresse";"Ville";"Pays";"Code Stock";"Fiches";"IN";"OUT";"DIFF"
<?php
$a_repo = $cn->get_array("select distinct t.r_id,r_name,r_adress,r_city,r_country from stock_repository as s join tmp_stockgood_detail as t\n\ton (s.r_id=t.r_id)\n\twhere\n\ts_id=\$1\n\torder by 2\n\t", array($tmp_id));
for ($r = 0; $r < count($a_repo); $r++) {
$a_stock = $cn->get_array("\n\t\t\t\t\tselect coalesce(sum(s_qin),0) as qin,coalesce(sum(s_qout),0) as qout,sg_code\n\t\t\t\t\t\tfrom tmp_stockgood_detail where r_id=\$1 and s_id=\$2\n\t\t\t\t\t\tgroup by sg_code\n\t\t\t\t\t\torder by sg_code\n\n\t\t\t\t\t", array($a_repo[$r]['r_id'], $tmp_id));
for ($s = 0; $s < count($a_stock); $s++) {
$a_card = $cn->get_array("\n\t\t\t\t\t\tselect f_id,vw_name,quick_code\n\t\t\t\t\t\tfrom vw_fiche_attr\n\t\t\t\t\t\twhere\n\t\t\t\t\t f_id in (\n\t\t\t\t\t\tselect distinct f_id from fiche_detail\n\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\tad_id=19 and\n\t\t\t\t\t\t\tad_value=\$1)\n\t\t\t\t\t\torder by vw_name,quick_code\n\t\t\t\t\t", array($a_stock[$s]['sg_code']));
printf('"%s";', $a_repo[$r]['r_name']);
printf('"%s";', $a_repo[$r]['r_adress']);
printf('"%s";', $a_repo[$r]['r_city']);
printf('"%s";', $a_repo[$r]['r_country']);
printf('"%s";', $a_stock[$s]['sg_code']);
$sep = "";
for ($c = 0; $c < count($a_card); $c++) {
$a = sprintf('[%s] %s', $a_card[$c]['quick_code'], $a_card[$c]['vw_name']);
$sep = " / ";
}
// for C
if (count($a_card) == 0) {
$a = ' Erreur Code non utilisé';
}
printf('"%s";', $a);
printf('%s;', nbm($a_stock[$s]['qin']));
printf('%s;', nbm($a_stock[$s]['qout']));
printf('%s', nbm(bcsub($a_stock[$s]['qin'], $a_stock[$s]['qout'])));
printf("\r\n");
}
}
function display_html()
{
$r = "";
$array = $this->load();
$odd = 0;
if (is_array($array) == false) {
return $array;
}
$old = "";
$tot_deb = 0;
$tot_cred = 0;
foreach ($array as $row) {
$odd++;
$r .= $odd % 2 == 0 ? '<tr class="odd">' : '<tr class="even">';
if ($old == $row['a_po_name']) {
$r .= '<td></td>';
} else {
if ($tot_deb != 0 || $tot_cred != 0) {
$r .= "<tr>" . td('');
$r .= "<td>Total </td>" . td(nbm($tot_deb), ' class="num"') . td(nbm($tot_cred), ' class="num"');
$s = abs($tot_deb - $tot_cred);
$d = $tot_deb > $tot_cred ? 'debit' : 'credit';
$r .= "<td class=\"num\">" . nbm($s) . "</td><td>{$d}</td>";
$r .= "</tr>";
}
$tot_deb = 0;
$tot_cred = 0;
// new
$r .= "</table>";
$r .= "<table class=\"result\" style=\"margin-bottom:3px\">";
$r .= "<tr>";
$r .= "<th style=\"width:30%\" >Poste comptable Analytique</th>";
$r .= "<th style=\"width:30%\">Poste comptable Analytique</th>";
$r .= "<th style=\"text-align:right\">Débit</th>";
$r .= "<th style=\"text-align:right\">Crédit</th>";
$r .= "<th style=\"text-align:right\">Solde</th>";
$r .= "<th>D/C</th>";
$r .= "</tr>";
$r .= '<tr>';
$r .= td($row['a_po_name'] . ' ' . $row['a_po_description']);
$old = $row['a_po_name'];
$r .= '</tr>';
$r .= '<tr>';
$r .= td('');
}
$tot_deb += $row['a_d'];
$tot_cred += $row['a_c'];
$r .= td($row['b_po_name'] . " " . $row['b_po_description']);
$r .= td(nbm($row['a_d']), ' class="num"');
$r .= td(nbm($row['a_c']), ' class="num"');
$r .= td(nbm($row['a_solde']), ' class="num"');
$r .= sprintf("<td>%s</td>", $row['a_debit']);
$r .= "</tr>";
}
/* end loop */
if ($tot_deb != 0 || $tot_cred != 0) {
$r .= "<tr>" . td('');
$r .= "<td>Total </td> <td ' class=\"num\"> " . nbm($tot_deb) . " </td> <td ' class=\"num\">" . nbm($tot_cred) . "</td>";
$s = abs($tot_deb - $tot_cred);
$d = $tot_deb > $tot_cred ? 'debit' : 'credit';
$r .= td(nbm($s), ' class="num"') . "<td>{$d}</td>";
$r .= "</tr>";
}
$r .= "</table>";
$r .= h2info('Résumé');
$r .= '<table class="result">';
$r .= '<tr>';
$r .= th('Po') . th('Nom') . th('Débit', ' style="text-align:right"') . th('Crédit', 'style="text-align:right" ') . th('Solde', ' style="text-align:right"');
$sum = $this->show_sum($array);
$tot_cred = 0;
$tot_deb = 0;
foreach ($sum as $row) {
$r .= '<tr>';
$r .= '<td>' . $row['poste'] . '</td>';
$r .= '<td>' . $row['desc'] . '</td>';
$r .= '<td class="num">' . nbm($row['debit']) . '</td>';
$r .= '<td class="num">' . nbm($row['credit']) . '</td>';
$diff = bcsub($row['debit'], $row['credit']);
$tot_cred = bcadd($tot_cred, $row['credit']);
$tot_deb = bcadd($tot_deb, $row['debit']);
$r .= td(nbm($diff), ' class="num" ');
$r .= '<td>' . $row['dc'] . '</td>';
$r .= '</tr>';
}
$r .= td('');
$r .= td('total');
$r .= td(nbm($tot_deb), 'class="num"');
$r .= td(nbm($tot_cred), 'class="num"');
$solde = bcsub($tot_deb, $tot_cred);
$sign = $tot_cred < $tot_deb ? " - " : " + ";
$r .= td($sign . nbm($solde), 'class="num" style="border:solid 1px blue;font-weight:bold"');
$r .= '</tr>';
$r .= '</table>';
return $r;
}
$str_anc .= td(nbm($htva));
$str_anc .= $anc_op->display_table(1, $htva, $div);
} else {
$row .= td('');
}
}
$class = $e % 2 == 0 ? ' class="even"' : 'class="odd"';
echo tr($row, $class);
}
if ($owner->MY_TVA_USE == 'Y') {
$row = td(_('Total'), ' style="font-style:italic;text-align:right;font-weight: bolder;width:auto" colspan="6"');
} else {
$row = td(_('Total'), ' style="font-style:italic;text-align:right;font-weight: bolder;width:auto" colspan="6"');
}
$row .= td(nbm($total_htva), 'class="num" style="font-style:italic;font-weight: bolder;"');
if ($owner->MY_TVA_USE == 'Y') {
$row .= td("") . td("") . td(nbm($total_tvac), 'class="num" style="font-style:italic;font-weight: bolder;"');
}
echo tr($row);
?>
</table>
</div>
<?php
require_once NOALYSS_INCLUDE . '/template/ledger_detail_bottom.php';
?>
</div>
echo $r;
// show all dossiers
if ($Res != null) {
foreach ($Res as $Dossier) {
if ($compteur % 2 == 0) {
$cl = 'class="odd"';
} else {
$cl = 'class="even"';
}
echo "<TR id=\"folder{$Dossier['dos_id']}\" {$cl}><TD style=\"vertical-align:top\"> " . $Dossier['dos_id'] . "</td><td> <B>" . h($Dossier['dos_name']) . "</B> </TD>";
$str_name = domaine . 'dossier' . $Dossier['dos_id'];
echo "<TD><I> " . h($Dossier['dos_description']) . "</I></td>";
$database_exist = $repocn->exist_database($str_name);
if ($database_exist > 0) {
$size = $repocn->get_value("select pg_database_size(\$1)/(1024*1024)::float", array($str_name));
echo td(nbm($size) . "MB", ' style="text-align:right"');
} else {
echo td(_("Dossier inexistant"), 'style="color:red"');
}
echo td($str_name);
if ($database_exist > 0) {
echo td(HtmlInput::anchor(_('Effacer'), '?action=dossier_mgt&sa=del&d=' . $Dossier['dos_id'], " onclick=\"folder_drop('" . $Dossier['dos_id'] . "')\""));
echo td(HtmlInput::anchor(_('Modifier'), '?action=dossier_mgt&sa=mod&d=' . $Dossier['dos_id'], " onclick=\"folder_modify('" . $Dossier['dos_id'] . "')\""));
echo td(HtmlInput::anchor(_('Backup'), 'backup.php?action=backup&sa=b&t=d&d=' . $Dossier['dos_id']));
} else {
echo td(HtmlInput::anchor(_('Effacer'), '?action=dossier_mgt&sa=del&d=' . $Dossier['dos_id'], " onclick=\"folder_drop('" . $Dossier['dos_id'] . "')\""));
}
$compteur++;
}
echo "</TR>";
}
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
/* $Revision$ */
// Copyright Author Dany De Bontridder danydb@aevalys.eu
/**
* @file
* @brief show detail of a operation of fin
*
*/
echo '<table class="result">';
echo '<tr>';
echo th(_('Compte en banque'));
echo th(_('Tiers'));
echo th(_('Libellé'));
echo th(_('Montant'));
echo '</tr>';
echo '<tr>';
$bk = new Fiche($cn, $obj->det->array[0]['qf_bank']);
$view_card_detail = HtmlInput::card_detail($bk->get_quick_code(), h($bk->getName()), ' class="line" ');
echo td($view_card_detail);
$other = new Fiche($cn, $obj->det->array[0]['qf_other']);
$view_card_detail = HtmlInput::card_detail($other->get_quick_code(), h($other->getName()), ' class="line" ');
echo td($view_card_detail);
$comment = strip_tags($obj->det->jr_comment);
echo td($comment);
echo td(nbm($obj->det->array[0]['qf_amount']), ' class="inum"');
echo '</tr>';
echo '</table>';
?>
// get sum for this lettering
$pdf->Cell($tab[7], 4, sprintf('%s', nbm($row['letter_diff'])), '0', '0', $align[7], $fill);
} else {
$pdf->Cell($tab[6], 4, "", 0, 0, 'R', $fill);
}
$pdf->Ln();
}
$pdf->SetFillColor(0, 0, 0);
$pdf->SetFont('DejaVuCond', 'B', 8);
$debit = sprintf('Debit : %s', nbm($amount_deb));
$credit = sprintf('Credit : %s', nbm($amount_cred));
if ($amount_deb > $amount_cred) {
$s = 'solde débiteur';
} else {
$s = 'solde crediteur';
}
$solde = sprintf('%s : %s', $s, nbm(abs(round($amount_cred - $amount_deb, 2))));
$pdf->Cell(0, 6, $debit, 0, 0, 'R');
$pdf->ln(4);
$pdf->Cell(0, 6, $credit, 0, 0, 'R');
$pdf->ln(4);
$pdf->Cell(0, 6, $solde, 0, 0, 'R');
$pdf->ln(4);
$pdf->Ln();
}
}
}
//Save PDF to file
$fDate = date('dmy-Hi');
$pdf->Output("category-{$fDate}.pdf", 'D');
exit;
$name = $cn->get_value('select pcm_lib from tmp_pcmn where pcm_val=$1', array($q[$e]['j_poste']));
$l_lib = $name;
}
}
$l_lib = strip_tags($l_lib);
if ($owner->MY_UPDLAB == 'Y') {
$hidden = HtmlInput::hidden("j_id[]", $q[$e]['j_id']);
$input = new IText("e_march" . $q[$e]['j_id'] . "_label", $l_lib);
$input->css_size = "100%";
} else {
$input = new ISpan("e_march" . $q[$e]['j_id'] . "_label");
$input->value = $l_lib;
$hidden = HtmlInput::hidden("j_id[]", $q[$e]['j_id']);
}
$row .= td($input->input() . $hidden);
$montant = td(nbm($q[$e]['j_montant']), 'class="num"');
$row .= $q[$e]['j_debit'] == 't' ? $montant : td('');
$row .= $q[$e]['j_debit'] == 'f' ? $montant : td('');
/* Analytic accountancy */
if ($owner->MY_ANALYTIC != "nu") {
if (preg_match('/^(6|7)/', $q[$e]['j_poste'])) {
echo HtmlInput::hidden("amount_t" . $amount_idx, $q[$e]['j_montant']);
$anc_op = new Anc_Operation($cn);
$anc_op->j_id = $q[$e]['j_id'];
$anc_op->in_div = $div;
$str_anc .= '<tr>';
$str_anc .= HtmlInput::hidden('op[]', $anc_op->j_id);
$str_anc .= td($q[$e]['j_qcode']);
$str_anc .= td($q[$e]['j_poste']);
$str_anc .= td($q[$e]['j_montant']);
$str_anc .= $anc_op->display_table(1, $q[$e]['j_montant'], $div);
}
?>
</td>
<td>
<?php
echo $row['ccomment'];
?>
</td>
<td class="num">
<?php
echo nbm($row['j_montant']);
?>
</td>
<td class="num">
<?php
echo nbm($row['sg_quantity']);
?>
</td>
<td>
<?php
echo $row['direction'];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
echo $nav_bar;
?>
$pdf->Cell($width[$i], 6, $detail['cred_montant'] > 0 ? nbm($detail['cred_montant']) : '', 0, 0, $lor[$i]);
$i++;
$pdf->Cell($width[$i], 6, nbm(abs($solde)) . $side, 0, 0, $lor[$i]);
$i++;
$pdf->Ln();
}
$pdf->SetFont('DejaVuCond', 'B', 8);
$i = 0;
$pdf->Cell($width[$i], 6, $current_exercice, 0, 0, $lor[$i]);
$i++;
$pdf->Cell($width[$i], 6, '', 0, 0, $lor[$i]);
$i++;
$pdf->Cell($width[$i], 6, '', 0, 0, $lor[$i]);
$i++;
$pdf->Cell($width[$i], 6, '', 0, 0, $lor[$i]);
$i++;
$pdf->Cell($width[$i], 6, 'Total du compte ' . $Poste->id, 0, 0, 'R');
$i++;
$pdf->Cell($width[$i], 6, $solde_d > 0 ? nbm($solde_d) : '', 0, 0, $lor[$i]);
$i++;
$pdf->Cell($width[$i], 6, $solde_c > 0 ? nbm($solde_c) : '', 0, 0, $lor[$i]);
$i++;
$pdf->Cell($width[$i], 6, nbm(abs($solde_c - $solde_d)), 0, 0, $lor[$i]);
$i++;
$pdf->Cell(5, 6, $solde_c > $solde_d ? 'C' : 'D', 0, 0, 'L');
$pdf->Ln();
$pdf->Ln();
}
//Save PDF to file
$pdf->Output("gl_comptes.pdf", 'D');
exit;
}
foreach ($a_sum as $a) {
$lvl1[$a] = bcadd($lvl1[$a], $r[$a]);
$lvl2[$a] = bcadd($lvl2[$a], $r[$a]);
$lvl3[$a] = bcadd($lvl3[$a], $r[$a]);
}
echo '<TR class="' . $tr . '">';
echo td($view_history);
echo td(h($r['label']));
if ($previous == 1) {
echo td(nbm($r['sum_deb_previous']), ' class="previous_year"');
echo td(nbm($r['sum_cred_previous']), ' class="previous_year" ');
echo td(nbm($r['solde_deb_previous']), ' class="previous_year"');
echo td(nbm($r['solde_cred_previous']), 'class="previous_year" ');
if (isset($_GET['lvl1']) || isset($_GET['lvl2']) || isset($_GET['lvl3'])) {
echo '<td></td>';
}
}
echo td(nbm($r['sum_deb']), 'style="text-align:right;"');
echo td(nbm($r['sum_cred']), 'style="text-align:right;"');
echo td(nbm($r['solde_deb']), 'style="text-align:right;"');
echo td(nbm($r['solde_cred']), 'style="text-align:right;"');
if (isset($_GET['lvl1']) || isset($_GET['lvl2']) || isset($_GET['lvl3'])) {
echo '<td></td>';
}
echo '</TR>';
}
echo '</table>';
}
// end submit
echo "</div>";
$row = '';
$q = $detail->det->array;
$fiche = new Fiche($cn);
$fiche->get_by_qcode($q[$e]['j_qcode']);
/* Analytic accountancy */
if ($owner->MY_ANALYTIC != "nu") {
$poste = $fiche->strAttribut(ATTR_DEF_ACCOUNT);
if (preg_match('/^(6|7)/', $q[$e]['j_poste'])) {
$qcode = $fiche->strAttribut(ATTR_DEF_QUICKCODE);
$anc_op = new Anc_Operation($cn);
$anc_op->j_id = $q[$e]['j_id'];
$anc_op->in_div = $div;
$str_anc .= '<tr>';
$str_anc .= td($poste);
$str_anc .= td($qcode);
$str_anc .= td(nbm($q[$e]['j_montant']));
$str_anc .= '<td>';
$str_anc .= HtmlInput::hidden('op[]', $anc_op->j_id);
$montant = $q[$e]['j_debit'] == "t" ? $q[$e]['j_montant'] : bcmul($q[$e]['j_montant'], -1);
$str_anc .= $anc_op->display_table(1, $montant, $div);
$str_anc .= '</td>';
$str_anc .= '</tr>';
}
}
}
?>
</div>
<?php
require_once NOALYSS_INCLUDE . '/template/ledger_detail_bottom.php';
?>
</div>
/**
* @brief show the result of the array to confirm
* before inserting
* @param$p_array array from the form
* \return string
*/
function confirm($p_array, $p_readonly = false)
{
global $g_parameter;
$msg = array();
if (!$p_readonly) {
$msg = $this->verify($p_array);
}
$this->id = $p_array['p_jrn'];
if (empty($p_array)) {
return 'Aucun résultat';
}
$anc = null;
extract($p_array);
$lPeriode = new Periode($this->db);
if ($this->check_periode() == true) {
$lPeriode->p_id = $period;
} else {
$lPeriode->find_periode($e_date);
}
$total_deb = 0;
$total_cred = 0;
bcscale(2);
$ret = "";
if (!empty($msg)) {
$ret .= $this->display_warning($msg, _("Attention : il vaut mieux utiliser les fiches que les postes comptables"));
}
$ret .= "<table >";
$ret .= "<tr><td>" . _('Date') . " : </td><td>{$e_date}</td></tr>";
/* display periode */
$date_limit = $lPeriode->get_date_limit();
$ret .= '<tr> ' . td(_('Période Comptable')) . td($date_limit['p_start'] . '-' . $date_limit['p_end']) . '</tr>';
$ret .= "<tr><td>" . _('Libellé') . " </td><td>" . h($desc) . "</td></tr>";
$ret .= "<tr><td>" . _('PJ Num') . " </td><td>" . h($e_pj) . "</td></tr>";
$ret .= '</table>';
$ret .= "<table class=\"result\">";
$ret .= "<tr>";
$ret .= "<th>" . _('Quick Code ou ');
$ret .= _("Poste") . " </th>";
$ret .= "<th style=\"text-align:left\"> " . _("Libellé") . " </th>";
$ret .= "<th style=\"text-align:right\">" . _("Débit") . "</th>";
$ret .= "<th style=\"text-align:right\">" . _("Crédit") . "</th>";
/* if we use the AC */
if ($g_parameter->MY_ANALYTIC != 'nu') {
$anc = new Anc_Plan($this->db);
$a_anc = $anc->get_list();
$x = count($a_anc);
/* set the width of the col */
$ret .= '<th colspan="' . $x . '" style="width:auto;text-align:center" >' . _('Compt. Analytique') . '</th>';
/* add hidden variables pa[] to hold the value of pa_id */
$ret .= Anc_Plan::hidden($a_anc);
}
$ret .= "</tr>";
$ret .= HtmlInput::hidden('e_date', $e_date);
$ret .= HtmlInput::hidden('desc', $desc);
$ret .= HtmlInput::hidden('period', $lPeriode->p_id);
$ret .= HtmlInput::hidden('e_pj', $e_pj);
$ret .= HtmlInput::hidden('e_pj_suggest', $e_pj_suggest);
$mt = microtime(true);
$ret .= HtmlInput::hidden('mt', $mt);
// For predefined operation
$ret .= HtmlInput::hidden('e_comm', $desc);
$ret .= HtmlInput::hidden('jrn_type', $this->get_type());
$ret .= HtmlInput::hidden('p_jrn', $this->id);
$ret .= HtmlInput::hidden('nb_item', $nb_item);
if ($this->with_concerned == true) {
$ret .= HtmlInput::hidden('jrn_concerned', $jrn_concerned);
}
$ret .= dossier::hidden();
$count = 0;
for ($i = 0; $i < $nb_item; $i++) {
if ($p_readonly == true) {
if (!isset(${'qc_' . $i})) {
${'qc_' . $i} = '';
}
if (!isset(${'poste' . $i})) {
${'poste' . $i} = '';
}
if (!isset(${'amount' . $i})) {
${'amount' . $i} = '';
}
}
$class = $i % 2 == 0 ? ' class="even" ' : ' class="odd" ';
$ret .= "<tr {$class}> ";
if (trim(${'qc_' . $i}) != "") {
$oqc = new Fiche($this->db);
$oqc->get_by_qcode(${'qc_' . $i}, false);
$strPoste = $oqc->strAttribut(ATTR_DEF_ACCOUNT);
$ret .= "<td>" . ${'qc_' . $i} . ' - ' . $oqc->strAttribut(ATTR_DEF_NAME) . HtmlInput::hidden('qc_' . $i, ${'qc_' . $i}) . '</td>';
}
if (trim(${'qc_' . $i}) == "" && trim(${'poste' . $i}) != "") {
$oposte = new Acc_Account_Ledger($this->db, ${'poste' . $i});
$strPoste = $oposte->id;
$ret .= "<td>" . h(${"poste" . $i} . " - " . $oposte->get_name()) . HtmlInput::hidden('poste' . $i, ${'poste' . $i}) . '</td>';
}
if (trim(${'qc_' . $i}) == "" && trim(${'poste' . $i}) == "") {
continue;
}
$ret .= "<td>" . h(${"ld" . $i}) . HtmlInput::hidden('ld' . $i, ${'ld' . $i});
$ret .= isset(${"ck{$i}"}) ? HtmlInput::hidden('ck' . $i, ${'ck' . $i}) : "";
$ret .= "</td>";
if (isset(${"ck{$i}"})) {
$ret .= "<td class=\"num\">" . nbm(${"amount" . $i}) . HtmlInput::hidden('amount' . $i, ${'amount' . $i}) . "</td>" . td("");
$total_deb = bcadd($total_deb, ${'amount' . $i});
} else {
$ret .= td("") . "<td class=\"num\">" . nbm(${"amount" . $i}) . HtmlInput::hidden('amount' . $i, ${'amount' . $i}) . "</td>";
$total_cred = bcadd($total_cred, ${"amount" . $i});
}
/*$ret.="<td>";
$ret.=(isset(${"ck$i"})) ? HtmlInput::hidden('ck' . $i, ${'ck' . $i}) : "";
$ret.="</td>";*/
// CA
if ($g_parameter->MY_ANALYTIC != 'nu') {
if (preg_match("/^[6,7]+/", $strPoste) == 1) {
// show form
$op = new Anc_Operation($this->db);
$null = $g_parameter->MY_ANALYTIC == 'op' ? 1 : 0;
$p_array['pa_id'] = $a_anc;
/* op is the operation it contains either a sequence or a jrnx.j_id */
$ret .= HtmlInput::hidden('op[]=', $i);
$ret .= '<td style="text-align:center">';
$read = $p_readonly == true ? 0 : 1;
$ret .= $op->display_form_plan($p_array, $null, $read, $count, round(${'amount' . $i}, 2));
$ret .= '</td>';
$count++;
}
}
$ret .= "</tr>";
}
$ret .= tr(td('') . td(_('Totaux')) . td($total_deb, 'class="num"') . td($total_cred, 'class="num"'), 'class="highlight"');
$ret .= "</table>";
if ($g_parameter->MY_ANALYTIC != 'nu' && $p_readonly == false) {
$ret .= '<input type="button" class="button" value="' . _('verifie Imputation Analytique') . '" onClick="verify_ca(\'\');">';
}
return $ret;
}
<td class="num">
<?php
echo nbm($tot_cum_price);
?>
</td>
<td class="num">
<?php
echo nbm($tot_cum_nd);
?>
</td>
<td>
</td>
<td class="num">
<?php
echo nbm($tot_cum_vat);
?>
</td>
<td class="num">
<?php
echo nbm($tot_cum_nd_tva);
?>
</td>
<td class="num">
<?php
echo nbm($tot_cum_tvac);
?>
</td>
</tfoot>
</table>
echo $onclick;
?>
" >
<?php
echo $a_key[$i]['kd_name'];
?>
</a>
</td>
<td>
<?php
echo $a_key[$i]['kd_description'];
?>
</td>
<?php
$sign = $a_key[$i]['distrib'] == 100 ? $g_succeed : $g_failed;
?>
<td>
<?php
echo nbm($a_key[$i]['distrib']);
?>
%
<?php
echo $sign;
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
if (count($a_card) == 0) {
echo '<span class="notice">' . _("Changement manuel") . '</span>';
}
?>
</td>
<td class="num">
<?php
echo nbm($a_stock[$s]['qin']);
?>
</td>
<td class="num">
<?php
echo nbm($a_stock[$s]['qout']);
?>
</td>
<td class="num">
<?php
echo nbm(bcsub($a_stock[$s]['qin'], $a_stock[$s]['qout']));
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
?>
</div>
function display_pdf()
{
$array = $this->load();
$pdf = new PDFBalance_Simple($this->db);
$pdf->set_info($this->from_poste, $this->to_poste, $this->from, $this->to);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->setTitle("Balance analytique", true);
$pdf->SetFont('DejaVu', '', 6);
for ($i = 0; $i < count($array); $i++) {
$row = $array[$i];
$pdf->Cell(20, 6, $row['po_id'], 0, 0, 'L');
$pdf->Cell(90, 6, $row['po_name'], 0, 0, 'L');
$pdf->Cell(20, 6, sprintf('%s', nbm($row['sum_deb'])), 0, 0, 'R');
$pdf->Cell(20, 6, sprintf('%s', nbm($row['sum_cred'])), 0, 0, 'R');
$pdf->Cell(20, 6, sprintf('%s', nbm($row['solde'])), 0, 0, 'R');
$pdf->Cell(20, 6, $row['debit'], 0, 0, 'R');
$pdf->Ln();
}
$fDate = date('dmy-Hi');
$pdf->output('simple-balance-' . $fDate . '.pdf', 'D');
}
/**
* @brief Display a box with the contains
* @param type $p_array Data to display
* @param type $p_title Title of the box
* @param type $p_div id of the box
*/
function display_dashboard_operation($p_array, $p_title, $p_div)
{
?>
<div id="<?php
echo $p_div;
?>
" class="inner_box" style="display:none;position:fixed;top:250px;left:12%;width: 75%;min-height:50%;overflow:auto;">
<?php
echo HtmlInput::title_box($p_title, $p_div, "hide");
?>
<?php
if (count($p_array) > 0) {
?>
<table class="result">
<tr>
<th><?php
echo _('Date');
?>
</th>
<th><?php
echo _('Code Interne');
?>
</th>
<th><?php
echo _('Pièce');
?>
</th>
<th><?php
echo _('Description');
?>
</th>
<th>
<?php
echo _('Montant');
?>
</th>
</tr>
<?php
for ($i = 0; $i < count($p_array); $i++) {
?>
<tr class="<?php
echo $i % 2 == 0 ? 'odd' : 'even';
?>
">
<td>
<?php
echo smaller_date(format_date($p_array[$i]['jr_date']));
?>
</td>
<td>
<?php
echo HtmlInput::detail_op($p_array[$i]['jr_id'], $p_array[$i]['jr_internal']);
?>
</td>
<td>
<?php
echo h($p_array[$i]['jr_pj_number']);
?>
</td>
<td>
<?php
echo h($p_array[$i]['jr_comment']);
?>
</td>
<td>
<?php
echo nbm($p_array[$i]['jr_montant']);
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
} else {
?>
<h2 class="notice"><?php
echo _('Aucune donnée');
?>
</h2>
<?php
}
?>
</div>
<?php
}
function display_html()
{
$r = "";
//---Html
$array = $this->load();
if (is_array($array) == false || empty($array)) {
return 0;
}
$r .= '<table class="result" style="width:100%">';
$ix = 0;
$prev = 'xx';
$idx = 0;
$tot_deb = $tot_cred = 0;
bcscale(2);
foreach ($array as $row) {
if ($prev != $row['po_name']) {
if ($ix > 0) {
$r .= '<tr>';
$tot_solde = bcsub($tot_cred, $tot_deb);
$sign = " " . ($tot_solde > 0) ? 'C' : 'D';
$r .= td('') . td('') . td('');
$r .= td('') . td('') . td('') . td('') . td('') . td(nbm($tot_deb), ' class="num"') . td(nbm($tot_cred), ' class="num"') . td(nbm($tot_solde) . $sign, ' class="num notice"');
}
$r .= '<tr>' . '<td colspan="7" style="width:auto">' . '<h2>' . h($row['po_name'] . ' ' . $row['po_description']) . '</td></tr>';
$r .= '<tr>' . '<th>' . '</th>' . '<th>' . _('Date') . '</th>' . '<th>' . _('Poste') . '</th>' . '<th>' . _('Quick_code') . '</th>' . '<th>' . _('Libellé') . '</th>' . '<th>' . '</th>' . '<th>' . _('Pièce') . '</th>' . '<th>' . _('Interne') . '</th>' . '<th style="text-align:right">' . _('Débit') . '</th>' . '<th style="text-align:right">' . _('Crédit') . '</th>' . '<th style="text-align:right">' . _('Prog.') . '</th>' . '</tr>';
$tot_deb = $tot_cred = 0;
$prev = $row['po_name'];
$ix++;
}
$class = $idx % 2 == 0 ? 'even' : 'odd';
$idx++;
$r .= '<tr class="' . $class . '">';
$detail = $row['jr_id'] != null ? HtmlInput::detail_op($row['jr_id'], $row['jr_internal']) : '';
$post_detail = $row['j_poste'] != null ? HtmlInput::history_account($row['j_poste'], $row['j_poste']) : '';
$card_detail = $row['f_id'] != null ? HtmlInput::history_card($row['f_id'], $row['qcode']) : '';
$amount_deb = $row['oa_debit'] == 't' ? $row['oa_amount'] : 0;
$amount_cred = $row['oa_debit'] == 'f' ? $row['oa_amount'] : 0;
$tot_deb = bcadd($tot_deb, $amount_deb);
$tot_cred = bcadd($tot_cred, $amount_cred);
$tot_solde = bcsub($tot_cred, $tot_deb);
/*
* Checked button
*/
$str_ck = "";
$str_document = "";
if ($row['jr_id'] != null) {
/*
* Get receipt info
*/
$str_document = HtmlInput::show_receipt_document($row['jr_id']);
if ($str_document != "") {
$ck = new ICheckBox('ck[]', $row['jr_id']);
$str_ck = $ck->input();
}
}
$r .= '<td>' . $str_ck . '</td>' . '<td>' . $row['oa_date'] . '</td>' . td($post_detail) . td($card_detail) . td($row['jr_comment']) . '<td>' . $str_document . '</td>' . td($row['jr_pj_number']) . '<td>' . $detail . '</td>' . '<td class="num">' . nbm($amount_deb) . '</td>' . '<td class="num">' . nbm($amount_cred) . '</td>' . '<td class="num">' . nbm($tot_solde) . '</td>';
$r .= '</tr>';
}
$r .= '<tr>';
$tot_solde = bcsub($tot_cred, $tot_deb);
$sign = $tot_solde > 0 ? 'C' : 'D';
$r .= td('') . td('') . td('');
$r .= td('') . td('') . td('') . td('') . td('') . td(nbm($tot_deb), ' class="num"') . td(nbm($tot_cred), ' class="num"') . td(nbm($tot_solde) . $sign, ' class="num notice"');
$r .= '</table>';
return $r;
}
<td>' . $detail['description'] . '</td>
<td>' . $detail['jr_pj_number'] . '</td>
<td align="right">' . ($detail['deb_montant'] > 0 ? nbm($detail['deb_montant']) : '') . '</td>
<td align="right">' . ($detail['cred_montant'] > 0 ? nbm($detail['cred_montant']) : '') . '</td>
<td align="right">' . nbm(abs($solde)) . $side . '</td>
<td style="text-align:right;color:red">' . $html_let . '</td>
</tr>';
}
echo '<tr class="highlight">
<td>' . $current_exercice . '</td>
<td>' . '' . '</td>
<td>' . '<b>' . 'Total du compte ' . $poste_id['pcm_val'] . '</b>' . '</td>
<td>' . '' . '</td>
<td align="right">' . '<b>' . ($solde_d > 0 ? nbm($solde_d) : '') . '</b>' . '</td>
<td align="right">' . '<b>' . ($solde_c > 0 ? nbm($solde_c) : '') . '</b>' . '</td>
<td align="right">' . '<b>' . nbm(abs($solde_c - $solde_d)) . '</b>' . '</td>
<td>';
if ($solde_c > $solde_d) {
echo "Crédit";
}
if ($solde_c < $solde_d) {
echo "Débit";
}
if ($solde_c == $solde_d) {
echo "=";
}
echo '</td>' . '</tr>';
}
echo '</table>';
echo Acc_Account_Ledger::HtmlTableHeader("gl_comptes");
echo "</div>";
$a = $line_tva['tva_id'];
if (isset($tot['tva'][$a])) {
?>
<td class="num"><?php
echo nbm($tot['tva'][$a]);
?>
</td>
<?php
} else {
?>
<td>
</td>
<?php
}
?>
<?php
}
?>
<?php
}
?>
<td class="num"><?php
echo nbm($tot['tvac']);
?>
</td>
<td></td>
</tr>
</table>
echo '</tr>';
echo '<tr>';
echo td(_('Credit'));
echo td(nbm($amount_cred), ' style="font-weight:bold;text-align:right"');
echo '</tr>';
echo '<tr class="highlight">';
$solde = abs(round($amount_cred - $amount_deb, 2));
if ($solde == 0) {
$s = 'solde';
} else {
if ($amount_deb > $amount_cred) {
$s = 'solde débiteur';
} else {
$s = 'solde crediteur';
}
}
echo td($s);
echo td(nbm($solde), ' style="font-weight:bold;text-align:right"');
echo '</tr>';
echo '</table>';
}
}
if ($allcard == 0) {
echo $str_add_card;
}
echo $export_csv;
echo $export_pdf;
echo $export_print;
?>
$bk_card = new Fiche($cn);
$bk_card->id = $Ledger->get_bank();
$filter_year = " j_tech_per in (select p_id from parm_periode where p_exercice='" . $g_user->get_exercice() . "')";
/* get saldo for not reconcilied operations */
$saldo_not_reconcilied = $bk_card->get_solde_detail($filter_year . " and j_grpt in (select jr_grpt_id from jrn where trim(jr_pj_number) ='' or jr_pj_number is null)");
/* get saldo for reconcilied operation */
$saldo_reconcilied = $bk_card->get_solde_detail($filter_year . " and j_grpt in (select jr_grpt_id from jrn where trim(jr_pj_number) != '' and jr_pj_number is not null)");
/* solde compte */
$saldo = $bk_card->get_solde_detail($filter_year);
echo '<table>';
echo '<tr>';
echo td("Solde compte ");
echo td(nbm(bcsub($saldo['debit'], $saldo['credit'])), ' style="text-align:right"');
echo '</tr>';
echo '<tr>';
echo td("Solde non rapproché ");
echo td(nbm(bcsub($saldo_not_reconcilied['debit'], $saldo_not_reconcilied['credit'])), ' style="text-align:right"');
echo '</tr>';
echo '<tr>';
echo td("Solde rapproché ");
echo td(nbm(bcsub($saldo_reconcilied['debit'], $saldo_reconcilied['credit'])), ' style="text-align:right"');
echo '</tr>';
echo '<tr>';
echo td("Total montant ");
echo td(nbm($tot_not_reconcilied), ' style="text-align:right"');
echo '</tr>';
echo '</table>';
echo HtmlInput::submit('save', 'Mettre à jour le n° de relevé bancaire');
echo '</form>';
echo '</div>';
return;
?>
</td>
<td class="box">
<?php
echo h(mb_substr($last_ledger[$i]['jr_comment'], 0, 40, 'UTF-8'));
?>
</td>
<td class="box">
<?php
echo HtmlInput::detail_op($last_ledger[$i]['jr_id'], $last_ledger[$i]['jr_internal']);
?>
</td>
<td class="num box">
<?php
echo nbm($last_ledger[$i]['jr_montant']);
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
<div id="last_operation_management_div" class="box">
<?php
echo HtmlInput::title_box(_('Suivi'), "last_operation_management_div", 'zoom', 'onclick="action_show(' . dossier::id() . ')"');
?>
<?php
function display_html()
{
bcscale(2);
if ($this->check() != 0) {
alert('Désolé mais une des dates données n\'est pas valide');
return;
}
//---------------------------------------------------------------------------
// Card - Acc
//---------------------------------------------------------------------------
if ($this->card_poste == '1') {
$this->load_card();
/*
* Show all the result
*/
$tot_card = 0;
$prev = '';
echo '<table class="result" style="margin-left:5px;margin-top:5px">';
$tot_glob = 0;
for ($i = 0; $i < count($this->arow); $i++) {
if ($i == 0) {
$prev = $this->arow[$i]['f_id'];
echo '<tr><td>' . HtmlInput::history_card($this->arow[$i]['f_id'], $this->arow[$i]['j_qcode'] . ' ' . $this->arow[$i]['name'], ' display:inline') . '</td></tr>';
}
$style = $i % 2 == 0 ? ' class="odd" ' : ' class="even" ';
if ($i != 0 && $prev != $this->arow[$i]['f_id']) {
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
echo '<tr style="padding-top:5px"><td>' . HtmlInput::history_card($this->arow[$i]['f_id'], $this->arow[$i]['j_qcode'] . ' ' . $this->arow[$i]['name'], ' display:inline ') . '</td></tr>';
$tot_card = 0;
$prev = $this->arow[$i]['f_id'];
}
echo '<tr ' . $style . '>';
$amount = $this->arow[$i]['sum_amount'];
if ($amount == null) {
$amount = 0;
}
$tot_card = bcadd($tot_card, $amount);
$tot_glob = bcadd($tot_glob, $amount);
echo td($this->arow[$i]['po_name'] . " " . $this->arow[$i]['po_description'], 'style="padding-left:10"');
echo td(nbm($amount), ' class="num" ');
echo '</tr>';
}
echo '<tr>';
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
echo '</table>';
echo '<h2> Résultat global ' . nbm($tot_glob) . '</h2>';
}
//---------------------------------------------------------------------------
// Accountancy - Analytic
//---------------------------------------------------------------------------
if ($this->card_poste == '2') {
$this->load_poste();
/*
* Show all the result
*/
$tot_card = 0;
$prev = '';
echo '<table class="result" style="margin-left:20px;margin-top:5px">';
$tot_glob = 0;
for ($i = 0; $i < count($this->arow); $i++) {
if ($i == 0) {
$prev = $this->arow[$i]['j_poste'];
echo '<tr><td>' . HtmlInput::history_account($this->arow[$i]['j_poste'], $this->arow[$i]['j_poste'] . ' ' . $this->arow[$i]['name'], ' display:inline') . '</td></tr>';
}
$style = $i % 2 == 0 ? ' class="odd" ' : ' class="even" ';
if ($i != 0 && $prev != $this->arow[$i]['j_poste']) {
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
echo '<tr style="padding-top:5px"><td>' . HtmlInput::history_account($this->arow[$i]['j_poste'], $this->arow[$i]['j_poste'] . ' ' . $this->arow[$i]['name'], ' display:inline ') . '</td></tr>';
$tot_card = 0;
$prev = $this->arow[$i]['j_poste'];
}
echo '<tr ' . $style . '>';
$amount = $this->arow[$i]['sum_amount'];
if ($amount == null) {
$amount = 0;
}
$tot_card = bcadd($tot_card, $amount);
$tot_glob = bcadd($tot_glob, $amount);
echo td($this->arow[$i]['po_name'] . " " . $this->arow[$i]['po_description'], 'style="padding-left:10"');
echo td(nbm($amount), ' class="num" ');
echo '</tr>';
}
echo '<tr>';
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
echo '</table>';
echo td(nbm($tot_card), ' class="num"');
}
//---------------------------------------------------------------------------
// Acc after card
//---------------------------------------------------------------------------
if ($this->card_poste == '3') {
$this->load_anc_card();
/*
* Show all the result
*/
$tot_card = 0;
$prev = '';
echo '<table class="result" style="margin-left:20px;margin-top:5px">';
$tot_glob = 0;
for ($i = 0; $i < count($this->arow); $i++) {
if ($i == 0) {
$prev = $this->arow[$i]['po_id'];
echo '<tr><td>' . $this->arow[$i]['po_name'] . " " . $this->arow[$i]['po_description'] . '</td></tr>';
}
$style = $i % 2 == 0 ? ' class="odd" ' : ' class="even" ';
if ($i != 0 && $prev != $this->arow[$i]['po_id']) {
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
echo '<tr><td>' . $this->arow[$i]['po_name'] . " " . $this->arow[$i]['po_description'] . '</td></tr>';
$tot_card = 0;
$prev = $this->arow[$i]['po_id'];
}
echo '<tr ' . $style . '>';
$amount = $this->arow[$i]['sum_amount'];
if ($amount == null) {
$amount = 0;
}
$tot_card = bcadd($tot_card, $amount);
$tot_glob = bcadd($tot_glob, $amount);
echo '<td style="padding-left:10">' . HtmlInput::history_card($this->arow[$i]['f_id'], $this->arow[$i]['j_qcode'] . ' ' . $this->arow[$i]['name'], ' display:inline') . '</td>';
echo td(nbm($amount), ' class="num" ');
echo '</tr>';
}
echo '<tr>';
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
echo '</table>';
echo td(nbm($tot_card), ' class="num"');
}
//---------------------------------------------------------------------------
// Analytic - Accountancy
//---------------------------------------------------------------------------
if ($this->card_poste == '4') {
$this->load_anc_account();
/*
* Show all the result
*/
$tot_card = 0;
$prev = '';
echo '<table class="result" style="margin-left:20px;margin-top:5px">';
$tot_glob = 0;
for ($i = 0; $i < count($this->arow); $i++) {
if ($i == 0) {
$prev = $this->arow[$i]['po_id'];
echo '<tr><td>' . $this->arow[$i]['po_name'] . " " . $this->arow[$i]['po_description'] . '</td></tr>';
}
$style = $i % 2 == 0 ? ' class="odd" ' : ' class="even" ';
if ($i != 0 && $prev != $this->arow[$i]['po_id']) {
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
$tot_card = 0;
$prev = $this->arow[$i]['po_id'];
echo '<tr><td>' . $this->arow[$i]['po_name'] . " " . $this->arow[$i]['po_description'] . '</td></tr>';
}
echo '<tr ' . $style . '>';
$amount = $this->arow[$i]['sum_amount'];
if ($amount == null) {
$amount = 0;
}
$tot_card = bcadd($tot_card, $amount);
$tot_glob = bcadd($tot_glob, $amount);
echo '<td style="padding-left:10">' . HtmlInput::history_account($this->arow[$i]['j_poste'], $this->arow[$i]['j_poste'] . ' ' . $this->arow[$i]['name'], ' display:inline') . '</td>';
echo td(nbm($amount), ' class="num" ');
echo '</tr>';
}
echo '<tr>';
echo td('Total');
echo td(nbm($tot_card), ' class="num"');
echo '</tr>';
echo '</table>';
echo '<h2> Résultat global ' . nbm($tot_glob) . '</h2>';
}
}
function html_table($p_from)
{
if ($p_from == "") {
$from = "";
$to = "";
} else {
$p = new Periode($this->db);
list($from, $to) = $p->get_date_limit($p_from);
}
$array = $this->get_list($from, $to);
if (empty($array)) {
return "Pas d'enregistrement trouvé";
}
// navigation_bar
$step = $_SESSION['g_pagesize'];
$page = isset($_GET['offset']) ? $_GET['page'] : 1;
$offset = isset($_GET['offset']) ? $_GET['offset'] : 0;
$bar = navigation_bar($offset + 1, count($array), $step, $page);
if ($step != -1) {
$view = array_splice($array, $offset, $step);
} else {
$view = $array;
}
$gDossier = dossier::id();
$ret = "";
$ret .= $bar;
$count = 0;
$group = 0;
$oldgroup = 0;
$oldjrid = 0;
foreach ($view as $row) {
$group = $row['oa_group'];
if ($group != $oldgroup) {
if ($oldgroup != 0) {
$efface = new IButton();
$efface->javascript = "anc_remove_operation(" . $gDossier . "," . $oldgroup . ")";
$efface->name = "Efface";
$efface->label = "Efface";
$ret .= "<td>" . $efface->input() . "</td>";
$this->oa_group = $oldgroup;
$jr_id = $this->get_jrid();
if ($jr_id != 0) {
// get the old jr_id
$detail = new IButton();
$detail->javascript = "viewOperation({$jr_id},{$gDossier})";
$detail->name = "Detail";
$detail->label = "Detail";
$ret .= "<td>" . $detail->input() . "</td>";
}
$ret .= '</table>';
}
$ret .= '<table id="' . $row['oa_group'] . '" class="result">';
$ret .= "<tr class=\"highlight\">" . td($row['oa_date']) . "<td>" . HtmlInput::detail_op($row['jr_id'], h($row['oa_description'] . " " . $row['jr_pj_number'])) . "</td>" . td();
$ret .= "<td>" . "Groupe id : " . $row['oa_group'] . "</td>" . ($oldgroup = $group);
}
$class = $count % 2 == 0 ? "odd" : "even";
$count++;
$cred = $row['oa_debit'] == 'f' ? "CREDIT" : "DEBIT";
$ret .= "<tr class=\"{$class}\">";
$ret .= "<td>" . h($row['po_name']) . "</td>";
$ret .= td(h($row['po_description']));
$ret .= '<td class="num">' . nbm($row['oa_amount']) . "</td>" . "<td>" . $cred . "</td>" . "</tr>";
}
$efface = new IButton();
$efface->javascript = "anc_remove_operation(" . "{$gDossier}," . $oldgroup . ")";
$efface->name = "Efface";
$efface->label = "Efface";
$ret .= "<td>" . $efface->input() . "</td>";
// get the old jr_id
$this->oa_group = $oldgroup;
$jr_id = $this->get_jrid();
if ($jr_id != 0) {
$detail = new IButton();
$detail->javascript = "modifyOperation({$jr_id},'" . $gDossier . "')";
$detail->name = "Detail";
$detail->label = "Detail";
$ret .= "<td>" . $detail->input() . "</td>";
}
$ret .= '</table>';
$ret .= $bar;
return $ret;
}
} else {
$result = $g_failed;
}
$class = $ix % 2 == 0 ? 'odd' : "even";
print tr(td($name) . td(nbm($deb), 'class="num"') . td(nbm($cred), 'class="num"') . td(nbm($result), 'class="num"') . td($result), "class=\"{$class}\"");
$ix++;
}
$deb = $cn->get_value("select sum (j_montant) from jrnx where j_debit='t' {$sql_year} ");
$cred = $cn->get_value("select sum (j_montant) from jrnx where j_debit='f' {$sql_year} ");
if ($cred == $deb) {
$result = $g_succeed;
} else {
$result = $g_failed;
}
$class = $ix % 2 == 0 ? 'odd' : "even";
print tr(td(_('Grand livre')) . td(nbm($deb), ' class="num"') . td(nbm($cred), ' class="num"') . td(nbm($result), ' class="num"') . td($result), "class=\"{$class}\"");
echo '</table>';
echo '</div>';
echo '<hr>';
echo '<div class="myfieldset"><h1 class="legend">' . _('Vérification des comptes') . '</h1>';
$bilan = new Acc_Bilan($cn);
$periode = new Periode($cn);
list($start_periode, $end_periode) = $periode->get_limit($exercice);
$bilan->from = $start_periode->p_id;
$bilan->to = $end_periode->p_id;
$bilan->verify();
echo '</div>';
?>
<hr>
<div class="myfieldset">
<h1 class="legend">
$internal = $opRap->get_internal();
$array_jr = $cn->get_array('select jr_date,jr_montant,jr_comment from jrn where jr_id=$1', array($aRap[$e]));
$amount = $array_jr[0]['jr_montant'];
$str = "modifyOperation(" . $aRap[$e] . "," . $gDossier . ")";
$rmReconciliation = new IButton('rmr');
$rmReconciliation->label = SMALLX;
$rmReconciliation->class = "tinybutton";
$rmReconciliation->javascript = "return confirm_box(null,'" . _("vous confirmez?") . "',";
$rmReconciliation->javascript .= sprintf('function () { dropLink(\'%s\',\'%s\',\'%s\',\'%s\');deleteRowRec(\'%s\',$(\'row%d\'));})', $gDossier, $div, $jr_id, $aRap[$e], $tableid, $e);
if ($access == 'W') {
$remove = $rmReconciliation->input();
} else {
$remove = '';
}
$comment = strip_tags($array_jr[0]['jr_comment']);
echo tr(td(format_date($array_jr[0]['jr_date'])) . td('<a class="line" href="javascript:void(0)" onclick="' . $str . '" >' . $internal . '</A>') . td($comment) . td(nbm($amount)) . td($remove), ' id = "row' . $e . '"');
}
echo '</table>';
}
if ($access == 'W') {
$wConcerned = new IConcerned("rapt" . $div);
$wConcerned->amount_id = $obj->det->jr_montant;
echo $wConcerned->input();
}
?>
</div>
<div id="linked_action_div<?php
echo $div;
?>
" style="display:<?php
echo $a_tab['linked_action_div']['display'];
<th style="text-align:right" ><?php
echo _("Solde");
?>
</th>
</tr>
<?php
}
if ($idx % 2 == 0) {
echo '<tr class="even">';
} else {
echo '<tr class="odd">';
}
echo td($array[$i]['po_name']);
echo td(nbm($array[$i]['sum_deb']), ' class="num"');
echo td(nbm($array[$i]['sum_cred']), ' class="num"');
$solde = bcsub($array[$i]['sum_cred'], $array[$i]['sum_deb']);
echo td(nbm($solde), ' class="num"');
$tot_group_deb = bcadd($tot_group_deb, $array[$i]['sum_deb']);
$tot_group_cred = bcadd($tot_group_cred, $array[$i]['sum_cred']);
echo '</tr>';
$idx++;
}
echo '<tr>';
echo td(_('Solde'));
echo td(nbm($tot_group_deb), ' class="num"');
echo td(nbm($tot_group_cred), ' class="num"');
echo td(nbm(bcsub($tot_group_cred, $tot_group_deb)), ' class="num"');
echo '</tr>';
?>
</table>
