使用Javascript从Oracle Primavera解析日历blob

Question

将日历数据以base64编码格式存储为blob，解码后提供以下内容，

(0\x{e76f}\x{e76f}(\x{e76f}\x{e76f}(\x{e76f}\x{e}\x{e76f}\x{e76f}(\x{e76f}\x{e76f}(\x{e76f}\x{2}\x{e76f}\x{2}\x{2}\x{e76f}\x{e((2)(0\x{e76f}\x{e76f}(\x{e76f}\x{e76f}(\x{e76f}(\x{e76f}\x{e76f}((0)\x{e76f}\x{e}\x{e}\x{e76f}\x{e76f}((S)\x{e76f}\x{e76f}(\x{e76f}\x{e76f}(0\x{e76f}\x{e76f}(\x{e76f}\x{e76f}\x{e76f}(\x{e76f}\x{e76f}(\x{e76f}\x{e}\x{e76f}\x{e76f}(\x{e}\x{e76f}(\x{e76f}\x{e76f}\x{e}(d(d(d(d\x{e76f}(d\x{e76f}\x{e76f}(d=39875)((D)\x{e76f}(\x{e76f}\x{e76f}\x{e76f}(\x{e76f}\x{e}\x{e}\x{e76f}\x{e}\x{e76f}\x{e76f}(d\x{e76f}\x{e76f}(\x{e76f}\x{e76f}\x{e76f}(\x{e76f}\x{e}\x{e76f}\x{(d(d(d(d\x{e76f}(d\x{e76f}\x{e76f}(d=40162)((D)\x{e76f}(\x{e76f}\x{e76f}\x{e}\x{e}\x{e76f}\x{e76f}\x{e76f}(d\x{e76f}\x{e76f}(\x{e76f}\x{e76f}\x{e76f}(\x{e76f}\x{e76f}\x(d(d(d\x{e76f}(d\x{e76f}\x{e76f}(\x{e76f}\x{e76f}\x{e76f}(\x{e76f}\x{

如何从这个变量中读取日期？我需要将它转换成JSON，以便脚本使用。我需要所有的异常-值和日期(例如，131是例外，40218是日期)。谢谢,

Answer 1

MPXJ读取这些数据。从这里开始，可以找到相关的代码，https://github.com/joniles/mpxj/blob/master/src/net/sf/mpxj/primavera/PrimaveraReader.java#L181，我怀疑您可以很容易地将它转换成Javascript。

Answer 2

这就是我是如何在PHP中使用嵌套括号类解析数据的。

https://gist.github.com/Xeoncross/4710324

然后处理时间间隔

if( preg_match('~^s\|([0-9]+):([0-9]+)\|f\|([0-9]+):([0-9]+)$~', $string, $match) )
{   // Start and finish times
    $interval[] = array(
        's' => array(
            't' => $match[1].':'.$match[2],
            'h' => (int)$match[1],
            'm' => (int)$match[2],
        ),
        'f' => array(
            't' => $match[3].':'.$match[4],
            'h' => (int)$match[3],
            'm' => (int)$match[4],
        )
    );
}