Esempio n. 1
0
//添加数据
func insert(entity Entity, model *Model, elements []element) (id int, err error) {

	sql := "insert into " + entity.Id + "("
	valueSql := " values ("

	params := []interface{}{}

	for _, element := range elements {
		if element.Type != "image" {
			sql += element.Field + ","

			valueSql += "?,"

			params = append(params, GetPropValue(model, element.Field))
		}
	}

	valueSql = commonlib.Substr(valueSql, 0, len(valueSql)-1)
	sql = commonlib.Substr(sql, 0, len(sql)-1)

	sql += ")"
	valueSql += ")"
	sql += valueSql

	Log.Debug(sql)

	db := GetMySQL()
	defer db.Close()

	stmt, err := db.Prepare(sql)

	if err != nil {
		Log.Warn(err.Error())
		return 0, err
	}

	res, err := stmt.Exec(params...)

	if err != nil {
		Log.Warn(err.Error())
		return 0, err
	}

	id64, err := res.LastInsertId()

	if err != nil {
		Log.Warn(err.Error())

		return 0, err
	}

	return int(id64), nil
}
Esempio n. 2
0
func updateCourse(tx *sql.Tx, courseDataMap map[string]interface{}, id string) error {
	sql := "update course set %v where cid=?"
	params := []interface{}{}

	setSql := ""

	for key, value := range courseDataMap {
		setSql += key + "=?,"
		params = append(params, value)
	}

	params = append(params, id)

	setSql = commonlib.Substr(setSql, 0, len(setSql)-1)

	sql = fmt.Sprintf(sql, setSql)
	lessgo.Log.Debug(sql)

	stmt, err := tx.Prepare(sql)

	if err != nil {
		lessgo.Log.Error(err.Error())
		return err
	}

	_, err = stmt.Exec(params...)

	if err != nil {
		lessgo.Log.Error(err.Error())
		return err
	}

	return nil
}
Esempio n. 3
0
/*****
 * 获取上传图片的随机不重复文件名
 */
func findRandomFileName(sourceFileName string) string {

	suffix := commonlib.Substr(sourceFileName, strings.LastIndex(sourceFileName, "."), len(sourceFileName))

	r := rand.New(rand.NewSource(time.Now().UnixNano()))

	str := ""

	for i := 0; i < 4; i++ {
		str += fmt.Sprint(r.Intn(10))
	}

	return fmt.Sprint(time.Now().UnixNano(), str, suffix)
}
Esempio n. 4
0
//构建查询的sql语句
func bulidSelectSql(entity Entity, colmuns []column) (string, string) {

	dataSql := "select " + entity.Id + "." + entity.Pk + ","

	if len(colmuns) > 0 {
		for _, column := range colmuns {
			if strings.Contains(column.Field, ".") {
				dataSql += column.Field + ","
			} else {
				dataSql += entity.Id + "." + column.Field + ","
			}
		}
	} else {
		for _, field := range entity.Fields {
			dataSql += entity.Id + "." + field.Name + ","
		}

		for _, ref := range entity.Refs {

			for _, field := range ref.Fields {
				if ref.Alias != "" {
					dataSql += ref.Alias + "." + field.Name + ","
				} else {
					dataSql += ref.Entity + "." + field.Name + ","
				}

			}

		}
	}

	dataSql = commonlib.Substr(dataSql, 0, len(dataSql)-1)

	dataSql += " from " + entity.Id + " " + entity.Id

	for _, ref := range entity.Refs {
		if ref.Alias != "" {
			dataSql += fmt.Sprintf(" left join %v %v on %v.%v=%v.%v", ref.Entity, ref.Alias, entity.Id, ref.Field, ref.Alias, ref.RefEntityField)
		} else {
			dataSql += fmt.Sprintf(" left join %v %v on %v.%v=%v.%v", ref.Entity, ref.Entity, entity.Id, ref.Field, ref.Entity, ref.RefEntityField)
		}
	}

	countSql := "select count(1) from " + entity.Id

	return countSql, dataSql
}
Esempio n. 5
0
func NewsImageUplaodAction(w http.ResponseWriter, r *http.Request) {

	m := make(map[string]interface{})

	newsImgDir, _ := lessgo.Config.GetValue("wooyou", "newsImgDir")

	_, err := os.Stat(newsImgDir)

	if err != nil && os.IsNotExist(err) {
		lessgo.Log.Info(newsImgDir, ",创建")
		os.Mkdir(newsImgDir, 0777)
	}

	fn, header, err := r.FormFile("imgFile")

	if err != nil && os.IsNotExist(err) {
		m["error"] = 1
		m["message"] = err.Error()
		lessgo.Log.Error("获取上传图片发生错误,信息如下:", err.Error())
		commonlib.OutputJson(w, m, " ")
		return
	}

	suffix := commonlib.Substr(header.Filename, strings.LastIndex(header.Filename, ".")+1, len(header.Filename))

	newFileName := findRandomFileName(header.Filename) + "." + suffix

	f, err := os.Create(newsImgDir + "/" + newFileName)

	if err != nil {
		m["error"] = 1
		m["message"] = err.Error()
		lessgo.Log.Error("获取上传图片发生错误,信息如下:", err.Error())
		commonlib.OutputJson(w, m, " ")
		return
	}

	defer f.Close()

	io.Copy(f, fn)

	m["error"] = 0
	m["url"] = "/newsimg/" + newFileName

	commonlib.OutputJson(w, m, " ")
}
Esempio n. 6
0
//处理实体的保存页请求
func dealEntitySave(_entity Entity, w http.ResponseWriter, r *http.Request) {

	m := make(map[string]interface{})

	employee := GetCurrentEmployee(r)

	if employee.UserId == "" {
		Log.Warn("用户未登陆")
		m["success"] = false
		m["code"] = 100
		m["msg"] = "用户未登陆"
		commonlib.OutputJson(w, m, " ")
		return
	}

	Log.Debug("路径:", r.URL.Path, "访问实体", _entity.Id, "的保存ajax请求")

	err := r.ParseForm()

	//异步请求绑定的组件Id
	componentId := r.FormValue("componentId")
	formpanel := runtimeComponentContain[componentId].(formPanel)

	if err != nil {
		m["success"] = false
		m["code"] = 100
		m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
		Log.Warn(err.Error())
		commonlib.OutputJson(w, m, " ")
		return
	}

	idString := r.FormValue(_entity.Pk)

	_model := new(Model)
	_model.Props = []*Prop{}

	imgElements := []element{}

	for _, formElement := range formpanel.Elements {
		_prop := new(Prop)

		if formElement.Type == "image" { //图片类型需要做多表处理
			imgElements = append(imgElements, formElement)
		} else if formElement.Type == "currentTime" { //当前时间,一般用于createTime
			_prop.Name = formElement.Field
			if formElement.Char14 == "true" {
				_prop.Value = time.Now().Format("20060102150405")
			} else {
				_prop.Value = time.Now().Format("2006-01-02 15:04:05")
			}
			_model.Props = append(_model.Props, _prop)
		} else {
			_prop.Name = formElement.Field
			_prop.Value = r.FormValue(formElement.Field)
			_model.Props = append(_model.Props, _prop)
		}
	}

	if idString != "" { //修改的情况
		id, err := strconv.Atoi(idString)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			Log.Warn(err.Error())
			commonlib.OutputJson(w, m, " ")
			return
		}

		_model.Id = fmt.Sprint(id)

		err = modify(_entity, _model, formpanel.Elements)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			commonlib.OutputJson(w, m, " ")
			return
		}

		m["success"] = true
		m["code"] = 200
		commonlib.OutputJson(w, m, " ")
		return
	} else {
		id, err := insert(_entity, _model, formpanel.Elements)

		for _, imgElment := range imgElements {

			filePath := r.FormValue(imgElment.Field)
			tmpFileName := ""

			if filePath != "" {
				imgEntity := getEntity(imgElment.ImageEntity)
				imageModel := new(Model)
				imageModel.Props = []*Prop{}

				fileNameProp := new(Prop)
				fileNameProp.Name = "filename"
				fileNameProp.Value = commonlib.SubstrByStEd(filePath, strings.LastIndex(filePath, "/")+1, strings.LastIndex(filePath, "."))
				tmpFileName = commonlib.Substr(filePath, strings.LastIndex(filePath, "/")+1, len(filePath))

				suffixProp := new(Prop)
				suffixProp.Name = "suffix"
				suffixProp.Value = commonlib.Substr(filePath, strings.LastIndex(filePath, ".")+1, len(filePath))

				refProp := new(Prop)
				refProp.Name = imgElment.Field
				refProp.Value = fmt.Sprint(id)

				imageModel.Props = append(imageModel.Props, fileNameProp)
				imageModel.Props = append(imageModel.Props, suffixProp)
				imageModel.Props = append(imageModel.Props, refProp)

				_, err := insert(imgEntity, imageModel, []element{
					element{
						Field: "filename",
					},
					element{
						Field: "suffix",
					},
					element{
						Field: imgElment.Field,
					},
				})

				if err != nil {
					m["success"] = false
					m["code"] = 100
					m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
					Log.Warn(err.Error())
					commonlib.OutputJson(w, m, " ")
					return
				}

				tmpFile, err := os.OpenFile("../tmp/"+tmpFileName, os.O_RDWR, 0777)

				if err != nil {
					m["success"] = false
					m["code"] = 100
					m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
					Log.Warn(err.Error())
					commonlib.OutputJson(w, m, " ")
					return
				}

				_, err = os.Stat(imgElment.ImagePath)

				if err != nil && os.IsNotExist(err) {
					Log.Info(imgElment.ImagePath, "文件夹不存在,创建")
					os.MkdirAll(imgElment.ImagePath, 0777)
				}

				disFile, err := os.Create(imgElment.ImagePath + "/" + tmpFileName)

				if err != nil {
					m["success"] = false
					m["code"] = 100
					m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
					Log.Warn(err.Error())
					commonlib.OutputJson(w, m, " ")
					return
				}

				io.Copy(disFile, tmpFile)

				os.Remove("../tmp/" + tmpFileName)
			}
		}

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			commonlib.OutputJson(w, m, " ")
			return
		}

		m["success"] = true
		m["code"] = 200
		commonlib.OutputJson(w, m, " ")
		return
	}

}
Esempio n. 7
0
func NewsFormAction(w http.ResponseWriter, r *http.Request, actionType string) {
	m := make(map[string]interface{})

	err := r.ParseForm()
	if err != nil {
		lessgo.Log.Error(err.Error())
		return
	}

	news := new(News)
	news.Id, _ = strconv.Atoi(r.FormValue("id"))
	news.Title = r.FormValue("title")
	news.NewsContent = r.FormValue("news_content")
	previewImage := r.FormValue("preview_image")
	news.PreviewImage = commonlib.Substr(previewImage, strings.LastIndex(previewImage, "/")+1, len(previewImage))
	news.PreviewText = r.FormValue("preview_text")
	news.IsCarousel = r.FormValue("is_carousel")
	carouselImage := r.FormValue("carousel_image")
	news.CarouselImage = commonlib.Substr(carouselImage, strings.LastIndex(carouselImage, "/")+1, len(carouselImage))

	msg := ""
	switch actionType {
	case FORM_ACTION_TYPE.CREATE.Key:
		msg, err = NewsSave(news)
	case FORM_ACTION_TYPE.UPDATE.Key:
		msg, err = NewsUpdate(news)
	}

	newsImgDir, _ := lessgo.Config.GetValue("wooyou", "newsImgDir")

	// 图片文件处理
	if news.PreviewImage != "" {
		tmpFile, err := os.OpenFile("../tmp/"+news.PreviewImage, os.O_RDWR, 0777)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			lessgo.Log.Error(err.Error())
			commonlib.OutputJson(w, m, " ")
			return
		}

		_, err = os.Stat(newsImgDir)

		if err != nil && os.IsNotExist(err) {
			lessgo.Log.Error(newsImgDir, "文件夹不存在,创建")
			os.MkdirAll(newsImgDir, 0777)
		}

		disFile, err := os.Create(newsImgDir + "/" + news.PreviewImage)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			lessgo.Log.Error(err.Error())
			commonlib.OutputJson(w, m, " ")
			return
		}

		io.Copy(disFile, tmpFile)

		os.Remove("../tmp/" + news.PreviewImage)
	}
	// 图片文件处理
	if news.CarouselImage != "" {
		tmpFile, err := os.OpenFile("../tmp/"+news.CarouselImage, os.O_RDWR, 0777)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			lessgo.Log.Error(err.Error())
			commonlib.OutputJson(w, m, " ")
			return
		}

		_, err = os.Stat(newsImgDir)

		if err != nil && os.IsNotExist(err) {
			lessgo.Log.Error(newsImgDir, "文件夹不存在,创建")
			os.MkdirAll(newsImgDir, 0777)
		}

		disFile, err := os.Create(newsImgDir + "/" + news.CarouselImage)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			lessgo.Log.Error(err.Error())
			commonlib.OutputJson(w, m, " ")
			return
		}

		io.Copy(disFile, tmpFile)

		os.Remove("../tmp/" + news.CarouselImage)
	}

	if err != nil {
		lessgo.Log.Error(err.Error())
		m["sucess"] = false
		m["msg"] = msg
	} else {
		m["success"] = true
		m["datas"] = news
	}
	commonlib.OutputJson(w, m, "")

	return
}
Esempio n. 8
0
func GetImageFileSuffix(imageName string) string {
	return commonlib.Substr(imageName, strings.LastIndex(imageName, ".")+1, len(imageName))
}
Esempio n. 9
0
func (log *MyLogger) Warn(arg0 ...interface{}) {
	_, file, line, _ := runtime.Caller(1)
	file = commonlib.Substr(file, strings.LastIndex(file, "/")+1, 100)
	tmplog.Warn(fmt.Sprint("[文件:", file, ",行:", line, "] ", fmt.Sprint(arg0...)))
}
Esempio n. 10
0
//处理实体的保存页请求
func dealEntitySave(entity Entity, w http.ResponseWriter, r *http.Request) {

	Log.Debug("路径:", r.URL.Path, "访问实体", entity.Id, "的保存ajax请求")

	err := r.ParseForm()

	//异步请求绑定的组件Id
	componentId := r.FormValue("componentId")
	formpanel := runtimeComponentContain[componentId].(FormPanel)

	m := make(map[string]interface{})

	if err != nil {
		m["success"] = false
		m["code"] = 100
		m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
		Log.Warn(err.Error())
		commonlib.OutputJson(w, m, " ")
		return
	}

	idString := r.FormValue(entity.Pk)

	model := new(Model)
	model.Props = []*Prop{}

	for _, element := range formpanel.Elements {
		prop := new(Prop)

		if element.Type == "image" { //图片类型需要做多表处理

			filePath := r.FormValue(element.Field)
			tmpFileName := ""

			if filePath != "" {
				imgEntity := GetEntity(element.ImageEntity)
				imageModel := new(Model)
				imageModel.Props = []*Prop{}

				fileNameProp := new(Prop)
				fileNameProp.Name = "filename"
				fileNameProp.Value = commonlib.SubstrByStEd(filePath, strings.LastIndex(filePath, "/")+1, strings.LastIndex(filePath, "."))
				tmpFileName = commonlib.Substr(filePath, strings.LastIndex(filePath, "/")+1, len(filePath))

				suffixProp := new(Prop)
				suffixProp.Name = "suffix"
				suffixProp.Value = commonlib.Substr(filePath, strings.LastIndex(filePath, ".")+1, len(filePath))

				imageModel.Props = append(imageModel.Props, fileNameProp)
				imageModel.Props = append(imageModel.Props, suffixProp)

				imgId, err := Insert(imgEntity, imageModel, []Element{
					Element{
						Field: "filename",
					},
					Element{
						Field: "suffix",
					},
				})

				if err != nil {
					m["success"] = false
					m["code"] = 100
					m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
					Log.Warn(err.Error())
					commonlib.OutputJson(w, m, " ")
					return
				}

				prop.Name = element.Field
				prop.Value = fmt.Sprint(imgId)
				model.Props = append(model.Props, prop)

				tmpFile, err := os.OpenFile("../tmp/"+tmpFileName, os.O_RDWR, 0777)

				if err != nil {
					m["success"] = false
					m["code"] = 100
					m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
					Log.Warn(err.Error())
					commonlib.OutputJson(w, m, " ")
					return
				}

				_, err = os.Stat(element.ImagePath)

				if err != nil && os.IsNotExist(err) {
					Log.Info(element.ImagePath, "文件夹不存在,创建")
					os.Mkdir(element.ImagePath, 0777)
				}

				disFile, err := os.Create(element.ImagePath + "/" + tmpFileName)

				if err != nil {
					m["success"] = false
					m["code"] = 100
					m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
					Log.Warn(err.Error())
					commonlib.OutputJson(w, m, " ")
					return
				}

				io.Copy(disFile, tmpFile)

				os.Remove("../tmp/" + tmpFileName)
			} else {
				prop.Name = element.Field
				prop.Value = fmt.Sprint(0)
				model.Props = append(model.Props, prop)
			}

		} else {
			prop.Name = element.Field
			prop.Value = r.FormValue(element.Field)
			model.Props = append(model.Props, prop)
		}
	}

	if idString != "" { //修改的情况
		id, err := strconv.Atoi(idString)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			Log.Warn(err.Error())
			commonlib.OutputJson(w, m, " ")
			return
		}

		model.Id = id

		err = Modify(entity, model, formpanel.Elements)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			commonlib.OutputJson(w, m, " ")
			return
		}

		m["success"] = true
		m["code"] = 200
		commonlib.OutputJson(w, m, " ")
		return
	} else {
		_, err = Insert(entity, model, formpanel.Elements)

		if err != nil {
			m["success"] = false
			m["code"] = 100
			m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
			commonlib.OutputJson(w, m, " ")
			return
		}

		m["success"] = true
		m["code"] = 200
		commonlib.OutputJson(w, m, " ")
		return
	}

}
Esempio n. 11
0
func ContractOfChildAction(w http.ResponseWriter, r *http.Request) {

	m := make(map[string]interface{})

	err := r.ParseForm()

	if err != nil {
		m["success"] = false
		m["code"] = 100
		m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
		commonlib.OutputJson(w, m, " ")
		return
	}

	childId := r.FormValue("childId")

	sql := "select contr.id,contr.contract_no,cour.name,contr.apply_time from contract contr left join course cour on cour.cid=contr.course_id where contr.child_id=? "

	lessgo.Log.Debug(sql)

	db := lessgo.GetMySQL()
	defer db.Close()

	rows, err := db.Query(sql, childId)

	if err != nil {
		lessgo.Log.Warn(err.Error())
		m["success"] = false
		m["code"] = 100
		m["msg"] = "系统发生错误,请联系IT部门"
		commonlib.OutputJson(w, m, " ")
		return
	}

	type Result struct {
		Value string `json:"value"`
		Desc  string `json:"desc"`
	}

	objects := []*Result{}

	for rows.Next() {

		model := new(Result)

		var contractNo, courseName, applyTime string

		err = commonlib.PutRecord(rows, &model.Value, &contractNo, &courseName, &applyTime)

		model.Desc = contractNo + "-" + courseName + "-" + commonlib.Substr(applyTime, 0, 8)

		if err != nil {
			lessgo.Log.Warn(err.Error())
			m["success"] = false
			m["code"] = 100
			m["msg"] = "系统发生错误,请联系IT部门"
			commonlib.OutputJson(w, m, " ")
			return
		}

		objects = append(objects, model)
	}
	m["success"] = true
	m["datas"] = objects

	commonlib.OutputJson(w, m, " ")
	return
}