$memberId = $db -> quote($_REQUEST['memberId']);
		$categoryId = $db -> quote($_REQUEST['categoryId']);
		$noOfUnits = $_REQUEST['noOfUnits'];
		$password = $db -> quote($_REQUEST['password']);
		$packId = $db -> quote($_REQUEST['packId']);
		$packageAmt11 = $_REQUEST['packageAmt1'];
		
		$packageDetails = $db -> select('SELECT * FROM `tbl_roidetails` WHERE `id`='.$packId.'' );
		
		$weeklyDetails = $db -> select('SELECT * FROM `tbl_roidetails` WHERE `id`='.$packId.'' );
	
		$serviceCharge=$packageDetails[0]['serviceCharge'];
		
		$packageAmt=$packageAmt11;		
		
		
		$week1Amt=$packageDetails[0]['week1']/100;
		$week1=$week1Amt*$packageAmt;		
		
		
		$week2Amt=$packageDetails[0]['week2']/100;
		$week2=$week2Amt*$packageAmt;
		
		
		$week3Amt=$packageDetails[0]['week3']/100;
		$week3=$week3Amt*$packageAmt;		
		
		
		$week4Amt=$packageDetails[0]['week4']/100;
		$week4=$week4Amt*$packageAmt;
		
		$pack1Amt=$serviceCharge/100;
		
		$packDets1=$week1*$pack1Amt;		
		
		$packDets2=$week2*$pack1Amt;		
		
		$packDets3=$week3*$pack1Amt;		
		
		$packDets4=$week4*$pack1Amt;
		
		$netpay1=$week1-$packDets1;
		$netpay2=$week2-$packDets2;
		$netpay3=$week3-$packDets3;
		$netpay4=$week4-$packDets4;
		
		
		
		
		$sumOfPin = $db -> select('SELECT sum(`Amount`) as TotalAmt FROM `tbl_pinwallet` WHERE `Memberid`="'.$_SESSION['memberId'].'"  ' );
		
		$topupDetails = $db -> select('SELECT sum(`amt`) as TotalAmt FROM `topupdetails` WHERE `loginid`="'.$_SESSION['memberId'].'"  ' );
		
		$sumOfPinWalletFrom = $db -> select('SELECT sum(`Amount`) as TotalAmt FROM `tbl_pinwallet` WHERE `pinwalletfrom`="'.$_SESSION['memberId'].'"  ' );
		
		$totalPinWallet=$sumOfPin[0]['TotalAmt']-$topUpDetails[0]['amt']-$sumOfPinWalletFrom[0]['TotalAmt'];
		
		
		if($totalPinWallet>=$packageAmt11){
			
			
				$topUpDetails =  $db -> query("INSERT INTO `topupdetails` (`memberid`,`categoryId`,`loginid`,`packageId`,`amt`,`topupDate`) VALUES (".$memberId.",".$categoryId.",'".$_SESSION['memberId']."','".$packageDetails[0]['id']."','".$packageAmt11."',".$date.")");
			
			if($topUpDetails){
				
					$topupDetailsLevelIncome = $db -> select('SELECT * FROM `topupdetails` WHERE `sno`="'.$topUpDetails.'"  ' );
				
					$date123 = strtotime("+7 day");
					$today = date('Y-m-d',$date123);

					$roundVal=$packageDetails[0]['noOfDays'];	


					$lastWeekCount=$roundVal*7;

					$lastWeekCountrepeat = strtotime("+$lastWeekCount day",strtotime($today));

					$lastWeekCountrepeat1 =date('Y-m-d', $lastWeekCountrepeat);	
					$lastweek1Amt=$packageDetails[0]['lastWeek']/100;
					$lastWeekAmtAl=$lastweek1Amt*$packageAmt;	





					$lastweek1ServAmt=$serviceCharge/100;
					$lastWeekServAmtAl=$lastweek1ServAmt*$lastWeekAmtAl;	

					$lastNetPay=$lastWeekAmtAl-$lastWeekServAmtAl;

					$totalPayAlls=0;		


					$principleRetunPercentage1=$weeklyDetails[0]['percentage']/100;

					$principleRetunPercentage2=$packageAmt11*$principleRetunPercentage1;

					$principleServiceAmt1=$weeklyDetails[0]['serviceCharge']/100;

					$principleServiceAmtMultiply1=$principleRetunPercentage2*$principleServiceAmt1;

					$principleServiceAmtMinus1=$principleRetunPercentage2-$principleServiceAmtMultiply1;
				
				
												if($weeklyDetails[0]['packageType']==1){
													
												$countDays=0;
													
													$coolingPeriod=$weeklyDetails[0]['coolingPeriod'];
													$afterSevenDay = strtotime("+$coolingPeriod day");

													$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);
													
												for($i=0;$i<$weeklyDetails[0]['noOfDays'];$i++){
													
													$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
													$dayForNextPrev2=date('D', strtotime($resultAfterSevenDays));
													
																			   
													$dateforNextWeek = strtotime(date("Y-m-d", strtotime($dateWithoutQuotes)) . " +$i day");			
													$weekForNextWeek=date('Y-m-d', $dateforNextWeek);
													$iVal=$i+1;
													
													$dayForNextPrev=date('D', strtotime($dayForNextPrev2));
													
													
																			   
													if($dayForNextPrev=='Sat'){
														
														$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
																			   
														$dateforNextWeek1 = strtotime(date("Y-m-d", strtotime($weekForNextWeek)) . " +2 day");							   
														$weekForNextWeek1=date('Y-m-d', $dateforNextWeek1);
														
														$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");					   
														
													}else if($dayForNextPrev=='Sun'){
																			   
														$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
														
														$dateforNextWeek1 = strtotime(date("Y-m-d", strtotime($weekForNextWeek)) . " +1 day");							   
														$weekForNextWeek1=date('Y-m-d', $dateforNextWeek1);
														
														$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");
																			   
													}else{
														   $resultAfterSevenDays=$resultAfterSevenDays;
														$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");
																			   
																			   
													}
																			   
													
												
												}


												}else if($weeklyDetails[0]['packageType']==2){
													
													$coolingPeriod=$weeklyDetails[0]['coolingPeriod'];
													$afterSevenDay = strtotime("+$coolingPeriod day");
													
													$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);
													$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
													
													if($dayForNextPrev=="Sat"){

														$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
														$dateforNextWeek1 = strtotime(date("Y-m-d", strtotime($resultAfterSevenDays)) . " +0 day");							   
														$resultAfterSevenDays=date('Y-m-d', $dateforNextWeek1);

													}else if($dayForNextPrev=="Sun"){

														$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
														$dateforNextWeek1 = strtotime(date("Y-m-d", strtotime($resultAfterSevenDays)) . " +0 day");							   
														$resultAfterSevenDays=date('Y-m-d', $dateforNextWeek1);


													}else{

														$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
														$dateforNextWeek1 = strtotime(date("Y-m-d", strtotime($resultAfterSevenDays)) . " +0 day");							   
														$resultAfterSevenDays=date('Y-m-d', $dateforNextWeek1);


													}
													

													for($i=0;$i<$weeklyDetails[0]['noOfDays'];$i++){	
														$iVal=$i+1;
														$resultAfterSevenDays1 = strtotime(date("Y-m-d", strtotime($resultAfterSevenDays)) . " +1 week");	
														$resultAfterSevenDays=date('Y-m-d', $resultAfterSevenDays1);
														
														$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");
													}	
													
														
													
												}else if($weeklyDetails[0]['packageType']==4){
													
													$coolingPeriod=$weeklyDetails[0]['coolingPeriod'];
													$afterSevenDay = strtotime("+$coolingPeriod day");

													$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);
													
													for($i=1;$i<=$weeklyDetails[0]['noOfDays'];$i++){
												$iVal=$i;
														$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +15 day'));
														
														$resultAfterSevenDays=$resultAfterSevenDays;
													
														$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");
														
												
												}	

												}else if($weeklyDetails[0]['packageType']==3){
													
													$coolingPeriod=$weeklyDetails[0]['coolingPeriod'];
													$afterSevenDay = strtotime("+$coolingPeriod day");

													$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

													for($i=0;$i<$weeklyDetails[0]['noOfDays'];$i++){
														
														$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 month'));
														$dayForNextPrev2=date('D', strtotime($resultAfterSevenDays));
													
													 $dateforNextWeek = strtotime(date("Y-m-d", strtotime($dateWithoutQuotes)) . " +$i month");			
													$weekForNextWeek=date('Y-m-d', $dateforNextWeek);
													$iVal=$i+1;
													
													$dayForNextPrev=date('D', strtotime($dayForNextPrev2));
													
													if($dayForNextPrev=='Sat'){
														 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
														$dateforNextWeek1 = strtotime(date("Y-m-d", strtotime($weekForNextWeek)) . " +2 day");							   
														$weekForNextWeek1=date('Y-m-d', $dateforNextWeek1);
														
														$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");					   
														
													}else if($dayForNextPrev=='Sun'){
															
														
														 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
														
														$dateforNextWeek1 = strtotime(date("Y-m-d", strtotime($weekForNextWeek)) . " +1 day");							   
														$weekForNextWeek1=date('Y-m-d', $dateforNextWeek1);
														
														$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");
																			   
													}else{
														
													 $resultAfterSevenDays=$resultAfterSevenDays;	 $resultAfterSevenDays=$resultAfterSevenDays;
													$resultForWeek1 =  $db -> query("INSERT INTO `principlereturn` (`packageId`,`Memberid`,`Week`,`payout`,`develop`,`netpay`,`eldate`,`cdate`) VALUES ('".$packageDetails[0]['id']."',".$memberId.",".$iVal.",'".$principleRetunPercentage2."','".$principleServiceAmtMultiply1."','".$principleServiceAmtMinus1."','".$resultAfterSevenDays."',".$dateTime.")");
																			   
													}
														
														
													
												
												}
													
												}
				
				$check2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`='.$memberId.' ' );	
				

				for($i=1;$i<=10;$i++){

					if($i==1){

						$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );

						$select1sumOfLevel1=$select1[0]['L1amt']+$packageAmt;

						$update= $db -> query('UPDATE `legcount` SET `L1amt`='.$select1sumOfLevel1.' WHERE `MemberID`="'.$select1[0]['MemberID'].'" ');








					}	
					if($i==2){

						$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select1[0]['SponsorID'].'" ' );
						$select1sumOfLevel2=$select2[0]['L2amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L2amt`='.$select1sumOfLevel2.' WHERE `MemberID`="'.$select2[0]['MemberID'].'" ');




					}
					if($i==3){

						$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );
						$select1sumOfLevel3=$select3[0]['L3amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L3amt`='.$select1sumOfLevel3.' WHERE `MemberID`="'.$select3[0]['MemberID'].'" ');


						$select3Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['MemberID'].'" ' );

						if($select3Tour[0]['L1amt']>=250000){

							$select3TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select3[0]['MemberID'].'" ' );	



						}	


					}
					if($i==4){

						$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );
						$select1sumOfLevel4=$select4[0]['L4amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L4amt`='.$select1sumOfLevel4.' WHERE `MemberID`="'.$select4[0]['MemberID'].'" ');

						$select4Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['MemberID'].'" ' );

						if($select4Tour[0]['L1amt']>=250000){

							$select4TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select4[0]['MemberID'].'" ' );	



						}		



					}
					if($i==5){

						$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );
						$select1sumOfLevel5=$select5[0]['L5amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L5amt`='.$select1sumOfLevel5.' WHERE `MemberID`="'.$select5[0]['MemberID'].'" ');



						$select5Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['MemberID'].'" ' );

						if($select5Tour[0]['L1amt']>=250000){

							$select5TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select5[0]['MemberID'].'" ' );	



						}		



					}
					if($i==6){

						$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );
						$select1sumOfLevel6=$select6[0]['L6amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L6amt`='.$select1sumOfLevel6.' WHERE `MemberID`="'.$select6[0]['MemberID'].'" ');

						$select6Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['MemberID'].'" ' );

						if($select6Tour[0]['L1amt']>=250000){

							$select6TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select6[0]['MemberID'].'" ' );	

							if($select5TourDb[0]['id']==""){
								//	$resultLegForTour1 =  $db -> query("INSERT INTO `tbl_tour` (`userId`,`amount`,`status`,`createdAt`) VALUES ('".$select6[0]['MemberID']."','".$select6Tour[0]['L1amt']."',1,".$date.")");
							}

						}		


					}
					if($i==7){

						$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );
						$select1sumOfLevel7=$select7[0]['L7amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L7amt`='.$select1sumOfLevel7.' WHERE `MemberID`="'.$select7[0]['MemberID'].'" ');

						$select7Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['MemberID'].'" ' );

						if($select7Tour[0]['L1amt']>=250000){

							$select7TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select7[0]['MemberID'].'" ' );	

							if($select7TourDb[0]['id']==""){
								//	$resultLegForTour1 =  $db -> query("INSERT INTO `tbl_tour` (`userId`,`amount`,`status`,`createdAt`) VALUES ('".$select7[0]['MemberID']."','".$select7Tour[0]['L1amt']."',1,".$date.")");
							}

						}		



					}
					if($i==8){

						$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );
						$select1sumOfLevel8=$select8[0]['L8amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L8amt`='.$select1sumOfLevel8.' WHERE `MemberID`="'.$select8[0]['MemberID'].'" ');


						$select8Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select8[0]['MemberID'].'" ' );

						if($select8Tour[0]['L1amt']>=250000){

							$select8TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select8[0]['MemberID'].'" ' );	

							if($select8TourDb[0]['id']==""){
								//	$resultLegForTour1 =  $db -> query("INSERT INTO `tbl_tour` (`userId`,`amount`,`status`,`createdAt`) VALUES ('".$select8[0]['MemberID']."','".$select8Tour[0]['L1amt']."',1,".$date.")");
							}

						}	

					}
					if($i==9){

						$select9 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select8[0]['SponsorID'].'" ' );
						$select1sumOfLevel9=$select9[0]['L9amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L9amt`='.$select1sumOfLevel9.' WHERE `MemberID`="'.$select9[0]['MemberID'].'" ');


						$select9Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select9[0]['MemberID'].'" ' );

						if($select9Tour[0]['L1amt']>=250000){

							$select9TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select9[0]['MemberID'].'" ' );	

							if($select9TourDb[0]['id']==""){
								//	$resultLegForTour1 =  $db -> query("INSERT INTO `tbl_tour` (`userId`,`amount`,`status`,`createdAt`) VALUES ('".$select9[0]['MemberID']."','".$select9Tour[0]['L1amt']."',1,".$date.")");
							}

						}




					}
					if($i==10){

						$select10 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select9[0]['SponsorID'].'" ' );
						$select1sumOfLevel10=$select10[0]['L10amt']+$packageAmt;
						$update= $db -> query('UPDATE `legcount` SET `L10amt`='.$select1sumOfLevel10.' WHERE `MemberID`="'.$select10[0]['MemberID'].'" ');

						$select10Tour = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select10[0]['MemberID'].'" ' );

						if($select10Tour[0]['L1amt']>=250000){

							$select10TourDb = $db -> select('SELECT * FROM `tbl_tour` WHERE `userId`="'.$select10[0]['MemberID'].'" ' );	

							if($select9TourDb[0]['id']==""){
								//	$resultLegForTour1 =  $db -> query("INSERT INTO `tbl_tour` (`userId`,`amount`,`status`,`createdAt`) VALUES ('".$select10[0]['MemberID']."','".$select10TourDb[0]['L1amt']."',1,".$date.")");
							}

						}


					}
					
				}
				
												$levelsCheck = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`='.$memberId.' ' );	
												
										
											
												$level1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$levelsCheck[0]['SponsorID'].'" ' );	
												
												
												$sumOfLevel1=$level1[0]['L1']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L1`='.$sumOfLevel1.' WHERE `MemberID`="'.$level1[0]['MemberID'].'" ');
												
											
												$level2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level1[0]['SponsorID'].'" ' );	
												
												
												$sumOfLevel2=$level2[0]['L2']+1;
																		$update= $db -> query('UPDATE `legcount` SET `L2`='.$sumOfLevel2.' WHERE `MemberID`="'.$level2[0]['MemberID'].'" ');
												
												
												
												$level3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level2[0]['SponsorID'].'" ' );	
												
												$sumOfLevel3=$level3[0]['L3']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L3`='.$sumOfLevel3.' WHERE `MemberID`="'.$level3[0]['MemberID'].'" ');
												
												
												$level4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level3[0]['SponsorID'].'" ' );	
												
												$sumOfLevel4=$level4[0]['L4']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L4`='.$sumOfLevel4.' WHERE `MemberID`="'.$level4[0]['MemberID'].'" ');
												
												$level5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level4[0]['SponsorID'].'" ' );	
												
												$sumOfLevel5=$level5[0]['L5']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L5`='.$sumOfLevel5.' WHERE `MemberID`="'.$level5[0]['MemberID'].'" ');
												
												$level6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level5[0]['SponsorID'].'" ' );	
												
												$sumOfLevel6=$level6[0]['L6']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L6`='.$sumOfLevel6.' WHERE `MemberID`="'.$level6[0]['MemberID'].'" ');
												
												$level7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level6[0]['SponsorID'].'" ' );	
												
												$sumOfLevel7=$level7[0]['L7']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L7`='.$sumOfLevel7.' WHERE `MemberID`="'.$level7[0]['MemberID'].'" ');
												
												$level8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level7[0]['SponsorID'].'" ' );	
												
												$sumOfLevel8=$level8[0]['L8']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L8`='.$sumOfLevel8.' WHERE `MemberID`="'.$level8[0]['MemberID'].'" ');
												
												$level9 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level8[0]['SponsorID'].'" ' );	
												
												$sumOfLevel9=$level9[0]['L9']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L9`='.$sumOfLevel9.' WHERE `MemberID`="'.$level9[0]['MemberID'].'" ');
												
												$level10 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$level9[0]['SponsorID'].'" ' );	
												
												$sumOfLevel10=$level10[0]['L10']+1;
												
												$update= $db -> query('UPDATE `legcount` SET `L10`='.$sumOfLevel10.' WHERE `MemberID`="'.$level10[0]['MemberID'].'" ');
									
						
				$levelDetailsForPack = $db -> select('SELECT * FROM `tbl_leveldetails` WHERE `packageID`='.$packId.' ' );


				$lev1=$levelDetailsForPack[0]['level1']/100;
				$lev1Amt=$lev1*$packageAmt;	


				$perServAmount=$levelDetailsForPack[0]['serviceAmt']/100;
				$serviceAmt1=$perServAmount*$lev1Amt;

				$totalAmts1=$lev1Amt-$serviceAmt1;

				$lev2=$levelDetailsForPack[0]['level2']/100;
				$lev2Amt=$lev2*$packageAmt;	


				$serviceAmt2=$perServAmount*$lev2Amt;

				$totalAmts2=$lev2Amt-$serviceAmt2;

				$lev3=$levelDetailsForPack[0]['level3']/100;
				$lev3Amt=$lev3*$packageAmt;	


				$serviceAmt3=$perServAmount*$lev3Amt;

				$totalAmts3=$lev3Amt-$serviceAmt3;	

				$lev4=$levelDetailsForPack[0]['level4']/100;
				$lev4Amt=$lev4*$packageAmt;	


				$serviceAmt4=$perServAmount*$lev4Amt;

				$totalAmts4=$lev4Amt-$serviceAmt4;	

				$lev5=$levelDetailsForPack[0]['level5']/100;
				$lev5Amt=$lev5*$packageAmt;	


				$serviceAmt5=$perServAmount*$lev5Amt;

				$totalAmts5=$lev5Amt-$serviceAmt5;	


				$lev6=$levelDetailsForPack[0]['level6']/100;
				$lev6Amt=$lev6*$packageAmt;	


				$serviceAmt6=$perServAmount*$lev6Amt;

				$totalAmts6=$lev6Amt-$serviceAmt6;


				$lev7=$levelDetailsForPack[0]['level7']/100;
				$lev7Amt=$lev7*$packageAmt;	

				$serviceAmt7=$perServAmount*$lev7Amt;
				$totalAmts7=$lev7Amt-$serviceAmt7;

				$lev8=$levelDetailsForPack[0]['level8']/100;
				$lev8Amt=$lev8*$packageAmt;	

				$serviceAmt8=$perServAmount*$lev8Amt;
				$totalAmts8=$lev8Amt-$serviceAmt8;



				$noOfWeeks=$levelDetailsForPack[0]['noOfDays'];	
				
				
				if($levelDetailsForPack[0]['packagetype']==1){

	

												
												for($i=1;$i<=8;$i++){
												
													if($i==1){
														
														
														$afterSevenDay = strtotime("-1 day");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															if($dayForNextPrev=='Sat'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																		if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		
																		}

																}
															}
															else if($dayForNextPrev=='Sun'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																		if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		

																		}
																}
															}
															else{
																
															     $resultAfterSevenDays=$resultAfterSevenDays;
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																		if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		
																		}

																}
															}

														}
																 
														
													}	
													
												
													
													if($i==2){

														$afterSevenDay = strtotime("-1 day");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															if($dayForNextPrev=='Sat'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
																

																$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){
if($select2[0]['status']==1){
																
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}
															else if($dayForNextPrev=='Sun'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
																

																	$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){

																if($select2[0]['status']==1){
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}
															else{
																
															     $resultAfterSevenDays=$resultAfterSevenDays;
																

																	$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){

																if($select2[0]['status']==1){
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}

														}

													}	


													if($i==3){
														
														$afterSevenDay = strtotime("-1 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		

																	}
																	}
																}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		
																	}

																	}
																}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){
if($select3[0]['status']==1){

																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		
																	}

																	}
																}
															}

														}	
														
														
													}
													
													
												if($i==4){
													
													$afterSevenDay = strtotime("-1 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}

														}		
													
														
													}	
														
													if($i==5){
														
														$afterSevenDay = strtotime("-1 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}	
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}	
														}	
															}
															}

														}	
														
													}
													
													if($i==6){
														
														$afterSevenDay = strtotime("-1 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}	
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}	
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}	
														}	
															}
															}

														}	
														
														
													}
													
													if($i==7){
														
														$afterSevenDay = strtotime("-1 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}	
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}	
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}
														}	
															}
															}

														}	
														
													}
													
													
													if($i==8){
														
														$afterSevenDay = strtotime("-1 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}

														}	
														
													}
															
													
												}	
}
if($levelDetailsForPack[0]['packagetype']==2){

	

												
												for($i=1;$i<=8;$i++){
												
													if($i==1){
														
														
														$afterSevenDay = strtotime("-7 day");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															if($dayForNextPrev=='Sat'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																	if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		

																	}
																}
															}
															else if($dayForNextPrev=='Sun'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																	if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		
																	}

																}
															}
															else{
																
															     $resultAfterSevenDays=$resultAfterSevenDays;
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																	if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		
																	}

																}
															}

														}
																 
														
													}	
													
												
													
													if($i==2){

														$afterSevenDay = strtotime("-7 day");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															if($dayForNextPrev=='Sat'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
																

																$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){
if($select2[0]['status']==1){
																
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}
															else if($dayForNextPrev=='Sun'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
																

																	$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){

																if($select2[0]['status']==1){
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}
															else{
																
															     $resultAfterSevenDays=$resultAfterSevenDays;
																

																	$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){
if($select2[0]['status']==1){
																
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}

														}

													}	


													if($i==3){
														
														$afterSevenDay = strtotime("-7 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		
																	}

																	}
																}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		

																	}
																	}
																}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){
if($select3[0]['status']==1){

																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		
																	}

																	}
																}
															}

														}	
														
														
													}
													
													
												if($i==4){
													
													$afterSevenDay = strtotime("-7 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}

														}		
													
														
													}	
														
													if($i==5){
														
														$afterSevenDay = strtotime("-7 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}	
														}	
															}
															}

														}	
														
													}
													
													if($i==6){
														
														$afterSevenDay = strtotime("-7 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}	
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}	
														}	
															}
															}

														}	
														
														
													}
													
													if($i==7){
														
														$afterSevenDay = strtotime("-7 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}
														}	
															}
															}

														}	
														
													}
													
													
													if($i==8){
														
														$afterSevenDay = strtotime("-7 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 week'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}		
            													}	
            												}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}

														}	
														
													}
															
													
												}	
}
if($levelDetailsForPack[0]['packagetype']==4){

	

												
												for($i=1;$i<=8;$i++){
												
													if($i==1){
														
														
														$afterSevenDay = strtotime("-15 day");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															  $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															  $resultAfterSevenDays=$resultAfterSevenDays;
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																	if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		
																	}

																}
															

														}
																 
														
													}	
													
												
													
													if($i==2){

														$afterSevenDay = strtotime("-15 day");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															
															
																
															     $resultAfterSevenDays=$resultAfterSevenDays;
																

																	$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){

																
																if($select2[0]['L1amt']>=0){			
if($select2[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
}
																}				
															}
															

														}

													}	


													if($i==3){
														
														$afterSevenDay = strtotime("-15 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															
														

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		

																	}
																	}
															
															}

														}	
														
														
													}
													
													
												if($i==4){
													
													$afterSevenDay = strtotime("-15 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															

														}		
													
														
													}	
														
													if($i==5){
														
														$afterSevenDay = strtotime("-15 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}
														}	
															
															}

														}	
														
													}
													
													if($i==6){
														
														$afterSevenDay = strtotime("-15 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}	
														}	
															
															}

														}	
														
														
													}
													
													if($i==7){
														
														$afterSevenDay = strtotime("-15 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}	
														}	
															
															}

														}	
														
													}
													
													
													if($i==8){
														
														$afterSevenDay = strtotime("-15 day");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 day'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															
																$resultAfterSevenDays=$resultAfterSevenDays;


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												
															}

														}	
														
													}
															
													
												}	
}	
				

if($levelDetailsForPack[0]['packagetype']==3){

	

												
												for($i=1;$i<=8;$i++){
												
													if($i==1){
														
														
														$afterSevenDay = strtotime("-1 month");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															if($dayForNextPrev=='Sat'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																	if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		

																	}
																}
															}
															else if($dayForNextPrev=='Sun'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																	if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		
																	}

																}
															}
															else{
																
															     $resultAfterSevenDays=$resultAfterSevenDays;
																

																if($check2[0]['SponsorID']!='' && $check2[0]['SponsorID']!='Company'){


																	$select1 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );			
																	if($select1[0]['status']==1){
																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$check2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts1."','".$serviceAmt1."','".$lev1Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",1)"); 		
																	}

																}
															}

														}
																 
														
													}	
													
												
													
													if($i==2){

														$afterSevenDay = strtotime("-1 month");
														
														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	
														
														for($j=1;$j<=$noOfWeeks;$j++){
														
															 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															  $dayForNextPrev=date('D', strtotime($resultAfterSevenDays));
															
															if($dayForNextPrev=='Sat'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));
																

																$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){

																if($select2[0]['status']==1){
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}
															else if($dayForNextPrev=='Sun'){
																
																 $resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));
																

																	$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){

																if($select2[0]['status']==1){
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}
															else{
																
															     $resultAfterSevenDays=$resultAfterSevenDays;
																

																	$select2 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$check2[0]['SponsorID'].'" ' );	

															if($select2[0]['SponsorID']!='' && $select2[0]['SponsorID']!='Company'){

																if($select2[0]['status']==1){
																if($select2[0]['L1amt']>=0){			

																	$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select2[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts2."','".$serviceAmt2."','".$lev2Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",2)"); 		
																}
																}				
															}
															}

														}

													}	


													if($i==3){
														
														$afterSevenDay = strtotime("-1 month");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		

																	}
																	}
																}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		

																	}
																	}
																}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select3 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select2[0]['SponsorID'].'" ' );		
																if($select3[0]['SponsorID']!='' && $select3[0]['SponsorID']!='Company'){

if($select3[0]['status']==1){
																	if($select3[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select3[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts3."','".$serviceAmt3."','".$lev3Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",3)"); 		

																	}
																	}
																}
															}

														}	
														
														
													}
													
													
												if($i==4){
													
													$afterSevenDay = strtotime("-1 month");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	
if($select4[0]['status']==1){
																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select4 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select3[0]['SponsorID'].'" ' );	

																if($select4[0]['SponsorID']!='' && $select4[0]['SponsorID']!='Company'){	if($select4[0]['status']==1){

																	if($select4[0]['L1amt']>=0){			
																		$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select4[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts4."','".$serviceAmt4."','".$lev4Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",4)"); 		
																	}
																	}		
																}
															}

														}		
													
														
													}	
														
													if($i==5){
														
														$afterSevenDay = strtotime("-1 month");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select5 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select4[0]['SponsorID'].'" ' );	
															
													if($select5[0]['SponsorID']!='' && $select5[0]['SponsorID']!='Company'){	
														if($select5[0]['status']==1){
														if($select5[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select5[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts5."','".$serviceAmt5."','".$lev5Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",5)"); 		
														}
														}	
															}
															}

														}	
														
													}
													
													if($i==6){
														
														$afterSevenDay = strtotime("-1 month");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select6 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select5[0]['SponsorID'].'" ' );	
															
													if($select6[0]['SponsorID']!='' && $select6[0]['SponsorID']!='Company'){	
														if($select6[0]['status']==1){
														if($select6[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select6[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts6."','".$serviceAmt6."','".$lev6Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",6)"); 		
														}
														}	
															}
															}

														}	
														
														
													}
													
													if($i==7){
														
														$afterSevenDay = strtotime("-1 month");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}	
														}	
															}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}
														}	
															}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select7 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select6[0]['SponsorID'].'" ' );	
															
													if($select7[0]['SponsorID']!='' && $select7[0]['SponsorID']!='Company'){	
														if($select7[0]['status']==1){
														if($select7[0]['L1amt']>=0){			
														$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select7[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts7."','".$serviceAmt7."','".$lev7Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",7)"); 		
														}
														}	
															}
															}

														}	
														
													}
													
													
													if($i==8){
														
														$afterSevenDay = strtotime("-1 month");

														$resultAfterSevenDays=date('Y-m-d', $afterSevenDay);	

														for($j=1;$j<=$noOfWeeks;$j++){

															$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +0 month'));
															$dayForNextPrev=date('D', strtotime($resultAfterSevenDays));

															if($dayForNextPrev=='Sat'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +2 day'));


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}
															else if($dayForNextPrev=='Sun'){

																$resultAfterSevenDays = date('Y-m-d', strtotime($resultAfterSevenDays . ' +1 day'));


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}
															else{

																$resultAfterSevenDays=$resultAfterSevenDays;


																$select8 = $db -> select('SELECT * FROM `legcount` WHERE `MemberID`="'.$select7[0]['SponsorID'].'" ' );	
															
            												if($select8[0]['SponsorID']!='' && $select8[0]['SponsorID']!='Company'){	
            													if($select8[0]['status']==1){
            													if($select8[0]['L1amt']>=0){			
            													$referalIncome =  $db -> query("INSERT INTO `levelincome` (`memberid`,`fromId`,`netpay`,`develop`,`payout`,`eldate`,`level`,`packageId`,`cdate`,`levelStage`) VALUES ('".$select8[0]['SponsorID']."','".$check2[0]['MemberID']."','".$totalAmts8."','".$serviceAmt8."','".$lev8Amt."','".$resultAfterSevenDays."',".$j.",".$topUpDetails.",".$dateTime.",8)"); 		
																}	
            													}	
            												}
															}

														}	
														
													}
															
													
												}	
}
		
				
												
				
			}											
			
		}
		
		echo 1;