| Line 202... |
Line 202... |
| 202 |
$new_address=$this->UserAddress->query($retailerAddress);
|
202 |
$new_address=$this->UserAddress->query($retailerAddress);
|
| 203 |
|
203 |
|
| 204 |
$retailerAddress="SELECT title,address,city,state,pin from retailers r join retailerlinks rl on r.id=rl.retailer_id where rl.user_id=$userId";
|
204 |
$retailerAddress="SELECT title,address,city,state,pin from retailers r join retailerlinks rl on r.id=rl.retailer_id where rl.user_id=$userId";
|
| 205 |
$retailer_address=$this->UserAddress->query($retailerAddress);
|
205 |
$retailer_address=$this->UserAddress->query($retailerAddress);
|
| 206 |
|
206 |
|
| 207 |
$retailerAddress="SELECT ua.store_name,ua.address,ua.city,ua.state,ua.pincode from useraddresses ua join users u on ua.user_id=u.id where ua.user_id=$userId";
|
207 |
$retailerAddress="SELECT ua.store_name,ua.address,ua.city,ua.state,ua.pincode from user_addresses ua join users u on ua.user_id=u.id where ua.user_id=$userId";
|
| 208 |
$user_update_address=$this->UserAddress->query($retailerAddress);
|
208 |
$user_update_address=$this->UserAddress->query($retailerAddress);
|
| 209 |
|
209 |
|
| 210 |
$retailerAddress="SELECT concat(' ', address_line_1,address_line_2) as address,city,state,pincode from users where id=$userId";
|
210 |
$retailerAddress="SELECT concat(' ', address_line_1,address_line_2) as address,city,state,pincode from users where id=$userId";
|
| 211 |
$user_address=$this->UserAddress->query($retailerAddress);
|
211 |
$user_address=$this->UserAddress->query($retailerAddress);
|
| 212 |
if($user_address[0]['users']['state']==null){
|
212 |
if($user_address[0]['users']['state']==null){
|