/** * 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; } }