| Line 551... |
Line 551... |
| 551 |
foreach($postOfficeResult as $value){
|
551 |
foreach($postOfficeResult as $value){
|
| 552 |
$postOffice[$value['postoffices']['pincode']]=$value['postoffices']['state'];
|
552 |
$postOffice[$value['postoffices']['pincode']]=$value['postoffices']['state'];
|
| 553 |
}
|
553 |
}
|
| 554 |
foreach ($users as $key => $value) {
|
554 |
foreach ($users as $key => $value) {
|
| 555 |
$userId=$value['User']['id'];
|
555 |
$userId=$value['User']['id'];
|
| 556 |
$retailerLinksQuery="select r.city,r.state,r.pin from retaileraddresses r join retailerlinks rl on r.retailer_id=rl.retailer_id where rl.user_id=$userId";
|
556 |
$masterQuery="select u.id,r.state,r.city,r.pin,
|
| 557 |
$retailerAddress=$this->User->query($retailerLinksQuery);
|
557 |
ra.state,ra.city,ra.pin,
|
| 558 |
if(empty($retailerAddress)){
|
558 |
u.state,u.city,u.pincode,
|
| - |
|
559 |
ua.state,ua.city,ua.pincode
|
| 559 |
$directRetailerAddress="select r.city,r.state,r.pin from retailers r join retailerlinks rl on r.id=rl.retailer_id where rl.user_id=$userId";
|
560 |
from retailers r left join retaileraddresses ra on r.id=ra.retailer_id
|
| 560 |
$retailerDirectAddress=$this->User->query($directRetailerAddress);
|
561 |
join retailerlinks rl on r.id=rl.retailer_id
|
| 561 |
if(empty($retailerDirectAddress)){
|
562 |
right join users u on rl.user_id=u.id
|
| 562 |
$userAddressQuery="select ua.city,ua.state,ua.pincode from useraddresses ua join users u on ua.user_id=u.id where ua.user_id=$userId";
|
563 |
left join useraddresses ua on u.id=ua.user_id
|
| - |
|
564 |
where u.id=$userId";
|
| 563 |
$userUpdateAddress=$this->User->query($userAddressQuery);
|
565 |
$retailerAddress=$this->User->query($masterQuery);
|
| - |
|
566 |
|
| 564 |
if(empty($userUpdateAddress)){
|
567 |
if($retailerAddress[0]['ra']['city']==null && $retailerAddress[0]['ra']['state']==null && $retailerAddress[0]['ra']['pin']==null){
|
| 565 |
$userQuery="select city,state,pincode from users where id=$userId and pincode is not null";
|
568 |
if($retailerAddress[0]['r']['city']==null && $retailerAddress[0]['r']['state']==null && $retailerAddress[0]['r']['pin']==null){
|
| 566 |
$myProfileAddress=$this->User->query($userQuery);
|
569 |
if($retailerAddress[0]['ua']['city']==null && $retailerAddress[0]['ua']['state']==null && $retailerAddress[0]['ua']['pincode']==null){
|
| 567 |
if(empty($myProfileAddress)){
|
570 |
if($retailerAddress[0]['u']['city']==null && $retailerAddress[0]['u']['state']==null && $retailerAddress[0]['u']['pincode']==null){
|
| 568 |
|
571 |
|
| 569 |
}else{
|
572 |
}else{
|
| 570 |
if(empty($myProfileAddress[0]['users']['state'])){
|
573 |
if($retailerAddress[0]['u']['state']==null && $retailerAddress[0]['u']['pincode']!=null){
|
| 571 |
$users[$key]['User']['state']=$postOffice[$myProfileAddress[0]['users']['pincode']];
|
574 |
$users[$key]['User']['state']=$postOffice[$retailerAddress[0]['u']['pincode']];
|
| 572 |
}
|
- |
|
| 573 |
else{
|
575 |
}else{
|
| 574 |
}
|
- |
|
| - |
|
576 |
$users[$key]['User']['state']=$retailerAddress[0]['u']['state'];
|
| - |
|
577 |
$users[$key]['User']['city']=$retailerAddress[0]['u']['city'];
|
| 575 |
}
|
578 |
}
|
| - |
|
579 |
|
| - |
|
580 |
}
|
| 576 |
}
|
581 |
}
|
| 577 |
else{
|
582 |
else{
|
| 578 |
$users[$key]['User']['city']=$userUpdateAddress[0]['ua']['city'];
|
- |
|
| 579 |
if(!(isset($userUpdateAddress[0]['ua']['state']))||empty($userUpdateAddress[0]['ua']['state'])){
|
583 |
if($retailerAddress[0]['ua']['state']==null && $retailerAddress[0]['ua']['pincode']!=null){
|
| 580 |
$users[$key]['User']['state']=$postOffice[$retailerAddress[0]['r']['pincode']];
|
584 |
$users[$key]['User']['state']=$postOffice[$retailerAddress[0]['r']['pincode']];
|
| 581 |
}else{
|
585 |
}else{
|
| 582 |
$users[$key]['User']['state']=$userUpdateAddress[0]['ua']['state'];
|
586 |
$users[$key]['User']['state']=$retailerAddress[0]['ua']['state'];
|
| - |
|
587 |
$users[$key]['User']['city']=$retailerAddress[0]['ua']['city'];
|
| 583 |
}
|
588 |
}
|
| 584 |
}
|
589 |
}
|
| 585 |
}
|
590 |
}
|
| 586 |
else{
|
591 |
else{
|
| 587 |
$users[$key]['User']['city']=$retailerDirectAddress[0]['r']['city'];
|
592 |
if($retailerAddress[0]['r']['state']==null && $retailerAddress[0]['r']['pin']!=null){
|
| 588 |
if(!(isset($retailerDirectAddress[0]['r']['state']))||empty($retailerDirectAddress[0]['r']['state'])){
|
593 |
$users[$key]['User']['city']=$retailerAddress[0]['r']['city'];
|
| 589 |
$users[$key]['User']['state']=$postOffice[$retailerDirectAddress[0]['r']['pincode']];
|
594 |
$users[$key]['User']['state']=$postOffice[$retailerAddress[0]['r']['pin']];
|
| 590 |
}else{
|
595 |
}else{
|
| 591 |
$users[$key]['User']['state']=$retailerDirectAddress[0]['r']['state'];
|
596 |
$users[$key]['User']['state']=$retailerAddress[0]['r']['state'];
|
| - |
|
597 |
$users[$key]['User']['city']=$retailerAddress[0]['r']['city'];
|
| 592 |
}
|
598 |
}
|
| 593 |
}
|
599 |
}
|
| 594 |
}else{
|
600 |
}else{
|
| 595 |
$users[$key]['User']['city']=$retailerAddress[0]['r']['city'];
|
601 |
if(($retailerAddress[0]['ra']['state']==null || empty($retailerAddress[0]['ra']['state'])) && $retailerAddress[0]['ra']['pin']!=null){
|
| 596 |
if(!(isset($retailerAddress[0]['r']['state']))||empty($retailerAddress[0]['r']['state'])){
|
602 |
$users[$key]['User']['city']=$retailerAddress[0]['ra']['city'];
|
| 597 |
$users[$key]['User']['state']=$postOffice[$retailerAddress[0]['r']['pincode']];
|
603 |
$users[$key]['User']['state']=$postOffice[$retailerAddress[0]['r']['pin']];
|
| 598 |
}else{
|
604 |
}else{
|
| 599 |
$users[$key]['User']['state']=$retailerAddress[0]['r']['state'];
|
605 |
$users[$key]['User']['state']=$retailerAddress[0]['ra']['state'];
|
| - |
|
606 |
$users[$key]['User']['city']=$retailerAddress[0]['ra']['city'];
|
| 600 |
}
|
607 |
}
|
| 601 |
}
|
608 |
}
|
| 602 |
}
|
609 |
}
|
| 603 |
|
610 |
|
| 604 |
$this->set(compact('groups','users'));
|
611 |
$this->set(compact('groups','users'));
|
| 605 |
}
|
612 |
}
|
| 606 |
|
613 |
|
| 607 |
/**
|
614 |
/**
|
| 608 |
* admin_view method
|
615 |
* admin_view method
|