Search jQuery

jQuery Forum

Auto add calculation by column pop up link

in Using jQuery Plugins • 7 years ago

Hi,

1. I have a problem regarding jquery auto add calculation. It is a timesheet hour calculation. Basically, I've done 90% of it and other 10% I cant seem to be found the solution.

This the script:

<script type="text/javascript">
$(document).ready(function () {
$('[data-toggle="popover"]').popover();
$('[id*=remarks_link]').popover();
function DisableDays(date) {
var day = date.getDay();
// If day == 5 then it is FRiday only enable understand bijes
if (day == 5) {
return [true];
} else {
return [false];
}
}
$(function () {
$('[id*=tb_date_pick]').datepicker({
changeMonth: true,
dateFormat: 'dd/mm/yy',
todayHighlight: true,
showAnime: 'fadeIn',
duration: 'fast',
beforeShowDay: DisableDays
});
});
$(function () {
$('#<%= GridView1.ClientID %> .tb_day').val("0");
});
$('#<%= GridView1.ClientID %> .tb_day').blur("change", function () {
if (isNaN(parseInt($(this).val()))) {
$(this).val('0');
} else {
$(this).val(parseInt($(this).val()).toString());
}
});
$('#<%= GridView1.ClientID %> .tb_day').blur("keyup", function () {
if (!jQuery.trim($(this).val()) == '') {
if (!isNaN(parseFloat($(this).val()))) {
var row = $(this).closest("tr");
$("[id*=hTest]", row).val(parseFloat($("[id*=tb_nt_sat]", row).val()) + parseFloat($("[id*=tb_nt_mon]", row).val()) + parseFloat($("[id*=tb_nt_tue]", row).val()) + parseFloat($("[id*=tb_nt_wed]", row).val()) + parseFloat($("[id*=tb_nt_thu]", row).val()) + parseFloat($("[id*=tb_nt_fri]", row).val()));
}
} else {
$(this).val('');
}
var grandTotal = 0;
$("[id*=hTest]").each(function () {
grandTotal = grandTotal + parseFloat($(this).val());
});
$("[id*=total_nt]").val(grandTotal.toString());
var satTot = 0;
var col = $(this).closest("td");
$("[id*=tb_nt_sat]").each(function () {
satTot += parseFloat($("[id*=tb_nt_sat]", col).val());
// satTot += parseFloat($(this).val());
});
$("[id*=tb_nt_sat_tot]").val(satTot.toString());
});
});
</script>

The 'satTot' seems not working as i expect( Auto add dynamically by column in gridview)

2. For popup link,I was thinking about using a link to a hidden textbox (for remark) and onmouse click, system will be displayed the textbox which consist of a few information from database and text area for remarking. I, thinking of simplest code for this. Can anyone advise me on this?

Replies(4)

kbwood.au

Re: Auto add calculation by column pop up link

7 years ago

Can you provide a page that shows the problem? That way we can see the HTML and the code and try it out.

HarryOthm..

Re: Auto add calculation by column pop up link

7 years ago

Thanks kbwood for the reply

. For your information, the page developed in microsoft sharepoint for webpart.

The calculation occur in gridview and the answer pass to textbox outside. And also I use bootstrap css and jquery ui.

This is the html:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDeleting="GridView1_RowDeleting" CssClass="table table-hover table-striped" GridLines="None" RowStyle-BackColor="#5AC3DE" AlternatingRowStyle-BackColor="#1ac6ff" Font-Size="Smaller">
<Columns>
<asp:BoundField DataField="Project No." HeaderText="Project No." />
<asp:BoundField DataField="Ctr No." HeaderText="Ctr No." />
<asp:BoundField DataField="Activity" HeaderText="Activity" />
<asp:TemplateField HeaderText="Remarks">
<ItemTemplate>
<asp:HyperLink ID="remarks_link" runat="server">View/Edit</asp:HyperLink>
<a href="#" data-toggle="popover" title="Popover Header" data-content="Some content inside the popover">Toggle popover</a></ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Actual" HeaderText="Actual To End of Week" />
<asp:TemplateField HeaderText="Sat st">
<ItemTemplate>
<asp:TextBox ID="tb_nt_sat" runat="server" CssClass="tb_day"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sat ot">
<ItemTemplate>
<asp:TextBox ID="tb_ot_sat" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sun st">
<ItemTemplate>
<asp:TextBox ID="tb_nt_sun" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sun ot">
<ItemTemplate>
<asp:TextBox ID="tb_ot_sun" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Mon st">
<ItemTemplate>
<asp:TextBox ID="tb_nt_mon" runat="server" CssClass="tb_day"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Mon ot">
<ItemTemplate>
<asp:TextBox ID="tb_ot_mon" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Tue st">
<ItemTemplate>
<asp:TextBox ID="tb_nt_tue" runat="server" CssClass="tb_day"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Tue ot">
<ItemTemplate>
<asp:TextBox ID="tb_ot_tue" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Wed st">
<ItemTemplate>
<asp:TextBox ID="tb_nt_wed" runat="server" CssClass="tb_day"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Wed ot">
<ItemTemplate>
<asp:TextBox ID="tb_ot_wed" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Thu st">
<ItemTemplate>
<asp:TextBox ID="tb_nt_thu" runat="server" CssClass="tb_day"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Thu ot">
<ItemTemplate>
<asp:TextBox ID="tb_ot_thu" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Fri st">
<ItemTemplate>
<asp:TextBox ID="tb_nt_fri" runat="server" CssClass="tb_day"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Fri ot">
<ItemTemplate>
<asp:TextBox ID="tb_ot_fri" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="hourtest">
<ItemTemplate>
<asp:TextBox ID="hTest" runat="server" CssClass="tb_day" ReadOnly="true"></asp:TextBox></ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Week" HeaderText="Weekly Total" />
<asp:BoundField DataField="Remain" HeaderText="Remaining hour" />
<asp:CommandField ShowEditButton="True" ButtonType="Button" />
<asp:CommandField ShowDeleteButton="True" ButtonType="Button" />
</Columns>
</asp:GridView>
//outside gridview
<asp:TextBox ID="tb_nt_sat_tot" runat="server" CssClass="button_total" ReadOnly="True"
Width="30px"></asp:TextBox>
<asp:TextBox ID="total_nt" runat="server" CssClass="button_total" ReadOnly="True"
Width="30px"></asp:TextBox>

2. I also include popup link (popover) in the code also located in gridview. I found popover bootstrap but i need suggestion on simplest code because the link will show readonly info for project, activity and textarea for remarking.

Glad anyone would help me

watusiware

Re: Auto add calculation by column pop up link

7 years ago

Few of us use Microsoft Sharepoint. We won't be able to run your example, nor will we be able to easily look at the code and know what it does.

It's better to post a link to your site, so that other can at least use the desktop browser's inspection/debug tools.

For problems that can be isolated, it's best to make an example using jsFiddle or Plunkr and then others can easily make changes for you to try. I'm afraid that would be difficult in this case, though.

I'm not sure what - if any - jQuery plugin(s) you are using? GridView is a Microsoft ASP thing. You'll get better help from a Microsoft ASP help site.

2. For popup link,I was thinking about using a link to a hidden textbox (for remark) and onmouse click, system will be displayed the textbox which consist of a few information from database and text area for remarking. I, thinking of simplest code for this. Can anyone advise me on this?

Not sure what your question here is.

Popovers don't seem to me to be very well-suited for collecting input. I would use a modal:

http://getbootstrap.com/javascript/#modals

Though, personally, I prefer just using a collapse. Popups/popovers/modals, can have messy complications (like what to do when they don't fit) on mobile touch-screens.

HarryOthm..

Re: Auto add calculation by column pop up link

7 years ago

Thanks @watusiware . The modal script worked.

Top Reply

Response title

Attachments

jQuery Forum

Auto add calculation by column pop up link

Replies(4)

Re: Auto add calculation by column pop up link

Re: Auto add calculation by column pop up link

Re: Auto add calculation by column pop up link

Re: Auto add calculation by column pop up link

Statistics

Tags

Actions