| Line 558... |
Line 558... |
| 558 |
u.state,u.city,u.pincode,
|
558 |
u.state,u.city,u.pincode,
|
| 559 |
ua.state,ua.city,ua.pincode
|
559 |
ua.state,ua.city,ua.pincode
|
| 560 |
from retailers r left join retaileraddresses ra on r.id=ra.retailer_id
|
560 |
from retailers r left join retaileraddresses ra on r.id=ra.retailer_id
|
| 561 |
join retailerlinks rl on r.id=rl.retailer_id
|
561 |
join retailerlinks rl on r.id=rl.retailer_id
|
| 562 |
right join users u on rl.user_id=u.id
|
562 |
right join users u on rl.user_id=u.id
|
| 563 |
left join useraddresses ua on u.id=ua.user_id
|
563 |
left join user_addresses ua on u.id=ua.user_id
|
| 564 |
where u.id=$userId";
|
564 |
where u.id=$userId";
|
| 565 |
$retailerAddress=$this->User->query($masterQuery);
|
565 |
$retailerAddress=$this->User->query($masterQuery);
|
| 566 |
$users[$key]['User']['retailer_id']=$retailerAddress[0]['rl']['retailer_id'];
|
566 |
$users[$key]['User']['retailer_id']=$retailerAddress[0]['rl']['retailer_id'];
|
| 567 |
if($retailerAddress[0]['ra']['city']==null && $retailerAddress[0]['ra']['state']==null && $retailerAddress[0]['ra']['pin']==null){
|
567 |
if($retailerAddress[0]['ra']['city']==null && $retailerAddress[0]['ra']['state']==null && $retailerAddress[0]['ra']['pin']==null){
|
| 568 |
if($retailerAddress[0]['r']['city']==null && $retailerAddress[0]['r']['state']==null && $retailerAddress[0]['r']['pin']==null){
|
568 |
if($retailerAddress[0]['r']['city']==null && $retailerAddress[0]['r']['state']==null && $retailerAddress[0]['r']['pin']==null){
|