/** * Funtion that returns fields that will be showed in the record selection popup * @return <Array of fields> */ public function getPopupViewFieldsList($sourceModule = false) { if (!empty($sourceModule)) { $parentRecordModel = Vtiger_Module_Model::getInstance($sourceModule); $relationModel = Vtiger_Relation_Model::getInstance($parentRecordModel, $this); } $popupFields = array(); if ($relationModel) { $popupFields = $relationModel->getRelationFields(true); } if (count($popupFields) == 0) { $popupFileds = $this->getSummaryViewFieldsList(); foreach ($popupFileds as $fieldName => $fieldModel) { if ($fieldName === 'folderid' || $fieldName === 'modifiedtime') { unset($popupFileds[$fieldName]); } } $reqPopUpFields = array('File Status' => 'filestatus', 'File Size' => 'filesize', 'File Location Type' => 'filelocationtype'); foreach ($reqPopUpFields as $fieldLabel => $fieldName) { $fieldModel = Vtiger_Field_Model::getInstance($fieldName, $this); if ($fieldModel->getPermissions('readwrite')) { $popupFileds[$fieldName] = $fieldModel; } } $popupFields = array_keys($popupFileds); } return $popupFields; }
public function getRelatedModuleRecordIds(Vtiger_Request $request, $recordIds = []) { $db = PearDatabase::getInstance(); $basicModule = $request->getModule(); $relatedModules = $request->get('related_modules'); $parentModuleModel = Vtiger_Module_Model::getInstance($basicModule); $relatedIds = []; if (!empty($relatedModules)) { foreach ($relatedModules as $relModData) { $relModData = explode('::', $relModData); $relatedModule = $relModData[0]; $type = $relModData[1]; switch ($type) { case 0: $field = $relModData[2]; foreach ($recordIds as $recordId) { $recordModel = Vtiger_Record_Model::getInstanceById($recordId, $basicModule); if ($recordModel->get($field) != 0 && Vtiger_Functions::getCRMRecordType($recordModel->get($field)) == $relatedModule) { $relatedIds[] = $recordModel->get($field); } } break; case 1: $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $instance = CRMEntity::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModuleModel); $fieldModel = $relationModel->getRelationField(); $tablename = $fieldModel->get('table'); $tabIndex = $instance->table_index; $relIndex = $this->getRelatedFieldName($relatedModule, $basicModule); if (!$relIndex) { break; } $sql = "SELECT vtiger_crmentity.crmid FROM vtiger_crmentity INNER JOIN {$tablename} ON {$tablename}.{$tabIndex} = vtiger_crmentity.crmid\n\t\t\t\t\t\tWHERE {$tablename}.{$relIndex} IN (" . $db->generateQuestionMarks($recordIds) . ")"; $result = $db->pquery($sql, $recordIds); while ($crmid = $db->getSingleValue($result)) { $relatedIds[] = $crmid; } break; case 2: foreach ($recordIds as $recordId) { $recordModel = Vtiger_Record_Model::getInstanceById($recordId, $basicModule); $relationListView = Vtiger_RelationListView_Model::getInstance($recordModel, $relatedModule); $query = $relationListView->getRelationQuery(); $queryEx = explode('FROM', $query, 2); $query = 'SELECT DISTINCT vtiger_crmentity.crmid FROM' . $queryEx[1]; $result = $db->query($query); while ($crmid = $db->getSingleValue($result)) { $relatedIds[] = $crmid; } } break; } $relatedIds = array_unique($relatedIds); } } return $relatedIds; }
/** * Function to save record * @param <Vtiger_Request> $request - values of the record * @return <RecordModel> - record Model of saved record */ public function saveRecord($request) { $adb = PearDatabase::getInstance(); $recordModel = $this->getRecordModelFromRequest($request); $recordModel->save(); $originalRecordId = $recordModel->getId(); if ($request->get('relationOperation')) { $parentModuleName = $request->get('sourceModule'); $parentModuleModel = Vtiger_Module_Model::getInstance($parentModuleName); $parentRecordId = $request->get('sourceRecord'); $relatedModule = $recordModel->getModule(); if ($relatedModule->getName() == 'Events') { $relatedModule = Vtiger_Module_Model::getInstance('Calendar'); } $relatedRecordId = $recordModel->getId(); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModule); $relationModel->addRelation($parentRecordId, $relatedRecordId); } // Handled to save follow up event $followupMode = $request->get('followup'); //Start Date and Time values $startTime = Vtiger_Time_UIType::getTimeValueWithSeconds($request->get('followup_time_start')); $startDateTime = Vtiger_Datetime_UIType::getDBDateTimeValue($request->get('followup_date_start') . " " . $startTime); list($startDate, $startTime) = explode(' ', $startDateTime); $subject = $request->get('subject'); if ($followupMode == 'on' && $startTime != '' && $startDate != '') { $recordModel->set('eventstatus', 'Planned'); $recordModel->set('subject', '[Followup] ' . $subject); $recordModel->set('date_start', $startDate); $recordModel->set('time_start', $startTime); $currentUser = Users_Record_Model::getCurrentUserModel(); $activityType = $recordModel->get('activitytype'); if ($activityType == 'Call') { $minutes = $currentUser->get('callduration'); } else { $minutes = $currentUser->get('othereventduration'); } $dueDateTime = date('Y-m-d H:i:s', strtotime("{$startDateTime}+{$minutes} minutes")); list($startDate, $startTime) = explode(' ', $dueDateTime); $recordModel->set('due_date', $startDate); $recordModel->set('time_end', $startTime); $recordModel->set('recurringtype', ''); $recordModel->set('mode', 'create'); $recordModel->save(); $heldevent = true; } //TODO: remove the dependency on $_REQUEST if ($_REQUEST['recurringtype'] != '' && $_REQUEST['recurringtype'] != '--None--') { vimport('~modules/Calendar/RepeatEvents.php'); $focus = new Activity(); //get all the stored data to this object $focus->column_fields = $recordModel->getData(); Calendar_RepeatEvents::repeatFromRequest($focus); } return $recordModel; }
function addRelation($request) { $sourceModule = $request->getModule(); $sourceRecordId = $request->get('src_record'); $relatedModule = $request->get('related_module'); $relatedRecordIdList = $request->get('related_record_list'); $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); foreach ($relatedRecordIdList as $relatedRecordId) { $relationModel->addRelation($sourceRecordId, $relatedRecordId, $listPrice); } }
/** * Function adds Products/Services-PriceBooks Relation * @param type $request */ function addListPrice($request) { $sourceModule = $request->getModule(); $sourceRecordId = $request->get('src_record'); $relatedModule = $request->get('related_module'); $relInfos = $request->get('relinfo'); $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); foreach ($relInfos as $relInfo) { $price = CurrencyField::convertToDBFormat($relInfo['price'], null, true); $relationModel->addListPrice($sourceRecordId, $relInfo['id'], $price); } }
/** * Function to save record * @param <Vtiger_Request> $request - values of the record * @return <RecordModel> - record Model of saved record */ public function saveRecord($request) { $recordModel = $this->getRecordModelFromRequest($request); $recordModel->save(); if ($request->get('relationOperation')) { $parentModuleName = $request->get('sourceModule'); $parentModuleModel = Vtiger_Module_Model::getInstance($parentModuleName); $parentRecordId = $request->get('sourceRecord'); $relatedModule = $recordModel->getModule(); $relatedRecordId = $recordModel->getId(); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModule); $relationModel->addRelation($parentRecordId, $relatedRecordId); } return $recordModel; }
/** * Function to delete the relation for specified source record id and related record id list * @param <array> $request * keys Content * src_module source module name * src_record source record id * related_module related module name * related_record_list json encoded of list of related record ids */ function deleteRelation($request) { $sourceModule = $request->getModule(); $sourceRecordId = $request->get('src_record'); $relatedModule = $request->get('related_module'); $relatedRecordIdList = $request->get('related_record_list'); //Setting related module as current module to delete the relation vglobal('currentModule', $relatedModule); $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); foreach ($relatedRecordIdList as $relatedRecordId) { $response = $relationModel->deleteRelation($sourceRecordId, $relatedRecordId); } echo $response; }
/** * Function to update Relation status * @param Vtiger_Request $request */ public function updateStatus(Vtiger_Request $request) { $relatedModuleName = $request->get('relatedModule'); $relatedRecordId = $request->get('relatedRecord'); $status = $request->get('status'); $response = new Vtiger_Response(); if ($relatedRecordId && $status && $status < 5) { $sourceModuleModel = Vtiger_Module_Model::getInstance($request->getModule()); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModuleName); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); $relationModel->updateStatus($request->get('sourceRecord'), array($relatedRecordId => $status)); $response->setResult(array(true)); } else { $response->setError($code); } $response->emit(); }
function addRelation($request) { $sourceModule = $request->getModule(); $sourceRecordId = $request->get('src_record'); $relatedModule = $request->get('related_module'); if (is_numeric($relatedModule)) { $relatedModule = Vtiger_Functions::getModuleName($relatedModule); } $relatedRecordIdList = $request->get('related_record_list'); $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); foreach ($relatedRecordIdList as $relatedRecordId) { $relationModel->addRelation($sourceRecordId, $relatedRecordId, $listPrice); } $response = new Vtiger_Response(); $response->setResult(true); $response->emit(); }
/** * Function to save record * @param <Vtiger_Request> $request - values of the record * @return <RecordModel> - record Model of saved record */ public function saveRecord($request) { $recordModel = $this->getRecordModelFromRequest($request); $recordModel->save(); if ($request->get('relationOperation')) { $parentModuleName = $request->get('sourceModule'); $parentModuleModel = Vtiger_Module_Model::getInstance($parentModuleName); $parentRecordId = $request->get('sourceRecord'); $relatedModule = $recordModel->getModule(); $relatedRecordId = $recordModel->getId(); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModule); $relationModel->addRelation($parentRecordId, $relatedRecordId); //To store the relationship between Products/Services and PriceBooks if ($parentRecordId && ($parentModuleName === 'Products' || $parentModuleName === 'Services')) { $parentRecordModel = Vtiger_Record_Model::getInstanceById($parentRecordId, $parentModuleName); $recordModel->updateListPrice($parentRecordId, $parentRecordModel->get('unit_price')); } } return $recordModel; }
function addRelation($request) { $sourceModule = $request->getModule(); $sourceRecordId = $request->get('src_record'); $relatedModule = $request->get('related_module'); $relatedRecordIdList = $request->get('related_record_list'); $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); foreach ($relatedRecordIdList as $relatedRecordId) { $relationModel->addRelation($sourceRecordId, $relatedRecordId, $listPrice); if ($relatedModule == 'PriceBooks') { $recordModel = Vtiger_Record_Model::getInstanceById($relatedRecordId); if ($sourceRecordId && ($sourceModule === 'Products' || $sourceModule === 'Services')) { $parentRecordModel = Vtiger_Record_Model::getInstanceById($sourceRecordId, $sourceModule); $recordModel->updateListPrice($sourceRecordId, $parentRecordModel->get('unit_price')); } } } }
/** * Function to save record * @param <Vtiger_Request> $request - values of the record * @return <RecordModel> - record Model of saved record */ public function saveRecord($request) { $recordModel = $this->getRecordModelFromRequest($request); $recordModel->save(); if ($request->get('relationOperation')) { $parentModuleName = $request->get('sourceModule'); $parentModuleModel = Vtiger_Module_Model::getInstance($parentModuleName); $parentRecordId = $request->get('sourceRecord'); $relatedModule = $recordModel->getModule(); $relatedRecordId = $recordModel->getId(); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModule); $relationModel->addRelation($parentRecordId, $relatedRecordId); } if ($request->get('imgDeleted')) { $imageIds = $request->get('imageid'); foreach ($imageIds as $imageId) { $status = $recordModel->deleteImage($imageId); } } return $recordModel; }
/** * Funtion that returns fields that will be showed in the record selection popup * @return <Array of fields> */ public function getPopupViewFieldsList($sourceModule = false) { if (!empty($sourceModule)) { $parentRecordModel = Vtiger_Module_Model::getInstance($sourceModule); $relationModel = Vtiger_Relation_Model::getInstance($parentRecordModel, $this); } $popupFields = array(); if ($relationModel) { $popupFields = $relationModel->getRelationFields(true); } if (count($popupFields) == 0) { $popupFileds = $this->getSummaryViewFieldsList(); $reqPopUpFields = array('Currency' => 'currency_id'); foreach ($reqPopUpFields as $fieldLabel => $fieldName) { $fieldModel = Vtiger_Field_Model::getInstance($fieldName, $this); if ($fieldModel->getPermissions('readwrite')) { $popupFileds[$fieldName] = $fieldModel; } } $popupFields = array_keys($popupFileds); } return $popupFields; }
public static function getInstance($parentRecordModel, $relationModuleName, $label = false) { $parentModuleName = $parentRecordModel->getModule()->get('name'); $className = Vtiger_Loader::getComponentClassName('Model', 'RelationListView', $parentModuleName); $instance = new $className(); $parentModuleModel = $parentRecordModel->getModule(); $relationModuleModel = Vtiger_Module_Model::getInstance($relationModuleName); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relationModuleModel, $label); $instance->setRelationModel($relationModel)->setParentRecordModel($parentRecordModel); return $instance; }
public static function getInstance($parentRecordModel, $relationModuleName, $label = false) { $parentModuleName = $parentRecordModel->getModule()->get('name'); $className = Vtiger_Loader::getComponentClassName('Model', 'RelationListView', $parentModuleName); $instance = new $className(); $parentModuleModel = $parentRecordModel->getModule(); $relatedModuleModel = Vtiger_Module_Model::getInstance($relationModuleName); $instance->setRelatedModuleModel($relatedModuleModel); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModuleModel, $label); $instance->setParentRecordModel($parentRecordModel); if (!$relationModel) { $relatedModuleName = $relatedModuleModel->getName(); $parentModuleModel = $instance->getParentRecordModel()->getModule(); $referenceFieldOfParentModule = $parentModuleModel->getFieldsByType('reference'); foreach ($referenceFieldOfParentModule as $fieldName => $fieldModel) { $refredModulesOfReferenceField = $fieldModel->getReferenceList(); if (in_array($relatedModuleName, $refredModulesOfReferenceField)) { $relationModelClassName = Vtiger_Loader::getComponentClassName('Model', 'Relation', $parentModuleModel->getName()); $relationModel = new $relationModelClassName(); $relationModel->setParentModuleModel($parentModuleModel)->setRelationModuleModel($relatedModuleModel); $parentModuleModel->set('directRelatedFieldName', $fieldModel->get('column')); } } } if (!$relationModel) { $relationModel = false; } $instance->setRelationModel($relationModel); return $instance; }
/** * Function to save record * @param <Vtiger_Request> $request - values of the record * @return <RecordModel> - record Model of saved record */ public function saveRecord($request) { $recordId = $request->get('record'); $recordModel = $this->getRecordModelFromRequest($request); $mode = $recordModel->get('mode'); $adb = PearDatabase::getInstance(); // check if encryption is enabled $config == false; if (file_exists('modules/OSSPasswords/config.ini.php')) { $config = parse_ini_file('modules/OSSPasswords/config.ini.php'); } //check if password was edited with hidden password $properPassword = $recordModel->get('password'); // edit mode if ($recordId != '' && $mode == 'edit') { if ($properPassword == '**********') { // hidden password sent in edit mode, get the correct one if ($config) { // when encryption is on $sql = "SELECT AES_DECRYPT(`password`, '" . $config['key'] . "') AS pass FROM `vtiger_osspasswords` WHERE `osspasswordsid` = ?;"; $result = $adb->pquery($sql, array($recordId), true); $properPassword = $adb->query_result($result, 0, 'pass'); } else { // encryption mode is off $sql = "SELECT `password` AS pass FROM `vtiger_osspasswords` WHERE `osspasswordsid` = ?;"; $result = $adb->pquery($sql, array($recordId), true); $properPassword = $adb->query_result($result, 0, 'pass'); } } $recordModel->set('password', $properPassword); $recordModel->save(); // after save we check if encryption is active if ($config) { $sql = "UPDATE `vtiger_osspasswords` SET `password` = AES_ENCRYPT(?,?) WHERE `osspasswordsid` = ?;"; $result = $adb->pquery($sql, array($properPassword, $config['key'], $recordId), true); } } else { if ($recordId == '' && $mode == '') { $recordModel->save(); // if encryption mode is on we will encrypt the password $recordId = $recordModel->get('id'); if ($config) { // when encryption is on $sql = "UPDATE `vtiger_osspasswords` SET `password` = AES_ENCRYPT(`password`, ?) WHERE `osspasswordsid` = ?;"; $result = $adb->pquery($sql, array($config['key'], $recordId), true); } } } if ($request->get('relationOperation')) { $parentModuleName = $request->get('sourceModule'); $parentModuleModel = Vtiger_Module_Model::getInstance($parentModuleName); $parentRecordId = $request->get('sourceRecord'); $relatedModule = $recordModel->getModule(); $relatedRecordId = $recordModel->getId(); $relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModule); $relationModel->addRelation($parentRecordId, $relatedRecordId); } return $recordModel; }
/** * Function to get popup view fields */ public function getPopupViewFieldsList($sourceModule = false) { $parentRecordModel = Vtiger_Module_Model::getInstance($sourceModule); if (!empty($sourceModule) && $parentRecordModel) { $relationModel = Vtiger_Relation_Model::getInstance($parentRecordModel, $this); } $popupFields = array(); if ($relationModel) { $popupFields = $relationModel->getRelationFields(true); } if (count($popupFields) == 0) { $popupFields = array_keys($this->getSummaryViewFieldsList()); } if (count($popupFields) == 0) { $popupFields = array_values($this->getRelatedListFields()); } return $popupFields; }
public function convertToNativeLink() { $url = $this->get('linkurl'); if (empty($url)) { return $url; } //Check if the link is not javascript if (!$this->isPageLoadLink()) { //To convert single quotes and double quotes $url = Vtiger_Util_Helper::toSafeHTML($url); return $url; } $module = false; $sourceModule = false; $sourceRecord = false; $parametersParts = explode('&', $url); foreach ($parametersParts as $index => $keyValue) { $urlParts = explode('=', $keyValue); $key = $urlParts[0]; $value = $urlParts[1]; if (strcmp($key, 'module') == 0) { $module = $value; } if (strcmp($key, 'action') == 0) { if (strpos($value, 'View')) { $value = str_replace('View', '', $value); $key = 'view'; } } if (strcmp($key, 'return_module') == 0) { $key = 'sourceModule'; //Indicating that it is an relation operation $parametersParts[] = 'relationOperation=true'; } if (strcmp($key, 'return_id') == 0) { $key = 'sourceRecord'; } if (strcmp($key, 'sourceRecord') == 0) { $sourceRecord = $value; } if (strcmp($key, 'sourceModule') == 0) { $sourceModule = $value; } $newUrlParts = array(); array_push($newUrlParts, $key); array_push($newUrlParts, $value); $parametersParts[$index] = implode('=', $newUrlParts); } //to append the reference field in one to many relation if (!empty($module) && !empty($sourceModule) && !empty($sourceRecord)) { $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($module); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); if ($relationModel->isDirectRelation()) { $fieldList = $relatedModuleModel->getFields(); foreach ($fieldList as $fieldName => $fieldModel) { if ($fieldModel->getFieldDataType() == Vtiger_Field_Model::REFERENCE_TYPE) { $referenceList = $fieldModel->getReferenceList(); if (in_array($sourceModuleModel->get('name'), $referenceList)) { $parametersParts[] = $fieldModel->get('name') . '=' . $sourceRecord; } } } } } $url = implode('&', $parametersParts); //To convert single quotes and double quotes $url = Vtiger_Util_Helper::toSafeHTML($url); return $url; }
public function isDeletable() { $srcModuleModel = Vtiger_Module_Model::getInstance($this->get('srcModule')); $relationModel = Vtiger_Relation_Model::getInstance($srcModuleModel, $this->get('module')); return $relationModel->isDeletable(); }
/** * Function to update the relation for specified source record id and related record id list * @param <array> $request * keys Content * src_module source module name * src_record source record id * related_module related module name * toRemove list of related record to remove * toAdd list of related record to add */ function updateRelation(Vtiger_Request $request) { $sourceModule = $request->getModule(); $sourceRecordId = $request->get('src_record'); $relatedModule = $request->get('related_module'); $toRemove = $request->get('toRemove'); $toAdd = $request->get('toAdd'); vglobal('currentModule', $sourceModule); $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); if (!empty($toAdd)) { foreach ($toAdd as $relatedRecordId) { if (substr($relatedRecordId, 0, 1) != 'T') { $relationModel->addRelation($sourceRecordId, $relatedRecordId); } } } if (!empty($toRemove)) { foreach ($toRemove as $relatedRecordId) { if (substr($relatedRecordId, 0, 1) != 'T') { $relationModel->deleteRelation($sourceRecordId, $relatedRecordId); } } } $response = new Vtiger_Response(); $response->setResult(true); $response->emit(); }
function updateFavoriteForRecord(Vtiger_Request $request) { $sourceModule = $request->getModule(); $relatedModule = $request->get('relatedModule'); $actionMode = $request->get('actionMode'); $sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); $relatedModuleModel = Vtiger_Module_Model::getInstance($relatedModule); $relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $relatedModuleModel); if (!empty($relationModel)) { $result = $relationModel->updateFavoriteForRecord($actionMode, ['crmid' => $request->get('record'), 'relcrmid' => $request->get('relcrmid')]); } $response = new Vtiger_Response(); $response->setResult((bool) $result); $response->emit(); }