芝麻web文件管理V1.00

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

<?php

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

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

public function Save($Warehouse)
    {
        // print_r($Warehouse);
        // die;

if (empty($Warehouse['Id']))
        {

// Set Third Leavel
            $account_no1='';
            $ThirdLevel_AccountNo = $this->select_query("select IFNULL(MAX(AccountNo), 0) as account_no from ThirdLevel where Headid = '2'");
            if ($ThirdLevel_AccountNo[0]['account_no'] == 0)
            {
                $account_no1 = "2100001";
            }
            else
            {
                $account_no1 = $ThirdLevel_AccountNo[0]['account_no'] + 1;
            }   
            $Warehouse_AccountNo = $account_no1;

// isert third leavel
            $q = "Insert into ThirdLevel (AccountNo, Headid, SubHeadid, SecondHeadid, AccountTitle, AccountType, Dr, Cr) VALUES (".$account_no1. ",2,2001,2000002,N'".$Warehouse['Name']."','Warehouse',0,0)";        
            if (mysqli_query($this->con, $q)) {
                $q2 = "INSERT INTO warehouse (AccountNo,Name, PropertyStatus, Phone, Address, Cnic) VALUES ('".$Warehouse_AccountNo."','".$Warehouse['Name']."', '".$Warehouse['PropertyStatus']."', '".$Warehouse['Phone']."', '".$Warehouse['Address']."', '".$Warehouse['Cnic']."')";
                if (mysqli_query($this->con, $q2)) {
                    return 'Success';
                }   else{
                    return "Error Code [321] : " . mysqli_error($this->con);
                }
            } else {
                return "Error Code [132]: " . mysqli_error($this->con);
            }
        }
        else
        {
            $q2 = "UPDATE `socialsolargreen`.`warehouse` SET `Name`='".$Warehouse['Name']."', `PropertyStatus`='".$Warehouse['PropertyStatus']."', `Phone`='".$Warehouse['Phone']."', `Address`='".$Warehouse['Address']."', `Cnic`='".$Warehouse['Cnic']."' WHERE  `Id`='".$Warehouse['Id']."'";
            if (mysqli_query($this->con, $q2)) {
                // return json_encode($Warehouse);
                return 'Success';
            }   else{
                return "Error Code [421] : " . mysqli_error($this->con);
            }
        }
    }

public function Edit($Id = ''){
        if(!empty($Id)){            
            $Warehouse = "select * from Warehouse Where id = $Id";
            $d = mysqli_query($this->con, $Warehouse);
            // 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;
        $Warehouse = "Delete from Warehouse where Id = $AccountNo";
        if (mysqli_query($this->con, $Warehouse)) {
            return 'Warehouse Deleted Success';
        }   else{
            return "Error Code [245] : " . mysqli_error($this->con);
        }
    }

}