//  
include_once($_SERVER['DOCUMENT_ROOT'].'/inc/error_reporting.php');

//  
include_once($_SERVER['DOCUMENT_ROOT'].'/inc/config.php');

//$dbh = mysql_connect($CONF['dbHost'],$CONF['dbUser'],$CONF['dbPass']) or die ('no connect Mysql');
//mysql_select_db($CONF['dbName'],$dbh) or die ("Can't connect DB");
//mysql_query("SET NAMES 'cp1251'") or die(mysql_error());

//  
$smarty = new Smarty();

$smarty->template_dir = $CONF['pathTmpl'];
$smarty->compile_dir  = $CONF['pathTmpl'].'templates_c/';
$smarty->config_dir   = $CONF['pathTmpl'].'configs/';
$smarty->cache_dir    = $CONF['pathTmpl'].'cache/';

$smarty->caching = false;
$smarty->debugging = DEBUG;

if ( $_SERVER['HTTP_HOST'] == 'demet.loc' ) $smarty->debugging = true;

$smarty->assign('padding',0);
$smarty->assign('full_list',false);
$smarty->assign('act','');
$smarty->assign('backurl_en',urlencode($_SERVER["REQUEST_URI"]));

$dbLib = new DB();

// 
$smarty->assign('menu', $dbLib->getAssocRows('SELECT header as header, url FROM pages WHERE left_menu = 1 ORDER BY left_sort DESC'));

//   
$res = $dbLib->query('SELECT name, value FROM settings');
$set = [];
while ($row = mysqli_fetch_assoc($res)) {
	$set[$row['name']] = $row['value'];
}
$CONF['settings'] = $set;
$smarty->assign('settings',$set);

//   
$res = $dbLib->query('SELECT name, value FROM stat');
$set = [];
while ($row = mysqli_fetch_assoc($res)) {
	$set[$row['name']] = $row['value'];
}
$smarty->assign('stat',$set);

if (isset($_SESSION['login'])) {
  $smarty->assign('user', $_SESSION['login']);
  $smarty->assign('user_name', $_SESSION['user_name']);
}

//  
$res = $dbLib->query('SELECT *, DATE_FORMAT(date,"%d.%m.%Y") as date FROM news WHERE visible = 1 AND abroad = 1 AND `date` <= NOW() ORDER BY sort DESC, id DESC LIMIT 5');
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	$row['date'] = formatMonth($row['date']);
	$data[] = $row;
}
$smarty->assign('abroad', $data);

$res = $dbLib->query('SELECT *, DATE_FORMAT(date,"%d.%m.%Y") as date FROM news WHERE visible = 1 AND abroad = 1 AND `date` <= NOW() ORDER BY sort DESC, id DESC LIMIT 5,5');
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
    $row['date'] = formatMonth($row['date']);
    $data[] = $row;
}
$smarty->assign('abroad_add', $data);


// 
$res = $dbLib->query("SELECT id, header, 'news' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM news
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1 
UNION
SELECT id, name AS header, 'glavnoe' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM vibor
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1
UNION
SELECT id, name AS header, 'vybor' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM ann2
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1
UNION
SELECT id, name AS header, 'osp' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM osp
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1
ORDER BY sort DESC, date_news DESC, id DESC LIMIT 5");
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	$row['date'] = formatMonth($row['date']);
	$data[] = $row;
}
$smarty->assign('news_main', $data);

$res = $dbLib->query("SELECT id, header, 'news' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM news
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1 
UNION
SELECT id, name AS header, 'glavnoe' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM vibor
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1
UNION
SELECT id, name AS header, 'vybor' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM ann2
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1
UNION
SELECT id, name AS header, 'osp' AS tbl, sort, DATE_FORMAT(date,'%d.%m.%Y') as date, date as date_news, visible FROM osp
WHERE visible = 1 AND `date` <= NOW() AND in_news = 1 
ORDER BY sort DESC, date_news DESC, id DESC LIMIT 5,5");
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
    $row['date'] = formatMonth($row['date']);
    $data[] = $row;
}
$smarty->assign('news_main_add', $data);

$smarty->assign('ann_main', $dbLib->getAssocRows('SELECT * FROM ann WHERE visible = 1 ORDER BY sort DESC, id DESC LIMIT ' . $CONF['settings']['ann']));
$smarty->assign('ann_main_new', $dbLib->countRows('SELECT * FROM ann WHERE TO_DAYS(NOW()) - TO_DAYS(created) <= 2 AND visible = 1'));

// > covid
$res = $dbLib->query('SELECT * FROM covid WHERE type = 1');
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	$row['new'] = $dbLib->countRows('SELECT * FROM covid WHERE TO_DAYS(NOW()) - TO_DAYS(created) <= 2 AND parent_id = ?', [$row['id']]);
	$data[$row['id']] = $row;
}
$smarty->assign('covid_main_parent', $data);

$res = $dbLib->query('SELECT * FROM covid WHERE visible = 1 ORDER BY parent_id DESC, id DESC LIMIT 10');
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	$data[$row['parent_id']][] = $row;
}
$smarty->assign('covid_main', $data);

$res = $dbLib->query('SELECT * FROM bill WHERE type = 1');
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	$data[$row['id']] = $row;
}
$smarty->assign('bill_main_parent', $data);

$res = $dbLib->query('SELECT * FROM bill WHERE visible = 1 ORDER BY parent_id DESC, id DESC LIMIT 10');
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	$data[$row['parent_id']][] = $row;
}
$smarty->assign('bill_main', $data);

$res = $dbLib->query('SELECT *,DATE_FORMAT(date,"%d.%m.%Y") as date, TO_DAYS(NOW()) - TO_DAYS(date) as diff FROM vibor WHERE visible = 1 ORDER BY sort DESC, id DESC LIMIT ' . $CONF['settings']['vibor']);
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
    //$row['date'] = formatMonth($row['date']);
    $arAuthor = unserialize($row['author']);
	
    if ($arAuthor) {
	    $sAuthor = implode(',', $arAuthor);
	    $res_author = $dbLib->query('SELECT * FROM author WHERE id IN (' . $sAuthor . ') ORDER BY sort DESC, id ASC');
		$data_author = array();
		while ($row_author = mysqli_fetch_assoc($res_author)) {
			$key = array_search($row_author['id'], $arAuthor);
			
			if ($key !== false) {
				$data_author[$key] = $row_author['id'];
			} else {
				$data_author[] = $row_author['id'];
			}
		}
		ksort($data_author);
		$row['authors'] = $data_author[0];
		
	}$row['ann'] = strip_tags($row['ann']);
	$withoutTags = strip_tags($row['text']);
	$count = str_word_count($withoutTags, 0, '?ɝ????ڬӥ??');
	$row['time'] = ceil($count/300);
    $data[] = $row;
}

$smarty->assign('vibor_main', $data);

$smarty->assign('vibor_main_new', $dbLib->countRows('SELECT * FROM vibor WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 2 AND visible = 1'));

$smarty->assign('sanctions_main_new', $dbLib->countRows('
SELECT id FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 2 AND visible = 1 AND sanctions = 1 
UNION ALL
SELECT id FROM vibor WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 2 AND visible = 1 AND sanctions = 1 
'));

// 
$res = $dbLib->query('SELECT *, DATE_FORMAT(date,"%d.%m.%Y") as date, TO_DAYS(NOW()) - TO_DAYS(date) as diff FROM ann2 WHERE visible = 1 AND interview = 1  AND `date` <= NOW() AND not_show_on_main = 0 ORDER BY sort DESC, id DESC LIMIT 3');
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	//$row['date'] = formatMonth($row['date']);
	$withoutTags = strip_tags($row['text']);
	$count = str_word_count($withoutTags, 0, '?ɝ????ڬӥ??');
	$row['time'] = ceil($count/300);
	$data[] = $row;
}
$smarty->assign('interview_main', $data);

$res = $dbLib->query('SELECT *, DATE_FORMAT(date,"%d.%m.%Y") as date, TO_DAYS(NOW()) - TO_DAYS(date) as diff FROM ann2 WHERE visible = 1 AND interview = 0 AND `date` <= NOW() ORDER BY sort DESC, id DESC LIMIT ' . $CONF['settings']['ann2']);
$data = [];
while ($row = mysqli_fetch_assoc($res)) {
	//$row['date'] = formatMonth($row['date']);	
	$arAuthor = unserialize($row['author']);
	
	if ($arAuthor) {
	    $sAuthor = implode(',', $arAuthor);
	    $res_au',
	5 => '',
	6 => '',
	7 => '',
];

$arr_months = [
	1 => '',
	2 => '',
	3 => '',
	4 => '',
	5 => '',
	6 => '',
	7 => '',
	8 => '',
	9 => '',
	10 => '',
	11 => '',
	12 => ''
];

$current_date = $arr_days[date('N')] . ', ' . date('j') . ' ' . $arr_months[date('n')] . ' ' . date('Y') . ' .';

$smarty->assign('current_date', $current_date);
?>