<?php
    try {
        if(isset($_POST['suppliername'])) {

            include_once('../backend/Supplier.php');
            include_once('../includes/sanitize.php');
            $supplier = new Supplier();

            $supplier->supplier_name = test_input($_POST['suppliername']);
            $supplier->supplier_email = test_input($_POST['supplieremail']);
            $supplier->supplier_address = test_input($_POST['supplieraddress']);
            $supplier->supplier_contact = test_input($_POST['suppliercontact']);
            $supplier->supplier_status =
            $supplier->add_new_supplier();
        }
    } catch (Exception $exception) {
        echo('failed to insert data!');
    }


?>




<?php include_once('head_section.php');  ?>
    <!-- PAGE CONTENT BEGINS -->


    <h4 class="header blue lighter bigger">
        <i class="ace-icon fa fa-users blue"></i>
        Add New Supplier
    </h4>


    <form method="post" class="form-horizontal" action="supplier.php">
        <div class="form-group">
            <label for="suppid" class="control-label col-sm-2">Supplier ID:</label>
            <div class="col-sm-6">
                <input type="text" class="form-control" name="supplierid" id="suppid" disabled>
            </div>
        </div>
        <div class="form-group">
            <label for="suppname" class="control-label col-sm-2">Supplier Name:</label>
            <div class="col-sm-6">
                <input type="text" class="form-control" name="suppliername" id="suppname" required>
            </div>
        </div>
        <div class="form-group">
            <label for="suppemail" class="control-label col-sm-2">Supplier Email:</label>
            <div class="col-sm-6">
                <input type="email" class="form-control" name="supplieremail" id="suppemail" required>
            </div>
        </div>
        <div class="form-group">
            <label for="suppadd" class="control-label col-sm-2">Supplier Address:</label>
            <div class="col-sm-6">
                <input type="text" class="form-control" name="supplieraddress" id="suppadd" required>
            </div>
        </div>
        <div class="form-group">
            <label for="suppcontact" class="control-label col-sm-2">Supplie Contact Number:</label>
            <div class="col-sm-6">
                <input type="text" class="form-control" name="suppliercontact" id="suppcontact" required>
            </div>
        </div>
        <div class="form-group">
            <label class="control-label col-sm-2" for="stali" >Supplier Status:</label>
            <select name="stopt" class="input-large col-sm-3" id="stali" style="margin-left: 15px;" required>
                <option value="">-- select supplier status --</option>
                <option value="pending">Pending</option>
                <option value="active">Active</option>
            </select>
        </div>
        <div class="form-group">
            <div class="col-sm-offset-2 col-sm-10">
                <button type="submit" class="btn btn-white btn-success btn-bold btn-round"><i class="ace-icon fa fa-save bigger-120 green"></i>Save</button>
                <button type="reset" class="btn btn-white btn-default btn-bold btn-round"><i class="ace-icon fa fa-undo bigger-120 red2"></i>Reset</button>
                <button type="button" class="btn btn-white btn-primary btn-bold btn-round"><i class="ace-icon fa fa-eye bigger-120 blue"></i>View</button>
            </div>

        </div>
    </form>



    <!-- PAGE CONTENT ENDS --> <?php  include_once('footer.php'); ?>

include_once('Connection.php');


class Supplier {
    public $supplier_id;
    public $supplier_name;
    public $supplier_email;
    public $supplier_address;
    public $supplier_contact;
    public $supplier_status;


    public function add_new_supplier() {

        //create database object
        $db = new Connection();
        $conn = $db->get_db();

        //prepare and bind
        $stmt = $conn->prepare(
            "INSERT INTO c_supplier (
                        supplier_name,
                        supplier_email,
                        supplier_address,
                        supplier_contact) VALUES (?,?,?,?)");

        //take values from the supplier form
        $supp_name = $this->supplier_name;
        $supp_email = $this->supplier_email;
        $supp_address = $this->supplier_address;
        $supp_contact = $this->supplier_contact;

        //bind parameters
        $stmt->bind_param("ssss", $supp_name, $supp_email, $supp_address, $supp_contact);


        //execute
        $stmt->execute();
        $stmt->close();
        $conn->close();

    }