erpsuiteios/Apex Mobile/Apex Mobile/RANetwork.m

//
//  RANetwork.m
//  Apex Mobile
//
//  Created by Ray on 31/01/2018.
//  Copyright © 2018 United Software Applications, Inc. All rights reserved.
//

#import "config.h"
#import "RAUtils.h"
#import "AESCrypt.h"
#import "RANetwork.h"
#import "AppDelegate.h"
#import "RAConvertor.h"
#import "ApexMobileDB.h"

@implementation RANetwork
+(NSData*)get_json : (NSString*) url parameters:(NSMutableDictionary *) params file:(NSString *) file //delegate:(id < NSURLConnectionDelegate >)delegate
{
    
    

    params = [self prepare_addtional_params:params];
    
    return [super get_json:url parameters:params file:file err_recorder:URL_ERR_LOG result_handler:^NSMutableDictionary *(NSMutableDictionary *jsobj) {
        int result=[[jsobj valueForKey:@"result"] intValue];
        //        UIApplication * app = [UIApplication sharedApplication];
        //        AppDelegate *appDelegate = (AppDelegate *)[app delegate];
        
        switch (result) {
            case 0:
                [jsobj setValue:MSG_USERAUTH_ERROR forKey:@"err_msg"];
                break;
            case 1:
                [jsobj setValue:MSG_ERROR forKey:@"err_msg"];
                break;
            case RESULT_TRUE:
                [jsobj setValue:MSG_SUCCESS forKey:@"err_msg"];
                break;
//            case 8:
//                [jsobj setValue:[jsobj valueForKey:@"msg"] forKey:@"err_msg"];
//                break;
            case 9:
                [jsobj setValue:[jsobj valueForKey:@"msg"] forKey:@"err_msg"];
                break;
            case RESULT_TIMEOUT:
                [jsobj setValue:MSG_TIMEOUT forKey:@"err_msg"];
                break;
            default:
                [jsobj setValue:MSG_ERROR forKey:@"err_msg"];
                break;
        }
        
        
        //        if([appDelegate.build intValue]< [[jsobj valueForKey:@"min_ver"]intValue])
        //        {
        //            [jsobj setValue:@"9" forKey:@"result"];
        //            [jsobj setValue:MSG_VER_LOW forKey:@"err_msg"];
        //        }
        return jsobj;
    } decrypt_handler:^NSMutableDictionary *(NSMutableDictionary *jsobj) {
        
        NSString* base64str = jsobj[@"str"];
        NSString* decryptstr=[AESCrypt AES128Decrypt:base64str key:@"Usai2010"];
        jsobj=[[RAConvertor string2dict:decryptstr] mutableCopy];
        return jsobj;
    }];
    
    
    /*
     
     
     
     */
    return nil;
}
+(NSMutableDictionary*) prepare_addtional_params:(NSMutableDictionary* ) params
{
    
    if (params == nil) {
        params = [NSMutableDictionary dictionary];
    }
    
    AppDelegate *appDelegate = (AppDelegate*)[[UIApplication sharedApplication] delegate];
//    if(appDelegate.user!=nil && params[@"user"] == nil)
//        [params setValue:[AESCrypt AES128Encrypt:appDelegate.user key:@"Usai2010"] forKey:@"user"];
//    if(appDelegate.password!=nil&& params[@"pwd"] == nil)
//        [params setValue:[AESCrypt AES128Encrypt:appDelegate.password key:@"Usai2010"] forKey:@"pwd"];
    
    if(appDelegate.user!=nil && params[@"user"] == nil)
        [params setValue:appDelegate.user  forKey:@"user"];
    if(appDelegate.password!=nil&& params[@"pwd"] == nil)
        [params setValue:appDelegate.password  forKey:@"pwd"];
    
    [params setValue:appDelegate.build forKey:@"app_ver"];
    
    NSDictionary* infoDict =[[NSBundle mainBundle] infoDictionary];
    NSString* short_version =[infoDict objectForKey:@"CFBundleShortVersionString"];
    [params setValue:short_version forKey:@"app_short_ver"];
    
    
    
#if TARGET_IPHONE_SIMULATOR//模拟器
    [params setValue:@"simulator_uuid" forKey:@"deviceid"];
#elif TARGET_OS_IPHONE//真机
    UIDevice * dev = [UIDevice currentDevice];
    NSUUID* uuid =dev.identifierForVendor;
    [params setValue:uuid.UUIDString forKey:@"deviceid"];
#endif
    
    params[@"os"]=@"iOS";
    return params;
}

+(int) ChangePassword : (NSString*) newpass user:(NSString*) user oldpass:(NSString*) oldpass
{
    
    if(![NetworkUtils IsNetworkAvailable])
        return RESULT_NET_NOTAVAILABLE;
    
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    
    
    NSMutableDictionary * params = [[NSMutableDictionary alloc] init];
    [params setValue:user forKey:@"user"];
    [params setValue:oldpass forKey:@"oldpass"];
    [params setValue:newpass forKey:@"newpass"];
    [params setValue:@"Change Password" forKey:@"module_name"];
    [params setValue:@"handset_search" forKey:@"action"];
//    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    NSData* json=[self get_json:URL_RETRIEVE_PASS parameters:params file:nil];
    
    
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return RESULT_NET_ERROR;
    }
    
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    if(jsobj)
    {
        int result = [[jsobj valueForKey:@"result"] intValue];
        if(result== AP_SESSION_EXPIRED)
        {
            [self Authorize:appDelegate.user password:appDelegate.password];
            json=[self get_json:URL_RETRIEVE_PASS parameters:params file:nil];
            if (json==nil)
            {
                DebugLog(@"json is wrong");
                return RESULT_NET_ERROR;
            }
            jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
            result = [[jsobj valueForKey:@"result"] intValue];
            
        }
        if(result!=AP_USER_AUTH)
        {
            DebugLog(@"USER NOT AUTHORIZED CODE=%d ",result);
            return RESULT_FALSE;
            
        }
        return RESULT_TRUE;
        
    }
    return RESULT_NET_ERROR;
    
    
}
+(int) RetrievePassword : (NSString*) user  email:(NSString*) email
{
    
    if(![NetworkUtils IsNetworkAvailable])
        return RESULT_NET_NOTAVAILABLE;
    NSMutableDictionary * params = [[NSMutableDictionary alloc] init];
    [params setValue:user forKey:@"user"];
    [params setValue:email forKey:@"email"];
    [params setValue:@"Retrieve Password" forKey:@"module_name"];
    [params setValue:@"handset_search" forKey:@"action"];
    NSData* json=[self get_json:URL_RETRIEVE_PASS parameters:params  file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return RESULT_NET_ERROR;
    }
    
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    if(jsobj)
    {
        int result = [[jsobj valueForKey:@"result"] intValue];
        if(result!=AP_USER_AUTH)
        {
            DebugLog(@"USER NOT AUTHORIZED CODE=%d ",result);
            return RESULT_FALSE;
            
        }
        return RESULT_TRUE;
        
    }
    return RESULT_NET_ERROR;
    
    
}
+(int)parse_authinfo : (NSData *) json user:(NSString*) user password:(NSString*) password
{
    DebugLog(@"parse_authinfo");
    NSError *error=nil;
    
    sqlite3 *db =[ApexMobileDB get_db];
    
    
    
    
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    if(jsobj)
    {
        
        UIApplication * app = [UIApplication sharedApplication];
        AppDelegate *appDelegate = (AppDelegate *)[app delegate];
        int result = [[jsobj valueForKey:@"result"] intValue];
        if(result!=AP_USER_AUTH)
        {
            DebugLog(@"USER NOT AUTHORIZED CODE=%d ",result);
            [appDelegate Logout];
            return RESULT_FALSE;
            
        }
        NSDictionary* objheader = [jsobj objectForKey:@"header"];
        
        NSString* required_ver=[objheader objectForKey:@"client_ver"] ;
        DebugLog(@"required_ver=%@ ",required_ver);
        NSDictionary* infoDict =[[NSBundle mainBundle] infoDictionary];
        NSString* versionNum =[infoDict valueForKey:@"CFBundleVersion"];
        versionNum = [NSString stringWithFormat:@"A%@",versionNum];
        int ibadge = [[objheader valueForKey:@"badge"] intValue];
        
        //        if([ibadge isEqual:[NSNull null]])
        //            strbadge=@"0";
        //        if(ibadge==nil)
        //            ibadge=@"0";
        //        if([strbadge isEqualToString:@"null"])
        //            strbadge=@"0";
        app.applicationIconBadgeNumber = ibadge;//[strbadge intValue];
        
        BOOL bigger = [versionNum compare:required_ver] ;
        if(!bigger)
            return RESULT_VER_LOW;
//        appDelegate.sessionid = [objheader valueForKey:@"sessionid"];
        appDelegate.user = user;
        appDelegate.password = password;
//        DebugLog(@"sessionid=%@ ",appDelegate.sessionid);
        if ([[objheader valueForKey:@"update"] boolValue]==false)
        {
            // no update on the server;
            return RESULT_TRUE;
        }
        int Auth_InfoVer = [[objheader valueForKey:@"ver"] intValue];
//        NSUserDefaults *defaults =[NSUserDefaults standardUserDefaults];
//        [defaults removeObjectForKey:[NSString stringWithFormat:@"%@_Auth_InfoVer",user]];
//        [defaults setInteger:Auth_InfoVer forKey:[NSString stringWithFormat:@"%@_Auth_InfoVer",user]];
        
        [ApexMobileDB execSql:@"delete from auth_ver;" db:db];
        [ApexMobileDB execSql:[NSString stringWithFormat:@"insert into auth_ver (ver) values (%d);",Auth_InfoVer] db:db];
        
        //        [defaults synchronize];
        
        NSDictionary* objfuncs = [jsobj objectForKey:@"functions"];
        NSArray* keys= [objfuncs allKeys];
        
        
        
        [ApexMobileDB execSql: [NSString stringWithFormat: @"update fields_info set abandon = 1 where user ='%@'",user] db:db];
        [ApexMobileDB execSql: [NSString stringWithFormat: @"update actions_info set abandon = 1 where user ='%@'",user] db:db];
        char* sql = "insert into fields_info(name,aname,field_type,function_name,behavior,priority,show,user) values(?,?,?,?,?,?,?,?)";
        char* sql1 = "insert into actions_info(name,function_name,user,priority) values(?,?,?,?)";
        
        sqlite3_stmt *stmt;
        sqlite3_stmt *stmt1;
        sqlite3_prepare_v2(db, sql, -1, &stmt, nil);
        sqlite3_prepare_v2(db, sql1, -1, &stmt1, nil);
        
        // db.beginTransaction();
        for(int i=0;i<keys.count;i++)
        {
            NSString* func_name = keys[i];
            NSDictionary *objfun = [objfuncs objectForKey:func_name];
            int behavior, priority = 999;
            int show =1;
            NSDictionary *objbehavior = [objfun objectForKey:@"search"];
            NSArray* keysbehavior= [objbehavior allKeys];
            behavior = BEHAVIOR_SEARCH;
            for(int j=0;j<keysbehavior.count;j++)
            {
                NSString* field = keysbehavior[j];
                NSDictionary* field_info = [objbehavior objectForKey:field];
                NSString* field_name =[field_info valueForKey:@"name"] ;
                NSString* field_type = [field_info valueForKey:@"type"] ;
                NSString* alias_name = [field_info valueForKey:@"alias"] ;
                priority = [[field_info valueForKey:@"priority"] intValue];
                if(priority==999)
                    show=0;
                else
                    show=1;
                int id = [ApexMobileDB get_recordid:db table:@"fields_info" where:[NSString stringWithFormat:@"name='%@' and behavior=%d and function_name='%@' and user='%@'",field_name,behavior,func_name,user]];
                if(id>=0)
                    [ApexMobileDB execSql:[NSString stringWithFormat:@"update fields_info set abandon = 0 where _id=%d",id] db:db];
                else
                {
                    
                    sqlite3_bind_text(stmt, 1, [field_name UTF8String], -1, NULL);
                    sqlite3_bind_text(stmt, 2, [alias_name UTF8String], -1, NULL);
                    sqlite3_bind_text(stmt, 3, [field_type UTF8String], -1, NULL);
                    
                    sqlite3_bind_text(stmt, 4, [func_name UTF8String], -1, NULL);
                    
                    sqlite3_bind_int(stmt, 5, behavior);
                    sqlite3_bind_int(stmt, 6, priority);
                    sqlite3_bind_int(stmt, 7, show);
                    sqlite3_bind_text(stmt, 8, [user UTF8String], -1, NULL);
                    
                    
                    if (sqlite3_step(stmt) != SQLITE_DONE)
                    {
                        fprintf(stderr, "Error: insert search failed, error infomation: %s\n", sqlite3_errmsg(db));
                    }
                    sqlite3_reset(stmt);
                    
                }
                
                
            }
            
            objbehavior = [objfun objectForKey:@"result"];
            NSArray* keysresult= [objbehavior allKeys];
            behavior = BEHAVIOR_RESULT;
            for(int j=0;j<keysresult.count;j++)
            {
                NSString* field = keysresult[j];
                NSDictionary* field_info = [objbehavior objectForKey:field];
                NSString* field_name =[field_info valueForKey:@"name"] ;
                NSString* field_type = [field_info valueForKey:@"type"] ;
                NSString* alias_name = [field_info valueForKey:@"alias"] ;
                priority = [[field_info valueForKey:@"priority"] intValue];
                if(priority==999)
                    show=0;
                else
                    show=1;
                int id = [ApexMobileDB get_recordid:db table:@"fields_info" where:[NSString stringWithFormat:@"name='%@' and behavior=%d and function_name='%@' and user='%@'",field_name,behavior,func_name,user]];
                if(id>=0)
                    [ApexMobileDB execSql:[NSString stringWithFormat:@"update fields_info set abandon = 0 where _id=%d",id] db:db];
                else
                {
                    sqlite3_bind_text(stmt, 1, [field_name UTF8String], -1, NULL);
                    sqlite3_bind_text(stmt, 2, [alias_name UTF8String], -1, NULL);
                    sqlite3_bind_text(stmt, 3, [field_type UTF8String], -1, NULL);
                    sqlite3_bind_text(stmt, 4, [func_name UTF8String], -1, NULL);
                    sqlite3_bind_int(stmt, 5, behavior);
                    sqlite3_bind_int(stmt, 6, priority);
                    sqlite3_bind_int(stmt, 7, show);
                    sqlite3_bind_text(stmt, 8, [user UTF8String], -1, NULL);
                    
                    if (sqlite3_step(stmt) != SQLITE_DONE)
                    {
                        fprintf(stderr, "Error: insert result failed, error infomation: %s\n", sqlite3_errmsg(db));
                    }
                    sqlite3_reset(stmt);
                    
                }
            }
            objbehavior = [objfun objectForKey:@"actions"];
            NSArray* keysactions= [objbehavior allKeys];
            behavior = BEHAVIOR_SEARCH;
            for(int j=0;j<keysactions.count;j++)
            {
                NSString* actionname = keysactions[j];
                int action_priority = [[objbehavior valueForKey:actionname] intValue];
                int id = [ApexMobileDB get_recordid:db table:@"actions_info" where:[NSString stringWithFormat:@"name='%@' and function_name='%@' and user='%@'",actionname,func_name,user]];
                if(id>=0)
                    [ApexMobileDB execSql:[NSString stringWithFormat:@"update actions_info set abandon = 0 , priority=%d where _id=%d",action_priority,id] db:db];
                else
                {
                    
                    sqlite3_bind_text(stmt1, 1, [actionname UTF8String], -1, NULL);
                    sqlite3_bind_text(stmt1, 2, [func_name UTF8String], -1, NULL);
                    sqlite3_bind_text(stmt1, 3, [user UTF8String], -1, NULL);
                    sqlite3_bind_int(stmt1, 4, action_priority);
                    
                    if (sqlite3_step(stmt1) != SQLITE_DONE)
                    {
                        fprintf(stderr, "Error: insert action_info failed, error infomation: %s\n", sqlite3_errmsg(db));
                    }
                    sqlite3_reset(stmt1);
                }
            }
        }
        [ApexMobileDB execSql:@"delete from fields_info where abandon = 1" db:db];
        [ApexMobileDB execSql:@"delete from actions_info where abandon = 1" db:db];
        
        sqlite3_finalize(stmt);
        sqlite3_finalize(stmt1);
        sqlite3_close(db);
        
        [ApexMobileDB deleteResultFields];
        [ApexMobileDB updateResultDisplayFields];
        /*
         
         db.setTransactionSuccessful();
         db.endTransaction();
         */
        return RESULT_TRUE;
        
    }
    //    NSDictionary *weatherInfo = [jsobj objectForKey:@"weatherinfo"];
    //    txtView.text = [NSString stringWithFormat:@"今天是 %@  %@  %@  的天气状况是：%@  %@ ",[weatherInfo objectForKey:@"date_y"],[weatherInfo objectForKey:@"week"],[weatherInfo objectForKey:@"city"], [weatherInfo objectForKey:@"weather1"], [weatherInfo objectForKey:@"temp1"]];
    //      DebugLog(@"weatherInfo字典里面的内容为--》%@", weatherDic );
    
    
    
    return RESULT_USERAUTH_ERROR;
}
+(DetailContent*) get_detailcontent: (NSMutableDictionary *) params
{
    DebugLog(@"get_detailcontent");
    DetailContent * detailContent = [[DetailContent alloc] init];
    NSMutableArray* segments = [[NSMutableArray alloc] init];
    detailContent.segments = segments;
    if(![NetworkUtils IsNetworkAvailable])
    {
        detailContent.result_code = RESULT_NET_NOTAVAILABLE;
        return detailContent;
    }
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
        [params setValue:@"handset_search" forKey:@"action"];
//    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    NSData* json=[self get_json:URL_REQUEST_RECORDS parameters:params file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        detailContent.result_code = RESULT_NET_ERROR;
        return detailContent;
    }
    
    
    //------------hack detail html 字体大小-----------
    NSString *str = [[NSString alloc] initWithData:json encoding:NSUTF8StringEncoding];
    

    
    str=[str stringByReplacingOccurrencesOfString:@"<table " withString:@"<table style=font-size:12px "];
    
    
        DebugLog(@"hack string: %@",str);
    //------- hack-----------
    NSDictionary *jsobj=[RAConvertor string2dict:str];
    
    
    NSError *error=nil;
//    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
//
//
    if(jsobj)
    {
        int result = [[jsobj valueForKey:@"result"] intValue];
        if(result== AP_SESSION_EXPIRED)
        {
            [self Authorize:appDelegate.user password:appDelegate.password];
            json=[self get_json:URL_REQUEST_RECORDS parameters:params  file:nil];
            if (json==nil)
            {
                DebugLog(@"json is wrong");
                detailContent.result_code = RESULT_NET_ERROR;
                return detailContent;
            }
            jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
            result = [[jsobj valueForKey:@"result"] intValue];
            
        }
        if(result!=AP_USER_AUTH)
        {
            DebugLog(@"USER NOT AUTHORIZED CODE=%d ",result);
            detailContent.result_code = result;
            return detailContent;
            
        }
        
        
//        if([params[@"action_type"] isEqualToString:@"Tracking"])
//        {
//            NSString *path = [[NSBundle mainBundle] pathForResource:@"fake_tracking.json" ofType:nil];
//            NSData *data = [[NSData alloc] initWithContentsOfFile:path];
//            NSDictionary *json = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingMutableLeaves error:nil];
//            jsobj = json;
//        }
        
        int count =[[jsobj valueForKey:@"count"] intValue];
        
//        if ([[params objectForKey:@"action_type"] isEqualToString:@"Detail"]) {
//            NSMutableDictionary *mJson = [jsobj mutableCopy];
//            NSDictionary *comm = @{
//                                   @"_name": @"Communication",
//                                   @"_type": @"communication",
//                                   @"cc": @"",
//                                   @"receipt": @"",
//                                   @"count": @2,
//                                   @"item0": @{
//                                           @"Sender": @"user name",
//                                           @"msg": @"content bla bla bla...",
//                                           @"mst_time": @"04/28/2018 20:15:33",
//                                           @"email_url": @"https://www.baidu.com"
//                                           },
//                                   @"item1": @{
//                                           @"Sender": @"user name",
//                                           @"msg": @"content bla bla bla...",
//                                           @"mst_time": @"04/28/2018 20:15:33"
//                                           }
//                                   };
//            [mJson setObject:comm forKey:[NSString stringWithFormat:@"group%d",count]];
//
//            [mJson setObject:@(++count) forKey:@"count"];
//
//            jsobj = mJson;
//        }
        
        detailContent.result_code = RESULT_TRUE;
        if(count==0)
        {
            
            return detailContent;
        }
        
        for(int i=0;i<count;i++)
        {
            
            NSDictionary* segment = [jsobj objectForKey:[NSString stringWithFormat:@"group%d",i]];
            [segments addObject:segment];
            
            /*
             JSONObject groupobj = jsonObj.getJSONObject("group" + i);
             View v = inflater.inflate(R.layout.group_tag, null);
             v.setOnClickListener(this);
             
             TextView tvgroup = (TextView) v.findViewById(R.id.tv_group);
             String group_name = groupobj.getString("_name");
             tvgroup.setText(group_name);
             v.setId(commonUtil.generateViewId());
             ll_root.addView(v);
             String grouptype = groupobj.getString("_type");
             
             */
        }
        
        //   NSDictionary* objrecords = [jsobj objectForKey:@"records"];
        
        detailContent.originContent = jsobj;
        
        return detailContent;
        
    }
    return nil;
    
}
+(PageData*) get_pagedata: (NSMutableDictionary *) params
{
    
    DebugLog(@"get_pagedata");
    if(![NetworkUtils IsNetworkAvailable])
        return nil;
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    [params setValue:@"handset_search" forKey:@"action"];
//    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    NSData* json=[self get_json:URL_REQUEST_RECORDS parameters:params  file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return nil;
    }
    
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    if(jsobj)
    {
        int result = [[jsobj valueForKey:@"result"] intValue];
        if(result== AP_SESSION_EXPIRED)
        {
            [self Authorize:appDelegate.user password:appDelegate.password];
            json=[self get_json:URL_REQUEST_RECORDS parameters:params file:nil];
            if (json==nil)
            {
                DebugLog(@"json is wrong");
                return nil;
            }
            jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
            result = [[jsobj valueForKey:@"result"] intValue];
            
        }
        if(result!=AP_USER_AUTH)
        {
            DebugLog(@"USER NOT AUTHORIZED CODE=%d ",result);
            return nil;
            
        }
        
        NSDictionary* objrecords = [jsobj objectForKey:@"records"];
        
        PageData * pageData = [[PageData alloc] initWithRecords:objrecords];
        return pageData;
        
    }
    return nil;
    
}
+(int) get_recordcount: (NSMutableDictionary *) params// delegate:(id < NSURLConnectionDelegate >)delegate
{
    DebugLog(@"get_recordcount");
    if(![NetworkUtils IsNetworkAvailable])
        return RESULT_NET_NOTAVAILABLE;
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    [params setValue:@"handset_search_count" forKey:@"action"];
//    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    
    NSData* json=[self get_json:URL_REQUEST_COUNT parameters:params file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return RESULT_NET_ERROR;
    }
    
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    if(jsobj)
    {
        int result = [[jsobj valueForKey:@"result"] intValue];
        if(result== AP_SESSION_EXPIRED)
        {
            [self Authorize:appDelegate.user password:appDelegate.password];
            json=[self get_json:URL_REQUEST_COUNT parameters:params file:nil];
            if (json==nil)
            {
                DebugLog(@"json is wrong");
                return RESULT_NET_ERROR;
            }
            jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
            result = [[jsobj valueForKey:@"result"] intValue];
            
        }
        if(result!=AP_USER_AUTH)
        {
            DebugLog(@"USER NOT AUTHORIZED CODE=%d ",result);
            return RESULT_USERAUTH_ERROR;
            
        }
        else
            return [[jsobj valueForKey:@"count" ] intValue];
    }
    
    return RESULT_ERROR;
}
//+(bool) IsHostAvailable : (NSString*) url
//{
//    Reachability *r = [Reachability reachabilityWithHostName:url];
//    int i = [r currentReachabilityStatus];
//    if ([r currentReachabilityStatus]==NotReachable)
//        return false;
//    return true;
//}
+(bool) IsNetworkAvailable
{
    
    if (([Reachability reachabilityForInternetConnection].currentReachabilityStatus == NotReachable) &&
        ([Reachability reachabilityForLocalWiFi].currentReachabilityStatus == NotReachable))
        return false;
    return true;
}

+(void)post_without_return : (NSString*) url parameters:(NSMutableDictionary *) params //delegate:(id < NSURLConnectionDelegate >)delegate
{
    
    
    params = [self prepare_addtional_params:params];
    
//    [self get_json:url parameters:params file:nil err_recorder:nil result_handler:nil decrypt_handler:nil];
    
//    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    //分界线的标识符
    NSString *TWITTERFON_FORM_BOUNDARY = @"AaB03x";
    //根据url初始化request
    NSMutableURLRequest* request = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:url]
                                                           cachePolicy:NSURLRequestReloadIgnoringLocalCacheData
                                                       timeoutInterval:30];
    //分界线 --AaB03x
    NSString *MPboundary=[[NSString alloc]initWithFormat:@"--%@",TWITTERFON_FORM_BOUNDARY];
    //结束符 AaB03x--
    NSString *endMPboundary=[[NSString alloc]initWithFormat:@"%@--",MPboundary];
    //要上传的图片
    //    UIImage *image=[params objectForKey:@"pic"];
    //得到图片的data
    //    NSData* data = UIImagePNGRepresentation(image);
    //http body的字符串
    NSMutableString *body=[[NSMutableString alloc]init];

    //    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    //     [params setValue:@"handset_login" forKey:@"action"];
    //    [headers setValue:[NSString stringWithFormat:@"%d",dataLength] forKey:@"Content-Length"];

//    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    //   [params setValue:password forKey:@"password"];
    //    [params setValue:[NSString stringWithFormat:@"%d",ver]  forKey:@"auth_ver"];



    //    [headers setValue:headQuerlString forKey:@"param"];

    //参数的集合的所有key的集合
    NSArray *keys= [params allKeys];
    DebugLog(@"================parms==================");
    //遍历keys
    for(int i=0;i<[keys count];i++)
    {
        //得到当前key
        NSString *key=[keys objectAtIndex:i];
        //如果key不是pic，说明value是字符类型，比如name：Boris
        if(![key isEqualToString:@"pic"])
        {
            //添加分界线，换行
            [body appendFormat:@"%@\r\n",MPboundary];
            //添加字段名称，换2行
            [body appendFormat:@"Content-Disposition: form-data; name=\"%@\"\r\n\r\n",key];
            //添加字段的值
            [body appendFormat:@"%@\r\n",[params objectForKey:key]];
            DebugLog(@"parameter: key=%@   value=%@",key,[params objectForKey:key]);
        }
    }
    DebugLog(@"================parms==================");
    ////添加分界线，换行
    [body appendFormat:@"%@\r\n",MPboundary];
    //声明pic字段，文件名为boris.png
    [body appendFormat:@"Content-Disposition: form-data; name=\"pic\"; filename=\"boris.png\"\r\n"];
    //声明上传文件的格式
    [body appendFormat:@"Content-Type: image/png\r\n\r\n"];

    //声明结束符：--AaB03x--
    NSString *end=[[NSString alloc]initWithFormat:@"\r\n%@",endMPboundary];
    //声明myRequestData，用来放入http body
    NSMutableData *myRequestData=[NSMutableData data];
    //将body字符串转化为UTF8格式的二进制
    [myRequestData appendData:[body dataUsingEncoding:NSUTF8StringEncoding]];
    //将image的data加入
    //    [myRequestData appendData:data];
    //加入结束符--AaB03x--
    [myRequestData appendData:[end dataUsingEncoding:NSUTF8StringEncoding]];

    //设置HTTPHeader中Content-Type的值
    NSString *content=[[NSString alloc]initWithFormat:@"multipart/form-data; boundary=%@",TWITTERFON_FORM_BOUNDARY];
    //设置HTTPHeader
    [request setValue:content forHTTPHeaderField:@"Content-Type"];
    //设置Content-Length
    [request setValue:[NSString stringWithFormat:@"%lu", (unsigned long)[myRequestData length]] forHTTPHeaderField:@"Content-Length"];
    //设置http body
    [request setHTTPBody:myRequestData];
    //http method
    [request setHTTPMethod:@"POST"];


//    NSHTTPURLResponse* urlResponse = nil;
//
//    NSError *error = [[NSError alloc] init];
//
    [NSURLConnection sendAsynchronousRequest:request queue:nil completionHandler:^(NSURLResponse *response,NSData *data,NSError *error){}];
    //    NSURLConnection *connection = [[NSURLConnection alloc]initWithRequest:request delegate:nil];
    
    
    
}


+(NSData*)get_marketnews : (NSString*) id limit: (int) limit
{
    if(![NetworkUtils IsNetworkAvailable])
        return nil;//RESULT_NET_NOTAVAILABLE;
    
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    [params setValue:@"Market News" forKey:@"module_name"];
    [params setValue:@"search" forKey:@"action_type"];
    [params setValue:id forKey:@"id"];
    [params setValue:[NSString stringWithFormat:@"%d",limit ] forKey:@"limit"];
    
    NSData* json=[self get_json:URL_ANNOUNCEMENTS parameters:params file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return nil;
    }
    return json;
    
    
    
}
+(NSData*)get_MessageDetail: (int) offset limit:(int) limit from:(NSString*) sid to:(NSString*) eid
{
    if(![NetworkUtils IsNetworkAvailable])
        return nil;//RESULT_NET_NOTAVAILABLE;
    
    
    
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    
    //    NSString* sess
    
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    [params setValue:@"Pull Message" forKey:@"module_name"];
    [params setValue:@"handset_search" forKey:@"action"];
    [params setValue:sid forKey:@"s_id"];
    [params setValue:eid forKey:@"e_id"];
    [params setValue:@"detail" forKey:@"action_type"];
    [params setValue:@"handset_search" forKey:@"action"];
//    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    [params setValue:appDelegate.duid forKey:@"uuid"];
    
    
    
    [params setValue:[NSString stringWithFormat:@"%d",offset] forKey:@"offset"];
    [params setValue:[NSString stringWithFormat:@"%d",limit] forKey:@"limit"];
    //    [params setValue:@"20" forKey:@"limit"];
    
    NSData* json=[self get_json:URL_PUSH parameters:params file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return nil;
    }
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    int result = [[jsobj valueForKey:@"result" ] intValue] ;
    if(result== AP_SESSION_EXPIRED)
    {
        [self Authorize:appDelegate.user password:appDelegate.password];
        json=[self get_json:URL_PUSH parameters:params file:nil];
        if (json==nil)
        {
            DebugLog(@"json is wrong");
            return nil;
        }
        jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
        result = [[jsobj valueForKey:@"result"] intValue];
        
    }
    if(result!= AP_MESSAGE_NEW)
        return nil;
    
    
    return json;
    
}
+(int) delAllMessage:(NSString*) before
{
    if(![NetworkUtils IsNetworkAvailable])
        return RESULT_NET_NOTAVAILABLE;//RESULT_NET_NOTAVAILABLE;
    
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    
    //    NSString* sess
    
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    [params setValue:@"Pull Message" forKey:@"module_name"];
    [params setValue:@"read_all" forKey:@"action_type"];
    [params setValue:@"handset_search" forKey:@"action"];
    //    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    [params setValue:appDelegate.duid forKey:@"uuid"];
    [params setValue:before forKey:@"id"];
    
    
    NSData* json=[self get_json:URL_PUSH parameters:params file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return RESULT_NET_ERROR;
    }
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    int result = [[jsobj valueForKey:@"result" ] intValue] ;
    if(result== AP_SESSION_EXPIRED)
    {
        [self Authorize:appDelegate.user password:appDelegate.password];
        json=[self get_json:URL_PUSH parameters:params file:nil];
        if (json==nil)
        {
            DebugLog(@"json is wrong");
            return RESULT_NET_ERROR;
        }
        jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
        result = [[jsobj valueForKey:@"result"] intValue];
        
    }
    return result;
    
    
}
+(NSData*)pull_message: (int) offset
{
    if(![NetworkUtils IsNetworkAvailable])
        return nil;//RESULT_NET_NOTAVAILABLE;
    
    
    
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    
    //    NSString* sess
    
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    [params setValue:@"Pull Message" forKey:@"module_name"];
    [params setValue:@"ios_list" forKey:@"action_type"];
    [params setValue:@"handset_search" forKey:@"action"];
//    [params setValue:appDelegate.sessionid forKey:@"sessionid"];
    [params setValue:appDelegate.duid forKey:@"uuid"];
    [params setValue:[NSString stringWithFormat:@"%d",offset] forKey:@"offset"];
    [params setValue:@"20" forKey:@"limit"];
    
    NSData* json=[self get_json:URL_PUSH parameters:params file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return nil;
    }
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    int result = [[jsobj valueForKey:@"result" ] intValue] ;
    if(result== AP_SESSION_EXPIRED)
    {
        [self Authorize:appDelegate.user password:appDelegate.password];
        json=[self get_json:URL_PUSH parameters:params file:nil];
        if (json==nil)
        {
            DebugLog(@"json is wrong");
            return nil;
        }
        jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
        result = [[jsobj valueForKey:@"result"] intValue];
        
    }
    if(result!= AP_MESSAGE_NEW)
        return nil;
    
    
    return json;
    
}
+(NSDictionary*) RequestServiceLocation
{
    if(![NetworkUtils IsNetworkAvailable])
        return false;//RESULT_NET_NOTAVAILABLE;
    
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    [params setValue:@"Location" forKey:@"module_name"];
    [params setValue:@"search" forKey:@"action_type"];
    [params setValue:@"999" forKey:@"limit"];
    
    NSData* json=[self get_json:URL_LOCATIONS parameters:params file:nil];
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }
    
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    
    
    NSString* path = [[RAUtils appCacheDirectory] stringByAppendingPathComponent:@"service_location.json"];
    if(jsobj!=nil&&[jsobj[@"result"] intValue]!=RESULT_NET_ERROR&&[jsobj[@"result"] intValue]!=RESULT_NET_NOTAVAILABLE)
    {
        
        [jsobj writeToFile:path atomically:YES];
//        return ret;
    }
    
    return jsobj;
    
   
    
}
+(bool) UpdateServiceLocation
{
    if(![NetworkUtils IsNetworkAvailable])
        return false;//RESULT_NET_NOTAVAILABLE;
    
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    [params setValue:@"Location" forKey:@"module_name"];
    [params setValue:@"search" forKey:@"action_type"];
    [params setValue:@"999" forKey:@"limit"];
    
    NSData* json=[self get_json:URL_LOCATIONS parameters:params file:nil];
    if (json==nil)
        return false;
    
    NSError *error=nil;
    NSDictionary *jsobj = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:&error];
    NSString* remote_ver = [jsobj valueForKey:@"version"] ;
    NSUserDefaults *defaults =[NSUserDefaults standardUserDefaults];
    
    NSString *local_ver =[defaults stringForKey:@"location_ver"];
    int total = [[jsobj valueForKey:@"total"] intValue];
    
    BOOL bigger = [remote_ver compare:local_ver];
//    if(!bigger)
//        return false;
    
    
    sqlite3 *db =[ApexMobileDB get_db];
    [ApexMobileDB execSql:@"delete from locations" db:db];
    
    char* sql = "insert into locations(area,company,city,longitude,latitude,address,telephone,fax,contact,email) values(?,?,?,?,?,?,?,?,?,?)";
    sqlite3_stmt *stmt;
    
    sqlite3_prepare_v2(db, sql, -1, &stmt, nil);
    
    NSDictionary* objrecords = [jsobj objectForKey:@"records"];
    
    for(int i=0;i<total;i++)
    {
        
        NSDictionary* objlocation = [objrecords objectForKey:[NSString stringWithFormat:@"record%d",i]];
        NSString* area = [objlocation valueForKey:@"area"];
        NSString* company = [objlocation valueForKey:@"company"];
        NSString* city = [objlocation valueForKey:@"city"];
        NSString*  longitude = [objlocation valueForKey:@"longitude"] ;
        NSString*  latitude = [objlocation valueForKey:@"latitude"] ;
        NSString* address = [objlocation valueForKey:@"address"];
        NSString* telephone = [objlocation valueForKey:@"telephone"];
        NSString* fax = [objlocation valueForKey:@"fax"];
        NSString* contact = [objlocation valueForKey:@"contact"];
        NSString* email = [objlocation valueForKey:@"email"];
        
        
        if([area isEqual:[NSNull null]])
            area=@"";
        if(area==nil)
            area=@"";
        if([area isEqualToString:@"null"])
            area=@"";
        
        
        if([company isEqual:[NSNull null]])
            company=@"";
        if(company==nil)
            company=@"";
        if([company isEqualToString:@"null"])
            company=@"";
        
        if([city isEqual:[NSNull null]])
            city=@"";
        if(city==nil)
            city=@"";
        if([city isEqualToString:@"null"])
            city=@"";
        
        if([longitude isEqual:[NSNull null]])
            longitude=@"";
        if(longitude==nil)
            longitude=@"";
        if([longitude isEqualToString:@"null"])
            longitude=@"";
        
        if([latitude isEqual:[NSNull null]])
            latitude=@"";
        if(latitude==nil)
            latitude=@"";
        if([latitude isEqualToString:@"null"])
            latitude=@"";
        
        if([address isEqual:[NSNull null]])
            address=@"";
        if(address==nil)
            address=@"";
        if([address isEqualToString:@"null"])
            address=@"";
        
        if([telephone isEqual:[NSNull null]])
            telephone=@"";
        if(telephone==nil)
            telephone=@"";
        if([telephone isEqualToString:@"null"])
            telephone=@"";
        
        if([fax isEqual:[NSNull null]])
            fax=@"";
        if(fax==nil)
            fax=@"";
        if([fax isEqualToString:@"null"])
            fax=@"";
        
        if([contact isEqual:[NSNull null]])
            contact=@"";
        if(contact==nil)
            contact=@"";
        if([contact isEqualToString:@"null"])
            contact=@"";
        
        if([email isEqual:[NSNull null]])
            email=@"";
        if(email==nil)
            email=@"";
        if([email isEqualToString:@"null"])
            email=@"";
        
        sqlite3_bind_text(stmt, 1, [area UTF8String], -1, NULL);
        sqlite3_bind_text(stmt, 2, [company UTF8String], -1, NULL);
        sqlite3_bind_text(stmt, 3, [city UTF8String], -1, NULL);
        sqlite3_bind_text(stmt, 4, [longitude UTF8String], -1, NULL);
        
        sqlite3_bind_text(stmt, 5, [latitude UTF8String], -1, NULL);
        
        
        
        sqlite3_bind_text(stmt, 6, [address UTF8String], -1, NULL);
        sqlite3_bind_text(stmt, 7, [telephone UTF8String], -1, NULL);
        sqlite3_bind_text(stmt, 8, [fax UTF8String], -1, NULL);
        sqlite3_bind_text(stmt, 9, [contact UTF8String], -1, NULL);
        sqlite3_bind_text(stmt, 10, [email UTF8String], -1, NULL);
        if (sqlite3_step(stmt) != SQLITE_DONE)
        {
            
            fprintf(stderr, "Error: insert search failed, error infomation: %s\nsql:%s\n", sqlite3_errmsg(db),sqlite3_sql(stmt));
        }
        sqlite3_reset(stmt);
        
    }
    
    sqlite3_finalize(stmt);
    
    sqlite3_close(db);
    
    [defaults removeObjectForKey:@"location_ver"];
    [defaults setValue:remote_ver forKey:@"location_ver"];
//    [defaults synchronize];
    return true;
    
}
//+(void) testmail1:(UIViewController*) caller
//{
//    MFMailComposeViewController *mail=[[MFMailComposeViewController alloc] init];
//    mail.mailComposeDelegate=caller;
//
//    //设置主题
//    [mail setSubject:@"测试发送电子邮件"];
//
//    //添加收件人
//    NSArray *toRecipients=[NSArray arrayWithObject:@"admin@163.com"];
//    [mail setToRecipients:toRecipients];
//    //添加抄送;
//    NSArray *ccRecipients=[NSArray arrayWithObjects:@"test1@163.com",@"test@qq.com", nil];
//    [mail setCcRecipients:ccRecipients];
//    //添加密送
//    NSArray *bccRecipients=[NSArray arrayWithObject:@"admin@gmail.com"];
//    [mail setBccRecipients:bccRecipients];
//
//
//    //添加一张图片
//    UIImage *addPic=[UIImage imageNamed:@"bg_3"];
//    NSData *imageData=UIImagePNGRepresentation(addPic);
//    [mail addAttachmentData:imageData mimeType:@"image/png" fileName:@"icon"];
//
//    //添加一个xml附件
////    NSString *file=[self fullBundlePathFromRelativePath:@"model.xml"];
////    NSData *xmldata=[NSData dataWithContentsOfFile:file];
////    [mail addAttachmentData:xmldata mimeType:@"" fileName:@"model"];
//
//    NSString *emailBody=@"<font color='red'>send test email</font>";
//    [mail setMessageBody:emailBody isHTML:YES];
//    [caller presentViewController:mail animated:YES completion:nil];
//
//
//}
//+(void) testmail
//{
//    NSMutableString *buffer=
//    [NSMutableString stringWithString:
//     @"<HTML><HEAD><TITLE>PAGE</TITLE></HEAD><BODY>example<img src=\"data:image/png;base64,\/9j\/4AAQSkZJRgABAQAAAQABAAD\/\/gA+Q1JFQVRPUjogZ2QtanBlZyB2MS4wICh1c2luZyBJSkcgSlBFRyB2NjIpLCBkZWZhdWx0IHF1YWxpdHkK\/9sAQwAIBgYHBgUIBwcHCQkICgwUDQwLCwwZEhMPFB0aHx4dGhwcICQuJyAiLCMcHCg3KSwwMTQ0NB8nOT04MjwuMzQy\/9sAQwEJCQkMCwwYDQ0YMiEcITIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIy\/8AAEQgAZABkAwEiAAIRAQMRAf\/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC\/\/EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29\/j5+v\/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC\/\/EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29\/j5+v\/aAAwDAQACEQMRAD8A9JK81JGKQ9acnWkxonjXpV+2TJFU4x0q9AcVIy6yDZXNeI9WGi2qz\/ZZrlnfascQyfc\/SukLfLXD+K7bVrvVIfseovaW0ajcqMFLknnkn0q6cOd8rdgUlFptXXYn8L+JLfxJHO0ULwvC4Vo3IJweh\/n+VdWigJXm3hrR7vSfF891E0QsbnKlGmDPzyD78\/zr0lT8tZq+zOjFRpKd6T0aT9PIqXKcms+QVpzc1nyjmrOYxpByeahYVM7DcR3qFjTIOs8JjGly\/wDXc\/8AoK0UeEiTpc2R0nOP++VooKRkE81Wv9VstJtGu76dIYV4LN3PoPU1M5wa5Dxxpj6hFp0u\/wDdW85Z1IyDkYB\/P+dKTsrjirux0mleMNC1YSfZNQjbyl3vvBTC+vzAcVrQ6\/pnkCZbtGj9V5\/SvGbmGO3ltGd44ljmVQY0wTknH610+jTPqniFrLzHMk2nSrISQdgyAh49yfzrJTu7G06Timd2njPSHG7zJ1izgStCwRj7HFM1HxJo9qHa5nUeXk\/dJPGenr9015vJBJltLMgWfmLaW+62MfkOtZC28niq7uNVvpNw3GONUOBwOO\/FCn3G6F2kmem6Z4utb29EMunz2oYFopHKsGwM\/wAJODjPFbNz4l0qxjY3V2kRBUYbgnPp615r4EjkfVZLd5I1ksiUDYB3e2e\/BP5Ve8RpNba7PLMwbzFQLhf4Qv8AiGpqTtdk+zTnyo6PVPGEBSJNNlieSVPMEkgJQLxjgdc5qHw54im1pbiG6t1juLfbuaPOxwc4Iz06HiuCvdZj05Es2zHudiJslcqwBK9MdQT16mo7DxxcQWd1aWMUbysQiXBYkgkYB98UOdnd7FRoOatHc9NuLS4gj8ySPCE8HI71nyPiuMtYb8app80F5ezP5qrcLLMWDKT83BP1Nd29pj+HP41akpbHPODg7M6jwe27SZj\/ANNz\/wCgrRVfwIMaNc8k\/wClv17fKtFUCOV8Ua7H4e0mS+dPMYELGmcbmPQV5FqHxE1fUX2XCxLb5yIogVBPbJ5Ndr8UHiks7K3lkChpGcDdjOBj+teYDTN+7bMNvUEina6DXdG5aeLLWa8i\/tCCZogoY7cEq4PUev416\/4aisII5dQt5Gea8hAikYABV6jH418\/vpkiDcsiE\/lXr3gqWX\/hDrFXOZFZl65wAxIH60o043G6knuYHivWDN4km0q1AWRYiZZx94ueQPyP61V0CNtN0u6imuU8zdvRHHQkf54rmreV77xlqEwYndLI3JxkFuBXQPbIWAj3guueud2O\/wCPFZVEm7GlKbjqT+DrN7jWdl5eGJ7h2cBDlmYcn6Hmu68VReXa2sgbcwlSBWmYk4Y45I+ufwrzKyuntPFmmLkK6SM2AeBkYx+leheObjGhWDZwWvYyfwBNdVGCcNUYTm1K6Haz4KtNU01kila3uVAKkDKsR69\/xzXmen+GNTnknlDxxpDIyhXGSWHoO3Ne43LiMrzwTXETMLPVJ4snDSM2Pcnd\/WnVhZXRm6jSM+z1O7triJ4IJRKjZzIm1R9fXr2r0bSdXg1fKeWY5lGSucg\/SuHbbI+4g1f8N3K2+sxPK6omWBJOBjBrBK2xPtZSep6P4LXbpV0P+nt\/5LRUvhJdumXB7NcuwPqCBRTN1seI\/GFP3OmP6NIM\/gv+FeULNIBtEjgZ7GvavinYNdeHBMgy1tKHP+6eD\/MV4ntY5wrEewphexIs8+cLK+f96up8PeNb\/Q7MWiRJcQmUyEyZ3DIAIBz7Vy0EcomRvJdwD0x1FeyaJ4R0l9Kt5ZzFK80YZZADgZ9vXtUyk1sa04Opoeb6G7f2ld4B3SfOPpknNbl7JN5aoJFDysqbh0Xnn8hSS6TBZ3GqXkDlmtd6xrjA2jOc+9ZWj6jd3+sWULKih5lCsVPHPSo1k9BuPJZM6m78P6Vpemxajbzn7VERKMvkkjnB+tP8UeKNN1nRbJbK6EkiTh3jIIZcAjODW34gt7mHQrt7pVhiZQhbA4JOBj868vkjjjJAKN2DDoa0oSlFNMWIhFNWPR9WD+NL66htNWaC3hwkJRvkd9uSTjr1xWRo1te2dxNZajIzSqoeF2OQy9Dg96PAFzMqXlpGCImdX3Ljg+mP89K1tb1GIa6qXUohaOIbC5wHz156VLm3OzJqU4+x5upZHTNLpys97tjbY244YnGOKrxTLIuVkVh2IOan0y8W0u2m278E8Zx2xWii5NJdThS6nrfhAsdJlDuXKzkbic5+VaKj8F3gvtGlkEezbOVxuzn5VOf1oolFxfKzqg04po5HXbVb3Trq2YZEsTJ+YryF7exsIyLZcqv3juJyfxr2e9yEYjqBxXhV5dOYTATwXLP65oSuyuZJNWM+5kuXLyBiqknB\/pXoPgzVIh4Wmt5JcT2kRkG4\/wAB54+h\/nXHWTw3NqIBPtl8xhsblWyOtQR5SORMnkBTg9eacoXQoVHB3RH9svFtLqOGUyRE\/vARnaCcZz+NMsZZLW\/tLggjbIrqfof\/AK1UJhsuVUNwQGPPHrWroFot7r1hayfdlnRWz6Z5qoJK5LbbSO6+KWqNvs9LjPbz5Mfkv9a83kDQgqzAlTzg5GfrXo\/xZsVS+sL5RgyRmJv+AnI\/9CNebuD5Uhx1FNK6KrN8+pe07U73SrgXFlOYpCMEgAgj3B4qG\/v7m\/nNxdzPLIeNzGo0O6IH2qK44jIrOy3Fd2sRXCPtEsbFSPvbTivQPDcbx6NbvISXdd3Pp2\/TFcbPaNZtBG8qSmWBJjt7bh0PvXovh6zl1PRIJ4NmFHllc9CvH+FdeEdNT5p\/Iwrc\/LaJ6t8Nm3eHbj\/r7b\/0BKKk+HlrLaaDcxzLhvtbEc9tiUVhiGnVk0a0laCTOc1m7SysJrmQ8Ivp37frXmWi6BYazNNDeXkkVy+SiKAAffJ6\/Su58ZzhNAn9crx\/wIV4\/rOoyRzwvCxjkU7wyHBB7Vk02tDVNJ6q5eutG1LwxfPDcQ+Zb5YpJ\/Cw\/Hv7VnbsRZJ5JGQPpXX6D42Go2g0\/XLeO7t3G3zSPmX6jvV3WdJ0K2sntILQb2+ZZQ5z1\/hPOcccHsaSm1o0VKnGS5os880+7s4dVja8haWPymQKuOteh+DY\/DUdnFPuH9ogjcbgjcG\/2P6Y5rza4spLbVvszMGBQspA981oWfmwTJKuQ8bBh9RVxgptq+pmqjp2dro9c1XSP+EwsDaTSiAxN5kTkZPTGD+deOX0M0Tz2cMDyyxk+Z5alggBwT9K7mfxY40dtu6KVVIMiH25xXOeDWD6vcyyyHAhPB\/jBI\/TpS9+nD3tzWfs6tRcpz0LZhX8qnXTr6+2ra2c828HBRCQccmkvUihvX8lWEDNuUH+Een4dK71PGLQWypp9rbRpGoCb1JIx34NGr2RlaKvzM4VryS6dBMf3kaLEFIwQAMAYr0jQLFdN02ONpZFmPzOUkK8ntwa85xJq\/ioTXDqJJJ9zkLwTnPT8K9NikDkAn8jXPWk1aKKppPU9T+H7l9DuSXd\/wDSmGXbJ+4lFN+HgxoNxj\/n6b\/0BKK0hrFBLc848cMTo\/X\/AJar\/WvINYUCBJOd27FFFadCB+h\/dkP0rojeXDWwVpWYIMKCelFFUgMmYB74SsMsIyM\/jVyNR5WaKKuh8ciavwoiRt0e1sFfQ0+5jSFFlhXynX5cpxkHtRRUYn+KiqP8NlcH5g55ZSGBPPNNnmeS6kkOAXbJAHHNFFEt0Zr4TR0yxhN\/b3Q3B+SQDwSK61X\/ANlee+KKK4qmrOuGx6r8N\/8AkXrn\/r7b\/wBASiiit4fCjN7n\/9k=\"  /></BODY></HTML>"];
//      NSString* subjectLine =@"Example HTML formatted EMAIL with Image";
//
//      NSString *str1 = (NSString *)CFBridgingRelease(CFURLCreateStringByAddingPercentEscapes(kCFAllocatorSystemDefault, (CFStringRef) subjectLine, NULL, CFSTR(";/?:@&=+$,"), kCFStringEncodingUTF8));
//      NSString *str2 = (NSString *)CFBridgingRelease(CFURLCreateStringByAddingPercentEscapes(kCFAllocatorSystemDefault, (CFStringRef)buffer, NULL, CFSTR(";/?:@&=+$,"), kCFStringEncodingUTF8));
//
//      NSString *urlString = [NSString stringWithFormat:@"mailto:?subject=%@&body=%@",str1 ,str2 ];
//
//      [[UIApplication sharedApplication] openURL:[NSURL  URLWithString:urlString]];
//
////    [NSURL URLWithString:urlString];
//}
+(NSData*)get_announcements : (NSString*) id limit: (int) limit
{
    if(![NetworkUtils IsNetworkAvailable])
        return nil;//RESULT_NET_NOTAVAILABLE;
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    [params setValue:@"Announcements" forKey:@"module_name"];
    [params setValue:@"search" forKey:@"action_type"];
    [params setValue:id forKey:@"id"];
    [params setValue:[NSString stringWithFormat:@"%d",limit ] forKey:@"limit"];
    
    NSData* json=[self get_json:URL_ANNOUNCEMENTS parameters:params file:nil];
    if (json==nil)
    {
        DebugLog(@"json is wrong");
        return nil;
    }
    return json;
    
    
    
}

+(void)Logout
{
    if(![NetworkUtils IsNetworkAvailable])
        return ;//RESULT_NET_NOTAVAILABLE;
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    if(appDelegate.duid !=nil)
        [params setValue:appDelegate.duid forKey:@"udid"];
    [params setValue:@"handset_logout" forKey:@"action"];
    
    [self post_without_return :URL_UPDATE_AUTH parameters:params];
}
+(int)Authorize : (NSString*) user password:(NSString*) password{
    
    if(![NetworkUtils IsNetworkAvailable])
        return RESULT_NET_NOTAVAILABLE;
    //    if(![RANetwork IsHostAvailable:URL_UPDATE_AUTH])
    //        return RESULT_NET_ERROR;
    
    
    __block long ver = 0;
    NSMutableDictionary* params = [[NSMutableDictionary alloc] init];
    
    dispatch_async(dispatch_get_main_queue(), ^{
        AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
        ver = appDelegate.authVer;
        if(appDelegate.duid !=nil)
            [params setValue:appDelegate.duid forKey:@"udid"];
    });
    
    [params setValue:@"handset_login" forKey:@"action"];
    //    [headers setValue:[NSString stringWithFormat:@"%d",dataLength] forKey:@"Content-Length"];
    
    [params setValue:user forKey:@"user"];
    [params setValue:password forKey:@"password"];
    [params setValue:[NSString stringWithFormat:@"%ld",ver]  forKey:@"auth_ver"];
#ifdef TEST
    [params setValue:@"true" forKey:@"is_debug"];
#else
    [params setValue:@"false" forKey:@"is_debug"];
#endif
    NSData* json=[self get_json:URL_UPDATE_AUTH parameters:params  file:nil];
    if(json==nil)
        return RESULT_NET_ERROR;
    
    int ret = [self parse_authinfo:json user:user password:password];
    DebugLog(@"parse_authinfo return %d ",ret);
    
    
    return ret;
    
}

+ (NSDictionary *)collectErrMsg:(NSString *)errMsg DeviceInfo:(NSString *)deviceInfo Time:(NSString *)time {
    
    NSMutableDictionary *params = [@{
                              @"device_info" : deviceInfo == nil ? @"" : deviceInfo,
                              @"crash_info" : errMsg == nil ? @"" : errMsg,
                              @"crash_time" : time == nil ? @"" : time
                              } mutableCopy];
    
    NSData* json=[self get_json:URL_ERR_LOG parameters:params  file:nil];
    
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                };
    }
    
    NSDictionary *resultDic = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil];
    
    return resultDic;
}

+ (NSDictionary *)requestHome {
    
    NSMutableDictionary *params = [NSMutableDictionary dictionary];
    
//    action=hand_new_home_list
    [params setObject:@"hand_new_home_list" forKey:@"action"];
    [params setObject:@(YES) forKey:@"request_location"];
    
    AppDelegate *appDelegate = (AppDelegate*)[[UIApplication sharedApplication] delegate];
    if(appDelegate.personalmode)
        params[@"personal_mode"] = @"true";
    else
        params[@"personal_mode"] = @"false";
    NSData* json=[self get_json:URL_HOME parameters:params  file:nil];
    
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }
    
    NSDictionary *resultDic = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil];
    
    return resultDic;
    
}

+ (NSDictionary *)search:(NSMutableDictionary *)params {
    
    [params setObject:@"handset_search" forKey:@"action"];
    
    NSData* json=[self get_json:URL_REQUEST_COUNT parameters:params  file:nil];
    
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }
    
    NSDictionary *resultDic = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil];
    
    return resultDic;
}

+ (NSDictionary *)requestOrderHistory:(NSMutableDictionary *)params {
    
    [params setObject:@"hand_new_home_list_all" forKey:@"action"];
    AppDelegate *appDelegate = (AppDelegate*)[[UIApplication sharedApplication] delegate];
    if(appDelegate.personalmode)
        params[@"personal_mode"] = @"true";
    else
        params[@"personal_mode"] = @"false";
    NSData* json=[self get_json:URL_HISTORY parameters:params  file:nil];
    
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }
    
    NSDictionary *resultDic = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil];
    
    return resultDic;
}

+ (void)download_file:(NSMutableDictionary *)params url:(NSString *)url toCachePath:(NSString *)path progressHandler:(progressHandler)progressHandler completionHandler:(resultHandler)result {
    params = [self prepare_addtional_params:params];
    [NetworkUtils downloadFileOffset:0 Param:params from:url method:@"POST" toPath:path progressHandler:progressHandler completionHandler:result];
}

+ (NSDictionary *)requestKPI {
    
    NSMutableDictionary *params = [NSMutableDictionary dictionary];
    
    [params setObject:@"hand_new_kpi" forKey:@"action"];
    AppDelegate *appDelegate = (AppDelegate*)[[UIApplication sharedApplication] delegate];
    if(appDelegate.personalmode)
        params[@"personal_mode"] = @"true";
    else
        params[@"personal_mode"] = @"false";
    NSData* json=[self get_json:URL_KPI parameters:params  file:nil];
    
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }
    
    NSDictionary *resultDic = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil];
    
    return resultDic;
    
}

+ (NSDictionary *)sendEmail:(NSString *)email CC:(NSString *)cc SerialNo:(NSString *)serialNo {
    
    if (!email) {
        email = @"";
    }
    if (!serialNo) {
        serialNo = @"";
    }
    
    NSMutableDictionary *params = [NSMutableDictionary dictionary];
    [params setObject:@"handset_search" forKey:@"action"];
    [params setObject:@"save_communication_email" forKey:@"action_type"];
    [params setObject:serialNo forKey:@"serial_no"];
    [params setObject:email forKey:@"msg"];
    
    if (cc) {
        [params setObject:cc forKey:@"cc"];
    }
    
    
    NSData* json=[self get_json:URL_SEND_COMM_EMAIL parameters:params  file:nil];
    
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }
    
    NSDictionary *resultDic = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil];
    
    return resultDic;
    
}

+ (NSDictionary *)uploadUserSql:(NSString *)sql {
    
    NSMutableDictionary *params = [NSMutableDictionary dictionary];
    [params setObject:@"handset_search" forKey:@"action"];
    [params setValue:sql forKey:@"sql"];
    
    NSData* json=[self get_json:URL_UPLOAD_SQL parameters:params  file:nil];
    
    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }
    
    NSDictionary *resultDic = [NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil];
    
    return resultDic;
}

+ (NSDictionary *)mockResult:(NSDictionary *)params {
    
    sleep(2);

    // Booking : module_name = Ocean Booking
    NSDictionary *item_booking = @{
                                   @"type": @0,
                                   @"title":@"FU YAMA TRADing", // Consignee
                                   @"date":@"03/28/2019 - 04/24/2019", // M.V ETD - M.V ETA
                                   @"port":@"CNYTN - USLAX", // pol pod
                                   @"desc":@"B61180700423", // Booking#
                                   @"detail":@"HUNG TA GARDEN ENTERPRISE CO., LTD", // Shipper
                                   @"consignee": @"Martin Jane",
                                   @"addition":@[
                                           @{
                                               @"name":@"Carrier Booking#",
                                               @"value":@"NAM1774822"
                                               },
                                           @{
                                               @"name":@"Consignee",
                                               @"value":@"FU YAMA TRADing"
                                               },
                                           @{
                                               @"name":@"Place Of Delivery",
                                               @"value":@"CAPE TOWN, SOUTH AFRICA"
                                               },
                                           ],
                                   @"rowActionParameters":@[
                                           @"27d620831e3f458643c8046305e2cd13"
                                           ]
                                   };

    // B/L Info : module_name = Ocean B/L info.
    NSDictionary *item_BL = @{
                               @"type": @1,
                               @"icon": @"status_ae",
                               @"title":@"FU YAMA TRADing", // Consignee
                               @"date":@"03/28/2019 - 04/24/2019", // ETD - ETA Port
                               @"port":@"CNYTN - USLAX", // pol pod
                               @"desc":@"A1903300004", // hbol#
                               @"detail":@"VIENXING GLOBAL PTE LTD", // Shipper
                               @"transport_stage": @3,
                               @"rowActionParameters":@[
                                       @"27d620831e3f458643c8046305e2cd13"
                                       ]
                               };

    // Container : module_name = Container detail
    NSDictionary *item_container = @{
                                      @"type": @2,
                                      @"icon": @"status_ae",
                                      @"title": @"CN - YC STONE INC",
                                      @"hbol": @"A1901280696",
                                      @"desc": @"A1901280696(1 containers)",
                                      @"detail": @"Gate in full for a booking; CNGOM (GAOMING, 44, CN  2019-01-04)",
                                      @"date": @"01/16/2019 - 01/29/2019",
                                      @"port": @"CNNSA - USLGB",
                                      @"transport_stage": @3,
                                      @"rowActionParameters":@[
                                              @"27d620831e3f458643c8046305e2cd13"
                                              ]
                                      };

    // Document : module_name = Download Document
    NSDictionary *item_doc = @{
                                @"type": @3,
                                @"fileName":@"A1811390637FR1-UTA.pdf",
                                @"fileType":@"HBL",
                                @"po":@"0001791,0001722,0001885",
                                @"bol":@"A1811390637",
                                @"rowActionParameters":@[
                                                         @"handset_search",
                                                         @"download_doc",
                                                         @"https://ra.apexshipping.com/main_new.php",
                                                         @"QW10UUtFeDdRNlBFTzhLbFpYcCUyRmtUSFJnWHRwZ1RQSnBnZmpQblc0c1BHJTJCR1E5c2ZScWY3NXpIazJ0OXdicHEyUnolMkJxSkN1MDVV",
                                                         @"Question : FileName: ONEYSRGU12759300FR3.PDF, BOL: ONEYSRGU12759300",
                                                         @"FileName: ONEYSRGU12759300FR3.PDF, BOL: ONEYSRGU12759300",
                                                         @""
                                                         ]
                                };

    NSString *module_name = [params objectForKey:@"module_name"];
    NSMutableArray *arr = [NSMutableArray array];
    for (int i = 0; i < 20; i++) {
        if ([module_name isEqualToString:@"Ocean Booking"]) {
            [arr addObject:item_booking.copy];
        } else if ([module_name isEqualToString:@"Ocean B/L info."]) {
            [arr addObject:item_BL.copy];
        } else if ([module_name isEqualToString:@"Container detail"]) {
            [arr addObject:item_container.copy];
        } else if ([module_name isEqualToString:@"Download Document"]) {
            [arr addObject:item_doc.copy];
        }
    }

    NSArray *menu;
    NSString *title = @"";
    if ([module_name isEqualToString:@"Ocean Booking"]) {

        title = @"Ocean Booking";
        menu = @[
                 @{
                     @"title": @"Setting",
                     @"action": @"field_setting"
                 },
                 @{
                     @"title": @"Save",
                     @"action": @"save"
                 }
                 ];
        
    } else if ([module_name isEqualToString:@"Ocean B/L info."]) {

        title = @"Ocean B/L info";
        menu = @[
                 @{
                     @"title": @"Setting",
                     @"action": @"field_setting"
                     },
                 @{
                     @"title": @"Save",
                     @"action": @"save"
                     }
                 ];
    } else if ([module_name isEqualToString:@"Container detail"]) {

        title = @"Container detail";
        menu = @[
                 @{
                     @"title": @"Setting",
                     @"action": @"field_setting"
                     },
                 @{
                     @"title": @"Save",
                     @"action": @"save"
                     }
                 ];
    } else if ([module_name isEqualToString:@"Download Document"]) {

        title = @"Download Document";
        menu = @[
                 @{
                     @"title": @"Save",
                     @"action": @"save"
                 }
                 ];
    }

    NSArray *row_actions;
    if ([module_name isEqualToString:@"Download Document"]) {

        row_actions = @[@{
                            @"title": @"Download Document",
                            @"module": @"quick_look",
                            @"url": @"https://ra.apexshipping.com/main_new.php",
                            @"params": @{
                                    @"action": @0,
                                    @"action_type": @1,
                                    @"prefix": @2,
                                    @"url": @3,
                                    @"email_subject": @4,
                                    @"email_content": @5,
                                    @"email": @6
                                    }
                            }];
    } else {

        row_actions = @[@{
                            @"title": @"Ocean B/L info Detail",
                            @"module": @"detail",
                            @"url": @"https://ra.apexshipping.com/main_new.php?action=handset_search",
                            @"params": @{
                                    @"id": @0,
                                    }
                            }];
    }

    NSDictionary *resultDic = @{
                                @"result" : @RESULT_TRUE,
                                @"title" : title,
                                @"row_actions" : row_actions,
                                @"items" : arr,
                                @"menu" : menu
                                };

    // for detail
//    NSArray *actions = @[
//                         @"Detail",
//                         @"ISF LOG",
//                         @"AMS LOG",
//                         @"Tracing",
//                         @"Detail"
//                         ];

    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    NSArray *actions = [ApexMobileDB getActionsForFunction:module_name withUser:appDelegate.user];

    NSMutableDictionary *json = [resultDic mutableCopy];
    [json setValue:actions forKey:@"actions"];

    NSLog(@"%@",[RAConvertor dict2string:json]);

    return json;
    
}

+ (NSDictionary *)fetchResultParameters:(NSMutableDictionary *)params {
    
//    return [self mockResult:params];
    
    params[@"action"]=@"handset_search";
    NSData* json=[self get_json:URL_SEARCH_RESULT parameters:params  file:nil];

    if (json==nil)
    {
        return @{
                 @"result" : @RESULT_NET_ERROR,
                 @"err_msg" : MSG_NET_ERROR
                 };
    }

    NSMutableDictionary *resultDic = [[NSJSONSerialization JSONObjectWithData:json options:NSJSONReadingMutableLeaves error:nil] mutableCopy];
    
    // detail data in local database
    NSString *module_name = [params objectForKey:@"module_name"];
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    NSArray *actions = [ApexMobileDB getActionsForFunction:module_name withUser:appDelegate.user];
    [resultDic setValue:actions forKey:@"actions"];
    
    return resultDic;
}

+ (NSDictionary *)saveSearchParameters:(NSString *)paramStr forModule:(NSString *)module withName:(NSString *)name {
    if (!paramStr || !module) {
        return @{
                 @"result" : @RESULT_FALSE,
                 @"err_msg" : @"Sorry, something is wrong."
                 };
    }
    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    NSString *sql = [NSString stringWithFormat: @"insert into history(params,name,module_name,user) values('%@','%@','%@','%@')",paramStr,name,module,appDelegate.user];
    
    __block BOOL out_success = NO;
    [ApexMobileDB jk_sync_excute:sql completion:^(BOOL success) {
        out_success = success;
    }];
    
    if (out_success) {
        
        return @{
                 @"result" : @RESULT_TRUE,
                 @"err_msg" : @"save success."
                 };
        
    } else {
        return @{
                 @"result" : @RESULT_FALSE,
                 @"err_msg" : @"Sorry, something is wrong."
                 };

    }
}

+ (NSString *)getDisplayFieldsForFunction:(NSString *)function limit:(NSUInteger)limit {

    AppDelegate *appDelegate = (AppDelegate *)[[UIApplication sharedApplication] delegate];
    return [ApexMobileDB getDisplayFieldsForFunction:function withUser:appDelegate.user limit:limit];
}

@end