Bestellstatus-Historie bereits in Bestellübersicht anzeigen lassen

[swolfram [templatix]]

Ich versuche verzeifelt, die Bestellstatus-Historie aus der Detailansicht in die Übersicht zu bekommen. In der admin/orders.php bin ich da sicherlich richtig, hier ist ja auch die Übersicht für die Detailseite drin. Aber ich bekomm die einfach nicht in die Box an der Seite. Irgendwie will heute nichts mehr....

Hat einer nen Tipp oder Code-Schnippsel?
Da wo der Pfeil hinzeigt soll dann stehen:
26.11.2014 In Bearbeitung
27.11.2014 Versendet

DANKE

Linkback: https://www.modified-shop.org/forum/index.php?topic=31611.0

[swolfram [templatix]]

Hach, doch endlich selber geschafft.... Frischer Kaffee hilft immer
Ob das jetzt modified-Konform ist weiß ich grad nicht, aber es funktioniert.

In der admin/orders.php ca. Zeile 1070 finde

Code: PHP  [Auswählen]

 $contents[] = array ('text' => '<br />'.TEXT_INFO_PAYMENT_METHOD.' '.$oInfo->payment_method);  

Füge danach ein

Code: PHP  [Auswählen]

/// BOL Order_Status_History in Adminbox - BS24
$oshlist_query="SELECT *
FROM orders_status os, orders_status_history osh
WHERE osh.orders_id = ".$oInfo->orders_id."
AND osh.orders_status_id = os.orders_status_id
AND os.language_id=2
ORDER BY osh.orders_status_history_id ASC";    
    $oshlist2 = xtc_db_query($oshlist_query);
while($osh = xtc_db_fetch_array($oshlist2)) {
    $oshistory .= '<strong>'.xtc_date_short($osh['date_added']).':</strong> '.$osh['orders_status_name'].'<br/>';
}
$contents[] = array ('text' => '<hr/>'.$oshistory.'<hr/>');
//// Order_Status_History EOL

[web0null]

Hatte es gerade zusammengestellt (aber die ganze Tabelle).
Wer es noch braucht,

Suche in "admin/orders.php",

Code: PHP  [Auswählen]

if ($order->info['comments']<>'') {
  $contents[] = array ('text' => '<br><strong>'.TABLE_HEADING_COMMENTS.':</strong><br>'.$order->info['comments']);
}
 

ersetze mit,

Code: PHP  [Auswählen]

if ($order->info['comments']<>'') {
  $contents[] = array ('text' => '<br><strong>'.TABLE_HEADING_COMMENTS.':</strong><br>'.$order->info['comments']);
}
$history_block  = '<div class="heading">'.TEXT_ORDER_HISTORY.'</div>'.PHP_EOL;
$history_block .= '<table border="1" cellspacing="0" cellpadding="5">'.PHP_EOL;
$history_block .= '<tr>'.PHP_EOL;
$history_block .= '<td class="smallText" align="center"><b>'.TABLE_HEADING_DATE_ADDED.'</b></td>'.PHP_EOL;
$history_block .= '<td class="smallText" align="center"><b>'.TABLE_HEADING_CUSTOMER_NOTIFIED.'</b></td>'.PHP_EOL;
$history_block .= '<td class="smallText" align="center"><b>'.TABLE_HEADING_STATUS.'</b></td>'.PHP_EOL;
$history_block .= '<td class="smallText" align="center"><b>'.TABLE_HEADING_COMMENTS.'</b></td>'.PHP_EOL;
$history_block .= '<td class="smallText" align="center"><b>'.TABLE_HEADING_COMMENTS_SENT.'</b></td>'.PHP_EOL;
$history_block .= '</tr>'.PHP_EOL;
$orders_history_query = xtc_db_query("-- " . __LINE__ . __FILE__ . "
    SELECT orders_status_id,
           date_added,
           customer_notified,
           comments,
           comments_sent
      FROM ".TABLE_ORDERS_STATUS_HISTORY."
     WHERE orders_id = ".$oInfo->orders_id."
  ORDER BY date_added
");
if ($count = xtc_db_num_rows($orders_history_query)) {
  while ($orders_history = xtc_db_fetch_array($orders_history_query)) {
    $count--;
    $class = ($count == 0) ? ' last_row' : '';
    $history_block .= '<tr>'.PHP_EOL;
    $history_block .= '<td class="smallText'.$class.'" align="center">'.xtc_datetime_short($orders_history['date_added']).'</td>'.PHP_EOL;
    $history_block .= '<td class="smallText'.$class.'" align="center">';
    $history_block .= $orders_history['customer_notified'] == '1'
                    ? xtc_image(DIR_WS_ICONS.'tick.gif', ICON_TICK)
                    : xtc_image(DIR_WS_ICONS.'cross.gif', ICON_CROSS);

    $history_block .= '</td>'.PHP_EOL;
    $history_block .= '<td class="smallText'. $class.'">';
    $history_block .= $orders_history['orders_status_id']!='0'
                    ? $orders_status_array[$orders_history['orders_status_id']]
                    :'<font color="#FF0000">'.TEXT_VALIDATING.'</font>';
    $history_block .= '</td>'.PHP_EOL;
    $history_block .= '<td class="smallText'.$class.'">'.nl2br(xtc_db_output($orders_history['comments'])).'&nbsp;</td>'. PHP_EOL;
    $history_block .= '<td class="smallText'.$class.'" align="center">';
    $history_block .= $orders_history['comments_sent'] == '1'
                    ? xtc_image(DIR_WS_ICONS.'tick.gif', ICON_TICK)
                    : xtc_image(DIR_WS_ICONS.'cross.gif', ICON_CROSS);
    $history_block .= '</td>'.PHP_EOL;
    $history_block .= '</tr>'.PHP_EOL;
  }
} else {
  $history_block .= '<tr>'.PHP_EOL;
  $history_block .= '<td class="smallText" colspan="5">'.TEXT_NO_ORDER_HISTORY.'</td>'.PHP_EOL;
  $history_block .= '</tr>'.PHP_EOL;
}

$history_block .= '</table>';
$contents[] = array ('text' => $history_block);
 

Gruß

[swolfram [templatix]]

Danke, sehr schön. Für mich wäre die gesamte Tabelle zuviel, aber so kann man jetzt wählen, je nach Geschmack 

[web0null]

Die "kleine" Variante (zwecks Konformität) sehe so aus,

Suche in "admin/orders.php",

Code: PHP  [Auswählen]

if ($order->info['comments']<>'') {
  $contents[] = array ('text' => '<br><strong>'.TABLE_HEADING_COMMENTS.':</strong><br>'.$order->info['comments']);
}
 

ersetze mit,

Code: PHP  [Auswählen]

if ($order->info['comments']<>'') {
  $contents[] = array ('text' => '<br><strong>'.TABLE_HEADING_COMMENTS.':</strong><br>'.$order->info['comments']);
}
$orders_history_query = xtc_db_query("-- " . __LINE__ . __FILE__ . "
   SELECT orders_status_id,
          date_added
     FROM ".TABLE_ORDERS_STATUS_HISTORY."
    WHERE orders_id = ".$oInfo->orders_id."
 ORDER BY date_added
");
$history_block = '<span>'.TEXT_ORDER_HISTORY.'</span><br />'.PHP_EOL;
while($orders_history = xtc_db_fetch_array($orders_history_query)) {
  $history_block .= '<strong>'.xtc_date_short($orders_history['date_added']).':</strong> '.$orders_status_array[$orders_history['orders_status_id']].'<br/>';
}
$contents[] = array ('text' => '<hr/>'.$history_block.'<hr/>');
 

Gruß