CExcelXMLTableShowHTML.class

SUBMITTED BY: Guest

DATE: July 23, 2014, 12:19 p.m.

FORMAT: Text only

SIZE: 12.5 kB

Raw Download

HITS: 1185

Report
  1. <?php
  3. include_once('CExcelXMLHTMLTable.class');
  5. class CExcelXMLTableShowHTML {
  7. var $version = '1.0a';
  8. var $author_info = 'Sergey Ovchinnikov <sergeyvo@ngs.ru>, ICQ UIN 91792005';
  10. var $Styles;
  11. var $StylesHTML;
  13. var $Tables;
  14. var $TablesHTML;
  16. var $HTMLTable;
  18. var $active_styles = array (
  20. 'font_size' => 'on',
  21. 'font_family' => 'on',
  22. 'font_color' => 'on',
  23. 'font_bold' => 'on',
  24. 'font_italic' => 'on',
  25. 'font_underline' => 'on',
  27. 'text_align' => 'on',
  28. 'text_valign' => 'on',
  30. 'bg_color' => 'on',
  32. 'column_width' => 'on',
  33. 'row_height' => 'on',
  35. // 'border_top' => 'on',
  36. // 'border_right' => 'on',
  37. // 'border_bottom' => 'on',
  38. // 'border_left' => 'on',
  40. 'number_format' => 'on'
  42. );
  44. var $default_styles = array (
  46. 'table_border' => 1,
  47. 'table_bordercolor' => "#C0C0C0",
  48. 'table_cellspacing' => 0,
  49. 'table_cellpadding' => 0,
  50. 'table_style' => "border-collapse:collapse;",
  52. 'font_size' => '10',
  53. 'font_family' => 'Arial Cyr',
  54. 'font_color' => '#000000',
  55. 'font_bold' => '',
  56. 'font_italic' => '',
  57. 'font_underline' => '',
  59. 'text_align' => '',
  60. 'text_valign' => '',
  62. 'bg_color' => '',
  64. 'column_width' => 64,
  65. 'row_height' => 15,
  67. );
  70. #===============================================================================================
  71. # CExcelXMLTableShowHTML
  72. #===============================================================================================
  73. function CExcelXMLTableShowHTML() {
  75. $this->HTMLTable = new CExcelXMLHTMLTable();
  76. }
  77. #===============================================================================================
  78. # SET ACTIVE STYLES
  79. #===============================================================================================
  80. function setActiveStyles($active_styles) {
  82. foreach($active_styles as $key=>$property) {
  84. $this->active_styles[$key] = $property;
  86. }
  88. }
  89. #===============================================================================================
  90. # SET DEFAULT STYLES
  91. #===============================================================================================
  92. function setDefaultStyles($default_styles) {
  94. foreach($default_styles as $key=>$property) {
  96. $this->default_styles[$key] = $property;
  98. }
  100. }
  101. #===============================================================================================
  102. # SET STYLES
  103. #===============================================================================================
  104. function setStyles($styles) {
  106. $this->Styles = $styles;
  107. }
  108. #===============================================================================================
  109. # SET TABLES
  110. #===============================================================================================
  111. function setTables($tables) {
  113. $this->Tables = $tables;
  114. }
  115. #===============================================================================================
  116. # GEN STYLE SHEET
  117. #===============================================================================================
  118. function genStyleSheet($styles) {
  120. $this->Styles = $styles;
  121. $active = $this->active_styles;
  122. $default = $this->default_styles;
  124. $sHTML.= "\n\n<STYLE>\n";
  127. if (strval($default['font_size']) =='') $default['font_size'] = $this->Styles['Default']['Font']['Size'];
  128. if (strval($default['font_family']) =='') $default['font_family'] = $this->Styles['Default']['Font']['FontName'];
  129. if (strval($default['font_color']) =='') $default['font_color'] = $this->Styles['Default']['Font']['Color'];
  130. if (strval($default['font_bold']) =='') $default['font_bold'] = $this->Styles['Default']['Font']['Bold'];
  132. if (strval($default['text_align']) =='') $default['text_align'] = $this->Styles['Default']['Alignment']['Horizontal'];
  133. // if (strval($default['text_valign']) =='') $default['text_valign'] = $this->Styles['Default']['Alignment']['Vertical'];
  135. if (strval($default['background']) =='') $default['background'] = $this->Styles['Default']['Interior']['Color'];
  137. if (strval($default['border_bottom'])=='') $default['border_bottom'] = $this->Styles['Default']['Borders']['Bottom']['Weight'];
  138. if (strval($default['border_left']) =='') $default['border_left'] = $this->Styles['Default']['Borders']['Left']['Weight'];
  139. if (strval($default['border_right']) =='') $default['border_right'] = $this->Styles['Default']['Borders']['Right']['Weight'];
  140. if (strval($default['border_top']) =='') $default['border_top'] = $this->Styles['Default']['Borders']['Top']['Weight'];
  143. $defHTML = $this->createStyle($default);
  145. if ($defHTML) {
  147. $sHTML.= "TD {\n";
  148. $sHTML.= $defHTML;
  149. $sHTML.= "}\n";
  150. }
  153. foreach($this->Styles as $style_name=>$style) {
  155. if ($active['font_size'] =='on') $st['font_size'] = $style['Font']['Size'];
  156. if ($active['font_family'] =='on') $st['font_family'] = $style['Font']['FontName'];
  157. if ($active['font_color'] =='on') $st['font_color'] = $style['Font']['Color'];
  158. if ($active['font_bold'] =='on') $st['font_bold'] = $style['Font']['Bold'];
  160. if ($active['font_italic'] =='on') $st['font_italic'] = $style['Font']['Italic'];
  161. if ($active['font_underline'] =='on') $st['font_underline'] = $style['Font']['Underline'];
  164. if ($active['text_align'] =='on') $st['text_align'] = $style['Alignment']['Horizontal'];
  165. if ($active['text_valign'] =='on') $st['text_valign'] = $style['Alignment']['Vertical'];
  167. if ($active['background'] =='on') $st['background'] = $style['Interior']['Color'];
  169. if ($active['border_bottom']=='on') $st['border_bottom'] = $style['Borders']['Bottom']['Weight'];
  170. if ($active['border_left'] =='on') $st['border_left'] = $style['Borders']['Left']['Weight'];
  171. if ($active['border_right'] =='on') $st['border_right'] = $style['Borders']['Right']['Weight'];
  172. if ($active['border_top'] =='on') $st['border_top'] = $style['Borders']['Top']['Weight'];
  174. $sBody = $this->createStyle($st);
  176. if ($sBody!='') {
  178. $sHTML.= ".".$style_name." {\n";
  179. $sHTML.= $sBody;
  180. $sHTML.= "}\n";
  182. }
  184. }
  186. $sHTML.= "</STYLE>\n\n";
  188. $this->StylesHTML = $sHTML;
  190. }
  192. #===============================================================================================
  193. # CREATE STYLE
  194. #===============================================================================================
  195. function createStyle($style) {
  197. $sBody='';
  200. if (strval($style['font_size'])!='')
  201. $sBody.= " font-size: ".$style['font_size']."px;\n";
  203. if (strval($style['font_family'])!='')
  204. $sBody.= " font-family: ".$style['font_family'].";\n";
  206. if (strval($style['font_color'])!='')
  207. $sBody.= " color: ".$style['font_color'].";\n";
  209. if (strval($style['font_bold'])=='1')
  210. $sBody.= " font-weight: bold;\n";
  213. if (strval($style['font_italic'])!='')
  214. $sBody.= " font-style: italic;\n";
  216. if (strval($style['font_underline'])!='')
  217. $sBody.= " text-decoration: underline;\n";
  221. if (strval($style['text_align'])!='')
  222. $sBody.= " text-align: ".$style['text_align'].";\n";
  224. if (strval($style['text_valign'])!='')
  225. $sBody.= " vertical-align: ".$style['text_valign'].";\n";
  229. if (strval($style['background'])!='')
  230. $sBody.= " background: ".$style['background'].";\n";
  233. if (strval($style['border_top'])!='')
  234. $sBody.= " border-top: ".$style['border_top']."pt solid windowtext;\n";
  236. if (strval($style['border_right'])!='')
  237. $sBody.= " border-right: ".$style['border_right']."pt solid windowtext;\n";
  239. if (strval($style['border_bottom'])!='')
  240. $sBody.= " border-bottom: ".$style['border_bottom']."pt solid windowtext;\n";
  242. if (strval($style['border_left'])!='')
  243. $sBody.= " border-left: ".$style['border_left']."pt solid windowtext;\n";
  245. return $sBody;
  247. }
  248. #===============================================================================================
  249. # SHOW HTML STYLE SHEET
  250. #===============================================================================================
  251. function showHTMLStyleSheet($styles) {
  253. $this->Styles = $styles;
  255. $this->genStyleSheet($styles);
  256. echo $this->StylesHTML;
  258. }
  260. #===============================================================================================
  261. # GEN EXCEL TABLE
  262. #===============================================================================================
  263. function genExcelTable($tables) {
  267. }
  269. #===============================================================================================
  270. # SHOW HTML EXCEL TABLE
  271. #===============================================================================================
  272. function showHTMLExcelTable() {
  274. // $this->Tables = $tables;
  276. $td_properties = array(
  277. 'colspan' => 'Colspan',
  278. 'rowspan' => 'Rowspan',
  279. // 'class' => 'StyleID',
  280. 'content' => 'Content',
  281. );
  283. $tr_properties = array(
  284. 'height' => 'Height',
  285. );
  287. $this->HTMLTable->setTDProperties($td_properties);
  288. $this->HTMLTable->setTRProperties($tr_properties);
  290. $this->HTMLTable->Styles = $this->Styles;
  291. $this->HTMLTable->active_styles = $this->active_styles;
  292. $this->HTMLTable->default_styles = $this->default_styles;
  294. echo "<!----------------------------------------------------------------------------------->\n";
  295. echo "<!-------------------------- EXCEL TABLES ------------------------------------------>\n";
  296. echo "<!----------------------------------------------------------------------------------->\n";
  297. for ($i=0; $i<count($this->Tables); $i++) {
  299. if ($this->Tables[$i]['Table']['Rows']) {
  301. echo "<B>".$this->Tables[$i]['ListName']."</B>";
  302. $this->HTMLTable->Table = $this->Tables[$i]['Table'];
  304. $this->HTMLTable->setRangeRows($this->Tables[$i]['Table']['ExpandedRowCount']);
  305. $this->HTMLTable->setRangeCols($this->Tables[$i]['Table']['ExpandedColumnCount']);
  306. $this->HTMLTable->showTable();
  307. echo "<BR>\n";
  308. }
  310. }
  311. echo "<!----------------------------------------------------------------------------------->\n";
  312. echo "<!-------------------------- /EXCEL TABLES ----------------------------------------->\n";
  313. echo "<!----------------------------------------------------------------------------------->\n\n\n";
  315. }
  316. #===============================================================================================
  317. # / class
  318. #===============================================================================================
  320. }
  322. ?>
comments powered by Disqus