project_web/ChooseCustomItem.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
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
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
<?php
require_once("session.php");
$session=new session();

if(!$SerialNumbers=$session->get_value("SerialNumbers"))
{
	echo "******************取得SerialNumbers失敗******************";
	exit();
}

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

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

$query="SELECT * FROM ".$SerialNumbers." WHERE State !='DIE'";
$db->query($query);

if($db->get_num_rows()!=1)
{
	echo "取得ItemID失敗";
	exit;
}

$temp=$db->fetch_array();
$ItemID=$temp['ID'];

$query="SELECT * FROM StoreTakenItem WHERE Store='".$SerialNumbers."'";
$db->query($query);

//找出所有商品清單 之後轉換名字用
while($temp=$db->fetch_array())
{
	$TakenItemIDList[]=$temp['TakenItemID'];
	$TakenItemNameList[]=$temp['ItemName'];
	$TakenItemPriceList[]=$temp['Price'];
}


$query="SELECT * FROM custom_information WHERE store='".$SerialNumbers."' AND item='".$ItemID."' AND number='".$_POST['CustomNumber']."'";
$db->query($query);
$temp=$db->fetch_assoc();
?>


<div style="border:1px solid;background-color:#EB87EA;margin-top:1px;">
	<span style="font-size:20px">第</span>
	<font size="18" style="color:#F7FA00;"><?php echo $_POST['CustomNumber'] ?></font>
	<span style="font-size:20px">號客戶商品列表</span>
</div>
<!--<div><button id="CloseCustomItemWindow">結束服務</button>-->
<!--<button id="CancelSelect">取消選取</button></div>-->
<div id="phoneNumber" style="font-size:18px;margin-top:10px;margin-bottom:10px;">電話：<?php echo $temp['PhoneNumber'];?></div>
<div id="ItemListBlock">
		<div class="ItemListTr">
			<div class="ItemListTd">
				商品名稱
			</div>
			<div class="ItemListTd">
				商品數量
			</div>
			<div class="ItemListTd">
				商品單價
			</div>
			<div class="ItemListTd">
				狀態
			</div>
		</div>
		<?php
			$TotalCost=0;


				$SelectItem=json_decode($temp['SelectItem']);
				foreach($SelectItem as $ItemTemp=>$ItemData)
				{
					$TakenItemID="";
					$NeedValue="";

					foreach($ItemData as $ItemColumn=>$Data)
					{
						if($ItemColumn=="TakenItemID")
							$TakenItemID=$Data;
						if($ItemColumn=="NeedValue")
							$NeedValue=$Data;
						if($ItemColumn=="Life")
							$Life=$Data;

					}

					echo '<div class="ItemListTr">';

					echo '<div class="ItemContentTd">';
					$Record=0;

					for($i=0;$i<count($TakenItemIDList);$i++)
					{
						if($TakenItemIDList[$i]==$TakenItemID)
						{
							echo $TakenItemNameList[$i];
							$Record=$i;

						}

					}

					echo '</div>';

					echo '<div class="ItemContentTd">';
					echo $NeedValue;
					echo '</div>';

					echo '<div class="ItemContentTd">';
					echo $TakenItemPriceList[$Record];
					echo '</div>';

					echo '<div class="ItemContentTd">';
					if($Life=='0')
						echo '未完成';
					if($Life=='1')
						echo '<span style="color:blue;font-weight:bolder;">已完成</span>';
					if($Life=='2')
						echo '製作中';
					echo '</div>';

					echo '</div>';
					$TotalCost+=(int)$TakenItemPriceList[$Record]*(int)$NeedValue;
				}


		?>

</div >
<div style="font-size:30px">
總金額: <span style="color:red;"><?php echo $TotalCost ?></span> 元
</div>
<script>
$('#CloseCustomItemWindow').click(function()
		{
			//清除CustomItemListBlock
			$('#CustomItemListBlock').html("");

			var Number=$('#NumberSelector').children("[selected]").val();
			if(Number!=undefined)
			{
				CloseCustomItemWindow(Number);
			}
			else
			{
				var Count=$('#NumberSelector').children().size();
				if(Count==1)
				{
					$('#NumberSelector').children().each(function()
										{
											if($(this).attr("selected")==undefined)
												;
											else
												CloseCustomItemWindow($(this).val());
										});
				}
				else
				{

				}
			}
			//將選擇屬性取消
			$('#NumberSelector').children().attr("selected",false);


		});

</script>