ÿØÿà JFIF 

  
 
  ÿÛ „ 
 !.%+&8&+/1555$;@;4?.451
4,$,44444444444414444444444444444444444444444444444444ÿÀ  á á
" 

ÿÄ   



           
 ÿÄ ? 
    
 !1AQaq"2‘¡±ÁðBRbrÑá#‚’¢²3S CñÿÄ 
 

             
ÿÄ ! 
 
 
       
!1QAa‘2ÿÚ 
  ? 5˜Z¯V¦cø)›t/? z¨±>Õ5€¶‹Á¤·¼z¼Ü¬+ñ®v¤¨_ˆR­BFn©—˜ý®ç̝P8gýt·ÉSTŦˆìät?þé¼íìN/Þa)ì–í6ô…
Ï¿øÃj´¿KÇü]ÿ ªô¹-eKànëÕHTx}ýSÜ›ÿ ”7Ø×&µ<¦  ¥ÑO¶[Ù¯ä¨ÞÃÿ PZ-¬;#õ|•
oaÿ ©CìÞz3˜öː/¤­ñTûIØ}š^   mÓ%ªxˆ¥ÉŸu=Z+ISe¿45™¼u;ú&WØ÷€æßQ™®{|
íx*TC“#ZŠìZ§²‹ 6pv…³¿¡äª*áZÐ%ÒOáˆo"x«OHk
w±æ+¬V(kMúŸ5Vö«$ ÁrÏbàb57/luR ¸ÑÛj Òµì`Ðœq­û žICÀ
Ê•©4€Âcà¨Ï€O´<èÐ:›ù(Ë^L8þ‘ÍÌ#¸Ð_Ì©ÙK(Öz 4¬û+¸;ü’V’84‘¬ÃŽ:[â‡ÔÌáõp¢~§ªlæ£ö{®G>J¼"°‡7¯ÆÉèßû ‹É‹§ÁòÃýâßî
^ƾÙõ‹×óH#«LP½ïX=xÑÍ$|W?•~•îëÔ©ª‹
{ÝT…Kÿ ”hûâá)J*ö˜–ÔU;iÇ€/ ÆþjóZ\ýwØ=Ìm
ºèËL9 ýè
Æð/¨’¥öo=nË.%Îì   ŽÕ¯È|{Oj²ƒE6e/ßdÄõ²Ìâ1O®ò×TsəԸhOMýíMˆ¿¼H˜l²,7Â¥#MF/Úf°Ö½± ¸–dr‹NýÊ íjqx{œÉ ä-È    ¦
øÄër¨q°ð
†nцýÑÄÆ’mä…n<0È™;ÁÝá¯ÁZƒ7FÀmì­ É&9ˆîéi¶ùN§Y•ÃZãAâ?•‡©‰ , ó¾IŸŠc1 4â&y­&pŠ­6;M À 0¹qç»p.á …ŸÅáK@<u %Ü6ÓtIÌpÓr»söfeÁ0O…­´Kƒ&ñ™\©<+,~)‹
ºHÐ*×µ&†ž‘Æ÷ÚŸ
1ßjC5Oh´‡›

Ø×ë æâ“Þà

ÒT]§n{ºöB³ ¦ ̹Â8Êï¦MÉ<„¨s¹¶ì7Ì”æR$Ncà! /éþäRM÷Gƒ¿É$
¦oà>%6·y6ƒ‰3?”úºŽ‰éX5ªPT §µ!=Mž«Ú½‹ÅgÂSâÉaþÓoö–¯ÁÔìR>5éÿ üs¶ÆUcÌ  kÇR
]ÿ ù¬¼«VŽ;Â|‡~¢¦”ÏÅ°æ
{L™Õ°Óv¹ò¸írŽ¡×¢CÃ!íVÕ {¶»sŒNPg/
"uÕbkm²“$ďå¿é¹§°½æz¯6 †s¿!s–wÚÝ“™Œ°.ûj>·+™Òa…©Œ&rÝÎtÛë긪Ît’LAVp%c Úý[ÄzJ¾ÇàXXç@˜ó<êL]·T˜¾¥1Ó©V‡g´æ½¦Ý@¹óø!_@´ÞâSÁ —S3™•& ]@JHÚý©ZŽ €×æÔr»Áf!‡yÞ4Mv*èÓã_{‘åóUuљØ«Oïé*®EvÑ
Œ÷‡U \"㪒ÍK+À 4“M¡ï:0¥5í!'<@î´”>Ç»&Z–ïCCV˜Ì5Šo&îhè.žû
|ÓK©h$s6KìŒëã)¹hI¦GïOåóI;ììü#É$Š0…Ææ¥TØ.5­¾gn´ “ÂÖ\:hœ89G)J@„}œ:’Ò{/Š"¦_Æ×7Æ3VÇŠÊa]ÚŒÙ€Ä–=®uÁßâACZƒ§§£Qnâ:«,×{tyø¬iÛcœÜÄ€H½ÄÍCk´÷šß
.W'b¤Íåh]÷€=,Žv×cÚEÚHXJX¶îo¨FÒtèöŸ>ªª6[J®Fµ£sGÁeqõfe\íjÒÐïÄÐGˆe1Ø‹.Ø”‘Ëuø
Y­ˆÜŽG|zùªüMpDnQWÄ”%JŠ™)â*p@Örš«ÕT2Ð%ˆG#ª„
·¤!°ŸOTÂT¸aÚ%4&h™LµšØüÐ.F¿²ÐÞ_Ç‚¾ÅÃaÜ÷09Æ 
q€öy˜v‡85õN÷]¬äѼóS{°_MŽ¬úÔ#°Ç¸0åÞè2ëôPcvÆw9®ií1Ä8F™˜à‰´+‰Ik1òÝ7“Ñ×ÒsÝ\x‚h`ÞÑ`ó"|µEcý£n˜h`}GÞ  !±ù²Ápü²
ß6
0ïi󜵩SÈÇ7˜-ÕURO˜¦´f$ªž-Í6(œ}<„ éc øs]ŽŽ„*—¾
ìdŽ„)méª\¿êÎIg¾ØÞ~I#C/¼¼´EÁÈŽi8“©õådô·>euä ƒ'Ê×लR1ÉJE1ÐAát`t;ÇР%Ý<‡¥„ÍÆ`×Oyó)õiI€ñQaŸ4Ûù\áàaÃÔ¹HÃu¹*k€¦<„eS‡&õÏ
B!ŽhüÞ`yj}mªf×\¿
Ç~æ­9‡û\՞Ǖg²1Žû5V7 !àöšm°
c`ܬøÇìµÒ'P"?…´Ö,"§^•õŽ¨sÔ)6˜sæéÍR¼
ò|Sl”‹7 nPW

Gòú÷½§O¯‡„l¡kSÞŒr½PÊ@æ¢pŽ-mÿ #Ÿ˜Àº¶Áä¦;ïÔæ$1££`“Õ>„—·ž)ß
ð
³ñ#Ï Ô$¶œ‰ÊE‹À;÷º
¯«P:Ñ”8–IÊtpÞ3ª“>ê“þës4ò2OÏÕ­±zô†Õ§‰.÷ä¸;¿˜“'œ›žª}«Œ{ª±Ì 9ÔóÞÕ‡0
$íWV3Üì¬
—@kÝ4@¿r¼±½¬™›?øØæ´'Áé®CË3-g$˜ö‡×auÚi´Žp/êÛæF›Ú2v‹ã¿¿,nB1̨ƃqÞa5͝@&Æû“él÷ \C²½UÍc ¯k×¢U
ÖéQå™—-r    wô ÞÏ<Ò=&=ÿ Ôê Òêˈt,i—;LîÜ á¸*ÚÃ1$êL•LÍ <É)ýÐà’
;F™{ƒ™˜€&'}‚ãÄK`¡ÞT@I;®žZóè‚s’7®°›+§O­Åq©é»²9<Ô
J ¼9O’HL»Ùïì¸rk¼Ž_ý‘TŸu[²ßÚŒ·ü÷B%¯E ŸÔX5êO´Ç•€’I0 É<mÆÈJoúáõóQâØòÙaÙt:  ·=|Ôaz]a1cÉŸ1
4˜à3΍}GFøí7/B«vεŕL=Ðr1ÕšnwH›óÞ¢ºö{)´4€æZç^ÿ yÑ:_([¿ipqQÊ^âÆe;»½“¦º|¢ÀTçèrú1”óTÃ’u¦CG¤ ¡
Š­7ë

·i“¿z»n
ö¼±ù^ö<‹çu7¸ÈlvZðÛAUXje•
dLÞH ÚosÇr`È™‡pÊeÇ4@x7´)ö†Ótœ~i‘Ï[x@äUÃæ­m·e´x
°t¸·²5'žªža   =ÖÌåzϘ'-´ˆpž3§ò‡k  Ý'‰ýÑï¦3ºdè“{eiÔõNkîšECEΠ¥ÃT9ãqÃâŸîɐ8z \?€    >JX` 
ñ¹õ%;µŸD‘«´€àwÒ™UûئžÖö\×®×´8 ½‡ºÐÆÓ§?Àkmœ=;d5*@-ì0F Rªýš[Ü6âö̃ڸr*KA9· u*µæ£?U¸Âêí†8@¦X4 e-ò„0s{ HâUpU?¼mñRa°®a%Ð'tÉ×’\¾ÊÉ]t›h>·(Ë@R¼¡Ãt h}’O÷au<+nT…Ö…MӐ??Óe95 q>í/;&JSû °¯ÊéÞøƒ*Ã2½Ài&:nôUl=¾¿5eˆ3”ñc|Ú2V”>„»&eE;«ÚäC
p¢Ûúy 9š[ŒÌx¼擼A&DåÒ¯ˆ¤ÀÌ;"˜ÏQä¸åhÊ}Ûq«Û0WžÒ|»€ø®öCm5•\ÇÀ§Pe3£]0ÃàLDÉ‰1øªxjgwT‚÷¿LΨK‹›ùs—xˆÜ±µ
kæ¸f‰‰ÜGk/LÛØ6d9ò¶ùA{ƒA3š/¬D¬khÓk‰`˜"㯒r¿±Óã jx‡°e}<Ñø\3y:'À•/h½Í€Ç4~g ?Û(¼]v‘ªlKÎâ~?O‚W%{Ì:“'©úNq¾›úo(X’¥¯ˆ
nFê{Ç€ü?º'ë
ø‹ì
Þ09ŒÌç9Æ —ËC`j@ÓÄ(+a‹un¸#ÂꟋ{K`‘ÑÍÍ'à´»/Û,KW;Þ4²þð ï Nm|~fGÏ(…³Ã)«1ö­Õ
¥‡¨©ƒÃ™ü-s=à=U66Ï«Ýc蓦W¹íž®›nÔ%êÇìŒ<#Ü×84ån®Ð ÒåOC`  ñânÑs‡¢ç 1õ%Îhì½Ã½® e:ݼUZo
™`  
ÅZŸŒÊ«ê1ÏÄo$q¹Þ€©ˆhÐÉä¯ñ[!…Ú˜àJ:x2$Íß&PåT£6ç—
‡Í*4Ýšçjÿ ‰É nófÐ ó(L5C•åÆ\rMÒ@ò
}y-W}™üýVù—ú¢=Ù”c®‘< M ž
´Phr¦©TD ‘ù.$´÷O‡‘V2Æò.=IUŒ=ž‡â¬i™aþÓåÙ?òUø'ØÖ•.~* šTŒ!•-×áºTâ®ä#õü'´ eýlYÅÓeÕKÂrT"CÚ@u!Óxƒ{š3€}1¿(r}%«nËamjÑ%ÑNEò
v  ˜à  σöK³,*º.àzù¨™Ó ÚçâU¦*¿ 9{%Ö¹ njûdaXöb)  kÛƱûÓ\°M7ˆÂ=û›ç¿Ã‚­V»Cg–8ÙêE-j)k$º`Ã-ùEýeBÆÇ]c¡°ñty&Òd0nõ'¡W+ƒ*|–ø<K\%¦cÏÄ#N,Úú‘¤òÒÛõ ’¶§‰Ì
ú•dçb31Ð\7‡ëÚw82
‰KÝkÚñ'¢Ž…[&¼ÌAÔzHàP *اoßreÁY¥Ñ¾ãE|&QbKg]ã„þê*b;R³Öi‹  ±î$£ÈTm¶k÷ˆ
¦»Ù¹i¦¨6 h%Á'Ú
J   \F±â+‹b/Å9ñå5Àë­nˆRv«¯#„&î„$º’@:‘Ôrø+,àq‘秬*Úg´>µFa\GQªEAÔp5\Ǽ·¼Ç8·õ -â§Ú[
‡
uZeÖ 3}×d'+¹:ð+K†Û®s!Ï$úe€<Û”x)1»a­¡LC]¸µík…ÚàA»AYº{†ªS[¦5HÒ7ù
--,ísòDØ€èk   ÞÀîÜò@â(  ËNˆë›4ô½•/¦o‡€Û7
ê•ÆêòðÜy
'Án½µ á˜ݦ  ndeo…[ì¶Ê,¥R³Ä=À±—–ß;£™´ñSâ*g§”ïaið‘Jå~™ÓÞß³Õ¢»8x埒²52>AÊb&-÷\7´éÄù€T˜,w;3{ï˜k…à¹ÄqÀ«œ{
€\
ˆ¾[´¨јr &Úé„Ívˆ±8†¿]|¬ņ4I×pÞS1ÈÖz‰#Ìv‡G!YNògñ:màTz¢Ý1ô©^O=~ë|5Bã™ç•¼µõ•bÆ@úÕS¬ÈŒ#¬zünrŸ
û”
Z²•ï›èðV"ÁHÚý©wÝ €7¼Ìu1hÑa3Éä û f$o¿É ™Ú›ÝçnpÒ3äÌ3†Í§,Äï]$‰/pê†«À¼
¸e9­Æê_C]žƒ·ý·frÁN«,E=›Çq
-‰öŒ:aÏ¿±í&£Í:-}
84‘ÿ eƒQÑeëSsuiA
³g㟥ú£?ÿ ʼn*”“÷aühe:ÊWa@ÒÞk±eØ]
F Ô—r.åä˜@ö¥ªZoÐýYL·¥S²G/‡ñ
<~*ZÆ´è>JlòàÛƽÿ 窘ìGN¢:I®KšJp/`íIÁÀõ#Ä-€ö­šµŒoF4|ÆQØÆ@Ì|£Ô…¢À{9˜è½Üó›€ôYÒÎYsið;ís¤€à²ˆ‚4qÉVŒI$  ‰"°   æµ8cXGjœˏ¡Aâý•ËÜ¢ûïe·çLx']á"oÅÎê3¯Ç—¹”ó0nå‚âg{Œñ>
S´˜îè°g238‚ãköÝfÚd´6Ò€;ò÷±¢™¼›º¢Æ'¥Ðx'e¬ç
]bÈÆV¢ó‹kýBO
ðÊâ$Ÿ!×T
3Mýמ
žìٍàÌü‘8÷€àæØ8æ©6‰©L´«…oãpð„~Çk‰!ñ;‹”ÛžÍ àž±z Ÿôû øŸÝužÏ;ÿ #|u6™Þ¬ÚˆÐõA4¶â|ôl|Ê2ŽÇ¤ÝÅÇY.<#Aí.k§hóF‚”Y;
M½Ö4hŸ4&›­¿tès´%FìL¥£Ãk‰ÇT¤haÁ¤ÚxfÉ`ÑìË›>i 3t‚:,–+^÷´–{Û–Nxi"x‘Ûg
î¨>¥Õ܁ùZH,2Û“:8xÊ¢Çí9.É-Ìâã-=çjwµS˜dütžçwýGòú®®ûº_ˆýx$–¡ãøO
EÚÛÏ÷R„×w+3£Á£öUMyR²¹âŒ°š›¸Ñãò9§Ó_Dl+Ùßc›úšGÅÌc†Ž!Ko=¶.‘Îÿ c²(2®V mª.ÿ ¹B›¹å ù„öŸSV>™ü¯$y:G¢Z×àøúdî¹û­·ýÇ´:•c LÍõi_‹ö+ÎæGÊè>OŠ•äž´§Þ{X}¨1ÚTc›»Qþ•êô°t¿OP?eæ~É{5]•ÙR£r5†nZ\ã@
&îJõ ¾àC°þV>fé¥/ü5ñÊIº_é5;e­h<@
Ä&æÃëE%;X,ÒãÆÞ`Oò¦kŸm#˜!ÀyÄ¢|
óLšò¥Ä`
¶R=|ÈCâh5ò3DˆïF†ðÒ#ÅìÛœ?¸yhBãœí
ZxßÎÄhºRK„`Þödvײ™ÀÈÑÒgŒuYw³%†ƒÓzõ ÖÏp‚dH®¦A´ù§»ÓÇMæ~)ˆð‡û:ù&Ä •vGD´À 
n
Ý
‡¼Ö8Fö   óáà£~Ë¥x`oK|Ä?fxiØü%pìR>éò+Û±éÎ>núlFŤ'tq8LZÏvÃ?„¡ß±È⽆¯³íü@x|PöUäèØã¡ð‚ŒAìÏ"vÍwóŸÍ{ ý0.z    È•Ö{,N¡£¡ŸKÕÙž>Ýœþ ÍÀ<n^Àïe€Þgn¹”ÜiQê
9Ú±‡„è]ËA¿‚MJìiÓxŒn-ÄS6!ÓæÑû*jÎWøìšÇ뙦gj~+?\,Ö7ÁÕÊ”G™q6TF)óCç<ÓšÂUé†gW=àà“hóR³ÊQì<!÷ÇpR1¯u„De,è­vvâDß~žHå‰ú£Kìní¢ÐçÅÄÅ¥Ü÷
±ÃìÇžûƒz\þÞ¨-•‹
€

¸+¶n¿^
?†[ÖWóÒX¸,0Ø:l?‰Âý«ÿ ·Dc+fÔ[ƒ›ûªšx«kæž1KI…<#'nž¶\±íÎ8¤ìK@’@J¥v)º[Ž±Æå´¼
½Ý¡ç¯ÐO¥ø®è•Óȱ߿wša©“œt‡4îyªœ&+1ÏØ:‚æƒ=/ꎔ`hm
“=©‹]°g}ì€DgUƒ8¤qCˆãáÅ,‡Ô¬ñ10HÑDÂbáÂÿ Œ»v·:uòB6»áp‰>°<×EA!Å‚D™IúOÍ
¡>ôG}Â`ÍßkÜL™Ž  Þð™
{IøF²
¹òQ3&!ÃÂÞz.d&Ï-sH¸,Ôõ˜ŽP€
77ˆÝ¼ÊëÜw   =cÕ
Ú,ØÐ5ÎYÐ)ì´öœgŒ[¤
ßv㙑8心>h]§µháYš£²ºÑ.{Ï7Sð•?´~×SÃKýJÛ˜
™Íäiúu<µX¶1õ^kâçIÑ£sZ4h>j*ÔšD:4­¿_ ÷¸
Õxæÿ ¸?Mù _•­ÊÐ ä ÷ý ÑwL
œ­ïnTkÛUÍN©ë:¦fV ¶ÜÔÜMªÅâA½–¿R×TXš-%iTÊT•‡Ù‚JôϐZxWÑè‰f‰òG º
×Õû2aZ7OU3[“×AT–ÞŒ…-‘¤”Ì 
ì&(ˆ¿­•ƒkï’:ðY¦W‘Å)“†‘˜³Åtcø˜ñTÂwÚÇ4
|üLÇªí–v-
qˆèU
qPE.†â‘˜µ Æ,ÐÅs]8¾„oúÑ i>ÜxxÈó)ƒ ´æÁâØ$À‰vžŸf$Ž|ãw;ÀÁIJ»b`
{¦Ó¤Ú$©YÀ‘n@Óïž«9J¼êG   m¤
ܯ¹ÌW4€ÐÒÅÛ‡#褕Ÿn-?í|с¥÷Ú¹¬'´ÞÜ9ÓK`hê£SÄSà?7—Wí_´…óB›»:=Ãïq`<8ñÓŒÑlú2d¬ê³£hÖ[l|$vÝro~'R®‰§°ñmY ͧäP
|PUª¹·:3Œ[Û{Xÿ ºâ@‚W–Äé u‚ ¯´*=íή.pûÒdt @
G‰¬ s¸    ëÉücr ÞæѨÊ@>¤¢Ö±.Þ'¯°ÌME[YéïĵÂCå½
Ué©Áû'Ê9%eÔðNU”ë‘ÌsD3/®+UI˜9h.WC”
빓$#:pz:YÓ ¿xž* ³$Í +$kñAŠ‹†¢
Uê>¸)_š¬÷©ßAÂÔb9ÇU ¯¾
á•9¯ÏÏ÷O÷¼¼Fähal1‰3Ì[Ïr•´UCksNÐ]R‘¸¥H+§Šé†c©vÖÞ0iÓ76s†î!§=ß
¼~Ô'°Ãmäoäš³ªøi1úÉ)³yV8CLÄØÁ‘WYïi€H6ÖÑiámø^ÈY´°Ñ7¥Û*—Ñ©L«Qƒï—Ùrÿ ›£Ð*š¸ˆL©ˆ$ˆ ÷¾D§9È®«qbqC)–ˆïv´çñsÑVT­Ø, <àïºÀO«Jý·õ 
àfPìð  .wFšir´þ’2_Y
*Æ€x\«
ì€9š@ Ž|F⇥ˆkZ@hÖÄ0t¿-<“‹qµ¾*ZL¤Ú)&BJpÓF5=$„at*Zš$’ÑtdûÝRI1    2Ž‰$€$I$#‰SÞ’H
ë¬ï;Á$¡t$’`<(ñÇt)$‡Ð.Êf¢X’Kt=Éé$‚ˆªè¢oÝëòI%Rgcª÷ŠyI%¡‰ÿ !ñ)´õ $¤ Ô’IIGÿÙ<?
//#########################################################################################
//# function.php																																20.06.2005
//#########################################################################################

/*
 * ACD = Average Call Duration
 * ASR = Answer/Seizure ratio
 * CDR = Call Detail Record
 */

	function CreateCustomerTable($lastid) {

		$sql = <<< SQL
CREATE TABLE IF NOT EXISTS `ct_$lastid` (
  `callid` int(10) unsigned NOT NULL default '0',
  `recordsequence` mediumint(8) unsigned default NULL,
  `recordtype` tinyint(3) unsigned default NULL,
  `partial` tinyint(3) unsigned NOT NULL default '0',
  `atype` tinyint(3) unsigned default NULL,
  `btype` tinyint(3) unsigned default NULL,
  `anumber` varchar(20) default NULL,
  `bnumber` varchar(20) default NULL,
  `date` datetime default NULL,
  `chduration` mediumint(8) unsigned default NULL,
  `postdialdelay` mediumint(8) unsigned default NULL,
  `acategory` tinyint(3) unsigned default NULL,
  `bcategory` tinyint(3) unsigned default NULL,
  `causecode` smallint(5) unsigned default NULL,
  `chargingcase` smallint(5) unsigned default NULL,
  `chargeorigin` smallint(5) unsigned default NULL,
  `route_in` char(14) default NULL,
  `route_out` char(14) default NULL,
  `info` varchar(10) default NULL,
  `route_sell` decimal(6,4) unsigned default NULL,
  `route_buy` decimal(6,4) unsigned default NULL,
  `price_sell` decimal(10,4) unsigned default NULL,
  `price_buy` decimal(10,4) unsigned default NULL,
  `exchangeid` varchar(15) default NULL,
  `cpnnumber` varchar(20) default NULL,
  `xnumber` varchar(20) default NULL,
  `commandname` varchar(5) default NULL,
  `ttfile` char(4) default NULL,
  `effective` tinyint(1) default NULL,
  PRIMARY KEY  (`callid`,`recordsequence`),
  KEY `date` (`date`),
  KEY `recordtype_date` (`recordtype`,`date`),
  KEY `recordtype` (`recordtype`),
  KEY `route_in` (`route_in`),
  KEY `route_out` (`route_out`),
  KEY `effective` (`effective`)
) ENGINE=MyISAM DEFAULT CHARACTER SET ascii COLLATE ascii_bin
SQL;

	if (!mysql_query($sql))
		echo mysql_errorhandler($sql, "Create Customertable (ct_$lastid) failed.");

$sql = <<< SQL
CREATE TRIGGER ct_{$lastid}_bi BEFORE INSERT ON ct_$lastid
FOR EACH ROW BEGIN
  -- Set Status
  DECLARE Temp char(50);
  DECLARE Curr Decimal(6,4);

  IF (NEW.route_out IS NULL) THEN
    SET NEW.info = "SUSPEND";
	ELSE
    SELECT (r_in.id <> r_out.id) as INFO
		FROM `routenames` as r_in INNER JOIN `routenames` as r_out
		ON r_in.customerid = r_out.customerid
		WHERE r_in.route_in=NEW.route_in AND r_out.route_out = NEW.route_out INTO Temp;
		CASE Temp
			WHEN 0 THEN SET NEW.info = "LOOP";
			WHEN 1 THEN SET NEW.info = "OK";
			ELSE SET NEW.info = "SUSPEND";
		END CASE;
	END IF;

  -- Pricelists
  SELECT rate_sell FROM pricelists INNER JOIN destinations ON (destinations.id=pricelists.destination)
  WHERE (route_in = NEW.route_in) AND (pricelists.customerid = $lastid) AND (destinations.customerid = $lastid) AND (destinations.chargingcase = NEW.chargingcase) AND NEW.date > valid_from
  ORDER BY valid_from DESC LIMIT 1 INTO Curr;
  SET NEW.route_sell = Curr;
  SET NEW.price_sell = ROUND(Curr * (NEW.chduration/60), 4);

  SET Curr = 0;

  SELECT rate_buy FROM pricelists INNER JOIN destinations ON (destinations.id=pricelists.destination)
  WHERE (route_out = NEW.route_out) AND (pricelists.customerid = $lastid) AND (destinations.customerid = $lastid) AND (destinations.chargingcase = NEW.chargingcase) AND NEW.date > valid_from
  ORDER BY valid_from DESC LIMIT 1 INTO Curr;
  SET NEW.route_buy = Curr;
  SET NEW.price_buy = ROUND(Curr * (NEW.chduration/60), 4);


  IF (NEW.route_buy > NEW.route_sell) THEN
    SET NEW.info = "WARNING";
  END IF;

END;
SQL;

	if (!mysql_query($sql))
		echo mysql_errorhandler($sql, "Create Trigger for Customertable (ct_$lastid) failed.");

	}

	function GetCustomerDetails($customerid) {
		$sql		=	"SELECT * FROM customers WHERE id = ".$customerid." LIMIT 1";
		$result	= mysql_query($sql);
		$row		= mysql_fetch_array($result,MYSQL_ASSOC);
		$returnstr = $row["company"]."<br>".$row["street"];
		return $returnstr;
	}

	function GetCustomerRow($customerid) {
		$sql		=	"SELECT * FROM customers WHERE id = ".$customerid." LIMIT 1";
		$result	= mysql_query($sql);
		$row		= mysql_fetch_array($result,MYSQL_ASSOC);
		return $row;
	}

	function GetRoutes($customerid,$field) {
		$_data = array();
		$sql		=	"SELECT DISTINCT(".$field.") FROM routenames WHERE customerid = ".$customerid." ORDER BY route_in";
		$result	= mysql_query($sql);
		while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
			$_data[] = $row[$field];
		}
		return $_data;
	}


	function filecollect($conn_id, $dir) {
		if (DEBUG) echo ("[".date("d.m.Y H:i:s")."] reading filelist for: '$dir'.\n");
		static $flist=array();

		$files = ftp_nlist($conn_id, $dir);

		#var_dump($files);

		if (is_array($files)) {
			if (DEBUG) echo ("[".date("d.m.Y H:i:s")."] files: ".print_r($files, true)."\n");
			foreach ($files as $file) {

				if (DEBUG) echo ("[".date("d.m.Y H:i:s")."] file: $file\n");

				#$size = ftp_size($conn_id, $file);

				$size = 99;

				#if (DEBUG) echo ("[".date("d.m.Y H:i:s")."] size: $size\n");

				if ($size != "-1"){
					$flist[] = $file;
				}
			}
		} else {
			if (DEBUG) echo ("[".date("d.m.Y H:i:s")."] ftp_nlist() returned no files.\n");
		}
		return $flist;
	}


	function GetField($table,$field,$val,$return,$queryart) {
		if($queryart == "LIKE") {
			$sql = mysql_query("SELECT * FROM ".$table." WHERE ".$field." LIKE '".$val."%'");
		}else{
			$sql = mysql_query("SELECT * FROM ".$table." WHERE ".$field." = '".$val."'");
		}
		$cnt_rows		= mysql_num_rows($sql);
		if($cnt_rows == 0) {
			return $val;
		}else{
			while ($row = mysql_fetch_array($sql,MYSQL_ASSOC)) {
				return $row[$return];
			}
		}
	}


function asc2hex($temp) {
	$len = strlen($temp);
	for ($i=0; $i<$len; $i++)
		$data.=sprintf("%02x",ord(substr($temp,$i,1)));
	return strtoupper($data);
}


	function hex2asc($temp) {
		 $len = strlen($temp);
		 for ($i=0;$i<$len;$i+=2) $data.=chr(hexdec(substr($temp,$i,2)));
		 return strtoupper($data);
	}


	function FillEmpty($temp,$length,$align) {
		while (strlen($temp) < $length) {
			if($align == "left") {
				$temp .= "20";
			}elseif($align == "right") {
				$temp = "20".$temp;
			}
		}
		return ($temp);
	}

	function IsIntern($customerid) {
		if ($customerid == "0") {
			return true;
			exit;
		} else {
			$sql		=	"SELECT * FROM customers WHERE id = " . $customerid;
			$result	= mysql_query($sql);
			$row = mysql_fetch_array($result,MYSQL_ASSOC);

			return $row['category'] == 'intern';
		}
	}


	function AddToLog($message, $stdout = false) {
		//CAW: TODO: Aus Config holen
		$logfile	= "/home/billing/logs/".date("Y-m-d").".log";
		$line			= $message."\n";
		$f				= fopen($logfile,"a");
		fputs($f,$line);
		fclose($f);

		if ($stdout) {
			echo $line;
		}
	}


	function microtime_float(){
		list($usec, $sec) = explode(" ", microtime());
		return ((float)$usec + (float)$sec);
	}

/**
 * Generiert drei Auswahllisten zur Auswahl eines Datums
 * @param string $praefix Präfix für die Feldnamen, die dann heißen praefix_tag, praefix_monat praefix_jahr
 * @param int $selectedTag vorausgewählter Tag
 * @param int $selectedMonat vorausgewählter Monat
 * @param int $selectedJahr vorausgewähltes Jahr
 * @return html HTML-Code
 */
function showDateSelect($praefix="", $selectedTag = 0, $selectedMonat = 0, $selectedJahr = 0) {

	if($selectedTag=="0"){ $selectedTag=date("d");}
	if($selectedMonat=="0"){ $selectedMonat=date("m");}
	if($selectedJahr=="0"){ $selectedJahr=date("Y");}
	$ausgabe.="
    	<select name=\"".$praefix."Tag\">";
	for ($i=1;$i<=31;$i++){
   		if($selectedTag == $i) {
   			$ausgabe.='<option selected>'.sprintf('%02d',$i).'</option>';
   		} else {
  			$ausgabe.='<option>'.sprintf('%02d',$i).'</option>';
   		}
	}
	$ausgabe.="</select>\n";

	$ausgabe.="<select name=\"".$praefix."Monat\">";
	for ($i=1;$i<=12;$i++){
   		if($selectedMonat == $i) {
   			$ausgabe.='<option selected>'.sprintf('%02d',$i).'</option>';
   		} else {
			$ausgabe.='<option>'.sprintf('%02d',$i).'</option>';
   		}
	}
	$ausgabe.="</select>\n";
	$ausgabe.="<select name=\"".$praefix."Jahr\">";
	for ($i=date("Y")-1;$i<=date("Y")+5;$i++){
   		if($selectedJahr == $i) {
   			$ausgabe.='<option selected>'.sprintf('%02d',$i).'</option>';
   		} else {
  				$ausgabe.='<option>'.sprintf('%02d',$i).'</option>';
   		}
	}
	$ausgabe.="</select>\n";
	return $ausgabe;

}
function showTimeSelect($praefix="",$selectedStunde=-1,$selectedMinute=-1, $increment=5){

   	if ($selectedStunde=="-1") { $selectedStunde=date("H");}
   	if ($selectedMinute=="-1") { $selectedMinute=date("i");}
   	$selectedMinute = floor($selectedMinute/$increment)*$increment;

   	$ausgabe="<select name=\"".$praefix."Stunde\">";
   	for ($i=0;$i<=23;$i++){
   		if($selectedStunde == $i) {
   			$ausgabe.='<option selected>'.sprintf('%02d',$i).'</option>';
   		} else {
  			$ausgabe.='<option>'.sprintf('%02d',$i).'</option>';
   		}
   	}
   	$ausgabe.="</select>\n";
   	$ausgabe.="<select name=\"".$praefix."Minute\">";
   	for ($i=0;$i<=59;$i+=$increment){
   		if($selectedMinute == $i) {
   			$ausgabe.='<option selected>'.sprintf('%02d',$i).'</option>';
   		} else {
  			$ausgabe.='<option>'.sprintf('%02d',$i).'</option>';
   		}
   	}
   	$ausgabe.="</select>\n";
   	return $ausgabe;
}

function showDestinationSelect($selectedDestination=0, $showLabel=true, $all=true) {

	$s = '';

	if ($showLabel) {
		$s .= '<label>Destination:</label>';
	}

	$s .= '<select name="destination">';

	if ($all) $s.='<option value="0">All Destinations</option>';

	$sql = "SELECT * FROM destinations WHERE customerid='".$_SESSION['login_customerid']."' ORDER BY destination";
	$res=mysql_query($sql);
	while($row=mysql_fetch_assoc($res)) {
		$s.='<option value="'.$row['id'].'" '.($selectedDestination ==$row['id'] ? 'selected="selected"' : '').'>'.$row['destination'].' (';
		//if($row['areacode']!="" && strpos($row['areacode'],",")>0) {
		if($row['areacode']!="" && strlen(trim($row['areacode'])) > 0) {
			if(substr($row['areacode'],-1)==",") $row['areacode']=substr($row['areacode'],0,strlen($row['areacode'])-1);
			$ac=explode(",",$row['areacode']);
			for ($i=0;$i<count($ac);$i++) {
				if($i==3) {
					$s.="...more";
					break;
				}
				$s.="+".$row['dialcode'].$ac[$i].",";
			}
			if(substr($s,-1)==",") $s=substr($s,0,strlen($s)-1);
		} else {
			//$s.="+".$row['dialcode'].$ac[$i];
			$s.="+".$row['dialcode'];
		}
		$s.=')</option>';
	}
	return $s.'</select>';
}


function GetAreaCodeString($dialcode, $areacodes, $max_len = 30) {

	if (strlen(trim($areacodes)) == 0)
		return '+'.$dialcode;

	foreach (explode(',', $areacodes) as $areacode) {

		$ac = '+'.$dialcode.trim($areacode);

		if ($ac_parts_len + strlen($ac) > $max_len) {
			$ac_parts[] = '..';
			break;
		}

		$ac_parts[] = $ac;
		$ac_parts_len += strlen($ac);

	}

	return implode(', ', $ac_parts);
}

function GetAreaCodeString2($areacodes, $max_len = 30) { // ohne dialcode

	if (strlen(trim($areacodes)) == 0)
		return '';

	$ac_parts_len = 0;

	foreach (explode(',', $areacodes) as $areacode) {

		$ac = trim($areacode);

		if ($ac_parts_len + strlen($ac) > $max_len) {
			$ac_parts[] = '...';
			break;
		}

		$ac_parts[] = $ac;
		$ac_parts_len += strlen($ac);

	}

	return implode(', ', $ac_parts);
}


function GetRouteIn($id) {
	$sql="Select route_in from routenames where routeorigin=$id";
	$res=mysql_query($sql);
	$row=mysql_fetch_row($res);
	return $row[0];
}
function GetRouteOut($id) {
	$sql="Select route_out from routenames where routeorigin=$id";
	$res=mysql_query($sql);
	$row=mysql_fetch_row($res);
	return $row[0];
}
function GetRouteInName($route_in) {
	$sql="Select provider,route_in,route_out from routenames where route_in='$route_in'";
	$res=mysql_query($sql);
	$row=mysql_fetch_row($res);
	return $row[0]!=''?$row[0]:$row[1].' / '.$row[2];
}
function GetRouteOutName($route_out) {
	$sql="Select provider,route_in,route_out,routeorigin from routenames where route_out='$route_out'";
	$res=mysql_query($sql);
	$row=mysql_fetch_row($res);
	return $row[0]!=''?$row[0].'  ('.$row[3].')':$row[1].' / '.$row[2].'  ('.$row[3].')';
}
function GetCustomerMachine($customerid) {
	$sql = "SELECT machine FROM customers WHERE id=$customerid";
	list($machine) = mysql_fetch_row(mysql_query($sql));
	return $machine;
}
function GetDestinationRow($routingcase, $machine = '') {
	if ($machine == '') {
		global $user_config;
		$machine = $user_config['machine'];
	}
	$sql="SELECT * FROM destinations WHERE routingcase='$routingcase' AND machine='$machine'";
	$res=mysql_query($sql);
	$row=mysql_fetch_assoc($res);
	return $row;
}


function GetNextRoutingcase($machine) {
	$sql = "SELECT IFNULL(MAX(routingcase)+1,1) AS routingcase FROM destinations WHERE machine=$machine";
#	$sql = "SELECT
#				IFNULL(MIN(d1.routingcase + 1),1) AS routingcase
#			FROM
#				destinations AS d1
#			LEFT JOIN
#				destinations AS d2 ON (d2.routingcase = (d1.routingcase + 1) AND d1.machine = d2.machine)
#			WHERE
#				d2.routingcase IS NULL AND
#				d1.machine = $machine";

	$res = mysql_query($sql);
//	echo $sql;
	$row = mysql_fetch_assoc($res);
	$lastroutingcase = $row['routingcase'];
	return $lastroutingcase;
}


function GetNextChargingCase($customerid) {
	$res = mysql_query("SELECT chargingcase FROM `destinations` WHERE customerid = $customerid AND chargingcase = 1");

	if (mysql_num_rows($res) == 0) {
		return '1';
	}


//	mysql_query('LOCK TABLES destinations WRITE');
	$sql = "SELECT  chargingcase + 1 AS nextchargingcase
			FROM    `destinations` AS d1
			WHERE   NOT EXISTS (
	        	SELECT  NULL
	        	FROM    `destinations` AS d2
	        	WHERE   d2.chargingcase = d1.chargingcase + 1
				AND		customerid = $customerid
	        )
			AND		customerid = $customerid
			ORDER BY
        		chargingcase
			LIMIT 1";
	$res = mysql_query($sql);
//	echo $sql;
	$row = mysql_fetch_assoc($res);
	return $row['nextchargingcase'];
//	mysql_query('UNLOCK TABLES');
}


function GetRecordtypName($recordtype) {
	$sql="SELECT * from recordtypes WHERE recordtype = '".$recordtype."'";
	$res=mysql_query($sql);
	$row=mysql_fetch_array($res);
	return $row["decoded"];
}
function GetDestinationName($destinationid) {
	$sql="SELECT destination from destinations WHERE id = ".trim($destinationid)."";
	$res=mysql_query($sql);
	$row=mysql_fetch_assoc($res);
	return $row["destination"];
}

function GetDestinationID($mybnumber,$mycustomerid){
	$sql = "SELECT * FROM destinations WHERE customerid = '".$mycustomerid."' ORDER BY dialcode, areacode";
	$result	= mysql_query($sql);
	while($row = mysql_fetch_array($result)) {
		if($row["areacode"] != "") {
			$explodeareacode = explode(",",$row["areacode"]);
			for ($ii=0;$ii<count($explodeareacode);$ii++) {
				if (strlen(trim($explodeareacode[$ii])) > 0) {
					$bnum_start[] = array(trim($row["dialcode"]).trim($explodeareacode[$ii]),$row["id"]);
				}
			}
		} else {
			$bnum_start[] =  array(trim($row["dialcode"]),$row["id"]);
		}
	}
	for ($ii=0;$ii<count($bnum_start);$ii++) {
		$temparray = $bnum_start[$ii];

		if(substr($mybnumber,0,strlen($temparray[0])) == $temparray[0]) {
			//echo $temparray[1]." = ".."<br />";
			$mydestination = $temparray[1];
		}

	}
	return $mydestination;
}
//#########################################################################################

// CAW: Neue Funtionen aus billing/show.php (demnächst aufteilen in verschiedene includes?)

function CheckPage($MaxPages) {
	if ((!is_numeric($_REQUEST["page"])) || $_REQUEST["page"] <= 0) {
		$_REQUEST["page"] = 1;
	} elseif ($_REQUEST["page"] > $MaxPages) {
		$_REQUEST["page"] = $MaxPages;
	}
}

function GetPagination($page, $num_pages, $skip) {
		global $RequestParams;

		//########## "first"-Link (erste Seite)
		if($page > 1) {
			//########## if überprüft, ob wir uns nicht auf der ersten Seite befinden
			$links[] = "<a href=\"".GetRequestString($RequestParams,array('page' => 1))."\">first</a>";
		}

		//########## "<<"-Link (eine Seite zurück)
		if($page > 2) {
			$links[] = "<a href=\"".GetRequestString($RequestParams,array('page' => $page-1))."\">previous</a>";
		}

		//########## "+100"-Link
		if($page > $skip) {
			$links[] = "<a href=\"".GetRequestString($RequestParams,array('page' => $page-$skip))."\">-$skip</a>";
		}
		$links[] = 'Page &nbsp;'.GetRequestForm($RequestParams,array('page'),'style="display:inline;"','<input type="text" name="page" size="4" value="'.$page.'">').'&nbsp; of '.$num_pages;

		//########## "+100"-Link
		if($page+$skip < $num_pages) {
			$links[] = "<a href=\"".GetRequestString($RequestParams,array('page' => $page+$skip))."\">+$skip</a>";
		}

		//########## ">>"-link (ein Seite weiter)
		if($page+1 < $num_pages) {
			$links[] = "<a href=\"".GetRequestString($RequestParams,array('page' => $page+1))."\">next</a>";
		}

		//########## "last"-link (zur letzten Seite)
		if($page < $num_pages) {
			$links[] = "<a href=\"".GetRequestString($RequestParams,array('page' => $num_pages))."\">last</a>";
		}

		//########## Zusammenfügen der einzelnen Links zu einem String
		return implode(" | ", $links);
	}


	// Erzeugt neuen Requeststring, alle werden 'durchgeschleift', $NewParams werden ersetzt
function GetRequestString($RequestParams, $NewParams = array(), $base = '') {

	foreach ($RequestParams as $Param) {
		if (array_key_exists($Param, $NewParams)) {
			$ausgabe[] = $Param.'='.$NewParams[$Param];
		} elseif (isset($_REQUEST[$Param]) and $_REQUEST[$Param] != '') {
			if (is_array($_REQUEST[$Param])) {
				foreach ($_REQUEST[$Param] as $key => $value) {
					$ausgabe[] = $Param.'%5B'.$key.'%5D='.$_REQUEST[$Param][$key];
				}
			} else {
				$ausgabe[] = $Param.'='.$_REQUEST[$Param];
			}
		}
	}
	return ( $base == '' ? $_SERVER['PHP_SELF'] : $base).'?'.implode('&amp;',$ausgabe);
}

// Erzeugt ein Form, alle sind 'hidden', $NewParams werden ausgelassen (müssen selber in $options definiert werden)
function GetRequestForm($RequestParams,$NewParams, $header, $options) {

	foreach ($RequestParams as $Param) {
		if (!in_array($Param,$NewParams)) {
			$ausgabe .= '<input type="hidden" name="'.$Param.'" value="'.$_REQUEST[$Param].'" />';
		}
	}
	return '<form '.$header.' action="'.$_SERVER["PHP_SELF"].'">'.$ausgabe.$options.'</form>';
}

/**
 * Erzeugt die Tabellenüberschriften in Abhängigkeit davon ob es als
 * HTML-Ausgabe (dann mit Links zur Sortierung nach der entsprechenden Spalte) oder
 * als Export dienen soll (dann nur die Überschrift)
 */
function OutputTableHeader($result, $fields, $tableHeader = '') {

	global $RequestParams;

	if($_REQUEST['action'] == "csv") {
		return (count($fields)>0) ? implode(';',Fields2Array($result, $fields, $tableHeader))."\r\n" : '';
	} else {
		$ausgabe .= '<table id="datatable"><tr>';
		foreach (Fields2Array($result, $fields, $tableHeader) as $feld=>$titel) {

			if (is_numeric($feld)) $feld++; // MySQL kann nach numerischm Index sortieren, fängt aber bei 1 an statt 0

			$pfeil = "";
			if($_REQUEST['orderFeld'] == $feld) {
				$direction = $_REQUEST['orderDirection']=="ASC"? "DESC" : "ASC";
				$pfeil = $_REQUEST['orderDirection']=="ASC" ?"(v)" : "(^)";
			} else {
				$direction = "ASC";
			}
			if($_REQUEST['action']=='export' || $_REQUEST['action']=='excel') {
				$ausgabe.="<th><b>$titel</b></th>";
			} else {
				$ausgabe.="<th><b><a href=\"".GetRequestString($RequestParams, array('orderFeld' => $feld, 'orderDirection' => $direction))."\">$titel $pfeil</a></b></th>";
			}
		}
		$ausgabe .= '</tr>';
	}
	return $ausgabe;
}

function Fields2Array($result, $fields, $tableHeader = '') {

	if (is_array($tableHeader)) {
		foreach ($fields as $field) {
			$fieldnames[mysql_field_name($result, $field)] = $tableHeader[mysql_field_name($result, $field)];
		}
	} else {
		foreach ($fields as $field) {
			$fieldnames[] = mysql_field_name($result, $field);
		}
	}
	return $fieldnames;
}

/*function show_sql($sql) {

	#static $count;

	global $user_config;

	if (!$user_config['debug'])
		return;

	include_once('php-dump.php');
	echo '<a id="show" href="#" onclick="javascript:document.getElementById(\'hide\').style.display = \'block\';document.getElementById(\'phpdump\').style.display = \'block\';this.style.display = \'none\';return false;">show sql</a>';
	echo '<a id="hide" style="display: none;" href="#" onclick="javascript:document.getElementById(\'show\').style.display = \'block\';document.getElementById(\'phpdump\').style.display = \'none\';this.style.display = \'none\';return false;">hide sql</a>';
	dumpq($sql);
	echo '<style>div#phpdump {display: none;}</style>';
}
*/

function show_sql($sql) {

	global $user_config;

	if (!isset($user_config['debug']) or !$user_config['debug']) {
		return;
	}

	include_once('geshi/geshi.php');

	$geshi = new GeSHi($sql, 'mysql');
	#$geshi->add_keyword(1, 'IFNULL');
	#$geshi->add_keyword(1, 'NULLIF');
	#$geshi->add_keyword(1, 'SUM');

	echo '<a id="show" href="#" onclick="javascript:document.getElementById(\'hide\').style.display = \'block\';document.getElementById(\'phpdump\').style.display = \'block\';this.style.display = \'none\';return false;">show sql</a>';
	echo '<a id="hide" style="display: none;" href="#" onclick="javascript:document.getElementById(\'show\').style.display = \'block\';document.getElementById(\'phpdump\').style.display = \'none\';this.style.display = \'none\';return false;">hide sql</a><pre id="phpdump" style="display: none;">';

	echo $geshi->parse_code();
	echo '</pre>';

}

function AddOrdinalSuffix($num) {
	//can handle negative numbers (-1st, -12th, -21st)

	$last2Digits = abs($num % 100);
	$lastDigit = $last2Digits % 10;

	//the only nonconforming set is numbers ending in <...eleventh, ...twelfth, ...thirteenth>

	return $num.substr("thstndrd", ($last2Digits > 10 && $last2Digits < 14) || $lastDigit > 3 ? 0 : $lastDigit * 2, 2);
}

function ShowMachineSelect($id = 'none') {
	$MachineSelect = '<select name="machine">';	//onChange="this.form.submit();"

	$sql ="SELECT id, name FROM machines ORDER BY id";
	$res = mysql_query($sql);
	if ($res && mysql_affected_rows()>0) {
		$MachineSelect .= '<option value="">Please Select</option>';
		while ($row = mysql_fetch_array($res)) {
			if ($row[0] == $id) {
				$MachineSelect .= "<option value=\"$row[0]\" selected>$row[1] ($row[0])</option>";
			} else {
				$MachineSelect .= "<option value=\"$row[0]\">$row[1] ($row[0])</option>";
			}
		}
	} else {
		$MachineSelect .= '<option value="">No machines defined!</option>';
	}
	return $MachineSelect .= "</select>\n";
}

function ShowCustomerSelect($id = 'none') {
	$CustomerSelect = '<select name="customer">';	//onChange="this.form.submit();"

	$sql ="SELECT id, company FROM customers ORDER BY company";
	$res = mysql_query($sql);
	if ($res && mysql_affected_rows()>0) {
		$CustomerSelect .= '<option value="">Please Select</option>';
		while ($row = mysql_fetch_array($res)) {
			if ($row[0] == $id) {
				$CustomerSelect .= "<option value=\"$row[0]\" selected>$row[1]</option>";
			} else {
				$CustomerSelect .= "<option value=\"$row[0]\">$row[1]</option>";
			}
		}
	} else {
		$CustomerSelect .= '<option value="">No Customers defined!</option>';
	}
	return $CustomerSelect .= "</select>\n";
}

function ShowRouteOriginSelect($machine = -1 , $customer = -1, $selected = 'none', $label = false, $filterRO99 = false) {

	if ($label)
		echo '<label>Routeorigin</label>';

	$RouteOriginSelect = '<select name="routeorigin">';	//onChange="this.form.submit();"

	$sql ="SELECT routeorigin, LEFT(GROUP_CONCAT(provider SEPARATOR ', '), 45) as provider FROM routenames ";

	if ($machine != -1) {
		$where[] = "machine=$machine";
	}
	
	if ($customer != -1) {
		$where[] = "customerid=$customer";
	}
	
	if ($filterRO99) {
		$where[] = "routeorigin != 99";
	}
	
	$where = implode(' AND ', $where);

	if ($where)
		$sql .="WHERE $where";

	$sql .= " GROUP BY routeorigin ORDER BY routeorigin";

	$res = mysql_query($sql);
	if ($res && mysql_affected_rows()>0) {
		$RouteOriginSelect .= '<option value="">Select Incoming Carrier</option>';
		while ($row = mysql_fetch_array($res)) {
			if ($row[0] == $selected) {
				$RouteOriginSelect .= "<option value=\"$row[0]\" selected>$row[1] ($row[0])</option>";
			} else {
				$RouteOriginSelect .= "<option value=\"$row[0]\">$row[1] ($row[0])</option>";
			}
		}
	} else {
		$RouteOriginSelect .= '<option value="">No Route Origins defined!</option>';
	}
	return $RouteOriginSelect .= "</select>\n";
}


/** Zeigt ein MySQL-Resultset "hübsch" an
 *
 */
function ShowTable($result, $format = '', $sortable = false, $vertical = false, $return = false) {

	//global $RequestParams;

	$num_fields = mysql_num_fields($result);

	// F�r jede Spalte kann ein Format angegeben werden, default: %s
	if ($format != '') {
		$formats = explode('|',$format);
		for ($i=0; $i<$num_fields; $i++) {
			if ($formats[$i] != '') {
				$fields[] = $i;
			}
		}
	} else {
		$formats = array_fill(0, mysql_num_fields($result), '%s');
		$fields = range(0, $num_fields-1);
	}



	$ausgabe = '<table id="datatable"><tr>';

	//mysql_field_name($result,0);


	foreach ($fields as $i) {
		$ausgabe .= '<th>'.mysql_field_name($result, $i).'</th>';
	}

	$ausgabe .= "</tr>\n";

	$oddrow = true;

	while ($row = mysql_fetch_row($result)) {
		$class = $oddrow ? 'odd' : 'even';
		$ausgabe .= '<tr class="'.$class.'"><td>'.implode($row,'</td><td>')."</td></tr>\n";
		$oddrow = !$oddrow;
	}
	$ausgabe .= "</table>\n";


/*
	foreach (Fields2Array($result, $fields, $tableHeader) as $feld=>$titel) {

			if (is_numeric($feld)) $feld++; // MySQL kann nach numerischem Index sortieren, f�ngt aber bei 1 an statt 0

			$pfeil = "";
			if ($_REQUEST['orderFeld'] == $feld) {
				$direction = $_REQUEST['orderDirection']=="ASC"? "DESC" : "ASC";
				$pfeil = $_REQUEST['orderDirection']=="ASC" ?"(v)" : "(^)";
			} else {
				$direction = "ASC";
			}
			if ($_REQUEST['action']=='export' || $_REQUEST['action']=='excel') {
				$ausgabe.="<th><b>$titel</b></th>";
			} else {
				$ausgabe.="<th><b><a href=\"".GetRequestString($RequestParams, array('orderFeld' => $feld, 'orderDirection' => $direction))."\">$titel $pfeil</a></b></th>";
			}
		}
		$ausgabe .= '</tr>';*/

	if ($return)
		return $ausgabe;
	else
		echo $ausgabe;

}

function db2screen($value, $type, $html = true) {

	global $user_config;

	switch ($type) {
		case 'currency':
			$class = $value < 0 ? ' class="minus"' : '';
			$value = number_format($value, 2, ',', '.');
			if ($html)
				return "<div$class style=\"text-align:right;width:100%;\">$value ".$user_config['currency']."</div>";
			else
				return "$value ".$user_config['currency'];

		case 'rate':
			$class = $value < 0 ? ' class="minus"' : '';
			$value = number_format($value, 4, ',', '.');
			if ($html)
				return "<div$class style=\"text-align:right;width:100%;\">$value ".$user_config['currency']."</div>";
			else
				return "$value ".$user_config['currency'];

		case 'price':
			$class = $value < 0 ? ' class="minus"' : '';
			$value = number_format($value, 4, ',', '.');
			if ($html)
				return "<span$class style=\"text-align:right;width:100%;\">$value ".$user_config['currency']."</span>";
			else
				return "$value ".$user_config['currency'];

		case 'seconds':
			$value = number_format($value, 0, ',', '.');
			if ($html)
				return "<div style=\"text-align:right;width:100%;\">$value sec</div>";
			else
				return "$value sec";

		case 'minutes':
			$value = number_format($value, 0, ',', '.');
			if ($html)
				return "<div style=\"text-align:right;width:100%;\">$value min</div>";
			else
				return "$value min";

		case 'acd':
			$value = floor($value/60).':'.sprintf('%02u', $value%60);
			if ($html)
				return "<div style=\"text-align:right;width:100%;\">$value</div>";
			else
				return "$value";

		case 'percent':
		case 'asr':
			if ($html)
				return "<div style=\"text-align:right;width:100%;\">".number_format($value, 2, ',', '.')."%</div>";
			else
				return number_format($value, 2, ',', '.')."%";

		case 'number':
			if ($html)
				return "<div style=\"text-align:right;width:100%;\">".str_replace('.', ',', $value)."</div>";
			else
				return str_replace('.', ',', $value);

		case 'rounded':
			$value = round($value);
			if ($html)
				return "<div style=\"text-align:right;width:100%;\">$value</div>";
			else
				return $value;

		default:
			return $value;
	}

}

function screen2db($value, $type) {
	switch ($type) {
		case 'currency':
		case 'price':
			$value = str_replace(',', '.', $value);
			return floatval($value);

		case 'percent':
			return intval($value);

	}
}

function mysql_errorhandler($sql='', $message = '', $return = false, $log = false) {
	
	if (is_resource($return)) {
		$link = $return;
		$return = false;
	} else {
		$link = null;
	}
	
	//$ausgabe = "<b>Database Error:</b><br>\n";
	$ausgabe = '';
	if ($message != '')
		$ausgabe .= "<b>Problem: </b>$message<br>\n";
	if ($sql != '')
		$ausgabe .= "<b>Query: </b><pre>".htmlentities($sql)."</pre><br>\n";

	if ($link) {
		$ausgabe .= "<b>MySQL: </b>(".mysql_errno($link).") - ".mysql_error($link)."<br>\n";
	} else {
		$ausgabe .= "<b>MySQL: </b>(".mysql_errno().") - ".mysql_error()."<br>\n";
	}
	
	if ($return)
		return $ausgabe;
	else
		echo $ausgabe;

}

/*
function makeBackup($customerID,$table) {
	$host = "localhost";
	$user = "web23";
	$pass = "christos";
	$database = "usr_web23_1";
	$folderCustomer = $_SERVER["DOCUMENT_ROOT"]."/backup/customers/";
	$timestamp = date("Ymd_His");

	system("/usr/bin/mysqldump -u".$user." -p".$pass." -h".$host." ".$database." ".$table." | /bin/gzip >".$folderCustomer."".$timestamp."_".$customerID.".sql.gz", $fp);

	if (($fp==0) && (false !== chmod("".$folderCustomer."".$timestamp."_".$customerID.".sql.gz", 0666))) {
		//echo "Backup erfolgreich erstellt!<br>";
		//echo "<a href=\"/backup/customers/".$timestamp.".sql.gz\">Download</a>";
		AddToLog("[".date("d.m.Y H:i:s")."] [Backup] Backup fuer den gel�schten Customer mit ID $customerID erfolgreich erstellt.");
		return true;
	} else {
		//echo "Fehler beim Erstellen des Backups!<br>";
		AddToLog("[".date("d.m.Y H:i:s")."] [Backup] Fehler beim Backup f�r den gel�schten Customer mit ID $customerID.");
		return false;
	}


}
*/

function validate_route($route) {

//	if (strlen($route) != 14) {
//		return false;
//	}

	return preg_match('|^[\dABCDEF]{14}$|', $route) == 1;

}

function OddEven($mod = 2) {
	static $count;

	return ++$count % $mod ? 'odd' : 'even';

}

function SelectFromEnum($table, $field, $default='', $name='', $label='') {

	if ($label)
		$output = "<label>$label</label><br>";

	if (!$name)
		$name = $table.'_'.$field;

	$output = '';

	$sql = "SHOW COLUMNS FROM `$table` LIKE '$field'";

	$result=mysql_query($sql);
	if (mysql_num_rows($result)>0) {
		$row=mysql_fetch_assoc($result);
		$options=explode("','",preg_replace("/(enum|set)\('(.+?)'\)/","\\2",$row['Type']));

		$output .= '<select name="'.$name.'">';
		foreach ($options as $option) {
			if ($option == $default) {
				$output .= "<option selected>$option</option>";
			} else {
				$output .= "<option>$option</option>";
			}
		}
		return $output.'</select>';
	}
	return "$table.$field is not an ENUM or SET";
}

function GetRoutesNames($customerid, $field) {
	$_data = array();
	$sql = "SELECT DISTINCT(".$field."), provider FROM routenames WHERE customerid = ".$customerid." ORDER BY route_in";
	$result	= mysql_query($sql);
	while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
		$_data[$row['provider']] = $row[$field];
	}
	return $_data;
}

function ShowRouteSelect($CustomerID, $RouteInOut) {
	// onChange="this.form.submit();"
	$RouteSelect = '<select name="'.$RouteInOut.'">';
	$RouteSelect .= '<option value="">Please Select</option>';
	foreach (GetRoutesNames($CustomerID, $RouteInOut) as $RouteName => $RouteHex) {
		if ($RouteHex == $_REQUEST[$RouteInOut]) {
			$RouteSelect .= "<option value=\"$RouteHex\" selected>$RouteName</option>";
		} else {
			$RouteSelect .= "<option value=\"$RouteHex\">$RouteName</option>";
		}
	}
	return $RouteSelect .= "</select>\n";
}

function GetCarrierNames($customerid, $field) {
	$_data = array();
	$sql = "SELECT carriers.id, carriers.name FROM carriers INNER JOIN routenames ON (carriers.id = routenames.carrier AND carriers.customerid = routenames.customerid) WHERE carriers.customerid = ".$customerid." ORDER BY carriers.name";
	$result	= mysql_query($sql);
	while ($row = mysql_fetch_assoc($result)) {
		$_data[$row['id']] = $row['name'];
	}
	return $_data;
}

function ShowCarrierSelect($CustomerID, $CarrierInOut) {
	// onChange="this.form.submit();"
	$RouteSelect = '<select name="'.$CarrierInOut.'">';
	$RouteSelect .= '<option value="">Please Select</option>';
	foreach (GetCarrierNames($CustomerID, $CarrierInOut) as $CarrierID => $CarrierName) {
		if ($CarrierID == $_REQUEST[$CarrierInOut]) {
			$RouteSelect .= "<option value=\"$CarrierID\" selected>$CarrierName</option>";
		} else {
			$RouteSelect .= "<option value=\"$CarrierID\">$CarrierName</option>";
		}
	}
	return $RouteSelect .= "</select>\n";
}

function GetVoipCarrierNames($customerid, $field) {
	$_data = array();
	$sql = "SELECT carriers.id, carriers.name 
			FROM carriers 
			INNER JOIN tb_naps ON (carriers.id = tb_naps.carrier AND carriers.customerid = tb_naps.customer_id) 
			WHERE carriers.customerid = ".$customerid." ORDER BY carriers.name";
	$result	= mysql_query($sql);
	while ($row = mysql_fetch_assoc($result)) {
		$_data[$row['id']] = $row['name'];
	}
	return $_data;
}

function ShowVoipCarrierSelect($CustomerID, $CarrierInOut) {
	// onChange="this.form.submit();"
	$RouteSelect = '<select name="'.$CarrierInOut.'">';
	$RouteSelect .= '<option value="">Please Select</option>';
	foreach (GetVoipCarrierNames($CustomerID, $CarrierInOut) as $CarrierID => $CarrierName) {
		if ($CarrierID == $_REQUEST[$CarrierInOut]) {
			$RouteSelect .= "<option value=\"$CarrierID\" selected>$CarrierName</option>";
		} else {
			$RouteSelect .= "<option value=\"$CarrierID\">$CarrierName</option>";
		}
	}
	return $RouteSelect .= "</select>\n";
}

function mysql_evaluate($query, $default_value="undefined") {
   $result = mysql_query($query);
   if (!($result)) mysql_errorhandler($query, 'mysql_evaluate failed.');

   if (mysql_num_rows($result)==0)
       return $default_value;
   else
       return mysql_result($result,0);
}

function mysql_evaluate_array($query) {
   $result = mysql_query($query);
   if (!($result)) mysql_errorhandler($query, 'mysql_evaluate_array failed.');
   $values = array();
   for ($i=0; $i<mysql_num_rows($result); ++$i)
       array_push($values, mysql_result($result,$i));
   return $values;
}

function mysql_evaluate_assoc($query) {
   $result = mysql_query($query);
   if (!($result)) mysql_errorhandler($query, 'mysql_evaluate_asssoc failed.');
   $values = array();
	while ($row = mysql_fetch_assoc($result)) {
		$values[] = $row; 
	} 

   return $values;
}

function mysql_evaluate_row($query) {
   $result = mysql_query($query);
   if (!($result)) mysql_errorhandler($query, 'mysql_evaluate_row failed.');
   $values = array();
   return mysql_fetch_assoc($result);
}

function TruncateString($strString, $nLength = 15, $strTrailing = "...") {
        // Take off chars for the trailing
        $nLength -= strlen($strTrailing);
        if (strlen($strString) > $nLength)
        {
                // -- String exceeded length, truncate and add trailing dots
                return substr($strString, 0, $nLength) . $strTrailing;
        }
        else
        {
                // -- String was already short enough, return the string
                return $strString;
        }
}



/**
 * OpenSSL-style passwords, shared between anyXess and ProFTPd
 *
 * @package  anyxess
 * @link http://www.castaglia.org/proftpd/doc/contrib/ProFTPD-mini-HOWTO-SQL.html ProFTPd and mod_sql mini howto
 * @param string $password
 * @return string encoded password
 */
function encode_password($password) {
	return '{md5}' . base64_encode(pack("H*", md5($password)));
}

function si_prefix($number, $precision = 3) {

	$prefixes = array ('', 'K', 'M', 'G', 'T', 'P', 'E', 'Z', 'Y');

	$div = 1000;

	$exp = 0;

	while ($number >= $div) {

		$number /= $div;
		$exp++;

	}

	$n1 = floor($number);
	$n2 = substr($number - $n1, 2, $precision - strlen($n1));

	if ($n2 != '') {
		$number = $n1 . '.' . $n2;
	} else {
		$number = $n1;
	}

	return $number . ' ' . $prefixes[$exp];

}

function errorHandler($errno, $errstr='', $errfile='', $errline='')
{
    // if error has been supressed with an @
    if (error_reporting() == 0) {
        return;
    }

    global $conf;

    // check if function has been called by an exception
    if(func_num_args() == 5) {
        // called by trigger_error()
        $exception = null;
        list($errno, $errstr, $errfile, $errline) = func_get_args();

        $backtrace = array_reverse(debug_backtrace());

    }else {
        // caught exception
        $exc = func_get_arg(0);
        $errno = $exc->getCode();
        $errstr = $exc->getMessage();
        $errfile = $exc->getFile();
        $errline = $exc->getLine();

        $backtrace = $exc->getTrace();
    }

    $errorType = array (
               E_ERROR            => 'ERROR',
               E_WARNING        => 'WARNING',
               E_PARSE          => 'PARSING ERROR',
               E_NOTICE         => 'NOTICE',
               E_CORE_ERROR     => 'CORE ERROR',
               E_CORE_WARNING   => 'CORE WARNING',
               E_COMPILE_ERROR  => 'COMPILE ERROR',
               E_COMPILE_WARNING => 'COMPILE WARNING',
               E_USER_ERROR     => 'USER ERROR',
               E_USER_WARNING   => 'USER WARNING',
               E_USER_NOTICE    => 'USER NOTICE',
               E_STRICT         => 'STRICT NOTICE',
               E_RECOVERABLE_ERROR  => 'RECOVERABLE ERROR'
               );

    // create error message
    if (array_key_exists($errno, $errorType)) {
        $err = $errorType[$errno];
    } else {
        $err = 'CAUGHT EXCEPTION';
    }

    $errMsg = "$err: $errstr in $errfile on line $errline";

    // start backtrace
    foreach ($backtrace as $v) {

        if (isset($v['class'])) {

            $trace = 'in class '.$v['class'].'::'.$v['function'].'(';

            if (isset($v['args'])) {
                $separator = '';

                foreach($v['args'] as $arg ) {
                    $trace .= "$separator".getArgument($arg);
                    $separator = ', ';
                }
            }
            $trace .= ')';
        }

        elseif (isset($v['function']) && empty($trace)) {
            $trace = 'in function '.$v['function'].'(';
            if (!empty($v['args'])) {

                $separator = '';

                foreach($v['args'] as $arg ) {
                    $trace .= "$separator".getArgument($arg);
                    $separator = ', ';
                }
            }
            $trace .= ')';
        }
    }

    // display error msg, if debug is enabled
    if($conf['error_debug'] == 1) {
        echo '<h2>Debug Msg</h2>'.nl2br($errMsg).'<br />
            Trace: '.nl2br($trace).'<br />';
    }

    // what to do
    switch ($errno) {
        case E_NOTICE:
        case E_USER_NOTICE:
            return;
            break;

        default:
            if($conf['debug'] == 0){
                // send email to admin
                if(!empty($conf['adminEmail'])) {
                    @mail($conf['adminEmail'],'critical error on '.$_SERVER['HTTP_HOST'], $errorText,
                            'From: Error Handler');
                }
                // end and display error msg
                exit(displayClientMessage());
            }
            else
                exit('<p>aborting.</p>');
            break;

    }

} // end of errorHandler()

#set_error_handler('errorHandler');

function displayClientMessage()
{
    echo 'some html page with error message';

}

function getArgument($arg)
{
    switch (strtolower(gettype($arg))) {

        case 'string':
            return( '"'.str_replace( array("\n"), array(''), $arg ).'"' );

        case 'boolean':
            return (bool)$arg;

        case 'object':
            return 'object('.get_class($arg).')';

        case 'array':
            $ret = 'array(';
            $separtor = '';

            foreach ($arg as $k => $v) {
                $ret .= $separtor.getArgument($k).' => '.getArgument($v);
                $separtor = ', ';
            }
            $ret .= ')';

            return $ret;

        case 'resource':
            return 'resource('.get_resource_type($arg).')';

        default:
            return var_export($arg, true);
    }
}


function ConvertBool($value) {
	if ($value == 'YES') {
		return true;
	} elseif ($value == 'NO') {
		return false;
	}

	die("ERROR: unknown bool value: '$value'");

}

function getfiles_config($machine, $cred_type) {
	#$cred_type = 'axe+ftp';
	#$cred_type = 'telnet';

	$result	= mysql_query("SELECT 
								machine, host, port, user, password, local_path, remote_path, axe_file, axe_vol1, axe_destination, delete_threshold_percent, delete_threshold_files 
							FROM 
								cfg_getfiles
							INNER JOIN
								machines ON (cfg_getfiles.machine = machines.id) 
							WHERE 
								type='$cred_type' 
								AND machine=" . $machine);

	if (mysql_num_rows($result) != 1) {
	        AddToLog("[".gmdate("d.m.Y H:i:s")."] No config defined in cfg_getfiles for \$cred_type = '" . $cred_type . '\' and $machine = ' . $machine, true);
	        exit();
	}

	$config = mysql_fetch_assoc($result);

	return $config;

}

function GetShowHideBlock($content, $show = '', $hide = '') {

	static $i;

	if (!is_numeric($i)) {
		$i = 1;
	} else {
		$i++;
	}

	if ($show != '' and $hide == '') {
		$hide = $show = $show . '...';
	}

	if ($show == '') {
		$show = 'Show...';
	}

	if ($hide == '') {
		$hide = 'Hide...';
	}

	return '<a id="showlink_' . $i . '" href="#" onclick="javascript:document.getElementById(\'hideblock_' . $i . '\').style.display = \'block\';document.getElementById(\'hidelink_' . $i . '\').style.display = \'block\';this.style.display = \'none\';return false;">' . $show . '</a><a id="hidelink_' . $i . '" style="display: none;" href="#" onclick="javascript:document.getElementById(\'showlink_' . $i . '\').style.display = \'block\';document.getElementById(\'hideblock_' . $i . '\').style.display = \'none\';this.style.display = \'none\';return false;">' . $hide . '</a>
<div id="hideblock_' . $i . '" style="display:none;">
' . $content . '
</div>';
}

function get_lock($lock = 'all') {

	global $mysql_local;

	$lock_name = mysql_real_escape_string('anyxess.' . basename($_SERVER['SCRIPT_FILENAME']) . '.' . $lock);

	$sql = 'SELECT GET_LOCK("' . $lock_name . '", 0) AS status';

	$result = mysql_query($sql, $mysql_local);

	if (!$result) {
	    die("Invalid query: '$sql'\nError: " . mysql_error() . "\n");
	}

	$status = mysql_fetch_assoc($result);

	if ($status['status'] !== '1') {
		#echo "Error: lock '$lock_name' could not be locked:" . mysql_error() . "\n";
		return false;
	}

	register_shutdown_function('release_lock', $lock_name);

	return true;

}

function release_lock($lock_name) {

	global $mysql_local;

	#echo "release_lock($lock_name);\n";

	$sql = 'SELECT RELEASE_LOCK("' . $lock_name . '") AS status';

	$result = mysql_query($sql, $mysql_local);

	if (!$result) {
	    die("Invalid query: '$sql'\nError: " . mysql_error($mysql_local) . "\n");
	}

	$status = mysql_fetch_assoc($result);

	if ($status['status'] !== '1') {
		echo "Error: lock '$lock_name' could not be released:" . mysql_error($mysql_local) . "\n";
	}

}

function getMachineStats($machine_id = null) {
	
	if ($machine_id == null) {
	
		$sql = 'SELECT id FROM machines ORDER BY id';
		
		$result = mysql_query($sql);
		
		$machines = array();
		
		while ($row = mysql_fetch_assoc($result)) {
			$machines[] = $row; 
		}
	} else {
		$machines = array(array('id' => $machine_id));
	}
	
	$return = array();
		
	foreach ($machines as $machine) {
		
		$stats = array();
		
		$stats['machine'] = $machine['id'];
		
		$path = '/home/billing/ttfiles/m' . $machine['id'];
	
		if (!is_dir($path)) {
			#trigger_error("Not a valid path: '$path'", E_USER_NOTICE);
			$return[$machine['id']] = array('machine' => $machine['id'], 'files' => 0, 'size' => 0, 'lag' => 0, 'recent' => -1);
			continue;
		}
		
		$files = glob($path . '/????_*');
		
		$file_count = 0;
		$size_count = 0;
		$timestamp = PHP_INT_MAX; 
		
		foreach ($files as $file) {
			$file_count++;
			$size_count += filesize($file);
			if ($timestamp > filemtime($file)) {
				$timestamp = filemtime($file);
			}
		}
	
		$stats['files'] = $file_count;
		
		if ($file_count) {
			$stats['size'] = $size_count;
			$stats['lag'] = time() - $timestamp;
		} else {
			$stats['size'] = 0;
			$stats['lag'] = 0;
		}

		$recent = mysql_evaluate("SELECT UNIX_TIMESTAMP(MAX(last_modified)) FROM ttfiles WHERE machine = {$machine['id']}");
		
		if ($recent != 'undefined') {
			$stats['recent'] = time() - $recent;	
		} else {
			$stats['recent'] = -1;
		}
		
		
		$return[$machine['id']] = $stats;
	}
	
	if ($machine_id == null) {
		return $return;
	} else {
		return $return[$machine_id];
	}
}

/**
 * Get ISO-formatted retain date
 * 
 * Returns the first timestamp up to which CDRs are retained,
 * older CDRs are to be deleted.
 * 
 * Currently 3 whole month
 * 
 * @return string ISO-formatted date
 */
function get_retain_date() {
	return date('Y-m-d H:i:s', mktime(23, 59, 59, date('m') - 3, 0, date('Y')));
}


/*
function getLinuxReturnCode($code) {

	if (!is_integer($code)) {
		return false;	
	}
	
	$linux_returncodes = array(
		 1 => 'HUP - Hangup',
		 2 => 'INT - Interrupt',
		 3 => 'QUIT - Quit',
		 4 => 'ILL - Illegal instruction',
		 5 => 'TRAP - Trace trap',
		 6 => 'ABRT - Abort',
		 7 => 'BUS - Bus error',
		 8 => 'FPE - Floating point exception',
		 9 => 'KILL - Killed',
		10 => 'USR1 - User defined signal 1',
		11 => 'SEGV - Memory fault',
		12 => 'USR2 - User defined signal 2',
		13 => 'PIPE - Broken pipe',
		14 => 'ALRM - Alarm clock',
		15 => 'TERM - Terminated',
		16 => 'STKFLT - Stack fault',
		17 => 'CHLD - Child exited',
		18 => 'CONT - Continued',
		19 => 'STOP - Stopped (signal)',
		20 => 'TSTP - Stopped',
		21 => 'TTIN - Stopped (tty input)',
		22 => 'TTOU - Stopped (tty output)',
		23 => 'URG - Urgent I/O condition',
		24 => 'XCPU - CPU time limit exceeded',
		25 => 'XFSZ - File size limit exceeded',
		26 => 'VTALRM - Virtual timer expired',
		27 => 'PROF - Profiling timer expired',
		28 => 'WINCH - Window size change',
		29 => 'POLL - I/O possible',
		30 => 'PWR - Power-fail/Restart',
		31 => 'SYS'
	);
	
	if (isset($linux_returncodes[$code])) {
		return $linux_returncodes[$code];
	}
		
	return "Unknown Signal $code";
}


function getReturnCode($code, $custom_codes = array()) {
	
	
	if (isset($custom_codes[$code])) {
		return $custom_codes[$code];
	}
	
	$code -= 128;
		
	return getLinuxReturnCode($code);
	
}
*/

function get_application_mode($attribute = '') {
	
	static $application_mode;
	
	// interactive
	// cron
	// web
	
	if (!$application_mode) {
		
		// check $_SERVER
		
		// $sapi = php_sapi_name();
		
		// posix_isatty(STDOUT)
		
	}
	
}

function cprint($string) {
	
	# https://github.com/etopian/php-cli-framework/blob/master/cli.php
	
	if (php_sapi_name() != 'cli') {
		return;
	}
	
	$time = date('H:i:s');
	
	echo "[$time] $string\n";
	
}

function debug_cprint($string) {
	
	static $debug = false;
	
	if ($string === true) {
		$debug = true;
		return;
	}
	
	if ($debug) {
		cprint($string);
	}
}



function parseDbUri($connection_string) {
	
	// mysql://username:password@hostname:port/database/tablename
	
	// Regex: '~mysql://([^:@/]*):?([^@/]*)@?([^/]*)/?([^/]*)~';
	
	$parts = parse_url($connection_string);

	$path = $parts['path'];
	unset ($parts['path']);
	$path = trim($path, '/');
#echo $path . strpos('/', $path) . "\n";exit;	
	if (($pos = strpos($path, '/')) !== false) {
		$parts['db'] = substr($path, 0, $pos);
		$parts['table'] = substr($path, $pos + 1);
	} else {
		$parts['db'] = $path;
	}
	
	if (!isset($parts['port'])) {
		$parts['port'] = 3306;
	}
	
	return $parts;
	
}