File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/finance/dashboard/versus_years.php

Back
<?php header('Content-Type: application/json'); include_once("../../../cfg/db.php"); include_once("../../../api/controllers/utility.php"); $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; $company = ""; $dealer = ""; if(isset($_POST['company']) && $_POST['company'] != 0){ $company = $db->escape($_POST['company']); $company = " AND company_id = $company "; } else { $company = " AND company_id IN(" . $granted_company_ids . ") "; } if(isset($_POST['dealer']) && $_POST['dealer'] != 0){ $dealer = $db->escape($_POST['dealer']); $dealer = " AND dealer_id = $dealer "; } $selected_year = $db->select("SELECT YEAR(CURDATE()) AS year_now"); $previous_year = $selected_year - 1; $previous_year_2 = $selected_year - 2; $current_monthly_array = array(); $previous_monthly_array = array(); $previous_monthly_array_2 = array(); $json_arr = array(); // current year if($selected_year%4 == 0){ $current_monthly_array = [$selected_year . "-01-01", $selected_year . "-01-31", $selected_year . "-02-01", $selected_year . "-02-29", $selected_year . "-03-01", $selected_year . "-03-31", $selected_year . "-04-01", $selected_year . "-04-30", $selected_year . "-05-01", $selected_year . "-05-31", $selected_year . "-06-01", $selected_year . "-06-30", $selected_year . "-07-01", $selected_year . "-07-31", $selected_year . "-08-01", $selected_year . "-08-31", $selected_year . "-09-01", $selected_year . "-09-30", $selected_year . "-10-01", $selected_year . "-10-31", $selected_year . "-11-01", $selected_year . "-11-30", $selected_year . "-12-01", $selected_year . "-12-31"]; } else { $current_monthly_array = [$selected_year . "-01-01", $selected_year . "-01-31", $selected_year . "-02-01", $selected_year . "-02-28", $selected_year . "-03-01", $selected_year . "-03-31", $selected_year . "-04-01", $selected_year . "-04-30", $selected_year . "-05-01", $selected_year . "-05-31", $selected_year . "-06-01", $selected_year . "-06-30", $selected_year . "-07-01", $selected_year . "-07-31", $selected_year . "-08-01", $selected_year . "-08-31", $selected_year . "-09-01", $selected_year . "-09-30", $selected_year . "-10-01", $selected_year . "-10-31", $selected_year . "-11-01", $selected_year . "-11-30", $selected_year . "-12-01", $selected_year . "-12-31"]; } // previous year if($previous_year%4 == 0){ $previous_monthly_array = [$previous_year . "-01-01", $previous_year . "-01-31", $previous_year . "-02-01", $previous_year . "-02-29", $previous_year . "-03-01", $previous_year . "-03-31", $previous_year . "-04-01", $previous_year . "-04-30", $previous_year . "-05-01", $previous_year . "-05-31", $previous_year . "-06-01", $previous_year . "-06-30", $previous_year . "-07-01", $previous_year . "-07-31", $previous_year . "-08-01", $previous_year . "-08-31", $previous_year . "-09-01", $previous_year . "-09-30", $previous_year . "-10-01", $previous_year . "-10-31", $previous_year . "-11-01", $previous_year . "-11-30", $previous_year . "-12-01", $previous_year . "-12-31"]; } else { $previous_monthly_array = [$previous_year . "-01-01", $previous_year . "-01-31", $previous_year . "-02-01", $previous_year . "-02-28", $previous_year . "-03-01", $previous_year . "-03-31", $previous_year . "-04-01", $previous_year . "-04-30", $previous_year . "-05-01", $previous_year . "-05-31", $previous_year . "-06-01", $previous_year . "-06-30", $previous_year . "-07-01", $previous_year . "-07-31", $previous_year . "-08-01", $previous_year . "-08-31", $previous_year . "-09-01", $previous_year . "-09-30", $previous_year . "-10-01", $previous_year . "-10-31", $previous_year . "-11-01", $previous_year . "-11-30", $previous_year . "-12-01", $previous_year . "-12-31"]; } // previous year 2 if($previous_year_2%4 == 0){ $previous_monthly_array_2 = [$previous_year_2 . "-01-01", $previous_year_2 . "-01-31", $previous_year_2 . "-02-01", $previous_year_2 . "-02-29", $previous_year_2 . "-03-01", $previous_year_2 . "-03-31", $previous_year_2 . "-04-01", $previous_year_2 . "-04-30", $previous_year_2 . "-05-01", $previous_year_2 . "-05-31", $previous_year_2 . "-06-01", $previous_year_2 . "-06-30", $previous_year_2 . "-07-01", $previous_year_2 . "-07-31", $previous_year_2 . "-08-01", $previous_year_2 . "-08-31", $previous_year_2 . "-09-01", $previous_year_2 . "-09-30", $previous_year_2 . "-10-01", $previous_year_2 . "-10-31", $previous_year_2 . "-11-01", $previous_year_2 . "-11-30", $previous_year_2 . "-12-01", $previous_year_2 . "-12-31"]; } else { $previous_monthly_array_2 = [$previous_year_2 . "-01-01", $previous_year_2 . "-01-31", $previous_year_2 . "-02-01", $previous_year_2 . "-02-28", $previous_year_2 . "-03-01", $previous_year_2 . "-03-31", $previous_year_2 . "-04-01", $previous_year_2 . "-04-30", $previous_year_2 . "-05-01", $previous_year_2 . "-05-31", $previous_year_2 . "-06-01", $previous_year_2 . "-06-30", $previous_year_2 . "-07-01", $previous_year_2 . "-07-31", $previous_year_2 . "-08-01", $previous_year_2 . "-08-31", $previous_year_2 . "-09-01", $previous_year_2 . "-09-30", $previous_year_2 . "-10-01", $previous_year_2 . "-10-31", $previous_year_2 . "-11-01", $previous_year_2 . "-11-30", $previous_year_2 . "-12-01", $previous_year_2 . "-12-31"]; } $query = ""; $current_year_arr = array(); $previous_year_array = array(); $previous_year_array_2 = array(); for($i=0; $i<23; $i++){ $date1 = ""; $date2 = ""; if($i%2 == 0){ $date1 = $current_monthly_array[$i]; $date2 = $current_monthly_array[$i+1]; $query = "SELECT COUNT(1) FROM finance WHERE policy_start_date BETWEEN '$date1' AND '$date2'".$company.$dealer; array_push($current_year_arr, $db->select($query)); $date1 = $previous_monthly_array[$i]; $date2 = $previous_monthly_array[$i+1]; $query = "SELECT COUNT(1) FROM finance WHERE policy_start_date BETWEEN '$date1' AND '$date2'".$company.$dealer; array_push($previous_year_array, $db->select($query)); $date1 = $previous_monthly_array_2[$i]; $date2 = $previous_monthly_array_2[$i+1]; $query = "SELECT COUNT(1) FROM finance WHERE policy_start_date BETWEEN '$date1' AND '$date2'".$company.$dealer; array_push($previous_year_array_2, $db->select($query)); } } // print_r($current_year_arr); return; $json_arr['current_year'] = $selected_year; $json_arr['current'] = $current_year_arr; $json_arr['previous'] = $previous_year_array; $json_arr['previous_2'] = $previous_year_array_2; echo json_encode($json_arr); ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings