Periode
| NAMA | NIK | DEPT | JOBSITE | MINGGU |
MINGGU |
MINGGU |
MINGGU |
TARGET | AKTUAL | RATA2 |
|---|---|---|---|---|---|---|---|---|---|---|
| ='$tgl1a' AND tgl<='$tgl1b' AND nik2 = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu11= mysql_num_rows($cekv); $cekv = mysql_query("select * from absen where (atr='C' || atr='S' || atr='R') AND tgl>='$tgl1a' AND tgl<='$tgl1b' AND nik = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu1absen= mysql_num_rows($cekv); $ada1=mysql_fetch_array($cekv); $cekv = mysql_query("select * from cnc where kategori like '%$kategorii%' AND tgl>='$tgl2a' AND tgl<='$tgl2b' AND nik2 = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu22= mysql_num_rows($cekv); $cekv = mysql_query("select * from absen where (atr='C' || atr='S' || atr='R') AND tgl>='$tgl2a' AND tgl<='$tgl2b' AND nik = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu2absen= mysql_num_rows($cekv); $ada2=mysql_fetch_array($cekv); $cekv = mysql_query("select * from cnc where kategori like '%$kategorii%' AND tgl>='$tgl3a' AND tgl<='$tgl3b' AND nik2 = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu33= mysql_num_rows($cekv); $cekv = mysql_query("select * from absen where (atr='C' || atr='S' || atr='R') AND tgl>='$tgl3a' AND tgl<='$tgl3b' AND nik = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu3absen= mysql_num_rows($cekv); $ada3=mysql_fetch_array($cekv); $cekv = mysql_query("select * from cnc where kategori like '%$kategorii%' AND tgl>='$tgl4a' AND tgl<='$tgl4b' AND nik2 = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu44= mysql_num_rows($cekv); $cekv = mysql_query("select * from absen where (atr='C' || atr='S' || atr='R') AND tgl>='$tgl4a' AND tgl<='$tgl4b' AND nik = '$rr[id_barang]' AND jobsite = '$rr[satuan_barang]'"); $minggu4absen= mysql_num_rows($cekv); $ada4=mysql_fetch_array($cekv); $_SESSION[cutii]=$targetm+$_SESSION[cutii]; if($minggu1absen >= 1){$minggu1="2";}else{$minggu1="";} if($minggu2absen >= 1){$minggu2="2";}else{$minggu2="";} if($minggu3absen >= 1){$minggu3="2";}else{$minggu3="";} if($minggu4absen >= 1){$minggu4="2";}else{$minggu4="";} if($minggu11 <= 0 && $minggu1absen >= 1){$minggu1a="2";}else{$minggu1a="";} if($minggu22 <= 0 && $minggu2absen >= 1){$minggu2a="2";}else{$minggu2a="";} if($minggu33 <= 0 && $minggu3absen >= 1){$minggu3a="2";}else{$minggu3a="";} if($minggu44 <= 0 && $minggu4absen >= 1){$minggu4a="2";}else{$minggu4a="";} if($tarharian2aa[target] >= 1){$tarmingguan=$tarharian2aa[target]-$minggu1a-$minggu2a-$minggu3a-$minggu4a;} elseif($tarharian2a[target] >= 1){$tarmingguan=$tarharian2a[target]-$minggu1a-$minggu2a-$minggu3a-$minggu4a;} else{$tarmingguan="";} if($minggu11 >= $tarharian2accc[target]){ $pencapaian1="";} elseif($minggu11 =="0" && $ada1[atr] != "C"){ $pencapaian1="red";} elseif($minggu11 < $tarharian2accc[target] && $minggu11 >=1){ $pencapaian1="orange";} elseif($minggu11 < $tarharian2accc[target] && $minggu1absen >=1){ $pencapaian1="orange";} else{$pencapaian1="red";} if($minggu22 >= $tarharian2accc[target]){ $pencapaian2="";} elseif($minggu22 =="0" && $ada2[atr] != "C"){ $pencapaian2="red";} elseif($minggu22 < $tarharian2accc[target] && $minggu22 >=1){ $pencapaian2="orange";} elseif($minggu22 < $tarharian2accc[target] && $minggu2absen >= 1){ $pencapaian2="orange";} else{$pencapaian2="red";} if($minggu33 >= $tarharian2accc[target]){ $pencapaian3="";} elseif($minggu33 =="0" && $ada3[atr] != "C"){ $pencapaian3="red";} elseif($minggu33 < $tarharian2accc[target] && $minggu33 >=1){ $pencapaian3="orange";} elseif($minggu33 < $tarharian2accc[target] && $minggu3absen >= 1){ $pencapaian3="orange";} else{$pencapaian3="red";} if($minggu44 >= $tarharian2accc[target]){ $pencapaian4="";} elseif($minggu44 =="0" && $ada4[atr] != "C"){ $pencapaian4="red";} elseif($minggu44 < $tarharian2accc[target] && $minggu44 >=1){ $pencapaian4="orange";} elseif($minggu44 < $tarharian2accc[target] && $minggu4absen >= 1){ $pencapaian4="orange";} else{$pencapaian4="red";} $targetm=$minggu11+$minggu22+$minggu33+$minggu44; $_SESSION[cuti]=$_SESSION[cuti]+$minggu11; $_SESSION[cutii]=$_SESSION[cutii]+$minggu22; $_SESSION[cutiii]=$_SESSION[cutiii]+$minggu33; $_SESSION[cutiiii]=$_SESSION[cutiiii]+$minggu44; if($minggu11 <= 0 && $minggu1absen >= 1){$minggu11a="$ada1[atr]";}else{$minggu11a=$minggu11;} if($minggu22 <= 0 && $minggu2absen >= 1){$minggu22a="$ada2[atr]";}else{$minggu22a=$minggu22;} if($minggu33 <= 0 && $minggu3absen >= 1){$minggu33a="$ada3[atr]";}else{$minggu33a=$minggu33;} if($minggu44 <= 0 && $minggu4absen >= 1){$minggu44a="$ada4[atr]";}else{$minggu44a=$minggu44;} $persen=($targetm/$tarmingguan)*100; $persen=ROUND($persen, 2); if($persen >=101){$persenn="100";} else{$persenn=$persen;} if($targetm >= $tarmingguan){ $pencapaian="";} else{$pencapaian="red";} ?> | "> | "> | "> | "> | "> | "> | ||||
| TOTAL | ||||||||||
WriteHTML($html); $mpdf->WriteHTML($stylesheet,1); $mpdf->WriteHTML(utf8_encode($html)); $mpdf->Output($nama_dokumen.".pdf" ,'I'); exit; ?>