Пример #1
0
function afficheSousRubriques($bud, $id_rub, &$form, $indent = 0)
{
    global $dbh, $charset;
    global $view_lig_rub_form, $lig_rub_img, $lig_indent;
    global $acquisition_gestion_tva;
    switch ($acquisition_gestion_tva) {
        case '0':
        case '2':
            $htttc = htmlentities($msg['acquisition_ttc'], ENT_QUOTES, $charset);
            $k_htttc = 'ttc';
            $k_htttc_autre = 'ht';
            break;
        default:
            $htttc = htmlentities($msg['acquisition_ht'], ENT_QUOTES, $charset);
            $k_htttc = 'ht';
            $k_htttc_autre = 'ttc';
            break;
    }
    $id_bud = $bud->id_budget;
    $q = budgets::listRubriques($id_bud, $id_rub);
    $list_n = pmb_mysql_query($q, $dbh);
    while ($row = pmb_mysql_fetch_object($list_n)) {
        $form = str_replace('<!-- sous_rub' . $id_rub . ' -->', $view_lig_rub_form . '<!-- sous_rub' . $id_rub . ' -->', $form);
        $marge = '';
        for ($i = 0; $i < $indent; $i++) {
            $marge .= $lig_indent;
        }
        $form = str_replace('<!-- marge -->', $marge, $form);
        $nb_sr = rubriques::countChilds($row->id_rubrique);
        if ($nb_sr) {
            $form = str_replace('<!-- img_plus -->', $lig_rub_img, $form);
        } else {
            $form = str_replace('<!-- img_plus -->', '', $form);
        }
        $form = str_replace('<!-- sous_rub -->', '<!-- sous_rub' . $row->id_rubrique . ' -->', $form);
        $form = str_replace('!!id_rub!!', $row->id_rubrique, $form);
        $form = str_replace('!!id_parent!!', $row->num_parent, $form);
        $libelle = htmlentities($row->libelle, ENT_QUOTES, $charset);
        $form = str_replace('!!lib_rub!!', $libelle, $form);
        //montant total
        $mnt['tot'][$k_htttc] = $row->montant;
        //montant a valider
        $mnt['ava'] = rubriques::calcAValider($row->id_rubrique);
        //montant engage
        $mnt['eng'] = rubriques::calcEngage($row->id_rubrique);
        //montant facture
        $mnt['fac'] = rubriques::calcFacture($row->id_rubrique);
        //montant paye
        $mnt['pay'] = rubriques::calcPaye($row->id_rubrique);
        //solde
        $mnt['sol'][$k_htttc] = $mnt['tot'][$k_htttc] - $mnt['eng'][$k_htttc];
        $lib_mnt = array();
        foreach ($mnt as $k => $v) {
            $lib_mnt[$k] = number_format($mnt[$k][$k_htttc], 2, '.', ' ');
            if ($acquisition_gestion_tva && $k != "tot" && $k != "sol") {
                $lib_mnt_autre[$k] = number_format($mnt[$k][$k_htttc_autre], 2, '.', ' ');
            }
        }
        if ($bud->type_budget == TYP_BUD_GLO) {
            $lib_mnt['tot'] = '&nbsp;';
            $lib_mnt['sol'] = '&nbsp;';
        }
        foreach ($lib_mnt as $k => $v) {
            if (!$acquisition_gestion_tva || !$lib_mnt_autre[$k]) {
                $form = str_replace('!!mnt_' . $k . '!!', $lib_mnt[$k], $form);
            } elseif ($acquisition_gestion_tva) {
                $form = str_replace('!!mnt_' . $k . '!!', $lib_mnt[$k] . "<br />" . $lib_mnt_autre[$k], $form);
            }
        }
        if ($nb_sr) {
            afficheSousRubriques($bud, $row->id_rubrique, $form, $indent + 1);
        }
    }
}
Пример #2
0
function afficheSousRubriques($id_bud, $id_rub, &$form, $indent = 0)
{
    global $dbh, $msg, $charset;
    global $lig_rub, $lig_rub_img, $lig_indent;
    $bud = new budgets($id_bud);
    $q = budgets::listRubriques($id_bud, $id_rub);
    $list_n = mysql_query($q, $dbh);
    while ($row = mysql_fetch_object($list_n)) {
        $form = str_replace('<!-- sous_rub' . $id_rub . ' -->', $lig_rub[0] . '<!-- sous_rub' . $id_rub . ' -->', $form);
        $marge = '';
        for ($i = 0; $i < $indent; $i++) {
            $marge .= $lig_indent;
        }
        $form = str_replace('<!-- marge -->', $marge, $form);
        if (rubriques::countChilds($row->id_rubrique)) {
            $form = str_replace('<!-- img_plus -->', $lig_rub_img, $form);
        } else {
            $form = str_replace('<!-- img_plus -->', '', $form);
        }
        $form = str_replace('<!-- sous_rub -->', '<!-- sous_rub' . $row->id_rubrique . ' -->', $form);
        $form = str_replace('!!id_rub!!', $row->id_rubrique, $form);
        $form = str_replace('!!id_parent!!', $row->num_parent, $form);
        $form = str_replace('!!lib_rub!!', $row->libelle, $form);
        if ($bud->type_budget == TYP_BUD_RUB) {
            $form = str_replace('!!mnt!!', $row->montant, $form);
        } else {
            $form = str_replace('!!mnt!!', '&nbsp;', $form);
        }
        $form = str_replace('!!ncp!!', $row->num_cp_compta, $form);
        afficheSousRubriques($id_bud, $row->id_rubrique, $form, $indent + 1);
    }
}