<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;
