Tad 教材網 - 線上書籍

:::

\[1102\] PHP全端開發
================

1. 表格常用樣式設定 
  ```php
  // 表格樣式設定
  $tableStyle = ['borderColor' => '000000', 'borderSize' => 6, 'cellMargin' => 80];
  // 橫列樣式
  $rowStyle = ['cantSplit' => true, 'tblHeader' => true];
  // 儲存格標題文字樣式設定
  $headStyle = ['bold' => true];
  // 儲存格內文文字樣式設定
  $cellStyle = ['valign' => 'center'];
  ```
2. 建立表格 
  ```php
  $table = $section->addTable($tableStyle);
  ```
3. 建立一個橫列（參數均可省略） 
  ```php
  $table->addRow($height, $rowStyle);
  ```
4. 建立儲存格 
  ```php
  $table->addCell($width, $cellStyle)->addText('內容', $fontStyle, $paraStyle);
  ```
5. 合併儲存格（套用不同儲存格樣式即可達成） 
  ```php
  $cellRowSpan  = array('vMerge' => 'restart'); //垂直合併
  $cellContinue = array('vMerge' => 'continue'); //略過
  $cellColSpan  = array('gridSpan' => 2); //水平合併
  ```
6. 完成 `word_signup.php` 如： 
  ```php
  <?php
  use PhpOffice\PhpWord\IOFactory;
  use PhpOffice\PhpWord\PhpWord;
  use PhpOffice\PhpWord\Shared\Converter;
  use Xmf\Request;
  use XoopsModules\Tadtools\TadDataCenter;
  use XoopsModules\Tad_signup\Tad_signup_actions;
  use XoopsModules\Tad_signup\Tad_signup_data;
  /*-----------引入檔案區--------------*/
  require_once __DIR__ . '/header.php';
  
  if (!$_SESSION['can_add']) {
      redirect_header($_SERVER['PHP_SELF'], 3, "您沒有權限使用此功能");
  }
  
  $id = Request::getInt('id');
  $action = Tad_signup_actions::get($id);
  
  require_once XOOPS_ROOT_PATH . '/modules/tadtools/vendor/autoload.php';
  $phpWord = new PhpWord();
  $phpWord->setDefaultFontName('標楷體'); //設定預設字型
  $phpWord->setDefaultFontSize(12); //設定預設字型大小
  // $header = $section->addHeader(); //頁首
  // $footer = $section->addFooter(); //頁尾
  // $footer->addPreserveText('{PAGE} / {NUMPAGES}', $fontStyle, $paraStyle);
  
  // 標題文字樣式設定
  $Title1Style = ['color' => '000000', 'size' => 18, 'bold' => true];
  $Title2Style = ['color' => '000000', 'size' => 16, 'bold' => true];
  // 內文文字設定
  $fontStyle = ['color' => '000000', 'size' => 14, 'bold' => false];
  // 置中段落樣式設定
  $paraStyle = ['align' => 'center', 'valign' => 'center'];
  // 靠左段落樣式設定
  $left_paraStyle = ['align' => 'left', 'valign' => 'center'];
  // 靠右段落樣式設定
  $right_paraStyle = ['align' => 'right', 'valign' => 'center'];
  // 表格樣式設定
  $tableStyle = ['borderColor' => '000000', 'borderSize' => 6, 'cellMargin' => 80];
  // 橫列樣式
  $rowStyle = ['cantSplit' => true, 'tblHeader' => true];
  // 儲存格標題文字樣式設定
  $headStyle = ['bold' => true];
  // 儲存格內文段落樣式設定
  $cellStyle = ['valign' => 'center'];
  
  $phpWord->addTitleStyle(1, $Title1Style, $paraStyle); //設定標題1樣式
  $phpWord->addTitleStyle(2, $Title2Style, $paraStyle); //設定標題1樣式
  
  //產生內容
  $section = $phpWord->addSection();
  $sectionStyle = $section->getStyle();
  $sectionStyle->setMarginTop(Converter::cmToTwip(2.5));
  $sectionStyle->setMarginLeft(Converter::cmToTwip(2.2));
  $sectionStyle->setMarginRight(Converter::cmToTwip(2.2));
  
  $title = "{$action['title']}簽到表";
  
  $section->addTitle($title, 1); //新增標題
  $section->addTextBreak(1);
  $section->addText("活動日期：{$action['action_date']}", $fontStyle, $left_paraStyle);
  $section->addTextBreak(1);
  
  $TadDataCenter = new TadDataCenter('tad_signup');
  $TadDataCenter->set_col('pdf_setup_id', $id);
  $pdf_setup_col = $TadDataCenter->getData('pdf_setup_col', 0);
  $col_arr = explode(',', $pdf_setup_col);
  $col_count = count($col_arr);
  if (empty($col_count)) {
      $col_count = 1;
  }
  
  $w = 10.6 / $col_count;
  
  $table = $section->addTable($tableStyle);
  $table->addRow();
  $table->addCell(Converter::cmToTwip(1.5), $cellStyle)->addText('編號', $fontStyle, $paraStyle);
  foreach ($col_arr as $col_name) {
      $table->addCell(Converter::cmToTwip($w), $cellStyle)->addText($col_name, $fontStyle, $paraStyle);
  }
  $table->addCell(Converter::cmToTwip(4.5), $cellStyle)->addText('簽名', $fontStyle, $paraStyle);
  
  $signup = Tad_signup_data::get_all($action['id'], null, true, true);
  $i = 1;
  foreach ($signup as $signup_data) {
      $table->addRow();
      $table->addCell(Converter::cmToTwip(1.5), $cellStyle)->addText($i, $fontStyle, $paraStyle);
      foreach ($col_arr as $col_name) {
          $table->addCell(Converter::cmToTwip($w), $cellStyle)->addText(implode('、', $signup_data['tdc'][$col_name]), $fontStyle, $paraStyle);
      }
  
      $table->addCell(Converter::cmToTwip(4.5), $cellStyle)->addText('', $fontStyle, $paraStyle);
      $i++;
  }
  
  $objWriter = IOFactory::createWriter($phpWord, 'Word2007');
  header('Content-Type: application/vnd.ms-word');
  header("Content-Disposition: attachment;filename={$title}.docx");
  header('Cache-Control: max-age=0');
  $objWriter->save('php://output');
  
  ```
 
[![](https://www.tad0616.net/uploads/tad_book3/image/48/to_github.png)<span class="sr-only">link to https://github.com/tadlearn/tad\_signup/commit/5257b1d9e2870da77abefd7a9f35d9903be04624 \\</span>](https://github.com/tadlearn/tad_signup/commit/5257b1d9e2870da77abefd7a9f35d9903be04624)

:::