[MOD] GeoZone - Add All Countries Button

[webpie it.]

Ok so trying to do this for 1.5.0.5

Trying to ad the world to a gwo zone, i did succesfully use this for 1.4.9.3 a while back as you will see above.

The code i'm using is taken from above in two places:


Find:
CODE: SELECT ALL

Code: Select all

<a onclick="addGeoZone();" class="button"><span><?php echo $button_utton_add_geo_zone; ?></span></a>

After, add:
CODE: SELECT ALL

Code: Select all

<a onclick="addAllGeoZones();" class="button"><span>Add All Countries</span></a>

(This fixes the button styling)

Find:
CODE: SELECT ALL

Code: Select all

function addGeoZone() {

THIS IS THE CORRECTION FROM TONNAER

(I changed the fix a bit to cut down on the ajax requests (calling for each of the 180+ countries to get their zones was killing my browser , so the new button code of IBBoard is fine , and the code to place at the end of the page becomes:)

Before, add:

Code: Select all

<script type="text/javascript"><!--
function addAllGeoZones() {
<?php foreach ($countries as $country) { ?>
    html  = '<tbody id="zone_to_geo_zone_row' + zone_to_geo_zone_row + '">';
    html += '<tr>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][country_id]" id="country' + zone_to_geo_zone_row + '" onchange="$(\'#zone' + zone_to_geo_zone_row + '\').load(\'index.php?route=localisation/geo_zone/zone&token=<?php echo $token; ?>&country_id=\' + this.value + \'&zone_id=0\');">';
     html += '<option value="<?php echo $country['country_id']; ?>"><?php echo addslashes($country['name']); ?></option>';
    html += '</select></td>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][zone_id]" id="zone' + zone_to_geo_zone_row + '"><option value="0">All zones</option></select></td>';
     html += '<td class="left"><a onclick="$(\'#zone_to_geo_zone_row' + zone_to_geo_zone_row + '\').remove();" class="button"><span><?php echo $button_remove; ?></span></a></td>';
   
    html += '</tr>';
    html += '</tbody>';

    $('#zone_to_geo_zone > tfoot').before(html);
   
    zone_to_geo_zone_row++;
    <?php } ?>
}
//--></script>

At the moment though, the button does nothing when clicked?

I don;t like the SQL methods above as it's not usable for a client etc...

Can anyone try to help me fix this for 1.5.0.5 as i was under the impression that this hadn't changed since 1.4x?

Thanks Guys!

Chris

[webpie it.]

Solved by Jcsmithy! as usual!

everything above is correct accept:

Before:
$('#zone_to_geo_zone > tfoot').before(html);

After:
$('#zone-to-geo-zone > tfoot').before(html);

Just the dashes need to change for 1.5x

cHRIS

[threedonuts]

Trying to use this code on v1.5.1. No go, even with the underscore and dash fix in the above post. I have the button, but nothing happens when clicked. Anyone had success? This should really be a standard feature!

Edit: Fixed...I did a replace all the first time since there were several occurences of $('#zone_to_geo_zone > tfoot').before(html);

Here's the working script for v1.5.1:

Code: Select all

<script type="text/javascript"><!--
function addAllGeoZones() {
<?php foreach ($countries as $country) { ?>
    html  = '<tbody id="zone_to_geo_zone_row' + zone_to_geo_zone_row + '">';
    html += '<tr>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][country_id]" id="country' + zone_to_geo_zone_row + '" onchange="$(\'#zone' + zone_to_geo_zone_row + '\').load(\'index.php?route=localisation/geo_zone/zone&token=<?php echo $token; ?>&country_id=\' + this.value + \'&zone_id=0\');">';
     html += '<option value="<?php echo $country['country_id']; ?>"><?php echo addslashes($country['name']); ?></option>';
    html += '</select></td>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][zone_id]" id="zone' + zone_to_geo_zone_row + '"><option value="0">All zones</option></select></td>';
     html += '<td class="left"><a onclick="$(\'#zone_to_geo_zone_row' + zone_to_geo_zone_row + '\').remove();" class="button"><span><?php echo $button_remove; ?></span></a></td>';
   
    html += '</tr>';
    html += '</tbody>';

    $('#zone-to-geo-zone > tfoot').before(html);
   
    zone_to_geo_zone_row++;
    <?php } ?>
}
//--></script>

[DaniellY]

Trying to use this code on v1.5.1. No go, even with the underscore and dash fix in the above post. I have the button, but nothing happens when clicked. Anyone had success? This should really be a standard feature!

Edit: Fixed...I did a replace all the first time since there were several occurences of $('#zone_to_geo_zone > tfoot').before(html);

Here's the working script for v1.5.1:

Code: Select all

<script type="text/javascript"><!--
function addAllGeoZones() {
<?php foreach ($countries as $country) { ?>
    html  = '<tbody id="zone_to_geo_zone_row' + zone_to_geo_zone_row + '">';
    html += '<tr>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][country_id]" id="country' + zone_to_geo_zone_row + '" onchange="$(\'#zone' + zone_to_geo_zone_row + '\').load(\'index.php?route=localisation/geo_zone/zone&token=<?php echo $token; ?>&country_id=\' + this.value + \'&zone_id=0\');">';
     html += '<option value="<?php echo $country['country_id']; ?>"><?php echo addslashes($country['name']); ?></option>';
    html += '</select></td>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][zone_id]" id="zone' + zone_to_geo_zone_row + '"><option value="0">All zones</option></select></td>';
     html += '<td class="left"><a onclick="$(\'#zone_to_geo_zone_row' + zone_to_geo_zone_row + '\').remove();" class="button"><span><?php echo $button_remove; ?></span></a></td>';
   
    html += '</tr>';
    html += '</tbody>';

    $('#zone-to-geo-zone > tfoot').before(html);
   
    zone_to_geo_zone_row++;
    <?php } ?>
}
//--></script>

Oh, thanks for the working code! i has already started to worry about that..

[perezosogato]

Trying to use this code on v1.5.1. No go, even with the underscore and dash fix in the above post. I have the button, but nothing happens when clicked. Anyone had success? This should really be a standard feature!

Edit: Fixed...I did a replace all the first time since there were several occurences of $('#zone_to_geo_zone > tfoot').before(html);

Here's the working script for v1.5.1:

Code: Select all

<script type="text/javascript"><!--
function addAllGeoZones() {
<?php foreach ($countries as $country) { ?>
    html  = '<tbody id="zone_to_geo_zone_row' + zone_to_geo_zone_row + '">';
    html += '<tr>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][country_id]" id="country' + zone_to_geo_zone_row + '" onchange="$(\'#zone' + zone_to_geo_zone_row + '\').load(\'index.php?route=localisation/geo_zone/zone&token=<?php echo $token; ?>&country_id=\' + this.value + \'&zone_id=0\');">';
     html += '<option value="<?php echo $country['country_id']; ?>"><?php echo addslashes($country['name']); ?></option>';
    html += '</select></td>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][zone_id]" id="zone' + zone_to_geo_zone_row + '"><option value="0">All zones</option></select></td>';
     html += '<td class="left"><a onclick="$(\'#zone_to_geo_zone_row' + zone_to_geo_zone_row + '\').remove();" class="button"><span><?php echo $button_remove; ?></span></a></td>';
   
    html += '</tr>';
    html += '</tbody>';

    $('#zone-to-geo-zone > tfoot').before(html);
   
    zone_to_geo_zone_row++;
    <?php } ?>
}
//--></script>

Oh, thanks for the working code! i has already started to worry about that..

Hi DaniellY,

does it work on the v1.50 ? Or need i upgrade to the v1.5.1

[perezosogato]

Solved by Jcsmithy! as usual!

everything above is correct accept:

Before:
$('#zone_to_geo_zone > tfoot').before(html);

After:
$('#zone-to-geo-zone > tfoot').before(html);

Just the dashes need to change for 1.5x

cHRIS

hi webpie.it

i am using v1.50, which is upgraded from v1.4.9.3.
though there is a add all countries button, but also find the below thing,
when i click "add all countries" button, not work....please find the attachment

[Gl4cier]

Trying to use this code on v1.5.1. No go, even with the underscore and dash fix in the above post. I have the button, but nothing happens when clicked. Anyone had success? This should really be a standard feature!

Edit: Fixed...I did a replace all the first time since there were several occurences of $('#zone_to_geo_zone > tfoot').before(html);

Here's the working script for v1.5.1:

Code: Select all

<script type="text/javascript"><!--
function addAllGeoZones() {
<?php foreach ($countries as $country) { ?>
    html  = '<tbody id="zone_to_geo_zone_row' + zone_to_geo_zone_row + '">';
    html += '<tr>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][country_id]" id="country' + zone_to_geo_zone_row + '" onchange="$(\'#zone' + zone_to_geo_zone_row + '\').load(\'index.php?route=localisation/geo_zone/zone&token=<?php echo $token; ?>&country_id=\' + this.value + \'&zone_id=0\');">';
     html += '<option value="<?php echo $country['country_id']; ?>"><?php echo addslashes($country['name']); ?></option>';
    html += '</select></td>';
     html += '<td class="left"><select name="zone_to_geo_zone[' + zone_to_geo_zone_row + '][zone_id]" id="zone' + zone_to_geo_zone_row + '"><option value="0">All zones</option></select></td>';
     html += '<td class="left"><a onclick="$(\'#zone_to_geo_zone_row' + zone_to_geo_zone_row + '\').remove();" class="button"><span><?php echo $button_remove; ?></span></a></td>';
   
    html += '</tr>';
    html += '</tbody>';

    $('#zone-to-geo-zone > tfoot').before(html);
   
    zone_to_geo_zone_row++;
    <?php } ?>
}
//--></script>

Oh, thanks for the working code! i has already started to worry about that..

Tried this and it doesn't work too (button and script?), any success with 1.5.1?

[perezosogato]

er... where is Q ?

[Yuki]

A quicker way if you don't mind running SQL direclty on the database is to use the following SQL

1. Find the geo_zone_id for your "Rest of the world" FGeo Zone

Code: Select all

SELECT geo_zone_id FROM `geo_zone` WHERE name = 'Rest of the world'


2. Then take this number (this example uses 6) and replace the number 6 in the following SQL

Code: Select all

INSERT into zone_to_geo_zone (country_id, geo_zone_id)
   SELECT country_id, 6
   FROM country


Done!

I wasn't able to get the code provided to work in this thread so I used Brad's MySQL solution and it worked ^ ^ (I just need to remove US zone off the list). Thanks!

[perezosogato]

I added each by each in about 10 mins

[sucotronic]

Using mysql shell it only takes seconds. First you have to create a Geo Zone with the description "Rest of the world", and then execute the following from the Mysql CLI:

Code: Select all

delimiter $$
CREATE PROCEDURE myProc()
  READS SQL DATA
BEGIN
  DECLARE geo_zzone INT;
  DECLARE count_countries INT;
  DECLARE country_insert INT;

  SELECT `geo_zone_id` INTO geo_zzone
  FROM `geo_zone`
  WHERE `description` LIKE "Rest of the world";

  SELECT count(`country`.`name`) INTO `count_countries` FROM `country`
  WHERE `country`.`country_id` NOT IN (SELECT `zone_to_geo_zone`.`country_id` FROM `zone_to_geo_zone`);

  WHILE (count_countries > 0) DO
    SELECT country.country_id INTO country_insert FROM country
    WHERE country.country_id NOT IN (SELECT zone_to_geo_zone.country_id FROM zone_to_geo_zone) LIMIT 1;

    INSERT INTO `zone_to_geo_zone` VALUES (NULL, country_insert, '0', geo_zzone, NOW(), DATE(0));

    SELECT count(name) INTO count_countries FROM country
    WHERE country_id NOT IN (SELECT country_id FROM zone_to_geo_zone);
  END WHILE;

END$$

delimiter ;

 call myProc();
drop procedure myProc;


[perezosogato]

Using mysql shell it only takes seconds. First you have to create a Geo Zone with the description "Rest of the world", and then execute the following from the Mysql CLI:

Code: Select all

delimiter $$
CREATE PROCEDURE myProc()
  READS SQL DATA
BEGIN
  DECLARE geo_zzone INT;
  DECLARE count_countries INT;
  DECLARE country_insert INT;

  SELECT `geo_zone_id` INTO geo_zzone
  FROM `geo_zone`
  WHERE `description` LIKE "Rest of the world";

  SELECT count(`country`.`name`) INTO `count_countries` FROM `country`
  WHERE `country`.`country_id` NOT IN (SELECT `zone_to_geo_zone`.`country_id` FROM `zone_to_geo_zone`);

  WHILE (count_countries > 0) DO
    SELECT country.country_id INTO country_insert FROM country
    WHERE country.country_id NOT IN (SELECT zone_to_geo_zone.country_id FROM zone_to_geo_zone) LIMIT 1;

    INSERT INTO `zone_to_geo_zone` VALUES (NULL, country_insert, '0', geo_zzone, NOW(), DATE(0));

    SELECT count(name) INTO count_countries FROM country
    WHERE country_id NOT IN (SELECT country_id FROM zone_to_geo_zone);
  END WHILE;

END$$

delimiter ;

 call myProc();
drop procedure myProc;


will it be dismissed once upgrade to a higher version OC?

[sucotronic]

Is my first experience with Opencart, but the normal way to upgrade shouldn't affect this, because it does the same as if you click the countries one by one.

[perezosogato]

hmmm....let me try on the localhost and then we will see...

[OSWorX]

will it be dismissed once upgrade to a higher version OC?

Normally updates should not touch any existing tables in the database.
Except the case, the table layout will be changed again (which can happen - you never will know what Daniel will do)

[markman-b]

I added them all manually. It gives me a warm feeling that even people from Gabon and Gambia can buy my products now. Do they have glassfiber internet there??? ?

[jp1976]

hi all. if i want some buttons like this, how i can?

Europe -- USA&Canada -- Asia -- Africa

[Qphoria]

er... where is Q ?

where should I be?

[sucotronic]

hi all. if i want some buttons like this, how i can?

Europe -- USA&Canada -- Asia -- Africa

Best way... hard code it directly in the php file. I know isn't elegant, but is easy and works.

[jp1976]

mmm... i m not very sure how to hardcode this...
some direction?