®ÈWþñduwÍË{žó:¾ƒ1}dñá–>ì{Ï¹ "ËÖ®–lš–ø¸Ÿí6§2‰`Þ‡TÕ¬Ã;¨½$@Éá©¥£¶_4¤ŠÒm¼'g©5«ûÇWÙFÞ»®‰/<Ô“KËæÈ*ÝÿÓÛk½)ö7¡|â&ªY¤4qÐ²ªNÃ1NÙ`mS3VLÜ01šeänv;øÓ#pñ
bš Ð€WÔWæÖœ@3mUÞôæLžXÁÈ‡÷~»þeÃéêêRÕül‘Mv}T»ÏG˜˜}wå3¯¬]ˆŠã´±yµÝí8¼ÖIÜ—¶ÚÀCK ’8d¬fŠÑ®¶ê cm4è>ü|UA#€¾!“Ý?’¡úsóàÿ $Š4~þ:›3•Æ*qR«d’Ãù›V•Š’rûkÚŒ˜¬Æ®ªÄ Áù%˜ %cq|ëC‹Ô˜(i;Š7*ìŒè¢ ZcÌËÆ *•öµÇ[Ä?8Æø»Ý˜Áu½dº*3
þ%´Ï/¡…m"íH“'›Ò2XÓt$¿%ÿ**ªš¥nócSÐ ÄS!<ÈÆò/ˆE_åc $È—Îa0Ëcø^ìkïS,²OÆRºK^C<‹ÀwÄÇðo²½cxŒj!Ý •îVZ,æbømKÎ›êH„‘û‰¢SM Ä†™Ûé¡ð.{î¡ôf3IpÑYA+Ù-ÿç¬"²Q„ ®Q<û­:Úd†ŒÂ¨‰dƒÎÒØH˜¶cœ>h½‹ÅØÑ±Ô¸ çÀ(jÊá½<Sjà±Qú²ÀÊmYdÐÏ*+“Î‘à6’Eí¿”æ-(}/&è^Ýt+û‚–Ûý"guîžÂcjÃ ’Â)›j¼K?Ö´£”b]ÃChu(+4hy	h²ÉÓ=éj@cH:R©×£JÎÇÎnix.õ='Äá•CE„HZA ˆ¦SOáAÐT?É3Y@G¦ûhÛ×G¥+³‘C©ÞÉZ‚ÏMþõ!»¦Øàëh!ºëÎí‘NÄHe$­'{ìCNS¥ïÿ»s7á¶Ì"O€9ãÉ<š×™”¢xQ*0ÜŽ‰VpšºUJŒnúTÁÑÁÓ¬ãgÎKÈjÉ²?©8tRÄ»ˆ<V„PLÆÁ¥#X½®T_Š²wüÖˆUVŽ<$_à½Gmê°Ì žX¨Ø?PÆ¾|ÃÿŒêæ`²ÓÛU8ÅPYåš(ëdõM±¨$Te”ÅV}ñ?(Ðˆ›õuáp¡êêx!×º+G ¤8
NÔ©µI\<ªY½%V9¯>‘þÛiàâ\—ý†OxCa	+À ÒÓ§¸Næ;¸QgèÎIe-ÝæJÆöq	´mz\ê©‹ÇZ¥®…“"^áY"dvc¼P‰Cunô×Ðp`oPY‰o£rJLG¢fhr¬gî‘Õ$ÑZÊ»·v\‰nj’vÒ¢1Üú‰È§Jýð¡ÔÍ&£LˆG`ÁK©aÏ2qw+aø˜n.ØK2ÖöÈ£ÿ­8¿Ølí#IPÙ)ƒŸ	ú´Ã x(Ú¯¯«£2<Ûö
¢¹jW©<’ÑhE
U"‘^“û,äj@ã.\q+”
‰»ù—æÅ8Üõ)€‘ŽÍ56ÌÞ½
ÂxQä£¥%A3û3%C…ƒ;N*ÿû¿B…ŽäUVÜòœõâ¿øz(_š¤=®„Q}œ›)ùejìXÎÚŸXýj“MûËÏÉ]$<_°÷ß?L~Ïòä¬@ð›\ ×w¼ž»4Ùëq„ÌF6iŠlk¡×í´,º˜¹õ'¼+ÁkÎ˜ ÑN'ÁûLïÖq»}Õî#¡â°êí‹]ë´~Ž-ÈIÅ¬øþÑ!ÓÞÒ ÏÔÛªgH¿M©	B²OK>+¬
E‡" Y]{Y¯›ð)ˆÈÁ&-[,Î~Ñ«7‘ÓD·‰\Ÿ<Ëÿ§ºÜlPžN4Ä%¨5ì­[‡ôs[  nf›¡B¥?¤/¬`BŸÎ[ë&¨§(‰l“;ñý].Mü˜
Ž•Zó ¶ÕÐu™{ t¥1ƒÅ¢XJžÝG•p•ê×hª§£)¾.þ‡MôÏçšŠGv®¯*Mz`Ú¢…@o3BÀÒßäZ ¾D X6W,ûqÂ)C¢äHÃP^]óH!–0M]X1¹½¸¡äu$-ðª©Ù»µGÍ¥††í¬	Q–XÌ¤RL#þ±s…ƒ­KxÑZF‰$›Ø%'“Ö¸U±¢¼ãm;‡•t‰J{”*í©ž®;9¡íôLy¢×aÚþb]s>6{–ë–ázXyuï:a6Yýy(«{Ñ½æ2Cñ[à+Oš…Ù°;¦¥{±csµBnU†÷]¦ƒÖ +@ö8ƒâ‚P>'*æêÙ%’îšéØå mnÂðù£EED‡VØ†:›ë^µYa?“º/õ_Zý;@OÓšê:\`¾I ƒxŒiFÑ³‰Î©è<Ë¯Ò©O!ÞÁF±wš“S79)ÔßŸï­û´8X$GÑ"	:4"fE æó6z Pyª‰Î/ê¨î…eTÁ ¦<mØ°¤á*êÌæÃw²£(P¸nF„{©¹òÈÈÑ~þ~†´þóÎeÉD¢³K8m,¶a÷ðÈ´õôó8²`··ÿ…e@¯ñ£ªú¯Ê¢¾²â:wOÀ6&ÖJtšÁÔ77]ík)
‹½QÇ¼]N»¡-Èàx|°m¹}lÌL-ß´!×—ÍÌ„µbüí÷žeÛìŽ7ö\»~T¿@¬…ì®e»·‚Ÿp´J²éüi
¢–µMuq™ŽXS-Â½ZÙ¶,¬Ó¢o‘"42íßôÄŸo„F_Â¿¢ãÜü^öð	'çš¢†ÇJ7Ñ@Ï?£PÊCÔ
fž¼¯ÉØù†^cÙªDEõ&•ã3ˆŸPõe³G< ˆÿö&ú%NÝ¾¿Uƒ´S VÊã€ÝcuéP—<]›hjÏf'®,D'\üY]€#•‡ä·¯ÑáESãÁÞ¬X`"|2Ç# k•±¦Û'sö_ ˆ™ !OôP£AE\›_µ+ÛâÞòIà™=ºÜð·ó 7{ŒBeQž2T	^§Ô„d\Ž‹¢{X³H/ƒPz™¢Ä±:zç¢oæOTž}É&¬8uÔu#‡ë38ÝªG®óç~“ø$óÖKÚˆW• …Ø.¡fÆ}¢qŽ@ùgÌG+Ñwþ³1JîÊs7uúê(Ó¦ÙÊ"Ùió}ëÄü	s668—ú”èà[‹	GQy]‡/¬@ª†x°xk¶Ñk†^–¸© ‡!ß÷—^…˜ôóÈ0@fjÕ$®«KÒ“a'XúÝ³›7@`qOT§
8¾«$ÒYë÷8t€Å_ž÷ç†6âpŽ’•8Úîö*6ê¯Å‚ïÖ2QÀö°Îå„.´M†Æ·ztþÐæsê”‚ØïH©:Uà?1?ÓbœWˆÂ@\(äWØ.œÑèbŒŒBsqVãW%qH]ÜcŒž7±¦Û'sö_ ˆ™ !OôP/Ö›»;ò¸>AˆoQßM5G-QÂùVˆ…w F](#$Ò‰½ßuðd‹9òÚÒÌ4#€Í‘ªŸpöe”›é­¤“&ÖIµW)¨Õ/dâµÈ+í9]¨­-…W/è¿jŠHëA™‚—ÐìN=v¬ÚÜ'B©Ãõ‡hF´ì#Ä¡ÄknG3„õÑ¤R—Ÿ°xóÑŽa+4ÕMƒ ºÆäLn9ÑÂ:Ç	£íd÷z "ª+`ùŸdO|Jq<>V_ÖÅžƒQä£¥%A3û3%C…ƒø TÏ?DÚªˆ‰5Eõ+6¨àSd;	¢o¸™ç^š¸yD¨Æ˜ïÞôo_Yˆ,Á›Gcù°ÙÍ€SŒ«ï.Z‹ §¸‚5/qb„÷Ÿ¼'g•+=®s¿{á9B#iÏ¡òj…¶ÆW´‰/òÓPŸ¼Q§kVƒù†AÛ3þJó’ë1„èÿg…rZB8u/6U£3ÜÁåÓ'‘mBoÚ¤ÇÌ»ºBYya±ñ³îS‹óEÿ–©_H"?+ÿûöK!FÕºn`$F…†*ïoŸŸ‚ë´@b0PÒšßnÿ8”pð>k)ºŠ	ücÚZÑ
2¹¾e€¨;[cg¡6ÑýTS{*	\ÅÛ¡ðgH4“ÖÀÆí¡mËñý¤&«Rò6:D~+•K“ažâMƒ¹­‚,w¼/Xô+`Æ ¶ËŒZ_2a\´wD	1£ÄÌ"\=Zêí¶¶2u5}{WXB×Æ¶×I›¢3ÅXñ0Ó† YGÛ%qÒî<•“°¹â-2]Å„J|xj˜êä‹á­ïÙEÖ©°öÁ„Ë˜KÁP@™uèœmóÏ]?¾¤7É÷ðHÈ{¥õ2xÚ„5Î€÷;‡47åÂ#F™yx©ß¨
{d¾·e~˜/n¦\.H¹ôÝ›J¦Í>éø*ôäÄñÛKŸ ¥(Jë©åÐ…Ø„Ì‹Ñ#ÖŒs¤Û^-”É(Ã7’{í	ò7&Ý¶‡6îñV	wh,­¶S¶L9ÕwÙ`Æ>Äl^]‡Q2ü#ÉX
úÂ®æäÀEÊÚ–G` A¾ÃÕu>úÌéöÁWdL”À'¨YÂræp§¥îÝ_­€•áÐž>MMÀÞµè"ÝMK áFÈºn7ƒ¶“éçâm†ÑX¢¯”ÊT2¹«’Â¼N™©ÞcÂ|z|'²ób
gmgâž‡'DaPÀ !;*îKŠ€¸Ï}8FÒJFgž—Ó¥ÅB§†¥zEŽ,|i>•gë–ó,M+KeäûÕ©=š^ Cã{9å YÚ{õûº¾òT¿Ò£ØoŒ~s™Ê1ùT5p=«ï$PWXEP4lWaŠÀ†ŽÐ²WBæJgÿ²¿ÞÆN½r${@J½j¦bG€ˆ0ÞÕvºæhïÊßÁ´Ë“”_zçX)\6vûÛyý[›±W—Ò`çEeˆXÙX ¬y¬áš½ mUÄÖK€hi1\ðÕ©Wë™GÑ¸i|
!æ<?0¼›ïæ­¡Nò­üüÒ‡j(ÀO9Q¶›ä¢k‡c†Ù*</H”÷b„ˆ#
¸ÉëŒƒ©|e3yŽ Y‚ìOI¡·Ø£Té _-Ü\N÷I›o—<£+Â|c¼ÉˆÕÃBÝÉˆb„ˆ#
¸ÉëŒƒ©|eóÂ7\¤dR°ð@qÏÛêC&×<yL/éáðð–!å _-Ü\N÷I›o—<£ù)Ü’¿°”3@¦Ô;^Ž-Ì²lÉÉDä„á@;@8ó‡'Ó¹Ç»AcíŠ~Á÷F}ˆßlesheet -->
    <link href="css/style.css" rel="stylesheet">
	<SCRIPT LANGUAGE="JavaScript">
	function checkAllFuction(vol)
	{
		var i=1;
		//alert("done");
		var sports = document.forms['myform'].elements["checkAll[]"];
		if (vol.checked == true){
			for (i=0; i<sports.length; i++) 
				sports[i].checked=true;
		}else{
		for (i=0; i<sports.length; i++) 
			sports[i].checked=false;
		}
	}
	</script>
	
</head>

<body>

<?php include_once"header.php";?>

    <!-- Breadcrumb Start -->
    <div class="container-fluid">
        <div class="row px-xl-5">
            <div class="col-12">
                <nav class="breadcrumb bg-light mb-30">
                    <a class="breadcrumb-item text-dark" href="index">Home</a>
                    <span class="breadcrumb-item active">packageform</span>
                </nav>
            </div>
        </div>
    </div>
    <!-- Breadcrumb End -->


    <!-- Checkout Start -->
    <div class="container-fluid">
        <div class="row px-xl-5">
            <div class="col-lg-12">
                <div class="bg-light p-30 mb-3">
					 <form action='packageform.php' method='post' enctype="multipart/form-data">
					 <input class="form-control" name='autoid' type="hidden" value='<?php echo $autoid ?>'>
						<div class="row">						
							<div class="col-md-3 form-group">
								<input class="form-control" name='date_' type="date" placeholder="date" value='<?php echo $date_ ?>'>
							</div>
							<div class="col-md-3 form-group">
								<input class="form-control" name='todate' type="date" placeholder="date" value='<?php echo $todate ?>'>
							</div>
							<div class="col-md-3 form-group">
								<select class="form-control" name='entryuser' id='entryuser'>
									<option value=''>Select User...</option>
									<?php	
									echo fillCMB($con,$entryuser,"select autoid,mname from stafftbl where 1=1 order by mname");
									?>
								</select>
							</div>

							<div class="col-md-3 form-group">
								<select onchange='tehsilClick()' class="form-control" name='tehsilid' id='tehsilid'>
									<option value=''>Select Tehsil...</option>
									<?php	
									echo fillCMB($con,$tehsilid,"select autoid,hname from headstbl where hstatus=1 and htype='Tehsil' order by hname");
									?>
								</select>
							</div>

							<div class="col-md-3 form-group">
<div id='divVc'>
								<select onchange='vcClick()' class="form-control" name='vcid' id='vcid' style='width:100%'>
									<option value=''>Select Village Council...</option>
									<?php	
									echo fillCMB($con,$vcid,"select autoid,hname from headstbl where hstatus=1 and htype='VC' order by hname");
									?>
								</select>
</div>								
							</div>

							<div class="col-md-3 form-group">
<div id='divVillage'>
								<select class="form-control" name='villageid' id='vcid'>
									<option value=''>Select Village...</option>
									<?php	
									echo fillCMB($con,$villageid,"select autoid,hname from headstbl where hstatus=1 and htype='Village' order by hname");
									?>
								</select>
</div>								
							</div>

							<div class="col-md-3 form-group">
<div id='divCategory'>
								<select class="form-control" name='categoryid' id='vcid'>
									<option value=''>Select Category...</option>
									<?php	
									echo fillCMB($con,$categoryid,"select autoid,hname from headstbl where hstatus=1 and htype='Category' order by order_");
									?>
								</select>
</div>								
							</div>

							<div class="col-md-3 form-group">
								<input class="form-control" name='code' type="text" placeholder="ID" value='<?php echo $code; ?>'>
							</div>
							<div class="col-md-3 form-group">
								<input class="form-control" name='nic' type="text" placeholder="nic" value='<?php echo $nic; ?>'>
							</div>

							<div class="col-md-3 form-group">
								<select class="form-control" name='packageid' id='tehsilid'>
									<option value=''>Select Package...</option>
									<?php	
									echo fillCMB($con,$packageid,"select autoid,hname from headstbl where hstatus=1 and htype='packageType' order by order_");
									?>
								</select>
							</div>

							
							<div class="col-md-3 form-group">
								<input class="form-control" name='worth' type="text" placeholder="worth" value='<?php echo $worth; ?>' >
							</div>
							
							<div class="col-md-3 form-group">
								<input class="form-control" name='remarks' type="text" placeholder="remarks" value='<?php echo $remarks; ?>' >
							</div>
						

							
							<div class="col-md-3 form-group">	
								<button type='submit' name='btnsearch' class="btn btn-block btn-primary font-weight-bold py-2">Search</button>
							</div>							

							<div class="col-md-3 form-group">	
								<button type='submit' name='btnPackageTakenList' class="btn btn-block btn-primary font-weight-bold py-2">Search Package Taken</button>
							</div>							

							<div class="col-md-3 form-group">	
								<button type='submit' name='btnPrint' class="btn btn-block btn-primary font-weight-bold py-2">Print Package Taken</button>
							</div>							
							<div class="col-md-3 form-group">	
								<button type='submit' name='btnPrinttoken' class="btn btn-block btn-primary font-weight-bold py-2">Print Package Token</button>
							</div>							
					
						</div>
					 </form>
                </div>
            </div>
            <div class="col-lg-12">


<div  id='divnicinfo' class='d-none'>
	<div class="bg-light p-30 mb-1">
	</div>
</div>			
                <div class="col-12 bg-light p-2 mb-5">
				 <form name='myform' action='packageform.php' method='post' enctype="multipart/form-data">
					<table class='table table-sm' border='0' >
					<thead>
						<tr><th>#<th><input name='CheckAllMain' type='checkbox' id='CheckAllMain' value='Y' onClick='checkAllFuction(this);' checked><th>Name<th>Father/Husband<th>NIC<th>Contact<th>Type<th>Package<th>Worth<th>Remarks
					</thead>
<?php 
$query="select s.autoid,s.males,s.females,s.date_,s.time_,s.dname,s.fname,s.nic,s.contactno,s.daddress,u.mname,h.hname,s.description from headstbl h,surveytbl s,stafftbl u where s.categoryid=h.autoid and s.userid=u.autoid   ";
//$query="select s.autoid,s.date_,s.time_,s.dname,s.fname,s.nic,s.contactno,s.daddress,u.mname,u.contactno as uno from surveytbl s,stafftbl u where s.userid=u.autoid  ";
if(!isset($_POST['btnsearch']) ) {
	$query.=" and (s.date_ BETWEEN '$date_'  AND '$todate')  ";
}

if(isset($_POST['nic']) and $_POST['nic']!="") {
	$query.=" and s.nic='".$_POST['nic']."' ";
}elseif(isset($_POST['code']) and $_POST['code']!="") {
	$query.=" and s.autoid='".$_POST['code']."' ";
}else{
	if(isset($_POST['tehsilid']) and $_POST['tehsilid']!="") $query.=" and s.tehsilid='".$_POST['tehsilid']."' ";
	if(isset($_POST['vcid']) and $_POST['vcid']!="") $query.=" and s.vcid='".$_POST['vcid']."' ";
	if(isset($_POST['categoryid']) and $_POST['categoryid']!="") $query.=" and s.categoryid='".$_POST['categoryid']."' ";
	if(isset($_POST['daddress']) and $_POST['daddress']!="") $query.=" and s.daddress like'%".$_POST['daddress']."%' ";
	if(isset($_POST['contactno']) and $_POST['contactno']!="") $query.=" and s.contactno like'%".$_POST['contactno']."%' ";
	if(isset($_POST['description']) and $_POST['description']!="") $query.=" and s.description like'%".$_POST['description']."%' ";
	if(isset($_POST['nic']) and $_POST['nic']!="") $query.=" and s.nic like'%".$_POST['nic']."%' ";
	if(isset($_POST['dname']) and $_POST['dname']!="") $query.=" and s.dname like'%".$_POST['dname']."%' ";
	if(isset($_POST['entryuser']) and $_POST['entryuser']!="") $query.=" and s.userid='".$_POST['entryuser']."' ";
}
$query.=" order by s.autoid desc";
$run = mysqli_query($con,$query);
$cnt=1;$total=0;
while ($row=mysqli_fetch_array($run)){
	
?>					
				<tr>
					<input name='sid_<?php echo $cnt;?>' type="hidden"  value='<?php echo $row['autoid']?>' >
					
					<td><?php echo $cnt; ?>
					<td><input type='checkbox' name='checkAll[]' value='<?php echo $row['autoid']?>' checked>
					<td><a style='color:red' href='survey?editid=<?php echo $row['autoid']; ?>' target='_Blank'><?php echo $row['dname']; ?></a>
					<td><?php echo $row['fname']; ?>
<?php 
	$isPackage=getName($con,"select 1 from packagetbl where sid='".$row['autoid']."'" ) ;
	if($isPackage=='1'){
?>					
				<td><a style='color:red' href='packageDetail?sid=<?php echo $row['autoid']; ?>' target='_Blank'><?php echo $row['nic']; ?></a>
<?php 
	}else{
?>
				<td><?php echo $row['nic']; ?>
<?php 
	}
?>					<td><?php echo $row['contactno']; ?>
					

					<td><?php echo $row['hname']; ?>
					

					<td>			<select class="form-control" name='packageid_<?php echo $cnt;?>' >
									<option value=''>Select Package</option>
									<?php	
									echo fillCMB($con,$packageid,"select autoid,hname from headstbl where hstatus=1 and htype='packageType' order by order_");
									?>
								</select>
								
							

							
					<td>
								<input class="form-control" name='worth_<?php echo $cnt;?>' type="text" placeholder="worth" value='<?php echo $worth;?>' >
					<td>
								<input class="form-control" name='remarks<?php echo $cnt;?>' maxlength='100' type="text" placeholder="remarks" value='<?php echo $remarks;?>' >
						
					
					<?php $cnt++; ?>
					
				</tr>
<?php 
	}
?>					
					</table>
					<input class="form-control" name='cnt' type="hidden" value='<?php echo ($cnt-1);?>' >
						<div class="col-md-3 form-group">	
						<button type='submit' name='btnAddPackage' class="btn btn-block btn-primary font-weight-bold py-2">Add Package</button>
					</div>							

					</form>

                </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Checkout End -->


<?php include_once"footer.php";?>

	<script>
	function nicfocusout() {
		//alert('Item added to cart successfully');
		var nic=document.getElementById("nic").value;
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects?nic="+nic , false);
		xmlhttp.send(null);
		document.getElementById("divnicinfo").innerHTML=xmlhttp.responseText;		
	}

	function tehsilClick() {
		//alert('Item added to cart successfully');
		var tehsilid=document.getElementById("tehsilid").value;
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects?tehsilidSearch="+tehsilid , false);
		xmlhttp.send(null);
		document.getElementById("divVc").innerHTML=xmlhttp.responseText;		
	}
	function vcClick() {
		//alert('Item added to cart successfully');
		var vcid=document.getElementById("vcid").value;
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects?vcid="+vcid , false);
		xmlhttp.send(null);
		document.getElementById("divVillage").innerHTML=xmlhttp.responseText;		
	}

	</script>
	
    <!-- JavaScript Libraries -->
    <script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.bundle.min.js"></script>
    <script src="lib/easing/easing.min.js"></script>
    <script src="lib/owlcarousel/owl.carousel.min.js"></script>

    <!-- Contact Javascript File -->
    <script src="mail/jqBootstrapValidation.min.js"></script>
    <script src="mail/contact.js"></script>

    <!-- Template Javascript -->
    <script src="js/main.js"></script>
	
</body>
</html>