qingdan.html 50 KB

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