$user['id'], 'group_id'=>(int)$user['field_6'], 'name'=> users::output_heading_from_item($user), 'email'=>$user['field_9'], 'language'=>$user['field_13'], ); $where_sql = ''; //check hidden common reports if(strlen(users_cfg::get_value_by_users_id($app_user['id'],'hidden_common_reports'))>0) { $where_sql = " and r.id not in (" . users_cfg::get_value_by_users_id($app_user['id'],'hidden_common_reports') . ")"; } //get common reports list $common_reports_list = array(); $reports_query = db_query("select r.* from app_reports r, app_entities e, app_entities_access ea where r.entities_id = e.id and e.id=ea.entities_id and length(ea.access_schema)>0 and ea.access_groups_id='" . db_input($app_user['group_id']) . "' and find_in_set(" . $app_user['group_id'] . ",r.users_groups) and r.reports_type = 'common' " . $where_sql . " order by r.dashboard_sort_order, r.name"); while($reports = db_fetch_array($reports_query)) { $common_reports_list[] = $reports['id']; } //echo '

'; $reports_query = db_query("select * from app_reports where ((created_by='" . $app_user['id'] . "' and reports_type='standard') " . (count($common_reports_list)>0 ? " or id in(" . implode(',',$common_reports_list). ")" : "") . ") and find_in_set('" . date('N'). "',notification_days) and find_in_set('" . date('H') . "',notification_time)"); while($reports = db_fetch_array($reports_query)) { $items_info = $hot_reports->get_items($reports,array('is_email'=>true)); //echo '
';
				//print_r($reports);
				
				if($items_info['items_count']>0)
				{				
					$reports_url = CRON_HTTP_SERVER_HOST . 'index.php?module=reports/view&reports_id=' . $reports['id'];
					
					$items_html = $this->render_items_html($items_info);
					
					$number_of_items_html = sprintf(TEXT_DISPLAY_NUMBER_OF_ITEMS,1,($items_info['items_count']>$hot_reports->poup_items_limit ? $hot_reports->poup_items_limit : $items_info['items_count']), $items_info['items_count']);
					
					$email_html = sprintf(TEXT_REPORTS_NOTIFICATION_EMAIL,$reports['name']) . '
' . $reports_url . '
' . $reports['name'] . ':
' . $items_html . $number_of_items_html;
							
					//echo '
' . $app_user['email'] . '
' . $email_html;
					
					$options = array('to' => $app_user['email'],
							'to_name' => $app_user['name'],
							'subject'=> $reports['name'],
							'body'=> $email_html,
							'from'=> CFG_EMAIL_ADDRESS_FROM,
							'from_name'=>CFG_EMAIL_NAME_FROM);
					 
					users::send_email($options);
					
				}
			}	
		}
	}
	
	function render_items_html($items_info)
	{
		$html = '';
		
		if($items_info['items_count']>0)
		{
			$html = '';
		}
		
		return $html;		
	}
}