sum数据，同样的sql利用minidao 和工具查出来的不一致
使用minidao的日志打印：userId:137********__dateStr:2018-06-06 15:29:51__sendflag:R
MiniDao-SQL:select SUM(outprem) redprem from lc_*** WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate
AND userid=:phone AND sendflag=:sendflag
sum:45.32__dateStr:2018-06-06 15:29:51
sql执行情况截图
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA5EAAADJCAIAAAA1hSHvAAAgAElEQVR4nO3deVQUd6Iv8N/1nnfmZN555+Xdc+bemXfnZqKTd+dub+aNGGN2Z5JMJvPmJve+6IwKRlyixrhNNIsxKggIrokrawPduDQgiAqyQ7MLsi+yqAiIgJpIR8BotLvfHwVNddWvflW90F0N38/5HU51UfWr3+9X1V1ffjQNMRqNRqOREGIcw192gAUAAAAAwKWINaGSMc4EVmRWAAAAAHA5ZxMqMisAAAAATDRkVgAAAABQO2RWAAAAAFA7ZFYAAAAAUDthZsXfYAEAAACA2tgkVHxuAAAAAACoEDIrAAAAAKid8F8JILMCAAAAgNqM/0MBwQIyKwAAAACoBLFOr/IhswIAAACAeuBzAwAAAABA7WxmVTHPCgAAAAAqhP8pAAAAAABqh8wKAAAAAGo3IZmVEGLwZgHqaL9KmuG9srKyTpw4oXORaAUiFIiTdvbsWU+P2WRjfRJZ8GxyCyXjjHPhPPEY4n4BLuTpaCoJmVVIVc98FzZm2rRp06ZNc1VtbjZtjF17ZWRkeFdmTU9Pn6ABnJr4Tx/kJPfw3sxqIcQ9DXPJUaiVqOrmpQZefdezEvfCDf3ydDSVNP6xrC78rCtCyHvvWazFYDDwHwrWWMdIvI1gpdQ2YoMvX7MW60PGt6zfNajsae/axkz0Vc44y9QTzVh2SfszMzO9K7Pm5ORQR1X8lfoEYY+8M88dqTVKKhE/9RQemr+eUTP1WBz2JCuXUSy2uVYcXMQPZcONVD0TsZeghdZK2Dsq7Dt1F/GO1GUlrRWv5Bash5BtkvLjKtlL+bH4DWM0knos5SdUtloB9v1CyWsCdY34q8L7u0HBq/pEm4i7nvh2ZpB+KXYJcS+QWV024WqxnWflPz2kFqQ2FlwZ1K9igjscdYEaZw2OZsQJvXpcO9XqqqqkyJ5u6jkVRzEqe9ufnZ2tPLMmyJnozJqQkMAYUsHouWpBQPzcEX+lLlDroe7L2EuqZnarpPZiP3HEGYKaKhzIZ1L1TMRe7BYydhEs29svqaM7ht8GcTS0ay/HjiX4rl0ttHcvJ1soSza2sheUfHV4QSHH7lNSe7Frc+xYgh65sO9S7M2szt/rPR1NJU14ZrWSiiyMbaTON/s6oN4RkVkNbsys1LPs/sxaUFCgJLMmJCSoYZ41NTVVdkgd+JGAvY0AO4OKHzLSp0Eud7J3Ec+tyrZHapKVSnlucz6zOp8j7d1X+TaO9V2qZsdQp1SVZ1YHJlml9pJNn+wfLajLSlro2F5UjmVWqRBmYL7+SG1mXSP7gkPlFZmV3VNk1olDeW+ASzKrOH+IZ8upmZW/jWOZ1cC8ydmbWflvHLEui1cKviW7F7sSPsZrkJKaBfVPRAv5qGdZ6pw6n1nZTZo2bdq2bduok6aCiVWPZ1adTveDH/yA2hGpe4Z4YNkjT10jRv31vfjZxP4tv3gvhzMrNY8qaY/CH/YUJg/+Q/HvhS3M35tL/TbZ3r1kuyComb2XgdZ3xo5SNbtnnlVqxMRjpWScqUmd3Xd2k+zdy4HRUHhaFb49gLHGoCyzKny1MTDv11I3I9k7EXUldS/GnVH2WFRK0rnCzKrkDuu2fgl4OppKosyzuuT9rOIT5rZ5VivGmwSkfmspeMLzryepBYMoS1E3Zm8j/irVJAHZmpUvONxCPtmfv9mvhnZlVuq5EHj99deV5FGPZ9b09HT2qEr9vGfvzIfsIHMcmNdkVzLRmVW8UklmtXd+0d55R2padeFejrWQ+l1BnnPVURQSB0olNQv2ksqjssdSckRX7cXeXvZYslw+z2qQfv1RuIadWWVXKrlbKdxLvKUD9xQlPVWSWR2+U09QvwQ8HU0lUSZWXZhZ2SdPdo2TmdUgdwt0Z2YVNEzwk5AzmZVds8JeONNCPsY5Zb/MOZNZ2bvo9XqVZ9aUlBQlo6oks4r3Ym/DwEiZ7nxvAPXvq9gRliObWRnzhS7PrBO0l/I6XfIt6jYuyawGWmhW2BJ7MytjYzfsJbs9Yy8lOzr8flbqZvyHSuabqHspn2u0rqFuww5eSlKaoB7qXuJtBKi/4zLY9lRhZnXmTu3yfgl4OppKmth5VurJk51yEz9kLIsp/Bssg4LpGYVXzM9+9rMLYzIzMxUmQvFDcSKUve/K1qywFw63UMAjmZXRnmnTpmVnZ7sts4aHh9ubWU+fPi37UmJXZrVrQUBhynRzZnW4PYynj/j2Pzkyq73HEqxRmGXtyqzKJ7wdmI/kf1U+z+rAEV21F3t7xl5K9pUdartux4KHzr/+MLDzltSCVA3svZQci8FVfXfyTu3yfgl4OppKGp9nnYj3s/LPnOCnE8EacRHsaB1K8RoB6sSMdb1ggf+QI55qlfqR5Uc/+pFer9doNIJQcuzYsfDw8N27d6ekpKSnp7/++uvUUML/ucexzCr1kxP1py7B4fgbKKlHSWZlnyzxqRes5D+Uagm1X7Ljc/78efdkVrvmWSMjI8+fP29tqlQvDKJ7BuOZxRhk6vNLQGpSk7+G/5DxrlbZepQcnbos1R673tJq4b1BUDCVJQhksmsYlatnL+oG4r6LK3e+hXa9SYNxLmT3siuzGqTHROGxqEMnNezsfinfy5mhZtxeZe+5BtHrD+MVxiB6/ZFqEuNVXer+5fBdj72GUY94DBnjQB1n2e5Tlx3ohcP9EvN0NJWE/ylAIfsiW1BQcOrUKUEWiYyMjIyM5JZ1Op1WqxV8PXHihF6vT0xM1Ov1er3+uE7HlVMnT6YkJ59LS7O3GQ5TfuFOGufOnXNDZg3nYWTW+Pj406dPFxQUcG2bgqfDbVT1cctTEMbfbTDU4EKejqaSkFntlp2dzc2tRvIIcok1qgqSq5VOp4uNiaEUjUYbH39cpzuh1R7X6dJTUzNSUzNSU9OtJSUlPSWFvzIpKSnRVlJSUnJy8pkzZzIyMsQfU2/vz1veQvYH8ezs7PDwcFdl1hga/jVw5MiRY8eOHT16lLtUoqOj4+LiTp06lZ2dLWize8fJ9QQznbJ/m+XMXgAAMNE8HU0lTUhm9fRouwzlFzH5+ZXx8VWxsfQSF8d9rY6MZJWIiJrIyLqjR2sPH647cmS00B7WREbalKgobl+bcuyYbCk/c6aYF5Vk31A1WRUWFqanpibFxOgjI/lF8oTyyu0xvb29JpPJ089cAACAqWUKZVbqhBZ7okuY7QoKCtLSlOSb6ogILpuOfrUWXnIdj6dHjtTylvkPZbJvZGS1ssxakZhYkZhYlppalJdH6Zdaic8O9d0/DsjLzj6flJSq053WaFIOHqyMi6uMjaWXuLjKuLi6Awe6u7vr6+u53T39tAUAAJhybDKrq/4Gi7uvi/8Wx2DPn4O4nFS+kVovDnaF6ekFqamKMqvE9Co/xdYePlx7+HDtkSOjC7SHgl2oRXlmrUhMrEhKuvPCCwpHTA1nUPAucqkFh1H/7kT85ynCbQAAAMC9KB9x5fxnXXH3dUGUcezzINxAae7Jzy9ITS08c6YqLm60WN8MoDCz2pbaI0dki2vnWa2lOCtLSY/VcAapmZWxxiVkP5XG009bAACAKcc1OVUqs0pN1FnXCBY8gss9AYQIimCzwoyMgtRUyjwrP7yOZVmVZ9aKpCTuTQJsajiDrs2ssmeZg8wKAACgNjaZ1YXvDRB/MJsDiUfhx5VRN5BaKa5fYe4pSEsrTE0tTE29FBd3SWJ61d55VsZbWifi/az8Up6Swu6vS86gQfH5knrrqux5px5OtgFssh+F6OmnLQAAwJRj8w8F+Pl1IjKrwaH/bya1wN5Gdk5OsJfMDFxeHjfJKphn5cKr9at1Qe3zrImJFYmJJZmZUsNumIAzyD5fsgvsqhTWY9c8KzIrAACAehDrDKs1dLoqs4r/u4bBFZnVIIqk4ok06oyabL5hkcisTs6zejazlqWmMnrsqjNosOd8OZlZ+ZVLHV0JvDcAAABAbShzqy6cZ7V3Qcyu6VXxtxgr7cqshdnZ+SkpXKnSaBR91hXt861UlVkrEhOL8vOluuyqM6hkwN0wz2oXZFYAAAC1sXlLgKvezzpB/5N3mu0Hc1Kn7gy0mTbZlbLJpjAnhzLPyoVX61few/FMSf2wqsjI8c+6En/cFW+l5EdcuSizSn2AgAvPoF3nSzD5yjjv02wxDqfwFFvx38wq9a5WTz9tAQAAppwp9D8FnJKXl5+aypVKflSVe2/AJcb86JEjXKkdW+AXbuVEz7OWXLjg6ZGdWNOY07QO8/TTFgAAYMpBZlWmsLDgzBnBPCsXXq1f+Q+94v2sFYmJpRkZnh7ZCWfvPKsSnn7aAgAATDkTklknpd7e3vZJ55tvvvH0uAIAAADIQ2ZVamhoyNMJ0/Um8fkCAACAyYR4ugHe5Nq1a21jPJ02XePBgweeHlQAAAAAeZR51hqQUF9fL8h8XHi1fhU/VHO6bWtr8/SIAgDIc/nvAwHAGyGz2qepqcmBaChIsbIPGStdGIWbmpo8PZwAAPLcf2sEABVCZrVbS0uLIJI6Hx/dr62trba21tNjCQAgz/23RgBQIWRWRwhiqzdqaGjw9CgCACji/lsjAKgQMquDGhsbPR07Hdfc3Ozp8QMAUMr9t0YAUCFkVsfV1dV544RrS0uLp0cOAMAO7r81AoAKIbO6QENDQ2trq8o/JaC9vb2trQ1vCQAAr+P+WyMAqBAy64RoaGi4fPlya2urNcsKPgbL/YG1ubkZf3QFAN7I/bdGAFAhZFaP4WZnJ26Ctq2trbW1tbm5ua6uztN9BQBwnPtvjQCgQsisAACgau6/NQKACiGzAgCAqrn/1ggAKoTMCgAAqub+WyMAqBAyKwAAqJr7b40AoELIrAAAoGruvzUCgAohswIAgKq5/9YIACpEyawAAAAAAKpCLAAAAAAA6oZ5VgAAAABQO2RWAAAAAFA7ZFYAAAAAUDtkVgAAAABQO2RWAAAAAFA7ZFYAAAAAUDtkVgAAAABQu9HMWhs6e3ZorduOKjpcsj/xT3bb4Sekvy6r0s3nYozLT4GgwtpQfw/0CgAAACYH6zyrIGGIAoeLcxT7cG4g7iDhcaCztCFycNhs2+ZAJY4cd/ygyf7OjIO4wmR/Qoh/aKh/aHLobOfqBAAAgClq/L0BtkFpojMr+3DuwAyGyf52ZysXZlbbtrk7syb7W/dN9nciYYrOMOIqAAAAOIqMpwibjCGZWSmTcLw5St6q2aGh3Kb+ydS9pA5HqS3Zn/j7+wtW2lTK7VwbOlsQk8SNluiiOOXx8hqlSeIe8Wqo5aYTk8d340042jZDumujW9QKK5FvjHAX+uCPszZO/GMDL7/aDo09FWKeFQAAAJzFy6zG2tDZ1tQikVn5q5P9xxKRdZU1t9WGziaEWtnoXlKHo9aW7E/4Ec4/eXRBPB9oeyTWloIGUGYmx/anNYnSo7Fv8YMzv1bJBvPzK61tNk1T1hj+LtTvEvG3KZlV8DMApQl2VIj3swIAAIDjbD43gBd1JDLr6BSe8He+RDjJZhsBxXtJHY5em1xQsw1KwmlP6Xch2E6NSmRWapMoPbJOLUu844DeDOFsMz+0ji4LKlHSGGFWFp0yymyzKLNKvTHA4QoBAAAAHGX7WVdSQY/ycCy20JMJ9Q2VvL2kDkevzY7MOjY3yAtcjHfO0oOh7Yas6MXvETe17O9P76DSzErZV7oSycbQEzj1lNEjps3MqezhkFkBAABgghFRtBn/5b7419q036bzf7tt3cAmNDF+Bz92OJv3Popqo2VWfgNtE9boW0T5e0hsadtfqb/BojSJ1iPmOxkkmyF4MwOtbTa/oVfWGN4u7O/ylsdbYnMM/oiMnVp7KwQAAABwkjCzCqKL7V/V2H4klPC3z/wtqe8NsN3L5nD0v8Gi/XmQ8E+dbNs33nCbNVJbjtfN/KwrcZMoPRL9Ct+a6PmjImwG5W+XxOdCqhLpxvB2oX13fN3s2cKIKRgJ/t+PiRugpEIAAAAAp4n/D5abo4bHk41nG8A+uhva5vJDePyEAgAAwCSE/93qWR5PeMisAAAA4AWQWQEAAABA7ZBZAQAAAEDtkFkBAAAAQO3IDQAAAAAAdcM8KwAAAACoHTIrAAAAAKgdMisAAAAAqB0yKwAAAACoHfkAAAAAAEDdMM8KAAAAAGqHzAoAAAAAakeG7vV7ReGaO3h3EEWqTO4hmty9wyBMhQ6697UdAGCyIVqdHgUFBQXFPcXTr/kAAN6KDA/dspahb/tVW4xGo1an/+brbxwunp9mmeAyuYdocvcOgzAVOsj1zpOv9wAA3oyMDN22luF7A6otRqNRq9N/fedrh8vdu99M7jK5h2hy9w6DMBU6aERmBQBwAhkZvmMtw/duqbYYuZvZ7TsOF8enbrykTO4hmty9wyBMhQ4akVkBAJxA7g9/bS38OVe1FaPRqNXp79y67XBxfOrGS8rkHqLJ3TsMwlTooBGZFQDACeT+yDfWMjJ0R7XFaDRqdfrbA7ccLnfu3J7chT1ErVf7kot79qReD0vpTC7uab3a511DJO7d40ePTQo8fvRY/b1zySmeBM+Cyd1BIzIrAIATyP2Ru+OFN+eqtmI0GrU6/a3+AUYpKy09efJk+vn0xvoG8Xfv3L41uQtjiPSGnpMld7puP+gffNg/+LDz1neJZXf0hh4vGiJx78xm89z15+asTmOUV9edM5vN6u+dk6c493Il+6nhFaeY0UGufLJl27HIWKmH6u+gEZkVAMAJ5Lv7g9bCn3NVWzFyN7O+fqmSn5fX3Nz84MGD7u7u9PPnxRvcvjUwuYvUEO04eTW7wXjz7sMrN+5evnazrbO/s8948+7D7IbBnfor3jJE4t6ZTaZX1ynIrCaT+nvnzClu7bryv6KX3bxxg/Hs8IpTLNXBJ1ee++Hy9P+6In3FqrU7du76241507cW/8uui9zDF442Ph/RMDeyXv0dNCKzAgA4gVgslu/uG0fLyF1nCiGEECL10MliNBq1Ov3AzT5qyc/Nu3z58qNHj7777ruLFy8WFRrE29y61T+5C3WITuV37jzdU3V1KKP2bnL2JbPZbDabU3KrcxqM1deGtyd2Jxs6XTVEhBDqMntLh3tnNpl2J1S1Xu0J1VW2Xu25fLVnl/Zic0dXSHxFfeu1oLjy2qaOkLhys8nk8gtAee+oWzrQfcYpDio9MW3v7xPK0wXr7xbUDsXk3tfkD8cXDBbWe8WzgNrBJ5adq++5d67u9vxF772/ZuO/bi/71c6Lz+6u/s8F7y37YOMfT17998TOmQcuub+D9p5HIzIrAIATiMViefDdt1zhz7k6UEZDqsRD/kopjMqNRqNWp+/vvSkuBfn5dXV1jx49evDgwaVLl9LT0/Nyc8WbDQz0ebJcDJxFCCGzdl48vpj4nRzoGxiwLrimUIdo9bHW7fru6Pxbgck3Nu3RWywWi8Xyyf6kkNTe2MJbX+i7V4W3umqICCGMh9waKQ70zsTLrKG6yl3aiyHaiyHxFcFx5UGx5Ts1ZTs1pUGx5SaTyeUXgFSDufXir1K72zsO1FP83OlN03b//o3ojfyVX5c03Nt7ZuRY1n1N/v2Y3KFDGV+XNrrpWTB+qdu9L7WDTyw7909bSrjyz5+X/svW0n/bUf7r4Mrn9tW+fKTx9ZjLr2vafr6j2PmzzH51Un4ZsHvnydd7AABvxmXWe6PlvlGypPkTQsiyZKkNuJd164KYYDPGMrUYjUatTt93o1dQLpaXZ2ZmDg4OjoyMVFdXFxQUFBcXZ2dn5+XmCrbs778pW074WdvrE1gu3qCMuxuP8ktQUufYjuIKE/yI3wmlNcgX6hC9ubPhj6Eta2I6fQ91/H7T6VeXhL3yXuhbm0+/d+Tqhvjriw51zNt7WckQ8UaG+J2gbEAI4b5S8beR2tfe3vEza8vVnqaOrpC48obL14Jiyy41tgdEl1TUXA6MKTWZTMovgP7+BD/pDrJ7R+0OtWtSAyI7DuJBKGqt+bsTS/969++f2P5GczvvVAac+GZjzL0vTt4LTv52x6lvPo7v23lCdhD4Z5n2FEgY+z7juqVe6k5dwxUVFZYx3C8KHj9+/P3339+/f39oaGhwcLC/vz87O1vJWS4P9GE8eWVPnF2XgVTvPPhyDwDg1YjFYnn44B5XrBOutuX0cuur8vLT1G24b/IXBMuCLaVINODbB999a+RuZj03BCU5KenUqVNnz541GAzl5eX19fVXr14dGBjIyckpLy2z2bivV64k+M0KKOOWj/sS6/J4KQ2c5RNYNvrwuB+ZFViqoNrevr4EP+J7XNFKxwt1iHw2Vf56U81vAptf23n51+/u4G78v353x9yAljeCLv8uqOnPexoVDFFpoN/YaJQFzKI1mxAi20LGqXegd/zMypthLQuMKQuILtkRVbwtsmhHVLHJZFJ8AZQGzvKZNYv4HZfviJLeCVayHyoZB/EgbMiPeDrlg2l7fk8+e+Xb6qdMNX9vqvupqe6njyv+zlT548flT32zNurOB+G9S79seu1j2UE47ifbd9mL1qmrmnoNV1VVcdft3bt3fXx8Hj9+/PHHH//whz/cuHHj119/PTAwcP369YyMDNmzXBboQ3tS00+r1LmQ2kb5NezJ13sAAG/GZdah0fLdPcmStpTLrNTv8m+6gpXULdnL1GI0GrU6/c3uHkEpKizMysqqqKjo6Ojo7Ozs6+sbHBy8d+9eZ2dnYmIif8u+mzfsKTo/n4Ay4cqSQB+fwLKxhwm+xE83ujLAlxBCiO9xbv0Yv4QbfTdvHLdOX/kElN3U+XGbjS/c6CsLsE7gzgooGT8Wv1q5Qh2if1pV9OKnl97Z0/rWrtY5C4O4e/8//uGzX3/SMDew5f+F1r8bVGnfECX4EtHIjOYt3rJNDuNtRq1Taj27d/zM2tR+vaH1WnBs+aWmjoDokvKa5i8iivLL6r6IMJhMJoW9O+5H/BJGv0q1k9E76lBQOyi7gfJB+OekD39xfuO0vW+Rz195WPxjc+FPzEVjpfB/mgx/3/XWjitzP63+xdLMv31HdhAYfR9/XoxfjTo/4us3dm1z163tpU55LjhwDdfV1XMzrDNmzJgxY8b333//5JNPNjY2Pvnkkzdv3uzq6mpra0tLS5M7y/yWS55f2bOsZJndO0++3gMAeDNisVi+fzjMlfHwKi5nucyaythmNHeOLfAJtpHCqNxoNGp1+t6ubnHRarVVVVW3bt0aHBzs7OycPn36008//fzzz8+aNevpp5+ePn16Y21db1f3zd4e5aUswIf4akXriwN8fAJKrcvEL2F0YXzj0gAfYt1G6ze6rPUjvgm91pXcsniBfwjbahUU6hC9/onh9U+L397V+Iddl1/y28Vl1mf/FPhG8OU/H7i8OOzi8t2l1o1lDsHlD5+AMtp3CSGyLWScegd6x2VW7k+vguPKg+PKgzRlgTGlO6KKvwg3fH604NMjeVuO5ptMJiW9Kwvw8Qkovtnbk+DLnVaZjjDW83tkXUPd3d5xEAzCyersn6V88L+zPpm27y2ybe79nH8wZ/7MnP2UOftn5uyfmS9Mf3xhehF5PY/89gx55YLPUtlB4CVMqUEQXMljm5UG+IgvZvpzwe5ruLWtjXtLgMlkeu2117777rvAwMAnnnji888/7+zsbG9vb2xsTElJkTnLpQE+vHHmzjXjtDqzzO6dJ1/vAQC8GZdZR8bKsGQ5u4wQQlakSm3A3QlYNTi3i9Fo1Or0N653iUtTfb1Wq21vbx8aGsrKypozZ05YWBiXXMNCw+bMmZOSlHzjelfvjW6lRbeI+OwopXyriH/f8wkoGlvpE1DC29c33rpLgi/x1XX33oj3JYsSRldal8cWdIsEwcVXJ6pWQaEO0dHkupc+SJ+7qfDZzVW/WBgz43efPPP7T/9pkWbOZ3Vvbin5w0cZUSl11o0VHahkh894X8YLIcS6ICDeRmpfu3pnzawh2osNrdfqWq7u1JSV11zeFlmUX1rz6eG8czmlnxzKNZlM8r3jnbWxUyZsIZtgBKhfBbWJd7F3ED7MPPRvFz6bZdj+Vwf+QAJ/O1zy9+bMp81Z082ZM8wXZpgvTH+U+9Rp8vIJ8qJm2vN1xxLteBZInGWJK5l/ufJW0p8Ldl/D165ds76N9be//e3w8DAhZGBggBDS1tbW2NhYXV2dcjpF5iyX7PAZf1LH+xLKk0vqWhUsM64BJb3z5Os9AIA3IxaL5fvv74+W8fAqKqOZ9Qz1u7J3dIWbWbcUFyN3M+u8Ti1lxcWpqamDg4Pvvvvu4sWLT58+PWPGjGeeeebMmTPvLV78H++8c6Pz+o2eLiWlJGAm8dleQv9uUYDPzIBi5krtIuIbZ/2uzpf4artu9MT5kkW60ZXW5bEF212Yx2IVqSH69w1JLy5LnLni/DPL8n6ytPjHS0unLzfMXHlh7vuJCz9NttlY0YHoDSOEyO7LOO8O9I7LrC1Xuq3vZA2IKd0eWbQ13PDZkfyPD+Z8dCBr81fZJpNJtnclATMF7fEJKGL0gtFfwXrBxoL+2jsOgkHILs1/93Tgr6JX/pf9f3x61/yh5ifNl580X/4fo6XlyYe1T4b99cz9P/5N2ie77TnFjMuPeiXzt+etpD8X7L6Gu7u7TSbTo0ePHj58+Jvf/MZoNK5bt+6JJ55YuXJlc3NzXV1dZWVlcnKyTAeLt/vwntfUxvDHX2qZca4VXsMefLkHAPBqxGKxPPr+u7FyX7Kc4zJrGmubscLdfcXLgg34ZOs0Go1anb7nWie1cPOsmZmZL7300pYtWxITE38+Y8bPZ8xITEzcsmXLyy+91HOts6fnumzR+hLiGye9gSHAZ2ZAMXNl8XYfMvZwfDnOlyzUjm5vXeYvEF/taA3FATN9tVLHYhXGEP35g4OzF8X+n4XHf7Hg1D/+Wf/LBcfn+GoWfbBfuKVU5cXbfazDUrzdZ7wv44UQYl0QoNYptV5577jM2kqOpGgAABQRSURBVNzRHRJfXn/5Wk1TR0B0SUlV4+fHCjPyL276Klt/Nu8v+zNNJpNM70TXgPVcMJrNbz+3TO219VuMsVI+JuxnwePeJy19P7D0/8DS/wNL3w8svU887v7vSk8xdx3KnWWJK5l/ufJW0p8Ldnewq6urt7f3xo0bXV3dnZ3X29s7mptb6urqL1ZWFpeU5Ofnp6enn01Lk+ugIcDHembjfGmNoZ5cqYf2XsDW3nny9R4AwJsRs9n86NGD0TIeXvklbYXNvXjO/svUzb4TxdDxleLNqAuMYjQatTp999Vr1JKZkVFfX3/mzJnf/e53L7/88vNz5rz6yiuvvvLKCy+88NpvX3vrrbe6r17r7u6UKUXbfGy7sChesE3hDp+ZO4rkVvLqGashdhFZGN8tWOattDk0t5J6LFZhD1H31WuLVwa/vWTf20v2vbcymL6NZOWFO8bbR28VIUSwIH7ILYu3FOyisHcmk+lLfXWo9uIu7cWQ+Iqg2PKAmJLtkUVbjxV+ejhv81fZG/df2HQg02w2y/XOpsQvEp/38fYzuiPVI3Hv+Duyt7TrFD+88XPTzR+ZbvzY1PPjx11/9/j6j76/PkPxKVZylmPH3sUiuoDHL1f+Supzwe4OlpRXfv3N4K07dwdu3+ntv9XVc7P9yvWmlrbqusaLl2pKyi/mFhSXGYoUdNDafnpjlFzD1CtBYTEiswIAOIE8fvSQVx44Vqw3OsFDqfX8h9RviYvRaNTq9F1XrlJLcUFhkj5Rq9W+/NJL29c/+03D6udmP/fC83O+aVi9ff2zc199tevK1e6ua5O7sIdISXHm6IQQ64KAYBv+GqmVSnpnUcwlveO3k99ZqS0VdllqrFR4it1QqB0sKa8sKq3IN5ReyCs8dyEn9Xxm0pnzupNJkZqEr45EhO37aueuPbmZWa66hqnnlPpQySkT986Tr/cAAN6MPH78Pa88FBRx/hhNlqItxXuJlxmbyRYjdzPruEItNRUXC3Nyci9kPvvss/lxL96qXPj8nDnPz5lzq3JhftyLL77wQlfHla7rV9mF2lPZvdRT2EOkqDgxMtY1gm9R14urkh3qieudXade/C1+FwSdFXRZcCzqsHjFILj5Gjbk5uVnZRfm5EiV/KzsiuISJ69h6ikTbCZ15SscLiMyKwCAE4jp8SNe+V61xWg0anX66+0d7HI8Pn727NnPzZ59Uqs7qdU9N3v27Nmzj8fHX2/vuN55ZXIXhUPEKp7uwpTtHQZhKnTQiMwKAOAEYjI95pVHqi1Go1Gr03e2tTternVM7jK5h2hy9w6DMBU6aERmBQBwAjGbTLzyWLXFaDRqdfprrW2Ol6vtk7tM7iGa3L3DIEyFDhqRWQEAnEDMNkyqLUajUavTo6CgoKCgoKCgTMFCPB2aAQAAAABkILMCAAAAgNohswIAAACA2iGzAgAAAIDaIbMCAAAAgNohswIAAACA2iGzAgAAAIDaTa3MWggwxtMXIwAAANiBmEwmk8lkNptNJpPURtYNGNg1jIyMjIyMDCswMjLCaK6TLSksLKwGqK6mZtaOjo7+/v6bTP39/R0dHYxL1Gg0bt261dfXd8GCBQMDA319fVVVVWVlZTk5OSkpKXFxcQsWLFi0aNHChQsZNbikJa7qDgAAgBqQ51alPbcq7ZW158xms9RGZrP51XXnuC2lCruG4eHhGX+MnfHH2J++Gc0o0/8YOzw8zGiuky1BZgUONbMODQ2tWrVqKdPKlSuHhoYYl+iWLVt8fX39/Pzmz5/f3d39k5/85JlnnklPT9fr9XFxcUePHp03bx63AaMSl7TEJZUAAACohNLM+spaZzPr9D/GTndFZnWmJciswKFm1rt3765cuVI25N29e5dxib733nuLFy9eunTpggULuru7n3rqqV/+8pe5ubmpqak6nS4iImL+/PlLlixZvHgxoxKXtMQllQAAAKgECYorr23qCIkrZ2fW3QlVrVd7QnWVrVd7Ll/t2aW92NzRFRJfUd96TUkNw8PD+z/ab5lJzvv5WWaSvRv3WGaS/Rv3iNfIZlZnWoLMChypzBoXF9fR0REbG9vR0dHR0aHRaNra2mJiYpqbm6OiohoaGqKjo2Uz67Jly1atWrVkyZLu7u5Zs2bNnTvXYDCcO3fuxIkTUVFRfn5+/v7+q1atYlTikpa4pBIAAACVIDs1ZTs1pUGxSjNrqK5yl/ZiiPZiSHxFcFx5UGy5khqGh4dX7s5bGZbz/q7sFSHZy4OzlgdfWBGSLV6jPLM60BIXZtZ169atW7fOyd2dqcEZnj26Gshm1tjYWI1GExMTExMTEx0dHRUVFRkZGRkZGRUVxQ55S5YsWb169YYNG1avXt3U1FRZWZmWlpaXl5eenn7q1KmYmJgVK1YsXbp08+bNjEpc0hKXVAIAAKASJCC6pKLmcmBMqcLManlzrvkPr4fElTdcvhYUW3apsV1JDcPDwyt3ZVtmknO+vpaZZPe6UMtMsizognXN0p0Zlplkz/ow5ZnV8uZcy5tzQ+LKLW/ODYots7w5NyC6xPyH1xkt4WfWdTyO5R7nM59nUyMyqwA/5K1du3bt2rXR0dFr166Niopau3ZteHj4+vXrIyIi2CFv2bJlGzdu/Oyzzz799NMPP/xw3bp169evX758+eLFixcuXOjv7//hhx++//77YWFhjEpc0hKXVAIAAKASZHtU8ReRRdujihVmVt68ZllgTFlAdImSGoaHh9/flb13w56PP9PuXhf6wef60A9D/APSV4RkLQvKWrozwz8g/b3t5/wD0pVnVgdaIphntYY2x9Lb5MusUyfFymZW/pRkREREeHj4sWPHjhw5cuzYMXbIW7FixV/+8pctW7YEBgbu2LHjyJEj6enpR48ePXz48LZt27Zs2fLRRx/t3bv30KFDjEpc0hKXVAIAAKASZGtEUX5Z3dYIg8LM2tR+vaH1WnBs+aWmjoDokvKaZiU1DA8Pvx+SbZlJ0hYutMwkuz4Iscwki784K/XHWBPUEmRW9tEnR2YtKiqSXSmbWVtbW1taWqKiourr68PDwy9dunT48OGSkpLDhw+zQ97SpUu3bt166NChmJiYiIiI2traDRs2vPjii9yv5o8fP67T6ZKSkpRnVodb4pJKAAAAVIJsOVrwyZG8z47my2ZW7g+eguPKg+PKgzRlOzWlB/TZYdp9QeGB4YnhO+MP9t7plapheHh4RXDWsqAL/gHpi7eeXfhZ6p8+Pb3gs5Sfvhn9RXT10dMtx1JajqW0HD3d8kV0jWxmdbgl4swqfm+A8jXcynUi4r2k3ofAfyi1L7Ulgg2oD8Ubizejdsqrk2tlZWVycnJubi5/ZW5ubnJycmVlpXUNO7NqNJro6Ojo6GjuTZ8JCQk6nS5uTFdXF+MZtX79ep1Od/LkyVOnTkVERFy6dCkkJGTDhg15eXnh4eF6vT4hISEhIeHLL79kVCLVEp1OFxMTw70PNSYmprdX8hnnqkoAAABUgnxyOO9cTunHh3KVZNYQ7cWG1mt1LVd3asrKG2qPJX/1pT5sf86RB48e6g3J4WfDu/vpt/Ph4eHlwVmWmeTMggWWmSR53nzLTPKadt4/vHPwUFLT4OC3Q0NDQ0NDg4P3DiU3K8msjrWEOs9KjXF2LYgp3EsqwrJrlt2LMYHKODr7uF5EEFvFgbVaLrPGxMS0tLQ0NTVFRkbW1tampqaePn3abDabzebk5ORz585lZGRIXaI7d+7UaDSRkZEajebgwYP79u2rqqqqqqrav3//oUOH4uLiNBqNRqM5cOCAVA1SLampqUlISLAGUI1Gk5ycnJmZaW8lFRUVQ0ND3LsFhoaGLl26xKgEAABAJcjmgzl/OZC16ats2czacqXb+v7RgJhSTd6piJwDh+uid9eftFgsj82ms7XpmQ1nqTUMDw8vDboQ+mHI+r9EBb4f+N6G2C/8v5hZTX6V+zcrzgScym5LzO1IzO3Q57R/eqxSNrM63BLZ9wZQ5xrFE6iCBbEJzaziNVJtZtc8WTNrNS+2UgNrNTOztre389/6mZWVlZmZWVhYyGXW3NzcjIyM5ORkqUs0LCwsPDw8MjIyNjY2IiIiODh4/fr1GzZsCA4Ojo6OjouLi4mJ0Wg0+/btk6pBqiVJSUlcGo4aw1VobyUjIyNms3lgYGBgYMBsNo+MjDAqAQAAUAny0VfZ+rN5G/dnymbW5o7ukPjy+svXapo6AqJLdhcF9/X1DQ4OPnz48OHDh7dv3+7o6Ei8lEKtYXh4eOnOjMjtZP3Bf43cTv4c/krkdjKzerS8nP2r/zj85cJtBYu2FywMKJTNrA63RElmFYQbd86zViv4CC27gqYDR2cc2rtwsZUaWKuZmdX6CaYNDQ3h4eFpaWm3b9828/T392u1WqlLNCQkZN++ffv27Tt48OBXX321b9++oKCg4OBgbs2hQ4e+/PLLgwcP7tmzR6oGqZbs3btX3JKAgAB7K4mLi+vv7+dq6Ovr02g0jEoAAABUgmz6KnvD/gsfHWBlVpPJ9KW+OlR7cZf2Ykh8RVBseUBMyfyUD69fv97e3s7dDjkHSk9SaxgaGloalGENqeLyf8ueDUto2JVQvyiQlVmdbAn1s66qbZMiY56VPR0rIFXnOhrBjuw6GVOtjOZRjyu1jVQDvEtlZSU1sFZLZNZ79+4dP36c+919TExMVFRUeHj40aNHGxoaenp6RkZGRkZGuru7a2pq9u7dK3WJhoaGbt68ec2aNWvXrv3www/XrFnzwQcfrF69es2aNevXr9+0adPmzZu3b9/OzqzUlixfvlzckpUrV9pbyebNm1taWsxms8lkam5u3rRpE6MSAAAAlSAWHqmNLDRH6hN/lbDib04F/ZXuQEtLS11T43+mRgeUnqDWMETDpdXZOdN/v3ePX0DB4oACv4CCtzdlMTKrky1R///BmjR5UeWomfXx48dmkcLCwl27dgUFBZWVlZWWln7xxRdbtmw5fPiw1CW6ffv2Xbt27dq1KywsbPfu3Xt59uzZs2fPnt27d4eFhbGnNqktSUhImDdv3gKeefPmBQcH21tJRUVFZ2dneXl5eXn5wMBARUUFoxIAAACVIM7s/Ibuo//21RoSFVzbevk5zZ5fxuy8MtCjfPdFhuef+WzJG+szfscrb6zPYGRWJ1ui5sw6mSY41Y+aWaV8/vnnH330UV1dXW1t7Zo1azZt2tTe3m7vJeq8zMzMxYsXv/POO/Pnz583b97bb7+9ZMkSe1uSmZm5evXqoqKiP/3pT/Pnzy8sLFyzZo1HugMAAGAXpzLrlf7uteej/yFo1e8iApedjmnru2FvDU//QUP5fNY3NBPUEjVnVnAnuzJre3t7WFjY8uXLly9fHhwc7MGE197evm3btnfffffdd9/dunWrYy1xSSUAAABu5lRm9TrIrMCxK7MCAACAxyGzwlSEzAoAAOBdplxmBeB4+mIEAAAAO0ytzAoAAAAA3giZFQAAAADUDpkVAAAAANQOmRUAAAAA1A6ZFQAAAADUDpkVAAAAANQOmRUAAAAA1A6ZFQAAAADUjqwAAAAAAFA3Ej9lWAAAAADAO8m8N4BLe+6Z8p1QyKwAAAAA3otUlmdJFSMvs1aWZw1f2uqlBZkVAAAAwKuRqoocqcLPrFUVOUM1gV5akFkBAAAAvBq5VJknVfiZ9VJl3lBdmPJCCCGE2LXLxBVkVgAAAACvRmqqCqQKP7PWVBXcazxgVyGE2LvLBBVkVgAAAACvRmqri6QKP7PWVhfdaz5qVyGE2LvLBBVkVgAAAACvRuprSqQKP7PW15R82xpjVyGE2LvLBBVkVgAAAACvRhrqyqQKP7M21JVxb1H9tl1nXeCK4KF1DX9j/jZK6hHv5UxBZgUAAADwaqSxvkKq8DNrY32F8UoiFyKNVxKtxfrQ3gV2PeKvThVkVgAAAABvRpobq6QKP7M2N1YZO9MIIcbONH7hT4ha1yhfkKpH/NWpgswKAAAA4M1IS3O1VOFn1pbmamPXBUKIsesCvzDWKFmQqod7yP/qVEFmBQAAAPBmpLWlVqrwM2trS611HnTwRj6/iNfzJ03FGyipR/zVmYLMCgAAAODVSFtrg1ThZ9a21obBm6WOFUKIw/u6pCCzAgAAAHg10tHWJFX4mbWjrenuQJUDxTp76tjuLinIrAAAAABejVzpaJEq/Mx6paPl7u0GLy3IrAAAAABejRiZrJnV2yGzAgAAAHgvEs9EJhFPDzUAAAAAOAiZFQAAAADUTua9AVzau+XlkFkBAAAAvBoZvrSVUdyWWQVzovz19u5FrQSZFQAAAMB7kRU8QzWBguLOzCoVSe3ai5p3kVkBAAAAvJptZq0LExTPZlbGeqnvIrMCAAAATD6jSY7LrPcaDwiKR94bIJVBleyFzAoAAAAw+dhm1uajguKReVa73s8qWEZmBQAAAJh8bDLrt60xguKRzw1QnlnFeyGzAgAAAEw+tpm1XScomGcFAAAAAI+zyazGK4mC4s55VqnPqGJHWIV7IbMCAAAAeC/bzNqZJigeeW+AyyGzAgAAAHg128zadUFQkFkBAAAAwONsMuvgjXxBQWYFAAAAAI+z+Z8CgzdLBQWZFQAAAAA8ziaz3h2oEhRkVgAAAADwOHL3dgOjILMCAAAAgMcRIxOZRDw91AAAAADgIBLP5Omc6UqeHmoAAAAAcBCSHAAAAACoHTIrAAAAAKgdMisAAAAAqB0yKwAAAACoHTIrAAAAAKgdMisAAAAAqB0yKwAAAACoHTIrAAAAAKgdMisAAAAAqB0yKwAAAACoHTIrAAAAAKgdMisAAAAAqB0yKwAAAACoHTIrAAAAAKgdMisAAAAAqN3/B2STDEhLV422AAAAAElFTkSuQmCCAA==
求指点
minidao 查出来多少 minidao sum出的是45.32，实际应该是 51.50 admin 发表于 2018-6-6 15:39 static/image/common/back.gif
minidao 查出来多少
minidao sum出的是45.32，实际应该是 51.50 代码贴出来，把日志打出来 admin 发表于 2018-6-6 15:48 static/image/common/back.gif
代码贴出来，把日志打出来
调用的地方
logger.info("----into --34-getRedpacketReward----userId:"+userId+"__dateStr:"+dateStr+"__sendflag:"+sendflag);
Map<String, BigDecimal> storeInfo = appRedpacketMiniDao.getRedEnvelopesReward(userId, dateStr, sendflag);
String sum=storeInfo.get("redprem")+"";
if (sum.equals("null")) {
sum="";
}
logger.info("----into --34-getRedpacketReward----sum:"+sum+"__dateStr:"+dateStr);
定义的地方
@Arguments({"phone","pdate","sendflag"})
@Sql("select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag")
Map<String, BigDecimal> getRedEnvelopesReward(String phone,String pdate, String sendflag);
九月 发表于 2018-6-6 15:55 static/image/common/back.gif
调用的地方
logger.info("----into --34-getRedpacketReward----userId:"+userId+"__dateStr:"+dateStr+" ...
调用的地方
logger.info("----into --34-getRedpacketReward----userId:"+userId+"__dateStr:"+dateStr+"__sendflag:"+sendflag);
Map<String, BigDecimal> storeInfo = appRedpacketMiniDao.getRedEnvelopesReward(userId, dateStr, sendflag);
String sum=storeInfo.get("redprem")+"";
if (sum.equals("null")) {
sum="";
}
logger.info("----into --34-getRedpacketReward----sum:"+sum+"__dateStr:"+dateStr);
定义的地方
@Arguments({"phone","pdate","sendflag"})
@Sql("select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag")
Map<String, BigDecimal> getRedEnvelopesReward(String phone,String pdate, String sendflag);
日志：
----into --34-getRedpacketReward----userId:13716837204__dateStr:2018-06-06 15:29:51__sendflag:R
MiniDao-SQL:
select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag
----into --34-getRedpacketReward----sum:45.32__dateStr:2018-06-06 15:29:51 直接返回long 类型试试 admin 发表于 2018-6-6 16:41 static/image/common/back.gif
直接返回long 类型试试
还是不行
代码：
@Arguments({"phone","pdate","sendflag"})
@Sql("select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag")
Map<String, Long> getRedEnvelopesReward(String phone,String pdate, String sendflag);
日志：
----into --34-getRedpacketReward----userId:13716837204__dateStr:2018-06-06 18:20:12__sendflag:R
MiniDao-SQL:
select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag
----into --34-getRedpacketReward----sum:45.32__dateStr:2018-06-06 18:20:12 那就是条件不对，你自己调试看看
页:
[1]
2