basisbuild.go 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322
  1. package oilsupplier
  2. import (
  3. "encoding/json"
  4. "strings"
  5. "time"
  6. "dashoo.cn/backend/api/business/items"
  7. "dashoo.cn/backend/api/business/baseUser"
  8. "dashoo.cn/business/userRole"
  9. //"dashoo.cn/backend/api/business/items"
  10. "dashoo.cn/backend/api/business/oilsupplier/basisbuild"
  11. . "dashoo.cn/backend/api/controllers"
  12. "dashoo.cn/utils"
  13. )
  14. type OilBasisBuildController struct {
  15. BaseController
  16. }
  17. // @Title 获取列表
  18. // @Description get user by token
  19. // @Success 200 {object} []basisbuild.OilBasisBuild
  20. // @router /list [get]
  21. func (this *OilBasisBuildController) GetEntityList() {
  22. //获取分页信息
  23. page := this.GetPageInfoForm()
  24. where := " 1=1 "
  25. orderby := "Id"
  26. asc := false
  27. Order := this.GetString("Order")
  28. Prop := this.GetString("Prop")
  29. if Order != "" && Prop != "" {
  30. orderby = Prop
  31. if Order == "asc" {
  32. asc = true
  33. }
  34. }
  35. CreateOn := this.GetString("CreateOn")
  36. Code := this.GetString("Code")
  37. Name := this.GetString("Name")
  38. if Code != "" {
  39. where = where + " and Code like '%" + Code + "%'"
  40. }
  41. if Name != "" {
  42. where = where + " and Name like '%" + Name + "%'"
  43. }
  44. if CreateOn != "" {
  45. dates := strings.Split(CreateOn, ",")
  46. if len(dates) == 2 {
  47. minDate := dates[0]
  48. maxDate := dates[1]
  49. where = where + " and CreateOn>='" + minDate + "' and CreateOn<='" + maxDate + "'"
  50. }
  51. }
  52. svc := basisbuild.GetOilBasisBuildService(utils.DBE)
  53. var list []basisbuild.OilBasisBuild
  54. total := svc.GetPagingEntitiesWithOrderBytbl("", page.CurrentPage, page.Size, orderby, asc, &list, where)
  55. var datainfo DataInfo
  56. datainfo.Items = list
  57. datainfo.CurrentItemCount = total
  58. datainfo.PageIndex = page.CurrentPage
  59. datainfo.ItemsPerPage = page.Size
  60. this.Data["json"] = &datainfo
  61. this.ServeJSON()
  62. }
  63. // @Title 获取字典列表
  64. // @Description get user by token
  65. // @Success 200 {object} map[string]interface{}
  66. // @router /dictlist [get]
  67. func (this *OilBasisBuildController) GetDictList() {
  68. dictList := make(map[string]interface{})
  69. dictSvc := items.GetItemsService(utils.DBE)
  70. userSvc := baseUser.GetBaseUserService(utils.DBE)
  71. //customerSvc := svccustomer.GetCustomerService(utils.DBE)
  72. //dictList["WellNo"] = dictSvc.GetKeyValueItems("WellNo", "")
  73. var userEntity userRole.Base_User
  74. userSvc.GetEntityById(this.User.Id, &userEntity)
  75. dictList["Supervisers"] = userSvc.GetUserListByDepartmentId("", userEntity.Departmentid)
  76. dictList["AuditStep"] = dictSvc.GetKeyValueItems("AuditStep", this.User.AccCode)
  77. //var dictCustomer []svccustomer.Customer
  78. //customerSvc.GetEntitysByWhere("" + CustomerName, "", &dictCustomer)
  79. //dictList["EntrustCorp"] = &dictCustomer
  80. var datainfo DataInfo
  81. datainfo.Items = dictList
  82. this.Data["json"] = &datainfo
  83. this.ServeJSON()
  84. }
  85. // @Title 获取实体
  86. // @Description 获取实体
  87. // @Success 200 {object} basisbuild.OilBasisBuild
  88. // @router /get/:id [get]
  89. func (this *OilBasisBuildController) GetEntity() {
  90. Id := this.Ctx.Input.Param(":id")
  91. var model basisbuild.OilBasisBuild
  92. svc := basisbuild.GetOilBasisBuildService(utils.DBE)
  93. svc.GetEntityByIdBytbl(""+OilBasisBuildName, Id, &model)
  94. this.Data["json"] = &model
  95. this.ServeJSON()
  96. }
  97. // @Title 添加
  98. // @Description 新增
  99. // @Success 200 {object} controllers.Request
  100. // @router /add [post]
  101. func (this *OilBasisBuildController) AddEntity() {
  102. var model basisbuild.OilBasisBuild
  103. var jsonBlob = this.Ctx.Input.RequestBody
  104. svc := basisbuild.GetOilBasisBuildService(utils.DBE)
  105. json.Unmarshal(jsonBlob, &model)
  106. model.CreateOn = time.Now()
  107. model.CreateBy = this.User.Realname
  108. model.CreateUserId, _ = utils.StrTo(this.User.Id).Int()
  109. //model.OrganizeId, _ = utils.StrTo(this.User.DepartmentId).Int()
  110. _, err := svc.InsertEntityBytbl(""+OilBasisBuildName, &model)
  111. var errinfo ErrorDataInfo
  112. if err == nil {
  113. //新增
  114. errinfo.Message = "添加成功!"
  115. errinfo.Code = 0
  116. errinfo.Item = model.Id
  117. this.Data["json"] = &errinfo
  118. this.ServeJSON()
  119. } else {
  120. errinfo.Message = "添加失败!" + utils.AlertProcess(err.Error())
  121. errinfo.Code = -1
  122. this.Data["json"] = &errinfo
  123. this.ServeJSON()
  124. }
  125. }
  126. // @Title 修改实体
  127. // @Description 修改实体
  128. // @Success 200 {object} controllers.Request
  129. // @router /update/:id [post]
  130. func (this *OilBasisBuildController) UpdateEntity() {
  131. id := this.Ctx.Input.Param(":id")
  132. var errinfo ErrorInfo
  133. if id == "" {
  134. errinfo.Message = "操作失败!请求信息不完整"
  135. errinfo.Code = -2
  136. this.Data["json"] = &errinfo
  137. this.ServeJSON()
  138. return
  139. }
  140. var model basisbuild.OilBasisBuild
  141. svc := basisbuild.GetOilBasisBuildService(utils.DBE)
  142. var jsonBlob = this.Ctx.Input.RequestBody
  143. json.Unmarshal(jsonBlob, &model)
  144. model.ModifiedOn = time.Now()
  145. model.ModifiedBy = this.User.Realname
  146. model.ModifiedUserId, _ = utils.StrTo(this.User.Id).Int()
  147. cols := []string{
  148. "Id",
  149. "Code",
  150. "Name",
  151. "F01",
  152. "F02",
  153. "F03",
  154. "F04",
  155. "F05",
  156. "F06",
  157. "F07",
  158. "F08",
  159. "F09",
  160. "F10",
  161. "F11",
  162. "F12",
  163. "F13",
  164. "F14",
  165. "F15",
  166. "F16",
  167. "F17",
  168. "F18",
  169. "F19",
  170. "F20",
  171. "F21",
  172. "F22",
  173. "F23",
  174. "F24",
  175. "F25",
  176. "Remark",
  177. "DeletionStateCode",
  178. "CreateOn",
  179. "CreateUserId",
  180. "CreateBy",
  181. "ModifiedOn",
  182. "ModifiedUserId",
  183. "ModifiedBy",
  184. }
  185. err := svc.UpdateEntityBytbl(""+OilBasisBuildName, id, &model, cols)
  186. if err == nil {
  187. errinfo.Message = "修改成功!"
  188. errinfo.Code = 0
  189. this.Data["json"] = &errinfo
  190. this.ServeJSON()
  191. } else {
  192. errinfo.Message = "修改失败!" + utils.AlertProcess(err.Error())
  193. errinfo.Code = -1
  194. this.Data["json"] = &errinfo
  195. this.ServeJSON()
  196. }
  197. }
  198. // @Title 删除单条信息
  199. // @Description
  200. // @Success 200 {object} ErrorInfo
  201. // @Failure 403 :id 为空
  202. // @router /delete/:Id [delete]
  203. func (this *OilBasisBuildController) DeleteEntity() {
  204. Id := this.Ctx.Input.Param(":Id")
  205. var errinfo ErrorInfo
  206. if Id == "" {
  207. errinfo.Message = "操作失败!请求信息不完整"
  208. errinfo.Code = -2
  209. this.Data["json"] = &errinfo
  210. this.ServeJSON()
  211. return
  212. }
  213. var model basisbuild.OilBasisBuild
  214. var entityempty basisbuild.OilBasisBuild
  215. svc := basisbuild.GetOilBasisBuildService(utils.DBE)
  216. opdesc := "删除-" + Id
  217. err := svc.DeleteOperationAndWriteLogBytbl(""+OilBasisBuildName, BaseOperationLogName, Id, &model, &entityempty, utils.ToStr(this.User.Id), this.User.Username, opdesc, "", "钻井日报")
  218. if err == nil {
  219. errinfo.Message = "删除成功"
  220. errinfo.Code = 0
  221. this.Data["json"] = &errinfo
  222. this.ServeJSON()
  223. } else {
  224. errinfo.Message = "删除失败!" + utils.AlertProcess(err.Error())
  225. errinfo.Code = -1
  226. this.Data["json"] = &errinfo
  227. this.ServeJSON()
  228. }
  229. }
  230. // @Title 基建类业务
  231. // @Description get user by token
  232. // @Success 200 {object} models.Userblood
  233. // @router /basiclist [get]
  234. func (this *OilBasisBuildController) BasicList() {
  235. page := this.GetPageInfoForm()
  236. var list []basisbuild.OilBasisBuild
  237. svc := basisbuild.GetOilBasisBuildService(utils.DBE)
  238. where := " 1=1"
  239. orderby := "Id"
  240. asc := true
  241. Order := this.GetString("Order")
  242. Prop := this.GetString("Prop")
  243. if Order != "" && Prop != "" {
  244. orderby = Prop
  245. if Order == "asc" {
  246. asc = true
  247. }
  248. }
  249. keyword := this.GetString("keyword")
  250. if keyword != "" {
  251. where = where + " and Name like '%" + keyword + "%' or Code like '%" + keyword + "%'"
  252. }
  253. total := svc.GetPagingEntitiesWithoutAccCode(page.CurrentPage, page.Size, orderby, asc, &list, where)
  254. var datainfo DataInfo
  255. datainfo.Items = list
  256. datainfo.CurrentItemCount = total
  257. this.Data["json"] = &datainfo
  258. this.ServeJSON()
  259. }