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;
     }
Example #4
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;