$g_user->check(); $g_user->check_dossier(dossier::id()); set_language(); if ($d == 'all') { $filter_card = ''; } else { if (strpos($d, 'sql]') == true) { $filter_card = str_replace('[sql]', " and ", $d); } else { $filter_card = "and fd_id in ({$d})"; } } if ($jrn != -1) { switch ($d) { case 'cred': $filter_jrn = $cn->make_list("select jrn_def_fiche_cred from jrn_def where jrn_def_id=\$1", array($jrn)); $filter_card = $filter_jrn != "" ? " and fd_id in ({$filter_jrn})" : ' and false '; break; case 'deb': $filter_jrn = $cn->make_list("select jrn_def_fiche_deb from jrn_def where jrn_def_id=\$1", array($jrn)); $filter_card = $filter_jrn != "" ? " and fd_id in ({$filter_jrn})" : ' and false '; break; case 'filter': $get_cred = 'jrn_def_fiche_cred'; $get_deb = 'jrn_def_fiche_deb'; $deb = $cn->get_value("select {$get_deb} from jrn_def where jrn_def_id=\$1", array($jrn)); $cred = $cn->get_value("select {$get_cred} from jrn_def where jrn_def_id=\$1", array($jrn)); $filter_jrn = ""; if ($deb !== '' && $cred != '') { $filter_jrn = $deb . ',' . $cred; } elseif ($deb != '') {
$g_user->check_dossier(dossier::id()); set_language(); $fLabel = isset($_REQUEST['l']) ? $_REQUEST['l'] : 'none'; $fTva_id = isset($_REQUEST['t']) ? $_REQUEST['t'] : 'none'; $fPrice_sale = isset($_REQUEST['p']) ? $_REQUEST['p'] : 'none'; $fPrice_purchase = isset($_REQUEST['b']) ? $_REQUEST['b'] : 'none'; if (isset($_SESSION['isValid']) && $_SESSION['isValid'] == 1) { $jrn = sql_string($_GET['j']); $d = sql_string($_GET['d']); if ($jrn == -1) { $d = 'all'; } if (strpos($d, 'sql') == false) { switch ($d) { case 'cred': $filter_jrn = $cn->make_list("select jrn_def_fiche_cred from jrn_def where jrn_def_id=\$1", array($jrn)); $filter_card = $filter_jrn != "" ? " and fd_id in ({$filter_jrn})" : ' and false '; break; case 'deb': $filter_jrn = $cn->make_list("select jrn_def_fiche_deb from jrn_def where jrn_def_id=\$1", array($jrn)); $filter_card = $filter_jrn != "" ? " and fd_id in ({$filter_jrn})" : ' and false '; break; case 'all': $filter_card = ""; break; case 'filter': $get_cred = 'jrn_def_fiche_cred'; $get_deb = 'jrn_def_fiche_deb'; $deb = $cn->get_value("select {$get_deb} from jrn_def where jrn_def_id=\$1", array($jrn)); $cred = $cn->get_value("select {$get_cred} from jrn_def where jrn_def_id=\$1", array($jrn)); $filter_jrn = "";