126

소율튜브 8편 - 다양한 소율

* ETRI ARM Firmware 교육과정 key point

1. 8주차 : 프로젝트 2~3개
2. 9주차 : AI
3. 8/29 발표
4. 8/30 소프트웨어 검증 업체

1. segment control

https://www.youtube.com/watch?v=BbgMEnmnM-o&feature=youtu.be

생각2) 나만 아니면 된다고 생각하다가 결국 자기 자식이 당한다. 즉, 자신에게 돌아온다. 물론, 자식을 자식으로 생각치 않는 부모에게는 해당없음. 불효자보다 이런 부모를 찾는 것이 급선무. 내 주변에도 많다.

https://charlespyo.com/2017/11/16/%EB%B8%94%EB%A1%9D%EC%B2%B4%EC%9D%B8%EC%9D%80-%ED%98%84%EC%9E%AC-%EC%96%B4%EB%94%94%EC%AF%A4-%EC%99%80%EC%9E%88%EB%82%98/

https://charlespyo.com/2017/10/16/%ED%91%9C%EC%B2%A0%EB%AF%BC%EC%9D%98-%ED%81%AC%EB%A6%BD%ED%86%A0%EB%B0%B8%EB%A6%AC-%ED%83%90%EB%B0%A9%EA%B8%B0-4/

*

CHECKING THIS ADD
CHECKING THIS
CHECKING THIS REMOVED 11
CHECKING THIS REMOVED 11
CHECKING THIS REMOVCHECKING THIS

견공자제분
KBS의 보도본부장 이화섭 - 고려대 언론학

조선,중앙,동아일보와 매일경제,한국경제

GS.s.pTendencyPeriodBar?.refresh()

If you have time to come to Korea. Could you come and join us? This is the best show in Korea economic fields. And KBS is the meaning of Korea Broadcasting System.

- (void) c828ListOfStatisticsTotal:(NSMutableArray *)array withDongCd:(NSString *)dongCd ctyp:(NSString*)ctyp {

    sqlite3_stmt *compiledStatement;

    @try {
        //TODO        array things...
        [self checkBackDB];
        if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {

            NSString *query = [NSString stringWithFormat:@" \
                               with t_dfct as ( \
                               select a.cd_dong, a.cd_flor, a.ho, \
                               sum(case b.cd_hndl_stat when 'B' then 1 else 0 end ) as cnt_b, \
                               sum(case b.cd_hndl_stat when 'E' then 1 else 0 end ) as cnt_e, \
                               sum(case b.cd_hndl_stat when 'X' then 1 else 0 end ) as cnt_x from ddtbt_hosh a \
                               left outer join ddtbt_dfct b \
                               on b.cd_dong = a.cd_dong \
                               and b.nohs = a.nohs \
                               and b.id_dfct_ctyp like 111  \
                               where a.cd_dong = '0301' \
                               group by a.cd_dong, a.cd_flor, a.ho \
                               ) \
                               , t_stat as ( \
                               select cd_dong, cd_flor, ho, \
                               case when (cnt_b + cnt_e) > 0 \
                               then case cnt_x when 0 then 'R' else 'Y' end else 'G' \
                               end cl_stat \
                               from t_dfct \
                               ) \
                               select count(cd_dong) as cl_all, \
                               sum(case cl_stat when 'R' then 1 else 0 end) as cl_r, \
                               sum(case cl_stat when 'Y' then 1 else 0 end) as cl_y, \
                               sum(case cl_stat when 'G' then 1 else 0 end) as cl_g from t_stat;"
                               ];

            const char *sqlStatement = [query cStringUsingEncoding:NSASCIIStringEncoding];

            if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {
                while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
                    NSLog(@"cl_all = %@",  [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 0)]);
                    NSLog(@"cl_r = %@",  [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 1)]);
                    NSLog(@"cl_y = %@", [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 2)]);
                    NSLog(@"cl_g = %@", [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 3)]);
                }
            }
        }
        sqlite3_finalize(compiledStatement);
        sqlite3_close(database);
    } @catch(NSException *e) {
        sqlite3_finalize(compiledStatement);
        sqlite3_close(database);
    }
}