芝麻web文件管理V1.00

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

<?php

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

public function Search($StDate ,$EnDate)
        {
            $opening_bal_query = "SELECT IFNULL(SUM(TranscationDetails.Dr), 0) AS Dr, ThirdLevel.SecondHeadid, Secondlevel.AccountTitle FROM TranscationDetails INNER JOIN ThirdLevel ON TranscationDetails.AccountNo = ThirdLevel.AccountNo INNER JOIN Secondlevel ON ThirdLevel.SecondHeadid = Secondlevel.AccountNo WHERE(ThirdLevel.SubHeadid = 5001) AND (TranscationDetails.TransDate BETWEEN '".$StDate."' AND '".$EnDate."') GROUP BY ThirdLevel.SecondHeadid, Secondlevel.AccountTitle";
            if ($returndata = mysqli_query($this->con, $opening_bal_query)) {
                $return = array();
                if(mysqli_num_rows($returndata) > 0){
                    while ($row = mysqli_fetch_assoc($returndata)) {
                        $return[] = $row;
                    }
                }else{
                    $return[] = "Record not Found";
                }
                return $return;
                die;
            }   else{
                return "Error Code [246] : " . mysqli_error($this->con);
                die;
            }
        }
    public function Details($StDate ,$EnDate ,$acc)
        {
            $opening_bal_query = "SELECT IFNULL(SUM(TranscationDetails.Dr), 0) AS Dr, ThirdLevel.AccountNo, ThirdLevel.AccountTitle AS AccountTitle FROM TranscationDetails INNER JOIN ThirdLevel ON TranscationDetails.AccountNo = ThirdLevel.AccountNo INNER JOIN Secondlevel ON ThirdLevel.SecondHeadid = Secondlevel.AccountNo WHERE(TranscationDetails.TransDate BETWEEN '".$StDate."' AND '".$EnDate."') AND (Secondlevel.AccountNo = '".$acc."') GROUP BY ThirdLevel.AccountNo, ThirdLevel.AccountTitle";
            if ($returndata = mysqli_query($this->con, $opening_bal_query)) {
                $return = array();
                if(mysqli_num_rows($returndata) > 0){
                    while ($row = mysqli_fetch_assoc($returndata)) {
                        $return[] = $row;
                    }
                }else{
                    $return[] = "Record not Found";
                }
                return $return;
                die;
            }   else{
                return "Error Code [246] : " . mysqli_error($this->con);
                die;
            }
        }
}