From eb4a307c1c7fafe61977587debfe120d65270f24 Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Fri, 11 Dec 2015 21:58:13 -0500 Subject: [PATCH] Remove old unused stuff from tools directory --- .../org.civicrm.payment.googlecheckout.zip | Bin 37060 -> 0 bytes .../GoogleCheckout.php | 343 --------- .../GoogleIPN.php | 573 --------------- .../googleNotify.php | 49 -- .../info.xml | 40 -- .../packages/Google/README | 115 --- .../packages/Google/demo/cartdemo.php | 178 ----- .../Google/demo/responsehandlerdemo.php | 300 -------- .../packages/Google/library/googlecart.php | 510 ------------- .../packages/Google/library/googleitem.php | 71 -- .../library/googlemerchantcalculations.php | 103 --- .../Google/library/googleresponse.php | 349 --------- .../packages/Google/library/googleresult.php | 144 ---- .../Google/library/googleshipping.php | 144 ---- .../packages/Google/library/googletaxrule.php | 97 --- .../Google/library/googletaxtable.php | 56 -- .../library/xml-processing/xmlbuilder.php | 116 --- .../library/xml-processing/xmlparser.php | 193 ----- .../Baykeeper.php | 680 ------------------ .../templates/Baykeeper.tpl | 33 - tools/extensions/org.civicrm.report.grant.zip | Bin 4681 -> 0 bytes .../org.civicrm.report.grant/Grant.php | 348 --------- .../org.civicrm.report.grant/info.xml | 27 - .../templates/Grant.tpl | 26 - .../org.civicrm.search.activity.zip | Bin 8088 -> 0 bytes .../ActivitySearch.php | 400 ----------- .../org.civicrm.search.activity/info.xml | 22 - .../templates/ActivitySearch.tpl | 142 ---- tools/extensions/org.civicrm.search.basic.zip | Bin 2751 -> 0 bytes .../org.civicrm.search.basic/Basic.php | 181 ----- .../org.civicrm.search.basic/info.xml | 21 - .../org.civicrm.search.multivalue.zip | Bin 6321 -> 0 bytes .../MultiValue.php | 293 -------- .../org.civicrm.search.multivalue/info.xml | 23 - .../templates/MultipleValues.tpl | 142 ---- tools/sites/stats/graphs.php | 121 ---- tools/sites/stats/index.php | 242 ------- tools/sites/stats/robots.txt | 2 - tools/sites/stats/stats.php | 212 ------ tools/tests/reports/index.html | 13 - 40 files changed, 6309 deletions(-) delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout.zip delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/GoogleCheckout.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/GoogleIPN.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/googleNotify.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/info.xml delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/README delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/cartdemo.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/responsehandlerdemo.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlecart.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleitem.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlemerchantcalculations.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresponse.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresult.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleshipping.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxrule.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxtable.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlbuilder.php delete mode 100644 tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlparser.php delete mode 100755 tools/extensions/org.civicrm.report.baykeeper/Baykeeper.php delete mode 100644 tools/extensions/org.civicrm.report.baykeeper/templates/Baykeeper.tpl delete mode 100644 tools/extensions/org.civicrm.report.grant.zip delete mode 100644 tools/extensions/org.civicrm.report.grant/Grant.php delete mode 100644 tools/extensions/org.civicrm.report.grant/info.xml delete mode 100644 tools/extensions/org.civicrm.report.grant/templates/Grant.tpl delete mode 100644 tools/extensions/org.civicrm.search.activity.zip delete mode 100644 tools/extensions/org.civicrm.search.activity/ActivitySearch.php delete mode 100644 tools/extensions/org.civicrm.search.activity/info.xml delete mode 100644 tools/extensions/org.civicrm.search.activity/templates/ActivitySearch.tpl delete mode 100644 tools/extensions/org.civicrm.search.basic.zip delete mode 100644 tools/extensions/org.civicrm.search.basic/Basic.php delete mode 100644 tools/extensions/org.civicrm.search.basic/info.xml delete mode 100644 tools/extensions/org.civicrm.search.multivalue.zip delete mode 100644 tools/extensions/org.civicrm.search.multivalue/MultiValue.php delete mode 100644 tools/extensions/org.civicrm.search.multivalue/info.xml delete mode 100644 tools/extensions/org.civicrm.search.multivalue/templates/MultipleValues.tpl delete mode 100644 tools/sites/stats/graphs.php delete mode 100644 tools/sites/stats/index.php delete mode 100644 tools/sites/stats/robots.txt delete mode 100644 tools/sites/stats/stats.php delete mode 100644 tools/tests/reports/index.html diff --git a/tools/extensions/org.civicrm.payment.googlecheckout.zip b/tools/extensions/org.civicrm.payment.googlecheckout.zip deleted file mode 100644 index a55ad6efbf4706dbe24a03bfdde510ad944093c7..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 37060 zcmb@tbC56JlP27@dE2(#ecQHe+n=^=+qQ1&wr$(CZFlc?CN^SYHg@0NzB5x1b)x<{ zPgZ4AW*qYio)0^Ad zo7~Jteg+{03j}mT1_UJkUqA$y zIyueTDJBZ%^2UCpD=Q_W+in8e|oROim!Ip z^^7K6U^Xo663{_N=GZYcRV1k+m>zp}oFt@DaoZ|3F3q%=rB7mJJodPX^}llI7lMMO zA5I_-xy~Y->E4VgB6he*8T30}5xLNfkXe{z`bqKy3Xu^t3pGRM^i1=h!5J$uo=ygJ_sf^24^mXqSR1NYScTk6EFy z+73J|A33Qkpx;hS!mVWkvO$Dl@{Ub~gqm2^KWUrf;<$4gwW((3jv*b1mL(C4k|*h<|*B!n;%`?%?5&$-9gZg^1Dy*4EyJqIFy;lCIs^ab?Ed zf*+?xzV>X~`9kIW;;&yx-kdnETcAKk1rR&r$^HOM9zsz>!MQ3AQ`?IgjNP%AN z1TAD_04*9ktN?EpYYc$*CvDk>h&Rahlx5Wi4$qG>Q5G%izLI|3Zm8- zmCFDF9<^FE51i%1aARMsRs$v$8n)*!t4Kvo7+Ve42U!T$FwKX9Q;{jkf-|BW7A+1> z2{9OF74x_1!6MJ3D{e~7T*9H!d-;lg>`k@C-j0tNE4ReYlRlIyf$B4a;w0^bVFb}8 z!jD$dAfEcG5ipAMy3)GKT1uo85WvWRGg?hweNxzMtlSZ(>jfwM8ql5B50RB zga+z}pcq5mOiL%U55x#S0>h@+OMO-V3l+s_yH1@9L|3xRPJsc3iB9H|)`Pan0=U##=PwoKsMo8|3@1FJ=|1j|Y#n#iFdEk7?iGrg z(VfG`bOIV?5`wOQ<$$f7%6F%cq+FA9c<7D|6@AAq4p=59Y>!|F9uQdG8!!((Bl2!1 z`_VdmqE5pL-DE#zT2^>dDf|2tDx*WH+kvLmmuSHl6iG3=RFYr_KT1@61e|yKd>CJZZQ)uq zf&uASLi>Pl_RV!!q672_4)SyFU#$fcB>-^Gp4J`DSIVHKz8PEkeg4Sw5%$H$DSXB8 z)wvs*>wn~wwuBI z>^x?ZJx^WldOD3dX3dcAwNAroDTXN;lmJeedeqMyyt4-61|*=;umuIDDb=abo(ed;hG7uvqmg8$Gukbne+fsuJ z!p02H9;H3=C2fMS${phnU|Ykz44cPcrc{%}r{pQfe$yfVzT&65ER6ZJVCI-KZX5wJ8rrr8>SbBxZi{q#++fl4Es8U#pqz?wqSFsMH zM(W(uheh=#^R@gEB?|J=!}53@nSDOqc6in{o=KVmOJ&JiQ$I;xKbvs$Mr82Bng&7v zg3u-p`8;}9O+IDklsOD{w%d?lk2hW!uSBX-w1QGANh-@c-%Zom{a#g#_Q&%)bt`N; zV`SEZ#DT6wr_ay>qfzR9Zs&Ab&(&OH?djLBG)~+qb0#-@ z#{wNR{DxqDmT#4l@|bA(e(LZVD6&iV)Ts|}s_LG>dfm995I(L!1u(5+=V~@= z>-Btp6Fk6oS0VN=*XMZS)*^*=2qmthOVoE_05uRQGdyhrq5MIgBN8yzwhd`lmFAzz z^y!gkJN74h4eCuu1CCC(#KPAehF{k1%fjr-LGMdIEhXonmTZxuWPxw&(NC(xk1pX^ zzKEe|uUj1E2;{y;-osnLe35E_@%1AtECjxUYAhzPsm5JZp|8u>0jTFtSmms)iV285M*|RUQZ7%jGMDU`UI#2=nPevQh3)MEIQeYx)tMW>Ovu#e)NiV}x$vBKVj;9` zo;gpoV}Icjq$B3?vV66{58YpW+JrUenp1n7S+QT3J!xs2J9@xP;#oYu7<=w~z1lJ6 zf`19xv*O-NY+b~91qa^(dKQmYT<`fN>+W^|@-uSNUO{KhH;m_qVgral zW8HjRxUph=uec;*w|+D)2ky4MCuI`pxwaj2H|qX*OCrnDB!l*nFFXz1o}m^q2pcvh zdqfpX)+d^Kd}d3P>mHn8b^8HJZh{}GYl%}V0=s8N0GEYhXyJi4sWt5gQ)Sbsi+pEYbd77zbD@bP3MUM;S(PY^HGBz< zB$>W?Ec58t@msCAgrrNW%`5vcXY!5wNLo>7cLQ|tnehGo+VuBmOq9%Q1-9iI1lUjUc;~;+=SXoBq*9+~J?Pdn-W*OYFX>0Bd0X8vOqQ)pLvT{{Fn!jj_6g@s z6Qf?hQ0jvcj`}}8@{(=X5?vDHhyvCA;{a0mqvukR1=Wktg!rl1RY?@hAE!QZ8_N2z z0!LpE%ph_&;#9{Ym4f@j2$uNq<=JaeS4adwV=pK88c)14!dy!O%?q0{ejwG{x`#YVrq!` z#zNHxJfGsv*dC}UlC<*Rqk|0sisCw3FjgAjZPRUqxWq8#*i264bz8Rus-C1%11rLI zpOlHx_|1yz<&z`b&UnS`iYCtyQ+7)7ShV1GpnT;`Rse(6`WBfw}d}uLvk>)`8!RI zuCDiyr>7iLy(No%H?pWYLRd0=_L&JF`P4!(h=;`n&FO;GS< zcY4>PZnr=Jb7*j~2bzU3a_D#8O)94^xr7djSH-$@?(wq?*XSroQq!Ap!*_c1j(x*5 zLZ1C^tpv8y`p57pQUDU#DM(q06Ql z>qNoX-8D_K&rfy2^q+b&YX`sUow8P6nCpMs?Y-A%e+b|n?Ah^!3dZPBvh`-=O*fp3 zxJLf`Y(g8tD|T12e<}agM2s5GT1oNy-*QT8vDM8e1P~A=Di9FYe=esei3*CyivE8! zglaTo<2Kllx<1sAx>+HXLEc@)3VI6#*TGRt=4=CWEF)4^OGHA7J01OecHsC)y}G6g zPl?wCQMg!crf#QZ5gQ0%P+od=qSo1^E^AOdp(U04@|^gq;XhO!OCeeEQ7bygYSwmIRev0JTAllo0sKKcq#rWQjaQyD1y7@!sG7d;`Z*vHG0n@{jX*)Ik3U;YgJCRE)THjgKr)=&kMSc1$|W$kkThIwwC7?llGKu|E9nx zaT=8=P#MrdapKcuv%dLIq1A2*wn;g7hkQ>{k&(;0-qMuKliYUU8-z?$&3*8?D%e&a zA?2Tp2bbV7g=Ge^W8}>|UzH*$^dzO#+@mA6ZDiMfqU5Dn_{-)?8@i^U8tHlJ;4@Ca&E*-|J0O z(7NZNojHKX@*^oO@Lz`ch?+Qo$c23Cy2kGWEdH`q2pNLXK4RG*h#@v*5Xv-(_Ocls z)YLt`9fSew>{@%#EnsutMq?pC*mf;z9s?YJ1gnr}UtPiAxG7La(@2d;{pY>3tr=bO zm0a#eEfwbpA}EfYo#0f6Mce3x*MrODD&Iurohe!`(V7Dr2BV5;|`S z5OQpJ*0@f|?{UfK8YK$Un1uO4+>Wu#tTtW-OYsrd(Ruv?n8`bTrRA#cQ@-nTZ5lv* zT0Ma-&Y$M|)7g_{v`iAzTBJoZC{yfq^~97X$O&rWc9)K=htOO&rc`s(M)MrSPl%4s z4i#Nw>LGh4UgJYAWw5I%?~R~P>ZU17Kum~Dc7hY$ks6$6So}~>Hze9V;)SbeDds(<8~w_4m^Kn+!jmlpZQ3Ot zuzGkVW6pIwHQ%RHW{5!jiwO1zAZ1@K0iakhlZP+qA?Uod_L%z2Rnke^=f!B z4)hRQR?1l*L~$Q1q<$5TTO1x+w4}XklrpCNR)mFFT~kHSBNuG0QKk!-;&HZ09qAtn ztisZdr3E>GOn@&c{ z3n1UhkGXiQm^3}l7m-d<^Cc;^B6JIB<+&W9pRR}rMlYLebm$o?cPBW2u0L|Me~h&x zRO#k)k3FoQFHJt!YwiYjw%7RN0Z#p)iT3ml%zH|iw`CKv_pv2!7p86yA9fO0#ostd zt&_txPod6tomy0D=1*D)gL*uLLpH(s@A@L^lP_mS0@^0UjJ+r*aU0kJN3Qf;Nzmuo zujr?>Y}`Myz{o? zA$X9Q=IpW|T$MKx`y2t~==kqH;Qx1-iu*s8I&CbC0EPgMe<|zypM^K6{~D;ftqq+6 zz~0!@$;r~r{9oGezj&wv$=^j~Fd!iDf8-^N|5h9RG0Diq(#FIT@UJwcEwv5119l{z z7j+qM(1ylX6Z5%3jS+l+Qa}loKsFt{oxM`j(e%)?Iiw$6-s zGWj+mrmdq!4KQaikX)-+o6yFq%vg7cM%4tyI`rrX7z@IHiRgICtk&M{LNayi8)p#z z`*@UkK_$f)EbV6EjJ3bNt#lP9C+Qz#_qlzEBK``*m_RTi-wNDl4l+$~9%arvv;u<- z&VM=Fzq$S{*q#F2dJ!wyo;oau(Lj~FyeHEqi6D&v_ZO6`U#wQ(0Q&P$6g4w?nuAyy zngpr+X~5Zb7B|A$il-QN?O8N-Yvj3vGq>gJ?8bfVC1PwB)o|X$KsObTB5{fd7!aw3 z9YwZRA*_cDyidT*^OdJyDJQlyaPl zJ0&*L(smN^dM>0SaPe;ICdM7L8Rcs1Xywf8LqM1&qG%50u?baQ#l=eUx%Z(%(LqUo z;G%v4$#`X76jy)KPkh}*QPDF%e5^aps15bM(T<2x6;#R>`=0qdSI>dyfR!K*BNXVvFqXqD!0Ppy0&veoL;png3I#o zG$R;~J>{gUJwuWgR4I;%P0D(^yP4KpdCKllGLN~v5*3ZJeqH|qwe>2^Osdt2)TGt!_e_`p=0AFu2R>8i%M0hd;YKt7tP~zojRY*lg9wi%`k#caU>11UUWc7&oP%YmY6C=JQYgjl2P-nDkfK zl`xaYU<9hPt5LufX#*|mHr^!b1VSd(W&Ze2*U2<(2W)i(!MlRC`&!P2&rEjP#Q?{{ zS?98^BFXRhhZ4mWW$~CIa=go%A31`*-Lj-P#dB5Ir1YiZ^P8vIBxb?2s3c^XypAvZ zqx5u7fy4=k3H1%r+yV{sUkwD4^eq!d$=iMg*?hRb~<<(VpYCyQEOs6aLl#8YHypfHdC$ zfV;bgBXD>=pCX2!J%`(~eQnGJyUKd%8qrMkQuq7wJKGQ1hEGae@LScQ1e^ z;4UVJpReup(U-OGU`7~w_RYZE5#a3c``7&2(e3BM>DNEy^kIIhXIxq;c^%tAxjt=< zLc|l5pD+s@h_q2=BzHuqn9>#ztst`h{oh!!-(648Le1p{X^X*1S6a^YXoUNZt_%gb z&W%UNtA#tikxx zaa)p{Iv{`V4)G4sm_5hEgD0|$2F27A`i7v3oH4s=ZF}RUCsjObM1$wFHf>|xsP(Fd zB>YYFisG$F64}{MWep>ag=bjj+u7$^Is=qqKAScRQD5`k;CA|MmkDz^`{;Kf;5C2g z&RW@5T(Q1f*!R?Cal0pS@#sgT@;e3b#mXATA-^^doUg!fFG{p9QVl|EE@^@0leCZ9 z>L}Od(J4MJjP`)fO)*ldRH{0mesHU}RvnY8T-xSCb{w_(%ilh;*0wG2Lzbo8bgj+4 z`Yl;4QW~Oy(Hqkb zN02Q*IY&9gMF6jRBS;zdn%wm>_Ax2mr>JkdqLSqgB_{O~T;Wd8@QadZQJqSssLfBVH3J(V z69%ihU=7a>GBMuGsQQgksc%nhVsKh>&2Um4hdXW&5V|v#pG(DCea<^c81m0}jKpls z{u{Wh(mr{Ds2lHPv)pV=CN(!bbPOn<6(Kb8-pqTd!TN&#M`q@hQFpRfQE@A5FnJd7@t@K2h)8l6o`n34z&qBQOUlt!|Iv@ACI_~K2%&Ur?W*)(oJ`J{^t2D1AZ4(bRBk8wTH%YGXA_a}4)eREODVtlJA>$bjb9p1`=Cz6`9 zuj`Wg+!ttc9-V9yd`?R2P{NE+&DAnPTG=B+ap-NaL`EK?21A_(dOdFBn=ss650{qkE& zAUmu+pBcTKp73?5NEswqr8;oOA(@gjyuKVG?X+b&7Xjg5ioGXrH*Ufy1Q%3kxLNp2 z;jI)O%{3epuinKZPmbDQr7o*-#i3W^!>P zX<+*o81vnb`a@ovkIN2!m!KF&=ubUcSu%OUwLEucuxz5dOqCzSCEyidhQKBLs0lEZ z$MLn!{~u+nv(CwWdITUKZ9yO)$^Tkr{huR-|L9r&iZ5K@SlVxhJvV;Qm_Zj5f=D_q z*eI~p!;VPe7(4w+SODG7HI#`h4xmarGSu99@44}EiWde*jLEgY{$-0_&GvZdv<}Ta z(Wj_7yq)!WJdNieHg{~0eFLPRzSxN16X5ZZ?F`>Bn;i1omq7*mY&+zMV!=uvgVU0| zMJ6l+zu!tvMUT1BPPyYIj4Y7s6Z;pHX3w#Z*2lm$lxm|4aZxctu)2$3;Qp%D&LiX6 zL%ut3K>=XDMccS{qj;mC6OG43ig~9f1C{y5_b&8A)A5#6)O zrRh-y{L?ReTdQ(wR7XY9F7k;MN;M@l<;Ua!$=CMQgjuN7F2x0A?5X_vv8JYpK} zlJuA^I!ZUWBi@-!Cd%+P_ZY8@>@;JiBcrqj@!zu$$zH(X%Huj5I=l2{7bD)u)9?2E zxl8o+d*2&4>zH^@XSx3dqs;1@3rU++ajm30x|-y zQo;s5nME&&XbdV9(;D*WI}oTurGo1+H$>ZOUM1QC~Af{NOmP0W)TVNH}BaL9Wjl^9B zYXzZh$mknX^^U64Ep}9RrGzw`gO@+Bm@3o(%0r3wi{il)mB0`s?Gu12F3{|zyyuCX z-uG`KY0z}^1Gmn_v?T4*)9>~n@%R7=1c3^0kP6o@p{!vvKv0@Pdo=#0-si`Z$@ejU zWt8h(t`CEH9YGV4U*+9}O$YN3rF}*Fp6K;wJ#s9?fT)3tPC(OA$xzC?f&+h@A$os- zmmM>hQt}fm@}3SdPo1-FW(#FW4fHq`#m)>u!m?if)d|vuE!@qlx8l%y#vG|_@k@r* z+URWVccLKrVs;S6gUTxo7kRAl0)ylmy!#SQK9?;>z5j`mAXGR9#TRE_FWst+S022C zw1=uqpUoI`tVS6rAN&__@vr#~0Y-nD%ksE02fe-#(ZG5$NbP%Y|2ozYD2Q&lR)0DR z1C(P(o&M@*1sY?>7iW3V5|Via$v^}gdq^h_guG#dWggms$iI(7MQ`k^tan zii06bVG4@1L@EA|s@1}crv>KGhe#&zP2);1NNAzD!K-k@d;&#Hj>_19f4LK$WQZ8Ec# znhG8}R0N$%zKHD%+hba4>JCi=bN}m5QKOX8N-vaPn8TTjx>!^-yb3w6tjl5fHH1=wn5OpQ~WYG1l_Cm5u&0wH&)to?!Swpdm72pOvy#pM@!B8 zERlt?knwY>`y!a%;31dC@s26GDuz62%EL06Xc4)WdQ#F{e`FSm>Prq0t%c&6Ca2;p z7tSf)B;>z5{ETXbfhtmhWId-!xZnewpnTj2lRj}D1SUd%bA3MOTd;yQBpu6`!m9tp zq6;)*P7rY{PFg4H>Kar5!3Q;~Ef>5S3K)x^z1!ufga(LB-LIa@l9i*6v^hd>(abv4Vd}GCttO5v=ZOLM>n9#0xkfQo>NHCB z$hn%JQE7;_WiijQr*j*(wWTg!eskD3(|D~df<#M(Fwufn_jSWy+2L*xaXK(k5n6|$ zrX#;ijIYTZ6U%vWZZD~ZmXI5zI8=>LJ`S8Cffi9*Fc+m)TY%6PwofU^vaGGXtV001 zVu2ZwBkRH{heM8mg*^+xYaEy9kPbkA8=FBEfc!?i^}fat+FjL&&cN4tFV`=wYkY1I zepHGm2ovLO{n8P5KYDB4FA;|mahBw=yn*ax3L8+AWyWEM;ZYnNKRb8l^{z%yrJ^t< zLf!b2%E@lX*a6)cF}9xb9E`ld&|wUYhUavC51`7ylT)wK4S zwcX!#hm$A#h8U`i!e7DkFE$=5f!9MTB!7&CDoWoh+xlNKrx8bxUyL%o9yEOd34O0LVIaQ$-EsU@$u=hh^5 z7T1j!Q4P~#Q(7}vo#&vQ28B3f{7S!Jefh>`s_sG5J zrRJTw+p{hIW`s~T0?wxQhtjZTI~`flCf$pzE_QGmT&VJe(b$%;8X-eeSz>u==n1DY zv-B6{3)Jeb?{~gLqUU1A(JdOSDBT&w;n*eC*he#33Wg)e2KN!y$~gb37F*3Di(-6v zyptgk*1VW;S@fdTrg8rkj6{yDHa1*5|*nRw7GBrq1M2Bwf4(_u>QTrTJEI$EFBRAi4^FN|XT1 zhyG^bpc){95SAccer+vv{PnXykzUsY?(%;yt>r?8jT0c&x)< zUu49FALH|31#UaYNjF4?1&B4qtqJrPJm(*+|`Bfqu>X6lY?LWkQzJ#xM}$NSRjh0fNY4%F*P1J(SHP zWx{n)ASnA3W37%E&ogMAH-%?@dt8%I9FfIwJ3_4kmi*1r$w0F@q$rLqj`WY8u!n6- zE|-sBXS}p~tkiVRgTp0SpmT#KW|oddMm%JeA2So+K%jdqTqczD;`+EJxO6GtYC#XC z4#iw+!POLcxC-gRnrfp{QqEy)oMSX`c60ft!qi!{iC}+)U?ltUd7GJZ(#i{Cv`OIY z^r^C1<&t_(EcUpD)e;z*7e`1O?Bj7X6oH6_dbqDq!-A@rpak_+ zjKe&DEaZ%txF{F%563z~Jo1rbQv0A+#o(a5A%yXz)Fe)I3!_X&zUM0 zn}11JYgA?J55(a9ZE8jgL2h@j58u#ibzzP&R`IbX zEjwZPJ>1E{nlyE4FFr0V?h%nd)=I2sZDO zns7>;ax#=YDK=y!P=!+xm7+v&7ocKBS^Q3+dy(mJ85)4;+&9~zyMY{Rt?;3Kp8e*_ zzH#%S-Y?ue&z@o0*Ou+0MSra}w?)=x_lFk)E0s*+vr#G4Y8zkRS3lWM>a3X&;(DM2 z?R>^Uw3mH~vM6(i(#@ux#vx-pb&l%BxQm6gg3_HWB(WSCW3G5z^ziKgkCvD+!o5e^ z+uNQaXx_=ilXsKmw&-nL=+MBqYnvut_34H@qrOjoernYQ6=8yy$L)~DAAbXCax~)^ zz2Mb=x&>e*ONGjuL=~+B6=Fe&N0#+KYLFmybux}-Qh%nfF_k~r4%@8dQK(a5B0%G2<9i7ensaTT;haVZK)CIalKbSfbyPbyLJ zs%o)@B0HOqPnbbVGF?;T&nLEPD8uNsTsFZ|Kz4!Y26{}Oyk?3{i#kftGSmCU_m#SH zMJzPL5UU!06=$+iA?#<#_^%yb3cXV2HfA>6`0^akh-Ic8m6o`&n6Sw_^G7kifRf(P z-?z6b;X@y^wApNTc`ykFQ*-qD=^LNL`&qdxuubM(%&ET@ImXAeXb<rI#yl=iR%VV~@H$8SP?NIEQF+f(Uv!!QQ*t*Q-4EP_2g0BK zbYQXzVJJcDY_nMbRn|aF=iDkalWO%689;bo~o)ng;;Fbni&_Qy} zYvOu&EtVEu?gqOMHRas1Rkj4A?WJ3_y9jzip%@TfTi#D=zkhV8UYaVowf3q(OWcj+ zDf-w|B3ckx_iOB_i!KN!F89 zEXi(mWph>}Xh{poL~udwZtL%lD-iD#iIogJ6hBV$M2+5Vo>iYZ4dhKfX~=!E|OS}LN0l>!#u%}Z2xoVPYMw8Jb%bVNxSLsAhR+RwR%E)`&DMAqrYeA%1<=W(28F!+E z#pz|07|pn3^xf3{0meic;;6r5Y27_ov1C0>4o~JDpN^K$eEG2B;^<3@7NB)v_g?S! zO<3`C^>)ixINRMJe{glPAN`GIXAysXNoxW3qoFBWU!2Nv)(UEfKq#R&$MiTg$B6`;kc zjx4_ABG|}j7NZGY)=3Swfge#M8*nE^2U3tw4u`Rk3E{?=IPft!JavCtzRpPWMefnk zvpkM`x@i;_l*t;!?o%rMx)}AWD1o*pqfpXu^ikgfJSv~tadyG`fe2d*b9|h)pa^65N1RD)*Cp5^i{`V z?=`Q0s|;#QTDCEEh=t+^RhaxhDyg(x#k9c^)3(wK)e^gqTJmUItdv5l7#Gi@QhR%K z#G5oCcMQqM2xNU)UF+z->7ySmQTIGUFHm%23InClPhOfbg0GVvJ0norhli}o68G`K z=Z*K56CfwXaNU{#)__hl#rF{r&rmR|kil55FMlP|_+s`juTVcCG~U9kwm#BukG~De zm~g3juIBa6d9Rd;JshWN7n}95vkfLYK@BlMjWhOWiST;Z^hp|;ZtA5Pm_vJqzfiR* z45KSU&;VbTHHrD8Gh|g5Mrs&1a zjgyl%ZN_^F$F2K{u-0lIk!?4YonEmtdGem!OYH`f(bTFl+ zBQQUCkD4M}Zn5{2G?c>C$kum=}ZDskDP7i)w=!G_dIHhB1QNzEa-aPG$W z1f>^TY3m@1sYmgbhKj$3KrU@^&<^FwhChuw5Na4uACw|w)7`{rGPC2EXe-*_S$l3W zcgDt0VcwJIr0rbl$J*Ag42m$vyZJlmkug5K@?Y@bWFYObpLKg94~@>4KY6OB0h z2NZpcB7_Cro zEq1EPv_cE%@@Ji5i?nG3!3Sy&-zhTRrgy(WPQiU*3_h^tjtF*oE>F3?%viqm?8>si z>4$P47Rb_AmnM1;Fy^#Nt{2CQ6r;U!q(n^hpISSFz4`LHt*uPyO6G^wiX(ioA@uQ* zR`yvKw<9Qn%1(;NCCOa+azGUSNlnSefz1+%N!^4bbZr6ogsRB!V_71*5~_8NDiC#3 zNAL!>I@Yu9d^bZARfzGI$y1F}fJGp5Wy7&Nk&jy7rMq7pePr%BxQ{`$HAui;kuMhV zYc?b1tUI;#U;4NYCQkd}>bo%S?xss(4bJ9PwIvd8XZCYtO}%9*|1n39D&?x)RyleDyp76b<YD{p_-4PU%ysJhC;&SpLYe%$OlLPRJ5Ad7@C;xMpcH3Fz9(t*06q&ONE$P)=MPaQQn06dt7OXS;jCS=~ z14sNpp8T6^s4}g5oEPuU;7)`z7AbJil$g3)*SzJkUhxot0){%IVx{-x9}>On$;R~= zsHJ6*x^-l0bEa`m_KZ8Oy@vO)UdC@{et;gP)Pu2T+`hDYlXnVEz9s{p8P$@#S?TjC z-)=a?)XYVM7?AQH^ew|j9~s}(0X!Sl{&{)n+o|+KJD#Q@nq_&%!{2l49XNsTqVP1W z0w8XhJ&vdqv4WZ>WW(;9>;=idYstcw%e}u{h`-=GyagKK)vi;YdmWLb(J>6fem`qP z`G$xc|A2SZ4_{f0oeQE!BUgsl>V~b{f0(R>-6UPio*P0=*j|8b_uAiDQHDax?B%HP zgGXiEeyj`L2tQ@_eRD?JfnGD5tv#GP;iw(B2|pNLsq0f-*tb$;#xFxk&OUyRn{gN_ zDYocpzLnu!MtsBmM65OT4d!oU6Dqc!;SOa3bsLOdYAr;uO6v`%B1}SK>SqjP zU_jLf^Nnb!Cr}F87a|QPLJUo+{iG`}f-z|y*w=n+OTeI=@8bK_YN5i% zw@K?RHE=z_V^RJ_e-0mHskwjV9J7zEnYS2{9gO886*4N5+)5wHLDV|H9Qiv?ng0aK zFe^3WgA_FNtR{M7<|^u3=IlV91}#}y)reZY$W1#S1&(y@tvEs?&*LCIXaOCmJ9<#} z27k!aq_5jmsDV9qzzcXw7yc%Qfj$2~JNH%S<<5h?+ZgtagfvVy3V^?;l*%6l#6Dw_ z!Z>WljPD!PaZFlG1}muul=CP9 z65vG1Pr$;U!$=hb$FP{T$mt-QLE+$(*{|m>Z=nzgX%iJsGwIHg7?J^%JunovWi7b^ z6l(o7<7gn-Z??4K$4~NbogEjC2 z*_G666XMQV%^|&4E*Q^& z*YNzPx~-l#FhlfH!v)juGxMUtuf08-3-Of$dkqQ@(^`!M{-UNdy{`L_8aKwUX%V_> zjzK>O^04i>%!Fn#UL&!S9N#xAXEf`KvE(FHq?b3j{pp(@6pLBq3+^U~Ehi7;ppsn; zt;2?wC1bXpZy11{qNII12~D7LM(ZKn$z(Ol7y^DMr{o)Su1AAI;i)O|RjMD>8Z3x+Q&>4>{rS^H^Y`AT75GqU^jjchJngk)@o;e~4347dg zJ3|et5SKRR;}19Fe0RpDMOtjW1+bST(8U86tx#ONPVjS z1#aT{5&lqryBDq3pZb1R9&QV2%e1XzckG(=Dv6c1Ch>dO!3Vv?Y0Qq%s!x<^4svtZ zNp+ii6?={L2f*+1ATosmg5T#n_y7w4p!rwS&^9KHMxO>rPDTdSM$Xm-P8OezN&jk2 zEc#TiW3wZ8FR9A}1H{8rEnW%ZpA7i#wv;Jo!_gdtOE=1bj`RZ%Un@ZJgq^cl3It_ENA+CW0ZkY=wCE zO35J=2#LZZ2kP-;hnje?SnQN{hMfv z`zUXbnS&Ns#-pRX4<5MxVj5ul?Pe;e;!eK5&h{nt!7& z<$Xfd*NwXcqxTLrQxAR%-WGgG*y9=Zx!>;UNdK`5TA~;ce)DKmRe&j&83p-r6T(5Z zPbDc{CR#@Zv}AU_QlB{}txcG=jA%sBtgmGV3n`T&RmHfE=~T~V;UH{R40xBg#ToXH zl9=$9yn$46iY&Ngw#@O{boNYT-D$uL3^Mjw2WC1^avTJ|mF3JprUG|AzfBfk}`i8Ko=ZpLW zwFUbMc(q17g;mzzAsQ8z?0nHXS*%qplS?#t_|q#(Bs~$a*9MnLJ_#$6y+cH5ZtY8(@+^?NRr1w zsOXz9qV+ch!egQlm{QtCuAXTkRdG>YWsekHl@$;sp{o>c4!ByUDw4BDFS`)gTHk(X zJp=1oUYSLDXY+EmTdusNnv~}%vo@k^hYMBK(?n6!eHno|I+Ag6cZNSDT3g?#YMdp` zin7(=mOFC*_j%PIUmH&iFFPo;;SHtY;b^MZC_{?;&OWm$wwiqC8ed_q)1|#d%>6i4 zDFgSHq!_5DlQFbGP~G8;VSCPrP(i<3|L}6vXKW2KbZ_1=x?E;< zM7KsuRS;gnJ<3OE;LblSp2RevoBXl+zEpdk z2?d_6hkg?F(@= zOl2eCRrmN@bMHTh^4bj&96u!a25|Lbbt`oI38<}P-%~4?%Qw*`zScvI$Yh)qqs(!t|xe_QqLh)=U4nH2PrCV#%UgwMnRM z^ffWkG&>*)j=WsnOd%GV{^1>#^!wC(!iet3OCvW7IkJ95oDCTR9{-B#pIi|I*I{Zo z`W(-2dIdAi@UcP#d@W4LxUn*${)Sky8AKP7BTl5Fm@>v>$o0jC!KuXKcgR|z(LK4k zQp17HBn&3$I&?+oeAb;egHd2!tptZpWUU0azvOqyYel5=3`OBhj@`&9G|Y`!bcw7} zzsRte$NzeaC$JLMz`MOC3EaFV9F#$6g-4I>fi&R|hGH&>^CuR=S_W(2T|ekA@kVGR zPw69;&w3!bEA%DI5h12QFLdP78MYt(9>T#{*xtCezKM32W^F4+#wfqSmtl;q(@D%Y zdlm%i!j(FSh9h$xw7a|3FIS#ICu>xf&ae;nCRC!ju5enusUtKXIEP;izyk>lzW!$2 ztYWyLqqH|X{ivw1wruuLHqu07zdQkzboKMYVgd5CGXi}wZ{va${#K66@tu}Halw3InQ{ue1DJ~LOgTPypw*sA@f1=X3^81^V6!{ zLPMNATD7`s{`qBF-e%-^kk+fQ61A7FFRq9ENnegBPI9uv?4gW`T*YYA;kfpYTR8ZA z!E=(dOd;y_dAD}Dn*$0OQ-$c1S+><6h$lEY$E47Ga_fX7TYhE<53@IpDV-W`6S`1^ zvab27z&U;kBBY@KLEM2BKNpbLwya|AB@thSYKGz=m5RMlF)VF0nxFjXSG9cid*Sv-Y9q&0t^P)Lp{nC8>Xd1ts8FzNF95_C$#qgL3Eu4MCt)K4Xz((GL zxfa0GlMGgNn7Gu*+6UQs7N82@XG{zVpw(1vPKR#W3?d4foKH0&qj&ikus_nXvK$Md{o}w(w8q3a<2C?Tn_bsG(f>dDzDV)@~;|3VL@;C$_h%5~X)c zdkt(7j)rpg+gH_+By6mrLTb!i)x?-?bz!XDcI0DAYWtU0M0FTo@z2qf6JA zH5Zu0ieEOxw_ppM61Lhp=M7jct@xL#K+V6TJ$5EgQI^k$a<#7?i5$4l)|d*@HW(0E zPM>*vo7$UqTz5UInPph!ELD?)mv#j|;1|ZX{2KIYd&<<><^6PVWrhgu< z$@~>%!RH$2==`sjz+hFIm|Zr6cdyq7i$;9?!Cse_{PINZB2P~nm4R%6wYfWJrf^`j z!1D&&`o^V?O-ynFNe!*SD?@(f+i~WY33o5zcoh)R_UvPP0YT_b&Wid^=R8%dB5CEC@^Fx2L;fx zWxzs51&wIVpkNt&!uLe`&ygxIFLx9$8YE1)zPMD@;6{~mf@67((T53U{+g5pfi)=tnmOmF#k(zv};0@P`w26{EAc0W=EKWMJKj1U4Hp%&QH*Otg+ zVW}I&2w!iv$Q`2=ji6hOHod-npbNai%X|)x)V-Pqgh~EhyP4Mw1dfOh=f?!LdB9l| z5(@cF59vv56ed;0`gC$4WXSJi?4WD*%cZ>RNZddZ6LK0@m7)QZMWcgq9EY#7ntCec zk(&XjLmB%p7TYO(YFeZr%)^AH^7>FJX^V>-^(r_?YihYsz z_A*)d^V?F9+~z?Ei0R`XPaYtYQyOsvt&CkGb83t(>%7T03d`pZ8W#!x`Ok*AJb;ac zlsxgCcjWoKjuS9~L5-6ctK4^`(8p6VapJR0Sc!#25KS;X?lW#o$UO2k3;aao<|zIl zPAYK`>Si6WlQw=i{{29~EC0}I?J zCzvX(xX%uPQ12V3Gf8!3VAW@8Zv9mXlG$?G?%?QZB##jwIZlglBl|4S&UHjPv|Sm< zEG|u!Z70^G3msk>Sv1tfLgLl3Exw{CAyY-6=i3$tFx0!hP8wNYnUd%3B5jrcn2t`_ z4;%SYfwcO{bduIp?!Xe*x)SbX+SuCiBEs7v0K+P`ECIUGg%Dt}wM!khS*+wkAuK~- zqDQej&Jp!>z05*=nxifR+IoDs5(JPo3q*SFYrOo$eyA^pU1>6OZCbXuImfAkTAMrI zOn!tkQt9kJg-+w2Ogq&d#DxGxaO*l}}L0|zcI6BYR?EZb`Y2AhBwEoxbK*u|ZbK=vW5!|Qst){v-z?wHV0WDTYZOy-b9Vh-$n142RKg@+O=eCDV|RNYkM&8KS3y2AO;M3V)aIjhFlj zL0n}Y1jrXf|A@!4C%#rAlJFIxYi$shLoXlv3A$=K(?Z|7?AOg4nP>He2XX--H9~76 z>|zX$(~$>1ejUIP|K)rM|Uv#^=c-ynRA)e}m#h{Okl{V!ezagT41amh+41C$YedG-udwZ3c=BaFS8#B57*Q9HH0(U4h24E4IJcV>Z_x`d^bCyGyg1U53spo?*_5Y z-cbL{D}#xVu-e|4@~*>SkpGV`P^WtU>t(#T^K{UB;Ib($MmAPjZx`!s*#4p^fh%sg zr^PR0HFP4Dk}khkxa4b{rChh4SwfaaQlb}YktqeD`HTnGW0(lM5NT3}OToeYxv@B& zpz3!>DXMmkIG=Fo_^+Bt^tb5^02E2WKt+3tmi%BtT|Z2#f5uu!@cjTFwE>`CFazQt zJU~$d+~JPh+*5Kbx;Hs9o(Fcp9^>@@=cFl;_U-Z~f3Ed{4Fg>+d$+C7`(-%L2^-Ag z_;X+1gG9pXg9M%B0EAN_0z@!H*(sSW^-@fe&n;$CEwBiLRMZd%67&oN6p!l$Cn~@E z9FU`IJDhrZ`6e!Q@;F^T9l(_{(M!Sq1#pUWC{1D;jV+IzzRV^Lq&iYJdasxx{iG1h z-KDh3Vq7?7kg=AZNDp4An|GkyDu?PiA}8C>UTHcM0Z$5@(mo* zG+Fe!AN*wn)}$;UGP(@fuDiq{OV5=8!$~>pyLyU3S72yV>t-qQ{1lVqeHXE^JL_{- z6Ofys_sAWbdl@FP@60(`$Ir$6U;e*5#`2@~NPZ4W64rZd5?h)GEsmu2cTV}tQTd?w zv7tafpeidKIF;K$l8ABlvVeQ|>ytN7Z+4FnZL>n#K_ZTa25C2Cp~N%ckr-tf0fLxM zU-^;4eh1Z7=5z~9km3P$H=OG*g)K+{cWbIzqfH%;i{^_L+WCn{1JiuS%mUE280UAV zTkUD(5A7hn0;f-@?Z4~$BFITyXRFU1#|8lvQV-5THCx`yujdJf(qBs~J2u7fmiXz| zE~~uKid*r1kpsaO(DB5%f7@9bb9dMc^8A45<}9r0wpv`<2!09RRg#T3nK%1mu4UgTmfy+ktO^4 z$ByvC5fE=z%zLs%ACe1|aL5*61a3@{OTchMR2=Tk* z1r1m}_$&8r-tt^IEa4iPB}bW zr`{6=g;tB9FKRR1)a^Im2UW}p3zO$3gz*xILwub9@D3M;tzSf>wIiL^e}W=#>fCl% z!?LlA?X=4oU<%y()->_%v+mR!_|biFpZO`X#LV7zYg7`m)4rC3h^-{;kduUI$_Q|H zXnI9MU76nqXI`aBa*PRsbqM)D`kMLFW6md``Wg%4QB!ca$H+)k`G8y`vsl4Er5CV| z494GpdWUW%Iq=N4w@WD5w=HMua#*{T*W%sG(kimRd?HegULmwrQE#OJ-^E}0p{5)o zn0omVYeZ=GmExYm<=dCU$NDvC@~}jDCr<^lcsT%)pTxB6l$td6Z^9a0mo=mTh7hU zNx;i~wujcE{fE|+r-l`(o;mQ|Sd%5e%)kzOUGT_e7lU!~&7FH@IcTxg&<-L#!x*zf z@_fQqAXw6s0oulbbu!f`lk(9W@`_56BWM~>QV$={EO$|;s%GCX)H(ogJYCl=ntbpk$VN4GkWQ~%Y{ zSMgm*4L0bezmolX?CdOrJo89Q+3XmBR{Xetj%ypIVOQ$J(0$M-XBQs583Qpg0hw?e z)X@!2;a9SLJ-d*(v|C$__7=XcpNr%Qusv;rqHW({{n|Iuj4@Sw$6(Qv*b|JV`9xYV zo0d?zC`H%cXyc#BL;DJ78@U(@feUU4#+!Uaw@)0A!4VeaBS|FOXR!?&*NCQ*gr>bb z{aR&W!~O4tYj=h#-E7QY3qzjbB^8jXCDM`oj@5JHFIu2Ajw=>oOA!7}eTEP$jMyW^ z?_pkB#Qa@ut@IEpwlP2oFu%lf8i;@3!FCHV2pKG02c!3%^Eb*oQJp z_&$QcZgCCiu7UM`uS~yoa9DI83B?tYQ@V{88#}NPYXA_ z?1$`#cvOHKsF=sX`&vH)ys-XEcm2v)SgMCSJxsG128= z=ljh4!s$=Z-rNJ~p|D>1t3hoyDjgOx9H<-D8&ddTcALlY_tM+P zow;LDAdIYTeE84=G|o#sxzLx~Nl1EzW7D7*Wx0@sjL`+_+3xi0y}02Q9CBt)O<}HW ziE{yc|DK2^wC4ERnX4NZVO+=cm`;+k?}bT=NwnWP=a15Q#Wubf>|1Ea(}sE**ea*T zQ~G)7A;m3+UQHN2g(5{xtgP31b1Z1i6&-Qq#4FS;Yl_hoW;+Nuuk5gjDK6f*eqP5 zy9>-WE6Z-{OsxYB>I7;zjRp?vTKarkK^+Tdi8OyzsTfwV0465^tR9Qm>|L3S+^(wH z6y#s(F2VKHCe>rCTqQ-l#b8wRbJex0FSdE7bSf~$+vM`6X_cZgO8GJ{)XY#F0mv22MP0r z3P4B)nCH7U!d#5-YA2;eb%AwilDxq-h7}9qf=DlU0{R@TSZMxi=Y&@utF@}wH}f*p zxhf6c=-(jG5gMJ10P>)_g)HF1>({sY1M9qU+t2xDFDHJ<6fnaJ-=*Yf2%8l;E;9Oy z53ZgeY*}6`Q)8b!_XerN%s_7?`uskw+RhPQzuv0-~LZt~QaZ5XVbB z|L9T`RYIa1bI81C<<<}0I9?_?oiJ3b``A*3@J%`t315sagY{ zNZtrja)d96AQTQg9;Un>RSv!1V(eA}hly7flv~QM#GNy6Z4!vaf6zuFDytUTl}dv0G;BmvsE=wOiy%O9|gHR-7j3YF1Vb z2A|GMUEBe4d<+u4@h|&M(M`U{_>Fvi7zw3)fDsslOhd`~3}}Pc+6YofO`=zQ)W;sJ zM!H9>T4yivSqKipa0zz75X%X_9?}5FK-t*a%r48T;II&IaO=nPja-i%-$%3&Ny7nm zXaS+r-C=2xkfYo~24iRh2`6-4Fi8l3w~-rtU?C7|oC(k};>Z!C6H#N%fJu?W0uO{> zrj=F+KmfU-V|K@@(e zV-csJ?gcdbMZfG{g9$t{d>~@V30>@&`(;Z$9`GamDBmv$3O00yB z5)Thhtrvs?>j0`2MRI?jff9}c&?`uI#qbT)N*2K!4LH-;m%6alD?7eEo&y*J1+E4x70+Ivz;C1nj7U%pI7K!&p`9c|aQu4LHz)_c!F~K9ScxkY zF^mbt9mhfda_Xzb9*JDeD+e5P9%x*U%W!WzS|d^_3hu-^{o@w{s_wCA%Eyzv*!Lto ze|K=#(lp^3lE5fUm7pETz+TwTR)p~0+gQ%Xo}C`0K@-S|_h6?1&Pb3^T#q1eWPhU* zV0F>`IUqSuH}fkAUKfmO*fWRFC!>H5iOef-y#f7AqvVoceQ~6*93)PjP*)xr1o-kt zVZ5L;c1h)T4y>7PP?bTUA%!Ji)QfZ5dYx2+QKS=o<$VG27Q%BZQFAlqlxTyi(0fhI zfKx!x<-=TN4v2IXFQD3Ac0+)Nz$Vd_un}j=kp18_Y{t2|uLx+A7!A9@W+ip6QN#k@ zUK2B2Dly>&H!A|49QEr+Fzb#>T(=hXoqz+#7(rXg?|6y;Q*D8l)gdAkcqk!5SxnQZsUZ>z>Wx19<4l3Sf6&M@5#g_Nx2<^PbvPp;rp< znRQ$10VO`al%ljGOpb2@EK3}(6piMlJ3EnXbr4)8WSA_t3h@ou0BzQRvD>%S-iFUW zpafPvSYlj8vrr!7sSQ>}pnL#ys^Y+svFZN`4I_R8pd%6L4mYh2{*7TiX^l3WECHHg zM=%2Gt!zDDp%M_uVU?t@TG_N4k4d_-hi{M!9mAXVo@((K%>4>d*kw7KK&I^UnZYj# z76nN}GERB|An+0OdO6<}>#a^Z;LIlgQlHWthA~sZ6Sck|0T>uv4oL8cqsVIrqpV7- zU@YoXvEi03>SqHTs5Q~~YNTY0&u)*9AUA|$o@H;oIAA$$t%lqzX&B=vz%PnR7OxzV zs4vN9+@<+|>9L>J*`Osz2?0b*Pdr(wOvr>ZROkRx zk()6DSz`<9g2zzBjpdk>1rZy}RtrB&?bLbFl?VK?w*U*zB~@o$?(X@P4ZVbT;5LlATrF_ z8MGf^+b-7xYj21!?Ol0FwEB^S6{u_9hH!4WeaQGU5cx|kxIJLOy_W>>)wiFWGFNHC z$TY0p3tH;kX*Ly#&sl8}Z|VED7~NKO81sHi5zutAhq>VkyMzb)Vlaw85u2SFsn!*^ zv1syBJMfYSEqIaJjpg1QKEdK$g$pH2Z6G1auM&i}o`9azj-A^YC4kQQ=><&BCHYft zgzUh~7BV)bD25!dP^&jhsIUSOD)Ek`P!LzGGEHvPGT)HSC&-d1)eu1iAS;LgGk!#f zhM)iuV|XbH7Js=YrNTivu3LkH5sl6|G(AhcVci-CzS(6JPP9I7m=rDnv~40!Ka}io z{zj#EZlr(=d2zZnx9OK-B3FDFDDX9eiSccdZ?n3{%OT;0Vh^RiY*w`Fp~EAX4r_N! z>9tAoVg%;Q8I?!D2P6TE|NY4K)qJ_Ww=f6FKFqRvZKfYM*5&(7QL8{%YJdi;D};1( zsGsK(#py_F0__V2Re_d7ZS=0nLQeq6s^#dNJf0e8L?qf0Mg^}YM%_O2S0;&EZ>y5l z1JoU879LGf-R~Gz9aoI4m835ELhucn$3~%C8L>mz( zNIcA~-n6)+HfKb3s(mI|01qmtPH+{e(9AC@oQnp;*RjBn+=zH$WJCp z)DuoeCk|M-H-ScBYOC`7rQO#kOtld(dvByEY=?U3{SPA@TuZb3lw#np0Y^vea)bRs5x_^Y{phYm*$i{G7WLHx~y+eLU5%WqYnso z@d1(BoMBOh*K!)cKHSq8qLWtoN2D@ppjz}z7BA#!Bd@Oh2b8m&crrQh3zMEswA5}k z6pmYe&k(piB%m7yyWdmPt5@ogB{-9g{JASw>uq}0|F8q9zoHt zGGbQ-P7(_uoI%;d}mp57w7^8&rg1utL^j#~O(C;c~vp=8Jxs%?p(7K#t zt>#H}9fJk&;9$eAcT!)CG^?-fWB4p>vh{*sl)XH`3ECPx;1 zCGchsYCDC>OO20bjCUqW1nWi0lX+Ekunw0)G$vvjZIfN(&1vsj?k<@W7{aLcWh{6z z+dunN^!S%_z6$SxRtQycV9`=%`s?-SuiYW;ob1jVU74x&vz(7c>q@>37|Kp|U$^=U zgC)$3?@Yl+&rmL+fSygs_FIYZpT_bi;a8Y;)U>SB71V?sTD(8*ecJGn`FSO1adkIs zhA2#uSZ=TO8*$8SfN#zv`{|qw`WO(Kz1u#kydRaTRAUmYBgU?)A>zwLDps%-AuIGe zthQpeY(xtQGhwIaF5lEii4Wo&QOWt;J7hiu4Z#>$WHz+O(RnBHt`B(G5tC#V)f6I- zrT)*D76p7qae%p0-`V8ofuxXMU`|t{H=2tb!F0vr9E>wqK>)r-s8~7g%q2V38GuE6 zKk<|crcOrrhA_XGyf65LM!JDFs;j!y*Npk2rUBE6kmvXy$9f~yPlc_}ThuP1&UAt) zIwt1X8n#QC4um;0`k*(r!f@t0hjBN!2FUA9QWhS)#d9qb%~eP3kdpS0h=r)=GrmEqV%`fj% zZ?Z@r#66x>OOZONvWdCQrLEUN-4-02>i$eT?UQCzjH9@xsS$zV|{yLz8X?$h`q7eWN)B8iDbdUak+93C$K#guzp>*|hsZBuN`+3sQm58hascS}7SHK-FfwtJ|=QnSr#axqyD zys<`s!IG)@;jl$l`i0nIv(>G$XL?RiRWFo0dX{EvrkYN*iBuySJ8o;JQNhI6Sl7^H zQ~M&$dpl{81#65cqJ#UZ@fQozmo3Z1<`}2re$B__D}ah4G2La3=8^bga+Do@hy+h$bQ{ zDji9J!xI?1$i;tQrKDA2&v8F9xD$EsX6fmE882~TuuQ(Tm!JJmHJ$d(zwK8;6LoAM zHrh~mc74TyZZhRmmVAk@mOO9vUCPlm(WOp_wz>r`u@jB1(s6Fjf3HribCMsj=!k-= ziwU}&!;>{!s0vN@OHZ;lO)9hLSh0~=x(9bV#b@NQn!l)^MO%L!&RGags}$K9a0+iz z$9EhMt6XztC?+y>mTGpEr>Idn*XCjS(IIpa{QjKgeB6jpHb6XoF;@j{M{v_#U)rc% zvaMy7O;$EPT1mFJg@s`A=F5ObTO0Ca;>_}vyL zK|~^@;p}c3^=qAWPyFpw;b83#$4#^ApV^^r7Z3W-LyeL5)-lx;{f*g)5M7)>{(O0qcjlKEr2{sq7e z{0<9Tbch0<9>#gzmS3TprQs~H5)epq{?P^V${EE>aM7(m8y;X6DKj{SU980?0`#L; zFS9Ia$PDnu!Pf~;Nr;O8F*9Ruyd;n#A}zVsDVLxiX)k+AUBVhW6j*U8^bSxl#p7B4 z$(q6>u0!y8_V>Xc;0ZhudY&6#JS9d|mU|8qWlmEC;=a}@RsC=Fpq#)(em9|@nSK?D z-2QBQ642+ZEgZA_WJY1N)bv;~n;khW;;=CerC1z8QhCusk*2G%tW2DBRSQ$I{g`(Q z31z>skq4KT;<9~EboZ$!xrby{dIJL`4$eQIsB-czr1!8rIro&8E?bLqo~mcqe`2ZJ zy>p%gR^~g9_nY{5o6`Co1#C_Jxck+-^6Oz`P@6q(#Nt$1e99;RAN{0A!(l{78+@tT z@xH+FA&QMJ_TJ2$@<_pHl^a$bwDA4MMhMu-ks!h-8Ol1Yme}5HV@+exL1H5B$kj}H%mS2AmhNH{o+6&wHj!-{^_U;0^m<;;R^$}4S9gMS@ zVERG!>tOB>Gas$5ow0!8L2@pP;WFI*g`<9Gg!yYUIN{r&{`n^7X_+OGu5+QDOeF$N zQ$P8(O%PJi=lRdtVFOoeAmmx0F5R^_7`U%m{>v<(z{v#s+Vc6M;Jf)m69_o)ccIu9 zA83f6*a+6_Ve3HuZb@)DD7$_ZLP8i$eLvvu4S^N(Haill{x|}$k=a+}lzJKH-(b|Eu zyFbjAR0(sy+9!VSb;5?8!LR+e+C?Uq)m~9gHd@L)q57r{i_oTaLKm;) z4Dx8MgA$Y&tOTmzO;mXSzIgj`lfRn8h~{e?g7law?`Bp-M8B6AmYdw=3?@ zlG!S%q-7!kD9(>dS9m_(_w=A}6ID1`4zA69XX9REmd8l;=OqT=BuC2aalSy;FY=xT zaicod7NtwZ=Ptlf?|_+V75LHe732#aV|yVy!G7WpPG+$TMS@_|9G=6kJe}+%H7Awz zhNUP(g-p{iG6uMZOu#viSCoM!VFy9rPG*Kc$k~>I!)e6?zm&+4kyUbqL87SSWMvL_ z>X|{vArvHAMEoN}r+*9~KIBb!qfmD3Kee7@FlBlLL}wcCkQq=d4zD*O>Z&uPY#TyN z=<$)IFRpwr@MqML_lU|NjRgV0rLl#(?JI&91a!;#?Hz}_FTYi+jbJO-~06< zH;lVr5e`S1wgZD6z#~T__pAam7?hpCV|%T`{t`v4b>?N)qoY0e&#$7 zn78EeJ68YqxzNqpty8#k`V6WiOo9uITtA%wB|;emX1t>N7+u9j4VZ?M>+**mB?<@bdSJgRh$+(vfqHPPaVE50x z{PqrZzAXZL4B}6L==kT@q5gAw`4+aOc66VyCV!7d>#gFEefj)xc7p~01o`>-pZ@-< zQ&n0Xn-QVwmU^9cf3{vOw|sTXDxIt`my8x_N8vO2ZGyz%dX;)DBli7ybrZbZZ+lS~ z#q%&D&F;$=N5>q7)117hO`P7=kUs7z#$WJ~g3!ynYNKZjOdnTJfNvE?VJ zze_;|qNht9jc%VictvJxgLUI^y#M$buomaFkBTnP4Zd9pgoG3Hg<4b1$_{^C5X(GJ zl69)eNFh%lN(h}4(kV|BYKY?8uz7p4W4iBA*j?mHmWc8YDVI&TNADuS0;|PB;CB9a zt`U!##ZCbeegWg!HTPzjN%_7MN_C!J%KCo5`L#J4?x(gFe}^fi*%{AH9PY+JXNW~H`~UG-5px08g#)1#aI{6)5*9Rw&bDbnekhi{O*cN11j>U^g@xfO1e zwb(_+Bdso+`J=`n_N3H++cF>rjzwKg6e%|d&8Lax2t6>7X`mkS_`l#^a^PNo1J)d4 zD(*w!3`;8M57w;(b+neWENQeMt{P^-c!*RrFQ~e<1J-!&vP-caw}X+^7u4LgT!p(S zqhwZMTq)qaVy&7@%0ye$e0$!s^)VeAOxXQ|YGiP{lJPpYyYr8#iSk4W8FGEw(sF7+ zA-F)ZY*RDNZtG4Z#8Ia?nN3T6)uX)m@%HK}3Sf36kE6BKlRU=df}ldnxA-^KfG;rU zIzk(1)Cny!hz(6CcHSI7BebvEr)IOYxG;>n(?X>#c7}`-&^m$7$2FFX_bv}R!6f_$ zZnJAB!{nQ`#Qt8|G|1X{llFJy+p$kxw_NX6C%_iyG1p{s99pozM zejS}{BJAv>=XC9KM{?2fZrv&;9}^#v8yj6v54o}nNTn*tHS3m*CV&I7=2+**I`|b$ zP+JMDYcgC{)OYrj-TBT2JSW{woY{aSj3F}O)vSGb_5ClocaHb#s3P3<~JbSKL=!QU}R-r zX7cragvk6GV*h^=@gEY={}C|9Z@>(If9jh4`$zpZ;J;-I{|oeghDx=U9)n4J8tfgA z0szSW8~P_KK%syB{{sEfY47jmR-ete#?~f||4cppy!*-jzq|iWQokoI|KlL6$@_YXBpJVcSPUjz)jD7~x{12G?-_*|k3jRMIZ`{8<8z9*KBlv$NpZ)j8 zq10~#-2Zn3KG){oQ_%h^KL30&e$PPrAV(=XZC{Khim8`wQs&(d+Zi5>X z?~jB$xc?eLfAIVJbCiBJj`<^{@1lPJrQdC2{v4&>Jskc>sY~iFp!ENDbog`he($IL zBfS~Jd`hMM2P@kDT~hur4gA)7 z_vaY>-i7l=M)KN!iqSvbdw%c9`E$^}tHk~YO=a=lfc|&Q*q=lFeJ|*bsBPYV3iThC z`j0z9{~GxJEu{YleDC+Cfd5%me**rkto{!rwSqM0XLjFbtoi3R0}KFwPtf1~`ad?3 BBP9R; diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/GoogleCheckout.php b/tools/extensions/org.civicrm.payment.googlecheckout/GoogleCheckout.php deleted file mode 100644 index 7c5ed1f6a4..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/GoogleCheckout.php +++ /dev/null @@ -1,343 +0,0 @@ -_mode = $mode; - $this->_paymentProcessor = $paymentProcessor; - $this->_processorName = ts('Google Checkout'); - } - - /** - * singleton function used to manage this object - * - * @param string $mode the mode of operation: live or test - * - * @param object $paymentProcessor - * @return object - */ - static - function &singleton($mode, &$paymentProcessor) { - $processorName = $paymentProcessor['name']; - if (self::$_singleton[$processorName] === NULL) { - self::$_singleton[$processorName] = new org_civicrm_payment_googlecheckout($mode, $paymentProcessor); - } - return self::$_singleton[$processorName]; - } - - /** - * This function checks to see if we have the right config values - * - * @return string the error message if any - */ - function checkConfig() { - $config = CRM_Core_Config::singleton(); - - $error = array(); - - if (empty($this->_paymentProcessor['user_name'])) { - $error[] = ts('User Name is not set in the Administer CiviCRM » Payment Processor.'); - } - - if (empty($this->_paymentProcessor['password'])) { - $error[] = ts('Password is not set in the Administer CiviCRM » Payment Processor.'); - } - - if (!empty($error)) { - return implode('

', $error); - } - else { - return NULL; - } - } - - /** - * This function collects all the information from a web/api form and invokes - * the relevant payment processor specific functions to perform the transaction - * - * @param array $params assoc array of input parameters for this transaction - * - * @return array the result in an nice formatted array (or an error object) - * @abstract - */ - function doDirectPayment(&$params) { - CRM_Core_Error::fatal(ts('This function is not implemented')); - } - - /** - * Sets appropriate parameters for checking out to google - * - * @param array $params name value pair of contribution datat - * - * @param $component - * @throws Exception - * @return void - */ - function doTransferCheckout(&$params, $component) { - $component = strtolower($component); - - $url = rtrim($this->_paymentProcessor['url_site'], '/') . '/cws/v2/Merchant/' . $this->_paymentProcessor['user_name'] . '/checkout'; - - //Create a new shopping cart object - // Merchant ID - $merchant_id = $this->_paymentProcessor['user_name']; - // Merchant Key - $merchant_key = $this->_paymentProcessor['password']; - $server_type = ($this->_mode == 'test') ? 'sandbox' : ''; - - $cart = new GoogleCart($merchant_id, $merchant_key, $server_type); - $item1 = new GoogleItem($params['item_name'], '', 1, $params['amount'], $params['currencyID']); - $cart->AddItem($item1); - - if ($component == "event") { - $privateData = "contactID={$params['contactID']},contributionID={$params['contributionID']},contributionTypeID={$params['contributionTypeID']},eventID={$params['eventID']},participantID={$params['participantID']},invoiceID={$params['invoiceID']}"; - } - elseif ($component == "contribute") { - $privateData = "contactID={$params['contactID']},contributionID={$params['contributionID']},contributionTypeID={$params['contributionTypeID']},invoiceID={$params['invoiceID']}"; - - $membershipID = CRM_Utils_Array::value('membershipID', $params); - if ($membershipID) { - $privateData .= ",membershipID=$membershipID"; - } - - $relatedContactID = CRM_Utils_Array::value('related_contact', $params); - if ($relatedContactID) { - $privateData .= ",relatedContactID=$relatedContactID"; - - $onBehalfDupeAlert = CRM_Utils_Array::value('onbehalf_dupe_alert', $params); - if ($onBehalfDupeAlert) { - $privateData .= ",onBehalfDupeAlert=$onBehalfDupeAlert"; - } - } - } - - // Allow further manipulation of the arguments via custom hooks .. - CRM_Utils_Hook::alterPaymentProcessorParams($this, $params, $privateData); - - $cart->SetMerchantPrivateData($privateData); - - if ($component == "event") { - $returnURL = CRM_Utils_System::url('civicrm/event/register', - "_qf_ThankYou_display=1&qfKey={$params['qfKey']}", - TRUE, NULL, FALSE - ); - } - elseif ($component == "contribute") { - $returnURL = CRM_Utils_System::url('civicrm/contribute/transact', - "_qf_ThankYou_display=1&qfKey={$params['qfKey']}", - TRUE, NULL, FALSE - ); - } - - $cart->SetContinueShoppingUrl($returnURL); - - $cartVal = base64_encode($cart->GetXML()); - $signatureVal = base64_encode($cart->CalcHmacSha1($cart->GetXML())); - - $googleParams = array('cart' => $cartVal, - 'signature' => $signatureVal, - ); - - require_once 'HTTP/Request.php'; - $params = array('method' => HTTP_REQUEST_METHOD_POST, - 'allowRedirects' => FALSE, - ); - $request = new HTTP_Request($url, $params); - foreach ($googleParams as $key => $value) { - $request->addPostData($key, $value); - } - - $result = $request->sendRequest(); - - if (PEAR::isError($result)) { - CRM_Core_Error::fatal($result->getMessage()); - } - - if ($request->getResponseCode() != 302) { - CRM_Core_Error::fatal(ts('Invalid response code received from Google Checkout: %1', - array(1 => $request->getResponseCode()) - )); - } - CRM_Utils_System::redirect($request->getResponseHeader('location')); - - exit(); - } - - /** - * hash_call: Function to perform the API call to PayPal using API signature - * @paymentProcessor is the array of payment processor settings value. - * @searchParamsnvpStr is the array of search params. - * returns an associtive array containing the response from the server. - * @param $paymentProcessor - * @param $searchParams - * @return array|object - * @throws \Exception - */ - function invokeAPI($paymentProcessor, $searchParams) { - $merchantID = $paymentProcessor['user_name']; - $merchantKey = $paymentProcessor['password']; - $siteURL = rtrim(str_replace('https://', '', $paymentProcessor['url_site']), '/'); - - $url = "https://{$merchantID}:{$merchantKey}@{$siteURL}/api/checkout/v2/reports/Merchant/{$merchantID}"; - $xml = self::buildXMLQuery($searchParams); - - if (!function_exists('curl_init')) { - CRM_Core_Error::fatal("curl functions NOT available."); - } - - $ch = curl_init(); - curl_setopt($ch, CURLOPT_URL, $url); - curl_setopt($ch, CURLOPT_VERBOSE, 1); - - //turning off the server and peer verification(TrustManager Concept). - curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE); - curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE); - - curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); - curl_setopt($ch, CURLOPT_POST, 1); - - //setting the nvpreq as POST FIELD to curl - curl_setopt($ch, CURLOPT_POSTFIELDS, $xml); - - //getting response from server - $xmlResponse = curl_exec($ch); - - // strip slashes if needed - if (get_magic_quotes_gpc()) { - $xmlResponse = stripslashes($xmlResponse); - } - - if (curl_errno($ch)) { - $e = &CRM_Core_Error::singleton(); - $e->push(curl_errno($ch), - 0, NULL, - curl_error($ch) - ); - return $e; - } - else { - curl_close($ch); - } - - return self::getArrayFromXML($xmlResponse); - } - - /** - * @param $searchParams - * - * @return string - */ - static - function buildXMLQuery($searchParams) { - $xml = ' -'; - - if (array_key_exists('next-page-token', $searchParams)) { - $xml .= ' -' . $searchParams['next-page-token'] . ''; - } - if (array_key_exists('start', $searchParams)) { - $xml .= ' -' . $searchParams['start'] . ' -' . $searchParams['end'] . ''; - } - if (array_key_exists('notification-types', $searchParams)) { - $xml .= ' - -' . implode($searchParams['notification-types'], ' -') . ' -'; - } - if (array_key_exists('order-numbers', $searchParams)) { - $xml .= ' - -' . implode($searchParams['order-numbers'], ' -') . ' -'; - } - $xml .= ' -'; - - return $xml; - } - - /** - * @param $xmlData - * - * @return array - */ - static - function getArrayFromXML($xmlData) { - require_once 'Google/library/xml-processing/xmlparser.php'; - $xmlParser = new XmlParser($xmlData); - $root = $xmlParser->GetRoot(); - $data = $xmlParser->GetData(); - - return array($root, $data); - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/GoogleIPN.php b/tools/extensions/org.civicrm.payment.googlecheckout/GoogleIPN.php deleted file mode 100644 index 1d15bc0a88..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/GoogleIPN.php +++ /dev/null @@ -1,573 +0,0 @@ -Integration as the - * "API Callback URL' - * Order processing commands can be sent automatically by placing these - * commands appropriately - * - * To use this code for merchant-calculated feedback, this url must be - * set also as the merchant-calculations-url when the cart is posted - * Depending on your calculations for shipping, taxes, coupons and gift - * certificates update parts of the code as required - * - */ - - - -require_once 'CRM/Core/Payment/BaseIPN.php'; - -define('GOOGLE_DEBUG_PP', 1); - -/** - * Class org_civicrm_payment_googlecheckout_GoogleIPN - */ -class org_civicrm_payment_googlecheckout_GoogleIPN extends CRM_Core_Payment_BaseIPN { - - /** - * We only need one instance of this object. So we use the singleton - * pattern and cache the instance in this variable - * - * @var object - */ - static private $_singleton = NULL; - - /** - * mode of operation: live or test - * - * @var object - */ - static protected $_mode = NULL; - - /** - * @param $name - * @param $type - * @param $object - * @param bool $abort - * - * @return mixed - */ - static function retrieve($name, $type, $object, $abort = TRUE) { - $value = CRM_Utils_Array::value($name, $object); - if ($abort && $value === NULL) { - CRM_Core_Error::debug_log_message("Could not find an entry for $name"); - echo "Failure: Missing Parameter

"; - exit(); - } - - if ($value) { - if (!CRM_Utils_Type::validate($value, $type)) { - CRM_Core_Error::debug_log_message("Could not find a valid entry for $name"); - echo "Failure: Invalid Parameter

"; - exit(); - } - } - - return $value; - } - - /** - * Constructor - * - * @param string $mode the mode of operation: live or test - * - * @param $paymentProcessor - * - * @return \org_civicrm_payment_googlecheckout_GoogleIPN - */ - function __construct($mode, &$paymentProcessor) { - parent::__construct(); - - $this->_mode = $mode; - $this->_paymentProcessor = $paymentProcessor; - } - - /** - * The function gets called when a new order takes place. - * - * @param xml $dataRoot response send by google in xml format - * @param array $privateData contains the name value pair of - * - * @param $component - * @return void - */ - function newOrderNotify($dataRoot, $privateData, $component) { - $ids = $input = $params = array(); - - $input['component'] = strtolower($component); - - $ids['contact'] = self::retrieve('contactID', 'Integer', $privateData, TRUE); - $ids['contribution'] = self::retrieve('contributionID', 'Integer', $privateData, TRUE); - - if ($input['component'] == "event") { - $ids['event'] = self::retrieve('eventID', 'Integer', $privateData, TRUE); - $ids['participant'] = self::retrieve('participantID', 'Integer', $privateData, TRUE); - $ids['membership'] = NULL; - } - else { - $ids['membership'] = self::retrieve('membershipID', 'Integer', $privateData, FALSE); - $ids['related_contact'] = self::retrieve('relatedContactID', 'Integer', $privateData, FALSE); - $ids['onbehalf_dupe_alert'] = self::retrieve('onBehalfDupeAlert', 'Integer', $privateData, FALSE); - } - $ids['contributionRecur'] = $ids['contributionPage'] = NULL; - - if (!$this->validateData($input, $ids, $objects)) { - return FALSE; - } - - // make sure the invoice is valid and matches what we have in the contribution record - $input['invoice'] = $privateData['invoiceID']; - $input['newInvoice'] = $dataRoot['google-order-number']['VALUE']; - $contribution = &$objects['contribution']; - if ($contribution->invoice_id != $input['invoice']) { - CRM_Core_Error::debug_log_message("Invoice values dont match between database and IPN request"); - echo "Failure: Invoice values dont match between database and IPN request

"; - return; - } - - // lets replace invoice-id with google-order-number because thats what is common and unique - // in subsequent calls or notifications sent by google. - $contribution->invoice_id = $input['newInvoice']; - - $input['amount'] = $dataRoot['order-total']['VALUE']; - - if ($contribution->total_amount != $input['amount']) { - CRM_Core_Error::debug_log_message("Amount values dont match between database and IPN request"); - echo "Failure: Amount values dont match between database and IPN request

"; - return; - } - - if (!$this->getInput($input, $ids)) { - return FALSE; - } - - require_once 'CRM/Core/Transaction.php'; - $transaction = new CRM_Core_Transaction(); - - // check if contribution is already completed, if so we ignore this ipn - if ($contribution->contribution_status_id == 1) { - CRM_Core_Error::debug_log_message("returning since contribution has already been handled"); - echo "Success: Contribution has already been handled

"; - } - else { - /* Since trxn_id hasn't got any use here, - * lets make use of it by passing the eventID/membershipTypeID to next level. - * And change trxn_id to google-order-number before finishing db update */ - - - if ($ids['event']) { - $contribution->trxn_id = $ids['event'] . CRM_Core_DAO::VALUE_SEPARATOR . $ids['participant']; - } - else { - $contribution->trxn_id = $ids['membership'] . CRM_Core_DAO::VALUE_SEPARATOR . $ids['related_contact'] . CRM_Core_DAO::VALUE_SEPARATOR . $ids['onbehalf_dupe_alert']; - } - } - - $contribution->save(); - $transaction->commit(); - return TRUE; - } - - /** - * The function gets called when the state(CHARGED, CANCELLED..) changes for an order - * - * @param string $status status of the transaction send by google - * @param $dataRoot - * @param $component - * @internal param array $privateData contains the name value pair of - * - * @return void - */ - function orderStateChange($status, $dataRoot, $component) { - $input = $objects = $ids = array(); - - $input['component'] = strtolower($component); - - $orderNo = $dataRoot['google-order-number']['VALUE']; - - require_once 'CRM/Contribute/DAO/Contribution.php'; - $contribution = new CRM_Contribute_DAO_Contribution(); - $contribution->invoice_id = $orderNo; - if (!$contribution->find(TRUE)) { - CRM_Core_Error::debug_log_message("Could not find contribution record with invoice id: $orderNo"); - echo "Failure: Could not find contribution record with invoice id: $orderNo

"; - exit(); - } - - // Google sends the charged notification twice. - // So to make sure, code is not executed again. - if ($contribution->contribution_status_id == 1) { - CRM_Core_Error::debug_log_message("Contribution already handled (ContributionID = $contribution)."); - exit(); - } - - $objects['contribution'] = &$contribution; - $ids['contribution'] = $contribution->id; - $ids['contact'] = $contribution->contact_id; - - $ids['event'] = $ids['participant'] = $ids['membership'] = NULL; - $ids['contributionRecur'] = $ids['contributionPage'] = NULL; - - if ($input['component'] == "event") { - list($ids['event'], $ids['participant']) = explode(CRM_Core_DAO::VALUE_SEPARATOR, - $contribution->trxn_id - ); - } - else { - list($ids['membership'], $ids['related_contact'], $ids['onbehalf_dupe_alert']) = explode(CRM_Core_DAO::VALUE_SEPARATOR, - $contribution->trxn_id - ); - - foreach (array('membership', 'related_contact', 'onbehalf_dupe_alert') as $fld) { - if (!is_numeric($ids[$fld])) { - unset($ids[$fld]); - } - } - } - - $this->loadObjects($input, $ids, $objects); - - require_once 'CRM/Core/Transaction.php'; - $transaction = new CRM_Core_Transaction(); - - if ($status == 'PAYMENT_DECLINED' || - $status == 'CANCELLED_BY_GOOGLE' || - $status == 'CANCELLED' - ) { - return $this->failed($objects, $transaction); - } - - $input['amount'] = $contribution->total_amount; - $input['fee_amount'] = NULL; - $input['net_amount'] = NULL; - $input['trxn_id'] = $orderNo; - $input['is_test'] = $contribution->is_test; - - $this->completeTransaction($input, $ids, $objects, $transaction); - } - - /** - * singleton function used to manage this object - * - * @param string $mode the mode of operation: live or test - * - * @param $component - * @param $paymentProcessor - * @return object - */ - static function &singleton($mode, $component, &$paymentProcessor) { - if (self::$_singleton === NULL) { - self::$_singleton = new org_civicrm_payment_googlecheckout_GoogleIPN($mode, $paymentProcessor); - } - return self::$_singleton; - } - - /** - * The function retrieves the amount the contribution is for, based on the order-no google sends - * - * @param int $orderNo send by google - * - * @return amount - */ - function getAmount($orderNo) { - require_once 'CRM/Contribute/DAO/Contribution.php'; - $contribution = new CRM_Contribute_DAO_Contribution(); - $contribution->invoice_id = $orderNo; - if (!$contribution->find(TRUE)) { - CRM_Core_Error::debug_log_message("Could not find contribution record with invoice id: $orderNo"); - echo "Failure: Could not find contribution record with invoice id: $orderNo

"; - exit(); - } - return $contribution->total_amount; - } - - /** - * The function returns the component(Event/Contribute..), given the google-order-no and merchant-private-data - * - * @param xml $xml_response response send by google in xml format - * @param array $privateData contains the name value pair of - * @param int $orderNo send by google - * @param string $root root of xml-response - * - * @return array context of this call (test, module, payment processor id) - */ - static function getContext($xml_response, $privateData, $orderNo, $root) { - $isTest = NULL; - $module = NULL; - if ($root == 'new-order-notification') { - $contributionID = $privateData['contributionID']; - $contribution = new CRM_Contribute_DAO_Contribution(); - $contribution->id = $contributionID; - if (!$contribution->find(TRUE)) { - CRM_Core_Error::debug_log_message("Could not find contribution record: $contributionID"); - echo "Failure: Could not find contribution record for $contributionID

"; - exit(); - } - if (stristr($contribution->source, ts('Online Contribution'))) { - $module = 'Contribute'; - } - elseif (stristr($contribution->source, ts('Online Event Registration'))) { - $module = 'Event'; - } - $isTest = $contribution->is_test; - } - else { - $contribution = new CRM_Contribute_DAO_Contribution(); - $contribution->invoice_id = $orderNo; - if (!$contribution->find(TRUE)) { - CRM_Core_Error::debug_log_message("Could not find contribution record with invoice id: $orderNo"); - echo "Failure: Could not find contribution record with invoice id: $orderNo

"; - exit(); - } - if (stristr($contribution->source, ts('Online Contribution'))) { - $module = 'Contribute'; - } - elseif (stristr($contribution->source, ts('Online Event Registration'))) { - $module = 'Event'; - } - $isTest = $contribution->is_test; - } - - if ($contribution->contribution_status_id == 1) { - //contribution already handled. - exit(); - } - - if ($module == 'Contribute') { - if (!$contribution->contribution_page_id) { - CRM_Core_Error::debug_log_message("Could not find contribution page for contribution record: $contributionID"); - echo "Failure: Could not find contribution page for contribution record: $contributionID

"; - exit(); - } - - // get the payment processor id from contribution page - $paymentProcessorID = CRM_Core_DAO::getFieldValue('CRM_Contribute_DAO_ContributionPage', - $contribution->contribution_page_id, - 'payment_processor_id' - ); - } - else { - if ($root == 'new-order-notification') { - $eventID = $privateData['eventID']; - } - else { - list($eventID, $participantID) = explode(CRM_Core_DAO::VALUE_SEPARATOR, - $contribution->trxn_id - ); - } - if (!$eventID) { - CRM_Core_Error::debug_log_message("Could not find event ID"); - echo "Failure: Could not find eventID

"; - exit(); - } - - // we are in event mode - // make sure event exists and is valid - require_once 'CRM/Event/DAO/Event.php'; - $event = new CRM_Event_DAO_Event(); - $event->id = $eventID; - if (!$event->find(TRUE)) { - CRM_Core_Error::debug_log_message("Could not find event: $eventID"); - echo "Failure: Could not find event: $eventID

"; - exit(); - } - - // get the payment processor id from contribution page - $paymentProcessorID = $event->payment_processor_id; - } - - if (!$paymentProcessorID) { - CRM_Core_Error::debug_log_message("Could not find payment processor for contribution record: $contributionID"); - echo "Failure: Could not find payment processor for contribution record: $contributionID

"; - exit(); - } - - return array($isTest, $module, $paymentProcessorID); - } - - /** - * This method is handles the response that will be invoked (from extern/googleNotify) every time - * a notification or request is sent by the Google Server. - * @param $xml_response - */ - static - function main($xml_response) { - require_once ('Google/library/googleresponse.php'); - require_once ('Google/library/googlemerchantcalculations.php'); - require_once ('Google/library/googleresult.php'); - require_once ('Google/library/xml-processing/xmlparser.php'); - - $config = CRM_Core_Config::singleton(); - - // Retrieve the XML sent in the HTTP POST request to the ResponseHandler - if (get_magic_quotes_gpc()) { - $xml_response = stripslashes($xml_response); - } - - require_once 'CRM/Utils/System.php'; - $headers = CRM_Utils_System::getAllHeaders(); - - if (GOOGLE_DEBUG_PP) { - CRM_Core_Error::debug_var('RESPONSE', $xml_response, TRUE, TRUE, 'Google'); - } - - // Retrieve the root and data from the xml response - $xmlParser = new XmlParser($xml_response); - $root = $xmlParser->GetRoot(); - $data = $xmlParser->GetData(); - - $orderNo = $data[$root]['google-order-number']['VALUE']; - - // lets retrieve the private-data - $privateData = $data[$root]['shopping-cart']['merchant-private-data']['VALUE']; - $privateData = $privateData ? self::stringToArray($privateData) : ''; - - list($mode, $module, $paymentProcessorID) = self::getContext($xml_response, $privateData, $orderNo, $root); - $mode = $mode ? 'test' : 'live'; - - require_once 'CRM/Financial/BAO/PaymentProcessor.php'; - $paymentProcessor = CRM_Financial_BAO_PaymentProcessor::getPayment($paymentProcessorID, - $mode - ); - - $ipn = &self::singleton($mode, $module, $paymentProcessor); - - // Create new response object - $merchant_id = $paymentProcessor['user_name']; - $merchant_key = $paymentProcessor['password']; - $server_type = ($mode == 'test') ? "sandbox" : ''; - - $response = new GoogleResponse($merchant_id, $merchant_key, - $xml_response, $server_type - ); - if (GOOGLE_DEBUG_PP) { - CRM_Core_Error::debug_var('RESPONSE-ROOT', $response->root, TRUE, TRUE, 'Google'); - } - - //Check status and take appropriate action - $status = $response->HttpAuthentication($headers); - - switch ($root) { - case "request-received": - case "error": - case "diagnosis": - case "checkout-redirect": - case "merchant-calculation-callback": - break; - - case "new-order-notification": { - $response->SendAck(); - $ipn->newOrderNotify($data[$root], $privateData, $module); - break; - } - case "order-state-change-notification": { - $response->SendAck(); - $new_financial_state = $data[$root]['new-financial-order-state']['VALUE']; - $new_fulfillment_order = $data[$root]['new-fulfillment-order-state']['VALUE']; - - switch ($new_financial_state) { - case 'CHARGEABLE': - $amount = $ipn->getAmount($orderNo); - if ($amount) { - $response->SendChargeOrder($data[$root]['google-order-number']['VALUE'], - $amount, $message_log - ); - $response->SendProcessOrder($data[$root]['google-order-number']['VALUE'], - $message_log - ); - } - break; - - case 'CHARGED': - case 'PAYMENT_DECLINED': - case 'CANCELLED': - $ipn->orderStateChange($new_financial_state, $data[$root], $module); - break; - - case 'REVIEWING': - case 'CHARGING': - case 'CANCELLED_BY_GOOGLE': - break; - - default: - break; - } - } - case "charge-amount-notification": - case "chargeback-amount-notification": - case "refund-amount-notification": - case "risk-information-notification": - $response->SendAck(); - break; - - default: - break; - } - } - - /** - * @param $input - * @param $ids - * - * @return bool - */ - function getInput(&$input, &$ids) { - if (!$this->getBillingID($ids)) { - return FALSE; - } - - $billingID = $ids['billing']; - $lookup = array("first_name" => 'contact-name', - // "last-name" not available with google (every thing in contact-name) - "last_name" => 'last_name', - "street_address-{$billingID}" => 'address1', - "city-{$billingID}" => 'city', - "state-{$billingID}" => 'region', - "postal_code-{$billingID}" => 'postal-code', - "country-{$billingID}" => 'country-code', - ); - - foreach ($lookup as $name => $googleName) { - $value = $dataRoot['buyer-billing-address'][$googleName]['VALUE']; - $input[$name] = $value ? $value : NULL; - } - return TRUE; - } - - /** - * Converts the comma separated name-value pairs in - * to an array of name-value pairs. - * @param $str - * @return array - */ - static - function stringToArray($str) { - $vars = $labels = array(); - $labels = explode(',', $str); - foreach ($labels as $label) { - $terms = explode('=', $label); - $vars[$terms[0]] = $terms[1]; - } - return $vars; - } - } - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/googleNotify.php b/tools/extensions/org.civicrm.payment.googlecheckout/googleNotify.php deleted file mode 100644 index 6348ad18ab..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/googleNotify.php +++ /dev/null @@ -1,49 +0,0 @@ - - - http://svn.civicrm.org/tools/branches/v3.3/extensions/org.civicrm.payment.googlecheckout.zip - GoogleCheckout - Google_Checkout - Google Checkout Payment Processor - - http://civicrm.org - http://wiki.civicrm.org/confluence/display/CRMDOC32/Google+Checkout+Configuration - http://forum.civicrm.org - http://civicrm.org/licensing - - AGPL - - CiviCRM LLC - info@civicrm.org - - 2010-09-01 - 1.1 - stable - 3.3 - For support, please contact project team on the forums. - - Merchant ID - Key - - - https://checkout.google.com/ - - - https://sandbox.google.com/checkout/ - - - - - notify - 0 - 1 - - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/README b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/README deleted file mode 100644 index 44571b06db..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/README +++ /dev/null @@ -1,115 +0,0 @@ -Sample PHP code for integration of Google Checkout with the merchant site --------------------------------------------------------------------------- - File structure and function - ---------------------------- - -There are two folders and a log file in the top level directory of -google-checkout-php-sample. - -1. "demo" directory: -This contains two files cartdemo.php and responsehandlerdemo.php - - a)cartdemo.php: - --------------- - This file demonstrates the steps required to add items, shipping, taxes and - merchant-calculations to the cart before it is posted to the Checkout server. - There are three use case functions defined with different settings for - shipping and taxes along with different button usages. - - b)responsehandler.php: - ---------------------- - This file will be used to handle the notifications, callbacks and order - processing steps. - The path for this file must be specified in the merchant's API callback - URL in Settings->Integration of the merchant's seller account. - This file can be used as is and modified by the merchant as per their - business workflow details. - Some of the initial steps performed in this file include collecting the - XML response, request that has been received and get a parsed result in a - PHP associative array for easy accesibility - (For details of parse output refer xmlparser.php which has an - example of how an XML maps to the object). - Order processing can be done using the SendProcessOrder(..) type of - methods provided in googleresponse.php. Some sample order processing - command invocations have been provided as comments in the code - - -2. "library" directory: -This contains the classes defined to describe the API structure so as to easily -define and add XML entries by defining objects of these classes. - - a) googlecart.php: - ------------------ - This is the main class which must be instantiated to post a cart. - It requires a merchant ID and key to be set and there is an option - to specify which server is to be used for the transactions - (Sandbox or Production). - It also has methods to add items, shipping options, tax options and - merchant-calculation details. - - b) googleitem.php: - ------------------ - This class is instantiated for every item to be added to the cart. - It requires the item name, description, price and quantity to be specified. - - c) googleshipping.php: - ---------------------- - This class is instantiated for every shipping option that is to be added to the cart. - It requires the shipping name type an price to be specified. - Other methods allow specification of the shipping restrictions. - - d) googletaxrule.php: - --------------------- - This class is used to define all tax rules for the tax tables. These may be - rules for default or alternate tax tables. Methods have been provided to add - states and zip patterns for the tax rules. - - e) googletaxtable.php: - ---------------------- - This class is used to aggregate all the defined tax rules to define a tax table. - This may be a default or alternate tax table identified by the "type" value. - - f) googleresponse.php: - ---------------------- - An instance of this class is created in the responsehandlerdemo.php. - This again requires the merchant id and merchant key to be specified. - There are methods provided to send all the different order processing - commands. - All notifications are parsed and the merchant can take required action - when a particular notification is received. - - g) googleresult.php: - -------------------- - This class is used for merchant-calculations and is invoked for - each result in the merchant-calculations-result sent from the - merchant in response to a callback. - - h) googlemerchantcalculations.php: - ---------------------------------- - In order to process merchant calculations, an instance of this - class is created. It is used to aggregate merchant results and - respond with the XML response for the callback. - - f) "xml-processing" directory: - ------------------------------ - - i) xmlbuilder.php: - ----------------- - This class generates XML and consists of "push" and "pop" - methods to add open and close tags respectively. - This is used internally by the library classes to generate - XML file for posting carts. - - ii)xmlparser.php: - ----------------- - This class parses XML documents using the SAX parser and is - compatible with PHP v4 and 5. It converts them to DOM form - returning the XML data in a PHP associative array. - This is used internally by the library classes to parse - XML requests and responses that are received from the - Checkout server. - -3. googlemessage.log: -The log file records all the notification and order processing commands that are -sent and received and can be useful information for debugging purposes. - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/cartdemo.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/cartdemo.php deleted file mode 100644 index f4340c9537..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/cartdemo.php +++ /dev/null @@ -1,178 +0,0 @@ -AddItem($item1); - $cart->AddItem($item2); - - //Add shipping options - $ship = new GoogleShipping("Ground", "flat-rate", 5); - $ship->SetAllowedCountryArea("CONTINENTAL_48"); - $cart->AddShipping($ship); - - $ship = new GoogleShipping("2nd Day", "flat-rate", 10); - $ship->SetAllowedCountryArea("FULL_50_STATES"); - $cart->AddShipping($ship); - - //Add tax options - $tax_rule = new GoogleTaxRule("default", 0.08); - $tax_rule->SetStateAreas("CA"); - $tax_table = new GoogleTaxTable("default"); - $tax_table->AddTaxRules($tax_rule); - $cart->AddTaxTables($tax_table); - - //Display Google Checkout button - echo $cart->CheckoutButtonCode("large"); -} - -function UseCase2() { - //Create a new shopping cart object - // Your Merchant ID - $merchant_id = ""; - // Your Merchant Key - $merchant_key = ""; - $server_type = "sandbox"; - $cart = new GoogleCart($merchant_id, $merchant_key, $server_type); - - //Add items to the cart - $item1 = new GoogleItem("Dry Food Pack AA1453", - " pack of highly nutritious dried food for emergency", 1, 35 - ); - $item2 = new GoogleItem("MegaSound 2GB MP3 Player", - "Portable MP3 player - stores 500 songs", 1, 178 - ); - $item3 = new GoogleItem("AA Rechargeable Battery Pack", - "Battery pack containing four AA rechargeable batteries", 1, 12 - ); - $cart->AddItem($item1); - $cart->AddItem($item2); - $cart->AddItem($item3); - - //Add shipping options - $ship = new GoogleShipping("flat", "flat-rate", 5); - $ship->SetAllowedStateAreas(array("NY", "CA")); - $cart->AddShipping($ship); - - $ship = new GoogleShipping("pickup", "pickup", 10); - $cart->AddShipping($ship); - - //Add tax options - $tax_rule = new GoogleTaxRule("default", 0.02, "FULL_50_STATES"); - $tax_rule->SetStateAreas(array("CA", "NY")); - $tax_table = new GoogleTaxTable("default"); - $tax_table->AddTaxRules($tax_rule); - $cart->AddTaxTables($tax_table); - - $tax_rule = new GoogleTaxRule("alternate", 0.05); - $tax_rule->SetZipPatterns(array("54305", "10027")); - $tax_rule->SetStateAreas("CA"); - $tax_table = new GoogleTaxTable("alternate", "test"); - $tax_table->AddTaxRules($tax_rule); - - $tax_rule = new GoogleTaxRule("alternate", 0.1); - $tax_rule->SetStateAreas(array("CO", "FL")); - $tax_table->AddTaxRules($tax_rule); - - $cart->AddTaxTables($tax_table); - - //Display XML data - echo htmlentities($cart->GetXML()); - - //Display a medium button with a transparent background - echo $cart->CheckoutButtonCode("medium", "trans"); -} - -function UseCase3() { - //Create a new shopping cart object - // Your Merchant ID - $merchant_id = ""; - // Your Merchant Key - $merchant_key = ""; - $server_type = "sandbox"; - $cart = new GoogleCart($merchant_id, $merchant_key, $server_type); - - //Add items to the cart - $item1 = new GoogleItem("Dry Food Pack AA1453", - " pack of highly nutritious dried food for emergency", 1, 35 - ); - $item2 = new GoogleItem("MegaSound 2GB MP3 Player", - "Portable MP3 player - stores 500 songs", 1, 178 - ); - $item3 = new GoogleItem("AA Rechargeable Battery Pack", - "Battery pack containing four AA rechargeable batteries", 1, 12 - ); - $cart->AddItem($item1); - $cart->AddItem($item2); - $cart->AddItem($item3); - - //Set request buyer phone - $cart->SetRequestBuyerPhone("true"); - - //Add merchant calculations options - $cart->SetMerchantCalculations( - "https://www.example.com/shopping/merchantCalc", "true", "true", "true" - ); - $ship = new GoogleShipping("merchant-calc", - "merchant-calculated", 5, "USD", "ALL" - ); - $ship->SetAllowedStateAreas(array("NY", "CA")); - $cart->AddShipping($ship); - - $tax_rule = new GoogleTaxRule("default", 0.2); - $tax_rule->SetStateAreas(array("CA", "NY")); - - $tax_table = new GoogleTaxTable("default"); - $tax_table->AddTaxRules($tax_rule); - $cart->AddTaxTables($tax_table); - - //Display XML data - echo htmlentities($cart->GetXML()); - - //Display a disabled, small button with a white background - echo $cart->CheckoutButtonCode("small", "white", "disabled"); -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/responsehandlerdemo.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/responsehandlerdemo.php deleted file mode 100644 index 847c4a4770..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/demo/responsehandlerdemo.php +++ /dev/null @@ -1,300 +0,0 @@ -Integration as the - * "API Callback URL' - * Order processing commands can be sent automatically by placing these - * commands appropriately - * - * To use this code for merchant-calculated feedback, this url must be - * set also as the merchant-calculations-url when the cart is posted - * Depending on your calculations for shipping, taxes, coupons and gift - * certificates update parts of the code as required - * - */ - - - -chdir(".."); -require_once ('library/googleresponse.php'); -require_once ('library/googlemerchantcalculations.php'); -require_once ('library/googleresult.php'); - -define('RESPONSE_HANDLER_LOG_FILE', 'googlemessage.log'); - -//Setup the log file -if (!$message_log = fopen(RESPONSE_HANDLER_LOG_FILE, "a")) { - error_func("Cannot open " . RESPONSE_HANDLER_LOG_FILE . " file.\n", 0); - exit(1); -} - -// Retrieve the XML sent in the HTTP POST request to the ResponseHandler -$xml_response = $HTTP_RAW_POST_DATA; -if (get_magic_quotes_gpc()) { - $xml_response = stripslashes($xml_response); -} -$headers = getallheaders(); -fwrite($message_log, sprintf("\n\r%s:- %s\n", date("D M j G:i:s T Y"), - $xml_response - )); - -// Create new response object -// Your Merchant ID -$merchant_id = ""; -// Your Merchant Key -$merchant_key = ""; -$server_type = "sandbox"; - -$response = new GoogleResponse($merchant_id, $merchant_key, - $xml_response, $server_type -); -$root = $response->root; -$data = $response->data; -fwrite($message_log, sprintf("\n\r%s:- %s\n", date("D M j G:i:s T Y"), - $response->root - )); - -//Use the following two lines to log the associative array storing the XML data -//$result = print_r($data,true); -//fwrite($message_log, sprintf("\n\r%s:- %s\n",date("D M j G:i:s T Y"),$result)); - -//Check status and take appropriate action -$status = $response->HttpAuthentication($headers); - -/* Commands to send the various order processing APIs - * Send charge order : $response->SendChargeOrder($data[$root] - * ['google-order-number']['VALUE'], , $message_log); - * Send process order : $response->SendProcessOrder($data[$root] - * ['google-order-number']['VALUE'], $message_log); - * Send deliver order: $response->SendDeliverOrder($data[$root] - * ['google-order-number']['VALUE'], , , - * , $message_log); - * Send archive order: $response->SendArchiveOrder($data[$root] - * ['google-order-number']['VALUE'], $message_log); - * - */ - - - -switch ($root) { - case "request-received": { - break; - } - case "error": { - break; - } - case "diagnosis": { - break; - } - case "checkout-redirect": { - break; - } - case "merchant-calculation-callback": { - // Create the results and send it - $merchant_calc = new GoogleMerchantCalculations(); - - // Loop through the list of address ids from the callback - $addresses = get_arr_result($data[$root]['calculate']['addresses']['anonymous-address']); - foreach ($addresses as $curr_address) { - $curr_id = $curr_address['id']; - $country = $curr_address['country-code']['VALUE']; - $city = $curr_address['city']['VALUE']; - $region = $curr_address['region']['VALUE']; - $postal_code = $curr_address['region']['VALUE']; - - // Loop through each shipping method if merchant-calculated shipping - // support is to be provided - if (isset($data[$root]['calculate']['shipping'])) { - $shipping = get_arr_result($data[$root]['calculate']['shipping']['method']); - foreach ($shipping as $curr_ship) { - $name = $curr_ship['name']; - //Compute the price for this shipping method and address id - // Modify this to get the actual price - $price = 10; - // Modify this as required - $shippable = "true"; - $merchant_result = new GoogleResult($curr_id); - $merchant_result->SetShippingDetails($name, $price, "USD", - $shippable - ); - - if ($data[$root]['calculate']['tax']['VALUE'] == "true") { - //Compute tax for this address id and shipping type - // Modify this to the actual tax value - $amount = 15; - $merchant_result->SetTaxDetails($amount, "USD"); - } - - $codes = get_arr_result($data[$root]['calculate']['merchant-code-strings'] - ['merchant-code-string'] - ); - foreach ($codes as $curr_code) { - //Update this data as required to set whether the coupon is valid, the code and the amount - $coupons = new GoogleCoupons("true", $curr_code['code'], 5, "USD", "test2"); - $merchant_result->AddCoupons($coupons); - } - $merchant_calc->AddResult($merchant_result); - } - } - else { - $merchant_result = new GoogleResult($curr_id); - if ($data[$root]['calculate']['tax']['VALUE'] == "true") { - //Compute tax for this address id and shipping type - // Modify this to the actual tax value - $amount = 15; - $merchant_result->SetTaxDetails($amount, "USD"); - } - $codes = get_arr_result($data[$root]['calculate']['merchant-code-strings'] - ['merchant-code-string'] - ); - foreach ($codes as $curr_code) { - //Update this data as required to set whether the coupon is valid, the code and the amount - $coupons = new GoogleCoupons("true", $curr_code['code'], 5, "USD", "test2"); - $merchant_result->AddCoupons($coupons); - } - $merchant_calc->AddResult($merchant_result); - } - } - fwrite($message_log, sprintf("\n\r%s:- %s\n", date("D M j G:i:s T Y"), - $merchant_calc->GetXML() - )); - $response->ProcessMerchantCalculations($merchant_calc); - break; - } - case "new-order-notification": { - $response->SendAck(); - break; - } - case "order-state-change-notification": { - $response->SendAck(); - $new_financial_state = $data[$root]['new-financial-order-state']['VALUE']; - $new_fulfillment_order = $data[$root]['new-fulfillment-order-state']['VALUE']; - - switch ($new_financial_state) { - case 'REVIEWING': { - break; - } - case 'CHARGEABLE': { - //$response->SendProcessOrder($data[$root]['google-order-number']['VALUE'], - // $message_log); - //$response->SendChargeOrder($data[$root]['google-order-number']['VALUE'], - // '', $message_log); - break; - } - case 'CHARGING': { - break; - } - case 'CHARGED': { - break; - } - case 'PAYMENT_DECLINED': { - break; - } - case 'CANCELLED': { - break; - } - case 'CANCELLED_BY_GOOGLE': { - //$response->SendBuyerMessage($data[$root]['google-order-number']['VALUE'], - // "Sorry, your order is cancelled by Google", true, $message_log); - break; - } - default: - break; - } - - switch ($new_fulfillment_order) { - case 'NEW': { - break; - } - case 'PROCESSING': { - break; - } - case 'DELIVERED': { - break; - } - case 'WILL_NOT_DELIVER': { - break; - } - default: - break; - } - } - case "charge-amount-notification": { - $response->SendAck(); - //$response->SendDeliverOrder($data[$root]['google-order-number']['VALUE'], - // , , , $message_log); - //$response->SendArchiveOrder($data[$root]['google-order-number']['VALUE'], - // $message_log); - break; - } - case "chargeback-amount-notification": { - $response->SendAck(); - break; - } - case "refund-amount-notification": { - $response->SendAck(); - break; - } - case "risk-information-notification": { - $response->SendAck(); - break; - } - default: { - break; - } - } - /* In case the XML API contains multiple open tags - with the same value, then invoke this function and - perform a foreach on the resultant array. - This takes care of cases when there is only one unique tag - or multiple tags. - Examples of this are "anonymous-address", "merchant-code-string" - from the merchant-calculations-callback API - */ -/** - * @param $child_node - * - * @return array - */function get_arr_result($child_node) { - $result = array(); - if (isset($child_node)) { - if (is_associative_array($child_node)) { - $result[] = $child_node; - } - else { - foreach ($child_node as $curr_node) { - $result[] = $curr_node; - } - } - } - return $result; - } - - /* Returns true if a given variable represents an associative array */ -/** - * @param $var - * - * @return bool - */function is_associative_array($var) { - return is_array($var) && !is_numeric(implode('', array_keys($var))); - } - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlecart.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlecart.php deleted file mode 100644 index b403111e34..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlecart.php +++ /dev/null @@ -1,510 +0,0 @@ -merchant_id = $id; - $this->merchant_key = $key; - - if (strtolower($server_type) == "sandbox") { - - $this->server_url = "https://sandbox.google.com/checkout/"; - } - else $this->server_url = "https://checkout.google.com/"; - - $this->schema_url = "http://checkout.google.com/schema/2"; - $this->base_url = $this->server_url . "cws/v2/Merchant/" . $this->merchant_id; - $this->checkout_url = $this->base_url . "/checkout"; - $this->checkout_diagnose_url = $this->base_url . "/checkout/diagnose"; - $this->request_url = $this->base_url . "/request"; - $this->request_diagnose_url = $this->base_url . "/request/diagnose"; - - //The item, shipping and tax table arrays are initialized - $this->item_arr = array(); - $this->shipping_arr = array(); - $this->alternate_tax_table_arr = array(); - } - - /** - * @param $cart_expire - */ - function SetCartExpiration($cart_expire) { - $this->cart_expiration = $cart_expire; - } - - /** - * @param $data - */ - function SetMerchantPrivateData($data) { - $this->merchant_private_data = $data; - } - - /** - * @param $url - */ - function SetEditCartUrl($url) { - $this->edit_cart_url = $url; - } - - /** - * @param $url - */ - function SetContinueShoppingUrl($url) { - $this->continue_shopping_url = $url; - } - - /** - * @param $req - */ - function SetRequestBuyerPhone($req) { - $this->_SetBooleanValue('request_buyer_phone', $req, ""); - } - - /** - * @param $url - * @param string $tax_option - * @param string $coupons - * @param string $gift_cert - */ - function SetMerchantCalculations($url, $tax_option = "false", - $coupons = "false", - $gift_cert = "false" - ) { - $this->merchant_calculations_url = $url; - $this->_SetBooleanValue('merchant_calculated', $tax_option, "false"); - $this->_SetBooleanValue('accept_merchant_coupons', $coupons, "false"); - $this->_SetBooleanValue('accept_gift_certificates', $gift_cert, "false"); - } - - /** - * @param $google_item - */ - function AddItem($google_item) { - $this->item_arr[] = $google_item; - } - - /** - * @param $ship - */ - function AddShipping($ship) { - $this->shipping_arr[] = $ship; - } - - /** - * @param $tax - */ - function AddTaxTables($tax) { - if ($tax->type == "default") { - $this->default_tax_table = $tax; - } - elseif ($tax->type == "alternate") { - $this->alternate_tax_table_arr[] = $tax; - } - } - - /** - * @return string - */ - function GetXML() { - require_once ('xml-processing/xmlbuilder.php'); - - $xml_data = new XmlBuilder(); - - $xml_data->Push('checkout-shopping-cart', - array('xmlns' => $this->schema_url) - ); - $xml_data->Push('shopping-cart'); - - //Add cart expiration if set - if ($this->cart_expiration != "") { - $xml_data->Push('cart-expiration'); - $xml_data->Element('good-until-date', $this->cart_expiration); - $xml_data->Pop('cart-expiration'); - } - - //Add XML data for each of the items - $xml_data->Push('items'); - foreach ($this->item_arr as $item) { - $xml_data->Push('item'); - $xml_data->Element('item-name', $item->item_name); - $xml_data->Element('item-description', $item->item_description); - $xml_data->Element('unit-price', $item->unit_price, - array('currency' => $item->currency) - ); - $xml_data->Element('quantity', $item->quantity); - if ($item->merchant_private_data != '') $xml_data->Element('merchant-private-date', - $item->merchant_private_data - ); - if ($item->tax_table_selector != '') { - $xml_data->Element('tax-table-selector', $item->tax_table_selector); - } - $xml_data->Pop('item'); - } - $xml_data->Pop('items'); - - if ($this->merchant_private_data != '') $xml_data->Element('merchant-private-data', - $this->merchant_private_data - ); - - $xml_data->Pop('shopping-cart'); - - $xml_data->Push('checkout-flow-support'); - $xml_data->Push('merchant-checkout-flow-support'); - if ($this->edit_cart_url != '') { - $xml_data->Element('edit-cart-url', $this->edit_cart_url); - } - if ($this->continue_shopping_url != '') $xml_data->Element('continue-shopping-url', - $this->continue_shopping_url - ); - - if (count($this->shipping_arr) > 0) { - - $xml_data->Push('shipping-methods'); - } - - //Add the shipping methods - foreach ($this->shipping_arr as $ship) { - //Pickup shipping handled in else part - if ($ship->type == "flat-rate" || - $ship->type == "merchant-calculated" - ) { - $xml_data->Push($ship->type . '-shipping', - array('name' => $ship->name) - ); - $xml_data->Element('price', $ship->price, - array('currency' => $ship->currency) - ); - - //Check if shipping restrictions have been specifd=ied - if ($ship->allowed_restrictions || - $ship->excluded_restrictions - ) { - $xml_data->Push('shipping-restrictions'); - - //Check if allowed restrictions specified - if ($ship->allowed_restrictions) { - $xml_data->Push('allowed-areas'); - if ($ship->allowed_country_area != "") $xml_data->Element('us-country-area', '', - array('country-area' => - $ship->allowed_country_area, - ) - ); - foreach ($ship->allowed_state_areas_arr as $current) { - $xml_data->Push('us-state-area'); - $xml_data->Element('state', $current); - $xml_data->Pop('us-state-area'); - } - foreach ($ship->allowed_zip_patterns_arr as $current) { - $xml_data->Push('us-zip-area'); - $xml_data->Element('zip-pattern', $current); - $xml_data->Pop('us-zip-area'); - } - $xml_data->Pop('allowed-areas'); - } - - if ($ship->excluded_restrictions) { - $xml_data->Push('allowed-areas'); - $xml_data->Pop('allowed-areas'); - $xml_data->Push('excluded-areas'); - if ($ship->excluded_country_area != "") $xml_data->Element('us-country-area', '', - array('country-area' => - $ship->excluded_country_area, - ) - ); - foreach ($ship->excluded_state_areas_arr as $current) { - $xml_data->Push('us-state-area'); - $xml_data->Element('state', $current); - $xml_data->Pop('us-state-area'); - } - foreach ($ship->excluded_zip_patterns_arr as $current) { - $xml_data->Push('us-zip-area'); - $xml_data->Element('zip-pattern', $current); - $xml_data->Pop('us-zip-area'); - } - $xml_data->Pop('excluded-areas'); - } - $xml_data->Pop('shipping-restrictions'); - } - $xml_data->Pop($ship->type . '-shipping'); - } - elseif ($ship->type == "pickup") { - $xml_data->Push('pickup', array('name' => $ship->name)); - $xml_data->Element('price', $ship->price, - array('currency' => $ship->currency) - ); - $xml_data->Pop('pickup'); - } - } - if (count($this->shipping_arr) > 0) { - $xml_data->Pop('shipping-methods'); - } - - if ($this->request_buyer_phone != "") $xml_data->Element('request-buyer-phone-number', - $this->request_buyer_phone - ); - - if ($this->merchant_calculations_url != "") { - $xml_data->Push('merchant-calculations'); - $xml_data->Element('merchant-calculations-url', - $this->merchant_calculations_url - ); - if ($this->accept_merchant_coupons != "") $xml_data->Element('accept-merchant-coupons', - $this->accept_merchant_coupons - ); - if ($this->accept_gift_certificates != "") $xml_data->Element('accept-gift-certificates', - $this->accept_gift_certificates - ); - $xml_data->Pop('merchant-calculations'); - } - - //Set Default and Alternate tax tables - if ((count($this->alternate_tax_table_arr) != 0) || (isset($this->default_tax_table))) { - if ($this->merchant_calculated != "") { - $xml_data->Push('tax-tables', array('merchant-calculated' => $this->merchant_calculated)); - } - else $xml_data->Push('tax-tables'); - - if (isset($this->default_tax_table)) { - $curr_table = $this->default_tax_table; - foreach ($curr_table->tax_rules_arr as $curr_rule) { - - - $xml_data->Push('default-tax-table'); - $xml_data->Push('tax-rules'); - foreach ($curr_rule->state_areas_arr as $current) { - $xml_data->Push('default-tax-rule'); - - $xml_data->Element('shipping-taxed', $curr_rule->shipping_taxed); - $xml_data->Element('rate', $curr_rule->tax_rate); - $xml_data->Push('tax-area'); - if ($curr_rule->country_area != "") { - $xml_data->Element('us-country-area', '', array('country-area' => $curr_rule->country_area)); - } - $xml_data->Push('us-state-area'); - $xml_data->Element('state', $current); - $xml_data->Pop('us-state-area'); - - $xml_data->Pop('tax-area'); - $xml_data->Pop('default-tax-rule'); - } - foreach ($curr_rule->zip_patterns_arr as $current) { - $xml_data->Push('default-tax-rule'); - - $xml_data->Element('shipping-taxed', $curr_rule->shipping_taxed); - $xml_data->Element('rate', $curr_rule->tax_rate); - $xml_data->Push('tax-area'); - - if ($curr_rule->country_area != "") { - - $xml_data->Element('us-country-area', '', array('country-area' => $curr_rule->country_area)); - } - $xml_data->Push('us-zip-area'); - $xml_data->Element('zip-pattern', $current); - $xml_data->Pop('us-zip-area'); - $xml_data->Pop('tax-area'); - $xml_data->Pop('default-tax-rule'); - } - $xml_data->Pop('tax-rules'); - $xml_data->Pop('default-tax-table'); - } - } - - if (count($this->alternate_tax_table_arr) != 0) { - $xml_data->Push('alternate-tax-tables'); - foreach ($this->alternate_tax_table_arr as $curr_table) { - foreach ($curr_table->tax_rules_arr as $curr_rule) { - $xml_data->Push('alternate-tax-table', array('standalone' => $curr_table->standalone, 'name' => $curr_table->name)); - $xml_data->Push('alternate-tax-rules'); - foreach ($curr_rule->state_areas_arr as $current) { - $xml_data->Push('alternate-tax-rule'); - - $xml_data->Element('shipping-taxed', $curr_rule->shipping_taxed); - $xml_data->Element('rate', $curr_rule->tax_rate); - $xml_data->Push('tax-area'); - if ($curr_rule->country_area != "") { - $xml_data->Element('us-country-area', '', array('country-area' => $curr_rule->country_area)); - } - $xml_data->Push('us-state-area'); - $xml_data->Element('state', $current); - $xml_data->Pop('us-state-area'); - - $xml_data->Pop('tax-area'); - $xml_data->Pop('alternate-tax-rule'); - } - foreach ($curr_rule->zip_patterns_arr as $current) { - $xml_data->Push('alternate-tax-rule'); - - $xml_data->Element('shipping-taxed', $curr_rule->shipping_taxed); - $xml_data->Element('rate', $curr_rule->tax_rate); - $xml_data->Push('tax-area'); - - if ($curr_rule->country_area != "") { - - $xml_data->Element('us-country-area', '', array('country-area' => $curr_rule->country_area)); - } - $xml_data->Push('us-zip-area'); - $xml_data->Element('zip-pattern', $current); - $xml_data->Pop('us-zip-area'); - $xml_data->Pop('tax-area'); - $xml_data->Pop('alternate-tax-rule'); - } - $xml_data->Pop('alternate-tax-rules'); - $xml_data->Pop('alternate-tax-table'); - } - } - $xml_data->Pop('alternate-tax-tables'); - } - $xml_data->Pop('tax-tables'); - } - $xml_data->Pop('merchant-checkout-flow-support'); - $xml_data->Pop('checkout-flow-support'); - $xml_data->Pop('checkout-shopping-cart'); - - return $xml_data->GetXML(); - } - - //Code for generating Checkout button - /** - * @param string $size - * @param string $style - * @param string $variant - * @param string $loc - * - * @return string - */ - function CheckoutButtonCode($size = "large", $style = "white", - $variant = "text", $loc = "en_US" - ) { - - switch ($size) { - case "large": - $width = "180"; - $height = "46"; - break; - - case "medium": - $width = "168"; - $height = "44"; - break; - - case "small": - $width = "160"; - $height = "43"; - break; - - default: - break; - } - - if ($variant == "text") { - $data = "

checkout_url . "\"> - GetXML()) . "\"> - CalcHmacSha1($this->GetXML())) . "\"> - server_url . "buttons/checkout.gif?merchant_id=" . $this->merchant_id . "&w=" . $width . "&h=" . $height . "&style=" . $style . "&variant=" . $variant . "&loc=" . $loc . "\" - height=\"" . $height . "\" width=\"" . $width . "\" /> -

"; - } - elseif ($variant == "disabled") { - $data = "

\"Checkout\"server_url . "buttons/checkout.gif?merchant_id=" . $this->merchant_id . "&w=" . $width . "&h=" . $height . "&style=" . $style . "&variant=" . $variant . "&loc=" . $loc . "\" - height=\"" . $height . "\" width=\"" . $width . "\" />

"; - } - return $data; - } - - //Method which returns the encrypted google cart to make sure that the carts are not tampered with - /** - * @param $data - * - * @return string - */ - function CalcHmacSha1($data) { - $key = $this->merchant_key; - $blocksize = 64; - $hashfunc = 'sha1'; - if (strlen($key) > $blocksize) { - $key = pack('H*', $hashfunc($key)); - } - $key = str_pad($key, $blocksize, chr(0x00)); - $ipad = str_repeat(chr(0x36), $blocksize); - $opad = str_repeat(chr(0x5c), $blocksize); - $hmac = pack( - 'H*', $hashfunc( - ($key ^ $opad) . pack( - 'H*', $hashfunc( - ($key ^ $ipad) . $data - ) - ) - ) - ); - return $hmac; - } - - //Method used internally to set true/false cart variables - /** - * @param $string - * @param $value - * @param $default - */ - function _SetBooleanValue($string, $value, $default) { - $value = strtolower($value); - if ($value == "true" || $value == "false")eval('$this->' . $string . '="' . $value . '";'); - else eval('$this->' . $string . '="' . $default . '";'); - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleitem.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleitem.php deleted file mode 100644 index 4fc38dd5f2..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleitem.php +++ /dev/null @@ -1,71 +0,0 @@ -item_name = $name; - $this->item_description = $desc; - $this->unit_price = $price; - $this->quantity = $qty; - $this->currency = $money; - $this->merchant_private_data = $private_data; - $this->tax_table_selector = $tax_selector; - } - - /** - * @param $private_data - */ - function SetMerchantPrivateData($private_data) { - $this->merchant_private_data = $private_data; - } - - /** - * @param $tax_selector - */ - function SetTaxTableSelector($tax_selector) { - $this->tax_table_selector = $tax_selector; - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlemerchantcalculations.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlemerchantcalculations.php deleted file mode 100644 index ab79b6fbf9..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googlemerchantcalculations.php +++ /dev/null @@ -1,103 +0,0 @@ -results_arr = array(); - } - - /** - * @param $results - */ - function AddResult($results) { - $this->results_arr[] = $results; - } - - /** - * @return string - */ - function GetXML() { - require_once ('xml-processing/xmlbuilder.php'); - - $xml_data = new XmlBuilder(); - $xml_data->Push('merchant-calculation-results', - array('xmlns' => $this->schema_url) - ); - $xml_data->Push('results'); - - foreach ($this->results_arr as $result) { - if ($result->shipping_name != "") { - $xml_data->Push('result', array('shipping-name' => - $result->shipping_name, 'address-id' => $result->address_id, - )); - $xml_data->Element('shipping-rate', $result->ship_price, - array('currency' => $result->ship_currency) - ); - $xml_data->Element('shippable', $result->shippable); - } - else $xml_data->Push('result', array('address-id' => $result->address_id)); - - if ($result->tax_amount != "") $xml_data->Element('total-tax', $result->tax_amount, - array('currency' => $result->tax_currency) - ); - - if ((count($result->coupon_arr) != 0) || - (count($result->giftcert_arr) != 0) - ) { - $xml_data->Push('merchant-code-results'); - - foreach ($result->coupon_arr as $curr_coupon) { - $xml_data->Push('coupon-result'); - $xml_data->Element('valid', $curr_coupon->coupon_valid); - $xml_data->Element('code', $curr_coupon->coupon_code); - $xml_data->Element('calculated-amount', $curr_coupon->coupon_amount, - array('currency' => $curr_coupon->coupon_currency) - ); - $xml_data->Element('message', $curr_coupon->coupon_message); - $xml_data->Pop('coupon-result'); - } - foreach ($result->giftcert_arr as $curr_gift) { - $xml_data->Push('gift-result'); - $xml_data->Element('valid', $curr_gift->gift_valid); - $xml_data->Element('code', $curr_gift->gift_code); - $xml_data->Element('calculated-amount', $curr_gift->gift_amount, - array('currency' => $curr_gift->gift_currency) - ); - $xml_data->Element('message', $curr_gift->gift_message); - $xml_data->Pop('gift-result'); - } - $xml_data->Pop('merchant-code-results'); - } - $xml_data->Pop('result'); - } - $xml_data->Pop('results'); - $xml_data->Pop('merchant-calculation-results'); - return $xml_data->GetXML(); - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresponse.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresponse.php deleted file mode 100644 index 52ca97b171..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresponse.php +++ /dev/null @@ -1,349 +0,0 @@ -merchant_id = $id; - $this->merchant_key = $key; - - if ($server_type == "sandbox") { - - $this->server_url = "https://sandbox.google.com/checkout/"; - } - else $this->server_url = "https://checkout.google.com/"; - - $this->schema_url = "http://checkout.google.com/schema/2"; - $this->base_url = $this->server_url . "cws/v2/Merchant/" . $this->merchant_id; - $this->checkout_url = $this->base_url . "/checkout"; - $this->checkout_diagnose_url = $this->base_url . "/checkout/diagnose"; - $this->request_url = $this->base_url . "/request"; - $this->request_diagnose_url = $this->base_url . "/request/diagnose"; - - $this->response = $response; - - if (strpos(__FILE__, ':') !== FALSE) { - - $path_delimiter = ';'; - } - else $path_delimiter = ':'; - - ini_set('include_path', ini_get('include_path') . $path_delimiter . '.'); - require_once ('xml-processing/xmlparser.php'); - $this->xml_parser = new XmlParser($response); - $this->root = $this->xml_parser->GetRoot(); - $this->data = $this->xml_parser->GetData(); - } - - /** - * @param $headers - * - * @return bool - */ - function HttpAuthentication($headers) { - if (isset($headers['Authorization'])) { - $auth_encode = $headers['Authorization']; - $auth = base64_decode(substr($auth_encode, - strpos($auth_encode, " ") + 1 - )); - $compare_mer_id = substr($auth, 0, strpos($auth, ":")); - $compare_mer_key = substr($auth, strpos($auth, ":") + 1); - } - else { - return FALSE; - } - if ($compare_mer_id != $this->merchant_id || - $compare_mer_key != $this->merchant_key - ) return FALSE; - return TRUE; - } - - /** - * @param $google_order - * @param string $amount - * @param $message_log - */ - function SendChargeOrder($google_order, $amount = '', $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\">"; - if ($amount != '') { - $postargs .= "" . $amount . ""; - } - $postargs .= ""; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $amount - * @param $reason - * @param $comment - * @param $message_log - */ - function SendRefundOrder($google_order, $amount, $reason, $comment, $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"> - " . $reason . " - " . htmlentities($amount) . " - " . htmlentities($comment) . " - "; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $reason - * @param $comment - * @param $message_log - */ - function SendCancelOrder($google_order, $reason, $comment, $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"> - " . htmlentities($reason) . " - " . htmlentities($comment) . " - "; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $carrier - * @param $tracking_no - * @param $message_log - */ - function SendTrackingData($google_order, $carrier, $tracking_no, $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"> - - " . htmlentities($carrier) . " - " . $tracking_no . " - - "; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $merchant_order - * @param $message_log - */ - function SendMerchantOrderNumber($google_order, $merchant_order, $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"> - " . $merchant_order . " - "; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $message - * @param string $send_mail - * @param $message_log - */ - function SendBuyerMessage($google_order, $message, $send_mail = "true", $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"> - " . $message . " - " . $send_mail . " - "; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $message_log - */ - function SendProcessOrder($google_order, $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"/> "; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $carrier - * @param $tracking_no - * @param string $send_mail - * @param $message_log - */ - function SendDeliverOrder($google_order, $carrier, $tracking_no, $send_mail = "true", $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"> - - " . htmlentities($carrier) . " - " . $tracking_no . " - - " . $send_mail . " - "; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $message_log - */ - function SendArchiveOrder($google_order, $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"/>"; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $google_order - * @param $message_log - */ - function SendUnarchiveOrder($google_order, $message_log) { - $postargs = " - schema_url . "\" google-order-number=\"" . $google_order . "\"/>"; - return $this->SendReq($this->request_url, $this->GetAuthenticationHeaders(), - $postargs, $message_log - ); - } - - /** - * @param $merchant_calc - */ - function ProcessMerchantCalculations($merchant_calc) { - $result = $merchant_calc->GetXML(); - echo $result; - } - - /** - * @return array - */ - function GetAuthenticationHeaders() { - $headers = array(); - $headers[] = "Authorization: Basic " . base64_encode( - $this->merchant_id . ':' . $this->merchant_key - ); - $headers[] = "Content-Type: application/xml"; - $headers[] = "Accept: application/xml"; - return $headers; - } - - /** - * @param $url - * @param $header_arr - * @param $postargs - * @param $message_log - */ - function SendReq($url, $header_arr, $postargs, $message_log) { - // Get the curl session object - $session = curl_init($url); - - // Set the POST options. - curl_setopt($session, CURLOPT_POST, TRUE); - curl_setopt($session, CURLOPT_HTTPHEADER, $header_arr); - curl_setopt($session, CURLOPT_POSTFIELDS, $postargs); - curl_setopt($session, CURLOPT_HEADER, TRUE); - curl_setopt($session, CURLOPT_RETURNTRANSFER, TRUE); - - // Do the POST and then close the session - $response = curl_exec($session); - if (curl_errno($session)) { - die(curl_error($session)); - } - else { - curl_close($session); - } - - // Get HTTP Status code from the response - $status_code = array(); - preg_match('/\d\d\d/', $response, $status_code); - - // Check for errors - switch ($status_code[0]) { - case 200: - // Success - break; - - case 503: - die('Error 503: Service unavailable.'); - break; - - case 403: - die('Error 403: Forbidden.'); - break; - - case 400: - die('Error 400: Bad request.'); - break; - - default: - echo $response; - die('Error :' . $status_code[0]); - } - fwrite($message_log, sprintf("\n\r%s:- %s\n", date("D M j G:i:s T Y"), - $response - )); - } - - function SendAck() { - $acknowledgment = "" . "schema_url . "\"/>"; - echo $acknowledgment; - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresult.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresult.php deleted file mode 100644 index a903753edb..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleresult.php +++ /dev/null @@ -1,144 +0,0 @@ -address_id = $address_id; - } - - /** - * @param $name - * @param $price - * @param string $money - * @param string $shippable - */ - function SetShippingDetails($name, $price, $money = "USD", - $shippable = "true" - ) { - $this->shipping_name = $name; - $this->ship_price = $price; - $this->ship_currency = $money; - $this->shippable = $shippable; - } - - /** - * @param $amount - * @param string $currency - */ - function SetTaxDetails($amount, $currency = "USD") { - $this->tax_amount = $amount; - $this->tax_currency = $currency; - } - - /** - * @param $coupon - */ - function AddCoupons($coupon) { - $this->coupon_arr[] = $coupon; - } - - /** - * @param $gift - */ - function AddGiftCertificates($gift) { - $this->giftcert_arr[] = $gift; - } -} - -/* This is a class used to return the results of coupons - * that the buyer entered code for on the place order page - */ - -/** - * Class GoogleCoupons - */ -class GoogleCoupons { - var $coupon_valid; - var $coupon_code; - var $coupon_currency; - var $coupon_amount; - var $coupon_message; - - /** - * @param $valid - * @param $code - * @param $amount - * @param $currency - * @param $message - */ - function googlecoupons($valid, $code, $amount, $currency, $message) { - $this->coupon_valid = $valid; - $this->coupon_code = $code; - $this->coupon_currency = $currency; - $this->coupon_amount = $amount; - $this->coupon_message = $message; - } -} - -/* This is a class used to return the results of gift certificates - * that the buyer entered code for on the place order page - */ - -/** - * Class GoogleGiftcerts - */ -class GoogleGiftcerts { - var $gift_valid; - var $gift_code; - var $gift_currency; - var $gift_amount; - var $gift_message; - - /** - * @param $valid - * @param $code - * @param $amount - * @param $currency - * @param $message - */ - function googlegiftcerts($valid, $code, $amount, $currency, $message) { - $this->gift_valid = $valid; - $this->gift_code = $code; - $this->gift_currency = $currency; - $this->gift_amount = $amount; - $this->gift_message = $message; - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleshipping.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleshipping.php deleted file mode 100644 index 6dc7fde91c..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googleshipping.php +++ /dev/null @@ -1,144 +0,0 @@ -price = $price; - $this->name = $name; - $this->type = strtolower($type); - $this->currency = $money; - - if ($allowed_country_area != "") { - - $this->SetAllowedCountryArea($allowed_country_area); - } - - if ($excluded_country_area != "") { - - $this->SetExcludedCountryArea($excluded_country_area); - } - - $this->allowed_state_areas_arr = array(); - $this->allowed_zip_patterns_arr = array(); - $this->excluded_state_areas_arr = array(); - $this->excluded_zip_patterns_arr = array(); - } - - /** - * @param $areas - */ - function SetAllowedStateAreas($areas) { - $this->allowed_restrictions = TRUE; - $this->allowed_state_areas_arr = $areas; - } - - /** - * @param $zips - */ - function SetAllowedZipPattens($zips) { - $this->allowed_restrictions = TRUE; - $this->allowed_zip_patterns_arr = $zips; - } - - /** - * @param $areas - */ - function SetExcludedStateAreas($areas) { - $this->excluded_restrictions = TRUE; - $this->excluded_state_areas_arr = $areas; - } - - /** - * @param $zips - */ - function SetExcludedZipPatternsStateAreas($zips) { - $this->excluded_restrictions = TRUE; - $this->excluded_zip_patterns_arr = $zips; - } - - /** - * @param $country_area - */ - function SetAllowedCountryArea($country_area) { - if ($country_area == "CONTINENTAL_48" || - $country_area == "FULL_50_STATES" || - $country_area = "ALL" - ) { - $this->allowed_country_area = $country_area; - $this->allowed_restrictions = TRUE; - } - else $this->allowed_country_area = ""; - } - - /** - * @param $country_area - */ - function SetExcludedCountryArea($country_area) { - if ($country_area == "CONTINENTAL_48" || - $country_area == "FULL_50_STATES" || - $country_area = "ALL" - ) { - $this->excluded_country_area = $country_area; - $this->excluded_restrictions = TRUE; - } - else $this->excluded_country_area = ""; - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxrule.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxrule.php deleted file mode 100644 index f4461ca3af..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxrule.php +++ /dev/null @@ -1,97 +0,0 @@ -rax_rule_type = strtolower($type); - $this->shipping_taxed = $shipping_taxed; - $this->tax_rate = $tax_rate; - - if ($country_area != "") { - - $this->SetCountryArea($country_area); - } - - $this->state_areas_arr = array(); - $this->zip_patterns_arr = array(); - } - - /** - * @param $areas - */ - function SetStateAreas($areas) { - if (is_array($areas)) { - $this->state_areas_arr = $areas; - } - else $this->state_areas_arr = array($areas); - } - - /** - * @param $zips - */ - function SetZipPatterns($zips) { - if (is_array($zips)) { - $this->zip_patterns_arr = $zips; - } - else $this->zip_patterns_arr = array($zips); - } - - /** - * @param $country_area - */ - function SetCountryArea($country_area) { - if ($country_area == "CONTINENTAL_48" || $country_area == "FULL_50_STATES" - || $country_area = "ALL" - ) $this->country_area = $country_area; - else $this->country_area = ""; - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxtable.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxtable.php deleted file mode 100644 index c8eb987f3a..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/googletaxtable.php +++ /dev/null @@ -1,56 +0,0 @@ -name = $name; - $this->type = strtolower($type); - $this->tax_rules_arr = array(); - $this->standalone = $standalone; - } - } - - /** - * @param $rules - */ - function AddTaxRules($rules) { - $this->tax_rules_arr[] = $rules; - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlbuilder.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlbuilder.php deleted file mode 100644 index a2c0c3e621..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlbuilder.php +++ /dev/null @@ -1,116 +0,0 @@ -indent = $indent; - $this->xml = '' . "\n"; - } - - function _indent() { - for ($i = 0, $j = count($this->stack); $i < $j; $i++) { - $this->xml .= $this->indent; - } - } - - //Used when an element has sub-elements - // This function adds an open tag to the output - /** - * @param $element - * @param array $attributes - */ - function Push($element, $attributes = array()) { - $this->_indent(); - $this->xml .= '<' . $element; - foreach ($attributes as $key => $value) { - $this->xml .= ' ' . $key . '="' . htmlentities($value) . '"'; - } - $this->xml .= ">\n"; - $this->stack[] = $element; - } - - //Used when an element has no subelements. - //Data within the open and close tags are provided with the - //contents variable - /** - * @param $element - * @param $content - * @param array $attributes - */ - function Element($element, $content, $attributes = array()) { - $this->_indent(); - $this->xml .= '<' . $element; - foreach ($attributes as $key => $value) { - $this->xml .= ' ' . $key . '="' . htmlentities($value) . '"'; - } - $this->xml .= '>' . htmlentities($content) . '' . "\n"; - } - - /** - * @param $element - * @param array $attributes - */ - function EmptyElement($element, $attributes = array()) { - $this->_indent(); - $this->xml .= '<' . $element; - foreach ($attributes as $key => $value) { - $this->xml .= ' ' . $key . '="' . htmlentities($value) . '"'; - } - $this->xml .= " />\n"; - } - - //Used to close an open tag - /** - * @param $pop_element - */ - function Pop($pop_element) { - $element = array_pop($this->stack); - $this->_indent(); - if ($element !== $pop_element)die('XML Error: Tag Mismatch when trying to close "' . $pop_element . '"'); - else $this->xml .= "\n"; - } - - /** - * @return string - */ - function GetXML() { - if (count($this->stack) != 0)die('XML Error: No matching closing tag found for " ' . array_pop($this->stack) { . '"' - ); - } - else return $this->xml; - } -} - diff --git a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlparser.php b/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlparser.php deleted file mode 100644 index d924033a39..0000000000 --- a/tools/extensions/org.civicrm.payment.googlecheckout/packages/Google/library/xml-processing/xmlparser.php +++ /dev/null @@ -1,193 +0,0 @@ - - * data 1 - * - * data 2 - * - * - * - * print_r($this->params) will return - Array -( - [addresses] => Array - ( - [anonymous-address] => Array - ( - [0] => Array - ( - [id] => 123 - [test] => Array - ( - [VALUE] => data 1 - ) - - ) - - [1] => Array - ( - [id] => 456 - [test] => Array - ( - [VALUE] => data 2 - ) - - ) - - ) - - ) - -) - * XmlParser returns an empty params array if it encounters - * any error during parsing - */ - -/** - * Class XmlParser - */ -class XmlParser { - - // Stores the object representation of XML data - var $params = array(); - var $root; - var $global_index = -1; - - /* Constructor for the class - * Takes in XML data as input( do not include the tag - */ - /** - * @param $input - */ - function XmlParser($input) { - $xmlp = xml_parser_create(); - xml_parse_into_struct($xmlp, $input, $vals, $index); - xml_parser_free($xmlp); - $this->root = strtolower($vals[0]['tag']); - $this->params = $this->UpdateRecursive($vals); - } - - /* Returns true if a given variable represents an associative array */ - /** - * @param $var - * - * @return bool - */ - function is_associative_array($var) { - return is_array($var) && !is_numeric(implode('', array_keys($var))); - } - - /* Converts the output of SAX parser into a PHP associative array similar to the - * DOM parser output - */ - /** - * @param $vals - * - * @return array - */ - function UpdateRecursive($vals) { - $this->global_index++; - //Reached end of array - if ($this->global_index >= count($vals)) { - return; - } - - $tag = strtolower($vals[$this->global_index]['tag']); - $value = trim($vals[$this->global_index]['value']); - $type = $vals[$this->global_index]['type']; - - //Add attributes - if (isset($vals[$this->global_index]['attributes'])) { - foreach ($vals[$this->global_index]['attributes'] as $key => $val) { - $key = strtolower($key); - $params[$tag][$key] = $val; - } - } - - if ($type == 'open') { - $new_arr = array(); - - //Read all elements at the next levels and add to an array - while ($vals[$this->global_index]['type'] != 'close' && - $this->global_index < count($vals) - ) { - $arr = $this->UpdateRecursive($vals); - if (count($arr) > 0) { - $new_arr[] = $arr; - } - } - $this->global_index++; - foreach ($new_arr as $arr) { - foreach ($arr as $key => $val) { - if (isset($params[$tag][$key])) { - //If this key already exists - if ($this->is_associative_array($params[$tag][$key])) { - //If this is an associative array and not an indexed array - // remove exisiting value and convert to an indexed array - $val_key = $params[$tag][$key]; - array_splice($params[$tag][$key], 0); - $params[$tag][$key][0] = $val_key; - $params[$tag][$key][] = $val; - } - else { - $params[$tag][$key][] = $val; - } - } - else { - $params[$tag][$key] = $val; - } - } - } - } - elseif ($type == 'complete') { - if ($value != '') { - $params[$tag]['VALUE'] = $value; - } - } - else $params = array(); - return $params; - } - - /* Returns the root of the XML data */ - /** - * @return string - */ - function GetRoot() { - return $this->root; - } - - /* Returns the array representing the XML data */ - /** - * @return array - */ - function GetData() { - return $this->params; - } -} - diff --git a/tools/extensions/org.civicrm.report.baykeeper/Baykeeper.php b/tools/extensions/org.civicrm.report.baykeeper/Baykeeper.php deleted file mode 100755 index 88c12ccf78..0000000000 --- a/tools/extensions/org.civicrm.report.baykeeper/Baykeeper.php +++ /dev/null @@ -1,680 +0,0 @@ -_columns = array('civicrm_contact' => - array('dao' => 'CRM_Contact_DAO_Contact', - 'fields' => - array('display_name' => - array('title' => ts('Contact Name'), - 'required' => TRUE, - 'no_repeat' => TRUE, - ), - 'id' => - array('no_display' => FALSE, - 'title' => ts('Contact ID'), - 'required' => TRUE, - ), - 'contact_id' => - array('title' => ts('Contact ID'), - 'name' => 'id', - 'default' => FALSE, - 'no_repeat' => TRUE, - 'required' => TRUE, - ), - 'addressee_display' => array('title' => ts('Addressee Name')), - 'postal_greeting_display' => array('title' => ts('Greeting')), - 'display_name_creditor' => - array('title' => ts('Soft Credit Name'), - 'name' => 'display_name', - 'alias' => 'soft_credit', - 'no_repeat' => TRUE, - ), - 'id_creditor' => - array('title' => ts('Soft Credit Id'), - 'name' => 'id', - 'alias' => 'soft_credit', - ), - 'employer_name' => - array('title' => ts('Employer Name'), - 'name' => 'display_name', - 'alias' => 'employer_company', - ), - 'employer_id' => - array('title' => ts('Employer Id'), - 'name' => 'employer_id', - ), - 'do_not_mail' => array('title' => ts('Do Not Mail')), - ), - 'filters' => - array('sort_name' => - array('title' => ts('Contact Name'), - 'operator' => 'like', - ), - 'id' => - array('title' => ts('Contact ID'), - 'no_display' => TRUE, - ), - ), - 'grouping' => 'contact-fields', - ), - 'civicrm_email' => - array('dao' => 'CRM_Core_DAO_Email', - 'fields' => - array('email' => - array('title' => ts('Email'), - 'default' => TRUE, - 'no_repeat' => TRUE, - ), - ), - 'grouping' => 'contact-fields', - ), - 'civicrm_phone' => - array('dao' => 'CRM_Core_DAO_Phone', - 'fields' => - array('phone' => - array('title' => ts('Phone'), - 'default' => TRUE, - 'no_repeat' => TRUE, - ), - ), - 'grouping' => 'contact-fields', - ), - 'civicrm_address' => - array('dao' => 'CRM_Core_DAO_Address', - 'fields' => - array('street_address' => NULL, - 'supplemental_address_1' => array('title' => ts('Sup Address 1'), - ), - 'supplemental_address_2' => array('title' => ts('Sup Address 2'), - ), - 'city' => NULL, - 'postal_code' => NULL, - 'location_type_id' => array('title' => ts('Location Type ID'), - ), - 'state_province_id' => - array('title' => ts('State/Province'), - ), - 'country_id' => - array('title' => ts('Country'), - 'default' => TRUE, - ), - ), - 'grouping' => 'contact-fields', - 'filters' => - array('country_id' => - array('title' => ts('Country'), - 'type' => CRM_Utils_Type::T_INT, - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Core_PseudoConstant::country(), - ), - 'state_province_id' => - array('title' => ts('State/Province'), - 'type' => CRM_Utils_Type::T_INT, - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Core_PseudoConstant::stateProvince(), - ), - ), - ), - 'civicrm_contribution' => - array('dao' => 'CRM_Contribute_DAO_Contribution', - 'fields' => - array( - 'contribution_id' => array( - 'name' => 'id', - 'no_display' => TRUE, - 'required' => TRUE, - ), - 'contribution_type_id' => array('title' => ts('Contribution Type'), - 'default' => TRUE, - ), - 'trxn_id' => NULL, - 'receive_date' => array('default' => TRUE), - 'receipt_date' => NULL, - 'source' => array('title' => ts('Source')), - 'fee_amount' => NULL, - 'net_amount' => NULL, - 'non_deductible_amount' => array('title' => ts('Non Deductible Amount')), - 'total_amount' => array('title' => ts('Total Amount'), - 'required' => TRUE, - ), - 'honor_contact_id' => array('title' => ts('Honor Contact ID'), - ), - 'honor_type_id' => array('title' => ts('Hon/Mem Type')), - ), - 'filters' => - array('receive_date' => - array('operatorType' => CRM_Report_Form::OP_DATE), - 'contribution_type_id' => - array('title' => ts('Contribution Type'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Contribute_PseudoConstant::contributionType(), - ), - 'contribution_status_id' => - array('title' => ts('Contribution Status'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Contribute_PseudoConstant::contributionStatus(), - ), - 'total_amount' => - array('title' => ts('Contribution Amount')), - ), - 'grouping' => 'contri-fields', - ), - 'civicrm_contact_hon_mem' => - array('dao' => 'CRM_Contact_DAO_Contact', - 'alias' => 'hon_mem', - 'fields' => - array('id' => array('title' => ts('Hon/Mem Contact ID'), - 'required' => TRUE, - 'no_display' => TRUE, - ), - 'display_name' => array('title' => ts('In Honor Of'), - 'required' => FALSE, - ), - ), - 'grouping' => 'contri-fields', - ), - 'civicrm_note' => - array('dao' => 'CRM_Core_DAO_Note', - 'fields' => - array( - 'note' => - array('title' => ts('Note'), - 'default' => TRUE, - 'no_repeat' => FALSE, - ), - ), - 'grouping' => 'contri-fields', - ), - 'civicrm_contribution_soft' => - array('dao' => 'CRM_Contribute_DAO_ContributionSoft', - 'fields' => - array('contribution_id' => - array('title' => ts('Contribution ID'), - 'no_display' => TRUE, - 'default' => TRUE, - ), - 'contact_id' => - array('title' => ts('Contact ID'), - 'no_display' => TRUE, - 'default' => TRUE, - ), - 'id' => - array('default' => TRUE, - 'no_display' => TRUE, - ), - ), - 'grouping' => 'softcredit-fields', - ), - 'civicrm_group_field' => - array('dao' => 'CRM_Contact_DAO_Group', - 'fields' => - array('title' => - array('title' => ts('Groups')), - ), - ), - 'civicrm_group' => - array('dao' => 'CRM_Contact_DAO_GroupContact', - 'alias' => 'cgroup', - 'fields' => - array( - ), - 'filters' => - array('gid' => - array('name' => 'group_id', - 'title' => ts('Group'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'group' => TRUE, - 'options' => CRM_Core_PseudoConstant::group(), - ), - ), - ), - 'civicrm_contribution_ordinality' => - array('dao' => 'CRM_Contribute_DAO_Contribution', - 'alias' => 'cordinality', - 'filters' => - array('ordinality' => - array('title' => ts('Contribution Ordinality'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => array(0 => 'First by Contributor', - 1 => 'Second or Later by Contributor', - ), - ), - ), - ), - ); - - $this->_options = array('first_contribution' => array('title' => ts('First Contribution'), - 'type' => 'checkbox', - ), - 'last_contribution' => array('title' => ts('Last Contribution'), - 'type' => 'checkbox', - ), - 'include_nondonors' => array('title' => ts('Include non-donors?'), - 'type' => 'checkbox', - ), - ); - - $this->_tagFilter = TRUE; - parent::__construct(); - } - - function preProcess() { - parent::preProcess(); - } - - function select() { - $select = array(); - - $this->_columnHeaders = array(); - foreach ($this->_columns as $tableName => $table) { - if (array_key_exists('fields', $table)) { - foreach ($table['fields'] as $fieldName => $field) { - if (!empty($field['required']) || !empty($this->_params['fields'][$fieldName])) { - if ($tableName == 'civicrm_address') { - $this->_addressField = TRUE; - } - elseif ($tableName == 'civicrm_email') { - $this->_emailField = TRUE; - } - /* - if ( $tableName == 'civicrm_group_field' && $fieldName == 'title' ) { - $select[] = "GROUP_CONCAT(DISTINCT {$field['dbAlias']} ORDER BY {$field['dbAlias']} ) as {$tableName}_{$fieldName}"; - } else { - $select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}"; - } - */ - - - // only include statistics columns if set - if (!empty($field['statistics'])) { - foreach ($field['statistics'] as $stat => $label) { - switch (strtolower($stat)) { - case 'sum': - $select[] = "SUM({$field['dbAlias']}) as {$tableName}_{$fieldName}_{$stat}"; - $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label; - $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['type'] = $field['type']; - $this->_statFields[] = "{$tableName}_{$fieldName}_{$stat}"; - break; - - case 'count': - $select[] = "COUNT({$field['dbAlias']}) as {$tableName}_{$fieldName}_{$stat}"; - $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label; - $this->_statFields[] = "{$tableName}_{$fieldName}_{$stat}"; - break; - - case 'avg': - $select[] = "ROUND(AVG({$field['dbAlias']}),2) as {$tableName}_{$fieldName}_{$stat}"; - $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['type'] = $field['type']; - $this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label; - $this->_statFields[] = "{$tableName}_{$fieldName}_{$stat}"; - break; - } - } - } - elseif ($tableName == 'civicrm_group_field' && $fieldName == 'title') { - $select[] = " GROUP_CONCAT(DISTINCT {$field['dbAlias']} ORDER BY {$field['dbAlias']} SEPARATOR ' |
') as {$tableName}_{$fieldName} "; - $this->_columnHeaders["{$tableName}_{$fieldName}"]['title'] = $field['title']; - $this->_columnHeaders["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array::value('type', $field); - } - else { - $select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}"; - $this->_columnHeaders["{$tableName}_{$fieldName}"]['title'] = $field['title']; - $this->_columnHeaders["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array::value('type', $field); - } - } - } - } - } - - // insert first and last contribution at end - if (!empty($this->_params['options']['first_contribution'])) { - $select[] = " '' as first_contribution"; - $this->_columnHeaders['first_contribution']['title'] = ts('First Contribution'); - } - - if (!empty($this->_params['options']['last_contribution'])) { - $select[] = " '' as last_contribution"; - $this->_columnHeaders['last_contribution']['title'] = ts('Last Contribution'); - } - - - $this->_select = "SELECT " . implode(', ', $select) . " "; - } - - function from() { - $alias_constituent = 'constituentname'; - $alias_creditor = 'soft_credit'; - $alias_employer = "employer_company"; - - $this->_from = NULL; - - $hackValue = CRM_Utils_Array::value('include_nondonors', $this->_params['options'], 0); - $contribJoin = $hackValue ? "LEFT" : "INNER"; - - $this->_from = " - FROM civicrm_contact {$this->_aliases['civicrm_contact']} {$this->_aclFrom} - $contribJoin JOIN civicrm_contribution {$this->_aliases['civicrm_contribution']} - ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_contribution']}.contact_id AND {$this->_aliases['civicrm_contribution']}.is_test = 0 - $contribJoin JOIN (SELECT c.id, IF(COUNT(oc.id) = 0, 0, 1) AS ordinality FROM civicrm_contribution c LEFT JOIN civicrm_contribution oc ON c.contact_id = oc.contact_id AND oc.receive_date < c.receive_date GROUP BY c.id) {$this->_aliases['civicrm_contribution_ordinality']} - ON {$this->_aliases['civicrm_contribution_ordinality']}.id = {$this->_aliases['civicrm_contribution']}.id - LEFT JOIN civicrm_note {$this->_aliases['civicrm_note']} - ON ({$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_note']}.contact_id AND - {$this->_aliases['civicrm_contribution']}.id = {$this->_aliases['civicrm_note']}.entity_id ) - LEFT JOIN civicrm_phone {$this->_aliases['civicrm_phone']} - ON ({$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_phone']}.contact_id AND - {$this->_aliases['civicrm_phone']}.is_primary = 1) - LEFT JOIN civicrm_contact {$alias_employer} - ON {$this->_aliases['civicrm_contact']}.employer_id = - {$alias_employer}.id - LEFT JOIN civicrm_contribution_soft {$this->_aliases['civicrm_contribution_soft']} - ON {$this->_aliases['civicrm_contribution_soft']}.contribution_id = - {$this->_aliases['civicrm_contribution']}.id - LEFT JOIN civicrm_contact {$alias_creditor} - ON {$this->_aliases['civicrm_contribution_soft']}.contact_id = - {$alias_creditor}.id - LEFT JOIN civicrm_contact {$this->_aliases['civicrm_contact_hon_mem']} - ON {$this->_aliases['civicrm_contribution']}.honor_contact_id = {$this->_aliases['civicrm_contact_hon_mem']}.id - "; - // add group - concatenated - $this->_from .= " LEFT JOIN civicrm_group_contact gc ON {$this->_aliases['civicrm_contact']}.id = gc.contact_id AND gc.status = 'Added' - LEFT JOIN civicrm_group {$this->_aliases['civicrm_group_field']} ON {$this->_aliases['civicrm_group_field']}.id = gc.group_id "; - - if ($this->_addressField OR (!empty($this->_params['state_province_id_value']) OR !empty($this->_params['country_id_value']))) { - $this->_from .= " - LEFT JOIN civicrm_address {$this->_aliases['civicrm_address']} - ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_address']}.contact_id AND - {$this->_aliases['civicrm_address']}.is_primary = 1\n"; - } - - if ($this->_emailField) { - $this->_from .= " - LEFT JOIN civicrm_email {$this->_aliases['civicrm_email']} - ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_email']}.contact_id AND - {$this->_aliases['civicrm_email']}.is_primary = 1\n"; - } - } - - function groupBy() { - $this->_groupBy = " GROUP BY {$this->_aliases['civicrm_contact']}.id, {$this->_aliases['civicrm_contribution']}.id "; - } - - function orderBy() { - $this->_orderBy = " ORDER BY {$this->_aliases['civicrm_contact']}.id, {$this->_aliases['civicrm_contribution']}.receive_date "; - } - - /** - * @param $rows - * - * @return array - */ - function statistics(&$rows) { - $statistics = parent::statistics($rows); - // because the query returns groups, the amount is multiplied by the number of groups a contact is in - // that's why this is disabled - /* SUM( {$this->_aliases['civicrm_contribution']}.total_amount ) as amount, */ - - - $select = " - SELECT COUNT({$this->_aliases['civicrm_contribution']}.total_amount ) as count, - ROUND(AVG({$this->_aliases['civicrm_contribution']}.total_amount), 2) as avg - "; - $sql = "{$select} {$this->_from} {$this->_where}"; - $dao = CRM_Core_DAO::executeQuery($sql); - - if ($dao->fetch()) { - // because the query returns groups, the amount is multiplied by the number of groups a contact is in - // that's why this is disabled - /* SUM( {$this->_aliases['civicrm_contribution']}.total_amount ) as amount, */ - - - /* - $statistics['counts']['amount'] = array( 'value' => $dao->amount, - 'title' => 'Total Amount', - 'type' => CRM_Utils_Type::T_MONEY ); - $statistics['counts']['avg'] = array( 'value' => $dao->avg, - 'title' => 'Average', - 'type' => CRM_Utils_Type::T_MONEY ); - */ - } - - return $statistics; - } - - function postProcess() { - // get the acl clauses built before we assemble the query - $this->buildACLClause($this->_aliases['civicrm_contact']); - parent::postProcess(); - } - - /** - * @param $rows - */ - function alterDisplay(&$rows) { - - require_once 'CRM/Contribute/BAO/Contribution/Utils.php'; - require_once 'CRM/Utils/Money.php'; - require_once 'CRM/Utils/Date.php'; - - $config = &CRM_Core_Config::singleton(); - - // custom code to alter rows - $checkList = array(); - $entryFound = FALSE; - $display_flag = $prev_cid = $cid = 0; - $contributionTypes = CRM_Contribute_PseudoConstant::contributionType(); - - foreach ($rows as $rowNum => $row) { - if (!empty($this->_noRepeats) && - $this->_outputMode != 'csv' - ) { - // don't repeat contact details if its same as the previous row - if (array_key_exists('civicrm_contact_id', $row)) { - if ($cid = $row['civicrm_contact_id']) { - if ($rowNum == 0) { - $prev_cid = $cid; - } - else { - if ($prev_cid == $cid) { - $display_flag = 1; - $prev_cid = $cid; - } - else { - $display_flag = 0; - $prev_cid = $cid; - } - } - - if ($display_flag) { - foreach ($row as $colName => $colVal) { - if (in_array($colName, $this->_noRepeats)) { - unset($rows[$rowNum][$colName]); - } - } - } - $entryFound = TRUE; - } - } - } - - if (array_key_exists('first_contribution', $row) || - array_key_exists('last_contribution', $row) - ) { - $details = CRM_Contribute_BAO_Contribution_Utils::getFirstLastDetails($row['civicrm_contact_id']); - if ($details['first']) { - $rows[$rowNum]['first_contribution'] = CRM_Utils_Money::format($details['first']['total_amount']) . ' - ' . CRM_Utils_Date::customFormat($details['first']['receive_date'], $config->dateformatFull); - } - if ($details['last']) { - $rows[$rowNum]['last_contribution'] = CRM_Utils_Money::format($details['last']['total_amount']) . ' - ' . CRM_Utils_Date::customFormat($details['last']['receive_date'], $config->dateformatFull); - } - } - - // handle state province - if (array_key_exists('civicrm_address_state_province_id', $row)) { - if ($value = $row['civicrm_address_state_province_id']) { - $rows[$rowNum]['civicrm_address_state_province_id'] = CRM_Core_PseudoConstant::stateProvince($value, FALSE); - - $url = CRM_Report_Utils_Report::getNextUrl('contribute/detail', - "reset=1&force=1&" . - "state_province_id_op=in&state_province_id_value={$value}", - $this->_absoluteUrl, $this->_id - ); - $rows[$rowNum]['civicrm_address_state_province_id_link'] = $url; - $rows[$rowNum]['civicrm_address_state_province_id_hover'] = ts("List all contribution(s) for this State."); - } - $entryFound = TRUE; - } - - // handle country - if (array_key_exists('civicrm_address_country_id', $row)) { - if ($value = $row['civicrm_address_country_id']) { - $rows[$rowNum]['civicrm_address_country_id'] = CRM_Core_PseudoConstant::country($value, FALSE); - - $url = CRM_Report_Utils_Report::getNextUrl('contribute/detail', - "reset=1&force=1&" . - "country_id_op=in&country_id_value={$value}", - $this->_absoluteUrl, $this->_id - ); - $rows[$rowNum]['civicrm_address_country_id_link'] = $url; - $rows[$rowNum]['civicrm_address_country_id_hover'] = ts("List all contribution(s) for this Country."); - } - - $entryFound = TRUE; - } - - // convert display name to links - if (array_key_exists('civicrm_contact_display_name', $row) && !empty($rows[$rowNum]['civicrm_contact_display_name']) && - array_key_exists('civicrm_contact_id', $row) - ) { - $url = CRM_Utils_System::url("civicrm/contact/view", - 'reset=1&cid=' . $row['civicrm_contact_id'], - $this->_absoluteUrl - ); - $rows[$rowNum]['civicrm_contact_display_name_link'] = $url; - $rows[$rowNum]['civicrm_contact_display_name_hover'] = ts("View Contact Summary for this Contact."); - } - - // convert soft credit id to link - if (array_key_exists('soft_credit_display_name', $row) && !empty($rows[$rowNum]['soft_credit_display_name']) && - array_key_exists('id', $row) - ) { - $url = CRM_Utils_System::url("civicrm/contact/view", - 'reset=1&cid=' . $row['id'], - $this->_absoluteUrl - ); - $rows[$rowNum]['soft_credit_display_name_creditor_link'] = $url; - $rows[$rowNum]['soft_credit_display_name_creditor_hover'] = ts("View Contact Summary for this Soft Credit."); - } - - // convert hon/mem contact to link - if (array_key_exists('civicrm_contact_hon_mem_display_name', $row) && !empty($rows[$rowNum]['civicrm_contribution_honor_contact_id']) && - array_key_exists('civicrm_contribution_honor_contact_id', $row) - ) { - $url = CRM_Utils_System::url("civicrm/contact/view", - 'reset=1&cid=' . $row['civicrm_contribution_honor_contact_id'], - $this->_absoluteUrl - ); - $rows[$rowNum]['civicrm_contact_hon_mem_display_name_link'] = $url; - $rows[$rowNum]['civicrm_contact_hon_mem_display_name_hover'] = ts("View Contact Summary for this Honor/Memory Contribution."); - } - - // honor of/memory of type - if ($value = CRM_Utils_Array::value('civicrm_contribution_honor_type_id', $row) && !empty($rows[$rowNum]['civicrm_contribution_honor_type_id'])) { - // rather than do a join, just change the output here, since there these values are pretty static - - - if ($rows[$rowNum]['civicrm_contribution_honor_type_id'] == 1) { - $rows[$rowNum]['civicrm_contribution_honor_type_id'] = "In Honor Of"; - } - elseif ($rows[$rowNum]['civicrm_contribution_honor_type_id'] == 2) { - $rows[$rowNum]['civicrm_contribution_honor_type_id'] = "In Memory Of"; - } - else { - $rows[$rowNum]['civicrm_contribution_honor_type_id'] = "n/a"; - } - } - - if ($value = CRM_Utils_Array::value('civicrm_contribution_contribution_type_id', $row)) { - $rows[$rowNum]['civicrm_contribution_contribution_type_id'] = $contributionTypes[$value]; - $entryFound = TRUE; - } - - if (($value = CRM_Utils_Array::value('civicrm_contribution_total_amount', $row)) && - CRM_Core_Permission::check('access CiviContribute') - ) { - $url = CRM_Utils_System::url("civicrm/contact/view/contribution", - "reset=1&id=" . - $row['civicrm_contribution_contribution_id'] . - "&cid=" . - $row['civicrm_contact_id'] . - "&action=view&context=contribution&selectedChild=contribute", - $this->_absoluteUrl - ); - $rows[$rowNum]['civicrm_contribution_total_amount_link'] = $url; - $rows[$rowNum]['civicrm_contribution_total_amount_hover'] = ts("View Details of this Contribution."); - $entryFound = TRUE; - } - - // skip looking further in rows, if first row itself doesn't - // have the column we need - if (!$entryFound) { - break; - } - $lastKey = $rowNum; - } - } -} - diff --git a/tools/extensions/org.civicrm.report.baykeeper/templates/Baykeeper.tpl b/tools/extensions/org.civicrm.report.baykeeper/templates/Baykeeper.tpl deleted file mode 100644 index a59eaf9b93..0000000000 --- a/tools/extensions/org.civicrm.report.baykeeper/templates/Baykeeper.tpl +++ /dev/null @@ -1,33 +0,0 @@ -{* - +--------------------------------------------------------------------+ - | CiviCRM version 4.7 | - +--------------------------------------------------------------------+ - | Copyright CiviCRM LLC (c) 2004-2015 | - +--------------------------------------------------------------------+ - | This file is a part of CiviCRM. | - | | - | CiviCRM is free software; you can copy, modify, and distribute it | - | under the terms of the GNU Affero General Public License | - | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | - | | - | CiviCRM is distributed in the hope that it will be useful, but | - | WITHOUT ANY WARRANTY; without even the implied warranty of | - | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | - | See the GNU Affero General Public License for more details. | - | | - | You should have received a copy of the GNU Affero General Public | - | License and the CiviCRM Licensing Exception along | - | with this program; if not, contact CiviCRM LLC | - | at info[AT]civicrm[DOT]org. If you have questions about the | - | GNU Affero General Public License or the licensing of CiviCRM, | - | see the CiviCRM license FAQ at http://civicrm.org/licensing | - +--------------------------------------------------------------------+ -*} -{include file="CRM/Report/Form.tpl"} - -{literal} - -{/literal} \ No newline at end of file diff --git a/tools/extensions/org.civicrm.report.grant.zip b/tools/extensions/org.civicrm.report.grant.zip deleted file mode 100644 index f3eeccd02676d5fd2da3059e1dbfebc405f79639..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 4681 zcma)AbyQUA9vxt4=}swONGT;Qa0%&-p$3ToB!@16Aslj~1ObVm1Vlo*hEPD#0VJdw zq$LGJP#)g<*1EoR-}Sw7*7??V{@MHYJ8Pfc`u5h-!~qfkeq1H35^{fR{=F~&m;vry z4nnq0eonStFd;8{4|gvgAqOuTH=o;JBSHX9c7=@g#r5MGKn%bFZsGs{e=K_c2+8>? zNFRHchpUZ`z4!kFr@pR`08n&YuaE9APzW0UD8K^%1pYs8)gSc>`FObg(L&mPZ=vm} zzWas61|czrR%o1|aCmpXL` zH9PwDt>p@}zubhy^8(+Lhs0DNJ-v0uN-0))L!&d&8_V6I3~^NA`tqDZ1X9zHN4(#8 z=CR-wDkbo6(VzH>15ymfuOD~nQ9h_J>?64I4A_yUaHyxxehP4V6 z3LwB?Ex;T~4JT?ZiZAa{-2lgKWkFOe#`EN-?`Wme&!2$%Y}Sp6RZ13W)R2& z=L>%@Do~O5o6Mx_>mcQhJrnmOTroYyua?5Q+T8DNo-cJyo#0gd#?mAg_u_ki_?E1D zsfNR&CWmlnAP1O{U9qdF55O~P?*PmI9NTI{vs`sEtUU5uiI zA@$aS-gyrLE~f&PM5&b{K4@Kf-BT01DORLiR!Q*2Ze{aO;)me>(qtDnAIy0DOF75` z035&4{QXwW}u zZA6i5d|RjF*;V`e^AUbd_9Ty?QX_0=u~kk;af?IY z{G0lIVr3tduf@D*|Nf`N{B66o->($04Sv$T?fJK74^EmrLHf5qTF&(_~_C^+JHM~WzbC7Uln`$t$@lHV& zCb`)j(dFH(#MZtQrN9b0yf1wmPaFQEI{P+V%JB19!Yz{hzVwBFIVPPw9c!dSqcuIe zAY2}9!zA4oO)iPt5~S#TDr#uLehvzHl!Q!e{+|vN?2UfBnRYKqH)3_ zuV@3D!|(|4)S-bUF;LTk`>tdvctH6nSZ|=u({92MhqraDv{SZ$$V?qja|rt#Oos1b zmKK=4Qu^`5*od98R3gkv#P)IA`Na#}`{G2&oj9V{Fx`P^W*&ai5S2B@Y-96k=JZ}! z@r9+@;lL{e$VQICO@HaR@w?BaV{v;<$DfjgZdsp)e?^4$y>?apRx0xdw#t8ce?Gg# zb8b1(k3I(AN&0PUl7$aatPu%{YNC`Cz)oa2Bx0T3cz6{`( zMXe}Gd$Zb;B6o$uk2r_eKewoA4=QJUluwDv>`TOnKz_po9+e=?R`ra<2lHPA6&tbz zremnPig*s+XSkQfW!97zFeFq4suuPaE&Ik~2cJ=d+`YuDD$*>-J?N~fmeE)w7UC7p z9W&Vup^jTQzNKBw<@fyJ2|L#r!tBV&ojN4V92+aYfgx~H1H=|;RH*F_Q!*PUuF0b; z#pEVuY;ENzaB9lZxq0sNB@w#N(r1Wdj47sInYL4Cdm> zb*YL}in&TCGcq*k6M&+{afg&z$0aw4cGaUx&FI1;K=s~(MeQog3_|%h%!BhLq&vJv z$Omq)2lK=b*tm}tYDdnw{n;tKA*j?CZ|1J6H4SFNE1;OoC8@UiB6l22l55eO znujdH=0B(C=S?xs%wRMV=Q>ZCVibw!;`ts93+j^*9e ztVA2IS>51)G_{Xemf~%!%D&h2dhNw&MHn&H-m-ujJ&0)!`ot$0!?>14B?~VbC&7r0CeidjPd+5k(OwncFculf>+T*LtkfvlyT5EK|@tCOBBO=)~j< zl@ahlj{%HVNx@M6$jm!tByrI1+$^$4e|>6DT&R*6J0yWQ5Me-j2T+UL2$zw8?a>4Hjawh06bJgqc$p}p4a-C8 z{rpqAK7zm3#HR&tPVFV*In_3b2$GOEE$0f8i7&svbFxd8=YE1=c3}_kB@R_k9wBpB z9idT|#a1CbNJYNQd(--vb7c!Xw(KhdtGP$h)PduSaI^Yo+=GKZHY!WHZ49$=1; zpHGFUT7iZrcP|cp7o!MIjTu^8AJ1oyyPlSaOE|5R{s^ItqkoBX$JW{aL*D^k86JH{iw<40w|}>q z8M<2xsDp1?Y_4m%7_}3N@4cD0Y(0;9ANffEOxSEN=N0`Srhek`-FirBHBnae?Ogm- z1@wk(DlL_d=|(0Gv;m0%Ev6D(sQUGsI`O)(pC>v7H24k(N*v~+*gV`9iw7f5*-Eyi zN%REl(Q-T5ib9o9?(Q{rEFEb~rr z=ipt@t;Dp-`jor74Sd##E@|IUfaE>$1%Ac88@co*pvWM&?JMSJ5OZ~GgNBxhY^e!- z5&ldUXLeBSDv>?&sDJDEXWA65bzQv@2AU^=!h7v{6XNNS7(|fUcb}A}Zq3nO=R_5x z%r@*9w^$NuMvZxLFeaVCX|?V!QIJX|JA9}$?bu=Pyp;t`&0Md?N6lPtlO;c4fwtZdB{xI2aSpJ z3cYcXY4aOu;RW}9m-l>jFH3+SIeX&b>yu<}9AiwF&3Tec^osIAYXhwxeZirdvG$HS z?k3}FQ8%%&oX`c!kkTcU`(bYP3wWZcH z%8xA0=^WZDW%0`zczq`o-=cntph{I+m<6T1eeWuQoCm{iks|e5i;S;CP}DCj%Ny^~ zeqfm`>T|$Dxv7$~iXo^O1_+_9kG3eCP|aZt6R+>l2b1+H-HWJGj)Bi^3x`=L4RKJG zQc=K8NNr*_*I3t zWKYMLk{Ih}yfQdgmyb``s??MAa@@a2(DuztbbG}WQ-d(cyXL{yPb20bWF6;8hUwig z+dK1JipXy_A?9ec0=lk}7Z-IW3WKqM-vh`VcUvGS_(|2+jTstGt%eMQ0w!d6Qn3WL zV-|fBPdr6Y7CLfPI>iRrE4vaxVVM(lb5~FMr}E(%Ms_qQmgZ|hENrKa!L#}}={=d^ zpa%xxtr^Pdo^CAPAgtKFJ2=_~d%gIZUUD+G)FlYfOQGy=s%_emcQU@sCe=~??k9Wj zH2$^nw~xOdkavtLcS-iuSj|OrMCfeYK?&Kl{`XQKB6}kg5tnPuH)+;9As@P}^fa-s zS#ka;E1>^(YCsP7r0`?=i{t?J&*b25slh+Pa{_*bH~ba+&nd#Mi2m|x|Cu5DNrZJx zQ5atJ{}KI^C|ooCNEH5SYkx8Rr$hXi@!oZY@{eEcC%^c=dHy~Ve&#`w{DSAN32{yH aV?z9`9o*}<1pvUkz6q~K4j=iCw|@cMh9k-V diff --git a/tools/extensions/org.civicrm.report.grant/Grant.php b/tools/extensions/org.civicrm.report.grant/Grant.php deleted file mode 100644 index 52a10b8fb7..0000000000 --- a/tools/extensions/org.civicrm.report.grant/Grant.php +++ /dev/null @@ -1,348 +0,0 @@ -_columns = array( - 'civicrm_contact' => - array('dao' => 'CRM_Contact_DAO_Contact', - 'fields' => - array('display_name' => - array('title' => ts('Contact Name'), - 'required' => TRUE, - 'no_repeat' => TRUE, - ), - ), - 'grouping' => 'contact-fields', - 'filters' => - array('display_name' => - array('title' => ts('Contact Name'), - 'operator' => 'like', - ), - 'gender_id' => - array('title' => ts('Gender'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Core_PseudoConstant::get('CRM_Contact_DAO_Contact', 'gender_id'), - ), - ), - ), - 'civicrm_address' => - array('dao' => 'CRM_Core_DAO_Address', - 'filters' => - array('country_id' => - array('title' => ts('Country'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Core_PseudoConstant::country(), - ), - 'state_province_id' => - array('title' => ts('State/Province'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Core_PseudoConstant::stateProvince(), - ), - ), - ), - 'civicrm_grant' => - array('dao' => 'CRM_Grant_DAO_Grant', - 'fields' => - array( - 'grant_type_id' => - array( - 'name' => 'grant_type_id', - 'title' => ts('Grant Type'), - ), - 'status_id' => - array( - 'name' => 'status_id', - 'title' => ts('Grant Status'), - ), - 'amount_requested' => - array( - 'name' => 'amount_requested', - 'title' => ts('Amount Requested'), - 'type' => CRM_Utils_Type::T_MONEY, - ), - 'amount_granted' => - array( - 'name' => 'amount_granted', - 'title' => ts('Amount Granted'), - ), - 'application_received_date' => - array( - 'name' => 'application_received_date', - 'title' => ts('Application Received Date'), - 'default' => TRUE, - ), - 'money_transfer_date' => - array( - 'name' => 'money_transfer_date', - 'title' => ts('Money Transfer Date'), - 'type' => CRM_Utils_Type::T_DATE, - ), - 'grant_due_date' => - array( - 'name' => 'grant_due_date', - 'title' => ts('Grant Due Date'), - 'type' => CRM_Utils_Type::T_DATE, - ), - 'rationale' => - array( - 'name' => 'rationale', - 'title' => ts('Rationale'), - ), - 'grant_report_received' => - array( - 'name' => 'grant_report_received', - 'title' => ts('Grant Report Received'), - ), - ), - 'filters' => - array('grant_type' => - array( - 'name' => 'grant_type_id', - 'title' => ts('Grant Type'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Core_PseudoConstant::get('CRM_Grant_DAO_Grant', 'grant_type_id'), - ), - 'status_id' => - array( - 'name' => 'status_id', - 'title' => ts('Grant Status'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Core_PseudoConstant::get('CRM_Grant_DAO_Grant', 'status_id'), - ), - 'amount_granted' => - array( - 'title' => ts('Amount Granted'), - 'operatorType' => CRM_Report_Form::OP_INT, - ), - 'amount_requested' => - array( - 'title' => ts('Amount Requested'), - 'operatorType' => CRM_Report_Form::OP_INT, - ), - 'application_received_date' => - array( - 'title' => ts('Application Received Date'), - 'operatorType' => CRM_Report_Form::OP_DATE, - ), - 'money_transfer_date' => - array( - 'title' => ts('Money Transfer Date'), - 'operatorType' => CRM_Report_Form::OP_DATE, - ), - 'grant_due_date' => - array( - 'title' => ts('Grant Due Date'), - 'operatorType' => CRM_Report_Form::OP_DATE, - 'type' => CRM_Report_Form::OP_DATE, - ), - ), - 'group_bys' => - array( - 'grant_type_id' => - array( - 'title' => ts('Grant Type'), - ), - 'status_id' => - array( - 'title' => ts('Grant Status'), - ), - 'amount_requested' => - array( - 'title' => ts('Amount Requested'), - ), - 'amount_granted' => - array( - 'title' => ts('Amount Granted'), - ), - 'application_received_date' => - array( - 'title' => ts('Application Received Date'), - ), - 'money_transfer_date' => - array( - 'title' => ts('Money Transfer Date'), - ), - ), - ), - ); - - parent::__construct(); - } - - function select() { - $select = array(); - - $this->_columnHeaders = array(); - foreach ($this->_columns as $tableName => $table) { - if ($tableName == 'civicrm_address') { - $this->_addressField = TRUE; - } - if (array_key_exists('fields', $table)) { - foreach ($table['fields'] as $fieldName => $field) { - if (!empty($field['required']) || !empty($this->_params['fields'][$fieldName])) { - - $select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}"; - - $this->_columnHeaders["{$tableName}_{$fieldName}"]['title'] = $field['title']; - $this->_columnHeaders["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array::value('type', $field); - } - } - } - } - - $this->_select = "SELECT " . implode(', ', $select) . " "; - } - - function from() { - $this->_from = " - FROM civicrm_grant {$this->_aliases['civicrm_grant']} - LEFT JOIN civicrm_contact {$this->_aliases['civicrm_contact']} - ON ({$this->_aliases['civicrm_grant']}.contact_id = {$this->_aliases['civicrm_contact']}.id ) "; - if ($this->_addressField) { - $this->_from .= " - LEFT JOIN civicrm_address {$this->_aliases['civicrm_address']} - ON {$this->_aliases['civicrm_contact']}.id = - {$this->_aliases['civicrm_address']}.contact_id AND - {$this->_aliases['civicrm_address']}.is_primary = 1\n"; - } - } - - function where() { - $clauses = array(); - foreach ($this->_columns as $tableName => $table) { - if (array_key_exists('filters', $table)) { - foreach ($table['filters'] as $fieldName => $field) { - - $clause = NULL; - if (CRM_Utils_Array::value('type', $field) & CRM_Utils_Type::T_DATE) { - $relative = CRM_Utils_Array::value("{$fieldName}_relative", $this->_params); - $from = CRM_Utils_Array::value("{$fieldName}_from", $this->_params); - $to = CRM_Utils_Array::value("{$fieldName}_to", $this->_params); - - if ($relative || $from || $to) { - $clause = $this->dateClause($field['name'], $relative, $from, $to, $field['type']); - } - } - else { - $op = CRM_Utils_Array::value("{$fieldName}_op", $this->_params); - if ($op) { - $clause = $this->whereClause($field, - $op, - CRM_Utils_Array::value("{$fieldName}_value", $this->_params), - CRM_Utils_Array::value("{$fieldName}_min", $this->_params), - CRM_Utils_Array::value("{$fieldName}_max", $this->_params) - ); - } - } - if (!empty($clause)) { - $clauses[] = $clause; - $this->_where = "WHERE" . implode(' AND ', $clauses); - } - } - } - } - } - - function groupBy() { - $this->_groupBy = ""; - if (!empty($this->_params['group_bys']) && - is_array($this->_params['group_bys']) && - !empty($this->_params['group_bys']) - ) { - foreach ($this->_columns as $tableName => $table) { - if (array_key_exists('group_bys', $table)) { - foreach ($table['group_bys'] as $fieldName => $field) { - if (!empty($this->_params['group_bys'][$fieldName])) { - $this->_groupBy[] = $field['dbAlias']; - } - } - } - } - } - if (!empty($this->_groupBy)) { - $this->_groupBy = "ORDER BY " . implode(', ', $this->_groupBy) . ", {$this->_aliases['civicrm_contact']}.sort_name"; - } - } - - /** - * @param $rows - */ - function alterDisplay(&$rows) { - // custom code to alter rows - $entryFound = FALSE; - foreach ($rows as $rowNum => $row) { - if (array_key_exists('civicrm_grant_grant_type_id', $row)) { - if ($value = $row['civicrm_grant_grant_type_id']) { - $rows[$rowNum]['civicrm_grant_grant_type_id'] = CRM_Core_PseudoConstant::getLabel('CRM_Grant_DAO_Grant', 'grant_type_id', $value); - } - $entryFound = TRUE; - } - if (array_key_exists('civicrm_grant_status_id', $row)) { - if ($value = $row['civicrm_grant_status_id']) { - $rows[$rowNum]['civicrm_grant_status_id'] = CRM_Core_PseudoConstant::getLabel('CRM_Grant_DAO_Grant', 'status_id', $value); - } - $entryFound = TRUE; - } - if (array_key_exists('civicrm_grant_grant_report_received', $row)) { - if ($value = $row['civicrm_grant_grant_report_received']) { - if ($value == 1) { - $value = 'Yes'; - } - else { - $value = 'No'; - } - $rows[$rowNum]['civicrm_grant_grant_report_received'] = $value; - } - $entryFound = TRUE; - } - if (!$entryFound) { - break; - } - } - } -} - diff --git a/tools/extensions/org.civicrm.report.grant/info.xml b/tools/extensions/org.civicrm.report.grant/info.xml deleted file mode 100644 index 0484ec1957..0000000000 --- a/tools/extensions/org.civicrm.report.grant/info.xml +++ /dev/null @@ -1,27 +0,0 @@ - - - http://svn.civicrm.org/tools/branches/v3.3/extensions/org.civicrm.report.grant.zip - Grant - Grant Report - Grant Report allows you to see the summary of grants that - have been admitted to your consitutents by your organisation. - - http://civicrm.org - http://forum.civicrm.org - http://civicrm.org/licensing - - AGPL - - CiviCRM LLC - info@civicrm.org - - 2010-09-01 - 1.1 - stable - 3.3 - For support, please contact project team on the forums. (http://forum.civicrm.org) - - grant/summary - CiviGrant - - diff --git a/tools/extensions/org.civicrm.report.grant/templates/Grant.tpl b/tools/extensions/org.civicrm.report.grant/templates/Grant.tpl deleted file mode 100644 index a8220b0fb9..0000000000 --- a/tools/extensions/org.civicrm.report.grant/templates/Grant.tpl +++ /dev/null @@ -1,26 +0,0 @@ -{* - +--------------------------------------------------------------------+ - | CiviCRM version 4.7 | - +--------------------------------------------------------------------+ - | Copyright CiviCRM LLC (c) 2004-2015 | - +--------------------------------------------------------------------+ - | This file is a part of CiviCRM. | - | | - | CiviCRM is free software; you can copy, modify, and distribute it | - | under the terms of the GNU Affero General Public License | - | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | - | | - | CiviCRM is distributed in the hope that it will be useful, but | - | WITHOUT ANY WARRANTY; without even the implied warranty of | - | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | - | See the GNU Affero General Public License for more details. | - | | - | You should have received a copy of the GNU Affero General Public | - | License and the CiviCRM Licensing Exception along | - | with this program; if not, contact CiviCRM LLC | - | at info[AT]civicrm[DOT]org. If you have questions about the | - | GNU Affero General Public License or the licensing of CiviCRM, | - | see the CiviCRM license FAQ at http://civicrm.org/licensing | - +--------------------------------------------------------------------+ -*} -{include file="CRM/Report/Form.tpl"} \ No newline at end of file diff --git a/tools/extensions/org.civicrm.search.activity.zip b/tools/extensions/org.civicrm.search.activity.zip deleted file mode 100644 index 24014135be707fbb1f189b061c243b961be688e7..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 8088 zcma)>Wpv$0)~=74Ic8=)W@e@wGds3pW@hG?IcCO~V`gTIV@k}-%xvc--MwaddhXXf z(vp@+KlY=ldL`}Juc90TBs}2PHl@ie_}j%FCjtNgz|PSOXk_7PVdQ87bTTn;G%^Po z7&-sE;q1YrrV0mupi>Y4@%%ho+z|j^koyn-z;7qTe?=YtOH`_Vi0W)&V{dKXY~u8L ze3Jh={+plA2@6G>zntx@f9ugxB|qr(=kb>w zooLzEElHxk61+t4^oCJen2o0o?7 zaN^KsOdmA%xVX+=Jpn%V^TdcuUu>D4Anx7y?%jQyI*C*zCy|OKofU(n`pF7Vl_hXe zRwA;$Z$4m1W{3mbVKG>X;->s-X<0?y0t5*aM^m78-G%x=(hwV8oSjvL`h{69heQrjq}AM6$rnL~NEj57 ziyGyymm4 zg^~{BQjbceyNR8Ld!lYDhvQr%Fr<>~Inbe}mjKs`6XQUn>*Ax?q0D^EET>V;u%{wI zivsj^9W&946tLo0WE)wbQH8Y0I8W+%JC?3{svnh^rOwVwHbsDCZ4f{Tq`i-Ft&M?2 zq-jqK+Up0^FZXbid3*v?=#hJa>8tum-OS*5Wt5lyH0VUZ&a)&g$PWt-V*WLsdF)O)b3KGNDvD-dn)`@hjaoT{+yHsL=F5b^LsOIQGuQ@W)XR*idv;Y!kB66D4`0x5(i(VS@s9 zsw)PJqv~m1r3k!No4Et&D`OD7n*e#qj|E(}*RQrUHCB4$Gjz*kdA>cGm5E<1z#lQw zl{cQ9u?;WG!CkvX@j#+&wIgC`dyV!F=%_KW(xyQJ2c2XrjBsmJi|WBE)Ss2ulvvjC z6jKsBM=eMCn-;X~AA#n{mWt9t_xkDDSkW>gYBPMh6yZ2USJyzn+*43%E++F%A<`>41aMzHb}=zit=GcE_P5n#+zbgBCy z!t`god{i}dlidgGGL-U&X{<8f4a%H@=l>T$lanQzWak zHNd`|B+sPQiVD%LA@MLipBXtM@M%FCMg%R6`+%G-iWKFI3f@Mviv#h~K7f|-DI9%^ z<&*0imV5H%al4!Hy5 z7JuoccTUZx1Py@e*fz+g$;2Teebp9ktkF*{I|WR`mz+GbmkhaXw#k}_tt~`|<%@5n zs^Bdm>lG86^rWOg?))rd74NKALV(TMjiKPn&`ZS|7(jGp6WPVUGdR$Rg`@9|eX79+C2DaD|xPt^I|DNS`m z63%X8YjW|BQA*Kw+&T%k*fmr|x(x(|l)y1c!U*I(M^FprmEZff2xc7@K44nwg@;YM z8gWiNG}=~Y5D0cPB-$$2dFh~DgZt_wg;(kplZ9OLQh?j2k+#NJi~TqxoCWsGJurQ3 zZ|!Ke2JSYXBOD>x$k3xHmas$PIP+S$hCbIRm#L+wjPX>NI@nC>$bMv71z%q7yjlO0 zI9F@faCYx$$ZqSR{xX`Zt}n0vZ8R}5H;HJ~N|%GZ+t~(Um#5H!Q-Pv-7Le$o{eh5% z{-hpCu2(t!>2C8W<+Y0mY=gkAKvvklsjsHPzz|>Jo5XfiU~|lSom$=H(rON2<3|}3 z{_hnxeu&Yl7x?5934B0l_aXG+(+FP$lQC;+Vy>@<2ov5s?o)H+_qS8#6{|By_)qpR z2Vc2vW!&c8=~3OKxPguuM*A|4@HsXjsY?+%>*3LLY*LR3F4T1VFloE8hSi^N@DS>q zE%uk0V((FY&Mo`d+-Fyy9i$6ttRVVuzcq63z77aR;- zUpxP3m3qEznln@@cUhescC+j1*=xgl$a?3lusX0W;E}I%90K-`_X6Ruvv+4#rqHY{ zwdx&joUW^@8~0&`Vn|BL&)3WQ`eo{eYR*M(2U`-ynO0eAskJVN%aClK2;@PqrUcg|Z{86#e~7p#CZ zo}Adei%Blx!9q751;Ja%g4LV*S4imu3D}u^j2*;|ozXjgA!`w1m=U~_l7p*Gq1Joc zFt5G7@{RlKU^HCBq3kATEicTi9W6)LSrHd41cIT zI7*w-{kPA}l@|}{uAMM;kv&+Qa#*(*lxQv`caX`|X%Mz|)ICy`9YLQ_mryp^w1}5+ z-vgF9BYHiInH0jf$VF1?g>y)12nBLgs}OX_Q$tWXE(##7vdkasJ=lB^3p_Fq&5q-0 zZhU1eqGUxBQ}d;APw8?_p59z;?U^A=^vTliVMO|*j6MZ=etm*+(WMwETRMPMTgo-1 zHcLIair(DFKrSX87P=RE?X1mOJLcKv^qlPETQcJMQjW61YX){q_DFj}#tR1#ijH8; zi|yUU8^o;bdRjur6ZwVNpN6B3aPh+%^Q>9R7`q|V`uqoR1|RggG>qKf0At<0M41$J zX~S7NvS#_XqhO~j<98z|+DMF0Rf&o)TM|CtL*@_VCw-hb=b?4%_Nn;tRO?Ep+RD@x zaebbG@$4hmrWfh#K7<07CuzM=nF*fZ9KNZ#J9|hig=|dgI%mPYt&mcEK@%EqpBUv| zg2gwSDo|Zy9VriJd+zIPx6{>p6PgWlm*gya)+W5~ucI^_a3~W2ISsB`PAT&;csde- zj|#uC!*NRNAv?f9venS9``s(V)#Ij(YXU`>-n;^KtmQN*ye;YuU+8 zPt%N(?q;C_IuPt6h|(}2SZmv)CviZZ$^Q8xn4a**>nnIN!@>TKqhyObXDiM?95YkV z_#O(SESnLWyypXhPI_T>rLcMA4T^bu+}3VLhQxa5xW`xISG601?fzPBa`q^1<=284 zu==-#&|YS+-bxUBJs;B;`KNhS8;d`1#eOcnvNSmFv#pcD&NVoH0j5ov$^8=^CFR7MM1X3 z;R7(AI^3ha25qW*WNPrgN4icE5&GPt`8M8EZLMVj4F&0lCMkGEMbbn`r?6XMhIDpb1+zu zgxF@VYNBOu4Jn0{M*PO+r_Y9<^}mV2D!;w!zZrz{4u5hWFsHHKftZ;cjb zQK~K9E_YqV)Xi!)QWCE%r1OjU6*0CjOr(FVqe-!?E~TMv)J~dQny9+GBO>ykg>~Qx zKYpLxvZGhUAqZI>kgSO0z))2_QUasY3<*lBS2wlHK1{V^PQ0ovAx^8M3H$mEmGs>k zNci|m$IN@Re0ErI@#weJ&s(I^I79B+Uq?lXlVoi&jGq;#xt#;(YGHf8_#0%=7 zUr$}Qa)BB15oYslOk?6FGD-D^b^zqh{XnrMg2d1RsT|#)b@8O#tz^fi<5|?dRgC{B%GYoh{_C822tzgjxNSb0s zOSyrNSK`N!kzm5!84^oXY(1OF?xdB(j=wBkn%$M~wLev8$Agt-{A~`G5a(B{N#_9d zD0M5rO6|Hubh^Y)g|#N0GA6%>OD=P!Ko!ge_x7<%mi@Qrb}}5$+?L9(?$kS55s)X` z)obl=#`)N>oaT&PLcCc7E5bBw0=#(yE8@dXd{Cf)l7JW!ym1zr0VF2`lh`^**M?9Y zo9~gN&sCVzW9~F2&CfKtp(%@c*_lUd-E{7^5*;D>^xfxd>Te(3-ZmISWLo<4iq7Z2 z7Dhm#m#t4R46%-Q|Ja&*QPTHb`~Fc~tTM~ZT63q01RO1dB_2tV>r8_CRmfr%=aKQD zwH8^d1z)KiJ3Z+R9S{q~-!0gGP)hb~J_0qq6Uo#z-e)@b1lH?NWr4#y@#QwdM+`fV z51yP#j(y2Ut&!3mJn`J71uZ9NJ@mvJzF(GG{Qo3UrQYxtCLFeHO``aT$4 zLQ?(9a3BbVBUv=E$!t7#??|#vlb-do6+?AoblcbvF}I+B<+JYX8SpKeafC)~S^r+8 za&bc=pAFcI$^LZ|L402yVp}$tHU~hUg-N6DuCFGuBJdrDa97XXb?t3n1NPE3`8a|^2&de+rf}vZscVasuMn_>9Kk^cH}rW9VHwMHjc{Ak zV+kD}jFH@4VQR`ZLs9L3O;4nd`C8oHz5(T@2cu<>jFd>4eK>fIH_I;-j~3mk2oSW*Zqw z-!=-`W(tXHOtAz-Jh815%TA4w06%lUOHL*_Q6bkjHFg2&o5Hr9!D8u|T_VG*O=Ao( zh1(+e*?3nQYXeEM;APoV|Dd6bHg&nY} zoehsFXiXh@?z1$;+P$eQ;cKYDhM?BD=E)oma+utGpFG4nHJQZwMw@vKXL+`~#Az;x zOBDVtmp~mMv9>kP$~8gXHV%`*0skCcp>mmp5>)=qZ+3uu@MQK}emrP;N*UP243dp2 zxO~4av9{f66*|9|H@P_ATHsF~kq($!V#DLRjW|S)FkUuCN#(l5FRmJ#JJ0bMM%Gsa zGQq(5a=Lxy?X6BVFoSBH-mjJ@-(4y7jV~tS4mX${7UV(CGU!f0jwaWu z0T}8nv(k$VS)hGfujvQO(-mX}GoDLl>qfp&L%Zq@44#bgj_Fj|zV($f%4qI-Hc&G` z@o|$tVm7GjOoP?c*+G4OmIbyN;huE2TMn*1n6EW>iR;GjE+(e+c!=)tV@g1#@x9IK4(*%F_UyN?jhZ~4Gjmm0m{%0L_OL!&`ULsZEyd6s!C%(eQ0mto zU!bgXJ;Mq~j79LYEvd0`XgBnq#4cQanqeKYjO+!Y|Csba@7=+hQXJAyutS0!P|78J z#e7_^imT)y0jh>8QU6t+nA2_`0Gk?(4hi!n{&E+hs(q=0J7+oOF=(Uf=V!wT)zMR% zr=T@2o+)`j52HnE^;@=hOYJ09HkTQJ3;B3eo-ItL7G~?bp!G(qr0xE&+P2(0q3|%& zL0hJrlKifAwP7eNnZMCRZ@jcQKWf+;Va5Rsv)$(gH$Tuab9F*R5@*qKjtc)_IvS&u z*}huU{wAEhv4&48$7LG7(a~qF>B(6cj7J351-z(*a=nz9v^nbe#uJv=&orcb3=BW? zGfugaphiIpFN4ZM?aHZ!v5rzDlx^XcSZv|S>1R1g4PqA`(rQK&-4Q@e!BJwjjaYBZ z?7T{&+!bkJ<>;?ay_;e%;P-0AWo;aA@dEKRtFgx8~Ur3@ICc%cI0duP^ zY80Ll(O`uuK~jh9NZ9sa=KF|H&9yPYJaX|wVP$O7DEZ$_o=fU@m36bYNC_XwDLmDd z2{CuVnLs#fs*-QFgrHZwat<9? ze~+BJKl)5*+6DG+A^q~GY;I3)kNyx6#s4Uze|c4Zqoch)bR_d{9c})-jv83(g@5X3 z%uwkI!cQH^FIj5w3$08DzOknV`ft(aft1cMV#j(P%2Xe7lk7(Qr^{PEMvw^)f$z_6 z*6weRQ9-P=U|VG_3wV)R=HFr%ZM>%rDH$B*!I=LhS8j=TY_GCfJ;Gk?hm+jpJho6O zQM+svv^j=aJA#{O!d#=yX~z)dEa}vN^YJ^Qgw=)W5uglV8*e{L1aC_ZJPseMtmCLm z`Z@v+Lb?qicGd&`%R1`RS6p~|3&H@$WHJF%HM2ru@z108O4Kfet-N-kyw_6F*R{*jJYQ*jq)d59ek+Nq81 zx`Zlt@a@7aHbWJ?zoPio7A$(yL`;_td1-#u_?M3EPOr3n>1gtI9cjqWRP9ARSid@O z>f5_Ud}`jvL5;jjue+H3JP0=N!7yuW*>+yD|_formValues = $formValues; - - /** - * Define the columns for search result rows - */ - $this->_columns = array( - ts('Name') => 'sort_name', - ts('Status') => 'activity_status', - ts('Activity Type') => 'activity_type', - ts('Activity Subject') => 'activity_subject', - ts('Scheduled By') => 'source_contact', - ts('Scheduled Date') => 'activity_date', - ' ' => 'activity_id', - ' ' => 'activity_type_id', - ' ' => 'case_id', - ts('Location') => 'location', - ts('Duration') => 'duration', - ts('Details') => 'details', - ts('Assignee') => 'assignee', - ); - - $this->_groupId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_OptionGroup', - 'activity_status', - 'id', - 'name' - ); - - //Add custom fields to columns array for inclusion in export - require_once 'CRM/Core/BAO/CustomGroup.php'; - $groupTree = &CRM_Core_BAO_CustomGroup::getTree('Activity', $form, NULL, - NULL, '', NULL - ); - - - //use simplified formatted groupTree - $groupTree = CRM_Core_BAO_CustomGroup::formatGroupTree($groupTree, 1, $form); - - //cycle through custom fields and assign to _columns array - foreach ($groupTree as $key) { - foreach ($key['fields'] as $field) { - $fieldlabel = $key['title'] . ": " . $field['label']; - $this->_columns[$fieldlabel] = $field['column_name']; - } - } - //end custom fields - } - - /** - * @param CRM_Core_Form $form - */ - function buildForm(&$form) { - - /** - * You can define a custom title for the search form - */ - $this->setTitle('Find Latest Activities'); - - /** - * Define the search form fields here - */ - // Allow user to choose which type of contact to limit search on - $form->add('select', 'contact_type', ts('Find...'), CRM_Core_SelectValues::contactType()); - - // Text box for Activity Subject - $form->add('text', - 'activity_subject', - ts('Activity Subject') - ); - - // Select box for Activity Type - $activityType = array('' => ' - select activity - ') + CRM_Core_PseudoConstant::activityType(); - - $form->add('select', 'activity_type_id', ts('Activity Type'), - $activityType, - FALSE - ); - - // textbox for Activity Status - $activityStatus = array('' => ' - select status - ') + CRM_Core_PseudoConstant::activityStatus(); - - $form->add('select', 'activity_status_id', ts('Activity Status'), - $activityStatus, - FALSE - ); - - // Activity Date range - $form->addDate('start_date', ts('Activity Date From'), FALSE, array('formatType' => 'custom')); - $form->addDate('end_date', ts('...through'), FALSE, array('formatType' => 'custom')); - - - // Contact Name field - $form->add('text', 'sort_name', ts('Contact Name')); - - /** - * If you are using the sample template, this array tells the template fields to render - * for the search form. - */ - $form->assign('elements', array('contact_type', 'activity_subject', 'activity_type_id', - 'activity_status_id', 'start_date', 'end_date', 'sort_name', - )); - } - - /** - * Define the smarty template used to layout the search form and results listings. - */ - function templateFile() { - return 'ActivitySearch.tpl'; - } - - /** - * Construct the search query - * @param int $offset - * @param int $rowcount - * @param null $sort - * @param bool $includeContactIDs - * @param bool $onlyIDs - * @return string - */ - function all($offset = 0, $rowcount = 0, $sort = NULL, - $includeContactIDs = FALSE, $onlyIDs = FALSE - ) { - - // SELECT clause must include contact_id as an alias for civicrm_contact.id - if ($onlyIDs) { - $select = 'contact_a.id as contact_id'; - } - else { - $select = ' - contact_a.id as contact_id, - contact_a.sort_name as sort_name, - contact_a.contact_type as contact_type, - activity.id as activity_id, - activity.activity_type_id as activity_type_id, - contact_b.sort_name as source_contact, - ov1.label as activity_type, - activity.subject as activity_subject, - activity.activity_date_time as activity_date, - ov2.label as activity_status, - cca.case_id as case_id, - activity.location as location, - activity.duration as duration, - activity.details as details, - assignment.activity_id as assignment_activity, - contact_c.display_name as assignee - '; - } - - $from = $this->from(); - - $where = $this->where($includeContactIDs); - - if (!empty($where)) { - $where = "WHERE $where"; - } - - // add custom group fields to SELECT and FROM clause - require_once 'CRM/Core/BAO/CustomGroup.php'; - $groupTree = &CRM_Core_BAO_CustomGroup::getTree('Activity', $form, NULL, NULL, '', NULL); - - foreach ($groupTree as $key) { - if ($key['extends'] == 'Activity') { - $select .= ", " . $key['table_name'] . ".*"; - $from .= " LEFT JOIN " . $key['table_name'] . " ON " . $key['table_name'] . ".entity_id = activity.id"; - } - } - // end custom groups add - - $sql = " SELECT $select FROM $from $where "; - - //no need to add order when only contact Ids. - if (!$onlyIDs) { - // Define ORDER BY for query in $sort, with default value - if (!empty($sort)) { - if (is_string($sort)) { - $sql .= " ORDER BY $sort "; - } - else { - $sql .= ' ORDER BY ' . trim($sort->orderBy()); - } - } - else { - $sql .= 'ORDER BY contact_a.sort_name, activity.activity_date_time DESC, activity.activity_type_id, activity.status_id, activity.subject'; - } - } - - if ($rowcount > 0 && $offset >= 0) { - $sql .= " LIMIT $offset, $rowcount "; - } - return $sql; - } - - // Alters the date display in the Activity Date Column. We do this after we already have - // the result so that sorting on the date column stays pertinent to the numeric date value - /** - * @param $row - */ - function alterRow(&$row) { - $row['activity_date'] = CRM_Utils_Date::customFormat($row['activity_date'], '%B %E%f, %Y %l:%M %P'); - } - - // Regular JOIN statements here to limit results to contacts who have activities. - /** - * @return string - */ - function from() { - return " - civicrm_contact contact_a - JOIN civicrm_activity activity - ON contact_a.id = activity.source_contact_id - JOIN civicrm_option_value ov1 - ON activity.activity_type_id = ov1.value AND ov1.option_group_id = 2 - JOIN civicrm_option_value ov2 - ON activity.status_id = ov2.value AND ov2.option_group_id = {$this->_groupId} - JOIN civicrm_contact contact_b - ON activity.source_contact_id = contact_b.id - LEFT JOIN civicrm_case_activity cca - ON activity.id = cca.activity_id - LEFT JOIN civicrm_activity_assignment assignment - ON activity.id = assignment.activity_id - LEFT JOIN civicrm_contact contact_c - ON assignment.assignee_contact_id = contact_c.id "; - } - - /** - * WHERE clause is an array built from any required JOINS plus conditional filters based on search criteria field values - * - * @param bool $includeContactIDs - * - * @return string - */ - function where($includeContactIDs = FALSE) { - $clauses = array(); - - // add contact name search; search on primary name, source contact, assignee - $contactname = $this->_formValues['sort_name']; - if (!empty($contactname)) { - $dao = new CRM_Core_DAO(); - $contactname = $dao->escape($contactname); - $clauses[] = "(contact_a.sort_name LIKE '%{$contactname}%' OR - contact_b.sort_name LIKE '%{$contactname}%' OR - contact_c.display_name LIKE '%{$contactname}%')"; - } - - $subject = $this->_formValues['activity_subject']; - - if (!empty($this->_formValues['contact_type'])) { - $clauses[] = "contact_a.contact_type LIKE '%{$this->_formValues['contact_type']}%'"; - } - - if (!empty($subject)) { - $dao = new CRM_Core_DAO(); - $subject = $dao->escape($subject); - $clauses[] = "activity.subject LIKE '%{$subject}%'"; - } - - if (!empty($this->_formValues['activity_status_id'])) { - $clauses[] = "activity.status_id = {$this->_formValues['activity_status_id']}"; - } - - if (!empty($this->_formValues['activity_type_id'])) { - $clauses[] = "activity.activity_type_id = {$this->_formValues['activity_type_id']}"; - } - - $startDate = $this->_formValues['start_date']; - if (!empty($startDate)) { - $startDate .= '00:00:00'; - $startDateFormatted = CRM_Utils_Date::processDate($startDate); - if ($startDateFormatted) { - $clauses[] = "activity.activity_date_time >= $startDateFormatted"; - } - } - - $endDate = $this->_formValues['end_date']; - if (!empty($endDate)) { - $endDate .= '23:59:59'; - $endDateFormatted = CRM_Utils_Date::processDate($endDate); - if ($endDateFormatted) { - $clauses[] = "activity.activity_date_time <= $endDateFormatted"; - } - } - - if ($includeContactIDs) { - $contactIDs = array(); - foreach ($this->_formValues as $id => $value) { - if ($value && - substr($id, 0, CRM_Core_Form::CB_PREFIX_LEN) == CRM_Core_Form::CB_PREFIX - ) { - $contactIDs[] = substr($id, CRM_Core_Form::CB_PREFIX_LEN); - } - } - - if (!empty($contactIDs)) { - $contactIDs = implode(', ', $contactIDs); - $clauses[] = "contact_a.id IN ( $contactIDs )"; - } - } - - return implode(' AND ', $clauses); - } - - /* - * Functions below generally don't need to be modified - */ - - /** - * @return mixed - */ - function count() { - $sql = $this->all(); - - $dao = CRM_Core_DAO::executeQuery($sql); - return $dao->N; - } - - /** - * @param int $offset - * @param int $rowcount - * @param null $sort - * - * @return string - */ - function contactIDs($offset = 0, $rowcount = 0, $sort = NULL) { - return $this->all($offset, $rowcount, $sort, FALSE, TRUE); - } - - /** - * @return array - */ - function &columns() { - return $this->_columns; - } - - /** - * @param $title - */ - function setTitle($title) { - if ($title) { - CRM_Utils_System::setTitle($title); - } - else { - CRM_Utils_System::setTitle(ts('Search')); - } - } - - /** - * @return null - */ - function summary() { - return NULL; - } -} - diff --git a/tools/extensions/org.civicrm.search.activity/info.xml b/tools/extensions/org.civicrm.search.activity/info.xml deleted file mode 100644 index bc3c559aa3..0000000000 --- a/tools/extensions/org.civicrm.search.activity/info.xml +++ /dev/null @@ -1,22 +0,0 @@ - - - http://svn.civicrm.org/tools/branches/v3.3/extensions/org.civicrm.search.activity.zip - ActivitySearch - Activity Search - This custom search allows to search through activities and returns activities as results (not contacts as regular search). - - http://civicrm.org - http://forum.civicrm.org - http://civicrm.org/licensing - - AGPL - - CiviCRM LLC - info@civicrm.org - - 2010-09-01 - 1.2 - beta - 3.33.4 - For support, please contact project team on the forums. (http://forum.civicrm.org) - diff --git a/tools/extensions/org.civicrm.search.activity/templates/ActivitySearch.tpl b/tools/extensions/org.civicrm.search.activity/templates/ActivitySearch.tpl deleted file mode 100644 index 80c049c85b..0000000000 --- a/tools/extensions/org.civicrm.search.activity/templates/ActivitySearch.tpl +++ /dev/null @@ -1,142 +0,0 @@ -{* - +--------------------------------------------------------------------+ - | CiviCRM version 4.7 | - +--------------------------------------------------------------------+ - | Copyright CiviCRM LLC (c) 2004-2015 | - +--------------------------------------------------------------------+ - | This file is a part of CiviCRM. | - | | - | CiviCRM is free software; you can copy, modify, and distribute it | - | under the terms of the GNU Affero General Public License | - | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | - | | - | CiviCRM is distributed in the hope that it will be useful, but | - | WITHOUT ANY WARRANTY; without even the implied warranty of | - | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | - | See the GNU Affero General Public License for more details. | - | | - | You should have received a copy of the GNU Affero General Public | - | License and the CiviCRM Licensing Exception along | - | with this program; if not, contact CiviCRM LLC | - | at info[AT]civicrm[DOT]org. If you have questions about the | - | GNU Affero General Public License or the licensing of CiviCRM, | - | see the CiviCRM license FAQ at http://civicrm.org/licensing | - +--------------------------------------------------------------------+ -*} -{* Template for "Sample" custom search component. *} -
-
-
-
- {ts}Edit Search Criteria{/ts} -
-
-
-
{include file="CRM/common/formButtons.tpl" location="top"}
- - {* Loop through all defined search criteria fields (defined in the buildForm() function). *} - {foreach from=$elements item=element} - - - - - {/foreach} -
{$form.$element.label} - {if $element eq 'start_date' OR $element eq 'end_date'} - {include file="CRM/common/jcalendar.tpl" elementName=$element} - {else} - {$form.$element.html} - {/if} -
-
{include file="CRM/common/formButtons.tpl" location="bottom"}
- -
-
-
-
- -{if $rowsEmpty || $rows} - -
- {if $rowsEmpty} -
- {include file="CRM/Contact/Form/Search/Custom/EmptyResults.tpl"} -
-{/if} - -{if $rows} -
- {* Search request has returned 1 or more matching rows. Display results and collapse the search criteria fieldset. *} - - {* This section handles form elements for action task select and submit *} -
- {include file="CRM/Contact/Form/Search/ResultTasks.tpl"} -
- {* This section displays the rows along and includes the paging controls *} -
- - {include file="CRM/common/pager.tpl" location="top"} - - {include file="CRM/common/pagerAToZ.tpl"} - - {strip} - - - - {foreach from=$columnHeaders item=header} - {if ($header.sort eq 'activity_id') or ($header.sort eq 'activity_type_id') or ($header.sort eq 'case_id') } - {elseif ($header.sort eq 'sort_name') or ($header.sort eq 'activity_status') or ($header.sort eq 'activity_type') or ($header.sort eq 'activity_subject') or ($header.sort eq 'source_contact') or ($header.SORT eq 'activity_date') or ($header.name eq null) } - - {/if} - - {/foreach} - - - - {counter start=0 skip=1 print=false} - {foreach from=$rows item=row} - - {assign var=cbName value=$row.checkbox} - - {foreach from=$columnHeaders item=header} - {if ($header.sort eq 'sort_name') or ($header.sort eq 'activity_status') or ($header.sort eq 'activity_type') or ($header.sort eq 'activity_subject') or ($header.sort eq 'source_contact') or ($header.SORT eq 'activity_date') or ($header.name eq null) } - {assign var=fName value=$header.sort} - {if $fName eq 'sort_name'} - - {elseif $fName eq 'activity_subject'} - - {elseif ($fName eq 'activity_id') or ($fName eq 'activity_type_id') or ($fName eq 'case_id')} - {else} - - {/if} - {/if} - {/foreach} - - - {/foreach} -
{$form.toggleSelect.html} - {if $header.sort} - {assign var='key' value=$header.sort} - {$sort->_response.$key.link} - {else} - {$header.name} - {/if} -  
{$form.$cbName.html}{$row.sort_name} - {if $row.case_id } - - {else} - - {/if} - {if isset($row.activity_subject) AND $row.activity_subject NEQ 'NULL'}{$row.activity_subject}{else}{ts}(no subject){/ts}{/if} - {$row.$fName}{$row.action}
- {/strip} - -{include file="CRM/common/pager.tpl" location="bottom"} - - -
- {* END Actions/Results section *} -
-{/if} -
-{/if} diff --git a/tools/extensions/org.civicrm.search.basic.zip b/tools/extensions/org.civicrm.search.basic.zip deleted file mode 100644 index 7153a34ff43e6f247c8a288acc1ee2229e4a5dee..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 2751 zcmaKuc{G&!AIBfYn#tH1Nh)K>R>(GtC0r>X<{DI(sRlJ;8C=RTLPEAF6qB_@_r^q_ z!N@lDC5>&Ek|EPv@rz_lesu3S_jgXe+w(oo_k6$qyxz}q&gY!>%jpD&Zx^uhl-3&} zz90VHpnw7p5RBEv_=Wjlf^ph}3qHXZUv0Dx!4IQ@bQK0b{k4HqzOAogwED+qLR z6u%elE(j(Je#onTMh7J60H5ybWxsIt5Rs>eEt-T z+g>2^*`{P5W`LNJ=rtL^BQW+v(H}4q*uv>-7spqTj*#g&nI6P6f3`e ziyIz7K#&`UdZ+(fTo2JJ)$BXUIjW;(EnVTNz>B|gBZPA8bJf?#l!1o>vd#dZdb;pM zKV8DC=`w)W=P0ULQ)~MKNKr1Y89!zi2ZYawz_7`5RV6FC``lu)B%kQ2!jIE7MVax7 zc%#h^CG`|`-ETRJ^wYgp4vXSQ?hOSl<(+DpyH=#c&tHXd)~=G=*KPO*LfyILLC@<} zSgRfP5PQDaSNEm5gV&?5{*c~}6rPdg$Ol(eiyh|#Hz1o${US3lXuapS#isI2&LzXn zqwSV@aTZ2&^G8-ejw*;mnS5?~ zU!z$xCtoFDZ8DE60E>d?H@`vpK?Qw5J+_e|xv1FL@|xezt* zr?bweEAZYHufMGTQ#b9tYo54V;)<5fl`6I_f$mBxqmWxXk*o{X_BjtNc(hNXlZ-VK z)v`V%&c%;Y3AO1}A^VS)l(vOlj|o=)J#%T#wVhjH?r5e0(2hYX|J?{z@Fk*Uz^ z(|mNr&rzCMzV}h+=(@S+s+k-Og1SX+x$CJ4d$t2ZYeG)pRsDYcNpJ6{fw!gIZ?M~aPdf~mZWtLnr6*jUY2rc-75g|w0o_bVR?kO^h(&oka%yqp?KH53T5Ep;P1Ak@{AyWeEHiE{?7BNTGG` zhM3jbdPrsc{tGS!c?*pa&Aq!#1YQbhW}-(~@?d4#(%H=Cb&4o>mLL7zYmXj@o2Yp< z7&2{nMt}(}XUl8ybiJA5Vjk7_YXseUtZS;!(1{?jo(B#-Fo(+m(N0f1jW0K1RO#zV zEn*`4Z5;7l*~KQ&4E%9rUw!5gjDApK>T6=%^q!X`nqgBd(FSl0dl{p-tEmQfV#MX) zmzF{1(vYz&r0RA1w$Sp9gH6t@foNtl6GA9|Dm%F3H@y4fU9i*x1O4oC)iq0rtR51I z+7NJ~sxXSxv^9=1RCrlfVMk875fIwe_n(cLrQWxCDWyoItv9QJ|J33!kP(7tY>2An z0RY@~YwrJ9E&Aav255)lE`M)DQL3p!_lqAIH{rBH!1!S>jpHVUz*(SSv!dfle~ed# z=18e!FAJ(2!d%LN9V>n|GvP=wf90(acG!Z}zG8Q4dZfQBR&u@YURkmORU0S^P9Gaa zE(FFrTX$-#LILeqtGvp0!u`m}$g_u{UU$`8u;3zH6wkl<9WeO~B@O!38uqEgK&?R~ z`<7yaReU7{f%aXST19C|XHmSJCb!A7CwELf(1g|Htn5ONEPLGKhG`<)9kXA)cwQ32 z&}5%6N+G>$-DsF4KXMNYX$a`v>I(CC5M2Gu4R%o_OopRW(a07_nqN!wYO!4vqS4s z{8fgamhSg5(8s&O)@u%1xW^xPQr6zTQx?)NK2M`9I%;@t;mQhvxg%a3v_M5 zFQF;f*IooEHb2dSg-~nOTuuHH?PCJHt<{?95|^{C}y~4;r?E|2Gl)3%@;p!2MX4pW**U%eHfNwCpE2 pKTh^PImB3h!JqubKXbkvvoq&E#PDxhBmjW6m-hB|UlrcD{TH=o$4USI diff --git a/tools/extensions/org.civicrm.search.basic/Basic.php b/tools/extensions/org.civicrm.search.basic/Basic.php deleted file mode 100644 index 2374c83fd0..0000000000 --- a/tools/extensions/org.civicrm.search.basic/Basic.php +++ /dev/null @@ -1,181 +0,0 @@ -normalize(); - $this->_columns = array( - '' => 'contact_type', - '' => 'contact_sub_type', - ts('Name') => 'sort_name', - ts('Address') => 'street_address', - ts('City') => 'city', - ts('State') => 'state_province', - ts('Postal') => 'postal_code', - ts('Country') => 'country', - ts('Email') => 'email', - ts('Phone') => 'phone', - ); - - $params = &CRM_Contact_BAO_Query::convertFormValues($this->_formValues); - $returnProperties = array(); - foreach ($this->_columns as $name => $field) { - $returnProperties[$field] = 1; - } - - $this->_query = new CRM_Contact_BAO_Query($params, $returnProperties, NULL, - FALSE, FALSE, 1, FALSE, FALSE - ); - } - - /** - * normalize the form values to make it look similar to the advanced form values - * this prevents a ton of work downstream and allows us to use the same code for - * multiple purposes (queries, save/edit etc) - * - * @return void - * @access private - */ - function normalize() { - $contactType = CRM_Utils_Array::value('contact_type', $this->_formValues); - if ($contactType && !is_array($contactType)) { - unset($this->_formValues['contact_type']); - $this->_formValues['contact_type'][$contactType] = 1; - } - - $group = CRM_Utils_Array::value('group', $this->_formValues); - if ($group && !is_array($group)) { - unset($this->_formValues['group']); - $this->_formValues['group'][$group] = 1; - } - - $tag = CRM_Utils_Array::value('tag', $this->_formValues); - if ($tag && !is_array($tag)) { - unset($this->_formValues['tag']); - $this->_formValues['tag'][$tag] = 1; - } - - return; - } - - /** - * @param CRM_Core_Form $form - */ - function buildForm(&$form) { - - //@todo FIXME - using the CRM_Core_DAO::VALUE_SEPARATOR creates invalid html - if you can find the form - // this is loaded onto then replace with something like '__' & test - $separator = CRM_Core_DAO::VALUE_SEPARATOR; - $contactTypes = array('' => ts('- any contact type -')) + CRM_Contact_BAO_ContactType::getSelectElements(FALSE, TRUE, $separator); - $form->add('select', 'contact_type', ts('Find...'), $contactTypes); - - // add select for groups - $group = array('' => ts('- any group -')) + CRM_Core_PseudoConstant::group(); - $form->addElement('select', 'group', ts('in'), $group); - - // add select for categories - $tag = array('' => ts('- any tag -')) + CRM_Core_PseudoConstant::get('CRM_Core_DAO_EntityTag', 'tag_id', array('onlyActive' => FALSE)); - $form->addElement('select', 'tag', ts('Tagged'), $tag); - - // text for sort_name - $form->add('text', 'sort_name', ts('Name')); - - $form->assign('elements', array('sort_name', 'contact_type', 'group', 'tag')); - } - - /** - * @return CRM_Contact_DAO_Contact - */ - function count() { - return $this->_query->searchQuery(0, 0, NULL, TRUE); - } - - /** - * @param int $offset - * @param int $rowCount - * @param null $sort - * @param bool $includeContactIDs - * - * @return CRM_Contact_DAO_Contact - */ - function all($offset = 0, $rowCount = 0, $sort = NULL, - $includeContactIDs = FALSE - ) { - return $this->_query->searchQuery($offset, $rowCount, $sort, - FALSE, $includeContactIDs, - FALSE, FALSE, TRUE - ); - } - - /** - * @return string - */ - function from() { - return $this->_query->_fromClause; - } - - /** - * @param bool $includeContactIDs - * - * @return string - */ - function where($includeContactIDs = FALSE) { - if ($whereClause = $this->_query->whereClause()) { - return $whereClause; - } - return ' (1) '; - } - - /** - * @return string - */ - function templateFile() { - return 'CRM/Contact/Form/Search/Basic.tpl'; - } -} - diff --git a/tools/extensions/org.civicrm.search.basic/info.xml b/tools/extensions/org.civicrm.search.basic/info.xml deleted file mode 100644 index 950c9cc665..0000000000 --- a/tools/extensions/org.civicrm.search.basic/info.xml +++ /dev/null @@ -1,21 +0,0 @@ - - - Basic - Basic Search - This custom search allows to search contacts through basic criteria like contact type, groups, tags. - - http://civicrm.org - http://forum.civicrm.org - http://civicrm.org/licensing - - AGPL - - CiviCRM LLC - info@civicrm.org - - 2010-09-01 - 1.0 - beta - 3.33.4 - For support, please contact project team on the forums. (http://forum.civicrm.org) - diff --git a/tools/extensions/org.civicrm.search.multivalue.zip b/tools/extensions/org.civicrm.search.multivalue.zip deleted file mode 100644 index 79bf594c9c1ca0fa3db0e2f33522098e6dd1dc2d..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 6321 zcmb7|WmFtn)`pwlkl+M|hTxtAXdr0g?(P<7+?@n>CpbX@!8N$MCO8Dw#@&N9Uvg*G zx_7?0Gg(t-)mf+hoM-P{t4_W9Rg{58Km+``3R^$|e=PnvkpoBpc8=z(CJuhFY zZ*Amk=JZn*{{`m?j1Qc>f22+^=-(tu|=_nCfINkRgJc7?pW0<6MaoH7BcGV}?ICKe~h7a6hPD)Zjki?N{g z9hy1^qcDRcd7&584$(IcByy<^5u|i1r!2(lWNLwHS;kJ<)GoQgMTMkmRbMm)dPd`- zA9)nZ21{T;l)}}MOj^}gl=5n+9=--sayjayo^z)-kR0~|NcWT|if)H6;8LNw&Q)7{ zqQP(wZ=~ImL(O6aMslNNvw)mLNKL8W&`qh77V7m}j6Ek-ir7>M*M4hgl#L)4Gs{+D zto`XcFtzeu*NQ6{$Y?fl_w`qe5^g!;Uub)JbGF6AsNjECn4+KrK-0OY7El zqdP2ejy5i0ASCu1J<6UEmk4dBR7d|g!w;40dSC=TI%2DSsj-1ee^T^<&U+v&#U}p#w7SE#tTkhsBGo({e-5-=LrfuP{_P^%F)mo+UV=)Zs=y`I-xjT zLMDAWWaL>V-JWloOdtW(w!;u^S|OLk3o4p)TJ{&8_6@%;wud#iZLd0g7%!i! z6hCeVB^l{Eh`p(Cz0$n12=Vd3nS>5g8{cH(djp@Gegw5tNgyyT&s@Hud!0dY&E;b+<(6SbepzOA zym?oyU1*-nR&-^cfkdjcf|lZwZr$D<%a=6{?A!SBOpQH5iNNNqrLJB$^b~-HrVEgikmKZ&j>5c_2Rw+t+%2Q&9cd*J3uT zbBcm`!vU!+m0YDJj3g9- zQT=bY8t0FF@>V4rjsOv1j=b_*_dRBt=c>udrvAJIo_tjPh?vmG0wUD7DL3`1YT8d| zM`0f0@w$Z$VB@B>?@fI*1J$>R3pHQoY+mbbIraAzy*aFZDuQp-Jbc4V^_T_&(D4Ih=m9E0!75;ZfY8EZW9h$#SCYGl?F zFqc+^xKlHo^bk(OY<#V~RnNlI3D^?b3}nHGXk~L_*0&`-RrW6cVeuW=hG05t?DB5i z5i&T}-IOD)4)gN`1iN`p@mAAZ`y|}8!S?wON&?+9%dK%?YtuHb3thIh(w7cD_uW># z2v%tNegRv41zO`KB}g2(0=i8HhI3hr0OOfPp{m1&0&bLx_osJYZOc-;m}mQ`tJjdlh98U=$03B(n_hI*UX#+iu8{u z^lVdTiVJmXED7|pTilaC4($b~lBhDI*Nk%h>@5PKgjwUfLB|~V{sFs};voL>=0I>N zwYHaKP*%PAqR+a-)Q1(q%9FlAkj=}wC?dQ#H!-R2>2+FaWu0DqbA7IXN8#7s{m)qD zCa_9wMk`o6AG}}QvC^oJQRx8@V@&bY=nl#F5MCb$ikvH|0A_^w6(ujV>M|pN z9u15d3i8nC5t5r!5C0Gm{(@-|6O*WPs0`D z@b>PWDlgu#rVdqjzoHYdXh&4c2N*ouB!1uD>4k*Bc5xgH2Ln-L8^o6 zd0&SfJLZ;%)Mg3;kJ@g(GXHjOmYbiv&C;TEaWSv2AJqzK1gAx;rYC~;mU5(vWcrma z$+Z`Fhjpqi>GB_Gm$T8_Ds*enW>d!5#^`H3q1bbuf(#uvb+b(y$n?SUHXH4M4IV;^ zM7cknT~D~25GqddKa6w_JhWj~uedN<1HWD-Uv;TVr2E0HAyubi(TC&|D1oP%UY6vO zMw`5Km(!)y&`;HeZZa7xi!Jb_`I1v;MNc?qf)vIph8_aGg_60{l`C(#H3DUS=rPE-PK(qiQ#@yzPRmVo(AxSRvKv-fUK?c!XNw@{*`JxtJQBY9SpB|KZflTx zy@#SYu*ku|wUF->hJL0Rmrdv6WuH#rFq({QQyH(5^hm`rc;$rB$)zeDtN$}#F~nR> zf?+T=K5$vY0Ogfn*K@^4w)3*R!OvI=DZ0`7gNX9{n)h`6*m1nd)N+XZ#>MXuIA-dU zTT91n49LpHIGL=V#P}nR2)`uIp8`er-42WLPo+gd4*)R#R-pVLOa9O#to9c6|4ot% z|B@sP*syW~ze)Q1i~(iunN<1BJ#Dc%+}h~PAxGO+#LtjvDZ`$L(F5sqT<%wz(S6sO z4IFJfNn>c@JB$r7eO%!lF75U=o7DGP%Hu%DZ1$~1adxJwHZ7gkFXq^>J^6s`HSZ}$ zTiRL+1-x7FmyH?R(msBCCOJ7rC)nCHE)JceXqr0rw89k6B(USw`&=J7$WxX5}qCnixa|vc>*_ZUko)`#w zl8j1~94SewPB|Y4Iv%Z%d@o?`pYVg((EoOWs_BY9B*Oy(9h@|?trD63oaY{$XPcz1 z38@pSRIsF0X@@mlI*@>QV6d$FJI+?^V+c&@n`;;Wyv#Gi1t=8y z0x;PdA8p;aGQ4SZV<*=(?l;cjGot(Q6j*PegZB0=-zgFzN=|!s&ZsdNX}065=#VTh zWJ((hd(7fJ-_4E;crXaQN2&>0MPH$jX)+RJ5Ah&5K~MvDlPZYImtNvlf(u92+H@%* zpQ89yRv;RnH1Sd`XCUa-31tZ>)5*{$x>9oZ^JHDoy+-bPW6a4R_NeNtE!AiKkzlXsgX7Ynb7ZlNVs!$F z?1cxVfcH}88T=*k6zL?j%h&4>OKdB` z1}s|8CxPXt9)G0e_w;FDKPb3kPvY;&)$9(F9!9JR<{aKn9daE2&mP7v+dF64bvVK; z;{v)PWlWB_7h}{rkoo;<4Hu|iS@)3xMP}whs#*=g%ytH@boWuwJ_pIxSs@uufT;yM zKczS|8B3%4utwe2-*XtQkQ08(7r@Ys`4GMSzA@>?7(%43gU}CyVhc&n0HLZf6300z{S)n zyuNmf%_FxEf!_0DUgPboQW=o+3aZA_j##r($54cDMTEjhxAF?qPv*T}BKntCFk?WktF zvFWs9LCw;UPJxmVPdsC$M!-1Yi5`*?o>UDqbV%=$&eLhkti^J_tg@%Cp;Y0he$F%; zApDIiB*!@Eb8=Cx6EJcPHjr1@Bb)M< z_~sqsL}u=YH$i$`g{%}6(qBd;f1K9IZ=QcinIF#S)iM?`ZYkEwrL&2c5Qp+%AouL5 zBg7YU?TwKG2=_uqM}G$eFhX^{0k4Z|7*RdD(MbgzQwJ%RD2Dx9waS;Uz6C{-e0h3r zy(7{O$5j9@Fla?H#&HNl_Ck-@($1#?=_A3XwsxJr#_>?t%p8wVe@ox1Qk8KeNJU~m zg}qOU{Uc+{$;(Y_MJ~#VlMXYcYTw<@1z*~@C7opW%Vyx%m=fVNo~zU>=JfhiRvkZx zhR{FmfE5Mux$iUR>8^u&7I}RMiTLtSn_5Z1eynSx`fd?_(8hiQn z<79c&!L($Ko9(V>jMRSNjtUIedFIKnIgxP&*Xibcx zKZ1>-kmXUyt)#zJd`U~{j?}*^$n12~3c!`F+R7oCr~1xhZSUFos@|04iD*lciovk~ zKcNmZqv*=g5{k#>!4O2iTzVhf%k5oU-$Wzp&2_(x3P<)~k&kA#z-~G3G`>f44Q@kQ z&QbEJ%)9vT)*bgeK9_(6&SIGA;oRgpOSsH)N_s2VGH#QHMiEzcGSu$Sx7Gl|Y6tDR zK;pqvz@ds(ZvBEX#J6U1zJ5py&YZlOCuq&nqNstnDWdg74UfsYfH#uBl}KMIhTd(_ zoB3J>^36SWMjXJVeRllN3_8J9T(wD#oBJx= za{)XSd737BKXr%&o0?IV-GiiK2$Z4G6nU!(EU$&Jd%--@`#GLiZ>p}layn%g4tFd< z+tf}Wu^!T@nPNU&z?t~kGx51OW)y*Ju}P#taQ#F(JSkMF|46ra7tyiZQP@6dKgf5{ z#&ICc;3kuOgW|A2diclHkQy7$Ua{&{(T8;4`5V5L2$#*2Ig@@9NDLqPXuh4tb+{jY z2g~l8TAJw%hgfh!^B`Zb=ns(_$SD6t7_Cu#Fl#mNZc4D3w~Fo8Ums@5Vap$SfwM}O z4@qM3vxXln5oyRxh0t1_+*tTd-6I3BW{{oDm}-?_d93)`=18{;iqY^Nqp2GM%UJhy zQQA&p4P9H3-k*jizrxY9rC?j+QIt<_#U{r;{{j{535%t;7b3VF0g78|o zL#1DGbOg&-tE`4)-BT*5pvG_-NX)8o%3(6p5%SGqX+sbXdKQm)ZaSQv#TKT&Gxo@N z7Bso=VWum&*JQqs0)4P6j0VP5lXKe-*ukBSL4}lr(;4@!HGjv0Sw15Esaq?48f$(@ zkSEu0001@u06_a&-3qaNYsczt^A8iP=8q(;tgoBM<(Ity4I)h9Ac)Q-{yBf`uGf35s>! zcJ1yC4;L)#@`<=P`=hkDD~{unt<`+1VR2&B?zH*%#xP04V@Z-to0eoCR**>ZEm>@k zz3A1gmelZ7jQYfo*Ex~NOmWe)Adt+QxI2j!uIJj+tPKC4joD{jMMPvG;2{4zi#oSYEQWSR< zW-F1^!CZJg>g=6z$=hNl(&za|n_5$Z-I={gx*QQ!E+|q=818HtaR-4BS?SX;#tu=( zwX8I{`1mKew)bk--ePmJqBnJWbuYzr1oy~lZ1(Qk2g?y-#EQ?#ZYxR0UUHKucS|Ba zdGLI!q;+o)%fmQ4UxQ!RujA%hPPyWC5n1AK#p#H9+|G(q> uJ@Ma9hrbeWe}?tn-{GHU#ZT6+v*O>fLqz&nHUQ$!!TtmQuzLRM>Hh%x7h^>L diff --git a/tools/extensions/org.civicrm.search.multivalue/MultiValue.php b/tools/extensions/org.civicrm.search.multivalue/MultiValue.php deleted file mode 100644 index 97e79cc51a..0000000000 --- a/tools/extensions/org.civicrm.search.multivalue/MultiValue.php +++ /dev/null @@ -1,293 +0,0 @@ -_groupTree = CRM_Core_BAO_CustomGroup::getTree("'Contact', 'Individual', 'Organization', 'Household'", - CRM_Core_DAO::$_nullObject, - NULL, -1 - ); - - $this->_columns = array(ts('Contact ID') => 'contact_id', - ts('Contact Type') => 'contact_type', - ts('Name') => 'sort_name', - ); - - $this->_customGroupIDs = CRM_Utils_Array::value('custom_group', $formValues); - - if (!empty($this->_customGroupIDs)) { - $this->addColumns(); - } - } - - function addColumns() { - // add all the fields for chosen groups - $this->_tables = $this->_options = array(); - foreach ($this->_groupTree as $groupID => $group) { - if (empty($this->_customGroupIDs[$groupID])) { - continue; - } - - // now handle all the fields - foreach ($group['fields'] as $fieldID => $field) { - $this->_columns[$field['label']] = "custom_{$field['id']}"; - if (!array_key_exists($group['table_name'], $this->_tables)) { - $this->_tables[$group['table_name']] = array(); - } - $this->_tables[$group['table_name']][$field['id']] = $field['column_name']; - - // also build the option array - $this->_options[$field['id']] = array(); - CRM_Core_BAO_CustomField::buildOption($field, - $this->_options[$field['id']] - ); - } - } - } - - /** - * @param CRM_Core_Form $form - */ - function buildForm(&$form) { - - /** - * You can define a custom title for the search form - */ - $this->setTitle('Multiple Value Custom Group Search and Export'); - - $form->add('text', - 'sort_name', - ts('Contact Name'), - TRUE - ); - if (empty($this->_groupTree)) { - CRM_Core_Error::statusBounce(ts("At least one Custom Group must be present, for Custom Group search."), - CRM_Utils_System::url('civicrm/contact/search/custom/list', - 'reset=1' - ) - ); - } - // add the checkbox for custom_groups - foreach ($this->_groupTree as $groupID => $group) { - if ($groupID == 'info') { - continue; - } - $form->addElement('checkbox', "custom_group[$groupID]", NULL, $group['title']); - } - } - - /** - * @return null - */ - function summary() { - return NULL; - } - - /** - * @param int $offset - * @param int $rowcount - * @param null $sort - * @param bool $includeContactIDs - * - * @return mixed - */ - function all($offset = 0, $rowcount = 0, $sort = NULL, - $includeContactIDs = FALSE - ) { - //redirect if custom group not select in search criteria - if (empty($this->_formValues['custom_group'])) { - CRM_Core_Error::statusBounce(ts("You must select at least one Custom Group as a search criteria."), - CRM_Utils_System::url('civicrm/contact/search/custom', - "reset=1&csid={$this->_formValues['customSearchID']}", - FALSE, NULL, FALSE, TRUE - ) - ); - } - $selectClause = " -contact_a.id as contact_id , -contact_a.contact_type as contact_type, -contact_a.sort_name as sort_name, -"; - - $customClauses = array(); - foreach ($this->_tables as $tableName => $fields) { - foreach ($fields as $fieldID => $fieldName) { - $customClauses[] = "{$tableName}.{$fieldName} as custom_{$fieldID}"; - } - } - $selectClause .= implode(',', $customClauses); - - return $this->sql($selectClause, - $offset, $rowcount, $sort, - $includeContactIDs, NULL - ); - } - - /** - * @return string - */ - function from() { - $from = "FROM civicrm_contact contact_a"; - $customFrom = array(); - if (!empty($this->_tables)) { - foreach ($this->_tables as $tableName => $fields) { - $customFrom[] = " LEFT JOIN $tableName ON {$tableName}.entity_id = contact_a.id "; - } - return $from . implode(' ', $customFrom); - } - return $from; - } - - /** - * @param bool $includeContactIDs - * - * @return mixed - */ - function where($includeContactIDs = FALSE) { - $count = 1; - $clause = array(); - $params = array(); - $name = CRM_Utils_Array::value('sort_name', - $this->_formValues - ); - if ($name != NULL) { - if (strpos($name, '%') === FALSE) { - $name = "%{$name}%"; - } - $params[$count] = array($name, 'String'); - $clause[] = "contact_a.sort_name LIKE %{$count}"; - $count++; - } - - $where = '( 1 )'; - if (!empty($clause)) { - $where .= ' AND ' . implode(' AND ', $clause); - } - - return $this->whereClause($where, $params); - } - - /** - * @return string - */ - function templateFile() { - return 'MultipleValues.tpl'; - } - - /** - * @return array - */ - function setDefaultValues() { - return array(); - } - - /** - * @param $row - */ - function alterRow(&$row) { - foreach ($this->_options as $fieldID => $values) { - $customVal = $valueSeparatedArray = array(); - if (in_array($values['attributes']['html_type'], - array('Radio', 'Select', 'Autocomplete-Select') - )) { - if ($values['attributes']['data_type'] == 'ContactReference' && $row["custom_{$fieldID}"]) { - $row["custom_{$fieldID}"] = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Contact', (int)$row["custom_{$fieldID}"], 'display_name'); - } - elseif ($row["custom_{$fieldID}"] && - array_key_exists($row["custom_{$fieldID}"], - $values - ) - ) { - $row["custom_{$fieldID}"] = $values[$row["custom_{$fieldID}"]]; - } - } - elseif (in_array($values['attributes']['html_type'], - array('CheckBox', 'Multi-Select', 'AdvMulti-Select') - )) { - $valueSeparatedArray = array_filter(explode(CRM_Core_DAO::VALUE_SEPARATOR, $row["custom_{$fieldID}"])); - foreach ($valueSeparatedArray as $val) { - $customVal[] = $values[$val]; - } - $row["custom_{$fieldID}"] = implode(', ', $customVal); - } - elseif (in_array($values['attributes']['html_type'], - array('Multi-Select State/Province', 'Select State/Province') - )) { - $valueSeparatedArray = array_filter(explode(CRM_Core_DAO::VALUE_SEPARATOR, $row["custom_{$fieldID}"])); - $stateName = CRM_Core_PseudoConstant::stateProvince(); - foreach ($valueSeparatedArray as $val) { - $customVal[] = $stateName[$val]; - } - $row["custom_{$fieldID}"] = implode(', ', $customVal); - } - elseif (in_array($values['attributes']['html_type'], - array('Multi-Select Country', 'Select Country') - )) { - $valueSeparatedArray = array_filter(explode(CRM_Core_DAO::VALUE_SEPARATOR, $row["custom_{$fieldID}"])); - CRM_Core_PseudoConstant::populate($countryNames, 'CRM_Core_DAO_Country', - TRUE, 'name', 'is_active' - ); - foreach ($valueSeparatedArray as $val) { - $customVal[] = $countryNames[$val]; - } - $row["custom_{$fieldID}"] = implode(', ', $customVal); - } - } - } - - /** - * @param $title - */ - function setTitle($title) { - CRM_Utils_System::setTitle($title); - } -} - diff --git a/tools/extensions/org.civicrm.search.multivalue/info.xml b/tools/extensions/org.civicrm.search.multivalue/info.xml deleted file mode 100644 index a6f3099984..0000000000 --- a/tools/extensions/org.civicrm.search.multivalue/info.xml +++ /dev/null @@ -1,23 +0,0 @@ - - - http://svn.civicrm.org/tools/branches/v3.3/extensions/org.civicrm.search.multivalue.zip - MultiValue - Multiple Values Search - desc - - http://civicrm.org - http://wiki.civicrm.org/confluence/display/CRMDOC32/Google+Checkout+Configuration - http://forum.civicrm.org - http://civicrm.org/licensing - - AGPL - - CiviCRM LLC - info@civicrm.org - - 2010-09-01 - 1.1 - beta - 3.33.4 - For support, please contact project team on the forums. (http://forum.civicrm.org) - diff --git a/tools/extensions/org.civicrm.search.multivalue/templates/MultipleValues.tpl b/tools/extensions/org.civicrm.search.multivalue/templates/MultipleValues.tpl deleted file mode 100644 index c4e54c6c69..0000000000 --- a/tools/extensions/org.civicrm.search.multivalue/templates/MultipleValues.tpl +++ /dev/null @@ -1,142 +0,0 @@ -{* - +--------------------------------------------------------------------+ - | CiviCRM version 4.7 | - +--------------------------------------------------------------------+ - | Copyright CiviCRM LLC (c) 2004-2015 | - +--------------------------------------------------------------------+ - | This file is a part of CiviCRM. | - | | - | CiviCRM is free software; you can copy, modify, and distribute it | - | under the terms of the GNU Affero General Public License | - | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | - | | - | CiviCRM is distributed in the hope that it will be useful, but | - | WITHOUT ANY WARRANTY; without even the implied warranty of | - | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | - | See the GNU Affero General Public License for more details. | - | | - | You should have received a copy of the GNU Affero General Public | - | License and the CiviCRM Licensing Exception along | - | with this program; if not, contact CiviCRM LLC | - | at info[AT]civicrm[DOT]org. If you have questions about the | - | GNU Affero General Public License or the licensing of CiviCRM, | - | see the CiviCRM license FAQ at http://civicrm.org/licensing | - +--------------------------------------------------------------------+ -*} -{* Template for "Sample" custom search component. *} -{assign var="showBlock" value="'searchForm'"} -{assign var="hideBlock" value="'searchForm_show','searchForm_hide'"} - - - -
-
- {ts}close section{/ts}{ts}Search Criteria{/ts} -
{include file="CRM/common/formButtons.tpl" location="top"}
- - - - - - {* Choose regular or 'tall' listing-box class for Group select box based on # of groups. *} - {if $form.custom_group|@count GT 8} - {assign var="boxClass" value="listing-box-tall"} - {else} - {assign var="boxClass" value="listing-box"} - {/if} - - - - -
{$form.sort_name.html}
-
- {foreach from=$form.custom_group item="group_val"} -
- {$group_val.html} -
- {/foreach} -
-
-
{include file="CRM/common/formButtons.tpl" location="bottom"}
-
-
- -{if $rowsEmpty} - {include file="CRM/Contact/Form/Search/Custom/EmptyResults.tpl"} -{/if} - -{if $summary} - {$summary.summary}: {$summary.total} -{/if} - -{if $rows} - {* Search request has returned 1 or more matching rows. Display results and collapse the search criteria fieldset. *} - {assign var="showBlock" value="'searchForm_show'"} - {assign var="hideBlock" value="'searchForm'"} - -
- - {* This section handles form elements for action task select and submit *} - {include file="CRM/Contact/Form/Search/ResultTasks.tpl"} - - {* This section displays the rows along and includes the paging controls *} -

- - {include file="CRM/common/pager.tpl" location="top"} - - {include file="CRM/common/pagerAToZ.tpl"} - - {strip} - - - - {foreach from=$columnHeaders item=header} - - {/foreach} - - - - {counter start=0 skip=1 print=false} - {foreach from=$rows item=row} - - {assign var=cbName value=$row.checkbox} - - {foreach from=$columnHeaders item=header} - {assign var=fName value=$header.sort} - {if $fName eq 'sort_name'} - - {else} - - {/if} - {/foreach} - - - {/foreach} -
{$form.toggleSelect.html} - {if $header.sort} - {assign var='key' value=$header.sort} - {$sort->_response.$key.link} - {else} - {$header.name} - {/if} -  
{$form.$cbName.html}{$row.sort_name}{$row.$fName}{$row.action}
- {/strip} - - {include file="CRM/common/pager.tpl" location="bottom"} - -

-
- {* END Actions/Results section *} -{/if} - - - diff --git a/tools/sites/stats/graphs.php b/tools/sites/stats/graphs.php deleted file mode 100644 index 2f40f595f8..0000000000 --- a/tools/sites/stats/graphs.php +++ /dev/null @@ -1,121 +0,0 @@ -year == date('Y') and $row->month == date('m')) { - continue; - }$data[$row->month . '’' . substr($row->year, 2)][$row->compare] = $row->data; - $compares[] = $row->compare; - } - $compares = array_unique($compares); - sort($compares); - - $keys = array_keys($data); - $key = $keys[count($data) - 1]; - $recent = array_pop($data); - $data = array_merge($data, array($key => $recent)); - - foreach ($data as $label => $values) { - foreach ($values as $compare => $value) { - $data[$label][$compare] = round($value / array_sum($values) * 100, 1); - } - } - - $lines = array(); - foreach (array_keys($data) as $label) { - $rolling = 0; - foreach ($compares as $compare) { - $rolling += $data[$label][$compare]; - $lines[$compare][$label] = $rolling; - } - } - - foreach ($lines as $line => $values) $lines[$line] = implode(',', $values); - - $colours = array(); - while (count($colours) < count($compares)) { - $colours[] = str_pad(dechex(rand(0, 16777215)), 6, '0', STR_PAD_LEFT); - } - - $fill = array(); - foreach ($colours as $i => $colour) { - $j = $i + 1; - $fill[] = "b,$colour,$i,$j,0"; - } - - $params = array( - 'chs' => '500x200', - 'cht' => 'lc', - 'chd' => 't:0,0|' . implode('|', $lines), - 'chm' => implode('|', $fill), - 'chco' => '00000000', - 'chxt' => 'x,y', - 'chxl' => '0:|' . implode('|', array_keys($data)) . '|1:|0%|25%|50%|75%|100%', - ); - - $trend = 'http://chart.apis.google.com/chart?'; - foreach ($params as $key => $value) $trend .= "&{$key}={$value}"; - - $last = array(); - $tail = array_pop($data); - foreach ($compares as $compare) { - $last[$compare] = $tail[$compare] ? $tail[$compare] : 0; - } - - $labels = array(); - foreach ($last as $label => $value) { - $lab = $label ? $label : 'unknown'; - $num = $recent[$label] ? $recent[$label] : 0; - $labels[] = "$lab ($num, {$value}%)"; - } - - $params = array( - 'chs' => '450x200', - 'cht' => 'p', - 'chd' => 't:' . implode(',', $last), - 'chl' => implode('|', $labels), - 'chco' => implode(',', $colours), - ); - - $pie = 'http://chart.apis.google.com/chart?'; - foreach ($params as $key => $value) $pie .= "&{$key}={$value}"; - - return array('url' => $trend, 'last' => $pie); -} - -/** - * @param $query - * - * @return array - */ -function trend($query) { - $data = array(); - $result = mysql_query($query); - while ($row = mysql_fetch_object($result)) { - if (!$_GET['current'] and $row->year == date('Y') and $row->month == date('m')) { - continue; - } - $data[$row->month . '’' . substr($row->year, 2)] = $row->data; - } - - $max = max($data); - - $params = array( - 'chs' => '500x200', - 'cht' => 'lc', - 'chd' => 't:' . implode(',', $data), - 'chds' => '0,' . $max, - 'chxt' => 'x,y', - 'chxl' => '0:|' . implode('|', array_keys($data)) . '|1:|0|' . implode('|', array($max * 0.25, $max * 0.5, $max * 0.75, $max)), - ); - - $url = 'http://chart.apis.google.com/chart?'; - foreach ($params as $key => $value) $url .= "&{$key}={$value}"; - return array('url' => $url, 'last' => array_pop($data)); -} - diff --git a/tools/sites/stats/index.php b/tools/sites/stats/index.php deleted file mode 100644 index f663165f92..0000000000 --- a/tools/sites/stats/index.php +++ /dev/null @@ -1,242 +0,0 @@ - - - - CiviCRM usage statistics - - - - - -

CiviCRM usage statistics

- 'Distinct installations', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month FROM stats GROUP BY year, month ORDER BY year, month', - 'type' => 'trend', - ), - array('title' => 'UF usage', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, uf compare FROM stats GROUP BY year, month, uf ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'CiviCRM versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(version, 1, 3) compare FROM stats WHERE version LIKE "_.%" GROUP BY year, month, SUBSTR(version, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'Drupal versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(ufv, 1, 1) compare FROM stats WHERE uf = "Drupal" GROUP BY year, month, SUBSTR(ufv, 1, 1) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'Joomla versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(ufv, 1, 3) compare FROM stats WHERE uf = "Joomla" GROUP BY year, month, SUBSTR(ufv, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'MySQL versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(MySQL, 1, 3) compare FROM stats GROUP BY year, month, SUBSTR(MySQL, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'PHP versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(PHP, 1, 3) compare FROM stats GROUP BY year, month, SUBSTR(PHP, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'Default languages', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, lang compare FROM stats GROUP BY year, month, lang ORDER BY year, month', - 'type' => 'compare', - ), -); - -switch ($_GET['current']) { - case FALSE: - print '

include partial data for current month

'; - break; - - case TRUE: - print '

drop partial data for current month

'; - break; -} - -// $fields = array('Activity', 'Case', 'Contact', 'Contribution', 'ContributionPage', 'ContributionProduct', 'Discount', 'Event', 'Friend', 'Grant', 'Mailing', 'Membership', 'MembershipBlock', 'Participant', 'Pledge', 'PledgeBlock', 'PriceSetEntity', 'Relationship', 'UFGroup', 'Widget'); - -$fields = array('Contact' => array('skip' => array(102), - 'min' => 10, - ), - 'Contribution' => array('skip' => array(13), 'min' => 10), - 'ContributionPage' => array('skip' => array(3), 'min' => 0), - 'Membership' => array('skip' => array(30), 'min' => 10), - 'MembershipBlock' => array('skip' => array(1), 'min' => 0), - 'Pledge' => array('skip' => array(3), 'min' => 0), - 'Friend' => array('skip' => array(2), 'min' => 0), - 'Event' => array('skip' => array(3), 'min' => 0), - 'Participant' => array('skip' => array(50), 'min' => 10), - 'Mailing' => array('skip' => NULL, 'min' => 3), - 'Case' => array('skip' => NULL, 'min' => 5), - 'UFGroup' => array('skip' => array(1), 'min' => 0), -); - - - -print '

jump to comonent stats: '; -foreach ($fields as $field => $dontCare) print "$field "; -print '

'; - -/** - foreach ($charts as $chart) { - switch ($chart['type']) { - case 'trend': - $result = trend($chart['query']); - print "

{$chart['title']} (last: {$result['last']})

"; - print "

"; break; - case 'compare': - $result = compare($chart['query']); - print "

{$chart['title']}

"; - print "

"; break; - } - } - **/ - -$year = date('Y'); -$month = date('n'); - -if (!$_GET['current']) { - $month--; - if ($month == 0) { - $year--; - $month = 12; - } -} - -// mysql_query("CREATE TEMPORARY TABLE latest_ids SELECT MAX(id) id FROM stats WHERE YEAR(time) = $year AND MONTH(time) = $month GROUP BY hash"); -mysql_query("CREATE TEMPORARY TABLE latest_ids SELECT MAX(id) id FROM stats WHERE substr(version,1,3) = '2.1' GROUP BY hash"); -mysql_query('CREATE INDEX latest_ids_id ON latest_ids (id)'); -mysql_query('CREATE TEMPORARY TABLE latest_stats SELECT * FROM stats WHERE id IN (SELECT * FROM latest_ids)'); -foreach ($fields as $field => $dontCare) { - mysql_query("CREATE INDEX latest_stats_$field ON latest_stats (`$field`)"); -} - -foreach ($fields as $field => $values) { - print "

$field

"; - - $clauses = array("( `$field` IS NOT NULL )"); - - if ($values['skip']) { - $skip = implode(',', $values['skip']); - $clauses[] = "( `$field` NOT IN ( $skip ) )"; - } - - if ($values['min']) { - $clauses[] = "( `$field` > {$values['min']} )"; - } - else { - $clauses[] = "( `$field` > 0 )"; - } - $clause = implode(' AND ', $clauses); - - $total = mysql_fetch_object(mysql_query("SELECT COUNT(*) count FROM latest_stats WHERE $clause")); - $total = $total->count; - print "Total: $total

"; - - $tops = mysql_query("SELECT `$field` field, COUNT(*) count FROM latest_stats WHERE $clause GROUP BY field ORDER BY count DESC LIMIT 5"); - print '

five most popular counts: '; - $first = $second = NULL; - while ($top = mysql_fetch_object($tops)) { - if ($first !== NULL and $second === NULL) { - $second = $top->field; - } - if ($first === NULL) { - $first = $top->field; - } - print "{$top->field} " . strtolower($field) . "s ({$top->count} installs), "; - } - print '

'; - - $stat = mysql_fetch_object(mysql_query("SELECT MAX(`$field`) max, ROUND(AVG(`$field`)) avg FROM latest_stats")); - print "

$field with all counts – max: {$stat->max}, avg: {$stat->avg}

"; - print ''; - - $high = -1; - $pieces = 20; - $lowCount = round($total / ($pieces + 2)); - $highCount = round($total / ($pieces - 2)); - for ($i = 1; $i <= $pieces; $i++) { - $low = $high + 1; - $high = round($i * $stat->max / $pieces); - - $loop = 0; - while (1) { - $count = mysql_fetch_object(mysql_query("SELECT COUNT(*) count FROM latest_stats WHERE `$field` BETWEEN $low AND $high AND $clause")); - $currentCount = $count->count; - if ($currentCount >= $lowCount && - $currentCount <= $highCount - ) { - break; - } - // echo "$currentCount, $lowCount, $highCount, $low, $high

"; - - if ($currentCount < $lowCount) { - $high = round($high + ($high - $low) / 2); - if ($high > $stat->max) { - $high = $stat->max; - } - } - - if ($currentCount > $highCount) { - $high = round($low + ($high - $low) / 2); - } - - $loop++; - if ($loop > 20) { - break; - } - } - // echo "RESULT: $low, $high, $currentCount

"; - - if ($currentCount) { - print "

"; - } - } - print '
lowhighcount
$low$high$currentCount
'; -} - -?> - - - diff --git a/tools/sites/stats/robots.txt b/tools/sites/stats/robots.txt deleted file mode 100644 index 1f53798bb4..0000000000 --- a/tools/sites/stats/robots.txt +++ /dev/null @@ -1,2 +0,0 @@ -User-agent: * -Disallow: / diff --git a/tools/sites/stats/stats.php b/tools/sites/stats/stats.php deleted file mode 100644 index 7626d6bec0..0000000000 --- a/tools/sites/stats/stats.php +++ /dev/null @@ -1,212 +0,0 @@ - - - - CiviCRM usage statistics - - - - - -

CiviCRM usage statistics

- 'Distinct installations', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month FROM stats GROUP BY year, month ORDER BY year, month', - 'type' => 'trend', - ), - array('title' => 'UF usage', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, uf compare FROM stats GROUP BY year, month, uf ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'CiviCRM versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(version, 1, 3) compare FROM stats WHERE version LIKE "_.%" GROUP BY year, month, SUBSTR(version, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'Drupal versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(ufv, 1, 1) compare FROM stats WHERE uf = "Drupal" GROUP BY year, month, SUBSTR(ufv, 1, 1) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'Joomla versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(ufv, 1, 3) compare FROM stats WHERE uf = "Joomla" GROUP BY year, month, SUBSTR(ufv, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'MySQL versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(MySQL, 1, 3) compare FROM stats GROUP BY year, month, SUBSTR(MySQL, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'PHP versions', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, SUBSTR(PHP, 1, 3) compare FROM stats GROUP BY year, month, SUBSTR(PHP, 1, 3) ORDER BY year, month', - 'type' => 'compare', - ), - array('title' => 'Default languages', - 'query' => 'SELECT COUNT(DISTINCT hash) data, YEAR(time) year, MONTH(time) month, lang compare FROM stats GROUP BY year, month, lang ORDER BY year, month', - 'type' => 'compare', - ), -); - -switch ($_GET['current']) { - case FALSE: - print '

include partial data for current month

'; - break; - - case TRUE: - print '

drop partial data for current month

'; - break; -} - -$fields = array('Activity', 'Case', 'Contact', 'Contribution', 'ContributionPage', 'ContributionProduct', 'Discount', 'Event', 'Friend', 'Grant', 'Mailing', 'Membership', 'MembershipBlock', 'Participant', 'Pledge', 'PledgeBlock', 'PriceSetEntity', 'Relationship', 'UFGroup', 'Widget'); - -print '

jump to comonent stats: '; -foreach ($fields as $field) print "$field "; -print '

'; - -foreach ($charts as $chart) { - switch ($chart['type']) { - case 'trend': - $result = trend($chart['query']); - print "

{$chart['title']} (last: {$result['last']})

"; - print "

"; - break; - - case 'compare': - $result = compare($chart['query']); - print "

{$chart['title']}

"; - print "

"; - break; - } -} - -$year = date('Y'); -$month = date('n'); - -if (!$_GET['current']) { - $month--; - if ($month == 0) { - $year--; - $month = 12; - } -} - -mysql_query("CREATE TEMPORARY TABLE latest_ids SELECT MAX(id) id FROM stats WHERE YEAR(time) = $year AND MONTH(time) = $month GROUP BY hash"); -mysql_query('CREATE INDEX latest_ids_id ON latest_ids (id)'); -mysql_query('CREATE TEMPORARY TABLE latest_stats SELECT * FROM stats WHERE id IN (SELECT * FROM latest_ids)'); -foreach ($fields as $field) { - mysql_query("CREATE INDEX latest_stats_$field ON latest_stats (`$field`)"); -} - -foreach ($fields as $field) { - print "

$field

"; - - $clauses = array("( `$field` IS NOT NULL )"); - $clauses[] = "( `$field` > 0 )"; - $clause = implode(' AND ', $clauses); - - $totals = mysql_query("SELECT COUNT(*) count FROM latest_stats WHERE $clause"); - while ($total = mysql_fetch_object($totals)) { - print "Total: {$total->count}

"; - } - - $tops = mysql_query("SELECT `$field` field, COUNT(*) count FROM latest_stats WHERE $clause GROUP BY field ORDER BY count DESC LIMIT 5"); - print '

five most popular counts: '; - $first = $second = NULL; - while ($top = mysql_fetch_object($tops)) { - if ($first !== NULL and $second === NULL) { - $second = $top->field; - } - if ($first === NULL) { - $first = $top->field; - } - print "{$top->field} " . strtolower($field) . "s ({$top->count} installs), "; - } - print '

'; - - $stat = mysql_fetch_object(mysql_query("SELECT MAX(`$field`) max, ROUND(AVG(`$field`)) avg FROM latest_stats")); - print "

$field with all counts – max: {$stat->max}, avg: {$stat->avg}

"; - print ''; - $high = -1; - $pieces = $stat->max > 100 ? 100 : $stat->max; - for ($i = 1; $i <= $pieces; $i++) { - $low = $high + 1; - $high = round($i * $stat->max / $pieces); - $count = mysql_fetch_object(mysql_query("SELECT COUNT(*) count FROM latest_stats WHERE `$field` BETWEEN $low AND $high AND $clause")); - if ($count->count) { - print ""; - } - } - print '
rangecount
$low–$high(" . $i * 100 / $pieces . "%)$count->count
'; - - $stat = mysql_fetch_object(mysql_query("SELECT MAX(`$field`) max, ROUND(AVG(`$field`)) avg FROM latest_stats WHERE `$field` != $first")); - print "

$field sans the $first count – max: {$stat->max}, avg: {$stat->avg}

"; - print ''; - $high = -1; - $pieces = $stat->max > 100 ? 100 : $stat->max; - for ($i = 1; $i <= $pieces; $i++) { - $low = $high + 1; - $high = round($i * $stat->max / $pieces); - $count = mysql_fetch_object(mysql_query("SELECT COUNT(*) count FROM latest_stats WHERE `$field` BETWEEN $low AND $high AND `$field` != $first")); - if ($count->count) { - print ""; - } - } - print '
rangecount
$low–$high(" . $i * 100 / $pieces . "%)$count->count
'; - - $stat = mysql_fetch_object(mysql_query("SELECT MAX(`$field`) max, ROUND(AVG(`$field`)) avg FROM latest_stats WHERE `$field` != $first AND `$field` != $second")); - print "

$field sans the $first and $second counts – max: {$stat->max}, avg: {$stat->avg}

"; - print ''; - $high = -1; - $pieces = $stat->max > 100 ? 100 : $stat->max; - for ($i = 1; $i <= $pieces; $i++) { - $low = $high + 1; - $high = round($i * $stat->max / $pieces); - $count = mysql_fetch_object(mysql_query("SELECT COUNT(*) count FROM latest_stats WHERE `$field` BETWEEN $low AND $high AND `$field` != $first AND `$field` != $second")); - if ($count->count) { - print ""; - } - } - print '
rangecount
$low–$high(" . $i * 100 / $pieces . "%)$count->count
'; -} - -?> - - - diff --git a/tools/tests/reports/index.html b/tools/tests/reports/index.html deleted file mode 100644 index 679fc5e8ff..0000000000 --- a/tools/tests/reports/index.html +++ /dev/null @@ -1,13 +0,0 @@ - - -

CiviCRM test reports site

-
- {ts}open section{/ts} - -