&tipe=&shift=&search=&site=&tgl1=&tgl2=" target="_blank">

MONTHLY PERFORMANCE PENGAWAS

0){$_SESSION[ratarcii]=$_SESSION[ratarcii]+1;}else{$_SESSION[ratarcii]=$_SESSION[ratarcii];} $rata1=($targetkx1/$ffff1[rata]*100)/$rowcountt1; $averagerci1=ROUND($rata1, 2); $adal = mysql_query("select * from datainsdis2 where (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND tgl between '$tgl1' AND '$tgl2' AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]'"); $ffff2 = mysql_fetch_array($adal); $cekv = mysql_query("select * FROM datainsdis2 WHERE (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND tgl between '$tgl1' AND '$tgl2' AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]' GROUP BY ids,nounit,site"); $rowcountt2= mysql_num_rows($cekv); $errre2=$rowcountt2*$ffff2[rata]; $query3q="SELECT SUM(nilai) FROM datainsdis2 where (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND tgl between '$tgl1' AND '$tgl2' AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]'"; $hasil3=mysql_query($query3q); $targetkx2 = mysql_result($hasil3, 0, 0); if($targetkx2 > 0){$_SESSION[ratarcii]=$_SESSION[ratarcii]+1;}else{$_SESSION[ratarcii]=$_SESSION[ratarcii];} $rata2=($targetkx2/$ffff2[rata]*100)/$rowcountt2; $averagerci2=ROUND($rata2, 2); $adal = mysql_query("select * from datarci where (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND tgl between '$tgl1' AND '$tgl2' AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]'"); $ffff3 = mysql_fetch_array($adal); $cekv = mysql_query("select * FROM datarci WHERE (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND tgl between '$tgl1' AND '$tgl2' AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]' GROUP BY ids,nounit,namajalan"); $rowcountt3= mysql_num_rows($cekv); $errre3=$rowcountt3*$ffff3[rata]; $query3q="SELECT SUM(nilai) FROM datarci where (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND tgl between '$tgl1' AND '$tgl2' AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]'"; $hasil3=mysql_query($query3q); $targetkx3 = mysql_result($hasil3, 0, 0); if($targetkx3 > 0){$_SESSION[ratarcii]=$_SESSION[ratarcii]+1;}else{$_SESSION[ratarcii]=$_SESSION[ratarcii];} $rata3=($targetkx3/$ffff3[rata]*100)/$rowcountt3; $averagerci3=ROUND($rata3, 2); $averagercii=$averagerci3+$averagerci2+$averagerci1; $averagerciii=$averagercii/$_SESSION[ratarcii]; $averagerci=ROUND($averagerciii, 2); $sqlx = mysql_query("SELECT * FROM datainsdis where tgl between '$tgl1' AND '$tgl2' AND (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]' group by nounitt,tgl,shift ORDER BY id desc"); $counterx="1"; while($isi = mysql_fetch_array($sqlx)){ if($isi[nounitt]==""){}else{ $query = mysql_query("INSERT INTO hisindis (nama,nik,tipe,avgjarak,plantpty,produc,fk,thm,site,data,jns,produksi,twh,twhh) values ('$isii[nama_barang]','$isii[id_barang]','$isi[shift]','$isi[tgl]','$isi[nounitt]','indis','','','$isi[site]','$_COOKIE[usernamex] $_SESSION[random]','DASHMPO','','','')"); } $counterx++;} $sqlx = mysql_query("SELECT * FROM datainsdis2 where tgl between '$tgl1' AND '$tgl2' AND (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]' group by nounit,tgl,shift ORDER BY id desc"); $counterx="1"; while($isi = mysql_fetch_array($sqlx)){ if($isi[nounit]==""){}else{ $query = mysql_query("INSERT INTO hisindis (nama,nik,tipe,avgjarak,plantpty,produc,fk,thm,site,data,jns,produksi,twh,twhh) values ('$isii[nama_barang]','$isii[id_barang]','$isi[shift]','$isi[tgl]','$isi[nounit]','indis2','','','$isi[site]','$_COOKIE[usernamex] $_SESSION[random]','DASHMPO','','','')"); } $counterx++;} $sqlx = mysql_query("SELECT * FROM datarci where tgl between '$tgl1' AND '$tgl2' AND (namagl = '$isii[nama_barang]' || nikgl='$isii[id_barang]') AND shift like '%$shiftt%' AND site = '$isii[satuan_barang]' group by nounit,tgl,shift ORDER BY id desc"); $counterx="1"; while($isi = mysql_fetch_array($sqlx)){ if($isi[nounit]==""){}else{ $query = mysql_query("INSERT INTO hisindis (nama,nik,tipe,avgjarak,plantpty,produc,fk,thm,site,data,jns,produksi,twh,twhh) values ('$isii[nama_barang]','$isii[id_barang]','$isi[shift]','$isi[tgl]','$isi[nounit]','rci','','','$isi[site]','$_COOKIE[usernamex] $_SESSION[random]','DASHMPO','','','')"); } $counterx++;} $tampil=mysql_query("SELECT * FROM hisindis WHERE avgjarak between '$tgl1' AND '$tgl2' AND (nama = '$isii[nama_barang]' || nik = '$isii[id_barang]') AND data='$_COOKIE[usernamex] $_SESSION[random]' AND jns='DASHMPO' AND tipe like '%$shiftt%' AND site = '$isii[satuan_barang]' GROUP by plantpty,tipe,avgjarak,site ORDER by avgjarak DESC"); $counterr = 1; while ($rrr=mysql_fetch_array($tampil)){ $rr = mysql_fetch_array(mysql_query("SELECT * FROM datahm WHERE tgl = '$rrr[avgjarak]' AND shift = '$rrr[tipe]' AND nounit='$rrr[plantpty]' AND site='$rrr[site]'")); if($rr[tgl]==""){ $_SESSION[produksii]=$_SESSION[produksii];$_SESSION[ptyy]=$_SESSION[ptyy];$_SESSION[jarakk]=$_SESSION[jarakk];$_SESSION[troduksi]=$_SESSION[troduksi]; $_SESSION[faktorr]=$_SESSION[faktorr];$_SESSION[banyakk]=$_SESSION[banyakk];$_SESSION[banyakkk]=$_SESSION[banyakkk];$_SESSION[producc]=$_SESSION[producc]; }else{ $totald=$rr[hmakhir]-$rr[hmawal]; $totall=ROUND($totald, 2); if($totall >= 15){ $shm="11"; $total=($shm)*0.95; } elseif($totall <= -0){ $total=0; $shm="0";} else{ $total=($totall)*0.95; $shm=$totall;} $ewh=$rr[selisihhm]; $ewh=ROUND($ewh, 2); $whh=$totald-$rr[selisihhm]; $wh=ROUND($whh, 2); $produksii=$rr[produksi]; $produksi=ROUND($produksii, 2); $produksiii=$produksi/$total; $produc=ROUND($produksiii, 2); $ptyy=$rr[pty]; $pty=ROUND($ptyy, 2); $faktorr=($produksiii/$pty)*100; $faktor=ROUND($faktorr, 2); $jarakk=$rr[jarak]; $jarak=ROUND($jarakk, 2); if($ewh >= 15){ $twh="11";} elseif($ewh <= 0){ $twh="0";} else{$twh=$ewh;} $tskk=$shm-$twh; $dhe=($tskk/$shm)*100; $dhe=ROUND($dhe, 2); $_SESSION[twh]=$_SESSION[twh]+$dhe; $_SESSION[totalwh]=$_SESSION[totalwh]+$rr[selisihhm]; if($faktor >= "120"){$_SESSION[produksii]=$_SESSION[produksii];$_SESSION[ptyy]=$_SESSION[ptyy];$_SESSION[jarakk]=$_SESSION[jarakk];$_SESSION[troduksi]=$_SESSION[troduksi]; $_SESSION[faktorr]=$_SESSION[faktorr];$_SESSION[banyakk]=$_SESSION[banyakk];$_SESSION[banyakkk]=$_SESSION[banyakkk]+1;$_SESSION[producc]=$_SESSION[producc]; } elseif($faktor <= "5"){ $_SESSION[produksii]=$_SESSION[produksii];$_SESSION[ptyy]=$_SESSION[ptyy];$_SESSION[jarakk]=$_SESSION[jarakk];$_SESSION[troduksi]=$_SESSION[troduksi]; $_SESSION[faktorr]=$_SESSION[faktorr];$_SESSION[producc]=$_SESSION[producc];$_SESSION[banyakk]=$_SESSION[banyakk];$_SESSION[banyakkk]=$_SESSION[banyakkk]+1; }else{$_SESSION[jarakk]=$_SESSION[jarakk]+$jarak;$_SESSION[ptyy]=$_SESSION[ptyy]+$pty;$_SESSION[produksii]=$_SESSION[produksii]+$produksi;$_SESSION[producc]=$_SESSION[producc]+$produc;$_SESSION[faktorr]=$_SESSION[faktorr]+$faktor; $_SESSION[banyakk]=$_SESSION[banyakk]+1; $_SESSION[banyakkk]=$_SESSION[banyakkk]+1; $_SESSION[troduksi]=($produksi*$jarak)+$_SESSION[troduksi]; } $_SESSION[totalhmm]=$_SESSION[totalhmm]+$shm; } $counterr++;} $gggg=$_SESSION[faktorr]/$_SESSION[banyakk]; $fk=ROUND($gggg, 2); $ggggg=$_SESSION[twh]/$_SESSION[banyakk]; $twhh=ROUND($ggggg, 2); $dat=mysql_query("select * from atr WHERE tgl between '$tgl1' AND '$tgl2' AND (nama = '$isii[nama_barang]' || nik = '$isii[id_barang]') AND site = '$isii[satuan_barang]' AND (jam!='A' || jam!='')"); $adaatr=mysql_num_rows($dat); $atrf=($adaatr/$jmlhar)*100; $atrf=ROUND($atrf, 0); include"condbams.php"; $dat=mysql_query("select * from shemanpower where (nik='$isii[id_barang]' || nama='$isii[nama_barang]') AND site = '$siteee'"); $sfsf=mysql_fetch_array($dat); $dat=mysql_query("select * from targetzam WHERE target='-2' AND idnama='$sfsf[id]' AND jns='HARIAN' AND tgl1 between '$tgl1' AND '$tgl2' AND jobsite = '$siteee' GROUP BY tgl1,idnama"); $dsfs=mysql_num_rows($dat); $targetkx=-2*$dsfs; $ttarharian=($jmlhar*2); $cekv = mysql_query("select * from sheoci where iduser='$sfsf[id]' AND tgl between '$tgl1' AND '$tgl2' GROUP by iduser,tgl,pukul"); $mingguana= mysql_num_rows($cekv); if($mingguana <= $ttarharian){ $harianza=$mingguana; } else{$harianza=$ttarharian;} include"condb.php"; $tarharian=($jmlhar*2)+$targetkx; if($tarharian == 0){$pencapaian="black";} elseif($harianza < $tarharian){$pencapaian="red";} else{$pencapaian="black";} $persen=($harianza/$tarharian)*100; $persen=ROUND($persen, 2); if($harianza <= $tarharian){$harian=$harianza;}else{$harian=$tarharian;} if($persen >=101){$persenn="100";} elseif($targetkx == "-$ttarharian"){$persenn="100";} else{$persenn=$persen;} $query3q="SELECT SUM(nilai) FROM buserrci WHERE tgl1 >= '$tgl1' AND tgl2 <= '$tgl2' AND (nik='$isii[id_barang]' || nama='$isii[nama_barang]') AND site = '$isii[satuan_barang]'"; $hasil3=mysql_query($query3q); $asisment = mysql_result($hasil3, 0, 0); $query3q="SELECT SUM(hasil) FROM buserrci WHERE tgl between '$tgl1' AND '$tgl2' AND nikgl='$isii[id_barang]' AND shift like '%$shiftt%' AND namagl = '$isii[nama_barang]' AND site = '$isii[satuan_barang]'"; $hasil3=mysql_query($query3q); $hasilbuserrci = mysql_result($hasil3, 0, 0); $dat=mysql_query("select * from buserrci WHERE tgl between '$tgl1' AND '$tgl2' AND nikgl='$isii[id_barang]' AND shift like '%$shiftt%' AND namagl = '$isii[nama_barang]' AND site = '$isii[satuan_barang]'"); $hasilbuserrcibagi=mysql_num_rows($dat); $tarbuserrci=(100*$hasilbuserrcibagi); $buserprorcii=($hasilbuserrci/$tarbuserrci)*100; $buserprorci=ROUND($buserprorcii, 2); $rci=$averagerci/100; $rcii=$rci*100*0.1; $rciix="$averagerci%*100*10%"; $bsr=$buserprorci/100; $bsrr=$bsr*100*0.1; $bsrrx="$buserprorci%*100*10%"; $fkh=$fk/100; $fkk=$fkh*100*0.1; $fkkx="$fk%*100*10%"; $atr=$atrf/100; $atrr=$atr*100*0.1; $atrrx="$atrf%*100*10%"; $zam=$persenn/100; $zamm=$zam*100*0.1; $zammx="$persenn%*100*10%"; $twhhf=$twhh/100; $twhhh=$twhhf*100*0.1; if($twhh < 5){ $performancee=(100*0.1+$asisment*0.2); $performanceex="Deviasi HM WH < 5% (100 x 10% + $asisment x 20%=$performancee)";}else{ $performancee=(0.5/$twhhh*100*0.1+$asisment*0.2); $performanceex="Deviasi HM WH > 5% (50% / $twhh% x 100 x 10% + $asisment x 20%=$performancee)"; } $performance=$rcii+$bsrr+$fkk+$atrr+$zamm+$performancee; $performance=ROUND($performance, 2); $dat=mysql_query("select * from atr where (nik='$isii[id_barang]' || nama='$isii[nama_barang]')"); $adaatrr=mysql_fetch_array($dat); if($adaatrr >= 1){$adafinger="black";}else{$adafinger="blue";} ?>

NO	DETAILS	NAMA	NIK	JAB	RCI/FCI/DCI	BUSER PRODUCTIVITY	PRODUCTIVITY	ATR	ZAM	DEVIASI HM WH	NILAI ASSESMENT	NILAI PERFORMANCE PENGAWAS	JOBSITE
					">	">%	">	">;">%	">%	">%		">