# Created : Mar 10, 2011 3:40:53 PM # ######################################### use_class('elements_search'); use_class('products_minierp'); use_class('element'); $class_es = new elements_search(); $class_pm = new products_minierp(); $products_id = tep_db_prepare_input($_GET['pid']); $is_accessed_from_design_mgmt = strpos($_SERVER['HTTP_REFERER'], 'designs-products-elements-used') !== false ? true : false; if (isset($_POST['me_action'])) { $class_es->postProcess($_POST); if ($_POST['me_action'] == 'ELEMENTSUSEDADD') { $pid = tep_db_prepare_input($_POST['pid']); $elid = tep_db_prepare_input($_POST['elid']); $elqty = tep_db_prepare_input($_POST['elqty']); $el_added = $class_pm->addElementToProducts($pid, $elid, $elqty); $result = array(); $result['eladded'] = $el_added; ajaxReturn($result); exit; } elseif ($_POST['me_action'] == 'ELEMENTSUSEDADDDIRECT') { $pid = tep_db_prepare_input($_POST['pid']); $elid = tep_db_prepare_input($_POST['elid']); $elqty = tep_db_prepare_input($_POST['elqty']); $el_added = $class_pm->addElementToProducts($pid, $elid, $elqty); $result = array(); $result['eladded'] = $el_added; ajaxReturn($result); exit; } elseif ($_POST['me_action'] == 'SEARCHUSEDELEMENTS') { $products_id_copy = tep_db_prepare_input($_POST['pid_c']);
$elements_ids[] = $elid; $elements_qtys[] = $elqty; $elements_titles[] = "{$elid} <i>\"JUMPRING-4 {$elqty} qtys</i>\""; echo "<h3>Add element " . implode(' and ', $elements_titles) . "</h3>"; $q = "SELECT pb.brand_name,pue.finishing_goldplate, p.* "; $q .= " FROM products p"; $q .= " INNER JOIN products_to_categories ptc ON ptc.products_id = p.products_id AND ptc.categories_id = 30"; //APPLY TO SETS $q .= " INNER JOIN products_use_elements pue ON pue.products_id = p.products_id"; $q .= " INNER JOIN element e ON e.elements_id = pue.elements_id AND e.attribute_category_id = 4"; $q .= " INNER JOIN products_brand pb ON pb.products_brand_id = p.products_brand_id"; $q .= " WHERE p.products_status = 1"; $q .= " AND p.products_brand_id != 23"; $q .= " AND pue.quantity >= 40"; $dbq = tep_db_query($q); $counter = 0; while ($r = tep_db_fetch_array($dbq)) { $products_id = $r['products_id']; $brand_name = $r['brand_name']; $is_goldplated = $r['finishing_goldplate'] == 1 ? true : false; //chain is goldplated $goldplated = $is_goldplated ? "- Goldplated" : ''; $class_pm->addElementToProducts($products_id, $elements_ids, $elements_qtys); if ($is_goldplated) { tep_db_perform('products_use_elements', array('finishing_goldplate' => '1'), 'update', "products_id={$products_id} AND elements_id IN (" . implode(',', $elements_ids) . ")"); } $class_pm->calculateMaterialExpenses($products_id); echo "added to products {$products_id} - {$brand_name} {$goldplated}<br/>"; $counter++; } echo "<h2>Total {$counter} Products added with new element!</h2>";