Файл: billing/_rootadmin/_orders.inc.php
Строк: 243
<?
checkAdminAccess('ordersRead',1);
if ($param == "uid" and $search) { print menu_admin_client($search); }
if ($param and $search) {$linkAddon = "param=$param&search=$search";}
if ($sub == 'delete' and $id) {
checkAdminAccess('ordersDelete',1);
$order = GetOrderById($id);
if ($order->serverlogin) {
$tarif = GetTarifById($order->tarif);
if ($tarif->autodelete) {
if (deleteUser($id)) {
print "Аккаунт <B>$order->serverlogin</b> автоматически удален на сервере.<BR>";
} else {
print "Аккаунт <B>$order->serverlogin</b> не удален на сервере ($GLOBALerror).<BR>";
}
} else {
print "Аккаунт <b>$order->serverlogin</b> не удалён на сервере (эта возможность отключена для тарифного плана).<BR>";
}
} else {
print "Аккаунт для заказа <B>ID #$order->id ($order->domain)</b> не удалён на сервере (не указан логин на сервере или не выбран сервер для данного заказа).<BR>";
}
if ($order->domain_reg == "1") {
$dm = GetDomainByDomain($order->domain);
if ($dm->status) {
@mysql_query("update orders_domains set host_id='0' where id='$dm->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
@mysql_query("update bills set host_id='0', host_srok='0', money_host='0', money_addons='0' where host_id='$order->id' and domain_id='$dm->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
} else {
@mysql_query("delete from orders_domains where host_id='$id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
}
} else {
@mysql_query("delete from orders_domains where host_id='$id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
}
@mysql_query("delete from orders where id='$id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
@mysql_query("update servers_ips set order_id='0',isMain='0' where order_id='$id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
@mysql_query("delete from bills where host_id='$id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
writeAdminLog("Удален заказ ID # $id, $order->domain");
print "Заказ и все счета, относящиеся к нему, успешно удалены.<BR><BR>";
}
$myShow = $_SESSION["orderShow"]; if (!$myShow) { $myShow="all"; }
if ($show and $show != $myShow) { $myShow = $show; $_SESSION["orderShow"] = $myShow; }
$mySort = $_SESSION["orderSort"];
$myShowVid = $_SESSION["orderShowVid"];
if ($showVid and $showVid != $myShowVid) { $myShowVid = $showVid; $_SESSION["orderShowVid"] = $myShowVid; }
if ($myShow == "all") {
$where = "where 1";
} else if ($myShow == "obrab") {
$where = "where o.status=1";
} else if ($myShow == "noobrab") {
$where = "where o.status=0";
} else if ($myShow == "suspended") {
$where = "where o.status=2";
} else if ($myShow == "toexpire") {
$where = "where TO_DAYS(o.todate)-TO_DAYS(NOW())>=0 and TO_DAYS(o.todate)-TO_DAYS(NOW())<=10";
} else if ($myShow == "expired") {
$where = "where TO_DAYS(o.todate)-TO_DAYS(NOW())<0";
}
if ($myShowVid and $myShowVid != "all") { $where .= " and t.id=o.tarif and t.vid='$myShowVid'"; }
else {$where .= " and t.id=o.tarif";}
if ($param == 'uid') { $operat = "o.$param = '$search'"; } else { $operat = "o.$param LIKE '%$search%'"; }
if ($search) { $where .= " and $operat"; }
if (!$mySort) { $mySort = "id"; } # установка поля для сортировки по умолчанию, если не указано
if ($sort and $sort != $mySort) { $mySort = $sort; } # установка нового типа сортировки, если клиент выбрал другой
$_SESSION["orderSort"] = $mySort;
if (!$_SESSION["orderDesc"]) { $_SESSION["orderDesc"] = "desc"; } # получение направления сортировки или установка по умолчанию
if ($desc and $desc != $_SESSION["orderDesc"]) { $_SESSION["orderDesc"] = $desc; } # установка нового направления сортировки, если клиент выбрал другое
if (!$desc and $_SESSION["orderDesc"]) { $desc = $_SESSION["orderDesc"]; }
if ($desc == "desc") { $desc = "asc"; } else { $desc = "desc"; }
$myDesc = $_SESSION["orderDesc"];
getfont();
?>
<table width=99%>
<tr>
<Td valign=top>
<table width=270>
<tr><td align=center bgcolor=<?=$font_head?>><B>Фильтр</b></td></tr>
<tr><td bgcolor=<?=$font_row?>>
<form method=post>
Тип заказов: <select name=showVid>
<option value="all" <? if ($myShowVid == "all") {print "selected";} ?>>Все типы</option>
<?
while (list($k,$v) = each($_lang[OrderType])) {
if ($myShowVid == $k) { $selectedVid = "selected"; } else { $selectedVid = ""; }
print "<option value=$k $selectedVid>$v</option>";
}
?>
</select><BR>
Статус заказов: <select name=show>
<option value=all <? if ($myShow == 'all') {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><BR>
<center><input type=submit value=Показать></center>
</form>
</td></tr>
</table>
</td>
<td width=50> </td>
<Td valign=top>
<table width=300>
<tr><td align=center bgcolor=<?=$font_head?>><B>Поиск</b></td></tr>
<tr><td bgcolor=<?=$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 o.*,TO_DAYS(o.todate)-TO_DAYS(NOW()) as leftdays,t.vid$select from orders as o, tarifs as t $where order by o.$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);
?>
<table cellpadding=3 width=99%>
<tr><td colspan=12 align=right><?=$txt?></td></tr>
<tr><td colspan=12 align=center bgcolor=<?=$font_head?>><B>Заказы</b></td></tr>
<tr bgcolor=<?=$font_head?> align=center>
<td></td>
<td><a href=?do=<?=$do?>&sort=orderdate&desc=<?=$desc?>>Дата <? if ($mySort == "orderdate") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."' title='".$_sort[$myDesc]."'>"; } ?></a></td>
<Td>Логин</Td>
<td>Логин на сервере</td>
<td><a href=?do=<?=$do?>&sort=domain&desc=<?=$desc?>>Домен <? if ($mySort == "domain") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."' title='".$_sort[$myDesc]."'>"; } ?></a></td>
<td><a href=?do=<?=$do?>&sort=tarif&desc=<?=$desc?>>Тариф <? if ($mySort == "tarif") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."' title='".$_sort[$myDesc]."'>"; } ?></a></td>
<td><a href=?do=<?=$do?>&sort=todate&desc=<?=$desc?>><img src=./_rootimages/hosting.gif border=0 alt='Хостинг' title='Хостинг'> Конец <? if ($mySort == "todate") { print "<img src=./_rootimages/s_".$myDesc.".png border=0 width=11 height=9 alt='".$_sort[$myDesc]."' title='".$_sort[$myDesc]."'>"; } ?></a></td>
<td>moneyBack</td>
<td><img src=./_rootimages/domain.gif border=0 alt='Домен' title='Домен'> Конец</td>
<td><img src=./_rootimages/hosting.gif border=0 alt='Хостинг' title='Хостинг'> Статус</td>
<td><img src=./_rootimages/domain.gif border=0 alt='Домен' title='Домен'> Статус</td>
<td></td>
</tr>
<?
$r=@mysql_query("select o.*,TO_DAYS(o.todate)-TO_DAYS(NOW()) as leftdays,t.vid$select from orders as o, tarifs as t $where order by o.$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);
$t=mysql_query("select * from tarifs where id = '$rr->tarif'");
$t=mysql_fetch_object($t);
$b=mysql_query("select * from bills where host_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);
if ($rr->leftdays > 0 and ($t->vid == "hosting" or $t->vid == "reseller") and !$rr->testPeriod) {
$moneyBack = GetMoneyBackByOrderId($rr->id)." ".CURAS;
} else {
$moneyBack = "-";
}
if ($rr->leftdays == "") {$rr->leftdays=0;}
if ($rr->leftdays <= 10 and $rr->startdate != "0000-00-00") {$rr->leftdays = "<font color=red>".$rr->leftdays."</font>";}
$statusHosting="<img src=./_rootimages/obrabotan_".$rr->status."_small.gif border=0 alt='".$_status[$rr->status]."' title='".$_status[$rr->status]."'>";
if ($rr->testPeriod) { $statusHosting = $statusHosting." <img src=./_rootimages/test_small.gif border=0 alt='Тестовый период'>"; }
$toDateHosting=mydate($rr->todate);
$leftDaysHosting="<label alt='осталось дней' title='осталось дней'>[$rr->leftdays]</label>";
if ($rr->startdate != "0000-00-00" or ($rr->testPeriod and $rr->serverlogin)) { $toDateHostingTxt = "$toDateHosting $leftDaysHosting"; } else { $toDateHostingTxt = "-"; }
$statusDomain = "";
$toDateDomain = "";
$leftDaysDomain = "";
$toDateDomainTxt = "";
if ($rr->domain_reg == "1") {
$d=@mysql_query("select *,TO_DAYS(todate)-TO_DAYS(NOW()) as leftdays from orders_domains where host_id='$rr->id'") or die("File: ".__FILE__."<BR>Line: ".__LINE__."<BR>MySQL Error: ".mysql_error());
$d=mysql_fetch_object($d);
if ($d->leftdays == "") {$d->leftdays=0;}
if ($d->leftdays <= 30 and $d->startdate != "0000-00-00") {$d->leftdays = "<font color=red>".$d->leftdays."</font>";}
$statusDomain = "<img src=./_rootimages/obrabotan_".$d->status."_small.gif border=0 alt='".$_status[$d->status]."' title='".$_status[$d->status]."'>";
$toDateDomain = mydate($d->todate);
$leftDaysDomain = "<label alt='осталось дней' title='осталось дней'>[$d->leftdays]</label>";
if ($d->startdate != "0000-00-00") { $toDateDomainTxt = "$toDateDomain $leftDaysDomain"; } else { $toDateDomainTxt = "-";}
}
if ($rr->domain) { $domainTxt = "<B>$rr->domain</b><BR>"; }
else { $domainTxt = ""; }
print "
<tr bgcolor=$font_row height=30>
<td align=center>
<a href=?do=editorder&host_id=$rr->id><img src=./_rootimages/edit.gif border=0 alt='Редактировать заказ' title='Редактировать заказ'></a><a href=?do=$do&sub=delete&id=$rr->id onclick="javascript: return confirm('Будет удален заказ, а так же все счета, относящиесу к нему. Вы уверены, что хотите удалить заказ?');"><img src=./_rootimages/del.gif border=0 alt='Удалить заказ' title='Удалить заказ'></a>
</td>
<td align=center>".mydate($rr->orderdate)."</td>
<td align=center><a href=?do=fullinfo&id=$u->id>$u->login</a></td>
<td align=center>$rr->serverlogin</td>
<td>".$domainTxt."[".$_newregmin[$rr->domain_reg]."]</td>
<td align=center>$t->name</td>
<td align=center nowrap>$toDateHostingTxt</td>
<td align=center>$moneyBack</td>
<td align=center nowrap>$toDateDomainTxt</td>
<td align=center>$statusHosting</font></td>
<td align=center>$statusDomain</font></td>
<td align=center>
<A href=?do=bills¶m=host_id&search=$rr->id><img src=./_rootimages/bills.gif border=0 alt='Счета по данному заказу: $bills' title='Счета по данному заказу: $bills'></a>
</td>
</tr>
";
$cnt++;
}
?>
<tr bgcolor=<?=$font_head?>><Td colspan=12>Всего заказов: <?=$rows?>, заказов на странице: <?=$cnt?></td></tr>
<tr><td colspan=12 align=right><?=$txt?></td></tr>
</table>
<?
?>