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); #-------------------------------------------------------------------------------