<?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();


?>