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(); }