glj_controller.js 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318
  1. /**
  2. * 工料机相关控制器
  3. *
  4. * @author CaiAoLin
  5. * @date 2017/6/22
  6. * @version
  7. */
  8. import BaseController from "../../common/base/base_controller";
  9. import GLJTypeConst from "../../common/const/glj_type_const";
  10. import GLJListModel from "../models/glj_list_model";
  11. import UnitPriceModel from "../models/unit_price_model";
  12. import UnitPriceFileModel from "../models/unit_price_file_model";
  13. import MixRatioModel from "../models/mix_ratio_model";
  14. class GLJController extends BaseController {
  15. /**
  16. * 构造函数
  17. *
  18. * @return {void}
  19. */
  20. constructor() {
  21. let parent = super();
  22. parent.title = '工料机';
  23. }
  24. /**
  25. * 获取工料机相关数据
  26. *
  27. * @param {object} request
  28. * @param {object} response
  29. * @return {void}
  30. */
  31. async getGljList(request, response) {
  32. // 标段id
  33. let projectId = request.body.project_id;
  34. projectId = parseInt(projectId);
  35. let responseData = {
  36. err: 0,
  37. msg: '',
  38. data: {}
  39. };
  40. try {
  41. if (isNaN(projectId) || projectId <= 0) {
  42. throw '标段id有误';
  43. }
  44. // 获取标段对应的单价文件id
  45. let unitPriceFileModel = new UnitPriceFileModel();
  46. let unitPriceFile = await unitPriceFileModel.getDataByProject(projectId);
  47. if (!unitPriceFile) {
  48. throw '没有对应的单价文件';
  49. }
  50. // 单价文件id作为同步的roomId
  51. let unitPriceFileId = unitPriceFile.id;
  52. // 先获取对应标段的项目工料机数据
  53. let gljListModel = new GLJListModel();
  54. let [gljList, mixRatioConnectData] = await gljListModel.getListByProjectId(projectId, unitPriceFileId);
  55. responseData.data.gljList = gljList;
  56. responseData.data.mixRatioConnectData = mixRatioConnectData;
  57. responseData.data.constData = {
  58. materialIdList: gljListModel.materialIdList,
  59. ownCompositionTypes: gljListModel.ownCompositionTypes,
  60. hostname: request.hostname,
  61. roomId: unitPriceFileId,
  62. GLJTypeConst: JSON.stringify(GLJTypeConst),
  63. };
  64. } catch (error) {
  65. responseData.err = 1;
  66. responseData.msg = error;
  67. }
  68. response.json(responseData);
  69. }
  70. /**
  71. * 更新数据
  72. *
  73. * @param {object} request
  74. * @param {object} response
  75. * @return {void}
  76. */
  77. async updateData(request, response) {
  78. let field = request.body.field;
  79. let value = request.body.value;
  80. value = value === 'true' ? 1 : value;
  81. value = value === 'false' ? 0 : value;
  82. let id = request.body.id;
  83. let responseData = {
  84. err: 0,
  85. msg: ''
  86. };
  87. try {
  88. // 可编辑的字段
  89. let editableField = ['is_evaluate', 'unit_price.market_price', 'is_adjust_price', 'mix_ratio.consumption'];
  90. if (editableField.indexOf(field) < 0) {
  91. throw '对应字段不能编辑';
  92. }
  93. let modelString = 'glj';
  94. // 切割字段
  95. let fieldArray = field.split('.');
  96. modelString = fieldArray.length > 1 ? fieldArray[0] : modelString;
  97. field = fieldArray.length > 1 ? fieldArray[1] : field;
  98. // 组合数据
  99. let updateData = new Object();
  100. updateData[field] = value;
  101. let result = false;
  102. let model = null;
  103. switch (modelString) {
  104. case 'glj':
  105. model = new GLJListModel();
  106. // 更新数据
  107. result = await model.updateById(id, updateData);
  108. break;
  109. case 'unit_price':
  110. let extend = request.body.extend;
  111. model = new UnitPriceModel();
  112. // 更新数据
  113. result = await model.updatePrice({id: id}, updateData, extend);
  114. break;
  115. case 'mix_ratio':
  116. let marketPrice = request.body.market_price;
  117. let basePrice = request.body.base_price;
  118. model = new MixRatioModel();
  119. result = await model.updateById(id, updateData);
  120. if (result && marketPrice && basePrice) {
  121. // 修改后更新父节点的项目工料机市场单价
  122. let mixRatioData = await model.findDataByCondition({id: id});
  123. if (mixRatioData.length <= 0) {
  124. break;
  125. }
  126. // 更新市场单价和基价单价
  127. let condition = {code: mixRatioData.connect_code, unit_price_file_id: mixRatioData.unit_price_file_id};
  128. let unitPriceUpdate = {
  129. base_price: basePrice,
  130. market_price: marketPrice
  131. };
  132. let unitPriceModel = new UnitPriceModel();
  133. let unitPriceResult = await unitPriceModel.updatePrice(condition, unitPriceUpdate);
  134. if (!unitPriceResult) {
  135. throw '更新单价数据失败';
  136. }
  137. }
  138. break;
  139. }
  140. if (!result) {
  141. throw '更新失败';
  142. }
  143. } catch (error) {
  144. console.log('error:' + error);
  145. responseData.err = 1;
  146. }
  147. response.json(responseData);
  148. }
  149. /**
  150. * 加载配合比相关数据
  151. *
  152. * @return {void}
  153. */
  154. async getRatio(request, response) {
  155. let projectGLJId = request.body.id;
  156. let projectId = request.body.project_id;
  157. let responseData = {
  158. err: 0,
  159. data: null
  160. };
  161. try {
  162. // 获取标段对应的单价文件id
  163. let unitPriceFileModel = new UnitPriceFileModel();
  164. let unitPriceFile = await unitPriceFileModel.getDataByProject(projectId);
  165. if (!unitPriceFile) {
  166. throw '没有对应的单价文件';
  167. }
  168. // 单价文件id作为同步的roomId
  169. let unitPriceFileId = unitPriceFile.id;
  170. let gljListModel = new GLJListModel();
  171. let result = await gljListModel.getCompositionList(projectGLJId, unitPriceFileId);
  172. if (result.length <= 0) {
  173. throw '没有找到数据';
  174. }
  175. responseData.data = JSON.stringify(result);
  176. } catch (error) {
  177. console.log(error);
  178. responseData.err = 1;
  179. }
  180. response.json(responseData);
  181. }
  182. /**
  183. * 删除配合比数据
  184. *
  185. * @param {object} request
  186. * @param {object} response
  187. * @return {void}
  188. */
  189. async deleteMixRatio(request, response) {
  190. let id = request.body.id;
  191. id = parseInt(id);
  192. let responseData = {
  193. err: 0,
  194. msg: ''
  195. };
  196. try {
  197. if (isNaN(id) || id <= 0) {
  198. throw '参数错误';
  199. }
  200. let mixRatioModel = new MixRatioModel();
  201. let result = await mixRatioModel.deleteById(id);
  202. if (!result) {
  203. throw '删除失败';
  204. }
  205. } catch (error) {
  206. responseData.err = 1;
  207. responseData.msg = error;
  208. }
  209. response.json(responseData);
  210. }
  211. /**
  212. * 模拟定额插入
  213. *
  214. * @param {object} request
  215. * @param {object} response
  216. * @return {void}
  217. */
  218. async test(request, response) {
  219. // 从定额库获取的数据
  220. let data = {
  221. glj_id: 17,
  222. project_id: 1,
  223. code: '00010201',
  224. name: '土石方综合工日',
  225. specs: '',
  226. unit: '工日',
  227. type: GLJTypeConst.LABOUR,
  228. base_price: 50,
  229. market_price: 50
  230. };
  231. try {
  232. let gljListModel = new GLJListModel();
  233. let result = await gljListModel.addList(data);
  234. } catch (error) {
  235. console.log(error);
  236. }
  237. response.end('success');
  238. }
  239. /**
  240. * 模拟定额修改单价
  241. *
  242. * @param {object} request
  243. * @param {object} response
  244. * @return {void}
  245. */
  246. async testModify(request, response) {
  247. let projectId = request.query.project;
  248. // 修改数据
  249. let updateData = {
  250. code: '36290101',
  251. market_price: '13',
  252. name: '水(10)',
  253. project_id: projectId
  254. };
  255. try {
  256. let gljListModel = new GLJListModel();
  257. let result = await gljListModel.modifyMarketPrice(updateData);
  258. console.log(result);
  259. } catch (error) {
  260. console.log(error);
  261. }
  262. response.end('success');
  263. }
  264. /**
  265. * 测试删除
  266. *
  267. * @param {object} request
  268. * @param {object} response
  269. * @return {void}
  270. */
  271. async delete(request, response) {
  272. try {
  273. let gljListModel = new GLJListModel();
  274. let result = await gljListModel.deleteById(63);
  275. console.log(result);
  276. } catch (error) {
  277. console.log(error);
  278. }
  279. response.end('success');
  280. }
  281. }
  282. export default GLJController;