Technical sharing by programmers
資訊庫元件設定 安裝【Manage Pallette】>>【Nodes】>> node-red-node-mysql 查詢待生產的訂單 msg.topic = “select concat(lastname, firstname) as ‘客戶名稱’, order_id as ‘訂單編號’, total as ‘金額’, date_added as ‘下單日期’ from oc_order where order_status_id =1”; return msg; var msg1 …
訂單狀態加急(Urgent) Opencart 後台設定： 【System】>>【Location】>>【Order Statuses】 資料庫關聯示意圖 訂單狀態值 初始值：Pending 生產中的值：Processing 生產完成的值：Processed 急單的值：Urgent 訂單完成的值：Complete 切換訂單狀態 狀態 值 Pending 1 Processing 2 Complete 5 Processed 15 Urgent 17
Opencart 後台設定： 【Options】 Opencart 後台設定： 【Products】>>【Options】
考題注意事項：蓋印次數 Opencart 後台設定： 【Attributes】 Opencart 後台設定： 【Products】>>【Attribute】
Install Certbot on Ubuntu Host
current in process record the version will be update += 1, so when in the same time another one do same thing will updated_rows == 0.
when select task by id, the database lock the record. if other one to do same time the second one will get the “Task is already claimed or completed” We …
^: indicating the begin $: indicateing the last [0-9]{4}: 4 characters and each character is 0~9. (?P<by_date>…….), will pass the value as by_date parameter to the view. r preceding the …