<?php   include_once('../config/db.php');   include_once('../config/check.php');  



if (filter_has_var(INPUT_POST, "submit")) 
    try{
            $date =            htmlspecialchars (strtoupper($_POST['date']));
            $date =            date("Y-m-d", strtotime($date));

            $branch =                   htmlspecialchars ( $_POST['branch']);
            $name =                   htmlspecialchars ( $_POST['name']);
            $code =                   htmlspecialchars ( $_POST['code']);
            $phone =                  htmlspecialchars ( $_POST['phone']);
            $email =                  htmlspecialchars ( $_POST['email']);
         //   $dcurrency =               htmlspecialchars ( $_POST['currency']);
            $pin =                    htmlspecialchars ( $_POST['pinnumber']);
            $vat =                    htmlspecialchars ( $_POST['vatnumber']);
            $address =                htmlspecialchars ( $_POST['address']);
            $location =               htmlspecialchars ( $_POST['location']);
           // $country =                htmlspecialchars ( $_POST['country']);
            
            $sql = 'INSERT INTO admbranch(branch,date,name,code,phone,email,pin,vat,address,location,uid) 
                                   VALUES (:branch,:date,:name,:code,:phone,:email,:pin,:vat,:address,:location,:uid )';
            $conn->prepare($sql)->execute([ 'branch'=>$branch,'date'=>$date,'name' => $name,'code'=>$code,'phone' => $phone ,'email' => $email ,
                                            'pin'=>$pin,'vat'=>$vat ,'address'=>$address,'location'=>$location,'uid'=>$uid ]);
            header("location:admbstore.php");

        } catch(Exception $e) { echo 'Message: ' .$e->getMessage();}

?>

<!DOCTYPE html>
<html>
<head>
<?php include_once('../inc/slink.php');   ?>  
</head>
<body <?php include_once('../inc/snav.php');  ?>
<div class="wrapper">

  <!-- Main Header -->
    <header class="main-header">

    <!-- Logo -->
       <?php include_once('../inc/sbrand.php');   ?>

    <!-- Header Navbar -->
    <?php include_once('../inc/snavbar.php');   ?>

  </header>
 
  <!-- Left side column. contains the logo and sidebar -->
    <aside class="main-sidebar">

    <!-- sidebar: style can be found in sidebar.less -->
     <?php include_once('../inc/smenuc.php');   ?>
    <!-- /.sidebar -->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">

    <section class="content-header">
      <h1>  <i class="fa fa-plus-circle" >  </i> Add Retails / Shops /Store   </h1>
        <ol class="breadcrumb">
               </ol>
    </section>

    <section class="content container-fluid"> 
        <div class="box box-success box-xs">
            <div class="box-body">
                <div class="row">
                <form class="form-horizontal add_form "  action="" method="post"  >
                                                           
                                        <div class="col-sm-3"> 
                                            <label > Date  </label>  
                                            <input type="text"   autocomplete="off" class="form-control datepicker" name="date"   required=""   > 
                                        </div> 
                                        <div class="col-sm-3">
                                            <label>  Select Branch  </label>                               
                                            <select class="form-control  js-example-basic-single "  required="" name="branch" style="width:100%" >
                                                <?php $stmt = $conn->prepare("SELECT * FROM admbranch where guard=1 ");
                                                $stmt->execute(); foreach ($stmt as $row) {?>
                                                        <option></option>
                                                        <option value="<?php echo $row['id']; ?>"><?php
                                                        echo $row['name']; ?></option> <?php } ?>
                                            </select>
                                        </div>                                            
                                                                                                                                        
                                        <div class="col-md-6">
                                            <label > Retails/Store  Name  </label>                          
                                            <input type="text" class="form-control" name="name" required="" autocomplete="off" >
                                        </div> 
                                        <div class="col-md-3">
                                            <label > Retails/Store Code  </label>                          
                                            <input type="text" class="form-control" name="code" required="" autocomplete="off" >
                                        </div> 
                                      
                                        <div class="col-sm-3"> 
                                            <label >  Phone  </label>  
                                                <input type="text"  name="phone" value="" autocomplete="off" class="form-control"   required=""   > 
                                        </div> 
                                        <div class="col-sm-3">   
                                                <label class=""> Email </label>              
                                                    <input type="email" class="form-control " name="email"  autocomplete="off">   
                                        </div>
                                      
                                                                                      
                                        <div class="col-sm-3"> 
                                           <label > PIN Number  </label>  
                                              <input type="text"  name="pinnumber"  autocomplete="off" class="form-control"   required=""   > 
                                        </div>     
                                        <div class="col-sm-3"> 
                                           <label > VAT Number  </label>  
                                              <input type="text"  name="vatnumber"  autocomplete="off" class="form-control"   required=""   > 
                                        </div>                                                       
                                                                                                           
                                        <div class="col-sm-3">   
                                            <label class=""> Address </label>              
                                                <input type="text" class="form-control " name="address"  required="" autocomplete="off">
                                        </div>
                                        <div class="col-sm-3">   
                                            <label class=""> Location  </label>              
                                                <input type="text" class="form-control " name="location"  required="" autocomplete="off">
                                        </div>
                                        <!-- <div class="col-sm-3">
                                            <label>  Country   </label>                               
                                            <select class="form-control  js-example-basic-single   "  required="" name="country" style="width:100%" >
                                                <?php $stmt = $conn->prepare("SELECT * FROM adcountry  ");
                                                $stmt->execute(); foreach ($stmt as $row) {?>
                                                        <option></option>
                                                        <option value="<?php echo $row['id']; ?>"><?php
                                                        echo $row['name']; ?></option> <?php } ?>
                                            </select>
                                        </div> -->
                                     

                            <!-- submit button -->
                            <div class="form-group">                              
                                <div class="col-sm-offset-4 col-sm-10" style="padding:0.5rem;">
                                        <button type="submit"  name="submit" class="btn btn-success col-md-3 subbtn ">  <i class="fa fa-plus"></i>  Add Retail/Store  </button> </div>
                            </div> 
                    </form>               
                </div>
            </div>
        </div>
                                
    </section>

</div>
  <!-- /.content-wrapper -->
  
  <!-- Main Footer -->
  <footer class="main-footer">
    <?php  include_once('../inc/sfooter.php'); ?>
  </footer>
  
</div>
                         
<!-- ./wrapper -->

<!-- REQUIRED JS SCRIPTS -->
<?php include_once('../inc/slinkjs.php') ?>

</body>
</html>