function build_from_string()
{
global $db, $app_list_strings, $beanList, $beanFiles, $current_user;
// Create a root GUID
$this->rootGuid = randomstring();
$this->joinSegments = array();
$this->maxDepth = 0;
$kOrgUnits = false;
//check if we do the Org Check
if (file_exists('modules/KOrgObjects/KOrgObject.php') && $GLOBALS['sugarconfig']['orgmanaged']) {
require_once 'modules/KOrgObjects/KOrgObject.php';
$thisKOrgObject = new KOrgObject();
$kOrgUnits = true;
}
/*
* Build the array for the joins based on the various Path we have
*/
foreach ($this->tablePath as $thisPath => $thisPathJoinType) {
// Process backcutting until we have found the node going upwards
// in the segments array or we are on the root segment
// (when no '::' can be found)
if (substr_count($thisPath, '::') > $this->maxDepth) {
$this->maxDepth = substr_count($thisPath, '::');
}
while (strpos($thisPath, '::') && !isset($this->joinSegments[$thisPath])) {
// add the segment to the segments table
$this->joinSegments[$thisPath] = array('alias' => randomstring(), 'linkalias' => randomstring(), 'level' => substr_count($thisPath, '::'), 'jointype' => $thisPathJoinType);
// find last occurence of '::' in the string and cut off there
$thisPath = substr($thisPath, strrpos($thisPath, "::"));
}
}
// Get the main Table we select from
$this->fromString = 'FROM ' . $this->get_table_for_module($this->root_module) . ' ' . $this->rootGuid;
// check if this is an array so we need to add joins ...
// add an entry for the root Object ...
// needed as reference for the GUID
$this->joinSegments['root:' . $this->root_module] = array('alias' => $this->rootGuid, 'level' => 0);
// get ther root Object
require_once $beanFiles[$beanList[$this->root_module]];
$this->joinSegments['root:' . $this->root_module]['object'] = new $beanList[$this->root_module]();
// check for Custom Fields
if ($this->joinSegments['root:' . $this->root_module]['object']->hasCustomFields()) {
$this->joinSegments['root:' . $this->root_module]['customjoin'] = randomstring();
$this->fromString .= ' LEFT JOIN ' . $this->get_table_for_module($this->root_module) . '_cstm as ' . $this->joinSegments['root:' . $this->root_module]['customjoin'] . ' ON ' . $this->rootGuid . '.id = ' . $this->joinSegments['root:' . $this->root_module]['customjoin'] . '.id_c';
}
// changed so we spport teams in Pro
if ($this->authChecklevel != 'none') {
switch ($GLOBALS['sugar_config']['KReports']['authCheck']) {
case 'KOrgObjects':
$this->fromString .= $thisKOrgObject->getOrgunitJoin($this->joinSegments['root:' . $this->root_module]['object']->table_name, $this->joinSegments['root:' . $this->root_module]['object']->object_name, $this->rootGuid, '1');
break;
case 'KAuthObjects':
$selectArray = array('where' => '', 'from' => '', 'select' => '');
$GLOBALS['KAuthAccessController']->addAuthAccessToListArray($selectArray, $this->joinSegments['root:' . $this->root_module]['object'], $this->joinSegments['root:' . $this->root_module]['alias'], true);
if (!empty($selectArray['where'])) {
if (empty($this->whereString)) {
$this->whereString = " " . $selectArray['where'] . " ";
} else {
$this->whereString .= " AND " . $selectArray['where'] . " ";
}
}
if (!empty($selectArray['join'])) {
$this->fromString .= ' ' . $selectArray['join'] . ' ';
}
break;
case 'PRO':
$this->fromString .= ' ';
$this->joinSegments['root:' . $this->root_module]['object']->add_team_security_where_clause($this->fromString, $this->rootGuid);
break;
//2013-03-26 Bug#460 Typo changed
//2013-03-26 Bug#460 Typo changed
case 'SecurityGroups':
if ($this->joinSegments['root:' . $this->root_module]['object']->bean_implements('ACL') && ACLController::requireSecurityGroup($this->joinSegments['root:' . $this->root_module]['object']->module_dir, 'list')) {
require_once 'modules/SecurityGroups/SecurityGroup.php';
global $current_user;
$owner_where = str_replace($this->joinSegments['root:' . $this->root_module]['object']->table_name, $this->rootGuid, $this->joinSegments['root:' . $this->root_module]['object']->getOwnerWhere($current_user->id));
$group_where = SecurityGroup::getGroupWhere($this->rootGuid, $this->joinSegments['root:' . $this->root_module]['object']->module_dir, $current_user->id);
if (!empty($owner_where)) {
if (empty($this->whereString)) {
$this->whereString = " (" . $owner_where . " or " . $group_where . ") ";
} else {
$this->whereString .= " AND (" . $owner_where . " or " . $group_where . ") ";
}
} else {
$this->whereString .= ' AND ' . $group_where;
}
}
break;
}
}
// Index to iterate through the join table building the joins
// from the root object outward going
$levelCounter = 1;
if (is_array($this->joinSegments)) {
while ($levelCounter <= $this->maxDepth) {
// set the array back to the first element in the array
reset($this->joinSegments);
foreach ($this->joinSegments as $thisPath => $thisPathDetails) {
// process only entries for the respective levels
if ($thisPathDetails['level'] == $levelCounter) {
// get the last enrty and the one before and the relevant arrays
$rightPath = substr($thisPath, strrpos($thisPath, "::") + 2, strlen($thisPath));
$leftPath = substr($thisPath, 0, strrpos($thisPath, "::"));
// explode into the relevant arrays
$rightArray = explode(':', $rightPath);
$leftArray = explode(':', $leftPath);
// 2011-07-21 add check for audit records
if ($rightArray[2] == 'audit') {
//handle audit link
$this->fromString .= $thisPathJoinType . $this->joinSegments[$leftPath]['object']->table_name . '_audit ' . $this->joinSegments[$thisPath]['alias'] . ' ON ' . $this->joinSegments[$thisPath]['alias'] . '.parent_id = ' . $this->joinSegments[$leftPath]['alias'] . '.id';
} elseif ($rightArray[0] == 'relationship') {
// set alias for the path to the linkalias of the connected bean
$this->joinSegments[$thisPath]['alias'] = $this->joinSegments[$leftPath]['linkalias'];
} elseif ($rightArray[0] == 'relate') {
//left Path Object must be set since we process from the top
if (!$this->joinSegments[$leftPath]['object'] instanceof $beanList[$rightArray[1]]) {
die('fatal Error in Join');
}
// load the module on the right hand side
require_once $beanFiles[$beanList[$this->joinSegments[$leftPath]['object']->field_defs[$rightArray[2]]['module']]];
$this->joinSegments[$thisPath]['object'] = new $beanList[$this->joinSegments[$leftPath]['object']->field_defs[$rightArray[2]]['module']]();
// join on the id = relate id .. on _cstm if custom field .. on main if regular
$this->fromString .= ' ' . $thisPathDetails['jointype'] . ' ' . $this->joinSegments[$thisPath]['object']->table_name . ' AS ' . $this->joinSegments[$thisPath]['alias'] . ' ON ' . $this->joinSegments[$thisPath]['alias'] . '.id=' . ($this->joinSegments[$leftPath]['object']->field_defs[$this->joinSegments[$leftPath]['object']->field_defs[$rightArray[2]]['id_name']]['source'] == 'custom_fields' ? $this->joinSegments[$leftPath]['customjoin'] : $this->joinSegments[$leftPath]['alias']) . '.' . $this->joinSegments[$leftPath]['object']->field_defs[$rightArray[2]]['id_name'] . ' ';
// check for Custom Fields
if ($this->joinSegments[$thisPath]['object']->hasCustomFields()) {
$this->joinSegments[$thisPath]['customjoin'] = randomstring();
$this->fromString .= ' LEFT JOIN ' . $this->joinSegments[$thisPath]['object']->table_name . '_cstm as ' . $this->joinSegments[$thisPath]['customjoin'] . ' ON ' . $this->joinSegments[$thisPath]['alias'] . '.id = ' . $this->joinSegments[$thisPath]['customjoin'] . '.id_c';
}
} else {
//left Path Object must be set since we process from the top
if (!$this->joinSegments[$leftPath]['object'] instanceof $beanList[$rightArray[1]]) {
$GLOBALS['log']->error('KReporter: fatal error in join with left path ' . $thisPath);
die('fatal Error in Join ' . $thisPath);
}
// load the relationship .. resp link
$this->joinSegments[$leftPath]['object']->load_relationship($rightArray[2]);
// set aliases for left and right .. will be processed properly anyway in the build of the link
// ... funny enough so
//2011-12-29 check if we have a jointpye
if ($thisPathDetails['jointype'] != '') {
//2011-12-29 see if the relationship vuilds on a custom field
if (isset($this->joinSegments[$leftPath]['object']->field_name_map[$this->joinSegments[$leftPath]['object']->{$rightArray}[2]->_relationship->rhs_key]['source']) && ($this->joinSegments[$leftPath]['object']->field_name_map[$this->joinSegments[$leftPath]['object']->{$rightArray}[2]->_relationship->rhs_key]['source'] == 'custom_fields' || $this->joinSegments[$leftPath]['object']->field_name_map[$this->joinSegments[$leftPath]['object']->{$rightArray}[2]->_relationship->lhs_key]['source'] == 'custom_fields')) {
$join_params = array('join_type' => $thisPathDetails['jointype'], 'right_join_table_alias' => $this->joinSegments[$leftPath]['customjoin'], 'left_join_table_alias' => $this->joinSegments[$leftPath]['customjoin'], 'join_table_link_alias' => $this->joinSegments[$thisPath]['linkalias'], 'join_table_alias' => $this->joinSegments[$thisPath]['alias']);
} else {
$join_params = array('join_type' => $thisPathDetails['jointype'], 'right_join_table_alias' => $this->joinSegments[$leftPath]['alias'], 'left_join_table_alias' => $this->joinSegments[$leftPath]['alias'], 'join_table_link_alias' => $this->joinSegments[$thisPath]['linkalias'], 'join_table_alias' => $this->joinSegments[$thisPath]['alias']);
}
//2010-09-09 Bug to handle left side join relationship
if (isset($this->joinSegments[$leftPath]['object']->field_defs[$rightArray[2]]['side']) && $this->joinSegments[$leftPath]['object']->field_defs[$rightArray[2]]['side'] == 'left' && !$this->joinSegments[$leftPath]['object']->{$rightArray}[2]->_swap_sides) {
$this->joinSegments[$leftPath]['object']->{$rightArray}[2]->_swap_sides = true;
}
$linkJoin = $this->joinSegments[$leftPath]['object']->{$rightArray}[2]->getJoin($join_params);
$this->fromString .= ' ' . $linkJoin;
}
// load the module on the right hand side
require_once $beanFiles[$beanList[$this->joinSegments[$leftPath]['object']->{$rightArray}[2]->getRelatedModuleName()]];
$this->joinSegments[$thisPath]['object'] = new $beanList[$this->joinSegments[$leftPath]['object']->{$rightArray}[2]->getRelatedModuleName()]();
//bugfix 2010-08-19, respect ACL role access for owner reuqired in select
if ($this->joinSegments[$leftPath]['object']->bean_implements('ACL') && ACLController::requireOwner($this->joinSegments[$leftPath]['object']->module_dir, 'list')) {
//2013-02-22 missing check if we have a wherestring at all
if ($this->whereString != '') {
$this->whereString .= ' AND ';
}
$this->whereString .= $this->joinSegments[$leftPath]['alias'] . '.assigned_user_id=\'' . $current_user->id . '\'';
}
// check for Custom Fields
if ($this->joinSegments[$thisPath]['object']->hasCustomFields()) {
$this->joinSegments[$thisPath]['customjoin'] = randomstring();
$this->fromString .= ' LEFT JOIN ' . $this->joinSegments[$thisPath]['object']->table_name . '_cstm as ' . $this->joinSegments[$thisPath]['customjoin'] . ' ON ' . $this->joinSegments[$thisPath]['alias'] . '.id = ' . $this->joinSegments[$thisPath]['customjoin'] . '.id_c';
}
// append join for Orgobjects if Object is OrgManaged
if ($this->authChecklevel != 'none' && $this->authChecklevel != 'top') {
switch ($GLOBALS['sugar_config']['KReports']['authCheck']) {
case 'KOrgObjects':
$this->fromString .= $thisKOrgObject->getOrgunitJoin($this->joinSegments[$thisPath]['object']->table_name, $this->joinSegments[$thisPath]['object']->object_name, $this->joinSegments[$thisPath]['alias'], '1');
break;
case 'KAuthObjects':
$selectArray = array('where' => '', 'from' => '', 'select' => '');
$GLOBALS['KAuthAccessController']->addAuthAccessToListArray($selectArray, $this->joinSegments[$thisPath]['object'], $this->joinSegments[$thisPath]['alias'], true);
if (!empty($selectArray['where'])) {
if (empty($this->whereString)) {
$this->whereString = " " . $selectArray['where'] . " ";
} else {
$this->whereString .= " AND " . $selectArray['where'] . " ";
}
}
if (!empty($selectArray['join'])) {
$this->fromString .= ' ' . $selectArray['join'] . ' ';
}
break;
case 'PRO':
$this->fromString .= ' ';
$this->joinSegments[$thisPath]['object']->add_team_security_where_clause($this->fromString, $this->joinSegments[$thisPath]['alias']);
break;
//2013-03-26 Bug#460 Typo changed
//2013-03-26 Bug#460 Typo changed
case 'SecurityGroups':
if ($this->joinSegments[$thisPath]['object']->bean_implements('ACL') && ACLController::requireSecurityGroup($this->joinSegments[$thisPath]['object']->module_dir, 'list')) {
require_once 'modules/SecurityGroups/SecurityGroup.php';
global $current_user;
$owner_where = str_replace($this->joinSegments[$thisPath]['object']->table_name, $this->joinSegments[$thisPath]['alias'], $this->joinSegments[$thisPath]['object']->getOwnerWhere($current_user->id));
$group_where = SecurityGroup::getGroupWhere($this->joinSegments[$thisPath]['alias'], $this->joinSegments[$thisPath]['object']->module_dir, $current_user->id);
if (!empty($owner_where)) {
if (empty($this->whereString)) {
$this->whereString = " (" . $owner_where . " or " . $group_where . ") ";
} else {
$this->whereString .= " AND (" . $owner_where . " or " . $group_where . ") ";
}
} else {
$this->whereString .= ' AND ' . $group_where;
}
}
break;
}
}
}
}
}
// increase Counter to tackle next level
$levelCounter++;
}
}
}
function action_get_korgobjects()
{
global $db;
require_once 'modules/KOrgObjects/KOrgObject.php';
$thisOrgObject = new KOrgObject();
$returnArray['count'] = $db->getRowCount($db->query($thisOrgObject->getEditViewOrgUnitQuery('KReports', $_REQUEST['query'])));
$queryObj = $db->query($thisOrgObject->getEditViewOrgUnitQuery('KReports', $_REQUEST['query']) . ' LIMIT ' . $_REQUEST['start'] . ',' . $_REQUEST['limit']);
while ($korgobjectrecord = $db->fetchByAssoc($queryObj)) {
$returnArray['data'][] = array('value' => $korgobjectrecord['id'], 'text' => $korgobjectrecord['name']);
}
echo json_encode($returnArray);
}
function display()
{
global $app_list_strings, $mod_strings, $current_language, $dictionary, $sugar_config;
// ann Add Js Strinf that will be assigned at the end befor ehte view gets rendered
$this->addJsString = '';
$jsVariables = '';
// get the Sugar Flavor
$jsVariables .= "var sugar_flavor='" . $GLOBALS['sugar_flavor'] . "';";
// get all the where editable fields per operator
include 'modules/KReports/config/KReportWhereOperators.php';
$jsVariables .= "var kreportoperatorcount=" . json_encode($kreporterWhereOperatorCount) . ";";
$mod_lang = return_module_language($current_language, 'KReports');
foreach ($mod_lang as $id => $value) {
$returnArray[] = array('lblid' => $id, 'value' => $value);
}
// add the app list array we need
if (is_array($this->bean->field_defs) && count($this->bean->field_defs) > 0) {
foreach ($this->bean->field_defs as $fieldId => $fieldDetails) {
if (isset($fieldDetails['options']) && isset($app_list_strings[$fieldDetails['options']])) {
$thisString = jarray_encode_kinamu($app_list_strings[$fieldDetails['options']]);
$returnArray[] = array('lblid' => $fieldId . '_options', 'value' => jarray_encode_kinamu($app_list_strings[$fieldDetails['options']]));
}
}
}
// set the language
$langJson = json_encode_kinamu($returnArray);
$this->ss->assign('jsonlanguage', json_encode_kinamu($returnArray));
// see if we have a return id
if (!isset($_REQUEST['return_id']) || $_REQUEST['return_id'] == '') {
$_REQUEST['return_id'] = $this->bean->id;
}
// set Options
if ($this->bean->reportoptions == '') {
$this->bean->reportoptions = '{"resultsFolded":false,"optionsFolded":true,"authCheck":"full","showDeleted":false,"showExport":true,"showSnapshots":false,"showTools":true}';
}
// handle Plugins
$pluginManager = new KReportPluginManager();
$pluginManager->getEditViewPlugins($this);
// handle authorization objects
if (!empty($GLOBALS['KAuthAccessController'])) {
if ($GLOBALS['KAuthAccessController']->orgManaged('KReport')) {
$jsVariables .= "var korgmanaged=true;";
} else {
$jsVariables .= "var korgmanaged=false;";
}
}
// manage Visualitazion Variables
$thisVisualizationManager = new KReportVisualizationManager();
$this->addJsString .= $thisVisualizationManager->getLayouts();
// assign to the Template
$this->ss->assign('editViewAddJs', $this->addJsString);
//2013-03-15 pass in teh auth check type
$jsVariables .= 'kreportAuthCheck=\'' . $sugar_config['KReports']['authCheck'] . '\';';
// handle access authentication for Dialog
global $sugar_config;
switch ($sugar_config['KReports']['authCheck']) {
case 'KAuthObjects':
$this->ss->assign('authaccess_id', $this->bean->korgobjectmain);
// get the name
require_once 'modules/KOrgObjects/KOrgObject.php';
$thisObject = new KOrgObject();
$thisObject->retrieve($this->bean->korgobjectmain);
$this->ss->assign('authaccess_name', $thisObject->name);
break;
case 'SecurityGroups':
$thisRecord = $db->fetchByAssoc($db->query("SELECT securitygroups_records.id, name FROM securitygroups_records INNER JOIN securitygroups ON securitygroups.id = securitygroups_records.securitygroup_id WHERE securitygroups_records.record_id='" . $this->bean->id . "'"));
if ($thisRecord) {
$this->ss->assign('authaccess_id', $thisRecord['id']);
$this->ss->assign('authaccess_name', $thisRecord['name']);
}
break;
case 'PRO':
if (!empty($this->bean->team_id)) {
$thisTeam = BeanFactory::getBean('Teams', $this->bean->team_id);
$this->ss->assign('team_name', $thisTeam->name . ' ' . $thisTeam->name_2);
}
break;
}
// set ambigious ariables
$this->ss->assign('jsVariables', $jsVariables);
// set if the Reporter is in DebugMode
if ($GLOBALS['sugar_config']['KReports']['debug']) {
$jsVariables .= "var kreportDebug=true;";
$this->ss->assign('kreportDebug', true);
} else {
$jsVariables .= "var kreportDebug=false;";
$this->ss->assign('kreportDebug', false);
}
if (!empty($this->bean->team_id)) {
$thisTeam = BeanFactory::getBean('Teams', $this->bean->team_id);
$this->ss->assign('team_name', $thisTeam->name . ' ' . $thisTeam->name_2);
}
// off we go
parent::display();
}
