='$tglawal' and tgl<=curdate();"); $result_omset = mysqli_fetch_array($query_omset); $realomset=$result_omset['omset']; $persenomset=($realomset/$tomset)*100; $query_employees ="SELECT id FROM pjppersonildetail where kdslm='$kdslm' group by custno;"; $result_count = $con->query($query_employees); $query_realoa ="SELECT custno FROM somobileheader where kdslm='$kdslm' and tgl>='$tglawal' and tgl<=curdate() group by custno;"; $result_count_oa = $con->query($query_realoa); $result_count_persen=($result_count_oa->num_rows/$result_count->num_rows)*100; $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'
Profil
Absen
ID Card
Transaksi
Target

'.number_format($tomset).'

Realisasi

'.number_format($realomset).'

Target

'.$result_count->num_rows.'

Realisasi

'.$result_count_oa->num_rows.'

Target

'.$result_count->num_rows.'

Realisasi

'.$result_count->num_rows.'

Target

'.$result_count->num_rows.'

Realisasi

'.$result_count->num_rows.'

Target

'.$result_count->num_rows.'

Realisasi

'.$result_count->num_rows.'

Target

'.$result_count->num_rows.'

Realisasi

'.$result_count->num_rows.'

Statistik Penjualan

'; $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 tgl FROM somobileheader WHERE tgl='$hasil_pengujung'"; $result_absensi = $connection->query($query_absensi); $absensi [] = $result_absensi->num_rows; } $tanggal_visitor = implode('","',$tanggal_visitor);?>