<td align=\'left\'>' . $value_urusan->kd_urusan . '</td> <td align=\'left\' colspan=26>' . $value_urusan->nm_urusan . '</td> </tr>'; $query_bidang = DB::query("SELECT\n a.tahun,\n bidang.kd_bidang,\n bidang.nm_bidang\n FROM\n tabel_dpa AS a\n INNER JOIN bidang ON bidang.kd_urusan = a.kd_urusan AND bidang.kd_bidang = a.kd_bidang\n WHERE\n CONCAT(a.kd_unit,kd_sub_unit) = {$req->skpd} AND\n a.tahun = {$req->tahun} AND \n a.kd_urusan = {$value_urusan->kd_urusan} AND\n a.kd_program > 14\n GROUP BY a.kd_urusan,a.kd_bidang"); $result_bidang = $query_bidang->fetchAll(); foreach ($result_bidang as $value_bidang) { $htmlTemplate .= '<tr> <td align=\'center\'></td> <td align=\'left\'>' . $value_urusan->kd_urusan . '.' . $value_bidang->kd_bidang . '</td> <td align=\'left\' colspan=26>' . $value_bidang->nm_bidang . '</td> </tr>'; } } /** * */ require_once 'library/lib/fpdf.inc.php'; require_once 'library/lib/pdftable.inc.php'; require_once 'library/lib/pdf.inc.php'; require_once 'library/lib/color.inc.php'; require_once 'library/lib/htmlparser.inc.php'; $p = new PDF(); $p->SetMargins(20, 10, 10); $p->AddPage(); $p->setStyle('small'); $p->text(0, 'Formulir Evaluasi Hasil Renja SKPD', 0, 'C'); $p->text(0, 'SKPD ' . Suggest::getSatker($req->skpd), 0, 'C'); $p->text(0, 'Periode Kegiatan Tahun ' . $req->tahun, 0, 'C'); $p->SetFont('helvetica', '', '5'); $p->htmltable($htmlTemplate); $p->output(NAMA_LAPORAN, 'F');
<?php require '../../boot.php'; require '../../session.php'; if (!isset($session) || $session->auth == "") { Common::Error(401, 'json'); } $req = Request::all($_REQUEST); if (empty($req)) { $users = DB::get("users"); for ($i = 0; $i < count($users); $i++) { $users[$i]->password = '******'; $users[$i]->satker = Suggest::getSatker($users[$i]->kd_subunit); } echo json_encode($users); exit; } $users = DB::findAll("users", $req); for ($i = 0; $i < count($users); $i++) { $users[$i]->password = '******'; $users[$i]->satker = Suggest::getSatker($users[$i]->kd_subunit); } echo json_encode($users); exit;