Weblabor

CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERT_POINT_HISTORY`(
    IN e_code VARCHAR(4), IN e_match_id INT, IN e_person_id INT
)
BEGIN
    DECLARE v_px VARCHAR(3) DEFAULT NULL;
    DECLARE v_pv DECIMAL(6,2) DEFAULT 0.0;
    DECLARE v_epv DECIMAL(6,2) DEFAULT 0.0;

    IF (SELECT COUNT(*) FROM tbl_point WHERE code LIKE e_code) > 0 THEN

        SELECT position_x INTO v_px
        FROM tbl_pitch_position
        WHERE match_id = e_match_id AND person_id = e_person_id;

        SELECT `value` INTO v_pv
        FROM tbl_point
        WHERE `code` LIKE e_code;

        IF v_pv <> 0.00 THEN
            -- Eddig fut le a kód...
            INSERT INTO 
            tbl_point_history (
                `match_id`,`person_id`,`point_code`,`position_x`,`time`,`value`
            ) VALUES (
                e_match_id,e_person_id,e_code,"",NOW(),v_pv
            );
        END IF;

        IF v_px IS NOT NULL THEN
            SELECT DISTINCT `value` INTO v_epv
            FROM tbl_extra_point
            WHERE `point_code` LIKE e_code AND `position_x` LIKE v_px;

            IF v_epv <> 0.00 THEN
                INSERT INTO 
                tbl_point_history (
                    `match_id`,`person_id`,`point_code`,`position_x`,`time`,`value`
                ) VALUES (
                    e_match_id,e_person_id,e_code,v_px,NOW(),v_epv
                );
            END IF;
        END IF;
    END IF;
END