function tool_hotel_lan_lp() {
  global $ar,$db; 
  $sql1="select daker,gel,emb,klt,no_rumah,lp,count(*) as jum from penempatan where lan=1 and lp!='' group by daker,gel,emb,klt,no_rumah,lp";
  $res1=mysqli_query($db,$sql1);
  while($r1=mysqli_fetch_assoc($res1)) {
    $udt1=array(
      'lan_'.$r1['lp']=>$r1['jum'],
    );
    Update($db,"myhotel",$udt1,"`code`='".$r1['emb']."".$r1['klt']."' and hotel_no='".$r1['no_rumah']."' and daker='".$r1['daker']."' and gel='".$r1['gel']."'",0);
  }
}