0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); require(DIR_WS_INCLUDES . 'template_top.php'); if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); ?>



PRODUCT_LIST_SORT_ORDER, 'PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, // 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW ); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { //sort order case 'PRODUCT_LIST_SORT_ORDER': $select_column_list .= 'p.products_sort_order, '; break; //end sort order case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } if ((!isset($HTTP_GET_VARS['sort'])) || (!preg_match('/^[1-8][ad]$/', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { //sort order if ($column_list[$i] == 'PRODUCT_LIST_SORT_ORDER') { $HTTP_GET_VARS['sort'] = $i + 1 . 'a'; $listing_sql .= " order by p.products_sort_order, pd.products_name"; break; } elseif ($column_list[$i] == 'PRODUCT_LIST_NAME' && PRODUCT_LIST_SORT_ORDER==0) { $HTTP_GET_VARS['sort'] = $i + 1 . 'a'; $listing_sql .= " order by pd.products_name"; // end sort order break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); switch ($column_list[$sort_col-1]) { //sort order case 'PRODUCT_LIST_SORT_ORDER': $listing_sql .= " order by p.products_sort_order , pd.products_name " . ($sort_order == 'a' ? 'asc' : ''); break; // end sort order case 'PRODUCT_LIST_MODEL': $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= " order by pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } $catname = HEADING_TITLE; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image, manufacturers_name as catname from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $catname = $image['catname']; } elseif ($current_category_id) { $image = tep_db_query("select c.categories_image, cd.categories_name as catname from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $image = tep_db_fetch_array($image); $catname = $image['catname']; } ?>

0) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { echo '
' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . '

' . TEXT_SHOW . ' '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); } echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo tep_hide_session_id() . '

' . "\n"; } } include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?>
Questo è il primo ecommerce in Italia che ti permette di visualizzare immediatamente il costo del prato a rotoli comprensivo di IVA e trasporto e puoi acquistarlo on-line.

Completi facilmente l'ordine e ricevi il prato a rotoli a casa in pochi giorni!

E' possibile acquistare anche piccole quantità di prato, è sufficiente scrivere quantità e località di destinazione nei campi di seguito per vedere il costo.

Inserisci quantità e località per vedere il costo del tuo prato.
Inserisci il luogo di consegna per vedere il costo del tuo prato.
Inserisci la provincia ed il comune.
Inserisci il comune.
Inserisci la quantità ed il luogo di consegna per vedere il costo del tuo prato.
metri quadri    
Inserisci il nome della città o il cap per trovarla velocemente.
' . ENTRY_COUNTRY_TEXT . '': ''); ?>
0); if ($country_id != '' and $entry_state_has_zones == true) { $zones_query = tep_db_query("select zone_id, zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' order by zone_name"); $zones_array = array(); while ($zones_values = tep_db_fetch_array($zones_query)) { $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']); } if (isset($zone_id)) { echo tep_draw_pull_down_menu('state', $zones_array, $zone_id, 'id="state"'); } else { $select_zones_array = array(); $select_zones_array[] = array('id' => '', 'text' => 'Seleziona...'); $zones_array = array_merge($select_zones_array, $zones_array); echo tep_draw_pull_down_menu('state', $zones_array, null, 'id="state"'); } } echo (tep_not_null(ENTRY_STATE_TEXT)) ? ' ' . ENTRY_STATE_TEXT . '' : ''; ?>
0); if ($zone_id != '' and $entry_zone_has_cities == true) { $cities_query = tep_db_query("select istat_code, city_name from " . TABLE_CITIES . " where city_zone_id = '" . (int)$zone_id . "' order by city_name"); $cities_array = array(); while ($cities_values = tep_db_fetch_array($cities_query)) { $cities_array[] = array('id' => $cities_values['istat_code'], 'text' => $cities_values['city_name']); } if (isset($city_id)) { echo tep_draw_input_field('city_name', null, 'id="city_name" style="display: none;"'); echo tep_draw_pull_down_menu('city_id', $cities_array, $city_id, 'id="city_id"'); } else { $select_cities_array = array(); $select_cities_array[] = array('id' => '', 'text' => 'Seleziona...'); $cities_array = array_merge($select_cities_array, $cities_array); echo tep_draw_input_field('city_name', null, 'id="city_name" style="display: none;"'); echo tep_draw_pull_down_menu('city_id', $cities_array, null, 'id="city_id"'); } } else { echo tep_draw_input_field('city_name', null, 'id="city_name"'); echo tep_draw_pull_down_menu('city_id', array(array('id' => '', 'text' => 'Seleziona...')), null, 'id="city_id" style="display: none;"'); } echo (tep_not_null(ENTRY_CITY_TEXT)) ? ' ' . ENTRY_CITY_TEXT . '' : ''; ?>
costo al metro quadro

 costo totale

'onclick="estimate_box_reset(); document.getElementById(\'estimate_box_overlay\').style.display=\'none\'; this.style.display=\'none\'; return false;"')); ?>

Come si procede all'acquisto del prato a rotoli:

Scegli la tipologia di prato fra quelle riportate nel box in alto a sinistra "Tipologie di Prato".

Se non hai idea di cosa scegliere acquista il 'Prato CLASSICO' realizzato con un miscuglio di:
'Festuca Arundinacea e Poa Pratense'
che praticamente è il tipo di prato a rotoli usato nella stragrande maggioranza dei casi ed è definito il "prato inglese classico".

Clicca quindi sulla tipologia di prato scelta per accedere alla scheda di ordine. In alternativa puoi utilizzare il box in alto che calcola immediatamente il costo del prato a rotoli di tipologia classica.
Dicci quanti metri quadri vuoi acquistare e dove dobbiamo consegnarlo.

Se non conosci precisamente le metrature del tuo giardini fatti aiutare dall'utility calcolatore che ti permette di calcolare in maniera semplice l'area da coprire con il prato a rotoli.

Inserisci quindi nel campo "metri quadri" il quantitativo di prato che vuoi acquistare espresso in mq.

Seleziona la la provincia ed il comune e scrivi l'indirizzo di consegna.

Fatto questo visualizzerai il costo del prato incluso di IVA e trasporto.
Conferma l'ordine.
Effettuato il pagamento ci sentiremo telefonicamente per concordare la data di consegna in base alle tue necessità.
Il prato a rotoli arriverà a casa tua in pochi giorni!