Exemple #1
0
 function GetDynamicList($arFilter, &$arrLegend, &$is_filtered)
 {
     $err_mess = CAdvBanner::err_mess() . "<br>Function: GetDynamicList<br>Line: ";
     global $DB;
     $arSqlSearch = array();
     if (CAdvBanner::CheckDynamicFilter($arFilter)) {
         if (is_array($arFilter)) {
             $filter_keys = array_keys($arFilter);
             for ($i = 0, $n = count($filter_keys); $i < $n; $i++) {
                 $key = $filter_keys[$i];
                 $val = $arFilter[$filter_keys[$i]];
                 if (is_array($val)) {
                     if (count($val) <= 0) {
                         continue;
                     }
                 } else {
                     if (strlen($val) <= 0 || "{$val}" == "NOT_REF") {
                         continue;
                     }
                 }
                 $key = strtoupper($key);
                 switch ($key) {
                     case "DATE_1":
                         $arSqlSearch[] = "D.DATE_STAT>=" . $DB->CharToDateFunction($val, "SHORT");
                         break;
                     case "DATE_2":
                         $arSqlSearch[] = "D.DATE_STAT<=" . $DB->CharToDateFunction($val . " 23:59:59", "FULL");
                         break;
                 }
             }
         }
     }
     $arContract = is_array($arFilter["CONTRACT_ID"]) ? $arFilter["CONTRACT_ID"] : array();
     $arBanner = is_array($arFilter["BANNER_ID"]) ? $arFilter["BANNER_ID"] : array();
     $arGroup = is_array($arFilter["GROUP_SID"]) ? $arFilter["GROUP_SID"] : array();
     $contract_total = $arFilter["CONTRACT_SUMMA"] == "Y" ? "Y" : "N";
     $banner_total = $arFilter["BANNER_SUMMA"] == "Y" ? "Y" : "N";
     $group_total = $arFilter["GROUP_SUMMA"] == "Y" ? "Y" : "N";
     $arShow = is_array($arFilter["WHAT_SHOW"]) ? $arFilter["WHAT_SHOW"] : array();
     if (in_array("ctr", $arShow)) {
         $arShow[] = "show";
         $arShow[] = "click";
     }
     $arShow = array_unique($arShow);
     $arrDays = array();
     $arrLegend = array();
     $strSqlSearch = GetFilterSqlSearch($arSqlSearch);
     $strSql = CAdvBanner::GetDynamicList_SQL($strSqlSearch);
     $rsD = $DB->Query($strSql, false, $err_mess . __LINE__);
     while ($arD = $rsD->Fetch()) {
         $arrDays[$arD["DATE_STAT"]]["DATE"] = $arD["DATE_STAT"];
         $arrDays[$arD["DATE_STAT"]]["D"] = $arD["DAY"];
         $arrDays[$arD["DATE_STAT"]]["M"] = $arD["MONTH"];
         $arrDays[$arD["DATE_STAT"]]["Y"] = $arD["YEAR"];
         foreach ($arShow as $ctype) {
             if ($ctype == "CTR") {
                 continue;
             }
             $ctype_u = strtoupper($ctype);
             if (intval($arD[$ctype_u . "_COUNT"]) > 0) {
                 if (in_array($arD["CONTRACT_ID"], $arContract)) {
                     if ($contract_total == "N") {
                         $arrLegend["3_CONTRACT_" . $arD["CONTRACT_ID"]]["TYPE"] = "CONTRACT";
                         $arrLegend["3_CONTRACT_" . $arD["CONTRACT_ID"]]["ID"] = $arD["CONTRACT_ID"];
                         $arrLegend["3_CONTRACT_" . $arD["CONTRACT_ID"]]["NAME"] = $arD["CONTRACT_NAME"];
                         $arrLegend["3_CONTRACT_" . $arD["CONTRACT_ID"]]["COUNTER_TYPE"] = "DETAIL";
                         $arrLegend["3_CONTRACT_" . $arD["CONTRACT_ID"]][$ctype_u] += $arD[$ctype_u . "_COUNT"];
                         $arrDays[$arD["DATE_STAT"]]["CONTRACT"]["DETAIL_" . $ctype_u][$arD["CONTRACT_ID"]] += $arD[$ctype_u . "_COUNT"];
                     } elseif ($contract_total == "Y") {
                         $arrLegend["3_CONTRACT"]["TYPE"] = "CONTRACT";
                         $arrLegend["3_CONTRACT"]["COUNTER_TYPE"] = "TOTAL";
                         $arrLegend["3_CONTRACT"][$ctype_u] += $arD[$ctype_u . "_COUNT"];
                         $arrDays[$arD["DATE_STAT"]]["CONTRACT"]["TOTAL_" . $ctype_u] += $arD[$ctype_u . "_COUNT"];
                     }
                 }
                 if (in_array($arD["BANNER_ID"], $arBanner)) {
                     if ($banner_total == "N") {
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]]["TYPE"] = "BANNER";
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]]["ID"] = $arD["BANNER_ID"];
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]]["TYPE_SID"] = $arD["BANNER_TYPE_SID"];
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]]["GROUP"] = $arD["GROUP_SID"];
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]]["NAME"] = $arD["BANNER_NAME"];
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]]["CONTRACT_ID"] = $arD["CONTRACT_ID"];
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]]["COUNTER_TYPE"] = "DETAIL";
                         $arrLegend["1_BANNER_" . $arD["BANNER_ID"]][$ctype_u] += $arD[$ctype_u . "_COUNT"];
                         $arrDays[$arD["DATE_STAT"]]["BANNER"]["DETAIL_" . $ctype_u][$arD["BANNER_ID"]] += $arD[$ctype_u . "_COUNT"];
                     } elseif ($banner_total == "Y") {
                         $arrLegend["1_BANNER"]["TYPE"] = "BANNER";
                         $arrLegend["1_BANNER"]["COUNTER_TYPE"] = "TOTAL";
                         $arrLegend["1_BANNER"][$ctype_u] += $arD[$ctype_u . "_COUNT"];
                         $arrDays[$arD["DATE_STAT"]]["BANNER"]["TOTAL_" . $ctype_u] += $arD[$ctype_u . "_COUNT"];
                     }
                 }
                 if (in_array($arD["GROUP_SID"], $arGroup)) {
                     if ($group_total == "N") {
                         $arrLegend["2_GROUP_" . $arD["GROUP_SID"]]["TYPE"] = "GROUP";
                         $arrLegend["2_GROUP_" . $arD["GROUP_SID"]]["ID"] = $arD["GROUP_SID"];
                         $arrLegend["2_GROUP_" . $arD["GROUP_SID"]]["COUNTER_TYPE"] = "DETAIL";
                         $arrLegend["2_GROUP_" . $arD["GROUP_SID"]][$ctype_u] += $arD[$ctype_u . "_COUNT"];
                         $arrDays[$arD["DATE_STAT"]]["GROUP"]["DETAIL_" . $ctype_u][$arD["GROUP_SID"]] += $arD[$ctype_u . "_COUNT"];
                     } elseif ($group_total == "Y") {
                         $arrLegend["2_GROUP"]["TYPE"] = "GROUP";
                         $arrLegend["2_GROUP"]["COUNTER_TYPE"] = "TOTAL";
                         $arrLegend["2_GROUP"][$ctype_u] += $arD[$ctype_u . "_COUNT"];
                         $arrDays[$arD["DATE_STAT"]]["GROUP"]["TOTAL_" . $ctype_u] += $arD[$ctype_u . "_COUNT"];
                     }
                 }
             }
         }
     }
     if (in_array("ctr", $arShow)) {
         // рассчитаем CTR
         reset($arrDays);
         while (list($keyD, $arD) = each($arrDays)) {
             reset($arrLegend);
             while (list(, $arrS) = each($arrLegend)) {
                 if ($arrS["COUNTER_TYPE"] == "DETAIL") {
                     $show_value = intval($arD[$arrS["TYPE"]][$arrS["COUNTER_TYPE"] . "_SHOW"][$arrS["ID"]]);
                     $click_value = intval($arD[$arrS["TYPE"]][$arrS["COUNTER_TYPE"] . "_CLICK"][$arrS["ID"]]);
                     if ($show_value <= 0) {
                         $ctr_value = 0;
                     } else {
                         $ctr_value = round($click_value * 100 / $show_value, 2);
                     }
                     $arD[$arrS["TYPE"]]["DETAIL_CTR"][$arrS["ID"]] = $ctr_value;
                     $arrDays[$keyD] = $arD;
                 } else {
                     $show_value = intval($arD[$arrS["TYPE"]][$arrS["COUNTER_TYPE"] . "_SHOW"]);
                     $click_value = intval($arD[$arrS["TYPE"]][$arrS["COUNTER_TYPE"] . "_CLICK"]);
                     if ($show_value <= 0) {
                         $ctr_value = 0;
                     } else {
                         $ctr_value = round($click_value * 100 / $show_value, 2);
                     }
                     $arD[$arrS["TYPE"]]["TOTAL_CTR"] = $ctr_value;
                     $arrDays[$keyD] = $arD;
                 }
             }
         }
     }
     // Определим цвета и суммарный CTR
     reset($arrLegend);
     $s = 0;
     if (in_array("ctr", $arShow)) {
         $s++;
     }
     if ($arFilter["WHAT_SHOW"] != array("ctr") && in_array("show", $arShow)) {
         $s++;
     }
     if ($arFilter["WHAT_SHOW"] != array("ctr") && in_array("click", $arShow)) {
         $s++;
     }
     if ($arFilter["WHAT_SHOW"] != array("ctr") && in_array("visitor", $arShow)) {
         $s++;
     }
     $total = sizeof($arrLegend) * $s;
     $color = "";
     while (list($key, $arr) = each($arrLegend)) {
         if (in_array("ctr", $arShow)) {
             $color = GetNextRGB($color, $total);
             $arr["COLOR_CTR"] = $color;
             if ($arr["SHOW"] <= 0) {
                 $ctr = 0;
             } else {
                 $ctr = round($arr["CLICK"] * 100 / $arr["SHOW"], 2);
             }
             $arr["CTR"] = $ctr;
         }
         if ($arFilter["WHAT_SHOW"] != array("ctr")) {
             if (in_array("show", $arShow)) {
                 $color = GetNextRGB($color, $total);
                 $arr["COLOR_SHOW"] = $color;
             }
             if (in_array("click", $arShow)) {
                 $color = GetNextRGB($color, $total);
                 $arr["COLOR_CLICK"] = $color;
             }
             if (in_array("visitor", $arShow)) {
                 $color = GetNextRGB($color, $total);
                 $arr["COLOR_VISITOR"] = $color;
             }
         }
         $arr["COLOR"] = $color;
         $arrLegend[$key] = $arr;
     }
     krsort($arrLegend);
     $is_filtered = IsFiltered($strSqlSearch);
     reset($arrDays);
     reset($arrLegend);
     return $arrDays;
 }