芝麻web文件管理V1.00

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

<?php

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

public function LedgureList()
    {
            $Ledgure = "select * from Ledgure ORDER BY id DESC LIMIT 250";
            $data = mysqli_query($this->con,$Ledgure); 
            return $data;
    }
    public function thirdlevel_dropdown()
    {
        $query= "SELECT * FROM `socialsolargreen`.`thirdlevel` ";
        $qd = mysqli_query($this->con, $query);
        if(mysqli_num_rows($qd) > 0){
            $optoin = '';
            while($data = mysqli_fetch_assoc($qd)){
                $optoin .= '<option value="'.$data['AccountNo'].'">'.$data['AccountTitle'].'</option>';
            }
            return $optoin;
            die;
        }else{
            return '<option value="">Select</option>';
        }
        die;
    }
    public function Search($cat, $StDate, $EnDate)
    {
        $ThirdLevel_AccountNo = $cat;
                $opening_bal_query = "SELECT CASE WHEN HeadId IN (1,5) THEN IFNULL((Dr)-(Cr), 0) WHEN HeadId IN (2,3,4) THEN IFNULL((Cr)-(Dr), 0) END AS Opening FROM ThirdLevel WHERE (AccountNo = '".$ThirdLevel_AccountNo."')";
                    if ($opening_bal = mysqli_fetch_assoc(mysqli_query($this->con, $opening_bal_query))) {
                        // print_r($opening_bal['Opening']);
                    }   else{
                        return "Error Code [246] : " . mysqli_error($this->con);
                        die;
                    }
                $opening_bal1_query = "SELECT  case When AccountNo Like '1%' OR AccountNo LIKE '5%' Then IFNULL(sum(Dr) - sum(Cr),0) 
                                            WHEN AccountNo Like '2%' OR AccountNo LIKE '3%' OR AccountNo LIKE '4%' Then IFNULL(sum(Cr) - sum(Dr),0) End
                                            As Opening FROM transcationdetails 
                                            WHERE AccountNo = '".$ThirdLevel_AccountNo."' and TransDate < '".$StDate."' group by AccountNo ";
                    if ($opening_bal1_exe = mysqli_query($this->con, $opening_bal1_query)) {
                        // it return number of rows in the table.
                        $row = mysqli_num_rows($opening_bal1_exe);
                        if($row > 0){
                            $opening_bal1 = mysqli_fetch_assoc($opening_bal1_exe);
                        }else{
                            $opening_bal1['Opening'] = '0';
                        }
                        // print_r($opening_bal1['Opening']);
                    }   else{
                        return "Error Code [247] : " . mysqli_error($this->con);
                        die;
                    }
                $ThirdLevel_AccountTitle_query = "SELECT AccountTitle FROM ThirdLevel WHERE (AccountNo = '".$ThirdLevel_AccountNo."') ";
                    if ($ThirdLevel_AccountTitle = mysqli_fetch_assoc(mysqli_query($this->con, $ThirdLevel_AccountTitle_query))) {
                        // print_r($ThirdLevel_AccountTitle['AccountTitle']);
                    }   else{
                        return "Error Code [242] : " . mysqli_error($this->con);
                        die;
                    }
        if ($cat == 0)
        {
            $trans_list_query = "SELECT ThirdLevel.Headid, ThirdLevel.SubHeadid, ThirdLevel.AccountTitle, ThirdLevel.AccountType, TranscationDetails.TransDes, TranscationDetails.TransDate, TranscationDetails.Dr, TranscationDetails.Cr, TranscationDetails.Vtype, TranscationDetails.cle_date, TranscationDetails.check_no, TranscationDetails.Bank, TranscationDetails.BankDes, TranscationDetails.BankAcc, TranscationDetails.V_No, TranscationDetails.Transid, TranscationDetails.AccountNo, ThirdLevel.SecondHeadid FROM ThirdLevel INNER JOIN TranscationDetails ON ThirdLevel.AccountNo = TranscationDetails.AccountNo WHERE(TranscationDetails.TransDate BETWEEN '".$StDate."' AND '".$EnDate."')";
            if ($trans_list = mysqli_fetch_assoc(mysqli_query($this->con, $trans_list_query))) {
                //  print_r($trans_list);
            }   else{
                return "Error Code [257] : " . mysqli_error($this->con);
                die;
            }

}
        else if ($cat != 0 && $StDate != "1" && $EnDate != "1")
        {
            $trans_list_query = "SELECT ThirdLevel.Headid, ThirdLevel.SubHeadid, ThirdLevel.AccountTitle, ThirdLevel.AccountType, TranscationDetails.TransDes, TranscationDetails.TransDate, TranscationDetails.Dr, TranscationDetails.Cr, TranscationDetails.Vtype, TranscationDetails.cle_date, TranscationDetails.check_no, TranscationDetails.Bank, TranscationDetails.BankDes, TranscationDetails.BankAcc, TranscationDetails.V_No, TranscationDetails.Transid, TranscationDetails.AccountNo, ThirdLevel.SecondHeadid FROM ThirdLevel INNER JOIN TranscationDetails ON ThirdLevel.AccountNo = TranscationDetails.AccountNo WHERE(TranscationDetails.TransDate BETWEEN '".$StDate."' AND '".$EnDate."') AND (TranscationDetails.AccountNo = '".$ThirdLevel_AccountNo."')";
            if ($trans_list = mysqli_query($this->con, $trans_list_query)) {
                $trans_listdata = array();
                while ($row = mysqli_fetch_assoc($trans_list)) {
                    $trans_listdata[] = $row;
                }
                // print_r($trans_list);
                // echo date('Y', strtotime($StDate));
           }   else{
               return "Error Code [445] : " . mysqli_error($this->con);
               die;
           }

}
        else if (date('Y', strtotime($StDate)) != "1" && date('Y', strtotime($EnDate)) != "1")
        {
            $trans_list_query = "SELECT ThirdLevel.Headid, ThirdLevel.SubHeadid, ThirdLevel.AccountTitle, ThirdLevel.AccountType, TranscationDetails.TransDes, TranscationDetails.TransDate, TranscationDetails.Dr, TranscationDetails.Cr, TranscationDetails.Vtype, TranscationDetails.cle_date, TranscationDetails.check_no, TranscationDetails.Bank, TranscationDetails.BankDes, TranscationDetails.BankAcc, TranscationDetails.V_No, TranscationDetails.Transid, TranscationDetails.AccountNo, ThirdLevel.SecondHeadid FROM ThirdLevel INNER JOIN TranscationDetails ON ThirdLevel.AccountNo = TranscationDetails.AccountNo WHERE (TranscationDetails.AccountNo = '".$ThirdLevel_AccountNo."')";
            if ($trans_list = mysqli_fetch_assoc(mysqli_query($this->con, $trans_list_query))) {
                print_r($trans_list);
                // echo date('Y', strtotime($StDate));
           }   else{
               return "Error Code [345] : " . mysqli_error($this->con);
               die;
           }
        }
        $ViewBag_opbalance = $opening_bal['Opening'] + $opening_bal1['Opening'];
        // 'ThirdLevelList': Typr,
        $VM = array(
            'openBalance'=>$ViewBag_opbalance,
            'ThirdLevel' => $ThirdLevel_AccountTitle['AccountTitle'],
            'trans_list' => $trans_listdata,
            'StDate'     => $StDate,
            'EnDate'     => $EnDate
        );
        // ViewBag.cat = cat;
        return $VM;
    }
}