Product Listing

[maykol]

Ciao a tutti,
domandina facile facile.... Sempre se c'è qualcuno che è così gentile da rispondermi....

Quali sono i settaggi giusti da utilizzare nella product listing per visualizzare:

1 immagie
2 Nome Prodotto
3 Produttore
4 Quantità disponibile
5 Prezzo

Ho provato a cambiare i numeri nella product listing ma non riesco a settare le varie voci in modo che sia tutto visilibe....
Grazie in anticipo...

[loris_ripa]

In Admin:

Configuration -> Product Listing

Setta i numeri in base all'ordine con cui vuoi che ti appaiano.
Ciao

[maykol]

ho provato a fare in questo modo ma il risultato e che vedo le prime tre voci, (immagine, nome prodotto, produttore) ma non vedo la quantrità e il costo.
Sembrerebbe che mi lascia vedere solo 3 campi per volta e gli altri no.
In oltre non so dove cambiare la SCRITTA Manufactur: con Artista: nella pagina nuovi prodotti.

[loris_ripa]

Strano...hai installato qualche contribution?
Nella mia admin lo stato delle opzioni è così:

Display Product Image 1
Display Product Manufaturer Name 0
Display Product Model 0
Display Product Name 2
Display Product Price 3
Display Product Quantity 0
Display Product Weight 0
Display Buy Now column 4

Ciao

[maykol]

si, avevo installato osplayer ma non mi funzionava e l'ho rimosso, anche se nella product listing visualizzo ancora le voci mp3 preview ma sono settati tutti a 0, la mia configurazione è come la tua ma io ho in più la quantità e non ho la colonna acquista.

[loris_ripa]

Hai provato a copiare il file product _listing.php originale nella tua cartella?
Ciao

[maykol]

penso che il problema sia propio quello, il mio codice della product_listing.php è il seguente:

<?php
/*
$Id: product_listing.php,v 1.44 2003/06/09 22:49:59 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/
$listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');

if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
</tr>
</table>
<?php
}

$list_box_contents = array();

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
switch ($column_list[$col]) {
case 'PRODUCT_LIST_MODEL':
$lc_text = TABLE_HEADING_MODEL;
$lc_align = '';
break;
case 'PRODUCT_LIST_NAME':
$lc_text = TABLE_HEADING_PRODUCTS;
$lc_align = '';
break;
case 'PRODUCT_LIST_MANUFACTURER':
$lc_text = TABLE_HEADING_MANUFACTURER;
$lc_align = '';
break;
case 'PRODUCT_LIST_PRICE':
$lc_text = TABLE_HEADING_PRICE;
$lc_align = 'right';
break;
case 'PRODUCT_LIST_QUANTITY':
$lc_text = TABLE_HEADING_QUANTITY;
$lc_align = 'right';
break;
case 'PRODUCT_LIST_WEIGHT':
$lc_text = TABLE_HEADING_WEIGHT;
$lc_align = 'right';
break;
case 'PRODUCT_LIST_IMAGE':
$lc_text = TABLE_HEADING_IMAGE;
$lc_align = 'center';
break;
case 'PRODUCT_LIST_BUY_NOW':
$lc_text = TABLE_HEADING_BUY_NOW;
$lc_align = 'center';
break;
}

if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) {
$lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);
}

$list_box_contents[0][] = array('align' => $lc_align,
'params' => 'class="productListing-heading"',
'text' => ' ' . $lc_text . ' ');
}

if ($listing_split->number_of_rows > 0) {
$rows = 0;
$column = 0;
echo '

<table cellspacing=0 cellpadding=0 bgcolor=#FFFFFF width=552>
<tr><td height=1></td></tr>
<tr><td colspan=5 bgcolor=#A6AEB1 height=2></td></tr>
<tr><td height=12></td></tr>
<tr><td colspan=5 class=ml6>       Categories / <span class=ch9>'.$breadcrumb->trail(' » ').'</span></td></tr>
<tr><td height=3></td></tr>
<tr><td colspan=5 height=1 align=center>
<table cellspcing=0 cellpadding=0 width=513 align=center>
<tr><td width=513 height=1 background=images/m33.gif></td></tr>
</table>
</td></tr>
<tr><td height=3></td></tr>
<tr>



';

$listing_query = tep_db_query($listing_split->sql_query);
while ($listing = tep_db_fetch_array($listing_query)) {
$product_contents = array();
$rows++;
if (($rows/2) == floor($rows/2)) {
$list_box_contents[] = array('params' => 'class="productListing-even"');
} else {
$list_box_contents[] = array('params' => 'class="productListing-odd"');
}

$cur_row = sizeof($list_box_contents) - 1;

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
$lc_align = '';

switch ($column_list[$col]) {
case 'PRODUCT_LIST_MODEL':
$lc_align = '';
$lc_text = ' ' . $listing['products_model'] . ' ';
break;
case 'PRODUCT_LIST_NAME':
$lc_align = '';
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
$lc_text = '<a class=ml6 href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>';
} else {
$lc_text = '<a class=ml6 href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>';
}
break;
case 'PRODUCT_LIST_MANUFACTURER':
$lc_align = '';
$lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> ';
break;
case 'PRODUCT_LIST_PRICE':
$lc_align = 'right';
if (tep_not_null($listing['specials_new_products_price'])) {
$lc_text = '<span class=ch7 style="color:#7F7F7F;font-size:11px"><s>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s></span><br><span class=ch7>' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
} else {
$lc_text = '<span class=ch7>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
}
break;
case 'PRODUCT_LIST_QUANTITY':
$lc_align = 'right';
$lc_text = ' ' . $listing['products_quantity'] . ' ';
break;
case 'PRODUCT_LIST_WEIGHT':
$lc_align = 'right';
$lc_text = ' ' . $listing['products_weight'] . ' ';
break;
case 'PRODUCT_LIST_IMAGE':
$lc_align = 'center';
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
$lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
} else {
$lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
}
break;
case 'PRODUCT_LIST_BUY_NOW':
$lc_align = 'center';
$lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ';
break;
}

$list_box_contents[$cur_row][] = array('align' => $lc_align,
'params' => 'class="productListing-data"',
'text' => $lc_text);
$product_contents[] = $lc_text;
}


$product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$listing['products_id'] . "' and language_id = '" . (int)$languages_id . "'");
$product = tep_db_fetch_array($product_query);
$new_products['products_description'] = $product['products_description'];
// get products category
$cat_query = tep_db_query("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$listing['products_id'] . "'");
if (tep_db_num_rows($cat_query) > 0) {
$categ = tep_db_fetch_array($cat_query);
$categ_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$categ['categories_id'] . "'");
$categ2 = tep_db_fetch_array($categ_query);
$categ_name = $categ2['categories_name'];
} else {
$categ_name = '';
}

echo '

<td width=184 valign=top align=center>
<table cellspacing=0 cellpadding=0 width=139 align=center>
<tr><td height=26></td></tr>
<tr><td align=center>'.$product_contents[0].'</td></tr>
<tr><td height=44></td></tr>
<tr><td><a class=ml5 href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $categ_name . '</a></td></tr>
<tr><td height=50 valign=middle>'.$product_contents[1].'</td></tr>
<tr><td background=images/m17.gif height=1></td></tr>
<tr><td height=45 valign=middle><img src=images/m18.gif width=4 height=4 align=absmiddle>  '.preg_replace('/\s\S*$/i', '', substr($new_products['products_description'], 0, 50)).' ...</td></tr>
<tr><td height=35 valign=middle class=ch7>'.$product_contents[2].'</td></tr>
<tr><td height=10></td></tr>
<tr><td><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_in_cart.gif') . '</a> <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id']) . '">' . tep_image_button('small_view.gif') . '</a></td></tr>
<tr><td height=6></td></tr>
</table>
</td>


';
$column ++;
if ($column >= 3) {
$rows ++;
$column = 0;
echo '
</tr>
<tr>


';
} else echo '
<td width=1 bgcolor=#A6AEB1>
<table cellspacing=0 cellpadding=0><tr>
<td bgcolor=#A6AEB1 width=1></td>
</tr></table></td>';



}

echo '
</tr>
<tr><td height=4></td></tr>
</table>




';

//new productListingBox($list_box_contents);
} else {
$list_box_contents = array();

$list_box_contents[0] = array('params' => 'class="productListing-odd"');
$list_box_contents[0][] = array('params' => 'class="productListing-data"',
'text' => TEXT_NO_PRODUCTS);

echo '<div class=PageHeading>Categories</div>';
new productListingBox($list_box_contents);
}

if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) {
?>

<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr><td height=2></td></tr>
<tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
</tr>
</table>

<?php
}
?>

[loris_ripa]

Prova a sostituire il tuo file con quello originale di OsC: confrontandoli hanno delle differenze.
Ricordati se hai installato qualche contribution che ha modificato il file product_listing.php.
Ciao

[maykol]

effettivamente sostituendo il files con quello nativo di os funziona correttamente ma il problema è che mi sballa tutta la grafica.
Grazie per l'aiuto che mi stai dando
Come devo modificare la mia product_listing.php per vedere il campo Quantità? mi manca solo quel campo...