| # |
Jun 29th 2017, 09:49 |
slackebot |
:now AND :then"]) ->bind(':now', Time::parse($args['select_date']), 'date') ->bind(':then', (Time::parse($args['select_date']))->addDays(7), 'date'); }]); this works fine. But I want to add max(days) [from PrescriptionItems] value in Prescriptions.created on line no 4. something like this - return $query->andWhere(["DATE(ADDDATE(Prescriptions.created, MAX(PrescriptionItems.days)) BETWE |
| # |
Jun 29th 2017, 09:49 |
 adityapansari |
Hey all. #cakephp3.2 I am using FriendsOfCake/ Search Plugin. I have two tables - Prescriptions and PrescriptionItems PrescriptionItems have days column. Inside PrescriptionsTable, I have - $this->hasMany('PrescriptionItems'); $this->searchManager() ->add('select_date', 'Search.Callback', [ 'callback' => function ($query, $args, $manager) { return $query->andWhere(["Prescriptions.cre |
| # |
Jun 29th 2017, 09:45 |
justrohu |
Hello all I have more than 20000+ records in my table and I want to export all of those record to a csv file. I don't want to use SELECT FILEINTO mysql option. can anyone please suggest me how do I do this. I have optimized the query. the issue is coming in foreach loop that I am using |
| # |
Jun 29th 2017, 09:42 |
jarard |
this is cake 2.x - the model is UserType, if i try any other variation I get "Missing relationship between User and Role" so I think UserType is correct |
| # |
Jun 29th 2017, 09:38 |
adriencs |
UsersTypeS ? |
| # |
Jun 29th 2017, 09:35 |
jarard |
using the above I get: Unknown column 'UserType.alias' in 'field list' |
| # |
Jun 29th 2017, 09:35 |
jarard |
is this the correct way to use a custom model for my 'group' in TinyAuth: https://gist.github.com/spacebiscuit/b35b4374011ea5d73c5cfad3ad347a6d |
| # |
Jun 29th 2017, 09:25 |
marcusgoede |
both screenshots appeared for the same error. I only switched the php version |
| # |
Jun 29th 2017, 09:24 |
adriencs |
:thinking_face: |
| # |
Jun 29th 2017, 09:21 |
adriencs |
green box ? something like XDebug ? |
| # |
Jun 29th 2017, 09:19 |
marcusgoede |
ok thank you for the hint. This helps me for now, but I asked in general if it’s possible to get this green box back |
| # |
Jun 29th 2017, 09:18 |
adriencs |
open /logs/errors.log |
| # |
Jun 29th 2017, 09:17 |
adriencs |
sublime can show you syntax errors with a plugin |
| # |
Jun 29th 2017, 09:16 |
marcusgoede |
no I’m using sublime. I expect PHP errors to show me file and line number. It was there all the time in a box with green background. Now it’s gone |
| # |
Jun 29th 2017, 09:15 |
adriencs |
red underline or something |
| # |
Jun 29th 2017, 09:15 |
adriencs |
your editor don't show syntax errors ? |
| # |
Jun 29th 2017, 08:43 |
neon1024 |
Which Mark though? ;) |
| # |
Jun 29th 2017, 08:41 |
Sebollson |
admad: Oh I see, so basicly design changed, implementation didnt :) |
| # |
Jun 29th 2017, 08:37 |
admad |
*if mark ... |
| # |
Jun 29th 2017, 08:37 |
admad |
probably the reason it behaves like this currently is because afterSaveCommit didn't exist initially |
| # |
Jun 29th 2017, 08:36 |
admad |
sounds reasonable, could be in 3.5 i mark or jose don't see any potential downsides |
| # |
Jun 29th 2017, 08:28 |
Sebollson |
@admad what do you think about that issue ?? |
| # |
Jun 29th 2017, 08:12 |
manuweg |
thanks |
| # |
Jun 29th 2017, 08:12 |
manuweg |
ok. I will give that a go |
| # |
Jun 29th 2017, 08:11 |
neon1024 |
Morning everyone |
| # |
Jun 29th 2017, 08:10 |
admad |
use crud and crud-view plugin and you won't have to bother generating templates for CRUD operations :slightly_smiling_face: |
| # |
Jun 29th 2017, 08:09 |
manuweg |
I have generated it with the table prefix eg. ShopOrderItems |
| # |
Jun 29th 2017, 08:09 |
manuweg |
everything actually works fine until I generate the template code |
| # |
Jun 29th 2017, 08:08 |
admad |
right, so that's not the issue |
| # |
Jun 29th 2017, 08:07 |
manuweg |
'className' => 'Shop.Products' |
| # |
Jun 29th 2017, 08:07 |
manuweg |
'className' => 'Shop.Orders' |
| # |
Jun 29th 2017, 08:07 |
manuweg |
https://thepasteb.in/p/zmh8Vry6RPBsZ |
| # |
Jun 29th 2017, 08:06 |
manuweg |
no it's the plugin |
| # |
Jun 29th 2017, 08:05 |
manuweg |
products are just a model within the the shop plugin |
| # |
Jun 29th 2017, 08:05 |
admad |
nvm, i see 'className' has the Shop prefix |
| # |
Jun 29th 2017, 08:04 |
manuweg |
Shop is the plugin |
| # |
Jun 29th 2017, 08:04 |
admad |
*your |
| # |
Jun 29th 2017, 08:04 |
admad |
manuweg: are you Products and Shops also in the Shop plugin? If you in associations you need to use Shop.Prouducts and Shop.Shops |
| # |
Jun 29th 2017, 07:38 |
manuweg |
thanks for the input |
| # |
Jun 29th 2017, 07:38 |
manuweg |
no worries |
| # |
Jun 29th 2017, 07:38 |
manuweg |
OK |