"> "> "> " style="font-size:10px;width:90px;border-radius: 5px; -moz-border-radius: 5px;" name="tgl1" placeholder="dd-mm-yyyy" type="text" required="required" type="text" onfocus="this.type='date'" onmouseover="this.type='date'" onclick="this.type='date'" onblur="this.type='text'" onmouseout="timeFunctionLong(this)"> " style="font-size:10px;width:90px;border-radius: 5px; -moz-border-radius: 5px;" name="tgl2" placeholder="dd-mm-yyyy" type="text" required="required" type="text" onfocus="this.type='date'" onmouseover="this.type='date'" onclick="this.type='date'" onblur="this.type='text'" onmouseout="timeFunctionLong(this)"> " placeholder="Search for..." style="font-size:10px" >
GENERATE DATA
= '$tgl' AND jobsite = '$rr[site]' order by tgl2 desc"); $tarharian1=mysql_fetch_array($dat); $tarharian1[target]; $dat=mysql_query("select * from targetzam where idnama='$rr[id]' AND jns='HARIAN' AND tgl1 <= '$tgl' AND tgl2 >= '$tgl' AND jobsite = '$rr[site]' order by tgl2 desc"); $tarharian2=mysql_fetch_array($dat); $tarharian2[target]; if($tarharian2[target] >= "0"){$tarharian=$tarharian2[target];}else{$tarharian=$tarharian1[target];} $dat=mysql_query("select * from sheoci where nama='$rr[nama]' AND iduser='$rr[id]' AND tgl = '$tgl' AND dept = '$rr[dept]'"); $rrr=mysql_fetch_array($dat); $cekv = mysql_query("select * from sheoci where nama='$rr[nama]' AND iduser='$rr[id]' AND tgl between '$tgl1' AND '$tgl2' AND dept = '$rr[dept]'"); $mingguanbln = mysql_num_rows($cekv); $cekv = mysql_query("select * from sheoci where nama='$rr[nama]' AND iduser='$rr[id]' AND tgl='$tgl' AND dept = '$rr[dept]'"); $mingguan1 = mysql_num_rows($cekv); if($mingguan1 <= $tarharian){$harianzz=$mingguan1;}else{$harianzz=$tarharian;} $_SESSION[harian]=$_SESSION[harian]+$harianzz; $_SESSION[tarharian]=$_SESSION[tarharian]+$tarharian; $dat=mysql_query("select * from sheocilokasi where idhazard='$rrr[id]'"); $wetwt=mysql_fetch_array($dat); $dat=mysql_query("select * from sheocitindakan2 where idhazard='$rrr[id]'"); $grgevre=mysql_fetch_array($dat); $cek = mysql_query("select * from sheocitindakan where idhazard='$rrr[id]' AND patuh='Patuh'"); $rowpatuh = mysql_num_rows($cek); $cek = mysql_query("select * from sheocitindakan where idhazard='$rrr[id]' AND patuh='Tidek Diobservasi'"); $rowtidakobserv = mysql_num_rows($cek); $cek = mysql_query("select * from sheocitindakan where idhazard='$rrr[id]' AND patuh='Tindakan Tidak Aman'"); $rowtidakaman = mysql_num_rows($cek); $dat=mysql_query("select * from targetzam where idnama='' AND jns='BULANAN' AND tgl1 <= '$tgl1' AND tgl2 >= '$tgl2' AND jobsite = '$rr[site]' order by tgl2 desc"); $tarmingguan1=mysql_fetch_array($dat); $tarmingguan1[target]; $dat=mysql_query("select * from targetzam where idnama='$rr[id]' AND jns='BULANAN' AND tgl1 <= '$tgl1' AND tgl2 >= '$tgl2' AND jobsite = '$rr[site]' order by tgl2 desc"); $tarmingguan2=mysql_fetch_array($dat); $tarmingguan2[target]; if($tarmingguan2[target] >= 1){$tarmingguan=$tarmingguan2[target];} else{$tarmingguan=$tarmingguan1[target];} if($harianzz == 0 && $tarharian== 0){$pencapaian="black";$persenn="100";} elseif($harianzz == 0 && $tarharian >= 1){$pencapaian="red";$persenn="0";} else{$pencapaian="black"; $persen=($harianzz/$tarharian)*100; $persen=ROUND($persen, 2); if($persen >=101){$persenn="100";}else{$persenn=$persen;} } $cek = mysql_query("select * from grafiksementara where tgl1='$tgl1' AND tgl2='$tgl2' AND nik='$rr[nik]' AND tarzambln='$tarmingguan'"); $sfesf = mysql_fetch_array($cek); if($mingguanbln == 0 && $tarmingguan== 0){$persennn="0";}else{ $persena=($mingguanbln/$tarmingguan)*100; $persena=ROUND($persena, 2); if($persena >=101){$persennn="100";}else{$persennn=$persena;} } if($sfesf[id] == ""){$_SESSION[blnn]=$_SESSION[blnn]+$tarmingguan; $tarmingguann=$tarmingguan; $hirungg="1"; $persennnn=$persennn; $mingguanblnn=$mingguanbln;}else{$_SESSION[blnn]=$_SESSION[blnn]+0; $tarmingguann=0;$persennnn=0;$mingguanblnn=0;$hirungg="0";} $queryy = mysql_query("INSERT INTO grafiksementara (ketlainnya,tinlainnya,ketpatuh,patuh,nama,nik,tzam,tarzam,tarzambln,dept,site,lokasi,tindakanlangsung,tgl,hps,tgl1,tgl2,idzam,jmlpatuh,jmltidak,jmltidakobservasi,jns,typee) VALUES ('$persennnn','$mingguanblnn','$hirungg','$persenn','$rr[nama]','$rr[nik]','$harianzz','$tarharian','$tarmingguann','$rr[dept]','$rr[site]','$wetwt[lokasi]','$grgevre[tindakanlangsung]','$tgl','$rr[nik]','$tgl1','$tgl2','$rrr[id]','$rowpatuh','$rowtidakobserv','$rowtidakaman','$efegaeg[lokasi]','HARIAN')"); ?> =101){$persenn="100";}else{$persenn=$persen;} $persenz=($_SESSION[harian]/$_SESSION[blnn])*100; $persenz=ROUND($persenz, 2); if($persenz >=101){$persennz="100";}else{$persennz=$persenz;} ?>
NO TANGGAL NAMA NIK JABATAN DEPT INPUT ZAM TARGET ZAM HARIAN PENCAPAIAN HARIAN INPUT ZAM BULANAN TARGET ZAM BULANAN PENCAPAIAN BULANAN SITE
"> "> "> "> "> "> "> "> "> "> "> "> ">
"> ">TOTAL BY HARIAN "> "> "> "> "> "> "> "> "> ">