Beispiel #1
0
 function remove($plan)
 {
     if ($this->countUsuarios($plan) > 0) {
         AppError::write(AppError::PLAN_USO_CANT_DELETE);
     }
     $id = is_object($plan) ? $plan->id : $plan;
     $query = "DELETE FROM usuarios_planes where id = ?";
     return DB::prepareExecute($query, array($id));
 }
Beispiel #2
0
 function remove($obj)
 {
     $id = is_object($obj) ? $obj->id : $obj;
     $query = "DELETE FROM " . $this->from . " where id = ?";
     $rowCount = DB::prepareExecute($query, array($id));
     $r = new stdClass();
     if ($rowCount) {
         $r->ok = TRUE;
     } else {
         $r->error = "No hubo cambios";
     }
     return $r;
 }
 protected function updateRelation($parent, $child, $modelo)
 {
     $query = "UPDATE " . $this->fromRelaciones . " SET cantidad = ?, factor = ? ";
     $params = array($child->cantidad, $child->factor);
     if (isset($child->custom_nombre)) {
         $query .= " , custom_nombre = ? ";
         $params[] = $child->custom_nombre;
     }
     $query .= " WHERE id_sup = ? and id_inf = ? ";
     $params[] = $parent->id;
     $params[] = $child->id;
     DB::prepareExecute($query, $params);
 }
 function remove($user)
 {
     $id = is_object($user) ? $user->id : $user;
     $query = "DELETE FROM usuarios where id = ?";
     return DB::prepareExecute($query, array($id));
 }
 function remove($caratula)
 {
     DB::beginTransaction();
     try {
         if ($this->type == TYPES::USER) {
             $fromDB = $this->getById($caratula->id);
             $usuario = new stdClass();
             $usuario->id = $fromDB->id_usuario;
         }
         $params = array($caratula->id);
         DB::prepareExecute("DELETE FROM " . $this->tables->beneficios . " WHERE id_modelo = ?", $params);
         DB::prepareExecute("DELETE FROM " . $this->tables->gastos . " WHERE id_modelo = ?", $params);
         DB::prepareExecute("DELETE FROM " . $this->tables->relaciones . " WHERE id_modelo = ?", $params);
         DB::prepareExecute("DELETE FROM " . $this->tables->conceptos . " WHERE id_modelo = ?", $params);
         DB::prepareExecute("DELETE FROM " . $this->tables->modelos . " WHERE id = ?", $params);
         if (isset($usuario)) {
             $this->updateCountModelosUsuario($usuario);
         }
         DB::commit();
     } catch (exception $e) {
         DB::rollBack();
         throw new Exception("No se pudo eliminar ");
     }
 }
 function remove($obj)
 {
     $id = is_object($obj) ? $obj->id : $obj;
     $query = "DELETE FROM " . $this->from . " where id = ?";
     return DB::prepareExecute($query, array($id));
 }
 function registerAccess($user)
 {
     $query = 'UPDATE usuarios SET uacceso = NOW() WHERE id = ?';
     DB::prepareExecute($query, array($user->id));
 }
 protected function removeDrafts()
 {
     DB::prepareExecute('DELETE FROM precios_insumos_tmp');
 }
 function consultas()
 {
     $query = "DELETE FROM conceptos_modelos WHERE codigo = '001855' AND id_modelo = 3";
     DB::prepareExecute();
     $query = "DELETE FROM conceptos_modelos WHERE codigo = '001600' AND id_modelo = 3";
     DB::prepareExecute();
     $query = "DELETE FROM conceptos_modelos WHERE codigo = '001804' AND id_modelo = 12";
     DB::prepareExecute();
     $query = "DELETE FROM conceptos_modelos WHERE codigo = '001855' AND id_modelo = 3";
     DB::prepareExecute();
 }
 protected function updatePrecioMaestro($concepto)
 {
     $query = "UPDATE " . $this->from . " SET precio = ?, id_familia = NULL, version = ? WHERE id = ?";
     $version = $concepto->version + 1;
     return DB::prepareExecute($query, array($concepto->precio, $version, $concepto->id));
 }
 protected function popFromModel($concepto)
 {
     // solo se saca del modelo si no esta en uso
     $query = "SELECT count(*) as count FROM " . $this->fromRelaciones . " WHERE id_sup = ? or id_inf = ?";
     $uso = DB::prepareExecuteFetch($query, array($concepto->id, $concepto->id));
     if ($uso->count == 0) {
         $querySelect = "DELETE FROM " . $this->from . " WHERE id = ?";
         DB::prepareExecute($query, array($concepto->id));
     }
 }