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

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

��ѧ٧ѧ�
<?php namespace App\Controllers; class Expenses extends Security_Controller { function __construct() { parent::__construct(); $this->init_permission_checker("expense"); $this->access_only_allowed_members(); } //load the expenses list view function index() { $this->check_module_availability("module_expense"); $view_data["custom_field_headers"] = $this->Custom_fields_model->get_custom_field_headers_for_table("expenses", $this->login_user->is_admin, $this->login_user->user_type); $view_data['categories_dropdown'] = $this->_get_categories_dropdown(); $view_data['members_dropdown'] = $this->_get_team_members_dropdown(); $view_data["projects_dropdown"] = $this->_get_projects_dropdown_for_income_and_epxenses("expenses"); return $this->template->rander("expenses/index", $view_data); } //get categories dropdown private function _get_categories_dropdown() { $categories = $this->Expense_categories_model->get_all_where(array("deleted" => 0), 0, 0, "title")->getResult(); $categories_dropdown = array(array("id" => "", "text" => "- " . app_lang("category") . " -")); foreach ($categories as $category) { $categories_dropdown[] = array("id" => $category->id, "text" => $category->title); } return json_encode($categories_dropdown); } //get team members dropdown private function _get_team_members_dropdown() { $team_members = $this->Users_model->get_all_where(array("deleted" => 0, "user_type" => "staff"), 0, 0, "first_name")->getResult(); $members_dropdown = array(array("id" => "", "text" => "- " . app_lang("member") . " -")); foreach ($team_members as $team_member) { $members_dropdown[] = array("id" => $team_member->id, "text" => $team_member->first_name . " " . $team_member->last_name); } return json_encode($members_dropdown); } //load the expenses list yearly view function yearly() { return $this->template->view("expenses/yearly_expenses"); } //load custom expenses list function custom() { return $this->template->view("expenses/custom_expenses"); } //load the recurring view of expense list function recurring() { return $this->template->view("expenses/recurring_expenses_list"); } //load the add/edit expense form function modal_form() { $this->validate_submitted_data(array( "id" => "numeric" )); $client_id = $this->request->getPost('client_id'); $model_info = $this->Expenses_model->get_one($this->request->getPost('id')); $view_data['categories_dropdown'] = $this->Expense_categories_model->get_dropdown_list(array("title")); $team_members = $this->Users_model->get_all_where(array("deleted" => 0, "user_type" => "staff"))->getResult(); $members_dropdown = array(); foreach ($team_members as $team_member) { $members_dropdown[$team_member->id] = $team_member->first_name . " " . $team_member->last_name; } $view_data['members_dropdown'] = array("0" => "-") + $members_dropdown; $view_data['clients_dropdown'] = array("" => "-") + $this->Clients_model->get_dropdown_list(array("company_name"), "id", array("is_lead" => 0)); $view_data['projects_dropdown'] = array("0" => "-") + $this->Projects_model->get_dropdown_list(array("title")); $view_data['taxes_dropdown'] = array("" => "-") + $this->Taxes_model->get_dropdown_list(array("title")); $model_info->project_id = $model_info->project_id ? $model_info->project_id : $this->request->getPost('project_id'); $model_info->user_id = $model_info->user_id ? $model_info->user_id : $this->request->getPost('user_id'); $view_data['model_info'] = $model_info; $view_data['client_id'] = $client_id; $view_data['can_access_expenses'] = $this->can_access_expenses(); $view_data['can_access_clients'] = $this->can_access_clients(); $view_data["custom_fields"] = $this->Custom_fields_model->get_combined_details("expenses", $view_data['model_info']->id, $this->login_user->is_admin, $this->login_user->user_type)->getResult(); return $this->template->view('expenses/modal_form', $view_data); } //save an expense function save() { $this->validate_submitted_data(array( "id" => "numeric", "expense_date" => "required", "category_id" => "required", "amount" => "required" )); $id = $this->request->getPost('id'); $target_path = get_setting("timeline_file_path"); $files_data = move_files_from_temp_dir_to_permanent_dir($target_path, "expense"); $new_files = unserialize($files_data); $recurring = $this->request->getPost('recurring') ? 1 : 0; $expense_date = $this->request->getPost('expense_date'); $repeat_every = $this->request->getPost('repeat_every'); $repeat_type = $this->request->getPost('repeat_type'); $no_of_cycles = $this->request->getPost('no_of_cycles'); $data = array( "expense_date" => $expense_date, "title" => $this->request->getPost('title'), "description" => $this->request->getPost('description'), "category_id" => $this->request->getPost('category_id'), "amount" => unformat_currency($this->request->getPost('amount')), "client_id" => $this->request->getPost('expense_client_id') ? $this->request->getPost('expense_client_id') : 0, "project_id" => $this->request->getPost('expense_project_id'), "user_id" => $this->request->getPost('expense_user_id'), "tax_id" => $this->request->getPost('tax_id') ? $this->request->getPost('tax_id') : 0, "tax_id2" => $this->request->getPost('tax_id2') ? $this->request->getPost('tax_id2') : 0, "recurring" => $recurring, "repeat_every" => $repeat_every ? $repeat_every : 0, "repeat_type" => $repeat_type ? $repeat_type : NULL, "no_of_cycles" => $no_of_cycles ? $no_of_cycles : 0, ); $expense_info = $this->Expenses_model->get_one($id); //is editing? update the files if required if ($id) { $timeline_file_path = get_setting("timeline_file_path"); $new_files = update_saved_files($timeline_file_path, $expense_info->files, $new_files); } $data["files"] = serialize($new_files); if ($recurring) { //set next recurring date for recurring expenses if ($id) { //update if ($this->request->getPost('next_recurring_date')) { //submitted any recurring date? set it. $data['next_recurring_date'] = $this->request->getPost('next_recurring_date'); } else { //re-calculate the next recurring date, if any recurring fields has changed. if ($expense_info->recurring != $data['recurring'] \|\| $expense_info->repeat_every != $data['repeat_every'] \|\| $expense_info->repeat_type != $data['repeat_type'] \|\| $expense_info->expense_date != $data['expense_date']) { $data['next_recurring_date'] = add_period_to_date($expense_date, $repeat_every, $repeat_type); } } } else { //insert new $data['next_recurring_date'] = add_period_to_date($expense_date, $repeat_every, $repeat_type); } //recurring date must have to set a future date if (get_array_value($data, "next_recurring_date") && get_today_date() >= $data['next_recurring_date']) { echo json_encode(array("success" => false, 'message' => app_lang('past_recurring_date_error_message_title'), 'next_recurring_date_error' => app_lang('past_recurring_date_error_message'), "next_recurring_date_value" => $data['next_recurring_date'])); return false; } } $save_id = $this->Expenses_model->ci_save($data, $id); if ($save_id) { save_custom_fields("expenses", $save_id, $this->login_user->is_admin, $this->login_user->user_type); echo json_encode(array("success" => true, "data" => $this->_row_data($save_id), 'id' => $save_id, 'message' => app_lang('record_saved'))); } else { echo json_encode(array("success" => false, 'message' => app_lang('error_occurred'))); } } //delete/undo an expense function delete() { $this->validate_submitted_data(array( "id" => "required\|numeric" )); $id = $this->request->getPost('id'); $expense_info = $this->Expenses_model->get_one($id); if ($this->Expenses_model->delete($id)) { //delete the files $file_path = get_setting("timeline_file_path"); if ($expense_info->files) { $files = unserialize($expense_info->files); foreach ($files as $file) { delete_app_files($file_path, array($file)); } } echo json_encode(array("success" => true, 'message' => app_lang('record_deleted'))); } else { echo json_encode(array("success" => false, 'message' => app_lang('record_cannot_be_deleted'))); } } //get the expnese list data function list_data($recurring = false) { $start_date = $this->request->getPost('start_date'); $end_date = $this->request->getPost('end_date'); $category_id = $this->request->getPost('category_id'); $project_id = $this->request->getPost('project_id'); $user_id = $this->request->getPost('user_id'); $custom_fields = $this->Custom_fields_model->get_available_fields_for_table("expenses", $this->login_user->is_admin, $this->login_user->user_type); $options = array("start_date" => $start_date, "end_date" => $end_date, "category_id" => $category_id, "project_id" => $project_id, "user_id" => $user_id, "custom_fields" => $custom_fields, "recurring" => $recurring); $list_data = $this->Expenses_model->get_details($options)->getResult(); $result = array(); foreach ($list_data as $data) { $result[] = $this->_make_row($data, $custom_fields); } echo json_encode(array("data" => $result)); } //get a row of expnese list private function _row_data($id) { $custom_fields = $this->Custom_fields_model->get_available_fields_for_table("expenses", $this->login_user->is_admin, $this->login_user->user_type); $options = array("id" => $id, "custom_fields" => $custom_fields); $data = $this->Expenses_model->get_details($options)->getRow(); return $this->_make_row($data, $custom_fields); } //prepare a row of expnese list private function _make_row($data, $custom_fields) { $description = $data->description; if ($data->linked_client_name) { if ($description) { $description .= "<br />"; } $description .= app_lang("client") . ": " . $data->linked_client_name; } if ($data->project_title) { if ($description) { $description .= "<br /> "; } $description .= app_lang("project") . ": " . $data->project_title; } if ($data->linked_user_name) { if ($description) { $description .= "<br /> "; } $description .= app_lang("team_member") . ": " . $data->linked_user_name; } if ($data->recurring) { //show recurring information $recurring_stopped = false; $recurring_cycle_class = ""; if ($data->no_of_cycles_completed > 0 && $data->no_of_cycles_completed == $data->no_of_cycles) { $recurring_cycle_class = "text-danger"; $recurring_stopped = true; } $cycles = $data->no_of_cycles_completed . "/" . $data->no_of_cycles; if (!$data->no_of_cycles) { //if not no of cycles, so it's infinity $cycles = $data->no_of_cycles_completed . "/∞"; } if ($description) { $description .= "<br /> "; } $description .= app_lang("repeat_every") . ": " . $data->repeat_every . " " . app_lang("interval_" . $data->repeat_type); $description .= "<br /> "; $description .= "<span class='$recurring_cycle_class'>" . app_lang("cycles") . ": " . $cycles . "</span>"; if (!$recurring_stopped && (int) $data->next_recurring_date) { $description .= "<br /> "; $description .= app_lang("next_recurring_date") . ": " . format_to_date($data->next_recurring_date, false); } } if ($data->recurring_expense_id) { if ($description) { $description .= "<br /> "; } $description .= modal_anchor(get_uri("expenses/expense_details"), app_lang("original_expense"), array("title" => app_lang("expense_details"), "data-post-id" => $data->recurring_expense_id)); } $files_link = ""; if ($data->files) { $files = unserialize($data->files); if (count($files)) { foreach ($files as $key => $value) { $file_name = get_array_value($value, "file_name"); $link = get_file_icon(strtolower(pathinfo($file_name, PATHINFO_EXTENSION))); $files_link .= js_anchor("<i data-feather='$link'></i>", array('title' => "", "data-toggle" => "app-modal", "data-sidebar" => "0", "class" => "float-start font-22 mr10", "title" => remove_file_prefix($file_name), "data-url" => get_uri("expenses/file_preview/" . $data->id . "/" . $key))); } } } $tax = 0; $tax2 = 0; if ($data->tax_percentage) { $tax = $data->amount * ($data->tax_percentage / 100); } if ($data->tax_percentage2) { $tax2 = $data->amount * ($data->tax_percentage2 / 100); } $row_data = array( $data->expense_date, modal_anchor(get_uri("expenses/expense_details"), format_to_date($data->expense_date, false), array("title" => app_lang("expense_details"), "data-post-id" => $data->id)), $data->category_title, $data->title, $description, $files_link, to_currency($data->amount), to_currency($tax), to_currency($tax2), to_currency($data->amount + $tax + $tax2) ); foreach ($custom_fields as $field) { $cf_id = "cfv_" . $field->id; $row_data[] = $this->template->view("custom_fields/output_" . $field->field_type, array("value" => $data->$cf_id)); } $row_data[] = modal_anchor(get_uri("expenses/modal_form"), "<i data-feather='edit' class='icon-16'></i>", array("class" => "edit", "title" => app_lang('edit_expense'), "data-post-id" => $data->id)) . js_anchor("<i data-feather='x' class='icon-16'></i>", array('title' => app_lang('delete_expense'), "class" => "delete", "data-id" => $data->id, "data-action-url" => get_uri("expenses/delete"), "data-action" => "delete-confirmation")); return $row_data; } function file_preview($id = "", $key = "") { if ($id) { $expense_info = $this->Expenses_model->get_one($id); $files = unserialize($expense_info->files); $file = get_array_value($files, $key); $file_name = get_array_value($file, "file_name"); $file_id = get_array_value($file, "file_id"); $service_type = get_array_value($file, "service_type"); $view_data["file_url"] = get_source_url_of_file($file, get_setting("timeline_file_path")); $view_data["is_image_file"] = is_image_file($file_name); $view_data["is_google_preview_available"] = is_google_preview_available($file_name); $view_data["is_viewable_video_file"] = is_viewable_video_file($file_name); $view_data["is_google_drive_file"] = ($file_id && $service_type == "google") ? true : false; return $this->template->view("expenses/file_preview", $view_data); } else { show_404(); } } /* upload a file / function upload_file() { upload_file_to_temp(); } / check valid file for ticket / function validate_expense_file() { return validate_post_file($this->request->getPost("file_name")); } //load the expenses yearly chart view function yearly_chart() { return $this->template->view("expenses/yearly_chart"); } function yearly_chart_data() { $months = array("january", "february", "march", "april", "may", "june", "july", "august", "september", "october", "november", "december"); $year = $this->request->getPost("year"); if ($year) { $expenses = $this->Expenses_model->get_yearly_expenses_chart($year); $values = array(); foreach ($expenses as $value) { $values[$value->month - 1] = $value->total; //in array the month january(1) = index(0) } foreach ($months as $key => $month) { $value = get_array_value($values, $key); $short_months[] = app_lang("short_" . $month); $data[] = $value ? $value : 0; } echo json_encode(array("months" => $short_months, "data" => $data)); } } function income_vs_expenses() { $view_data["projects_dropdown"] = $this->_get_projects_dropdown_for_income_and_epxenses(); return $this->template->rander("expenses/income_vs_expenses_chart", $view_data); } function income_vs_expenses_chart_data() { $year = $this->request->getPost("year"); $project_id = $this->request->getPost("project_id"); if ($year) { $expenses_data = $this->Expenses_model->get_yearly_expenses_chart($year, $project_id); $payments_data = $this->Invoice_payments_model->get_yearly_payments_chart($year, "", $project_id); $payments = array(); $expenses = array(); for ($i = 1; $i <= 12; $i++) { $payments[$i] = 0; $expenses[$i] = 0; } foreach ($payments_data as $payment) { $payments[$payment->month] = $payment->total; } foreach ($expenses_data as $expense) { $expenses[$expense->month] = $expense->total; } foreach ($payments as $payment) { $payments_array[] = $payment; } foreach ($expenses as $expense) { $expenses_array[] = $expense; } echo json_encode(array("income" => $payments_array, "expenses" => $expenses_array)); } } function income_vs_expenses_summary() { $view_data["projects_dropdown"] = $this->_get_projects_dropdown_for_income_and_epxenses(); return $this->template->view("expenses/income_vs_expenses_summary", $view_data); } function income_vs_expenses_summary_list_data() { $year = explode("-", $this->request->getPost("start_date")); $project_id = $this->request->getPost("project_id"); if ($year) { $expenses_data = $this->Expenses_model->get_yearly_expenses_chart($year[0], $project_id); $payments_data = $this->Invoice_payments_model->get_yearly_payments_chart($year[0], "", $project_id); $payments = array(); $expenses = array(); for ($i = 1; $i <= 12; $i++) { $payments[$i] = 0; $expenses[$i] = 0; } foreach ($payments_data as $payment) { $payments[$payment->month] = $payment->total; } foreach ($expenses_data as $expense) { $expenses[$expense->month] = $expense->total; } //get the list of summary $result = array(); for ($i = 1; $i <= 12; $i++) { $result[] = $this->_row_data_of_summary($i, $payments[$i], $expenses[$i]); } echo json_encode(array("data" => $result)); } } //get the row of summary private function _row_data_of_summary($month_index, $payments, $expenses) { //get the month name $month_array = array(" ", "january", "february", "march", "april", "may", "june", "july", "august", "september", "october", "november", "december"); $month = get_array_value($month_array, $month_index); $month_name = app_lang($month); $profit = $payments - $expenses; return array( $month_index, $month_name, to_currency($payments), to_currency($expenses), to_currency($profit) ); } / list of expense of a specific client, prepared for datatable / function expense_list_data_of_client($client_id) { $this->access_only_team_members(); $custom_fields = $this->Custom_fields_model->get_available_fields_for_table("expenses", $this->login_user->is_admin, $this->login_user->user_type); $options = array("client_id" => $client_id); $list_data = $this->Expenses_model->get_details($options)->getResult(); $result = array(); foreach ($list_data as $data) { $result[] = $this->_make_row($data, $custom_fields); } echo json_encode(array("data" => $result)); } private function can_access_clients() { $permissions = $this->login_user->permissions; if (get_array_value($permissions, "client")) { return true; } else { return false; } } function expense_details() { $this->validate_submitted_data(array( "id" => "required\|numeric" )); $expense_id = $this->request->getPost('id'); $options = array("id" => $expense_id); $info = $this->Expenses_model->get_details($options)->getRow(); if (!$info) { show_404(); } $view_data["expense_info"] = $info; $view_data['custom_fields_list'] = $this->Custom_fields_model->get_combined_details("expenses", $expense_id, $this->login_user->is_admin, $this->login_user->user_type)->getResult(); return $this->template->view("expenses/expense_details", $view_data); } } / End of file expenses.php / / Location: ./app/controllers/expenses.php */

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