beginTransaction();
$transid_sql = "select mxin_inter_trans_seq.nextval as transid from dual";
$transid_stmt = sql_debug($db,$transid_sql);
$transid_result = $transid_stmt->fetch(PDO::FETCH_ASSOC);
$transid = $transid_result['TRANSID'];
$meterinsert_sql = "insert into cf_meter_iface (assetnum, changeby, dorollover,
inspector, isdelta, measuredate, metername, newreading, newreadingdate,
orgid, siteid, transid, transseq) values (
:assetnum, :changeby, 0, :inspector, :isdelta, to_date(:readingdate,'YYYY-MM-DD'),
:metername, :newreading, to_date(:readingdate||' '||to_char(sysdate,'HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS'), 'UMC','CF',:transid,:transseq)";
sql_debug($db, $meterinsert_sql, array(':assetnum'=>$_POST['assetnum'],':changeby'=>'MAXIMO',
':inspector'=>$pawprint,':isdelta'=>1,':metername'=>$_POST['fueltype'],
':newreading'=>$_POST['fuelquantity'],':readingdate'=>$_POST['transdate'],
':transid'=>$transid, ':transseq'=>2));
sql_debug($db, $meterinsert_sql, array(':assetnum'=>$_POST['assetnum'],':changeby'=>'MAXIMO',
':inspector'=>$pawprint,':isdelta'=>1,':metername'=>'FUELCOST',
':newreading'=>$_POST['fuelcost'],':readingdate'=>$_POST['transdate'],
':transid'=>$transid, ':transseq'=>3));
$mx_intertrans_insert_sql = "insert into mxin_inter_trans (extsysname, ifacename, transid, action) values
('CF_TRANSPORTATION','MXMETERInterface',:transid,'AddChange')";
sql_debug($db, $mx_intertrans_insert_sql,array(':transid'=>$transid));
$db->commit();
}
function save_csv()
{
// $csv_file = '/home/graumannc/www/infolib.new/sysdev/mf_csv/fuelcsv' . date("m.d.y") . '.csv';
// $fd = fopen($csv_file, "a");
// $linevalue = '"'.$_POST['assetnum'].'","'.$_POST['transdate'].'","'.$_POST['fueltype'].'",'.$_POST['fuelquantity'].','.$_POST['fuelcost'].','.$_POST['odometer'].',"'.$_POST['pawprint'].'","'.date("m/d/y").'"';
// fwrite($fd, $linevalue . "\n");
// fclose($fd);
}
if($_POST) {
if(!validate_vehicle()) {
$invalid['vehicle']=true;
}
if(!validate_transdate()) {
$invalid['transdate']=true;
}
if(!validate_fueltype()) {
$invalid['fueltype']=true;
}
if(!validate_fuelquantity()) {
$invalid['fuelquantity']=true;
}
if(!validate_fuelcost()) {
$invalid['fuelcost']=true;
}
if(!validate_pawprint()) {
$invalid['pawprint']=true;
}
if(!$invalid) {
save_meters();
//save_csv();
sleep(2);
$saved=true;
}
}
?>
Campus Facilities InfoLibrary
Connection failed: &emdash; SQLSTATE[42S02]: pdo_oci_handle_factory: ORA-12154: TNS:could not resolve the connect identifier specified
(/builddir/build/BUILD/php-7.1.33/ext/pdo_oci/oci_driver.c:640)