Search found 734 matches

by jsetzer
2020-10-20 18:47
Forum: Tips And Tricks
Topic: Help with lookup field in appgini project (advanced query)
Replies: 2
Views: 31

Re: Help with lookup field in appgini project (advanced query)

SELECT `projects`.`pkey`, `projects`.`project`, `projects`.`start_conclusion` CONCAT_WS('', `projects`.`project`, `projects`.`start_conclusion`) FROM `projects` WHERE `projects`.`active` = 'YES' ORDER BY `project` As far as I know the advanced query should return two values: the primary key and the...
by jsetzer
2020-10-20 18:38
Forum: Tips And Tricks
Topic: $_GET returning filter value?
Replies: 2
Views: 34

Re: $_GET returning filter value?

Can you try this instead:

Code: Select all

$catg = makesafe($_GET["FilterValue[13]"]);
echo 'testing:  '.$catg;
by jsetzer
2020-10-20 16:31
Forum: Tips And Tricks
Topic: take two numbers of year in appgini project with calculated field
Replies: 3
Views: 35

Re: take two numbers of year in appgini project with calculated field

Thank you, Fabiano, I'm happy this solution works fine for you. :D
by jsetzer
2020-10-20 08:16
Forum: Tips And Tricks
Topic: take two numbers of year in appgini project with calculated field
Replies: 3
Views: 35

Re: take two numbers of year in appgini project with calculated field

Hi Fabiano, first check the following SQL command with your database tool (like phpMyAdmin or Adminer): SELECT *, concat_ws('-', DATE_FORMAT(start_date, '%y'), DATE_FORMAT(ifnull(updated_end_date, end_date), '%y')) as 'calculated_years' FROM `TABLENAME` * replace TABLENAME I have created a table for...
by jsetzer
2020-10-15 08:25
Forum: Tips And Tricks
Topic: A Currency Field with more than one option
Replies: 5
Views: 115

Re: A Currency Field with more than one option

Please have a look at dataformat options.

This could be a starting point:
viewtopic.php?f=11&t=1614&p=11142&hilit ... cfg#p11142
by jsetzer
2020-10-14 11:42
Forum: Getting Started
Topic: Settings.
Replies: 3
Views: 77

Re: Settings.

Maybe you should try something like this:

Code: Select all

function settings_init(&$options, $memberInfo, &$args)
{
  $options->AllowInsert = sqlValue("SELECT count(*) FROM settings") == 0 ? 1 : 0;	
  return TRUE;
}
by jsetzer
2020-10-13 11:32
Forum: Tips And Tricks
Topic: A Currency Field with more than one option
Replies: 5
Views: 115

Re: A Currency Field with more than one option

The problem you are describing here is actually valid for all tasks where something has to be versioned - here: Exchange rates depending on date I such cases I am usually adding a lookup table for currencies and store the currency_id next to the price. Example Table "invoicess" id status_id with thi...
by jsetzer
2020-10-12 16:45
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: custom title not working?
Replies: 2
Views: 58

Re: custom title not working?

I'm sorry, the function you are refering to will be available from next version on (2020/10) which will be released soon this month.

Please see the changelog:
https://appgini.bizzworxx.de/products/j ... changelog/
by jsetzer
2020-10-11 11:56
Forum: Advanced Customizations > Hooks
Topic: Automatically insert a value incremented by one unit into a field when I generate a new record
Replies: 3
Views: 110

Re: Automatically insert a value incremented by one unit into a field when I generate a new record

This is a well known software- and database-problem. Imagine there are 2 or more users creating a record in the same period of time. One enters insert-mode and can see the serial number. Later, another user or more users also enter insert-mode. In this common scenario all of them would see the same ...
by jsetzer
2020-10-09 13:17
Forum: Advanced Customizations > Others
Topic: Custom Page - Column Sum
Replies: 11
Views: 206

Re: Custom Page - Column Sum

Well done. I'm wondering if $conn is the same DB or a different datasource.

If this is the same DB, you can also use the built-in sqlValue()-function:

Code: Select all

$sum = sqlValue('SELECT SUM(workforce_out) FROM workforce_impact_report_30_days'); 
by jsetzer
2020-10-09 10:45
Forum: Getting Started
Topic: combining data from more than one table
Replies: 14
Views: 291

Re: combining data from more than one table

Example screenshot (Bootstrap 3 list-group-items) "Recently Viewed Records" (per user) showing a list of records from different tables. Each list-view-item is linked to the detail view:
chrome_J31oVO6zQO.png
chrome_J31oVO6zQO.png (24.06 KiB) Viewed 245 times
by jsetzer
2020-10-09 10:43
Forum: Getting Started
Topic: combining data from more than one table
Replies: 14
Views: 291

Re: combining data from more than one table

For sure you can create table-rows (or list-items) as you like and, for example, put a link to the detail view into the first cell of each row: not tested code <?php // get your search results using SQL // $rows = ?> <table class="table table-bordered table-striped table-hover"> <!-- use PHP and ite...
by jsetzer
2020-10-09 04:25
Forum: Advanced Customizations > Others
Topic: Custom Page - Column Sum
Replies: 11
Views: 206

Re: Custom Page - Column Sum

Code: Select all

$eo = null;
$rows = [];
$res = sql("select * from TABLENAME", $eo);
if (!$eo) { 
  while($row = db_fetch_assoc($res)) 
    $rows[] = $row;
}
by jsetzer
2020-10-08 20:19
Forum: Advanced Customizations > Others
Topic: Custom Page - Column Sum
Replies: 11
Views: 206

Re: Custom Page - Column Sum

I must have missed that, sorry!!!
by jsetzer
2020-10-08 18:20
Forum: Advanced Customizations > Others
Topic: Custom Page - Column Sum
Replies: 11
Views: 206

Re: Custom Page - Column Sum

I recommend using the AppGini built in sql-function if you fetch data from current database. Are you sure you mean mysql_* functions? I guess you will have to use mysqli_* functions instead. I think you have mixed up mysqli-functons and mysql-functions. Can you please ask your questions in the forum...
by jsetzer
2020-10-08 17:18
Forum: Getting Started
Topic: combining data from more than one table
Replies: 14
Views: 291

Re: combining data from more than one table

An alternative to an additional view is a custom page (https://bigprof.com/appgini/help/advanced-topics/custom-limited-access-pages), on which the information can be collected from database using the built-in sql-command and displayed, for example as a table or list. Bootstrap 3 Tables https://getbo...
by jsetzer
2020-10-08 17:06
Forum: Advanced Customizations > Hooks
Topic: Sending email to multiple receipt
Replies: 5
Views: 117

Re: Sending email to multiple receipt

I think you have mixed up the two foreach-loops. Create your message first. Then use foreach to send it to each recipient: not tested code: function myone_sped_after_update($data, $memberInfo, &$args) { $receipt=array('[email protected].com','[email protected].com'); // compose message foreach($data as $fiel...
by jsetzer
2020-10-07 15:39
Forum: Tips And Tricks
Topic: Added Page on Very Slow
Replies: 8
Views: 185

Re: Added Page on Very Slow

According to Chapter "Tips / Custom pages" in the docs https://appgini.bizzworxx.de/products/javascript-library/documentation/installation-integration/, can you please try the following include in hooks/header-extras.php <script src="<?=PREPEND_PATH?>hooks/AppGiniHelper.min.js"></script> chrome_wmDD...
by jsetzer
2020-10-07 15:03
Forum: Tips And Tricks
Topic: Added Page on Very Slow
Replies: 8
Views: 185

Re: Added Page on Very Slow

Did you notice /hooks/hooks?
I guess there is something wrong with your include path
by jsetzer
2020-10-07 10:33
Forum: Tips And Tricks
Topic: Added Page on Very Slow
Replies: 8
Views: 185

Re: Added Page on Very Slow

Hi, I agree with Olaf: the custom page looks fine. I assume that you have already checked if all additional scripts could be loaded and no more (red) errors appear in the console. If this issue is related to lazy loaded scripts or other resources, it might help if you open the developer tools in you...
by jsetzer
2020-10-02 17:30
Forum: Getting Started
Topic: DevTools failed to load SourceMap
Replies: 3
Views: 81

Re: DevTools failed to load SourceMap

"AppGini.currentTableName: Could not retrieve table name from page URL" Yes, there are a few posts in this forum about this. It is a well known issue on AppGini custom pages and pages not related to any table. This console printout will not harm your other scripts so we all can ignore it for now. I...
by jsetzer
2020-10-02 15:19
Forum: Getting Started
Topic: DevTools failed to load SourceMap
Replies: 3
Views: 81

Re: DevTools failed to load SourceMap

Hello, I assume that many/most of us will have this console warning, as it is a known browser problem. To my knowledge the warning has nothing to do with AppGini or AppGini extensions. Here is an article that describes a way to get around this warning. https://superuser.com/questions/1523427/google-...
by jsetzer
2020-09-22 18:14
Forum: Getting Started
Topic: How to Archive Deleted Records?
Replies: 8
Views: 1045

Re: How to Archive Deleted Records?

1[+2] columns vs. 1 column Yes, from technical point of view you are completely right, Olaf. Thanks for emphasizing. The primary idea of soft-delete is the is_deleted flag. As mentioned ("perhaps"), deleted_by and/or deleted_on are optional for some extra information. Of course, if you have at leas...
by jsetzer
2020-09-22 16:56
Forum: Getting Started
Topic: How to Archive Deleted Records?
Replies: 8
Views: 1045

Re: How to Archive Deleted Records?

Forgot to say: the "soft-delete" concept can be used with an "is_archived" column (instead of "is_deleted"). Filter all records where is_archived = 1 in _init() function. Those marked records will stay in db and integrity with related records (lookups) will be kept. But if you need extra archive tab...