AppGini Community Forums

dharbitindy wrote: ↑

2019-06-18 17:46

Added some more pics to above link for explanation, and to clarify the above, getting no results, or 0.00. Not wrong results.

Thank you,
David

ob_start();
        print_r($data);
        print_r($matl_price);
        print_r($part_weight);
    $c=ob_get_clean();
    echo "<pre>".htmlspecialchars($c)."</pre>";

dharbitindy wrote: ↑

2019-06-19 00:06

Hi, I put this in, but not seeing anything new in browser?

function results_before_insert(&$data, $memberInfo, &$args){

$part_weight = sqlValue(
"SELECT part_weight FROM quoting where quoting_ID='{$data['quoting_ID']}'"
);
$data['lbs_per_m'] = $part_weight * 1000 / 16;

$matl_price = sqlValue(
"SELECT matl_price FROM quoting where quoting_ID='{$data['quoting_ID']}'"
);
$data['matl_cost'] = $data['lbs_per_m'] * $matl_Price;

return TRUE;

ob_start();
print_r($data);
print_r($matl_price);
print_r($part_weight);
$c=ob_get_clean();
echo "<pre>".htmlspecialchars($c)."</pre>";

}

Thank you,
David

pböttcher wrote: ↑

2019-06-19 07:35

Hi,

I think the issue is because you try to get the matl_price from the quoting table, but instead the matl_price in the quoting table is a lookup to the materials table. So you need actually to pick the matl_price from the materials table.

so you may try this

Code: Select all

$from = get_sql_from('quoting');
$matl_price = sqlvalue("SELECT price_lb from ".$from." and quoting.quoting_ID='{$data['quoting_ID']}'");
$data['matl_cost'] = $data['lbs_per_m'] * $matl_Price;