Search found 410 matches

by pböttcher
2019-05-25 17:47
Forum: Advanced Customizations > Hooks
Topic: create a printable timesheet
Replies: 2
Views: 26

Re: create a printable timesheet

Hi,

in you posted query you are missing the table(s) from which you want to get your data

your code:
as 'inf_trattamento_dati' from and AppuntamentiID=104

as 'inf_trattamento_dati' from "HERE YOU NEED TO HAVE THE TABLE(S) AND THE WHERE CLAUSE" and AppuntamentiID=104
by pböttcher
2019-05-24 21:22
Forum: Getting Started
Topic: Child Tables Settings
Replies: 6
Views: 120

Re: Child Tables Settings

Hi,

you can use

$j('#tab_TABLE-FIELD').parent().hide();

where TABLE = composition
and FIELD = the field that corresponds to the RM List

but you may need to check if the tab already exists before hiding it, as it is create afterwards.
by pböttcher
2019-05-23 21:33
Forum: Getting Started
Topic: Child Tables Settings
Replies: 6
Views: 120

Re: Child Tables Settings

Hi,

you can set this in AppGini in the table settings. At the lower part on the right side you see the parent/child settings, here you specify which child shall be displayed.
by pböttcher
2019-05-22 20:05
Forum: Advanced Customizations > Hooks
Topic: create a "read more" link in a field in table view
Replies: 4
Views: 76

Re: create a "read more" link in a field in table view

Hi,

can you make a sample "screenshot" of what you try to acheive? Do you want to add additional text and buttons for the read more?
by pböttcher
2019-05-17 11:20
Forum: Advanced Customizations > Hooks
Topic: calculate the "months" component of a person's age
Replies: 3
Views: 86

Re: calculate the "months" component of a person's age

Hi,

you may try

Code: Select all

var dob = get_date('data_nascita');
var today = new Date();
var age = (new Date(today-dob)).getFullYear()-1970;
var month=(new Date(today-dob)).getMonth();
by pböttcher
2019-05-17 11:02
Forum: Tips And Tricks
Topic: Hide field depending user group
Replies: 18
Views: 216

Re: Hide field depending user group

Hi, I tried it on my testsystem and it works. Can you please post the code exaclty as you have it in your hook file (with all spaces, tabs, etc.). And did you check of a user that is not in the administrador group (sorry to ask so stupid...). Also you could test for the user that is in the administr...
by pböttcher
2019-05-16 19:49
Forum: Tips And Tricks
Topic: Hide field depending user group
Replies: 18
Views: 216

Re: Hide field depending user group

Hi,

can you post what you have in your hook file
by pböttcher
2019-05-16 08:14
Forum: Getting Started
Topic: Edit Maintenance Mode Page
Replies: 2
Views: 123

Re: Edit Maintenance Mode Page

Hi,

have a look at

amin/incFunctions.php ->
function handle_maintenance($echo = false){
by pböttcher
2019-05-16 07:12
Forum: Tips And Tricks
Topic: Hide field depending user group
Replies: 18
Views: 216

Re: Hide field depending user group

Hi, try this: function Pagos_dv($selectedID, $memberInfo, &$html, &$args){ /* current user is not an administrador group? if($memberInfo['group'] != 'administrador'){ $html.=<<<EOC <script> \$j(function() { \$j('#checado').hide(); }) </script> EOC; } } In the funtction you need to access the $member...
by pböttcher
2019-05-15 06:49
Forum: Advanced Customizations > Hooks
Topic: calculate the "months" component of a person's age
Replies: 3
Views: 86

Re: calculate the "months" component of a person's age

Hi, you may try it like this: if(isset($_REQUEST['SelectedID'])){ $id = makeSafe($_REQUEST['SelectedID']); date_default_timezone_set('UTC'); $birth=sqlvalue("SELECT data_nascita from anagrafica_persone where pkey='{$id}'"); $date1 = new DateTime(); $date2 = new DateTime($birth); $interval = $date1->...
by pböttcher
2019-05-14 19:51
Forum: Getting Started
Topic: Lookup Field - Other Parent Record Data
Replies: 1
Views: 44

Re: Lookup Field - Other Parent Record Data

Hi,

if I get right what you try to acheive, you can do this through the advance lookup option. You can edit the predefined SQL to match your needs.
You need to keep key (mostly the id) as first element.
by pböttcher
2019-05-09 06:29
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 345

Re: Order by date if lookup field

Hi,

as you can see in your SQL you have an alias for the appuntamenti` table. Hence you need to reference the alias

appuntamenti` as appuntamenti1

so please try

$options->QueryOrder="order by appuntamenti1.data_appuntamento desc";
by pböttcher
2019-05-09 05:22
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 345

Re: Order by date if lookup field

Hi,

can you post the result if you put in

$options->QueryOrder="order by appuntamenti.data_appuntamento desc";

If there is an error, please post the error (screenshot help a lot :-) ).
by pböttcher
2019-05-08 21:05
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 345

Re: Order by date if lookup field

Hi, hmmm, what is the error message that you get. I tried it on my testsytem and it works fine. can you try $options->QueryOrder="order by `appointamenti`.`data_appuntamento` desc"; And please make sure to copy the exact code you use into the post. As in your post $ options -> QueryOrder = "order by...
by pböttcher
2019-05-08 17:50
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 345

Re: Order by date if lookup field

Hi,

ok, no worries to all :-)

please try

function consuntivo_eventi_incontri_init(&$options, $memberInfo, &$args){

$options->QueryOrder="order by appointments.data_appuntamento desc";

}
by pböttcher
2019-05-08 14:45
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 345

Re: Order by date if lookup field

Hi, not sure why you post something like @Jan: The 2nd proposal is not mine - and I'm afraid the 2nd will not work on lookup fields. I tested it and it works just fine! @fgazza You post from the "event_date" field of the "events" table [/b] then you update the query with $ options-> QueryOrder = "or...
by pböttcher
2019-05-07 20:26
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 345

Re: Order by date if lookup field

`Hi, you can try to set the order in the hooks/result_events.php function result_events_init(&$options, $memberInfo, &$args){ $options->QueryOrder="order by `events`.`result_events` desc"; } where events is the table for the lookup and result_events is the field (hope I got that right). Or if you ha...
by pböttcher
2019-05-06 21:29
Forum: Advanced Customizations > Others
Topic: Edit rights
Replies: 9
Views: 212

Re: Edit rights

oh, sorry, I guess I was to short in my answer. Try this select group_concat(membership_grouppermissions.tableName ORDER BY membership_grouppermissions.tableName SEPARATOR ', ') as tablename, membership_users.memberid FROM `membership_grouppermissions` left JOIN membership_users on membership_users....
by pböttcher
2019-05-06 05:10
Forum: Advanced Customizations > Others
Topic: Edit rights
Replies: 9
Views: 212

Re: Edit rights

use

AND membership_grouppermissions.tablename IN ('YOURTABLE_1') and membership_grouppermissions.tablename IN ('YOURTABLE_2')
by pböttcher
2019-05-05 08:18
Forum: Bugs/annoyances
Topic: start_session error
Replies: 11
Views: 196

Re: start_session error

Hi,

can you explain how you integerate the directorylinks.php in your app. From where are you calling the page?
by pböttcher
2019-05-04 20:02
Forum: Bugs/annoyances
Topic: Visualize and Add Icons not always displayed when viewed in a tab
Replies: 5
Views: 358

Re: Visualize and Add Icons not always displayed when viewed in a tab

Hi, I think this is a bug. I could reproduce it and if the select a value on the first lookup both icons (visualize and add)disapear as there is now window.resize happening in order to circumvent it I put in the hoosks/TABLENAME-dv.js script $j(function () { $j( document ).ajaxSuccess(function( even...
by pböttcher
2019-05-02 17:52
Forum: Advanced Customizations > Hooks
Topic: Getting Jquery to call Function In Hooks file
Replies: 7
Views: 392

Re: Getting Jquery to call Function In Hooks file

Nope, you would have to create some logic to handle the ajax call in combination with the after_update hook and all possible option that a user could do.
I would go for the other option.
by pböttcher
2019-05-02 17:50
Forum: Bugs/annoyances
Topic: start_session error
Replies: 11
Views: 196

Re: start_session error

Hi,

can you send the first few lines of your hooks/directorylinks.php. Are you including something in here?
by pböttcher
2019-05-01 20:54
Forum: Advanced Customizations > Hooks
Topic: Getting Jquery to call Function In Hooks file
Replies: 7
Views: 392

Re: Getting Jquery to call Function In Hooks file

Well the other option would be to use ajax. But this would always happen bevor the save has really executed, so this might not be what you want. You could initiate an ajax call once the user checks the checkbox and run your SQL, but what happens if the user does not store the data and aborts the edi...
by pböttcher
2019-05-01 18:05
Forum: Advanced Customizations > Hooks
Topic: Getting Jquery to call Function In Hooks file
Replies: 7
Views: 392

Re: Getting Jquery to call Function In Hooks file

Hi, you added a checkbox to the DV, but this checkbox is on the page only. It has no reference to the data you are submitting once you click on the save button. The idea with the checkbox was, that you add it in AppGini to you database and use it once you press save and get that value. i.e. you add ...