One Hat Cyber Team

View File Name : change_current_year.php

<?php
set_time_limit(1200);
$connect = mysql_connect("209.237.150.136", "57513_nseorgng1", "nse11111") or die ("Can not conect, check your server connection.");
mysql_select_db ("57513_nse");
//$query1 = "SELECT max_id FROM roll_max ORDER BY id DESC LIMIT 1";
//$result = mysql_query($query1);
//$row1 = mysql_fetch_array($result);
//$max_id = $row1['max_id'];
//$query = "SELECT * FROM nsemem WHERE nseregno != 'new' AND id > '$max_id' ORDER BY id LIMIT 500";
//$result = mysql_query($query);
//while($row = mysql_fetch_array($result)){
//    $nseregno = $row['nseregno'];
//    $id = $row['id'];
//    if(!empty($nseregno)){
//        $i++;
//        echo "$i ---";
//        echo "$nseregno<br>";
//        UpdateMembersPayment($nseregno);        
//    }
//}
//mysql_query("INSERT INTO roll_max(max_id) VALUES('$id')");

//Comment out the previous codes and remove this comment after after all updates has been done to spread advanced fees
//spreadAdvancedPay();
$query1 = "SELECT * FROM nsemem WHERE grade = 'member'";
$result1 = mysql_query($query1);
while($row = mysql_fetch_array($result1)){
	$nseregno = $row['nseregno'];
	$id = $row['id'];
 if(!empty($nseregno)){
        $i++;
        echo "$i ---";
        echo "$nseregno<br>";
       // UpdateMembersPayment($nseregno);        
   }
}
function UpdateMembersPayment($nseregno) {
    //mysql_query("insert into payitem_amount_new(nseregno) values('$nseregno')");
    //echo "am here";
    $query = "SELECT grade,lifeMember FROM nsemem WHERE nseregno  = '$nseregno'";
    $result =  mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    //$grade = $row['grade'];
    $grade = 4;
    $life = $row['lifeMember'];
    if($life != "-1"){
    $year = "2010";
    $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) or die(mysql_error());
    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' ";
        $q_update = "UPDATE payitem_amount SET `$name` = '$general_amount' WHERE nseregno = '$nseregno' ";
        echo "$q_update;<br>";

        //mysql_query($q_update) or die(mysql_error());
    }
    }else{
        //$q_update = "UPDATE payitem_amount_new SET benevolentfund = '250',internationallevy = '250' WHERE nseregno = '$nseregno'";
        $q_update = "UPDATE payitem_amount SET benevolentfund = '250',internationallevy = '250' 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_2010 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_2010 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'";
    $query_update = "update payitem_amount 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";
    $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>");
    }   
}
?>