public static function getByName($name)
{
$sql = "select * from " . self::$tablename . " where name=\"{$name}\"";
$query = Executor::doit($sql);
$found = null;
$data = new AlbumData();
while ($r = $query->fetch_array()) {
$data->id = $r['id'];
$data->nick = $r['nick'];
$data->name = $r['name'];
$data->mail = $r['mail'];
$data->password = $r['password'];
$data->usertype = UserTypedata::getById($r['usertype_id']);
$data->status = StatusData::getById($r['status_id']);
$data->is_admin = $r['is_admin'];
$data->is_verified = $r['is_verified'];
$data->created_at = $r['created_at'];
$found = $data;
break;
}
return $found;
}
</td>
</tr>
</table>
<br>
</div>
</div>
<div class="row">
<div class="col-md-12">
<form class="form-horizontal" role="form" method="post" action="index.php?action=changestatus">
<div class="form-group">
<label for="inputEmail1" class="col-md-3 control-label">Estado</label>
<div class="col-md-6">
<select name="status_id" class="form-control">
<?php
foreach (StatusData::getAll() as $s) {
?>
<option value="<?php
echo $s->id;
?>
" <?php
if ($s->id == $buy->status_id) {
echo "selected";
}
?>
><?php
echo $s->name;
?>
</option>
<?php
}
public function getStatus()
{
return StatusData::getById($this->status_id);
}
<div class="row">
<div class="col-md-12">
<h1>BIENVENIDO A KATANA</h1>
<p>Katana es un sistema de tienda en linea.</p>
<?php
$status = StatusData::getAll();
if (count($status) > 0) {
?>
<div class="panel panel-default">
<div class="panel-heading">
<i class="fa fa-th-list"></i> Operaciones
</div>
<div class="widget-body medium no-padding">
<div class="table-responsive">
<table class="table table-bordered">
<tbody>
<thead>
<th>Estado</th>
<th>Cantidad</th>
</thead>
<?php
foreach ($status as $cat) {
?>
<tr>
<td><?php
echo $cat->name;
?>
</td>
public static function getAllLikeName($username)
{
$sql = "select * from " . self::$tablename . " where name like '%{$username}%'";
$query = Executor::doit($sql);
$array = array();
$cnt = 0;
while ($r = $query->fetch_array()) {
$array[$cnt] = new UserData();
$array[$cnt]->id = $r['id'];
$array[$cnt]->nick = $r['nick'];
$array[$cnt]->name = $r['name'];
$array[$cnt]->mail = $r['mail'];
$array[$cnt]->image = $r['image'];
$array[$cnt]->password = $r['password'];
$array[$cnt]->usertype_id = UserTypeData::getById($r['usertype_id']);
$array[$cnt]->status_id = StatusData::getById($r['status_id']);
$array[$cnt]->is_admin = $r['is_admin'];
$array[$cnt]->is_verified = $r['is_verified'];
$array[$cnt]->created_at = $r['created_at'];
$cnt++;
}
return $array;
}
</div>
</div>
<div class="container">
<div class="row">
<div class="col-md-12">
<?php
if ($buy->status_id == 1) {
?>
<p class="alert alert-warning">Operacion Pendiente</p>
<?php
} elseif ($buy->status_id >= 2 && $buy->status_id <= 4) {
?>
<p class="alert alert-info"><?php
echo StatusData::getById($buy->status_id)->name;
?>
</p>
<?php
} elseif ($buy->status_id == 5) {
?>
<p class="alert alert-danger">Operacion Cancelada</p>
<?php
}
?>
<h2> Compra #<?php
echo $buy->id;
?>
</h2>
<?php
if (count($products) > 0) {
