傑佛瑞Blog TIPTOP ERP+ EasyFlow (BPM) + BI 系統整合開發經驗分享

May 05 Thu 2011 16:33
電子簽核表單及流程動態更改方式(侵入性極高)

電子簽核表單及流程動態更改方式 (程式侵入性極高) ===> UI 操作 Data , 操作 Data 就等於玩弄 UI
開發程序說明:
1.表單跑錯流程了或是流程設計錯誤了造成無法派送下一關或是引發不可預期的錯誤問題
Anyway 我們需要可以在執行時期去做動態變更資料及內容的狀況時 How to do !!!????
2.萬一流程被結案了或是被終止或是正在進行中 (無法取回重辦) 或是資料沒有正確儲存起來或是會隨著時間一再做變動其變動性極大的狀況時 How to do!!!???
舉例說明:
如外出申請單一樣不到最後一刻不曉得哪些人隨車出去或是開哪台公務車回來如何申請費用公出時又形同請公出假需要轉HR人資系統等等需求因隨時都會有變動的可能性事後補單需求頻繁之狀況
PS:大概如上述所言故有此功能需求提出
結論就是:
是否有方法可以做動態即時的資料更動讓系統隨我們想要的方式去GO
答案是當然可以!!!!!

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類： EasyFlow GP

▲top

May 05 Thu 2011 16:32
(自訂功能) 自動完成與提示: 表單欄位共用功能 (Ajax --> PHP (JSON/XML)

(自訂功能) 自動完成與提示: 表單欄位共用功能 (Ajax --> PHP (JSON/XML)

1. Javascript 程式碼片斷:

//////////// BEGIN : AutoSuggest 自動完成 For TIPTOP Ajax Function /////////////////

// AutoSuggest --> pnu_file.pnu031 輸入關鍵字系統自動完成與提示可用字串

var options_pnu031 = {

script: function (input) { return "http://127.0.0.1/glmc/ajax/ajax_autosuggest.php?input="+input; },

varname:"input"

};

var as_pnu031 = new bsn.AutoSuggest('pnu031', options_pnu031);

//////////// END : AutoSuggest 自動完成 For TIPTOP Ajax Function //////////////////////////

1. PHP 程式碼片斷:

//////////// BEGIN : AutoSuggest 自動完成 For TIPTOP Ajax Function /////////////////

<?php

$input = $_GET['input'];

$len = strlen($input);

$limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 6;

$link = OCILogon("ds", "ds", "topprod");

$query = "select distinct afa01,afa02

from (

select afa01,afa02

from db1.afa_file

where afaacti='Y'

union all

select afa01,afa02

from db2.afa_file

where afaacti='Y'

union all

select afa01,afa02

from db3.afa_file

where afaacti='Y' ) order by 1";

//echo "$query";

$s = OCIParse($link,$query);

if(! $s)

{

$e = ocierror();

var_dump($e);

}

ociexecute($s);

$Rrows = ocifetchstatement($s, $results);

$aUsers = array ();

$aInfo = array ();

for ($i = 0; $i < $Rrows; $i++)

{

$aUsers[$i]= $results["AFA01"][$i];

$aInfo[$i] = $results["AFA02"][$i];

}

//This will print all the elements in the array

//or you can print one element=$myarray[0]

# for ($j=0; $j < $Rrows; $j++)

# {

# echo "$j:" . $aUsers[$j]."<br>\n";

# }

$aResults = array();

$count = 0;

if ($len)

{

for ($i=0;$i<count($aUsers);$i++)

{

// had to use utf_decode, here

// not necessary if the results are coming from oracle

//

if (substr($aUsers[$i],0,$len) == $input)

{

$count++;

$aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($aUsers[$i]), "info"=>htmlspecialchars($aInfo[$i]) );

}

if ($limit && $count==$limit)

break;

}

header ("Expires: Mon, 26 Jul 2000 05:00:00 GMT"); // Date in the past

header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified

header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1

header ("Pragma: no-cache"); // HTTP/1.0

if (isset($_REQUEST['json']))

{

header("Content-Type: application/json; charset=utf-8");

echo "{\"results\": [";

$arr = array();

for ($i=0;$i<count($aResults);$i++)

{

$arr[] = "{\"id\": \"".$aResults[$i]['id']."\", \"value\": \"".$aResults[$i]['value']."\", \"info\": \"\"}";

}

echo implode(", ", $arr);

echo "]}";

}

else

{

header("Content-Type: text/xml; charset=utf-8");

echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?><results>";

for ($i=0;$i<count($aResults);$i++)

{

echo "<rs id=\"".$aResults[$i]['id']."\" info=\"".$aResults[$i]['info']."\">".$aResults[$i]['value']."</rs>";

}

echo "</results>";

}

OCIFreeStatement($s);

OCILogoff($link);

?>

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類： EasyFlow GP

▲top

May 05 Thu 2011 16:32
電子簽核使用者自訂異(開窗查詢)範例程式碼

function btn_query_onclick(){
var sql ="";
sql += "select distinct gem01,gem03 from ( ";
sql += "SELECT gem01,gem03 FROM "+dbs+".gem_file WHERE gem05=? AND gemacti=? ";
sql += "union all ";
sql += "SELECT gem01,gem03 FROM "+dbs+".gem_file WHERE gem05=? AND gemacti=? ";
sql += "union all ";
sql += "SELECT gem01,gem03 FROM "+dbs+".gem_file WHERE gem05=? AND gemacti=? ";
sql += " ) ";
sql += " where gem01 like ? ";
var fieldName = "OpenWinForReturn";
var labelArray = new Array("部門編號","部門名稱");
var returnId = new Array("pnu033");
var databaseCfgId = "LocalConnection_for_TIPTOP";
var sqlClaused =sql;
var params = new Array("Y","Y","Y","Y","Y","Y","%");
var types = new Array("SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR");
var setIds= new Array("gem01","gem03");
openWind(fieldName,labelArray,returnId,databaseCfgId,sqlClaused,params,types,setIds);
}

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類： EasyFlow GP

▲top

May 05 Thu 2011 16:31
電子簽核統計表範例

電子簽核統計表範例
public function StringToSQL(switchMode:String):String {
   var para1:String = f_sdate.text;
   var para2:String = f_edate.text;
   var USERID:String = myUserName;


  /* BEGIN: 組合SQL命令要操作遠端物件去執行的 SQL命令字串 */
  var sql_str:String ="";
  sql_str +=" SELECT distinct ('http://127.0.0.1:8080/NaNaWeb/GP/WMS/TraceProcess/TraceProcessForSearchForm'||'?'||'hdnMethod=searchSingleFormDetail'||'&'||'hdnFormDefId="+TableSchema.toString()+"'||'&'||'hdnProcessInstOID='|| PROCESSOID ||'&'||'hdnCurrentUserId=administrator') AS URL,('http://127.0.0.1:8080/NaNaWeb/GP/WMS/TraceProcess/ProcessInstanceTraceResult'||'?'||'hdnMethod=traceProcessFromExternalWeb'||'&'||'hdnProcessInstOID='|| PROCESSOID ||'&'||'hdnCurrentUserId=administrator'||'&'||'hdnLocale=zh_TW') AS URLX,";
  sql_str +=" NVL(serialNumber,' ') AS X,nvl(to_char(f_applydate,'yyyy/mm/dd'),' ') AS X0,NVL(X1,' ') AS X1,NVL(X2,' ') AS X2,NVL(X3,' ') AS X3,NVL(X4,' ') AS X4,NVL(X5,' ') AS X5,NVL(X6,' ') AS X6,NVL(X7,' ') AS X7,NVL(X8,' ') AS X8,NVL(X9,' ') AS X9,DECODE(NVL(processState,9), '0', '未開始', '1', '進行中', '2', '已暫停', '3', '已完成', '4', '已撤銷', '5', '已中止',processState) AS X10,nvl(t3.username,'無') AS X11,NVL(X12,'未核准') AS X12 ";
  sql_str +=" FROM ( SELECT DISTINCT LOCALRELEVANTDATA.valueoid,FORMINSTANCE.SERIALNUMBER AS A1,ProcessInstance.serialNumber, ProcessInstance.currentState AS processState, ProcessInstance.OID AS processOID, ParticipantActivityInstance.definitionId, Users.id, Users.userName ";
  sql_str +=" FROM ef.ProcessInstance, ef.ParticipantActivityInstance, ef.WorkItem, ef.WorkAssignment, ef.Users,ef.LOCALRELEVANTDATA,ef.FORMINSTANCE ";
  sql_str +=" WHERE ParticipantActivityInstance.contextOID = ProcessInstance.contextOID ";
  sql_str +=" AND ParticipantActivityInstance.currentState >= 0 ";
  sql_str +=" AND WorkItem.containerOID = ParticipantActivityInstance.OID ";
  sql_str +=" AND WorkItem.currentState >= 0 AND WorkAssignment.workItemOID = WorkItem.OID ";
  sql_str +=" AND WorkAssignment.isNotice >= 0 AND WorkAssignment.assigneeOID = Users.OID ";
  sql_str +=" and PROCESSINSTANCE.CONTEXTOID=LOCALRELEVANTDATA.CONTAINEROID and LOCALRELEVANTDATA.VALUEOID=FORMINSTANCE.OID) t1, ";
  sql_str +=" (SELECT DISTINCT ProcessInstance.OID AS processOID2, Users.id, Users.userName ";
  sql_str +=" FROM EF.ProcessInstance, EF.ParticipantActivityInstance, EF.WorkItem, EF.WorkAssignment, EF.Users ";
  sql_str +=" WHERE ParticipantActivityInstance.contextOID = ProcessInstance.contextOID ";
  sql_str +=" AND (ParticipantActivityInstance.currentState = 0 OR ParticipantActivityInstance.currentState = 1 ";
  sql_str +=" OR ParticipantActivityInstance.currentState = 6) ";
  sql_str +=" AND WorkItem.containerOID = ParticipantActivityInstance.OID ";
  sql_str +=" AND (WorkItem.currentState = 0 OR WorkItem.currentState = 1) ";
  sql_str +=" AND WorkAssignment.workItemOID = WorkItem.OID AND WorkAssignment.isNotice = 0 ";
  sql_str +=" AND WorkAssignment.assigneeOID = Users.OID ";
  sql_str +=" and ProcessInstance.serialNumber like '"+TableSchema.toString()+"%' ) t3 , ";
  sql_str +=" ( select T1.oid,f_applier,f_applydate,nvl(f_applydept,' ') AS X1,users.id AS UUID, ";
  sql_str +=" nvl(users.username,'無') AS X2,nvl(sel_leavingtype,( select distinct NVL(max(g_sel_leavingtype),' ') from ef."+TableSchema.toString()+"_g_detail t2 ";
  sql_str +=" where t1.formserialnumber = t2.formserialnumber and rownum <=1 )) AS X3,nvl(f_sdate,( select distinct min(g_cqh04) from ef."+TableSchema.toString()+"_g_detail t2 ";
  sql_str +=" where t1.formserialnumber = t2.formserialnumber )) AS X4, ";
  sql_str +=" nvl(f_stime,( select distinct min(g_cqh051) from ef."+TableSchema.toString()+"_g_detail t2 ";
  sql_str +=" where t1.formserialnumber = t2.formserialnumber )) AS X5,nvl(f_edate,( select distinct max(g_cqh04) from ef."+TableSchema.toString()+"_g_detail t2 ";
  sql_str +=" where t1.formserialnumber = t2.formserialnumber )) AS X6,nvl(f_etime,( select distinct max(g_cqh061) from ef."+TableSchema.toString()+"_g_detail t2 ";
  sql_str +=" where t1.formserialnumber = t2.formserialnumber )) AS X7, ";
  sql_str +=" decode(substr(NVL(txt_applied_hours,nvl(f_total_hours,0)),1,1),'.','0'||NVL(txt_applied_hours,nvl(f_total_hours,0)),nvl(to_char(nvl(txt_applied_hours,nvl(f_total_hours,0))),' ')) AS X8, ";
  sql_str +=" decode(substr(NVL(txt_applied_days,nvl(f_total_days,0)),1,1),'.','0'||nvl(txt_applied_days,nvl(f_total_days,0)),nvl(to_char(nvl(txt_applied_days,nvl(f_total_days,0))),' ')) AS X9,NVL(f_CONFX,'未核准') AS X12 ";
  sql_str +=" from EF."+TableSchema.toString()+" t1,EF.USERS WHERE f_applier = users.id(+) ";
  sql_str +=" ) t4 ";
  sql_str +=" where serialNumber like '"+TableSchema.toString()+"%' ";
  sql_str +=" AND t3.processOID2(+) = processOID AND t1.valueoid = t4.oid(+) AND t4.f_applier LIKE '"+USERID+"' AND";
  sql_str +=" f_applydate BETWEEN to_date('"+para1+"','yyyy/mm/dd') AND to_date('"+para2+"','yyyy/mm/dd') AND ";
  sql_str +=" processState LIKE '"+f_status.selectedItem.data+"' order by 4 desc ";
  /* END: 組合SQL命令要操作遠端物件去執行的 SQL命令字串 */

  return sql_str;
}

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(1) 人氣()

個人分類： EasyFlow GP

▲top

May 05 Thu 2011 16:30
●集團年度出貨數量金額統計表●

●集團年度出貨數量金額統計表●

sql_str += " SELECT '"+para1+"' OPLANT,t1.OYEAR,t1.OMONTH,"
   sql_str += " CASE WHEN t1.OSALES IS NULL THEN '全部合計' ";
   sql_str += " WHEN t1.OSALES IS NOT NULL AND t1.OITEMNO IS NULL ";
   sql_str += " THEN '小計 ('||t1.OSALES||')' ELSE t1.OSALES END OSALES, ";
   sql_str += " (t1.OITEMNO||'_') OITEMNO,t1.OITEMD1,t1.OITEMD2,t1.OCUSTID,t1.OCUSTOM,sum(t1.ONUM) ONUM,sum(t1.OTOTAL) OTOTAL ,sum(t2.ONUM) ONUM2,sum(t2.OTOTAL) OTOTAL2 FROM ( ";
   sql_str += " SELECT OYEAR,OMONTH,OSALES,OITEMNO,OITEMD1,OITEMD2,OCUSTID,OCUSTOM,SUM(ONUM) AS ONUM,SUM(OTOTAL) AS OTOTAL FROM ( ";
sql_str += " SELECT '"+para2+"' AS OYEAR,NVL(month(oga02),0) AS OMonth,NVL(USERNAME,'N/A') AS OSALES,NVL(IMA01,' ') AS OITEMNO,NVL(IMA02,' ') AS OITEMD1,NVL(IMA021,' ') AS OITEMD2,NVL(occ01,' ') AS OCUSTID,NVL(occ02,' ') AS OCUSTOM,ogb12 AS ONUM,(ogb12*ogb13*oga24) as OTOTAL ";
sql_str += " FROM "+para1+".ima_file,"+para1+".oga_file,"+para1+".ogb_file,"+para1+".occ_file,DS.STAFF_FILE ";
sql_str += " WHERE occ01 = oga03 ";
sql_str += " AND ogb04 = ima01 ";
sql_str += " AND oga01 = ogb01 ";
sql_str += " AND ogapost = 'Y' "; // -- 已扣帳
sql_str += " AND ogaconf = 'Y' ";// -- 已確認
sql_str += " AND oga55 ='1' ";
   sql_str += " AND oga09 not in ('1', '5') ";// -- 排除出通單
   sql_str += " AND year(oga02) LIKE '"+para2+"' ";
   sql_str += " AND month(oga02) LIKE '"+para3+"' ";
   sql_str += " AND occ04 = USERID(+) ";
   sql_str += " AND ogb04 LIKE '"+para4+"' ";
   sql_str += " order by 1,2 ";
   sql_str += " ) ";
   sql_str += " GROUP BY OYEAR,OMONTH,OSALES,OITEMNO,OITEMD1,OITEMD2,OCUSTID,OCUSTOM ";
   sql_str += " order by 1,2,3 ";
   sql_str += " ) t1,( ";
   sql_str += " SELECT '"+para1+"' OPLANT,OYEAR,OSALES,OITEMNO,OITEMD1,OITEMD2,OCUSTID,OCUSTOM,SUM(ONUM) AS ONUM,SUM(OTOTAL) AS OTOTAL FROM ( ";
sql_str += " SELECT '"+para2+"' AS OYEAR,NVL(USERNAME,'N/A') AS OSALES,NVL(IMA01,' ') AS OITEMNO,NVL(IMA02,' ') AS OITEMD1,NVL(IMA021,' ') AS OITEMD2,NVL(occ01,' ') AS OCUSTID,NVL(occ02,' ') AS OCUSTOM,ogb12 AS ONUM,(ogb12*ogb13*oga24) as OTOTAL ";
sql_str += " FROM "+para1+".ima_file,"+para1+".oga_file,"+para1+".ogb_file,"+para1+".occ_file,DS.STAFF_FILE ";
sql_str += " WHERE occ01 = oga03 ";
sql_str += " AND ogb04 = ima01 ";
sql_str += " AND oga01 = ogb01 ";
sql_str += " AND ogapost = 'Y' ";// -- 已扣帳
sql_str += " AND ogaconf = 'Y' ";// -- 已確認
sql_str += " AND oga55 ='1' ";
   sql_str += " AND oga09 not in ('1', '5') ";// -- 排除出通單
   sql_str += " AND year(oga02) LIKE '"+para2+"' ";
   sql_str += " AND occ04 = USERID(+) ";
   sql_str += " AND ogb04 LIKE '"+para4+"' ";
   sql_str += " order by 1,2 ";
   sql_str += " ) ";
   sql_str += " GROUP BY OYEAR,OSALES,OITEMNO,OITEMD1,OITEMD2,OCUSTID,OCUSTOM ";
   sql_str += " order by 1,2,3 ";
   sql_str += " ) t2 ";
   sql_str += " where ";
   sql_str += " t1.OSALES = t2.OSALES ";
   sql_str += " AND t1.OYEAR = t2.OYEAR ";
   sql_str += " AND t1.OITEMNO = t2.OITEMNO ";
   sql_str += " AND t1.OITEMD1 = t2.OITEMD1 ";
   sql_str += " AND t1.OITEMD2 = t2.OITEMD2 ";
   sql_str += " AND t1.OCUSTID = t2.OCUSTID ";
   sql_str += " AND t1.OCUSTOM = t2.OCUSTOM ";
   sql_str += " GROUP BY GROUPING SETS((t1.OSALES),(t1.OYEAR,t1.OMONTH,t1.OSALES,t1.OITEMNO,t1.OITEMD1,t1.OITEMD2,t1.OCUSTID,t1.OCUSTOM,t1.ONUM,t1.OTOTAL, t2.ONUM, t2.OTOTAL ),()) ";

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類：客製程式開發

▲top

May 05 Thu 2011 16:30
●單據編號未扣帳未確認檢查表aoou702●

●單據編號未扣帳未確認檢查表aoou702●
DROP VIEW DS.CV_"+dbs+"PNO;

CREATE OR REPLACE FORCE VIEW ds.cv_"+dbs+"pno (x1,
   x2,
   x3,
   x4,
   x5,
   x6,
   x7,
   x8,
   x9,
   x10
   )
AS
   SELECT 'AIM' AS x1, ina01 AS x2, smydesc AS x3,
   TO_CHAR (ina02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (ina03, 'yyyy/mm/dd') AS x5, inaconf AS x6, inapost AS x7,
   inauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ina_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ina01 LIKE TRIM (smyslip) || '-%'
   AND inapost = 'N'
   AND inaconf <> 'X'
   AND inauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AIM' AS x1, imm01 AS x2, smydesc AS x3,
   TO_CHAR (imm02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (imm12, 'yyyy/mm/dd') AS x5, immconf AS x6, imm03 AS x7,
   immuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".imm_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE imm01 LIKE TRIM (smyslip) || '-%'
   AND imm10 = '1'
   AND (immconf = 'N' AND imm03 = 'N')
   AND immuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AIM' AS x1, imm01 AS x2, smydesc AS x3,
   TO_CHAR (imm02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (imm12, 'yyyy/mm/dd') AS x5, immconf AS x6, imm03 AS x7,
   immuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".imm_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE imm01 LIKE TRIM (smyslip) || '-%'
   AND imm10 IN ('2', '3', '4')
   AND (imm04 = 'N' AND imm03 = 'N')
   AND immuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AIM' AS x1, imo01 AS x2, smydesc AS x3,
   TO_CHAR (imo02, 'yyyy/mm/dd') AS x4, '' AS x5, imoconf AS x6,
   imopost AS x7, imouser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".imo_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE imo01 LIKE TRIM (smyslip) || '-%'
   AND imopost = 'N'
   AND imoconf <> 'X'
   AND imouser = zx01(+)
   AND zx03 = gem01(+)
-----------
   UNION ALL
   SELECT 'APM' AS x1, pmk01 AS x2, smydesc AS x3,
   TO_CHAR (pmk04, 'yyyy/mm/dd') AS x4, '' AS x5, pmk18 AS x6,
   ' ' AS x7, pmkuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".pmk_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE pmk01 LIKE TRIM (smyslip) || '-%'
   AND pmk25 <> '6'
   AND pmk18 = 'N'
   AND pmkuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'APM' AS x1, pmi01 AS x2, smydesc AS x3,
   TO_CHAR (pmi02, 'yyyy/mm/dd') AS x4, '' AS x5, pmiconf AS x6,
   ' ' AS x7, pmiuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".pmi_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE pmi01 LIKE TRIM (smyslip) || '-%'
   AND pmiconf = 'N'
   AND pmiuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'APM' AS x1, pmm01 AS x2, smydesc AS x3,
   TO_CHAR (pmm04, 'yyyy/mm/dd') AS x4, '' AS x5, pmm18 AS x6,
   ' ' AS x7, pmmuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".pmm_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE pmm01 LIKE TRIM (smyslip) || '-%'
   AND pmm25 <> '6'
   AND pmm18 = 'N'
   AND pmmuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'APM' AS x1, pna01 AS x2, smydesc AS x3,
   TO_CHAR (pna04, 'yyyy/mm/dd') AS x4, '' AS x5, pna05 AS x6,
   pnaconf AS x7, pnauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".pna_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE pna01 LIKE TRIM (smyslip) || '-%'
   AND (pna05 != 'X' AND pnaconf = 'N')
   AND pnauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'APM' AS x1, rvu01 AS x2, smydesc AS x3,
   TO_CHAR (rvu03, 'yyyy/mm/dd') AS x4, '' AS x5, rvuconf AS x6,
   ' ' AS x7, rvuuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".rvu_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE rvu01 LIKE TRIM (smyslip) || '-%'
   AND rvuconf = 'N'
   AND rvuuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'APM' AS x1, rva01 AS x2, smydesc AS x3,
   TO_CHAR (rva06, 'yyyy/mm/dd') AS x4, '' AS x5, rvaconf AS x6,
   ' ' AS x7, rvauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".rva_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE rva01 LIKE TRIM (smyslip) || '-%'
   AND rvaconf = 'N'
   AND rvauser = zx01(+)
   AND zx03 = gem01(+)
------------
   UNION ALL
   SELECT 'AXM' AS x1, oea01 AS x2, oaydesc AS x3,
   TO_CHAR (oea02, 'yyyy/mm/dd') AS x4, '' AS x5, oeaconf AS x6,
   ' ' AS x7, oeauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".oea_file, "+dbs+".oay_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE oea01 LIKE TRIM (oayslip) || '-%'
   AND oeaconf = 'N'
   AND oeauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXM' AS x1, oep01 AS x2, oaydesc AS x3,
   TO_CHAR (oep04, 'yyyy/mm/dd') AS x4, '' AS x5, oepconf AS x6,
   ' ' AS x7, oepuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".oep_file, "+dbs+".oay_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE oep01 LIKE TRIM (oayslip) || '-%'
   AND oep09 <> '2'
   AND oepconf <> 'X'
   AND oepuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXM' AS x1, oga01 AS x2, oaydesc AS x3,
   TO_CHAR (oga02, 'yyyy/mm/dd') AS x4, '' AS x5, ogaconf AS x6,
   ogapost AS x7, ogauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".oga_file, "+dbs+".oay_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE oga01 LIKE TRIM (oayslip) || '-%'
   AND ogaconf <> 'X'
   AND ( ( oga09 IN ('2', '3', '4', '7', '8', '9')
   AND (ogaconf = 'N' OR ogapost = 'N')
   )
   OR (oga09 IN ('1', '5') AND ogaconf = 'N')
   )
   AND ogauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXM' AS x1, ofa01 AS x2, 'INVOICE ' AS x3,
   TO_CHAR (ofa02, 'yyyy/mm/dd') AS x4, '' AS x5, ofaconf AS x6,
   ' ' AS x7, ofauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ofa_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ofaconf = 'N' AND ofauser = zx01(+) AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXM' AS x1, oha01 AS x2, oaydesc AS x3,
   TO_CHAR (oha02, 'yyyy/mm/dd') AS x4, '' AS x5, ohaconf AS x6,
   ohapost AS x7, ohauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".oha_file, "+dbs+".oay_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE oha01 LIKE TRIM (oayslip) || '-%'
   AND (ohaconf = 'N' OR (ohaconf != 'X' AND ohapost = 'N'))
   AND ohauser = zx01(+)
   AND zx03 = gem01(+)
--------------------
   UNION ALL
   SELECT 'ASF' AS x1, sfb01 AS x2, smydesc AS x3,
   TO_CHAR (sfb81, 'yyyy/mm/dd') AS x4, '' AS x5, sfb87 AS x6,
   ' ' AS x7, sfbuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".sfb_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE sfb01 LIKE TRIM (smyslip) || '-%'
   AND sfb04 <> '8'
   AND sfb28 IS NOT NULL
   AND sfb28 <> ' '
   AND sfb87 = 'N'
   AND sfbuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ASF' AS x1, sfp01 AS x2, smydesc AS x3,
   TO_CHAR (sfp03, 'yyyy/mm/dd') AS x4, '' AS x5, sfpconf AS x6,
   sfp04 AS x7, sfpuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".sfp_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE sfp01 LIKE TRIM (smyslip) || '-%'
   AND (sfpconf != 'X' AND sfp04 = 'N')
   AND sfpuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ASF' AS x1, sfu01 AS x2, smydesc AS x3,
   TO_CHAR (sfu02, 'yyyy/mm/dd') AS x4, '' AS x5, sfuconf AS x6,
   sfupost AS x7, sfuuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".sfu_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE sfu01 LIKE TRIM (smyslip) || '-%'
   AND (sfuconf != 'X' AND sfupost = 'N')
   AND sfuuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ASF' AS x1, sfk01 AS x2, smydesc AS x3,
   TO_CHAR (sfk02, 'yyyy/mm/dd') AS x4, '' AS x5, sfkconf AS x6,
   sfkpost AS x7, sfkuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".sfk_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE sfk01 LIKE TRIM (smyslip) || '-%'
   AND (sfkconf != 'X' AND sfkpost = 'N')
   AND sfkuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ASF' AS x1, ksa01 AS x2, smydesc AS x3,
   TO_CHAR (ksa02, 'yyyy/mm/dd') AS x4, '' AS x5, ' ' AS x6,
   ksapost AS x7, ksauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ksa_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ksa01 LIKE TRIM (smyslip) || '-%'
   AND ksapost = 'N'
   AND ksauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ASF' AS x1, ksc01 AS x2, smydesc AS x3,
   TO_CHAR (ksc02, 'yyyy/mm/dd') AS x4, '' AS x5, kscconf AS x6,
   kscpost AS x7, kscuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ksc_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ksc01 LIKE TRIM (smyslip) || '-%'
   AND (kscconf != 'X' AND kscpost = 'N')
   AND kscuser = zx01(+)
   AND zx03 = gem01(+)
------------------------------
   UNION ALL
   SELECT 'AAP' AS x1, apa01 AS x2, apydesc AS x3,
   TO_CHAR (apa02, 'yyyy/mm/dd') AS x4, '' AS x5, apa41 AS x6,
   apa42 AS x7, apauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".apa_file, "+dbs+".apy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE apa01 LIKE TRIM (apyslip) || '-%'
   AND apa41 = 'N'
   AND apa42 = 'N'
   AND apauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, apf01 AS x2, apydesc AS x3,
   TO_CHAR (apf02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (apfinpd, 'yyyy/mm/dd') AS x5, apf41 AS x6, ' ' AS x7,
   apfuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".apf_file, "+dbs+".apy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE apf01 LIKE TRIM (apyslip) || '-%'
   AND apf41 = 'N'
   AND apfuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, ala01 AS x2, '' AS x3,
   TO_CHAR (ala08, 'yyyy/mm/dd') AS x4,
   TO_CHAR (alainpd, 'yyyy/mm/dd') AS x5, alafirm AS x6, '' AS x7,
   alauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ala_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE (alaclos IS NULL OR alaclos <> 'Y')
   AND alafirm = 'N'
   AND alauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, ala01 AS x2, '' AS x3,
   TO_CHAR (ala08, 'yyyy/mm/dd') AS x4,
   TO_CHAR (alainpd, 'yyyy/mm/dd') AS x5, ala78 AS x6, alafirm AS x7,
   alauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ala_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ala78 = 'N'
   AND (alaclos IS NULL OR alaclos <> 'Y')
   AND alafirm != 'X'
   AND alauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, alc01 AS x2, '' AS x3,
   TO_CHAR (alc08, 'yyyy/mm/dd') AS x4,
   TO_CHAR (alcinpd, 'yyyy/mm/dd') AS x5, alcfirm AS x6, ' ' AS x7,
   alcuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".alc_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE alcfirm = 'N' AND alcuser = zx01(+) AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, alc01 AS x2, '' AS x3,
   TO_CHAR (alc08, 'yyyy/mm/dd') AS x4,
   TO_CHAR (alcinpd, 'yyyy/mm/dd') AS x5, alc78 AS x6, ' ' AS x7,
   alcuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".alc_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE alc78 = 'N' AND alcuser = zx01(+) AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, alk01 AS x2, '' AS x3,
   TO_CHAR (alk02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (alkinpd, 'yyyy/mm/dd') AS x5, alkfirm AS x6, ' ' AS x7,
   alkuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".alk_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE alkfirm = 'N' AND alkuser = zx01(+) AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, alh01 AS x2, '' AS x3,
   TO_CHAR (alh021, 'yyyy/mm/dd') AS x4,
   TO_CHAR (alhinpd, 'yyyy/mm/dd') AS x5, alhfirm AS x6, ' ' AS x7,
   alhuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".alh_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE alhfirm = 'N' AND alhuser = zx01(+) AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AAP' AS x1, als01 AS x2, '' AS x3,
   TO_CHAR (als02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (alsinpd, 'yyyy/mm/dd') AS x5, alsfirm AS x6, ' ' AS x7,
   alsuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".als_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE alsfirm = 'N' AND alsuser = zx01(+) AND zx03 = gem01(+)
----------------------
   UNION ALL
   SELECT 'ANM' AS x1, nmd01 AS x2, nmydesc AS x3,
   TO_CHAR (nmd07, 'yyyy/mm/dd') AS x4, '' AS x5, nmd30 AS x6,
   ' ' AS x7, nmduser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".nmd_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE nmd01 LIKE TRIM (nmyslip) || '-%'
   AND nmd30 = 'N'
   AND nmduser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, npl01 AS x2, nmydesc AS x3,
   TO_CHAR (npl02, 'yyyy/mm/dd') AS x4, '' AS x5, nplconf AS x6,
   ' ' AS x7, npluser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".npl_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE npl01 LIKE TRIM (nmyslip) || '-%'
   AND nplconf = 'N'
   AND npluser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, nmh01 AS x2, nmydesc AS x3,
   TO_CHAR (nmh04, 'yyyy/mm/dd') AS x4, '' AS x5, nmh38 AS x6,
   ' ' AS x7, nmhuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".nmh_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE nmh01 LIKE TRIM (nmyslip) || '-%'
   AND nmh38 = 'N'
   AND nmhuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, npn01 AS x2, nmydesc AS x3,
   TO_CHAR (npn02, 'yyyy/mm/dd') AS x4, '' AS x5, npnconf AS x6,
   ' ' AS x7, npnuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".npn_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE npn01 LIKE TRIM (nmyslip) || '-%'
   AND npnconf = 'N'
   AND npnuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, nmg00 AS x2, nmydesc AS x3,
   TO_CHAR (nmg01, 'yyyy/mm/dd') AS x4, '' AS x5, nmgconf AS x6,
   ' ' AS x7, nmguser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".nmg_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE nmg00 LIKE TRIM (nmyslip) || '-%'
   AND nmgconf = 'N'
   AND nmguser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, nne01 AS x2, nmydesc AS x3,
   TO_CHAR (nne02, 'yyyy/mm/dd') AS x4, '' AS x5, nneconf AS x6,
   ' ' AS x7, nneuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".nne_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE nne01 LIKE TRIM (nmyslip) || '-%'
   AND nneconf = 'N'
   AND nneuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, nng01 AS x2, nmydesc AS x3,
   TO_CHAR (nng02, 'yyyy/mm/dd') AS x4, '' AS x5, nngconf AS x6,
   ' ' AS x7, nnguser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".nng_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE nng01 LIKE TRIM (nmyslip) || '-%'
   AND nngconf = 'N'
   AND nnguser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, nni01 AS x2, nmydesc AS x3,
   TO_CHAR (nni02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (nniinpd, 'yyyy/mm/dd') AS x5, nniconf AS x6, ' ' AS x7,
   nniuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".nni_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE nni01 LIKE TRIM (nmyslip) || '-%'
   AND nniconf = 'N'
   AND nniuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'ANM' AS x1, nnk01 AS x2, nmydesc AS x3,
   TO_CHAR (nnk02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (nnkinpd, 'yyyy/mm/dd') AS x5, nnkconf AS x6, ' ' AS x7,
   nnkuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".nnk_file, "+dbs+".nmy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE nnk01 LIKE TRIM (nmyslip) || '-%'
   AND nnkconf = 'N'
   AND nnkuser = zx01(+)
   AND zx03 = gem01(+)
---------------------
   UNION ALL
   SELECT 'AXR' AS x1, ola01 AS x2, ooydesc AS x3,
   TO_CHAR (ola02, 'yyyy/mm/dd') AS x4, '' AS x5, olaconf AS x6,
   '' AS x7, olauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ola_file, "+dbs+".ooy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ola01 LIKE TRIM (ooyslip) || '-%'
   AND (ola40 IS NULL OR ola40 <> 'Y')
   AND olaconf = 'N'
   AND olauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXR' AS x1, ole01 AS x2, ooydesc AS x3,
   TO_CHAR (ole03, 'yyyy/mm/dd') AS x4, '' AS x5, oleconf AS x6,
   ole28 AS x7, oleuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ole_file, "+dbs+".ooy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ole01 LIKE TRIM (ooyslip) || '-%'
   AND (oleconf = 'N' AND ole28 = 'N')
   AND oleuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXR' AS x1, olc01 AS x2, 'INVOICE ' AS x3,
   TO_CHAR (olc02, 'yyyy/mm/dd') AS x4, '' AS x5, olcconf AS x6,
   ' ' AS x7, olcuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".olc_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE olcconf = 'N' AND olcuser = zx01(+) AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXR' AS x1, oma01 AS x2, ooydesc AS x3,
   TO_CHAR (oma02, 'yyyy/mm/dd') AS x4, '' AS x5, omaconf AS x6,
   omavoid AS x7, omauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".oma_file, "+dbs+".ooy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE oma01 LIKE TRIM (ooyslip) || '-%'
   AND omaconf = 'N'
   AND omavoid = 'N'
   AND omauser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AXR' AS x1, ooa01 AS x2, ooydesc AS x3,
   TO_CHAR (ooa02, 'yyyy/mm/dd') AS x4,
   TO_CHAR (ooa021, 'yyyy/mm/dd') AS x5, ooaconf AS x6, ' ' AS x7,
   ooauser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".ooa_file, "+dbs+".ooy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE ooa01 LIKE TRIM (ooyslip) || '-%'
   AND ooaconf = 'N'
   AND ooauser = zx01(+)
   AND zx03 = gem01(+)
---------------------
   UNION ALL
   SELECT 'AQC' AS x1, qcf01 AS x2, smydesc AS x3,
   TO_CHAR (qcf04, 'yyyy/mm/dd') AS x4, '' AS x5, qcf14 AS x6,
   '' AS x7, qcfuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".qcf_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE qcf01 LIKE TRIM (smyslip) || '-%'
   AND qcf14 = 'N'
   AND qcfuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AQC' AS x1, qcm01 AS x2, smydesc AS x3,
   TO_CHAR (qcm04, 'yyyy/mm/dd') AS x4, '' AS x5, qcm14 AS x6,
   '' AS x7, qcmuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".qcm_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE qcm01 LIKE TRIM (smyslip) || '-%'
   AND qcm14 = 'N'
   AND qcmuser = zx01(+)
   AND zx03 = gem01(+)
   UNION ALL
   SELECT 'AQC' AS x1, qcs01 AS x2, smydesc AS x3,
   TO_CHAR (qcs04, 'yyyy/mm/dd') AS x4, '' AS x5, qcs14 AS x6,
   '' AS x7, qcsuser AS x8, zx02 AS x9, gem02 AS x10
   FROM "+dbs+".qcs_file, "+dbs+".smy_file, "+dbs+".zx_file, "+dbs+".gem_file
   WHERE qcs01 LIKE TRIM (smyslip) || '-%'
   AND qcs14 = 'N'
   AND qcsuser = zx01(+)
   AND zx03 = gem01(+);

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類：客製程式開發

▲top

May 05 Thu 2011 16:30
關於我

TIPTOP GP ERP + EasyFlow GP+ BI 系統整合開發建置經驗分享
企業級應用程序開發技術整合專案研究探討
此站使用程式技術如下:
1.Flex SDK ( 3 + 4 )
2.pureMVC / Cairngorm Framework
3. JAVA ( 5 / 6)
4.Spring3 / Hibernate3 / iBatis(myBatis)
5.amfphp
6.BlazeDS
7.Apache / Tomcat / Ralio CFML

＊個人喜歡研究新技術應用開發整合平台。
＊外包案子接收窗口平台: 104外包網 JCase / 518 外包網。
＊針對社會人士授課企業電腦系統實務應用與教學。
＊如果你有 TIPTOP GP 4GL / Crystal Report / EasyFlow GP / BI / Flex / AIR / PHP / Java / Oracle PL/SQL 相關的案子需要外包都可以直接與我聯絡！
Phone:0928432056
MSN:johnaustinkimo@yahoo.com.tw
YAHOO MAILBOX:johnaustinkimo@yahoo.com.tw
PS: 意者請洽: 我的電話 / 電子郵件 / MSN / 簡訊或忙線中未接請留言給我謝謝您

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類：

▲top

May 05 Thu 2011 16:28
●單階材料用途查詢abmq510●

●單階材料用途查詢abmq510●

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類：客製程式開發

▲top

May 05 Thu 2011 16:27
●每月結案工單超領料統計表●

●每月結案工單超領料統計表●
public function StringToSQL(switchMode:String):String {

var para1:String = (f_itemno.text =="")? "%" : searchAndReplace(f_itemno.text,"*","%");

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類：客製程式開發

▲top

May 05 Thu 2011 16:26
●集團製造生產日況維護作業●

●集團製造生產日況維護作業●

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類：客製程式開發

▲top

May 05 Thu 2011 16:25
●鼎新 TIPTOP ERP PreBOM 維護作業●

●TIPTOP ERP GP PreBOM 維護作業●
程式作業說明:
鼎新TIPTOP GP abmi600 工程正式BOM 與開發模擬BOM 作業優化解決方案
客戶提供PreBOM產品用料表(EXCEL / TXT ...格式) 與鼎新 TIPTOP GP ERP 做資料互動連結依客戶提供料品可自定義對應系統的模擬PreBOM選料策略

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(1) 人氣()

個人分類：站台介紹

▲top

May 05 Thu 2011 16:24
●集團信用超限暨留置放行維護作業●

●集團信用超限暨留置放行維護作業●
switch(mode_type){
case "SO":

(繼續閱讀...)

jeffreyhu 發表在痞客邦留言(0) 人氣()

個人分類：客製程式開發

▲top

參觀人氣

成人內容提醒