From b01ee3e9d7061a1b3b4887980b0542371be9bcd8 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 16 Jul 2014 06:19:03 -0700
Subject: [PATCH] REST API, RT#28181

---
 httemplate/REST/1.0/.cust_bill.swp   | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.cust_main.swp   | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.cust_pkg.swp    | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.part_pkg.swp    | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.phone_avail.swp | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.rate_detail.swp | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/rate_detail      |   2 +-
 7 files changed, 1 insertion(+), 1 deletion(-)
 delete mode 100644 httemplate/REST/1.0/.cust_bill.swp
 delete mode 100644 httemplate/REST/1.0/.cust_main.swp
 delete mode 100644 httemplate/REST/1.0/.cust_pkg.swp
 delete mode 100644 httemplate/REST/1.0/.part_pkg.swp
 delete mode 100644 httemplate/REST/1.0/.phone_avail.swp
 delete mode 100644 httemplate/REST/1.0/.rate_detail.swp

diff --git a/httemplate/REST/1.0/.cust_bill.swp b/httemplate/REST/1.0/.cust_bill.swp
deleted file mode 100644
index 44d4de7a94a29acefde64d29436755153ef9f719..0000000000000000000000000000000000000000
GIT binary patch
literal 0
HcmV?d00001

literal 12288
zcmeI2%Wl&^6o#j)DIhMpE)J<v$D*lIio_xpAtV+c!J-8=fGjtjG^5&%>q{aO1(uX0
zh!>!|3ld1IS-=K~x1bCDN!%uBfvC%hGt#GtJ?ES`^EsO+-mE;nd!KHu+z=QSgjg(p
z+}K;cEf$u9P+d3Fw`Yx(FJ&6Jy;*TDbV0inOPMH7+U+!zLFBuswAb%!JhWF=Dt0qV
zQfE{7{;XQO&IZ`PNe#@4wd<=DowZoFN|!D^I%xrpX9H}24X^<=zy{a=8(;%$;1nB3
zqdD;s{h!Itu#nGlN9O#JCpN$a*Z><~18jf|umLu}2G{@_U;}L66dG_nA@<J-u{)3E
z@&Et9@Bg3Yh4>D>fzRL*cnx;JJz#<*a0Ofj`{#uC1-^nk@E-I)7d!w3@B@2%0Uy9S
z@D{uQdhb_&2OD4mY=8~00XDz}*Z><~18m@bFi^9LDpYAhh=HJq@vJ&^saK4{m!!*$
z!;en1y>%>-Xu6or*5g{A0ym;Q8BV=1E~jgh8-_yzy46zB_YxZD?TuKbSsYTGp5%GK
z^NB8W8rBR)$71Cmw@#xXC3C7v)2iZ-B>hCSsDwJ5AaFyE<PIGPB#ZiDYX849{->t@
z-N>+s<NKSVE%ounXT~Ey6P=hmC8>~w+hL~{k_x+F7LYNT3so`Y1U_~W>Bh}=GI4x!
z8P3g7h6(d|jR9E#>2NW+u{@Syp->X}DlM5dvSW$Y<Fi;fu?$=lmW&v&fkj&BaLvuq
hcFAaNDSfAwf2C?gl3}ysNu(tyl7^4dqGIEz_zh{@?2iBd

diff --git a/httemplate/REST/1.0/.cust_main.swp b/httemplate/REST/1.0/.cust_main.swp
deleted file mode 100644
index d785784d38797fac52d412ec4b0a607cbf00e9ae..0000000000000000000000000000000000000000
GIT binary patch
literal 0
HcmV?d00001

literal 12288
zcmeI2O>Y}T7{{j^cyB@Np(mt=bj|JxCyrAj4vj5JYapU&OPoR_+FBEPY_GDrc6Qed
zAur_s0xlJwpnL%&Bsg-U6sSa7P9RZ%gt*aifD_OI|Jj{gn>3MQaVnZse%{%6eda&&
zJYy@nF!}1tEIm8%48!#}V|(AcQhlQOJTsnR%sJ0}nLX@kx<W)<zC5hnhU~D=41@@s
zhA6b7NO)bBN1`xSsm>RQ6O)B{FN|s)cXl-Hu<>-cRzNE-sK9P^aH=>da}JC>N&EJm
z8Z6Xlt$<cQE1(t73TOqi0$KsBfL7ptu0Yh?#V%lu_o;clqVBsk-PNPMX$7<bS^=$q
zRzNGD70?Q31+)TM0j+>mKr3($D!?0zHSTBZ@&hm)|Nl>a|NrtBV>iJM;41hUyaV0_
zEzks2FbB$@1peH^*bQ(Ud<s4R?}PV11snzAAP;`q&Dd>l8GH`j0vEt(upj*XC}Tf?
zAHnzFJ8%Vj0WN}BkOO<boktk^3;YZ|26b>8><3pLX6zDp7i@rOaPuL?z62kDBVZr6
z^B`k?fZN~}xCTA~7l8)^Xn-P^1bOf@xC7n(2H%1k;2QV_NIky-AA(EZ95@ROf+=td
zn*Rzu1NzbmXa%$aT7gj%n4T`=9N&q`jIHC3gc~|dvd9R=%btkZod$^|GEbhGH_4_|
zIxunruhVdvE1UZsp_>t^CMIqkac3QjD#Yed?$+!?H5IKM2)v+2zQEgkL=c*A8G(p;
zflnoRojl$pqc&bXd~&AN5|QIKJ9&C8dykLK9!lD*+lS(|M5cHn3V1DCa!o3g$;ckF
z3T+;?1JN`w6e`e}oXp6l%_F|x3RxDHn%PihQo~yr9KJ+Lq2NKiZLKOhR5xSkXmLmV
z4_lS@a|Tj}j~}Im2qT&~HuG|Y44K}({%bE)<|>rgHz8Ag&x34PUd{2(cbvLN%d*ar
zww2Q})%hwmb+vM=a%7&0^upYU*}I#oW_>9!#+b^49<iOsYAm$J%S*jZBrG#$PEc6q
zE)OiD-g3svT^?}H>dTp$R+E#gg}sF^3LL*>+V%vYwOY;rzZ<O=x#5+C|7|Hs_wq9A
zd<CGpl01oW!__wJOk=qRGB?9UFiq_KY_CyrWe%#I)7!Ql0T&fPz}=eK*eq=^a9>)s
zh_{3vZ~TzEB9tD0mhx72c^E(ULJ=S%?f|yN{th#(IJ&GNzQ{PRg;qw*wv(U~??WNO
zyz9Ux<DOKs8n8x2qru01dQq%|l<O|G;0Dpwm1Lw-!6dXyS+9orW*&o@s-amb!`5{>
zja9<}Wnw3hoU`fz)0P9tNy8@-d*tkkv`$7AH^$3x66I-l?Vo@3j^}YdIsGy#<E^0P
zKFq3rjbo^@G>zl2v1ulJueiMdr41^avtmOnSh~ieh}YX5HpAM2<GO2IzGB-(VQbR{
z=Q?n<sL_-U49qk><WoI60W};!V?BS-?=1Uqz?2&<?i2|Xaim*hl0x|Y>Snpg^2$dv
zlgq1;SPff_rVLS$UB)zI%6|Jtq*QLJZzeBRl0z0hFjsH{tB&(XscG3TDeSsVWSIrn
z5y&{)3!GXY<Qwvq5umPT=V^-Ix-2f{y{H|>bD1-(z8_8JNci<mL!f0Cp<R4>+mtJx
GVgCRGY3p79

diff --git a/httemplate/REST/1.0/.cust_pkg.swp b/httemplate/REST/1.0/.cust_pkg.swp
deleted file mode 100644
index 451a98554b9bfb2e7d243f943a2e1aa8e7b0788d..0000000000000000000000000000000000000000
GIT binary patch
literal 0
HcmV?d00001

literal 12288
zcmeI2O=}ZD7{{j`^kA!^M?s$^8#jTr+g8Ct+w}#C^dOcd^`a8i%_JF`-A#9ATdGvO
z=vhC3SBriD{Q!b~fcBtA!EYh{XLmzW5kilJXULD)%*!*+{AMp9^K|y%%6+;yb3>q9
z5aRN)ul2pPyCS(Jgxc~#(>$uQds6DYw>@gy3lq?3$5JM$C7rI;GU)d_EuFRHdc&EU
znRWa$(aruwXH+QeX9H~D*ajxV_4&D3Gp$^jq)Qjqj~#(0umLu}2G{@_U;}J`4X^<=
zaB>ak{+M`)^iLIAu#0-^pSt+U6&qj!Y=8~00XDz}*Z><~18jf|umLu30u6XAA%2ew
z@qPly<NyD`@Bd%th4=}6fbZZNcmrO8F6e*;sDs<!7Wi{chy$<>zJSl*9e4{mpbe_P
z29tomRd5B2gR|faI1LVv&p!ABK7u{)0hl~r0WNHS4X^<=zy{a=8(;%$fDN#LlV)Ji
zsi;tCSBPDFNcIxdrYc$Sv>Qm>9nl@NNN$q7y56v<M$f4nL@m|c`Cp{L&<FLwSU;Ay
zdrhIl#cd)iPgKq_kS0=3CECa&l&sG@Sh3V;9MTd!qQL8u)tq+ktgbXWQme2XO_4RY
zz&-6|Psx@~PZo+Ohr9EmAn?LG`N6ns2l>e1g@z&ytyF}}T@6P&5+#bMr6iToa3hSi
zL&C-KFb&Ac>(YWSdkS_Av&P0Y6Y0f%H>uiLVu7bZdkRAAe3HH77Sm~$Y9`%0haxl%
z!L*r}hpLQ#Bd1!N#l7YHD1-=haO8Oi<FK$(Lpn*nr*zeJkV7nSH$IJ3GnOW+sug2w
rP@AH8s$qq!+e>w~YWW>yS{92}Yq3Hy^rM!<%tT{ec8E2qxR1qO|IY8X

diff --git a/httemplate/REST/1.0/.part_pkg.swp b/httemplate/REST/1.0/.part_pkg.swp
deleted file mode 100644
index 547a79eee70e909867fa3ae423c06424560a50df..0000000000000000000000000000000000000000
GIT binary patch
literal 0
HcmV?d00001

literal 12288
zcmeI2O-~a+7{>>%iZ6IXlSf$G-GowniAX2~Ogvy>Vg!{$Ofz(+bi=;1yHg1g^r(IT
zJ!<sm(X$>+)GwfsqZhx0|Jk;**bqcdB+n*4c6VN$dFD4$0_m)b-<`in6JwVJu9HGM
z@;)uhOkNXb&kNx{l#wak@2Uh!>6%>Muiax4FkeZON_|h|t6HnD7D%n~x34cO<}Zwm
z=W8<2rP|u+exbOY4X}ZO7-;B9?rOidbn(Kt={7ucj!qBUIY<O<%Ldp08(;%$fDNz#
zHoykhz#%uFYklGg=5VAn52tnS`{Ukv<r^Dd18jf|umLu}2G{@_U;}J`4X^<=a0m@Z
zPl)<4A#(jl9^e1B|NsAaLWphf1AGCW!87m_RDc4DU;)g5Ss=jo<3fA`AHfIk61)Hr
zxB&>90fS%woC4bz`#pFI-T)0!Pykb465y*#F#)aslj|V(io9QgSKv7?^SB2r@aw1$
z?*LzHfDNz#Hoykh02^QfY~YX@DC9@{$k#=a{ucg{?z$dK?RqsevpYv=o9+Ii_dj&q
zyUSiRS$R)op{K-3lx`#uP1Ah}WsR)%JaY$VTAaHzUs_e#k1FwKM-{;%M1~t#QE$B7
zl0B38s}ZuJ&X`F(RWd189lJdjdz6+(sxqy*SwhVf%zmPv>#g}%Uw6p!Q@Ii-kII2e
z)2I=Wi-wp<76xNDnXOH-N;F-hv@8ReI97Sp&lNGM3>~ZFx`chTMJh-YZ5k6>0N3!+
z(h?=g^AlCpq+^m)Zlt;tN<X4z?laAnp0CI@t)p1ehSKEYgtrP+q?Koz)U)V*1?gDj
zI1FXvk*bqz!o{IVQk&f7&_tb;?yPaQ)=W)rsICZc0xyb&8qr!5uSbM~<;F1fO!HyL
zWCTY$@jGjg?plmZvRhs3>0-M#=HlXzd^VSM<Scm;v9mGEo-#YC;;X<*F+%g9E52Fe
za05nKQARs%T(nPXfv+7qk4=#%SZ^eLDN)9~V<l)Cx@00`b+VzW*{Yh7LhJWMVT4pv
Tjy;8LsYa*l6XeoJaasHZ*g<8?

diff --git a/httemplate/REST/1.0/.phone_avail.swp b/httemplate/REST/1.0/.phone_avail.swp
deleted file mode 100644
index a65bb2748f3a7bfff6877043883065d4bb49031b..0000000000000000000000000000000000000000
GIT binary patch
literal 0
HcmV?d00001

literal 12288
zcmeI2&2G~`5XUz?Q>fs8dO_1PA+|)mno1m!SO}Fv4_qi82SC==-X<&Twd>s^t*XLv
z01v@|6E9F6fpS8;1s5b{9h)FHM7>dIR{G11v-6*s-|ofo?suN<K7_liZH8lwvGcXF
zy>IXDvs<?rlT)tj<7ML@62hc>wrt*OYuG->gwQe+?XfW;P9tta`_Y5F$L(&b(@w{U
z5<Z`D87*_8|A_z*xEO&|*4yfKY|LhL18!V@a<OolO$3Ml5g-CYfCvx)B0vO)z@;W&
z(h7Tn9jp{xtQXhHU)SO%U5Ee?AOb{y2oM1xKm>>Y5g-CYfCvzQOGto+jD5VqSZ@`J
z$M65;`~UZAjD1C&qdud~Q14K0Q5uz@dZ-mt1@+}BW1mnd>KSSsbrbayeSe@npg3xX
z8lY^xEfftRKm>>Y5g-CYfCvx)B0vO)z<*3&(5_1*jmH=)8*YF39P4p7b0EWm(1B1!
zWS|Y+1J48xl2Cv+3dUTG1h_0dhFX3`T1{dNL#T<PG|5cU8wulwGSm*lJcSde`7rcA
z2R!1LQwv72>7_j5u~YM17f$oCa<{p`!b(5yyzDbOA(R5DDuJEd9Z0ieDnqG8Sd2{w
z+!!8=MF=JVJq^&?K&`l`VmydQ%L8y=1Mba3G`Mh5+QvyHz+hK^=e=!)=0!8)=0$&H
z1{XZ&=4p^q`Ovmz%k#0i9D?!Z1zBEw#_~2N>Xk}n>fcsiq9UR7!lFN4gTfHa54GS~
zFxF0^%+k1n3(zQFG=^Tu1x^7sL>^xv!`l8>o8K{Z+NNy8u+O!`HH?mdgO+$&9(PA9
tbud3DZ#O{;<MDM|XyfyV8Ru(l!w1DC9n?W6yN!H1$64$i7wX;%_6ui>4-NnT

diff --git a/httemplate/REST/1.0/.rate_detail.swp b/httemplate/REST/1.0/.rate_detail.swp
deleted file mode 100644
index 8d46a280f00f95becd547d1b0486b5d0f3e090a5..0000000000000000000000000000000000000000
GIT binary patch
literal 0
HcmV?d00001

literal 12288
zcmeI2&1w@-6vt0p7HdT}?mV{B&V;s^Mn#1-Y5j<_U{#uaxCjonnVV)LNz<7dwS?5C
zP`c1Z@F8^JUQ|#J7lP>0NATR-nK~(AyDgjxe=g_T^L2kSn~>R<URzwktJ%vy>omZR
z!FQ!|FK@v4ae&~lXlnOit6G;*wZxOd;&ydGw;D<r1-^7^O36m6E|heai=`Demz{P)
zvOHfZ5!4T>#^+3c2^^U~TUDp74Xs|fn48u)qazpa?3vXgr*j|^U;<2l2`~XBzyz28
z6JP?zpMYu&z%#nWiTEm`@jh^1k4@f~025#WOn?b60Vco%m;e)C0!)AjFo9!8K==Sx
zP6B)*>Hq(e-~V5S0X~vGklvEskY1B^NP={qG)nq(3g8uKkMx4{ob-q^M=FpeNfv34
z^koR(GwD5PkK~coNo%A9(l}|D^qXe+Mfw@f^<B@#iwQ6RCcp%k025#WOn?b60VeQY
z0<-Q|&<s=o0BLnIGrb*AK2@RcqU}273ux_Ilku@#6HzUcRa+l-y8CV=HtN!*O60av
zpDNorqKn&+6k(<2bWA(!ChZ(-h!%Fx@_PMxnW5YawwhA~@^x|ESY9=dbw9#P((zx3
z=IiJr(O3r(C*lbjJ7}evVLmpK626R-XIh(4_Y+KnPVn?eZ+xKB`P8j3560EINisqn
z%_STI$W*t9yw2{Q_CTmP)S=L&o+Al8;@!Wl-@S#Et#(s|JC!Y8(v-H9vTf)OkFE8E
z;&KsF^Ji1nZ?+p$CdDdi1}A^7nn^A`SS+oS(7{siPVwdn=J59Ny`^*-1^<1WsNx7Y
zG}P318ftC^f-2RqDx1Mnp(R4maO_l!ox%Jrx(~|}b57Zx$XG6Bu%i+7Rkv+o73zm5
h+N$R0YMS0`{L;^kp=@eG^o%3rV7c$<WpJ!ehCf56BN_kz

diff --git a/httemplate/REST/1.0/rate_detail b/httemplate/REST/1.0/rate_detail
index 54e55de6c..6ae503190 100644
--- a/httemplate/REST/1.0/rate_detail
+++ b/httemplate/REST/1.0/rate_detail
@@ -7,7 +7,7 @@ my $extra_sql = '';
 if ( $cgi->param('countrycode') =~ /^\+?(\d+)$/ ) {
   my $countrycode = $1;
   $extra_sql = "
-    WHERE EXISTS ( SELECT 1 rate_region
+    WHERE EXISTS ( SELECT 1 FROM rate_region
                      WHERE rate_detail.dest_regionnum = rate_region.regionnum
                        AND countrycode = '$countrycode'
   ";
-- 
2.11.0