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