| Server IP : 74.208.127.88 / Your IP : 18.117.85.73 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/muebles/pos11/core/app/model/ |
Upload File : |
<div class="row">
<div class="col-md-12">
<div class="btn-group pull-right">
<div class="btn-group pull-right">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
<i class="fa fa-download"></i> Descargar <span class="caret"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a href="report/clients-word.php">Word 2007 (.docx)</a></li>
</ul>
</div>
</div>
<div class="card">
<div class="card-header" data-background-color="blue">
<h4 class="title">Promociones</h4>
</div>
<div class="card-content table-responsive">
<a href="./index.php?view=newreservation" class="btn btn-info">Nueva </a>
<a href="./index.php?view=oldreservations" class="btn btn-default"> Anteriores</a>
<br><br>
<form class="form-horizontal" role="form">
<input type="hidden" name="view" value="reservations">
<?php
$pacients = CategoryData::getAll();
$medics = PersonData::getClients();
?>
<div class="form-group">
<div class="col-lg-2">
<div class="input-group">
<span class="input-group-addon"><i class="fa fa-search"></i></span>
<input type="text" name="q" value="<?php if(isset($_GET["q"]) && $_GET["q"]!=""){ echo $_GET["q"]; } ?>" class="form-control" placeholder="Palabra clave">
</div>
</div>
<div class="col-lg-2">
<div class="input-group">
<span class="input-group-addon"><i class="fa fa-male"></i></span>
<select name="pacient_id" class="form-control">
<option value="">Categorias</option>
<?php foreach($pacients as $p):?>
<option value="<?php echo $p->id; ?>" <?php if(isset($_GET["pacient_id"]) && $_GET["pacient_id"]==$p->id){ echo "selected"; } ?>><?php echo $p->id." - ".$p->name." ".$p->lastname; ?></option>
<?php endforeach; ?>
</select>
</div>
</div>
<div class="col-lg-2">
<div class="input-group">
<span class="input-group-addon"><i class="fa fa-support"></i></span>
<select name="medic_id" class="form-control">
<option value="">Clientes</option>
<?php foreach($medics as $p):?>
<option value="<?php echo $p->id; ?>" <?php if(isset($_GET["medic_id"]) && $_GET["medic_id"]==$p->id){ echo "selected"; } ?>><?php echo $p->id." - ".$p->name." ".$p->lastname; ?></option>
<?php endforeach; ?>
</select>
</div>
</div>
<div class="col-lg-4">
<div class="input-group">
<span class="input-group-addon"><i class="fa fa-calendar"></i></span>
<input type="date" name="date_at" value="<?php if(isset($_GET["date_at"]) && $_GET["date_at"]!=""){ echo $_GET["date_at"]; } ?>" class="form-control" placeholder="Palabra clave">
</div>
</div>
<div class="col-lg-2">
<button class="btn btn-primary btn-block">Buscar</button>
</div>
</div>
</form>
<?php
$users= array();
if((isset($_GET["q"]) && isset($_GET["pacient_id"]) && isset($_GET["medic_id"]) && isset($_GET["date_at"])) && ($_GET["q"]!="" || $_GET["pacient_id"]!="" || $_GET["medic_id"]!="" || $_GET["date_at"]!="") ) {
$sql = "select * from reservation where ";
if($_GET["q"]!=""){
$sql .= " title like '%$_GET[q]%' and note like '%$_GET[q] %' ";
}
if($_GET["pacient_id"]!=""){
if($_GET["q"]!=""){
$sql .= " and ";
}
$sql .= " pacient_id = ".$_GET["pacient_id"];
}
if($_GET["medic_id"]!=""){
if($_GET["q"]!=""||$_GET["pacient_id"]!=""){
$sql .= " and ";
}
$sql .= " medic_id = ".$_GET["medic_id"];
}
if($_GET["date_at"]!=""){
if($_GET["q"]!=""||$_GET["pacient_id"]!="" ||$_GET["medic_id"]!="" ){
$sql .= " and ";
}
$sql .= " date_at = \"".$_GET["date_at"]."\"";
}
$users = ReservationData::getBySQL($sql);
}else{
$users = ReservationData::getAll();
}
if(count($users)>0){
// si hay usuarios
?>
<table class="table table-bordered table-hover">
<thead>
<th>Asunto</th>
<th>Empleado</th>
<th>Usuario</th>
<th>Fecha</th>
<th></th>
</thead>
<?php
foreach($users as $user){
$pacient = $user->getPacient();
$medic = $user->getMedic();
?>
<tr>
<td><?php echo $user->title; ?></td>
<td><?php echo $pacient->name." ".$pacient->lastname; ?></td>
<td><?php echo $medic->name." ".$medic->lastname; ?></td>
<td><?php echo $user->date_at." ".$user->time_at; ?></td>
<td style="width:180px;">
<a href="index.php?view=editreservation&id=<?php echo $user->id;?>" class="btn btn-warning btn-xs">Editar</a>
<a href="index.php?action=delreservation&id=<?php echo $user->id;?>" class="btn btn-danger btn-xs">Eliminar</a>
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
<?php
}else{
echo "<p class='alert alert-danger'>No hay registrados</p>";
}
?>
</div>
</div>