nopaste

                                                                                                                                                                                                                                                               
Delivered-To: [email protected]
Received: by 10.76.133.164 with SMTP id pd4csp327526oab;
        Mon, 14 Oct 2013 15:17:56 -0700 (PDT)
X-Received: by 10.182.44.134 with SMTP id e6mr30188804obm.14.1381789076174;
        Mon, 14 Oct 2013 15:17:56 -0700 (PDT)
Return-Path: <[email protected]>
Received: from 216459-web1.unfuddle.com (216459-web1.unfuddle.com. [98.129.249.98])
        by mx.google.com with ESMTP id gw9si16977581obc.33.1969.12.31.16.00.00;
        Mon, 14 Oct 2013 15:17:56 -0700 (PDT)
Received-SPF: pass (google.com: domain of [email protected] designates 98.129.249.98 as permitted sender) client-ip=98.129.249.98;
Authentication-Results: mx.google.com;
       spf=pass (google.com: domain of [email protected] designates 98.129.249.98 as permitted sender) [email protected]
Received: from us-east-1c-relay-i-8c074ff6 (ec2-184-73-209-69.compute-1.amazonaws.com [184.73.209.69])
	by 216459-web1.unfuddle.com (Postfix) with ESMTP id CF504381802C
	for <[email protected]>; Mon, 14 Oct 2013 17:17:55 -0500 (CDT)
Received: from us-east-1c-unfscheduler-1-i-b5c17bd7 (ip-10-86-11-69.ec2.internal [10.86.11.69])
	by us-east-1c-relay-i-8c074ff6 (Postfix) with ESMTP id 770E62003D
	for <[email protected]>; Mon, 14 Oct 2013 22:17:55 +0000 (UTC)
Received: by us-east-1c-unfscheduler-1-i-b5c17bd7 (Postfix, from userid 33)
	id 76A25448DB; Mon, 14 Oct 2013 22:17:55 +0000 (UTC)
Date: Mon, 14 Oct 2013 22:17:54 +0000
From: Unfuddle Notifications <[email protected]>
To: [email protected]
Subject: ZipRecruiter: Ticket #4864 - Autorenewer should clear dates on copied notifications
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=mimepart_525c6d936bb5e_4be83fee7cf3e940110077
Message-Id: <20131014221755.76A25448DB@us-east-1c-unfscheduler-1-i-b5c17bd7>


--mimepart_525c6d936bb5e_4be83fee7cf3e940110077
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: Quoted-printable
Content-Disposition: inline

Recent Activity for ZipRecruiter since 14 Oct 2013 21:38




=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
Tickets
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

#4864 Autorenewer should clear dates on copied notifications
------------------------------------------------------
(http://starterview.unfuddle.com/a#/projects/1/tickets/by_number/4864)

I guess from [comment 5 at #4477](https://starterview.unfuddle.com/a#/pro=
jects/1/tickets/by_number/4477[comment-7923]) that when the auto-renewer =
copies budget threshold notifications, it neglects to reset the last-sent=
 dates on them, so that the notifications are sent at the wrong times, or=
 perhaps not at all.

See budget 1079, which was created on 2013-10-01, I suspect by the autore=
newer, and which did not send any notifications until it hit 90% today.



Comments

Mark D. said on 14 Oct 2013 18:14:
I think the notification dates are fixed.  I did:

        update  board_budget_notification bbn
            join board_budget bu using (board_budget_id)
            set last_passed =3D '2013-10-01'
            where bu.autorenew =3D 1 and
                  last_passed < '2013-10-01' and
                  threshold =3D 0 and
                  bu.start_date >=3D '2013-10-01';

The idea here being to select the notification base time (`threshold =3D =
0`)budgets from this month (`start_date >=3D '2013-10-01'`) that resulted=
 from autorenews (`autorenew =3D 1`) where the base time was nonsensical =
(`last_pased < '2013-10-01'`), and reset it to the time that the budget w=
as actually created.

A notification is sent if the threshold is exceeded and the notification'=
s last-sent date is greater than the base time for the notification group=
.  Notifications would have been missed when they were sent for last mont=
h's budget, because the times were copied to the new budget.  But all suc=
h times should be for dates prior to October 1 when the budget was actual=
ly created, so resetting the base time to October 1 should cause all noti=
fications to be sent correctly.






----
You have received this email notification because you have either subscri=
bed to it, or are involved in an Unfuddle project.  You are subscribed as=
 [email protected].  If you wish to unsubscribe from this notification=
, please visit http://unfuddle.com/support/optout?confirmation=3Df3ed566b=
59022e857cb1b772a75db5bc1d8bb358de37f9ef6b9ba57fbf74b376&email=3Dmjd@zipr=
ecruiter.com&origin=3Dnotification

--mimepart_525c6d936bb5e_4be83fee7cf3e940110077
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: Quoted-printable
Content-Disposition: inline





<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
  <title>Recent Activity for ZipRecruiter since 14 Oct 2013 21:38</title>=

  <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf-8=
" /> =

</head>
<body style=3D"font-family:Verdana,sans-serif !important; font-size: 150%=
; font-size: 12px !important; width:800px;">
  <style type=3D"text/css">
        a,
    a:link,
    a:visited{ color: #009; }
    a:hover,
    a:active{ color: #900; }
    a img{ border: 0; }

    body h1,
    body h2,
    body h3,
    .title{ font-family: "Trebuchet MS", Verdana, sans-serif; }

    .message .content h1{ padding: 0; }
    .message .content h1,
    .message .content h2,
    .message .content h3,
    .message .content h4{ text-align: left; border: 0; }
    .message .content h1{ color: #000; }
    .message .content h2{ color: #111; }
    .message .content h3{ color: #222; }
    .message .content ul,
    .message .content ol{ margin-left: 10px; padding: 0; }
    .message .content ul li{ list-style-type: disc; margin-left: 10px; pa=
dding-left: 0; }
    .message .content ol li{ list-style-type: decimal !important; margin-=
left: 10px; padding-left: 0; }

    .ticket .description p{ margin: 15px 0; border: 0; text-align: left; =
padding-left: 0; }
    .ticket .description h1,
    .ticket .description h2,
    .ticket .description h3,
    .ticket .description li{ margin: 3px 0; border: 0; text-align: left; =
padding-left: 0; }
    .ticket .description ul,
    .ticket .description ol{ margin: 0 0 0 10px; padding: 0; }
    .ticket .description ul li{ list-style-type: disc; margin-left: 10px;=
 padding-left: 0; }
    .ticket .description ol li{ list-style-type: decimal !important; marg=
in-left: 10px; padding-left: 0; }
    .ticket pre{ overflow: auto; background: #fff; border: 1px solid #ccc=
; width: 99%; }
    .ticket.priority_highest pre,
    .ticket.priority_high pre{ border-color: #f99; }
    .ticket.priority_low pre,
    .ticket.priority_lowest pre{ border-color: #9ED2F2; }
  </style>

  =

 =

  <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" width=3D"100%" =
style=3D"font-family:Verdana,sans-serif; font-size: 12px;">
        =

    =

    =

                        <tr valign=3D"top">
          <td width=3D"80" id=3D'tickets' style=3D"text-align: center; bo=
rder-top: 1px solid #ccc; padding: 10px 10px 10px 10px; min-height: 40px;=
 background: #fff">
                        <img src=3D"http://unfuddle.com/email_assets/tick=
et.32.gif" width=3D"32" height=3D"32" alt=3D"Ticket" />
            <div style=3D"margin-top: 0px; font-size: 9px; width: 100%; t=
ext-align: center; color: #666;">Ticket</div>
          </td>
          <td style=3D"border-top: 1px solid #ccc; padding: 10px 10px 10p=
x 10px; min-height: 40px; background: #fff">
            <div style=3D"font-size: 120% !important; border: 1px solid #=
FC0; font-size: 12px; padding: 5px; background: #FFF5CC;background: #FFEE=
EE; border-color: #f99;">
              <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" wid=
th=3D"100%">
                <tr>
                  <td>
                    <h2 style=3D"font-size: 16px; margin-top: 5px;padding=
: 0; margin: 0 0 10px 0;"><a href=3D"http://starterview.unfuddle.com/a#/p=
rojects/1/tickets/by_number/4864">Autorenewer should clear dates on copie=
d notifications</a></h2>
                  </td>
                  <td align=3D"right">
                    <div style=3D"color: #8CA68A; font-size: 27px;color: =
#900;">#4864</div>
                  </td>
                </tr>
                              </table>
            </div>

                          <h2 style=3D"font-size: 16px; margin-top: 5px;"=
>Comments</h2>
              <div style=3D"margin-left: 15px; margin-top: 1em; margin-bo=
ttom: 1em;">
                                  <div style=3D"font-weight: bold; font-s=
ize: 12px; margin: 10px 0 0 0; padding: 0;">Mark D. said on 14 Oct 2013 1=
8:14:</div>
                  <div style=3D"margin: 0 0 0 16px; font-size: 12px; padd=
ing: 0;"><div class=3D"markdown_formatted"><p style=3D'font-size: 12px;'>=
I think the notification dates are fixed.  I did:</p>

<p style=3D'font-size: 12px;'re><code style=3D'font-size: 12px; white-spa=
ce: pre;'>    update  board_budget_notification bbn
        join board_budget bu using (board_budget_id)
        set last_passed =3D '2013-10-01'
        where bu.autorenew =3D 1 and
              last_passed &lt; '2013-10-01' and
              threshold =3D 0 and
              bu.start_date &gt;=3D '2013-10-01';
</code></pre>

<p style=3D'font-size: 12px;'>The idea here being to select the notificat=
ion base time (<code style=3D'font-size: 12px; white-space: pre;'>thresho=
ld =3D 0</code>)budgets from this month (<code style=3D'font-size: 12px; =
white-space: pre;'>start_date &amp;gt;=3D '2013-10-01'</code>) that resul=
ted from autorenews (<code style=3D'font-size: 12px; white-space: pre;'>a=
utorenew =3D 1</code>) where the base time was nonsensical (<code style=3D=
'font-size: 12px; white-space: pre;'>last_pased &amp;lt; '2013-10-01'</co=
de>), and reset it to the time that the budget was actually created.</p>

<p style=3D'font-size: 12px;'>A notification is sent if the threshold is =
exceeded and the notification's last-sent date is greater than the base t=
ime for the notification group.  Notifications would have been missed whe=
n they were sent for last month's budget, because the times were copied t=
o the new budget.  But all such times should be for dates prior to Octobe=
r 1 when the budget was actually created, so resetting the base time to O=
ctober 1 should cause all notifications to be sent correctly.</p>
</div></div>
                                                </div>
            =

            =

                      </td>
        </tr>
          =

        =

    =

        =

  </table>

  <hr />
  <p style=3D"font-size: 12px;">You have received this email notification=
 because you have either subscribed to it, or are involved in an Unfuddle=
 project.  You are subscribed as [email protected].  If you wish to un=
subscribe from this notification, please click <a href=3D"http://unfuddle=
.com/api/support/optout?confirmation=3Df3ed566b59022e857cb1b772a75db5bc1d=
8bb358de37f9ef6b9ba57fbf74b376&amp;email=3Dmjd%40ziprecruiter.com&amp;ori=
gin=3Dnotification">here</a>.</p>
</body>
</html>=

--mimepart_525c6d936bb5e_4be83fee7cf3e940110077--