<?php
$input = file_get_contents('php://input');
$array = json_decode($input, true);
$CampaignName = $array["CampaignName"];
$QueueID = $array["QueueID"];
$data = $array["Data"];

$uniq = uniqid();

$host = "localhost";
$user = "dialeruser";
$pass = "dialerpass";
$db = "dialerdb";

//CONECT
$link = mysql_connect($host,$user,$pass) or die(mysql_error());
		mysql_select_db($db, $link);

echo "connect v pohode \n";

//Zisti ci uz mame kampan s takym menom
	$sql=mysql_query("SELECT ID FROM  Campaign WHERE CampaignName='$CampaignName'", $link) or die(mysql_error());
		    if (mysql_num_rows($sql) == 0)
       			{
				$sql1="INSERT INTO Campaign(CampaignName,LastIdDial,Running,MaxCalls,Queue,Pause,TotalAgents) VALUES('$CampaignName','0','0','0','$queueID','0','0')";
				$res1=mysql_query($sql1,$link) or die(mysql_error());
			}else{
				echo "zaznam uz existuje\n";
				die();
			}
echo "Zisti kampan v pohode\n";
//Zisti id kampane
$sql2="SELECT ID FROM Campaign WHERE CampaignName='" .$CampaignName. "'";
		$res2=mysql_query($sql2,$link) or die("res2");
		$row = mysql_fetch_assoc($res2);
	        $myID = $row['ID'];

echo "Zisti id v pohode $myID\n";

//Vyvor tabulku pre kampan
$sqlc="CREATE TABLE `$CampaignName` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `IDcamp` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Date` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `NameCamp` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `LastName` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Tel` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Tries` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CallStatus` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SIP_CAUSE` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Deliver` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Uniqueid` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `VarSymbol` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Notes` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dstchannel` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `waitQueue` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `Active` int(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8";
mysql_query($sqlc,$link);
echo "Create v pohode\n";



//vloz zaznam do tabulky

 try{
  echo "Zacinam try\n";
foreach ($data as $item) {
    echo $item["LastName"];
    echo $item["TelNumber"];
    echo $item["VariableSymbol"];
}


$q = $link->prepare("INSERT INTO " .$CampaignName. " (IDcamp,NameCamp,LastName,VarSymbol,Tel,Tries,Uniqueid) VALUES (?, ?, ?,?,?,?,?)");


 foreach($data as $value){

echo "vojde";
   $q ->execute( '$myID','$CampaignName', array($value['LastName'], $value['TelNumber'], $value['VariableSymbol'] ),'0','$uniq');

 }

if ($link->query($q) === TRUE) {
    echo "New record created successfully";

} else {
    echo "Error: " . $stmt . "<br>" . $conn->error;
}



  }
    catch(PDOException $exception){
       return $exception->getMessage();
    }
echo "exception: ".$exception;


foreach ($data as $item) {
	echo $item["LastName"];
	echo $item["TelNumber"];
	echo $item["VariableSymbol"];
}
if ($CampaignName =! null){
	echo "hue";
	//die();
}

?>