๐Ÿ’ป IT

// ๊ฐ€๊นŒ์ด ์žˆ๋Š” tr ์ง€์šฐ๊ธฐ
$(this).closest('tr').remove();
// ์œˆ๋„์šฐ ์ž๋™ ์ข…๋ฃŒ 3600 = 60๋ถ„ *60์ดˆ์ž„
Cmd์— shutdown -s -t 3600

// ์ž๋™์ข…๋ฃŒ ์ทจ์†Œ 
shutdown -a
// ๋ผ๋””์˜ค ๋ฒ„ํŠผ hide์‹œ label์„ hide ํ•ด์ฃผ๋ฉด๋Œ
$('label[for="expndRptEsntlN"]').hide();
$("#์•„์ด๋””").serializeArray(); 
// ํ•˜๋ฉด name:valueํ˜•ํƒœ๋กœ ๋ณผ์ˆ˜์žˆ์Šต๋‹ˆ๋‹ค.

 

-- CAST() ์‚ฌ์šฉ๋ฐฉ๋ฒ•
UPDATE 
   TB_ACNTG_EXPND_RPT_M taerm
   SET 
   taerm.EXPND_RPT_SUM_AMT =(taerm.EXPND_RPT_SUM_AMT -    CAST(#{expndRptAmt} AS DECIMAL))
   ,taerm.UPDT_ID = #{updtId}
   ,taerm.UPDT_DT = NOW()
WHERE 
   taerm.INSTT_INFO_ID = #{insttInfoId}
   AND taerm.EXPND_RPT_ID = #{expndRptId}

**AS๋กœ ๋ฐ”๊ฟ€ ๋ฐ์ดํ„ฐ ํƒ€์ž…์„ ๋ช…์‹œํ•ด์ค˜์•ผํ•œ๋‹ค.

 

//๋‚ ์งœ ํ‘œ์‹œ(์—ฐ๋งŒ)
$(function(){
   $("#accDate").val(new Date().getFullYear());
   $("#accDate").datepicker({
       changeMonth: false,
       changeYear: true,
       showButtonPanel: true,
       dateFormat: 'yy',
       onClose: function(dateText, inst) {
            $(this).datepicker('setDate', new Date(inst.selectedYear, 0, 1));
       }
   }).focus(function () {
      // ์—ฐ๋„ ์„ ํƒํ•  ๋•Œ๋งŒ ๋‹ฌ๋ ฅ ํ‘œ์‹œ
       $(".ui-datepicker-calendar").hide();
       $(".ui-datepicker-month").hide();
      $(".ui-datepicker-prev").hide();
      $(".ui-datepicker-next").hide();
   });
});

+ Recent posts