-
Notifications
You must be signed in to change notification settings - Fork 0
/
addblockpos.php
42 lines (36 loc) · 1.74 KB
/
addblockpos.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
<?
require $_SERVER["DOCUMENT_ROOT"] . "/lib/config.php";
$_SERVER["debug"] = false;
require $_SERVER["DOCUMENT_ROOT"] . "/lib/core.php";
// ïåðåêîäèðóåì ïîëó÷åíûå äàííûå
// (èñïîëüçóþòñÿ ôóíêöèè èç multibyte.php, ïîòîìó
// çäåñü, à íå â encoding.php âûçûâàåì)
// TODO: À íóæíî ëè çäåñü? Çàïðåòèë ðåãèñòðàöèþ ãëîáàëüíûõ,
// à ïîñò è ãåò òóò âñ¸ ðàâíî ðåãèñòðèðóþ
foreach ($_GET as $key => $val) {
${$key} = cmsUTF_decode($val);
// îíà ñàìà è ìàññèâû ïåðåêîäèðóåò è ïðîâåðÿåò íà utf
}
foreach ($_POST as $key => $val) {
${$key} = cmsUTF_decode($val);
// îíà ñàìà è ìàññèâû ïåðåêîäèðóåò è ïðîâåðÿåò íà utf
}
// çàêàç÷èê ïî tzid
$sql = "SELECT orders.customer_id AS id FROM tz JOIN (orders) ON (tz.order_id=orders.id) WHERE tz.id='{$tznumber}'";
$rs = sql::fetchOne($sql);
if (empty($rs)) {
echo -1;
exit;
}
$customer_id = $rs[id];
// ïëàòó
$sql="SELECT id FROM boards WHERE customer_id='$customer_id' AND board_name='$board'";
$rs = sql::fetchOne($sql);
$sql="REPLACE INTO boards (id,board_name,customer_id,sizex,sizey,thickness,drawing_id,texåolite,textolitepsi,thick_tol,rmark,frezcorner,layers,razr,pallad,immer,aurum,numlam,lsizex,lsizey,mask,mark,glasscloth,class,complexity_factor,frez_factor) VALUES ('{$rs["id"]}' , '$board' ,'$customer_id' ,'$sizex' ,'$sizey' ,'$thickness' ,'$drawing_id' ,'$textolite' ,'$textolitepsi' ,'$thick_tol' ,'$rmark' ,'$frezcorner' ,'$layers' ,'$razr' ,'$pallad' ,'$immer' ,'$aurum' ,'$numlam' ,'$lsizex' ,'$lsizey' ,'$mask' ,'$mark' ,'$glasscloth' ,'$class' ,'$complexity_factor' ,'$frez_factor')";
sql::query ($sql);
$plate_id = sql::lastId();
// ïîçèöèþ ê áëîêó
$sql = "INSERT INTO blockpos (block_id,board_id,nib,nx,ny) VALUES ('$block_id','$plate_id','$num','$bnx','$bny')";
sql::query ($sql);
echo $plate_id;
?>