Exemplos de shopartikel em PHP

Exemplo n.º 1

Arquivo: shopimport_db.php Projeto: jquade/lxoffice-erp

        exit;
    }
} else {
    echo "Keine Defaultsprache im Shop eingestellt.";
    exit;
}
$Languages = array();
foreach ($Language as $Langrow) {
    if ($Langrow["SHOP"] > 0 and $Langrow["ERP"] > 0) {
        $Languages[$Langrow["ERP"]] = $Langrow["SHOP"];
    }
}
/*******************************************
* Import starten
*******************************************/
$artikel = shopartikel();
//array_keys($Languages));
echo "Artikelexport ERP -&gt; xt:Commerce (Standardsprache {$ShopdefaultLang}): " . count($artikel) . " Artikel markiert.<br>";
if ($artikel) {
    //Mit jedem Artikel in der Defaultsprache:
    foreach ($artikel as $data) {
        //Kategorie abfragen/anlegen
        $data["categories_id"] = getCategory($data["partsgroup"], $ShopdefaultLang, $Languages);
        chkartikel($data, $ShopdefaultLang, false);
    }
    foreach ($Languages as $erplang => $shoplang) {
        //Mit jeder weiteren Sprache
        $artikel = shopartikellang($erplang, $SpracheAlle);
        echo "Shopsprache: {$shoplang}<br>";
        if ($artikel) {
            foreach ($artikel as $data) {

Exemplo n.º 2

Arquivo: shopimport_db.php Projeto: roethigj/Lx-Office-Anpassungen

		exit;
	}
} else  {
	echo "Keine Defaultsprache im Shop eingestellt.";
	exit;
}

$Languages=array();
foreach ($Language as $Langrow) {
	if ($Langrow["SHOP"]>0 and $Langrow["ERP"]>0) $Languages[$Langrow["ERP"]]=$Langrow["SHOP"];
}

/*******************************************
* Import starten
*******************************************/
$artikel=shopartikel(); //array_keys($Languages));

echo "Artikelexport ERP -&gt; xt:Commerce (Standardsprache $ShopdefaultLang): ".count($artikel)." Artikel markiert.<br>";

if ($artikel) { //Mit jedem Artikel in der Defaultsprache:
	foreach ($artikel as $data) {
		//Kategorie abfragen/anlegen
		$data["categories_id"]=getCategory($data["partsgroup"],$ShopdefaultLang,$Languages);
		chkartikel($data,$ShopdefaultLang,false);
	}

	foreach ($Languages as $erplang=>$shoplang) { //Mit jeder weiteren Sprache
		$artikel=shopartikellang($erplang,$SpracheAlle);
		echo "Shopsprache: $shoplang<br>";
		if ($artikel) {
			foreach ($artikel as $data) {

Exemplo n.º 3

Arquivo: erpexport.php Projeto: jquade/lxoffice-erp

        echo "</td></tr></table><font color='red'>{$sql} : {$err}</font><br>";
    }
}
function shopartikel()
{
    global $db;
    $sql = "SELECT P.partnumber,P.description,P.unit,P.weight,t.rate,P.sellprice,P.listprice,P.priceupdate,PG.partsgroup,P.notes,P.image FROM ";
    $sql .= "parts P left join partsgroup PG on  PG.id=P.partsgroup_id ";
    $sql .= "left join chart c on c.id = P.income_accno_id ";
    $sql .= "left join tax T on T.taxkey=C.taxkey_id ";
    $sql .= "where shop = 't'";
    $rs = $db->getAll($sql, DB_FETCHMODE_ASSOC);
    return $rs;
}
if ($_POST["export"]) {
    $data = shopartikel();
    $delim = $_POST["deli"] ? $_POST["deli"] : ",";
    if (get_magic_quotes_gpc()) {
        $crln = stripslashes($_POST["crln"]);
    }
    $crln = str_replace('\\r', "\r", $crln);
    $crln = str_replace('\\n', "\n", $crln);
    $crln = str_replace('\\t', "\t", $crln);
    $encl = $_POST["encl"];
    $i = 0;
    $f = fopen($ERPdir, "w");
    if ($_POST["partnumber"]) {
        $header .= $_POST["PN"] . $delim;
    }
    if ($_POST["desctiption"]) {
        $header .= $_POST["BEZ"] . $delim;