include_once '../app/vender/PHPExcel_180/PHPExcel.php';
include_once '../app/library/MDB.php';
$mdb = new MDB('ar');
$dir = __DIR__ . "/update_db_config/Config/";
$files = scandir($dir);
$excels = [];
foreach ($files as $key => $value) {
if (file_exists($dir . $value) && substr($value, -4) == 'xlsx') {
if ($value == '角色属性.xlsx') {
$datas = updateData($dir . $value);
//print_r($datas);
if (!count($datas['list'])) {
exit('NO DATAS');
}
foreach ($datas['list'] as $key => $value) {
$mdb->selectCol('user_level_conf_' . $datas['version'])->insert($value);
}
}
}
}
function updateData($filename, $encode = 'utf-8')
{
$PHPReader = new PHPExcel_Reader_Excel2007();
if (!$PHPReader->canRead($filename)) {
$PHPReader = new PHPExcel_Reader_Excel5();
if (!$PHPReader->canRead($filename)) {
echo 'no Excel';
return;
}
}
$PHPExcel = $PHPReader->load($filename);
