001.<?
002.session_start();
003.include"checksession.php";
004.include"ConnectionDb.php";
005.?><?
006.
007.$page=$_GET['page'];
008.if($page==""){
009. $page=1;
010.}
011.$each=10;
012.
013.$sql_product="SELECT* FROM tbpackren";
014.$result_product= mysql_query($sql_product);
015.$totals=mysql_num_rows($result_product);
016.$totalpages=ceil($totals/$each);
017.$goto=($page-1)*$each;
018.
019.$sql_product = "SELECT*FROM tbpackren ORDER BY pkrenid DESC limit $goto,$each";
020.$result_product = mysql_query($sql_product);
021.
022.
023.$sql="SELECT MAX (pkrenid) AS pkrenid FROM tbpackren";
024.$result=mysql_query($sql);
025.$dbarr= mysql_fetch_array($result);
026.if($num=="0"){
027. $total="0001";
028.}else{
029. $total=$dnarr['pkrenid']+1;
030. if($total<10){
031. $total="000".$total;
032. }elseif ($total<100){
033. $total="00".$total;
034. } elseif ($total<1000){
035. $total="0".$total;
036. }
037.}
038.?>
039.<table width="700" border="0" align="center" cellpadding="1" cellspacing="1" bordercolordark="#FFFFFF">
040.<tr>
041.<td colspan="5" bgcolor="#FFCCCC" align="center"><b>รายการข้อมมูลโปรโมชั่นชุด</b></td>
042.</tr>
043.<tr bgcolor="#FFFFCC">
044.<td width="169" align="center">รหัสโปรโมชั่น</td>
045.<td width="320" align="center">ชื่อโปโมชั่น</td>
046.<td width="102" align="center">แก้ไข</td>
047.<td width="109" align="center">ลบ</td>
048.</tr>
049.<?
050.while ($dbarr_product = mysql_fetch_array($result_product)){
051. ?>
052. <tr bgcolor="#F4F4F4">
053. <td align="center"><?=$dbarr_product['pkrenid'];?></td>
054. <td> <?=$dbarr_product['pkrenname'];?></td>
055.
056.
057.<td align="center">[<a href="main.php?menu=2&do=edit&id=<?=$dbarr_product['pkrenid'];?>">แก้ไข</a>]</td>
058.
059.<td align="center">[<a href="main.php?menu=2&do=delete&id=<?=$dbarr_product['pkrenid'];?>">ลบ</a>]</td>
060.</tr>
061.<?
062.}
063. ?>
064. <tr bgcolor="#F4F4F4">
065. <td colspan="4" align="rigth">มีทั้งหมด<?=$total;?>รายการ:
066. <?
067. if ($totalpages>1){
068. for ($i=1;$i<$totalpages;$i++){
069. if($i==$page){
070. echo"<b>หน้า $page</b>";
071. }else{
072. echo"|<a href=\"main.php?manu=2&do=add&page=$i\">$i</a> ";
073. }
074. }
075. }
076. ?>
077. </td>
078. </tr>
079. </table>
080. <form name="frmpackage" method="post" action="main.php?menu=2&do=add&doing=add" enctype="multipart/form-date">
081. <table width="300" border="0" align="center" cellpadding="0" cellspacing="0"
082. bordercolordark="#FFFFFF">
083. <tr>
084. <td bgcolor="FFCCCC" align="center" <b>เพิ่มข้อมูล</b></td>
085. </tr>
086. <tr>
087. <td>
088. <table width="700" border="0" align="center" cellpadding="5" cellspacing="1">
089. <tr bgcolor="#F4F4F4">
090. <td width="50%" align="left">รหัสโปรโมชั่น<input maxLength=3 name=pkrenid value="<?=$total;?>" size="8"></td>
091. <td width="50%" align="left"ประเภทชุด<select name="ref_sectionid">
092. <option value="0">กรุณาเลือกประเภทชุด</option>
093. <?
094. $sql="select*from tbsection";
095. $result= mysql_query($sql);
096. while($darr_product= mysql_fetch_array($reult)){
097. echo"<option value=$dbarr_product[sectionid]>$dbarr_product
098. [sectionname]</option>";
099. }
100. ?>
101. </select>
102. </td>
103. </tr>
104. <tr bgcolor="#F4F4F4">
105. <td colspan="4" align="left">ชื่อโปรโมชั่น<input maxlength="150" name="pkrenname"size="80"></td>
106. </tr>
107. <tr>
108. <td align="left">ราคา/ชุด <input maxlength="50" name="unitprice" size="8">บาท</td>
109. <td align="left">ไฟล์รูปภาพ<input type="file" name="photo"><input type ="hidden"name="MEX_FILE_SIZE" value="1000000"></td>
110. </tr>
111. <tr bgcolor="#F4F4F4">
112. <td align="left">รายละเอียดโดยย่อ<br><textarea name="txtdatetail" cols="40" rows="4"></textarea></td>
113.<td align="left">สิ่งที่นำมาติดต่อ<br><textarea name="remark" cols="40" rows="4"></textarea></td>
114.</tr>
115.<tr bgcolor="#F4F4F4">
116.<td align="left">อัตรานี้รวม<br><textarea name="pkinclude" cols="40" rows="3"></textarea></td>
117.<td align="left">อัตราไม่นี้รวม<br><textarea name="pknotinclude" cols="40" rows="3"></textarea></td>
118.</tr>
119.<tr bgcolor="#F4F4F4">
120.<td colspan="2" align="left"รายระเอียดต่างๆ<br><textarea name="txtAct" cols="100" rows="30"></textarea>
121.</tr>
122.<tr bgcolor="#F4F4F4">
123.<td colspan="6" align="center">
124.<input type="submit" name="submin" value="บันทึก">
125.<input type="reset" name="Reset" value="ล้างข้อมูล">
126.<input name="cid" type="hidden" value="<?=$total;?>">
127.</td>
128.</tr>
129.</table>
130.</td>
131.</tr>
132.</table>
133.</form>
134.<?
135.if ($_REQEST['doing']=="ad"){
136. if(($_REQSET['pkrenid']=="")or ($_REQUEST['pkrenname']=="")or($_REQUEST['ref_sectionid']=="")){
137. echo"<h1>กรุณากรอกข้อมูลให้ครบ</h1>";
138. }else{
139.$pkrenid=$_POST['pkrenid'];
140.$sectionid=$_POST['ref_sectionid'];
141.$pkrenname=$_POST['pkrenname'];
142.$txtdetail=$_POST['txtdetail'];
143.$pkinclude=$_POST['pkinclude'];
144.$pknotinclude=$_POST['pknotinclude'];
145.$remark=$_POST['remark'];
146.$unitprice=number_format($_POST['unitprice'],2,'.','');
147.$txtact=$_POST['txtAct'];
148.
149.$photo=$_FILES['photo']['tmp_name'];
150.$photo_name-$_FILES['photo']['name'];
151.$photo_size=$_FILES['photo']['size'];
152.$photo_type=$_FILES['photo']['type'];
153.
154.if($photo==""){
155. $sql_add="INSERT INTO tbpackren (pkrenid,pkrenname,pkdatetail,unitprice,ref_sectionid,pkinclude,pknotinclude,remark,activity,pkpicren)
156. VALUES ('$pkrenid','$pkrenname','$txtail','$unitprice','$sectionid','$pkinclude','$pknotinclude','$remark',$txtact','');";
157. if($result_add){
158. echo"บันทึกข้อมูลเรียบร้อบแล้ว";
159. echo"<meta http-equiv='refresh' content='1;url=main.php?manu=2&do=add'>";
160. }else{
161. echo"<h1>ไม่สามารถบันทึกข้อมูลได้</h1>";
162. echo"<meat http-equiv='refresh' content='1;url=main.php'>";
163. }
164.}else{
165. $array_last= explode(".",$photo_name);
166. $c=count($array_last)-1;
167. $lastname=strtolower($array_last[$c]);
168. if ($lastname=="gif" or $lastname=="jpg" or lastname=="jpeg"){
169. $set_photo=explode(".",$photo_name);
170. $plname="pk_".$pkrenid;
171. $plname=$set_photo[1];
172. $photoname=$pnname.".".$plnanme;
173. copy ($photo,"..images/package/".$photoname);
174.
175. $sql_add="INSERT INTO tbpackren (pkrenid,pkrenname,pkdetail,unitprice,ref_sectionid,pkinclude,pknotinclude,remark,activity,pkpicren)
176. VALUE ('$pkrenid','$pkrenname','$txtetail','$unitpice','$sectionid','$pkinclude','$pknotinclude','$remark','$txtact','$photoname');";
177. $result_add=mysql_query($sql_add);
178. if($result_add){
179. echo "บันทึกข้อมูลเรียบร้อยแล้ว";
180. echo "<meta http-equiv='refresh' content='1;url=main.php?manu=2&do=add'>";
181. }else{
182. echo"<h1>ไม่สามารถบันทึกข้อมูลได้</h1>";
183. echo"<meta http-equiv='refresh' content='1;url=main.php'>";
184. }
185. }else{
186. echo "<h1>ไม่สามารถบันทึกไฟร์รูปภาพได้(ต้องเป็น .jpg ,.gif เท่านั้น) </h1>";
187. echo "<meta http-equiv='refresh' content-'1;url=main.php'>";
188. }
189. unlink ($photo);
190.}
191. }
192. }
193. ?><?
194.
195. include "CloseDb.php";
196. ?>
