$fil .= $fpublisher == "0" || $fpublisher == "" ? "" : " `publisher`='{$fpublisher}'"; $filt .= $filt == "" ? $fil : " AND " . $fil; $fil .= $flanguage == "0" || $flanguage == "" ? "" : " `language`='{$flanguage}'"; $filt .= $filt == "" ? $fil : " AND " . $fil; $filt = $filt == "" ? "" : " WHERE " . $filt; $ord = gets('sortby'); $ord = $ord == "" ? "" : " ORDER BY " . $ord; $sql = "SELECT * FROM `catalog` " . $filt . $ord; //echo $sql; $pdf->setCellPaddings(1, 1, 1, 1); $t = mysql_query($sql); while ($f = dbFA($t)) { $i = 0; if ($pdf->GetY() > 190) { $pdf->AddPage(); dc_tableHead($th, $tw, $ta); } $ny = $pdf->GetY(); $my = 0; if ($tc[dp_Title] == '1') { $pdf->MultiCell($tw[$i++], 0, str_replace("\\'", "'", $f['title']), 0, 'L', 0, 0, '', '', true); } if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); } if ($tc[dp_Callnumber] == '1') { $pdf->MultiCell($tw[$i++], 0, $f['callnumber'], 0, 'L', 0, 0, '', '', true); } if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); }
$fil .= $flevel == "0" ? "" : " `level`='{$flevel}'"; $filt .= $filt == "" ? $fil : " AND " . $fil; $fil .= $fgroup == "0" ? "" : " `group`='{$fgroup}'"; $filt .= $filt == "" ? $fil : " AND " . $fil; $fil .= $fgroup == "0" ? "" : " `division`='{$fdivision}'"; $filt .= $filt == "" ? $fil : " AND " . $fil; $filt = $filt == "" ? "" : " WHERE " . $filt; $ord = gets('sortby'); $sql = "SELECT * FROM employee " . $filt . " ORDER BY " . $ord; //echo $sql; $t = mysql_query($sql); while ($f = dbFA($t)) { $i = 0; if ($pdf->GetY() > 190) { $pdf->AddPage(); dc_tableHead($th, $tw); } if ($tc[dp_Name] == '1') { $pdf->MultiCell($tw[$i++], 0, $f['name'], 0, 'L', 0, 0, '', '', true); } if ($tc[dp_Nip] == '1') { $pdf->MultiCell($tw[$i++], 0, $f['nip'], 0, 'L', 0, 0, '', '', true); } if ($tc[dp_Status] == '1') { $pdf->MultiCell($tw[$i++], 0, $mstr_status[$f['status']], 0, 'L', 0, 0, '', '', true); } if ($tc[dp_Level] == '1') { $pdf->MultiCell($tw[$i++], 0, $mstr_level[$f['level']], 0, 'L', 0, 0, '', '', true); } if ($tc[dp_Group] == '1') { $pdf->MultiCell($tw[$i++], 0, $mstr_group[$f['group']], 0, 'L', 0, 0, '', '', true);