| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158 |
- //
- // SelectUploadOrderViewController.m
- // iSales-NPD
- //
- // Created by Ray on 9/3/16.
- // Copyright © 2016 United Software Applications, Inc. All rights reserved.
- //
- #import "SelectUploadOrderViewController.h"
- #import "iSalesDB.h"
- #import <sqlite3.h>
- #import "SelectOrderTableViewCell.h"
- @interface SelectUploadOrderViewController ()<UITableViewDataSource,UITableViewDelegate>
- @property (nonatomic,strong) NSMutableArray<NSDictionary *> *sync_data;
- @property (strong, nonatomic) IBOutlet UITableView *syncDataTableView;
- @property (strong, nonatomic) IBOutlet UIButton *uploadButton;
- @end
- @implementation SelectUploadOrderViewController
- - (void)viewDidLoad {
- [super viewDidLoad];
- // Do any additional setup after loading the view.
-
- // self.syncDataTableView.delegate = self;
- // self.syncDataTableView.dataSource = self;
-
- }
- - (void)didReceiveMemoryWarning {
- [super didReceiveMemoryWarning];
- // Dispose of any resources that can be recreated.
- }
- - (NSMutableArray<NSDictionary *> *)sync_data {
- if (!_sync_data) {
- _sync_data = [NSMutableArray array];
-
- NSString *sql = @"select decrypt(c.company_name),o.so_id,o.sync_data from (select so_id,sync_data,customer_cid from offline_order where sync_data not null) as o join offline_contact as c on c.contact_id = o.customer_cid ;";
- [iSalesDB jk_query:sql completion:^(sqlite3_stmt *stmt, NSMutableDictionary *container, long *count) {
-
- const char *cn = (char *)sqlite3_column_text(stmt,0);
- if (cn == NULL) {
- cn = "";
- }
- const char *_id = (char *)sqlite3_column_text(stmt,1);
- if (_id == NULL) {
- _id = "";
- }
- const char *data = (char *)sqlite3_column_text(stmt,2);
- if (data == NULL) {
- data = "";
- }
-
- NSString *company_name = [NSString stringWithUTF8String:cn];
- NSString *so_id = [NSString stringWithUTF8String:_id];
- NSString *sync_data_str = [NSString stringWithUTF8String:data];
-
- NSDictionary *dic = [@{
- @"check" : @(1),
- @"company_name" : company_name,
- @"so_id" : so_id,
- @"sync_data" : sync_data_str
- } mutableCopy];
- [_sync_data addObject:dic];
-
-
- }];
-
- }
- return _sync_data;
- }
- - (IBAction)uploadButtonClicked:(UIButton *)sender {
-
- NSMutableArray *uploadArray = [NSMutableArray array];
-
- for (NSDictionary *dic in self.sync_data) {
-
- int check = [dic[@"check"] integerValue];
- NSString *so_id = dic[@"so_id"];
-
- if (check == 0) {
- [uploadArray addObject:so_id];
- }
-
- }
-
- if (self.returnValue && uploadArray.count) {
- self.returnValue(uploadArray);
- }
-
- [self dismissViewControllerAnimated:true completion:nil];
-
- }
- #pragma mark - dataSource
- - (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView {
- return 1;
- }
- - (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section {
- return self.sync_data.count;
- }
- - (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
-
- SelectOrderTableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:@"SelectOrderTableViewCell" forIndexPath:indexPath];
-
- NSDictionary *dic = [self.sync_data objectAtIndex:indexPath.row];
- int check = [dic[@"check"] integerValue];
- NSString *so_id = dic[@"so_id"];
- NSString *company_name = dic[@"company_name"];
-
- if (check)
- cell.checkedButton.selected = YES;
-
- cell.labelsoid.text = so_id;
- cell.labelcompany.text = company_name;
-
-
- return cell;
- }
- #pragma mark - delegate
- - (CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath {
- return 44;
- }
- - (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath {
-
- SelectOrderTableViewCell *cell = (SelectOrderTableViewCell *)[tableView cellForRowAtIndexPath:indexPath];
-
- cell.selected = NO;
- cell.checkedButton.selected = !cell.checkedButton.selected;
-
- NSMutableDictionary *dic = (NSMutableDictionary *)[self.sync_data objectAtIndex:indexPath.row];
- int check = [dic[@"check"] integerValue];
-
- if (cell.checkedButton.selected) {
- check = 1;
- } else {
- check = 0;
- }
- [dic setValue:[NSNumber numberWithInteger:check] forKey:@"check"];
-
- }
- //- (BOOL
- @end
|