function _1_created_HelpDesk($user_id, $mailDetail, $folder, $return) { $adb = PearDatabase::getInstance(); $result_user_id = $adb->pquery("SELECT crm_user_id FROM roundcube_users where user_id = ? ", array($user_id), true); $assigned_user_id = $adb->query_result($result_user_id, 0, 'crm_user_id'); $EmailNumPrefix = OSSMailScanner_Record_Model::findEmailNumPrefix('HelpDesk', $mailDetail['subject']); $result = $adb->pquery("SELECT ticketid FROM vtiger_troubletickets where ticket_no = ? ", array($EmailNumPrefix), true); $exceptionsAll = OSSMailScanner_Record_Model::getConfig('exceptions'); if (!empty($exceptionsAll['crating_tickets'])) { $exceptions = explode(',', $exceptionsAll['crating_tickets']); foreach ($exceptions as $exception) { if (strpos($mailDetail['fromaddress'], $exception) !== FALSE) { return ['created_HelpDesk' => '']; } } } if ($adb->num_rows($result) == 0) { $contact_id = OSSMailScanner_Record_Model::findEmail($mailDetail['fromaddress'], 'Contacts', false); $parent_id = OSSMailScanner_Record_Model::findEmail($mailDetail['fromaddress'], 'Accounts', false); $HelpDeskInstance = CRMEntity::getInstance('HelpDesk'); $HelpDeskInstance->column_fields['assigned_user_id'] = $assigned_user_id; $HelpDeskInstance->column_fields['ticket_title'] = $mailDetail['subject']; if ($contact_id && $contact_id != '' && $contact_id != '0') { $HelpDeskInstance->column_fields['contact_id'] = $contact_id; } if ($parent_id && $parent_id != '' && $parent_id != '0') { $HelpDeskInstance->column_fields['parent_id'] = $parent_id; $servicecontracts = $adb->pquery("SELECT servicecontractsid, priority FROM vtiger_servicecontracts where sc_related_to = ? ", array($parent_id)); if ($adb->num_rows($servicecontracts) == 1) { $HelpDeskInstance->column_fields['servicecontractsid'] = $adb->query_result($servicecontracts, 0, 'servicecontractsid'); $HelpDeskInstance->column_fields['ticketpriorities'] = $adb->query_result($servicecontracts, 0, 'priority'); } } $HelpDeskInstance->column_fields['description'] = strip_tags($mailDetail['body']); $HelpDeskInstance->column_fields['ticketstatus'] = 'Open'; $HelpDeskInstance->save('HelpDesk'); $id = $HelpDeskInstance->id; $result_ossmailview = $adb->pquery("SELECT ossmailviewid FROM vtiger_ossmailview where uid = ? ", array($mailDetail['message_id']), true); if ($adb->num_rows($result_ossmailview) > 0) { $ossmailviewid = $adb->query_result($result_ossmailview, 0, 'ossmailviewid'); $adb->pquery("INSERT INTO vtiger_crmentityrel SET crmid=?, module=?, relcrmid=?, relmodule=?", array($ossmailviewid, 'OSSMailView', $id, 'HelpDesk')); } $adb->pquery("UPDATE vtiger_crmentity SET createdtime = ?,smcreatorid = ?,modifiedby = ? WHERE crmid = ? ", array($mailDetail['udate_formated'], $assigned_user_id, $assigned_user_id, $id)); } return array('created_HelpDesk' => $id); }
function bind_prefix($user_id, $mail_detail, $folder, $moduleName, $table_name, $table_col) { $adb = PearDatabase::getInstance(); if ($mail_detail['ossmailviewid'] == '') { $result_ossmailview = $adb->pquery("SELECT ossmailviewid FROM vtiger_ossmailview where uid = ? AND rc_user = ? ", [$mail_detail['message_id'], $user_id]); if ($adb->num_rows($result_ossmailview) == 0) { return FALSE; } $mailViewId = $adb->query_result($result_ossmailview, 0, 'ossmailviewid'); } else { $mailViewId = $mail_detail['ossmailviewid']; } $relationExist = false; $relationExistResult = $adb->pquery("SELECT crmid FROM vtiger_ossmailview_relation WHERE ossmailviewid = ?;", [$mailViewId]); for ($i = 0; $i < $adb->num_rows($relationExistResult); $i++) { $crmid = $adb->query_result_raw($relationExistResult, $i, 'crmid'); $type = Vtiger_Functions::getCRMRecordType($crmid); if ($type == $moduleName) { $relationExist = TRUE; } } if ($relationExist) { return false; } $emailNumPrefix = OSSMailScanner_Record_Model::findEmailNumPrefix($moduleName, $mail_detail['subject']); if (!$emailNumPrefix) { return false; } require_once "modules/{$moduleName}/{$moduleName}.php"; $moduleObject = new $moduleName(); $tableIndex = $moduleObject->table_index; $return_id = []; $result = $adb->pquery("SELECT {$tableIndex} FROM " . $table_name . " INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = " . $table_name . "." . $tableIndex . " WHERE vtiger_crmentity.deleted = 0 AND " . $table_col . " = ? ", [$emailNumPrefix]); if ($adb->num_rows($result) > 0) { $crmid = $adb->getSingleValue($result); $resultRelation = $adb->pquery('SELECT * FROM vtiger_ossmailview_relation WHERE ossmailviewid=? AND crmid=?', [$mailViewId, $crmid]); if ($resultRelation->rowCount() == 0) { $adb->pquery('INSERT INTO vtiger_ossmailview_relation SET ossmailviewid=?, crmid=?, date=?', [$mailViewId, $crmid, $mail_detail['udate_formated']]); $return_id[] = $crmid; } } return $return_id; }