We need a small script which searches in the database to find out how many posts there if for the current day.
Search in the database pallel29_c7nordiccall_dk tabel queue_calls - It must search for the number of rows where the column queue_name2 contains CBD Nordic and the column queue_name contains 206611.
Scriptet the script must count the number of rows and multiply it by 8, and then send the information in an e-mail.
Subject: Dagens statistik for CBD Nordic
Mail:
Hej
Vi har i dag håndteret [number of rows] opkald for jer, som sammenlagt har kostet [number of rows * 8] kroner.
Med venlig hilsen
NordicCall
The information must be send to XX and BCC XX
The above must also be done for the rows where queue_name2 contains Xshopping and queue_name contains 271171.
Scriptet the script must count the number of rows and multiply it by 8, and then send the information in an e-mail.
Subject: Dagens statistik for Xshopping
E-mail:
Hej
Vi har i dag håndteret [number of rows] opkald for jer, som sammenlagt har kostet [number of rows * 8] kroner.
Med venlig hilsen
NordicCall
The information must be send to XX and BCC XX
This must also be done for the following rows.
1. queue_name2 contains Nettoparts DK and queue_name contains 206111
2. queue_name2 contains Nettoparts SE and queue_name contains 47924721
3. queue_name2 contains Nettoparts NO and queue_name contains 46418331
Scriptet the script must count the number of rows and multiply it by 8, and then send the information in an e-mail.
Scriptet the script must count the number of rows and multiply it by 8, and then send the information in an e-mail.
Subject: Dagens statistik for Nettoparts
e-mail:
Hej
Vi har i dag håndteret
[number of rows for 1] opkald for jer i Danmark (Antallet er fra Nettoparts DK)
[number of rows for 2] opkald for jer i Sverige (Antallet er fra Nettoparts SE)
[number of rows for 3] opkald for jer i Norge (Antallet er fra Nettoparts NO)
Med venlig hilsen
The information must be send to XX and BCC XX
For ALL of the above it is important that NO mail is send, if the number one day is zero (for the last one, all of the number must be zero for no mail to be sent).
Hi, Palle
How are you?
I am very confident to create a script to get the number of posts from your database.
I have deep knowledge of PHP+MySQL for 5 years.
Please contact me to discuss more.
Hope to be working with you.
Regards.