芝麻web文件管理V1.00

编辑当前文件:/home/sditechnicalteam/socialsolargreens.pk/controller/designation_controller.php

<?php

include 'partial/db.php';
global $dbobj;
class Designation extends db {

public function DesignationList()
    {
            $Designation = "select * from Designation ORDER BY id DESC LIMIT 250";
            $data = mysqli_query($this->con,$Designation); 
            return $data;
    }

public function Save($Designation)
    {
        if (empty($Designation['Id']))
        {   
            $q = "INSERT INTO `socialsolargreen`.`designation` (`Name`, `BasicSalary`, `MedicalAllowance`, `HouseRent`, `Total`) VALUES ('".$Designation['Name']."', '".$Designation['BasicSalary']."', '".$Designation['MedicalAllowance']."', '".$Designation['HouseRent']."', '".$Designation['Total']."')";
            if (mysqli_query($this->con, $q)) {
                return 'Success';
            }   else{
                return "Error Code [321] : " . mysqli_error($this->con);
            }
        }
        else
        {
            $q2 = "UPDATE `socialsolargreen`.`designation` SET `Name`='".$Designation['Name']."', `BasicSalary`='".$Designation['BasicSalary']."', `MedicalAllowance`='".$Designation['MedicalAllowance']."', `HouseRent`='".$Designation['HouseRent']."', `Total`='".$Designation['Total']."' WHERE  `Id`='".$Designation['Id']."'";
            if (mysqli_query($this->con, $q2)) {
                // return json_encode($Designation);
                return 'Success';
            }   else{
                return "Error Code [421] : " . mysqli_error($this->con);
            }
        }
    }

public function Edit($Id = ''){
        if(!empty($Id)){            
            $Designation = "select * from Designation Where id = $Id";
            $d = mysqli_query($this->con, $Designation);
            // print_r($d);
            if ($d->num_rows > 0) {
                $data = mysqli_fetch_assoc($d);
                return $data;
            }   else{
                return "Error Code [521] : " . mysqli_error($this->con);
            }
        }
    }

public function Delete($AccountNo = ''){
        global $dbobj;
        $Designation = "Delete from Designation where Id = $AccountNo";
        if (mysqli_query($this->con, $Designation)) {
            return 'Designation Deleted Success';
        }   else{
            return "Error Code [245] : " . mysqli_error($this->con);
        }
    }

}