function applyChange() { global $adb; if ($this->hasError()) { $this->sendError(); } if ($this->isApplied()) { $this->sendMsg('Changeset ' . get_class($this) . ' already applied!'); } else { global $adb; $vendorsInstance = Vtiger_Module::getInstance('Vendors'); $blockInstance = Vtiger_Block::getInstance('LBL_VENDOR_INFORMATION', $vendorsInstance); $field = Vtiger_Field::getInstance('assigned_user_id', $vendorsInstance); if ($field) { $this->ExecuteQuery('update vtiger_field set presence=2 where fieldid=' . $field->id); } else { $field = new Vtiger_Field(); $field->name = 'assigned_user_id'; $field->label = 'Assigned To'; $field->table = 'vtiger_crmentity'; $field->column = 'smownerid'; $field->columntype = 'INT(11)'; $field->uitype = 53; $field->displaytype = 1; $field->typeofdata = 'V~M'; $field->presence = 2; $field->quickcreate = 0; $field->quicksequence = 5; $blockInstance->addField($field); // Allow Sharing access and role-based security for Vendors Vtiger_Access::deleteSharing($vendorsInstance); Vtiger_Access::initSharing($vendorsInstance); Vtiger_Access::allowSharing($vendorsInstance); Vtiger_Access::setDefaultSharing($vendorsInstance); } $this->sendMsg('Changeset ' . get_class($this) . ' applied!'); $this->markApplied(); } $this->finishExecution(); }
function applyChange() { if ($this->hasError()) { $this->sendError(); } if ($this->isApplied()) { $this->sendMsg('Changeset ' . get_class($this) . ' already applied!'); } else { $emailsInstance = Vtiger_Module::getInstance('Emails'); // Allow Sharing access and role-based security for Vendors Vtiger_Access::deleteSharing($emailsInstance); Vtiger_Access::initSharing($emailsInstance); Vtiger_Access::allowSharing($emailsInstance); Vtiger_Access::setDefaultSharing($emailsInstance, 'private'); Vtiger_Profile::initForModule($emailsInstance); // Email Reporting - set reports to public because access is private by default and configurable now $emrpts = "UPDATE vtiger_report SET sharingtype='Public' WHERE reportname in ('Contacts Email Report','Accounts Email Report','Leads Email Report','Vendors Email Report')"; $this->ExecuteQuery($emrpts, array()); $this->sendMsg('Changeset ' . get_class($this) . ' applied!'); $this->markApplied(); } $this->finishExecution(); }
/** * Disallow module sharing control */ function disallowSharing() { Vtiger_Access::allowSharing($this, false); }
$vendorBlock = Vtiger_Block::getInstance('LBL_VENDOR_INFORMATION', $vendorInstance); $vendorAssignedToField = new Vtiger_Field(); $vendorAssignedToField->name = 'assigned_user_id'; $vendorAssignedToField->label = 'Assigned To'; $vendorAssignedToField->table = 'vtiger_crmentity'; $vendorAssignedToField->column = 'smownerid'; $vendorAssignedToField->uitype = 53; $vendorAssignedToField->typeofdata = 'V~M'; $vendorBlock->addField($vendorAssignedToField); $vendorAllFilter = Vtiger_Filter::getInstance('All', $vendorInstance); $vendorAllFilter->addField($vendorAssignedToField, 5); } // Allow Sharing access and role-based security for Vendors Vtiger_Access::deleteSharing($vendorInstance); Vtiger_Access::initSharing($vendorInstance); Vtiger_Access::allowSharing($vendorInstance); Vtiger_Access::setDefaultSharing($vendorInstance); Vtiger_Module::syncfile(); // Add Email Opt-out for Leads $leadsInstance = Vtiger_Module::getInstance('Leads'); $leadsOptOutField = Vtiger_Field::getInstance('emailoptout', $leadsInstance); if (!$leadsOptOutField) { $leadsOptOutField = new Vtiger_Field(); $leadsOptOutField->name = 'emailoptout'; $leadsOptOutField->label = 'Email Opt Out'; $leadsOptOutField->table = 'vtiger_leaddetails'; $leadsOptOutField->column = $leadsOptOutField->name; $leadsOptOutField->columntype = 'VARCHAR(3)'; $leadsOptOutField->uitype = 56; $leadsOptOutField->typeofdata = 'C~O'; $leadsInformationBlock = Vtiger_Block::getInstance('LBL_LEAD_INFORMATION', $leadsInstance);
ExecutePQuery("UPDATE vtiger_cvadvfilter SET columnname=? WHERE columnname=?", array($newProductHandlerColumnName, $oldProductHandlerColumnName)); ExecuteQuery("UPDATE vtiger_crmentity, vtiger_service SET vtiger_crmentity.smownerid = vtiger_service.handler WHERE vtiger_crmentity.crmid = vtiger_service.serviceid"); ExecuteQuery("ALTER TABLE vtiger_service DROP COLUMN handler"); ExecutePQuery("UPDATE vtiger_field SET columnname = 'smownerid', tablename = 'vtiger_crmentity', uitype = '53', typeofdata = 'V~M', info_type = 'BAS', quickcreate = 0, quickcreatesequence = 4\r\n\t\t\t\tWHERE columnname = 'handler' AND tablename = 'vtiger_service' AND tabid = ?", array($servicesTabId)); $oldServiceOwnerColumnName = 'vtiger_service:handler:assigned_user_id:Services_Owner:V'; $newServiceOwnerColumnName = 'vtiger_crmentity:smownerid:assigned_user_id:Services_Owner:V'; ExecutePQuery("UPDATE vtiger_cvcolumnlist SET columnname=? WHERE columnname=?", array($newServiceOwnerColumnName, $oldServiceOwnerColumnName)); ExecutePQuery("UPDATE vtiger_cvadvfilter SET columnname=? WHERE columnname=?", array($newServiceOwnerColumnName, $oldServiceOwnerColumnName)); // Allow Sharing access and role-based security for Products and Services Vtiger_Access::deleteSharing($productInstance); Vtiger_Access::initSharing($productInstance); Vtiger_Access::allowSharing($productInstance); Vtiger_Access::setDefaultSharing($productInstance); Vtiger_Access::deleteSharing($serviceInstance); Vtiger_Access::initSharing($serviceInstance); Vtiger_Access::allowSharing($serviceInstance); Vtiger_Access::setDefaultSharing($serviceInstance); Vtiger_Module::syncfile(); /* Replace 'Handler' field with 'Assigned to' field for Products and Services - ends */ ExecutePQuery("UPDATE vtiger_entityname SET fieldname = 'firstname,lastname' WHERE tabid= ? ", array($contactTab)); ExecutePQuery("UPDATE vtiger_entityname SET fieldname = 'firstname,lastname' WHERE tabid= ? ", array($leadTab)); ExecutePQuery("UPDATE vtiger_entityname SET fieldname = 'first_name,last_name' WHERE tabid= ? ", array($usersTab)); require_once 'include/utils/utils.php'; $usersQuery = "SELECT * FROM vtiger_users"; $usersResult = $adb->query($usersQuery); $usersCount = $adb->num_rows($usersResult); for ($i = 0; $i < $usersCount; ++$i) { $userId = $adb->query_result($usersResult, $i, 'id'); $userName = $adb->query_result($usersResult, $i, 'user_name'); $firstName = $adb->query_result($usersResult, $i, 'first_name'); $lastName = $adb->query_result($usersResult, $i, 'last_name');