function _get_dataset($sites = array(), &$all_site_ids, $client_tab_id = 0, $client_tab_columns = array(), $start_date = 0, $end_date = 0, &$total_stats = array(), $csv = false)
{
$result = array();
$grid_method = get_grid_method_from_page();
$user = $this->session->all_userdata();
if (!empty($sites)) {
$this->load->model('model_sites');
$this->load->model('model_site_whois');
if ($client_tab_id == '0') {
$data_types = array();
if (!empty($client_tab_columns)) {
foreach ($client_tab_columns as $client_tab_column) {
$data_types[$client_tab_column['attribute_array_index']] = $client_tab_column['attribute_value_type'];
}
}
foreach ($sites as $site) {
$this_site = array($site['site_id']);
$all_site_ids[] = $site['site_id'];
foreach ($site as $site_key => $value) {
// Taken care of
if ($site_key == 'site_id' || $site_key == 'site_notes' || $site_key == 'site_displayed_flag') {
continue;
}
if ($site_key == 'site_title') {
$classes = 'tooltip fg-button ui-state-default fg-button-icon-solo ui-corner-all';
if (!$csv) {
$actions = '<a href="javascript: void(0);" title="Popup Edit" class="' . $classes . ' popup_edit" id="' . $site['site_id'] . '">' . '<span class="ui-icon ui-icon-newwin"></span> </a>' . '<a href="javascript: void(0);" title="Inline Edit" class="' . $classes . ' edit" id="' . $site['site_id'] . '">' . '<span class="ui-icon ui-icon-arrow-1-e"></span> </a>' . '<a href="javascript: void(0);" title="Delete Site" class="' . $classes . ' delete" id="' . $site['site_id'] . '">' . '<span class="ui-icon ui-icon-close"></span> </a>';
$this_site[] = $actions;
if (!empty($site['site_notes'])) {
$title = $site['site_notes'];
} else {
$title = $site['site_title'];
}
if (is_domain($site['site_title'])) {
$value = '<a href="http://' . $site['site_title'] . '" target="_blank" class="tooltip" title="' . $title . '">' . $site['site_title'] . '</a>';
} else {
$value = '<span class="tooltip" title="' . $title . '">' . $site['site_title'] . '</span>';
}
$checked = '';
if ($site['site_displayed_flag'] == '1') {
$checked = ' checked';
}
$disp_title = 'Display on Dashboard';
$disp_id = 'site_displayed_flag-' . $site['site_id'];
$this_site[] = '<input title="' . $disp_title . '" type="checkbox" class="site_displayed_flag tooltip" id="' . $disp_id . '" value="1"' . $checked . '>' . $value;
}
} else {
if ($data_types[$site_key] == 'PC') {
$contact_parts = explode("\t", $site[$site_key]);
if ($csv) {
$this_site[] = isset($contact_parts[0]) ? $contact_parts[0] : '';
$this_site[] = isset($contact_parts[1]) ? $contact_parts[1] : '';
$this_site[] = isset($contact_parts[2]) ? $contact_parts[2] : '';
$this_site[] = isset($contact_parts[3]) ? $contact_parts[3] : '';
} else {
$value = $contact_parts[0];
if (!empty($contact_parts[1])) {
$value .= ', email: ' . $contact_parts[1];
}
if (!empty($contact_parts[2])) {
$value .= ', phone: ' . $contact_parts[2];
}
if (!empty($contact_parts[3])) {
$value .= ', mobile: ' . $contact_parts[3];
}
$this_site[] = $value;
}
} else {
$this_site[] = $csv ? csv_output($value) : $value;
}
}
}
$result[] = $this_site;
}
} else {
$this->model_sites->get_site_stats($sites, $user, $start_date, $end_date, $total_stats);
$sites_keys = array();
$contact_keys = array();
if (!empty($client_tab_columns)) {
foreach ($client_tab_columns['columns'] as $client_tab_column) {
if ($client_tab_column['attributeType'] == 'PC') {
$contact_keys[] = $client_tab_column['id'];
}
}
$contact_keys = array_intersect($contact_keys, array_keys($sites[0]));
foreach ($sites as $site) {
$site['id'] = $site['site_id'];
$all_site_ids[] = $site['site_id'];
$classes = 'tooltip fg-button ui-state-default fg-button-icon-solo ui-corner-all';
$actions = '<a href="javascript: void(0);" title="View/edit all details" class="' . $classes . ' popup_edit" id="' . $site['site_id'] . '">' . '<span class="ui-icon ui-icon-newwin"></span> </a>' . '<a href="javascript: void(0);" title="Report an issue with this site" class="' . $classes . ' popup_report" id="' . $site['site_id'] . '">' . '<span class="ui-icon ui-icon-flag"></span> </a>';
$site['actions'] = $actions;
if (!empty($site['site_notes'])) {
$title = $site['site_notes'];
} else {
$title = $site['site_title'];
}
if (is_domain($site['site_title'])) {
$value = '<a href="http://' . $site['site_title'] . '" target="_blank" class="tooltip" title="' . $title . '">' . $site['site_title'] . '</a>';
} else {
$value = '<span class="tooltip" title="' . $title . '">' . $site['site_title'] . '</span>';
}
$site['site_title'] = $value;
if (!empty($contact_keys)) {
foreach ($contact_keys as $contact_key) {
$contact_parts = explode("\t", $site[$contact_key]);
$value = $contact_parts[0];
if (!empty($contact_parts[1])) {
$value .= ', email: ' . $contact_parts[1];
}
if (!empty($contact_parts[2])) {
$value .= ', phone: ' . $contact_parts[2];
}
if (!empty($contact_parts[3])) {
$value .= ', mobile: ' . $contact_parts[3];
}
$site[$contact_key] = $value;
}
}
// Don't need site_notes any more
unset($site['site_notes']);
$result[] = $site;
}
}
}
}
return $result;
}
csv_output("Date" . $sep . "Registered User" . $sep . "Registered Projects" . $eol);
//echo "Min: $min_year/$min_month\n";
//echo "Max: $max_year/$max_month\n";
for ($year = $min_year; $year <= $max_year; $year++) {
$y_min_month = 1;
if ($year == $min_year) {
$y_min_month = $min_month;
}
$y_max_month = 12;
if ($year == $max_year) {
$y_max_month = $max_month;
}
for ($month = $y_min_month; $month <= $y_max_month; $month++) {
$user = 0;
if (isset($total_array[$year][$month]['user'])) {
$user = $total_array[$year][$month]['user'];
}
$group = 0;
if (isset($total_array[$year][$month]['group'])) {
$group = $total_array[$year][$month]['group'];
}
csv_output('1/' . $month . '/' . $year . $sep . $user . $sep . $group . $eol);
}
}
//fclose($fd);
#removed_user
#select YEAR(FROM_UNIXTIME(date)) as year, MONTH(FROM_UNIXTIME(date)) as month, count(*) as c from group_history where field_name='removed_user' group by year,month order by year,month;
#added_user
#select YEAR(FROM_UNIXTIME(date)) as year, MONTH(FROM_UNIXTIME(date)) as month, count(*) as c from group_history where field_name like 'added_user%' group by year,month order by year,month;
#6632
#1023
