$element = new element($elements_id); $supplier = new elements_suppliers($supplier_id); if (is_null($supplier->id)) { $messagebox->add("Please select a supplier to add!"); } else { $element->getSuppliers(); $unit = ''; $qty_per_unit = 1; foreach ($element->suppliers as $etes) { if ($etes['is_default'] == '1') { $unit = $etes['price_quantity_type']; $qty_per_unit = $etes['pieces_per_qty_type']; break; } } $element->addSupplier($supplier->id, 0, $unit, '', '', 0, $qty_per_unit, '0', $supplier->safety_delivery_time); $messagebox->add('New Supplier: <strong>' . $supplier->detail['name'] . '</strong> is added to this element.', 'green'); } $_GET['id'] = $elements_id; } elseif ($_POST['me_action'] == 'SEARCHELEMENTSBYSUPCODE') { $jng_warehouses_id = tep_db_prepare_input($_POST['jng_warehouses_id']); $supcode = tep_db_prepare_input($_POST['supcode']); $q = "SELECT etes.elements_id, etes.item_number, es.suppliers_name FROM elements_suppliers es LEFT JOIN elements_to_elements_suppliers etes ON etes.elements_suppliers_id=es.elements_suppliers_id WHERE etes.item_number LIKE '%{$supcode}%'"; $r = tep_db_query($q); $elements_found = tep_db_num_rows($r); if ($elements_found == 0) { $elements = '<div class="red">Can not find element with supplier code containing <strong>' . $supcode . '</strong> in database.</div>'; } elseif ($elements_found == 1) { $row = tep_db_fetch_array($r); $elements = getElementSuppliers($row['elements_id']); } else {