protected function execute($arguments = array(), $options = array())
{
// initialize the database connection
$databaseManager = new sfDatabaseManager($this->configuration);
$connection = $databaseManager->getDatabase($options['connection'])->getConnection();
//$request = new FetchEventivalXMLWebRequest(array('url' =>'http://www.eventival.eu/poff/14/et/ws/2ae44138cee5011f9cd2d474f11bfbd9/films/sections.xml'));
//$xmlObj = $request->send();
//$xmlObj->requestType = 'Sections';
//$xmlObj->mapObjects();
//$request = new FetchEventivalXMLWebRequest(array('url' =>'http://www.eventival.eu/poff/14/et/ws/2ae44138cee5011f9cd2d474f11bfbd9/films/cinemas.xml'));
//$xmlObj = $request->send();
//$xmlObj->requestType = 'Cinema';
//$xmlObj->mapObjects();
$request = new FetchEventivalXMLWebRequest(array('url' => 'http://www.eventival.eu/poff/14/en/ws/2ae44138cee5011f9cd2d474f11bfbd9/films/categories/10/publications-locked.xml'));
$xmlObj = $request->send();
$xmlObj->requestType = 'Films';
$xmlObj->mapObjects();
$request = new FetchEventivalXMLWebRequest(array('url' => 'http://www.eventival.eu/poff/14/en/ws/2ae44138cee5011f9cd2d474f11bfbd9/films/categories/9/publications-locked.xml'));
$xmlObj = $request->send();
$xmlObj->requestType = 'Films';
$xmlObj->mapObjects();
//$request = new FetchEventivalXMLWebRequest(array('url' =>'http://www.eventival.eu/poff/14/et/ws/2ae44138cee5011f9cd2d474f11bfbd9/films/screenings.xml'));
//$xmlObj = $request->send();
//$xmlObj->requestType = 'Screenings';
//$xmlObj->mapObjects();
}
private function mapSections()
{
$url = 'http://www.eventival.eu/poff/14/et/ws/2ae44138cee5011f9cd2d474f11bfbd9/films/sections.xml';
$request = new FetchEventivalXMLWebRequest(array('url' => $url));
$groupArray = $request->send()->getResponseArray();
$url = 'http://www.eventival.eu/poff/14/en/ws/2ae44138cee5011f9cd2d474f11bfbd9/films/sections.xml';
$request = new FetchEventivalXMLWebRequest(array('url' => $url));
$groupArray2 = $request->send()->getResponseArray();
$group2 = $groupArray2['section'];
$i = 0;
foreach ($groupArray['section'] as $group) {
$product_group = '';
$product_group2 = '';
$product_group['title'] = $group['name'];
$product_group['level'] = 1;
$product_group['lft'] = 2;
$product_group['eventival_id'] = $group['id'];
$product_group2 = $group2[$i];
$product_group['Translation'] = array('et' => array('name' => is_array($group['name']) ? '' : $group['name'], 'description' => is_array($group['description']) ? '' : $group['description']), 'en' => array('name' => is_array($product_group2['name']) ? '' : $product_group2['name'], 'description' => is_array($product_group2['description']) ? '' : $product_group2['description']), 'ru' => array('name' => is_array($product_group2['name']) ? '' : $product_group2['name'], 'description' => is_array($product_group2['description']) ? '' : $product_group2['description']));
$action = $this->checkData($product_group['eventival_id']);
if ($action == 'create') {
$id = $this->createData('ProductGroup', $product_group);
} else {
$this->updateData('ProductGroup', $product_group, $action);
$product_group['Translation'] = array('en' => array('name' => is_array($product_group2['name']) ? '' : $product_group2['name'], 'description' => is_array($product_group2['description']) ? '' : $product_group2['description']));
$this->updateData('ProductGroup', $product_group, $action);
$id = $action;
}
$i++;
}
return false;
}
