Post by ElectraStore12 » Sat Jul 11, 2020 8:53 am

hello guys , i am using opencart 3.0.3.2 with journal 3 theme
journal 3 has a newsletter register , when customer added his email it is added in sql journal_newsletter
but when i go to mail form and send my newsletter it only send it for those who has registered ( from customer table ) it doesn't import emails from journal table
how can i fix this ?
i searched for a week before submitting this topic but couldn't find a solution ..


Posts

Joined
Sat Jul 11, 2020 8:50 am

Post by letxobnav » Sat Jul 11, 2020 5:58 pm

well, OC does this:

Code: Select all

					case 'newsletter':
						$customer_data = array(
							'filter_newsletter' => 1,
							'start'             => ($page - 1) * 10,
							'limit'             => 10
						);

						$email_total = $this->model_customer_customer->getTotalCustomers($customer_data);

						$results = $this->model_customer_customer->getCustomers($customer_data);

						foreach ($results as $result) {
							$emails[] = $result['email'];
						}
so you add another function which retrieves the emails from your journal newsletter table, then add those to the $emails array, do an array_unique to prevent duplicates and that's it.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by paulfeakins » Mon Jul 13, 2020 6:09 pm

ElectraStore12 wrote:
Sat Jul 11, 2020 8:53 am
i searched for a week before submitting this topic but couldn't find a solution ..
If you can't find a solution, you could pay a developer such as ourselves or post a job in the Commercial Support Forum.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by JNeuhoff » Mon Jul 13, 2020 7:03 pm

ElectraStore12 wrote:
Sat Jul 11, 2020 8:53 am
hello guys , i am using opencart 3.0.3.2 with journal 3 theme
journal 3 has a newsletter register , when customer added his email it is added in sql journal_newsletter
but when i go to mail form and send my newsletter it only send it for those who has registered ( from customer table ) it doesn't import emails from journal table
how can i fix this ?
i searched for a week before submitting this topic but couldn't find a solution ..
Is there any reason why you won't use the standard OpenCart newsletter functionality? Journal3 is a non-standard compliant commercial 3rd party theme extension (of poor quality I might add!), so you might want to get in touch with the Journal-support on this, or post it on the commercial support section of the OpenCart forum.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 7 guests