Example #1
0
function UploadEmployeeFiles($formname, $loginid_result)
{
    global $con, $ClientId, $ClientSecret, $RedirectUri, $DriveScopes, $CalenderScopes, $Refresh_Token, $emp_uldid;
    $loginid = $loginid_result;
    $emp_uploadfilelist = array();
    $login_empid = getEmpfolderName($loginid);
    //    echo $login_empid;exit;
    $select_folderid = mysqli_query($con, "SELECT * FROM USER_RIGHTS_CONFIGURATION WHERE URC_ID=13");
    if ($row = mysqli_fetch_array($select_folderid)) {
        $folderid = $row["URC_DATA"];
    }
    $drive = new Google_Client();
    $Client = get_servicedata();
    $ClientId = $Client[0];
    $ClientSecret = $Client[1];
    $RedirectUri = $Client[2];
    $DriveScopes = $Client[3];
    $CalenderScopes = $Client[4];
    $Refresh_Token = $Client[5];
    $drive->setClientId($ClientId);
    $drive->setClientSecret($ClientSecret);
    $drive->setRedirectUri($RedirectUri);
    $drive->setScopes(array($DriveScopes, $CalenderScopes));
    $drive->setAccessType('online');
    $refresh_token = $Refresh_Token;
    $drive->refreshToken($refresh_token);
    $service = new Google_Service_Drive($drive);
    $logincre_foldername = $login_empid;
    $emp_folderid = "";
    $emp_uploadfilenamelist = array();
    $emp_uploadfileidlist = array();
    $children = $service->children->listChildren($folderid);
    $root_filearray = $children->getItems();
    foreach ($root_filearray as $child) {
        if ($service->files->get($child->getId())->getExplicitlyTrashed() == 1) {
            continue;
        }
        $rootfold_title = $service->files->get($child->getId())->title;
        $split_folderid = explode(" ", $rootfold_title);
        if (strcasecmp($emp_uldid, $split_folderid[count($split_folderid) - 1]) != 0) {
            continue;
        }
        $emp_folderid = $service->files->get($child->getId())->id;
        if ($rootfold_title != $login_empid) {
            //        //rename folder for loging updation start
            renamefile($service, $logincre_foldername, $emp_folderid);
        }
        //end
        $emp_uploadfilenamelist = array();
        $children1 = $service->children->listChildren($child->getId());
        $child_filearray = $children1->getItems();
        sort($child_filearray);
        foreach ($child_filearray as $child1) {
            if ($service->files->get($child1->getId())->getExplicitlyTrashed() == 1) {
                continue;
            }
            $emp_uploadfilenamelist[] = $service->files->get($child1->getId())->title;
        }
        break;
    }
    sort($emp_uploadfilenamelist);
    $emp_uploadfileidlist = array();
    $emp_uploadfilelinklist = array();
    for ($f = 0; $f < count($emp_uploadfilenamelist); $f++) {
        $children1 = $service->children->listChildren($emp_folderid);
        $filearray1 = $children1->getItems();
        foreach ($filearray1 as $child1) {
            if ($service->files->get($child1->getId())->getExplicitlyTrashed() == 1) {
                continue;
            }
            if ($service->files->get($child1->getId())->title == $emp_uploadfilenamelist[$f]) {
                $emp_uploadfileidlist[] = $service->files->get($child1->getId())->id;
                $emp_uploadfilelinklist[] = $service->files->get($child1->getId())->alternateLink;
            }
        }
    }
    if ($emp_folderid == "" && $formname == "login_creation") {
        $newFolder = new Google_Service_Drive_DriveFile();
        $newFolder->setMimeType('application/vnd.google-apps.folder');
        $newFolder->setTitle($logincre_foldername);
        if ($folderid != null) {
            $parent = new Google_Service_Drive_ParentReference();
            $parent->setId($folderid);
            $newFolder->setParents(array($parent));
        }
        try {
            $folderData = $service->files->insert($newFolder);
        } catch (Google_Service_Exception $e) {
            echo 'Error while creating <br>Message: ' . $e->getMessage();
            die;
        }
        $emp_folderid = $folderData->id;
    }
    if ($formname == "login_fetch") {
        if ($emp_folderid == "") {
            echo "Error:Folder id Not present";
            exit;
        }
        $emp_uploadfiles = array($emp_uploadfileidlist, $emp_uploadfilenamelist, $emp_uploadfilelinklist);
        return $emp_uploadfiles;
    }
    return $emp_folderid;
}
             $refresh_token = $Refresh_Token;
             $drive->refreshToken($refresh_token);
             $service = new Google_Service_Drive($drive);
             $file_id_value = insertFile($service, $ufilename, 'PersonalDetails', $new_empfolderid, $ufiletype, $ufiletempname);
             if ($file_id_value != '') {
                 array_push($file_array, $file_id_value);
             }
         }
     }
 }
 if ($upload_flag == 1 && count($file_array) == 0) {
     $file_flag = 0;
     URSRC_unshare_document($loginid, $fileId);
     URSRC_unshare_document($loginid, $codeopti_fileId);
     $con->rollback();
     $login_empid = getEmpfolderName($loginid);
     renamefile($service, $login_empid, $new_empfolderid);
 }
 //UPDATE PART SENDING MAIL
 $select_template = "SELECT * FROM EMAIL_TEMPLATE_DETAILS WHERE ET_ID=16";
 $select_template_rs = mysqli_query($con, $select_template);
 if ($row = mysqli_fetch_array($select_template_rs)) {
     $mail_subject1 = $row["ETD_EMAIL_SUBJECT"];
     $body = $row["ETD_EMAIL_BODY"];
 }
 $select_template = "SELECT URC_DATA FROM USER_RIGHTS_CONFIGURATION WHERE URC_ID=26";
 $select_template_rs = mysqli_query($con, $select_template);
 if ($row = mysqli_fetch_array($select_template_rs)) {
     $mail_display1 = $row["URC_DATA"];
 }
 //not aplicable