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