/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = SimpelPersonil::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id_personil' => $this->id_personil]);
return $dataProvider;
}
public function actionMonikeg()
{
// get your HTML raw content without any layouts or scripts
if (!empty($_GET['unit_id'])) {
$find_query = "SELECT c.* FROM simpel_keg as a\n LEFT JOIN pegawai.daf_unit b ON a.unit_id = b.unit_id\n LEFT JOIN simpel_personil c ON a.id_kegiatan = c.id_kegiatan\n WHERE (unit_parent_id='" . $_GET['unit_id'] . "') and tgl_berangkat='" . $_GET['tgl_mulai'] . "' or tgl_kembali='" . $_GET['tgl_kembali'] . "' and c.status=4 group by pegawai_id";
$query = SimpelPersonil::findBySql($find_query);
$countQuery = count($query->all());
$pages = new Pagination(['totalCount' => $countQuery]);
$models = $query->offset($pages->offset, $pages->pageSize = 10)->limit($pages->limit)->all();
} else {
$unit = SimpelPersonil::find()->joinWith('keg')->where('simpel_keg.status = 4')->groupBy('pegawai_id');
$count = count($unit->all());
$pages = new Pagination(['totalCount' => $count]);
$models = $unit->offset($pages->offset, $pages->pageSize = 10)->limit($pages->limit)->all();
}
return $this->render('monikeg', ['pages' => $pages, 'models' => $models]);
}
public function actionUrll($id)
{
$model = $this->findModel($id);
$model2 = \backend\models\SimpelPersonil::find()->where('id_kegiatan=' . $id)->all();
return $this->renderAjax('v_qrcode_luar', ['model' => $model, 'model2' => $model2]);
}
$da = $i . '0';
} elseif ($i == 30) {
$da = $i . '0';
} else {
$da = $i;
}
// echo $da;
// die();
$count = Yii::$app->db->createCommand("SELECT count(pegawai_id) from simpel_personil where pegawai_id=" . $key['pegawai_id'] . " and tgl_berangkat='" . $tahun . '-' . $bln . '-' . $da . "'")->queryScalar();
if ($count > 0) {
?>
<span class="label label-success" data-toggle="popover" data-html="true" title="Detail Tujuan Keberangkatan"
data-content="
<?php
$tgl = isset($_GET['tgl_mulai']) ? $_GET['tgl_mulai'] : $key->tgl_berangkat;
$data = \backend\models\SimpelPersonil::find()->where("pegawai_id=" . $key['pegawai_id'] . " and tgl_berangkat like '%" . $tgl . "%'")->groupBy('id_kegiatan')->all();
foreach ($data as $value) {
echo '<b>' . $value->keg->kotaTujuan->nama . '</b> ';
echo "<br/>";
echo $value->keg->nama_keg;
echo "<br/>";
echo "<br/>";
}
?>
"><?php
echo count($data) . 'x';
?>
</span>
<?php
} else {
echo "";
public function CountUper($id)
{
/* $command = Yii::$app->db->createCommand("SELECT
sum(transport+taksi+taksi2+lumpsum+uhr+uhr_fb+penginapan+representatif+trans_pim+inap_lain+inap_fb )
FROM perjadin where nomi_id=16"); */
$command = Yii::$app->db->createCommand("SELECT sum(jml) FROM simpel_rincian_biaya where personil_id=" . $id . " and bukti_kwitansi in(1,2) GROUP BY id_kegiatan");
$sum = $command->queryScalar();
$counts = \backend\models\SimpelPersonil::find()->where(['id_personil' => $id])->count();
if (!empty($counts)) {
return $sum;
} else {
return "-";
}
}
/**
* Finds the SimpelPersonil model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return SimpelPersonil the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = SimpelPersonil::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
<div class="box-body" style="display: block;">
<table style="width:100%;" class="table table-striped">
<thead>
<tr style="background-color:#4e95f4;">
<th width="2%" class="th">No.</th>
<th width="33%">Data Personil</th>
<th width="33%">Data Penugasan</th>
<th width="27%">Pembiayaan Luar Negri </th>
<th width="5%">Action</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$data = \backend\models\SimpelPersonil::find()->where('id_kegiatan=' . $model->id_kegiatan)->all();
foreach ($data as $key) {
?>
<tr class="item-row">
<td valign="top"><span id="No"><?php
echo $no;
?>
</span></td>
<td style="width:5%;">
<table style="width:80%;">
<tbody>
<tr>
<td width="20%">Nama</td>
<td valign="top">:</td>
<td><?php
public function Jml($id)
{
$personil = \backend\models\SimpelPersonil::find();
$rincian = \backend\models\SimpelRincianBiaya::find();
$daftar = \backend\models\SimpelDafKatBiaya::find();
return $id;
}
public function getPersonil()
{
return $this->hasOne(\backend\models\SimpelPersonil::className(), ['id_personil' => 'personil_id']);
}
