* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*
********************************************************************************/
require_once "modules/Faq/Faq.php";
$focus = new FAQ();
//Map the vtiger_fields like ticket column => vtiger_faq column where ticket column is the troubletikcets vtiger_field name & vtiger_faq - column_fields
$ticket_faq_mapping_fields = array('title' => 'question', 'product_id' => 'product_id', 'description' => 'faq_answer');
$sql = " select ticketid, title, product_id,vtiger_crmentity.description, solution,vtiger_troubletickets.status, category from vtiger_troubletickets inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_troubletickets.ticketid where ticketid=?";
$res = $adb->pquery($sql, array($_REQUEST['record']));
//set all the ticket values to FAQ
foreach ($ticket_faq_mapping_fields as $ticket_column => $faq_column) {
$focus->column_fields[$faq_column] = $adb->query_result($res, 0, $ticket_column);
}
$focus->save("Faq");
if ($focus->id != '') {
$description = $adb->query_result($res, 0, 'description');
$solution = $adb->query_result($res, 0, 'solution');
//Add the solution of the ticket with the FAQ answer
$answer = $description;
if ($solution != '') {
$answer .= "\r\n\r\n" . $app_strings['LBL_SOLUTION'] . ":\r\n" . $solution;
}
//Retrive the ticket comments from the vtiger_ticketcomments vtiger_table and added into the vtiger_faq answer
$sql = "select ticketid, comments, createdtime from vtiger_ticketcomments where ticketid=?";
$res = $adb->pquery($sql, array($_REQUEST['record']));
$noofrows = $adb->num_rows($res);
if ($noofrows > 0) {
$answer .= "\r\n\r\n" . $app_strings['LBL_COMMENTS'] . ":";
}
