function olah_csv_timbang($p) {
global $db,$ar;
//urut,code,med_hotel_no,pax,jam_timbang,tim_timbang
//6,JKG21,506,319,2026-06-16 12,1
$data=explode(',',strtoupper(trim($p)));
$dt['no']=$data[0];
$dt['code']=$data[1];
$dt['med_hotel_no']=$data[2];
$dt['pax']=$data[3];
//$dt['jam_timbang']=$data[4];
if(strlen(trim($data[4]))<9) {
$dt['jam_timbang']='2026-'.$data[4].':00:00';
} else {
$dt['jam_timbang']=$data[4].':00:00';
}
$dt['tim']=$data[5];
echo "<br>"; count($data); echo "<br>";
echo "<pre>"; print_r($dt); echo "</pre>";
if(count($data)!=6) {
echo "jumlah data sebaris tidak benar<br>";
} else {
//t1 cek code
$sql0="SELECT * from myhotel where code='".$dt['code']."' and hotel_no='".$dt['med_hotel_no']."'";
$res0=mysqli_query($db,$sql0);
if(mysqli_num_rows($res0)==1) {
$udt=array(
'timbang_no'=>$dt['no'],
'timbang_date'=>substr($dt['jam_timbang'],0,10),
'timbang_time'=>strtotime($dt['jam_timbang']),
'timbang_pax'=>$dt['pax'],
'timbang_tim'=>$dt['tim'],
'update_by'=>$_SESSION['user']['petugas'],
'update_at'=>time()
);
Update($db,"myhotel",$udt,"`code`='".$dt['code']."' and `hotel_no`='".$dt['med_hotel_no']."'",1);
$udt2=array(
'timbang_date'=>substr($dt['jam_timbang'],0,10),
'timbang_time'=>strtotime($dt['jam_timbang']),
'update_by'=>$_SESSION['user']['petugas'],
'update_at'=>time()
);
Update($db,"mykloter",$udt2,"`code`='".$dt['code']."'",1);
}
}
/* */
}