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;
}
