Файл: _rootadmin/_domains.inc.php
Строк: 436
<?
if ($param == "uid" and $search) { print menu_admin_client($search); }
if ($param and $search) {$linkAddon = "param=$param&search=$search";}
if ($sub == 'deletenotinwhois') {
$domains = @mysql_query("select * from orders_domains where status='1' or status='2'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
?>
<form method=post>
<input type=hidden name=do value=<? print $do?>>
<input type=hidden name=sub value=delete>
<input type=hidden name=mass value=1>
<input type=hidden name=reason value="<? print $_lang[DomainDeleteReasonRegistratorCancel2]?>">
<table cellpadding=3>
<tr><td colspan=4 align=center bgcolor=<? print $font_head?>><B>Домены отсутствующие в WHOIS</b></td></tr>
<tr bgcolor=<? print $font_head?> align=center>
<td><input type=checkbox onclick='setChecked(this,1)'></td>
<td>Домен</td>
<td>Статус</td>
<td>Ошибка WHOIS</td>
</tr>
<?
while ($domain = @mysql_fetch_object($domains)) {
$d = new domain($domain->domain);
if ($d->is_available()) {
$domainFree = 1;
$err = $d->last_error;
} else {
$domainFree = 0;
}
$statusDomain = "<img src=./_rootimages/obrabotan_".$domain->status."_small.gif border=0 alt='".$_status[$domain->status]."'>";
print "
<tr bgcolor=$font_row height=30>
<td align=center width=20><input type=checkbox name=elementsToCheck2[] value=$domain->id>
<td>$domain->domain</td>
<td align=center>$statusDomain</font></td>
<td>$err</td>
</tr>
";
}
?>
<tr><td align=center colspan=4 bgcolor=<? print $font_row?>><input type=submit value=Удалить></td></tr>
</table>
</form><BR>
<?
}
if ($sub == 'delete') {
checkAdminAccess('domainsDelete',1);
if ($reason) {
if (!$mass) { $elementsToCheck = array(); $elementsToCheck[] = $id; }
if (count($elementsToCheck2) > 0) { $elementsToCheck = $elementsToCheck2; }
if (count($elementsToCheck) > 0) {
while (list($k,$v) = @each($elementsToCheck)) {
$domain = GetDomainById($v);
if ($domain->id) {
$user = GetUserById($domain->uid);
$registrator = GetRegistratorById($domain->autoregby);
if (($domain->status == "1" or $domain->status == "2") and ($registrator->type == "hostmasterepp" or $registrator->type == "nicdpua")) {
if (deleteDomain($domain->domain)) {
print "Доменное имя <b>$domain->domain</b> автоматически удалено у регистратора.<BR>";
} else {
print "Доменное имя <b>$domain->domain</b> не удалено у регистратора ($GLOBALerror).<BR>";
}
}
if ($domain->dnsServerId) {
if (deleteDomainZoneAtServer($domain->id)) {
print "Доменная зона для <b>$domain->domain</b> автоматически удалена на сервере.<BR>";
} else {
print "Доменная зона для <b>$domain->domain</b> не удалена на сервере ($GLOBALerror).<BR>";
}
}
@mysql_query("delete from orders_domains where id='$domain->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
@mysql_query("delete from orders_domainscert where domain_id='$domain->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
$bs = @mysql_query("select * from bills where domain_id='$domain->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
while ($b = @mysql_fetch_object($bs)) {
if (!$b->status) {
@mysql_query("delete from bills where id='$b->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
} else {
@mysql_query("update bills set archived=1 where id='$b->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
}
}
writeAdminLog("Удален домен ID # $domain->id, $domain->domain ($reason)");
$tpl=GetTpl('email_touser_domain_delete', $user->lang);
$subject=$tpl[subject]; $template=$tpl[template];
if ($subject and $template) {
$company_name=GetSetting('company_name');
$company_url=GetSetting('company_url');
$manager_email=GetSetting("manager_email");
$support_url=GetSetting("support_url");
$subject = str_replace('{domain}',$domain->domain,$subject);
$template = str_replace('{company_name}',$company_name,$template);
$template = str_replace('{company_url}',$company_url,$template);
$template = str_replace('{support_url}',$support_url,$template);
$template = str_replace('{domain}',$domain->domain,$template);
$template = str_replace('{reason}',$reason,$template);
WriteMailLog($subject,$template,$user->id);
sendmail($user->email,$company_name,$manager_email,$subject,$template,'','',$tpl[type]);
sendmail($user->email2,$company_name,$manager_email,$subject,$template,'','',$tpl[type]);
}
print "Домен <b>ID # $domain->id, $domain->domain</b> и все счета, относящиеся к нему, успешно удалены.<BR>";
}
}
print "<BR>";
}
}
else {
print "<form method=post>";
print "<input type=hidden name=do value='$do'>";
print "<input type=hidden name=sub value='$sub'>";
print "<input type=hidden name=mass value='$mass'>";
if (!$mass) {
print "<input type=hidden name=id value='$id'>";
} else {
while (list($k,$v) = @each($elementsToCheck)) {
print "<input type=hidden name=elementsToCheck[] value='$v'>";
}
}
print "<B>Причина удаления доменного имени:</b> <input type=text name=reason size=20> ";
print "<input type=submit value=Удалить>";
print "</form><BR><BR>";
}
}
checkAdminAccess('domainsRead',1);
$myShow = $_SESSION["domainShow"]; if (!$myShow) { $myShow="all"; }
if ($show and $show != $myShow) { $myShow = $show; $_SESSION["domainShow"] = $myShow; }
$mySort = $_SESSION["domainSort"];
if ($myShow == "all") {
$where = "";
} else if ($myShow == "vobrab") {
$where = "where status=3";
} else if ($myShow == "obrab") {
$where = "where status=1";
} else if ($myShow == "noobrab") {
$where = "where status=0";
} else if ($myShow == "suspended") {
$where = "where status=2";
} else if ($myShow == "toexpire") {
$where = "where TO_DAYS(todate)-TO_DAYS(NOW())>=0 and TO_DAYS(todate)-TO_DAYS(NOW())<=30";
} else if ($myShow == "expired") {
$where = "where TO_DAYS(todate)-TO_DAYS(NOW())<0";
}
if ($param == 'uid') { $operat = "$param = '$search'"; } else { $operat = "$param LIKE '%$search%'"; }
if ($search) {
if ($where) { $where .= " and $operat"; }
else { $where = "where $operat"; }
}
if (!$mySort) { $mySort = "id"; } # установка поля для сортировки по умолчанию, если не указано
if ($sort and $sort != $mySort) { $mySort = $sort; } # установка нового типа сортировки, если клиент выбрал другой
$_SESSION["domainSort"] = $mySort;
if (!$_SESSION["domainDesc"]) { $_SESSION["domainDesc"] = "desc"; } # получение направления сортировки или установка по умолчанию
if ($desc and $desc != $_SESSION["domainDesc"]) { $_SESSION["domainDesc"] = $desc; } # установка нового направления сортировки, если клиент выбрал другое
if (!$desc and $_SESSION["domainDesc"]) { $desc = $_SESSION["domainDesc"]; }
if ($desc == "desc") { $desc = "asc"; } else { $desc = "desc"; }
$myDesc = $_SESSION["domainDesc"];
getfont();
?>
<table width=99%>
<tr>
<Td valign=top>
<table width=270>
<tr><td align=center bgcolor=<? print $font_head?>><B>Фильтр</b></td></tr>
<tr><td bgcolor=<? print $font_row?> align=center>
<form method=post>
<select name=show>
<option value=all <? if ($myShow == 'all') {print "selected";} ?>>Все домены</option>
<option value=vobrab <? if ($myShow == 'vobrab') {print "selected";} ?>>В обработке</option>
<option value=obrab <? if ($myShow == 'obrab') {print "selected";} ?>>Обработанные</option>
<option value=noobrab <? if ($myShow == 'noobrab') {print "selected";} ?>>Не обработанные</option>
<option value=suspended <? if ($myShow == 'suspended') {print "selected";} ?>>Приостановленные</option>
<option value=toexpire <? if ($myShow == 'toexpire') {print "selected";} ?>>Заканчивающиеся</option>
<option value=expired <? if ($myShow == 'expired') {print "selected";} ?>>Закончившиеся</option>
</select>
<input type=submit value=Показать>
</form>
</td></tr>
</table>
</td>
<td width=50> </td>
<Td valign=top>
<table width=340>
<tr><td align=center bgcolor=<? print $font_head?>><B>Поиск</b></td></tr>
<tr><td bgcolor=<? print $font_row?>><form method=post><input type=hidden name=show value=all><select name=param><option value=domain selected>Домен:</option><option value=remark>Комментарий:</option></select> <input type=text name=search size=20> <input type=submit value=Найти></form></td></tr>
</table>
</td>
<td width=100%></td>
</tr>
</table><BR>
<?
$r=@mysql_query("select *,TO_DAYS(todate)-TO_DAYS(NOW()) as leftdays from orders_domains $where order by $mySort $myDesc") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
$rows = mysql_num_rows($r);
list($start, $perPage, $txt) = MakePages($page, $rows, $linkAddon);
?>
<form method=post>
<input type=hidden name=do value=<? print $do?>>
<input type=hidden name=sub value=delete>
<input type=hidden name=mass value=1>
<table cellpadding=3 width=99%>
<tr><td colspan=10 align=right><? print $txt?></td></tr>
<tr><td colspan=10 align=center bgcolor=<? print $font_head?>><B>Домены</b></td></tr>
<tr bgcolor=<? print $font_head?> align=center>
<td><input type=checkbox onclick='setChecked(this,0)'></td>
<td></td>
<td><a href=?do=<? print $do?>&sort=id&desc=<? print $desc?>>ID <? if ($mySort == "id") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."'>"; } ?></a></td>
<td><a href=?do=<? print $do?>&sort=orderdate&desc=<? print $desc?>>Дата <? if ($mySort == "orderdate") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."'>"; } ?></a></td>
<td align=center>Логин</td>
<td><a href=?do=<? print $do?>&sort=domain&desc=<? print $desc?>>Домен <? if ($mySort == "domain") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."'>"; } ?></a></td>
<td><a href=?do=<? print $do?>&sort=todate&desc=<? print $desc?>><img src=./_rootimages/domain.gif border=0 alt='Домен'> Конец <? if ($mySort == "todate") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."'>"; } ?></a></td>
<td><a href=?do=<? print $do?>&sort=status&desc=<? print $desc?>><img src=./_rootimages/domain.gif border=0 alt='Домен'> Статус <? if ($mySort == "status") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."'>"; } ?></a></td>
<td></td>
</tr>
<?
$r=@mysql_query("select *,TO_DAYS(todate)-TO_DAYS(NOW()) as leftdays from orders_domains $where order by $mySort $myDesc LIMIT $start,$perPage") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
$cnt=0;
getfont();
while ($rr = @mysql_fetch_object($r)) {
getfont();
$u=mysql_query("select * from users where id = '$rr->uid'");
$u=mysql_fetch_object($u);
$b=mysql_query("select * from bills where archived=0 and domain_id = '$rr->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
$bills=mysql_num_rows($b);
$b=mysql_fetch_object($b);
$cert=mysql_query("select * from orders_domainscert where domain_id = '$rr->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
$cert=mysql_num_rows($cert);
if ($cert) { $cert = " [<a href=?do=domainscerts&show=all¶m=d.domain&search=$rr->domain>сертификат</a>]"; } else { $cert = "";}
if ($rr->leftdays == "") { $rr->leftdays = 0; }
if ($rr->leftdays <= 30 and $rr->startdate != "0000-00-00") { $rr->leftdays = "<font color=red>".$rr->leftdays."</font>"; }
$statusDomain = "<img src=./_rootimages/obrabotan_".$rr->status."_small.gif border=0 alt='".$_status[$rr->status]."'>";
$toDateDomain = mydate($rr->todate);
$leftDaysDomain = "<label alt='осталось дней'>[$rr->leftdays]</label>";
if ($rr->startdate != "0000-00-00") { $toDateDomainTxt = "$toDateDomain $leftDaysDomain"; } else { $toDateDomainTxt = "-";}
if ($rr->host_id) { $edit_link = "host_id=$rr->host_id"; }
else { $edit_link = "domain_id=$rr->id"; }
if ($rr->transfer) {
$newreg = $_newregmin[3];
} else {
$newreg = $_newregmin[1];
}
$remarkTxt = "";
if ($rr->comment) { $remarkTxt .= "<B>Комментарий клиента:</b> $rr->comment<BR>"; }
if ($rr->remark) { $remarkTxt .= "<B>Заметки для админа:</b> $rr->remark<BR>"; }
if ($rr->remarkUser) { $remarkTxt .= "<B>Заметки для клиента:</b> $rr->remarkUser<BR>"; }
if ($remarkTxt) { $remarkTxt = preg_replace("/rn/ui","<BR>",$remarkTxt); $remarkTxt = " <img src=./_rootimages/question.gif alt="$remarkTxt">"; }
print "
<tr bgcolor=$font_row height=30>
<td align=center width=20><input type=checkbox name=elementsToCheck[] value=$rr->id>
<td align=center width=20>
<a href=?do=$do&sub=delete&id=$rr->id onclick="javascript: return confirm('Будет удален домен, а так же все счета, относящиесу к нему. Вы уверены, что хотите удалить домен?');"><img src=./_rootimages/del.gif border=0 alt='Удалить домен'></a>
</td>
<td align=center>$rr->id</td>
<td align=center>".mydate($rr->orderdate)."</td>
<td align=center><a href=?do=fullinfo&id=$u->id>$u->login</a></td>
<td><B>$rr->domain</b>$remarkTxt<BR>[$newreg]$cert</td>
<td align=center>$toDateDomainTxt</td>
<td align=center>$statusDomain</font></td>
<td align=center width=50>
<a href=?do=editorder&$edit_link><img src=./_rootimages/edit.gif border=0 alt='Редактировать заказ'></a>
<A href=?do=bills¶m=domain_id&search=$rr->id><img src=./_rootimages/bills.gif border=0 alt='Счета: $bills'></a>
</td>
</tr>
";
$cnt++;
}
?>
<tr bgcolor=<? print $font_head?>><Td colspan=10>Всего доменов: <? print $rows?>, доменов на странице: <? print $cnt?></td></tr>
<tr><td colspan=10 align=right><? print $txt?></td></tr>
</table>
Отмеченные домены: <input type=submit value=Удалить>
</form>
<form method=post>
<input type=hidden name=do value=<? print $do?>>
<input type=hidden name=sub value=deletenotinwhois>
Удалить обработанные домены, отсутствующие в WHOIS: <input type=submit value=Удалить>
</form>
<?
?>