CExcelXMLHTMLTable.class

SUBMITTED BY: Guest

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

FORMAT: Text only

SIZE: 10.0 kB

Raw Download

HITS: 967

Report
  1. <?php
  3. include_once 'CHTMLTable.class';
  5. class CExcelXMLHTMLTable extends CHTMLTable{
  7. var $version = '1.1a';
  8. var $author_info = 'Sergey Ovchinnikov <sergeyvo@ngs.ru>, ICQ UIN 91792005';
  10. var $Styles;
  12. var $active_styles;
  13. var $default_styles;
  15. #===============================================================================================
  16. # PRINT OPEN TABLE
  17. #===============================================================================================
  18. function printOpenTable() {
  20. $default = $this->default_styles;
  22. $this->Table['border'] = $default['table_border'];
  23. $this->Table['bordercolor'] = $default['table_bordercolor'];
  24. $this->Table['cellspacing'] = $default['table_cellspacing'];
  25. $this->Table['cellpadding'] = $default['table_cellpadding'];
  26. $this->Table['style'] = $default['table_style'];
  28. echo "\n\r<TABLE";
  30. foreach($this->table_properties as $key=>$property) {
  32. if (strval($this->Table[$this->table_properties[$key]])!='') {
  34. echo " ".$key."=\"".strval($this->Table[$this->table_properties[$key]])."\"";
  36. }
  38. }
  40. echo ">\n\r";
  41. }
  43. #===============================================================================================
  44. # PRINT CLOSE TABLE
  45. #===============================================================================================
  46. function printCloseTable() {
  48. echo "<TR height=\"0\">\n";
  50. $Active = $this->active_styles;
  51. $Default = $this->default_styles;
  55. for($j=0; $j<$this->range_cols; $j++) {
  58. if (strval($Active['column_width'])=='on') {
  60. $width = $this->Table['ColumnProperties'][$j]['Width'];
  62. if (strval($this->Table['ColumnProperties'][$j]['Width'])=='' && strval($Default['column_width'])!='') {
  64. $width = $Default['column_width'];
  65. }
  66. }
  67. elseif(strval($Default['column_width'])!='') {
  69. $width = $Default['column_width'];
  70. }
  73. // $width = $this->table['ColumnProperties'][$j]['Width'];
  74. // if(!$width) $width = 64;
  76. echo " <TD width=\"".$width."\"></TD>\n";
  77. // style=\"border-bottom: none;border-top: none;border-left: none;border-bottom: right;\"
  79. }
  81. echo "</TR>\n";
  83. echo "</TABLE>\n\r\n\r";
  85. }
  86. #===============================================================================================
  87. # PRINT OPEN TR
  88. #===============================================================================================
  89. function printOpenTR($tr) {
  91. $Active = $this->active_styles;
  92. $Default = $this->default_styles;
  94. if (strval($Active['row_height'])=='on') {
  96. if (strval($tr[$this->tr_properties['height']])=='' && strval($Default['row_height'])!='') {
  98. $tr[$this->tr_properties['height']] = $Default['row_height'];
  99. }
  101. }
  102. elseif(strval($Default['row_height'])!='') {
  104. $tr[$this->tr_properties['height']] = $Default['row_height'];
  105. }
  107. echo "<TR";
  109. foreach($this->tr_properties as $key=>$property) {
  111. if (strval($tr[$this->tr_properties[$key]])!='') {
  113. echo " ".$key."=\"".strval($tr[$this->tr_properties[$key]])."\"";
  115. }
  117. }
  119. echo ">\n\r";
  121. }
  122. #===============================================================================================
  123. # PRINT OPEN TD
  124. #===============================================================================================
  125. function printTD($td) {
  127. $Styles = $this->Styles;
  128. $Active = $this->active_styles;
  129. $Default = $this->default_styles;
  132. echo " <TD";
  134. foreach($this->td_properties as $key=>$property) {
  136. if (strval($td[$this->td_properties[$key]])!='' && $key!='content') {
  138. echo " ".$key."=\"".strval($td[$this->td_properties[$key]])."\"";
  140. }
  142. }
  145. if (strval($Active['text_align'])=='on') {
  147. if (strval($Styles[$td['StyleID']]['Alignment']['Horizontal'])!='') $align = $Styles[$td['StyleID']]['Alignment']['Horizontal'];
  148. elseif(strval($Default['text_align'])!='') $align = strval($Default['text_align']);
  150. if($td['Type']=='Number' && $Active['number_format']=='on' && !$Styles[$td['StyleID']]['Alignment']['Horizontal']) $align = 'right';
  151. }
  152. else {
  154. if(strval($Default['text_align'])!='') $align = strval($Default['text_align']);
  155. if($td['Type']=='Number' && $Active['number_format']=='on') $align = 'right';
  156. }
  157. if ($align) echo " align=\"".$align."\"";
  161. if (strval($Active['text_valign'])=='on') {
  163. if (strval($Styles[$td['StyleID']]['Alignment']['Vertical'])!='') $valign = $Styles[$td['StyleID']]['Alignment']['Vertical'];
  164. elseif(strval($Default['text_valign'])!='') $valign = strval($Default['text_valign']);
  165. }
  166. else {
  168. if(strval($Default['text_valign'])!='') $valign = strval($Default['text_valign']);
  169. }
  170. if ($valign) echo " valign=\"".$valign."\"";
  174. if (strval($Active['bg_color'])=='on') {
  176. if (strval($Styles[$td['StyleID']]['Interior']['Color'])!='') $bg_color = $Styles[$td['StyleID']]['Interior']['Color'];
  177. elseif(strval($Default['bg_color'])!='') $bg_color = strval($Default['bg_color']);
  178. }
  179. else {
  181. if(strval($Default['bg_color'])!='') $bg_color = strval($Default['bg_color']);
  182. }
  183. if ($bg_color) echo " bgColor=\"".$bg_color."\"";
  188. $style = '';
  190. if (strval($Active['font_size'])=='on') {
  192. if (strval($Styles[$td['StyleID']]['Font']['Size'])!='') $font_size = $Styles[$td['StyleID']]['Font']['Size'];
  193. elseif(strval($Default['font_size'])!='') $font_size = strval($Default['font_size']);
  194. }
  195. else {
  197. if(strval($Default['font_size'])!='') $font_size = strval($Default['font_size']);
  198. }
  199. if ($font_size) $style.="font-size: ".$font_size."pt; ";
  203. if (strval($Active['font_family'])=='on') {
  205. if (strval($Styles[$td['StyleID']]['Font']['FontName'])!='') $font_family = $Styles[$td['StyleID']]['Font']['FontName'];
  206. elseif(strval($Default['font_family'])!='') $font_family = strval($Default['font_family']);
  207. }
  208. else {
  209. if(strval($Default['font_family'])!='') $font_family = strval($Default['font_family']);
  210. }
  211. if ($font_family) $style.="font-family: ".$font_family."; ";
  216. if (strval($Active['font_color'])=='on') {
  218. if (strval($Styles[$td['StyleID']]['Font']['Color'])!='') $font_color = $Styles[$td['StyleID']]['Font']['Color'];
  219. elseif(strval($Default['font_color'])!='') $font_color = strval($Default['font_color']);
  220. }
  221. else {
  222. if(strval($Default['font_color'])!='') $font_color = strval($Default['font_color']);
  223. }
  224. if ($font_color) $style.="color: ".$font_color."; ";
  229. if (strval($Active['font_bold'])=='on') {
  231. if (strval($Styles[$td['StyleID']]['Font']['Bold'])!='') $font_bold = $Styles[$td['StyleID']]['Font']['Bold'];
  232. elseif(strval($Default['font_bold'])!='') $font_bold = strval($Default['font_bold']);
  233. }
  234. else {
  235. if(strval($Default['font_bold'])!='') $font_bold = strval($Default['font_bold']);
  236. }
  237. if ($font_bold) $style.="font-weight: bold; ";
  242. if (strval($Active['font_italic'])=='on') {
  244. if (strval($Styles[$td['StyleID']]['Font']['Italic'])!='') $font_italic = $Styles[$td['StyleID']]['Font']['Italic'];
  245. elseif(strval($Default['font_italic'])!='') $font_italic = strval($Default['font_italic']);
  246. }
  247. else {
  248. if(strval($Default['font_italic'])!='') $font_italic = strval($Default['font_italic']);
  249. }
  250. if ($font_italic) $style.="font-style: italic; ";
  254. if (strval($Active['font_underline'])=='on') {
  256. if (strval($Styles[$td['StyleID']]['Font']['Underline'])!='') $font_underline = $Styles[$td['StyleID']]['Font']['Underline'];
  257. elseif(strval($Default['font_underline'])!='') $font_underline = strval($Default['font_underline']);
  258. }
  259. else {
  260. if(strval($Default['font_underline'])!='') $font_underline = strval($Default['font_underline']);
  261. }
  262. if ($font_underline) $style.="text-decoration: underline; ";
  265. if ($style) echo " style=\"".$style."\"";
  268. echo ">";
  269. if ($td[$this->td_properties['content']]) echo $td[$this->td_properties['content']];
  270. else echo '&nbsp;';
  271. echo "</TD>\n\r";
  273. }
  277. }
  279. ?>
comments powered by Disqus