}); $app->put('/feed/config', function () use($app, $response, $utils) { $code = 200; $responseText = 'ok'; $requestData = json_decode($app->request->getRawBody(), true); $data = array(); if (empty($requestData)) { $code = 400; $responseText = 'Bad Request'; $data['result'] = 'Data Error'; } else { try { //delete enlisting venue aliases $deleteVenueAliasSQL = "DELETE FROM venueAlias WHERE feed_id = :feed_id: AND venue_id = :venue_id:"; $insertVenueAliasSQL = "INSERT INTO venueAlias (feed_id,venue_id,name) VALUES(:feed_id:,:venue_id:,:venue_name:)"; $db = $app->getService('db'); foreach ($requestData as $row) { $aliases = $utils->index_set($row, 'aliases'); $venue_id = (int) $utils->index_set($row, 'venue_id'); $feed_id = (int) $utils->index_set($row, 'feed_id'); $priority = (int) $utils->index_set($row, 'priority'); if (empty($venue_id) || empty($feed_id)) { throw new Exception('Data Error'); } $existingVenueAlias = venueAlias::find(array('feed_id' => $feed_id, 'venue_id' => $venue_id)); if (count($existingVenueAlias) == 1) { $existingVenueAlias->delete(); } foreach ($aliases as $alias) { $app->modelsManager->executeQuery($insertVenueAliasSQL, array('feed_id' => $feed_id, 'venue_id' => $venue_id, 'venue_name' => trim($alias))); }