1 |
270 |
ahitrov |
package webshop::Coupon; |
2 |
|
|
|
3 |
|
|
use strict; |
4 |
|
|
use warnings 'all'; |
5 |
|
|
|
6 |
|
|
use Contenido::Globals; |
7 |
|
|
use base "Contenido::Document"; |
8 |
|
|
use Data::Dumper; |
9 |
|
|
|
10 |
|
|
sub extra_properties |
11 |
|
|
{ |
12 |
|
|
return ( |
13 |
|
|
{ 'attr' => 'class', 'column' => undef }, |
14 |
|
|
{ 'attr' => 'status', 'type' => 'status', 'rusname' => 'Статус', |
15 |
|
|
'cases' => [ |
16 |
|
|
[0, 'Купон не активен'], |
17 |
|
|
[1, 'Купон активен и разослан'], |
18 |
|
|
[2, 'Прототип ждет обработки'], |
19 |
|
|
[3, 'Купон использован'], |
20 |
|
|
[4, 'Прототип обработан роботом'], |
21 |
|
|
], |
22 |
|
|
}, |
23 |
|
|
{ 'attr' => 'uid_proto','type' => 'status', 'rusname' => 'Прототип пользовательского доступа', |
24 |
|
|
'cases' => [ |
25 |
|
|
[0, 'Купон доступен всем пользователям'], |
26 |
|
|
[1, 'Персональный купон, создается для всех зарегистрированных пользователей'], |
27 |
|
|
[2, 'Персональный купон, пользователи по выбору'], |
28 |
|
|
[3, 'Персональный купон для одного пользователя'], |
29 |
|
|
], |
30 |
|
|
'rem' => 'Заполняется при создании прототипа купона', |
31 |
|
|
}, |
32 |
|
|
{ 'attr' => 'uid_condition', 'type' => 'string', 'rusname' => 'Условие для прототипа' }, |
33 |
|
|
{ 'attr' => 'uid', 'type' => 'pickup', 'rusname' => 'Пользователь', |
34 |
|
|
lookup_opts => { class => $state->{users}->profile_document_class, order_by => 'email', search_by => 'email' }, |
35 |
|
|
allow_null => 1, default => 0, |
36 |
|
|
rem => '0 - действует для всех пользователей, многократно. id - для одного пользователя, однократно.' |
37 |
|
|
}, |
38 |
|
|
{ 'attr' => 'groups', 'rusname' => 'Группы товаров', |
39 |
|
|
lookup_opts => { class => $state->{webshop}->{item_section_class}, }, |
40 |
|
|
allow_null => 1, |
41 |
|
|
rem => 'Список разделов, на содержимое которых распространяется скидка по купону', |
42 |
|
|
}, |
43 |
|
|
{ 'attr' => 'discount', 'type' => 'string', 'rusname' => 'Скидка на сумму заказа (число или процент)', shortname => 'Скидка', |
44 |
|
|
default => 0, column => 2 }, |
45 |
|
|
{ 'attr' => 'min_sum', 'type' => 'string', 'rusname' => 'Минимальная сумма, на которую действует скидка', default => 0 }, |
46 |
|
|
) |
47 |
|
|
} |
48 |
|
|
|
49 |
|
|
sub class_name |
50 |
|
|
{ |
51 |
|
|
return 'Webshop: купон'; |
52 |
|
|
} |
53 |
|
|
|
54 |
|
|
sub class_description |
55 |
|
|
{ |
56 |
|
|
return 'Webshop: купон'; |
57 |
|
|
} |
58 |
|
|
|
59 |
|
|
sub class_table |
60 |
|
|
{ |
61 |
|
|
return 'webshop::SQL::CouponsTable'; |
62 |
|
|
} |
63 |
|
|
|
64 |
|
|
sub contenido_status_style |
65 |
|
|
{ |
66 |
|
|
my $self = shift; |
67 |
|
|
if ( $self->status == 3 ) { |
68 |
|
|
return 'color:black;'; |
69 |
|
|
} elsif ( $self->status == 2 ) { |
70 |
|
|
return 'color:red;'; |
71 |
|
|
} elsif ( $self->status == 4 ) { |
72 |
|
|
return 'color:olive;'; |
73 |
|
|
} |
74 |
|
|
} |
75 |
|
|
|
76 |
274 |
ahitrov |
sub table_links |
77 |
|
|
{ |
78 |
|
|
return [ |
79 |
|
|
{ name => 'Купоны', class => 'webshop::Coupon', filter => 'pid', field => 'pid' }, |
80 |
|
|
]; |
81 |
|
|
} |
82 |
270 |
ahitrov |
|
83 |
|
|
|
84 |
|
|
sub get_discount |
85 |
|
|
{ |
86 |
|
|
my $self = shift; |
87 |
|
|
|
88 |
|
|
my (%opts) = @_; |
89 |
432 |
ahitrov |
return 0 unless exists $opts{basket} || exists $opts{uid} && $opts{uid} || exists $opts{session} && $opts{session}; |
90 |
270 |
ahitrov |
return 0 unless $self->discount; |
91 |
|
|
|
92 |
589 |
ahitrov |
my $basket = exists $opts{basket} ? delete $opts{basket} : $keeper->{webshop}->get_basket ( %opts, with_products => 1 ); |
93 |
270 |
ahitrov |
return 0 unless ref $basket eq 'ARRAY' && @$basket; |
94 |
|
|
|
95 |
|
|
my ($number, $sum_total) = (0, 0); |
96 |
589 |
ahitrov |
my @basket = grep { exists $_->{item} && $_->{item} } @$basket; |
97 |
|
|
return 0 unless @basket; |
98 |
|
|
map { my $price = $_->{item}->price; $number += $_->number; $sum_total += $_->number * $price } @basket; |
99 |
270 |
ahitrov |
warn "BASKET: $number Items of $sum_total Value\n"; |
100 |
|
|
|
101 |
|
|
my $discount_counted = 0; |
102 |
589 |
ahitrov |
my $items = $self->keeper->get_documents ( |
103 |
270 |
ahitrov |
class => $state->{webshop}->{item_document_class}, |
104 |
|
|
lclass => 'webshop::CouponItemLink', |
105 |
|
|
lsource => $self->id, |
106 |
|
|
light => 1, |
107 |
589 |
ahitrov |
return_mode => 'hash_ref', |
108 |
270 |
ahitrov |
); |
109 |
589 |
ahitrov |
|
110 |
|
|
if ( $self->groups ) { |
111 |
|
|
my %groups = map { $_ => 1 } $self->groups; |
112 |
590 |
ahitrov |
@basket = grep { scalar (grep { exists $groups{$_} } $_->{item}->sections) > 0 || exists $items->{$_->{item}->id} } @basket; |
113 |
589 |
ahitrov |
} elsif ( keys %$items ) { |
114 |
|
|
@basket = grep { exists $items->{$_->{item}->id} } @basket; |
115 |
270 |
ahitrov |
} |
116 |
589 |
ahitrov |
return 0 unless @basket; |
117 |
270 |
ahitrov |
|
118 |
589 |
ahitrov |
my $found_sum = 0; |
119 |
|
|
foreach my $bi ( @basket ) { |
120 |
|
|
warn "BASKET: Basket item id [".$bi->item_id."]\n" if $DEBUG; |
121 |
|
|
next if $bi->{item}->special_price; |
122 |
|
|
next unless $bi->{item}->price > 0 && $bi->{item}->storage; |
123 |
|
|
$found_sum += $bi->number * $bi->{item}->price; |
124 |
270 |
ahitrov |
} |
125 |
591 |
ahitrov |
return $found_sum > 0 ? $self->can_discount( $found_sum, $sum_total ) : 0; |
126 |
270 |
ahitrov |
} |
127 |
|
|
|
128 |
|
|
|
129 |
|
|
sub can_discount |
130 |
|
|
{ |
131 |
|
|
my $self = shift; |
132 |
|
|
my $sum = shift; |
133 |
591 |
ahitrov |
my $total = shift || $sum; |
134 |
270 |
ahitrov |
return 0 unless $sum; |
135 |
|
|
|
136 |
|
|
my $discount = $self->discount; |
137 |
|
|
my $min_sum = $self->min_sum || 0; |
138 |
|
|
my $count = 0; |
139 |
|
|
if ( $discount =~ /([\d\.]+)%/ ) { |
140 |
|
|
my $proc = $1; |
141 |
|
|
return 0 unless $proc; |
142 |
|
|
$count = $sum / 100 * $proc; |
143 |
|
|
} else { |
144 |
|
|
$count = $discount; |
145 |
|
|
} |
146 |
|
|
my $rest = $sum - $count; |
147 |
432 |
ahitrov |
warn "Min Sum: $min_sum. Rest: $rest\n" if $DEBUG; |
148 |
591 |
ahitrov |
$count = 0 if ($min_sum && $total < $min_sum) || $rest <= 0; |
149 |
432 |
ahitrov |
warn "Count: $count\n" if $DEBUG; |
150 |
270 |
ahitrov |
return $count; |
151 |
|
|
} |
152 |
|
|
|
153 |
|
|
|
154 |
|
|
|
155 |
|
|
|
156 |
|
|
#sub table_links |
157 |
|
|
#{ |
158 |
|
|
# return [ |
159 |
|
|
# { name => 'Города', class => 'webshop::Town', filter => 'pid', field => 'pid' }, |
160 |
|
|
# ]; |
161 |
|
|
#} |
162 |
|
|
|
163 |
|
|
sub pre_store |
164 |
|
|
{ |
165 |
|
|
my $self = shift; |
166 |
|
|
|
167 |
|
|
my $default_section = $project->s_alias->{webshop_coupons} if ref $project->s_alias eq 'HASH'; |
168 |
|
|
if ( $default_section && !$self->sections ) { |
169 |
|
|
$self->sections($default_section); |
170 |
|
|
} |
171 |
|
|
|
172 |
|
|
return 1; |
173 |
|
|
} |
174 |
|
|
|
175 |
274 |
ahitrov |
|
176 |
|
|
sub post_delete |
177 |
|
|
{ |
178 |
|
|
my $self = shift; |
179 |
|
|
|
180 |
|
|
my $sql = $self->keeper->SQL->prepare('DELETE FROM webshop_coupons where pid = ?'); |
181 |
|
|
$sql->execute( $self->id ); |
182 |
276 |
ahitrov |
$sql = $self->keeper->SQL->prepare('DELETE FROM webshop_coupon_links where source_id = ?'); |
183 |
274 |
ahitrov |
$sql->execute( $self->id ); |
184 |
276 |
ahitrov |
$sql = $self->keeper->SQL->prepare('DELETE FROM webshop_order_coupons where dest_id = ?'); |
185 |
274 |
ahitrov |
$sql->execute( $self->id ); |
186 |
|
|
|
187 |
|
|
1; |
188 |
|
|
} |
189 |
|
|
|
190 |
270 |
ahitrov |
1; |