I saw the modifications for tracking time on the ticket level, but I want to do things a little differently and track it on the ticket response level.
I've added a "billablehours" field, type double to the ost_ticket_response table.
on the staff/viewticket.inc.php file I added
Billable Hours:
to this form
#reply" name="reply" id="replyform" method="post" enctype="multipart/form-data">
next under tickets.php (line 85) I changed this:
if(!$errors && ($respId=$ticket->postResponse($_POST,$_POST,$_POST,$_FILES,$_POST)))
and last under class.ticket.php
I made this alteration:
function postResponse($msgid,$response,$signature='none',$attachment=false,$canalert=true,$billablehours=0){
global $thisuser,$cfg;
if(!$thisuser || !$thisuser->getId() || !$thisuser->isStaff()) //just incase
return 0;
$sql= 'INSERT INTO '.TICKET_RESPONSE_TABLE.' SET created=NOW() '.
',billablehours='.db_input($billablehours).
',ticket_id='.db_input($this->getId()).
',msg_id='.db_input($msgid).
',response='.db_input(Format:($response)).
',staff_id='.db_input($thisuser->getId()).
',staff_name='.db_input($thisuser->getName()).
',ip_address='.db_input($thisuser->getIP());
$resp_id=0;
Let me also explain, I am not a PHP developer, I've never done anything in PHP, just CF. I know if I change',billablehours=5'. it writes the message and the hours in there with no problem... I guess I am just not passing the field or parsing it properly. Any help would be appreciated.
The reason why I did it like this is because I will compile my bills at the end of each week regardless if the ticket is closed or not. I want to be able to bill for the services performed.
steve
