laravel DHTMLX使用（一）

你的名字 2022-03-28 03:53 158阅读 0赞

1.下载DHTMLX：[https://dhtmlx.com/docs/download.shtml][https_dhtmlx.com_docs_download.shtml]

2.解压到laravel的public目录下![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTgxNTAwMQ_size_16_color_FFFFFF_t_70]

3.主要使用的是codebase/dhtmlx.css和codebase/dhtmlx.js，在页面引用这两个文件即可  
![在这里插入图片描述][20190109151158312.png]

4.创建一个DHTMLX表格  
页面代码如下

Calendar eXcell

5.编写接口，返回xml格式数据  
public function xx()\{  
$res = QrModel::select(‘id’,‘public\_code’,‘upc’)->limit(9)->get();  
$xml = “<?xml version='1.0' encoding='utf-8' ?>”;  
header(“Content-Type:text/xml”);  
 x m l . = ′ < r o w s > ′ ; f o r ( xml .= &\#x27;<rows>&\#x27;; for( xml.=′<rows>′;for(i=0; i < c o u n t ( i<count( i<count(res);$i++)\{  
 x m l . = ′ < r o w i d = " ′ . ( xml.= &\#x27;<row id="&\#x27;.( xml.=′<rowid="′.(i+1).’"> //行id  
‘. r e s \[ res\[ res\[i\]->id.’ //第一列数据  
‘. r e s \[ res\[ res\[i\]->public\_code.’ //第二列数据  
‘. r e s \[ res\[ res\[i\]->upc.’  
';  
\}  
$xml .= ‘’;  
echo $xml;  
exit;  
\}

6.最终效果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTgxNTAwMQ_size_16_color_FFFFFF_t_70 1]

[https_dhtmlx.com_docs_download.shtml]: https://dhtmlx.com/docs/download.shtml
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTgxNTAwMQ_size_16_color_FFFFFF_t_70]: /images/20220328/2e66bf0ca21b4002ac98ddbd5df0c9e4.png
[20190109151158312.png]: /images/20220328/fc497cfcfb1548659c6d34c60e27a6cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTgxNTAwMQ_size_16_color_FFFFFF_t_70 1]: /images/20220328/07bc56f42db1460aad3c67a3531d49fa.png