pquery("INSERT INTO vtiger_mailmanager_mailrel (mailuid, emailid, crmid) VALUES (?,?,?)", array($mailuid, $emailid, $crmid)); } static function lookupMailInVtiger($searchTerm, $user) { $handler = vtws_getModuleHandlerFromName('Emails', $user); $meta = $handler->getMeta(); $moduleFields = $meta->getModuleFields(); $parentIdFieldInstance = $moduleFields['parent_id']; $referenceModules = $parentIdFieldInstance->getReferenceList(); $filteredResult = array(); foreach($referenceModules as $referenceModule) { $referenceModuleHandler = vtws_getModuleHandlerFromName($referenceModule, $user); $referenceModuleMeta = $referenceModuleHandler->getMeta(); $referenceModuleEmailFields = $referenceModuleMeta->getEmailFields(); $referenceModuleEntityFields = $referenceModuleMeta->getNameFields(); $referenceModuleEntityFieldsArray = explode(',', $referenceModuleEntityFields); $searchFieldList = array_merge($referenceModuleEmailFields, $referenceModuleEntityFieldsArray); if(!empty($searchFieldList) && !empty($referenceModuleEmailFields)) { $searchFieldListString = implode(',', $referenceModuleEmailFields); $where = null; for($i=0; $i $record[$searchField], 'name'=>$record[$searchField]." - ".getTranslatedString($referenceModule), 'record'=>$record['id']); } } } } } return $filteredResult; } static function lookupMailAssociation($mailuid) { global $adb; // Mail could get associated with two-or-more records if they get deleted after linking. $result = $adb->pquery( "SELECT vtiger_mailmanager_mailrel.* FROM vtiger_mailmanager_mailrel INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_mailmanager_mailrel.crmid AND vtiger_crmentity.deleted=0 AND vtiger_mailmanager_mailrel.mailuid=? LIMIT 1", array(decode_html($mailuid))); if ($adb->num_rows($result)) { $resultrow = $adb->fetch_array($result); return $resultrow; } return false; } static function lookupVTEMailAssociation($emailId) { global $adb; $result = $adb->pquery( "SELECT vtiger_mailmanager_mailrel.* FROM vtiger_mailmanager_mailrel INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_mailmanager_mailrel.crmid AND vtiger_crmentity.deleted=0 AND vtiger_mailmanager_mailrel.mailuid=? LIMIT 1", array(decode_html($mailuid))); if ($adb->num_rows($result)) { $resultrow = $adb->fetch_array($result); return $resultrow; } return false; } static function checkModuleWriteAccessForCurrentUser($module) { global $current_user; if (isPermitted($module, 'EditView') == "yes" && vtlib_isModuleActive($module)) { return true; } return false; } /** * function to check the read access for the current user * @global Users Instance $current_user * @param String $module - Name of the module * @return Boolean */ static function checkModuleReadAccessForCurrentUser($module) { global $current_user; if (isPermitted($module, 'DetailView') == "yes" && vtlib_isModuleActive($module)) { return true; } return false; } /** * Invoked when special actions are performed on the module. * @param String $modulename - Module name * @param String $event_type - Event Type (module.postinstall, module.disabled, module.enabled, module.preuninstall) */ function vtlib_handler($modulename, $event_type) { if($event_type == 'module.postinstall') { // TODO Handle actions when this module is installed. } else if($event_type == 'module.disabled') { // TODO Handle actions when this module is disabled. } else if($event_type == 'module.enabled') { // TODO Handle actions when this module is enabled. } else if($event_type == 'module.preuninstall') { // TODO Handle actions when this module is about to be deleted. } else if($event_type == 'module.preupdate') { // TODO Handle actions before this module is updated. } else if($event_type == 'module.postupdate') { // TODO Handle actions when this module is updated. } } } ?>