Form.js 94 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945
  1. Ext.define('erp.view.common.print.Form', {
  2. extend : 'Ext.form.Panel',
  3. alias : 'widget.erpPrintFormPanel',
  4. id : 'printform',
  5. autoScroll : true,
  6. frame : true,
  7. style : 'border-width: 0 1px 1px 1px;',
  8. defaultType : 'textfield',
  9. layout : 'column',
  10. labelSeparator : ':',
  11. fieldDefaults : {
  12. fieldStyle : "background:#FFFAFA;color:#515151;",
  13. labelAlign : "right",
  14. blankText : $I18N.common.form.blankText
  15. },
  16. FormUtil : Ext.create('erp.util.FormUtil'),
  17. buttonAlign : 'center',
  18. buttons : [
  19. {
  20. name : 'print',
  21. text : $I18N.common.button.erpPrintButton,
  22. iconCls : 'x-button-icon-print',
  23. cls : 'x-btn-gray',
  24. height : 26,
  25. style : {
  26. marginLeft : '10px'
  27. },
  28. handler : function(btn) {
  29. var form = Ext.getCmp('printform');
  30. console.log(form);
  31. var reportName = '';
  32. var condition = '';
  33. var cop = form.title;
  34. var code = '';
  35. var custcode = '';
  36. var prodcode = '';
  37. var fromdate = '';
  38. var enddate = '';
  39. console.log(cop);
  40. var id = "1";
  41. var idS = '';
  42. var vendorcode = '';
  43. var purchaseman = '';
  44. var status = '';
  45. var whcode = '';
  46. var salecode = '';
  47. var todate = '';
  48. var dateFW = '';
  49. var assifall = '';
  50. var tablename = form.tablename;
  51. console.log("tablename=" + tablename);
  52. console.log(form.caller);
  53. var defaultCondition = "";
  54. var thisreport = "";
  55. if (cop == "销售额同比增长图(按业务员)" || cop == "销售额同比增长图(按业务员)") {
  56. fromdate = Ext.Date.format(Ext.getCmp('pi_date').firstVal, 'Y-m-d');
  57. todate = Ext.Date.format(Ext.getCmp('pi_date').secondVal, 'Y-m-d');
  58. console.log(fromdate);
  59. console.log(todate);
  60. }
  61. if (cop == "出入库明细表(过账日期)") {
  62. fromdate = Ext.Date.format(Ext.getCmp('pi_date1').firstVal, 'Y-m-d');
  63. todate = Ext.Date.format(Ext.getCmp('pi_date1').secondVal, 'Y-m-d');
  64. console.log(fromdate);
  65. console.log(todate);
  66. }
  67. if (cop == "明细分类账报表") {
  68. fromdate = Ext.Date.format(Ext.getCmp('sl_date').firstVal, 'Y-m-d');
  69. todate = Ext.Date.format(Ext.getCmp('sl_date').secondVal, 'Y-m-d');
  70. console.log(fromdate);
  71. console.log(todate);
  72. }
  73. if (cop == "期间库存表") {
  74. fromdate = Ext.Date.format(Ext.getCmp('pw_date').firstVal, 'Y-m-d');
  75. todate = Ext.Date.format(Ext.getCmp('pw_date').secondVal, 'Y-m-d');
  76. console.log(fromdate);
  77. console.log(todate);
  78. }
  79. if (cop == "库存周转率分析表" || cop == "原材料周转天数表") {
  80. fromdate = Ext.Date.format(Ext.getCmp('pi_date').firstVal, 'Y-m-d');
  81. todate = Ext.Date.format(Ext.getCmp('pi_date').secondVal, 'Y-m-d');
  82. console.log(fromdate);
  83. console.log(todate);
  84. }
  85. if (cop == "产品分析表") {
  86. fromdate = Ext.Date.format(Ext.getCmp('vr_recorddate').firstVal, 'Y-m-d');
  87. todate = Ext.Date.format(Ext.getCmp('vr_recorddate').secondVal, 'Y-m-d');
  88. console.log(fromdate);
  89. console.log(todate);
  90. }
  91. if (cop == "待处理统计‎(按检验人-日期‎)") {
  92. fromdate = Ext.Date.format(Ext.getCmp('ve_date').firstVal, 'Y-m-d');
  93. todate = Ext.Date.format(Ext.getCmp('ve_date').secondVal, 'Y-m-d');
  94. console.log(fromdate);
  95. console.log(todate);
  96. }
  97. if (cop == "供应商交货达成率报表") {
  98. fromdate = Ext.Date.format(Ext.getCmp('pd_delivery').firstVal, 'Y-m-d');
  99. todate = Ext.Date.format(Ext.getCmp('pd_delivery').secondVal, 'Y-m-d');
  100. console.log(fromdate);
  101. console.log(todate);
  102. }
  103. if (cop == "采购成本降价表(按最新入库)") {
  104. fromdate = Ext.Date.format(Ext.getCmp('pi_date').firstVal, 'Y-m-d');
  105. todate = Ext.Date.format(Ext.getCmp('pi_date').secondVal, 'Y-m-d');
  106. enddate = Ext.Date.format(Ext.getCmp('pi_date1').value, 'Y-m-d');
  107. console.log(fromdate);
  108. console.log(todate);
  109. console.log(enddate);
  110. }
  111. if (cop == "月COSTDOWN统计表") {
  112. fromdate = Ext.Date.format(Ext.getCmp('pu_date').firstVal, 'Y-m-d');
  113. todate = Ext.Date.format(Ext.getCmp('pu_date').secondVal, 'Y-m-d');
  114. enddate = Ext.Date.format(Ext.getCmp('PU_UPDATEDATE').value, 'Y-m-d');
  115. console.log(fromdate);
  116. console.log(todate);
  117. console.log(enddate);
  118. }
  119. if (cop == "在制仓库库存表(汇总)") {
  120. var myDate = new Date();
  121. var y = myDate.getFullYear();
  122. var m = myDate.getMonth() + 1;
  123. var d = myDate.getDate();
  124. m = m < 10 ? "0" + m : m;
  125. d = d < 10 ? "0" + d : d;
  126. todate = y + "-" + m + "-" + d;
  127. }
  128. if (cop == "制造单备料单(A4)") {
  129. // var today=new Date()(); // 获取今天时间
  130. // today.setDate()(today.getDate()() + 7); // 系统会自动转换
  131. idS = Ext.getCmp('ma_code').value;
  132. }
  133. if (cop == "派车费用统计") {
  134. var dateRange = Ext.getCmp('tt_date');
  135. dateFW = dateRange.value;
  136. var custcode = Ext.getCmp('tt_carcode').value;
  137. todate = custcode;
  138. fromdate = Ext.getCmp('tt_date').firstVal;
  139. enddate = Ext.getCmp('tt_date').secondVal;
  140. }
  141. if (cop == "销售订单达成率表") {
  142. todate = Ext.Date.format(Ext.getCmp('sa_date').firstVal, 'Y-m-d');
  143. ;
  144. }
  145. if (cop == "在制仓库库存表(制单)!") {
  146. var myDate = new Date();
  147. var y = myDate.getFullYear();
  148. var m = myDate.getMonth() + 1;
  149. var d = myDate.getDate();
  150. m = m < 10 ? "0" + m : m;
  151. d = d < 10 ? "0" + d : d;
  152. todate = y + "-" + m + "-" + d;
  153. }
  154. if (cop == "未发货客户订单明细表") {
  155. var dateRange = Ext.getCmp('sa_date');
  156. var dateValuePrint = dateRange.valuePrint;
  157. dateFW = dateRange.value;
  158. }
  159. if (cop == "集团应收周报表") {
  160. fromdate = Ext.Date.format(Ext.getCmp('ab_date').firstVal, 'Y-m-d');
  161. todate = Ext.Date.format(Ext.getCmp('ab_date').secondVal, 'Y-m-d');
  162. console.log(fromdate);
  163. console.log(todate);
  164. }
  165. var me = this;
  166. Ext.Ajax.request({
  167. url : basePath + 'common/enterprise/getprinturl.action?caller=' + caller,
  168. callback : function(opt, s, r) {
  169. var re = Ext.decode(r.responseText);
  170. defaultCondition = re.condition;
  171. thisreport = re.reportname;
  172. console.log(defaultCondition);
  173. if (defaultCondition != null) {
  174. if (commonContition != "") {
  175. commonContition = defaultCondition + ' and ' + commonContition;
  176. } else {
  177. commonContition = defaultCondition;
  178. }
  179. }
  180. // ===========================================
  181. var whichsystem = re.whichsystem;
  182. var urladdress = "";
  183. var rpname = re.reportName;
  184. // console.log(rpname);
  185. if (Ext.isEmpty(rpname) || rpname == "null") {
  186. urladdress = re.printurl;
  187. } else if (rpname.indexOf(thisreport) > 0) {
  188. urladdress = re.ErpPrintLargeData;
  189. } else {
  190. urladdress = re.printurl;
  191. }
  192. // console.log(reportName);
  193. // console.log(re.ErpPrintLargeData);
  194. console.log(urladdress);
  195. console.log(whichsystem);
  196. // ===============================================
  197. console.log(commonContition);
  198. form.FormUtil.batchPrint(idS, thisreport, commonContition, cop, todate, dateFW, fromdate,
  199. enddate, urladdress, whichsystem);
  200. // 在这里传条件和报表名字
  201. }
  202. });
  203. var length = form.items.length;
  204. var i = 0;
  205. var tablename = form.tablename;
  206. var reportName = "";
  207. var thisvalue = "";
  208. var field = "";
  209. var logicField = "";
  210. // 设置一个默认条件
  211. // var defaultContition=form.detailcondition;
  212. var commonContition = defaultCondition;
  213. while (i < length) {
  214. // 判断逻辑类型是否为空,不为空条件需替代为逻辑字段,不为空需要判断逻辑类型的字段类型,日期型需要格式化
  215. // console.log(form.items.items[i].logic);
  216. logicField = form.items.items[i].logic;
  217. // console.log(form.items.keys[i]);
  218. field = form.items.keys[i];
  219. // console.log(field);
  220. // console.log(Ext.getCmp(form.items.keys[i]).value);
  221. thisvalue = Ext.getCmp(form.items.keys[i]).value;
  222. console.log(thisvalue);
  223. console.log(form.items.items[i].xtype);
  224. console.log(logicField);
  225. if (thisvalue != "" && logicField != null) {
  226. // 判断逻辑字段的类型,日期需要格式化
  227. if (form.items.items[i].xtype == "condatefield") {
  228. var dateRange = Ext.getCmp(logicField);
  229. var dateValuePrint = dateRange.valuePrint;
  230. console.log(dateValuePrint);
  231. console.log(commonContition);
  232. if (commonContition != null && commonContition != '') {
  233. commonContition += ' and ' + dateValuePrint;
  234. } else {
  235. commonContition = dateValuePrint;
  236. }
  237. } else if (form.items.items[i].xtype == "ftfindfield") {
  238. var codeRange = Ext.getCmp(logicField);
  239. var codeValuePrint = codeRange.valuePrint;
  240. //===特殊处理,查询范围字段为明细行
  241. if(logicField=='vd_catecode'){
  242. codeValuePrint=codeValuePrint.replace(/voucher/g,'VoucherDetail');
  243. }
  244. if (commonContition != null && commonContition != '') {
  245. commonContition += ' and ' + codeValuePrint;
  246. } else {
  247. commonContition = codeValuePrint;
  248. }
  249. }else if(form.items.items[i].xtype == "textareafield"){
  250. if(cop=="工单备料批量打印"){
  251. var strs= new Array();
  252. var newstrs='';
  253. console.log(Ext.getCmp('ma_code').value);
  254. strs=Ext.getCmp('ma_code').value.split("\n");
  255. for (i=0;i<strs.length ;i++ )
  256. {
  257. newstrs+="'"+strs[i]+"'"+",";
  258. }
  259. console.log(newstrs.substring(0, newstrs.length-1));
  260. var textvalue=newstrs.substring(0, newstrs.length-1);
  261. commonContition +=' and ' +'{' + logicField + '}in' + "[" + textvalue + "]";
  262. //commonContition ='{' + logicField + '}in' + "[" + textvalue + "]";
  263. }
  264. }
  265. else if (form.items.items[i].xtype == "datefield") {
  266. thisvalue = Ext.Date.format(thisvalue, 'Y-m-d');
  267. todate = thisvalue;
  268. // 倒算库存金额带日期,倒算未开票
  269. if (commonContition != null && commonContition != '') {
  270. commonContition += ' and ' + '{' + logicField + '}<=' + "date(" + "'" + thisvalue
  271. + "'" + ")";
  272. } else {
  273. commonContition = '{' + logicField + '}<=' + "date(" + "'" + thisvalue + "'" + ")";
  274. }
  275. } else {
  276. if (commonContition != null && commonContition != '') {
  277. // 判断是否是采购员ID,因为采购员ID设置成DBFIND,则判断不出是数值型还是字符型,故需要特殊处理一下
  278. if (logicField.indexOf('buyerid') > 0 || logicField.indexOf('sellerid') > 0
  279. || logicField.indexOf('yearmonth') > 0||logicField.indexOf('id') > 0||logicField.indexOf('bo_id') > 0) {
  280. commonContition += ' and ' + '{' + logicField + '}=' + thisvalue;
  281. } else if (cop == "集团毛利润汇总表" || cop == "集团毛利润分析表-按客户" || cop == "集团毛利润分析表-按品牌"
  282. || cop == "集团毛利润分析表-按业务员" || cop == "集团应收汇总表" || cop == "集团应付汇总表"
  283. || cop == "集团呆库存汇总表-按业务员" || cop == "集团死库存汇总表-按业务员"
  284. || cop == "集团呆库存汇总表-按业务员" || cop == "集团毛利润明细分析表") {
  285. var arrcode = '';
  286. strs = thisvalue.split(",");
  287. if (strs.length > 1) {
  288. for (i = 0; i < strs.length; i++) {
  289. arrcode += "'" + strs[i] + "'" + ",";
  290. }
  291. commonContition += ' and ' + '{' + logicField + '}in ['
  292. + arrcode.substring(0, arrcode.length - 1) + ']';
  293. } else {
  294. commonContition += ' and ' + '{' + logicField + '}=' + "'" + thisvalue
  295. + "'";
  296. }
  297. } else {
  298. commonContition += ' and ' + '{' + logicField + '}=' + "'" + thisvalue + "'";
  299. }
  300. } else {
  301. // 判断是否是采购员ID,因为采购员ID设置成DBFIND,则判断不出是数值型还是字符型,故需要特殊处理一下
  302. if (logicField.indexOf('buyerid') > 0 || logicField.indexOf('sellerid') > 0
  303. || logicField.indexOf('yearmonth') > 0) {
  304. console.log("ffff");
  305. if (cop == "成本汇总表") {
  306. commonContition = '{' + logicField + '}=' + "'" + thisvalue + "'";
  307. } else {
  308. commonContition = '{' + logicField + '}=' + thisvalue;
  309. }
  310. } else {
  311. if (cop == "分仓库库存报表" || cop == "仓库盘点表(按品牌规格)" || cop == "集团库存数量金额表"
  312. || cop == "集团库存汇总表" || cop == "集团品牌库存汇总表" || cop == "集团银行余额汇总表"
  313. || cop == "集团业务员应付汇总表") {
  314. var arrcode = '';
  315. var strs = new Array();
  316. if (cop == "分仓库库存报表" || cop == "仓库盘点表(按品牌规格)") {
  317. strs = thisvalue.split("#");
  318. } else {
  319. strs = thisvalue.split(",");
  320. }
  321. if (strs.length > 1) {
  322. for (i = 0; i < strs.length; i++) {
  323. arrcode += "'" + strs[i] + "'" + ",";
  324. }
  325. commonContition = '{' + logicField + '}in ['
  326. + arrcode.substring(0, arrcode.length - 1) + ']';
  327. } else {
  328. commonContition = '{' + logicField + '}=' + "'" + thisvalue + "'";
  329. }
  330. } else {
  331. commonContition = '{' + logicField + '}=' + "'" + thisvalue + "'";
  332. }
  333. }
  334. }
  335. }
  336. }
  337. i = i + 1;
  338. // }
  339. }
  340. // console.log(commonContition);
  341. // consle.lg();
  342. /*
  343. * *******报表公用取条件 start
  344. *
  345. *
  346. * ******* end /
  347. */
  348. /*
  349. * */
  350. /*
  351. *
  352. * if(cop=="估价/成交价差异表"){
  353. *
  354. * var dateRange=Ext.getCmp('ev_date'); var
  355. * codeRange=Ext.getCmp('ev_code');
  356. * console.log(dateRange.valuePrint);
  357. * console.log(codeRange.valuePrint); var codeValuePrint =
  358. * codeRange.valuePrint; var
  359. * dateValuePrint=dateRange.valuePrint; var
  360. * custcode=Ext.getCmp('cu_code'); var
  361. * prodcode=Ext.getCmp('pr_code'); var conditioncode =
  362. * codeValuePrint; var conditiondate = dateValuePrint;
  363. * console.log(conditioncode); console.log(conditiondate);
  364. * reportName="Evaluation"; condition=conditioncode+' and
  365. * '+conditiondate; console.log(condition);
  366. * console.log(form.title); }else if(cop=="采购额‎‎物料"){ var
  367. * dateRange=Ext.getCmp('pi_date'); var
  368. * dateValuePrint=dateRange.valuePrint; var
  369. * kind=Ext.getCmp('pr_kind').value; reportName="ypurc2";
  370. * condition=dateValuePrint+' and
  371. * ('+'{ProdInOut.pi_class}='+"'采购验收单'"+' or
  372. * '+'{ProdInOut.pi_class}='+"'采购验退单'"+')'+' and
  373. * '+'{ProdInOut.pi_status}='+"'已过账'"; if(kind!=""){
  374. * condition+=' and '+'{Product.pr_kind}=' +"'"+kind+"'"; }
  375. * console.log(kind); }else if(cop=="采购额供应商‎‎"){ var
  376. * dateRange=Ext.getCmp('pi_date'); var
  377. * dateValuePrint=dateRange.valuePrint; var
  378. * vendcode=Ext.getCmp('ve_code').value;
  379. * reportName="ypurc1"; condition=dateValuePrint+' and
  380. * ('+'{ProdInOut.pi_class}='+"'采购验收单'"+' or
  381. * '+'{ProdInOut.pi_class}='+"'采购验退单'"+')'+' and
  382. * '+'{ProdInOut.pi_status}='+"'已过账'"; if(vendcode!=""){
  383. * condition+=' and '+'{ProdInout.pi_cardcode}'
  384. * +"'"+vendcode+"'"; } console.log(condition); } else
  385. * if(cop=="客户名条打印"){ reportName="customerMT";
  386. * code=Ext.getCmp('cu_code').value; if (code!=""){
  387. * condition='{customer.cu_code}='+"'"+code+"'"; } }else
  388. * if(cop=="客户信用检查明细表"){ reportName="customerXY";
  389. * code=Ext.getCmp('cu_code').value; if (code!=""){
  390. * condition='{customer.cu_code}='+"'"+code+"'"; } }else
  391. * if(cop=="客户订单明细表"){ reportName="saledetail";
  392. * dateRange=Ext.getCmp('sa_date'); console.log(dateRange);
  393. *
  394. * dateFW=dateRange.value; console.log(dateFW); var
  395. * dateValuePrint=dateRange.valuePrint; var conditiondate =
  396. * dateValuePrint; var
  397. * custcode=Ext.getCmp('sa_custcode').value; var
  398. * prodcode=Ext.getCmp('pr_code').value;
  399. * condition=conditiondate+' and '+'{Sale.sa_status}<>'+"'已结案'";
  400. * if(custcode!=""){ condition+=' and
  401. * '+'{sale.sa_custcode}='+"'"+custcode+"'"; }
  402. * if(prodcode!=""){ condition+=' and
  403. * '+'{saledetail.sd_prodcode}='+"'"+prodcode+"'"; }
  404. * console.log(condition);
  405. *
  406. * }else if(cop=="未发货客户订单明细表"){
  407. * reportName="saledetailnotsend"; var
  408. * dateRange=Ext.getCmp('sa_date'); var
  409. * dateValuePrint=dateRange.valuePrint;
  410. * dateFW=dateRange.value; console.log(dateFW); var
  411. * conditiondate = dateValuePrint; var
  412. * custcode=Ext.getCmp('sa_custcode').value; var
  413. * sellercode=Ext.getCmp('sa_sellercode').value;
  414. * condition=conditiondate+' and
  415. * '+'{SaleDetail.sd_qty}-{SaleDetail.sd_sendqty}>0.001'+'
  416. * and '+'{sale.sa_status}<>'+"'已结案'" ; if(custcode!=""){
  417. * condition+=' and
  418. * '+'{sale.sa_custcode}='+"'"+custcode+"'"; }
  419. * if(sellercode!=""){ condition+=' and
  420. * '+'{sale.sa_sellercode}='+"'"+sellercode+"'"; }
  421. * console.log(condition);
  422. *
  423. * }else if(cop=="价格变动审批表"){ var
  424. * dateRange=Ext.getCmp('pu_date'); var
  425. * dateValuePrint=dateRange.valuePrint; var
  426. * vendcode=Ext.getCmp('pu_vendcode').value;
  427. * prodcode=Ext.getCmp('pr_code').value;
  428. * reportName="PriceChange"; condition=dateValuePrint;
  429. * if(vendcode!=""){ condition+=' and
  430. * '+'{purchase.pu_vendcode}='+"'"+code+"'"; }
  431. * if(prodcode!=""){ condition+=' and
  432. * '+'{purchasedetail.pd_prodcode}='+"'"+prodcode+"'" ; }
  433. * console.log(condition);
  434. *
  435. * }else if(cop=="月COST DOWN统计表"){ var
  436. * dateRange=Ext.getCmp('pu_date'); var
  437. * dateValuePrint=dateRange.valuePrint; var
  438. * vendcode=Ext.getCmp('pu_vendcode').value;
  439. * prodcode=Ext.getCmp('pr_code').value;
  440. * reportName="CostDown"; condition=dateValuePrint;
  441. * if(vendcode!=""){ condition+=' and
  442. * '+'{purchase.pu_vendcode}='+"'"+code+"'"; }
  443. * if(prodcode!=""){ condition+=' and
  444. * '+'{purchasedetail.pd_prodcode}='+"'"+prodcode+"'" ; }
  445. * console.log(condition);
  446. * } else if(cop=="客户订单追踪表"){ var
  447. * dateRange=Ext.getCmp('sa_date'); var
  448. * codeRange=Ext.getCmp('sa_code');
  449. * console.log(dateRange.valuePrint);
  450. * console.log(codeRange.valuePrint); var codeValuePrint =
  451. * codeRange.valuePrint; var
  452. * dateValuePrint=dateRange.valuePrint;
  453. * custcode=Ext.getCmp('cu_code').value;
  454. * reportName="saletrack"; console.log(codeValuePrint);
  455. * condition=dateValuePrint; if(codeValuePrint!=""){
  456. * condition+=' and '+codeValuePrint; } if(custcode!=""){
  457. * condition+=' and
  458. * '+'{sale.sa_custcode}='+"'"+custcode+"'"; }
  459. *
  460. * }else if(cop=="派车费用统计"){ var
  461. * dateRange=Ext.getCmp('tt_date'); dateFW=dateRange.value;
  462. * var dateValuePrint=dateRange.valuePrint;
  463. * reportName="carcosttotal"; var
  464. * custcode=Ext.getCmp('tt_carcode').value; todate=custcode;
  465. * fromdate=Ext.getCmp('tt_date').firstVal;
  466. * enddate=Ext.getCmp('tt_date').secondVal;
  467. *
  468. *
  469. * }else if(cop=="销售订单预计交货表"){ var
  470. * dateRange=Ext.getCmp('sa_date'); var
  471. * codeRange=Ext.getCmp('sa_code');
  472. * console.log(dateRange.valuePrint);
  473. * console.log(codeRange.valuePrint); var codeValuePrint =
  474. * codeRange.valuePrint; var
  475. * dateValuePrint=dateRange.valuePrint;
  476. * console.log(dateValuePrint);
  477. * custcode=Ext.getCmp('cu_code').value;
  478. * reportName="salepresend"; condition=dateValuePrint;
  479. * if(codeValuePrint!=""){ condition+=' and
  480. * '+codeValuePrint; } if(custcode!=""){ condition+=' and
  481. * '+'{sale.sa_custcode}='+"'"+custcode+"'"; } }else
  482. * if(cop=="产品别预计出货表"){ var dateRange=Ext.getCmp('sa_date');
  483. * var codeRange=Ext.getCmp('sa_code');
  484. * console.log(dateRange.valuePrint);
  485. * console.log(codeRange.valuePrint); var codeValuePrint =
  486. * codeRange.valuePrint; var
  487. * dateValuePrint=dateRange.valuePrint;
  488. * console.log(dateValuePrint); reportName="saleprodkind";
  489. * custcode=Ext.getCmp('cu_code').value;
  490. * reportName="salekindsend"; console.log(reportName);
  491. * condition=dateValuePrint; if(codeValuePrint!=""){
  492. * condition+=' and '+codeValuePrint; } if(custcode!=""){
  493. * condition+=' and
  494. * '+'{sale.sa_custcode}='+"'"+custcode+"'"; } }else
  495. * if(cop=="订单生产进度表"){ var dateRange=Ext.getCmp('sa_date');
  496. * var codeRange=Ext.getCmp('sa_code');
  497. * console.log(dateRange.valuePrint);
  498. * console.log(codeRange.valuePrint); var codeValuePrint =
  499. * codeRange.valuePrint; var
  500. * dateValuePrint=dateRange.valuePrint;
  501. * console.log(dateValuePrint); reportName="ProgressSheet";
  502. * custcode=Ext.getCmp('cu_code').value;
  503. * condition=dateValuePrint; if(codeValuePrint!=""){
  504. * condition+=' and '+codeValuePrint; } if(custcode!=""){
  505. * condition+=' and
  506. * '+'{sale.sa_custcode}='+"'"+custcode+"'"; } }else
  507. * if(cop=="出货清单DD"){ var dateRange=Ext.getCmp('pi_date');
  508. * var codeRange=Ext.getCmp('pi_inoutno'); var
  509. * codeValuePrint = codeRange.valuePrint; var
  510. * dateValuePrint=dateRange.valuePrint;
  511. * reportName="SaleSendOut"; condition=codeValuePrint+' and
  512. * '+dateValuePrint; }else if(cop=="出货明细表" || cop=="出货清单"){
  513. * var dateRange=Ext.getCmp('pi_date'); var
  514. * dateValuePrint=dateRange.valuePrint; var
  515. * whcode=Ext.getCmp('pi_whcode').value; var
  516. * depcode=Ext.getCmp('pi_departmentcode').value; var
  517. * status=Ext.getCmp('pi_status').value; var
  518. * cardcode=Ext.getCmp('pi_cardcode').value; var
  519. * piclass=Ext.getCmp('pi_class').value; var
  520. * prodcode=Ext.getCmp('pr_code').value;
  521. * reportName="SaleSendOut"; condition=dateValuePrint;
  522. * if(cardcode!=""){ condition+=" and
  523. * {prodinout.pi_cardcode}='"+cardcode+"' " ; }
  524. * if(whcode!=""){ condition+=' and
  525. * {prodiodetail.pd_whcode}='+"'"+whcode+"'"; }
  526. * if(depcode!=""){ condition+=' and
  527. * {prodinout.pi_departmentcode}='+"'"+depcode+"'"; }
  528. * if(piclass=="出货单"){ condition+=' and
  529. * {prodinout.pi_class}='+"'"+piclass+"'"; }
  530. * if(piclass=="销售退货单"){ condition+=' and
  531. * {prodinout.pi_class}='+"'"+piclass+"'"; }
  532. * if(piclass=="全部"){ condition+=' and
  533. * '+'({prodinout.pi_class}='+"'出货单'"+' or
  534. * '+'{prodinout.pi_class}= '+"'销售退货单'"+")"; }
  535. * if(prodcode!=""){ condition+=' and
  536. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  537. * console.log(condition);
  538. *
  539. * }else if(cop=="包装单打印"){ reportName="paking";
  540. * condition='{packing.pa_id}='+Ext.getCmp('pa_id').value+'';;
  541. * }else if(cop=="销售退货清单打印"){ var
  542. * dateRange=Ext.getCmp('pi_date'); var
  543. * codeRange=Ext.getCmp('pi_inoutno'); var codeValuePrint =
  544. * codeRange.valuePrint; var
  545. * dateValuePrint=dateRange.valuePrint;
  546. * custcode=Ext.getCmp('cu_code').value;
  547. * reportName="Salereturn"; condition=dateValuePrint;
  548. * if(codeValuePrint!=""){ condition+=' and
  549. * '+codeValuePrint; } if(custcode!=""){ condition+=' and
  550. * '+'{prodinout.pi_cardcode}='+"'"+custcode+"'"; }
  551. * console.log(condition); }else if(cop=="销售退货理由分析表"){ var
  552. * dateRange=Ext.getCmp('pi_date');
  553. * custcode=Ext.getCmp('cu_code').value;
  554. * console.log(dateRange.valuePrint); var
  555. * dateValuePrint=dateRange.valuePrint;
  556. * console.log(dateValuePrint); reportName="retulistAn";
  557. * condition=dateValuePrint; if(custcode!=""){ condition+='
  558. * and '+'{prodinout.pi_cardcode}='+"'"+custcode+"'"; }
  559. *
  560. * }else if(cop=="客户别销退理由分析表"){ var
  561. * dateRange=Ext.getCmp('pi_date');
  562. * console.log(dateRange.valuePrint); var
  563. * dateValuePrint=dateRange.valuePrint;
  564. * console.log(dateValuePrint);
  565. * custcode=Ext.getCmp('cu_code').value;
  566. * reportName="salecustkind"; condition=dateValuePrint;
  567. * if(custcode!=""){ condition+=' and
  568. * '+'{prodinout.pi_cardcode}='+"'"+custcode+"'"; } }else
  569. * if(cop=="估价单成本一览表"){ var dateRange=Ext.getCmp('ev_date');
  570. * var codeRange=Ext.getCmp('ev_code');
  571. * console.log(dateRange.valuePrint); var
  572. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  573. * codeRange.valuePrint; console.log(dateValuePrint);
  574. * custcode=Ext.getCmp('cu_code').value;
  575. * prodcode=Ext.getCmp('pr_code').value;
  576. * reportName="EvaluationCB"; condition=dateValuePrint;
  577. * if(codeValuePrint!=""){ condition+=' and ' +
  578. * codeValuePrint; } if(custcode!=""){ condition+=' and '
  579. * +'{Evaluation.ev_custcode}='+"'"+custcode+"'"; }
  580. * if(prodcode!=""){ condition+=' and
  581. * '+'{EvaluationDetail.evd_prodcode}='+prodcode+"'"; }
  582. *
  583. * }else if(cop=="毛利润分析(按客户)"){ var
  584. * dateRange=Ext.getCmp('pi_date'); var
  585. * dateValuePrint=dateRange.valuePrint;
  586. * custcode=Ext.getCmp('sa_custcode').value;
  587. * reportName="PROFITCUSTOMER"; condition=dateValuePrint+'
  588. * and ('+'{prodinout.pi_class}='+"'出货单'"+' or
  589. * '+'{prodinout.pi_class}='+"'销售退货单'"+")";;
  590. * if(custcode!=""){ condition+=' and
  591. * '+'{prodinout.pi_cardcode}='+"'"+custcode+"'"; }
  592. * console.log(condition); }else if(cop=="毛利润分析(按业务员)"){ var
  593. * dateRange=Ext.getCmp('pi_date'); var
  594. * dateValuePrint=dateRange.valuePrint; var
  595. * sellercode=Ext.getCmp('sa_sellercode').value;
  596. * reportName="PROFITSELLER"; condition=dateValuePrint+' and
  597. * ('+'{prodinout.pi_class}='+"'出货单'"+' or
  598. * '+'{prodinout.pi_class}='+"'销售退货单'"+")";
  599. * if(sellercode!=""){ condition+=' and
  600. * '+'{prodinout.pi_sellercode}='+"'"+sellercode+"'"; }
  601. * console.log(condition); }else if(cop=="毛利润分析(按产品)"){ var
  602. * dateRange=Ext.getCmp('pi_date'); var
  603. * dateValuePrint=dateRange.valuePrint; var
  604. * prodcode=Ext.getCmp('pr_code').value;
  605. * reportName="profitproduct"; condition=dateValuePrint+'
  606. * and ('+'{prodinout.pi_class}='+"'出货单'"+' or
  607. * '+'{prodinout.pi_class}='+"'销售退货单'"+")";
  608. * if(prodcode!=""){ condition+=' and
  609. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  610. * console.log(condition); }else if(cop=="毛利润分析(按机型)"){ var
  611. * dateRange=Ext.getCmp('pi_date'); var
  612. * dateValuePrint=dateRange.valuePrint;
  613. * reportName="profitproductkind";
  614. * condition=dateValuePrint+' and
  615. * ('+'{prodinout.pi_class}='+"'出货单'"+' or
  616. * '+'{prodinout.pi_class}='+"'销售退货单'"+")";
  617. *
  618. * console.log(condition); } else if(cop=="毛利润分析明细表"){ var
  619. * dateRange=Ext.getCmp('pi_date'); var
  620. * dateValuePrint=dateRange.valuePrint; var
  621. * sellercode=Ext.getCmp('sa_sellercode').value;
  622. * reportName="PROFITDETAIL"; condition=dateValuePrint+' and
  623. * ('+'{prodinout.pi_class}='+"'出货单'"+' or
  624. * '+'{prodinout.pi_class}='+"'销售退货单'"+")";
  625. * if(sellercode!=""){ condition+=' and
  626. * '+'{prodinout.pi_sellercode}='+"'"+sellercode+"'"; }
  627. * }else if(cop=="销售预测明细表"){ var
  628. * dateRange=Ext.getCmp('sf_tilldate'); var
  629. * dateValuePrint=dateRange.valuePrint; var
  630. * sellercode=Ext.getCmp('cu_code').value;
  631. * reportName="SaleForDetail"; condition=dateValuePrint;
  632. * if(sellercode!=""){ condition+=' and
  633. * '+'{SaleForecast.sf_custcode}='+"'"+sellercode+"'"; } }
  634. * else if(cop=="供应商基本资料表"){ reportName="VendorList";
  635. * code=Ext.getCmp('ve_code').value;
  636. * vendorcode=Ext.getCmp('ve_buyerid').value; if(code!="" &&
  637. * vendorcode!="" ){
  638. * condition='{vendor.ve_code}='+"'"+code+"'"+" and "
  639. * +'{vendor.ve_buyerid}='+code; console.log(condition); }
  640. * if(code!="" && vendorcode==""){
  641. * condition='{vendor.ve_code}='+"'"+code+"'"; } if(code=="" &&
  642. * vendorcode!=""){
  643. * condition='{vendor.ve_buyerid}='+vendorcode; } }else
  644. * if(cop=="供应商名条打印"){ reportName="VendorMT";
  645. * code=Ext.getCmp('ve_code').value; if(code!=""){
  646. * condition='{vendor.ve_code}='+"'"+code+"'"; } }else
  647. * if(cop=="供应商ABC分析表"){ reportName="VendorABC";
  648. * code=Ext.getCmp('ve_code').value; if(code!=""){
  649. * condition='{vendor.ve_code}='+"'"+code+"'"; } }else
  650. * if(cop=="请购清单打印"){ reportName="ApplicationDetail"; var
  651. * dateRange=Ext.getCmp('ap_date'); var
  652. * dateValuePrint=dateRange.valuePrint;
  653. * code=Ext.getCmp('ap_code').value; if(code!="" &&
  654. * dateRange=="[object Object]"){
  655. * condition='{Application.ap_code}='+"'"+code+"'"; }else
  656. * if(code=="" && dateValuePrint!=""){
  657. * condition=dateValuePrint; }else if(code!=""&&
  658. * dateValuePrint!=""){
  659. * condition='{Application.ap_code}='+"'"+code+"'" + " and
  660. * "+dateValuePrint; } }else if(cop=="请购单进度追踪表打印"){
  661. * reportName="ApplicationTrack";
  662. * code=Ext.getCmp('ap_code').value; if(code!=""){
  663. * condition='{Application.ap_code}='+"'"+code+"'"; } }else
  664. * if(cop=="请购转采购清单打印"){ reportName="ApplicationToPur";
  665. * code=Ext.getCmp('ap_code').value; if(code!=""){
  666. * condition='{Application.ap_code}='+"'"+code+"'"; } }else
  667. * if(cop=="采购单交货数量审核表"){ var
  668. * dateRange=Ext.getCmp('pu_date'); var
  669. * codeRange=Ext.getCmp('pu_code');
  670. * console.log(dateRange.valuePrint); var
  671. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  672. * codeRange.valuePrint; console.log(dateValuePrint);
  673. * vendorcode=Ext.getCmp('pu_vendcode').value;
  674. * purchaseman=Ext.getCmp('pu_buyerid').value;
  675. * status=Ext.getCmp('pu_status').value;
  676. * reportName="PurchaseQTY"; condition=dateValuePrint;
  677. * if(codeValuePrint!=""){ condition+=' and
  678. * '+codeValuePrint; } if(vendorcode!=""){ condition+=' and
  679. * '+'{purchase.pu_vendcode}='+"'"+vendorcode+"'"; }
  680. * if(purchaseman!=""){ condition+=' and
  681. * '+'{purchase.pu_buyerid}='+purchaseman+"'"; } }else
  682. * if(cop=="采购单进度追踪表"){ var dateRange=Ext.getCmp('pu_date');
  683. * var codeRange=Ext.getCmp('pu_code');
  684. * console.log(dateRange.valuePrint); var
  685. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  686. * codeRange.valuePrint; console.log(dateValuePrint);
  687. * vendorcode=Ext.getCmp('pu_vendcode').value;
  688. * purchaseman=Ext.getCmp('pu_buyerid').value;
  689. * status=Ext.getCmp('pu_status').value;
  690. * reportName="PurchaseTrack"; condition=dateValuePrint;
  691. * if(codeValuePrint!=""){ condition+=' and
  692. * '+codeValuePrint; } if(vendorcode!=""){ condition+=' and
  693. * '+'{purchase.pu_vendcode}='+"'"+vendorcode+"'"; }
  694. * if(purchaseman!=""){ condition+=' and
  695. * '+'{purchase.pu_buyerid}='+purchaseman+"'"; } }else
  696. * if(cop=="采购单清单打印"){ var dateRange=Ext.getCmp('pu_date');
  697. * var codeRange=Ext.getCmp('pu_code');
  698. * console.log(dateRange.valuePrint); var
  699. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  700. * codeRange.valuePrint; console.log(dateValuePrint);
  701. * vendorcode=Ext.getCmp('pu_vendcode').value;
  702. * purchaseman=Ext.getCmp('pu_buyerid').value;
  703. * reportName="PurcAllDetail"; condition=dateValuePrint;
  704. * if(codeValuePrint!=""){ condition+=' and
  705. * '+codeValuePrint; } if(vendorcode!=""){ condition+=' and
  706. * '+'{purchase.pu_vendcode}='+"'"+vendorcode+"'"; }
  707. * if(purchaseman!=""){ condition+=' and
  708. * '+'{purchase.pu_buyerid}='+purchaseman+"'"; } }else
  709. * if(cop=="物料采购明细表"){ var dateRange=Ext.getCmp('pu_date');
  710. * console.log(dateRange.valuePrint); var
  711. * dateValuePrint=dateRange.valuePrint;
  712. * console.log(dateValuePrint);
  713. * vendorcode=Ext.getCmp('pu_vendcode').value;
  714. * purchaseman=Ext.getCmp('pu_buyerid').value;
  715. * reportName="ProductBuy"; condition=dateValuePrint;
  716. * if(vendorcode!=""){ condition+=' and
  717. * '+'{purchase.pu_vendcode}='+"'"+vendorcode+"'"; } if(
  718. * purchaseman!="") { condition+=' and
  719. * '+'{purchase.pu_buyerid}='+purchaseman; } }else
  720. * if(cop=="收货明细表"){ var dateRange=Ext.getCmp('pi_date');
  721. * var dateValuePrint=dateRange.valuePrint;
  722. * prodcode=Ext.getCmp('pr_code').value; var
  723. * vendcode=Ext.getCmp('ve_code').value; var
  724. * pucode=Ext.getCmp('pu_code').value; var
  725. * piclass=Ext.getCmp('pi_class').value;
  726. *
  727. * reportName="inDetail"; condition=dateValuePrint+' and
  728. * {ProdInOut.pi_status}='+"'已过账'"; // if(prodcode!=""){
  729. * condition+=' and
  730. * {prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  731. * if(vendcode!=""){ condition+=' and
  732. * {prodinout.pi_cardcode}='+"'"+vendcode+"'"; }
  733. * if(pucode!=""){ condition+=' and
  734. * {purchase.pu_code}='+"'"+pucode+"'"; } if(piclass=="全部"){
  735. * condition+=' and '+'({ProdInOut.pi_class}='+"'采购验收单'"+
  736. * 'OR {ProdInOut.pi_class}='+"'采购验退单'"+ 'OR
  737. * {ProdInOut.pi_class}='+"'委外验收单'"+ 'OR
  738. * {ProdInOut.pi_class}='+"'委外验退单'"+ 'OR
  739. * {ProdInOut.pi_class}='+"'不良品入库单'"+' OR
  740. * {ProdInOut.pi_class}='+"'不良品出库单')"; }else{ condition+='
  741. * and {prodinout.pi_class}='+"'"+piclass+"'"; }
  742. * console.log(condition);
  743. * } else if(cop=="未到货采购明细表"){ var
  744. * dateRange=Ext.getCmp('pu_date'); var
  745. * dateValuePrint=dateRange.valuePrint;
  746. * console.log(dateValuePrint);
  747. * vendorcode=Ext.getCmp('pu_vendcode').value;
  748. * purchaseman=Ext.getCmp('pu_buyerid').value; var
  749. * pucode=Ext.getCmp('pu_code').value; var
  750. * prodcode=Ext.getCmp('pr_code').value;
  751. * reportName="PurcAllDetail"; condition=dateValuePrint+'
  752. * and
  753. * '+'({PurchaseDetail.pd_qty}-{PurchaseDetail.pd_acceptqty})>0.001
  754. * AND (ISNULL({PurchaseDetail.pd_mrpstatus}) or
  755. * '+'{PurchaseDetail.pd_mrpstatus}<>'+"'已结案'"+ ' )'+' and
  756. * '+'{purchase.pu_status}<>'+"'已结案'"; if(vendorcode!=""){
  757. * condition+=' and
  758. * '+'{purchase.pu_vendcode}='+"'"+vendorcode+"'"; } if(
  759. * purchaseman!="") { condition+=' and
  760. * '+'{purchase.pu_buyerid}='+purchaseman; } if(pucode!=""){
  761. * condition+=' and '+'{purchase.pu_code}='+"'"+pucode+"'"; }
  762. * if(prodcode!=""){ condition+=' and
  763. * '+'{purchasedetail.pd_prodcode}='+"'"+prodcode+"'"; }
  764. * console.log(condition); } else if(cop=="物料采购单价明细表"){ var
  765. * dateRange=Ext.getCmp('pp_auditdate');
  766. * console.log(dateRange.valuePrint); var
  767. * dateValuePrint=dateRange.valuePrint;
  768. * console.log(dateValuePrint);
  769. * vendorcode=Ext.getCmp('pu_vendcode').value;
  770. * purchaseman=Ext.getCmp('pp_buyerid').value;
  771. * reportName="PurchasePriceDetail";
  772. * condition=dateValuePrint; if(vendorcode!=""){
  773. * condition+=' and
  774. * '+'{PurchasePrice.pp_vendcode}='+"'"+vendorcode+"'"; }
  775. * if( purchaseman!="") { condition+=' and
  776. * '+'{PurchasePrice.pp_buyerid}='+purchaseman; }
  777. *
  778. * }else if(cop=="供应商收货状况表"){ reportName="PurcAllDetail_vv";
  779. * vendorcode=Ext.getCmp('ve_code').value;
  780. * if(vendorcode!=""){
  781. * condition='{Vendor.ve_code}='+"'"+vendorcode+"'"; } }else
  782. * if(cop=="采购物料预计到库状况表"){ var
  783. * dateRange=Ext.getCmp('pu_date'); var
  784. * codeRange=Ext.getCmp('pu_code');
  785. * console.log(dateRange.valuePrint); var
  786. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  787. * codeRange.valuePrint; console.log(dateValuePrint);
  788. * vendorcode=Ext.getCmp('pu_vendcode').value;
  789. * purchaseman=Ext.getCmp('pu_buyerid').value;
  790. * reportName="ProductWLDKZK"; condition=dateValuePrint;
  791. * if(vendorcode!=""){ condition+=' and
  792. * '+'{purchase.pu_vendcode}='+"'"+vendorcode+"'"; } if(
  793. * purchaseman!="") { condition+=' and
  794. * '+'{purchase.pu_buyerid}='+purchaseman; }
  795. * if(codeValuePrint!=""){ condition+=' and
  796. * '+codeValuePrint; } }else if(cop=="采购预测未转明细表"){
  797. * reportName="PurchaseYCWZ";
  798. * code=Ext.getCmp('pf_code').value; if(vendorcode!=""){
  799. * condition='{PurchaseForecast.pf_code}='+"'"+code+"'"; }
  800. * }else if(cop=="采购预测转出明细表"){ reportName="PurchaseYCYZ";
  801. * code=Ext.getCmp('pf_code').value; if(vendorcode!=""){
  802. * condition='{PurchaseForecast.pf_code}='+"'"+code+"'"; }
  803. * }else if(cop=="交货数量统计分析表"){ reportName="InWh";
  804. * code=Ext.getCmp('pi_inoutno').value; if(code!=""){
  805. * condition='{ProdInOut.pi_inoutno}='+"'"+code+"'"; } }else
  806. * if(cop=="交期统计分析表"){ reportName="InJh";
  807. * code=Ext.getCmp('pi_inoutno').value; if(code!=""){
  808. * condition='{ProdInOut.pi_inoutno}='+"'"+code+"'"; } }else
  809. * if(cop=="采购收料统计表"){ reportName="QUA_VerifyApply";
  810. * code=Ext.getCmp('pd_vacode').value; if(code!=""){
  811. * condition='{VerifyApply.va_code}='+"'"+code+"'"; } }else
  812. * if(cop=="采购退货理由分析表"){ reportName="piolistTHreson";
  813. * code=Ext.getCmp('pi_inoutno').value; if(code!=""){
  814. * condition='{ProdInOut.pi_inoutno}='+"'"+code+"'"; } }else
  815. * if(cop=="物料询价历史资料表"){ reportName="InquiryProduct";
  816. * code=Ext.getCmp('pp_code').value; if(code!=""){
  817. * condition='{PurchasePrice.pp_code}='+"'"+code+"'"; }
  818. * }else if(cop=="采购单价统计表"){ reportName="InPrice";
  819. * code=Ext.getCmp('pi_inoutno').value; if(code!=""){
  820. * condition='{ProdInOut.pi_inoutno}='+"'"+code+"'"; } }else
  821. * if(cop=="采购单交货异常表"){ reportName="PurchaseJHNG";
  822. * code=Ext.getCmp('pi_inoutno').value; if(code!=""){
  823. * condition='{ProdInOut.pi_inoutno}='+"'"+code+"'"; } }else
  824. * if(cop=="物料库存成本报表"){ reportName="ProductCBJE";
  825. * code=Ext.getCmp('pr_code').value; if(code!=""){
  826. * condition='{ProductWh.pw_prodcode}='+"'"+code+"'"; }
  827. * }else if(cop=="出入库明细表"){ var
  828. * dateRange=Ext.getCmp('pi_date'); var
  829. * kind=Ext.getCmp('pi_class').value; var
  830. * whcode=Ext.getCmp('pi_whcode').value; var
  831. * batchcode=Ext.getCmp('pd_batchcode').value; var
  832. * status=Ext.getCmp('pi_status').value; var
  833. * department=Ext.getCmp('pi_departmentname').value; var
  834. * dateValuePrint=dateRange.valuePrint;
  835. * prodcode=Ext.getCmp('pr_code').value; var
  836. * xcode=Ext.getCmp('pd_ordercode').value;
  837. * reportName="PRODIO"; condition=dateValuePrint;
  838. * console.log(dateValuePrint); console.log(kind);
  839. * console.log(whcode); if(prodcode!=""){ condition+=' and
  840. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  841. * if(kind!=""&&kind!="全部"){ condition+=' and
  842. * '+'{prodinout.pi_class}='+"'"+kind+"'"; } if(whcode!=""){
  843. * condition+=' and
  844. * '+'{prodiodetail.pd_whcode}='+"'"+whcode+"'"; }
  845. * if(batchcode!=""){ condition+=' and
  846. * '+'{prodiodetail.pd_batchcode}='+"'"+batchcode+"'"; }
  847. * if(status!=""&&status!="全部"){ condition+=' and
  848. * '+'{prodinout.pi_status}='+"'"+status+"'"; }
  849. * if(department!=""){ condition+=' and
  850. * '+'{prodinout.pi_departmentname}='+"'"+department+"'"; }
  851. * if(xcode!=""){ condition+=' and
  852. * '+'{prodiodetail.pd_ordercode}='+"'"+xcode+"'"; }
  853. *
  854. * console.log(condition);
  855. *
  856. * }else if(cop=="出入库明细表(合并)"){ var
  857. * dateRange=Ext.getCmp('pi_date'); var
  858. * kind=Ext.getCmp('pi_class').value; var
  859. * whcode=Ext.getCmp('pi_whcode').value; var
  860. * batchcode=Ext.getCmp('pd_batchcode').value; var
  861. * status=Ext.getCmp('pi_status').value; var
  862. * department=Ext.getCmp('pi_departmentname').value; var
  863. * dateValuePrint=dateRange.valuePrint;
  864. * prodcode=Ext.getCmp('pr_code').value; var
  865. * xcode=Ext.getCmp('pd_ordercode').value;
  866. * reportName="PRODIOHB"; condition=dateValuePrint+' and
  867. * '+'({PRODINOUT.PI_CLASS}='+"'出货单'" + ' or
  868. * {PRODINOUT.PI_CLASS}='+"'生产领料单'"+' or
  869. * {PRODINOUT.PI_CLASS}='+"'生产补料单'"+' or
  870. * {PRODINOUT.PI_CLASS}='+"'其它出库单'"+' or
  871. * {PRODINOUT.PI_CLASS}='+"'拨出单'"+ ' or
  872. * {PRODINOUT.PI_CLASS}='+"'采购验退单')";
  873. * console.log(dateValuePrint); console.log(kind);
  874. * console.log(whcode); if(prodcode!=""){ condition+=' and
  875. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  876. * if(kind!=""&&kind!="全部"){ condition+=' and
  877. * '+'{prodinout.pi_class}='+"'"+kind+"'"; } if(whcode!=""){
  878. * condition+=' and
  879. * '+'{prodiodetail.pd_whcode}='+"'"+whcode+"'"; }
  880. * if(batchcode!=""){ condition+=' and
  881. * '+'{prodiodetail.pd_batchcode}='+"'"+batchcode+"'"; }
  882. * if(status!=""&&status!="全部"){ condition+=' and
  883. * '+'{prodinout.pi_status}='+"'"+status+"'"; }
  884. * if(department!=""){ condition+=' and
  885. * '+'{prodinout.pi_departmentname}='+"'"+department+"'"; }
  886. * if(xcode!=""){ condition+=' and
  887. * '+'{prodiodetail.pd_ordercode}='+"'"+xcode+"'"; }
  888. *
  889. * console.log(condition);
  890. * } else if(cop=="采购验收清单表"){ var
  891. * dateRange=Ext.getCmp('pi_date'); var
  892. * codeRange=Ext.getCmp('pi_inoutno'); var kind='采购验收单'; var
  893. * whcode=Ext.getCmp('pi_whcode').value;
  894. *
  895. * var dateValuePrint=dateRange.valuePrint; var
  896. * codeValuePrint = codeRange.valuePrint;;
  897. * reportName="PRODIO"; condition=dateValuePrint;
  898. * console.log(dateValuePrint); console.log(kind);
  899. * console.log(whcode); if(codeValuePrint!=""){ condition+='
  900. * and '+codeValuePrint; } if(kind!=""){ condition+=' and
  901. * '+'{prodinout.pi_class}='+"'"+kind+"'"; } if(whcode!=""){
  902. * condition+=' and
  903. * '+'{prodiodetail.pd_whcode}='+"'"+whcode+"'"; }
  904. *
  905. * console.log(condition);
  906. * } else if(cop=="仓库库存金额汇总表"){ reportName="ProductJEHZ";
  907. * code=Ext.getCmp('pr_code').value;
  908. * whcode=Ext.getCmp('pw_whcode').value; if(code!=""){
  909. * condition='{ProductWh.pw_prodcode}='+"'"+code+"'"; }else
  910. * if(whcode!=""){ if (code!=""){ condition+=" and
  911. * "+'{ProductWh.pw_whcode}='+"'"+whcode+"'"; }else {
  912. * condition='{ProductWh.pw_whcode}='+"'"+whcode+"'"; } }
  913. * }else if(cop=="仓库库存金额明细表"){ reportName="ProductJEMX";
  914. * code=Ext.getCmp('pr_code').value;
  915. * whcode=Ext.getCmp('pw_whcode').value; if(code!=""){
  916. * condition='{ProductWh.pw_prodcode}='+"'"+code+"'"; }else
  917. * if(whcode!=""){ if (code!=""){ condition+=" and
  918. * "+'{ProductWh.pw_whcode}='+"'"+whcode+"'"; }else {
  919. * condition='{ProductWh.pw_whcode}='+"'"+whcode+"'"; } }
  920. * }else if(cop=="库存数量表"){ reportName="ProductNUM";
  921. * code=Ext.getCmp('pr_code').value;
  922. * //whcode=Ext.getCmp('pw_whcode').value; if(code!=""){
  923. * condition='{ProductOnhand.po_prodcode}='+"'"+code+"'"; }
  924. * }else if(cop=="仓库有效状况表"){ reportName="ProductSFYX";
  925. * code=Ext.getCmp('pr_code').value;
  926. * whcode=Ext.getCmp('ba_whcode').value; if(code!=""){
  927. * condition='{ProductWh.pw_prodcode}='+"'"+code+"'"; }else
  928. * if(whcode!=""){ if (code!=""){ condition+=" and
  929. * "+'{ProductWh.pw_whcode}='+"'"+whcode+"'"; }else {
  930. * condition='{ProductWh.pw_whcode}='+"'"+whcode+"'"; } }
  931. * }else if(cop=="滞料物料分析表"){ reportName="ProductDCWL";
  932. * code=Ext.getCmp('pr_code').value;
  933. * whcode=Ext.getCmp('ba_whcode').value; if(code!=""){
  934. * condition='{ProductWh.pw_prodcode}='+"'"+code+"'"; }else
  935. * if(whcode!=""){ if (code!=""){ condition+=" and
  936. * "+'{ProductWh.pw_whcode}='+"'"+whcode+"'"; }else {
  937. * condition='{ProductWh.pw_whcode}='+"'"+whcode+"'"; } }
  938. * }else if(cop=="库存账龄表"){ reportName="PwAgeAll";
  939. * code=Ext.getCmp('ba_prodcode').value;
  940. * whcode=Ext.getCmp('ba_whcode').value;
  941. * condition="{Batch.ba_date}<={@Date0To} and
  942. * {Batch.ba_thisremain}<>0"; if(code!=""){ condition+='
  943. * and '+'{Batch.ba_prodcode}='+"'"+code+"'"; }
  944. * if(whcode!=""){ condition+=' and
  945. * '+'{Batch.ba_whcode}='+"'"+whcode+"'"; } }else
  946. * if(cop=="库存数量金额账龄表"){ reportName="PwAgeAll";
  947. * code=Ext.getCmp('pr_code').value;
  948. * whcode=Ext.getCmp('pw_whcode').value; if(code!="" &&
  949. * whcode!=""){
  950. * condition='{ProductWh.pw_prodcode}='+"'"+code+"'"+"and"+'{ProductWh.pw_whcode}='+"'"+whcode+"'"; }
  951. * }else if(cop=="低於订购点物料表"){ reportName="PRODLIST";
  952. * code=Ext.getCmp('pr_code').value; if(code!=""){
  953. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  954. * if(cop=="两阶段调拨明细表"){ var dateRange=Ext.getCmp('pi_date');
  955. * var codeRange=Ext.getCmp('pi_inoutno');
  956. * console.log(dateRange.valuePrint); var
  957. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  958. * codeRange.valuePrint;
  959. * prodcode=Ext.getCmp('pr_code').value;
  960. * custcode=Ext.getCmp('cu_code').value;
  961. * reportName="WareHouse"; condition=dateValuePrint;
  962. * if(codeValuePrint!=""){ condition+=' and
  963. * '+codeValuePrint; } if(prodcode!=""){
  964. * condition+='{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  965. * if(custcode!=""){ condition+=' and
  966. * '+'{ProdInOut.pi_cardcode}='+custcode+"'"; }
  967. *
  968. * }else if(cop=="两阶段调拨数量稽核表"){ var
  969. * dateRange=Ext.getCmp('pi_date'); var
  970. * codeRange=Ext.getCmp('pi_inoutno');
  971. * console.log(dateRange.valuePrint); var
  972. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  973. * codeRange.valuePrint;
  974. * prodcode=Ext.getCmp('pr_code').value;
  975. * custcode=Ext.getCmp('cu_code').value;
  976. * reportName="WareHouseYYDB"; condition=dateValuePrint;
  977. * if(codeValuePrint!=""){ condition+=' and
  978. * '+codeValuePrint; } if(prodcode!=""){
  979. * condition+='{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  980. * if(custcode!=""){ condition+=' and
  981. * '+'{ProdInOut.pi_cardcode}='+custcode+"'"; } }else
  982. * if(cop=="营运中心间调拨数量稽核表"){ var
  983. * dateRange=Ext.getCmp('pi_date'); var
  984. * codeRange=Ext.getCmp('pi_inoutno');
  985. * console.log(dateRange.valuePrint); var
  986. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  987. * codeRange.valuePrint;
  988. * prodcode=Ext.getCmp('pr_code').value;
  989. * custcode=Ext.getCmp('cu_code').value;
  990. * reportName="WareHouseCKDB"; condition=dateValuePrint;
  991. * if(codeValuePrint!=""){ condition+=' and
  992. * '+codeValuePrint; } if(prodcode!=""){
  993. * condition+='{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  994. * if(custcode!=""){ condition+=' and
  995. * '+'{ProdInOut.pi_cardcode}='+custcode+"'"; } }else
  996. * if(cop=="营运中心间调拨在途数量统计表"){ var
  997. * dateRange=Ext.getCmp('pi_date'); var
  998. * codeRange=Ext.getCmp('pi_inoutno');
  999. * console.log(dateRange.valuePrint); var
  1000. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  1001. * codeRange.valuePrint; reportName="WareHouseZTSL";
  1002. * prodcode=Ext.getCmp('pr_code').value;
  1003. * custcode=Ext.getCmp('cu_code').value;
  1004. * condition=dateValuePrint; if(codeValuePrint!=""){
  1005. * condition+=' and '+codeValuePrint; } if(prodcode!=""){
  1006. * condition+='{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1007. * if(custcode!=""){ condition+=' and
  1008. * '+'{ProdInOut.pi_cardcode}='+custcode+"'"; } }else
  1009. * if(cop=="ABC分类表"){ reportName="ProductABC";
  1010. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1011. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1012. * if(cop=="物料基本资料表(报表)"){ reportName="PRODLIST";
  1013. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1014. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1015. * if(cop=="物料基本资料-库存资料表(报表)"){ reportName="ProductKCZL";
  1016. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1017. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1018. * if(cop=="物料资料-销售资料"){ reportName="ProductSale";
  1019. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1020. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1021. * if(cop=="物料资料-采购资料"){ reportName="ProductPurchase";
  1022. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1023. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1024. * if(cop=="物料资料-计划资料"){ reportName="ProductJHZL";
  1025. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1026. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1027. * if(cop=="物料资料-财务资料"){ reportName="ProductCWZL";
  1028. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1029. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1030. * if(cop=="物料资料-特征资料"){ reportName="ProductTZZL";
  1031. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1032. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1033. * if(cop=="新增物料资料基本状况表"){ reportName="PRODLIST";
  1034. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1035. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1036. * if(cop=="物料单位换算资料表"){ reportName="ProductDWHS";
  1037. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1038. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1039. * if(cop=="物料库存明细表(报表)"){ reportName="ProductKCMX";
  1040. * code=Ext.getCmp('pr_code').value; if(code!=""){
  1041. * condition='{Product.pr_code}='+"'"+code+"'"; } }else
  1042. * if(cop=="在制委外加工单控制表"){ var
  1043. * dateRange=Ext.getCmp('ma_date'); var
  1044. * codeRange=Ext.getCmp('ma_code');
  1045. * console.log(dateRange.valuePrint); var
  1046. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  1047. * codeRange.valuePrint; reportName="ProgressSheetExp";
  1048. * prodcode=Ext.getCmp('pr_code').value;
  1049. * condition=dateValuePrint; if(codeValuePrint!=""){
  1050. * condition+=' and '+codeValuePrint; } if(prodcode!=""){
  1051. * condition+='{make.ma_prodcode}='+"'"+prodcode+"'"; }
  1052. * }else if(cop=="委外加工单损耗率报表"){ var
  1053. * dateRange=Ext.getCmp('ma_date'); var
  1054. * codeRange=Ext.getCmp('ma_code');
  1055. * console.log(dateRange.valuePrint); var
  1056. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  1057. * codeRange.valuePrint; reportName="Expliolist_bfbl";
  1058. * prodcode=Ext.getCmp('pr_code').value;
  1059. * condition=dateValuePrint; if(codeValuePrint!=""){
  1060. * condition+=' and '+codeValuePrint; } if(prodcode!=""){
  1061. * condition+='{make.ma_prodcode}='+"'"+prodcode+"'"; }
  1062. * }else if(cop=="委外加工变更单打印"){ var
  1063. * dateRange=Ext.getCmp('mc_date'); var
  1064. * codeRange=Ext.getCmp('mc_code');
  1065. * console.log(dateRange.valuePrint); var
  1066. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  1067. * codeRange.valuePrint; reportName="MakeChangeWW_Batch";
  1068. * prodcode=Ext.getCmp('pr_code').value;
  1069. * condition=dateValuePrint; if(codeValuePrint!=""){
  1070. * condition+=' and '+codeValuePrint; } if(prodcode!=""){
  1071. * condition+='{makechangedetail.md_prodcode}='+"'"+prodcode+"'"; }
  1072. * }else if(cop=="在制制造单控制表"){ reportName="ProgressSheet";
  1073. * code=Ext.getCmp('ma_code').value; if(code!=""){
  1074. * condition='{make.ma_code}='+"'"+code+"'"; } }else
  1075. * if(cop=="完工入库明细表"){ var dateRange=Ext.getCmp('pi_date');
  1076. * var codeRange=Ext.getCmp('pi_inoutno');
  1077. * console.log(dateRange.valuePrint); var
  1078. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  1079. * codeRange.valuePrint; reportName="finish_Batch"; var
  1080. * whcode=Ext.getCmp('pi_whcode').value;
  1081. * condition=dateValuePrint; if(codeValuePrint!=""){
  1082. * condition+=' and '+codeValuePrint; } if(whcode!=""){
  1083. * condition+='{ProdInOut.pi_whcode}='+"'"+whcode+"'"; }
  1084. * }else if(cop=="拆件完工入库明细表"){ var
  1085. * date=Ext.getCmp('pi_date'); var
  1086. * code=Ext.getCmp('pi_inoutno');
  1087. * reportName="chaijianDetailh"; var
  1088. * whcode=Ext.getCmp('pi_whcode').value;
  1089. * condition='{ProdInOut.pi_class}='+"'拆件完工入库'";
  1090. * if(code!=""){ condition+=' and
  1091. * '+'{ProdInOut.pi_inoutno}='+"'"+code+"'"; }
  1092. * if(whcode!=""){ condition+=' and
  1093. * '+'{ProdInOut.pi_whcode}='+"'"+whcode+"'"; }
  1094. * if(date!=""){ condition+=' and
  1095. * '+'{ProdInOut.pi_date}='+"'"+date+"'"; } }else
  1096. * if(cop=="制造单变更打印"){ var dateRange=Ext.getCmp('mc_date');
  1097. * var codeRange=Ext.getCmp('mc_inoutno');
  1098. * console.log(dateRange.valuePrint); var
  1099. * dateValuePrint=dateRange.valuePrint; var codeValuePrint =
  1100. * codeRange.valuePrint; reportName="MakeChange_Batch";
  1101. * custcode=Ext.getCmp('pi_cardcode').value;
  1102. * prodcode=Ext.getCmp('pr_code').value;
  1103. * condition=dateValuePrint+' and
  1104. * '+'{makechange.mc_tasktype}='+"'制造变更单'";
  1105. * if(codeValuePrint!=""){ condition+=' and
  1106. * '+codeValuePrint; } if(prodcode!=""){ condition+=' and
  1107. * '+'{makechangedetail.md_prodcode}='+"'"+prodcode+"'"; }
  1108. * }else if(cop=="生产进度报表"){ var
  1109. * dateRange=Ext.getCmp('ma_date');
  1110. * console.log(dateRange.valuePrint); var
  1111. * dateValuePrint=dateRange.valuePrint; //var codeValuePrint =
  1112. * codeRange.valuePrint; reportName="ProgressSheet";
  1113. * custcode=Ext.getCmp('ma_custcode').value;
  1114. * prodcode=Ext.getCmp('ma_prodcode').value;
  1115. * code=Ext.getCmp('ma_code').value;
  1116. * condition=dateValuePrint; if(code!=""){ condition+=' and
  1117. * '+'{make.ma_code}='+"'"+code+"'"; } if(prodcode!=""){
  1118. * condition+=' and
  1119. * '+'{make.ma_prodcode}='+"'"+prodcode+"'"; }
  1120. * if(custcode!=""){ condition+=' and
  1121. * '+'{make.ma_custcode}='+"'"+custcode+"'"; } }else
  1122. * if(cop=="生产执行明细表"){ var dateRange=Ext.getCmp('ma_date');
  1123. * console.log(dateRange.valuePrint); var
  1124. * dateValuePrint=dateRange.valuePrint;
  1125. * reportName="MakeDetail";
  1126. * prodcode=Ext.getCmp('ma_prodcode').value;
  1127. * code=Ext.getCmp('ma_code').value;
  1128. * condition=dateValuePrint; if(code!=""){ condition+=' and
  1129. * '+code; } if(prodcode!=""){ condition+=' and
  1130. * '+'{make.ma_prodcode}='+"'"+prodcode+"'"; }
  1131. *
  1132. * }else if(cop=="生产领料退料明细表"){ var
  1133. * dateRange=Ext.getCmp('pi_date');
  1134. * console.log(dateRange.valuePrint); var
  1135. * dateValuePrint=dateRange.valuePrint; reportName="scll";
  1136. * var code=Ext.getCmp('ma_code').value;
  1137. * prodcode=Ext.getCmp('ma_prodcode').value;
  1138. * condition=dateValuePrint+' and
  1139. * '+'{ProdInOut.pi_status}='+"'已过账'"+' and
  1140. * ('+'{ProdInOut.pi_class}='+"'生产领料单'"+' or
  1141. * '+'{ProdInOut.pi_class}='+"'生产退料单'"+' or
  1142. * '+'{ProdInOut.pi_class}='+"'生产补料单'"+')'; if(code!=""){
  1143. * condition+=' and
  1144. * '+'{prodiodetail.pd_ordercode}='+"'"+code+"'"; }
  1145. * if(prodcode!=""){ condition+=' and
  1146. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1147. * console.log(condition); }else if(cop=="生产领料退料汇总表"){ var
  1148. * dateRange=Ext.getCmp('pi_date');
  1149. * console.log(dateRange.valuePrint); var
  1150. * dateValuePrint=dateRange.valuePrint;
  1151. * reportName="ProdOutMake";
  1152. * prodcode=Ext.getCmp('pr_code').value;
  1153. * condition=dateValuePrint+' and
  1154. * '+'{ProdInOut.pi_status}='+"'已过账'"+' and
  1155. * ('+'{ProdInOut.pi_class}='+"'生产领料单'"+' or
  1156. * '+'{ProdInOut.pi_class}='+"'生产退料单'"+' or
  1157. * '+'{ProdInOut.pi_class}='+"'生产补料单'"+')';
  1158. * if(prodcode!=""){ condition+=' and
  1159. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; } }else
  1160. * if(cop=="生产报废明细表"){ var
  1161. * dateRange=Ext.getCmp('ms_indate');
  1162. * console.log(dateRange.valuePrint); var
  1163. * dateValuePrint=dateRange.valuePrint;
  1164. * reportName="MakeScrapDetail";
  1165. * prodcode=Ext.getCmp('pr_code').value;
  1166. * condition=dateValuePrint; if(prodcode!=""){ condition+='
  1167. * and '+'{MakeScrapDetail.md_prodcode}='+"'"+prodcode+"'"; }
  1168. * }else if(cop=="制造单材料成本统计表"){ var
  1169. * dateRange=Ext.getCmp('pi_date');
  1170. * console.log(dateRange.valuePrint); var
  1171. * dateValuePrint=dateRange.valuePrint;
  1172. * reportName="MakeCost";
  1173. * prodcode=Ext.getCmp('pr_code').value;
  1174. * condition=dateValuePrint; if(prodcode!=""){ condition+='
  1175. * and '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1176. * }else if(cop=="制造用料ECR替代汇总表"){ var
  1177. * dateRange=Ext.getCmp('ma_date');
  1178. * console.log(dateRange.valuePrint); var
  1179. * dateValuePrint=dateRange.valuePrint;
  1180. * reportName="MaterialECR"; var
  1181. * code=Ext.getCmp('ma_code').value;
  1182. * condition=dateValuePrint; if(code!=""){ condition+=' and
  1183. * '+'{makematerial.mm_code}='+"'"+code+"'"; } }else
  1184. * if(cop=="制造单ECN汇总表"){ var
  1185. * dateRange=Ext.getCmp('ma_date');
  1186. * console.log(dateRange.valuePrint); var
  1187. * dateValuePrint=dateRange.valuePrint;
  1188. * reportName="ECNtoMake"; var
  1189. * code=Ext.getCmp('ma_code').value;
  1190. * condition=dateValuePrint; if(code!=""){ condition+=' and
  1191. * '+'{make.ma_code}='+"'"+code+"'"; } }else
  1192. * if(cop=="制造单一览表"){ var dateRange=Ext.getCmp('ma_date');
  1193. * console.log(dateRange.valuePrint); var
  1194. * dateValuePrint=dateRange.valuePrint;
  1195. * reportName="MakeList"; var
  1196. * code=Ext.getCmp('ma_code').value; var
  1197. * status=Ext.getCmp('ma_status').value; var
  1198. * checkstatus=Ext.getCmp('ma_checkstatus').value;
  1199. * condition=dateValuePrint; if(code!=""){ condition+=' and
  1200. * '+'{make.ma_code}='+"'"+code+"'"; } if(status!="全部"){
  1201. * condition+=' and '+'{make.ma_status}='+"'"+status+"'"; }
  1202. * if(checkstatus!="全部"){ condition+=' and
  1203. * '+'{make.ma_checkstatus}='+"'"+checkstatus+"'"; } }else
  1204. * if(cop=="制造单用料明细表"){ var dateRange=Ext.getCmp('ma_date');
  1205. * console.log(dateRange.valuePrint); var
  1206. * dateValuePrint=dateRange.valuePrint;
  1207. * reportName="MakeMaterial_Status";
  1208. * prodcode=Ext.getCmp('ma_prodcode').value;
  1209. * condition=dateValuePrint; if(prodcode!=""){ condition+='
  1210. * and '+'{make.ma_prodcode}='+"'"+prodcode+"'"; } }else
  1211. * if(cop=="生产领料退料明细表"){ var
  1212. * dateRange=Ext.getCmp('ma_date');
  1213. * console.log(dateRange.valuePrint); var
  1214. * dateValuePrint=dateRange.valuePrint;
  1215. * reportName="MakeMaterialUse";
  1216. * prodcode=Ext.getCmp('ma_prodcode').value; var
  1217. * code=Ext.getCmp('ma_code').value;
  1218. * condition=dateValuePrint; if(prodcode!=""){ condition+='
  1219. * and '+'{make.ma_prodcode}='+"'"+prodcode+"'"; }
  1220. * if(code!=""){ condition+=' and
  1221. * '+'{make.ma_code}='+"'"+code+"'"; } }else
  1222. * if(cop=="制造单领料情况"){ var dateRange=Ext.getCmp('ma_date');
  1223. * console.log(dateRange.valuePrint); var
  1224. * dateValuePrint=dateRange.valuePrint;
  1225. * prodcode=Ext.getCmp('pr_code').value;
  1226. * reportName="makeMaterialsum"; condition=dateValuePrint;
  1227. * if(prodcode!=""){ condition+=' and
  1228. * '+'{make.ma_prodcode}='+"'"+prodcode+"'"; } }else
  1229. * if(cop=="制造单领料情况(按结案日期)"){ var
  1230. * dateRange=Ext.getCmp('ma_actenddate');
  1231. * console.log(dateRange.valuePrint); var
  1232. * dateValuePrint=dateRange.valuePrint;
  1233. * prodcode=Ext.getCmp('pr_code').value;
  1234. * dateFW=dateRange.value; console.log(dateFW);
  1235. * reportName="makeMaterialsum"; condition=dateValuePrint+'
  1236. * and '+'{Make.MA_STATUS}='+"'已结案'"; if(prodcode!=""){
  1237. * condition+=' and
  1238. * '+'{make.ma_prodcode}='+"'"+prodcode+"'"; } } else
  1239. * if(cop=="物料状态明细表"){ prodcode=Ext.getCmp('pr_code').value;
  1240. * reportName="ProductBalance"; if(prodcode!=""){
  1241. * condition='{product.pr_code}='+"'"+product+"'"; } }else
  1242. * if(cop=="缺料表分析(按工单)"){ var
  1243. * dateRange=Ext.getCmp('ma_date');
  1244. * console.log(dateRange.valuePrint); var
  1245. * dateValuePrint=dateRange.valuePrint;
  1246. * prodcode=Ext.getCmp('pr_code').value;
  1247. * reportName="MaterialLackForWCPlan_bymake";
  1248. * condition=dateValuePrint; if(prodcode!=""){ condition+='
  1249. * and '+'{make.ma_prodcode}='+"'"+prodcode+"'"; } }else
  1250. * if(cop=="缺料表分析(按物料)"){
  1251. * prodcode=Ext.getCmp('pr_code').value;
  1252. * reportName="MaterialLackForWCPlan_byprod";
  1253. * if(prodcode!=""){
  1254. * condition='{MaterialLackForWCPlan.ml_prodcode}='+"'"+prodcode+"'"; }
  1255. * }else if(cop=="在制仓库库存表(制单)"){ var
  1256. * dateRange=Ext.getCmp('ma_date');
  1257. * console.log(dateRange.valuePrint); var
  1258. * dateValuePrint=dateRange.valuePrint;
  1259. * prodcode=Ext.getCmp('pr_code').value; var
  1260. * whcode=Ext.getCmp('ma_whcode').value;
  1261. * reportName="Makeonhand"; condition=dateValuePrint+' and
  1262. * '+'(isnull({makematerial.mm_materialstatus}) or
  1263. * {makematerial.mm_materialstatus}=" ")';
  1264. * todate=Ext.getCmp('pr_date').rawValue; if(todate==""){
  1265. * var myDate = new Date(); var y=myDate.getFullYear(); var
  1266. * m=myDate.getMonth()+1; var d=myDate.getDate(); m=m<10?"0"+m:m;
  1267. * d=d<10?"0"+d:d; todate=y+"-"+m+"-"+d; }
  1268. *
  1269. *
  1270. * console.log(todate); if(prodcode!=""){ condition+=' and
  1271. * '+'{make.ma_prodcode}='+"'"+prodcode+"'"; }
  1272. * if(whcode!=""){ condition+=' and
  1273. * '+'{make.ma_whcode}='+"'"+whcode+"'"; }
  1274. * console.log(condition); }else if(cop=="在制仓库库存表(汇总)"){ var
  1275. * dateRange=Ext.getCmp('ma_date');
  1276. * console.log(dateRange.valuePrint); var
  1277. * dateValuePrint=dateRange.valuePrint;
  1278. * prodcode=Ext.getCmp('pr_code').value; var
  1279. * whcode=Ext.getCmp('ma_whcode').value;
  1280. * reportName="MakeonhandSum"; condition=dateValuePrint;
  1281. * if(todate==""){ var myDate = new Date(); var
  1282. * y=myDate.getFullYear(); var m=myDate.getMonth()+1; var
  1283. * d=myDate.getDate(); m=m<10?"0"+m:m; d=d<10?"0"+d:d;
  1284. * todate=y+"-"+m+"-"+d; } if(prodcode!=""){ condition+='
  1285. * and '+'{make.ma_prodcode}='+"'"+prodcode+"'"; }
  1286. * if(whcode!=""){ condition+=' and
  1287. * '+'{make.ma_whcode}='+"'"+whcode+"'"; }
  1288. *
  1289. * }else if(cop=="生产领料明细表"){ var
  1290. * dateRange=Ext.getCmp('pi_date');
  1291. * console.log(dateRange.valuePrint); var
  1292. * dateValuePrint=dateRange.valuePrint;
  1293. * prodcode=Ext.getCmp('pr_code').value; reportName="scll";
  1294. * condition=dateValuePrint; if(prodcode!=""){ condition+='
  1295. * and '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1296. * }else if(cop=="委外单一览表"){ var
  1297. * dateRange=Ext.getCmp('ma_date');
  1298. * console.log(dateRange.valuePrint); var
  1299. * dateValuePrint=dateRange.valuePrint;
  1300. * reportName="MakeListWW";
  1301. * prodcode=Ext.getCmp('pr_code').value;
  1302. * condition=dateValuePrint+' and
  1303. * '+'{make.ma_tasktype}='+"'OS'"; if(prodcode!=""){
  1304. * condition+=' and
  1305. * '+'{make.ma_prodcode}='+"'"+prodcode+"'"; } }else
  1306. * if(cop=="委外领退料明细表"){ var dateRange=Ext.getCmp('pi_date');
  1307. * console.log(dateRange.valuePrint); var
  1308. * dateValuePrint=dateRange.valuePrint;
  1309. * prodcode=Ext.getCmp('pr_code').value;
  1310. * reportName="scllWW"; condition=dateValuePrint;
  1311. * if(prodcode!=""){ condition+=' and
  1312. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; } }else
  1313. * if(cop=="委外入库明细表"){ var dateRange=Ext.getCmp('pi_date');
  1314. * var dateValuePrint=dateRange.valuePrint;
  1315. * prodcode=Ext.getCmp('pr_code').value;
  1316. * reportName="PRODIO"; condition=dateValuePrint;
  1317. * if(prodcode!=""){ condition+=' and
  1318. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; } }else
  1319. * if(cop=="标准工时统计"){ var dateRange=Ext.getCmp('pi_date');
  1320. * var dateValuePrint=dateRange.valuePrint;
  1321. * condition=dateValuePrint+' and
  1322. * '+'{prodinout.pi_status}='+"'已过账'"+' and
  1323. * '+'{prodinout.pi_class}='+"'完工入库单'"; reportName="bztime";
  1324. * }else if(cop=="出入库单状态统计表"){ var
  1325. * dateRange=Ext.getCmp('pi_date'); var
  1326. * dateValuePrint=dateRange.valuePrint;
  1327. * condition=dateValuePrint; reportName="ProdInoutStatus";
  1328. * console.log(condition); }else if(cop=="制造单备料单"){ var
  1329. * code=Ext.getCmp('ma_code').value; var
  1330. * remark=Ext.getCmp('ma_remark').value; if(remark=="A4"){
  1331. * reportName="MakeUsagePrebymake"; } if(remark=="半刀"){
  1332. * reportName="MakeUsagePrebymake_14"; } if(code!=""){
  1333. * condition='{MA_MAKEMATERIAL_VIEW.ma_code}='+"'"+code+"'";
  1334. * } }else if(cop=="制造单备料单(按物料合并)"){ var
  1335. * prodcode=Ext.getCmp('ma_prodcode').value; var
  1336. * wccode=Ext.getCmp('ma_wccode').value; var
  1337. * code=Ext.getCmp('ma_code').value; var
  1338. * remark=Ext.getCmp('ma_reamrk').value;
  1339. * condition='{MA_MAKEUSEPRE.ma_checkstatus}='+"'已批准'"; var
  1340. * arrcode=''; var strs= new Array(); strs=code.split("#");
  1341. * console.log(strs.length); if(strs.length>1){ for(i=0;i<strs.length;i++){
  1342. * arrcode+="'"+strs[i]+"'"+","; } condition+=' and
  1343. * '+'{MA_MAKEUSEPRE.ma_code}in['+arrcode.substring(0,
  1344. * arrcode.length-1)+']'; }else{ if(code!=""){ condition+='
  1345. * and '+'{MA_MAKEUSEPRE.ma_code}in['+"'"+code+"'"+']'; } }
  1346. * if(remark=="A4"){ reportName="MakeUsagePre"; }
  1347. * if(remark=="半刀"){ reportName="MakeUsagePre_14"; }
  1348. * if(prodcode!=""){ condition+=' and
  1349. * '+'{MA_MAKEUSEPRE.mm_prodcode}='+"'"+prodcode+"'"; }
  1350. * if(wccode!=""){ condition+=' and
  1351. * '+'{MA_MAKEUSEPRE.ma_wccode}='+"'"+wccode+"'"; }
  1352. * ///if(code!=""){ //condititon+=' and
  1353. * '+'{MA_MAKEUSEPRE.ma_code}='+"'"+arrcode+"'"; //}
  1354. * console.log(condition); }else
  1355. * if(cop=="未到货采购汇总表‎(‎按物料‎)"){ var
  1356. * dateRange=Ext.getCmp('pu_date'); var
  1357. * dateValuePrint=dateRange.valuePrint; var
  1358. * prodcode=Ext.getCmp('pr_code').value;
  1359. * reportName="purcalldetail_p"; condition=dateValuePrint+'
  1360. * and
  1361. * ('+'{PurchaseDetail.pd_qty}-{PurchaseDetail.pd_acceptqty})>0.001'+'
  1362. * and '+'{PurchaseDetail.pd_mrpstatus}<>'+"'已结案'";
  1363. * if(prodcode!=""){ condition+=' and
  1364. * '+'{PurchaseDetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1365. * console.log(condition); }else
  1366. * if(cop=="未到货采购汇总表‎(‎按供应商‎)"){ var
  1367. * dateRange=Ext.getCmp('pu_date'); var
  1368. * dateValuePrint=dateRange.valuePrint; var
  1369. * prodcode=Ext.getCmp('pr_code').value;
  1370. * reportName="purcalldetail_v"; condition=dateValuePrint+'
  1371. * and
  1372. * ('+'{PurchaseDetail.pd_qty}-{PurchaseDetail.pd_acceptqty})>0.001'+'
  1373. * and '+'{PurchaseDetail.pd_mrpstatus}<>'+"'已结案'";
  1374. * if(prodcode!=""){ condition+=' and
  1375. * '+'{PurchaseDetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1376. * console.log(condition); }else if(cop=="收料明细表"){ var
  1377. * dateRange=Ext.getCmp('va_date'); var
  1378. * dateValuePrint=dateRange.valuePrint; var
  1379. * vendcode=Ext.getCmp('ve_code').value; var
  1380. * prodcode=Ext.getCmp('pr_code').value;
  1381. * reportName="QUA_VerifyApply"; condition=dateValuePrint;
  1382. * if(vendcode!=""){ condition+=' and
  1383. * '+'{VerifyApply.va_vendcode}='+"'"+vendcode+"'"; }
  1384. * if(prodcode!=""){ condition+=' and
  1385. * '+'{Product.pr_code}='+"'"+prodcode+"'"; }
  1386. * console.log(condition); }else if(cop=="采购汇总表(按供应商)"){ var
  1387. * dateRange=Ext.getCmp('pu_date'); var
  1388. * dateValuePrint=dateRange.valuePrint; var
  1389. * vendcode=Ext.getCmp('ve_code').value; var
  1390. * prodcode=Ext.getCmp('pr_code').value;
  1391. * reportName="PurTotal_V"; condition=dateValuePrint;
  1392. * if(vendcode!=""){ condition+=' and
  1393. * '+'{Purchase.pu_vendcode}='+"'"+prodcode+"'"; }
  1394. * if(prodcode!=""){ condition+=' and
  1395. * '+'{PurchaseDetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1396. * console.log(condition); }else if(cop=="采购汇总表(按物料)"){ var
  1397. * dateRange=Ext.getCmp('pu_date'); var
  1398. * dateValuePrint=dateRange.valuePrint; var
  1399. * vendcode=Ext.getCmp('ve_code').value; var
  1400. * prodcode=Ext.getCmp('pr_code').value;
  1401. * reportName="PurTotal_P"; condition=dateValuePrint+' and
  1402. * '+'{Purchase.pu_status}='+"'已审核'"+' and
  1403. * '+'{Purchase.pu_status}<>'+"'已作废'"+' and
  1404. * '+'{Purchase.pu_status}<>'+"'已结案'"; if(vendcode!=""){
  1405. * condition+=' and
  1406. * '+'{Purchase.pu_vendcode}='+"'"+vendcode+"'"; }
  1407. * if(prodcode!=""){ condition+=' and
  1408. * '+'{PurchaseDetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1409. * console.log(condition); }else if(cop=="采购汇总表(按订单)"){ var
  1410. * dateRange=Ext.getCmp('pu_date'); var
  1411. * dateValuePrint=dateRange.valuePrint; var
  1412. * vendcode=Ext.getCmp('ve_code').value; var
  1413. * prodcode=Ext.getCmp('pr_code').value; var
  1414. * pucode=Ext.getCmp('pu_code').value;
  1415. * reportName="PurTotal_S"; condition=dateValuePrint+' and
  1416. * '+'{Purchase.pu_status}='+"'已审核'"+' and
  1417. * '+'{Purchase.pu_status}<>'+"'已作废'"+' and
  1418. * '+'{Purchase.pu_status}<>'+"'已结案'"; if(vendcode!=""){
  1419. * condition+=' and
  1420. * '+'{Purchase.pu_vendcode}='+"'"+vendcode+"'"; }
  1421. * if(prodcode!=""){ condition+=' and
  1422. * '+'{PurchaseDetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1423. * if(pucode!=""){ condition+=' and
  1424. * '+'{Purchase.pu_code}='+"'"+pucode+"'"; }
  1425. * console.log(condition); }else if(cop=="超期未到货明细表"){ var
  1426. * dateRange=Ext.getCmp('pu_date'); var
  1427. * dateValuePrint=dateRange.valuePrint; var
  1428. * vendcode=Ext.getCmp('ve_code').value; var
  1429. * prodcode=Ext.getCmp('pr_code').value; var
  1430. * pucode=Ext.getCmp('pu_code').value;
  1431. * reportName="purcalldetail"; if(todate==""){ var myDate =
  1432. * new Date(); var y=myDate.getFullYear(); var
  1433. * m=myDate.getMonth()+1; var d=myDate.getDate(); m=m<10?"0"+m:m;
  1434. * d=d<10?"0"+d:d; todate=y+"-"+m+"-"+d; }
  1435. * console.log(todate); condition=dateValuePrint+' and
  1436. * ('+'{PurchaseDetail.pd_qty}-{PurchaseDetail.pd_acceptqty})>0.001
  1437. * and {PurchaseDetail.pd_delivery}<='+'date('+"'"+todate+"'"+')';
  1438. * if(vendcode!=""){ condition+=' and
  1439. * '+'{Purchase.pu_vendcode}='+"'"+vendcode+"'"; }
  1440. * if(prodcode!=""){ condition+=' and
  1441. * '+'{PurchaseDetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1442. * if(pu_code!=""){ condition+=' and
  1443. * '+'{Purchase.pu_code}='+"'"+pucode+"'"; }
  1444. * console.log(condition); }else if(cop=="分仓库库存报表"){ var
  1445. * whcode=Ext.getCmp('pi_whcode').value;
  1446. * console.log(whcode); reportName="pronhandw";
  1447. * condition='{ProductWH.pw_onhand}>0'; if(whcode!=""){
  1448. * condition+=' and
  1449. * '+'{ProductWH.pw_whcode}='+"'"+whcode+"'"; }
  1450. * console.log(condition); }else if(cop=="出入库汇总表"){ var
  1451. * dateRange=Ext.getCmp('pi_date'); var
  1452. * dateValuePrint=dateRange.valuePrint; var
  1453. * prodcode=Ext.getCmp('pr_code').value; var
  1454. * whcode=Ext.getCmp('pi_whcode').value;
  1455. * condition=dateValuePrint; reportName="ProdIOTotal";
  1456. * if(prodcode!=""){ condition+=' and
  1457. * '+'{ProdIoDetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1458. * if(whcode!=""){ condition+=' and
  1459. * '+'{ProdInout.pd_whcode}='+"'"+whcode+"'"; }
  1460. * console.log(condition);
  1461. *
  1462. * }else if(cop=="分仓库库存总表"){ reportName="pronhandwtotal";
  1463. * var whcode=Ext.getCmp('pi_whcode').value;
  1464. * condition='{ProductWH.pw_onhand}>0'; if(whcode!=""){
  1465. * condition+=' and
  1466. * '+'{ProductWH.pw_whcode}='+"'"+whcode+"'"; } }else
  1467. * if(cop=="下阶工单查询"){ var dateRange=Ext.getCmp('ma_date');
  1468. * var dateValuePrint=dateRange.valuePrint; var
  1469. * macode=Ext.getCmp('ma_code').value; console.log(macode);
  1470. * var i; var arrcode="";
  1471. *
  1472. * var strs= new Array(); strs=macode.split("#");
  1473. * console.log(strs.length); reportName="MakeMaterial33";
  1474. * condition=dateValuePrint; if(strs.length>1){ for(i=0;i<strs.length;i++){
  1475. * arrcode+="'"+strs[i]+"'"+","; } condition+=' and
  1476. * '+'{MakeMaterial.mm_processcode}
  1477. * in['+arrcode.substring(0, arrcode.length-1)+']';
  1478. * idS=arrcode.substring(0, arrcode.length-1); }else{
  1479. * if(macode!=""){ condition+=' and
  1480. * '+'{MakeMaterial.mm_processcode} in['+"'"+macode+"'"+']';
  1481. * idS="'"+macode+"'"; } }
  1482. *
  1483. * console.log(condition); }else if(cop=="工单调拨查询"){ var
  1484. * dateRange=Ext.getCmp('ma_date'); var
  1485. * dateValuePrint=dateRange.valuePrint; var
  1486. * macode=Ext.getCmp('ma_code').value; console.log(macode);
  1487. * var i; var arrcode="";
  1488. *
  1489. * var strs= new Array(); strs=macode.split("#");
  1490. * console.log(strs.length); reportName="MakeMaterial31";
  1491. * condition=dateValuePrint; if(strs.length>1){ for(i=0;i<strs.length;i++){
  1492. * arrcode+="'"+strs[i]+"'"+","; } condition+=' and
  1493. * '+'{make.ma_code} in['+arrcode.substring(0,
  1494. * arrcode.length-1)+']'; idS=arrcode.substring(0,
  1495. * arrcode.length-1); }else{ if(macode!=""){ condition+='
  1496. * and '+'{make.ma_code} in['+"'"+macode+"'"+']';
  1497. * idS="'"+macode+"'"; } } console.log(condition); }else
  1498. * if(cop=="工单素材查询"){
  1499. *
  1500. * var dateRange=Ext.getCmp('ma_date'); var
  1501. * dateValuePrint=dateRange.valuePrint; var
  1502. * macode=Ext.getCmp('ma_code').value; console.log(macode);
  1503. * var i; var arrcode="";
  1504. *
  1505. * var strs= new Array(); strs=macode.split("#");
  1506. * console.log(strs.length); reportName="MakeMaterial32";
  1507. * condition=dateValuePrint; if(strs.length>1){ for(i=0;i<strs.length;i++){
  1508. * arrcode+="'"+strs[i]+"'"+","; } condition+=' and
  1509. * '+'{make.ma_code} in['+arrcode.substring(0,
  1510. * arrcode.length-1)+']'; idS=arrcode.substring(0,
  1511. * arrcode.length-1); }else{ if(macode!=""){ condition+='
  1512. * and '+'{make.ma_code} in['+"'"+macode+"'"+']';
  1513. * idS="'"+macode+"'"; } } console.log(condition);
  1514. *
  1515. * }else if(cop=="物料时段需求分析"){ reportName="ProdMonthNeed";
  1516. *
  1517. * var prodcode=Ext.getCmp('pr_code').value; var
  1518. * kind=Ext.getCmp('pr_jhzc').value; if(kind=="外购件"){
  1519. * if(prodcode!=""){ condition="{product.pr_status}='已审核'
  1520. * and {product.pr_supplytype}<>'VIRTUAL' and
  1521. * {product.pr_manutype}='PURCHASE'"+' and
  1522. * '+'{product.pr_code}='+"'"+prodcode+"'"; } }
  1523. * if(kind=="制造件"){ if(prodcode!=""){
  1524. * condition="{product.pr_status}='已审核' and
  1525. * {product.pr_supplytype}<>'虚拟件' and
  1526. * ({product.pr_manutype}='MAKE' or
  1527. * {product.pr_manutype}='OSMAKE')"+' and
  1528. * '+'{product.pr_code}='+"'"+prodcode+"'"; } } }else
  1529. * if(cop=="发票明细查询"){ var dateRange=Ext.getCmp('ab_date');
  1530. * var dateValuePrint=dateRange.valuePrint; var
  1531. * custcode=Ext.getCmp('ma_custcode').value; var
  1532. * prodcode=Ext.getCmp('pr_code').value;
  1533. * reportName="ArbillDetail"; condition=dateValuePrint;
  1534. * if(custcode!=""){ condition+=' and
  1535. * '+'{ArBill.ab_custcode}='+"'"+custcode+"'"; }
  1536. * if(prodcode!=""){ condition+=' and
  1537. * '+'{ARBILLDetail.abd_prodcode}='+"'"+prodcode+"'"; }
  1538. * }else if(cop=="发票明细查询香港"){ var
  1539. * dateRange=Ext.getCmp('ab_date'); var
  1540. * dateValuePrint=dateRange.valuePrint; var
  1541. * custcode=Ext.getCmp('ma_custcode').value; var
  1542. * prodcode=Ext.getCmp('pr_code').value;
  1543. * reportName="ArbillDetail_hk"; condition=dateValuePrint;
  1544. * if(custcode!=""){ condition+=' and
  1545. * '+'{ArBill.ab_custcode}='+"'"+custcode+"'"; }
  1546. * if(prodcode!=""){ condition+=' and
  1547. * '+'{ARBILLDetail.abd_prodcode}='+"'"+prodcode+"'"; } }
  1548. * else if(cop=="批记录"){ reportName="BATCHLST"; var
  1549. * whcode=Ext.getCmp('ba_whcode').value; var
  1550. * batchcode=Ext.getCmp('ba_code').value; var
  1551. * prodcode=Ext.getCmp('pr_code').value;
  1552. * condition="{Batch.ba_remain}>0"; if(whcode!=""){
  1553. * condition+=' and '+'{batch.ba_whcode}='+"'"+whcode+"'"; }
  1554. * if(batchcode!=""){ condition+=' and
  1555. * '+'{batch.ba_code}='+"'"+batchcode+"'"; }
  1556. * if(prodcode!=""){ condition+=' and
  1557. * '+'{batch.ba_prodcode}='+"'"+prodcode+"'"; }
  1558. * console.log(condition); }else if(cop=="开票明细表"){ var
  1559. * dateRange=Ext.getCmp('ab_date'); var
  1560. * dateValuePrint=dateRange.valuePrint;
  1561. * reportName="billout"; var
  1562. * custcode=Ext.getCmp('ab_custcode').value;
  1563. * condition=dateValuePrint; if(custcode!=""){ condition+='
  1564. * and '+'{arbill.ab_custcode}='+"'"+custcode+"'"; }
  1565. * console.log(condition); }else if(cop=="开票明细表香港"){ var
  1566. * dateRange=Ext.getCmp('ab_date'); var
  1567. * dateValuePrint=dateRange.valuePrint;
  1568. * reportName="billout_hk"; var
  1569. * custcode=Ext.getCmp('ab_custcode').value;
  1570. * condition=dateValuePrint; if(custcode!=""){ condition+='
  1571. * and '+'{arbill.ab_custcode}='+"'"+custcode+"'"; }
  1572. * console.log(condition); } else if(cop=="出入库明细表(过账日期)"){
  1573. * var dateRange=Ext.getCmp('pi_date1'); var
  1574. * kind=Ext.getCmp('pi_class').value; var
  1575. * whcode=Ext.getCmp('pi_whcode').value; var
  1576. * batchcode=Ext.getCmp('pd_batchcode').value; var
  1577. * status=Ext.getCmp('pi_status').value; var
  1578. * department=Ext.getCmp('pi_departmentname').value; var
  1579. * dateValuePrint=dateRange.valuePrint;
  1580. * prodcode=Ext.getCmp('pr_code').value;
  1581. * reportName="PRODIO"; condition=dateValuePrint;
  1582. * console.log(dateValuePrint); console.log(kind);
  1583. * console.log(whcode); if(prodcode!=""){ condition+=' and
  1584. * '+'{prodiodetail.pd_prodcode}='+"'"+prodcode+"'"; }
  1585. * if(kind!=""&&kind!="全部"){ condition+=' and
  1586. * '+'{prodinout.pi_class}='+"'"+kind+"'"; } if(whcode!=""){
  1587. * condition+=' and
  1588. * '+'{prodiodetail.pd_whcode}='+"'"+whcode+"'"; }
  1589. * if(batchcode!=""){ condition+=' and
  1590. * '+'{prodiodetail.pd_batchcode}='+"'"+batchcode+"'"; }
  1591. * if(status!=""&&status!="全部"){ condition+=' and
  1592. * '+'{prodinout.pi_status}='+"'"+status+"'"; }
  1593. * if(department!=""){ condition+=' and
  1594. * '+'{prodinout.pi_departmentname}='+"'"+department+"'"; }
  1595. *
  1596. * console.log(condition);
  1597. * } else if(cop=="月销售分析表香港"){ var
  1598. * dateRange=Ext.getCmp('ab_date'); var
  1599. * dateValuePrint=dateRange.valuePrint;
  1600. * reportName="billout_month_hk"; var
  1601. * custcode=Ext.getCmp('ab_custcode').value;
  1602. * condition=dateValuePrint+' and '+' (
  1603. * ({arbill.ab_class}='+"'其它应收单'"+' and
  1604. * '+'({ARBillDetail.abd_catecode} like '+ "'5101*'"+ ' or
  1605. * {ARBillDetail.abd_catecode} like '+ "'5102*'))"+' or
  1606. * '+'{arbill.ab_class}<>'+"'其它应收单')"; if(custcode!=""){
  1607. * condition+=' and
  1608. * '+'{arbill.ab_custcode}='+"'"+custcode+"'"; }
  1609. * console.log(condition); } else if(cop=="月销售分析表"){ var
  1610. * dateRange=Ext.getCmp('ab_date'); var
  1611. * dateValuePrint=dateRange.valuePrint;
  1612. * reportName="billout_month"; var
  1613. * custcode=Ext.getCmp('ab_custcode').value;
  1614. * condition=dateValuePrint+' and '+' (
  1615. * ({arbill.ab_class}='+"'其它应收单'"+' and
  1616. * '+'({ARBillDetail.abd_catecode} like '+ "'5101*'"+ ' or
  1617. * {ARBillDetail.abd_catecode} like '+ "'5102*'))"+' or
  1618. * '+'{arbill.ab_class}<>'+"'其它应收单')"; if(custcode!=""){
  1619. * condition+=' and
  1620. * '+'{arbill.ab_custcode}='+"'"+custcode+"'"; }
  1621. * console.log(condition); } else if(cop=="派车次数统计"){ var
  1622. * dateRange=Ext.getCmp('vr_recorddate'); var
  1623. * dateValuePrint=dateRange.valuePrint;
  1624. * reportName="carcountdetail"; var
  1625. * custcode=Ext.getCmp('vr_depart').value;
  1626. * condition=dateValuePrint; if(custcode!=""){ condition+='
  1627. * and '+'{Vehiclereturn.vr_depart}='+"'"+custcode+"'"; }
  1628. * console.log(condition); }else if(cop=="部门派车费用统计"){ var
  1629. * dateRange=Ext.getCmp('vr_recorddate'); var
  1630. * dateValuePrint=dateRange.valuePrint;
  1631. * reportName="carcostdepart"; var
  1632. * custcode=Ext.getCmp('vr_depart').value;
  1633. * condition=dateValuePrint; if(custcode!=""){ condition+='
  1634. * and '+'{Vehiclereturn.vr_depart}='+"'"+custcode+"'"; }
  1635. * console.log(condition); }else if(cop=="成本汇总表"){ var
  1636. * datemonth=Ext.getCmp('cd_yearmonth').value;
  1637. * console.log(datemonth); reportName="CostDetail";
  1638. * condition='{CostDetail.cd_yearmonth}='+"'"+datemonth+"'";
  1639. * console.log(condition); }else if(cop=="成本用料月结表"){ var
  1640. * datemonth=Ext.getCmp('cd_yearmonth').value;
  1641. * console.log(datemonth); reportName="costdetailmaterial";
  1642. * condition='{CostDetailMaterial.cdm_yearmonth}='+datemonth;
  1643. * console.log(condition); }else if(cop=="未开票明细表"){ var
  1644. * dateRange=Ext.getCmp('pi_date'); var
  1645. * dateValuePrint=dateRange.valuePrint;
  1646. * reportName="wkpDetail"; var
  1647. * custcode=Ext.getCmp('pi_arcode').value;
  1648. * condition=dateValuePrint; if(custcode!=""){ condition+='
  1649. * and
  1650. * '+'{FA_NOTKP_ARBILL_VIEW.pi_arcode}='+"'"+custcode+"'"; }
  1651. * console.log(condition); }else if(cop=="应付开票明细表"){ var
  1652. * dateRange=Ext.getCmp('ab_date'); var
  1653. * dateValuePrint=dateRange.valuePrint;
  1654. * reportName="BillOutAPDetail"; var
  1655. * vendcode=Ext.getCmp('ab_vendcode').value;
  1656. * condition=dateValuePrint; if(vendcode!=""){ condition+='
  1657. * and '+'{apbill.ab_vendcode}='+"'"+vendcode+"'"; }
  1658. * console.log(condition); }else if(cop=="应付开票明细表香港"){ var
  1659. * dateRange=Ext.getCmp('ab_date'); var
  1660. * dateValuePrint=dateRange.valuePrint;
  1661. * reportName="BillOutAPDetail_hk"; var
  1662. * vendcode=Ext.getCmp('ab_vendcode').value;
  1663. * condition=dateValuePrint; if(vendcode!=""){ condition+='
  1664. * and '+'{apbill.ab_vendcode}='+"'"+vendcode+"'"; }
  1665. * console.log(condition); } else if(cop=="应付未开票明细表"){ var
  1666. * dateRange=Ext.getCmp('pi_date'); var
  1667. * dateValuePrint=dateRange.valuePrint;
  1668. * reportName="ApwkpDetail"; var
  1669. * vendcode=Ext.getCmp('pi_receivecode').value;
  1670. * condition=dateValuePrint; if(vendcode!=""){ condition+='
  1671. * and
  1672. * '+'{FA_NOTKP_APBILL_VIEW.pi_receivecode}='+"'"+vendcode+"'"; }
  1673. * console.log(condition); } else if(cop=="已完成采购总额"){ var
  1674. * dateRange=Ext.getCmp('pi_date'); var
  1675. * dateValuePrint=dateRange.valuePrint;
  1676. * reportName="purchaseAll"; condition=dateValuePrint+' and '
  1677. * +'({ProdInOut.pi_class}='+"'采购验收单'"+' or
  1678. * '+'{ProdInOut.pi_class}='+"'采购验退单')"+' and
  1679. * '+'{ProdInOut.pi_status}='+"'已过账'";
  1680. * console.log(condition); }else if(cop=="流程单打印"){ var
  1681. * code=Ext.getCmp('si_flowcode').value;
  1682. * reportName="byqmakeflow"; if(code!=""){
  1683. * condition='{MakeFlow.mf_code}='+"'"+code+"'"; }
  1684. * console.log(condition); }else if(cop=="生产日报明细表"){ var
  1685. * dateRange=Ext.getCmp('di_date'); var
  1686. * dateValuePrint=dateRange.valuePrint;
  1687. * reportName="MakeDayDetail"; condition=dateValuePrint;
  1688. * console.log(condition); }else if(cop=="集团出入库明细表"){ var
  1689. * dateRange=Ext.getCmp('pi_date'); var
  1690. * dateValuePrint=dateRange.valuePrint;
  1691. * prodcode=Ext.getCmp('pd_prodcode').value; var
  1692. * piclass=Ext.getCmp('pi_class').value;
  1693. * reportName="ProdIO_Group"; condition=dateValuePrint;
  1694. * if(prodcode!=""){ condition+=' and
  1695. * '+'{GROUP_PRODIO_VIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1696. * if(piclass!=""){ condition+=' and
  1697. * '+'{GROUP_PRODIO_VIEW.pi_class}='+"'"+piclass+"'"; }
  1698. * }else if(cop=="集团毛利润分析明细表"){ var
  1699. * dateRange=Ext.getCmp('pi_date'); var
  1700. * dateValuePrint=dateRange.valuePrint; var
  1701. * cop=Ext.getCmp('pi_cop').value; var
  1702. * custcode=Ext.getCmp('cu_code').value; var
  1703. * sellercode=Ext.getCmp('pi_emcode').value;
  1704. * prodcode=Ext.getCmp('pd_prodcode').value;
  1705. * reportName="PROFITDETAIL_Group";
  1706. * condition=dateValuePrint; if(cop!=""){ condition+=' and
  1707. * '+'{GETALLDATA_VIEW.pi_code}='+"'"+cop+"'"; }
  1708. * if(custcode!=""){ condition+=' and
  1709. * '+'{GETALLDATA_VIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1710. * if(sellercode!=""){ condition+=' and
  1711. * '+'{GETALLDATA_VIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1712. * if(prodcode!=""){ condition+=' and
  1713. * '+'{GETALLDATA_VIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1714. * }else if(cop=="集团毛利润分析表-按客户"){ var
  1715. * dateRange=Ext.getCmp('pi_date'); var
  1716. * dateValuePrint=dateRange.valuePrint; var
  1717. * cop=Ext.getCmp('pi_cop').value; var
  1718. * custcode=Ext.getCmp('cu_code').value; var
  1719. * sellercode=Ext.getCmp('pi_emcode').value;
  1720. * prodcode=Ext.getCmp('pd_prodcode').value;
  1721. * reportName="PROFITCUSTOMER_Group";
  1722. * condition=dateValuePrint; if(cop!=""){ condition+=' and
  1723. * '+'{GETALLDATA_VIEW.pi_code}='+"'"+cop+"'"; }
  1724. * if(custcode!=""){ condition+=' and
  1725. * '+'{GETALLDATA_VIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1726. * if(sellercode!=""){ condition+=' and
  1727. * '+'{GETALLDATA_VIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1728. * if(prodcode!=""){ condition+=' and
  1729. * '+'{GETALLDATA_VIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1730. * }else if(cop=="集团毛利润分析表-按产品型号"){ var
  1731. * dateRange=Ext.getCmp('pi_date'); var
  1732. * dateValuePrint=dateRange.valuePrint; var
  1733. * cop=Ext.getCmp('pi_cop').value; var
  1734. * custcode=Ext.getCmp('cu_code').value; var
  1735. * sellercode=Ext.getCmp('pi_emcode').value;
  1736. * prodcode=Ext.getCmp('pd_prodcode').value;
  1737. * reportName="profitproduct_Group";
  1738. * condition=dateValuePrint; if(cop!=""){ condition+=' and
  1739. * '+'{MLR_PRODUCTVIEW.pi_code}='+"'"+cop+"'"; }
  1740. * if(custcode!=""){ condition+=' and
  1741. * '+'{MLR_PRODUCTVIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1742. * if(sellercode!=""){ condition+=' and
  1743. * '+'{MLR_PRODUCTVIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1744. * if(prodcode!=""){ condition+=' and
  1745. * '+'{MLR_PRODUCTVIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1746. * }else if(cop=="集团毛利润分析表-按品牌"){ var
  1747. * dateRange=Ext.getCmp('pi_date'); var
  1748. * dateValuePrint=dateRange.valuePrint; var
  1749. * cop=Ext.getCmp('pi_cop').value; var
  1750. * custcode=Ext.getCmp('cu_code').value; var
  1751. * sellercode=Ext.getCmp('pi_emcode').value;
  1752. * prodcode=Ext.getCmp('pd_prodcode').value;
  1753. * reportName="profitproductkind_Group";
  1754. * condition=dateValuePrint; if(cop!=""){ condition+=' and
  1755. * '+'{MLR_PRODUCTVIEW.pi_code}='+"'"+cop+"'"; }
  1756. * if(custcode!=""){ condition+=' and
  1757. * '+'{MLR_PRODUCTVIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1758. * if(sellercode!=""){ condition+=' and
  1759. * '+'{MLR_PRODUCTVIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1760. * if(prodcode!=""){ condition+=' and
  1761. * '+'{MLR_PRODUCTVIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1762. * }else if(cop=="集团毛利润分析表-按业务员"){ var
  1763. * dateRange=Ext.getCmp('pi_date'); var
  1764. * dateValuePrint=dateRange.valuePrint; var
  1765. * cop=Ext.getCmp('pi_cop').value; var
  1766. * custcode=Ext.getCmp('cu_code').value; var
  1767. * sellercode=Ext.getCmp('pi_emcode').value;
  1768. * prodcode=Ext.getCmp('pd_prodcode').value;
  1769. * reportName="PROFITSELLER_Group";
  1770. * condition=dateValuePrint; if(cop!=""){ condition+=' and
  1771. * '+'{SELLERDATA_VIEW.pi_code}='+"'"+cop+"'"; }
  1772. * if(custcode!=""){ condition+=' and
  1773. * '+'{SELLERDATA_VIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1774. * if(sellercode!=""){ condition+=' and
  1775. * '+'{SELLERDATA_VIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1776. * if(prodcode!=""){ condition+=' and
  1777. * '+'{SELLERDATA_VIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1778. * }else if(cop=="集团未交货销售订单总表"){ var
  1779. * dateRange=Ext.getCmp('pi_date'); var
  1780. * dateValuePrint=dateRange.valuePrint; var
  1781. * cop=Ext.getCmp('pi_cop').value; var
  1782. * custcode=Ext.getCmp('cu_code').value; var
  1783. * sellercode=Ext.getCmp('pi_emcode').value;
  1784. * prodcode=Ext.getCmp('pd_prodcode').value;
  1785. * reportName="sasumc_Group"; condition=dateValuePrint;
  1786. * if(cop!=""){ condition+=' and
  1787. * '+'{SALEINFO_VIEW.pi_code}='+"'"+cop+"'"; }
  1788. * if(custcode!=""){ condition+=' and
  1789. * '+'{SALEINFO_VIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1790. * if(sellercode!=""){ condition+=' and
  1791. * '+'{SALEINFO_VIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1792. * if(prodcode!=""){ condition+=' and
  1793. * '+'{SALEINFO_VIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1794. * }else if(cop=="集团未交货销售订单总表(型号)"){ var
  1795. * dateRange=Ext.getCmp('pi_date'); var
  1796. * dateValuePrint=dateRange.valuePrint; var
  1797. * cop=Ext.getCmp('pi_cop').value; var
  1798. * custcode=Ext.getCmp('cu_code').value; var
  1799. * sellercode=Ext.getCmp('pi_emcode').value;
  1800. * prodcode=Ext.getCmp('pd_prodcode').value;
  1801. * reportName="sasump_Group"; condition=dateValuePrint;
  1802. * if(cop!=""){ condition+=' and
  1803. * '+'{SALEINFO_VIEW.pi_code}='+"'"+cop+"'"; }
  1804. * if(custcode!=""){ condition+=' and
  1805. * '+'{SALEINFO_VIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1806. * if(sellercode!=""){ condition+=' and
  1807. * '+'{SALEINFO_VIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1808. * if(prodcode!=""){ condition+=' and
  1809. * '+'{SALEINFO_VIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1810. * }else if(cop=="集团未交货销售订单总表(业务员)"){ var
  1811. * dateRange=Ext.getCmp('pi_date'); var
  1812. * dateValuePrint=dateRange.valuePrint; var
  1813. * cop=Ext.getCmp('pi_cop').value; var
  1814. * custcode=Ext.getCmp('cu_code').value; var
  1815. * sellercode=Ext.getCmp('pi_emcode').value;
  1816. * prodcode=Ext.getCmp('pd_prodcode').value;
  1817. * reportName="sasums_Group"; condition=dateValuePrint;
  1818. * if(cop!=""){ condition+=' and
  1819. * '+'{SALEINFO_VIEW.pi_code}='+"'"+cop+"'"; }
  1820. * if(custcode!=""){ condition+=' and
  1821. * '+'{SALEINFO_VIEW.pi_cardcode}='+"'"+custcode+"'"; }
  1822. * if(sellercode!=""){ condition+=' and
  1823. * '+'{SALEINFO_VIEW.pi_emcode}='+"'"+sellercode+"'"; }
  1824. * if(prodcode!=""){ condition+=' and
  1825. * '+'{SALEINFO_VIEW.pd_prodcode}='+"'"+prodcode+"'"; }
  1826. * }else if(cop=="应收账龄分析表"){ var
  1827. * dateRange=Ext.getCmp('ab_date'); var
  1828. * dateValuePrint=dateRange.valuePrint; var
  1829. * custcode=Ext.getCmp('cu_code').value; var
  1830. * seller=Ext.getCmp('em_id').value; reportName="ARAgeAll";
  1831. * condition='{ARBill.ab_date}<={@Date0To} AND
  1832. * {ARBill.ab_aramount}<>{ARBill.ab_thispayamount}'+' and
  1833. * '+dateValuePrint; if(custcode!=""){ condition+=' and
  1834. * '+'{ARBill.ab_custcode}='+"'"+custcode+"'"; }
  1835. * if(seller!=""){ condition+=' and
  1836. * '+'{ARBill.ab_sellerid}='+seller; } }else
  1837. * if(cop=="应付账龄分析表"){ var dateRange=Ext.getCmp('ab_date');
  1838. * var dateValuePrint=dateRange.valuePrint;
  1839. * reportName="APAgeAll"; condition='{APBill.ab_paydate}<={@Date0To}
  1840. * AND {APBill.ab_apamount}<>{APBill.ab_payamount}'+' and
  1841. * '+dateValuePrint; console.log(condition); }else
  1842. * if(cop=="应收账明细表"){ var dateRange=Ext.getCmp('asl_date');
  1843. * var dateValuePrint=dateRange.valuePrint; var
  1844. * custcode=Ext.getCmp('cu_code').value;
  1845. * condition=dateValuePrint+' and
  1846. * '+'{ArSubledger.asl_source}<>'+"'预收冲应收'";
  1847. * reportName="ArSubledger"; if(custcode!=""){ condition+='
  1848. * and '+'{ArSubledger.asl_custcode}='+"'"+custcode+"'"; }
  1849. * }else if(cop=="应付账明细表"){ var
  1850. * dateRange=Ext.getCmp('asl_date'); var
  1851. * dateValuePrint=dateRange.valuePrint;
  1852. * reportName="ApSubledger"; var
  1853. * vendcode=Ext.getCmp('ve_code').value;
  1854. * condition=dateValuePrint+' and
  1855. * '+'{ApSubledger.asl_source}<>'+"'预收冲应收'";
  1856. * if(vendcode!=""){ condition+=' and
  1857. * '+'{ApSubledger.asl_vendcode}='+"'"+vendcode+"'"; } }else
  1858. * if(cop=="应收账款汇总表"){ reportName="CustomerAR"; var
  1859. * custcode=Ext.getCmp('cu_code').value; var condition="";
  1860. * if(custcode!=""){
  1861. * condition='{CustAr.ca_custcode}='+"'"+custcode+"'"; }
  1862. * }else if(cop=="应付账款汇总表"){ reportName="VendorAP"; var
  1863. * custcode=Ext.getCmp('ve_code').value; var condition="";
  1864. * if(custcode!=""){
  1865. * condition='{VendAp.va_vendcode}='+"'"+custcode+"'"; } }
  1866. *
  1867. * form.FormUtil.batchPrint(idS,reportName,condition,cop,todate,dateFW,fromdate,enddate);
  1868. */
  1869. }
  1870. }, {
  1871. text : $I18N.common.button.erpCloseButton,
  1872. iconCls : 'x-button-icon-close',
  1873. cls : 'x-btn-gray',
  1874. height : 26,
  1875. handler : function() {
  1876. var main = parent.Ext.getCmp("content-panel");
  1877. main.getActiveTab().close();
  1878. }
  1879. } ],
  1880. initComponent : function() {
  1881. var param = {
  1882. caller : caller,
  1883. condition : ''
  1884. };
  1885. this.FormUtil.getItemsAndButtons(this, 'common/singleFormItems.action', param);
  1886. this.callParent(arguments);
  1887. this.addKeyBoardEvents();
  1888. // this.initFields(this);
  1889. },
  1890. /**
  1891. * 监听一些事件
  1892. * <br>
  1893. * Ctrl+Alt+S 单据配置维护
  1894. * Ctrl+Alt+P 参数、逻辑配置维护
  1895. */
  1896. addKeyBoardEvents: function(){
  1897. var me = this;
  1898. Ext.EventManager.addListener(document.body, 'keydown', function(e){
  1899. if(e.altKey && e.ctrlKey) {
  1900. if(e.keyCode == Ext.EventObject.S) {
  1901. var url = "jsps/ma/form.jsp?formCondition=fo_idIS" + me.fo_id + "&gridCondition=fd_foidIS" + me.fo_id,
  1902. forms = Ext.ComponentQuery.query('form'),
  1903. grids = Ext.ComponentQuery.query('gridpanel'),
  1904. formSet = [], gridSet = [];
  1905. if(forms.length > 0) {
  1906. Ext.Array.each(forms, function(f){
  1907. f.fo_id && (formSet.push(f.fo_id));
  1908. });
  1909. }
  1910. if(grids.length > 0) {
  1911. Ext.Array.each(grids, function(g){
  1912. if(g.xtype.indexOf('erpGridPanel') > -1)
  1913. gridSet.push(window.caller);
  1914. else if(g.caller)
  1915. gridSet.push(g.caller);
  1916. });
  1917. }
  1918. if(formSet.length > 0 || gridSet.length > 0) {
  1919. url = "jsps/ma/multiform.jsp?formParam=" + formSet.join(',') + '&gridParam=' + gridSet.join(',');
  1920. }
  1921. me.FormUtil.onAdd('form' + caller, 'Form配置维护(' + caller + ')', url);
  1922. } else if(e.keyCode == Ext.EventObject.P) {
  1923. me.FormUtil.onAdd('configs-' + caller, '逻辑配置维护(' + caller + ')', "jsps/ma/logic/config.jsp?whoami=" + caller);
  1924. }
  1925. }
  1926. });
  1927. }
  1928. });