| # |
Nov 8th 2019, 10:34 |
 dereuromark |
Going to release TinyAuth next generation auth plugin if someone wants to give early feedback before I release the major? Ideally the ones already using it and checking BC etc. |
| # |
Nov 8th 2019, 10:31 |
dev.cyrusjayson |
ok |
| # |
Nov 8th 2019, 10:31 |
graziel |
bin/cake orm_cache clear |
| # |
Nov 8th 2019, 10:31 |
dev.cyrusjayson |
how? |
| # |
Nov 8th 2019, 10:31 |
graziel |
try clearing orm cache |
| # |
Nov 8th 2019, 10:31 |
dev.cyrusjayson |
do I need to compile something? |
| # |
Nov 8th 2019, 10:30 |
dev.cyrusjayson |
what is going on. kinda frustrating |
| # |
Nov 8th 2019, 10:30 |
dev.cyrusjayson |
even here I can’t see the user_id ``` $this->paginate = [ 'contain' => ['Customers', 'Statuses', 'Users'] ]; $orders = $this->paginate($this->Orders); $this->set(compact('orders')); ``` |
| # |
Nov 8th 2019, 10:29 |
dev.cyrusjayson |
it is not a field. it is association in users model |
| # |
Nov 8th 2019, 10:28 |
slackebot1 |
'foreignKey' => 'user_id' ]); $this->hasMany('Suborders', [ 'foreignKey' => 'order_id' ]); } ``` |
| # |
Nov 8th 2019, 10:28 |
dev.cyrusjayson |
``` public function initialize(array $config) { parent::initialize($config); $this->setTable('orders'); $this->setDisplayField('id'); $this->setPrimaryKey('id'); $this->belongsTo('Customers', [ 'foreignKey' => 'customer_id' ]); $this->belongsTo('Statuses', [ 'foreignKey' => 'status_id' ]); $this->belongsTo('Users', [ |
| # |
Nov 8th 2019, 10:28 |
dev.cyrusjayson |
``` |
| # |
Nov 8th 2019, 10:28 |
slackebot1 |
$validator; } ``` |
| # |
Nov 8th 2019, 10:28 |
dev.cyrusjayson |
``` public function validationDefault(Validator $validator) { $validator ->integer('id') ->allowEmptyString('id', null, 'create'); $validator ->scalar('name') ->maxLength('name', 255) ->allowEmptyString('name'); $validator ->scalar('code') ->maxLength('code', 45) ->allowEmptyString('code'); return |
| # |
Nov 8th 2019, 10:27 |
challgren |
‘user’ isn’t though |
| # |
Nov 8th 2019, 10:27 |
dev.cyrusjayson |
yes ``` protected $_accessible = [ 'user_id' => true, 'name' => true, 'customer_id' => true, 'status_id' => true, 'remarks' => true, 'is_paid' => true, 'date_created' => true, 'customer' => true, 'status' => true, 'suborders' => true ]; ``` |
| # |
Nov 8th 2019, 10:27 |
challgren |
is the field accessible? |
| # |
Nov 8th 2019, 10:26 |
dev.cyrusjayson |
it just seems cake don’t know user_id added |
| # |
Nov 8th 2019, 10:26 |
dev.cyrusjayson |
there is no error though |
| # |
Nov 8th 2019, 10:26 |
dev.cyrusjayson |
I cant see it also. and I have association that gives user as null. but the user_id is not also there |
| # |
Nov 8th 2019, 10:25 |
challgren |
Check `$entity>errors()` |
| # |
Nov 8th 2019, 10:25 |
dev.cyrusjayson |
I added new field name user_id in table [11:14 AM] it is not saving [11:14 AM] even I was passing the data |
| # |
Nov 8th 2019, 10:12 |
jotpe |
Hey :wave: |
| # |
Nov 8th 2019, 09:31 |
dereuromark |
If they can be null why are they relevant for the query? ;) i think this is a design issue in most cases. |
| # |
Nov 8th 2019, 09:25 |
spriz |
I would assume the performance of such query is not great :) :) |
| # |
Nov 8th 2019, 09:25 |
roel |
Oh thanks :) |
| # |
Nov 8th 2019, 09:24 |
roel |
@spriz the date columns can be `null` |
| # |
Nov 8th 2019, 09:19 |
spriz |
@roel but one way could be this: https://gist.github.com/Spriz/3862a1bee5a8d67ef7b85434e61be9ad |
| # |
Nov 8th 2019, 09:14 |
noel |
@martonmiklosqdev I suggest you use xdebug in that case. Not sure why the line numbers aren't showing up correctly for you. This happens to me in JavaScript quite often and it's very annoying. I've never seen it in PHP. |
| # |
Nov 8th 2019, 09:13 |
spriz |
@roel does the date column really have `0` and not `null` in the DB? |
| # |
Nov 8th 2019, 08:59 |
roel |
`SELECT * FROM `<table>` WHERE `<fk_id>` IN (1,2)` ` ORDER BY GREATEST(COALESCE(`<date_column_1>`, 0), COALESCE(`<date_column_2>`, 0)) DESC` ` LIMIT 10` |
| # |
Nov 8th 2019, 08:59 |
roel |
The query is as follows: |
| # |
Nov 8th 2019, 08:59 |
roel |
Hello everyone, I have a SQL query that I would like to convert to a cakephp (3.6) query, but I have no clue how to do it and if it is even possible. |
| # |
Nov 8th 2019, 08:19 |
javier.villanueva |
I think that your models are different than the models im thinking |
| # |
Nov 8th 2019, 08:18 |
javier.villanueva |
morning all |
| # |
Nov 8th 2019, 06:36 |
conehead |
Morning! |
| # |
Nov 8th 2019, 06:17 |
alexdd55976 |
Morning |
| # |
Nov 8th 2019, 01:50 |
ndm |
Check `$context['newRecord']` |
| # |
Nov 8th 2019, 01:47 |
francisdoydora |
thanks in advance for your help :slightly_smiling_face: |
| # |
Nov 8th 2019, 01:47 |
francisdoydora |
if update, allowEmptyFile. Else if create, follow the validator rule I posted. |
| # |
Nov 8th 2019, 01:37 |
slackebot1 |
(isset($context['data']['academic_level_id'])) { return $context['data']['academic_level_id'] === '1'; } return true; })``` |