Soy César Mora's questions

I need to use the DB facade within the tests, however I am getting the errorA facade root has not been set.

I have tried to load the facade in a TestCase extension as follows:

protected function getPackageAliases($app)
    {
        return [
            'DB' => 'Illuminate\Support\Facades\DB'
        ];
    }

    protected function getEnvironmentSetUp($app)
    {
        $app->withFacades();
    }

However, I still keep getting the same error. Given the structure of the application, I require a connection to the database, using mockery is not an option.

I have two tables in the database, one for phrases and one for users, where a user can have many phrases and that phrase only belongs to one user.

I have populated my database with factory to do some tests, but I have noticed that for some records their relations are not loaded, nor the reverse (Phrases => User ; User => Phrases). This only happens with some registers, which seems quite strange to me.

I have checked how the records that do not load their relation in the database are and they look good, related under a foreign key not null and without problems to make the match in SQL.

Relations

// Phrases
public function User() : BelongsTo {
    return $this->belongsTo(User::class, 'user_id');
}

// User
public function Phrases() : HasMany {
    return $this->hasMany(Phrase::class, 'user_id', 'id');
}

Query:

App\Models\User::with('Phrases')->where('id','74e21510-b466-4376-8ad5-2950830853fa')->first();

App\Models\Phrase::with('User')->where('id',573)->first();

Note: When calling the models separately (Models that do not load their relations), both exist and are displayed without problems.

What could be wrong? Why does it only happen with some models and not with all?

Laravel 8.x

I am creating an access token for my user in passport and instead of getting a stringfrom JWTI am getting the token data in format json. Why is this happening?

Token creation:

if(Auth::attempt($credentials)){
    $user = Auth::user();
    $token = $user->createToken('My Token', ['read-phrase'])->accessToken;
    return response()->json(["token" => $token]);
}

The variable $tokenremains as an instance ofLaravel\Sanctum\PersonalAccessToken

What I get as a response from the call tocreateToken()

Laravel\Sanctum\NewAccessToken {#1415
  +accessToken: Laravel\Sanctum\PersonalAccessToken {#478
    #casts: array:2 [
      "abilities" => "json"
      "last_used_at" => "datetime"
    ]
    #fillable: array:3 [
      0 => "name"
      1 => "token"
      2 => "abilities"
    ]
    #hidden: array:1 [
      0 => "token"
    ]
    #connection: "mysql"
    #table: "personal_access_tokens"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: true
    #attributes: array:8 [
      "name" => "My Token"
      "token" => "8063ed4786de4e6ad31a3d355dcc65463db2d6902d84f41d4cc85752fe90b87d"
      "abilities" => "["read-phrase"]"
      "tokenable_id" => "00d1783b-6904-492a-a249-b4e85a3ec70c"
      "tokenable_type" => "App\Models\User"
      "updated_at" => "2020-10-15 21:30:17"
      "created_at" => "2020-10-15 21:30:17"
      "id" => 8
    ]
    #original: array:8 [
      "name" => "My Token"
      "token" => "8063ed4786de4e6ad31a3d355dcc65463db2d6902d84f41d4cc85752fe90b87d"
      "abilities" => "["read-phrase"]"
      "tokenable_id" => "00d1783b-6904-492a-a249-b4e85a3ec70c"
      "tokenable_type" => "App\Models\User"
      "updated_at" => "2020-10-15 21:30:17"
      "created_at" => "2020-10-15 21:30:17"
      "id" => 8
    ]
    #changes: []
    #classCastCache: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    #visible: []
    #guarded: array:1 [
      0 => "*"
    ]
  }
  +plainTextToken: "8|IFDDKth2llbJpG9SgCDXaAWj19KekEhFlCrvDLRW"
}

The documentation of passport indicates that to obtain the token it is necessary to call subsequently ->accessToken;, which returns me:

Laravel\Sanctum\PersonalAccessToken {#478
  #casts: array:2 [
    "abilities" => "json"
    "last_used_at" => "datetime"
  ]
  #fillable: array:3 [
    0 => "name"
    1 => "token"
    2 => "abilities"
  ]
  #hidden: array:1 [
    0 => "token"
  ]
  #connection: "mysql"
  #table: "personal_access_tokens"
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  #perPage: 15
  +exists: true
  +wasRecentlyCreated: true
  #attributes: array:8 [
    "name" => "My Token"
    "token" => "23b10620f2e7b0f59e17337ba2d7b1a2da5ccbfea7a1fc0c95d4ca76f7d8eeb8"
    "abilities" => "["read-phrase"]"
    "tokenable_id" => "00d1783b-6904-492a-a249-b4e85a3ec70c"
    "tokenable_type" => "App\Models\User"
    "updated_at" => "2020-10-15 21:31:52"
    "created_at" => "2020-10-15 21:31:52"
    "id" => 9
  ]
  #original: array:8 [
    "name" => "My Token"
    "token" => "23b10620f2e7b0f59e17337ba2d7b1a2da5ccbfea7a1fc0c95d4ca76f7d8eeb8"
    "abilities" => "["read-phrase"]"
    "tokenable_id" => "00d1783b-6904-492a-a249-b4e85a3ec70c"
    "tokenable_type" => "App\Models\User"
    "updated_at" => "2020-10-15 21:31:52"
    "created_at" => "2020-10-15 21:31:52"
    "id" => 9
  ]
  #changes: []
  #classCastCache: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: []
  #touches: []
  +timestamps: true
  #visible: []
  #guarded: array:1 [
    0 => "*"
  ]
}

I have tried with a totally clean installation of laravel and passport and it has delivered the JWT without major problems.

The output of the call to $user->createToken('My Token')->accessToken;is a JWT like the following:

eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxIiwianRpIjoiN2ZmNjc1Nzc4YzQ5YTY0NjllMWM0ZjhjNWY1YmI0YTEwZTIxZWI3Y2Q2NGYyNzk4MWNhYWNjY2U3NDZjZWYxNmVhY2U4NGJhNWFjZGVjNzMiLCJpYXQiOjE2MDI3OTc1NzAsIm5iZiI6MTYwMjc5NzU3MCwiZXhwIjoxNjM0MzMzNTcwLCJzdWIiOiIxIiwic2NvcGVzIjpbXX0.n-XfuB0iqFxkLdWP925OuIC9Qdsm3nTCPuoIOEyStPf4udd6ym8xVQO6ivExVsLKZPpp__ZUl1xl8MqDLu5bCwrI7prpWKdd6fXtlmorqUNWQ6TJ65ZckBWdCdOs2Stxp8t_8Ojbkpid933ZkA3lyxQIz-h25_axG8ghciftWxfC5awOuKBq4r6PQggXGu9zJdkHdvoRr9YiqysmnSABRj4VqM_Rg5CDIoQ5bpVU8M3VYrYtQ6cgkb5vFP9L4_h7dEvW7LvBXOd8liM5dLVd8o4muok1DieGBDx85Kc_v3tPsUMw5j84rI5LPIKghvmxt637hmASxANoQ1LVSky7fpPOjVSyq2gJ0UO-HrBXtGIkZmEMiEe2Nh307cF6x5ZUPAYa7UhzZETrQAqid8j25gTdu2OxjOfudIZUJPs2WowXSImikEHvKYNv7up96wX3ZpQjsCFeODSlL-G2_wLjtRt_EBM7KwEugylDPydHaKa8iI6LTbFVmP400l3eONwNRcVCzUUMjV3rf5snp2boYTP07kdqcslXc88UPrSNgyEOCUmS8xeaAgbLOiM3fAyfzBSe4qJIoEIb1HH78eGYsH93A_Ae6GdF0GJBReCXyebVdBG2SvoOINZu7tIQYDfuX_HGFMiccnZrdltYOD7gm7xoC4oJ_38OPot9mcNRusE

The difference between the clean install and my "app" is as follows:

1.- I am using UUID for users and passport

2.- I installed Jetstream

3.- I installed LightHouse (Graphql)

How can I give the corresponding format to my token to later use them in the headers with Bearer?

I am working in Laravel passport with personal tokens, the id of my users is of type uuidto prevent them from being guessed.

Everything works fine in relation to the user, the problem comes when generating a token:

$token = $user->createToken('My Token', ['read-phrase'])->accessToken;

When my user id is a inteverything works fine, but when it is uuidI get the following error message:

Illuminate\Database\QueryException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'tokenable_id' at row 1 

I have replaced in all migrations the data type by uuid, to be more specific:

//oauth_auth_codes
$table->uuid('user_id')->index();
$table->uuid('client_id');

//oauth_access_tokens
$table->uuid('user_id')->nullable()->index();
$table->uuid('client_id');

//oauth_clients
$table->uuid('user_id')->nullable()->index();

//oauth_personal_access_clients
$table->uuid('client_id');

Error trace stack:

Illuminate\Database\QueryException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'tokenable_id' at row 1 (SQL: insert into `personal_access_tokens` (`name`, `token`, `abilities`, `tokenable_id`, `tokenable_type`, `updated_at`, `created_at`) values (My Token, 5eaef6980a34301b04b26602d92ed224bf17867121d5f352b60b738ee5af3feb, ["read-phrase"], 00d1783b-6904-492a-a249-b4e85a3ec70c, App\Models\User, 2020-10-15 15:12:49, 2020-10-15 15:12:49)) in file C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Connection.php on line 671

#0 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into `pe...', Array, Object(Closure))
#1 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Connection.php(465): Illuminate\Database\Connection->run('insert into `pe...', Array, Object(Closure))
#2 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Connection.php(417): Illuminate\Database\Connection->statement('insert into `pe...', Array)
#3 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `pe...', Array)
#4 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2871): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `pe...', Array, 'id')
#5 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(1496): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(892): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(857): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(720): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\HasOneOrMany.php(298): Illuminate\Database\Eloquent\Model->save()
#10 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Support\helpers.php(263): Illuminate\Database\Eloquent\Relations\HasOneOrMany->Illuminate\Database\Eloquent\Relations\{closure}(Object(Laravel\Sanctum\PersonalAccessToken))
#11 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\HasOneOrMany.php(299): tap(Object(Laravel\Sanctum\PersonalAccessToken), Object(Closure))
#12 C:\xampp74\htdocs\phrases\vendor\laravel\sanctum\src\HasApiTokens.php(49): Illuminate\Database\Eloquent\Relations\HasOneOrMany->create(Array)
#13 C:\xampp74\htdocs\phrases\app\Http\Controllers\AccountsController.php(38): App\Models\User->createToken('My Token', Array)
#14 [internal function]: App\Http\Controllers\AccountsController->login(Object(Illuminate\Http\Request))
#15 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): call_user_func_array(Array, Array)
#16 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('login', Array)
#17 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Route.php(255): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\AccountsController), 'login')
#18 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Route.php(197): Illuminate\Routing\Route->runController()
#19 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Router.php(691): Illuminate\Routing\Route->run()
#20 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#22 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(127): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(103): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest(Object(Illuminate\Http\Request), Object(Closure), Array)
#25 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(55): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\Http\Request), Object(Closure), 'api', Object(Closure))
#26 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), 'api')
#27 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#28 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Router.php(693): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#29 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Router.php(668): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#30 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Router.php(634): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#31 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Routing\Router.php(623): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#32 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(166): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#33 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#34 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#36 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#37 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 C:\xampp74\htdocs\phrases\vendor\fruitcake\laravel-cors\src\HandleCors.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#43 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Fruitcake\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 C:\xampp74\htdocs\phrases\vendor\fideloper\proxy\src\TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(141): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#48 C:\xampp74\htdocs\phrases\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#49 C:\xampp74\htdocs\phrases\public\index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#50 {main}

What else do I need to change to make token creation with my userid as UUID work?

How can I correctly call the implementation of an abstract function from the parent class? The problem is that I don't quite understand staticand I don't know if I should do it with staticor $this.

<?php
abstract class ParentClass{
    abstract protected function createArray();

    public function printArray(){
        // ACA LLAMO A MI FUNCIÓN ABSTRACTA
        // OPCIÓN 1
        print_r(static::createArray());
        // OPCIÓN 2
        print_r($this->createArray());
    }
} 

class ChildClass extends ParentClass{
    protected function createArray(){
        return [1,2,3,4];
    }
}

$c = new ChildClass();

$c->printArray();

I understand the following, you can correct me if I'm wrong.

self: It refers to the same class at runtime where the word is written, so if I call the abstract function with in my parent class, selfit will give me an error, since it will call its definition.

$this: It refers to the instance of the object, in this case the instance will already have the implementation of the method and that is why it will work.

From what I've read I staticprefer the instantiated class, in this case the child and that's why it works.

Can anyone give me a simple answer of what it really is static?

staticand are $thisthey the same? if not the same... How are they different?

Finally I have noticed that with staticyou can call static properties and methods, while with $thisnot.

Given the following string

var log = `added 20-11-19 10:02 - Lucho Jara : Un golpe de suerte espero despierto. Canción: Luis Jara - Un golpe de suerte
           added 21-12-20 11:52 - baby shark : Baby shark, doo doo doo doo doo doo`;;

The text with which I want to perform the explode is:added 20-11-19 10:02 - Lucho Jara :

The problem is that the date and time 20-11-19 10:02can vary but they will keep the format ( added **-**-** **:** -).

The name of the author after the date mentioned above can also vary (it is the same in length) - Lucho Jara :but the separators - :will always be kept.

Now, if we look at the description that follows, we realize that they could still contain the characters - :for which a traditional explode will not work for us.

Can wildcards be used? Any efficient way to do this?

I'm trying to play a .mp3background for an activity but the audio only lasts 2 or 3 seconds and stops when it actually .mp3lasts 1 min 3 seg. Why does this happen?

    override fun onCreate(savedInstanceState: Bundle?) {
        super.onCreate(savedInstanceState)
        setContentView(R.layout.activity_main)
        val mp = MediaPlayer.create(this, R.raw.suspenso)
        mp.setVolume(100F, 100F)
        mp.start()
    }

If I have one select * from personasthat returns the following:

   Nombre   | Valor
   ----------------- 
    Carlos  |   10
   ----------------- 
    Miguel  |   20

Can I in my query add a specific value - that can be obtained through sub-queries - for each tuple?

    Nombre  | Valor
   ----------------- 
    Carlos  |   10 (+5 #Este numero se trae de una sub-consulta)
   ----------------- 
    Miguel  |   20 (+10, #Este numero se trae de una sub-consulta)

What I want is to get the following:

Nombre  | Valor
   ----------------- 
    Carlos  |   15
   ----------------- 
    Miguel  |   30

I'm trying to create a base class with common methods to then extend all my classes and avoid repeating methods. At the moment I have a filling method and another for obtaining the properties of the class.

These functions also allow you to manipulate the values ​​before assigning/getting the respective value ( Kind of like Laravel does with accessors and mutators ).

The problem is that it only works when the properties of the child class are public and not private or protected. This is so since in a normal class it cannot be ensured that the property exists in the child class and therefore it cannot generate a dependency.

I have tried with a clase abstracta, but since I want my properties of the respective classes to be dynamic it is not what I am looking for.

I finally tried with a trait, but the behavior is the same as with a "normal" class.

Is there an alternative to being able to access the properties of the child classes from the parents?

<?php 
class model{
  protected $classname;
  protected $fillable;
  protected $obtainable;
  const MUTATOR_FUNCTION_PREFIX = "set_";
  const ACCESOR_FUNCTION_PREFIX = "get_";

  function __construct(){
    $this->fillable = [];
    $this->obtainable = [];
  }

  public function fill($params){
    if(gettype($params) != 'array'){
      return null;
    }
    foreach($this->fillable as $property){
      $property_exist = isset($params[$property]); 
      if($property_exist){
        $method = self::MUTATOR_FUNCTION_PREFIX . $property; 
        if(method_exists($this->classname, $method)){
          $this->$property = $this->classname::$method($params[$property]);
        }else{
          $this->$property = $params[$property];
        }
      }
    }
  }

  public function get(){
    $response = new stdClass();
    foreach($this->obtainable as $property){
      $property_exist = isset($this->$property); 
      if($property_exist){
        $method = self::ACCESOR_FUNCTION_PREFIX . $property; 
        if(method_exists($this->classname, $method)){
          $response->$property = $this->classname::$method($this->$property);
        }else{
          $response->$property = $this->$property;
        }
      }
    }
    return $response;
  }
}

class publication extends model {
    public $comment;
    function __construct(){
        $this->fillable = ['comment'];
        $this->obtainable = ['comment'];
    }
}

$publication = new publication();
$publication->fill(["comment" => "This is my first comment"]);
print_r($publication->get());

I need to sign a request, I am using Andy Smith 's Oauth library and I need to generate the authorization for the header.

The problem is that I always get Message signature not valid in my TC, so I guess I'm generating the input parameters wrong to sign the request.

  $method = 'http';
  $url = 'http://cvirtual.cl/mod/lti/service.php';
  $request = new OAuthRequest($method, $url);
  $token = new OAuthToken('asd123', '8cUIaGVLhmg4pe7gqoOu3ldxJTOXyNmu');
  $consumer = new OAuthConsumer('asd123', '8cUIaGVLhmg4pe7gqoOu3ldxJTOXyNmu', 'about:blank');
  $signature = new OAuthSignatureMethod_HMAC_SHA1();
  $request = $request->from_consumer_and_token($consumer, $token, $method, $url);
  $request->sign_request($signature, $consumer, $token);
  echo("<textarea rows='5' cols='100'>{$request->to_header()}</textarea>");

If someone can answer the following questions to better understand the protocol, it would be of great help.

1. Is the method with or without ://? (Ex: http:// or http)
2. Does the url include http://?
3. Is the url of the person issuing the request or the url to whom the request is made?
4. What about friendly routes, should .php be included in the link to sign the petition?

The library gives me the following header:

Authorization: OAuth oauth_version="1.0",oauth_nonce="7243daf569edbad7309bc19fd724244e",oauth_timestamp="1561125182",oauth_consumer_key="asd123",oauth_token="asd123",oauth_signature_method="HMAC-SHA1",oauth_signature="yn0cSIQg3Aj6FIWalE%2FIrktaFbA%3D"

I'm trying to send a request with POSTMAN , should it start with OAuth or directly in the key value parameters like oauth_version?

It is worth mentioning that I am working locally and without HTTPS

Once the respective cron with its functionality has been created, we can assign it a time, which the documentation says is its "execution time"

protected function schedule(Schedule $schedule)
{
    $schedule->command('cron:job')
             ->everyMinute();
}

To execute the Laravel schedule, the server also needs a cron or scheduled task.

So, what is the function of the defined time ->everyMinute()if the cron that will be executed by the server side will actually trigger the execution of our schedule, since our Laravel schedule does not behave like a queue (A command is executed once and it remains operative).

If I set my server side cron time to 1 hour, my laravel schedule would run every 1 hour, not every 1 minute as I have defined within the schedule.

I have the name of an image in the database, which I want to convert to a full path using a function that receives the name of the image and assigns it the previous path on the server.

I am doing my queries with eager loading in cascade table1.table2.table3 so it returns the name of the image, not a url, since to obtain the url I must apply a function.

I've looked through the documentation but haven't found anything that can help me.

How can I modify the model so that it always returns a processed field with a function created by me?

How can I change the name of an application, the name that appears under the icon when an app is going to be opened in the android launcher.

I have added in the app tag

<application android:label="Nombre App">

But the name hasn't changed.

Suppose that throughout the dom I have several links with the same class, how can I know the index that this link is when clicked.

<a href="#seccion" class="section-modchooser-link"></a> // Este seria el indice 0
<a href="#ejemplo" class="section-modchooser-link"></a> // Este seria el indice 1
<a href="#otro-ejemplo" class="section-modchooser-link"></a> // Este seria el indice 2


$('a.section-modchooser-link').on('click',function(e){
    e.preventDefault()
    var clicked = $(this)
})

What I'm looking for: if I click on link 1, know that this link within the dom is number 1

I have an activity in which I need to change the color of several elements, so doing it one by one can be a bit tedious. These elements share a common denominator which is the color from the corresponding resource.

Is it possible to change the value of such a resource programmatically?

For example, make:

<color name="colorTitle">#212121</color>

then take another hexadecimal value and apply it to all elements that have colorTitle .

I can't access the relationship with with from the parent table to the child table, it tells me:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subMeals.meal_id' in 'where clause' (SQL: select * from subComidaswhere subComidas. comida_idin (1, 2))

The strange thing is that I check the models and they are fine. In fact, I can call the relation from the child table with no problems or other food relations.

Meals table model

class comida extends Model
{
protected $table = 'comidas';

protected $fillable = [
    'id',
    'cm_nombre',
    'created_at',
    'us_id',
    'updated_at'
];

// SUS HIJOS
public function planesAlimentarios(){
    return $this->belongsToMany('frust\planesAlimentario');
}

public function alimentos(){
  return $this->belongsToMany('frust\alimento');
}

public function subComida(){
    return $this->hasMany('frust\subComida');
}

// SUS PADRES
public function User(){
    return $this->belongsTo('frust\User','us_id','id');
}
}

Model was daughter:

class subComida extends Model

{
protected $table = 'subComidas';

protected $fillable = [
    'id',
    'sbc_nombre',
    'sbc_porcentaje',
    'created_at',
    'cm_id',
    'updated_at'
];
// SUS HIJOS
// SUS PADRES
    public function Comida(){
        return $this->belongsTo('frust\Comida','cm_id','id');
}
}

As I try to bring the objects from the parent table and it gives me an error:

$comidas = comida::with(['subComida'])->paginate(5);        
    dd($comidas);

How can I try to bring the objects from the child table (and it brings them without problems)

$comidas = subComida::with(['Comida'])->paginate(5);        
    dd($comidas);

I also tried to overwrite the primary keys with $primaryKey

Laravel version: 5.4

I have an error when paging the data, it only loads the first page and then it gives me a MethodNotAllowedHttpException .

I've been tossing it around and can't figure it out.

Route:

Route::post('estados/resultado','consultasController@searchestado')->name('consultas.estado.search');

Controller:

public function searchestado (Request $request){
    $consulta = Order::Estado($request->state, $request->orden, $request->modo)->paginate(5);
    return view('resultadoConsulta')->with('order',$consulta);
}

Scope:

public function scopeEstado($query,$estado,$orden,$modo){
    return $query->where('state','=',$estado)
                 ->where('user_id','=',\Auth::user()->id)
                 ->orderBy($orden,$modo);
}

Loading everything without pagination works fine , I tried to paginate in the socope and the pagination did not work correctly either.

It loads me the values ​​indicated in paginate(5) and the navigation between pages is rendered well but the content of the other pages is not loaded.

I leave a DD in the controller before returning the data to the view:

I have other paginations that work fine, I'm relatively new to this framework and there's something I'm missing, I've looked at the documentation but can't figure it out.

Maybe it shouldn't be with POST because adding the ?page=2 generates the error?

I tried with GET and it didn't work either, when I changed the page the parameters of the query were deleted.

POSTURL:

/consultas/estados/resultado
/consultas/estados/resultado?page=2

GET-URL:

/consultas/estados/resultado?state=En+Camino&orden=buy_date&modo=desc
/consultas/estados/resultado?page=2

Error message when changing pages:

Is there a shorthand way to identify the columns of each table by creating the query like this?

$product = Product::with(['order'])->where('user_id','=',\Auth::user()->id)->find($id);

For example specifying something like this:

->where('order.user_id','=',\Auth::user()->id)

user_id is a field from the order table, the example doesn't work as it doesn't recognize the user_id field .

Or for these type of queries I need to use if or if the buldier DB::

I have a problem when it comes to displaying the error messages of the form with ajax, by traditional http everything goes well but when I do it by ajax and I force an error in the form it tells me 422 Unprocessable Entity as a response but it does not show me the error messages as if it were normal http.

If the form is fine, continue with the controller code, I put a response below to check if it was received correctly by ajax and it did indeed respond to the message.

if ($request->ajax()) {
        return response()->json(['mensaje'=>'validacion pasada wey']);
    }

I reiterate, for normal http everything works fine and it shows me the corresponding validation messages, for example: name cannot be less than 3 characters.

I went through the documentation and quote this part: For a traditional HTTP request, a redirect response will be generated, while a JSON response will be sent for AJAX requests.

I leave my ajax code with which I have been testing the responses:

$('#btn_main').on('click',function(e){
        e.preventDefault();
        var action = $('#mainform').attr('action');
        var method = $('#mainform').attr('method');

        $.ajax({
        beforeSend:function(){
            console.log('before send ok');
        },
        url: action,
        type: method,
        data: $('#mainform').serialize(),
        dataType:'json',

        success:function(respuesta){
            $.each(respuesta,function(name,value){
                console.log('name: '+ name + '\n'+ 'value: '+ value);
            });
        },

        error:function(jqXHR,estado,error){
            console.log('estado error: ' + estado);
            console.log('error de error: ' + error);
        },

        complete:function(jqXHR,estado){
            console.log('estado complete: ' + estado);
        },
        timeout:10000
        });
    });

The way I am validating in the controller is as follows:

$this->validate($request,[
        'tracking' => 'min:3',
        'date' => 'min:6|required'
    ]); 

Do I need to add something extra to the validation in the controller so that it gives me the corresponding response in json?

So I'm showing the errors but I guess if it gives me a json response I'll have to add them with jquery.

@if(count($errors)>0)
    <ul class="alert alert-danger">
    @foreach($errors->all() as $error)
        <li>{{ $error }}</li>
    @endforeach
    </ul>
@endif

I have been practicing laraveland there is something that does not work for me and I do not finish understanding or reviewing the documentation.

It turns out that I want to call the related objects between tables to be able to get their other data, and when I do it findwith a specific id for an object it works, but when I do it with eachfor the entire list it returns the relationships as NULL.

//Here I return NULL

$articles = Article::orderBy('id','DESC')->paginate(5);
$articles->each(function($articles){
    $articles->categorie;
    $articles->user;
});
dd($articles);

// But if I try it like this, it returns the relationships well

$articles = Article::find(2);
$articles->categorie;
$articles->user;    
dd($articles);