mantisbt-plugins / calendar

Adds the task scheduling function in MantisBT based on the calendar of events with the possibility of one-way synchronization with Google Calendar.

MantisBT Calendar Plugin

Overview

Adds the task scheduling function in MantisBT based on the calendar of events with the possibility of one-way synchronization with Google Calendar.

Screenshots

Features

• The ability to create event.
• Binding any number of bugs to event.
• Bug can be related to any number of events.
• Visual display of events in bugs view page.
• One-way synchronization with Google Calendar (v. >= 2.3.0)
• Support for different time zones.
• Recurring events(v. >= 2.4.0-dev).

Download

Please download the stable version. (https://github.com/mantisbt-plugins/Calendar/releases/latest)

How to install

1. Copy Calendar folder into plugins folder.
2. Open Mantis with browser.
3. Log in as administrator.
4. Go to Manage -> Manage Plugins.
5. Find Calendar in the list.
6. Click Install.

How to enabled Google Calendar Sync (for Calendar version >= 2.3.0 )

1. Go to Google Developers Console and create the new project.
2. Download JSON file.
3. Upload the JSON file on the Calendar settings page.
4. Click the save button.
5. Go to the calendar settings for a specific user and click "Enable sync with Google Calendar"
6. Give permission to manage your calendars Google.
7. Select a calendar for one-way synchronization with Google Calendar.

Detailed instructions are provided in the project wiki. https://github.com/mantisbt-plugins/Calendar/wiki#how-to-enabled-google-calendar-sync

Supported Versions

• MantisBT 2.14 and higher - supported

calendar's Issues

DEPRECATED: 'Return type of RRule\RRule::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice

Hi Thanks for the plugin. But i am getting errors at every page after i have installed it. Do you know how to remove this error? Because i cant click on the View Issues button for example, probably because the error list is very long.
Thank you.

PHP 8.1.12
Mantis 2.25.5
Calendar 2.6.1

DEPRECATED: 'Return type of RRule\RRule::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice' in 'D:\nginx\html\mantisbt\plugins\Calendar\api\php-rrule-1.6.1\src\RRule.php' line 1033
DEPRECATED: 'Return type of RRule\RRule::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice' in 'D:\nginx\html\mantisbt\plugins\Calendar\api\php-rrule-1.6.1\src\RRule.php' line 1025
DEPRECATED: 'Return type of RRule\RRule::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice' in 'D:\nginx\html\mantisbt\plugins\Calendar\api\php-rrule-1.6.1\src\RRule.php' line 1042
DEPRECATED: 'Return type of RRule\RRule::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice' in 'D:\nginx\html\mantisbt\plugins\Calendar\api\php-rrule-1.6.1\src\RRule.php' line 1008
DEPRECATED: 'Return type of RRule\RRule::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice' in 'D:\nginx\html\mantisbt\plugins\Calendar\api\php-rrule-1.6.1\src\RRule.php' line 1053
DEPRECATED: 'Return type of RRule\RRule::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice' in 'D:\nginx\html\mantisbt\plugins\Calendar\api\php-rrule-1.6.1\src\RRule.php' line 1061
DEPRECATED: 'Return type of RRule\RRule::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice' in 'D:\nginx\html\mantisbt\plugins\Calendar\api\php-rrule-1.6.1\src\RRule.php' line 1093

Calendar Fatal error: Call to undefined function print_column_time()

I'm facing a problem with Calendar plugin.
After the installation of the plugin i am getting [Fatal error: Call to undefined function print_column_time() ]
plugins\Calendar\pages\calendar_user_page.php on line 99

MantisBT Version: 2.18.0

Any help with this issue??

Add Chinese language

From user request:

I found MantisBT Calendar Plugin don't support Chinese language，so I translate the file to help who want Chinese language.
PS：if you set Chinese language，you should change Calendar\files\Calendar.css【 td.column-time-td】,set the width more than 100.

Calendar not working

Hi, I have installed the calendar plug in ''Avatars via Gravatar 2.18.0'' my OS is Ubuntu , and the mantis db is 2.18.0, do you have any recommendation, to fix this, or something to chek.

Regards

The date of the event does not work at creation.

Because of this, the event is almost impossible to find, since it is too deep in time.

Events remaining after issue is closed

Events linked to issues, remain in calendar when the issue is closed, The spected behaviour should be delete related events once the issue is closed. If not, developers have to update calendar manually for already configured events, and it looses all its utility for untenable manteinance reasons.

Problems with installation

Hello !

i trying to install Calendar Plugin v 2.6 on mantis v 2.23.0 / shema version 210 / postgres v11.4.
On the Adminview - Plugins it means i need a Updgrade (required mantis v 2.14).

By pressing Upgrade it shows an ERROR #2503 in Block #0 .

Whats wrong ? I activated logging, but cant see nothing..
And Calendar is not working.

Thanks !

Event status

The event must have some status.
After that, you can delete the cell.

Bug Creation

Hi again.

There is some way to create new incidences with the Calendar Event? I mean instead of relate a bug to a event, for each day the event is repeated create a new incidence.

Thanks in advance.

Incorrect integer value: '' for column 'date_changed' at row 1

APPLICATION ERROR #401

数据库查询失败。数据库返回的错误信息是：#1366: Incorrect integer value: '' for column 'date_changed' at row 1 查询语句：INSERT INTO mantis_plugin_Calendar_events_table
( project_id, name,
activity, author_id, date_changed,
changed_user_id, date_from, date_to,
duration, recurrence_pattern, parent_id
)
VALUES
( ?,?,
?,?,?,
?,?,?,
?,?,?)

Allow to change other settings of the plug-in through the menu "Management"

В основном это касается переменных связанных со временем.
Дополнительно необходимо костомизировать настройки под каждого пользователя/проект.

It is necessary to solve the problem with the display of overlapping events on the main view.

Feature Request: It is not possible to add an event which is 2 or more days long.

Would it be possible to consider implementing this? Holidays for example do not take 1 day generally.

List for exceptions / inclusions of dates

For a more gradual formation of the list of dates, it is necessary to take into account holidays.

Добавить возможность выбора рабочего диапазона и количества дней для отображения для каждого пользователя по отдельности.

Персонализировать события

Необходимо добавить возможность добавлять участников события.

Соответственно необходимо проработать главный вид календаря чтобы можно было фильтровать события по пользователям.

Clicking 'Current week' button takes user to previous week

When I click on 'Current week' button, it takes me to the previous week instead of the actual current week.

Is this repository maintained anymore?

I consider using this plugin in production, but I see that there was no recent activity. Is it safe to use this plugin on a production site?

Event Viewer

Hello,
It seems that when I open the Event Viewer of an event already scheduled in the calendar, the following Warning message appears on the 'update_bug_button' and 'delete_bug_button' buttons:
APPLICATION WARNING #300: String "update_bug_button" not found. (in '/var/www/html/plugins/Calendar/pages/view.php' line 100)
APPLICATION WARNING #300: String "delete_bug_button" not found. (in '/var/www/html/plugins/Calendar/pages/view.php' line 101)

Why is this? It seems that the buttons are not loading correctly, or if these are the buttons, how can I remove the Warning messages?

Thanks in advance!

Do not allow users to synchronize the event with Google.

Calander not displaying correctly

I have installed the calendar using the installation guide, but it is not showing as the images with the events in boxes and times and dates. We are not linking this to google would this cause an issue?

Calendar of Events 2.6.0 is the version being used
MantisBT Core 2.24.2

Thanks

The server denied the request. Error: Invalid code

Hello, I meet error when I doing step 12 (sync google calendar).
I input: 'http://YOU_DOMAIN_HOSTED_MANTISBT/plugin.php?page=Calendar/user_config_google', but it say can't redirect.

In addition, can Calendar plugins combine with Reminder plugins?
Thank you!

A MultiProject Calendar

Hi,

First, thanks for the plugin!

Possible to add choise ,in settings, if we want one calendar per project or one calendar for every projects?
To be able to add to the same event differents bugs for differents projects (they are linked and must be done at the same event)

Many Thanks
Regards

Mat

Send outlook ical event once add event in Calendar plugin

Hi,

Is there a way to send outlook ical event once added event in Calendar plugin ?

Failed to parse time string

This bug is caused by an incorrect data type in the recurrence_pattern column.
Need to change to MEDIUMTEXT.

Add the translation into Spanish.

Translation courtesy of Andres Felipe Galeano Botero [email protected]

The end time of the event does not change.

It is not possible to change the end time of an event in an already created event.

Add a https connection check to the current mantisbt installation.

It is necessary in order not to mislead the user to the possibility of setting up synchronization with Google.

Are you sure you want to delete this event? SYSTEM ERROR

SYSTEM ERROR

'Argument 1 passed to event_google_get_id() must be an instance of int, integer given, called in /var/www/html/plugins/Calendar/core/calendar_google_api.php on line 216 and defined' in '/var/www/html/plugins/Calendar/core/calendar_google_api.php' line 248

Errors when trying to install plugin

We have done a new clean install of mantis bt but using MS SQL server this time. But when trying to install the calender we get the following errors.

APPLICATION ERROR #2503

Upgrading the plugin schema failed at step #4. Error "SQLState: 42000
Error Code: 156
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'DROP'.
SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'date_event'.
SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'hour_start'.
SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'minutes_start'.
SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'hour_finish'.
SQLState: 42000
Error Code: 102
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'minutes_finish'.
" occurred while executing the following statement(s):
ALTER TABLE mantis_plugin_Calendar_events_table DROP COLUMN tasks, DROP COLUMN date_event, DROP COLUMN hour_start, DROP COLUMN minutes_start, DROP COLUMN hour_finish, DROP COLUMN minutes_finish

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Version Info

Enhancement requests

I'd like to propose a few requests that may greatly improve this already amazing plugin. These come from our continued use of the plugin.

1. Monthly Calendar View: View the events by month in addition to weekly view
2. Event List: View events as a list with a column showing their scheduled dates and duration
3. Notifications: Show event notifications on the Activities Section e.g. 'Admin created a new event Number 00004'

Edit Event Buttons are missing!

PHP 8.1.12
Mantis 2.25.5
Calendar 2.6.1

Hi
when i click on the event, i guess Edit Event View Page is shown but i cannot edit anything. i see also that some buttons are not available.
Any suggestions?
Thanks

Cant add users to an event

PHP 8.1.12
Mantis 2.25.5
Calendar 2.6.1

Add instructions on connecting the google sync.

You need to do this because users are having trouble configuring on the google side.

Add email notifications

Расширить диапазон доступного времени при создании события.

When creating an event, the task list is not generated correctly.

You should clean the filter before forming the list of bugs.

Is it possible to reduce the time intervals?

1. When the name of the event contains Cyrillic characters - an error.

2. Is it possible to reduce the time intervals?
   For example, 14:00-15:00, 15:00-16:00.

It is not possible to change the first instance of an event throughout the entire repetition chain.

When you change the first instance of a recurring event, changes occur without asking for the depth of the changes. Because of this, it is not possible to edit the first instance in the chain of events.

Error trying activate user Calendar

Hi, I have follow all step for installation, but when I'm on user calendar page, I click on "Enable sync with Google Calendar", I allow permission, but at the end, I give this error:

The server denied the request.
Error: Could not determine client ID from request

The strange thing is that the redirect uri after oauth permission is this: https://bug.bogny.eu/plugin.php?page=Calendar/user_config_google&state=%5B%22user_config_google%22%5D&code=4/AAA7m0ynV3KTzmkYzn_rBE5N39-AXpxK5IUbQDphxh60tp8je46c-RKXM4TqPfY0hCThz1LWS4moAxSBNHhDrOE#

Maybe the problem are caused by %5B%22 or %22%5D????? IDK

This is my uploaded json file:

                                    Array
(
    [client_id] => 1234567890-ASDASDASDASDASDASD.apps.googleusercontent.com
    [project_id] => bogny-eu
    [auth_uri] => https://accounts.google.com/o/oauth2/auth
    [token_uri] => https://accounts.google.com/o/oauth2/token
    [auth_provider_x509_cert_url] => https://www.googleapis.com/oauth2/v1/certs
    [redirect_uris] => Array
        (
            [0] => https://bug.bogny.eu/plugin.php?page=Calendar/user_config_google
        )
    [javascript_origins] => Array
        (
            [0] => https://bug.bogny.eu
        )
)

Thanks for any help!

Add the function of recurrent events.

problems when plugin folder is outside the main root folder

The following folder structure:

-- /var/www/html/MantisBT
-- /var/www/html/plugins

After installing the Calendar plugin and trying to add an event i get the following error message:

'include(/var/www/html/plugins/Calendar/pages/../../../bug_view_inc.php): failed to open stream: No such file or directory' in '/var/www/html/plugins/Calendar/pages/event_insert_page.php' line 87

I have tried to change line 87 to: include( $g_absolute_path . 'bug_view_inc.php' );

but that give me an other error:
'include(/var/www/html/plugins/Calendar/pages/../../../bugnote_view_inc.php): failed to open stream: No such file or directory' in '/var/www/html/mantis/bug_view_inc.php' line 790

Error when trying to go back previous weeks

When i try to go back a few weeks on the calendar page I get the following error

"'A non-numeric value encountered' in 'C:...plugins\Calendar\core\calendar_date_api.php' line 301

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section."

Steps to reproduce:

1. Go to 'Calendar'
2. Scroll to | Back | Current week | Next | navigation buttons and click on 'Back' multiple times then the error appears

Проверить как выглядит колонка "Время" при просмотре задачи

В firefox колонка сильно широкая

Add Logging

The selected calendar is not correctly saved.

If the user selects the first item in the list of his calendars and saves it, then afterwards it will be impossible to select another item in the list.

Public/private events.

By analogy with notes.