>> OFFER <<< //============================================================================== //================================================================== INIT Values $Depot= array( "O_PriceOfList" => 0, "O_PriceForSale1"=> 0); //============================================================================== function DepotCalculate(&$Offer){ //----------------------------- DepotCalculate //============================================================================== global $Depot; //------------------------------------------------------------------------------ $Depot['O_PriceOfList' ] += $Offer['O_PriceOfList' ] * $Offer['O_Depot']; $Depot['O_PriceForSale1'] += $Offer['O_PriceForSale1'] * $Offer['O_Depot']; } //----------------------------------------------------- DepotCalculate **END** //============================================================================== function DepotTotals(){ //------------------------------------------ DepotTotals //============================================================================== global $RP, $Depot; //------------------------------------------------------------------------------ switch ($RP['l']): case "de": $w1= "Lager-Listenpreis"; $w2= "Lager-Verkaufspreis"; $w3= number_format($Depot['O_PriceOfList' ],2,',','.'); $w4= number_format($Depot['O_PriceForSale1'],2,',','.'); break; default : $w1= "Depot-Price of List"; $w2= "Depot-Price for Sale"; $w3= number_format($Depot['O_PriceOfList' ],2,'.',','); $w4= number_format($Depot['O_PriceForSale1'],2,'.',','); endswitch; //------------------------------------------------------------------------------ return("
" . "$w1 $w3 ... " . "$w2 $w4" . "
"); } //-------------------------------------------------------- DepotTotals **END** //============================================================================== function OfferInit(&$pARRAY){ //-------------------------------------- OfferInit //============================================================================== global $SysHome; //------------------------------------------------------------------------------ $pARRAY['O_SortField' ]= ""; $pARRAY['O_PicURL' ]= ""; $pARRAY['O_PicBorder' ]= 0; $pARRAY['O_PicPos' ]= $SysHome['H_O_PicPos']; $pARRAY['O_Type' ]= $SysHome['H_O_Type']; $pARRAY['O_ShowHead' ]= "Y"; $pARRAY['O_ShowPosting' ]= $SysHome['H_O_ShowPosting']; $pARRAY['O_ShowInNewslist' ]= "Y"; $pARRAY['O_ItemGroup' ]= ""; $pARRAY['O_ItemNr' ]= ""; $pARRAY['O_Depot' ]= 1; $pARRAY['O_Tax' ]= 20; $pARRAY['O_PriceOfList' ]= "0.00"; $pARRAY['O_PriceForSale1' ]= "0.00"; $pARRAY['O_PriceForSale2' ]= "0.00"; $pARRAY['O_PriceForSale3' ]= "0.00"; $pARRAY['O_PriceForSale4' ]= "0.00"; $pARRAY['O_PriceForSale5' ]= "0.00"; $pARRAY['O_Key1' ]= ""; $pARRAY['O_Key2' ]= ""; $pARRAY['O_Key3' ]= ""; $pARRAY['O_Cat1' ]= 0; $pARRAY['O_Cat2' ]= 0; $pARRAY['O_Cat3' ]= 0; $pARRAY['O_A_ID_Distributor']= ""; $pARRAY['O_A_ID_Producer' ]= ""; $pARRAY['O_Hits' ]= 0; } //---------------------------------------------------------- OfferInit **END** //============================================================================== function OfferLangInit(&$pARRAY){//------------------------------- OfferLangInit //============================================================================== global $RP, $SysHome; //------------------------------------------------------------------------------ $pARRAY['OL_O_ID' ]= $RP['ofr']; $pARRAY['OL_Lng_Code']= $RP['idl']; $pARRAY['OL_ValiDate']= ""; $pARRAY['OL_ExpDate' ]= ""; $pARRAY['OL_Status' ]= "4"; $pARRAY['OL_Subtitle']= ""; $pARRAY['OL_Text' ]= ""; $pARRAY['OL_InsDT' ]= date("Y-m-d H:i:s"); $pARRAY['OL_InsBY' ]= $_SESSION['USER']; //------------------------------------------------------------------------------ if($SysHome['H_I_Status'] == "N") $pARRAY['OL_Status'] = "0"; } //------------------------------------------------------ OfferLangInit **END** //============================================================================== function OfferRow($pBY,$pL,$pOFR,&$rt,&$nr){ //------------------------ OfferRow //============================================================================== // $pL = '' ... Returns Offer with all Translations ! //============================================================================== global $GV, $RP; $ItsMe= "$pBY
calling _offer.php - OfferRow"; //------------------------------------------------------------------------------ $sql = "SELECT sc_offer.*, sc_offer_lang.* " . "FROM (sc_offer " . " INNER JOIN sc_offer_lang ON O_ID = OL_O_ID) " . "WHERE O_W_ID = " . $RP['p'] . " " ; if ($pOFR != 0) $sql .="AND sc_offer.O_ID = $pOFR "; if ($pL."." != ".") $sql .="AND sc_offer_lang.OL_Lng_Code = '$pL' "; if (! $_SESSION['LOGIN']) $sql .="AND OL_Status = '0' "; //------------------------------------------------------------- Archive YES / NO if (! $_SESSION['LOGIN'] and $RP['arc'] != "x") $sql .="AND (OL_ValiDate = '' OR " . " OL_ValiDate IS NULL OR " . " OL_ValiDate <= '" . date("Y-m-d") . "') " . "AND (OL_ExpDate = '' OR " . " OL_ExpDate IS NULL OR " . " OL_ExpDate > '" . date("Y-m-d") . "') " ; $sql.="ORDER BY OL_Lng_Code "; //-------------------------------------------------------------------- sc_SELECT sc_SELECT($ItsMe,'CheckNo',$sql,$rt,$nr); } //--------------------------------------------------------- OfferRow ***END*** //============================================================================== function OfferSet($pBY,$pSEC,$pL,$pTYPE,&$rt,&$nr){ //----------------- OfferSet //============================================================================== global $GV, $RP, $SysFolder, $SysHome; $ItsMe = "$pBY
calling _offer.php - OfferSet"; $Condition= ""; //---------------------------------------------------------------------- Archive if ($RP['arc'] == "x"): $Condition .="AND NOT((OL_ValiDate = '' OR " . " OL_ValiDate IS NULL OR " . " OL_ValiDate <= '" . date("Y-m-d") . "') " . " AND " . " (OL_ExpDate = '' OR " . " OL_ExpDate IS NULL OR " . " OL_ExpDate > '" . date("Y-m-d") . "')) " ; else: //----------------------------------------------------------------- Actual $Condition .="AND (OL_ValiDate = '' OR " . " OL_ValiDate IS NULL OR " . " OL_ValiDate <= '" . date("Y-m-d") . "') " . "AND (OL_ExpDate = '' OR " . " OL_ExpDate IS NULL OR " . " OL_ExpDate > '" . date("Y-m-d") . "') " ; endif; //-------------------------------------------------------------------- OL_Status if (! $_SESSION['LOGIN']) $Condition .= "AND OL_Status = '0' "; //===================================================================== for NAVI if ($pTYPE == "NAVI"): $sql = "SELECT O_ID, OL_Lng_Code " . "FROM ((sc_index " . " INNER JOIN sc_offer ON X_Child_ID = O_ID) " . " INNER JOIN sc_offer_lang ON OL_O_ID = O_ID) " . "WHERE X_Parent_F_ID = $pSEC " . "AND O_W_ID = " . $RP['p'] . " " . "AND OL_Lng_Code = '$pL' " . "AND X_W_ID = " . $RP['p'] . " " . "AND X_Child_Type = 'O' " . $Condition ; else: //=============================================================== for LIST //----------------------------------------------------------- actual Language $sql = "SELECT '1' AS Type, sc_offer.*, sc_offer_lang.* " . "FROM ((sc_index " . " INNER JOIN sc_offer ON X_Child_ID = O_ID) " . " INNER JOIN sc_offer_lang ON OL_O_ID = O_ID) " . "WHERE X_Parent_F_ID = $pSEC " . "AND O_W_ID = " . $RP['p'] . " " . "AND OL_Lng_Code = '$pL' " . "AND X_W_ID = " . $RP['p'] . " " . "AND X_Child_Type = 'O' " . $Condition ; //----------------------------------------------------------- other Languages $sql .="UNION " . "SELECT '2' AS Type, sc_offer.*, sc_offer_lang.* " . "FROM ((sc_index " . " INNER JOIN sc_offer ON X_Child_ID = O_ID) " . " INNER JOIN sc_offer_lang ON OL_O_ID = O_ID) " . "WHERE X_Parent_F_ID = $pSEC " . "AND O_W_ID = " . $RP['p'] . " " . "AND OL_Lng_Code <> '$pL' " . "AND X_W_ID = " . $RP['p'] . " " . "AND X_Child_Type = 'O' " . $Condition . "AND NOT EXISTS " . " (SELECT OL_O_ID FROM sc_offer_lang " . " WHERE OL_O_ID = O_ID " . " AND OL_Lng_Code = '$pL') " ; endif; //============================================================ prepare $SortCode // $SortCode kann nur dann �ber $_SESSION['osrt'] kommen, wenn // der Aufruf per URL erfolgte. In allen anderen F�llen wird // $SortCode direkt aus $SysFolder['F_SortFolder'] �bernommen. //------------------------------------------------------------------------------ if ($_SESSION['osrt']."." <> "."): $SortCode = $_SESSION['osrt']; else: // $SortCode = $SysFolder['F_SortFolder']; $SortCode = 1; endif; //------------------------------------------------------------------------------ switch($SortCode): case "2": //-------------------------------------------------- OfferName DESC $sql.= "ORDER BY OL_Lng_Code,O_SortField,OL_Headline,OL_Subtitle DESC "; break; case "3": //----------------------------------------------------- OfferIntKey $sql.= "ORDER BY O_ItemGroup,O_ItemNr,OL_Lng_Code,OL_Headline "; break; case "4": //------------------------------------------------ OfferIntKey DESC $sql.= "ORDER BY O_ItemGroup,O_ItemNr DESC,OL_Lng_Code,OL_Headline "; break; case "5": //--------------------------------------------------------- OfferNr $sql.= "ORDER BY O_ID,OL_Lng_Code,OL_Headline "; break; case "6": //---------------------------------------------------- OfferNr DESC $sql.= "ORDER BY O_ID DESC,OL_Lng_Code,OL_Headline "; break; case "7": //--------------------------------------------------- OL_UpdDT DESC $sql.= "ORDER BY OL_Lng_Code,OL_UpdDT DESC "; break; default : //------------------------------ unknown $SortCode or "1" = Default $sql.= "ORDER BY OL_Lng_Code,O_SortField,OL_Headline,OL_Subtitle "; endswitch; sc_SELECT($ItsMe,'CheckNo',$sql,$rt,$nr); } //--------------------------------------------------------- OfferSet ***END*** //============================================================================== function WriteOffer($pBY,&$pARRAY){ //------------------------------- WriteOffer //============================================================================== global $GV, $RP, $SysHome; $ItsMe= "$pBY
calling _offer.php - WriteOffer"; $RET = ""; //========================================================= Write Login-Headline if ($_SESSION['LOGIN'] and $SysHome['W_MultiLang'] == "Y") $RET .= OfferLanguages($ItsMe, $pARRAY['O_ID']); if ($_SESSION['LOGIN']) $RET .= OfferAdminHeader($ItsMe, $pARRAY); //======================================================================= HEADER if ($pARRAY['O_ShowHead'] == "Y"): //----------------------------------------------------------- WriteOrderBlock if ($RP['arc']."." == ".") $RET .= "
" . "" . WriteOrderBlock($ItsMe,$pARRAY) . "
" . "
"; //--------------------------------------------------------------------- Flags if ($SysHome['W_MultiLang'] == "Y"): MakeOfferFlags($ItsMe, $pARRAY['O_ID'], $pARRAY['OL_Lng_Code']); if ($GV['FlagSelect']."." != ".") $RET .= "
" . $GV['FlagSelect'] . "
"; endif; //--------------------------------------------------------------- OL_Headline $RET .= "

" . $pARRAY['OL_Headline'] . "

"; //--------------------------------------------------------------- OL_Subtitle $w1= ""; if ($SysHome['H_O_ShowItemNr'] <> "D" and $pARRAY['O_ShowItemNr'] == "Y" and $pARRAY['O_ItemGroup'] . $pARRAY['O_ItemNr']."." != "."): $w1 = "(" . $pARRAY['O_ItemGroup']; if ($pARRAY['O_ItemNr']."." != "."): if ($pARRAY['O_ItemGroup']."." != ".") $w1 .= "-"; $w1 .= $pARRAY['O_ItemNr']; endif; $w1 .= ")"; endif; if ($pARRAY['OL_Subtitle']."." != "."): if ($w1 != "") $w1 .= "  "; $w1 .= $pARRAY['OL_Subtitle']; endif; if ($w1 != "") $RET .= "

$w1

"; endif; //============================================================== Prepare Picture // O_PicPos ... "1" - before Text // "2" - aligned right // "3" - after Text // "4" - aligned left //------------------------------------------------------------------------------ $w1= ""; $w2= ""; $PicStrg= ""; if ($pARRAY['O_PicURL']."." != "."): //-------------------------- Logout-Status check if local picture is existing if ((! $_SESSION['LOGIN']) and stripos($pARRAY['O_PicURL'],"HTTP://") === FALSE and (! file_exists($pARRAY['O_PicURL']))) $pARRAY['O_PicURL']= ""; //--------------------------------------------------------------------------- if ($pARRAY['O_PicURL']."." != "."): switch($pARRAY['O_PicPos']): case "1": $w1.= "margin:2px 0px 10px 0px;text-align:center;"; break; case "2": $w1.= "margin:2px 0px 10px 10px;float:right;"; break; case "3": $w1.= "margin:10px 0px 10px 0px;text-align:center;"; break; default : $w1.= "margin:2px 10px 10px 0px;float:left;"; endswitch; $w2= "border:0;"; if ($pARRAY['O_PicBorder'] >= "1" and $pARRAY['O_PicBorder'] <= "9") $w2 = "border:solid " . $pARRAY['O_PicBorder'] . "px #AAAAAA;"; //------------------------------------------------------------------------ $PicStrg = "
" . "" . "
"; endif; endif; //============================================================= Text and Picture $RET .= "
"; //------------------------------------------------------- Picture BEFORE Text if ($pARRAY['O_PicPos'] == "1" and $PicStrg != "") $RET .= $PicStrg; //------------------------------------------------------ Picture WITHOUT Text if ($pARRAY['OL_Text']."." == "."){ if (($pARRAY['O_PicPos'] == "2" or $pARRAY['O_PicPos'] == "4") and $PicStrg != "") $RET .= $PicStrg; } else { //-------------------------------------------- Picture LEFT or RIGHT if (($pARRAY['O_PicPos'] == "2" or $pARRAY['O_PicPos'] == "4") and $PicStrg != "") $RET .= $PicStrg; //---------------------------------------------------------------- OL_Text $RET .= $pARRAY['OL_Text']; } //-------------------------------------------------------- Picture AFTER Text if ($pARRAY['O_PicPos'] == "3" and $PicStrg != "") $RET .= $PicStrg; //================================================================== Footnote $Footnote= ""; //--------------------------------------------------------------------------- switch($pARRAY['OL_Lng_Code']): case "de": $w1= "Hits"; break; default : $w1= "Hits"; endswitch; //-------------------------------------------------------------------- O_Hits if ($SysHome['H_O_ShowHits'] <> "D" and $pARRAY['O_ShowHits'] == "Y" and $pARRAY['O_Hits'] > 0): $Footnote .= "" . "" . "$w1" . "" . $pARRAY['O_Hits'] . "" . ""; endif; //--------------------------------------------------------------------------- if ($Footnote != "") $RET .= "" . "$Footnote
"; //--------------------------------------------------------------------------- $RET .= "
" . ABSATZ; //=================================================================== WriteAlloc if ($_SESSION['LOGIN']): $RET .= WriteAlloc($ItsMe,"OFR",$pARRAY['O_ID'],"","","UPDATE"); else: if ($SysHome['H_O_ShowAlloc'] == "Y" and $pARRAY['O_ShowAlloc'] == "Y") $RET .= WriteAlloc($ItsMe,"OFR",$pARRAY['O_ID'],"INTERNET","","PRINT"); endif; //======================================================================= Return return("
$RET
"); } //--------------------------------------------------------- WriteOfr ***END*** //============================================================================== function MakeOfferFlags($pBY, $pID, $pIDL) { //------------------ MakeOfferFlags //============================================================================== global $GV, $RP, $SysHome, $SysFolder; $ItsMe = "$pBY
calling _offer.php - MakeOfferFlags"; $GV['FlagSelect']= ""; //=================================================================== FlagSelect $Condition1= ""; //------------------------------------------------------------- Archive YES / NO if (! $_SESSION['LOGIN'] and $RP['arc'] != "x") $Condition1 .="AND (OL_ValiDate = '' OR " . " OL_ValiDate IS NULL OR " . " OL_ValiDate <= '" . date("Y-m-d") . "') " . "AND (OL_ExpDate = '' OR " . " OL_ExpDate IS NULL OR " . " OL_ExpDate > '" . date("Y-m-d") . "') " ; //------------------------------------------------------------------------------ $sql= "SELECT sys_lang.*, OL_Lng_Code " . "FROM ((sc_offer INNER JOIN sc_offer_lang " . " ON sc_offer.O_ID = sc_offer_lang.OL_O_ID) " . " INNER JOIN sys_lang " . " ON sys_lang.Lng_Code = sc_offer_lang.OL_Lng_Code) " . "WHERE O_ID = '$pID' " . "AND OL_O_ID = '$pID' " . "AND OL_Lng_Code <> '$pIDL' " . $Condition1 . "ORDER BY Lng_Code " ; //-------------------------------------------------------------------- sc_SELECT sc_SELECT("$ItsMe - FlagSelect",'CheckNo',$sql,$rt,$nr); $w1= ""; for ($i = 0; $i < $nr; $i++): $temp = mysqli_fetch_assoc($rt); //----------------------------------------------------------------- JumpTo $JumpTo = "listobj.php" . $GV['CgiString'] . "&idl=" . $temp['Lng_Code'] . "&ofr=$pID"; //-------------------------------------------------------------- by Selectbox if ($SysFolder['F_InfMLang'] == "S"): $w1 .= ""; else: //------------------------------------------------------------ by Flags $w2 = " " . $temp['Lng_Code'] . " "; if ($temp['Lng_Ctry_Nr']."." != ".") $w2 = sc_MakeFlagImg($ItsMe, $temp['Lng_Code']); $w1 .= "$w2"; endif; endfor; mysqli_free_result($rt); //----------------------------------------------------------- Prepare FlagSelect if($w1 != ""): if($SysFolder['F_InfMLang'] == "S"): //--------------------- ... by Selectbox $GV['FlagSelect'] = ""; else: //-------------------------------------------------------- ... by Flags $GV['FlagSelect'] = $w1; endif; endif; } //--------------------------------------------------- MakeOfferFlags ***END*** //============================================================================== function OfferLanguages($pBY,$pOFR){ //-------------------------- OfferLanguages //============================================================================== global $GV, $RP, $SysFolder, $SysHome; $ItsMe = "$pBY
calling _offer.php - OfferLanguages"; $Listing= ""; $RET = ""; sc_CheckParmNumeric($ItsMe,'pOFR',$pOFR); //============================================================ prepare $UsedLang $sql = "SELECT OL_Lng_Code FROM sc_offer " . " INNER JOIN sc_offer_lang " . " ON sc_offer.O_ID = sc_offer_lang.OL_O_ID " . "WHERE O_ID = $pOFR " . "AND O_W_ID = " . $RP['p'] . " " ; sc_SELECT($ItsMe,'CheckNo',$sql,$rt,$nr); //------------------------------------------------------------------------------ $UsedLang= ""; for ($i=1; $i<=$nr; $i++): $temp = mysqli_fetch_assoc($rt); $UsedLang .= $temp['OL_Lng_Code'] . ";"; endfor; mysqli_free_result($rt); //============================================================= prepare $UpdLink $UpdLink= "updofr2.php" . $GV['CgiString'] . "&ofr=$pOFR"; //=================================================== Write List of Translations $sql = "SELECT sys_lang.*,sc_offer_lang.* " . "FROM sc_offer_lang INNER JOIN sys_lang " . " ON sc_offer_lang.OL_Lng_Code = sys_lang.Lng_Code " . "WHERE OL_O_ID = $pOFR " . "ORDER BY Lng_" . $RP['l'] . " " ; sc_SELECT("$ItsMe - Translations",'CheckNo',$sql,$rt,$nr); //------------------------------------------------------------------------------ $NumActual= 0; for ($i = 0; $i < $nr; $i++): $temp= mysqli_fetch_assoc($rt); //--------------------------------------------------------------------------- if (($temp['OL_ValiDate']."." == "." or $temp['OL_ValiDate'] <= date("Y-m-d")) and ($temp['OL_ExpDate']."." == "." or $temp['OL_ExpDate'] > date("Y-m-d"))): $TabHeader= " class='Td_ActualHeader'"; $TabMemo = " class='Td_ActualMemo'"; $NumActual++; else: $TabHeader= " class='Td_ArchiveHeader'"; $TabMemo = " class='Td_ArchiveMemo'"; endif; //--------------------------------------------------------------------------- $Listing .= ""; //------------------------------------------------------------------- EDIT if ($_SESSION['U_Offer'] >= "2"): //--------------------------------------------------------------------- switch($RP['l']): case "de": $w1= "BEARBEITEN"; break; default : $w1= "EDIT"; endswitch; //--------------------------------------------------------------------- if ($RP['p'] == 350): $Listing .= "" . "$w1"; else: $Listing .= "" . "$w1"; endif; endif; //=============================================================== Headline $w1 = $temp['OL_Headline']; if ($temp['Lng_Code'] == $SysHome['W_StdLang']) $w1 = "" . $temp['OL_Headline'] . ""; //------------------------------------------------------------------------ $Listing .= "" . sc_MakeFlagImg($ItsMe, $temp['Lng_Code']) . "$w1" . ""; //-------------------------------------------------------------- OL_Status if($SysHome['H_I_Status'] == "Y"): switch($RP['l']): case "de": switch($temp['OL_Status']): case "0": $w1= "" . "freigegeben"; break; case "2": $w1= "" . "gesperrt"; break; case "4": $w1= "" . "in Bearbeitung"; break; endswitch; break; default: switch($temp['OL_Status']): case "0": $w1= "" . "released"; break; case "2": $w1= "" . "locked"; break; case "4": $w1= "" . "under
construction"; break; endswitch; endswitch; $Listing .= "$w1"; endif; //------------------------------------------------ OL_ValiDate, OL_ExpDate $Listing .= "" . $temp['OL_ValiDate'] . "" . "" . $temp['OL_ExpDate'] . ""; //=================================== Offer Translation - ARCHIVE / DELETE $w2 = ""; //---------------------------------------------------------------- ARCHIVE if (($temp['OL_ValiDate']."." == "." or $temp['OL_ValiDate'] <= date("Y-m-d")) and ($temp['OL_ExpDate']."." == "." or $temp['OL_ExpDate'] > date("Y-m-d"))): //--------------------------------------------------------------------- if ($_SESSION['U_Offer'] >= 4): switch($RP['l']): case "de": $w1= "ARCHIVIEREN"; break; default : $w1= "ARCHIVE"; endswitch; $w2 = "$w1"; endif; else: //----------------------------------------------------------- DELETE if (strlen($UsedLang) > 3 and $_SESSION['U_Offer'] >= 5): switch($RP['l']): case "de": $w1= "LÖSCHEN"; break; default : $w1= "DELETE"; endswitch; $w2 = "$w1"; endif; endif; //------------------------------------------------------------------------ if ($w2 <> ""): $Listing .= "$w2"; else: $Listing .= " "; endif; //------------------------------------------------------------------------ $Listing .= ""; endfor; mysqli_free_result($rt); //======================================================================= HEADER switch($RP['l']): case "de": $w1= "ANGEBOT"; $w2= "Verfügbare Übersetzungen"; break; default : $w1= "OFFER"; $w2= "Available Translations"; endswitch; //------------------------------------------------------------------------------ $RET .= "" . ""; //===================================================== Selectbox for NewLang $Condition= ""; if ($SysHome['H_ObjectLang']."." != ".") $Condition = "WHERE '" . $SysHome['H_ObjectLang'] . "' ". " LIKE CONCAT('%',Lng_Code,'%')" ; //--------------------------------------------------------------------------- $sql = "SELECT sys_lang.* FROM sys_lang " . $Condition . "ORDER BY Lng_" . $RP['l'] . " " ; sc_SELECT("$ItsMe - NewLang",'CheckNo',$sql,$rt,$nr); //--------------------------------------------------------------------------- $w1= ""; for ($i = 0; $i < $nr; $i++): $temp = mysqli_fetch_assoc($rt); if (strpos($UsedLang,$temp['Lng_Code']) === FALSE) $w1 .= ""; endfor; mysqli_free_result($rt); //--------------------------------------------------------------------------- if ($w1 != ""): //------------------------------------------------------------------------ switch($RP['l']): case "de": $w2= ""; break; default : $w2= ""; endswitch; //------------------------------------------------------------------------ $RET .= ""; endif; //--------------------------------------------------------- ValiDate, ExpDate switch($RP['l']): case "de": $w1= "Gültig VON"; $w2= "Gültig BIS"; break; default : $w1= "Valid FROM"; $w2= "Valid TO"; endswitch; //--------------------------------------------------------------------------- $RET .= "" . ""; //================================================= Complete ARCHIVE / DELETE $w2 = ""; //------------------------------------------------------------------- ARCHIVE if($NumActual > 0): if($_SESSION['U_Offer'] >= 4): switch($RP['l']): case "de": $w1= "Angebot mit allen Übersetzungen ARCHIVIEREN"; break; default : $w1= "ARCHIVE Offer with all Translations"; endswitch; $w2 = "$w1"; endif; else: //-------------------------------------------------------------- DELETE if($_SESSION['U_Offer'] >= 5): switch($RP['l']): case "de": $w1= "Angebot mit allen Übersetzungen LÖSCHEN"; break; default : $w1= "DELETE Offer with all Translations"; endswitch; $w2 = "$w1"; endif; endif; //--------------------------------------------------------------------------- if ($w2 <> ""): $RET .= ""; else: $RET .= ""; endif; //--------------------------------------------------------------------------- $RET .= "
$w1 $pOFR - $w2" . "$w1$w2$w2 
"; //=========================================================== Write TRANSLATIONS if ($Listing == ""): //--------------------------------------------------------------------------- switch($RP['l']): case "de": $w1= "Keine Übersetzungen verfügbar."; break; default : $w1= "No Translations available."; endswitch; //--------------------------------------------------------------------------- $Listing = "" . "$w1"; endif; //------------------------------------------------------------------------------ $RET .= "" . $Listing . "
"; //------------------------------------------------------------------------------ return($RET . ABSATZ); } //--------------------------------------------------- OfferLanguages ***END*** //============================================================================== function OfferAdminHeader($pBY, &$pARRAY) { //----------------- OfferAdminHeader //============================================================================== global $GV, $RP, $SysHome, $SysFolder; $ItsMe= "$pBY
calling _offer.php - OfferAdminHeader"; $RET = ""; //----------------------------------------------------------------------- Actual if (($pARRAY['OL_ValiDate']."." == "." or $pARRAY['OL_ValiDate'] <= date("Y-m-d")) and ($pARRAY['OL_ExpDate' ]."." == "." or $pARRAY['OL_ExpDate' ] > date("Y-m-d"))): $TabHeader= " class='Td_ActualHeader'"; $TabMemo = " class='Td_ActualMemo ui-widget-header'"; else: //---------------------------------------------------------------- Archive $TabHeader= " class='Td_ArchiveHeader'"; $TabMemo = " class='Td_ArchiveMemo'"; endif; //------------------------------------------------------------------------------ $RET .= ""; //---------------------------------------------------------------------- EDIT switch($RP['l']): case "de": $w1= "BEARBEITEN"; break; default : $w1= "EDIT"; endswitch; //--------------------------------------------------------------------------- if ($_SESSION['U_Offer'] >= 2): if ($RP['p'] == 350 OR $RP['p'] == 191 OR $RP['p'] == 219): $RET .= ""; else: $RET .= ""; endif; else: $RET .= ""; endif; //------------------------------------------------------------------- DETAILS $RET .= ""; //-------------------------------------------------------- actual Language if ($SysHome['W_MultiLang'] == "Y") $RET .= "" . sc_MakeFlagImg($ItsMe, $pARRAY['OL_Lng_Code']) . ""; //------------------------------------------------------------------- O_ID switch($RP['l']): case "de": $w1= "Angebot-ID"; break; default : $w1= "Offer-ID"; endswitch; //------------------------------------------------------------------------ $RET .= "" . "$w1 " . $pARRAY['O_ID'] . ""; //------------------------------------------------------------- OL_Status $StatusColor = ""; $StatusText = ""; //------------------------------------------------------------------------ switch($RP['l']): case "de": switch ($pARRAY['OL_Status']): case "0": $StatusColor="#33CC33"; $StatusText="freigegeben"; break; case "2": $StatusColor="#FF6600"; $StatusText="gesperrt"; break; case "4": $StatusColor="#FF6666"; $StatusText="in Bearbeitung"; break; endswitch; break; default : switch ($pARRAY['OL_Status']): case "0": $StatusColor="#33CC33"; $StatusText="released"; break; case "2": $StatusColor="#FF6600"; $StatusText="locked"; break; case "4": $StatusColor="#FF6666"; $StatusText="under construction"; break; endswitch; endswitch; //------------------------------------------------------------------------ if ($StatusText."." <> ".") $RET .= "Status " . "$StatusText"; //------------------------------------------------------------ O_SortField if ($pARRAY['O_SortField']."." <> ".") $RET .= "Sort " . $pARRAY['O_SortField'] . ""; //---------------------------------------------------------------- O_Depot switch($pARRAY['O_Type']): case "3": switch($RP['l']): case "de": $w= "Std."; break; default : $w= "Std."; endswitch; break; default : switch($RP['l']): case "de": $w= "Abvk."; break; default : $w= "Sale" ; endswitch; endswitch; //------------------------------------------------------------------------ $RET .= "Depot " . "$w " . $pARRAY['O_Depot'] . ""; //----------------------------------------------------------------- O_Hits if ($pARRAY['O_Hits']."." <> ".") $RET .= "Hits " . $pARRAY['O_Hits'] . ""; //------------------------------------------------------------------------ $RET .= ""; //------------------------------------------------------------------- ARCHIVE if (($pARRAY['OL_ValiDate']."." == "." or $pARRAY['OL_ValiDate'] <= date("Y-m-d")) and($pARRAY['OL_ExpDate' ]."." == "." or $pARRAY['OL_ExpDate' ] > date("Y-m-d"))): //------------------------------------------------------------------------ if ($_SESSION['U_Offer'] >= 4): //--------------------------------------------------------------------- switch ($RP['l']): case "de": $w1= "Angebot mit allen Übersetzungen ARCHIVIEREN"; break; default : $w1= "ARCHIVE Offer with all translations"; endswitch; //--------------------------------------------------------------------- $RET .= ""; else: $RET .= " "; endif; else: //-------------------------------------------------------------- DELETE if ($_SESSION['U_Offer'] >= 5): //--------------------------------------------------------------------- switch ($RP['l']): case "de": $w1= "Angebot mit allen Übersetzungen " . "LÖSCHEN"; break; default : $w1= "DELETE Offer with all translations"; endswitch; //--------------------------------------------------------------------- $RET .= ""; else: $RET .= ""; endif; endif; //================================================================= UpdSelBox $RET .= ""; //--------------------------------------------------------------------------- $RET .= "
" . "$w1" . "" . "$w1" . "" . "$w1" . "" . "" .$w1. "" . " ". UpdSelBoxNew($ItsMe, $pARRAY, "OFFER") . "
" . sc_MakeSpacer(4); //------------------------------------------------------------------------------ return($RET); } //------------------------------------------------- OfferAdminHeader ***END*** //============================================================================== function OfferListLine($pBY, &$pARRAY, $pTHUMB){ //--------------- OfferListLine //============================================================================== global $GV, $RP, $SysHome, $SysFolder; $ItsMe= "$pBY
calling _offer.php - OfferListLine"; $RET = ""; $GV['FlagSelect']= ""; //------------------------------------------------------------------ INIT Values if (! isset($pARRAY['Type'])) $pARRAY['Type'] = ""; //------------------------------------------------------------------------------ $w1= "default.php" . $GV['CgiString'] . "&ofr=" . $pARRAY['O_ID']; if ($pARRAY['Type'] == "2") $w1 .= "&idl=" . $pARRAY['OL_Lng_Code']; $HelpOfrURL= htmlspecialchars($w1); //============================================================== PREPARE PICTURE $HelpPicURL= utf8_decode($pARRAY['O_PicURL']); //------------------------------------------- Check if local picture is existing if ($HelpPicURL."." != "."): if (stripos($HelpPicURL,"HTTP://") === FALSE and (! file_exists($HelpPicURL))) $HelpPicURL= ""; endif; //------------------------------------------------------------------- H_O_ThumbX switch($RP['l']): case "de": $w1= "Bild verfügbar"; break; case "es": $w1= "Foto disponible"; break; case "fr": $w1= "Photo disponible"; break; default : $w1= "Picture available"; endswitch; //------------------------------------------------------------------------------ $HelpThumb= ""; if ($SysHome['H_O_ThumbX'] != 0 and $pTHUMB == "Y"): $HelpWidth = $SysHome['H_O_ThumbX']; if ($HelpPicURL."." != "."): $HelpThumb = "" . ""; endif; endif; //============================================================= OfferAdminHeader if ($_SESSION['LOGIN']) $RET .= OfferAdminHeader($ItsMe, $pARRAY); //================================================================== RIGHT BLOCK $RightBlock = ""; //========================================================== LOGOUT / OrderBlock if (! $_SESSION['LOGIN'] AND $RP['arc']."." == "."): $RightBlock .= "" . "" . "" . WriteOrderBlock($ItsMe,$pARRAY) . "" . "
" . ""; else: //===================================================== LOGIN / AdminBlock $RightBlock .= ""; //=========================================================== LOGIN-Prices switch($RP['l']): case "de": $w1= "Listenpreis"; $w2= number_format($pARRAY['O_PriceOfList'],2,',','.'); $w3= "Verkaufspreis"; $w4= number_format($pARRAY['O_PriceForSale1'],2,',','.'); break; default : $w1= "Price of List"; $w2= number_format($pARRAY['O_PriceOfList'],2,'.',','); $w3= "Price for sale"; $w4= number_format($pARRAY['O_PriceForSale1'],2,'.',','); endswitch; //------------------------------------------------------------------------ if ($pARRAY['O_PriceForSale1'] <= 0) $w4 = "$w4"; //======================================================================== $RightBlock .= "" . "" . //------------------------------------------------- Price of List "" . "" . "" . "" . //------------------------------------------------ Price for sale "" . "" . "
$w1" . "$w2 
$w3" . "$w4 
" . "
" . ""; endif; //=================================================================== LEFT BLOCK $LeftBlock = ""; //=================================================================== LeftBox if ($HelpThumb <> "") $LeftBlock .= ""; //================================================================= CenterBox $LeftBlock .= ""; //=============================================================== LanguageBox if ($SysHome['W_MultiLang'] == "Y"): MakeOfferFlags($ItsMe, $pARRAY['O_ID'], $pARRAY['OL_Lng_Code']); if ($GV['FlagSelect']."." != ".") $LeftBlock .= ""; endif; //--------------------------------------------------------------------------- $LeftBlock .= "
$HelpThumb"; //------------------------------------------------------------------------ $LeftBlock .= "
"; //------------------------------------------------------ sc_MakeFlagImg if ($pARRAY['Type'] == "2") $LeftBlock .= sc_MakeFlagImg($ItsMe, $pARRAY['OL_Lng_Code']); //--------------------------------------------------------------------- $LeftBlock .= "" . $pARRAY['OL_Headline'] . ""; //--------------------------------------------------------------------- $LeftBlock .= "
"; //--------------------------------------------------------------- Subtitle $LeftBlock .= "
" . OfferListLineSubtitle($ItsMe,$pARRAY) . "
"; //------------------------------------------------------------- WriteAlloc if ($_SESSION['LOGIN'] and $_SESSION['oalloc'] == "Y"): $LeftBlock .= "
" . ABSATZ; $LeftBlock .= WriteAlloc($ItsMe,"OFR",$pARRAY['O_ID'],"","","PRINT"); endif; //------------------------------------------------------------------------ $LeftBlock .= "		" . $GV['FlagSelect'] . "
"; //============================================================================== $RET .= "
" . "" . "" . $RightBlock . "
$LeftBlock
" . "
" . ABSATZ; //------------------------------------------------------------------------------ return($RET); } //---------------------------------------------------- OfferListLine ***END*** //============================================================================== function OfferListLineSubtitle($pBY,&$pARRAY){ //--------- OfferListLineSubtitle //============================================================================== global $GV, $RP, $SysFolder, $SysHome; $ItsMe = "$pBY
calling _offer.php - OfferListLineSubtitle"; $Subtitle= ""; //-------------------------------------------------------- O_ItemGroup, O_ItemNr if ($SysHome['H_O_ShowItemNr'] == "Y" and $pARRAY['O_ItemGroup'] . $pARRAY['O_ItemNr'] ."." !="."): $Subtitle = "(" . $pARRAY['O_ItemGroup']; if ($pARRAY['O_ItemNr']."." != "."): if ($pARRAY['O_ItemGroup']."." != ".") $Subtitle .= "-"; $Subtitle .= $pARRAY['O_ItemNr']; endif; $Subtitle .= ")"; endif; //------------------------------------------------------------------ OL_Subtitle if ($pARRAY['OL_Subtitle']."." != "."): if ($Subtitle != "") $Subtitle .= "  "; $Subtitle .= $pARRAY['OL_Subtitle']; endif; //------------------------------------------------------------------ OL_ValiDate if ($SysFolder['F_InfShowVali'] == "Y"): if ($Subtitle != "") $Subtitle .= "  "; $Subtitle .= "" . "(" . $pARRAY['OL_ValiDate'] . ")"; endif; //-------------------------------------------------------------- further Details if (strlen($pARRAY['OL_Text']) > 0 and $pARRAY['OL_Text']."." <> "
 
." and $pARRAY['OL_Text']."." <> "

 

."): //--------------------------------------------------------------------------- switch($RP['l']): case "de": $w2= "... weitere Details"; break; default : $w2= "... further Details"; endswitch; //--------------------------------------------------------------------------- if ($Subtitle != "") $Subtitle .= "  "; $w1 = "default.php" . $GV['CgiString'] . "&ofr=" . $pARRAY['O_ID']; $Subtitle .= "$w2"; endif; //------------------------------------------------------------------------------ return($Subtitle); } //------------------------------------------- OfferListLineSubtitle ***END *** //============================================================================== function WriteOrderBlock($pBY,&$pARRAY){ //--------------------- WriteOrderBlock //============================================================================== global $GV, $RP, $SysHome, $SysFolder; $ItsMe= "$pBY
calling _offer.php - WriteOrderBlock"; $RET = ""; //----------------------------------------------------- suppress F_ShowOfrPrices if ($SysFolder['F_ShowOfrPrices'] == "0") return($RET); //---------------------------------------------------------------- O_PriceOfList if ($pARRAY['O_PriceOfList'] > 0): //--------------------------------------------------------------------------- switch($RP['l']): case "de": $w1= "Listenpreis"; $w2= number_format($pARRAY['O_PriceOfList'],2,',',''); break; default : $w1= "Price of list"; $w2= number_format($pARRAY['O_PriceOfList'],2,'.',''); endswitch; //--------------------------------------------------------------------------- $RET .= "$w1
$w2"; else: $RET .= " "; endif; //====================================================== SINGLE OFFER - RESERVED if ($pARRAY['O_Type'] <> "3" and $pARRAY['O_Depot'] <= 0): //--------------------------------------------------------------------------- switch($RP['l']): case "de": $w1= "RESERVIERT"; break; default : $w1= "RESERVED"; endswitch; //--------------------------------------------------------------------------- $RET .= "" . "- - $w1 - -"; else: //======================================================= ALL OTHER OFFERS //----------------------------------------------------------- O_PriceForSale1 switch($RP['idl']): case "de": $w= number_format($pARRAY['O_PriceForSale1'],2,',',''); break; default : $w= number_format($pARRAY['O_PriceForSale1'],2,'.',''); endswitch; //--------------------------------------------------------------------------- $RET .= "" . "$w "; //-------------------------------------------------------- B_O_Quantity / Buy $RET .= "" . "
" . "
" . "" . "" . "" . "" . "" . "" . "" ; //----------------------------------------------------------- B_O_Quantity if ($pARRAY['O_Type'] <> "3" and $pARRAY['O_Depot'] == 1): $RET .= ""; else: $RET .= ""; endif; //-------------------------------------------------------------------- Buy switch($RP['l']): case "de": $w1= "in den Einkaufskorb legen"; break; default : $w1= "put into Basket"; endswitch; //------------------------------------------------------------------------ $RET .= "" . "
" . "
"; //------------------------------------------------------------------------ $RET .= ""; endif; //------------------------------------------------------------------------------ return($RET); } //-------------------------------------------------- WriteOrderBlock ***END*** //============================================================================== function OfferInsert($pBY,&$pARRAY,$pMSG) {//----------------------- OfferInsert //============================================================================== global $RP, $SysHome; $ItsMe= "$pBY
calling _offer.php - OfferInsert"; //------------------------------------------------------------------------------ if($pARRAY['O_Tax' ]== "") $pARRAY['O_Tax' ]= 0; if($pARRAY['O_PriceOfList' ]== "") $pARRAY['O_PriceOfList' ]= "0.00"; if($pARRAY['O_PriceForSale1' ]== "") $pARRAY['O_PriceForSale1' ]= "0.00"; if($pARRAY['O_PriceForSale2' ]== "") $pARRAY['O_PriceForSale2' ]= "0.00"; if($pARRAY['O_PriceForSale3' ]== "") $pARRAY['O_PriceForSale3' ]= "0.00"; if($pARRAY['O_PriceForSale4' ]== "") $pARRAY['O_PriceForSale4' ]= "0.00"; if($pARRAY['O_PriceForSale5' ]== "") $pARRAY['O_PriceForSale5' ]= "0.00"; //------------------------------------------------------------------------------ $pARRAY['O_ShowHits' ]=($SysHome['H_O_ShowHits' ] == "Y" ?"Y" :"N"); $pARRAY['O_ShowItemNr' ]=($SysHome['H_O_ShowItemNr' ] == "Y" ?"Y" :"N"); $pARRAY['O_ShowProducer' ]=($SysHome['H_O_ShowProducer' ] == "Y" ?"Y" :"N"); $pARRAY['O_ShowDistributor']=($SysHome['H_O_ShowDistributor'] == "Y" ?"Y" :"N"); $pARRAY['O_ShowAlloc' ]=($SysHome['H_O_ShowAlloc' ] == "Y" ?"Y" :"N"); $pARRAY['O_ShowPosting' ]=($SysHome['H_O_ShowPosting' ] == "Y" ?"Y" :"N"); //------------------------------------------------------------------------------ if($pARRAY['O_Cat1' ]== "") $pARRAY['O_Cat1' ]= 0; if($pARRAY['O_Cat2' ]== "") $pARRAY['O_Cat2' ]= 0; if($pARRAY['O_Cat3' ]== "") $pARRAY['O_Cat3' ]= 0; if($pARRAY['O_A_ID_Distributor']== "") $pARRAY['O_A_ID_Distributor']= "NULL"; if($pARRAY['O_A_ID_Producer' ]== "") $pARRAY['O_A_ID_Producer' ]= "NULL"; //------------------------------------------------------------------------------ $sql = "INSERT INTO sc_offer (" . "O_W_ID, " . "O_SortField, " . "O_PicURL, " . "O_PicBorder, " . "O_PicPos, " . "O_ShowHead, " . "O_ShowHits, " . "O_ShowItemNr, " . "O_ShowProducer, " . "O_ShowDistributor, " . "O_ShowAlloc, " . "O_ShowPosting, " . "O_ShowInNewslist, " . "O_ItemGroup, " . "O_ItemNr, " . "O_Type, " . "O_Depot, " . "O_Tax, " . "O_PriceOfList, " . "O_PriceForSale1, " . "O_PriceForSale2, " . "O_PriceForSale3, " . "O_PriceForSale4, " . "O_PriceForSale5, " . "O_Key1, " . "O_Key2, " . "O_Key3, " . "O_Cat1, " . "O_Cat2, " . "O_Cat3, " . "O_A_ID_Distributor, " . "O_A_ID_Producer) " . "VALUES (" . " " . $pARRAY['p' ]. " , " . "'" . $pARRAY['O_SortField' ]. "', " . "'" . $pARRAY['O_PicURL' ]. "', " . "'" . $pARRAY['O_PicBorder' ]. "', " . "'" . $pARRAY['O_PicPos' ]. "', " . "'" . "Y" . "', " . "'" . $pARRAY['H_O_ShowHits' ]. "', " . "'" . $pARRAY['H_O_ShowItemNr' ]. "', " . "'" . $pARRAY['H_O_ShowProducer' ]. "', " . "'" . $pARRAY['H_O_ShowDistributor']. "', " . "'" . $pARRAY['H_O_ShowAlloc' ]. "', " . "'" . $pARRAY['H_O_ShowPosting' ]. "', " . "'" . $pARRAY['O_ShowInNewslist' ]. "', " . "'" . $pARRAY['O_ItemGroup' ]. "', " . "'" . $pARRAY['O_ItemNr' ]. "', " . "'" . $pARRAY['O_Type' ]. "', " . " " . $pARRAY['O_Depot' ]. " , " . " " . $pARRAY['O_Tax' ]. " , " . " " . $pARRAY['O_PriceOfList' ]. " , " . " " . $pARRAY['O_PriceForSale1' ]. " , " . " " . $pARRAY['O_PriceForSale2' ]. " , " . " " . $pARRAY['O_PriceForSale3' ]. " , " . " " . $pARRAY['O_PriceForSale4' ]. " , " . " " . $pARRAY['O_PriceForSale5' ]. " , " . "'" . $pARRAY['O_Key1' ]. "', " . "'" . $pARRAY['O_Key2' ]. "', " . "'" . $pARRAY['O_Key3' ]. "', " . " " . $pARRAY['O_Cat1' ]. " , " . " " . $pARRAY['O_Cat2' ]. " , " . " " . $pARRAY['O_Cat3' ]. " , " . " " . $pARRAY['O_A_ID_Distributor' ]. " , " . " " . $pARRAY['O_A_ID_Producer' ]. " ) " ; sc_INSERT($ItsMe,$sql); $pARRAY['ofr'] = sc_LastInsertID($ItsMe); //============================================================== INSERT sc_index $sql = "INSERT INTO sc_index (" . "X_W_ID, " . "X_Parent_F_ID, " . "X_Child_Type, " . "X_Child_ID, " . "X_Focus, " . "X_Alloc_Type, " . "X_Synonym_F_ID, " . "X_InsDT, " . "X_InsBY, " . "X_UpdDT, " . "X_UpdBY) " . "VALUES( " . " " . $RP['p'] . " , " . " " . $pARRAY['sec'] . " , " . "'" . "O" . "', " . " " . $pARRAY['ofr'] . " , " . "'" . "N" . "', " . "'" . "O" . "', " . " " . "NULL" . " , " . "'" . date("Y-m-d H:i:s"). "', " . "'" . $_SESSION['USER'] . "', " . " " . "NULL" . " , " . " " . "NULL" . " ) " ; sc_INSERT($ItsMe,$sql); //------------------------------------------------------------------------------ if ($pMSG == "WriteMessage"): switch($RP['l']): case "de": sc_MESSAGE("Neuzugang OK"); break; default : sc_MESSAGE("Insert OK"); endswitch; endif; //------------------------------------------------------------------------------ OfferLangInsert($ItsMe,$pARRAY,$pARRAY['ofr'],$RP['idl'],$pMSG); } //------------------------------------------------------ OfferInsert ***END*** //============================================================================== function OfferLangInsert($pBY,&$pARRAY,$pNR,$pL,$pMSG){ //------ OfferLangInsert //============================================================================== global $RP; $ItsMe= "$pBY
calling _offer.php - OfferLangInsert"; //------------------------------------------------------------------------------ if ($pARRAY['OL_Status' ]."." == ".") $pARRAY['OL_Status' ]= "0"; //------------------------------------------------------------------------------ $sql = "INSERT INTO sc_offer_lang (" . "OL_O_ID, " . "OL_Lng_Code, " . "OL_ValiDate, " . "OL_ExpDate, " . "OL_Status, " . "OL_Headline, " . "OL_Subtitle, " . "OL_Text, " . "OL_InsDT, " . "OL_InsBY, " . "OL_UpdDT, " . "OL_UpdBY) " . "VALUES (" . " " . $pNR . " , " . "'" . $pL . "', " . "'" . $pARRAY['OL_ValiDate']. "', " . "'" . $pARRAY['OL_ExpDate' ]. "', " . "'" . $pARRAY['OL_Status' ]. "', " . "'" . $pARRAY['OL_Headline']. "', " . "'" . $pARRAY['OL_Subtitle']. "', " . "'" . $pARRAY['OL_Text' ]. "', " . "'" . date("Y-m-d H:i:s") . "', " . "'" . $_SESSION['USER'] . "', " . "'" . date("Y-m-d H:i:s") . "', " . "'" . "') " ; sc_INSERT($ItsMe,$sql); //------------------------------------------------------------------------------ if ($pMSG == "WriteMessage"): switch($RP['l']): case "de": sc_MESSAGE("Eingabe der Übersetzung " . "" . $RP['idl'] . " für Angebot " . "" . $RP['ofr'] . " OK"); break; default : sc_MESSAGE("Inserting of translation " . "" . $RP['idl'] . " for Offer " . "" . $RP['ofr'] . " OK"); endswitch; endif; } //-------------------------------------------------- OfferLangInsert ***END*** //============================================================================== function OfferUpdate($pBY,&$pARRAY){//------------------------------ OfferUpdate //============================================================================== global $RP; $ItsMe= "$pBY
calling _offer2.php / OfferUpdate"; //============================================================== UPDATE sc_offer if ($pARRAY['O_Tax'] == "") $pARRAY['O_Tax'] = 0; if ($pARRAY['O_PriceOfList'] == "") $pARRAY['O_PriceOfList'] = "0.00"; if ($pARRAY['O_PriceForSale1'] == "") $pARRAY['O_PriceForSale1'] = "0.00"; if ($pARRAY['O_PriceForSale2'] == "") $pARRAY['O_PriceForSale2'] = "0.00"; if ($pARRAY['O_PriceForSale3'] == "") $pARRAY['O_PriceForSale3'] = "0.00"; if ($pARRAY['O_PriceForSale4'] == "") $pARRAY['O_PriceForSale4'] = "0.00"; if ($pARRAY['O_PriceForSale5'] == "") $pARRAY['O_PriceForSale5'] = "0.00"; if ($pARRAY['O_Cat1'] == "") $pARRAY['O_Cat1'] = 0; if ($pARRAY['O_Cat2'] == "") $pARRAY['O_Cat2'] = 0; if ($pARRAY['O_Cat3'] == "") $pARRAY['O_Cat3'] = 0; if ($pARRAY['O_A_ID_Distributor']== "") $pARRAY['O_A_ID_Distributor']= "NULL"; if ($pARRAY['O_A_ID_Producer'] == "") $pARRAY['O_A_ID_Producer'] = "NULL"; if ($pARRAY['O_PicURL'] != "" && preg_match('/^\//',$pARRAY['O_PicURL'])) $pARRAY['O_PicURL']= substr($pARRAY['O_PicURL'],1); //------------------------------------------------------------------------------ $sql = "UPDATE sc_offer SET " . "O_ShowInNewslist = '" . $pARRAY['O_ShowInNewslist' ]. "', " . "O_SortField = '" . $pARRAY['O_SortField' ]. "', " . "O_PicURL = '" . $pARRAY['O_PicURL' ]. "', " . "O_PicBorder = '" . $pARRAY['O_PicBorder' ]. "', " . "O_PicPos = '" . $pARRAY['O_PicPos' ]. "', " . "O_ItemGroup = '" . $pARRAY['O_ItemGroup' ]. "', " . "O_ItemNr = '" . $pARRAY['O_ItemNr' ]. "', " . "O_Type = '" . $pARRAY['O_Type' ]. "', " . "O_Depot = " . $pARRAY['O_Depot' ]. " , " . "O_Tax = " . $pARRAY['O_Tax' ]. " , " . "O_PriceOfList = " . $pARRAY['O_PriceOfList' ]. " , " . "O_PriceForSale1 = " . $pARRAY['O_PriceForSale1' ]. " , " . "O_PriceForSale2 = " . $pARRAY['O_PriceForSale2' ]. " , " . "O_PriceForSale3 = " . $pARRAY['O_PriceForSale3' ]. " , " . "O_PriceForSale4 = " . $pARRAY['O_PriceForSale4' ]. " , " . "O_PriceForSale5 = " . $pARRAY['O_PriceForSale5' ]. " , " . "O_Key1 = '" . $pARRAY['O_Key1' ]. "', " . "O_Key2 = '" . $pARRAY['O_Key2' ]. "', " . "O_Key3 = '" . $pARRAY['O_Key3' ]. "', " . "O_Cat1 = " . $pARRAY['O_Cat1' ]. " , " . "O_Cat2 = " . $pARRAY['O_Cat2' ]. " , " . "O_Cat3 = " . $pARRAY['O_Cat3' ]. " , " . "O_A_ID_Distributor = ". $pARRAY['O_A_ID_Distributor']. " , " . "O_A_ID_Producer = " . $pARRAY['O_A_ID_Producer' ]. " " . "WHERE O_ID = " . $RP['ofr'] . " " ; sc_UPDATE($ItsMe,'CheckOne',$sql,$nr); //========================================================= UPDATE sc_offer_lang if ($pARRAY['OL_Status']."." == ".") $pARRAY['OL_Status'] = "0"; //------------------------------------------------------------------------------ $sql = "UPDATE sc_offer_lang SET " . "OL_ValiDate = '". $pARRAY['OL_ValiDate']. "', " . "OL_ExpDate = '" . $pARRAY['OL_ExpDate' ]. "', " . "OL_Status = '" . $pARRAY['OL_Status' ]. "', " . "OL_Headline = '". $pARRAY['OL_Headline']. "', " . "OL_Subtitle = '". $pARRAY['OL_Subtitle']. "', " . "OL_Text = '" . $pARRAY['OL_Text' ]. "', " . "OL_UpdDT = '" . date("Y-m-d H:i:s") . "', " . "OL_UpdBy = '" . $_SESSION['USER' ]. "' " . "WHERE OL_O_ID = " . $RP['ofr'] . " " . "AND OL_Lng_Code = '" . $RP['idl'] . "' " ; sc_UPDATE($ItsMe,'CheckOne',$sql,$nr); //------------------------------------------------------------------------------ //============================== CHECK EXISTING ALLOCATION FOR NEW PARENT-FOLDER // After the update of the OFFER MAIN ATTRIBUTES there will be checked if // the user try's to move the OFFER into another Parent-FOLDER there for // we search for an allready existing allocation of the INFO in the selected // new Parent-FOLDER. //============================================================================== $sql = "SELECT COUNT(*) AS NUMBER_OF_ALLOCS FROM sc_index " . "WHERE X_W_ID = " . $RP['p'] . " " . "AND X_Child_ID = " . $pARRAY['ofr'] . " " . "AND X_Child_Type = 'O' " . "AND X_Alloc_Type = 'A' " . "AND X_Parent_F_ID = " . $pARRAY['sec'] . " " ; sc_SELECT($ItsMe,"CheckOne",$sql,$rs,$nr); $temp = mysqli_fetch_assoc($rs); mysqli_free_result($rs); //=============== DELETE OF EXISTING ALLOCATION & UPDATE PARENT-FOLDER OF ORIGIN // If we found an allocation in the selected destination-FOLDER we delete // the allocation recordset before we update(move!) the origin recordset // to the new Parent-FOLDER //============================================================================== if ($temp['NUMBER_OF_ALLOCS'] > 0): //============================================================ EXECUTE DELETE $sql = "DELETE FROM sc_index " . "WHERE X_W_ID = " . $RP['p'] . " " . "AND X_Child_ID = " . $pARRAY['ofr'] . " " . "AND X_Child_Type = 'O' " . "AND X_Alloc_Type = 'A' " . "AND X_Parent_F_ID = " . $pARRAY['sec'] . " " ; sc_DELETE("$ItsMe - DELETE of allocation for $ObjType",$sql,$nr); endif; //============================================================== UPDATE sc_index $sql = "UPDATE sc_index SET " . "X_Parent_F_ID = " . $pARRAY['sec'] . ", " . "X_UpdDT = '" . date("Y-m-d H:i:s"). "', " . "X_UpdBY = '" . $_SESSION['USER'] . "' " . "WHERE X_W_ID = " . $RP['p'] . " " . "AND X_Child_ID = " . $pARRAY['ofr'] . " " . "AND X_Child_Type = 'O' " . "AND X_Alloc_Type = 'O' " ; sc_UPDATE($ItsMe,'CheckOne',$sql,$nr); //------------------------------------------------------------------------------ switch($RP['l']): case "de": sc_MESSAGE("Änderung Angebots " . $RP['ofr'] . " " . "Sprache " . $RP['idl'] . " OK"); break; default : sc_MESSAGE("Update Offer " . $RP['ofr'] . " " . "Language " . $RP['idl'] . " OK"); endswitch; } //------------------------------------------------------ OfferUpdate ***END*** //============================================================================== function OfferWriteFormLang($pBY){//------------------------- OfferWriteFormLang //============================================================================== global $GV, $RP, $SysHome, $tempOfr; $ItsMe = "$pBY
calling _offer2.php - OfferWriteFormLang"; //=========================================================== hidden OL_Lng_Code if($RP['ofr']. "." != ".") echo ""; //================================================= INFO FORM Haupteinstellungen echo "
"; //---------------------------- prepare Tooltip (INFO Eingabe/Letzte Änderung) $tooltip = sc_WriteAllocMessage($pBY); echo ''; echo ""; //------------------------------------------------------------ WL_StartFolder switch ($RP['l']): case "de": $w1= "Zuweisung"; break; default : $w1= "Allocation"; endswitch; //--------------------------------------------------------------------------- $sql = "SELECT FL_Headline FROM sc_folder_lang " . "WHERE FL_F_ID = " . $RP['sec'] . " " ; sc_SELECT($ItsMe,'CheckNo',$sql,$rt,$nr); $temp = mysqli_fetch_assoc($rt); $sec_Name = $temp['FL_Headline']; mysqli_free_result($rt); //--------------------------------------------------------------------------- echo ""; echo "". "
" . "". $w1.""; echo ""; echo "". "$sec_Name - ID ".$RP['sec'].""; echo "
"; //========================================================== O_ShowInNewslist switch($RP['l']): case "de": $w1= "Newsliste"; $w2= "JA"; $w3= "NEIN"; $tooltip = "Hier können Sie auswählen,
ob die aktuelle INFO in die Newsliste aufgenommen werden soll!"; break; default : $w5= "Newslist"; $w2= "YES"; $w3= "NO"; $tooltip = "Here you can select,
if the actual INFO schould be displayed in the newslist!"; endswitch; switch($tempOfr['O_ShowInNewslist']): case "Y": $c = "#00AA00"; break; case "N": $c = "#FF0000"; break; endswitch; echo ''; echo ""; //--------------------------------------------------------------------------- echo "" . "". //------------------------------------------------------------------------ "
". //========================================================== Newslist TOOLTIP "$w1". "" . "". "
"; //================================================================= OL_Status if ($SysHome['H_I_Status'] == "Y"): //------------------------------------------------------------------------ switch($RP['l']): case "de": $w1= "Status"; $w0= "freigegeben"; //......... selectbox value = 0 !!! $w2= "gesperrt"; //......... selectbox value = 2 !!! $w4= "in Bearbeitung"; //......... selectbox value = 4 !!! break; default : $w1= "Status"; $w0= "released"; $w2= "locked"; $w4= "under construction"; endswitch; switch($tempOfr['OL_Status']): case "0": $c = "#00AA00"; break; case "2": $c = "#FF0000"; break; case "4": $c = "#FF8800"; break; endswitch; //------------------------------------------------------------------------ echo ""; echo "" . ""; echo "
$w1" . "
"; endif; //=============================================================== O_SortField switch($RP['l']): case "de": $w1= "Sortierung"; break; default : $w1= "Sorting"; endswitch; //--------------------------------------------------------------------------- echo ""; echo "" . ""; //------------------------------------------------------------------------ echo "
". "$w1". "" . "" . "
"; //=================================================== IL_ValiDate, IL_ExpDate switch($RP['l']): case "de": $w2= "gültig "; $w3= "AB"; $w4= "BIS"; break; default : $w2= "valid "; $w3= "FROM"; $w4= "TO"; endswitch; //--------------------------------------------------------------------------- echo ""; echo ""; // echo ""; //------------------------------------------------------------ IL_ValiDate echo "" . sc_DatePicker('OL_ValiDate', $tempOfr['OL_ValiDate'], '100px', '-1:+2'); // echo ""; //------------------------------------------------------------- IL_ExpDate echo "" . sc_DatePicker('OL_ExpDate', $tempOfr['OL_ExpDate'], '100px', '-1:+10'); echo ""; //------------------------------------------------------------------------ echo "
$w2
$w3
$w4BIS Datum löschen". "
"; //---------------------------- prepare Tooltip (INFO Eingabe/Letzte Änderung) /* $tooltip = sc_WriteAllocMessage($pBY); echo ''; echo ""; //------------------------------------------------------------ WL_StartFolder switch ($RP['l']): case "de": $w1= "Ordner"; break; default : $w1= "Folder"; endswitch; //--------------------------------------------------------------------------- echo ""; echo ""; echo "
" . "$w1"; echo ""; echo "
"; * */ echo "
"; //======================================================= INFO Hauptattribute echo "
"; //------------------------------------------------------------------------ switch($RP['l']): case "de": $w1= "Überschrift"; $w2= "Untertitel"; break; default : $w1= "Headline"; $w2= "Subtitle"; endswitch; //------------------------------------------------------------------------ echo ""; //--------------------------------------------------------- OL_Headline echo "" . ""; //------------------------------------------------------------ OL_Subtitle echo "
" . "
$w1
" . "" . "
"; //------------------------------------------------------------------------ echo ""; //--------------------------------------------------------------------- echo "" . ""; //------------------------------------------------------------------------ echo ""; //------------------------------------------------------------------------ echo "
$w2
". "		" . "
"; echo "
"; //--------- Container für Filemanager //=============================================================== O_PicURL switch($RP['l']): case "de": $w1= "Bild URL"; $w2= "Bild auswählen"; break; default : $w1= "Picture URL"; $w2= "Select Picture"; endswitch; //------------------------------------------------------------------------ echo ""; echo "". "" . "". // ""; //--------------------------------------------------------------------- "
$w1" . "". "Bild URL löschen". "". "" . "
". // "" . // "
"; //------------------------------------------------------------------------ switch($RP['l']): case "de": $w1= "Bild anzeigen"; break; default : $w1= "Show Picture"; endswitch; //------------------------------------------------------------------------ //=============================================================== O_PicPos echo "". ""; echo ""; echo ""; echo ""; echo "". ""; //============================================================ O_PicBorder switch($RP['l']): case "de": $w1= "Rahmen"; $w2= "". "NEIN"; $w3= ""; $w4= ""; $w5= ""; break; default : $w1= "Border"; $w2= "". "NO"; $w3= ""; $w4= ""; $w5= ""; endswitch; //--------------------------------------------------------------------- echo "" . ""; //--------------------------------------------------------------------- echo ""; //========================================================== OFFER OL_Text switch($RP['l']): case "de": $w1= "Text"; break; default : $w1= "Text"; endswitch; //------------------------------------------------------------------------ echo ""; echo ""; //--------------------------------------------------------------------- echo "
"; echo ""; echo "
" . ABSATZ; //==================================================== EXTENDED ATTRIBUTES echo WriteExtendedAttributes($ItsMe,"Offer", $tempOfr['O_Key1'],$tempOfr['O_Key2'],$tempOfr['O_Key3'], $tempOfr['O_Cat1'],$tempOfr['O_Cat2'],$tempOfr['O_Cat3']); //============================================ OFFER FORM Haupteinstellungen END echo "
"; } //----------------------------------------------- OfferWriteFormLang ***END*** //============================================================================== Function WriteOfferText($pBY,$pINF){ //-------------------------- WriteOfferText // BUG ? $pINF //============================================================================== global $GV, $RP; $ItsMe= "$pBY
calling WriteOfferText"; $WriteOfferText= ""; //------------------------------------------------------------------------------ $sql = "SELECT sc_info_lang.* " . "FROM sc_info INNER JOIN sc_info_lang " . " ON sc_info.I_ID = sc_info_lang.IL_I_ID " . "WHERE I_ID = $pINF " . "AND I_W_ID = " . $RP['p'] . " " . "AND IL_Lng_Code = '" . $RP['l'] . "' " . "AND (OL_ValiDate = '' OR " . " OL_ValiDate IS NULL OR " . " OL_ValiDate <= '" . date("Y-m-d") . "') " . "AND (OL_ExpDate = '' OR " . " OL_ExpDate IS NULL OR " . " OL_ExpDate > '" . date("Y-m-d") . "') " ; sc_SELECT($ItsMe,'CheckNo',$sql,$rt,$nr); $temp= mysqli_fetch_assoc($rt); if($RP['id'] == "sh") $RP['MailSubject']= $temp['IL_Headline']; $WriteOfferText= $temp['IL_Text']; mysqli_free_result($rt); return $WriteOfferText; } //--------------------------------------------------- WriteOfferText ***END*** //============================================================================== function WriteOrderMail($pBY,&$pARRAY){ //----------------------- WriteOrderMail //============================================================================== global $GV, $RP, $SysHome; $ItsMe= "$pBY
calling WriteOrderMail"; $GV['HitsDetail'] = 0; $pARRAY['MailText2']= ""; //------------------------------------------------------------------------------ $sql = "SELECT sc_basket.*, sc_offer.*,sc_offer_lang.* " . "FROM sc_basket, sc_offer, sc_offer_lang " . "WHERE B_Session = '" . session_id() . "' " . "AND B_W_ID = " . $RP['p'] . " " . "AND B_O_ID = O_ID " . "AND O_ID = OL_O_ID " . "AND OL_Lng_Code = '" . $RP['l'] . "' " . "ORDER BY OL_Headline, OL_Subtitle " ; sc_SELECT($ItsMe,'CheckNo',$sql,$rt,$nr); //============================================================================== // No items found in basket - probably timeout ! ==> EXIT //============================================================================== if ($nr == 0): switch($RP['l']): case "de": sc_MESSAGE ( "Hallo, dies ist eine Systeminformation !
" . "
" . "Ihre Bestellung konnte leider nicht " . "durchgeführt werden, da ihr Einkaufskorb zum " . "Zeitpunkt ihrer Bestellung leer war.
" . "
" . "Der häufigste Grund hiefür ist, dass zwischen " . "der letzten Artikelauswahl und ihrer Auftragserteilung " . "über - JETZT BESTELLEN - zu viel Zeit vergangen ist " . "(session timeout).
" . "
" . "Bitte wiederholen sie den gesamten Bestellvorgang. " . "Sollten sie dennoch wieder diese Systeminformation " . "erhalten, wenden sie sich bitte telefonisch oder " . "per eMail an den Betreiber dieser Website.
" . "
" . "Wir danken für ihr Verständnis !
" . "
" ); break; default : sc_MESSAGE ( "Hello, this is a system message !
" . "
" . "Your order could not be executed by the system, cause " . "your basket has been emty at the moment of execution.
" . "
" . "The reason mostly is a session timeout. Between picking " . "up the last item and your action - ORDER NOW - has been " . "a too large space of time.
" . "
" . "Please repeat your complete order. If you get this system " . "message again, contact the owner of this website by phone " . "or email.
" . "
" . "With best thanks for your understanding !
" . "
" ); endswitch; header("location: default.php" . $GV['CgiString']); exit; endif; //===================================================================== HEADER 1 switch($RP['l']): case "de": $w1= "Sie haben folgende Bestellung in Auftrag gegeben"; break; default : $w1= "This is your Order"; endswitch; //------------------------------------------------------------------------------ $pARRAY['MailText2'] .= "
" . "$w1" . "
"; //===================================================================== HEADER 2 switch($RP['l']): case "de": $w1= "Artikelbezeichnung"; $w2= "Art.-Nr."; $w3= "Einzel-
preis"; $w4= "Menge"; $w5= "SUMME"; break; default : $w1= "Offername"; $w2= "Item-Nr."; $w3= "Price"; $w4= "Quantity"; $w5= "TOTAL"; endswitch; //============================================================= OFFER LIST START $pARRAY['MailText2'] .= "" . "" . "" . "" . "" . "" . "" . "\r\n"; //=================================================================== OFFER LINE for ($i = 0; $i < $nr; $i++): $temp= mysqli_fetch_assoc($rt); $pARRAY['O_Tax'] = $temp['O_Tax']; //--------------------------------------------------------------------------- $pARRAY['DetailPrice']= $temp['O_PriceForSale1']; $pARRAY['TotalPrice'] = $temp['O_PriceForSale1'] * $temp['B_O_Quantity']; $pARRAY['TotalTax']= $temp['TotalPrice'] - ($temp['TotalPrice'] / ($temp['O_Tax'] + 100) *100); //--------------------------------------------------------------------------- $pARRAY['MailText2'] .= ""; //---------------------------------------------- OL_Headline / OL_Subtitle if($temp['OL_Headline'] . $temp['OL_Subtitle']."." != "."): if($temp['OL_Headline']."." != ".") $w1 = "" . $temp['OL_Headline'] . ""; if($temp['OL_Subtitle']."." != "."): if($w1 . "." != ".") $w1.= "
"; $w1.= "
" . $temp['OL_Subtitle'] . "
"; endif; else: $w1 = " "; endif; $pARRAY['MailText2'] .= ""; //---------------------------------------------- O_ItemGroup, O_ItemNr $w1= " "; if ($temp['O_ItemGroup']."." != ".") $w1 = $temp['O_ItemGroup']; if ($temp['O_ItemNr']."." != "."): if ($temp['O_ItemGroup']."." != ".") $w1 .= "-"; $w1 .= $temp['O_ItemNr']; endif; $pARRAY['MailText2'] .= ""; //------------------------------------------------------------ DetailPrice switch($RP['l']): case "en": $w1= number_format($pARRAY['DetailPrice'],2,'.',','); $w2= number_format($pARRAY['TotalPrice'],2,'.',','); break; default: $w1= number_format($pARRAY['DetailPrice'],2,',','.'); $w2= number_format($pARRAY['TotalPrice'],2,',','.'); endswitch; //------------------------------------------------------------------------ $pARRAY['MailText2'] .= ""; //----------------------------------------------------------- B_O_Quantity $pARRAY['MailText2'] .= ""; //------------------------------------------------------------- TotalPrice $pARRAY['MailText2'] .= "\r\n"; //--------------------------------------------------------------------------- $GV['HitsDetail']++; $pARRAY['TotalPriceBasket']+= $pARRAY['TotalPrice']; endfor; mysqli_free_result($rt); //=============================================================== OFFER LIST END $pARRAY['MailText2'].= "
" . "$w1" . "$w2" . "$w3" . "$w4" . "$w5
" . "$w1" . "$w1" . "$w1" . $temp['B_O_Quantity'] . "" . "$w2
"; //================================================================== GRAND TOTAL switch($RP['l']): case "de": $w1= "GESAMTSUMME in " . $SysHome['W_Currency'] . " inkl. MwST"; $w2= number_format($pARRAY['TotalPriceBasket'],2,',','.'); break; default : $w1= "GRAND TOTAL in ". $SysHome['W_Currency'] .", Tax included"; $w2= number_format($pARRAY['TotalPriceBasket'],2,'.',','); endswitch; //------------------------------------------------------------------------------ $pARRAY['MailText2'].= "" . "" . "" . "" . "
" . "$w1" . "$w2
\r\n"; } //--------------------------------------------------- WriteOrderMail ***END*** ?> Home

Die Philatelie - Eines der schönsten Hobbys dieser Welt

Willkommen auf meiner WebSite !
www.BriefmarkenEck.at

 

Prüfung klassischer Briefmarken von
Österreich und Lombardei / Venetien

Für die Pflege und Erweiterung meiner eigenen Sammlung klassischer Briefmarken von Österreich sowie Lombardei und Venetien tätige ich laufend neue Ankäufe. So komme ich auch immer wieder zu Material, über das ich bereits verfüge oder welches nicht zu meinem Sammelgebiet gehört. Die schönsten Stücke davon, Serien oder thematisch zusammengestellten Lots biete ich hier als Privatverkauf an.

Als Sachverständiger für Philatelie garanatiere ich für die Richtigkeit meiner Angebotsbeschreibungen. Sollten sich im Falle eines Verkaufs dennoch Fehler oder Mängel eingeschlichen haben, machen sie mich bitte per Mail darauf aufmerksam. Es wird sich immer eine für beide Seiten zufrieden stellende, einvernehmliche Lösung finden.

Werfen sie nun einen Blick auf "Die aktuellsten Angebote" oder wählen sie aus den Themen im Menü.

Und nun viel Spaß bei Stöbern !

  

Als Prüfer obiger Sammelgebiete verfüge ich über eine entsprechende Referenzsammlung sowie zugehörige Fachliteratur.

Viele Stücke meiner Sammlung sind mit Bestimmungen, Signaturen, Befunden oder Attesten bekannter, international geschätzter Prüfer versehen und untermauern die Bestimmung von Farben, Typen, Platten oder sonstiger Besonderheiten.

Gerne stelle ich meine Dienstleistungen als Briefmarkenprüfer zur Verfügung. Neben der Prüfung von Belegen und Briefmarken aus meinen Prüfgebieten umfassen diese aber auch Sammlungsbewertungen, Beratung zur Sammlungsfortführung oder deren möglichst optimale Verwertung.

Bei Interesse kontaktieren sie mich bitte per Mail oder Telefon. Schicken sie mir jedoch aus Sicherheitsgründen keinesfalls irgendwelche Prüfobjekte ohne vorherige Vereinbarung.
Welchen Preis hat eine Briefmarke?
Michel Rundschau 12/2006