| # |
Jun 11th 2018, 13:14 |
veve |
slackebot, I'm working on a very very big database and I need to optimize storage as much as possible |
| # |
Jun 11th 2018, 13:14 |
 dereuromark |
tinyint(1) should always equal bool |
| # |
Jun 11th 2018, 13:13 |
dereuromark |
enum and others, I mean |
| # |
Jun 11th 2018, 13:13 |
dereuromark |
instead change the schema, fix it to tinyint(2) for bool and others |
| # |
Jun 11th 2018, 13:13 |
dereuromark |
why? I think you have the wrong attempt on this |
| # |
Jun 11th 2018, 13:12 |
veve |
Hello, is there a way to change CakePhp 3 behaviour so that it does not "treat" tinyint as boolean (except by modifying the database structure) ? |
| # |
Jun 11th 2018, 12:59 |
lorenzo |
what’s a semi-month? |
| # |
Jun 11th 2018, 12:58 |
admad |
well then i have no idea what a "semi-month" is, good luck |
| # |
Jun 11th 2018, 12:57 |
madrid988 |
I will create a function to do so |
| # |
Jun 11th 2018, 12:57 |
madrid988 |
admad: some semi-months have more more than 14 days, so adding +1 month +2 weeks would not be correct. |
| # |
Jun 11th 2018, 12:50 |
Arckame |
(sorry, my english isn't very good) |
| # |
Jun 11th 2018, 12:49 |
Arckame |
e, 'prefix' => false, '_ext' => false, )" |
| # |
Jun 11th 2018, 12:49 |
Arckame |
I have some issue with debugKit and cakephp 3.6.5, composer dependencies are clean, the debugkit icon is availble in the bottom right, but with the error message "Error: DebugKitController could not be found.", the error.log return "Controller class DebugKit could not be found. Exception Attributes: array ( 'class' => 'DebugKit', 'plugin' => fals |
| # |
Jun 11th 2018, 12:48 |
admad |
don't think there's a method like `addFortnight()` (which is what i assume you mean by "semi-month") |
| # |
Jun 11th 2018, 12:47 |
admad |
+1 month, +2 weeks would be one way |
| # |
Jun 11th 2018, 12:44 |
madrid988 |
Using chronos, how can I add 3 'semi-months' to a DateTime? |
| # |
Jun 11th 2018, 12:42 |
Arckame |
hello |
| # |
Jun 11th 2018, 12:27 |
josbeir |
;) |
| # |
Jun 11th 2018, 12:27 |
mohitprakashsharma555 |
@tim @josbeir Thanks for response guys i got a solution :slightly_smiling_face: $states = $this->Counties->States->find('list',['keyField' => 'id','valueField' =>'state'])->toArray(); |
| # |
Jun 11th 2018, 12:26 |
kitcat711 |
ok, trying |
| # |
Jun 11th 2018, 12:26 |
edgaras.jan |
in hasMany() |
| # |
Jun 11th 2018, 12:26 |
kitcat711 |
du to some "historical choices", the result may not be the same every where :) |
| # |
Jun 11th 2018, 12:25 |
kitcat711 |
in the hasMany declaration? or can I do it in the contain? |
| # |
Jun 11th 2018, 12:24 |
edgaras.jan |
add 'propertyName' |
| # |
Jun 11th 2018, 12:23 |
kitcat711 |
while using a contain, how can I change the property name? Example: Notices hasMany Receipts I want my result in the property "'receipt_accounting_records' instead of 'receipts' |
| # |
Jun 11th 2018, 12:21 |
kitcat711 |
hello |
| # |
Jun 11th 2018, 12:15 |
adrienlambertwac |
In your function uploadFile you must set $team to the view like this $this->set(‘team’, $team) |
| # |
Jun 11th 2018, 12:12 |
adrienlambertwac |
And when you debug the entity in the view, she is empty? |
| # |
Jun 11th 2018, 12:12 |
edgaras.jan |
joopm: and matching() is not necessary, only where() |
| # |
Jun 11th 2018, 12:12 |
josbeir |
@tim you need to upgrade your google :rolling_on_the_floor_laughing: |
| # |
Jun 11th 2018, 12:10 |
tim |
Ugh don't know how I got on 2.0 cakebook >.< |
| # |
Jun 11th 2018, 12:10 |
edgaras.jan |
joopm: remove 'finder' from $this->belongsTo('CompanyTypes', []); and use finder in controller `$this->Companies->find('external')` |
| # |
Jun 11th 2018, 12:10 |
josbeir |
@mohitprakashsharma555 => https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#finding-key-value-pairs |
| # |
Jun 11th 2018, 12:09 |
lorenzo |
joomp it is difficult to help you if you don;t answer the questions I ask |
| # |
Jun 11th 2018, 12:09 |
tim |
https://book.cakephp.org/2.0/en/models/model-attributes.html#displayfield |
| # |
Jun 11th 2018, 12:09 |
mohitprakashsharma555 |
$states = $this->Counties->States->find('list', ['limit' => 200]); |
| # |
Jun 11th 2018, 12:08 |
mohitprakashsharma555 |
i am getting id on this relaction i want name how i can set name fields $this->belongsTo('States', [ 'foreignKey' => 'state_id', 'joinType' => 'INNER' ]); |
| # |
Jun 11th 2018, 12:07 |
joopm |
but i need to pre filter in the model |
| # |
Jun 11th 2018, 12:07 |
edgaras.jan |
and remove matching(), leave only `return $query->where(['CompanyTypes.id' => 1]);` |
| # |
Jun 11th 2018, 12:07 |
joopm |
that would not work,i want that i want to filter companies by their type,i know i can make a find in the controller and pass to the template |
| # |
Jun 11th 2018, 12:05 |
edgaras.jan |
joopm: try moving finder to CompanyTypesTable |