<?php
$vdate="191022";//closing
include_once('../etc/dbv2.php');
include_once('../etc/sessionv2.php');
include_once("../lib/language_$LG.php");
ISACCESS("",1);

$adm=$_SESSION['username'];
$op=$_REQUEST['op'];
	
	if($op == 'upload'){
		$fn=basename( $_FILES['file']['name']);
		if($fn!=""){
			$tmp=$_FILES['file']['tmp_name'];
			$fp = fopen($tmp, 'r');
			$row=1;
			while (!feof($fp)) {
				$str = stream_get_line($fp, 1000000, "\r\n");
				list($uid,$name,$jobdiv,$att_date,$att_day,$day_type,$attin,$attbreak,$attresume,$attout,$otin,$otout,$ot,$short,$jobgrp)=str_getcsv($str, ",", '"');
				$uid=str_replace("\"","",$uid);
				$uid=str_replace(" ","",$uid);
				$name=str_replace("\"","",$name);
				$name=addslashes($name);
				$jobdiv=str_replace("\"","",$jobdiv);
				$jobgrp=str_replace("\"","",$jobgrp);
				$jobgrp=str_replace(" ","",$jobgrp);
				$att_date=str_replace("\"","",$att_date);
				list($hh,$bb,$tttt)=explode("/",$att_date);
				$att_date="$tttt-$bb-$hh";
				$attday=str_replace("\"","",$attday);
				$day_type=str_replace("\"","",$day_type);
				$attin=str_replace("\"","",$attin);
				$attbreak=str_replace("\"","",$attbreak);
				$attresume=str_replace("\"","",$attresume);
				$attout=str_replace("\"","",$attout);
				$otin=str_replace("\"","",$otin);
				$otout=str_replace("\"","",$otout);
				$ot=str_replace("\"","",$ot);
				$short=str_replace("\"","",$short);
				$attin=str_replace(" ","",$attin);
				$attbreak=str_replace(" ","",$attbreak);
				$attresume=str_replace(" ","",$attresume);
				$attout=str_replace(" ","",$attout);
				$otin=str_replace(" ","",$otin);
				$otout=str_replace(" ","",$otout);
				$ot=str_replace(" ","",$ot);
				$short=str_replace(" ","",$short);

				/* buang qouble quote */

				$uid=addslashes($uid);
				$xname=addslashes($name);
				$jobgrp=addslashes($jobgrp);
				$jobdiv=addslashes($jobdiv);
				
				if(($attin=="") && ($attout=="") && ($otin=="") && ($otout=="")){$sta=1;}else{$sta=0;}
				
				/*$sql="insert into usr(cdate,sch_id,uid,name,ic,tel,hp,mel,addr,syslevel,pass,job,jobsta,jobdiv,jobstart) 
				values (now(),$sid,'$uid','$xname','$ic','$tel','$hp','$mel','$addr','GURU','123456','$job','$jobsta','$jobdiv','$jobstart')";
				mysql_query($sql)or die("$sql 6query failed:".mysql_error());
				$sql="update type set val=val+1 where grp='staffid' and sid='$sid'";
				mysql_query($sql)or die("query failed:".mysql_error());
				*/
				$sqlcekrekod="select * from usratt where d='$att_date' and usr_uid='$uid'";
				$rescekrekod=mysqli_query($link,$sqlcekrekod)or die("$sqlcekrekod query failed:".mysqli_error($link));
				$numcekrekod=mysqli_num_rows($rescekrekod);
				if($numcekrekod>0){
				$sql="update usratt set att='$att',sta='$sta',des='$des',daytype='$day_type',att_in='$attin',att_break='$attbreak',att_resume='$attresume',att_out='$attout',ot_in='$otin',ot_out='$otout',upd_att=now(),usr_grp='$jobgrp',ot='$ot',short='$short',sch_id='$sid' where year='$tttt' and usr_uid='$uid' and d='$att_date';";
				}else{
				$sql="insert into usratt(sch_id,usr_uid,year,d,att,sta,des,daytype,att_in,att_break,att_resume,att_out,ot_in,ot_out,upd_att,usr_grp,ot,short)values('$sid','$uid','$tttt','$att_date','$att','$sta','$des','$day_type','$attin','$attbreak','$attresume','$attout','$otin','$otout',now(),'$jobgrp','$ot','$short');";
				}

				if($row>1 && $uid!=''){
				//echo $sql."<br>";
				mysqli_query($link,$sql)or die("$sql query failed:".mysqli_erorr($link));
				}
					$row++;
			}
			$f="<font color=\"red\"><b>$lg_successfully_saved</b></font>";
		}
	}
?>
<!DOCTYPE html>
<!-- Author: Awfatech -->
<!--[if IE 8]><html class="ie8" lang="en"><![endif]-->
<!--[if IE 9]><html class="ie9" lang="en"><![endif]-->
<!--[if !IE]><!-->
<html lang="en">
	<!--<![endif]-->
	<!-- start: HEAD -->
	<head>
		<title><?php echo "$lg_upload $lg_staff_attendance";?></title>
</head>
<body>
<form name="mymodal" id="mymodal" method="post" enctype="multipart/form-data">
	<input type="hidden" name="op">
	<input type="hidden" name="sid" value="<?php echo $sid;?>">
	<input type="hidden" name="page" value="../usratt/usratt_upload.php">

	<div class="modal-content no-border">
        <!-- START SECTION 1 : HEADER -->
		<div class="modal-header mybg-dark-blue">
			<div class="pull-left">
				<h4 class="text-white no-margin text-uppercase"><?php echo "$lg_upload $lg_staff_attendance";?></h4>
			</div>
			<div class="pull-right">
				<a class="text-white text-large" data-dismiss="modal"><i class="ti ti-close text-white"></i></a>
			</div>
			<!-- end: FILTER -->
		</div>
		<div class="mytabletitle mybg-black no-border">
			<a class="btn text-white" onClick="upload_data('mymodal','upload');">
				<span class="text-white"><i class="ti ti-upload"></i><div class="text-small"><?php echo "$lg_upload";?></div></span>
            </a>
			<a class="btn text-white" href="<?php echo "../usratt/upload_att.csv";?>">
				<span class="text-white"><i class="ti ti-download"></i><div class="text-small"><?php echo "$lg_download $lg_format";?></div></span>
            </a>
            <a class="btn text-white" onclick="main_processv2('mymodal');">
                <span class="text-white"><i class="ti ti-reload"></i><div class="text-small"><?php echo $lg_refresh;?></div></span>
            </a>
		</div>
		<div class="panel-body">
			<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
				<div class="form-group col-xs-12 col-sm-12 col-md-6 col-lg-6">
					<font color="blue">
						<?php if($LG=="BM"){?>
							Langkah 1: Muat turun fail format .Csv<br>
							Langkah 2: Masukkan data yang anda perlukan <br/> (* symbol ini data yang wajib di isi dan symbol(,) tidak diperlukan), bermula baris kedua.<br>
							Langkah 3: Tekan butang choose file<br>
							Langkah 4: Pilih fail .csv yang telah anda ubah<br>
							Langkah 5: Tekan butang muat naik<br>
						<?php }else{?>
							Step 1: Download format File .Csv<br>
							Step 2: Enter the data you needed <br/> (* this symbol is mandatory data and symbol(,) no need), starting second row.<br>
							Step 3: Click choose file to process/upload<br>
							Step 4: Choose the .csv file you have changed<br>
							Step 5: Click upload button<br>
						<?php }?>
					</font>
				</div>
				<div class="form-group col-xs-12 col-sm-12 col-md-6 col-lg-6">
					<span class="text-bold"> <?php echo "$lg_upload";?></span>
					<input type="file" name="file" id="file" class="form-control input-sm">
				</div>
				<?php echo $f;?>
			</div>
		</div>
	</div>
</form>
</body>
</html>
