芝麻web文件管理V1.00

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

<?php

include 'partial/db.php';
global $dbobj;
$dbobj = new db();

Class Cash_Payment extends db {

function cash_payment_list()
      {
        global $dbobj;
        $query= "SELECT * FROM TranscationDetails WHERE (Vtype = 'CPV') AND (Cr > 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 = 'CPV' AND (InvId='-1')";
          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 WHERE (AccountNo NOT IN (1100001, 4400001, 1100002, 5500001)) 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;
        }
 
        if(!empty($Acc_List) && !empty($V_No)){
          $result = $V_No;
          $result['Acc_List'] = $Acc_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 = "(Cash)";
                }

$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) VALUES ('".$TranscationDetails_Transid."',N'".$TranscationDetails['narr'][$i]."','".$TranscationDetails['TranscationDetails_TransDate']."','".$TranscationDetails['account_no'][$i]."','".$TranscationDetails['Dr'][$i]."','".$TranscationDetails['Cr'][$i]."','-1','CPV','".$TranscationDetails['V_No']."')";
                  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) VALUES ('" .$TranscationDetails_Transid. "','".$paidforcash."','".$TranscationDetails['TranscationDetails_TransDate']."','1100001',0,'".$TranscationDetails['TranscationDetails_Cr']."','-1','CPV','".$TranscationDetails['V_No']."')";
                  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
          {
              $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 = "(Cash)";
                }

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

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

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

}
          die;
          
      }

public function Edit($V_No)
        {
            $TranscationsList_query = "SELECT TranscationDetails.Id, TranscationDetails.Transid, TranscationDetails.TransDes, TranscationDetails.TransDate, TranscationDetails.AccountNo, TranscationDetails.Dr, TranscationDetails.Cr, TranscationDetails.Invid, TranscationDetails.Vtype, TranscationDetails.cle_date, TranscationDetails.check_no, TranscationDetails.Bank, TranscationDetails.BankDes, TranscationDetails.Remarks, TranscationDetails.BankAcc, TranscationDetails.V_No, ThirdLevel.AccountTitle FROM TranscationDetails INNER JOIN ThirdLevel ON TranscationDetails.AccountNo = ThirdLevel.AccountNo WHERE  (TranscationDetails.Vtype = 'CPV') AND (TranscationDetails.V_No = '".$V_No."') AND (TranscationDetails.Dr > 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 = 'CPV') AND (Cr > 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 WHERE (AccountNo NOT IN (1100001, 4400001, 1100002, 5500001)) 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;
              }
            $VoucherVM = array
            (
                'TranscationDetails' => $Transcations,
                'Accounts' => $Acc_List,
                'TranscationList' => $TranscationsList,
            );
            return $VoucherVM;
        }
     
}