One Hat Cyber Team

View File Name : fxn.php

<?php
ob_start();
//include_once("../function.php");

function GetImage ($std_custome4) {
    $thispfile = "../images/memberpicture/$std_custome4";
    if (file_exists($thispfile)) {
        $thisimage = "../images/memberpicture/$std_custome4";
    }
    else {
        $thisimage = "../images/memberpicture/nopicture.jpg";
    }
    return $thisimage;

}

function UpImage ($std_custome4) {
    $thispfile = "$std_custome4";
    return $thispfile;
}
function GetLevelName ($lv) {
    $query1 = "SELECT *
	FROM level
	WHERE level_id = '$lv'
	LIMIT 1";
    $query1 = mysql_query($query1)
            or die(mysql_error());
    $num1 = mysql_num_rows($query1);
    $row1 = mysql_fetch_array($query1);
    $level_name = $row1["level_name"];
    return $level_name;

}
function getLevelGrade($id) {
    $query = "SELECT *
	FROM grade
	WHERE gradeid='$id'
	LIMIT 1";
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    $num = mysql_num_rows($result);

    $grade_id = $row["gradeid"];
    $grade_name = $row["gradename"];

    $grade_name = stripslashes($grade_name);

    return $grade_name;
}
function getfullname($id) {
    $result = mysql_query("select lastname,firstname,middlename from nsemem where id = '$id'");
    $row = mysql_fetch_array($result);
    $lastname = $row['lastname'];
    $firstname = $row['firstname'];
    $middlename = $row['middlename'];

    $fullname = "$lastname $firstname $middlename";
    return $fullname;

}
/**
 *
 * set membership dues for newly created members
 */
function insertNewMemberDues($nseregno) {
    $timezone = "Africa/Lagos";
    date_default_timezone_set($timezone);
    //insert query starts here
    //echo "INSERT INTO payitem_amount(nseregno) VALUES($nseregno)";
    mysql_query("INSERT INTO payitem_amount(`nseregno`) VALUES('$nseregno')");
    //get the members grade
    $query = "SELECT * FROM nsemem WHERE nseregno = '$nseregno' AND nseregno != 'new'";
    $result =  mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $grade = $row['grade'];
    $firstdegdate = $row['firstdegdate'];


    //get the current year
    $year = getCurrentYear();
    $query_payitem  = "SELECT * FROM payitem";
    $result1 = mysql_query($query_payitem);
    while ($row1 = mysql_fetch_array($result1)) {
        $id = $row1['id'];
        $fieldname = $row1['name'];
        $query = "SELECT * FROM paymentperyear WHERE grade_id = '$grade' AND pay_year = '$year' AND payitem_id = '$id'";
        $result = mysql_query($query);
        $row = mysql_fetch_array($result);
        $payitem_id = $row['payitem_id'];
        $grade_id = $row['grade_id'];
        $pay_year = $row['pay_year'];
        $general_amount = $row['general_amount'];
        $grad_amount1 = $row['grad_amount1'];
        $grad_amount2 = $row['grad_amount2'];
        $grad_amount3 = $row['grad_amount3'];
        // if it is Abuja NEC levy then use teh grad_amount
        if($payitem_id == 3){
            $today = date("Y-m-d");
            $query_diff = "SELECT DATEDIFF('$today','$firstdegdate') AS grad_diff";
            //echo $query_diff;
            $result_diff = mysql_query($query_diff);
            $row_diff = mysql_fetch_array($result_diff);
            $grad_diff = $row_diff['grad_diff'] / 365;
           // echo "Grad diff = $grad_diff <br>";
            if($grad_diff < 5 ){
                $general_amount = $grad_amount1;
            }
            elseif($grad_diff < 10 ){
                $general_amount = $grad_amount2;
            }
            else{
                $general_amount = $grad_amount3;
            }
        }
        $query_update = "UPDATE payitem_amount SET `$fieldname` = '$general_amount' WHERE nseregno = '$nseregno'";
        //echo "$query_update <br>";
         $query_update = mysql_query($query_update) or die(mysql_error());
     }
}
function UpdateMembersPayment($nseregno) {
    //mysql_query("insert into payitem_amount_new(nseregno) values('$nseregno')");
    $query = "SELECT grade FROM nsemem WHERE nseregno  = '$nseregno'";
    $result =  mysql_query($query);
    $row = mysql_fetch_array($result);
    $grade = $row['grade'];
    $year = getCurrentYear();
    $query = "SELECT p.payitem_id, p.general_amount,i.name FROM paymentperyear p, payitem i WHERE p.pay_year = '$year' AND p.grade_id = '$grade' AND p.payitem_id = i.id AND i.onetime = 0 AND i.publish != 0";
    //echo $query;
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result)) {
        $name = $row['name'];
        $payitem_id =  $row['payitem_id'];
        $general_amount = $row['general_amount'];
        $q_update = "UPDATE payitem_amount_new SET `$name` = '$general_amount' WHERE nseregno = '$nseregno' ";
        //echo "$q_update<br>";

        mysql_query($q_update) or die(mysql_error());
    }
    calculatePreviousOutstanding($nseregno);
}
function calculatePreviousOutstanding($nseregno) {
    $myprev_out = 0;
    $query1 = "SELECT * FROM payitem WHERE onetime = '0' AND publish = 1 AND id != 8";
    $result1 = mysql_query($query1);
    while($row1 = mysql_fetch_array($result1)) {
        $name =  $row1["name"];

        $query = "SELECT `$name` FROM payitem_amount WHERE nseregno = '$nseregno'";
        //echo $query;
        $result =  mysql_query($query) or die(mysql_errno());
        $row = mysql_fetch_array($result);
        $amount = $row["$name"];
       // echo "$name = $amount <br>";
        $myprev_out += $amount;
    }
    //deduct advanced payment from the previous outstanding
    $query2 = "SELECT * FROM payitem WHERE id = 8";
    $result2 = mysql_query($query2);
    $row2 = mysql_fetch_array($result2);
    $name2 = $row2["name"];
    $query = "SELECT `$name2` FROM payitem_amount WHERE nseregno = '$nseregno'";
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    $d_advance = $row["$name2"];
    //echo "$name2 = $d_advance <br>";
//advance pay is saved as negative so add it(in otherwords subtract it)
    $myprev_out = $myprev_out + $d_advance;
//echo "newprevious = $myprev_out";
    // if the difference is less than 0 make previous outstanding 0 and put the rest on advanced payment
    if($myprev_out < 0) {

        $d_advance = $myprev_out ;
        $myprev_out = 0;
        //echo $d_advance;
    }

    $query_update = "update payitem_amount_new set prev_out = '$myprev_out', advanced_pay ='$d_advance' WHERE nseregno =  '$nseregno'";
//echo "$query_update<br>";
 mysql_query($query_update);
}

function spreadAdvancedPay(){
    $query = "SELECT * FROM payitem_amount_new WHERE advanced_pay < 0 LIMIT 1";
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result)){
        $nseregno = $row['nseregno'];
        $annualsub = $row['annualsub'];
        $benevolentfund = $row['benevolentfund'];
        $internationallevy = $row['internationallevy'];
        $prev_out = $row['prev_out'];
        $advanced_pay = $row['advanced_pay'];
        $myadvpay = $advanced_pay;
        if($prev_out > 0 && $myadvpay < 0){
            $prev_out = $prev_out + $myadvpay;
            if($prev_out < 0){
                $myadvpay = $prev_out;
                $prev_out = 0;
                //echo "$myadvpay<br>";

            }
            else{ $myadvpay = 0; }
        }
        if($annualsub > 0 && $myadvpay < 0){
            $annualsub = $annualsub + $myadvpay;
            if($annualsub < 0){
                $myadvpay = $annualsub;
                $annualsub = 0;
                //echo "$myadvpay<br>";

            }else{ $myadvpay = 0; }
        }
        if($benevolentfund > 0 && $myadvpay < 0){
            $benevolentfund = $benevolentfund + $myadvpay;
            if($benevolentfund < 0){
                $myadvpay = $benevolentfund;
                $benevolentfund = 0;
                //echo "$myadvpay<br>";

            }else{ $myadvpay = 0; }
        }
        if($internationallevy > 0 && $myadvpay < 0){
            $internationallevy = $internationallevy + $myadvpay;
            if($internationallevy < 0){
                $myadvpay = $internationallevy;
                $internationallevy = 0;
               // echo "$myadvpay<br>";

            }else{ $myadvpay = 0; }
        }
       echo("UPDATE payitem_amount_new SET annualsub = $annualsub, benevolentfund = $benevolentfund,
        internationallevy = '$internationallevy',prev_out = '$prev_out', advanced_pay = '$myadvpay' WHERE nseregno = '$nseregno';<br>");
    }
   
}
?>