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'] . ")";