๐Ÿฅํฌ์Šค ๋ฉ”๋‰ด ํด๋ฆญ์‹œ ์ฃผ๋ฌธ ๋„ฃ๊ธฐ

๊ถŒ์žฌํ˜„ยท2021๋…„ 8์›” 2์ผ
0
post-thumbnail

each ํ™œ์šฉ, ๊ฐ’ ๋„ฃ์„ ๋•Œ, ๊ฐ’ ๋ฐ”๋€” ๋•Œ

๋ฉ”๋‰ด ํด๋ฆญ ์‹œ ์ฃผ๋ฌธ์— ๋„ฃ๊ธฐ

์ฃผ๋ฌธ์ƒํ™ฉ์— ๋„ฃ์–ด์ฃผ๋Š” ์ฝ”๋“œ

//ํ˜„์žฌ์ฃผ๋ฌธ ์ƒํ™ฉ์— ๋„ฃ๊ธฐ
	$("body").on("click",".menu_btn",function(){
		console.log(cnt);
		if(cnt < 7){
			
			$("#menuNo").val($(this).attr("mno"));
	//์ฃผ๋ฌธ์ƒํ™ฉ์„ ๊ทธ๋ ค์ฃผ๋Š” ํ•จ์ˆ˜
          reloadOrd();
		
			cnt++;
			
		}else{
			ordPopup("", "๋”์ด์ƒ ํ’ˆ๋ชฉ์ถ”๊ฐ€๋Š” ๋ถˆ๊ฐ€ํ•ฉ๋‹ˆ๋‹ค.",function(){
			});
		}
			
	}); 

.menu_btn์ด ๋ฉ”๋‰ด์ด๋ฆ„์ด ๋“ค์–ด๊ฐ€ ์žˆ๋Š” ๋ฒ„ํŠผ์ด๋‹ค. ๊ทธ๋ž˜์„œ ๊ทธ๊ฒƒ์„ ํด๋ฆญ ์‹œ

form ์•ˆ์— ์žˆ๋Š” #menuNo๋กœ ๋ฉ”๋‰ด ๋ฒˆํ˜ธ๋ฅผ ๋„ฃ์–ด์ค€๋‹ค.

<!-- ์˜ค๋”๋ฉ”๋‰ด -->
	<select id="getMOrd" parameterType="hashmap" resultType="hashmap">
		SELECT  PM.MENU_NO AS MNO, PM.MENU_NAME AS MNAME, PC.CATE_NAME AS CNAME, PM.MENU_PRICE AS MPRICE, PM.MENU_IMG AS MIMG,PC.CATE_NO AS CNO
		FROM POS_MENU PM INNER JOIN POS_CATE PC
	                         ON PM.POS_CATE_NO = PC.CATE_NO
		WHERE PM.MENU_NO = #{menuNo}
	</select>

์œ„์—์„œ ์‚ฌ์šฉํ•œ #menuNo๊ฐ€ xml์—์„œ ํ™œ์šฉ๋œ๋‹ค. ํ’€์–ด์„œ ์„ค๋ช…ํ•ด๋ณด๋ฉด ๋งŒ์•ฝ DB์— ์ €์žฅ๋œ ๋ฉ”๋‰ด๋ฒˆํ˜ธ๊ฐ€ 2๋ฒˆ์ธ ๊ฒƒ์„ ํฌ์Šค์—์„œ ํด๋ฆญ ์‹œ xml์—์„œ๋Š” #{menuNo} ์— 2๊ฐ€ ๋“ค์–ด๊ฐ€๊ฒŒ ๋œ๋‹ค.

 <!-- ์˜ค๋”๋ฉ”๋‰ด -->
	<select id="getMOrd" parameterType="hashmap" resultType="hashmap">
		SELECT  PM.MENU_NO AS MNO, PM.MENU_NAME AS MNAME, PC.CATE_NAME AS CNAME, PM.MENU_PRICE AS MPRICE, PM.MENU_IMG AS MIMG,PC.CATE_NO AS CNO
		FROM POS_MENU PM INNER JOIN POS_CATE PC
	                         ON PM.POS_CATE_NO = PC.CATE_NO
		WHERE PM.MENU_NO = 2
	</select>

์œ„์— ์ฒ˜๋Ÿผ ๋ฒˆํ˜ธ๊ฐ€ ๋“ค์–ด๊ฐ€๊ฒŒ๋˜์„œ ๋ฐ์ดํ„ฐ๊ฐ€ ์ถœ๋ ฅ๋œ๋‹ค.
๊ทธ๋‹ค์Œ DB์—์„œ ๋ฉ”๋‰ด ๋ฒˆํ˜ธ 2๋ฒˆ์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๊บผ๋‚ด์™€์„œ ์ปจํŠธ๋กค๋Ÿฌ์—์„œ ORD ๋ผ๋Š” ํ‚ค ๊ฐ’์œผ๋กœ modelMap์— ๋„ฃ์–ด์ค€๋‹ค.

@RequestMapping(value="/PosOrd",
			method = RequestMethod.POST,
			produces = "text/json;charset=UTF-8")
	@ResponseBody
	public String PosOrd(
		@RequestParam HashMap<String, String> params) throws Throwable{
	ObjectMapper mapper = new ObjectMapper();
	Map<String, Object> modelMap = new HashMap<String, Object>();
	
	System.out.println("์˜ค๋”Params"+params);
	// ์˜ค๋” ์ทจ๋“
	HashMap<String, String>ord= ijhService.getMOrd(params);
	
	modelMap.put("ord", ord);
	
	System.out.println("์˜ค๋” ๋ชฉ๋ก ๋ณด์ž"+ord);
	return mapper.writeValueAsString(modelMap);
		
	}
    ์ปจํŠธ๋กค๋Ÿฌ์—์„œ ord๋กœ ๋ฉ”๋‰ด๋ฒˆํ˜ธ 2๋ฒˆ์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๋ฐ›๋Š”๋‹ค.


๋ฐ›์€ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€์ง€๊ณ  reloadOrd()๋กœ ๋‹ค์‹œ ๊ทธ๋ ค์ค€๋‹ค.

function reloadOrd(){
	var params = $("#ord_form").serialize();
	console.log(params);
	$.ajax({
		url: "PosOrd",
		type: "post",
		dataType: "json",
		data: params,
		success: function(res){
			console.log(res.ord);
			inputOrd(res.ord); //์ฃผ๋ฌธ์„ ๋„ฃ๊ณ  ๊ทธ๋ ค์ฃผ๋Š” ํ•จ์ˆ˜
			
		},
		error: function(request, status, error){
			console.log(error)
		}
	});
}
//ํ˜„์žฌ ์ฃผ๋ฌธ ๋„ฃ๊ธฐ
function inputOrd(ord){
	var order ="";
//MNO๋Š” ๋ฉ”๋‰ด ๋ฒˆํ˜ธ
// MIMG๋Š” ๋ฉ”๋‰ด ์ด๋ฏธ์ง€
// MNAME์€ ๋ฉ”๋‰ด ์ด๋ฆ„
// MPRICE์€ ๋ฉ”๋‰ด ๊ฐ€๊ฒฉ
	order+= 		"<div class=\"ord_stat\">";
	order+= 			"<div class=\"ord_img\" mNo=\""+ ord.MNO +"\">";
	order+= 				"<img src=\"resources/upload/"+ord.MIMG+"\" class=\"choice_img\">";
	order+= 			"</div>";
	order+= 			"<div class=\"ord_div\">";
	order+= 				"<input type=\"text\" value=\""+ ord.MNAME + "\" class=\"choice_menu\">";
	order+= 			"</div>";
	order+= 			"<div class=\"ord_div\">";
	order+= 				"<input type=\"text\" value=\""+ ord.MPRICE + "\" class=\"choice_price\">";
	order+= 			"</div >";
	order+= 			"<div class=\"ord_div\">";
	order+= 				"<select id=\"ord_cnt\" name=\"ord_cnt\">";
	order+= 					"<option value=\"1\" selected=\"selected\">1</option>";
	order+= 					"<option value=\"2\">2</option>";
	order+= 					"<option value=\"3\">3</option>";
	order+= 					"<option value=\"4\">4</option>";
	order+= 					"<option value=\"5\">5</option>";
	order+= 					"<option value=\"6\">6</option>";
	order+= 					"<option value=\"7\">7</option>";
	order+= 					"<option value=\"8\">8</option>";
	order+= 					"<option value=\"9\">9</option>";
	order+= 					"<option value=\"10\">10</option>";
	order+= 				"</select>";
	order+= 			"</div>";
	order+= 			"<div class=\"ord_div\">";
	order+= 				"<input type=\"button\" value=\"์ทจ์†Œ\" class=\"choice_cnl\">";
	order+= 			"</div >";
	order+= 		"</div>";
	
	$(".ord_area").append(order);
	ordRes();
	ord_pay();
}

ord์—์„œ ๋ฐ›์€ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€์ง€๊ณ  ๋ฉ”๋‰ด๋ฅผ ๊ทธ๋ ค์ค€๋‹ค.

๐ŸŒˆ๊ตํ›ˆ : ์˜ค๋Š˜ ํฐ์‚ฐ์„ ๋„˜์€ ๋Š๋‚Œ์ด๋‹ค.

profile
ํ˜ธํ…”๋ฆฌ์–ด ์ถœ์‹  ๋น„์ „๊ณต์ž

0๊ฐœ์˜ ๋Œ“๊ธ€