$hitung = "SELECT count(a.id_kegiatan) FROM simpel_keg a LEFT JOIN pegawai.daf_unit b on a.unit_id=b.unit_id WHERE status=4 and b.unit_parent_id='" . $sat->unit_id . "' ";
$count = Yii::$app->db->createCommand($hitung)->queryScalar();
echo $count;
break;
default:
$hitung = "SELECT count(a.id_kegiatan) FROM simpel_keg a LEFT JOIN pegawai.daf_unit b on a.unit_id=b.unit_id WHERE status=4 and b.unit_parent_id='" . $sat->unit_id . "' ";
$count = Yii::$app->db->createCommand($hitung)->queryScalar();
echo $count;
break;
}
?>
</td>
<td align="center" width="260">Rp. <?php
$pag = number_format(HelperUnit::Pagu($sat->unit_id), 0, ",", ".");
echo $pag;
?>
</td>
</tr>
<?php
$n++;
}
?>
<?php
$no++;
}
?>
<tr>
<td style="background-color: white;" scope="row"></td>
</tr>
