Автоматизация и оптимизация продаж жилья с помощью интернет-технологий на предприятии ООО "Домстрой-1"

$res = $db->query($q);

$num = $res->num_rows;

for($e=0;$e<$num;$e++)

{

$r = $res->fetch_assoc();

//echo $r['name']."<br>";

$pgr = (int)$r['pgrID'];

echo "<optgroup label=";echo "'-> "; echo $r['name'];echo"'>";

$qu = "select * from tovar where pgrID='".$pgr."'";

$resu = $db->query($qu);

$n=$resu->num_rows;

for($s=0;$s<$n;$s++)

{

$re=$resu->fetch_assoc();

echo "<option value=".$re['kod'];

echo "'>";

echo $re['naim'];

echo "</option>";

}

echo "</optgroup>";

}

echo "</optgroup>";

//echo "<hr>";

}

echo "</select>";

echo "<select name='kol'>";

for($t=1;$t<250;$t++)

{

echo "<option value=";

echo $t;

echo ">";

echo $t;

echo "</option>";

}

echo "<input type='submit' value='INSERT'>";

echo "</select><br><br>";

echo "</form>";

echo "<form name='tab'>";

echo "<TABLE width='50%' border='1' align='center'><TBODY>";

echo "<tr><td><font size=4 color='red'>Наименование</td><td>Цена</td><td>Количество</td></font></tr>";

$arr = array();

$arrnom = array();

$zapros = "select * from ord_item where ordid=1";

$reszap = $db->query($zapros);

$kolrows = $reszap->num_rows;

for($r=1;$r<$kolrows+1;$r++)

{

$row=$reszap->fetch_assoc();

$kodt = (int)$row['tovid'];

$kolt = (int)$row['kol'];

$zapros2 = "select * from tovar where kod='".$kodt."'";

$reszap2=$db->query($zapros2);

$row2 = $reszap2->fetch_assoc();

$arr[$r]=$row2['naim'];

$arrnom[$r]=$row2['kod'];

echo "<tr><td>"; echo $row2['naim'];echo "</td><td>"; echo $row2['prise']; echo "</td><td>"; echo $kolt; echo "</td></tr>";

$summa = $summa + (int)$row2['prise']*(int)$kolt;

}

echo "<tr><td><b>Итого по заказу<b></td><td></td><td>".$summa; echo "</td></tr>";

echo "</TBODY></TABLE>";

echo "<p align='center'><input type='submit' value='create'></p>";

echo "</form><br/>";

echo "<table align='center'><form action='del.php' name='delete' method='POST'>";

echo "<select name='row_del'>";

echo "<option selected value='all'>Все</Option>";

for($w=1;$w<$kolrows+1;$w++)

{

echo "<option value='$arrnom[$w]'>".$arr[$w]; echo "</option>";

}

echo"<input type='submit' value='Delete row'></table>";

echo "</form>";

?>

Приложение 3

Программный код модуля Insert_item.php

<?php

$tovar = $_POST['tovar'];

$kol = $_POST['kol'];

@ $db=new mysqli('localhost', `Client', ' 6a1133a45de6acbfde8d54dc9315cbd25e1765d1', 'tovar');

$data = date('y-m-d');

$ordid = 1;

$ordid = (int)$ordid;

//echo (int)$tovar;echo "//".(int)$kol;

$kodtov = (int)$tovar;

$koltov = (int)$kol;

if (mysqli_connect_errno())

{

echo 'Нет соединения!!';

exit;

}

@mysql_query ("set character_set_client='cp1251'");

@mysql_query ("set character_set_results='cp1251'");

@mysql_query ("set collation_connection='cp1251_general_ci'");

$query = "insert into ord_item (tovid, ordid, kol) values ('".$kodtov."', '".$ordid."', '".$koltov."')";

$result=$db->query($query);

if ($result)

echo $db->affected_rows." пункт заказа добавлен!<br>";

include('select.php'); ?>

Приложение 4

Программный код модуля nedvig_update.php

<?php

$date=date('dmy');

$fname='tov'&$date&'.xml'

header('Content-Type: text/html; charset=windows-1251');

$xmlstr = join('',file($fname));

define("CHARSET", "Windows-1251");

if(!$dom = domxml_open_mem($xmlstr)) {

echo "Ошибка при разборе документа\n";

exit;

}

$root = $dom->document_element();

$nodes = $root->child_nodes();

//print_r($nodes);

echo "<br>";

echo $nodes;

echo "<hr>";

$i=0;

foreach($nodes as $node){

if ($node->tagname=='element'){

$persons_info =

$node->child_nodes();

foreach ($persons_info as $info){

if ($info->type==XML_ELEMENT_NODE) {

$currentPers[$info->tagname] = $info->get_content();

//echo $info->tagname;

}}

$naim = $currentPers['name']; #25

$kod = (int)$currentPers['kod'];

Продолжение приложения 8.

$prise=(float)$currentPers['prise'];

$kol =1;

echo "$naim/*/$kod/*/<br>";

@ $db=new mysqli('localhost', 'manager', ' 6a1133a45de6acbfde8d54dc9315cbd25e1765d1', 'tovar');

if (mysqli_connect_errno())

{

echo 'Нет соединения!!';

exit;

}

@mysql_query ("set character_set_client='cp1251'");

@mysql_query ("set character_set_results='cp1251'");

@mysql_query ("set collation_connection='cp1251_general_ci'");

$query="update into tovar (kod, name, prise) values

('".$kod."', '".$name."', '".$prise."')";

$result=$db->query($query);

if ($result)

echo $db->affected_rows." Товар обновлен!<br>";

}

Размещено на Allbest.ru