<?php
/**
 * Date: 11/9/17
 * Time: 5:28 PM
 */
defined('BASEPATH') OR exit('No direct script access allowed');

class DayBook_model extends CI_Model
{
    
    /*
     * day book update details
     * params:
     * created by kdk
     * */
    
    // get income expense type lists
    public function get_Income_Expense_typeState(){
        $this->db->select('t1.ListCode, t1.ListName');
        $this->db->from(''.PICK_LIST_DETAILS. ' as t1');
        $this->db->where('t1.ListGroup', 10);
        // $this->db->join('' . COURSE . ' as t2', 't2.UniversityID = t1.UniversityID', 'LEFT');
        $typeDetails = $this->db->get();
        $typeStateDetails = $typeDetails->result();
            // TypeName details
            $this->db->select('t2.TypeName, t2.TypeID, t2.ID');
            $this->db->from(''.INCOMEOUTCOMEMASTER. ' as t2');
            $this->db->where('t2.IsActive', 1);

            $typeNaDetails = $this->db->get();
            $typeNameDetails = $typeNaDetails->result();

        $results['typeNameStatus']      = true;
        $results['typeList'] = $typeStateDetails;
        $results['typeNameList'] = $typeNameDetails;
        return $results;
    }

    
    public function emp_day_book_AccessChk($arr) {
        $id = $arr['localUserID'];
        $sql1 = "SELECT t1.FinanceModuleAccess FROM ".STAFF." as t1 LEFT JOIN ".LOGIN." as t2 ON t2.StaffID = t1.StaffID WHERE t2.id = $id";
        // update branch to staff_branch table
        $dayBookAccDetails = $this->db->query($sql1);
        $dayBkAcesDetail = $dayBookAccDetails->result();
        $result['dayBkAccessChkStatus'] = true;
        $result['dayBkAccessChk_Value'] = $dayBkAcesDetail[0]->FinanceModuleAccess;
        // echo $result['dayBkAccessChk_Value'];exit();                                                                                                                                                                                     
        return $result;
    }

    // get the daybook details list
    public function get_Daybook_Details_List($reqData, $reqDataBy) {

        if($reqData['date'] != '' && $reqData['dateTo'] != '') {
        // $this->db->select('t1.*, t2.ListName, t3.TypeName');
        // $this->db->from(''.DAYBOOKMASTER. ' as t1');
        // $this->db->join('' . PICK_LIST_DETAILS . ' as t2', 't2.ListCode = t1.Name', 'LEFT');
        // $this->db->join('' . INCOMEOUTCOMEMASTER . ' as t3', 't3.ID = t1.Type', 'LEFT');
        
        $d = new DateTime($reqData['date']);
        $dTo = new DateTime($reqData['dateTo']);
        $fromDate = $d->format('Y-m-d');
        $toDate = $dTo->format('Y-m-d');
        $reqpayType = $reqDataBy['localBranchID'];

        $querys = "SELECT t1.ID as ORDER_ID, t1.*, t2.ListName, t3.TypeName , t5.Firstname as Approved_by_name ,
        t7.UniversityName as UniversityName, t6.CourseName as CourseName
        FROM ".DAYBOOKMASTER." as t1 
        LEFT JOIN ".PICK_LIST_DETAILS." as t2 ON t2.ListCode = t1.Name 
        LEFT JOIN ".INCOMEOUTCOMEMASTER." as t3 ON t3.ID = t1.Type 
        LEFT JOIN ".LOGIN." as t4 ON t4.ID = t1.Approval_By 
        LEFT JOIN ".STAFF." as t5 ON t5.StaffID = t4.StaffID
        LEFT JOIN ".COURSE." as t6 ON t6.CourseID = t1.CourseID
        LEFT JOIN ".UNIVERSITY." as t7 ON t7.UniversityID = t6.UniversityID
        WHERE STR_TO_DATE(t1.Date, '%d-%m-%Y') BETWEEN '$fromDate' 
        AND '$toDate' AND t1.BranchCode = '$reqpayType' ORDER BY ORDER_ID DESC";
// echo $querys;exit();
        // $this->db->where(' STR_TO_DATE(t1.Date, %d-%m-%Y) >=', $fromDate);
        // $this->db->where(' STR_TO_DATE(t1.Date, %d-%m-%Y) >=', $toDate); 
        // $this->db->where('t1.Date', $reqData['date']);
        // $this->db->order_by('CreatedOn', 'DESC');
        // $this->db->where('t1.BranchCode', $reqDataBy['localBranchID']);
        
        } else {
        // $this->db->select('t1.*, t2.ListName, t3.TypeName');
        // $this->db->from(''.DAYBOOKMASTER. ' as t1');
        // $this->db->join('' . PICK_LIST_DETAILS . ' as t2', 't2.ListCode = t1.Name', 'LEFT');
        // $this->db->join('' . INCOMEOUTCOMEMASTER . ' as t3', 't3.ID = t1.Type', 'LEFT');
        // // $this->db->where('t1.Date', $reqData['date']);
        // $this->db->order_by('CreatedOn', 'DESC');
        // $this->db->where('t1.BranchCode', $reqDataBy['localBranchID']);
            $reqpayType = $reqDataBy['localBranchID'];
            $querys = "SELECT t1.ID as ORDER_ID, t1.*, t2.ListName, t3.TypeName, t5.Firstname as Approved_by_name ,
            t7.UniversityName as UniversityName, t6.CourseName as CourseName
            FROM ".DAYBOOKMASTER." as t1 
            LEFT JOIN ".PICK_LIST_DETAILS." as t2 ON t2.ListCode = t1.Name 
            LEFT JOIN ".INCOMEOUTCOMEMASTER." as t3 ON t3.ID = t1.Type 
            LEFT JOIN ".LOGIN." as t4 ON t4.ID = t1.Approval_By 
            LEFT JOIN ".STAFF." as t5 ON t5.StaffID = t4.StaffID
            LEFT JOIN ".COURSE." as t6 ON t6.CourseID = t1.CourseID
            LEFT JOIN ".UNIVERSITY." as t7 ON t7.UniversityID = t6.UniversityID
            WHERE t1.BranchCode = '$reqpayType' ORDER BY ORDER_ID DESC";
            
        }
       
        // $this->db->join('' . COURSE . ' as t2', 't2.UniversityID = t1.UniversityID', 'LEFT');
        $dayBookDetails = $this->db->query($querys);
        $dayBookDetailsList = $dayBookDetails->result();
        $results['dayBookListStatus']      = true;
        $results['dayBookListDetails'] = $dayBookDetailsList;
        return $results;
    }

    public function get_Daybook_Approval_Details_List($reqData, $reqDataBy) {
        if($reqData['date'] != '' && $reqData['dateTo'] != '') {
            $d = new DateTime($reqData['date']);
            $dTo = new DateTime($reqData['dateTo']);
            $fromDate = $d->format('Y-m-d');
            $toDate = $dTo->format('Y-m-d');
            $reqpayType = $reqDataBy['localBranchID'];

            $querys = "SELECT t1.ID as ORDER_ID, t1.*, t2.ListName, t3.TypeName , t5.Firstname as Approved_by_name,t7.UniversityName as UniversityName, t6.CourseName as CourseName FROM ".DAYBOOKMASTER." as t1 LEFT JOIN ".PICK_LIST_DETAILS." as t2 ON t2.ListCode = t1.Name LEFT JOIN ".INCOMEOUTCOMEMASTER." as t3 ON t3.ID = t1.Type 
            LEFT JOIN ".LOGIN." as t4 ON t4.ID = t1.Approval_By LEFT JOIN ".STAFF." as t5 ON t5.StaffID = t4.StaffID LEFT JOIN ".COURSE." as t6 ON t6.CourseID = t1.CourseID
              LEFT JOIN ".UNIVERSITY." as t7 ON t7.UniversityID = t6.UniversityID
            WHERE STR_TO_DATE(t1.Date, '%d-%m-%Y') BETWEEN '$fromDate' 
            AND '$toDate' AND t1.BranchCode = '$reqpayType' AND t1.Status NOT IN ('Approved', 'Cancel') ORDER BY ORDER_ID DESC";
        } 
        else {   $reqpayType = $reqDataBy['localBranchID'];
            $querys = "SELECT t1.ID as ORDER_ID, t1.*, t2.ListName, t3.TypeName, t5.Firstname as Approved_by_name,t7.UniversityName as UniversityName, t6.CourseName as CourseName FROM ".DAYBOOKMASTER." as t1 LEFT JOIN ".PICK_LIST_DETAILS." as t2 ON t2.ListCode = t1.Name LEFT JOIN ".INCOMEOUTCOMEMASTER." as t3 ON t3.ID = t1.Type 
            LEFT JOIN ".LOGIN." as t4 ON t4.ID = t1.Approval_By LEFT JOIN ".STAFF." as t5 ON t5.StaffID = t4.StaffID LEFT JOIN ".COURSE." as t6 ON t6.CourseID = t1.CourseID
              LEFT JOIN ".UNIVERSITY." as t7 ON t7.UniversityID = t6.UniversityID
            WHERE t1.BranchCode = '$reqpayType' AND t1.Status NOT IN ('Approved', 'Cancel') ORDER BY ORDER_ID DESC";
            
        }
            $dayBookDetails = $this->db->query($querys);
            $dayBookDetailsList = $dayBookDetails->result();
            $results['dayBookListStatus']      = true;
            $results['dayBookListDetails'] = $dayBookDetailsList;
        return $results;
    }

    // delete the daybook details
    public function delete_dayBookDetails($id) {
        // echo $id;exit();
        
        $mysql = "SELECT * FROM ".DAYBOOKMASTER." WHERE ID = '$id'";
        $deleteDetails = $this->db->query($mysql);
        $deleteDataDetails = $deleteDetails->result();
        $branch = $deleteDataDetails[0]->BranchCode;

        $sql = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID < '$id')
                ORDER BY  ID DESC
                LIMIT 1 ";

        $currBalance = 0;
        $latestUpdate = $this->db->query($sql);
        $latestUpdateDetails = $latestUpdate->result();
        $currBalance = $latestUpdateDetails[0]->Balance;
        $currID = $latestUpdateDetails[0]->ID;

        // $sql1 = " DELETE FROM ".DAYBOOKMASTER." WHERE ID ='$id'";
        $sql1 = "UPDATE ".DAYBOOKMASTER." SET Status ='Cancel' WHERE ID ='$id'";
             
        // update branch to staff_branch table
        if ($this->db->query($sql1) == '1') {

            $sql2 = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID > '$currID')
                ORDER BY  ID ASC";
            $latestUpdate2 = $this->db->query($sql2);
            $latestUpdateDetails2 = $latestUpdate2->result();

            foreach( $latestUpdateDetails2 as $clip){
                if($clip->Name == 'I002' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                    //Income
                    $currBalance = $currBalance + $clip->Amount;
                }else if ($clip->Name == 'I001' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                    //Expense
                    $currBalance = $currBalance - $clip->Amount;
                } else {
                }
                $updateSql = "UPDATE ".DAYBOOKMASTER." SET Balance ='$currBalance' WHERE ID = '$clip->ID'";
                $this->db->query($updateSql);
            }

            $result['deletedStatus'] = true;
            $result['message']               = "Entry is Deleted";

        } else {
            $result['deletedStatus'] = false;
            $result['message']               = "Something went wrong.please try again";
        }

        // print_r($latestUpdateDetails);exit();
                            return $result;
    }

    // delete the daybook fees entry details
    public function delete_dayBookFeePayableDetails($id) {
        $this->db->select('FeesPaymentID, BranchCode');
        $this->db->from(DAYBOOKMASTER);
        $this->db->where('ID', $id);
        $typeDetails = $this->db->get();
        $typeStateDetails = $typeDetails->result();
        $getID = $typeStateDetails[0]->FeesPaymentID;
        $branch = $typeStateDetails[0]->BranchCode;
        // echo $id;exit();
        try {
            // $sql1 = " DELETE FROM ".STUDENTS_FEES_PAID." WHERE ID ='$getID'";
            $sql1 = "UPDATE ".STUDENTS_FEES_PAID." SET IsActive ='0' WHERE ID ='$getID'";
            $this->db->query($sql1);
        } catch(Exception $e) {
            echo 'error';
        } finally {
            $sql = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID < '$id')
            ORDER BY  ID DESC
            LIMIT 1 ";

            $currBalance = 0;
            $currID = $id;
            $latestUpdate = $this->db->query($sql);
            $latestUpdateDetails = $latestUpdate->result();
            If(is_array($latestUpdateDetails) && count($latestUpdateDetails)>0)
            {
                $currBalance = $latestUpdateDetails[0]->Balance;
                $currID = $latestUpdateDetails[0]->ID;
            }else{
            }
            // $sql1 = " DELETE FROM ".DAYBOOKMASTER." WHERE FeesPaymentID ='$getID'";
            // $sql1 = " DELETE FROM ".DAYBOOKMASTER." WHERE FeesPaymentID ='$getID'";
            $sql1 = "UPDATE ".DAYBOOKMASTER." SET Status ='Cancel' WHERE FeesPaymentID ='$getID'";
               
            // update branch to staff_branch table
            if ($this->db->query($sql1)  == '1') {

                $sql2 = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID > '$currID')
                    ORDER BY  ID ASC";
                $latestUpdate2 = $this->db->query($sql2);
                $latestUpdateDetails2 = $latestUpdate2->result();

                foreach( $latestUpdateDetails2 as $clip){
                    if($clip->Name == 'I002' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                        //Income
                        $currBalance = $currBalance + $clip->Amount;
                    }else if ($clip->Name == 'I001' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                        //Expense
                        $currBalance = $currBalance - $clip->Amount;
                    } else {
                    }
                    $updateSql = "UPDATE ".DAYBOOKMASTER." SET Balance ='$currBalance' WHERE ID = '$clip->ID'";
                    $this->db->query($updateSql);
                }
                
                $result['deletedStatus'] = true;
                $result['message']               = "Entry is Deleted";
            } else {
                $result['deletedStatus'] = false;
                $result['message']               = "Something went wrong.please try again";
            }
        }
        return $result;
    }

    // update existing daybook details 
    public function update_dayBookDetails($Arr, $upFor) {
    
     $branch = $Arr['BranchCode'];
     $sql = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID < '$upFor')
            ORDER BY  ID DESC
            LIMIT 1 ";
            $prevBalance = 0;
        $latestUpdate = $this->db->query($sql);
        $latestUpdateDetails = $latestUpdate->result();
        If(is_array($latestUpdateDetails) && count($latestUpdateDetails)>0)
        {
        $prevBalance = $latestUpdateDetails[0]->Balance;
        }else{
        }

        if($Arr['Name'] == 'I002') {
            //Income
            $Arr['Balance'] = $prevBalance + $Arr['Amount'];
        }else if ($Arr['Name'] == 'I001') {
            //Expense
            $Arr['Balance'] = $prevBalance - $Arr['Amount'];
        } else {
            $Arr['Balance'] = 0;
        }

        $this->db->where('ID', $upFor);
        $this->db->update(DAYBOOKMASTER, $Arr);
        if ($this->db->affected_rows() == '1') {

            $currBalance = 0;
            $sql1 = "SELECT * FROM ".DAYBOOKMASTER." WHERE BranchCode = '$branch' AND ID = '$upFor'";
            $latestUpdate1 = $this->db->query($sql1);
            $latestUpdateDetails1 = $latestUpdate1->result();
            $currBalance = $latestUpdateDetails1[0]->Balance;

            $sql2 = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID > '$upFor')
                ORDER BY  ID ASC";
            $latestUpdate2 = $this->db->query($sql2);
            $latestUpdateDetails2 = $latestUpdate2->result();

            foreach( $latestUpdateDetails2 as $clip){
                    if($clip->Name == 'I002' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                        //Income
                        $currBalance = $currBalance + $clip->Amount;
                    }else if ($clip->Name == 'I001' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                        //Expense
                        $currBalance = $currBalance - $clip->Amount;
                    } else {
                    }
                    $updateSql = "UPDATE ".DAYBOOKMASTER." SET Balance ='$currBalance' WHERE ID = '$clip->ID'";
                    $this->db->query($updateSql);
            }
            $result['updateDetailsStatus'] = true;
            $result['message'] = "Successfully Details Updated";
        } else {
            $result['updateDetailsStatus'] = false;
            $result['message']               = "Something went wrong.please try again";
        }
        return $result;
    }

     // add dayBook 
    public function add_dayBook($Arr)
    {
        $voucherNo = $Arr['VoucherNumber'];
        $sqlCheck = "SELECT * FROM ".DAYBOOKMASTER." WHERE VoucherNumber = '$voucherNo'";
    //    print_r($this->db->query($sqlCheck));exit();
         $checkAdd = $this->db->query($sqlCheck);
            $checkAddDetails = $checkAdd->result();
        if(count( $checkAddDetails ) > 0){
                    $result['addDayBookStatus'] = false;
                    $result['message']      = "This Voucher Number Already Exist.";
        }else{
         $branch = $Arr['BranchCode'];
        $sql = "SELECT * FROM ".DAYBOOKMASTER." WHERE BranchCode = '$branch'
            ORDER BY  ID DESC
            LIMIT 1";
             $prevBalance = 0;
        $latestUpdate = $this->db->query($sql);
        $latestUpdateDetails = $latestUpdate->result();

          If(is_array($latestUpdateDetails) && count($latestUpdateDetails)>0)
        {
        $prevBalance = $latestUpdateDetails[0]->Balance;
        }else{
        }
        
        if($Arr['Name'] == 'I002') {
            //Income
            $Arr['Balance'] = $prevBalance + $Arr['Amount'];
        }else if ($Arr['Name'] == 'I001') {
            //Expense
            $Arr['Balance'] = $prevBalance - $Arr['Amount'];
        } else {
            $Arr['Balance'] = 0;
        }

        $this->db->insert(DAYBOOKMASTER, $Arr);
        if ($this->db->affected_rows() == '1') {
                    $result['addDayBookStatus'] = true;
                    $result['message']      = "Successfully DayBook Details Added";
        } else {
            $result['addDayBookStatus'] = false;
            $result['message']      = "Something went wrong.please try again";
        }
}
       
        return $result;
    }

    // approve/reject status updation for the daybook expense details
    public function update_status_admin($arr) {
    
        $Approval_By = $arr[0]['Approval_By'];
        $Approval_Comments = $arr[0]['Approval_Comments'];
        $UpdatedBy = $arr[0]['UpdatedBy'];
        $UpdatedOn = $arr[0]['UpdatedOn'];
        $status = $arr[0]['Status'];
        // $number = array();
        // foreach($arr as $ar){
        //         array_push($number, $ar['ID']);
        // }
        // $updateFor = implode(',', $number);
        $updateFor = $arr[0]['ID'];
        if( $status == "Pending" || $status == "Approved" ||  $status == "approved" || $status == "pending"){

            $mysql = "SELECT * FROM ".DAYBOOKMASTER." WHERE ID = '$updateFor'";
            $updateDetails = $this->db->query($mysql);
            $updateDataDetails = $updateDetails->result();
            $branch = $updateDataDetails[0]->BranchCode;
            $Amount = 0;
            $Amount = $updateDataDetails[0]->Amount;

            $sql = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID < '$updateFor')
                ORDER BY  ID DESC
                LIMIT 1 ";

            $currBalance = 0;
            $latestUpdate = $this->db->query($sql);
            $latestUpdateDetails = $latestUpdate->result();
                    if($updateDataDetails[0]->Name == 'I002' ) {
                            //Income
                            $currBalance = $latestUpdateDetails[0]->Balance + $Amount;
                        }else if ($updateDataDetails[0]->Name == 'I001') {
                            //Expense
                            $currBalance = $latestUpdateDetails[0]->Balance - $Amount;
                        } else {
                        }
                //  $currBalance = $latestUpdateDetails[0]->Balance + $Amount;

            $sql = "UPDATE ".DAYBOOKMASTER."
            SET Status = '$status', Approval_By = '$Approval_By' , 
            Approval_Comments = '$Approval_Comments', UpdatedBy = '$UpdatedBy' , UpdatedOn = '$UpdatedOn' , Balance = '$currBalance'
            WHERE id = '$updateFor' ";
            $mBranchDetails = $this->db->query($sql);
            // echo $mBranchDetails;
            // echo $this->db->affected_rows(); exit();
            if ($this->db->affected_rows() >= 1) {
                    $sql2 = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID > '$updateFor')
                    ORDER BY  ID ASC";
                    $latestUpdate2 = $this->db->query($sql2);
                    $latestUpdateDetails2 = $latestUpdate2->result();
                    foreach( $latestUpdateDetails2 as $clip){
                        if($clip->Name == 'I002' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                            //Income
                            $currBalance = $currBalance + $clip->Amount;
                        }else if ($clip->Name == 'I001' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                            //Expense
                            $currBalance = $currBalance - $clip->Amount;
                        } else {
                        }
                        $updateSql = "UPDATE ".DAYBOOKMASTER." SET Balance ='$currBalance' WHERE ID = '$clip->ID'";
                        $this->db->query($updateSql);
                    }
                    $result['addStatus'] = true;
                        $result['message']      = "Successfully Details Updated";
            } else {
                    $result['addStatus'] = false;
                    $result['message']      = "Something went wrong.please try again";
            }
        } else if( $status == "Rejected" || $status == "rejected"  ) {
            $mysql = "SELECT * FROM ".DAYBOOKMASTER." WHERE ID = '$updateFor'";
            $updateDetails = $this->db->query($mysql);
            $updateDataDetails = $updateDetails->result();
            $branch = $updateDataDetails[0]->BranchCode;
            $Amount = 0;
            $Amount = $updateDataDetails[0]->Amount;
            if($updateDataDetails[0]->PaymentStatus === '1' || $updateDataDetails[0]->PaymentStatus === '0'){

        
                $sql = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID < '$updateFor')
                    ORDER BY  ID DESC
                    LIMIT 1 ";

                $currBalance = 0;
                $latestUpdate = $this->db->query($sql);
                $latestUpdateDetails = $latestUpdate->result();
                $currBalance = $latestUpdateDetails[0]->Balance;

                $sql = "UPDATE ".DAYBOOKMASTER."
                    SET Status = '$status', Approval_By = '$Approval_By' , 
                    Approval_Comments = '$Approval_Comments', UpdatedBy = '$UpdatedBy' , UpdatedOn = '$UpdatedOn' , Balance = '$currBalance'
                    WHERE id = '$updateFor' ";
                $mBranchDetails = $this->db->query($sql);
                // echo $mBranchDetails;
                // echo $this->db->affected_rows(); exit();
                if ($this->db->affected_rows() >= 1) {
                        $sql2 = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID > '$updateFor')
                        ORDER BY  ID ASC";
                        $latestUpdate2 = $this->db->query($sql2);
                        $latestUpdateDetails2 = $latestUpdate2->result();
                        foreach( $latestUpdateDetails2 as $clip){
                            if($clip->Name == 'I002' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                                //Income
                                $currBalance = $currBalance + $clip->Amount;
                            }else if ($clip->Name == 'I001' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
                                //Expense
                                $currBalance = $currBalance - $clip->Amount;
                            } else {
                            }
                            $updateSql = "UPDATE ".DAYBOOKMASTER." SET Balance ='$currBalance' WHERE ID = '$clip->ID'";
                            $this->db->query($updateSql);
                        }
                        $result['addStatus'] = true;
                            $result['message']      = "Successfully Details Updated";
                } else {
                        $result['addStatus'] = false;
                        $result['message']      = "Something went wrong.please try again";
                }
            } 
            // else if($updateDataDetails[0]->PaymentStatus === '0') {
            //     $currentVoucheNumber = $updateDataDetails[0]->VoucherNumber;
            // $mySql = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND VoucherNumber = '$currentVoucheNumber')
            //         ORDER BY  ID ASC
            //         LIMIT 1 ";
            //     $mySqlUpdate = $this->db->query($mySql);
            //     $mySqlUpdateDetails = $mySqlUpdate->result();
            //     $mySqlUpdateDetailsID = $mySqlUpdateDetails[0]->ID;

            //     $sql = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID < '$mySqlUpdateDetailsID')
            //         ORDER BY  ID DESC
            //         LIMIT 1 ";
            //     $currBalance = 0;
            //     $latestUpdate = $this->db->query($sql);
            //     $latestUpdateDetails = $latestUpdate->result();
            //      If(is_array($latestUpdateDetails) && count($latestUpdateDetails)>0)
            //         {
            //         $currBalance = $latestUpdateDetails[0]->Balance;
            //         }else{
            //         }
            //     $sql = "UPDATE ".DAYBOOKMASTER."
            //         SET Status = '$status', Approval_By = '$Approval_By' , 
            //         Approval_Comments = '$Approval_Comments', UpdatedBy = '$UpdatedBy' , UpdatedOn = '$UpdatedOn' , Balance = '$currBalance'
            //         WHERE VoucherNumber = '$currentVoucheNumber' ";
            //     $mBranchDetails = $this->db->query($sql);
            //     if ($this->db->affected_rows() >= 1) {
            //             $sql2 = "SELECT * FROM ".DAYBOOKMASTER." WHERE (BranchCode = '$branch' AND ID > '$updateFor')
            //             ORDER BY  ID ASC";
            //             $latestUpdate2 = $this->db->query($sql2);
            //             $latestUpdateDetails2 = $latestUpdate2->result();
            //             foreach( $latestUpdateDetails2 as $clip){
            //                 if($clip->Name == 'I002' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
            //                     //Income
            //                     $currBalance = $currBalance + $clip->Amount;
            //                 }else if ($clip->Name == 'I001' && ($clip->Status == "Pending" || $clip->Status == "Approved" ||  $clip->Status == "approved" || $clip->Status == "pending")) {
            //                     //Expense
            //                     $currBalance = $currBalance - $clip->Amount;
            //                 } else {
            //                 }
            //                 $updateSql = "UPDATE ".DAYBOOKMASTER." SET Balance ='$currBalance' WHERE ID = '$clip->ID'";
            //                 $this->db->query($updateSql);
            //             }
            //             $result['addStatus'] = true;
            //                 $result['message']      = "Successfully Details Updated";
            //     } else {
            //             $result['addStatus'] = false;
            //             $result['message']      = "Something went wrong.please try again";
            //     }

            // }
            }
            return $result;
    }

    // daybook full details for super admin view
    public function get_Daybook_Details_List_superAdmin($reqData, $reqDataBy){

         if($reqData['date'] != '' && $reqData['dateTo'] != '') {
            $this->db->select('t1.*, t2.ListName, t3.TypeName, t4.BranchName, t6.Firstname as Approved_by_name ');
            $this->db->from(''.DAYBOOKMASTER. ' as t1');
            $this->db->join('' . PICK_LIST_DETAILS . ' as t2', 't2.ListCode = t1.Name', 'LEFT');
            $this->db->join('' . INCOMEOUTCOMEMASTER . ' as t3', 't3.ID = t1.Type', 'LEFT');
            $this->db->join('' . BRANCH . ' as t4', 't4.BranchCode = t1.BranchCode', 'LEFT');
            $this->db->join('' . LOGIN . ' as t5', 't5.ID = t1.Approval_By', 'LEFT');
            $this->db->join('' . STAFF . ' as t6', 't6.StaffID = t5.StaffID', 'LEFT');
            $this->db->where('t1.Date >=', $reqData['date']);
            $this->db->where('t1.Date <=', $reqData['dateTo']);
            $this->db->order_by('CreatedOn', 'DESC');
            // $this->db->join('' . COURSE . ' as t2', 't2.UniversityID = t1.UniversityID', 'LEFT');
            $dayBookDetails = $this->db->get();
            $dayBookDetailsList = $dayBookDetails->result();
         }  else {
            $this->db->select('t1.*, t2.ListName, t3.TypeName, t4.BranchName, t6.Firstname as Approved_by_name ');
            $this->db->from(''.DAYBOOKMASTER. ' as t1');
            $this->db->join('' . PICK_LIST_DETAILS . ' as t2', 't2.ListCode = t1.Name', 'LEFT');
            $this->db->join('' . INCOMEOUTCOMEMASTER . ' as t3', 't3.ID = t1.Type', 'LEFT');
            $this->db->join('' . BRANCH . ' as t4', 't4.BranchCode = t1.BranchCode', 'LEFT');
             $this->db->join('' . LOGIN . ' as t5', 't5.ID = t1.Approval_By', 'LEFT');
            $this->db->join('' . STAFF . ' as t6', 't6.StaffID = t5.StaffID', 'LEFT');
            // $this->db->where('t1.Date', $reqData['date']);
            $this->db->order_by('CreatedOn', 'DESC');
            // $this->db->join('' . COURSE . ' as t2', 't2.UniversityID = t1.UniversityID', 'LEFT');
            $dayBookDetails = $this->db->get();
            $dayBookDetailsList = $dayBookDetails->result();
         }

        $results['dayBookListStatus']      = true;
        $results['dayBookListDetails'] = $dayBookDetailsList;
        return $results;
    }
}