function signin($js){
global $ar,$db;
$dt=array();
//$dt['js']=$js;
$email2 =$js['email'];
$em=explode('@',$email2);
$m1 = preg_replace("/[^A-Za-z0-9]/","",$em[0]);
if($m1!='' && $em[1]!='') {
$email=$m1."@".$em[1];
//cek email dobel
$sql9="SELECT id,nama from `petugas` where email='".$email."'";
//$dt['sql'][0]=$sql9;
$res9=mysqli_query($db,$sql9);
if(mysqli_num_rows($res9)==0) {
$dt['error']=true;
$dt['message']="Email '".$email."' tidak terdaftar";
//$dt['info'][0]="Email '".$email."' belum terdaftar";
} else {
//$dt['message']="Email '".$email."' belum terdaftar";
//cek username
if(mysqli_num_rows($res9)==1) {
//$dt['info'][1]="Email '".$email."' terdaftar";
$sql8="SELECT id,petugas,daftar,daker,sektor,tusi,email,img,tahun,tahun_haji from `petugas` where `email`='".$email."' and `password`='".md5($js['password'])."' and `st`=1";
//$dt['sql'][1]=$sql8;
$res8=mysqli_query($db,$sql8);
if(mysqli_num_rows($res8)==0) {
$dt['message']="Email '".$email."' benar, password salah";
//$dt['info'][2]="Email '".$email."' terdaftar, password salah";
$dt['error']=true;
} else {
$r8=mysqli_fetch_assoc($res8);
$dt['success']=true;
$dt['member']['data']=$r8;
$dt['member']['data']['image']=$ar['img_url']."".$r8['img'];
$sql9="SELECT * from `files` where modul='petugas' and item_id=".$r8['id']." order by id desc";
$res9=mysqli_query($db,$sql9);
if(mysqli_num_rows($res9)>0) {
$c=0;
while($r9=mysqli_fetch_assoc($res9)) {
//$dt['img']['data'][$c]['id']=$r9['id'];
$dt['img']['data'][$c]['url']['small']=$ar['img_url']."".$r9['modul']."/".$r9['path']."/".$r9['seq']."/image/small/".$r9['url'];
$dt['img']['data'][$c]['url']['medium']=$ar['img_url']."".$r9['modul']."/".$r9['path']."/".$r9['seq']."/image/medium/".$r9['url'];
$dt['img']['data'][$c]['url']['big']=$ar['img_url']."".$r9['modul']."/".$r9['path']."/".$r9['seq']."/image/big/".$r9['url'];
$c++;
}
} else {
$dt['img']['data'][0]['url']['small']=$ar['img_url']."member/user.png";
$dt['img']['data'][0]['url']['medium']=$ar['img_url']."member/user.png";
$dt['img']['data'][0]['url']['big']=$ar['img_url']."member/user.png";
}
$dt['img']['count']=$c;
$jj['uuid']=$r8['id'];
}
}
}
}
return $dt;
}