| # |
Apr 19th 2017, 12:50 |
crazycoder |
inoas, it does not really make sense to me....agents_sectors only has agent_id and sector_id |
| # |
Apr 19th 2017, 12:45 |
Junior |
thanks! |
| # |
Apr 19th 2017, 12:45 |
Junior |
i am as we speak in the aware trait |
| # |
Apr 19th 2017, 12:45 |
inoas |
just for checking |
| # |
Apr 19th 2017, 12:45 |
inoas |
then add debug calls to the muffin footprint vendor code |
| # |
Apr 19th 2017, 12:44 |
Junior |
if exists |
| # |
Apr 19th 2017, 12:44 |
inoas |
10-15mins? |
| # |
Apr 19th 2017, 12:44 |
Junior |
i need to see somehow what data exists inside the footprint |
| # |
Apr 19th 2017, 12:44 |
Junior |
yes... it would take time but if i don't have other option.. |
| # |
Apr 19th 2017, 12:44 |
inoas |
whatever, you get what I mean, isolate the issue ;) |
| # |
Apr 19th 2017, 12:43 |
inoas |
same database |
| # |
Apr 19th 2017, 12:43 |
inoas |
create a git feature branch |
| # |
Apr 19th 2017, 12:43 |
inoas |
and work from there |
| # |
Apr 19th 2017, 12:43 |
inoas |
and a blank users model without plugin maybe even |
| # |
Apr 19th 2017, 12:43 |
inoas |
start with nothing ;p |
| # |
Apr 19th 2017, 12:43 |
Junior |
my user model is AuthAcl.Users |
| # |
Apr 19th 2017, 12:42 |
Junior |
inoas, no, found it somewhere in the docs to load that way |
| # |
Apr 19th 2017, 12:42 |
inoas |
belongsToMany is just a shortcut around hasMany <> belongs to JOIN MODEL belongs to <> hasMany other Model |
| # |
Apr 19th 2017, 12:41 |
inoas |
hasMany |
| # |
Apr 19th 2017, 12:41 |
inoas |
then make it so |
| # |
Apr 19th 2017, 12:39 |
crazycoder |
Agents is not associated with AgentsSectors |
| # |
Apr 19th 2017, 12:38 |
inoas |
is that your users model? |
| # |
Apr 19th 2017, 12:38 |
inoas |
Junior: why do you have a model named Footprints? |
| # |
Apr 19th 2017, 12:38 |
inoas |
and then within that contain Sectors |
| # |
Apr 19th 2017, 12:38 |
inoas |
Agents.AgentsSectors = use select here to only specify agent_id and sector id |
| # |
Apr 19th 2017, 12:38 |
inoas |
try going through the auto join model |
| # |
Apr 19th 2017, 12:37 |
crazycoder |
Agents->find()->contain(the previos code) |
| # |
Apr 19th 2017, 12:37 |
crazycoder |
it is a hbtm relationship |
| # |
Apr 19th 2017, 12:36 |
inoas |
how does your finder look |
| # |
Apr 19th 2017, 12:36 |
crazycoder |
}, |
| # |
Apr 19th 2017, 12:36 |
crazycoder |
return $q->select(['Sectors.name']); |
| # |
Apr 19th 2017, 12:36 |
crazycoder |
'Agents.Sectors' => function($q) { |
| # |
Apr 19th 2017, 12:36 |
crazycoder |
yeah i do that |
| # |
Apr 19th 2017, 12:36 |
Junior |
user |
| # |
Apr 19th 2017, 12:36 |
Junior |
inoas, if i remove from my code $this->loadModel('Footprints'); i no longer get the auto-tables error but i get an empty iser |
| # |
Apr 19th 2017, 12:36 |
inoas |
that's weirdo |
| # |
Apr 19th 2017, 12:36 |
crazycoder |
i only need the name |
| # |
Apr 19th 2017, 12:36 |
crazycoder |
inoas, this is a piece of output right now https://gist.github.com/anonymous/a4fd71a376a5e47ecf54d5bd9d51f853 |
| # |
Apr 19th 2017, 12:35 |
inoas |
you can remove fields with entity or ->select() within contain then |
| # |
Apr 19th 2017, 12:35 |
inoas |
public function findWithCourses(Query $query, $options) { return $query->contain('Memberships')->contain('Memberships.Courses'); } |
| # |
Apr 19th 2017, 12:35 |
crazycoder |
(in AgentsTable) |