/**
* Get data used for inserting into the DB.
*
* this cooks all data to whats needed by providers (all of them) later...
*
* for now the event end_ts is 00:00. some algorithms will be
* needed for the following todo
*
* @todo do something about events that start between 23:00 and 6:00
*/
public function getInsertData(Zend_Feed_EntryRss $item)
{
/*
<item>
<title>16.02.2007: Landfall & Pornolé (Kraftfeld)</title>
<link>http://tickets.petzi.ch/detail_evenement.php?new_lang=en&id_evenement=5346</link>
<description></description>
<author>Info@kraftfeld.ch</author>
<category>Alternative</category>
<pubDate>Fri, 12 Jan 2007 16:44:06 +0100</pubDate>
<guid>http://tickets.petzi.ch/detail_evenement.php?new_lang=en&id_evenement=5346</guid>
<petzi:eventTitle>Landfall & Pornolé</petzi:eventTitle>
<petzi:eventDate>2007-02-16</petzi:eventDate>
<petzi:eventType>Alternative</petzi:eventType>
<petzi:eventTime>22:00:00</petzi:eventTime>
<petzi:eventDoors>21:00:00</petzi:eventDoors>
<petzi:eventPrice>12</petzi:eventPrice>
<petzi:eventPriceType>0</petzi:eventPriceType>
<petzi:eventHasAdvanceSale>0</petzi:eventHasAdvanceSale>
<petzi:eventTicketsAvailable>0</petzi:eventTicketsAvailable>
<petzi:eventCanceled>0</petzi:eventCanceled>
<petzi:clubName>Kraftfeld</petzi:clubName>
<petzi:clubStreet>Lagerplatz 18</petzi:clubStreet>
<petzi:clubPostalCode>8400</petzi:clubPostalCode>
<petzi:clubCity>Winterthur</petzi:clubCity>
<petzi:clubCanton>ZH</petzi:clubCanton>
<petzi:clubPhone>052.202.02.04</petzi:clubPhone>
<petzi:clubWebsite>www.kraftfeld.ch</petzi:clubWebsite>
<petzi:clubMail>Info@kraftfeld.ch</petzi:clubMail>
</item>
*/
if ($item->eventDoors() == '00:00:00') {
$start_ts = $item->eventDate() . 'T' . $item->eventTime() . '+01:00';
} else {
$start_ts = $item->eventDate() . 'T' . $item->eventDoors() . '+01:00';
}
$end_ts = $item->eventDate() . 'T24:00:00+01:00';
$desc_text = '' . htmlspecialchars($item->eventTitle()) . "\n" . 'Genre: ' . htmlspecialchars($item->eventType()) . "\n" . 'Doors: ' . $item->eventDoors() . "\n" . 'Venue: ' . htmlspecialchars($item->clubName()) . ' (' . htmlspecialchars($item->clubWebsite) . ')' . "\n\n" . 'Tickets or more Infos: ' . htmlspecialchars($item->link()) . "\n\n";
$desc_text .= 'Data source: http://www.petzi.ch ' . "\n";
$desc_text .= 'commercial use is prohibited - see http://tickets.petzi.ch/rss.php for license';
$desc_text_nolinks = htmlspecialchars($item->eventTitle()) . "\n" . 'Genre: ' . htmlspecialchars($item->eventType()) . "\n" . 'Doors: ' . $item->eventDoors() . "\n" . 'Venue: ' . htmlspecialchars($item->clubName()) . "\n\n";
$desc_text_nolinks .= 'Data source: petzi.ch ' . "\n";
$desc_text_nolinks .= 'commercial use is prohibited - see tickets.petzi.ch/rss.php for license';
$desc_html = '<p><strong>' . htmlspecialchars($item->eventTitle()) . "</strong>\n" . '<p>Data source: <a href="http://www.petzi.ch"><img src="http://petzi.ch/images/logo_petzi.jpg"/></a>' . '<p>commercial use is prohibited - <a href="http://tickets.petzi.ch/rss.php">data license</a>';
$desc_wiki = '';
$cost_text = $this->getCostText($item);
if ($item->eventPriceType() == 1) {
$free = 1;
} else {
$free = 0;
}
$venue_name = $item->clubName();
$city_name = $item->clubPostalCode() . ' ' . $item->clubCity() . ', CH';
$location = $venue_name . ', ' . $city_name;
$venue_link = 'http://' . $item->clubWebsite();
$style_tags = $item->category();
$r = array('start_ts' => $start_ts, 'end_ts' => $end_ts, 'event_name' => htmlspecialchars($item->eventTitle()), 'desc_text' => $desc_text, 'desc_text_nolinks' => $desc_text_nolinks, 'desc_html' => $desc_html, 'desc_wiki' => $desc_wiki, 'cost_text' => $cost_text, 'free' => $free, 'venue_name' => $venue_name, 'venue_link' => $venue_link, 'city_name' => $city_name, 'city_postal' => $city_postal, 'location' => $location, 'link' => $item->link(), 'style_tags' => $style_tags, 'raw_data' => $item->saveXML());
return $r;
}
public function getInsertData(Zend_Feed_EntryRss $item)
{
$start_ts = $item->eventDate() . 'T' . $item->eventDoors() . '+01:00';
$end_ts = $item->eventDate() . 'T24:00:00+01:00';
/*
<title>12.01.2007: Tight Finks & Fuckadies (OX Kultur)</title>
<link>http://tickets.petzi.ch/detail_evenement.php?new_lang=en&id_evenement=5131</link>
<description />
<author>info@oxx.ch</author>
<category>Garage, Punk, Rock</category>
<pubDate>Wed, 13 Dec 2006 13:00:04 +0100</pubDate>
<guid>http://tickets.petzi.ch/detail_evenement.php?new_lang=en&id_evenement=5131</guid>
<petzi:eventTitle>Tight Finks & Fuckadies</petzi:eventTitle>
<petzi:eventDate>2007-01-12</petzi:eventDate>
<petzi:eventType>Garage, Punk, Rock</petzi:eventType>
<petzi:eventTime>22:00:00</petzi:eventTime>
<petzi:eventDoors>21:00:00</petzi:eventDoors>
<petzi:eventPrice>16</petzi:eventPrice>
<petzi:eventHasAdvanceSale>1</petzi:eventHasAdvanceSale>
<petzi:clubName>OX Kultur</petzi:clubName>
<petzi:clubStreet>Ochsengasse</petzi:clubStreet>
<petzi:clubPostalCode>4800</petzi:clubPostalCode>
<petzi:clubCity>Zofingen</petzi:clubCity>
<petzi:clubCanton>AG</petzi:clubCanton>
<petzi:clubPhone>062 751 93 74</petzi:clubPhone>
<petzi:clubWebsite>www.oxx.ch/</petzi:clubWebsite>
<petzi:clubMail>info@oxx.ch</petzi:clubMail>
*/
$sDesc = '' . htmlspecialchars($item->eventTitle()) . "\n" . 'Genre: ' . htmlspecialchars($item->eventType()) . "\n" . 'Doors: ' . $item->eventDoors() . "\n" . 'Venue: ' . htmlspecialchars($item->clubName()) . ' (' . htmlspecialchars($item->clubWebsite) . ')' . "\n\n" . 'Tickets or more Infos: ' . htmlspecialchars($item->link()) . "\n\n";
/**
$lDesc = $sDesc
. $item->clubStreet()."\n\n"
. $item->clubPostalCode().' '.$item->clubCity()."\n\n";
if ($item->eventHasAdvanceSale() == 1) {
$petzilink = 'buy tickets: '.$item->link();
} else {
$petzilink = 'more infos: $item->link()';
}
*/
$petzilink .= 'Data source: http://www.petzi.ch ' . "\n";
$petzilink .= 'commercial use is prohibited - see http://tickets.petzi.ch/rss.php for license';
$lDesc .= $petzilink;
$sDesc .= $petzilink;
$location = $item->clubName() . ', ' . $item->clubCanton() . '-' . $item->clubPostalCode() . ' ' . $item->clubCity() . ', CH';
return array('start_ts' => $start_ts, 'end_ts' => $end_ts, 'event_name' => htmlspecialchars($item->eventTitle()), 'shortdesc' => $sDesc, 'longdesc' => $lDesc, 'location' => $location, 'link' => $item->link());
}
