Пример #1
0
 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;
 }
Пример #2
0
 /**
  * @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>';
 }
Пример #3
0
     $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++) {
Пример #4
0
			<?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");
Пример #5
0
 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>';
     }
 }
Пример #6
0
    ?>
        <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 
Пример #7
0
 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;
 }
Пример #8
0
    ?>
 >
				<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 
Пример #9
0
 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>';
     }
 }
Пример #10
0
    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'];
Пример #11
0
    $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;
    ?>
">