存储函数使用（自用）

create
    definer = lydb@`%` function getfiledifbebook(field_id varchar(255), begin_time varchar(255),
                                                 end_time varchar(255)) returns varchar(50)
BEGIN
	#Routine body goes here...
	/*
	根据场馆id和开始时间，结束时间
	判断此场馆场地被预订状态的内容
	0：还未被预订  1：已经被预订了
	*/
DECLARE result VARCHAR (50);
DECLARE ll_row INTEGER;
DECLARE ll_state VARCHAR (50);
DECLARE  ll_res  INTEGER;
DECLARE ll_enable  INTEGER;

select t.is_reserved from base_field t where t.field_id = field_id and t.is_enable = '0' into ll_res;

IF ll_res = 1 THEN
	 SELECT '4' INTO result;
ELSE
   select t.is_enable from base_field_bill_rule t where t.field_id = field_id and t.begin_time = begin_time
		AND t.end_time = end_time  into ll_enable;
   IF ll_enable = 1 THEN
     SELECT '4' INTO result;
   ELSE
		SELECT
			count(1)
		FROM
			reserve_detail b
		WHERE
			b.field_id = field_id
		AND b.begin_time = begin_time
		AND b.end_time = end_time 
		AND b.reserve_status in ('1','2','4') INTO ll_row;

			IF ll_row > 0 THEN
				SELECT
					a.reserve_status
				FROM
					reserve_detail a
				WHERE
					a.field_id = field_id
				AND a.begin_time = begin_time
				AND a.end_time = end_time 
				AND a.reserve_status in ('1','2','4') 
				INTO ll_state;

				IF ll_state = '4' then
					SELECT '4' INTO result;
				ELSE
					SELECT '1' INTO result;
				END
				IF;

			ELSE
				SELECT
					'0' INTO result;
			END IF;
   end if;
END IF;

	RETURN (result);
END;