2. PHPRunner General questions
  3. [SOLVED]  Program to List page from the Inline add Enter a product number after the data into related fields
This topic is locked
[SOLVED]

 Program to List page from the Inline add Enter a product number after the data into related fields

 		5/29/2015 4:11:29 AM
PHPRunner General questions
C
 carrie3800332 author

Program to List page from the Inline add i want keyin a product number after the data into related fields

I keyin product number But data did not into any related fields

Can kindly advice? Thank you.

My program vents →Add page →Before record added

global $conn;
$str="select length as length,

trail_degrees as trail_degrees,

symbol as symbol,

empty_torso as empty_torso,

buckle_length as buckle_length,

volume as volume,

empty_timber as empty_timber from buy_d where per_no='".$values[pro_no]."'";
$rs = CustomQuery($str);

$data = db_fetch_array($rs);

$values["length"] = $data["length"];

$values["trail_degrees"] = "'".$data["trail_degrees"]."'";

$values["symbol"] = "'".$data["symbol"]."'";

$values["empty_torso"] = "'".$data["empty_torso"]."'";

$values["buckle_length"] = "'".$data["buckle_length"]."'";

$values["volume"] = "'".$data["volume"]."'";

$values["empty_timber"] = "'".$data["empty_timber"]."'";
Sergey Kornilov admin 5/29/2015

It looks like you are looking for Autofill function. Check 'Autofill' section at http://xlinesoft.com/phprunner/docs/lookup_wizard.htm

Is that what you looking for?
C
 		carrie3800332 author 6/3/2015

Thank you replay, This issue has been resolved~

but Why this program use Events→ Add page→ javaScript onLoad Event can not be calculated?

this program finished can not be calculated

i try Before Other two program finished It has become not be calculated now

(Before the two program the calculation no problem )
How can I do? Thank you!
this program:

function func() {

var ctrlpro_no = Runner.getControl(pageid, 'pro_no');

var ctrllength = Runner.getControl(pageid, 'length');

var ctrlsymbol = Runner.getControl(pageid, 'symbol');

var ctrlempty_torso = Runner.getControl(pageid, 'empty_torso');

var ctrlbuckle_length = Runner.getControl(pageid, 'buckle_length');

var ctrlod = Runner.getControl(pageid, 'od');

var ctrlaverage_diameter = Runner.getControl(pageid, 'average_diameter');

var ctrlvolume = Runner.getControl(pageid, 'volume');

var ctrlempty_timber = Runner.getControl(pageid, 'empty_timber');

var ctrldiscount = Runner.getControl(pageid, 'discount');

var ctrlsolid_wood = Runner.getControl(pageid, 'solid_wood');
if (ctrlpro_no.getValue() !='') {
switch (ctrlsymbol.getValue()) {

case '+':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrldiscount.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854))

+((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854))) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}else{

ctrldiscount.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854))) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}

case '-':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrldiscount.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)) +((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/2)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}else{

ctrldiscount.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/2)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}

case '/':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrldiscount.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)) +((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/4)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}else{

ctrldiscount.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/4)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}

case '':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrldiscount.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)) +((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/8)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}else{

ctrldiscount.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/8)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}

case '':

if (ctrlsymbol.getValue()=='' && ctrlbuckle_length.getValue() > 0 ) {

ctrldiscount.setValue(((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)).toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}

if (ctrlsymbol.getValue()=='' && ctrlbuckle_length.getValue() ==0 ) {

ctrldiscount.setValue(0);

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue() - ctrldiscount.getValue()).toFixed(2));

break;

}

}

}
ctrllength.on('keyup', func);

ctrlsymbol.on('keyup', func);

ctrlempty_torso.on('keyup', func);

ctrlbuckle_length.on('keyup', func);

ctrlod.on('keyup', func);

ctrlaverage_diameter.on('keyup', func);

ctrlvolume.on('keyup', func);

ctrlempty_timber.on('keyup', func);

ctrldiscount.on('keyup', func);

ctrlsolid_wood.on('keyup', func);

};
Before program one:

function func() {

var ctrllength = Runner.getControl(pageid, 'length');

var ctrltrail_degreess1 = Runner.getControl(pageid, 'trail_degreess1');

var ctrltrail_degreess2 = Runner.getControl(pageid, 'trail_degreess2');

var ctrltrail_degreese1 = Runner.getControl(pageid, 'trail_degreese1');

var ctrltrail_degreese2 = Runner.getControl(pageid, 'trail_degreese2');

var ctrlsymbol = Runner.getControl(pageid, 'symbol');

var ctrlempty_torso = Runner.getControl(pageid, 'empty_torso');

var ctrlbuckle_length = Runner.getControl(pageid, 'buckle_length');

var ctrlod = Runner.getControl(pageid, 'od');

var ctrlaverage_diameter = Runner.getControl(pageid, 'average_diameter');

var ctrlvolume = Runner.getControl(pageid, 'volume');

var ctrlempty_timber = Runner.getControl(pageid, 'empty_timber');

var ctrlsolid_wood = Runner.getControl(pageid, 'solid_wood');
ctrlaverage_diameter.setValue(Math.floor( (parseFloat(ctrltrail_degreess1.getValue()) + parseFloat(ctrltrail_degreess2 .getValue()) + parseFloat(ctrltrail_degreese1.getValue()) + parseFloat(ctrltrail_degreese2.getValue()) ) / 4));
if (ctrlaverage_diameter.getValue() !='') {

ctrlvolume.setValue((ctrllength.getValue() Math.pow(ctrlaverage_diameter.getValue(), 2) (0.000007854)).toFixed(2));
switch (ctrlsymbol.getValue()) {

case '+':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrlempty_timber.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854))

+((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854))) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}else{

ctrlempty_timber.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854))) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}

case '-':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrlempty_timber.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)) +((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/2)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}else{

ctrlempty_timber.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/2)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}

case '/':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrlempty_timber.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)) +((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/4)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}else{

ctrlempty_timber.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/4)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}

case '':

if (ctrlbuckle_length.getValue() > 0 && (ctrlempty_torso.getValue() > 0 ) ) {

ctrlempty_timber.setValue((((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)) +((ctrllength.getValue() 0.1) - (ctrlbuckle_length.getValue() 0.01)) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/8)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}else{

ctrlempty_timber.setValue(((ctrllength.getValue() 0.1) ((ctrlempty_torso.getValue() 0.01) (ctrlempty_torso.getValue() 0.01) (0.7854)/8)) .toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}

case '':

if (ctrlsymbol.getValue()=='' && ctrlbuckle_length.getValue() > 0 ) {

ctrlempty_timber.setValue(((ctrlbuckle_length.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (ctrlaverage_diameter.getValue() 0.01) (0.7854)).toFixed(2));

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}

if (ctrlsymbol.getValue()=='' && ctrlbuckle_length.getValue() ==0 ) {

ctrlempty_timber.setValue(0);

ctrlsolid_wood.setValue((ctrlvolume.getValue() - ctrlempty_timber.getValue()).toFixed(2));

break;

}

}

}

};

ctrllength.on('keyup', func);

ctrltrail_degreess1.on('keyup', func);

ctrltrail_degreess2.on('keyup', func);

ctrltrail_degreese1.on('keyup', func);

ctrltrail_degreese2.on('keyup', func);

ctrlsymbol.on('keyup', func);

ctrlempty_torso.on('keyup', func);

ctrlbuckle_length.on('keyup', func);

ctrlod.on('keyup', func);

ctrlaverage_diameter.on('keyup', func);

ctrlvolume.on('keyup', func);

ctrlempty_timber.on('keyup', func);

ctrlsolid_wood.on('keyup', func);
Before program two:

function func() {

var ctrlinvoice_qty = Runner.getControl(pageid, 'invoice_qty');

var ctrlinvoice_price = Runner.getControl(pageid, 'invoice_price');

var ctrlinvoice_sum = Runner.getControl(pageid, 'invoice_sum');

var ctrlinvoice_tax = Runner.getControl(pageid, 'invoice_tax');

var ctrlinvoice_amount = Runner.getControl(pageid, 'invoice_amount');

var ctrlinvoice_no = Runner.getControl(pageid, 'invoice_no');
if ( ctrlinvoice_qty.getValue()!='' )
ctrlinvoice_sum.setValue(Math.round(ctrlinvoice_qty.getValue()) Math.round(ctrlinvoice_price .getValue()));

ctrlinvoice_tax.setValue(Math.round(ctrlinvoice_sum.getValue()) 0.05);

ctrlinvoice_amount.setValue(Math.round(ctrlinvoice_sum.getValue())+(Math.round(ctrlinvoice_tax.getValue())));
ctrlinvoice_qty.on('keyup', func);

ctrlinvoice_price.on('keyup', func);

ctrlinvoice_sum.on('keyup', func);

ctrlinvoice_tax .on('keyup', func);

ctrlinvoice_amount.on('keyup', func);

};
Sergey Kornilov admin 6/3/2015

I don't thing anyone can answer this question looking at this wall of code.
What you need to do is to troubleshoot this code to see if there are any syntax or runtime errors there. Here is the article that explains how to do that:

http://xlinesoft.com/phprunner/docs/troubleshooting_javascript_errors.htm
C
 		carrie3800332 author 6/8/2015

Thank you replay

This issue has been resolved~