CONTENIDO Forum

Code: Alles auswählen

<?php
/*****************************************
* File      :   $RCSfile: include.recipients_import.php,v $
* Project   :   Contenido
* Descr     :   Frontend user editor
* Modified  :   $Date: 2005/12/11 18:48:25 $
*
* © four for business AG, www.4fb.de, generated by HerrB
*
* $Id: include.recipients_import.php,v 1.3 2005/12/11 18:48:25 bbehrens Exp $
******************************************/
cInclude("classes", "widgets/class.widgets.page.php");
cInclude("classes", "class.ui.php");
cInclude("classes", "class.htmlelements.php");
cInclude("classes", "class.newsletter.recipients.php");

$oPage       = new cPage;
$oRecipients = new RecipientCollection;

if (is_array($cfg['plugins']['recipients'])) {
	foreach ($cfg['plugins']['recipients'] as $plugin) {
		plugin_include("recipients", $plugin."/".$plugin.".php");	
	}
}

$aFields 		= array();
$aFieldDetails	= array();
$aFields["name"]						= strtolower(i18n("Name"));
$aFieldDetails["name"]["mandatory"]		= false;
$aFieldDetails["name"]["type"]			= "string";
$aFieldDetails["name"]["plugin"]		= false;
$aFieldDetails["name"]["col"]			= -1;
$aFields["email"]						= strtolower(i18n("Mail"));
$aFieldDetails["email"]["mandatory"]	= true;
$aFieldDetails["email"]["type"]			= "string";
$aFieldDetails["email"]["plugin"]		= false;
$aFieldDetails["email"]["col"]			= -1;
$aFields["deactivated"]					= strtolower(i18n("Deactivated"));
$aFieldDetails["active"]["mandatory"]	= false;
$aFieldDetails["active"]["type"]		= "boolean";
$aFieldDetails["active"]["plugin"]		= false;
$aFieldDetails["active"]["col"]			= -1;
$aFields["confirmed"]					= strtolower(i18n("Confirmed"));
$aFieldDetails["confirmed"]["mandatory"]= false;
$aFieldDetails["confirmed"]["type"]		= "boolean";
$aFieldDetails["confirmed"]["plugin"]	= false;
$aFieldDetails["confirmed"]["col"]		= -1;
$aFields["confirmeddate"]					= strtolower(i18n("Confirmed Date"));
$aFieldDetails["confirmeddate"]["mandatory"]= false;
$aFieldDetails["confirmeddate"]["type"]		= "string";
$aFieldDetails["confirmeddate"]["plugin"]	= false;
$aFieldDetails["confirmeddate"]["col"]		= -1;

/* Check out if there are any plugins */
if (is_array($cfg['plugins']['recipients'])) {
	foreach ($cfg['plugins']['recipients'] as $sPlugin) {
		if (function_exists("recipients_".$sPlugin."_wantedVariables") && function_exists("recipients_".$sPlugin."_store")) {
			$aPluginTitles = call_user_func("recipients_".$sPlugin."_canonicalVariables");
    		$aPluginFields = call_user_func("recipients_".$sPlugin."_wantedVariables");
    		foreach ($aPluginFields as $sField) {
    			if ($_REQUEST["ckb".$sField]) {
    				$aFields[$sField]					= strtolower(str_replace(" ","", $aPluginTitles[$sField]));
    				$aFieldDetails[$sField]["mandatory"]= true;
    				$aFieldDetails[$sField]["type"]		= "string";
    				$aFieldDetails[$sField]["plugin"]	= $sPlugin;
    				$aFieldDetails[$sField]["col"]		= -1;
    			}
    		}
    	}
	}
}

if ($action == "recipients_import_exec" && $perm->have_perm_area_action("recipients", "recipients_create")) {	
	$_REQUEST["txtData"] = trim(stripslashes($_REQUEST["txtData"]));

	if ($_REQUEST["txtData"]) {
		//echo "<pre>".nl2br(stripslashes($_REQUEST["txtData"]))."</pre>";
		$aLines 		= explode("\n", stripslashes($_REQUEST["txtData"]));
		$iAdded     	= 0;
		$iDublettes 	= 0;
		$iInvalid   	= 0;
		$iRow       	= 0;
		$iCol       	= 0;
		$bStop      	= false;
		$sMessage		= "";
		$aMessage   	= array();
		$aInvalidLines	= array();

		foreach($aLines as $sLine) {
			$iRow++;

			$aParts = explode(chr(9), trim($sLine));
			
			if ($iRow == 1) {
				$aInvalidLines[] = $sLine;
				
				foreach ($aParts as $sHeader) {
					$sKey = array_search(strtolower(htmlentities(trim($sHeader))), $aFields);
					if ($sKey === false) {
						$aMessage[] = sprintf(mi18n("Given column header '%s' unknown, column ignored"), $sHeader);
                	} else {
                		$aFieldDetails[$sKey]["col"] = $iCol;
						$iCol++;
					}
				}
				foreach ($aFieldDetails as $sKey => $aDetails) {
					if ($aDetails["mandatory"] && $aDetails["col"] == -1) {
						$aMessage[] = sprintf(mi18n("Mandatory column '%s' wasn't found, import stopped"), $aDetails[$sKey]);
						$bStop = true;
					}
				}
				if ($bStop) {
					exit;
				} else {
					$_REQUEST["txtData"] = "";
            	}
			} else {
				$sEMail = trim($aParts[$aFieldDetails["email"]["col"]]);
				if ($aFieldDetails["name"]["col"] > -1) {
					$sName = trim($aParts[$aFieldDetails["name"]["col"]]);
					if ($sName == "") {
						$sName = $sEMail;
					}
				} else {
					$sName = $sEMail;
				}
				if ($sEMail == "") {
					$aMessage[] = sprintf(mi18n("Item with empty mail address found, item ignored (name: %s, row: %s)"), $sName, $iRow);
					$aInvalidLines[] = $sLine;
					$iInvalid++;
				} else if (!isValidMail($sEMail)) {
					$aMessage[] = sprintf(mi18n("Mail address '%s' is invalid, item ignored (row: %s)"), $sEMail, $iRow);
					$aInvalidLines[] = $sLine;
					$iInvalid++;
				} else if ($oRecipients->emailExists($sEMail)) {
               		$aMessage[] = sprintf(mi18n("Recipient with mail address '%s' already exists, item skipped (row: %s)"), $sEMail, $iRow);
               		$aInvalidLines[] = $sLine;
					$iDublettes++;
				} else {
					unset ($sLine);
					if ($oRecipient = $oRecipients->create($sEMail, $sName)) {
						$iAdded++;
						unset($aPluginValue);
						$aPluginValue = array();
						
						foreach ($aFieldDetails as $sKey => $aDetails) {
							if ($aDetails["col"] > -1) {
								if ($aDetails["plugin"] == false) {
									if ($aDetails["type"] == "boolean") {
										$sValue = strtolower(trim($aParts[$aDetails["col"]]));
										
										if ($sValue == "yes" || $sValue == i18n("yes") || $sValue == "true" || (is_numeric($sValue) && $sValue > 0)) {
											$oRecipient->set($sKey, 1);
										} else {
											$oRecipient->set($sKey, 0);
										}
									} else {
										$sValue = trim($aParts[$aDetails["col"]]);
										$oRecipient->set($sKey, $sValue);
									}
								} else {
									// type may be mentioned here, also, but as plugins currently can't
									// specify the type, just treat everything as string
									
									// There may be plugins which store more than one value per plugin_store-
									// function. As the plugin_store parameter is an array of values, collect
									// all values in an array for later storing... unfortunately, that means,
									// that we have to go through the fields array second time per item *sigh*
									$aPluginValue[$aDetails["plugin"]][$sKey] = trim($aParts[$aDetails["col"]]);
								}
							}
						}
						// Store all base data
						$oRecipient->store();
						
						// Store plugin data (to store plugin data, only, where the column has been found in the data
						// should be faster than going through all plugins and store mostly empty arrays) 
						$sCurrentPlugin = "";
						foreach ($aFieldDetails as $sKey => $aDetails) {
							if ($aDetails["col"] > -1 && $aDetails["plugin"] && $aDetails["plugin"] !== $sCurrentPlugin) {
								$sCurrentPlugin = $aDetails["plugin"];
								
								call_user_func("recipients_".$sCurrentPlugin."_store", $aPluginValue[$sCurrentPlugin]);
							}
						}
					}
				}
			}
		}
		if (count($aInvalidLines) > 1) {
			$_REQUEST["txtData"] = implode("\n", $aInvalidLines);
		}
		if (count($aMessage) > 0) {
			$sMessage = $notification->returnNotification("warning", implode("<br />", $aMessage))."<br />";
		}
		$sMessage .= $notification->returnNotification("info", sprintf(i18n("%d recipients added, %d recipients skipped (email already exists) and %d invalid recipients/e-mail adresses ignored. Invalid recipients are shown (if any)."), $iAdded, $iDublettes, $iInvalid));
		if ($iAdded > 0) {
			$oPage->setReload();
		}
	}
}
		
$oForm = new UI_Table_Form("properties");
$oForm->setVar("frame", $frame);
$oForm->setVar("area", $area);
$oForm->setVar("action", "recipients_import_exec");

$oForm->addHeader(i18n("Import recipients"));

$oAreaData = new cHTMLTextarea("txtData", $_REQUEST["txtData"], 80, 20);

$sInfo = sprintf(i18n("Insert recipients using this format: <data><tab><data>... - each recipient in a new line.".
					  "<br />The first line must contain the column names; this specifies the column order, ".
					  "<br />e.g. name mail -> first column contains the name, the second the mail address.".
					  "<br /><br />Example:<br />name mail<br />Smith jon.smith@domain.tld".
					  "<br /><br />The following column names will be recognized:<br />%s"), implode("<br />", $aFields));
			  
$oForm->add(i18n("Recipients"), $oAreaData->render()."<br />".$sInfo);
unset ($sInfo);

$oPage->setContent($sMessage.$oForm->render(true));
$oPage->render();
?>

Code: Alles auswählen

/* Create a link to purge subscribed but not confirmed recipients */

Code: Alles auswählen

/* Create a link to import recipients */
$oLink = new cHTMLLink;
$oLink->setMultiLink("recipients", "", "recipients_import", "recipients_import");
$oLink->setContent('<img style="padding-right: 4px;" src="'.$cfg["path"]["images"] . 'users_add.gif" align="middle">'.i18n("Import recipients").'</a>');

$sContent .= $oLink->render().'<br />'.chr(10);

Code: Alles auswählen

<?php
echo "Folgende Datein sind unterhalb von Daten in der Dateiverwaltung hinterlegt";

//List aus in dem Verzeichnis ist
$d = dir("upload/x_csv-upload/");
while($inhalt = $d->read()) {
  echo $inhalt . "<br>\n";
  $neu = $inhalt;
  }
$d->close();

// Datei oeffnen
$id="99";
$id2="299";
$fp = fopen("upload/x_csv-upload/".$neu."", "r");

//Ziel für die erzeugte Datei
$Datei = "upload/x_sql-download/erzeugteliste.sql";

//Zieldatei öffnen
$FilePointer = fopen($Datei, "w");

//Daten von Datei 1 auslesen und in Datei 2 schreiben
while($data = fgetcsv($fp, 8192, ";"))
{
		$num= count ($data);
		$id++;
		$id2++;
		
		//Ändert das @-Zeichen um
		$mail=str_replace('@', '%40', $data[0]);
		$Text = "INSERT INTO `con_news_rcp` (`idnewsrcp`, `idclient`, `idlang`, `email`, `confirmed`, `confirmeddate`, `lastaction`, `name`, `hash`, `deactivated`, `author`, `created`, `lastmodified`, `modifiedby`) VALUES ($id, 1, 1, '$mail', 1, '2006-07-19 00:00:00', NULL, '', 'hash-Schlüssel...bdd17960cf5', 0, 'Admin-Schlüssel...21232f29', '2006-07-19 00:00:00', '2006-07-19 00:00:00', 'Admin-Schlüssel...21232f29');\n";
		fwrite($FilePointer, $Text);
		/*echo "INSERT INTO `con_properties` (`idproperty`, `idclient`, `itemtype`, `itemid`, `type`, `name`, `value`, `author`, `created`, `modified`, `modifiedby`) VALUES ($id2, 1, 'idnewsrcp', '$id', 'contact', 'lastname', '$data[2]', 'nobody', ' ', ' ', 'nobody');";
		echo "<br>\n";
		$id2++;
		echo "INSERT INTO `con_properties` (`idproperty`, `idclient`, `itemtype`, `itemid`, `type`, `name`, `value`, `author`, `created`, `modified`, `modifiedby`) VALUES ($id2, 1, 'idnewsrcp', '$id', 'contact', 'firstname', '$data[1]', 'nobody', ' ', ' ', 'nobody');";  		  		
		echo "<br>\n";
		*/
}
echo "<br>";
echo $id-99;
echo " Datensätze wurden eingetragen, die SQL-Datei wurde erzeugt und kann gedownloaded werde!<br>Link: <a href='upload/x_sql-download/erzeugteliste.sql'>erzeugteliste.sql</a>";
fclose ($fp);
fclose($FilePointer);
?>