$r[0]['email'] = 'Email';
$r[0]['first_name'] = 'First Name';
$r[0]['last_name'] = 'Last Name';
foreach ($reports as $rep) {
$x = array();
$x['email'] = $rep['customers_email_address'];
$x['first_name'] = $rep['customers_firstname'];
$x['last_name'] = $rep['customers_lastname'];
$r[] = $x;
}
$file_name = 'jng-business-partner-' . date('Ymd-Hi') . '.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
echo tep_create_csv($r);
exit;
} else {
//NORMAL PAGE
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$bp_total_query = tep_db_query("SELECT count(c.customers_id) AS total FROM customers c" . $filter_query);
$bp_total = tep_db_fetch_array($bp_total_query);
//PAGING QUERY & LINKS
$offset = ($page - 1) * ROWPERPAGE;
$page_query = " LIMIT " . ROWPERPAGE . " OFFSET {$offset}";
$pagelink = tep_paging($bp_total['total'], $page, '?open=business-partner&page=');
$bp_query = "SELECT c.customers_id, c.customers_email_address, c.customers_status, c.customers_firstname, c.customers_lastname";
$bp_query .= ", bp.*";
$dti_ref_filter = $class_dti->drawReferrerCombo('dti_referrers', $dti_referrers, 'No Referrer Filter');
$dti_stat_filter = $class_dti->drawStatusCombo('dti_com_status', $dti_com_status, 'No Status Filter');
$begin = strtotime($begin_text);
$end = strtotime($end_text);
$commissions = $class_dti->retrieveFilteredCommissions($dti_referrers, $begin, $end, $status);
$cancels = $class_dti->retrieveFilteredCommissionsCancel($dti_referrers, $begin, $end, $status);
if (isset($_GET['format']) && $_GET['format'] == 'csv') {
$csv_commissions = $class_dti->drawCommissionCSV($commissions);
$csv_cancels = $class_dti->drawCommissionCancelCSV($cancels);
$csv_report = array_merge($csv_commissions, array(array()), $csv_cancels);
$file_name = 'partner-commissions-' . date('Ymd', $begin) . '-' . date('Ymd', $end) . '.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
echo tep_create_csv($csv_report);
exit;
} else {
$content = '';
$content .= '<div class="dti_filter float-box ui-corner-all" style="margin-right:20px;">';
$content .= '<form name="com_filter" action="?open=dti-commissions" method="post">';
$content .= '<table border="0" cellpadding="0" cellspacing="0" border="1">';
$content .= '<tr>';
$content .= '<th rowspan="2" class="title">Filter</td>';
$content .= '<th>From</th><th>To</th><th>Referrer</th><th>Status</th>';
$content .= '<th rowspan="2" id="apply_filter"> </th>';
$content .= '</tr>';
$content .= '<tr>';
$content .= '<td><input type="text" class="date_picker" name="begin_text" value="' . $begin_text . '" /></td>';
$content .= '<td><input type="text" class="date_picker" name="end_text" value="' . $end_text . '" /></td>';
$content .= '<td>' . $dti_ref_filter . '</td>';
$csvdata = array();
$c = array();
$c['order_id'] = 'order_id';
$c['delivery_company'] = 'delivery_company';
$c['delivery_name'] = 'delivery_name';
$c['delivery_address'] = 'delivery_address';
$c['delivery_city'] = 'delivery_city';
$c['delivery_postcode'] = 'delivery_postcode';
$c['delivery_country'] = 'delivery_country';
$csvdata[] = $c;
foreach ($order_data_array as $order_id) {
$order = array();
//RETRIEVED DATA
$order_data = $class_o->retrieveDetail($order_id);
$c = array();
$c['order_id'] = $order_data['orders_no'];
$c['delivery_company'] = $order_data['delivery_company'];
$c['delivery_name'] = $order_data['delivery_name'];
$c['delivery_address'] = $order_data['delivery_street_address'];
$c['delivery_city'] = $order_data['delivery_city'];
$c['delivery_postcode'] = "'" . $order_data['delivery_postcode'] . "'";
$c['delivery_country'] = $order_data['delivery_country'];
$csvdata[] = $c;
}
$file_name = 'jng-package-labels-' . date('Ymd-Hi') . '.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
echo tep_create_csv($csvdata);
$data[] = $p['products_price'];
$data[] = '';
$data[] = 'Recently bought on ' . date('d-M-Y', strtotime($p['date_purchased']));
$csv[] = $data;
foreach ($el[$product_id] as $e) {
$data = array();
$data[] = '';
$data[] = $e['elements_code'];
$data[] = $e['elements_price'];
$data[] = $e['quantity'];
$data[] = $e['quantity'] * $e['elements_price'];
$csv[] = $data;
}
$data = array();
$data[] = '';
$data[] = '';
$data[] = '';
$data[] = '';
$data[] = '';
$data[] = '';
$data[] = '';
$csv[] = $data;
}
$content .= '<div class="homewin"> </div>';
$file_name = 'jng-product-analysis-' . date('Ymd-Hi') . '.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
echo tep_create_csv($csv);
exit;
$table[] = $row1_period;
$table[] = $row2_blank_line;
$table[] = $row3_previous_open_amount;
$table[] = $row4_incoming_amount_real;
$table[] = $row5_outgoing_amount_real;
$table[] = $row6_total_invoice_amount;
$table[] = $row7_total_returns_amount;
$table[] = $row8_blank_line;
$table[] = $row9_calculated_open_amount;
$table[] = $row10_open_amount;
$table[] = $row11_blank_line;
$table[] = $row12_open_amount_diff;
$table[] = $row13_blank_line;
$table[] = $row14_open_amount_prev_0;
$table[] = $row15_open_amount_prev_1;
$table[] = $row16_open_amount_prev_2;
$table[] = $row17_blank_line;
$table[] = $row18_returns_same_period;
$table[] = $row19_returns_previous_period;
$table[] = $row20_blank_line;
$table[] = $row21_confirmed_payment_prev;
$table[] = $row22_sent_to_atriga;
$table[] = $row23_total_after_returns;
$today = date('Ymd');
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$today}-ReportBookkeeping-{$year}.csv\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
//csv is adjusted to german version
echo str_replace('.', ',', tep_create_csv($table, ';'));
tep_db_close();
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
$q = "SELECT navigation FROM jng_sp_catalog GROUP BY navigation";
$r = tep_db_query($q);
$navs = array();
while ($row = tep_db_fetch_array($r)) {
$navs[] = $row['navigation'];
}
$navid = neckermannNavIDs();
$show = array();
foreach ($navid as $id => $name) {
if (in_array($id, $navs)) {
$show[] = array($id, $name);
}
}
echo '<pre>';
echo tep_create_csv($show);
echo '</pre>';
tep_db_close();
$q .= " FROM jng_sp_orders jo";
$q .= " LEFT JOIN jng_sp_orders_items joi ON joi.jng_sp_orders_id = jo.jng_sp_orders_id";
$q .= " WHERE joi.status IN ( 2, 3, 4 )";
$q .= " AND DATE_ADD( order_date, INTERVAL IF( (delivery_time -3) <0, 1, delivery_time -3 ) DAY ) <= DATE( '{$date_filter}' )";
$r = tep_db_query($q);
$total_products = tep_db_num_rows($r);
while ($row = tep_db_fetch_array($r)) {
$line = array();
$line[] = date('dmY', strtotime($row['AUFTRAGS_DATUM']));
$line[] = $row['AUFTRAGS_NR'];
$line[] = $row['ARTIKELNR'];
$line[] = $row['KUNDEN_NUMMER'];
$line[] = $row['KUNDE'];
$csv[] = $line;
}
if (isset($_GET['format']) && $_GET['format'] == 'csv') {
$file_name = date('ymd') . '-Verspaetete-Sendungen-JNG.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
$content = tep_create_csv($csv);
} else {
$content .= '<div>Total Products: ' . $total_products . '</div>';
$content .= '<div><a href="?format=csv&ts=' . time() . '" target="_blank">Click here to download as CSV</a></div>';
$content .= '<pre style="margin-top:20px;">';
$content .= tep_create_csv($csv);
$content .= '</pre>';
}
echo $content;
tep_db_close();
$crow[] = $row['coupon_code'];
if ($x == $column) {
$c[] = $crow;
$crow = array();
$x = 0;
}
}
if ($x < $column) {
$c[] = $crow;
}
$file_name = 'jng-500-vouchers-.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
echo tep_create_csv($c);
exit;
/*
} else {
if(isset($_GET['nodebug']) && $_GET['nodebug']=='true') $debug = false;
else $debug = true;
if($debug) {
$coupons = array();
$sql_data_array = array('no', 'No',
'coupon_code' => 'Code',
'coupon_amount' => 'Amount',
'free_shipping' => 'FS',
'coupon_minimum_order' => 'MinOrder',
'coupon_start_date' => 'Start',
$xml_rel = amazonVDTemplateXML('accessories', $ean, $links_ids);
amazonVDWriteToFile($xml_variation_filename, $xml_rel, 'a');
}
##echo $xml_var4;
amazonVDWriteToFile($xml_variation_filename, $xml_var4, 'a', false);
*/
//IMPORTANT TODO: REFIGURE A WAY TO GENERATE THE DISCOUNTED PRODUCTS
if (count($discounted_products) > 0) {
$dp = array();
$dp[] = 'EAN';
$dp[] = 'Price Old';
$dp[] = 'Selling Price Old';
$dp[] = 'Price New';
$dp[] = 'Selling Price New';
array_unshift($discounted_products, $dp);
amazonVDWriteToFile($csv_discount_filename, tep_create_csv($discounted_products), 'w');
}
$upload_id = $class_ju->newUpload($jng_sp_id, 'CAT', $xml_item_filename, $session_userinfo['username']);
//$class_ju->addUploadType($upload_id, 'VAR', $xml_variation_filename);
$class_ju->addUploadType($upload_id, 'MEDIA', strval($total_zipfiles));
foreach ($upload_image_log as $jcid) {
$class_ju->addUploadImage($upload_id, $jcid);
}
foreach ($active_log as $status => $jccol) {
foreach ($jccol as $jcid) {
$class_ju->addUploadProducts($upload_id, $jcid, $status);
}
}
$content .= '<table border="0" cellpadding="0" cellspacing="0">';
$fsstyle = ' style="padding-top:8px;text-align:right;"';
$xmlitem_file = SP_AMAZONVD_UPLOAD_PATH . $xml_item_filename;
$orders[1]['name'] = ' ';
$orders[1]['bt_own'] = ' ';
$orders[1]['bt_number'] = ' ';
$orders[1]['bt_name'] = ' ';
$orders[1]['bt_bankno'] = ' ';
$orders[1]['o_number'] = ' ';
$orders[1]['price'] = ' ';
$orders[1]['i_number'] = ' ';
}
if ($csvformat) {
$file_name = 'jng-bankeinzug-unpaid-' . date('Ymd-Hi') . '.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
echo tep_create_csv($orders);
exit;
} else {
$order = array();
$order['name'] = ' ';
$order['bt_own'] = ' ';
$order['bt_number'] = ' ';
$order['bt_name'] = ' ';
$order['bt_bankno'] = ' ';
$order['o_number'] = ' ';
$amount = $csvformat ? number_format($total_price, 2) : displayCurrency('EUR', $total_price);
$order['price'] = $amount;
$order['i_number'] = ' ';
$orders[] = $order;
}
$dl = '?open=orders-bankeinzug-unpaid&format=csv';
