Search found 627 matches

by jsetzer
2020-07-09 12:16
Forum: Advanced Customizations > Hooks
Topic: Login directly to Table View
Replies: 9
Views: 207

Re: Login directly to Table View

Code: Select all

// ...
$tableName = 'customers';
$sql = "SELECT COUNT(*) 
  FROM `membership_userrecords` WHERE `tableName` = '{$tableName}' 
  AND `memberID` = '{$memberInfo["username"]}'";
$getrecordcount = sqlValue($sql);
// ...
by jsetzer
2020-07-09 05:41
Forum: Tips And Tricks
Topic: Android App to access AppGini
Replies: 10
Views: 221

Re: Android App to access AppGini

yeah its a free source project now, you should be able to publish it for free! Sorry for the misunderstanding, I was not talking about coronalabs product, but I was talking about the required Oracle JDK , which it not free since April 2019 any more. Is there any free alternative? Did you test with ...
by jsetzer
2020-07-08 21:17
Forum: Advanced Customizations > Hooks
Topic: Day of Week problem Language
Replies: 11
Views: 280

Re: Day of Week problem Language

Sorry, I do not understand. You can change the resulting daynames to whatever you like, for example to strings having any international characters SELECT ELT(dayofweek(`date`), 'äöü', 'ÄÖÜ', 'ß', 'áà', 'â', 'Ææ', '♠♣♥♦') FROM `vouchers` chrome_Gu9NviR1Hr.png Just replace the 7 entries 'Dom', 'Lun', ...
by jsetzer
2020-07-08 21:07
Forum: Tips And Tricks
Topic: Android App to access AppGini
Replies: 10
Views: 221

Re: Android App to access AppGini

Thanks, @DOliviera, I got it running in CORONA SIMULATOR on Windows 10 (64).

For deploying as Android App there is Oracle JDK required. Since April this is not free any longer for professional use. Is there a free way to build an Android app?
by jsetzer
2020-07-08 14:46
Forum: Tips And Tricks
Topic: Android App to access AppGini
Replies: 10
Views: 221

Re: Android App to access AppGini

Hi @DOliviera, thanks for sharing your experience on corona application. I have registered, downloaded, installed and created a blank project. There are 26 files in that blank project. Most are PNG-image files. There is a config.lua and a main.lua. Where do I have to put the code line you have menti...
by jsetzer
2020-07-08 05:25
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Field remain open after input
Replies: 1
Views: 121

Re: Field remain open after input

Sorry, I do not understand what you mean by "keeping filled fields open". Can you please post a screenshot and illustrate what you mean. Additionally, I have seen that you are using blanks in field names, for example in new AppGiniField("field 1a") I am wondering if the fieldnames really have any bl...
by jsetzer
2020-07-08 05:19
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Change label, show * for mandatory
Replies: 3
Views: 157

SOLVED: Change label, show * for mandatory

Thanks, Paul, I'm happy it works for you!
by jsetzer
2020-07-08 04:52
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Error 404 in custom pages
Replies: 3
Views: 90

Re: Error 404 in custom pages

(2) You can reference the fully qualified url, for example: <!-- file: hooks/header-extras.php --> <script src="http://localhost/PATH/TO/YOUR/APP/hooks/AppGiniHelper.min.js"></script> Please note Alternative (1) is more dynamic and more flexible Alternative (2) is shorter, but you will have to chang...
by jsetzer
2020-07-08 04:49
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Error 404 in custom pages
Replies: 3
Views: 90

Re: Error 404 in custom pages

(1) Starting from the specs for custom pages here, https://bigprof.com/appgini/help/advanced-topics/custom-limited-access-pages, you have to define a constant named PREPEND_PATH : <?php // file: hooks/YOURCUSTOMPAGE.php define('PREPEND_PATH', '../'); // ... You can use that constant in hooks/header-...
by jsetzer
2020-07-06 21:48
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: TAB View Transition
Replies: 16
Views: 282

Re: TAB View Transition

Thanks, I will have a look next weeks if there is something special/different with the lookup's "add new" buttons.
by jsetzer
2020-07-06 21:39
Forum: Advanced Customizations > Hooks
Topic: Day of Week problem Language
Replies: 11
Views: 280

Re: Day of Week problem Language

(2) different approach Step 1: Create a table (in your SQL tool or by code) and populate id's 1-7 with your localized weekday names, starting with 1=Sunday...7=Saturday. DROP TABLE IF EXISTS `i18n_weekdays`; CREATE TABLE `i18n_weekdays` ( `id` int(11) NOT NULL, `lang_code` varchar(5) NOT NULL, `week...
by jsetzer
2020-07-06 21:19
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: TAB View Transition
Replies: 16
Views: 282

Re: TAB View Transition

Good to hear. Can you please tell us what was the problem?
by jsetzer
2020-07-06 21:15
Forum: Advanced Customizations > Hooks
Topic: Day of Week problem Language
Replies: 11
Views: 280

Re: Day of Week problem Language

SELECT ELT(dayofweek(`FIELDNAME`), 'Dom', 'Lun', 'Mar', 'Mer', 'Gio', 'Ven', 'Sab') FROM `TABLENAME` WHERE `PKCOLUMN`='%ID%' Please note that first entry in list of days is Sunday , because (by default) week starts on Sundays in MySQL databases. Just replace: FIELDNAME (your date field) TABLENAME y...
by jsetzer
2020-07-06 12:52
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: TAB View Transition
Replies: 16
Views: 282

Re: TAB View Transition

I'm sorry if this does not work for you. I have just checked again and for me it works even with the .detail_view style without further modification. There is no blank page when opening "add new" modal in my environment. ezgif.com-video-to-gif.gif Are you sure there are no errors in console which co...
by jsetzer
2020-07-06 12:36
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: TAB View Transition
Replies: 16
Views: 282

Re: TAB View Transition

By the way: If...

Code: Select all

.detail_view { display: none; } 
...causes the problem you are facing, you can replace the CSS selector by a different one which suits your requirements better, for example:

Code: Select all

.table-YOURTABLENAME.detail_view { display: none;}
(replace YOURTABLENAME)
by jsetzer
2020-07-06 11:17
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: TAB View Transition
Replies: 16
Views: 282

Re: TAB View Transition

Hi, I have just tested opening a modal "add new" dialog. In my form there is no blank dialog, but the expected dialog opens up. So, can you please check your code for javascript errors first (console tab in dev-tools). If there are no errors, please remove the customization code and reload (always c...
by jsetzer
2020-07-06 08:51
Forum: Advanced Customizations > Others
Topic: Android App for AppGini
Replies: 6
Views: 167

Re: Android App for AppGini

It was a bit of a hassle to install Android Studio and fix the build errors (change package name, import R), but finally it works.
It opens up new perspectives and raises new ideas.
by jsetzer
2020-07-06 07:26
Forum: Advanced Customizations > Others
Topic: Android App for AppGini
Replies: 6
Views: 167

Re: Android App for AppGini

That's awesome, thanks a lot!!!

Screenshot_20200706-092217_OCMS Mobile-1.jpg
Screenshot_20200706-092217_OCMS Mobile-1.jpg (40.17 KiB) Viewed 132 times
Screenshot_20200706-092358_OCMS Mobile.jpg
Screenshot_20200706-092358_OCMS Mobile.jpg (40.98 KiB) Viewed 132 times
by jsetzer
2020-07-06 06:17
Forum: Advanced Customizations > Hooks
Topic: Auto adjust quantity if similar item added
Replies: 7
Views: 174

Re: Auto adjust quantity if similar item added

Maybe this one is even easier.

(2) different approach
  1. Select different product_id from OrderItems of the same order.
  2. foreach product_id
    1. update the quantity of the first orderitem for that product and order
    2. then delete all other orderitems for that product and order
by jsetzer
2020-07-06 06:14
Forum: Advanced Customizations > Hooks
Topic: Auto adjust quantity if similar item added
Replies: 7
Views: 174

Re: Auto adjust quantity if similar item added

chrome_rqg1iyuGtf.png If I got you right, you'd like to put the sum of all quantities of OrderItems, having the same product_id, into one OrderItem. I am afraid you cannot force users to edit an existing OrderItem instead of inserting a new OrderItem with identical product_id. But after insert you ...
by jsetzer
2020-07-05 09:53
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Duplication of Buttons in Detail view
Replies: 14
Views: 233

Re: Duplication of Buttons in Detail view

Thanks! I'm happy I could help. Just open the final source code in the browser (CTRL+U in Chrome) and search for btn-toolbar. There is the default one from AppGini and there is a second one created when initializing AppGiniDetailView object. The 2nd one is required for custom buttons which are docum...
by jsetzer
2020-07-05 07:36
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Duplication of Buttons in Detail view
Replies: 14
Views: 233

Re: Duplication of Buttons in Detail view

Can you please check how many $j('#Services_dv_action_buttons .btn-toolbar') you have. I guess there are two ".btn-toolbars", not one. chrome_wqvbe2bH2t.png If there are two targets, this means you are appending your 2 buttons to 2 btn-toolbars which makes 4 buttons. You should change the selector a...
by jsetzer
2020-07-05 05:47
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Duplication of Buttons in Detail view
Replies: 14
Views: 233

Re: Duplication of Buttons in Detail view

Can you also please ensure that there is only one (!) initialization of new AppGiniDetailView() in your code.