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) {