while ($row = tep_db_fetch_array($r)) { $products_id = $row['products_id']; $ca = explode(',', $row['color']); foreach ($ca as $key => $c) { $ca[$key] = trim($c); } $color_pattern_id = array(); foreach ($ca as $c) { if ($c != '' && isset($colors[$c])) { $color_pattern_id[] = $colors[$c]; } } if (count($color_pattern_id) > 0) { $class_pm->setColorPattern($products_id, $color_pattern_id); } $ma = explode(',', $row['material']); foreach ($ma as $key => $m) { $ma[$key] = trim($m); } $products_materials_id = array(); foreach ($ma as $m) { if ($m != '' && in_array($m, $materials)) { $products_materials_id[] = array_search($m, $materials); } } if (count($products_materials_id) > 0) { $class_pm->setProductMaterials($products_id, $products_materials_id); } } echo 'Done'; tep_db_close();
while ($r = tep_db_fetch_array($dbq)) { if ($r['finishing_goldplate'] == '1' && !in_array($r['products_id'], $goldplated)) { $goldplated[] = $r['products_id']; } if (!isset($products[$r['products_id']])) { $products[$r['products_id']] = array(); } if (!is_null($r['attribute_material_id']) && !in_array($r['attribute_material_id'], $products[$r['products_id']])) { $products[$r['products_id']][] = $r['attribute_material_id']; } } //echo "<pre>";var_dump($products); //die(); foreach ($products as $pid => $materials_id) { // echo "$pid : ";print_r($materials_id); // echo "<br if (count($materials_id) > 0) { if (in_array($pid, $goldplated)) { $key = array_search('1', $materials_id); if ($key !== false) { unset($materials_id[$key]); } $materials_id[] = '17'; } $class_pm->setProductMaterials($pid, $materials_id); $class_cp->setParams($pid, 'M'); echo "Product {$pid} , materials_id's (" . implode(",", $materials_id) . ") added <br/>"; } else { echo "No Material found: {$pid}<br/>"; } }