| # |
Feb 4th 2018, 01:12 |
ahmed_bodi |
the core of the issue was actually using varchar's for the id's due to an auth plugin i had used prior, but removed all the old crap and convertedit all back to int's and now all works great |
| # |
Feb 4th 2018, 01:12 |
 ricksaccous |
@itamer ->first only returns one result.. how are you getting null? what returns null exactly? that code you posted? |
| # |
Feb 4th 2018, 01:11 |
ahmed_bodi |
i finally got it |
| # |
Feb 4th 2018, 01:11 |
ahmed_bodi |
@hmic your awesome |
| # |
Feb 4th 2018, 00:45 |
slackebot |
, 'conditions' => ['Memberships.id' => 'Individuals.membership_id'] ] , 'Finances' => [ 'table' => 'finances' , 'type' => 'INNER' , 'conditions' => ['Finances.membership_id' => 'Memberships.id'] ]]) ->order(['Finances.enddate' => 'DESC']) ->first(); |
| # |
Feb 4th 2018, 00:45 |
itamer |
$user = $this->find() ->select(['Individuals.id', 'Individuals.email', 'Individuals.password', 'Finances.enddate']) ->where([ 'Individuals.email' => $email , 'Individuals.status IN' => ['g','m'] , 'Memberships.softdelete' => 'N' ]) ->join([ 'Memberships' => [ 'table' => 'memberships' , 'type' => 'INNER' |
| # |
Feb 4th 2018, 00:45 |
itamer |
aargh, I just broke something. I'll past the code below. It's in a table file, if I debug to get the query and run it I get 3 results. but the cake3 query returns null. Any ideas? |
| # |
Feb 4th 2018, 00:44 |
ahmed_bodi |
:) |
| # |
Feb 4th 2018, 00:44 |
popperz0r |
thanks |
| # |
Feb 4th 2018, 00:44 |
popperz0r |
yep! :P |
| # |
Feb 4th 2018, 00:43 |
popperz0r |
content type json? |
| # |
Feb 4th 2018, 00:43 |
popperz0r |
https://book.cakephp.org/3.0/en/views/json-and-xml-views.html#creating-json-views |
| # |
Feb 4th 2018, 00:43 |
popperz0r |
its on the docs |
| # |
Feb 4th 2018, 00:43 |
popperz0r |
```// View code - src/Template/Articles/json/index.ctp foreach ($articles as and$article) { unset($article->generated_html);``` |
| # |
Feb 4th 2018, 00:42 |
popperz0r |
nono |
| # |
Feb 4th 2018, 00:41 |
ahmed_bodi |
.json extension? |
| # |
Feb 4th 2018, 00:40 |
popperz0r |
why does some of my ajax auto trigger /json view files and some dont? |
| # |
Feb 4th 2018, 00:40 |
popperz0r |
i also have a json doubt :) |
| # |
Feb 4th 2018, 00:30 |
hippo |
Anyone here using CRUD JSONAPI? |
| # |
Feb 4th 2018, 00:18 |
ahmed_bodi |
i've got the user's primary key id's in the referrer_id fields where the links are supposed to be |
| # |
Feb 4th 2018, 00:18 |
ahmed_bodi |
@hmic, ok so ive mapped parent_id to my referrer_id field, and ive added the lft and rght fields. I've also run users->recover() and none of the fields are becoming populated so now im lost |
| # |
Feb 4th 2018, 00:08 |
ahmed_bodi |
parent_id i imaging in my case would be referrer_id |
| # |
Feb 4th 2018, 00:06 |
hmic |
;-) |
| # |
Feb 4th 2018, 00:06 |
hmic |
which can be used to build the tree initially from existing data |
| # |
Feb 4th 2018, 00:06 |
hmic |
parent_id is already there - might be different name |
| # |
Feb 4th 2018, 00:06 |
ahmed_bodi |
will give it a shot sure |
| # |
Feb 4th 2018, 00:05 |
hmic |
you got the idea now? |
| # |
Feb 4th 2018, 00:05 |
ahmed_bodi |
ok so add lft and rght |
| # |
Feb 4th 2018, 00:05 |
hmic |
and it would have been working already ;-) |
| # |
Feb 4th 2018, 00:04 |
hmic |
and run repair on the tree with your current data |
| # |
Feb 4th 2018, 00:04 |
ahmed_bodi |
fml coding on no sleep is screwing me over |
| # |
Feb 4th 2018, 00:04 |
hmic |
just add the 2 fields to the users table |
| # |
Feb 4th 2018, 00:04 |
hmic |
it ought to be easy for you |
| # |
Feb 4th 2018, 00:04 |
ahmed_bodi |
... your kidding |
| # |
Feb 4th 2018, 00:04 |
hmic |
should be the same now! |
| # |
Feb 4th 2018, 00:03 |
ahmed_bodi |
correct |
| # |
Feb 4th 2018, 00:03 |
hmic |
user and referer was the same table to start with, true? |
| # |
Feb 4th 2018, 00:03 |
ahmed_bodi |
ah no, i split the referrer stuff out into its own table |
| # |
Feb 4th 2018, 00:03 |
hmic |
which is the one we are talking about? your user table which holds a tree structure now |
| # |
Feb 4th 2018, 00:03 |
ahmed_bodi |
dont i need the id of the referrer in the referrer table for the children query? |
| # |
Feb 4th 2018, 00:03 |
ahmed_bodi |
that was the get of the user id |