<?php
use HRNParis\main;
if (!isset($_SESSION['user'])) {
require_once 'login.php';
} else {
include_once 'controllers/main.php';
$main = new main\main();
$content = '
<!--Jquery-->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<link href="css/admin_general.css" rel="stylesheet">
<link rel="stylesheet" href="css/admin_index.css" />
<link rel="stylesheet" href="css/admin_permissions.css" />
<script src="js/admin_sponsors_permissions.js"></script>
</head>
<body>
<!--Main Wrapper-->
<div class="wrapper">
<h1 class="WrapperMainH1">HR Tech Europe - Paris 2015 | Modify Sponsor Permission</h1>
<div id="MenuIconContainer">';
if (isset($_SESSION['admin'])) {
$content .= '<a href="sponsors" title="Back To Sponsors"><img class="MenuIcon" src="img/icons/main.png" onmouseover="this.src=';
$content .= "'img/icons/main_hover.png';";
$content .= '" onmouseout="this.src=';
$content .= "'img/icons/main.png';";
$content .= '" ></a>';
<?php
use HRNParis\main;
if (!isset($_SESSION['user'])) {
require_once 'login.php';
} else {
include_once 'controllers/main.php';
$main = new main\main();
$content = '
<!--Jquery-->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<link href="css/admin_general.css" rel="stylesheet">
<link rel="stylesheet" href="css/admin_index.css" />
<link rel="stylesheet" href="css/admin_socials.css" />
<script src="js/admin_social_links_edit.js"></script>
<!--Include Font Awesome -->
<link href="http://maxcdn.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.min.css" rel="stylesheet">
</head>
<body>
<!--Main Wrapper-->
<div class="wrapper">
<h1 class="WrapperMainH1">HR Tech Europe - World Congress Site | Edit Social Links</h1>
<?php
use HRNParis\main;
use HRNParis\sponsors;
if (!isset($_SESSION['user'])) {
require_once 'login.php';
} else {
include_once 'controllers/main.php';
include_once 'controllers/sponsors_main.php';
$main = new main\main();
$sponsors = new sponsors\sponsors_main();
$content = '
<!--Jquery-->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<link href="css/admin_general.css" rel="stylesheet">
<link rel="stylesheet" href="css/admin_index.css" />
<link rel="stylesheet" href="../css/sponsors-grid.css" />
<link rel="stylesheet" href="css/admin_sponsor_tags.css" />
<script src="js/admin_sponsors_tags.js"></script>
</head>
<body>
<!--Main Wrapper-->
<div class="wrapper">
<h1 class="WrapperMainH1">HR Tech Europe - Paris 2015 | Modify Sponsor Permission</h1>
<div id="MenuIconContainer">';
$content .= '</div>
$agenda = new agenda\agenda_main();
$result = $agenda->get_category_colors();
if (isset($result)) {
echo json_encode($result);
}
}
/*/////////////
Save Booking Data
///////////////*/
if (isset($_POST['action']) && $_POST['action'] == 'save_booking_data') {
$the_main = new main\main();
$result = $the_main->save_booking($_POST['name'], $_POST['company'], $_POST['email'], $_POST['phone'], $_POST['program'], $_POST['number']);
$the_main->marketing_email($_POST['name'], $_POST['company'], $_POST['email'], $_POST['phone'], $_POST['program'], $_POST['number']);
}
/*/////////////
Save press Data
///////////////*/
if (isset($_POST['action']) && $_POST['action'] == 'save_press_data') {
$the_main = new main\main();
$the_main->press_email($_POST['first_name'], $_POST['last_name'], $_POST['company'], $_POST['email'], $_POST['phone'], $_POST['title']);
}
/*/////////////
URL decoder
///////////////*/
if (isset($_POST['action']) && $_POST['action'] == 'url_decoder') {
$the_main = new agenda\agenda_main();
$result = $the_main->decode_url($_POST['url_data']);
if (isset($result)) {
echo json_encode($result);
}
}
}
//change sponsor type
if (isset($_POST['action']) && $_POST['action'] == 'change_sponsor_type') {
$the_main = new main\main();
$agenda = new agenda\agenda_main();
$the_main->change_agenda_sponsor_type($_POST['day'], $_POST['category'], $_POST['type']);
$result = $agenda->get_sponsor_data($_POST['day'], $_POST['category']);
if (isset($result)) {
echo $result;
}
}
//add sponsor to agenda
if (isset($_POST['action']) && $_POST['action'] == 'add_sponsor_to_agenda') {
$the_main = new main\main();
$agenda = new agenda\agenda_main();
$output = $the_main->add_sponsor_to_agenda($_POST['block_id'], $_POST['sponsor_id'], $_POST['type']);
$result = $agenda->get_sponsor_data($output['agenda_day'], $output['agenda_category_id']);
if (isset($result)) {
echo $result;
}
}
//delete sponsor from agenda
if (isset($_POST['action']) && $_POST['action'] == 'delete_sponsor_from_agenda') {
$the_main = new main\main();
$agenda = new agenda\agenda_main();
$the_main->delete_sponsor_from_agenda($_POST['day'], $_POST['category'], $_POST['sponsor_id']);
$result = $agenda->get_sponsor_data($_POST['day'], $_POST['category']);
if (isset($result)) {
echo $result;
}
}
public function sponsors($category)
{
$main = new main\main();
$content = '';
//ORDER BY CASE sdc.sponsor_id WHEN 14 THEN 1 END DESC, rand() :O ilyenkor a 14-es id-jú lesz mindig az első a többi pedig random utána
//ha meg fix a sorrend akkor meg ORDER BY sdc.id DESC
//Get basic date about a sponsors
//Name Bio Category website image image alt sponsor_id
$stat_q = "SELECT sn.sponsor_name, sb.sponsor_bio, sc.category_id, sl.sponsor_link_url, sdc.sponsor_id, ss.status_id FROM sponsors_name as sn, sponsors_bio as sb, sponsors_data_connection as sdc, sponsors_status as ss, sponsors_category as sc, sponsors_links as sl WHERE sdc.sponsor_name_id=sn.id AND sdc.sponsor_bio_id=sb.id AND sdc.sponsor_id=ss.sponsor_id AND (ss.status_id='1' OR ss.status_id='3') AND sdc.sponsor_link_id=sl.id AND sdc.sponsor_category_id=sc.id AND sc.category_id= :category ORDER BY sn.sponsor_name ASC";
$stat = $this->pdo->prepare($stat_q);
$stat->bindValue(':category', $category, \PDO::PARAM_INT);
$stat->execute();
if ($stat->rowCount() > 0) {
while ($sponsors = $stat->fetch()) {
//Logo
$sponsor_logo_q = "SELECT idb.image_url, idb.alt_name FROM image_db as idb, image_connection as ic WHERE ic.entity_type_id='2' AND ic.entity_id= :id AND ic.image_db_id=idb.id";
$sponsor_logo = $this->pdo->prepare($sponsor_logo_q);
$sponsor_logo->bindValue(':id', $sponsors['sponsor_id'], \PDO::PARAM_INT);
$sponsor_logo->execute();
if ($sponsor_logo->rowCount() > 0) {
$spimage = $sponsor_logo->fetch();
$sponsors['image_url'] = $spimage['image_url'];
$sponsors['alt_name'] = $spimage['alt_name'];
} else {
$sponsors['image_url'] = '';
$sponsors['alt_name'] = '';
}
//Get the social link types
$s = 10;
$social_type_q = "SELECT id, type FROM social_link_types";
$stype = $this->pdo->prepare($social_type_q);
$stype->execute();
if ($stype->rowCount() > 0) {
while ($link_type = $stype->fetch()) {
//facebook
$social_q = "SELECT sl.social_link_url FROM social_links as sl, social_links_connection as slc WHERE slc.entity_type_id='2' AND slc.entity_id= :id AND slc.link_id=sl.id AND slc.social_link_type_id= :type ORDER BY slc.date DESC LIMIT 0,1";
$socials = $this->pdo->prepare($social_q);
$socials->bindValue(':id', $sponsors['sponsor_id'], \PDO::PARAM_INT);
$socials->bindValue(':type', $link_type['id'], \PDO::PARAM_INT);
$socials->execute();
if ($socials->rowCount() > 0) {
$link = $socials->fetch();
//facebook
$data[$s] = $link['social_link_url'];
$s++;
} else {
$data[$s] = '';
$s++;
}
}
//link type fetch ends
}
//if stype row count end
$permission = 0;
if (isset($_SESSION['user_id'])) {
//Get permission
$name_q = "SELECT id FROM sponsors_user_connection WHERE sponsors_id = :sponsor AND users_id = :user ORDER BY date DESC LIMIT 0,1";
$name = $this->pdo->prepare($name_q);
$name->bindValue(':sponsor', $sponsors['sponsor_id'], \PDO::PARAM_INT);
$name->bindValue(':user', $_SESSION['user_id'], \PDO::PARAM_INT);
$name->execute();
if ($name->rowCount() > 0) {
$permission = 1;
}
}
//A La carte data
/*
$AlaCarteData = function($sId){
$out = '';
//Get permission
$alacarte_q = "SELECT spat.text, spat.id FROM sponsors_alacarte_text as spat INNER JOIN sponsors_alacarte as sac ON spat.sponsors_alacarte_id=sac.id WHERE sac.sponsor_id = :sponsor ORDER BY spat.date";
$alacarte = $this->pdo->prepare($alacarte_q);
$alacarte->bindValue(':sponsor', $sId, \PDO::PARAM_INT);
$alacarte->execute();
if ($alacarte->rowCount() > 0) {
while($aData = $alacarte->fetch()){
$out .= '<div class="AlaCarteItem" data-alacarteid="'.$aData['id'].'">'.$aData['text'].'</div>';
}
} else {
$out .= '<div>-</div>';
}
return $out;
};
//------
*/
if (isset($_SESSION['sponsors_admin']) && ($permission == 1 || isset($_SESSION['super_admin']))) {
/*
-----------------------------
Admin
---------------------------------
*/
$achor = $this->clean_str($sponsors['sponsor_name']);
$content .= '<!-- ' . $sponsors['sponsor_name'] . ' -->
<div class="Sponsor">';
$content .= '<a id="' . $achor . '" class="anchorclass"></a>';
$content .= '<div class="ReturnValue" style="display:none"></div>';
$content .= '<div class="SystemIcons">';
//$content .=' <i data-sponsor="'.$sponsors['sponsor_id'].'" class="fa fa-pencil SysIcon SysCategories"></i>';
if (isset($_SESSION['super_admin'])) {
//$content .='<i data-sponsor="'.$sponsors['sponsor_id'].'" class="fa fa-cog SysIcon SysOptions"></i>';
}
$content .= ' <i data-sponsor="' . $sponsors['sponsor_id'] . '" class="fa fa-trash-o SysIcon SysDelete"></i>';
if (isset($_SESSION['super_admin']) && $sponsors['status_id'] == 3) {
$content .= '<div class="SysApprove" data-entity_type="2" data-sponsor="' . $sponsors['sponsor_id'] . '">Approve Sponsor</div>';
}
$content .= '</div>';
if (isset($_SESSION['sponsors_admin'])) {
$content .= '<div class="SponsorLogo dropzone" data-sponsor="' . $sponsors['sponsor_id'] . '" data-sname="' . $sponsors['sponsor_name'] . '"><img src="../img/sponsors/logos/' . $sponsors['image_url'] . '" alt="' . $sponsors['alt_name'] . '"></div>';
} else {
$content .= ' <div class="SponsorLogoNormal"><img src="../img/sponsors/logos/' . $sponsors['image_url'] . '" alt="' . $sponsors['alt_name'] . '"></div>';
}
$content .= '<div class="SponsorDetails">';
//Sponsor name
$content .= '<h2 class="SponsorName Editable" data-type="NameEdit" data-sponsor="' . $sponsors['sponsor_id'] . '">' . $sponsors['sponsor_name'] . '</h2>';
//Name edit Field
$content .= '<input class="NameEdit EditField" data-mainclass="SponsorName" style="display:none;" type="text" value="' . $sponsors['sponsor_name'] . '">';
//Sponsor link
$content .= '<i class="fa fa-external-link Editable" data-type="LinkEdit" data-sponsor="' . $sponsors['sponsor_id'] . '"></i>';
//Link edit Field
$content .= '<input class="LinkEdit EditField" data-mainclass="fa-external-link" style="display:none;" type="text" value="' . $sponsors['sponsor_link_url'] . '">';
//Sponsor Bio
$content .= '<div class="SponsorDescription" data-type="BioEdit" data-sponsor="' . $sponsors['sponsor_id'] . '">' . $sponsors['sponsor_bio'] . '</div>';
$content .= '<div class="HelpText" data-sponsor="' . $sponsors['sponsor_id'] . '">Press Esc to exit the editor!</div>';
//Bio Edit field
$content .= '<textarea class="BioEdit" data-mainclass="SponsorDescription" style="display:none;">' . $sponsors['sponsor_bio'] . '</textarea>';
//Social icons
$content .= '<div class="SponsorSocialIcons">';
$content .= '<span data-pasturl="sponsors#' . $achor . '" data-entity_id="' . $sponsors['sponsor_id'] . '" data-entity_type="2" class="SocialLinkEdit"><i class="fa fa-comment fa-2x"></i>Social Links</span>';
$content .= ' <select data-entity_id="' . $sponsors['sponsor_id'] . '" data-entity_type="2" class="SelectClass" id="Category">';
$content .= $main->sponsor_categories();
$content .= '</select>';
/*
$content .='
<div class="alacarteReturnValue" style="display:none"></div>
<br /><label><input type="checkbox" class="AddAlaCarteChekbox">New A La Carte For This Sponsor</label>
<div class="AlaCarteContainer">
<input data-sponsor="'.$sponsors['sponsor_id'].'" class="AlaCarteText AdminInputField" type="text" / >
</div>
';*/
$content .= '
<div class="AlacarteContainer">
<div></div>
<h4>A La Carte options</h4>
<div class="AlaCarteBox">';
$content .= $this->get_carted_data($sponsors['sponsor_id']);
$content .= '</div>
<div class="AlaCarteItemNew" data-sponsorid="' . $sponsors['sponsor_id'] . '">Create new A La Carte</div>
</div>
';
$content .= '</div>
</div>
</div>
<!-- END ' . $sponsors['sponsor_name'] . ' --> ';
} else {
/*
-----------------------------
Normal user
---------------------------------
*/
$content .= '<!-- ' . $sponsors['sponsor_name'] . ' -->
<div class="Sponsor">
<div class="SponsorLogo"><img src="../img/sponsors/logos/' . $sponsors['image_url'] . '" alt="' . $sponsors['alt_name'] . '"></div>
<div class="SponsorDetails">
<h2 class="SponsorName"><a class="CompanyLink" href="' . $sponsors['sponsor_link_url'] . '" target="_blank" title="' . $sponsors['sponsor_name'] . '"';
$content .= ' onClick="_gaq.push([';
$content .= "'_trackEvent', 'SponsorCompanySite', 'ExternalForward', '" . $sponsors['sponsor_name'] . "']);";
$content .= '">';
$content .= $sponsors['sponsor_name'] . ' <i class="fa fa-external-link"></i></a></h2>
<div class="SponsorDescription">' . $sponsors['sponsor_bio'] . '</div>
<div class="SponsorSocialIcons">';
if ($data[10] != '') {
$content .= '<a href="' . $data[10] . '" target="_blank" title="' . $sponsors['sponsor_name'] . ' - Facebook"';
$content .= ' onClick="_gaq.push([';
$content .= "'_trackEvent', 'SponsorSocialSite', 'ExternalForward', 'Facebook-" . $sponsors['sponsor_name'] . "']);";
$content .= '">';
$content .= '<div class="SponsorSocialIcon SponsorFacebookIcon"></div></a>';
}
if ($data[11] != '') {
$content .= '<a href="' . $data[11] . '" target="_blank" title="' . $sponsors['sponsor_name'] . ' - Twitter"';
$content .= ' onClick="_gaq.push([';
$content .= "'_trackEvent', 'SponsorSocialSite', 'ExternalForward', 'Twitter-" . $sponsors['sponsor_name'] . "']);";
$content .= '">';
$content .= '<div class="SponsorSocialIcon SponsorTwitterIcon"></div></a>';
}
if ($data[12] != '') {
$content .= '<a href="' . $data[12] . '" target="_blank" title="' . $sponsors['sponsor_name'] . ' - Linkedin"';
$content .= ' onClick="_gaq.push([';
$content .= "'_trackEvent', 'SponsorSocialSite', 'ExternalForward', 'Linkedin-" . $sponsors['sponsor_name'] . "']);";
$content .= '">';
$content .= '<div class="SponsorSocialIcon SponsorLinkedinIcon"></div></a>';
}
/*
if ($data[13] !='') {
$content .= '<a href="'.$data[13].'" target="_blank" title="'.$sponsors['sponsor_name'].' - Flickr"';
$content .=' onClick="_gaq.push([';
$content .="'_trackEvent', 'SponsorSocialSite', 'ExternalForward', 'Flickr-".$sponsors['sponsor_name']."']);";
$content .='">';
$content .= '<div class="SponsorSocialIcon SponsorFlickrinIcon"></div></a>';
}
*/
$content .= '</div>
</div>
</div>
<!-- END ' . $sponsors['sponsor_name'] . ' --> ';
}
}
//while sponsors fetch
}
//if num rows sponsors
return $content;
}
<?php use HRNParis\main; include_once 'controllers/main.php'; $main = new main\main(); ?> <!doctype html> <html lang="en"> <head> <meta name="description" content="The World's Leading Conference & Expo on HR and the Future of Work. 27-28 October, Paris."> <meta name="keywords" content="HR Conference, HR event, HR Tech, HRN Europe"> <meta name="author" content="HRN Europe - The Pan European HR Network"> <meta name="designer" content="Designed by: Judit Bernat - juditbernat.mail@gmail.com "> <meta name="developer" content="Developed by: TesseracT - bottyan.tamas@web-developer.hu, Benedek Nagy - trialshock@gmail.com, Myrrdhinn - balazs.pentek@web-developer.hu"> <meta charset="utf-8" /> <meta name="viewport" content="initial-scale=1, maximum-scale=1"> <title>HR Tech World Congress | 27–28 October | Paris</title> <!-- Open Graph data --> <meta property="og:site_name" content="HR Tech World Congress"/> <meta property="og:title" content="The Future of Work is in Paris this October – HR Tech World Congress 2015"/> <meta property="og:description" content="HR Tech World Congress 2015 – Unleash Your People!"/> <meta property="og:url" content="http://hrtechcongress.com/"> <meta property="og:type" content="website"/> <meta property="og:image" content="http://hrtechcongress.com/img/preview-images/preview-image-1.jpg" /> <meta property="og:image" content="http://hrtechcongress.com/img/preview-images/preview-image-3.jpg" /> <meta property="og:image" content="http://hrtechcongress.com/img/preview-images/preview-image-2.jpg" /> <!-- Favicon --> <link rel="apple-touch-icon" sizes="57x57" href="img/favicon/apple-touch-icon-57x57.png"> <link rel="apple-touch-icon" sizes="60x60" href="img/favicon/apple-touch-icon-60x60.png"> <link rel="apple-touch-icon" sizes="72x72" href="img/favicon/apple-touch-icon-72x72.png">
<div id="MenuIconContainer">';
if (isset($_SESSION['user'])) {
$content .= '<a title="Back to Sponsors" href="sponsors"><img alt="Back to Main Page" class="MenuIcon" src="img/icons/main.png" onmouseover="this.src=';
$content .= "'img/icons/main_hover.png';";
$content .= '" onmouseout="this.src=';
$content .= "'img/icons/main.png';";
$content .= '" ></a>';
}
$content .= '</div>
<!--Form container-->
<div id="container">';
if (isset($_SESSION['sponsors_admin'])) {
include_once 'controllers/main.php';
$main = new main\main();
if (isset($_SESSION['Result']) && $_SESSION['Result'] != '') {
$content .= '<div id="ReturnValue" style="display:none">' . $_SESSION['Result'] . '</div>';
$_SESSION['Result'] = '';
} else {
$content .= '<div id="ReturnValue" style="display:none"></div>';
}
$content .= '<form id="sponsors" action="#" name="sponsors" method="post"><br />';
$content .= '
<fieldset>
<legend>Delegate</legend>
<input class="AdminInputField" required="required" id="SponsorName" type="text" placeholder="Sponsor Name" /><br />
<input class="AdminInputField" id="SponsorURL" type="text" placeholder="Company Website" /><br />
<textarea class="TextAreaClass" id="SponsorBio" placeholder="Sponsor Bio"></textarea><br />
<select class="SelectClass" id="Category">';
$content .= $main->sponsor_categories();
<?php use HRNParis\mediapartners; use HRNParis\main; include_once 'controllers/mediapartners_main.php'; include_once 'controllers/main.php'; $main = new main\main(); $sponsors = new mediapartners\mediapartners_main(); ?> <!doctype html> <html lang="en"> <head> <meta name="description" content="The fastest growing HR event in the world. Paris October 24 - 25"> <meta name="keywords" content="HR Conference, HR Tech Europe, HR Tech Conference, HR Congress, HR Tech Congress, iRecruit, disruptHR "> <meta name="author" content="HRN Europe - The Pan European HR Network"> <meta name="developer" content="Developed by: TesseracT - bottyan.tamas@web-developer.hu, Benedek Nagy - trialshock@gmail.com, Myrrdhinn - balazs.pentek@web-developer.hu"> <meta charset="utf-8" /> <meta name="viewport" content="initial-scale=1, maximum-scale=1"> <title>HR Tech World Congress | Press</title> <!-- Open Graph data --> <meta property="og:site_name" content="HR Tech World Congress"/> <meta property="og:title" content="HR Tech World Congress | Press"/> <meta property="og:description" content="The fastest growing HR event in the world! Paris October 24 - 25"/> <meta property="og:url" content="http://hrtechcongress.com/press"> <meta property="og:type" content="website"/> <meta property="og:image" content="http://hrtechcongress.com/img/preview-images/preview-image-1.jpg" /> <meta property="og:image" content="http://hrtechcongress.com/img/preview-images/preview-image-2.jpg" /> <meta property="og:image" content="http://hrtechcongress.com/img/preview-images/preview-image-3.jpg" />
