$name = $_SESSION['id']['user']; } else { $name = $ticket['name']; } // Insert reply into database hesk_dbQuery("INSERT INTO `" . hesk_dbEscape($hesk_settings['db_pfix']) . "replies` (`replyto`,`name`,`message`,`dt`,`attachments`) VALUES ({$ticket['id']},'" . hesk_dbEscape($name) . "','" . hesk_dbEscape($message) . "',NOW(),'" . hesk_dbEscape($myattachments) . "')"); /*** Need to notify any staff? ***/ // --> Prepare reply message // 1. Generate the array with ticket info that can be used in emails $info = array('email' => $ticket['email'], 'category' => $ticket['category'], 'priority' => $ticket['priority'], 'owner' => $ticket['owner'], 'trackid' => $ticket['trackid'], 'status' => $ticket['status'], 'name' => $ticket['name'], 'lastreplier' => $ticket['name'], 'subject' => $ticket['subject'], 'message' => stripslashes($message), 'attachments' => $myattachments, 'dt' => hesk_date($ticket['dt'], true), 'lastchange' => hesk_date($ticket['lastchange'], true), 'id' => $ticket['id']); //insert to ERP ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// include 'oe_api.php'; $valid_services = array("SCA" => "mail.message", "PIS" => "project.issue"); //klasat e ERP me te cilat do te punojme $oeapi = new OpenerpApi(); $params1 = array(); // array me vlerat e ticket_id $params = array(); // array me vlerat e reply_message $params1[0] = $ticket['id']; $data = $oeapi->search_helpdeskID($valid_services["PIS"], $ticket['id']); // gjejme ceshtjen ky helpdesk_id = ticket_id //Ermedita - lista e emaileve te staffit qe jan te lidhur me ceshtjen $issue_id = hesk_dbQuery("SELECT `contract_ticket_id` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "tickets` WHERE `id`=" . $ticket['id']); $i_id = mysqli_fetch_array($issue_id); $users = hesk_dbQuery("SELECT `userId` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "userforcontract` WHERE `contractId`=" . $i_id[0]); $u = array(); while ($user = mysqli_fetch_array($users)) { $u[] = $user['userId']; }
$ticket = hesk_newTicket($tmpvar); //insert to ERP ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// include 'oe_api.php'; $valid_services = array("SCA" => "project.issue"); //klasat e ERP me te cilat do te punojme $params = array(); $params['name'] = hesk_POST('subject'); $params['description'] = hesk_POST('message'); $params['email_from'] = hesk_POST('email'); $params['priority'] = hesk_POST('priority'); $params['categ_id'] = hesk_POST('category'); $params['cp_issue_type'] = "helpdesk"; $params['helpdesk_id'] = $ticket['id']; $params['project_id'] = 3; $oeapi = new OpenerpApi(); //create object $data = $oeapi->create_record($params, $valid_services["SCA"]); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Notify the customer if ($hesk_settings['notify_new']) { //Ermedita - send email to assigned staff depending on Contracts $users = hesk_dbQuery("SELECT `userId` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "userforcontract` WHERE `contractId`=" . hesk_POST('contract_name')); $u = array(); while ($user = mysqli_fetch_array($users)) { $u[] = $user['userId']; } $ulist = implode(',', $u); $u_emails = hesk_dbQuery("SELECT `email` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` WHERE `id` IN (" . $ulist . ")"); //ndertojme template e emailit ne rastin kur SKA probleme $email_body = "<p> Përshendetje,</p>" . "<p> U Hap Ceshtja: " . hesk_POST('subject') . " me ID: " . $ticket['id'] . "</p>";