Example #1
0
$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();
    }
Example #2
0
$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);