Search found 524 matches

by onoehring
2020-05-20 05:20
Forum: Getting Started
Topic: Do sqlValue and sql functions close/reuse connections?
Replies: 2
Views: 156

Re: Do sqlValue and sql functions close/reuse connections?

Hi,

thank you, I will try your suggestion.
Olaf
by onoehring
2020-05-19 09:24
Forum: Getting Started
Topic: Do sqlValue and sql functions close/reuse connections?
Replies: 2
Views: 156

Do sqlValue and sql functions close/reuse connections?

Hi, I got an error from the MySQL Server (on 1&1) that "user .... already has more than max_user_connections active connections". I make use of AppGini's SQL functions sql and sqlValue , so I am wondering, if they close their connection after the result has been received. Or - does AG create a singl...
by onoehring
2020-05-12 11:40
Forum: Advanced Customizations > Hooks
Topic: Color a row when sum of a field is 0
Replies: 1
Views: 212

Re: Color a row when sum of a field is 0

Hi,

check out my earlier question (and answers you find) here: viewtopic.php?f=2&t=3194&p=10855&hilit=color#p10855

Olaf
by onoehring
2020-05-11 13:12
Forum: AppGini Plugins
Topic: Reprts 3 - Pie Charts
Replies: 4
Views: 217

Re: Reprts 3 - Pie Charts

Hi,

sorry, I bought the add on, but have not used it. Maybe a bug?
Olaf
by onoehring
2020-05-04 13:14
Forum: Getting Started
Topic: Only 5 rows to show
Replies: 3
Views: 190

Re: Only 5 rows to show

Hi, check out this page: https://bigprof.com/appgini/help/advanced-topics/hooks/DataList-object but, you will not find queywhere there either. You can use the code on the bottom of the page to see all data options available - and there you will see querywhere. You should check (where pböthcer sugges...
by onoehring
2020-04-30 06:28
Forum: Bugs/annoyances
Topic: Data Format Bug
Replies: 15
Views: 2006

Re: Data Format Bug

Hi, just try to add to /hooks/tablename.php -> _before_update function a check for the field and replace all . to , and vice versa. Try something like this $your_field_name = number_format($your_field_name,2,",","."); or vice versa $your_field_name = number_format($your_field_name,2,".",","); Olaf
by onoehring
2020-04-29 15:24
Forum: Bugs/annoyances
Topic: Data Format Bug
Replies: 15
Views: 2006

Re: Data Format Bug

Hi,

either I read too quick, or you did not tell us: Have you set the correct data type in AppGini? For currency I would suggest decimal (integer can not hold any decimals).
ec_20200428_01.png
ec_20200428_01.png (10.69 KiB) Viewed 225 times
Olaf
by onoehring
2020-04-28 09:21
Forum: Getting Started
Topic: Cell Background color in Printout
Replies: 4
Views: 150

Re: Cell Background color in Printout

Hi,

try to define your own css class with the !important and include that:

Code: Select all

<th colspan = "4" class="YOURCLASS"><b>DELIVERY & PACKING DETAILS</b></th>
und

Code: Select all

YOURCLASS{text-align:center; background-color: #CCCCCC !important;}
Olaf
by onoehring
2020-04-28 08:21
Forum: AppGini Plugins
Topic: Reprts 3 - Pie Charts
Replies: 4
Views: 217

Re: Reprts 3 - Pie Charts

Hi,

and what is your question? Some more details will also be nice, maybe a screenshot of what you get and a description/mockup, of what you want to get.

Olaf
by onoehring
2020-04-28 08:19
Forum: Advanced Customizations > Hooks
Topic: Multiple companies using same app
Replies: 6
Views: 291

Re: Multiple companies using same app

Hi,

adding to pbötchers idea, you could set that department as session variable and add a link to that page to your navigation bar (/hooks/nav-...). This would enable people to switch departments while staying logged in.

Olaf
by onoehring
2020-04-28 08:18
Forum: Getting Started
Topic: Cell Background color in Printout
Replies: 4
Views: 150

Re: Cell Background color in Printout

Hi,

I suggest you define the CSS in an external stylesheet.
To have the background color in print, you need to add !important to the definition.
try:

Code: Select all

<th colspan = "4" style="text-align:center; background-color: #CCCCCC !important;"><b>DELIVERY & PACKING DETAILS</b></th>
Olaf
by onoehring
2020-04-27 05:58
Forum: Advanced Customizations > Hooks
Topic: Multiple companies using same app
Replies: 6
Views: 291

Re: Multiple companies using same app

Hi,

you are welcome. I meant to suggest to read the docs of my CVB :-)

Olaf
by onoehring
2020-04-26 07:20
Forum: Advanced Customizations > Hooks
Topic: Multiple companies using same app
Replies: 6
Views: 291

Re: Multiple companies using same app

Hi TD, I think you asked something similar the other day. Imho is does not matter from which department they log in. You should instead give the possibility to filter by department (display that in a column). Why I think it does not matter for what they log in? If they are attached to several depart...
by onoehring
2020-04-26 07:03
Forum: Advanced Customizations > Others
Topic: When child record updated as Completed, then corresponding parent records should not be Editable
Replies: 4
Views: 225

Re: When child record updated as Completed, then corresponding parent records should not be Editable

Hi, in hooks/child-tablename.php you can check in the _before_update function if field X from some table contains Y and the react on that. In your case: If status=completed then return false -> False will cancel the update process, thus making it impossible to change anything in the child record. Yo...
by onoehring
2020-04-24 07:39
Forum: Getting Started
Topic: Modifying login page
Replies: 10
Views: 315

Re: Modifying login page

Hi,

thanks for sharing.

Just a thought:
But: Why do you want the department id? This should be tied to the user in an internal table, so you can always look it up after the user has logged in.
Or: Simply use usergroupd and let people see only records from their group (e.g. department).

Olaf
by onoehring
2020-04-23 16:14
Forum: Getting Started
Topic: Modifying login page
Replies: 10
Views: 315

Re: Modifying login page

Hi, look in the /hooks/tablename.php -> _init function. There you can change the header for that table and for tableview, detailview etc. It's already in the function, you just need to add your own code to the specific switch-statement. Please note, the comment to this, that is: If you add your head...
by onoehring
2020-04-23 15:34
Forum: Getting Started
Topic: Modifying login page
Replies: 10
Views: 315

Re: Modifying login page

Hi,

just try. Add something (like: AAAAAAAAAAA) to header-extras.php and reload your page, see what happens.
header-extras is read by php when the page will be created. The contents will be added to (all) your pages.

Olaf
by onoehring
2020-04-23 09:39
Forum: Getting Started
Topic: Mysql question
Replies: 9
Views: 338

Re: Mysql question

Hi

attention: Concat will fail if one of the columns is NULL.
Maybe (code not tested):

Code: Select all

concat ((IfNull(Name, ''),' ',(IfNull(Surname, ''))
SQL can be nicer to have no space before / after - but google for that or try:

Code: Select all

trim(concat ((IfNull(Name, ''),' ',(IfNull(Surname, '')))
Olaf
by onoehring
2020-04-23 09:34
Forum: Getting Started
Topic: Updating in Table View
Replies: 6
Views: 211

Re: Updating in Table View

Hi,

the thread I linked to above: viewtopic.php?f=8&t=3443

Olaf
by onoehring
2020-04-23 09:33
Forum: Getting Started
Topic: Modifying login page
Replies: 10
Views: 315

Re: Modifying login page

Hi,

fpr 1) I suggest you take a look here: viewtopic.php?f=4&t=3114

Olaf
by onoehring
2020-04-22 09:58
Forum: Getting Started
Topic: Updating in Table View
Replies: 6
Views: 211

Re: Updating in Table View

Hi,

I would suggest you use the other thread as there is the developer himself present.

Olaf
by onoehring
2020-04-21 18:00
Forum: Getting Started
Topic: Updating in Table View
Replies: 6
Views: 211

Re: Updating in Table View

Hi,

take a look here: viewtopic.php?f=8&t=3443

Olaf
by onoehring
2020-04-21 18:00
Forum: Tips And Tricks
Topic: apply a custom quey in lookup field only if groups is not admin or superuser
Replies: 4
Views: 231

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

Hi, just from memory: The query is saved in some file (just search all files for part of your querystring) and exists in a JS variable. You might be able to overwrite this variable in the /hooks/tablename-php _init function according to your needs. Just check in the init for the usergroup and set th...
by onoehring
2020-04-21 09:50
Forum: Getting Started
Topic: Mysql question
Replies: 9
Views: 338

Re: Mysql question

Hi, that's what the SQL does: It combines the name from one table with the code from the other. Maybe you have doubles in your table B? As data is saved in a "normalized" fashion, it's just right, that in table B only the code (number) is saved. What is sometimes missing? In table A all values shoul...