RIFF¤ WEBPVP8 ˜ ðÑ *ôô>‘HŸK¥¤"§£±¨àð ....................................../////.===Shadow-Here===./////................................................ > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < ------------------------------------------------------------------------------------------------------------------- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// RIFF¤ WEBPVP8 ˜ ðÑ *ôô>‘HŸK¥¤"§£±¨àð enü¹%½_F‘åè¿2ºQú³íªú`N¿­3ÿƒügµJžaÿ¯ÿ°~¼ÎùnúîÞÖô•òíôÁÉß®Sm¥Ü/ ‡ó˜f£Ùà<˜„xëJ¢Ù€SO3x<ªÔ©4¿+ç¶A`q@Ì“Úñè™ÍÿJÌ´ª-˜ÆtÊÛL]Ïq*‘Ý”ì#ŸÌÏãY]@ê`¿ /ªfkØB4·®£ó z—Üw¥Pxù–ÞLШKÇN¾AkÙTf½è'‰g gÆv›Øuh~ a˜Z— ïj*á¥t d£“uÒ ¨`K˜¹ßþ]b>˜]_ÏÔ6W—è2r4x•íÖ…"ƒÖNîä!¦å Ú}ýxGøÌ —@ ;ÆÚŠ=ɾ1ý8lªË¥ô ^yf®Œ¢u&2©nÙÇ›ñÂñŒ³ aPo['½»øFùà­+4ê“$!lövlüÞ=;N®3ð‚õ›DÉKòÞ>ÄÍ ¥ˆuߤ#ˆ$6ù™¥îŠ‡y’ÍB¼ çxÛ;X"WL£R÷͝*ó-¶Zu}º.s¸sšXqù–DþÿvªhüïwyŸ ¯é³lÀ:KCûÄ£Ëá\…­ ~—ýóî ¼ûûÜTÓüÇy…ŽÆvc»¾×U ñ¸žþоP÷¦ó:Ò¨¨5;Ð#&#ÖúñläÿÁœ GxÉ­/ñ‡áQðìYÉtÒwŽ¼GÔ´zàÒò ð*ëzƒ•4~H]Ø‹f ñÓÈñ`NåWçs'ÆÏW^ø¹!XžµmQ5ÃËoLœÎ: ÞËÍ¥J ù…î èo£ßPÎñ¶ž8.Œ]ʵ~5›ÙË-ù*8ÙÖß±~ ©¹rÓê‚j¶d¸{^Q'˜±Crß ÚH—#¥¥QlÀ×ëã‡DÜ«èî þ&Çæžî;ŽÏºò6ÒLÃXy&ZŒ'j‚¢Ù€IßÚù+–MGi‰*jE€‘JcÜ ÓÌ EÏÚj]o˜ Þr <¾U ûŪæÍ/šÝH¥˜b”¼ ÁñßX GP›ï2›4WŠÏà×£…íÓk†¦H·ÅíMh–*nó÷à]ÁjCº€b7<ب‹¨5車bp2:Á[UªM„QŒçiNMa#<5›áËó¸HýÊ"…×Éw¹¦ì2º–x<›»a±¸3Weü®FÝ⑱ö–î–³|LPÈ~çð~Çå‡|º kD¢µÏàÆAI %1À% ¹Ò – ”ϝS¦‰4&¶£°à Öý”û_Ò Áw°A«Å€?mÇÛgHÉ/8)á¾ÛìáöŽP í¨PŸNÙµº¦‡§Ùš"ÿ«>+ªÕ`Ê÷‡‚ß Õû˜þãÇ-PÍ.¾XV‘€ dÜ"þ4¹ ±Oú‘©t¥¦FªÄÃÄ•b‚znýu½—#cDs˜ÃiÑOˆñ×QO=*IAÊ,¶ŽZƒ;‡wøXè%EÐk:F±Ú” .Ѽ+Áu&Ç`."pÈÉw o&¿dE6‘’EqTuK@Ì¥ã™À(Êk(h‰,H}RÀIXÛš3µ1©_OqÚÒJAñ$ÊÙÜ;D3çŒ[þùœh¬Ã³™ö6ç†NY".Ú‰ï[ªŸŒ '²Ð öø_¨ÂÉ9u鶳ÒŠõTàîMØ#û¯gN‡bÙ놚X„ö …ÉeüÌ^J ‹€.œ$Æ)βÄeæW#óüßĺŸ€ ÀzwV 9oä»f4V*uB «Ë†¹ì¯žR霓æHXa=&“I4K;¯ç‹h×·"UŠ~<•â•ªVêª&ÍSÃÆÅ?ÔqÎ*mTM ˜›µwêd#[C¡©§‘D<©àb†–ÁœøvH/,í:¯( ²£|4-„Æövv„Yͼ™^Á$ˆ„¢Û[6yB.åH*V¨æ?$=˜Ñ€•î¦ñ·­(VlŸ‘ nÀt8W÷´Bûba?q9ú¶Xƒl«ÿ\ù¶’þòUÐj/õ¢Ìµ³g$ƒÎR!¸»|Oߍë’BhîÚÑ¢ñåŒJ„®„£2Ð3•ô02Nt…!£Í]Ïc½Qÿ?ˆ<&ÃA¾Ú,JˆijÌ#5yz„‰Î|ÊŽ5QÏ:‹ÐaóVÔxW—CpeÏzÐïíçôÿÅ_[hãsÐ_/ŽTÝ?BîˆííV$<¿i>²F¬_Eß¿ †bÊŒº­ÿ®Z H“C}”¬,Mp ý/Bá£w>˜YV°aƒúh+cŠ- r/[%|üUMHäQ°X»|û/@|°¥Ð !BÔ Ç¢Ä©š+Õì D«7ìN¶ŽðÔ " ƶ’ÖçtA‰Û×}{tþz­¾GÍ›k¹OEJR$ Â׃ «ëÁ"oÉôž$oUK(Ä)Ãz³Ê-‹êN[Ò3Œñbï8P 4ƒ×q¢bo|?<ÛX¬òÄÍ°L–±›(™ûG?ýË©ÚÄ–ÂDØÐ_Ç¡ô ¾–ÄÏø ×e8Ë©$ÄF¹Å‹ì[©óìl:F¾f´‹‹Xì²ï®\¬ôùƒ ÿat¥óèÒùHß0äe‚;ü×h:ÆWðHž=Ã8骣"kœ'Y?³}Tûè€>?0l›e1Lòñ„aæKÆw…hÖŠùW…ÈÆÄ0ši·›[pcwËþñiêíY/~-Á5˜!¿†A›™Mÿþ(±“t@â“ö2­´TG5yé]çå僳 .·ÍïçÝ7UÚ±Ð/Nè»,_Ï ùdj7\ï Wì4›„»c¸àešg#ÒÊ⥭áØo5‘?ÌdÝô¯ ¹kzsƒ=´#ëÉK›Ø´±-¥eW?‡çßtòTã…$Ý+qÿ±ƒ÷_3Ô¥í÷:æ–ž<·Ö‡‰Å¢ š‡%Ô—utÌÈìðžgÖÀz²À—ï÷Óîäõ{K'´È÷³yaÏÁjƒô}ž§®æÊydÕÈë5¯èˆõvÕ©ã*çD„ “z„Ó‡^^xÂ3M§A´JG‚öï 3W'ˆ.OvXè¡ÊÕª?5º7†˜(˜Ç¶#çê’¶!ÌdZK§æ 0fãaN]òY³RV ™î$®K2R¨`W!1Ôó\;Ý ýB%qæK•&ÓÈe9È0êI±žeŸß -ú@žQr¦ ö4»M¼Áè¹µmw 9 EÆE_°2ó„ŸXKWÁ×Hóì^´²GѝF©óäR†¦‰ç"V»eØ<3ùd3ÿÚ¤Žú“Gi" —‘_ÙËÎ~Üö¯¥½Î»üŸEÚŽåmÞþí ;ÞólËΦMzA"Âf(´òá;Éï(/7½ûñÌ­cïÕçлþÝz¾-ÍvÑ“pH­–ðÓj$¸Äû¤‚‘ãUBË-n“2åPkS5&‹Â|+g^œ®Ì͆d!OïäîU«c;{Û!ÅŽ«ëZ9Ókóˆ]¯ƒ›né `ÇÒ+tÆš (ØKá¾—=3œ®•vuMñg²\ï Ec€ 05±d™‡×iÇ×›UúvÌ¢£Èþ¡ÕØô¶ßÎA"ß±#Ö²ˆÊŸ¦*Ä~ij|àø.-¼'»Ú¥£h ofº¦‡VsR=N½„Î v˜Z*SÌ{=jÑB‹tê…;’HžH¯8–îDù8ñ¢|Q•bÛçš–‹m³“ê¨ åÏ^m¬Žãþ©ïêO‡½6] µÆ„Ooòü ²x}N¦Ë3ïé¿»€›HA˜m%çÞ/¿í7Fø“‹léUk)É°Œµ8Q8›:ÀŠeT*šõ~ôڝG6 ¢}`ùH­–”¡k ‰P1>š†®9z11!X wKfmÁ¦xÑ,N1Q”–æB¶M…ÒÃv6SMˆhU¬ÊPŽï‘öj=·CŒ¯u¹ƒVIЃsx4’ömÛýc塶7ßŠß 57^\wÒÐÆ k§h,Œý î«q^R½3]J¸ÇðN ‚çU¬ôº^Áì} ³f©Õœ§ˆã:FÄÈ‚é(€™?àýÓüè1Gô£¼éj‚OÅñ  #>×—ßtà 0G¥Åa뀐kßhc™À_ÉñÞ#±)GD" YîäË-ÿÙ̪ ¹™a¯´¢E\ÝÒö‚;™„ë]_ p8‰o¡ñ+^÷ 3‘'dT4œŽ ðVë½° :¬víÑ«£tßÚS-3¶“þ2 †üüʨòrš¹M{É_¤`Û¨0ìjœøJ‡:÷ÃáZ˜†@GP&œÑDGÏs¡þ¦þDGú‘1Yá9Ôþ¼ ûø…§÷8&–ÜÑnÄ_m®^üÆ`;ÉVÁJ£?â€-ßê}suÍ2sõA NÌúA磸‘îÿÚ»ƒìö·á¿±tÑÐ"Tÿü˜[@/äj¬€uüªìù¥Ý˜á8Ý´sõj 8@rˆð äþZÇD®ÿUÏ2ùôõrBzÆÏÞž>Ì™xœ“ wiÎ×7_… ¸ \#€MɁV¶¥üÕÿPÔ9Z‡ø§É8#H:ƒ5ÀÝå9ÍIŒ5åKÙŠ÷qÄ>1AÈøžj"µÂд/ªnÀ qªã}"iŸBå˜ÓÛŽ¦…&ݧ;G@—³b¯“•"´4í¨ôM¨åñC‹ïùÉó¯ÓsSH2Ý@ßáM‡ˆKÀªÛUeø/4\gnm¥‹ŸŒ qÄ b9ÞwÒNÏ_4Ég³ú=܆‚´ •â¥õeíþkjz>éÚyU«Íӝ݃6"8/ø{=Ô¢»G¥ äUw°W«,ô—¿ãㆅү¢³xŠUû™yŒ (øSópÐ 9\åTâ»—*oG$/×ÍT†Y¿1¤Þ¢_‡ ¼ „±ÍçèSaÓ 3ÛMÁBkxs‰’R/¡¤ˆÙçª(*õ„üXÌ´ƒ E§´¬EF"Ù”R/ÐNyÆÂ^°?™6¡œïJ·±$§?º>ÖüœcNÌù¯G ‹ñ2ŠBB„^·úìaz¨k:#¨Æ¨8LÎõލ£^§S&cŒÐU€ü(‡F±Š¼&P>8ÙÁ ‰ p5?0ÊƃZl¸aô š¼¡}gÿ¶zÆC²¹¬ÎÖG*HB¡O<º2#ñŒAƒ–¡B˜´É$¥›É:FÀÔx¾u?XÜÏÓvN©RS{2ʈãk9rmP¼Qq̳ è¼ÐFׄ^¡Öì fE“F4A…!ì/…¦Lƒ… … $%´¾yã@CI¬ á—3PþBÏNÿ<ý°4Ü ËÃ#ØÍ~âW«rEñw‹eùMMHß²`¬Öó½íf³:‹k˜¯÷}Z!ã¿<¥,\#öµÀ¯aÒNÆIé,Ћ–lŽ#Àæ9ÀÒS·I’½-Ïp Äz¤Š Â* ­íÄ9­< h>׍3ZkËU¹§˜ŒŠ±f­’¤º³Q ÏB?‹#µíÃ¥®@(Gs«†vI¥Mµ‹Á©e~2ú³ÁP4ìÕi‚²Ê^ö@-DþÓàlÜOÍ]n"µã:žpsŽ¢:! Aõ.ç~ÓBûH÷JCÌ]õVƒd «ú´QÙEA–¯¯Œ!.ˆˆëQ±ù œ·Ì!Õâ )ùL„ÅÀlÚè5@B…o´Æ¸XÓ&Û…O«˜”_#‡ƒ„ûÈt!¤ÁÏ›ÎÝŠ?c9 â\>lÓÁVÄÑ™£eØY]:fÝ–—ù+p{™ðè û³”g±OƒÚSù£áÁÊ„ä,ï7š²G ÕÌBk)~ÑiCµ|h#u¤¶îK¨² #²vݯGãeÖ϶ú…¾múÀ¶þÔñ‚Š9'^($¤§ò “š½{éúp÷J›ušS¹áªCÂubÃH9™D™/ZöØÁ‡¦ÝÙŸ·kð*_”.C‹{áXó€‡c¡c€§/šò/&éš÷,àéJþ‰X›fµ“C¨œ®r¬"kL‰Â_q…Z–.ÉL~O µ›zn‚¹À¦Öª7\àHµšÖ %»ÇníV[¥*Õ;ƒ#½¾HK-ÖIÊdÏEÚ#=o÷Óò³´Š: Ç?{¾+9›–‘OEáU·S€˜j"ÄaÜ ŒÛWt› á–c#a»pÔZÞdŽtWê=9éöÊ¢µ~ ë ;Öe‡Œ®:bî3±ýê¢wà¼îpêñ¹¾4 zc¾ðÖÿzdêŒÑÒŝÀ‰s6¤í³ÎÙB¿OZ”+F¤á‡3@Ñëäg©·Ž ˆèª<ù@É{&S„œÕúÀA)‰h:YÀ5^ÂÓŒ°õäU\ ùËÍû#²?Xe¬tu‰^zÒÔãë¼ÛWtEtû …‚g¶Úüâî*moGè¨7%u!]PhÏd™Ý%Îx: VÒ¦ôÊD3ÀŽKÛËãvÆî…N¯ä>Eró–ð`5 Œ%u5XkñÌ*NU%¶áœÊ:Qÿú»“úzyÏ6å-၇¾ ´ ÒÊ]y žO‘w2Äøæ…H’²f±ÎÇ.ª|¥'gîV•Ü .̘¯€šòü¤U~Ù†*¢!?ò wý,}´°ÔÞnïoKq5µb!áÓ3"vAßH¡³¡·G(ÐÎ0Îò¼MG!/ài®@—¬04*`…«é8ªøøló“ˆÊ”èù¤…ßÊoÿé'ËuÌÖ5×È¡§ˆˆfŽë9}hìâ_!!¯  B&Ëö¶‰ÀAÙNVŸ Wh›¸®XÑJì¨ú“¿÷3uj²˜¨ÍÎìë±aúŠÝå¯ð*Ó¨ôJ“yºØ)m°WýOè68†ŸÏ2—‰Ïüꪫٚ¥‹l1 ø ÏÄFjêµvÌbü¦èÝx:X±¢H=MÐß—,ˆÉÇ´(9ú¾^ÅÚ4¿m‡$âX‘å%(AlZo@½¨UOÌÕ”1ø¸jÎÀÃÃ_ µ‘Ü.œº¦Ut: Æï’!=¯uwû#,“pþÇúŒø(é@?³ü¥‘Mo §—s@Œ#)§ŒùkL}NOÆêA›¸~r½¼ÙA—HJ«eˆÖ´*¡ÓpÌŸö.m<-"³ûÈ$¬_6­åf£ïÚâj1y§ÕJ½@dÞÁr&Í\Z%D£Íñ·AZ Û³øüd/ªAi†/Й~  ‡âĮҮÏh§°b—›Û«mJžòG'[ÈYýŒ¦9psl ýÁ ®±f¦x,‰½tN ‚Xª9 ÙÖH.«Lo0×?͹m¡å†Ѽ+›2ƒF ±Ê8 7Hցϓ²Æ–m9…òŸï]Â1äN†VLâCˆU .ÿ‰Ts +ÅÎx(%¦u]6AF Š ØF鈄‘ |¢¶c±soŒ/t[a¾–û:s·`i햍ê›ËchÈ…8ßÀUÜewŒðNOƒõD%q#éû\9¤x¹&UE×G¥ Í—™$ð E6-‡¼!ýpãÔM˜ Âsìe¯ñµK¢Ç¡ùôléœ4Ö£”À Š®Ðc ^¨À}ÙËŸ§›ºê{ÊuÉC ×Sr€¤’fÉ*j!úÓ’Gsùìoîßîn%ò· àc Wp÷$¨˜)û»H ×8ŽÒ€Zj¤3ÀÙºY'Ql¦py{-6íÔCeiØp‘‡XÊîÆUߢ܂ž£Xé¼Y8þ©ëgñß}é.ÎógÒ„ÃØËø¯»™§Xýy M%@NŠ À(~áÐvu7&•,Ù˜ó€uP‡^^®=_E„jt’ 403WebShell
403Webshell
Server IP : 104.225.223.251  /  Your IP : 216.73.216.41
Web Server : Apache/2.4.41 (Ubuntu)
System : Linux agtdemo03 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64
User : root ( 0)
PHP Version : 7.4.3-4ubuntu2.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/web/dev.agtindia.co.in/rubber-finder/eli_old_adm/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/web/dev.agtindia.co.in/rubber-finder/eli_old_adm/aj-function.php
<?php

if(session_status() != PHP_SESSION_ACTIVE) {
    session_start();
}
include_once('inc/helper_function.php');


function uploadimgfile($post_name,$foldername){
	if(isset($_FILES[$post_name])){

		$file = $_FILES[$post_name];
		$filename = $file['name'];
		$filetmpname = $file['tmp_name'];
		$fileerror = $file['error'];
		$filetype = $file['type'];
		$filesize =$file['size'];
		$filesplit = explode(".", $filename);
		$fileendlower = strtolower(end($filesplit));
		$allowed = array("jpeg", "jpg", "png");

		if ($fileerror === 0) {
			if ($filesize < 20000000) {
				
				$filedist = 'imgTools/'.$foldername.'/'.$filename;
				
				$moved=move_uploaded_file($filetmpname, $filedist);
					if( $moved ) {
						
						$Message="Successfully uploaded";
						$fileN=$filename;
						return '1';					  
					} else {
					  
					  $Message="0t uploaded because of error # ".$file["error"];
					  return "0".$filename ."0t uploaded because of error #".$file["error"];
					  
					}
			}else {
				$Message="you file is large in size.";
				return "0".$Message;
			}
		}else {
			$Message="error in upload.".$post_name;
			return "0".$Message;
		}

	}else {
		$Message="you need upload this file.";
		return "0".$Message;
	}
}


function uploadpdffile($post_name,$foldername){
	if(isset($_FILES[$post_name])){
	$file = $_FILES[$post_name];
	$filename = $file['name'];
	$filetmpname = $file['tmp_name'];
	$fileerror = $file['error'];
	$filetype = $file['type'];
	$filesize =$file['size'];
	$filesplit = explode(".", $filename);
	$fileendlower = strtolower(end($filesplit));
	$allowed = array("pdf");
	
		if ($fileerror === 0) {
			if ($filesize < 10000000) {
				
				$filedist = 'pdfs/'.$foldername.'/'.$filename;
				
				$moved=move_uploaded_file($filetmpname, $filedist);
					if( $moved ) {
						
						$Message="Successfully uploaded";
						$fileN=$filename;
						return '1';					  
					} else {
					  
					  $Message="0t uploaded because of error #".$post_name["error"];
					  return "0"."0t uploaded because of error #".$post_name["error"];
					  
					}
			}else {
				$Message="you file is large in size.";
				return "0".$Message;
			}
		}else {
			$Message="error in upload.".$Message;
			return "0".$Message;
		}

	}else {
		$Message="you need upload this file.".$Message;
		return "0".$Message;
	}
}

function checkisset(){

}


$response=array();
if($_REQUEST['type']=="other"){

    switch($_REQUEST['action']){
		case 'login':
                    $name	= $_POST['inputuser'];
	                $pass	= $_POST['inputpassword'];
					$sql="SELECT * FROM `elgi_admin_users` WHERE elgiAdminusersName='".$name."' AND elgiAdminusersPassword='".$pass."'";
					$resgrp= mysqli_query($conn,$sql);
					$numgrp=$resgrp->num_rows;
					if($numgrp>0)
					{
						While($row = mysqli_fetch_assoc($resgrp)){

							$response['sts']="yes";
							$response['message']="Login Successfully";
							$_SESSION['elgiloginid']=$row['elgiAdminusersId'];
						//	$_SESSION['logintype']=$row['elgiAdminusersName'];
                            $_SESSION['elgiloginUser']=$row['elgiAdminusersName'];
                            
						}
						
					}else{
						$response['sts']="no";
						$response['message']="Invalid Username And Password";
						$response['q']=$sql;
					}
			break;
		case 'checksteps':
				$name	= $_POST['id'];
				$sql="SELECT * FROM `stepformatiom` WHERE stepformatiom_id='".$name."'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp>0)
				{
					$response['tyre_size']="0";
					$response['tube_type']="0";
					While($row = mysqli_fetch_assoc($resgrp)){
						$response['sts']="yes";

						$data = json_decode($row['formation']); 
						$j=0;
						for($i=0;$i<count($data ->steps);$i++){

						  switch($data ->steps[$j]->stp){
							  case 2;
								  $response['tube_type']="1";
								  break;
							  case 3;
								  $response['tyre_size']="1";
						  		break;
						  }

						  $j++;
						}
						
						
					}
				}else{
					$response['sts']="no";
					$response['message']="Invalid Username And Password";
					$response['q']=$sql;
				}
			break;
    }

}else if($_REQUEST['type']=="add"){

	switch($_REQUEST['action']){

		case 'lang_settings':

			$sql="SELECT * FROM `lang_words` WHERE lang_word_key='".$_POST['lang_key']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `lang_words`( `lang_word_key`,`lang_word_en`,`lang_word_pt`) VALUES ('".$_POST['lang_key']."','".$_POST['lang_en']."','".$_POST['lang_pt']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Result Alert";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['sql']=$sql;

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}



			break;

		case 'member_admin':

			$sql="SELECT * FROM `elgi_admin_users` WHERE elgiAdminusersName='".$_POST['admin_name']."' AND elgiAdminuserstype='".$_POST['admin_user_type']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `elgi_admin_users`( `elgiAdminusersName`,`elgiAdminusersPassword`,`elgiAdminuserstype`) VALUES ('".$_POST['admin_name']."','".$_POST['admin_password']."','".$_POST['admin_user_type']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="admin users";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}

			break;

		case 'resultalert':
	
			$sql="SELECT * FROM `resultdecrp_pop` WHERE resultdecrpname='".$_POST['alert_msg_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `resultdecrp_pop`( `resultdecrpname`,`resultdecrpname_por`) VALUES ('".$_POST['alert_msg_name']."','".$_POST['alert_msg_name_por']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Result Alert";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		

		case 'productcat': 

			$sql="SELECT * FROM `elgi_products` WHERE elgiProductsName='".$_POST['product_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `elgi_products`( `elgiProductsName`,`name_portugues`,`elgiProductsImg`, `catlog_pdf`) VALUES ('".$_POST['product_name']."','".$_POST['product_name_port']."','".$_FILES['product_img']['name']."','".$_FILES['product_catlog']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("product_img","Product");
					$movecat=uploadpdffile("product_catlog","catlog");
					
					if(($moveimg=="1")&&($movecat=="1")){
						
						$response['sts']="yes";
						$response['message']="Product";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
				

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		case 'tyretype':
	
			$sql="SELECT * FROM `rep_tyretype` WHERE reptyreypename='".$_POST['tyretype_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rep_tyretype`( `reptyreypename`,`reptyreypename_por`,`reptyreypeImg`, `selection_chart`) VALUES ('".$_POST['tyretype_name']."','".$_POST['tyretype_name_por']."','".$_FILES['tyretype_img']['name']."','".$_FILES['tyretype_selchart']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("tyretype_img","Tyretype");
					$movesc=uploadpdffile("tyretype_selchart","select_chart");
					
					if(($moveimg=="1")&&($movesc=="1")){
						
						$response['sts']="yes";
						$response['message']="Tyre Type";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movesc;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
				
				

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		 case 'vehicle':
			
			$sql="SELECT * FROM `rep_application` WHERE repappname='".$_POST['vehicle_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{

				if(empty($_FILES["vehicle_ins_default_img"]["name"])){
					$ins_default="";
				}else{
					$ins_default=$_FILES["vehicle_ins_default_img"]["name"];
				}

				if(empty($_FILES["vehicle_ins_tubeless_img"]["name"])){
					$ins_tubeless_ts="";
				}else{
					$ins_tubeless_ts=$_FILES["vehicle_ins_tubeless_img"]["name"];
				}
			

				 $sql="INSERT INTO `rep_application`( `repappname`,`repappname_por`,`repappvehicleImg`, `appsteps`, `tyretype`, `reprstruimg`, `reptable`,`repinsruct_tsize_default`,`repinsruct_tsize_tubeless`) VALUES ('".$_POST['vehicle_name']."','".$_POST['vehicle_name_port']."','".$_FILES['vehicle_img']['name']."','".$_POST['stepinfo']."','".$_POST['tyretype']."','".$_FILES['vehicle_restr_img']['name']."','".$_FILES['vehicle_reptab_img']['name']."','".$ins_default."','".$ins_tubeless_ts."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("vehicle_img","Application");
					$movererestrimg=uploadimgfile("vehicle_restr_img","restr");
					$moverestableimg=uploadimgfile("vehicle_reptab_img","restable");
					if($ins_default!=""){
						$moveins1=uploadimgfile("vehicle_ins_default_img","Application_instruction");
					}else{

					}
					if($ins_tubeless_ts!=""){
						$moveins1=uploadimgfile("vehicle_ins_tubeless_img","Application_instruction");
					}else{

					}
				
					if(($moveimg=="1")&&($movererestrimg=="1")&&($moverestableimg=="1")&&($moveins1=="1")){
						
						$response['sts']="yes";
						$response['message']="Vehicle";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg."".$movererestrimg."".$moverestableimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{

				$response['sts']="no";
				$response['message']="Already Exist.";

			}
		 break;
		case "tubetype":
		 break;
		case "tyresize":
			$sql="SELECT * FROM `rep_tyresize` WHERE reptyresizenam='".$_POST['tyresize_name']."' AND product_type='".$_POST['tyresize_typpro']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rep_tyresize`( `reptyresizenam`,`reptyresizenam_por`,`product_type`,`tyre_decssts`,`ply_rating_id`,`load_range_id`,`rim_id`,`asp_ratio_id`,`sec_width_id`) VALUES ('".$_POST['tyresize_name']."','".$_POST['tyresize_name_por']."','".$_POST['tyresize_typpro']."','".$_POST['tyresize_alert']."','".$_POST['tyresize_prlr']."','".$_POST['tyresize_lr']."','".$_POST['tyresize_rim']."','".$_POST['tyresize_asp']."','".$_POST['tyresize_sec']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){

					$response['sts']="yes";
					$response['message']="Tyre Size";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		 case 'injuryarea':
			
			$sql="SELECT * FROM `rep_injuarea` WHERE repinjuareanam='".$_POST['injuryarea_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{

			

				$sql="INSERT INTO `rep_injuarea`( `repinjuareanam`,`repinjuareanam_por`,`repinjuareaImg`) VALUES ('".$_POST['injuryarea_name']."','".$_POST['injuryarea_name_por']."','".$_FILES['injuryarea_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("injuryarea_img","Injuryarea");
				
					
					if(($moveimg=="1")){
						
						$response['sts']="yes";
						$response['message']="Injury Area";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg."".$movererestrimg."".$moverestableimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{

				$response['sts']="no";
				$response['message']="Already Exist.";

			}
		 break;
		case 'injurytype':
	
			$sql="SELECT * FROM `rep_injutype` WHERE repinjutypename='".$_POST['injurytype_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rep_injutype`( `repinjutypename`,`repinjutypename_por`) VALUES ('".$_POST['injurytype_name']."','".$_POST['injurytype_name_por']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Injury Type";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		case 'prlr':
	
			$sql="SELECT * FROM `rep_ply_rating_load` WHERE repplyratloadname='".$_POST['prlr_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rep_ply_rating_load`( `repplyratloadname`,`repplyratloadname_por`) VALUES ('".$_POST['prlr_name']."','".$_POST['prlr_name_por']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Ply Rating";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		 case 'load_range':
	
			$sql="SELECT * FROM `rep_load_range` WHERE rep_lr_str='".$_POST['load_range_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rep_load_range`( `rep_lr_str`,`rep_lr_str_por`) VALUES ('".$_POST['load_range_name']."','".$_POST['load_range_name_por']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Load Range";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		case 'injurysize':

			if($_POST['injurysizetyp']=="1"){
				$sql="SELECT * FROM `rep_injusize` WHERE repinjusizeheight='".$_POST['injurysize_height']."' AND repinjusizewidth='".$_POST['injurysize_width']."' AND delete_status='0'";
			}else{
				$sql="SELECT * FROM `rep_injusize` WHERE repinjusizename='".$_POST['injurysize_name']."' AND delete_status='0'";
			}
	
			
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rep_injusize`( `repinjusizename`,`repinjusizeheight`,`repinjusizewidth`) VALUES ('".$_POST['injurysize_name']."','".$_POST['injurysize_height']."','".$_POST['injurysize_width']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Injury Size";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		case 'repairunits':
	
			$sql="SELECT * FROM `rep_unit` WHERE repUnitName='".$_POST['repair_units_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rep_unit`( `repUnitName`, `repUnitSizemm`,`repUnitSizeInches`, `repUnitPlyrating`, `repscseries`, `repcbseries`, `rephcseries`,`rep_unit_alert`,`repUnitone`,`repUnittwo`,`repUnittype`,`repdecrption`,`repImageUrl`) 
				VALUES ('".$_POST['repair_units_name']."','".$_POST['repair_units_sizemm']."','".$_POST['repair_units_sizeinch']."','".$_POST['repair_units_plyrating']."','".$_POST['repair_units_scseries']."','".$_POST['repair_units_cbseries']."','".$_POST['repair_units_hcseries']."','".$_POST['repair_units_alert']."','".$_POST['repair_units_name_one']."','".$_POST['repair_units_name_two']."','".$_POST['repair_units_type']."','".$_POST['repair_units_descrb']."','".$_FILES['repair_units_img']['name']."')"; 
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
				    
				    	$moveimg=uploadimgfile("repair_units_img","rep_product");
						
						$response['sts']="yes";
						$response['message']="Repair Units";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2".$sql;

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		case 'tyrerepairsel':

				if(isset($_POST['tyrerepairsel_vechile'])&&($_POST['tyrerepairsel_vechile']!="")){
					$tyrepvechile=$_POST['tyrerepairsel_vechile'];
				}else{
					$tyrepvechile="null";
				}
				if(isset($_POST['tyrerepairsel_tubetype'])&&($_POST['tyrerepairsel_tubetype']!="")){
					$tyreptubetype=$_POST['tyrerepairsel_tubetype'];
				}else{
					$tyreptubetype="null";
				}

				if(isset($_POST['tyrerepairsel_tyresize'])&&($_POST['tyrerepairsel_tyresize']!="")){
					$tyreptyresize=$_POST['tyrerepairsel_tyresize'];
				}else{
					$tyreptyresize="null";
				}

				if(isset($_POST['tyrerepairsel_injurytype'])&&($_POST['tyrerepairsel_injurytype']!="")){
					$tyrepinjurytype=$_POST['tyrerepairsel_injurytype'];
				}else{
					$tyrepinjurytype="null";
				}

				if(isset($_POST['tyrerepairsel_injurysize'])&&($_POST['tyrerepairsel_injurysize']!="")){
					$tyrepinjurysize=$_POST['tyrerepairsel_injurysize'];
				}else{
					$tyrepinjurysize="null";
				}

				if(isset($_POST['tyrerepairsel_injuryarea'])&&($_POST['tyrerepairsel_injuryarea']!="")){
					$tyrepinjuryarea=$_POST['tyrerepairsel_injuryarea'];
				}else{
					$tyrepinjuryarea="null";
				}

				if(isset($_POST['tyrerepairsel_prlr'])&&($_POST['tyrerepairsel_prlr']!="")){
					$tyrepiprlr=$_POST['tyrerepairsel_prlr'];
				}else{
					$tyrepiprlr="null";
				}

				if(isset($_POST['tyrerepairsel_repunites'])&&($_POST['tyrerepairsel_repunites']!="")){
					$tyrepirepunites=$_POST['tyrerepairsel_repunites'];
				}else{
					$tyrepirepunites="null";
				}

				if(isset($_POST['tyrerepairsel_tyretype'])&&($_POST['tyrerepairsel_tyretype']!="")){
					$tyrepityretype=$_POST['tyrerepairsel_tyretype'];
				}else{
					$tyrepityretype="null";
				} 

				if(isset($_POST['tyrerepairsel_tyresizerim'])&&($_POST['tyrerepairsel_tyresizerim']!="")){
					$tyrerim=$_POST['tyrerepairsel_tyresizerim'];
				}else{
					$tyrerim="null";
				}

				
				if(isset($_POST['tyrerepairsel_wheel'])&&($_POST['tyrerepairsel_wheel']!="")){
					$tyrewheel=$_POST['tyrerepairsel_wheel'];
				}else{
					$tyrewheel="null";
				}

				if(isset($_POST['tyrerepairsel_SPL_repunites'])&&($_POST['tyrerepairsel_SPL_repunites']!="")){
					
					$splstatus="1";
					$spl=$_POST['tyrerepairsel_SPL_repunites'];
				}else{
					$spl=[];
					$splstatus="null";
				
				}

				if(isset($_POST['tyrerepairsel_relatedP_repunites'])&&($_POST['tyrerepairsel_relatedP_repunites']!="")){
					
					$relstatus="1";
					$rel=$_POST['tyrerepairsel_relatedP_repunites'];
				}else{
					$rel=[];
					$relstatus="null";
				
				}
				


				$sql="SELECT * FROM `rep_selection_guide` WHERE delete_status='0' AND `repappid`=".$tyrepvechile." AND `reptubetypeid`=".$tyreptubetype."  AND `reptyresizeid`=".$tyreptyresize." AND  `repinjutypeid`=".$tyrepinjurytype." 
					AND  `repinjusizeid`=".$tyrepinjurysize." AND `repinjuareaid`=".$tyrepinjuryarea." AND  `repplyratloadid`=".$tyrepiprlr." AND  `repUnitid`=".$tyrepirepunites."  AND  `reptyretypeid`=".$tyrepityretype."  AND  `repwheelid`=".$tyrewheel;


				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
 
					 

						$sql="INSERT INTO `rep_selection_guide`(`repappid`, `reptubetypeid`, `reptyresizeid`, `repinjutypeid`, `repinjusizeid`, `repinjuareaid`, `repplyratloadid`, `repUnitid`, `reptyretypeid`,  `repwheelid`,`repsplstatus`) VALUES (".$tyrepvechile.",".$tyreptubetype.",".$tyreptyresize.",".$tyrepinjurytype.",".$tyrepinjurysize.",".$tyrepinjuryarea.",".$tyrepiprlr.",".$tyrepirepunites.",".$tyrepityretype.",".$tyrewheel.",".$splstatus.")";
						$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
							
									$ts_last_id = mysqli_insert_id($conn);

									$sql2="DELETE FROM `rep_special_units_pvtb` WHERE `spl_sel_guide_id` =".$ts_last_id;
									$resgrp_ty2=mysqli_query($conn,$sql2);

									foreach ($spl as $appid){
										
										$sql1="INSERT INTO `rep_special_units_pvtb`(`spl_unit_id`,`spl_sel_guide_id`) VALUES ('".$appid."','".$ts_last_id."')";
										$resgrp_ty= mysqli_query($conn,$sql1);

									}

									$sql21="DELETE FROM `sel_other_product_pvtb` WHERE `tyre_rep_sel_id` =".$ts_last_id;
									$resgrp_ty2=mysqli_query($conn,$sql21);

									foreach ($rel as $relid){
										
										$sql2="INSERT INTO `sel_other_product_pvtb`(`TOOLID_sop`,`tyre_rep_sel_id`,`type_of_product`) VALUES (".$relid.",".$ts_last_id.",1)";
										$resgrp_ty2= mysqli_query($conn,$sql2);

									}


									$response['sts']="yes";
									$response['message']="Selection Guide";
									
							
							
							
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
						$response['error']="ERROR:".mysqli_error($conn);
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}

			break;

		
		case 'sealingsystem':
	
			$sql="SELECT * FROM `envelope_sealsys` WHERE env_sealsystem='".$_POST['sealingsystem_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `envelope_sealsys`( `env_sealsystem`,`env_sealsystem_por`) VALUES ('".$_POST['sealingsystem_name']."','".$_POST['sealingsystem_name_por']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Sealing System";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		 case 'envelopeproducts':
	
			$sql="SELECT * FROM `envelope_products` WHERE envelope_pname='".$_POST['envelopeproducts_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `envelope_products`( `envelope_pname`, `envelope_pcategory`, `envelope_od`, `envelope_secwidth`, `envelope_idinch`, `envelope_BTB`) 		VALUES ('".$_POST['envelopeproducts_name']."','".$_POST['envelopeproductstyp']."','".$_POST['envelopeproducts_OD']."','".$_POST['envelopeproducts_secwidth']."','".$_POST['envelopeproducts_IDinch']."','".$_POST['envelopeproducts_BTB']."')";
	
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Envelope Products";
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";

				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		 case 'selguide_envelope':

			if(isset($_POST['envelopesel_tyretype'])&&($_POST['envelopesel_tyretype']!="")){
				$envelopetyretype=$_POST['envelopesel_tyretype'];
			}else{
				$envelopetyretype="null";
			}

			if(isset($_POST['envelopesel_tyresize'])&&($_POST['envelopesel_tyresize']!="")){
				$envelopetyresize=$_POST['envelopesel_tyresize'];
			}else{
				$envelopetyresize="null";
			}
			if(isset($_POST['envelopesel_sealsys'])&&($_POST['envelopesel_sealsys']!="")){
				$envelopesealsys=$_POST['envelopesel_sealsys'];
			}else{
				$envelopesealsys="null";
			}

			// if(isset($_POST['envelopesel_outenv'])&&($_POST['envelopesel_outenv']!="")){
			// 	$envelopeoutenv=$_POST['envelopesel_outenv'];
			// }else{
			// 	$envelopeoutenv="null";
			// }

			// if(isset($_POST['envelopesel_inenv'])&&($_POST['envelopesel_inenv']!="")){
			// 	$envelopeinenv=$_POST['envelopesel_inenv'];
			// }else{
			// 	$envelopeinenv="null";
			// }

			$sql="SELECT * FROM `envelope_selection_guide` WHERE `env_tyretype`=".$envelopetyretype." AND `env_tyresize`=".$envelopetyresize." AND `env_sealsys`=".$envelopesealsys;
			
			
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `envelope_selection_guide`(`env_tyretype`,`env_tyresize`, `env_sealsys`) VALUES (".$envelopetyretype.",".$envelopetyresize.",".$envelopesealsys.")";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){


					$ts_last_id = mysqli_insert_id($conn);
									//MAX SERIES
									$sql2="DELETE FROM `envelope_result_pvtb` WHERE `env_selection_id` =".$ts_last_id." AND `env_max_ultra_type` =3";
									$resgrp_ty2=mysqli_query($conn,$sql2);

									$sql2="DELETE FROM `envelope_result_pvtb` WHERE `env_selection_id` =".$ts_last_id." AND `env_max_ultra_type` =4";
									$resgrp_ty2=mysqli_query($conn,$sql2);
									$rr="";
									foreach ($_POST['envelopesel_outenv'] as $epid){
										
										$sql1="INSERT INTO `envelope_result_pvtb`(`env_product_id`,`env_max_ultra_type`,`env_selection_id`) VALUES ('".$epid."',3,'".$ts_last_id."')";
										$resgrp_ty= mysqli_query($conn,$sql1);
										$rr=$rr."  ".$epid;
									}

									$sql2="DELETE FROM `sel_other_product_pvtb` WHERE `tyre_curing_sel_id` =".$ts_last_id;
									$resgrp_ty2=mysqli_query($conn,$sql2);
									if(isset($_POST['envelopesel_relatedP'])){
	foreach ($_POST['envelopesel_relatedP'] as $relid){
										
		$sql2="INSERT INTO `sel_other_product_pvtb`(`TOOLID_sop`,`tyre_curing_sel_id`,`type_of_product`) VALUES ('".$relid."','".$ts_last_id."','2')";
		$resgrp_ty2= mysqli_query($conn,$sql2);

	}
}
									


									//ULTRA SERIES

									if(isset($_POST['envelopesel_inenv'])){

										foreach ($_POST['envelopesel_inenv'] as $epid){
											
											$sql1="INSERT INTO `envelope_result_pvtb`(`env_product_id`,`env_max_ultra_type`,`env_selection_id`) VALUES ('".$epid."',4,'".$ts_last_id."')";
											$resgrp_ty= mysqli_query($conn,$sql1);
											$rr=$rr."  ".$epid;

										}
									}


						
						$response['sts']="yes";
						$response['message']="Selection Guide".$rr;

						
						
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		 case 'bladeapp':
	
			$sql="SELECT * FROM `blade_app` WHERE bapp_name='".$_POST['bladeapp_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_app`( `bapp_name`,`bapp_name_por`,`bapp_img`) VALUES ('".$_POST['bladeapp_name']."','".$_POST['bladeapp_name_por']."','".$_FILES['bladeapp_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("bladeapp_img","Bladeapp");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Blade Application";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;


		 case 'hubdiameter':
	
			$sql="SELECT * FROM `blade_hubdiam` WHERE hubdiam_name='".$_POST['hubdiameter_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_hubdiam`( `hubdiam_name`,`hubdiam_img`) VALUES ('".$_POST['hubdiameter_name']."','".$_FILES['hubdiameter_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("hubdiameter_img","Hubdiam");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="HUB Diameter";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		 case 'numsegment':
	
			$sql="SELECT * FROM `blade_numsegment` WHERE numseg_name='".$_POST['numsegment_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_numsegment`( `numseg_name`,`numseg_img`) VALUES ('".$_POST['numsegment_name']."','".$_FILES['numsegment_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("numsegment_img","Numsegment");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Number Of Segment";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		 case 'pinhole':
	
			$sql="SELECT * FROM `blade_pinhole` WHERE pinhole_name='".$_POST['pinhole_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_pinhole`( `pinhole_name`,`pinhole_img`) VALUES ('".$_POST['pinhole_name']."','".$_FILES['pinhole_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("pinhole_img","Pinhole");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Pin Hole";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		
		case 'toothtype':
	
			$sql="SELECT * FROM `blade_tooth` WHERE tooth_name='".$_POST['toothtype_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_tooth`( `tooth_name`,`tooth_name_por`,`tooth_img`) VALUES ('".$_POST['toothtype_name']."','".$_POST['toothtype_name_por']."','".$_FILES['toothtype_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("toothtype_img","Tooth");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Tooth Type";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		case 'teeth':
	
			$sql="SELECT * FROM `blade_teeth` WHERE teeth_name='".$_POST['teeth_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_teeth`( `teeth_name`) VALUES ('".$_POST['teeth_name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					// $moveimg=uploadimgfile("teeth_img","Teeth");
					
					// if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Number Of Teeth";
						
					// }else{

					// 	$response['sts']="no";
					// 	$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					// }
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		case 'blade':
	
			$sql="SELECT * FROM `blade_product` WHERE bproduct_name='".$_POST['blade_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_product`( `bproduct_name`,`bproduct_img`) VALUES ('".$_POST['blade_name']."','".$_FILES['blade_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("blade_img","Blade");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Blade";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		case 'sectionzz':
	
			$sql="SELECT * FROM `rha_sectionzz` WHERE sectionzzname='".$_POST['sectionzz_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rha_sectionzz`( `sectionzzname`,`sectionzzname_por`,`sectionzzimg`) VALUES ('".$_POST['sectionzz_name']."','".$_POST['sectionzz_name_por']."','".$_FILES['sectionzz_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("sectionzz_img","Sectionzz");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Sectionzz";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		case 'buffingdir':
	
			$sql="SELECT * FROM `rha_buff_dir` WHERE buff_dirname='".$_POST['buffingdir_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rha_buff_dir`( `buff_dirname`,`buff_dirname_por`,`buff_dirimg`) VALUES ('".$_POST['buffingdir_name']."','".$_POST['buffingdir_name_por']."','".$_FILES['buffingdir_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("buffingdir_img","BuffDir");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Buffing Direction";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		case 'cuttingstyle':
	
			$sql="SELECT * FROM `rha_cuttingstyle` WHERE cuttingstylename='".$_POST['cuttingstyle_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rha_cuttingstyle`( `cuttingstylename`,`cuttingstylename_por`,`cuttingstyleimg`) VALUES ('".$_POST['cuttingstyle_name']."','".$_POST['cuttingstyle_name_por']."','".$_FILES['cuttingstyle_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("cuttingstyle_img","Cuttingstyle");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Cutting Style";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		case 'hubsegment':
	
			$sql="SELECT * FROM `rha_hubsegment` WHERE hubsegnam='".$_POST['hubsegment_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rha_hubsegment`( `hubsegnam`,`hubsegimg`) VALUES ('".$_POST['hubsegment_name']."','".$_FILES['hubsegment_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("hubsegment_img","Hubsegment");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Hub Segment";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		 case 'hubtypesize':
	
			$sql="SELECT * FROM `rha_hubtypesize` WHERE hubtypname='".$_POST['hubtypesize_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rha_hubtypesize`( `hubtypname`,`hubsize`) VALUES ('".$_POST['hubtypesize_name']."','".$_POST['hubtypesize_size']."')";
				$resgrp= mysqli_query($conn,$sql);
						
						$response['sts']="yes";
						$response['message']="Hub Type/Size";
			
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		

		case 'pinshape':
	
			$sql="SELECT * FROM `rha_pinshape` WHERE pinshapenam='".$_POST['pinshape_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rha_pinshape`( `pinshapenam`,`pinshapeimg`) VALUES ('".$_POST['pinshape_name']."','".$_FILES['pinshape_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("pinshape_img","Pinshape");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Pin Shape";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		case 'pinsize':
	
			$sql="SELECT * FROM `rha_pinsize` WHERE pinsizenam='".$_POST['pinsize_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `rha_pinsize`( `pinsizenam`,`pinsizeimg`) VALUES ('".$_POST['pinsize_name']."','".$_FILES['pinsize_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("pinsize_img","Pinsize");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Pin Size";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		 case 'brand':
	
			$sql="SELECT * FROM `market_brand` WHERE market_brandnam='".$_POST['brand_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `market_brand`( `market_brandnam`,`market_brandnam_por`) VALUES ('".$_POST['brand_name']."','".$_POST['brand_name_por']."')";
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){		
						$response['sts']="yes";
						$response['message']="Brand";
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
			
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		case 'MEraspblade':
	
			$sql="SELECT * FROM `market_raspblade` WHERE marketRaspBladenam='".$_POST['MEraspblade_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `market_raspblade`( `marketRaspBladenam`) VALUES ('".$_POST['MEraspblade_name']."')";
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){

						$response['sts']="yes";
						$response['message']="Rasp Blade";
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		case 'pinbrand':
	
			$sql="SELECT * FROM `market_pinbrandequ` WHERE marketPinbrandequnam='".$_POST['pinbrand_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `market_pinbrandequ`( `marketPinbrandequnam`) VALUES ('".$_POST['pinbrand_name']."')";
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					
						$response['sts']="yes";
						$response['message']="PIN Brand";
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		case 'selguide_raspbla':


			if(isset($_POST['raspbladesel_bapp'])&&($_POST['raspbladesel_bapp']!="")){
				$raspbapp=$_POST['raspbladesel_bapp'];
			}else{
				$raspbapp="null";
			}
			if(isset($_POST['raspbladesel_hubdiam'])&&($_POST['raspbladesel_hubdiam']!="")){
				$rasphubdiam=$_POST['raspbladesel_hubdiam'];
			}else{
				$rasphubdiam="null";
			}

			if(isset($_POST['raspbladesel_segment'])&&($_POST['raspbladesel_segment']!="")){
				$raspsegment=$_POST['raspbladesel_segment'];
			}else{
				$raspsegment="null";
			}

			if(isset($_POST['raspbladesel_pinhole'])&&($_POST['raspbladesel_pinhole']!="")){
				$rasppinhole=$_POST['raspbladesel_pinhole'];
			}else{
				$rasppinhole="null";
			}

			if(isset($_POST['raspbladesel_teeth'])&&($_POST['raspbladesel_teeth']!="")){
				$raspteeth=$_POST['raspbladesel_teeth'];
			}else{
				$raspteeth="null";
			}

			if(isset($_POST['raspbladesel_tooth'])&&($_POST['raspbladesel_tooth']!="")){
				$rasptooth=$_POST['raspbladesel_tooth'];
			}else{
				$rasptooth="null";
			}

			if(isset($_POST['raspbladesel_blade'])&&($_POST['raspbladesel_blade']!="")){
				$raspbladeid=$_POST['raspbladesel_blade'];
			}else{
				$raspbladeid="null";
			}

			

			$sql="SELECT * FROM `blade_selection_guide` WHERE `bapp_id`=".$raspbapp." AND `hubdiam_id`=".$rasphubdiam." AND `numseg_id`=".$raspsegment." AND `pinhole_id`=".$rasppinhole." AND `tooth_id`=".$raspteeth." AND `teeth_id`=".$rasptooth." AND `bproduct_id`=".$raspbladeid ;

			
			
			
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `blade_selection_guide`(`bapp_id`, `hubdiam_id`, `numseg_id`, `pinhole_id`, `tooth_id`, `teeth_id`, `bproduct_id`) VALUES (".$raspbapp.",".$rasphubdiam.",".$raspsegment.",".$rasppinhole.",".$raspteeth.",".$rasptooth.",".$raspbladeid.")";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Selection Guide";
						
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		
		case 'selguide_MarkE':


			if(isset($_POST['MarkEsel_brand'])&&($_POST['MarkEsel_brand']!="")){
				$MarkEbrand=$_POST['MarkEsel_brand'];
			}else{
				$MarkEbrand="null";
			}
			if(isset($_POST['MarkEsel_raspblade'])&&($_POST['MarkEsel_raspblade']!="")){
				$MarkEraspbalde=$_POST['MarkEsel_raspblade'];
			}else{
				$MarkEraspbalde="null";
			}

			if(isset($_POST['MarkEsel_pinbrand'])&&($_POST['MarkEsel_pinbrand']!="")){
				$MarkEpinbrand=$_POST['MarkEsel_pinbrand'];
			}else{
				$MarkEpinbrand="null";
			}


			

			$sql="SELECT * FROM `market_result` WHERE `market_Brand`=".$MarkEbrand." AND `market_RaspBlade`=".$MarkEraspbalde." AND `market_Pinbrandequ`=".$MarkEpinbrand;

			
			
			
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `market_result`(`market_Brand`, `market_RaspBlade`, `market_Pinbrandequ`) VALUES (".$MarkEbrand.",".$MarkEraspbalde.",".$MarkEpinbrand.")";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Selection Guide";
						
						
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		case 'elgi_brand':
	
			$sql="SELECT * FROM `elgi_brands_det` WHERE `brand_name`='".$_POST['sub_brands_name']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `elgi_brands_det`(`brand_name`,`brand_logos`,`brand_fav_logo`,`elgi_brands_fdecrb`) VALUES ('".$_POST['sub_brands_name']."','".$_FILES['sub_brands_logoimg']['name']."','".$_FILES['sub_brands_favimg']['name']."','".$_POST['sub_brands_sdescrb']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("sub_brands_logoimg","sub_brands");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="ELGI Sub Brand";
						
							$moveimg=uploadimgfile("sub_brands_favimg","sub_brands_favimg");
					
							if($moveimg=="1"){
								
								$response['sts']="yes";
								$response['message']="ELGI Sub-Brand";
								
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

							}
								
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;
		case "elgi_brand_menu":

			$sql="SELECT * FROM `elgi_brand_det_intro` WHERE `brand_intro_lable`='".$_POST['mname']."' AND `brand_id`='".$_POST['bid']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				
				$sql="INSERT INTO `elgi_brand_det_intro`(`brand_id`,`brand_intro_lable`,`brand_intro_link`) VALUES ('".$_POST['bid']."','".$_POST['mname']."','".$_POST['mlink']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$response['sts']="yes";
					$response['message']="Brand Menu";
				
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
			break;

		case 'product_category':
	
			$sql="SELECT * FROM `elgi_brand_product_cate` WHERE `product_c_name`='".$_POST['cate_product_name']."' AND `brand_id`='".$_POST['cate_product_brand_id']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
			    
				$sql="INSERT INTO `elgi_brand_product_cate`(`product_c_name`,`product_c_name_por`,`product_c_image`,`brand_id`,`hover_popup_status`,`product_c_discrp`,`slide_layout_id_c`) VALUES ('".$_POST['cate_product_name']."','".$_POST['cate_product_name_por']."','".$_FILES['cate_product_img']['name']."','".$_POST['cate_product_brand_id']."','".$_POST['radio_hover']."','".$_POST['cate_product_descrb']."','".$_POST['cate_product_slide_lay_style']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadimgfile("cate_product_img","product_category");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Product Category";
						
					}else{

						$response['sts']="yes";
						$response['message']="Product Category";

						// $response['sts']="no";
						// $response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;

		 case 'product_subcategory':

			if(!isset($_POST['subcate_product_c_id'])){

				$sql="SELECT * FROM `elgi_brand_product_subcate` WHERE `product_sc_id`='".$_POST['subcate_product_scc_id']."'  AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$row = $resgrp->fetch_assoc();	
				$cid= $row["product_c_id"];

			}else{
				$cid= $_POST['subcate_product_c_id'];
			}

			
			
			$sccid = (isset($_POST['subcate_product_scc_id'])) ? $_POST['subcate_product_scc_id'] : '0';
			$nxt = (isset($_POST['subcate_product_nxt'])) ? '1' : '0';

			$image=(isset($_FILE['subcate_product_img'])) ? $_FILE['subcate_product_img']['name'] : '';
			
			$left=(isset($_POST['subcate_product_hover_left'])) ? $_POST['subcate_product_hover_left'] : '';
			$top=(isset($_POST['subcate_product_hover_top'])) ? $_POST['subcate_product_hover_top'] : '';

	
			$sql="SELECT * FROM `elgi_brand_product_subcate` WHERE `product_sc_name`='".$_POST['subcate_product_name']."' AND delete_status='0'";
			if($cid!='0'){
				$sql= $sql." AND `product_c_id`='".$cid."'";
			}

			if($sccid !='0'){
				$sql= $sql." AND `product_parent_sc`='".$sccid."' ";
			}
			
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			
			if($numgrp==0)
			{

				$scprodnam=$_POST['subcate_product_name'];
				$scprodnampor=$_POST['subcate_product_name_por'];
				$slidelaystyle=$_POST['subcate_slide_lay_style'];
				
				$sql="INSERT INTO `elgi_brand_product_subcate`(`product_sc_name`,`product_sc_name_por`,`product_c_id`, `slide_layout_id`,`product_parent_sc`,`next_step`,`product_sc_image`,`home_hover_left`,`home_hover_top`) VALUES ('".$scprodnam."','".$scprodnampor."','".$cid."','".$slidelaystyle."','".$sccid."','".$nxt."','".$image."','".$left."','".$top."')";
				$resgrp_insert= mysqli_query($conn,$sql);

				if($resgrp_insert){
					if(isset($_FILE['subcate_product_img'])) {
						$moveimg=uploadimgfile("subcate_product_img","ssc_cards_file");
					}else{
						$moveimg='1';
					}
					
					if($moveimg=="1"){
						$response['sts']="yes";
						$response['message']="Product Sub-Category";	
					}else{
						$response['sts']="No";
						$response['message']="Product Sub-Category Inserted.File Unsuccessfully";	
					}

					
				}else{

					$response['sts']="no";
					$response['q']=$sql;
					$response['message']="Server Error.Try Again.Error 2";
					
			
				}
				
			}else{

				$response['sts']="no";
				$response['message']="Already Exist.";

			}
		 break;
		case 'scc_cards':
			$sql="SELECT * FROM `ssc_card_details` WHERE `ssc_sec_subcate`='".$_POST['eb_ssc_card_sc_id']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `ssc_card_details`(`ssc_sec_subcate`,`ssc_card_img`,`ssc_card_name`) VALUES ('".$_POST['eb_ssc_card_sc_id']."','".$_FILES['eb_ssc_card_img']['name']."','".$_POST['eb_ssc_name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					


					$moveimg=uploadimgfile("eb_ssc_card_img","ssc_cards_file");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Card Add Successfully";
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}

			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 
		 break;
	
		case 'elgi_b_product':
	
			$sql="SELECT * FROM `elgi_brand_product` WHERE `eb_product_name`='".$_POST['eb_product_name']."' AND `product_sc_id`='".$_POST['eb_product_sc_id']."' AND delete_status='0'";
			$resgrp= mysqli_query($conn,$sql);
			$numgrp=$resgrp->num_rows;
			if($numgrp==0)
			{
				$sql="INSERT INTO `elgi_brand_product`(`eb_product_name`,`eb_product_descrb`,`product_sc_id`,`eb_product_specific`,`eb_p_intro_img`) VALUES ('".$_POST['eb_product_name']."','".$_POST['eb_product_descrb']."','".$_POST['eb_product_sc_id']."','".$_FILES['eb_product_specific']['name']."','".$_FILES['eb_product_intro_img']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					
					$moveimg=uploadpdffile("eb_product_specific","specification");

					$moveimg=uploadimgfile("eb_product_intro_img","product_media_file");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Pr".$sql;
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2".$resgrp -> error;
					$response['q']=$sql;
			
				}
				
			}else{
				$response['sts']="no";
				$response['message']="Already Exist.";
			}
		 break;


		case "elgi_b_product_images":
		
				$sql="INSERT INTO `elgi_b_p_media`(`eb_mf_product_id`,`eb_p_file_type`,`eb_p_file_loc`) VALUES ('".$_POST['product_id']."','".$_POST['product_media_file_type']."','".$_FILES['product_media_file']['name']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					$moveimg=uploadimgfile("product_media_file","product_media_file");
					
					if($moveimg=="1"){
						$response['sts']="yes";
						$response['message']="Product Images";
						$response['id']=mysqli_insert_id($conn);
					}else{
						$response['sts']="yes";
						$response['message']="Product Images Faild";
					
					}
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
					$response['id']="0";
			
				}
				
		
			break;

		
		case 'branch':

			$sql="INSERT INTO `elgi_branch`( `elgi_branchname`, `elgi_branchsub`, `elgi_branchadd`, `elgi_branchmob`, `elgi_branchmail`, `branch_iframe`, `branch_country`) VALUES ('".$_POST['branch_name']."','".$_POST['branch_subname']."','".$_POST['branch_address']."','".$_POST['branch_mob']."','".$_POST['branch_mail']."','".$_POST['branch_Iframe']."','".$_POST['branch_country']."')";
			$resgrp= mysqli_query($conn,$sql);
			
			if($resgrp){
				
				$response['sts']="yes";
				$response['message']='Branch';
					
			}else{

				$response['sts']="no";
				$response['message']="Server Error.Try Again.Error 2";

			}


			break;


		case 'related_product':

			// $sql="SELECT * FROM `other_product` WHERE `name_ot_pro`='".$_POST['ot_product_name']."' AND `elgi_product_id`='".$_POST['other_product_cate_id']."' AND delete_status='0'";
			// $resgrp= mysqli_query($conn,$sql);
			// $numgrp=$resgrp->num_rows;
			// if($numgrp==0)
			// {
				$sql="INSERT INTO `other_product`( `name_ot_pro`,  `image_ot_pro`, `descrb_ot_pro`, `availables_ot_pro`, `shelf_life_ot_pro`,`elgi_product_id`) 
				VALUES ('".$_POST['ot_product_name']."','".$_FILES['other_product_img']['name']."','".$_POST['ot_product_descrb']."','".$_POST['ot_availables']."','".$_POST['other_shelf_life']."','".$_POST['other_product_cate_id']."')";
				$resgrp= mysqli_query($conn,$sql);
				
				if($resgrp){
					

					$moveimg=uploadimgfile("other_product_img","other_product");
					
					if($moveimg=="1"){
						
						$response['sts']="yes";
						$response['message']="Pr".$sql;
						
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;

					}
					
				}else{

					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2";
					$response['q']=$sql;
			
				}
				
			// }else{
			// 	$response['sts']="no";
			// 	$response['message']="Already Exist.";
			// }
			break;

		case 'related_product_tool':
	
				$sql="SELECT * FROM `other_product_tools` WHERE `tool_name`='".$_POST['ot_product_tool_name']."' AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
				    
					$sql="INSERT INTO `other_product_tools`( `tool_name`, `tool_image` ,`special_status`,`tools_category`,`tools_type`,`tool_descrb`,`tyre_construct_opt`,`product_id_opt`,`order_by_opt`)
					VALUES ('".$_POST['ot_product_tool_name']."','".$_FILES['other_product_tool_img']['name']."','".$_POST['radio_spl']."','".$_POST['tool_category']."','".$_POST['tool_type']."','".$_POST['other_product_tool_descrb']."','".$_POST['tyretype']."','".$_POST['product_tool_type']."','".$_POST['product_tool_order']."')";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
						
						$moveimg=uploadimgfile("other_product_tool_img","other_product_tool");
						
						if($moveimg=="1"){
							$ts_last_id = mysqli_insert_id($conn);

									$sql2="DELETE FROM `other_product_pvtb` WHERE `rel_pro_pid` =".$ts_last_id;
									$resgrp_ty2=mysqli_query($conn,$sql2);

									foreach($_POST['other_wheel_id'] as $appid){
										
										$sql1="INSERT INTO `other_product_pvtb`(`rel_pro_wheel`,`rel_pro_pid`) VALUES ('".$appid."','".$ts_last_id."')";
										$resgrp_ty= mysqli_query($conn,$sql1);

									}
							
							$response['sts']="yes";
							$response['message']="Pr".$sql;
							
						}else{
	
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
	
						}
						
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			 break;

			 case 'related_product_tool_category':
					$rimname=trim($_POST['product_tool_category_name']," ");
					$protyp=trim($_POST['product_tool_type']," ");
					$pptyp=trim($_POST['parent_tool_category']," ");
					$tcontyp=$_POST['tool_category_tyretype'];
					
					$sql="SELECT * FROM `tools_category` WHERE `tool_c_name`='".$rimname."' AND delete_status=0";
					$resgrp= mysqli_query($conn,$sql);
					$numgrp=$resgrp->num_rows;
					if($numgrp==0)
					{
						
						$sql="INSERT INTO `tools_category`(`tool_c_name`,`tyre_construct_toolt`,`product_type`,`parent_tool_cate_id`,`display_order`) 
						VALUES ('".$rimname."','".$tcontyp."','".$protyp."','".$pptyp."','".$_POST['product_tool_category_display_order']."')";
						$resgrp= mysqli_query($conn,$sql);
						
						if($resgrp){
							
	
								$response['sts']="yes";
								$response['message']="Tools";
							
						}else{
		
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2";
							$response['q']=$sql;
					
						}
						
					}else{
						$response['sts']="no";
						$response['message']="Already Exist.";
					}
				 break;
	
		case 'rim':
			$rimname=trim($_POST['rim_name']," ");
				$sql="SELECT * FROM `rep_rim` WHERE `rim_name_en`='".$rimname."' AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
				    
					$sql="INSERT INTO `rep_rim`( `rim_name_en`) 
					VALUES ('".$rimname."')";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
						

							$response['sts']="yes";
							$response['message']="Rim";
						
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			 break;

			 case 'section_width':
				$sec_w_name=trim($_POST['sec_w_name']," ");
				$sql="SELECT * FROM `rep_section_width` WHERE `rep_sec_width_name_en`='".$sec_w_name."' AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
				    
					$sql="INSERT INTO `rep_section_width`(`rep_sec_width_name_en`) 
					VALUES ('".$sec_w_name."')";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
							
							$response['sts']="yes";
							$response['message']="Section Width";
							
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			 break;


			 
			 case 'aspect_ratio':
				$asp_ratio_name=trim($_POST['asp_ratio_name']," ");
				$sql="SELECT * FROM `rep_aspect_ratio` WHERE `aspect_ratio_name_en`='".$asp_ratio_name."' AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
				    
					$sql="INSERT INTO `rep_aspect_ratio`(`aspect_ratio_name_en`) 
					VALUES ('".$asp_ratio_name."')";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
							
							$response['sts']="yes";
							$response['message']="Section Width";
							
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			 break;
			case 'spl_spec_list':

				    
					$sql="INSERT INTO `spl_spec_product`(`product_id`, `spl_spec_pro_ww_mm`, `spl_spec_pro_nsd_mm`, `spl_spec_pro_leng_mm`, `spl_spec_pro_avg_wt`) 
					VALUES (".$_POST['product_id'].",".$_POST['widthmm_name'].",".$_POST['nsdmm_name'].",".$_POST['lengthmm_name'].",".$_POST['avgwt_name'].")";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
							
							$response['sts']="yes";
							$response['message']="Section Width";
							
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
				
					}
			
			 break;


			 case 'tyre_pp_construct':
	
				$sql="SELECT * FROM `tyre_pp_construct` WHERE tppc_name_en='".$_POST['tppc_name']."' AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
					$sql="INSERT INTO `tyre_pp_construct`( `tppc_name_en`,`tppc_name_por`,`tppc_img`) VALUES ('".$_POST['tppc_name']."','".$_POST['tppc_name_por']."','".$_FILES['tppc_img']['name']."')";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
						
						$moveimg=uploadimgfile("tppc_img","tyre_preparation_type");
						
						if($moveimg=="1"){
							
							$response['sts']="yes";
							$response['message']="Tyre Preparetion Construction";
							
						}else{
	
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
	
						}
						
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			 break;


			 case 'tyre_pp_repair_typ':
	
				$sql="SELECT * FROM `tyre_pp_repair_typ` WHERE repair_typ_name='".$_POST['repair_typ_name']."' AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
					$sql="INSERT INTO `tyre_pp_repair_typ`( `repair_typ_name`,`repair_typ_name_por`,`repair_typ_img`) VALUES ('".$_POST['repair_typ_name']."','".$_POST['repair_typ_name_por']."','".$_FILES['repair_typ_img']['name']."')";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
						
						$moveimg=uploadimgfile("repair_typ_img","tyre_pp_repair_typ");
						
						if($moveimg=="1"){
							
							$response['sts']="yes";
							$response['message']="Repair Type";
							
						}else{
	
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
	
						}
						
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			 break;

			 case 'tools_category':
	
				$sql="SELECT * FROM `tools_type` WHERE tools_typ_name='".$_POST['product_tool_category_name']."' AND delete_status='0'";
				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
					$sql="INSERT INTO `tools_type`( `tools_typ_name`,`tools_typ_name_por`,`display_order`) VALUES ('".$_POST['product_tool_category_name']."','".$_POST['product_tool_category_name_por']."','".$_POST['product_tool_category_display_order']."')";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
						
						
							
							$response['sts']="yes";
							$response['message']="Tool Type";
							
						
						
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			 break;

			 case 'selguide_tyre_pp':

				if(isset($_POST['tyre_pp_construct'])&&($_POST['tyre_pp_construct']!="")){
					$tyre_pp_construct=$_POST['tyre_pp_construct'];
				}else{
					$tyre_pp_construct="null";
				}

				if(isset($_POST['tyre_pp_repair_typ'])&&($_POST['tyre_pp_repair_typ']!="")){
					$tyre_pp_repair_typ=$_POST['tyre_pp_repair_typ'];
				}else{
					$tyre_pp_repair_typ="null";
				}

				if(isset($_POST['tyre_pp_tool'])&&($_POST['tyre_pp_tool']!="")){
					$tyre_pp_tool=$_POST['tyre_pp_tool'];
				}else{
					$tyre_pp_tool="null";
				}
				
				
				


				$sql="SELECT * FROM `tyre_pp_selection_guide` WHERE delete_status='0' AND `tppc_id`=".$tyre_pp_construct." AND `repair_typ_id`=".$tyre_pp_repair_typ."  AND `tool_id`=".$tyre_pp_tool;


				$resgrp= mysqli_query($conn,$sql);
				$numgrp=$resgrp->num_rows;
				if($numgrp==0)
				{
 
					 

					$sql="INSERT INTO `tyre_pp_selection_guide`(`tppc_id`, `repair_typ_id`, `tool_id`) VALUES (".$tyre_pp_construct.",".$tyre_pp_repair_typ.",".$tyre_pp_tool.")";
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
							
									$ts_last_id = mysqli_insert_id($conn);

									$response['sts']="yes";
									$response['message']="Selection Guide";
							
							
					}else{

						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
						$response['error']="ERROR:".mysqli_error($conn);
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}

			break;


		
		default:
		 break;
	}

}else if($_REQUEST['type']=="up"){

	switch($_REQUEST['action']){

		case 'lang_settings':
			if(isset($_POST["lang_id"])&&($_POST["lang_id"]!="")){
				//  `reptyreypename_por`, `reptyreypeImg`, `selection_chart`, `status`, `delete_status` FROM `rep_tyretype` WHERE 1

				$sql="UPDATE `lang_words` SET `lang_word_key`='".$_POST['lang_key']."', `lang_word_en`='".$_POST['lang_en']."', `lang_word_pt`='".$_POST['lang_pt']."'";
			
				
				$sql=$sql." WHERE lang_word_id=".$_POST["lang_id"];
				
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					
						$response['sts']="yes";
						$response['message']="KEY WORD";
						
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
					
					
				}
			}else{
				$response['sts']="no";
				$response['message']="Need KeyWord Id Contact Developer.Error 3:code";
				
			
			}
			break;
		
		case 'member_admin':
			if(isset($_POST["admin_id"])&&($_POST["admin_id"]!="")){
				//  `reptyreypename_por`, `reptyreypeImg`, `selection_chart`, `status`, `delete_status` FROM `rep_tyretype` WHERE 1

				$sql="UPDATE `elgi_admin_users` SET `elgiAdminusersName`='".$_POST['admin_name']."', `elgiAdminusersPassword`='".$_POST['admin_password']."', `elgiAdminuserstype`='".$_POST['admin_user_type']."'";
			
				
				$sql=$sql." WHERE elgiAdminusersId=".$_POST["admin_id"];
				
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					
						$response['sts']="yes";
						$response['message']="Result Alert";
						
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
					
					
				}
			}else{
				$response['sts']="no";
				$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
				
			
			}
			break;


		case 'resultalert':
			if(isset($_POST["alert_msg_id"])&&($_POST["alert_msg_id"]!="")){
				//  `reptyreypename_por`, `reptyreypeImg`, `selection_chart`, `status`, `delete_status` FROM `rep_tyretype` WHERE 1

				$sql="UPDATE `resultdecrp_pop` SET `resultdecrpname`='".$_POST['alert_msg_name']."', `resultdecrpname_por`='".$_POST['alert_msg_name_por']."'";
			
				
				$sql=$sql." WHERE resultdecrp=".$_POST["alert_msg_id"];
				
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					
						$response['sts']="yes";
						$response['message']="Result Alert";
						
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
					
					
				}
			}else{
				$response['sts']="no";
				$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
				
			
			}
			break;



			case 'elgi_brand':
		
	
			if(isset($_POST["sub_brnads_id"])&&($_POST["sub_brnads_id"]!="")){
			
					$sql="UPDATE `elgi_brands_det` SET `brand_name`='".$_POST['sub_brands_name']."',`elgi_brands_fdecrb`='".$_POST['sub_brands_sdescrb']."'";
					
					
					if(isset($_FILES['sub_brands_logoimg']['name'])&&($_FILES['sub_brands_logoimg']['name']!="")){
						$sql=$sql.", `brand_logos`='".$_FILES['sub_brands_logoimg']['name']."'";
					}
					if(isset($_FILES['sub_brands_favimg']['name'])&&($_FILES['sub_brands_favimg']['name']!="")){
						$sql=$sql.",`brand_fav_logo`='".$_FILES['sub_brands_favimg']['name']."'";
					}
					
					$sql=$sql." WHERE brand_Id=".$_POST["sub_brnads_id"];
					
					$resgrp= mysqli_query($conn,$sql);
					if($resgrp){
							
						if(isset($_FILES['sub_brands_logoimg']['name'])&&($_FILES['sub_brands_logoimg']['name']!="")){
							$moveimg=uploadimgfile("sub_brands_logoimg","sub_brands");;
						}else{
							$moveimg="1";
						}
						if(isset($_FILES['sub_brands_favimg']['name'])&&($_FILES['sub_brands_favimg']['name']!="")){
							
							$movecat=uploadimgfile("sub_brands_favimg","sub_brands_favimg");;
						
						}else{
							$movecat="1";
						}
						
						if(($moveimg=="1")&&($movecat=="1")){
							
							$response['sts']="yes";
							$response['message']="Elgi Brand";
							
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
						}

					}else{
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2:code";
						
					}
				}else{
					$response['sts']="no";
					$response['message']="Need Brand Id Contact Developer.Error 3:code";
				
				}
				break;
			case "elgi_brand_menu":
				if(isset($_POST["b_menuid"])&&($_POST["b_menuid"]!="")){
				

					$sql="UPDATE `elgi_brand_det_intro` SET `brand_id`='".$_POST['bid']."' AND `brand_intro_lable`='".$_POST['mname']."' AND `brand_intro_link`='".$_POST['mlink']."'";
					$sql=$sql." WHERE elgi_brand_intro_id=".$_POST["b_menuid"];
					$resgrp= mysqli_query($conn,$sql);
					
					if($resgrp){
						
						$response['sts']="yes";
						$response['message']="Brand Menu";
					
					}else{
	
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2";
						$response['q']=$sql;
				
					}
					
				}else{
					$response['sts']="no";
					$response['message']="Already Exist.";
				}
			break;


			case 'product_category':
				
					if(isset($_POST["cate_product_id"])&&($_POST["cate_product_id"]!="")){
					
							$sql="UPDATE `elgi_brand_product_cate` SET `product_c_name`='".$_POST['cate_product_name']."' , `product_c_name_por`='".$_POST['cate_product_name_por']."' , `hover_popup_status`='".$_POST['radio_hover']."',`product_c_discrp`='".$_POST['cate_product_descrb']."',`slide_layout_id_c`='".$_POST['cate_product_slide_lay_style']."'";
							
			
							if(isset($_FILES['cate_product_img']['name'])&&($_FILES['cate_product_img']['name']!="")){
								$sql=$sql.", `product_c_image`='".$_FILES['cate_product_img']['name']."'";
							}
							
							$sql=$sql." WHERE product_c_id=".$_POST["cate_product_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['cate_product_img']['name'])&&($_FILES['cate_product_img']['name']!="")){
									$moveimg=uploadimgfile("cate_product_img","product_category");;
								}else{
									$moveimg="1";
								}
							
								
								if($moveimg=="1"){
									
									$response['sts']="yes";
									$response['message']="Product Category ";
									
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
								}
		
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Producr Id Contact Developer.Error 3:code";
						
						}
						break;
		case 'product_subcategory':


							if(isset($_POST["subcate_product_id"])&&($_POST["subcate_product_id"]!=""))
							{
						
									if(!isset($_POST['subcate_product_c_id'])){

										$sql = "SELECT * FROM `elgi_brand_product_subcate` WHERE `product_sc_id`='".$_POST['subcate_product_scc_id']."'  AND delete_status='0'";	
										$resgrp = mysqli_query($conn, $sql);
										$numcount = mysqli_num_rows($resgrp);
										if($numcount>0)
										{
											while($query=mysqli_fetch_assoc($resgrp))
											{
												$cid = $query["product_c_id"];
											}
										
										}

									}else{

										$cid= $_POST['subcate_product_c_id'];

									}
															
									$sccid = (isset($_POST['subcate_product_scc_id'])) ? $_POST['subcate_product_scc_id'] : '0';
									$nxt = (isset($_POST['subcate_product_nxt'])) ? '1' : '0';
										$left=(isset($_POST['subcate_product_hover_left'])) ? $_POST['subcate_product_hover_left'] : '';
			                            $top=(isset($_POST['subcate_product_hover_top'])) ? $_POST['subcate_product_hover_top'] : '';

									$sql="UPDATE `elgi_brand_product_subcate` SET `product_sc_name`='".$_POST['subcate_product_name']."' , `product_sc_name_por`='".$_POST['subcate_product_name_por']."', `product_c_id`='".$cid."', `slide_layout_id`='".$_POST['subcate_slide_lay_style']."', `product_parent_sc`='.$sccid.',`next_step`='".$nxt."',`home_hover_left`='".$left."',`home_hover_top`='".$top."' ";
									if(isset($_FILES['subcate_product_img']['name'])&&($_FILES['subcate_product_img']['name']!="")){
											$sql=$sql.", `product_sc_image`='".$_FILES['subcate_product_img']['name']."'";
										}
									$sql=$sql." WHERE product_sc_id=".$_POST["subcate_product_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
									    
									    	if(isset($_FILES['subcate_product_img']['name'])&&($_FILES['subcate_product_img']['name']!="")){
												$moveimg=uploadimgfile("subcate_product_img","product_sub_category");
											}else{
												$moveimg="1";
											}
											
											if($moveimg=="1"){
												
												$response['sts']="yes";
											    $response['message']="Product Sub-Category ";
												
											}else{
						
												$response['sts']="no";
												$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
						
											}

											
											
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
										
									}
								}else{

									$response['sts']="no";
									$response['message']="Need Product Sub-Category Id Contact Developer.Error 3:code";
								
								}
								break;

								case 'scc_cards':
								
									if(isset($_POST["eb_ssc_card_id"])&&($_POST["eb_ssc_card_id"]!=""))
									{
						
										$sql="UPDATE `ssc_card_details` SET `ssc_sec_subcate`='".$_POST['eb_ssc_card_sc_id']."', `ssc_card_name`='".$_POST['eb_ssc_name']."'";
										
										if(isset($_FILES['eb_ssc_card_img']['name'])&&($_FILES['eb_ssc_card_img']['name']!="")){
											$sql=$sql.", `ssc_card_img`='".$_FILES['eb_ssc_card_img']['name']."'";
										}

										$sql=$sql." WHERE ssc_card_id=".$_POST["eb_ssc_card_id"];
										
										$resgrp= mysqli_query($conn,$sql);
										
										if($resgrp){
											
						
						
											if(isset($_FILES['eb_ssc_card_img']['name'])&&($_FILES['eb_ssc_card_img']['name']!="")){
												$moveimg=uploadimgfile("eb_ssc_card_img","ssc_cards_file");
											}else{
												$moveimg="1";
											}
											
											if($moveimg=="1"){
												
												$response['sts']="yes";
												$response['message']="Card Updated Successfully";
												
											}else{
						
												$response['sts']="no";
												$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
						
											}
											
										}else{
						
											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 2";
											$response['q']=$sql;
									
										}
						
									}else{
										$response['sts']="no";
										$response['message']="Need Product Sub-Category Id Contact Developer.Error 3:code";
									}
								 
								 break;
		case 'product_subcategory_slide':
								if(isset($_POST["subcate_product_id"])&&($_POST["subcate_product_id"]!="")){



									$one_subc_title= (!isset($_POST['subcate_title_one'])) ? "" : $_POST['subcate_title_one'];
									$one_sub_scc=(!isset($_POST['subcate_scc_one'])) ? "" : $_POST['subcate_scc_one'];
									
									$two_subc_title=(!isset($_POST['subcate_title_two'])) ? "" : $_POST['subcate_title_two'];
									$two_sub_scc=(!isset($_POST['subcate_scc_two'])) ? "" : $_POST['subcate_scc_two'];
									
									$three_subc_title=(!isset($_POST['subcate_title_three'])) ? "" : $_POST['subcate_title_three'];
									$three_sub_scc=(!isset($_POST['subcate_scc_three'])) ? "" : $_POST['subcate_scc_three'];
									
									$four_subc_title=(!isset($_POST['subcate_title_four'])) ? "" : $_POST['subcate_title_four'];
									$four_sub_scc=(!isset($_POST['subcate_scc_four'])) ? "" : $_POST['subcate_scc_four'];

									$about_descr=(!isset($_POST['subcate_card_descr'])) ? "" : $_POST['subcate_card_descr'];
									$about=(!isset($_POST['subcate_card_title'])) ? "" : $_POST['subcate_card_title'];

									$sql="UPDATE `elgi_brand_product_subcate` SET `product_sc_title_one`='".$one_subc_title."',`p_parent_sc_one`='".$one_sub_scc."',`product_sc_title_two`='".$two_subc_title."',`p_parent_sc_two`='".$two_sub_scc."',`product_sc_title_three`='".$three_subc_title."',`p_parent_sc_three`='".$three_sub_scc."',`product_sc_title_four`='".$four_subc_title."',`p_parent_sc_four`='".$four_sub_scc."',`product_sub_about`='".$about_descr."',`product_sub_ptitle`='".$about."'";

									$sql=$sql." WHERE product_sc_id=".$_POST["subcate_product_id"];
									
									$resgrp= mysqli_query($conn,$sql);

									if($resgrp){

											$response['sts']="yes";
											$response['message']="Product Sub-Category Slide ";
											
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
										
									}
									
								}else{
									$response['sts']="no";
									$response['message']="Need Product Sub-Category Id Contact Developer.Error 3:code";
								}

								break;
					

		case 'elgi_b_product':
	
						if(isset($_POST["eb_product_id"])&&($_POST["eb_product_id"]!="")){
	
							$sql="UPDATE `elgi_brand_product` SET `eb_product_name`='".$_POST['eb_product_name']."' , `eb_product_descrb`='".$_POST['eb_product_descrb']."' , `product_sc_id`='".$_POST['eb_product_sc_id']."'";
							
			
							if(isset($_FILES['eb_product_specific']['name'])&&($_FILES['eb_product_specific']['name']!="")){
								$sql=$sql.", `eb_product_specific`='".$_FILES['eb_product_specific']['name']."'";
							}

							
							if(isset($_FILES['eb_product_intro_img']['name'])&&($_FILES['eb_product_intro_img']['name']!="")){
								$sql=$sql.", `eb_p_intro_img`='".$_FILES['eb_product_intro_img']['name']."'";
							}


							
							$sql=$sql." WHERE eb_product_id=".$_POST["eb_product_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['eb_product_specific']['name'])&&($_FILES['eb_product_specific']['name']!="")){
									$moveimg=uploadpdffile("eb_product_specific","specification");
								}else{
									$moveimg="1";
								}

								if(isset($_FILES['eb_product_intro_img']['name'])&&($_FILES['eb_product_intro_img']['name']!="")){
									$moveimg=uploadimgfile("eb_product_intro_img","product_media_file");
								}else{
									$moveimg="1";
								}
							
								
								if($moveimg=="1"){
									
									$response['sts']="yes";
									$response['message']="Product ";
									
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
								}
		
							}else{
								$response['sts']="no";
								$response['query']=$sql;
								$response['message']="Server Error.Try Again.Error 2:code".$resgrp -> error;
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need  Id Contact Developer.Error 3:code";
						
						}
						
					break;
	
			
		case 'productcat':
				if(isset($_POST["product_id"])&&($_POST["product_id"]!="")){
					$sql="UPDATE `elgi_products` SET `elgiProductsName`='".$_POST['product_name']."', `name_portugues`='".$_POST['product_name_port']."'";
					
					
					if(isset($_FILES['product_img']['name'])&&($_FILES['product_img']['name']!="")){
						$sql=$sql.", `elgiProductsImg`='".$_FILES['product_img']['name']."'";
					}
					if(isset($_FILES['product_catlog']['name'])&&($_FILES['product_catlog']['name']!="")){
						$sql=$sql.",`catlog_pdf`='".$_FILES['product_catlog']['name']."'";
					}
					
					$sql=$sql." WHERE elgiProductsId=".$_POST["product_id"];
					
					$resgrp= mysqli_query($conn,$sql);
					if($resgrp){
							
						if(isset($_FILES['product_img']['name'])&&($_FILES['product_img']['name']!="")){
							$moveimg=uploadimgfile("product_img","Product");
						}else{
							$moveimg="1";
						}
						if(isset($_FILES['product_catlog']['name'])&&($_FILES['product_catlog']['name']!="")){
							
							$movecat=uploadpdffile("product_catlog","catlog");
						
						}else{
							$movecat="1";
						}
						
						if(($moveimg=="1")&&($movecat=="1")){
							
							$response['sts']="yes";
							$response['message']="Product";
							
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
						}

					}else{
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2:code";
						
					}
				}else{
					$response['sts']="no";
					$response['message']="Need Product Id Contact Developer.Error 3:code";
				
				}
				break;
		case 'product_group':
					if(isset($_POST["group_id"])&&($_POST["group_id"]!="")){
						
						$sql="UPDATE `elgi_products` SET `elgiProductsName`='".$_POST['group_name']."', `elgiProducts_por`='".$_POST['group_name_port']."'";
						
						
						if(isset($_FILES['group_img']['name'])&&($_FILES['group_img']['name']!="")){
							$sql=$sql.", `elgiProductsImg`='".$_FILES['group_img']['name']."'";
						}
						if(isset($_FILES['group_catlog']['name'])&&($_FILES['group_catlog']['name']!="")){
							$sql=$sql.",`catlog_pdf`='".$_FILES['group_catlog']['name']."'";
						}
						
						$sql=$sql." WHERE elgiProductsId=".$_POST["group_id"];
						
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
								
							if(isset($_FILES['group_img']['name'])&&($_FILES['group_img']['name']!="")){
								$moveimg=uploadimgfile("group_img","Product");
							}else{
								$moveimg="1";
							}
							if(isset($_FILES['group_catlog']['name'])&&($_FILES['group_catlog']['name']!="")){
								
								$movecat=uploadpdffile("group_catlog","catlog");
							
							}else{
								$movecat="1";
							}
							
							if(($moveimg=="1")&&($movecat=="1")){
								
								$response['sts']="yes";
								$response['message']="Tyre Type";
								
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
							}
	
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
							
							
						}
					}else{
						$response['sts']="no";
						$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
					
					}
					break;
				
				
		case 'tyretype':
					if(isset($_POST["tyretype_id"])&&($_POST["tyretype_id"]!="")){
							$sql="UPDATE `rep_tyretype` SET `reptyreypename`='".$_POST['tyretype_name']."', `reptyreypename_por`='".$_POST['tyretype_name_por']."'";
						
						
						if(isset($_FILES['tyretype_img']['name'])&&($_FILES['tyretype_img']['name']!="")){
							$sql=$sql.", `reptyreypeImg`='".$_FILES['tyretype_img']['name']."'";
						}
						if(isset($_FILES['tyretype_selchart']['name'])&&($_FILES['tyretype_selchart']['name']!="")){
							$sql=$sql.",`selection_chart`='".$_FILES['tyretype_selchart']['name']."'";
						}
						
						$sql=$sql." WHERE reptyreypeid=".$_POST["tyretype_id"];
						
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
								
							if(isset($_FILES['tyretype_img']['name'])&&($_FILES['tyretype_img']['name']!="")){
								$moveimg=uploadimgfile("tyretype_img","Tubetype");
							}else{
								$moveimg="1";
							}
							if(isset($_FILES['tyretype_selchart']['name'])&&($_FILES['tyretype_selchart']['name']!="")){
								
								$movecat=uploadpdffile("tyretype_selchart","select_chart");
							
							}else{
								$movecat="1";
							}
							
							if(($moveimg=="1")&&($movecat=="1")){
								
								$response['sts']="yes";
								$response['message']="Tyre Type";
								
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
							}
	
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
							
							
						}
					}else{
						$response['sts']="no";
						$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
					
					}
					break;  
		case 'vehicle':
						if(isset($_POST["vehicle_id"])&&($_POST["vehicle_id"]!="")){
						
							$sql="	UPDATE `rep_application` SET `repappname`='".$_POST['vehicle_name']."',`repappname_por`='".$_POST['vehicle_name_port']."'";
							if(isset($_FILES['vehicle_img']['name'])&&($_FILES['vehicle_img']['name']!="")){
								$sql=$sql.", `repappvehicleImg`='".$_FILES['vehicle_img']['name']."'";
							}
							if(isset($_FILES['vehicle_restr_img']['name'])&&($_FILES['vehicle_restr_img']['name']!="")){
								$sql=$sql.",`reprstruimg`='".$_FILES['vehicle_restr_img']['name']."'";
							}
							if(isset($_FILES['vehicle_reptab_img']['name'])&&($_FILES['vehicle_reptab_img']['name']!="")){
								$sql=$sql.",`reptable`='".$_FILES['vehicle_reptab_img']['name']."'";
							}

							if(isset($_FILES['vehicle_ins_default_img']['name'])&&($_FILES['vehicle_ins_default_img']['name']!="")){
								$ins_default=$_FILES['vehicle_ins_default_img']['name'];
								$sql=$sql.",`repinsruct_tsize_default`='".$_FILES['vehicle_ins_default_img']['name']."'";
							}else{
								$ins_default="";
							}
							if(isset($_FILES['vehicle_ins_tubeless_img']['name'])&&($_FILES['vehicle_ins_tubeless_img']['name']!="")){
								$ins_tubeless_ts=$_FILES['vehicle_ins_tubeless_img']['name'];
								$sql=$sql.",`repinsruct_tsize_tubeless`='".$_FILES['vehicle_ins_tubeless_img']['name']."'";
							}else{
								$ins_tubeless_ts="";
							}

							// if(isset($_FILES['vehicle_ins_default_img']['name'])&&($_FILES['vehicle_ins_default_img']['name']!=""])){
							// 	$ins_default="";
							// }else{
							// 	$ins_default=$_FILES["vehicle_ins_default_img"]["name"];
							// 	$sql=$sql.",`repinsruct_tsize_default`='".$ins_default."'";
							// }
			
							// if(empty($_FILES["vehicle_ins_tubeless_img"]["name"])){
							// 	$ins_tubeless_ts="";   
							// }else{
							// 	$ins_tubeless_ts=$_FILES["vehicle_ins_tubeless_img"]["name"];
							// 	$sql=$sql.",`repinsruct_tsize_tubeless`='".$ins_tubeless_ts."'";
							// }
						

							
							$sql=$sql.",`appsteps`='".$_POST['stepinfo']."',`tyretype`='".$_POST['tyretype']."' WHERE repappid=".$_POST["vehicle_id"];
	
								
						// $moveimg=uploadimgfile("vehicle_img","Application");
						// $movererestrimg=uploadimgfile("vehicle_restr_img","restr");
						// $moverestableimg=uploadimgfile("vehicle_reptab_img","restable");
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['vehicle_img']['name'])&&($_FILES['vehicle_img']['name']!="")){
									$moveimg=uploadimgfile("vehicle_img","Application");
								}else{
									$moveimg="1";
								}
								if(isset($_FILES['vehicle_restr_img']['name'])&&($_FILES['vehicle_restr_img']['name']!="")){
									
									$movererestrimg=uploadimgfile("vehicle_restr_img","restr");
								
								}else{
									$movererestrimg="1";
								}

								
								
								
								if(isset($_FILES['vehicle_reptab_img']['name'])&&($_FILES['vehicle_reptab_img']['name']!="")){
									
									$moverestableimg=uploadimgfile("vehicle_reptab_img","restable");
								
								}else{
									$moverestableimg="1";
								}

								if($ins_default!=""){
									$moveins1=uploadimgfile("vehicle_ins_default_img","Application_instruction");
								}else{
									$moveins1="1" ;
								}
								if($ins_tubeless_ts!=""){
									$moveins2=uploadimgfile("vehicle_ins_tubeless_img","Application_instruction");
								}else{
									$moveins2="1" ;
								}
								
								if(($moveimg=="1")&&($movererestrimg=="1")&&($moverestableimg=="1")&&($moveins1=="1")&&($moveins2=="1")){
									
									$response['sts']="yes";
									$response['message']="vehicle Type  " ;
									
								}else{
	
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movererestrimg." to ".$moverestableimg;
								
								}
		
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Aga.Error 2:code";
							 
								
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
						
						}
					break;
		case 'tubetype':
						if(isset($_POST["tubetype_id"])&&($_POST["tubetype_id"]!="")){
					
							$sql="UPDATE `rep_tube_type` SET `reptubetypename`='".$_POST['tubetype_name']."', `reptubetypename_por`='".$_POST['tubetype_name_por']."'";
							
							
							if(isset($_FILES['tubetype_img']['name'])&&($_FILES['tubetype_img']['name']!="")){
								$sql=$sql.", `reptubetypeImg`='".$_FILES['tubetype_img']['name']."'";
							}
							
							$sql=$sql." WHERE reptubetypeid=".$_POST["tubetype_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['tubetype_img']['name'])&&($_FILES['tubetype_img']['name']!="")){
									$moveimg=uploadimgfile("tubetype_img","Tubetype");
								}else{
									$moveimg="1";
								}

								
								if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="Tube Type";
									
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
								}
		
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code".mysql_error($conn);
								
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
						
						}
						break;

		case 'tyresize':
						if(isset($_POST["tyresize_id"])&&($_POST["tyresize_id"]!="")){
						
	
							
							$sql="UPDATE `rep_tyresize` SET `reptyresizenam`='".$_POST['tyresize_name']."',`product_type`='".$_POST['tyresize_typpro']."', `reptyresizenam_por`='".$_POST['tyresize_name_por']."',`ply_rating_id`='".$_POST['tyresize_prlr']."',`load_range_id`='".$_POST['tyresize_lr']."' ,`tyre_decssts`='".$_POST['tyresize_alert']."',`rim_id`='".$_POST['tyresize_rim']."',`asp_ratio_id`='".$_POST['tyresize_asp']."',`sec_width_id`='".$_POST['tyresize_sec']."'";
						
							$sql=$sql." WHERE reptyresizeid=".$_POST["tyresize_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
								
									$ts_last_id = $_POST["tyresize_id"];

									
									$response['sts']="yes";
									$response['message']="Tyre Size";
									
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
						
						}
						break;
		case 'injuryarea':
						if(isset($_POST["injuryarea_id"])&&($_POST["injuryarea_id"]!="")){
					
							$sql="UPDATE `rep_injuarea` SET `repinjuareanam`='".$_POST['injuryarea_name']."', `repinjuareanam_por`='".$_POST['injuryarea_name_por']."'";
							
							if(isset($_FILES['injuryarea_img']['name'])&&($_FILES['injuryarea_img']['name']!="")){
								$sql=$sql.", `repinjuareaImg`='".$_FILES['injuryarea_img']['name']."'";
							}
							
							$sql=$sql." WHERE repinjuareaid=".$_POST["injuryarea_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['injuryarea_img']['name'])&&($_FILES['injuryarea_img']['name']!="")){
									$moveimg=uploadimgfile("injuryarea_img","Injuryarea");
								}else{
									$moveimg="1";
								}
								
								if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="Injury Area";
									
								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
								
								}
		
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								
							}
						}else{

							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
						
						}
						break;
		case 'injurytype':
						if(isset($_POST["injurytype_id"])&&($_POST["injurytype_id"]!="")){
						
	
							$sql="UPDATE `rep_injutype` SET `repinjutypename`='".$_POST['injurytype_name']."', `repinjutypename_por`='".$_POST['injurytype_name_por']."'";
						
							
							$sql=$sql." WHERE repinjutypeid=".$_POST["injurytype_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
								
									$response['sts']="yes";
									$response['message']="Injury Type";
									
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Injury Type Id Contact Developer.Error 3:code";
							
						
						}
						break;
		case 'prlr':
						if(isset($_POST["prlr_id"])&&($_POST["prlr_id"]!="")){
						
	
							$sql="UPDATE `rep_ply_rating_load` SET `repplyratloadname`='".$_POST['prlr_name']."', `repplyratloadname_por`='".$_POST['prlr_name_por']."'";
						
							
							$sql=$sql." WHERE repplyratloadid=".$_POST["prlr_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
								
									$response['sts']="yes";
									$response['message']="Ply Rating";
									
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Ply Rating Id Contact Developer.Error 3:code";
							
						
						}
						break;
						case 'load_range':
							if(isset($_POST["load_range_id"])&&($_POST["load_range_id"]!="")){
							
		
								$sql="UPDATE `rep_load_range` SET `rep_lr_str`='".$_POST['load_range_name']."', `rep_lr_str_por`='".$_POST['load_range_name_por']."'";
							
								
								$sql=$sql." WHERE rep_lr_id=".$_POST["load_range_id"];
								
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
									
										$response['sts']="yes";
										$response['message']="Load Range";
										
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
									
									
								}
							}else{
								$response['sts']="no";
								$response['message']="Need Load Range Id Contact Developer.Error 3:code";
								
							
							}
							break;
		case 'injurysize':
							if(isset($_POST["injurysize_id"])&&($_POST["injurysize_id"]!="")){

								$injurysize_name="";
								$injurysize_height="";
								$injurysize_width="";
								if($_POST['injurysizetyp']=="0"){
									$injurysize_name=$_POST['injurysize_name'];
								}else{
									$injurysize_height=$_POST['injurysize_height'];
									$injurysize_width=$_POST['injurysize_width'];
								}
							
		
								$sql="UPDATE `rep_injusize` SET `repinjusizename`='".$injurysize_name."', `repinjusizeheight`='".$injurysize_height."', `repinjusizewidth`='".$injurysize_width."',`repinjusizetyp`='".$_POST['injurysizetyp']."'";
							
								
								$sql=$sql." WHERE repinjusizeid=".$_POST["injurysize_id"];
								
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
									
										$response['sts']="yes";
										$response['message']="Injury Size";
										
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
									
									
								}
							}else{
								$response['sts']="no";
								$response['message']="Need Injury Size Id Contact Developer.Error 3:code";
								
							
							}
						break;

		case 'repairunits': 
							if(isset($_POST["repair_units_id"])&&($_POST["repair_units_id"]!="")){
							    
							
				

				    
				

								$sql="UPDATE `rep_unit` SET `repUnitName`='".$_POST['repair_units_name']."', `repUnitSizemm`='".$_POST['repair_units_sizemm']."', `repUnitSizeInches`='".$_POST['repair_units_sizeinch']."',`repUnitPlyrating`='".$_POST['repair_units_plyrating']."',`repscseries`='".$_POST['repair_units_scseries']."',`repcbseries`='".$_POST['repair_units_cbseries']."',`rephcseries`='".$_POST['repair_units_hcseries']."',`rep_unit_alert`='".$_POST['repair_units_alert']."',`repUnittype`='".$_POST['repair_units_type']."',`repUnitone`='".$_POST['repair_units_name_one']."',`repUnittwo`='".$_POST['repair_units_name_two']."',`repdecrption`='".$_POST['repair_units_descrb']."',`repImageUrl`='".$_FILES['repair_units_img']['name']."'";
								
								$sql=$sql." WHERE repUnitid =".$_POST["repair_units_id"];
								
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
								    
								    if(isset($_FILES['repair_units_img']['name'])&&($_FILES['repair_units_img']['name']!="")){
    									$moveimg=uploadimgfile("repair_units_img","Bladeapp");
    								}else{
    									$moveimg="1";
    								}
								
								
    								if(($moveimg=="1")){
    									
    									$response['sts']="yes";
    									$response['message']="Repair Units";
    									
    								}else{
    									$response['sts']="no";
    									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
								    }
									
										
								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
										
								}
							}else{

								$response['sts']="no";
								$response['message']="Need Repair Units Id Contact Developer.Error 3:code";
								
							
							}
						break;

		case 'tyrerepairsel':

							if(isset($_POST["tyrerepairsel_id"])&&($_POST["tyrerepairsel_id"]!="")){

								if(isset($_POST['tyrerepairsel_vechile'])&&($_POST['tyrerepairsel_vechile']!="")){
									$tyrepvechile=$_POST['tyrerepairsel_vechile'];
								}else{
									$tyrepvechile="null";
								}
								if(isset($_POST['tyrerepairsel_tubetype'])&&($_POST['tyrerepairsel_tubetype']!="")){
									$tyreptubetype=$_POST['tyrerepairsel_tubetype'];
								}else{
									$tyreptubetype="null";
								}
					
								if(isset($_POST['tyrerepairsel_tyresize'])&&($_POST['tyrerepairsel_tyresize']!="")){
									$tyreptyresize=$_POST['tyrerepairsel_tyresize'];
								}else{
									$tyreptyresize="null";
								}
					
								if(isset($_POST['tyrerepairsel_injurytype'])&&($_POST['tyrerepairsel_injurytype']!="")){
									$tyrepinjurytype=$_POST['tyrerepairsel_injurytype'];
								}else{
									$tyrepinjurytype="null";
								}
					
								if(isset($_POST['tyrerepairsel_injurysize'])&&($_POST['tyrerepairsel_injurysize']!="")){
									$tyrepinjurysize=$_POST['tyrerepairsel_injurysize'];
								}else{
									$tyrepinjurysize="null";
								}
					
								if(isset($_POST['tyrerepairsel_injuryarea'])&&($_POST['tyrerepairsel_injuryarea']!="")){
									$tyrepinjuryarea=$_POST['tyrerepairsel_injuryarea'];
								}else{
									$tyrepinjuryarea="null";
								}
					
								if(isset($_POST['tyrerepairsel_prlr'])&&($_POST['tyrerepairsel_prlr']!="")){
									$tyrepiprlr=$_POST['tyrerepairsel_prlr'];
								}else{
									$tyrepiprlr="null";
								}
					
								if(isset($_POST['tyrerepairsel_repunites'])&&($_POST['tyrerepairsel_repunites']!="")){
									$tyrepirepunites=$_POST['tyrerepairsel_repunites'];
								}else{
									$tyrepirepunites="null";
								}
					
								if(isset($_POST['tyrerepairsel_tyretype'])&&($_POST['tyrerepairsel_tyretype']!="")){
									$tyrepityretype=$_POST['tyrerepairsel_tyretype'];
								}else{
									$tyrepityretype="null";
								}

								if(isset($_POST['tyrerepairsel_tyresizerim'])&&($_POST['tyrerepairsel_tyresizerim']!="")){
									$tyrerim=$_POST['tyrerepairsel_tyresizerim'];
								}else{
									$tyrerim="null";
								}
								
								if(isset($_POST['tyrerepairsel_wheel'])&&($_POST['tyrerepairsel_wheel']!="")){
									$tyrewheel=$_POST['tyrerepairsel_wheel'];
								}else{
									$tyrewheel="null";
								}
								$splstatus="null";
								foreach ($_POST['tyrerepairsel_SPL_repunites'] as $appid){
									$splstatus="1";
								}

								$splstatus="null";
								foreach ($_POST['tyrerepairsel_relatedP_repunites'] as $appid){
									$splstatus="1";
								}
								
								$sql="UPDATE `rep_selection_guide` SET `repappid`=".$tyrepvechile.",repsplstatus=".$splstatus.",`reptubetypeid`=".$tyreptubetype.",`reptyresizeid`=".$tyreptyresize.",`repinjutypeid`=".$tyrepinjurytype.",`repinjusizeid`=".$tyrepinjurysize.",`repinjuareaid`=".$tyrepinjuryarea.",`repplyratloadid`=".$tyrepiprlr.",`repUnitid`=".$tyrepirepunites.",`reptyretypeid`=".$tyrepityretype.",`repwheelid`=".$tyrewheel.",`reprimtyresizeid`=".$tyrerim;
								
								$sql=$sql." WHERE repselectiondid =".$_POST["tyrerepairsel_id"];
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){

									
									$ts_last_id =$_POST["tyrerepairsel_id"];

									$sql2="DELETE FROM `rep_special_units_pvtb` WHERE `spl_sel_guide_id` =".$ts_last_id;
									$resgrp_ty2=mysqli_query($conn,$sql2);

									foreach ($_POST['tyrerepairsel_SPL_repunites'] as $appid){
										
										$sql1="INSERT INTO `rep_special_units_pvtb`(`spl_unit_id`,`spl_sel_guide_id`) VALUES ('".$appid."','".$ts_last_id."')";
										$resgrp_ty= mysqli_query($conn,$sql1);

									}

									$sql2="DELETE FROM `sel_other_product_pvtb` WHERE `tyre_rep_sel_id` =".$ts_last_id;
									$resgrp_ty2=mysqli_query($conn,$sql2);

									foreach ($_POST['tyrerepairsel_relatedP_repunites'] as $relid){
										
										$sql2="INSERT INTO `sel_other_product_pvtb`(`TOOLID_sop`,`tyre_rep_sel_id`,`type_of_product`) VALUES ('".$relid."','".$ts_last_id."','1')";
										$resgrp_ty2= mysqli_query($conn,$sql2);

									}
									
									$response['sts']="yes";
									$response['message']="Selection Guide";
									$response['sql']=$sql2;

								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
									$response['q']="Error description: " .mysqli_error($conn);
															
								}
						}else{
							$response['sts']="no";
							$response['message']="Need Repair Selection Guide Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'sealingsystem':
						if(isset($_POST["sealingsystem_id"])&&($_POST["sealingsystem_id"]!="")){
					
							$sql="UPDATE `envelope_sealsys` SET `env_sealsystem`='".$_POST['sealingsystem_name']."', `env_sealsystem_por`='".$_POST['sealingsystem_name_por']."'";
						
							
							$sql=$sql." WHERE env_sealsysid=".$_POST["sealingsystem_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
								
									$response['sts']="yes";
									$response['message']="Sealing System";
									
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						
						}
						break;
		case 'envelopeproducts':
						if(isset($_POST["envelopeproducts_id"])&&($_POST["envelopeproducts_id"]!="")){
					
							$sql="UPDATE `envelope_products` SET `envelope_pname`='".$_POST['envelopeproducts_name']."',`envelope_pcategory`='".$_POST['envelopeproductstyp']."',`envelope_od`='".$_POST['envelopeproducts_OD']."',`envelope_secwidth`='".$_POST['envelopeproducts_secwidth']."',`envelope_idinch`='".$_POST['envelopeproducts_IDinch']."',`envelope_BTB`='".$_POST['envelopeproducts_BTB']."'";
						
							
							$sql=$sql." WHERE  `envelope_pid`='".$_POST['envelopeproducts_id']."'";
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
								
									$response['sts']="yes";
									$response['message']="Envelope Products";
									
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								
								
							}
						}else{
							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						
						}
						break;
		case 'selguide_envelope':

							if(isset($_POST["envelopesel_id"])&&($_POST["envelopesel_id"]!="")){

								if(isset($_POST['envelopesel_tyretype'])&&($_POST['envelopesel_tyretype']!="")){
									$envelopetyretype=$_POST['envelopesel_tyretype'];
								}else{
									$envelopetyretype="null";
								}

								if(isset($_POST['envelopesel_tyresize'])&&($_POST['envelopesel_tyresize']!="")){
									$envelopetyresize=$_POST['envelopesel_tyresize'];
								}else{
									$envelopetyresize="null";
								}
								if(isset($_POST['envelopesel_sealsys'])&&($_POST['envelopesel_sealsys']!="")){
									$envelopesealsys=$_POST['envelopesel_sealsys'];
								}else{
									$envelopesealsys="null";
								}
					
								// if(isset($_POST['envelopesel_outenv'])&&($_POST['envelopesel_outenv']!="")){
								// 	$envelopeoutenv=$_POST['envelopesel_outenv'];
								// }else{
								// 	$envelopeoutenv="null";
								// }

								
								// if(isset($_POST['envelopesel_inenv'])&&($_POST['envelopesel_inenv']!="")){
								// 	$envelopeinenv=$_POST['envelopesel_inenv'];
								// }else{
								// 	$envelopeinenv="null";
								// }
							
						
								$sql="UPDATE `envelope_selection_guide` SET `env_tyretype`=".$envelopetyretype.",`env_tyresize`=".$envelopetyresize.",`env_sealsys`=".$envelopesealsys;
								
								$sql=$sql." WHERE env_searchid =".$_POST["envelopesel_id"];
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
									$ts_last_id=$_POST["envelopesel_id"];

									//MAX SERIES
									$sql2="DELETE FROM `envelope_result_pvtb` WHERE `env_selection_id` =".$ts_last_id." AND `env_max_ultra_type` =3";
									$resgrp_ty2=mysqli_query($conn,$sql2);

									foreach ($_POST['envelopesel_outenv'] as $epid){
										
										$sql1="INSERT INTO `envelope_result_pvtb`(`env_product_id`,`env_max_ultra_type`,`env_selection_id`) VALUES ('".$epid."',3,'".$ts_last_id."')";
										$resgrp_ty= mysqli_query($conn,$sql1);

									}

									$sql2="DELETE FROM `sel_other_product_pvtb` WHERE `tyre_curing_sel_id` =".$ts_last_id;
									$resgrp_ty2=mysqli_query($conn,$sql2);
								
									if(isset($_POST['envelopesel_relatedP'])){
										foreach ($_POST['envelopesel_relatedP'] as $relid){
											
											$sql2="INSERT INTO `sel_other_product_pvtb`(`TOOLID_sop`,`tyre_curing_sel_id`,`type_of_product`) VALUES ('".$relid."','".$ts_last_id."','2')";
											$resgrp_ty2= mysqli_query($conn,$sql2);

										}
									}

									//ULTRA SERIES

									$sql2="DELETE FROM `envelope_result_pvtb` WHERE `env_selection_id` =".$ts_last_id." AND `env_max_ultra_type` =4";
									$resgrp_ty2=mysqli_query($conn,$sql2);
								
									if(isset($_POST['envelopesel_inenv'])){
										foreach ($_POST['envelopesel_inenv'] as $epid){
											
											$sql1="INSERT INTO `envelope_result_pvtb`(`env_product_id`,`env_max_ultra_type`,`env_selection_id`) VALUES ('".$epid."',4,'".$ts_last_id."')";
											$resgrp_ty= mysqli_query($conn,$sql1);

										}
									}
									
									$response['sts']="yes";
									$response['message']="Selection Guide";
										
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
									
								}
								
						}else{
							$response['sts']="no";
							$response['message']="Need Envelope Selection Guide Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'bladeapp':
						if(isset($_POST["bladeapp_id"])&&($_POST["bladeapp_id"]!="")){
						
							$sql="UPDATE `blade_app` SET `bapp_name`='".$_POST['bladeapp_name']."',`bapp_name_por`='".$_POST['bladeapp_name_por']."'";
						
							
							if(isset($_FILES['bladeapp_img']['name'])&&($_FILES['bladeapp_img']['name']!="")){
								$sql=$sql.", `bapp_img`='".$_FILES['bladeapp_img']['name']."'";
							}
							
							$sql=$sql." WHERE bapp_id=".$_POST["bladeapp_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['bladeapp_img']['name'])&&($_FILES['bladeapp_img']['name']!="")){
									$moveimg=uploadimgfile("bladeapp_img","Bladeapp");
								}else{
									$moveimg="1";
								}
								
								
								if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="Blade Application";
									
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
								}
		
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
									
							}
						}else{

							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'hubdiameter':
						if(isset($_POST["hubdiameter_id"])&&($_POST["hubdiameter_id"]!="")){
							
							$sql="UPDATE `blade_hubdiam` SET `hubdiam_name`='".$_POST['hubdiameter_name']."'";

							if(isset($_FILES['hubdiameter_img']['name'])&&($_FILES['hubdiameter_img']['name']!="")){
								$sql=$sql.", `hubdiam_img`='".$_FILES['hubdiameter_img']['name']."'";
							}
							
							$sql=$sql." WHERE hubdiam_id=".$_POST["hubdiameter_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['hubdiameter_img']['name'])&&($_FILES['hubdiameter_img']['name']!="")){
									$moveimg=uploadimgfile("hubdiameter_img","Hubdiam");
								}else{
									$moveimg="1";
								}
								
								if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="HUB Diameter";
									
								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg." to ".$movecat;
								
								}
		
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
									
							}
						}else{

							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'numsegment':
						if(isset($_POST["numsegment_id"])&&($_POST["numsegment_id"]!="")){
							
							$sql="UPDATE `blade_numsegment` SET `numseg_name`='".$_POST['numsegment_name']."'";

							if(isset($_FILES['numsegment_img']['name'])&&($_FILES['numsegment_img']['name']!="")){
								$sql=$sql.", `numseg_img`='".$_FILES['numsegment_img']['name']."'";
							}
							
							$sql=$sql." WHERE numseg_id=".$_POST["numsegment_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['numsegment_img']['name'])&&($_FILES['numsegment_img']['name']!="")){
									$moveimg=uploadimgfile("numsegment_img","Numsegment");
								}else{
									$moveimg="1";
								}
								
								if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="Number Of Segment";
									
								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
								
								}
		
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
									
							}
						}else{

							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'pinhole':
				if(isset($_POST["pinhole_id"])&&($_POST["pinhole_id"]!="")){
							
							$sql="UPDATE `blade_pinhole` SET `pinhole_name`='".$_POST['pinhole_name']."'";

							if(isset($_FILES['pinhole_img']['name'])&&($_FILES['pinhole_img']['name']!="")){
								$sql=$sql.", `pinhole_img`='".$_FILES['pinhole_img']['name']."'";
							}
							
							$sql=$sql." WHERE pinhole_id=".$_POST["pinhole_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['pinhole_img']['name'])&&($_FILES['pinhole_img']['name']!="")){
									$moveimg=uploadimgfile("pinhole_img","Pinhole");
								}else{
									$moveimg="1";
								}
								
								if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="Pin Hole";
									
								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
								
								}
		
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
									
							}
						}else{

							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'toothtype':
						if(isset($_POST["toothtype_id"])&&($_POST["toothtype_id"]!="")){
							
							$sql="UPDATE `blade_tooth` SET `tooth_name`='".$_POST['toothtype_name']."', `tooth_name_por`='".$_POST['toothtype_name_por']."'";

							if(isset($_FILES['toothtype_img']['name'])&&($_FILES['toothtype_img']['name']!="")){
								$sql=$sql.", `tooth_img`='".$_FILES['toothtype_img']['name']."'";
							}
							
							$sql=$sql." WHERE tooth_id =".$_POST["toothtype_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								if(isset($_FILES['toothtype_img']['name'])&&($_FILES['toothtype_img']['name']!="")){
									$moveimg=uploadimgfile("toothtype_img","Tooth");
								}else{
									$moveimg="1";
								}
								
								if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="Tooth Type";
									
								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
								
								}
		
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
									
							}
						}else{

							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'teeth':
						if(isset($_POST["teeth_id"])&&($_POST["teeth_id"]!="")){
							
							$sql="UPDATE `blade_teeth` SET `teeth_name`='".$_POST['teeth_name']."'";

							
							
							$sql=$sql." WHERE teeth_id =".$_POST["teeth_id"];
							
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
									
								// if(isset($_FILES['teeth_img']['name'])&&($_FILES['teeth_img']['name']!="")){
								// 	$moveimg=uploadimgfile("teeth_img","Teeth");
								// }else{
								// 	$moveimg="1";
								// }
								
								// if(($moveimg=="1")){
									
									$response['sts']="yes";
									$response['message']="Teeth";
									
								// }else{

								// 	$response['sts']="no";
								// 	$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
								
								// }
		
							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
									
							}
						}else{

							$response['sts']="no";
							$response['message']="Need Tyre Type Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'blade':
						if(isset($_POST["blade_id"])&&($_POST["blade_id"]!="")){
									
									$sql="UPDATE `blade_product` SET `bproduct_name`='".$_POST['blade_name']."'";

									if(isset($_FILES['blade_img']['name'])&&($_FILES['blade_img']['name']!="")){
										$sql=$sql.", `bproduct_img`='".$_FILES['blade_img']['name']."'";
									}
									
									$sql=$sql." WHERE bproduct_id =".$_POST["blade_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										if(isset($_FILES['blade_img']['name'])&&($_FILES['blade_img']['name']!="")){
											$moveimg=uploadimgfile("blade_img","Blade");
										}else{
											$moveimg="1";
										}
										
										if(($moveimg=="1")){
											
											$response['sts']="yes";
											$response['message']="Blade";
											
										}else{

											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
										
										}
				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Blade Id Contact Developer.Error 3:code";
							
						}
						break;

		case 'selguide_raspbla':

							if(isset($_POST["raspbladesel_id"])&&($_POST["raspbladesel_id"]!="")){

								if(isset($_POST['raspbladesel_bapp'])&&($_POST['raspbladesel_bapp']!="")){
									$raspbapp=$_POST['raspbladesel_bapp'];
								}else{
									$raspbapp="null";
								}
								if(isset($_POST['raspbladesel_hubdiam'])&&($_POST['raspbladesel_hubdiam']!="")){
									$rasphubdiam=$_POST['raspbladesel_hubdiam'];
								}else{
									$rasphubdiam="null";
								}
					
								if(isset($_POST['raspbladesel_segment'])&&($_POST['raspbladesel_segment']!="")){
									$raspsegment=$_POST['raspbladesel_segment'];
								}else{
									$raspsegment="null";
								}
					
								if(isset($_POST['raspbladesel_pinhole'])&&($_POST['raspbladesel_pinhole']!="")){
									$rasppinhole=$_POST['raspbladesel_pinhole'];
								}else{
									$rasppinhole="null";
								}
					
								if(isset($_POST['raspbladesel_teeth'])&&($_POST['raspbladesel_teeth']!="")){
									$raspteeth=$_POST['raspbladesel_teeth'];
								}else{
									$raspteeth="null";
								}
					
								if(isset($_POST['raspbladesel_tooth'])&&($_POST['raspbladesel_tooth']!="")){
									$rasptooth=$_POST['raspbladesel_tooth'];
								}else{
									$rasptooth="null";
								}
					
								if(isset($_POST['raspbladesel_blade'])&&($_POST['raspbladesel_blade']!="")){
									$raspbladeid=$_POST['raspbladesel_blade'];
								}else{
									$raspbladeid="null";
								}
		
						
								$sql="UPDATE `blade_selection_guide` SET `bapp_id`=".$raspbapp.",`hubdiam_id`=".$rasphubdiam.",`numseg_id`=".$raspsegment.",`pinhole_id`=".$rasppinhole.",`tooth_id`=".$rasptooth.",`teeth_id`=".$raspteeth.",`bproduct_id`=".$raspbladeid."";
								
								
								$sql=$sql." WHERE bresult_id =".$_POST["raspbladesel_id"];
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
									
									$response['sts']="yes";
									$response['message']="Selection Guide";
										
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
									
								}
								
						}else{
							$response['sts']="no";
							$response['message']="Need Blade Selection Guide Id Contact Developer.Error 3:code";
							
						}
						break;
		
		case 'sectionzz':
						if(isset($_POST["sectionzz_id"])&&($_POST["sectionzz_id"]!="")){
									
									$sql="UPDATE `rha_sectionzz` SET `sectionzzname`='".$_POST['sectionzz_name']."',`sectionzzname_por`='".$_POST['sectionzz_name_por']."'";

									if(isset($_FILES['sectionzz_img']['name'])&&($_FILES['sectionzz_img']['name']!="")){
										$sql=$sql.", `sectionzzimg`='".$_FILES['sectionzz_img']['name']."'";
									}
									
									$sql=$sql." WHERE sectionzzid =".$_POST["sectionzz_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										if(isset($_FILES['sectionzz_img']['name'])&&($_FILES['sectionzz_img']['name']!="")){
											$moveimg=uploadimgfile("sectionzz_img","Sectionzz");
										}else{
											$moveimg="1";
										}
										
										if(($moveimg=="1")){
											
											$response['sts']="yes";
											$response['message']="Sectionzz";
											
										}else{

											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
										
										}
				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Blade Id Contact Developer.Error 3:code";
							
						}
						break;
		
		case 'buffingdir':
						if(isset($_POST["buffingdir_id"])&&($_POST["buffingdir_id"]!="")){
									
									$sql="UPDATE `rha_buff_dir` SET `buff_dirname`='".$_POST['buffingdir_name']."',`buff_dirname_por`='".$_POST['buffingdir_name_por']."'";

									if(isset($_FILES['buffingdir_img']['name'])&&($_FILES['buffingdir_img']['name']!="")){
										$sql=$sql.", `buff_dirimg`='".$_FILES['buffingdir_img']['name']."'";
									}
									
									$sql=$sql." WHERE buff_dirid =".$_POST["buffingdir_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										if(isset($_FILES['buffingdir_img']['name'])&&($_FILES['buffingdir_img']['name']!="")){
											$moveimg=uploadimgfile("buffingdir_img","BuffDir");
										}else{
											$moveimg="1";
										}
										
										if(($moveimg=="1")){
											
											$response['sts']="yes";
											$response['message']="Buffing Direction";
											
										}else{

											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
										
										}
				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Buffing Direction Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'cuttingstyle':
						if(isset($_POST["cuttingstyle_id"])&&($_POST["cuttingstyle_id"]!="")){
									
									$sql="UPDATE `rha_cuttingstyle` SET `cuttingstylename`='".$_POST['cuttingstyle_name']."',`cuttingstylename_por`='".$_POST['cuttingstyle_name_por']."'";

									if(isset($_FILES['cuttingstyle_img']['name'])&&($_FILES['cuttingstyle_img']['name']!="")){
										$sql=$sql.", `cuttingstyleimg`='".$_FILES['cuttingstyle_img']['name']."'";
									}
									
									$sql=$sql." WHERE cuttingstyleid =".$_POST["cuttingstyle_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										if(isset($_FILES['cuttingstyle_img']['name'])&&($_FILES['cuttingstyle_img']['name']!="")){
											$moveimg=uploadimgfile("cuttingstyle_img","Cuttingstyle");
										}else{
											$moveimg="1";
										}
										
										if(($moveimg=="1")){
											
											$response['sts']="yes";
											$response['message']="Cutting Style";
											
										}else{

											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
										
										}
				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Cutting Style Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'hubsegment':
						if(isset($_POST["hubsegment_id"])&&($_POST["hubsegment_id"]!="")){
									
									$sql="UPDATE `rha_hubsegment` SET `hubsegnam`='".$_POST['hubsegment_name']."'";

									if(isset($_FILES['hubsegment_img']['name'])&&($_FILES['hubsegment_img']['name']!="")){
										$sql=$sql.", `hubsegimg`='".$_FILES['hubsegment_img']['name']."'";
									}
									
									$sql=$sql." WHERE hubsegid =".$_POST["hubsegment_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										if(isset($_FILES['hubsegment_img']['name'])&&($_FILES['hubsegment_img']['name']!="")){
											$moveimg=uploadimgfile("hubsegment_img","Hubsegment");
										}else{
											$moveimg="1";
										}
										
										if(($moveimg=="1")){
											
											$response['sts']="yes";
											$response['message']="HUB Segment";
											
										}else{

											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
										
										}
				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Hub Segment Id Contact Developer.Error 3:code";
							
						}
						break;
		
		case 'hubtypesize':
						if(isset($_POST["hubtypesize_id"])&&($_POST["hubtypesize_id"]!="")){
									
									$sql="UPDATE `rha_hubtypesize` SET `hubtypname`='".$_POST['hubtypesize_name']."',`hubsize`='".$_POST['hubtypesize_size']."'";

								
									
									$sql=$sql." WHERE hubtypsizid =".$_POST["hubtypesize_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										
											
											$response['sts']="yes";
											$response['message']="HUB Type/Size";
											

				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Hub Type/Size Id Contact Developer.Error 3:code";
							
						}
						break;

		case 'pinshape':
						if(isset($_POST["pinshape_id"])&&($_POST["pinshape_id"]!="")){
									
									$sql="UPDATE `rha_pinshape` SET `pinshapenam`='".$_POST['pinshape_name']."',`pinshapenam_por`='".$_POST['pinshape_name_por']."'";

									if(isset($_FILES['pinshape_img']['name'])&&($_FILES['pinshape_img']['name']!="")){
										$sql=$sql.", `pinshapeimg`='".$_FILES['pinshape_img']['name']."'";
									}
									
									$sql=$sql." WHERE pinshapeid =".$_POST["pinshape_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										if(isset($_FILES['pinshape_img']['name'])&&($_FILES['pinshape_img']['name']!="")){
											$moveimg=uploadimgfile("pinshape_img","Pinshape");
										}else{
											$moveimg="1";
										}
										
										if(($moveimg=="1")){
											
											$response['sts']="yes";
											$response['message']="Pin Shape";
											
										}else{

											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
										
										}
				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Pinshape Id Contact Developer.Error 3:code";
							
						}
						break;
		
		
		case 'pinsize':
						if(isset($_POST["pinsize_id"])&&($_POST["pinsize_id"]!="")){
									
									$sql="UPDATE `rha_pinsize` SET `pinsizenam`='".$_POST['pinsize_name']."'";

									if(isset($_FILES['pinsize_img']['name'])&&($_FILES['pinsize_img']['name']!="")){
										$sql=$sql.", `pinsizeimg`='".$_FILES['pinsize_img']['name']."'";
									}
									
									$sql=$sql." WHERE pinsizeid =".$_POST["pinsize_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										if(isset($_FILES['pinshape_img']['name'])&&($_FILES['pinshape_img']['name']!="")){
											$moveimg=uploadimgfile("pinshape_img","Pinshape");
										}else{
											$moveimg="1";
										}
										
										if(($moveimg=="1")){
											
											$response['sts']="yes";
											$response['message']="Pin Size";
											
										}else{

											$response['sts']="no";
											$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
										
										}
				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Pinshape Id Contact Developer.Error 3:code";
							
						}
						break;

		
																			
		case 'brand':
						if(isset($_POST["brand_id"])&&($_POST["brand_id"]!="")){
									
									$sql="UPDATE `market_brand` SET `market_brandnam`='".$_POST['brand_name']."',`market_brandnam_por`='".$_POST['brand_name_por']."'";

								
									
									$sql=$sql." WHERE market_brandid =".$_POST["brand_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										
											
											$response['sts']="yes";
											$response['message']="Brand";
											

				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Brand Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'MEraspblade':
						if(isset($_POST["MEraspblade_id"])&&($_POST["MEraspblade_id"]!="")){
									
									$sql="UPDATE `market_raspblade` SET `marketRaspBladenam`='".$_POST['MEraspblade_name']."'";

								
									
									$sql=$sql." WHERE marketRaspBladeid =".$_POST["MEraspblade_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										
											
											$response['sts']="yes";
											$response['message']="Rasp Blade";
											

				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Rasp Blade Id Contact Developer.Error 3:code";
							
						}
						break;
		case 'pinbrand':
						if(isset($_POST["pinbrand_id"])&&($_POST["pinbrand_id"]!="")){
									
									$sql="UPDATE `market_pinbrandequ` SET `marketPinbrandequnam`='".$_POST['pinbrand_name']."'";

								
									
									$sql=$sql." WHERE marketPinbrandequid =".$_POST["pinbrand_id"];
									
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
											
										
											
											$response['sts']="yes";
											$response['message']="Pin Brand";
											

				
									}else{

										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
											
									}
						}else{

							$response['sts']="no";
							$response['message']="Need Pin Brand Id Contact Developer.Error 3:code";
							
						}
						break;		

		
		case 'selguide_MarkE':

							if(isset($_POST["MarkEsel_id"])&&($_POST["MarkEsel_id"]!="")){

								if(isset($_POST['MarkEsel_brand'])&&($_POST['MarkEsel_brand']!="")){
									$MarkEbrand=$_POST['MarkEsel_brand'];
								}else{
									$MarkEbrand="null";
								}
								if(isset($_POST['MarkEsel_raspblade'])&&($_POST['MarkEsel_raspblade']!="")){
									$MarkEraspblade=$_POST['MarkEsel_raspblade'];
								}else{
									$MarkEraspblade="null";
								}
					
								if(isset($_POST['MarkEsel_pinbrand'])&&($_POST['MarkEsel_pinbrand']!="")){
									$MarkEpinbrand=$_POST['MarkEsel_pinbrand'];
								}else{
									$MarkEpinbrand="null";
								}
					
							
		
						
								$sql="UPDATE `market_result` SET `market_Brand`=".$MarkEbrand.",`market_RaspBlade`=".$MarkEraspblade.",`market_Pinbrandequ`=".$MarkEpinbrand;
								
								$sql=$sql." WHERE market_resultid =".$_POST["MarkEsel_id"];
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
									
									$response['sts']="yes";
									$response['message']="Selection Guide";
										
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
									
								}
								
						}else{
							$response['sts']="no";
							$response['message']="Need Blade Selection Guide Id Contact Developer.Error 3:code";
							
						}
						break;

		
		case 'product_spare':
									if(isset($_POST["product_spare_id"])&&($_POST["product_spare_id"]!="")){
												
												$sql="UPDATE `new_product` SET `product_name`='".$_POST['product_spare_name']."',`product_name_por`='".$_POST['product_spare_name_por']."',`product_cate_id`='".$_POST['product_spare_cate_id']."'";
			
												if(isset($_FILES['product_spare_img']['name'])&&($_FILES['product_spare_img']['name']!="")){
													$sql=$sql.", `product_img`='".$_FILES['product_spare_img']['name']."'";
												}
												
												$sql=$sql." WHERE product_id =".$_POST["product_spare_id"];
												
												$resgrp= mysqli_query($conn,$sql);
												if($resgrp){
														
													if(isset($_FILES['product_spare_img']['name'])&&($_FILES['product_spare_img']['name']!="")){
														$moveimg=uploadimgfile("product_spare_img","product_spare");
													}else{
														$moveimg="1";
													}
													
													if(($moveimg=="1")){
														
														$response['sts']="yes";
														$response['message']="Product";
														
													}else{
			
														$response['sts']="no";
														$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
													
													}
							
												}else{
			
													$response['sts']="no";
													$response['message']="Server Error.Try Again.Error 2:code";
													$response['q']=$sql;
														
												}
									}else{
			
										$response['sts']="no";
										$response['message']="Need Product Id Contact Developer.Error 3:code";
										
									}
									break;

		case 'img_setting':
				if(isset($_POST["img_setting_id"])&&($_POST["img_setting_id"]!="")){
							
						

							if(isset($_FILES['img_setting_img']['name'])&&($_FILES['img_setting_img']['name']!="")){
								$sql="UPDATE `settiingimg` SET  `settiingimgloc`='".$_FILES['img_setting_img']['name']."'";
								$sql=$sql." WHERE settiingimgid=".$_POST["img_setting_id"];
							
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
										
									if(isset($_FILES['img_setting_img']['name'])&&($_FILES['img_setting_img']['name']!="")){
										$moveimg=uploadimgfile("img_setting_img","settings");
									}else{
										$moveimg="1";
									}
									
									if(($moveimg=="1")){
										
										$response['sts']="yes";
										$response['message']="Image";
										
									}else{
	
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
									
									}
			
								}else{
	
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
										
								}
							}else{
	
								$response['sts']="no";
								$response['message']="Image Is Empty";
									
							}
							
						
						}else{

							$response['sts']="no";
							$response['message']="Need Setting Id Contact Developer.Error 3:code";
							
						}
				break;
			case 'branch':
						if(isset($_POST['branch_id'])&&($_POST['branch_id']!="")){

							$sql="UPDATE `elgi_branch` SET `elgi_branchname`='".$_POST['branch_name']."',`elgi_branchsub`='".$_POST['branch_subname']."',`elgi_branchadd`='".$_POST['branch_address']."',`elgi_branchmob`='".$_POST['branch_mob']."',`elgi_branchmail`='".$_POST['branch_mail']."',`branch_iframe`='".$_POST['branch_Iframe']."',`branch_country`='".$_POST['branch_country']."' WHERE `elgi_branchid`='".$_POST['branch_id']."'";
							$resgrp= mysqli_query($conn,$sql);
							
							if($resgrp){
				
								
									$response['sts']="yes";
									$response['message']='Branch';
							
									
							}else{
				
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2";
				
							}
						}else{
				
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 3";

						}
				
				
							break;

			case 'related_product_tool':

							if(isset($_POST["other_product_tool_id"])&&($_POST["other_product_tool_id"]!="")){


								$sql="UPDATE `other_product_tools` SET `tool_name`='".$_POST['ot_product_tool_name']."' ,`tyre_construct_opt`='".$_POST['tyretype']."' ,`tool_descrb`= '".$_POST['other_product_tool_descrb']."' ,`special_status`='".$_POST['radio_spl']."',`tool_name`='".$_POST['ot_product_tool_name']."' ,`tools_category`='".$_POST['tool_category']."',`tools_type`='".$_POST['tool_type']."',`product_id_opt`='".$_POST['product_tool_category']."',`order_by_opt`='".$_POST['product_tool_order']."'";
								
								if(isset($_FILES['other_product_tool_img']['name'])&&($_FILES['other_product_tool_img']['name']!="")){
									$sql=$sql.", `tool_image`='".$_FILES['other_product_tool_img']['name']."'";
								}


								
								$sql=$sql." WHERE TOOLID=".$_POST["other_product_tool_id"];
								
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
										
									if(isset($_FILES['other_product_tool_img']['name'])&&($_FILES['other_product_tool_img']['name']!="")){
										$moveimg=uploadimgfile("other_product_tool_img","other_product_tool");
									}else{
										$moveimg="1";
									}

									
									if($moveimg=="1"){

										$sql2="DELETE FROM `other_product_pvtb` WHERE `rel_pro_pid` =".$_POST["other_product_tool_id"];
										$resgrp_ty2=mysqli_query($conn,$sql2);
	
										foreach($_POST['other_wheel_id'] as $appid){
											
											$sql1="INSERT INTO `other_product_pvtb`(`rel_pro_wheel`,`rel_pro_pid`) VALUES ('".$appid."','".$_POST["other_product_tool_id"]."')";
											$resgrp_ty= mysqli_query($conn,$sql1);
	
										}
								
										
										$response['sts']="yes";
										$response['message']="Product Tool";
										
									}else{
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
									}

								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
									
								}
							}else{
								$response['sts']="no";
								$response['message']="Need  Id Product Developer.Error 3:code";
							
							}
							
						break;


			case 'related_product':

							if(isset($_POST["other_product_id"])&&($_POST["other_product_id"]!="")){

								$sql="UPDATE `other_product` SET `name_ot_pro`='".$_POST['ot_product_name']."' , `descrb_ot_pro`='".$_POST['ot_product_descrb']."' , `availables_ot_pro`='".$_POST['ot_availables']."' ,`shelf_life_ot_pro`='".$_POST['other_shelf_life']."',`elgi_product_id`='".$_POST['other_product_cate_id']."'";
								
								if(isset($_FILES['other_product_img']['name'])&&($_FILES['other_product_img']['name']!="")){
									$sql=$sql.", `image_ot_pro`='".$_FILES['other_product_img']['name']."'";
								}

								
								$sql=$sql." WHERE OTPID=".$_POST["other_product_id"];
								
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){
										
									if(isset($_FILES['other_product_img']['name'])&&($_FILES['other_product_img']['name']!="")){
										$moveimg=uploadimgfile("other_product_img","other_product");
									}else{
										$moveimg="1";
									}
									
									if($moveimg=="1"){
										
										$response['sts']="yes";
										$response['message']="Product ";
										
									}else{
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
									}

								}else{

									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code".$resgrp -> error;
									
								}

							}else{
								$response['sts']="no";
								$response['message']="Need  Id Product Developer.Error 3:code";
							
							}
							

						break;

			case 'elgi_b_product_images':
						$sql="UPDATE `elgi_b_p_media` SET `eb_p_file_type`='".$_POST['product_media_file_type']."'";
						if(isset($_FILES['product_media_file']['name'])&&($_FILES['product_media_file']['name']!="")){
									$sql=$sql.", `eb_p_file_loc`='".$_FILES['product_media_file']['name']."'";
								}

						
						$sql=$sql." WHERE eb_p_media_id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						
							if($resgrp){
									
								if(isset($_FILES['product_media_file']['name'])&&($_FILES['product_media_file']['name']!="")){
									
									$moveimg=uploadimgfile("product_media_file","product_media_file");
								}else{
									$moveimg="1";
								}
								
								if($moveimg=="1"){
									$response['sts']="yes";
									$response['message']="Media File";
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
								}

							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code".$resgrp -> error;
								
							}


						break;	

						case 'related_product_tool_category':
							if(isset($_POST['other_product_tool_id'])&&($_POST['other_product_tool_id']!="")){

							
								
								$sql="UPDATE `tools_category` SET `tool_c_name`='".$_POST['product_tool_category_name']."',`tyre_construct_toolt`='".$_POST['tool_category_tyretype']."',`product_type`='".$_POST['product_tool_type']."',`parent_tool_cate_id`='".$_POST['parent_tool_category']."',`display_order`='".$_POST['product_tool_category_display_order']."' WHERE `tool_c_id`='".$_POST['other_product_tool_id']."'";
								$resgrp= mysqli_query($conn,$sql);
								
								if($resgrp){
					
									 
										$response['sts']="yes";
										$response['message']='Tools Category';
								
										
								}else{
					
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2";
					
								}
							}else{
					
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 3";
	
							}
					
					
							break;


						case 'rim':
							if(isset($_POST['rim_id'])&&($_POST['rim_id']!="")){
	
								$sql="UPDATE `rep_rim` SET `rim_name_en`='".$_POST['rim_name']."' WHERE `rim_id`='".$_POST['rim_id']."'";
								$resgrp= mysqli_query($conn,$sql);
								
								if($resgrp){
					
									
										$response['sts']="yes";
										$response['message']='Rim';
								
										
								}else{
					
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2";
					
								}
							}else{
					
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 3";
	
							}
					
					
							break;
	

							case 'section_width':
								if(isset($_POST['rep_sec_width_id'])&&($_POST['rep_sec_width_id']!="")){
		
									$sql="UPDATE `rep_section_width` SET `rep_sec_width_name_en`='".$_POST['sec_w_name']."' WHERE `rep_sec_width_id`='".$_POST['rep_sec_width_id']."'";
									$resgrp= mysqli_query($conn,$sql);
									
									if($resgrp){
						
										
											$response['sts']="yes";
											$response['message']='Section Width';
									
											
									}else{
						
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2";
						
									}
								}else{
						
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 3";
		
								}
						
						
								break;

							case 'aspect_ratio':
								if(isset($_POST['asp_ratio_id'])&&($_POST['asp_ratio_id']!="")){
		
									$sql="UPDATE `rep_aspect_ratio` SET `aspect_ratio_name_en`='".$_POST['asp_ratio_name']."' WHERE `aspect_ratio_id`='".$_POST['asp_ratio_id']."'";
									$resgrp= mysqli_query($conn,$sql);
									
									if($resgrp){
										
											$response['sts']="yes";
											$response['message']='Aspect Ratio';
											
									}else{
						
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2";
						
									}

								}else{
						
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 3";
		
								}
						
								break;

							case 'tyre_pp_construct':
									if(isset($_POST["tppc_id"])&&($_POST["tppc_id"]!="")){
												
												$sql="UPDATE `tyre_pp_construct` SET `tppc_name_en`='".$_POST['tppc_name']."',`tppc_name_por`='".$_POST['tppc_name_por']."'";
			
												if(isset($_FILES['tppc_img']['name'])&&($_FILES['tppc_img']['name']!="")){
													$sql=$sql.", `tppc_img`='".$_FILES['tppc_img']['name']."'";
												}
												
												$sql=$sql." WHERE tppc_id =".$_POST["tppc_id"];
												
												$resgrp= mysqli_query($conn,$sql);
												if($resgrp){
														
													if(isset($_FILES['tppc_img']['name'])&&($_FILES['tppc_img']['name']!="")){
														$moveimg=uploadimgfile("tppc_img","tyre_preparation_type");
													}else{
														$moveimg="1";
													}
													
													if(($moveimg=="1")){
														
														$response['sts']="yes";
														$response['message']="Tyre Preparetion Construction";
														
													}else{
			
														$response['sts']="no";
														$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
													
													}
							
												}else{
			
													$response['sts']="no";
													$response['message']="Server Error.Try Again.Error 2:code";
														
												}
									}else{
			
										$response['sts']="no";
										$response['message']="Need Blade Id Contact Developer.Error 3:code";
										
									}
									break;

							case 'tyre_pp_repair_typ':
										if(isset($_POST["repair_typ_id"])&&($_POST["repair_typ_id"]!="")){
													
													$sql="UPDATE `tyre_pp_repair_typ` SET `repair_typ_name`='".$_POST['repair_typ_name']."',`repair_typ_name_por`='".$_POST['repair_typ_name_por']."'";
				
													if(isset($_FILES['repair_typ_img']['name'])&&($_FILES['repair_typ_img']['name']!="")){
														$sql=$sql.", `repair_typ_img`='".$_FILES['repair_typ_img']['name']."'";
													}
													
													$sql=$sql." WHERE repair_typ_id =".$_POST["repair_typ_id"];
													
													$resgrp= mysqli_query($conn,$sql);
													if($resgrp){
															
														if(isset($_FILES['repair_typ_img']['name'])&&($_FILES['repair_typ_img']['name']!="")){
															$moveimg=uploadimgfile("repair_typ_img","tyre_pp_repair_typ");
														}else{
															$moveimg="1";
														}
														
														if(($moveimg=="1")){
															
															$response['sts']="yes";
															$response['message']="Tool category";
															
														}else{
				
															$response['sts']="no";
															$response['message']="Server Error.Try Again.Error 1:code ".$moveimg;
														
														}
								
													}else{
				
														$response['sts']="no";
														$response['message']="Server Error.Try Again.Error 2:code";
															
													}
										}else{
				
											$response['sts']="no";
											$response['message']="Need Repair Type Id Contact Developer.Error 3:code";
											
										}
										break;
							case 'tools_category':
											if(isset($_POST["product_tool_c_id"])&&($_POST["product_tool_c_id"]!="")){
														
														$sql="UPDATE `tools_type` SET `tools_typ_name`='".$_POST['product_tool_category_name']."',`tools_typ_name_por`='".$_POST['product_tool_category_name_por']."',`display_order`='".$_POST['product_tool_category_display_order']."'";
					
														
														
														$sql=$sql." WHERE tools_typ_id =".$_POST["product_tool_c_id"];
														
														$resgrp= mysqli_query($conn,$sql);
														if($resgrp){
																
																$response['sts']="yes";
																$response['message']="Repair Type";
																
															
														}else{
					
															$response['sts']="no";
															$response['message']="Server Error.Try Again.Error 2:code";
																
														}
											}else{
					
												$response['sts']="no";
												$response['message']="Need Repair Type Id Contact Developer.Error 3:code";
												
											}
											break;
					case 'selguide_tyre_pp':

						if(isset($_POST["tyre_pp_sel_id"])&&($_POST["tyre_pp_sel_id"]!="")){

							if(isset($_POST['tyre_pp_construct'])&&($_POST['tyre_pp_construct']!="")){
								$tyre_pp_construct=$_POST['tyre_pp_construct'];
							}else{
								$tyre_pp_construct="null";
							}
			
							if(isset($_POST['tyre_pp_repair_typ'])&&($_POST['tyre_pp_repair_typ']!="")){
								$tyre_pp_repair_typ=$_POST['tyre_pp_repair_typ'];
							}else{
								$tyre_pp_repair_typ="null";
							}
			
							if(isset($_POST['tyre_pp_tool'])&&($_POST['tyre_pp_tool']!="")){
								$tyre_pp_tool=$_POST['tyre_pp_tool'];
							}else{
								$tyre_pp_tool="null";
							}
							
							$sql="UPDATE `tyre_pp_selection_guide` SET `tppc_id`=".$tyre_pp_construct.",repair_typ_id=".$tyre_pp_repair_typ.",`tool_id`=".$tyre_pp_tool;
							
							$sql=$sql." WHERE tyre_pp_sel_id =".$_POST["tyre_pp_sel_id"];
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){
								
								$response['sts']="yes";
								$response['message']="Selection Guide";
								$response['sql']=$sql2;

							}else{

								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
								$response['q']="Error description: " .mysqli_error($conn);
														
							}

					}else{

						$response['sts']="no";
						$response['message']="Need Preparation Selection Guide Id Contact Developer.Error 3:code";
						
					}

				break;
		
		
	}

}else if($_REQUEST['type']=="del"){
	if(isset($_POST["id"])&&($_POST["id"]!="")){
		switch($_REQUEST['action']){
			

			case 'member_admin':
				$sql="UPDATE `elgi_admin_users` SET delete_status='1'";
				$sql=$sql." WHERE elgiAdminusersId=".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Result Alert";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
					
				}

			break;

			case 'resultalert':
				$sql="UPDATE `resultdecrp_pop` SET delete_status='1'";
				$sql=$sql." WHERE resultdecrp=".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Result Alert";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
					
				}

			break;
			case 'productcat':
				$sql="UPDATE `elgi_products` SET delete_status='1'";
				$sql=$sql." WHERE elgiProductsId=".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Product";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
				}

				break;
			case 'tyretype':
					$sql="UPDATE `rep_tyretype` SET delete_status='1'";
					$sql=$sql." WHERE reptyreypeid=".$_POST["id"];
					$resgrp= mysqli_query($conn,$sql);
					if($resgrp){
						$response['sts']="yes";
						$response['message']="Tyre Type";
					}else{
						$response['sts']="no";
						$response['message']="Server Error.Try Again.Error 2:code";
					}
	
					break;
			case 'vehicle':
						$sql="UPDATE `rep_application` SET delete_status='1'";
						$sql=$sql." WHERE repappid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Tyre Type";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'tubetype':
						$sql="UPDATE `rep_tube_type` SET delete_status='1'";
						$sql=$sql." WHERE reptubetypeid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Tube Type";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
							
						}
		
					break;
			case 'tyresize':
						$sql="UPDATE `rep_tyresize` SET delete_status='1'";
						$sql=$sql." WHERE reptyresizeid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Tube Type";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
							
						}
		
					break;	
			
			case 'injuryarea':
						$sql="UPDATE `rep_injuarea` SET delete_status='1'";
						$sql=$sql." WHERE repinjuareaid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Injury Area";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
			case 'injurytype':
						$sql="UPDATE `rep_injutype` SET delete_status='1'";
						$sql=$sql." WHERE repinjutypeid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Injury Type";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'prlr':
						$sql="UPDATE `rep_ply_rating_load` SET delete_status='1'";
						$sql=$sql." WHERE repplyratloadid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Ply Rating";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
					case 'load_range':
						$sql="UPDATE `rep_load_range` SET delete_status='1'";
						$sql=$sql." WHERE rep_lr_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Load Range";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
			case 'injurysize':
						$sql="UPDATE `rep_injusize` SET delete_status='1'";
						$sql=$sql." WHERE repinjusizeid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Injury Size";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
			case 'repairunits':
						$sql="UPDATE `rep_unit` SET delete_status='1'";
						$sql=$sql." WHERE repUnitid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Injury Size";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
			case 'sealingsystem':
						$sql="UPDATE `envelope_sealsys` SET delete_status='1'";
						$sql=$sql." WHERE env_sealsysid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Sealing System";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'envelopeproducts':
						$sql="UPDATE `envelope_products` SET delete_status='1'";
						$sql=$sql." WHERE envelope_pid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Envelope Products";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'bladeapp':
						$sql="UPDATE `blade_app` SET delete_status='1'";
						$sql=$sql." WHERE bapp_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Blade Application";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'hubdiameter':
						$sql="UPDATE `blade_hubdiam` SET delete_status='1'";
						$sql=$sql." WHERE hubdiam_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="HUB Diameter";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'numsegment':
						$sql="UPDATE `blade_numsegment` SET delete_status='1'";
						$sql=$sql." WHERE numseg_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Number of Segment";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'pinhole':
						$sql="UPDATE `blade_pinhole` SET delete_status='1'";
						$sql=$sql." WHERE pinhole_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Pin Hole";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'toothtype':
						$sql="UPDATE `blade_tooth` SET delete_status='1'";
						$sql=$sql." WHERE tooth_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Tooth Type";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			
			case 'teeth':
						$sql="UPDATE `blade_teeth` SET delete_status='1'";
						$sql=$sql." WHERE teeth_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Teeth";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'blade':
						$sql="UPDATE `blade_product` SET delete_status='1'";
						$sql=$sql." WHERE bproduct_id=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Blade";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'sectionzz':
						$sql="UPDATE `rha_sectionzz` SET delete_status='1'";
						$sql=$sql." WHERE sectionzzid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Section ZZ";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'sectionzz':
						$sql="UPDATE `rha_sectionzz` SET delete_status='1'";
						$sql=$sql." WHERE sectionzzid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Section ZZ";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'buffingdir':
						$sql="UPDATE `rha_buff_dir` SET delete_status='1'";
						$sql=$sql." WHERE buff_dirid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Buffing Direction";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'cuttingstyle':
						$sql="UPDATE `rha_cuttingstyle` SET delete_status='1'";
						$sql=$sql." WHERE cuttingstyleid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Cutting Style";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'hubsegment':
						$sql="UPDATE `rha_hubsegment` SET delete_status='1'";
						$sql=$sql." WHERE hubsegid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Hub Segment";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			
			case 'hubtypesize':
						$sql="UPDATE `rha_hubtypesize` SET delete_status='1'";
						$sql=$sql." WHERE hubtypsizid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Hub Type/Size";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'pinshape':
						$sql="UPDATE `rha_pinshape` SET delete_status='1'";
						$sql=$sql." WHERE pinshapeid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="PIN Shape";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'pinsize':
						$sql="UPDATE `rha_pinsize` SET delete_status='1'";
						$sql=$sql." WHERE pinsizeid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="PIN Size";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'brand':
						$sql="UPDATE `market_brand` SET delete_status='1'";
						$sql=$sql." WHERE market_brandid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="PIN Size";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'MEraspblade':
						$sql="UPDATE `market_raspblade` SET delete_status='1'";
						$sql=$sql." WHERE marketRaspBladeid=".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Rasp Blade";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'pinbrand':
						$sql="UPDATE `market_pinbrandequ` SET delete_status='1'";
						$sql=$sql." WHERE marketPinbrandequid =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Pin Brand";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;		

			case 'selguide_raspbla':
						$sql="UPDATE `blade_selection_guide` SET delete_status='1'";
						$sql=$sql." WHERE bresult_id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Selection Guide";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;		
			case 'selguide_MarkE':
						$sql="UPDATE `market_result` SET delete_status='1'";
						$sql=$sql." WHERE market_resultid =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Selection Guide";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'selguide_envelope':
						$sql="UPDATE `envelope_selection_guide` SET delete_status='1'";
						$sql=$sql." WHERE env_searchid =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Selection Guide";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'elgi_brand':
						$sql="UPDATE `elgi_brands_det` SET delete_status='1'";
						$sql=$sql." WHERE brand_Id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
						
							$sql="UPDATE `elgi_brand_product_cate` SET delete_status='1'";
							$sql=$sql." WHERE `product_c_id` =".$_POST["id"];
							$resgrp= mysqli_query($conn,$sql);
							if($resgrp){

								$sql="UPDATE `elgi_brand_product_subcate` SET delete_status='1'";
								$sql=$sql." WHERE `product_sc_id` =".$_POST["id"];
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){

									$sql="UPDATE `elgi_brand_product` SET delete_status='1'";
									$sql=$sql." WHERE eb_product_id =".$_POST["id"];
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
										$response['sts']="yes";
										$response['message']="Sub Brand";
									}else{
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
									}
									
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
								}
								
							}else{
								$response['sts']="no";
								$response['message']="Server Error.Try Again.Error 2:code";
							}
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	

			case 'product_category':
						$sql="UPDATE `elgi_brand_product_cate` SET delete_status='1'";
						$sql=$sql." WHERE `product_c_id` =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							
						

							$sql="UPDATE `elgi_brand_product_subcate` SET delete_status='1'";
								$sql=$sql." WHERE `product_sc_id` =".$_POST["id"];
								$resgrp= mysqli_query($conn,$sql);
								if($resgrp){

									$sql="UPDATE `elgi_brand_product` SET delete_status='1'";
									$sql=$sql." WHERE eb_product_id =".$_POST["id"];
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
										$response['sts']="yes";
										$response['message']="Product Category";
										
									}else{
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
									}
									
								}else{
									$response['sts']="no";
									$response['message']="Server Error.Try Again.Error 2:code";
								}



						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;		
			case 'product_subcategory':
						$sql="UPDATE `elgi_brand_product_subcate` SET delete_status='1'";
						$sql=$sql." WHERE `product_sc_id` =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
									
									$sql="UPDATE `elgi_brand_product` SET delete_status='1'";
									$sql=$sql." WHERE eb_product_id =".$_POST["id"];
									$resgrp= mysqli_query($conn,$sql);
									if($resgrp){
										$response['sts']="yes";
										$response['message']="Product Sub-Category";
									}else{
										$response['sts']="no";
										$response['message']="Server Error.Try Again.Error 2:code";
									}
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;
			case 'elgi_b_product':
						$sql="UPDATE `elgi_brand_product` SET delete_status='1'";
						$sql=$sql." WHERE eb_product_id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Product";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
			case 'branch':
						$sql="UPDATE `elgi_branch` SET delete_status='1'";
						$sql=$sql." WHERE elgi_branchid =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Branch";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
			case 'elgi_b_product_images':
						$sql="UPDATE `elgi_b_p_media` SET delete_status='1'";
						$sql=$sql." WHERE eb_p_media_id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Media File";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	

			case 'scc_cards':
						$sql="UPDATE `ssc_card_details` SET delete_status='1'";
						$sql=$sql." WHERE ssc_card_id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="SCC Cards File";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	

			case 'related_product':
						$sql="UPDATE `other_product` SET delete_status='1'";
						$sql=$sql." WHERE OTPID =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Related Product";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	

			case 'related_product_tool':
						$sql="UPDATE `other_product_tools` SET delete_status='1'";
						$sql=$sql." WHERE TOOLID =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Related Product";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	
			case 'rim':
						$sql="UPDATE `rep_rim` SET delete_status='1'";
						$sql=$sql." WHERE rim_id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Rim";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	

			case 'section_width':
						$sql="UPDATE `rep_section_width` SET delete_status='1'";
						$sql=$sql." WHERE rep_sec_width_id =".$_POST["id"];
						$resgrp= mysqli_query($conn,$sql);
						if($resgrp){
							$response['sts']="yes";
							$response['message']="Section Width";
						}else{
							$response['sts']="no";
							$response['message']="Server Error.Try Again.Error 2:code";
						}
					break;	

				
			case 'aspect_ratio':
				$sql="UPDATE `rep_aspect_ratio` SET delete_status='1'";
				$sql=$sql." WHERE aspect_ratio_id =".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Aspect Ratio";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
				}
			break;	

			case 'tyre_pp_construct':
				$sql="UPDATE `tyre_pp_construct` SET delete_status='1'";
				$sql=$sql." WHERE tppc_id=".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Tyre Preparetion Construction";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
				}
			break;

			case 'tyre_pp_repair_typ':
				$sql="UPDATE `tyre_pp_repair_typ` SET delete_status='1'";
				$sql=$sql." WHERE repair_typ_id=".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Repair Tool";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
				}
			break;
			case 'tools_category':
				$sql="UPDATE `tools_type` SET delete_status='1'";
				$sql=$sql." WHERE tools_typ_id=".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Tool Category";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
				}
			break;

			case 'selguide_tyre_pp':
				$sql="UPDATE `envelope_selection_guide` SET delete_status='1'";
				$sql=$sql." WHERE env_searchid =".$_POST["id"];
				$resgrp= mysqli_query($conn,$sql);
				if($resgrp){
					$response['sts']="yes";
					$response['message']="Selection Guide";
				}else{
					$response['sts']="no";
					$response['message']="Server Error.Try Again.Error 2:code";
				}
			break;
					
		}
	}else{
		$response['sts']="no";
		$response['message']="Select One product.Error 3:code";
	}
	
	
}

echo json_encode($response);


?>

Youez - 2016 - github.com/yon3zu
LinuXploit