/oscommerce2-mypgsql/catalog/admin/includes/functions/html_graphs.php

https://github.com/shooray/oscommerce2-mypgsql · PHP · 568 lines · 400 code · 104 blank · 64 comment · 81 complexity · 3881520d9aff25deb37021e979d42ccf MD5 · raw file 

    

  1. <?php
    2. 

  2. /*
    3. 

  3.   $Id$
    4. 

    5. 

  5.   osCommerce, Open Source E-Commerce Solutions
    6. 

  6.   http://www.oscommerce.com
    7. 

    8. 

  8.   Copyright (c) 2002 osCommerce
    9. 

    10. 

  10.   Released under the GNU General Public License
    11. 

    12. 

  12.   HTML_Graphs (v1.5 1998/11/05 06:15:52) by Phil Davis, http://www.pobox.com/~pdavis/
    13. 

  13. */
    14. 

  14. 

  15. ////
    16. 

  16. // calls routines to initialize defaults, set up table
    17. 

  17. // print data, and close table.
    18. 

  18.   function html_graph($names, $values, $bars, $vals, $dvalues = 0, $dbars = 0) {
    19. 

  19. // set the error level on entry and exit so as not to interfear with anyone elses error checking.
    20. 

  20.     $er = error_reporting(1);
    21. 

  21. 

  22. // set the values that the user didn't
    23. 

  23.     $vals = hv_graph_defaults($vals);
    24. 

  24.     $html_graph_string = start_graph($vals, $names);
    25. 

  25. 

  26.     if ($vals['type'] == 0) {
    27. 

  27.       $html_graph_string .= horizontal_graph($names, $values, $bars, $vals);
    28. 

  28.     } elseif ($vals['type'] == 1) {
    29. 

  29.       $html_graph_string .= vertical_graph($names, $values, $bars, $vals);
    30. 

  30.     } elseif ($vals['type'] == 2) {
    31. 

  31.       $html_graph_string .= double_horizontal_graph($names, $values, $bars, $vals, $dvalues, $dbars);
    32. 

  32.     } elseif ($vals['type'] == 3) {
    33. 

  33.       $html_graph_string .= double_vertical_graph($names, $values, $bars, $vals, $dvalues, $dbars);
    34. 

  34.     }
    35. 

  35. 

  36.     $html_graph_string .= end_graph();
    37. 

  37. 

  38. // Set the error level back to where it was.
    39. 

  39.     error_reporting($er);  
    40. 

  40. 

  41.     return $html_graph_string;
    42. 

  42.   }
    43. 

  43. 

  44. ////
    45. 

  45. // sets up the $vals array by initializing all values to null. Used to avoid
    46. 

  46. // warnings from error_reporting being set high. This routine only needs to be
    47. 

  47. // called if you are worried about using uninitialized variables.
    48. 

  48.   function html_graph_init() {
    49. 

  49.     $vals = array('vlabel'=>'',
    50. 

  50.                   'hlabel'=>'',
    51. 

  51.                   'type'=>'',
    52. 

  52.                   'cellpadding'=>'',
    53. 

  53.                   'cellspacing'=>'',
    54. 

  54.                   'border'=>'',
    55. 

  55.                   'width'=>'',
    56. 

  56.                   'background'=>'',
    57. 

  57.                   'vfcolor'=>'',
    58. 

  58.                   'hfcolor'=>'',
    59. 

  59.                   'vbgcolor'=>'',
    60. 

  60.                   'hbgcolor'=>'',
    61. 

  61.                   'vfstyle'=>'',
    62. 

  62.                   'hfstyle'=>'',
    63. 

  63.                   'noshowvals'=>'',
    64. 

  64.                   'scale'=>'',
    65. 

  65.                   'namebgcolor'=>'',
    66. 

  66.                   'valuebgcolor'=>'',
    67. 

  67.                   'namefcolor'=>'',
    68. 

  68.                   'valuefcolor'=>'',
    69. 

  69.                   'namefstyle'=>'',
    70. 

  70.                   'valuefstyle'=>'',
    71. 

  71.                   'doublefcolor'=>'');
    72. 

  72. 

  73.     return($vals);
    74. 

  74.   }
    75. 

  75. 

  76. ////
    77. 

  77. // prints out the table header and graph labels
    78. 

  78.   function start_graph($vals, $names) {
    79. 

  79.     $start_graph_string = '<table cellpadding="' . $vals['cellpadding'] . '" cellspacing="' . $vals['cellspacing'] . '" border="' . $vals['border'] . '"';
    80. 

  80. 

  81.     if ($vals['width'] != 0) $start_graph_string .= ' width="' . $vals['width'] . '"';
    82. 

  82.     if ($vals['background']) $start_graph_string .= ' background="' . $vals['background'] . '"';
    83. 

  83. 

  84.     $start_graph_string .= '>' . "\n";
    85. 

  85. 

  86.     if ( ($vals['vlabel']) || ($vals['hlabel']) ) {
    87. 

  87.       if ( ($vals['type'] == 0) || ($vals['type'] == 2) ) {
    88. 

  88. // horizontal chart
    89. 

  89.         $rowspan = sizeof($names) + 1; 
    90. 

  90.         $colspan = 3; 
    91. 

  91.       } elseif ( ($vals['type'] == 1) || ($vals['type'] == 3) ) {
    92. 

  92. // vertical chart
    93. 

  93.         $rowspan = 3;
    94. 

  94.         $colspan = sizeof($names) + 1; 
    95. 

  95.       }
    96. 

  96. 

  97.       $start_graph_string .= '  <tr>' . "\n" .
    98. 

  98.                              '    <td align="center" valign="center"';
    99. 

  99. 

  100. // if a background was choosen don't print cell BGCOLOR
    101. 

  101.       if (!$vals['background']) $start_graph_string .= ' bgcolor="' . $vals['hbgcolor'] . '"';
    102. 

  102. 

  103.       $start_graph_string .= ' colspan="' . $colspan . '"><font color="' . $vals['hfcolor'] . '" style="' . $vals['hfstyle'] . '"><strong>' . $vals['hlabel'] . '</strong></font></td>' . "\n" .
    104. 

  104.                              '  </tr>' . "\n" .
    105. 

  105.                              '  <tr>' . "\n" .
    106. 

  106.                              '    <td align="center" valign="center"';
    107. 

  107. 

  108. // if a background was choosen don't print cell BGCOLOR
    109. 

  109.       if (!$vals['background']) $start_graph_string .= ' bgcolor="' . $vals['vbgcolor'] . '"';
    110. 

  110. 

  111.       $start_graph_string .=  ' rowspan="' . $rowspan . '"><font color="' . $vals['vfcolor'] . '" style="' . $vals['vfstyle'] . '"><strong>' . $vals['vlabel'] . '</strong></font></td>' . "\n" .
    112. 

  112.                               '  </tr>' . "\n";
    113. 

  113.     }
    114. 

  114. 

  115.     return $start_graph_string;
    116. 

  116.   }
    117. 

  117. 

  118. ////
    119. 

  119. // prints out the table footer
    120. 

  120.   function end_graph() {
    121. 

  121.     return '</table>' . "\n";
    122. 

  122.   }
    123. 

  123. 

  124. ////
    125. 

  125. // sets the default values for the $vals array
    126. 

  126.   function hv_graph_defaults($vals) {
    127. 

  127.     if (!$vals['vfcolor']) $vals['vfcolor'] = '#000000';
    128. 

  128.     if (!$vals['hfcolor']) $vals['hfcolor'] = '#000000';
    129. 

  129.     if (!$vals['vbgcolor']) $vals['vbgcolor'] = '#FFFFFF';
    130. 

  130.     if (!$vals['hbgcolor']) $vals['hbgcolor'] = '#FFFFFF';
    131. 

  131.     if (!$vals['cellpadding']) $vals['cellpadding'] = '0';
    132. 

  132.     if (!$vals['cellspacing']) $vals['cellspacing'] = '0';
    133. 

  133.     if (!$vals['border']) $vals['border'] = '0';
    134. 

  134.     if (!$vals['scale']) $vals['scale'] = '1';
    135. 

  135.     if (!$vals['namebgcolor']) $vals['namebgcolor'] = '#FFFFFF';
    136. 

  136.     if (!$vals['valuebgcolor']) $vals['valuebgcolor'] = '#FFFFFF';
    137. 

  137.     if (!$vals['namefcolor']) $vals['namefcolor'] = '#000000';
    138. 

  138.     if (!$vals['valuefcolor']) $vals['valuefcolor'] = '#000000';
    139. 

  139.     if (!$vals['doublefcolor']) $vals['doublefcolor'] = '#886666';
    140. 

  140. 

  141.     return $vals;
    142. 

  142.   }
    143. 

  143. 

  144. ////
    145. 

  145. // prints out the actual data for the horizontal chart
    146. 

  146.   function horizontal_graph($names, $values, $bars, $vals) {
    147. 

  147.     $horizontal_graph_string = '';
    148. 

  148.     for($i = 0, $n = sizeof($values); $i < $n; $i++) { 
    149. 

  149.       $horizontal_graph_string .= '  <tr>' . "\n" .
    150. 

  150.                                   '    <td align="right"';
    151. 

  151. // if a background was choosen don't print cell BGCOLOR
    152. 

  152.       if (!$vals['background']) $horizontal_graph_string .= ' bgcolor="' . $vals['namebgcolor'] . '"';
    153. 

  153. 

  154.       $horizontal_graph_string .= '><font size="-1" color="' . $vals['namefcolor'] . '" style="' . $vals['namefstyle'] . '">' . $names[$i] . '</font></td>' . "\n" .
    155. 

  155.                                   '    <td'; 
    156. 

  156. 

  157. // if a background was choosen don't print cell BGCOLOR
    158. 

  158.       if (!$vals['background']) $horizontal_graph_string .= ' bgcolor="' . $vals['valuebgcolor'] . '"';
    159. 

  159. 

  160.       $horizontal_graph_string .= '>';
    161. 

  161. 

  162. // decide if the value in bar is a color code or image.
    163. 

  163.       if (preg_match('/^#/', $bars[$i])) {
    164. 

  164.         $horizontal_graph_string .= '<table cellpadding="0" cellspacing="0" bgcolor="' . $bars[$i] . '" width="' . ($values[$i] * $vals['scale']) . '">' . "\n" .
    165. 

  165.                                     '  <tr>' . "\n" .
    166. 

  166.                                     '    <td>&nbsp;</td>' . "\n" .
    167. 

  167.                                     '  </tr>' . "\n" .
    168. 

  168.                                     '</table>';
    169. 

  169.       } else {
    170. 

  170.         $horizontal_graph_string .= '<img src="' . $bars[$i] . '" height="10" width="' . ($values[$i] * $vals['scale']) . '">';
    171. 

  171.       }
    172. 

  172. 

  173.       if (!$vals['noshowvals']) {
    174. 

  174.         $horizontal_graph_string .= '<i><font size="-2" color="' . $vals['valuefcolor'] . '" style="' . $vals['valuefstyle'] . '">(' . $values[$i] . ')</font></i>';
    175. 

  175.       }
    176. 

  176. 

  177.       $horizontal_graph_string .= '</td>' . "\n" .
    178. 

  178.                                   '  </tr>' . "\n";
    179. 

  179.     } // endfor
    180. 

  180. 

  181.     return $horizontal_graph_string;
    182. 

  182.   }
    183. 

  183. 

  184. ////
    185. 

  185. // prints out the actual data for the vertical chart
    186. 

  186.   function vertical_graph($names, $values, $bars, $vals) {
    187. 

  187.     $vertical_graph_string = '  <tr>' . "\n";
    188. 

  188. 

  189.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    190. 

  190.       $vertical_graph_string .= '    <td align="center" valign="bottom"';
    191. 

  191. 

  192. // if a background was choosen don't print cell BGCOLOR
    193. 

  193.       if (!$vals['background']) $vertical_graph_string .= ' bgcolor="' . $vals['valuebgcolor'] . '"';
    194. 

  194. 

  195.       $vertical_graph_string .= '>';
    196. 

  196. 

  197.       if (!$vals['noshowvals']) {
    198. 

  198.         $vertical_graph_string .= '<i><font size="-2" color="' . $vals['valuefcolor'] . '" style="' . $vals['valuefstyle'] . '">(' . $values[$i] . ')</font></i><br />';
    199. 

  199.       }
    200. 

  200. 

  201.       $vertical_graph_string .= '<img src="' . $bars[$i] . '" width="5" height="';
    202. 

  202. 

  203. // values of zero are displayed wrong because a image height of zero 
    204. 

  204. // gives a strange behavior in Netscape. For this reason the height 
    205. 

  205. // is set at 1 pixel if the value is zero. - Jan Diepens
    206. 

  206.       if ($values[$i] != 0) {
    207. 

  207.         $vertical_graph_string .= $values[$i] * $vals['scale'];
    208. 

  208.       } else {
    209. 

  209.         $vertical_graph_string .= '1';
    210. 

  210.       } 
    211. 

  211. 

  212.       $vertical_graph_string .= '"></td>' . "\n";
    213. 

  213.     } // endfor
    214. 

  214. 

  215.     $vertical_graph_string .= '  </tr>' . "\n" .
    216. 

  216.                               '  <tr>' . "\n";
    217. 

  217. 

  218.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    219. 

  219.       $vertical_graph_string .= '    <td align="center" valign="top"';
    220. 

  220. 

  221. // if a background was choosen don't print cell BGCOLOR
    222. 

  222.       if (!$vals['background']) $vertical_graph_string .= ' bgcolor="' . $vals['namebgcolor'] . '"';
    223. 

  223. 

  224.       $vertical_graph_string .= '><font size="-1" color="' . $vals['namefcolor'] . '" style="' . $vals['namefstyle'] . '">' . $names[$i] . '</font></td>' . "\n";
    225. 

  225.     } // endfor
    226. 

  226. 

  227.     $vertical_graph_string .= '  </tr>' . "\n";
    228. 

  228. 

  229.     return $vertical_graph_string;
    230. 

  230.   }
    231. 

  231. 

  232. ////
    233. 

  233. // prints out the actual data for the double horizontal chart
    234. 

  234.   function double_horizontal_graph($names, $values, $bars, $vals, $dvalues, $dbars) {
    235. 

  235.     $double_horizontal_graph_string = '';
    236. 

  236.     for($i = 0, $n = sizeof($values); $i < $n; $i++) {
    237. 

  237.       $double_horizontal_graph_string .= '  <tr>' . "\n" .
    238. 

  238.                                         '    <td align="right"';
    239. 

  239. 

  240. // if a background was choosen don't print cell BGCOLOR
    241. 

  241.       if (!$vals['background']) $double_horizontal_graph_string .= ' bgcolor="' . $vals['namebgcolor'] . '"';
    242. 

  242. 

  243.       $double_horizontal_graph_string .= '><font size="-1" color="' . $vals['namefcolor'] . '" style="' . $vals['namefstyle'] . '">' . $names[$i] . '</font></td>' . "\n" .
    244. 

  244.                                          '    <td';
    245. 

  245. 

  246. // if a background was choosen don't print cell BGCOLOR
    247. 

  247.       if (!$vals['background']) $double_horizontal_graph_string .= ' bgcolor="' . $vals['valuebgcolor'] . '"';
    248. 

  248. 

  249.       $double_horizontal_graph_string .= '><table align="left" cellpadding="0" cellspacing="0" width="' . ($dvalues[$i] * $vals['scale']) . '">' . "\n" .
    250. 

  250.                                          '      <tr>' . "\n" .
    251. 

  251.                                          '        <td';
    252. 

  252. 

  253. // set background to a color if it starts with # or an image otherwise.
    254. 

  254.       if (preg_match('/^#/', $dbars[$i])) {
    255. 

  255.         $double_horizontal_graph_string .= ' bgcolor="' . $dbars[$i] . '">';
    256. 

  256.       } else {
    257. 

  257.         $double_horizontal_graph_string .= ' background="' . $dbars[$i] . '">';
    258. 

  258.       }
    259. 

  259. 

  260.       $double_horizontal_graph_string .= '<nowrap>';
    261. 

  261. 

  262. // decide if the value in bar is a color code or image.
    263. 

  263.       if (preg_match('/^#/', $bars[$i])) {
    264. 

  264.         $double_horizontal_graph_string .= '<table align="left" cellpadding="0" cellspacing="0" bgcolor="' . $bars[$i] . '" width="' . ($values[$i] * $vals['scale']) . '">' . "\n" .
    265. 

  265.                                            '  <tr>' . "\n" .
    266. 

  266.                                            '    <td>&nbsp;</td>' . "\n" .
    267. 

  267.                                            '  </tr>' . "\n" .
    268. 

  268.                                            '</table>';
    269. 

  269.       } else {
    270. 

  270.         $double_horizontal_graph_string .= '<img src="' . $bars[$i] . '" height="10" width="' . ($values[$i] * $vals['scale']) . '">';
    271. 

  271.       }          
    272. 

  272. 

  273.       if (!$vals['noshowvals']) {
    274. 

  274.         $double_horizontal_graph_string .= '<i><font size="-3" color="' . $vals['valuefcolor'] . '" style="' . $vals['valuefstyle'] . '">(' . $values[$i] . ')</font></i>';
    275. 

  275.       }
    276. 

  276. 

  277.       $double_horizontal_graph_string .= '</nowrap></td>' . "\n" .
    278. 

  278.                                          '        </tr>' . "\n" .
    279. 

  279.                                          '      </table>';
    280. 

  280. 

  281.       if (!$vals['noshowvals']) {
    282. 

  282.         $double_horizontal_graph_string .= '<i><font size="-3" color="' . $vals['doublefcolor'] . '" style="' . $vals['valuefstyle'] . '">(' . $dvalues[$i] . ')</font></i>';
    283. 

  283.       }
    284. 

  284. 

  285.       $double_horizontal_graph_string .= '</td>' . "\n" .
    286. 

  286.                                          '  </tr>' . "\n";
    287. 

  287.     } // endfor
    288. 

  288. 

  289.     return $double_horizontal_graph_string;
    290. 

  290.   }
    291. 

  291. 

  292. ////
    293. 

  293. // prints out the actual data for the double vertical chart
    294. 

  294.   function double_vertical_graph($names, $values, $bars, $vals, $dvalues, $dbars) {
    295. 

  295.     $double_vertical_graph_string = '  <tr>' . "\n";
    296. 

  296.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    297. 

  297.       $double_vertical_graph_string .= '    <td align="center" valign="bottom"';
    298. 

  298. 

  299. // if a background was choosen don't print cell BGCOLOR
    300. 

  300.       if (!$vals['background']) $double_vertical_graph_string .= ' bgcolor="' . $vals['valuebgcolor'] . '"';
    301. 

  301. 

  302.       $double_vertical_graph_string .= '><table>' . "\n" .
    303. 

  303.                                        '      <tr>' . "\n" .
    304. 

  304.                                        '        <td align="center" valign="bottom"';
    305. 

  305. 

  306. // if a background was choosen don't print cell BGCOLOR
    307. 

  307.       if (!$vals['background']) $double_vertical_graph_string .= ' bgcolor="' . $vals['valuebgcolor'] . '"';
    308. 

  308. 

  309.       $double_vertical_graph_string .= '>';
    310. 

  310. 

  311.       if (!$vals['noshowvals'] && $values[$i]) {
    312. 

  312.         $double_vertical_graph_string .= '<i><font size="-2" color="' . $vals['valuefcolor'] . '" style="' . $vals['valuefstyle'] . '">(' . $values[$i] . ')</font></i><br />';
    313. 

  313.       }
    314. 

  314. 

  315.       $double_vertical_graph_string .= '<img src="' . $bars[$i] . '" width="10" height="';
    316. 

  316. 

  317.       if ($values[$i] != 0) {
    318. 

  318.         $double_vertical_graph_string .= $values[$i] * $vals['scale'];
    319. 

  319.       } else {
    320. 

  320.         $double_vertical_graph_string .= '1';
    321. 

  321.       }
    322. 

  322. 

  323.       $double_vertical_graph_string .= '"></td>' . "\n" .
    324. 

  324.                                        '        <td align="center" valign="bottom"';
    325. 

  325. 

  326. // if a background was choosen don't print cell BGCOLOR
    327. 

  327.       if (!$vals['background']) $double_vertical_graph_string .= ' bgcolor="' . $vals['valuebgcolor'] . '"';
    328. 

  328. 

  329.       $double_vertical_graph_string .= '>';
    330. 

  330. 

  331.       if (!$vals['noshowvals'] && $dvalues[$i]) {
    332. 

  332.         $double_vertical_graph_string .= '<i><font size="-2" color="' . $vals['doublefcolor'] . '" style="' . $vals['valuefstyle'] . '">(' . $dvalues[$i] . ')</font></i><br />';
    333. 

  333.       }
    334. 

  334. 

  335.       $double_vertical_graph_string .= '<img src="' . $dbars[$i] . '" width="10" height="';
    336. 

  336. 

  337.       if ($dvalues[$i] != 0) {
    338. 

  338.         $double_vertical_graph_string .= $dvalues[$i] * $vals['scale'];
    339. 

  339.       } else {
    340. 

  340.         $double_vertical_graph_string .= '1';
    341. 

  341.       }
    342. 

  342. 

  343.       $double_vertical_graph_string .= '"></td>' . "\n" .
    344. 

  344.                                        '      </tr>' . "\n" .
    345. 

  345.                                        '    </table></td>' . "\n";
    346. 

  346.     } // endfor
    347. 

  347. 

  348.     $double_vertical_graph_string .= '  </tr>' . "\n" .
    349. 

  349.                                      '  <tr>' . "\n";
    350. 

  350. 

  351.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    352. 

  352.       $double_vertical_graph_string .= '    <td align="center" valign="top"';
    353. 

  353. 

  354. // if a background was choosen don't print cell BGCOLOR
    355. 

  355.       if (!$vals['background']) $double_vertical_graph_string .= ' bgcolor="' . $vals['namebgcolor'] . '"';
    356. 

  356. 

  357.       $double_vertical_graph_string .= '><font size="-1" color="' . $vals['namefcolor'] . '" style="' . $vals['namefstyle'] . '">' . $names[$i] . '</font></td>' . "\n";
    358. 

  358.     } // endfor
    359. 

  359. 

  360.     $double_vertical_graph_string .= '  </tr>' . "\n";
    361. 

  361. 

  362.     return $double_vertical_graph_string;
    363. 

  363.   }
    364. 

  364. 

  365. ////
    366. 

  366. // draws a double vertical bar graph for the banner views vs clicks statistics
    367. 

  367.   function tep_banner_graph_infoBox($banner_id, $days) {
    368. 

  368.     $names = array();
    369. 

  369.     $values = array();
    370. 

  370.     $dvalues = array();
    371. 

  371. 

  372.     $banner_stats_query = tep_db_query("select dayofmonth(banners_history_date) as name, banners_shown as value, banners_clicked as dvalue from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . $banner_id . "' and to_days(now()) - to_days(banners_history_date) < " . $days . " order by banners_history_date");
    373. 

  373.     while ($banner_stats = tep_db_fetch_array($banner_stats_query)) {
    374. 

  374.       $names[] = $banner_stats['name'];
    375. 

  375.       $values[] = $banner_stats['value'];
    376. 

  376.       $dvalues[] = $banner_stats['dvalue'];
    377. 

  377.     }
    378. 

  378.     $largest = @max($values);
    379. 

  379. 

  380.     $bars = array();
    381. 

  381.     $dbars = array();
    382. 

  382.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    383. 

  383.       $bars[$i] = DIR_WS_IMAGES . 'graph_hbar_blue.gif';
    384. 

  384.       $dbars[$i] = DIR_WS_IMAGES . 'graph_hbar_red.gif';
    385. 

  385.     }
    386. 

  386. 

  387.     $graph_vals = @array('vlabel'=>TEXT_BANNERS_DATA,
    388. 

  388.                         'hlabel'=>TEXT_BANNERS_LAST_3_DAYS,
    389. 

  389.                         'type'=>'3',
    390. 

  390.                         'cellpadding'=>'',
    391. 

  391.                         'cellspacing'=>'1',
    392. 

  392.                         'border'=>'',
    393. 

  393.                         'width'=>'',
    394. 

  394.                         'vfcolor'=>'#ffffff',
    395. 

  395.                         'hfcolor'=>'#ffffff',
    396. 

  396.                         'vbgcolor'=>'#81a2b6',
    397. 

  397.                         'hbgcolor'=>'#81a2b6',
    398. 

  398.                         'vfstyle'=>'Verdana, Arial, Helvetica',
    399. 

  399.                         'hfstyle'=>'Verdana, Arial, Helvetica',
    400. 

  400.                         'scale'=>100/$largest,
    401. 

  401.                         'namebgcolor'=>'#f3f5fe',
    402. 

  402.                         'valuebgcolor'=>'#f3f5fe',
    403. 

  403.                         'namefcolor'=>'',
    404. 

  404.                         'valuefcolor'=>'#0000d0',
    405. 

  405.                         'namefstyle'=>'Verdana, Arial, Helvetica',
    406. 

  406.                         'valuefstyle'=>'',
    407. 

  407.                         'doublefcolor'=>'#ff7339');
    408. 

  408. 

  409.     return html_graph($names, $values, $bars, $graph_vals, $dvalues, $dbars);
    410. 

  410.   }
    411. 

  411. 

  412. ////
    413. 

  413. // draws a double vertical bar graph for the banner views vs clicks statistics
    414. 

  414.   function tep_banner_graph_yearly($banner_id) {
    415. 

  415.     global $banner, $HTTP_GET_VARS;
    416. 

  416. 

  417.     $banner_stats_query = tep_db_query("select year(banners_history_date) as year, sum(banners_shown) as value, sum(banners_clicked) as dvalue from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . $banner_id . "' group by year(banners_history_date)");
    418. 

  418.     while ($banner_stats = tep_db_fetch_array($banner_stats_query)) {
    419. 

  419.       $names[] = $banner_stats['year'];
    420. 

  420.       $values[] = (($banner_stats['value']) ? $banner_stats['value'] : '0');
    421. 

  421.       $dvalues[] = (($banner_stats['dvalue']) ? $banner_stats['dvalue'] : '0');
    422. 

  422.     }
    423. 

  423. 

  424.     $largest = @max($values);
    425. 

  425. 

  426.     $bars = array();
    427. 

  427.     $dbars = array();
    428. 

  428.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    429. 

  429.       $bars[$i] = DIR_WS_IMAGES . 'graph_hbar_blue.gif';
    430. 

  430.       $dbars[$i] = DIR_WS_IMAGES . 'graph_hbar_red.gif';
    431. 

  431.     }
    432. 

  432. 

  433.     $graph_vals = @array('vlabel'=>TEXT_BANNERS_DATA,
    434. 

  434.                         'hlabel'=>sprintf(TEXT_BANNERS_YEARLY_STATISTICS, $banner['banners_title']),
    435. 

  435.                         'type'=>'3',
    436. 

  436.                         'cellpadding'=>'',
    437. 

  437.                         'cellspacing'=>'1',
    438. 

  438.                         'border'=>'',
    439. 

  439.                         'width'=>'',
    440. 

  440.                         'vfcolor'=>'#ffffff',
    441. 

  441.                         'hfcolor'=>'#ffffff',
    442. 

  442.                         'vbgcolor'=>'#81a2b6',
    443. 

  443.                         'hbgcolor'=>'#81a2b6',
    444. 

  444.                         'vfstyle'=>'Verdana, Arial, Helvetica',
    445. 

  445.                         'hfstyle'=>'Verdana, Arial, Helvetica',
    446. 

  446.                         'scale'=>100/$largest,
    447. 

  447.                         'namebgcolor'=>'#f3f5fe',
    448. 

  448.                         'valuebgcolor'=>'#f3f5fe',
    449. 

  449.                         'namefcolor'=>'',
    450. 

  450.                         'valuefcolor'=>'#0000d0',
    451. 

  451.                         'namefstyle'=>'Verdana, Arial, Helvetica',
    452. 

  452.                         'valuefstyle'=>'',
    453. 

  453.                         'doublefcolor'=>'#ff7339');
    454. 

  454. 

  455.     return html_graph($names, $values, $bars, $graph_vals, $dvalues, $dbars);
    456. 

  456.   }
    457. 

  457. 

  458. ////
    459. 

  459. // draws a double vertical bar graph for the banner views vs clicks statistics
    460. 

  460.   function tep_banner_graph_monthly($banner_id) {
    461. 

  461.     global $banner, $HTTP_GET_VARS;
    462. 

  462. 

  463.     $year = (($HTTP_GET_VARS['year']) ? $HTTP_GET_VARS['year'] : date('Y'));
    464. 

  464. 

  465.     for ($i=1; $i<13; $i++) {
    466. 

  466.       $names[] = strftime('%b', mktime(0,0,0,$i));
    467. 

  467.       $values[] = '0';
    468. 

  468.       $dvalues[] = '0';
    469. 

  469.     }
    470. 

  470. 

  471.     $banner_stats_query = tep_db_query("select month(banners_history_date) as banner_month, sum(banners_shown) as value, sum(banners_clicked) as dvalue from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . $banner_id . "' and year(banners_history_date) = '" . $year . "' group by month(banners_history_date)");
    472. 

  472.     while ($banner_stats = tep_db_fetch_array($banner_stats_query)) {
    473. 

  473.       $names[($banner_stats['banner_month']-1)] = strftime('%b', mktime(0,0,0,$banner_stats['banner_month']));
    474. 

  474.       $values[($banner_stats['banner_month']-1)] = (($banner_stats['value']) ? $banner_stats['value'] : '0');
    475. 

  475.       $dvalues[($banner_stats['banner_month']-1)] = (($banner_stats['dvalue']) ? $banner_stats['dvalue'] : '0');
    476. 

  476.     }
    477. 

  477. 

  478.     $largest = @max($values);
    479. 

  479. 

  480.     $bars = array();
    481. 

  481.     $dbars = array();
    482. 

  482.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    483. 

  483.       $bars[$i] = DIR_WS_IMAGES . 'graph_hbar_blue.gif';
    484. 

  484.       $dbars[$i] = DIR_WS_IMAGES . 'graph_hbar_red.gif';
    485. 

  485.     }
    486. 

  486. 

  487.     $graph_vals = @array('vlabel'=>TEXT_BANNERS_DATA,
    488. 

  488.                         'hlabel'=>sprintf(TEXT_BANNERS_MONTHLY_STATISTICS, $banner['banners_title'], date('Y')),
    489. 

  489.                         'type'=>'3',
    490. 

  490.                         'cellpadding'=>'',
    491. 

  491.                         'cellspacing'=>'1',
    492. 

  492.                         'border'=>'',
    493. 

  493.                         'width'=>'',
    494. 

  494.                         'vfcolor'=>'#ffffff',
    495. 

  495.                         'hfcolor'=>'#ffffff',
    496. 

  496.                         'vbgcolor'=>'#81a2b6',
    497. 

  497.                         'hbgcolor'=>'#81a2b6',
    498. 

  498.                         'vfstyle'=>'Verdana, Arial, Helvetica',
    499. 

  499.                         'hfstyle'=>'Verdana, Arial, Helvetica',
    500. 

  500.                         'scale'=>100/$largest,
    501. 

  501.                         'namebgcolor'=>'#f3f5fe',
    502. 

  502.                         'valuebgcolor'=>'#f3f5fe',
    503. 

  503.                         'namefcolor'=>'',
    504. 

  504.                         'valuefcolor'=>'#0000d0',
    505. 

  505.                         'namefstyle'=>'Verdana, Arial, Helvetica',
    506. 

  506.                         'valuefstyle'=>'',
    507. 

  507.                         'doublefcolor'=>'#ff7339');
    508. 

  508. 

  509.     return html_graph($names, $values, $bars, $graph_vals, $dvalues, $dbars);
    510. 

  510.   }
    511. 

  511. 

  512. ////
    513. 

  513. // draws a double vertical bar graph for the banner views vs clicks statistics
    514. 

  514.   function tep_banner_graph_daily($banner_id) {
    515. 

  515.     global $banner, $HTTP_GET_VARS;
    516. 

  516. 

  517.     $year = (isset($HTTP_GET_VARS['year']) ? $HTTP_GET_VARS['year'] : date('Y'));
    518. 

  518.     $month = (isset($HTTP_GET_VARS['month']) ? $HTTP_GET_VARS['month'] : date('n'));
    519. 

  519. 

  520.     $days = (date('t', mktime(0,0,0,$month))+1);
    521. 

  521.     $stats = array();
    522. 

  522.     for ($i=1; $i<$days; $i++) {
    523. 

  523.       $names[] = $i;
    524. 

  524.       $values[] = '0';
    525. 

  525.       $dvalues[] = '0';
    526. 

  526.     }
    527. 

  527. 

  528.     $banner_stats_query = tep_db_query("select dayofmonth(banners_history_date) as banner_day, banners_shown as value, banners_clicked as dvalue from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . $banner_id . "' and month(banners_history_date) = '" . $month . "' and year(banners_history_date) = '" . $year . "'");
    529. 

  529.     while ($banner_stats = tep_db_fetch_array($banner_stats_query)) {
    530. 

  530.       $names[($banner_stats['banner_day']-1)] = $banner_stats['banner_day'];
    531. 

  531.       $values[($banner_stats['banner_day']-1)] = (($banner_stats['value']) ? $banner_stats['value'] : '0');
    532. 

  532.       $dvalues[($banner_stats['banner_day']-1)] = (($banner_stats['dvalue']) ? $banner_stats['dvalue'] : '0');
    533. 

  533.     }
    534. 

  534. 

  535.     $largest = @max($values);
    536. 

  536. 

  537.     $bars = array();
    538. 

  538.     $dbars = array();
    539. 

  539.     for ($i = 0, $n = sizeof($values); $i < $n; $i++) {
    540. 

  540.       $bars[$i] = DIR_WS_IMAGES . 'graph_hbar_blue.gif';
    541. 

  541.       $dbars[$i] = DIR_WS_IMAGES . 'graph_hbar_red.gif';
    542. 

  542.     }
    543. 

  543. 

  544.     $graph_vals = @array('vlabel'=>TEXT_BANNERS_DATA,
    545. 

  545.                         'hlabel'=>sprintf(TEXT_BANNERS_DAILY_STATISTICS, $banner['banners_title'], strftime('%B', mktime(0,0,0,$month)), $year),
    546. 

  546.                         'type'=>'3',
    547. 

  547.                         'cellpadding'=>'',
    548. 

  548.                         'cellspacing'=>'1',
    549. 

  549.                         'border'=>'',
    550. 

  550.                         'width'=>'',
    551. 

  551.                         'vfcolor'=>'#ffffff',
    552. 

  552.                         'hfcolor'=>'#ffffff',
    553. 

  553.                         'vbgcolor'=>'#81a2b6',
    554. 

  554.                         'hbgcolor'=>'#81a2b6',
    555. 

  555.                         'vfstyle'=>'Verdana, Arial, Helvetica',
    556. 

  556.                         'hfstyle'=>'Verdana, Arial, Helvetica',
    557. 

  557.                         'scale'=>100/$largest,
    558. 

  558.                         'namebgcolor'=>'#f3f5fe',
    559. 

  559.                         'valuebgcolor'=>'#f3f5fe',
    560. 

  560.                         'namefcolor'=>'',
    561. 

  561.                         'valuefcolor'=>'#0000d0',
    562. 

  562.                         'namefstyle'=>'Verdana, Arial, Helvetica',
    563. 

  563.                         'valuefstyle'=>'',
    564. 

  564.                         'doublefcolor'=>'#ff7339');
    565. 

  565. 

  566.     return html_graph($names, $values, $bars, $graph_vals, $dvalues, $dbars);
    567. 

  567.   }
    568. 

  568. ?>
    569.