blob: af971329e53122ad083a08d8dcb66979d19cc0de (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
#!/usr/bin/perl
use Text::CSV;
use Data::Dumper;
# cw_products
# 0 id 1 sku 2 product_name
# cw_skus
# 0 sku_id 1 sku 2 product_id
# cw_orders
# 0 order_id 1 date 2 status 3 customer_id
# cw_order_skus
# 0 id 1 order_id 2 sku_id
# cw_customers
# 0 customer_id 1 customer_type 2 date_added 3 date_modified 4 first_name 5 last_name
# 6 7 8 9 10 = address
@products = load_csv("cw_products.csv");
@skus = load_csv("cw_skus.csv");
@orders = load_csv("cw_orders.csv");
@order_skus = load_csv("cw_order_skus.csv");
@customers = load_csv("cw_customers.csv");
$product_name_lookup = {};
for $product (@products) {
$sku_name = $product->[1];
$product_name = $product->[2];
$product_name_lookup->{ $sku_name } = $product_name;
}
$customer_name_lookup = {};
for $customer (@customers) {
$id = $customer->[0];
$name = $customer->[5] . " " . $customer->[4];
$customer_name_lookup->{ $id } = $name;
}
$customer_lookup = {};
for $customer (@customers) {
$id = $customer->[0];
$customer_name_lookup->{ $id } = $customer;
}
$sku_id_lookup = {};
for $sku (@skus) {
$sku_id = $sku->[0];
$sku_name = $sku->[1];
$product_name = $product_name_lookup->{ $sku_name };
$sku_id_lookup->{ $sku_id } = $product_name;
}
$order_customer_lookup = {};
for $order (@orders) {
$order_id = $order->[0];
$customer_id = $order->[3];
$customer_name = $customer_name_lookup->{ $customer_id };
$order_customer_lookup->{ $order_id } = lc( $customer_name );
}
$order_sku_lookup = {};
for $order_sku (@order_skus) {
$order_id = $order_sku->[1];
$sku_id = $order_sku->[2];
$sku_name = $sku_id_lookup->{ $sku_id };
$customer_name = $order_customer_lookup->{ $order_id };
if ( not exists($order_sku_lookup->{ $customer_name })) {
$order_sku_lookup->{ $customer_name } = {};
}
$order_sku_lookup->{ $customer_name }->{ $sku_name } = 1;
if ( $customer_name =~ /dieter/ ) {
print $sku_name . "\n";
}
}
# print Dumper( $order_sku_lookup );
sub load_csv () {
my $filename = shift;
my @rows;
my $csv = Text::CSV->new ( { binary => 1 } ) # should set binary attribute.
or die "Cannot use CSV: ".Text::CSV->error_diag ();
open my $fh, "<:encoding(utf8)", $filename or die "$filename: $!";
while ( my $row = $csv->getline( $fh ) ) {
push @rows, $row;
}
$csv->eof or $csv->error_diag();
close $fh;
return @rows;
}
|
