# erp/1.6.7/modules/hrm/includes/api/class-hrm-reports-controller.php

ERP: Complete HR, Accounting & CRM Suite Built for WooCommerce, version 1.6.7. 324 lines.

- Page: https://pluginprobe.com/plugins/erp/1.6.7/code/modules/hrm/includes/api/class-hrm-reports-controller.php
- Raw: https://pluginprobe.com/plugins/erp/1.6.7/raw/modules/hrm/includes/api/class-hrm-reports-controller.php
- Modified: 2020-10-29T12:26:44+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/erp/1.6.7/code/modules/hrm/includes/api/class-hrm-reports-controller.php#L10-L20`.

```php
<?php

namespace WeDevs\ERP\HRM\API;

use WeDevs\ERP\API\REST_Controller;
use WP_Error;
use WP_REST_Response;
use WP_REST_Server;

class HRM_Reports_Controller extends REST_Controller {

    /**
     * Endpoint namespace.
     *
     * @var string
     */
    protected $namespace = 'erp/v1';

    /**
     * Route base.
     *
     * @var string
     */
    protected $rest_base = 'hrm/reports';

    /**
     * Register the routes for the objects of the controller.
     */
    public function register_routes() {
        register_rest_route( $this->namespace, '/' . $this->rest_base . '/age-profiles', [
            [
                'methods'             => WP_REST_Server::READABLE,
                'callback'            => [ $this, 'get_age_profiles' ],
                'permission_callback' => function ( $request ) {
                    return current_user_can( 'erp_hr_manager' );
                },
            ],
        ] );

        register_rest_route( $this->namespace, '/' . $this->rest_base . '/gender-profiles', [
            [
                'methods'             => WP_REST_Server::READABLE,
                'callback'            => [ $this, 'get_gender_profiles' ],
                'permission_callback' => function ( $request ) {
                    return current_user_can( 'erp_hr_manager' );
                },
            ],
        ] );

        register_rest_route( $this->namespace, '/' . $this->rest_base . '/head-counts', [
            [
                'methods'             => WP_REST_Server::READABLE,
                'callback'            => [ $this, 'get_head_counts' ],
                'args'                => $this->get_collection_params(),
                'permission_callback' => function ( $request ) {
                    return current_user_can( 'erp_hr_manager' );
                },
            ],
        ] );

        register_rest_route( $this->namespace, '/' . $this->rest_base . '/salary-histories', [
            [
                'methods'             => WP_REST_Server::READABLE,
                'callback'            => [ $this, 'get_salary_histories' ],
                'args'                => $this->get_collection_params(),
                'permission_callback' => function ( $request ) {
                    return current_user_can( 'erp_hr_manager' );
                },
            ],
        ] );

        register_rest_route( $this->namespace, '/' . $this->rest_base . '/year-of-services', [
            [
                'methods'             => WP_REST_Server::READABLE,
                'callback'            => [ $this, 'get_year_of_services' ],
                'args'                => $this->get_collection_params(),
                'permission_callback' => function ( $request ) {
                    return current_user_can( 'erp_hr_manager' );
                },
            ],
        ] );
    }

    /**
     * Get a collection of age profiles
     *
     * @param WP_REST_Request $request
     *
     * @return WP_Error|WP_REST_Response
     */
    public function get_age_profiles( $request ) {
        $args = [
            'number'    => $request['per_page'],
            'offset'    => ( $request['per_page'] * ( $request['page'] - 1 ) ),
            'dimension' => isset( $request['dimension'] ) ? $request['dimension'] : 'general',
        ];

        $employees = new \WeDevs\ERP\HRM\Models\Employee();

        if ( $args['dimension'] == 'department' ) {
            $departments = erp_hr_get_departments();

            $emp_all_data = [];

            foreach ( $departments as $department ) {
                $emp_by_dept = $employees->where( 'department', $department->id )->get();
                $breakdown   = get_employee_breakdown_by_age( $emp_by_dept );

                $emp_all_data[ $department->name ] = $breakdown;
            }
        } else {
            $emp_all      = $employees->get();
            $emp_all_data = get_employee_breakdown_by_age( $emp_all );
        }

        $formated_items = $emp_all_data;

        $response = rest_ensure_response( $formated_items );
        $response = $this->format_collection_response( $response, $request, 0 );

        return $response;
    }

    /**
     * Get a collection of gender profiles
     *
     * @param WP_REST_Request $request
     *
     * @return WP_Error|WP_REST_Response
     */
    public function get_gender_profiles( $request ) {
        $args = [
            'number'    => $request['per_page'],
            'offset'    => ( $request['per_page'] * ( $request['page'] - 1 ) ),
            'dimension' => isset( $request['dimension'] ) ? $request['dimension'] : 'general',
        ];

        if ( $args['dimension'] == 'department' ) {
            $departments = erp_hr_get_departments();

            $gender_ratio = [];

            foreach ( $departments as $department ) {
                $count_by_dept = erp_hr_get_gender_count( $department->id );

                $gender_ratio[ $department->name ] = $count_by_dept;
            }
        } else {
            $gender_ratio = erp_hr_get_gender_ratio_data();
        }

        $formated_items = $gender_ratio;

        $response = rest_ensure_response( $formated_items );
        $response = $this->format_collection_response( $response, $request, 0 );

        return $response;
    }

    /**
     * Get a collection of head counts
     *
     * @since 1.0.0
     *
     * @param $request
     *
     * @return mixed|object|WP_Error|WP_REST_Response
     */
    public function get_head_counts( $request ) {
        $args = [
            'number' => $request['per_page'],
            'offset' => ( $request['per_page'] * ( $request['page'] - 1 ) ),
            'type'   => isset( $request['type'] ) ? $request['type'] : 'summary',
        ];

        if ( ! in_array( $request['type'], [ 'summary', 'list' ] ) ) {
            return new WP_Error( 'rest_performance_invalid_type', __( 'Invalid Type received' ), [ 'status' => 400 ] );
        }

        $formatted_items = [];
        $total           = 0;

        if ( $args['type'] == 'summary' ) {
            $this_month = current_time( 'Y-m-01' );
            $chart_data = [];

            for ( $i = 0; $i <= 11; $i ++ ) {
                $month    = date( 'Y-m', strtotime( $this_month . " -$i months" ) );
                $js_month = strtotime( $month . '-01' ) * 1000;
                $count    = erp_hr_get_headcount( $month, '', 'month' );

                $chart_data[] = (object) [
                    'month' => $month,
                    'count' => $count,
                ];
            }
            $formatted_items = $chart_data;
            $total           = count( $chart_data );
        } else {
            global $wpdb;

            $user_ids = $wpdb->get_col( "SELECT user_id FROM {$wpdb->prefix}erp_hr_employees LIMIT {$args['number']} OFFSET {$args['offset']}" );
            $total    = (int) $wpdb->get_var( "SELECT count(*) FROM {$wpdb->prefix}erp_hr_employees" );

            foreach ( $user_ids as $user_id ) {
                $data                = [];
                $employee            = new \WeDevs\ERP\HRM\Employee( intval( $user_id ) );
                $data['id']          = $user_id;
                $data['name']        = $employee->get_full_name();
                $data['avatar_url']  = $employee->get_avatar_url( 80 );
                $data['hiring_date'] = $employee->hiring_date;
                $data['job_title']   = $employee->get_job_title();
                $data['department']  = $employee->get_department_title();
                $data['location']    = $employee->get_work_location();
                $data['status']      = $employee->get_status();
                $formatted_items[]   = $data;
            }
        }

        $response = rest_ensure_response( $formatted_items );
        $response = $this->format_collection_response( $response, $request, $total );

        return $response;
    }

    /**
     * Get a collection of salary histories
     *
     * @param WP_REST_Request $request
     *
     * @return WP_Error|WP_REST_Response
     */
    public function get_salary_histories( $request ) {
        $args = [
            'number' => $request['per_page'],
            'offset' => ( $request['per_page'] * ( $request['page'] - 1 ) ),
        ];

        global $wpdb;

        $user_ids    = $wpdb->get_col( "SELECT user_id FROM {$wpdb->prefix}erp_hr_employees LIMIT {$args['number']} OFFSET {$args['offset']}" );
        $total_items = (int) $wpdb->get_var( "SELECT count(*) FROM {$wpdb->prefix}erp_hr_employees" );

        $date_format = get_option( 'date_format' );

        $formated_items = [];

        foreach ( $user_ids as $user_id ) {
            $employee      = new \WeDevs\ERP\HRM\Employee( intval( $user_id ) );
            $compensations = $employee->get_job_histories( 'compensation' );

            $data = [];

            if ( !empty( $compensations['compensation'] ) ) {
                foreach ( $compensations['compensation'] as $compensation ) {
                    $data[] = [
                        'employee_id'   => (int) esc_attr( $employee->id ),
                        'employee_name' => $employee->display_name,
                        'avatar_url'    => $employee->get_avatar_url( 80 ),
                        'date'          => date( $date_format, strtotime( esc_attr( $compensation['date'] ) ) ),
                        'pay_rate'      => (int) esc_attr( $compensation['pay_rate'] ),
                        'pay_type'      => esc_attr( $compensation['pay_type'] ),
                    ];
                }
            }

            if ( $data ) {
                $formated_items[] = $data;
            }
        }
        $response = rest_ensure_response( $formated_items );
        $response = $this->format_collection_response( $response, $request, $total_items );

        return $response;
    }

    /**
     * Get a collection of year of services
     *
     * @param WP_REST_Request $request
     *
     * @return WP_Error|WP_REST_Response
     */
    public function get_year_of_services( $request ) {
        $args = [
            'number' => $request['per_page'],
            'offset' => ( $request['per_page'] * ( $request['page'] - 1 ) ),
        ];

        global $wpdb;

        $user_ids = $wpdb->get_col( "SELECT user_id FROM {$wpdb->prefix}erp_hr_employees WHERE status = 'active' LIMIT {$args['number']} OFFSET {$args['offset']}" );

        $total_items = $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->prefix}erp_hr_employees WHERE status = 'active'" );

        $hire_data = [];

        foreach ( $user_ids as $user_id ) {
            $employee = new \WeDevs\ERP\HRM\Employee( intval( $user_id ) );
            $date     = date_parse_from_format( 'Y-m-d', $employee->hiring_date );
            $month    = $date['month'];
            $day      = $date['day'];

            if ( $month > 0 ) {
                $hire_data[ $month ][ $day ][] = [
                    'employee_id'   => (int) $employee->id,
                    'employee_name' => $employee->display_name,
                    'hiring_date'   => $employee->hiring_date,
                    'job_age'       => date( 'Y', time() ) - date( 'Y', strtotime( $employee->hiring_date ) ),
                ];
            }
        }

        ksort( $hire_data );

        $formated_items = $hire_data;

        $response = rest_ensure_response( $formated_items );
        $response = $this->format_collection_response( $response, $request, $total_items );

        return $response;
    }
}

```