project_web/next_value.php at master · CFWei/project_web · GitHub

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
<?php

require_once("session.php");
require_once("connect_mysql_class.php");
require_once("mysql_inc.php");

//$SerialNumbers=$_POST['SerialNumbers'];
$se=new session();
	if(!$SerialNumbers=$se->get_value("SerialNumbers"))
	{
		echo "******************取得SerialNumbers失敗******************";
		exit();
	}
$Item_Id=$_POST['Item_Id'];
$choose=$_POST['choose'];
//1:下一號 2：跳號

//$SerialNumber="AGgnGwIhGMZWIPecEQ4B";
//$Item_Id="eyaP1gPTbI";

$db=new DB();
$db->connect_db($_DB['host'], $_DB['username'], $_DB['password'], $_DB['dbname']);

$query="SELECT Now_Value,Value,State FROM ".$SerialNumbers." WHERE ID = '".$Item_Id."'";
$db->query($query);

$temp=$db->fetch_array();
$Now_Value=$temp['Now_Value'];
$Value=$temp['Value'];
$State=$temp['State'];

//$query="UPDATE custom_information SET life=1 where `store` ='".$SerialNumbers."' and `item`='".$Item_Id."' and `number`='".$Now_Value."'";
//$db->query($query);

$query="SELECT number,custom_id,life FROM custom_information WHERE store='".$SerialNumbers."' and item='".$Item_Id."' and life='0' order by number";
$db->query($query);

$check=-1;
while($t=$db->fetch_array())
{
	//將目前號碼的使用者 life 設為 1(已服務）
	if($t['number']==$Now_Value && $t['life']!=1 && $choose==1)
	{
		$db1=new DB();
		$db1->connect_db($_DB['host'], $_DB['username'], $_DB['password'], $_DB['dbname']);
		$query="UPDATE custom_information SET life=1 where `store` ='".$SerialNumbers."' and `item`='".$Item_Id."' and `number`='".$Now_Value."' and custom_id='".$t['custom_id']."'";
		$db1->query($query);
	}
	if($t['number']>$Now_Value && $t['life']==0 && $check==-1)
	{
		$check=$t['number'];
	}
}
echo $check;
/*
if($check==-1&&$State!='WAIT')
{
	$query="UPDATE `".$SerialNumbers."` SET `State`=\"WAIT\" where `ID` =\"".$Item_Id."\"";
	$db->query($query);
}
*/

if($check!=-1)
{
	$query="UPDATE `".$SerialNumbers."` SET `Now_Value`=\"".$check."\" where `ID` =\"".$Item_Id."\"";
	$db->query($query);
	if($State=='WAIT')
	{
		$query="UPDATE `".$SerialNumbers."` SET `State`=\"STOP\" where `ID` =\"".$Item_Id."\"";
		$db->query($query);
	}
}


?>