function transformManifest($xml, $dir)
{
$lJson = new stdClass();
if (isset($xml['object'])) {
$lJson->object = (string) $xml['object'];
}
if (isset($xml->manifests)) {
$lJson->manifests = new stdClass();
foreach ($xml->manifests->manifest as $manifest) {
$lPath = (string) $manifest;
$lType = (string) $manifest['type'];
$lJson->manifests->{$lType} = $lPath;
}
}
if (isset($xml->types)) {
$lJson->types = new stdClass();
foreach ($xml->types->type as $type) {
$lType = (string) $type['id'];
$lJson->types->{$lType} = new stdClass();
$lJson->types->{$lType}->properties = getProperties($type->properties);
}
}
$lJson->properties = new stdClass();
$lJson->properties = getProperties($xml->properties);
file_put_contents($dir . '/manifest.json', json_encode($lJson));
}
/**
* Class constructor
*
* @param array $initValues Initial object properties.
*
* @return void
*/
public final function __construct(array $initValues = array())
{
$this->__vars = getProperties($this);
if (isset($this->ID)) {
unset($this->ID);
}
foreach ($initValues as $key => $values) {
if (is_numeric($key[0])) {
continue;
}
$this->{$key} = $values;
}
}
function Connect_db()
{
if (($properties = getProperties()) != null) {
$host = $properties["host"];
$user = $properties["user"];
$password = $properties["password"];
$bdname = $properties["bdname"];
} else {
$host = "localhost";
$user = "******";
$password = "";
$bdname = "ptut";
}
try {
$bdd = new PDO('mysql:host=' . $host . ';dbname=' . $bdname . ';charset=utf8', $user, $password);
return $bdd;
} catch (Exception $e) {
die('Erreur: ' . $e->getMessage());
}
}
/**
* Read EXIF/IPTC data of a file
*
* Pulls the metadata from an item
*
* @param string $file filename to read metadata from
* @return array The EXIF/IPTC items for this file
*
* This code from here to the end of this file was borrowed from
* the Gallery v2 EXIF module written by:
* Bharat Mediratta <*****@*****.**>
* Georg Rehfeld <*****@*****.**>
*
*/
function ExifProcessor($file)
{
$rawExifData = array();
$iptc = new JPEG($file);
$rawExifData = read_exif_data_raw($file, false);
$exifKeys = getExifKeys();
// builds an array of the EXIF data we care about...
$properties = getProperties();
$results = array();
$pCount = count($properties);
if ($pCount > 0) {
foreach ($properties as $property) {
$title = $exifKeys[$property][0];
for ($i = 1; $i < sizeof($exifKeys[$property]); $i++) {
$value = getExifValue($rawExifData, explode('.', $exifKeys[$property][$i]));
if (!isset($value)) {
$value = getIptcValue($iptc, explode('.', $exifKeys[$property][$i]));
}
if (isset($value)) {
$value = postProcessValue($property, $value);
$results[] = array('title' => $title, 'value' => $value);
break;
}
}
}
}
return $results;
}
<?php
if (isset($_SESSION['user']) && $_SESSION['user'] != '' && $_SESSION['type'] != 2) {
// User is logged in and not a staff member, determine if they are an admin or owner
require $relative . 'data/php/database/pdo.inc';
if ($_SESSION['type'] == 3) {
if (isset($_GET['owner']) && $_GET['owner'] != '') {
// Find owner's properties
echo getProperties($_GET['owner']);
} else {
$errors = array();
echo '<h2>Select Owner</h2>';
include $relative . 'data/php/owner/properties.inc';
}
} else {
// Find owner's properties
echo getProperties($_SESSION['user']);
}
} else {
if (!isset($_SESSION['user']) || $_SESSION['user'] == '') {
// Go to login page
header("Location: http://{$_SERVER['HTTP_HOST']}/{$topDir}user/login.php");
} else {
echo '<label>Page not found</label>';
}
}
?>
</div>
<!-- MAIN CONTENT ENDS -->
<?php
require $relative . 'data/php/site/footer.inc';
?>
?>
<div id="uriDiv" style="position:absolute;top:105px;left:50%;display:none;visibility:hidden;width:300px;white-space:nowrap;"><input type="text" class="input1" name="uriForGuest" id="uriForGuest" value="" /> <b><a href="JavaScript:hideId('uriDiv');" title="<convert>#label=371<convert>">X</a><!-- Fermer --></b></div>
</div>
<div id="body">
<!--#################### MAP ################################################-->
<div id="map" class="div_2_l" style="height:250px;">
</div>
<!--#################### PROPERTIES #########################################-->
<div id="properties" class="div_2_l">
<h2><convert>#label=333<convert><!--Propriétés--></h2>
<?php
$geodesic = isset($_GET['geodesic']) ? $_GET['geodesic'] : '';
$length = isset($_GET['length']) ? $_GET['length'] : '';
$temperature = isset($_GET['temperature']) ? $_GET['temperature'] : '';
$systemArray = array("geodesic" => urldecode(stripslashes($geodesic)), "length" => urldecode(stripslashes($length)), "temperature" => urldecode(stripslashes($temperature)));
echo getProperties($category, $id, USER_IS_CONNECTED, $labelsBlank, $labelsSinceDate, false, $systemArray, isset($_POST['print']), "file_" . $_SESSION['language'] . ".php?category=" . $category . "&id=" . $id);
?>
<span id="hidden_name" style="display:none;visibility:hidden;"><?php
echo $entryName;
?>
</span>
</div>
<!--#################### INPUT AREA #########################################-->
<div id="input_area" class="div_2_r">
<textarea class="input1" rows="5" cols=""></textarea>
</div>
<!--#################### LICENSE ############################################-->
<div id="license" class="credit div_2_l" style="text-align:center;">
<?php
echo getLicense(1);
?>
function import($store, $csv_file, $delete_old_items, $categories)
{
$folder = getContactsFolder($store);
// open the csv file and start reading
$fh = fopen($csv_file, "r");
if (!$fh) {
trigger_error("Can't read CSV file \"" . $csv_file . "\".", E_USER_ERROR);
}
// Delete all existing items if requested.
if ($delete_old_items) {
mapi_folder_emptyfolder($folder, DEL_ASSOCIATED);
printf("Old items deleted.\n");
}
$properties = getProperties();
$properties = replaceStringPropertyTags($store, $properties);
//composed properties which require more work
$special_properties = getSpecialPropertyNames();
$csv_mapping = getMapping();
$i = 1;
while (!feof($fh)) {
$line = fgetcsv($fh, CSV_MAX_LENGTH, CSV_DELIMITER, CSV_ENCLOSURE);
// print_r($line);
if (!$line) {
continue;
}
if ($i == 1 && defined('FIELD_NAMES') && FIELD_NAMES) {
$i++;
continue;
}
$propValues = array();
//set "simple" properties
foreach ($csv_mapping as $property => $cnt) {
if (!in_array($property, $special_properties)) {
setProperty($property, $line[$csv_mapping[$property]], $propValues, $properties);
}
}
// set display name
if (isset($csv_mapping["display_name"]) && isset($line[$csv_mapping["display_name"]])) {
$name = to_windows1252($line[$csv_mapping["display_name"]]);
$propValues[$properties["display_name"]] = $propValues[$properties["subject"]] = $propValues[$properties["fileas"]] = $name;
$propValues[$properties["fileas_selection"]] = -1;
} else {
$propValues[$properties["display_name"]] = $propValues[$properties["subject"]] = $propValues[$properties["fileas"]] = "";
if (isset($propValues[$properties["given_name"]])) {
$propValues[$properties["display_name"]] .= $propValues[$properties["given_name"]];
$propValues[$properties["subject"]] .= $propValues[$properties["given_name"]];
}
if (isset($propValues[$properties["surname"]])) {
if (strlen($propValues[$properties["display_name"]]) > 0) {
$propValues[$properties["display_name"]] .= " " . $propValues[$properties["surname"]];
$propValues[$properties["subject"]] .= " " . $propValues[$properties["surname"]];
} else {
$propValues[$properties["display_name"]] .= $propValues[$properties["surname"]];
$propValues[$properties["subject"]] .= $propValues[$properties["surname"]];
}
}
if (isset($propValues[$properties["surname"]])) {
$propValues[$properties["fileas"]] .= $propValues[$properties["surname"]];
}
if (isset($propValues[$properties["given_name"]])) {
if (strlen($propValues[$properties["fileas"]]) > 0) {
$propValues[$properties["fileas"]] .= ", " . $propValues[$properties["given_name"]];
} else {
$propValues[$properties["fileas"]] .= $propValues[$properties["given_name"]];
}
}
}
$nremails = array();
$abprovidertype = 0;
if (isset($csv_mapping["email_address_1"]) && isset($line[$csv_mapping["email_address_1"]])) {
setEmailAddress($line[$csv_mapping["email_address_1"]], $propValues[$properties["display_name"]], 1, $propValues, $properties, $nremails, $abprovidertype);
}
if (isset($csv_mapping["email_address_2"]) && isset($line[$csv_mapping["email_address_2"]])) {
setEmailAddress($line[$csv_mapping["email_address_2"]], $propValues[$properties["display_name"]], 2, $propValues, $properties, $nremails, $abprovidertype);
}
if (isset($csv_mapping["email_address_3"]) && isset($line[$csv_mapping["email_address_3"]])) {
setEmailAddress($line[$csv_mapping["email_address_3"]], $propValues[$properties["display_name"]], 3, $propValues, $properties, $nremails, $abprovidertype);
}
if (!empty($nremails)) {
$propValues[$properties["address_book_mv"]] = $nremails;
}
$propValues[$properties["address_book_long"]] = $abprovidertype;
//set addresses
if (isset($csv_mapping["home_address_street2"])) {
mergeStreet("home", $line[$csv_mapping["home_address_street2"]], $propValues, $properties);
}
if (isset($csv_mapping["home_address_street3"])) {
mergeStreet("home", $line[$csv_mapping["home_address_street3"]], $propValues, $properties);
}
if (!isset($propValues[$properties["home_address"]]) && isset($propValues[$properties["home_address_street"]]) && isset($propValues[$properties["home_address_postal_code"]]) && isset($propValues[$properties["home_address_city"]]) && isset($propValues[$properties["home_address_state"]]) && isset($propValues[$properties["home_address_country"]])) {
buildAddressString("home", $propValues[$properties["home_address_street"]], $propValues[$properties["home_address_postal_code"]], $propValues[$properties["home_address_city"]], $propValues[$properties["home_address_state"]], $propValues[$properties["home_address_country"]], $propValues, $properties);
}
if (isset($csv_mapping["business_address_street2"])) {
mergeStreet("business", $line[$csv_mapping["business_address_street2"]], $propValues, $properties);
}
if (isset($csv_mapping["business_address_street3"])) {
mergeStreet("business", $line[$csv_mapping["business_address_street3"]], $propValues, $properties);
}
if (!isset($propValues[$properties["business_address"]]) && isset($propValues[$properties["business_address_street"]]) && isset($propValues[$properties["business_address_postal_code"]]) && isset($propValues[$properties["business_address_city"]]) && isset($propValues[$properties["business_address_state"]]) && isset($propValues[$properties["business_address_country"]])) {
buildAddressString("business", $propValues[$properties["business_address_street"]], $propValues[$properties["business_address_postal_code"]], $propValues[$properties["business_address_city"]], $propValues[$properties["business_address_state"]], $propValues[$properties["business_address_country"]], $propValues, $properties);
}
if (isset($csv_mapping["other_address_street2"])) {
mergeStreet("other", $line[$csv_mapping["other_address_street2"]], $propValues, $properties);
}
if (isset($csv_mapping["other_address_street3"])) {
mergeStreet("other", $line[$csv_mapping["other_address_street3"]], $propValues, $properties);
}
if (!isset($propValues[$properties["other_address"]]) && isset($propValues[$properties["other_address_street"]]) && isset($propValues[$properties["other_address_postal_code"]]) && isset($propValues[$properties["other_address_city"]]) && isset($propValues[$properties["other_address_state"]]) && isset($propValues[$properties["other_address_country"]])) {
buildAddressString("other", $propValues[$properties["other_address_street"]], $propValues[$properties["other_address_postal_code"]], $propValues[$properties["other_address_city"]], $propValues[$properties["other_address_state"]], $propValues[$properties["other_address_country"]], $propValues, $properties);
}
if (isset($propValues[$properties["home_address"]])) {
$propValues[$properties["mailing_address"]] = 1;
setMailingAdress($propValues[$properties["home_address_street"]], $propValues[$properties["home_address_postal_code"]], $propValues[$properties["home_address_city"]], $propValues[$properties["home_address_state"]], $propValues[$properties["home_address_country"]], $propValues[$properties["home_address"]], $propValues, $properties);
} elseif (isset($propValues[$properties["business_address"]])) {
$propValues[$properties["mailing_address"]] = 2;
setMailingAdress($propValues[$properties["business_address_street"]], $propValues[$properties["business_address_postal_code"]], $propValues[$properties["business_address_city"]], $propValues[$properties["business_address_state"]], $propValues[$properties["business_address_country"]], $propValues[$properties["business_address"]], $propValues, $properties);
} elseif (isset($propValues[$properties["other_address"]])) {
$propValues[$properties["mailing_address"]] = 3;
setMailingAdress($propValues[$properties["other_address_street"]], $propValues[$properties["other_address_postal_code"]], $propValues[$properties["other_address_city"]], $propValues[$properties["other_address_state"]], $propValues[$properties["other_address_country"]], $propValues[$properties["other_address"]], $propValues, $properties);
}
if (isset($categories) && !empty($categories)) {
setProperty("categories", $categories, $propValues, $properties);
}
// if the display name is set, then it is a valid contact: save it to the folder
if (isset($propValues[$properties["display_name"]])) {
$propValues[$properties["message_class"]] = "IPM.Contact";
$propValues[$properties["icon_index"]] = "512";
$message = mapi_folder_createmessage($folder);
mapi_setprops($message, $propValues);
mapi_savechanges($message);
printf("New contact added: \"%s\".\n", $propValues[$properties["display_name"]]);
}
$i++;
}
}
include "../properties_" . $_SESSION['language'] . ".php";
$frame = "details";
header("Content-type: text/plain");
//Capture the action type :
$type = isset($_GET['type']) ? $_GET['type'] : '';
switch ($type) {
case "details":
$id = isset($_GET['id']) ? $_GET['id'] : '';
$category = isset($_GET['category']) ? $_GET['category'] : '';
$labelsBlank = array("", "", "", "", "", "", "");
$isConnected = USER_IS_CONNECTED;
$geodesic = isset($_GET['geodesic']) ? $_GET['geodesic'] : '';
$length = isset($_GET['length']) ? $_GET['length'] : '';
$temperature = isset($_GET['temperature']) ? $_GET['temperature'] : '';
$systemArray = array("geodesic" => urldecode(stripslashes($geodesic)), "length" => urldecode(stripslashes($length)), "temperature" => urldecode(stripslashes($temperature)));
$innerHTML = getProperties($category, $id, $isConnected, $labelsBlank, $labelsSinceDate, true, $systemArray, false, __FILE__);
break;
case "list_caver":
$id = isset($_GET['id']) ? $_GET['id'] : '';
$category = isset($_GET['category']) ? $_GET['category'] : '';
// $sql = "SELECT ca.Id AS objectId, 'caver' AS category, Ifnull(co.".$_SESSION['language']."_name,'<convert>#label=512<convert>') AS country, ca.Id AS value, CONCAT(if(ca.Name is null AND ca.Surname is null,'',CONCAT(if(ca.Name is null,'',CONCAT(ca.Name, ' ')),if(ca.Surname is null,'',CONCAT(ca.Surname , ' ')),'<convert>#label=34<convert> ')), ca.Nickname) As NName ";
$sql = "SELECT ca.Id AS objectId, 'caver' AS category, Ifnull(co." . $_SESSION['language'] . "_name,'<convert>#label=512<convert>') AS country, ca.Id AS value, ca.Nickname As NName ";
$sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_caver` ca ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_country` co ON ca.Country = co.Iso ";
$sql .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`J_" . $category . "_caver` ec ON ca.Id = ec.Id_caver ";
$sql .= "WHERE ec.Id_" . $category . " = " . $id . " ";
$sql .= "ORDER BY country, NName ";
$comparedCol = "value";
$countryCol = "country";
$idCol = "objectId";
$categoryCol = "category";
