Bug 20144: [sql_modes] Fix date format in tests
[koha.git] / t / db_dependent / Acquisition / OrderUsers.t
1 use Modern::Perl;
2 use Test::More tests => 3;
3
4 use C4::Acquisition;
5 use C4::Biblio;
6 use C4::Letters;
7 use Koha::Database;
8 use Koha::Acquisition::Booksellers;
9 use Koha::Acquisition::Orders;
10
11 use t::lib::TestBuilder;
12
13 my $schema = Koha::Database->schema;
14 $schema->storage->txn_begin;
15 my $builder = t::lib::TestBuilder->new;
16
17 my $library = $builder->build({
18     source => "Branch",
19 });
20 my $patron_category = $builder->build({ source => 'Category' });
21 my $currency = $builder->build({ source => 'Currency' });
22
23 # Creating some orders
24 my $bookseller = Koha::Acquisition::Bookseller->new(
25     {
26         name         => "my vendor",
27         address1     => "bookseller's address",
28         phone        => "0123456",
29         active       => 1,
30     }
31 )->store;
32
33 my $basketno = NewBasket( $bookseller->id, 1 );
34
35 my $budgetid = C4::Budgets::AddBudget(
36     {
37         budget_code => "budget_code_test_getordersbybib",
38         budget_name => "budget_name_test_getordersbybib",
39     }
40 );
41 my $budget = C4::Budgets::GetBudget($budgetid);
42
43 my @ordernumbers;
44 my ( $biblionumber, $biblioitemnumber ) = C4::Biblio::AddBiblio( MARC::Record->new, '' );
45
46 my $order = Koha::Acquisition::Order->new(
47     {
48         basketno         => $basketno,
49         quantity         => 2,
50         biblionumber     => $biblionumber,
51         budget_id        => $budgetid,
52         entrydate        => '2014-01-01',
53         currency         => $currency->{currency},
54         orderstatus      => 1,
55         quantityreceived => 0,
56         rrp              => 10,
57         ecost            => 10,
58     }
59 )->store;
60 my $ordernumber = $order->ordernumber;
61
62 my $invoiceid = AddInvoice(
63     invoicenumber => 'invoice',
64     booksellerid  => $bookseller->id,
65     unknown       => "unknown"
66 );
67
68 my $borrowernumber = C4::Members::AddMember(
69     cardnumber => 'TESTCARD',
70     firstname =>  'TESTFN',
71     surname => 'TESTSN',
72     categorycode => $patron_category->{categorycode},
73     branchcode => $library->{branchcode},
74     dateofbirth => '',
75     dateexpiry => '9999-12-31',
76     userid => 'TESTUSERID'
77 );
78
79 C4::Acquisition::ModOrderUsers( $ordernumber, $borrowernumber );
80
81 my $is_added = grep { /^$borrowernumber$/ } C4::Acquisition::GetOrderUsers( $ordernumber );
82 is( $is_added, 1, 'ModOrderUsers should link patrons to an order' );
83
84 $order = Koha::Acquisition::Orders->find( $ordernumber );
85 ModReceiveOrder(
86     {
87         biblionumber      => $biblionumber,
88         order             => $order->unblessed,
89         quantityreceived  => 1,
90         cost              => 10,
91         ecost             => 10,
92         invoiceid         => $invoiceid,
93         rrp               => 10,
94         budget_id         => $budgetid,
95     }
96 );
97
98 my $messages = C4::Letters::GetQueuedMessages({ borrowernumber => $borrowernumber });
99 is( scalar( @$messages ), 0, 'The letter has not been sent to message queue on receiving the order, the order is not entire received');
100
101 $order = Koha::Acquisition::Orders->find( $ordernumber );
102 ModReceiveOrder(
103     {
104         biblionumber      => $biblionumber,
105         order             => $order->unblessed,
106         quantityreceived  => 1,
107         cost              => 10,
108         ecost             => 10,
109         invoiceid         => $invoiceid,
110         rrp               => 10,
111         budget_id         => $budgetid,
112     }
113 );
114
115 $messages = C4::Letters::GetQueuedMessages({ borrowernumber => $borrowernumber });
116 is( scalar( @$messages ), 1, 'The letter has been sent to message queue on receiving the order');