$archive_path['5'] = SP_AMAZONVD_ARCHIVE_PATH;
$archive_path['7'] = SP_BUYVIP_ARCHIVE_PATH;
$archive_path['9'] = SP_AMAZONFR_ARCHIVE_PATH;
$download_link_id = array();
$download_link_id['5'] = 'amvde';
$download_link_id['7'] = 'buyvip';
$download_link_id['9'] = 'amfr';
$sp_list = $class_sp->retrieveList('use_amvd_logistic=1');
$sp_list_ids = array_keys($sp_list);
$default_sp_id = $sp_list_ids[0];
$header = 'Redownload PO Confirmation File';
$paragraphs = array();
$paragraphs[] = 'You can download here recent PO confirmation file of specific Sales Partner';
$style = 'margin:10px 0 20px 0;';
$content .= drawSOPinfo($header, $paragraphs, $style);
$content .= '<div style="margin-bottom:20px;">' . $class_sp->drawCombo($sp_list, $default_sp_id, 'spid-po-confirm') . '</div>';
foreach ($sp_list as $jng_sp_id => $sp_detail) {
$display = $jng_sp_id == $default_sp_id ? '' : ' style="display:none;"';
$content .= '<div id="spid-po-confirm-' . $jng_sp_id . '" class="spid-po-confirm"' . $display . '>';
$backup_path = $archive_path[$jng_sp_id] . 'confirm/';
$existingfiles = array();
$q = "SELECT filename FROM jng_sp_download WHERE jng_sp_id={$jng_sp_id} AND process_status='I' ORDER BY download_time DESC LIMIT 10";
$r = tep_db_query($q);
while ($row = tep_db_fetch_array($r)) {
if (!in_array($row['filename'], $existingfiles)) {
if (is_file($backup_path . $row['filename'])) {
$existingfiles[] = $row['filename'];
}
}
}
if (count($existingfiles) > 0) {
function manageOrderList_drawFilter($jng_sp_id, $ean_list = null, $date_start = null, $date_end = null, $brand_id = null, $cat_id = null, $orders_no = '')
{
use_class('jng_sp');
use_class('products_brand');
$class_sp = new jng_sp();
$class_pb = new products_brand();
$spdata = $class_sp->retrieveList();
$brands = $class_pb->retrieveList("active_status='1'");
array_unshift($spdata, array('jng_sp_id' => '0', 'name' => 'All Sales Partners'));
$filter_sp = $class_sp->drawCombo($spdata, $jng_sp_id, '', 'jng_sp_id', 'orders-spid');
$brand_options = array();
$brand_options[0] = 'Show All Brands';
foreach ($brands as $b) {
$brand_options[$b['products_brand_id']] = $b['brand_name'];
}
$filter_brand = '<select name="brand_id">' . loadComboListFromArray($brand_options, null, $brand_id, false) . '</select>';
$filter_category = comboProductsCategory('cat_id', 'cat_id', $cat_id, '', '', 'Show All Category');
$filter_prod_search = '<input type="text" name="ean_list" class="product-id input" value="' . $ean_list . '" />';
$filter_range_date = '<input name="date_range_start" class="date_picker" value="' . $date_start . '"/>';
$filter_range_date .= ' to <input name="date_range_end" class="date_picker" value="' . $date_end . '"/>';
$filter_range_date .= ' <input type="button" value="Go" class="date_range_go" title="Apply lead time start date filter" />';
$filter_range_date .= ' <input type="button" value="Clear" class="date_range_clear" title="Clear lead time start date filter" />';
$filter_orders_no = '<input type="text" name="orders_no" class="orders-no" value="' . (is_array($orders_no) ? implode(",", $orders_no) : $orders_no) . '" />';
$enter_info = '<span class="notice smallText" style="font-weight:normal;">(press <em>Enter</em> to filter)</span>';
$result .= '<div style="margin-bottom:10px;">';
$result .= '<table border="0" cellpadding="0" cellspacing="0">';
$result .= '<tr>';
$result .= '<td rowspan="2" class="w080 bold" style="v-align:middle;">Filter by:</td>';
$result .= '<td class="bold">Sales Partner</td>';
$result .= '<td class="bold">Brand</td>';
$result .= '<td class="bold">Category</td>';
$result .= '<td class="bold">Product ID/EAN ' . $enter_info . '</td>';
$result .= '<td class="bold">Order No. ' . $enter_info . '</td>';
$result .= '<td class="bold">Lead Time Start Date</td>';
$result .= '</tr>';
$result .= '<tr><td>' . $filter_sp . '</td><td>' . $filter_brand . '</td><td>' . $filter_category . '</td><td>' . $filter_prod_search . '</td><td>' . $filter_orders_no . '</td><td>' . $filter_range_date . '</td></tr>';
$result .= '</table></div>';
return $result;
}
$session_page = 'sp-products-manage';
$show_sp_combo = true;
if (isset($_GET['jng_sp_id']) && $_GET['jng_sp_id'] != '') {
$jng_sp_id = tep_db_prepare_input($_GET['jng_sp_id']);
$show_sp_combo = false;
} elseif (isset($_POST['jng_sp_id']) && $_POST['jng_sp_id'] != '') {
$jng_sp_id = tep_db_prepare_input($_POST['jng_sp_id']);
} elseif (isset($_SESSION[$session_page]['jng_sp_id'])) {
$jng_sp_id = $_SESSION[$session_page]['jng_sp_id'];
} else {
$jng_sp_id = $sp_data[$sp_data_keys[0]]['jng_sp_id'];
}
$_SESSION[$session_page]['jng_sp_id'] = $jng_sp_id;
$sp_detail = $class_sp->retrieveDetail($jng_sp_id);
if ($show_sp_combo) {
$sp_combo = $class_sp->drawCombo($sp_data, $jng_sp_id, 'sp_option', 'jng_sp_id');
$content = '<h3>';
$content .= '<form name="sel_sp" action="?open=analysis-vc-params" method="post">';
$content .= 'Sales Partner ';
$content .= $sp_combo;
$content .= '</form>';
$content .= '</h3>';
}
$form .= '<form name="sp_data" action="?open=analysis-vc-params" method="post">';
$form .= '<input type="hidden" name="me_action" value="SAVEVCPARAMS" />';
$form .= '<input type="hidden" name="jng_sp_id" value="' . $jng_sp_id . '" />';
$form .= '<div class="form"><table border="0" cellpadding="0" cellspacing="0">';
foreach ($vc_params as $key => $colname) {
$width = $key == 0 ? ' width="250"' : '';
$form .= '<tr><td' . $width . '>' . $vc_labels[$key] . '</td><td>';
$form .= '<input type="text" class="number" name="' . $colname . '" value="' . $sp_detail[$colname] . '" /> ' . $vc_units[$key] . '</td></tr>';
}
$result .= ' </div>';
} else {
$result .= "Product {$products_id} not found";
}
$result .= '</div>';
$ajaxResult = array();
$ajaxResult['result'] = $result;
$ajaxResult['pid'] = $products_id;
ajaxReturn($ajaxResult);
exit;
}
$sp_data = $class_sp->retrieveList();
array_unshift($sp_data, array('jng_sp_id' => '0', 'name' => 'Julie & Grace'));
array_unshift($sp_data, array('jng_sp_id' => 'ALL', 'name' => 'ALL SP and J&G'));
$filter_sp = $class_sp->drawCombo($sp_data, $jng_sp_id, 'sp-id');
$content .= '<div class="notice" style="margin:-15px 0 20px 0;">Show Course of Demand of a product based on selected filters</div>';
$content .= '<table border="0" cellpadding="0" cellspacing="0" style="margin-bottom:20px;">';
$content .= '<tr>';
$content .= '<td>';
$content .= '<div class="bold">Sales Partner</div>';
$content .= '<div>' . $filter_sp . '</div>';
$content .= '</td>';
$content .= '<td>';
$content .= '<div class="bold">Product ID</div>';
$content .= '<div>';
$content .= ' <input type="text" id="products-id" class="w250" />';
$content .= '</div>';
$content .= '</td>';
$content .= '<td>';
$content .= '<div class="bold">Week</div>';
