Overdue - not counting weekend days

ern

Dear OsTicket fans!

Does anyone did MOD like in the title?

The target is to not couting weekend days to overdue function.

I have idea to set different overdue time (default time for me is 3 days) when the ticket is created i.e.

-when ticket created on Fri - set overdue on 5 days

-when ticket created on Thu - set overdue on 4 days

What You think about it?

Cheers,

Lucas

ern

I have an idea to use bash command which on output give day of week:

date -R| awk '{print $1}'| sed -e 's/,$//'

And now there is a job to change function called duedate in newticket.inc.php

IF 'my code above' == Thu set strtotime("+5 days")

IF 'my code above' == Fri set strtotime("+4 days")

ELSE set strtotime("+3 days")

But I am not php programmer, so can anyone help me to write this properly?

Due date in newticket.inc.php:

<tr>

<td align="left" valign="top"> Due Date:</td>

<td>

Time is based on your time zone (GM <?=$thisuser->getTZoffset()?>)  <?=$errors?> 

<input id="duedate" name="duedate"

value="<?=Format:($info==""?date("d-m-Y", strtotime("+2 days")):$info)?>"

onclick="event.cancelBubble=true;calendar(this);" autocomplete=OFF>

<a href="#" onclick="event.cancelBubble=true;calendar(getObj('duedate')); return false;"><img src='images/cal.png'border=0 alt=""></a>

  

<?php

$min=$hr=null;

if($info)

list($hr,$min)=explode(':',$info);

echo Misc:($hr,$min,'time');

?>

  <?=$errors?>

</td>

</tr>

ern

From this site:

(http://php.net/manual/pl/function.getdate.php)

there is a example how to do this but in other way (I think better way):

// This functions calculates the next date only using business days

// 2 parameters, the startdate and the number of businessdays to add

function calcduedate($datecalc,$duedays) {

$i = 1;

while ($i <= $duedays) {

$datecalc += 86400; // Add a day.

$date_info = getdate( $datecalc );

if (($date_info == 0) or ($date_info == 6) ) {

$datecalc += 86400; // Add a day.

continue;

}

$i++;

}

return $datecalc ;

}

Right now, duedate is modyfying when next day of week is Sat (6) or Sun (0),

but there is a problem with starting date is 1-1-1970

I checked if getdate function is working correctly and I prepared php code:

<?php

$today = getdate();

print_r($today);

?>

and I got proper results.

Array ( => 35 => 33 => 18 => 22 => 0 => 1 => 2012 => 21 => Sunday => January => 1327253615 )

SO, WHERE IS A PROBLEM...?

I attached my newticket.inc.php - but remember that I have a lot of modifications.

[newticket.inc.zip](https://forum.osticket.com/assets/files/migrated/9/5b7f6a50ded5be84f44955c30d2809a.zip)

ern

One little change around line 170 in Due Date section:

this part of code:

date("d-m-Y", calcduedate(date("d-m-Y"), 2))

change to:

date("d-m-Y", calcduedate(time(), 2))

And it works

Example of this function You can check on this (page).

Enjoy the code!