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;
}
<div class="custom-properties"><?php
require_javascript("og/CustomProperties.js");
$ot = ObjectTypes::findById($member->getObjectTypeId());
if ($ot->getName() == 'project_folder' || $ot->getName() == 'customer_folder') {
$ot = ObjectTypes::findByName('folder');
}
$cps = MemberCustomProperties::getAllMemberCustomPropertiesByObjectType($ot->getId(), $visibility);
if ($visibility == 'others' && count($cps) == 0 && Plugins::instance()->isActivePlugin('member_custom_properties')) {
echo lang('there are no custom properties defined message', strtolower(lang($ot->getName())), escape_character($member->getName()));
echo '<br />' . lang('there are no custom properties defined link');
}
if (!$parent_member) {
$parent_member = 0;
}
$ti = 0;
if (!isset($genid)) {
$genid = gen_id();
}
if (!isset($startTi)) {
$startTi = 10000;
}
if (count($cps) > 0) {
$print_table_functions = false;
foreach ($cps as $customProp) {
if (!isset($required) || $required && ($customProp->getIsRequired() || $customProp->getVisibleByDefault()) || !$required && !($customProp->getIsRequired() || $customProp->getVisibleByDefault())) {
$ti++;
$cpv = MemberCustomPropertyValues::getMemberCustomPropertyValue($member->getId(), $customProp->getId());
$default_value = $customProp->getDefaultValue();
if ($cpv instanceof MemberCustomPropertyValue) {
$default_value = $cpv->getValue();
}
