# |
Mar 7th 2018, 07:27 |
slackebot |
=> array('u.id', 'Patient.first_name', 'Patient.last_name'), 'order' => array('Patient.last_name ASC', 'Patient.first_name ASC')); How can I display the original mysql query? |
# |
Mar 7th 2018, 07:27 |
slackebot |
$conditions['Patient.user_id'], ), 'u.id' => $conditions['Patient.user_id']), 'OR' => array( array('Patient.first_name LIKE' => '%'.$this -> data['Patient']['search_by_keywords'].'%', ), 'Patient.last_name LIKE' => '%'.$this -> data['Patient']['search_by_keywords'].'%'),'AND' => array('Patient.is_active = 1'),'AND' => array('Patient.user_id = '.$conditions['Patient.user_id'],'Patient.is_active = 1') ), 'fields' |
# |
Mar 7th 2018, 07:27 |
santosh.madeti |
Hi my project was built on Cakephp 1.3 , Some one wrote the below query to get list of records. $this -> paginate = array('joins' => array( array('table' => 'users', 'alias' => 'u', 'type' => 'left', 'foreignKey' => false, 'conditions' => array('Patient.user_id = u.id','Patient.is_active' => 1))), 'conditions' => array($conditions['Patient.is_active'] = 1, 'OR' => array( array('u.created_by' => |
# |
Mar 7th 2018, 07:17 |
megan |
@norman.cis10 have you checked out http://cakephpjobs.com/ |
# |
Mar 7th 2018, 07:16 |
megan |
Morning everyone :slightly_smiling_face: |
# |
Mar 7th 2018, 06:22 |
norman.cis10 |
for the same |
# |
Mar 7th 2018, 06:22 |
norman.cis10 |
Please add me on Job board |
# |
Mar 7th 2018, 06:22 |
norman.cis10 |
Hello to All |
# |
Mar 7th 2018, 06:06 |
ricksaccous |
@kailas are you using wkhtmltopdf? |
# |
Mar 7th 2018, 04:48 |
richellyitalo |
Hello |
# |
Mar 7th 2018, 03:09 |
etipaced |
@kailas I don’t have a DPI set, but I do set page size. |
# |
Mar 7th 2018, 03:01 |
kailas |
I’m trying to use CakePdf but all the PDF rendered views are being generated with too small of text. I think this might have to do with the DPI passed to the pdf engine. anyone have experience with this and where to pass it (if that’s the issue)? |
# |
Mar 7th 2018, 00:20 |
dereuromark |
sth like https://github.com/dereuromark/cakephp-sandbox/blob/3.0/src/Model/Table/UsersTable.php#L64 |
# |
Mar 7th 2018, 00:20 |
rafael.junqueira.sant |
that will be useful information |
# |
Mar 7th 2018, 00:20 |
rafael.junqueira.sant |
thank you |
# |
Mar 7th 2018, 00:20 |
rafael.junqueira.sant |
alright! |
# |
Mar 7th 2018, 00:20 |
dereuromark |
Table classes in /Model/Table |
# |
Mar 7th 2018, 00:19 |
dereuromark |
in the tables |
# |
Mar 7th 2018, 00:18 |
rafael.junqueira.sant |
where is this file, that is created by bake command line? |
# |
Mar 7th 2018, 00:17 |
rafael.junqueira.sant |
where can I write code for relations, so a controller can contain a related table? |
# |
Mar 7th 2018, 00:16 |
dereuromark |
You can write one :slightly_smiling_face: |
# |
Mar 7th 2018, 00:16 |
dereuromark |
Nah, if it aint in the docs, then probably not even on some blog posts |
# |
Mar 7th 2018, 00:16 |
rafael.junqueira.sant |
haha |
# |
Mar 7th 2018, 00:15 |
dereuromark |
oh and here I thought its the latest `js framework` I missed |
# |
Mar 7th 2018, 00:14 |
rafael.junqueira.sant |
@dereuromark, do you know a guide somewhere for cases like this? |
# |
Mar 7th 2018, 00:13 |
rafael.junqueira.sant |
I feel bad to bend the english name like that as well, but since I don't know yet how it will affect the whole not to bend it... |
# |
Mar 7th 2018, 00:12 |
rafael.junqueira.sant |
haha dereuromark, these are the initial of my middle name and surname |
# |
Mar 6th 2018, 23:59 |
dereuromark |
Bending the "english" language too much for the sake of one line less - I usually dont go that way. |
# |
Mar 6th 2018, 23:58 |
dereuromark |
as for your issue: you can always define things manually - this way you go around the conventions - if it helps in a situation why not |
# |
Mar 6th 2018, 23:57 |
dereuromark |
@rafael.junqueira.sant the fact that you have `js` in your name makes me wanna run away :P |
# |
Mar 6th 2018, 23:56 |
dereuromark |
you can composer require that branch and test it on your project |
# |
Mar 6th 2018, 23:55 |
etipaced |
Ok. I’ve never contributed before, so I’ll see about getting things setup so I can review. |
# |
Mar 6th 2018, 23:54 |
rafael.junqueira.sant |
@dereuromark, can you help me with the question I asked above? |
# |
Mar 6th 2018, 23:52 |
dereuromark |
you can also confirm if it works the way you want/need it |
# |
Mar 6th 2018, 23:52 |
dereuromark |
yes, it does |
# |
Mar 6th 2018, 23:51 |
etipaced |
Definitely related. Does 10877 need contribution still? |
# |
Mar 6th 2018, 23:45 |
dereuromark |
seems related to https://github.com/cakephp/cakephp/pull/11780 and https://github.com/cakephp/cakephp/issues/10877 |
# |
Mar 6th 2018, 23:43 |
etipaced |
What is the correct way to convert user data into UTC? |
# |
Mar 6th 2018, 23:43 |
etipaced |
When user supplied datetime values are marshaled into entity properties as FrozenTime objects, Cake is assuming the timezone is UTC, but this isn’t the case as the user is assuming that the value is in PST. So my object is erroneous: ``` object(Cake\I18n\FrozenTime) { 'time' => '2018-04-01T16:00:00+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false } ``` |
# |
Mar 6th 2018, 22:58 |
rafael.junqueira.sant |
the documentation has an example with users (user_favorite_pages), but in this case the controller will be able to contain the Users data, but in my case, what makes me confused is what is the convention for multiple words tables so they can be contained by the controllers they are related to |
# |
Mar 6th 2018, 22:52 |
rafael.junqueira.sant |
Hello! I have the following situation: a page named For Whom. I wanted to call the table for_whoms, and the table with translations I'd call for_whom_translations, is this the right way to do it? I want ForWhomTranslationsController to contain ForWhoms and be able to access it. |