horsensspejder-web/ajax/sendsms.php

<?php

require_once( "../inc/mysql.php" );
require_once( "ajaxcommon.php" );

require("../inc/sendmessages.php");


$enheder = $_GET["enheder"];
$individer = $_GET["individer"];
$besked = $_GET["besked"];
$samletpris = $_GET["samletpris"];

$personer = findPersoner($enheder, $individer);

$antal = count($personer); 

$besked = escape_string($besked);

$sql = "INSERT INTO smsjob (enheder,individer,besked,antalmodtagere,samletpris, tidspunkt) VALUES ('$enheder','$individer','$besked', $antal, $samletpris, now());";
squery($sql);

$jobid = insert_id();


$count = 0;
$uids = "'" . implode("','", $personer) . "'";
$sql = "SELECT * FROM stamdata WHERE id IN ($uids) ORDER BY fornavn,efternavn";
$res = query($sql);
foreach($res as $row) {

        $to = $row->mobil;

        if ($to == "") //ingen grund til at oprette en row i outbox uden mobil nr
                continue;

        $cc = substr($to,0,2);

        if ( $cc != "45") {
                $to = "45" . $to;
        }

        $sql = "insert into outbox(receiver,message,status,statustime) values('$to','$besked','NEW', now() )";
        squery($sql);
        
        $count++;
}

sendmessages();


?>
1	<?php
2
3	require_once( "../inc/mysql.php" );
4	require_once( "ajaxcommon.php" );
5
6	require("../inc/sendmessages.php");
7
8
9
10
11	$enheder = $_GET["enheder"];
12	$individer = $_GET["individer"];
13	$besked = $_GET["besked"];
14	$samletpris = $_GET["samletpris"];
15
16	$personer = findPersoner($enheder, $individer);
17
18	$antal = count($personer);
19
20	$besked = escape_string($besked);
21
22	$sql = "INSERT INTO smsjob (enheder,individer,besked,antalmodtagere,samletpris, tidspunkt) VALUES ('$enheder','$individer','$besked', $antal, $samletpris, now());";
23	squery($sql);
24
25	$jobid = insert_id();
26
27
28	$count = 0;
29	$uids = "'" . implode("','", $personer) . "'";
30	$sql = "SELECT * FROM stamdata WHERE id IN ($uids) ORDER BY fornavn,efternavn";
31	$res = query($sql);
32	foreach($res as $row) {
33
34	$to = $row->mobil;
35
36	if ($to == "") //ingen grund til at oprette en row i outbox uden mobil nr
37	continue;
38
39	$cc = substr($to,0,2);
40
41	if ( $cc != "45") {
42	$to = "45" . $to;
43	}
44
45	$sql = "insert into outbox(receiver,message,status,statustime) values('$to','$besked','NEW', now() )";
46	squery($sql);
47
48	$count++;
49	}
50
51	sendmessages();
52
53
54	?>