[invoice :]
stdClass Object
(
[invoice_id] => 55
[created_at] => 2024-10-18 17:33:11
[sn] => 2
[table_no] => 0
[user_id] => 25
[sum] => 325
[note] =>
[is_finished] => 1
[updated_at] => 0000-00-00 00:00:00
[nick_name] => 黃榮清
[role] => admin
[phone] =>
[g_note] =>
)
SELECT count(*) as 'count' FROM `invoice`
where (`user_id` = '25') and ('invoice_id'<=55)
;
new常客:
44
原先
Array
(
[0] => stdClass Object
(
[title] => 臭豆腐(大)
[price] => 80
[amount] => 1
[option] => null
)
[1] => stdClass Object
(
[title] => 米粉湯
[price] => 30
[amount] => 1
[option] => null
)
[2] => stdClass Object
(
[title] => 涼麵(大)
[price] => 50
[amount] => 2
[option] => null
)
[3] => stdClass Object
(
[title] => 烏梅汁
[price] => 30
[amount] => 1
[option] => null
)
[4] => stdClass Object
(
[title] => 豆干
[price] => 10
[amount] => 1
[option] => null
)
[5] => stdClass Object
(
[title] => 海帶
[price] => 15
[amount] => 1
[option] => null
)
[6] => stdClass Object
(
[title] => 無骨鹹酥雞
[price] => 60
[amount] => 1
[option] => null
)
)
==>k:0
==>k:1
==>k:2
==>k:3
==>k:4
==>k:5
==>k:6
調整後
Array
(
[0] => stdClass Object
(
[title] => 臭豆腐(大)
[price] => 80
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[1] => stdClass Object
(
[title] => 米粉湯
[price] => 30
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[2] => stdClass Object
(
[title] => 涼麵(大)
[price] => 50
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[3] => stdClass Object
(
[title] => 涼麵(大)
[price] => 50
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 1
)
[4] => stdClass Object
(
[title] => 烏梅汁
[price] => 30
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[5] => stdClass Object
(
[title] => 豆干
[price] => 10
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[6] => stdClass Object
(
[title] => 海帶
[price] => 15
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[7] => stdClass Object
(
[title] => 無骨鹹酥雞
[price] => 60
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
)
============
stdClass Object
(
[invoice_id] => 55
[created_at] => 2024-10-18 17:33:11
[sn] => 2
[table_no] => 0
[user_id] => 25
[sum] => 325
[note] =>
[is_finished] => 1
[updated_at] => 0000-00-00 00:00:00
[nick_name] => 黃榮清
[role] => admin
[phone] =>
[g_note] =>
)
============
Array
(
[0] => stdClass Object
(
[title] => 臭豆腐(大)
[price] => 80
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[1] => stdClass Object
(
[title] => 米粉湯
[price] => 30
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[2] => stdClass Object
(
[title] => 涼麵(大)
[price] => 50
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[3] => stdClass Object
(
[title] => 涼麵(大)
[price] => 50
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 1
)
[4] => stdClass Object
(
[title] => 烏梅汁
[price] => 30
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[5] => stdClass Object
(
[title] => 豆干
[price] => 10
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[6] => stdClass Object
(
[title] => 海帶
[price] => 15
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
[7] => stdClass Object
(
[title] => 無骨鹹酥雞
[price] => 60
[amount] => 1
[option] => null
[jimmy] => me
[multi] => 0
)
)
============
'==印表機設定==
ESC @
ESC M 0
'== invoice 表頭 ==
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 12 16 0
"桌號 "
' <==[GS ! 0x11] 設定字符大小 [大字] ==>
GS ! 0x11
' <== [GS B 1/0] 設置/解除反白打印模式 ==>
' <== [HT] 水平制表 相當於 tab ==>
' <== [ESC E 1/0] 設置/解除粗體打印 ==>
GS B 1 " 外帶 " GS B 0 HT ESC E 1 " 0002" ESC E 0 HT
' <== [GS ! 0x0] 設定字符大小 [小字] ==>
GS ! 0x0
' <== [ESC J n] 打印並進紙 n 點 ==>
' <== 往下位移 75 單位 ==>
ESC J 75
CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 18 25 0
"10-18 17:33 " HT " 金額:$325 "CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
ESC D 18 0
"管理員 : 黃榮清" CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
GS ! 0x11
"【 共 8 件商品 】"CR LF\n
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"1."
GS ! 0x11
"臭豆腐(大)"
HT "80" ESC J 15
CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"2."
GS ! 0x11
"米粉湯"
HT "30" ESC J 15
CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"3."
GS ! 0x11
"涼麵(大)"
HT "50" ESC J 15
CR LF
'==增加橫線 hr ==
GS ! 0x0 " " CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"4."
GS ! 0x11
"涼麵(大)"
HT "50" ESC J 15
CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"5."
GS ! 0x11
"烏梅汁"
HT "30" ESC J 15
CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"6."
GS ! 0x11
"豆干"
HT "10" ESC J 15
CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"7."
GS ! 0x11
"海帶"
HT "15" ESC J 15
CR LF
'==增加橫線 hr ==
GS ! 0x0 "----------------------------------" CR LF
' <== [ESC D t1 t2 ]設置水平制表位置 共 34 字 ==>
ESC D 27 28 29 30 0
GS ! 0x0
"8."
GS ! 0x11
"無骨鹹酥雞"
HT "60" ESC J 15
CR LF
'==空行 / 裁紙 ==
'往下位移 100 單位
ESC J 250 CR LF
GS V 49
============
{"invoice":{"invoice_id":"55","created_at":"2024-10-18 17:33:11","sn":"2","table_no":"0","user_id":"25","sum":"325","note":null,"is_finished":"1","updated_at":"0000-00-00 00:00:00","nick_name":"\u9ec3\u69ae\u6e05","role":"admin","phone":"","g_note":null},"menus":[{"title":"\u81ed\u8c46\u8150(\u5927)","price":"80","amount":1,"option":"null","jimmy":"me","multi":0},{"title":"\u7c73\u7c89\u6e6f","price":"30","amount":1,"option":"null","jimmy":"me","multi":0},{"title":"\u6dbc\u9eb5(\u5927)","price":"50","amount":1,"option":"null","jimmy":"me","multi":0},{"title":"\u6dbc\u9eb5(\u5927)","price":"50","amount":1,"option":"null","jimmy":"me","multi":1},{"title":"\u70cf\u6885\u6c41","price":"30","amount":1,"option":"null","jimmy":"me","multi":0},{"title":"\u8c46\u5e72","price":"10","amount":1,"option":"null","jimmy":"me","multi":0},{"title":"\u6d77\u5e36","price":"15","amount":1,"option":"null","jimmy":"me","multi":0},{"title":"\u7121\u9aa8\u9e79\u9165\u96de","price":"60","amount":1,"option":"null","jimmy":"me","multi":0}],"escpos":"'==\u5370\u8868\u6a5f\u8a2d\u5b9a==\nESC @ \nESC M 0\n'== invoice \u8868\u982d ==\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 12 16 0 \n\"\u684c\u865f \" \n' <==[GS ! 0x11] \u8a2d\u5b9a\u5b57\u7b26\u5927\u5c0f [\u5927\u5b57] ==>\nGS ! 0x11 \n' <== [GS B 1\/0] \u8a2d\u7f6e\/\u89e3\u9664\u53cd\u767d\u6253\u5370\u6a21\u5f0f ==>\n' <== [HT] \u6c34\u5e73\u5236\u8868 \u76f8\u7576\u65bc tab ==>\n' <== [ESC E 1\/0] \u8a2d\u7f6e\/\u89e3\u9664\u7c97\u9ad4\u6253\u5370 ==>\n GS B 1 \" \u5916\u5e36 \" GS B 0 HT ESC E 1 \" 0002\" ESC E 0 HT \n' <== [GS ! 0x0] \u8a2d\u5b9a\u5b57\u7b26\u5927\u5c0f [\u5c0f\u5b57] ==>\nGS ! 0x0 \n' <== [ESC J n] \u6253\u5370\u4e26\u9032\u7d19 n \u9ede ==>\n' <== \u5f80\u4e0b\u4f4d\u79fb 75 \u55ae\u4f4d ==> \nESC J 75 \nCR LF \n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 18 25 0\n\"10-18 17:33 \" HT \" \u91d1\u984d:$325 \"CR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\nESC D 18 0 \n\"\u7ba1\u7406\u54e1 : \u9ec3\u69ae\u6e05\" CR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\nGS ! 0x11 \n\"\u3010 \u5171 8 \u4ef6\u5546\u54c1 \u3011\"CR LF\\n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"1.\" \nGS ! 0x11 \n\"\u81ed\u8c46\u8150(\u5927)\" \n HT \"80\" ESC J 15 \nCR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"2.\" \nGS ! 0x11 \n\"\u7c73\u7c89\u6e6f\" \n HT \"30\" ESC J 15 \nCR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"3.\" \nGS ! 0x11 \n\"\u6dbc\u9eb5(\u5927)\" \n HT \"50\" ESC J 15 \nCR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \" \" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"4.\" \nGS ! 0x11 \n\"\u6dbc\u9eb5(\u5927)\" \n HT \"50\" ESC J 15 \nCR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"5.\" \nGS ! 0x11 \n\"\u70cf\u6885\u6c41\" \n HT \"30\" ESC J 15 \nCR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"6.\" \nGS ! 0x11 \n\"\u8c46\u5e72\" \n HT \"10\" ESC J 15 \nCR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"7.\" \nGS ! 0x11 \n\"\u6d77\u5e36\" \n HT \"15\" ESC J 15 \nCR LF \n\n'==\u589e\u52a0\u6a6b\u7dda hr ==\n GS ! 0x0 \"----------------------------------\" CR LF\n' <== [ESC D t1 t2 ]\u8a2d\u7f6e\u6c34\u5e73\u5236\u8868\u4f4d\u7f6e \u5171 34 \u5b57 ==> \nESC D 27 28 29 30 0\nGS ! 0x0 \n\"8.\" \nGS ! 0x11 \n\"\u7121\u9aa8\u9e79\u9165\u96de\" \n HT \"60\" ESC J 15 \nCR LF \n'==\u7a7a\u884c \/ \u88c1\u7d19 ==\n'\u5f80\u4e0b\u4f4d\u79fb 100 \u55ae\u4f4d \nESC J 250 CR LF\nGS V 49 \n","say":"\u5916\u5e36\u9ede\u9910 0002 \u865f"}