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 "