|
|
<?php header("Access-Control-Allow-Origin: *"); header("Content-type: application/vnd.fdf"); header("Cache-Control: no-cache, must-revalidate"); $host = '127.0.0.1'; $db = 'valucalcprices'; $user = 'valucalcreader'; $pass = 'readerpassword'; $charset = 'utf8mb4'; $options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,]; $dsn = "mysql:host=$host;dbname=$db;charset=$charset"; $pdo = new PDO($dsn, $user, $pass, $options); date_default_timezone_set('America/Los_Angeles'); $StatMsg = date('d-m-y h:i:s'); $series = "Diamonds"; $gemtype = "Diamond"; $cuttype = $_POST["CutType"]; $weight = $_POST["Weight"]; $quality = $_POST["Quality"]; $color = $_POST["Color"]; $sql = "select Price from PriceGrid WHERE Series = :series and GemType = :gemtype and CutType = :cuttype and WeightLower <= :weight and WeightUpper > :weight and Quality = :quality and Color = :color"; $stmt = $pdo->prepare($sql); $stmt->execute(['series' => $series, 'gemtype' => $gemtype, 'cuttype' => $cuttype, 'weight' => $weight, 'quality' => $quality, 'color' => $color]); $records = $stmt->fetchAll(PDO::FETCH_ASSOC); $price = $records[0]['Price']; ?> %FDF-1.2 1 0 obj <</FDF <?php echo "<</Fields[<</T(Status)/V($StatMsg)>> <</T(PerCaratPrice)/V($price)>>]>>"; ?> >> endobj trailer << /Root 1 0 R >> %%EOF ---------- <?php header("Access-Control-Allow-Origin: *"); header("Content-type: application/vnd.fdf"); header("Cache-Control: no-cache, must-revalidate"); $endpoint = 'convert'; $access_key = 'YOURFIXER.IOACCESSKEY'; date_default_timezone_set('America/Los_Angeles'); $StatMsg = date('d-m-y h:i:s'); $from = $_POST["From"]; $to = $_POST["To"]; $amount = $_POST["OneUSDollar"]; $ch = curl_init('https://data.fixer.io/api/'.$endpoint.'?access_key='.$access_key.'&from='.$from.'&to='.$to.'&amount='.$amount.''); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $json = curl_exec($ch); curl_close($ch); $conversionResult = json_decode($json, true); $rate = $conversionResult ['info']['rate']; ?> %FDF-1.2 1 0 obj <</FDF <?php echo "<</Fields[<</T(Status)/V($StatMsg)>> <</T(Result)/V($rate)>>]>>"; ?> >> endobj trailer << /Root 1 0 R >> %%EOF ---------- <?php header("Access-Control-Allow-Origin: *"); header("Content-type: application/vnd.fdf"); header("Cache-Control: no-cache, must-revalidate"); $host = "127.0.0.1"; $db = 'classicmodels'; $user = 'classicmodelsuser01'; $pass = 'user01password'; $charset = 'utf8'; $options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,]; $dsn = "mysql:host=$host;dbname=$db;charset=$charset"; $pdo = new PDO($dsn, $user, $pass, $options); date_default_timezone_set('America/Los_Angeles'); $StatMsg = date('d-m-y h:i:s'); $customerNumber = $_POST["CustomerNumber"]; $sql = "select customerNumber, customerName, contactLastName, contactFirstName, phone, addressLine1, addressLine2, city, state, postalCode, country, creditLimit, accountsPayable from customers WHERE customerNumber = :customerNumber"; $stmt = $pdo->prepare($sql); $stmt->bindValue(':customerNumber',(int) $customerNumber, PDO::PARAM_INT); $stmt->execute(); $records = $stmt->fetchAll(PDO::FETCH_ASSOC); $customername = $records[0]['customerName']; $contactlastname = $records[0]['contactLastName']; $contactfirstname = $records[0]['contactFirstName']; $phone = $records[0]['phone']; $addressline1 = $records[0]['addressLine1']; $addressline2 = $records[0]['addressLine2']; $city = $records[0]['city']; $state = $records[0]['state']; $postalcode = $records[0]['postalCode']; $country = $records[0]['country']; $creditlimit = $records[0]['creditLimit']; $accountspayable = $records[0]['accountsPayable']; ?> %FDF-1.2 1 0 obj <</FDF <?php echo "<</Fields[<</T(Status)/V($StatMsg)>> <</T(CustomerName)/V($customername)>> <</T(ContactLastName)/V($contactlastname)>> <</T(ContactFirstName)/V($contactfirstname)>> <</T(Phone)/V($phone)>> <</T(AddressLine1)/V($addressline1)>> <</T(AddressLine2)/V($addressline2)>> <</T(City)/V($city)>> <</T(State)/V($state)>> <</T(PostalCode)/V($postalcode)>> <</T(Country)/V($country)>> <</T(CreditLimit)/V($creditlimit)>> <</T(AccountsPayable)/V($accountspayable)>> ]>>"; ?> >> endobj trailer << /Root 1 0 R >> %%EOF ---------- <?php header("Access-Control-Allow-Origin: *"); header("Content-type: application/vnd.fdf"); header("Cache-Control: no-cache, must-revalidate"); $host = "127.0.0.1"; $db = 'salesorders'; $user = 'user01'; $pass = 'user01password'; $charset = 'utf8mb4'; $options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,]; $dsn = "mysql:host=$host;dbname=$db;charset=$charset"; $pdo = new PDO($dsn, $user, $pass, $options); date_default_timezone_set('America/Los_Angeles'); $StatMsg = date('d-m-y h:i:s'); $productnumber = $_POST["ProductNumberLine01"]; $linenumber = "01"; $sql = "select ProductNumber, ProductName, RetailPrice, QuantityOnHand from Products WHERE productnumber = :productnumber"; $stmt = $pdo->prepare($sql); $stmt->execute(['productnumber' => $productnumber]); $records = $stmt->fetchAll(PDO::FETCH_ASSOC); $productname = $records[0]['ProductName']; $retailprice = $records[0]['RetailPrice']; $quantityonhand = $records[0]['QuantityOnHand']; ?> %FDF-1.2 1 0 obj <</FDF <?php echo "<</Fields[<</T(Status)/V($StatMsg)>> <</T(ProductNameLine$linenumber)/V($productname)>> <</T(RetailPriceLine$linenumber)/V($retailprice)>> <</T(QuantityOnHandLine$linenumber)/V($quantityonhand)>>]>>"; ?> >> endobj trailer << /Root 1 0 R >> %%EOF ---------- <?php header("Access-Control-Allow-Origin: *"); header("Content-type: application/vnd.fdf"); //header("Content-Type: application/json; charset=utf8mb4"); header("Cache-Control: no-cache, must-revalidate"); $host = "127.0.0.1"; $db = 'salesorders'; $user = 'user01'; $pass = 'user01password'; $port = "3306"; $charset = "utf8mb4"; $options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, // PDO::ATTR_EMULATE_PREPARES => FALSE, // PDO::MYSQL_ATTR_INIT_COMMAND => 'SET sql_mode="STRICT_TRANS_TABLES"', ]; $dsn = "mysql:host=$host;dbname=$db;charset=$charset;port=$port"; $pdo = new PDO($dsn, $user, $pass, $options); date_default_timezone_set('America/Los_Angeles'); $status = date('m/d/Y h:i:s a', time()); $productnumber01 = $_POST["ProductNumberLine01"]; $quantityonhand01 = $_POST["QuantityOnHandLine01"]; $quantityordered01 = $_POST["QuantityLine01"]; $newquantityonhand01 = $quantityonhand01 - $quantityordered01; $productnumber02 = $_POST["ProductNumberLine02"]; $quantityonhand02 = $_POST["QuantityOnHandLine02"]; $quantityordered02 = $_POST["QuantityLine02"]; $newquantityonhand02 = $quantityonhand02 - $quantityordered02; $productnumber03 = $_POST["ProductNumberLine03"]; $quantityonhand03 = $_POST["QuantityOnHandLine03"]; $quantityordered03 = $_POST["QuantityLine03"]; $newquantityonhand03 = $quantityonhand03 - $quantityordered03; try{ $pdo->beginTransaction(); $sql = "UPDATE Products SET QuantityOnHand = ?, Status = ? WHERE ProductNumber = ?"; $stmt = $pdo->prepare($sql); $stmt->execute(array($newquantityonhand01,$status,$productnumber01)); $sql = "UPDATE Products SET QuantityOnHand = ?, Status = ? WHERE ProductNumber = ?"; $stmt = $pdo->prepare($sql); $stmt->execute(array($newquantityonhand02,$status,$productnumber02)); $sql = "UPDATE Products SET QuantityOnHand = ?, Status = ? WHERE ProductNumber = ?"; $stmt = $pdo->prepare($sql); $stmt->execute(array($newquantityonhand03,$status,$productnumber03)); $pdo->commit(); $message = "The Quantity On Hand values for all 3 items have been decremented by"; } catch(Exception $e){ $message= "Error"; $pdo->rollBack(); } ?> %FDF-1.2 1 0 obj <</FDF <?php echo "<</Fields[<</T(Status)/V($status - $message $user)>> <</T(QuantityOnHandLine01)/V($newquantityonhand01)>> <</T(QuantityOnHandLine02)/V($newquantityonhand02)>> <</T(QuantityOnHandLine03)/V($newquantityonhand03)>> ]>> "; ?> >> endobj trailer << /Root 1 0 R >> %%EOF |
|