Return-path: Envelope-to: miguel@ssf.com.mx Delivery-date: Sun, 27 Mar 2016 15:55:39 -0600 Received: from o1678990x3.outbound-mail.sendgrid.net ([167.89.90.3]:25000) by vishnu.hosting-mexico.net with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.86_1) (envelope-from ) id 1akIen-002kgi-Ex for miguel@ssf.com.mx; Sun, 27 Mar 2016 15:55:39 -0600 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=bitbucket.org; h=content-type:mime-version:subject:from:to:references:in-reply-to; s=s1; bh=xGisLDS7FP+S07Y2OwJ5ASedgEk=; b=N5noCbRf7O/R5uYjzxWYTfM 9T2VDj7JTi//nb/xxYVz2dbjvK7husQ+fOy0gcPRVIBhyFnfotqYlC/cYOnXs19J SW/rg/xtjnLUYmczKP23bdpOZO91HV8fgEPp0qwVRCHoRrRfH/YZgHCZlE7klJ+2 l32EUmOfAklulBiNuqh8= Received: by filter0578p1mdw1.sendgrid.net with SMTP id filter0578p1mdw1.20865.56F856B1B 2016-03-27 21:54:57.088872696 +0000 UTC Received: from celery-worker-103.ash1.bb-inf.net (mail-ash.bitbucket.org [104.192.143.195]) by ismtpd0006p1iad1.sendgrid.net (SG) with ESMTP id 9Evta3tZRneXA-f3lI97HA for ; Sun, 27 Mar 2016 21:54:57.116 +0000 (UTC) Received: from celery-worker-103.ash1.bb-inf.net (localhost.localdomain [127.0.0.1]) by celery-worker-103.ash1.bb-inf.net (Postfix) with ESMTP id F0E615797D for ; Sun, 27 Mar 2016 21:54:56 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============2022063421756654604==" MIME-Version: 1.0 Subject: Re: [Bitbucket] Pull request #96: Traidos cambios de version 2 (globalgassf/globalnet3) From: "Alexander Garcia" To: miguel@ssf.com.mx Date: Sun, 27 Mar 2016 21:54:56 -0000 Auto-Submitted: auto-generated Message-ID: References: Precedence: bulk In-Reply-To: X-SG-EID: jcizN1ZJXGzc0OL9Q7wZ4g3GQhOSGfYMdoZYX2+1Ytcow6esqjQN/i5szkKo0xJG6eJg+IJajfHzlz MmX067iLyBOhGfwr9OpGfFybI8A/Dg6zp7Z8IOAzJrYL6t17ppdyJu03Z4SJVytPBNYh84u/7rzzru dNKs2mivRt6zqQUMuqmvl6/U3POweaQs654x7EpvcdtwqXq1geMX40KrLDuJKsw8c5N53mqWU6TBh9 PVyykx0D661rplcV22Hd3m X-Spam-Status: No, score=-0.1 X-Spam-Score: 0 X-Spam-Bar: / X-Ham-Report: Spam detection software, running on the system "vishnu.hosting-mexico.net", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see root\@localhost for details. Content preview: --- you can reply above this line --- New comment on pull request: https://bitbucket.org/globalgassf/globalnet3/pull-requests/96/traidos-cambios-de-version-2#comment-16327807 [...] Content analysis details: (-0.1 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 0.0 URIBL_BLOCKED ADMINISTRATOR NOTICE: The query to URIBL was blocked. See http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block for more information. [URIs: cloudfront.net] -0.0 RCVD_IN_DNSWL_NONE RBL: Sender listed at http://www.dnswl.org/, no trust [167.89.90.3 listed in list.dnswl.org] -0.0 RCVD_IN_MSPIKE_H4 RBL: Very Good reputation (+4) [167.89.90.3 listed in wl.mailspike.net] -0.0 SPF_PASS SPF: sender matches SPF record 0.0 HTML_MESSAGE BODY: HTML included in message -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from author's domain 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not necessarily valid -0.1 DKIM_VALID Message has at least one valid DKIM or DK signature -0.0 RCVD_IN_MSPIKE_WL Mailspike good senders X-Spam-Flag: NO --===============2022063421756654604== MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit --- you can reply above this line --- New comment on pull request: https://bitbucket.org/globalgassf/globalnet3/pull-requests/96/traidos-cambios-de-version-2#comment-16327807 Alexander Garcia said: El metodo lo cambie a que fuera asi, para que de una vez se vaya SELECT COALESCE(SUM(d.quantity),0) FROM NoteDetail d " + "LEFT JOIN d.note n " + "LEFT JOIN n.account c " + "WHERE c.customer.id = :customerId " + "AND n.entryDate " + "BETWEEN :initDate AND :endDate -- Unwatch this pull request to stop receiving email updates: https://bitbucket.org/globalgassf/globalnet3/pull-requests/96/unwatch/miguelssf/550b27d8065c7f700ede37cae268ac94daf79a80/ --===============2022063421756654604== MIME-Version: 1.0 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit
Alexander Garcia commented on pull request #96: Traidos cambios de version 2
app/mx/ssf/globalgas/daos/income/sale/NoteDetailDAO.java
171 + + "LEFT JOIN d.note n "
172 + + "LEFT JOIN d.note.account.customer c "
173 + + "WHERE c.id = :customerId "
174 + + "AND n.entryDate "
xander-ssf
Alexander Garcia commented on pull request #96:
Traidos cambios de version 2

El metodo lo cambie a que fuera asi, para que de una vez se vaya

SELECT COALESCE(SUM(d.quantity),0) FROM NoteDetail d " + "LEFT JOIN d.note n " + "LEFT JOIN n.account c " + "WHERE c.customer.id = :customerId " + "AND n.entryDate " + "BETWEEN :initDate AND :endDate

View this pull request or add a comment by replying to this email.
175 + + "BETWEEN :initDate AND :endDate ")
176 + Double findMaxConsumationOfMonthByCustomer(@Param("customerId") Long customerId, @Param("initDate") Date initDate, @Param("endDate") Date endDate);
158 177 }
Unwatch this pull request to stop receiving email updates. Bitbucket
--===============2022063421756654604==--