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 - bhaskarBNC

1
Questions / multiple entry in SubForm from Master form using PHPRad
Hello @willvin   My SQL data

Suggestion Needed

Tables

table - items
fields - id,quote_no,charge,rate,qty

table-quote
fields - id,quote_no,client_name,remarks
--------------------
Master Form - quote
Sub Form - Items
--------------------

Page Events AfterAdd in quote form
for ($i = 0; $i < count($allmodeldata); $i++) {
    $table_data = array(
        "id" => $id[$i] + $allmodeldata[$i]['id'],
        "charge" => $charge[$i] + $allmodeldata[$i]['charge'],
        "rate" => $rate[$i] + $allmodeldata[$i]['rate'],
        "qty" => $qty[$i] + $allmodeldata[$i]['qty']
    );
  
    $db->where("id", $allmodeldata[$i]['id']);
    $db->update("item", $table_data);
}

----------------------------------------------------

Suggest me Errors message in submitting data .
2
Questions / Re: Running Multiple Quries using Dynamic Table Row
Hello @willvin   My SQL data

Suggestion Needed

Tables

table - items
fields - id,quote_no,charge,rate,qty

table-quote
fields - id,quote_no,client_name,remarks
--------------------
Master Form - quote
Sub Form - Items
--------------------

Page Events AfterAdd in quote form
for ($i = 0; $i < count($allmodeldata); $i++) {
    $table_data = array(
        "id" => $id[$i] + $allmodeldata[$i]['id'],
        "charge" => $charge[$i] + $allmodeldata[$i]['charge'],
        "rate" => $rate[$i] + $allmodeldata[$i]['rate'],
        "qty" => $qty[$i] + $allmodeldata[$i]['qty']
    );
   
    $db->where("id", $allmodeldata[$i]['id']);
    $db->update("item", $table_data);
}

----------------------------------------------------

Suggest me Errors message in submitting data .

Thanks
Bhaskar