CiviCRM Community Forums (archive)

Hey there,

I was going to bring this up tomorrow at our user group (along with direct debit) as two things that UK orgs can do to boost their profile and help the community.  LindseyM - how does that sound to you?

Michael

Sounds good Myles.  Michael - I've just realised that my reply earlier this week never got 'posted'.  I was asking about Alpha International's involvement in ongoing Gift Aid module maintenance as they partially funded the initial project.  Are they currently using it and willing to help maintain it?  Were they at the user group?  My knowledge of the module is non-existent as we're not planning to use it until later this year but I'm keen to be kept in the loop and to see it working.

Wonderful.  Thanks very much Parvez.  That's great news.  Are you planning to make it compatible with Drupal 7?

Hi All,

Actually, I managed to get Gift Aid module work on D7/Civi 4.0.x but now If I'm now trying to make the original CiviCRM gift aid module working CiviCRM 4.1

Parvez - Is there any work or code done yet?  My company and I may be can join to be working on the Gift Aid module?


Erawat

Hey Erawat

We're due to start work on this from the 27th of February. I'll touch base on the forum again with the work we are going to carry out. There are a few tweaks as well as getting the module working in terms of when a contribution should be gift aid eligible etc.

Has any of your work been contributed back to the core?

Thanks

Parvez

Hi Parvez

Are you going to make this happen on the code sprint?  I didn't contribute it back to the core as there is not thing change. I used Gift Aid for CiviCRM 3.3 and modified just an info for the module which was working well on CiviCRM 4.0.x/D7 but now the module is no longer working anymore. I was trying to fix it but has not yet success as I have to use my time and resource to do some other projects.

Hopefully, If they anything I can help to make this module happen. I will definitely do!!

Erawat

Gift Aid module has been fixed in CiviCRM 4.1/D7

Please see the updated on wiki page

http://wiki.civicrm.org/confluence/display/CRM/Gift+aid+installation,+configuration+and+usage

and the working code can be checked out at

http://svn.civicrm.org/tools/branches/v4.1/drupal/modules/civicrm_giftaid/

Thanks SRajesh for making this!!

Erawat

Hi Guys

Below is a patch to stop the gift aid batch failing if any of the data contains single quotes or any other un escaped data

Replace the following in civicrm_giftaid/GiftAid/Utils/Contribution.php


$query = "INSERT INTO civicrm_value_gift_aid_submission
(entity_id, eligible_for_gift_aid, name, address, post_code, amount, gift_aid_amount)
VALUES ({$contributionID}, 1, '{$displayName}', '{$fullFormatedAddress}',
       '{$address['postal_code']}', {$contribution['total_amount']}, {$giftAidAmount})
ON DUPLICATE KEY UPDATE
name      = '{$displayName}',
address   = '{$fullFormatedAddress}',
post_code = '{$address['postal_code']}',
amount    = {$contribution['total_amount']},
gift_aid_amount = {$giftAidAmount}
";
                CRM_Core_DAO::executeQuery( $query );

with

                $query = "INSERT INTO civicrm_value_gift_aid_submission
(entity_id, eligible_for_gift_aid, name, address, post_code, amount, gift_aid_amount)
VALUES (%0, 1, %1, %2, %3, %4, %5)
ON DUPLICATE KEY UPDATE
name      = %1,
address   = %2,
post_code = %3,
amount    = %4,
gift_aid_amount = %5
";
                CRM_Core_DAO::executeQuery( $query,
                  array(array($contributionID, 'Int'),
                        array($displayName, 'String'),
                        array($fullFormatedAddress, 'String'),
                        array($address['postal_code'], 'String'),
                        array($contribution['total_amount'], 'String'),
                        array($giftAidAmount, 'String'),
                        )
                );

Thanks

Parvez