eda/config.php at master · alderven/eda · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php
require_once "common.php";

###################################################################################################
# I. Define Constants
###################################################################################################

# 1. Define DB constants
$servername = 'localhost';
$username = 'root';
$password = '12345';
$db_name = 'eda';
$table_users = 'users';
$table_food = 'food';
$table_orders = 'orders';
$table_filters = 'filters';
$table_config = 'config';

# 2. Define web site URL
$site_url = 'http://eda.adalisk.com/';

# 3. Define Email
$send_email_from = 'eda@adalisk.com';

###################################################################################################
# II. Connect to DB
###################################################################################################

# 1. Create DB connection
$conn = new mysqli($servername, $username, $password, $db_name);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

# 2. Configure DB encoding
$sql = "SET NAMES utf8";
$conn->query($sql);

###################################################################################################
# III. Get Email Password
###################################################################################################

$sql = "SELECT ParameterValue FROM $table_config WHERE ParameterName = 'EmailPassword'";
$result = $conn->query($sql);
 while ($row = $result->fetch_assoc()) {
	$send_email_from_pass = $row["ParameterValue"];
 }

# Proceed further only if User Session defined
if(isset($_SESSION['myusername'])) {

	# Get User info from DB
	$sql = "SELECT * FROM $table_users WHERE Login = '" . $_SESSION['myusername'] . "'";
	$result = $conn->query($sql);
	 while ($row = $result->fetch_assoc()) {
		$user_id = $row["Id"];
		$role_id = $row["RoleId"];
		$company_id = $row["CompanyId"];
		$name = $row["Name"];
		$surname = $row["Surname"];
		$email = $row["Login"];
	}


	###################################################################################################
	# IV. Get email recipients
	###################################################################################################

	# 4. Define Email recipients
	$recipients_adam = ['adoskhoev@adalisk.com', 'aananyev@adalisk.com', $email];
	$recipients_cimus = ['spetrochenkov@adalisk.com', 'aananyev@adalisk.com', $email];
	$recipients_kunak = ['vsmirnov@adalisk.com', 'spetrochenkov@adalisk.com', 'vvaplyushkin@adalisk.com', 'aananyev@adalisk.com'];
	$recipients_when_nothing_ordered = ['adoskhoev@adalisk.com', 'spetrochenkov@adalisk.com', 'aananyev@adalisk.com', $email];

	if (get_version() == 'Debug') {
		$recipients_adam = ['alexander.ananyev@glidewelldental.com', $email];
		$recipients_cimus = ['eda@adalisk.com', 'alexander.ananyev@glidewelldental.com', $email];
		$recipients_kunak = ['alexander.ananyev@glidewelldental.com'];
		$recipients_when_nothing_ordered = ['alexander.ananyev@glidewelldental.com', $email];
	}

	###################################################################################################
	# V. Generate Navigation Bar
	###################################################################################################

	# 3. Initialize Admin Navigation Bar depending on the User RoleId
	$adminNavBar = '';
	if ($role_id == 0 or $role_id == 1) {
		$adminNavBar = '<li class="dropdown">
					<a href="" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Администрирование<span class="caret"></span></a>
					<ul class="dropdown-menu">
						<li><a href="excel.php"><span class="glyphicon glyphicon-paperclip"></span> Управление Excel файлами</a></li>
						<li><a href="admin.users.php"><span class="glyphicon glyphicon-user"></span> Управление пользователями</a></li>
					</ul>
				</li>';
	}

	# 4. Define Navigation Bar
	$navigationBar = '
	<div class="flex-container container">
		<nav class="navbar navbar-default">
			<div class="container-fluid">
			  <div class="navbar-header">
				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
				  <span class="sr-only">Toggle navigation</span>
				  <span class="icon-bar"></span>
				  <span class="icon-bar"></span>
				  <span class="icon-bar"></span>
				</button>
				<a class="navbar-brand" href="menu.php"><span class="glyphicon glyphicon-cutlery"></span> Сервис "Еда"</a>
			  </div>
			  <div id="navbar" class="navbar-collapse collapse">
				<ul class="nav navbar-nav">
					<li><a href="menu.php"><span class="glyphicon glyphicon-list-alt"></span> Меню</a></li>
					<li class="dropdown">
						<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Настройки<span class="caret"></span></a>
						<ul class="dropdown-menu">
							<li><a href="presettings.php"><span class="glyphicon glyphicon-filter"></span> Ручной фильтр</a></li>
							<li><a href="settings_autofill.php"><span class="glyphicon glyphicon-random"></span> Автозаполнение</a></li>
						</ul>
					</li>
					<li class="dropdown">
						<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Статистика<span class="caret"></span></a>
						<ul class="dropdown-menu">
							<li><a href="stat.php"><span class="glyphicon glyphicon-stats"></span> Общая статистика</a></li>
							<li><a href="stat_orders_history.php"><span class="glyphicon glyphicon-calendar"></span> История заказов</a></li>
							<li><a href="stat_favorite_dishes.php"><span class="glyphicon glyphicon-heart"></span> Любимые блюда</a></li>
						</ul>
					</li>
					<li class="dropdown">
						<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Разработка<span class="caret"></span></a>
						<ul class="dropdown-menu">
							<!--<li><a href="whats_new.php"><span class="glyphicon glyphicon-question-sign"></span> Что нового?</a></li>-->
							<li><a href="api.php"><span class="glyphicon glyphicon-transfer"></span> Открытое API</a></li>
							<li><a href="android.php"><span class="glyphicon glyphicon-phone"></span> Android-версия</a></li>
						</ul>
					</li>' . $adminNavBar . '</ul>
				<ul class="nav navbar-nav navbar-right">
					<li class="dropdown">
						<a href="" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><span class="glyphicon glyphicon-user"></span> ' . $name . ' ' . $surname . ' <span class="caret"></span></a>
						<ul class="dropdown-menu">
							<li><a href="change_password.php"><span class="glyphicon glyphicon-cog"></span> Сменить пароль</a></li>
							<li><a href="logout.php"><span class="glyphicon glyphicon-log-out"></span> Выйти</a></li>
						</ul>
					</li>
				</ul>
				</div><!--/.nav-collapse -->
			</div><!--/.container-fluid -->
		</nav>';
}
?>