[2025-08-17 21:31:41]
[2025-08-17 21:31:41]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '000037', '2025-08-17', '2025-08-17', '250817212849', '', '', '', '', '', '', '', '','01')[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '치즈(조흥)', '000114', '2.5kg*4ea', '2', '126000', '', '3431', '1' , '2025-08-17 21:31:41'  , 1 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '흑미도우(320g)', '000002', '320g*40ea', '3', '41200', '', '3431', '2' , '2025-08-17 21:31:41'  , 2 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '스트링치즈(레프리노)', '000003', '6.8kg', '1', '80308', '', '3431', '3' , '2025-08-17 21:31:41'  , 3 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '전지베이컨', '000172', '500g*20ea', '3', '6950', '', '3431', '4' , '2025-08-17 21:31:41'  , 4 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '자숙새우', '000020', '500g*10ea', '2', '10300', '', '3431', '5' , '2025-08-17 21:31:41'  , 5 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '치킨텐더(태국산)', '000025', '1kg*10ea', '1', '10950', '', '3431', '6' , '2025-08-17 21:31:41'  , 6 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '고르곤졸라(냉동,500g)', '000160', '500g*20봉', '1', '15000', '', '3431', '7' , '2025-08-17 21:31:41'  , 7 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '블랙올리브슬라이스', '000230', '405g*24ea', '4', '1750', '', '3431', '8' , '2025-08-17 21:31:41'  , 8 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '오이피클(국내산)', '000131', '80g*175ea', '1', '47425', '', '3431', '9' , '2025-08-17 21:31:41'  , 9 )[2025-08-17 21:31:41]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '박스13\"', '000089', '100ea/box', '1', '37000', '', '3431', '10' , '2025-08-17 21:31:41'  , 10 )[2025-08-17 21:32:21]
[2025-08-17 21:32:21]
UPDATE ordbook_m SET orddate = '2025-08-17', deldate = '2025-08-17', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = '01'  WHERE ordno = '3431' [2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '치즈(조흥)', pcode = '000114', pnorm = '2.5kg*4ea', ordqnt = '2', price = '126000', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '1'  WHERE ordno = '3431' AND seq = '1'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '흑미도우(320g)', pcode = '000002', pnorm = '320g*40ea', ordqnt = '3', price = '41200', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '2'  WHERE ordno = '3431' AND seq = '2'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '스트링치즈(레프리노)', pcode = '000003', pnorm = '6.8kg', ordqnt = '1', price = '80308', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '3'  WHERE ordno = '3431' AND seq = '3'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '전지베이컨', pcode = '000172', pnorm = '500g*20ea', ordqnt = '3', price = '6950', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '4'  WHERE ordno = '3431' AND seq = '4'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '자숙새우', pcode = '000020', pnorm = '500g*10ea', ordqnt = '2', price = '10300', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '5'  WHERE ordno = '3431' AND seq = '5'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '치킨텐더(태국산)', pcode = '000025', pnorm = '1kg*10ea', ordqnt = '1', price = '10950', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '6'  WHERE ordno = '3431' AND seq = '6'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '고르곤졸라(냉동,500g)', pcode = '000160', pnorm = '500g*20봉', ordqnt = '1', price = '15000', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '7'  WHERE ordno = '3431' AND seq = '7'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '블랙올리브슬라이스', pcode = '000230', pnorm = '405g*24ea', ordqnt = '4', price = '1750', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '8'  WHERE ordno = '3431' AND seq = '8'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '오이피클(국내산)', pcode = '000131', pnorm = '80g*175ea', ordqnt = '1', price = '47425', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '9'  WHERE ordno = '3431' AND seq = '9'[2025-08-17 21:32:21]
UPDATE ordbook_d SET pname = '박스13\"', pcode = '000089', pnorm = '100ea/box', ordqnt = '1', price = '37000', bigo = '' , lastmodify = '2025-08-17 21:32:21'  , parentseq = '10'  WHERE ordno = '3431' AND seq = '10'[2025-08-17 22:47:01]
[2025-08-17 22:47:01]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '000049', '2025-08-17', '2025-08-17', '250817224123', '', '', '', '', '', '', '', '','01')[2025-08-17 22:47:01]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '흑미도우(240g)', '000001', '240g*54ea', '1', '50760', '', '3432', '1' , '2025-08-17 22:47:01'  , 1 )[2025-08-17 22:47:01]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '치킨스틱(태국산)', '000023', '1kg*10ea', '2', '12000', '', '3432', '2' , '2025-08-17 22:47:01'  , 2 )[2025-08-17 22:47:01]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '마요네즈', '000040', '1kg*10ea', '3', '4400', '', '3432', '3' , '2025-08-17 22:47:01'  , 3 )[2025-08-17 22:47:01]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '음료1구캐리어', '000054', '200ea*50봉', '3', '7800', '', '3432', '4' , '2025-08-17 22:47:01'  , 4 )[2025-08-17 22:47:01]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '새송이', '000065', '2kg*5ea', '1', '5500', '', '3432', '5' , '2025-08-17 22:47:01'  , 5 )[2025-08-17 22:47:01]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '크림소스(파스타용)', '000088', '1kg*10ea', '2', '5500', '', '3432', '6' , '2025-08-17 22:47:01'  , 6 )[2025-08-17 22:47:01]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '박스13\"', '000089', '100ea/box', '1', '37000', '', '3432', '7' , '2025-08-17 22:47:01'  , 7 )[2025-08-17 22:47:22]
DELETE FROM ordbook_d WHERE ordno = \'3432\' AND seq= \'3\'[2025-08-17 22:48:08]
DELETE FROM ordbook_d WHERE ordno = \'3432\' AND seq= \'2\'[2025-08-17 22:48:40]
[2025-08-17 22:48:40]
UPDATE ordbook_m SET orddate = '2025-08-17', deldate = '2025-08-17', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = '01'  WHERE ordno = '3432' [2025-08-17 22:48:40]
UPDATE ordbook_d SET pname = '흑미도우(240g)', pcode = '000001', pnorm = '240g*54ea', ordqnt = '1', price = '50760', bigo = '' , lastmodify = '2025-08-17 22:48:40'  , parentseq = '1'  WHERE ordno = '3432' AND seq = '1'[2025-08-17 22:48:40]
UPDATE ordbook_d SET pname = '음료1구캐리어', pcode = '000054', pnorm = '200ea*50봉', ordqnt = '3', price = '7800', bigo = '' , lastmodify = '2025-08-17 22:48:40'  , parentseq = '4'  WHERE ordno = '3432' AND seq = '4'[2025-08-17 22:48:40]
UPDATE ordbook_d SET pname = '새송이', pcode = '000065', pnorm = '2kg*5ea', ordqnt = '1', price = '5500', bigo = '' , lastmodify = '2025-08-17 22:48:40'  , parentseq = '5'  WHERE ordno = '3432' AND seq = '5'[2025-08-17 22:48:40]
UPDATE ordbook_d SET pname = '크림소스(파스타용)', pcode = '000088', pnorm = '1kg*10ea', ordqnt = '2', price = '5500', bigo = '' , lastmodify = '2025-08-17 22:48:40'  , parentseq = '6'  WHERE ordno = '3432' AND seq = '6'[2025-08-17 22:48:40]
UPDATE ordbook_d SET pname = '박스13\"', pcode = '000089', pnorm = '100ea/box', ordqnt = '1', price = '37000', bigo = '' , lastmodify = '2025-08-17 22:48:40'  , parentseq = '7'  WHERE ordno = '3432' AND seq = '7'[2025-08-17 22:48:40]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '치킨텐더(태국산)', '000025', '1kg*10ea', '2', '10950', '', '3432', '8' , '2025-08-17 22:48:40'  , 8 )[2025-08-17 22:50:05]
[2025-08-17 22:50:05]
UPDATE ordbook_m SET orddate = '2025-08-17', deldate = '2025-08-17', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = '01'  WHERE ordno = '3432' [2025-08-17 22:50:05]
UPDATE ordbook_d SET pname = '흑미도우(240g)', pcode = '000001', pnorm = '240g*54ea', ordqnt = '1', price = '50760', bigo = '' , lastmodify = '2025-08-17 22:50:05'  , parentseq = '1'  WHERE ordno = '3432' AND seq = '1'[2025-08-17 22:50:05]
UPDATE ordbook_d SET pname = '음료1구캐리어', pcode = '000054', pnorm = '200ea*50봉', ordqnt = '3', price = '7800', bigo = '' , lastmodify = '2025-08-17 22:50:05'  , parentseq = '4'  WHERE ordno = '3432' AND seq = '4'[2025-08-17 22:50:05]
UPDATE ordbook_d SET pname = '새송이', pcode = '000065', pnorm = '2kg*5ea', ordqnt = '1', price = '5500', bigo = '' , lastmodify = '2025-08-17 22:50:05'  , parentseq = '5'  WHERE ordno = '3432' AND seq = '5'[2025-08-17 22:50:05]
UPDATE ordbook_d SET pname = '크림소스(파스타용)', pcode = '000088', pnorm = '1kg*10ea', ordqnt = '2', price = '5500', bigo = '' , lastmodify = '2025-08-17 22:50:05'  , parentseq = '6'  WHERE ordno = '3432' AND seq = '6'[2025-08-17 22:50:05]
UPDATE ordbook_d SET pname = '박스13\"', pcode = '000089', pnorm = '100ea/box', ordqnt = '1', price = '37000', bigo = '' , lastmodify = '2025-08-17 22:50:05'  , parentseq = '7'  WHERE ordno = '3432' AND seq = '7'[2025-08-17 22:50:05]
UPDATE ordbook_d SET pname = '치킨텐더(태국산)', pcode = '000025', pnorm = '1kg*10ea', ordqnt = '2', price = '10950', bigo = '' , lastmodify = '2025-08-17 22:50:05'  , parentseq = '8'  WHERE ordno = '3432' AND seq = '8'[2025-08-17 22:50:05]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '마요네즈', '000040', '1kg*10ea', '3', '4400', '', '3432', '9' , '2025-08-17 22:50:05'  , 9 )