芝麻web文件管理V1.00

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

<?php

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

public function Product_List()
    {
        $ProductTypes_query = "SELECT * FROM productstype ";
        if ($ProductTypes_query_result = mysqli_query($this->con, $ProductTypes_query)) {
            while($row = mysqli_fetch_assoc($ProductTypes_query_result)){
              $ProductTypes[] = $row;
            }
            return $ProductTypes;
            die;
        }   else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }
    }

public function Search($cat, $StDate, $EnDate)
    {
        // $ProductTypes_query = "SELECT * FROM productstype ";
        // if ($ProductTypes_query_result = mysqli_query($this->con, $ProductTypes_query)) {
        //     while($row = mysqli_fetch_assoc($ProductTypes_query_result)){
        //       $Typr[] = $row;
        //     }
        // }   else{
        //     return "Error Code [721] : " . mysqli_error($this->con);
        //     die;
        // }

// if (date('Y', strtotime($StDate)) != "1" && date('Y', strtotime($EnDate)) != "1") 
        // {
        //     $StockList = new Repo<StockTable>().GetAllData("SELECT ISNULL(SUM(Stock.DQty), 0) AS PDQty, ISNULL(SUM(Stock.FQty), 0) + Products.OpStock AS PFQty, ISNULL(SUM(Stock.WQty), 0) AS PWQty,(SELECT ISNULL(SUM(DQty), 0) AS SDQty FROM Stock AS Stock_1 WHERE (PId = Stock.PId) AND (VType = 'SINV')) AS SDQty, (SELECT ISNULL(SUM(FQty), 0) AS SFQty FROM Stock AS Stock_2 WHERE (PId = Stock.PId) AND (VType = 'SINV')) AS SFQty, (SELECT ISNULL(SUM(WQty), 0) AS SWQty FROM Stock AS Stock_3 WHERE (PId = Stock.PId) AND (VType = 'SINV')) AS SWQty, Products.Name AS PName FROM Stock INNER JOIN Products ON Stock.PId = Products.Id WHERE (Stock.Date BETWEEN '"+ StDate.ToString("dd-MMM-yyyy") +"' AND '"+ EnDate.ToString("dd-MMM-yyyy") + "') AND (Stock.VType = 'PINV') GROUP BY Products.OpStock, Products.Name, Stock.PId").ToList();
        //     echo 'dsafdfsdfsdfsa';
        // }
        if (date('Y', strtotime($StDate)) != "1" && date('Y', strtotime($EnDate)) != "1" && $cat != 0) 
        {
            $StockList_query = "
                                SELECT 
                                    IFNULL(SUM(Stock.DQty), 0) AS PDQty,
                                    IFNULL(SUM(Stock.FQty), 0) + Products.OpStock AS PFQty,
                                    IFNULL(SUM(Stock.WQty), 0) AS PWQty,
                                    (SELECT IFNULL(SUM(DQty), 0) AS SDQty FROM Stock AS Stock_1 WHERE (PId = Stock.PId) AND (VType = 'SINV')) AS SDQty,
                                    (SELECT IFNULL(SUM(FQty), 0) AS SFQty FROM Stock AS Stock_2 WHERE (PId = Stock.PId) AND (VType = 'SINV')) AS SFQty, 
                                    (SELECT IFNULL(SUM(WQty), 0) AS SWQty FROM Stock AS Stock_3 WHERE (PId = Stock.PId) AND (VType = 'SINV')) AS SWQty,
                                    Products.Name AS PName 
                                FROM Stock 
                                INNER JOIN Products ON Stock.PId = Products.Id 
                                WHERE 
                                (Stock.Date BETWEEN '".$StDate."' AND '".$EnDate."') 
                                AND (Stock.TypeId = '1') 
                                AND (Stock.VType = 'PINV') 
                                GROUP BY Products.OpStock, Products.Name, Stock.PId                
                                ";
            // print_r($StockList_query);
            // die;
            if ($StockList_query_result = mysqli_query($this->con, $StockList_query)) {
                while($row = mysqli_fetch_assoc($StockList_query_result)){
                    $StockList[] = $row;
                }
            }   else{
                return "Error Code [721] : " . mysqli_error($this->con);
                die;
            }
            // echo 'cat';
        }
        // print_r($StockList);
        // die;
        // ViewBag.Type = Typr;
        // ViewBag.cat = cat;
        // ViewBag.StDate = StDate.ToString("yyyy-MM-dd");
        // ViewBag.EnDate = EnDate.ToString("yyyy-MM-dd");
        return $StockList;
    }
    
}
?>