Attachment #52420 for bug #11708

View | Details | Raw Unified | Return to bug 11708
Collapse All | Expand All




    my $dbh        = C4::Context->dbh;
    my $sth = $dbh->prepare("
        UPDATE aqbasketgroups
        SET closeddate=CAST(NOW() AS DATE)
               closeddate=CAST(NOW() AS DATE)
        WHERE  id=?
    ");
    $sth->execute($basketgroupno);

    my $dbh        = C4::Context->dbh;
    my $sth = $dbh->prepare("
        UPDATE aqbasketgroups
        SET    closeddate=NULL
        WHERE  id=?
    ");
    $sth->execute($basketgroupno);


$hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,

$hashref->{'closed'} set 'closeddate' if true, or reset 'closeddate' if defined but false.

=cut


    die "booksellerid is required to create a basketgroup" unless $basketgroupinfo->{'booksellerid'};
    my $query = "INSERT INTO aqbasketgroups (";
    my @params;
    foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment)) {
        if ( defined $basketgroupinfo->{$field} ) {
            $query .= "$field, ";
            push(@params, $basketgroupinfo->{$field});


$hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,

$hashref->{'closed'} set 'closeddate' if true, or reset 'closeddate' if defined but false.

=cut


    my @params;

    if ($basketgroupinfo->{closed}) {
        $query .= "closeddate = IF(closeddate IS NULL, CAST(NOW() AS DATE), closeddate), ";
    } elsif (defined $basketgroupinfo->{closed}) {
        $query .= "closeddate = NULL, ";
    }

    foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment)) {
        if ( defined $basketgroupinfo->{$field} ) {
            $query .= "$field=?, ";
            push(@params, $basketgroupinfo->{$field});

        { Slice => {} },
        $basketgroupid
    );
    my $basketgroup = $result_set->[0];    # id is unique
    $basketgroup->{closed} = defined($basketgroup->{closeddate}) ? 1 : 0;
    return $basketgroup;
}

#------------------------------------------------------------#

    my $dbh = C4::Context->dbh;
    my $sth = $dbh->prepare($query);
    $sth->execute($booksellerid);
    my $basketgroups = $sth->fetchall_arrayref({});
    foreach my $bg (@$basketgroups) {
        $bg->{closed} = defined($bg->{closeddate}) ? 1 : 0;
    }
    return $basketgroups;
}

#------------------------------------------------------------#

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/Bug-11708-remove-column-aqbasketgroups-closed.sql (+3 lines)
	1	UPDATE aqbasketgroups SET closeddate = CAST(NOW() AS DATE) WHERE closed = 1;
	2
	3	ALTER TABLE aqbasketgroups DROP COLUMN closed;

Lines 2773-2780 DROP TABLE IF EXISTS `aqbasketgroups`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (-3 / +1 lines)
2773	CREATE TABLE `aqbasketgroups` (	2773	CREATE TABLE `aqbasketgroups` (
2774	`id` int(11) NOT NULL auto_increment,	2774	`id` int(11) NOT NULL auto_increment,
2775	`name` varchar(50) default NULL,	2775	`name` varchar(50) default NULL,
2776	`closed` tinyint(1) default NULL,	2776	`closeddate` date default NULL,
2777	closeddate date default NULL, -- the date the basketgroup was closed
2778	`booksellerid` int(11) NOT NULL,	2777	`booksellerid` int(11) NOT NULL,
2779	`deliveryplace` varchar(10) default NULL,	2778	`deliveryplace` varchar(10) default NULL,
2780	`freedeliveryplace` text default NULL,	2779	`freedeliveryplace` text default NULL,
2781	-

Return to bug 11708

Lines 411-418 sub CloseBasketgroup { Link Here

(-)a/C4/Acquisition.pm (-10 / +15 lines)
411	my $dbh = C4::Context->dbh;	411	my $dbh = C4::Context->dbh;
412	my $sth = $dbh->prepare("	412	my $sth = $dbh->prepare("
413	UPDATE aqbasketgroups	413	UPDATE aqbasketgroups
414	SET closed=1,	414	SET closeddate=CAST(NOW() AS DATE)
415	closeddate=CAST(NOW() AS DATE)
416	WHERE id=?	415	WHERE id=?
417	");	416	");
418	$sth->execute($basketgroupno);	417	$sth->execute($basketgroupno);
Lines 433-439 sub ReOpenBasketgroup { Link Here
433	my $dbh = C4::Context->dbh;	432	my $dbh = C4::Context->dbh;
434	my $sth = $dbh->prepare("	433	my $sth = $dbh->prepare("
435	UPDATE aqbasketgroups	434	UPDATE aqbasketgroups
436	SET closed=0, closeddate=NULL	435	SET closeddate=NULL
437	WHERE id=?	436	WHERE id=?
438	");	437	");
439	$sth->execute($basketgroupno);	438	$sth->execute($basketgroupno);
Lines 852-858 $hashref->{'freedeliveryplace'} is the 'freedeliveryplace' field of the basketgr Link Here
852		851
853	$hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,	852	$hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,
854		853
855	$hashref->{'closed'} is the 'closed' field of the aqbasketgroups table, it is false if 0, true otherwise.	854	$hashref->{'closed'} set 'closeddate' if true, or reset 'closeddate' if defined but false.
856		855
857	=cut	856	=cut
858		857
Lines 861-867 sub NewBasketgroup { Link Here
861	die "booksellerid is required to create a basketgroup" unless $basketgroupinfo->{'booksellerid'};	860	die "booksellerid is required to create a basketgroup" unless $basketgroupinfo->{'booksellerid'};
862	my $query = "INSERT INTO aqbasketgroups (";	861	my $query = "INSERT INTO aqbasketgroups (";
863	my @params;	862	my @params;
864	foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment closed)) {	863	foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment)) {
865	if ( defined $basketgroupinfo->{$field} ) {	864	if ( defined $basketgroupinfo->{$field} ) {
866	$query .= "$field, ";	865	$query .= "$field, ";
867	push(@params, $basketgroupinfo->{$field});	866	push(@params, $basketgroupinfo->{$field});
Lines 916-922 $hashref->{'freedeliveryplace'} is the 'freedeliveryplace' field of the basketgr Link Here
916		915
917	$hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,	916	$hashref->{'deliverycomment'} is the 'deliverycomment' field of the basketgroup in the aqbasketgroups table,
918		917
919	$hashref->{'closed'} is the 'closed' field of the aqbasketgroups table, it is false if 0, true otherwise.	918	$hashref->{'closed'} set 'closeddate' if true, or reset 'closeddate' if defined but false.
920		919
921	=cut	920	=cut
922		921
Lines 928-939 sub ModBasketgroup { Link Here
928	my @params;	927	my @params;
929		928
930	if ($basketgroupinfo->{closed}) {	929	if ($basketgroupinfo->{closed}) {
931	$query .= "closeddate = IF(closed = 0, CAST(NOW() AS DATE), closeddate), ";	930	$query .= "closeddate = IF(closeddate IS NULL, CAST(NOW() AS DATE), closeddate), ";
932	} elsif (defined $basketgroupinfo->{closed}) {	931	} elsif (defined $basketgroupinfo->{closed}) {
933	$query .= "closeddate = NULL, ";	932	$query .= "closeddate = NULL, ";
934	}	933	}
935		934
936	foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment closed)) {	935	foreach my $field (qw(name billingplace deliveryplace freedeliveryplace deliverycomment)) {
937	if ( defined $basketgroupinfo->{$field} ) {	936	if ( defined $basketgroupinfo->{$field} ) {
938	$query .= "$field=?, ";	937	$query .= "$field=?, ";
939	push(@params, $basketgroupinfo->{$field});	938	push(@params, $basketgroupinfo->{$field});
Lines 1006-1012 sub GetBasketgroup { Link Here
1006	{ Slice => {} },	1005	{ Slice => {} },
1007	$basketgroupid	1006	$basketgroupid
1008	);	1007	);
1009	return $result_set->[0]; # id is unique	1008	my $basketgroup = $result_set->[0]; # id is unique
		1009	$basketgroup->{closed} = defined($basketgroup->{closeddate}) ? 1 : 0;
		1010	return $basketgroup;
1010	}	1011	}
1011		1012
1012	#------------------------------------------------------------#	1013	#------------------------------------------------------------#
Lines 1026-1032 sub GetBasketgroups { Link Here
1026	my $dbh = C4::Context->dbh;	1027	my $dbh = C4::Context->dbh;
1027	my $sth = $dbh->prepare($query);	1028	my $sth = $dbh->prepare($query);
1028	$sth->execute($booksellerid);	1029	$sth->execute($booksellerid);
1029	return $sth->fetchall_arrayref({});	1030	my $basketgroups = $sth->fetchall_arrayref({});
		1031	foreach my $bg (@$basketgroups) {
		1032	$bg->{closed} = defined($bg->{closeddate}) ? 1 : 0;
		1033	}
		1034	return $basketgroups;
1030	}	1035	}
1031		1036
1032	#------------------------------------------------------------#	1037	#------------------------------------------------------------#