Search found 31 matches

by fbrano
2019-03-04 14:16
Forum: Advanced Customizations > Hooks
Topic: Quick way to customize the yourtablename.fieldname.csv file
Replies: 2
Views: 1541

Re: Quick way to customize the yourtablename.fieldname.csv file

Where is problem in my code, when I want conditionally modify content of choices in field: When existing record is open for modification in DV, list of options does not change according value in `Stav_pristupu` When new record is added also I have to set value of list options to one choice = "ziadan...
by fbrano
2019-03-01 10:19
Forum: Tips And Tricks
Topic: Update a groupID for several distinct users selected from column of other table
Replies: 1
Views: 119

Update a groupID for several distinct users selected from column of other table

Hi, I'd like to do an update of field groupID in table membership_users for selection of users from other table where they are selected by command: SELECT DISTINCT Schvalovatel1 FROM `role`, my question is how to write an update command correctly: UPDATE `membership_users` SET `groupID` = 5 WHERE `c...
by fbrano
2019-02-28 10:37
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

This works fine: $memberinfo = getMemberInfo(); sql("update `Systemy` set `Vlastnik`= '{$memberinfo['custom'][1]}' where ID in ({$cs_ids})",$eo); but I'd like to replace value in field Vlastnik on all selected rows in db Systemy with superodinate of Vlastnik found in db Pouzivatelia in field Manazer...
by fbrano
2018-10-17 09:45
Forum: Tips And Tricks
Topic: Switching the rolle in AppGini Application
Replies: 5
Views: 929

Re: Switching the rolle in AppGini Application

This code solved modification only curent user's group: <?php $curr_dir = dirname(__FILE__); include("{$curr_dir}/defaultLang.php"); include("{$curr_dir}/language.php"); include("{$curr_dir}/lib.php"); $group = $_REQUEST['Group']; $memberinfo = getMemberInfo(); sqlvalue("UPDATE membership_users set ...
by fbrano
2018-10-17 08:43
Forum: Tips And Tricks
Topic: Switching the rolle in AppGini Application
Replies: 5
Views: 929

Re: Switching the rolle in AppGini Application

Reason of crussing application is in modification values in table membership_users groupID
by fbrano
2018-10-17 06:49
Forum: Tips And Tricks
Topic: Switching the rolle in AppGini Application
Replies: 5
Views: 929

Re: Switching the rolle in AppGini Application

After I test to switch user group privilegs acording switched group did not changed. After all when I log out I got this error... ( ! ) Fatal error: Maximum function nesting level of '256' reached, aborting! in C:\wamp\www\elp\settings-manager.php on line 111 Call Stack # Time Memory Function Locati...
by fbrano
2018-09-26 21:31
Forum: Feature Suggestions
Topic: Switching the rolle in AppGini Application
Replies: 4
Views: 679

Re: Switching the rolle in AppGini Application

I'd like to have ability for user to switch between groups according the role they stand for, for example requester and approver in one person. It also can be solved to allow user registration in several groups according his role in application. Thank you for putting it on to-do list.
by fbrano
2018-09-24 17:08
Forum: Feature Suggestions
Topic: Switching the rolle in AppGini Application
Replies: 4
Views: 679

Switching the rolle in AppGini Application

It would be nice to have feature as switching the rolle of logged in user in application.
by fbrano
2018-09-19 06:45
Forum: Advanced Customizations > Others
Topic: Filter with date functions
Replies: 8
Views: 1990

Re: Filter with date functions

This Works: $j(function() { var d = new Date(); // formatted date .. change order and separator to the ones you selected in your AppGini project // in the below line, the format is month/day/year var formattedDate = (d.getDate()) + '.' + (d.getMonth()+1) + '.' + d.getFullYear(); // now build the 4 p...
by fbrano
2018-09-07 11:35
Forum: Advanced Customizations > Others
Topic: Filter with date functions
Replies: 8
Views: 1990

Re: Filter with date functions

In my project it works this way: $j(function() { var date = new Date(); date.setDate(date.getDate()); // formatted date .. change order and separator to the ones you selected in your AppGini project // in the below line, the format is month/day/year var formattedDate = (date.getDay()+2) + '.' + (dat...
by fbrano
2018-09-06 16:06
Forum: Tips And Tricks
Topic: Authenticate against Microsoft Directory (LDAP)
Replies: 10
Views: 1730

Re: Authenticate against Microsoft Directory (LDAP)

Let me explain it, I do not want to remove it only hide it and of course not from sign in page but from sign up page.

I do not think that new user account in AppGini application is checked in LDAP during sign up process.
by fbrano
2018-08-22 11:37
Forum: Tips And Tricks
Topic: Authenticate against Microsoft Directory (LDAP)
Replies: 10
Views: 1730

Re: Authenticate against Microsoft Directory (LDAP)

I'd like to know your thinking on this. Is it possible to modify sign up dialog to remove password field, because it is confusing to check password complex to minimum 4 characters when it is not applicable during LDAP authentication? How to force user to use his AD account as username? I came uppon ...
by fbrano
2018-08-21 11:59
Forum: Tips And Tricks
Topic: Authenticate against Microsoft Directory (LDAP)
Replies: 10
Views: 1730

Re: Authenticate against Microsoft Directory (LDAP)

LDAP authentication works, thank you.

Now I have to fill up membership_users db with all active directory accounts. Will I have to generate random passwords for imported AD users while appgini application has minimun 4 characters password condition when new user is created?
by fbrano
2018-08-21 07:51
Forum: Getting Started
Topic: Access Admin Area
Replies: 7
Views: 1962

Re: Access Admin Area

Any news in adding another SUPER admin?
by fbrano
2018-08-21 06:08
Forum: Tips And Tricks
Topic: Authenticate against Microsoft Directory (LDAP)
Replies: 10
Views: 1730

Re: Authenticate against Microsoft Directory (LDAP)

Only with 'DOMAIN\login name' I got successful result.
by fbrano
2018-08-03 21:48
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

One note how browsers behaved, chrome updated page automaticaly, but IE requested to click on OK in confirmation window.
by fbrano
2018-08-03 05:39
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

Many thanks for your patience with me ;) it is exactly what I was looking for
by fbrano
2018-08-02 12:51
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

With systax '{$memberinfo['custom'][1]}' I got expected value, but in this form '{$memberinfo['custom1']}' there is no output. What to add to code and where to add it as I want to refresh page after finishing batch action to be able to see updated fields automaticaly not only manualy via F5 in brows...
by fbrano
2018-08-02 05:21
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

Many thanks it works with this syntax: /* retrieve the records and display mail labels */ $res = sql( "select * from Pristupy where ID in ({$cs_ids})", $eo); $memberinfo = getMemberInfo(); sql("update `Pristupy` set `Revidoval`= '{$memberinfo['custom'][1]}' where ID in ({$cs_ids})",$eo); sql("update...
by fbrano
2018-08-02 04:53
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

Adding $memberinfo = getMemberInfo(); in mail_labels.php file do not solved task. Is there way how to do it directly in function file table-tv.js without calling mail_labels.php? I do not need output a separate page, only refresh table view after update fields 'Revised' and 'Date_of_revision' btw up...
by fbrano
2018-08-01 12:53
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

My last experience put the update before while command works for selected records it can update date of revision but can not update information about logged user from memberinfo array, any idea? /* retrieve the records and display mail labels */ $res = sql( "select * from Pristupy where ID in ({$cs_...
by fbrano
2018-08-01 07:49
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

This works, but it updates all records not only selected: sql("update `Pristupy` set `Revidoval`= '12345678'",$eo);
by fbrano
2018-08-01 06:07
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

I used example with print-labels, but add sql update for certain field, which I need to be filled up with logged user ID stroed in custom[1] field in $memberInfo database, here is code: <?php /* Including the following files allows us to use many shortcut functions provided by AppGini. Here, we'll b...
by fbrano
2018-07-28 16:36
Forum: Advanced Customizations > Others
Topic: More batch actions with global variables
Replies: 15
Views: 1309

Re: More batch actions with global variables

Sure, I did label print example, but I have to figure out how to update certain field in the range of selected records with login of actual user.