foreach ($liste['data'] as $b) {
$arr['status'] = $b['status'];
foreach ($b['merges'] as $x => $x_value) {
switch ($x) {
case 'EMAIL':
$arr["email"] = $x_value;
break;
case 'FNAME':
$arr["ime"] = $x_value;
break;
case 'LNAME':
$arr["prezime"] = $x_value;
break;
}
}
$a = spremi($arr, $conn);
array_push($array, array('id' => $a, 'status' => $b['status']));
}
foreach ($array as $ar => $a) {
napuniKotaktiListe($arr, $conn, $a['id'], $a['status']);
}
echo 'Uspjesno sinkronizirani podaci!';
} else {
echo 'Neispravni JSON podatci!';
}
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
function spremi($arr, $con)
{
//prvo provjerava da li postoji kontakt ako da onda update ako ne onda insert
include_once 'class/connection.php';
include_once 'class/MailChimp.php';
// ovo je skripta koja dobiva JSON i sinkronizira bazu s MailChimpom
$data = file_get_contents('php://input');
$arr = json_decode($data, true);
try {
if ($arr['firma_idfirma'] && $arr['fi_mailChimpAPIkey']) {
//instanciranje mailchimp objekta
$MailChimp = new MailChimp($arr['fi_mailChimpAPIkey']);
//instanciranje connection objekta
$conn = new Connection();
//dohvati liste iz mailchimpa i spremi u bazu
$liste = $MailChimp->call('lists/list');
foreach ($liste['data'] as $i => $c) {
$c['firmaID'] = $arr['firma_idfirma'];
spremi($c, $conn);
}
echo 'Uspjesno povlacenje listi s MailChimp racuna!';
} else {
echo 'Dogodila se greska!!';
}
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
function spremi($item, $con)
{
$c = $con->spajanje();
$provjera = "Select crm.mailchimpliste.* from mailchimpliste where IDListe ='" . $item['id'] . "' and firma_idfirma ='" . $item['firmaID'] . "'";
$res = $con->upit($c, $provjera);
if (!$res) {
$sql = "INSERT INTO crm.mailchimpliste (Listname,IDListe,firma_idfirma) VALUES ('" . $item['name'] . "','" . $item['id'] . "'," . $item['firmaID'] . ")";
