129

@interface statisticsTotalChecking : NSObject {}
@property   (nonatomic, strong) NSString    *cl_all;
@property   (nonatomic, strong) NSString    *cl_r;
@property   (nonatomic, strong) NSString    *cl_y;
@property   (nonatomic, strong) NSString    *cl_g;
@end


@implementation statisticsTotalChecking
@end


SqlUtils *db = [[SqlUtils alloc] init];
    
    object->listOf = [[NSMutableArray alloc] initWithCapacity:0];
    [db c828ListOfStatistics:object->listOf withDongCd:@"" ctyp:@""];
        
    object->nsm = [[NSMutableArray alloc] initWithCapacity:0];
    [db c828ListOfStatisticsTotal:object->nsm withDongCd:@"" ctyp:@""];
    statisticsTotalChecking *stc8 = [object->nsm objectAtIndex:0];
    NSLog(@"cl_all = %@",  stc8.cl_all);
    NSLog(@"cl_r = %@",  stc8.cl_r);
    NSLog(@"cl_y = %@", stc8.cl_y);
    NSLog(@"cl_g = %@", stc8.cl_g);


//      int total = 0;
//      int e = 0;
//      int b = 0;
//      int d = 0;
//
//      for(int i=0; i<[mList4calculatingStat count];i++) {
//          DFCT_LIST *data = [mList4calculatingStat objectAtIndex:i];
//          if (YES == [data.cd_hndl_stat isEqualToString:@"E"]) {
//              //            [img setTitle:@"처리" forState:UIControlStateDisabled];
//              e++;
//          }
//          else if (YES == [data.cd_hndl_stat isEqualToString:@"B"]) {
//              //            [img setTitle:@"접수" forState:UIControlStateDisabled];
//              b++;
//          }
//          else {
//              //            [img setTitle:@"완료" forState:UIControlStateDisabled];
//              d++;
//          }
//      }
//
//      total = e + b + d;
    


  SqlUtils *db = [[SqlUtils alloc] init];
    
    maxho = [[db hjhHoshMaxValue:mDongCd] intValue];
    

  if ([mListDong count] > 0) {
        DDTBT_DONG *data = [mListDong objectAtIndex:0];
        [db selectFlorrrr:mListFlor withDongCd:mDongCd isAll:mIsAll];
        [mTableViewFlor reloadData];
    }

- (NSInteger) selectCountOfMaxFloor:(NSString *)dongCd;


// 하자 상태별 건수
//    [self setDfctCount];

- (void) setDfctCount {

        // 하자 상태별 건수
//        [self setDfctCount];


    //    NSInteger cntE = 0;
    //    NSInteger cntX = 0;
    
    //    SqlUtils *db = [[SqlUtils alloc] init];
    //    cntE = [db selectDfctCount:@"E"];
    //    cntX = [db selectDfctCount:@"X"];
    //    cntX += [db selectDfctCount:@"B"];
    //
    //    [mlblStat+stics setText:[NSString stringWithFormat:@" 전체 : 0건| 접수 : 0건 | 처리 : 0건 | 완료 : 0건"]];
}

//        CGRect transformedBounds = CGRectApplyAffineTransform(mainPanel.bounds, mainPanel.transform);
    ////    mainPanel.layer.anchorPoint = CGPointMake(0.5, 0.5);
    //    mainPanel.layer.position = CGPointMake(200,200);
    ////                                           _scrollview.bounds.size.width, _scrollview.bounds.size.height);
//        [_scrollview setContentSize:transformedBounds.size];
        


//    [self->_scrollview setContentSize:CGSizeMake(1000*recognizer.scale, 1000*recognizer.scale)];
//    CGPoint pointToScaleTo = CGPointMake(0, 0); //Just enter the coordinates you
                                                //want to scale your view towards
//    CGFloat viewWidth = mainPanel.bounds.size.width;
//    CGFloat viewHeight = mainPanel.bounds.size.height;

//    CGFloat scaleFactorX = recognizer.scale;
//    CGFloat scaleFactorY = recognizer.scale;

//    CGAffineTransform scaleTransform = CGAffineTransformMakeScale(scaleFactorX, scaleFactorY);

//    [UIView animateWithDuration:0.1f delay:0.0f options:0 animations:^{
//        //I divide the x and y coordinates by the view width and height
//        //because the anchor point coordinates are normalized to the range
//        //0.0-1.0.


//        //Now that the anchor point has been changed, apply the scale transform
//        self.mainPanel.transform = scaleTransform;
//
//    } completion:^(BOOL finished) {}];

//    [self.mainPanel removeFromSuperview];
//    [self->_scrollview addSubview:self.mainPanel];
    
//    CGFloat s = recognizer.scale;
//    CGAffineTransform tr = CGAffineTransformScale(mainPanel.transform, s, s);
//
//    CGFloat h = mainPanel.frame.size.height;
//    CGFloat w = mainPanel.frame.size.width;
//
//    [UIView animateWithDuration:0.5 delay:0 options:0 animations:^{
//        self.mainPanel.transform = tr;
//        self.mainPanel.center = CGPointMake(w*s , h*s );
//        int temp = 1==1;
//        if([temp is])
//    } completion:^(BOOL finished) {}];
//

//    
//    NSInteger   id_mbil;
//    
//    
//    
//    NSString    *mode;
//    NSInteger   id_dfct;
//    NSString    *cd_site;
//    NSString    *cd_hndl_stat;
//    NSString    *cd_rcpt_phs;
//    NSString    *yn_re_rcpt;
//    NSInteger   notm_re_rcpt;
//    NSString    *dt_rcpt;
//    NSString    *id_rcpt_prsn;
//    NSString    *cd_dong;
//    NSString    *nohs;
//    NSString    *cd_loc_clsf;
//    NSString    *yn_hosh_comn;
//    NSInteger   id_loc;
//    NSInteger   id_rgon;
//    NSInteger   id_dfct_ctyp;
//    NSInteger   id_dfct_type;
//    NSInteger   id_dfct_caus;
//    NSInteger   id_dfct_cl;
//    NSString    *dfct_cnts;
//    NSString    *id_wrk_fmer_pic_atch_file;
//    NSString    *id_wrk_aftr_pic_atch_file;
//    NSString    *yn_re_clsf_rqst;
//    NSString    *id_cplt_prsn;
//    NSString    *dt_cplt;
//    NSInteger   notm_vrf_chk;
//    NSString    *dnt_rgst;
//    NSString    *id_rgst;
//    NSString    *dnt_chg;
//    NSString    *id_chg;
//    NSString    *cd_re_rcpt_resn;
//    NSString    *nm_re_rcpt_resn;
//    NSString    *yn_svr_trsm;
//    
//    NSMutableArray  *atchListFmer;
//    NSMutableArray  *atchListAftr;
//    
//    
//    //평형정보 추가하자
//    //조회용으로만...
//    NSString    *cd_tppg;
//    //공종명,원인명,구분명
//    NSString    *nm_dfct_ctyp;
//    NSString    *nm_dfct_caus;
//    NSString    *nm_dfct_cl;
//    
//    NSString    *nm_loc;
//    NSString    *nm_rgon;
//    NSString    *nm_dfct_type;
//    
//    NSString    *nm_dong;
//    
//    
//    NSInteger   search001;
//    NSInteger   search002;
//    NSInteger   search003;
//    NSString   *cd_cpny;
//    NSString    *nm_cpny;
//    
//    //nipt
//    NSString    *seq_nipt;
//    
//    
//    //    NSString    *nm_nipt;
//    //    NSString    *cnst_vrf_rqst;
//    //    NSString    *dnt_vrf_rqst;
//    //    NSString    *yn_vrf_cplt;
//    //    NSString    *dnt_vrf_cplt;
//    //    NSString    *cnts_req_vrf;

PRAGMA foreign_keys = off;

BEGIN;

ALTER TABLE "DDTBT_DFCT" RENAME TO "_DDTBT_DFCT_old";

CREATE TABLE "DDTBT_DFCT" (
   "id_mbil" number PRIMARY KEY ASC
 , "mode" varchar(2)
 , "id_dfct" number
 , "cd_site" vharchar(6)
 , "cd_hndl_stat" varchar(20)
 , "cd_rcpt_phs" varchar(20)
 , "yn_re_rcpt" varchar(1)
 , "notm_re_rcpt" varchar(6)
 , "dt_rcpt" varchar(8)
 , "id_rcpt_prsn" varchar(20)
 , "cd_dong" varchar(4)
 , "nohs" varchar(5)
 , "cd_loc_clsf" varchar(20)
 , "yn_hosh_comn" varchar(1)
 , "id_loc" number
 , "id_rgon" number
 , "id_dfct_ctyp" number
 , "id_dfct_type" number
 , "id_dfct_caus" number
 , "id_dfct_cl" number
 , "dfct_cnts" varchar(200)
 , "id_wrk_fmer_pic_atch_file" varchar(50)
 , "id_wrk_aftr_pic_atch_file" varchar(50)
 , "yn_re_clsf_rqst" varchar(1)
 , "id_cplt_prsn" varchar(20)
 , "dt_cplt" varchar(8)
 , "notm_vrf_chk" number
 , "dnt_rgst" varchar(8)
 , "id_rgst" varchar(10)
 , "dnt_chg" varchar(8)
 , "id_chg" varchar(10)
 , "cd_re_rcpt_resn" varchar(20)
 , "nm_re_rcpt_resn" varchar(200)
 , "yn_svr_trsm" varchar(1)
 , "search001" number
 , "search002" number
 , "search003" number
 , "cd_cpny" varchar(10)
 , "seq_nipt" varchar(10)
 , "yn_cmpx_ctyp" varchar(1)
 , "id_flwg_ctyp" number
 , "cnts_dfct_mgt" varchar(1000)
 , "cd_stat_prev" varchar(2)
 , "ds_hname" varchar(300)
);

INSERT INTO "DDTBT_DFCT" (
   "id_mbil"
 , "mode"
 , "id_dfct"
 , "cd_site"
 , "cd_hndl_stat"
 , "cd_rcpt_phs"
 , "yn_re_rcpt"
 , "notm_re_rcpt"
 , "dt_rcpt"
 , "id_rcpt_prsn"
 , "cd_dong"
 , "nohs"
 , "cd_loc_clsf"
 , "yn_hosh_comn"
 , "id_loc"
 , "id_rgon"
 , "id_dfct_ctyp"
 , "id_dfct_type"
 , "id_dfct_caus"
 , "id_dfct_cl"
 , "dfct_cnts"
 , "id_wrk_fmer_pic_atch_file"
 , "id_wrk_aftr_pic_atch_file"
 , "yn_re_clsf_rqst"
 , "id_cplt_prsn"
 , "dt_cplt"
 , "notm_vrf_chk"
 , "dnt_rgst"
 , "id_rgst"
 , "dnt_chg"
 , "id_chg"
 , "cd_re_rcpt_resn"
 , "nm_re_rcpt_resn"
 , "yn_svr_trsm"
 , "search001"
 , "search002"
 , "search003"
 , "cd_cpny"
 , "seq_nipt"
 , "yn_cmpx_ctyp"
 , "id_flwg_ctyp"
 , "cnts_dfct_mgt"
 , "cd_stat_prev"
)
SELECT
   "id_mbil"
 , "mode"
 , "id_dfct"
 , "cd_site"
 , "cd_hndl_stat"
 , "cd_rcpt_phs"
 , "yn_re_rcpt"
 , "notm_re_rcpt"
 , "dt_rcpt"
 , "id_rcpt_prsn"
 , "cd_dong"
 , "nohs"
 , "cd_loc_clsf"
 , "yn_hosh_comn"
 , "id_loc"
 , "id_rgon"
 , "id_dfct_ctyp"
 , "id_dfct_type"
 , "id_dfct_caus"
 , "id_dfct_cl"
 , "dfct_cnts"
 , "id_wrk_fmer_pic_atch_file"
 , "id_wrk_aftr_pic_atch_file"
 , "yn_re_clsf_rqst"
 , "id_cplt_prsn"
 , "dt_cplt"
 , "notm_vrf_chk"
 , "dnt_rgst"
 , "id_rgst"
 , "dnt_chg"
 , "id_chg"
 , "cd_re_rcpt_resn"
 , "nm_re_rcpt_resn"
 , "yn_svr_trsm"
 , "search001"
 , "search002"
 , "search003"
 , "cd_cpny"
 , "seq_nipt"
 , "yn_cmpx_ctyp"
 , "id_flwg_ctyp"
 , "cnts_dfct_mgt"
 , "cd_stat_prev"
FROM "_DDTBT_DFCT_old";

DROP TABLE "_DDTBT_DFCT_old";

COMMIT;

PRAGMA foreign_keys = ON;
try catch  모두 제
      @try {

                } @catch (NSException *exception) {
                } @finally {
                }

                if(sqlite3_column_text(compiledStatement, 27))

@try {
} @catch (NSException *exception) {
                    NSLog(@"There's no cd_cpny");
                    //                     sqlite3_finalize(compiledStatement);
                    //                    sqlite3_close(database);
                } @finally {
                }
                


                NSLog(@"edtgSelectDfct data.nm_dfct_ctyp %@", data.nm_dfct_ctyp);
                
          @try {
                              NSLog(@"ds_hname = %@", data.ds_hname);
                                       } @catch (NSException *exception) {
                                       } @finally {
                                       }
//            UITextField *resn = [alertView textFieldAtIndex:0];
    //            nm = resn.text;
    //
    //            /*
    //            NSString *sss = [cd stringByAppendingString:nm];
    //            [GlobalVar alertMsgOKWithTitle:@"mBASS" message:sss];
    //            return;
    //            */
    //
    //            SqlUtils *db = [[SqlUtils alloc] init];
    //            NSMutableArray *arr = [NSMutableArray arrayWithCapacity:0];
    //
    //            // 재접수정보 저장
    //            for (int i=0; i<[mList count]; i++) {
    //                DFCT_LIST *data = [mList objectAtIndex:i];
    //
    //                if (YES == data.isCheck && YES == [data.cd_hndl_stat isEqualToString:@"E"]) {
    //                    // 체크된거만 재접수 사유 저장
    //                    data.cd_hndl_stat = @"B";
    //
    //                    //[db updateDfct:data.id_mbil reRcptResnCd:cd nm:nm];
    //
    //                    [arr addObject:data];
    //                }
    //
    //                data.isCheck = NO;
    //            }
    //
    //            [db updateDfctArr:arr reRcptResnCd:cd nm:nm];
    //
    //            [mChkAll setSelected:NO];
    //            [self checkAllList:NO];
    //
    //            [mTableView reloadData];
    //        }
    //    }