��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/rickpfrv/clients.dominiquerickard.com/app/Models/Expenses_model.php

��ѧ٧ѧ�
<?php namespace App\Models; class Expenses_model extends Crud_model { protected $table = null; function __construct() { $this->table = 'expenses'; parent::__construct($this->table); } function get_details($options = array()) { $expenses_table = $this->db->prefixTable('expenses'); $expense_categories_table = $this->db->prefixTable('expense_categories'); $projects_table = $this->db->prefixTable('projects'); $users_table = $this->db->prefixTable('users'); $taxes_table = $this->db->prefixTable('taxes'); $clients_table = $this->db->prefixTable('clients'); $where = ""; $id = get_array_value($options, "id"); if ($id) { $where = " AND $expenses_table.id=$id"; } $start_date = get_array_value($options, "start_date"); $end_date = get_array_value($options, "end_date"); if ($start_date && $end_date) { $where .= " AND ($expenses_table.expense_date BETWEEN '$start_date' AND '$end_date') "; } $category_id = get_array_value($options, "category_id"); if ($category_id) { $where .= " AND $expenses_table.category_id=$category_id"; } $project_id = get_array_value($options, "project_id"); if ($project_id) { $where .= " AND $expenses_table.project_id=$project_id"; } $user_id = get_array_value($options, "user_id"); if ($user_id) { $where .= " AND $expenses_table.user_id=$user_id"; } $client_id = get_array_value($options, "client_id"); if ($client_id) { $where .= " AND $expenses_table.client_id=$client_id"; } $recurring = get_array_value($options, "recurring"); if ($recurring) { $where .= " AND $expenses_table.recurring=1"; } //prepare custom fild binding query $custom_fields = get_array_value($options, "custom_fields"); $custom_field_query_info = $this->prepare_custom_field_query_string("expenses", $custom_fields, $expenses_table); $select_custom_fields = get_array_value($custom_field_query_info, "select_string"); $join_custom_fields = get_array_value($custom_field_query_info, "join_string"); $sql = "SELECT $expenses_table., $expense_categories_table.title as category_title, CONCAT($users_table.first_name, ' ', $users_table.last_name) AS linked_user_name, $clients_table.company_name AS linked_client_name, $projects_table.title AS project_title, tax_table.percentage AS tax_percentage, tax_table2.percentage AS tax_percentage2 $select_custom_fields FROM $expenses_table LEFT JOIN $expense_categories_table ON $expense_categories_table.id= $expenses_table.category_id LEFT JOIN $clients_table ON $clients_table.id= $expenses_table.client_id LEFT JOIN $projects_table ON $projects_table.id= $expenses_table.project_id LEFT JOIN $users_table ON $users_table.id= $expenses_table.user_id LEFT JOIN (SELECT $taxes_table. FROM $taxes_table) AS tax_table ON tax_table.id = $expenses_table.tax_id LEFT JOIN (SELECT $taxes_table.* FROM $taxes_table) AS tax_table2 ON tax_table2.id = $expenses_table.tax_id2 $join_custom_fields WHERE $expenses_table.deleted=0 $where"; return $this->db->query($sql); } function get_income_expenses_info() { $expenses_table = $this->db->prefixTable('expenses'); $invoice_payments_table = $this->db->prefixTable('invoice_payments'); $taxes_table = $this->db->prefixTable('taxes'); $info = new \stdClass(); $sql1 = "SELECT SUM($invoice_payments_table.amount) as total_income FROM $invoice_payments_table WHERE $invoice_payments_table.deleted=0"; $income = $this->db->query($sql1)->getRow(); $sql2 = "SELECT SUM($expenses_table.amount + IFNULL(tax_table.percentage,0)/100IFNULL($expenses_table.amount,0) + IFNULL(tax_table2.percentage,0)/100IFNULL($expenses_table.amount,0)) AS total_expenses FROM $expenses_table LEFT JOIN (SELECT $taxes_table.id, $taxes_table.percentage FROM $taxes_table) AS tax_table ON tax_table.id = $expenses_table.tax_id LEFT JOIN (SELECT $taxes_table.id, $taxes_table.percentage FROM $taxes_table) AS tax_table2 ON tax_table2.id = $expenses_table.tax_id2 WHERE $expenses_table.deleted=0"; $expenses = $this->db->query($sql2)->getRow(); $info->income = $income->total_income; $info->expneses = $expenses->total_expenses; return $info; } function get_yearly_expenses_chart($year, $project_id = 0) { $expenses_table = $this->db->prefixTable('expenses'); $taxes_table = $this->db->prefixTable('taxes'); $where = ""; if ($project_id) { $where = " AND $expenses_table.project_id=$project_id"; } $expenses = "SELECT SUM($expenses_table.amount + IFNULL(tax_table.percentage,0)/100IFNULL($expenses_table.amount,0) + IFNULL(tax_table2.percentage,0)/100IFNULL($expenses_table.amount,0)) AS total, MONTH($expenses_table.expense_date) AS month FROM $expenses_table LEFT JOIN (SELECT $taxes_table.id, $taxes_table.percentage FROM $taxes_table) AS tax_table ON tax_table.id = $expenses_table.tax_id LEFT JOIN (SELECT $taxes_table.id, $taxes_table.percentage FROM $taxes_table) AS tax_table2 ON tax_table2.id = $expenses_table.tax_id2 WHERE $expenses_table.deleted=0 AND YEAR($expenses_table.expense_date)= $year $where GROUP BY MONTH($expenses_table.expense_date)"; return $this->db->query($expenses)->getResult(); } //get the recurring expenses which are ready to renew as on a given date function get_renewable_expenses($date) { $expenses_table = $this->db->prefixTable('expenses'); $sql = "SELECT * FROM $expenses_table WHERE $expenses_table.deleted=0 AND $expenses_table.recurring=1 AND $expenses_table.next_recurring_date IS NOT NULL AND $expenses_table.next_recurring_date<='$date' AND ($expenses_table.no_of_cycles < 1 OR ($expenses_table.no_of_cycles_completed < $expenses_table.no_of_cycles ))"; return $this->db->query($sql); } }

| ver. 1.4 | Github | . | PHP 7.4.33 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0 | proxy | phpinfo | ��ѧ��ۧܧ�