private static function _initPathConst()
{
define('ROOT_PATH', getCWD() . '/Demo/');
// 自定义excel对应的根目录
define('EXCEL_PATH', ROOT_PATH . 'excelFile/');
define('LUA_PATH', ROOT_PATH . 'outputLua/');
define('XML_PATH', ROOT_PATH . 'outputXml/');
define('XML_ROOT_NAME', 'config');
}
public static function getRoot()
{
$cwd = isset($_SERVER['phpspec']) ? 'api' : getCWD();
$first_dir = explode('/', $_SERVER['REQUEST_URI']);
$first_dir = $first_dir[1];
$path_array = explode('/', $cwd);
$path = array();
$count = count($path_array);
for ($p = 0; $p < $count; $p++) {
if ($path_array[$p] === $first_dir) {
break;
}
}
for ($p; $p < $count; $p++) {
array_push($path, $path_array[$p]);
}
return '/' . implode('/', $path) . '/';
}
function sixWeeks()
{
require str_replace('/admin', '', getCWD()) . '/config/siteSettings.php';
if (!$attendanceInterval) {
$attendanceInterval = 42;
}
//set default
$this->dbcnx();
$sql = "select count(*) as total from NDKP_attendancetype \n\t\t\t\twhere DATE_SUB(CURDATE(), INTERVAL {$attendanceInterval} DAY) <= date";
$dbi = mysql_query($sql) or die(mysql_error());
$r = mysql_fetch_object($dbi);
return $r->total;
}
<?php
$url = $_GET["url"];
$filepath = realpath(getCWD() . "/" . $url);
if (file_exists($filepath)) {
$info = parse_url($filepath);
$pathInfo = pathinfo($info["path"]);
if (strpos($url, "public/") === 0) {
// Rewrite to real URL
header("Location:" . $system["contentUrl"] . $url);
exit;
} else {
if (strpos($url, "lib/") === 0 || strpos($url, "data/") === 0) {
if (isset($pathInfo["extension"])) {
$ext = strtolower($pathInfo["extension"]);
} else {
$ext = "";
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Disposition: filename=" . $pathInfo["basename"]);
header("Content-Transfer-Encoding: binary");
if ($ext === "php" && strpos($url, "lib/") === 0) {
if (strpos(file_get_contents($filepath), "//EXTERNAL") > 0) {
include $filepath;
} else {
header("HTTP/1.0 403 Forbidden");
}
} else {
if (isset($info["scheme"])) {
function doVcards($single, $extension, $targetcode, $zip)
{
$sql = "select * from tempcsvdata where uid = '" . $_SESSION["loginCRM"] . "' order by id";
$csvdata = $_SESSION['db']->getAll($sql);
if ($csvdata) {
$pfad = $_SESSION["login"] . "/vcard";
chkdir($pfad, '.');
$pfad = "../dokumente/" . $_SESSION["dbname"] . "/" . $pfad . "/";
$felder = explode(":", $csvdata[0]["csvdaten"]);
$personen = False;
if (in_array("TITEL", $felder)) {
$personen = True;
}
$i = 0;
foreach ($felder as $feld) {
$felder[$feld] = $i++;
}
array_shift($csvdata);
if ($single) {
if ($personen) {
$filename = "Pvcard." . $extension;
} else {
$filename = "Fvcard." . $extension;
}
$f = fopen($pfad . $filename, "w");
}
$srvcode = strtoupper($_SESSION["charset"]);
$cnt = 0;
foreach ($csvdata as $row) {
$vcard = new Contact_Vcard_Build();
if ($targetcode != $srvcode) {
$row["csvdaten"] = iconv($srvcode, $targetcode, $row["csvdaten"]);
}
$data = explode(":", $row["csvdaten"]);
$vcard->setFormattedName($data[$felder["NAME1"]]);
if ($data[$felder["NAME2"]]) {
if ($personen) {
$vcard->setName($data[$felder["NAME2"]], $data[$felder["NAME1"]], "", $data[$felder["ANREDE"]], $data[$felder["TITEL"]]);
} else {
$vcard->setName($data[$felder["NAME1"]], $data[$felder["NAME2"]], "", "", "");
}
} else {
if ($personen) {
$vcard->setName($data[$felder["NAME1"]], "", "", $data[$felder["ANREDE"]], $data[$felder["TITEL"]]);
} else {
$vcard->setName($data[$felder["NAME1"]], "", "", "", "");
}
}
$vcard->addAddress('', '', $data[$felder["STRASSE"]], $data[$felder["ORT"]], '', $data[$felder["PLZ"]], $data[$felder["LAND"]]);
$vcard->addParam('TYPE', 'WORK');
if ($personen) {
$vcard->addOrganization($data[$felder["FIRMA"]]);
} else {
$vcard->addOrganization($data[$felder["NAME1"]]);
$vcard->addOrganization($data[$felder["NAME2"]]);
}
if ($data["email"]) {
$vcard->addEmail($data[$felder["EMAIL"]]);
$vcard->addParam('TYPE', 'WORK');
}
if ($data["phone"]) {
$vcard->addTelephone($data[$felder["TEL"]]);
$vcard->addParam('TYPE', 'WORK');
}
if ($data["fax"]) {
$vcard->addTelephone($data[$felder["FAX"]]);
$vcard->addParam('TYPE', 'FAX');
}
// get back the vCard and print it
$text = $vcard->fetch();
if (!$single) {
if ($personen) {
$f = fopen($pfad . "/" . $data[$felder["ID"]] . $data[$felder["NAME1"]] . "_vcard." . $extension, "w");
} else {
$f = fopen($pfad . "/" . $data[$felder["KDNR"]] . "_vcard." . $extension, "w");
}
fputs($f, $text);
fclose($f);
} else {
fputs($f, $text);
}
unset($vcard);
unset($text);
$cnt++;
}
if ($single) {
fclose($f);
}
if ($zip) {
require 'pclzip.lib.php';
require 'zip.lib.php';
if (!$single) {
$oldpath = getCWD();
chdir($pfad);
$archiveFiles = glob("*_vcard." . $extension);
chdir($oldpath);
} else {
//$archiveFiles[] = "vcard.".$_POST["extension"];
$archiveFiles[] = $filename;
}
$filename = "vcard." . $extension . ".zip";
$archive = new PclZip($pfad . $filename);
$v_list = $archive->create($pfad . $_SESSION["login"], '', $pfad . $_SESSION["login"], '', "vcardPreAdd");
$zip = new zipfile();
for ($i = 0; $i < count($archiveFiles); $i++) {
$file = $archiveFiles[$i];
// zip.lib dirty hack
$fp = fopen($pfad . $file, "r");
$content = @fread($fp, filesize($pfad . $file));
fclose($fp);
$zip->addFile($content, $file);
unlink($pfad . $file);
}
$fp = fopen($pfad . $filename, "w+");
fputs($fp, $zip->file());
fclose($fp);
}
if ($single || $zip) {
echo "[<a href='" . $pfad . $filename . "'>download</a>]<br />";
} else {
}
}
echo "{$cnt} Adressen bearbeitet.";
}
