CiviCRM Community Forums (archive)

If  I sign up a (paid) member off-line using either the organisation and member type or a price set, the current date shows on the (default) receipt emails that I send at the time I record the payment.

If I renew a member off-line , the current date does not show on the receipt emails that I send at the time I record the payment.

If I resend the membership receipt email at a later time, the processing/payment date does not show up on either the  sign up or renewal emails.

The relevant code is:

      {if $receive_date}
        <tr>
         <td {$labelStyle}>
          {ts}Date Paid{/ts}
         </td>
         <td {$valueStyle}>
          {$receive_date|truncate:10:''|crmDate}
         </td>
        </tr>
       {/if}

I can't check properly on the demo site because it doesn't send emails,  but my default receipt template is identical to that on the demo site 

This same code is also in the off-line contribution receipts.  If I resend them at a later date rather than the membership receipts, the receive_date is shown.

However, our membership receipts contain extra customised information for each individual, so I really want to be able to resend them if required.

If I add the code:

{if $receiptType EQ 'membership renewal'}
     <tr>
         <td {$labelStyle}>
          {ts}Date Paid{/ts}
         </td>
         <td {$valueStyle}>
          {$smarty.now|date_format:'%e %B %Y'}
         </td>
      </tr>
{/if} 

I can get the correct date to show on the renewal receipts on the day I process them, but obviously if I resend the receipts at a later date the date of resending shows not the original date.

I have checked in the Civicrm_contribute table and the receive_date is recorded for all off-line sign ups and renewals.

Is anyone able to offer any suggestions?
 

Thanks for your reply Lobo.

I don't actually have access to the code, but could ask my implementers to look, however, having delved a little deeper in relation to other issues I think it is a lost cause.

As stated in my original post I can modify the Memberships - Signup and Renewal Receipts (off-line) template so that the correct date shows on renewal receipts sent on the day they are processed. (Perhaps this could be considered as an inclusion for the default template?)

So what I was really after was a way to get the receive date to show if I have to resend the membership receipt.

And this is the 'lost cause' part of it I think. (Although I have no experience with PHP and so could be talking nonsense.)

The only place the receive date is currently held is the contribution table. 

There is a one-to-many relationship between membership_id and contribution_ids so it may be difficult to get the last renewal date out of the contributions table if the starting point is the membership_Id which I suppose it is when resending a membership receipt.

For this and other reasons I think it would worthwhile adding a column called last_renewal_date to the membership table.  It's default would be null and it would be overwritten with the appropriate date whenever a membership was renewed.