function tool_hotel_ptg_lp() {
  global $ar,$db; 
  $sql1="SELECT daker,gel,emb,klt,no_rumah,lp,count(*) as jum from penempatan where porsi like '747%' and lp!='' group by daker,gel,emb,klt,emb,klt,no_rumah,lp";
  $res1=mysqli_query($db,$sql1);
  while($r1=mysqli_fetch_assoc($res1)) {
    $udt1=array(
      'ptg_'.$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);
  }
}