ThinkPHP下实现Word导出

最新推荐文章于 2025-05-18 14:13:58 发布
最新推荐文章于 2025-05-18 14:13:58 发布
阅读量6.3k 收藏 4
点赞数 1
CC 4.0 BY-SA版权
分类专栏： PHP web开发 MySQL 文章标签： thinkphp 函数 word 遍历
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/ZDX_Y/article/details/59166118
在台网项目中，为满足震源回波信息导出需求，本文档介绍如何利用ThinkPHP框架处理多维数组，将查询到的台站及测项信息填充到预先设计的Word模板中，提高导出效率。通过调整查询和模板绘制策略，避免了复杂的数据匹配，实现了高效的数据写入。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

台网项目中有一个需求是点选震源返回范围内台站的各测项信息，思路是先把Word模板绘制好，然后-查询台站信息写入模板中。Word导出效果图如下。
这里写图片描述
实现这个模块的困难在于对多位数组的操作。在查询完点选范围内的所有台站信息后，在根据这些信息逐一去查询测项名称和分数信息。最开始由于思维局限，考虑的是把逐一查询的信息和台站信息匹配存放在同一一个数组中，然后单独在绘制word模板函数中再把它遍历出来。先不说这本身已经把效率变得很慢，其次是这个查询出结果的数组已经是多于三维的数组了，无法把需要的信息组合在一起。
思路重新捋一捋后，换了一种办法，是先把台站基本信息返回给Word模板绘制函数，然后再Word模板函数中逐一查询得分信息，直接绘制在表格中。
下面是代码：

<?php
/*
**@function Out put the word into Public/Word
**@need PHPWord Class in Include/Library/Org/Util/PHPWord
**@author zdx
**@date the last modified time 2017-2-20
**@bug fixs by zdx 2017-2-22 除去导出中出现的辅助测项和应实时运行仪器数与实际值不匹配
*/
namespace Home\Controller;
use Think\Controller;
ini_set('memory_limit','1024M');
ini_set('max_execution_time','86400');
class OutWordController extends AuthController{
    public function index(){
        header('Content-Type:text/html; charset=utf8');
        import('Org.Util.PHPWord');
        import('Org.Util.PHPWord.IOFactory');
        // New Word Document
        if(IS_POST){
        $param_latitude=I('post.lat','','htmlspecialchars');
        $param_longitude=I('post.lng','','htmlspecialchars');
        $param_distance=I('post.radius','','htmlspecialchars');
        }
        $distance=$param_distance*100;
//$PHPWord = new PHPWord();
$PHPWord = new \PHPWord();
// New portrait section
$section = $PHPWord->createSection();
//Get time stamp
$year = date("Y");
$month = date("m");
$day = date("d");
$hour = date("G");
$minute = date("i");

// Add header
$header = $section->createHeader();
$table = $header->addTable();
$table->addRow();
$table->addCell(4500)->addText($year.'年'.$month.'月'.$day.'日');
$table->addCell(4500)->addText('测试版',null,array('align'=>'right'));

// Add listitem elements
$PHPWord->addFontStyle('myOwnStyle', array('name'=>'FangSong', 'size'=>'14'));
$PHPWord->addParagraphStyle('P-Style', array('spaceAfter'=>95));
$listStyle = array('listType'=>\PHPWord_Style_ListItem::TYPE_NUMBER_NESTED);
$section->addListItem('数据质量评估情况', 0, 'myOwnStyle', $listStyle, 'P-Style');

// Prepare the score from SearchAllItems()
$score_count =$this->SearchAllItems();
$HighScore = $score_count['xb_HighScore']+$score_count['lt_HighScore']+$score_count['dc_HighScore']+$score_count['ddc_HighScore']+$score_count['ddz_HighScore'];
$MediumScore = $score_count['xb_MediumScore']+$score_count['lt_MediumScore']+$score_count['dc_MediumScore']+$score_count['ddc_MediumScore']+$score_count['ddz_MediumScore'];
$LowScore = $score_count['xb_LowScore']+$score_count['lt_LowScore']+$score_count['dc_LowScore']+$score_count['ddc_LowScore']+$score_count['ddz_LowScore'];
$FlunkScore = $score_count['xb_FlunkScore']+$score_count['lt_FlunkScore']+$score_count['dc_FlunkScore']+$score_count['ddc_FlunkScore']+$score_count['ddz_FlunkScore'];
$electHighScore = $score_count['dc_HighScore']+$score_count['ddc_HighScore']+$score_count['ddz_HighScore'];
$electMediumScore = $score_count['dc_MediumScore']+$score_count['ddc_MediumScore']+$score_count['ddz_MediumScore'];
$electLowScore = $score_count['dc_LowScore']+$score_count['ddc_LowScore']+$score_count['ddz_LowScore'];
$electFlunkScore = $score_count['dc_FlunkScore']+$score_count['ddc_FlunkScore']+$score_count['ddz_FlunkScore'];
$ele_shouldcounts = $score_count['ddz_shouldRuning']+$score_count['ddc_shouldRuning']+$score_count['dc_shouldRuning']+$electHighScore+$electMediumScore+$electLowScore+$electFlunkScore;
$xb_shouldcounts = $score_count['xb_shouldRuning']+$score_count['xb_HighScore']+$score_count['xb_MediumScore']+$score_count['xb_LowScore']+$score_count['xb_FlunkScore'];
$lt_shouldcounts = $score_count['lt_shouldRuning']+$score_count['lt_HighScore']+$score_count['lt_MediumScore']+$score_count['lt_LowScore']+$score_count['lt_FlunkScore'];
$ItemCount = $ele_shouldcounts+$xb_shouldcounts+$lt_shouldcounts;
//Null assignment of data to zero
if ($score_count['xb_HighScore']==null) {
    $score_count['xb_HighScore'] = 0;
}
if ($score_count['xb_MediumScore']==null) {
    $score_count['xb_MediumScore'] = 0;
}
if ($score_count['xb_LowScore']==null ){
    $score_count['xb_LowScore'] = 0;
}
if ($score_count['xb_FlunkScore']==null ){
    $score_count['xb_FlunkScore'] = 0;
}
if ($score_count['lt_HighScore']==null) {
    $score_count['lt_HighScore'] = 0;
}
if ($score_count['lt_MediumScore']==null) {
   $score_count['lt_MediumScore'] = 0;
}
if ($score_count['lt_LowScore']==null) {
    $score_count['lt_LowScore'] = 0;
}
if ($score_count['lt_FlunkScore']==null) {
    $score_count['lt_FlunkScore'] = 0;
}
// Add the main text elements
$PHPWord->addFontStyle('rmStyle', array('bold'=>false, 'name'=>'FangSong', 'size'=>'14'));
$PHPWord->addParagraphStyle('pmStyle', array('align'=>'left','spacing'=>150, 'spaceAfter'=>100,'spaceBefore'=>50));
$section->addText(' 震中距离'.$distance.'km范围内，共检测到'.$ItemCount.'台项主观测数据,检测预报效能得分为90~100的有'.$HighScore.'项，75~90的有'.$MediumScore.'项，60~75的有'.$LowScore.'项,60分以下的有'.$FlunkScore.'项(附件1)。', 'rmStyle', 'pmStyle');
$section->addTextBreak(2);

// Define the  first table style arrays
$styleTable = array('alignMent' => 'center','borderTopSize'=>16, 'borderTopColor'=>'434343','borderBottomSize'=>16,'borderBottomColor'=>'434343', 'cellMargin'=>80,'borderLeftColor'=>'ffffff','borderRightColor'=>'ffffff','borderInsideVColor'=>'ffffff');
$styleFirstRow = array('borderBottomSize'=>16, 'borderBottomColor'=>'434343', 'bgColor'=>'ffffff');

// Define cell style arrays
$styleCell = array('valign'=>'center');
$styleCellBTLR = array('valign'=>'center', 'textDirection'=>\PHPWord_Style_Cell::TEXT_DIR_BTLR);

// Define font style for first row
$fontStyle = array('bold'=>true, 'align'=>'center');
$PHPWord->addParagraphStyle('pStyle', array('bold'=>true,'align'=>'center'));
// Add the  first table style
$PHPWord->addTableStyle('myOwnTableStyle', $styleTable, $styleFirstRow);

// Add table
$table = $section->addTable('myOwnTableStyle');

// Add row
$table->addRow(450);

// Add cells
$table->addCell(2100, $styleCell)->addText('监测预报效能自动评估得分', $fontStyle,'pStyle');
$table->addCell(2100, $styleCell)->addText('形变学科', $fontStyle,'pStyle');
$table->addCell(2100, $styleCell)->addText('电磁学科', $fontStyle,'pStyle');
$table->addCell(2100, $styleCell)->addText('流体学科', $fontStyle,'pStyle');


// Add more rows / cells
$styleCellColor = array('bgColor'=>'cccccc');
    $table->addRow();
    $table->addCell(2100,$styleCellColor)->addText("90-100",null,array('align'=>'center'));
    $table->addCell(2100,$styleCellColor)->addText($score_count['xb_HighScore'].'('.$xb_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100,$styleCellColor)->addText($electHighScore.'('.$ele_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100,$styleCellColor)->addText($score_count['lt_HighScore'].'('.$lt_shouldcounts.')',null,array('align'=>'center'));
    $table->addRow();
    $table->addCell(2100)->addText("75-90",null,array('align'=>'center'));
    $table->addCell(2100)->addText($score_count['xb_MediumScore'].'('.$xb_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100)->addText($electMediumScore.'('.$ele_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100)->addText($score_count['lt_MediumScore'].'('.$lt_shouldcounts.')',null,array('align'=>'center'));
    $table->addRow();
    $table->addCell(2100,$styleCellColor)->addText("60-75",null,array('align'=>'center'));
    $table->addCell(2100,$styleCellColor)->addText($score_count['xb_LowScore'].'('.$xb_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100,$styleCellColor)->addText($electLowScore.'('.$ele_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100,$styleCellColor)->addText($score_count['lt_LowScore'].'('.$lt_shouldcounts.')',null,array('align'=>'center'));
    $table->addRow();
    $table->addCell(2100)->addText("<60",null,array('align'=>'center'));
    $table->addCell(2100)->addText($score_count['xb_FlunkScore'].'('.$xb_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100)->addText($electFlunkScore.'('.$ele_shouldcounts.')',null,array('align'=>'center'));
    $table->addCell(2100)->addText($score_count['lt_FlunkScore'].'('.$lt_shouldcounts.')',null,array('align'=>'center'));

//Add the second conent
$PHPWord->addFontStyle('r2Style', array('bold'=>false, 'name'=>'FangSong', 'size'=>'10.5'));
$PHPWord->addParagraphStyle('pStyle', array('align'=>'center', 'spaceAfter'=>100));
$section->addText('注：括号内为应实时运行的仪器数，括号外为实时运行的仪器数', 'r2Style', 'pStyle');
$section->addTextBreak(2);

//Add the third conent
$PHPWord->addFontStyle('r3Style', array('bold'=>false, 'name'=>'FangSong', 'size'=>'14'));
$PHPWord->addParagraphStyle('pStyle', array('align'=>'center', 'spaceAfter'=>100));
$section->addText('附表：'.$distance.'km范围内台项监测预报效能自动评估结果（'.date("Y-m-d").'）', 'r3Style', 'pStyle');
$section->addTextBreak(0);

// Define the second table style arrays
$styleTable = array('alignMent' => 'center','borderTopSize'=>16, 'borderTopColor'=>'434343','borderBottomSize'=>16,'borderBottomColor'=>'434343', 'cellMargin'=>80,'borderLeftColor'=>'ffffff','borderRightColor'=>'ffffff','borderInsideVColor'=>'ffffff');
$styleFirstRow = array('borderBottomSize'=>16, 'borderBottomColor'=>'434343', 'bgColor'=>'ffffff');

$styleCell = array('valign'=>'center');
$styleCellBTLR = array('valign'=>'center', 'textDirection'=>\PHPWord_Style_Cell::TEXT_DIR_BTLR);

$fontStyle = array('bold'=>true, 'align'=>'center');
$PHPWord->addParagraphStyle('pStyle', array('bold'=>true,'align'=>'center'));

$PHPWord->addTableStyle('myOwnTableStyle', $styleTable, $styleFirstRow);

$table = $section->addTable('myOwnTableStyle');

$table->addRow(600);

$table->addCell(1000, $styleCell)->addText('台站代码', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('台站名', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('经度', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('纬度', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('震中距(km)', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('测项代码', $fontStyle,'pStyle');
$table->addCell(6000, $styleCell)->addText('测项名称', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('观测系统评分', $fontStyle,'pStyle');
$table->addCell(4000, $styleCell)->addText('数据质量得分', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('跟踪应用得分', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('总分', $fontStyle,'pStyle');
$table->addCell(1000, $styleCell)->addText('备注', $fontStyle,'pStyle');
$item_stations = $this->return_eachitems();
for ($i=0; $i <count($item_stations) ; $i++) { 
    # code...
    for ($j=0; $j <count($item_stations[$i]) ; $j++) { 
        //获得距离
        $distance = $this->getDistance($item_stations[$i][$j]['LATITUDE'], $item_stations[$i][$j]['LONGITUDE'], $param_latitude,$param_longitude);
        if (substr($item_stations[$i][$j]['ITEMID'], 0,1)=='2') {
            $sub='_XB_';
        }
        elseif(substr($item_stations[$i][$j]['ITEMID'], 0,1)=='4') {
            $sub='_LT_';
        }
        elseif(substr($item_stations[$i][$j]['ITEMID'], 0,2)=='31') {
            $sub='_DC_';
        }
        elseif(substr($item_stations[$i][$j]['ITEMID'], 0,2)=='32') {
            $sub='_DDZ_';
        }
        elseif(substr($item_stations[$i][$j]['ITEMID'], 0,2)=='34') {
            $sub='_DDC_';
        }
        elseif(substr($item_stations[$i][$j]['ITEMID'], 0,2)=='91') {
            $sub='_FZ_';
        }
        $item_info=M('','','CONFIG_JC_MANAGEGRADE');
        switch ($sub) {
                    case '_XB_':
                        $eachItems_sql ='SELECT DISTINCT a.ITEMSNAME,a.SYS_EVALUATION,a.DATA_EVALUATION,a.TRA_EVALUATION,a.SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_XB_FINALSCORE a WHERE a.ITEMSID = '.'\''.$item_stations[$i][$j]['ITEMID'].'\''.'  AND a.POINTID='.'\''.$item_stations[$i][$j]['POINTID'].'\''.' AND a.STATIONID='.'\''.$item_stations[$i][$j]['STATIONID'].'\''.' AND ISLASTEST = 1';
                        $items_XB = $item_info->query($eachItems_sql);
                        $table->addRow();
                        $style = array('bgColor'=>'cccccc');
                        $styleCellColor = ($j % 2 == 0) ? $style : '';
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONID'],null,array('align'=>'center'));
                        $table->addCell(3000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LATITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LONGITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($distance,null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['ITEMID'].$item_stations[$i][$j]['POINTID'],null,array('align'=>'center'));
                        $table->addCell(4000,$styleCellColor)->addText($items_XB[0]['ITEMSNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_XB[0]['SYS_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_XB[0]['DATA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_XB[0]['TRA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_XB[0]['SUM_GRADE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText(" ",null,array('align'=>'center'));
                        break;
                    case '_LT_':
                        $eachItems_sql='SELECT DISTINCT a.ITEMSNAME,a.SYS_EVALUATION,a.DATA_EVALUATION,a.TRA_EVALUATION,a.SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_LT_FINALSCORE a WHERE a.ITEMID = '.'\''.$item_stations[$i][$j]['ITEMID'].'\''.'  AND a.POINTID='.'\''.$item_stations[$i][$j]['POINTID'].'\''.' AND a.STATIONID='.'\''.$item_stations[$i][$j]['STATIONID'].'\''.' AND ISLASTEST = 1 ';
                        $items_LT = $item_info->query($eachItems_sql);
                        $table->addRow();
                        $style = array('bgColor'=>'cccccc');
                        $styleCellColor = ($j % 2 == 0) ? $style : '';
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONID'],null,array('align'=>'center'));
                        $table->addCell(3000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LATITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LONGITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($distance,null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['ITEMID'].$item_stations[$i][$j]['POINTID'],null,array('align'=>'center'));
                        $table->addCell(4000,$styleCellColor)->addText($items_LT[0]['ITEMSNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_LT[0]['SYS_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_LT[0]['DATA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_LT[0]['TRA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_LT[0]['SUM_GRADE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText(" ",null,array('align'=>'center'));
                        break;
                    case '_DC_':
                        $eachItems_sql='SELECT DISTINCT a.ITEMSNAME,a.SYS_EVALUATION,a.DATA_EVALUATION,a.TRA_EVALUATION,a.SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_DC_FINALSCORE a WHERE a.ITEMID =  '.'\''.$item_stations[$i][$j]['ITEMID'].'\''.'  AND a.POINTID='.'\''.$item_stations[$i][$j]['POINTID'].'\''.' AND a.STATIONID='.'\''.$item_stations[$i][$j]['STATIONID'].'\''.' AND ISLASTEST = 1 ';
                        $items_DC = $item_info->query($eachItems_sql);
                        $table->addRow();
                        $style = array('bgColor'=>'cccccc');
                        $styleCellColor = ($j % 2 == 0) ? $style : '';
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONID'],null,array('align'=>'center'));
                        $table->addCell(3000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LATITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LONGITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($distance,null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['ITEMID'].$item_stations[$i][$j]['POINTID'],null,array('align'=>'center'));
                        $table->addCell(4000,$styleCellColor)->addText($items_DC[0]['ITEMSNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DC[0]['SYS_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DC[0]['DATA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DC[0]['TRA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DC[0]['SUM_GRADE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText(" ",null,array('align'=>'center'));
                        break;
                    case '_DDZ_':
                        $eachItems_sql='SELECT DISTINCT a.ITEMSNAME,a.SYS_EVALUATION,a.DATA_EVALUATION,a.TRA_EVALUATION,a.SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_DDZ_FINALSCORE a WHERE a.ITEMID = '.'\''.$item_stations[$i][$j]['ITEMID'].'\''.'  AND a.POINTID='.'\''.$item_stations[$i][$j]['POINTID'].'\''.' AND a.STATIONID='.'\''.$item_stations[$i][$j]['STATIONID'].'\''.' AND ISLASTEST = 1 ';
                        $items_DDZ = $item_info->query($eachItems_sql);
                        $table->addRow();
                        $style = array('bgColor'=>'cccccc');
                        $styleCellColor = ($j % 2 == 0) ? $style : '';
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONID'],null,array('align'=>'center'));
                        $table->addCell(3000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LATITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LONGITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($distance,null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['ITEMID'].$item_stations[$i][$j]['POINTID'],null,array('align'=>'center'));
                        $table->addCell(4000,$styleCellColor)->addText($items_DDZ[0]['ITEMSNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDZ[0]['SYS_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDZ[0]['DATA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDZ[0]['TRA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDZ[0]['SUM_GRADE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText(" ",null,array('align'=>'center'));
                        break;
                    case '_DDC_':
                        $eachItems_sql='SELECT DISTINCT a.ITEMSNAME,a.SYS_EVALUATION,a.DATA_EVALUATION,a.TRA_EVALUATION,a.SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_DDC_FINALSCORE a WHERE a.ITEMID = '.'\''.$item_stations[$i][$j]['ITEMID'].'\''.'  AND a.POINTID='.'\''.$item_stations[$i][$j]['POINTID'].'\''.' AND a.STATIONID='.'\''.$item_stations[$i][$j]['STATIONID'].'\''.' AND ISLASTEST = 1';                        
                        $items_DDC = $item_info->query($eachItems_sql);
                        $table->addRow();
                        $style = array('bgColor'=>'cccccc');
                        $styleCellColor = ($j % 2 == 0) ? $style : '';
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONID'],null,array('align'=>'center'));
                        $table->addCell(3000,$styleCellColor)->addText($item_stations[$i][$j]['STATIONNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LATITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['LONGITUDE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($distance,null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($item_stations[$i][$j]['ITEMID'].$item_stations[$i][$j]['POINTID'],null,array('align'=>'center'));
                        $table->addCell(4000,$styleCellColor)->addText($items_DDC[0]['ITEMSNAME'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDC[0]['SYS_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDC[0]['DATA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDC[0]['TRA_EVALUATION'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText($items_DDC[0]['SUM_GRADE'],null,array('align'=>'center'));
                        $table->addCell(1000,$styleCellColor)->addText(" ",null,array('align'=>'center'));
                        break;
                    case '_FZ_':

                        break;
                }

    }

    }
$section->addTextBreak(2);

//Add the fourth conent
$PHPWord->addFontStyle('r4Style', array('bold'=>false, 'name'=>'FangSong', 'size'=>'14'));
$PHPWord->addParagraphStyle('p4Style', array('align'=>'left', 'spaceAfter'=>100));
$section->addText('空间展示功能', 'r4Style', 'p4Style');
$section->addTextBreak(0);  

// Save File
$objWriter = \PHPWord_IOFactory::createWriter($PHPWord, 'Word2007');
        $date = date('Ymdhis');
        $stationID =$this->SearchCenterStation();
        $savefile = './public/Word/'.$date.'.docx';
        $objWriter->save($savefile);
        echo $savefile;

    }

    /*
    **Query all stations in the 500km range
    **@param $lat $lon
    **@author zdx
    **@date 2017-2-18
    */
    public function SearchAllStations($lat,$lon,$dis){
        //$lat=39.92;
        //$lon=116;
        $mode=M('','','CONFIG_QZDATA');
        $sql="select STATIONID from QZDATA.QZ_DICT_STATIONS where latitude > '".$lat."'-'".$dis."' and latitude < '".$lat."'+'".$dis."' and longitude > '".$lon."'-'".$dis."' and longitude < '".$lon."'+'".$dis."' order by ACOS(SIN(('".$lat."' * 3.1415) / 180 ) *SIN((latitude * 3.1415) / 180 ) +COS(('".$lat."' * 3.1415) / 180 ) * COS((latitude * 3.1415) / 180 ) *COS(('".$lon."'* 3.1415) / 180 - (longitude * 3.1415) / 180 ) ) * 6380";       
        //Check out all stations
        $result = $mode->query($sql);
        //Number of stations
        $station_counts = count($result);
        return $result;
    }
    /*
    **The query returns to the main items grades 
    */
    public function SearchAllItems(){
            //Returns a fractional array
            $score_count = array();
            //Define the number of the main test items
            $item_counts = 0;
            //Get the station within the range
        header("Content-Type: text/html; charset=utf-8");
        if(IS_POST){
        $param_latitude=I('post.lat','','htmlspecialchars');
        $param_longitude=I('post.lng','','htmlspecialchars');
        $param_distance=I('post.radius','','htmlspecialchars');
        }

            $result = $this->SearchAllStations($param_latitude,$param_longitude,$param_distance);

            //Traverse the range of stations ID
            for ($i=0; $i <count($result) ; $i++) { 
            $mode=M('','','CONFIG_QZDATA');
            $item_sql="select distinct a.stationid, a.stationname,b.ITEMID,b.POINTID from qzdata.qz_dict_stations a,qzdata.qz_dict_stationitems b where a.stationid=b.stationid and a.STATIONID='".$result[$i]['STATIONID']."'";
            //Check out the main items in the range station
            $item_result=$mode->query($item_sql);

            /*This cycle is to add up the number of points in each subject
             according to the main items in the range of stations*/
            for ($j=0; $j <count($item_result) ; $j++) { 
                $yy++;
                $stationid=$item_result[$j][STATIONID];
                $itemid=$item_result[$j][ITEMID];
                $pointid=$item_result[$j][POINTID];
                $item_grade=M('','','CONFIG_JC_MANAGEGRADE');
                if (substr($itemid, 0,1)=='2') {
                    $sub='_XB_';
                }
                if (substr($itemid, 0,1)=='4') {
                    $sub='_LT_';
                }
                if (substr($itemid, 0,2)=='31') {
                    $sub='_DC_';
                }
                if (substr($itemid, 0,2)=='32') {
                    $sub='_DDZ_';
                }
                if (substr($itemid, 0,2)=='34') {
                    $sub='_DDC_';
                }
                if (substr($itemid, 0,2)=='91') {
                    $sub='_FZ_';
                }
                switch ($sub) {
                    case '_XB_':
                        $score_sql="SELECT DISTINCT SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_XB_FINALSCORE WHERE ITEMSID = '".$itemid."'  AND POINTID='".$pointid."' AND STATIONID='".$stationid."' AND ISLASTEST = 1";
                        $grade = $item_grade->query($score_sql);
                        if ($grade[0][SUM_GRADE]>=90&&$grade[0][SUM_GRADE]<=100) {
                            $xb_HighScore++;
                        }elseif ($grade[0][SUM_GRADE]>0&&$grade[0][SUM_GRADE]<60) {
                            $xb_FlunkScore++;
                        }elseif ($grade[0][SUM_GRADE]>=60&&$grade[0][SUM_GRADE]<75) {
                            $xb_LowScore++;
                        }elseif ($grade[0][SUM_GRADE]>=75&&$grade[0][SUM_GRADE]<90) {
                            $xb_MediumScore++;
                        }elseif ($grade[0][SUM_GRADE]<=0||$grade[0][SUM_GRADE]>100||$grade[0][SUM_GRADE]==null) {
                            $xb_shouldRuning++;
                        }
                        break;

                    case '_LT_':
                        $score_sql="SELECT DISTINCT SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_LT_FINALSCORE WHERE ITEMID = '".$itemid."'  AND POINTID='".$pointid."' AND STATIONID='".$stationid."' AND ISLASTEST = 1";
                        //var_dump($score_sql);
                        $grade = $item_grade->query($score_sql);
                        //var_dump($grade[0][SUM_GRADE]);
                        if ($grade[0][SUM_GRADE]>=90&&$grade[0][SUM_GRADE]<=100) {
                            $lt_HighScore++;
                        }elseif ($grade[0][SUM_GRADE]>0&&$grade[0][SUM_GRADE]<60) {
                            $lt_FlunkScore++;
                        }elseif ($grade[0][SUM_GRADE]>=60&&$grade[0][SUM_GRADE]<75) {
                            $lt_LowScore++;
                        }elseif ($grade[0][SUM_GRADE]>=75&&$grade[0][SUM_GRADE]<90) {
                            $lt_MediumScore++;
                        }elseif ($grade[0][SUM_GRADE]<=0||$grade[0][SUM_GRADE]>100||$grade[0][SUM_GRADE]==null) {
                            $lt_shouldRuning++;
                        }

                        break;
                    case '_DC_':
                        $score_sql="SELECT DISTINCT SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_DC_FINALSCORE WHERE ITEMID = '".$itemid."'  AND POINTID='".$pointid."' AND STATIONID='".$stationid."' AND ISLASTEST = 1";
                        //var_dump($score_sql);
                        $grade = $item_grade->query($score_sql);
                        if ($grade[0][SUM_GRADE]>=90&&$grade[0][SUM_GRADE]<=100) {
                            $dc_HighScore++;
                        }elseif ($grade[0][SUM_GRADE]>0&&$grade[0][SUM_GRADE]<60) {
                            $dc_FlunkScore++;
                        }elseif ($grade[0][SUM_GRADE]>=60&&$grade[0][SUM_GRADE]<75) {
                            $dc_LowScore++;
                        }elseif ($grade[0][SUM_GRADE]>=75&&$grade[0][SUM_GRADE]<90) {
                            $dc_MediumScore++;
                        }elseif ($grade[0][SUM_GRADE]<=0||$grade[0][SUM_GRADE]>100||$grade[0][SUM_GRADE]==null) {
                            $dc_shouldRuning++;
                        }


                        break;
                    case '_DDZ_':
                        $score_sql="SELECT DISTINCT SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_DDZ_FINALSCORE WHERE ITEMID = '".$itemid."'  AND POINTID='".$pointid."' AND STATIONID='".$stationid."' AND ISLASTEST = 1";
                        //var_dump($score_sql);
                        $grade = $item_grade->query($score_sql); 
                        if ($grade[0][SUM_GRADE]>=90&&$grade[0][SUM_GRADE]<=100) {
                            $ddz_HighScore++;
                        }elseif ($grade[0][SUM_GRADE]>0&&$grade[0][SUM_GRADE]<60) {
                            $ddz_FlunkScore++;
                        }elseif ($grade[0][SUM_GRADE]>=60&&$grade[0][SUM_GRADE]<75) {
                            $ddz_LowScore++;
                        }elseif ($grade[0][SUM_GRADE]>=75&&$grade[0][SUM_GRADE]<90) {
                            $ddz_MediumScore++;
                        }elseif ($grade[0][SUM_GRADE]<=0||$grade[0][SUM_GRADE]>100||$grade[0][SUM_GRADE]==null) {
                            $ddz_shouldRuning++;
                        }

                        break;
                    case '_DDC_':
                        $score_sql="SELECT DISTINCT SUM_GRADE FROM JC_MANAGEGRADE.MG_CP_DDC_FINALSCORE WHERE ITEMID = '".$itemid."'  AND POINTID='".$pointid."' AND STATIONID='".$stationid."'AND ISLASTEST = 1";
                        $grade = $item_grade->query($score_sql);
                        if ($grade[0][SUM_GRADE]>=90&&$grade[0][SUM_GRADE]<=100) {
                            $ddc_HighScore++;
                        }elseif ($grade[0][SUM_GRADE]>0&&$grade[0][SUM_GRADE]<60) {
                            $ddc_FlunkScore++;
                        }elseif ($grade[0][SUM_GRADE]>=60&&$grade[0][SUM_GRADE]<75) {
                            $ddc_LowScore++;
                        }elseif ($grade[0][SUM_GRADE]>=75&&$grade[0][SUM_GRADE]<90) {
                            $ddc_MediumScore++;
                        }elseif ($grade[0][SUM_GRADE]<=0||$grade[0][SUM_GRADE]>100||$grade[0][SUM_GRADE]==null) {
                            $ddc_shouldRuning++;
                        }

                        break;
                    case '_FZ_':

                        break;


                }
            }
            $item_counts += count($item_result);


           }
        //The grades are stored and returned in the array
        $score_count['xb_shouldRuning'] = $xb_shouldRuning;
        $score_count['lt_shouldRuning'] = $lt_shouldRuning;
        $score_count['ddz_shouldRuning'] = $ddz_shouldRuning;
        $score_count['ddc_shouldRuning'] = $ddc_shouldRuning;
        $score_count['dc_shouldRuning'] = $dc_shouldRuning;
        $score_count['xb_MediumScore'] = $xb_MediumScore;
        $score_count['xb_LowScore'] = $xb_LowScore;
        $score_count['xb_FlunkScore'] = $xb_FlunkScore;
        $score_count['xb_HighScore'] = $xb_HighScore;
        $score_count['lt_MediumScore'] = $lt_MediumScore;
        $score_count['lt_LowScore'] = $lt_LowScore;
        $score_count['lt_FlunkScore'] = $lt_FlunkScore;
        $score_count['lt_HighScore'] = $lt_HighScore;
        $score_count['dc_MediumScore'] = $dc_MediumScore;
        $score_count['dc_LowScore'] = $dc_LowScore;
        $score_count['dc_FlunkScore'] = $dc_FlunkScore;
        $score_count['dc_HighScore'] = $dc_HighScore;
        $score_count['ddc_MediumScore'] = $ddc_MediumScore;
        $score_count['ddc_LowScore'] = $ddc_LowScore;
        $score_count['ddc_FlunkScore'] = $ddc_FlunkScore;
        $score_count['ddc_HighScore'] = $ddc_HighScore;
        $score_count['ddz_MediumScore'] = $ddz_MediumScore;
        $score_count['ddz_LowScore'] = $ddz_LowScore;
        $score_count['ddz_FlunkScore'] = $ddz_FlunkScore;
        $score_count['ddz_HighScore'] = $ddz_HighScore;
        //Number of the main  items
        $score_count['counts'] = $item_counts;
        return $score_count;

    }
    /*
    **返回测点信息
    */
    public function return_eachitems(){
        header("Content-Type: text/html; charset=utf-8");
        if(IS_POST){
        $param_latitude=I('post.lat','','htmlspecialchars');
        $param_longitude=I('post.lng','','htmlspecialchars');
        $param_distance=I('post.radius','','htmlspecialchars');
        }
        $result = $this->SearchAllStations($param_latitude,$param_longitude,$param_distance);
        static $item_result_each = array();
        //Traverse the range of stations ID
        for ($i=0; $i <count($result) ; $i++) { 
        $mode=M('','','CONFIG_QZDATA');
        $item_sql="select distinct a.stationid, a.stationname,a.latitude,a.longitude,b.ITEMID,b.POINTID from qzdata.qz_dict_stations a,qzdata.qz_dict_stationitems b where a.stationid=b.stationid and a.STATIONID='".$result[$i]['STATIONID']."'";
        //Check out the main items in the range station
        $item_result=$mode->query($item_sql);  
        //var_dump($item_result);
        $item_result_each[]=$item_result;
        }
        //var_dump($item_result_each);
        //echo (count($item_result_each));
        return $item_result_each;
    }

    /* 
    * * @desc 根据两点间的经纬度计算距离 
    * * @param float $lat 纬度值 
    * * @param float $lng 经度值 
    */ 
public function getDistance($latitude1, $longitude1, $latitude2, $longitude2) {  
    $theta = $longitude1 - $longitude2;  
    $miles = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) + (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta)));  
    $miles = acos($miles);  
    $miles = rad2deg($miles);  
    $miles = $miles * 60 * 1.1515;   
    $kilometers = $miles * 1.609344;   
    return round($kilometers,2);  
}
    /* 
    * * @desc 输出浏览器端 
    */ 
    public function sefile(){  
        $data = $_GET[info];  
        $filename = $data;    
        header('Content-Type: application/octet-stream');       
        header('content-disposition:attachment;filename='.basename($filename));
        header('content-length:'.filesize($filename));
        readfile($filename);
        unlink($filename);
    }


}
php分享案例,分享 ThinkPHP6.0 内容导出 Word 案例
weixin_28717939的博客
03-21 475
下面由thinkphp框架教程栏目给大家介绍 ThinkPHP6.0 内容导出 Word 案例，希望对需要的朋友有所帮助！(一)环境配置基础环境系统环境：Windows10 x64PHP集成环境：phpstudyPHP依赖管理工具：Composer手册：Thinkphp(二)安装ThinkPHP6.0和Phpword扩展(1)安装ThinkPHP6.0composer create-project...
thinkphp按照模板样式替换内容导出word
凌云鹤YK
01-02 1369
thinkphp按照模板样式替换内容导出word 场景：有一个模板文件，我们需要从后台导出一个结构和这个模板一模一样的word文档，只是每次导出word文档里的内容不一样。比如导出不同客户的承诺书时，不同的客户姓名，身份证号码等信息都不一样。这里我是用phpword实现的，过程如下。 一、先创建好word模板文件，格式为docx。如下图为模板文件。${name}为每次导出要替换的变量。 二、利用...
thinkphp生成word文档并导出
07-24
thinkphp把数据库内容生成word，且可以下载到本地，一个类放到指定文件夹里，另一个则是控制器，自行修改即可。
PHP高效导出Word文档完整教程
weixin_33562004的博客
05-18 938
PHPWord是PHP语言的一个库，用于生成和操作Microsoft Word文档。它提供了一套丰富的API，使PHP开发者能够方便地创建和编辑Word文档，包括但不限于添加文本、图片、表格以及格式设置等。其核心目标是将复杂的Word文档操作抽象化，简化为更加直观易懂的代码操作。要创建一个模板，我们首先定义好带有占位符的Word文档。占位符可以是简单文本或变量，稍后会被实际数据替代。例如，以下代码展示如何在PHPWord中使用模板：// 加载模板文件// 替换模板中的占位符// 保存文档。
thinkphp5+PHPword实现文档导出到word
技术小贺
02-26 2271
1、加载依赖包 composer require phpoffice/phpword 2、官网手册和example phpw官网 实例 3、体验地址 AI智能翻译写作机器人 4、直接导出到本地或者保存word到项目目录 /** * @param Request $request * @author: Jackhhy <jackhhy520@qq....
php导出word文档（支持样式导出）
02-21
支持php、thinkphp进行将html页面直接导出为word，样式可一并导出为word
thinphp php导出word,thinkhphp5.0利用PHPWord导出word
weixin_39655085的博客
04-01 317
下载PHPWord放到thinkphp->extend下具体代码：Loader::import('PHPWord.php');Loader::import('PHPWord.IOFactory.php');Loader::import('PHPWord.Section.php');Loader::import('PHPWord.Template.php');Loader::import('P...
thinkphp6 导出word文件（包含html、css）
qq_38750144的博客
11-07 450
thinkphp6 导出word文档
ThinkPHP实现Word文档生成与导出功能
最新发布
08-08
本文将详细讲解如何借助 ThinkPHP 框架实现 Word 文档的生成与导出，重点剖析 WordController.class.php 和 Wordmaker.class.php 这两个关键文件的作用。 WordController.class.php 是 ThinkPHP 中的控制器文件，它...
thinkphp+layui+phpword实现php中将表单导出word格式
12-11
结合这三个技术栈，开发人员能够实现一个功能强大的网页应用，用户可以通过Layui设计的表单界面输入数据，之后这些数据通过ThinkPHP后端处理，最终通过PHPWord库将数据导出为Word格式的文件。这个过程不仅涉及到前端...
thinkphp5.0集成phpword，生成word文档并下载-附件资源
03-02
thinkphp5.0集成phpword，生成word文档并下载-附件资源
php导出work,thinkphp如何导出word
weixin_30099989的博客
03-19 304
thinkphp导出word需要引入Wordmaker.class.php类文件，通过该类文件生成word文档导出来。下面介绍实现的过程：在Thinkphp的controller文件夹内新建一个WordController.class.php文件，作为生成word的控制器。把Wordmaker.class.php类文件放在Thinkphp目录Util文件夹下面，用于下面步骤使用import方法导入...
ThinkPHP完全开发手册word版
08-30
thinkphp框架的完全帮助文档，作为现在国内最著名的三大PHP开发框架之一，thinkphp以简单，功能强大，是最合适的企业网站开发框架。一般找到的都是PDF的，但次为word版，使大家学习使用起来更加方便
ThinkPHP5快速入门 Word版本
12-11
最新的5.0版本，word版本更直观。
【最新】ThinkPHP5快速入门手册Word完全版 下载
04-04
thinkPHP 官网付费推荐官方出品教程Word版本。 ThinkPHP V5.0 快速入门系列是学习和掌握ThinkPHP5.0不可多得的入门指引教程，针对新手用户由浅入深给出了详尽的使用。 本书围绕WEB开发和API开发常用的一系列基础功能进行循序渐进的讲解。
php 在thinkphp 框架下生成word
weixin_33813128的博客
06-15 980
2019独角兽企业重金招聘Python工程师标准>>> ...
ThinkPHP6利用phpoffice/phpword导出word文档
打代码是一天，不打代码也是一天
07-27 2744
大概步骤如下 1 tp框架导入phpoffice/phpword包 composer require phpoffice/phpword 2 利用word模板导出生成word文档，其中包含文字、图片、多段落、循环试题 // 导出word文件路径+文件名 $path = "./storage/file/7月份驾驶员培训结业报告.docx" // 模板文件路径+文件名 $templatePath = "./storage/template/driver_report_template.docx"; $t.
thinphp php导出word,thinkphp 用phpword导出word文档,文件损坏
weixin_39794385的博客
04-01 263
悬赏园豆：15[待解决问题]代码： 1 import("Org.Util.PHPWord"); 2 import("Org.Util.PHPWord.IOFactory"); 3 $PHPWord = new \PHPWord(); 4 $document = $PHPWord->loadTemplate('template1.docx'); ...
记一次php 导出word文档
qq_58778333的博客
05-25 1044
"options" => "[{"name":"A","value":"明火造成人员烧伤11","attrid":"","attr":""},{"name":"B","value":"变压器自身易爆炸","attrid":"","attr":""},{"name":"C","value":"明火可能造成环境污染","attrid":"","attr":""},{"name":"D","value":" 以上均不对","attrid":"","attr":""}]"克隆行数 （若不在表格中 则会报错）
ThinkPHP 3.2实现Excel导入导出功能详解
- **导出.txt**：这可能是关于如何使用ThinkPHP框架来实现Excel导出功能的详细教程文档。 - **联系.txt**：可能包含了一些联系信息或者具体的联系方式，用以获取技术支持或进一步信息。 - **PHPExcel导入教程**：...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值