Attachment #3697 for bug #6069

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

Lines 46-51 BEGIN { Link Here

(-)a/C4/Budgets.pm (+55 lines)
46		46
47	&GetBudgetPeriod	47	&GetBudgetPeriod
48	&GetBudgetPeriods	48	&GetBudgetPeriods
		49	&GetBudgetFirstChild
		50	&GetBudgetParent
		51	&GetBudgetSecondChild
		52
49	&ModBudgetPeriod	53	&ModBudgetPeriod
50	&AddBudgetPeriod	54	&AddBudgetPeriod
51	&DelBudgetPeriod	55	&DelBudgetPeriod
Lines 464-469 sub GetBudgetPeriod { Link Here
464	}	468	}
465		469
466	# -------------------------------------------------------------------	470	# -------------------------------------------------------------------
		471	sub GetBudgetFirstChild {
		472	my $dbh = C4::Context->dbh;
		473	my $query = "SELECT *
		474	FROM `aqbudgets`
		475	WHERE budget_parent_id
		476	IN (
		477	SELECT budget_id FROM `aqbudgets`
		478	JOIN `aqbudgetperiods` ON aqbudgets.budget_period_id = aqbudgetperiods.budget_period_id
		479	WHERE ((`budget_parent_id` IS NULL)AND (`budget_period_active` LIKE 1)))
		480	ORDER BY `aqbudgets`.`budget_parent_id`, budget_name ASC";
		481	my $sth= $dbh->prepare($query);
		482	$sth->execute();
		483	my $data = $sth->fetchall_arrayref({});
		484	return $data;
		485	}
		486	# -------------------------------------------------------------------
		487	sub GetBudgetParent {
		488	my $dbh = C4::Context->dbh;
		489	my $query = "SELECT *
		490	FROM `aqbudgets`
		491	JOIN `aqbudgetperiods` ON aqbudgets.budget_period_id = aqbudgetperiods.budget_period_id
		492	WHERE ((`budget_parent_id` IS NULL)AND (`budget_period_active` LIKE 1))
		493	ORDER BY `aqbudgets`.`budget_id`, budget_name ASC";
		494	my $sth= $dbh->prepare($query);
		495	$sth->execute();
		496	my $data = $sth->fetchall_arrayref({});
		497	return $data;
		498	}
		499	# -------------------------------------------------------------------
		500	sub GetBudgetSecondChild {
		501	my $dbh = C4::Context->dbh;
		502	my $query = "SELECT *
		503	FROM `aqbudgets`
		504	WHERE budget_parent_id
		505	IN (
		506	SELECT budget_id
		507	FROM `aqbudgets`
		508	WHERE budget_parent_id
		509	IN (
		510	SELECT budget_id
		511	FROM `aqbudgets`
		512	JOIN `aqbudgetperiods` ON aqbudgets.budget_period_id = aqbudgetperiods.budget_period_id
		513	WHERE ((`budget_parent_id` IS NULL)AND (`budget_period_active` LIKE 1))))
		514	ORDER BY `aqbudgets`.`budget_parent_id` , budget_name ASC";
		515	my $sth= $dbh->prepare($query);
		516	$sth->execute();
		517	my $data = $sth->fetchall_arrayref({});
		518	return $data;
		519	}
		520	# -------------------------------------------------------------------
		521
467	sub DelBudgetPeriod{	522	sub DelBudgetPeriod{
468	my ($budget_period_id) = @_;	523	my ($budget_period_id) = @_;
469	my $dbh = C4::Context->dbh;	524	my $dbh = C4::Context->dbh;




</script>
<!--/TMPL_IF-->
<script type="text/javascript" src="<!-- TMPL_VAR NAME='themelang' -->/js/acq.js"></script>
<script type="text/javascript">
// <![CDATA[
    $(document).ready(function() {
    $('#sub_budgetid').hide();
    $('#su_sub_budgetid').hide();
    $("#budgetid").val("").attr('selected', 'selected');
           
        $('#budgetid').change(function() {
        var budget= $('#budgetid').val();
                
        if (budget ==""){
        $('#sub_budgetid').hide();
        $('#su_sub_budgetid').hide();
        $('#sub_budgetid option:visible').hide();
        $('#su_sub_budgetid option:visible').hide();
        $("#sub_budgetid").val("").attr('selected', 'selected');
        $("#su_sub_budgetid").val("").attr('selected', 'selected');
        }
        else {
        $('#sub_budgetid').show();
        $('#sub_budgetid option:visible').hide();
        $('.'+budget).show();
        $('#a').show();
        $("#sub_budgetid").val("").attr('selected', 'selected');
        $('#su_sub_budgetid option:visible').hide();
        $('#su_sub_budgetid').hide();
        }
        });

        $('#sub_budgetid').change(function() {
        var subbudget= $('#sub_budgetid').val();
        
        if (subbudget ==""){
        $('#su_sub_budgetid').hide();
        $("#su_sub_budgetid").val("").attr('selected', 'selected');
        $("#sub_budgetid").val("").attr('selected', 'selected');
        
        }
        else {
        $('#su_sub_budgetid').show();
        $('#su_sub_budgetid option:visible').hide();
        $('.'+subbudget).show();
        $('#b').show();
        $("#su_sub_budgetid").val("").attr('selected', 'selected');
        }
        });
    });
// ]]>
</script>

</head>
<body>
<!-- TMPL_INCLUDE name="header.inc" -->

                <option value="">Any</option><!-- TMPL_LOOP name="budgetsloop" -->
                <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR name="budget_id" -->" selected="selected"><!-- TMPL_VAR name="budget_name" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR name="budget_id" -->"><!-- TMPL_VAR name="budget_name" --></option><!-- /TMPL_IF --><!-- /TMPL_LOOP -->
            </select>
            <select name="sub_budgetid" id="sub_budgetid" >
                <option value="" id="a">Any</option><!-- TMPL_LOOP name="sub_budgetsloop" -->
                <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR name="budget_id" -->" selected="selected" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;"><!-- TMPL_VAR name="budget_name" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR name="budget_id" -->" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;" ><!-- TMPL_VAR name="budget_name" --></option><!-- /TMPL_IF --><!-- /TMPL_LOOP -->
            </select>
            <select name="su_sub_budgetid" id="su_sub_budgetid">
                <option value="" id="b">Any</option><!-- TMPL_LOOP name="su_sub_budgetsloop" -->
                <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR name="budget_id" -->" selected="selected" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;"><!-- TMPL_VAR name="budget_name" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR name="budget_id" -->" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;"><!-- TMPL_VAR name="budget_name" --></option><!-- /TMPL_IF --><!-- /TMPL_LOOP -->
            </select>
		</li><li><label for="quantity">Copies:</label>
			<input type="text" size="10" id="quantity" name="quantity" value="<!-- TMPL_VAR name="quantity" -->" onchange="calcNewsuggTotal();" />
                </li><li><label for="currency">Currency:</label>

Lines 84-89 my $tabcode = $input->param('tabcode'); Link Here

(-)a/suggestion/suggestion.pl (-1 / +11 lines)
84	my $suggestion_ref = $input->Vars;	84	my $suggestion_ref = $input->Vars;
85		85
86	delete $$suggestion_ref{$_} foreach qw( suggestedbyme op displayby tabcode edit_field );	86	delete $$suggestion_ref{$_} foreach qw( suggestedbyme op displayby tabcode edit_field );
		87
		88	$suggestion_ref->{'budgetid'} = $suggestion_ref->{'su_sub_budgetid'}\|\|$suggestion_ref->{'sub_budgetid'}\|\|$suggestion_ref->{'budgetid'};
		89	delete $$suggestion_ref{$_} foreach qw( suggestedbyme op displayby tabcode edit_field sub_budgetid su_sub_budgetid);
		90
87	foreach (keys %$suggestion_ref){	91	foreach (keys %$suggestion_ref){
88	delete $$suggestion_ref{$_} if (!$$suggestion_ref{$_} && ($op eq 'else' \|\| $op eq 'change'));	92	delete $$suggestion_ref{$_} if (!$$suggestion_ref{$_} && ($op eq 'else' \|\| $op eq 'change'));
89	}	93	}
Lines 294-301 my $budgets = GetBudgets($searchbudgets); Link Here
294	foreach my $budget (@$budgets){	298	foreach my $budget (@$budgets){
295	$budget->{'selected'}=1 if ($$suggestion_ref{'budgetid'} && $budget->{'budget_id'} eq $$suggestion_ref{'budgetid'})	299	$budget->{'selected'}=1 if ($$suggestion_ref{'budgetid'} && $budget->{'budget_id'} eq $$suggestion_ref{'budgetid'})
296	};	300	};
		301	my $bud = GetBudgetParent();
		302	my $subbud = GetBudgetFirstChild();
		303	my $susubbud = GetBudgetSecondChild();
297		304
298	$template->param( budgetsloop => $budgets);	305	$template->param( budgetsloop => $budgets);
		306	$template->param( budgetsloop => $bud );
		307	$template->param( sub_budgetsloop => $subbud );
		308	$template->param( su_sub_budgetsloop => $susubbud );
		309
299	$template->param( "statusselected_$$suggestion_ref{'STATUS'}" =>1);	310	$template->param( "statusselected_$$suggestion_ref{'STATUS'}" =>1);
300		311
301	# get currencies and rates	312	# get currencies and rates
302	-

Return to bug 6069

Lines 87-92 $(document).ready(function() { calcNewsuggTotal(); }); Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/suggestion.tmpl (+58 lines)
87	</script>	87	</script>
88	<!--/TMPL_IF-->	88	<!--/TMPL_IF-->
89	<script type="text/javascript" src="<!-- TMPL_VAR NAME='themelang' -->/js/acq.js"></script>	89	<script type="text/javascript" src="<!-- TMPL_VAR NAME='themelang' -->/js/acq.js"></script>
		90	<script type="text/javascript">
		91	// <![CDATA[
		92	$(document).ready(function() {
		93	$('#sub_budgetid').hide();
		94	$('#su_sub_budgetid').hide();
		95	$("#budgetid").val("").attr('selected', 'selected');
		96
		97	$('#budgetid').change(function() {
		98	var budget= $('#budgetid').val();
		99
		100	if (budget ==""){
		101	$('#sub_budgetid').hide();
		102	$('#su_sub_budgetid').hide();
		103	$('#sub_budgetid option:visible').hide();
		104	$('#su_sub_budgetid option:visible').hide();
		105	$("#sub_budgetid").val("").attr('selected', 'selected');
		106	$("#su_sub_budgetid").val("").attr('selected', 'selected');
		107	}
		108	else {
		109	$('#sub_budgetid').show();
		110	$('#sub_budgetid option:visible').hide();
		111	$('.'+budget).show();
		112	$('#a').show();
		113	$("#sub_budgetid").val("").attr('selected', 'selected');
		114	$('#su_sub_budgetid option:visible').hide();
		115	$('#su_sub_budgetid').hide();
		116	}
		117	});
		118
		119	$('#sub_budgetid').change(function() {
		120	var subbudget= $('#sub_budgetid').val();
		121
		122	if (subbudget ==""){
		123	$('#su_sub_budgetid').hide();
		124	$("#su_sub_budgetid").val("").attr('selected', 'selected');
		125	$("#sub_budgetid").val("").attr('selected', 'selected');
		126
		127	}
		128	else {
		129	$('#su_sub_budgetid').show();
		130	$('#su_sub_budgetid option:visible').hide();
		131	$('.'+subbudget).show();
		132	$('#b').show();
		133	$("#su_sub_budgetid").val("").attr('selected', 'selected');
		134	}
		135	});
		136	});
		137	// ]]>
		138	</script>
		139
90	</head>	140	</head>
91	<body>	141	<body>
92	<!-- TMPL_INCLUDE name="header.inc" -->	142	<!-- TMPL_INCLUDE name="header.inc" -->
Lines 169-174 $(document).ready(function() { calcNewsuggTotal(); }); Link Here
169	<option value="">Any</option><!-- TMPL_LOOP name="budgetsloop" -->	219	<option value="">Any</option><!-- TMPL_LOOP name="budgetsloop" -->
170	<!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR name="budget_id" -->" selected="selected"><!-- TMPL_VAR name="budget_name" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR name="budget_id" -->"><!-- TMPL_VAR name="budget_name" --></option><!-- /TMPL_IF --><!-- /TMPL_LOOP -->	220	<!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR name="budget_id" -->" selected="selected"><!-- TMPL_VAR name="budget_name" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR name="budget_id" -->"><!-- TMPL_VAR name="budget_name" --></option><!-- /TMPL_IF --><!-- /TMPL_LOOP -->
171	</select>	221	</select>
		222	<select name="sub_budgetid" id="sub_budgetid" >
		223	<option value="" id="a">Any</option><!-- TMPL_LOOP name="sub_budgetsloop" -->
		224	<!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR name="budget_id" -->" selected="selected" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;"><!-- TMPL_VAR name="budget_name" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR name="budget_id" -->" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;" ><!-- TMPL_VAR name="budget_name" --></option><!-- /TMPL_IF --><!-- /TMPL_LOOP -->
		225	</select>
		226	<select name="su_sub_budgetid" id="su_sub_budgetid">
		227	<option value="" id="b">Any</option><!-- TMPL_LOOP name="su_sub_budgetsloop" -->
		228	<!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR name="budget_id" -->" selected="selected" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;"><!-- TMPL_VAR name="budget_name" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR name="budget_id" -->" class="<!-- TMPL_VAR name="budget_parent_id" -->" style ="display : none;"><!-- TMPL_VAR name="budget_name" --></option><!-- /TMPL_IF --><!-- /TMPL_LOOP -->
		229	</select>
172	</li><li><label for="quantity">Copies:</label>	230	</li><li><label for="quantity">Copies:</label>
173	<input type="text" size="10" id="quantity" name="quantity" value="<!-- TMPL_VAR name="quantity" -->" onchange="calcNewsuggTotal();" />	231	<input type="text" size="10" id="quantity" name="quantity" value="<!-- TMPL_VAR name="quantity" -->" onchange="calcNewsuggTotal();" />
174	</li><li><label for="currency">Currency:</label>	232	</li><li><label for="currency">Currency:</label>