/
addposintz.php
123 lines (116 loc) · 4 KB
/
addposintz.php
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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<?
// Äîáàâëÿåò ïîçèöèþ ÒÇ â áàçó â áàçó
// Ïàðàìåòðû
// tz - èäåíòèôèêàòîð ÒÇ
// posintz - íîìåð ïîçèöèè â ÒÇ
// customer - çàêàç÷èê
// board - èìÿ ïëàòû
// numbers - êîëè÷åñòâî
// zap - çàïóùåíà èëè íåò (0/1)
// user - êòî äîáàâèë
// Âîçâðàùàåò id
$GLOBALS["debugAPI"] = true;
include_once $GLOBALS["DOCUMENT_ROOT"]."/lib/sql.php"; // ýòî íóæíî ïðè äîáàâëåíèè òàê êàê íå âûçûâàåòñÿ çàãîëîâê html
print_r($_GET);
// Îïðåäåëèì èäåíòèôèêàòîð êîìåíòàðèÿ
$sql="SELECT id FROM coments WHERE comment='$comment'";
debug($sql);
$res = mysql_query($sql);
if ($rs=mysql_fetch_array($res)){
$comment_id = $rs["id"];
} else {
$sql="INSERT INTO coments (comment) VALUES ('$comment')";
debug($sql);
mysql_query($sql);
$comment_id = mysql_insert_id();
if (!$comment_id) my_error();
}
// Îïðåäåëèì èäåíòèôèêàòîð ïîëüçîâàòåëÿ
$sql="SELECT id FROM users WHERE nik='$user'";
debug($sql);
$res = mysql_query($sql);
if ($rs=mysql_fetch_array($res)){
$user_id = $rs["id"];
} else {
$sql="INSERT INTO users (nik) VALUES ('$user')";
debug($sql);
mysql_query($sql);
$user_id = mysql_insert_id();
if (!$user_id) my_error();
}
// íàéäåì íîìåð çàêàç÷èêà
$file_link = addslashes($file_link);
debug ($file_link);
$sql="SELECT id FROM customers WHERE customer='$customer'";
debug($sql);
$res = mysql_query($sql);
if ($rs=mysql_fetch_array($res)){
$customer_id = $rs["id"];
} else {
$sql="INSERT INTO customers (customer) VALUES ('$customer')";
debug($sql);
mysql_query($sql);
$customer_id = mysql_insert_id();
if (!$customer_id) my_error();
}
// îïðåäåëèì ïëàòó
$sql="SELECT id FROM plates WHERE customer_id='$customer_id' AND plate='$board'";
debug($sql);
$res = mysql_query($sql);
if ($rs=mysql_fetch_array($res)){
$plate_id = $rs["id"];
} else {
$sql="INSERT INTO plates (customer_id,plate) VALUES ('$customer_id','$board')";
debug($sql);
mysql_query($sql);
$plate_id = mysql_insert_id();
if (!$plate_id) my_error();
}
// îïðåäåëèì ïëàòó
$sql="SELECT id FROM boards WHERE customer_id='$customer_id' AND board_name='$board'";
debug($sql);
$res = mysql_query($sql);
if ($rs=mysql_fetch_array($res)){
$board_id = $rs["id"];
} else {
// íå áóäó äîáàâëÿòü - äàííûõ íåò è ýòî äåëàåòñÿ â äðóãîì ìåñòå
}
// Îïðåäåëèì áëîê - îí óæå äîëæåí áûòü â áàçå
$sql = "SELECT * FROM blockpos WHERE board_id='$board_id'";
debug($sql);
$res = mysql_query($sql);
if ($rs=mysql_fetch_array($res)){
$block_id = $rs["block_id"];
} else {
// íå áóäó äîáàâëÿòü - äàííûõ íåò è ýòî äåëàåòñÿ â äðóãîì ìåñòå
}
// äîáàâèì ÌÏ åñëè åñòü òàêîå èñïðàâèì
$sql="SELECT * FROM posintz WHERE tz_id='$tz' AND posintz='$posintz'";
debug($sql);
$res = mysql_query($sql);
if (mysql_num_rows($res) == 0){
$sql="INSERT INTO posintz (tz_id,posintz,plate_id,board_id,block_id,numbers,first,srok,priem,constr,template_check,template_make,eltest,numpl,numbl,pitz_mater,pitz_psimat,comment_id) VALUES ('$tz','$posintz','$plate_id','$board_id','$block_id','$numbers','$first','$srok','$priem','$constr','$template_check','$template_make','$eltest','$numpl','$numbl','$textolite','$textolitepsi','$comment_id')";
debug($sql);
mylog1($sql);
mysql_query($sql);
$pit_id = mysql_insert_id();
if (!$pit_id) my_error();
} else {
$sql="UPDATE posintz SET numbers='$numbers', plate_id='$board_id',plate_id='$board_id', block_id='$block_id',first='$first',srok='$srok',priem='$priem',constr='$constr',template_check='$template_check',template_make='$template_make', eltest='$eltest', numpl='$numpl', numbl='$numbl', pitz_mater='$textolite', pitz_psimat='$textolitepsi', comment_id='$comment_id' WHERE tz_id='$tz' AND posintz='$posintz'";
debug($sql);
mylog1($sql);
mysql_query($sql);
$rs=mysql_fetch_array($res);
$pit_id = $rs["id"];
}
// îáíîâèòü çàïóñêè åñëè íåêîòîðûå ïîçèöèè óæå çàïóñêàëèñü
$sql="SELECT * FROM lanch WHERE tz_id='$tz' AND pos_in_tz='$posintz'";
$res = mysql_query($sql);
if($rs=mysql_fetch_array($res)) {
$sql="UPDATE lanch SET pos_in_tz_id='$pit_id' WHERE id='".$rs["id"]."'";
mysql_query($sql);
$sql="UPDATE posintz SET ldate='".$rs["ldate"]."' WHERE id='$pit_id'";
mysql_query($sql);
}
printf("%08d",$pit_id);
?>