qingdan.html 57 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163
  1. <!DOCTYPE html>
  2. <html lang="zh-CN">
  3. <head>
  4. <meta charset="utf-8">
  5. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  6. <meta http-equiv="x-ua-compatible" content="ie=edge">
  7. <title>清单规则编辑器</title>
  8. <link rel="stylesheet" href="/lib/bootstrap/css/bootstrap.min.css">
  9. <link rel="stylesheet" href="/web/maintain/bills_lib/css/main.css">
  10. <link rel="stylesheet" href="/lib/font-awesome/font-awesome.min.css">
  11. <link rel="stylesheet" href="/lib/jquery-contextmenu/jquery.contextMenu.css">
  12. <!--spread-->
  13. <link rel="stylesheet" href="/lib/spreadjs/sheets/css/gc.spread.sheets.sc.css">
  14. <link rel="stylesheet" href="/lib/codemirror/codemirror.css">
  15. <link rel="stylesheet" href="/lib/codemirror/material.css">
  16. </head>
  17. <body>
  18. <div class="header">
  19. <nav class="navbar navbar-toggleable-lg navbar-light bg-faded p-0 ">
  20. <span class="header-logo px-2">清单规则编辑器</span>
  21. <div class="navbar-text"></div>
  22. </nav>
  23. <nav class="navbar navbar-toggleable-lg justify-content-between navbar-light p-0">
  24. <ul class="nav nav-tabs" role="tablist">
  25. <li class="nav-item">
  26. <a class="nav-link active px-3" href="javascript: void(0);">清单</a>
  27. </li>
  28. <li class="nav-item">
  29. <a id="aStdJobs" class="nav-link px-3" href="stdJobs">工作内容</a>
  30. </li>
  31. <li class="nav-item">
  32. <a id="aStdItems" class="nav-link px-3" href="stdItems">项目特征</a>
  33. </li>
  34. </ul>
  35. </nav>
  36. </div>
  37. <div class="main">
  38. <div class="content" >
  39. <div class="container-fluid">
  40. <div class="row">
  41. <div class="main-content col-lg-7 p-0">
  42. <nav class="navbar sticky-top navbar-toggleable-md navbar-light bg-faded tools-bar">
  43. <div class="collapse navbar-collapse" id="navbarNav">
  44. <ul class="navbar-nav">
  45. <li class="nav-item">
  46. <a class="nav-link text-primary lock-btn-control" doing="false" fcsOnBills="true" id="insert" href="javascript: void(0);"><i class="fa fa-share" aria-hidden="true"></i>插入</a>
  47. </li>
  48. <li class="nav-item">
  49. <input class="lock-btn-control" style="width: 50px; height: 24px;margin-top:5px" id="insert_row" type="text" value="1" type="number" min="1" step="1" />
  50. </li>
  51. <li class="nav-item">
  52. <a class="nav-link text-primary lock-btn-control" doing="false" fcsOnBills="true" id ="delete" href="javascript:void (0)"><i class="fa fa-remove" aria-hidden="true"></i>删除</a>
  53. </li>
  54. <li class="nav-item">
  55. <a class="nav-link text-primary lock-btn-control" doing="false" fcsOnBills="true" id="upLevel" href="javascript: void(0);"><i class="fa fa-arrow-left" aria-hidden="true"></i>升级</a>
  56. </li>
  57. <li class="nav-item">
  58. <a class="nav-link text-primary lock-btn-control" doing="false" fcsOnBills="true" id="downLevel" href="javascript: void(0);"><i class="fa fa-arrow-right" aria-hidden="true"></i>降级</a>
  59. </li>
  60. <li class="nav-item">
  61. <a class="nav-link text-primary lock-btn-control" doing="false" fcsOnBills="true" canMove="false" id="upMove" href="javascript: void(0);"><i class="fa fa-arrow-up" aria-hidden="true"></i>上移</a>
  62. </li>
  63. <li class="nav-item">
  64. <a class="nav-link text-primary lock-btn-control" doing="false" fcsOnBills="true" canMove="false" id="downMove" href="javascript: void(0);"><i class="fa fa-arrow-down" aria-hidden="true"></i>下移</a>
  65. </li>
  66. </ul>
  67. </div>
  68. </nav>
  69. <div class="main-data" id="spreadBills">
  70. </div>
  71. </div>
  72. <div class="main-side col-lg-5 p-0">
  73. <div class="container-fluid" style="overflow: auto; height: 100%">
  74. <div style="width:50%; height: 330px; float: left;">
  75. <h5>工作内容</h5>
  76. <div id="spreadJobs" class="ovf-hidden" style="width:97%; height: 300px;"></div>
  77. </div>
  78. <div style="width:50%; height: 330px; float: left;">
  79. <h5>项目特征</h5>
  80. <div id="spreadItems" class="ovf-hidden" style="width: 97%; height: 300px;"></div>
  81. </div>
  82. <!-- <div class="form-group">
  83. <a class="pull-right" href="javacript:void(0);" data-toggle="modal" data-target="#help" >html怎么写?</a>
  84. <label for="exampleTextarea">补注:</label>
  85. <textarea id="exampleTextarea" name="editor" class="form-control" rows="8"></textarea>
  86. </div>-->
  87. <div class="form-group">
  88. <a class="pull-right" href="javacript:void(0);" data-toggle="modal" data-target="#help" >html怎么写?</a>
  89. <a trigger="billsRecharge" class="pull-right mr-3 uploadImgTrigger lock-btn-control" href="javacript:void(0);" data-toggle="modal" data-target="#uploadimg" ><i class="fa fa-image"></i>上传图片</a>
  90. <label for="exampleTextarea">补注:</label>
  91. <textarea class="form-control" id="exampleTextarea" rows="8"></textarea>
  92. <div>
  93. <label for="erratumRecordText">勘误记录:</label>
  94. <textarea class="form-control lock-btn-control" id="erratumRecordText" rows="8" style="height: calc(100% - 38px);"></textarea>
  95. </div>
  96. </div>
  97. <!-- <div class="row">
  98. <div class="col ovf-hidden" style="width:50%; height: 100%; float: left;">
  99. <h5>工作内容</h5>
  100. <div id="spreadJobs" style="width:97%; height: 300px;"></div>
  101. </div>
  102. <div class="col" style="width:50%; height: 100%; float: left;">
  103. <h5>项目特征</h5>
  104. <div id="spreadItems" class="ovf-hidden" style="width: 97%; height: 300px;"></div>
  105. </div>
  106. <div class="w-100"></div>
  107. <div class="col">
  108. <div class="form-group">
  109. <label for="exampleTextarea"><h5>补注:</h5></label>
  110. <textarea class="form-control" id="exampleTextarea" rows="8"></textarea>
  111. </div>
  112. </div>
  113. </div>-->
  114. </div>
  115. </div>
  116. </div>
  117. </div>
  118. </div>
  119. </div>
  120. <!--弹出添加-->
  121. <div class="modal fade" id="add" data-backdrop="static" style="display: none;" aria-hidden="true">
  122. <div class="modal-dialog" role="document">
  123. <div class="modal-content">
  124. <div class="modal-header">
  125. <h5 class="modal-title">添加定额</h5>
  126. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  127. <span aria-hidden="true">×</span>
  128. </button>
  129. </div>
  130. <div class="modal-body">
  131. <form>
  132. <div class="form-group">
  133. <label>编码</label>
  134. <input class="form-control" placeholder="输入编码" type="text">
  135. </div>
  136. <div class="form-group">
  137. <label>名称</label>
  138. <input class="form-control" placeholder="输入名称" type="text">
  139. </div>
  140. <div class="form-group">
  141. <label>单位</label>
  142. <select class="form-control"><option>选择单位</option><option>m3</option></select>
  143. </div>
  144. <div class="form-group">
  145. <label>基价</label>
  146. <input class="form-control" placeholder="输入基价" type="number">
  147. </div>
  148. <div class="form-group">
  149. <label>显示名称(以%s表示参数)</label>
  150. <input class="form-control" placeholder="输入显示名称" type="text">
  151. </div>
  152. <div class="form-group">
  153. <label>默认取费专业</label>
  154. <input class="form-control" placeholder="输入取费专业" type="text">
  155. </div>
  156. </form>
  157. </div>
  158. <div class="modal-footer">
  159. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  160. <a href="" class="btn btn-primary">添加</a>
  161. </div>
  162. </div>
  163. </div>
  164. </div>
  165. <!--弹出编辑-->
  166. <div class="modal fade" id="edit" data-backdrop="static" style="display: none;" aria-hidden="true">
  167. <div class="modal-dialog" role="document">
  168. <div class="modal-content">
  169. <div class="modal-header">
  170. <h5 class="modal-title">编辑定额</h5>
  171. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  172. <span aria-hidden="true">×</span>
  173. </button>
  174. </div>
  175. <div class="modal-body">
  176. <form>
  177. <div class="form-group">
  178. <label>编码</label>
  179. <input class="form-control" placeholder="输入编码" type="text" value="AA0001">
  180. </div>
  181. <div class="form-group">
  182. <label>名称</label>
  183. <input class="form-control" placeholder="输入名称" type="text" value="人工挖土方">
  184. </div>
  185. <div class="form-group">
  186. <label>单位</label>
  187. <select class="form-control"><option>m3</option></select>
  188. </div>
  189. <div class="form-group">
  190. <label>基价</label>
  191. <input class="form-control" placeholder="输入基价" type="number" value="880.84">
  192. </div>
  193. <div class="form-group">
  194. <label>显示名称(以%s表示参数)</label>
  195. <input class="form-control" placeholder="输入显示名称" type="text" value="人工挖土方">
  196. </div>
  197. <div class="form-group">
  198. <label>默认取费专业</label>
  199. <input class="form-control" placeholder="输入取费专业" type="text" value="1">
  200. </div>
  201. </form>
  202. </div>
  203. <div class="modal-footer">
  204. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  205. <a href="" class="btn btn-primary">确定</a>
  206. </div>
  207. </div>
  208. </div>
  209. </div>
  210. <!--弹出删除-->
  211. <div class="modal fade" id="del" data-backdrop="static" style="display: none;" aria-hidden="true">
  212. <div class="modal-dialog" role="document">
  213. <div class="modal-content">
  214. <div class="modal-header">
  215. <h5 class="modal-title">删除确认</h5>
  216. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  217. <span aria-hidden="true">×</span>
  218. </button>
  219. </div>
  220. <div class="modal-body">
  221. <h5 class="text-danger">删除后无法恢复,确认是否删除?</h5>
  222. </div>
  223. <div class="modal-footer">
  224. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  225. <a href="" class="btn btn-danger">删除</a>
  226. </div>
  227. </div>
  228. </div>
  229. </div>
  230. <!--弹出提示窗口-->
  231. <button id="alertBtn" class="btn btn-primary btn-lg" data-toggle="modal" data-target="#alertDiv" style="display: none"></button>
  232. <div class="modal fade" id="alertDiv" data-backdrop="static" style="display: none;" aria-hidden="true">
  233. <input type="hidden" value="123">
  234. <div class="modal-dialog" role="document">
  235. <div class="modal-content">
  236. <div class="modal-header">
  237. <h5 class="modal-title">警告</h5>
  238. <button type="button" id="alertCls" class="close" data-dismiss="modal" aria-label="Close">
  239. <span aria-hidden="true">×</span>
  240. </button>
  241. </div>
  242. <div class="modal-body">
  243. <h5 class="text-danger" id="alertTxt">编号不存在,请重新输入!</h5>
  244. </div>
  245. <div class="modal-footer">
  246. <button type="button" class="btn btn-danger" id="alertCof" data-dismiss="modal">确认</button>
  247. </div>
  248. </div>
  249. </div>
  250. </div>
  251. <!--删除-->
  252. <div class="modal fade" id="delAlert" data-backdrop="static" style="display: none;" aria-hidden="true">
  253. <input type="hidden" value="123">
  254. <div class="modal-dialog" role="document">
  255. <div class="modal-content">
  256. <div class="modal-header">
  257. <h5 class="modal-title">警告</h5>
  258. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  259. <span aria-hidden="true">×</span>
  260. </button>
  261. </div>
  262. <div class="modal-body">
  263. <h5 class="text-danger" id="delText">是否删除当前清单及其子项?</h5>
  264. </div>
  265. <div class="modal-footer">
  266. <button type="button" class="btn btn-danger" id="delConfirm">确认</button>
  267. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  268. </div>
  269. </div>
  270. </div>
  271. </div>
  272. <!--弹出html填写帮助-->
  273. <!--弹出html填写帮助-->
  274. <div class="modal fade" id="help" style="display: none;" aria-hidden="true">
  275. <div class="modal-dialog" role="document">
  276. <div class="modal-content">
  277. <div class="modal-header">
  278. <h5 class="modal-title">html填写帮助</h5>
  279. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  280. <span aria-hidden="true">×</span>
  281. </button>
  282. </div>
  283. <div class="modal-body">
  284. <p class="text-primary">&lt;p&gt;这是一行文本&lt;/p&gt;</p>
  285. <p class="mb-0">文本居中:text-center</p>
  286. <p class="text-primary">&lt;p class="text-center" &gt;这是一行文本&lt;/p&gt;</p>
  287. <p class="mb-0">文本居右:text-right</p>
  288. <p class="text-primary">&lt;p class="text-right" &gt;这是一行文本&lt;/p&gt;</p>
  289. <p class="mb-0">文本居左(默认已居左):text-left</p>
  290. <p class="text-primary">&lt;p class="text-left" &gt;这是一行文本&lt;/p&gt;</p>
  291. <p class="mb-0">表格:table、tr、th、td</p>
  292. <p class="mb-0 text-primary">&lt;table&gt;</p>
  293. <p class="mb-0 text-primary">&lt;tr&gt;&lt;th&gt;表头1&lt;/th&gt;&lt;th&gt;表头2&lt;/th&gt;&lt;th&gt;表头3&lt;/th&gt;&lt;/tr&gt;</p>
  294. <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容1&lt;/td&gt;&lt;td&gt;内容2&lt;/td&gt;&lt;td&gt;内容3&lt;/td&gt;&lt;/tr&gt;</p>
  295. <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容4&lt;/td&gt;&lt;td&gt;内容5&lt;/td&gt;&lt;td&gt;内容6&lt;/td&gt;&lt;/tr&gt;</p>
  296. <p class="mb-0 text-primary">&lt;/table&gt;</p>
  297. <p>
  298. <table class="table table-sm table-bordered">
  299. <tr><th>表头1</th><th>表头2</th><th>表头3</th></tr>
  300. <tr><td>内容1</td><td>内容2</td><td>内容3</td></tr>
  301. <tr><td>内容4</td><td>内容5</td><td>内容6</td></tr>
  302. </table>
  303. </p>
  304. <p class="mb-0">合并横向单元格(2格):colspan="2"</p>
  305. <p class="mb-0 text-primary">&lt;table&gt;</p>
  306. <p class="mb-0 text-primary">&lt;tr&gt;&lt;th colspan="2"&gt;表头1表头2&lt;/th&gt;&lt;th&gt;表头3&lt;/th&gt;&lt;/tr&gt;</p>
  307. <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容1&lt;/td&gt;&lt;td&gt;内容2&lt;/td&gt;&lt;td&gt;内容3&lt;/td&gt;&lt;/tr&gt;</p>
  308. <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容4&lt;/td&gt;&lt;td&gt;内容5&lt;/td&gt;&lt;td&gt;内容6&lt;/td&gt;&lt;/tr&gt;</p>
  309. <p class="mb-0 text-primary">&lt;/table&gt;</p>
  310. <p>
  311. <table class="table table-sm table-bordered">
  312. <tr><th colspan="2">表头1表头2</th><th>表头3</th></tr>
  313. <tr><td>内容1</td><td>内容2</td><td>内容3</td></tr>
  314. <tr><td>内容4</td><td>内容5</td><td>内容6</td></tr>
  315. </table>
  316. </p>
  317. <p class="mb-0">合并竖向单元格(2格):rowspan="2"</p>
  318. <p class="mb-0 text-primary">&lt;table&gt;</p>
  319. <p class="mb-0 text-primary">&lt;tr&gt;&lt;th&gt;表头1&lt;/th&gt;&lt;th&gt;表头2&lt;/th&gt;&lt;th&gt;表头3&lt;/th&gt;&lt;/tr&gt;</p>
  320. <p class="mb-0 text-primary">&lt;tr&gt;&lt;td rowspan="2"&gt;内容1内容4&lt;/td&gt;&lt;td&gt;内容2&lt;/td&gt;&lt;td&gt;内容3&lt;/td&gt;&lt;/tr&gt;</p>
  321. <p class="mb-0 text-primary">&lt;tr&gt;&lt;td&gt;内容5&lt;/td&gt;&lt;td&gt;内容6&lt;/td&gt;&lt;/tr&gt;</p>
  322. <p class="mb-0 text-primary">&lt;/table&gt;</p>
  323. <p>
  324. <table class="table table-sm table-bordered">
  325. <tr><th>表头1</th><th>表头2</th><th>表头3</th></tr>
  326. <tr><td rowspan="2">内容1内容4</td><td>内容2</td><td>内容3</td></tr>
  327. <tr><td>内容5</td><td>内容6</td></tr>
  328. </table>
  329. </p>
  330. </div>
  331. <div class="modal-footer">
  332. <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
  333. </div>
  334. </div>
  335. </div>
  336. </div>
  337. <%include ../../../common/html/uploadImg.html %>
  338. <!-- JS. -->
  339. <script src = "/lib/spreadjs/sheets/gc.spread.sheets.all.11.1.2.min.js"></script>
  340. <script src = "/lib/localforage/localforage.min.js"></script>
  341. <script src="/public/common_util.js"></script>
  342. <script>GC.Spread.Sheets.LicenseKey = '<%- LicenseKey %>';</script>
  343. <script src="/public/web/uuid.js"></script>
  344. <script src="/lib/jquery/jquery.min.js"></script>
  345. <script src="/lib/tether/tether.min.js"></script>
  346. <script src="/lib/jquery-contextmenu/jquery.contextMenu.min.js"></script>
  347. <script src="/lib/jquery-contextmenu/jquery.ui.position.js"></script>
  348. <script src="/lib/bootstrap/bootstrap.min.js"></script>
  349. <script src="/web/maintain/bills_lib/scripts/global.js"></script>
  350. <script src="/public/web/PerfectLoad.js"></script>
  351. <script src="/public/web/common_ajax.js"></script>
  352. <script src="/public/web/lock_util.js"></script>
  353. <script src="/public/web/sheet/sheet_common.js"></script>
  354. <script type="text/javascript" src="/public/web/sheet/sheet_data_helper.js"></script>
  355. <script src="/web/maintain/bills_lib/scripts/set_sheets.js"></script>
  356. <script src="/web/maintain/bills_lib/scripts/bills_lib_ajax.js"></script>
  357. <!--idTree-->
  358. <script src="/public/web/id_tree.js"></script>
  359. <script src="/public/web/tree_sheet/tree_sheet_controller.js"></script>
  360. <script src="/public/web/tree_sheet/tree_sheet_helper.js"></script>
  361. <script src="/web/maintain/bills_lib/scripts/bills_lib_setting.js"></script>
  362. <script src="/web/maintain/bills_lib/scripts/bills_lib_tree.js"></script>
  363. <script src="/web/maintain/bills_lib/scripts/db_controller.js"></script>
  364. <script src="/web/maintain/bills_lib/scripts/tools.js"></script>
  365. <script src="/lib/codemirror/codemirror.js"></script>
  366. <script src="/lib/codemirror/xml.js"></script>
  367. <script src="/web/common/js/uploadImg.js"></script>
  368. </body>
  369. <script type="text/javascript">
  370. const locked = lockUtil.getLocked();
  371. var codeEditor = CodeMirror.fromTextArea(document.getElementById("exampleTextarea"), {
  372. mode: "text/html",
  373. lineNumbers: true,
  374. theme:"material",
  375. readOnly: locked
  376. });
  377. codeEditor.setSize('auto','350px');
  378. const erratumRecordEditor = CodeMirror.fromTextArea(document.getElementById("erratumRecordText"), {
  379. mode: "text/html",
  380. lineNumbers: true,
  381. theme:"material",
  382. readOnly: locked
  383. });
  384. erratumRecordEditor.setSize('auto','350px');
  385. autoFlashHeight();
  386. let BillsFixedFlagList = JSON.parse('<%- BillsFixedFlagList %>');
  387. // 清单类型下拉
  388. const kindList = [{ name: '分部', value: 2 }, { name: '清单', value: 3 }];
  389. let userAccount = '<%= userAccount %>';
  390. let maxJobsNumber;
  391. let maxItemsNumber;
  392. let orgJobData;
  393. let orgItemData;
  394. let billsTree = billsLibTree.createBillsTree();
  395. let billsLibId = getQueryString("billsLibId");
  396. let sheetDatas;
  397. let sheetItemsDatas;
  398. let sheetBillsDatas;
  399. tools.redirect(billsLibId, 'stdBillsmain');
  400. let billsSpread;
  401. let jobsSpread = new GC.Spread.Sheets.Workbook($("#spreadJobs")[0], {sheetCount: 1});
  402. jobsSpread.options.allowUserDragFill = false;
  403. sheetCommonObj.bindEscKey(jobsSpread, [{sheet: jobsSpread.getSheet(0), editStarting: jobsController.onEditStart, editEnded: jobsController.onEditEnded}]);
  404. let itemsSpread = new GC.Spread.Sheets.Workbook($("#spreadItems")[0], {sheetCount: 1});
  405. itemsSpread.options.allowUserDragFill = false;
  406. sheetCommonObj.bindEscKey(itemsSpread, [{sheet: itemsSpread.getSheet(0), editStarting: itemsController.onEditStart, editEnded: itemsController.onEditEnded}]);
  407. $(document).ready(function(){
  408. $("#aStdJobs").attr('href', function(){
  409. return `stdJobs?billsLibId=${billsLibId}&locked=${locked}`;
  410. });
  411. $('#aStdItems').attr('href', function(){
  412. return `stdItems?billsLibId=${billsLibId}&locked=${locked}`;
  413. });
  414. billsAjax.getStdBillsLibName(billsLibId);
  415. billsAjax.getBills(billsLibId, function(bills){
  416. showBillsSheet(bills, jobsSpread.getActiveSheet(), itemsSpread.getActiveSheet(), billsLibSetting)
  417. const spreads = [billsSpread, jobsSpread, itemsSpread];
  418. const $range = $(document.body);
  419. lockUtil.lockSpreadsAndTools(spreads, $range, locked);
  420. });
  421. buildJobs(jobsSpread, jobsSetting);
  422. buildItems(itemsSpread, itemsSetting);
  423. });
  424. function nodeOpration(controller, totalJobs, totalItems){
  425. let btnInsert = $('#insert');
  426. let btnDelete = $('#delete');
  427. let btnUpLevel = $('#upLevel');
  428. let btnDownLevel = $('#downLevel');
  429. let btnUpMove = $('#upMove');
  430. let btnDownMove = $('#downMove');
  431. dbController.editData(controller);
  432. function onInsert(){
  433. if(btnInsert.attr('doing') === 'false' && btnInsert.attr('fcsOnBills') === 'true'){
  434. let btnInsertRow = $('#insert_row').val();
  435. if (isNaN(btnInsertRow) || btnInsertRow < 1) {
  436. alert(`请输入正确的行数。`);
  437. $('#insert_row').val('1');
  438. return;
  439. }
  440. btnInsertRow = parseInt(btnInsertRow) ;
  441. dbController.insert(controller, btnInsert,btnInsertRow);
  442. tools.clearData(jobsSpread.getActiveSheet());
  443. tools.clearData(itemsSpread.getActiveSheet());
  444. }
  445. }
  446. btnInsert.click(function(){
  447. onInsert()
  448. });
  449. $('#insert_row').on('keypress', function(e) {
  450. // 检查是否按下的是 Enter 键(keyCode 13 或 which 13)
  451. if (e.which === 13 || e.keyCode === 13) {
  452. onInsert()
  453. }
  454. });
  455. //删除清单
  456. $('#delConfirm').click(function () {
  457. dbController.delete(controller, btnDelete, totalJobs, totalItems);
  458. $('#delAlert').modal('hide');
  459. });
  460. btnDelete.click(function(){
  461. if(btnDelete.attr('doing') === 'false' && btnDelete.attr('fcsOnBills') === 'true'){
  462. $('#delAlert').modal('show');
  463. }
  464. });
  465. btnUpLevel.click(function(){
  466. if(btnUpLevel.attr('doing') === 'false' && btnUpLevel.attr('fcsOnBills') === 'true'){
  467. dbController.upLevel(controller, btnUpLevel);
  468. }
  469. });
  470. btnDownLevel.click(function(){
  471. if(btnDownLevel.attr('doing') === 'false' && btnDownLevel.attr('fcsOnBills') === 'true'){
  472. dbController.downLevel(controller, btnDownLevel);
  473. }
  474. });
  475. btnUpMove.click(function(){
  476. if(btnUpMove.attr('doing') === 'false' && btnUpMove.attr('fcsOnBills') === 'true'){
  477. dbController.upMove(controller, btnUpMove);
  478. }
  479. //refSheet
  480. else if(btnUpMove.attr('doing') === 'false' && btnUpMove.attr('fcsOnBills') === 'false' && btnUpMove.attr('canMove') === 'true'){
  481. if(controller.tree.selected.field === 'job'){
  482. jobsController.upMove(controller, jobsSpread.getActiveSheet());
  483. }
  484. else if(controller.tree.selected.field === 'item'){
  485. itemsController.upMove(controller, itemsSpread.getActiveSheet());
  486. }
  487. }
  488. });
  489. btnDownMove.click(function(){
  490. if(btnDownMove.attr('doing') === 'false' && btnDownMove.attr('fcsOnBills') === 'true'){
  491. dbController.downMove(controller, btnDownMove);
  492. }
  493. else if(btnDownMove.attr('doing') === 'false' && btnDownMove.attr('fcsOnBills') === 'false' && btnDownMove.attr('canMove') === 'true'){
  494. if(controller.tree.selected.field === 'job'){
  495. jobsController.downMove(controller, jobsSpread.getActiveSheet());
  496. }
  497. else if(controller.tree.selected.field === 'item'){
  498. itemsController.downMove(controller, itemsSpread.getActiveSheet());
  499. }
  500. }
  501. });
  502. }
  503. function setCombo(sheet, col, comboDatas) {
  504. sheet.suspendPaint();
  505. sheet.suspendEvent();
  506. let combo = sheetCommonObj.getDynamicCombo();
  507. combo.items(comboDatas).itemHeight(10).editable(false);
  508. sheet.getRange(-1, col, -1, 1).cellType(combo);
  509. sheet.resumePaint();
  510. sheet.resumeEvent();
  511. }
  512. // 获取清单类型名称
  513. function getKindName(kind) {
  514. return (kindList.find(item => item.value === kind))?.name || '';
  515. }
  516. function showBillsSheet(datas, jobsSheet, itemsSheet, setting) {
  517. billsSpread = new GC.Spread.Sheets.Workbook($('#spreadBills')[0], {sheetCount: 1});
  518. let billsSheet = billsSpread.getSheet(0);
  519. billsSheet.frozenColumnCount(2);
  520. sheetCommonObj.bindEscKey(billsSpread, [{sheet: billsSpread.getSheet(0), editStarting: dbController.onEditStart, editEnded: dbController.onEditEnded}]);
  521. billsSpread.focus(true);
  522. setSheet.initSheet(billsSpread, setting, true);
  523. myKey.delKey(billsSpread);
  524. for (let data of datas) {
  525. if (data.fixedFlag) {
  526. let findData = BillsFixedFlagList.find((x) => data.fixedFlag === x.value);
  527. if (findData) {
  528. data.fixedFlag = findData.name;
  529. }
  530. }
  531. if (data.kind) {
  532. data.kind = getKindName(data.kind);
  533. }
  534. }
  535. billsTree.loadDatas(datas);
  536. let controller = TREE_SHEET_CONTROLLER.createNew(billsTree.tree, billsSpread.getActiveSheet(), setting);
  537. controller.showTreeData();
  538. dbController.controller = controller;
  539. sheetBillsDatas = tools.getsheetDatas(controller.sheet, 'bills', controller);
  540. setSheet.formatter(billsSpread.getActiveSheet());
  541. const codeCol = setting.cols.findIndex(item => item.data.field ==='code');
  542. billsSheet.setFormatter(-1, codeCol, '@', GC.Spread.Sheets.SheetArea.viewport);
  543. //setTagId
  544. setTagID(controller, setting);
  545. if (!controller.tree.selected && controller.tree.findNode(controller.sheet.getTag(0, 0, GC.Spread.Sheets.SheetArea.viewport))) {
  546. controller.setTreeSelected(controller.tree.findNode(controller.sheet.getTag(0, 0, GC.Spread.Sheets.SheetArea.viewport)));
  547. }
  548. //刷新节点可进行操作的按钮
  549. refreshBtn(controller);
  550. controller.setTreeSelected(controller.tree.findNode(controller.sheet.getTag(0, 0)));
  551. //粘贴事件
  552. bindPasteBills(controller, billsSpread.getActiveSheet(), setting);
  553. bindBillsRangeChanged(controller, billsSpread.getActiveSheet(), setting);
  554. //补注内容改变
  555. rechargeChange(controller);
  556. // 勘误错误改变
  557. erratumRecordChange(controller)
  558. //焦点控制
  559. switchFcs(controller, controller.sheet, billsSpread, jobsSheet, itemsSheet);
  560. //jobs
  561. jobOperation(controller, jobsSheet, function(totalJobs){
  562. //------关联表粘贴复制
  563. bindPasteRel(jobsSheet, controller, totalJobs, jobsSetting);
  564. //items
  565. itemOperation(controller, itemsSheet, function(totalItems){
  566. bindPasteItemsRel(itemsSheet, controller, totalItems, itemsSetting);
  567. //节点操作
  568. nodeOpration(controller, totalJobs, totalItems);
  569. });
  570. });
  571. // 设置固定清单下拉
  572. let nameList = BillsFixedFlagList.map((data) => data.name);
  573. let comboCol = setting.cols.findIndex((data) => data.data.field === 'fixedFlag');
  574. setCombo(billsSheet, comboCol, nameList);
  575. // 设置清单类型下拉
  576. let kindComboList = kindList.map((data) => data.name);
  577. let kindCol = setting.cols.findIndex((data) => data.data.field === 'kind');
  578. setCombo(billsSheet, kindCol, kindComboList);
  579. onContextmenuOpr(billsSpread, controller);
  580. }
  581. function switchFcs(controller, billsSheet, billsSpread, jobsSheet, itemsSheet){
  582. let btnInsert = $('#insert');
  583. let btnDelete = $('#delete');
  584. let btnUpMove = $('#upMove');
  585. let btnDownMove = $('#downMove');
  586. let btnUpLevel = $('#upLevel');
  587. let btnDownLevel = $('#downLevel');
  588. billsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
  589. jobsSheet.clearSelection();
  590. itemsSheet.clearSelection();
  591. billsSpread.focus(true);
  592. jobsSheet.options.isProtected = true;
  593. itemsSheet.options.isProtected = true;
  594. billsSheet.options.isProtected = false;
  595. btnInsert.attr('fcsOnBills', 'true');
  596. btnDelete.attr('fcsOnBills', 'true');
  597. btnUpLevel.attr('fcsOnBills', 'true');
  598. btnDownLevel.attr('fcsOnBills', 'true');
  599. btnUpMove.attr('fcsOnBills', 'true');
  600. btnDownMove.attr('fcsOnBills', 'true');
  601. });
  602. jobsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
  603. itemsSheet.clearSelection();
  604. jobsSpread.focus(true);
  605. itemsSheet.options.isProtected = true;
  606. billsSheet.options.isProtected = true;
  607. jobsSheet.options.isProtected = false;
  608. controller.tree.selected.args = args;
  609. controller.tree.selected.field = 'job';
  610. tools.btnClose(btnInsert);
  611. tools.btnClose(btnDelete);
  612. tools.btnClose(btnUpLevel);
  613. tools.btnClose(btnDownLevel);
  614. btnInsert.attr('fcsOnBills', 'false');
  615. btnDelete.attr('fcsOnBills', 'false');
  616. btnUpLevel.attr('fcsOnBills', 'false');
  617. btnDownLevel.attr('fcsOnBills', 'false');
  618. btnUpMove.attr('fcsOnBills', 'false');
  619. btnDownMove.attr('fcsOnBills', 'false');
  620. let selected;
  621. if(controller.tree.selected){
  622. selected = controller.tree.selected.jobs[args.row];
  623. }
  624. if(tools.canUpMove(selected, controller.tree.selected.jobs)){
  625. tools.btnAction(btnUpMove);
  626. btnUpMove.attr('canMove', 'true');
  627. }
  628. else{
  629. tools.btnClose(btnUpMove);
  630. btnUpMove.attr('canMove', 'false');
  631. }
  632. if(tools.canDownMove(selected, controller.tree.selected.jobs)){
  633. tools.btnAction(btnDownMove);
  634. btnDownMove.attr('canMove', 'true');
  635. }
  636. else{
  637. tools.btnClose(btnDownMove);
  638. btnDownMove.attr('canMove', 'false');
  639. }
  640. });
  641. itemsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
  642. jobsSheet.clearSelection();
  643. itemsSpread.focus(true);
  644. jobsSheet.options.isProtected = true;
  645. billsSheet.options.isProtected = true;
  646. itemsSheet.options.isProtected = false;
  647. controller.tree.selected.args = args;
  648. controller.tree.selected.field = 'item';
  649. tools.btnClose(btnInsert);
  650. tools.btnClose(btnDelete);
  651. tools.btnClose(btnUpLevel);
  652. tools.btnClose(btnDownLevel);
  653. btnInsert.attr('fcsOnBills', 'false');
  654. btnDelete.attr('fcsOnBills', 'false');
  655. btnUpLevel.attr('fcsOnBills', 'false');
  656. btnDownLevel.attr('fcsOnBills', 'false');
  657. btnUpMove.attr('fcsOnBills', 'false');
  658. btnDownMove.attr('fcsOnBills', 'false');
  659. let selected;
  660. if(controller.tree.selected){
  661. selected = controller.tree.selected.items[args.row];
  662. }
  663. if(tools.canUpMove(selected, controller.tree.selected.items)){
  664. tools.btnAction(btnUpMove);
  665. btnUpMove.attr('canMove', 'true');
  666. }
  667. else{
  668. tools.btnClose(btnUpMove);
  669. btnUpMove.attr('canMove', 'false');
  670. }
  671. if(tools.canDownMove(selected, controller.tree.selected.items)){
  672. tools.btnAction(btnDownMove);
  673. btnDownMove.attr('canMove', 'true');
  674. }
  675. else{
  676. tools.btnClose(btnDownMove);
  677. btnDownMove.attr('canMove', 'false');
  678. }
  679. });
  680. };
  681. function setTagID(controller, setting){
  682. if(controller.tree.items.length > 0){
  683. let length = controller.tree.items.length;
  684. for(var i=0; i<length; i++){
  685. setting.cols.forEach(function(col, colIdx){
  686. if(controller.tree.items[i].data.ID){
  687. controller.sheet.setTag(i, colIdx, controller.tree.items[i].data.ID);
  688. }
  689. });
  690. }
  691. }
  692. }
  693. function refreshBtn(controller){
  694. if (locked) {
  695. return;
  696. }
  697. controller.bind('refreshBaseActn', function (tree) {
  698. let showButton = function (show, btn) {
  699. tools.btnAction($('#insert'), 'focusOnBills');
  700. if (show) {
  701. tools.btnAction(btn, 'doing');
  702. } else {
  703. tools.btnClose(btn, 'doing');
  704. }
  705. };
  706. showButton(tree.selected && tree.selected.canUpLevel(), $('#upLevel'));
  707. showButton(tree.selected && tree.selected.canDownLevel(), $('#downLevel'));
  708. showButton(tree.selected && tree.selected.canUpMove(), $('#upMove'));
  709. showButton(tree.selected && tree.selected.canDownMove(), $('#downMove'));
  710. showButton(tree.selected ? true : false, $('#delete'));
  711. });
  712. }
  713. function rechargeChange(controller){
  714. codeEditor.on("change", function () {
  715. if(controller.tree.selected){
  716. let newData = codeEditor.getValue();
  717. if(newData !== controller.tree.selected.data.recharge){
  718. rechargeController.updateRechar(controller.tree.selected, newData);
  719. }
  720. }
  721. });
  722. /*$('#exampleTextarea').bind('change', function(){
  723. let newData = $('#exampleTextarea').val();
  724. if(controller.tree.selected){
  725. console.log(controller.tree.selected.data.code)
  726. rechargeController.updateRechar(controller.tree.selected, newData);
  727. }
  728. });*/
  729. }
  730. // 勘误记录
  731. function erratumRecordChange(controller){
  732. erratumRecordEditor.on('change', async function () {
  733. console.log('1111');
  734. const node = controller.tree.selected;
  735. const erratumRecord = erratumRecordEditor.getValue();
  736. if (!node || erratumRecord === node.data.erratumRecord) {
  737. return;
  738. }
  739. try {
  740. const updateId = node.getID();
  741. await ajaxPost('/stdBillsEditor/updateBills', { billsLibId, updateId, field: 'erratumRecord', data: erratumRecord });
  742. node.data.erratumRecord = erratumRecord;
  743. } catch(error) {
  744. alert(error.message);
  745. erratumRecordEditor.setValue(node.data.erratumRecord || '');
  746. }
  747. });
  748. }
  749. function jobOperation(controller, jobsSheet, callback){
  750. mainAjax.getMaxNumber(billsLibId, 'jobs', function(result){
  751. if(result.length === 0){
  752. maxJobsNumber = 0;
  753. }
  754. else {
  755. maxJobsNumber = result[0].code;
  756. }
  757. jobsAjax.getJobContent(billsLibId, function(datas){
  758. let totalJobs = createObj.newJobs();
  759. totalJobs.loadJobs(controller.tree.items, datas);
  760. jobsController.totalJobs = totalJobs;
  761. initData(controller, jobsSheet, jobsSetting, 'jobs');
  762. myKey.delKey(jobsSpread, controller, totalJobs, jobsSetting, 'jobs');
  763. bindSheet(controller, jobsSheet, 'jobs', jobsSetting);
  764. jobsController.editData(jobsSheet);
  765. if (callback){
  766. callback(totalJobs);
  767. }
  768. });
  769. });
  770. }
  771. function itemOperation(controller, itemsSheet, callback){
  772. mainAjax.getMaxNumber(billsLibId, 'items', function(result){
  773. if(result.length === 0){
  774. maxItemsNumber = 0;
  775. }
  776. else {
  777. maxItemsNumber = result[0].code;
  778. }
  779. itemsAjax.getItemCharacter(billsLibId, function(datas){
  780. let totalItems = createObj.newItems();
  781. totalItems.loadItems(controller.tree.items, datas);
  782. itemsController.totalItems = totalItems;
  783. initData(controller, itemsSheet, itemsSetting, 'items');
  784. myKey.delKey(itemsSpread, controller, totalItems, itemsSetting, 'items');
  785. bindSheet(controller, itemsSheet, 'items', itemsSetting);
  786. itemsController.editData(itemsSheet);
  787. if(callback){
  788. callback(totalItems)
  789. }
  790. });
  791. });
  792. }
  793. //初始焦点工作表和项目表绑定数据
  794. function initData(controller, sheet, setting, classify){
  795. if(controller.tree.selected){
  796. let arr = controller.tree.selected[classify];
  797. let recharge = controller.tree.selected.data.recharge;
  798. let prefix = classify === 'jobs' ? 'job' : 'item';
  799. if(arr.length > 0){
  800. tools.orderReshowData(sheet, arr, setting, prefix,true);
  801. }
  802. else{
  803. setSheet.setMaxRowCount(sheet, []);
  804. }
  805. if(recharge){
  806. codeEditor.setValue(recharge);
  807. //$('#exampleTextarea').val(recharge);
  808. }
  809. else{
  810. codeEditor.setValue('');
  811. //$('#exampleTextarea').val('');
  812. }
  813. const erratumRecord = controller.tree.selected.data.erratumRecord || '';
  814. erratumRecordEditor.setValue(erratumRecord);
  815. }
  816. }
  817. function bindSheet(controller, sheet, field, setting){
  818. controller.sheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function(sender, args){
  819. if(args.newSelections[0]){
  820. controller.tree.selected = controller.tree.items[args.newSelections[0].row] ? controller.tree.items[args.newSelections[0].row] : null;
  821. }
  822. if(controller.tree.selected && args.oldSelections[0].row !== args.newSelections[0].row|| controller.tree.selected && args.oldSelections[0].row === 0){
  823. //rechargeArea
  824. const recharge = controller.tree.selected.data.recharge || '';
  825. codeEditor.setValue(recharge);
  826. const erratumRecord = controller.tree.selected.data.erratumRecord || '';
  827. erratumRecordEditor.setValue(erratumRecord);
  828. //$('#exampleTextarea').val(controller.tree.selected.data.recharge);
  829. if(field === 'jobs'){
  830. tools.clearData(sheet);
  831. let jobs = controller.tree.selected.jobs;
  832. setSheet.setMaxRowCount(sheet, jobs);
  833. if(jobs.length > 0){
  834. tools.orderReshowData(sheet, jobs, setting, 'job', true);
  835. orgJobData = sheet.getValue(0, 0);
  836. }
  837. //sheetDatas = tools.getsheetDatas(sheet, 'jobs');
  838. }
  839. if(field === 'items'){
  840. tools.clearData(sheet);
  841. let items = controller.tree.selected.items;
  842. setSheet.setMaxRowCount(sheet, items);
  843. if(items.length > 0){
  844. tools.orderReshowData(sheet, items, setting, 'item', true);
  845. orgItemData = sheet.getValue(0, 0);
  846. }
  847. //sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
  848. }
  849. }
  850. });
  851. }
  852. function bindPasteBills(controller, sheet, setting){
  853. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
  854. sheetBillsDatas = tools.getsheetDatas(sheet, 'bills', controller);
  855. let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
  856. let maxRow = args.cellRange.row + args.cellRange.rowCount - 1;
  857. //复制的列数超过正确的列数,不可复制
  858. if(maxCol >= billsLibSetting.cols.length || maxRow >= controller.tree.items.length){
  859. args.cancel = true;
  860. }
  861. });
  862. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
  863. let datas = [], field;
  864. let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
  865. let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
  866. let markRow = orgRow, colLen = sheet.getColumnCount(GC.Spread.Sheets.SheetArea.viewport);
  867. let validDatas = tools.getValidDatas(sheet, setting, args);
  868. sheet.suspendPaint();
  869. for(let i =orgRow, j=0; i<= maxRow; i++, j++){
  870. //let id = controller.tree.items[i] ? controller.tree.items[i].getID() : null;
  871. let id = sheet.getTag(i, 0);
  872. if(id && j< validDatas.length){
  873. validDatas[j].ID = id;
  874. for(let k =orgCol; k<= maxCol; k++){
  875. setting.cols.forEach(function(col, colIdx){
  876. if(colIdx === k){
  877. if(validDatas[j][col.data.field]){
  878. sheet.setValue(i, k, validDatas[j][col.data.field]);
  879. sheetBillsDatas.datasIdx['rowIdx'+ i][col.data.field] = validDatas[j][col.data.field];
  880. }
  881. else {
  882. sheet.setValue(i, k, '');
  883. sheetBillsDatas.datasIdx['rowIdx'+ i][col.data.field] = '';
  884. }
  885. }
  886. });
  887. }
  888. }
  889. else if(i < controller.tree.items.length && j>= validDatas.length){
  890. //reshow orgDatas
  891. sheet.setValue(i, 0, sheetBillsDatas.datasIdx['rowIdx'+ i].kind);
  892. sheet.setValue(i, 1, sheetBillsDatas.datasIdx['rowIdx'+ i].code + '');
  893. sheet.setValue(i, 2, sheetBillsDatas.datasIdx['rowIdx'+ i].name);
  894. sheet.setValue(i, 3, sheetBillsDatas.datasIdx['rowIdx'+ i].unit);
  895. sheet.setValue(i, 4, sheetBillsDatas.datasIdx['rowIdx'+ i].ruleText);
  896. sheet.setValue(i, 5, sheetBillsDatas.datasIdx['rowIdx'+ i].unitPrice);
  897. // sheet.setValue(i, 4, sheetBillsDatas.datasIdx['rowIdx'+ i].engineering);
  898. sheet.setValue(i, 10, sheetBillsDatas.datasIdx['rowIdx'+ i].fixedFlag);
  899. }
  900. else {
  901. sheet.clear(i, 0, 1, sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.data);
  902. }
  903. }
  904. sheet.resumePaint();
  905. billsAjax.pasteBills(userAccount, billsLibId, validDatas);
  906. for(let vData of validDatas){
  907. let node = controller.tree.nodes['id_' + vData.ID];
  908. if(node){
  909. Object.assign(node.data, vData);
  910. }
  911. }
  912. sheet.setRowCount(sheetBillsDatas.datas.length);
  913. });
  914. }
  915. function bindBillsRangeChanged(controller, sheet, setting) {
  916. sheet.bind(GC.Spread.Sheets.Events.RangeChanged, function (sender, info) {
  917. const postData = [];
  918. let curRow;
  919. let curData;
  920. info.changedCells.forEach(({ row, col }) => {
  921. const node = controller.tree.items[row];
  922. if (curRow !== row) {
  923. curData = { ID: node.data.ID };
  924. postData.push(curData);
  925. }
  926. curRow = row;
  927. const field = setting.cols[col].data.field;
  928. let value = sheet.getValue(row, col);
  929. if (field === 'fixedFlag') {
  930. const findData = BillsFixedFlagList.find((x) => x.name === value);
  931. if (findData) {
  932. value = findData.value;
  933. }
  934. } else if (field === 'kind') {
  935. const findData = kindList.find((x) => x.name === value);
  936. if (findData) {
  937. value = findData.value;
  938. }
  939. }
  940. curData[field] = value;
  941. });
  942. billsAjax.pasteBills(userAccount, billsLibId, postData, function () {
  943. info.changedCells.forEach(({ row, col }) => {
  944. const node = controller.tree.items[row];
  945. const field = setting.cols[col].data.field;
  946. let value = sheet.getValue(row, col);
  947. if (field === 'fixedFlag') {
  948. const findData = BillsFixedFlagList.find((x) => x.value === value);
  949. if (findData) {
  950. value = findData.name;
  951. }
  952. } else if (field === 'kind') {
  953. const findData = kindList.find((x) => x.value === value);
  954. if (findData) {
  955. value = findData.name;
  956. }
  957. }
  958. node.data[field] = value;
  959. sheetBillsDatas.datasIdx['rowIdx' + row][field] = value;
  960. sheet.setValue(row, col, node.data[field] || '');
  961. });
  962. }, function () {
  963. info.changedCells.forEach(({ row, col }) => {
  964. const node = controller.tree.items[row];
  965. const field = setting.cols[col].data.field;
  966. sheet.setValue(row, col, node.data[field] || '');
  967. });
  968. });
  969. });
  970. }
  971. function bindPasteRel(sheet, controller, totalJobs, setting){
  972. //sheetDatas = tools.getsheetDatas(sheet, 'jobs');
  973. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
  974. let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
  975. sheetDatas = tools.getsheetDatas(sheet, 'jobs');
  976. //复制的列数超过正确的列数,不可复制
  977. if(maxCol >= jobsSetting.cols.length){
  978. args.cancel = true;
  979. }
  980. });
  981. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
  982. if(controller.tree.selected){
  983. let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
  984. let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
  985. let pasteArr = [];
  986. let crossedDatas = [];
  987. let uncrossedDatas = [];
  988. const codeCol = 0;
  989. const contentCol = 1;
  990. for(let i=orgRow; i<=maxRow; i++){
  991. //粘贴编号列,转换成粘贴内容处理
  992. let code = sheet.getCell(i, codeCol).value();
  993. let content = sheet.getCell(i, contentCol).value();
  994. if(code && !content){
  995. let contentByCode = tools.getContentByCode(totalJobs.jobsArr, code);
  996. if(contentByCode){
  997. pasteArr.push(contentByCode);
  998. }
  999. }
  1000. if(content){
  1001. pasteArr.push(content);
  1002. }
  1003. }
  1004. let uniqPasteArr = tools.uniqArr(pasteArr);
  1005. let serialNoUn = tools.getSerialNo(controller.tree.selected.jobs) - 1;
  1006. for(let i =orgRow, j=0; i<=uniqPasteArr.length+orgRow-1; i++, j++ ){
  1007. let flag = true;
  1008. let crossedData;
  1009. sheetDatas.forEach(function(rowData){
  1010. if(rowData.rowIdx === i && rowData.data !== uniqPasteArr[j]){
  1011. flag = false;
  1012. let serialNo = tools.getObj(controller.tree.selected.jobs, rowData.id, 'job');
  1013. crossedData = {
  1014. orgId: rowData.id,
  1015. newData: uniqPasteArr[j],
  1016. serialNo: serialNo
  1017. };
  1018. }
  1019. });
  1020. if(flag){
  1021. serialNoUn++;
  1022. uncrossedDatas.push({data: uniqPasteArr[j], serialNo: serialNoUn});
  1023. }
  1024. else {
  1025. crossedDatas.push(crossedData);
  1026. }
  1027. }
  1028. let pasteDatas = tools.encapData(uncrossedDatas, crossedDatas, controller, totalJobs);
  1029. if(pasteDatas.updateDatas.length > 0 || pasteDatas.createDatas.length > 0){
  1030. billsAjax.pasteRel(userAccount, billsLibId, pasteDatas.updateDatas, pasteDatas.createDatas, 'jobs', function(datas){
  1031. pasteController.frontOperator(sheet, setting, controller, totalJobs, datas);
  1032. });
  1033. }
  1034. else {
  1035. tools.orderReshowData(sheet, controller.tree.selected.jobs, setting, 'job', true);
  1036. }
  1037. }
  1038. else {
  1039. tools.clearData(sheet);
  1040. }
  1041. });
  1042. }
  1043. function bindPasteItemsRel(sheet, controller, totalItems, setting){
  1044. //sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
  1045. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
  1046. let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
  1047. sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
  1048. //复制的列数超过正确的列数,不可复制
  1049. if(maxCol >= itemsSetting.cols.length){
  1050. args.cancel = true;
  1051. }
  1052. });
  1053. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
  1054. if(controller.tree.selected){
  1055. let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
  1056. let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
  1057. let pasteArr = [];
  1058. let crossedDatas = [];
  1059. let uncrossedDatas = [];
  1060. const codeCol = 0;
  1061. const contentCol = 1;
  1062. for(let i=orgRow; i<=maxRow; i++){
  1063. //编号列转换成内容列处理
  1064. let code = sheet.getCell(i, codeCol).value();
  1065. let content = sheet.getCell(i, contentCol).value();
  1066. if(code && !content){
  1067. let contentByCode = tools.getContentByCode(totalItems.itemsArr, code);
  1068. if(contentByCode){
  1069. pasteArr.push(contentByCode);
  1070. }
  1071. }
  1072. if(content){
  1073. pasteArr.push(content);
  1074. }
  1075. }
  1076. let uniqPasteArr = tools.uniqArr(pasteArr);
  1077. let serialNoUn = tools.getSerialNo(controller.tree.selected.items) - 1;
  1078. for(let i =orgRow, j=0; i<=uniqPasteArr.length+orgRow-1; i++, j++ ){
  1079. let flag = true;
  1080. let crossedData;
  1081. sheetItemsDatas.forEach(function(rowData){
  1082. if(rowData.rowIdx === i && rowData.data !== uniqPasteArr[j]){
  1083. flag = false;
  1084. let serialNo = tools.getObj(controller.tree.selected.items, rowData.id, 'item');
  1085. crossedData = {
  1086. orgId: rowData.id,
  1087. newData: uniqPasteArr[j],
  1088. serialNo: serialNo
  1089. };
  1090. }
  1091. });
  1092. if(flag){
  1093. serialNoUn ++;
  1094. uncrossedDatas.push({data: uniqPasteArr[j], serialNo: serialNoUn});
  1095. }
  1096. else {
  1097. crossedDatas.push(crossedData);
  1098. }
  1099. }
  1100. let pasteDatas = tools.encapItemsData(uncrossedDatas, crossedDatas, controller, totalItems);
  1101. if(pasteDatas.updateDatas.length > 0 || pasteDatas.createDatas.length > 0){
  1102. billsAjax.pasteRel(userAccount, billsLibId, pasteDatas.updateDatas, pasteDatas.createDatas, 'items', function(datas){
  1103. pasteController.frontItemsRelOperator(sheet, setting, controller, totalItems, datas);
  1104. });
  1105. }
  1106. else{
  1107. tools.orderReshowData(sheet, controller.tree.selected.items, setting, 'item', true);
  1108. }
  1109. }
  1110. else {
  1111. tools.clearData(sheet);
  1112. }
  1113. });
  1114. }
  1115. function buildJobs(jobsSpread, setting){
  1116. setSheet.initSheet(jobsSpread, setting, true);
  1117. jobsSpread.getActiveSheet().clearSelection();
  1118. myKey.downKey(jobsSpread);
  1119. myKey.enterKey(jobsSpread);
  1120. TREE_SHEET_HELPER.loadSheetHeader(jobsSetting, jobsSpread.getActiveSheet());
  1121. }
  1122. function buildItems(itemsSpread, setting){
  1123. setSheet.initSheet(itemsSpread, setting, true);
  1124. // setSheet.setMaxRowCount(itemsSpread.getActiveSheet(), 10);
  1125. itemsSpread.getActiveSheet().clearSelection();
  1126. myKey.downKey(itemsSpread);
  1127. myKey.enterKey(itemsSpread);
  1128. TREE_SHEET_HELPER.loadSheetHeader(itemsSetting, itemsSpread.getActiveSheet());
  1129. }
  1130. </script>
  1131. </html>