One Hat Cyber Team

View File Name : index.php

<?php

//ini_set('max_execution_time', 6000);

//die(); 



//header("Content-type: application/vnd-ms-excel");

//header("Content-Disposition: attachment; filename=NIQS Financial List.xls");



$con = mysqli_connect("localhost", "niqsorgn_portal", "@Xchange69!") or die("Not Connected");

$db = mysqli_select_db($con, "niqsorgn_pota1969");



//get all

$q = "SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.memberGrade!='9' AND (a.memberGrade='1' OR a.memberGrade='2' OR a.memberGrade='6') AND a.memberSurname!=''  AND a.deceased!='1' AND a.memberSurname != 'DEMO' AND a.memberSurname != 'DEMO' AND a.memberSurname != 'ACCOUNT' AND a.memberOthernames!='DEMO' AND ((b.advance + b.annualSub + b.annualSub2017 + b.annualSub2018 + b.annualSub2019 + b.annualSub2020 + b.annualSub2021 + b.annualSub2022 + b.annualSub2023 + b.annualSub2024 + b.devtLevy2 + b.devtLevy1) > 0) ORDER BY a.memberState ASC"; //order by memberState





$r = mysqli_query($con, $q);

$as = mysqli_num_rows($r);  //die();  



echo "<h3 align='center'> LIST OF CORPORATE MEMBERS/FELLOWS WHO STAND THE RISK OF BEING SUSPENDED FROM THE INSTITUTE'S <br>

REGISTER DUE TO THEIR INDEBTEDNESS AS AT ".date('d M, Y')." ....4TH APRIL, 2024 <BR>   </h3>";

echo "<table align='center' border='1' cellpadding='0' cellspacing='0' width='auto'>";



$dd = 1;



echo "<tr><th> SN <th> MEMBER NO. <td><b> &nbsp; &nbsp;   NAME <th> GRADE <th> CHAPTER <th> TOTAL OUTSTANDING<br>SUBSCRIPTION  <th> TOTAL DEV'T<br>LEVY <th> TOTAL OUTSTANDING<br>AMOUNT</tr>";



//<th> Passport <th> ID Card Status</tr>";

while($row = mysqli_fetch_array($r))

{

 

 	

 	$no = $row['memberNo'];

 	$title = $row['memberTitle'];

 	$names = $row['memberSurname']. " ".$row['memberOthernames'];

 	

 	$sex = $row['memberSex'];

 	$dob = $row['memberDOB'];

 	$grade = $row['memberGrade'];

 	$chapter= $row['memberState'];

 	$phone= $row['memberPhone'];

 	$phone2= $row['memberPhone2'];

 	$mniqsdate= $row['member_date'];

 	

 	$email= strtolower($row['memberEmail']);

 	$regdate = $row['memberRegDate'];

 	$memberAddress = $row['memberAddress'];

     

 	extract($row);

 	

 	//how old is he/she

 	$yr = date('Y') - date('Y', strtotime($dob));	

 	if($yr == 0){ $yr = $yr + 1; }

 	

	if(date('m') - date('m', strtotime($dob)) < 0)

	{

	   //not completed in terms of month

	   $yr = $yr-1; 

	   

	} elseif((date('m') - date('m', strtotime($dob)) == 0) && (date('d') - date('d', strtotime($dob)) < 0)){

	    //month is same  but day is yet to complete

	   //not completed in terms of day

	   $yr = $yr-1;

	}	

 	//---how old

 	

 	$amountSub = $row['advance'] + $row['outstanding'] + $row['annualSub'] + $row['annualSub2017'] + $row['annualSub2018'] + $row['annualSub2019'] + $row['annualSub2020'] + $row['annualSub2021'] + $row['annualSub2022'] + $row['upgradeCharge'] + $row['annualSub2023'] + $row['annualSub2024'];

 	$amountDev = $row['devtLevy1'] + $row['devtLevy2'];

	$totalamount = $amountSub + $amountDev;



        switch($grade)

	{

		case 1: $memberGrade="FELLOW";

		break;

		

		case 2: $memberGrade="MEMBER";

		break;

		

		case 3: $memberGrade="PROBATIONER";

		break;

		

		case 4: $memberGrade="TECHNICIAN";

		break;

		

		case 5: $memberGrade="STUDENT";

		break;

		

		case 6: $memberGrade="PRACTICING FIRM";

		break;

		

		case 7: $memberGrade="GRADUATE";

		break;

		

		case 8: $memberGrade="STATE CHAPTER";

		break;

		

		case 9: $memberGrade="PAST PRESIDENT";

		break;

		

		default: $memberGrade = $memberGrade;

		

	}

		

	



	//chk if late

	$qd = "SELECT * FROM deceased WHERE memberNo='$no'";

	$rd = mysqli_query($con, $qd);

	$deadi = mysqli_num_rows($rd);  //die();

	

	if($deadi < 1)

	{

     	if(strlen($names) > 3){ 

            //echo "<tr><td> $dd <td align='center'> $no <td> ".strtoupper($names)." <td> $dob <td> $yr <td> $memberGrade <td> $phone, $phone2  <td> $email <td> $chapter <td> $outstanding <td> $advance <td> $annualSub <td> $annualSub2017 <td> $annualSub2018 <td> $annualSub2019 <td> $annualSub2020 <td> $annualSub2021 <td> $annualSub2022 <td> $annualSub2023 <td> $annualSub2024 <td> $upgradeCharge <td> $devtLevy1 <td> $devtLevy2 <td>".number_format($amount,2);

     	    echo "<tr><td> $dd <td align='center'> $no <td> ".strtoupper($names)." <td> $memberGrade <td> ".strtoupper($chapter)." <td align='center'> ".number_format($amountSub,2)." <td align='center'> ".number_format($amountDev, 2)." <td align='center'>".number_format($totalamount,2). " </tr>";

     	    $dd++;

         }

	 }

    

}





//echo '<script>window.close();</script>';

?>