/**
* Given some details, generate a printable packing slip.
*
* @param string $title Title of the packing slip.
* @param array $details Array of details about the packing slip.
* @param array $products Array of products for the packing slip.
* @return string Generated HTML packing slip.
*/
function generatePrintablePackingSlip($title, $details, $products)
{
$db = $GLOBALS['ISC_CLASS_DB'];
$template = new TEMPLATE('ISC_LANG');
$template->frontEnd();
$template->setTemplateBase(ISC_BASE_PATH . "/templates");
$template->panelPHPDir = ISC_BASE_PATH . "/includes/display/";
$template->templateExt = "html";
$template->setTemplate(getConfig("template"));
$template->assign('PackingSlipTitle', $title);
$template->assign('OrderId', $details['shiporderid']);
$template->assign('OrderDate', cdate($details['shiporderdate']));
if(!empty($details['shipmethod'])) {
$template->assign('ShippingMethod', isc_html_escape($details['shipmethod']));
}
else {
$template->assign('HideShippingMethod', 'display: none');
}
if(!empty($details['shiptrackno'])) {
$template->assign('TrackingNo', isc_html_escape($details['shiptrackno']));
}
else {
$template->assign('HideTrackingNo', 'display: none');
}
if(!empty($details['shipcomments'])) {
$template->assign('Comments', nl2br(isc_html_escape($details['shipcomments'])));
$template->assign('HideComments', '');
}
else {
$template->assign('Comments', '');
$template->assign('HideComments', 'display: none');
}
if(!empty($details['shipdate'])) {
$template->assign('DateShipped', cDate($details['shipdate']));
}
else {
$template->assign('HideShippingDate', 'display: none');
}
if(empty($products)) {
return false;
}
$query = "
SELECT customerid, CONCAT(custconfirstname, ' ', custconlastname) AS ordcustname, custconemail AS ordcustemail, custconphone AS ordcustphone
FROM [|PREFIX|]customers
WHERE customerid = '".$db->Quote($details['shipcustid'])."'
";
$query .= $db->AddLimit(0, 1);
$result = $db->Query($query);
$template->assign('CustomerName', '');
$template->assign('CustomerEmail', '');
$template->assign('CustomerPhone', '');
if($customer = $db->Fetch($result)) {
// Format the customer details
$template->assign('CustomerName', isc_html_escape($customer['ordcustname']));
$template->assign('CustomerEmail', isc_html_escape($customer['ordcustemail']));
$template->assign('CuastomerPhone', isc_html_escape($customer['ordcustphone']));
$template->assign('CustomerId', $customer['customerid']);
}
else {
$template->assign('HideCustomerDetails', 'display: none');
}
$template->assign('StoreAddressFormatted', nl2br(GetConfig('StoreAddress')));
$addressDetails = array(
'shipfirstname' => $details['shipbillfirstname'],
'shiplastname' => $details['shipbilllastname'],
'shipcompany' => $details['shipbillcompany'],
'shipaddress1' => $details['shipbillstreet1'],
'shipaddress2' => $details['shipbillstreet2'],
'shipcity' => $details['shipbillsuburb'],
'shipstate' => $details['shipbillstate'],
'shipzip' => $details['shipbillzip'],
'shipcountry' => $details['shipbillcountry'],
'countrycode' => $details['shipbillcountrycode'],
);
$template->assign('BillingAddress', ISC_ADMIN_ORDERS::buildOrderAddressDetails($addressDetails, false));
$template->assign('BillingPhone', isc_html_escape($details['shipbillphone']));
if(!$details['shipbillphone']) {
$template->assign('HideBillingPhone', 'display: none');
}
$template->assign('BillingEmail', isc_html_escape($details['shipbillemail']));
if(!$details['shipbillemail']) {
$template->assign('HideBillingEmail', 'display: none');
}
$addressDetails = array(
'shipfirstname' => $details['shipshipfirstname'],
'shiplastname' => $details['shipshiplastname'],
'shipcompany' => $details['shipshipcompany'],
'shipaddress1' => $details['shipshipstreet1'],
'shipaddress2' => $details['shipshipstreet2'],
'shipcity' => $details['shipshipsuburb'],
'shipstate' => $details['shipshipstate'],
'shipzip' => $details['shipshipzip'],
'shipcountry' => $details['shipshipcountry'],
'countrycode' => $details['shipshipcountrycode'],
);
$template->assign('ShippingAddress', ISC_ADMIN_ORDERS::buildOrderAddressDetails($addressDetails, false));
$template->assign('ShippingPhone', isc_html_escape($details['shipshipphone']));
if(!$details['shipshipphone']) {
$template->assign('HideShippingPhone', 'display: none');
}
$template->assign('ShippingEmail', isc_html_escape($details['shipshipemail']));
if(!$details['shipshipemail']) {
$template->assign('HideShippingEmail', 'display: none');
}
$fieldsArray = array();
$query = "
SELECT o.*
FROM [|PREFIX|]order_configurable_fields o
JOIN [|PREFIX|]product_configurable_fields p ON o.fieldid = p.productfieldid
WHERE o.orderid=".(int)$details['shiporderid']."
ORDER BY p.fieldsortorder ASC
";
$result = $db->Query($query);
$fields = array();
while ($row = $db->Fetch($result)) {
$fieldsArray[$row['ordprodid']][] = $row;
}
// Build the list of products that are being shipped
$productsTable = '';
foreach($products as $product) {
$template->assign('ProductName', isc_html_escape($product['prodname']));
if($product['prodcode']) {
$template->assign('ProductSku', isc_html_escape($product['prodcode']));
}
else {
$template->assign('ProductSku', getLang('NA'));
}
$template->assign('ProductQuantity', $product['prodqty']);
$pOptions = '';
if($product['prodoptions'] != '') {
$options = @unserialize($product['prodoptions']);
if(!empty($options)) {
foreach($options as $name => $value) {
$template->assign('FieldName', isc_html_escape($name));
$template->assign('FieldValue', isc_html_escape($value));
$pOptions .= $template->GetSnippet('PrintableInvoiceItemConfigurableField');
}
}
}
if($pOptions) {
$template->assign('ProductOptions', $pOptions);
$template->assign('HideVariationOptions', '');
}
else {
$template->assign('HideVariationOptions', 'display: none');
}
$productFields = '';
if(!empty($fieldsArray[$product['prodordprodid']])) {
$fields = $fieldsArray[$product['prodordprodid']];
foreach($fields as $field) {
if(empty($field['textcontents']) && empty($field['filename'])) {
continue;
}
$fieldValue = '-';
$template->assign('FieldName', isc_html_escape($field['fieldname']));
if($field['fieldtype'] == 'file') {
$fieldValue = '<a href="'.GetConfig('ShopPath').'/'.GetConfig('ImageDirectory').'/configured_products/'.urlencode($field['originalfilename']).'">'.isc_html_escape($field['originalfilename']).'</a>';
}
else {
$fieldValue = isc_html_escape($field['textcontents']);
}
$template->assign('FieldValue', $fieldValue);
$productFields .= $template->getSnippet('PrintableInvoiceItemConfigurableField');
}
}
$template->assign('ProductConfigurableFields', $productFields);
if(!$productFields) {
$template->assign('HideConfigurableFields', 'display: none');
}
else {
$template->assign('HideConfigurableFields', '');
}
if($product['prodeventdatename']) {
$template->assign('FieldName', isc_html_escape($product['prodeventdatename']));
$template->assign('FieldValue', isc_date('dS M Y', $product['prodeventdate']));
$template->assign('ProductEventDate', $template->getSnippet('PrintableInvoiceItemConfigurableField'));
$template->assign('HideEventDate', '');
}
else {
$template->assign('ProductEventDate', '');
$template->assign('HideEventDate', 'display: none');
}
$productsTable .= $template->GetSnippet('PrintablePackingSlipItem');
}
$template->assign('ProductsTable', $productsTable);
$template->setTemplate('packing_slip_print');
return $template->parseTemplate(true);
}
$points_counter = $data[0]['Relevance'];
}
//Save the parameters :
if (isset($_POST['save'])) {
$name = isset($_POST['p_caver_name']) ? $_POST['p_caver_name'] : '';
$surname = isset($_POST['p_caver_surname']) ? $_POST['p_caver_surname'] : '';
//$login = (isset($_POST['p_caver_login'])) ? $_POST['p_caver_login'] : '';
$nickname = isset($_POST['p_caver_nickname']) ? $_POST['p_caver_nickname'] : '';
$country = isset($_POST['p_caver_country']) ? $_POST['p_caver_country'] : '';
$region = isset($_POST['p_caver_region']) ? $_POST['p_caver_region'] : '';
$city = isset($_POST['p_caver_city']) ? $_POST['p_caver_city'] : '';
$facebook = isset($_POST['p_caver_facebook']) ? $_POST['p_caver_facebook'] : '';
$postal = isset($_POST['p_caver_postal']) ? $_POST['p_caver_postal'] : '';
$address = isset($_POST['p_caver_address']) ? $_POST['p_caver_address'] : '';
$birth = isset($_POST['p_caver_birth']) ? $_POST['p_caver_birth'] : '';
$birth = cDate($birth, true);
$contact = isset($_POST['p_caver_contact']) ? $_POST['p_caver_contact'] : '';
$initiation = isset($_POST['p_caver_initiation']) ? $_POST['p_caver_initiation'] : '';
$language = isset($_POST['p_caver_language']) ? $_POST['p_caver_language'] : '';
if ($language == "" || $language == Select_default) {
$language = $_SESSION['language'];
}
$public = isset($_POST['p_caver_public']) ? $_POST['p_caver_public'] : '';
$alert_for_news = isset($_POST['p_caver_news']) ? $_POST['p_caver_news'] : '';
$show_links = isset($_POST['p_caver_links']) ? $_POST['p_caver_links'] : '';
$detail_level = isset($_POST['p_caver_detail_level']) ? $_POST['p_caver_detail_level'] : '';
$latitude = isset($_POST['p_caver_latitude']) ? $_POST['p_caver_latitude'] : '';
$longitude = isset($_POST['p_caver_longitude']) ? $_POST['p_caver_longitude'] : '';
$custom_message = isset($_POST['p_caver_message']) ? $_POST['p_caver_message'] : '';
$picture_file_name = isset($_POST['p_caver_file']) ? $_POST['p_caver_file'] : '';
$sql = "UPDATE `" . $_SESSION['Application_host'] . "`.`T_caver` ";
/**
* Given a gift certificate code, apply it to the quote.
*
* @throws ISC_QUOTE_EXCEPTION when the gift certificate cannot be applied
* @param string $code Gift certificate code.
* @return ISC_QUOTE This quote instance.
*/
public function applyGiftCertificate($code)
{
// First check if we have a valid gift certificate
$certificate = $this->fetchGiftCertificate($code);
// Invalid gift certificate code was entered
if (!$certificate['giftcertid'] || $certificate['giftcertbalance'] == 0) {
throw new ISC_QUOTE_EXCEPTION(getLang('BadGiftCertificateInvalid'));
}
// This gift certificate has expired
if ($certificate['giftcertstatus'] == 4 ||
($certificate['giftcertexpirydate'] != 0 && time() >= $certificate['giftcertexpirydate'])) {
if ($certificate['giftcertstatus'] != 4) {
$updatedCertificate = array(
'giftcertstatus' => 4
);
$GLOBALS['ISC_CLASS_DB']->updateQuery(
'gift_certificates',
$updatedCertificate,
"giftcertid='".$GLOBALS['ISC_CLASS_DB']->quote($certificate['giftcertid'])."'"
);
}
if ($certificate['giftcertexpirydate'] != 0) {
throw new ISC_QUOTE_EXCEPTION(
sprintf(getLang('BadGiftCertificateExpired'), cDate($certificate['giftcertexpirydate']))
);
}
else {
throw new ISC_QUOTE_EXCEPTION(getLang('BadGiftCertificateInvalid'));
}
}
$certificate = array(
'code' => $code,
'id' => $certificate['giftcertid'],
'amount' => $certificate['giftcertamount'],
'balance' => $certificate['giftcertbalance'],
'expiry' => $certificate['giftcertexpirydate']
);
return $this->addGiftCertificate($certificate);
}
/**
* This file is part of GrottoCenter.
*
* GrottoCenter is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* GrottoCenter is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with GrottoCenter. If not, see <http://www.gnu.org/licenses/>.
*
* @copyright Copyright (c) 2009-2012 Cl�ment Ronzon
* @license http://www.gnu.org/licenses/agpl.txt
*/
function getProperties($category, $id, $isConnected, $labelsBlank, $labelsSinceDate, $addTitle, $systemArray = array(), $for_printer = false, $opener)
{
switch ($category) {
case "entry":
$AvgAe = getAvgAestheticism($id);
$sqlAe = "SELECT round(Aestheticism) AS Aestheticism FROM `" . $_SESSION['Application_host'] . "`.`T_comment` WHERE Id_entry=" . $id;
$AvgCa = getAvgCaving($id);
$sqlCa = "SELECT round(Caving) AS Caving FROM `" . $_SESSION['Application_host'] . "`.`T_comment` WHERE Id_entry=" . $id;
$AvgAp = getAvgApproach($id);
$sqlAp = "SELECT round(Approach) AS Approach FROM `" . $_SESSION['Application_host'] . "`.`T_comment` WHERE Id_entry=" . $id;
if (!$addTitle) {
$histoAe = "<div onclick=\"JavaScript:infoHistoAe();\" class=\"histo\"><img src=\"" . getHistoSrc($sqlAe, 'Aestheticism') . "\" alt=\"image\" /></div>\n";
$histoCa = "<div onclick=\"JavaScript:infoHistoCa();\" class=\"histo\"><img src=\"" . getHistoSrc($sqlCa, 'Caving') . "\" alt=\"image\" /></div>\n";
$histoAp = "<div onclick=\"JavaScript:infoHistoAp();\" class=\"histo\"><img src=\"" . getHistoSrc($sqlAp, 'Approach') . "\" alt=\"image\" /></div>\n";
} else {
$histoAe = "";
$histoCa = "";
$histoAp = "";
}
$sql = "SELECT cat.*, ty." . $_SESSION['language'] . "_type AS typeName, ca.Name as NetwName, ca.Id as NetwId, ma.Name AS MasName, ma.Id AS MasId, ";
//$sql .= "IF(ISNULL(ca.Id)=1,eybis.Min_depth,ca.Min_depth) AS Min_depth, ";
//$sql .= "IF(ISNULL(ca.Id)=1,eybis.Max_depth,ca.Max_depth) AS Max_depth, ";
$sql .= "IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth) AS Depth, ";
$sql .= "IF(ISNULL(ca.Id)=1,eybis.Is_diving,ca.Is_diving) AS Is_diving, ";
$sql .= "IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length) AS Length, ";
$sql .= "IF(ISNULL(ca.Id)=1,eybis.Temperature,ca.Temperature) AS Temperature, ";
$sql .= "IF(ISNULL(ca.Id)=1,NULL,(SELECT COUNT(*) FROM `" . $_SESSION['Application_host'] . "`.`J_cave_entry` WHERE ca.Id = Id_cave)) AS NumberOfEntries, ";
$sql .= "GROUP_CONCAT(DISTINCT u.Url ORDER BY u.Url SEPARATOR '<br />\n') AS Partners ";
$sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_entry` cat ";
$sql .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`T_single_entry` eybis ON cat.Id = eybis.Id ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_type` ty ON cat.Id_type = ty.Id ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_cave_entry` ce ON cat.Id = ce.Id_entry ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_cave` ca ON ce.Id_cave = ca.Id ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_massif_cave` mc ON (mc.Id_cave = ca.Id OR mc.Id_entry = cat.Id) ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_massif` ma ON ma.Id = mc.Id_massif ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_entry_url` eu ON eu.Id_entry = cat.Id ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_url` u ON u.Id = eu.Id_url ";
break;
case "cave":
$listSQL = "SELECT DISTINCT e.Id, e.Name ";
$listSQL .= "FROM `" . $_SESSION['Application_host'] . "`.`T_entry` e ";
$listSQL .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`J_cave_entry` ce ON ce.Id_entry = e.Id ";
$listSQL .= "WHERE ce.Id_cave = " . $id . " AND e.Is_public = 'YES' ";
if (!$isConnected) {
$listSQL .= "AND e.Is_public = 'YES' ";
}
$listSQL .= "ORDER BY e.Name ";
$entryList = getDataFromSQL($listSQL, __FILE__, "function", __FUNCTION__);
$entriesList = "";
for ($index = 0; $index < $entryList["Count"]; $index++) {
$entriesList .= "<a href=\"JavaScript:openMe(" . $entryList[$index]['Id'] . ", 'entry', false);\">" . $entryList[$index]['Name'] . "</a>, ";
}
$entriesList = substr($entriesList, 0, strlen($entriesList) - 2);
$sql = "SELECT cat.*, ma.Name AS MasName, ma.Id AS MasId ";
$sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_cave` cat ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_massif_cave` mc ON mc.Id_cave = cat.Id ";
$sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_massif` ma ON ma.Id = mc.Id_massif ";
break;
case "massif":
$listSQL = "SELECT COUNT(*) AS Nb, ";
$listSQL .= "-MAX(ABS(IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth))) AS Max_Depth, ";
$listSQL .= "MAX(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Max_Length, ";
$listSQL .= "SUM(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Sum_Length, ";
$listSQL .= "-AVG(ABS(IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth))) AS Avg_Depth, ";
$listSQL .= "STD(ABS(IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth))) AS Std_Depth, ";
$listSQL .= "AVG(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Avg_Length, ";
$listSQL .= "STD(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Std_Length ";
$listSQL .= "FROM `" . $_SESSION['Application_host'] . "`.`T_entry` e ";
$listSQL .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`T_single_entry` eybis ON e.Id = eybis.Id ";
$listSQL .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_cave_entry` ce ON e.Id = ce.Id_entry ";
$listSQL .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_cave` ca ON ca.Id = ce.Id_cave ";
$listSQL .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_massif_cave` mc ON (mc.Id_cave = ce.Id_cave OR mc.Id_entry = e.Id) ";
$listSQL .= "WHERE mc.Id_massif = " . $id . " ";
$entriesStats = getDataFromSQL($listSQL, __FILE__, "function", __FUNCTION__);
default:
$sql = "SELECT cat.* ";
$sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_" . $category . "` cat ";
break;
}
$sql .= "WHERE cat.Id = " . $id . " ";
if (!$isConnected && $category == "entry") {
$sql .= "AND cat.Is_public = 'YES' ";
}
if ($category == "entry") {
$sql .= "GROUP BY cat.Id ";
$sql .= "ORDER BY MasName DESC ";
}
$data = getDataFromSQL($sql, __FILE__, $opener, __FUNCTION__);
if ($data['Count'] > 0) {
$is_public = $data[0]['Contact_is_public'];
$is_shown = $category == "caver" && ($is_public == Contact_for_registered && $isConnected || $is_public == Contact_for_everybody) || $category != "caver";
if ($addTitle) {
if (isset($data[0]['Nickname'])) {
$title_name = $data[0]['Nickname'];
} else {
$title_name = $data[0]['Name'];
}
$innerHTML .= getTopMenu(getCloseBtn("JavaScript:resetDetails();", "<convert>#label=371<convert>") . "<div class=\"frame_title\">" . setTitle("#", "details", "<convert>#label=440<convert> " . $title_name, 1) . "</div>");
//A propos de
}
if ($is_shown) {
$innerHTML .= getInnerLine($data[0]['Name'], $data[0]['Name'], "<convert>#label=199<convert> :");
//Nom
}
$innerHTML .= getInnerLine($entriesList, $entriesList, "<convert>#label=384<convert> :");
//Entrées :
$innerHTML .= getInnerLine($entriesStats[0]['Nb'], $entriesStats[0]['Nb'], "<convert>#label=384<convert> :");
//Entrées :
$innerHTML .= getInnerLine($entriesStats[0]['Max_Depth'], round($entriesStats[0]['Max_Depth']), "<convert>#label=758<convert> :", "", "<convert>#label=268<convert>");
//Prof. Max. ://m
$innerHTML .= getInnerLine($entriesStats[0]['Avg_Depth'], round($entriesStats[0]['Avg_Depth']), "<convert>#label=759<convert> :", "", "<convert>#label=268<convert>");
//Prof. Moy. ://m
$innerHTML .= getInnerLine($entriesStats[0]['Std_Depth'], round($entriesStats[0]['Std_Depth']), "<convert>#label=760<convert> :", "", "<convert>#label=268<convert>");
//E.Type Prof. ://m
$innerHTML .= getInnerLine($entriesStats[0]['Max_Length'], round($entriesStats[0]['Max_Length']), "<convert>#label=761<convert> :", "", "<convert>#label=268<convert>");
//Dev. Max. ://m
$innerHTML .= getInnerLine($entriesStats[0]['Sum_Length'], round($entriesStats[0]['Sum_Length']), "<convert>#label=762<convert> :", "", "<convert>#label=268<convert>");
//Dev. Total ://m
$innerHTML .= getInnerLine($entriesStats[0]['Avg_Length'], round($entriesStats[0]['Avg_Length']), "<convert>#label=763<convert> :", "", "<convert>#label=268<convert>");
//Dev. Moy. ://m
$innerHTML .= getInnerLine($entriesStats[0]['Std_Length'], round($entriesStats[0]['Std_Length']), "<convert>#label=764<convert> :", "", "<convert>#label=268<convert>");
//E.Type Dev. ://m
if ($isConnected) {
$innerHTML .= getInnerLine($data[0]['Locked'], convertYN($data[0]['Locked'], "<convert>#label=441<convert>", "<convert>#label=442<convert>"), "<convert>#label=443<convert> :");
//Oui //Non //Est en cours de modification
$innerHTML .= getInnerLine($data[0]['Is_public'], convertYN($data[0]['Is_public'], "<convert>#label=441<convert>", "<convert>#label=442<convert>"), "<convert>#label=444<convert> :");
//Est publique
}
$innerHTML .= getInnerLine($data[0]['typeName'], $data[0]['typeName'], "<convert>#label=114<convert> :");
//Type de sous-sol
if ($is_shown) {
$innerHTML .= getInnerLine($data[0]['Surname'], $data[0]['Surname'], "<convert>#label=200<convert> :");
//Prénom
}
$innerHTML .= getInnerLine($data[0]['Nickname'], $data[0]['Nickname'], "<convert>#label=34<convert> :");
//Alias
if ($is_shown) {
$innerHTML .= getInnerLine($data[0]['Date_birth'], timeToStr($data[0]['Date_birth']), "<convert>#label=445<convert> ", "", "<convert>#label=446<convert>", getSinceDateFromD(cDate($data[0]['Date_birth'], false), $labelsBlank), "", "<convert>#label=447<convert>");
//Né(e) le //(mm/jj/aaaa) //ans
}
$innerHTML .= getInnerLine($data[0]['Year_discovery'], $data[0]['Year_discovery'], "<convert>#label=109<convert> :", "", "", getSinceDateFromD("01/01/" . $data[0]['Year_discovery'], $labelsSinceDate));
//Année de découverte
$innerHTML .= getInnerLine($data[0]['Year_birth'], $data[0]['Year_birth'], "<convert>#label=147<convert> :", "", "", getSinceDateFromD("01/01/" . $data[0]['Year_birth'], $labelsSinceDate));
//Année de fondation
if ($is_shown) {
//$innerHTML .= getInnerLine($data[0]['Date_inscription'],"<br />".timeToStr($data[0]['Date_inscription']),"<convert>#label=448<convert> ".$_SESSION['Application_name']." :","","<convert>#label=446<convert><br />",getSinceDateFromD(cDate($data[0]['Date_inscription'],false),$labelsSinceDate));//Date d'inscription à //(mm/jj/aaaa)
$innerHTML .= getInnerLine($data[0]['Connection_counter'], $data[0]['Connection_counter'], "<convert>#label=449<convert> ", "", "<convert>#label=450<convert> " . $_SESSION['Application_name']);
//S'est connecté //fois sur
//$innerHTML .= getInnerLine($data[0]['Date_last_connection'],"<br />".timeToStr($data[0]['Date_last_connection']),"<convert>#label=24<convert> :","","<convert>#label=446<convert><br />",getSinceDateFromDT(cDate($data[0]['Date_last_connection'],false),$labelsSinceDate));//Dernière connection //(mm/jj/aaaa)
}
if ($isConnected) {
//$innerHTML .= getInnerLine($data[0]['Date_reviewed'],"<br />".timeToStr($data[0]['Date_reviewed']),"<convert>#label=451<convert> :","","<convert>#label=446<convert><br />",getSinceDateFromDT(cDate($data[0]['Date_reviewed'],false),$labelsSinceDate));//Dernière modification //(mm/jj/aaaa)
}
if ($is_shown) {
$innerHTML .= getInnerLine($data[0]['Year_initiation'], $data[0]['Year_initiation'], "<convert>#label=204<convert> :");
//Année d'initiation à la spéléo
if ($category == "entry") {
$innerHTML .= getInnerLine($data[0]['Contact'], $data[0]['Contact'], "<convert>#label=741<convert> :");
//Contact
} else {
$innerHTML .= getInnerLine($data[0]['Contact'], $data[0]['Contact'], "<convert>#label=146<convert> :", "mailto:" . $data[0]['Contact']);
//Contact
}
if (isset($data[0]['City'])) {
$innerHTML .= "<div class=\"detail_line\"><span class=\"details_label\"><convert>#label=102<convert> :</span><br />\n";
//Adresse
if ($category != "entry") {
$innerHTML .= getInnerLine($data[0]['Address'], $data[0]['Address']) . "<br />\n";
}
$innerHTML .= getInnerLine($data[0]['City'], $data[0]['Postal_code'] . " " . $data[0]['City']) . "<br />\n";
$innerHTML .= getInnerLine($data[0]['Region'], $data[0]['Region'] . ", " . strtoupper(getCountry($_SESSION['language'], $data[0]['Country']))) . "<br />\n";
$innerHTML .= "</div>";
} else {
$innerHTML .= getInnerLine($data[0]['Country'], getCountry($_SESSION['language'], $data[0]['Country']), "<convert>#label=98<convert> :");
//Pays
}
$innerHTML .= getInnerLine($data[0]['Language'], $data[0]['Language'], "<convert>#label=205<convert> :");
//Langue
}
if ($is_shown) {
if ($data[0]['Latitude'] != "" && $data[0]['Longitude'] != "") {
$innerHTML .= "<div class=\"detail_line\"><span class=\"details_label\"><convert>#label=660<convert></span>";
$innerHTML .= " <span class=\"details_data\"><convert>#label=286<convert></span></div>";
//Système géodésique //(GPS) - WGS84 Décimal
$innerHTML .= getInnerLine($data[0]['Latitude'], round($data[0]['Latitude'], 5), "<convert>#label=103<convert> :", "", "<convert>#label=104<convert> <convert>#label=293<convert>.");
//Latitude //degrés N.
$innerHTML .= getInnerLine($data[0]['Longitude'], round($data[0]['Longitude'], 5), "<convert>#label=105<convert> :", "", "<convert>#label=104<convert> <convert>#label=294<convert>.");
//Longitude //degrés S.
$innerHTML .= "<div class=\"detail_line\"><input type=\"button\" name=\"convert\" class=\"button1\" value=\"<convert>#label=31<convert>...\" onclick=\"JavaScript:";
$innerHTML .= "openWindow('converter_" . $_SESSION['language'] . ".php?c=coords&lat=" . $data[0]['Latitude'] . "&lng=" . $data[0]['Longitude'] . "&i=" . $data[0]['Country'] . "&readonly=true', '', 434, 260);\" /></div>";
//<!--Convertisseur...-->
}
}
$innerHTML .= getInnerLine($data[0]['Altitude'], $data[0]['Altitude'], "<convert>#label=106<convert> :", "", "<convert>#label=66<convert>");
//Altitude //mètres
$innerHTML .= getInnerLine($data[0]['NetwId'], $data[0]['NetwName'], "<convert>#label=453<convert>", "JavaScript:detailMarker(undefined, 'cave', " . $data[0]['NetwId'] . ", '" . $_SESSION['language'] . "')", "", $data[0]['NumberOfEntries'], "<convert>#label=454<convert>", "<convert>#label=455<convert>");
//Fait partie du réseau //ayant //entrées
$innerHTML .= getInnerLine($data[0]['MasId'], $data[0]['MasName'], "<convert>#label=560<convert> ", "JavaScript:detailMarker(undefined, 'massif', " . $data[0]['MasId'] . ", '" . $_SESSION['language'] . "')");
//Fait partie du massif
//$innerHTML .= getInnerLine($data[0]['Min_depth'],$data[0]['Min_depth'],"<convert>#label=456<convert> :","","<convert>#label=66<convert>");//Profondeur Min. //mètres
//$innerHTML .= getInnerLine($data[0]['Max_depth'],$data[0]['Max_depth'],"<convert>#label=457<convert> :","","<convert>#label=66<convert>");//Profondeur Max. //mètres
$innerHTML .= getInnerLine($data[0]['Depth'], $data[0]['Depth'], "<convert>#label=64<convert> :", "", "<convert>#label=66<convert>");
//Profondeur Min. //mètres
$innerHTML .= getInnerLine($data[0]['Length'], $data[0]['Length'], "<convert>#label=68<convert> :", "", "<convert>#label=66<convert>");
//Développement //mètres
$innerHTML .= getInnerLine($data[0]['Temperature'], $data[0]['Temperature'], "<convert>#label=69<convert> :", "", "<convert>#label=70<convert>");
//Température //degrés celsius
$innerHTML .= getInnerLine($data[0]['Is_diving'], convertYN($data[0]['Is_diving'], "<convert>#label=441<convert>", "<convert>#label=442<convert>"), "<convert>#label=71<convert> :");
//Oui //Non //Spéléo. plongée
if ($category == "entry") {
$innerHTML .= getInnerLine($data[0]['Partners'], replaceLinks($data[0]['Partners']), "<convert>#label=670<convert> :<br />\n");
//Sites partenaires
}
$innerHTML .= getInnerLine($AvgAe, round($AvgAe, 1), "<convert>#label=458<convert> :", "", "<convert>#label=459<convert>");
//Intérêt ///10
if (isset($AvgAe)) {
$innerHTML .= $histoAe;
}
$innerHTML .= getInnerLine($AvgCa, round($AvgCa, 1), "<convert>#label=460<convert> :", "", "<convert>#label=459<convert>");
//Progression ///10
if (isset($AvgCa)) {
$innerHTML .= $histoCa;
}
$innerHTML .= getInnerLine($AvgAp, round($AvgAp, 1), "<convert>#label=461<convert> :", "", "<convert>#label=459<convert>");
//Accès ///10
if (isset($AvgAp)) {
$innerHTML .= $histoAp;
}
if ($category == "entry" && $addTitle) {
$innerHTML .= "<a href=\"#\" onclick=\"JavaScript:detailMarker(event, 'entry', '" . $id . "', '" . $_SESSION['language'] . "',true, {'geodesic': '" . $systemArray["geodesic"] . "','length': '" . $systemArray["length"] . "','temperature': '" . $systemArray["temperature"] . "'});\" title=\"<convert>#label=184<convert>\" style=\"color:red;\"><!--Voir la fiche détaillée de cette entrée-->\n";
$innerHTML .= "<convert>#label=185<convert>\n";
//Fiche détaillée...
$innerHTML .= "</a><br />\n";
}
if ($isConnected && allowAccess(properties_view_all)) {
$innerHTML .= "### Reserved for webmasters: ###<br />\n";
foreach ($data[0] as $key => $value) {
if ($key != "Custom_message") {
$innerHTML .= "<b>" . $key . "</b> : <i>" . replaceLinks(nl2br($value)) . "</i><br />\n";
}
}
}
}
if ($addTitle) {
$innerHTML .= getBotMenu();
}
$innerHTML = "<div class=\"menu\">" . $innerHTML . "</div>";
return $innerHTML;
}
function setSession($status, $data = "")
{
$_SESSION['user_connected'] = $status;
if ($status) {
$_SESSION['user_id'] = $data['Id'];
$_SESSION['user_name'] = $data['Name'];
$_SESSION['user_surname'] = $data['Surname'];
$_SESSION['user_login'] = $data['Login'];
$_SESSION['user_nickname'] = $data['Nickname'];
$_SESSION['user_last_connection'] = cDate($data['Date_last_connection'], false);
$_SESSION['user_country'] = $data['Country'];
$_SESSION['user_region'] = $data['Region'];
$_SESSION['user_city'] = $data['City'];
$_SESSION['user_postal'] = $data['Postal_code'];
$_SESSION['user_address'] = $data['Address'];
$_SESSION['user_birth'] = cDate($data['Date_birth'], false);
$_SESSION['user_contact'] = $data['Contact'];
$_SESSION['user_initiation'] = $data['Year_initiation'];
$_SESSION['user_language'] = $data['Language'];
$_SESSION['language'] = $_SESSION['user_language'];
$_SESSION['user_public'] = $data['Contact_is_public'];
$_SESSION['user_hover'] = $data['Show_links'];
$_SESSION['user_detail_level'] = $data['Detail_level'];
$_SESSION['user_latitude'] = $data['Latitude'];
$_SESSION['user_longitude'] = $data['Longitude'];
$_SESSION['user_default_lat'] = $data['Default_latitude'];
$_SESSION['user_default_lng'] = $data['Default_longitude'];
$_SESSION['user_default_zoom'] = $data['Default_zoom'];
$_SESSION['user_message'] = $data['Custom_message'];
$_SESSION['user_facebook'] = $data['Facebook'];
$_SESSION['user_file'] = $data['Picture_file_name'];
$_SESSION['user_banned'] = $data['Banned'];
$_SESSION['user_news'] = $data['Alert_for_news'];
$_SESSION['user_utcoffset'] = $data['Utc_offset'];
$_SESSION['user_timezone'] = $data['Id_time_zone'];
// $_SESSION['user_timeformat'] = $data['Time_format'];
$_SESSION['user_rights'] = getUserRights($_SESSION['user_id']);
$_SESSION['user_lastactivitydate'] = 0;
}
}
