qingdan.html 67 KB

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