tBInitialStockList.jsp 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  2. <%@include file="/context/mytags.jsp"%>
  3. <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  4. <div class="easyui-layout" fit="true">
  5. <div region="center" style="padding:0px;border:0px">
  6. <t:datagrid name="tBInitialStockList" checkbox="true" fitColumns="false" title="期初库存" actionUrl="tBInitialStockController.do?datagrid" idField="id" fit="true" queryMode="group">
  7. <t:dgCol title="主键" field="id" hidden="true" queryMode="single" width="120"></t:dgCol>
  8. <t:dgCol title="仓库编码" field="warehouseCode" queryMode="single" width="120"></t:dgCol>
  9. <t:dgCol title="仓库名称" field="warehouseName" queryMode="single" width="120"></t:dgCol>
  10. <t:dgCol title="库存金额(元)" field="totalMoney" queryMode="single" formatterjs="formatterNum" width="120"></t:dgCol>
  11. <t:dgCol title="仓库" field="warehouseId" hidden="true" query="true" queryMode="single" dictionary="t_b_warehouse,id,warehouse_name, and delete_flag != '1' and `status` != '1' " width="120"></t:dgCol>
  12. <t:dgCol title="经手人" field="byhandId" query="true" queryMode="single" dictionary="t_s_base_user,id,realName" width="120"></t:dgCol>
  13. <t:dgCol title="提交人" field="checkName" queryMode="single" width="120"></t:dgCol>
  14. <t:dgCol title="同步状态" field="syncStatus" query="false" queryMode="single" dictionary="syncstatus" width="120"></t:dgCol>
  15. <t:dgCol title="制单人" field="createName" hidden="true" queryMode="single" width="120"></t:dgCol>
  16. <t:dgCol title="制单人登录名称" field="createBy" hidden="true" queryMode="single" width="120"></t:dgCol>
  17. <t:dgCol title="制单日期" field="createDate" hidden="true" formatter="yyyy-MM-dd hh:mm:ss" queryMode="single" width="120"></t:dgCol>
  18. <t:dgCol title="更新人名称" field="updateName" hidden="true" queryMode="single" width="120"></t:dgCol>
  19. <t:dgCol title="更新人登录名称" field="updateBy" hidden="true" queryMode="single" width="120"></t:dgCol>
  20. <t:dgCol title="更新日期" field="updateDate" formatter="yyyy-MM-dd hh:mm:ss" hidden="true" queryMode="single" width="120"></t:dgCol>
  21. <t:dgCol title="经手人名称" field="byhandName" hidden="true" queryMode="single" width="120"></t:dgCol>
  22. <t:dgCol title="经手人登录名称" field="byhandBy" hidden="true" queryMode="single" width="120"></t:dgCol>
  23. <t:dgCol title="经手日期" field="byhandDate" hidden="true" queryMode="single" width="120"></t:dgCol>
  24. <t:dgCol title="提交人ID" field="checkerId" hidden="true" queryMode="single" width="120"></t:dgCol>
  25. <t:dgCol title="提交人登录名称" field="checkBy" hidden="true" queryMode="single" width="120"></t:dgCol>
  26. <t:dgCol title="提交日期" field="checkDate" hidden="true" queryMode="single" width="120"></t:dgCol>
  27. <t:dgCol title="备注" field="remark" hidden="true" queryMode="single" width="120"></t:dgCol>
  28. <t:dgCol title="操作" field="opt"></t:dgCol>
  29. <%-- <t:dgDelOpt title="删除" url="tBInitialStockController.do?doDel&id={id}" funname="check_del(id)"/> --%>
  30. <t:dgFunOpt funname="check_del(id,syncStatus)" title="删除" />
  31. <t:dgToolBar title="录入" icon="icon-add" operationCode="add" url="tBInitialStockController.do?goAdd" funname="add" width="100%" height="100%"></t:dgToolBar>
  32. <t:dgToolBar title="修改" icon="icon-edit" operationCode="edit" url="tBInitialStockController.do?goUpdate" funname="update" width="100%" height="100%"></t:dgToolBar>
  33. <%-- <t:dgToolBar title="批量删除" icon="icon-remove" operationCode="remove" url="tBInitialStockController.do?doBatchDel" funname="deleteALLSelect"></t:dgToolBar> --%>
  34. <t:dgToolBar title="查看" icon="icon-search" url="tBInitialStockController.do?goUpdate" funname="detail" width="100%" height="100%"></t:dgToolBar>
  35. <t:dgToolBar title="同步实时库存" icon="icon-edit" operationCode="edit" url="tBInitialStockController.do?syncRealStock" funname="syncRealStock"></t:dgToolBar>
  36. <t:dgToolBar title="导入" icon="icon-putout" operationCode="put" funname="ImportXls"></t:dgToolBar>
  37. <t:dgToolBar title="导出" icon="icon-put" operationCode="put" funname="ExportXls"></t:dgToolBar>
  38. <t:dgToolBar title="模板下载" icon="icon-putout" operationCode="putout" funname="ExportXlsByT"></t:dgToolBar>
  39. </t:datagrid>
  40. </div>
  41. </div>
  42. <script src = "webpage/cn/com/lzt/initialstock/tBInitialStockList.js"></script>
  43. <script type="text/javascript">
  44. $(document).ready(function(){
  45. //给时间控件加上样式
  46. $("#tBInitialStockListtb").find("input[name='createDate']").attr("class","Wdate").click(function(){WdatePicker({dateFmt:'yyyy-MM-dd'});});
  47. $("#tBInitialStockListtb").find("input[name='updateDate']").attr("class","Wdate").click(function(){WdatePicker({dateFmt:'yyyy-MM-dd'});});
  48. });
  49. function formatterNum(value,rec,index){
  50. if(value != null && value != ''){
  51. return Math.round(new Number(value) * 100) / 100;
  52. }else{
  53. return new Number(0);
  54. }
  55. }
  56. //导入
  57. function ImportXls() {
  58. openuploadwin('Excel导入', 'tBInitialStockController.do?upload', "tBInitialStockList");
  59. }
  60. //导出
  61. function ExportXls() {
  62. JeecgExcelExport("tBInitialStockController.do?exportXls","tBInitialStockList");
  63. }
  64. //模板下载
  65. function ExportXlsByT() {
  66. JeecgExcelExport("tBInitialStockController.do?exportXlsByT","tBInitialStockList");
  67. }
  68. //删除
  69. function check_del(id,syncStatus){
  70. var url = 'tBInitialStockController.do?doDel';
  71. url += '&id='+id;
  72. $.dialog.confirm('<t:mutiLang langKey="确定要删除吗?"/>', function(){
  73. if(syncStatus != '0'){
  74. $.messager.alert('提示信息',"该条记录已同步到实时库存,不能删除!");
  75. return;
  76. }else{
  77. lockuploadify(url, '&id');
  78. }
  79. }, function(){
  80. });
  81. }
  82. //新增
  83. function add(title,url,id){
  84. window.location.href=url;
  85. }
  86. //更新
  87. function update(title,url, id){
  88. var rowsData = $('#'+id).datagrid('getSelections');
  89. if (!rowsData || rowsData.length==0) {
  90. tip('<t:mutiLang langKey="common.please.select.edit.item"/>');
  91. return;
  92. }else if(rowsData.length>=2){
  93. tip('请选择一条记录');
  94. return;
  95. }
  96. if(rowsData[0].syncStatus != null && rowsData[0].syncStatus =='0'){
  97. updateNotCreateWin("修改",url, "tBInitialStockList",false);
  98. }else{
  99. $.messager.alert('提示信息',"该条记录已同步到实时库存,不能修改!");
  100. return;
  101. }
  102. }
  103. //查看
  104. function view(title,url, id){
  105. viewNotCreateWin("查看",url, "tBInitialStockList",false);
  106. }
  107. //同步实时库存
  108. function syncRealStock(title,url, id) {
  109. gridname=id;
  110. var rowsData = $('#'+id).datagrid('getSelections');
  111. if (!rowsData || rowsData.length==0 || rowsData.length>=2) {
  112. tip('请选择一条记录');
  113. return;
  114. }
  115. url += '&id='+rowsData[0].id;
  116. $.dialog.confirm('<t:mutiLang langKey="确定要同步吗?同步完不可撤回和修改!"/>', function(){
  117. if(rowsData[0].syncStatus == null){
  118. $.messager.alert('提示信息',"该条记录状态异常,无法进行操作");
  119. return;
  120. }else if(rowsData[0].syncStatus =='1'){
  121. $.messager.alert('提示信息',"该条记录已同步到实时库存,不能再同步");
  122. return;
  123. }else{
  124. lockuploadify(url, '&id');
  125. }
  126. }, function(){
  127. });
  128. }
  129. function lockuploadify(url, id) {
  130. $.ajax({
  131. async : false,
  132. cache : false,
  133. type : 'POST',
  134. url : url,// 请求的action路径
  135. error : function() {// 请求失败处理函数
  136. },
  137. success : function(data) {
  138. var d = data; // ------ $.parseJSON(data);
  139. if (d.success) {
  140. var msg = d.msg;
  141. tip(msg);
  142. reloadTable();
  143. }
  144. }
  145. });
  146. }
  147. function syncRealStock1(id) {
  148. createwindow('删除', 'tBInitialStockController.do?syncRealStock&id=' + id);
  149. }
  150. function syncRealStock2(title,url, id){
  151. //debugger;
  152. //alert();
  153. var rowsData = $('#'+id).datagrid('getSelections');
  154. if(rowsData[0].syncStatus == null || rowsData[0].syncStatus =='1'){
  155. $.messager.alert('提示信息',"该条记录已同步到实时库存,不能修改!");
  156. return;
  157. }else{
  158. }
  159. }
  160. </script>