234

            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 '%@' \

//                               where a.cd_dong = '%@' \

//                               group by a.cd_dong, a.cd_flor, a.ho \

//                               ) \

//                               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 \

//                               order by cd_flor desc, ho asc;"

//                               //                               ,dongCd, nohs,yn

//                               //                               ,mode, hndlStatCd

//                               ,ctyp

//                               ,[GlobalVar loadFromUserDefaults:@"current_cd_dong"]

//                               ];

 

select a.cd_dong, a.cd_flor, a.ho, ifnull(cl_stat, 'G') as cl_stat 

from ddtbt_hosh a
left outer join ddtbt_status b 

on b.cd_dong = a.cd_dong
and b.nohs = a.nohs
and b.id_dfct_ctyp = 0 --공종 전체일때 0 

where a.cd_dong = '0301' -- 동
order by a.cd_flor desc, a.ho, id_dfct_ctyp ; 

with t_stat as 

(
select a.cd_dong, a.cd_flor, a.ho, 

ifnull(cl_stat, 'G') as cl_stat from ddtbt_hosh a 

left outer join ddtbt_status b
on b.cd_dong = a.cd_dong
and b.nohs = a.nohs
and b.id_dfct_ctyp = 0 --공종 전체일때 0 

where a.cd_dong = '0301' -- 동 ) 

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 

 

 

—————————————————————BEGIN;

 

CREATE TABLE "DDTBT_STATUS" (

   "cd_dong" varchar(4) NOT NULL

 , "nohs" varchar(5) NOT NULL

 , "id_dfct_ctyp" INTEGER NOT NULL

 , "cl_stat" varchar(10)

 , PRIMARY KEY("cd_dong", "nohs", "id_dfct_ctyp")

);

 

COMMIT;

 

서버 명세 수신 서버 담당자에게 수신

—————————————————————

METHOD 명 ‘getstatus’ 

Parameter = cd_site 

 

다운로드 기능 삽입

—————————————————————————

 

HttpRequest *httpJob = nil; //Request 객체 지정용 인스턴스 변수 생성 = 포인터 선언

 

전송 SQL문자열을 생성

 

XMLRequest* xmlRequest = [[XMLRequest alloc]init];

            

            [xmlRequest addFetchSQL:[NSString stringWithFormat:@"<reqhead method='getstatus' id='%@'><devicespec platform='ios' line1number='' deviceid='' ver='%@' /></reqhead><reqbody><data cd_site='%@'  /></reqbody>"

                                     ,GlobalVar.globalVar.userInfo.userId

                                     ,[GlobalVar currentBundleVersion]

                                     ,[GlobalVar loadFromUserDefaults:@"udglobalCDSite"]

                                     ]];

            

 

XML 생성

            NSString* sRequestXML = [xmlRequest makeXML];

                    NSLog(@"sRequestXML:%@", sRequestXML);

            

            서버로 전송

            httpJob = [[HttpRequest alloc] initWithURL:SERVERURL timeOut:60];

응답 수신

 

            NSString* sReceivedXML = [httpJob requestUrl:sRequestXML];

 

 

 

 

@interface DDTBT_STATUS : NSObject { }

 

@property (nonatomic, strong) NSString *cd_dong;

@property (nonatomic, strong) NSString *nohs;

@property (assign) NSInteger id_dfct_ctyp;

@property (nonatomic, strong) NSString *cl_stat;

 

@end

 

 

 

 

 

 

@implementation DDTBT_STATUS

 

@synthesize cd_dong;

@synthesize nohs;

@synthesize id_dfct_ctyp;

@synthesize cl_stat;

 

- (id)init {

    if (self = [super init]) {

        self.cd_dong = @"";

        self.nohs = @"";

        self.id_dfct_ctyp = 0;

        self.cl_stat = @"";

      return self;

    }

}

 

#include <stdio.h>

 

typedef struct twoInt {

   int one;

   int two;

} twoInt;

 

int main()

{

   int array[10] = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10};

 

   for(int i=0; i<10;i++) { printf("array[i] = %d\n", i, array[i]);

}

 

or

 

twoInt *temp = (twoInt *)array;

for (int i=0; i<5; i++) {

   printf("temp = %d, %d\n", temp->one, temp->two);

    temp++ };

 

구조체, 포인터, 배열 모두 메모리 구조 생각하면 됨.