ho un problemino con il modulo fornito da trovaprezzi
non mi calcola le spese di spedizione
Avevo pensato di risolvere con una cosa piu' semplice
impostare nello script che le spese di spedizione sono di 6 euro fisse per ogni prodotto senza che lui lo vada a calcolare.ma come posso fare?
dove devo modificare?
eccovi lo script
fatemi sapere
grazie
Codice: Seleziona tutto
<?php
// Php display_errors value
$display_errors = 1;
$script_version = "2.0.0";
// Set display errors value
ini_set('display_errors', $display_errors);
include('includes/configure.php'); // include i dati per la connessione al DB
require('includes/database_tables.php'); //include le costanti con i nomi delle tabelle del DB
$link = DbConnection(); //Inizializza la connessione al db mysql
$site_url = "http://www.xxxxxxxxx.com"; // <--- Inserire qui l'URL del sito SENZA SLASH FINALE es: "http://www.undominio.com/catalog"
$language_id = "6"; // <--- Inserire qui l'ID della lingua utilizzata
$reftracking = ""; // <---- Inserire qui la string per il tracking, se utilizzata. Ad esempio: "&refid=5" oppre "&track=acme"
/*********************************** NON MODIFICARE ALTRO ***************************************/
$shippingmethods = getshippingmodes($link); // Ottiene una sola volta i metodi di spedizione diponibili da db
$shippingdetails = getshippingsdetails($shippingmethods,$link); // Ottiene le spese di spedizione relative ai metodi di spedizione disponibili
global $rescount;
//$rescount=0;
$listing_sql = "
SELECT
p.products_id,
p.products_image,
p.manufacturers_id,
p.products_price,
p.products_weight,
p.products_tax_class_id AS tax_id,
pd.products_name,
pd.products_description,
p2c.categories_id,
c.parent_id,
c.categories_id,
cd.categories_name,
m.manufacturers_id,
IF(p.manufacturers_id = 0, NULL, m.manufacturers_name) AS marca,
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,
IF(p.products_quantity > 0, 'disponibile','non disponibile') as availability,
IF(p.products_model = NULL, -1, p.products_model) as codprod
FROM
".TABLE_PRODUCTS." p
LEFT JOIN ".TABLE_SPECIALS." s ON p.products_id = s.products_id
LEFT JOIN ".TABLE_MANUFACTURERS." m ON p.manufacturers_id = m.manufacturers_id,
".TABLE_PRODUCTS_DESCRIPTION." pd,
".TABLE_PRODUCTS_TO_CATEGORIES." p2c,
".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd
WHERE
p2c.categories_id = c.categories_id AND
c.categories_id = cd.categories_id AND
p.products_id = p2c.products_id AND
pd.products_id = p2c.products_id AND
p.products_status = '1' AND
pd.language_id = '$language_id' AND
cd.language_id = '$language_id'
ORDER BY final_price DESC
";
if($result = mysql_query( $listing_sql, $link ) )
{
if (isset($_GET['debug']))
{
if($_GET['debug']=="debugme")
{
echo "<p><b>Version: </b>" .$script_version . "</p>";
echo "<b>Query eseguita correttamente:</b> </br>" .$listing_sql . "</br></br>";
echo "<p><b>Shipping active methods : </b>";
ShowShippingActiveMethods($shippingmethods);
echo " </p>";
echo "<p><b>Shipping details : </b>";
ShowShippingDetails($shippingmethods, $shippingdetails);
echo " </p>";
}
}
$filestring = "";
while($row=mysql_fetch_array($result))
{
$descrizionehtml=$row["products_description"];
$descrizionehtml=strip_tags($descrizionehtml);
$descrizionehtml=substr($descrizionehtml,0,255);
$descrizione1 = CleanHtml($descrizionehtml);
$cat_arr = CatString($row["categories_id"],$language_id,$link);
$cat_arr = array_reverse($cat_arr);
$cat_list = implode(";",$cat_arr);
$final_price = Tasse($row['tax_id'], $row['final_price'],$link);
if (isset($_GET['noshipping']))
{
if ($_GET['noshipping'] == '1')
{
$shippingprice = -1;
}
else
{
$shippingprice = getshippingprice($row["products_weight"],$row["products_price"],$shippingmethods,$shippingdetails,$link);
}
}
else
{
$shippingprice = getshippingprice($row["products_weight"],$row["products_price"],$shippingmethods,$shippingdetails,$link);
}
$filestring=$row["products_id"]."|".$row["products_name"]."|".$site_url."/images/".$row["products_image"]."|".$site_url."/product_info.php?products_id=".$row["products_id"].$reftracking."|".$cat_list."|".$final_price."|".$descrizione1."|".$row["marca"]."|" . $row["availability"] ."|" . $shippingprice ."|" . $row["codprod"] ."<endrecord>\r\n";
if (isset($_GET['debug']))
{
if($_GET['debug']=="debugme")
{
echo "</br> <b>Prezzi ProductId:</b> " .$row["products_id"] . " <b>ProductName:</b> " .$row["products_name"] . " <b>product_price:</b> " .$row["products_price"] . " <b>final_price:</b> " .$row['final_price'] . " <b>price_with_tax:</b> " .$final_price;
echo "</br>";
}
}
echo $filestring;
$rescount += 1;// $rescount++;
}
}
else
{
echo "Errore nell'esecuzione della query:<br>".$listing_sql."<br>".mysql_errno().": ".mysql_error()."<br>";
}
if (isset($_GET['debug']))
{
if($_GET['debug']=="debugme")
{
// If debug is enabled then show languages
echo "<p><b>Languages:</b></p>";
ShowAvailableLanguages($link);
echo "<p><b>Countries:</b></p>";
ShowAvailableCountries($link);
echo "<p><b>Categories id:</b></p>";
ShowAvailableCategories($link);
echo "<p><b>Num risultati query:</b>$rescount</p>";
//echo "<pre>$listing_sql</pre>";
$countres = TpDebug($language_id,$link);
echo "<p><b>Num prodotti attivi:</b>".$countres[0]."</p>";
echo "<p><b>Num prodotti inattivi:</b>".$countres[1]."</p>";
}
}
mysql_close();
/******************************** CONNESSIONE AL DATABASE ***************************************/
/* Ritorna la risorsa di connessione $link */
function DbConnection(){ //
$link = mysql_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD) //
or die( "Errore nella connessione al database ".mysql_errno().": ".mysql_error() ); //
mysql_select_db(DB_DATABASE) //
or die( "Errore nella selezione del database ".mysql_errno().": ".mysql_error() ); //
return $link; //
} //
/************************************************************************************************/
/******************************* CATEGORIE ******************************************************/
function CatString($cat,$language_id,$link) {
$list = array();
do{
$catsql = "SELECT c.categories_id, c.parent_id, cd.categories_name FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd WHERE c.categories_id = cd.categories_id AND c.categories_id = $cat and cd.language_id=$language_id";
if($res = mysql_query($catsql, $link ) )
{
$row = mysql_fetch_row($res);
$cat = $row[1];
$parent = $row[1];
array_push($list,$row[2]);
}
}while($parent != 0);
return $list;
}
/******************************* CALCOLO IVA / TASSE ********************************************/
function Tasse($tax_id, $price,$link)
{
if ($tax_id == 0)
{
$final_price = $price;
}
else
{
$taxsql = "SELECT tax_rate FROM ".TABLE_TAX_RATES." WHERE tax_rates_id = $tax_id";
if ($res = mysql_query($taxsql,$link ) ){
$row = mysql_fetch_row($res);
$rate = $row[0];
$tax = ($price / 100) * $rate;
$final_price = $price + $tax;
}
}
return $final_price;
}
/******************************* METODI DI SPEDIZIONE *************************************/
function getshippingmodes($link){
$metodiattivi = array(); // Array contenente i metodi di spedizione
$methodsql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_INSTALLED\""; // Ottiene i moduli installati per le spese di spedizione //
if($res = mysql_query($methodsql, $link ) ){
$row = mysql_fetch_row($res);
}
$freeshippingsql = "SELECT configuration_value FROM " . TABLE_CONFIGURATION. " WHERE configuration_key=\"MODULE_ORDER_TOTAL_INSTALLED\""; // Ottiene i metodi di visualizzazione del totale per determinare se è attivo il free shipping
if($res = mysql_query($freeshippingsql, $link ) ){
$rowfree = mysql_fetch_row($res);
}
if ( strpos($rowfree[0],"ot_shipping.php") === false)
{
}
else
{
$freeshippingactivesql = "SELECT configuration_value FROM " . TABLE_CONFIGURATION . " WHERE configuration_key=\"MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING\""; // Verifica che sia attivo il free shipping
if($res = mysql_query($freeshippingactivesql , $link ) )
{
$rowfreeactive = mysql_fetch_row($res);
}
if ($rowfreeactive[0] == "true")
{
array_push($metodiattivi,"free"); // E' Stata configurata la spedizione gratuita se l'ordine supera un certo prezzo
}
}
$metodi = explode(";",$row[0]); // Ottiene i metodi di pagamento
foreach ($metodi as $metodo){ // Calcolo le spese di spedizione in base ai metodi installati
switch ($metodo){
case "flat.php" : // Spese di spedizione flat
$activesql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_FLAT_STATUS\"";
if($res = mysql_query($activesql, $link ) ){
$row = mysql_fetch_row($res);
if ($row[0] == "True"){
array_push($metodiattivi,"flat");
}
}
break;
case "item.php" : // spese di spedizione in base al numero di oggetti
$activesql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_ITEM_STATUS\"";
if($res = mysql_query($activesql, $link ) ){
$row = mysql_fetch_row($res);
if ($row[0] == "True"){
array_push($metodiattivi,"item");
}
}
break;
case "table.php" : //Spese di spedizione in base al costo o in base al peso
$activesql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_TABLE_STATUS\"";
if($res = mysql_query($activesql, $link ) ){
$row = mysql_fetch_row($res);
if ($row[0] == "True"){
array_push($metodiattivi,"table");
}
}
break;
case "zones.php" : // Spese di spedizione in base alla destinazione e al peso
$activesql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_ZONES_STATUS\"";
if($res = mysql_query($activesql, $link ) ){
$row = mysql_fetch_row($res);
if ($row[0] == "True"){
array_push($metodiattivi,"zones");
}
}
break;
default : // Spese di spedizione calcolate con un modulo custom
array_push($metodiattivi,"custom");
}
}
return $metodiattivi;
}
/************** OTTIENE I PREZZI RELATIVI AI METODI DI SPEDIZIONE ATTIVI ******************************/
function getshippingsdetails($shippings_methods,$link){
$shippingsdetails = array();
foreach ($shippings_methods as $metodo){
switch ($metodo){
case "flat" : //Spese di spedizione flat
$costsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_FLAT_COST\"";
$handlingsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_FLAT_HANDLING\"";
if($res = mysql_query($costsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["flat"]["cost"] = $row[0];
}
if($res = mysql_query($handlingsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["flat"]["handling"] = $row[0];
}
break;
case "item" : // Spese di spedizione in base al numero di oggetti
$costsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_ITEM_COST\"";
$handlingsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_ITEM_HANDLING\"";
if($res = mysql_query($costsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["item"]["cost"] = $row[0];
}
if($res = mysql_query($handlingsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["item"]["handling"] = $row[0];
}
break;
case "table" : // Spese di spedizione in base al prezzo o al peso
$costsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_TABLE_COST\"";
$handlingsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_TABLE_HANDLING\"";
$tablemodesql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_TABLE_MODE\"";
$boxweightsql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"SHIPPING_BOX_WEIGHT\"";
if($res = mysql_query($tablemodesql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["table"]["mode"] = $row[0];
}
if($res = mysql_query($costsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["table"]["cost"] = $row[0];
}
if($res = mysql_query($handlingsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["table"]["handling"] = $row[0];
}
if ($shippingdetails["table"]["mode"] == "weight"){ // Se il metodo di calcolo per le spese di spedizione e' in base al peso ottengo il peso dell'imballo
if($res = mysql_query($boxweightsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["table"]["boxweight"] = $row[0];
}
}
break;
case "zones" : // Spese di spedizione in base alla zona e al peso
$costsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_ZONES_COST_1\"";
$handlingsql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_SHIPPING_ZONES_HANDLING_1\"";
$boxweightsql = "SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"SHIPPING_BOX_WEIGHT\"";
if($res = mysql_query($costsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["zones"]["cost"] = $row[0];
}
if($res = mysql_query($handlingsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["zones"]["handling"] = $row[0];
}
if($res = mysql_query($boxweightsql, $link ) ){
$row = mysql_fetch_row($res);
$shippingdetails["zones"]["boxweight"] = $row[0];
}
break;
case "free": // Spedizione gratuita nel caso il prezzo superi una certa soglia
$costosql = "SELECT configuration_VALUE FROM ".TABLE_CONFIGURATION." WHERE configuration_key=\"MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER\"";
if ($res = mysql_query($costosql,$link ) )
{
$row = mysql_fetch_row($res);
$shippingdetails["free"]["limit"] = $row[0];
}
break;
}
}
return $shippingdetails;
}
/******************* OTTIENE LE SPESE DI SPEDIZIONE PER IL PRODOTTO ****************************/
function getshippingprice($product_weight='',$product_price='',$shippingmethods,$shippingdetails,$link)
{
$costo = array(); // Array contenente i costi calcolati in base ai metodi
foreach ($shippingmethods as $metodo){
switch ($metodo)
{
case "flat" : // Spese di spedizione "flat"
array_push($costo,$shippingdetails["flat"]["cost"] + $shippingdetails["flat"]["handling"]);
break;
case "item" : // Spese di spedizione in base al numero di oggetti
array_push($costo,$shippingdetails["item"]["cost"] + $shippingdetails["item"]["handling"] );
break;
case "table" : // Spese di spedizione calcolate in base al prezzo o al peso
if ($shippingdetails["table"]["mode"] == "weight"){ // Spese di spedizione in base al peso
$totale = $product_weight + $shippingdetails["table"]["boxweight"];
}
else{ // Spese di spedizione in base al prezzo
$totale = $product_price;
}
$table_cost = split("[:,]" ,$shippingdetails["table"]["cost"]);
$size = sizeof($table_cost);
for ($i=0, $n=$size; $i<$n; $i+=2) { // Trova la classe di peso o di prezzo e calcola le spese
if ($totale <= $table_cost[$i]) {
$spesa = $table_cost[$i+1];
break;
}
}
array_push($costo,$spesa + $shippingdetails["table"]["handling"]);
break;
case "zones" : // Spese di spedizione in base al peso e alla zona di spedizione, viene considerata la zona piu' vicina
$totale = $product_weight + $shippingdetails["zones"]["boxweight"];
$table_cost = split("[:,]" ,$shippingdetails["zones"]["cost"]);
$size = sizeof($table_cost);
for ($i=0, $n=$size; $i<$n; $i+=2) { // Trova la classe di peso e calcola il prezzo
if ($totale <= $table_cost[$i]) {
$spesa = $table_cost[$i+1];
break;
}
}
array_push($costo,$spesa + $shippingdetails["zones"]["handling"]);
break;
case "free" : // Spese di spedizione gratuite oltre ad un certo prezzo
if ($product_price > $shippingdetails["free"]["limit"])
array_push($costo,0);
break;
case "custom" : // Modulo per il calcolo delle spese personalizzato
array_push($costo,-1);
break;
}
}
sort($costo); // Ordino i costi ottenendo cosi' quello piu' basso
return ($costo[0]);
}
/******************************* FORMATTAZIONE STRINGA DESCRIZIONE ******************************/
function CleanHtml($string)
{
$string = strip_tags($string); //elimina i tags html
$string = substr($string,0,255); //taglia la stringa fino a max 255 caratteri
$search = array ("'<script[^>]*?>.*?</script>'si", // Rimozione del javascript
"'<[\/\!]*?[^<>]*?>'si", // Rimozione dei tag HTML
"'([\r\n])[\s]+'", // Rimozione degli spazi bianchi
"'([\r])+'", // Rimozione degli spazi bianchi
"'([\n])+'", // Rimozione degli spazi bianchi
"'&(quot|#34);'i", // Sostituzione delle entità HTML
"'&(amp|#38);'i",
"'&(lt|#60);'i",
"'&(gt|#62);'i",
"'&(nbsp|#160);'i",
"'&(iexcl|#161);'i",
"'&(cent|#162);'i",
"'&(pound|#163);'i",
"'&(copy|#169);'i",
"'&#(\d+);'e"); // Valuta come codice PHP
$replace = array ("",
"",
"",
"",
"",
"",
"",
"",
"",
"",
chr(161),
chr(162),
chr(163),
chr(169),
"chr(\\1)");
$descrizione1 = preg_replace($search, $replace, $string);
return $descrizione1;
}
function TpDebug($language_id,$link)
{
$results = array();
$sql1 = "SELECT COUNT(products_id) FROM ".TABLE_PRODUCTS." WHERE products_status = 1";
$sql2 = "SELECT COUNT(products_id) FROM ".TABLE_PRODUCTS." WHERE products_status = 0";
$sql3 = "SELECT COUNT(p.products_id) FROM
".TABLE_PRODUCTS." p,
".TABLE_PRODUCTS_DESCRIPTION." pd,
".TABLE_PRODUCTS_TO_CATEGORIES." p2c,
".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd
LEFT JOIN ".TABLE_SPECIALS." s ON p.products_id = pd.products_id
LEFT JOIN ".TABLE_MANUFACTURERS." m ON p.manufacturers_id = m.manufacturers_id
WHERE
p2c.categories_id = c.categories_id AND
c.categories_id = cd.categories_id AND
p.products_id = p2c.products_id AND
pd.products_id = p2c.products_id AND
p.products_status = '1' AND
pd.language_id = '$language_id' AND
cd.language_id = '$language_id'
";
if($result = mysql_query( $sql1, $link ) )
{
$row1=mysql_fetch_row($result);
$results[0] = $row1[0]; // Retrieve the enabled products ( with products_status = 1 )
}
else
{
$results[0] = "<p>Huston, we got a problem: <b>".mysql_errno()."</b> - ".mysql_error();
}
//echo "<p>Risultati Query:$rescount</p>";
if($result = mysql_query( $sql2, $link ) )
{
$row2=mysql_fetch_row($result);
$results[1] = $row2[0]; // Retrieve the disabled products ( with products_status = 0 )
}
else
{
$results[1] = "<p>Huston, we got a problem: <b>".mysql_errno()."</b> - ".mysql_error();
}
return $results;
}
function ShowAvailableLanguages($link)
{
if (isset($_GET['debug']))
{
if($_GET['debug']=="debugme")
{
$results = array();
$sql_select = "SELECT * FROM " . TABLE_LANGUAGES;
if($result = mysql_query( $sql_select, $link ) )
{
while($row=mysql_fetch_array($result))
{
echo $row["name"] . " : " . $row["code"] . " - language_id: " . $row["languages_id"] . "</br>";
}
}
}
}
}
function ShowAvailableCountries($link)
{
if (isset($_GET['debug']))
{
if($_GET['debug']=="debugme")
{
$results = array();
$sql_select = "SELECT * FROM " . TABLE_COUNTRIES;
if($result = mysql_query( $sql_select, $link ) )
{
while($row=mysql_fetch_array($result))
{
echo $row["countries_name"] . " : " . $row["countries_iso_code_2"] . " - country_id: " . $row["countries_id"] . "</br>";
}
}
}
}
}
function ShowAvailableCategories($link)
{
if (isset($_GET['debug']))
{
if($_GET['debug']=="debugme")
{
$results = array();
$sql_select = "select distinct(categories_id) from " . TABLE_PRODUCTS_TO_CATEGORIES . " order by categories_id";
if($result = mysql_query( $sql_select, $link ) )
{
while($row=mysql_fetch_array($result))
{
echo $row["categories_id"] . ";";
}
}
}
}
}
function ShowShippingActiveMethods($shippingmethods)
{
$methodsCounter = 0;
foreach($shippingmethods as $method)
{
$methodsCounter++;
echo $method;
if ( $methodsCounter < (count($shippingmethods)) )
{
echo " |";
}
}
}
function ShowShippingDetails($shippingmethods, $shippingdetails)
{
echo "<table border=1>";
echo "<tr>";
echo "<td> Type </td> <td> Cost </td> <td> Handling </td>";
echo "</tr>";
foreach($shippingmethods as $method)
{
echo "<tr>";
echo "<td>" . $method . "</td>";
echo "<td> " . $shippingdetails[$method]["cost"] . "</td>";
echo "<td> " . $shippingdetails[$method]["handling"] . "</td>";
echo "<tr>";
}
echo "</table>";
}
?>
