JFIFXX    $.' ",#(7),01444'9=82<.342  2!!22222222222222222222222222222222222222222222222222"4 ,PG"Z_4˷kjزZ,F+_z,© zh6٨icfu#ډb_N?wQ5-~I8TK<5oIv-k_U_~bMdӜUHh?]EwQk{_}qFW7HTՑYF?_'ϔ_Ջt=||I 6έ"D/[k9Y8ds|\Ҿp6Ҵ].6znopM[mei$[soᘨ˸ nɜG-ĨUycP3.DBli;hjx7Z^NhN3u{:jx힞#M&jL P@_ P&o89@Sz6t7#Oߋ s}YfTlmrZ)'Nk۞pw\Tȯ?8`Oi{wﭹW[r Q4F׊3m&L=h3z~#\l :F,j@ ʱwQT8"kJO6֚l}R>ډK]y&p}b;N1mr$|7>e@BTM*-iHgD) Em|ؘbҗaҾt4oG*oCNrPQ@z,|?W[0:n,jWiEW$~/hp\?{(0+Y8rΟ+>S-SVN;}s?. w9˟<Mq4Wv'{)01mBVW[8/< %wT^5b)iM pgN&ݝVO~qu9 !J27$O-! :%H ـyΠM=t{!S oK8txA& j0 vF Y|y ~6@c1vOpIg4lODL Rcj_uX63?nkWyf;^*B @~a`Eu+6L.ü>}y}_O6͐:YrGXkGl^w~㒶syIu! W XN7BVO!X2wvGRfT#t/?%8^WaTGcLMI(J1~8?aT ]ASE(*E} 2#I/׍qz^t̔bYz4xt){ OH+(EA&NXTo"XC')}Jzp ~5}^+6wcQ|LpdH}(.|kc4^"Z?ȕ a<L!039C EuCFEwç ;n?*oB8bʝ'#RqfM}7]s2tcS{\icTx;\7KPʇ Z O-~c>"?PEO8@8GQgaՎ󁶠䧘_%#r>1zaebqcPѵn#L =׀t L7`VA{C:ge@w1 Xp3c3ġpM"'-@n4fGB3DJ8[JoߐgK)ƛ$ 83+ 6ʻ SkI*KZlT _`?KQKdB`s}>`*>,*@JdoF*弝O}ks]yߘc1GV<=776qPTtXԀ!9*44Tހ3XΛex46YD  BdemDa\_l,G/֌7Y](xTt^%GE4}bTڹ;Y)BQu>J/J ⮶.XԄjݳ+Ed r5_D1 o Bx΢#<W8R6@gM. drD>(otU@x=~v2 ӣdoBd3eO6㣷ݜ66YQz`S{\P~z m5{J/L1xO\ZFu>ck#&:`$ai>2ΔloF[hlEܺΠk:)` $[69kOw\|8}ބ:񶐕IA1/=2[,!.}gN#ub ~݊}34qdELc$"[qU硬g^%B zrpJru%v\h1Yne`ǥ:gpQM~^Xi `S:V29.PV?Bk AEvw%_9CQwKekPؠ\;Io d{ ߞoc1eP\ `E=@KIRYK2NPlLɀ)&eB+ь( JTx_?EZ }@ 6U뙢طzdWIn` D噥[uV"G&Ú2g}&m?ċ"Om# {ON"SXNeysQ@FnVgdX~nj]J58up~.`r\O,ư0oS _Ml4kv\JSdxSW<AeIX$Iw:Sy›R9Q[,5;@]%u@ *rolbI  +%m:͇ZVủθau,RW33 dJeTYE.Mϧ-oj3+yy^cVO9NV\nd1 !͕_)av;թMlWR1)ElP;yوÏu 3k5Pr6<⒲l!˞*u־n!l:UNW %Chx8vL'X@*)̮ˍ D-M+JUkvK+x8cY?Ԡ~3mo|u@[XeYC\Kpx8oCC&N~3-H MXsu<`~"WL$8ξ3a)|:@m\^`@ҷ)5p+6p%i)P Mngc#0AruzRL+xSS?ʮ}()#tmˇ!0}}y$6Lt;$ʳ{^6{v6ķܰgVcnn ~zx«,2u?cE+ȘH؎%Za)X>uWTzNyosFQƤ$*&LLXL)1" LeOɟ9=:tZcŽY?ӭVwv~,Yrۗ|yGaFC.+ v1fήJ]STBn5sW}y$~z'c 8  ,! pVNSNNqy8z˱A4*'2n<s^ǧ˭PJޮɏUGLJ*#i}K%,)[z21z ?Nin1?TIR#m-1lA`fT5+ܐcq՝ʐ,3f2Uեmab#ŠdQy>\)SLYw#.ʑf ,"+w~N'cO3FN<)j&,- љ֊_zSTǦw>?nU仆Ve0$CdrP m׈eXmVu L.bֹ [Դaզ*\y8Է:Ez\0KqC b̘cөQ=0YsNS.3.Oo:#v7[#߫ 5܎LEr49nCOWlG^0k%;YߝZǓ:S#|}y,/kLd TA(AI$+I3;Y*Z}|ӧOdv..#:nf>>ȶITX 8y"dR|)0=n46ⲑ+ra ~]R̲c?6(q;5% |uj~z8R=XIV=|{vGj\gcqz؋%Mߍ1y#@f^^>N#x#۹6Y~?dfPO{P4Vu1E1J *|%JN`eWuzk M6q t[ gGvWIGu_ft5j"Y:Tɐ*; e54q$C2d} _SL#mYpO.C;cHi#֩%+) ӍƲVSYźg |tj38r|V1#;.SQA[S#`n+$$I P\[@s(EDzP])8G#0B[ىXIIq<9~[Z멜Z⊔IWU&A>P~#dp]9 "cP Md?٥Ifتuk/F9c*9Ǎ:ØFzn*@|Iށ9N3{'['ͬҲ4#}!V Fu,,mTIkv C7vB6kT91*l '~ƞFlU'M ][ΩũJ_{iIn$L jOdxkza۪#EClx˘oVɞljr)/,߬hL#^Lф,íMƁe̩NBLiLq}(q6IçJ$WE$:=#(KBzђ xlx?>Պ+>W,Ly!_DŌlQ![ SJ1ƐY}b,+Loxɓ)=yoh@꥟/Iѭ=Py9 ۍYӘe+pJnϱ?V\SO%(t =?MR[Șd/ nlB7j !;ӥ/[-A>dNsLj ,ɪv=1c.SQO3UƀܽE̻9GϷD7(}Ävӌ\y_0[w <΍>a_[0+LF.޺f>oNTq;y\bՃyjH<|q-eɏ_?_9+PHp$[uxK wMwNی'$Y2=qKBP~Yul:[<F12O5=d]Ysw:ϮEj,_QXz`H1,#II dwrP˂@ZJVy$\y{}^~[:NߌUOdؾe${p>G3cĖlʌ ת[`ϱ-WdgIig2 }s ؤ(%#sS@~3XnRG~\jc3vӍLM[JBTs3}jNʖW;7ç?=XF=-=qߚ#='c7ڑWI(O+=:uxqe2zi+kuGR0&eniT^J~\jyp'dtGsO39* b#Ɋ p[BwsT>d4ۧsnvnU_~,vƜJ1s QIz)(lv8MU=;56Gs#KMP=LvyGd}VwWBF'à ?MHUg2 !p7Qjڴ=ju JnA suMeƆҔ!)'8Ϣٔޝ(Vpצ֖d=ICJǠ{qkԭ߸i@Ku|p=..*+xz[Aqġ#s2aƊRR)*HRsi~a &fMP-KL@ZXy'x{}Zm+:)) IJ-iu ܒH'L(7yGӜq j 6ߌg1go,kرtY?W,pefOQS!K۟cҒA|սj>=⬒˧L[ ߿2JaB~Ru:Q] 0H~]7ƼI(}cq 'ήETq?fabӥvr )o-Q_'ᴎoK;Vo%~OK *bf:-ťIR`B5!RB@ï u ̯e\_U_ gES3QTaxU<~c?*#]MW,[8Oax]1bC|踤Plw5V%){t<d50iXSUm:Z┵i"1^B-PhJ&)O*DcWvM)}Pܗ-q\mmζZ-l@}aE6F@&Sg@ݚM ȹ 4#p\HdYDoH"\..RBHz_/5˘6KhJRPmƶim3,#ccoqa)*PtRmk7xDE\Y閣_X<~)c[[BP6YqS0%_;Àv~| VS؇ 'O0F0\U-d@7SJ*z3nyPOm~P3|Yʉr#CSN@ ƮRN)r"C:: #qbY. 6[2K2uǦHYRQMV G$Q+.>nNHq^ qmMVD+-#*U̒ p욳u:IBmPV@Or[b= 1UE_NmyKbNOU}the`|6֮P>\2PVIDiPO;9rmAHGWS]J*_G+kP2KaZH'KxWMZ%OYDRc+o?qGhmdSoh\D|:WUAQc yTq~^H/#pCZTI1ӏT4"ČZ}`w#*,ʹ 0i課Om*da^gJ݅{le9uF#Tֲ̲ٞC"qߍ ոޑo#XZTp@ o8(jdxw],f`~|,s^f1t|m򸄭/ctr5s79Q4H1꠲BB@l9@C+wpxu£Yc9?`@#omHs2)=2.ljg9$YS%*LRY7Z,*=䷘$armoϰUW.|rufIGwtZwo~5 YյhO+=8fF)W7L9lM̘·Y֘YLf큹pRF99.A "wz=E\Z'a 2Ǚ#;'}G*l^"q+2FQ hjkŦ${ޮ-T٭cf|3#~RJt$b(R(rdx >U b&9,>%E\ Άe$'q't*אެb-|dSBOO$R+H)܎K1m`;J2Y~9Og8=vqD`K[F)k[1m޼cn]skz$@)!I x՝"v9=ZA=`Ɠi :E)`7vI}dYI_ o:obo 3Q&D&2= Ά;>hy.*ⅥSӬ+q&j|UƧ}J0WW< ۋS)jQRjƯrN)Gű4Ѷ(S)Ǣ8iW52No˓ ۍ%5brOnL;n\G=^UdI8$&h'+(cȁ߫klS^cƗjԌEꭔgFȒ@}O*;evWVYJ\]X'5ղkFb 6Ro՜mi Ni>J?lPmU}>_Z&KKqrIDՉ~q3fL:Se>E-G{L6pe,8QIhaXaUA'ʂs+טIjP-y8ۈZ?J$WP Rs]|l(ԓsƊio(S0Y 8T97.WiLc~dxcE|2!XKƘਫ਼$((6~|d9u+qd^389Y6L.I?iIq9)O/뚅OXXVZF[یgQLK1RҖr@v#XlFНyS87kF!AsM^rkpjPDyS$Nqnxҍ!Uf!ehi2m`YI9r6 TFC}/y^Η5d'9A-J>{_l+`A['յϛ#w:݅%X}&PStQ"-\縵/$ƗhXb*yBS;Wջ_mcvt?2}1;qSdd~u:2k52R~z+|HE!)Ǟl7`0<,2*Hl-x^'_TVgZA'j ^2ΪN7t?w x1fIzC-ȖK^q;-WDvT78Z hK(P:Q- 8nZ܃e貾<1YT<,"6{/ ?͟|1:#gW>$dJdB=jf[%rE^il:BxSּ1հ,=*7 fcG#q eh?27,!7x6nLC4x},GeǝtC.vS F43zz\;QYC,6~;RYS/6|25vTimlv& nRh^ejRLGf? ۉҬܦƩ|Ȱ>3!viʯ>vオX3e_1zKȗ\qHS,EW[㺨uch⍸O}a>q6n6N6qN ! 1AQaq0@"2BRb#Pr3C`Scst$4D%Td ?Na3mCwxAmqmm$4n淿t'C"wzU=D\R+wp+YT&պ@ƃ3ޯ?AﶂaŘ@-Q=9Dռѻ@MVP܅G5fY6# ?0UQ,IX(6ڵ[DIMNލc&υj\XR|,4 jThAe^db#$]wOӪ1y%LYm뭛CUƃߜ}Cy1XνmF8jI]HۺиE@Ii;r8ӭVFՇ| &?3|xBMuSGe=Ӕ#BE5GY!z_eqр/W>|-Ci߇t1ޯќdR3ug=0 5[?#͏qcfH{ ?u=??ǯ}ZzhmΔBFTWPxs}G93 )gGR<>r h$'nchPBjJҧH -N1N?~}-q!=_2hcMlvY%UE@|vM2.Y[|y"EïKZF,ɯ?,q?vM 80jx";9vk+ ֧ ȺU?%vcVmA6Qg^MA}3nl QRNl8kkn'(M7m9وq%ޟ*h$Zk"$9: ?U8Sl,,|ɒxH(ѷGn/Q4PG%Ա8N! &7;eKM749R/%lc>x;>C:th?aKXbheᜋ^$Iհ hr7%F$EFdt5+(M6tÜUU|zW=aTsTgdqPQb'm1{|YXNb P~F^F:k6"j! Ir`1&-$Bevk:y#ywI0x=D4tUPZHڠ底taP6b>xaQ# WeFŮNjpJ* mQN*I-*ȩFg3 5Vʊɮa5FO@{NX?H]31Ri_uѕ 0 F~:60p͈SqX#a5>`o&+<2D: ڝ$nP*)N|yEjF5ټeihyZ >kbHavh-#!Po=@k̆IEN@}Ll?jO߭ʞQ|A07xwt!xfI2?Z<ץTcUj]陎Ltl }5ϓ$,Omˊ;@OjEj(ا,LXLOЦ90O .anA7j4 W_ٓzWjcBy՗+EM)dNg6y1_xp$Lv:9"zpʙ$^JԼ*ϭo=xLj6Ju82AH3$ٕ@=Vv]'qEz;I˼)=ɯx /W(Vp$ mu񶤑OqˎTr㠚xsrGCbypG1ߠw e8$⿄/M{*}W]˷.CK\ުx/$WPwr |i&}{X >$-l?-zglΆ(FhvS*b߲ڡn,|)mrH[a3ר[13o_U3TC$(=)0kgP u^=4 WYCҸ:vQרXàtkm,t*^,}D* "(I9R>``[~Q]#afi6l86:,ssN6j"A4IuQ6E,GnHzSHOuk5$I4ؤQ9@CwpBGv[]uOv0I4\yQѸ~>Z8Taqޣ;za/SI:ܫ_|>=Z8:SUIJ"IY8%b8H:QO6;7ISJҌAά3>cE+&jf$eC+z;V rʺmyeaQf&6ND.:NTvm<- uǝ\MvZYNNT-A>jr!SnO 13Ns%3D@`ܟ 1^c< aɽ̲Xë#w|ycW=9I*H8p^(4՗karOcWtO\ƍR8'KIQ?5>[}yUײ -h=% qThG2)"ו3]!kB*pFDlA,eEiHfPs5H:Փ~H0DتDIhF3c2E9H5zԑʚiX=:mxghd(v׊9iSOd@0ڽ:p5h-t&Xqӕ,ie|7A2O%PEhtjY1wЃ!  ࢽMy7\a@ţJ 4ȻF@o̒?4wx)]P~u57X 9^ܩU;Iꭆ 5 eK27({|Y׎ V\"Z1 Z}(Ǝ"1S_vE30>p; ΝD%xW?W?vo^Vidr[/&>~`9Why;R ;;ɮT?r$g1KACcKl:'3 cﳯ*"t8~l)m+U,z`(>yJ?h>]vЍG*{`;y]IT ;cNUfo¾h/$|NS1S"HVT4uhǜ]v;5͠x'C\SBplh}N ABx%ޭl/Twʽ]D=Kžr㻠l4SO?=k M: cCa#ha)ѐxcsgPiG{+xQI= zԫ+ 8"kñj=|c yCF/*9жh{ ?4o kmQNx;Y4膚aw?6>e]Qr:g,i"ԩA*M7qB?ӕFhV25r[7 Y }LR}*sg+xr2U=*'WSZDW]WǞ<叓{$9Ou4y90-1'*D`c^o?(9uݐ'PI& fJݮ:wSjfP1F:X H9dԯ˝[_54 }*;@ܨ ðynT?ןd#4rGͨH1|-#MrS3G3).᧏3vz֑r$G"`j 1tx0<ƆWh6y6,œGagAyb)hDß_mü gG;evݝnQ C-*oyaMI><]obD":GA-\%LT8c)+y76oQ#*{(F⽕y=rW\p۩cA^e6KʐcVf5$'->ՉN"F"UQ@fGb~#&M=8טJNu9D[̤so~ G9TtW^g5y$bY'سǴ=U-2 #MCt(i lj@Q 5̣i*OsxKf}\M{EV{υƇ);HIfeLȣr2>WIȂ6ik 5YOxȺ>Yf5'|H+98pjn.OyjY~iw'l;s2Y:'lgꥴ)o#'SaaKZ m}`169n"xI *+ }FP"l45'ZgE8?[X7(.Q-*ތL@̲v.5[=t\+CNܛ,gSQnH}*FG16&:t4ُ"Ạ$b |#rsaT ]ӽDP7ո0y)e$ٕvIh'QEAm*HRI=: 4牢) %_iNݧl] NtGHL ɱg<1V,J~ٹ"KQ 9HS9?@kr;we݁]I!{ @G["`J:n]{cAEVʆ#U96j#Ym\qe4hB7Cdv\MNgmAyQL4uLjj9#44tl^}LnR!t±]rh6ٍ>yҏNfU  Fm@8}/ujb9he:AyծwGpΧh5l}3p468)Udc;Us/֔YX1O2uqs`hwgr~{ RmhN؎*q 42*th>#E#HvOq}6e\,Wk#Xb>p}դ3T5†6[@Py*n|'f֧>lư΂̺SU'*qp_SM 'c6m ySʨ;MrƋmKxo,GmPAG:iw9}M(^V$ǒѽ9| aJSQarB;}ٻ֢2%Uc#gNaݕ'v[OY'3L3;,p]@S{lsX'cjwk'a.}}& dP*bK=ɍ!;3ngΊUߴmt'*{,=SzfD Ako~Gaoq_mi}#mPXhύmxǍ΂巿zfQc|kc?WY$_Lvl߶c`?ljݲˏ!V6UЂ(A4y)HpZ_x>eR$/`^'3qˏ-&Q=?CFVR DfV9{8gnh(P"6[D< E~0<@`G6Hгcc cK.5DdB`?XQ2ٿyqo&+1^ DW0ꊩG#QnL3c/x 11[yxპCWCcUĨ80me4.{muI=f0QRls9f9~fǨa"@8ȁQ#cicG$Gr/$W(WV"m7[mAmboD j۳ l^kh׽ # iXnveTka^Y4BNĕ0 !01@Q"2AaPq3BR?@4QT3,㺠W[=JKϞ2r^7vc:9 EߴwS#dIxu:Hp9E! V 2;73|F9Y*ʬFDu&y؟^EAA(ɩ^GV:ݜDy`Jr29ܾ㝉[E;FzxYGUeYC v-txIsםĘqEb+P\ :>iC';k|zرny]#ǿbQw(r|ӹs[D2v-%@;8<a[\o[ϧwI!*0krs)[J9^ʜp1) "/_>o<1AEy^C`x1'ܣnps`lfQ):lb>MejH^?kl3(z:1ŠK&?Q~{ٺhy/[V|6}KbXmn[-75q94dmc^h X5G-}دBޟ |rtMV+]c?-#ڛ^ǂ}LkrOu>-Dry D?:ޞUǜ7V?瓮"#rչģVR;n/_ ؉vݶe5db9/O009G5nWJpA*r9>1.[tsFnQ V 77R]ɫ8_0<՜IFu(v4Fk3E)N:yڮeP`1}$WSJSQNjٺ޵#lј(5=5lǏmoWv-1v,Wmn߀$x_DȬ0¤#QR[Vkzmw"9ZG7'[=Qj8R?zf\a=OU*oBA|G254 p.w7  &ξxGHp B%$gtЏ򤵍zHNuЯ-'40;_3 !01"@AQa2Pq#3BR?ʩcaen^8F<7;EA{EÖ1U/#d1an.1ě0ʾRh|RAo3m3 % 28Q yφHTo7lW>#i`qca m,B-j݋'mR1Ήt>Vps0IbIC.1Rea]H64B>o]($Bma!=?B KǾ+Ծ"nK*+[T#{EJSQs5:U\wĐf3܆&)IԆwE TlrTf6Q|Rh:[K zc֧GC%\_a84HcObiؖV7H )*ģK~Xhչ04?0 E<}3#u? |gS6ꊤ|I#Hڛ աwX97Ŀ%SLy6č|Fa 8b$sקhb9RAu7˨pČ_\*w묦F 4D~f|("mNKiS>$d7SlA/²SL|6N}S˯g]6; #. 403WebShell
403Webshell
Server IP : 43.205.77.33  /  Your IP : 216.73.216.90
Web Server : Apache
System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els13.x86_64 #1 SMP Fri Nov 22 06:29:45 UTC 2024 x86_64
User : dbcollege ( 1086)
PHP Version : 8.0.30
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/dbcollege/public_html/admission/application/controllers/user/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /home/dbcollege/public_html/admission/application/controllers/user/Student.php
<?php

/**
 * Controller Class For Handling All Request Related To Students
 *
 * @author Softpro India Pvt. Ltd.
 */
defined('BASEPATH') or exit('No direct script access allowed');

class Student extends CI_Controller {

    public function __construct() {
        parent::__construct();
        $this->load->model('user/StudentManagement');
        $this->load->model('admin/CourseManagement');
        $this->load->model('admin/SessionManagement');
        $this->load->model('admin/LocationManagement');
        $this->load->model('admin/RelationManagement');
        $this->load->model('admin/ExamManagement');
        $this->load->model('admin/DocumentManagement');
        $this->load->model('admin/IDProofManagement');
        $this->load->model('admin/BranchManagement');
    }

    public function validateCounsellingReferenceNumber() {
        $this->session->unset_userdata('cRefDetails');
        $viewData["branch"] = $this->BranchManagement->getAllBranches()->result();
        $this->load->view('user/validateCounsellingDetails', $viewData);
    }

    public function processReferenceNumber() {
        $this->form_validation->set_rules('counsellingReferenceNumber', 'Counselling Reference Number', 'trim|required', array('required' => 'Please Enter Counselling Reference Number.'));
        if ($this->form_validation->run() == FALSE) {
            $this->validateCounsellingReferenceNumber();
        } else {
            $counsellingReferenceNumber = $this->input->post("counsellingReferenceNumber");
            $csvFileDetails = "https://cas.dbcollege.ac.in/assets/admin/uploads/bulkfiles/counsellinginfo/counsellingData.csv";
            $csvFileContent = $this->csvhandler->readCSV($csvFileDetails);
            $studentDetailsFromCounsellingNumber = array();
            if (sizeof($csvFileContent)) {
                for ($i = 1; $i < sizeof($csvFileContent); $i++) {
                    if ($csvFileContent[$i][1] == $counsellingReferenceNumber) {
                        $studentInfo = $this->StudentManagement->getStudentPersonalInfoByFormNumber($counsellingReferenceNumber, true)->result();
                        if (sizeof($studentInfo)) {
                            $this->session->set_flashdata('errorMessage', "Registration Process Is Already Complete For This Form Id/Reference Number (" . $counsellingReferenceNumber . ").");
                            redirect("user/Student/validateCounsellingReferenceNumber");
                        } else {
                            $studentInfo = $this->StudentManagement->getStudentPersonalInfoByFormNumber($counsellingReferenceNumber, false)->result();
                            if (sizeof($studentInfo)) {
                                $tspi_id = $studentInfo[0]->tspi_id;
                                $this->db->trans_start();
                                $this->StudentManagement->deleteStudentPersonalInfoEntry($tspi_id);
                                $this->StudentManagement->deleteStudentContactInfoEntry($tspi_id);
                                $this->StudentManagement->deleteStudentEntranceExamProfExpAndExtraCurricularInfoEntry($tspi_id);
                                $this->StudentManagement->deleteStudentHostelAndResidenceChoiceInfoEntry($tspi_id);
                                $this->StudentManagement->deleteStudentIDProofInfoEntry($tspi_id);
                                $this->StudentManagement->deleteStudentEducationalQualificationInfoEntry($tspi_id);
                                $this->StudentManagement->deleteStudentFamilyBackgroundInfoEntry($tspi_id);
                                $studentPhotographDocId = $this->DocumentManagement->getDocumentByFlag("SP")->result()[0]->doc_id;
                                $studentSignDocId = $this->DocumentManagement->getDocumentByFlag("SS")->result()[0]->doc_id;
                                $studentDocuments = $this->DocumentManagement->getAllDocumentsOfStudentBy($tspi_id)->result();
                                for ($j = 0; $j < sizeof($studentDocuments); $j++) {
                                    $thisDocument = $studentDocuments[$j];
                                    if ($thisDocument->tddi_doc_id == $studentPhotographDocId) {
                                        if ($thisDocument->tddi_doc_file_path != "picnotavail.jpg") {
                                            if (file_exists("./assets/admin/uploads/studentData/" . $thisDocument->tddi_doc_file_path)) {
                                                unlink("./assets/admin/uploads/studentData/" . $thisDocument->tddi_doc_file_path);
                                            }
                                        }
                                    } else if ($thisDocument->tddi_doc_id == $studentSignDocId) {
                                        if ($thisDocument->tddi_doc_file_path != "signnotavail.png") {
                                            if (file_exists("./assets/admin/uploads/studentData/" . $thisDocument->tddi_doc_file_path)) {
                                                unlink("./assets/admin/uploads/studentData/" . $thisDocument->tddi_doc_file_path);
                                            }
                                        }
                                    } else {
                                        if (file_exists("./assets/admin/uploads/studentData/" . $thisDocument->tddi_doc_file_path)) {
                                            unlink("./assets/admin/uploads/studentData/" . $thisDocument->tddi_doc_file_path);
                                        }
                                    }
                                }
                                $this->DocumentManagement->deleteStudentDocumentInfoEntry($tspi_id);
                                $this->db->trans_complete();
                            }
                        }
                        $counsellingClosureInfo = $this->CourseManagement->getCounsellingClosureInfoBy(trim(addslashes($csvFileContent[$i][4])))->result();
                        if (sizeof($counsellingClosureInfo)) {
                            if ($counsellingClosureInfo[0]->aar_status == "T") {
                                if ((date('Y-m-d', strtotime(date('Y-m-d'))) >= date("Y-m-d", strtotime($counsellingClosureInfo[0]->aar_start_date))) && ((date('Y-m-d', strtotime(date('Y-m-d')))) <= date("Y-m-d", strtotime($counsellingClosureInfo[0]->aar_end_date)))) {
                                    $studentDetailsFromCounsellingNumber = array(
                                        'StudentName' => $csvFileContent[$i][2],
                                        'FatherName' => $csvFileContent[$i][3],
                                        'Course' => $csvFileContent[$i][4],
                                        'DOB' => $csvFileContent[$i][5],
                                        'Gender' => $csvFileContent[$i][6],
                                        'Category' => $csvFileContent[$i][7],
                                        'PH' => $csvFileContent[$i][8],
                                        'Merit' => $csvFileContent[$i][9],
                                        'Domicile' => $csvFileContent[$i][10],
                                        'AllottedCategory' => $csvFileContent[$i][11],
                                        'referenceNumber' => $counsellingReferenceNumber
                                    );
                                    $this->session->set_userdata("cRefDetails", $studentDetailsFromCounsellingNumber);
                                    redirect('user/Student/registerStudent');
                                } else {
                                    $this->session->set_flashdata('errorMessage', "Admission Closed For The Course Requested By You.");
                                    redirect("user/Student/validateCounsellingReferenceNumber");
                                }
                            } else {
                                $this->session->set_flashdata('errorMessage', "Admission For The Course You Have Requested Is Temporarily Closed. Contact College For More Info.");
                                redirect("user/Student/validateCounsellingReferenceNumber");
                            }
                        } else {
                            $studentDetailsFromCounsellingNumber = array(
                                'StudentName' => $csvFileContent[$i][2],
                                'FatherName' => $csvFileContent[$i][3],
                                'Course' => $csvFileContent[$i][4],
                                'DOB' => $csvFileContent[$i][5],
                                'Gender' => $csvFileContent[$i][6],
                                'Category' => $csvFileContent[$i][7],
                                'PH' => $csvFileContent[$i][8],
                                'Merit' => $csvFileContent[$i][9],
                                'Domicile' => $csvFileContent[$i][10],
                                'AllottedCategory' => $csvFileContent[$i][11],
                                'referenceNumber' => $counsellingReferenceNumber
                            );
                            $this->session->set_userdata("cRefDetails", $studentDetailsFromCounsellingNumber);
                            redirect('user/Student/registerStudent');
                        }
                    }
                }
                $this->session->set_flashdata('errorMessage', "No Record Found Against Entered Reference Number.");
                $this->validateCounsellingReferenceNumber();
            } else {
                $this->session->set_flashdata('errorMessage', "No Student Records Found.");
                $this->validateCounsellingReferenceNumber();
            }
        }
    }

    public function registerStudent() {
        if ($this->session->userdata('cRefDetails')) {
            $viewData['cRefDetails'] = $this->session->userdata('cRefDetails');
            $viewData['courses'] = $this->CourseManagement->getCoursesBySessionAndFormFee('T', 'F')->result();
            $viewData['states'] = $this->LocationManagement->getAllNonDeletedActiveStates()->result();
            $viewData['relations'] = $this->RelationManagement->getAllNonDeletedActiveRelations()->result();
            $viewData["branch"] = $this->BranchManagement->getAllBranches()->result();
            $viewData['categories'] = json_decode(file_get_contents('https://cas.dbcollege.ac.in/assets/admin/json/categories.json'), true);
            $viewData['religions'] = json_decode(file_get_contents('https://cas.dbcollege.ac.in/assets/admin/json/religions.json'), true);
            $this->load->view('user/registerStudent', $viewData);
        } else {
            redirect('user/Student/validateCounsellingReferenceNumber');
        }
    }

    public function saveNewStudent() {
        $this->form_validation->set_rules('stuCourse', 'Course', 'trim|required', array('required' => 'Please Select Course.'));
        $this->form_validation->set_rules('stuName', 'Student Name', 'trim|required', array('required' => 'Student Name Is Required.'));
        $this->form_validation->set_rules('stuMailingAddrLineOne', 'Mailing Address Line 1', 'trim|required', array('required' => 'Please Enter Mailing Address Line 1.'));
        $this->form_validation->set_rules('stuMailingAddrState', 'Mailing State', 'trim|required', array('required' => 'Please Select Mailing State.'));
        $this->form_validation->set_rules('stuMailingAddrCity', 'Mailing City', 'trim|required', array('required' => 'Please Select Mailing City.'));
        $this->form_validation->set_rules('stuMailingAddrZipCode', 'Mailing Zipcode', 'trim|required|numeric|min_length[6]|max_length[6]', array('required' => 'Please Enter Mailing Zipcode.'));
        $this->form_validation->set_rules('stuMobile', 'Student Mobile Number', 'trim|required|numeric|min_length[10]|max_length[10]', array('required' => 'Student Mobile Is Required.'));
        $this->form_validation->set_rules('stuEmail', 'Student Email', 'trim|required|valid_email', array('required' => 'Please Enter Email Of Student.', 'valid_email' => 'Enter Valid Student Email'));
        $this->form_validation->set_rules('stuPermaAddrLineOne', 'Permanent Address Line 1', 'trim|required', array('required' => 'Please Enter Permanent Address Line 1.'));
        $this->form_validation->set_rules('stuPermaAddrState', 'Permanent State', 'trim|required', array('required' => 'Please Select Permanent State.'));
        $this->form_validation->set_rules('stuPermaAddrCity', 'Permanent City', 'trim|required', array('required' => 'Please Select Permanent City.'));
        $this->form_validation->set_rules('stuPermaAddrZipCode', 'Permanent Zipcode', 'trim|required|numeric|min_length[6]|max_length[6]', array('required' => 'Please Enter Permanent Zipcode.'));
        $this->form_validation->set_rules('stuGen', 'Student Gender', 'trim|required', array('required' => 'Please Select Gender Of Student.'));
        $this->form_validation->set_rules('stuDOB', 'Student D.O.B', 'trim|required', array('required' => 'Please Select D.O.B. Of Student.'));
        $this->form_validation->set_rules('stuCategory', 'Student Category', 'trim|required', array('required' => 'Please Select Student Category.'));
        $this->form_validation->set_rules('stuReligion', 'Student Religion', 'trim|required', array('required' => 'Please Select Student Religion.'));
        //student Qualification validation and array formation logic
        $studentEducationQualificatioInfo = array();
        $studentEduQualiExamIds = $this->input->post('stuEduQualiExamId');
        $studentEduQualiBoardUniv = $this->input->post('stuEduQualiBoardUniv');
        $studentEduQualiStream = $this->input->post('stuEduQualiStream');
        $studentEduQualiYearOfExam = $this->input->post('stuEduQualiYearOfExam');
        $studentEduQualiMaxMarks = $this->input->post('stuEduQualiMaxMarks');
        $studentEduQualiMarksObtnd = $this->input->post('stuEduQualiMarksObt');
        $studentEduQualiPrcntObtnd = $this->input->post('stuEduQualiPercntCGPA');
        $studentEduQualiDiv = $this->input->post('stuEduQualiDiv');
        $totalEduQualisInfo = sizeof($studentEduQualiExamIds);
        $isNonNumericOrBlank = 0;
        for ($i = 0; $i < $totalEduQualisInfo; $i++) {
            if ((trim($studentEduQualiBoardUniv[$i]) == "") || (trim($studentEduQualiStream[$i]) == "") || (trim($studentEduQualiYearOfExam[$i]) == "") || (trim($studentEduQualiDiv[$i]) == "") || (trim($studentEduQualiPrcntObtnd[$i]) == "") || (trim($studentEduQualiMarksObtnd[$i]) == "")) {
                $isNonNumericOrBlank++;
            } else {
                $thisEduQualiInfo = array(
                    'tesi_exam' => $studentEduQualiExamIds[$i],
                    'tesi_board' => $studentEduQualiBoardUniv[$i],
                    'tesi_university' => $studentEduQualiBoardUniv[$i],
                    'tesi_stream' => $studentEduQualiStream[$i],
                    'tesi_passing_year' => $studentEduQualiYearOfExam[$i],
                    'tesi_percnt' => $studentEduQualiPrcntObtnd[$i],
                    'tesi_cgpa' => $studentEduQualiMarksObtnd[$i],
                    'tesi_division' => $studentEduQualiDiv[$i],
                    'tesi_added_on' => date("Y-m-d H:i:s"),
                    'tesi_updated_on' => date("Y-m-d H:i:s"),
                    'tesi_added_by' => "0",
                    'tesi_updated_by' => "0",
                    'tspi_id' => '',
                    'tesi_max_marks_cgpa' => $studentEduQualiMaxMarks[$i]
                );
                array_push($studentEducationQualificatioInfo, $thisEduQualiInfo);
            }
        }
        $studentFamilyBackgroundInfo = array();
        $studentFamilyBGName = $this->input->post('stuFamBGName');
        $studentFamilyBGDesig = $this->input->post('stuFamBGDesignation');
        $studentFamilyBGOrg = $this->input->post('stuFamBGOrganization');
        $studentFamilyBGRel = $this->input->post('stuFamBGRelation');
        $isFamilyBackgroundBlank = 0;
        for ($i = 0; $i < 3; $i++) {
            $thisFamilyBGInfo = array(
                'tfbi_relation' => trim($studentFamilyBGRel[$i]),
                'tfbi_name' => strtoupper(addslashes(trim($studentFamilyBGName[$i]))),
                'tfbi_organization' => strtoupper(addslashes(trim($studentFamilyBGOrg[$i]))),
                'tfbi_designation' => strtoupper(addslashes(trim($studentFamilyBGDesig[$i]))),
                'tfbi_user_type_flag' => 'S',
                'tfbi_mapping_id' => '',
                'tfbi_added_on' => date("Y-m-d H:i:s"),
                'tfbi_updated_on' => date("Y-m-d H:i:s"),
                'tfbi_added_by' => "0",
                'tfbi_updated_by' => "0"
            );
            array_push($studentFamilyBackgroundInfo, $thisFamilyBGInfo);
        }
        $fatherRelId = $this->RelationManagement->getRelationInfoByName("FATHER")->result()[0];
        $studentFatherFamBGInfo = array(
            'tfbi_relation' => $fatherRelId->rel_id,
            'tfbi_name' => strtoupper(addslashes(trim($this->input->post('stuFatherName')))),
            'tfbi_organization' => "NA",
            'tfbi_designation' => "NA",
            'tfbi_user_type_flag' => 'S',
            'tfbi_mapping_id' => '',
            'tfbi_added_on' => date("Y-m-d H:i:s"),
            'tfbi_updated_on' => date("Y-m-d H:i:s"),
            'tfbi_added_by' => "0",
            'tfbi_updated_by' => "0"
        );
        $motherRelId = $this->RelationManagement->getRelationInfoByName("MOTHER")->result()[0];
        $studentMotherFamBGInfo = array(
            'tfbi_relation' => $motherRelId->rel_id,
            'tfbi_name' => strtoupper(addslashes(trim($this->input->post('stuMotherName')))),
            'tfbi_organization' => "NA",
            'tfbi_designation' => "NA",
            'tfbi_user_type_flag' => 'S',
            'tfbi_mapping_id' => '',
            'tfbi_added_on' => date("Y-m-d H:i:s"),
            'tfbi_updated_on' => date("Y-m-d H:i:s"),
            'tfbi_added_by' => "0",
            'tfbi_updated_by' => "0"
        );
        array_push($studentFamilyBackgroundInfo, $studentFatherFamBGInfo);
        array_push($studentFamilyBackgroundInfo, $studentMotherFamBGInfo);
        if ($this->form_validation->run() == FALSE) {
            $this->registerStudent();
        } else if ($isNonNumericOrBlank) {
            $this->session->set_flashdata('errorMessage', "Any Of The Educational Qualification Is Incorrect. Please Enter All Required Fields & Valid Number/Decimal Number In Marks, Percentage Fields.");
            $this->registerStudent();
        } else if ($isFamilyBackgroundBlank) {
            $this->session->set_flashdata('errorMessage', "Any Of The Family Background Deatils Is Not Filled. Please Enter All Required Fields.");
            $this->registerStudent();
        } else if (empty($_FILES['stuPhotograph']['name'])) {
            $this->session->set_flashdata('errorMessage', "Select An Image As Photograph.");
            $this->registerStudent();
        } else if (empty($_FILES['stuSignature']['name'])) {
            $this->session->set_flashdata('errorMessage', "Select An Image As Signature.");
            $this->registerStudent();
        } else {
            $studentDocumentInfo = array();
            $session = $this->SessionManagement->getCurrentSessionDetails()->result()[0];
            $ucsMappingDetails = $this->CourseManagement->getAllUCSMappingBySessionAndCourse($session->session_id, $this->input->post('stuCourse'))->result()[0];
            $photograph = "";
            $signature = "";
            /* Signature Upload */
            $studentSignImg['upload_path'] = './assets/admin/uploads/studentData/';
            $studentSignImg['allowed_types'] = 'jpeg|jpg|png';
            $studentSignImg['max_size'] = '500';
            $studentSignImg['file_ext_tolower'] = TRUE;
            $studentSignImg['encrypt_name'] = TRUE;
            $this->load->library('upload', $studentSignImg);
            if (!$this->upload->do_upload('stuSignature')) {
                $this->session->set_flashdata('errorMessage', $this->upload->display_errors());
                redirect("user/Student/registerStudent");
            } else {
                $studentSignDocId = $this->DocumentManagement->getDocumentByFlag("SS")->result()[0]->doc_id;
                $signature = $this->upload->data()['file_name'];
                $studentSignInfo = array(
                    'tddi_doc_id' => $studentSignDocId,
                    'tddi_doc_file_path' => $signature,
                    'tddi_code' => $studentSignDocId,
                    'tddi_user_type_flag' => 'S',
                    'tddi_mapping_id' => '',
                    'tddi_semester' => 'NA',
                    'ucs_map_id' => $ucsMappingDetails->ucs_map_id,
                    'tddi_added_on' => date("Y-m-d H:i:s"),
                    'tddi_updated_on' => date("Y-m-d H:i:s"),
                    'tddi_added_by' => "0",
                    'tddi_updated_by' => "0"
                );
                array_push($studentDocumentInfo, $studentSignInfo);
            }
            /* Signature Upload */
            /* Photo Upload */
            $studentImg['upload_path'] = './assets/admin/uploads/studentData/';
            $studentImg['allowed_types'] = 'jpeg|jpg|png';
            $studentImg['max_size'] = '500';
            $studentImg['file_ext_tolower'] = TRUE;
            $studentImg['encrypt_name'] = TRUE;
            $this->load->library('upload', $studentImg);
            if (!$this->upload->do_upload('stuPhotograph')) {
                $this->session->set_flashdata('errorMessage', $this->upload->display_errors());
                redirect("user/Student/registerStudent");
            } else {
                $studentPhotographDocId = $this->DocumentManagement->getDocumentByFlag("SP")->result()[0]->doc_id;
                $photograph = $this->upload->data()['file_name'];
                $studentPhotoInfo = array(
                    'tddi_doc_id' => $studentPhotographDocId,
                    'tddi_doc_file_path' => $photograph,
                    'tddi_code' => $studentPhotographDocId,
                    'tddi_user_type_flag' => 'S',
                    'tddi_mapping_id' => '',
                    'tddi_semester' => 'NA',
                    'ucs_map_id' => $ucsMappingDetails->ucs_map_id,
                    'tddi_added_on' => date("Y-m-d H:i:s"),
                    'tddi_updated_on' => date("Y-m-d H:i:s"),
                    'tddi_added_by' => "0",
                    'tddi_updated_by' => "0"
                );
                array_push($studentDocumentInfo, $studentPhotoInfo);
            }
            /* Photo Upload */
            $studentPersonalInfo = array(
                'tspi_name' => strtoupper(addslashes(trim($this->input->post('stuName')))),
                'ucs_map_id' => $ucsMappingDetails->ucs_map_id,
                'tspi_mobile' => trim($this->input->post('stuMobile')),
                'tspi_email' => trim($this->input->post('stuEmail')),
                'tspi_gender' => trim($this->input->post('stuGen')),
                'tspi_category' => trim($this->input->post('stuCategory')),
                'tspi_religion' => trim($this->input->post('stuReligion')),
                'tspi_dob' => ($this->input->post('stuDOB') == "") ? NULL : date("Y-m-d", strtotime(str_replace('/', '-', $this->input->post('stuDOB')))),
                'tspi_added_by' => "0",
                'tspi_added_on' => date("Y-m-d H:i:s"),
                'tspi_updated_by' => "0",
                'tspi_updated_on' => date("Y-m-d H:i:s"),
                'tspi_password' => MD5('12345'),
                'tspi_rollNumber' => (trim($this->input->post('stuRollNo') == '')) ? addslashes(trim($this->input->post('stuFormNo'))) : addslashes(trim($this->input->post('stuRollNo'))),
                'tspi_is_diff_abled' => trim($this->input->post('stuDiffAbled')),
                'tspi_parent_annual_income' => trim($this->input->post('stuParentIncome')),
                'tspi_remarks' => addslashes(trim($this->input->post('stuRemarks'))),
                'tspi_reference_no' => addslashes(trim($this->input->post('referenceNumber'))),
                'tspi_domicile' => addslashes(trim($this->input->post('stuDomicile'))),
                'tspi_allotted_category' => addslashes(trim($this->input->post('stuAllotCategory')))
            );
            $studentContactInfo = array(
                'tsci_perma_state' => trim($this->input->post('stuPermaAddrState')),
                'tsci_perma_city' => trim($this->input->post('stuPermaAddrCity')),
                'tsci_perma_zipcode' => trim($this->input->post('stuPermaAddrZipCode')),
                'tsci_resid_state' => trim($this->input->post('stuMailingAddrState')),
                'tsci_resid_city' => trim($this->input->post('stuMailingAddrCity')),
                'tsci_resid_zipcode' => trim($this->input->post('stuMailingAddrZipCode')),
                'tsci_parent_landline' => trim($this->input->post('stuParentLandline')),
                'tsci_parent_mobile' => trim($this->input->post('stuParentMobile')),
                'tsci_added_on' => date("Y-m-d H:i:s"),
                'tsci_added_by' => "0",
                'tsci_updated_on' => date("Y-m-d H:i:s"),
                'tsci_updated_by' => "0",
                'tspi_id' => '',
                'tsci_perma_address_line_one' => addslashes(trim($this->input->post('stuPermaAddrLineOne'))),
                'tsci_perma_address_line_two' => addslashes(trim($this->input->post('stuPermaAddrLineTwo'))),
                'tsci_perma_address_line_three' => addslashes(trim($this->input->post('stuPermaAddrLineThree'))),
                'tsci_resid_address_line_one' => addslashes(trim($this->input->post('stuMailingAddrLineOne'))),
                'tsci_resid_address_line_two' => addslashes(trim($this->input->post('stuMailingAddrLineTwo'))),
                'tsci_resid_address_line_three' => addslashes(trim($this->input->post('stuMailingAddrLineThree')))
            );
            $studentEntranceProfAndExtraCurricularInfo = array(
                'tsevi_is_prof_exp' => trim($this->input->post('stuProfExp')),
                'tsevi_no_of_years' => trim($this->input->post('stuProfExpInYears')),
                'tsevi_organization' => addslashes(trim($this->input->post('stuProfOrgName'))),
                'tsevi_job_desc' => addslashes(trim($this->input->post('stuProfJobDesc'))),
                'tsevi_extra_activities' => addslashes(trim($this->input->post('stuExtraCurricularAct'))),
                'tsevi_how_know_sms' => "Any Other",
                'tsevi_entrance_through' => trim($this->input->post('stuEntranceExam')),
                'tsevi_form_no' => trim($this->input->post('stuEntranceExamRegNo')),
                'tsevi_composite_score' => trim($this->input->post('stuEntranceExamComScore')),
                'tsevi_percnt_obtained' => trim($this->input->post('stuEntranceExamPercentileObt')),
                'tsevi_rank' => trim($this->input->post('stuEntranceExamRank')),
                'tsevi_added_on' => date("Y-m-d H:i:s"),
                'tsevi_updated_on' => date("Y-m-d H:i:s"),
                'tsevi_added_by' => "0",
                'tsevi_updated_by' => "0",
                'tspi_id' => '',
                'tsevi_percntage' => trim($this->input->post('stuEntranceExamPercentage'))
            );
            $studentHostelAndResidenceInfo = array(
                'tshri_is_hostel_opted' => "F",
                'tshri_resid_choice' => NULL,
                'tshri_comm_state' => '0',
                'tshri_comm_city' => '0',
                'tshri_loc_guard_state' => '0',
                'tshri_loc_guard_city' => '0',
                'tshri_added_on' => date("Y-m-d H:i:s"),
                'tshri_updated_on' => date("Y-m-d H:i:s"),
                'tshri_added_by' => "0",
                'tshri_updated_by' => "0",
                'tspi_id' => ''
            );
            $aadharIdInfo = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(2, "S")->result()[0];
            $studentAadharInfo = array(
                'tipi_number' => (trim($this->input->post('stuAadharNo')) == "") ? "" : trim($this->input->post('stuAadharNo')),
                'rel_id' => 0,
                'tipsm_id' => $aadharIdInfo->tipsm_id,
                'tipi_added_on' => date("Y-m-d H:i:s"),
                'tipi_updated_on' => date("Y-m-d H:i:s"),
                'tipi_added_by' => "0",
                'tipi_updated_by' => "0",
                'tipi_for' => ''
            );
            $PANInfo = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(1, "S")->result()[0];
            $studentPANInfo = array(
                'tipi_number' => (trim($this->input->post('stuPAN')) == "") ? "" : trim($this->input->post('stuPAN')),
                'rel_id' => 0,
                'tipsm_id' => $PANInfo->tipsm_id,
                'tipi_added_on' => date("Y-m-d H:i:s"),
                'tipi_updated_on' => date("Y-m-d H:i:s"),
                'tipi_added_by' => "0",
                'tipi_updated_by' => "0",
                'tipi_for' => ''
            );
            $casteCertificateInfo = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(5, "S")->result()[0];
            $studentCasteCertificateInfo = array(
                'tipi_number' => (trim($this->input->post('stuCSTCNumber')) == "") ? "" : trim($this->input->post('stuCSTCNumber')),
                'rel_id' => 0,
                'tipsm_id' => $casteCertificateInfo->tipsm_id,
                'tipi_added_on' => date("Y-m-d H:i:s"),
                'tipi_updated_on' => date("Y-m-d H:i:s"),
                'tipi_added_by' => "0",
                'tipi_updated_by' => "0",
                'tipi_for' => ''
            );
            $incomeCertificateInfo = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(6, "S")->result()[0];
            $studentIncomeCertificateInfo = array(
                'tipi_number' => (trim($this->input->post('stuAICNumber')) == "") ? "" : trim($this->input->post('stuAICNumber')),
                'rel_id' => 0,
                'tipsm_id' => $incomeCertificateInfo->tipsm_id,
                'tipi_added_on' => date("Y-m-d H:i:s"),
                'tipi_updated_on' => date("Y-m-d H:i:s"),
                'tipi_added_by' => "0",
                'tipi_updated_by' => "0",
                'tipi_for' => ''
            );
            $studentIdProofInfo = array($studentAadharInfo, $studentPANInfo, $studentCasteCertificateInfo, $studentIncomeCertificateInfo);
            $this->db->trans_start();
            $tspi_id = $this->StudentManagement->createNewStudentPersonalInfoEntry($studentPersonalInfo);
            if ($tspi_id) {
                $studentContactInfo['tspi_id'] = $tspi_id;
                $studentHostelAndResidenceInfo['tspi_id'] = $tspi_id;
                $studentPANInfo['tipi_for'] = $tspi_id;
                $studentAadharInfo['tipi_for'] = $tspi_id;
                $studentEntranceProfAndExtraCurricularInfo['tspi_id'] = $tspi_id;
                for ($i = 0; $i < sizeof($studentIdProofInfo); $i++) {
                    $studentIdProofInfo[$i]['tipi_for'] = $tspi_id;
                }
                for ($i = 0; $i < sizeof($studentEducationQualificatioInfo); $i++) {
                    $studentEducationQualificatioInfo[$i]['tspi_id'] = $tspi_id;
                }
                for ($i = 0; $i < sizeof($studentFamilyBackgroundInfo); $i++) {
                    $studentFamilyBackgroundInfo[$i]['tfbi_mapping_id'] = $tspi_id;
                }
                for ($i = 0; $i < sizeof($studentDocumentInfo); $i++) {
                    $studentDocumentInfo[$i]['tddi_mapping_id'] = $tspi_id;
                }
                $studentPersonalInfo = array(
                    'tspi_id' => $tspi_id,
                    'tspi_form_no' => "UND-" . $tspi_id,
                    'tspi_rollNumber' => "UND-" . $tspi_id,
                    'tspi_enrollment_no' => "UND-" . $tspi_id
                );
                $this->StudentManagement->updateStudentPersonalInfo($studentPersonalInfo);
                $this->StudentManagement->createNewStudentContactInfoEntry($studentContactInfo);
                $this->StudentManagement->createNewStudentEntranceExamProfExpAndExtraCurricularInfoEntry($studentEntranceProfAndExtraCurricularInfo);
                $this->StudentManagement->createNewStudentEducationalQualificationInfoMulti($studentEducationQualificatioInfo);
                $this->StudentManagement->createNewStudentFamilyBackgroundInfoMulti($studentFamilyBackgroundInfo);
                $this->IDProofManagement->createNewIDProofInfoMulti($studentIdProofInfo);
                $this->StudentManagement->createNewStudentHostelAndResidenceChoiceInfoEntry($studentHostelAndResidenceInfo);
                $this->DocumentManagement->createNewDocumentInfoMulti($studentDocumentInfo);
                $this->db->trans_complete();
                /* Sending Photo & Signature To ERP Folder Structure */
                $data = array(
                    'photograph' => base_url("assets/admin/uploads/studentData/" . $photograph),
                    'signature' => base_url("assets/admin/uploads/studentData/" . $signature),
                );
                $payload = json_encode($data);
                /* URL Modification Needed In Below URL As Per Production Environment */
                $ch = curl_init('https://cas.dbcollege.ac.in/webServices/FileTransfer/copyFileFromURL');
                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
                curl_setopt($ch, CURLINFO_HEADER_OUT, true);
                curl_setopt($ch, CURLOPT_POST, true);
                curl_setopt($ch, CURLOPT_POSTFIELDS, $payload);
                curl_setopt($ch, CURLOPT_HTTPHEADER, array(
                    'Content-Type: application/json',
                    'Content-Length: ' . strlen($payload))
                );
                $result = json_decode(curl_exec($ch));
                curl_close($ch);
                /* Sending Photo & Signature To ERP Folder Structure Ends */
                $this->session->set_flashdata('successMessage', 'Student Registered Successfully.');
                redirect("user/Student/admissionFormDeclaration/" . $tspi_id);
            } else {
                $this->session->set_flashdata('successMessage', 'An Error Occured While Student Registration. Try Again.');
                redirect("user/Student/registerStudent");
            }
        }
    }

    public function admissionFormDeclaration($tspi_id) {
        $viewData["courseTypes"] = $this->CourseManagement->getDistinctCourseTypeFromCourseTable()->result();
        $viewData['courses'] = $this->CourseManagement->getCoursesBySessionAndFormFee('T', 'F')->result();
        $viewData['states'] = $this->LocationManagement->getAllNonDeletedActiveStates()->result();
        $viewData['relations'] = $this->RelationManagement->getAllNonDeletedActiveRelations()->result();
        $viewData['stuPersonalInfoWithPicAndSign'] = $this->StudentManagement->getStudentPersonalInfoAndPhotoSignBy($tspi_id, '')->result()[0];
        $aadharIdInfo = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(2, "S")->result()[0]->tipsm_id;
        $aadharInfo = $this->IDProofManagement->getIdProofInfoBy($tspi_id, $aadharIdInfo)->result()[0];
        $viewData['aadharInfo'] = $aadharInfo;
        $PANInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(1, "S")->result()[0]->tipsm_id;
        $PANInfo = $this->IDProofManagement->getIdProofInfoBy($tspi_id, $PANInfoID)->result()[0];
        $viewData['PANInfo'] = $PANInfo;
        $casteCertificateInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(5, "S")->result()[0]->tipsm_id;
        $casteCertificateInfo = $this->IDProofManagement->getIdProofInfoBy($tspi_id, $casteCertificateInfoID)->result()[0];
        $viewData['casteCertificateInfo'] = $casteCertificateInfo;
        $incomeCertificateInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(6, "S")->result()[0]->tipsm_id;
        $incomeCertificateInfo = $this->IDProofManagement->getIdProofInfoBy($tspi_id, $incomeCertificateInfoID)->result()[0];
        $viewData['incomeCertificateInfo'] = $incomeCertificateInfo;
        $studentPhotographDocId = $this->DocumentManagement->getDocumentByFlag("SP")->result()[0]->doc_id;
        $studentPhotographDoc = $this->DocumentManagement->getUploadedDocumentOfStudentBy($tspi_id, $studentPhotographDocId)->result()[0];
        $viewData['studentPhotographDoc'] = $studentPhotographDoc;
        $studentSignDocId = $this->DocumentManagement->getDocumentByFlag("SS")->result()[0]->doc_id;
        $studentSignDoc = $this->DocumentManagement->getUploadedDocumentOfStudentBy($tspi_id, $studentSignDocId)->result()[0];
        $viewData['studentSignDoc'] = $studentSignDoc;
        $viewData['hostelInfo'] = $this->StudentManagement->getStudentHostelInfoBy($tspi_id)->result()[0];
        $viewData['stuContactInfo'] = $this->StudentManagement->getStudentContactInfoBy($tspi_id)->result()[0];
        $viewData['stuEntranceExamAndProfExpInfo'] = $this->StudentManagement->getStudentStudentEntranceExamProfExpAndExtraCurricularInfoBy($tspi_id)->result()[0];
        $viewData['stuFamilyBGInfo'] = $this->StudentManagement->getStudentFamilyBackgroundInfoBy($tspi_id)->result();
        $viewData['stuEduQualifInfo'] = $this->StudentManagement->getStudentEducationalQualificationInfo($tspi_id)->result();
        $viewData['stuFatherName'] = $this->StudentManagement->getStudentFatherInfoBy($tspi_id)->result()[0]->tfbi_name;
        $viewData['stuFatherFamBGId'] = $this->StudentManagement->getStudentFatherInfoBy($tspi_id)->result()[0]->tfbi_id;
        $viewData['stuMotherName'] = $this->StudentManagement->getStudentMotherInfoBy($tspi_id)->result()[0]->tfbi_name;
        $viewData['stuMotherFamBGId'] = $this->StudentManagement->getStudentMotherInfoBy($tspi_id)->result()[0]->tfbi_id;
        $viewData["branch"] = $this->BranchManagement->getAllBranches()->result();
        $this->load->view('user/admissionFormDeclaration', $viewData);
    }

    public function declareAdmissionForm() {
        $tspi_id = $this->input->post("tspi_id");
        $this->form_validation->set_rules('declaration', 'declaration', 'required', array('required' => 'Please Select Declaration Checkbox.'));
        if ($this->form_validation->run() == FALSE) {
            $this->admissionFormDeclaration($tspi_id);
        } else {
            $persoanlDetailArray = array("tspi_status" => "NA", "tspi_id" => $tspi_id);
            if ($this->StudentManagement->updateStudentPersonalInfo($persoanlDetailArray)) {
                $this->payment($tspi_id);
            } else {
                redirect("user/Student/admissionFormDeclaration/" . $tspi_id);
            }
        }
    }

    public function payment($tspi_id) {
        if ($this->StudentManagement->getPersonalDetailsByTSPIID($tspi_id)->result()[0]->tspi_status == "NA") {
            $admissionFeeDetails = $this->StudentManagement->getStudentPersonalInfoAndPhotoSignBy($tspi_id)->result()[0];
            $transactionArray = array(
                "gateway_txnid" => "gtxn" . substr(time(), 2) . $tspi_id,
                "regno" => $tspi_id,
                "bank_ref_no" => "bnkrefno" . substr(time(), 2) . $tspi_id,
                "fee" => $admissionFeeDetails->ucs_form_fee,
                "tdate" => date("Y-m-d H:i:s"),
                "status" => "T",
                "error_desc" => "Success",
                "tran_details" => "ADMISSION",
                "tran_dt" => date("Y-m-d")
            );
            $this->db->trans_start();
            if ($this->StudentManagement->insertTransactionDetails($transactionArray)) {
                /* Below Logic Is For Auto-Generating Form No. */
                //$admissionFrmNoArray = array("regno" => $tspi_id);
                //$formno = $this->StudentManagement->insertAdmissionForm($admissionFrmNoArray);
                //$tspi_form_no = $admissionFeeDetails->course_name . "-" . $formno;
                /* Above Logic Is For Auto-Generating Form No. */
                /* Setting The Reference No./Form Id As Form No. Below */
                $tspi_form_no = $admissionFeeDetails->tspi_reference_no;
                /* Setting The Reference No./Form Id As Form No. */
                $persoanlDetailsArray = array(
                    "tspi_form_no" => $tspi_form_no,
                    "tspi_id" => $tspi_id,
                    "tspi_rollNumber" => $tspi_form_no,
                    "tspi_enrollment_no" => $tspi_form_no
                );
                $this->StudentManagement->updateStudentPersonalInfo($persoanlDetailsArray);
                $this->db->trans_complete();
                $this->session->set_flashdata("successMessage", "Transaction Suucessful.");
                redirect("Home");
            } else {
                $this->session->set_flashdata("errorMessage", "Transaction Failed.");
                redirect("user/enrollStudent");
            }
        } else {
            $this->session->set_flashdata("errorMessage", "Please Check Declaration.");
            redirect("user/Student/admissionFormDeclaration/" . $tspi_id);
        }
    }

    public function acknowledgement() {
        $viewData["branch"] = $this->BranchManagement->getAllBranches()->result();
        $this->load->view("user/acknowledgement", $viewData);
    }

    public function printAcknowledgement() {
        $viewData["branch"] = $this->BranchManagement->getAllBranches()->result();
        if (isset($_POST['opt1'])) {
            $this->form_validation->set_rules('form_no', 'Form Number', 'trim|required', array('required' => 'Enter Form Number.'));
            $this->form_validation->set_rules('opt', 'Option', 'trim|required', array('required' => 'Select Either Admission Form / Fee Acknowledgement.'));
            if ($this->form_validation->run() == FALSE) {
                $this->acknowledgement();
            } else {
                $option = $this->input->post("opt");
                $fornno = $this->input->post("form_no");
                if (sizeof($this->StudentManagement->getStudentFullAdmissionAndTransactionDetails($fornno)->result())) {
                    if ($option == "A") {
                        $personalInfo = $this->StudentManagement->getStudentFullAdmissionAndTransactionDetails($fornno)->result()[0];
                        $viewData['stuPersonalInfoWithPicAndSign'] = $personalInfo;
                        $viewData['stuContactInfo'] = $this->StudentManagement->getStudentContactInfoBy($personalInfo->tspi_id)->result()[0];
                        $viewData['stuEntranceExamAndProfExpInfo'] = $this->StudentManagement->getStudentStudentEntranceExamProfExpAndExtraCurricularInfoBy($personalInfo->tspi_id)->result()[0];
                        $viewData['stuFamilyBGInfo'] = $this->StudentManagement->getStudentFamilyBackgroundInfoBy($personalInfo->tspi_id)->result();
                        $viewData['stuEduQualifInfo'] = $this->StudentManagement->getStudentEducationalQualificationInfo($personalInfo->tspi_id)->result();

                        $aadharIdInfo = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(2, "S")->result()[0]->tipsm_id;
                        $aadharInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $aadharIdInfo)->result()[0];
                        $viewData['aadharInfo'] = $aadharInfo;

                        $PANInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(1, "S")->result()[0]->tipsm_id;
                        $PANInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $PANInfoID)->result()[0];
                        $viewData['PANInfo'] = $PANInfo;

                        $casteCertificateInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(5, "S")->result()[0]->tipsm_id;
                        $casteCertificateInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $casteCertificateInfoID)->result()[0];
                        $viewData['casteCertificateInfo'] = $casteCertificateInfo;

                        $incomeCertificateInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(6, "S")->result()[0]->tipsm_id;
                        $incomeCertificateInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $incomeCertificateInfoID)->result()[0];
                        $viewData['incomeCertificateInfo'] = $incomeCertificateInfo;

                        $studentPhotographDocId = $this->DocumentManagement->getDocumentByFlag("SP")->result()[0]->doc_id;
                        $studentPhotographDoc = $this->DocumentManagement->getUploadedDocumentOfStudentBy($personalInfo->tspi_id, $studentPhotographDocId)->result()[0];

                        $viewData['studentPhotographDoc'] = $studentPhotographDoc;

                        $studentSignDocId = $this->DocumentManagement->getDocumentByFlag("SS")->result()[0]->doc_id;
                        $studentSignDoc = $this->DocumentManagement->getUploadedDocumentOfStudentBy($personalInfo->tspi_id, $studentSignDocId)->result()[0];
                        $viewData['studentSignDoc'] = $studentSignDoc;

                        $viewData['hostelInfo'] = $this->StudentManagement->getStudentHostelInfoBy($personalInfo->tspi_id)->result()[0];

                        $viewData['stuFatherName'] = $this->StudentManagement->getStudentFatherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_name;
                        $viewData['stuFatherFamBGId'] = $this->StudentManagement->getStudentFatherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_id;
                        $viewData['stuMotherName'] = $this->StudentManagement->getStudentMotherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_name;
                        $viewData['stuMotherFamBGId'] = $this->StudentManagement->getStudentMotherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_id;
                        $this->load->view("user/admissionFormAcknowledgement", $viewData);
                    } else {
                        $viewData["feeDetails"] = $this->StudentManagement->getStudentFullAdmissionAndTransactionDetails($fornno)->result();
                        $this->load->view("user/feeAcknowledgement", $viewData);
                    }
                } else {
                    $this->session->set_flashdata('errorMessage', "Please enter valid Form No.");
                    $this->acknowledgement();
                }
            }
        } else if (isset($_POST['opt2'])) {
            $this->form_validation->set_rules('email', "Applicant's Email", 'trim|required', array('required' => 'Enter Applicant Email.'));
            $this->form_validation->set_rules('mobile', 'Form Number', 'trim|required', array('required' => 'Enter Applicant Mobile.'));
            $this->form_validation->set_rules('dob', 'DOB', 'trim|required', array('required' => 'Select Applicant DOB.'));
            $this->form_validation->set_rules('opt', 'Option', 'trim|required', array('required' => 'Select Either Admission Form / Fee Acknowledgement.'));

            if ($this->form_validation->run() == FALSE) {
                $this->acknowledgement();
            } else {
                $viewData["branch"] = $this->BranchManagement->getAllBranches()->result();
                $email = $this->input->post("email");
                $mobile = $this->input->post("mobile");
                $dob = date('Y-m-d', strtotime(str_replace('/', '-', $this->input->post("dob"))));
                $option = $this->input->post("opt");
                if (sizeof($this->StudentManagement->getStudentFullAdmissionAndTransactionDetails('', $email, $mobile, $dob)->result())) {
                    if ($option == "A") {

                        $personalInfo = $this->StudentManagement->getStudentFullAdmissionAndTransactionDetails('', $email, $mobile, $dob)->result()[0];
                        $viewData['stuPersonalInfoWithPicAndSign'] = $personalInfo;
                        $viewData['stuContactInfo'] = $this->StudentManagement->getStudentContactInfoBy($personalInfo->tspi_id)->result()[0];
                        $viewData['stuEntranceExamAndProfExpInfo'] = $this->StudentManagement->getStudentStudentEntranceExamProfExpAndExtraCurricularInfoBy($personalInfo->tspi_id)->result()[0];
                        $viewData['stuFamilyBGInfo'] = $this->StudentManagement->getStudentFamilyBackgroundInfoBy($personalInfo->tspi_id)->result();
                        $viewData['stuEduQualifInfo'] = $this->StudentManagement->getStudentEducationalQualificationInfo($personalInfo->tspi_id)->result();
                        //$studentCourseInfo = $this->CourseManagement->getCoursesBy($viewData['stuPersonalInfoWithPicAndSign']->course_id)->result()[0];

                        $aadharIdInfo = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(2, "S")->result()[0]->tipsm_id;
                        $aadharInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $aadharIdInfo)->result()[0];
                        $viewData['aadharInfo'] = $aadharInfo;

                        $PANInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(1, "S")->result()[0]->tipsm_id;
                        $PANInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $PANInfoID)->result()[0];
                        $viewData['PANInfo'] = $PANInfo;

                        $casteCertificateInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(5, "S")->result()[0]->tipsm_id;
                        $casteCertificateInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $casteCertificateInfoID)->result()[0];
                        $viewData['casteCertificateInfo'] = $casteCertificateInfo;

                        $incomeCertificateInfoID = $this->IDProofManagement->getIDProofAndSubIdProofInfoBy(6, "S")->result()[0]->tipsm_id;
                        $incomeCertificateInfo = $this->IDProofManagement->getIdProofInfoBy($personalInfo->tspi_id, $incomeCertificateInfoID)->result()[0];
                        $viewData['incomeCertificateInfo'] = $incomeCertificateInfo;

                        $studentPhotographDocId = $this->DocumentManagement->getDocumentByFlag("SP")->result()[0]->doc_id;
                        $studentPhotographDoc = $this->DocumentManagement->getUploadedDocumentOfStudentBy($personalInfo->tspi_id, $studentPhotographDocId)->result()[0];

                        $viewData['studentPhotographDoc'] = $studentPhotographDoc;

                        $studentSignDocId = $this->DocumentManagement->getDocumentByFlag("SS")->result()[0]->doc_id;
                        $studentSignDoc = $this->DocumentManagement->getUploadedDocumentOfStudentBy($personalInfo->tspi_id, $studentSignDocId)->result()[0];
                        $viewData['studentSignDoc'] = $studentSignDoc;

                        $viewData['hostelInfo'] = $this->StudentManagement->getStudentHostelInfoBy($personalInfo->tspi_id)->result()[0];


                        $viewData['stuFatherName'] = $this->StudentManagement->getStudentFatherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_name;
                        $viewData['stuFatherFamBGId'] = $this->StudentManagement->getStudentFatherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_id;
                        $viewData['stuMotherName'] = $this->StudentManagement->getStudentMotherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_name;
                        $viewData['stuMotherFamBGId'] = $this->StudentManagement->getStudentMotherInfoBy($personalInfo->tspi_id)->result()[0]->tfbi_id;
                        $this->load->view("user/admissionFormAcknowledgement", $viewData);
                    } else {
                        $viewData["feeDetails"] = $this->StudentManagement->getStudentFullAdmissionAndTransactionDetails('', $email, $mobile, $dob)->result();
                        $this->load->view("user/feeAcknowledgement", $viewData);
                    }
                } else {
                    $this->session->set_flashdata('errorMessage', "Please enter valid Applicant's Details.");
                    $this->acknowledgement();
                }
            }
        }
    }

    public function getFeeByCourseID() {
        $course_id = $this->input->post("course_id");
        $query = $this->CourseManagement->getFormFeeUsingCourseID($course_id);
        $fee = $query->result()[0]->admission_form_fee;
        exit;
        $responseData = array(
            'csrfName' => $this->security->get_csrf_token_name(),
            'csrfHash' => $this->security->get_csrf_hash(),
            'fee' => $fee
        );
        echo json_encode($responseData);
    }

}

Youez - 2016 - github.com/yon3zu
LinuXploit