Staffelpreise und Connector

[Modulexpert]

Moin!

Muß ich irgendwas noch aktivieren damit die Staffelpreise übernommen werden ? Derzeit werden Sie nicht übernommen

 

[Andreas Grambow]

Unterstützt ZenCard überhaupt Staffelpreise in der Standartinstallation?

 

[Modulexpert]

ab 1.3 standardmäßig drin.. leider ein wenig zu umständlich gemacht.

Habs mir persönlich schon so umgeschrieben das es fixer geht, aber übers Jawi wärs noch fixer(da hab ich die Preise schon alle drin hehe)

Wir erstellt man Staffelpreise mit Zen-Cart ?

Admin -> Artikelpreismanager

Dann Artikel auswählen

-> bearbeiten klicken

-> leere Rabatte hinzufügen

-> dann eingeben

->aktualisiren klicken

fertig


Ich sags ja umständlich gemacht (Mußte gerade selber gucken hehe Bei mir sinds nur 2 Schritte)

 

[Andreas Grambow]

Dann wirst du dir den Connector umschreiben müssen.

Schau dir dazu den von XTC an und suche dir die Tabellenfelder raus, in die die Staffelpreise geschrieben werden.

 

[Modulexpert]

So und nun für die anderen.

Da es ja keine Händlerpreise im Zen Card gibt, gelten nur die Kundenstaffelpreise.

Suche in der Datei dbeS/Artikel.php :

function insertPreise($products_id)
{
	/*
        $personalOfferTable = "personal_offers_by_customers_status_";
	$endKunden_arr = explode(";",$GLOBALS['einstellungen']->mappingEndkunde);
	foreach ($endKunden_arr as $customers_status_id)
	{
		if ($customers_status_id>=0 && strlen($customers_status_id)>0)
		{
			$table = $personalOfferTable.$customers_status_id;
			eS_execute_query("delete from $table where products_id=".$products_id);
			eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,1,".floatval($_POST["ArtikelVKNetto"]).")");
			if (intval($_POST["PAnz1"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["PAnz1"]).",".floatval($_POST["PPreis1"]).")");
			if (intval($_POST["PAnz2"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["PAnz2"]).",".floatval($_POST["PPreis2"]).")");
			if (intval($_POST["PAnz3"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["PAnz3"]).",".floatval($_POST["PPreis3"]).")");
			if (intval($_POST["PAnz4"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["PAnz4"]).",".floatval($_POST["PPreis4"]).")");
			if (intval($_POST["PAnz5"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["PAnz5"]).",".floatval($_POST["PPreis5"]).")");
		}
	}
	$haendlerKunden_arr = explode(";",$GLOBALS['einstellungen']->mappingHaendlerkunde);
	foreach ($haendlerKunden_arr as $customers_status_id)
	{
		if ($customers_status_id>=0 && strlen($customers_status_id)>0)
		{
			$table = $personalOfferTable.$customers_status_id;
			eS_execute_query("delete from $table where products_id=".$products_id);
			eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,1,".floatval($_POST["ArtikelVKHaendlerNetto"]).")");
			if (intval($_POST["HAnz1"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz1"]).",".floatval($_POST["HPreis1"]).")");
			if (intval($_POST["HAnz2"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz2"]).",".floatval($_POST["HPreis2"]).")");
			if (intval($_POST["HAnz3"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz3"]).",".floatval($_POST["HPreis3"]).")");
			if (intval($_POST["HAnz4"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz4"]).",".floatval($_POST["HPreis4"]).")");
			if (intval($_POST["HAnz5"])>0)
				eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz5"]).",".floatval($_POST["HPreis5"]).")");
		}
	}
       */
}

ersetze mit :

function insertPreise($products_id)
{
 	
	$personalOfferTable = DB_PREFIX . "products_discount_quantity";
	//$endKunden_arr = explode(";",$GLOBALS['einstellungen']->mappingEndkunde);
//	foreach ($endKunden_arr as $customers_status_id)
//	{
		$table = $personalOfferTable;
		eS_execute_query("delete from $table where products_id=".$products_id);
		eS_execute_query("update ".DB_PREFIX."products set products_discount_type='2' where products_id=".$products_id);
		//eS_execute_query("insert into $table (products_id, discount_qty, discount_price) values ($products_id,1,".floatval($_POST["ArtikelVKNetto"]).")");
		if (intval($_POST["PAnz1"])>0)
			eS_execute_query("insert into $table (discount_id, products_id, discount_qty, discount_price) values ('1',".$products_id.",".intval($_POST["PAnz1"]).",".floatval($_POST["PPreis1"]).")");
		if (intval($_POST["PAnz2"])>0)
			eS_execute_query("insert into $table (discount_id, products_id, discount_qty, discount_price) values ('2',".$products_id.",".intval($_POST["PAnz2"]).",".floatval($_POST["PPreis2"]).")");
		if (intval($_POST["PAnz3"])>0)
			eS_execute_query("insert into $table (discount_id, products_id, discount_qty, discount_price) values ('3',".$products_id.",".intval($_POST["PAnz3"]).",".floatval($_POST["PPreis3"]).")");
		if (intval($_POST["PAnz4"])>0)
			eS_execute_query("insert into $table (discount_id, products_id, discount_qty, discount_price) values ('4',".$products_id.",".intval($_POST["PAnz4"]).",".floatval($_POST["PPreis4"]).")");
		if (intval($_POST["PAnz5"])>0)
			eS_execute_query("insert into $table (discount_id, products_id, discount_qty, discount_price) values ('5',".$products_id.",".intval($_POST["PAnz5"]).",".floatval($_POST["PPreis5"]).")");
//	}
	/*
	$haendlerKunden_arr = explode(";",$GLOBALS['einstellungen']->mappingHaendlerkunde);
	foreach ($haendlerKunden_arr as $customers_status_id)
	{
		$table = $personalOfferTable.$customers_status_id;
		eS_execute_query("delete from $table where products_id=".$products_id);
		eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,1,".floatval($_POST["ArtikelVKHaendlerNetto"]).")");
		if (intval($_POST["HAnz1"])>0)
			eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz1"]).",".floatval($_POST["HPreis1"]).")");
		if (intval($_POST["HAnz2"])>0)
			eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz2"]).",".floatval($_POST["HPreis2"]).")");
		if (intval($_POST["HAnz3"])>0)
			eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz3"]).",".floatval($_POST["HPreis3"]).")");
		if (intval($_POST["HAnz4"])>0)
			eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz4"]).",".floatval($_POST["HPreis4"]).")");
		if (intval($_POST["HAnz5"])>0)
			eS_execute_query("insert into $table (products_id, quantity, personal_offer) values ($products_id,".intval($_POST["HAnz5"]).",".floatval($_POST["HPreis5"]).")");
	}
	*/
}

Getestet mit Zencart V1.3.7
http://schlemmerbude.com/index.php?main_page=product_info&cPath=116_141&products_id=1985

 

[Andreas Grambow]

freut mich wenn du das hingekriegt hast, vieleicht nehmen Thomas und Janusch diese Änderung ja in den nächsten Connector auf.

 

[Modulexpert]

War einfach, hatte ich schnell durchgeblickt , einfache und gut übersichtliche Programmierung.Ich code ja selber aber nur fürs WBB http://hacks4wbb.com

Ich denke aber diese Änderung sollte mit rein, ist wichtig finde ich.