Search found 219 matches

by jsetzer
2019-08-23 14:50
Forum: Feature Suggestions
Topic: One directory, multiple database
Replies: 0
Views: 34

One directory, multiple database

Hi, I'm just making up my mind and doing some research on how to use the same application (files, directories) with different databases to build some kind of multi-tenant application with seperated databases. I'm not a friend of copying files from one directory to n other directories, one per client...
by jsetzer
2019-08-20 09:22
Forum: Bugs/annoyances
Topic: membership tables
Replies: 5
Views: 99

Re: membership tables

all other users are updating properly except the latest one? Can you see any difference between the last one and the others? Perhaps that one has a very (!) long memberID or special characters in his/her name? No other idea at the moment. For me the next step would be narrowing it down by adding so...
by jsetzer
2019-08-20 08:02
Forum: Getting Started
Topic: How to use value from current record in look up query field?
Replies: 5
Views: 68

Re: How to use value from current record in look up query field?

Sorry, I did not see that you have already answered your request by yourself.

Anyway, hope this idea will help anyone!

Best,
Jan
by jsetzer
2019-08-20 07:43
Forum: Getting Started
Topic: How to use value from current record in look up query field?
Replies: 5
Views: 68

Re: How to use value from current record in look up query field?

Hi Olaf, if it becomes too complicated when using the built-in options, only, you are always free to add any custom input control to your form. For example in hooks/TABLENAME.php function TABLENAME_dv(): // new input without any formatting or label, yet $html .= "<input name=\"whatever\" id=\"whatev...
by jsetzer
2019-08-17 10:16
Forum: Bugs/annoyances
Topic: Password Reset does not work
Replies: 4
Views: 92

Re: Password Reset does not work

Are you using Sendmail or did you configure SMTP? Are you able to send a message to any user from Admin Area? If sendmail: just in case you are testing on localhost: make sure your local mailserver has been installed and configured correctly with php. In Windows environments with XAMPP or WAMP there...
by jsetzer
2019-08-14 17:37
Forum: Bugs/annoyances
Topic: Problem zooming images in print view
Replies: 3
Views: 84

Re: Problem zooming images in print view

Usually I don't use TABLENAME_header- and TABLENAME_footer-functions, but I guess for print preview this is a good place to do the changes: function TABLENAME_footer($contentType, $memberInfo, &$args) { // ... case 'print-tableview': $footer='<script>$j("img.img-thumbnail").closest("a").attr("data-l...
by jsetzer
2019-08-14 16:37
Forum: Bugs/annoyances
Topic: Problem zooming images in print view
Replies: 3
Views: 84

Re: Problem zooming images in print view

Hi, I guess you mean the hourglass when you click am image and the full-size-picture not showing up in the print-preview? I'm wondering if the zooming functionality is required at all in print preview. Maybe you should try to disable the lightbox integration for print view using JQuery: Those images...
by jsetzer
2019-08-14 16:23
Forum: Advanced Customizations > Others
Topic: Batch Action multi sources.
Replies: 7
Views: 231

Re: Batch Action multi sources.

Yes, you can use join the same table multiple times but then you have to use alias names ("as"): See code below: I'm using the same table 'b' in three joins. Each time I'm kind of "renaming" table "b" to "b1", "b2", "b3" using 'as' (alias). Afterwards you can use the table by it's alias name as if i...
by jsetzer
2019-08-13 17:38
Forum: Advanced Customizations > Others
Topic: Batch Action multi sources.
Replies: 7
Views: 231

Re: Batch Action multi sources.

Hi, let's have an abstract example: Tables `a`, `b`, `c` and `d`: All those tables have a primary key named `id`. Table `a` is the master table The columns a.b_id , a.c_id and a.d_id are modeled as lookups pointing to the tables `b`, `c` and `d`. chrome_2019-08-13_19-35-50.png Table "a" id b_id c_id...
by jsetzer
2019-08-13 05:17
Forum: Advanced Customizations > Others
Topic: Batch Action multi sources.
Replies: 7
Views: 231

Re: Batch Action multi sources.

Hi, there are at least two ways to merge data from related tables: The pure SQL way (recommended) Change your SQL query and use SQL's LEFT JOIN or INNER JOIN , for example: // ... $sql = "SELECT `marriage`.* , COALESCE(`othertable`.`column_name`, 'your_default_value') as 'othertable_column' FROM `ma...
by jsetzer
2019-08-11 18:07
Forum: Advanced Customizations > Hooks
Topic: Customizing the data displayed in the table view
Replies: 4
Views: 114

Re: Customizing the data displayed in the table view

It could also help to execute the SELECT CONCAT(...) FROM `cameras` in your SQL workbench (phpMyAdmin, Adminer, etc) to find the quotation-error.
by jsetzer
2019-08-11 18:01
Forum: Advanced Customizations > Hooks
Topic: Customizing the data displayed in the table view
Replies: 4
Views: 114

Re: Customizing the data displayed in the table view

There must be something wrong with quotes in line 37. Try a simpler modification first to get rid of your syntax errors.
by jsetzer
2019-08-11 14:17
Forum: Advanced Customizations > Hooks
Topic: Customizing the data displayed in the table view
Replies: 4
Views: 114

Re: Customizing the data displayed in the table view

There is something wrong in first two lines. Can you please remove the 2nd line or the 1st line depending on your real table name
by jsetzer
2019-08-03 14:57
Forum: Advanced Customizations > Others
Topic: dual field lookup from links
Replies: 3
Views: 192

Re: dual field lookup from links

1) On save you can use TABLENAME_before_insert() function in hooks/TABLENAME.php to get the other value from database and fill $data 2) if you want to read the other value immediately after barcode scan or input, you can use $j.ajax(...) in TABLENAME-dv.js to call a server side php script. Pass the ...
by jsetzer
2019-08-02 13:15
Forum: Tips And Tricks
Topic: How can I add text to the Modify record icon
Replies: 9
Views: 976

Re: How can I add text to the Modify record icon

That code above was css-only. There is so much more when using JQuery, for example:

Replacing icon and adding btn-primary style (Bootstrap):
chrome_2019-08-02_15-11-15.png
chrome_2019-08-02_15-11-15.png (38.45 KiB) Viewed 169 times

Additional buttons per row with custom link:

chrome_2019-08-02_15-12-18.png
chrome_2019-08-02_15-12-18.png (48.25 KiB) Viewed 169 times

Regards,
Jan
by jsetzer
2019-08-02 12:55
Forum: Tips And Tricks
Topic: How can I add text to the Modify record icon
Replies: 9
Views: 976

Re: How can I add text to the Modify record icon

Hey, what about a PURE CSS ONE-LINER : Paste the following CSS-code into your CSS-file (or into your <style>-section for example in hooks/header-extras.php). .children-tabs td.view-on-click a::after { content: "Click here"; } This is the result: chrome_2019-08-02_14-42-10.png Wanna play around a bit...
by jsetzer
2019-07-30 14:27
Forum: Getting Started
Topic: How: Change Label on the fly (filling in result from database)?
Replies: 2
Views: 76

Re: How: Change Label on the fly (filling in result from database)?

Un table view you can use hooks/TN-tv.js to change .text(...) or .html(...) of any $j("th.FN").

For detail view in TN-dv.js you can also find the relevant labels using JQuery and replace innerHtml by whatever you need.

Regards,
Jan
by jsetzer
2019-07-30 08:24
Forum: Advanced Customizations > Hooks
Topic: Hide/show fields in Detail View
Replies: 12
Views: 184

Re: Hide/show fields in Detail View

I would recommend normalizing your tables: Wouldn't it be better to have an additional table "marriages". Having this you are free to add as many marriages per person* as you need . For each marriage you will be able to enter date of marriage and end-date and perhaps more information, for example ch...
by jsetzer
2019-07-27 20:12
Forum: Advanced Customizations > Hooks
Topic: Field Color based on numeric value
Replies: 11
Views: 215

Re: Field Color based on numeric value

You have changed the scenario :) 1) Use parseFloat() function to convert string from .text() return value into numeric value before comparing. 2) I think the condition should be (eff >= 98), not (eff => 98) I guess this is your main bug. 3) Additionally change the selector from .eff-eff_percent to t...
by jsetzer
2019-07-27 18:15
Forum: Advanced Customizations > Hooks
Topic: Field Color based on numeric value
Replies: 11
Views: 215

Re: Field Color based on numeric value

In line 6 try this instead:

Code: Select all

 $j(this).addClass("text-danger");
 
Regards,
Jan
by jsetzer
2019-07-26 07:48
Forum: Getting Started
Topic: open url from sql query
Replies: 3
Views: 137

Re: open url from sql query

You are mixing up JavaScript with PHP window.open belongs to JavaScript. In PHP you can use the header-function: https://www.php.net/manual/en/function.header.php header('Location: http://www.example.com/'); string-concatenation in 'treinocardio_pdf.php?id=' + $id The "+" can be used to concat strin...
by jsetzer
2019-07-26 07:38
Forum: Advanced Customizations > Hooks
Topic: SET Value of Parent TABLE field in Child field
Replies: 7
Views: 174

Re: SET Value of Parent TABLE field in Child field

Hi, if you only need to show outcomes.SODescription in criteria -tableview and criteria -detailview it should be enough to set criteria.SODescription as lookup towards outcomes.SODescription and check [x] Autofill. But if you need the text value inside criteria -table you are right: you'll have to "...
by jsetzer
2019-07-24 11:30
Forum: Advanced Customizations > Hooks
Topic: Center login box
Replies: 9
Views: 199

SOLVED: Center login box

Great, glad to hear!

Best Regards,
Jan
by jsetzer
2019-07-23 18:08
Forum: Advanced Customizations > Hooks
Topic: SUM OF COLUMN
Replies: 9
Views: 241

Re: SUM OF COLUMN

If I understand right: On ... insert update or delete ...of... incomes or expenses ...you'd like to update the fields... Total income, Total expense and Balance of the master record, right? Of cause there are multiple ways to achieve this. You can do it this way: create a function budgets_update($id...
by jsetzer
2019-07-23 14:49
Forum: Advanced Customizations > Hooks
Topic: Center login box
Replies: 9
Views: 199

Re: Center login box

You can use jquery to... remove $j("#login_splash") add class "col-sm-offset-3" to $j(".container > .row > .col-sm-6") add class "col-lg-offset-4" to $j(".container > .row > .col-lg-4") That should do the trick. For example add the following code to hooks/header-extras.php : <script> $j(function() {...