public function saveUser(Sponsor $user)
{
$userData = $user->getArrayData();
if ($this->getUser($user->uid) == NULL) {
// SI NO EXISTE EL USUARIO
$this->tableGateway->insert($userData);
} else {
$this->tableGateway->update($userData, array('UID' => $user->uid));
}
}
public function run()
{
$faker = Faker::create();
foreach (range(1, 10) as $index) {
Sponsor::create([]);
}
}
public function testHeaderWithSponsor()
{
$header = Header::create()->withTitle(H1::create()->appendText('Big Top Title ')->appendText(Bold::create()->appendText('in Bold')))->withSubTitle(H2::create()->appendText('Smaller SubTitle ')->appendText(Bold::create()->appendText('in Bold')))->withKicker(H3::create()->appendText('Kicker ')->appendText(Bold::create()->appendText('in Bold')))->withSponsor(Sponsor::create()->withPageUrl('http://facebook.com/my-sponsor'));
$expected = '<header>' . '<h1>Big Top Title <b>in Bold</b></h1>' . '<h2>Smaller SubTitle <b>in Bold</b></h2>' . '<h3 class="op-kicker">Kicker <b>in Bold</b></h3>' . '<ul class="op-sponsors">' . '<li>' . '<a href="http://facebook.com/my-sponsor" rel="facebook"></a>' . '</li>' . '</ul>' . '</header>';
$rendered = $header->render();
$this->assertEquals($expected, $rendered);
}
public function testRenderWithSponsor()
{
$list = Sponsor::create()->withPageUrl('http://facebook.com/my-sponsor');
$expected = '<ul class="op-sponsors">' . '<li>' . '<a href="http://facebook.com/my-sponsor" rel="facebook"></a>' . '</li>' . '</ul>';
$rendered = $list->render();
$this->assertEquals($expected, $rendered);
}
public static function createFromData(\stdClass $data)
{
/** @var static $object */
$object = parent::createBaseFromData($data);
if (isset($data->parent_uuid)) {
$object->parentUuid = $data->parent_uuid;
}
if (isset($data->contacts)) {
$object->contactInformation = ContactInformation::createFromData($data->contacts);
}
if (isset($data->content)) {
foreach ($data->content as $contentData) {
$object->content[] = Content::createFromData($contentData);
}
}
if (isset($data->map)) {
$object->map = Map::createFromData($data->map);
}
if (isset($data->sponsors)) {
foreach ($data->sponsors as $sponsorData) {
$object->sponsors[] = Sponsor::createFromData($sponsorData);
}
}
return $object;
}
/**
*
* Simple login function.
* @param $username string Username
* @param $password string Password
* @return boolean
*
*/
public function login($username, $password, $encrypted = false)
{
// valid login requires status_id to be 1, in addition to matching email and password. The status_id indicates email has been confirmed.
if (!$encrypted) {
$sql_raw = "SELECT sponsor_id, region_id, region_type FROM sponsor WHERE email='{$username}' AND password='******'";
} else {
$sql_raw = "SELECT sponsor_id, region_id, region_type FROM sponsor WHERE email='{$username}' AND password='******'";
}
$sql_raw = "SELECT sponsor_id FROM sponsor WHERE email='{$username}'";
if ($data = db()->Get_Row($sql_raw)) {
$sponsor = new Sponsor($data['sponsor_id']);
$_SESSION['admin_id'] = $sponsor->id();
$_SESSION['region_id'] = $sponsor->region_id();
$_SESSION['region_type'] = $sponsor->region_type();
return true;
}
return false;
}
public static function initForTeam(&$team)
{
$sponsorsStore = array();
$sponsorRate = 1;
$sponsorsStore = RAM::getInstance()->getObjectsForTeam($team->getSocialUserId(), RAM::RAM_TYPE_SPONSOR);
if (count($sponsorsStore) != $team->getSponsorsCount() || $team->getSponsorsCount() == 0) {
//] || GlobalParameters::$IS_FAKE_ENTER
// || GlobalParameters::MODER_ID == $team->getSocialUserId()){
$sponsorsStore = array();
$sql_template = "SELECT\n item_sponsors.id,\n item_sponsors.energy,\n item_sponsors.required_level\nFROM sponsors\nLEFT JOIN item_sponsors ON item_sponsors.id = sponsors.sponsor_id\nWHERE vk_id = '%s'";
$sql = sprintf($sql_template, $team->getSocialUserId());
$SQLresult = SQL::getInstance()->query($sql);
if ($SQLresult instanceof ErrorPoint) {
return $SQLresult;
}
$team->setSponsorsCount($SQLresult->num_rows, true);
if ($SQLresult->num_rows) {
$counter = 0;
while ($sponsor = $SQLresult->fetch_object()) {
$sponsorInstance = new Sponsor();
$sponsorInstance->initFromParameters($sponsor);
$sponsorRate *= $sponsorInstance->getEnergy();
$sponsorsStore[$sponsorInstance->getId()] = $sponsorInstance;
RAM::getInstance()->setSponsor($sponsorInstance, $team->getSocialUserId(), $counter);
$counter++;
}
if (count($sponsorsStore) > GlobalParameters::SPONSORS_LIMIT) {
return new ErrorPoint(ErrorPoint::CODE_LOGIC, "Количество спонсоров превышет допустимого значения " . count($sponsorsStore) . " - " . $SQLresult->num_rows, ErrorPoint::TYPE_SYSTEM);
}
$team->setSponsorRate($sponsorRate);
$team->setMaxEnergy($sponsorRate * LevelsGrid::getInstance()->getBaseEnergy($team->getLevel()));
}
} else {
foreach ($sponsorsStore as $sponsorInstance) {
$sponsorRate *= $sponsorInstance->getEnergy();
}
}
return $sponsorsStore;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$tgl = new DateTime(date('Y-m-d'));
$limit = Setting::first();
$limitdtstart = new DateTime($limit->startdayreg);
$limitdtend = new DateTime($limit->enddayreg);
$limitstart = $limitdtstart->diff($tgl)->format('%R%a');
$limitend = $limitdtend->diff($tgl)->format('%R%a');
$sma = Rekor::where('tingkat', 'SMA')->orderBy('urut', 'ASC')->get();
$smp = Rekor::where('tingkat', 'SMP')->orderBy('urut', 'ASC')->get();
$sd = Rekor::where('tingkat', 'SD')->orderBy('urut', 'ASC')->get();
$sponsors = Sponsor::all();
if ($limitstart < 0) {
$stat = 0;
return View::make('front.index')->with('stat', $stat)->with('limit', $limit)->with('sponsors', $sponsors)->with('sma', $sma)->with('smp', $smp)->with('sd', $sd);
}
if ($limitend > 0) {
$stat = 0;
return View::make('front.index')->with('stat', $stat)->with('limit', $limit)->with('sponsors', $sponsors)->with('sma', $sma)->with('smp', $smp)->with('sd', $sd);
}
return View::make('front.index')->with('stat', 1)->with('limit', $limit)->with('sponsors', $sponsors)->with('sma', $sma)->with('smp', $smp)->with('sd', $sd);
}
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/global.php';
require_once DOC_ROOT . '/includes/classes/class.html.php';
require_once DOC_ROOT . '/includes/classes/class.sponsor.php';
require_once DOC_ROOT . '/includes/classes/class.office.php';
$region_id = 65517;
$region_type = REGION_CITY;
$office_ids = Office::get_ids_by_region($region_id, $region_type);
$id = get_param('id');
$sponsor = new Sponsor($id);
if (!empty($_POST)) {
$sponsor->region_id($region_id);
$sponsor->region_type($region_type);
$sponsor->department_id(get_param('department_id'));
$sponsor->sponsor_type(get_param('sponsor_type'));
$sponsor->title(get_param('title'));
$sponsor->name_first(get_param('name_first'));
$sponsor->name_last(get_param('name_last'));
$sponsor->name_middle(get_param('name_middle'));
$sponsor->office(get_param('office'));
$sponsor->phone(get_param('phone'));
$sponsor->email(get_param('email'));
$sponsor->bio(get_param('bio'));
$sponsor->image(get_param('image'));
if ($id) {
$sponsor->update();
} else {
$id = $sponsor->insert();
}
redirect('sponsor');
function setSponsor(Sponsor $object, $inTeam, $indexInRAM = null)
{
if (!$this->isRAMEnabled) {
return null;
}
if (is_null($indexInRAM)) {
$linkName = $this->get(RAM::RAM_TYPE_SPONSOR . "_" . $inTeam . "_" . $object->getId());
} else {
$linkName = RAM::RAM_TYPE_SPONSOR . "_" . $inTeam . "_" . $indexInRAM;
$result = $this->set(RAM::RAM_TYPE_SPONSOR . "_" . $inTeam . "_" . $object->getId(), $linkName);
}
$result = $this->set($linkName, $object);
return $result;
}
<?php
session_start();
define("CONST_FILE_PATH", "../includes/constants.php");
include '../classes/WebPage.php';
//Set up page as a web page
$thisPage = new WebPage();
//Create new instance of webPage class
$dbObj = new Database();
//Instantiate database
$sponsorObj = new Sponsor($dbObj);
// Create an object of Sponsor class
$errorArr = array();
//Array of errors
$sponsorLogo = "";
$sponsorImage = "";
if (!isset($_SESSION['ITCLoggedInAdmin']) || !isset($_SESSION["ITCadminEmail"])) {
$json = array("status" => 0, "msg" => "You are not logged in.");
header('Content-type: application/json');
echo json_encode($json);
} else {
if (filter_input(INPUT_POST, "addNewSponsor") != NULL && filter_input(INPUT_POST, "addNewSponsor") == "addNewSponsor") {
$postVars = array('name', 'logo', 'website', 'product', 'description', 'image');
// Form fields names
//Validate the POST variables and add up to error message if empty
foreach ($postVars as $postVar) {
switch ($postVar) {
case 'logo':
$sponsorObj->{$postVar} = basename($_FILES["logo"]["name"]) ? rand(100000, 1000000) . "_" . strtolower(str_replace(" ", "_", filter_input(INPUT_POST, 'name'))) . "." . pathinfo(basename($_FILES["logo"]["name"]), PATHINFO_EXTENSION) : "";
$sponsorLogo = $sponsorObj->{$postVar};
if ($sponsorObj->{$postVar} == "") {
<?php
session_start();
define("CONST_FILE_PATH", "includes/constants.php");
define("CURRENT_PAGE", "home");
require 'classes/WebPage.php';
//Set up page as a web page
$thisPage = new WebPage();
//Create new instance of webPage class
$dbObj = new Database();
//Instantiate database
$thisPage->dbObj = $dbObj;
$courseObj = new Course($dbObj);
$categoryObj = new CourseCategory($dbObj);
$clientObj = new Sponsor($dbObj);
$quoteObj = new Quote($dbObj);
$calendar = new Calendar($dbObj);
$videoObj = new Video($dbObj);
include 'includes/other-settings.php';
require 'includes/page-properties.php';
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
<?php
include 'includes/meta-tags.php';
?>
<style type="text/css">img.wp-smiley,img.emoji {display: inline !important;border: none !important;box-shadow: none !important;height: 1em !important;width: 1em !important;margin: 0 .07em !important;vertical-align: -0.1em !important;background: none !important;padding: 0 !important; }</style>
<link rel='stylesheet' id='rs-plugin-settings-css' href='plugins/revslider/rs-plugin/css/settings1dc6.css?ver=4.6.5' type='text/css' media='all' />
<style id='rs-plugin-settings-inline-css' type='text/css'>.tp-caption a{color:#e05100;text-shadow:none; text-decoration:none;-webkit-transition:all 0.2s ease-out;-moz-transition:all 0.2s ease-out;-o-transition:all 0.2s ease-out;-ms-transition:all 0.2s ease-out}.tp-caption a:hover{color:#ffa902}</style>
<link rel='stylesheet' id='wpProQuiz_front_style-css' href='plugins/sfwd-lms/wp-pro-quiz/css/wpProQuiz_front.min4fde.css?ver=0.28' type='text/css' media='all' />
/**
* @return int
*/
public function PosGold()
{
$platinum = Sponsor::get()->filter(array('Type' => 'Platinum'))->count();
return ($this->iteratorPos + $platinum) % 2;
}
require_once DOC_ROOT . '/includes/classes/class.html.php';
require_once DOC_ROOT . '/includes/classes/class.sponsor.php';
$region_id = 65517;
$region_type = REGION_CITY;
$sponsor_ids = Sponsor::get_ids_by_region($region_id, $region_type);
$html = new HTML('admin');
$html->set_title('Edit personnel directory listings');
$html->generate_header();
?>
<div class='row_clickable' onclick="document.location.href='sponsor_edit'">
<h3>Add a new sponsor to the directory</h3>
</div>
<?php
if (!empty($sponsor_ids)) {
foreach ($sponsor_ids as $id) {
$sponsor = new Sponsor($id);
$sponsor_type = $sponsor->sponsor_type();
if ($sponsor_type == 'I') {
$name_last = $sponsor->name_last();
$name_first = $sponsor->name_first();
$name_middle = $sponsor->name_middle();
$title = $sponsor->title();
$sponsor_name = $name_first . ' ' . $name_last . ', ' . $title;
} elseif ($sponsor_type == 'O') {
$office = $sponsor->office();
$sponsor_name = $office;
}
$src = '/images/photos/personnel/' . $sponsor->image();
$region_name = $sponsor->region;
?>
<div class='row_clickable row_thumb' onclick="document.location.href='sponsor_edit?id=<?php
public function get_delete($id)
{
$sponsors = Sponsor::find($id)->delete();
return Redirect::to('rms/sponsors')->with('success', 'Successfully Removed Sponsor');
}
/**
* Renderize the view.
*
* @return null
*/
public function render(Sponsor $sponsor)
{
?>
<p>
<?php
echo REQUIRED_FIELDS_TEXT;
?>
</p>
<form action="<?php
echo $this->generateURL('sponsor', 'edit', $sponsor->getIdSponsor());
?>
" method="post">
<fieldset>
<div class="row">
<div class="col-md-6">
<div>
<label for="name">
Nombre <small>(*)</small>
</label>
<input name="name" type="text" required value="<?php
echo $sponsor->getName();
?>
" />
</div>
<div>
<label for="email">
Email <small>(*)</small>
</label>
<input name="email" type="text" required value="<?php
echo $sponsor->getEmail();
?>
" />
</div>
</div>
<div class="col-md-6">
<div>
<label for="website">
Web <small>(*)</small>
</label>
<input name="website" type="text" required value="<?php
echo $sponsor->getWebsite();
?>
" />
</div>
<div>
<input type="submit" value="Modificar" />
</div>
</div>
</div>
</fieldset>
</form>
<?php
}
public function Sponsors($type = '')
{
return Sponsor::get()->filter(array('Type' => $type))->sort('RAND()');
}
/**
* Modify a sponsor saved in the database.
*
* @param Sponsor $sponsor
* @return integer
*/
public function editSponsor(Sponsor $sponsor)
{
$sql = "UPDATE sponsor \n\t\t\tSET id_sponsor = '" . $sponsor->getIdSponsor() . "', name = '" . replaceCharacters($sponsor->getName()) . "', email = '" . $sponsor->getEmail() . "', website = '" . $sponsor->getWebsite() . "' WHERE id_sponsor = '" . $sponsor->getIdSponsor() . "'";
return DB::query($sql);
}
public function action()
{
SQL::getInstance()->autocommit(false);
$actionResult = SponsorSatellite::erase();
/*
$sponsorsStoreInRAM = RAM::getInstance()->getObjectsForTeam(UserParameters::getUserId(), RAM::RAM_TYPE_SPONSOR);
foreach ($sponsorsStoreInRAM as $sponsorInstance){
RAM::getInstance()->deleteSponsor($sponsorInstance->getId(), UserParameters::getUserId());
}
*/
track_stats();
// Отслеживаем производительность
$energyRate = 1;
$sponsorsStore = array();
$actionResult = NULL;
if (!is_object($this->parameters) && !is_array($this->parameters)) {
$this->parameters = str_replace('\\\\"', '', $this->parameters);
$this->parameters = str_replace(']\\"', ']', $this->parameters);
$this->parameters = str_replace('\\"[', '[', $this->parameters);
$this->parameters = json_decode($this->parameters);
}
track_stats();
// Отслеживаем производительность
if (!Utils::isEmpty($this->parameters) && !$actionResult instanceof ErrorPoint) {
$sponsorDBResult = SponsorSatellite::getFromStoreByIds($this->parameters);
$sponsorCount = count($sponsorDBResult);
track_stats();
// Отслеживаем производительность
if ($sponsorDBResult instanceof ErrorPoint) {
$actionResult = $sponsorDBResult;
} elseif ($sponsorCount) {
if ($sponsorCount > GlobalParameters::SPONSORS_LIMIT) {
$actionResult = new ErrorPoint(ErrorPoint::CODE_LOGIC, "Количество спонсоров превышет допустимый предел. Получено " . $sponsorCount . " спонсоров ", ErrorPoint::TYPE_SYSTEM);
} else {
track_stats();
// Отслеживаем производительность
foreach ($sponsorDBResult as $sponsor) {
$sponsorInstance = new Sponsor();
$sponsorInstance->initFromParameters($sponsor);
if ($sponsorInstance->getRequiredLevel() > $this->teamProfile->getLevel()) {
$actionResult = new ErrorPoint(ErrorPoint::CODE_SECURITY, "Спонсор не доступен по уровню. Уровень спонсора: " . $sponsorInstance->getRequiredLevel() . ", а у вас " . intval($this->teamProfile->getLevel()), ErrorPoint::TYPE_USER);
break;
}
$actionResult = $sponsorInstance->save();
if ($actionResult instanceof ErrorPoint) {
break;
}
$energyRate *= $sponsorInstance->getEnergy();
$sponsorsStore[] = $sponsorInstance;
}
track_stats();
// Отслеживаем производительность
}
}
}
if ($actionResult instanceof ErrorPoint) {
SQL::getInstance()->rollback();
return $actionResult;
}
if ($energyRate < 1) {
$energyRate = 1;
}
track_stats();
// Отслеживаем производительность
$this->teamProfile->setSponsorRate($energyRate);
$this->teamProfile->setMaxEnergy($energyRate * LevelsGrid::getInstance()->getBaseEnergy($this->teamProfile->getLevel()));
$this->teamProfile->bindSponsors($sponsorsStore);
$actionResult = $this->teamProfile->save();
if ($actionResult instanceof ErrorPoint) {
SQL::getInstance()->rollback();
} else {
SQL::getInstance()->commit();
}
track_stats();
// Отслеживаем производительность
return $actionResult;
}
<?php
session_start();
define("CONST_FILE_PATH", "includes/constants.php");
define("CURRENT_PAGE", "clients");
require 'classes/WebPage.php';
//Set up page as a web page
$thisPage = new WebPage();
//Create new instance of webPage class
$dbObj = new Database();
//Instantiate database
$thisPage->dbObj = $dbObj;
$courseObj = new Course($dbObj);
$categoryObj = new CourseCategory($dbObj);
$quoteObj = new Quote($dbObj);
$clientObj = new Sponsor($dbObj);
include 'includes/other-settings.php';
require 'includes/page-properties.php';
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
<?php
include 'includes/meta-tags.php';
?>
<style type="text/css">img.wp-smiley,img.emoji {display: inline !important;border: none !important;box-shadow: none !important;height: 1em !important;width: 1em !important;margin: 0 .07em !important;vertical-align: -0.1em !important;background: none !important;padding: 0 !important; }</style>
<link rel='stylesheet' id='rs-plugin-settings-css' href='<?php
echo SITE_URL;
?>
plugins/revslider/rs-plugin/css/settings1dc6.css?ver=4.6.5' type='text/css' media='all' />
<link rel='stylesheet' id='themerex-prettyphoto-style-css' href='<?php
// echo $condition;
});
/**
* Department
*/
require 'model/department.php';
$department = new Department();
$app->get('/departments/list', function () {
global $department, $conn;
echo json_encode($department->lists($conn));
});
/**
* Sponsor
*/
require 'model/sponsor.php';
$sponsor = new Sponsor();
$app->get('/sponsors', function () {
global $sponsor, $conn, $app;
$query = $app->request()->params('query');
echo json_encode($sponsor->show($conn, $query));
});
$app->get('/sponsors/list', function () {
global $sponsor, $conn;
echo json_encode($sponsor->lists($conn));
});
// GET route
$app->get('/', function () {
echo 'Hello World!';
});
// POST route
$app->post('/post', function () {
/**
* Remove the specified sponsor from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$sponsor = Sponsor::findOrFail($id);
$destinationPath = public_path() . DIRECTORY_SEPARATOR . 'uploads/sponsor' . DIRECTORY_SEPARATOR . $sponsor->logo;
try {
File::delete($destinationPath);
} catch (FileNotFound $e) {
// File sudah dihapus/tidak ada
}
Sponsor::destroy($id);
return Redirect::route('admin.sponsors.index')->with("successMessage", "Sponsor berhasil dihapus")->withTitle("Sponsor");
}
/**
* Renderize the view.
*
* @return null
*/
public function render(Sponsor $sponsor)
{
?>
<p>
<?php
echo REQUIRED_FIELDS_TEXT;
?>
</p>
<form action="<?php
echo $this->generateURL('sponsor', 'edit', $sponsor->getIdSponsor());
?>
" method="post">
<fieldset>
<div class="row">
<div class="col-md-6">
<div>
<label for="name">
Nombre <small>(*)</small>
</label>
<input name="name" type="text" required value="<?php
echo $sponsor->getName();
?>
" />
</div>
</div>
<div class="col-md-6">
<div>
<label for="type">
Tipo <small>(*)</small>
</label>
<select name="type" required>
<option value="">
Seleccionar
</option>
<?php
if ($sponsor->getType() === "PRIVADO") {
?>
<option value="PRIVADO" selected>
Privado
</option>
<option value="PUBLICO">
Público
</option>
<option value="QUIENES-SOMOS">
Quienes Somos
</option>
<?php
} else {
if ($sponsor->getType() === "PUBLICO") {
?>
<option value="PRIVADO">
Privado
</option>
<option value="PUBLICO" selected>
Público
</option>
<option value="QUIENES-SOMOS">
Quienes Somos
</option>
<?php
} else {
if ($sponsor->getType() === "QUIENES-SOMOS") {
?>
<option value="PRIVADO">
Privado
</option>
<option value="PUBLICO">
Público
</option>
<option value="QUIENES-SOMOS" selected>
Quienes Somos
</option>
<?php
}
}
}
?>
</select>
</div>
<div>
<input type="submit" value="Modificar" />
</div>
</div>
</div>
</fieldset>
</form>
<?php
}
echo $announcement->title();
?>
'></div>
</div>
<div class="row">
<div class="label" class="select">Sponsor:</div>
<div class="input_border">
<select name="sponsor_ids[]" id="sponsor_ids" multiple>
<option>Select One:</option>
<?php
$sponsor_ids = $announcement->get_sponsor_ids();
$region_sponsor_ids = Sponsor::get_ids_by_region($region_id);
if (!empty($region_sponsor_ids)) {
foreach ($region_sponsor_ids as $id) {
$sponsor = new Sponsor($id);
$sponsor_name = $sponsor->sponsor_name();
$selected = in_array($id, $sponsor_ids) ? 'selected' : '';
echo '<option ' . $selected . ' value="' . $id . '">' . $sponsor_name . '</option>"';
}
}
?>
</select>
</div>
</div>
<div class="row">
<div class="label" class="select">Status:</div>
<div class="input_border">
<select name="status_id" id="status_id">
<option>Select One:</option>
