function uploadFile($controller, $realestate_id)
{
$extras = new Extras();
$itm = new Photo();
$itm->realestate_id = $realestate_id;
$backUrl = $extras->encryptQuery1(KEY_SALT, 'realestate_id', $realestate_id, 'photo_realestate_view.php');
$itm->created_at = time();
$itm->updated_at = time();
$desired_dir = IMAGE_UPLOAD_DIR;
$errors = array();
$count = count($_FILES["file"]["name"]);
for ($key = 0; $key < $count; $key++) {
$file_name = $_FILES['file']['name'][$key];
$file_size = $_FILES['file']['size'][$key];
$file_tmp = $_FILES['file']['tmp_name'][$key];
$file_type = $_FILES['file']['type'][$key];
if ($file_size > 2097152) {
$errors[] = 'File size must be less than 2 MB';
}
$date = date_create();
$timestamp = time();
$temp = explode(".", $_FILES["file"]["name"][0]);
$extension = end($temp);
$new_file_name = $desired_dir . "/" . "large_" . $timestamp . "." . $extension;
if ($key == 1) {
$new_file_name = $desired_dir . "/" . "thumb_" . $timestamp . "." . $extension;
}
if (empty($errors) == true) {
if (is_dir($desired_dir) == false) {
// Create directory if it does not exist
mkdir("{$desired_dir}", 0700);
}
if (is_dir($file_name) == false) {
// rename the file if another one exist
move_uploaded_file($file_tmp, $new_file_name);
} else {
$new_dir = $new_file_name . time();
rename($file_tmp, $new_dir);
}
if ($key == 0) {
$itm->photo_url = ROOT_URL . $new_file_name;
}
if ($key == 1) {
$itm->thumb_url = ROOT_URL . $new_file_name;
}
} else {
print_r($errors);
}
}
$controller->insertPhoto($itm);
echo "<script type='text/javascript'>location.href='{$backUrl}.php';</script>";
}
function process($parameters)
{
$payments = new Payments();
if (!$payments->checkLogin()) {
$this->redirect('error');
}
//if empty parameter, add there current user
if (isset($parameters[0])) {
$userId = $parameters[0];
} else {
$userId = $_SESSION['id_user'];
}
if ($userId != $_SESSION['id_user'] && !$payments->checkIfIsAdminOfUser($_SESSION['id_user'], $userId)) {
$this->redirect('error');
}
$data = $payments->getUserData($userId);
//actualize old payments
$resultMessages = $payments->actualizePayments($data['payments']);
//create new payments
$payments->makeNewPayments($data['user'], $data['tariff'], $this->language);
$this->messages = array_merge($this->messages, $resultMessages);
//get new data for user view
$data = $payments->getUserData($userId);
$data['payments'] = $payments->enhanceUserPayments($data['payments'], $this->language);
$extras = new Extras();
$this->data['blankExtras'] = $extras->getBlankExtras($userId);
//display non-active user
if (!$data['user']['active']) {
$this->messages[] = ['s' => 'info', 'cs' => 'Neaktivní uživatel - nové faktury se negenerují', 'en' => 'Inactive user - new invoices are not generated'];
}
$this->data['admin'] = $payments->checkIfIsAdminOfUser($_SESSION['id_user'], $userId);
$this->data['tariff'] = $data['tariff'];
$this->data['user'] = $data['user'];
$this->data['payments'] = $data['payments'];
$this->header['title'] = ['cs' => 'Přehled plateb', 'en' => 'Payments overview'];
//TODO add nice sliding JS invoice detail directly into view
//TODO hide table in view when empty (no data)
$this->view = 'payments';
}
<table class="table">
<thead>
<tr>
<th>#</th>
<th>Name</th>
<th>Icon</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($categories != null) {
$ind = $begin + 1;
foreach ($categories as $category) {
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'category_id', $category->category_id, 'category_update.php');
$deleteUrl = $extras->encryptQuery1(KEY_SALT, 'category_id', $category->category_id, 'categories.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$category->category}</td>";
echo "<td><img src='{$category->category_icon}' width='40' height='40' /></td>";
echo "<td>\n <a class='btn btn-primary btn-xs' href=\"{$updateUrl}\"><span class='glyphicon glyphicon-pencil'></span></a>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$category->category_id}'><span class='glyphicon glyphicon-remove'></span></button>\n </td>";
echo "</tr>";
echo "<div class='modal fade' id='modal_{$category->category_id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>\n\n <div class='modal-dialog'>\n <div class='modal-content'>\n <div class='modal-header'>\n <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>×</button>\n <h4 class='modal-title' id='myModalLabel'>Deleting Category</h4>\n </div>\n <div class='modal-body'>\n <p>Deleting this is not irreversible. Do you wish to continue?\n </div>\n <div class='modal-footer'>\n <button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>\n <a type='button' class='btn btn-primary' href='{$deleteUrl}'>Delete</a>\n </div>\n </div>\n </div>\n </div>";
++$ind;
}
}
?>
</tbody>
<?php
require_once 'header.php';
$controller = new ControllerRealEstate();
$controllerAgent = new ControllerAgent();
$controllerPropertyType = new ControllerPropertyType();
$agents = $controllerAgent->getAgents();
$propertytypes = $controllerPropertyType->getPropertyTypes();
$extras = new Extras();
if (isset($_POST['submit'])) {
$itm = new RealEstate();
$itm->address = htmlspecialchars(trim(strip_tags($_POST['address'])), ENT_QUOTES);
$itm->baths = htmlspecialchars(trim(strip_tags($_POST['baths'])), ENT_QUOTES);
$itm->beds = trim(strip_tags($_POST['beds']));
$itm->built_in = trim(strip_tags($_POST['built_in']));
$itm->country = htmlspecialchars(trim(strip_tags($_POST['country'])), ENT_QUOTES);
$itm->created_at = time();
$itm->desc1 = $extras->removeHttp(htmlspecialchars(trim(strip_tags($_POST['desc1'])), ENT_QUOTES));
$itm->featured = htmlspecialchars(trim(strip_tags($_POST['featured'])), ENT_QUOTES);
$itm->lat = trim(strip_tags($_POST['lat']));
$itm->lon = trim(strip_tags($_POST['lon']));
$itm->lot_size = trim(strip_tags($_POST['lot_size']));
$itm->price = htmlspecialchars(trim(strip_tags($_POST['price'])), ENT_QUOTES);
$itm->price_per_sqft = htmlspecialchars(trim(strip_tags($_POST['price_per_sqft'])), ENT_QUOTES);
$itm->property_type = trim(strip_tags($_POST['property_type']));
$itm->rooms = trim(strip_tags($_POST['rooms']));
$itm->sqft = trim(strip_tags($_POST['sqft']));
$itm->status = trim(strip_tags($_POST['status']));
$itm->updated_at = time();
$itm->is_deleted = 0;
$itm->agent_id = trim(strip_tags($_POST['agent_id']));
function getParamsFromUser()
{
$extras = new Extras();
return $extras->decryptParams(KEY_SALT, $_SERVER['QUERY_STRING']);
}
<?php
require_once 'header.php';
$controller = new ControllerCategory();
$extras = new Extras();
$category_id = $extras->decryptQuery1(KEY_SALT, $_SERVER['QUERY_STRING']);
if ($category_id != null) {
$category = $controller->getCategoryByCategoryId($category_id);
if (isset($_POST['submit'])) {
$itm = new Category();
$itm->category_id = $category_id;
$itm->category = trim(strip_tags($_POST['category']));
$itm->created_at = time();
$itm->updated_at = time();
$itm->category_icon = $_POST['category_icon'];
$count = count($_FILES["file"]["name"]);
if (!empty($_FILES["file"]["name"][0])) {
uploadFile($controller, $itm);
} else {
$controller->updateCategory($itm);
echo "<script type='text/javascript'>location.href='categories.php';</script>";
}
}
} else {
echo "<script type='text/javascript'>location.href='403.php';</script>";
}
function uploadFile($controller, $itm)
{
$extras = new Extras();
$desired_dir = Constants::IMAGE_UPLOAD_DIR;
$errors = array();
<thead>
<tr>
<th>#</th>
<th>Name</th>
<th>Registered Via:</th>
<th>Access Role</th>
</tr>
</thead>
<tbody>
<?php
if ($users != null) {
$ind = 1;
foreach ($users as $user) {
$extras = new Extras();
$featuredUrl = $extras->encryptQuery2(KEY_SALT, 'user_id', $user->user_id, 'user_id', $user->deny_access, 'users.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$user->full_name}</td>";
$registered_via = @"Web";
if ($user->facebook_id > 0) {
$registered_via = @"Facebook";
}
if ($user->twitter_id > 0) {
$registered_via = @"Twitter";
}
echo "<td>{$registered_via}</td>";
if ($user->deny_access == 1) {
echo "<td><a href='{$featuredUrl}'>Allow</a></td>";
} else {
<?php
require_once 'header.php';
$controller = new ControllerRealEstate();
$controllerAgent = new ControllerAgent();
$controllerPropertyType = new ControllerPropertyType();
$agents = $controllerAgent->getAgents();
$propertytypes = $controllerPropertyType->getPropertyTypes();
$extras = new Extras();
$realestate_id = $extras->decryptQuery1(KEY_SALT, $_SERVER['QUERY_STRING']);
if ($realestate_id != null) {
$realestate = $controller->getRealEstateByRealEstateId($realestate_id);
if (isset($_POST['submit'])) {
$itm = $realestate;
$itm->address = htmlspecialchars(trim(strip_tags($_POST['address'])), ENT_QUOTES);
$itm->baths = htmlspecialchars(trim(strip_tags($_POST['baths'])), ENT_QUOTES);
$itm->beds = trim(strip_tags($_POST['beds']));
$itm->built_in = trim(strip_tags($_POST['built_in']));
$itm->country = htmlspecialchars(trim(strip_tags($_POST['country'])), ENT_QUOTES);
$itm->desc1 = $extras->removeHttp(htmlspecialchars(trim(strip_tags($_POST['desc1'])), ENT_QUOTES));
$itm->featured = htmlspecialchars(trim(strip_tags($_POST['featured'])), ENT_QUOTES);
$itm->lat = trim(strip_tags($_POST['lat']));
$itm->lon = trim(strip_tags($_POST['lon']));
$itm->lot_size = trim(strip_tags($_POST['lot_size']));
$itm->price = htmlspecialchars(trim(strip_tags($_POST['price'])), ENT_QUOTES);
$itm->price_per_sqft = htmlspecialchars(trim(strip_tags($_POST['price_per_sqft'])), ENT_QUOTES);
$itm->property_type = trim(strip_tags($_POST['property_type']));
$itm->rooms = trim(strip_tags($_POST['rooms']));
$itm->sqft = trim(strip_tags($_POST['sqft']));
$itm->status = trim(strip_tags($_POST['status']));
$itm->updated_at = time();
<thead>
<tr>
<th>#</th>
<th>Name</th>
<th>Username</th>
<th>Access Role</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($users != null) {
$ind = 1;
foreach ($users as $user) {
$extras = new Extras();
$featuredUrl = $extras->encryptQuery2(KEY_SALT, 'authentication_id', $user->authentication_id, 'authentication_id', $user->deny_access, 'admin_access.php');
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'authentication_id', $user->authentication_id, 'access_user_update.php');
$deleteUrl = $extras->encryptQuery1(KEY_SALT, 'authentication_id', $user->authentication_id, 'admin_access.php');
$deleteUrl = $extras->encryptQuery2(KEY_SALT, 'authentication_id', $user->authentication_id, 'deleted', "deleted", 'admin_access.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$user->name}</td>";
echo "<td>{$user->username}</td>";
if ($user->deny_access == 1) {
echo "<td><a href='{$featuredUrl}'>Allow</a></td>";
} else {
echo "<td><a href='{$featuredUrl}'>Deny</a></td>";
}
echo "<td>\n <a class='btn btn-primary btn-xs' href='{$updateUrl}'><span class='glyphicon glyphicon-pencil'></span></a>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$user->authentication_id}'><span class='glyphicon glyphicon-remove'></span></button>\n </td>";
echo "</tr>";
<th>is Featured?</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($realestates != null) {
$ind = 1;
foreach ($realestates as $realestate) {
$featured = "no";
if ($realestate->featured == 1) {
$featured = "yes";
}
$no_of_photos = $controllerPhoto->getNoOfPhotosByRealEstateId($realestate->realestate_id);
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'realestate_id', $realestate->realestate_id, 'realestate_update.php');
$deleteUrl = $extras->encryptQuery1(KEY_SALT, 'realestate_id', $realestate->realestate_id, 'realestates.php');
$featuredUrl = $extras->encryptQuery2(KEY_SALT, 'realestate_id', $realestate->realestate_id, 'featured', $featured, 'realestates.php');
$viewUrl = $extras->encryptQuery1(KEY_SALT, 'realestate_id', $realestate->realestate_id, 'photo_realestate_view.php');
$photoUrl = $extras->encryptQuery1(KEY_SALT, 'realestate_id', $realestate->realestate_id, 'photo_realestate_insert.php');
echo "<tr>";
echo "<td>{$realestate->realestate_id}</td>";
echo "<td>{$realestate->price}</td>";
echo "<td>{$realestate->address}</td>";
echo "<td>{$no_of_photos} Photo(s)</td>";
if ($realestate->featured == 1) {
echo "<td><a href='{$featuredUrl}'>No</a></td>";
} else {
echo "<td><a href='{$featuredUrl}'>Yes</a></td>";
}
<!-- Table -->
<table class="table">
<thead>
<tr>
<th>#</th>
<th>Name</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($propertytypes != null) {
$ind = 1;
foreach ($propertytypes as $propertytype) {
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'propertytype_id', $propertytype->propertytype_id, 'propertytype_update.php');
$deleteUrl = $extras->encryptQuery1(KEY_SALT, 'propertytype_id', $propertytype->propertytype_id, 'propertytypes.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$propertytype->property_type}</td>";
echo "<td>\n <a class='btn btn-primary btn-xs' href='{$updateUrl}'><span class='glyphicon glyphicon-pencil'></span></a>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$propertytype->propertytype_id}'><span class='glyphicon glyphicon-remove'></span></button>\n </td>";
echo "</tr>";
echo "<div class='modal fade' id='modal_{$propertytype->propertytype_id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>\n\n <div class='modal-dialog'>\n <div class='modal-content'>\n <div class='modal-header'>\n <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>×</button>\n <h4 class='modal-title' id='myModalLabel'>Deleting Property Type</h4>\n </div>\n <div class='modal-body'>\n <p>Deleting this is not irreversible. Do you wish to continue?\n </div>\n <div class='modal-footer'>\n <button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>\n <a type='button' class='btn btn-primary' href='{$deleteUrl}'>Delete</a>\n </div>\n </div>\n </div>\n </div>";
++$ind;
}
}
?>
</tbody>
<?php
require_once 'header.php';
$controller = new ControllerStore();
$controllerCategory = new ControllerCategory();
$categories = $controllerCategory->getCategories();
$extras = new Extras();
if (isset($_POST['submit'])) {
$itm = new Store();
$itm->store_name = htmlspecialchars(trim(strip_tags($_POST['store_name'])), ENT_QUOTES);
$itm->store_address = htmlspecialchars(trim(strip_tags($_POST['store_address'])), ENT_QUOTES);
$store_desc = preg_replace('~[\\r\\n]+~', '', $_POST['store_desc']);
$itm->store_desc = htmlspecialchars(trim(strip_tags($store_desc)));
$itm->lat = trim(strip_tags($_POST['lat']));
$itm->lon = htmlspecialchars(trim(strip_tags($_POST['lon'])), ENT_QUOTES);
$itm->created_at = time();
$itm->website = $extras->removeHttp(htmlspecialchars(trim(strip_tags($_POST['website'])), ENT_QUOTES));
$itm->phone_no = htmlspecialchars(trim(strip_tags($_POST['phone_no'])), ENT_QUOTES);
$itm->email = trim(strip_tags($_POST['email']));
$itm->sms_no = trim(strip_tags($_POST['sms_no']));
$itm->category_id = trim(strip_tags($_POST['category_id']));
$itm->updated_at = time();
$itm->featured = trim(strip_tags($_POST['featured']));
$controller->insertStore($itm);
echo "<script type='text/javascript'>location.href='stores.php';</script>";
}
?>
<!DOCTYPE html>
<html lang="en"><head>
<?php
require_once 'header.php';
$controller = new ControllerPropertyType();
$extras = new Extras();
$propertytype_id = $extras->decryptQuery1(KEY_SALT, $_SERVER['QUERY_STRING']);
if ($propertytype_id != null) {
$propertytype = $controller->getPropertyTypeByPropertyTypeId($propertytype_id);
if (isset($_POST['submit'])) {
$propertytype_found = $controller->getPropertyTypeByPropertyType(trim($_POST['property_type']));
if ($propertytype_found == null) {
$itm = new PropertyType();
$itm->property_type = htmlspecialchars(trim(strip_tags($_POST['property_type'])), ENT_QUOTES);
$itm->created_at = time();
$itm->updated_at = time();
$itm->propertytype_id = $propertytype_id;
$controller->updatePropertyType($itm);
echo "<script type='text/javascript'>location.href='propertytypes.php';</script>";
} else {
echo "<script>alert('Cannot update because property type exist already.');</script>";
}
}
} else {
echo "<script type='text/javascript'>location.href='403.php';</script>";
}
?>
<!DOCTYPE html>
<html lang="en"><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
function process($parameters)
{
$extras = new Extras();
$fakturoid = new FakturoidWrapper();
$action = $extras->sanitize($parameters[0]);
switch ($action) {
case 'add':
$paymentId = $extras->sanitize($_POST['paymentId']);
$price = $extras->sanitize($_POST['price']);
$description = $extras->sanitize($_POST['description']);
$result = $extras->checkAddValues($paymentId, $price, $description);
if ($result['s'] == 'success') {
$status = $extras->getStatusOfPayment($paymentId);
//allow add extra only when new payment will be generated
if (!in_array($status, ['unpaid', 'refund', 'timeout'])) {
$this->messages[] = ['s' => 'error', 'cs' => 'Bohužel, položka nebyla přidána; platba se právě platí nebo je již zaplacená', 'en' => 'Sorry, we cannot add an extra; payment is processing'];
} else {
$invoiceFakturoidId = $fakturoid->getFakturoidInvoiceIdFromPaymentId($paymentId);
$extraFakturoidId = $fakturoid->addExtra($invoiceFakturoidId, $price, $description);
$result = $extras->addExtra($paymentId, $price, $description, $extraFakturoidId);
$this->messages[] = $result;
}
}
$this->redirect('checkUsers');
break;
case 'addBlank':
$userId = $extras->sanitize($_POST['userId']);
$price = $extras->sanitize($_POST['price']);
$description = $extras->sanitize($_POST['description']);
$result = $extras->checkAddBlankValues($userId, $price, $description);
if ($result['s'] == 'success') {
$this->messages[] = $extras->addBlankExtra($userId, $price, $description);
} else {
$this->messages[] = $result;
}
$this->redirect('checkUsers');
break;
case 'delete':
$extraId = $parameters[1];
$status = $extras->getStatusOfPaymentFromExtraId($extraId);
//allow add extra only when new payment will be generated or is blank
if (!in_array($status, ['unpaid', 'refund', 'timeout', null])) {
$this->messages[] = ['s' => 'error', 'cs' => 'Bohužel, položka nebyla zrušena; platba se právě platí nebo je již zaplacená', 'en' => 'Sorry, we cannot cancel an extra; payment is processing'];
} else {
$extraFakturoidId = $fakturoid->getExtraFakturoidId($extraId);
$invoiceFakturoidId = $fakturoid->getInvoiceFakturoidIdFromExtraId($extraId);
$fakturoid->deleteExtra($invoiceFakturoidId, $extraFakturoidId);
$result = $extras->deleteExtra($extraId);
$this->messages[] = $result;
}
$this->redirect('checkUsers');
break;
default:
$this->redirect('error');
}
}
public function insertar_info($user, $pass)
{
$pw = Extras::Encr($pass);
//Nuestro password fue enviado a encriptar a la funcion de arriba
$sql = Extras::Script_db("call nombre_de_nuestro_store_procedure");
//Esto enviara a nuestro funcion estatica una llamada de store procedure
$sql_2 = Extras::Script_db("SELECT*FROM name_dbase");
//Un query normal para base de datos
//Aqui llamaremos todos los archivos de la db
while ($res = mysqli_fetch_array($sql)) {
$this->name[] = $res;
// se vaya almacenando en un array
}
return $this->name;
// Enviamos los datos.
}
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($stores != null) {
$ind = $begin + 1;
foreach ($stores as $store) {
$featured = "no";
if ($store->featured == 1) {
$featured = "yes";
}
$no_of_photos = $controllerPhoto->getNoOfPhotosByStoreId($store->store_id);
$rating = $controllerRating->getRatingByStoreId($store->store_id);
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'store_id', $store->store_id, 'store_update.php');
$deleteUrl = $extras->encryptQuery1(KEY_SALT, 'store_id', $store->store_id, 'stores.php');
$featuredUrl = $extras->encryptQuery2(KEY_SALT, 'store_id', $store->store_id, 'featured', $featured, 'stores.php');
$viewUrl = $extras->encryptQuery1(KEY_SALT, 'store_id', $store->store_id, 'photo_store_view.php');
$photoUrl = $extras->encryptQuery1(KEY_SALT, 'store_id', $store->store_id, 'photo_store_insert.php');
$reviewUrl = $extras->encryptQuery1(KEY_SALT, 'store_id', $store->store_id, 'store_reviews_view.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$store->store_name}</td>";
echo "<td>{$store->store_address}</td>";
echo "<td>{$no_of_photos} Foto(s)</td>";
echo "<td>{$rating}</td>";
if ($store->featured == 1) {
echo "<td><a href='{$featuredUrl}'>No</a></td>";
} else {
<table class="table">
<thead>
<tr>
<th>#</th>
<th>Event</th>
<th>Date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($news != null) {
$ind = 1;
foreach ($news as $m_news) {
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'news_id', $m_news->news_id, 'news_update.php');
$deleteUrl = $extras->encryptQuery1(KEY_SALT, 'news_id', $m_news->news_id, 'news.php');
$datetime = date("M d, Y h:i", $m_news->created_at);
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$m_news->news_title}</td>";
echo "<td>{$datetime}</td>";
echo "<td>\n <a class='btn btn-primary btn-xs' href='{$updateUrl}'><span class='glyphicon glyphicon-pencil'></span></a>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$m_news->news_id}'><span class='glyphicon glyphicon-remove'></span></button>\n \n </td>";
echo "</tr>";
//<!-- Modal -->
echo "<div class='modal fade' id='modal_{$m_news->news_id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>\n\n <div class='modal-dialog'>\n <div class='modal-content'>\n <div class='modal-header'>\n <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>×</button>\n <h4 class='modal-title' id='myModalLabel'>Deleting News</h4>\n </div>\n <div class='modal-body'>\n <p>Deleting this is not irreversible. Do you wish to continue?\n </div>\n <div class='modal-footer'>\n <button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>\n <a type='button' class='btn btn-primary' href='{$deleteUrl}'>Delete</a>\n </div>\n </div>\n </div>\n </div>";
++$ind;
}
}
?>
/**
* showTables
*
* @param mixed $io Description.
*
* @access public
*
* @return mixed Value.
*/
public function showTables($io = true)
{
$bdd = self::dbConnect();
$sql = 'SHOW TABLES';
$response = $bdd->prepare($sql);
$response->execute();
while ($row = $response->fetch()) {
$tables[] = $row[0];
}
if ($io) {
echo 'There is ' . Extras::pluralize("table", count($tables)) . ' into the ' . self::DATABASE . ' database:<br />' . implode('<br />', $tables) . '<br />';
}
return implode(', ', $tables);
}
<?php
require_once 'header.php';
$controller = new ControllerAgent();
$controllerUser = new ControllerUser();
$users = $controllerUser->getUsers();
$extras = new Extras();
$agent_id = $extras->decryptQuery1(KEY_SALT, $_SERVER['QUERY_STRING']);
if ($agent_id != null) {
$agent = $controller->getAgentByAgentId($agent_id);
if (isset($_POST['submit'])) {
$itm = new Agent();
$itm->address = trim(strip_tags($_POST['address']));
$itm->contact_no = trim(strip_tags($_POST['contact_no']));
$itm->country = trim(strip_tags($_POST['country']));
$itm->created_at = time();
$itm->email = trim(strip_tags($_POST['email']));
$itm->name = trim(strip_tags($_POST['name']));
$itm->sms = trim(strip_tags($_POST['sms']));
$itm->updated_at = time();
$itm->zipcode = trim(strip_tags($_POST['zipcode']));
$itm->photo_url = trim(strip_tags($_POST['photo_url']));
$itm->thumb_url = trim(strip_tags($_POST['thumb_url']));
$itm->twitter = trim(strip_tags($_POST['twitter']));
$itm->fb = trim(strip_tags($_POST['fb']));
$itm->linkedin = trim(strip_tags($_POST['linkedin']));
$itm->company = trim(strip_tags($_POST['company']));
$itm->user_id = trim(strip_tags($_POST['user_id']));
$itm->agent_id = $agent_id;
$count = count($_FILES["file"]["name"]);
if (!empty($_FILES["file"]["name"][0]) && !empty($_FILES["file"]["name"][1])) {
echo "<a href='{$insertUrl}' class='btn btn-default btn-sm'><span class='glyphicon glyphicon-plus'></span></a>";
?>
</form>
</div>
</div>
<div class="panel-body">
<div class="row">
<?php
if ($photos_store != null) {
$ind = 1;
$count = count($photos_store);
foreach ($photos_store as $photo_store) {
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'photo_id', $photo_store->photo_id, 'photo_store_update.php');
$deleteUrl = $extras->encryptQuery2(KEY_SALT, 'store_id', $photo_store->store_id, 'photo_id', $photo_store->photo_id, 'photo_store_view.php');
echo "<div class='col-sm-6 col-md-4'>";
echo "<div class='thumbnail'>";
echo "<img src='{$photo_store->thumb_url}' alt='...' style = 'display:block; height:150px; margin-left:auto; margin-right:auto; max-width:100%;'>";
echo "<div class='caption'>";
echo "<p>";
echo "<a href='{$updateUrl}' class='btn btn-primary btn-xs' role='button'>Edit</a> ";
echo "<button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$photo_store->photo_id}'>Large Image</button> ";
echo "<button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#delete_modal_{$photo_store->photo_id}'>Delete</button>";
echo "</p>";
echo "</div>";
echo "</div>";
echo "</div>";
//<!-- Modal -->
<?php
require_once 'header.php';
$controller = new ControllerStore();
$controllerCategory = new ControllerCategory();
$categories = $controllerCategory->getCategories();
$extras = new Extras();
$store_id = $extras->decryptQuery1(KEY_SALT, $_SERVER['QUERY_STRING']);
if ($store_id != null) {
$store = $controller->getStoreByStoreId($store_id);
if (isset($_POST['submit'])) {
$itm = $store;
$itm->store_name = htmlspecialchars(trim(strip_tags($_POST['store_name'])), ENT_QUOTES);
$itm->store_address = htmlspecialchars(trim(strip_tags($_POST['store_address'])), ENT_QUOTES);
$store_desc = preg_replace('~[\\r\\n]+~', '', $_POST['store_desc']);
$itm->store_desc = htmlspecialchars(trim(strip_tags($store_desc)));
$itm->lat = trim(strip_tags($_POST['lat']));
$itm->lon = htmlspecialchars(trim(strip_tags($_POST['lon'])), ENT_QUOTES);
$itm->created_at = time();
$itm->website = $extras->removeHttp(htmlspecialchars(trim(strip_tags($_POST['website'])), ENT_QUOTES));
$itm->phone_no = htmlspecialchars(trim(strip_tags($_POST['phone_no'])), ENT_QUOTES);
$itm->email = trim(strip_tags($_POST['email']));
$itm->sms_no = trim(strip_tags($_POST['sms_no']));
$itm->category_id = trim(strip_tags($_POST['category_id']));
$itm->updated_at = time();
$itm->featured = trim(strip_tags($_POST['featured']));
$controller->updateStore($itm);
echo "<script type='text/javascript'>location.href='stores.php';</script>";
}
} else {
echo "<script type='text/javascript'>location.href='403.php';</script>";
private function createPayment($user, $tariff, $beginningDate, $lang)
{
$userId = $user['id_user'];
$tariffId = $tariff['id_tariff'];
$tariffName = $this->getTariffName($tariffId, 'cs');
//invoice is in czech only
$priceCZK = $tariff['priceCZK'];
$fakturoid = new FakturoidWrapper();
$fakturoidInvoice = $fakturoid->createInvoice($user, $tariff['priceCZK'], $tariffName, $beginningDate, $lang);
if (!$fakturoidInvoice) {
return ['s' => 'error', 'cs' => 'Nepovedlo se spojení s fakturoid.cz. Zkuste to prosím za pár minut', 'en' => 'We are unable to connect to fakturoid.cz. Try again in a few minutes'];
}
$fakturoidInvoiceId = $fakturoidInvoice->id;
$fakturoidInvoiceNumber = $fakturoidInvoice->number;
$now = date('Y-m-d H-i-s');
Db::queryModify('
INSERT INTO `payments` (
`id_payer`,
`payment_first_date`,
`status`,
`time_generated`,
`tariff_id`,
`price_CZK`,
`invoice_fakturoid_id`,
`invoice_fakturoid_number`
) VALUES (?, ?, ?, ?, ?, ?, ?, ?)', [$userId, date('Y-m-d', $beginningDate), 'unpaid', $now, $tariffId, $priceCZK, $fakturoidInvoiceId, $fakturoidInvoiceNumber]);
//add blank extras
$extras = new Extras();
$blankExtras = $extras->getBlankExtras($user['id_user']);
if (!empty($blankExtras)) {
foreach ($blankExtras as $extra) {
$extraId = $extra['id_extra'];
$price = $extra['priceCZK'];
$description = $extra['description'];
$fakturoidExtraId = $fakturoid->addExtra($fakturoidInvoiceId, $extra['priceCZK'], $extra['description']);
$paymentId = $this->getPaymentIdFromFakturoidInvoiceId($fakturoidInvoiceId);
$extras->assignBlankExtra($paymentId, $price, $description, $fakturoidExtraId, $extraId);
}
}
//send email to user
$subject = NAME . ' Paralelní Polis - nová faktura';
$link = ROOT . '/cs/payments';
$message = 'Ahoj,<br/>
<br/>
vystavili jsem ti fakturu za členství / pronájem v Paper Hub v Paralelní Polis.<br/>
<a href="' . $link . '">' . $link . '</a><br/>
Platbu uhradíš jednoduše na odkazu výše.<br/>
<br/>
Díky za rychlou platbu!<br/>
Paper Hub';
$this->sendEmail(EMAIL, $user['email'], $subject, $message);
//and send copy of email to hub manager
//TODO refractor
$this->sendEmail(EMAIL, EMAIL_HUB_MANAGER, NAME . ' - Poslána výzva o nové faktuře na email ' . $user['email'], $message);
return ['s' => 'success'];
}
<!-- Table -->
<table class="table">
<thead>
<tr>
<th>#</th>
<th>Category</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($arrayCategories != null) {
$ind = 1;
foreach ($arrayCategories as $category) {
$extras = new Extras();
$params = array();
$params[0] = array('category_id', $category->category_id);
$updateUrl = $extras->encryptParams(KEY_SALT, $params, 'category_update.php');
$params = array();
$params[0] = array('category_id', $category->category_id);
$params[1] = array('action_delete', 1);
$deleteUrl = $extras->encryptParams(KEY_SALT, $params, 'categories.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$category->category}</td>";
echo "<td>\n\t\t\t\t\t <a class='btn btn-primary btn-xs' href='{$updateUrl}'><span class='glyphicon glyphicon-pencil'></span></a>\n\t\t \t<button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$category->category_id}'><span class='glyphicon glyphicon-remove'></span></button>\n\t\t\t \t</td>";
echo "</tr>";
++$ind;
echo "<div class='modal fade' id='modal_{$category->category_id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>\n\t\t \t<div class='modal-dialog'>\n\t\t \t<div class='modal-content'>\n\t\t \t<div class='modal-header'>\n\t\t <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>×</button>\n\t\t <h4 class='modal-title' id='myModalLabel'>Deleting Category</h4>\n\t\t \t</div>\n\t\t \t<div class='modal-body'>\n\t\t \t<p>Deleting this is not irreversible. Do you wish to continue?\n\t\t \t</div>\n\t\t \t<div class='modal-footer'>\n\t\t \t<button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>\n\t\t \t<a type='button' class='btn btn-primary' href='{$deleteUrl}'>Delete</a>\n\t\t \t</div>\n\t\t \t</div>\n\t\t </div>\n\t\t </div>";
}
<!-- Table -->
<table class="table">
<thead>
<tr>
<th>#</th>
<th>Title</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($deals != null) {
$ind = 1;
foreach ($deals as $deal) {
$extras = new Extras();
$params = array();
$params[0] = array('deal_id', $deal->deal_id);
$updateUrl = $extras->encryptParams(KEY_SALT, $params, 'deal_update.php');
$params = array();
$params[0] = array('deal_id', $deal->deal_id);
$params[1] = array('action_delete', 1);
$deleteUrl = $extras->encryptParams(KEY_SALT, $params, 'approved_deals.php');
$controllerDeal = new ControllerDeal();
$isExpired = $controllerDeal->checkIfDealIsExpired($deal->deal_id);
$val = "<span class='label label-danger'>Expired</span>";
if (!$isExpired) {
$val = "<span class='label label-success'> Active </span>";
}
echo "<tr>";
echo "<td>{$ind}</td>";
border-left: 5px solid <?php
esc_attr_e($options[$slug . '-border']);
?>
;
border-right: 5px solid transparent;
color: <?php
esc_attr_e($options[$slug . '-text']);
?>
;
line-height: 1.4em;
padding-left: 5px;
padding-bottom: 2px;
}
<?php
Extras::add_map_display_css($slug);
if ('1' === $options['color_widgets']) {
?>
<?php
Widgets::add_widget_display_css($slug);
}
?>
.tribe-events-category-<?php
echo $slug;
?>
h2.tribe-events-list-event-title.entry-title a,
.tribe-events-category-<?php
echo $slug;
?>
h2.tribe-events-list-event-title a
{
<table class="table">
<thead>
<tr>
<th>#</th>
<th>Name</th>
<th>Registered Via:</th>
<th>Access Role</th>
</tr>
</thead>
<tbody>
<?php
if ($users != null) {
$ind = 1;
foreach ($users as $user) {
$extras = new Extras();
$params = array();
$params[0] = array('user_id', $user->user_id);
$params[1] = array('deny_access', $user->deny_access);
$deleteUrl = $extras->encryptParams(KEY_SALT, $params, 'users.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$user->full_name}</td>";
$registered_via = @"----";
if ($user->facebook_id > 0) {
$registered_via = @"Facebook";
}
if ($user->twitter_id > 0) {
$registered_via = @"Twitter";
}
if ($user->google_id > 0) {
<tr>
<th>#</th>
<th>Name</th>
<th>Address</th>
<th>Contact No</th>
<th>Photos</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($agents != null) {
$ind = 1;
foreach ($agents as $agent) {
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'agent_id', $agent->agent_id, 'agent_update.php');
$deleteUrl = $extras->encryptQuery1(KEY_SALT, 'agent_id', $agent->agent_id, 'agents.php');
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$agent->name}</td>";
echo "<td>{$agent->address}</td>";
echo "<td>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_photo_thumb_{$agent->agent_id}'>Thumb</button>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_photo_large_{$agent->agent_id}'>Large</button>\n </td>";
echo "<td>{$agent->contact_no}</td>";
echo "<td>\n <a class='btn btn-primary btn-xs' href=\"{$updateUrl}\"><span class='glyphicon glyphicon-pencil'></span></a>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$agent->agent_id}'><span class='glyphicon glyphicon-remove'></span></button>\n </td>";
echo "</tr>";
echo "<div class='modal fade' id='modal_{$agent->agent_id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>\n\n <div class='modal-dialog'>\n <div class='modal-content'>\n <div class='modal-header'>\n <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>×</button>\n <h4 class='modal-title' id='myModalLabel'>Deleting Agent</h4>\n </div>\n <div class='modal-body'>\n <p>Deleting this is not irreversible. Do you wish to continue?\n </div>\n <div class='modal-footer'>\n <button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>\n <a type='button' class='btn btn-primary' href='{$deleteUrl}'>Delete</a>\n </div>\n </div>\n </div>\n </div>";
//<!-- Modal -->
echo "<div class='modal fade' id='modal_photo_thumb_{$agent->agent_id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>";
echo "<div class='modal-dialog'>";
echo "<div class='modal-content'>";
<table class="table">
<thead>
<tr>
<th>#</th>
<th >Name</th>
<th width="50%">Comment</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($reviews != null) {
$ind = 1;
foreach ($reviews as $review) {
$extras = new Extras();
$deleteUrl = $extras->encryptQuery2(KEY_SALT, 'review_id', $review->store_id, 'photo_id', $review->review_id, 'store_reviews_view.php');
$user = $controllerUser->getUserByUserId($review->user_id);
echo "<tr>";
echo "<td>{$ind}</td>";
echo "<td>{$user->full_name}</td>";
echo "<td>{$review->review}</td>";
echo "<td>\n <button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$review->review_id}'><span class='glyphicon glyphicon-remove'></span></button>\n \n </td>";
echo "</tr>";
//<!-- Modal -->
echo "<div class='modal fade' id='modal_{$review->review_id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>\n\n <div class='modal-dialog'>\n <div class='modal-content'>\n <div class='modal-header'>\n <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>×</button>\n <h4 class='modal-title' id='myModalLabel'>Deleting Review</h4>\n </div>\n <div class='modal-body'>\n <p>Deleting this is not irreversible. Do you wish to continue?\n </div>\n <div class='modal-footer'>\n <button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>\n <a type='button' class='btn btn-primary' href='{$deleteUrl}'>Delete</a>\n </div>\n </div>\n </div>\n </div>";
++$ind;
}
}
?>
<?php
require_once 'header.php';
$controller = new ControllerAuthentication();
$extras = new Extras();
$authentication_id = $extras->decryptQuery1(KEY_SALT, $_SERVER['QUERY_STRING']);
$user = $controller->getAccessUserByAuthenticationId($authentication_id);
if ($authentication_id != null) {
if (isset($_POST['submit'])) {
$itm = new Authentication();
$itm->authentication_id = $user->authentication_id;
$itm->name = trim(strip_tags($_POST['name']));
$itm->username = $user->username;
$pass = trim(strip_tags($_POST['password']));
$password_confirm = trim(strip_tags($_POST['password_confirm']));
$password_current = trim(strip_tags($_POST['password_current']));
$itm->password = md5($pass);
if (strlen($pass) < 8) {
echo "<script >alert('Password field must be atleast 8 alphanumeric characters.');</script>";
} else {
if ($user->password != md5($password_current)) {
echo "<script >alert('Current password does not match.');</script>";
} else {
if ($pass != $password_confirm) {
echo "<script >alert('Password does not match.');</script>";
} else {
$controller->updateAccessUser($itm);
echo "<script type='text/javascript'>location.href='admin_access.php';</script>";
}
}
}
echo "<a href='{$insertUrl}' class='btn btn-default btn-sm'><span class='glyphicon glyphicon-plus'></span></a>";
?>
</form>
</div>
</div>
<div class="panel-body">
<div class="row">
<?php
if ($photos_realestate != null) {
$ind = 1;
$count = count($photos_realestate);
foreach ($photos_realestate as $photo_realestate) {
$extras = new Extras();
$updateUrl = $extras->encryptQuery1(KEY_SALT, 'photo_id', $photo_realestate->photo_id, 'photo_realestate_update.php');
$deleteUrl = $extras->encryptQuery2(KEY_SALT, 'realestate_id', $photo_realestate->realestate_id, 'photo_id', $photo_realestate->photo_id, 'photo_realestate_view.php');
echo "<div class='col-sm-6 col-md-4'>";
echo "<div class='thumbnail'>";
echo "<img src='{$photo_realestate->thumb_url}' alt='...' style = 'display:block; height:150px; margin-left:auto; margin-right:auto; max-width:100%;'>";
echo "<div class='caption'>";
echo "<p>";
echo "<a href='{$updateUrl}' class='btn btn-primary btn-xs' role='button'>Edit</a> ";
echo "<button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#modal_{$photo_realestate->photo_id}'>Large Photo</button> ";
echo "<button class='btn btn-primary btn-xs' data-toggle='modal' data-target='#delete_modal_{$photo_realestate->photo_id}'>Delete</button>";
echo "</p>";
echo "</div>";
echo "</div>";
echo "</div>";
//<!-- Modal -->
