INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("239","2036","1215","2016-03-02 00:00:00","13347","4011","0","0"),
("240","2035","1215","2016-03-02 00:00:00","13435","4403","0","0"),
("257","2036","1215","2016-03-03 00:00:00","20965","10589","0","0"),
("271","2035","1215","2016-03-03 00:00:00","18740","5994","0","0"),
("289","2036","1215","2016-03-04 00:00:00","8964","4113","0","0"),
("312","2035","1215","2016-03-06 00:00:00","12682","1634","0","0"),
("315","2036","1215","2016-03-07 00:00:00","11338","6527","0","0"),
("324","2035","1215","2016-03-07 00:00:00","18053","4966","0","0"),
("339","2036","1215","2016-03-08 00:00:00","26112","11783","0","0"),
("356","2035","1215","2016-03-08 00:00:00","8637","3718","0","0"),
("369","2036","1215","2016-03-09 00:00:00","15113","7852","0","0"),
("372","2035","1215","2016-03-09 00:00:00","23436","12372","0","0"),
("395","2036","1215","2016-03-10 00:00:00","26724","16430","0","0"),
("401","2035","1215","2016-03-10 00:00:00","8455","2911","0","0"),
("417","2036","1215","2016-03-11 00:00:00","17459","12542","0","0"),
("443","2035","1215","2016-03-13 00:00:00","16078","7768","0","0"),
("446","2036","1215","2016-03-14 00:00:00","7466","2125","0","0"),
("459","2035","1215","2016-03-14 00:00:00","15300","9521","0","0"),
("465","2036","1215","2016-03-15 00:00:00","18029","4318","0","0"),
("474","2034","1215","2016-03-15 00:00:00","7048","1547","0","0"),
("479","2035","1215","2016-03-15 00:00:00","13799","5667","0","0"),
("490","2036","1215","2016-03-16 00:00:00","22828","13508","0","0"),
("495","2034","1215","2016-03-16 00:00:00","85680","84383","0","0"),
("498","2035","1215","2016-03-16 00:00:00","26010","12189","0","0"),
("508","2036","1215","2016-03-17 00:00:00","20250","7736","0","0"),
("514","2034","1215","2016-03-17 00:00:00","13299","2243","0","0"),
("515","2035","1215","2016-03-17 00:00:00","26424","16946","0","0"),
("528","2036","1215","2016-03-18 00:00:00","11010","5323","0","0"),
("547","2035","1215","2016-03-20 00:00:00","23367","10798","0","0"),
("549","2036","1215","2016-03-21 00:00:00","13137","1734","0","0"),
("560","2035","1215","2016-03-21 00:00:00","28345","12542","0","0"),
("573","2036","1215","2016-03-22 00:00:00","11308","2235","0","0"),
("586","2035","1215","2016-03-22 00:00:00","19440","8593","0","0"),
("588","2034","1215","2016-03-22 00:00:00","81697","83633","0","0"),
("598","2036","1215","2016-03-23 00:00:00","16556","3856","0","0"),
("605","2035","1215","2016-03-23 00:00:00","22452","7986","0","0"),
("614","2034","1215","2016-03-23 00:00:00","5098","2379","0","0"),
("622","2036","1215","2016-03-24 00:00:00","20682","10798","0","0"),
("630","2035","1215","2016-03-24 00:00:00","17517","7128","0","0"),
("640","2034","1215","2016-03-24 00:00:00","3205","1054","0","0"),
("643","2036","1215","2016-03-25 00:00:00","8391","3804","0","0"),
("655","2035","1215","2016-03-27 00:00:00","24420","10849","0","0"),
("657","2036","1215","2016-03-28 00:00:00","18089","6040","0","0"),
("662","2035","1215","2016-03-28 00:00:00","26069","13874","0","0"),
("669","2034","1215","2016-03-28 00:00:00","6060","5414","0","0"),
("673","2036","1215","2016-03-29 00:00:00","14937","5850","0","0"),
("680","2035","1215","2016-03-29 00:00:00","23928","11434","0","0"),
("693","2036","1215","2016-03-30 00:00:00","19890","4221","0","0"),
("695","2035","1215","2016-03-30 00:00:00","27717","10638","0","0"),
("704","2034","1215","2016-03-30 00:00:00","2340","641","0","0"),
("708","2036","1215","2016-03-31 00:00:00","17610","4977","0","0"),
("712","2035","1215","2016-03-31 00:00:00","27766","15724","0","0"),
("727","2036","1215","2016-04-01 00:00:00","15149","6979","0","0"),
("741","2035","1215","2016-04-03 00:00:00","27638","15591","0","0"),
("745","2036","1215","2016-04-04 00:00:00","24384","9687","0","0"),
("755","2035","1215","2016-04-04 00:00:00","22075","12001","0","0"),
("757","2034","1215","2016-04-04 00:00:00","160865","171802","0","0"),
("762","2036","1215","2016-04-05 00:00:00","17357","8778","0","0"),
("770","2035","1215","2016-04-05 00:00:00","22640","10012","0","0"),
("777","2036","1215","2016-04-06 00:00:00","83430","76383","0","0"),
("790","2035","1215","2016-04-06 00:00:00","15478","14803","0","0"),
("791","2034","1215","2016-04-06 00:00:00","6180","6154","0","0"),
("798","2036","1215","2016-04-07 00:00:00","15534","7050","0","0"),
("807","2034","1215","2016-04-07 00:00:00","3990","3138","0","0"),
("813","2035","1215","2016-04-08 00:00:00","13460","3926","0","0"),
("815","2036","1215","2016-04-08 00:00:00","17428","9577","0","0"),
("830","2036","1215","2016-04-11 00:00:00","18750","14315","0","0"),
("832","2035","1215","2016-04-11 00:00:00","17874","5749","0","0"),
("844","2035","1215","2016-04-12 00:00:00","19679","4729","0","0"),
("846","2036","1215","2016-04-12 00:00:00","4313","681","0","0"),
("857","2035","1215","2016-04-13 00:00:00","22346","9925","0","0"),
("875","2035","1215","2016-04-14 00:00:00","21084","5875","0","0"),
("878","2036","1215","2016-04-14 00:00:00","21089","16771","0","0"),
("894","2035","1215","2016-04-15 00:00:00","4887","1993","0","0"),
("895","2036","1215","2016-04-15 00:00:00","8790","6046","0","0"),
("909","2035","1215","2016-04-17 00:00:00","18868","7678","0","0"),
("912","2036","1215","2016-04-18 00:00:00","22470","12673","0","0"),
("918","2035","1215","2016-04-18 00:00:00","21654","8775","0","0"),
("930","2036","1215","2016-04-19 00:00:00","19799","12415","0","0"),
("936","2035","1215","2016-04-19 00:00:00","20781","11410","0","0"),
("941","2034","1215","2016-04-19 00:00:00","5896","1675","0","0"),
("946","2036","1215","2016-04-20 00:00:00","22847","13654","0","0"),
("954","2035","1215","2016-04-20 00:00:00","23392","11147","0","0"),
("959","2034","1215","2016-04-20 00:00:00","2340","1645","0","0"),
("964","2036","1215","2016-04-21 00:00:00","21930","14906","0","0"),
("967","2035","1215","2016-04-21 00:00:00","21677","8502","0","0"),
("979","2036","1215","2016-04-22 00:00:00","24090","26158","0","0"),
("990","2035","1215","2016-04-24 00:00:00","17696","6145","0","0"),
("994","2036","1215","2016-04-25 00:00:00","26010","16551","0","0"),
("1000","2035","1215","2016-04-25 00:00:00","23990","12199","0","0"),
("1010","2035","1215","2016-04-26 00:00:00","24323","13385","0","0"),
("1014","2036","1215","2016-04-26 00:00:00","23603","14069","0","0"),
("1041","2035","1215","2016-04-27 00:00:00","25570","18143","0","0"),
("1054","2035","1215","2016-04-28 00:00:00","21762","13709","0","0"),
("1081","2035","1215","2016-05-01 00:00:00","10166","3037","0","0"),
("1094","2035","1215","2016-05-02 00:00:00","11186","4120","0","0"),
("1099","2036","1215","2016-05-03 00:00:00","10199","5359","0","0"),
("1104","2035","1215","2016-05-03 00:00:00","24247","13325","0","0"),
("1138","2036","1215","2016-05-05 00:00:00","12436","5535","0","0"),
("1140","2035","1215","2016-05-05 00:00:00","20000","10250","0","0"),
("1151","2036","1215","2016-05-06 00:00:00","16445","12770","0","0"),
("1169","2035","1215","2016-05-08 00:00:00","6857","2030","0","0"),
("1177","2036","1215","2016-05-09 00:00:00","23407","15741","0","0"),
("1194","2036","1215","2016-05-10 00:00:00","9781","9513","0","0"),
("1221","2036","1215","2016-05-11 00:00:00","25823","15593","0","0"),
("1248","2036","1215","2016-05-12 00:00:00","2400","0","0","0"),
("1255","2036","1215","2016-05-13 00:00:00","30051","16782","0","0"),
("1267","2035","1215","2016-05-14 00:00:00","8220","2051","0","0"),
("1276","2036","1215","2016-05-16 00:00:00","18430","5905","0","0"),
("1295","2036","1215","2016-05-17 00:00:00","26416","13999","0","0"),
("1333","2036","1215","2016-05-18 00:00:00","16408","11095","0","0"),
("1339","2036","1215","2016-05-19 00:00:00","25215","15248","0","0"),
("1361","2036","1215","2016-05-20 00:00:00","22068","17698","0","0"),
("1378","2035","1215","2016-05-21 00:00:00","28726","18929","0","0"),
("1385","2036","1215","2016-05-23 00:00:00","22788","12298","0","0"),
("1389","2035","1215","2016-05-23 00:00:00","22777","8835","0","0"),
("1403","2036","1215","2016-05-24 00:00:00","77896","85361","0","0"),
("1409","2035","1215","2016-05-24 00:00:00","23778","13693","0","0"),
("1424","2036","1215","2016-05-25 00:00:00","25500","20961","0","0"),
("1428","2035","1215","2016-05-25 00:00:00","22374","6082","0","0"),
("1442","2036","1215","2016-05-26 00:00:00","26340","19416","0","0"),
("1451","2035","1215","2016-05-26 00:00:00","23388","13490","0","0"),
("1456","2032","1215","2016-05-26 00:00:00","5364","323","0","0"),
("1466","2036","1215","2016-05-27 00:00:00","24523","16879","0","0"),
("1471","2032","1215","2016-05-27 00:00:00","16453","7296","0","0"),
("1478","2035","1215","2016-05-29 00:00:00","23815","11951","0","0"),
("1479","2035","1215","2016-05-30 00:00:00","5556","2443","0","0"),
("1484","2036","1215","2016-05-31 00:00:00","81057","72779","0","0"),
("1494","2032","1215","2016-05-31 00:00:00","12238","2674","0","0"),
("1501","2035","1215","2016-05-31 00:00:00","12963","5125","0","0"),
("1505","2032","1215","2016-06-01 00:00:00","15900","5650","0","0"),
("1507","2036","1215","2016-06-01 00:00:00","14039","9314","0","0"),
("1519","2035","1215","2016-06-01 00:00:00","25350","12293","0","0"),
("1536","2036","1215","2016-06-02 00:00:00","21999","17354","0","0"),
("1543","2032","1215","2016-06-02 00:00:00","15926","5144","0","0"),
("1545","2035","1215","2016-06-02 00:00:00","20829","11423","0","0"),
("1561","2036","1215","2016-06-03 00:00:00","25770","15601","0","0"),
("1568","2032","1215","2016-06-03 00:00:00","10733","4168","0","0"),
("1582","2035","1215","2016-06-05 00:00:00","26918","22088","0","0"),
("1587","2036","1215","2016-06-06 00:00:00","7269","6449","0","0"),
("1590","2032","1215","2016-06-06 00:00:00","21467","10109","0","0"),
("1594","2035","1215","2016-06-06 00:00:00","22763","19118","0","0"),
("1608","2032","1215","2016-06-07 00:00:00","15837","5521","0","0"),
("1615","2035","1215","2016-06-07 00:00:00","22922","20995","0","0"),
("1617","2036","1215","2016-06-07 00:00:00","87719","73487","0","0"),
("1624","2032","1215","2016-06-08 00:00:00","16642","5700","0","0"),
("1631","2035","1215","2016-06-08 00:00:00","1171","667","0","0"),
("1645","2036","1215","2016-06-09 00:00:00","13536","3374","0","0"),
("1651","2032","1215","2016-06-09 00:00:00","15107","6294","0","0"),
("1656","2035","1215","2016-06-09 00:00:00","12796","13248","30","0");
INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("1672","2032","1215","2016-06-10 00:00:00","7487","2377","0","0"),
("1691","2032","1215","2016-06-13 00:00:00","18996","9617","0","0"),
("1698","2035","1215","2016-06-13 00:00:00","17905","4888","0","0"),
("1702","2035","1215","2016-06-14 00:00:00","17782","18544","0","0"),
("1714","2032","1215","2016-06-14 00:00:00","19222","5849","0","0"),
("1732","2032","1215","2016-06-15 00:00:00","9798","5035","0","0"),
("1736","2035","1215","2016-06-15 00:00:00","598","0","0","0"),
("1783","2035","1215","2016-06-19 00:00:00","10","0","0","0"),
("1795","2032","1215","2016-06-20 00:00:00","15711","5610","0","0"),
("1799","2035","1215","2016-06-20 00:00:00","21957","22807","0","0"),
("1811","2032","1215","2016-06-21 00:00:00","6387","2466","0","0"),
("1821","2035","1215","2016-06-21 00:00:00","16643","0","0","0"),
("1826","2035","1215","2016-06-22 00:00:00","8401","125","0","0"),
("1837","2032","1215","2016-06-22 00:00:00","16739","9090","0","0"),
("1859","2032","1215","2016-06-23 00:00:00","15406","5115","0","0"),
("1862","2035","1215","2016-06-23 00:00:00","625","0","0","0"),
("1894","2032","1215","2016-06-27 00:00:00","16660","6166","0","0"),
("1902","2035","1215","2016-06-27 00:00:00","4981","232","0","0"),
("1903","2036","1215","2016-06-27 00:00:00","7660","4301","0","0"),
("1919","2032","1215","2016-06-28 00:00:00","14997","6483","0","0"),
("1920","2035","1215","2016-06-28 00:00:00","23568","22360","0","0"),
("1933","2032","1215","2016-06-29 00:00:00","14009","5567","0","0"),
("1935","2035","1215","2016-06-29 00:00:00","3937","3242","0","0"),
("1957","2032","1215","2016-06-30 00:00:00","14798","4913","0","0"),
("1958","2035","1215","2016-06-30 00:00:00","19257","18025","0","0"),
("1975","2035","1215","2016-07-03 00:00:00","16292","15410","0","0"),
("1990","2032","1215","2016-07-05 00:00:00","14370","3180","0","0"),
("1992","2035","1215","2016-07-05 00:00:00","24697","23922","0","0"),
("2036","2032","1215","2016-07-07 00:00:00","14574","4590","0","0"),
("2070","2035","1215","2016-07-10 00:00:00","29004","28727","0","0"),
("2081","2032","1215","2016-07-11 00:00:00","14177","5459","0","0"),
("2108","2032","1215","2016-07-12 00:00:00","13008","2946","0","0"),
("2131","2032","1215","2016-07-13 00:00:00","2694","1088","0","0"),
("2140","2032","1215","2016-07-14 00:00:00","16090","11110","0","0"),
("2188","2032","1215","2016-07-18 00:00:00","15633","6006","0","0"),
("2207","2032","1215","2016-07-19 00:00:00","13493","5852","0","0"),
("2226","2032","1215","2016-07-20 00:00:00","15446","2955","0","0"),
("2263","2032","1215","2016-07-21 00:00:00","14000","2952","0","0"),
("2296","2036","1215","2016-07-22 00:00:00","6386","3543","0","0"),
("2320","2032","1215","2016-07-25 00:00:00","13518","1731","0","0"),
("2347","2032","1215","2016-07-26 00:00:00","14058","4811","0","0"),
("2355","2036","1215","2016-07-26 00:00:00","5400","5149","0","0"),
("2373","2032","1215","2016-07-27 00:00:00","17889","10005","0","0"),
("2398","2032","1215","2016-07-28 00:00:00","12888","3499","0","0"),
("2403","2036","1215","2016-07-28 00:00:00","11129","2404","0","0"),
("2446","2035","1215","2016-07-31 00:00:00","16921","16886","0","0"),
("2453","2036","1215","2016-08-01 00:00:00","24470","18357","0","0"),
("2462","2032","1215","2016-08-01 00:00:00","15684","2987","0","0"),
("2464","2035","1215","2016-08-01 00:00:00","27096","28348","0","0"),
("2482","2032","1215","2016-08-02 00:00:00","17620","5992","0","0"),
("2483","2035","1215","2016-08-02 00:00:00","13958","15828","0","0"),
("2491","2036","1215","2016-08-02 00:00:00","4182","3448","0","0"),
("2505","2032","1215","2016-08-03 00:00:00","14005","3633","0","0"),
("2511","2036","1215","2016-08-03 00:00:00","8760","6066","0","0"),
("2527","2036","1215","2016-08-04 00:00:00","8339","6354","0","0"),
("2532","2032","1215","2016-08-04 00:00:00","14252","3276","0","0"),
("2549","2036","1215","2016-08-05 00:00:00","27205","22662","0","0"),
("2569","2036","1215","2016-08-08 00:00:00","22004","13801","0","0"),
("2579","2031","1215","2016-08-08 00:00:00","14355","12167","0","0"),
("2584","2035","1215","2016-08-08 00:00:00","12399","10736","0","0"),
("2589","2031","1215","2016-08-09 00:00:00","22500","19318","0","0"),
("2590","2036","1215","2016-08-09 00:00:00","74949","71260","0","0"),
("2607","2035","1215","2016-08-09 00:00:00","15040","14931","0","0"),
("2614","2036","1215","2016-08-10 00:00:00","16757","9759","0","0"),
("2622","2031","1215","2016-08-10 00:00:00","23160","21400","0","0"),
("2624","2035","1215","2016-08-10 00:00:00","23741","23027","0","0"),
("2626","2032","1215","2016-08-10 00:00:00","16036","5558","0","0"),
("2638","2036","1215","2016-08-11 00:00:00","13717","10872","0","0"),
("2646","2032","1215","2016-08-11 00:00:00","6834","2358","0","0"),
("2679","2035","1215","2016-08-14 00:00:00","27658","27520","0","0"),
("2696","2035","1215","2016-08-15 00:00:00","26502","26326","0","0"),
("2698","2032","1215","2016-08-15 00:00:00","15417","6882","0","0"),
("2717","2035","1215","2016-08-16 00:00:00","14209","15083","0","0"),
("2720","2032","1215","2016-08-16 00:00:00","13356","5534","0","0"),
("2733","2036","1215","2016-08-17 00:00:00","82680","75317","0","0"),
("2744","2032","1215","2016-08-17 00:00:00","15300","3791","0","0"),
("2745","2035","1215","2016-08-17 00:00:00","14546","14373","0","0"),
("2758","2036","1215","2016-08-18 00:00:00","85860","21266","0","0"),
("2767","2035","1215","2016-08-18 00:00:00","26926","26816","0","0"),
("2770","2032","1215","2016-08-18 00:00:00","15690","5673","0","0"),
("2782","2036","1215","2016-08-19 00:00:00","25715","20690","0","0"),
("2802","2035","1215","2016-08-21 00:00:00","1060","298","0","0"),
("2805","2036","1215","2016-08-22 00:00:00","84086","74571","0","0"),
("2813","2032","1215","2016-08-22 00:00:00","15974","6742","0","0"),
("2814","2035","1215","2016-08-22 00:00:00","16140","16081","0","0"),
("2829","2036","1215","2016-08-23 00:00:00","26279","20415","0","0"),
("2839","2035","1215","2016-08-23 00:00:00","26764","26829","0","0"),
("2841","2032","1215","2016-08-23 00:00:00","16298","6939","0","0"),
("2851","2036","1215","2016-08-24 00:00:00","75980","71552","0","0"),
("2862","2032","1215","2016-08-24 00:00:00","16299","4635","0","0"),
("2864","2035","1215","2016-08-24 00:00:00","25187","27518","0","0"),
("2879","2036","1215","2016-08-25 00:00:00","26820","17173","0","0"),
("2889","2032","1215","2016-08-25 00:00:00","14391","5784","0","0"),
("2904","2036","1215","2016-08-26 00:00:00","29125","22495","0","0"),
("2935","2036","1215","2016-08-29 00:00:00","83880","79182","0","0"),
("2943","2032","1215","2016-08-29 00:00:00","14230","6310","0","0"),
("2959","2036","1215","2016-08-30 00:00:00","83212","78205","0","0"),
("2972","2032","1215","2016-08-30 00:00:00","16096","6192","0","0"),
("2989","2036","1215","2016-08-31 00:00:00","7146","3949","0","0"),
("3001","2032","1215","2016-08-31 00:00:00","16370","3414","0","0"),
("3011","2036","1215","2016-09-01 00:00:00","30411","23064","0","0"),
("3023","2032","1215","2016-09-01 00:00:00","13032","3352","0","0"),
("3025","2031","1215","2016-09-01 00:00:00","9441","329","0","0"),
("3036","2036","1215","2016-09-02 00:00:00","18048","12889","0","0"),
("3059","2036","1215","2016-09-06 00:00:00","29127","19545","0","0"),
("3066","2031","1215","2016-09-06 00:00:00","14309","2060","0","0"),
("3068","2032","1215","2016-09-06 00:00:00","13235","3604","0","0"),
("3082","2036","1215","2016-09-07 00:00:00","80537","73068","0","0"),
("3092","2031","1215","2016-09-07 00:00:00","14688","2069","0","0"),
("3093","2032","1215","2016-09-07 00:00:00","17458","9223","0","0"),
("3112","2036","1215","2016-09-08 00:00:00","31225","22996","0","0"),
("3122","2032","1215","2016-09-08 00:00:00","13593","4558","0","0"),
("3123","2031","1215","2016-09-08 00:00:00","12950","2641","0","0"),
("3135","2036","1215","2016-09-09 00:00:00","23640","16947","0","0"),
("3165","2036","1215","2016-09-12 00:00:00","26961","22115","0","0"),
("3173","2032","1215","2016-09-12 00:00:00","16418","7082","0","0"),
("3175","2031","1215","2016-09-12 00:00:00","14768","2214","0","0"),
("3192","2036","1215","2016-09-13 00:00:00","84330","77434","0","0"),
("3202","2032","1215","2016-09-13 00:00:00","14569","5484","0","0"),
("3203","2031","1215","2016-09-13 00:00:00","13233","3657","0","0"),
("3213","2036","1215","2016-09-14 00:00:00","29997","21189","0","0"),
("3222","2031","1215","2016-09-14 00:00:00","14113","3698","0","0"),
("3225","2032","1215","2016-09-14 00:00:00","13822","4260","0","0"),
("3244","2036","1215","2016-09-15 00:00:00","85858","18030","0","0"),
("3251","2032","1215","2016-09-15 00:00:00","15504","4995","0","0"),
("3262","2032","1215","2016-09-16 00:00:00","10008","1994","0","0"),
("3264","2031","1215","2016-09-16 00:00:00","13285","2202","0","0"),
("3265","2036","1215","2016-09-16 00:00:00","5219","0","0","0"),
("3281","2036","1215","2016-09-19 00:00:00","28558","19558","0","0"),
("3285","2032","1215","2016-09-19 00:00:00","15612","4056","0","0"),
("3286","2031","1215","2016-09-19 00:00:00","15809","4130","0","0"),
("3295","2036","1215","2016-09-20 00:00:00","79583","72564","0","0"),
("3301","2031","1215","2016-09-20 00:00:00","14995","3592","0","0"),
("3302","2032","1215","2016-09-20 00:00:00","13036","3399","0","0"),
("3305","2035","1215","2016-09-20 00:00:00","30","0","0","0"),
("3311","2036","1215","2016-09-21 00:00:00","81011","75934","0","0"),
("3313","2032","1215","2016-09-21 00:00:00","11676","4326","0","0"),
("3316","2031","1215","2016-09-21 00:00:00","10557","1447","0","0"),
("3325","2036","1215","2016-09-22 00:00:00","73729","18539","0","0"),
("3330","2031","1215","2016-09-22 00:00:00","13574","2709","0","0"),
("3331","2032","1215","2016-09-22 00:00:00","12900","3062","0","0"),
("3344","2036","1215","2016-09-23 00:00:00","162899","17748","0","0"),
("3360","2036","1215","2016-09-26 00:00:00","81697","76698","0","0"),
("3368","2032","1215","2016-09-26 00:00:00","13518","3644","0","0"),
("3370","2031","1215","2016-09-26 00:00:00","11095","3336","0","0"),
("3374","2036","1215","2016-09-27 00:00:00","82106","21281","0","0"),
("3380","2032","1215","2016-09-27 00:00:00","14236","4145","0","0"),
("3381","2031","1215","2016-09-27 00:00:00","15878","3222","0","0"),
("3390","2036","1215","2016-09-28 00:00:00","33044","20504","0","0");
INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("3396","2031","1215","2016-09-28 00:00:00","14357","3698","0","0"),
("3397","2032","1215","2016-09-28 00:00:00","13510","4666","0","0"),
("3409","2036","1215","2016-09-29 00:00:00","67213","19177","0","0"),
("3413","2031","1215","2016-09-29 00:00:00","15621","4657","0","0"),
("3415","2032","1215","2016-09-29 00:00:00","18252","8348","0","0"),
("3424","2036","1215","2016-09-30 00:00:00","29053","24527","0","0"),
("3443","2036","1215","2016-10-03 00:00:00","38465","18501","0","0"),
("3447","2032","1215","2016-10-03 00:00:00","14723","3973","0","0"),
("3448","2031","1215","2016-10-03 00:00:00","12820","3967","0","0"),
("3459","2036","1215","2016-10-04 00:00:00","64330","26120","0","0"),
("3461","2032","1215","2016-10-04 00:00:00","16933","6150","0","0"),
("3463","2031","1215","2016-10-04 00:00:00","8908","2117","0","0"),
("3476","2036","1215","2016-10-05 00:00:00","29012","19954","0","0"),
("3480","2032","1215","2016-10-05 00:00:00","17079","5783","0","0"),
("3495","2036","1215","2016-10-06 00:00:00","32357","19754","0","0"),
("3500","2031","1215","2016-10-06 00:00:00","14605","5506","0","0"),
("3502","2032","1215","2016-10-06 00:00:00","16016","6033","0","0"),
("3520","2036","1215","2016-10-07 00:00:00","26595","23309","0","0"),
("3526","2031","1215","2016-10-07 00:00:00","4498","1070","0","0"),
("3550","2032","1215","2016-10-10 00:00:00","7598","2015","0","0"),
("3552","2031","1215","2016-10-10 00:00:00","5129","2146","0","0"),
("3568","2031","1215","2016-10-11 00:00:00","15099","5159","0","0"),
("3573","2032","1215","2016-10-11 00:00:00","19952","8618","0","0"),
("3582","2036","1215","2016-10-11 00:00:00","64468","66575","0","0"),
("3589","2036","1215","2016-10-12 00:00:00","29824","21446","0","0"),
("3592","2031","1215","2016-10-12 00:00:00","17563","9037","0","0"),
("3600","2032","1215","2016-10-12 00:00:00","15995","5947","0","0"),
("3613","2036","1215","2016-10-13 00:00:00","83067","75535","0","0"),
("3614","2031","1215","2016-10-13 00:00:00","17208","9422","0","0"),
("3618","2032","1215","2016-10-13 00:00:00","14534","4590","0","0"),
("3636","2036","1215","2016-10-14 00:00:00","26630","20374","0","0"),
("3640","2032","1215","2016-10-14 00:00:00","6826","3126","0","0"),
("3660","2036","1215","2016-10-17 00:00:00","84638","76457","0","0"),
("3667","2031","1215","2016-10-17 00:00:00","17880","7973","0","0"),
("3669","2032","1215","2016-10-17 00:00:00","12342","4825","0","0"),
("3671","2034","1215","2016-10-17 00:00:00","3630","2498","0","0"),
("3682","2036","1215","2016-10-18 00:00:00","29298","23949","0","0"),
("3686","2032","1215","2016-10-18 00:00:00","17136","9191","0","0"),
("3689","2031","1215","2016-10-18 00:00:00","16890","8143","0","0"),
("3703","2036","1215","2016-10-19 00:00:00","77988","84257","0","0"),
("3706","2031","1215","2016-10-19 00:00:00","16977","6807","0","0"),
("3708","2032","1215","2016-10-19 00:00:00","13692","4904","0","0"),
("3717","2036","1215","2016-10-20 00:00:00","71297","18249","0","0"),
("3720","2031","1215","2016-10-20 00:00:00","14755","4652","0","0"),
("3723","2032","1215","2016-10-20 00:00:00","15783","4801","0","0"),
("3731","2036","1215","2016-10-21 00:00:00","149304","15142","0","0"),
("3747","2036","1215","2016-10-24 00:00:00","64578","19881","0","0"),
("3752","2032","1215","2016-10-24 00:00:00","13554","5658","0","0"),
("3754","2031","1215","2016-10-24 00:00:00","13148","7252","0","0"),
("3762","2036","1215","2016-10-25 00:00:00","30990","23236","0","0"),
("3766","2031","1215","2016-10-25 00:00:00","11116","4728","0","0"),
("3770","2034","1215","2016-10-25 00:00:00","1198","352","0","0"),
("3771","2032","1215","2016-10-25 00:00:00","12514","4989","0","0"),
("3777","2036","1215","2016-10-26 00:00:00","84666","76472","0","0"),
("3779","2031","1215","2016-10-26 00:00:00","14639","6270","0","0"),
("3782","2032","1215","2016-10-26 00:00:00","19857","12344","0","0"),
("3792","2036","1215","2016-10-27 00:00:00","21472","14239","0","0"),
("3798","2032","1215","2016-10-27 00:00:00","16542","9623","0","0"),
("3799","2031","1215","2016-10-27 00:00:00","15304","4878","0","0"),
("3806","2036","1215","2016-10-28 00:00:00","27922","24203","0","0"),
("3808","2031","1215","2016-10-28 00:00:00","5377","5749","0","0"),
("3812","2032","1215","2016-10-28 00:00:00","10510","5720","0","0"),
("3830","2031","1215","2016-10-31 00:00:00","14137","4909","0","0"),
("3833","2036","1215","2016-10-31 00:00:00","27268","77030","0","0"),
("3835","2032","1215","2016-10-31 00:00:00","13428","3175","0","0"),
("3844","2036","1215","2016-11-01 00:00:00","85493","160858","0","0"),
("3850","2031","1215","2016-11-01 00:00:00","15056","3918","0","0"),
("3851","2034","1215","2016-11-01 00:00:00","13110","1571","0","0"),
("3855","2032","1215","2016-11-01 00:00:00","16923","5977","0","0"),
("3861","2036","1215","2016-11-02 00:00:00","30423","19158","0","0"),
("3865","2031","1215","2016-11-02 00:00:00","16368","6282","0","0"),
("3867","2034","1215","2016-11-02 00:00:00","12660","2556","0","0"),
("3870","2032","1215","2016-11-02 00:00:00","13159","3461","0","0"),
("3878","2036","1215","2016-11-03 00:00:00","28417","26765","0","0"),
("3881","2031","1215","2016-11-03 00:00:00","14531","6024","0","0"),
("3886","2032","1215","2016-11-03 00:00:00","11627","3979","0","0"),
("3900","2036","1215","2016-11-04 00:00:00","24264","20473","0","0"),
("3903","2032","1215","2016-11-04 00:00:00","7441","3640","0","0"),
("3918","2036","1215","2016-11-07 00:00:00","33112","21764","0","0"),
("3920","2031","1215","2016-11-07 00:00:00","16319","7487","0","0"),
("3921","2032","1215","2016-11-07 00:00:00","14048","5505","0","0"),
("3927","2034","1215","2016-11-07 00:00:00","11850","2004","0","0"),
("3939","2031","1215","2016-11-08 00:00:00","15899","5943","0","0"),
("3940","2036","1215","2016-11-08 00:00:00","67138","17257","0","0"),
("3944","2032","1215","2016-11-08 00:00:00","25016","12622","0","0"),
("3945","2034","1215","2016-11-08 00:00:00","39240","9103","0","0"),
("3958","2036","1215","2016-11-09 00:00:00","29256","21463","0","0"),
("3963","2031","1215","2016-11-09 00:00:00","14369","5225","0","0"),
("3965","2034","1215","2016-11-09 00:00:00","14513","4133","0","0"),
("3966","2032","1215","2016-11-09 00:00:00","17817","7244","0","0"),
("3988","2036","1215","2016-11-10 00:00:00","30149","20907","0","0"),
("3990","2031","1215","2016-11-10 00:00:00","15930","7699","0","0"),
("3993","2032","1215","2016-11-10 00:00:00","17183","5554","0","0"),
("3996","2034","1215","2016-11-10 00:00:00","13109","3084","0","0"),
("4014","2036","1215","2016-11-11 00:00:00","29865","23002","0","0"),
("4040","2036","1215","2016-11-14 00:00:00","82891","77938","0","0"),
("4041","2031","1215","2016-11-14 00:00:00","8130","6293","0","0"),
("4043","2032","1215","2016-11-14 00:00:00","14997","3133","0","0"),
("4047","2034","1215","2016-11-14 00:00:00","17520","8061","0","0"),
("4056","2036","1215","2016-11-15 00:00:00","30566","23396","0","0"),
("4058","2031","1215","2016-11-15 00:00:00","19828","7177","0","0"),
("4065","2034","1215","2016-11-15 00:00:00","9715","1913","0","0"),
("4066","2032","1215","2016-11-15 00:00:00","15816","7912","0","0"),
("4080","2036","1215","2016-11-16 00:00:00","88657","84217","0","0"),
("4081","2031","1215","2016-11-16 00:00:00","21415","8909","0","0"),
("4086","2032","1215","2016-11-16 00:00:00","15023","4600","0","0"),
("4087","2034","1215","2016-11-16 00:00:00","16857","6630","0","0"),
("4096","2036","1215","2016-11-17 00:00:00","82755","75918","0","0"),
("4097","2031","1215","2016-11-17 00:00:00","16155","6125","0","0"),
("4100","2032","1215","2016-11-17 00:00:00","15762","7383","0","0"),
("4101","2034","1215","2016-11-17 00:00:00","14098","5551","0","0"),
("4122","2036","1215","2016-11-18 00:00:00","26664","16548","0","0"),
("4141","2036","1215","2016-11-21 00:00:00","84474","77129","0","0"),
("4143","2031","1215","2016-11-21 00:00:00","9164","5490","0","0"),
("4148","2032","1215","2016-11-21 00:00:00","8914","5896","0","0"),
("4149","2034","1215","2016-11-21 00:00:00","14005","6398","0","0"),
("4156","2036","1215","2016-11-22 00:00:00","82542","75650","0","0"),
("4161","2031","1215","2016-11-22 00:00:00","15088","7424","0","0"),
("4162","2032","1215","2016-11-22 00:00:00","16256","12108","0","0"),
("4164","2034","1215","2016-11-22 00:00:00","15839","7310","0","0"),
("4178","2036","1215","2016-11-23 00:00:00","3976","884","0","0"),
("4203","2036","1215","2016-11-28 00:00:00","81709","76090","0","0"),
("4205","2034","1215","2016-11-28 00:00:00","14737","6999","0","0"),
("4206","2032","1215","2016-11-28 00:00:00","17999","10055","0","0"),
("4217","2036","1215","2016-11-29 00:00:00","84856","74756","0","0"),
("4222","2034","1215","2016-11-29 00:00:00","13109","5801","0","0"),
("4227","2032","1215","2016-11-29 00:00:00","16168","8780","0","0"),
("4233","2036","1215","2016-11-30 00:00:00","29650","17841","0","0"),
("4237","2032","1215","2016-11-30 00:00:00","16658","8122","0","0"),
("4238","2034","1215","2016-11-30 00:00:00","14790","4363","0","0"),
("4245","2032","1215","2016-12-01 00:00:00","17426","4517","0","0"),
("4246","2036","1215","2016-12-01 00:00:00","27851","18831","0","0"),
("4253","2034","1215","2016-12-01 00:00:00","16650","7517","0","0"),
("4270","2036","1215","2016-12-02 00:00:00","29171","21232","0","0"),
("4303","2031","1215","2016-12-05 00:00:00","17037","10463","0","0"),
("4307","2034","1215","2016-12-05 00:00:00","2368","429","0","0"),
("4308","2032","1215","2016-12-05 00:00:00","14069","3980","0","0"),
("4316","2036","1215","2016-12-06 00:00:00","29719","22453","0","0"),
("4319","2034","1215","2016-12-06 00:00:00","10140","3246","0","0"),
("4320","2032","1215","2016-12-06 00:00:00","19800","13691","0","0"),
("4327","2036","1215","2016-12-07 00:00:00","20404","15323","0","0"),
("4329","2031","1215","2016-12-07 00:00:00","15449","7725","0","0"),
("4331","2032","1215","2016-12-07 00:00:00","14006","6129","0","0"),
("4332","2034","1215","2016-12-07 00:00:00","8097","824","0","0"),
("4339","2036","1215","2016-12-08 00:00:00","76263","16474","0","0"),
("4340","2031","1215","2016-12-08 00:00:00","15266","6914","0","0"),
("4343","2034","1215","2016-12-08 00:00:00","11155","2972","0","0"),
("4345","2032","1215","2016-12-08 00:00:00","13169","6694","0","0"),
("4356","2036","1215","2016-12-09 00:00:00","27410","19766","0","0");
INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("4357","2031","1215","2016-12-09 00:00:00","15470","5668","0","0"),
("4382","2036","1215","2016-12-12 00:00:00","13320","10232","0","0"),
("4384","2032","1215","2016-12-12 00:00:00","17728","7090","0","0"),
("4385","2034","1215","2016-12-12 00:00:00","14519","5683","0","0"),
("4387","2031","1215","2016-12-12 00:00:00","14664","7579","0","0"),
("4397","2036","1215","2016-12-13 00:00:00","22593","20578","0","0"),
("4398","2031","1215","2016-12-13 00:00:00","15750","7977","0","0"),
("4402","2034","1215","2016-12-13 00:00:00","12209","3925","0","0"),
("4403","2032","1215","2016-12-13 00:00:00","13328","4702","0","0"),
("4407","2036","1215","2016-12-14 00:00:00","28225","20529","0","0"),
("4410","2031","1215","2016-12-14 00:00:00","9630","4685","0","0"),
("4412","2034","1215","2016-12-14 00:00:00","35129","18365","0","0"),
("4415","2032","1215","2016-12-14 00:00:00","15606","8337","0","0"),
("4420","2036","1215","2016-12-15 00:00:00","30804","19912","0","0"),
("4421","2031","1215","2016-12-15 00:00:00","13980","5640","0","0"),
("4424","2032","1215","2016-12-15 00:00:00","19290","10166","0","0"),
("4425","2034","1215","2016-12-15 00:00:00","14339","6637","0","0"),
("4442","2036","1215","2016-12-16 00:00:00","23103","20610","0","0"),
("4446","2031","1215","2016-12-16 00:00:00","5248","1777","0","0"),
("4454","2036","1215","2016-12-19 00:00:00","31947","19441","0","0"),
("4456","2031","1215","2016-12-19 00:00:00","11654","3403","0","0"),
("4457","2032","1215","2016-12-19 00:00:00","11190","3143","0","0"),
("4459","2034","1215","2016-12-19 00:00:00","10380","3861","0","0"),
("4467","2036","1215","2016-12-20 00:00:00","31351","19162","0","0"),
("4469","2031","1215","2016-12-20 00:00:00","15942","4813","0","0"),
("4471","2034","1215","2016-12-20 00:00:00","16380","6877","0","0"),
("4472","2032","1215","2016-12-20 00:00:00","15150","8003","0","0"),
("4481","2036","1215","2016-12-21 00:00:00","31206","23261","0","0"),
("4485","2031","1215","2016-12-21 00:00:00","14579","7925","0","0"),
("4486","2034","1215","2016-12-21 00:00:00","12390","4785","0","0"),
("4487","2032","1215","2016-12-21 00:00:00","17370","5477","0","0"),
("4497","2036","1215","2016-12-22 00:00:00","29409","22558","0","0"),
("4499","2031","1215","2016-12-22 00:00:00","12075","4657","0","0"),
("4500","2032","1215","2016-12-22 00:00:00","18865","10952","0","0"),
("4501","2034","1215","2016-12-22 00:00:00","14876","5317","0","0"),
("4525","2031","1215","2016-12-27 00:00:00","16295","8167","0","0"),
("4527","2034","1215","2016-12-27 00:00:00","15808","6678","0","0"),
("4528","2032","1215","2016-12-27 00:00:00","16709","10998","0","0"),
("4535","2031","1215","2016-12-28 00:00:00","15059","7283","0","0"),
("4538","2034","1215","2016-12-28 00:00:00","46488","21566","0","0"),
("4539","2032","1215","2016-12-28 00:00:00","14097","6582","0","0"),
("4543","2034","1215","2016-12-29 00:00:00","40079","32293","0","0"),
("4545","2032","1215","2016-12-29 00:00:00","3359","2091","0","0"),
("4550","2032","1215","2016-12-30 00:00:00","3951","0","0","0"),
("4554","2034","1215","2016-12-30 00:00:00","300","0","0","0"),
("4562","2032","1215","2017-01-01 00:00:00","780","370","0","0"),
("4563","2032","1215","2017-01-02 00:00:00","0","0","0","0"),
("4572","2036","1215","2017-01-03 00:00:00","31332","22612","0","0"),
("4575","2032","1215","2017-01-03 00:00:00","15387","7295","0","0"),
("4577","2031","1215","2017-01-03 00:00:00","14460","6867","0","0"),
("4583","2032","1215","2017-01-04 00:00:00","21718","12192","0","0"),
("4586","2036","1215","2017-01-04 00:00:00","29223","14718","0","0"),
("4588","2034","1215","2017-01-04 00:00:00","10230","2563","0","0"),
("4589","2031","1215","2017-01-04 00:00:00","11878","4166","0","0"),
("4596","2032","1215","2017-01-05 00:00:00","18898","11065","0","0"),
("4597","2036","1215","2017-01-05 00:00:00","28560","22380","0","0"),
("4609","2036","1215","2017-01-06 00:00:00","26527","20995","0","0"),
("4632","2036","1215","2017-01-09 00:00:00","33988","25780","0","0"),
("4634","2032","1215","2017-01-09 00:00:00","15297","7691","0","0"),
("4635","2031","1215","2017-01-09 00:00:00","12538","4125","0","0"),
("4641","2036","1215","2017-01-10 00:00:00","30164","25287","0","0"),
("4644","2031","1215","2017-01-10 00:00:00","11190","3878","0","0"),
("4646","2032","1215","2017-01-10 00:00:00","17850","10396","0","0"),
("4653","2031","1215","2017-01-11 00:00:00","17874","8354","0","0"),
("4654","2036","1215","2017-01-11 00:00:00","23394","21277","0","0"),
("4656","2032","1215","2017-01-11 00:00:00","16800","9144","0","0"),
("4667","2032","1215","2017-01-12 00:00:00","14700","5058","0","0"),
("4680","2036","1215","2017-01-16 00:00:00","30856","21491","0","0"),
("4682","2032","1215","2017-01-16 00:00:00","17686","4621","0","0"),
("4686","2036","1215","2017-01-17 00:00:00","29015","18297","0","0"),
("4690","2032","1215","2017-01-17 00:00:00","17486","8189","0","0"),
("4694","2036","1215","2017-01-18 00:00:00","31285","22262","0","0"),
("4698","2032","1215","2017-01-18 00:00:00","17604","7743","0","0"),
("4699","2034","1215","2017-01-18 00:00:00","2970","1565","0","0"),
("4704","2036","1215","2017-01-19 00:00:00","70279","20120","0","0"),
("4708","2032","1215","2017-01-19 00:00:00","13587","4624","0","0"),
("4710","2036","1215","2017-01-20 00:00:00","30066","22955","0","0"),
("4718","2036","1215","2017-01-23 00:00:00","85348","75348","0","0"),
("4720","2032","1215","2017-01-23 00:00:00","13825","5243","0","0"),
("4722","2034","1215","2017-01-23 00:00:00","11909","1897","0","0"),
("4728","2036","1215","2017-01-24 00:00:00","31322","21307","0","0"),
("4731","2032","1215","2017-01-24 00:00:00","14932","4181","0","0"),
("4735","2036","1215","2017-01-25 00:00:00","40844","21385","0","0"),
("4737","2032","1215","2017-01-25 00:00:00","13050","4712","0","0"),
("4738","2034","1215","2017-01-25 00:00:00","15060","3924","0","0"),
("4745","2036","1215","2017-01-26 00:00:00","69743","75958","0","0"),
("4748","2032","1215","2017-01-26 00:00:00","15446","3939","0","0"),
("4753","2036","1215","2017-01-27 00:00:00","149674","22382","0","0"),
("4763","2036","1215","2017-01-30 00:00:00","83198","77901","0","0"),
("4766","2032","1215","2017-01-30 00:00:00","9804","2579","0","0"),
("4767","2034","1215","2017-01-30 00:00:00","10888","2346","0","0"),
("4772","2036","1215","2017-01-31 00:00:00","85800","77813","0","0"),
("4773","2031","1215","2017-01-31 00:00:00","14839","5365","0","0"),
("4774","2032","1215","2017-01-31 00:00:00","11708","4878","0","0"),
("4779","2036","1215","2017-02-01 00:00:00","83810","24040","0","0"),
("4780","2032","1215","2017-02-01 00:00:00","14968","5893","0","0"),
("4785","2036","1215","2017-02-02 00:00:00","32018","23499","0","0"),
("4787","2032","1215","2017-02-02 00:00:00","15268","5874","0","0"),
("4791","2036","1215","2017-02-03 00:00:00","155169","20509","0","0"),
("4802","2036","1215","2017-02-06 00:00:00","24201","19973","0","0"),
("4805","2032","1215","2017-02-06 00:00:00","13409","4366","0","0"),
("4813","2036","1215","2017-02-07 00:00:00","83680","83563","0","0"),
("4816","2032","1215","2017-02-07 00:00:00","12479","5713","0","0"),
("4823","2036","1215","2017-02-08 00:00:00","66895","79440","0","0"),
("4828","2032","1215","2017-02-08 00:00:00","16100","7076","0","0"),
("4833","2036","1215","2017-02-09 00:00:00","27116","15871","0","0"),
("4835","2032","1215","2017-02-09 00:00:00","17435","8845","0","0"),
("4841","2036","1215","2017-02-10 00:00:00","168285","14486","0","0"),
("4852","2036","1215","2017-02-13 00:00:00","27782","21914","0","0"),
("4857","2032","1215","2017-02-13 00:00:00","16740","7489","0","0"),
("4862","2036","1215","2017-02-14 00:00:00","78575","19670","0","0"),
("4866","2032","1215","2017-02-14 00:00:00","14606","6173","0","0"),
("4874","2036","1215","2017-02-15 00:00:00","79795","19173","0","0"),
("4876","2032","1215","2017-02-15 00:00:00","13530","4455","0","0"),
("4885","2036","1215","2017-02-16 00:00:00","83753","21960","0","0"),
("4889","2032","1215","2017-02-16 00:00:00","13372","4840","0","0"),
("4895","2036","1215","2017-02-17 00:00:00","150480","9646","0","0"),
("4905","2036","1215","2017-02-20 00:00:00","66176","77412","0","0"),
("4910","2036","1215","2017-02-21 00:00:00","85731","78236","0","0"),
("4917","2036","1215","2017-02-22 00:00:00","81376","76565","0","0"),
("4919","2032","1215","2017-02-22 00:00:00","15840","6215","0","0"),
("4926","2036","1215","2017-02-23 00:00:00","83722","78083","0","0"),
("4929","2032","1215","2017-02-23 00:00:00","13824","7800","0","0"),
("4933","2036","1215","2017-02-24 00:00:00","152940","22564","0","0"),
("4936","2032","1215","2017-02-24 00:00:00","4680","1742","0","0"),
("4942","2036","1215","2017-02-27 00:00:00","75271","76292","0","0"),
("4944","2032","1215","2017-02-27 00:00:00","13795","5092","0","0"),
("4946","2034","1215","2017-02-27 00:00:00","9540","3135","0","0"),
("4952","2036","1215","2017-02-28 00:00:00","86815","77712","0","0"),
("4954","2034","1215","2017-02-28 00:00:00","15342","7887","0","0"),
("4957","2032","1215","2017-02-28 00:00:00","12092","4163","0","0"),
("4964","2036","1215","2017-03-01 00:00:00","41514","21270","0","0"),
("4966","2034","1215","2017-03-01 00:00:00","11243","4804","0","0"),
("4967","2032","1215","2017-03-01 00:00:00","14423","5713","0","0"),
("4972","2036","1215","2017-03-02 00:00:00","79744","74194","0","0"),
("4974","2034","1215","2017-03-02 00:00:00","13310","4578","0","0"),
("4976","2032","1215","2017-03-02 00:00:00","10799","2940","0","0"),
("4981","2036","1215","2017-03-03 00:00:00","30611","26906","0","0"),
("4991","2036","1215","2017-03-06 00:00:00","76939","14570","0","0"),
("4992","2034","1215","2017-03-06 00:00:00","11766","5087","0","0"),
("4994","2032","1215","2017-03-06 00:00:00","12914","4313","0","0"),
("4999","2036","1215","2017-03-07 00:00:00","80499","18524","0","0"),
("5002","2034","1215","2017-03-07 00:00:00","12654","4526","0","0"),
("5004","2032","1215","2017-03-07 00:00:00","13225","3746","0","0"),
("5007","2036","1215","2017-03-08 00:00:00","81941","74433","0","0"),
("5008","2031","1215","2017-03-08 00:00:00","25830","23347","0","0"),
("5010","2034","1215","2017-03-08 00:00:00","14695","5596","0","0"),
("5011","2032","1215","2017-03-08 00:00:00","14552","7011","0","0"),
("5019","2036","1215","2017-03-09 00:00:00","28532","14955","0","0");
INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("5020","2031","1215","2017-03-09 00:00:00","21660","20916","0","0"),
("5022","2034","1215","2017-03-09 00:00:00","15499","7265","0","0"),
("5024","2032","1215","2017-03-09 00:00:00","13050","4101","0","0"),
("5031","2036","1215","2017-03-10 00:00:00","132274","17955","0","0"),
("5035","2031","1215","2017-03-10 00:00:00","8402","4269","0","0"),
("5041","2036","1215","2017-03-13 00:00:00","73549","72203","0","0"),
("5042","2031","1215","2017-03-13 00:00:00","74679","73555","0","0"),
("5049","2032","1215","2017-03-13 00:00:00","15720","8116","0","0"),
("5054","2036","1215","2017-03-14 00:00:00","82294","18005","0","0"),
("5055","2031","1215","2017-03-14 00:00:00","82279","73628","0","0"),
("5060","2032","1215","2017-03-14 00:00:00","14487","4729","0","0"),
("5063","2031","1215","2017-03-15 00:00:00","84112","75896","0","0"),
("5065","2036","1215","2017-03-15 00:00:00","68618","17564","0","0"),
("5068","2032","1215","2017-03-15 00:00:00","15719","5923","0","0"),
("5077","2031","1215","2017-03-16 00:00:00","20520","17798","0","0"),
("5078","2036","1215","2017-03-16 00:00:00","40889","18151","0","0"),
("5080","2032","1215","2017-03-16 00:00:00","14428","6141","0","0"),
("5099","2032","1215","2017-03-20 00:00:00","14407","6514","0","0"),
("5102","2036","1215","2017-03-21 00:00:00","81808","76207","0","0"),
("5104","2031","1215","2017-03-21 00:00:00","29729","23658","0","0"),
("5106","2032","1215","2017-03-21 00:00:00","15778","9014","0","0"),
("5109","2036","1215","2017-03-22 00:00:00","83214","21129","0","0"),
("5111","2031","1215","2017-03-22 00:00:00","29490","24434","0","0"),
("5113","2032","1215","2017-03-22 00:00:00","10669","4087","0","0"),
("5114","2036","1215","2017-03-23 00:00:00","85129","80929","0","0"),
("5115","2031","1215","2017-03-23 00:00:00","21657","12029","0","0"),
("5117","2032","1215","2017-03-23 00:00:00","16851","6400","0","0"),
("5119","2036","1215","2017-03-24 00:00:00","175757","15217","0","0"),
("5120","2031","1215","2017-03-24 00:00:00","25590","24992","0","0"),
("5126","2031","1215","2017-03-27 00:00:00","76234","177050","0","0"),
("5129","2032","1215","2017-03-27 00:00:00","15778","8665","0","0"),
("5131","2036","1215","2017-03-27 00:00:00","69161","69185","0","0"),
("5133","2031","1215","2017-03-28 00:00:00","30270","25528","0","0"),
("5134","2036","1215","2017-03-28 00:00:00","87716","82780","0","0"),
("5136","2032","1215","2017-03-28 00:00:00","14129","5819","0","0"),
("5140","2031","1215","2017-03-29 00:00:00","102303","182909","0","0"),
("5141","2036","1215","2017-03-29 00:00:00","66046","77013","0","0"),
("5142","2032","1215","2017-03-29 00:00:00","15864","9834","0","0"),
("5148","2031","1215","2017-03-30 00:00:00","39636","174263","0","0"),
("5149","2036","1215","2017-03-30 00:00:00","78227","74730","0","0"),
("5151","2032","1215","2017-03-30 00:00:00","14557","6342","0","0"),
("5156","2031","1215","2017-03-31 00:00:00","29340","30476","0","0"),
("5157","2036","1215","2017-03-31 00:00:00","147892","15386","0","0"),
("5161","2036","1215","2017-04-03 00:00:00","71927","80796","0","0"),
("5165","2032","1215","2017-04-03 00:00:00","14526","4227","0","0"),
("5170","2036","1215","2017-04-04 00:00:00","27204","23909","0","0"),
("5175","2032","1215","2017-04-04 00:00:00","9090","3303","0","0"),
("5179","2036","1215","2017-04-05 00:00:00","27976","20289","0","0"),
("5183","2032","1215","2017-04-05 00:00:00","14865","7436","0","0"),
("5186","2036","1215","2017-04-06 00:00:00","85106","79268","0","0"),
("5191","2032","1215","2017-04-06 00:00:00","15818","7012","0","0"),
("5195","2036","1215","2017-04-07 00:00:00","27158","19919","0","0"),
("5197","2031","1215","2017-04-07 00:00:00","2490","1823","0","0"),
("5207","2036","1215","2017-04-10 00:00:00","31552","20956","0","0"),
("5210","2031","1215","2017-04-10 00:00:00","15540","3423","0","0"),
("5212","2032","1215","2017-04-10 00:00:00","12179","6331","0","0"),
("5216","2036","1215","2017-04-11 00:00:00","42635","73808","0","0"),
("5219","2031","1215","2017-04-11 00:00:00","15750","4840","0","0"),
("5220","2032","1215","2017-04-11 00:00:00","13320","6842","0","0"),
("5227","2034","1215","2017-04-11 00:00:00","60","0","0","0"),
("5228","2036","1215","2017-04-12 00:00:00","81485","18204","0","0"),
("5234","2031","1215","2017-04-12 00:00:00","16050","7015","0","0"),
("5240","2036","1215","2017-04-13 00:00:00","32792","24200","0","0"),
("5243","2031","1215","2017-04-13 00:00:00","16500","8528","0","0"),
("5252","2036","1215","2017-04-14 00:00:00","66187","11387","0","0"),
("5262","2036","1215","2017-04-17 00:00:00","40535","73901","0","0"),
("5268","2032","1215","2017-04-17 00:00:00","14010","6777","0","0"),
("5269","2031","1215","2017-04-17 00:00:00","14490","6163","0","0"),
("5278","2036","1215","2017-04-18 00:00:00","29653","19691","0","0"),
("5283","2032","1215","2017-04-18 00:00:00","14250","6650","0","0"),
("5286","2031","1215","2017-04-18 00:00:00","10650","5082","0","0"),
("5290","2036","1215","2017-04-19 00:00:00","80693","23238","0","0"),
("5295","2032","1215","2017-04-19 00:00:00","15180","6387","0","0"),
("5298","2031","1215","2017-04-19 00:00:00","10889","8698","0","0"),
("5301","2036","1215","2017-04-20 00:00:00","81905","21183","0","0"),
("5304","2032","1215","2017-04-20 00:00:00","15090","7296","0","0"),
("5306","2031","1215","2017-04-20 00:00:00","10105","4941","0","0"),
("5313","2036","1215","2017-04-21 00:00:00","97113","250681","0","0"),
("5324","2036","1215","2017-04-24 00:00:00","51990","81912","0","0"),
("5328","2031","1215","2017-04-24 00:00:00","13951","6383","0","0"),
("5331","2032","1215","2017-04-24 00:00:00","13260","5094","0","0"),
("5337","2036","1215","2017-04-25 00:00:00","20602","22174","0","0"),
("5339","2032","1215","2017-04-25 00:00:00","13619","4274","0","0"),
("5340","2031","1215","2017-04-25 00:00:00","13950","6315","0","0"),
("5350","2036","1215","2017-04-26 00:00:00","63091","24801","0","0"),
("5353","2031","1215","2017-04-26 00:00:00","13607","4685","0","0"),
("5354","2032","1215","2017-04-26 00:00:00","16940","8994","0","0"),
("5364","2032","1215","2017-04-27 00:00:00","16258","7711","0","0"),
("5365","2031","1215","2017-04-27 00:00:00","14908","7637","0","0"),
("5386","2032","1215","2017-05-01 00:00:00","18450","10610","0","0"),
("5387","2031","1215","2017-05-01 00:00:00","15390","5301","0","0"),
("5392","2032","1215","2017-05-02 00:00:00","15419","6853","0","0"),
("5393","2036","1215","2017-05-02 00:00:00","28273","12805","0","0"),
("5399","2031","1215","2017-05-02 00:00:00","18030","11632","0","0"),
("5408","2036","1215","2017-05-03 00:00:00","69028","16096","0","0"),
("5412","2031","1215","2017-05-03 00:00:00","14906","4789","0","0"),
("5414","2032","1215","2017-05-03 00:00:00","11524","3942","0","0"),
("5423","2036","1215","2017-05-04 00:00:00","72648","23336","0","0"),
("5425","2032","1215","2017-05-04 00:00:00","16259","9175","0","0"),
("5427","2031","1215","2017-05-04 00:00:00","9780","8402","0","0"),
("5434","2036","1215","2017-05-05 00:00:00","12604","2826","0","0"),
("5457","2036","1215","2017-05-08 00:00:00","83157","19359","0","0"),
("5458","2032","1215","2017-05-08 00:00:00","12750","5353","0","0"),
("5459","2031","1215","2017-05-08 00:00:00","15270","7212","0","0"),
("5467","2036","1215","2017-05-09 00:00:00","11784","0","0","0"),
("5470","2032","1215","2017-05-09 00:00:00","13136","4080","0","0"),
("5471","2031","1215","2017-05-09 00:00:00","15660","6648","0","0"),
("5481","2032","1215","2017-05-10 00:00:00","14370","6153","0","0"),
("5482","2031","1215","2017-05-10 00:00:00","14100","4547","0","0"),
("5489","2031","1215","2017-05-11 00:00:00","15630","6907","0","0"),
("5490","2032","1215","2017-05-11 00:00:00","14250","5777","0","0"),
("5512","2032","1215","2017-05-15 00:00:00","14070","6240","0","0"),
("5514","2031","1215","2017-05-15 00:00:00","12390","4676","0","0"),
("5517","2036","1215","2017-05-16 00:00:00","36511","7276","0","0"),
("5519","2032","1215","2017-05-16 00:00:00","14938","5740","0","0"),
("5521","2031","1215","2017-05-16 00:00:00","15750","9361","0","0"),
("5529","2036","1215","2017-05-17 00:00:00","69116","14116","0","0"),
("5532","2032","1215","2017-05-17 00:00:00","13706","5668","0","0"),
("5534","2031","1215","2017-05-17 00:00:00","16770","10357","0","0"),
("5538","2036","1215","2017-05-18 00:00:00","59754","17493","0","0"),
("5539","2031","1215","2017-05-18 00:00:00","15300","9483","0","0"),
("5540","2032","1215","2017-05-18 00:00:00","14550","5620","0","0"),
("5547","2036","1215","2017-05-19 00:00:00","96134","25379","0","0"),
("5555","2036","1215","2017-05-22 00:00:00","23388","17433","0","0"),
("5557","2031","1215","2017-05-22 00:00:00","15960","7444","0","0"),
("5558","2032","1215","2017-05-22 00:00:00","13890","6997","0","0"),
("5562","2036","1215","2017-05-23 00:00:00","60845","18252","0","0"),
("5565","2032","1215","2017-05-23 00:00:00","14304","5573","0","0"),
("5566","2031","1215","2017-05-23 00:00:00","14460","6367","0","0"),
("5573","2032","1215","2017-05-24 00:00:00","13349","5204","0","0"),
("5574","2036","1215","2017-05-24 00:00:00","73160","17023","0","0"),
("5577","2031","1215","2017-05-24 00:00:00","15899","7455","0","0"),
("5583","2036","1215","2017-05-25 00:00:00","80952","23663","0","0"),
("5586","2031","1215","2017-05-25 00:00:00","15960","7126","0","0"),
("5587","2032","1215","2017-05-25 00:00:00","19289","10419","0","0"),
("5592","2036","1215","2017-05-26 00:00:00","47275","14357","0","0"),
("5603","2031","1215","2017-05-29 00:00:00","4110","1896","0","0"),
("5604","2036","1215","2017-05-30 00:00:00","79862","19806","0","0"),
("5606","2032","1215","2017-05-30 00:00:00","14819","6450","0","0"),
("5607","2031","1215","2017-05-30 00:00:00","15690","8477","0","0"),
("5614","2032","1215","2017-05-31 00:00:00","22170","9000","0","0"),
("5615","2036","1215","2017-05-31 00:00:00","80359","21929","0","0"),
("5622","2032","1215","2017-06-01 00:00:00","20296","6494","0","0"),
("5623","2036","1215","2017-06-01 00:00:00","82894","20974","0","0"),
("5631","2036","1215","2017-06-02 00:00:00","24732","17737","0","0"),
("5642","2036","1215","2017-06-05 00:00:00","66898","18832","0","0"),
("5644","2032","1215","2017-06-05 00:00:00","18118","7589","0","0"),
("5650","2036","1215","2017-06-06 00:00:00","77707","8144","0","0"),
("5653","2032","1215","2017-06-06 00:00:00","18809","9173","0","0");
INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("5658","2036","1215","2017-06-07 00:00:00","77005","20741","0","0"),
("5663","2032","1215","2017-06-07 00:00:00","18147","8608","0","0"),
("5666","2032","1215","2017-06-08 00:00:00","22380","12562","0","0"),
("5667","2036","1215","2017-06-08 00:00:00","58732","12762","0","0"),
("5674","2036","1215","2017-06-09 00:00:00","82388","22300","0","0"),
("5682","2032","1215","2017-06-12 00:00:00","23250","15145","0","0"),
("5685","2032","1215","2017-06-13 00:00:00","23670","13724","0","0"),
("5688","2036","1215","2017-06-13 00:00:00","22057","19534","0","0"),
("5697","2036","1215","2017-06-14 00:00:00","77946","20116","0","0"),
("5702","2032","1215","2017-06-14 00:00:00","20727","11858","0","0"),
("5705","2036","1215","2017-06-15 00:00:00","44853","82168","0","0"),
("5709","2032","1215","2017-06-15 00:00:00","23640","13816","0","0"),
("5718","2036","1215","2017-06-16 00:00:00","249023","245869","0","0"),
("5739","2036","1215","2017-06-19 00:00:00","61388","8932","0","0"),
("5740","2032","1215","2017-06-19 00:00:00","18839","7358","0","0"),
("5745","2036","1215","2017-06-20 00:00:00","84639","80886","0","0"),
("5750","2032","1215","2017-06-20 00:00:00","15330","7299","0","0"),
("5754","2036","1215","2017-06-21 00:00:00","73927","17747","0","0"),
("5757","2032","1215","2017-06-21 00:00:00","21120","11467","0","0"),
("5765","2036","1215","2017-06-22 00:00:00","70350","19613","0","0"),
("5774","2032","1215","2017-06-22 00:00:00","19557","11628","0","0"),
("5778","2036","1215","2017-06-23 00:00:00","45881","19072","0","0"),
("5783","2032","1215","2017-06-23 00:00:00","690","526","0","0"),
("5789","2036","1215","2017-06-26 00:00:00","81392","24648","0","0"),
("5793","2032","1215","2017-06-26 00:00:00","21120","11263","0","0"),
("5796","2036","1215","2017-06-27 00:00:00","75572","21020","0","0"),
("5799","2032","1215","2017-06-27 00:00:00","18476","8079","0","0"),
("5806","2036","1215","2017-06-28 00:00:00","76092","11647","0","0"),
("5811","2032","1215","2017-06-28 00:00:00","17340","7498","0","0"),
("5816","2036","1215","2017-06-29 00:00:00","65181","16004","0","0"),
("5822","2032","1215","2017-06-29 00:00:00","18084","8593","0","0"),
("5830","2036","1215","2017-06-30 00:00:00","96462","13772","0","0"),
("5837","2032","1215","2017-07-03 00:00:00","20250","9020","0","0"),
("5842","2036","1215","2017-07-05 00:00:00","77344","19464","0","0"),
("5844","2032","1215","2017-07-05 00:00:00","18780","10244","0","0"),
("5849","2036","1215","2017-07-06 00:00:00","28363","6846","0","0"),
("5852","2032","1215","2017-07-06 00:00:00","23324","12070","0","0"),
("5853","2034","1215","2017-07-06 00:00:00","16890","15581","0","0"),
("5855","2036","1215","2017-07-07 00:00:00","74644","22232","0","0"),
("5859","2032","1215","2017-07-07 00:00:00","24420","16623","0","0"),
("5863","2034","1215","2017-07-10 00:00:00","31350","14122","0","0"),
("5864","2036","1215","2017-07-10 00:00:00","71536","8115","0","0"),
("5868","2032","1215","2017-07-10 00:00:00","14903","6282","0","0"),
("5873","2036","1215","2017-07-11 00:00:00","34836","14036","0","0"),
("5876","2034","1215","2017-07-11 00:00:00","16260","9592","0","0"),
("5878","2032","1215","2017-07-11 00:00:00","21802","11682","0","0"),
("5885","2034","1215","2017-07-12 00:00:00","22110","13434","0","0"),
("5886","2036","1215","2017-07-12 00:00:00","76925","16112","0","0"),
("5889","2031","1215","2017-07-12 00:00:00","11400","2792","0","0"),
("5892","2032","1215","2017-07-12 00:00:00","21989","12446","0","0"),
("5894","2034","1215","2017-07-13 00:00:00","23814","14958","0","0"),
("5895","2036","1215","2017-07-13 00:00:00","29345","24309","0","0"),
("5897","2031","1215","2017-07-13 00:00:00","13590","4587","0","0"),
("5899","2032","1215","2017-07-13 00:00:00","20758","12976","0","0"),
("5909","2034","1215","2017-07-14 00:00:00","26310","17407","0","0"),
("5910","2036","1215","2017-07-14 00:00:00","72337","9383","0","0"),
("5912","2031","1215","2017-07-14 00:00:00","17580","8762","0","0"),
("5916","2032","1215","2017-07-14 00:00:00","60","0","0","0"),
("5925","2034","1215","2017-07-17 00:00:00","29430","18826","0","0"),
("5928","2031","1215","2017-07-17 00:00:00","13500","6431","0","0"),
("5930","2032","1215","2017-07-17 00:00:00","20695","8916","0","0"),
("5934","2034","1215","2017-07-18 00:00:00","27870","20702","0","0"),
("5936","2031","1215","2017-07-18 00:00:00","13858","6630","0","0"),
("5938","2032","1215","2017-07-18 00:00:00","14009","4339","0","0"),
("5943","2036","1215","2017-07-18 00:00:00","66338","8433","0","0"),
("5951","2036","1215","2017-07-19 00:00:00","82915","27629","0","0"),
("5952","2034","1215","2017-07-19 00:00:00","80940","73407","0","0"),
("5954","2031","1215","2017-07-19 00:00:00","13860","6400","0","0"),
("5955","2032","1215","2017-07-19 00:00:00","24417","12098","0","0"),
("5961","2036","1215","2017-07-20 00:00:00","30487","23635","0","0"),
("5962","2034","1215","2017-07-20 00:00:00","16405","7675","0","0"),
("5964","2031","1215","2017-07-20 00:00:00","13437","6345","0","0"),
("5967","2032","1215","2017-07-20 00:00:00","20278","10036","0","0"),
("5977","2036","1215","2017-07-21 00:00:00","23963","18477","0","0"),
("5980","2031","1215","2017-07-21 00:00:00","14187","16586","0","0"),
("5987","2034","1215","2017-07-24 00:00:00","27780","14044","0","0"),
("5988","2036","1215","2017-07-24 00:00:00","54209","16266","0","0"),
("5991","2032","1215","2017-07-24 00:00:00","17963","5464","0","0"),
("5997","2036","1215","2017-07-25 00:00:00","84677","25955","0","0"),
("5998","2034","1215","2017-07-25 00:00:00","20010","14178","0","0"),
("6001","2032","1215","2017-07-25 00:00:00","20787","9109","0","0"),
("6008","2036","1215","2017-07-26 00:00:00","28565","24290","0","0"),
("6010","2034","1215","2017-07-26 00:00:00","83662","78494","0","0"),
("6015","2032","1215","2017-07-26 00:00:00","17560","8651","0","0"),
("6022","2034","1215","2017-07-27 00:00:00","26724","17108","0","0"),
("6024","2036","1215","2017-07-27 00:00:00","83248","24561","0","0"),
("6030","2032","1215","2017-07-27 00:00:00","16410","5740","0","0"),
("6037","2034","1215","2017-07-28 00:00:00","26135","20144","0","0"),
("6038","2036","1215","2017-07-28 00:00:00","29932","26244","0","0"),
("6053","2036","1215","2017-07-31 00:00:00","20640","11852","0","0"),
("6054","2032","1215","2017-07-31 00:00:00","14367","6981","0","0"),
("6058","2034","1215","2017-08-01 00:00:00","57443","76713","0","0"),
("6064","2032","1215","2017-08-01 00:00:00","19007","8319","0","0"),
("6065","2036","1215","2017-08-01 00:00:00","50490","10037","0","0"),
("6075","2034","1215","2017-08-02 00:00:00","15838","12724","0","0"),
("6079","2032","1215","2017-08-02 00:00:00","20429","11323","0","0"),
("6085","2034","1215","2017-08-03 00:00:00","77025","71948","0","0"),
("6086","2031","1215","2017-08-03 00:00:00","14126","13887","0","0"),
("6091","2032","1215","2017-08-03 00:00:00","19766","10769","0","0"),
("6094","2034","1215","2017-08-04 00:00:00","112066","15336","0","0"),
("6098","2031","1215","2017-08-04 00:00:00","14876","10398","0","0"),
("6100","2036","1215","2017-08-04 00:00:00","247050","10180","0","0"),
("6101","2032","1215","2017-08-04 00:00:00","6930","2561","0","0"),
("6104","2034","1215","2017-08-07 00:00:00","23340","16645","0","0"),
("6105","2036","1215","2017-08-07 00:00:00","28434","19050","0","0"),
("6108","2031","1215","2017-08-07 00:00:00","14940","9959","0","0"),
("6111","2032","1215","2017-08-07 00:00:00","20158","10255","0","0"),
("6113","2036","1215","2017-08-08 00:00:00","28740","23539","0","0"),
("6115","2034","1215","2017-08-08 00:00:00","78710","16659","0","0"),
("6118","2031","1215","2017-08-08 00:00:00","14578","8840","0","0"),
("6120","2032","1215","2017-08-08 00:00:00","20100","11601","0","0"),
("6122","2034","1215","2017-08-09 00:00:00","28726","21568","0","0"),
("6125","2031","1215","2017-08-09 00:00:00","14278","12274","0","0"),
("6128","2032","1215","2017-08-09 00:00:00","20730","10707","0","0"),
("6129","2036","1215","2017-08-09 00:00:00","18330","11586","0","0"),
("6132","2036","1215","2017-08-10 00:00:00","30075","25081","0","0"),
("6133","2034","1215","2017-08-10 00:00:00","80340","73164","0","0"),
("6135","2031","1215","2017-08-10 00:00:00","13440","11385","0","0"),
("6139","2032","1215","2017-08-10 00:00:00","23250","12985","0","0"),
("6144","2034","1215","2017-08-11 00:00:00","27570","23437","0","0"),
("6145","2036","1215","2017-08-11 00:00:00","252248","14757","0","0"),
("6156","2034","1215","2017-08-14 00:00:00","79199","76114","0","0"),
("6157","2036","1215","2017-08-14 00:00:00","90373","84221","0","0"),
("6158","2031","1215","2017-08-14 00:00:00","14550","9320","0","0"),
("6161","2032","1215","2017-08-14 00:00:00","21629","11789","0","0"),
("6166","2034","1215","2017-08-15 00:00:00","25465","24376","0","0"),
("6170","2031","1215","2017-08-15 00:00:00","14400","7800","0","0"),
("6171","2036","1215","2017-08-15 00:00:00","78475","12783","0","0"),
("6174","2032","1215","2017-08-15 00:00:00","18900","8404","0","0"),
("6179","2034","1215","2017-08-16 00:00:00","42804","76295","0","0"),
("6181","2036","1215","2017-08-16 00:00:00","30442","21328","0","0"),
("6186","2032","1215","2017-08-16 00:00:00","19770","8890","0","0"),
("6192","2036","1215","2017-08-17 00:00:00","82539","74112","0","0"),
("6193","2034","1215","2017-08-17 00:00:00","81292","73329","0","0"),
("6199","2032","1215","2017-08-17 00:00:00","20160","7583","0","0"),
("6200","2034","1215","2017-08-18 00:00:00","29400","22102","0","0"),
("6202","2036","1215","2017-08-18 00:00:00","266366","266543","0","0"),
("6207","2031","1215","2017-08-18 00:00:00","14516","12745","0","0"),
("6218","2034","1215","2017-08-21 00:00:00","27989","21126","0","0"),
("6224","2031","1215","2017-08-21 00:00:00","11550","8945","0","0"),
("6230","2036","1215","2017-08-21 00:00:00","36964","21433","0","0"),
("6232","2032","1215","2017-08-21 00:00:00","19229","7744","0","0"),
("6233","2035","1215","2017-08-21 00:00:00","630","147","0","0"),
("6238","2034","1215","2017-08-22 00:00:00","75390","19660","0","0"),
("6249","2031","1215","2017-08-22 00:00:00","14550","10710","0","0"),
("6252","2036","1215","2017-08-22 00:00:00","78299","19416","0","0"),
("6254","2032","1215","2017-08-22 00:00:00","16890","5850","0","0"),
("6259","2034","1215","2017-08-23 00:00:00","30989","19844","0","0"),
("6269","2031","1215","2017-08-23 00:00:00","15329","13206","0","0");
INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("6274","2036","1215","2017-08-23 00:00:00","78016","72952","0","0"),
("6275","2032","1215","2017-08-23 00:00:00","19903","7488","0","0"),
("6282","2032","1215","2017-08-24 00:00:00","26400","11930","0","0"),
("6285","2036","1215","2017-08-24 00:00:00","85311","27235","0","0"),
("6286","2034","1215","2017-08-24 00:00:00","60150","19450","0","0"),
("6297","2031","1215","2017-08-24 00:00:00","14220","13992","0","0"),
("6307","2034","1215","2017-08-25 00:00:00","258199","255725","0","0"),
("6317","2036","1215","2017-08-25 00:00:00","253584","24820","0","0"),
("6330","2034","1215","2017-08-28 00:00:00","44484","80468","0","0"),
("6339","2036","1215","2017-08-28 00:00:00","84979","84390","0","0"),
("6343","2032","1215","2017-08-28 00:00:00","19620","7655","0","0"),
("6352","2034","1215","2017-08-29 00:00:00","52527","88543","0","0"),
("6361","2036","1215","2017-08-29 00:00:00","84899","21890","0","0"),
("6372","2032","1215","2017-08-29 00:00:00","18710","8864","0","0"),
("6391","2034","1215","2017-08-30 00:00:00","84099","80671","0","0"),
("6393","2032","1215","2017-08-30 00:00:00","21000","11253","0","0"),
("6396","2036","1215","2017-08-30 00:00:00","75531","11302","0","0"),
("6408","2034","1215","2017-08-31 00:00:00","80194","18894","0","0"),
("6409","2036","1215","2017-08-31 00:00:00","80136","18582","0","0"),
("6418","2032","1215","2017-08-31 00:00:00","17519","5484","0","0"),
("6420","2034","1215","2017-09-01 00:00:00","118618","333645","0","0"),
("6434","2036","1215","2017-09-01 00:00:00","18746","3866","0","0"),
("6441","2034","1215","2017-09-05 00:00:00","28920","23431","0","0"),
("6457","2032","1215","2017-09-05 00:00:00","20790","11499","0","0"),
("6483","2032","1215","2017-09-06 00:00:00","18720","6398","0","0"),
("6507","2032","1215","2017-09-07 00:00:00","19620","5606","0","0"),
("6543","2032","1215","2017-09-11 00:00:00","19410","7973","0","0"),
("6544","2034","1215","2017-09-11 00:00:00","16013","11608","0","0"),
("6548","2034","1215","2017-09-12 00:00:00","17902","15007","0","0"),
("6566","2032","1215","2017-09-12 00:00:00","27750","16148","0","0"),
("6567","2036","1215","2017-09-12 00:00:00","64073","61738","0","0"),
("6584","2034","1215","2017-09-13 00:00:00","83273","73340","0","0"),
("6588","2032","1215","2017-09-13 00:00:00","23549","12160","0","0"),
("6589","2036","1215","2017-09-13 00:00:00","432480","77728","0","0"),
("6608","2034","1215","2017-09-14 00:00:00","84962","80824","0","0"),
("6615","2032","1215","2017-09-14 00:00:00","19734","15909","0","0"),
("6631","2034","1215","2017-09-15 00:00:00","24437","22142","0","0"),
("6656","2034","1215","2017-09-18 00:00:00","25710","16691","0","0"),
("6662","2032","1215","2017-09-18 00:00:00","21630","11680","0","0"),
("6663","2036","1215","2017-09-18 00:00:00","98121","94251","0","0"),
("6690","2034","1215","2017-09-19 00:00:00","18958","13597","0","0"),
("6691","2032","1215","2017-09-19 00:00:00","18990","8879","0","0"),
("6692","2036","1215","2017-09-19 00:00:00","79344","83720","0","0"),
("6714","2034","1215","2017-09-20 00:00:00","19889","14808","0","0"),
("6716","2036","1215","2017-09-20 00:00:00","168252","15653","0","0"),
("6719","2032","1215","2017-09-20 00:00:00","26519","13043","0","0"),
("6735","2034","1215","2017-09-21 00:00:00","51719","77445","0","0"),
("6740","2032","1215","2017-09-21 00:00:00","21580","13454","0","0"),
("6752","2034","1215","2017-09-22 00:00:00","23177","22804","0","0"),
("6785","2034","1215","2017-09-25 00:00:00","29879","24280","0","0"),
("6801","2036","1215","2017-09-25 00:00:00","94368","94109","0","0"),
("6804","2032","1215","2017-09-25 00:00:00","18218","7471","0","0"),
("6811","2034","1215","2017-09-26 00:00:00","27586","24325","0","0"),
("6826","2032","1215","2017-09-26 00:00:00","20723","12816","0","0"),
("6827","2036","1215","2017-09-26 00:00:00","68900","4351","0","0"),
("6832","2034","1215","2017-09-27 00:00:00","27251","21123","0","0"),
("6848","2032","1215","2017-09-27 00:00:00","21148","12095","0","0"),
("6851","2036","1215","2017-09-27 00:00:00","96225","96010","0","0"),
("6866","2034","1215","2017-09-28 00:00:00","83010","77096","0","0"),
("6880","2032","1215","2017-09-28 00:00:00","17010","7539","0","0"),
("6883","2036","1215","2017-09-28 00:00:00","471829","366","0","0"),
("6885","2034","1215","2017-09-29 00:00:00","120157","247968","0","0"),
("6916","2034","1215","2017-10-02 00:00:00","39737","79194","0","0"),
("6934","2032","1215","2017-10-02 00:00:00","18180","8593","0","0"),
("6943","2034","1215","2017-10-03 00:00:00","84479","81062","0","0"),
("6967","2032","1215","2017-10-03 00:00:00","18580","7240","0","0"),
("6972","2034","1215","2017-10-04 00:00:00","85857","80041","0","0"),
("6999","2032","1215","2017-10-04 00:00:00","20039","9782","0","0"),
("7005","2034","1215","2017-10-05 00:00:00","29548","22539","0","0"),
("7030","2036","1215","2017-10-05 00:00:00","85697","83188","0","0"),
("7033","2032","1215","2017-10-05 00:00:00","11250","6640","0","0"),
("7038","2034","1215","2017-10-06 00:00:00","112053","20903","0","0"),
("7061","2036","1215","2017-10-06 00:00:00","250394","12242","0","0"),
("7070","2034","1215","2017-10-09 00:00:00","70735","81094","0","0"),
("7095","2032","1215","2017-10-09 00:00:00","18660","9372","0","0"),
("7096","2036","1215","2017-10-09 00:00:00","97118","95582","0","0"),
("7103","2034","1215","2017-10-10 00:00:00","77228","21863","0","0"),
("7133","2032","1215","2017-10-10 00:00:00","15508","8176","0","0"),
("7135","2036","1215","2017-10-10 00:00:00","235808","168861","0","0"),
("7161","2032","1215","2017-10-11 00:00:00","22823","11711","0","0"),
("7162","2034","1215","2017-10-11 00:00:00","83791","79459","0","0"),
("7167","2035","1215","2017-10-11 00:00:00","17946","8430","0","0"),
("7179","2035","1215","2017-10-12 00:00:00","25203","10292","0","0"),
("7198","2034","1215","2017-10-12 00:00:00","81707","80574","0","0"),
("7203","2032","1215","2017-10-12 00:00:00","20249","10023","0","0"),
("7209","2034","1215","2017-10-13 00:00:00","21430","18576","0","0"),
("7210","2036","1215","2017-10-13 00:00:00","262831","6954","0","0"),
("7225","2035","1215","2017-10-13 00:00:00","18501","2489","0","0"),
("7240","2034","1215","2017-10-16 00:00:00","27374","20797","0","0"),
("7241","2032","1215","2017-10-16 00:00:00","20129","9759","0","0"),
("7242","2036","1215","2017-10-16 00:00:00","102599","99265","0","0"),
("7245","2035","1215","2017-10-16 00:00:00","17777","10494","0","0"),
("7255","2034","1215","2017-10-17 00:00:00","70415","88406","0","0"),
("7277","2035","1215","2017-10-17 00:00:00","18725","4060","0","0"),
("7283","2032","1215","2017-10-17 00:00:00","18629","8163","0","0"),
("7286","2036","1215","2017-10-17 00:00:00","336695","1134","0","0"),
("7317","2032","1215","2017-10-18 00:00:00","21839","10736","0","0"),
("7319","2034","1215","2017-10-18 00:00:00","74167","69513","0","0"),
("7327","2034","1215","2017-10-19 00:00:00","82823","76689","0","0"),
("7354","2035","1215","2017-10-19 00:00:00","25106","17957","0","0"),
("7357","2032","1215","2017-10-19 00:00:00","26757","17210","0","0"),
("7362","2034","1215","2017-10-20 00:00:00","254516","255572","0","0"),
("7404","2034","1215","2017-10-23 00:00:00","80931","73020","0","0"),
("7418","2035","1215","2017-10-23 00:00:00","2380","3535","0","0"),
("7429","2032","1215","2017-10-23 00:00:00","22500","12103","0","0"),
("7438","2034","1215","2017-10-24 00:00:00","168971","159840","0","0"),
("7466","2032","1215","2017-10-24 00:00:00","21388","9956","0","0"),
("7481","2034","1215","2017-10-25 00:00:00","6429","5216","0","0"),
("7501","2032","1215","2017-10-25 00:00:00","23339","12723","0","0"),
("7505","2035","1215","2017-10-25 00:00:00","177","0","0","0"),
("7516","2034","1215","2017-10-26 00:00:00","26086","21314","0","0"),
("7540","2032","1215","2017-10-26 00:00:00","15689","6623","0","0"),
("7552","2034","1215","2017-10-27 00:00:00","266968","271080","0","0"),
("7602","2034","1215","2017-10-30 00:00:00","88600","11700","0","0"),
("7609","2032","1215","2017-10-30 00:00:00","23879","9662","0","0"),
("7618","2034","1215","2017-10-31 00:00:00","29299","23531","0","0"),
("7645","2032","1215","2017-10-31 00:00:00","10739","2144","0","0"),
("7648","2034","1215","2017-11-01 00:00:00","85979","80800","0","0"),
("7670","2032","1215","2017-11-01 00:00:00","25680","13240","0","0"),
("7675","2034","1215","2017-11-02 00:00:00","109764","16797","0","0"),
("7698","2032","1215","2017-11-02 00:00:00","19890","9653","0","0"),
("7764","2032","1215","2017-11-06 00:00:00","18650","6443","0","0"),
("7792","2032","1215","2017-11-07 00:00:00","20535","9556","0","0"),
("7794","2034","1215","2017-11-07 00:00:00","74515","72567","0","0"),
("7802","2034","1215","2017-11-08 00:00:00","83359","77755","0","0"),
("7818","2032","1215","2017-11-08 00:00:00","25495","11641","0","0"),
("7826","2034","1215","2017-11-09 00:00:00","89242","82437","0","0"),
("7844","2032","1215","2017-11-09 00:00:00","21924","11556","0","0"),
("7855","2034","1215","2017-11-10 00:00:00","257847","256966","0","0"),
("7884","2034","1215","2017-11-13 00:00:00","82753","77256","0","0"),
("7902","2032","1215","2017-11-13 00:00:00","17426","5809","0","0"),
("7907","2034","1215","2017-11-14 00:00:00","66701","81050","0","0"),
("7919","2032","1215","2017-11-14 00:00:00","17640","8468","0","0"),
("7929","2034","1215","2017-11-15 00:00:00","83962","79375","0","0"),
("7941","2032","1215","2017-11-15 00:00:00","17207","8112","0","0"),
("7951","2034","1215","2017-11-16 00:00:00","52272","85768","0","0"),
("7960","2032","1215","2017-11-16 00:00:00","16110","6048","0","0"),
("7969","2034","1215","2017-11-17 00:00:00","14034","12311","0","0"),
("7981","2034","1215","2017-11-20 00:00:00","85228","79092","0","0"),
("7988","2032","1215","2017-11-20 00:00:00","24257","10599","0","0"),
("7994","2034","1215","2017-11-21 00:00:00","54768","85220","0","0"),
("7999","2032","1215","2017-11-21 00:00:00","20062","10101","0","0"),
("8012","2034","1215","2017-11-22 00:00:00","102009","8294","0","0"),
("8036","2034","1215","2017-11-27 00:00:00","81810","74863","0","0"),
("8041","2032","1215","2017-11-27 00:00:00","21504","10890","0","0"),
("8060","2034","1215","2017-11-28 00:00:00","86974","86230","0","0"),
("8071","2032","1215","2017-11-28 00:00:00","20089","10370","0","0"),
("8089","2034","1215","2017-11-29 00:00:00","76040","78255","0","0"),
("8094","2032","1215","2017-11-29 00:00:00","20064","10056","0","0");
INSERT INTO hp_working_hours (`hId`,`memberId`,`teamId`,`dated`,`outbound_working_time`,`outbound_idle_time`,`inbound_working_time`,`inbound_idle_time`) VALUES
("8111","2034","1215","2017-11-30 00:00:00","85690","82236","0","0"),
("8120","2032","1215","2017-11-30 00:00:00","21550","9125","0","0"),
("8135","2034","1215","2017-12-01 00:00:00","260496","257865","0","0"),
("8167","2032","1215","2017-12-04 00:00:00","28442","17039","0","0"),
("8170","2034","1215","2017-12-04 00:00:00","19170","15984","0","0"),
("8195","2032","1215","2017-12-05 00:00:00","21306","10766","0","0"),
("8196","2034","1215","2017-12-05 00:00:00","79068","73014","0","0"),
("8211","2034","1215","2017-12-06 00:00:00","88839","79881","0","0"),
("8215","2032","1215","2017-12-06 00:00:00","24187","15046","0","0"),
("8233","2032","1215","2017-12-07 00:00:00","23670","14883","0","0"),
("8235","2034","1215","2017-12-07 00:00:00","72018","21382","0","0"),
("8252","2034","1215","2017-12-08 00:00:00","31256","26562","0","0"),
("8273","2034","1215","2017-12-11 00:00:00","24988","78904","0","0"),
("8281","2032","1215","2017-12-11 00:00:00","21376","11023","0","0"),
("8299","2034","1215","2017-12-12 00:00:00","84449","77941","0","0"),
("8301","2032","1215","2017-12-12 00:00:00","20662","11858","0","0"),
("8319","2034","1215","2017-12-13 00:00:00","28502","16591","0","0"),
("8326","2032","1215","2017-12-13 00:00:00","19398","10231","0","0"),
("8341","2032","1215","2017-12-14 00:00:00","26367","13392","0","0"),
("8368","2034","1215","2017-12-15 00:00:00","9810","9140","0","0"),
("8381","2032","1215","2017-12-18 00:00:00","22826","13548","0","0"),
("8382","2034","1215","2017-12-18 00:00:00","22617","21659","0","0"),
("8404","2032","1215","2017-12-19 00:00:00","18659","5790","0","0"),
("8411","2034","1215","2017-12-19 00:00:00","47707","72303","0","0"),
("8425","2034","1215","2017-12-20 00:00:00","23995","19523","0","0"),
("8428","2032","1215","2017-12-20 00:00:00","18116","12095","0","0"),
("8441","2032","1215","2017-12-21 00:00:00","21256","9480","0","0"),
("8451","2032","1215","2017-12-22 00:00:00","5940","2340","0","0"),
("8478","2034","1215","2017-12-27 00:00:00","55859","92552","0","0"),
("8501","2034","1215","2017-12-28 00:00:00","74100","73223","0","0"),
("8502","2032","1215","2017-12-28 00:00:00","17172","6778","0","0"),
("8507","2034","1215","2017-12-29 00:00:00","30862","22712","0","0"),
("8515","2032","1215","2017-12-29 00:00:00","24897","13719","0","0"),
("8531","2034","1215","2018-01-02 00:00:00","27959","25441","0","0"),
("8540","2032","1215","2018-01-02 00:00:00","20219","12718","0","0"),
("8549","2034","1215","2018-01-03 00:00:00","20383","6556","0","0"),
("8551","2032","1215","2018-01-03 00:00:00","19733","11785","0","0"),
("8556","2032","1215","2018-01-04 00:00:00","23969","10154","0","0"),
("8557","2034","1215","2018-01-04 00:00:00","21809","18067","0","0"),
("8572","2032","1215","2018-01-05 00:00:00","25858","16277","0","0"),
("8584","2034","1215","2018-01-05 00:00:00","4199","3238","0","0"),
("8591","2034","1215","2018-01-08 00:00:00","30507","27420","0","0"),
("8598","2032","1215","2018-01-08 00:00:00","23639","12031","0","0"),
("8606","2034","1215","2018-01-09 00:00:00","24777","10602","0","0"),
("8609","2032","1215","2018-01-09 00:00:00","21630","17421","0","0"),
("8624","2032","1215","2018-01-10 00:00:00","19620","8188","0","0"),
("8627","2034","1215","2018-01-10 00:00:00","13472","13605","0","0"),
("8637","2032","1215","2018-01-11 00:00:00","20120","9729","0","0"),
("8641","2034","1215","2018-01-11 00:00:00","13629","5555","0","0"),
("8645","2034","1215","2018-01-12 00:00:00","27958","22850","0","0"),
("8654","2032","1215","2018-01-12 00:00:00","12420","5356","0","0"),
("8663","2034","1215","2018-01-15 00:00:00","77624","76822","0","0"),
("8668","2032","1215","2018-01-15 00:00:00","16620","7165","0","0"),
("8679","2034","1215","2018-01-16 00:00:00","28993","23895","0","0"),
("8683","2032","1215","2018-01-16 00:00:00","25110","11147","0","0"),
("8698","2034","1215","2018-01-17 00:00:00","92420","86394","0","0"),
("8707","2032","1215","2018-01-17 00:00:00","18347","10397","0","0"),
("8721","2034","1215","2018-01-18 00:00:00","82035","80233","0","0"),
("8727","2032","1215","2018-01-18 00:00:00","23566","12573","0","0"),
("8738","2034","1215","2018-01-19 00:00:00","345088","343471","0","0"),
("8747","2032","1215","2018-01-19 00:00:00","14310","7341","0","0"),
("8760","2032","1215","2018-01-22 00:00:00","20174","9157","0","0"),
("8767","2034","1215","2018-01-22 00:00:00","180","0","0","0"),
("8769","2034","1215","2018-01-23 00:00:00","83111","74545","0","0"),
("8770","2032","1215","2018-01-23 00:00:00","23602","7926","0","0"),
("8790","2034","1215","2018-01-24 00:00:00","83630","325","0","0"),
("8798","2032","1215","2018-01-24 00:00:00","23901","9097","0","0"),
("8803","2032","1215","2018-01-25 00:00:00","18886","9754","0","0"),
("8804","2034","1215","2018-01-25 00:00:00","13669","7431","0","0"),
("8824","2032","1215","2018-01-26 00:00:00","5880","3250","0","0"),
("8828","2034","1215","2018-01-26 00:00:00","13559","12312","0","0"),
("8836","2034","1215","2018-01-29 00:00:00","36824","76937","0","0"),
("8842","2032","1215","2018-01-29 00:00:00","19360","10392","0","0"),
("8849","2032","1215","2018-01-30 00:00:00","22850","10035","0","0"),
("8851","2034","1215","2018-01-30 00:00:00","75160","69836","0","0"),
("8863","2034","1215","2018-01-31 00:00:00","64077","80123","0","0"),
("8864","2032","1215","2018-01-31 00:00:00","20301","9775","0","0"),
("8880","2034","1215","2018-02-01 00:00:00","77875","75167","0","0"),
("8881","2032","1215","2018-02-01 00:00:00","13423","6516","0","0"),
("8884","2034","1215","2018-02-02 00:00:00","114304","18562","0","0"),
("8888","2032","1215","2018-02-02 00:00:00","10761","6090","0","0"),
("8892","2032","1215","2018-02-05 00:00:00","26320","11953","0","0"),
("8909","2034","1215","2018-02-06 00:00:00","94558","89365","0","0"),
("8920","2032","1215","2018-02-06 00:00:00","19971","7383","0","0"),
("8936","2032","1215","2018-02-07 00:00:00","21938","11939","0","0"),
("8939","2034","1215","2018-02-07 00:00:00","79800","75122","0","0"),
("8946","2034","1215","2018-02-08 00:00:00","86454","14902","0","0"),
("8951","2032","1215","2018-02-08 00:00:00","22491","12078","0","0"),
("8965","2034","1215","2018-02-09 00:00:00","108020","255350","0","0"),
("8976","2034","1215","2018-02-12 00:00:00","86897","81433","0","0"),
("8982","2032","1215","2018-02-12 00:00:00","24783","16739","0","0"),
("8993","2034","1215","2018-02-13 00:00:00","89520","87119","0","0"),
("9002","2032","1215","2018-02-13 00:00:00","24080","9444","0","0"),
("9013","2034","1215","2018-02-14 00:00:00","21193","16319","0","0"),
("9019","2032","1215","2018-02-14 00:00:00","18427","6862","0","0"),
("9023","2034","1215","2018-02-15 00:00:00","29709","565","0","0"),
("9025","2032","1215","2018-02-15 00:00:00","25069","10377","0","0"),
("9058","2032","1215","2018-02-19 00:00:00","23538","13929","0","0"),
("9071","2032","1215","2018-02-20 00:00:00","16032","10387","0","0"),
("9075","2032","1215","2018-02-21 00:00:00","20024","11995","0","0"),
("9097","2032","1215","2018-02-22 00:00:00","18780","11441","0","0"),
("9108","2032","1215","2018-02-23 00:00:00","4470","2011","0","0"),
("9120","2032","1215","2018-02-26 00:00:00","19735","9705","0","0"),
("9134","2032","1215","2018-02-27 00:00:00","24193","14492","0","0"),
("9148","2032","1215","2018-02-28 00:00:00","19687","9813","0","0"),
("9160","2032","1215","2018-03-01 00:00:00","21242","11442","0","0"),
("9173","2032","1215","2018-03-02 00:00:00","12359","8750","0","0"),
("9200","2032","1215","2018-03-05 00:00:00","21059","12181","0","0"),
("9212","2032","1215","2018-03-06 00:00:00","24106","13470","0","0"),
("9218","2034","1215","2018-03-07 00:00:00","76245","84823","0","0"),
("9220","2032","1215","2018-03-07 00:00:00","26612","14778","0","0"),
("9234","2034","1215","2018-03-08 00:00:00","83625","22034","0","0"),
("9237","2032","1215","2018-03-08 00:00:00","22634","11267","0","0");



