diff options
| author | emkael <emkael@tlen.pl> | 2020-05-05 14:25:42 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2020-05-05 14:25:42 +0200 |
| commit | 62827e6cf470449c117624058fb36ad94804bcc0 (patch) | |
| tree | 10cd1e4d36c34b694acfadaa69fc7f6ae2b1eabd /plugins/Timetrackingeditor/Html.php | |
| parent | 7b66ddf2e4fbdb837e78d8b7dbaa9fc38391bc32 (diff) | |
Diffstat (limited to 'plugins/Timetrackingeditor/Html.php')
| -rw-r--r-- | plugins/Timetrackingeditor/Html.php | 182 |
1 files changed, 182 insertions, 0 deletions
diff --git a/plugins/Timetrackingeditor/Html.php b/plugins/Timetrackingeditor/Html.php new file mode 100644 index 00000000..eb3e1fa5 --- /dev/null +++ b/plugins/Timetrackingeditor/Html.php @@ -0,0 +1,182 @@ +<?php + +namespace Kanboard\Plugin\Timetrackingeditor; + +use SplFileObject; + +/** + * HTML Writer + * + * Allows exporting Data as HTML file. + * In contrast to CSV this allows clean interpration of HTML Tags by Excel + * + * @author Thomas Stinner + */ +class Html +{ + /** + * CSV/SQL columns + * + * @access private + * @var array + */ + private $columns = array(); + + /** + * Constructor + * + * @access public + */ + public function __construct() + { + } + + /** + * Check boolean field value + * + * @static + * @access public + * @param mixed $value + * @return int + */ + public static function getBooleanValue($value) + { + if (! empty($value)) { + $value = trim(strtolower($value)); + return $value === '1' || $value{0} === 't' || $value{0} === 'y' ? 1 : 0; + } + + return 0; + } + + /** + * Output CSV file to standard output + * + * @static + * @access public + * @param array $rows + */ + public static function output(array $rows) + { + $html= new static; + $html->write('php://output', $rows); + } + + /** + * Define column mapping between CSV and SQL columns + * + * @access public + * @param array $columns + * @return Csv + */ + public function setColumnMapping(array $columns) + { + $this->columns = $columns; + return $this; + } + + /** + * Write HTML file + * + * @access public + * @param string $filename + * @param array $rows + * @return Html + */ + public function write($filename, array $rows) + { + + $fp = fopen($filename, 'w'); + + if (is_resource($fp)) { + $types = array_shift($rows); + + $this->writeHeader($fp); + foreach ($rows as $row) { + $this->writeRow($fp, $types, $row); + } + $this->writeFooter($fp); + fclose($fp); + } + + return $this; + } + + /** + * write a HTML header + * + * @param $fp filepointer + */ + private function writeHeader($fp) + { + fwrite($fp,"<HTML><HEAD><STYLE>\n"); + fwrite($fp,"b,p {mso-data-placement: same-cell; }\n"); + fwrite($fp,".num { mso-number-format:General; }\n"); + fwrite($fp,".dec { mso-number-format: 0,00; }\n"); + fwrite($fp,".text { mso-number-format:\"\\@\"; }\n"); + fwrite($fp,".date { mso-number-format:\"Short Date\"; }\n"); + fwrite($fp,"</STYLE></HEAD>\n"); + fwrite($fp,"<BODY><TABLE>"); + + } + + /** + * write a single row + * + * @param fp filepointer + * @param $row row + */ + private function writeRow($fp, array $types, array $row) + { + fwrite($fp,"<tr>"); + foreach ($row as $key => $value) { + fwrite($fp,"<td class='".$types[$key]."'>".$value."</td>"); + } + fwrite($fp,"</tr>\n"); + } + + /** + * write a HTML footer + */ + private function writeFooter($fp) + { + fwrite($fp,"</TABLE></BODY></HTML>"); + } + + /** + * Associate columns header with row values + * + * @access private + * @param array $row + * @return array + */ + private function associateColumns(array $row) + { + $line = array(); + $index = 0; + + foreach ($this->columns as $sql_name => $csv_name) { + if (isset($row[$index])) { + $line[$sql_name] = $row[$index]; + } else { + $line[$sql_name] = ''; + } + + $index++; + } + + return $line; + } + + /** + * Filter empty rows + * + * @access private + * @param array $row + * @return array + */ + private function filterRow(array $row) + { + return array_filter($row); + } +} |