xyzshop/test/TestSpreadsheet.php

<?php


use PHPUnit\Framework\TestCase;

define('APP_ID', 'test');
define('BASE_ROOT_PATH', str_replace('/test', '', dirname(__FILE__)));

require_once(BASE_ROOT_PATH . '/global.php');
require_once(BASE_CORE_PATH . '/lrlz.php');
require_once(BASE_ROOT_PATH . '/fooder.php');

Log::record('1',Log::DEBUG);
require_once(BASE_ROOT_PATH . '/vendor/autoload.php');
require_once(BASE_HELPER_PATH . '/bank/execl_loader.php');
require_once(BASE_HELPER_PATH . '/bank/converter.php');
Log::record('2',Log::DEBUG);


//use PhpOffice\PhpSpreadsheet\Spreadsheet;
//use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

//
//	Strangely, PHP doesn't have a mb_str_replace multibyte function
//	As we'll only ever use this function with UTF-8 characters, we can simply "hard-code" the character set
//
if ((!function_exists('mb_str_replace')) &&
    (function_exists('mb_substr')) && (function_exists('mb_strlen')) && (function_exists('mb_strpos'))) {
    function mb_str_replace($search, $replace, $subject) {
        if(is_array($subject)) {
            $ret = array();
            foreach($subject as $key => $val) {
                $ret[$key] = mb_str_replace($search, $replace, $val);
            }
            return $ret;
        }

        foreach((array) $search as $key => $s) {
            if($s == '') {
                continue;
            }
            $r = !is_array($replace) ? $replace : (array_key_exists($key, $replace) ? $replace[$key] : '');
            $pos = mb_strpos($subject, $s, 0, 'UTF-8');
            while($pos !== false) {
                $subject = mb_substr($subject, 0, $pos, 'UTF-8') . $r . mb_substr($subject, $pos + mb_strlen($s, 'UTF-8'), 65535, 'UTF-8');
                $pos = mb_strpos($subject, $s, $pos + mb_strlen($r, 'UTF-8'), 'UTF-8');
            }
        }
        return $subject;
    }
}

class TestSpreadsheet extends TestCase
{
    public static function setUpBeforeClass() : void
    {
        Base::run_util();
    }

    public function testLoad()
    {
        $spreadsheet = new PhpOffice\PhpSpreadsheet\Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('A1', 'Hello World !');

        $writer = new PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
        $writer->save('hello world.xlsx');
    }

    public function testReadSheet()
    {
//        $paths = [BASE_DATA_PATH . '/log/国研银行/2021.04.1.xls', BASE_DATA_PATH . '/log/椰子银行'];
//        $file = BASE_DATA_PATH . '/log/国研银行/2021.04.1.xls';
//        $file = BASE_DATA_PATH . '/log/椰子银行/椰子建行2020-06月.xls';
//        $file = BASE_DATA_PATH . '/log/国研银行/国研交行2021-11月.xls';
//        $file = BASE_DATA_PATH . '/log/国研银行/国研浦发2021-09月.xls';
//        $file = BASE_DATA_PATH . '/log/国研银行/国研招行2021-10月.xlsx';
//        $file = BASE_DATA_PATH . '/log/椰子银行/2021.11汇付宝付款明细单据数据导出.xls';
//        $file = BASE_DATA_PATH . '/log/椰子银行/椰子建行2021-05月.xls';

//        $path = BASE_DATA_PATH . '/log/国研银行'; //'国研交行21-22.xls','国研浦发银行明细账2109-2202.xls','椰子招行2021-04月.xlsx','国研招行21-2202.xlsx'
        Log::set_level(Log::WARING);
        Log::enable_sql(false);


        $path = BASE_DATA_PATH . '/log/椰子银行';
        $files = ['椰子招行2021-06月.xlsx'];

        $loader = new bank\execl_loader();
        foreach ($files as $file) {
            $file = $path . '/' . $file;
            $loader->load_file($file);
        }
    }

    //docker-compose run -d phpcli php /var/www/html/phpunit-9.2.5.phar --filter "/(TestSpreadsheet::testLoadDir)( .*)?$/" --test-suffix TestSpreadsheet.php /var/www/html/test
    public function testLoadDir()
    {
        $dir = BASE_DATA_PATH . '/log';
        $loader = new bank\execl_loader();
        $loader->load_dir($dir);
    }

    public function testFloat()
    {
        $val = '430,143.46';
//        $x = floatval($val);
//        $x = money_format($val);
        $x = mb_str_replace(',','',$val);
    }


    public function testReadMoney()
    {
//        $money_read = function ($val)
//        {
//            $val = trim($val);
//            if($val[0] == '￥') {
//                $amount = 0;
//            }
//
//        };
//
//        $left = mb_str_replace('¥','','¥1.00');
//        $val = $money_read('¥1.00');
    }


}