lims/src/dashoo.cn/backend/api/controllers/base.go

// Controller基础类，所有Controller会继承此类
package controllers

import (
	"encoding/base64"
	"errors"
	"fmt"
	"reflect"
	"strconv"
	"strings"

	"github.com/astaxie/beego"

	"dashoo.cn/backend/api/business/material"
	"dashoo.cn/backend/api/models"
	"dashoo.cn/business2/userRole"
	"dashoo.cn/utils"
	"dashoo.cn/utils/redis"
)

// Operations about tokens
type BaseController struct {
	beego.Controller
	User *models.UserInfo
}

type ErrorInfo struct {
	Code    int64  `json:"code"`
	Message string `json:"message,omitempty"`
}

type ErrorDataInfo struct {
	Code    int64       `json:"code"`
	Message string      `json:"message,omitempty"`
	Item    interface{} `json:"item,omitempty"` //数据
}
type DataEntryInfo struct {
	Code             int64       `json:"code"`
	Message          string      `json:"message,omitempty"`
	Item             interface{} `json:"item,omitempty"` //数据
	Info             int         `json:"info"`
	CurrentItemCount int64       `json:"currentItemCount,omitempty"` //结果集中的条目数目
	ItemsPerPage     int64       `json:"itemsPerPage,omitempty"`     //每页记录数目
	StartIndex       int64       `json:"startIndex,omitempty"`       //items中第一个条目的索引
	TotalItemsx      int64       `json:"totalItemsx,omitempty"`      //当前集合中可用的总条目数
	PageIndex        int64       `json:"pageIndex,omitempty"`        //条目的当前页索引
	TotalPages       int64       `json:"totalPages,omitempty"`       //当前结果集中的总页数
}

type Request struct {
	Status  int    `json:"status"`
	Id      string `json:"id"`
	Message string `json:"message"`
}

type PageInfo struct {
	CurrentPage int64 `form:"_currentPage"`
	Size        int64 `form:"_size"`
}

type Status struct {
	Status  int    `json:"status"`
	Id      string `json:"id"`
	Message string `json:"message"`
}

type ValidformStruct struct {
	Info   string      `json:"info"`
	Status string      `json:"status"`
	Items  interface{} `json:"items,omitempty"` //数据列表
}

type ALterDataInfo struct {
	MainItem   interface{} `json:"mainitem,omitempty"`   //数据
	CerItem    interface{} `json:"ceritem,omitempty"`    //数据
	DeviItem   interface{} `json:"deviitem,omitempty"`   //数据
	AlvalItem  interface{} `json:"alvalitem,omitempty"`  //数据
	RepeatItem interface{} `json:"repeatitem,omitempty"` //数据
	ResponItem interface{} `json:"responitem,omitempty"` //数据
	ShiftItem  interface{} `json:"shiftitem,omitempty"`  //数据
}

var (
	Nsqdtcpaddr                              string
	Nsqtopic                                 string
	SalesAdmin                               string = "SalesAdmin" //分销商管理员
	ProjectSourse                            string = "coldchain"
	DonorstbName                             string = "DonorsInfo"
	DonorslogtbName                          string = "DonorsLog"
	DonorsNoteItemName                       string = "DonorsNoteItem"
	IsUpdating                               string = "false"
	EquipmentModelName                       string = "EquipMentModel" //设备型号管理表
	SamplesLogtbName                         string = "SamplesLog"
	SamplesMaintbName                        string = "SamplesMain"
	SamplesDetailtbName                      string = "SamplesDetail"
	SamplesBusstbName                        string = "SamplesBusiness"
	SamplesDetailFiletbName                  string = "SamplesFileDetail"         // 归档表
	SamplesAttachmenttbName                  string = "SamplesAttachment"         // 附件表
	SampleSearchTemplateName                 string = "SampleSearchTemplate"      // 样本搜索模版表
	SampleTestMainName                       string = "SampleTestMain"            //样本检测信息主表
	SampleTestDetailName                     string = "SampleTestDetail"          //样本检测子表
	SamplesBookName                          string = "SamplesBook"               //样本列表
	SamplesBookDetailName                    string = "SamplesBookDetail"         //样本列表详情
	SampleTypeName                           string = "SampleType"                //样本类型
	STypeNoteItemName                        string = "STypeNoteItem"             //样本特有扩展
	ManagementPreparationName                string = "ManagementPreparation"     //制备管理
	PreparationStepDataName                  string = "PreparationStepData"       //制备步骤
	PreparationStepDetailDataName            string = "PreparationStepDetailData" //制备操作详情
	ManagementControlName                    string = "ManagementPreparation"     //质控管理
	ControlStepDataName                      string = "PreparationStepData"       //质控步骤
	ControlStepDetailDataName                string = "PreparationStepDetailData" //质控操作详情
	BaseOperationLogName                     string = "Base_OperationLog"         //操作日志表
	MaterialInfoName                         string = "MaterialInfo"              //库存信息表
	MaterialBatchKCName                      string = "MaterialBatchKC"           //物料批次库存信息表
	MaterialStoreHouseName                   string = "MaterialStoreHouse"        //仓库列表
	MaterialCKDetailName                     string = "MaterialCKDetail"          //出库管理子表
	MaterialCKHeadName                       string = "MaterialCKHead"            //出库管理主表
	MaterialPDDetailName                     string = "MaterialPDDetail"          //盘点子表
	MaterialPDHeadName                       string = "MaterialPDHead"            //盘点管理主表
	MicrobialName                            string = "Microbial"                 //动物微生物表
	CellBloodName                            string = "CellBlood"                 //采血表
	TestTemplateName                         string = "TestTemplate"              //检测模板
	PreparationTemplateName                  string = "PreparationTemplate"
	PreparationTemplateStepName              string = "PreparationTemplateStep"
	PreparationTemplateStepDetailName        string = "PreparationTemplateStepDetail"
	CellSaveName                             string = "CellSave"                    //细胞存储表
	Coustom_InformationName                  string = "Coustom_Information"         //客户信息表
	Order_InformationName                    string = "Order_Information"           //订单信息表
	GeneProductName                          string = "GeneProduct"                 //基因治疗表
	CellProductName                          string = "CellProduct"                 //细胞制备表
	MaterialRKDetailName                     string = "MaterialRKDetail"            //库存表
	MaterialRKHeadName                       string = "MaterialRKHead"              //入库主表
	TestSampleName                           string = "TestSample"                  //检验样本
	TestSampleDetailName                     string = "TestSampleDetail"            //检验样本详情表
	TestSampleInfoName                       string = "TestSampleInfo"              //检验样本信息
	TestSampleRelationName                   string = "TestSampleRelation"          //样本套餐-采样关系表
	TestTransferOrdersName                   string = "TestTransferOrders"          //检验交接单
	TestInfoName                             string = "TestInfo"                    //检验单
	TestInfoDetailName                       string = "TestInfoDetail"              //检验结果
	TestItemsListName                        string = "TestItemsList"               // 检验项目内容
	TestListName                             string = "TestList"                    //检验项目主表
	TestListDetailName                       string = "TestListDetail"              //检验项目详情表
	TestLaboratoryName                       string = "TestLaboratory"              //检验实验室
	TestQualityControlName                   string = "TestQualityControl"          //质控数据
	TestControlParametersName                string = "TestControlParameters"       //质控品参数
	TestControlParametersDetailName          string = "TestControlParametersDetail" //质控品详情
	AccusationParametersName                 string = "AccusationParameters"
	TestApplicationName                      string = "TestApplication"     //检验申请单
	TestPackageCategoryName                  string = "TestPackageCategory" // 类别
	TestPrintTemplateName                    string = "TestPrintTemplate"   //打印模板
	TestPackageName                          string = "TestPackage"         //检验套餐
	TestPackageItemsName                     string = "TestPackageItems"    //检验套餐项目明细
	InstrumentName                           string = "Instrument"
	Base_ItemTreeDetailsName                 string = "Base_ItemTreeDetails"           //数据字典  文档结构
	Base_ItemDetailsName                     string = "Base_ItemDetails"               //数据字典
	InstrumenMaintainLogName                 string = "InstrumenMaintainLog"           //质量管理
	InstrumenstateName                       string = "Instrumenstate"                 //设备自动发送信息
	InstrumenRunRecordName                   string = "InstrumenRunRecord"             //设备运行信息
	CustomerName                             string = "Customer"                       //客户原始信息内容
	CellsContractName                        string = "CellsContract"                  //合同管理
	CellsContractDetailName                  string = "CellsContractDetail"            //合同详情
	CellsCollectionName                      string = "CellsCollection"                //样本采集
	CellsCollectionDetailName                string = "CellsCollectionDetail"          //样本采集子表
	CellsCollectionSensorsName               string = "CellsCollectionSensors"         //采集单Sensor表
	CellsPrepareTemplateName                 string = "CellsPrepareTemplate"           //Cells制备模板主表
	CellsPrepareTemplateStepName             string = "CellsPrepareTemplateStep"       //Cells制备模板步骤表
	CellsPrepareTemplateStepDetailName       string = "CellsPrepareTemplateStepDetail" //Cells制备模板步骤详情表
	CellsPreparationName                     string = "CellsPreparation"               //Cells制备表
	CellsPreparationInfoName                 string = "CellsPreparationInfo"
	CellsPreparationInfoDetailName           string = "CellsPreparationInfoDetail"
	CellsPreparationSamplesName              string = "CellsPreparationSamples"              //Cells制备样本信息表
	CellsPreparationInfoDetailAttachmentName string = "CellsPreparationInfoDetailAttachment" //Cells制备附件表
	DonorsInfoAttachmentName                 string = "DonorsInfoAttachment"                 //样本采集附件
	InstrumenMaintainLogAttachmentName       string = "InstrumenMaintainLogAttachment"       //质量管理附件
	CellsContractAttachmentName              string = "CellsContractAttachment"              //合同管理附件
	CellsProductDeliveryName                 string = "CellsProductDelivery"                 //产品交付
	CellsProductDeliverySampleName           string = "CellsProductDeliverySample"           //交付详情
	CellsProductDeliveryAttachmentName       string = "CellsProductDeliveryAttachment"       //产品交付附件
	CellsPreparationTraceName                string = "CellsPreparationTrace"                //制备信息溯源表
	ControlTemplateName                      string = "ControlTemplate"                      //Cells质控备模板主表
	ControlTemplateStepName                  string = "ControlTemplateStep"                  //Cells质控模板步骤表
	ControlTemplateStepDetailName            string = "ControlTemplateStepDetail"            //Cells质控模板步骤详情表
	ControlName                              string = "Control"                              //Cells质控表
	ControlInfoName                          string = "ControlInfo"
	ControlInfoDetailName                    string = "ControlInfoDetail"
	ControlInfoDetailAttachmentName          string = "ControlInfoDetailAttachment"
	ControlTraceName                         string = "ControlTrace"                //制备信息溯源表
	DocumentInfoName                         string = "DocumentInfo"                //文档
	DocumentHistoryName                      string = "DocumentHistory"             //历史文档
	SamplesCustomorName                      string = "SamplesCustomor"             //样本库客户信息表
	SamplesCommunicationName                 string = "SamplesCommunication"        //样本库客户交流记录表
	SamplesProtocolName                      string = "SamplesProtocol"             //样本库协议表
	SamplesProtocolDetailName                string = "SamplesProtocolDetail"       //样本库协议执行信息表
	DonorsDetailName                         string = "DonorsDetail"                //样本库样本来源详情表
	ShelfName                                string = "Shelf"                       //设备冻存架表
	BoxName                                  string = "Box"                         //设备冻存盒表
	GroupDetailName                          string = "GroupDetail"                 //样本库分组表
	SamplesApplyName                         string = "SamplesApply"                //出入库申请表
	SamplesApplyDetailName                   string = "SamplesApplyDetail"          //出入库申请详情表
	SamplesRecordName                        string = "SamplesRecord"               //样本操作记录表
	LimsEntrustMainName                      string = "LimsEntrustMain"             //LIMS委托管理
	TestPackageTypesName                     string = "TestPackageTypes"            // LIMS检验类型
	LimsSampleTypeName                       string = "LimsSampleType"              // LIMS样品类型
	LimsDocTemplateName                      string = "LimsDocTemplate"             // lims模板
	LimsDocTemplateDetailName                string = "LimsDocTemplateDetail"       // lims模板详情
	LimsTaskBalanceName                      string = "LimsTaskBalance"             // 任务分配表
	LimsDeliverName                          string = "LimsDeliver"                 //样品交接表
	LimsDeliverDetailName                    string = "LimsDeliverDetail"           //样品交接详情表
	LimsPreparationName                      string = "LimsPreparation"             //样品制备表
	LimsCreateReportName                     string = "LimsCreateReport"            //报告生成
	LimsDateEntryName                        string = "LimsDateEntry"               //数据录入
	LimsDocHistoryName                       string = "LimsDocHistory"              //数据录入文档历史
	LimsEntrustSampleName                    string = "LimsEntrustSample"           //委托样品明细表
	LimsEntrustSampleTypeName                string = "LimsEntrustSampleType"       //详情表
	LimsReportHuxfName                       string = "LimsReportHuxf"              //呼吸阀检测数据记录表
	LimsReportYeyaqfName                     string = "LimsReportYeyaqf"            //液压安全阀检测数据记录表
	LimsReportZuhqName                       string = "LimsReportZuhq"              //阻火器检测数据记录表
	LimsReportElecGroundName                 string = "LimsReportElecGround"        //电气接地装置检测原始记录
	LimsReportLeakProtectName                string = "LimsReportLeakProtect"       //漏电保护器检测数据记录表
	LimsReportEquipotentName                 string = "LimsReportEquipotent"        //防雷装置（等电位）检测原始记录
	LimsReportLightProtectName               string = "LimsReportLightProtect"      //防雷装置检测原始记录
	LimsReportAmmeterName                    string = "LimsReportAmmeter"           //电流表检测原始记录
	LimsReportKqpmName                       string = "LimsReportAirFoamGenerator"  //空气泡沫产生器检测数据记录表
	LimsReportNoBeamPumpingUnitName          string = "LimsReportNoBeamPumpingUnit" //无游梁式抽油机检测数据记录表
	LimsReportBeamPumpingUnitName            string = "LimsReportBeamPumpingUnits"  //游梁式抽油机检测数据记录表
	LimsDrillingDailyName                    string = "LimsDrillingDaily"           //工程监督中心钻井工程监督日报
	LimsOilTestingDailyName                  string = "LimsOilTestingDaily"         //试油监督日报表
	LimsReportSignName                       string = "LimsReportSign"              //报告签发
	LimsReportHistoryName                    string = "LimsReportHistory"           //报告历史
	LimsCustomerpositionName                 string = "LimsCustomerPosition"
	LimsPressureLeakName                     string = "LimsPressureLeak"              //阻火器压力损失表
	LimsSpecifyStandardName                  string = "LimsSpecifyStandard"           //Lims规格型号标准
	BaseUserName                             string = "Base_User"                     //用户表
	UserQualificationName                    string = "UserQualification"             //用户资质表
	LimsInstrumentGroup                      string = "LimsInstrumentGroup"           // 检测仪器关联
	LimsReportAlertorName                    string = "LimsReportAlertor"             // 计量站报警器
	LimsReportAlertorCertificateName         string = "LimsReportAlertorCertificate"  // 计量站报警器  证书编号表
	LimsReportAlertorDeviationName           string = "LimsReportAlertorDeviation"    // 计量站报警器 示值误差及响应时间表
	LimsReportAlertorOtherName               string = "LimsReportAlertorOther"        // 计量站报警器 干扰误差
	LimsReportAlertorRepeatName              string = "LimsReportAlertorRepeat"       // 计量站报警器  重复性
	LimsReportAlertorShiftName               string = "LimsReportAlertorShift"        // 计量站报警器 漂移
	LimsReportAlertorValueName               string = "LimsReportAlertorValue"        // 计量站报警器 报警误差/报警功能及报警动作值
	LimsReportLiquidTransportationName       string = "LimsReportLiquidTransportation" //离心泵机组液体输送系统节能监测原始记录
	LimsReportAlertorResponseTimeName        string = "LimsReportAlertorResponseTime" // 计量站报警器  响应时间
	LimsReportPistonPumpUnitName             string = "LimsReportPistonPumpUnit" //柱塞泵机组液体输送系统节能监测原始记录
	LimsReportMotorName                      string = "LimsReportMotor" // 电动机节能监测原始记录
	LimsReportElecPumpWellName               string = "LimsReportElecPumpWell" // 电泵井节能监测原始数据记录表
	LimsReportScrewPumpName                  string = "LimsReportScrewPump" //  螺杆泵节能监测原始数据记录表
	LimsReportSpecialFieldName               string = "LimsReportSpecialField" // 油田专用变压器运行数据现场测试记录
)

//分页信息及数据
type DataInfo struct {
	CurrentItemCount int64       `json:"currentItemCount,omitempty"` //结果集中的条目数目
	ItemsPerPage     int64       `json:"itemsPerPage,omitempty"`     //每页记录数目
	StartIndex       int64       `json:"startIndex,omitempty"`       //items中第一个条目的索引
	TotalItemsx      int64       `json:"totalItemsx,omitempty"`      //当前集合中可用的总条目数
	PageIndex        int64       `json:"pageIndex,omitempty"`        //条目的当前页索引
	TotalPages       int64       `json:"totalPages,omitempty"`       //当前结果集中的总页数
	Items            interface{} `json:"items,omitempty"`            //数据列表
}

//下拉idname
type SelectIdNameModel struct {
	Id   int    `json:"id"`
	Name string `json:"name"`
}

func (this *BaseController) Prepare() {
	find := false

	// 不需要做登录验证的页面
	urls := []string{"/api/auth", "/api/users/registemanage", "/printservice",
		"/api/webinterface/preparelist", "/api/webinterface/prepareinfo",
		"/api/sampletest_v/sampletest", "/api/sampletest_v/getpass", "/api/sampletest_v/editpass/",
		"/api/sampletest_v/donorsdetail", "/api/sampletest_v/testdetail", "/api/uploads/samplesinput", "/api/doctemplate_onlyoffice/callback", "/api/doctemplate_onlyoffice/viewcallback", "/api/limsupload/usersignimg",
		"/api/uploads/samplestypeimg", "/api/limsdataentry/historyimg/"}
	for _, v := range urls {
		fmt.Println("**this.Ctx.Input.URL()**", this.Ctx.Input.URL())
		if this.Ctx.Input.URL() == v {
			find = true
			break
		}
		if strings.Contains(this.Ctx.Input.URL(), "/api/sampletest_v/editpass/") {
			find = true
			fmt.Println("/api/sampletest_v/editpass/")
			break
		}
		if strings.Contains(this.Ctx.Input.URL(), "/api/limsdataentry/historyimg/") {
			find = true
			fmt.Println("/api/limsdataentry/historyimg/")
			break
		}
	}

	if !find { // 如果是登录操作不做验证
		var err error
		this.User, err = this.ParseToken()
		if err != nil { // token非法或已失效
			fmt.Println(err)
			this.Abort("401")
		}

		if this.User == nil {
			this.User = &models.UserInfo{}
		}

		svc := userRole.GetUserService(utils.DBE)
		usermodel := svc.GetUserInfoSelf(this.User.Username)
		this.User.Id = utils.ToStr(usermodel.Id)
		this.User.Realname = usermodel.Realname
		this.User.AccCode = usermodel.AccCode
		this.User.Description = usermodel.Description
		this.User.DepartmentId = usermodel.Departmentid
		this.User.Roles = utils.ToStr(usermodel.Roleid)
		beego.Debug("User:", this.User)
	}

	if this.User == nil {
		fmt.Println("user is null")
		this.User = &models.UserInfo{}
	}
}

// ParseToken parse JWT token in http header.
func (this *BaseController) ParseToken() (*models.UserInfo, error) {
	authString := this.Ctx.Input.Header("Authorization")
	beego.Debug("AuthString:", authString)

	kv := strings.Split(authString, " ")
	if len(kv) != 2 || kv[0] != "Bearer" {
		beego.Error("AuthString invalid:", authString)
		return nil, errors.New("AuthString invalid")
	}
	tokenString := kv[1]
	pUserinfo, err := models.CheckToken(tokenString)
	return pUserinfo, err
}

//获取waterdrop帐号密码
func (this *BaseController) GetuAndp() (string, string) {
	return "seedplatform", "seed@platformDASHOO.cn"
	//return "coldcloud", "CC@p1a2w3d4word"
}

//获取accode
func (this *BaseController) GetAccode() string {
	return this.User.AccCode
}

//获取仓库Id
func (this *BaseController) GetHouseIdByLoginuser() int {
	svc := material.GetMaterialService(utils.DBE)
	return svc.GetHouseIdByDepartmentId(this.User.AccCode+MaterialStoreHouseName, this.User.DepartmentId)
}

func (this *BaseController) GetupdbAndHost() (string, string, string, string) {
	return "coldcloud", "cc@1qaz2wsx", "coldcloud", "121.42.244.202:9086"
}

func (this *BaseController) GetPageInfoForm() (page PageInfo) {
	page.CurrentPage, _ = this.GetInt64("_currentPage")
	page.Size, _ = this.GetInt64("_size")
	return
}

//初始化redis
func InitRedis() {
	poolnum := 5
	addr := utils.Cfg.MustValue("redis", "addr")
	redis.InitRedis(poolnum, addr)
}

//打印相关

type PrintColType struct {
	JsonType   string
	FieldIndex int
	FieldType  string
	FieldSize  int
	FieldName  string
	Required   bool
}
type PrintData struct {
	Data interface{}
	Cols []PrintColType
}
type PrintInfo struct {
	Alldata []PrintData `json:"alldata"`
	Vars    []string    `json:"vars"`
}

func AutoColType(source interface{}) (cols []PrintColType) {
	sObjT := reflect.TypeOf(source).Elem()
	for i := 0; i < sObjT.NumField(); i++ {
		fieldT := sObjT.Field(i)
		var fieldName, jsontype, datatype string = fieldT.Name, fieldT.Type.Kind().String(), "string"
		var fildsize = 2000
		switch fieldT.Type.Kind() {
		case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
			fildsize = 0
			datatype = "integer"
		case reflect.Float32, reflect.Float64:
			datatype = "float"
			fildsize = 0
		}
		cols = append(cols, PrintColType{jsontype, i, datatype, fildsize, fieldName, false})
	}
	return
}

//base64 解密
const (
	base64Table = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/"
)

var coder = base64.NewEncoding(base64Table)

func Base64Decode(src string) string {
	co, _ := coder.DecodeString(src)
	return string(co)
}

func FloatPoint(value float64, bit int) float64 {
	value_str := strconv.FormatFloat(value, 'f', bit, 64)
	value_f64, _ := strconv.ParseFloat(value_str, 64)
	return value_f64
}

//===========ln
type DetailsInfo struct {
	Code    int64       `json:"code"`
	Message string      `json:"message,omitempty"`
	Item    interface{} `json:"item,omitempty"`  //数据
	Types   interface{} `json:"types,omitempty"` //检测类型
}