kpt_xdmy/doc/eqzhibiao/eq-牧场分级统计-设备指标.md

pasture

• add column

  alter table pasture 
  add index (region_id),
  add  index (center_id);
  add center_id int(11) default  0,
  add region_id int(11) default  0;
  add center varchar(64)  default '' ,
  add  region varchar(64)  default '' ,
  add center_sort int(11) default 0
  

• update

• region

  update
  pasture
  set
  region = case
      when name = '宝鸡牧场'
      or name = '吴忠牧场'
      or name = '阜民丰牧场' then '西北大区'
      when name = '双城牧场'
      or name = '尚志牧场'
      or name = '乌兰牧场' then '东北大区'
      when name = '商河牧场'
      or name = '汶上牧场'
      or name = '临沂牧场' then '华中大区'
      when name = '察一牧场'
      or name = '察北牧场' 
      or name = '察二牧场'
      or name = '恒盛牧场' then '察北大区'
      when name = '塞一牧场'
      or name = '塞二牧场'
      or name = '塞三牧场'
      or name = '塞四牧场'
      or name = '塞五牧场'
      or name = '通辽牧场' then '塞北大区'
      when name = '蚌埠牧场'
      or name = '合肥牧场'
      or name = '马鞍山牧场' then '华东大区'
      when name = '和林牧场'
      or name = '西藏牧场'
      or name = '洪雅牧场'
      or name = '眉山牧场'
      or name = '云南牧场' then '蒙云川大区'
      when name = '赛罕牧场'
      or name = '托县牧场'
      or name = '和一牧场'
      or name = '大梁牧场'
      or name = '舍必崖牧场'
      or name = '马群沟牧场'
      or name = '磴口牧场' then '内蒙大区'
      when name = '衡一牧场'
      or name = '衡二牧场'
      or name = '新乐牧场'
      or name = '宿迁牧场' then '华北大区'
  end
  

1. center

   update pasture
   set center =case
   when name = '宝鸡牧场'
   or name = '吴忠牧场'
   or name = '阜民丰牧场'
   or name = '双城牧场'
   or name = '尚志牧场'
   or name = '乌兰牧场'
   or name = '商河牧场'
   or name = '汶上牧场'
   or name = '临沂牧场' then '一中心'
   when name = '察一牧场'
   or name = '察北牧场'
   or name = '察二牧场'
   or name = '恒盛牧场'
   or name = '塞一牧场'
   or name = '塞二牧场'
   or name = '塞三牧场'
   or name = '塞四牧场'
   or name = '塞五牧场'
   or name = '通辽牧场'
   or name = '蚌埠牧场'
   or name = '合肥牧场'
   or name = '马鞍山牧场' then '二中心'
   when name = '和林牧场'
   or name = '洪雅牧场'
   or name = '西藏牧场'
   or name = '眉山牧场'
   or name = '云南牧场'
   or name = '赛罕牧场'
   or name = '托县牧场'
   or name = '和一牧场'
   or name = '大梁牧场'
   or name = '舍必崖牧场'
   or name = '马群沟牧场'
   or name = '磴口牧场'
   or name = '衡一牧场'
   or name = '衡二牧场'
   or name = '新乐牧场'
   or name = '宿迁牧场' then '三中心'
   end 
   

2. region_id

   update pasture 
   set  region_id  = case
   when region = '西北大区' then 1
   when region = '东北大区' then 2
   when region = '华中大区' then 3
   when region = '察北大区' then 4
   when region = '塞北大区' then 5
   when region = '华东大区' then 6
   when region = '蒙云川大区' then 7 
   when region = '内蒙大区' then 8
   when region = '华北大区' then 9
   end
   

3. center_id

   update pasture
   set center_id =case
   when center = '一中心' then 1
   when center = '二中心' then 2
   when center = '三中心' then 3
   end
   

interface

• 设备指标

  {"name":"getChooseEqMonthBudgetListSumAll","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-04","endTime":"2022-07-04","pastureId":18,"departmentId":""}}
  

• 维修费

  {"name":"getChooseMonthWX","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-04","endTime":"2022-07-04","pastureId":18,"departmentId":""}}
  

• 电费

  {"name":"getChooseElectricityPrice","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-05","endTime":"2022-07-05","pastureId":18,"departmentId":""}}
  

• 水费

  {"name":"getChooseWaterPrice","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-05","endTime":"2022-07-05","pastureId":18,"departmentId":""}}
  

• 燃动费(柴油费)

  {"name":"getChooseMonthiolPrice","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-05","endTime":"2022-07-05","pastureId":18,"departmentId":""}}
  

• 燃动动量（柴油量）

  {"name":"getChooseMonthOilT","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-05","endTime":"2022-07-05","pastureId":18,"departmentId":""}}
  

• 电量

  {"name":"getChooseMonthElectricity","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-05","endTime":"2022-07-05","pastureId":18,"departmentId":""}}
  

• 水量

  {"name":"getChooseMonthWater","page":1,"offset":1,"returntype":"Map","parammaps":{"startTime":"2022-07-05","endTime":"2022-07-05","pastureId":18,"departmentId":""}}
  

• 导出 https://tmrwatch.cn:8082/authdata/downloadmailreport

  {"name":"DownloadEquipment","offset":0,"pagecount":0,"parammaps":{"startTime":"2022-02-00","endTime":"2022-03-00","pastureId":"","departmentId":"","deptId":""}}
  

feiqi

dict (revoke)

• add column

  alter table dict 
  add type_name varchar(64) not null default '';
  

• insert

  insert into dict (name, pid, orderby, isAllow, enable, type_name,type_id) 
  values
  ('西北大区', -1, 1, 1, 1, '牧场大区分级',1),
  ('东北大区', -1, 1, 1, 1, '牧场大区分级',2),
  ('华中大区', -1, 1, 1, 1, '牧场大区分级',3),
  ('一中心', -1, 1, 1, 1, '牧场中心分级',1),
  ('察北大区', -1, 1, 1, 1, '牧场大区分级',4),
  ('塞北大区', -1, 1, 1, 1, '牧场大区分级',5),
  ('华东大区', -1, 1, 1, 1, '牧场大区分级',6),
  ('二中心', -1, 1, 1, 1, '牧场中心分级',2),
  ('蒙云川大区', -1, 1, 1, 1, '牧场大区分级',7),
  ('内蒙大区', -1, 1, 1, 1, '牧场大区分级',8),
  ('华北大区', -1, 1, 1, 1, '牧场大区分级',9),
  ('三中心', -1, 1, 1, 1, '牧场中心分级',3)
  

https://eam.modernfarming.cn:8000/authdata/downloadmailreport

{"name":"DownloadEquipment","offset":0,"pagecount":0,"parammaps":{"startTime":"2022-08-02","endTime":"2022-08-02","pastureId":"","departmentId":"","deptId":""}}