Search found 318 matches

by D Oliveira
2023-01-25 22:36
Forum: Advanced Customizations > Hooks
Topic: TCPDF - GET ID
Replies: 4
Views: 131

Re: TCPDF - GET ID

you shouldn't be executing a query with this get request parameter without the makeSafe() function shielding from a mysql injection.
by D Oliveira
2022-12-25 00:12
Forum: Tips And Tricks
Topic: Dark mode for apps - chrome ext will save your eyes
Replies: 1
Views: 193

Dark mode for apps - chrome ext will save your eyes

Hey Folks,

People that stare at appgini based apps throughout their days have reported that using a darker theme like the chrome extension below can significantly help reduce stress on your eyes:

https://chrome.google.com/webstore/deta ... hnkhdbieeh


Hope it helps!
by D Oliveira
2022-12-22 23:59
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniHelper feature - dv.getChildrenTabs().sort()
Replies: 14
Views: 522

Re: AppGiniHelper feature - dv.getChildrenTabs().sort()

...I don't think BigProf can afford to double development cost... $79 is just too cheap for what Appgini offers in my opinion, I would explore charging subscription options and raising the base price if that's what it takes to expand development, but yeah at the end of the day this is not my decisi...
by D Oliveira
2022-12-21 20:47
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniHelper feature - dv.getChildrenTabs().sort()
Replies: 14
Views: 522

Re: AppGiniHelper feature - dv.getChildrenTabs().sort()

I understand backwards compatibility is a major driver to sustain the business side of things, but that doesn't mean BigProf can't fork the project in light of the benefits and create a separate product even though I understand this would take tremendous effort and so far Appgini has been brilliant ...
by D Oliveira
2022-12-21 19:46
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniHelper feature - dv.getChildrenTabs().sort()
Replies: 14
Views: 522

Re: AppGiniHelper feature - dv.getChildrenTabs().sort()

...Next version of AppGini Helper Javascript Library... Very interesting, hopefully you can add a quick one-liner repositioning feature to this collapsable panels as well, I don't see Appgini heading towards the object oriented programming approach trend within the PHP world nowadays, I think it wi...
by D Oliveira
2022-12-20 14:53
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniHelper feature - dv.getChildrenTabs().sort()
Replies: 14
Views: 522

Re: AppGiniHelper feature - dv.getChildrenTabs().sort()

It's a bit off topic but I'm not particularly a fan of the bottom panel for children tables, in my workflow I usually hide the whole panel and insert each table block in the section that pertains that information, otherwise you have to keep scrolling up and down to access it. Usually I create a chec...
by D Oliveira
2022-11-23 00:37
Forum: Bugs/annoyances
Topic: closing modal window automatically?
Replies: 1
Views: 209

Re: closing modal window automatically?

you can use the .click() js method on the element that closes the modal an run this on the parent js in case you wanna trigger any action after modal has been closed: $j(function() { $j(window).on('child-modal-closed', function(e, data) { // do something $j('form').submit(); // reload the current DV...
by D Oliveira
2022-11-12 20:37
Forum: Tips And Tricks
Topic: [TUTORIAL] BARCODE SCANNING
Replies: 12
Views: 6729

Re: [TUTORIAL] BARCODE SCANNING

Hello,

There are modern more viable options nowadays, even though I don't use scanning in my workflow anymore, I would look at:

https://github.com/mubaidr/Javascript-Barcode-Reader
by D Oliveira
2022-10-22 22:54
Forum: Getting Started
Topic: How to go ahead commercially?
Replies: 2
Views: 263

Re: How to go ahead commercially?

I guess Appgini's creator has said something about this before:

viewtopic.php?t=743
by D Oliveira
2022-10-13 23:28
Forum: Advanced Customizations > Hooks
Topic: Conditionally show as read only to certain group
Replies: 10
Views: 715

Re: Conditionally show as read only to certain group

Here's some help: <div id="my_div"> A Text Value </div> <script type="text/javascript"> jQuery(function(){ var pass_val = 'passing_value'; var received_val = null; $j.ajax({ url: 'ajax-file.php', data: { ajax_pass: pass_val }, success: function(data){ if (data) { console.log(data); received_val = da...
by D Oliveira
2022-09-09 08:05
Forum: Advanced Customizations > Hooks
Topic: Modify Table View
Replies: 2
Views: 338

Re: Modify Table View

you can filter the table, get the url param, after condition met add .css or javascript in hooks/footer-extras.php
by D Oliveira
2022-08-26 23:42
Forum: Getting Started
Topic: PHP Versions
Replies: 6
Views: 504

Re: PHP Versions

I support Jan's idea running mac os xampp 8.1.6 PHP version: 8.1.6 Server version: 10.4.21-MariaDB - Source distribution AppGini 22.14 no language settings no problems, running smoothly ( was running well with PHP 7.3 and 7.4 as well) (only problem when executing sql() method without second error pa...
by D Oliveira
2022-08-19 17:37
Forum: Getting Started
Topic: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php
Replies: 5
Views: 885

Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php

PHP 8.1 will throw so many errors for older appgini versions, change php version to 7.x on cpanel or update your app to 22.14
by D Oliveira
2022-08-19 12:26
Forum: Getting Started
Topic: special condition <=>
Replies: 3
Views: 558

Re: special condition <=>

code note tested tablename-dv.js -> replace table name for your tablename and put this file inside hooks directory $j(function()){ $j('#field_name').on('change', function(){ if( $j('#field_name').val() <= 4 ){ $j('#another_field').val('low'); }else if( $j('#field_name').val() == 5 ){ $j('#another_fi...
by D Oliveira
2022-08-08 01:33
Forum: Tips And Tricks
Topic: [tutorial] hide child table view field columns
Replies: 0
Views: 620

[tutorial] hide child table view field columns

Hey guys, have you ever wanted to hide some columns inside a child table but did not want to mess with the original table view setup? Just use the following code in your hooks/footer-extras.php :) <?php ?> <script type="text/javascript"> var my_table = window.location.href; var parts = my_table.spli...
by D Oliveira
2022-08-06 18:06
Forum: Tips And Tricks
Topic: getting 500 on ajax call, any hints?
Replies: 9
Views: 776

Re: getting 500 on ajax call, any hints?

Thank you both for helping, that did it!!! removing the quote and adding second parameter =)))
by D Oliveira
2022-08-06 17:16
Forum: Tips And Tricks
Topic: getting 500 on ajax call, any hints?
Replies: 9
Views: 776

Re: getting 500 on ajax call, any hints?

Hi there, thank you for replying =) I'm still getting status 500 with this code, it seems to only work when using sqlValue() all other functions keep returning 500 jquery-3.5.1.min.js:2 GET http://localhost/tigercontrol2/hooks/ajax/ajax-po.php?ajax_pass=6&ajax_pass1=workbook_gutter 500 (Internal Ser...
by D Oliveira
2022-08-06 14:23
Forum: Tips And Tricks
Topic: global search plugin for just specific tables?
Replies: 1
Views: 422

Re: global search plugin for just specific tables?

found the solution for this one as well but be cautious because you will have to change a core appgini file named incCommom.php duplicate the function getTableList(), give it another name and only keep the tables you want to search, then in your global script change the function name to reflect that...
by D Oliveira
2022-08-06 13:02
Forum: Tips And Tricks
Topic: getting 500 on ajax call, any hints?
Replies: 9
Views: 776

Re: getting 500 on ajax call, any hints?

still not ideal but that way you dont need multiple ajax files: $ajax_pass = makeSafe($_REQUEST['ajax_pass']); $ajax_pass1 = makeSafe($_REQUEST['ajax_pass1']); $ajax_pass2 = makeSafe($_REQUEST['ajax_pass2']); $ajax_pass3 = makeSafe($_REQUEST['ajax_pass3']); $query_start = "SELECT ct_name FROM {$ajax...
by D Oliveira
2022-08-06 12:37
Forum: Tips And Tricks
Topic: getting 500 on ajax call, any hints?
Replies: 9
Views: 776

Re: getting 500 on ajax call, any hints?

this is weird because sqlValue() works but that not efficient ( field by field.... ) using mtsqli_fetch_array() would save way more time returning all values, if anyone knows how to fix this please share, in the meanwhile the following code works but you will have to query every field... $query_star...
by D Oliveira
2022-08-05 23:13
Forum: Tips And Tricks
Topic: getting 500 on ajax call, any hints?
Replies: 9
Views: 776

getting 500 on ajax call, any hints?

hey guys, can anyone help me figure out why it is returning 500 error? js var pass_val = $j('#tender1-container').val(); var tblname = 'workbook'; $j.ajax({ url: 'hooks/ajax/ajax-po.php', data: { ajax_pass: pass_val, ajax_pass1: tblname }, success: function(data){ if (data) { console.log(data); var ...
by D Oliveira
2022-08-02 10:14
Forum: Tips And Tricks
Topic: global search plugin for just specific tables?
Replies: 1
Views: 422

global search plugin for just specific tables?

Hey guys, does anyone know a mod for the global search script to search just specific tables instead of all tables? I would like to create separate search pages with each searching specific tables <?php /** * Basic script to perform global search on all tables of an AppGini application. * Create a n...
by D Oliveira
2022-07-27 15:41
Forum: Tips And Tricks
Topic: Scaling horizontally? Concurrent connections
Replies: 0
Views: 303

Scaling horizontally? Concurrent connections

Hey folks, I'm just wondering if any of you had reached a limit of concurrent connections in your apps and how you scaled horizontally once scaling vertically stops being a feasible option, I'm assuming the most practical way is to host your db in a separate vps server and leverage load balancer to ...
by D Oliveira
2022-07-22 13:04
Forum: Advanced Customizations > Hooks
Topic: Hooks - JOB
Replies: 1
Views: 279

Re: Hooks - JOB

in your main app directory find tablename_view.php

then locate:

Code: Select all

// Fields that can be displayed in the csv file
	$x->QueryFieldsCSV = [

find your lookup field and insert a query for the output value, now your csv file has the actual data of the lookup instead of the ID, hope that helps.
by D Oliveira
2022-07-22 12:54
Forum: Getting Started
Topic: Appgini cant write to this folder please select a folder you have write access to
Replies: 4
Views: 428

Re: Appgini cant write to this folder please select a folder you have write access to

this sounds like a permissions issue you can try running sudo chmod 755 or going straight to the directory and changing writing permissions, hope that helps.