| Line 552... |
Line 552... |
| 552 |
foreach($postOfficeResult as $value){
|
552 |
foreach($postOfficeResult as $value){
|
| 553 |
$postOffice[$value['postoffices']['pincode']]=$value['postoffices']['state'];
|
553 |
$postOffice[$value['postoffices']['pincode']]=$value['postoffices']['state'];
|
| 554 |
}
|
554 |
}
|
| 555 |
foreach ($users as $key => $value) {
|
555 |
foreach ($users as $key => $value) {
|
| 556 |
$userId=$value['User']['id'];
|
556 |
$userId=$value['User']['id'];
|
| 557 |
$masterQuery="select u.id,r.state,r.city,r.pin,
|
557 |
$masterQuery="select u.id,rl.retailer_id,r.state,r.city,r.pin,
|
| 558 |
ra.state,ra.city,ra.pin,
|
558 |
ra.state,ra.city,ra.pin,
|
| 559 |
u.state,u.city,u.pincode,
|
559 |
u.state,u.city,u.pincode,
|
| 560 |
ua.state,ua.city,ua.pincode
|
560 |
ua.state,ua.city,ua.pincode
|
| 561 |
from retailers r left join retaileraddresses ra on r.id=ra.retailer_id
|
561 |
from retailers r left join retaileraddresses ra on r.id=ra.retailer_id
|
| 562 |
join retailerlinks rl on r.id=rl.retailer_id
|
562 |
join retailerlinks rl on r.id=rl.retailer_id
|
| 563 |
right join users u on rl.user_id=u.id
|
563 |
right join users u on rl.user_id=u.id
|
| 564 |
left join useraddresses ua on u.id=ua.user_id
|
564 |
left join useraddresses ua on u.id=ua.user_id
|
| 565 |
where u.id=$userId";
|
565 |
where u.id=$userId";
|
| 566 |
$retailerAddress=$this->User->query($masterQuery);
|
566 |
$retailerAddress=$this->User->query($masterQuery);
|
| 567 |
|
- |
|
| - |
|
567 |
$users[$key]['User']['retailer_id']=$retailerAddress[0]['rl']['retailer_id'];
|
| 568 |
if($retailerAddress[0]['ra']['city']==null && $retailerAddress[0]['ra']['state']==null && $retailerAddress[0]['ra']['pin']==null){
|
568 |
if($retailerAddress[0]['ra']['city']==null && $retailerAddress[0]['ra']['state']==null && $retailerAddress[0]['ra']['pin']==null){
|
| 569 |
if($retailerAddress[0]['r']['city']==null && $retailerAddress[0]['r']['state']==null && $retailerAddress[0]['r']['pin']==null){
|
569 |
if($retailerAddress[0]['r']['city']==null && $retailerAddress[0]['r']['state']==null && $retailerAddress[0]['r']['pin']==null){
|
| 570 |
if($retailerAddress[0]['ua']['city']==null && $retailerAddress[0]['ua']['state']==null && $retailerAddress[0]['ua']['pincode']==null){
|
570 |
if($retailerAddress[0]['ua']['city']==null && $retailerAddress[0]['ua']['state']==null && $retailerAddress[0]['ua']['pincode']==null){
|
| 571 |
if($retailerAddress[0]['u']['city']==null && $retailerAddress[0]['u']['state']==null && $retailerAddress[0]['u']['pincode']==null){
|
571 |
if($retailerAddress[0]['u']['city']==null && $retailerAddress[0]['u']['state']==null && $retailerAddress[0]['u']['pincode']==null){
|
| 572 |
|
572 |
|