公司做的时实查询数据系统测试版

package com.dgch.bean; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; /** * * @author liangrui * 2013/11/21 * *排队机整体运营日报表DG_PDJ_DAY_REPORT */ public class DgPdjDayReports { /** * [{STAT_DAY=20131105, BUSS_SUM=42424242, USER_SUM=424242, TOUCH_SUM=121, SMS_SUM=21, TARGET_USER_SUM=21, UNTARGET_USER_SUM=21, REPLY_SUM=12, HANDLE_SUM=12, ERROR_SUM=12, QX_SUM=12, TOUCH_PER=12, SELL_PER=12, REPLY_PER=12, OKREPLY_PER=12, OKHANDLE_SUM=12, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=888}, {STAT_DAY=20130822, BUSS_SUM=36677382, USER_SUM=12522521, TOUCH_SUM=1667, SMS_SUM=1625, TARGET_USER_SUM=1439, UNTARGET_USER_SUM=186, REPLY_SUM=14, HANDLE_SUM=3, ERROR_SUM=10, QX_SUM=1, TOUCH_PER=97.4805%, SELL_PER=88.5538%, REPLY_PER=0.9729%, OKREPLY_PER=0.2085%, OKHANDLE_SUM=2, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=354}, {STAT_DAY=20130820, BUSS_SUM=36677382, USER_SUM=12522521, TOUCH_SUM=1654, SMS_SUM=1603, TARGET_USER_SUM=1429, UNTARGET_USER_SUM=174, REPLY_SUM=12, HANDLE_SUM=0, ERROR_SUM=10, QX_SUM=2, TOUCH_PER=96.9166%, SELL_PER=89.1454%, REPLY_PER=0.8397%, OKREPLY_PER=0.0000%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=353}, {STAT_DAY=20130819, BUSS_SUM=36677382, USER_SUM=12522521, TOUCH_SUM=1918, SMS_SUM=1860, TARGET_USER_SUM=1624, UNTARGET_USER_SUM=236, REPLY_SUM=11, HANDLE_SUM=0, ERROR_SUM=9, QX_SUM=2, TOUCH_PER=96.9760%, SELL_PER=87.3118%, REPLY_PER=0.6773%, OKREPLY_PER=0.0000%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=352}, {STAT_DAY=20130818, BUSS_SUM=36677382, USER_SUM=12522521, TOUCH_SUM=1793, SMS_SUM=1719, TARGET_USER_SUM=1518, UNTARGET_USER_SUM=201, REPLY_SUM=13, HANDLE_SUM=0, ERROR_SUM=13, QX_SUM=0, TOUCH_PER=95.8728%, SELL_PER=88.3072%, REPLY_PER=0.8564%, OKREPLY_PER=0.0000%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=351}, {STAT_DAY=20130805, BUSS_SUM=36677382, USER_SUM=12522521, TOUCH_SUM=2341, SMS_SUM=2281, TARGET_USER_SUM=2007, UNTARGET_USER_SUM=274, REPLY_SUM=28, HANDLE_SUM=0, ERROR_SUM=27, QX_SUM=1, TOUCH_PER=97.4370%, SELL_PER=87.9877%, REPLY_PER=1.3951%, OKREPLY_PER=0.0000%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=350}, {STAT_DAY=20130804, BUSS_SUM=36677382, USER_SUM=12522521, TOUCH_SUM=2357, SMS_SUM=2254, TARGET_USER_SUM=1924, UNTARGET_USER_SUM=330, REPLY_SUM=33, HANDLE_SUM=0, ERROR_SUM=30, QX_SUM=3, TOUCH_PER=95.6300%, SELL_PER=85.3594%, REPLY_PER=1.7152%, OKREPLY_PER=0.0000%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=349}, {STAT_DAY=20130801, BUSS_SUM=36677382, USER_SUM=12522521, TOUCH_SUM=2385, SMS_SUM=2335, TARGET_USER_SUM=1975, UNTARGET_USER_SUM=360, REPLY_SUM=25, HANDLE_SUM=1, ERROR_SUM=21, QX_SUM=3, TOUCH_PER=97.9036%, SELL_PER=84.5824%, REPLY_PER=1.2658%, OKREPLY_PER=0.0506%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=348}, {STAT_DAY=20130730, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=3680, SMS_SUM=3534, TARGET_USER_SUM=3159, UNTARGET_USER_SUM=375, REPLY_SUM=6, HANDLE_SUM=2, ERROR_SUM=4, QX_SUM=0, TOUCH_PER=96.0326%, SELL_PER=89.3888%, REPLY_PER=0.1899%, OKREPLY_PER=0.0633%, OKHANDLE_SUM=2, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=347}, {STAT_DAY=20130726, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2265, SMS_SUM=2197, TARGET_USER_SUM=1933, UNTARGET_USER_SUM=264, REPLY_SUM=6, HANDLE_SUM=1, ERROR_SUM=4, QX_SUM=1, TOUCH_PER=96.9978%, SELL_PER=87.9836%, REPLY_PER=0.3104%, OKREPLY_PER=0.0517%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=346}, {STAT_DAY=20130725, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2272, SMS_SUM=2213, TARGET_USER_SUM=1956, UNTARGET_USER_SUM=257, REPLY_SUM=5, HANDLE_SUM=2, ERROR_SUM=3, QX_SUM=0, TOUCH_PER=97.4032%, SELL_PER=88.3868%, REPLY_PER=0.2556%, OKREPLY_PER=0.1022%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=345}, {STAT_DAY=20130724, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2099, SMS_SUM=2021, TARGET_USER_SUM=1763, UNTARGET_USER_SUM=258, REPLY_SUM=13, HANDLE_SUM=3, ERROR_SUM=10, QX_SUM=0, TOUCH_PER=96.2839%, SELL_PER=87.2340%, REPLY_PER=0.7374%, OKREPLY_PER=0.1702%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=344}, {STAT_DAY=20130720, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2214, SMS_SUM=2138, TARGET_USER_SUM=1918, UNTARGET_USER_SUM=220, REPLY_SUM=3, HANDLE_SUM=0, ERROR_SUM=3, QX_SUM=0, TOUCH_PER=96.5673%, SELL_PER=89.7100%, REPLY_PER=0.1564%, OKREPLY_PER=0.0000%, OKHANDLE_SUM=0, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=343}, {STAT_DAY=20130716, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=1322, SMS_SUM=1262, TARGET_USER_SUM=1117, UNTARGET_USER_SUM=145, REPLY_SUM=10, HANDLE_SUM=3, ERROR_SUM=7, QX_SUM=0, TOUCH_PER=95.4614%, SELL_PER=88.5103%, REPLY_PER=0.8953%, OKREPLY_PER=0.2686%, OKHANDLE_SUM=3, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=342}, {STAT_DAY=20130711, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2510, SMS_SUM=2425, TARGET_USER_SUM=2151, UNTARGET_USER_SUM=274, REPLY_SUM=18, HANDLE_SUM=12, ERROR_SUM=6, QX_SUM=0, TOUCH_PER=96.6135%, SELL_PER=88.7010%, REPLY_PER=0.8368%, OKREPLY_PER=0.5579%, OKHANDLE_SUM=10, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=341}, {STAT_DAY=20130713, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2264, SMS_SUM=2176, TARGET_USER_SUM=1947, UNTARGET_USER_SUM=229, REPLY_SUM=17, HANDLE_SUM=7, ERROR_SUM=9, QX_SUM=1, TOUCH_PER=96.1131%, SELL_PER=89.4761%, REPLY_PER=0.8731%, OKREPLY_PER=0.3595%, OKHANDLE_SUM=7, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=340}, {STAT_DAY=20130709, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2686, SMS_SUM=2427, TARGET_USER_SUM=2174, UNTARGET_USER_SUM=253, REPLY_SUM=22, HANDLE_SUM=11, ERROR_SUM=11, QX_SUM=0, TOUCH_PER=90.3574%, SELL_PER=89.5756%, REPLY_PER=1.0120%, OKREPLY_PER=0.5060%, OKHANDLE_SUM=9, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=339}, {STAT_DAY=20130705, BUSS_SUM=35727665, USER_SUM=12235073, TOUCH_SUM=2513, SMS_SUM=2477, TARGET_USER_SUM=2197, UNTARGET_USER_SUM=280, REPLY_SUM=18, HANDLE_SUM=8, ERROR_SUM=10, QX_SUM=0, TOUCH_PER=98.5674%, SELL_PER=88.6960%, REPLY_PER=0.8193%, OKREPLY_PER=0.3641%, OKHANDLE_SUM=8, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=338}, {STAT_DAY=20130629, BUSS_SUM=30149595, USER_SUM=10086819, TOUCH_SUM=6432, SMS_SUM=6272, TARGET_USER_SUM=5046, UNTARGET_USER_SUM=1226, REPLY_SUM=56, HANDLE_SUM=15, ERROR_SUM=40, QX_SUM=1, TOUCH_PER=97.5124%, SELL_PER=80.4528%, REPLY_PER=1.1098%, OKREPLY_PER=0.2973%, OKHANDLE_SUM=14, NGBOSS_HANDLE_SUM=null, NGBOSS_HANDLE_PER=null, NGBOSS_HANDLE_OK_SUM=null, NGBOSS_HANDLE_OK_PER=null, P_ID=337}, {STAT_DAY=20130614, BUSS_SUM=31431543, USER_SUM=12070069, TOUCH_SUM=3366, SMS_SUM=3278, TARGET_USER_SUM=3006, UNTARGET_USER_SUM=272, REPLY_SUM=4, HANDLE_SUM=2, ERROR_SUM=2, QX_SUM=0, TOUCH_