//発注日とステータスの更新

//入力値取得
var itemBlockListHed = TALON.getBlockData_List(1);
var lineDataMap = itemBlockListHed[0];
var _NRHATTYU = lineDataMap['NRHATTYU'];
var _STHATTYU = lineDataMap['STHATTYU'];
var _MODIFY_COUNT = lineDataMap['MODIFY_COUNT'];

if ( _STHATTYU == '10' ) {

//フィールドの設定
var itemColNameTbl = [
'NRHATTYU' ,
'DTHATTYU' ,
'STHATTYU' ,
'UPDATED_DATE' ,
'UPDATED_BY' ,
'UPDATED_PRG_NM' ,
'MODIFY_COUNT'
];

//データの設定
var itemDataList = new Array();
itemDataList['NRHATTYU']   = _NRHATTYU;
itemDataList['DTHATTYU']   = new java.util.Date();
itemDataList['STHATTYU']   = '20';
itemDataList['UPDATED_DATE']   = new java.util.Date();
itemDataList['UPDATED_BY']     = TALON.getUserInfoMap().get("USER_ID");
itemDataList['UPDATED_PRG_NM'] = 'XDMF_HF013_0';
itemDataList['MODIFY_COUNT']   = ( _MODIFY_COUNT + 1);

var whereList = new Array();
var whereTbl1 = [ null, '=' ,  'NRHATTYU' ];
whereList.push(whereTbl1);

TALON.updateByMap( 'HT010', itemDataList , itemColNameTbl , whereList );
}

var objSU      = %2_QTHATTYU%;
var objTANKA   = %2_PRHATTYU%;
var objKINGAKU = %2_KINGAKU%;

if (objSU.value=='') { objSU.value = '0'; }
if (objTANKA.value=='') { objTANKA.value = '0'; }

/* カンマを除去して計算して、カンマ編集して金額項目にセット */
objKINGAKU.value = parseInt(objSU.value.replace(',','')) * parseInt(objTANKA.value.replace(',',''));
objKINGAKU.value = objKINGAKU.value.replace( /(\d)(?=(\d\d\d)+(?!\d))/g, '$1,');

var objSU      = %2_QTHATTYU%;
var objTANKA   = %2_PRHATTYU%;
var objKINGAKU = %2_KINGAKU%;

if (objSU.value=='') { objSU.value = '0'; }
if (objTANKA.value=='') { objTANKA.value = '0'; }

/* カンマを除去して計算して、カンマ編集して金額項目にセット */
objKINGAKU.value = parseInt(objSU.value.replace(',','')) * parseInt(objTANKA.value.replace(',',''));
objKINGAKU.value = objKINGAKU.value.replace( /(\d)(?=(\d\d\d)+(?!\d))/g, '$1,');

var objSU      = %2_QTHATTYU%;
var objTANKA   = %2_PRHATTYU%;
var objKINGAKU = %2_KINGAKU%;

if (objSU.value=='') { objSU.value = '0'; }
if (objTANKA.value=='') { objTANKA.value = '0'; }

/* カンマを除去して計算して、カンマ編集して金額項目にセット */
objKINGAKU.value = parseInt(objSU.value.replace(',','')) * parseInt(objTANKA.value.replace(',',''));
objKINGAKU.value = objKINGAKU.value.replace( /(\d)(?=(\d\d\d)+(?!\d))/g, '$1,');

SELECT  
        HT010.NRHATTYU as NRHATTYU
       ,HT010.STHATTYU as STHATTYU
       ,HT010.DTHATTYU as DTHATTYU
       ,HT010.IDSIIRESAKI as IDSIIRESAKI
       ,AT030.TXKANJI as TXKANJI
       ,HT010.CDSOUKO as CDSOUKO
       ,AT040.TXSOUKO as TXSOUKO
       ,HT010.TXTEKIYO as TXTEKIYO
       ,HT010.DTCREATE as DTCREATE
       ,HT010.MODIFY_COUNT as MODIFY_COUNT
       ,AT030.NRYUBIN
       ,AT030.TXJYUSYO1
FROM
 HT010 LEFT JOIN AT030
            ON  HT010.IDSIIRESAKI = AT030.IDTORIHIKISAKI
 LEFT JOIN AT040
            ON  HT010.CDSOUKO= AT040.CDSOUKO

SELECT  
        HT011.NRHATTYU as NRHATTYU
       ,HT011.SQHATTYU as SQHATTYU
       ,HT011.IDHINMOKU as IDHINMOKU
       ,BT010.TXHINBAN as TXHINBAN
       ,BT010.TXHINMEI as TXHINMEI
       ,HT011.QTHATTYU as QTHATTYU
       ,KBUNITPUR_VAL.DSP1 as KBUNITPUR
       ,HT011.PRHATTYU as PRHATTYU
       ,HT011.QTHATTYU * HT011.PRHATTYU as KINGAKU
      ,HT011.DTNOUKI as DTNOUKI
       ,HT011.NRSOURCE as NRSOURCE
       ,HT011.QTKENSYU as QTKENSYU
       ,HT011.QTKANZAN
       ,CASE WHEN HT011.FGNYUKA = 'T' THEN '済み' END AS FGNYUKA 
       ,HT011.MODIFY_COUNT as MODIFY_COUNT
FROM
 HT010 INNER JOIN HT011
            ON  HT010.NRHATTYU = HT011.NRHATTYU
 LEFT JOIN BT010
            ON  HT011.IDHINMOKU = BT010.IDHINMOKU
 LEFT JOIN TLN_M_HANYO_CODE_MAIN KBUNITPUR_VAL
            ON  KBUNITPUR_VAL.SIKIBETU_CODE = 'KBUNIT'
           AND KBUNITPUR_VAL.KEY_CODE = BT010.KBUNITPUR