while($row=mysqli_fetch_array($tabid)){ $tab_id=$row["TTIP_ID"]; } $fid= mysqli_query($con,"SELECT UARD_FILE_ID,ULD_ID FROM USER_ADMIN_REPORT_DETAILS WHERE UARD_ID=$id"); while($row=mysqli_fetch_array($fid)){ $file_id=$row["UARD_FILE_ID"]; $ure_uld_id=$row["ULD_ID"]; } $result = $con->query("CALL SP_TS_SINGLE_TABLE_ROW_DELETION(18,$id,'$USERSTAMP',@success_flag)"); if(!$result) die("CALL failed: (" . $con->errno . ") " . $con->error); $select = $con->query('SELECT @success_flag'); $result = $select->fetch_assoc(); $flag= $result['@success_flag']; if($flag==1 && ($file_id!=null || $file_id!='')) { $userfolderid=get_emp_folderid($ure_uld_id); $upload_dir = $dir.$parentfolder.DIRECTORY_SEPARATOR.$userfolderid.DIRECTORY_SEPARATOR; $deletepath = $upload_dir.$file_id.".png"; unlink($deletepath); } echo $flag; } if($_REQUEST['option']=='ONDUTY') { $sdate = $_REQUEST['sdate']; $edate=$_REQUEST['edate']; $odstartdate = date('Y-m-d',strtotime($sdate)); $odenddate=date('Y-m-d',strtotime($edate)); $sql=mysqli_query($con,"SELECT DISTINCT A.OED_ID,A.OED_DATE,A.OED_DESCRIPTION,B.ULD_LOGINID,DATE_FORMAT(CONVERT_TZ(A.OED_TIMESTAMP,'+00:00','+08:00'), '%d-%m-%Y %T')as OED_TIMESTAMP FROM ONDUTY_ENTRY_DETAILS A INNER JOIN USER_LOGIN_DETAILS B on A.ULD_ID=B.ULD_ID INNER JOIN USER_ACCESS C where A.OED_DATE between '$odstartdate' and '$odenddate' and C.UA_TERMINATE IS null"); while($row=mysqli_fetch_array($sql)){
{ if(isset($_POST["option"])){ $date = $_POST['ARE_tb_date']; $seconddate="null"; $attendance=$_POST['ARE_lb_attendance']; $perm_time=$_POST['ARE_lb_timing']; $reason=$_POST['ARE_ta_reason']; $report=$_POST['ARE_ta_report']; $ampm=$_POST['ARE_lb_ampm']; $project=$_POST['checkbox']; $ADM_uld_id=$_POST['ARE_lb_loginid']; $finaldate = date('Y-m-d',strtotime($date)); } $imagedata=$_POST['string']; $uploadcount=$_POST['upload_count']; $userfolderid=get_emp_folderid($ADM_uld_id); $doc_folder=$dir.'ATS_DOCUMENT'.DIRECTORY_SEPARATOR; echo $userfolderid.$doc_folder; //File upload function $upload_file_array=array(); for($x=0;$x<$uploadcount;$x++) { echo $_FILES['upload_filename'.$x]['tmp_name'].$uploadcount.'www'; move_uploaded_file($_FILES['upload_filename'.$x]['tmp_name'],$doc_folder.$_FILES['upload_filename'.$x]['name']); $upload_file_array[]=$_FILES['upload_filename'.$x]['name']; } $upload_filename=''; for($y=0;$y<count($upload_file_array);$y++) { if($upload_file_array[$y]!='') {
{ if($y==0) { $upload_filename=$upload_file_array[$y]; } else{ $upload_filename=$upload_filename.'/'.$upload_file_array[$y]; } } } if(($attendance=="1") || (($attendance=="0") && (($ampm=="AM") || ($ampm=="PM"))) || (($attendance=="OD") && (($ampm=="AM") || ($ampm=="PM")))){ $logname=mysqli_query($con,"SELECT ULD_ID FROM VW_TS_ALL_EMPLOYEE_DETAILS WHERE ULD_LOGINID='$USERSTAMP'"); while($row=mysqli_fetch_array($logname)){ $loginid=$row["ULD_ID"]; } $userfolderid=get_emp_folderid($loginid); $daterep=str_replace('-','',$date); $filename=$loginid.'_'.$daterep.'_'.date('His'); $upload_dir = $dir.$parentfolder.DIRECTORY_SEPARATOR.$userfolderid.DIRECTORY_SEPARATOR; $file = $upload_dir.$filename.".png"; try{ $data=str_replace('data:image/png;base64,','',$imagedata); $data = str_replace(' ','+',$data); $data = base64_decode($data); $success = file_put_contents($file, $data); $fileflg=1; } catch(Exception $e){ print $e->getMessage(); $fileflg=0; }
$imagedata=$_POST['imgData']; // echo "SELECT TRD_IMG_FILE_NAME FROM LMC_TEAM_REPORT_DETAILS WHERE TRD_DATE='$reportdate' AND EMP_ID='$activeemp'"; $oldimgfileid=mysqli_query($con,"SELECT TRD_IMG_FILE_NAME FROM LMC_TEAM_REPORT_DETAILS WHERE TRD_DATE='$reportdate' AND ULD_ID='$activeemp'"); if($row=mysqli_fetch_array($oldimgfileid)) { $old_imgfileid=$row['TRD_IMG_FILE_NAME']; } //End of File Uploads $userfolderid; $uploadpath; if($imagedata!='' && $reportdate!='' && $EmployeeReport[0]!='' && $teamname!=''){ $daterep=str_replace('-','',$reportdate); // $imgfilename=$EmployeeReport[0].'_'.$daterep.'_'.date('His').'.png'; $imgfilename=$EmployeeReport[0].'_'.$daterep.'_'.date('His').'.txt'; $userfolderid=get_emp_folderid($EmployeeReport[0]); chmod($userfolderid,0777); $path=$dir.$parentfolder.DIRECTORY_SEPARATOR.$userfolderid.DIRECTORY_SEPARATOR; // $path='LMC_REPORT_IMAGE'.DIRECTORY_SEPARATOR.'RENU_01042015_180754'.DIRECTORY_SEPARATOR; if ( ! is_writable($path)) { $writable=0; } else { $writable=1; } if(is_dir($path)){ $dirflag=1; } else{ $dirflag=0;