Hey,
How can i copy/paste the field quantity that is shown in line items, those fields are only visible when i click the button, add services, or add product, so they are not visible in the studio.
So i want to copy the field quantity that is in the product line, and paste it into the services line.
Thanks.
take a look at the js files located in /modules/AOS_Products_Quotes/ is not upgrade safe tho
best regards
It works now, the quantity field appears in the service line, but now i do have another problem.
When i put a number in this new field, the total of the item_line it’s not changing, but the total of the line_group its working perfectly (check the picture), i changed the code and i think it should be working, but it isn’t, so my question is, do i need to change anymore file?
Here is the code, in case someone wants to use it, or wants to check why it’s not working :P.
**
* Advanced OpenSales, Advanced, robust set of sales modules.
* @package Advanced OpenSales for SugarCRM
* @copyright SalesAgility Ltd http://www.salesagility.com
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE as published by
* the Free Software Foundation; either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU AFFERO GENERAL PUBLIC LICENSE
* along with this program; if not, see http://www.gnu.org/licenses
* or write to the Free Software Foundation,Inc., 51 Franklin Street,
* Fifth Floor, Boston, MA 02110-1301 USA
*
* @author SalesAgility <info@salesagility.com>
*/
var lineno;
var prodln = 0;
var servln = 0;
var groupn = 0;
var group_ids = {};
/**
* Load Line Items
*/
function insertLineItems(product,group){
var type = 'product_';
var ln = 0;
var current_group = 'lineItems';
var gid = product.group_id;
if(typeof group_ids[gid] === 'undefined'){
current_group = insertGroup();
group_ids[gid] = current_group;
for(var g in group){
if(document.getElementById('group'+current_group + g) !== null){
document.getElementById('group'+current_group + g).value = group[g];
}
}
} else {
current_group = group_ids[gid];
}
if(product.product_id != '0' && product.product_id !== ''){
ln = insertProductLine('product_group'+current_group,current_group);
type = 'product_';
} else {
ln = insertServiceLine('service_group'+current_group,current_group);
type = 'service_';
}
for(var p in product){
if(document.getElementById(type + p + ln) !== null){
if(product[p] !== '' && isNumeric(product[p]) && p != 'vat' && p != 'product_id' && p != 'name' && p != "part_number"){
document.getElementById(type + p + ln).value = format2Number(product[p]);
} else {
document.getElementById(type + p + ln).value = product[p];
}
}
}
calculateLine(ln,type);
}
/**
* Insert product line
*/
function insertProductLine(tableid, groupid) {
if(!enable_groups){
tableid = "product_group0";
}
if (document.getElementById(tableid + '_head') !== null) {
document.getElementById(tableid + '_head').style.display = "";
}
var vat_hidden = document.getElementById("vathidden").value;
var discount_hidden = document.getElementById("discounthidden").value;
sqs_objects["product_name[" + prodln + "]"] = {
"form": "EditView",
"method": "query",
"modules": ["AOS_Products"],
"group": "or",
"field_list": ["name", "id","part_number", "cost", "price","description","currency_id"],
"populate_list": ["product_name[" + prodln + "]", "product_product_id[" + prodln + "]", "product_part_number[" + prodln + "]", "product_product_cost_price[" + prodln + "]", "product_product_list_price[" + prodln + "]", "product_item_description[" + prodln + "]", "product_currency[" + prodln + "]"],
"required_list": ["product_id[" + prodln + "]"],
"conditions": [{
"name": "name",
"op": "like_custom",
"end": "%",
"value": ""
}],
"order": "name",
"limit": "30",
"post_onblur_function": "formatListPrice(" + prodln + ");",
"no_match_text": "No Match"
};
sqs_objects["product_part_number[" + prodln + "]"] = {
"form": "EditView",
"method": "query",
"modules": ["AOS_Products"],
"group": "or",
"field_list": ["part_number", "name", "id","cost", "price","description","currency_id"],
"populate_list": ["product_part_number[" + prodln + "]", "product_name[" + prodln + "]", "product_product_id[" + prodln + "]", "product_product_cost_price[" + prodln + "]", "product_product_list_price[" + prodln + "]", "product_item_description[" + prodln + "]", "product_currency[" + prodln + "]"],
"required_list": ["product_id[" + prodln + "]"],
"conditions": [{
"name": "part_number",
"op": "like_custom",
"end": "%",
"value": ""
}],
"order": "name",
"limit": "30",
"post_onblur_function": "formatListPrice(" + prodln + ");",
"no_match_text": "No Match"
};
tablebody = document.createElement("tbody");
tablebody.id = "product_body" + prodln;
document.getElementById(tableid).appendChild(tablebody);
var x = tablebody.insertRow(-1);
x.id = 'product_line' + prodln;
var a = x.insertCell(0);
a.innerHTML = "<input type='text' style='width:73px;' name='product_product_qty[" + prodln + "]' id='product_product_qty" + prodln + "' size='5' value='' title='' tabindex='116' onblur='Quantity_format2Number(" + prodln + ");calculateLine(" + prodln + ",\"product_\");'>";
var b = x.insertCell(1);
b.innerHTML = "<input style='width:178px;' class='sqsEnabled' autocomplete='off' type='text' name='product_name[" + prodln + "]' id='product_name" + prodln + "' maxlength='50' value='' title='' tabindex='116' value=''><input type='hidden' name='product_product_id[" + prodln + "]' id='product_product_id" + prodln + "' size='20' maxlength='50' value=''>";
var b1 = x.insertCell(2);
b1.innerHTML = "<input style='width:178px;' class='sqsEnabled' autocomplete='off' type='text' name='product_part_number[" + prodln + "]' id='product_part_number" + prodln + "' maxlength='50' value='' title='' tabindex='116' value=''>";
var b2 = x.insertCell(3);
b2.innerHTML = "<button title='" + SUGAR.language.get('app_strings', 'LBL_SELECT_BUTTON_TITLE') + "' accessKey='" + SUGAR.language.get('app_strings', 'LBL_SELECT_BUTTON_KEY') + "' type='button' tabindex='116' class='button' value='" + SUGAR.language.get('app_strings', 'LBL_SELECT_BUTTON_LABEL') + "' name='btn1' onclick='openProductPopup(" + prodln + ");'><img src='themes/default/images/id-ff-select.png' alt='" + SUGAR.language.get('app_strings', 'LBL_SELECT_BUTTON_LABEL') + "'></button>";
var c = x.insertCell(4);
c.innerHTML = "<input style='text-align: right; width:115px;' type='text' name='product_product_list_price[" + prodln + "]' id='product_product_list_price" + prodln + "' size='11' maxlength='50' value='' title='' tabindex='116' onblur='calculateLine(" + prodln + ",\"product_\");'><input type='hidden' name='product_product_cost_price[" + prodln + "]' id='product_product_cost_price" + prodln + "' value='' />";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("product_product_list_price" + prodln);
currencyFields.push("product_product_cost_price" + prodln);
}
var d = x.insertCell(5);
d.innerHTML = "<input type='text' style='text-align: right; width:90px;' name='product_product_discount[" + prodln + "]' id='product_product_discount" + prodln + "' size='12' maxlength='50' value='' title='' tabindex='116' onblur='calculateLine(" + prodln + ",\"product_\");' onblur='calculateLine(" + prodln + ",\"product_\");'><input type='hidden' name='product_product_discount_amount[" + prodln + "]' id='product_product_discount_amount" + prodln + "' value='' />";
d.innerHTML += "<select tabindex='116' name='product_discount[" + prodln + "]' id='product_discount" + prodln + "' onchange='calculateLine(" + prodln + ",\"product_\");'>" + discount_hidden + "</select>";
var e = x.insertCell(6);
e.innerHTML = "<input type='text' style='text-align: right; width:115px;' name='product_product_unit_price[" + prodln + "]' id='product_product_unit_price" + prodln + "' size='11' maxlength='50' value='' title='' tabindex='116' readonly='readonly' onblur='calculateLine(" + prodln + ",\"product_\");' onblur='calculateLine(" + prodln + ",\"product_\");'>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("product_product_unit_price" + prodln);
}
var f = x.insertCell(7);
f.innerHTML = "<input type='text' style='text-align: right; width:90px;' name='product_vat_amt[" + prodln + "]' id='product_vat_amt" + prodln + "' size='11' maxlength='250' value='' title='' tabindex='116' readonly='readonly'>";
f.innerHTML += "<select tabindex='116' name='product_vat[" + prodln + "]' id='product_vat" + prodln + "' onchange='calculateLine(" + prodln + ",\"product_\");'>" + vat_hidden + "</select>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("product_vat_amt" + prodln);
}
var g = x.insertCell(8);
g.innerHTML = "<input type='text' style='text-align: right; width:115px;' name='product_product_total_price[" + prodln + "]' id='product_product_total_price" + prodln + "' size='11' maxlength='50' value='' title='' tabindex='116' readonly='readonly'><input type='hidden' name='product_group_number[" + prodln + "]' id='product_group_number" + prodln + "' value='"+groupid+"'>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("product_product_total_price" + prodln);
}
var h = x.insertCell(9);
h.innerHTML = "<input type='hidden' name='product_currency[" + prodln + "]' id='product_currency" + prodln + "' value=''><input type='hidden' name='product_deleted[" + prodln + "]' id='product_deleted" + prodln + "' value='0'><input type='hidden' name='product_id[" + prodln + "]' id='product_id" + prodln + "' value=''><button type='button' id='product_delete_line" + prodln + "' class='button' value='" + SUGAR.language.get(module_sugar_grp1, 'LBL_REMOVE_PRODUCT_LINE') + "' tabindex='116' onclick='markLineDeleted(" + prodln + ",\"product_\")'><img src='themes/default/images/id-ff-clear.png' alt='" + SUGAR.language.get(module_sugar_grp1, 'LBL_REMOVE_PRODUCT_LINE') + "'></button><br>";
enableQS(true);
//QSFieldsArray["EditView_product_name"+prodln].forceSelection = true;
var y = tablebody.insertRow(-1);
y.id = 'product_note_line' + prodln;
var h1 = y.insertCell(0);
h1.colSpan = "3";
h1.style.color = "rgb(68,68,68)";
h1.innerHTML = "<span style='vertical-align: top;'>" + SUGAR.language.get(module_sugar_grp1, 'LBL_PRODUCT_DESCRIPTION') + " : </span>";
h1.innerHTML += "<textarea tabindex='116' name='product_item_description[" + prodln + "]' id='product_item_description" + prodln + "' rows='2' cols='23'></textarea> ";
var i = y.insertCell(1);
i.colSpan = "3";
i.style.color = "rgb(68,68,68)";
i.innerHTML = "<span style='vertical-align: top;'>" + SUGAR.language.get(module_sugar_grp1, 'LBL_PRODUCT_NOTE') + " : </span>";
i.innerHTML += "<textarea tabindex='116' name='product_description[" + prodln + "]' id='product_description" + prodln + "' rows='2' cols='23'></textarea> ";
addToValidate('EditView','product_product_id'+prodln,'id',true,"Please choose a product");
prodln++;
return prodln - 1;
}
/**
* Open product popup
*/
function openProductPopup(ln){
lineno=ln;
var popupRequestData = {
"call_back_function" : "setProductReturn",
"form_name" : "EditView",
"field_to_name_array" : {
"id" : "product_product_id" + ln,
"name" : "product_name" + ln,
"description" : "product_item_description" + ln,
"part_number" : "product_part_number" + ln,
"cost" : "product_product_cost_price" + ln,
"price" : "product_product_list_price" + ln,
"currency_id" : "product_currency" + ln
}
};
open_popup('AOS_Products', 800, 850, '', true, true, popupRequestData);
}
function setProductReturn(popupReplyData){
set_return(popupReplyData);
formatListPrice(lineno);
}
function formatListPrice(ln){
if (typeof currencyFields !== 'undefined'){
var product_currency_id = document.getElementById('product_currency' + ln).value;
product_currency_id = product_currency_id ? product_currency_id : -99;//Assume base currency if no id
var product_currency_rate = get_rate(product_currency_id);
var dollar_product_price = ConvertToDollar(document.getElementById('product_product_list_price' + ln).value, product_currency_rate);
document.getElementById('product_product_list_price' + ln).value = format2Number(ConvertFromDollar(dollar_product_price, lastRate));
var dollar_product_cost = ConvertToDollar(document.getElementById('product_product_cost_price' + ln).value, product_currency_rate);
document.getElementById('product_product_cost_price' + ln).value = format2Number(ConvertFromDollar(dollar_product_cost, lastRate));
}
else
{
document.getElementById('product_product_list_price' + ln).value = format2Number(document.getElementById('product_product_list_price' + ln).value);
document.getElementById('product_product_cost_price' + ln).value = format2Number(document.getElementById('product_product_cost_price' + ln).value);
}
calculateLine(ln,"product_");
}
/**
* Insert Service Line
*/
function insertServiceLine(tableid, groupid) {
if(!enable_groups){
tableid = "service_group0";
}
if (document.getElementById(tableid + '_head') !== null) {
document.getElementById(tableid + '_head').style.display = "";
}
var vat_hidden = document.getElementById("vathidden").value;
var discount_hidden = document.getElementById("discounthidden").value;
tablebody = document.createElement("tbody");
tablebody.id = "service_body" + servln;
document.getElementById(tableid).appendChild(tablebody);
var x = tablebody.insertRow(-1);
x.id = 'service_line' + servln;
var a = x.insertCell(0);
a.innerHTML = "<input type='text' style='width:73px;' name='service_product_qty[" + servln + "]' id='service_product_qty" + servln + "' size='5' value='' title='' tabindex='116' onblur='Quantity_format2NumberService(" + servln + ");calculateLine(" + servln + ",\"service_\");'>";
var b = x.insertCell(1);
b.colSpan = "4";
b.innerHTML = "<textarea name='service_name[" + servln + "]' id='service_name" + servln + "' size='16' cols='64' title='' tabindex='116'></textarea><input type='hidden' name='service_product_id[" + servln + "]' id='service_product_id" + servln + "' size='20' maxlength='50' value='0'>";
var b1 = x.insertCell(2);
b1.innerHTML = "<input type='text' style='text-align: right; width:115px;' name='service_product_list_price[" + servln + "]' id='service_product_list_price" + servln + "' size='11' maxlength='50' value='' title='' tabindex='116' onblur='calculateLine(" + servln + ",\"service_\");'>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("service_product_list_price" + servln);
}
var b2 = x.insertCell(3);
b2.innerHTML = "<input type='text' style='text-align: right; width:90px;' name='service_product_discount[" + servln + "]' id='service_product_discount" + servln + "' size='12' maxlength='50' value='' title='' tabindex='116' onblur='calculateLine(" + servln + ",\"service_\");' onblur='calculateLine(" + servln + ",\"service_\");'><input type='hidden' name='service_product_discount_amount[" + servln + "]' id='service_product_discount_amount" + servln + "' value='' />";
b2.innerHTML += "<select tabindex='116' name='service_discount[" + servln + "]' id='service_discount" + servln + "' onchange='calculateLine(" + servln + ",\"service_\");'>" + discount_hidden + "</select>";
var c = x.insertCell(4);
c.innerHTML = "<input type='text' style='text-align: right; width:115px;' name='service_product_unit_price[" + servln + "]' id='service_product_unit_price" + servln + "' size='11' maxlength='50' value='' title='' tabindex='116' onblur='calculateLine(" + servln + ",\"service_\");'>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("service_product_unit_price" + servln);
}
var d = x.insertCell(5);
d.innerHTML = "<input type='text' style='text-align: right; width:90px;' name='service_vat_amt[" + servln + "]' id='service_vat_amt" + servln + "' size='11' maxlength='250' value='' title='' tabindex='116' readonly='readonly'>";
d.innerHTML += "<select tabindex='116' name='service_vat[" + servln + "]' id='service_vat" + servln + "' onchange='calculateLine(" + servln + ",\"service_\");'>" + vat_hidden + "</select>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("service_vat_amt" + servln);
}
var e = x.insertCell(6);
e.innerHTML = "<input type='text' style='text-align: right; width:115px;' name='service_product_total_price[" + servln + "]' id='service_product_total_price" + servln + "' size='11' maxlength='50' value='' title='' tabindex='116' readonly='readonly'><input type='hidden' name='service_group_number[" + servln + "]' id='service_group_number" + servln + "' value='"+ groupid +"'>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("service_product_total_price" + servln);
}
var f = x.insertCell(7);
f.innerHTML = "<input type='hidden' name='service_deleted[" + servln + "]' id='service_deleted" + servln + "' value='0'><input type='hidden' name='service_id[" + servln + "]' id='service_id" + servln + "' value=''><button type='button' class='button' id='service_delete_line" + servln + "' value='" + SUGAR.language.get(module_sugar_grp1, 'LBL_REMOVE_PRODUCT_LINE') + "' tabindex='116' onclick='markLineDeleted(" + servln + ",\"service_\")'><img src='themes/default/images/id-ff-clear.png' alt='" + SUGAR.language.get(module_sugar_grp1, 'LBL_REMOVE_PRODUCT_LINE') + "'></button><br>";
servln++;
return servln - 1;
}
/**
* Insert product Header
*/
function insertProductHeader(tableid){
tablehead = document.createElement("thead");
tablehead.id = tableid +"_head";
tablehead.style.display="none";
document.getElementById(tableid).appendChild(tablehead);
var x=tablehead.insertRow(-1);
x.id='product_head';
var a=x.insertCell(0);
a.style.color="rgb(68,68,68)";
a.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_PRODUCT_QUANITY');
var b=x.insertCell(1);
b.style.color="rgb(68,68,68)";
b.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_PRODUCT_NAME');
var b1=x.insertCell(2);
b1.colSpan = "2";
b1.style.color="rgb(68,68,68)";
b1.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_PART_NUMBER');
var c=x.insertCell(3);
c.style.color="rgb(68,68,68)";
c.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_LIST_PRICE');
var d=x.insertCell(4);
d.style.color="rgb(68,68,68)";
d.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_DISCOUNT_AMT');
var e=x.insertCell(5);
e.style.color="rgb(68,68,68)";
e.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_UNIT_PRICE');
var f=x.insertCell(6);
f.style.color="rgb(68,68,68)";
f.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_VAT_AMT');
var g=x.insertCell(7);
g.style.color="rgb(68,68,68)";
g.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_TOTAL_PRICE');
var h=x.insertCell(8);
h.style.color="rgb(68,68,68)";
h.innerHTML=' ';
}
/**
* Insert service Header
*/
function insertServiceHeader(tableid){
tablehead = document.createElement("thead");
tablehead.id = tableid +"_head";
tablehead.style.display="none";
document.getElementById(tableid).appendChild(tablehead);
var x=tablehead.insertRow(-1);
x.id='service_head';
var aa=x.insertCell(0);
aa.style.color="rgb(68,68,68)";
aa.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_QUANTITY_NAME');
var a=x.insertCell(1);
a.colSpan = "4";
a.style.color="rgb(68,68,68)";
a.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_SERVICE_NAME');
var b=x.insertCell(2);
b.style.color="rgb(68,68,68)";
b.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_SERVICE_LIST_PRICE');
var c=x.insertCell(3);
c.style.color="rgb(68,68,68)";
c.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_SERVICE_DISCOUNT');
var d=x.insertCell(4);
d.style.color="rgb(68,68,68)";
d.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_SERVICE_PRICE');
var e=x.insertCell(5);
e.style.color="rgb(68,68,68)";
e.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_VAT_AMT');
var f=x.insertCell(6);
f.style.color="rgb(68,68,68)";
f.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_TOTAL_PRICE');
var g=x.insertCell(7);
g.style.color="rgb(68,68,68)";
g.innerHTML=' ';
}
/**
* Insert Group
*/
function insertGroup()
{
if(!enable_groups && groupn > 0){
return;
}
var tableBody = document.createElement("tr");
tableBody.id = "group_body"+groupn;
document.getElementById('lineItems').appendChild(tableBody);
var a=tableBody.insertCell(0);
a.colSpan="100";
var table = document.createElement("table");
table.id = "group"+groupn;
if(enable_groups){
table.style.border = '1px grey solid';
table.style.borderRadius = '4px';
table.border="1";
}
table.style.whiteSpace = 'nowrap';
table.width = '950';
a.appendChild(table);
tableheader = document.createElement("thead");
table.appendChild(tableheader);
var header_row=tableheader.insertRow(-1);
if(enable_groups){
var header_cell = header_row.insertCell(0);
header_cell.scope="row";
header_cell.colSpan="8";
header_cell.innerHTML=SUGAR.language.get(module_sugar_grp1, 'LBL_GROUP_NAME')+": <input name='group_name[]' id='"+ table.id +"name' size='30' maxlength='255' title='' tabindex='120' type='text'><input type='hidden' name='group_id[]' id='"+ table.id +"id' value=''><input type='hidden' name='group_group_number[]' id='"+ table.id +"group_number' value='"+groupn+"'>";
var header_cell_del = header_row.insertCell(1);
header_cell_del.scope="row";
header_cell_del.innerHTML="<span title='" + SUGAR.language.get(module_sugar_grp1, 'LBL_DELETE_GROUP') + "' style='float: right;'><a style='cursor: pointer;' id='deleteGroup' tabindex='116' onclick='markGroupDeleted("+groupn+")'><img src='themes/default/images/id-ff-clear.png' alt='X'></a></span><input type='hidden' name='group_deleted[]' id='"+ table.id +"deleted' value='0'>";
}
var productTableHeader = document.createElement("thead");
table.appendChild(productTableHeader);
var productHeader_row=productTableHeader.insertRow(-1);
var productHeader_cell = productHeader_row.insertCell(0);
productHeader_cell.colSpan="100";
var productTable = document.createElement("table");
productTable.id = "product_group"+groupn;
productHeader_cell.appendChild(productTable);
insertProductHeader(productTable.id);
var serviceTableHeader = document.createElement("thead");
table.appendChild(serviceTableHeader);
var serviceHeader_row=serviceTableHeader.insertRow(-1);
var serviceHeader_cell = serviceHeader_row.insertCell(0);
serviceHeader_cell.colSpan="100";
var serviceTable = document.createElement("table");
serviceTable.id = "service_group"+groupn;
serviceHeader_cell.appendChild(serviceTable);
insertServiceHeader(serviceTable.id);
/*tablebody = document.createElement("tbody");
table.appendChild(tablebody);
var body_row=tablebody.insertRow(-1);
var body_cell = body_row.insertCell(0);
body_cell.innerHTML+=" ";*/
tablefooter = document.createElement("tfoot");
table.appendChild(tablefooter);
var footer_row=tablefooter.insertRow(-1);
var footer_cell = footer_row.insertCell(0);
footer_cell.scope="row";
footer_cell.colSpan="20";
footer_cell.innerHTML="<input type='button' tabindex='116' class='button' value='"+SUGAR.language.get(module_sugar_grp1, 'LBL_ADD_PRODUCT_LINE')+"' id='"+productTable.id+"addProductLine' onclick='insertProductLine(\""+productTable.id+"\",\""+groupn+"\")' />";
footer_cell.innerHTML+=" <input type='button' tabindex='116' class='button' value='"+SUGAR.language.get(module_sugar_grp1, 'LBL_ADD_SERVICE_LINE')+"' id='"+serviceTable.id+"addServiceLine' onclick='insertServiceLine(\""+serviceTable.id+"\",\""+groupn+"\")' />";
if(enable_groups){
footer_cell.innerHTML+="<span style='float: right;'>"+SUGAR.language.get(module_sugar_grp1, 'LBL_TOTAL_AMT')+": <input name='group_total_amt[]' id='"+ table.id +"total_amt' size='21' maxlength='26' value='' title='' tabindex='120' type='text' readonly></span>";
var footer_row2=tablefooter.insertRow(-1);
var footer_cell2 = footer_row2.insertCell(0);
footer_cell2.scope="row";
footer_cell2.colSpan="20";
footer_cell2.innerHTML="<span style='float: right;'>"+SUGAR.language.get(module_sugar_grp1, 'LBL_DISCOUNT_AMOUNT')+": <input name='group_discount_amount[]' id='"+ table.id +"discount_amount' size='21' maxlength='26' value='' title='' tabindex='120' type='text' readonly></span>";
var footer_row3=tablefooter.insertRow(-1);
var footer_cell3 = footer_row3.insertCell(0);
footer_cell3.scope="row";
footer_cell3.colSpan="20";
footer_cell3.innerHTML="<span style='float: right;'>"+SUGAR.language.get(module_sugar_grp1, 'LBL_SUBTOTAL_AMOUNT')+": <input name='group_subtotal_amount[]' id='"+ table.id +"subtotal_amount' size='21' maxlength='26' value='' title='' tabindex='120' type='text' readonly></span>";
var footer_row4=tablefooter.insertRow(-1);
var footer_cell4 = footer_row4.insertCell(0);
footer_cell4.scope="row";
footer_cell4.colSpan="20";
footer_cell4.innerHTML="<span style='float: right;'>"+SUGAR.language.get(module_sugar_grp1, 'LBL_TAX_AMOUNT')+": <input name='group_tax_amount[]' id='"+ table.id +"tax_amount' size='21' maxlength='26' value='' title='' tabindex='120' type='text' readonly></span>";
if(document.getElementById('subtotal_tax_amount') !== null){
var footer_row5=tablefooter.insertRow(-1);
var footer_cell5 = footer_row5.insertCell(0);
footer_cell5.scope="row";
footer_cell5.colSpan="20";
footer_cell5.innerHTML="<span style='float: right;'>"+SUGAR.language.get(module_sugar_grp1, 'LBL_SUBTOTAL_TAX_AMOUNT')+": <input name='group_subtotal_tax_amount[]' id='"+ table.id +"subtotal_tax_amount' size='21' maxlength='26' value='' title='' tabindex='120' type='text' readonly></span>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("" + table.id+ 'subtotal_tax_amount');
}
}
var footer_row6=tablefooter.insertRow(-1);
var footer_cell6 = footer_row6.insertCell(0);
footer_cell6.scope="row";
footer_cell6.colSpan="20";
footer_cell6.innerHTML="<span style='float: right;'>"+SUGAR.language.get(module_sugar_grp1, 'LBL_GROUP_TOTAL')+": <input name='group_total_amount[]' id='"+ table.id +"total_amount' size='21' maxlength='26' value='' title='' tabindex='120' type='text' readonly></span>";
if (typeof currencyFields !== 'undefined'){
currencyFields.push("" + table.id+ 'total_amt');
currencyFields.push("" + table.id+ 'discount_amount');
currencyFields.push("" + table.id+ 'subtotal_amount');
currencyFields.push("" + table.id+ 'tax_amount');
currencyFields.push("" + table.id+ 'total_amount');
}
}
groupn++;
return groupn -1;
}
/**
* Mark Group Deleted
*/
function markGroupDeleted(gn)
{
document.getElementById('group_body' + gn).style.display = 'none';
var rows = document.getElementById('group_body' + gn).getElementsByTagName('tbody');
for (x=0; x < rows.length; x++) {
var input = rows[x].getElementsByTagName('button');
for (y=0; y < input.length; y++) {
if (input[y].id.indexOf('delete_line') != -1) {
input[y].click();
}
}
}
}
/**
* Mark line deleted
*/
function markLineDeleted(ln, key)
{
// collapse line; update deleted value
document.getElementById(key + 'body' + ln).style.display = 'none';
document.getElementById(key + 'deleted' + ln).value = '1';
document.getElementById(key + 'delete_line' + ln).onclick = '';
var groupid = 'group' + document.getElementById(key + 'group_number' + ln).value;
if(checkValidate('EditView',key+'product_id' +ln)){
removeFromValidate('EditView',key+'product_id' +ln);
}
calculateTotal(groupid);
calculateTotal();
}
/**
* Calculate Line Values
*/
function calculateLine(ln, key){
var required = 'product_list_price';
if(document.getElementById(key + required + ln) === null){
required = 'product_unit_price';
}
if (document.getElementById(key + 'name' + ln).value === '' || document.getElementById(key + required + ln).value === ''){
return;
}
if(key === "product_" && document.getElementById(key + 'product_qty' + ln) !== null && document.getElementById(key + 'product_qty' + ln).value === '')||(key === "service_" && document.getElementById(key + 'product_qty' + ln) !== null && document.getElementById(key + 'product_qty' + ln).value === ''){
document.getElementById(key + 'product_qty' + ln).value =1;
}
var productUnitPrice = unformat2Number(document.getElementById(key + 'product_unit_price' + ln).value);
if(document.getElementById(key + 'product_list_price' + ln) !== null && document.getElementById(key + 'product_discount' + ln) !== null && document.getElementById(key + 'discount' + ln) !== null){
var listPrice = get_value(key + 'product_list_price' + ln);
var discount = get_value(key + 'product_discount' + ln);
var dis = document.getElementById(key + 'discount' + ln).value;
if(dis == 'Amount')
{
if(discount > listPrice)
{
document.getElementById(key + 'product_discount' + ln).value = listPrice;
discount = listPrice;
}
productUnitPrice = listPrice - discount;
document.getElementById(key + 'product_unit_price' + ln).value = format2Number(listPrice - discount);
}
else if(dis == 'Percentage')
{
if(discount > 100)
{
document.getElementById(key + 'product_discount' + ln).value = 100;
discount = 100;
}
discount = (discount/100) * listPrice;
productUnitPrice = listPrice - discount;
document.getElementById(key + 'product_unit_price' + ln).value = format2Number(listPrice - discount);
}
else
{
document.getElementById(key + 'product_unit_price' + ln).value = document.getElementById(key + 'product_list_price' + ln).value;
document.getElementById(key + 'product_discount' + ln).value = '';
discount = 0;
}
document.getElementById(key + 'product_list_price' + ln).value = format2Number(listPrice);
//document.getElementById(key + 'product_discount' + ln).value = format2Number(unformat2Number(document.getElementById(key + 'product_discount' + ln).value));
document.getElementById(key + 'product_discount_amount' + ln).value = format2Number(-discount, 6);
}
var productQty = 1;
if(document.getElementById(key + 'product_qty' + ln) !== null){
productQty = unformat2Number(document.getElementById(key + 'product_qty' + ln).value);
if (key=="product_")
{
Quantity_format2Number(ln);
}
else if (key=="service_")
{
Quantity_format2NumberService(ln);
}
}
var vat = unformatNumber(document.getElementById(key + 'vat' + ln).value,',','.');
var productTotalPrice = productQty * productUnitPrice;
var totalvat=(productTotalPrice * vat) /100;
if(total_tax){
productTotalPrice=productTotalPrice + totalvat;
}
document.getElementById(key + 'vat_amt' + ln).value = format2Number(totalvat);
document.getElementById(key + 'product_unit_price' + ln).value = format2Number(productUnitPrice);
document.getElementById(key + 'product_total_price' + ln).value = format2Number(productTotalPrice);
var groupid = 0;
if(enable_groups){
groupid = document.getElementById(key + 'group_number' + ln).value;
}
groupid = 'group' + groupid;
calculateTotal(groupid);
calculateTotal();
}
function calculateAllLines(){
var row = document.getElementById('lineItems').getElementsByTagName('tbody');
var length = row.length;
for (k=0; k < length; k++) {
var input = row[k].getElementsByTagName('input');
var key = input[0].id.split('_')[0]+'_';
var ln = input[0].id.slice(-1);
calculateLine(ln, key);
}
}
/**
* Calculate totals
*/
function calculateTotal(key)
{
if (typeof key === 'undefined') { key = 'lineItems'; }
var row = document.getElementById(key).getElementsByTagName('tbody');
if(key == 'lineItems') key = '';
var length = row.length;
var head = {};
var tot_amt = 0;
var subtotal = 0;
var dis_tot = 0;
var tax = 0;
for (i=0; i < length; i++) {
var qty = 1;
var list = null;
var unit = 0;
var deleted = 0;
var dis_amt = 0;
var product_vat_amt = 0;
var input = row[i].getElementsByTagName('input');
for (j=0; j < input.length; j++) {
if (input[j].id.indexOf('product_qty') != -1) {
qty = unformat2Number(input[j].value);
}
if (input[j].id.indexOf('product_list_price') != -1)
{
list = unformat2Number(input[j].value);
}
if (input[j].id.indexOf('product_unit_price') != -1)
{
unit = unformat2Number(input[j].value);
}
if (input[j].id.indexOf('product_discount_amount') != -1)
{
dis_amt = unformat2Number(input[j].value);
}
if (input[j].id.indexOf('vat_amt') != -1)
{
product_vat_amt = unformat2Number(input[j].value);
}
if (input[j].id.indexOf('deleted') != -1) {
deleted = input[j].value;
}
}
if(deleted != 1 && key !== ''){
head[row[i].parentNode.id] = 1;
} else if(key !== '' && head[row[i].parentNode.id] != 1){
head[row[i].parentNode.id] = 0;
}
if (qty !== 0 && list !== null && deleted != 1) {
tot_amt += list * qty;
} else if (qty !== 0 && unit !== 0 && deleted != 1) {
tot_amt += unit * qty;
}
if (dis_amt !== 0 && deleted != 1) {
dis_tot += dis_amt * qty;
}
if (product_vat_amt !== 0 && deleted != 1) {
tax += product_vat_amt;
}
}
for(var h in head){
if (head[h] != 1 && document.getElementById(h + '_head') !== null) {
document.getElementById(h + '_head').style.display = "none";
}
}
subtotal = tot_amt + dis_tot;
set_value(key+'total_amt',tot_amt);
set_value(key+'subtotal_amount',subtotal);
set_value(key+'discount_amount',dis_tot);
var shipping = get_value(key+'shipping_amount');
var shippingtax = get_value(key+'shipping_tax');
var shippingtax_amt = shipping * (shippingtax/100);
set_value(key+'shipping_tax_amt',shippingtax_amt);
tax += shippingtax_amt;
set_value(key+'tax_amount',tax);
set_value(key+'subtotal_tax_amount',subtotal + tax);
set_value(key+'total_amount',subtotal + tax + shipping);
}
function set_value(id, value){
if(document.getElementById(id) !== null)
{
document.getElementById(id).value = format2Number(value);
}
}
function get_value(id){
if(document.getElementById(id) !== null)
{
return unformat2Number(document.getElementById(id).value);
}
return 0;
}
function unformat2Number(num)
{
return unformatNumber(num, num_grp_sep, dec_sep);
}
function format2Number(str, sig)
{
if (typeof sig === 'undefined') { sig = sig_digits; }
num = Number(str);
if(sig == 2){
str = formatCurrency(num);
}
else{
str = num.toFixed(sig);
}
str = str.split(/,/).join('{,}').split(/\./).join('{.}');
str = str.split('{,}').join(num_grp_sep).split('{.}').join(dec_sep);
return str;
}
function formatCurrency(strValue)
{
strValue = strValue.toString().replace(/\$|\,/g,'');
dblValue = parseFloat(strValue);
blnSign = (dblValue == (dblValue = Math.abs(dblValue)));
dblValue = Math.floor(dblValue*100+0.50000000001);
intCents = dblValue%100;
strCents = intCents.toString();
dblValue = Math.floor(dblValue/100).toString();
if(intCents<10)
strCents = "0" + strCents;
for (var i = 0; i < Math.floor((dblValue.length-(1+i))/3); i++)
dblValue = dblValue.substring(0,dblValue.length-(4*i+3))+','+
dblValue.substring(dblValue.length-(4*i+3));
return (((blnSign)?'':'-') + dblValue + '.' + strCents);
}
function Quantity_format2Number(ln)
{
var str = '';
var qty=unformat2Number(document.getElementById('product_product_qty' + ln).value);
if(qty === null){qty = 1;}
if(qty === 0){
str = '0';
} else {
str = format2Number(qty);
if(sig_digits){
str = str.replace(/0*$/,'');
str = str.replace(dec_sep,'~');
str = str.replace(/~$/,'');
str = str.replace('~',dec_sep);
}
}
document.getElementById('product_product_qty' + ln).value=str;
}
function Quantity_format2NumberService(ln)
{
var str = '';
var qty=unformat2Number(document.getElementById('service_product_qty' + ln).value);
if(qty === null){qty = 1;}
if(qty === 0){
str = '0';
} else {
str = format2Number(qty);
if(sig_digits){
str = str.replace(/0*$/,'');
str = str.replace(dec_sep,'~');
str = str.replace(/~$/,'');
str = str.replace('~',dec_sep);
}
}
document.getElementById('service_product_qty' + ln).value=str;
}
function formatNumber(n, num_grp_sep, dec_sep, round, precision) {
if (typeof num_grp_sep == "undefined" || typeof dec_sep == "undefined") {
return n;
}
if(n === 0) n = '0';
n = n ? n.toString() : "";
if (n.split) {
n = n.split(".");
} else {
return n;
}
if (n.length > 2) {
return n.join(".");
}
if (typeof round != "undefined") {
if (round > 0 && n.length > 1) {
n[1] = parseFloat("0." + n[1]);
n[1] = Math.round(n[1] * Math.pow(10, round)) / Math.pow(10, round);
n[1] = n[1].toString().split(".")[1];
}
if (round <= 0) {
n[0] = Math.round(parseInt(n[0], 10) * Math.pow(10, round)) / Math.pow(10, round);
n[1] = "";
}
}
if (typeof precision != "undefined" && precision >= 0) {
if (n.length > 1 && typeof n[1] != "undefined") {
n[1] = n[1].substring(0, precision);
} else {
n[1] = "";
}
if (n[1].length < precision) {
for (var wp = n[1].length; wp < precision; wp++) {
n[1] += "0";
}
}
}
regex = /(\d+)(\d{3})/;
while (num_grp_sep !== "" && regex.test(n[0])) {
n[0] = n[0].toString().replace(regex, "$1" + num_grp_sep + "$2");
}
return n[0] + (n.length > 1 && n[1] !== "" ? dec_sep + n[1] : "");
}
function check_form(formname) {
calculateAllLines();
if (typeof(siw) != 'undefined' && siw && typeof(siw.selectingSomething) != 'undefined' && siw.selectingSomething)
return false;
return validate_form(formname, '');
}I dont know how to upload a .js, so i just copied the full code, sorry for that.
Thanks.
Another quick question,
im writing tons of alerts inside the code to see what happen’s, but they are not showing at all, any ideas why this is happening?
Thanks.
I solved this problem, the problem was that i missed a parenthesis in the code, stupid mistake…
Hello! Could you help me with the same issue, please? Where did you miss the parenthesis in the code?
Also please, explain. Did you add the new field ‘qty’ for service line through the studio? Or do you use the same field as for product line?
I will be really grateful for that!
We’ll be waiting for your reply!