query($sql); while ($r = $db->fetch($res)) { $stats[] = $r; } $zasobInfo = null; $sql = " select z.`DESC`, z.`DESC_PL`, z.`OPIS` from `CRM_LISTA_ZASOBOW` z where z.`DESC`='index.php?MENU_INIT=USERS2_MARKETING_STATS_CURRENT_COST_VIEW' "; $res = $db->query($sql); while ($r = $db->fetch($res)) { $zasobInfo = $r; } SE_Layout::menu(); ?>

DESC_PL; ?>
OPIS; ?>

PAY_RANGE_LIMIT; $lastPayRangeLimit = $payRangeLimit - 10; $jsonPriceDataByRangeLimit = array(); $vValue = $vSalesByRangeLimit->NET; $jsonPriceDataByRangeLimit["NET-{$lastPayRangeLimit}-{$payRangeLimit}"] = (int)$vValue; $kLabel = 'NET'; $jsonTooltips[] = "Ilość klientów płącących za {$kLabel} w przedziale od {$lastPayRangeLimit}zł do {$payRangeLimit}zł: {$vValue}"; $vValue = $vSalesByRangeLimit->NET_plus_TEL_or_TV; $jsonPriceDataByRangeLimit["NET-PLUS-{$lastPayRangeLimit}-{$payRangeLimit}"] = (int)$vValue; $kLabel = 'NET plus TEL lub TV'; $jsonTooltips[] = "Ilość klientów płącących za {$kLabel} w przedziale od {$lastPayRangeLimit}zł do {$payRangeLimit}zł: {$vValue}"; $jsonData[] = array_values($jsonPriceDataByRangeLimit); $jsonLabels[] = "od {$lastPayRangeLimit}zł do {$payRangeLimit}zł"; } $wykresMinItemHeight = 14; $wykresTestHeight = count($stats) * 3 * $wykresMinItemHeight; if ($wykresTestHeight > $wykresHeight - 60 - 20) { $wykresHeight = $wykresTestHeight + 60 + 20; } $jsonColorsAll = array(); for ($i = 0, $mi = 0, $mc = count($jsonColors); $i < 12; $i++) { $jsonColorsAll[] = $jsonColors[$mi]; if (++$mi >= $mc) { $mi = 0; } } $jsonColors = $jsonColorsAll; ?>
[No canvas support]
PAY_RANGE_LIMIT - 10; ?>
przedział cenowy ilość klientów płacących za NET ilość klientów płacących za NET plus TEL lub TV
od zł do PAY_RANGE_LIMIT; ?>zł NET; ?> NET_plus_TEL_or_TV; ?>
';print_r($stats);echo'';// TODO: RMME $sqlCreateView = " CREATE VIEW `USERS2_MARKETING_STATS_CURRENT_COST_VIEW` AS select `USERS2_MARKETING_STATS_CURRENT_COST_TEMP_VIEW`.`PAY` AS `PAY_RANGE_LIMIT` , sum(if((`USERS2_MARKETING_STATS_CURRENT_COST_TEMP_VIEW`.`SERVICES` = 'I'),1,0)) AS `NET` , sum(if((`USERS2_MARKETING_STATS_CURRENT_COST_TEMP_VIEW`.`SERVICES` = 'ITV'),1,0)) AS `NET_plus_TEL_or_TV` from `USERS2_MARKETING_STATS_CURRENT_COST_TEMP_VIEW` group by `USERS2_MARKETING_STATS_CURRENT_COST_TEMP_VIEW`.`PAY` order by `USERS2_MARKETING_STATS_CURRENT_COST_TEMP_VIEW`.`PAY` "; $sqlCreateTempView = " CREATE VIEW `USERS2_MARKETING_STATS_CURRENT_COST_TEMP_VIEW` AS select `USERS2_MARKETING`.`M_REWIR` AS `M_REWIR` , 'I' AS `SERVICES` , (ceiling((`USERS2_MARKETING`.`I_PAY` / 10)) * 10) AS `PAY` from `USERS2_MARKETING` where ((substr(`USERS2_MARKETING`.`M_REWIR`,1,(locate('.',`USERS2_MARKETING`.`M_REWIR`) - 1)) in ('PRZYWIDZ','KOLBUDY','TRABKI_WIELKIE')) and (coalesce(`USERS2_MARKETING`.`I_PAY`,0) > 0)) union all select `USERS2_MARKETING`.`M_REWIR` AS `M_REWIR` , 'ITV' AS `SERVICES` , (ceiling((((`USERS2_MARKETING`.`I_PAY` + coalesce(`USERS2_MARKETING`.`T_PAY`,0)) + coalesce(`USERS2_MARKETING`.`TV_PAY`,0)) / 10)) * 10) AS `PAY` from `USERS2_MARKETING` where ((substr(`USERS2_MARKETING`.`M_REWIR`,1,(locate('.',`USERS2_MARKETING`.`M_REWIR`) - 1)) in ('PRZYWIDZ','KOLBUDY','TRABKI_WIELKIE')) and (coalesce(`USERS2_MARKETING`.`I_PAY`,0) > 0) and ((coalesce(`USERS2_MARKETING`.`T_PAY`,0) > 0) or (coalesce(`USERS2_MARKETING`.`TV_PAY`,0) > 0))) "; }