public function add()
{
if (isset($_POST['save_user_btn'])) {
$row = [];
if ($_GET['id']) {
$row['id'] = $_GET['id'];
} else {
$row['create_date'] = date('Y-m-d H:i:s');
}
$row['email'] = $_POST['email'];
$row['user_name'] = $_POST['user_name'];
$row['user_surname'] = $_POST['user_surname'];
$row['user_group_id'] = $_POST['user_group_id'];
if ($_POST['user_password']) {
$row['user_password'] = md5($_POST['user_password']);
}
$this->model('backend_users')->insert($row);
if ($_POST['user_password']) {
$this->logOut();
$this->auth(registry::get('user')['email'], md5($_POST['user_password']));
registry::remove('user');
$this->checkAuth();
}
header('Location: ' . SITE_DIR . 'users/');
exit;
}
$this->render('user_groups', $this->model('user_groups')->getAll());
if ($_GET['id']) {
$this->render('user', $this->model('backend_users')->getById($_GET['id']));
}
$this->view('users' . DS . 'add');
}
public function unites_ajax()
{
switch ($_REQUEST['action']) {
case "save_taste":
$taste = $_POST['taste'];
$taste['id'] = $this->model('tastes')->insert($taste);
$taste['status'] = 1;
echo json_encode($taste);
exit;
break;
case "save_unit":
$rows = [];
$date = date('Y-m-d H:i:s');
for ($i = 0; $i < $_POST['quantity']; $i++) {
$rows[$i] = $_POST['unit'];
$rows[$i]['create_date'] = $date;
$rows[$i]['creator'] = registry::get('user')['id'];
}
$this->model('stock_units')->insertRows($rows);
echo json_encode(array('status' => 1));
exit;
break;
case "get_unites":
$params = [];
$params['table'] = 'stock_units u';
$params['join']['tastes'] = array('as' => 't', 'on' => 't.id = u.taste_id', 'left' => true);
$params['join']['products'] = array('as' => 'p', 'on' => 'p.id = u.product_id');
$params['select'] = array('p.product_name', 'IF(t.taste_name, t.taste_name, " - ")', 'IF(t.expiration_date, t.expiration_date, " - ")');
exit;
break;
}
}
/**
* Construct
*
* @param registry $registry
* @param int $currency_id Current currency_id id
*/
public function __construct($registry, $currency_id)
{
$this->_db = $registry->get('db');
try {
$statement = $this->_db->prepare('SELECT * FROM `currency`');
$statement->execute();
} catch (PDOException $e) {
if ($this->db->inTransaction()) {
$this->db->rollBack();
}
trigger_error($e->getMessage());
}
if ($statement->rowCount()) {
foreach ($statement->fetchAll() as $currency) {
$this->_currencies[$currency->currency_id] = array('currency_id' => $currency->currency_id, 'code' => $currency->code, 'rate' => $currency->rate, 'symbol' => $currency->symbol, 'name' => $currency->name);
if ($currency->currency_id == $currency_id) {
$this->_currency_id = $currency->currency_id;
$this->_currency_code = $currency->code;
$this->_currency_rate = $currency->rate;
$this->_currency_name = $currency->name;
$this->_currency_symbol = $currency->symbol;
}
}
}
}
protected function render($key, $value)
{
$common_vars = registry::get('common_vars');
if (!$common_vars) {
$common_vars = [];
}
$common_vars[$key] = $value;
registry::set('common_vars', $common_vars);
}
public function savePositions($positions)
{
$stm = $this->pdo->prepare('
UPDATE modules_user_groups_relations SET x_position = :x_position, y_position = :y_position WHERE module_id = :module_id AND user_group_id = :user_group_id
');
foreach ($positions as $module_id => $data) {
$data['module_id'] = $module_id;
$data['user_group_id'] = registry::get('user')['user_group_id'];
$stm->execute($data);
}
}
/**
* @param string $model
* @param null/string $table
* @param null/string $db
* @param null/string $user
* @param null/string $password
* @return model
*/
protected function model($model, $table = null, $db = null, $user = null, $password = null)
{
$models = registry::get('models');
if (!($m = $models[$model][$table])) {
$model_file = ROOT_DIR . 'models' . DS . $model . '_model.php';
if (file_exists($model_file)) {
$model_class = $model . '_model';
$m = new $model_class($table ? $table : $model, $db, $user, $password);
} else {
$m = new default_model($model);
}
$models[$model][$table] = $m;
registry::remove('models');
registry::set('models', $models);
}
return $m;
}
public function catcher($category)
{
$this->render('categories', $this->model('categories')->getCategories());
$active_category = $this->model('categories')->getByField('category_key', $category);
if ($active_category) {
$limit = 10;
$count = $this->model('products')->countCategoryProducts($active_category['id']);
$count_pages = ceil($count / $limit);
if ($_GET['page'] > 1 && is_numeric($_GET['page'])) {
$lim = $limit . ', ' . ($count_pages * $limit > $count ? $count_pages * $limit : $count);
} else {
$lim = $limit;
}
$pages = [];
for ($i = 1; $i <= $count_pages; $i++) {
$params = $_GET;
$params['page'] = $i;
$url = SITE_DIR . registry::get('route') . '?' . http_build_query($params);
$pages[$i] = $url;
}
$this->render('pages', $pages);
if (isset($_GET['order'])) {
switch ($_GET['order']) {
case "name":
$order = 'p.product_name' . (isset($_GET['desc']) ? ' DESC' : '');
break;
case "price":
$order = 'p.price' . (isset($_GET['desc']) ? ' DESC' : '');
break;
case "bestseller":
$order = 'p.bestseller' . (!isset($_GET['desc']) ? ' DESC' : '');
break;
}
}
$this->render('products', $this->model('products')->getCategoryProducts($active_category['id'], $order, $lim));
$this->render('bestsellers', $this->model('products')->getCategoryBestsellers($active_category['id'], 3));
$this->render('active_category', $active_category);
$this->view('catalog' . DS . 'index');
} else {
$this->view('common' . DS . '404');
}
}
public function index_ajax()
{
switch ($_REQUEST['action']) {
case "save_password":
if ($_POST['password'] && $_POST['password'] == $_POST['repeat_password']) {
$row = array('id' => registry::get('user')['id'], 'user_password' => md5($_POST['password']));
if ($this->model('asanatt_users')->insert($row)) {
echo json_encode(array('status' => 1));
$this->logOut();
$this->auth(registry::get('user')['email'], md5($_POST['password']));
registry::remove('user');
$this->checkAuth();
} else {
echo json_encode(array('status' => 2));
}
}
exit;
break;
}
}
public function getRestChartsList($url)
{
$stm = $this->pdo->prepare('
SELECT
chart_name,
url,
icon,
color
FROM
asanatt_charts c
JOIN
asanatt_charts_user_groups_relations r ON r.chart_id = c.id
WHERE
r.user_group_id = :user_group_id
AND
c.url != :url
ORDER BY c.position
');
return $this->get_all($stm, array('user_group_id' => registry::get('user')['user_group_id'], 'url' => $url));
}
<div class="col-md-offset-1 col-md-4">
<div class="form-group">
<label for="language">
Language
</label>
<select id="language" class="form-control" name="settings[1][language]">
<option value="rus" <?php
if (registry::get('language') == 'rus') {
echo 'selected';
}
?>
>
Russian
</option>
<option value="eng" <?php
if (registry::get('language') == 'eng') {
echo 'selected';
}
?>
>
English
</option>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-offset-1 col-md-4">
<input type="submit" class="btn btn-lg btn-info" value="Save">
</div>
</div>
<!--<a id="navbar-home-btn" href="--><?php
//echo SITE_DIR;
?>
<!--">-->
<!-- <i class="fa fa-home"></i>-->
<!--</a>-->
<div class="navbar-right">
<ul class="nav navbar-nav">
<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">
<i class="fa fa-user"></i>
<span><?php
echo registry::get('user')['user_name'];
?>
<?php
echo registry::get('user')['user_surname'];
?>
<i class="caret"></i></span>
</a>
<ul class="dropdown-menu dropdown-custom dropdown-menu-right">
<li class="dropdown-header text-center">Account</li>
<li class="divider"></li>
<li>
<a data-toggle="modal" href="<?php
echo SITE_DIR;
?>
settings/">
<i class="fa fa-cog fa-fw pull-right"></i>
Settings
</a>
</li>
<?php
$module_name = 'registration';
$module_loader =& registry::get('TModuleLoader');
$module_loader->registerClassFile('TRegistration', 'modules/' . $module_name . '/registration.class');
/**
* @param mixed $value
*/
protected function log($value)
{
$log = registry::get('log');
registry::remove('log');
$log[] = print_r($value, 1);
registry::set('log', $log);
}
</li>
<li<?php
if (registry::get('route') == 'about') {
echo ' class="active"';
}
?>
>
<a href="<?php
echo SITE_DIR;
?>
about/">
<div class="ct-textEffect"><span data-content="Новости">О нас</span></div>
</a>
</li>
<li<?php
if (registry::get('route') == 'contacts') {
echo ' class="active"';
}
?>
>
<a href="<?php
echo SITE_DIR;
?>
contacts/">
<div class="ct-textEffect"><span data-content="Новости">Контакты</span></div>
</a>
</li>
<!-- <li class="dropdown"><a href="rent-now.html"><div class="ct-textEffect"><span data-content="Rent Now">Rent Now</span></div></a>-->
<!-- <ul class="dropdown-menu">-->
<!-- <li><a href="rent-now.html"><span>Rent Now</span></a></li>-->
<!-- <li><a href="rent-item.html"><span>Rent Item</span></a></li>-->
protected $_objects = array();
function set($name, &$object)
{
$this->_objects[$name] =& $object;
}
function &get($name)
{
return $this->_objects[$name];
}
}
// 2. use
// First we create our database and registry objects
$db = new databaseConnection();
$registry = new registry();
// Then we add the db object to the registry
// It will now be available anywhere the registry
// is also available!
$registry->add("database", $db);
// Now we create the objet that gets our username
// and checks for admin status
$user = new username($registry);
$admin = new admin($registry);
$username = $user->getUser(12);
$isAdmin = $admin->check($username);
echo "Username: "******"<br />";
//output: Username: 12
echo "Is Admin? " . $isAdmin;
//output: is Admin? boolean answer 0 or 1
// 3. further use
$databaseObj = $registry->get("database");
$databaseObj->query("SELECT username FROM users" . " WHERE id={$userId}");
public function getLocale($table, $key)
{
$row = array('language' => registry::get('language'), 'locale_key' => $key, 'locale_table' => $table);
return $this->model('locale')->getByFields($row)['locale_value'];
}
/**
* Override registry get method
* @throws modules_exception
*/
public function get($id)
{
if ($id == 'core') {
return core::get_instance();
}
$return = parent::get($id);
if (!$return) {
throw new modules_exception('Try to get unloaded module ' . $id);
}
return $return;
}
private function tasks($workspace_id)
{
$this->render('week_offset', 0);
$this->render('workspace_name', $_SESSION['asana']['workspace_name']);
if (!$_SESSION['asana']['tasks']) {
$tasks = $this->api()->getTasks($workspace_id, registry::get('user')['asana_id']);
$_SESSION['asana']['tasks'] = $tasks;
} else {
$tasks = $_SESSION['asana']['tasks'];
}
$projects = [];
foreach ($tasks['data'] as $k => $task) {
$id = number_format($task['projects'][0]['id'], 0, '.', '');
$tasks['data'][$k]['projects'][0]['id'] = $id;
$task['projects'][0]['id'] = $id;
$projects[$id] = $task['projects'][0];
$tasks['data'][$k]['worked_time'] = $this->getWorkedTime($task['id'], registry::get('user')['asana_id']);
$tasks['daily'][$k] = $this->model('time')->getWorkedTimeDaily($task['id'], registry::get('user')['asana_id']);
$ex_task = $this->model('asanatt_task')->getByFields(array('tid' => $task['id'], 'userid' => registry::get('user')['asana_id']));
if (!$ex_task || !$ex_task['userid']) {
$ex_task['tid'] = $task['id'];
$ex_task['userid'] = registry::get('user')['asana_id'];
$ex_task['project'] = isset($task['projects'][0]['name']) ? $task['projects'][0]['name'] : '';
$ex_task['name'] = $task['name'];
$ex_task['username'] = registry::get('user')['email'];
$play_date = $task['created_at'] ? substr($task['created_at'], 0, 10) : date('Y-m-d');
$ex_task['play_date'] = $play_date;
$this->model('asanatt_task')->insert($ex_task);
} elseif ($ex_task['project'] != $task['projects'][0]['name'] || $ex_task['name'] != $task['name']) {
$ex_task['project'] = isset($task['projects'][0]['name']) ? $task['projects'][0]['name'] : '';
$ex_task['name'] = $task['name'];
$this->model('asanatt_task')->insert($ex_task);
}
if (!empty($_GET['project'])) {
if ($task['projects'][0]['id'] != $_GET['project']) {
unset($tasks['data'][$k]);
unset($tasks['daily'][$k]);
}
}
}
$this->render('projects', $projects);
$this->render('tasks', $tasks);
$template = $this->fetch('tracker' . DS . 'tasks');
return $template;
}
<form action="#" method="get" class="sidebar-form">
<div class="input-group">
<input type="text" name="q" class="form-control" placeholder="Search..."/>
<span class="input-group-btn">
<button type='submit' name='seach' id='search-btn' class="btn btn-flat"><i class="fa fa-search"></i></button>
</span>
</div>
</form>
<!-- /.search form -->
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu">
<?php
foreach ($sidebar as $k => $v) {
?>
<li <?php
if (registry::get('route_parts')[0] == $v['route']) {
echo 'class="active"';
}
?>
>
<?php
if (!$v['children']) {
?>
<a href="<?php
echo ($v['external'] ? '' : SITE_DIR) . ($v['route'] ? $v['route'] . '/' : '');
?>
">
<?php
}
?>
<?php
?>
">
<div class="error-require validate-message">
Обязательное поле
</div>
<div class="validate-message" id="key_unique_error">
Данный ключ уже используется
</div>
</div>
<div class="form-group">
<label>Изображение</label>
<div class="row">
<div class="col-md-3">
<input name="logo" type="button" value="Загрузить" class="btn btn-default" id="upload_btn" />
<input type="hidden" id="rand" value="<?php
echo mktime() . registry::get('user')['id'];
?>
">
<input type="hidden" name="category[image]" value="" id="category_image_hidden_input">
</div>
<div class="col-md-4">
<span id="upload_status"></span>
<span id="preview">
<?php
if ($category['image'] && file_exists(ROOT_DIR . 'uploads' . DS . 'images' . DS . 'category_images' . DS . $category['image'])) {
?>
<img src="<?php
echo SITE_DIR . 'uploads/images/category_images/' . $category['image'] . '?' . rand();
?>
" />
<?php
/**
* Override registry get method
* @throws modules_exception
*/
public function get($id)
{
if ($id == 'core') {
return core::get_instance();
}
$return = parent::get($id);
if (!$return) {
// try deferred
$return = $this->resolve_deferred($id);
if (!$return) {
throw new module_exception('Try to get unloaded module ' . $id);
}
}
return $return;
}
<div class="page-head">
<div class="container">
<div class="page-title">
<h1><?php
echo $breadcrumb['title'] ? $breadcrumb['title'] : registry::get('system_route')['title'];
?>
</h1>
</div>
</div>
</div>
protected function api()
{
if (!($api = registry::get('asana_api'))) {
$api = new api_class();
registry::set('asana_api', $api);
}
return $api;
}
public function getOvertime($dates)
{
$stm = $this->pdo->prepare('
SELECT * FROM dashboard.asanatt_overtime WHERE work_date BETWEEN :date_from AND :date_to
');
$approved = [];
foreach ($this->get_all($stm, $dates) as $v) {
$approved[$v['work_date']][$v['user_id']] = $v['overtime_approved'];
}
$stm = $this->pdo->prepare('
SELECT
DATE(t.work_end) date,
u.id user_id,
(HOUR(TIMEDIFF(work_end, work_begin)) +
MINUTE(TIMEDIFF(work_end, work_begin))/60) - ' . registry::get('config')['day_length'] . ' value
FROM
asanatt_excel_time t
JOIN
asanatt_user_mapping u ON u.user_name = t.username
WHERE
work_begin BETWEEN :date_from AND :date_to
AND TIMEDIFF(work_end, work_begin) > "' . (registry::get('config')['day_length'] >= 10 ? registry::get('config')['day_length'] : '0' . (int) registry::get('config')['day_length']) . ':00:00"
');
$tmp = $this->get_all($stm, $dates);
//print_r($tmp);
$res = [];
foreach ($tmp as $v) {
if ($approved[$v['date']][$v['user_id']] > $v['value']) {
$v['value'] = $approved[$v['date']][$v['user_id']];
$res[$v['date']][$v['user_id']] = $v;
} elseif ($approved[$v['date']][$v['user_id']]) {
$v['value'] = $approved[$v['date']][$v['user_id']];
$res[$v['date']][$v['user_id']] = $v;
}
}
return $res;
}
function _get($id)
{
return parent::get($id);
}
public function settings()
{
$this->render('config', registry::get('config'));
$this->view('summary' . DS . 'settings');
}
