คู่มือ Naming Series ใน Frappe ฉบับสมบูรณ์ — Custom Variables, Document Naming Rules และ Buddhist Era

DYY.-02-.#####     → parts: ["DYY", "-02-", "#####"]
                   → "26" + "-02-" + "00001" = "26-02-00001"

TS.DYY.DMM.####   → parts: ["TS", "DYY", "DMM", "####"]
                   → "TS" + "26" + "02" + "0001" = "TS26020001"

XS.BEYY./.####    → parts: ["XS", "BEYY", "/", "####"]
                   → "XS" + "69" + "/" + "0001" = "XS69/0001"

# overrides/naming.py
from datetime import datetime
 
def parse_buddhist_year(doc, pattern):
    """BEYY → ปี พ.ศ. 2 หลักจากวันที่ปัจจุบัน
    2026 CE → 2569 BE → '69'"""
    be_year = datetime.now().year + 543
    return str(be_year)[-2:]
 
def parse_document_buddhist_year(doc, pattern):
    """DBEYY → ปี พ.ศ. 2 หลักจากวันที่บนเอกสาร
    2026 CE → 2569 BE → '69'"""
    if not doc:
        # Preview mode (หน้า Document Naming Settings)
        be_year = datetime.now().year + 543
        return str(be_year)[-2:]
 
    doc_date = get_document_date(doc)
    if not doc_date:
        be_year = datetime.now().year + 543
        return str(be_year)[-2:]
 
    be_year = doc_date.year + 543
    return str(be_year)[-2:]

DEPARTMENT_CODES = {
    "Safety - COMP": "01",
    "Production - COMP": "02",
    "IT - COMP": "04",
    "Accounting - COMP": "20",
}
 
for dept_name, dept_code in DEPARTMENT_CODES.items():
    _create_naming_rule(
        document_type="Material Request",
        prefix=f"DYY.-{dept_code}-",
        prefix_digits=4,
        priority=10,
        conditions=[{
            "field": "custom_department",
            "condition": "=",
            "value": dept_name,
        }],
    )

import frappe
 
def _create_naming_rule(document_type, prefix, prefix_digits, priority, conditions):
    """สร้าง Document Naming Rule ตัวเดียว"""
    # ข้ามถ้ามีอยู่แล้ว
    existing = frappe.db.get_value(
        "Document Naming Rule",
        {"document_type": document_type, "prefix": prefix, "disabled": 0},
        "name",
    )
    if existing:
        return
 
    doc = frappe.new_doc("Document Naming Rule")
    doc.document_type = document_type
    doc.prefix = prefix
    doc.prefix_digits = prefix_digits
    doc.priority = priority
 
    for cond in conditions:
        doc.append("conditions", {
            "field": cond["field"],
            "condition": cond["condition"],
            "value": cond["value"],
        })
 
    doc.insert(ignore_permissions=True)

# Priority 10: Rule เฉพาะ
_create_naming_rule("Sales Order", "DYY.DMM", 4, priority=10,
    conditions=[{"field": "order_type", "condition": "=", "value": "Sales"}])
 
# Priority 5: Catch-all (ไม่มี conditions)
_create_naming_rule("Sales Order", "TS.DYY.DMM", 4, priority=5,
    conditions=[])

# custom/sales_invoice.py
import frappe
from frappe.utils import cint, getdate, today
from erpnext.accounts.doctype.sales_invoice.sales_invoice import SalesInvoice
 
 
class CustomSalesInvoice(SalesInvoice):
    def autoname(self):
        """
        Custom naming: IV{DBEYY}{6-digit continuous counter}
        ตัวอย่าง: IV69082680 (IV prefix + ปี พ.ศ. 69, counter 082680)
        Counter ต่อเนื่องข้ามปี — ไม่ Reset
        Return Invoice ใช้ naming_series ปกติ
        """
        if self.is_return:
            return super().autoname()
 
        posting_date = getdate(self.get("posting_date") or today())
        be_yy = str(posting_date.year + 543)[-2:]
 
        # Atomic counter ผ่าน tabSeries
        series_key = "MY_APP_SI_COUNTER"
        current = frappe.db.sql(
            "SELECT `current` FROM `tabSeries` WHERE `name`=%s FOR UPDATE",
            series_key,
        )
        if not current:
            frappe.db.sql(
                "INSERT INTO `tabSeries` (`name`, `current`) VALUES (%s, 0)",
                series_key,
            )
            counter = 1
        else:
            counter = cint(current[0][0]) + 1
 
        frappe.db.sql(
            "UPDATE `tabSeries` SET `current`=%s WHERE `name`=%s",
            (counter, series_key),
        )
        self.name = f"IV{be_yy}{counter:06d}"

def _init_counter():
    """กำหนดค่าเริ่มต้น Counter ให้ตรงกับเอกสารที่มีอยู่"""
    series_key = "MY_APP_SI_COUNTER"
    existing = frappe.db.sql(
        "SELECT `current` FROM `tabSeries` WHERE `name`=%s", series_key
    )
    if existing:
        return  # มีค่าอยู่แล้ว
 
    # หาค่า Counter สูงสุดจากเอกสารที่มี
    max_counter = frappe.db.sql("""
        SELECT MAX(CAST(SUBSTRING(name, 3) AS UNSIGNED))
        FROM `tabSales Invoice`
        WHERE name REGEXP '^[0-9]{8,}$'
    """)
 
    initial = int(max_counter[0][0]) if max_counter and max_counter[0][0] else 0
    frappe.db.sql(
        "INSERT INTO `tabSeries` (`name`, `current`) VALUES (%s, %s)",
        (series_key, initial),
    )

PICK_LIST_CUSTOM_FIELDS = {
    "Pick List": [
        {
            "fieldname": "custom_order_type",
            "fieldtype": "Link",
            "label": "Order Type",
            "options": "Sales Order Type",
            "read_only": 1,
            "in_standard_filter": 1,
            "insert_after": "company",
        },
    ],
}

# hooks.py
doc_events = {
    "Pick List": {
        "before_save": "your_app.custom.pick_list.before_save",
    },
}
 
# custom/pick_list.py
import frappe
 
def before_save(doc, method=None):
    """Auto-populate custom_order_type จาก Sales Order ที่เชื่อมโยง"""
    if doc.get("custom_order_type"):
        return
 
    for item in doc.get("locations") or []:
        if item.get("sales_order"):
            order_type = frappe.db.get_value(
                "Sales Order", item.sales_order, "order_type"
            )
            if order_type:
                doc.custom_order_type = order_type
                break

MANAGED_PREFIXES = (
    "DYY.-01-",     # MR dept 01
    "DYY.-02-",     # MR dept 02
    "TS.DYY.DMM",   # SO catch-all
    "XS.DBEYY./",   # Pick List Sample
)
 
def cleanup():
    """ลบ Document Naming Rules ทั้งหมดที่ App นี้สร้าง"""
    all_rules = frappe.get_all(
        "Document Naming Rule",
        filters={"disabled": 0},
        fields=["name", "prefix"],
    )
    deleted = 0
    for rule in all_rules:
        if rule.prefix in MANAGED_PREFIXES:
            frappe.delete_doc("Document Naming Rule", rule.name, force=True)
            deleted += 1
 
    frappe.db.commit()
    print(f"ลบ {deleted} naming rules สำเร็จ")