case 'tiptext':

    $row[$column['name'].'__'.$column['type']] = '<div class="el-tooltip" aria-describedby="el-tooltip-127" tabindex="0" style="color: rgb(64, 158, 255); text-overflow: ellipsis; overflow: hidden; white-space: nowrap;" title="'.$row[$column['name']].'" data-toggle="tooltip" >'.$row[$column['name']].'</div>';

    break;

<?php

return [

    // 数据库类型

    'type'            => 'pgsql',

    // 服务器地址

    'hostname'        => '172.2.2.254',

    // 数据库名

    'database'        => 'cmsdb',

    // 用户名

    'username'        => 'postgres',

    // 密码

    'password'        => 'postgres',

    // 端口

    'hostport'        => '5432',

    // 连接dsn

    'dsn'             => '',

    // 数据库连接参数

    'params'          => [],

    // 数据库编码默认采用utf8

    'charset'         => 'utf8',

    // 数据库表前缀

    'prefix'          => 'dp_',

    // 数据库调试模式

    'debug'           => true,

    // 数据库部署方式:0 集中式(单一服务器),1 分布式(主从服务器)

    'deploy'          => 0,

    // 数据库读写是否分离 主从式有效

    'rw_separate'     => false,

    // 读写分离后 主服务器数量

    'master_num'      => 1,

    // 指定从服务器序号

    'slave_no'        => '',

    // 是否严格检查字段是否存在

    'fields_strict'   => false,

    // 数据集返回类型

    'resultset_type'  => 'array',

    // 自动写入时间戳字段

    'auto_timestamp'  => false,

    // 时间字段取出后的默认时间格式

    'datetime_format' => false,

    // 是否需要进行SQL性能分析

    'sql_explain'     => false,

];

$db_hikvision = require_once('database2.php');

//海康数据库配置

    'db_hikvision' => $db_hikvision,

$data_list = Db::connect('db_hikvision')

            ->table('oc_person')

            ->where($map)

            ->order($order)

            ->paginate();

/**

     * 设置树状表格，此模式建议设置为无分页模式

     * @param string $key    唯一标识字段

     * @param string $pkey   父结点字段

     * @param int    $pos    可控制列位置，默认为0，即第一列

     * @param int    $expand 默认展开层级，默认为1

     */

    public function setTreeMode($key = "id", $pkey = "pid", $pos = 0, $expand = 1)

    {

        if (!empty($key) && !empty($pkey)) {

            $this->_vars['tree_mode'] = [

                'key' => $key,

                'pkey' => $pkey,

                'pos' => $pos,

                'expand' => $expand,

            ];

        }

        return $this;

    }

<tbody{present name='tree_mode'} id="tree_table" expand="{$tree_mode.expand|default=1}" pos="{$tree_mode.pos|default=0}"{/present}</tbody>

<tr class="{$row['_tr_class']|default=''}"{present name='tree_mode'} id="{$row[$tree_mode['key']]}" pid="{$row[$tree_mode['pkey']]}"{/present}></tr>

$('#tree_table').treeTable({

    expandLevel:$('#tree_table').attr("expand"),

    column:$('#tree_table').attr("pos")

});

return ZBuilder::make('table')

    ....

    ->setTreeMode("id", "pid", 1, 99)

    ->noPages() //建议使用无分页模式，取数据的时候，一次性将数据取出来

    ->fetch();

    

<script src="__LIBS__/bootstrap-datetimepicker/moment.min.js"></script>

use tcpdf\Tcpdf;



class PDF extends Common

{

    public function index()

    {

            // create new PDF document

            $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);

            // set document information

            $pdf->SetCreator(PDF_CREATOR);

            $pdf->SetAuthor('Nicola Asuni');

            $pdf->SetTitle('TCPDF Example 001');

            $pdf->SetSubject('TCPDF Tutorial');

            $pdf->SetKeywords('TCPDF, PDF, example, test, guide');

            

            // set default header data

            $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 001', PDF_HEADER_STRING, array(0,64,255), array(0,64,128));

            $pdf->setFooterData(array(0,64,0), array(0,64,128));

            

            // set header and footer fonts

            $pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));

            $pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));

            

            // set default monospaced font

            $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

            

            // set margins

            $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);

            $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);

            $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);

            

            // set auto page breaks

            $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);

            

            // set image scale factor

            $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

            

            // set some language-dependent strings (optional)

            if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {

                require_once(dirname(__FILE__).'/lang/eng.php');

                $pdf->setLanguageArray($l);

            }

            

            // ---------------------------------------------------------

            

            // set default font subsetting mode

            $pdf->setFontSubsetting(true);

            

            // Set font

            // dejavusans is a UTF-8 Unicode font, if you only need to

            // print standard ASCII chars, you can use core fonts like

            // helvetica or times to reduce file size.

            $pdf->SetFont('dejavusans', '', 14, '', true);

            

            // Add a page

            // This method has several options, check the source code documentation for more information.

            $pdf->AddPage();

            

            // set text shadow effect

            $pdf->setTextShadow(array('enabled'=>true, 'depth_w'=>0.2, 'depth_h'=>0.2, 'color'=>array(196,196,196), 'opacity'=>1, 'blend_mode'=>'Normal'));

            

            // Set some content to print

            $html = <<<EOD

            <h1>Welcome to <a href="h提提p://www点tcpdf点org" style="text-decoration:none;background-color:#CC0000;color:black;"> <span style="color:black;">TC</span><span style="color:white;">PDF</span> </a>!</h1>

            <i>This is the first example of TCPDF library.</i>

            <p>This text is printed using the <i>writeHTMLCell()</i> method but you can also use: <i>Multicell(), writeHTML(), Write(), Cell() and Text()</i>.</p>

            <p>Please check the source code documentation and other examples for further information.</p>

            <p style="color:#CC0000;">TO IMPROVE AND EXPAND TCPDF I NEED YOUR SUPPORT, PLEASE <a href="h提提p://sourceforge点net/donate/index

点

php?group_id=128076">MAKE A DONATION!</a></p>

            EOD;

            

            // Print text using writeHTMLCell()

            $pdf->writeHTMLCell(0, 0, '', '', $html, 0, 1, 0, true, '', true);

            

            // ---------------------------------------------------------

            

            // Close and output PDF document

            // This method has several options, check the source code documentation for more information.

            $pdf->Output('example_001.pdf', 'I');

            

            //============================================================+

            // END OF FILE

            //============================================================+

    }

}

// 关闭路由

\think\App::route(false);

有的时候我们希望获取图片路径的时候带上完整的域名，官方的get_thumb函数没有提供，

自己加了一个$domain参数，给需要的人



application\common.php



if (!function_exists('get_thumb')) {

    /**

     * 获取图片缩略图路径

     * @param int $id 附件id

     * @author 蔡伟明 <314013107@qq.com>

     * @return string

     */

    function get_thumb($id = 0,$domain=true)

    {

        $path = model('admin/attachment')->getThumbPath($id);

        if (!$path) {

            return config('public_static_path').'admin/img/none.png';

        }

       

        if($domain){      

                if(empty($_SERVER['HTTPS']))

                        $pre="http://";

                else

                        $pre="https://";

                return   $pre.$_SERVER['HTTP_HOST'].PUBLIC_PATH. $path;

        }

        else {

                return  PUBLIC_PATH. $path;

        }

    }

}

    public function export()

    {

        // 查询数据

        $data = LevelModel::all();

        // 设置表头信息（对应字段名,宽度，显示表头名称）

        $cellName = [

            ['id', 'auto', 'ID'],

            ['name', 'auto', '级别名称'],

            ['score', 'auto', '积分要求'],

            ['discount', 'auto', '享受折扣'],

            ['create_time', 'auto', '创建时间'],

            ['update_time', 'auto', '更新时间']

        ];

        // 调用插件（传入插件名，[导出文件名、表头信息、具体数据]）

        plugin_action('Excel/Excel/export', ['test', $cellName, $data]);

    }