Search found 20 matches

by kerelov
2021-04-25 05:21
Forum: Bugs/annoyances
Topic: MYSQL syntax error with filters after the bug fix for QueryWhere in v5.95
Replies: 5
Views: 1744

Re: MYSQL syntax error with filters after the bug fix for QueryWhere in v5.95

So the easiest to reproduce is to have a table (for example table with name "notes") where you give full permission to admins group (insert, view for all, edit for all, delete for all) and a second group for example clients which have access to the same table with group level (insert, view for group...
by kerelov
2021-04-22 08:04
Forum: Bugs/annoyances
Topic: homeLinks[] and navLinks[] not working after update to 5.95
Replies: 1
Views: 216

Re: homeLinks[] and navLinks[] not working after update to 5.95

This issue is also connected to group permissions like the filters issue with QueryWhere. When you give all groups permission to homeLinks and navLinks using

Code: Select all

'groups' => array('*'),
all links appear again.
by kerelov
2021-04-22 07:17
Forum: Bugs/annoyances
Topic: homeLinks[] and navLinks[] not working after update to 5.95
Replies: 1
Views: 216

homeLinks[] and navLinks[] not working after update to 5.95

On both apps that I have after the 5.95 update homeLinks[] and navLinks[] stopped working. It looks like those arrays are not parsed at all. I'm considering a jQuery implementation in the extras files to bring back my links.
by kerelov
2021-04-14 09:04
Forum: Bugs/annoyances
Topic: MYSQL syntax error with filters after the bug fix for QueryWhere in v5.95
Replies: 5
Views: 1744

MYSQL syntax error with filters after the bug fix for QueryWhere in v5.95

After upgrading from 5.94 to 5.95 in one of my apps where I use users with only group access I receive MYSQL syntax errors in all tables when I try to use default filter, custom filter or initial filter. I've edited datalist.php with the code from v5.94 (https://forums.appgini.com/phpbb/viewtopic.ph...
by kerelov
2021-03-06 16:58
Forum: AppGini Plugins
Topic: To Do List plugin
Replies: 28
Views: 4087

Re: To Do List plugin

Hi,
I have a problem with the tasks saving.
In the moment that the To Do List window is closed all tasks just vanish and the list is empty.
The same happens when I change page navigate in my app.
by kerelov
2020-12-30 11:26
Forum: Advanced Customizations > Others
Topic: Kool PHP and Appgini integration
Replies: 1
Views: 482

Re: Kool PHP and Appgini integration

For now I have found a better solution using iframe. This allows me to use the native Apgini header. Not the best but it is ok.
by kerelov
2020-12-28 16:33
Forum: Advanced Customizations > Others
Topic: Kool PHP and Appgini integration
Replies: 1
Views: 482

Kool PHP and Appgini integration

Hi Appginers, I have the following problem: I need to integrate KoolPHP report into the AppGini project. I've done everything and the report is ready to use but I have anoying problem with jquery and prototype declarations in header.php file of AppGini. There is some kind of conflict between Koolrep...
by kerelov
2020-11-09 08:16
Forum: Bugs/annoyances
Topic: Appgini 5.9 Filter issue
Replies: 4
Views: 672

Re: Appgini 5.9 Filter issue

Same problem here, default filters only work with admin users. Problem is still unsolved in version 5.91
by kerelov
2020-07-30 12:01
Forum: Advanced Customizations > Hooks
Topic: Filter a drop down with parameter obtained with Ajax
Replies: 2
Views: 1470

Re: Filter a drop down with parameter obtained with Ajax

Guys, I have finally figure it out. $j('#debit_account-container').on('change', function(e){ var account_id = e.added.id; //console.log(account_id); if(account_id == '<Нищо>'){ $j('#nomenclature_debit').val(''); }else{ $j.ajax({ url: 'hooks/ajax-nomenclature-type.php', data: { account_id: account_id...
by kerelov
2020-07-27 08:30
Forum: Advanced Customizations > Hooks
Topic: Filter a drop down with parameter obtained with Ajax
Replies: 2
Views: 1470

Filter a drop down with parameter obtained with Ajax

Hi Guys, I can't manage to make a correct jQuery select2 script that can filter a drop down based on a user choice from previous drop down and an additional filter parameter obtained by ajax request from another table. Actually I just only need to use the second filter parameter (ID), obtained with ...
by kerelov
2020-07-01 15:13
Forum: Tips And Tricks
Topic: Group and User Permissions
Replies: 1
Views: 1918

Re: Group and User Permissions

This works perfectly. Thank you! Do you have something for user permissions too?
by kerelov
2020-05-26 11:00
Forum: Feature Suggestions
Topic: Chat box
Replies: 12
Views: 6617

Re: Chat box

Can you post your solution for the "shout box"?
by kerelov
2020-05-19 10:53
Forum: Tips And Tricks
Topic: Calculated fields Cyrillic characters problem
Replies: 5
Views: 984

Re: Calculated fields Cyrillic characters problem

Well, I did it kind of like that. I created a new table service_fields with just two columns - bg and en - for the two languages. And now the SQL looks like this: SELECT ROUND ( IF (`tasks`.`free` = 1, 0, IF (`tasks`.`charge_type` = `service_fields`.`bg` AND `service_fields`.`en` = 'Fixed', `task_ty...
by kerelov
2020-05-19 08:06
Forum: Tips And Tricks
Topic: Calculated fields Cyrillic characters problem
Replies: 5
Views: 984

Re: Calculated fields Cyrillic characters problem

This is the SQL, it works fine when using English for example `tasks`.`charge_type` = 'Per Hour'. When I change 'Per Hour' with 'На Час', it does not work. `tasks`.`charge_type` is a simple list defined in Appgini like: Per Hour;;Fixed;;Combined. When I defined it as На час;;Фиксирана;;Комбинирана a...
by kerelov
2020-05-11 16:59
Forum: Tips And Tricks
Topic: Calculated fields Cyrillic characters problem
Replies: 5
Views: 984

Calculated fields Cyrillic characters problem

Hi Guys, I have the following problem: When I have a compression in the calculated field (`tasks`.`value`) in Appgini with a word with cyrillic characters (example `tasks`.`charge_type` = 'Фиксирана') the query fails. The field `charge_type` is a simple list defined also in Appgini like this: Фиксир...
by kerelov
2020-04-23 19:10
Forum: Tips And Tricks
Topic: apply a custom quey in lookup field only if groups is not admin or superuser
Replies: 4
Views: 848

Re: apply a custom quey in lookup field only if groups is not admin or superuser

Hi, Why don’t you try the following strategy: Create 2 lookup fields. In the first one place the original SQL you posted and in the second one place the SQL with the additional `appuntamenti`.`attivo` = '1' . Now you can add in footer-extras.php a php code that checks for session variable of the use...
by kerelov
2020-04-23 10:03
Forum: Tips And Tricks
Topic: Show file in another table
Replies: 0
Views: 2122

Show file in another table

So I have an app where all the documents are uploaded in one specific table called 'documents'. Later these documents could be attached to other tables related to different topics and it is possible for one document be attached to different topics. This is good to avoid uploading one document severa...
by kerelov
2020-04-22 17:55
Forum: Advanced Customizations > Hooks
Topic: Filter for Multi-select by SelectedID
Replies: 0
Views: 2139

Filter for Multi-select by SelectedID

Hi guys, This topic about the multi-select lookup fields was very helpful: https://bigprof.com/blog/appgini/a-work-around-to-implement-a-multiple-choice-lookup-field-in-your-appgini-apps/ With just a slight change it works nice to filter by the SelectedID or any other field in DV: You just need to c...