<?php
$db = mysql_connect ("127.0.0.1","root","");
mysql_select_db("smeta",$db);
mysql_query("set names 'cp1251',$link");
$result = mysql_query("SELECT name FROM smetaonl",$db)or die("ERROR: ".mysql_error());
$row = mysql_fetch_assoc($result);
$zn = 1;
$z = 2;
$klvrazd = 1;
$q = mysql_query ("SELECT * FROM smetaonl");
echo "<form action='add.php' method='post' id='grdform'><table class='table1' bgcolor='#fff' id='table1' width='100%' cellspacing='0'>";
echo "<tr id='tr' bgcolor='#fff'>";
echo "<th align='center' bgcolor='#fff'></th>";
echo "<th align='center'>№№</th>";
echo "<th align='center'>Цвет</th>";
echo "<th align='center'>Обоснование</th>"; //---+
echo "<th align='center'>Наименование</th>";
echo "<th align='center'>Ед. измерения</th>";
echo "<th align='center'>Количество на единицу</th>"; //---+
echo "<th align='center'>Цена</th>";
echo "<th align='center'>Тип строки</th>"; //---+
echo "<th align='center'>Количество всего</th>";
echo "<th align='center'>% выполнения</th>"; //---+
echo "<th align='center'>Примечание</th>"; //---+
echo "<th align='center'>Подитог</th></tr>";
echo "<tr bgcolor='#fff'><th bgcolor='#fff'><a href='#' onClick='add(this); add(this)'><img src='per.gif' align='left'></a></th><th colspan='12' align='center' id=raz$zn>Раздел1</th></tr>";
for ($c=0; $c<mysql_num_rows($q); $c++)
{
$f = mysql_fetch_array($q);
$s = $f[cena]*$f[kolvo];
$colo[$zn] = $f[color];
echo "<tr id='tr$zn' class='tr$zn' bgcolor='#ccc'>";
echo "<td align='left' width='82' bgcolor='#fff'><a href='#' ID=k$zn onClick='delstr(this)' class='left'>X</a><a href='#' ID=k$zn onClick='addRaz(this)' ><img src='remove.gif' align='center'></a><img src='plus.gif' align='right'><br><a href='#' ID=k$zn onClick='pure(this); func()'><img src='zero.gif' align='left'></a><a href='#' ID=k$zn onClick='minus(this)'><img src='minus.gif' align='center'></a><a href='#' ID=k$zn onClick='copy(this); func()'><img src='arr.gif' align='right'></a></td><td id=nnome$zn>";
echo "$f[numb]";
echo "</td><td align='center' id='ooo'>";
echo "<a href='#' id='color$zn' onClick='h_show(this)'>Выбор</a>";
echo '<script language="javascript">col_or[cc] = parseInt("'.$f[color].'"); cc += 1;</script>';
echo "<br><a href='#' onClick='deleteRow(this)'><img src='delete.gif' align='left'></a><a href='#' id='down_col$z' onClick='down_col(this)'><img src='arrow.gif' align='right'></a></td><td>";
echo "<input type='text' size='15' maxlength='15' name='obos$zn' id='obos$zn' value='$f[obos]'><br><img src='delete.gif' align='left'><a href='#' id='down_obs$z' onClick='down_obs(this)'><img src='arrow.gif' align='right'></a>";
echo "</td><td><input type='text' size='15' maxlength='15' name='name$zn' id='name$zn' value='$f[name]'><br><a href='#' id='down_nmn$z' onClick='down_nmn(this)'><img src='arrow.gif' align='right'></a>";
echo "</td><td align='center'><a href='#' id=mera$zn onClick='h_show_mera(this)'>";
echo "$textt</a><br><a href='#' id='down_edm$z' onClick='down_edm(this)'><img src='arrow.gif' align='right'></a>";
echo "</td><td><input type='text' class='prices' onkeyup='func()' size='15' maxlength='15' name='kolvo$zn' id='kolvo$zn' value='$f[kolvs]'><br><img src='delete.gif' align='left'><a href='#' id='down_kle$z' onClick='down_kle(this)'><img src='arrow.gif' align='right'></a>";
echo "</td><td valign='top'><input type='text' class='prices' onkeyup='func()' size='15' maxlength='15' name='cena$zn' id=cen$zn value='$f[cena]'>";
echo "</td><td>";
echo "<a href='#' id=tip$zn>$f[tipst]</a>";
echo "<br><img src='delete.gif' align='left'></td><td valign='top'><input type='text' class='prices' onkeyup='func()' size='15' maxlength='15' name='kolvs' id=kol$zn value='$f[kolvo]'>";
echo "</td><td>";
echo "<input type='text' class='prices' size='3' maxlength='3' name='vypol$zn' id=vypol$zn value='$f[vypol]'>";
echo "<br><img src='delete.gif' align='left'></td><td><input type='text' class='prices' size='15' maxlength='15' name='prim$zn' id='prim$zn' value='$f[prim]'><br><img src='delete.gif' align='left'><a href='#' id='down_prm$z' onClick='down_prm(this)'><img src='arrow.gif' align='right'></a>";
echo "</td><td valign='top'><input type='text' size='15' maxlength='15' name=sum$zn id=sum$zn disabled></td></tr>";
$zn++;
$z++;
}
echo "<tr bgcolor='#fff'><td colspan='12' class='rightcol'><a align='left'>Итого</a></td><td align='center' bgcolor='ffffff'><a id='itog'>0</a></td></tr>";
while ($x<10)
{
$g = $x;
$itog_o = "obos$g";
$itog_o = $_POST[$itog_o];
$itog_n = "name$g";
$itog_n = $_POST[$itog_n];
$itog_k = "kolvo$g";
$itog_k = $_POST[$itog_k];
$itog_v = "vypol$g";
$itog_v = $_POST[$itog_v];
$itog_p = "prim$g";
$itog_p = $_POST[$itog_p];
$bl = "1.$g";
$query = "UPDATE smetaonl SET obos = '$itog_o' WHERE numb = $bl";
$result = mysql_query($query);
$query = "UPDATE smetaonl SET name = '$itog_n' WHERE numb = $bl";
$result = mysql_query($query) or die("Query failed");
$query = "UPDATE smetaonl SET kolvo = '$itog_k' WHERE numb = $bl";
$result = mysql_query($query) or die("Query failed");
$query = "UPDATE smetaonl SET vypol = '$itog_v' WHERE numb = $bl";
$result = mysql_query($query) or die("Query failed");
$query = "UPDATE smetaonl SET prim = '$itog_p' WHERE numb = $bl";
$result = mysql_query($query) or die("Query failed");
$x++;
}
?>
</table><input type="button" onClick="send()" value="Сохранить"></form>