Beispiel #1
0
     //		$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'";