function setupMySql($dbCon)
{
try {
//chmod(realpath(__DIR__ . '/src'),0755);
$query = getSql();
$setup = $dbCon->prepare($query);
$setup->execute();
} catch (Exception $e) {
return false;
}
return $dbCon;
}
function getKinchRanks()
{
global $common, $pdo, $gender, $kinch, $type, $lang;
$sql = getSql();
$stmt = $pdo->query($sql);
$i = 1;
$preScore = "";
foreach ($stmt as $row) {
if ($kinch == 'all' or $kinch == '') {
$score = $row['Score'];
$s333 = $row['333'];
$s444 = $row['444'];
$s555 = $row['555'];
$s222 = $row['222'];
$s333oh = $row['333oh'];
$s333ft = $row['333ft'];
$sMinx = $row['minx'];
$sPyram = $row['pyram'];
$sSq1 = $row['sq1'];
$sClock = $row['clock'];
$sSkewb = $row['skewb'];
$s666 = $row['666'];
$s777 = $row['777'];
$s333bf = $row['333bf'];
$s333fm = $row['333fm'];
$s444bf = $row['444bf'];
$s555bf = $row['555bf'];
$s333mbf = $row['333mbf'];
} elseif ($kinch == 'main') {
$score = $row['ScoreMain'];
$s333 = $row['333'];
$s444 = $row['444'];
$s555 = $row['555'];
$s222 = $row['222'];
$s333oh = "0.00";
$s333ft = "0.00";
$sMinx = "0.00";
$sPyram = "0.00";
$sSq1 = "0.00";
$sClock = "0.00";
$sSkewb = "0.00";
$s666 = "0.00";
$s777 = "0.00";
$s333bf = "0.00";
$s333fm = "0.00";
$s444bf = "0.00";
$s555bf = "0.00";
$s333mbf = "0.00";
} elseif ($kinch == '333') {
$score = $row['Score333'];
$s333 = $row['333'];
$s444 = "0.00";
$s555 = "0.00";
$s222 = "0.00";
$s333oh = $row['333oh'];
$s333ft = $row['333ft'];
$sMinx = "0.00";
$sPyram = "0.00";
$sSq1 = "0.00";
$sClock = "0.00";
$sSkewb = "0.00";
$s666 = "0.00";
$s777 = "0.00";
$s333bf = $row['333bf'];
$s333fm = $row['333fm'];
$s444bf = "0.00";
$s555bf = "0.00";
$s333mbf = "0.00";
} elseif ($kinch == 'big') {
$score = $row['ScoreBig'];
$s333 = "0.00";
$s444 = "0.00";
$s555 = $row['555'];
$s222 = "0.00";
$s333oh = "0.00";
$s333ft = "0.00";
$sMinx = "0.00";
$sPyram = "0.00";
$sSq1 = "0.00";
$sClock = "0.00";
$sSkewb = "0.00";
$s666 = $row['666'];
$s777 = $row['777'];
$s333bf = "0.00";
$s333fm = "0.00";
$s444bf = "0.00";
$s555bf = "0.00";
$s333mbf = "0.00";
} elseif ($kinch == 'bld') {
$score = $row['ScoreBld'];
$s333 = "0.00";
$s444 = "0.00";
$s555 = "0.00";
$s222 = "0.00";
$s333oh = "0.00";
$s333ft = "0.00";
$sMinx = "0.00";
$sPyram = "0.00";
$sSq1 = "0.00";
$sClock = "0.00";
$sSkewb = "0.00";
$s666 = "0.00";
$s777 = "0.00";
$s333bf = $row['333bf'];
$s333fm = "0.00";
$s444bf = $row['444bf'];
$s555bf = $row['555bf'];
$s333mbf = $row['333mbf'];
} elseif ($kinch == 'var') {
$score = $row['ScoreVar'];
$s333 = "0.00";
$s444 = "0.00";
$s555 = "0.00";
$s222 = "0.00";
$s333oh = "0.00";
$s333ft = "0.00";
$sMinx = $row['minx'];
$sPyram = $row['pyram'];
$sSq1 = $row['sq1'];
$sClock = $row['clock'];
$sSkewb = $row['skewb'];
$s666 = "0.00";
$s777 = "0.00";
$s333bf = "0.00";
$s333fm = "0.00";
$s444bf = "0.00";
$s555bf = "0.00";
$s333mbf = "0.00";
}
if ($score == $preScore) {
$rank = "";
} else {
$rank = $i;
}
echo <<<EOT
\t\t<tr>
\t\t\t<td>{$rank}</td>
\t\t\t<td>{$common->showFlag($row['countryId'])}{$row['countryId']}</td>
\t\t\t<td><span class='text-warning'><strong>{$common->scoreColor($score)}</strong></span></td>
\t\t\t<td class='text-right'>{$common->scoreColor($s333)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s444)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s555)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s222)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s333oh)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s333ft)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($sMinx)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($sPyram)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($sSq1)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($sClock)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($sSkewb)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s666)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s777)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s333bf)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s333fm)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s444bf)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s555bf)}</td>
\t\t\t<td class='text-right'>{$common->scoreColor($s333mbf)}</td>
\t\t</tr>
EOT;
$preScore = $score;
$preRank = $rank;
$i++;
}
}
function cleanCache($timespan = null)
{
global $cacheLimit;
if (!isset($timespan)) {
$timespan = $cacheLimit;
}
$sql = getSql();
if ($sql != null) {
$date = date("Y-m-d H:i:s", time() - $timespan);
$query = "delete from datacache where updated < '{$date}'";
if ($sql->query($query)) {
return true;
}
}
return false;
}
function getRanking()
{
global $common, $pdo, $region, $events, $gender, $show, $type, $lang;
$sql = getSql();
$stmt = $pdo->query($sql);
$i = 1;
$preRecord = "";
foreach ($stmt as $row) {
if ($lang == 'jp' and is_null($row['jname']) == false) {
$competition = $row['jname'];
} else {
$competition = $row['cellName'];
}
if ($type == '' or $type == 'single') {
$record = $common->resultConvert($events, $row['best']);
} elseif ($type == 'average') {
$record = $common->resultConvert($events, $row['average'], true);
}
if ($record == $preRecord) {
$rank = "";
} elseif (($show == '100' or $show == '') and $i > 100 or $show == 1000 and $i > 1000) {
break;
} else {
$rank = $i;
}
echo <<<EOT
\t\t<tr>
\t\t\t<td>{$rank}</td>
\t\t\t<td><a href='person.php?id={$row['personId']}'>{$row['personName']}</a></td>
\t\t\t<td>{$common->showFlag($row['countryId'])}{$row['countryId']}</td>
\t\t\t<td>{$record}</td>
\t\t\t<td><a href='results.php?id={$row['competitionId']}'>{$competition}</a></td>
\t\t\t<td>{$common->dateConvert($row['year'], $row['month'], $row['day'], $row['endMonth'], $row['endDay'])}</td>
\t\t</tr>
EOT;
$preRecord = $record;
$preRank = $rank;
$i++;
}
}
title_no AS title_no,
year AS year,
country AS country,
duration AS duration,
director AS director,
writter AS writter,
cast AS cast
FROM movie LIMIT $post, 3
';
header('Content-Type/json: application/json');
echo "{filmarks: " . json_encode(connectDb()->query($sql)->fetchAll(PDO::FETCH_ASSOC)) . "}";
} elseif (isset($_POST['grid3'])) {
$post = htmlspecialchars($_POST['grid3']);
$number = 3;
getSql($post, $number);
} elseif (isset($_POST['grid4'])) {
$post = htmlspecialchars($_POST['grid4']);
$number = 4;
getSql($post, $number);
} elseif (isset($_POST['grid5'])) {
$post = htmlspecialchars($_POST['grid5']);
$number = 5;
getSql($post, $number);
} elseif (isset($_POST['info'])) {
// ---- 映画情報の取得
$post = htmlspecialchars($_POST['info']);
getMovieInfo($post);
// getSql(0,2);
} else {
$post = 'error';
}
function getCompetitions()
{
global $common, $region, $search, $year, $pdo, $lang;
$sql = getSql();
$stmt = $pdo->query($sql);
// テーブル作成
foreach ($stmt as $row) {
if ($row['result'] == 0) {
$result = "class='info'";
} else {
$result = "";
}
if ($lang == 'jp' and is_null($row['jname']) == false) {
$competition = $row['jname'];
$city = $row['jarea'];
} else {
$competition = $row['cellName'];
$city = $row['cityName'];
}
echo <<<EOT
\t\t<tr {$result}>
\t\t<td>{$common->dateConvert($row['year'], $row['month'], $row['day'], $row['endMonth'], $row['endDay'])}</td>
\t\t<td><a href='results.php?id={$row['id']}'>{$competition}</a></td>
\t\t<td>{$common->showFlag($row['countryId'])}<strong>{$row['countryId']}</strong>, {$city}</td>
\t\t</tr>
EOT;
}
}
<?php
include "db.php";
include "baseListDao.php";
$tipoListado = $_GET['estado'];
$sqlList = getSql($tipoListado);
getList($sqlList);
closeConnection();
function getSql($idTipoListado)
{
$json = array();
//Recupero instalacion
$eventos = "select * from EventosCerradosCancelados_V";
return $eventos;
}
<?php
include "db.php";
include "baseListDao.php";
$sqlList = getSql();
getList($sqlList);
closeConnection();
function getSql()
{
$json = array();
//Recupero instalacion
$usuarios = "select * from Usuarios";
return $usuarios;
}
/**
* Функция для генерации массива новостей для RSS
*
*/
function rss(&$params)
{
$list = getSql("SELECT id, date, UNIX_TIMESTAMP(date) as ts, text_" . lang() . " as text, description_" . lang() . " as description FROM " . $this->table . " WHERE visible > 0 AND root_id=" . ROOT_ID . " ORDER BY date DESC LIMIT " . $params['limit']);
header('Content-Type: text/xml');
return array('list' => $list);
}
function GetTable()
{
global $limit;
$offset = (int) get('offset');
$limit = (int) get('limit', $this->Param('limit', $limit));
$reklams = sql_getRows("SELECT * FROM stat_reklama");
if (empty($reklams)) {
$ret['tip']['text'] = "Рекламные кампании не созданы. Для того чтобы создать рекламную кампанию, нажмите кнопку \"Настройка рекламных кампаний\".";
return $ret;
}
foreach ($reklams as $key => $reklama) {
if (!$reklama['click_count']) {
$reklama['click_count'] = 0;
}
if (!$reklama['displays_count']) {
$reklama['displays_count'] = 0;
}
if (!$reklama['displays_count']) {
$reklama['displays_count'] = 0;
}
if (!$reklama['budget']) {
$reklama['budget'] = 0;
}
$identifiers = explode(',', $reklama['identifiers']);
foreach ($identifiers as $k => $v) {
$identifiers[$k] = trim($v);
}
$identifiers_state = "";
if (!empty($identifiers)) {
$identifiers_state = " AND (";
foreach ($identifiers as $k => $v) {
$identifiers_state .= " page.uri LIKE '%from=" . $v . "'" . ($k < count($identifiers) - 1 ? " OR" : "");
}
$identifiers_state .= ") ";
}
// определяем дату начала рекламной кампании по первому вхождению
if ($reklama['start_date'] == '0000-00-00 00:00:00') {
$reklama['start_date'] = sql_getValue("SELECT min( time )\n \tFROM " . STAT_SESSIONS_TABLE . " as s LEFT JOIN stat_pages AS page ON page.id = s.first_page\n\t\t\t\tWHERE 1 " . $identifiers_state);
if (!$reklama['start_date']) {
$reklama['start_date'] = sql_getValue("SELECT min( time ) FROM " . STAT_SESSIONS_TABLE);
}
} else {
$reklama['start_date'] = strtotime($reklama['start_date']);
}
if ($reklama['end_date'] == '0000-00-00 00:00:00') {
$reklama['end_date'] = sql_getValue("SELECT max( time )\n \tFROM " . STAT_SESSIONS_TABLE . " as s LEFT JOIN stat_pages AS page ON page.id = s.first_page\n\t\t\t\tWHERE 1 " . $identifiers_state);
if (!$reklama['end_date']) {
$reklama['end_date'] = sql_getValue("SELECT max( time ) FROM " . STAT_SESSIONS_TABLE);
}
} else {
$reklama['end_date'] = strtotime($reklama['end_date']);
}
$date_state = "";
if ($reklama['start_date']) {
$date_state .= " AND sess.time>=" . $reklama['start_date'];
}
if ($reklama['end_date']) {
$date_state .= " AND sess.time<=" . $reklama['end_date'];
}
// Временные таблицы
// Выборка из stat_sessions за время кампании
$tmp_table = "`tmp_reklama`";
$sql = "DROP TABLE IF EXISTS " . $tmp_table;
sql_query($sql);
$sql = "CREATE TEMPORARY TABLE " . $tmp_table . " (\n \t\t\tPRIMARY KEY (`sess_id`),\n \t\t\tKEY `ip` (`ip`,`agent_id`),\n \t\t\tKEY `time` (`time`,`robot`),\n \t\t\tKEY `first_page` (`first_page`)\n\t\t\t) SELECT * FROM " . STAT_SESSIONS_TABLE . " AS sess WHERE sess.robot=0 " . $date_state;
$res = sql_query($sql);
if (sql_getErrNo()) {
$flag = sql_getError();
break;
}
// Выборка из stat_sessions за время кампании при условии $identifiers_state
$tmp_table_ident = "`tmp_reklama_ident`";
$sql = "DROP TABLE IF EXISTS " . $tmp_table_ident;
sql_query($sql);
$sql = "CREATE TEMPORARY TABLE " . $tmp_table_ident . " (\n \t\t\tPRIMARY KEY (`sess_id`),\n \t\t\tKEY `ip` (`ip`,`agent_id`),\n \t\t\tKEY `time` (`time`,`robot`),\n \t\t\tKEY `first_page` (`first_page`)\n\t\t\t) SELECT * FROM " . STAT_SESSIONS_TABLE . " AS sess, " . STAT_PAGES_TABLE . " as page \n\t\t\tWHERE sess.first_page=page.id AND sess.robot=0 " . $date_state . $identifiers_state;
$res = sql_query($sql);
if (sql_getErrNo()) {
$flag = sql_getError();
break;
}
$cnt = sql_getRow("SELECT COUNT(*) AS cnt, COUNT(DISTINCT(sess.ip)) as cnt_ip FROM " . $tmp_table . " AS sess");
// Общее число посетителей
$all_count = (int) $cnt['cnt'];
// Общее число ip адресов
$all_ip_count = (int) $cnt['cnt_ip'];
// Кол-во посетителей, просмотревших более 1 страницы
$sql = "SELECT COUNT(DISTINCT(sess.sess_id)) FROM " . $tmp_table_ident . " AS sess,\n " . STAT_PAGES_TABLE . " AS page WHERE page.id=sess.first_page\n AND sess.path!='' AND LENGTH(sess.path)-LENGTH(REPLACE(sess.path,' ',''))+1 > 1 ";
$count_pages[1] = (int) sql_getValue($sql);
// Кол-во посетителей, просмотревших более 2 страниц
$sql = "SELECT COUNT(DISTINCT(sess.sess_id)) FROM " . $tmp_table_ident . " AS sess,\n " . STAT_PAGES_TABLE . " AS page WHERE page.id=sess.first_page\n AND sess.path!='' AND LENGTH(sess.path)-LENGTH(REPLACE(sess.path,' ',''))+1 > 2 ";
$count_pages[2] = (int) sql_getValue($sql);
// Выбираем поля
$select = array();
############################################################################################
// название кампании
$select[] = "'" . $reklama['name'] . "' AS campaign";
// дата начала кампании
$select[] = "FROM_UNIXTIME(" . $reklama['start_date'] . ", '%d.%m.%Y') AS start_date";
// дата окончания кампании
$select[] = "FROM_UNIXTIME(" . $reklama['end_date'] . ", '%d.%m.%Y') AS end_date";
// бюждет кампании
$select[] = "'" . $reklama['budget'] . "' AS budget";
// кол-во показов
$select[] = "'" . $reklama['displays_count'] . "' AS displays_count";
// Общее число посетителей
$select[] = "'" . $all_count . "' AS all_count";
// количество рекламных посетителей
$select[] = "CONCAT(COUNT(DISTINCT(sess.sess_id)), ' <span style=\"font-size: 85%\">(', '" . $reklama['click_count'] . "',')</span>') AS involved_visitors_fact";
// доля рекламы в посещаемости
$select[] = "CONCAT(IF(" . $all_count . "!=0,COUNT(DISTINCT(sess.sess_id))/" . $all_count . ",0)*100,'%') AS reklama_to_attendance";
// ip адресов
$select[] = "CONCAT(COUNT(DISTINCT(sess.ip)), ' <span style=\"font-size: 85%\">(', IF(" . $all_ip_count . "!=0,COUNT(DISTINCT(sess.ip))/" . $all_ip_count . ",0)*100, '%)</span>') AS ip_count_share";
// события
if ($this->events) {
foreach ($this->events as $k => $event) {
// Временная таблица
$tmp_table_event = "`tmp_reklama_event`";
$sql = "DROP TABLE IF EXISTS " . $tmp_table_event;
getSql($sql);
$sql = "CREATE TEMPORARY TABLE " . $tmp_table_event . " (\n\t\t\t\t\tPRIMARY KEY (`id`),\n \t\t\t\t\tKEY `host_uri` (`host`,`uri`)\n\t\t\t\t\t) SELECT * FROM " . STAT_PAGES_TABLE . " AS page \n\t\t\t\t\tWHERE page.uri LIKE '" . str_replace("*", "%", $event['url']) . "'";
$res = getSql($sql);
if (sql_getErrNo()) {
$flag = sql_getError();
break;
}
$sql = "SELECT COUNT(DISTINCT(sess.sess_id)) AS count\n FROM " . STAT_LOG_TABLE . " AS sess,\n " . $tmp_table_event . " AS page\n WHERE sess.page_id=page.id " . $date_state;
$all_event_count = (int) sql_getValue($sql);
// Кол-во событий за время рекламной кампании
$identifiers_state2 = str_replace('page.uri', 'page2.uri', $identifiers_state);
$sql = "SELECT COUNT(DISTINCT(sess.sess_id)) AS count FROM " . $tmp_table_ident . " AS sess,\n " . STAT_LOG_TABLE . " AS log,\n " . STAT_PAGES_TABLE . " AS page2,\n " . STAT_PAGES_TABLE . " AS page\n WHERE sess.sess_id=log.sess_id AND log.page_id=page2.id AND sess.first_page=page.id\n AND page2.uri LIKE '" . str_replace("*", "%", $event['url']) . "'";
$event_count[$k] = (int) sql_getValue($sql);
// Кол-во событий по клику
$select[] = "CONCAT('" . $event_count[$k] . "', ' <span style=\"font-size: 85%\">(', IF(" . $all_event_count . "!=0," . $event_count[$k] . "/" . $all_event_count . ",0)*100, '%)</span>') AS event_" . $k . "_share";
}
}
$select[] = "' ' as line1";
############################################################################################
// CTR
$select[] = "CONCAT(IF(" . $reklama['displays_count'] . "!=0,COUNT(page.uri)/" . $reklama['displays_count'] . ",0)*100, '% <span style=\"font-size: 85%\">(', IF(" . $reklama['displays_count'] . "!=0," . $reklama['click_count'] . "/" . $reklama['displays_count'] . ",0)*100, '%</span>)') AS CTR_fact";
// ip адреса
$select[] = "CONCAT(IF(COUNT(DISTINCT(sess.sess_id))!=0,COUNT(DISTINCT(sess.ip))/COUNT(DISTINCT(sess.sess_id)),0)*100, '% / ', IF(" . $reklama['displays_count'] . "!=0,COUNT(DISTINCT(sess.ip))/" . $reklama['displays_count'] . ",0)*100, '%') AS client_ip_slash";
// качество просмотра (просмотревшие более 1 страницы)
$select[] = "CONCAT('" . $count_pages[1] . "', ' / ', IF(COUNT(DISTINCT(sess.sess_id))!=0," . $count_pages[1] . "/COUNT(DISTINCT(sess.sess_id)),0)*100, '% / ', IF(" . $reklama['displays_count'] . "!=0," . $count_pages[1] . "/" . $reklama['displays_count'] . ",0)*100, '%') AS client_1_slash";
// качество просмотра (просмотревшие более 2 страниц)
$select[] = "CONCAT('" . $count_pages[2] . "', ' / ', IF(COUNT(DISTINCT(sess.sess_id))!=0," . $count_pages[2] . "/COUNT(DISTINCT(sess.sess_id)),0)*100, '% / ', IF(" . $reklama['displays_count'] . "!=0," . $count_pages[2] . "/" . $reklama['displays_count'] . ",0)*100, '%') AS client_2_slash";
// события
if ($this->events) {
foreach ($this->events as $k => $event) {
$select[] = "CONCAT('" . $event_count[$k] . "', ' / ', IF(COUNT(DISTINCT(sess.sess_id))!=0," . $event_count[$k] . "/COUNT(DISTINCT(sess.sess_id)),0)*100, '% / ', IF(" . $reklama['displays_count'] . "!=0," . $event_count[$k] . "/" . $reklama['displays_count'] . ",0)*100, '%') AS event_" . $k . "_slash";
}
}
$select[] = "' ' as line2";
############################################################################################
// стоимость 1000 показов
$select[] = "ROUND(IF(" . $reklama['displays_count'] . "!=0," . $reklama['budget'] . "/" . $reklama['displays_count'] . ",0)*1000,2) AS display_1000_cost";
// стоимость клика
$select[] = "CONCAT(ROUND(IF(COUNT(DISTINCT(sess.sess_id))!=0," . $reklama['budget'] . "/COUNT(DISTINCT(sess.sess_id)), 0),2), ' <span style=\"font-size: 85%\">(', ROUND(IF(" . $reklama['click_count'] . "!=0," . $reklama['budget'] . "/" . $reklama['click_count'] . ", 0),2) ,'</span>)') AS click_cost";
// стоимость IP адреса
$select[] = "ROUND(IF(COUNT(DISTINCT(sess.ip))!=0," . $reklama['budget'] . "/COUNT(DISTINCT(sess.ip)),0),2) AS ip_cost";
// стоимость 2+
$select[] = "ROUND(IF(" . $count_pages[1] . "!=0," . $reklama['budget'] . "/" . $count_pages[1] . ",0),2) AS client_1_cost";
// стоимость 3+
$select[] = "ROUND(IF(" . $count_pages[2] . "!=0," . $reklama['budget'] . "/" . $count_pages[2] . ",0),2) AS client_2_cost";
// события
if ($this->events) {
foreach ($this->events as $k => $event) {
$select[] = "ROUND(IF(" . $event_count[$k] . "!=0," . $reklama['budget'] . "/" . $event_count[$k] . ",0),2) AS event_" . $k . "_cost";
}
}
############################################################################################
$sql = "SELECT " . implode(", ", $select) . "\n FROM " . $tmp_table_ident . " AS sess,\n " . STAT_PAGES_TABLE . " AS page WHERE page.id=sess.first_page";
$data[$key] = sql_getRow($sql);
}
/* $num = count($data);
if ($num > 0) {
$num_concat_share = array();
$num_concat_slash = array();
foreach ($data as $k=>$v) {
if ($k == $num) break;
$data[$k]['start_date'] = date('Y/m/d', $data[$k]['start_date']);
$data[$k]['end_date'] = date('Y/m/d', $data[$k]['end_date']);
foreach ($v as $k2=>$v2) {
if ($k2 == 'line1' || $k2 == 'line2') {$data[$num][$k2] = ' '; continue;}
if (strpos($k2,'_slash')!==false) {
$n = sscanf($v2, '%f/%f/%f/%f');
foreach ($n as $mm=>$nn) {
if (isset($nn)) $num_concat_slash[$num][$k2][$mm] += $nn;
}
$data[$num][$k2] = "";
} elseif (strpos($k2,'_share')!==false) {
$a = str_replace("%", "***", $v2);
list($n1, $n2) = sscanf($a, '%f <span style="font-size: 85***">(%f***)</span>');
$num_concat_share[$num][$k2][0] += $n1;
$num_concat_share[$num][$k2][1] += $n2;
$data[$num][$k2] = $num_concat_share[$num][$k2][0]." (".$num_concat_share[$num][$k2][1]."%)";
} elseif (strpos($k2,'_fact')!==false) {
$a = str_replace("%", "***", $v2);
list($n1, $n2) = sscanf($a, '%f <span style="font-size: 85***">(%f)</span>');
$num_concat_share[$num][$k2][0] += $n1;
$num_concat_share[$num][$k2][1] += $n2;
$data[$num][$k2] = $num_concat_share[$num][$k2][0]." (".$num_concat_share[$num][$k2][1].")";
} else $data[$num][$k2] += $v2;
}
}
foreach ($num_concat_slash[$num] as $key=>$val) {
foreach ($val as $k=>$v) {
$data[$num][$key] .= $v.($k<count($val)-1 ? '/':'');
}
}
$data[$num]['campaign'] = $this->str('total');
$data[$num]['start_date'] = "";
$data[$num]['end_date'] = "";
foreach ($data[$num] as $k2=>$v2)
$data[$num][$k2] = '<span style="font-size: 85%; font-weight: bold;">'.$data[$num][$k2].'</span>';
}
*/
$keys = end($data);
foreach ($keys as $k => $v) {
$temp = explode('_', $k);
if ($temp[0] == 'event' && $temp[2] == 'share') {
$keys[$k] = $this->events[$temp[1]]['name'] . (lang() == 'ru' ? ": кол-во <span style=\"font-size: 85%\">(доля от общего)</span>" : ": quantity (share)");
} else {
if ($temp[0] == 'event' && $temp[2] == 'slash') {
$keys[$k] = $this->events[$temp[1]]['name'] . (lang() == 'ru' ? " (кол-во / % от кликов / % от показов)" : " (quantity / % from click / % from displays)");
} else {
if ($temp[0] == 'event' && $temp[2] == 'cost') {
$keys[$k] = (lang() == 'ru' ? "Стоимость \"" : "Cost \"") . $this->events[$temp[1]]['name'] . "\"";
} else {
$keys[$k] = $this->str($k);
}
}
}
}
array_unshift($data, $keys);
$i = 0;
foreach ($keys as $key => $val) {
foreach ($data as $k => $v) {
$data1[$i][$k] = $v[$key];
}
$i++;
}
/* $total_head = array(
'',
$this->_str('visitors'),
);
$total[] = array(
$this->str('total_period'),
(int)sql_getValue("SELECT COUNT(*) FROM ".$tmp_table),
);*/
// Main Table
foreach ($data as $k => $v) {
$id = sql_getValue("SELECT id FROM stat_reklama WHERE name='" . $v['campaign'] . "' LIMIT 1");
if ($id) {
$row = sql_getValue("SELECT identifiers FROM stat_reklama WHERE id=" . $id);
$identifiers = explode(',', $row);
foreach ($identifiers as $key => $val) {
$identifiers[$key] = trim($val);
}
if (!empty($identifiers)) {
$str = '<a href="#" onclick="window.open(\'stat.php?page=stat/stat_summary&adv[reklama]=' . implode(', ', $identifiers) . '\', \'stat\', \'width=900, height=600, resizable=1, status=1\').focus(); return false;"><img src="images/icons/icon.plus.gif" width=16 heidht=16 border=0 alt="' . $this->str('more') . '" align="absmiddle" hspace="3"></a> ' . $v['campaign'];
} else {
$str = $v['campaign'];
}
} else {
$str = $v['campaign'];
}
$columns[$k] = array('header' => $str, 'nowrap' => 1);
}
unset($data1[0]);
// Убираем первую строку с названиями кампаний (т.к. она есть в шапке таблицы)
$ret['table'] = $this->stat_table(array('columns' => $columns, 'data' => $data1, 'count' => $count, 'offset' => $offset, 'limit' => $limit));
return $ret;
}
}
//
//==========================================================
//
// Display Search Results
//
//==========================================================
$con = getDbConnection();
if ($con) {
$search = isset($_GET['q']) ? $_GET['q'] : '';
if (isset($_POST['submit'])) {
$aParams = getParams($_POST['search']);
} else {
$aParams = getParams($search);
}
$sql = getSql($aParams);
$result = getResult($con, $sql);
if ($result) {
echo '<b class="ooo">Total Results: ' . $result->num_rows . '</b>';
if (12 <= $result->num_rows) {
$sql .= " LIMIT 0,12";
$result = mysqli_query($con, $sql);
echo ' <i>(but only showing the first <b style="color:blue;">dozen </b> </i>)';
}
echo '<hr />';
echo '<dl class="dx w88 mga">';
while ($row = mysqli_fetch_array($result)) {
// SORRY - only for my table of jokes
if (isset($row['xrl'])) {
$link = '<a href="http://www.johns-jokes.com/' . $row['xrl'] . '">' . $row['title'] . '</a>';
echo "<dt>" . $link . "</dt>";
/**
* [getSqlLastday]
* @return [type] [description]
*/
function getSqlLastday()
{
//TODO 小心月份的最后一天（暂时不用担心）
$lastDay = date('Ymd', strtotime('yesterday'));
return getSql($lastDay, intval($lastDay) + 1);
}
