private function prepareObject($rows, $start, $limit, $dimension, $member_type_id, $total)
{
$custom_properties = MemberCustomProperties::getAllMemberCustomPropertiesByObjectType($member_type_id);
$ot = ObjectTypes::findById($member_type_id);
$object = array("totalCount" => $total, "start" => $start, "dimension_id" => $dimension->getId(), "dimension_name" => $dimension->getName(), "object_type_name" => $ot->getName(), "members" => array());
$member_ids = array();
$ids = array();
for ($i = 0; $i < $limit; $i++) {
if (isset($rows[$i])) {
$row = $rows[$i];
$info = $row;
$info['icon_cls'] = $ot->getIconClass();
$path_ids = array();
$m = Members::findById(array_var($row, 'member_id'));
$all_parents = $m->getAllParentMembersInHierarchy();
foreach ($all_parents as $parent) {
if (!isset($path_ids[$dimension->getId()])) {
$path_ids[$dimension->getId()] = array();
}
$path_ids[$dimension->getId()][$parent->getId()] = $parent->getId();
break;
}
$info['mem_path'] = json_encode($path_ids);
// calculated info
/* $more_info = array(
'total_tasks' => array_var($row, 'total_tasks'),
'completed_tasks' => array_var($row, 'completed_tasks'),
'task_completion_p' => number_format(array_var($row, 'task_completion_p'), 2),
'total_estimated_time' => array_var($row, 'total_estimated_time'),
'total_worked_time' => array_var($row, 'total_worked_time'),
'time_worked_p' => number_format(array_var($row, 'time_worked_p'), 2),
);
$info = array_merge($info, $more_info);*/
$object["members"][] = $info;
$member_ids[] = array_var($row, 'member_id');
}
}
// set custom properties
foreach ($member_ids as $k => &$mid) {
if (!is_numeric($mid) || $mid == 0) {
unset($member_ids[$k]);
}
}
if (Plugins::instance()->isActivePlugin('member_custom_properties') && count($member_ids) > 0) {
foreach ($custom_properties as $cp) {
$cp_rows = DB::executeAll("SELECT * FROM " . TABLE_PREFIX . "member_custom_property_values cpv \r\n\t\t\t\t\tWHERE cpv.member_id IN (" . implode(',', $member_ids) . ") \r\n\t\t\t\t\tAND cpv.custom_property_id = '" . $cp->getId() . "' AND cpv.value != ''\r\n\t\t\t\t\tAND cpv.value != '" . EMPTY_DATETIME . "' AND cpv.value != '" . EMPTY_DATE . "'\r\n\t\t\t\t\tORDER BY cpv.member_id");
$mcpv = new MemberCustomPropertyValue();
foreach ($cp_rows as $cp_row) {
$mcpv->setValue($cp_row['value']);
$cp_val = get_member_custom_property_value_for_listing($cp, $cp_row['member_id'], array($mcpv));
foreach ($object["members"] as &$x) {
if ($x['member_id'] == $cp_row['member_id']) {
$x['cp_' . $cp->getId()] = $cp_val;
break;
}
}
}
}
}
return $object;
}
} else {
echo select_box($name, $options, array('tabindex' => $startTi + $ti, 'style' => 'min-width:140px', 'id' => $genid . 'cp' . $customProp->getId()));
}
break;
case 'table':
$columnNames = explode(',', $customProp->getValues());
$cell_width = 600 / count($columnNames) . "px";
$html = '<div class="og-add-custom-properties"><table><tr>';
foreach ($columnNames as $colName) {
$html .= '<th style="width:' . $cell_width . ';min-width:120px;">' . $colName . '</th>';
}
$ti += 1000;
$html .= '</tr><tr>';
$values = MemberCustomPropertyValues::getMemberCustomPropertyValues($member->getId(), $customProp->getId());
if (trim($default_value) != '' && (!is_array($values) || count($values) == 0)) {
$def_cp_value = new MemberCustomPropertyValue();
$def_cp_value->setValue($default_value);
$values = array($def_cp_value);
}
$rows = 0;
if (is_array($values) && count($values) > 0) {
foreach ($values as $val) {
$col = 0;
$values = str_replace("\\|", "%%_PIPE_%%", $val->getValue());
$exploded = explode("|", $values);
foreach ($exploded as $v) {
$v = str_replace("%%_PIPE_%%", "|", $v);
$html .= '<td><input class="value" style="width:' . $cell_width . ';min-width:120px;" name="' . $name . "[{$rows}][{$col}]" . '" value="' . clean($v) . '" tabindex="' . ($startTi + $ti++) . '"/></td>';
$col++;
}
$html .= '<td><div class="ico ico-delete" style="width:16px;height:16px;cursor:pointer" onclick="og.removeTableCustomPropertyRow(this.parentNode.parentNode);return false;"> </div></td>';
