MTP2.0_New
/
MTP20_IF


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
							/**
* @Author: zou.yingbin
* @Create  : 2021/1/12 10:38
* @Modify  : 2021/1/12 10:38
 */

package models

import (
	"fmt"
	"mtp2_if/db"
	"mtp2_if/logger"
)

//现货合同操作数据
type ErmcpOPApplyModel struct {
	OPERATEAPPLYID   string `json:"OPERATEAPPLYID"  xorm:"'OPERATEAPPLYID'"`     //操作申请ID(603+Unix秒时间戳(10位)+xxxxxx)
	OPERATEAPPLYTYPE int32  `json:"OPERATEAPPLYTYPE"  xorm:"'OPERATEAPPLYTYPE'"` //操作申请类型 - 1:点价 2:结算登记 3:款项登记 4:发票登记
	RELATEDID        string `json:"RELATEDID"  xorm:"'RELATEDID'"`               //现货合同ID
	DETAILJSON       string `json:"-"  xorm:"'DETAILJSON'"`                      //明细JSON
	APPLYID          string `json:"APPLYID"  xorm:"'APPLYID'"`                   //申请人
	APPLYTIME        string `json:"APPLYTIME"  xorm:"'APPLYTIME'"`               //申请时间
	APPLYSTATUS      int32  `json:"APPLYSTATUS"  xorm:"'APPLYSTATUS'"`           //申请状态 - 1:待审核 2:审核通过 3:审核拒绝 4:处理失败 5:已撤回
	AUDITTIME        string `json:"AUDITTIME"  xorm:"'AUDITTIME'"`               //审核时间
	CONTRACTTYPE     int32  `json:"CONTRACTTYPE"  xorm:"'CONTRACTTYPE'"`         //现货合同类型 - 1:采购 -1:销售
	CONTRACTNO       string `json:"CONTRACTNO"  xorm:"'CONTRACTNO'"`             //合同编号
	PRICETYPE        int32  `json:"PRICETYPE"  xorm:"'PRICETYPE'"`               //定价类型 - 1:一口价 2:点价 3:暂定价
	PRICEMOVE        float64`json:"PRICEMOVE"  xorm:"'PRICEMOVE'"`               //升贴水
	GOODSNAME        string `json:"GOODSNAME"  xorm:"'GOODSNAME'"`               //商品名称
	GOODSCODE        string `json:"GOODSCODE"  xorm:"'GOODSCODE'"`               //点价合约
	EnumdicName      string `json:"EnumdicName"  xorm:"'ENUMDICNAME'"`           //单位名称
	BUYUSERNAME      string `json:"BUYUSERNAME"  xorm:"'BUYUSERNAME'"`           //采购方名称
	SELLUSERNAME     string `json:"SELLUSERNAME"  xorm:"'SELLUSERNAME'"`         //销售方名字
	APPLYNAME        string `json:"APPLYNAME"  xorm:"'APPLYNAME'"`               //申请人名称
}

func (r *ErmcpOPApplyModel) buildSql(opType int32) string {
	sqlId := "select to_char(t.OPERATEAPPLYID) OPERATEAPPLYID," +
		"       t.OPERATEAPPLYTYPE," +
		"       to_char(t.RELATEDID) RELATEDID," +
		"       t.DETAILJSON," +
		"       to_char(t.APPLYID) APPLYID," +
		"       to_char(t.APPLYTIME,'yyyy-mm-dd hh:mi') APPLYTIME," +
		"       t.APPLYSTATUS," +
		"       to_char(t.AUDITTIME,'yyyy-mm-dd hh:mi') AUDITTIME," +
		"       t.CONTRACTTYPE," +
		"       s.CONTRACTNO," +
		"       s.PRICETYPE," +
		"       s.pricemove,"+
		"       g.GOODSNAME," +
		"       g.GOODSCODE," +
		"       e.EnumdicName," +
		"       m.username APPLYName," +
		"       u1.accountname buyuserName," +
		"       u2.accountname selluserName" +
		"  from ermcp_contractoperateapply t" +
		"  left join ermcp_spotcontract s" +
		"    on t.relatedid = s.spotcontractid" +
		"  left join goods g" +
		"    on s.goodsid = g.goodsid" +
		"  left join loginaccount l on t.applyid=l.loginid" +
		"  left join systemmanager m on m.logincode=l.logincode" +
		"  left join useraccount u1 on s.buyuserid=u1.userid" +
		"  left join useraccount u2 on s.selluserid=u2.userid" +
		"  left join enumdicitem e" +
		"    on e.enumitemname = g.goodunitid" +
		"   and e.enumdiccode = 'goodsunit'" +
		"  where t.operateapplytype = %v"

	return fmt.Sprintf(sqlId, opType)
}

// 从数据库中查询合同操作申请相关信息, opType 操作申请类型 - 1:点价 2:结算登记 3:款项登记 4:发票登记
func (r *ErmcpOPApplyModel) GetData(opType int32) ([]ErmcpOPApplyModel, error) {
	sData := make([]ErmcpOPApplyModel, 0)
	e := db.GetEngine()
	s := e.SQL(r.buildSql(opType))
	if err := s.Find(&sData); err != nil {
		logger.GetLogger().Errorf("ermcp query fail:%v", err)
		return sData, err
	}
	return sData, nil
}