37 function writeCsvFile(&$array,$headline = TRUE, $delimiter =
"," ,$windowsLinebreak = TRUE) {
39 if (count($array) == 0) {
42 $df = fopen(
"php://output",
'w');
45 $keys = array_keys(reset($array));
46 $keys = array_map(
function($in) {
return iconv(
'utf-8',
'iso-8859-1',$in);},$keys);
47 fputcsv($df, $keys,$delimiter);
48 if($windowsLinebreak) {
52 foreach ($array as $row) {
56 return iconv(
'utf-8',
'iso-8859-1',
57 htmlspecialchars_decode($in,ENT_QUOTES));},$row);
58 fputcsv($df, $toWrite, $delimiter);
59 if(count($toWrite)==1) {
62 if($windowsLinebreak) {
83 if($sponsorIds===NULL) {
85 $stmt = $mysqli->prepare(
"SELECT email
86 FROM ". $db[
'contact_person'].
" WHERE newsletter=1" );
89 $stmt->bind_result($email);
91 while ($stmt->fetch()) {
93 $row[] = array(($email));
98 $sponsors = $sponsorIds;
99 if(!$sponsors===FALSE) {
100 $mailAddresses = array();
101 foreach($sponsors as $sponsorId) {
103 foreach ($contactPersons as $contactPerson) {
104 if($contactPerson[
'newsletter']==1) {
105 $mailAddresses[] = array(($contactPerson[
'email']));
109 return $mailAddresses;
111 exitWithErrorTemplate(array(
"Es ist ein Fehler aufgetreten. Zugriff auf das Ergebnis nicht möglich."));
128 if($sponsorIds===NULL) {
130 $stmt = $mysqli->prepare(
"SELECT email
131 FROM " . $db[
'contact_person']);
133 $stmt->bind_result($email);
135 while ($stmt->fetch()) {
140 $row[] = array(($email));
145 $sponsors = $sponsorIds;
146 if(!$sponsors===FALSE) {
147 $mailAddresses = array();
148 foreach($sponsors as $sponsorId) {
150 foreach ($contactPersons as $contactPerson) {
151 $mailAddresses[] = array(($contactPerson[
'email']));
154 return $mailAddresses;
156 exitWithErrorTemplate(array(
"Es ist ein Fehler aufgetreten. Zugriff auf das Ergebnis nicht möglich."));
173 if ($sponsorIdList == NULL) {
175 $stmt = $mysqli->prepare(
176 "SELECT name, sponsor_name, position, email, telephone_number, mobile_phone_number
177 FROM " . $db[
'sponsor'] .
"," . $db[
'contact_person'] .
"
178 WHERE " . $db[
'sponsor'] .
".sponsor_id = " . $db[
'contact_person'] .
".sponsor_id" .
" AND newsletter = 1");
180 $stmt->bind_result($name, $sponsor_name, $position, $email, $telephone_number, $mobile_phone_number);
182 while ($stmt->fetch()) {
185 "Anzeigename" => $name,
186 "Organisation" => $sponsor_name,
187 "Position" => $position,
189 "Telefon" => $telephone_number,
"Mobil" => $mobile_phone_number);
194 $sponsors = $sponsorIdList;
195 if(!$sponsors===FALSE) {
196 $mailAddressesNewsletter = array();
198 foreach($sponsors as $sponsorId) {
202 foreach ($contactPersons as $contactPerson) {
203 if($contactPerson[
'newsletter']==1) {
204 $mailAddressesNewsletter[] = array(
205 "Anzeigename"=>$contactPerson[
'name'],
206 "Organisation"=>$sponsor[
'name'],
207 "Position"=>$contactPerson[
'position'],
208 "E-Mail"=>$contactPerson[
'email'],
209 "Telefon"=>$contactPerson[
'phone'],
"Mobil"=>$contactPerson[
'mobile']
214 return $mailAddressesNewsletter;
216 exitWithErrorTemplate(array(
"Es ist ein Fehler aufgetreten. Zugriff auf das Ergebnis nicht möglich."));
233 if($sponsorIds===NULL) {
235 $stmt = $mysqli->prepare(
236 "SELECT name, sponsor_name, position, email, telephone_number, mobile_phone_number
237 FROM " . $db[
'sponsor'] .
"," . $db[
'contact_person'] .
"
238 WHERE " . $db[
'sponsor'] .
".sponsor_id = " . $db[
'contact_person'] .
".sponsor_id");
240 $stmt->bind_result($name, $sponsor_name, $position, $email, $telephone_number, $mobile_phone_number);
242 while ($stmt->fetch()) {
245 "Anzeigename" => $name,
246 "Organisation" => $sponsor_name,
247 "Position" => $position,
249 "Telefon" => $telephone_number,
"Mobil" => $mobile_phone_number);
254 $sponsors = $sponsorIds;
255 if(!$sponsors===FALSE) {
256 $mailAddresses = array();
257 foreach($sponsors as $sponsorId) {
260 foreach ($contactPersons as $contactPerson) {
261 $mailAddresses[] = array(
262 "Anzeigename"=>$contactPerson[
'name'],
263 "Organisation"=>$sponsor[
'name'],
264 "Position"=>$contactPerson[
'position'],
265 "E-Mail"=>$contactPerson[
'email'],
266 "Telefon"=>$contactPerson[
'phone'],
"Mobil"=>$contactPerson[
'mobile']
270 return $mailAddresses;
272 exitWithErrorTemplate(array(
"Es ist ein Fehler aufgetreten. Zugriff auf das Ergebnis nicht möglich."));
290 if($sponsorIds===NULL) {
292 $stmt = $mysqli->prepare(
"SELECT name, sponsor_name, street, house_number, zip_code, town, country
293 FROM ". $db[
'sponsor'].
",". $db[
'contact_person'].
" WHERE ". $db[
'sponsor'].
".sponsor_id = ".
294 $db[
'contact_person'].
".sponsor_id");
297 $stmt->bind_result($contact_person_name, $sponsor_name, $street, $house_number, $zip_code, $town, $country);
299 while ($stmt->fetch()) {
302 "Sponsorname"=>$sponsor_name,
303 "Name"=>$contact_person_name,
305 "Hausnummer"=>$house_number,
313 $addresses = array();
314 $sponsors = $sponsorIds;
315 if(!$sponsors===FALSE) {
316 foreach($sponsors as $sponsorId) {
318 $addresses[] = array(
319 "Sponsorname"=>$sponsor[
'name'],
320 "Straße"=>$sponsor[
'street'],
321 "Hausnummer"=>$sponsor[
'houseNumber'],
322 "PLZ"=>$sponsor[
'zipCode'],
323 "Stadt"=>$sponsor[
'town'],
324 "Land"=>$sponsor[
'country']);
328 exitWithErrorTemplate(array(
"Es ist ein Fehler aufgetreten. Zugriff auf das Ergebnis nicht möglich."));
340 header(
"Pragma: private");
341 header(
"Expires: 0");
342 header(
"Cache-Control: must-revalidate, post-check=0, pre- check=0");
343 header(
"Content-Type: application/force-download");
344 header(
"Content-Type: application/octet-stream");
345 header(
"Content-Type: application/download");
346 header(
"Content-Disposition: attachment;filename=$filename");
347 header(
"Content-Transfer-Encoding: binary");