function penkin7_list($q,$col,$q1,$col1,$q2,$col2,$q3,$col3,$lcol,$lq,$pl) {
global $db,$ar;
//print_r($ar);
?>
<div class="row">
<?php
$sql = "select * from penkin7 where id>0 ";
if($col!='') {
$sql .= " and `".$col."`='".$q."' ";
}
if($col1!='') {
$sql .= " and `".$col1."`='".$q1."' ";
}
if($col2!='') {
$sql .= " and `".$col2."`='".$q2."' ";
}
if($col3!='') {
$sql .= " and `".$col3."`='".$q3."' ";
}
if($lcol!='') {
$sql .= " and `".$lcol."` like '".$lq."%' ";
}
$sql1=$sql;
$res1=mysqli_query($db, $sql1);
$sql .= " order by selesai_at desc limit ".$pl;
$res = mysqli_query($db, $sql);
//echo $sql;
while($v = mysqli_fetch_assoc($res)) {
if($v['pekerjaan_id']>0) {
$sql3="SELECT uraian from ref_pekerjaan where id=".$v['pekerjaan_id'];
$res3=mysqli_query($db,$sql3);
$r3=mysqli_fetch_assoc($res3);
if($r3['uraian']!='') {
$uraian=$r3['uraian'];
} else {
$uraian="";
}
} else {
$uraian=$v['uraian'];
}
?>
<div class="col-3 pb-13" id="<?=$v['id'];?>">
<a href="https://api-petugas.haji.go.id/ptgsapi/petugashaji/penkin/get_image/<?=$v['url'];?>" target="_blank"><img src="https://api-petugas.haji.go.id/ptgsapi/petugashaji/penkin/get_image/<?=$v['url'];?>" class="image-fluid" width="250" style="height:auto;"></a>
<br><span class="small">
<?=date("Y-m-d H:i",$v['mulai_at']);?>-<?=date("H:i",$v['selesai_at']);?>
</span><br>
<span class="small"><?=$v['make'];?>, <?=$v['model'];?>, <?=$v['software'];?>, <?=$v['iso'];?></span><br>
<?=$uraian;?><br>
<?=$v['deskripsi'];?><br> <?=$v['nama'];?> |
<a href="?op=penkin7&op2=list&col=nilai&q=<?=$v['nilai'];?>"><?=$v['nilai'];?></a> |
<a href="?op=penkin7&op2=list&col=daftar&q=<?=$v['daftar'];?>"><?=$v['daftar'];?></a> |
<a href="?op=penkin7&op2=list&col1=tusi&q1=<?=$v['tusi'];?>"><?=$v['tusi'];?></a> |
<a href="?op=penkin7&op2=list&col2=sektor&q2=<?=$v['sektor'];?>"><?=$v['sektor'];?></a> |
<a href="?op=penkin7&op2=list&col2=pekerjaan_id&q2=<?=$v['pekerjaan_id'];?>&col=daftar&q=<?=$v['daftar'];?>"><?=$v['pekerjaan_id'];?></a> |
<a href="#<?=$v['id'];?>" onClick="uCol(<?=$v['id'];?>,'sel',0,'penkin7');" class="btn btn-xs btn-color-green">usel</a> | <a href="?op=penkin7&op2=edit&id=<?=$v['id'];?>" class="btn btn-xs btn-warning">edit</a>
</div>
<?php
}
?>
</div><?=ang2(mysqli_num_rows($res1));?>
<br><?=$sql;?><br>
<?php
}