會員統計:

';print_r($ary_tbl);exit; #debug
  $s.='[==== 今日以來(過去24小時) ====]'
  .$tbody[0]
  .'[==== 七日內(過去168小時) ====]'
  .$tbody[1]
  .'[==== 上架以來 ====]'
  .$tbody[2]
  ;


  $s.='
職缺統計:
  1. 職缺總數: '.$job_count.' 

  2. 上架職缺總數: '.$visible_job_count.'

  3. 待審職缺數: '.$wait4verify_job_count.'

  '.($wait4verify_job_list ? '
'.$wait4verify_job_list.'
' : '');
  $expired_list = '';
  /*
  foreach(array( #30,60,
  90
  #,120,150,
  ,180
  #,210,240,270,300,330,360
  )as$i=>$x){
    ${'date_after_'.$x.'days'} = date("Y-m-d", strtotime('+'.$x.' day', $now_timestamp));
    $q = $this->get(PDO::class)->query(
        $sql_visible_job . ' AND `date_expired`<"'.${'date_after_'.$x.'days'}.'"');
    ${'expired_job_count_after_'.$x.'days'} = $q->rowCount();
    $expired_list.='
'.(($i+1)*3).'個月內到期之職缺總數: '.${'expired_job_count_after_'.$x.'days'}.'
';
  }*/
  $date_after_90days = date('Y-m-d', strtotime('+90 day', $now_timestamp));
  $date_after_180days = date('Y-m-d', strtotime('+180 day', $now_timestamp));
  $q = $this->get(PDO::class)->query($sql_visible_job . ' AND `date_expired`<"'.$date_after_90days.'"');
  $expired_job_count_within_90days = $q->rowCount();
  $expired_list.='
3個月內到期之職缺總數: '.$expired_job_count_within_90days.'
';
  $q = $this->get(PDO::class)->query($sql_visible_job . ' AND `date_expired`>="'.$date_after_90days.'" AND `date_expired`<"'.$date_after_180days.'"');
  $expired_job_count_between_90day_and_180day = $q->rowCount();
  $expired_list.='
3 ~ 6個月內到期之職缺總數: '.$expired_job_count_between_90day_and_180day.'
';
  $q = $this->get(PDO::class)->query($sql_visible_job . ' AND `date_expired`>="'.$date_after_180days.'"');
  $expired_job_count_after_180days = $q->rowCount();
  $expired_list.='
超過6個月到期之職缺總數: '.$expired_job_count_after_180days.'
';

  $s.='4. 職缺到期統計:
'.($expired_list ? '
'.$expired_list.'
' : '');  
  
  $q = $this->get(PDO::class)->query(str_replace('*','COUNT(`id`) AS c, `company`',$sql_visible_job).' GROUP BY `company` ORDER BY c DESC LIMIT 5');
  $top_company_list = '';
  while($row = $q->fetch()) {
    $top_company_list.='
'.$row['company'].' ('.$row['c'].')
';
  }
  $s .= '5. 職缺數前五名公司(上架中):

  
'.$top_company_list.'
';
  # [==== 當日 ====]
                                     
  # [==== 七日內 ====]
       
  
  $q = $this->get(PDO::class)->query($sql_visible_job . ' ORDER BY browse_count DESC LIMIT 10');
  $topview_job_list = '';
  while($row = $q->fetch()) {
    $topview_job_list .= '
'.$row['company'].' - ' . $row['job_title'] . ' - ' . $row['browse_count'].'
';
  }
  $sql_visible_job_innerjoin_jobbrowse = str_replace('`jobs`', '`jobs` INNER JOIN `job_browse` ON job_browse.job_id=jobs.id ', $sql_visible_job);
  foreach(array(168, 24)as$hour){
    ${'date_before_'.$hour.'hour'} = date('Y-m-d', strtotime('-'.$hour.' hour', $now_timestamp));
  }
  foreach(array(168,24)as$hour){
    $sql = str_replace('SELECT * ',
                      'SELECT COUNT(job_id) browse_count,job_id,company,job_title ',
                      $sql_visible_job_innerjoin_jobbrowse)
            .' AND `datetime`>="'.${'date_before_'.$hour.'hour'}.'" GROUP BY job_id ORDER BY browse_count DESC LIMIT 10';
    $q = $this->get(PDO::class)->query($sql);
    ${'topview_job_list_in_'.$hour.'hr'} = '';
    while($row = $q->fetch()) {
      ${'topview_job_list_in_'.$hour.'hr'} .= '
'.$row['company'].' - ' . $row['job_title'] . ' - ' . $row['browse_count'].'
';
    }
  }
  #
  $q = $this->get(PDO::class)->query($sql_visible_job . ' ORDER BY submit_count DESC LIMIT 5');
  $topapply_job_list = '';
  while($row = $q->fetch()) {
    $topapply_job_list .= '
'.$row['company'].' - ' . $row['job_title'] . ' - ' . $row['submit_count'].'
';
  }
  $sql_visible_job_innerjoin_application = str_replace('`jobs`', '`jobs` INNER JOIN `application` ON application.job_id=jobs.id ', $sql_visible_job);
  foreach(array(168,24)as$hour){
    $sql = str_replace('SELECT * ',
                      'SELECT COUNT(job_id) submit_count,job_id,company,job_title ',
                      $sql_visible_job_innerjoin_application)
            .' AND `send_time`>="'.${'date_before_'.$hour.'hour'}.'" GROUP BY job_id ORDER BY submit_count DESC LIMIT 5';
    $q = $this->get(PDO::class)->query($sql);
    ${'topapply_job_list_in_'.$hour.'hr'} = '';
    while($row = $q->fetch()) {
      ${'topapply_job_list_in_'.$hour.'hr'} .= '
'.$row['company'].' - ' . $row['job_title'] . ' - ' . $row['submit_count'].'
';
    }
  }

  $s.='6. 上架中(不含已過期或下架中)的職缺瀏覽人數前十名 

  (公司名稱) (職缺名稱) (瀏覽人數)

  [==== 今日以來(過去24小時) ====]

  '.($topview_job_list_in_24hr ? '
'.$topview_job_list_in_24hr.'
' : '').
  '[==== 七日內(過去168小時) ====]

  '.($topview_job_list_in_168hr ? '
'.$topview_job_list_in_168hr.'
' : '').
  '[==== 上架以來 ====]

  '.($topview_job_list ? '
'.$topview_job_list.'
' : '').
  '7. 上架中(不含已過期或下架中)的職缺履歷投送前五名

  (公司名稱) (職缺名稱) (瀏覽人數)

  [==== 今日以來(過去24小時) ====]

  '.($topapply_job_list_in_24hr ? '
'.$topapply_job_list_in_24hr.'
' : '').
  '[==== 七日內(過去168小時) ====]

  '.($topapply_job_list_in_168hr ? '
'.$topapply_job_list_in_168hr.'
' : '').
  '[==== 上架以來 ====]

  '.($topapply_job_list ? '
'.$topapply_job_list.'
' : '');
  // sending email
  if(isset($_GET['debug_stats']) and IS_DEVELOPER){
    echo$s;
    die('debugging...');
  }else{
    $ary_emails = IS_DEV
              ? array('wei@sted.tw')
              : array(
                      'richie.tsai@sted.tw',
                      'ben.wang@sted.tw',
);
    $subj = '[JOBS.AIA] 每日統計 @ '.date('Y-m-d');
    if($valid_member_count>=1000){
      $_ = '【達成：有效會員數破1000】';
      $subj .= $_;
      $s = $_ .'
' . $s;
    }
    if($visible_job_count>=100){
      $_ =  '【達成：目前上架中職缺數破100】';
      $subj .= $_;
      $s = $_ . '
' . $s;
    }
    send_mail_base($ary_emails, $subj, $s);
  }
  return $response;
});