table = Database::get_main_table(TABLE_CAREER);
}
/**
* Get the count of elements.
*
* @return int
*/
public function get_count()
{
$row = Database::select(
'count(*) as count',
$this->table,
[],
'first'
);
return $row['count'];
}
/**
* @param array $where_conditions
*
* @return array
*/
public function get_all($where_conditions = [])
{
return Database::select(
'*',
$this->table,
['where' => $where_conditions, 'order' => 'name ASC']
);
}
/**
* Update all promotion status by career.
*
* @param int $career_id
* @param int $status (1 or 0)
*/
public function update_all_promotion_status_by_career_id($career_id, $status)
{
$promotion = new Promotion();
$promotion_list = $promotion->get_all_promotions_by_career_id($career_id);
if (!empty($promotion_list)) {
foreach ($promotion_list as $item) {
$params['id'] = $item['id'];
$params['status'] = $status;
$promotion->update($params);
$promotion->update_all_sessions_status_by_promotion_id($params['id'], $status);
}
}
}
/**
* Returns HTML the title + grid.
*
* @return string
*/
public function display()
{
$html = '
';
$html .= Display::grid_html('careers');
return $html;
}
/**
* @return array
*/
public function get_status_list()
{
return [
CAREER_STATUS_ACTIVE => get_lang('Unarchived'),
CAREER_STATUS_INACTIVE => get_lang('Archived'),
];
}
/**
* Returns a Form validator Obj.
*
* @todo the form should be auto generated
*
* @param string $url
* @param string $action add, edit
*
* @return FormValidator
*/
public function return_form($url, $action)
{
$form = new FormValidator('career', 'post', $url);
// Setting the form elements
$header = get_lang('Add');
if ($action == 'edit') {
$header = get_lang('Modify');
}
$id = isset($_GET['id']) ? intval($_GET['id']) : '';
$form->addHeader($header);
$form->addHidden('id', $id);
$form->addElement('text', 'name', get_lang('Name'), ['size' => '70']);
$form->addHtmlEditor(
'description',
get_lang('Description'),
false,
false,
[
'ToolbarSet' => 'Careers',
'Width' => '100%',
'Height' => '250',
]
);
$status_list = $this->get_status_list();
$form->addElement('select', 'status', get_lang('Status'), $status_list);
if ($action == 'edit') {
$form->addElement('text', 'created_at', get_lang('CreatedAt'));
$form->freeze('created_at');
}
if ($action == 'edit') {
$form->addButtonSave(get_lang('Modify'), 'submit');
} else {
$form->addButtonCreate(get_lang('Add'), 'submit');
}
// Setting the defaults
$defaults = $this->get($id);
if (!empty($defaults['created_at'])) {
$defaults['created_at'] = api_convert_and_format_date($defaults['created_at']);
}
if (!empty($defaults['updated_at'])) {
$defaults['updated_at'] = api_convert_and_format_date($defaults['updated_at']);
}
$form->setDefaults($defaults);
// Setting the rules
$form->addRule('name', get_lang('ThisFieldIsRequired'), 'required');
return $form;
}
/**
* Copies the career to a new one.
*
* @param int Career ID
* @param bool Whether or not to copy the promotions inside
*
* @return int New career ID on success, false on failure
*/
public function copy($id, $copy_promotions = false)
{
$career = $this->get($id);
$new = [];
foreach ($career as $key => $val) {
switch ($key) {
case 'id':
case 'updated_at':
break;
case 'name':
$val .= ' '.get_lang('CopyLabelSuffix');
$new[$key] = $val;
break;
case 'created_at':
$val = api_get_utc_datetime();
$new[$key] = $val;
break;
default:
$new[$key] = $val;
break;
}
}
$cid = $this->save($new);
if ($copy_promotions) {
//Now also copy each session of the promotion as a new session and register it inside the promotion
$promotion = new Promotion();
$promo_list = $promotion->get_all_promotions_by_career_id($id);
if (!empty($promo_list)) {
foreach ($promo_list as $item) {
$promotion->copy($item['id'], $cid, true);
}
}
}
return $cid;
}
/**
* @param int $career_id
*
* @return bool
*/
public function get_status($career_id)
{
$table = Database::get_main_table(TABLE_CAREER);
$career_id = intval($career_id);
$sql = "SELECT status FROM $table WHERE id = '$career_id'";
$result = Database::query($sql);
if (Database::num_rows($result) > 0) {
$data = Database::fetch_array($result);
return $data['status'];
} else {
return false;
}
}
/**
* @param array $params
* @param bool $show_query
*
* @return int
*/
public function save($params, $show_query = false)
{
if (isset($params['description'])) {
$params['description'] = Security::remove_XSS($params['description']);
}
$id = parent::save($params);
if (!empty($id)) {
Event::addEvent(
LOG_CAREER_CREATE,
LOG_CAREER_ID,
$id,
api_get_utc_datetime(),
api_get_user_id()
);
}
return $id;
}
/**
* Delete a record from the career table and report in the default events log table.
*
* @param int $id The ID of the career to delete
*
* @return bool True if the career could be deleted, false otherwise
*/
public function delete($id)
{
$res = parent::delete($id);
if ($res) {
$extraFieldValues = new ExtraFieldValue('career');
$extraFieldValues->deleteValuesByItem($id);
Event::addEvent(
LOG_CAREER_DELETE,
LOG_CAREER_ID,
$id,
api_get_utc_datetime(),
api_get_user_id()
);
}
return $res;
}
/**
* {@inheritdoc}
*/
public function update($params, $showQuery = false)
{
if (isset($params['description'])) {
$params['description'] = Security::remove_XSS($params['description']);
}
return parent::update($params, $showQuery);
}
/**
* @param array
* @param Graph $graph
*
* @return string
*/
public static function renderDiagram($careerInfo, $graph)
{
if (!($graph instanceof Graph)) {
return '';
}
// Getting max column
$maxColumn = 0;
foreach ($graph->getVertices() as $vertex) {
$groupId = (int) $vertex->getGroup();
if ($groupId > $maxColumn) {
$maxColumn = $groupId;
}
}
$list = [];
/** @var Vertex $vertex */
foreach ($graph->getVertices() as $vertex) {
$group = $vertex->getAttribute('Group');
$groupData = explode(':', $group);
$group = $groupData[0];
$groupLabel = isset($groupData[1]) ? $groupData[1] : '';
$subGroup = $vertex->getAttribute('SubGroup');
$subGroupData = explode(':', $subGroup);
$column = $vertex->getGroup();
$row = $vertex->getAttribute('Row');
$subGroupId = $subGroupData[0];
$label = isset($subGroupData[1]) ? $subGroupData[1] : '';
$list[$group][$subGroupId]['columns'][$column][$row] = $vertex;
$list[$group][$subGroupId]['label'] = $label;
$list[$group]['label'] = $groupLabel;
}
$maxGroups = count($list);
$widthGroup = 30;
if (!empty($maxGroups)) {
$widthGroup = 85 / $maxGroups;
}
$connections = '';
$groupDrawLine = [];
$groupCourseList = [];
// Read Connections column
foreach ($list as $group => $subGroupList) {
foreach ($subGroupList as $subGroupData) {
$columns = isset($subGroupData['columns']) ? $subGroupData['columns'] : [];
$showGroupLine = true;
if (count($columns) == 1) {
$showGroupLine = false;
}
$groupDrawLine[$group] = $showGroupLine;
//if ($showGroupLine == false) {
/** @var Vertex $vertex */
foreach ($columns as $row => $items) {
foreach ($items as $vertex) {
if ($vertex instanceof Vertex) {
$groupCourseList[$group][] = $vertex->getId();
$connectionList = $vertex->getAttribute('Connections');
$firstConnection = '';
$secondConnection = '';
if (!empty($connectionList)) {
$explode = explode('-', $connectionList);
$pos = strpos($explode[0], 'SG');
if ($pos === false) {
$pos = strpos($explode[0], 'G');
if (is_numeric($pos)) {
// group_123 id
$groupValueId = (int) str_replace(
'G',
'',
$explode[0]
);
$firstConnection = 'group_'.$groupValueId;
$groupDrawLine[$groupValueId] = true;
} else {
// Course block (row_123 id)
if (!empty($explode[0])) {
$firstConnection = 'row_'.(int) $explode[0];
}
}
} else {
// subgroup__123 id
$firstConnection = 'subgroup_'.(int) str_replace('SG', '', $explode[0]);
}
$pos = strpos($explode[1], 'SG');
if ($pos === false) {
$pos = strpos($explode[1], 'G');
if (is_numeric($pos)) {
$groupValueId = (int) str_replace(
'G',
'',
$explode[1]
);
$secondConnection = 'group_'.$groupValueId;
$groupDrawLine[$groupValueId] = true;
} else {
// Course block (row_123 id)
if (!empty($explode[0])) {
$secondConnection = 'row_'.(int) $explode[1];
}
}
} else {
$secondConnection = 'subgroup_'.(int) str_replace('SG', '', $explode[1]);
}
if (!empty($firstConnection) && !empty($firstConnection)) {
$connections .= self::createConnection(
$firstConnection,
$secondConnection,
['Left', 'Right']
);
}
}
}
}
}
//}
}
}
$graphHtml = '';
foreach ($list as $group => $subGroupList) {
$showGroupLine = false;
if (isset($groupDrawLine[$group]) && $groupDrawLine[$group]) {
$showGroupLine = true;
}
$graphHtml .= self::parseSubGroups(
$groupCourseList,
$group,
$list[$group]['label'],
$showGroupLine,
$subGroupList,
$widthGroup
);
}
$graphHtml .= '
';
$graphHtml .= $connections;
return $graphHtml;
}
/**
* @param Graph $graph
* @param Template $tpl
*
* @return string
*/
public static function renderDiagramByColumn($graph, $tpl)
{
if (!($graph instanceof Graph)) {
return '';
}
// Getting max column
$maxColumn = 0;
foreach ($graph->getVertices() as $vertex) {
$groupId = (int) $vertex->getGroup();
if ($groupId > $maxColumn) {
$maxColumn = $groupId;
}
}
$list = [];
$subGroups = [];
/** @var Vertex $vertex */
foreach ($graph->getVertices() as $vertex) {
$column = $vertex->getGroup();
$group = $vertex->getAttribute('Group');
$groupData = explode(':', $group);
$group = $groupData[0];
$groupLabel = isset($groupData[1]) ? $groupData[1] : '';
$subGroup = $vertex->getAttribute('SubGroup');
$subGroupData = explode(':', $subGroup);
$row = $vertex->getAttribute('Row');
$subGroupId = $subGroupData[0];
$subGroupLabel = isset($subGroupData[1]) ? $subGroupData[1] : '';
if (!empty($subGroupId) && !in_array($subGroupId, $subGroups)) {
//$subGroups[$subGroupId][] = $vertex->getId();
$subGroups[$subGroupId]['items'][] = $vertex->getId();
$subGroups[$subGroupId]['label'] = $subGroupLabel;
}
$list[$column]['rows'][$row]['items'][] = $vertex;
$list[$column]['rows'][$row]['label'] = $subGroupId;
$list[$column]['rows'][$row]['group'] = $group;
$list[$column]['rows'][$row]['group_label'] = $groupLabel;
$list[$column]['rows'][$row]['subgroup'] = $subGroup;
$list[$column]['rows'][$row]['subgroup_label'] = $subGroupLabel;
$list[$column]['label'] = $groupLabel;
$list[$column]['column'] = $column;
}
$connections = '';
$groupDrawLine = [];
$groupCourseList = [];
$simpleConnectionList = [];
// Read Connections column
foreach ($list as $column => $groupList) {
foreach ($groupList['rows'] as $subGroupList) {
/** @var Vertex $vertex */
foreach ($subGroupList['items'] as $vertex) {
if ($vertex instanceof Vertex) {
$rowId = $vertex->getId();
$groupCourseList[$vertex->getAttribute('Column')][] = $vertex->getId();
$connectionList = $vertex->getAttribute('Connections');
if (empty($connectionList)) {
continue;
}
$simpleFirstConnection = '';
$simpleSecondConnection = '';
$explode = explode('-', $connectionList);
$pos = strpos($explode[0], 'SG');
if ($pos === false) {
$pos = strpos($explode[0], 'G');
if (is_numeric($pos)) {
// Is group
$groupValueId = (int) str_replace(
'G',
'',
$explode[0]
);
$groupDrawLine[$groupValueId] = true;
$simpleFirstConnection = 'g'.(int) $groupValueId;
} else {
// Course block (row_123 id)
if (!empty($explode[0])) {
$simpleFirstConnection = 'v'.(int) $explode[0];
}
}
} else {
// subgroup__123 id
$simpleFirstConnection = 'sg'.(int) str_replace('SG', '', $explode[0]);
}
$pos = false;
if (isset($explode[1])) {
$pos = strpos($explode[1], 'SG');
}
if ($pos === false) {
if (isset($explode[1])) {
$pos = strpos($explode[1], 'G');
$value = $explode[1];
}
if (is_numeric($pos)) {
$groupValueId = (int) str_replace(
'G',
'',
$value
);
$simpleSecondConnection = 'g'.(int) $groupValueId;
$groupDrawLine[$groupValueId] = true;
} else {
// Course block (row_123 id)
if (!empty($explode[0]) && isset($explode[1])) {
$simpleSecondConnection = 'v'.(int) $explode[1];
}
}
} else {
$simpleSecondConnection = 'sg'.(int) str_replace('SG', '', $explode[1]);
}
if (!empty($simpleFirstConnection) && !empty($simpleSecondConnection)) {
$simpleConnectionList[] = [
'from' => $simpleFirstConnection,
'to' => $simpleSecondConnection,
];
}
}
}
}
}
$graphHtml = '';
$groupsBetweenColumns = [];
foreach ($list as $column => $columnList) {
foreach ($columnList['rows'] as $subGroupList) {
$newGroup = $subGroupList['group'];
$label = $subGroupList['group_label'];
$newOrder[$newGroup]['items'][] = $subGroupList;
$newOrder[$newGroup]['label'] = $label;
$groupsBetweenColumns[$newGroup][] = $subGroupList;
}
}
// Creates graph
$graph = new stdClass();
$graph->blockWidth = 240;
$graph->blockHeight = 120;
$graph->xGap = 70;
$graph->yGap = 40;
$graph->xDiff = 70;
$graph->yDiff = 40;
$graph->groupXGap = 50;
foreach ($groupsBetweenColumns as $group => $items) {
self::parseColumnList($groupCourseList, $items, '', $graph, $simpleConnectionList);
}
$graphHtml .= '';
// Create groups
if (!empty($graph->groupList)) {
$groupList = [];
$groupDiffX = 20;
$groupDiffY = 10;
$style = 'whiteSpace=wrap;rounded;html=1;strokeColor=red;fillColor=none;strokeWidth=2;align=left;verticalAlign=top;';
foreach ($graph->groupList as $id => $data) {
if (empty($id)) {
continue;
}
$x = $data['min_x'] - $groupDiffX;
$y = $data['min_y'] - $groupDiffY;
$width = $data['max_width'] + ($groupDiffX * 2);
$height = $data['max_height'] + $groupDiffY * 2;
$label = ''.$data['label'].'
';
$vertexData = "var g$id = graph.insertVertex(parent, null, '$label', $x, $y, $width, $height, '$style');";
$groupList[] = $vertexData;
}
$tpl->assign('group_list', $groupList);
}
// Create subgroups
$subGroupList = [];
$subGroupListData = [];
foreach ($subGroups as $subGroupId => $vertexData) {
$label = $vertexData['label'];
$vertexIdList = $vertexData['items'];
foreach ($vertexIdList as $rowId) {
$data = $graph->allData[$rowId];
$originalRow = $data['row'];
$column = $data['column'];
$x = $data['x'];
$y = $data['y'];
$width = $data['width'];
$height = $data['height'];
if (!isset($subGroupListData[$subGroupId])) {
$subGroupListData[$subGroupId]['min_x'] = 1000;
$subGroupListData[$subGroupId]['min_y'] = 1000;
$subGroupListData[$subGroupId]['max_width'] = 0;
$subGroupListData[$subGroupId]['max_height'] = 0;
$subGroupListData[$subGroupId]['label'] = $label;
}
if ($x < $subGroupListData[$subGroupId]['min_x']) {
$subGroupListData[$subGroupId]['min_x'] = $x;
}
if ($y < $subGroupListData[$subGroupId]['min_y']) {
$subGroupListData[$subGroupId]['min_y'] = $y;
}
$subGroupListData[$subGroupId]['max_width'] = ($column + 1) * ($width + $graph->xGap) - $subGroupListData[$subGroupId]['min_x'];
$subGroupListData[$subGroupId]['max_height'] = ($originalRow + 1) * ($height + $graph->yGap) - $subGroupListData[$subGroupId]['min_y'];
}
$style = 'whiteSpace=wrap;rounded;dashed=1;strokeColor=blue;fillColor=none;strokeWidth=2;align=left;verticalAlign=bottom;';
$subGroupDiffX = 5;
foreach ($subGroupListData as $subGroupId => $data) {
$x = $data['min_x'] - $subGroupDiffX;
$y = $data['min_y'] - $subGroupDiffX;
$width = $data['max_width'] + $subGroupDiffX * 2;
$height = $data['max_height'] + $subGroupDiffX * 2;
$label = ''.$data['label'].'
';
$vertexData = "var sg$subGroupId = graph.insertVertex(parent, null, '$label', $x, $y, $width, $height, '$style');";
$subGroupList[] = $vertexData;
}
}
// Create connections (arrows)
if (!empty($simpleConnectionList)) {
$connectionList = [];
//$style = 'endArrow=classic;html=1;strokeWidth=4;exitX=1;exitY=0.5;entryX=0;entryY=0.5;';
$style = '';
foreach ($simpleConnectionList as $connection) {
$from = $connection['from'];
$to = $connection['to'];
$vertexData = "var e1 = graph.insertEdge(parent, null, '', $from, $to, '$style')";
$connectionList[] = $vertexData;
}
$tpl->assign('connections', $connectionList);
}
$tpl->assign('subgroup_list', $subGroupList);
$tpl->assign('vertex_list', $graph->elementList);
$graphHtml .= '';
return $graphHtml;
}
public static function parseColumnList($groupCourseList, $columnList, $width, &$graph, &$connections)
{
$graphHtml = '';
$oldGroup = null;
$newOrder = [];
foreach ($columnList as $key => $subGroupList) {
$newGroup = $subGroupList['group'];
$label = $subGroupList['group_label'];
$newOrder[$newGroup]['items'][] = $subGroupList;
$newOrder[$newGroup]['label'] = $label;
}
foreach ($newOrder as $newGroup => $data) {
$label = $data['label'];
$subGroupList = $data['items'];
if (!isset($graph->groupList[$newGroup])) {
$graph->groupList[$newGroup]['min_x'] = 1000;
$graph->groupList[$newGroup]['min_y'] = 1000;
$graph->groupList[$newGroup]['max_width'] = 0;
$graph->groupList[$newGroup]['max_height'] = 0;
$graph->groupList[$newGroup]['label'] = $label;
}
$maxColumn = 0;
$maxRow = 0;
$minColumn = 100;
$minRow = 100;
foreach ($subGroupList as $item) {
/** @var Vertex $vertex */
foreach ($item['items'] as $vertex) {
$column = $vertex->getAttribute('Column');
$realRow = $vertex->getAttribute('Row');
if ($column > $maxColumn) {
$maxColumn = $column;
}
if ($realRow > $maxRow) {
$maxRow = $realRow;
}
if ($column < $minColumn) {
$minColumn = $column;
}
if ($realRow < $minRow) {
$minRow = $realRow;
}
}
}
if (!empty($newGroup)) {
$graphHtml .= ''; //style="display:grid"
}
$addRow = 0;
if (!empty($label)) {
$graphHtml .= "
$label
";
$addRow = 1;
}
foreach ($subGroupList as $item) {
$graphHtml .= self::parseVertexList(
$groupCourseList,
$item['items'],
$addRow,
$graph,
$newGroup,
$connections
);
}
if (!empty($newGroup)) {
$graphHtml .= '
';
}
}
return $graphHtml;
}
/**
* @param array $groupCourseList
* @param array $vertexList
* @param int $addRow
* @param stdClass $graph
* @param int $group
* @param array $connections
*
* @return string
*/
public static function parseVertexList($groupCourseList, $vertexList, $addRow = 0, &$graph, $group, &$connections)
{
if (empty($vertexList)) {
return '';
}
$graphHtml = '';
/** @var Vertex $vertex */
foreach ($vertexList as $vertex) {
$column = $vertex->getAttribute('Column');
$realRow = $originalRow = $vertex->getAttribute('Row');
if ($addRow) {
$realRow = $realRow + $addRow;
}
$id = $vertex->getId();
$area = "$realRow/$column";
$graphHtml .= '';
$color = '';
if (!empty($vertex->getAttribute('DefinedColor'))) {
$color = $vertex->getAttribute('DefinedColor');
}
$content = '
'.$vertex->getAttribute('Notes').'
';
$content .= '
['.$id.']
';
$title = $vertex->getAttribute('graphviz.label');
if (!empty($vertex->getAttribute('LinkedElement'))) {
$title = Display::url($title, $vertex->getAttribute('LinkedElement'));
}
$originalRow--;
$column--;
//$title = "$originalRow / $column";
$graphHtml .= Display::panel(
$content,
$title,
null,
null,
null,
"row_$id",
$color
);
$panel = Display::panel(
$content,
$title,
null,
null,
null,
"row_$id",
$color
);
$x = $column * $graph->blockWidth + $graph->xDiff;
$y = $originalRow * $graph->blockHeight + $graph->yDiff;
$width = $graph->blockWidth - $graph->xGap;
$height = $graph->blockHeight - $graph->yGap;
$style = 'text;html=1;strokeColor=green;fillColor=#ffffff;overflow=fill;rounded=0;align=left;';
$panel = str_replace(["\n", "\r"], '', $panel);
$vertexData = "var v$id = graph.insertVertex(parent, null, '".addslashes($panel)."', $x, $y, $width, $height, '$style');";
$graph->elementList[$id] = $vertexData;
$graph->allData[$id] = [
'x' => $x,
'y' => $y,
'width' => $width,
'height' => $height,
'row' => $originalRow,
'column' => $column,
'label' => $title,
];
if ($x < $graph->groupList[$group]['min_x']) {
$graph->groupList[$group]['min_x'] = $x;
}
if ($y < $graph->groupList[$group]['min_y']) {
$graph->groupList[$group]['min_y'] = $y;
}
$graph->groupList[$group]['max_width'] = ($column + 1) * ($width + $graph->xGap) - $graph->groupList[$group]['min_x'];
$graph->groupList[$group]['max_height'] = ($originalRow + 1) * ($height + ($graph->yGap)) - $graph->groupList[$group]['min_y'];
$graphHtml .= '
';
$arrow = $vertex->getAttribute('DrawArrowFrom');
$found = false;
if (!empty($arrow)) {
$pos = strpos($arrow, 'SG');
if ($pos === false) {
$pos = strpos($arrow, 'G');
if (is_numeric($pos)) {
$parts = explode('G', $arrow);
if (empty($parts[0]) && count($parts) == 2) {
$groupArrow = $parts[1];
$graphHtml .= self::createConnection(
"group_$groupArrow",
"row_$id",
['Left', 'Right']
);
$found = true;
$connections[] = [
'from' => "g$groupArrow",
'to' => "v$id",
];
}
}
} else {
// Case is only one subgroup value example: SG1
$parts = explode('SG', $arrow);
if (empty($parts[0]) && count($parts) == 2) {
$subGroupArrow = $parts[1];
$graphHtml .= self::createConnection(
"subgroup_$subGroupArrow",
"row_$id",
['Left', 'Right']
);
$found = true;
$connections[] = [
'from' => "sg$subGroupArrow",
'to' => "v$id",
];
}
}
if ($found == false) {
// case is connected to 2 subgroups: Example SG1-SG2
$parts = explode('-', $arrow);
if (count($parts) == 2 && !empty($parts[0]) && !empty($parts[1])) {
$defaultArrow = ['Top', 'Bottom'];
$firstPrefix = '';
$firstId = '';
$secondId = '';
$secondPrefix = '';
if (is_numeric($pos = strpos($parts[0], 'SG'))) {
$firstPrefix = 'sg';
$firstId = str_replace('SG', '', $parts[0]);
}
if (is_numeric($pos = strpos($parts[1], 'SG'))) {
$secondPrefix = 'sg';
$secondId = str_replace('SG', '', $parts[1]);
}
if (!empty($secondId) && !empty($firstId)) {
$connections[] = [
'from' => $firstPrefix.$firstId,
'to' => $secondPrefix.$secondId,
$defaultArrow,
];
$found = true;
}
}
}
if ($found == false) {
// case DrawArrowFrom is an integer
$defaultArrow = ['Left', 'Right'];
if (isset($groupCourseList[$column]) &&
in_array($arrow, $groupCourseList[$column])
) {
$defaultArrow = ['Top', 'Bottom'];
}
$graphHtml .= self::createConnection(
"row_$arrow",
"row_$id",
$defaultArrow
);
$connections[] = [
'from' => "v$arrow",
'to' => "v$id",
];
}
}
}
return $graphHtml;
}
/**
* @param array $groupCourseList list of groups and their courses
* @param int $group
* @param string $groupLabel
* @param bool $showGroupLine
* @param array $subGroupList
* @param $widthGroup
*
* @return string
*/
public static function parseSubGroups(
$groupCourseList,
$group,
$groupLabel,
$showGroupLine,
$subGroupList,
$widthGroup
) {
$topValue = 90;
$defaultSpace = 40;
$leftGroup = $defaultSpace.'px';
if ($group == 1) {
$leftGroup = 0;
}
$groupIdTag = "group_$group";
$borderLine = $showGroupLine === true ? 'border-style:solid;' : '';
$graphHtml = '';
if (!empty($groupLabel)) {
$graphHtml .= '
'.$groupLabel.'
';
}
foreach ($subGroupList as $subGroup => $subGroupData) {
$subGroupLabel = isset($subGroupData['label']) ? $subGroupData['label'] : '';
$columnList = isset($subGroupData['columns']) ? $subGroupData['columns'] : [];
if (empty($columnList)) {
continue;
}
$line = '';
if (!empty($subGroup)) {
$line = 'border-style:solid;';
}
// padding:15px;
$graphHtml .= '
';
if (!empty($subGroupLabel)) {
$graphHtml .= '
'.$subGroupLabel.'
';
}
foreach ($columnList as $column => $rows) {
$leftColumn = $defaultSpace.'px';
if ($column == 1) {
$leftColumn = 0;
}
if (count($columnList) == 1) {
$leftColumn = 0;
}
$widthColumn = 85 / count($columnList);
$graphHtml .= '
';
$maxRow = 0;
foreach ($rows as $row => $vertex) {
if ($row > $maxRow) {
$maxRow = $row;
}
}
$newRowList = [];
$defaultSubGroup = -1;
$subGroupCountList = [];
for ($i = 0; $i < $maxRow; $i++) {
/** @var Vertex $vertex */
$vertex = isset($rows[$i + 1]) ? $rows[$i + 1] : null;
if (!is_null($vertex)) {
$subGroup = $vertex->getAttribute('SubGroup');
if ($subGroup == '' || empty($subGroup)) {
$defaultSubGroup = 0;
} else {
$defaultSubGroup = (int) $subGroup;
}
}
$newRowList[$i + 1][$defaultSubGroup][] = $vertex;
if (!isset($subGroupCountList[$defaultSubGroup])) {
$subGroupCountList[$defaultSubGroup] = 1;
} else {
$subGroupCountList[$defaultSubGroup]++;
}
}
$subGroup = null;
$subGroupAdded = [];
/** @var Vertex $vertex */
foreach ($newRowList as $row => $subGroupList) {
foreach ($subGroupList as $subGroup => $vertexList) {
if (!empty($subGroup) && $subGroup != -1) {
if (!isset($subGroupAdded[$subGroup])) {
$subGroupAdded[$subGroup] = 1;
} else {
$subGroupAdded[$subGroup]++;
}
}
foreach ($vertexList as $vertex) {
if (is_null($vertex)) {
$graphHtml .= '
';
$graphHtml .= '
';
continue;
}
$id = $vertex->getId();
$rowId = "row_$row";
$graphHtml .= '
';
$color = '';
if (!empty($vertex->getAttribute('DefinedColor'))) {
$color = $vertex->getAttribute('DefinedColor');
}
$content = $vertex->getAttribute('Notes');
$content .= '
['.$id.']
';
$title = $vertex->getAttribute('graphviz.label');
if (!empty($vertex->getAttribute('LinkedElement'))) {
$title = Display::url($title, $vertex->getAttribute('LinkedElement'));
}
$graphHtml .= Display::panel(
$content,
$title,
null,
null,
null,
null,
$color
);
$graphHtml .= '
';
$arrow = $vertex->getAttribute('DrawArrowFrom');
$found = false;
if (!empty($arrow)) {
$pos = strpos($arrow, 'SG');
if ($pos === false) {
$pos = strpos($arrow, 'G');
if (is_numeric($pos)) {
$parts = explode('G', $arrow);
if (empty($parts[0]) && count($parts) == 2) {
$groupArrow = $parts[1];
$graphHtml .= self::createConnection(
"group_$groupArrow",
"row_$id",
['Left', 'Right']
);
$found = true;
}
}
} else {
$parts = explode('SG', $arrow);
if (empty($parts[0]) && count($parts) == 2) {
$subGroupArrow = $parts[1];
$graphHtml .= self::createConnection(
"subgroup_$subGroupArrow",
"row_$id",
['Left', 'Right']
);
$found = true;
}
}
}
if ($found == false) {
$defaultArrow = ['Left', 'Right'];
if (isset($groupCourseList[$group]) &&
in_array($arrow, $groupCourseList[$group])
) {
$defaultArrow = ['Top', 'Bottom'];
}
$graphHtml .= self::createConnection(
"row_$arrow",
"row_$id",
$defaultArrow
);
}
}
}
}
$graphHtml .= '
';
}
$graphHtml .= '
';
}
$graphHtml .= '
';
return $graphHtml;
}
/**
* @param string $source
* @param string $target
* @param array $anchor
*
* @return string
*/
public static function createConnection($source, $target, $anchor = [])
{
if (empty($anchor)) {
// Default
$anchor = ['Bottom', 'Right'];
}
$anchor = implode('","', $anchor);
$html = ''.PHP_EOL;
return $html;
}
}