Changes about filters

[yakari007]

• We dont filter with id. Remove ID from query filter.
• If the field is ending with _id this means that this is a id field. And ID fields are not filtered by <> signs.
• ID's are always brought by id_ref this means that if we want to filter by id, we will get id_ref, take object and filter with that id

Example;

    public function accountChannelId($value)
    {
        $accountChannel = AccountChannels::where('id_ref', $value)->first();

        if($accountChannel) {
            return $this->builder->where('accountChannelId', '=', $accountChannel->id);
        }
    }

[HuseyinCanAgdelen]

Needs to be tested @yakari007. Are we sure about generating methods for fields ending with '_id'? I can think of two possible problems:

1. What about columns like representative_id, is there going to be a Representative class?
2. Currently we are generating methods which include $accountChannel = AccountChannel::where('id_ref', $value)->first(); Here, this gives an error because AccountChannel model is not yet generated.

[yakari007]

If we see such a column (representatie_id) we can understand that there should be a relation somehow. However to understand the relation we need to look at foreign keys. If we can find foreign keys we should create a model that extends the table that is connected by foreign key.

For instance; if representative_id is linked to users table with id, this means that basicly this object is a user. But since the name is given different the perspective to the object may be different. To cover that scenario we need to create a new object and extend Users model.

class Representative extends Users {
    ....
}