数据库表
现在需要根据cardStatus字段进行合并,
和lastTime,printStatus 字段无关
最终结果如下:
hostId beginDate endDate cardStatus
liquan 2016-06-19 11:01:37 2016-06-19 11:02:56 -117
liquan 2016-06-19 11:03:56 2016-06-19 11:04:56 -239
liquan 2016-06-19 11:05:57 2016-06-19 11:08:57 -117
liquan 2016-06-19 11:09:58 2016-06-19 11:11:58 0
liquan 2016-06-19 11:12:58 2016-06-19 11:12:58 -117
liquan 2016-06-19 11:13:58 2016-06-19 11:13:58 -239
liquan 2016-06-19 11:14:59 2016-06-19 11:19:00 -117
后面结果一次类推