FM / Table

/var/www/vhosts/ihelp.ro/httpdocs/src/Model/Table/

/var/www/vhosts/ihelp.ro/httpdocs/src/Model/Table

Name	Size	Mode	Actions
AppTable.php	2056	0644	edit dl rm
AwbsTable.php	7076	0644	edit dl rm
BankAccountsTable.php	2622	0644	edit dl rm
BannersTable.php	3464	0644	edit dl rm
CartProductsTable.php	1752	0644	edit dl rm
CartsTable.php	2120	0644	edit dl rm
CategoriesTable.php	2599	0644	edit dl rm
CauseNewsTable.php	1877	0644	edit dl rm
CausesTable.php	3936	0644	edit dl rm
CausesTagsTable.php	1450	0644	edit dl rm
CitiesTable.php	1909	0644	edit dl rm
CountiesTable.php	1186	0644	edit dl rm
DocumentsTable.php	2761	0644	edit dl rm
DonationsTable.php	2965	0644	edit dl rm
GalleryImagesTable.php	11671	0644	edit dl rm
LoginTokensTable.php	1486	0644	edit dl rm
OrderProductsTable.php	1749	0644	edit dl rm
OrdersTable.php	4810	0644	edit dl rm
ProductFavoritesTable.php	2255	0644	edit dl rm
ProductsTable.php	6987	0644	edit dl rm
ProductsTagsTable.php	1466	0644	edit dl rm
ProfilesTable.php	3594	0644	edit dl rm
ProposedCausesTable.php	1793	0644	edit dl rm
SettingsTable.php	1783	0644	edit dl rm
SponsorsActivitiesTable.php	3562	0644	edit dl rm
SponsorsTable.php	1494	0644	edit dl rm
TagsTable.php	906	0644	edit dl rm
UserAddressesTable.php	4183	0644	edit dl rm
UserSocialsTable.php	783	0644	edit dl rm
UsersTable.php	6672	0644	edit dl rm

Edit: /var/www/vhosts/ihelp.ro/httpdocs/src/Model/Table/CitiesTable.php (1909B)

<?php

declare(strict_types=1);

namespace App\Model\Table;

use Cake\ORM\Query;
use Cake\ORM\RulesChecker;
use Cake\ORM\Table;
use Cake\Validation\Validator;

/**
 * Cities Model
 */
class CitiesTable extends Table
{
    /**
     * Initialize method
     */
    public function initialize(array $config): void
    {
        parent::initialize($config);

$this->setTable('cities');
        $this->setDisplayField('name');
        $this->setPrimaryKey('id');

$this->belongsTo('Counties', [
            'foreignKey' => 'county_id',
            'joinType' => 'INNER',
        ]);
        $this->hasMany('UserAddresses', [
            'foreignKey' => 'city_id',
        ]);
    }

/**
     * Default validation rules.
     */
    public function validationDefault(Validator $validator): Validator
    {
        $validator
            ->integer('id')
            ->allowEmptyString('id', null, 'create');

$validator
            ->scalar('name')
            ->maxLength('name', 255)
            ->requirePresence('name', 'create')
            ->notEmptyString('name');

$validator
            ->scalar('county_name')
            ->maxLength('county_name', 255)
            ->requirePresence('county_name', 'create')
            ->notEmptyString('county_name');

$validator
            ->scalar('county_code')
            ->maxLength('county_code', 2)
            ->allowEmptyString('county_code');

$validator
            ->integer('extra_km')
            ->requirePresence('extra_km', 'create')
            ->notEmptyString('extra_km');

return $validator;
    }

/**
     * Returns a rules checker object that will be used for validating
     */
    public function buildRules(RulesChecker $rules): RulesChecker
    {
        $rules->add($rules->existsIn(['county_id'], 'Counties'), ['errorField' => 'county_id']);

return $rules;
    }
}

setTable('cities'); $this->setDisplayField('name'); $this->setPrimaryKey('id'); $this->belongsTo('Counties', [ 'foreignKey' => 'county_id', 'joinType' => 'INNER', ]); $this->hasMany('UserAddresses', [ 'foreignKey' => 'city_id', ]); } /** * Default validation rules. */ public function validationDefault(Validator $validator): Validator { $validator ->integer('id') ->allowEmptyString('id', null, 'create'); $validator ->scalar('name') ->maxLength('name', 255) ->requirePresence('name', 'create') ->notEmptyString('name'); $validator ->scalar('county_name') ->maxLength('county_name', 255) ->requirePresence('county_name', 'create') ->notEmptyString('county_name'); $validator ->scalar('county_code') ->maxLength('county_code', 2) ->allowEmptyString('county_code'); $validator ->integer('extra_km') ->requirePresence('extra_km', 'create') ->notEmptyString('extra_km'); return $validator; } /** * Returns a rules checker object that will be used for validating */ public function buildRules(RulesChecker $rules): RulesChecker { $rules->add($rules->existsIn(['county_id'], 'Counties'), ['errorField' => 'county_id']); return $rules; } }