$width = $pdf->w - $pdf->lMargin - $pdf->rMargin; $height = 12; $pdf->AddPage(); $pdf->SetFillColor(255, 255, 255); $pdf->SetFont('Arial', '', 7); $subtot = array(); foreach ($dtKary as $lstKary) { $noe += 1; $pdf->Cell(3 / 100 * $width, $height, $noe, 1, 0, 'C', 1); $pdf->Cell(13 / 100 * $width, $height, $optNmKar[$lstKary], 1, 0, 'L', 1); $pdf->Cell(7 / 100 * $width, $height, $optTipe[$optTipeId[$lstKary]], 1, 0, 'C', 1); $pdf->Cell(10 / 100 * $width, $height, number_format($dtGaji[$lstKary], 0), 1, 0, 'R', 1); $totGaji += $dtGaji[$lstKary]; foreach ($test as $barisTgl => $isiTgl) { $pdf->Cell(1.5 / 100 * $width, $height, $dtAbsens[$lstKary][$isiTgl], 1, 0, 'C', 1); $akhirX = $pdf->GetX(); } foreach ($klmpkAbsn as $brsKet => $hslKet) { $pdf->Cell(2 / 100 * $width, $height, $brt[$lstKary][$hslKet['kodeabsen']], 1, 0, 'C', 1); $subtot[$lstKary]['total'] += $brt[$lstKary][$hslKet['kodeabsen']]; } $pdf->Cell(5 / 100 * $width, $height, $subtot[$lstKary]['total'], 1, 1, 'R', 1); } $pdf->Output(); break; case 'excel': //echo "warning:".$strx; //================================================= $tab .= "Print Time:" . date('Y-m-d H:i:s') . "<br>By:" . $_SESSION['empl']['name']; $dt = date("His"); $nop_ = "daftar_remise_" . $dt;
/** * PDF image renderer * * @param PDF $pdf * * @return void */ function render($pdf) { global $lastpicbottom, $lastpicpage, $lastpicleft, $lastpicright; // Check for a pagebreak first if ($pdf->checkPageBreakPDF($this->height + 5)) { $this->y = $pdf->GetY(); } $curx = $pdf->GetX(); // If current position (left)set "." if ($this->x == ".") { $this->x = $pdf->GetX(); } else { $this->x = $pdf->addMarginX($this->x); $pdf->SetX($curx); } if ($this->y == ".") { //-- first check for a collision with the last picture if (isset($lastpicbottom)) { if ($pdf->PageNo() == $lastpicpage && $lastpicbottom >= $pdf->GetY() && $this->x >= $lastpicleft && $this->x <= $lastpicright) { $pdf->SetY($lastpicbottom + 5); } } $this->y = $pdf->GetY(); } else { $pdf->SetY($this->y); } if ($pdf->getRTL()) { $pdf->Image($this->file, $pdf->getPageWidth() - $this->x, $this->y, $this->width, $this->height, "", "", $this->line, false, 72, $this->align); } else { $pdf->Image($this->file, $this->x, $this->y, $this->width, $this->height, "", "", $this->line, false, 72, $this->align); } $lastpicpage = $pdf->PageNo(); $pdf->lastpicpage = $pdf->getPage(); $lastpicleft = $this->x; $lastpicright = $this->x + $this->width; $lastpicbottom = $this->y + $this->height; // Setup for the next line if ($this->line == "N") { $pdf->SetY($lastpicbottom); } }
/** * PDF line renderer * * @param PDF $pdf * * @return void */ function render($pdf) { if ($this->x1 == ".") { $this->x1 = $pdf->GetX(); } if ($this->y1 == ".") { $this->y1 = $pdf->GetY(); } if ($this->x2 == ".") { $this->x2 = $pdf->getMaxLineWidth(); } if ($this->y2 == ".") { $this->y2 = $pdf->GetY(); } if ($pdf->getRTL()) { $pdf->Line($pdf->getPageWidth() - $this->x1, $this->y1, $pdf->getPageWidth() - $this->x2, $this->y2); } else { $pdf->Line($this->x1, $this->y1, $this->x2, $this->y2); } }
} if (!is_null($row['ta_Email']) && $row['ta_Email'] != '') { $contatti .= $row['ta_Email'] . ' '; } $pdf->Cell(135, 6, ' ' . $contatti, 1, 1); $pdf->Cell(40, 6, 'Tutor scolastico ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' prof. ' . utf8_decode($row['TUT_Nome']) . ' ' . utf8_decode($row['TUT_Cognome']), 1, 1); $pdf->Cell(40, 6, 'Contatti ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . $row['TUT_Cellulare'] . ' ' . $row['TUT_Email'], 1, 1); /* $pdf->Cell(40,12,'Applicazione competenze ',1,0,'R',1); $pdf->MultiCell(135,4,' '.utf8_decode($row['STA_Compito']),1,1);*/ $pdf->Ln(3); $pdf->SetFont('abac', '', 11); $pdf->Cell(0, 8, "Polizze assicurative", 0, 2); $pdf->SetFont('abalc', '', 9); $pdf->Rect($pdf->GetX() + 6, $pdf->GetY(), 169, 8); $pdf->Cell(6); $pdf->Cell(0, 4, "INAIL Codice PAT n. " . $rsmeucci['INAIL_Pat'] . " - Infortuni sul lavoro Polizza n. " . $rsmeucci['ASS_Infortuni'], 0, 2); $pdf->Cell(0, 4, "Responsabilità civile Polizza n. " . $rsmeucci['ASS_RespCivile'] . " (Compagnia assicurativa " . $rsmeucci['ASS_Compagnia'] . ")"); $pdf->Ln(5); $pdf->SetFont('abac', '', 11); $pdf->Cell(0, 8, "Obiettivi e modalità del Tirocinio", 0, 2); $pdf->SetFont('abalc', '', 9); $pdf->Cell(6); $pdf->MultiCell(169, 4, "Orientamento: Prendere coscienza delle abilità specifiche necessarie all'inserimento in un settore produttivo e delle possibilità di autorealizzazione in un ambiente diverso da quello familiare e scolastico.", 'TLR', 2); $pdf->Cell(6); $pdf->MultiCell(169, 4, "Socializzazione: Formare o potenziare le abilità comunicative e rafforzare determinate abilità cognitive, sociali e professionali; sviluppare le capacità di adattamento al fine di assumere atteggiamenti idonei rispetto all'ambiente operativo in cui gli alunni vengono inseriti.", 'LR', 2); $pdf->Cell(6); $pdf->MultiCell(169, 4, "Sviluppo di abilità: Acquisire la capacità di rendersi autonomo nello svolgere i compiti assegnati; Sviluppare precisione ed accuratezza nell'effettuare il lavoro assegnato.", 'LR', 2); $pdf->Cell(6); $pdf->MultiCell(169, 4, "Comportamento: Educazione al rispetto degli orari; sviluppare un corretto rapporto con gli altri dipendenti; capire l'importanza della cura delle attrezzature.", 'LR', 2);
} //================================ $pdf = new PDF('L', 'pt', 'A4'); $width = $pdf->w - $pdf->lMargin - $pdf->rMargin; $height = 10; $pdf->AddPage(); $pdf->SetFillColor(255, 255, 255); $pdf->SetFont('Arial', '', 4.5); if ($modPil != '2') { $ang = 1; $totalThn = count($dtThnBudget); $totalThn = $totalThn + 1; foreach ($dtThnBudget as $brsThnBudget) { if ($ang == 1) { $bmilY = $pdf->GetY(); $bmilX = $pdf->GetX(); $pdf->SetY($bmilY + 10); $pdf->Cell(15, $height, $ang, 1, 0, 'C'); $modPil == '0' ? $pdf->Cell(50, $height, $brsThnBudget, 1, 0, 'L') : $pdf->Cell(50, $height, $brsThnBudget . "[" . $dtJmlhThnTnm[$thnBudget][$brsThnBudget] . "]", 1, 0, 'L'); } else { if ($ang < $totalThn) { $bmilY = $pdf->GetY(); $bmilX = $pdf->GetX(); $pdf->SetY($bmilY + 10); $pdf->Cell(15, $height, $ang, 1, 0, 'C'); $modPil == '0' ? $pdf->Cell(50, $height, $brsThnBudget, 1, 0, 'L') : $pdf->Cell(50, $height, $brsThnBudget . "[" . $dtJmlhThnTnm[$thnBudget][$brsThnBudget] . "]", 1, 0, 'L'); } } $ang += 1; for ($pdfAngk = 1; $pdfAngk <= $totalUnit + 1; $pdfAngk++) { if ($pdfAngk != $totalUnit + 1) {
$strv = "select namabarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $bar->kodebarang . "'"; $resv = mysql_query($strv); $barv = mysql_fetch_object($resv); $namabarang = $barv->namabarang; $pdf->Cell(8, 5, $no, 1, 0, 'L', 1); $pdf->Cell(42, 5, $bar->nopo, 1, 0, 'L', 1); $pdf->Cell(28, 5, $kodebarang, 1, 0, 'C', 1); $pdf->Cell(80, 5, $namabarang, 1, 0, 'L', 1); $pdf->Cell(15, 5, $satuan, 1, 0, 'L', 1); $pdf->Cell(18, 5, number_format($jumlah, 2, '.', ','), 1, 1, 'R', 1); } //footer================================ // $dtpenerima=namakaryawan($dbname,$conn,$penerima); // $dtpengetahui=namakaryawan($dbname,$conn,$pengetahui); $dptinY = $pdf->GetY(); $dptinX = $pdf->GetX(); $pdf->SetY($dptinY + 25); $pdf->SetX($dptinX); $pdf->SetFillColor(255, 255, 255); $pdf->SetFont('Arial', 'B', 8); if (substr($expend, 0, 1) == 'S') { $dert = $_SESSION['lang']['expeditor']; $duer = $optSupplier[$expend]; } else { $dert = $_SESSION['lang']['dibawa']; $duer = $optKary[$expend]; } $pdf->Cell(50, $height, $_SESSION['lang']['penerima'] . ",", 0, 0, 'C', 0); $pdf->Cell(70, $height, $dert . ",", 0, 0, 'C', 0); $pdf->Cell(65, $height, $_SESSION['lang']['pengirim'] . ",", 0, 1, 'C', 0); $pdf->ln(25);
if ($nama_bagian != '') { $pdf->AddPage(); } $nama_bagian = $outbox->nama_bagian; $pdf->ChapterTitle($nama_bagian); } if ($pdf->GetY() >= 175) { $pdf->AddPage(); } $i++; $pdf->Cell(-6); $pdf->Cell(6, $margin, $i, 0, 0); $pdf->Cell(30, $margin, $outbox->no_surat, 0, 0); $pdf->Cell(15, $margin, date("d-m-Y", strtotime($outbox->tgl_masuk)), 0, 0); $pdf->Cell(15, $margin, date("d-m-Y", strtotime($outbox->tgl_surat)), 0, 0); $current_x1 = $pdf->GetX(); $current_y1 = $pdf->GetY(); $pdf->Cell(90); $current_x2 = $pdf->GetX(); $current_y2 = $pdf->GetY(); $pdf->Cell(50); $current_x3 = $pdf->GetX(); $current_y3 = $pdf->GetY(); $pdf->Cell(35); $pdf->Cell(30, $margin, $outbox->nama_jenis, 0, 0); $pdf->Cell(0, $margin, $outbox->first_name, 0, 0); $pdf->SetXY($current_x3, $current_y3); $pdf->MultiCell(35, $margin, $outbox->ptt, 0, 'L'); $y3 = $pdf->getY(); $pdf->SetXY($current_x2, $current_y2); $pdf->MultiCell(50, $margin, $outbox->tujuan, 0, 'L');
foreach($tab_liste_item as $item_id) // Pour chaque item... { $releve_PDF->VertCellFit($releve_PDF->cases_largeur, $releve_PDF->etiquette_hauteur, $tab_item[$item_id][0]['item_ref'], 1 /*border*/, 0 /*br*/, TRUE /*fill*/); $releve_HTML_table_head .= '<th title="'.html($tab_item[$item_id][0]['item_nom']).'"><img alt="'.html($tab_item[$item_id][0]['item_ref']).'" src="./_img/php/etiquette.php?dossier='.$_SESSION['BASE'].'&nom='.urlencode($tab_item[$item_id][0]['item_ref']).'&size=8" /></th>'; } } else { foreach($tab_eleve as $tab) // Pour chaque élève... { extract($tab); // $eleve_id $eleve_nom $eleve_prenom $eleve_id_gepi $releve_PDF->VertCellFit($releve_PDF->cases_largeur, $releve_PDF->etiquette_hauteur, $eleve_nom.' '.$eleve_prenom, 1 /*border*/, 0 /*br*/, TRUE /*fill*/); $releve_HTML_table_head .= '<th><img alt="'.html($eleve_nom.' '.$eleve_prenom).'" src="./_img/php/etiquette.php?dossier='.$_SESSION['BASE'].'&nom='.urlencode($eleve_nom).'&prenom='.urlencode($eleve_prenom).'&size=8" /></th>'; } } $releve_PDF->SetX( $releve_PDF->GetX()+2 ); $releve_PDF->choisir_couleur_fond('gris_moyen'); $releve_PDF->Cell($releve_PDF->cases_largeur , $releve_PDF->etiquette_hauteur , '[ * ]' , 1 , 0 , 'C' , true , ''); $releve_PDF->Cell($releve_PDF->cases_largeur , $releve_PDF->etiquette_hauteur , '[ ** ]' , 1 , 1 , 'C' , true , ''); $checkbox_vide = ($affichage_checkbox) ? '<th class="nu"> </th>' : '' ; $releve_HTML_table_head .= '<th class="nu"> </th><th>[ * ]</th><th>[ ** ]</th>'.$checkbox_vide.'</tr></thead>'."\r\n"; // lignes suivantes $releve_HTML_table_body = ''; if($tableau_tri_objet=='eleve') { foreach($tab_eleve as $tab) // Pour chaque élève... { extract($tab); // $eleve_id $eleve_nom $eleve_prenom $eleve_id_gepi $releve_PDF->choisir_couleur_fond('gris_clair'); $releve_PDF->CellFit($releve_PDF->intitule_largeur , $releve_PDF->cases_hauteur , pdf($eleve_nom.' '.$eleve_prenom) , 1 , 0 , 'L' , true , ''); $releve_HTML_table_body .= '<tr><td>'.html($eleve_nom.' '.$eleve_prenom).'</td>';
$pdf->Cell(10, 5, ':', 0, 0, 'C'); $pdf->Cell(80, 5, $dOrder['nopp'], 0, 0, 'L'); $pdf->Cell(15, 5, 'Qty', 0, 0, 'L'); $pdf->Cell(10, 5, ':', 0, 0, 'C'); $pdf->Cell(10, 5, $dOrderJum['jumlah'], 0, 1, 'L'); $pdf->Cell(15, 5, '', 0, 0, 'L'); $pdf->Cell(10, 5, '', 0, 0, 'C'); $pdf->Cell(80, 5, '', 0, 0, 'L'); $pdf->Cell(15, 5, 'Approx Value', 0, 0, 'L'); $pdf->Cell(10, 5, ':', 0, 0, 'C'); $pdf->Cell(10, 5, $dOrder['matauang'] . '. ' . number_format($dOrder['nilaipermintaan'], 2), 0, 1, 'L'); $pdf->SetFont('Arial', '', 5); $pdf->Cell(15, 5, '(Bank by price lowest quotation)', 0, 0, 'L'); $pdf->SetFont('Arial', '', 7); $pdf->Ln(); $awalXjudulno = $pdf->GetX(); $awalYjudulatas = $pdf->GetY(); $pdf->Cell(10, 5, 'No', 1, 0, 'C'); $awalXjudulsup = $pdf->GetX(); $pdf->Cell(50, 5, 'Supplier & Place', 1, 0, 'C'); $awalXjudulbp = $pdf->GetX(); $pdf->Cell(35, 5, 'Basic Price', 1, 0, 'C'); $awalXjudulppn = $pdf->GetX(); $pdf->Cell(30, 5, 'PPN 10%', 1, 0, 'C'); $awalXjudulfp = $pdf->GetX(); $pdf->Cell(35, 5, 'Final Price', 1, 0, 'C'); $awalXjudulpy = $pdf->GetX(); $akhirXjudulpy = $pdf->GetX() + 35; $pdf->Cell(35, 5, 'Payment', 1, 1, 'C'); $pdf->SetFont('Arial', '', 7); $iData = "select * from " . $dbname . ".log_perintaanhargaht where nomor='" . $nodph . "' ";
} else { $sql .= "ORDER BY substr(billno,3,10)"; } // echo "<pre>$sql</pre>"; $result = $mysqli->query($sql); $data = array(); while ($row = $result->fetch_assoc()) { $data[] = $row; } $result->close(); $first = true; foreach ($data as $d) { if (isset($_GET['printaddress']) && $_GET['printaddress'] == 'Y') { $pdf->AddPage(); $pdf->SetFont('Arial', '', 10); $x = $pdf->GetX() + 60; $y = $pdf->GetY() + 85; $pdf->SetXY($x, $y); $w = $pdf->h - $pdf->bMargin - $pdf->y; $pdf->RotatedCell(270, $w, 6, $d['party_name'], 0, 1, 'L'); $pdf->RotatedCell(270, $w, 6, $d['party_address'], 0, 1, 'L'); $pdf->RotatedCell(270, $w, 6, $d['party_city'], 0, 1, 'L'); } else { $invoice = $d['sale_master_id']; $partyName = $d['party_name']; $partyCity = $d['party_city']; $billno = $d['billno']; $date = $d['sale_date_fmt']; $billteNo = $d['billte_no']; $transporter = $d['transporter_name']; $address = $d['party_address'];
$business_id = $gd['business_id']; //check if line is paid $lp = mysql_query("select * from ebpls_transaction_payment_or_details a, ebpls_transaction_payment_or b where a.trans_id='{$owner_id}' and a.payment_id='{$business_id}' and a.ts between '{$date_from} 00:00:00' and '{$date_to} 23:59:59' and a.or_no = b.or_no"); //echo "select * from tempbusnature where owner_id='$owner_id' and business_id='$business_id' and recpaid='1'"; //$lp = mysql_query("select * from tempbusnature a, ebpls_buss_nature b, ebpls_transaction_payment_or_details c where owner_id='$owner_id' and business_id='$business_id' and recpaid='1' and a.bus_code=b.natureid and //a.owner_id=c.trans_id and a.business_id=c.payment_id and c.ts between '$date_from 00:00:00' and '$date_to 23:59:59'"); while ($gp = mysql_fetch_assoc($lp)) { //get details $f = 0; $pdf->SetX(5); $pdf->Cell(50, 5, $gd[fulln], 1, 0, 'C'); $pdf->Cell(240, 5, $gd[business_name] . "/" . $gd[business_add], 1, 0, 'L'); //get or $getor = mysql_query("select * from ebpls_transaction_payment_or_details a, ebpls_transaction_payment_or b where a.trans_id='{$owner_id}' and a.payment_id='{$business_id}' and a.or_no=b.or_no"); $getor = mysql_fetch_assoc($getor); $RX = $pdf->GetX(); $pdf->Cell(40, 5, '', 1, 0, 'C'); //$pdf->Cell(40,5,$getor[or_no],1,0,'C'); //get paytax/fee $gettax = mysql_Query("select * from tempassess a where a.owner_id='{$owner_id}' and a.business_id='{$business_id}'"); $dfv = 0; while ($gett = mysql_fetch_assoc($gettax)) { //while ($dfv < $v) { $dfv++; //display $f++; $disp = mysql_Query("select sum(amount) from ebpls_payment_details a, rpt_temp_abs b where a.owner_id='{$owner_id}' and a.business_id='{$business_id}' and a.tfoid='{$tfoid[$f]}' and a.tfoid = b.tfoid and or_no = '{$gp['payment_code']}' order by or_no asc"); //echo "select * from ebpls_payment_details a where a.owner_id='$owner_id' and a.business_id='$business_id' and a.tfoid='$tfoid[$f]' <br>"; //$disp = mysql_Query("select * from tempassess a where a.owner_id='$owner_id' and a.business_id='$business_id' and a.natureid='$gp[bus_code]' and a.tfoid='$tfoid[$f]'"); $cntm = mysql_num_rows($disp); if ($tfoid[$f] != '') {
foreach($tab_repartition_quantitatif as $item_id => $tab_effectifs) { $somme += max(4,max($tab_effectifs)); } $sacoche_pdf->tableau_devoir_repartition_nominative_initialiser($somme); foreach($tab_item_id as $item_id=>$tab_infos_item) { // 1ère ligne : nouvelle page si besoin + référence du devoir et des codes si besoin $sacoche_pdf->tableau_devoir_repartition_nominative_entete($groupe_nom,$date_fr,$description,$tab_init_quantitatif,$tab_repartition_quantitatif[$item_id]); // ligne de répartition pour 1 item : référence item $sacoche_pdf->tableau_saisie_reference_item($tab_infos_item[0],$tab_infos_item[1]); // ligne de répartition pour 1 item : cases répartition nominative foreach($tab_repartition_nominatif[$item_id] as $code=>$tab_eleves) { // Ecrire les noms ; plus court avec MultiCell() mais pb des retours à la ligne pour les noms trop longs $memo_X = $sacoche_pdf->GetX(); $memo_Y = $sacoche_pdf->GetY(); foreach($tab_eleves as $key => $eleve_texte) { $sacoche_pdf->CellFit($sacoche_pdf->cases_largeur , $sacoche_pdf->lignes_hauteur , pdf($eleve_texte) , 0 , 2 , 'L' , false , ''); } // Ajouter la bordure $sacoche_pdf->SetXY($memo_X , $memo_Y); $sacoche_pdf->Cell($sacoche_pdf->cases_largeur , $sacoche_pdf->cases_hauteur , '' , 1 , 0 , 'C' , false , ''); } $sacoche_pdf->SetXY($sacoche_pdf->marge_gauche , $sacoche_pdf->GetY()+$sacoche_pdf->cases_hauteur); } $sacoche_pdf->Output($dossier_export.$fnom_export.'_repartition_nominative.pdf','F'); // // c'est fini... //
$pdf->setX($x + 1); $pdf->Celda(60, $lh2, utf8_decode('Desincorporación en el Mes por el Conceptos 60'), 0, 0, '', true); // Faltantes de Bienes por Investigar $pdf->setX($x + 200); $pdf->Celda(50, $lh2, $data['desin_f'], 'B', 1, 'C', true); $pdf->setY($yt + 55); $pdf->setX($x + 1); $pdf->Celda(60, $lh2, utf8_decode('Existencia Final'), 0, 0, '', true); $pdf->setX($x + 200); $pdf->Celda(50, $lh2, $data['existencia_final'], 'B', 1, 'C', true); $pdf->setY($yt + 65); $pdf->setX($x + 1); $pdf->Celda(60, $lh2, utf8_decode('TOTALES IGUALES'), 0, 0, '', true); $pdf->setX($x + 120); $pdf->Celda(50, $lh2, $data['total'], 'B', 0, 'C', true); $pdf->setX($x + 200); $pdf->Celda(50, $lh2, $data['total2'], 'B', 1, 'C', true); $pdf->setY($yt + 100); $pdf->SetDrawColor(0, 0, 0); $y = $pdf->GetY(); $pdf->SetY($y + 30); $pdf->SetX($pdf->GetX() + 8); $pdf->Cell(70, $lh, $pdf->capitalizar("{$header['responsable']}"), 0, 1, 'C', false); $pdf->SetX($pdf->GetX() + 8); $pdf->Cell(70, $lh, utf8_decode("Nombre y Apellido del {$header['cargo']}"), 'T', 0, 'C', false); $pdf->SetX($pdf->GetX() + 19); $pdf->Cell(70, $lh, 'Sello de la Unidad', 'T', 0, 'C', false); $pdf->SetX($pdf->GetX() + 19); $pdf->Cell(70, $lh, "Firma", 'T', 1, 'C', false); $pdf->Ln(5); $pdf->Output('bm4.pdf', 'D');
} else { $spek = ""; } $nopp = substr($bar->nopp, 0, 3); $sSat = "select satuan,namabarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $bar->kodebarang . "'"; $qSat = mysql_query($sSat) or die(mysql_error()); $rSat = mysql_fetch_assoc($qSat); $satuan = $rSat['satuan']; $namabarang = $rSat['namabarang']; $i++; if ($no != 1) { $pdf->SetY($akhirY); } $posisiY = $pdf->GetY(); $pdf->Cell(8, 4, $no, 0, 0, 'L', 0); $pdf->SetX($pdf->GetX()); $pdf->Cell(15, 5, $bar->kodebarang, 0, 0, 'C', 0); if ($spek == '' && $bar->catatan == '') { $pdf->MultiCell(84, 5, $namabarang, 0, 'J', 0); } else { if ($spek != '' && $bar->catatan == '') { $pdf->MultiCell(84, 5, $namabarang . "\n" . $spek, 0, 'J', 0); } else { if ($spek == '' && $bar->catatan != '') { $pdf->MultiCell(84, 5, $namabarang . "\n" . $bar->catatan, 0, 'J', 0); } else { $pdf->MultiCell(84, 5, $namabarang . "\n" . $spek . "\n" . $bar->catatan, 0, 'J', 0); } } } $akhirY = $pdf->GetY();
foreach ($albero as $linea) { // $pdf->Cell(0,6,$albero[0],0,0,'L'); // $righe = count($albero)-1; //for( $y=0; $y<=$righe; $y++){ // $linea=$albero[$y]; $pdf->Ln(1); // $str=utf8_decode($linea); $str = iconv('UTF-8', 'windows-1252', $linea); // $str=html_entity_decode($linea,"ENT_HTML5", "UTF-8"); $prev = strpos($str, '('); $indent = substr($str, 0, $prev); // [X] $str = substr($str, $prev); // [X] $y1 = $pdf->GetY(); $x1 = $pdf->GetX() + $pdf->lMargin; $y2 = $y1 + 4; $x2 = $pdf->lMargin - 2; while ($indent != "") { // $y1=$y1+$vspacing; $x1 = $pdf->GetX(); // $y2=$y1+6; $x2 = $x1 + 1; $ind = substr($indent, 0, 1); $indent = substr($indent, 1); switch ($ind) { case "I": $pdf->line($x1, $y1 + $vspacing, $x1, $y2 + $vspacing); $pdf->SetXY($x2, $y1 + 1 + $vspacing); break; case "T":
$sede = utf8_decode($row['AZ_Indirizzo']) . ' ' . utf8_decode($row['AZ_Localita']) . ' ' . $row['AZ_CAP'] . ' ' . utf8_decode($row['AZ_Comune']); } else { $sede = utf8_decode($row['STA_Sede']); } $pdf->Cell(135, 6, ' ' . $sede, 1, 1); $pdf->Cell(40, 6, 'Periodo ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' da ' . strftime('%d/%m/%Y', strtotime($row['STA_DataInizio'])) . ' a ' . strftime('%d/%m/%Y', strtotime($row['STA_DataFine'])), 1, 1); $pdf->Cell(40, 6, 'Orario ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . utf8_decode($row['STA_Orario']), 1, 1); $pdf->Cell(40, 6, 'Tutor aziendale ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . utf8_decode($row['PAZ_Titolo']) . ' ' . utf8_decode($row['PAZ_Nome']), 1, 1); $pdf->Cell(40, 6, 'Tutor scolastico ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' prof. ' . utf8_decode($row['TUT_Nome']) . ' ' . utf8_decode($row['TUT_Cognome']), 1, 1); $pdf->Ln(3); $pdf->SetFont('abac', '', 11); $x = $pdf->GetX(); $y = $pdf->GetY(); $pdf->Cell(30, 10, 'Data', 1, 0, 'C', 1); $pdf->Rect($x + 30, $y, 74, 10); $pdf->Cell(74, 5, "Firma mattino", 0, 0, 'C'); $pdf->Cell(74, 5, "Firma pomeriggio", 0, 1, 'C'); $pdf->Cell(30); $pdf->SetFont('abalc', '', 10); $pdf->Rect($x + 104, $y, 74, 10); $pdf->Cell(74, 5, "(dalle ore ............... alle ore ...............)", 0, 0, 'C'); $pdf->Cell(74, 5, "(dalle ore ............... alle ore ...............)", 0, 1, 'C'); $pdf->SetFont('abac', '', 12); $pdf->Cell(30, 7, '', 1, 0, 'R'); $pdf->Cell(74, 7, '', 1, 0, 'R'); $pdf->Cell(74, 7, '', 1, 1, 'R'); $pdf->Cell(30, 7, '', 1, 0, 'R');
$mypdf->Ln(); $mypdf->Ln(); //table heading $mypdf->SetFont('Arial', '', 10); $mypdf->setFillColor(178, 211, 230); $mypdf->SetDrawColor(178, 211, 230); $mypdf->Cell(30, 10, 'Category', 1, 0, 'C', true); $mypdf->setFillColor(178, 211, 230); $mypdf->Cell(95, 10, 'Description', 1, 0, 'C', true); $mypdf->setFillColor(178, 211, 230); $mypdf->Cell(30, 10, 'Expense Date', 1, 0, 'C', true); $mypdf->setFillColor(178, 211, 230); $mypdf->Cell(30, 10, 'Amount', 1, 0, 'C', true); $mypdf->Ln(); $mypdf->SetFont('Arial', '', 9); $x_axis = $mypdf->GetX(); $y_axis = $mypdf->GetY(); $sql = "SELECT count(ExCategory) from tbluserexpenses Where `UserName`= '{$User}' "; $res = $dbh->prepare($sql); $res->execute(); $Rcnt = $res->fetchColumn(); if ($Rcnt > 0) { $sql = "SELECT * from tbluserexpenses Where `UserName`= '{$User}' AND `Currency`='USD' AND ExCategory IN ('Flight','Railway','Taxi','Fairy','Bus') ORDER BY ExCategory,ClaimDate"; $result = $dbh->prepare($sql); $result->execute(); $RCount = $result->rowCount(); if ($RCount > 0) { $y = $mypdf->GetY(); if ($y != $y_axis) { $mypdf->setXY($x_axis, $y + 10); } else {
$dummy = ''; if ($flag90 == 1) { $dummy = number_format($sisainvoice, 2); } $pdf->Cell(25, 5, $dummy, 'T', 0, 'R'); $dummy = ''; if ($flag100 == 1) { $dummy = number_format($sisainvoice, 2); } $pdf->Cell(25, 5, $dummy, 'T', 0, 'R'); $dummy = ''; $pdf->Cell(25, 5, number_format($dibayar, 2, '.', ','), 'T', 1, 'R'); // $pdf->Cell(25,5,$outstd,'LTR',1,'R'); $pdf->__currentY = $pdf->GetY(); $pdf->MultiCell(17, 5, tanggalbiasa2($tanggal), 0, 'L'); $pdf->SetXY($pdf->GetX() + 17, $pdf->__currentY); $pdf->MultiCell(55, 5, $namasupplier, 0, 'L'); $pdf->SetXY($pdf->GetX() + 17 + 55, $pdf->__currentY); // $pdf->Cell(55,5,$noinvoice,'LBR',0,'L'); $pdf->MultiCell(25, 5, $nopokontrak, 0, 'L'); $pdf->SetXY($pdf->GetX() + 17 + 55 + 25, $pdf->__currentY); $pdf->Cell(29, 5, $jatuhtempo, 0, 0, 'R'); $pdf->Cell(26, 5, '', 0, 0, 'R'); $pdf->Cell(25, 5, '', 0, 0, 'R'); $pdf->Cell(25, 5, '', 0, 0, 'R'); $pdf->Cell(25, 5, '', 0, 0, 'R'); $pdf->Cell(25, 5, '', 0, 0, 'R'); $pdf->Cell(25, 5, $outstd . " Hari", 0, 1, 'R'); $pdf->Ln(); // $pdf->Cell(25,5,'','LBR',1,'R'); }
function home__memberlist_printview() { global $base_url, $files_dir, $config; // $content='<html><head><meta http-equiv="Content-Type" content="application/pdf; charset=utf-8" />'; // drupal_add_css(BOOTSTRAP.'/css/bootstrap.min.css'); // drupal_add_css(CHURCHDB.'/cdb_printview.css'); // $content=$content.drupal_get_header(); if (!user_access("view memberliste", "churchdb")) { addErrorMessage(t("no.permission.for", t("list.of.members"))); return " "; } require_once ASSETS . '/fpdf17/fpdf.php'; $compact = true; if (isset($_GET["compact"])) { $compact = $_GET["compact"]; } // Instanciation of inherited class $pdf = new PDF('P', 'mm', 'A4'); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Arial', '', 9); $res = home_getMemberList(); $pdf->SetLineWidth(0.4); $pdf->SetDrawColor(200, 200, 200); $fields = _home__memberlist_getSettingFields()->fields; foreach ($res as $p) { $pdf->Line(8, $pdf->GetY() - 1, 204, $pdf->GetY() - 1); $pdf->Cell(10, 10, "", 0); if ($p->imageurl == null || !file_exists("{$files_dir}/fotos/{$p->imageurl}")) { $p->imageurl = "nobody.gif"; } $pdf->Image("{$files_dir}/fotos/{$p->imageurl}", $pdf->GetX() - 10, $pdf->GetY() + 1, 9); $pdf->Cell(2); $pdf->Cell(13, 9, $p->anrede, 0, 0, 'L'); $pdf->Cell(48, 9, utf8_decode("{$p->name}, {$p->vorname}"), 0, 0, 'L'); $pdf->Cell(45, 9, utf8_decode("{$p->strasse}"), 0, 0, 'L'); // TODO: second occurence of code part - whats this for? $birthday = ""; if ($p->geburtsdatum != null) { if ($p->year < 7000) { $birthday = "{$p->day}.{$p->month}."; } if ($p->year != 1004 && $fields["memberlist_birthday_full"]->getValue()) { if ($p->year < 7000) { $birthday = $birthday . $p->year; } else { $birthday = $birthday . $p->year - 7000; } } } $pdf->Cell(20, 9, $birthday, 0, 0, 'L'); if ($fields["memberlist_telefonprivat"]->getValue() && $p->telefonprivat != "") { $pdf->Cell(30, 9, $p->telefonprivat, 0, 0, 'L'); } else { if ($fields["memberlist_telefongeschaeftlich"]->getValue() && $p->telefongeschaeftlich != "") { $pdf->Cell(30, 9, $p->telefongeschaeftlich, 0, 0, 'L'); } else { if ($fields["memberlist_telefongeschaeftlich"]->getValue() && $p->fax != "") { $pdf->Cell(30, 9, $p->fax . " (Fax)", 0, 0, 'L'); } else { $pdf->Cell(30, 9, "", 0, 0, 'L'); } } } if ($fields["memberlist_telefonhandy"]->getValue() && $p->telefonhandy != "") { $pdf->Cell(30, 9, $p->telefonhandy, 0, 0, 'L'); } // Zeilenumbruch $pdf->Ln(5); $pdf->Cell(73); $pdf->Cell(48, 10, "{$p->plz} " . utf8_decode($p->ort), 0, 0, 'L'); $pdf->Cell(17); if ($fields["memberlist_email"]->getValue() && $p->email != "") { $pdf->SetFont('Arial', '', 8); $pdf->Cell(30, 9, $p->email); $pdf->SetFont('Arial', '', 9); } $pdf->Ln(12); } $pdf->Output(t("list.of.members") . '.pdf', 'I'); }
$tt++; $pdf->SetTextColor(0); $pdf->SetFillColor(255); $pdf->Cell($br00, $zelle, " ", 0, 0, 'C'); if (isset($datum[$t - 1]) and $datum[$t] == $datum[$t - 1] and $tt > 1) { $ttext = ' '; } else { //$pdf->Cell($br01,$zelle,utf8_decode($arrWochentag[date("l",$datum[$t])]). ", " . $datum_arr[$t][2].".".$datum_arr[$t][1].".".$datum_arr[$t][0],1,0,'L',1); } $ttext = utf8_decode($arrWochentag[date("l", $datum[$t])]) . ", " . $datum_arr[$t][2] . "." . $datum_arr[$t][1] . "." . $datum_arr[$t][0]; } if ($termine[$t]->starttime != '00:00:00') { $ttext .= ' ' . substr($termine[$t]->starttime, 0, 5); } $pdf->Cell($br01, $zelle, $ttext, 1, 0, 'R', 1); //$pdf->Cell($br02,$zelle,utf8_decode($termine[$t]->name),1,0,'L',1); $yy1 = $pdf->GetY(); $xx1 = $pdf->GetX() + $br02; $pdf->Multicell($br02, $zelle, utf8_decode($termine[$t]->name), 1, 1, 'L', 1); $yy3 = $pdf->GetY(); $pdf->SetY($yy1); $pdf->SetX($xx1); $pdf->Multicell($br03, $zelle, utf8_decode($termine[$t]->typ), 1, 1, 'L', 1); $yy4 = $pdf->GetY(); if ($yy4 < $yy3) { $pdf->SetY($yy3); } } } // ENDE : Terminschleife // Ausgabe $pdf->Output(utf8_decode(JText::_('TERMINE_HEAD')) . '.pdf', 'D');
$this->SetY(-15); $this->SetFont('Arial', 'I', 8); $this->Cell(10, 10, 'Page ' . $this->PageNo() . " / {totalPages}", 0, 0, 'L'); } } //================================ $pdf = new PDF('L', 'pt', 'A4'); $pdf->AliasNbPages('{totalPages}'); $width = $pdf->w - $pdf->lMargin - $pdf->rMargin; $height = 10; $tnggi = $jmlHari * $height; $pdf->AddPage(); // $pdf->SetFillColor(255,255,255); // $pdf->SetFont('Arial','B',5); $tinggiAkr = $pdf->GetY(); $ksamping = $pdf->GetX(); $pdf->SetY($tinggiAkr + 20); $pdf->SetX($ksamping + 500); $pdf->SetFont('Arial', 'B', 6); $pdf->SetFillColor(255, 255, 255); $pdf->Cell(65, $height, " ", R, 0, 'C', 1); $pdf->SetFillColor(220, 220, 220); $pdf->Cell(135, $height, $_SESSION['lang']['anggaran'], TLR, 0, 'C', 1); $pdf->Cell(90, $height, $_SESSION['lang']['realisasi'], TLR, 1, 'C', 1); $tinggiAkr = $pdf->GetY(); $ksamping = $pdf->GetX(); $pdf->SetY($tinggiAkr); $pdf->SetX($ksamping + 500); $pdf->SetFillColor(255, 255, 255); $pdf->Cell(65, $height, " ", R, 0, 'C', 1); $pdf->SetFillColor(220, 220, 220);
$pdf->AliasNbPages(); $pdf->SetFont('Arial', '', 10); $sqa = "select \n\t\tISNULL(REF5CLI_FAC,'NO DEFINIDO') as EMPRESA,\n\t\tNOMBRE_CLI AS CLIENTE,\n\t\tCOUNT(*) AS CANT,\n\t\tSUM(ISNULL(TOTAL_FAC,0)) AS TOTAL,\n\t\tSUM(ISNULL(TOTAL_FAC,0))-SUM(ISNULL(ANTICIPO_EXP,0)) AS MSEG,\n\t\tSUM(ANTICIPO_EXP) AS MPAC\n\t\tfrom Tbfacturacion3\n\t\tinner join TbClientes\n\t\ton codigo_cli=cliente_fac\n\t\tLEFT JOIN TBEXPEDIENTES ON\n\t\tCONVERT(NVARCHAR,CODIGO_EXP) = pedido_fac\n\t\tWHERE (CONVERT(DATE,FECHA_FAC) BETWEEN CONVERT(DATE,'{$ddesde}') AND CONVERT(DATE,'{$dhasta}'))\n\t\tand status_fac=" . ($sts == 1 ? '1' : '0') . "\n\t\t" . ($emp ? " AND REF5CLI_FAC IN (SELECT nombre_emp FROM TbEmpresas WHERE CODIGO_EMP='{$emp}')" : "") . "\n\t\t" . ($cli ? " AND CODIGO_CLI='{$cli}'" : "") . "\n\t\tGROUP BY REF5CLI_FAC, nombre_cli\n\t\tORDER BY " . ($groupby ? $groupby : ' NOMBRE_CLI'); $lastGroup = ""; //putxt($sqa); $sql = mssql_query($sqa); $pp = 0; while ($row = mssql_fetch_array($sql)) { if ($pp == 0 || $pdf->GetY() > 240) { $pdf->AddPage(); $pp++; $pdf->Ln(4); $pdf->Line(10, $pdf->GetY(), 200, $pdf->GetY()); $pdf->Ln(2); if ($ddesde) { if ($pdf->GetX() > 160) { $pdf->Ln(); } $pdf->Cell(47, 4, toStr('Fecha desde: ' . date('d/m/Y', strtotime($ddesde)))); $pdf->Cell(47, 4, toStr('Fecha hasta: ' . date('d/m/Y', strtotime($dhasta)))); } if ($cli) { if ($pdf->GetX() > 120) { $pdf->Ln(); } $pdf->Cell(94, 4, toStr('Cliente: ' . $cli . ' ' . $nombre_cli)); } if ($emp) { if ($pdf->GetX() > 120) { $pdf->Ln(); }
// @$hslBagi[$thnBudget][$lstThaTnm][$ktKrgng]=$dtNoakunRup[$thnBudget][$lstThaTnm][$ktKrgng]/$ttlLuastm; // $pdf->Cell(40,10,number_format($dtNoakunRup[$thnBudget][$lstThaTnm][$ktKrgng],0),1,0,'R',1); // $pdf->Cell(40,10,number_format($hslBagi[$thnBudget][$lstThaTnm][$ktKrgng],0),1,0,'R',1); // } // } // // } // //$pdf->Cell($colTotal,$height,"",1,1,'C',1); // // $brs=0; // $awal=1; // //$totAkun+=1; // } $pdf->SetFont('Arial', '', 5); $yAkhir = $pdf->GetY(); $xPertama = $pdf->GetX(); $pdf->SetY($yAkhir); $pdf->SetX($xPertama); $pdf->Cell(58, $height, $barisNoakun, 1, 0, 'L', 1); $pdf->Cell(150, $height, $optKegiatan[$barisNoakun], 1, 0, 'L', 1); //echo $totRupiah[$thnBudget][$barisNoakun]."<br>"; if (substr($barisNoakun, 0, 1) == '1') { @($hasilBagi[$barisNoakun] = $totRupiah[$thnBudget][$barisNoakun] / $ttlLuastbm); } else { @($hasilBagi[$barisNoakun] = $totRupiah[$thnBudget][$barisNoakun] / $ttlLuastm); } $pdf->Cell(40, 10, number_format($totRupiah[$thnBudget][$barisNoakun], 0), 1, 0, 'R', 1); $pdf->Cell(40, 10, number_format($hasilBagi[$barisNoakun], 0), 1, 0, 'R', 1); $grndTotal += $totRupiah[$thnBudget][$barisNoakun]; $grndTotalHsil += $hasilBagi[$barisNoakun]; $yAkhir = $pdf->GetY();
$pdf->Cell(135, 8, ' ' . utf8_decode($row['TIR_Nome']) . ' ' . utf8_decode($row['TIR_Cognome']), 1, 1); $pdf->Cell(40, 8, 'Tutor aziendale ', 1, 0, 'R', 1); $pdf->Cell(135, 8, ' ' . utf8_decode($row['PAZ_Titolo']) . ' ' . utf8_decode($row['PAZ_Nome']), 1, 1); $pdf->Cell(40, 8, 'Azienda ospitante ', 1, 0, 'R', 1); $pdf->Cell(135, 8, ' ' . utf8_decode($row['AZ_RagioneSociale']), 1, 1); $pdf->Cell(40, 8, 'Sede del tirocinio ', 1, 0, 'R', 1); if (is_null($row['STA_Sede']) || $row['STA_Sede'] == '') { $sede = utf8_decode($row['AZ_Indirizzo']) . ' ' . utf8_decode($row['AZ_Localita']) . ' ' . $row['AZ_CAP'] . ' ' . utf8_decode($row['AZ_Comune']); } else { $sede = utf8_decode($row['STA_Sede']); } $pdf->Cell(135, 8, ' ' . $sede, 1, 1); $pdf->Cell(40, 8, 'Periodo ', 1, 0, 'R', 1); $pdf->Cell(135, 8, ' da ' . strftime('%d/%m/%Y', strtotime($row['STA_DataInizio'])) . ' a ' . strftime('%d/%m/%Y', strtotime($row['STA_DataFine'])), 1, 1); $pdf->Cell(40, 16, 'Applicazione competenze ', 1, 0, 'R', 1); $pdf->Rect($pdf->GetX(), $pdf->GetY(), 135, 16); $pdf->MultiCell(135, 5, ' ' . utf8_decode($row['STA_Compito']), 0, 1); $pdf->Ln(16); $pdf->SetFont('abac', '', 10); $x = $pdf->GetX(); $y = $pdf->GetY(); $pdf->Cell(40, 12, 'Grado di apprendimento ', 0, 0, 'R', 1); $pdf->Rect($x, $y, 40, 12); $pdf->Rect($pdf->GetX(), $pdf->GetY(), 135, 12); $pdf->SetFont('abalc', '', 9); $pdf->Cell(27, 6, 'Gravemente insuff.', 0, 0, 'C'); $pdf->Cell(27, 6, 'Insufficiente', 0, 0, 'C'); $pdf->Cell(27, 6, 'Sufficiente', 0, 0, 'C'); $pdf->Cell(27, 6, 'Buono', 0, 0, 'C'); $pdf->Cell(27, 6, 'Ottimo', 0, 1, 'C'); $pdf->Rect(70, $pdf->GetY(), 3, 3);
if ($chinese) { $job_n = mb_convert_encoding($job_n, 'UTF-8', 'HTML-ENTITIES'); $job_label = mb_convert_encoding($job_label, 'UTF-8', 'HTML-ENTITIES'); $pdf->SetFont('GB', '', 9); } else { $job_n = mb_convert_encoding($job_n, 'ISO-8859-1', 'HTML-ENTITIES'); $job_label = mb_convert_encoding($job_label, 'ISO-8859-1', 'HTML-ENTITIES'); $pdf->SetFont('Helvetica', '', 9); } $pdf->Cell(30, 6, $job_label . ":", 1, 0, 'L'); $pdf->Cell(65, 6, $job_n, 1, 1, 'L'); //$pdf->Cell(0, 6, "Subnet Description: $sub_desc", 1, 0, 'L'); # $pdf->Ln(); $pdf->SetFont('Helvetica', '', 10); //get current possition so we can put the pie chart to the side $valX = $pdf->GetX(); $valY = $pdf->GetY(); $riskarray = array(); //array of risks for pie chart $colorarray = array(); //array of colors for pie chart //$query = "SELECT DISTINCT hostIP, hostname FROM vuln_nessus_results t1 // where report_id='$report_id' $query_host $query_critical order BY hostIP"; $query = "SELECT DISTINCT t1.hostip as hostIP, HEX(t1.ctx) as ctx\n FROM vuln_nessus_results t1\n where\n t1.report_id in ({$report_id}) \n and falsepositive='N'\n order BY hostIP"; $result = $dbconn->execute($query); //initialise variable for number of hosts while loop $hosts = array(); while ($row = $result->fields) { $host_id = key(Asset_host::get_id_by_ips($dbconn, $row['hostIP'], $row['ctx'])); if (valid_hex32($host_id)) { $hostname = Asset_host::get_name_by_id($dbconn, $host_id);
$pdf->SetFont('Arial', 'U', 6); $pdf->Cell(0, 40, '', 0, 1); $pdf->Cell(0, 5, utf8_decode('Biothys GmbH | Gewerbestr. 6 | D-77731 Willstätt'), 0, 1, 'L', false); $pdf->SetFont('Arial', '', 10); $pdf->Cell(0, 5, utf8_decode($company->getName()), 0, 1, 'L', false); $pdf->Cell(0, 5, utf8_decode($receiving_address->getLine() . ' ' . $receiving_address->getComplement()), 0, 1, 'L', false); $pdf->Cell(0, 5, utf8_decode($receiving_address->getZip() . ' ' . $receiving_address->getCity() . ' ' . $receiving_address->getCountry()), 0, 1, 'L', false); //Marge left $pdf->SetFont('Arial', 'B', 20); $pdf->Cell(180, 15, utf8_decode('Invoice for samples'), 0, 1, 'R', false); //Marge top $pdf->Cell(0, 10, '', 0, 1); //CellBorder//remplacer le ust-id quand il sera setup $pdf->SetFont('Arial', 'B', 11); $pdf->Cell(185, 21, '', 1); $pdf->setX($pdf->GetX() - 185); $pdf->setY($pdf->GetY() + 2); $pdf->FirstTable(array(array(utf8_decode('n° :'), $id_document, date('d.m.y', $order->getDate_entry())), array('UST-ID :', $company->getUst_id(), $order->getEmployee()->getSurname() . ' ' . $order->getEmployee()->getName()), array('Your ID :', $company->getId(), '1/1'))); $pdf->SetFont('Arial', '', 8); $pdf->setY($pdf->GetY() + 2); $pdf->MultiCell(100, 3, utf8_decode($text_intro)); $pdf->setY($pdf->GetY() + 2); $pdf->SecondTable($order); $pdf->setY($pdf->GetY() + 5); $pdf->SetFont('Arial', '', 8); $pdf->SetTextColor(0); // Delivery Address $pdf->SetFont('Arial', 'B', 12); $pdf->Cell(180, 6, utf8_decode('Delivery Address : '), 0, 1, 'L', false); $pdf->SetFont('Arial', '', 8); $delivery_address = new address($order->getId_delivery_address());
$str3 = "select jumlah,idkomponen,a.karyawanid,c.plus from " . $dbname . ".sdm_gaji_vw a \r\n left join " . $dbname . ".sdm_ho_component c on a.idkomponen=c.id\r\n where a.sistemgaji='Bulanan' and a.periodegaji='" . $perod . "' "; //exit("Error:".$str3); $res3 = mysql_query($str3, $conn); while ($bar3 = mysql_fetch_assoc($res3)) { if ($bar3['plus'] == '1') { if ($bar3['jumlah'] != '') { $arrValPlus[$bar3['karyawanid']][$bar3['idkomponen']] = $bar3['jumlah']; } } elseif ($bar3['plus'] == '0') { if ($bar3['jumlah'] != '') { $arrValMinus[$bar3['karyawanid']][$bar3['idkomponen']] = $bar3['jumlah']; } } } foreach ($arrKary as $dtKary) { $pdf->Image('images/logo.jpg', $pdf->GetX(), $pdf->GetY(), 10); $pdf->SetX($pdf->getX() + 10); $pdf->SetFont('Arial', 'B', 8); $pdf->Cell(75, 12, $_SESSION['org']['namaorganisasi'], 0, 1, 'L'); $pdf->SetFont('Arial', '', 6); $pdf->Cell(71, 4, $_SESSION['lang']['slipGaji'] . ': ' . $arrBln[$idBln] . "-" . $bln[0], 'T', 0, 'L'); $pdf->SetFont('Arial', '', 6); $pdf->Cell(25, 4, 'Printed on: ' . date('d-m-Y: H:i:s'), "T", 1, 'R'); $pdf->SetFont('Arial', '', 6); $pdf->Cell(25, 4, $_SESSION['lang']['nik'] . "/" . $_SESSION['lang']['tmk'], 0, 0, 'L'); $pdf->Cell(35, 4, ": " . $arrNik[$dtKary] . "/" . tanggalnormal($arrTglMsk[$dtKary]), 0, 0, 'L'); $pdf->Cell(18, 4, $_SESSION['lang']['unit'] . "/" . $_SESSION['lang']['bagian'], 0, 0, 'R'); $pdf->Cell(28, 4, ': ' . $idAfd . " / " . $arrBag[$dtKary], 0, 1, 'L'); $pdf->Cell(25, 4, $_SESSION['lang']['namakaryawan'] . ":", 0, 0, 'L'); $pdf->Cell(35, 4, ': ' . $arrNmKary[$dtKary], 0, 0, 'L'); $pdf->Cell(18, 3, $_SESSION['lang']['jabatan'], 0, 0, 'R');
$pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Arial', 'B', 12); if (isset($_GET['emp_id'])) { $emp_id = $_GET['emp_id']; } include "actions/class_functions.php"; include "actions/subject_functions.php"; if (!isset($_GET['sy_id'])) { $school_yr = get_active_sy(); } else { $school_yr = $_GET['sy_id']; } $image1 = "../images/pnhs_logo.png"; //$pdf->Cell( 30, 30, $pdf->Image($image1, $pdf->GetX(), $pdf->GetY(), 25), 1, 0, 'L', false ); $pdf->Image($image1, $pdf->GetX(), $pdf->GetY(), 25); $pdf->Cell(0, 10, "PAG'ASA NATIONAL HIGH SCHOOL", 0, 1, 'C'); $pdf->Cell(0, 10, "Summary of Load ", 0, 1, 'C'); $pdf->Cell(0, 10, "", '', 1, 'C'); $query_emp = mysql_query("SELECT * FROM employee_t WHERE emp_id='{$emp_id}'"); $row_emp = mysql_fetch_assoc($query_emp); $query_load = mysql_query("SELECT * FROM teacher_t WHERE emp_id='{$emp_id}'"); $row_load = mysql_fetch_assoc($query_load); $query_sy = mysql_query("SELECT * FROM school_year_t WHERE sy_id='{$school_yr}'"); $row_sy = mysql_fetch_assoc($query_sy); $pdf->Cell(70, 10, "", '', 1); $pdf->SetFillColor(150); $pdf->Cell(190, 10, "SECTION DETAILS", 1, 1, '', true); $pdf->SetFont('Arial', '', 9); $pdf->Cell(95, 10, "NAME: " . $row_emp['l_name'] . ", " . $row_emp['f_name'], 1, '', ''); $pdf->Cell(95, 10, "SCHOOL YEAR: " . $row_sy['sy_start'] . " - " . $row_sy['sy_end'], 1, 1, '');
$qSat = mysql_query($sSat) or die(mysql_error()); $rSat = mysql_fetch_assoc($qSat); $satuan = $rSat['satuan']; $namabarang = $rSat['namabarang']; $i++; if ($no != 1) { $pdf->SetY($akhirY); } $akhirY = $pdf->GetY(); if ($akhirY >= 260) { $pdf->AddPage(); $akhirY = $pdf->GetY(); } //no $pdf->Cell(8, 4, $no, 0, 0, 'L', 0); $pdf->SetX($pdf->GetX()); $posisiY = round($pdf->GetY()); $pdf->Cell(12, 5, substr($bar->kodebarang, 0, 3), 0, 0, 'C', 0); //nama barang $pdf->MultiCell(60, 5, " " . $namabarang . "\n" . $spek . $bar->catatan, 0, 'J', 0); $akhirY = $pdf->GetY(); //naik lagi kursornya $pdf->SetY($posisiY); $pdf->SetX($pdf->GetX() + 82); //no pp + pt + jumlah + satuan + harga + total $pdf->Cell(12, 5, $nopp, 0, 0, 'C', 0); $pdf->Cell(12, 5, $unit, 0, 0, 'C', 0); $pdf->Cell(14, 5, number_format($jumlah, 2, '.', ','), 0, 0, 'R', 0); $pdf->Cell(14, 5, $bar->satuan, 0, 0, 'C', 0); if ($bar->matauang == 'IDR') { $pdf->Cell(29, 5, $bar->matauang . " " . number_format($harga_sat, 2, '.', ','), 0, 0, 'R', 0);
$pdf->Cell(140, 5, "METODO DE PAGO: EFECTIVO"); $pdf->Cell(50, 5, "IMPORTE:" . $datos[7]); $pdf->Ln(); $pdf->Cell(10); $le = new EnLetras(); $v = str_replace(",", "", $datos[7]); $pdf->Cell(148, 5, "Cantidad en Letra: " . $le->ValorEnLetras($totl, "pesos")); $pdf->Cell(50, 5, "I.V.A. \$" . $iva); $pdf->Ln(); $pdf->Cell(154); $pdf->Cell(50, 5, "TOTAL: \$" . number_format($totl, 2)); $pdf->ln(); $pdf->ln(); $pdf->ln(); $img = "julia.png"; $pdf->Cell(30, 40, $pdf->Image($img, $pdf->GetX(), $pdf->GetY(), 25, 25)); $pdf->SetXY($pdf->GetX(), $pdf->GetY()); $pdf->SetFont('Arial', 'B', 5); $pdf->MultiCell(70, 3, utf8_decode("Vigencia: 2 Años a partir de la fecha de aprobación de la asignación de folios, la cual es del 19 de Marzo de 2013. Vence el 19 de Marzo de 2015. No. de Aprobación: 24848803 Cantidad 500 del 1 al 500.")); $pdf->Ln(); $pdf->Cell(30); $pdf->SetFont('Arial', 'B', 6); $pdf->Cell(40, 5, "Efectos Fiscales al pago."); $pdf->Ln(); $pdf->Cell(30); $pdf->Cell(40, 5, utf8_decode("Pago en una sola exhibición")); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->SetFont('Arial', 'B', 8); $pdf->Cell(40);