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; }
function URSRC_delete_create_calendarevent($ULD_id, $loginid_name, $finaldate) { global $con, $ClientId, $ClientSecret, $RedirectUri, $DriveScopes, $CalenderScopes, $Refresh_Token; $select_calenderid = mysqli_query($con, "SELECT * FROM USER_RIGHTS_CONFIGURATION WHERE URC_ID=10"); if ($row = mysqli_fetch_array($select_calenderid)) { $calenderid = $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'); $authUrl = $drive->createAuthUrl(); $refresh_token = $Refresh_Token; $drive->refreshToken($refresh_token); $cal = new Google_Service_Calendar($drive); $service = new Google_Service_Calendar($drive); try { $events = $service->events->listEvents($calenderid); } catch (Exception $e) { $cal_flag = 0; return $cal_flag; } while (true) { foreach ($events->getItems() as $newevent) { $desc = $newevent->getDescription(); if ($desc == $ULD_id) { $event_id = $newevent->getId(); $service->events->delete($calenderid, $event_id); } } $pageToken = $events->getNextPageToken(); if ($pageToken) { $optParams = array('pageToken' => $pageToken); $events = $service->events->listEvents($calenderid, $optParams); } else { break; } } $cal_flag = URSRC_calendar_create($loginid_name, $ULD_id, $finaldate, $calenderid, 'JOIN DATE'); return $cal_flag; }
echo JSON_ENCODE($appendTable); } //UPDATE CODING if ($_REQUEST['option'] == "CONFIG_SRCH_UPD_save") { $ff = 1; $flag = $_REQUEST['CONFIG_SRCH_UPD_lb_module']; $CONFIG_SRCH_UPD_data = $_REQUEST['CONFIG_SRCH_UPD_tb_data']; $CONFIG_SRCH_UPD_type = $_REQUEST['CONFIG_SRCH_UPD_lb_type']; $CONFIG_SRCH_UPD_id = $_REQUEST['CONFIG_SRCH_UPD_id']; $CONFIG_SRCH_UPD_arr_config = array(4 => array("ATTENDANCE_CONFIGURATION", "AC_DATA"), 5 => array("PROJECT_CONFIGURATION", "PC_DATA"), 2 => array("REPORT_CONFIGURATION", "RC_DATA"), 3 => array("USER_RIGHTS_CONFIGURATION", "URC_DATA")); $sql1 = "SELECT " . $CONFIG_SRCH_UPD_arr_config[$flag][1] . " FROM " . $CONFIG_SRCH_UPD_arr_config[$flag][0] . " CCN WHERE CCN.CGN_ID=(SELECT C.CGN_ID FROM CONFIGURATION C WHERE C.CGN_ID='{$CONFIG_SRCH_UPD_type}') AND " . $CONFIG_SRCH_UPD_arr_config[$flag][1] . "='{$CONFIG_SRCH_UPD_data}'"; $CONFIG_SRCH_UPD_type1 = mysqli_query($con, $sql1); $CONFIG_SRCH_UPD_save = 0; //SERVICE $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'); $authUrl = $drive->createAuthUrl(); $refresh_token = $Refresh_Token; $drive->refreshToken($refresh_token); $service = new Google_Service_Drive($drive);
function URSRC_calendar_create($loggin, $fileId, $loginid_name, $URSC_uld_id, $finaldate, $calenderid, $status, $form, $filesarray, $URSRC_firstname, $URSRC_lastname, $folderid) { global $con, $ClientId, $ClientSecret, $RedirectUri, $DriveScopes, $CalenderScopes, $Refresh_Token; $drive = new Google_Client(); $Client = get_servicedata(); $ClientId = "651424197810-72ki9kr1k58v3qec0034q1bfj2og6ss8.apps.googleusercontent.com"; //$Client[0]; $ClientSecret = "NRY1PYuUK-NeJAZVJxUvXBeb"; //$Client[1]; $RedirectUri = "https://developers.google.com/oauthplayground"; //$Client[2]; $DriveScopes = "https://www.googleapis.com/auth/drive"; //$Client[3]; $CalenderScopes = "https://www.googleapis.com/auth/calendar"; //$Client[4]; $Refresh_Token = "1/YkIO518mEEVO9z5bdieivdpf9XVBnZN4PWZPLStyGzk"; //$Client[5]; $drive->setClientId($ClientId); $drive->setClientSecret($ClientSecret); $drive->setRedirectUri($RedirectUri); $drive->setScopes(array($DriveScopes, $CalenderScopes)); $drive->setAccessType('online'); $authUrl = $drive->createAuthUrl(); $refresh_token = $Refresh_Token; $drive->refreshToken($refresh_token); $service = new Google_Service_Drive($drive); // print_r($service); if ($form == 'TERMINATE') { $file_arraycount = 1; try { $permissions = $service->permissions->listPermissions($fileId); $return_value = $permissions->getItems(); } catch (Exception $e) { $ss_flag = 0; } foreach ($return_value as $key => $value) { if ($value->emailAddress == $loggin) { $permission_id = $value->id; } } if ($permission_id != '') { try { $service->permissions->delete($fileId, $permission_id); $ss_flag = 1; } catch (Exception $e) { $ss_flag = 0; } } else { $ss_flag = 1; } } else { $value = $loggin; $type = 'user'; $role = 'reader'; $email = $loggin; $newPermission = new Google_Service_Drive_Permission(); $newPermission->setValue($value); $newPermission->setType($type); $newPermission->setRole($role); $newPermission->setEmailAddress($email); try { $service->permissions->insert($fileId, $newPermission); $ss_flag = 1; } catch (Exception $e) { $ss_flag = 0; } if ($ss_flag == 1) { if ($filesarray != '') { $file_array = array(); $allfilearray = explode(",", $filesarray); foreach ($allfilearray as $value) { $uploadfilename = $value; $drivefilename = $URSRC_firstname . ' ' . $URSRC_lastname . '-' . $uploadfilename; $extension = explode(".", $uploadfilename); if ($extension[1] == 'pdf') { $mimeType = 'application/pdf'; } if ($extension[1] == 'jpg') { $mimeType = 'image/jpeg'; } if ($extension[1] == 'png') { $mimeType = 'image/png'; } $file_id_value = insertFile($service, $drivefilename, 'PersonalDetails', $folderid, $mimeType, $uploadfilename); if ($file_id_value != '') { array_push($file_array, $file_id_value); } } $file_arraycount = count($file_array); } else { $file_arraycount = 1; } } } if ($ss_flag == 1 && $file_arraycount > 0) { $cal = new Google_Service_Calendar($drive); $event = new Google_Service_Calendar_Event(); $event->setsummary($loginid_name . ' ' . $status); $event->setDescription($URSC_uld_id); $start = new Google_Service_Calendar_EventDateTime(); $start->setDate($finaldate); //setDate('2014-11-18'); $event->setStart($start); $event->setEnd($start); try { $createdEvent = $cal->events->insert($calenderid, $event); $cal_flag = 1; } catch (Exception $e) { $cal_flag = 0; } } $flag_array = [$ss_flag, $cal_flag, $file_id_value, $file_array]; return $flag_array; }