Search found 21 matches

by landrea
2019-03-22 20:31
Forum: Getting Started
Topic: get right options with hooks
Replies: 0
Views: 14

get right options with hooks

I'm working a hook using js files it works, but it's only a concidence because I dont' have enough datas inside, so at the moment the option1 is correctly what i need to check, but this can change with other datas the problem is the value inside the option is not the foreign key as I thought (i made...
by landrea
2019-03-22 19:43
Forum: Getting Started
Topic: SQL JOIN HELP
Replies: 0
Views: 11

SQL JOIN HELP

I need help optimize the sql I'm in a custom page, I'm getting this array of result from a sql call $res = sql("SELECT tipologia_intervento, COUNT(*) FROM dt_reg_interventi GROUP BY tipologia_intervento", $eo); tiplogia_intervento is a foreign key so, then I need to make a for lop of the array resul...
by landrea
2019-03-21 12:56
Forum: Getting Started
Topic: SQL OPTION IN LOOKUP
Replies: 3
Views: 46

Re: SQL OPTION IN LOOKUP

the sql simply create this: when you select a elements from the list and you associate one to these 3 tables (I separated in 3 tables because they have notihng to do each others, but this element), next time the element is not in the list any more, for doing this I simple added another filed where y...
by landrea
2019-03-20 19:58
Forum: Getting Started
Topic: SQL OPTION IN LOOKUP
Replies: 3
Views: 46

Re: SQL OPTION IN LOOKUP

ok, I think i wrong field, i need to look the descritpion, sorry, the concept wasn't wrong SELECT `dt_inventario`.`id_inventario`, `dt_inventario`.`num_inventario`, `dt_inventario`.`descrizione_inv` FROM `dt_inventario` LEFT JOIN `dt_tip_inventario` as dt_tip_inventario1 ON `dt_tip_inventario1`.`id_...
by landrea
2019-03-20 19:45
Forum: Getting Started
Topic: SQL OPTION IN LOOKUP
Replies: 3
Views: 46

SQL OPTION IN LOOKUP

I have a lookup field in a table, this lookup is connected 3 tables what I want to do is reduce the list if one of these tables already selected a value from the list I added a field in the lookup table called decrizione_inv and in my idea this field is empty or null if noone of these 3 tables have ...
by landrea
2019-03-17 12:38
Forum: Getting Started
Topic: how to return a row from database and get it
Replies: 5
Views: 53

Re: how to return a row from database and get it

ok thanks , I rewrite better, in this way I can adapt the script also situation I can have more rows and not only a row, I'm probably going to use the template for many works at the moment I dont' have the real form for testing the ajax, I still have to do it, but I dont' think I'm going to have pro...
by landrea
2019-03-17 11:56
Forum: Getting Started
Topic: how to return a row from database and get it
Replies: 5
Views: 53

Re: how to return a row from database and get it

at the moment I made this, I'm checking without the ajax, I'm sending parameter directly in the url I dont' know if have a sense, it seems working, i added makesafe for security reason, pheraps is not necessary in this case, I think I'm ok at the moment I added a header to test better the data, I do...
by landrea
2019-03-17 10:13
Forum: Getting Started
Topic: how to return a row from database and get it
Replies: 5
Views: 53

how to return a row from database and get it

I have a theorical problem, I probably will need to do a ajax call to a php file in my hooks folder this time I probably will need to retrun a row from the database and not a single value, I think I can't echo an array like I can echo a simpe string with a a value, I'm not sure because I sometimes c...
by landrea
2019-03-15 15:39
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 87

Re: change value in a filed when select another field

I share the last version, in case people have same need or people want suggest something to do it better, I added an onlick function that show the modal if the field is empty, so dont' store data if the delay still is working and user fast push save button dt_aule-dv.js // ==========================...
by landrea
2019-03-15 15:22
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 87

Re: change value in a filed when select another field

at the moment I changed in this way, adding a deley of 2 seconds, then I'm going to add a required field there with jquery or directly in the software menu of appgini, so you can't submit if is still empty, I woudl prefer another soluction, even though in my test 2 seconds are probably sufficient to...
by landrea
2019-03-15 15:00
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 87

Re: change value in a filed when select another field

ok, I made it, I have a problem because that's not a real select ajax call is ok so I don't post it If I look the html code in console the value of the field connected the select is ok, it change correctly, but when I console.log (in my script onchange jquery) I'm getting alwasy the precedent select...
by landrea
2019-03-14 18:45
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 87

Re: change value in a filed when select another field

thanks very much, I think is in section 10 of the course I need to adapt a little the example probably because had to do with calculation, more or less the select should fire a ajax cal and then I write the value in the field with jquery, I need a php file inside hook that create the sql so, it's qu...
by landrea
2019-03-14 18:21
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 87

change value in a filed when select another field

I made the hook course only I forget lot of things because I don't use the software often I need a little help to remember best techinique to do it I have a table with a lookup filed point into another table, this filed is a select now in the next field it's readonly field i need to store something ...
by landrea
2019-02-09 13:19
Forum: Getting Started
Topic: question new version AppGini 5.73 and 74
Replies: 1
Views: 154

question new version AppGini 5.73 and 74

Hello, I have right to upgrade my appgini to the new version, I have two questions 1) log report say we have now a new password system (more secure) question is if I can still copy the database from local host mysql to online mysql (I mean with the function you export and import slq file) or with th...
by landrea
2018-11-25 09:21
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 447

Re: help for structure of an application

I pheraps need to have a fied in computer is foreigh key to offices and a field in office is foregn key to computers so I need probably to change it automatically if something change and setup a read only field with jquery in one of the two tables I though a way to join tables, source code is too co...
by landrea
2018-11-22 15:29
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 447

Re: help for structure of an application

thanks jsetzer I probably need to think careful application more than I thought, your post help me I was searching about join tables in the forum and in the main guide and there are not specific examples I know how to write the sql, but I don't get how I will serve the data inside a table I didn't c...
by landrea
2018-11-22 13:48
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 447

Re: help for structure of an application

Thanks balfons, surelly app gini is perfect for this application, since I don't have trilion of data, we speak of 200/250 computers and we need to fit the technical part of the law about privacy in europe (that unfortunatly it's the same for a corporation with 10.000 professionists and a no profit o...
by landrea
2018-11-16 16:22
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 447

help for structure of an application

Hello, I need help in order to think how strcture a application. What I need is create a table for offices and create a table for computers are in these offices I want to know if there are computers not associate to the offices, so tables need to be separated and for this porpouse I see in the guide...
by landrea
2018-08-06 12:54
Forum: Advanced Customizations > Others
Topic: multi choice
Replies: 13
Views: 1584

Re: multi choice

Thanks Yesterday i made some test It's not important what you write in the app gini interface since if you put a csv file this ovverride simply your original list (this behaviour is in the php code of root/tablename_dml.php) csv file need the following name: table.field.csv and you need to put it in...
by landrea
2018-08-04 16:27
Forum: Advanced Customizations > Others
Topic: multi choice
Replies: 13
Views: 1584

Re: multi choice

i'm new user and still i'm studying the software i was looking for a solution like the question of the topic i'm intrested your solution, so i ask help to get it better i think i get the php file you posted I create a specific table that i use for the list options when someone update the table (for ...
by landrea
2018-08-04 16:07
Forum: Tips And Tricks
Topic: Alternative Homepage / Indexpage / Dashboard
Replies: 4
Views: 1681

Re: Alternative Homepage / Indexpage / Dashboard

this is really a very good, really amazing
i woudl like to know how you did it
do you work only in footer hook?