getOne('SELECT * FROM vendor WHERE id = '.$_GET['fid']); } else { $data = $_SESSION['db']->getOne('SELECT * FROM customer WHERE id = '.$_GET['fid']); }; $fa['RECV_NAME1'] = $data['name']; $fa['RECV_NAME2'] = $data['']; $fa['RECV_STREET'] = $data['street']; $fa['RECV_HOUSENUMBER'] = ''; $fa['RECV_PLZ'] = $data['zipcode']; $fa['RECV_CITY'] = $data['city']; $fa['RECV_COUNTRY'] = strtoupper( substr( $data['country'],0,3 ) ); }; $sql = "SELECT * FROM crmdefaults WHERE grp = 'dhl'"; $rs = $_SESSION['db']->getAll($sql); $produkte = array(); foreach ( $rs as $row ) { if ( !preg_match( '/SEND/', $row['key'] ) ) { $produkte[$row['key']] = $row['val']; } else { $send[$row['key']] = $row['val']; }; }; $sender = $send['SEND_NAME1'].','.$send['SEND_NAME2'].','.$send['SEND_STREET'].','.$send['SEND_HOUSENUMBER'].','.$send['SEND_PLZ'].','.$send['SEND_CITY'].','.$send['SEND_COUNTRY']; if ( isset( $_POST['add'] ) ) { unset( $_POST['add'] ) ; unset( $_POST['popup'] ) ; mb_internal_encoding($_SESSION["charset"]); $_POST['RECV_NAME1'] = mb_convert_encoding($_POST['RECV_NAME1'],'Windows-1252'); $_POST['RECV_STREET'] = mb_convert_encoding($_POST['RECV_STREET'],'Windows-1252'); $_POST['RECV_CITY'] = mb_convert_encoding($_POST['RECV_CITY'],'Windows-1252'); $_SESSION['DHL'][] = $_POST; } else if ( isset( $_POST['do'] ) ) { $header = 'SEND_NAME1,SEND_NAME2,SEND_STREET,SEND_HOUSENUMBER,SEND_PLZ,SEND_CITY,SEND_COUNTRY,RECV_NAME1,RECV_NAME2,RECV_STREET,RECV_HOUSENUMBER,RECV_PLZ,RECV_CITY,RECV_COUNTRY,PRODUCT,COUPON'; $spacer = array('','','','','','',''); if ( isset($_SESSION['DHL']) ) { $f = fopen('tmp/dhl.csv','w'); fputs ( $f, $header."\n"); $first = true; foreach ($_SESSION['DHL'] as $address) { if ( $first ) { fputcsv ( $f,array_merge($send,$address),',','"' ); $first = false; } else { fputcsv ( $f,array_merge($spacer,$address),',','"' ); }; }; fclose($f); $link = 'download'; } } ?> DHL

DHL Adressexport

'; $cnt = 0; if ( isset($_SESSION['DHL']) ) foreach ($_SESSION['DHL'] as $address) { echo implode(',',$address)." [entfernen]
"; $cnt ++; } ?>
Empfänger 1' size='20' maxlength='50'>
Empfänger 2' size='20' maxlength='50'>
Strasse ' size='20' maxlength='50'>
Hausnr. ' size='20' maxlength='11'> wenn nicht in Strasse
Plz ' size='20' maxlength='11'>
Ort ' size='20' maxlength='38'>
Land ' size='20' maxlength='50'> 3 Buchstaben, siehe: Wikipedia Spalte ALPHA-3
Produkt
Cupon
   
close]'; }; ?>