Skip to main content

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts 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.