Author Archives: admin

jquery plugin: fancytree tree view

  1. https://github.com/mar10/fancytree
  2. https://github.com/mar10/fancytree/wiki/TutorialExtensions
  3. http://wwwendt.de/tech/fancytree/demo/#sample-3rd-jQuery-contextMenu.html
    實作網站: 三國理財

 

 

PhpSpreadsheet

PhpSpreadsheet is the next version of PHPExcel. It breaks compatibility to dramatically improve the code base quality (namespaces, PSR compliance, use of latest PHP language features, etc.).

Because all efforts have shifted to PhpSpreadsheet, PHPExcel will no longer be maintained. All contributions for PHPExcel, patches and new features, should target PhpSpreadsheet develop branch.

Git:

https://github.com/PHPOffice/PhpSpreadsheet

Doc:

https://phpspreadsheet.readthedocs.io/en/develop/

API Doc:

https://phpoffice.github.io/PhpSpreadsheet/master/PhpOffice/PhpSpreadsheet/Cell/DataType.html

Example:

 

Laravel Excel

Official:

https://laravel-excel.maatwebsite.nl/docs/2.1/export/export

Note: When title row is in Chinese, need to change setting in config/excel.php: to_ascii: false;

https://laravel-china.org/topics/2029/laravel-excel-import-excel-file-incomplete-solution

Phpspreadsheet: (phpexcel is deprecated):

https://github.com/PHPOffice/PhpSpreadsheet

Don’t use heading as data key:

/config/excel.php: heading => false;

Example Code:

 

usort

 

Tree Traversal Examples

 

Enter to submit a form (or trigger a button)

 

Datatable Server Side Processing (Laravel)

Javascript:

Config:

 

Controller:

Model:

 

serialize form