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 />