while ($data = mysql_fetch_array($res))
{
$dataArray[] = $data['Aset_ID'];
}
}
$paging = paging($_GET['pid'], 100);
if($dataArray!= "") $dataImplode = implode(',',$dataArray); else $dataImplode = "";
// pr($dataImplode);
if($dataImplode!=""){
$viewTable = 'penilaian_'.$SessionUser['ses_uoperatorid'];
$table = $DBVAR->is_table_exists($viewTable, 1);
if (!$table){
$sql="CREATE OR REPLACE VIEW $viewTable AS SELECT a.Aset_ID, a.NamaAset, a.Kelompok_ID, a.LastSatker_ID, a.NomorReg,
a.Lokasi_ID, a.LastKondisi_ID, c.Kelompok, c.Kode,
d.NamaLokasi, e.KodeSatker, e.NamaSatker, f.InfoKondisi, KTR.NoKontrak
FROM Aset AS a
LEFT JOIN KontrakAset AS KTRA ON a.Aset_ID=KTRA.Aset_ID
LEFT JOIN Kontrak AS KTR ON KTR.Kontrak_ID=KTRA.Kontrak_ID
LEFT JOIN Kelompok AS c ON a.Kelompok_ID = c.Kelompok_ID
LEFT JOIN Lokasi AS d ON a.Lokasi_ID = d.Lokasi_ID
LEFT JOIN Satker AS e ON a.LastSatker_ID = e.Satker_ID
LEFT JOIN Kondisi AS f ON a.LastKondisi_ID = f.Kondisi_ID
WHERE a.Aset_ID IN ({$dataImplode})
ORDER BY a.Aset_ID asc";
$exec=mysql_query($sql) or die(mysql_error());
include "../../config/config.php";
include"$path/header.php";
include"$path/title.php";
$USERAUTH = new UserAuth();
$DBVAR = new DB();
$SESSION = new Session();
$menu_id = 42;
$SessionUser = $SESSION->get_session_user();
($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login'));
$USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
$resetDataView = $DBVAR->is_table_exists('pemindahtanganan_'.$SessionUser['ses_uoperatorid'], 0);
?>
<html>
<body>
<div id="content">
<?php
include"$path/menu.php";
?>
</div>
</div>
<div id="tengah1">
<div id="frame_tengah1">
