gutterwb-dv.js
Code: Select all
$j(function(){
/* on changing product, retrieve unit price from products table and populate unit price field */
$j('#gEstimateID').on('change', function(){
var pid = $j('#gEstimateID').val();
if (pid == ''){
$j('#gename').val('');
$j('#geaddress').val('');
$j('#gephone').val('');
$j('#geemail').val('');
$j('#gegatecode').val('');
$j('#gesubdv').val('');
$j('#geprice').val('');
$j('#geestmname').val('');
$j('#geestmdate').val('');
$j('#gecomment').val('');
}else{
var pid = $j('#gEstimateID').val();
$j.ajax({
url: 'hooks/ajax-gutterajax.php',
data: { pid: pid },
success: function(data){
$j('#gename').val('data[1]');
$j('#geaddress').val('data[2]');
$j('#gephone').val('data[3]');
$j('#geemail').val('data[4]');
$j('#gegatecode').val('data[5]');
$j('#gesubdv').val('data[6]');
$j('#geprice').val('data[7]');
$j('#geestmname').val('data[8]');
$j('#geestmdate').val('data[9]');
$j('#gecomment').val('data[10]');
}
});
}
});
});
Code: Select all
<?php
$currDir = dirname(__FILE__) . '/..';
include("$currDir/defaultLang.php");
include("$currDir/language.php");
include("$currDir/lib.php");
$pid = $_REQUEST['pid'];
$data[1] = sql("SELECT name FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[2] = sql("SELECT address FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[3] = sql("SELECT phone FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[4] = sql("SELECT email FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[5] = sql("SELECT gatecode FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[6] = sql("SELECT subdv FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[7] = sql("SELECT price FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[8] = sql("SELECT estmname FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[9] = sql("SELECT estamdate FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
$data[10] = sql("SELECT comment FROM EstimatesHO WHERE EstimateID = '{$pid}'", $eo);
echo $data;
?>