-- Obtener ITEM DATA
/*
SELECT
	IF(act.external_id IS NOT NULL, act.external_id, act.id_for_share) AS 'CPNT_ID',
	 'AFA_CURSO' as 'CPNT_TYP_ID',
	 UPPER(DATE_FORMAT(act.created_at, '%b-%d-%Y %H:%i:%s')) AS 'REV_DTE',
	 'PUBLIC' as 'DMN_ID',
	 'N' as 'NOTACTIVE',
	 act.name as 'CPNT_TITLE',
	 '0' as 'DEFAULT_PUB_PRICE',
	 IFNULL(ROUND(act.duration / 60, 2), 0.00) AS CONTACT_HRS
FROM training_activities act
WHERE act.sync_complete = 0 AND act.id_for_share IS NOT NULL AND act.active = 1;
*/

-- Marcar con la fecha de hoy la sincronizacion
/*
UPDATE training_activities
SET sync_sent = CURDATE()
WHERE sync_complete = 0
  AND id_for_share IS NOT NULL
  AND active = 1;
*/


-- Marcar como completada la sincronizacion de los envios de hoy
/* 
UPDATE training_activities
SET sync_complete = 1
WHERE sync_sent = CURDATE()
  AND sync_complete = 0
  AND id_for_share IS NOT NULL
  AND active = 1;
*/

-- Desmarcar como completada la sincronizacion de los envios de hoy
/* 
UPDATE training_activities
SET sync_complete = 0
WHERE sync_sent = CURDATE()
  AND sync_complete = 1
  AND id_for_share IS NOT NULL
  AND active = 1;
*/

-- Desmarcar con la fecha de hoy la sincronizacion
/*
UPDATE training_activities
SET sync_sent = null
WHERE sync_sent = CURDATE()
  AND sync_complete = 0
  AND id_for_share IS NOT NULL
  AND active = 1;
*/






-- LEARNING HISTORY
/* 
SELECT 
    LPAD(u.code_user, 8, '0') AS STUD_ID,
    'AFA_CURSO' AS CPNT_TYP_ID, 
    IF(act.external_id IS NOT NULL, act.external_id, act.id_for_share) AS CPNT_ID,
    'AFA_C' as CMPL_STAT_ID,
    UPPER(DATE_FORMAT(ups.finalized, '%b-%d-%Y %H:%i:%s')) AS COMPL_DTE,
    100 as GRADE,
    IFNULL(ROUND(ups.online_time / 60, 2), 0.00) AS CONTACT_HRS
FROM users u 
INNER JOIN user_progress_statuses ups ON u.id = ups.user_id 
INNER JOIN training_activities act ON ups.training_activity_id = act.id 
WHERE u.code_user IS NOT NULL
    AND ups.finalized IS NOT NULL
    AND ups.online_time IS NOT NULL
    AND ups.progress_type = 'ACTIVITY'
    AND (act.external_id IS NOT NULL OR act.id_for_share IS NOT NULL);
*/