[SOLVED] Pivot Calendar - Calendar Extended

[LPARO]

I'm trying to configure a pivot type report, however, I'm having a problem.

The "pivot calendar" report does not work with the "extended calendar" type field, because when I try to configure the "Calendar Report" it does not allow me to select "start date" and "end date" that are "extended calendar" type, when clicking on the arrow to select fields, no information appears.

I don't know if this is a bug or if it's intentional.

[brave]

maybe the way will help viewtopic.php?f=23&t=3791

[LPARO]

maybe the way will help viewtopic.php?f=23&t=3791

Hello Brave, thanks for the feedback.

I applied the fix you indicated, but the bug persists.

Would you have any other suggestions?

Thanks in advance!

[LPARO]

Dear Sergey,

After some attempts to resolve the issue, I made a small change in the code (in the /plugins/ext/modules/pivot_calendars/actions/entities.php folder), adding 'fieldtype_input_date_extra' in the strings $start_date_fields and $end_date_fields

Apparently it's working.

I submit it to your analysis to verify that it will not cause any interference in the application, behold, I am not a programmer.

On line 84 I made this change:

Code: Select all

$start_date_fields = array();
$fields_query = db_query("select * from app_fields where type in ('fieldtype_input_date','fieldtype_input_date_extra','fieldtype_input_datetime','fieldtype_dynamic_date') and entities_id='" . db_input($entities_id) . "' order by sort_order, name" );
while($fields = db_fetch_array($fields_query))

On line 100 I made this change:

Code: Select all

$end_date_fields = array();
$fields_query = db_query("select * from app_fields where type in ('fieldtype_input_date','fieldtype_input_date_extra','fieldtype_input_datetime','fieldtype_dynamic_date') and entities_id='" . db_input($entities_id) . "' order by sort_order, name" );
while($fields = db_fetch_array($fields_query))

[support]

@LPARO you are right. Just provide full file with fix.

File from archive need to replace in plugins\ext\modules\pivot_calendars\actions\

This fix will be included in 3.3 version.