By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `barber_employee` (`emp_id` INT, `tot_sal` INT)
CREATE TABLE `attendance_log` (`emp_id` INT, `io` VARCHAR(10))
CREATE TABLE employee(position INT, status INT)
CREATE PROCEDURE `addBarberCommission`(IN `empID` INT, IN `ioIN` VARCHAR(11))
BEGIN
INSERT INTO `attendance_log` (`emp_id`, `io`) VALUES (`empID`, `ioIN`);
IF EXISTS (SELECT e.position, e.status, a.io FROM employee e INNER JOIN
attendance_log a WHERE a.emp_id = `empID`
AND e.position = 'Barber'
AND e.status = 'Active'
AND a.io = 'Time In') THEN
INSERT INTO `barber_employee` (`emp_id`, `tot_sal`) VALUES (`empID`, 0);
END IF;
END #
CALL `addBarberCommission`(1,'a')