}
return $kode;
}
function show_kode_satker($satker_id){
$query="select KodeSatker from Satker where Satker_ID='$satker_id'";
$result_query= mysql_query($query) or die(mysql_error());
while($row= mysql_fetch_object($result_query))
{
$kode=$row->KodeSatker;
}
return $kode;
}
$id=$_GET['aset'];
$query_dokumen=" SELECT T.Tanah_ID as Tanah_ID, A.NamaAset as NamaAset, A.Pemilik as Pemilik, A.LastSatker_ID as LastSatker,
A.Kelompok_ID as Kelompok_ID FROM Tanah as T, Aset as A where T.Aset_ID=A.Aset_ID and T.Tanah_ID='$id
ORDER BY A.LastSatker_ID ASC '";
$result_dokumen=mysql_query($query_dokumen) or die(mysql_error());
while ($row_dokumen=mysql_fetch_object($result_dokumen)){
$kode= show_kode_kelompok($row_dokumen->Kelompok_ID);
$hasil= "$kode";
$hasil2=trim($hasil);
}
echo $hasil2;
?>
function radioasetanah($style_div, $save_element, $tbody_name, $prefix)
{
$temp = explode("|", $prefix);
$prefix = $temp[0];
$update = $temp[1];
echo "<div {$style_div}>";
echo "<table width=\"100%\" align=\"left\" border=\"0\" class=\"tabel\">";
echo " <tr>\n <th align=\"left\" border=\"0\" nowrap colspan=\"3\">\n <input type=\"hidden\" name=\"{$save_element}\" id=\"{$save_element}\" value=\"{$update}\"> \n <input type=\"text\" style=\"width: 70%;\" value=\"\" id=\"search_kelompok{$prefix}\">\n <input type=\"button\" id=\"preload_kelompok\" value=\"Cari\" onClick=\"recp{$prefix}()\">\n </th>\n </tr>\n <tr>\n\n <th width=\"50px\"> </th>\n <th width=\"200px\"align=\"center\"><b>Kode</b></th>\n <th width=\"400px\" align=\"left\"><b>Nama</b></th>\n </tr>\n <tr>\n <td colspan=\"3\"></td>\n </tr>\n <tbody id='{$tbody_name}'>";
if ($update != "") {
$sql = "SELECT T.Tanah_ID as Tanah_ID, A.NamaAset as NamaAset, A.Pemilik as Pemilik, A.LastSatker_ID as LastSatker,\n A.Kelompok_ID as Kelompok_ID FROM Tanah as T, Aset as A where T.Aset_ID=A.Aset_ID \n ORDER BY A.LastSatker_ID ASC";
$result = mysql_query($sql);
$cek_satker = "";
$no = 1;
while ($row = mysql_fetch_object($result)) {
$kode = show_kode_kelompok($row->Kelompok_ID);
$uraian = $row->NamaAset;
$Pemilik = $row->Pemilik;
$satker = show_kode_satker($row->LastSatker);
$tanah_id = $row->Tanah_ID;
if ($cek_satker != "" && $cek_satker != $satker) {
$no = 1;
}
$result_kode = $Pemilik . ".{$satker}" . ".{$kode}-{$no}";
$kode_for_js = "{$prefix}-kelompok_tanah_1|{$kode}|1";
$cek_satker = $satker;
$no++;
if ($update == $tanah_id) {
echo "<tr id='{$kode_for_js}'>";
echo "<td> <input type=\"radio\" name=\"{$tbody_name}" . "[]\" id=\"{$prefix}" . "_{$kode}\" value=\"{$tanah_id}\" onclick=\"SelectAllChild_{$tbody_name}(this);\" checked></td>";
echo "<input type=\"hidden\" id=\"id_parent_{$prefix}" . "_{$kode}\" value=\"\">";
echo "<input type=\"hidden\" id=\"id_nilai_{$prefix}" . "_{$kode}\" value=\"{$uraian}\">";
echo "<td>{$result_kode}</td>";
echo "<td>{$uraian}</td>";
echo "</tr>";
} else {
echo "<tr id='{$kode_for_js}'>";
echo "<td> <input type=\"radio\" name=\"{$tbody_name}" . "[]\" id=\"{$prefix}" . "_{$kode}\" value=\"{$tanah_id}\" onclick=\"SelectAllChild_{$tbody_name}(this);\"></td>";
echo "<input type=\"hidden\" id=\"id_parent_{$prefix}" . "_{$kode}\" value=\"\">";
echo "<input type=\"hidden\" id=\"id_nilai_{$prefix}" . "_{$kode}\" value=\"{$uraian}\">";
echo "<td>{$result_kode}</td>";
echo "<td>{$uraian}</td>";
echo "</tr>";
}
}
} else {
$sql = "SELECT T.Tanah_ID as Tanah_ID, A.NamaAset as NamaAset, A.Pemilik as Pemilik, A.LastSatker_ID as LastSatker,\n A.Kelompok_ID as Kelompok_ID FROM Tanah as T, Aset as A where T.Aset_ID=A.Aset_ID \n ORDER BY A.LastSatker_ID ASC";
$result = mysql_query($sql);
$cek_satker = "";
$no = 1;
while ($row = mysql_fetch_object($result)) {
$kode = show_kode_kelompok($row->Kelompok_ID);
$uraian = $row->NamaAset;
$Pemilik = $row->Pemilik;
$satker = show_kode_satker($row->LastSatker);
$tanah_id = $row->Tanah_ID;
if ($cek_satker != "" && $cek_satker != $satker) {
$no = 1;
}
$result_kode = $Pemilik . ".{$satker}" . ".{$kode}-{$no}";
$kode_for_js = "{$prefix}-kelompok_tanah_1|{$kode}|1";
$cek_satker = $satker;
$no++;
echo "<tr id='{$kode_for_js}'>";
echo "<td> <input type=\"radio\" name=\"{$tbody_name}" . "[]\" id=\"{$prefix}" . "_{$kode}\" value=\"{$tanah_id}\" onclick=\"SelectAllChild_{$tbody_name}(this);\"></td>";
echo "<input type=\"hidden\" id=\"id_parent_{$prefix}" . "_{$kode}\" value=\"\">";
echo "<input type=\"hidden\" id=\"id_nilai_{$prefix}" . "_{$kode}\" value=\"{$uraian}\">";
echo "<td>{$result_kode}</td>";
echo "<td>{$uraian}</td>";
echo "</tr>";
}
}
echo "\t</tbody></table>";
echo "</div>";
}
