112

2020-03-19 10:23:10.2041350900 MBASS[2031:210011] selectDfct:(DDTBT_DFCT *) query: select a.cd_dong                            ,a.nohs                            ,a.cd_loc_clsf                            ,a.id_loc                            ,a.id_rgon                            ,a.id_dfct_ctyp                            ,a.id_dfct_type                            ,a.id_dfct_caus                            ,a.id_dfct_cl                            ,a.dfct_cnts                            ,ifnull(a.id_wrk_fmer_pic_atch_file,'') as id_wrk_fmer_pic_atch_file                            ,ifnull(a.id_wrk_aftr_pic_atch_file,'') as id_wrk_aftr_pic_atch_file                            ,a.yn_re_clsf_rqst                            ,b.cd_tppg                            ,ifnull(c.nm_dfct_ctyp,'') as nm_dfct_ctyp                            ,ifnull(d.nm_dfct_caus,'') as nm_dfct_caus                            ,ifnull(e.nm_dfct_cl,'') as nm_dfct_cl                            ,a.mode                            ,a.cd_hndl_stat                            ,ifnull(f.nm_loc,'') as nm_loc                            ,ifnull(g.nm_rgon,'') as nm_rgon                            ,ifnull(h.nm_dfct_type,'') as nm_dfct_type                            ,a.yn_svr_trsm                            ,i.nm_dong                            ,ifnull(cd_re_rcpt_resn,'')                            ,ifnull(nm_re_rcpt_resn,'')                            ,a.cd_cpny                            ,a.seq_nipt                            from ddtbt_dfct a                            inner join ddtbt_hosh b on b.cd_dong=a.cd_dong and b.nohs=a.nohs                            left outer join ddtbt_rgon_dfct_ctyp c on c.id_rgon=a.id_rgon                            left outer join ddtbt_dfct_caus d on d.id_dfct_caus=a.id_dfct_caus                            left outer join ddtbt_dfct_cl e on e.id_dfct_cl=a.id_dfct_cl                            left outer join ddtbt_site_tppg_loc f on f.cd_tppg=b.cd_tppg and f.id_loc=a.id_loc                            left outer join ddtbt_site_loc_rgon g on g.id_loc=a.id_loc and g.id_rgon=a.id_rgon                            left outer join ddtbt_rgon_dfct_type h on h.id_rgon=a.id_rgon and h.id_dfct_type=a.id_dfct_type                            left outer join ddtbt_dong i on i.cd_dong=a.cd_dong                            where a.id_mbil=18;
2020-03-19 10:23:10.2096410900 MBASS[2031:210011] [logging] no such column: nm_dfct_type in select nm_dfct_type                            from ddtbt_rgon_dfct_ctyp                            where  id_dfct_ctyp=12                            order by nm_dfct_type DESC;
2020-03-19 10:23:10.2130280900 MBASS[2031:210011] 하자내용재접수사유 :   

       //UILabel* label = [[UILabel alloc] initWithFrame:self.bounds];
        //label.autoresizingMask = UIViewAutoresizingFlexibleWidth | UIViewAutoresizingFlexibleRightMargin;
        //label.lineBreakMode = NSLineBreakByTruncatingTail;
        //[self addSubview: label];
        //self.label = label;


2020-03-19 10:23:10.2133820900 MBASS[2031:210011] selectSiteTppgLoc_SqlUtils.m
2020-03-19 10:23:10.2154420900 MBASS[2031:210011] superSelectSiteLocRgon
2020-03-19 10:23:10.2192890900 MBASS[2031:210011] BsQtChkEdtg2902397516057523
select a.id_mbil                            ,a.cd_dong                            ,a.nohs                            ,c.nm_loc                            ,d.nm_rgon                            ,e.nm_dfct_type                            ,a.dfct_cnts                            ,a.cd_hndl_stat                            ,a.yn_re_clsf_rqst                            ,a.id_wrk_fmer_pic_atch_file                            ,a.id_wrk_aftr_pic_atch_file                            ,f.nm_dong                            ,a.dnt_rgst                            ,a.id_rgon                           ,a.cd_cpny                           from ddtbt_dfct a                            inner join ddtbt_hosh b on b.cd_dong=a.cd_dong and b.nohs=a.nohs                            inner join ddtbt_site_tppg_loc c on c.cd_tppg=b.cd_tppg and c.id_loc=a.id_loc                            inner join ddtbt_site_loc_rgon d on d.id_loc=a.id_loc and d.id_rgon=a.id_rgon                            inner join ddtbt_rgon_dfct_type e on e.id_rgon=a.id_rgon and e.id_dfct_type=a.id_dfct_type                            inner join ddtbt_dong f on f.cd_dong=a.cd_dong                            where a.cd_dong like '%' and a.nohs like '%' and a.yn_re_clsf_rqst like '%'                            and a.mode='U'                            and a.yn_svr_trsm<>'Y'                            and a.cd_hndl_stat like '%'                                     order by a.cd_dong, a.nohs desc, a.id_loc, a.id_rgon;

 

 

Top 10 Monty Python's Flying Circus Moments


https://namu.wiki/w/%EB%AA%AC%ED%8B%B0%20%ED%8C%8C%EC%9D%B4%EC%84%A0


정보 폐쇄의 증거 사라지고 있네.
https://www.youtube.com/watch?v=MYK1ujdrbiQ
https://www.youtube.com/watch?v=OWcpklDPCqI




"아름다운게 추한 것보다 낫다." (Beautiful is better than ugly)
"명시적인 것이 암시적인 것 보다 낫다." (Explicit is better than implicit)
"단순함이 복잡함보다 낫다." (Simple is better than complex)
"복잡함이 난해한 것보다 낫다." (Complex is better than complicated)
"가독성은 중요하다." (Readability counts)

DDTBT_DFCT.ID_DFCT_CL = 10

//NSMutableDictionary *dic = [[NSMutableDictionary alloc] initWithCapacity:0];
    //[db selectHosh:dic withDongCd:mDongCd nohs:mNohs];

 static NSString *CellIdentifier_dong = @"CellHoshCd_dong";
    static NSString *CellIdentifier_flor = @"CellHoshCd_flor";
    static NSString *CellIdentifier_hosh = @"CellHoshCd_hosh";
  cell = [[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault reuseIdentifier:CellIdentifier_dong];

 cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier_dong];
o

static NSString *CellIdentifier = @"CheckInspectionCell";
UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier];

cell = [[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault reuseIdentifier:CellIdentifier];
        
    if( cell != nil)
        for(int i=0; i<=[cell.contentView.subviews count];i++)
            if([cell.contentView.subviews objectAtIndex:i] != nil)
                [[cell.contentView.subviews objectAtIndex:i] removeFromSuperview];
        //        UIButton *img = [cell.contentView.subviews objectAtIndex:1];
        //        if (YES == [data.cd_hndl_stat isEqualToString:@"E"]) {
        //            [img setBackgroundImage:[UIImage imageNamed:@"icon04.png"] forState:UIControlStateDisabled];
        //            [img setTitle:@"처리" forState:UIControlStateDisabled];
        //            [img setTitleColor:[UIColor whiteColor] forState:UIControlStateDisabled];
        //
        //        }
        //        else if (YES == [data.cd_hndl_stat isEqualToString:@"B"]) {
        //            [img setBackgroundImage:[UIImage imageNamed:@"icon03.png"] forState:UIControlStateDisabled];
        //            [img setTitle:@"접수" forState:UIControlStateDisabled];
        //            [img setTitleColor:[UIColor whiteColor] forState:UIControlStateDisabled];
        //
        //        }
        //        else {
        //            [img setBackgroundImage:[UIImage imageNamed:@"icon05.png"] forState:UIControlStateDisabled];
        //            [img setTitle:@"완료" forState:UIControlStateDisabled];
        //            [img setTitleColor:[UIColor blackColor] forState:UIControlStateDisabled];
        //        }
        //

//                       [UIImage imageWithContentsOfFile:filePath];
//    myImage.image = [UIImage imageNamed:@"checkmaker64.png"];
//                    DDTBT_DFCT *another = [[DDTBT_DFCT alloc] init];
    //                    [self selectDfct:another byMbilId:data.id_mbil];

    //    [text drawAtPoint:CGPointMake(0, textrect.origin.y-20 ) forWidth:textrect.origin.x withFont:font lineBreakMode:0];

점검조회 접수 건 완료 처리 관련 수정 사항
 
 
현재 현상
‘접수’ -> ‘완료’ 처리 후 해당 건을 ‘완료취소’ 하면 ‘처리’로 바뀜
  - 기존에는 처리 항목만 완료 할수 있었고 완료취소 하면 무조건 ‘처리’로 돌아갔음
 
 
 
변경내용
Local  DDTBT_DFCT  Table  컬럼추가
    CD_STAT_PREV VARCHAR(20)    ‘이전상태값
 
점검조회 및 확검에서 ‘완료’ 처리 시 현재 상태(DDTBT_DFCT.CD_HNDL_STAT) 값을 새로운 컬럼 (DDTBT_DFCT.CD_STAT_PREV) 에 저장
‘완료취소’ 할 때 DDTBT_DFCT.CD_STAT_PREV 값으로 되돌림
 
 1. 점검조회 화면 공사진행상황 아이콘 표시 확인
 
2. 사진 Tag 작업 – Local 사진 첨부 할 때 사진 비율에 따라 Tag 깨짐 현상처리
 
3. 현장선택 및 변경 관련 Processor 확인 및 안정화
 
4. 메인메뉴 표시 상태에서 메인화면 작동안되게 처리

SELECT DISTINCT A.ID_DFCT_CTYP "+
      " ,A.NM_DFCT_CTYP "+
      " ,B.CD_CPNY "+
      " ,B.NM_CPNY "+
      " FROM "+LocalDatabaseManager.TABLE_NAME_DDTBT_RGON_DFCT_CTYP +" A "+
      " INNER JOIN "+LocalDatabaseManager.TABLE_NAME_DDTBT_CPNY_NOHS_QOTA+ " B "+
      " ON  B.ID_DFCT_CTYP = A.ID_DFCT_CTYP " +
      " AND B.CD_DONG  ='%s'" +
      " AND A.ID_DFCT_CTYP  ='%s'" +
      " ORDER BY ODER_MKAR "