날짜검색

(。◠ ◠。)·2023년 9월 21일
0

시작날짜만 검색 -> 끝날짜는 오늘날짜로
끝날짜만 검색 -> 끝날짜만으로 검색
끝날짜가 시작날짜보다 클 경우 시작날짜는 초기화 된 채로 끝날짜만으로 검색

var currentDate = new Date();
var year = currentDate.getFullYear();
var month = String(currentDate.getMonth() + 1).padStart(2, '0');
var day = String(currentDate.getDate()).padStart(2, '0');
var today = year + '-' + month + '-' + day;

	$('#searchStDate').change(function(){
		if($('#searchEdDate').val() != ""){
			if($('#searchEdDate').val() < $('#searchStDate').val()){
				$('#searchStDate').val("");
			}
		}
		if($('#searchEdDate').val() == ""){
			$('#searchEdDate').val(today);
		}
		listForm.submit();
	});
	$('#searchEdDate').change(function(){
		if($('#searchStDate').val() !=  ""){
			if($('#searchEdDate').val() < $('#searchStDate').val()){
				$('#searchStDate').val("");
			}
		}
		listForm.submit();
	});
	<if test='searchStDate != null and searchStDate !="" and searchEdDate != null and searchEdDate !=""'>
			AND REGIST_DATE BETWEEN #{searchStDate} AND DATE_ADD(#{searchEdDate}, INTERVAL 1 DAY)
		</if>
		<if test='(searchStDate == null or searchStDate == "") and (searchEdDate != null and searchEdDate != "")'>
			AND REGIST_DATE <![CDATA[<=]]> DATE_ADD(#{searchEdDate}, INTERVAL 1 DAY)
		</if>
profile
화이탱!

0개의 댓글