query($query_employees); $query_position ="SELECT position_id FROM position"; $result_count_position = $connection->query($query_position); $query_building ="SELECT building_id FROM building"; $result_count_building = $connection->query($query_building); $query_shift ="SELECT shift_id FROM shift"; $result_count_shift = $connection->query($query_shift); echo'

'.$result_count->num_rows.'

Pengguna

Selengkapnya

'.$result_count_position->num_rows.'

Jabatan

Selengkapnya

'.$result_count_building->num_rows.'

Lokasi Kantor

Selengkapnya

'.$result_count_shift->num_rows.'

Shift Kerja

Selengkapnya

Statistik Absensi

'; $date = date("d-m-Y",strtotime("-6 days")); $D = substr($date,0,2); $M = substr($date,3,2)-1; $Y = substr($date,6,4); $tgl_skrg = date("Y-m-d"); $seminggu = strtotime("-1 week +1 day",strtotime($tgl_skrg)); $hasilnya = date('Y-m-d', $seminggu); //visitor for ($i=0; $i<=6; $i++){ $tgl_pengujung = strtotime("+$i day",strtotime($hasilnya)); $hasil_pengujung = date("Y-m-d", $tgl_pengujung); $tanggal_visitor []= tgl_ind($hasil_pengujung); $query_absensi ="SELECT presence_date FROM presence WHERE presence_date='$hasil_pengujung'"; $result_absensi = $connection->query($query_absensi); $absensi [] = $result_absensi->num_rows; } $tanggal_visitor = implode('","',$tanggal_visitor);?>