JA Job Board Component 8,554 posts

[environc Friend environcJoin date: December 2012Posts: 173Downloads:0Uploads:33 Thanks: 30 Thanked: 2 times in 1 posts]

#183858

Hi,

When employer clicks “Buy Subscription” on employer menu and selects subscription then proceeds to checkout, employer can no longer cancel the checkout process. The Employer menu doesn’t show anything except Payment To Complete Your Register. When you click on this link, you go back to the checkout page. So the employers is basically locked out of the account. How can employers cancel a subscription if the no longer want to continue with it?

Regards
.

[HeR0 Friend HeR0Join date: August 2011Posts: 3626Downloads:0Uploads:61 Thanks: 33 Thanked: 588 times in 549 posts]

#479795

Hi Environc,

Please open file modules/mod_jajobboard_menu/helper.php and find query string

$query = "SELECT a.id AS transactionid, a.completed, b.id as subscriptionid, b.duration, b.units, a.created_date, a.processed_date, a.user_id
FROM #__ja_transactions a
INNER JOIN #__ja_subscriptions b ON a.product_id = b.id
WHERE a.user_id = ".$user->id."
AND a.product_type = 'S'
AND ( ISNULL(a.reason) OR a.reason <> 'Reverse' )
ORDER BY a.id DESC LIMIT 1";
replace it to

$query = "SELECT a.id AS transactionid, a.completed, b.id as subscriptionid, b.duration, b.units, a.created_date, a.processed_date, a.user_id
FROM #__ja_transactions a
INNER JOIN #__ja_subscriptions b ON a.product_id = b.id
WHERE a.user_id = ".$user->id."
AND a.product_type = 'S'
AND a.complete = 1
AND ( ISNULL(a.reason) OR a.reason <> 'Reverse' )
ORDER BY a.id DESC LIMIT 1";

Hope this helps.

Regards

[Author]

Posts