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(); }