TableRates/index.php at master · seamusdiamond/TableRates · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?

require_once("countryCodeLists.php");

$three = explode("\n",$three);
$c = explode("\n",$c);

if(!isset($_POST['submit'])) {
?>
<!doctype html>
<!--[if lt IE 7]> <html class="no-js ie6 oldie" lang="en"> <![endif]-->
<!--[if IE 7]>    <html class="no-js ie7 oldie" lang="en"> <![endif]-->
<!--[if IE 8]>    <html class="no-js ie8 oldie" lang="en"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
<head>
<!--
    |                  |
_ \ |  _` |  _ \ __ \  __|  _ \   __|
__/ | (   |  __/ |   | |   (   |\__ \
\___|_|\__, |\___|_|  _|\__|\___/ ____/
    |___/
    Elgentos Ecommerce Solutions
        www.elgentos.nl
    info@elgentos.nl / 050-7001515

    Oh hi there! o/

-->
<meta charset="utf-8">
<title>Magento Table Rates Generator</title>
<meta name="description" content="Generate your table rates (tablerates.csv) for Magento shipping!" />
<meta name="keywords" content="magento, table, rates, tablerates, tablerates.csv, magento, shipping, costs, generator" />
<meta name="author" content="Elgentos Ecommerce Solutions" />
<meta name="viewport" content="width=device-width,initial-scale=1" />
<!--[if ie]><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" /><![endif]-->
<link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="generator.css">

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script type="text/javascript" src="javascript.js"></script>
<script type="text/javascript">

var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-1292775-30']);
_gaq.push(['_trackPageview']);

(function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();

</script>
</head>

<body>
<h1>Elgentos' Magento Table Rates Generator</h1>
<ul>
<li>- You can use this generator to generate the tablerates.csv file to import into your Magento installation.</li>
<li>- You can check all the countries in the European Union at once, and set default "Shipping Costs" and "From &lt;condition&gt;" for the checked countries.</li>
<li>- Click "+ Add row" to add an extra row to allow tier pricing for shipping costs.</li>
<li>- Click "Generate tablesrates.csv" to download the generated CSV file.</li>
<li>-
<?php if(!isset($_GET['twoLetterCodes'])) { ?>
For older Magento versions (<1.4), 2-letter country codes are needed. <input type="button" name="button" onclick="document.location.href='/tablerates/?twoLetterCodes'" value="Switch to 2-letter country codes" />
<?php  } else { ?>
For newer Magento versions (>1.4), 3-letter country codes are needed. <input type="button" name="button" onclick="document.location.href='/tablerates/'" value="Switch to 3-letter country codes" />
<?php  } ?></li>
</ul>
<br />
<input type="button" name="button" onclick="checkEU()" value="Check all countries in European Union" />
<br />
<input type="button" name="button" onclick="checkEuro()" value="Check all European countries" />
<br />
<br />
Default price: <input type="text" value="12.50" id="defPrice" name="defPrice" /> <br /><input type="button" name="button" onclick="setDefPrice()" value="Set default Shipping Costs for checked countries" /><br /><br />
Table rates condition: <select id="carriers_tablerate_condition_name" name="carriers_tablerate_condition_name" onchange="changeLabel()">
    <option value="weight">Weight vs. Destination</option>
    <option value="price" selected="selected">Price vs. Destination</option>
    <option value="qty"># of Items vs. Destination</option>
</select><br />
Default From condition value: <input type="text" value="0" id="defSubtotal" name="defSubtotal" /> <br /><input type="button" name="button" onclick="setdefSubtotal()" value="Set default condition value for checked countries" /><br /><br />
<form action="" method="post">
<ul>
<li><table><tr><th style="width:250px;">Country</th><th>Shipping Costs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span id="conditionLabel">From subtotal</span></th><th>&nbsp;</th></tr></table></li>
<?php
foreach($three as $part) {
    $parts3 = explode(" - ",$part);
    $threes[$parts3[0]] = $parts3[1];
}

foreach($c as $d) {
    $parts = explode(" - ",$d);
    if(isset($_GET['twoLetterCodes'])) {
        $countryCode = $parts[0];
    } else {
        $countryCode = $threes[$parts[0]];
    }
    ?>
    <li>
        <table>
            <tr>
                <td style="width: 250px;"><input type='checkbox' name='country_<?=$countryCode;?>[]' value='<?=$countryCode;?>' id='country_<?=$countryCode;?>' /> <label><?=$parts[1];?></label></td>
                <td>&euro; <input type="text" name="price_<?=$countryCode;?>[]" />&nbsp;&nbsp;<span class="euroCondition">&euro;</span> <input type="text" name="from_<?=$countryCode;?>[]" /></td>
                <td><a href="javascript:void()" class="addRow">+ Add row</a>
            </tr>
        </table>
    </li>
    <?php
}
?>
</ul>
<br />
<input type="submit" name="submit" value="Generate tablerates.csv" />
<small>&copy; 2012 <a href="http://elgentos.nl" title="Elgentos Ecommerce Solutions" alt="Elgentos Ecommerce Solutions">Elgentos Ecommerce Solutions</a></small>
</form>
</body>
</html>
<?php } else {
    header("Content-Type: text/plain");
    header("Content-type: application/force-download");
    header("Content-Transfer-Encoding: Binary");
    header("Content-disposition: attachment; filename=\"tablerates.csv\"");
    if($_POST['carriers_tablerate_condition_name']=="weight") {
        $condition = "Weight (and price)";
    } elseif($_POST['carriers_tablerate_condition_name']=="price") {
        $condition = "Order Subtotal (and above)";
    } elseif($_POST['carriers_tablerate_condition_name']=="qty") {
        $condition = "# of Items (and above)";
    }
    echo "Country,Region/State,Zip/Postal Code,".$condition.",Shipping Price\n";
    foreach($_POST as $key=>$value) {
        if(stripos($key,"country_")!==false) {
            list($dummy,$country) = explode("_",$key);
            foreach($_POST['price_'.$country] as $key=>$price) {
                $price = $_POST['price_'.$country][$key];
                $from = $_POST['from_'.$country][$key];
                echo $country.",*,*,".$from.",".$price."\n";
            }
        }
    }
}
?>