$loginid_name = strtoupper(substr($loginid_name, 0, strpos($loginid_name, '.'))); } else{ $loginid_name=$loginid_name; } $uld_id=mysqli_query($con,"select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='$loginid'"); while($row=mysqli_fetch_array($uld_id)){ $URSC_uld_id=$row["ULD_ID"]; } $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"]; } $fileId=$ss_fileid; $return_array=URSRC_calendar_create($loginid,$fileId,$emp_name,$URSC_uld_id,$enddate,$calenderid,'TERMINATE DATE','TERMINATE','','','',''); $ss_flag=$return_array[0]; $cal_flag=$return_array[1]; if($ss_flag==0){ $con->rollback(); } if($cal_flag==0){ share_document($loginid,$fileId); $con->rollback(); } $flag_array=[$flag,$ss_flag,$cal_flag,$fileId]; } else{ $flag_array=[$flag]; } $con->commit();
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; }