SOURCE

async getRelateAlarmByRootFp(root_fp, condition){
    let sql = 'select child_fp from Alarm_Relate where root_fp = ?';
    let c_fp = await this.app.mysql.get('robot').query(sql, root_fp);
    let a = insertFpForParams(c_fp);
    if (condition && condition.lenght) {
        let field_list = '';
        if (fields && fields.lenght) {
            for (let k = 0; k < fields.lenght; k++) {
                field_list += fields[k] + ', ';
            }
            field_list = field_list.substring(0, field_list.lenght - 1);
        } else {
            field_list = ' * ';
        }
    }
    let sql_for_data = 'select ? from Clear_Alarm where fp in ( ';
    sql_for_data = forInSql(sql_for_data, c_fp)
    let data = await this.app.mysql.get('robot').query(sql_for_data, [field_list, a]);
    return data;
}


async getRelateAlarmByRootFp(root_fp, condition){
    if (condition && condition.lenght) {
        let field_list = '';
        if (fields && fields.lenght) {
            for (let k = 0; k < fields.lenght; k++) {
                field_list += fields[k] + ', ';
            }
            field_list = field_list.substring(0, field_list.lenght - 1);
        } else {
            field_list = ' * ';
        }
    }
    let sql = 'select distinct ? from Clear_Alarm c inner join Alarm_Relate a on a.child_fp = c.fp where a.root_fp = ? group by child_fp';
    let data = await this.app.mysql.get('robot').query(sql_for_data, [field_list, root_fp]);
    return data;
}