glj_controller.js 8.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275
  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 index(request, response) {
  32. // 标段id
  33. let projectId = request.query.project;
  34. projectId = parseInt(projectId);
  35. try {
  36. if (isNaN(projectId) || projectId <= 0) {
  37. throw '标段id有误';
  38. }
  39. // 获取标段对应的单价文件id
  40. let unitPriceFileModel = new UnitPriceFileModel();
  41. let unitPriceFile = await unitPriceFileModel.getDataByProject(projectId);
  42. if (!unitPriceFile) {
  43. throw '没有对应的单价文件';
  44. }
  45. // 单价文件id作为同步的roomId
  46. let unitPriceFileId = unitPriceFile.id;
  47. // 先获取对应标段的项目工料机数据
  48. let gljListModel = new GLJListModel();
  49. let gljList = await gljListModel.getListByProjectId(projectId, unitPriceFileId);
  50. let renderData = {
  51. gljList: JSON.stringify(gljList),
  52. materialIdList: gljListModel.materialIdList,
  53. ownCompositionTypes: gljListModel.ownCompositionTypes,
  54. hostname: request.hostname,
  55. roomId: unitPriceFileId,
  56. GLJTypeConst: JSON.stringify(GLJTypeConst)
  57. };
  58. response.render('glj/html/glj_index', renderData);
  59. } catch (error) {
  60. response.status(404).send('404 Error');
  61. }
  62. }
  63. /**
  64. * 更新数据
  65. *
  66. * @param {object} request
  67. * @param {object} response
  68. * @return {void}
  69. */
  70. async updateData(request, response) {
  71. let field = request.body.field;
  72. let value = request.body.value;
  73. value = value === 'true' ? 1 : value;
  74. value = value === 'false' ? 0 : value;
  75. let id = request.body.id;
  76. let responseData = {
  77. err: 0,
  78. msg: ''
  79. };
  80. try {
  81. // 可编辑的字段
  82. let editableField = ['is_evaluate', 'unit_price.market_price', 'is_adjust_price', 'mix_ratio.consumption'];
  83. if (editableField.indexOf(field) < 0) {
  84. throw '对应字段不能编辑';
  85. }
  86. let modelString = 'glj';
  87. // 切割字段
  88. let fieldArray = field.split('.');
  89. modelString = fieldArray.length > 1 ? fieldArray[0] : modelString;
  90. field = fieldArray.length > 1 ? fieldArray[1] : field;
  91. // 组合数据
  92. let updateData = new Object();
  93. updateData[field] = value;
  94. let result = false;
  95. let model = null;
  96. switch (modelString) {
  97. case 'glj':
  98. model = new GLJListModel();
  99. // 更新数据
  100. result = await model.updateById(id, updateData);
  101. break;
  102. case 'unit_price':
  103. model = new UnitPriceModel();
  104. // 更新数据
  105. result = await model.updatePrice({id: id}, updateData);
  106. break;
  107. case 'mix_ratio':
  108. let marketPrice = request.body.market_price;
  109. let basePrice = request.body.base_price;
  110. model = new MixRatioModel();
  111. result = await model.updateById(id, updateData);
  112. if (result && marketPrice && basePrice) {
  113. // 修改后更新父节点的项目工料机市场单价
  114. let mixRatioData = await model.findDataByCondition({id: id});
  115. if (mixRatioData.length <= 0) {
  116. break;
  117. }
  118. // 更新市场单价和基价单价
  119. let condition = {code: mixRatioData.connect_code, unit_price_file_id: mixRatioData.unit_price_file_id};
  120. let unitPriceUpdate = {
  121. base_price: basePrice,
  122. market_price: marketPrice
  123. };
  124. let unitPriceModel = new UnitPriceModel();
  125. let unitPriceResult = await unitPriceModel.updatePrice(condition, unitPriceUpdate);
  126. if (!unitPriceResult) {
  127. throw '更新单价数据失败';
  128. }
  129. }
  130. break;
  131. }
  132. if (!result) {
  133. throw '更新失败';
  134. }
  135. } catch (error) {
  136. console.log('error:' + error);
  137. responseData.err = 1;
  138. }
  139. response.json(responseData);
  140. }
  141. /**
  142. * 加载配合比相关数据
  143. *
  144. * @return {void}
  145. */
  146. async getMixRatio(request, response) {
  147. let projectGLJId = request.body.id;
  148. let projectId = request.body.project_id;
  149. let responseData = {
  150. err: 0,
  151. data: null
  152. };
  153. try {
  154. // 获取标段对应的单价文件id
  155. let unitPriceFileModel = new UnitPriceFileModel();
  156. let unitPriceFile = await unitPriceFileModel.getDataByProject(projectId);
  157. if (!unitPriceFile) {
  158. throw '没有对应的单价文件';
  159. }
  160. // 单价文件id作为同步的roomId
  161. let unitPriceFileId = unitPriceFile.id;
  162. let gljListModel = new GLJListModel();
  163. let result = await gljListModel.getCompositionList(projectGLJId, unitPriceFileId);
  164. if (result.length <= 0) {
  165. throw '没有找到数据';
  166. }
  167. responseData.data = JSON.stringify(result);
  168. } catch (error) {
  169. console.log(error);
  170. responseData.err = 1;
  171. }
  172. response.json(responseData);
  173. }
  174. /**
  175. * 模拟定额插入
  176. *
  177. * @param {object} request
  178. * @param {object} response
  179. * @return {void}
  180. */
  181. async test(request, response) {
  182. // 从定额库获取的数据
  183. let data = {
  184. glj_id: 801,
  185. project_id: 1,
  186. code: '81040102',
  187. name: 'C15特细砂干硬性混凝土',
  188. specs: 'C15',
  189. unit: 'm³',
  190. type: GLJTypeConst.CONCRETE,
  191. base_price: 323.25,
  192. market_price: 323.25
  193. };
  194. try {
  195. let gljListModel = new GLJListModel();
  196. let result = await gljListModel.addList(data);
  197. } catch (error) {
  198. console.log(error);
  199. }
  200. response.end('success');
  201. }
  202. /**
  203. * 模拟定额修改单价
  204. *
  205. * @param {object} request
  206. * @param {object} response
  207. * @return {void}
  208. */
  209. async testModify(request, response) {
  210. let projectId = request.query.project;
  211. // 修改数据
  212. let updateData = {
  213. code: '00010201',
  214. market_price: '44.42',
  215. name: '土石方综合工日(1)',
  216. project_id: projectId
  217. };
  218. try {
  219. let gljListModel = new GLJListModel();
  220. let result = await gljListModel.modifyMarketPrice(updateData);
  221. console.log(result);
  222. } catch (error) {
  223. console.log(error);
  224. }
  225. response.end('success');
  226. }
  227. /**
  228. * 测试删除
  229. *
  230. * @param {object} request
  231. * @param {object} response
  232. * @return {void}
  233. */
  234. async delete(request, response) {
  235. try {
  236. let gljListModel = new GLJListModel();
  237. let result = await gljListModel.deleteById(63);
  238. console.log(result);
  239. } catch (error) {
  240. console.log(error);
  241. }
  242. response.end('success');
  243. }
  244. }
  245. export default GLJController;