PivotTable:从 MySQL 查询生成和呈现数据透视表

[{"title":"（ 28 个子文件 2.06MB ） PivotTable:从 MySQL 查询生成和呈现数据透视表","children":[{"title":"PivotTable-master","children":[{"title":"sql","children":[{"title":"sales_example.sql <span style='color:#111;'> 4.88KB </span>","children":null,"spread":false},{"title":"schema.sql <span style='color:#111;'> 144B </span>","children":null,"spread":false},{"title":"data","children":[{"title":"category.tsv <span style='color:#111;'> 63B </span>","children":null,"spread":false},{"title":"product.tsv <span style='color:#111;'> 2.38KB </span>","children":null,"spread":false},{"title":"country.tsv <span style='color:#111;'> 5.88KB </span>","children":null,"spread":false},{"title":"person.tsv <span style='color:#111;'> 1.95MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"src","children":[{"title":"PivotTable.php <span style='color:#111;'> 8.15KB </span>","children":null,"spread":false},{"title":"Util.php <span style='color:#111;'> 851B </span>","children":null,"spread":false},{"title":"Database.php <span style='color:#111;'> 2.37KB </span>","children":null,"spread":false}],"spread":true},{"title":"scripts","children":[{"title":"run_tests.sh <span style='color:#111;'> 76B </span>","children":null,"spread":false},{"title":"get_required_libraries.sh <span style='color:#111;'> 329B </span>","children":null,"spread":false},{"title":"code_validator.sh <span style='color:#111;'> 156B </span>","children":null,"spread":false}],"spread":true},{"title":"lib","children":[{"title":"phpcs.phar <span style='color:#111;'> 483.49KB </span>","children":null,"spread":false},{"title":"phpunit.phar <span style='color:#111;'> 3.25MB </span>","children":null,"spread":false},{"title":"composer.phar <span style='color:#111;'> 1.03MB </span>","children":null,"spread":false}],"spread":true},{"title":"demo","children":[{"title":"SalesDemo.php <span style='color:#111;'> 2.81KB </span>","children":null,"spread":false},{"title":"footer.php <span style='color:#111;'> 16B </span>","children":null,"spread":false},{"title":"header.php <span style='color:#111;'> 731B </span>","children":null,"spread":false},{"title":"htm","children":[{"title":"sales.htm <span style='color:#111;'> 17.68KB </span>","children":null,"spread":false}],"spread":true},{"title":"index.php <span style='color:#111;'> 61B </span>","children":null,"spread":false}],"spread":true},{"title":"doc","children":[{"title":"README <span style='color:#111;'> 0B </span>","children":null,"spread":false}],"spread":true},{"title":"LICENSE <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 237B </span>","children":null,"spread":false},{"title":"tests","children":[{"title":"DatabaseTest.php <span style='color:#111;'> 1.39KB </span>","children":null,"spread":false},{"title":"PivotTableTest.php <span style='color:#111;'> 268B </span>","children":null,"spread":false},{"title":"SalesExample.php <span style='color:#111;'> 2.24KB </span>","children":null,"spread":false}],"spread":true},{"title":".gitignore <span style='color:#111;'> 36B </span>","children":null,"spread":false},{"title":"composer.json <span style='color:#111;'> 428B </span>","children":null,"spread":false}],"spread":false}],"spread":true}]