Skip to main content ↑ ↓

Messages

This section allows you to view all Messages made by this member. Note that you can only see Messages made in areas you currently have access to.

Messages - maumar

1
Questions / PERFORMING CALCULATIONS ON DYNAMIC TABLE ROWS
Dear Sir @willvin I appreciate your help. If possible  please  help me about this issue . While I was using static table the following code was working perfectly to multiply two values i-e rate & quantity and result was displayed on third field invoice_rate .  But after using Dynamic Table Row it is not working. Thanks & Regards...

Code: [Select]
$(document).ready(function() { $("#ctrl-rate,#ctrl-quantity").keyup(function () { $('#ctrl-invoice_rate').val(($('#ctrl-quantity').val() * $('#ctrl-rate').val())); }); });
3
Questions / Re: Running Multiple Quries using Dynamic Table Row
Dear @willvin
I have used this query on Execute Before Adding Records

$db->where("wh_item", $modeldata['product']);
$db->where("category", $modeldata['category']);
$wh_quantity = $db->getValue("whstock", "wh_quantity");

and this one for after adding records
$table_data = array(
    "wh_quantity" => $wh_quantity + $modeldata['qty']
);
$db->where($row = 1);
$db->where("wh_item", $modeldata['product']);
$db->where("category", $modeldata['category']);
$db->update("whstock", $table_data);

$table_data = array(
    "wh_quantity" => $wh_quantity + $modeldata['qty']
);
$db->where($row = 2);
$db->where("wh_item", $modeldata['product']);
$db->where("category", $modeldata['category']);
$db->update("whstock", $table_data);


Please guide how can i do that

4
Questions / Running Multiple Quries using Dynamic Table Row
Hi all
Is it possible to run multiple queries as a result of dynamic table row.
For example When I add three records using dynamic table row . A query should executed for each record (After add record) . I tried but a single query is executed for first record.