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 check and warn if an accound has the wrong saldo
* @param $p_message legend of the fieldset
* @param $p_type type of the Acccount ACT actif, ACTINV...
* @param $p_type the saldo must debit or credit
*/
private function warning($p_message, $p_type, $p_deb)
{
$sql = "select pcm_val,pcm_lib from tmp_pcmn where pcm_type='{$p_type}'";
$res = $this->db->exec_sql($sql);
if (Database::num_row($res) == 0) {
return;
}
$count = 0;
$nRow = Database::num_row($res);
$ret = "";
$obj = new Acc_Account_Ledger($this->db, 0);
for ($i = 0; $i < $nRow; $i++) {
$line = Database::fetch_array($res, $i);
/* set the periode filter */
$sql = sql_filter_per($this->db, $this->from, $this->to, 'p_id', 'j_tech_per');
$obj->id = $line['pcm_val'];
$solde = $obj->get_solde_detail($sql);
$solde_signed = bcsub($solde['debit'], $solde['credit']);
if ($solde_signed < 0 && $p_deb == 'D' || $solde_signed > 0 && $p_deb == 'C') {
$ret .= '<li> ' . HtmlInput::history_account($line['pcm_val'], 'Anomalie pour le compte ' . $line['pcm_val'] . ' ' . h($line['pcm_lib']) . " D: " . $solde['debit'] . " C: " . $solde['credit'] . " diff " . $solde['solde']);
$count++;
}
}
echo '<fieldset>';
echo '<legend>' . $p_message . '</legend>';
if ($count != 0) {
echo '<ol>' . $ret . '</ol>';
echo '<span class="error">' . _("Nbres anomalies") . ' : ' . $count . '</span>';
} else {
echo _("Pas d'anomalie détectée");
}
echo '</fieldset>';
}
$letter->get_letter();
}
// unlettered
if ($_GET['histo'] == 2) {
$letter->get_unletter();
}
if ($_GET['histo'] == 6) {
$letter->get_letter_diff();
}
/* skip if nothing to display */
if (count($letter->content) == 0) {
continue;
}
$detail_card = HtmlInput::card_detail($row->strAttribut(ATTR_DEF_QUICKCODE), $row->strAttribut(ATTR_DEF_NAME));
echo '<h2>' . $detail_card;
echo "poste " . ":" . HtmlInput::history_account($row->strAttribut(ATTR_DEF_ACCOUNT), $row->strAttribut(ATTR_DEF_ACCOUNT), 'display:inline') . HtmlInput::infobulle(27) . '</h2>';
echo '<table class="result">';
echo '<tr>';
echo th(_('Date'));
echo th(_('ref'));
echo th(_('Interne'));
echo th(_('Comm'));
echo th(_('Montant'), 'style="width:auto" colspan="2"');
echo th(_('Prog.'));
echo th(_('Let.'));
echo '</tr>';
$amount_deb = 0;
$amount_cred = 0;
$prog = 0;
bcscale(2);
for ($i = 0; $i < count($letter->content); $i++) {
<?php
echo h($array[$i]['fd_label']);
?>
</td>
<td>
<?php
echo h($array[$i]['vw_description']);
?>
</td>
<td>
<?php
echo h($array[$i]['tva_num']);
?>
</td>
<td style="text-align:right">
<?php
echo HtmlInput::history_account($array[$i]['poste'], $array[$i]['poste']);
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
echo HtmlInput::button_close("boxsearch_card_div");
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>';
}
}
?>
<li><?php
echo HtmlInput::card_detail($a_qcode[$i]["j_qcode"], $a_qcode[$i]["j_qcode"], ' style="display:inline"');
echo " ";
echo HtmlInput::history_card($a_qcode[$i]["f_id"], _("Hist."), ' display:inline');
?>
</li>
<ul>
<?php
$all_dep = Database::fetch_all($poste);
for ($e = 0; $e < count($all_dep); $e++) {
?>
<li>
<?php
echo HtmlInput::history_account($all_dep[$e]['j_poste'], $all_dep[$e]['j_poste'], ' display:inline ');
?>
<?php
echo h($all_dep[$e]['pcm_lib']);
?>
</li>
<?php
}
?>
</ul>
<?php
}
?>
</ol>
<h2><?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>
<?php
echo HtmlInput::card_detail($row['qcode'], "", ' class="line" ');
?>
</td>
<td>
<?php
echo h($row['name']);
?>
</td>
<td>
<?php
echo HtmlInput::history_account($row['poste'], $row['poste']);
?>
</td>
<?php
if ($allcard == 1) {
?>
<td>
<?php
echo h($row['fd_label']);
?>
</td>
<?php
}
?>
<td>
<?php
function display_html()
{
bcscale(2);
if ($this->check() != 0) {
alert('Désolé mais une des dates données n\'est pas valide');
return;
}
if ($this->card_poste == '1') {
$this->load_card();
echo '<table class="result">';
echo '<tr>';
echo th('Fiche');
foreach ($this->aheader as $h) {
echo '<th style="text-align:right">' . h($h['po_name']) . '</th>';
}
echo th('Total', ' style="text-align:right"');
echo '</tr>';
/*
* Show all the result
*/
$tot_global = 0;
for ($i = 0; $i < count($this->arow); $i++) {
$tr = $i % 2 == 0 ? '<tr class="even">' : '<tr class="odd">';
echo $tr;
echo td(HtmlInput::history_card($this->arow[$i]['f_id'], $this->arow[$i]['card_account'] . ' ' . $this->arow[$i]['name']));
$tot_row = 0;
for ($x = 0; $x < count($this->aheader); $x++) {
$amount = $this->db->get_value($this->sql, array($this->arow[$i]['f_id'], $this->aheader[$x]['po_id']));
if ($amount == null) {
$amount = 0;
}
if (isset($tot_col[$x])) {
$tot_col[$x] = bcadd($tot_col[$x], $amount);
} else {
$tot_col[$x] = $amount;
}
echo td(nbm($amount), ' class="num" ');
$tot_row = bcadd($tot_row, $amount);
}
echo td(nbm($tot_row), ' class="num"');
$tot_global = bcadd($tot_global, $tot_row);
echo '</tr>';
}
echo '<tr>';
echo td('Totaux');
for ($i = 0; $i < count($this->aheader); $i++) {
echo td(nbm($tot_col[$i]), ' class="num"');
}
echo td(nbm($tot_global), ' class="num input_text notice" ');
echo '</tr>';
echo '</table>';
}
if ($this->card_poste == '2') {
$this->load_poste();
echo '<table class="result">';
echo '<tr>';
echo th('poste comptable ');
foreach ($this->aheader as $h) {
echo '<th style="text-align:right">' . h($h['po_name']) . '</th>';
}
echo th('Total', ' style="text-align:right"');
echo '</tr>';
/*
* Show all the result
*/
$tot_global = 0;
for ($i = 0; $i < count($this->arow); $i++) {
$tr = $i % 2 == 0 ? '<tr class="even">' : '<tr class="odd">';
echo $tr;
echo td(HtmlInput::history_account($this->arow[$i]['card_account'], $this->arow[$i]['card_account'] . ' ' . $this->arow[$i]['name']));
$tot_row = 0;
for ($x = 0; $x < count($this->aheader); $x++) {
$amount = $this->db->get_value($this->sql, array($this->arow[$i]['card_account'], $this->aheader[$x]['po_id']));
if ($amount == null) {
$amount = 0;
}
if (isset($tot_col[$x])) {
$tot_col[$x] = bcadd($tot_col[$x], $amount);
} else {
$tot_col[$x] = $amount;
}
echo td(nbm($amount), ' class="num" ');
$tot_row = bcadd($tot_row, $amount);
}
echo td(nbm($tot_row), ' class="num"');
$tot_global = bcadd($tot_global, $tot_row);
echo '</tr>';
}
echo '<tr>';
echo td('Totaux');
for ($i = 0; $i < count($this->aheader); $i++) {
echo td(nbm($tot_col[$i]), ' class="num"');
}
echo td(nbm($tot_global), ' class="num input_text notice" ');
echo '</tr>';
echo '</table>';
}
}
echo $class;
?>
">
<td style="padding-right:55px">
<a href="javascript:void(0)" class="detail" onclick="<?php
echo $array[$i]['javascript'];
?>
">
<?php
echo $array[$i]['quick_code'];
?>
</a>
</td>
<td>
<?php
echo HtmlInput::history_account($array[$i]['accounting'], $array[$i]['accounting']);
?>
</td>
<td>
<?php
echo $array[$i]['name'];
?>
</td>
<td>
<?php
echo $array[$i]['first_name'];
?>
</td>
<td>
<?php
echo $array[$i]['description'];
$A = Database::fetch_array($Ret, $i);
$class = $i % 2 == 0 ? "even" : "odd";
?>
<tr id="row_<?php
echo $A['pcm_val'];
?>
" class="<?php
echo $class;
?>
">
<td class="<?php
echo $class;
?>
">
<?php
echo HtmlInput::history_account($A['pcm_val'], $A['pcm_val']);
?>
</td>
<td class="<?php
echo $class;
?>
">
<?php
printf("<A style=\"text-decoration:underline\" HREF=\"javascript:void(0)\" onclick=\"pcmn_update(%d,'%s')\">", $str_dossier, $A['pcm_val']);
echo h($A['pcm_lib']);
?>
</td>
<td class="<?php
echo $class;
?>
">