WebSVN – lars-tiefland.content-management – Blame – /trunk/cronjobs/ebay_mail.php

Revision	Autor	Zeilennr.	Zeile
1	lars	1	`<?php`
		2
		3	`/**`
		4	`* @package Content-management`
		5	`* @author Webagentur Niewerth <tiefland@weban.de>`
		6	`* @copyright 2011 Webagentur Niewerth`
		7	`* @license propietary http://www.weban.de`
		8	`* @version $Rev: 3873 $`
		9	`* @filesource`
		10	`*`
		11	`*/`
		12
		13	`/**`
		14	`*`
		15	`* @package Content-management`
		16	`* @author Webagentur Niewerth <tiefland@weban.de>`
		17	`* @copyright 2011 Webagentur Niewerth`
		18	`*/`
		19
		20	`// SVN: $Id: ebay_mail.php 3873 2011-09-01 13:50:57Z tiefland $`
		21
		22	`require_once "../Online-Shop/connect2.php";`
		23	`require_once`
		24	`"../Warenwirtschaft/includes/bestellungen/system/getBestellarten.php";`
		25
		26	`$bestellarten = getBestellarten();`
		27
		28	`$start_date = date( "Y-m-d H:i:00", strtotime( "-12 hours" ) );`
		29
		30	`$shop = filter_input( INPUT_GET, "shop", FILTER_VALIDATE_INT );`
		31	`$bestellart_id = filter_input( INPUT_GET, "bestellart_id",`
		32	`FILTER_VALIDATE_INT );`
		33	`$button_id = filter_Input( INPUT_GET, "button_id", FILTER_VALIDATE_INT );`
		34
		35	`if ( $bestellarten && !$bestellart_id )`
		36	`{`
		37	`die( "Dieser Shop arbeitet mit Bestellarten.<br>Bitte geben Sie die richtige an!" );`
		38	`} elseif ( !stristr( $bestellarten[$bestellart_id]["rufname"], "ebay" ) )`
		39	`{`
		40	`die( "Dies ist die Bestellart für Ebay-Bestellungen!<br>Bitte geben Sie die richtige an!" );`
		41	`}`
		42	`if ( !$button_id \|\| !$shop )`
		43	`{`
		44	`die( "Fehler: Falscher Aufruf.<br>Es müssen 2 weitere Parameter übergeben werden!" );`
		45	`}`
		46
		47	`$bestellart = false;`
		48	`$sql = "SELECT`
		49	`b.id,`
		50	`b.shops_ID,`
		51	`b.bestellart_id,`
		52	`l.E_Mail,`
		53	`l.Name1,`
		54	`l.Name2,`
		55	`l.Vorname,`
		56	`l.Anrede,`
		57	`b.erstellt_am`
		58	`FROM`
		59	`Bestellung b,`
		60	`Logins l`
		61	`WHERE`
		62	`shops_id=" . $shop . "`
		63	`AND`
		64	`l.id=b.login`
		65	`AND`
		66	`bestellart_id=" . $bestellart_id . "`
		67	`AND`
		68	`b.erstellt_am >='$start_date'`
		69	`";`
		70	`$res = mysql_query( $sql );`
		71	`while ( $row = mysql_fetch_assoc( $res ) )`
		72	`{`
		73	`$erstellt_am = datetime2human( $row["erstellt_am"] );`
		74	`$Datum = $erstellt_am["Datum"];`
		75	`$Zeit = $erstellt_am["Zeit"];`
		76	`$Userdata = $row;`
		77	`$Heute = date( "d.m.Y" );`
		78	`$jetzt = date( "H:i" );`
		79	`$bestellart = false;`
		80	`$Bestellung = $row["id"];`
		81	`if ( is_array( $bestellarten ) && $Bestellung )`
		82	`{`
		83	`$sql_s = "`
		84	`SHOW`
		85	`COLUMNS`
		86	`FROM`
		87	`shops`
		88	`LIKE`
		89	`'database'`
		90	`";`
		91	`$res_s = mysql_query( $sql_s );`
		92	`if ( mysql_num_rows( $res_s ) )`
		93	`{`
		94	`$sql_sb = "SELECT`
		95	`database`
		96	`FROM`
		97	`shops s,`
		98	`Bestellung b`
		99	`WHERE`
		100	`s.ID=b.shops_ID`
		101	`AND`
		102	`b.ID=$Bestellung`
		103	`";`
		104	`$res_sb = mysql_query( $sql_sb );`
		105	`$row_sb = mysql_fetch_assoc( $res_sb );`
		106	`if ( $row_sb["database"] )`
		107	`{`
		108	`$database = $row_sb["database"] . ".";`
		109	`}`
		110	`}`
		111	`$settings_table = $database . "web_settings";`
		112	`$sql_ws = "`
		113	`SHOW`
		114	`COLUMNS`
		115	`FROM`
		116	`$settings_table`
		117	`LIKE`
		118	`'bestellart_id'`
		119	`";`
		120	`$res_ws = mysql_query( $sql_ws );`
		121	`$anz = mysql_num_rows( $res_ws );`
		122	`if ( $anz )`
		123	`{`
		124	`$bestellart = true;`
		125	`define( "BESTELLART", true );`
		126	`}`
		127	`else`
		128	`{`
		129	`$bestellart = false;`
		130	`define( "BESTELLART", false );`
		131	`}`
		132	`} elseif ( $Bestellung )`
		133	`{`
		134	`$sql_s = "`
		135	`SHOW`
		136	`COLUMNS`
		137	`FROM`
		138	`shops`
		139	`LIKE`
		140	`'database'`
		141	`";`
		142	`$database = "";`
		143	`$res_s = mysql_query( $sql_s );`
		144	`if ( mysql_num_rows( $res_s ) )`
		145	`{`
		146	`$sql = "SELECT`
		147	`database`
		148	`FROM`
		149	`shops s,`
		150	`Bestellung b`
		151	`WHERE`
		152	`s.ID=b.shops_ID`
		153	`AND`
		154	`b.ID=$Bestellung`
		155	`";`
		156	`$res_sb = mysql_query( $sql_sb );`
		157	`$row_sb = mysql_fetch_assoc( $res_sb );`
		158	`if ( $row_sb["database"] )`
		159	`{`
		160	`$database = $row_sb["database"] . ".";`
		161	`}`
		162	`}`
		163	`$settings_table = $database . "web_settings";`
		164	`$bestellart = false;`
		165	`define( "BESTELLART", false );`
		166	`}`
		167
		168	`if ( $bestellart )`
		169	`{`
		170	`$query = "`
		171	`SELECT`
		172	`*`
		173	`FROM`
		174	`$settings_table`
		175	`WHERE`
		176	`bestellart_id=" . $bestellart_id . "`
		177	`AND`
		178	`shops_ID = " . $shop . "`
		179	`ORDER BY`
		180	`Rang";`
		181	`}`
		182	`else`
		183	`{`
		184	`$query = "`
		185	`SELECT`
		186	`*`
		187	`FROM`
		188	`$settings_table`
		189	`WHERE`
		190	`shops_ID = " . $shop . "`
		191	`ORDER BY`
		192	`Rang";`
		193	`}`
		194
		195	`$result_w = mysql_query( $query ) or die( mysql_errno() . ": " .`
		196	`mysql_error() . "<hr>$query<hr>" );`
		197	`if ( !mysql_num_rows( $result_w ) && $bestellart )`
		198	`{`
		199	`$query = "SELECT`
		200	`*`
		201	`FROM`
		202	`$settings_table`
		203	`WHERE`
		204	`shops_ID = " . $shop . "`
		205	`AND`
		206	`bestellart_id=" . $bestellart_id . "`
		207	`ORDER BY`
		208	`Rang`
		209	`";`
		210	`$result_w = mysql_query_logged( $query ) or die( mysql_errno() .`
		211	`": " . mysql_error() . "<hr>$query<hr>" );`
		212	`}`
		213	`while ( $zeile_w = mysql_fetch_assoc( $result_w ) )`
		214	`{`
		215	`// $web_settings[$zeile_w["shops_ID"]][$zeile_w["ID"]] = $zeile_w["Inhalt"];`
		216	`$buffer = $zeile_w["Inhalt"];`
		217	`$wsID = $zeile_w["ID"];`
		218	`if ( $wsID != 1000 )`
		219	`{`
		220	`if ( strpos( $buffer, '"' ) !== false )`
		221	`{`
		222	`$buffer = str_replace( '"', "***", $buffer );`
		223	`}`
		224	`@eval( "\$buffer=\"$buffer\";" );`
		225	`if ( strpos( $buffer, '***' ) !== false )`
		226	`{`
		227
		228	`$buffer = str_replace( '***', '"', $buffer );`
		229	`}`
		230	`}`
		231	`$web_settings[$shop][$wsID] = rawurlencode( $buffer );`
		232	`}`
		233	`if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["button" .`
		234	`$button_id] ) )`
		235	`{`
		236	`$Felddaten = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["button" .`
		237	`$button_id] );`
		238	`if ( isset( $user_rechte["Warenwirtschaft"]["bestellung"]["button" .`
		239	`$button_id] ) and ( $web_settings[$row["shops_ID"]][$Felddaten[1]] ) )`
		240	`{`
		241	`// Mail Client dazuschalten (Markus 02.07.207)`
		242	`$buttonType = isset( $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] ) ?`
		243	`"button" : "submit";`
		244	`if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] ) )`
		245	`{`
		246	`$mailData[$row["id"]][$button_id]['subject'] =`
		247	`rawurldecode( $web_settings[$row["shops_ID"]][$Felddaten[1]] );`
		248	`$mailData[$row["id"]][$button_id]['body'] = rawurldecode( $web_settings[$row["shops_ID"]][$Felddaten[2]] );`
		249	`$mailData[$row["id"]][$button_id]['inTextField'] =`
		250	`rawurldecode( $web_settings[$row["shops_ID"]][$Felddaten[3]] );`
		251	`$to = $row["E_Mail"];`
		252	`//$to = "tiefland@weban.de";`
		253	`$mailData[$row["id"]][$button_id]['mailto'] = $to;`
		254	`$FelddatenII = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] );`
		255	`if ( $FelddatenII[0] == "websettingid" )`
		256	`{`
		257	`$mailData[$row["id"]][$button_id]['mailfrom'] =`
		258	`rawurldecode( $web_settings[$row["shops_ID"]][$FelddatenII[1]] );`
		259	`}`
		260
		261	`$_SESSION['mailData'] = $mailData;`
		262	`}`
		263	`}`
		264	`}`
		265	`$sql_d = "SELECT`
		266	`id`
		267	`FROM`
		268	`dokumente`
		269	`WHERE`
		270	`data_foreign=" . $row["id"] . "`
		271	`AND`
		272	`table_foreign='Bestellung'`
		273	`AND`
		274	`document LIKE 'ebayBestaetigung%'`
		275	`";`
		276	`$res_d = mysql_query( $sql_d );`
		277	`$anz = mysql_num_rows( $res_d );`
		278	`if ( !$anz )`
		279	`{`
		280	`$_GET["shop"] = 1;`
		281	`$_POST = $_SESSION["mailData"][$row["id"]][$button_id];`
		282	`$_POST["id"] = 6;`
		283	`$_POST["Bestellung"] = $row["id"];`
		284	`$_POST["shops_ID"] = 1;`
		285	`$_POST["button"] = rawurldecode( $Felddaten[0] );`
		286	`$_POST["update"]["list"] = true;`
		287	`$_POST["adminMail"] = $_POST["mailfrom"];`
		288	`$url = "../Warenwirtschaft/MailClient/index.php";`
		289	`require $url;`
		290	`}`
		291	`}`
		292	`?>`

Subversion-Projekte lars-tiefland.content-management

(root)/trunk/cronjobs/ebay_mail.php – Revision 1