AppGini Community Forums

I'm looking for a solution to create a web based application. I've been reviewing various solutions including Appgini.

I'm wondering if I can have 'due dates' in Appgini.

Example: cells where the due date is expired would be red, cells where the due date is 7 days out yellow, cells where due dates are 8+ days out green. Once the item is take care of, then due date updates to either 7 days out, 14 days out, 30 days out, end of the following month, etc.

If Appgini is capable of doing this, please briefly explain. Thanks.

Although this is not directly supported by AppGini, it can be added by customizing the generated code. Let's assume your table name is 'tasks', the field name is 'due_date', and the date format for that field is 'month/day/year'. You should add code similar to the following in the generated 'hooks/footer-extras.php' file:
Here is sample output that shows how highlighting would look like (assuming the default bootstrap theme):

Thank you for the response a.gneady. I purchased appgini last night, I'm looking forward to using and supporting the development & support of Appgini.

You're always welcome.
And thanks for your order

a.gneady wrote:Although this is not directly supported by AppGini, it can be added by customizing the generated code. Let's assume your table name is 'tasks', the field name is 'due_date', and the date format for that field is 'month/day/year'. You should add code similar to the following in the generated 'hooks/footer-extras.php' file:

Code: Select all

$j('td.tasks-due_date a').each(function(){
    var ds = $j(this).html();
    
    /* assuming date format of due_date is month/day/year */
    var dc = new Date(ds.replace(/(\d{1,2})\/(\d{1,2})\/(\d{4})/, '$3-$1-$2'));
    
    var today = new Date();
    var days_ahead = parseInt((dc - today) / 86400 / 1000);

    if(days_ahead >= 8){
        // 8+ days left, use green highlighting
        $j(this).addClass('text-success').parent().addClass('success');
    }else if(days_ahead >= 7){
        // 7 days left, use yellow highlighting
        $j(this).addClass('text-warning').parent().addClass('warning');
    }else{
        // less than 7 days left, use red highlighting
        $j(this).addClass('text-danger').parent().addClass('danger');
    }
});

Here is sample output that shows how highlighting would look like (assuming the default bootstrap theme):

Doing the above I get the following errors.

@ All, I think I got it working! I'll update momentarily! Yeeeehaw! Making progress with Appgini.

How did you fix that error, I got the same, not sure how to work around it!

I have two more questions about this function please:

• Is it possible to highlight the whole row and not just the due date cell?
• Is it possible to highlight it based on cell content, like if it had the word 'hot' or so?

Thank your for your awesome support!

Regarding the above error, make sure the code is inserted in the footer page inside a script tag. You should also make sure it is NOT placed inside a php block.

To highlight an entire row based on a value you can use a code similar to the one below.
For more tips and ideas regarding customizing the generated code, please refer to our AppGini Customization Course at https://www.udemy.com/customizing-appgi ... ode=TENOFF

Thank you so much Noha, it is working for me now. However, for some reason I don't get the text effect of the theme when the whole row is selected (see screenshot), it only color the background with the right theme but not the text. Is there a way to fix this?
I checked the preview of your course, it does sound interesting. I'll definitely sign up for it.

This code should do the job:

I just found out that it only works on Chrome browser - not other browsers like Microsoft Edge, Firefox, and others. I haven't test on different browsers, just three of them. These highlight colors works on chrome only - is there a way to get it working on other browsers?

D Campbell wrote: ↑

2017-10-25 14:08

I just found out that it only works on Chrome browser - not other browsers like Microsoft Edge, Firefox, and others. I haven't test on different browsers, just three of them. These highlight colors works on chrome only - is there a way to get it working on other browsers?

I have just tried it on IE and Firefox browsers and it works as fine as on Chrome browser.