芝麻web文件管理V1.00

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

<?php

include 'partial/db.php';
global $dbobj;
$dbobj = new db();
class Bank_Receipt extends db {

function Bank_Receipt_list()
     {
          global $dbobj;
          $query= "SELECT * FROM TranscationDetails WHERE (Vtype = 'BRV') AND (Dr > 0) ORDER BY V_No DESC";
          $data = mysqli_query($dbobj->con, $query);
               return $data;
     }

public function Create()
      {
          $TranscationDetails_query = "select IFNULL(Max(TranscationDetails.V_No),0)+1  AS v_no from TranscationDetails where VType = 'BRV'";
          if ($TranscationDetails_query_result = mysqli_query($this->con, $TranscationDetails_query)) {
              while($row = mysqli_fetch_assoc($TranscationDetails_query_result)){
                $V_No = $row;
              }
          }   else{
              return "Error Code [321] : " . mysqli_error($this->con);
              die;
          }
          $Acc_List_query = "SELECT * FROM ThirdLevel ORDER BY AccountNo DESC ";
          if ($Acc_List_query_result = mysqli_query($this->con, $Acc_List_query)) {
               while($Acc_List_row = mysqli_fetch_assoc($Acc_List_query_result)){
               $Acc_List[] = $Acc_List_row;
               }
          }   else{
               return "Error Code [321] : " . mysqli_error($this->con);
               die;
          }
 
          $Bank_List_query = "SELECT * FROM  ThirdLevel WHERE (SecondHeadid = '1000003') ORDER BY AccountNo DESC";
          if ($Bank_List_query_result = mysqli_query($this->con, $Bank_List_query)) {
               while($Bank_List_row = mysqli_fetch_assoc($Bank_List_query_result)){
               $Bank_List[] = $Bank_List_row;
               }
          }   else{
               return "Error Code [321] : " . mysqli_error($this->con);
               die;
          }

if(!empty($Acc_List) && !empty($V_No)){
          $result = $V_No;
          $result['Acc_List'] = $Acc_List;
          $result['Bank_List'] = $Bank_List;
        }else{
          $result = array('Result Not Found');
        }
        return $result;
        die;
     }

public Function Save($TranscationDetails = '')
      {

//    echo '<pre>';
     //      print_r($TranscationDetails);
     //    echo '</pre>';
     //      die;

if(empty($TranscationDetails['TranscationDetails_Id']))
          { 
              $TranscationDetails_Transid_query = "select IFNULL(Max(Transid),0)+1 as Transid from TranscationDetails";
                if ($TranscationDetails_Transid_query_result = mysqli_query($this->con, $TranscationDetails_Transid_query)) {
                    while($row = mysqli_fetch_assoc($TranscationDetails_Transid_query_result)){
                      $TranscationDetails_Transid = $row['Transid'];
                    }
                }   else{
                    return "Error Code [321] : " . mysqli_error($this->con);
                    die;
                }
                // print_r($TranscationDetails_Transid);
                // die;
                if(!empty($TranscationDetails['TranscationDetails_TransDes'])){
                  $paidforcash = $TranscationDetails['TranscationDetails_TransDes'];
                }else{
                  $paidforcash = "(Bank)";
                }

$accounts_insertion_loop = [];
              for ($i = 0; $i < count($TranscationDetails['account_no']); $i++)
              {
                  $query = "INSERT INTO TranscationDetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype,V_No, Comid,BankDes,check_no,cle_date,BankAcc) VALUES ('".$TranscationDetails_Transid."',N'".$TranscationDetails['narr'][$i]."','".$TranscationDetails['TranscationDetails_TransDate']."','".$TranscationDetails['account_no'][$i]."','".$TranscationDetails['Dr'][$i]."','".$TranscationDetails['Cr'][$i]."','-1','BRV','".$TranscationDetails['V_No']."','0','".$TranscationDetails['narr'][$i]."','".$TranscationDetails['c_no'][$i]."','".$TranscationDetails['cl_date'][$i]."','".$TranscationDetails['TranscationDetails_AccountNo']."')";
                  if (mysqli_query($this->con, $query)) {
                  }   else{
                    $accounts_insertion_loop[] = "Error Code [321] : " . mysqli_error($this->con);
                  }
              }

if(empty($accounts_insertion_loop)){
                $query = "INSERT INTO TranscationDetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype,V_No, Comid) VALUES ('" .$TranscationDetails_Transid. "','".$paidforcash."','".$TranscationDetails['TranscationDetails_TransDate']."','".$TranscationDetails['TranscationDetails_AccountNo']."','".$TranscationDetails['TranscationDetails_Dr']."',0,'-1','BRV','".$TranscationDetails['V_No']."','0')";
                  if (mysqli_query($this->con, $query)) {
                  }   else{
                    $accounts_insertion_loop[] = "Error Code [321] : " . mysqli_error($this->con);
                  }
              }

// print_r($accounts_insertion_loop);
              // die;

if(empty($accounts_insertion_loop)){
                return "Voucher Created Successfully";
              }else{
                return ' Error : ' .json_encode($accounts_insertion_loop);
              }
          }
          else
          {
               // print_r($TranscationDetails['TranscationDetails_Id']);
          //     $TranscationDetails_Transid_query = "select IFNULL(Max(Transid),0)+1 as Transid from TranscationDetails";
          //       if ($TranscationDetails_Transid_query_result = mysqli_query($this->con, $TranscationDetails_Transid_query)) {
          //           while($row = mysqli_fetch_assoc($TranscationDetails_Transid_query_result)){
          //             $TranscationDetails_Transid = $row['Transid'];
          //           }
          //       }   else{
          //           return "Error Code [321] : " . mysqli_error($this->con);
          //           die;
          //       }
                // print_r($TranscationDetails_Transid);
                // die;
                if(!empty($TranscationDetails['TranscationDetails_TransDes'])){
                  $paidforcash = $TranscationDetails['TranscationDetails_TransDes'];
                }else{
                  $paidforcash = "(Bank)";
                }

$del_query = "DELETE FROM TranscationDetails WHERE Vtype='BRV' AND V_No='".$TranscationDetails['V_No']."'";
              if (mysqli_query($this->con, $del_query)) {
              
              } else{
                  return "Error Code [321] : " . mysqli_error($this->con);
                  die;
              }

$accounts_insertion_loop = [];
              for ($i = 0; $i < count($TranscationDetails['account_no']); $i++)
              {
                    $query = "INSERT INTO TranscationDetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype,V_No, Comid,BankDes,check_no,cle_date,BankAcc) VALUES ('".$TranscationDetails['TranscationDetails_Id']."',N'".$TranscationDetails['narr'][$i]."','".$TranscationDetails['TranscationDetails_TransDate']."','".$TranscationDetails['account_no'][$i]."','".$TranscationDetails['Dr'][$i]."','".$TranscationDetails['Cr'][$i]."','-1','BRV','".$TranscationDetails['V_No']."','0','".$TranscationDetails['narr'][$i]."','".$TranscationDetails['c_no'][$i]."','".$TranscationDetails['cl_date'][$i]."','".$TranscationDetails['TranscationDetails_AccountNo']."')";
                    if (mysqli_query($this->con, $query)) {
                    }   else{
                         $accounts_insertion_loop[] = "Error Code [321] : " . mysqli_error($this->con);
                    }
              }

if(empty($accounts_insertion_loop)){
                    $query = "INSERT INTO TranscationDetails (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype,V_No, Comid) VALUES ('" .$TranscationDetails['TranscationDetails_Id']. "','".$paidforcash."','".$TranscationDetails['TranscationDetails_TransDate']."','".$TranscationDetails['TranscationDetails_AccountNo']."','".$TranscationDetails['TranscationDetails_Dr']."',0,'-1','BRV','".$TranscationDetails['V_No']."','0')";
                    if (mysqli_query($this->con, $query)) {
                    }   else{
                         $accounts_insertion_loop[] = "Error Code [321] : " . mysqli_error($this->con);
                    }
              }

// print_r($accounts_insertion_loop);
              // die;

if(empty($accounts_insertion_loop)){
                return "Voucher Update Successfully";
              }else{
                return ' Error : ' .json_encode($accounts_insertion_loop);
              }

}
          die;
          
      }

public function Edit($V_No)
        {
            $TranscationsList_query = "SELECT TranscationDetails.*, ThirdLevel.AccountTitle FROM TranscationDetails INNER JOIN ThirdLevel ON TranscationDetails.AccountNo = ThirdLevel.AccountNo WHERE (TranscationDetails.Vtype = 'BRV') AND (TranscationDetails.V_No = '".$V_No."') AND (TranscationDetails.Cr > 0)";
              if ($TranscationsList_query_result = mysqli_query($this->con, $TranscationsList_query)) {
                  while($row = mysqli_fetch_assoc($TranscationsList_query_result)){
                    $TranscationsList[] = $row;
                  }
              }   else{
                  return "Error Code [321] : " . mysqli_error($this->con);
                  die;
              }

$Transcations_query = "SELECT * FROM TranscationDetails WHERE(V_No = '".$V_No."') AND (Vtype = 'BRV') AND (Dr > 0)";
              if ($Transcations_query_result = mysqli_query($this->con, $Transcations_query)) {
                  while($row = mysqli_fetch_assoc($Transcations_query_result)){
                    $Transcations = $row;
                  }
              }   else{
                  return "Error Code [321] : " . mysqli_error($this->con);
                  die;
              }
            $Acc_List_query = "SELECT * FROM ThirdLevel ORDER BY AccountNo DESC ";
              if ($Acc_List_query_result = mysqli_query($this->con, $Acc_List_query)) {
                  while($row = mysqli_fetch_assoc($Acc_List_query_result)){
                    $Acc_List[] = $row;
                  }
              }   else{
                  return "Error Code [321] : " . mysqli_error($this->con);
                  die;
              }
              $Bank_List_query = "SELECT * FROM  ThirdLevel WHERE (SecondHeadid = '1000003') ORDER BY AccountNo DESC";
              if ($Bank_List_query_result = mysqli_query($this->con, $Bank_List_query)) {
                  while($row = mysqli_fetch_assoc($Bank_List_query_result)){
                    $Bank_List[] = $row;
                  }
              }else{
                  return "Error Code [321] : " . mysqli_error($this->con);
                  die;
              }
            $VoucherVM = array
            (
                'TranscationDetails' => $Transcations,
                'Accounts' => $Acc_List,
                'TranscationList' => $TranscationsList,
                'Bank_List' => $Bank_List,
            );
            return $VoucherVM;
        }
}
?>