scj/apps/supplier/resources.py

# -*- coding: utf-8 -*-
from __future__ import absolute_import

from import_export import resources
from import_export.fields import Field
from apps.base import ExcelImporter


class SupplierResource(resources.Resource):

    def __init__(self):
        super(SupplierResource, self).__init__()
        self.fields['name'] = Field(attribute='name')
        self.fields['type_text'] = Field(attribute='type_text')
        self.fields['contacts'] = Field(attribute='contacts')
        self.fields['phone_number'] = Field(attribute='phone_number')
        self.fields['address'] = Field(attribute='address')
        self.fields['opening_bank'] = Field(attribute='opening_bank')
        self.fields['account'] = Field(attribute='account')
        self.fields['tax_number'] = Field(attribute='tax_number')
        self.fields['credit_code'] = Field(attribute='credit_code')
        self.fields['enabled_text'] = Field(attribute='enabled_text')
        self.fields['notes'] = Field(attribute='notes')

    def get_export_headers(self):
        return [u'名称', u'类别',  u'联系人', u'电话', u'地址', u'开户行', u'账号', u'税号', u'信用代码', u'可用', u'备注']

    class Meta:
        export_order = ('name', 'type_text', 'contacts', 'phone_number', 'address', 'opening_bank', 'account', 'tax_number', 'credit_code', 'enabled_text', 'notes')



class SupplierImporter(ExcelImporter):
    fields = {
        u'名称': (True, ExcelImporter.formatUnicode),
        u'类别': (True, ExcelImporter.formatUnicode),
        u'联系人': (False, ExcelImporter.formatUnicode),
        u'电话': (False, ExcelImporter.formatTel),
        u'地址': (False, ExcelImporter.formatUnicode),
        u'开户行': (False, ExcelImporter.formatUnicode),
        u'账号': (False, ExcelImporter.formatUnicode),
        u'信用代码': (False, ExcelImporter.formatUnicode),
        u'税号': (False, ExcelImporter.formatUnicode),
        u'备注': (False, ExcelImporter.formatUnicode),
    }