* 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'] . ":"; }