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