function send()
{
$emails = array();
$groups = array();
if (!isset($_POST['users']) and !isset($_POST['email'])) {
return;
}
$sqlGroups = '';
if (!empty($_POST['users'])) {
foreach ($_POST['users'] as $item) {
if ($item == 'iusers') {
$sql = 'SELECT email FROM {{iusers}} WHERE visible=1';
$emails = array_merge($emails, DB::getAll($sql, 'email'));
} elseif ($item == 'subscribers') {
$sql = 'SELECT email FROM {{subscribers}}';
$emails = array_merge($emails, DB::getAll($sql, 'email'));
} elseif ($item == 'orders') {
$sql = 'SELECT email FROM {{orders}}';
$emails = array_merge($emails, DB::getAll($sql, 'email'));
} else {
$groups[] = $item;
}
}
$sqlGroups = 'emailgroups=\'' . implode(',', $_POST['users']) . '\',';
}
if (!empty($groups)) {
$users = Iuser::getGroupUsers($groups, 'email');
$emails = array_merge($emails, $users);
}
$emails[] = $_POST['email'];
$emails = array_unique($emails);
$text = View::getRenderFullEmpty('email/notifications', array('text' => $_POST['body'], 'title' => $_POST['subject']));
foreach ($emails as $email) {
$mail = new Email();
$mail->Text($text);
$mail->Subject($_POST['subject']);
$mail->From($_POST['emailfrom']);
$mail->mailTo($email);
$mail->Send();
}
$sql = '
INSERT INTO {{notification}}
SET
subject=\'' . $_POST['subject'] . '\',
body=\'' . $_POST['body'] . '\',
email=\'' . implode(',', $emails) . '\',
' . $sqlGroups . '
emailfrom=\'' . $_POST['emailfrom'] . '\',
cdate=NOW(),
author=' . $_SESSION['user']['id'] . '
';
DB::exec($sql);
}
function show()
{
if (Funcs::$uri[3]) {
$model = new Notification();
$data = $model->getEdit(Funcs::$uri[3]);
}
$data['formpath'] = 'send';
// Получаем статусы пользователей
$data['groups'] = Iuser::getGroupList();
$data['emailfrom'] = 'robot@' . str_replace('www.', '', $_SERVER["HTTP_HOST"]);
View::plugin('send', $data);
}
public function generatepass()
{
print Iuser::generate_password(8);
}
<td id="name"></td>
<td>
<div class="input_text_holder">
<input id="inputText" type="text" class="input_text" disabled name="value" value="<?php
echo $value;
?>
">
</div>
</td>
</tr>
<tr id="select" style="display:none">
<td>Промо-код на статус</td>
<td>
<select id="inputSelect" name="value" disabled>
<?php
foreach (Iuser::getStatusList() as $item) {
?>
<option value="<?php
echo $item['id'];
?>
" <?php
if ($item['id'] == $value) {
?>
selected<?php
}
?>
><?php
echo $item['name'];
?>
</option>
<?php
public static function setOrderUser($orderId, $iuserId)
{
$iuser = Iuser::getIuser($iuserId);
$address = IuserAddress::getAddresses($iuserId);
$sql = '
UPDATE {{orders}}
SET iuser='******',
name=\'' . $iuser['name'] . '\',
phone=\'' . $iuser['phone'] . '\',
email=\'' . $iuser['email'] . '\',
address=\'' . serialize($address[0]) . '\',
wdate=NOW(),
authoredit=' . $_SESSION['user']['id'] . '
WHERE id=' . $orderId . '
';
DB::exec($sql);
}
function editUser()
{
DB::escapePost();
$fields = '';
foreach (OneSSA::$iuserStandart as $key => $item) {
if ($key == 'pass' && trim($_POST[$key]) != '') {
$fields .= '' . $key . '=MD5(\'' . $_POST[$key] . '\'), ';
} else {
$fields .= '' . $key . '=\'' . $_POST[$key] . '\', ';
}
}
$user = $_POST['id'];
if ($_POST['igroup'] == '') {
$_POST['igroup'] = 0;
}
$sql = '
UPDATE {{iusers}}
SET
' . $fields . '
igroup=' . $_POST['igroup'] . '
WHERE id=' . $user . '
';
DB::exec($sql);
$addingSql = '';
if (count($_POST['fileIds']) > 0) {
$addingSql = ' AND id NOT IN (' . implode(',', $_POST['fileIds']) . ') ';
}
$sql = '
SELECT path FROM {{iusers_files}}
WHERE iuser='******' ' . $addingSql . '
';
$delFiles = DB::getAll($sql, 'path');
foreach ($delFiles as $item) {
unlink($_SERVER['DOCUMENT_ROOT'] . $item);
}
$dir = md5('touch' . $user);
$dir = '/u/files/iusers/' . $dir . '/';
if (is_dir($_SERVER['DOCUMENT_ROOT'] . $dir)) {
if (count(scandir($_SERVER['DOCUMENT_ROOT'] . $dir)) == 2) {
rmdir($_SERVER['DOCUMENT_ROOT'] . $dir);
}
}
$sql = '
DELETE FROM {{iusers_files}}
WHERE iuser='******' ' . $addingSql . '
';
DB::exec($sql);
Iuser::upload($user);
$sql = '
DELETE FROM {{iusers_adds}}
WHERE iuser='******'
';
DB::exec($sql);
$data = array();
foreach (OneSSA::$iuserStandartAdds as $title => $items) {
foreach ($items as $key => $item) {
if ($item['main'] != 1) {
if ($item['type'] == 'bool') {
$data[$key] = $_POST[$key] == 1 ? '1' : '0';
} else {
$data[$key] = $_POST[$key];
}
}
}
}
foreach ($data as $key => $item) {
$sql = '
INSERT INTO {{iusers_adds}}
SET iuser='******',
name=\'' . $key . '\',
string_value=\'' . $_POST[$key] . '\'
';
DB::exec($sql);
}
}
public function checkfield()
{
print Iuser::checkFieldUnique();
}
