pendejadas

DROP PROCEDURE IF EXISTS sp_detailAnnouncement_state_change;
DELIMITER //
CREATE PROCEDURE sp_detailAnnouncement_state_change
(
	IN typeAction VARCHAR(25),
	IN detailAnnouncementIds TEXT,
	IN state VARCHAR(2),
    IN stateAvailability VARCHAR(2),
    IN userId INT,
    OUT rpta INT,
    OUT message VARCHAR(200)
)
BEGIN
	DECLARE @dateStartEvent DATETIME
	DECLARE @valueLimit FLOAT

	SELECT * FROM tm_requerimiento WHERE tm_idrequerimiento

    UPDATE td_requerimiento SET ta_estado_facilitador = state, IdUsuarioAct = userId, FechaAct = NOW()
   		WHERE FIND_IN_SET(td_idrequerimiento, detailAnnouncementIds);


   	SELECT value INTO @valueLimit FROM ta_default_limit WHERE name = 'employer_cancel_48_hours';




   	IF state = '09' THEN
	    UPDATE tm_usuario SET ta_estado_disponibilidad = stateAvailability, IdUsuarioAct = userId, FechaAct = NOW()
	   		WHERE tm_idusuario IN (
	   			SELECT tm_idusuario FROM td_requerimiento
	   			WHERE FIND_IN_SET(td_idrequerimiento, detailAnnouncementIds)
	   		);
   	END IF;

    SET rpta = 1;
END//
DELIMITER ;



SELECT * FROM ta_default_limit;

DROP TABLE IF EXISTS ta_default_limit;

CREATE TABLE ta_default_limit
(
	id int AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(60),
	description VARCHAR(100),
	typeLimit VARCHAR(10),
	value float,
	penalty tinyint(1),
	penatly_percent_value float,
	active tinyint(1),
	createDate datetime,
	modifiedDate datetime
);

INSERT INTO ta_default_limit (name, description, typeLimit, value, penalty, penatly_percent_value, active, createDate, modifiedDate)
VALUES ('employer_cancel_48_hours', 'Cancelación de empleador dentro de 48 horas', 'time', 48, 1, 0.5, 1, NOW(), NOW());

INSERT INTO ta_default_limit (name, description, typeLimit, value, penalty, penatly_percent_value, active, createDate, modifiedDate)
VALUES ('employer_cancel_24_hours', 'Cancelación de empleador dentro de 24 horas', 'time', 24, 1, 1.0, 1, NOW(), NOW());

INSERT INTO ta_default_limit (name, description, typeLimit, value, penalty, penatly_percent_value, active, createDate, modifiedDate)
VALUES ('employer_announcements_free', 'Límite de anuncios free', 'time', 20, 0, 0, 1, NOW(), NOW());

INSERT INTO ta_default_limit (name, description, typeLimit, value, penalty, penatly_percent_value, active, createDate, modifiedDate)
VALUES ('facilitator_confirm_72_hours', 'Confirmación de facilitador 72 horas antes', 'time', 72, 0, 0, 1, NOW(), NOW());

INSERT INTO ta_default_limit (name, description, typeLimit, value, penalty, penatly_percent_value, active, createDate, modifiedDate)
VALUES ('facilitator_confirm_24_hours', 'Confirmación de facilitador 24 horas', 'time', 24, 0, 0, 1, NOW(), NOW());

INSERT INTO ta_default_limit (name, description, typeLimit, value, penalty, penatly_percent_value, active, createDate, modifiedDate)
VALUES ('facilitator_confirm_3_hours', 'Confirmación de facilitador 3 horas', 'time', 3, 0, 0, 1, NOW(), NOW());