// $result = array(); // $result['tooltip'] = $tooltip; // ajaxReturn($result); // exit; } elseif ($_POST['me_action'] == 'GETELEMENTSUSED') { $items = tep_db_prepare_input($_POST['oi_id']); $items_id = explode(",", $items); $item = array(); foreach ($items_id as $id) { $item[] = $class_jo->retrieveItemDetail($id); } $elements = array(); $elements_usage = array(); foreach ($item as $i) { $qty = $i['order_quantity']; $eu = $class_jo->countElementsUsage($i['products_id'], $i['products_articles_id']); foreach ($eu as $id => $e) { if (!in_array($id, $elements)) { $elements[] = $id; $elements_usage[$id] = $qty * $e; } else { $elements_usage[$id] += $qty * $e; } } } $elements_filter = implode(',', $elements); $el_query = "SELECT e.elements_id, e.elements_code, CONCAT('elements/',ei.image_path,ei.image_filename) AS image"; $el_query .= ", es.suppliers_name"; $el_query .= " FROM elements e"; $el_query .= " LEFT JOIN elements_images ei ON ei.elements_id=e.elements_id AND ei.elements_sample_name='EC1'"; $el_query .= " LEFT JOIN elements_to_elements_suppliers etes ON etes.elements_id=e.elements_id AND etes.is_default='1'";