<?php
include 'class/coupon.class.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php include 'header.php';?>
</head>
<body>
<div id="wrapper">
<?php include 'menu.php'; ?>
<?php if (!(he_can('BD'))) {echo "<script>location.href = '403.php';</script>";}?>
<?php
$managerCou = new CouponManager($db);
$res='';
if (isset($_POST["op"])){$res = $managerCou->bd($_POST);}
?>
<!-- Page Content -->
<div id="page-wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Base De Données</h1>
</div>
<!-- /.col-lg-12 -->
<ul class="nav nav-tabs" role="tablist">
<li role="presentation" <?php if (!(isset($_POST["op"]))) echo 'class="active"'; ?> ><a href="#parametres" aria-controls="parametres" role="tab" data-toggle="tab">Paramétres</a></li>
<?php if (isset($_POST["op"])) { ?>
<li role="presentation" <?php if (isset($_POST["op"])) echo 'class="active"'; ?>><a href="#resultat" aria-controls="resultat" role="tab" data-toggle="tab">Résultat</a></li>
<?php } ?>
</ul>
<div class="tab-content">
<div role="tabpanel" class="tab-pane fade in <?php if (!(isset($_POST["op"]))) echo "active"; ?>" id="parametres">
<div class="row hidden-print">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-heading">
</div>
<div class="panel-body">
<table class="table table-striped">
<form name='frm' id='frm' action='' method='post'>
<input type='hidden' name='op' value = 'affichage'>
<tbody>
<tr>
<th>
Afficher
</th>
<td>
<select id="aff" name="aff" class="form-control">
<option value="1">Les numéros de téléphones</option>
<option value="2">Les adresses mail</option>
<option value="3">Les noms et les prénoms</option>
<option value="4">Les prénoms et les noms </option>
</select>
</td>
</tr>
<tr>
<th>
A partir
</th>
<td>
<select id="tab" name="tab" class="form-control">
<option value="1">Des acheteurs</option>
<option value="2">Des inscrit</option>
<option value="3">Des acheteurs et des inscrits</option>
</select>
</td>
</tr>
<tr>
<th>
Séparé par
</th>
<td>
<input type="text" id="sep" name="sep" class="form-control" value=";" title="Séparateur" required>
</td>
</tr>
<tr>
<th>
Paramètres avancés
</th>
<td>
<input type="text" id="avc" name="avc" class="form-control" title="Paramètres avancés" >
<span style="font-weight: normal;font-style: italic;font-size: 11px;"> Utiliser les %; debut% %milieu% %fin</span>
</td>
</tr>
<tr>
<th colspan='2'>
<center><button class="btn btn-primary" type="submit" ><i class="fas fa-eye"></i> Extraire</button></center>
</th>
</tr>
</tbody>
</form>
</table>
<?php
if (isset($_POST["op"]))
{
// echo "<script> document.getElementById('tab').value = '4';</script>";
echo "<script>document.frm.aff.value = '".$_POST["aff"]."'</script>";
echo "<script>document.frm.tab.value = '".$_POST["tab"]."'</script>";
echo "<script>document.frm.sep.value = '".$_POST["sep"]."'</script>";
echo "<script>document.frm.avc.value = '".$_POST["avc"]."'</script>";
}
?>
</div>
<!-- /.table-responsive -->
</div>
</div>
</div>
</div>
<div role="tabpanel" class="tab-pane fade in <?php if (isset($_POST["op"])) echo "active"; ?>" id="resultat">
<div class="row hidden-print">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-heading">
</div>
<div class="panel-body">
<textarea class="form-control code_area" rows="10"><?php echo $res; ?></textarea>
</div>
<!-- /.table-responsive -->
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<!-- jQuery -->
<script src="../bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Metis Menu Plugin JavaScript -->
<script src="../bower_components/metisMenu/dist/metisMenu.min.js"></script>
<!-- Custom Theme JavaScript -->
<script src="../dist/js/sb-admin-2.js"></script>
</body>
</html>