PageRenderTime 56ms CodeModel.GetById 26ms RepoModel.GetById 0ms app.codeStats 0ms

/pc/_menu_stock/stock1.php

https://gitlab.com/cigiko/brdnc.cafe24.com
PHP | 246 lines | 231 code | 14 blank | 1 comment | 25 complexity | b1e91be5a526ee4faa79d2359a3acf93 MD5 | raw file
    

  1. 					<!--------------------------------------------------subject table end---------------------------------------------------->
    2. 

  2. 					<table width="100%" border="0" cellspacing="0" cellpadding="0">
    3. 

  3. 					<tr height="30">
    4. 

  4. 						<td class="d3_sub" bgcolor="#F8F8F8"><b><font size="2" color="#cc0099">◈</font><font size="2" color="#6666cc"> 재고 현황</font></b></td>
    5. 

  5. 						<td align="right" valign="bottom" class="d3_sub" bgcolor="#F8F8F8"><!-- <font color="red">*</font> 필수 항목은 반드시 입력하시기 바랍니다. -->&nbsp;</td>
    6. 

  6. 					</tr>
    7. 

  7. 					</table>
    8. 

  8. 					<!--------------------------------------------------subject table end---------------------------------------------------->
    9. 

  9. 					<div style="height:570px; padding-top:10px;">
    10. 

  10. 					<?
    11. 

  11. 						$add_where="";
    12. 

  12. 

  13. 							if($classify1||$classify2||$s_date||$e_date||$sh_con||$sh_text||$accounts||$arr){
    14. 

  14. 								 $add_where.="where 1=1";
    15. 

  15. 							}
    16. 

  16. 							if($classify1) $add_where.=" AND category='$classify1' ";
    17. 

  17. 							if($classify2) $add_where.=" AND brand='$classify2' ";
    18. 

  18. 							if($s_date) $add_where.=" AND st_date >='$s_date' ";
    19. 

  19. 							if($e_date) $add_where.=" AND st_date <='$e_date' ";
    20. 

  20. 							if($accounts) $add_where.=" AND accounts='$accounts' ";
    21. 

  21. 

  22. 							if(!$arr||$arr==1){
    23. 

  23. 								 $add_arr=" order	 by st_date desc, seq_num desc";
    24. 

  24. 							} else if($arr==2){
    25. 

  25. 								 $add_arr=" order	 by price_in ";
    26. 

  26. 							} else {
    27. 

  27. 								 $add_arr=" order	 by price_in desc ";
    28. 

  28. 							}
    29. 

  29. 							if($sh_text){
    30. 

  30. 								 if($sh_con==1) $add_where.=" AND (accounts like '%$sh_text%' OR worker like '%$sh_text%' OR	category like '%$sh_text%' OR brand like '%$sh_text%' OR style like '%$sh_text%' OR color like '%$sh_text%' OR comp like '%$sh_text%') ";
    31. 

  31. 								 if($sh_con==2) $add_where.=" AND (category like '%$sh_text%' OR brand like '%$sh_text%') ";
    32. 

  32. 								 if($sh_con==3) $add_where.=" AND style like '%$sh_text%' ";
    33. 

  33. 								 if($sh_con==4) $add_where.=" AND color like '%$sh_text%' ";
    34. 

  34. 								 if($sh_con==5) $add_where.=" AND comp like '%$sh_text%' ";
    35. 

  35. 							}
    36. 

  36. 

  37. 							$total_qty=" SELECT SUM(qty) AS total_qty
    38. 

  38. 											 FROM (SELECT seq_num, category, brand, style, color, comp, price_in, accounts, worker, st_date,
    39. 

  39. 													 ( CASE division WHEN '1' THEN qty ELSE (- qty) END ) AS qty FROM cms_stock_main)
    40. 

  40. 											 AS cms_stock_main $add_where ";
    41. 

  41. 							$aaa=mysql_query($total_qty, $connect);
    42. 

  42. 							$bbb=mysql_fetch_array($aaa);
    43. 

  43. 

  44. 							$total_p_in= " SELECT SUM(qty*price_in) AS total_p_in
    45. 

  45. 												FROM (SELECT seq_num, category, brand, style, color, comp, price_in, accounts, worker, st_date,
    46. 

  46. 													 	( CASE division WHEN '1' THEN qty ELSE (-qty) END ) AS qty
    47. 

  47. 												FROM cms_stock_main) AS cms_stock_main_ $add_where  ";
    48. 

  48. 							$ccc=mysql_query($total_p_in, $connect);
    49. 

  49. 							$ddd=mysql_fetch_array($ccc);
    50. 

  50. 

  51. 							$total_p_set= " SELECT SUM(qty * set_price) AS total_p_set
    52. 

  52. 												 FROM (SELECT seq_num, category, brand, style, color, comp, price_in, set_price, accounts, worker, st_date,
    53. 

  53. 													 	 ( CASE division WHEN '1' THEN qty ELSE (- qty) END ) AS qty
    54. 

  54. 												 FROM cms_stock_main) AS cms_stock_main $add_where  ";
    55. 

  55. 							$eee=mysql_query($total_p_set, $connect);
    56. 

  56. 							$fff=mysql_fetch_array($eee);
    57. 

  57. 					?>
    58. 

  58. 					<table width="100%" border="0" cellpadding="0" cellspacing="0">
    59. 

  59. 					<tr>
    60. 

  60. 						<td align="right" class="form2" style="padding:0 20px 2px 0;" valign="top">
    61. 

  61. 							<a href="excel_stock_list.php?add_where=<?=urlencode($add_where)?>&add_arr=<?=$add_arr?>&total_qty=<?=$bbb[total_qty]?>&total_p_in=<?=$ddd[total_p_in]?>&total_p_set=<?=$fff[total_p_set]?>"><img src="../images/excel_icon.jpg" height="10" border="0"> EXCEL 출력</a><!--  -->
    62. 

  62. 						</td>
    63. 

  63. 					</tr>
    64. 

  64. 					</table>
    65. 

  65. 					<div id="p_img_div" style="position:absolute; left:944px; top:153px; width:163px; border:1px solid #9EACC0; height:134px; z-index:1; display:none;">
    66. 

  66. 					<img id="p_img" src="" width="190" height="190" border="0">
    67. 

  67. 					</div>
    68. 

  68. 

  69. 					<table width="100%" height="60" border="0" cellpadding="0" cellspacing="0">
    70. 

  70. 					<form method="post" name="st_sh_frm" action="<?$_SERVER['PHP_SELF']?>">
    71. 

  71. 					<input type="hidden" name="start" value="1">
    72. 

  72. 					<tr>
    73. 

  73. 						<td width="80" class="form1"bgcolor="#F8F8F8">분 류 별 </td>
    74. 

  74. 						<td class="form2">
    75. 

  75. 							<select name="classify1" style="width:90" onChange="chk_sel(this.value,1);">
    76. 

  76. 								<option value="" <?if(!$classify1) echo "selected";?>> 1차 분류
    77. 

  77. 								<?
    78. 

  78. 									$qry="select * from cms_stock_1st_classify";
    79. 

  79. 									$rlt=mysql_query($qry, $connect);
    80. 

  80. 									for($i=0; $rs=mysql_fetch_array($rlt); $i++){
    81. 

  81. 								?>
    82. 

  82. 										<option value="<?=$rs[classify]?>" <?if($classify1==$rs[classify]) echo "selected";?>> <?=$rs[classify]?>
    83. 

  83. 								<? } ?>
    84. 

  84. 							</select>
    85. 

  85. 							<select name="classify2" style="width:90" onLoad="chk_sel(classify1.value,1);">
    86. 

  86. 								<option value="" <?if(!$classify2) echo "selected";?>> 2차 분류
    87. 

  87. 								<?
    88. 

  88. 									$qry1="select * from cms_stock_2nd_classify where 1st_classify='$classify1' ";
    89. 

  89. 									$rlt1=mysql_query($qry1, $connect);
    90. 

  90. 									for($i=0; $rs1=mysql_fetch_array($rlt1); $i++){
    91. 

  91. 										 if($classify1){
    92. 

  92. 								?>
    93. 

  93. 										<option value="<?=$rs1[classify]?>" <?if($classify2==$rs1[classify]) echo "selected";?>> <?=stripslashes($rs1[classify])?>
    94. 

  94. 								<? }} ?>
    95. 

  95. 							</select>
    96. 

  96. 						<iframe width='0' height='0' name="sel_frame"></iframe>
    97. 

  97. 						</td>
    98. 

  98. 						<td width="80" class="form1"bgcolor="#F8F8F8">입고기간 </td>
    99. 

  99. 						<td class="form2">
    100. 

  100. 						<input type="text" name="s_date" id="s_date" value="<?=$s_date?>" class="inputStyle2" onclick="openCalendar(this)" onmouseover="cngClass(this,'inputStyle22')" onmouseout="cngClass(this,'inputStyle2')"; size="18">
    101. 

  101. 						<a href="javascript:" onclick="openCalendar(document.getElementById('s_date'));"><img src="../images/calendar.jpg" border="0"></a> ~
    102. 

  102. 

  103. 						<input type="text" name="e_date" id="e_date" value="<?=$e_date?>" class="inputStyle2" onclick="openCalendar(this)" onmouseover="cngClass(this,'inputStyle22')" onmouseout="cngClass(this,'inputStyle2')"; size="18">
    104. 

  104. 						<a href="javascript:" onclick="openCalendar(document.getElementById('e_date'));"><img src="../images/calendar.jpg" border="0"></a> &nbsp;&nbsp;
    105. 

  105. 						<a href="javascript:" onclick="today_();" title="오늘">오늘</a> &nbsp;<a href="#" onclick="to_del_();">
    106. 

  106. 						<img src="../img/bt_del.jpg" width="10" height="10" border="0" alt="삭제"><!-- <font color="#993300"><b>x</b> --></font></a>
    107. 

  107. 						</td>
    108. 

  108. 

  109. 						<td width="180" bgcolor="#F8F8F8" rowspan="2" style="padding:0 0 0 20px; border-width: 0 0 1px 1px; border-color:#CFCFCF; border-style: solid;">
    110. 

  110. 							<select name="sh_con">
    111. 

  111. 								<option value="1" <?if($sh_con==1) echo "selected";?>> 통합검색
    112. 

  112. 								<option value="2"<?if($sh_con==2) echo "selected";?>> 분 류 별
    113. 

  113. 								<option value="3"<?if($sh_con==3) echo "selected";?>> 상 품 명
    114. 

  114. 								<option value="4"<?if($sh_con==4) echo "selected";?>> 컬 러
    115. 

  115. 								<option value="5"<?if($sh_con==5) echo "selected";?>> 재 질
    116. 

  116. 							</select><br>
    117. 

  117. 							<input type="text" name="sh_text" value="<?=$sh_text?>" size="30" class="inputStyle2" onmouseover="cngClass(this,'inputStyle22')" onmouseout="cngClass(this,'inputStyle2')"; onClick="this.value='' ">
    118. 

  118. 						</td>
    119. 

  119. 						<td class="form2" rowspan="2"><input type="button" value=" 검 색 " onclick="submit();" class="inputstyle1" style="height='50'; width='110';"></td>
    120. 

  120. 					</tr>
    121. 

  121. 					<tr>
    122. 

  122. 						<td class="form1"bgcolor="#F8F8F8">입고처별 </td>
    123. 

  123. 						<td class="form2">
    124. 

  124. 						<select name="accounts" style="width:185;">
    125. 

  125. 							<option value="" <?if(!$accounts) echo "selected";?>> 전 체
    126. 

  126. 							<?
    127. 

  127. 								$qry1 = "select * from cms_stock_main, cms_accounts where division='1' and cms_stock_main.accounts=cms_accounts.code group by accounts";
    128. 

  128. 								$rlt1 = mysql_query($qry1, $connect);
    129. 

  129. 								while($rs1 = mysql_fetch_array($rlt1)){
    130. 

  130. 							?>
    131. 

  131. 							<option value="<?=$rs1[code]?>" <?if($accounts==$rs1[code]) echo "selected";?>> <?=$rs1[si_name]?>
    132. 

  132. 							<? } ?>
    133. 

  133. 						</select>
    134. 

  134. 						</td>
    135. 

  135. 						<td class="form1"bgcolor="#F8F8F8">정렬방식 </td>
    136. 

  136. 						<td class="form2">
    137. 

  137. 							<input type="radio" name="arr" value="1" <?if(!$arr||$arr=='1') echo "checked";?>> 최근 입고일순 <input type="radio" name="arr" value="2" <?if($arr=='2') echo "checked";?>> 낮은 가격순 <input type="radio" name="arr" value="3" <?if($arr=='3') echo "checked";?>> 높은 가격순
    138. 

  138. 						</td>
    139. 

  139. 					</tr>
    140. 

  140. 					</form>
    141. 

  141. 					</table>
    142. 

  142. 

  143. 					<table width="100%" border="0" cellpadding="0" cellspacing="0">
    144. 

  144. 					<!-- <tr>
    145. 

  145. 						<td class="form2">&nbsp;</td>
    146. 

  146. 					</tr> -->
    147. 

  147. 					</table><p>
    148. 

  148. 

  149. 

  150. 					<table border="0" width="100%" cellspacing="0" cellpadding="0">
    151. 

  151. 						<tr align="center" height="35">
    152. 

  152. 							<td width="30" bgcolor="#EAEAEA" class="tb1">
    153. 

  153. 								<input type="checkbox" name="" disabled>
    154. 

  154. 							</td>
    155. 

  155. 							<td width="100" bgcolor="#EAEAEA" class="tb1">이 미 지</td>
    156. 

  156. 							<td width="100" bgcolor="#EAEAEA" class="tb1">카테고리</td>
    157. 

  157. 							<td width="90" bgcolor="#EAEAEA" class="tb1">브랜드(BRAND)</td>
    158. 

  158. 							<td width="130" bgcolor="#EAEAEA" class="tb1">스타일(STYLE)</td>
    159. 

  159. 							<td width="100" bgcolor="#EAEAEA" class="tb1">컬러(COLOR)</td>
    160. 

  160. 							<td width="152" bgcolor="#EAEAEA" class="tb1">재질(COMP.)</td>
    161. 

  161. 							<td width="60" bgcolor="#EAEAEA" class="tb1">수량(QTY.)</td>
    162. 

  162. 							<td width="100" bgcolor="#EAEAEA" class="tb1">입고 단가</td>
    163. 

  163. 							<td width="100" bgcolor="#EAEAEA" class="tb1">책정 단가</td>
    164. 

  164. 							<td width="100" bgcolor="#EAEAEA" class="tb1">입고 일자</td>
    165. 

  165. 						</tr>
    166. 

  166. 						<?
    167. 

  167. 							$query="SELECT seq_num, category, brand, style, color,comp, price_in, accounts, worker, st_date,  SUM(qty) AS st_qty
    168. 

  168. 													FROM (SELECT seq_num, category, brand, style, color, comp, price_in, accounts, worker, st_date,
    169. 

  169. 																				( CASE division WHEN '1' THEN qty ELSE (- qty) END )
    170. 

  170. 													AS qty FROM cms_stock_main) AS cms_stock_main $add_where
    171. 

  171. 													GROUP BY style, color having st_qty>0";
    172. 

  172. 							$result=mysql_query($query, $connect);
    173. 

  173. 							$total_bnum=mysql_num_rows($result);     // 총 게시물 수   11111111111111111111
    174. 

  174. 							mysql_free_result($result);
    175. 

  175. 

  176. 							$page=$_GET['page'];
    177. 

  177. 							$gb=$_REQUEST['gb'];
    178. 

  178. 

  179. 							$index_num = 8;                 // 한 페이지 표시할 목록 개수 22222222222222
    180. 

  180. 							$page_num = 10;								  // 한 페이지에 표시할 페이지 수 33333
    181. 

  181. 							$start=$_REQUEST['start'];
    182. 

  182. 							if(!$start) $start = 1;              // 현재페이지 444444444
    183. 

  183. 							$s = ($start-1)*$index_num;
    184. 

  184. 							$e = $index_num;
    185. 

  185. 

  186. 							$query1="SELECT seq_num, category, brand, style, color,comp, price_in, price_out, set_price, accounts, worker, st_date, SUM(qty) AS st_qty
    187. 

  187. 														FROM (SELECT seq_num, category, brand, style, color,comp, price_in, price_out, set_price, accounts, worker, st_date,
    188. 

  188. 																				( CASE division WHEN '1' THEN qty ELSE (- qty) END )
    189. 

  189. 														AS qty FROM cms_stock_main) AS cms_stock_main $add_where
    190. 

  190. 													  GROUP BY style, color having st_qty>0 $add_arr limit $s, $e";
    191. 

  191. 							$result1=mysql_query($query1, $connect);
    192. 

  192. 							if($total_bnum==0){
    193. 

  193. 						?>
    194. 

  194. 						<tr>
    195. 

  195. 							<td align="center" height="38" class="tb2" colspan="11"> 등록 된 데이터가 없습니다. </td>
    196. 

  196. 						</tr>
    197. 

  197. 						<?
    198. 

  198. 							}else{
    199. 

  199. 							for($i=0; $rows1=mysql_fetch_array($result1); $i++){
    200. 

  200. 								 $bunho=$total_bnum-($i+$cline)+1;
    201. 

  201. 						?>
    202. 

  202. 						<tr>
    203. 

  203. 							<td align="center" height="30" class="tb2"><input type="checkbox" name="seq_num[]" value="<?=$rows2[seq_num]?>" disabled></td>
    204. 

  204. 							<td align="center" height="30" class="tb2">
    205. 

  205. 								<img src="p_img/<?=$rows1[style]?>_<?=$rows1[color]?>.jpg" onError="this.src='p_img/no_image.jpg'; " height="28" border="0" alt="" onmouseover="imgOver(this.src)" onmouseout="imgOut(this.src)">
    206. 

  206. 							</td>
    207. 

  207. 							<td height="30" style="padding:0 0 0 10px;border-width: 0 0 1px 0; border-color:#E1E1E1; border-style: solid;"><?=$rows1[category]?>&nbsp;</td>
    208. 

  208. 							<td align="left" height="30" class="tb2"><?=stripslashes($rows1[brand])?>&nbsp;</td>
    209. 

  209. 							<td align="left" height="30" class="tb2"><font color="#3a3a3a"><?=$rows1[style]?></font>&nbsp;</td>
    210. 

  210. 							<td align="left" height="30" class="tb2"><?=$rows1[color]?>&nbsp;</td>
    211. 

  211. 							<td align="left" height="30" class="tb2"><?=$rows1[comp]?>&nbsp;</td>
    212. 

  212. 							<td align="right" height="30" style="padding:0 10px 0 0px;" class="tb2"><?=number_format($rows1[st_qty])?>&nbsp;</td>
    213. 

  213. 							<td align="right" height="30" style="padding:0 10px 0 0px;" class="tb2"><?=number_format($rows1[price_in])?>&nbsp;</td>
    214. 

  214. 							<td align="right" height="30" style="padding:0 10 px0 0px;" class="tb2"><?=number_format($rows1[set_price])?></td>
    215. 

  215. 							<td align="center" height="30" class="tb2"><?=$rows1[st_date]?>&nbsp;</td>
    216. 

  216. 						</tr>
    217. 

  217. 						<?
    218. 

  218. 							 }}
    219. 

  219. 							 mysql_free_result($result1);
    220. 

  220. 						?>
    221. 

  221. 						<tr>
    222. 

  222. 							<td height="32" align="center" colspan="11">
    223. 

  223. 								<?
    224. 

  224. 									$url="message_1.php?gb=1";
    225. 

  225. 									page_avg3($total_bnum,$page_num, $index_num,$start);
    226. 

  226. 									//1. 총게시물수 2. 한페이지 페이지수 3. 한페이지목록 수 3. 시작페이지
    227. 

  227. 								?>
    228. 

  228. 							</td>
    229. 

  229. 						</tr>
    230. 

  230. 						</table><p>
    231. 

  231. 						<table width="100%" border="0" cellspacing="0" cellpadding="0" bordercolor="#D6D6D6" width="250" style="border-collapse:collapse; border:1px solid #D6D6D6">
    232. 

  232. 						<tr height="35" align="center">
    233. 

  233. 							<?
    234. 

  234. 								if($bbb[total_qty]==0){$total_qty_="-";}else{$total_qty_=number_format($bbb[total_qty])." PCS";}
    235. 

  235. 								if($ddd[total_p_in]==0){$total_p_in_="-";}else{$total_p_in_=number_format($ddd[total_p_in])." 원";}
    236. 

  236. 								if($fff[total_p_set]==0){$total_p_set_="-";}else{$total_p_set_=number_format($fff[total_p_set])." 원";}
    237. 

  237. 							?>
    238. 

  238. 							<td width="8%" bgcolor="#f0f0ff"> TOTAL 수량 </td>
    239. 

  239. 							<td width="12%"><?=$total_qty_?></td>
    240. 

  240. 							<td width="8%" bgcolor="#f0f0ff">입고가 기준 합계</td>
    241. 

  241. 							<td width="12%"><?=$total_p_in_?></td>
    242. 

  242. 							<td width="8%" bgcolor="#f0f0ff">책정가 기준 합계</td>
    243. 

  243. 							<td width="12%"><?=$total_p_set_?></td>
    244. 

  244. 						</tr>
    245. 

  245. 						</table>
    246. 

  246. 						</div>
    247. 

  247.