| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- /**
- * @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 {
- USERID int64 `json:"userid" xorm:"'USERID'"` //用户ID
- 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'"` //申请人名称
- AUDITNAME string `json:"auditname" xorm:"'AUDITNAME'"` //审核人名称
- }
- 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:ss') APPLYTIME," +
- " t.APPLYSTATUS," +
- " to_char(t.AUDITTIME,'yyyy-mm-dd hh:mi:ss') AUDITTIME," +
- " t.CONTRACTTYPE," +
- " s.CONTRACTNO," +
- " s.PRICETYPE," +
- " s.pricemove," +
- " g.GOODSNAME," +
- " g.GOODSCODE," +
- " e.EnumdicName," +
- " m.username APPLYName," +
- " m2.username auditName," +
- " 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 loginaccount l2 on t.auditid=l2.loginid" +
- " left join systemmanager m2 on m2.logincode=l2.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 and s.userid=%v"
- if len(r.RELATEDID) > 0{
- sqlId = sqlId + " and t.relatedid=" + r.RELATEDID
- }
- return fmt.Sprintf(sqlId, opType, r.USERID)
- }
- // 从数据库中查询合同操作申请相关信息, 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
- }
|
