/** * Objekte auf PDF zeichnen * * @param array $templ * @param array $data */ function _write_object($templ, $data) { global $barcode; for ($i = 0; $i < count($templ); $i++) { if ($templ[$i]['user_type'] == $row['type'] || $templ[$i]['user_type'] == "0") { switch ($templ[$i]['type']) { case 'text': $this->pdf->SetFont($templ[$i]['font'], '', $templ[$i]["fontsize"]); $this->pdf->SetTextColor($templ[$i]["red"], $templ[$i]["green"], $templ[$i]["blue"]); if ($templ[$i]['end_x'] == "1") { $this->pdf->Text($templ[$i]["pos_x"] - $this->pdf->GetStringWidth($templ[$i]['text']) + $this->x, $templ[$i]["pos_y"] + $this->y, $templ[$i]['text']); } else { $this->pdf->Text($templ[$i]["pos_x"] + $this->x, $templ[$i]["pos_y"] + $this->y, $templ[$i]['text']); } break; case 'rect': $this->pdf->SetDrawColor($templ[$i]["red"], $templ[$i]["green"], $templ[$i]["blue"]); if ($templ[$i]['fontsize'] == "1") { $this->pdf->SetFillColor($templ[$i]["red"], $templ[$i]["green"], $templ[$i]["blue"]); $this->pdf->Rect($templ[$i]['pos_x'] + $this->x, $templ[$i]['pos_y'] + $this->y, $templ[$i]['end_x'], $templ[$i]['end_y'], "FD"); } else { $this->pdf->SetFillColor(255); $this->pdf->Rect($templ[$i]['pos_x'] + $this->x, $templ[$i]['pos_y'] + $this->y, $templ[$i]['end_x'], $templ[$i]['end_y']); } break; case 'line': $this->pdf->SetDrawColor($templ[$i]["red"], $templ[$i]["green"], $templ[$i]["blue"]); $this->pdf->Line($templ[$i]['pos_x'] + $this->x, $templ[$i]['pos_y'] + $this->y, $templ[$i]['end_x'] + $this->x, $templ[$i]['end_y'] + $this->y); break; case 'image': $this->pdf->Image(IMAGE_PATH . $templ[$i]['text'], $templ[$i]['pos_x'] + $this->x, $templ[$i]['pos_y'] + $this->y, $templ[$i]['end_x'], $templ[$i]['end_y']); break; case 'barcode': $imagename = mt_rand(100000, 999999); $barcode->get_image($data['userid'], BARCODE_PATH . $imagename); $this->pdf->Image(BARCODE_PATH . $imagename . ".png", $templ[$i]['pos_x'] + $this->x, $templ[$i]['pos_y'] + $this->y); $barcode->kill_image(BARCODE_PATH . $imagename); case 'data': $this->pdf->SetFont($templ[$i]['font'], '', $templ[$i]["fontsize"]); $this->pdf->SetTextColor($templ[$i]["red"], $templ[$i]["green"], $templ[$i]["blue"]); if ($templ[$i]['end_x'] == "1") { $this->pdf->Text($templ[$i]["pos_x"] - $this->pdf->GetStringWidth($data[$templ[$i]['text']]) + $this->x, $templ[$i]["pos_y"] + $this->y, $data[$templ[$i]['text']]); } else { $this->pdf->Text($templ[$i]["pos_x"] + $this->x, $templ[$i]["pos_y"] + $this->y, $data[$templ[$i]['text']]); } break; } } } }
include "utility.php"; $cubename_sel = $_POST["cubename"]; $colonna = $_POST["ordinamento_col"]; $ordinamento = $_POST["ordinamento_type"]; $slice = $_POST["slice"]; $levels = unserialize(stripslashes($_POST['levels'])); $level_ser = implode("-", $levels); $query = SQLgenerator2($cubename_sel, $level_ser, $slice, $colonna, $ordinamento); $result = exec_query($query); $ncols = mysql_num_fields($result); define('FPDF_FONTPATH', '../fpdf/font/'); require '../fpdf/fpdf.php'; $p = new fpdf(); $p->Open(); $p->AddPage(); $p->SetTextColor(0); $p->SetFont('Arial', '', 8); $w = 10; $h = 10; $off_h = 5; $off_w = 40; //***************************Heading for ($i = 0; $i < $ncols; $i++) { $colname = mysql_fetch_field($result); $nome = $colname->name; $tabella = $colname->table; if ($tabella == "") { $field = "{$nome}"; } else { $field = "{$tabella}.{$nome}"; }