Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- header('Content-Type: text/html; charset=utf-8');
- include("con.php"); //insert data server
- try {
- // read from products table
- $sqlproducts = "SELECT product_name, product_number FROM products ORDER BY product_name ASC";
- $stmt1 = $pdo->prepare($sqlproducts);
- $stmt1->execute();
- $resultsproducts = $stmt1->fetchAll(PDO::FETCH_ASSOC);
- // read from suppliers table
- $sqlsuppliers = "SELECT supplier_name, ID FROM suppliers ORDER BY supplier_name ASC";
- $stmt2 = $pdo->prepare($sqlsuppliers);
- $stmt2->execute();
- $resultssupliers = $stmt2->fetchAll(PDO::FETCH_ASSOC);
- if($_SERVER['REQUEST_METHOD'] == 'POST') {
- $pdo->beginTransaction();
- $prodnumber = $_REQUEST["output"];
- $suppliernumber = $_REQUEST["output1"];
- $amount = $_POST['amount'];
- $project_number = 0;
- $amount_out = 0;
- /*
- echo "Prod:";
- echo $prodnumber;
- echo '<br>';
- echo "Supplier:";
- echo $suppliernumber;
- echo '<br>';
- echo "Amount:";
- echo $amount;
- echo '<br>';
- */
- if(empty($prodnumber) || empty($suppliernumber) || empty($amount)) {
- ?>
- <div id="dialog-message" title="שגיאה">
- <p align="right">
- <span class="ui-icon ui-icon-circle-close" style="float:right; margin:0 7px 50px 0;"></span>
- יש למלא את כל השדות
- </p>
- </div>
- <?php
- } else {
- $sql = "INSERT INTO inventory_stock (product_number, supplier_ID, project_number, amount_in, amount_out) VALUES (:product_number, :supplier_ID, :project_number, :amount_in, :amount_out)";
- $stmt = $pdo->prepare($sql);
- $stmt->execute(['product_number' => $prodnumber, 'supplier_ID' => $suppliernumber, 'project_number' => $project_number, 'amount_in' => $amount, 'amount_out' => $amount_out]);
- $pdo->commit();
- ?>
- <div id="dialog-message" title="הצלחה">
- <p align="right" >
- <span class="ui-icon ui-icon-circle-check" style="float:right; margin:0 7px 50px 0;"></span>
- נקלט בהצלחה
- </p>
- </div>
- <?php
- }
- }
- $prodnumber = "";
- $suppliernumber = "";
- $amount = "";
- }
- catch(Exception $e){
- $pdo->rollBack();
- ?>
- <div id="dialog-message" title="שגיאה">
- <p align="right">
- <span class="ui-icon ui-icon-circle-close" style="float:right; margin:0 7px 50px 0;"></span>
- שגיאה! לא נעשה עדכון
- </p>
- </div>
- <?php
- echo "<br>" . 'N° : '.$e->getCode();
- echo "<br>" . 'Error : '.$e->getMessage();
- $pdo = null;
- }
- ?>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <link rel = "stylesheet" type = "text/css" href = "myStyle.css"/>
- <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
- <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
- <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
- <title>הכנסה למלאי</title>
- <style>
- .form-control {
- border: -1px solid #ccc;
- text-align: right;
- }
- </style>
- </head>
- <body>
- <form action="" method="POST" class="form-style-9">
- <div align="right">
- <H1 align="right">מלאי נכנס</H1>
- <ul>
- <li>
- <!-- שם מוצר ושמירת המק"ט -->
- <select class="field-style field-split align-left" name='productsnumber' onChange='outputValue(this)'>
- <option value='' selected disabled>בחר מוצר</option>
- <?php foreach($resultsproducts as $row)
- {
- echo "<option value='" . $row['product_number'] . "'>" . $row['product_name'] . "</option>";
- }?>
- </select>
- <input type='hidden' id='output' name='output' readonly />
- </li>
- <li>
- <!-- שם הספק -->
- <select class="field-style field-split align-right" name='suppliersnumber' onChange='outputValue1(this)'>
- <option value='' selected disabled>בחר שם הספק</option>
- <?php foreach($resultssupliers as $row)
- {
- echo "<option value='" . $row['ID'] . "'>" . $row['supplier_name'] . "</option>";
- }?>
- </select>
- <input type='hidden' id='output1' name='output1' readonly />
- <input type="number" name="amount" placeholder="הכנס כמות" class="field-style field-split align-left " />
- <li>
- <input type="submit" value="הכנס מלאי חדש" style = "font-size:20px; float:right">
- </li>
- </ul>
- </div>
- </form>
- </body>
- </html>
- <script>
- function outputValue(item)
- {
- document.getElementById('output').value = item.value;
- }
- function outputValue1(item)
- {
- document.getElementById('output1').value = item.value;
- }
- $( function(){
- $( "#dialog-message" ).dialog({
- modal: true,
- buttons: {
- Ok: function() {
- $( this ).dialog( "close" );
- }
- }
- });
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement