[MOD] Close ticket on Opening

michael.therrien

Someone's request for this feature has motivated me to create an option to close the ticket on submission. It's simple and here's the MOD:

In /include/staff/newticket.inc.php, ADD

<?//MOD by michael.therrien 7/30/09?>

<tr>

<td></td>

<td>

<input type="checkbox" name="openclosed" value="closed">Submit the ticket as closed.

</td>

</tr>

<?//END MOD?>

Above ~line 229:

<tr height=2px><td align="left" colspan=2 > </td</tr>

In /include/class.ticket.php, ADD:

//MOD by michael.therrien 7/30/09

var $openclosed;

Below ~line 45:

var $overdue;

and ADD:

//MOD by michael.therrien 7/30/09

if($var=="closed")

$sql.=',status=\'closed\',closed=NOW()';

Below ~line 1219:

$sql.=',duedate='.db_input(date('Y-m-d G',Misc:($var.' '.$var)));

Triple-Clones

1.6 rc5

Thanks for this MOD - I'm using with success, however I did have to make the following change:

if($var=="closed")

$sql.=',status='.db_input('closed').',closed=NOW()';

michael.therrien

Thanks!

I'm just curious what function this calls, is it just a filter? (I'd look but don't have the time currently)

Thanks!

~Mike

Thanks for this MOD - I'm using with success, however I did have to make the following change:
if($var=="closed")
$sql.=',status='.db_input('closed').',closed=NOW()';

Triple-Clones

it's in "include/mysql.php"

function db_input($param,$quote=true) {

//is_numeric doesn't work all the time...9e8 is considered numeric..which is correct...but not expected.

if($param && preg_match("/^\d+(\.\d+)?$/",$param))

return $param;

if($param && is_array($param)){

reset($param);

while (list($key, $value) = each($s)) {

$param = db_input($value,$quote);

}

return $param;

}

return db_real_escape($param,$quote);

}