/**
* executing preimporting changes to target core
* @return void
*/
protected function prepare()
{
//update template types
DB\dbQuery("ALTER TABLE `templates`\n CHANGE `type` `type` enum('case','object','file','task','user','email','template','field','search','comment','shortcut','menu')\n COLLATE utf8_general_ci NULL after `is_folder`") or die(DB\dbQueryError());
// set templates template id in config
$ids = DM\Templates::getIdsByType('template');
$id = array_shift($ids);
BBM::$cfg['templatesTemplateId'] = $id;
$this->cfg['templates']['Menu rule']['fields']['template_ids']['cfg']['templates'] = $id;
$this->cfg['templates']['Menu rule']['fields']['menu']['cfg']['templates'] = $id;
// detect fields template id
$ids = DM\Templates::getIdsByType('field');
$id = array_shift($ids);
BBM::$cfg['fieldTemplateId'] = $id;
//detect folderTemplateId
$ids = Config::get('folder_templates');
if (!empty($ids)) {
BBM::$cfg['folderTemplateId'] = array_shift($ids);
}
//create "Menu" folder under templates to store our menu templates there
//and update BBM::$cfg['templatesFolderId'] to our folder id
$o = new \CB\Objects\Object();
$rootId = Browser::getRootFolderId();
$pid = Objects::getChildId($rootId, 'Templates');
if (empty($pid)) {
$pid = Objects::getChildId($rootId, 'System');
if (!empty($pid)) {
$pid = Objects::getChildId($pid, 'Templates');
}
}
$id = $o->create(array('id' => null, 'pid' => $pid, 'template_id' => BBM::$cfg['folderTemplateId'], 'name' => 'Menu', 'data' => array('_title' => 'Menu')));
BBM::$cfg['templatesFolderId'] = $id;
//create System/Menus folder for transferring menu rules to it
$pid = Objects::getChildId($rootId, 'System');
if (empty($pid)) {
$pid = $o->create(array('id' => null, 'pid' => $rootId, 'template_id' => BBM::$cfg['folderTemplateId'], 'name' => 'System', 'data' => array('_title' => 'System')));
}
$this->cfg['menusFolderId'] = $o->create(array('id' => null, 'pid' => $pid, 'template_id' => BBM::$cfg['folderTemplateId'], 'name' => 'Menus', 'data' => array('_title' => 'Menus')));
}
/**
* update create menus
* @return void
*/
protected function updateCreateMenus()
{
$rootId = \CB\Browser::getRootFolderId();
$pid = Objects::getChildId($rootId, 'System');
if (!empty($pid)) {
$pid = Objects::getChildId($pid, 'Menus');
if (!empty($pid)) {
$res = DB\dbQuery('SELECT id
FROM tree
WHERE pid = $1
AND dstatus = 0', $pid) or die(DB\dbQueryError());
if ($r = $res->fetch_assoc()) {
$o = Objects::getCachedObject($r['id']);
$d = $o->getData();
$d['data']['menu'] = $this->templateIds['Case'] . ',' . $this->templateIds['Contact'] . ',' . $this->templateIds['Organization'] . ',' . $d['data']['menu'];
$o->update($d);
}
$res->close();
}
}
}
protected function getMenuSeparatorId()
{
return Objects::getChildId(1, array('Tree', 'System', 'Templates', 'Built-in', 'Menu', '- Menu separator -'));
}
/**
* sync config table ids with those from tree
* @return void
*/
protected function syncConfigIds()
{
echo "Sync config ids .. ";
$rootId = Browser::getRootFolderId();
$pid = Objects::getChildId($rootId, 'System');
$pid = Objects::getChildId($pid, 'Config');
$ref = array();
$left = array();
$lastLength = 0;
$rows = DM\Config::readAll();
//add root nodes
foreach ($rows as &$r) {
if (empty($r['pid'])) {
$tr = DM\Tree::getChildByName($pid, $r['param']);
if (empty($tr)) {
DM\Config::delete($r['id']);
} else {
$ref[$r['id']] =& $r;
$r['treeRecord'] = $tr;
}
} else {
$left[] =& $r;
}
}
while (!empty($left) && sizeof($left) != $lastLength) {
$rows = $left;
$lastLength = sizeOf($left);
$left = array();
foreach ($rows as &$r) {
if (isset($ref[$r['pid']]) && !empty($ref[$r['pid']]['treeRecord'])) {
$ref[$r['id']] =& $r;
$r['treeRecord'] = DM\Tree::getChildByName($ref[$r['pid']]['treeRecord']['id'], $r['param']);
} else {
$left[] =& $r;
}
}
}
//iterate and update config table
foreach ($ref as &$r) {
$tr = $r['treeRecord'];
$pid = empty($ref[$r['pid']]['treeRecord']) ? null : $ref[$r['pid']]['treeRecord']['id'];
DB\dbQuery('UPDATE config
SET
id = $2
,pid = $3
WHERE id = $1', array($r['id'], $tr['id'], $pid));
}
echo "Ok \n";
}
/**
* transfer config options to tree
* @return void
*/
protected function syncConfigToTree()
{
$o = new \CB\Objects\Object();
$co = new \CB\Objects\Config();
$recs = DM\Config::readAll();
foreach ($recs as $r) {
//detect option type
$type = '';
switch ($r['param']) {
case 'default_event_template':
case 'default_file_template':
case 'default_folder_template':
case 'default_task_template':
$type = 'int';
break;
case 'default_language':
case 'languages':
case 'project_name_en':
case 'project_name_ru':
$type = 'varchar';
break;
case 'folder_templates':
case 'max_files_version_count':
case 'templateIcons':
$type = 'text';
break;
case 'facet_configs':
case 'js':
case 'maintenance_cfg':
case 'node_facets':
case 'rootNode':
case 'object_type_plugins':
case 'treeNodes':
$type = 'json';
break;
case 'responsible_party':
case 'responsible_party_default':
case 'task_categories':
case 'maintenance_mode':
continue;
default:
if (is_numeric($r['value'])) {
$type = 'int';
} else {
$type = 'text';
}
}
if (empty($type)) {
continue;
}
$childs = array();
if ($r['param'] == 'folder_templates') {
$r['value'] .= ',' . $this->templateIds["Config json option"];
DM\Config::update($r);
}
if ($r['param'] == 'treeNodes') {
$childs = Util\toJSONArray($r['value']);
$r['value'] = '';
DM\Config::update($r);
}
$pid = $o->create(array('id' => null, 'pid' => $this->cfg['configFolderId'], 'template_id' => $this->templateIds["Config {$type} option"], 'name' => $r['param'], 'data' => array('_title' => $r['param'], 'value' => $r['value'])));
$i = 1;
foreach ($childs as $k => $v) {
$co->create(array('id' => null, 'pid' => $pid, 'template_id' => $this->templateIds["Config {$type} option"], 'name' => $k, 'data' => array('_title' => $k, 'value' => json_encode($v, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT), 'order' => $i++)));
}
}
//add menu rule for Menus folder
$pid = Objects::getChildId($this->systemFolderId, 'Menus');
$tempalteIds = DM\Templates::getIdsByType('menu');
$o->create(array('id' => null, 'pid' => $pid, 'template_id' => $tempalteIds[0], 'name' => 'Create config options rule', 'data' => array('_title' => 'Create config options rule', 'node_ids' => $this->cfg['configFolderId'], 'menu' => $this->templateIds['Config int option'] . ',' . $this->templateIds['Config varchar option'] . ',' . $this->templateIds['Config text option'] . ',' . $this->templateIds['Config json option'])));
}