webshophun.hu

Kód: Egész kijelölése

define("XLS_BE","XLS-be mentés");

Kód: Egész kijelölése

// Ha xls kell
if(isset($_GET["action"]) && trim($_GET["action"]) == "xls_create" ){
	xlsCreate();
}

Kód: Egész kijelölése

<div style="margin: 10px; cursor:pointer;"><form name="xlsForm" method="post" action="kategoria.php?left=katalogus&center=term_exp&action=xls_create" style="margin:0px; padding:0px; font-family:Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color:#333333; margin-left:10px;">
<?php echo ARFORMA; ?>:&nbsp;<select name="arforma_id" class="inputok" style="margin: 10px 0px;">
<?php while($act = mysql_fetch_assoc($result)){
		echo '<option value="'. $act["arforma_id"] .'">'. $act["arforma"] .'</option>';
}?>
</select><br />
<input type="submit" name="xls_export" value="<?php echo XLS_BE; ?>" title="<?php echo XLS_BE; ?>" class="submit_btn" />
    </form></div>
<hr />

Kód: Egész kijelölése

<div style="margin: 10px; cursor:pointer;"><input type="button" name="xml_export" value="<?php echo XML_BE; ?>" title="<?php echo XML_BE; ?>" onClick="xmlCreate('<?php echo XML_SUCCESFUL; ?>');" class="submit_btn" /></div>.............

Kód: Egész kijelölése

//XLS eloállítása
function xlsCreate(){

$fejlec = "<table border='0'><tr style='background-color:#FF0; font-weight:bold;' ><td>". TERMEK_KOD ."</td><td>".TERMEK_NEVE . "</td><td>". BRUTTO . "</td><td>". TERMEK_LINK. "</td><td>". TERMEK_LEIRASA . "</td><td>". TERMEK_FOTO . "</td><td>". GYARTO . "</td><td>". KATEGORIA_NEV . "</td></tr>";

//Bruttó vagy nettó árformát kaptunk?
// Árforma kiolvasása
$sql = "SELECT af.forma
		FROM ". ARFORMA_TABLE. " as af 
		WHERE af.arforma_id = ". tep_db_input($_POST["arforma_id"]);
$result = mysql_query2(__LINE__, __FILE__, $sql);

	if(mysql_num_rows($result) > 0){
	$arformaArray = mysql_fetch_assoc($result); 
	
	
	if($arformaArray["forma"] == "brutto"){
	//Bruttó árak vannak
	// Olvassuk ki az adatokat
	$sql ="SELECT nl.name, a.ar, t.id, nl.description,t.image_address, g.gyarto_neve, kl.nev, t.kod
		FROM ".TERMEK_TABLE." as t 
		INNER JOIN ".TERMEK_TO_KATEGORIA_TABLE." as ttk ON ttk.termek_id = t.id
		INNER JOIN ". GYARTOK_TABLE ." as g ON t.gyarto = g.id
		INNER JOIN ". KATEGORIA_LEIRAS_TABLE." as kl ON kl.kat_id = ttk.termek_kategoria_id
		INNER JOIN ".ARAK_TABLE." as a ON t.id = a.termek_id
		LEFT JOIN ".NEV_LEIRAS_TABLE." as nl ON nl.termek_id = t.id
		WHERE t.status = 'igen' 
		AND nl.language_id= ". tep_db_input($_SESSION["admin"]["nyelv_id"]) ."
		AND a.arforma_id = 1
		GROUP BY t.id
		ORDER BY nl.name ";
	}else{
	// Az árak nettó módon vannak megadva
	// Olvassuk ki az adatokat
	$sql ="SELECT nl.name, FORMAT(((afa.szint/100)+1)*a.ar,4) as ar, t.id, nl.description,t.image_address, g.gyarto_neve, kl.nev, t.kod
		FROM ".TERMEK_TABLE." as t
		INNER JOIN ". AFA_TABLE ." as afa ON t.afa_id = afa.afa_id
		INNER JOIN ".TERMEK_TO_KATEGORIA_TABLE." as ttk ON ttk.termek_id = t.id
		INNER JOIN ". GYARTOK_TABLE ." as g ON t.gyarto = g.id
		INNER JOIN ". KATEGORIA_LEIRAS_TABLE." as kl ON kl.kat_id = ttk.termek_kategoria_id
		INNER JOIN ".ARAK_TABLE." as a ON t.id = a.termek_id
		LEFT JOIN ".NEV_LEIRAS_TABLE." as nl ON nl.termek_id = t.id
		WHERE t.status = 'igen' 
		AND nl.language_id= ". tep_db_input($_SESSION["admin"]["nyelv_id"]) ."
		AND a.arforma_id = 1
		GROUP BY t.id
		ORDER BY nl.name ";
	}
	
	$result = mysql_query2(__LINE__, __FILE__, $sql);
	while($act = mysql_fetch_assoc($result)){
	$fejlec .= '<tr><td>'. $act["kod"] .'</td><td>'. strip_tags(str_replace(array("|","&#337;","<br/>",";",'"'),array("","o","","",""),$act["name"])) .'</td><td>' .  $act["ar"] . "</td><td>". $_SESSION["admin"]["bolt_url"]."/index.php?center=uj_termek&term_id=". $act["id"] . "</td><td>". strip_tags(str_replace(array("|","&#337;","<br/>",";",'"'),array("","o","","",""),$act["description"]))  . "</td><td>". $_SESSION["admin"]["bolt_url"] ."/". $act["image_address"] . "</td><td>".$act["gyarto_neve"]. "</td><td>". $act["nev"] ."</td></tr>";
	}
	$fejlec .= '</table>';
	header('Content-type: application/x-octet-stream');   
	header('Content-disposition: attachment; filename=termekek.xls');
	echo $fejlec;
	exit;
	}
}