/**
* @param mixed $id
* @return array
* @throws EntityNotFoundException
* @throws InvalidArgumentException
*/
public static function find($id)
{
if (!empty($id) and is_numeric($id)) {
$entity = db::get_single_row("SELECT * FROM " . static::TABLE . " WHERE id = " . db::input($id));
if (empty($entity)) {
throw new EntityNotFoundException($id, self::getEntity());
} else {
return $entity;
}
} else {
throw new InvalidArgumentException(self::getEntity());
}
}
$result[] = 'Оплачено';
Order::update($_GET['order_id'], array('referrer_payment_date' => date('Y-m-d H:i:s')));
break;
case 'oplata_kln':
case 'cost_kln':
case 'cost_auth':
case 'author_paid':
case 'company_paid':
case 'about_mng':
//коментарий
$result[] = $value = $_GET['value'];
break;
case 'time_auth':
$value = utils_cvt_date2i(str_replace('.', '-', $_GET['value']));
$result[] = $_GET['value'];
$author_info = db::get_single_row("\n SELECT u.id, u.email, u.fio\n FROM " . TABLE_USERS . " u\n JOIN " . TABLE_ORDERS . " o ON o.author_id = u.id\n WHERE o.id = " . db::input($_GET['order_id']) . "\n ");
if ($author_info) {
// Author::sendEmail($_GET['order_id'], array($author_info['id']), '№' . $_GET['order_id'] . ' ИЗМЕНИЛАСЬ ДАТА', '№' . $_GET['order_id'] . ' ИЗМЕНИЛАСЬ ДАТА на ' . $_GET['value']);
$message_id = mls_Send("u" . $author_info['id'], "u" . $_SESSION["user"]["data"]["id"], '№' . $_GET['order_id'] . ' ИЗМЕНИЛАСЬ ДАТА', '№' . $_GET['order_id'] . ' ИЗМЕНИЛАСЬ ДАТА на ' . $_GET['value'], 1, 0);
Author::enqueue_message_to_email($message_id, array($author_info['id']), \Components\Entity\EmailNotification::TO_AUTHOR_ON_ORDER_CHANGE);
}
break;
case 'debt_to_author':
$bDoUpdate = false;
$orders = explode(',', $_GET['order_id']);
foreach ($orders as $order_id) {
$order_id = trim($order_id);
if (empty($order_id)) {
continue;
}
$order_info = get_order_info($order_id);
<?php
use Components\Classes\db;
$client_change_history = db::get_single_row("SELECT * FROM " . TABLE_CLIENTS_HISTORY . " WHERE id = " . db::input($_REQUEST['change']));
/******************** before edit start ********************/
$h = 580;
$frm = $GUI->Form("Данные о клиенте до изменений", 400, $h);
$frm->VLine(10, $h - 80, 380);
$b = $frm->Button("Назад", 155, $h - 60, 100);
$b->Event = "document.location.href=\"?section=kln&subsection=2&kln_id=" . $_REQUEST['kln_id'] . "&action=history_table\"";
$ypos = 10;
$frm->Label("Имя", 10, $ypos);
$t = $frm->Text(10, $ypos += 20, 380, $client_change_history["fio_old"]);
//1
$t->linkName = "fio";
$frm->Label("Филиал", 10, $ypos += 30);
$t = $frm->Text(10, $ypos += 20, 380, get_filial_name($client_change_history["filial_id_old"]));
//1
$t->linkName = "filial_id";
$before_edit_pass = '******';
$frm->Label("Пароль", 10, $ypos += 30);
$t = $frm->Text(10, $ypos += 20, 380, $before_edit_pass);
//1
$t->linkName = "hpwd";
$frm->Label("Почта", 10, $ypos += 30);
$t = $frm->Text(10, $ypos += 20, 180, $client_change_history["email_old"]);
//4
$t->linkName = "email";
$frm->Label("Телефон", 210, $ypos - 20);
$t = $frm->Text(210, $ypos, 180, $client_change_history["telnum_old"]);
//5
<?php
use Components\Classes\db;
require_once '../../includes/application_top.php';
if (!$_SESSION["user"]["auth"]) {
die("запрещено");
}
if (!isset($_REQUEST["num"])) {
die("нет данных");
}
$num = intval($_REQUEST["num"]);
$message = db::get_single_row("SELECT * FROM " . TABLE_MESSAGES . " WHERE id = " . db::input($num) . " AND (creator_id = 'u" . $_SESSION["user"]["data"]["id"] . "' OR addr = 'u" . $_SESSION["user"]["data"]["id"] . "')");
if (!$message) {
die("сообщение не найдено");
}
$tp = "i";
if ($message["addr"] != "u" . $_SESSION["user"]["data"]["id"]) {
$tp = "o";
}
if ($message["basket"]) {
$tp = "b";
}
die("<p><input type='button' value='Перейти' onclick='document.location.href=\"?section=mls&subsection=2&type=" . $tp . "&read=" . $num . "\"'></p>" . text_to_html($message["text"]));
function impdiscip_exec($Frm, $Err)
{
if (!$Err) {
$v = $Frm->GetValue(0);
if (!strpos($v["type"], "ms-excel")) {
$Frm->_gui->informer->ERR("Неправильный тип файла");
page_reloadSubSec();
} else {
$s = "";
if ($Frm->GetValue(1)) {
db::truncate(TABLE_DISCIPLINE);
db::truncate(TABLE_DISCIPLINE_TO_NAPRAVL);
db::truncate(TABLE_AUTHOR_TO_DISCIPLINE);
$s = "Таблица очищена. ";
}
require_once DIR_FS_DOCUMENT_ROOT . "/ext/PHPExcel/PHPExcel.php";
$loader = PHPExcel_IOFactory::load($v['tmp_name']);
$loader->setActiveSheetIndex(0);
$sheet = $loader->getActiveSheet();
$colNumber = PHPExcel_Cell::columnIndexFromString($sheet->getHighestColumn());
if ($colNumber < 1 or $colNumber > 2) {
$Frm->_gui->informer->ERR("В таблице должно быть от 1 до 2 колонок(сейчас " . $colNumber . ")");
page_reloadSubSec();
}
$rowIterator = $sheet->getRowIterator();
$addcnt = 0;
foreach ($rowIterator as $row) {
// Получили ячейки текущей строки и обойдем их в цикле
$cellIterator = $row->getCellIterator();
foreach ($cellIterator as $cell) {
$value = trim($cell->getValue());
$color = $sheet->getStyle($cell->getCoordinate())->getFill()->getEndColor()->getRGB();
if ($color == '000000') {
$napravl = db::get_single_row("SELECT * FROM " . TABLE_NAPRAVL . " WHERE LOWER(name) = '" . db::input(strtolower($value)) . "'");
if ($napravl) {
$napravl_id = $napravl['id'];
} else {
$napravl_id = Napravl::create(array('name' => $value));
}
} else {
if (empty($napravl_id)) {
continue 2;
}
$discipline = db::get_single_row("SELECT * FROM " . TABLE_DISCIPLINE . " WHERE LOWER(name) = '" . db::input(strtolower($value)) . "'");
if ($discipline) {
Disciplines::addToNaprav($discipline['id'], $napravl_id);
continue 2;
} else {
$discipline_id = Discipline::create(array('name' => $value));
Disciplines::addToNaprav($discipline_id, $napravl_id);
$addcnt++;
}
}
}
}
$Frm->_gui->informer->OK($s . "Добавлено " . $addcnt . " строк");
page_reloadSubSec();
}
}
}
/**
* @deprecated
* @param $internal_name
* @return array
*/
function get_config_by_iname($internal_name)
{
return db::get_single_row("SELECT * FROM " . TBL_PREF . "configs WHERE internal_name = '" . db::input($internal_name) . "'");
}
function LoadFromBase()
{
if (CGUI_FILTERS_DEBUG) {
$this->_gui->DBG("> FilterColletion > LoadFromBase");
}
if ($this->cfg_table && $this->cfg_field) {
if ($this->cfg_table == 'clients') {
$id = $_SESSION["frame"]["client"]["id"];
} else {
$id = $_SESSION["user"]["data"]["id"];
}
$fields = db::get_single_row("SELECT " . $this->cfg_field . " FROM " . TBL_PREF . $this->cfg_table . " WHERE id = " . $id);
if (count($fields) && strlen($fields[$this->cfg_field])) {
$sv = unserialize($fields[$this->cfg_field]);
//load usersets
foreach ($this->userSets as $k => $v) {
if (isset($sv["usersets"][$v->id])) {
$v->LoadBaseConf($sv["usersets"][$v->id]);
}
}
foreach ($this->stdSets as $k => $v) {
if (isset($sv["stdsets"][$v->id])) {
$v->LoadBaseConf($sv["stdsets"][$v->id]);
}
}
}
}
}
