Search found 74 matches

by sacgtdev
2023-04-07 09:20
Forum: Getting Started
Topic: completetly different CSV export SQL?
Replies: 5
Views: 1775

Re: completetly different CSV export SQL?

I have a page xxx.com?ids=1,2,3 where 1,2,3 is the record id. I able to filter the table by record ids but the save csv doesn't work as expected. I have tried to amend the tablename_csv function in hooks by reconstructing the query. I able to reconstruct the query by replacing part of the original q...
by sacgtdev
2023-03-30 10:03
Forum: Tips And Tricks
Topic: Audit Log
Replies: 120
Views: 110383

Re: Audit Log

I modify the auditLog_functions.php for the following function, it works for me. function Audit_makeSafe_custom($data, $is_gpc = true) { if (!is_array($data) && !is_string($data)) { return $data; } if (is_array($data)) { return array_map(function ($entry) use ($is_gpc) { return is_array($entry) ? Au...
by sacgtdev
2023-03-30 01:37
Forum: Tips And Tricks
Topic: Audit Log
Replies: 120
Views: 110383

Re: Audit Log

I found out the issue due to : 2023-03-30T00:26:05.490718327Z: [ERROR] 127.0.0.1 - 30/Mar/2023:00:26:05 +0000 "POST /palm_character_view.php" 500 2023-03-30T00:26:05.493239655Z: [ERROR] NOTICE: PHP message: PHP Fatal error: Uncaught TypeError: strlen(): Argument #1 ($str) must be of type string, arr...
by sacgtdev
2023-03-27 06:27
Forum: Tips And Tricks
Topic: Audit Log
Replies: 120
Views: 110383

Re: Audit Log

Anybody has experienced using the audit log on nginx web server with php 8.0? I encountered 404 error when the audit functions (after_insert, before_insert, etc..) are applied in the hooks. Example, when load the table_view url, says table_view.php, it is ok (200). But, when insert record in table_v...
by sacgtdev
2023-03-26 15:01
Forum: Bugs/annoyances
Topic: migrate from apache 2.0 to nginx and php8.0 (issue encountered)
Replies: 3
Views: 214

Re: migrate from apache 2.0 to nginx and php8.0 (issue encountered)

I realize the problem arises due to the audit log in the hooks files. This is verified by uncommenting the audit log related functions in the hooks file such as table_after_change(), etc .. The 404 error was not found when the app was deployed in apache web server. But, upon migrate to nginx web ser...
by sacgtdev
2023-03-25 09:44
Forum: Bugs/annoyances
Topic: migrate from apache 2.0 to nginx and php8.0 (issue encountered)
Replies: 3
Views: 214

migrate from apache 2.0 to nginx and php8.0 (issue encountered)

I migrate from apache to nginx web server with php8.0 for Appgini 5.97, I encountered an issue when performing insert/delete records. The page will be redirected to 404 page while the record was successfully entered. But, there was no ownership record registered in membership_userrrecord table. More...
by sacgtdev
2023-01-20 01:15
Forum: Bugs/annoyances
Topic: lookup field sql query error when insert/delete record
Replies: 1
Views: 413

Re: lookup field sql query error when insert/delete record

please ignore. issue rectify.. update incCommon.php
by sacgtdev
2023-01-17 06:28
Forum: Bugs/annoyances
Topic: lookup field sql query error when insert/delete record
Replies: 1
Views: 413

lookup field sql query error when insert/delete record

Appgini 5.97 SELECT `trial_recfertiliser`.`id` as 'id', IF( CHAR_LENGTH(`trial1`.`trial_code`), CONCAT_WS('', `trial1`.`trial_code`), '' ) as 'trial_id', IF( CHAR_LENGTH(`fertiliser_conversion`.`fertiliser_name`), CONCAT_WS('', `fertiliser_conversion`.`fertiliser_name`), '' ) as 'fertiliser_name' FR...
by sacgtdev
2022-07-22 03:10
Forum: Advanced Customizations > Others
Topic: Button color based on query value
Replies: 1
Views: 312

Button color based on query value

How to code the button color so that the button color based on certain conditional value?

eg. if query_value >0, then color = green, otherwise, red.

Button is currently generated using jquery.
by sacgtdev
2022-03-07 03:36
Forum: Bugs/annoyances
Topic: Batch action 'change owner' doesn't show users list
Replies: 4
Views: 1168

Re: Batch action 'change owner' doesn't show users list

May I ask whether you have resolved it? Can you share the workarounds?
by sacgtdev
2022-02-09 09:04
Forum: Tips And Tricks
Topic: Placing update_calc_fields function after csv import
Replies: 0
Views: 535

Placing update_calc_fields function after csv import

May I know where to place the update_calc_fields function so that the calculated field will be auto-calculated after every csv import?
by sacgtdev
2021-12-30 15:49
Forum: Tips And Tricks
Topic: DropDown List different colors
Replies: 17
Views: 6015

Re: DropDown List different colors

The code works. Thank you pböttcher
by sacgtdev
2021-12-29 23:41
Forum: Tips And Tricks
Topic: DropDown List different colors
Replies: 17
Views: 6015

Re: DropDown List different colors

How to change the text color of drop-down options?

Image
by sacgtdev
2021-12-29 13:04
Forum: Tips And Tricks
Topic: DropDown List different colors
Replies: 17
Views: 6015

Re: DropDown List different colors

I would like to change the background of option list with different color as shown below. Trying to use the code as shown below, but nothing seems to have changed in appearance.. Is my selector correct? https://i.imgur.com/cVTxpxr.jpeg Code placed in tablename-dv.js $j(function () { var onSelectOpen...
by sacgtdev
2021-12-29 08:45
Forum: Tips And Tricks
Topic: DropDown List different colors
Replies: 17
Views: 6015

Re: DropDown List different colors

I trying out the code shared by Pbotcher, but couldn't make it work...Can anyone help? Following is the js code: https://forums.appgini.com/phpbb/viewtopic.php?t=2876#p9282 $j(function () { var onSelectOpen=function(){ $j(".select2-drop-active .select2-result-selectable:eq(0)").css("color","") $j("....
by sacgtdev
2021-12-26 12:31
Forum: Tips And Tricks
Topic: import csv and do calculation for each record
Replies: 0
Views: 938

import csv and do calculation for each record

Hi. I would like to know how to concurrently do calculation for the calculated field when importing record via csv import.

Any idea?

Regards,
Stephen Yap
by sacgtdev
2021-12-24 06:42
Forum: Tips And Tricks
Topic: RecordsPerPage = $pagenumber
Replies: 2
Views: 1060

Re: RecordsPerPage = $pagenumber

thanks. It works.
by sacgtdev
2021-12-23 10:09
Forum: Tips And Tricks
Topic: CSV magic fiile (option list)
Replies: 1
Views: 784

CSV magic fiile (option list)

For the list option using csv method, if the 'option 1' is removed from the csv. The previously entered value will not be shown in the form details. Re-saving the record will nullify the value. Is there any tricks to circumvent the changes on the field to NULL during saving despite the original valu...
by sacgtdev
2021-12-23 10:08
Forum: Tips And Tricks
Topic: RecordsPerPage = $pagenumber
Replies: 2
Views: 1060

RecordsPerPage = $pagenumber

I would like to let user to choose the no. of record per page. Is there anyone can share the code? I am thinking of leveraging $x->RecordsPerPage = $pagenumber; and create a table to let users to specify page number eg. 25 instead of hard-coded? But, how to store that in the session when a user modi...
by sacgtdev
2021-11-14 04:34
Forum: Advanced Customizations > Hooks
Topic: Search Crashes when searching Views using global-search.php
Replies: 5
Views: 1818

Re: Search Crashes when searching Views using global-search.php

Hi mohamed, I have similar objective as yours which is to allow user to view records which are inaccessible to them in the actual table. I think we can create the view for each table and edit the global-search.php where: /* get tables accessible by current user */ //$tables = getTableList(); //chang...
by sacgtdev
2021-10-08 05:04
Forum: Getting Started
Topic: Filter by selected in table view
Replies: 7
Views: 1787

Re: Filter by selected in table view

Having querywhere set in hooks init, I am able to filter the record. But, if navigate from other page to the page that have querywhere set, the page will not load and require re-submission/refresh.
by sacgtdev
2021-10-08 00:18
Forum: Tips And Tricks
Topic: Audit Log
Replies: 120
Views: 110383

Re: Audit Log

I did the test before and after installation of audit log. However, I didn't meant that the flaw is from the audit log, it could be the conflict with existing setup. I will try on a fresh generated application using Appgini 5.97 (before and after) to confirm again.
by sacgtdev
2021-10-03 03:09
Forum: Tips And Tricks
Topic: Audit Log
Replies: 120
Views: 110383

Re: Audit Log

Hi, onoehring I am experiencing a little annoyance after install the audit log on Appginin 5.97. When I navigate to admin page after the first login attempt, it will return me to an login page again. I have to re-login in order to access the Admin page. May I know whether this is bug that ye to reso...
by sacgtdev
2021-10-02 02:44
Forum: Tips And Tricks
Topic: implement update_calc_fields in import csv
Replies: 0
Views: 956

implement update_calc_fields in import csv

How to implement update_calc_fields function in import-csv.php so that every record imported would have calculated field run automatically?