function kloter_bysektor($js){
global $ar,$db;
$dt=array();
$sql2="SELECT `code` from `myhotel` where sektor='".$js."' group by code";
$res2=mysqli_query($db,$sql2);
$jr2=mysqli_num_rows($res2);
$dt['sql']=$sql2;
//$sql=$sql2." group by code";
//echo $sql.";<br>";
//$res=mysqli_query($db,$sql);
if($jr2>0) {
$dt['count']=$jr2;
$dt['success']=true;
$c=0;
while($r2=mysqli_fetch_assoc($res2)) {
$sql3="SELECT emb,klt,gel,code,total from mykloter where code='".$r2['code']."'";
$res3=mysqli_query($db,$sql3);
$r3=mysqli_fetch_assoc($res3);
$dt['data'][$c]=$r3;
$c++;
}
} else {
$dt['count']=0;
$dt['error']=true;
$dt['message']="data action not found";
}
return $dt;
}