585 lines
30 KiB
PHP
Executable File
585 lines
30 KiB
PHP
Executable File
<?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;
|
|
}
|
|
} |