Due Date for closed tickets

[GoneShootin]

Before we upgraded to the latest version we were having problems with Due Dates/Times for closed tickets. So instead of farting about with settings and so on, I simply hacked

/modules/core/staff_dashboard.php

with

PHP Code:

        // Get Overdue Tickets
        $dbCore->query("SELECT * FROM `". TABLE_PREFIX ."tickets` WHERE `departmentid` IN (". buildIN($_assigns) .") AND `ticketstatusid` IN (". buildIN(getDisplayTicketStatusList()) .") AND (`duetime` < '". DATENOW ."' AND `duetime` != 0) AND ticketstatusid <> 3;");


        // Get Tickets Due Today
        $dbCore->query("SELECT * FROM `". TABLE_PREFIX ."tickets` WHERE `departmentid` IN (". buildIN($_assigns) .") AND `ticketstatusid` IN (". buildIN(getDisplayTicketStatusList()) .") AND (`duetime` > '". intval($_datestart) ."' AND `duetime` < '". intval($_dateend) ."') AND ticketstatusid <> 3;"); 


By adding an extra

 AND ticketstatusid <> 3

To the end of each of the above queries I can now prevent any closed tickets being displayed "incorrectly" as due. Due tickets should never be flagged if their status is closed.

[craigbrass]

Thanks for sharing that! I am sure many will find it useful.

[GoneShootin]

Yeah it doesn't really fix the problem but it certainly hides the "incorrect" info.