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');
