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.
[SOLVED] Pivot Calendar - Calendar Extended
- LPARO
- Posts: 153
- Joined: 03 Mar 2021, 18:01
- Name: Luiz Paro
- Location: Brasil, São Paulo
- Company Name: Luiz Paro Advogados
- Contact:
[SOLVED] Pivot Calendar - Calendar Extended
Last edited by LPARO on 10 Aug 2022, 17:59, edited 1 time in total.
Re: Pivot Calendar - Calendar Extended
maybe the way will help viewtopic.php?f=23&t=3791
- LPARO
- Posts: 153
- Joined: 03 Mar 2021, 18:01
- Name: Luiz Paro
- Location: Brasil, São Paulo
- Company Name: Luiz Paro Advogados
- Contact:
Re: Pivot Calendar - Calendar Extended
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
- Posts: 153
- Joined: 03 Mar 2021, 18:01
- Name: Luiz Paro
- Location: Brasil, São Paulo
- Company Name: Luiz Paro Advogados
- Contact:
Re: Pivot Calendar - Calendar Extended
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:
On line 100 I made this change:
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
- Site Admin
- Posts: 6242
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Pivot Calendar - Calendar Extended
@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.
File from archive need to replace in plugins\ext\modules\pivot_calendars\actions\
This fix will be included in 3.3 version.
- Attachments
-
- entities.zip
- (1.59 KiB) Downloaded 45 times