$category_top_id = tep_db_prepare_input($_POST['ctid']); $genders = Product::getOldProductFunction()->productGenderName(); unset($genders[0]); //none unset($genders[3]); //unisex $obj_ct = new CategoryTop($category_top_id); $subcats = ProductAttribute::getOldStylesFunction()->retrieveList($obj_ct->getSubCategoryGroup()); if (in_array($jng_sp_id, array(1005))) { //get from Primary Navigation (Navigation for this SP separated between Primary and Secondary) $navids = retrieveNavIDs($jng_sp_id, 'sc'); } else { //Navigation are used for both Primary and Additional $navids = retrieveNavIDs($jng_sp_id, ''); } $params = $class_jpc->loadAsMapper($jng_sp_id, $param_code); if (count($subcats) == 0) { $result = '<h3 class="red">No Sub Categories found</h3>'; } else { $result = '<div><table class="form" border="0" cellpadding="0" cellspacing="0">'; foreach ($genders as $gkey => $gval) { $gender_color = $gkey == '1' ? 'green' : 'blue'; foreach ($subcats as $sc) { $param_id = $sc['styles_id']; $param_name = $sc['name']; $param_id2 = $gkey; $params_key = $param_id . '-' . $param_id2; $navids_combo = '<select id="navids">' . loadComboListFromArray($navids) . '</select>'; if (isset($params[$params_key])) { $checked = 'checked="checked"'; $param_value = $params[$params_key];
} $content .= '</table>'; $content .= '<div style="margin-top:20px;"><input id="amvd-download-all" type="button" value="Download All Files" /></div>'; $javascript .= ' $("#amvd-download-all").click(function() { $("a.dl-icon").each(function() { window.open($(this).attr("href")); }); }); '; //AMAZON VENDOR UPLOAD PROCESS END } elseif ($jng_sp_id == '1001') { /////////////////////////////////////// // LAZADA INDONESIA UPLOAD PROCESS // /////////////////////////////////////// //SP brand values will be filled later in the loop $sp_values_brand = array(); $sp_values_colors = $class_jcp->loadAsMapper($jng_sp_id, 'C'); $sp_values_navsubcat = $class_jcp->loadAsMapper($jng_sp_id, 'N'); $sp_values_navcat = $class_jcp->loadAsMapper($jng_sp_id, 'V'); // $template_file = SP_LAZADAID_PATH . 'templates/catalog-fashion.xls'; $template_file = SP_LAZADAID_PATH . 'templates/catalog-fashion-150519.xls'; //set on which row the column key is $template_row_keys = 3; //set on which row the data should start $template_row_start = 4; $obj_excel_reader = new PHPExcel_Reader_Excel5(); $test = $obj_excel_reader->canRead($template_file); $obj_excel = $obj_excel_reader->load($template_file); $obj_excel->setActiveSheetIndex(0); $obj_excel_ws = $obj_excel->getActiveSheet(); //get all column key from template $colkey = 'Starter';