Tag: Formatting

I am developing a project and have difficulties for a long time. I hope you can help me. I do not have much knowledge in JavaScript or JQuery.

In short:
I'm creating a budget record form and need to sum the values ​​of a particular column of a table and assign them to a field I've set as a subtotal. Later, this value is used to calculate a discount that can be assigned under "Fixed value" or "%", which leads to what I have determined as total.

It's worth noting that the fields in the table are generated dynamically with javascript, and that I would somehow have to store each line and their respective fields in order to later upload them to a database when dealing with values ​​in "R $" I have a lot of trouble formatting and doing the calculations while my currency mask is working.

// currency mask
Function currency (i) {
var v = i.value.replace (/  D / g, & # 39; & # 39;);
v = (v / 100) .toFixed (2) + ";
v = v.replace (".", ",");
v = v.replace (/ ( d) ( d {3}) ( d {3}), / g, "$ 1. $ 2. $ 3,");
v = v.replace (/ ( d) ( d {3}), / g, "$ 1. $ 2,");
i.value = "" + v;
}

// budget page
$ (document) .ready (function () {
var counter = 0;
// Add new line
$ ("# addLine"). On ("click", function () {
counter ++;

var newRow = $ ("");
var cols = "";
cols + = & # 39;& # 39 ;;
cols + = & # 39;& # 39 ;;
cols + = & # 39;& # 39 ;;
cols + = & # 39;& # 39 ;;
cols + = & # 39;& # 39 ;;
newRow.append (cols);

$ ("# table_levels") append (newRow);

});

// Function call to calculate the sum of each line
$ ("# table_levels"). on ("blur keyup", & # 39; input[name^="orcamento_item_valor"], Input[name^="orcamento_item_qtd"]& # 39 ;, function (event) {
calculateSeries ($ (this) .closest ("tr"));
});

// remove line
$ ("# table_levels") on ("click", "a.deleteLinha", function (event) {
$ (this) .closest ("tr"). remove ();
});
});

// function to calculate the sum of each line
Function calculate line (line) {
var price = + row.find (& # 39; input[name^="orcamento_item_valor"]& # 39;) .val ();
var quant = + row.find (& # 39; input[name^="orcamento_item_qtd"]& # 39;) .val ();

// 2 decimal places
var tot = (price * quant) .toFixed (2);
// replace the point with a comma
dead = dead.replace (".", ",");
// The regex at the bottom places one point to the left of each group of 3 digits because it is not at the beginning of the number
For example, if you want to change the row determination (& # 39 ;, Total & # 39;). Html ("R $" + (dead) .replace (/  B (?));
var v_total = (dead) .replace (/  B (? = ( d {3}) + (?!  d)) / g, ".");
$ ("#increment_item_subtotal"). val (v_total);
}

    

    
General data
    

    

        Name of the customer / pre-client: *
        
    
    

        Responsible Officer: 
        
    
    

        Status: *
        
            Choose
            Pending
            Approved
            Canceled
        
    
    

        Opening Date: 
        
    
    

        Opening hours: 
        
    
    

        time: 
        
    
    

        Budget remark: 
        
    
    
    
budget item
    

    

    

        

            

                
Product / service
                
unit value
                
amount
                
value
                
commands
            
        
        


        
        

            

                
Add
            
        
    
    
    
    
    

        Subtotal: 
        
    
    

        Type of description: 
        
            Choose
            % Percentage
            R $ fixed value
        
    
    

        Discount: 
        
    
    

        Total: 
        
    
    
    



    
        
        Clear
    
    
         
        Register yourself