= ?, 1, 0)) as total_last FROM alert a INNER JOIN alert_type at ON at.alert_type_id = a.alert_type_id WHERE ( ( a.alert_type_id IN ( SELECT xatr.alert_type_id FROM alert_type xat INNER JOIN alert_type_roles xatr ON xatr.alert_type_id = xat.alert_type_id INNER JOIN orchadmin_user_roles xour ON xour.orchadmin_role_id = xatr.orchadmin_role_id WHERE xour.orchadmin_user_id = ? and (xat.alert_permission = "group" OR (xat.alert_permission = "individual" and xour.orchadmin_role_id NOT IN (3) ) ) GROUP BY xatr.alert_type_id) ) OR a.alert_id IN (SELECT xar.alert_id FROM alert_roles xar INNER JOIN orchadmin_user_roles xour ON xour.orchadmin_role_id = xar.orchadmin_role_id WHERE xour.orchadmin_user_id = ? GROUP BY xar.alert_id) OR ( a.alert_for = "vendor" AND a.alert_for_id IN (SELECT vendor_id FROM vendor WHERE assigned_to = ?) ) OR ( a.alert_for = "artist" AND a.alert_for_id IN (SELECT a.artist_id FROM artist_info a INNER JOIN vendor v ON v.vendor_id = a.vendor_id WHERE v.assigned_to = ?) ) OR ( a.alert_for = "release" AND a.alert_for_id IN (SELECT r.upc FROM releases r INNER JOIN artist_info a ON a.artist_id = r.artist_id INNER JOIN vendor v ON v.vendor_id = a.vendor_id WHERE r.release_status = "in_content" AND v.assigned_to = ?) ) )'; $result = Doctrine_Manager::getInstance()->getConnection('art_relations')->execute($sql, $params); $myalert_row = $result->fetchAll(); if (is_file(PUBLIC_PATH.'/oa/images/users/'.$logged_user_id.'.jpg')) { $avatar_image = '/images/users/' . $logged_user_id . '.jpg'; } else { $avatar_image = '/images/imgAvatar.gif'; } $logoutLink = '/logout_v2.php'; ?>
 
oa_acl->getPrimaryRole() ?>