thinkphp5.0、5.1,insertAll 插入oracle时间被过滤问题,修改框架驱动

thinkphp5.0、5.1,insertAll 插入oracle时间被过滤问题,修改框架驱动

修改db\Builder.php

public function insertAll($dataSet, $options = [], $replace = false)
{
    // 获取合法的字段
    if ('*' == $options['field']) {
        $fields = array_keys($this->query->getFieldsType($options['table']));
    } else {
        $fields = $options['field'];
    }

    foreach ($dataSet as &$data) {
        foreach ($data as $key => $val) {
            if (!in_array($key, $fields, true)) {
                if ($options['strict']) {
                    throw new Exception('fields not exists:[' . $key . ']');
                }
                unset($data[$key]);
            } elseif (is_null($val)) {
                $data[$key] = 'NULL';
            } elseif (is_scalar($val)) {
                $data[$key] = $this->parseValue($val, $key);
            } elseif (is_object($val) && method_exists($val, '__toString')) {
                // 对象数据写入
                $data[$key] = $val->__toString();
            } elseif (isset($val[0]) && 'exp' == $val[0]) {
                $data[$key] = $val[1];
            } else{
                unset($data[$key])
            }
        }
        $value = array_values($data);
        $values[] = 'SELECT ' . implode(',', $value) . 'FROM DUAL';
    }
    $fields = array_map([$this, 'parseKey'], array_keys(reset($dataSet)));
    $sql = str_replace(
        ['%INSERT%', '%TABLE%', '%FIELD%', '%DATA%', '%COMMENT%'],
        [
            $replace ? 'REPLACE' : 'INSERT',
            $this->parseTable($options['table'], $options),
            implode(' , ', $fields),
            implode(' UNION ALL ', $values),
            $this->parseComment($options['comment']),
        ], $this->insertAllSql);
    return $sql;
}