include_once './db_connect.php';
//подключаемся к базе
$dbh = mysql_connect(host, user, pswd) or die("Не могу соединиться с MySQL.");
mysql_select_db(SCAD) or die("Не могу подключиться к базе.");
$res = mysql_query("SET NAMES utf8");
//обновляем узлы
$nodes = new TNode();
$sql = "UPDATE " . document . " SET text = '" . $nodes->set_to_scad_txt() . "' WHERE id = " . D_node;
mysql_query($sql);
//обновляем элементы
$members = new TMember();
$s = iconv('UTF-8', 'CP1251', $members->set_to_scad_txt());
$sql = "UPDATE " . document . " SET text = '{$s}' WHERE id = " . D_member;
mysql_query($sql);
//обновляем группы для подбора стали
$groups_for_steel = new TMemberGroupSteel();
$s = iconv('UTF-8', 'CP1251', $groups_for_steel->set_to_scad_txt());
$sql = "UPDATE " . document . " SET text = '{$s}' WHERE id = " . D_member_group_for_steel;
mysql_query($sql);
//собираем документ
$today = date("d.m.Y");
header("Content-Disposition: attachment; filename={$today}.txt");
header("Content-Type: application/octet-stream");
$sql = "SELECT * FROM " . document;
mysql_query($sql);
switch (mysql_errno()) {
case 1146:
echo "<b>Table " . document . " doesn't exist. Please create DB.</b><br>";
break;
default:
if (mysql_errno() > 0) {
$document[$doc_number] = $doc_content;
}
echo 'Загружены документы:<br/>';
// print_r($document);
//разбираем группы элементов
$TIMESTART = timeMeasure();
if (isset($document[D_member_group])) {
$member_groups = new TMemberGroup();
$member_groups->get_from_scad_txt($document[D_member_group]);
echo D_member_group . ' - группы элементов;<br/>';
}
echo round(timeMeasure() - $TIMESTART, 6) . ' сек<br/>';
$TIMESTART = timeMeasure();
//разбираем группы для подбора стали
if (isset($document[D_member_group_for_steel])) {
$member_groups_for_steel = new TMemberGroupSteel();
$member_groups_for_steel->get_from_scad_txt($document[D_member_group_for_steel]);
echo D_member_group_for_steel . ' - группы элементов для подбора;<br/>';
}
echo round(timeMeasure() - $TIMESTART, 6) . ' сек<br/>';
$TIMESTART = timeMeasure();
//разбираем узлы
if (isset($document[D_node])) {
//замена переносов
$document[D_node] = str_replace("\r\n", ' ', $document[D_node]);
$document[D_node] = str_replace("\n", ' ', $document[D_node]);
//замена двойных пробелов
$document[D_node] = preg_replace("|\\s{2,}|", ' ', $document[D_node]);
$nodes = new TNode();
$nodes->get_from_scad_txt($document[D_node]);
echo D_node . ' - узлы;<br/>';
