public function myBids($uid, $period)
 {
     $this->checkUser($uid);
     $sql = sprintf("SELECT * FROM location_bids WHERE owner_id=%s AND period_bids=%s order by bid_created_dt asc", $this->qstr($uid), $this->qstr($period));
     $result = $this->_connMain->Execute($sql);
     if ($result->RecordCount() == 0) {
         throw new Exception('No Bids available.');
     }
     $return = array();
     $Models_Geo = new Models_Geo();
     $return['country'] = array();
     $return['state'] = array();
     $return['city'] = array();
     while (!$result->EOF) {
         $location = array();
         switch ($result->fields['location_type']) {
             case 'Country':
                 $location = $Models_Geo->getCountryDetails($result->fields['location_id'], 0);
                 $return['country'][] = array('bidDetail' => $result->fields, 'location' => $location);
                 break;
             case 'State':
                 $location = $Models_Geo->getStateDetails($result->fields['location_id'], 0);
                 $return['state'][] = array('bidDetail' => $result->fields, 'location' => $location);
                 break;
             case 'City':
                 $location = $Models_Geo->getCityDetails($result->fields['location_id'], 0);
                 $return['city'][] = array('bidDetail' => $result->fields, 'location' => $location);
                 break;
         }
         $result->MoveNext();
     }
     return $return;
 }