<?php
    include"./dbconnect.php";
    
    if(isset($_GET['is_decimal']) && $_GET['is_decimal'] != '' && isset($_GET['school_code']) && $_GET['school_code'] != '') {
        $schoolCode = $_GET['school_code'];
        $sel_school = mysqli_query($con, "select * from schools where schoolCode='$schoolCode'");
        $main_username = '';
        $main_password = '';
        $main_dbname = '';
        while ($row_school = mysqli_fetch_array($sel_school)) {
            $main_username = $row_school['dbUsernameFees'];
            $main_password = $row_school['dbPassword'];
            $main_dbname = $row_school['dbFees'];
        }
        $school_db_con = mysqli_connect("localhost",$main_username,$main_password,$main_dbname);
        if($school_db_con) {
            if($_GET['is_decimal'] == "1") {
                
                mysqli_query($school_db_con, "ALTER TABLE `stud_basic2` CHANGE `Total_Amount` `Total_Amount` DECIMAL(10,2) NOT NULL, CHANGE `Paid` `Paid` DECIMAL(10,2) NOT NULL, CHANGE `Balance` `Balance` DECIMAL(10,2) NOT NULL, CHANGE `discount` `discount` DECIMAL(10,2) NOT NULL;");
                
                mysqli_query($school_db_con, "ALTER TABLE `paid_fees` CHANGE `Fine_Amount` `Fine_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` DECIMAL(10,2) NULL DEFAULT NULL;");
                
                mysqli_query($school_db_con, "ALTER TABLE `paid_fees_delete` CHANGE `Fine_Amount` `Fine_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` DECIMAL(10,2) NULL DEFAULT NULL;");
                
                echo"The school now accepts decimal values in the fees section."; exit;
            }
            else {
                
                mysqli_query($school_db_con, "ALTER TABLE `stud_basic2` CHANGE `Total_Amount` `Total_Amount` BIGINT NOT NULL, CHANGE `Paid` `Paid` BIGINT NOT NULL, CHANGE `Balance` `Balance` BIGINT NOT NULL, CHANGE `discount` `discount` BIGINT NOT NULL;");
                
                mysqli_query($school_db_con, "ALTER TABLE `paid_fees` CHANGE `Fine_Amount` `Fine_Amount` INT NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` INT NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` INT NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` INT NULL DEFAULT NULL;");
                
                mysqli_query($school_db_con, "ALTER TABLE `paid_fees_delete` CHANGE `Fine_Amount` `Fine_Amount` INT NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` INT NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` INT NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` INT NULL DEFAULT NULL;");
                
                echo"The school no longer accepts decimal values in the fees section."; exit;
            }
        }
        else {
            echo"Unable to connect school database."; exit;
        }
    }
    else {
        echo"Please include the `is_decimal` and `school_code` parameters in the URL."; exit;
    }
?>