Simple php script

Færdiggjort Opslået 2 år siden Betalt ved levering
Færdiggjort 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).

PHP MySQL Software Arkitektur HTML JavaScript

Projekt ID: #30545438

Om projektet

4 bud Remote projekt Aktiv 2 år siden

Tildelt til:

abubakar12345678

I will make this script surely. Give me chance. I will show you good result. Thanks.................

$40 USD på 1 dag
(72 bedømmelser)
5.5

4 freelancere byder i gennemsnit $38 timen for dette job

freelancersandh1

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....

$20 USD in 7 dage
(14 bedømmelser)
4.6
ivangon

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 Flere

$40 USD på 1 dag
(0 bedømmelser)
0.0