public function Select($ServerID)
{
/******************************************************************************/
$__args_types = array('integer');
#-------------------------------------------------------------------------------
$__args__ = Func_Get_Args();
eval(FUNCTION_INIT);
/******************************************************************************/
$Settings = DB_Select('Servers', '*', array('UNIQ', 'ID' => $ServerID));
#-------------------------------------------------------------------------------
switch (ValueOf($Settings)) {
case 'error':
return ERROR | @Trigger_Error('[HostingServer->Select]: не удалось выбрать сервер');
case 'exception':
return new gException('SERVER_NOT_FOUND', 'Указаный сервер не найден');
case 'array':
#-------------------------------------------------------------------------------
$this->SystemID = $Settings['Params']['SystemID'];
#-------------------------------------------------------------------------------
$this->Settings = $Settings;
#-------------------------------------------------------------------------------
if (Is_Error(System_Load(SPrintF('libs/%s.php', $this->SystemID)))) {
@Trigger_Error('[HostingServer->Select]: не удалось загрузить целевую библиотеку');
}
#-------------------------------------------------------------------------------
return TRUE;
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
}
function smarty_function_copyright($params, $smarty)
{
$Copyright = DB_Select('Config', 'Value', array('UNIQ', 'Where' => "`Param` = 'Copyright'"));
if (!Is_Array($Copyright)) {
return ERROR | @Trigger_Error(500);
}
return $Copyright['Value'];
}
public function getParams()
{
$Server = DB_Select('Servers', array('Address', 'Params'), array('UNIQ', 'Where' => SPrintF('(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = %u) = `Servers`.`ID`', $this->params['OrderID'])));
if (!Is_Array($Server)) {
return ERROR | @Trigger_Error(500);
}
$this->params['Server'] = $Server;
return $this->params;
}
public function getParams()
{
Debug(print_r($this->params, true));
$Service = DB_Select('Services', array('ID', 'Code', 'Name', 'NameShort'), array('UNIQ', 'ID' => $this->params['ServiceID']));
if (!Is_Array($Service)) {
return ERROR | @Trigger_Error(500);
}
$this->params['Service'] = $Service;
return $this->params;
}
public function FindSystem($ExtraIPOrderID, $OrderType, $DependOrderID)
{
/****************************************************************************/
$__args_types = array('integer', 'string', 'integer');
$__args__ = Func_Get_Args();
eval(FUNCTION_INIT);
/****************************************************************************/
/* find server */
Debug(SPrintF('[system/classes/ExtraIPServer]: OrderType = %s', $OrderType));
#-------------------------------------------------------------------------------
$Columns = array(SPrintF('(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = `%sOrdersOwners`.`OrderID`) AS `ServerID`', $OrderType), 'Login');
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$OrderServer = DB_Select(SPrintF('%sOrdersOwners', $OrderType), $Columns, array('UNIQ', 'ID' => $DependOrderID));
switch (ValueOf($OrderServer)) {
case 'error':
return ERROR | @Trigger_Error('[Server->Select]: ошибка поиска зависимого заказа');
case 'exception':
return new gException('DEPEND_ORDER_NOT_FOUND', 'Не найден заказ к которому необходимо добавить/удалить IP адрес');
case 'array':
#-------------------------------------------------------------------------------
$SysInfo = DB_Select('Servers', '*', array('UNIQ', 'ID' => $OrderServer['ServerID']));
switch (ValueOf($SysInfo)) {
case 'error':
return ERROR | @Trigger_Error('[Server->Select]: не удалось выбрать сервер');
case 'exception':
return new gException('SERVER_NOT_FOUND', 'Указаный сервер не найден');
case 'array':
/* find server info */
#-------------------------------------------------------------------------
# add User Login on server
$SysInfo['UserLogin'] = $OrderServer['Login'];
Debug(SPrintF('[system/classes/ExtraIPServer]: OrderType = %s', $OrderType));
Debug(SPrintF('[system/classes/ExtraIPServer]: found ICS: %s', $SysInfo['Params']['SystemID']));
$this->SystemID = $SysInfo['Params']['SystemID'];
$this->Settings = $SysInfo;
if (Is_Error(System_Load(SPrintF('libs/%s.php', $this->SystemID)))) {
@Trigger_Error('[Server->Select]: не удалось загрузить целевую библиотеку');
}
// + надо загрузить собсно либу для работы с IP адресами
#-------------------------------------------------------------------------------
return TRUE;
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
default:
return ERROR | @Trigger_Error(101);
}
default:
return ERROR | @Trigger_Error(101);
}
}
public function getParams()
{
#-------------------------------------------------------------------------------
#$Server = DB_Select('HostingServers', Array('Address', 'Url', 'Ns1Name', 'Ns2Name', 'MySQL'), Array('UNIQ', 'ID' => $this->params['ServerID']));
$Server = DB_Select('Servers', array('Address', 'Params'), array('UNIQ', 'Where' => SPrintF('(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = %u) = `Servers`.`ID`', $this->params['OrderID'])));
if (!Is_Array($Server)) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
$this->params['Server'] = $Server;
#-------------------------------------------------------------------------------
return $this->params;
#-------------------------------------------------------------------------------
}
function CreateMap($ID, &$ParentNode)
{
#-----------------------------------------------------------------------------
$Group = DB_Select('Groups', '*', array('UNIQ', 'ID' => $ID));
#-----------------------------------------------------------------------------
switch (ValueOf($Group)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
#-------------------------------------------------------------------------
$Node = new Tag('node', array('TEXT' => $Group['Name'], 'STYLE' => 'bubble', 'BACKGROUND_COLOR' => $Group['IsDepartment'] ? '#F07D00' : '#F9E47D'), new Tag('edge', array('STYLE' => 'sharp_bezier', 'COLOR' => '#D5F66C', 'WIDTH' => 5)), new Tag('font', array('BOLD' => 'true', 'NAME' => 'SansSerif', 'SIZE' => 14)), new Tag('icon', array('BUILTIN' => 'none')));
#-------------------------------------------------------------------------
$Childs = DB_Select('Groups', '*', array('Where' => SPrintF('`ParentID` = %u AND `ParentID` != `ID`', $Group['ID'])));
#-------------------------------------------------------------------------
switch (ValueOf($Childs)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
# No more...
break;
case 'array':
#---------------------------------------------------------------------
foreach ($Childs as $Child) {
CreateMap($Child['ID'], $Node);
}
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------
$ParentNode->AddChild($Node);
#-------------------------------------------------------------------------
return TRUE;
default:
return ERROR | @Trigger_Error(101);
}
}
public function Select($ServerID)
{
/******************************************************************************/
$__args_types = array('integer');
#-------------------------------------------------------------------------------
$__args__ = Func_Get_Args();
eval(FUNCTION_INIT);
/******************************************************************************/
Debug('[system/classes/DomainServer.class.php]: function Select');
#-------------------------------------------------------------------------------
$Settings = DB_Select('Servers', '*', array('UNIQ', 'ID' => $ServerID));
#-------------------------------------------------------------------------------
switch (ValueOf($Settings)) {
case 'error':
return ERROR | @Trigger_Error('[DomainServer->Select]: не удалось выбрать регистратора');
case 'exception':
return new gException('REGISTRATOR_NOT_FOUND', 'Указаный регистратор не найден');
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
$this->SystemID = $Settings['Params']['SystemID'];
#-------------------------------------------------------------------------------
$this->Settings = $Settings;
#-------------------------------------------------------------------------------
if (Is_Error(System_Load(SPrintF('libs/%s.php', $this->Settings['Params']['SystemID'])))) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
return TRUE;
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
}
$DomainScheme = Is_Array($DomainScheme) ? $DomainScheme : array();
#-------------------------------------------------------------------
$dDomainScheme = DB_Select('DomainsSchemes', 'ID', array('Where' => SPrintF("`Name` = '%s'", $DomainScheme['DomainZone'])));
#-------------------------------------------------------------------
switch (ValueOf($dDomainScheme)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
#---------------------------------------------------------------
$IDomainScheme = array('GroupID' => 2000000, 'UserID' => 100, 'Name' => $DomainScheme['DomainZone'], 'CostOrder' => $DomainScheme['CostOrder'], 'CostProlong' => $DomainScheme['CostProlong'], 'MinOrderYears' => 1, 'MaxActionYears' => 1, 'DaysToProlong' => 31);
#---------------------------------------------------------------
$Registrator = $DomainScheme['Registrator'];
#---------------------------------------------------------------
$Registrator = Is_Array($Registrator) ? $Registrator : array();
#---------------------------------------------------------------
$dRegistrator = DB_Select('Registrators', 'ID', array('UNIQ', 'Where' => SPrintF("`Name` = '%s'", $Registrator['Name'])));
#---------------------------------------------------------------
switch (ValueOf($dRegistrator)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
#-----------------------------------------------------------
$IRegistrator = array('Name' => $Registrator['Name'], 'TypeID' => $Registrator['TypeID'], 'Address' => $Registrator['Address'], 'Port' => $Registrator['Port'], 'Protocol' => $Registrator['Protocol'], 'Login' => $Registrator['Login'], 'Password' => 'Default');
#-----------------------------------------------------------
$RegistratorID = DB_Insert('Registrators', $IRegistrator);
if (Is_Error($RegistratorID)) {
return ERROR | @Trigger_Error(500);
}
#-----------------------------------------------------------
$IDomainScheme['RegistratorID'] = $RegistratorID;
break;
#-------------------------------------------------------------------------------
/** @author Alex Keda, for www.host-food.ru */
/******************************************************************************/
/******************************************************************************/
$__args_list = array('Task', 'DNSmanagerOrderID');
/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
if (Is_Error(System_Load('classes/DNSmanagerServer.class.php'))) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
$Columns = array('ID', 'UserID', 'Login', '(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = `DNSmanagerOrdersOwners`.`OrderID`) AS `ServerID`', '(SELECT `IsReselling` FROM `DNSmanagerSchemes` WHERE `DNSmanagerSchemes`.`ID` = `DNSmanagerOrdersOwners`.`SchemeID`) as `IsReselling`', '(SELECT `Name` FROM `DNSmanagerSchemes` WHERE `DNSmanagerSchemes`.`ID` = `DNSmanagerOrdersOwners`.`SchemeID`) as `SchemeName`');
$DNSmanagerOrder = DB_Select('DNSmanagerOrdersOwners', $Columns, array('UNIQ', 'ID' => $DNSmanagerOrderID));
#-------------------------------------------------------------------------------
switch (ValueOf($DNSmanagerOrder)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
#-------------------------------------------------------------------------------
$ClassDNSmanagerServer = new DNSmanagerServer();
#-------------------------------------------------------------------------------
$IsSelected = $ClassDNSmanagerServer->Select((int) $DNSmanagerOrder['ServerID']);
#-------------------------------------------------------------------------------
switch (ValueOf($IsSelected)) {
case 'error':
return ERROR | @Trigger_Error(500);
#-------------------------------------------------------------------------------
// перебираем полученных пользователей.
foreach ($Users as $User) {
#-------------------------------------------------------------------------------
# выбираем меньшую из дат, т.к. мог не входить никогда
$EnterDate = $User['EnterDate'] > $User['RegisterDate'] ? $User['EnterDate'] : $User['RegisterDate'];
Debug(SPrintF('[comp/Tasks/GC/WithdrawalOldUsers]: автоматическое списание денег с балланса юзера (%s) не заходившего в биллинг %s дней', $User['Email'], Ceil((Time() - $EnterDate) / (24 * 3600))));
#-------------------------------------------------------------------------------
#if($User['Email'] != '*****@*****.**')
# continue;
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
# выбираем договора юзера с баллансом больше нуля
$Where = array(SPrintF('`UserID` = %u', $User['ID']), '`Balance` > 0');
#-------------------------------------------------------------------------------
$Contract = DB_Select('Contracts', array('ID', 'TypeID', 'Customer', 'Balance'), array('UNIQ', 'Where' => $Where, 'Limits' => array(0, 1)));
#-------------------------------------------------------------------------------
switch (ValueOf($Contract)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return new gException('CONTRACT_NOT_FOUND', 'Договора не найдены');
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
Debug(SPrintF('[comp/Tasks/GC/WithdrawalOldUsers]: юзер (%s), договор #%u, балланс %s', $User['Email'], $Contract['ID'], $Contract['Balance']));
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
default:
return ERROR | @Trigger_Error(101);
}
#---------------------------------------------------------------------------
$MessageID = DB_Insert('EdesksMessages', $IEdeskMessage);
if (Is_Error($MessageID)) {
return ERROR | @Trigger_Error(500);
}
#---------------------------------------------------------------------------
if (isset($IEdeskMessage['FileName'])) {
if (!SaveUploadedFile('EdesksMessages', $MessageID, $Upload['Data'])) {
return new gException('CANNOT_SAVE_UPLOADED_FILE', 'Не удалось сохранить загруженный файл');
}
}
#---------------------------------------------------------------------------
$Users = DB_Select('Users', 'ID', array('Where' => SPrintF('`ID` != %u AND `ID` > 50', $__USER['ID'])));
#---------------------------------------------------------------------------
switch (ValueOf($Users)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
#-----------------------------------------------------------------------
foreach ($Users as $User) {
#---------------------------------------------------------------------
$IsSend = NotificationManager::sendMsg('EdeskCreate', (int) $User['ID'], array('EdeskID' => $EdeskID, 'Theme' => $Theme, 'Message' => $Message));
#---------------------------------------------------------------------
switch (ValueOf($IsSend)) {
case 'error':
return ERROR | @Trigger_Error(500);
$DependService = DB_Select(array('Servers', 'ServersGroups'), array('(SELECT `Code` FROM `Services` WHERE `Services`.`ID` = `ServersGroups`.`ServiceID`) AS `Code`', '(SELECT `NameShort` FROM `Services` WHERE `Services`.`ID` = `ServersGroups`.`ServiceID`)'), array('UNIQ', 'Where' => array('`Servers`.`ServersGroupID` = `ServersGroups`.`ID`', SPrintF('`Servers`.`ID` = %u', $ExtraIPOrder['ServerID']))));
#-------------------------------------------------------------------------------
switch (ValueOf($DependService)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return new gException('DESTINATION_SERVER_NOT_FOUND', 'Сервер размещения не найден');
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
# находим данные для этого заказа Хостинга/ВПС
$DependOrder = DB_Select(SPrintF('%sOrdersOwners', $DependService['Code']), array('ID', 'UserID', 'Login', 'Password', 'Domain', 'SchemeID'), array('UNIQ', 'Where' => SPrintF('`OrderID` = %u', $ExtraIPOrder['DependOrderID'])));
switch (ValueOf($DependOrder)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$ExtraIPServer = new ExtraIPServer();
#-------------------------------------------------------------------------------
$IsSelected = $ExtraIPServer->FindSystem((int) $ExtraIPOrderID, (string) $DependService['Code'], (int) $DependOrder['ID']);
/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
$Args = Args();
#-------------------------------------------------------------------------------
$TableID = (string) @$Args['TableID'];
$RowID = (int) @$Args['RowID'];
$UserNotice = (string) @$Args['UserNotice'];
#-------------------------------------------------------------------------------
if (Is_Error(System_Load('modules/Authorisation.mod'))) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Notice = DB_Select(SPrintF('%sOwners', $TableID), array('ID', 'UserNotice', 'UserID'), array('UNIQ', 'ID' => $RowID));
#-------------------------------------------------------------------------------
switch (ValueOf($Notice)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
#-------------------------------------------------------------------------------
if ($GLOBALS['__USER']['ID'] != $Notice['UserID']) {
if (!$GLOBALS['__USER']['IsAdmin']) {
return ERROR | @Trigger_Error(700);
}
}
#-------------------------------------------------------------------------------
break;
/******************************************************************************/
# Ищем максимальный UserID
$MaxUserID = DB_Select('Users', 'MAX(`ID`) AS `ID`', array('UNIQ'));
switch (ValueOf($MaxUserID)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
# перебираем все идентификаторы котоыре > 300 и < 2001
$OldUserIDs = DB_Select('Users', '`ID`', array('Where' => SPrintF('`ID` > 300 AND `ID` < 2001')));
switch (ValueOf($OldUserIDs)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return TRUE;
case 'array':
break;
default:
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
if ($MaxUserID['ID'] < 2001) {
$NewUserID = 2001;
} else {
$NewUserID = $MaxUserID['ID'];
$__USER = $GLOBALS['__USER'];
#-------------------------------------------------------------------------------
$Path = Tree_Path('Groups', (int) $__USER['GroupID'], 'ID');
#-------------------------------------------------------------------------------
switch (ValueOf($Path)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
#---------------------------------------------------------------------------
$Result = array();
#---------------------------------------------------------------------------
$Where = array(SPrintF("((`GroupID` IN (%s) OR `UserID` = %u) AND `IsActive` = 'yes') OR ((SELECT COUNT(*) FROM `OrdersOwners` WHERE `OrdersOwners`.`ServiceID` = `Services`.`ID` AND `UserID` = %u) > 0)", Implode(',', $Path), $__USER['ID'], $__USER['ID']), "`IsHidden` != 'yes'");
#---------------------------------------------------------------------------
$Services = DB_Select('Services', array('ID', 'Code', 'Item', 'ServicesGroupID', 'IsActive', '(SELECT `Name` FROM `ServicesGroups` WHERE `ServicesGroups`.`ID` = `Services`.`ServicesGroupID`) as `ServicesGroupName`', '(SELECT `SortID` FROM `ServicesGroups` WHERE `ServicesGroups`.`ID` = `Services`.`ServicesGroupID`) as `ServicesSortID`'), array('SortOn' => array('ServicesSortID', 'SortID'), 'Where' => $Where));
#---------------------------------------------------------------------------
switch (ValueOf($Services)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return FALSE;
case 'array':
#-----------------------------------------------------------------------
$ServicesGroupID = UniqID();
#-----------------------------------------------------------------------
foreach ($Services as $Service) {
#---------------------------------------------------------------------
if ($Service['ServicesGroupID'] != $ServicesGroupID) {
#-------------------------------------------------------------------
$ServicesGroupID = $Service['ServicesGroupID'];
#------------------------------------------------------------------------------
$ExecutePeriod = Comp_Load('Formats/Task/ExecuteTime', array('ExecutePeriod' => $Settings['ExecutePeriod'], 'DefaultTime' => 120));
if (Is_Error($ExecutePeriod)) {
return ERROR | @Trigger_Error(500);
}
#------------------------------------------------------------------------------
$ExecuteTime = Comp_Load('Formats/Task/ExecuteTime', array('ExecuteTime' => $Settings['ExecuteTime'], 'DefaultTime' => MkTime(5, 0, 0, Date('n'), Date('j') + 1, Date('Y'))));
if (Is_Error($ExecuteTime)) {
return ERROR | @Trigger_Error(500);
}
#------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Where = array("`StatusID` = 'Active' OR `StatusID` = 'ForTransfer' OR `StatusID` = 'OnTransfer'", SPrintF('UNIX_TIMESTAMP() - %u * 86400 > `UpdateDate`', $Settings['WhoIsUpdatePeriod']), SPrintF('UNIX_TIMESTAMP() - %u * 86400 > `StatusDate`', $Settings['WhoIsBeginUpdate']));
#-------------------------------------------------------------------------------
$Columns = array('ID', 'DomainName', '(SELECT `Name` FROM `DomainSchemes` WHERE `DomainSchemes`.`ID` = `SchemeID`) AS `DomainZone`', '(SELECT `Params` FROM `Servers` WHERE `Servers`.`ID` = `ServerID`) AS `Params`');
$DomainOrders = DB_Select('DomainOrdersOwners', $Columns, array('Where' => $Where, 'Limits' => array(0, $Settings['Limit']), 'SortOn' => array('UpdateDate', 'DomainName')));
#-------------------------------------------------------------------------------
switch (ValueOf($DomainOrders)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
# No more...
break;
case 'array':
#-------------------------------------------------------------------------------
$GLOBALS['TaskReturnInfo'] = array();
#-------------------------------------------------------------------------------
foreach ($DomainOrders as $DomainOrder) {
#-------------------------------------------------------------------------------
$Comp = Comp_Load('www/Administrator/API/DomainOrderWhoIsUpdate', array('DomainOrderID' => $DomainOrder['ID']));
if (Is_Error($Comp)) {
#-------------------------------------------------------------------------------
/** @author Alex Keda, for www.host-food.ru */
/******************************************************************************/
/******************************************************************************/
$__args_list = array('ServiceOrder');
/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
#Debug(SPrintF('[comp/Triggers/Statuses/Orders/Waiting]: ServiceOrder = %s',print_r($ServiceOrder,true)));
#-------------------------------------------------------------------------------
$UserID = $GLOBALS['__USER']['ID'];
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Service = DB_Select('Services', array('ID', 'Code', 'Name', 'NameShort'), array('UNIQ', 'ID' => $ServiceOrder['ServiceID']));
switch (ValueOf($Service)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Params = array('SchemeID' => 0, 'OrderID' => $ServiceOrder['ID'], 'MaxOrders' => 0, 'MinOrdersPeriod' => 0, 'ServiceID' => $Service['ID'], 'ServiceName' => $Service['Name'], 'SchemeName' => $Service['NameShort']);
#-------------------------------------------------------------------------------
$Comp = Comp_Load('Services/Orders/OrdersHistory', $Params);
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return new gException('SERVICE_NOT_FOUND', 'Указанный сервис не найден');
case 'array':
# No more...
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
if ($Service['Code'] != "Default") {
$Columns = array('*', SPrintF('(SELECT `IsAutoProlong` FROM `Orders` WHERE `%sOrdersOwners`.`OrderID`=`Orders`.`ID`) AS `IsAutoProlong`', $Service['Code']));
#-------------------------------------------------------------------------------
$Order = DB_Select(SPrintF('%sOrdersOwners', $Service['Code']), $Columns, array('UNIQ', 'ID' => $ServiceOrderID));
#-------------------------------------------------------------------------------
switch (ValueOf($Order)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'false':
return ERROR | @Trigger_Error(700);
case 'true':
#-----------------------------------------------------------------------
$StatusID = $VPSOrder['StatusID'];
#-----------------------------------------------------------------------
if (!In_Array($StatusID, array('Waiting', 'Active', 'Suspended'))) {
return new gException('VPS_ORDER_CAN_NOT_PAY', 'Заказ не может быть оплачен');
}
#-----------------------------------------------------------------------
$UserID = $VPSOrder['UserID'];
#-----------------------------------------------------------------------
$VPSScheme = DB_Select('VPSSchemes', array('ID', 'Name', 'CostDay', 'CostInstall', 'IsActive', 'IsProlong', 'MinDaysPay', 'MinDaysProlong', 'MaxDaysPay'), array('UNIQ', 'ID' => $VPSOrder['SchemeID']));
#-----------------------------------------------------------------------
switch (ValueOf($VPSScheme)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
#-------------------------------------------------------------------
if ($VPSOrder['IsPayed']) {
#-----------------------------------------------------------------
if (!$VPSScheme['IsProlong']) {
return new gException('SCHEME_NOT_ALLOW_PROLONG', 'Тарифный план заказа виртуального сервера не позволяет продление');
}
} else {
#-----------------------------------------------------------------
}
#-------------------------------------------------------------------------------
$Form->AddChild($Comp);
#-------------------------------------------------------------------------------
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Table = array();
#-------------------------------------------------------------------------------
if (isset($_COOKIE['OwnerID'])) {
#-------------------------------------------------------------------------------
$OwnerID = $_COOKIE['OwnerID'];
#-------------------------------------------------------------------------------
if (isset($_COOKIE['IsManaged'])) {
#-------------------------------------------------------------------------------
$Owner = DB_Select('Users', array('Email', 'Name'), array('UNIQ', 'ID' => $OwnerID));
#-------------------------------------------------------------------------------
switch (ValueOf($Owner)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
# No more...
break;
case 'array':
#-------------------------------------------------------------------------------
$Table[] = array('Партнер', SPrintF('%s (%s)', $Owner['Name'], $Owner['Email']));
#-------------------------------------------------------------------------------
break;
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
default:
#-------------------------------------------------------------------------------
/** @author Alex Keda, for www.host-food.ru */
/******************************************************************************/
/******************************************************************************/
$__args_list = array('IsSearch');
/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
$Periods = array(7 => 'Неделю назад', 30 => 'Месяц назад', 182 => 'Полгода назад', 365 => 'Один год назад', 730 => 'Два года назад', 1095 => 'Три года назад');
#-------------------------------------------------------------------------------
$Filters = array('Входившие не более чем');
#-------------------------------------------------------------------------------
foreach (Array_Keys($Periods) as $Key) {
#-------------------------------------------------------------------------------
$Users = DB_Select('Users', array('ID'), array('Where' => SPrintF('`EnterDate` > %u', Time() - $Key * 24 * 60 * 60)));
#-------------------------------------------------------------------------------
switch (ValueOf($Users)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
continue 2;
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
$Filter = array('Name' => $Periods[$Key], 'UsersIDs' => array());
#-------------------------------------------------------------------------------
if ($IsSearch) {
<?php
#-------------------------------------------------------------------------------
/** @author Sergey Sedov (for www.host-food.ru) */
/******************************************************************************/
/******************************************************************************/
$__args_list = array('Params');
/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
$Where = SPrintF("`StatusID` = 'Waiting' AND `StatusDate` < UNIX_TIMESTAMP( ) - %d *86400", $Params['Invoices']['DaysBeforeDeleted']);
#-------------------------------------------------------------------------------
$Invoices = DB_Select('InvoicesOwners', array('ID', 'UserID'), array('SortOn' => 'CreateDate', 'IsDesc' => TRUE, 'Where' => $Where));
switch (ValueOf($Invoices)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return TRUE;
case 'array':
#---------------------------------------------------------------------------
foreach ($Invoices as $Invoice) {
Debug(SPrintF("[Tasks/GC/SetDeletedWaitingInvoice]: Отмена счёта #%d.", $Invoice['ID']));
#----------------------------------TRANSACTION----------------------------
if (Is_Error(DB_Transaction($TransactionID = UniqID('comp/Tasks/GC/SetDeletedWaitingInvoice')))) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------
$Comp = Comp_Load('www/API/StatusSet', array('ModeID' => 'Invoices', 'StatusID' => 'Rejected', 'RowsIDs' => $Invoice['ID'], 'Comment' => SPrintF('Автоматическая отмена счёта, неоплачен более %d дней', $Params['Invoices']['DaysBeforeDeleted'])));
#-------------------------------------------------------------------------
switch (ValueOf($Comp)) {
$DOM->AddHTML('Agreement', $Adding);
#-------------------------------------------------------
$Comp = Comp_Load('Clauses/Load', SPrintF('Contracts/Types/%s/Footer/%s', $Contract['TypeID'], $Executor['TemplateID']));
if (Is_Error($Comp)) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------
$DOM->AddChild('Footer', $Comp['DOM']);
#-------------------------------------------------------
$Childs = $DOM->Links['WorkComplite']->Childs;
#-------------------------------------------------------
for ($i = 0; $i < Count($WorksComplite); $i++) {
#-----------------------------------------------------
$WorkComplite = $WorksComplite[$i];
#-----------------------------------------------------
$Service = DB_Select('Services', '*', array('UNIQ', 'ID' => $WorkComplite['ServiceID']));
#-----------------------------------------------------
switch (ValueOf($Service)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
#-------------------------------------------------
$WorkComplite['Service'] = $Service;
#-------------------------------------------------
$WorkCompliteSumm = $WorkComplite['Amount'] * $WorkComplite['Cost'] * (1 - $WorkComplite['Discont']);
#-------------------------------------------------
$Comp = Comp_Load('Formats/Currency', $WorkCompliteSumm);
if (Is_Error($Comp)) {
return ERROR | @Trigger_Error(500);
$Comment = 'Отменён (выполнена транзакция разблокировки средств или выполнена операция по возврату платежа после списания средств)';
#-------------------------------------------------------------------------------
#----------------------------------TRANSACTION----------------------------------
if (Is_Error(DB_Transaction($TransactionID = UniqID('Merchant/Uniteller')))) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
# ставим счёт как неоплаченный
# плохая идея. появляется кнопка про оплату, а оплатить нельзя - юнителлер не даёт
#$IsUpdate = DB_Update('Invoices',Array('IsPosted'=>FALSE),Array('ID'=>$Invoice['ID']));
#if(Is_Error($IsUpdate))
# return ERROR | @Trigger_Error(500);
#-------------------------------------------------------------------------------
# вычитаем сумму счёта из договора, на который счёт.
$Contract = DB_Select('ContractsOwners', 'Balance', array('UNIQ', 'ID' => $Invoice['ContractID']));
switch (ValueOf($Contract)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
$After = $Contract['Balance'] - $Invoice['Summ'];
#-------------------------------------------------------------------------------
$IsUpdate = DB_Update('Contracts', array('Balance' => $After), array('ID' => $Invoice['ContractID']));
if (Is_Error($IsUpdate)) {
# No more...
# No more...
case 'true':
#-------------------------------------------------------------------------------
# событие, чтоле прибить...
#-------------------------------------------------------------------------------
break;
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
} else {
#-------------------------------------------------------------------------------
$Clause = DB_Select('Clauses', '*', array('UNIQ', 'Where' => "`Partition` = 'CreateTicket/LOCK_OVERLIMITS'"));
#-------------------------------------------------------------------------------
switch (ValueOf($Clause)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
Debug(SPrintF('[comp/Tasks/HostingCPUUsage]: Статья для создания тикета не обнаружена: CreateTicket/LOCK_OVERLIMITS'));
break;
case 'array':
#-------------------------------------------------------------------------------
# готовим тикет
$ITicket = array('Theme' => $Clause['Title'], 'PriorityID' => 'Low', 'Flags' => 'CloseOnSee', 'TargetGroupID' => 3100000, 'TargetUserID' => 100, 'UserID' => $HostingOrder['UserID'], 'Message' => TemplateReplace(Strip_Tags($Clause['Text']), $Params, FALSE));
#-------------------------------------------------------------------------------
$IsAdd = Comp_Load('www/API/TicketEdit', $ITicket);
if (Is_Error($IsAdd)) {
return ERROR | @Trigger_Error(500);
if (Is_Error($Comp)) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
$Table[] = array(new Tag('NOBODY', new Tag('SPAN', 'Стоимость месяца'), new Tag('BR'), new Tag('SPAN', array('class' => 'Comment'), 'Используется для отображения')), $Comp);
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Comp = Comp_Load('Form/Summ', array('name' => 'CostInstall', 'value' => SPrintF('%01.2f', $DSScheme['CostInstall'])));
if (Is_Error($Comp)) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
$Table[] = array('Стоимость установки/подключения', $Comp);
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Servers = DB_Select('Servers', array('ID', 'Address'), array('Where' => '(SELECT `ServiceID` FROM `ServersGroups` WHERE `ServersGroups`.`ID` = `Servers`.`ServersGroupID`) = 40000', 'SortOn' => 'Address'));
#-------------------------------------------------------------------------------
switch (ValueOf($Servers)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return new gException('SERVERS_NOT_FOUND', 'Группа управляющих серверов не найдена. Добавьте группу серверов для сервиса "Выделенный сервер" и хотя бы один управляющий сервер в неё');
case 'array':
# No more...
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
$Options = array();
#-------------------------------------------------------------------------------
<?php
#-------------------------------------------------------------------------------
/** @author Великодный В.В. (Joonte Ltd.) */
/******************************************************************************/
/******************************************************************************/
$__args_list = array('Item');
/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
$DSOrder = DB_Select('DSOrdersOwners', array('ID', 'IP', 'UserID'), array('UNIQ', 'Where' => SPrintF('`OrderID` = %u', $Item['OrderID'])));
#-------------------------------------------------------------------------------
switch (ValueOf($DSOrder)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return new gException('DS_ORDER_NOT_FOUND', 'Заказ на аренду сервера не найден');
case 'array':
#-------------------------------------------------------------------------------
$Comp = Comp_Load('www/API/DSOrderPay', array('DSOrderID' => $DSOrder['ID'], 'DaysPay' => $Item['Amount']));
if (Is_Error($Comp)) {
return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
switch (ValueOf($Comp)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return new gException('DS_ORDER_PAY_ERROR', 'Ошибка оплаты заказа выделенного сервера', $Comp);
case 'array':
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Service = DB_Select('Services', array('ID', 'Code', 'Name'), array('UNIQ', 'ID' => $DNSmanagerOrder['ServiceID']));
switch (ValueOf($Service)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Scheme = DB_Select(SPrintF('%sSchemes', $Service['Code']), array('*'), array('UNIQ', 'ID' => $DNSmanagerOrder['SchemeID']));
switch (ValueOf($Scheme)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Params = array('SchemeID' => $DNSmanagerOrder['SchemeID'], 'OrderID' => $DNSmanagerOrder['OrderID'], 'MaxOrders' => $Scheme['MaxOrders'], 'MinOrdersPeriod' => $Scheme['MinOrdersPeriod'], 'ServiceID' => $Service['ID'], 'ServiceName' => $Service['Name'], 'SchemeName' => $Scheme['Name']);
#-------------------------------------------------------------------------------
$Comp = Comp_Load('Services/Orders/OrdersHistory', $Params);
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
foreach ($OrdersConsider as $OrderConsider) {
#-------------------------------------------------------------------------------
if ($OrderConsider['SumDaysRemainded'] <= IntVal($Settings['ResetDaysTo'])) {
continue;
}
#-------------------------------------------------------------------------------
$OrderID = $OrderConsider['OrderID'];
#Debug(SPrintF('[comp/Tasks/GC/ResetOrdersDays]: OrderID = %s; DaysRemainded = %s',$OrderID,$OrderConsider['SumDaysRemainded']));
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
# Заказы этого клиента, только те для которых есть учёт в таблице OrdersConsider
$Where = array(SPrintF('`UserID` = (SELECT `UserID` FROM `OrdersOwners` WHERE `ID` = %u)', $OrderID), '(SELECT `OrderID` FROM `OrdersConsider` WHERE `OrdersConsider`.`OrderID` = `OrdersOwners`.`ID` LIMIT 1) IS NOT NULL');
#-------------------------------------------------------------------------------
$Orders = DB_Select('OrdersOwners', array('ID', 'UserID', 'StatusID'), array('Where' => $Where));
#-------------------------------------------------------------------------------
switch (ValueOf($Orders)) {
case 'error':
return ERROR | @Trigger_Error(500);
case 'exception':
return ERROR | @Trigger_Error(400);
case 'array':
break;
default:
return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Order = Current($Orders);
#-------------------------------------------------------------------------------
