protected function loadValue()
{
$v9b207167e5381c47682c6b4f58a623fb = array();
$v3aabf39f2d943fa886d86dcbbee4d910 = $this->field_id;
if ($v8d777f385d3dfec8815d20f7496026dc = $this->getPropData()) {
foreach ($v8d777f385d3dfec8815d20f7496026dc['text_val'] as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
if (is_null($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) {
continue;
}
if (str_replace(" ", "", trim($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) == "") {
continue;
}
$v9b207167e5381c47682c6b4f58a623fb[] = self::filterOutputString((string) $v3a6d0284e743dc4a9b86f97d6dd1a3bf);
}
return $v9b207167e5381c47682c6b4f58a623fb;
}
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT text_val FROM {$this->tableName} WHERE obj_id = '{$this->object_id}' AND field_id = '{$v3aabf39f2d943fa886d86dcbbee4d910}' LIMIT 1";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a, true);
while (list($v3a6d0284e743dc4a9b86f97d6dd1a3bf) = mysql_fetch_row($result)) {
if (is_null($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) {
continue;
}
if (str_replace(" ", "", trim($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) == "") {
continue;
}
$v9b207167e5381c47682c6b4f58a623fb[] = self::filterOutputString((string) $v3a6d0284e743dc4a9b86f97d6dd1a3bf);
}
return $v9b207167e5381c47682c6b4f58a623fb;
}
protected function save()
{
$v67b3dba8bc6778101892eb77249db32e = self::filterInputString($this->host);
$vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_domain_mirrows SET host = '{$v67b3dba8bc6778101892eb77249db32e}' WHERE id = '{$this->id}'";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
return true;
}
/**
* Метод получения отчёта
*
* @return array
*/
public function get()
{
$sHostSQL = $this->getHostSQL("p");
l_mysql_query("SET @all = (SELECT COUNT(*) AS `cnt` FROM `cms_stat_paths` `p`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $sHostSQL . ")");
$result['detail'] = $this->simpleQuery("(SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'sites' AS `type`, `d`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_sites` `ss` ON `s`.`concrete_src_id` = `ss`.`id`\r\n INNER JOIN `cms_stat_sources_sites_domains` `d` ON `d`.`id` = `ss`.`domain`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQLd . " AND `s`.`src_type` = 1\r\n GROUP BY `d`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'search' AS `type`, `sse`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_search` `ss` ON `ss`.`id` = `s`.`concrete_src_id`\r\n INNER JOIN `cms_stat_sources_search_engines` `sse` ON `sse`.`id` = `ss`.`engine_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 2\r\n GROUP BY `sse`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'pr' AS `type`, `pr`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_pr` `pr` ON `pr`.`id` = `s`.`concrete_src_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 3\r\n GROUP BY `pr`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'ticket' AS `type`, `t`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_ticket` `t` ON `t`.`id` = `s`.`concrete_src_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 4\r\n GROUP BY `t`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'coupon' AS `type`, `c`.`descript` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_coupon` `c` ON `c`.`id` = `s`.`concrete_src_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 5\r\n GROUP BY `c`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'direct' AS `type`, 'direct' AS `name` FROM `cms_stat_paths` `p`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `p`.`source_id` = 0)\r\n\r\n ORDER BY `cnt` DESC\r\n LIMIT " . $this->offset . ", " . $this->limit);
$result['segments'] = $this->simpleQuery("SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `cnt`, `type` FROM (\r\n (SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'sites' AS `type`, `d`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_sites` `ss` ON `s`.`concrete_src_id` = `ss`.`id`\r\n INNER JOIN `cms_stat_sources_sites_domains` `d` ON `d`.`id` = `ss`.`domain`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 1\r\n GROUP BY `d`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'search' AS `type`, `sse`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_search` `ss` ON `ss`.`id` = `s`.`concrete_src_id`\r\n INNER JOIN `cms_stat_sources_search_engines` `sse` ON `sse`.`id` = `ss`.`engine_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 2\r\n GROUP BY `sse`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'pr' AS `type`, `pr`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_pr` `pr` ON `pr`.`id` = `s`.`concrete_src_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 3\r\n GROUP BY `pr`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'ticket' AS `type`, `t`.`name` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_ticket` `t` ON `t`.`id` = `s`.`concrete_src_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 4\r\n GROUP BY `t`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'coupon' AS `type`, `c`.`descript` AS `name` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`\r\n INNER JOIN `cms_stat_sources_coupon` `c` ON `c`.`id` = `s`.`concrete_src_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `s`.`src_type` = 5\r\n GROUP BY `c`.`id`)\r\n\r\n UNION\r\n (\r\n SELECT COUNT(*) AS `cnt`, COUNT(*) / @all * 100 AS `abs`, 'direct' AS `type`, 'direct' AS `name` FROM `cms_stat_paths` `p`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . $this->getUserFilterWhere('p') . " " . $sHostSQL . " AND `p`.`source_id` = 0)\r\n ) `tmp`\r\n GROUP BY `tmp`.`type`\r\n ORDER BY `cnt` DESC\r\n LIMIT " . $this->offset . ", " . $this->limit);
/*
l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_pages_refuse`");
l_mysql_query("CREATE TEMPORARY TABLE `tmp_pages_refuse` (`path_id` INT, `level` INT, KEY `path_id_level` (`path_id`, `level`)) ENGINE = MEMORY");
l_mysql_query("INSERT INTO `tmp_pages_refuse` SELECT `path_id`, MAX(`number_in_path`) AS `mnum` FROM `cms_stat_hits` `h`
INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`
WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " AND `p`.`host_id` = " . $this->host_id . "
GROUP BY `path_id`
HAVING `mnum` = 1");
l_mysql_query("SET @all_refuses = (SELECT COUNT(*) FROM tmp_pages_refuse)");
l_mysql_query("SET @all_visits = (SELECT COUNT(*) FROM `cms_stat_paths` `p`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " AND `p`.`host_id` = " . $this->host_id . " )");
return $this->simpleQuery("SELECT COUNT(DISTINCT(`h`.`path_id`)) AS `refuse`, COUNT(*) AS `entry`, COUNT(DISTINCT(`h`.`path_id`)) / COUNT(*) * 100 AS `refuse_percent`, COUNT(DISTINCT(`h`.`path_id`)) / @all_refuses * 100 AS `all_refuses_percent`, COUNT(DISTINCT(`h`.`path_id`)) / @all_visits * 100 AS `traffic_lost`, `p`.`uri`, `p`.`id` FROM `tmp_pages_refuse` `t`
INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `t`.`path_id` AND `h`.`number_in_path` = `t`.`level`
INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h`.`page_id`
INNER JOIN `cms_stat_hits` `h2` ON `h2`.`page_id` = `p`.`id` AND `h2`.`number_in_path` = 1
WHERE `p`.`host_id` = " . $this->host_id . "
GROUP BY `h`.`page_id`
LIMIT 10");
*/
return $result;
}
protected function saveValue()
{
$this->deleteCurrentRows();
if (sizeof($this->value) == 1) {
$v2063c1608d6e0baf80249c42e2be5804 = trim($this->value[0], ",");
$v2063c1608d6e0baf80249c42e2be5804 = preg_replace("/[^A-Za-z0-9А-Яа-яЁё'\\-\$%_,\\s]/u", "", $v2063c1608d6e0baf80249c42e2be5804);
$v2063c1608d6e0baf80249c42e2be5804 = explode(",", $v2063c1608d6e0baf80249c42e2be5804);
} else {
$v2063c1608d6e0baf80249c42e2be5804 = array_map(create_function('$a', " return preg_replace(\"/[^A-Za-z0-9А-Яа-яЁё'\\-\\\$%_,\\s]?/u\", \"\", \$a); "), $this->value);
}
$v2817f701d5e1a1181e657251363295fd = 0;
foreach ($v2063c1608d6e0baf80249c42e2be5804 as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = trim($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
if (strlen($v3a6d0284e743dc4a9b86f97d6dd1a3bf) == 0) {
continue;
}
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = self::filterInputString($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO {$this->tableName} (obj_id, field_id, varchar_val) VALUES('{$this->object_id}', '{$this->field_id}', '{$v3a6d0284e743dc4a9b86f97d6dd1a3bf}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
++$v2817f701d5e1a1181e657251363295fd;
}
if (!$v2817f701d5e1a1181e657251363295fd) {
$this->fillNull();
}
}
private function getDetail()
{
l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_visit_time`");
l_mysql_query("CREATE TEMPORARY TABLE `tmp_visit_time` (`mins` FLOAT) ENGINE = MEMORY");
l_mysql_query("INSERT INTO `tmp_visit_time` SELECT (UNIX_TIMESTAMP(MAX(`h`.`date`)) - UNIX_TIMESTAMP(MIN(`h`.`date`))) / 60 AS `minutes` FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . " \r\n GROUP BY `h`.`path_id`");
return $this->simpleQuery("SELECT COUNT(*) AS `cnt`, IF(`mins` > 10, IF(`mins` > 20, IF(`mins` > 30, IF(`mins` > 40, IF(`mins` > 50, 51, 41), 31), 21), 11), ROUND(`mins`)) `minutes`\r\n FROM `tmp_visit_time`\r\n GROUP BY `minutes` ORDER BY `cnt` DESC");
}
public function addField($vb068931cc450442b63f5b3d276ea4297, $vd5d3db1765287eef77d7927cc956f50a, $v1e3f04102267eaf5e8d0ca424fd5c561, $ve1c6c9ef2fcbe75f26f815c4ef2e60b4 = true, $v1945c9a2a5e2ba6133f1db6757a35fcb = false, $vd5752333adc3a004f826f2ea2a41273a = false)
{
$this->disableCache();
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO cms3_object_fields VALUES()";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
return false;
}
$v3aabf39f2d943fa886d86dcbbee4d910 = l_mysql_insert_id();
$v06e3d36fa30cea095545139854ad1fb9 = new umiField($v3aabf39f2d943fa886d86dcbbee4d910);
$v06e3d36fa30cea095545139854ad1fb9->setName($vb068931cc450442b63f5b3d276ea4297);
$v06e3d36fa30cea095545139854ad1fb9->setTitle($vd5d3db1765287eef77d7927cc956f50a);
if (!$v06e3d36fa30cea095545139854ad1fb9->setFieldTypeId($v1e3f04102267eaf5e8d0ca424fd5c561)) {
return false;
}
$v06e3d36fa30cea095545139854ad1fb9->setIsVisible($ve1c6c9ef2fcbe75f26f815c4ef2e60b4);
$v06e3d36fa30cea095545139854ad1fb9->setIsLocked($v1945c9a2a5e2ba6133f1db6757a35fcb);
$v06e3d36fa30cea095545139854ad1fb9->setIsInheritable($vd5752333adc3a004f826f2ea2a41273a);
if (!$v06e3d36fa30cea095545139854ad1fb9->commit()) {
return false;
}
$this->fields[$v3aabf39f2d943fa886d86dcbbee4d910] = $v06e3d36fa30cea095545139854ad1fb9;
return $v3aabf39f2d943fa886d86dcbbee4d910;
}
protected function saveValue()
{
$this->deleteCurrentRows();
if (is_null($this->value)) {
return;
}
$v2817f701d5e1a1181e657251363295fd = 0;
foreach ($this->value as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
if (!$v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
continue;
}
if (is_object($v3a6d0284e743dc4a9b86f97d6dd1a3bf)) {
if (!@is_file($v3a6d0284e743dc4a9b86f97d6dd1a3bf->getFilePath())) {
continue;
}
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = l_mysql_real_escape_string($v3a6d0284e743dc4a9b86f97d6dd1a3bf->getFilePath());
} else {
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = l_mysql_real_escape_string($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
}
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = self::unescapeFilePath($v3a6d0284e743dc4a9b86f97d6dd1a3bf);
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO {$this->tableName} (obj_id, field_id, text_val) VALUES('{$this->object_id}', '{$this->field_id}', '{$v3a6d0284e743dc4a9b86f97d6dd1a3bf}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
++$v2817f701d5e1a1181e657251363295fd;
}
if (!$v2817f701d5e1a1181e657251363295fd) {
$this->fillNull();
}
}
public function get()
{
$sQr = "SET @cnt := (SELECT COUNT(*) FROM `cms_stat_sources_openstat` `os`
INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . ")";
l_mysql_query($sQr);
$result = $this->simpleQuery("SELECT COUNT(*) AS `total` FROM `cms_stat_sources_openstat` `os`
INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
INNER JOIN `cms_stat_sources_openstat_source` `s` ON `s`.`id` = `os`.`source_id`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p'));
$i_total = (int) $result[0]['total'];
$sQr = "SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @cnt * 100 AS `rel`, `s`.`name` AS 'name', `s`.`id` AS `source_id` FROM `cms_stat_sources_openstat` `os`
INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
INNER JOIN `cms_stat_sources_openstat_source` `s` ON `s`.`id` = `os`.`source_id`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "
GROUP BY `s`.`id`
ORDER BY `abs` DESC
LIMIT " . $this->offset . ", " . $this->limit;
$res = $this->simpleQuery($sQr, true);
return array("all"=>$res['result'], "summ"=>$i_total, "total"=>$res['FOUND_ROWS']);
}
private function getDetail()
{
l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_users_loyality`");
l_mysql_query("CREATE TEMPORARY TABLE `tmp_users_loyality` (`count` INT) ENGINE = MEMORY");
l_mysql_query("INSERT INTO `tmp_users_loyality` SELECT COUNT(*) AS `cnt` FROM `cms_stat_paths` `p`\r\n INNER JOIN `cms_stat_users` `u` ON `u`.`id` = `p`.`user_id` AND `u`.`first_visit` < `p`.`date`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "\r\n GROUP BY `p`.`user_id`");
return $this->simpleQuery("SELECT COUNT(*) AS `cnt`, IF(`count` > 10, IF(`count` > 20, IF(`count` > 30, IF(`count` > 40, IF(`count` > 50, 51, 41), 31), 21), 11), `count`) AS `visits_count` FROM `tmp_users_loyality`\r\n GROUP BY `visits_count`");
}
private function loadTypes()
{
$vb99eb979e6f6efabc396f777b503f7e7 = cacheFrontend::getInstance();
$vda80b9ab86c2d00b85de0cf003cb3e6e = $vb99eb979e6f6efabc396f777b503f7e7->loadData('hierarchy_types');
if (!is_array($vda80b9ab86c2d00b85de0cf003cb3e6e)) {
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT `id`, `name`, `title`, `ext` FROM `cms3_hierarchy_types` ORDER BY `name`, `ext`";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
$vda80b9ab86c2d00b85de0cf003cb3e6e = array();
while (list($vb80bb7740288fda1f201890375a60c8f) = $vf1965a857bc285d26fe22023aa5ab50d = mysql_fetch_row($result)) {
$vda80b9ab86c2d00b85de0cf003cb3e6e[$vb80bb7740288fda1f201890375a60c8f] = $vf1965a857bc285d26fe22023aa5ab50d;
}
$vb99eb979e6f6efabc396f777b503f7e7->saveData('hierarchy_types', $vda80b9ab86c2d00b85de0cf003cb3e6e, 3600);
}
foreach ($vda80b9ab86c2d00b85de0cf003cb3e6e as $vb80bb7740288fda1f201890375a60c8f => $vf1965a857bc285d26fe22023aa5ab50d) {
$v599dcce2998a6b40b1e38e8c6006cb0a = $vb99eb979e6f6efabc396f777b503f7e7->load($vb80bb7740288fda1f201890375a60c8f, 'element_type');
if ($v599dcce2998a6b40b1e38e8c6006cb0a instanceof iUmiHierarchyType == false) {
try {
$v599dcce2998a6b40b1e38e8c6006cb0a = new umiHierarchyType($vb80bb7740288fda1f201890375a60c8f, $vf1965a857bc285d26fe22023aa5ab50d);
} catch (privateException $ve1671797c52e15f763380b45e841ec32) {
continue;
}
$vb99eb979e6f6efabc396f777b503f7e7->save($v599dcce2998a6b40b1e38e8c6006cb0a, 'element_type');
}
$this->types[$vb80bb7740288fda1f201890375a60c8f] = $v599dcce2998a6b40b1e38e8c6006cb0a;
}
return true;
}
public function getPath()
{
$path = explode('/', $this->params['path']);
$str = '';
foreach ($path as $val) {
$str .= (int)$val . ', ';
}
$str = substr($str, 0, -2);
$qry = "SELECT `id`, `uri` FROM `cms_stat_pages` WHERE `id` IN (" . $str . ")";
$res = l_mysql_query($qry);
$result = array();
while ($row = mysql_fetch_assoc($res)) {
$result[$row['id']] = $row['uri'];
}
reset($path);
$return = array();
foreach ($path as $val) {
if (isset($result[$val])) {
$return[] = $result[$val];
}
}
return $return;
}
public function getDynamic()
{
l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_activity`");
l_mysql_query("CREATE TEMPORARY TABLE `tmp_activity` (`days` INT, `" . $this->groupby . "` INT, `year` INT, `date` DATETIME) ENGINE = MEMORY");
l_mysql_query("INSERT INTO `tmp_activity` SELECT FLOOR( ( UNIX_TIMESTAMP(MAX(`date`)) - UNIX_TIMESTAMP(MIN(`date`)) ) / (COUNT(*) - 1) / 3600 / 24 ) AS `days`, DATE_FORMAT(`date`, '%" . $this->groupby_key . "') AS `" . $this->groupby . "`, DATE_FORMAT(`date`, '%Y') AS `year`, `date` FROM `cms_stat_paths`\r\n WHERE `date` BETWEEN '" . $this->formatDate($this->start) . "' AND '" . $this->formatDate($this->finish) . "' " . $this->getHostSQL() . $this->getUserFilterWhere() . "\r\n GROUP BY `user_id`");
return $this->simpleQuery("SELECT AVG(`days`) AS `avg`, `" . $this->groupby . "` AS `period`, UNIX_TIMESTAMP(`date`) AS `ts` FROM `tmp_activity`\r\n GROUP BY `" . $this->groupby . "`, `year` ORDER BY `date`");
}
public static function saveBranchedTablesRelations()
{
$v47826cacc65c665212b821e6ff80b9b0 = self::getRelationsFilePath();
$v9b81909fd0da3add2602a8d0ede0e4e7 = umiObjectTypesCollection::getInstance();
self::$branchedObjectTypes = array();
clearstatcache();
if (file_exists($v47826cacc65c665212b821e6ff80b9b0)) {
unlink($v47826cacc65c665212b821e6ff80b9b0);
}
$vac5c74b64b4b8352ef2f181affb5ac2a = "SHOW TABLES LIKE 'cms3_object_content%'";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a, true);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
$v8587774de94e7ee1616350d82cc72317 = array();
while (list($v80071f37861c360a27b7327e132c911a) = mysql_fetch_row($result)) {
if (preg_match("/cms3_object_content_([0-9]+)/", $v80071f37861c360a27b7327e132c911a, $vc68271a63ddbc431c307beb7d2918275)) {
$v8587774de94e7ee1616350d82cc72317[] = (int) $vc68271a63ddbc431c307beb7d2918275[1];
}
}
$vf9ecb86fe4446d46abf44c1f55be3d43 = array();
foreach ($v8587774de94e7ee1616350d82cc72317 as $vacf567c9c3d6cf7c6e2cc0ce108e0631) {
$v0e8133eb006c0f85ed9444ae07a60842 = array_keys($v9b81909fd0da3add2602a8d0ede0e4e7->getTypesByHierarchyTypeId($vacf567c9c3d6cf7c6e2cc0ce108e0631));
if (is_array($v0e8133eb006c0f85ed9444ae07a60842)) {
foreach ($v0e8133eb006c0f85ed9444ae07a60842 as $v6301cee35ea764a1e241978f93f01069) {
$vf9ecb86fe4446d46abf44c1f55be3d43[$v6301cee35ea764a1e241978f93f01069] = $vacf567c9c3d6cf7c6e2cc0ce108e0631;
}
}
}
file_put_contents($v47826cacc65c665212b821e6ff80b9b0, serialize($vf9ecb86fe4446d46abf44c1f55be3d43));
chmod($v47826cacc65c665212b821e6ff80b9b0, 0777);
return self::$branchedObjectTypes = $vf9ecb86fe4446d46abf44c1f55be3d43;
}
public function get()
{
$cond = array();
foreach (array('source_id', 'campaign_id') as $val) {
if ((int)$this->params[$val] > 0) {
$cond[] = '`os`.`' . $val . '` = ' . (int)$this->params[$val];
}
}
$cond_str = '';
if (sizeof($cond)) {
$cond_str = ' AND ' . implode(' AND ', $cond);
}
l_mysql_query("SET @cnt := (SELECT COUNT(*) FROM `cms_stat_sources_openstat` `os`
INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . $cond_str . ")");
$result = $this->simpleQuery("SELECT COUNT(*) AS `abs` FROM `cms_stat_sources_openstat` `os`
INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
INNER JOIN `cms_stat_sources_openstat_service` `s` ON `s`.`id` = `os`.`service_id`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . $cond_str);
$i_total = (isset($result[0]['total'])) ? (int) $result[0]['total'] : 0;
$res = $this->simpleQuery("SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @cnt * 100 AS `rel`, `s`.`name`, `s`.`id` AS 'service_id' FROM `cms_stat_sources_openstat` `os`
INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`
INNER JOIN `cms_stat_sources_openstat_service` `s` ON `s`.`id` = `os`.`service_id`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . $cond_str . "
GROUP BY `s`.`id`
ORDER BY `abs` DESC
LIMIT " . $this->offset . ", " . $this->limit, true);
return array("all"=>$res['result'], "summ"=>$i_total, "total"=>$res['FOUND_ROWS']);
}
/**
* метод получения почасовой информации за выходные и будни
*
* @return array
*/
private function getAvg()
{
$this->setUpVars();
$qry = "(SELECT 'routine' AS `type`, COUNT(*) / " . $this->routine_count . ".0 AS `avg`, `h`.`hour` FROM `cms_stat_paths` `p`
INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id` AND `h`.`number_in_path` = 1
INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`
INNER JOIN `cms_stat_sources_sites` `ss` ON `ss`.`id` = `s`.`concrete_src_id`
LEFT JOIN `cms_stat_holidays` `holidays` ON `h`.`day` = `holidays`.`day` AND `h`.`month` = `holidays`.`month`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . " AND `s`.`src_type` = 1
AND `day_of_week` BETWEEN 1 AND 5 AND `holidays`.`id` IS NULL
GROUP BY `h`.`hour`)
UNION
(SELECT 'weekend' AS `type`, COUNT(*) / " . $this->holidays_count . ".0 AS `avg`, `h`.`hour` FROM `cms_stat_paths` `p`
INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id` AND `h`.`number_in_path` = 1
INNER JOIN `cms_stat_sources` `s` ON `s`.`id` = `p`.`source_id`
INNER JOIN `cms_stat_sources_sites` `ss` ON `ss`.`id` = `s`.`concrete_src_id`
LEFT JOIN `cms_stat_holidays` `holidays` ON `h`.`day` = `holidays`.`day` AND `h`.`month` = `holidays`.`month`
WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . " AND `s`.`src_type` = 1
AND (`day_of_week` NOT BETWEEN 1 AND 5 OR `holidays`.`id` IS NOT NULL)
GROUP BY `h`.`hour`)";
$res = l_mysql_query($qry);
$result = array();
while ($row = mysql_fetch_assoc($res)) {
$result[$row['type']][$row['hour']] = $row['avg'];
}
return $result;
}
protected function saveValue()
{
$this->deleteCurrentRows();
$v2817f701d5e1a1181e657251363295fd = 0;
foreach ($this->value as $v3a6d0284e743dc4a9b86f97d6dd1a3bf) {
if ($v3a6d0284e743dc4a9b86f97d6dd1a3bf === false || $v3a6d0284e743dc4a9b86f97d6dd1a3bf === "") {
continue;
}
if (strpos(".", $v3a6d0284e743dc4a9b86f97d6dd1a3bf) === false) {
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = str_replace(",", ".", $v3a6d0284e743dc4a9b86f97d6dd1a3bf);
}
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = abs((double) $v3a6d0284e743dc4a9b86f97d6dd1a3bf);
if ($v3a6d0284e743dc4a9b86f97d6dd1a3bf > 999999999.99) {
$v3a6d0284e743dc4a9b86f97d6dd1a3bf = 999999999.99;
}
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO {$this->tableName} (obj_id, field_id, float_val) VALUES('{$this->object_id}', '{$this->field_id}', '{$v3a6d0284e743dc4a9b86f97d6dd1a3bf}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
if ($v56bd7107802ebe56c6918992f0608ec6 = l_mysql_error()) {
throw new coreException($v56bd7107802ebe56c6918992f0608ec6);
}
++$v2817f701d5e1a1181e657251363295fd;
}
$this->dbValue = $this->value;
if (!$v2817f701d5e1a1181e657251363295fd) {
$this->fillNull();
}
}
/**
* Метод получения отчёта
*
* @return array
*/
public function get()
{
l_mysql_query("SET @all = (SELECT COUNT(*) FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " AND `number_in_path` = 1 " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . ")");
$resSumm = $this->simpleQuery("SELECT COUNT(*) AS 'cnt' FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h`.`page_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " AND `h`.`number_in_path` = 1 " . $this->getHostSQL("p"));
$i_summ = (int) $resSumm[0]['cnt'];
$res = $this->simpleQuery($qry = "SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @all * 100 AS `rel`, `p`.`uri`, `p`.`id`, UNIX_TIMESTAMP(`h`.`date`) AS `ts` FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h`.`page_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " AND `h`.`number_in_path` = 1 " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "\r\n GROUP BY `h`.`page_id`\r\n ORDER BY `abs` DESC\r\n LIMIT " . $this->offset . ", " . $this->limit, true);
return array("all" => $res['result'], "summ" => $i_summ, "total" => $res['FOUND_ROWS']);
}
public function get()
{
l_mysql_query("SET @cnt := (SELECT COUNT(*) FROM `cms_stat_sources_openstat` `os`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . ((int) $this->params['source_id'] > 0 ? ' AND `os`.`source_id` = ' . (int) $this->params['source_id'] : '') . ")");
$result = $this->simpleQuery("SELECT COUNT(*) AS `total` FROM `cms_stat_sources_openstat` `os`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`\r\n INNER JOIN `cms_stat_sources_openstat_campaign` `c` ON `c`.`id` = `os`.`campaign_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . ((int) $this->params['source_id'] > 0 ? ' AND `os`.`source_id` = ' . (int) $this->params['source_id'] : ''));
$i_total = (int) $result[0]['total'];
$res = $this->simpleQuery("SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @cnt * 100 AS `rel`, `c`.`name`, `c`.`id` as 'campaign_id' FROM `cms_stat_sources_openstat` `os`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `os`.`path_id`\r\n INNER JOIN `cms_stat_sources_openstat_campaign` `c` ON `c`.`id` = `os`.`campaign_id`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . ((int) $this->params['source_id'] > 0 ? ' AND `os`.`source_id` = ' . (int) $this->params['source_id'] : '') . "\r\n GROUP BY `c`.`id`\r\n ORDER BY `abs` DESC\r\n LIMIT " . $this->offset . ", " . $this->limit, true);
return array("all" => $res['result'], "summ" => $i_total, "total" => $res['FOUND_ROWS'], 'source_id' => isset($this->params['source_id']) ? intval($this->params['source_id']) : 0);
}
/**
* Метод получения отчёта
*
* @return array
*/
public function get()
{
l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_pages_refuse`");
l_mysql_query("CREATE TEMPORARY TABLE `tmp_pages_refuse` (`path_id` INT, `level` INT, KEY `path_id_level` (`path_id`, `level`)) ENGINE = MEMORY");
l_mysql_query("INSERT INTO `tmp_pages_refuse` SELECT `path_id`, MAX(`number_in_path`) AS `mnum` FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "\r\n GROUP BY `path_id`\r\n HAVING `mnum` = 1");
l_mysql_query("SET @all_refuses = (SELECT COUNT(*) FROM tmp_pages_refuse)");
l_mysql_query("SET @all_visits = (SELECT COUNT(*) FROM `cms_stat_paths` `p`\r\n WHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . " )");
return $this->simpleQuery("SELECT COUNT(DISTINCT(`h`.`path_id`)) AS `refuse`, COUNT(*) / COUNT(DISTINCT(`h`.`path_id`)) AS `entry`, COUNT(DISTINCT(`h`.`path_id`)) / COUNT(*) * 100 AS `refuse_percent`, COUNT(DISTINCT(`h`.`path_id`)) / @all_refuses * 100 AS `all_refuses_percent`, COUNT(DISTINCT(`h`.`path_id`)) / @all_visits * 100 AS `traffic_lost`, `p`.`uri`, `p`.`id` FROM `tmp_pages_refuse` `t`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `t`.`path_id` AND `h`.`number_in_path` = `t`.`level`\r\n INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h`.`page_id`\r\n INNER JOIN `cms_stat_hits` `h2` ON `h2`.`page_id` = `p`.`id` AND `h2`.`number_in_path` = 1\r\n WHERE " . $this->getHostSQL("p") . "\r\n GROUP BY `h`.`page_id`\r\n ORDER BY `refuse` DESC\r\n LIMIT " . $this->offset . ", " . $this->limit);
}
protected function save()
{
$vb068931cc450442b63f5b3d276ea4297 = self::filterInputString($this->name);
$vd5d3db1765287eef77d7927cc956f50a = self::filterInputString($this->title);
$vabf77184f55403d75b9d51d79162a7ca = self::filterInputString($this->ext);
$vac5c74b64b4b8352ef2f181affb5ac2a = "UPDATE cms3_hierarchy_types SET name = '{$vb068931cc450442b63f5b3d276ea4297}', title = '{$vd5d3db1765287eef77d7927cc956f50a}', ext = '{$vabf77184f55403d75b9d51d79162a7ca}' WHERE id = '{$this->id}'";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
return true;
}
public function getIncluded($section)
{
l_mysql_query("SET @all = (SELECT COUNT(*) FROM `cms_stat_pages` `p`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`page_id` = `p`.`id`\r\n WHERE `p`.`section` = '" . mysql_real_escape_string($section) . "' AND `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . ")");
$result = $this->simpleQuery("SELECT COUNT(*) AS `summ` FROM `cms_stat_pages` `p`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`page_id` = `p`.`id`\r\n WHERE `p`.`section` = '" . mysql_real_escape_string($section) . "' AND `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p"));
$i_summ = (int) $result[0]['summ'];
$arrQr = $this->simpleQuery("SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @all * 100 AS `rel`, `p`.`uri`, `p`.`section`, UNIX_TIMESTAMP(`h`.`date`) AS `ts` FROM `cms_stat_pages` `p`\r\n INNER JOIN `cms_stat_hits` `h` ON `h`.`page_id` = `p`.`id`\r\n WHERE `p`.`section` = '" . mysql_real_escape_string($section) . "' AND `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . "\r\n GROUP BY `p`.`id`\r\n ORDER BY `abs` DESC\r\n LIMIT " . $this->offset . ", " . $this->limit, true);
$arrToReturn = array("all" => $arrQr['result'], "summ" => $i_summ, "total" => $arrQr['FOUND_ROWS']);
return $arrToReturn;
}
public function get()
{
$result = array();
$sQuery = "SELECT COUNT(*) AS `count`, `location` \r\n\t\t FROM `cms_stat_users` \r\n\t\t\t\t WHERE 1 " . $this->getHostSQL() . (!empty($this->user_id) ? ' AND id IN ' . implode(', ', $this->user_id) : '') . " \r\n\t\t\t\t GROUP BY `location` \r\n\t\t\t\t ORDER BY `count` DESC LIMIT 15";
$rQueryResult = l_mysql_query($sQuery);
while ($aRow = mysql_fetch_assoc($rQueryResult)) {
$result[] = $aRow;
}
return $result;
}
public function json_delete_field()
{
$field_id = (int) getRequest('param0');
$type_id = (int) getRequest('param1');
$sql = "SELECT fc.group_id FROM cms3_object_field_groups ofg, cms3_fields_controller fc WHERE ofg.type_id = '{$type_id}' AND fc.group_id = ofg.id AND fc.field_id = '{$field_id}'";
$result = l_mysql_query($sql);
list($group_id) = mysql_fetch_row($result);
umiObjectTypesCollection::getInstance()->getType($type_id)->getFieldsGroup($group_id)->detachField($field_id);
$this->flush();
}
/**
* Метод получения отчёта
*
* @return array
*/
public function get()
{
if (!$this->params['page_uri']) {
$page_id = $this->params['page_id'];
} else {
$sql = "SELECT id FROM cms_stat_pages WHERE uri = '" . mysql_real_escape_string($this->params['page_uri']) . "' " . $this->getHostSQL("") . " LIMIT 1";
list($page_id) = mysql_fetch_row(l_mysql_query($sql));
}
return $this->simpleQuery("SELECT COUNT(*) AS `abs`, `p`.`uri`, `p`.`id` FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_hits` `h2` ON `h2`.`prev_page_id` = `h`.`page_id` AND `h2`.`number_in_path` = `h`.`number_in_path` + 1 AND `h2`.`path_id` = `h`.`path_id`\r\n INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h2`.`page_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " AND `h`.`page_id` = " . (int) $page_id . " " . $this->getHostSQL("p") . "\r\n GROUP BY `h2`.`page_id`\r\n ORDER BY `abs` DESC");
}
public function get()
{
$result = array();
$sQuery = "SELECT COUNT(*) AS `count` , `page`.`uri`, `page`.`section` \r\n\t\t\t\t FROM `cms_stat_pages` AS `page`, `cms_stat_hits` AS `hit`, \r\n\t\t\t\t `cms_stat_paths` AS `path`, `cms_stat_sources` AS `source` \r\n\t\t\t\t WHERE `source`.`concrete_src_id`=" . $this->params['source_id'] . "\r\n\t\t\t\t\t AND `source`.`src_type` = 1\r\n\t\t\t\t\t AND `path`.`source_id` = `source`.`id`\r\n\t\t\t\t\t AND `hit`.`path_id`=`path`.`id` \r\n\t\t\t\t\t AND `hit`.`number_in_path`=1\r\n\t\t\t\t\t AND `page`.`id`=`hit`.`page_id`\r\n\t\t\t\t\t AND `hit`.`date` BETWEEN " . $this->getQueryInterval() . " \r\n\t\t\t\t\t " . $this->getHostSQL('page') . $this->getUserFilterWhere('path') . " \r\n\t\t\t\t GROUP BY `page`.`id`";
$rQueryResult = l_mysql_query($sQuery);
while ($aRow = mysql_fetch_array($rQueryResult)) {
$result[] = $aRow;
}
return $result;
}
/**
* Метод получения отчёта
*
* @return array
*/
public function get()
{
$this->groupby = $this->calcGroupby($this->start, $this->finish);
$qry = "SELECT COUNT(DISTINCT(`p`.`user_id`)) AS `cnt`, UNIX_TIMESTAMP(`h`.`date`) AS `ts`, `h`.`date`, `h`.`" . $this->groupby . "` AS `period` FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_pages` `pg` ON `pg`.`id` = `h`.`page_id`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "\r\n GROUP BY `h`.`" . $this->groupby . "`\r\n ORDER BY `h`.`date` ASC";
$res = l_mysql_query($qry);
$result = array();
while ($row = mysql_fetch_assoc($res)) {
$result[] = array('ts' => $row['ts'], 'cnt' => $row['cnt'], 'period' => $row['period']);
}
return array('detail' => $result, 'groupby' => $this->groupby);
}
/**
* Метод получения отчёта
*
* @return array
*/
public function get()
{
l_mysql_query("SET @all = (SELECT COUNT(*) FROM `cms_stat_paths`\r\n WHERE `date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL() . ")");
l_mysql_query("DROP TEMPORARY TABLE IF EXISTS `tmp_paths_out`");
l_mysql_query("CREATE TEMPORARY TABLE `tmp_paths_out` (`level`INT, `path_id` INT, KEY `path_id_level` (`path_id`, `level`)) ENGINE = MEMORY");
l_mysql_query("INSERT INTO `tmp_paths_out` (SELECT MAX(`number_in_path`) AS `level`, `path_id` FROM `cms_stat_hits` `h`\r\n INNER JOIN `cms_stat_paths` `p` ON `p`.`id` = `h`.`path_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "\r\n GROUP BY `path_id`)");
$resSumm = $this->simpleQuery("SELECT COUNT(*) AS 'cnt' FROM `cms_stat_hits` `h`\r\n INNER JOIN `tmp_paths_out` `t` ON `h`.`path_id` = `t`.`path_id` AND `h`.`number_in_path` = `t`.`level`\r\n INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h`.`page_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p"));
$i_summ = isset($resSumm[0]) ? (int) $resSumm[0]['cnt'] : 0;
$res = $this->simpleQuery("SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS `abs`, COUNT(*) / @all * 100 AS `rel`, `p`.`uri` FROM `cms_stat_hits` `h`\r\n INNER JOIN `tmp_paths_out` `t` ON `h`.`path_id` = `t`.`path_id` AND `h`.`number_in_path` = `t`.`level`\r\n INNER JOIN `cms_stat_pages` `p` ON `p`.`id` = `h`.`page_id`\r\n WHERE `h`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . "\r\n GROUP BY `h`.`page_id`\r\n ORDER BY `rel` DESC\r\n LIMIT " . $this->offset . ", " . $this->limit, true);
return array("all" => $res['result'], "summ" => $i_summ, "total" => $res['FOUND_ROWS']);
}
/**
* метод получения среднего числа посещений за выходные и будни
*
* @return array
*/
private function getAvg()
{
$this->setUpVars();
$qry = "(SELECT 'routine' AS `type`, COUNT(*) / " . $this->routine_count . ".0 AS `avg` FROM `cms_stat_paths` `p`\r\n\t\t\t\tINNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id` AND `h`.`number_in_path` = 1\r\n\t\t\t\tLEFT JOIN `cms_stat_holidays` `holidays` ON `h`.`day` = `holidays`.`day` AND `h`.`month` = `holidays`.`month`\r\n\t\t\t\tWHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "\r\n\t\t\t\t\tAND `day_of_week` BETWEEN 1 AND 5 AND `holidays`.`id` IS NULL)\r\n\t\t\t\tUNION\r\n\t\t\t\t(SELECT 'weekend' AS `type`, COUNT(*) / " . $this->holidays_count . ".0 AS `avg` FROM `cms_stat_paths` `p`\r\n\t\t\t\tINNER JOIN `cms_stat_hits` `h` ON `h`.`path_id` = `p`.`id` AND `h`.`number_in_path` = 1\r\n\t\t\t\tLEFT JOIN `cms_stat_holidays` `holidays` ON `h`.`day` = `holidays`.`day` AND `h`.`month` = `holidays`.`month`\r\n\t\t\t\tWHERE `p`.`date` BETWEEN " . $this->getQueryInterval() . " " . $this->getHostSQL("p") . $this->getUserFilterWhere('p') . "\r\n\t\t\t\t\tAND (`day_of_week` NOT BETWEEN 1 AND 5 OR `holidays`.`id` IS NOT NULL))";
$res = l_mysql_query($qry);
$result = array();
while ($row = mysql_fetch_assoc($res)) {
$result[$row['type']] = $row['avg'];
}
return $result;
}
protected function fillNull()
{
$v16b2b26000987faccb260b9d39df1269 = (int) $this->object_id;
$v945100186b119048837b9859c2c46410 = (int) $this->field_id;
$vac5c74b64b4b8352ef2f181affb5ac2a = "SELECT COUNT(*) FROM `cms3_object_content_cnt` WHERE `obj_id` = {$v16b2b26000987faccb260b9d39df1269} AND `field_id` = {$v945100186b119048837b9859c2c46410}";
$result = l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
list($ve2942a04780e223b215eb8b663cf5353) = mysql_fetch_row($result);
if ($ve2942a04780e223b215eb8b663cf5353 == 0) {
$vac5c74b64b4b8352ef2f181affb5ac2a = "INSERT INTO `cms3_object_content_cnt` (`obj_id`, `field_id`) VALUES ('{$v16b2b26000987faccb260b9d39df1269}', '{$v945100186b119048837b9859c2c46410}')";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
}
}
public function delLang($v78e6dd7a49f5b0cb2106a3a434dd5c86)
{
$this->disableCache();
cacheFrontend::getInstance()->flush();
$v78e6dd7a49f5b0cb2106a3a434dd5c86 = (int) $v78e6dd7a49f5b0cb2106a3a434dd5c86;
if (!$this->isExists($v78e6dd7a49f5b0cb2106a3a434dd5c86)) {
return false;
}
$vac5c74b64b4b8352ef2f181affb5ac2a = "DELETE FROM cms3_langs WHERE id = '{$v78e6dd7a49f5b0cb2106a3a434dd5c86}'";
l_mysql_query($vac5c74b64b4b8352ef2f181affb5ac2a);
unset($this->langs[$v78e6dd7a49f5b0cb2106a3a434dd5c86]);
}
