| # |
Mar 7th 2018, 09:23 |
 birdy247 |
I wondered if there was a more SQL way? |
| # |
Mar 7th 2018, 09:23 |
birdy247 |
File uploaded https://cakesf.slack.com/files/U0T295QA3/F9K9QUA4R/-.php / https://slack-files.com/T053DPNCM-F9K9QUA4R-8ffd466716 |
| # |
Mar 7th 2018, 09:23 |
birdy247 |
@admad This is my plan, but I am using this |
| # |
Mar 7th 2018, 09:21 |
admad |
You can by using the callback filter and building query yourself. |
| # |
Mar 7th 2018, 09:17 |
birdy247 |
but was wondering if its possible to instead (in the query), join firstname and lastname and then perform the Like on that? |
| # |
Mar 7th 2018, 09:16 |
birdy247 |
I know I can use a OR query and the like |
| # |
Mar 7th 2018, 09:16 |
birdy247 |
I am using the search plugin, and am wanting to enable a free text search i.e. "firstname lastname" |
| # |
Mar 7th 2018, 09:15 |
birdy247 |
in our users table we model first_name and last_name |
| # |
Mar 7th 2018, 09:13 |
birdy247 |
I am just trying to think up a use case... |
| # |
Mar 7th 2018, 09:12 |
birdy247 |
@admad I see, so its probably designed for the Crud view |
| # |
Mar 7th 2018, 08:59 |
marcusgoede |
File uploaded https://cakesf.slack.com/files/U260GELVA/F9KQXUZC4/-.php / https://slack-files.com/T053DPNCM-F9KQXUZC4-935c85a6f5 |
| # |
Mar 7th 2018, 08:59 |
marcusgoede |
good morning. anyone has an idea why my collection is not sorted? |
| # |
Mar 7th 2018, 08:56 |
admad |
@birdy247 no, on add/edit it popular vars for filling select options for related models |
| # |
Mar 7th 2018, 08:55 |
admad |
@birdy247 hehe, no problem |
| # |
Mar 7th 2018, 08:47 |
birdy247 |
Is this just a time saver over adding contains in the queries |
| # |
Mar 7th 2018, 08:47 |
birdy247 |
The Crud RelatedModels listener |
| # |
Mar 7th 2018, 08:47 |
birdy247 |
Morning @neon1024 |
| # |
Mar 7th 2018, 08:46 |
bravo-kernel |
:+1::skin-tone-3: |
| # |
Mar 7th 2018, 08:46 |
bravo-kernel |
@admad A promise unkept :,( |
| # |
Mar 7th 2018, 08:45 |
neon1024 |
Morning everypone |
| # |
Mar 7th 2018, 08:40 |
birdy247 |
I had to do something fairly urgent yesterday (which the client now doesnt want!), but will pick this up today and provide feedback :slightly_smiling_face: |
| # |
Mar 7th 2018, 08:39 |
birdy247 |
a day is 48 hours right ;) |
| # |
Mar 7th 2018, 08:39 |
admad |
@birdy247 i ain't gonna greet you cause you lied to me :P |
| # |
Mar 7th 2018, 08:13 |
birdy247 |
Morning |
| # |
Mar 7th 2018, 07:40 |
spexi |
Is it possible to add items to breadcrumbs in controller? |
| # |
Mar 7th 2018, 07:28 |
santosh.madeti |
how to get the last excuted query? |
| # |
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 |