$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 = "";
