I’m use phpmaker to record order number for my online store.my Table structure : oder_number (varchar 50); status (enum: ‘new’,‘sent’,‘cancel’) default ‘new’.When I’m get an order, I used barcode scanner to store/add the order number. After packet is ready, then logistic company will came to pick the packet. I want to create custom file/page with a html form for scan again the order number and the status changed to ‘Sent’. The system must can filter only ‘new’ status can process to avoid duplicate packet or cancelled order. if status not ‘new’, it will give me warning.I’m not programmer, can someone help me for create a custom file for store where packet already pickup by logistic. thanksSorry for my bad english
No need to create a Custom file for that. You may simply create some Database Views for that. For example, one Database View for displaying the records with “new” status, and the other for displaying the records which have status other than “new”.Based on those Database Views, then you may simply generate the Edit page with “Modal dialog” option enabled from “Table” setup. No need to display the “status” field. You may hide it from “Page_Load” server event that belongs to the Edit Page. After that, simply put this following code in “Row_Updating” server event that belongs to the Database View which will display the records with “new” status:$rsnew[“status”] = “sent”;
I am still confused, can you explain in more detail
In which part did not you understand?
with $rsnew[“status”] = “sent”;How can it’s prevent us not sent packet with “cancelled status or already sent status.”
Then you need to include that Dropdown control to display it in Edit Page, and no need to use the code I gave you before.