public function getJobPostStatistics(CompanyService $company, $user_id, $company_id, $job_id)
{
try {
$response = ['date_lists' => $company->getDateLists($job_id), 'views' => $company->getDailyJobPostViews($job_id), 'matches' => $company->getDailyJobPostMatches($job_id), 'applicants' => $company->getDailyJobPostApplicants($job_id)];
return $this->json_response->success($response);
} catch (Exception $e) {
return $this->json_response->error(['error' => $e->getMessage()]);
}
}
public function testGuzzle(CompanyService $company)
{
/*$client = new GuzzleClient();
$response = $client->request('GET', 'https://maps.googleapis.com/maps/api/geocode/json?address=Horsholmsgade 22C, 1th. Kobenhavnn&key=AIzaSyCThnvUY6ZAV7JakXbKE5Mw8QSdJ4Fa06U');
$data = json_decode($response->getBody()->getContents(),true);
echo "<pre>";
print_r($data['results'][0]['geometry']);
print_r($data['status']);
echo "</pre>";*/
/*$job_post_created_date = date('Y-m-d',strtotime('2016-09-01'));
// $job_post_end_date = date('Y-m-d', strtotime('+30 days',strtotime($job_post_created_date)));
$job_post_end_date = date('Y-m-d', strtotime('2016-09-15'));
echo $job_post_created_date . ' to ' . $job_post_end_date . '<br/>';
$from = date_create($job_post_created_date);
$to = date_create($job_post_end_date);
$date_diff = date_diff($from,$to);
echo $date_diff->format("%a") . '<br/>';
$date_diff_result = (int) $date_diff->format("%a");
$date_lists = [];
for($x = 0 ; $x <= $date_diff_result ; $x++) {
$date_lists[] = [
date('Y-m-d', strtotime("+$x days",strtotime($job_post_created_date))),
0
];
}*/
/*echo "<pre>";
print_r($date_lists);
echo "</pre>";*/
// $viewed_dates = CompanyJobView::select(DB::raw('DATE(created_at) as created_date'),DB::raw('COUNT(*) as count'))->where('job_id','=',3)->groupBy('created_date')->get()->toArray();
// $viewed_dates = CompanyApplyJob::select(DB::raw('DATE(created_at) as created_date'),DB::raw('COUNT(*) as count'))->where('job_id','=',3)->groupBy('created_date')->get()->toArray();
/*$viewed_dates = CompanyJobMatch::select('match_count_date as created_date','match_count as count')->where('job_id','=',3)->groupBy('created_date')->get()->toArray();
echo "<pre>";
print_r($viewed_dates);
echo "</pre>";*/
/*foreach ($date_lists as $key => $date_list) {
foreach ($viewed_dates as $viewed_date) {
if($date_list[0] == $viewed_date['created_date']) {
$date_lists[$key][1] = $viewed_date['count'];
}
}
}
echo "<pre>";
print_r($date_lists);
echo "</pre>";*/
echo "<pre></br>";
echo "Job Post Views</br>";
print_r($company->getDailyJobPostViews(3));
echo "Job Post Matches</br>";
print_r($company->getDailyJobPostMatches(3));
echo "Job Post Applicants</br>";
print_r($company->getDailyJobPostApplicants(3));
echo "</pre>";
}