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;
}
$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();
$content .= '</select>
<br /><br /><label><input type="checkbox" id="Alacarte"> A La Carte Sponsor</label>
<div id="AlaCarteField" style="display:none">
<input class="AdminInputField" id="AlaCarteText" type="text" placeholder="A La Carte text" />
<label><input type="checkbox" id="OnlyAlacarte">A La Carte Sponsor ONLY!</label>
</div>
</fieldset>';
$content .= '
<fieldset>
<legend>Social links</legend>
<input class="AdminInputField" id="Facebook" type="text" placeholder="Facebook" /><br />
<input class="AdminInputField" id="Twitter" type="text" placeholder="Twitter" /><br />
<input class="AdminInputField" id="Linkedin" type="text" placeholder="Linkedin" /><br />
<input class="AdminInputField" id="Flickr" type="text" placeholder="Flicker" /><br />
