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