| Raamatu pealkiri | Kokku | Unikaalseid | Lehitsetud | Kirjastuse e-poele | Apollole | Rahva Raamatule | Raamatukoile | TLBanner | Flash Banner |
|---|---|---|---|---|---|---|---|---|---|
| " . l($fetch_name['name'], "node/$obj->nid") . " | " . $obj->total; $output .= " | " . $obj->visits; $output .= " | " .$result_lehitsenud['count(source)']. " | " . $result_kirjastus['count(source)'] . " | " . $result_apollo['count(source)'] . " | " . $result_rahva['count(source)'] . " | " . $result_raamatukoja['count(source)'] . " | ". $result_top_right_banner['count(source)'] . " | " . $result_flash_banner['count(source)'] . " |
- Külastused on tõusnud eelmise perioodiga võrreldes.
- Külastused on langenud eelmise perioodiga võrreldes.";
/*
if($user->uid == 1) {
if($_GET['fill'] == 'yes') {
print "DEBUG:';
$form['date'] = array(
'#type' => "textfield",
'#title' => t('Date'),
'#size' => 10,
'#default_value' => $_SESSION['filter']['start_date'],
'#required' => TRUE,
'#field_suffix' => $suffix,
);
$suffi2x = '';
$suffi2x .= '';
$form['enddate'] = array(
'#type' => "textfield",
'#title' => t('Date'),
'#size' => 10,
'#default_value' => $_SESSION['filter']['end_date'],
'#required' => TRUE,
'#field_suffix' => $suffi2x,
);
$form['submit'] = array('#type' => 'submit', '#value' => t('Show'));
return $form;
}
function statistics_admin_form($form_state) {
$sql = db_query("SELECT {users}.name, {profile_values}.value, {users_roles}.rid, {users_roles}.uid FROM {profile_values}, {users_roles}, {users} WHERE {users_roles}.rid = 4 AND {users_roles}.uid = {profile_values}.uid AND {profile_values}.fid = 4 AND {users}.uid = {users_roles}.uid ORDER BY {profile_values}.value ASC");
while($roles = db_fetch_array($sql)) {
if($roles['value'] == '') $roles['value'] = '? ('.$roles['name'].')';
$user_array[$roles['uid']] = $roles['value'];
}
$user_array[$roles[1]] = "admin";
$form['select_user'] = array(
'#type' => "select",
'#title' => t("Kirjastaja"),
'#options' => $user_array,
'#description' => t("Vali Kirjastaja"),
'#default_value' => $_SESSION['filter']['user'],
);
$form['submit'] = array('#type' => 'submit', '#value' => t('Show'));
return $form;
}
function statistics_view_form_submit($form, &$form_state) {
$_SESSION['filter']['start_date'] = $form_state['values']['date'];
$_SESSION['filter']['end_date'] = $form_state['values']['enddate'];
}
function statistics_admin_form_submit($form, &$form_state) {
$_SESSION['filter']['user'] = $form_state['values']['select_user'];
}
function build_fill_array() {
$nids = db_query("SELECT nid FROM {node} WHERE type='raamat'");
while($nid_array = db_fetch_array($nids)) {
$nid[] = $nid_array['nid'];
}
$start_ts = mktime(0,0,0, 12, 10, date('Y'));
$end_ts = mktime(0,0,0, 12, 13, date('Y'));
while($start_ts <= $end_ts) {
$day = mktime(12,0,0, date('m', $start_ts), date('d', $start_ts), date('Y', $start_ts));
$range_from = mktime(0,0,0, date('m', $start_ts), date('d', $start_ts), date('Y', $start_ts));
$range_to = mktime(23,59,59, date('m', $start_ts), date('d', $start_ts), date('Y', $start_ts));
foreach($nid as $n) {
$results = db_fetch_object(db_query("SELECT count(hostname) as total, count(distinct hostname) as visits FROM {accesslog} WHERE timestamp BETWEEN %d AND %d AND path = 'node/%d'", $range_from, $range_to, $n));
$sql_insert = "INSERT INTO {statistics_view} (`id`, `nid`, `total`, `unique`, `timestamp`, `date`) VALUES (NULL, $n, $results->total, $results->visits, ".mktime().", '$day');";
db_query($sql_insert);
}
$start_ts = mktime(0,0,0, date('m', $start_ts), date('d', $start_ts)+1, date('Y', $start_ts));
}
}
function statistics_view_cron() {
$day_start = mktime(0,0,0,date('m'), date('d')-1, date('Y'));
$day_end = mktime(23,59,59, date('m'), date('d')-1, date('Y'));
$range = "AND timestamp BETWEEN $day_start AND $day_end";
$nids = db_query("SELECT nid FROM {node} WHERE type='raamat'");
while($db = db_fetch_object($nids)) {
$sql = db_query("SELECT count(hostname) as total, count(distinct hostname) as visits FROM {accesslog} WHERE path = 'node/%d' $range ", $db->nid);
$db_array = db_fetch_object($sql);
$sql_insert = "INSERT INTO {statistics_view} (`id`, `nid`, `total`, `unique`, `timestamp`, `date`) VALUES (NULL, $db->nid, $db_array->total, $db_array->visits, ".mktime().", ".mktime(12,0,0, date('m', $day_start), date('d', $day_start), date('Y', $day_start)).");";
db_query($sql_insert);
}
}