PHP - [51] :: Web-программирование :: Компьютерный форум Ru.Board

как это можно заставить рабоать быстрее, а то ругается что за 30 сек не успевает сделать и как решить проблему весокосного года

Код:

<form action="create.report.php" method="post">
<table cellpadding="1" cellspacing="0" class=text_normal>
<tr>
<td>
Префикс номера
<td>
<SELECT NAME=prefix class=form_normal>
<option>52
<option>58
<option>59
</SELECT>

<tr>
<td>
Дата ПО (DD:MM:YYYY)
<td>
<SELECT NAME=day class=form_normal>
<?
for($i=1;$i <= 31;$i++):
if ($i < "10"):
if ($i == date(d)) echo "<option selected>0".$i;
else echo "<option>0".$i;
else:
if ($i == date(d)) echo "<option selected>".$i;
else echo "<option>".$i;
endif;
endfor;
?>
</SELECT>:
<SELECT NAME=month class=form_normal>
<?
for($i=1;$i <= 12;$i++):
if ($i < "10"):
if ($i == date(m)) echo "<option selected>0".$i;
else echo "<option>0".$i;
else:
if ($i == date(m)) echo "<option selected>".$i;
else echo "<option>".$i;
endif;
endfor;
?>
</SELECT>:
<SELECT NAME=year class=form_normal>
<?
$year = date(Y);
for($i=1;$i <= $year[3];$i++):
if ($i < "10"):
if ($i == $year[3]) echo "<option selected>200".$i;
else echo "<option>200".$i;
else:
if ($i == $year[3]) echo "<option selected>20".$i;
else echo "<option>20".$i;
endif;
endfor;
?>
</SELECT>
<tr><td><td><input type="submit" name="create_report" value="показать" class=form_button>
</table>
</form>
<hr>

<br>
<?

if ($_POST['create_report'] != ""){

$day_po = $_POST['day'];
$month_po = $_POST['month'];
$year_po = $_POST['year'];
switch($_POST['month']):
case 1:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '32')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 2:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '29')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 3:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '32')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 4:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '31')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 5:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '32')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 6:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '31')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 7:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '32')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 8:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '32')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 9:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '31')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 10:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '32')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 11:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '31')
{
$month_po++;
if ($month_po < 10) $month_po = "0".$month_po;
$day_po = '01';
}
break;
}
case 12:
{
$day_po++;
if ($day_po < 10) $day_po = "0".$day_po;
if ($day_po == '32')
{
$month_po = '01';
$day_po = '01';
$year_po++;
}
break;
}
endswitch;

$DateTime = $_POST['year'].$_POST['month'].$_POST['day'];

switch($_POST['prefix']):
case 52:
{
$num_a_st = 2520000;
$num_a_en = 2529999;
break;
}
case 58:
{
$num_a_st = 2580000;
$num_a_en = 2589999;
break;
}
case 59:
{
$num_a_st = 2590000;
$num_a_en = 2599999;
break;
}
endswitch;

for ($num = $num_a_st;$num <= $num_a_en;$num++,$min_sum = 0)
{
if (mssql_result(mssql_query("SELECT Tar FROM tarphone where PhoneA = ".$num.""),0,0) == 1)
{
$result = mssql_query("
SELECT CallLength FROM ".$tbl_store."
WHERE (PhoneA LIKE '%".$num."') AND (CallDateTime >= '".$DateTime."') AND
(CallDateTime < '".$year_po.$month_po.$day_po."')
");

/*
SELECT ".$tbl_store.".CallLength,".$tbl_store.".PhoneA
FROM ".$tbl_store." LEFT OUTER JOIN
tarphone ON tarphone.PhoneA = ".$tbl_store.".PhoneA
WHERE (".$tbl_store.".PhoneA LIKE '%".$num."') AND (".$tbl_store.".CallDateTime >= '".$DateTime."') AND
(".$tbl_store.".CallDateTime < '".$year_po.$month_po.$day_po."') AND (tarphone.Tar = 1)

*/

if (mssql_num_rows($result) != 0)
{
echo "<br>".$num."<br>";
for($i = 1; $i <= mssql_num_rows($result); $i++):
$m = mssql_result($result,$i-1,0)/60;
$m_a = explode(".",$m);
if ($m_a[1] != "") $m_a[0]++;
$min_sum += $m_a[0];
endfor;
echo $min_sum;
}
}
}
}
else echo "пусто";
?>
</tr></table></body></html>
<br>
</body></html>

Модерирует : Cheery
Версия для печати • Подписаться • Добавить в закладки
Страницы: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71