$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';