Can somebody help me to sort this?
I am using WP 3.5.2 and I have "Orders" post type where purchase_order custom field is located.
This is the sample of purchase order record:
PO - is prefix that is always the same
CO - first 2 letters of the site name - if site name is "Coca Cola" - CO will appear (if I change the name of the site, this will change too)
S - always the same
2013 - current year
0051 - number that increase by 1 when hit Add New Order. Must have 4 characters. If number is 1 then 0001 will appear.
I need this as a hook that will auto generate and auto populate my purchase_order custom filed. PO number must be generated as a unique record.
Function has to count "published and drafted" Order post types and then to increase that number by one, so last part of PO number can be generated (0051).
For the reference, please take a look how this guy solved something similar http://www.codeproject.com/Articles/491733/Auto-generated-sequence-number-in-SQL-Server