from django.db import models from ERP_5.utils.base_model import BaseModel # 货币种类 currency_choices = ( ('CNY', '人民币'), ('USD', '美元'), ('EUR', '欧元'), ('JPY', '日元'), ('HKD', '港币') ) # 付款类型 pay_choices = ( ('1', '采购定金'), ('2', '采购货款'), ('3', '欠款还款'), ('4', '其他付款') ) # 付款单的模型类 class PaymentModel(BaseModel): pay_date = models.DateTimeField('付款日期') number_code = models.CharField('单据编号,不让用户填写', max_length=28) discount_money = models.DecimalField('优惠金额(付款优惠),最多精确到小数点后两位', max_digits=10, default=0, decimal_places=2, blank=True, null=True) pay_money = models.DecimalField('合计 付款金额最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) this_money = models.DecimalField('实际 付款金额最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) remark = models.CharField('备注', max_length=512, blank=True, null=True) currency = models.CharField('货币种类', max_length=20, null=True, choices=currency_choices, default='CNY') pay_category = models.CharField('付款类型', max_length=2, null=True, choices=pay_choices, default='1') status = models.CharField('状态,0:未审核,1:已审核', max_length=1, default='0') account = models.ForeignKey('basic_info.SettlementAccountModel', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='结算账户，审核之后不能改') operator_user = models.ForeignKey('erp_system.UserModel', related_name='operator14_pay_list', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='财务操作人员，不能修改') # 增加一个冗余字段 operator_user_name = models.CharField('财务人员的真实姓名', max_length=20, null=True, blank=True) check_user = models.ForeignKey('erp_system.UserModel', related_name='check13_pay_list', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='审核人员，不能修改') # 增加一个冗余字段 check_user_name = models.CharField('审核人员的真实姓名', max_length=20, null=True, blank=True) supplier = models.ForeignKey('basic_info.SupplierModel', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='供应商，审核之后不能改') # 增加一个冗余字段 supplier_name = models.CharField('供应商名称', max_length=30, null=True, blank=True) purchase = models.ForeignKey('purchase_info.PurchaseModel', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='采购订单，审核之后不能改') attachment_list = models.CharField('附件的id列表，字段的值为: 1,2,3,4', max_length=20, null=True, blank=True) class Meta: db_table = 't_payment' verbose_name = '付款单表' verbose_name_plural = verbose_name ordering = ['id'] # 付款单中 付款项目的模型类 class PaymentItemModel(BaseModel): # 冗余字段 storage_code = models.CharField('采购入库单编号,不让用户填写', max_length=28) purchase_storage = models.ForeignKey('warehouse_info.PurchaseStorageModel', related_name='pay_item_list', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='采购入库单') payment = models.ForeignKey('PaymentModel', null=True, blank=True, related_name='item_list', on_delete=models.SET_NULL, verbose_name='付款单，不能改') should_money = models.DecimalField('应该 付款金额(就是采购入库单中需要支付的金额)，最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) this_money = models.DecimalField('本次 付款金额，最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) remark = models.CharField('备注', max_length=512, blank=True, null=True) class Meta: db_table = 't_payment_item' verbose_name = '付款单中的 付款项目表' verbose_name_plural = verbose_name ordering = ['id'] # 收款类型 receipt_choices = ( ('1', '销售定金'), ('2', '销售出库货款'), ('3', '客户还款的收款'), ('4', '其他收款') ) # 收款单的模型类 class ReceiptModel(BaseModel): pay_date = models.DateTimeField('收款日期') number_code = models.CharField('单据编号,不让用户填写', max_length=28) discount_money = models.DecimalField('优惠金额(收款优惠),最多精确到小数点后两位', max_digits=10, default=0, decimal_places=2, blank=True, null=True) receipt_money = models.DecimalField('合计 收款金额最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) this_money = models.DecimalField('实际 收款金额最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) remark = models.CharField('备注', max_length=512, blank=True, null=True) currency = models.CharField('货币种类', max_length=20, null=True, choices=currency_choices, default='CNY') receipt_category = models.CharField('收款类型', max_length=2, null=True, choices=receipt_choices, default='1') status = models.CharField('状态,0:未审核,1:已审核', max_length=1, default='0') account = models.ForeignKey('basic_info.SettlementAccountModel', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='结算账户，审核之后不能改') operator_user = models.ForeignKey('erp_system.UserModel', related_name='operator12_pay_list', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='财务操作人员，不能修改') # 增加一个冗余字段 operator_user_name = models.CharField('财务人员的真实姓名', max_length=20, null=True, blank=True) check_user = models.ForeignKey('erp_system.UserModel', related_name='operator11_pay_list', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='审核人员，不能修改') # 增加一个冗余字段 check_user_name = models.CharField('审核人员的真实姓名', max_length=20, null=True, blank=True) customer = models.ForeignKey('basic_info.CustomerModel', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='客户，审核之后不能改') # 增加一个冗余字段 customer_name = models.CharField('客户名称', max_length=30, null=True, blank=True) sale = models.ForeignKey('sale_info.SaleModel', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='销售订单，审核之后不能改') attachment_list = models.CharField('附件的id列表，字段的值为: 1,2,3,4', max_length=20, null=True, blank=True) class Meta: db_table = 't_receipt' verbose_name = '收款单表' verbose_name_plural = verbose_name ordering = ['id'] # 收款单中 收款项目的模型类 class ReceiptItemModel(BaseModel): # 冗余字段 storage_code = models.CharField('销售出库单编号,不让用户填写', max_length=28) deliver_storage = models.ForeignKey('warehouse_info.SaleDeliverModel', related_name='pay_item_list', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='采购入库单') receipt = models.ForeignKey('ReceiptModel', null=True, blank=True, related_name='item_list', on_delete=models.SET_NULL, verbose_name='收款单，不能改') should_money = models.DecimalField('应该 收款金额(就是采购入库单中需要支收的金额)，最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) this_money = models.DecimalField('本次 收款金额，最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) remark = models.CharField('备注', max_length=512, blank=True, null=True) class Meta: db_table = 't_receipt_item' verbose_name = '收款单中的 收款项目表' verbose_name_plural = verbose_name ordering = ['id'] # 收款单的模型类 # class ReceiptModel(BaseModel): # pay_date = models.DateTimeField('收款日期') # number_code = models.CharField('单据编号,不让用户填写', max_length=28) # discount_money = models.DecimalField('优惠金额(收款优惠),最多精确到小数点后两位', max_digits=10, default=0, decimal_places=2, # blank=True, null=True) # receipt_money = models.DecimalField('合计 收款金额最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) # this_money = models.DecimalField('实际 收款金额最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) # remark = models.CharField('备注', max_length=512, blank=True, null=True) # currency = models.CharField('货币种类', max_length=20, null=True, choices=currency_choices, default='CNY') # pay_category = models.CharField('收款类型', max_length=2, null=True, choices=pay_choices, default='1') # status = models.CharField('状态,0:未审核,1:已审核', max_length=1, default='0') # # account = models.ForeignKey('basic_info.SettlementAccountModel', null=True, blank=True, on_delete=models.SET_NULL, # verbose_name='结算账户，审核之后不能改') # operator_user = models.ForeignKey('erp_system.UserModel', related_name='operator_pay_list', null=True, # blank=True, on_delete=models.SET_NULL, # verbose_name='财务操作人员，不能修改') # # 增加一个冗余字段 # operator_user_name = models.CharField('财务人员的真实姓名', max_length=20, null=True, blank=True) # check_user = models.ForeignKey('erp_system.UserModel', related_name='operator3_pay_list', null=True, blank=True, on_delete=models.SET_NULL, # verbose_name='审核人员，不能修改') # # 增加一个冗余字段 # check_user_name = models.CharField('审核人员的真实姓名', max_length=20, null=True, blank=True) # # customer = models.ForeignKey('basic_info.CustomerModel', null=True, blank=True, on_delete=models.SET_NULL, # verbose_name='客户，审核之后不能改') # # 增加一个冗余字段 # customer_name = models.CharField('客户名称', max_length=30, null=True, blank=True) # sale = models.ForeignKey('purchase_info.SaleModel', null=True, blank=True, on_delete=models.SET_NULL, # verbose_name='销售订单，审核之后不能改') # attachment_list = models.CharField('附件的id列表，字段的值为: 1,2,3,4', max_length=20, null=True, blank=True) # # class Meta: # db_table = 't_receipt' # verbose_name = '收款单表' # verbose_name_plural = verbose_name # ordering = ['id'] # # # # 收款单中 收款项目的模型类 # class ReceiptItemModel(BaseModel): # # 冗余字段 # storage_code = models.CharField('销售出库单编号,不让用户填写', max_length=28) # deliver_storage = models.ForeignKey('warehouse_info.SaleDeliverModel', related_name='pay_item_list', null=True, blank=True, # on_delete=models.SET_NULL, verbose_name='采购入库单') # # receipt = models.ForeignKey('ReceiptModel', null=True, blank=True, related_name='item_list', on_delete=models.SET_NULL, # verbose_name='收款单，不能改') # should_money = models.DecimalField('应该 收款金额(就是采购入库单中需要支收的金额)，最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) # this_money = models.DecimalField('本次 收款金额，最多精确到小数点后两位', max_digits=10, decimal_places=2, default=0) # # remark = models.CharField('备注', max_length=512, blank=True, null=True) # # class Meta: # db_table = 't_receipt_item' # verbose_name = '收款单中的 收款项目表' # verbose_name_plural = verbose_name # ordering = ['id']