![](\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/06\/f0accf80687180f9ac35e1b6a6378000.png\")
<\/p>\n<\/p>\n
\u6210\u672c\u9636\uff1a99\u00a0 \u539f\u6599\u65e0\u5de5\u5355(\u91c7\u8d2d\u6599\u4ef6)\u00a0 ima08=P\/V\/Z<\/p>\n
0-96 \u6210\u54c1\u6216\u534a\u6210\u54c1\u6709\u5de5\u5355\u6709BOM<\/p>\n
<\/p>\n
cca_file \u5e93\u5b58\u6210\u672c\u671f\u521d<\/p>\n
ccb_file \u5e93\u5b58\u6210\u672c\u5f53\u6708\u5165\u5e93\u8c03\u6574\u91d1\u989d<\/p>\n
ccc_file \u00a0\u5e93\u5b58\u6708\u52a0\u6743\u6210\u672c<\/p>\n
ccg_file \u6bcf\u6708\u5de5\u5355\u4e3b\u4ef6\u5728\u5236\u6210\u672c\uff08\u4f9d\u5de5\u5355\u522b\u7684\u5206\u6279\u5728\u5236\u6210\u672c\uff09\u00a0\u00a0 \u5373\u5de5\u5355\u4e0a\u9636\u6210\u672c<\/p>\n
cch_file \u6bcf\u6708\u5de5\u5355\u5143\u4ef6\u5728\u5236\u6210\u672c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5373\u5de5\u5355\u4e0b\u9636\u6210\u672c<\/p>\n
<\/p>\n
cct_file \u62c6\u4ef6\u5355\u5934<\/p>\n
ccu_file \u62c6\u4ef6\u5355\u8eab<\/p>\n
<\/p>\n
\u5148\u8fdb\u5148\u51fa<\/p>\n
Cxa_file<\/p>\n
Cxb_file<\/p>\n
<\/p>\n
\u8ba1\u7b97\u8303\u56f4\uff1a<\/p>\n
\u6709\u4e0b\u5217\u60c5\u51b5\u4e4b\u4e00\u7684\u6599\u4ef6\uff0c\u5747\u7eb3\u5165\u8ba1\u7b97\u8303\u56f4\uff1a<\/p>\n
1 tlf\u6863\u5f53\u671f\u6709\u5f02\u52a8\u7684\u6599\u4ef6 tlf<\/p>\n
2\u5f53\u671f\u6709\u6295\u5165\u5de5\u65f6\u7684\u6599\u4ef6 ccj<\/p>\n
3\u6709\u5de5\u5355\u5907\u6599\u4e14\u6709\u6295\u5165\u5de5\u65f6\u7684\u6599\u4ef6\u00a0 sfa\/sfb\/ccj<\/p>\n
4\u5f53\u671f\u6709\u4e0a\u9636\u5728\u5236\u6210\u672c\u7684\u6599\u4ef6(ccg\u6709\u4f59\u989d)<\/p>\n
5\u5f53\u671f\u6709\u4e0b\u9636\u5728\u5236\u6210\u672c\u7684\u6599\u4ef6\uff08cch\u672a\u4f59\u989d\uff09<\/p>\n
6\u6709\u5e93\u5b58\u671f\u521d\u5f00\u5e10\u7684\u6599\u4ef6cca<\/p>\n
7\u5f53\u671f\u5de5\u5355\u6709\u671f\u521d\u5728\u5236\u5f00\u5e10\u91d1\u989d\u7684\u6599\u4ef6 ccf<\/p>\n
8\u5f53\u671f\u5de5\u5355\u6709\u5728\u5236\u8c03\u6574\u91d1\u989d\u7684\u6599\u4ef6ccl<\/p>\n
9\u5f53\u671f\u5de5\u5355\u6709\u5de5\u5355\u53d1\u9000\u6599\u5f02\u52a8\u7684\u6599\u4ef6sfb\/tlf<\/p>\n
<\/p>\n
select \u6210\u672c\u9636ima57,\u00a0\u6599\u53f7ima01,\u987b\u8ba1\u7b97\u91cd\u5de5\u5426ccd03,\u4f4e\u9636\u7801ima16,\u6765\u6e90\u7801ima08,\u5206\u7fa4\u7801ima06,\u5176\u4ed6\u5206\u7fa4\u7801ima09-11,\u6210\u672c\u5206\u7fa4\u7801ima12,<\/p>\n
where ima\u6599\u53f7=tlf \u6599\u53f7 and\u00a0\u00a0 tlf\u5f02\u52a8\u65e5\u671f\u4e3a\u5f53\u524d\u671f\u95f4 and\u00a0 tlf902\u4ed3\u5e93\u4e0d\u4e3aJIT\u4ed3\u5e93 and \u4ed3\u5e93\u4e0d\u4e3a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##tlf\u6863\u5f53\u671f\u6709\u5f02\u52a8\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where ima\u6599\u53f7=\u5de5\u5355\u6863sfb\u6599\u53f7 and \u6295\u5165\u5de5\u65f6ccj01\u5728\u5f53\u671f\u671f\u95f4 and ccj04\u5de5\u5355\u53f7=\u5de5\u5355\u6863\u5de5\u5355\u53f7sfb01\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0##\u5f53\u671f\u6709\u6295\u5165\u5de5\u65f6\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where ima\u6599\u53f7=\u5907\u6599\u6863\u6599\u53f7sfa03 and \u6295\u5165\u5de5\u65f6ccj01\u5728\u5f53\u671f\u671f\u95f4 and ccj04\u5de5\u5355\u53f7=\u5de5\u5355\u6863\u5de5\u5355\u53f7sfb01 and sfa\u5907\u6599\u6863\u6599\u53f7=sfb\u5de5\u5355\u6863\u6599\u53f7\u00a0 ##\u6709\u5de5\u5355\u5907\u6599\u4e14\u6709\u6295\u5165\u5de5\u65f6\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where ima\u6599\u53f7=\u5728\u5236\u6210\u672c\u6863\u6599\u53f7ccg and \u5728\u5236\u6210\u672c\u4e3a\u5f53\u671f and ccg91\/92\u5f53\u671f\u5728\u5236\u6210\u672c\u6570\u91cf\u6216\u5355\u4ef7\u4e0d\u4e3a\u96f6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##\u5f53\u671f\u6709\u4e0a\u9636\u5728\u5236\u6210\u672c\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where ima\u6599\u53f7=\u5728\u5236\u6210\u672c\u5143\u4ef6\u6863cch\u6599\u53f7 and \u5728\u5236\u6210\u672c\u4e3a\u5f53\u671f and cch91\/92\u5f53\u671f\u5728\u5236\u6210\u672c\u6570\u91cf\u6216\u5355\u4ef7\u4e0d\u4e3a\u96f6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##\u5f53\u671f\u6709\u4e0b\u9636\u5728\u5236\u6210\u672c\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where ima\u6599\u53f7=\u5e93\u5b58\u671f\u521d\u5f00\u5e10\u6599\u53f7cca\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##\u6709\u5e93\u5b58\u671f\u521d\u5f00\u5e10\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where ccf \u671f\u521d\u5728\u5236\u5f00\u5e10\u91d1\u989d\u6863\u6599\u53f7=\u5de5\u5355\u6863\u6599\u53f7sfb and ima\u6599\u53f7=sfb\u5de5\u5355\u6599\u53f7 and \u671f\u521d\u5728\u5236\u5f00\u5e10\u91d1\u989d\u4e0d\u4e3a\u96f6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##\u5f53\u671f\u5de5\u5355\u6709\u671f\u521d\u5728\u5236\u5f00\u5e10\u91d1\u989d\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where ccl\u5f53\u671f\u5728\u5236\u8c03\u6574\u91d1\u989d\u6599\u53f7=\u5de5\u5355\u6599\u53f7ima and ima \u6599\u53f7=\u5de5\u5355\u6599\u53f7sfb<\/p>\n
##\u5f53\u671f\u5de5\u5355\u6709\u5728\u5236\u8c03\u6574\u91d1\u989d\u7684\u6599\u4ef6<\/p>\n
UNION<\/p>\n
Where (\u672a\u7ed3\u6848\u5de5\u5355sfb38 is null or\u7ed3\u6848\u65e5\u5728\u5f53\u524d\u671f\u95f4\u5185) and ima\u6599\u53f7=\u5de5\u5355\u6599\u53f7sfb05 and tlf\u5355\u636e\u65e5\u671f\u5728\u5f53\u524d\u671f\u95f4\u5185 and \u00a0tlf\u5de5\u5355\u5355\u53f7=sfb\u5de5\u5355\u5355\u53f7 and tlf13\u5f02\u52a8\u547d\u4ee4\u4ee3\u53f7\u4e3a\u201casfi5*\u201d\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##\u5f53\u671f\u5de5\u5355\u6709\u5de5\u5355\u53d1\u9000\u6599\u5f02\u52a8\u7684\u6599\u4ef6<\/p>\n
\u4f8b\u5982\uff1a<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file,tlf_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ima01 = tlf01 AND tlf06 BETWEEN ’00\/01\/01′ AND ’00\/01\/31′<\/p>\n
AND tlf902 NOT IN (SELECT jce02 FROM jce_file)\u00a0\u00a0 AND tlf907 != 0<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file, ccj_file,sfb_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ima01 = sfb05 AND ccj01 BETWEEN ’00\/01\/01′ AND ’00\/01\/31′<\/p>\n
AND ccj04 = sfb01<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file, ccj_file,sfb_file,sfa_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ima01 = sfa03 AND ccj01 BETWEEN ’00\/01\/01′ AND ’00\/01\/31′<\/p>\n
AND ccj04 = sfb01\u00a0 AND sfb01 = sfa01<\/p>\n
GROUP BY 1,2,3,4,5,6,7, 8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file, ccg_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ima01 = ccg04 \u00a0AND ccg02= 1999 AND ccg03= 12<\/p>\n
AND (ccg91 !=0 OR ccg92 !=0 OR ccg92a !=0 OR ccg92b !=0<\/p>\n
OR ccg92c!=0 OR ccg92d !=0 OR ccg92e !=0 )<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file,cch_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ima01 = cch04 AND cch02=1999 AND cch03=12<\/p>\n
AND (cch91!=0 OR cch92 !=0 OR cch92a!=0 OR cch92b !=0 OR cch92c!=0<\/p>\n
OR cch92d !=0 OR cch92e !=0 )<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file,cca_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ima01=cca01 AND cca02= 1999 AND cca03= 12<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file,ccf_file,sfb_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ccf01=sfb01 AND ima01 = sfb05 AND ccf02=1999 AND ccf03=12<\/p>\n
AND (ccf11 !=0 OR ccf12!=0 OR ccf12a !=0 OR ccf12b !=0 OR ccf12c !=0<\/p>\n
OR\u00a0 ccf12d !=0 OR ccf12e !=0 )<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file,ccl_file,sfb_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND ccl01 = sfb01 AND ima01 = sfb05 AND ccl02= 2000 AND ccl03= 1<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
UNION<\/p>\n
SELECT ima57,ima01,ccd03,ima16,ima08,ima06,ima09,ima10,ima11,ima12<\/p>\n
FROM ima_file,tlf_file,sfb_file,OUTER ccd_file<\/p>\n
WHERE ima57=ccd01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n
AND (sfb38 BETWEEN ’00\/01\/01′ AND ’00\/01\/31′ OR sfb38 IS NULL )<\/p>\n
AND ima01 = sfb05 AND tlf06 BETWEEN ’00\/01\/01′ AND ’00\/01\/31′<\/p>\n
AND tlf62 = sfb01\u00a0\u00a0 and tlf13[1,5] = ‘asfi5’<\/p>\n
GROUP BY 1,2,3,4,5,6,7,8,9,10<\/p>\n
INTO TEMP tlf_temp WITH NO LOG<\/p>\n
<\/p>\n
\u8ba1\u7b97\u8fc7\u7a0b\uff1a<\/p>\n
\u6392\u5e8f\u65b9\u5f0f\uff1aUNIQUE ima57,ima01,ccd03,ima16\u00a0\u00a0 ima57 desc\/ima16\/ima01<\/p>\n
\u6210\u672c\u9636\u4e3a99 \uff1a1\u3001ccc\u6e05\u96f6\uff0c\u53d6\u4e0a\u671f\u7ed3\u5b58\u8f6c\u672c\u671f\u671f\u521d<\/p>\n
2\u3001\u7531tlf \u8ba1\u7b97\u5165\u51fa\u5e93\u6570\u91cf\uff0c\u7531apb101\u8ba1\u7b97\u5165\u5e93\uff08\u91c7\u8d2d\uff09\u6210\u672c<\/p>\n
3\u3001\u52a0\u4e0a\u5165\u5e93\u8c03\u6574\u91d1\u989d<\/p>\n
4\u3001\u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58<\/p>\n
5\u3001\u66f4\u65b0ccc-file<\/p>\n
\u6210\u672c\u9636\u4e0d\u4e3a99\uff1a1\u3001\u5904\u7406\u5f53\u524d\u6210\u672c\u9636\u6240\u6709\u6599\u4ef6\u91cd\u5de5<\/p>\n
2\u3001ccc\u6e05\u96f6\uff0c\u53d6\u4e0a\u671f\u7ed3\u5b58\u8f6c\u672c\u671f\u671f\u521d<\/p>\n
3\u3001\u5904\u7406<\/strong>WIP<\/strong>\u5728\u5236\u6210\u672c<\/strong><\/p>\n 4\u3001\u7531tlf \u8ba1\u7b97\u5165\u51fa\u5e93\u6570\u91cf\uff0c\u5165\u5e93\u6210\u672c(\u5916\u8d2d\u6599\u4ef6)<\/p>\n 5\u3001\u52a0\u4e0a\u5165\u5e93\u8c03\u6574\u91d1\u989d<\/p>\n 6\u3001\u52a0\u4e0a<\/strong>WIP<\/strong>\u5165\u5e93\u91d1\u989d<\/strong><\/p>\n 7\u3001\u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58<\/p>\n 8\u3001\u66f4\u65b0ccc-file<\/p>\n \u5904\u7406\u91cd\u5de5<\/p>\n <\/p>\n <\/p>\n \u91cd\u5de5\u5904\u7406\u8fc7\u7a0b\uff1a<\/p>\n \u4ee5\u5f53\u524d\u6210\u672c\u9636\u7684\u6240\u6709\u6599\u4ef6\u4e3a\u8ba1\u7b97\u8303\u56f4\uff0c<\/p>\n 1\u3001p500_rework1\u5148\u5904\u7406\u91cd\u5de5WIP\u53ca\u5b8c\u6210\u54c1\u5165\u5e93\uff0c<\/p>\n p500_wip_rework\u5904\u7406\u91cd\u5de5\u5728\u5236\u6210\u672c\uff08\u4ee5\u91cd\u5de5\u5de5\u5355sfb99=Y\u4e3a\u8303\u56f4\uff09\uff0c\u6b65\u9aa4\u4e0e\u5904\u7406\u4e00\u822c\u5728\u5236\u76f8\u540c\uff1awip_1\u8ba1\u7b97\u4e3b\u4ef6\u90e8\u5206\u6210\u672c\uff1bwip_2\u8ba1\u7b97\u5143\u4ef6\u6295\u5165\u6210\u672c\uff1bwip_3\u8ba1\u7b97\u5143\u4ef6\u8f6c\u51fa\u6210\u672c\uff1bwip_4\u5904\u7406\u4e3b\u4ef6SUM\u6210\u672c\u3002<\/p>\n 2\u3001p500_rework2\u8ba1\u7b97\u6240\u6709\u91cd\u5de5\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58\uff0c<\/p>\n p500_ccg2_cost\u52a0\u4e0aWIP\u91cd\u5de5\u5165\u5e93\u6210\u672c\uff08ccg32\u5728\u5236\u8f6c\u51fa\u91d1\u989d\u00e0ccc28\uff09\uff1b<\/p>\n p500_ccc_tot(2) \u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58\uff1b<\/p>\n 3\u3001\u8bb0\u5f55\u62c6\u4ef6\u5f0f\u5de5\u5355\u7684\u6295\u5165\u53ca\u8f6c\u51fa\u00a0\uff08sfb02=11\uff09<\/p>\n \u627e\u6240\u6709\u62c6\u4ef6\u5f0f\u5de5\u5355\uff1b<\/p>\n wipx_1\u8ba1\u7b97\u62c6\u4ef6\u5f0fWIP\u4e3b\u4ef6\u90e8\u5206\u6210\u672c\uff1b<\/p>\n wipx_2\u8ba1\u7b97\u62c6\u4ef6\u5f0fWIP\u5143\u4ef6\u6295\u5165\u6210\u672c\uff1b<\/p>\n wipx_3\u8ba1\u7b97\u62c6\u4ef6\u5f0fWIP\u5143\u4ef6\u8f6c\u51fa\u6210\u672c\uff1b<\/p>\n wipx_4\u8ba1\u7b97\u62c6\u4ef6\u5f0fWIP\u4e3b\u4ef6SUM\u6210\u672c\uff1b<\/p>\n p500_ccc_tot(2)\u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58\uff1b<\/p>\n <\/p>\n <\/p>\n MAIN<\/p>\n \u5220\u9664\u672c\u671f\u5df2\u6709\u8d44\u6599\uff0c\u53d6\u4e0a\u671f\u7ed3\u5b58\u8f6c\u672c\u671f\u671f\u521dp500_last0<\/p>\n \u627e\u8ba1\u7b97\u8303\u56f4\uff08\u53d6\u672c\u671f\u6709\u5f02\u52a8\u4e4b\u8d44\u6599\u8ba1\u7b97tlf\uff09<\/p>\n \u6293\u8d44\u6599\u5230\u00a0\u00a0 tlf_tmp<\/p>\n fetch \u6210\u672c\u9636\/\u6599\u53f7\/\u91cd\u5de5\u5426\/\u4f4e\u9636\u7801\u00a0 \uff08\u6309\u6210\u672c\u9636\u964d\u5e8f\u6392\u5217\uff09 \u6765\u8ba1\u7b97<\/p>\n FOR EACH<\/p>\n IF \u5f53\u524d\u6599\u4ef6\u6210\u672c\u9636\u4e0d\u540c<\/p>\n PUSH \u6599\u53f7<\/p>\n P500_rework \u91cd\u5de5\u5904\u7406\u00a0 (\u672c\u6210\u672c\u9636\u6240\u6709\u6599\u4ef6)<\/p>\n POP \u6599\u53f7<\/p>\n END IF<\/p>\n \u4fdd\u5b58\u5f53\u524d\u6599\u4ef6\u6599\u53f7g_ima01_t<\/p>\n \u5c06\u5f53\u524d\u6599\u4ef6\u5f53\u671f\u6210\u672c\u6863\u5f52\u96f6 ccc_file\u00a0 p500_ccc_0<\/p>\n \u53d6\u6599\u4ef6\u4e0a\u671f\u7ed3\u5b58p500_last<\/p>\n IF \u5f53\u524d\u6599\u4ef6\u4e0d\u662f\u539f\u6599\uff08\u6210\u672c\u9636\u6570\u4e0d\u4e3a99\uff09<\/p>\n \u5904\u7406WIP\u5728\u5236\u6210\u672c\u00a0 p500_wip<\/p>\n END IF<\/p>\n \u7531tlf_file \u8ba1\u7b97\u5165\u51fa\u5e93\u6570\u91cf\u53ca\u91c7\u8d2d\u6210\u672c\u00a0 p500_tlf<\/p>\n \u52a0\u5165\u51fa\u5e93\u8c03\u6574\u91d1\u989d p500_ccb_cost<\/p>\n IF \u5f53\u524d\u6599\u4ef6\u4e0d\u662f\u539f\u6599\uff08\u6210\u672c\u9636\u6570\u4e0d\u4e3a99\uff09<\/p>\n \u52a0\u4e0aWIP\u5165\u5e93\u91d1\u989d\u00a0 p500_ccg_cost<\/p>\n END IF<\/p>\n \u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58 p500_ccc_tot(1)<\/p>\n \u8ba1\u7b97\u7ed3\u679c\u5199\u5165\u5f53\u671f\u6210\u672c\u6863p500_ccc_ins<\/p>\n END FOREACH<\/p>\n IF \u4e0a\u4e00\u6599\u53f7\u4e3aNULL \u5219 \u4e0a\u4e00\u6599\u53f7\u7f6e\u96f6<\/p>\n IF \u4e0a\u4e00\u6210\u672c\u9636\u4e3aNULL \u5219\u4e0a\u4e00\u6210\u672c\u9636\u7f6e\u96f6<\/p>\n \u7b2c\u4e8c\u6b21\u5904\u7406\u91cd\u5de5p500_rework<\/p>\n END MAIN<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n P500_last0()<\/p>\n Delete \u672c\u671f\u6210\u672c\u8d44\u6599<\/p>\n DELETE FROM ccc_file WHERE ccc02=\u00a0 2000 AND ccc03= 1 AND ccc01 IN(SELECT ima01 FROM ima_file WHERE ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’)<\/p>\n \u53d6\u4e0a\u671f\u53ca\u5f00\u5e10\u6210\u672c<\/p>\n SELECT ima01 FROM ccc_file,ima_file WHERE ccc02=1999 AND ccc03=12 AND ccc01=ima01 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n UNION SELECT ima01 FROM cca_file,ima_file WHERE cca02=\u00a0 1999 AND cca03= 12 AND cca01=ima01\u00a0 AND ima01 matches ‘*’ AND ima01 NOT MATCHES ‘MISC*’<\/p>\n CALL p500_ccc_0() \u6e05\u96f6<\/p>\n SELECT * INTO g_ccc.* FROM ccc_file WHERE ccc01 = l_ima01 AND ccc02=last_yy AND ccc03=last_mm\u00a0\u00a0\u00a0\u00a0\u00a0 \u5148\u53d6\u4e0a\u6708\u7ed3\u5b58<\/p>\n SELECT * INTO l_cca.* FROM cca_file WHERE cca01=g_ccc.ccc01 AND cca02=last_yy AND cca03=last_mm\u00a0 \u518d\u53d6\u671f\u521d\u5f00\u5e10<\/p>\n <\/p>\n <\/p>\n <\/p>\n P500_rework()<\/p>\n \u53d6\u5f53\u524d\u6599\u4ef6\u6210\u672c\u9636\u7684ccd03 \uff08\u987b\u8ba1\u7b97\u91cd\u5de5\u5426\uff09<\/p>\n IF\u987b\u91cd\u5de5<\/p>\n \u5148\u8ba1\u7b97WIP\u53ca\u5b8c\u6210\u54c1\u5165\u5e93p500_rework1<\/p>\n \u518d\u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58p500\u00ad_rework2<\/p>\n \u8bb0\u5f55WIP-\u62c6\u4ef6\u5f0f\u5de5\u5355\u5728\u5236\u6210\u672c\uff08\u5de5\u5355\u6027\u8d28\u4e3a11\uff09\u76ee\u7684\u4e3a\u53d6\u91cd\u5de5\u540e\u5355\u4ef7 p500_wipx0<\/p>\n END IF<\/p>\n END p500_rework2<\/p>\n <\/p>\n <\/p>\n P500_rework1()<\/p>\n \u5728\u987b\u8ba1\u7b97\u7684\u8d44\u6599\u4e2d\u6293\u5f53\u524d\u6599\u4ef6\u5f02\u52a8\u8d44\u6599 tlf_tmp<\/p>\n FOREACH \u6599\u4ef6<\/p>\n \u4ececcc_file \u4e2d\u6293\u5f53\u671f\u8d44\u6599\uff0c\u5426\u5219\u7f6e\u96f6<\/p>\n \u5904\u7406WIP\u91cd\u5de5\u6210\u672c\uff08\u91cd\u5de5\u00a0sfb99=y —\u5de5\u5355\u6863sfb_file \u91cd\u5de5\u5426\uff09 p500_wip_rework<\/p>\n end foreach<\/p>\n end p500_rework1<\/p>\n <\/p>\n p500_rework2()<\/p>\n <\/p>\n \u5728\u987b\u8ba1\u7b97\u7684\u8d44\u6599\u4e2d\u6293\u5f53\u524d\u6210\u672c\u9636\u6240\u6709\u6599\u4ef6\u5f02\u52a8\u8d44\u6599 tlf_tmp<\/p>\n FOREACH \u6599\u4ef6<\/p>\n \u4ececcc_file \u4e2d\u6293\u5f53\u671f\u8d44\u6599\uff0c\u5426\u5219\u7f6e\u96f6<\/p>\n \u52a0\u4e0aWIP\u91cd\u5de5\u5165\u5e93\u91d1\u989dp500_ccg2_cost<\/p>\n \u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58 p500_ccc_tot(2)<\/p>\n \u66f4\u65b0ccc_file p500_ccc_upd<\/p>\n end<\/p>\n end<\/p>\n <\/p>\n <\/p>\n p500_wipx0()<\/p>\n \u5728\u987b\u8ba1\u7b97\u7684\u8d44\u6599\u4e2d\u6293\u5f53\u524d\u6599\u4ef6\u5f02\u52a8\u8d44\u6599 tlf_tmp<\/p>\n FOREACH \u6599\u4ef6<\/p>\n \u4ececcc_file \u4e2d\u6293\u5f53\u671f\u8d44\u6599\uff0c\u5426\u5219\u7f6e\u96f6<\/p>\n p500_wipx<\/p>\n end<\/p>\n end<\/p>\n <\/p>\n <\/p>\n p500_last0()<\/p>\n \u53d6\u4e0a\u671f\u7ed3\u5b58\u8f6c\u672c\u6708\u671f\u521d<\/p>\n <\/p>\n p500_tlf<\/p>\n \u5bf9\u67d0\u4e00\u6599\u4ef6\u7531tlf\u6863\u5206\u7c7b\u7edf\u8ba1\u5165\u51fa\u5e93\u6570\u91cf<\/p>\n \u5e76\u5206\u522b\u53d6\u5165\u5e93\u6210\u672c\uff0c\u51fa\u5e93\u6210\u672c\u6682\u672a\u5904\u7406<\/p>\n \uff08\u00a0\u7531tlf \u53d6\u5f02\u52a8\u5355\u7c7b\u578bXXX\/\u5355\u53f7XXX1\/\u9879\u6b21XXX2\uff09<\/p>\n <\/p>\n WHEN tlf13[1,4]=’axmt’ OR tlf13 = ‘aomt800′\u00a0 \u9500\u8d27\u9886\u51fa<\/p>\n LET g_ccc.ccc61=g_ccc.ccc61+q_tlf.tlf10*u_sign<\/p>\n CALL p500_ccc63_cost(u_sign)<\/p>\n IF u_sign = 1 THEN<\/p>\n LET g_ccc.ccc64=g_ccc.ccc64+q_tlf.tlf10*u_sign<\/p>\n END IF<\/p>\n <\/p>\n WHEN q_tlf.tlf13=’aimt301′ OR q_tlf.tlf13=’aimt311’<\/p>\n ##\u62a5\u5e9f\u5f02\u52a8(aimt303,aimt313)\u5e94\u5217\u5165\u6742\u9879\u5f02\u52a8\u4e2d<\/p>\n OR q_tlf.tlf13 = ‘aimt303′ OR q_tlf.tlf13 =’aimt313′<\/p>\n LET g_ccc.ccc41=g_ccc.ccc41+q_tlf.tlf10*u_sign<\/p>\n <\/p>\n WHEN q_tlf.tlf13[1,5]=’asfi5′\u00a0\u00a0 #\ue61b\u5de5\u5355\u53d1\u6599<\/p>\n IF g_sfb99=’Y’ THEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #\u91cd\u5de5\u9886\u51fa<\/p>\n LET g_ccc.ccc25=g_ccc.ccc25+q_tlf.tlf10*u_sign<\/p>\n ELSE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #\u4e00\u822c\u5de5\u5355\u9886\u51fa<\/p>\n LET g_ccc.ccc31=g_ccc.ccc31+q_tlf.tlf10*u_sign<\/p>\n END IF<\/p>\n <\/p>\n WHEN q_tlf.tlf13[1,5]=’asft6′\u00a0\u00a0 #\u5de5\u5355\u5165\u5e93<\/p>\n IF q_tlf.tlf02 = 65 OR q_tlf.tlf03 = 65 THEN #\u62c6\u4ef6\u5de5\u5355\uff08\u6210\u672c\u7531WIP\u5904\u7406\uff09<\/p>\n LET g_ccc.ccc31=g_ccc.ccc31+q_tlf.tlf10*u_sign<\/p>\n ELSE<\/p>\n IF g_sfb99=’Y’ THEN\u00a0\u00a0\u00a0\u00a0 #\u91cd\u5de5\u5165\u5e93\uff08\u6210\u672c\u7531\u91cd\u5de5WIP\u8f6c\u51fa\uff09<\/p>\n LET g_ccc.ccc27=g_ccc.ccc27+q_tlf.tlf10*u_sign<\/p>\n ELSE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #\u4e00\u822c\u5165\u5e93<\/p>\n LET g_ccc.ccc21=g_ccc.ccc21+q_tlf.tlf10*u_sign<\/p>\n CALL p500_ccc22_cost()\u00a0\u00a0 #\u53d6\u6210\u672c<\/p>\n END IF<\/p>\n END IF<\/p>\n <\/p>\n WHEN q_tlf.tlf13 = ‘aimt302’ OR q_tlf.tlf13 = ‘aimt312′<\/p>\n LET g_ccc.ccc21=g_ccc.ccc21+q_tlf.tlf10<\/p>\n LET g_ccc.ccc43=g_ccc.ccc43+q_tlf.tlf10<\/p>\n CALL p500_ccc22_cost()<\/p>\n U_flag\u4e3a\u5165\u51fa\u5e93\u6807\u5fd7<\/p>\n WHEN u_flag=’1′\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #\u4e00\u822c\u5de5\u5355\u5165\u5e93\u3001\u91c7\u8d2d\u5165\u3001\u4ed3\u9000<\/p>\n LET g_ccc.ccc21=g_ccc.ccc21+q_tlf.tlf10*u_sign<\/p>\n CALL p500_ccc22_cost()\u00a0\u00a0 #\u53d6\u5165\u5e93\u6210\u672c<\/p>\n WHEN u_flag=’5′\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #\u8c03\u6574<\/p>\n LET g_ccc.ccc51=g_ccc.ccc51+q_tlf.tlf10*u_sign<\/p>\n WHEN u_flag=’6’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #\u76d8\u5dee<\/p>\n LET g_ccc.ccc71=g_ccc.ccc71+q_tlf.tlf10*u_sign<\/p>\n OTHERWISE CONTINUE FOREACH<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n p500_ccc22_cost()<\/p>\n \u53d6\u5165\u5e93\u6210\u672c<\/p>\n <\/p>\n \u5de5\u5355\u5165\u5e93\u6210\u672c\u6682\u4e0d\u5904\u7406 (tlf13 MATCHES ‘asf*’)<\/p>\n \u5de5\u5355\u5165\u5e93\u6210\u672c\u5e94\u7531WIP\u8f6c\u5165\uff0c\u6545\u52a0\u5de5\u8d39\u4e8ewip_2_22()\u5f52\u5165\u6295\u5165\u6210\u672c\uff0c\u518d\u8f6c\u5165\u5e93<\/p>\n <\/p>\n \u5982\u4e3a\u59d4\u5916\u9000\u5e93\u6682\u4e0d\u5904\u7406<\/p>\n IF q_tlf.tlf13 matches ‘apmt107*’ THEN<\/p>\n LET l_pmm02=NULL<\/p>\n SELECT pmm02 INTO l_pmm02 FROM pmm_file WHERE pmm01=q_tlf.tlf036<\/p>\n AND pmm18 <> ‘X’<\/p>\n IF l_pmm02=’SUB’ THEN RETURN END IF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #–>\u59d4\u5916\u9000\u5e93\u4ea6\u7531WIP\u8f6c\u51fa\ue65e<\/p>\n END IF<\/p>\n WHEN q_tlf.tlf13 MATCHES ‘aimt30*’\u00a0\u00a0 #\u6742\u9879\u5165zzz<\/p>\n CALL p500_ccc44_cost()<\/p>\n LET amt=l_ccc23 * q_tlf.tlf10 * u_sign<\/p>\n WHEN q_tlf.tlf13 = ‘aimt720’ OR\u00a0\u00a0 #\u8c03\u62e8\u5165zzz<\/p>\n q_tlf.tlf13 = ‘aimp700’ OR q_tlf.tlf13 = ‘aimp701′<\/p>\n LET amt\u00a0 = g_ccc.ccc23 * q_tlf.tlf10\u00a0 #\u76f4\u63a5\u53d6\u4e0a\u6708\u5e73\u5747\u5355\u4ef7<\/p>\n OTHERWISE\u00a0\u00a0\u00a0\u00a0\u00a0 #\u53d6\u53d1\u53d1\u7968\u8bf7\u6b3e\u7acb\u5e10\u91d1\u989d<\/p>\n SELECT apa44,SUM(apb101) #\u5e10\u6b3e\u5355\u8eab\u6210\u672c\u5206\u644a\u672c\u5e01\u91d1\u989d<\/p>\n \u4e3a\u4e86\u914d\u5408\u6210\u672c\u5206\u644a\u4f5c\u4e1aaapt900 \u6545\u6539apb10\u4e3a\u53d6apb101<\/p>\n FROM apb_file,apa_file<\/p>\n WHERE apb21=xxx1 AND apb22=xxx2 \u00a0\u00a0##xxx1\u4e3atlf\u5355\u636e\u53f7\uff0cxxx2\u4e3a\u9879\u6b21<\/p>\n AND apb01=apa01 AND apa00 = ’11’ \u00a0\u00a0#\u5e10\u6b3e\u6027\u8d28\u4e3a\u8fdb\u8d27\u53d1\u7968<\/p>\n AND apa75 != ‘Y’ AND apa42 = ‘N’\u00a0\u00a0\u00a0 #\u975e\u5916\u8d2d\u8d44\u6599\u4e14\u672a\u4f5c\u5e9f\u5e10\u6b3e<\/p>\n AND apa02 BETWEEN g_bdate AND g_edate<\/p>\n GROUP BY 1<\/p>\n \u95ee\u9898\uff1a\u4e3a\u4f55\u4e0d\u5224\u65ad\u786e\u8ba4\u5426\uff1f\uff1f\uff1fapa41=Y<\/p>\n SELECT apa44,SUM(apb101)\u00a0\u00a0 #\u00a0\u6263\u9664\u6298\u8ba9\u90e8\u5206\uff08\u9000\u8d27\uff09<\/p>\n FROM apb_file,apa_file<\/p>\n WHERE apb21=xxx1 AND apb22=xxx2 AND apb01=apa01<\/p>\n AND apa00 = ’21’ AND apa58 = ‘2’ AND apa75 != ‘Y’ #\u5e10\u6b3e\u4e3a\u9000\u8d27\u6298\u8ba9<\/p>\n AND apa42 = ‘N’<\/p>\n AND apa02 BETWEEN g_bdate AND g_edate<\/p>\n GROUP BY 1<\/p>\n \u91d1\u989d\u53d6\u7edd\u5bf9\u503c<\/p>\n \u82e5\u4e3a\u5916\u8d2d\u4fe1\u7528\u72b6\u5165\u5e93\u5219\u53d6\u5230\u8d27\u5206\u644a\u540e\u91d1\u989d\u00a0sum(ale09)<\/p>\n SELECT alk72,SUM(ale09)<\/p>\n FROM ale_file ,alk_file<\/p>\n WHERE ale16=xxx1 AND ale17=xxx2 AND ale01=alk01<\/p>\n GROUP BY 1<\/p>\n \u66f4\u65b0tlf \u6863\uff0c\u5176\u4e2d\u6742\u6536\u4e0d\u66f4\u65b0\uff0c\u7531axct500\u786e\u5b9a<\/p>\n IF q_tlf.tlf13 != ‘aimt302’ and q_tlf.tlf13 != ‘aimt312′ THEN<\/p>\n UPDATE tlf_file SET (tlf21,tlf221,tlf222,tlf2231,tlf2232,tlf224,<\/p>\n tlf211,tlf212,tlf65)<\/p>\n =(amt,amta,amtb,amtc,amtd,amte,TODAY,g_time,l_apa44)<\/p>\n WHERE ROWID=q_tlf_rowed<\/p>\n <\/p>\n <\/p>\n <\/p>\n p500_ccc44_cost()<\/p>\n \u53d6\u6742\u9879\u5165\u5e93\u6210\u672c<\/p>\n \u5148\u53d6\u672c\u6708\u6742\u9879\u5165\u5e93\u91d1\u989d\u6863inb_file \uff08\u624b\u5de5\u7ef4\u62a4\uff09<\/p>\n \u5982\u65e0\u5355\u4ef7\u5219\u53d6\u671f\u521d\u5f00\u5e10\u91d1\u989d cca_file<\/p>\n \u4ecd\u65e0\u5355\u4ef7\u5219\u53d6\u4e0a\u6708\u5e73\u5747ccc_file ccc23<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n p500_ccc63_cost()<\/p>\n \u672c\u6708\u9500\u8d27\u6536\u5165<\/p>\n <\/p>\n <\/p>\n p500_ccb_cost()<\/p>\n \u52a0\u5165\u5e93\u5e93\u8c03\u6574\u91d1\u989d<\/p>\n <\/p>\n <\/p>\n p500_ccg_cost()<\/p>\n \u52a0\u4e0aWIP\u5165\u5e93\u91d1\u989d\uff08\u5de5\u5355\u4e3b\u4ef6\u5728\u5236\u6210\u672c\uff09<\/p>\n \u975e\u91cd\u5de5\u7684\u3001\u975e\u9884\u6d4b\u5de5\u5355\u3001\u975e\u62c6\u4ef6\u5f0f\u5de5\u5355\u7684\u5de5\u5355\u4e3b\u4ef6\u5728\u5236\u6210\u672c<\/p>\n <\/p>\n <\/p>\n p500_ccg2_cost()<\/p>\n \u52a0\u4e0aWIP\u91cd\u5de5\u5165\u5e93\u91d1\u989d<\/p>\n \u91cd\u5de5\u7684\u3001\u975e\u9884\u6d4b\u5de5\u5355\u3001\u975e\u62c6\u4ef6\u5f0f\u5de5\u5355\u7684\u5de5\u5355\u4e3b\u4ef6\u5728\u5236\u6210\u672c<\/p>\n <\/p>\n <\/p>\n <\/p>\n p500_ccc_tot(1 or 2)<\/p>\n \u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58<\/p>\n 1\u00e0\u7b2c\u4e00\u9636\u6bb5\uff0c\u5148\u4e0d\u5904\u7406\u91cd\u5de5<\/p>\n 2\u00e0\u7b2c\u4e8c\u9636\u6bb5\uff0c\u5904\u7406\u91cd\u5de5<\/p>\n if 2 \u5219\u5904\u7406\u91cd\u5de5 p500_ccc_ccc26\u00a0\u00a0\u00a0\u00a0 ccc26\u91cd\u5de5\u9886\u51fa\u91d1\u989d<\/p>\n p500_ccc_ccc23\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ccc23\u672c\u6708\u5e73\u5747\u5355\u4ef7<\/p>\n IF \u00a0\u7b2c\u4e00\u9636\u6bb5\u4e14\u5f53\u524d\u6210\u672c\u9636\u4e0d\u987b\u8ba1\u7b97\u91cd\u5de5 \u6216 \u7b2c\u4e8c\u9636\u6bb5<\/p>\n LET \u672c\u6708\u5de5\u5355\u9886\u7528\u6210\u672c=0\u00a0\u00a0\u00a0 g_ccc_ccc32<\/p>\n LET \u672c\u6708\u6742\u9879\u9886\u7528\u6210\u672c=0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42<\/p>\n LET \u672c\u6708\u5176\u4ed6\u9886\u7528\u6210\u672c=0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a052<\/p>\n LET \u672c\u6708\u9500\u8d27\u6210\u672c=0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 62\/62a\/62b\/62c\/62d\/62e<\/p>\n LET \u672c\u6708\u76d8\u76c8\u4e8f\u91d1\u989d=0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 72<\/p>\n LET \u672c\u6708\u9500\u9000\u6210\u672c=0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 66\/66a-e<\/p>\n P500_tlf21_upd<\/p>\n END IF<\/p>\n LET \u672c\u6708\u7ed3\u5b58\u6570\u91cfccc91=\u4e0a\u6708\u7ed3\u5b58\u6570\u91cfccc11+\u672c\u6708\u5165\u5e93\u6570\u91cfccc21\uff08\u91c7\u8d2d\u5165+\u5de5\u5355\u5165+\u59d4\u5916\u5165\uff09+\u672c\u6708\u91cd\u5de5\u9886\u51faccc25+\u672c\u6708\u91cd\u5de5\u5165\u5e93\u6570\u91cfccc27+\u672c\u6708\u5de5\u5355\u9886\u7528\u6570\u91cfccc31+\u672c\u6708\u6742\u9879\u9886\u7528\u6570\u91cfccc41+\u672c\u6708\u5176\u4ed6\u8c03\u6574\u6570\u91cfccc51+\u672c\u6708\u9500\u8d27\u6570\u91cfccc61+\u672c\u6708\u76d8\u76c8\u4e8f\u6570\u91cfccc71<\/p>\n LET \u672c\u6708\u7ed3\u5b58\u91d1\u989dccc92=\u4e0a\u6708\u7ed3\u5b58\u91d1\u989dccc12+\u672c\u6708\u5165\u5e93\u91d1\u989dccc22\uff08\u6750\u659922a+\u4eba\u5de522b+\u5236\u8d3922c+\u52a0\u5de522d+\u5176\u4ed622e\uff09+\u672c\u6708\u91cd\u5de5\u9886\u51fa\u91d1\u989dccc26+\u672c\u6708\u91cd\u5de5\u5165\u5e93\u91d1\u989dccc28+\u672c\u6708\u5de5\u5355\u9886\u7528\u6210\u672cccc32+\u672c\u6708\u6742\u9879\u9886\u7528\u6210\u672cccc42+\u672c\u6708\u5176\u4ed6\u8c03\u6574\u6210\u672cccc52+\u672c\u6708\u9500\u8d27\u6210\u672cccc62+\u672c\u6708\u76d8\u76c8\u4e8f\u91d1\u989dccc72<\/p>\n \u9500\u9000\u6570\u91cfccc64\u548c\u9500\u9000\u6210\u672cccc66\u672a\u8003\u8651\uff1f\uff1f\uff1f<\/p>\n LET \u672c\u6708\u7ed3\u5b58\u6750\u6599\u91d1\u989d=\u672c\u6708\u7ed3\u5b58\u6570\u91cfccc91*\u672c\u6708\u5e73\u5747\u5355\u4ef7-\u6750\u6599ccc223a<\/p>\n \u4eba\u5de5<\/p>\n \u5236\u8d39<\/p>\n \u59d4\u5916<\/p>\n \u5176\u4ed6<\/p>\n \u5dee\u5f02\u91d1\u989dccc93<\/p>\n <\/p>\n <\/p>\n <\/p>\n p500_ccc_ccc26<\/p>\n \u5904\u7406\u91cd\u5de5\u9886\u51fa\u91d1\u989d<\/p>\n <\/p>\n <\/p>\n p500_ccc_ccc23()<\/p>\n \u8ba1\u7b97\u672c\u6708\u91cd\u5de5\u5de5\u5355\u90e8\u5206\u7684\u5e73\u5747\u5355\u4ef7<\/p>\n \u5148\u53d6\u671f\u521d\u5f00\u5e10\uff0c\u518d\u53d6\u4e0a\u6708\u4f59\u989d\u8fdb\u884c\u8ba1\u7b97\u5e73\u5747\u5355\u4ef7<\/p>\n <\/p>\n <\/p>\n p500_tlf_upd()<\/p>\n \u66f4\u65b0tlf \u6863\u5355\u4ef7<\/p>\n <\/p>\n p500_ccc_ins()<\/p>\n \u66f4\u65b0ccc\u6863\u6210\u672c\u91d1\u989d<\/p>\n <\/p>\n p500_cch_0()<\/p>\n \u5c06\u5de5\u5355\u5143\u4ef6\u5728\u5728\u5236\u6210\u672c\u6863\u6309\u4e0a\u6708\u671f\u672b\u8f6c\u672c\u6708\u671f\u521d\uff0c\u5176\u4f59\u5f52\u96f6<\/p>\n <\/p>\n p500_cch_01()<\/p>\n \u5c06\u5de5\u5355\u5143\u4ef6\u5728\u5728\u5236\u6210\u672c\u6863\u5168\u90e8\u5f52\u96f6<\/p>\n <\/p>\n wip_del()<\/p>\n \u5220\u9664\u5de5\u5355\u5728\u5236\u6210\u672c\u6863\uff08ccg\/cch\uff09<\/p>\n p500_wip()<\/p>\n \u5904\u7406WIP\u5de5\u5355\u5728\u5236\u6210\u672c(\u5de5\u5355\u6027\u8d281\/7)<\/p>\n SELECT * FROM sfb_file\u00a0\u00a0 #\u627e\u5f53\u524d\u6599\u4ef6\u5728\u5236\u5de5\u5355\uff08\u975e\u91cd\u5de5\uff09<\/p>\n WHERE sfb05 =g_ima01<\/p>\n AND sfb02!= ’13’ AND sfb02 != ’11’<\/p>\n AND (sfb99 IS NULL OR sfb99 = ‘ ‘ OR sfb99=’N’)<\/p>\n AND (sfb38 IS NULL OR sfb38 >= g_bdate)\u00a0 # \u5de5\u5355\u6210\u4f1a\u7ed3\u5e10\u65e5<\/p>\n AND (sfb81 IS NULL OR sfb81 <= g_edate)\u00a0 # \u5de5\u5355\u5f00\u7acb\u65e5\u671f<\/p>\n ORDER BY sfb01<\/p>\n \u5148delete \u00a0ccg\/cch\u00a0 wip_del<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u4e3b\u4ef6\u90e8\u5206\u6210\u672c(ccg)\u00a0 wip_1()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u5143\u4ef6\u6295\u5165\u6210\u672c(cch)\u00a0 wip_2()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u5143\u4ef6\u8f6c\u51fa\u6210\u672c(cch)\u00a0 wip_3()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u4e3b\u4ef6SUM\u6210\u672c(ccg)\u00a0 wip_4()<\/p>\n <\/p>\n <\/p>\n p500_wip_rework()<\/p>\n \u5904\u7406WIP-REWORK\u5728\u5236\u6210\u672c\uff08\u91cd\u5de5sfb99=\u2019Y\u2019\uff09<\/p>\n \u5148delete \u00a0ccg\/cch\u00a0 wip_del2<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u4e3b\u4ef6\u90e8\u5206\u6210\u672c(ccg)\u00a0 wip_1()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u5143\u4ef6\u6295\u5165\u6210\u672c(cch)\u00a0 wip_2()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u5143\u4ef6\u8f6c\u51fa\u6210\u672c(cch)\u00a0 wip_3()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u4e3b\u4ef6SUM\u6210\u672c(ccg)\u00a0 wip_4()<\/p>\n <\/p>\n <\/p>\n wip_1()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u4e3b\u4ef6\u90e8\u5206\u6210\u672c(ccg)<\/p>\n \u5c06mccg\u5f52\u96f6p500_mccg_0<\/p>\n <\/p>\n wip\u4e0a\u671f\u671f\u672b\u6570\u91cf\u8f6c\u672c\u671f\u671f\u521d\uff08\u5148\u53d6\u5728\u5236\u5de5\u5355\u6210\u672c\u6570\u91cfccg91,\u518d\u53d6\u5728\u5236\u5f00\u5e10\u6863\u6570\u91cfccf11\uff09<\/p>\n \u5de5\u65f6\u7edf\u8ba1wip_ccg20\uff08\u53d6ccj\u6863\u5de5\u5355\u5408\u8ba1\u5de5\u65f6\uff09<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355WIP\u4e3b\u4ef6\u8f6c\u51fa\u6570\u91cfwip_ccg31 \uff08\u53d6tlf\u6863\u6210\u54c1\u5165\u5e93-\u6210\u54c1\u9000\u5e93\uff09<\/p>\n \u66f4\u65b0ccg_file<\/p>\n <\/p>\n <\/p>\n <\/p>\n wip_ccg20()<\/p>\n SELECT SUM(ccj05) INTO mccg.ccg20 FROM ccj_file\u00a0\u00a0\u00a0\u00a0\u00a0 #\u53d6ccj\u6863\u5de5\u5355\u5408\u8ba1\u5de5\u65f6<\/p>\n WHERE ccj04=g_sfb.sfb01 AND ccj01 BETWEEN g_bdate AND g_edate<\/p>\n <\/p>\n Wip_ccg31()<\/p>\n \u8ba1\u7b97\u5de5\u5355WIP\u4e3b\u4ef6\u8f6c\u51fa\u6570\u91cf<\/p>\n SELECT SUM(tlf10*tlf60) INTO g_make_qty FROM tlf_file\u00a0\u00a0\u00a0\u00a0\u00a0 # \u5f53\u6708\u6210\u54c1\u5165\u5e93\u91cf<\/p>\n WHERE tlf62=g_sfb.sfb01 AND tlf06 BETWEEN g_bdate AND g_edate<\/p>\n AND (tlf03 = 50)<\/p>\n AND tlf13 MATCHES ‘asft6*’<\/p>\n AND (tlf01 = g_sfb.sfb05)<\/p>\n SELECT SUM(tlf10*tlf60) INTO g_make_qty2 FROM tlf_file\u00a0\u00a0\u00a0\u00a0 #\u5f53\u6708\u6210\u54c1\u9000\u5e93\u91cf<\/p>\n WHERE tlf62=g_sfb.sfb01 AND tlf06 BETWEEN g_bdate AND g_edate<\/p>\n AND (tlf02 = 50)<\/p>\n AND tlf13 MATCHES ‘asft6*’<\/p>\n AND (tlf01 = g_sfb.sfb05)<\/p>\n \u8f6c\u51fa\u6570\u91cf\uff08\u4ee5\u8d1f\u6570\u8868\u793a\uff09=\u9000\u5e93\u91cf-\u5165\u5e93\u91cf<\/p>\n <\/p>\n <\/p>\n <\/p>\n wip_ccg21()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u4e3b\u4ef6\u6295\u5165\u6570\u91cf<\/p>\n \u6293\u5de5\u5355\u53d1\u6599\u5e95\u7a3fsfq\u7684\u6210\u5957\u53d1\u6599\uff08sfp=1\uff09-\u6210\u5957\u9000\u6599\uff08sfp=6\uff09<\/p>\n <\/p>\n <\/p>\n wip_2()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u5143\u4ef6\u2018\u671f\u521d\/\u672c\u671f\u6295\u5165\u6210\u672c\u2019cch<\/p>\n step1. WIP\u5143\u4ef6\u4e0a\u671f\u672b\u8f6c\u672c\u671f\u671f\u521d\u00a0 wip_2_1<\/p>\n step2-1 WIP\u5143\u4ef6\u672c\u671f\u6295\u5165\u6750\u6599\uff08\u4f9d\u5de5\u5355\u53d1\u6599\/\u9000\u6599\u6863\uff09 wip_2_21<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP\u4e3b\u4ef6\u6295\u5165\u6570\u91cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 wip_ccg21<\/p>\n step2-2 WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u4eba\u5de5\u5236\u8d39\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 wip_2_22<\/p>\n step2-3 WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u8c03\u6574\u6210\u672c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 wip_2_23<\/p>\n <\/p>\n <\/p>\n wip_2_1()<\/p>\n \u5148\u53d6cch\u6863\u4e0a\u671f\u8f6c\u672c\u671f\u671f\u521d<\/p>\n \u518d\u53d6ccf\u5728\u5236\u5f00\u5e10\u6863\u8f6c\u672c\u671f\u671f\u521d<\/p>\n <\/p>\n <\/p>\n wip_2_21()<\/p>\n WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u6750\u6599\uff08\u4f9d\u5de5\u5355\u53d1\/\u9000\u6599\u6863\uff09 \u540c\u65f6\u7ed3\u51fa\u6295\u5165\u91d1\u989d<\/p>\n SELECT tlf01,ima08,ima57,tlf02,tlf03,tlf13,SUM(tlf10*tlf60*tlf907*-1),<\/p>\n SUM(tlf21*tlf907*-1),SUM(tlf221*tlf907*-1),SUM(tlf222*tlf907*-1),<\/p>\n SUM(tlf2231*tlf907*-1)<\/p>\n FROM tlf_file,ima_file<\/p>\n WHERE tlf62=g_sfb.sfb01 AND tlf06 BETWEEN g_bdate AND g_edate<\/p>\n AND ((tlf02=50 AND tlf03 BETWEEN 60 AND 69) OR<\/p>\n (tlf03=50 AND tlf02 BETWEEN 60 AND 69))<\/p>\n AND tlf01=ima01 AND tlf10<>0<\/p>\n AND tlf13 MATCHES ‘asfi5*’ #\u5de5\u5355\u53d1\u9000\u6599<\/p>\n AND tlf907 != 0<\/p>\n GROUP BY 1,2,3,4,5,6<\/p>\n <\/p>\n \u4e3b\u4ef6\u6599\u53f7=\u5143\u4ef6\u6599\u53f7\u00a0\u00a0 \u8868\u793a\u91cd\u5de5<\/p>\n \u6210\u672c\u9636\u76f8\u7b49ima57 =ima57_t\u8868\u793a\u91cd\u5de5<\/p>\n \u6210\u672c\u9636\u8f83\u5c0fima57<ima57_t \u8868\u793a\u91cd\u5de5<\/p>\n \u53d6\u53d1\u6599\u5355\u4ef7<\/p>\n \u672c\u9636\u91cd\u5de5\u8005\u53d6\u91cd\u5de5\u524d\u5e93\u5b58\u6708\u5e73\u5747 \uff08\u672c\u6708ccc12+ccc22\uff09<\/p>\n \u4e0a\u9636\u91cd\u5de5\u8005\u53d6\u4e0a\u6708\u5e93\u5b58\u6708\u5e73\u5747<\/p>\n \u65e0\u5355\u4ef7\u53d6\u4e0a\u6708\u5e93\u5b58\u6708\u5e73\u5747\u00a0\u00a0\u00a0 \uff08\u4e0a\u6708ccc23\uff09<\/p>\n \u4ecd\u65e0\u5355\u4ef7\u53d6\u4e0a\u671f\u5e93\u5b58\u5f00\u5e10\u5355\u4ef7\uff08\u4e0a\u6708cca23\uff09<\/p>\n \u975e\u91cd\u5de5\u5219\u53d6\u672c\u6708\u5e93\u5b58\u6708\u5e73\u5747 \uff08\u5f53\u6708ccc23\uff09<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n wip_2_22()<\/p>\n WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u4eba\u5de5\u5236\u8d39<\/p>\n \u7531cck\u6bcf\u6708\u4eba\u5de5\/\u5236\u8d39\/\u5de5\u65f6\u6863\u6293\u53d6<\/p>\n \u59d4\u5916\u52a0\u5de5\u6210\u672c=\u59d4\u5916\u5165\u5e93\uff08apb101\uff09-\u59d4\u5916\u9000\u5e93(apb101)<\/p>\n <\/p>\n <\/p>\n wip_2_23()<\/p>\n WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u8c03\u6574\u6210\u672c<\/p>\n \u7531ccl\u00a0\u5728\u5236\u8c03\u6574\u6210\u672c\u6863\u6293\u53d6<\/p>\n <\/p>\n wip_32()<\/p>\n WIP\u5143\u4ef6 \u672c\u671f\u8f6c\u51fa\u6210\u672c\uff08\u5b9e\u9645\u6210\u672c\uff09<\/p>\n <\/p>\n \u5148\u5224\u65ad\u672c\u671f\u8f6c\u51fa\u5143\u4ef6\u6570\u91cf\uff08\u4f9d\u6807\u51c6QPA\u8ba1\u7b97\uff09<\/p>\n \u6309\u5de5\u65f6\u5206\u914d\u4eba\u5de5\u5236\u8d39<\/p>\n \u82e5\u672c\u671f\u4ec5\u53d1\u751f\u52a0\u5de5\u8d39\u4e14\u5df2\u5b8c\u5de5\u5165\u5e93\uff0c\u5219\u5168\u6570\u8f6c\u51fa<\/p>\n \u82e5\u5f53\u671f\u672a\u8f6c\u51fa\u5373\u7ed3\u6848\uff0c\u5219\u5f52\u5165\u5dee\u5f02\u6210\u672c<\/p>\n \u8ba1\u7b97\u672c\u671f\u7ed3\u5b58\u6210\u672c<\/p>\n <\/p>\n <\/p>\n p500_sub()<\/p>\n \u66ff\u4ee3\u4ef6\u8f6c\u51fa<\/p>\n <\/p>\n <\/p>\n wip_4()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355WIP\u4e3b\u4ef6\u6210\u672cccg<\/p>\n \u53d6cch-\u00e0ccg\u00a0 ,\u53d6\u534a\u6210\u54c1cch-\u00e0 ccg ,\u00a0 \u6240\u6709cch-\u534a\u6210\u54c1cch(\u5143\u4ef6\u8f6c\u51fa\u6210\u672c) = \u672c\u9636\u4e3b\u4ef6\u6295\u5165\u6210\u672c<\/p>\n <\/p>\n <\/p>\n <\/p>\n p500_wipx()\u00a0\u00a0\u00a0 \u62c6\u4ef6\u5f0f\u5de5\u5355\u6295\u5165\u53ca\u62c6\u4ef6\u8f6c\u51fa<\/p>\n \u5904\u7406WIP\u5728\u5236\u6210\u672c<\/p>\n wipx_1 \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP \u4e3b\u4ef6\u90e8\u5206\u6210\u672c(cct)<\/p>\n wipx_2 \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP \u5143\u4ef6\u6295\u5165\u6210\u672c(ccu)<\/p>\n wipx_3\u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP \u5143\u4ef6\u8f6c\u51fa\u6210\u672c(ccu)<\/p>\n wipx_4 \u8ba1\u7b97\u6bcf\u5f20\u5de5\u5355\u7684WIP \u4e3b\u4ef6SUM\u6210\u672c(cct)<\/p>\n p500_ccc_tot(2) \u8ba1\u7b97\u6240\u6709\u51fa\u5e93\u6210\u672c\u53ca\u7ed3\u5b58<\/p>\n p500_ccc_upd\u00a0\u00a0 update ccc_file<\/p>\n <\/p>\n wipx_1()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u62c6\u4ef6\u5f0f\u5de5\u5355\u7684WIP\u4e3b\u4ef6\u90e8\u5206\u6210\u672c<\/p>\n \u5c06mcct\u6e05\u96f6<\/p>\n wipx_cct20 \u7edf\u8ba1\u5de5\u65f6<\/p>\n <\/p>\n <\/p>\n wipx_2()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u62c6\u4ef6\u5f0f\u5de5\u5355\u7684WIP\u5143\u4ef6\u2018\u671f\u521d\/\u672c\u671f\u6295\u5165\u2019\u6210\u672c\uff08ccu\uff09<\/p>\n wipx2_1\u00a0\u00a0 WIP\u5143\u4ef6 \u4e0a\u671f\u671f\u672b\u8f6c\u672c\u671f\u671f\u521d<\/p>\n wipx2_21\u00a0\u00a0 WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u6750\u6599\uff08\u4f9d\u62c6\u4ef6\u5f0f\u5de5\u5355\u53d1\/\u9000\u6599\u5355\uff09<\/p>\n wipx2_22\u00a0 WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u4eba\u5de5\u5236\u8d39<\/p>\n wipx2_23\u00a0 WIP\u5143\u4ef6 \u672c\u671f\u6295\u5165\u8c03\u6574\u6210\u672c<\/p>\n <\/p>\n <\/p>\n wipx_3()<\/p>\n WIP\u5143\u4ef6 \u672c\u671f\u8f6c\u51fa\u6210\u672c<\/p>\n \u53d6\u5f53\u6708\u5e93\u5b58\u6708\u5e73\u5747\u6863\uff0c\u62c6\u51fa\u5143\u4ef6\u53d6\u672c\u6708\u7b97\u51fa\u52a0\u6743\u5e73\u5747\u5355\u4ef7<\/p>\n wipx_2_24() \u8ba1\u7b97\u671f\u672b\uff08\u5de5\u5355\u672a\u7ed3\u6848\uff09\u6216\u5dee\u5f02\uff08\u5de5\u5355\u5df2\u7ed3\u6848\uff09<\/p>\n <\/p>\n <\/p>\n wipx_4()<\/p>\n \u8ba1\u7b97\u6bcf\u5f20\u62c6\u4ef6\u5f0f\u5de5\u5355WIP\u4e3b\u4ef6\u6210\u672c\uff08cct\uff09<\/p>\n <\/p>\n \u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » TIPTOP axcp500D \u4ee3\u7801\u89e3\u91ca<\/a><\/p>","protected":false},"excerpt":{"rendered":" \u6210\u672c\u9636\uff1a99\u00a0 \u539f\u6599\u65e0\u5de5\u5355(\u91c7\u8d2d\u6599\u4ef6)\u00a0 ima08=P\/V\/Z \u539f\u6599\u6709\u5de5\u5355\u6709BOM \u6210\u54c1\u6216\u534a\u6210\u54c1\u6709\u5de5\u5355\u65e0BOM 0-96 \u6210\u54c1\u6216\u534a\u6210\u54c1\u6709\u5de5\u5355\u6709BOM cca_file \u5e93\u5b58\u6210\u672c\u671f\u521d ccb_file \u5e93\u5b58\u6210\u672c\u5f53\u6708\u5165\u5e93\u8c03\u6574\u91d1\u989d ccc_ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,25],"tags":[468,469,382],"class_list":["post-1329","post","type-post","status-publish","format-standard","hentry","category-4gl","category-abnormal","tag-axcp500","tag-469","tag-382"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1329"}],"version-history":[{"count":2,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1329\/revisions"}],"predecessor-version":[{"id":1331,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1329\/revisions\/1331"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}