Simple php script
$10-30 USD
Betalt ved levering
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).
Projekt ID: #30545438
Om projektet
Tildelt til:
I will make this script surely. Give me chance. I will show you good result. Thanks.................
4 freelancere byder i gennemsnit $38 timen for dette job
Hi i have read your project detail and i can do this task using php message me and talk to me about budget and time....
