function prepareItems(&$items)
{
foreach ($items as &$item) {
$url = getUrl($item);
$item = array('id' => crc32('auto_' . $url), 'target' => getTarget($item['subdomain']), 'url' => $url, 'maker' => isset($item['maker']) ? $item['maker'] : '', 'model' => isset($item['model']) ? $item['model'] : '', 'year' => isset($item['year']) ? $item['year'] : '', 'fuel' => isset($item['fuel']) ? $item['fuel'] : '', 'color' => isset($item['color']) ? $item['color'] : '', 'type' => isset($item['type']) ? $item['type'] : '', 'min_price' => isset($item['min_price']) ? $item['min_price'] : '', 'body_type' => isset($item['body_type']) ? $item['body_type'] : '', 'city_name' => isset($item['city_name']) ? $item['city_name'] : '', 'total' => isset($item['total']) ? $item['total'] : '', 'calc' => isset($item['calc']) ? $item['calc'] : '');
}
}
function updateUrl($arr, $mysqli)
{
$subdomain = '';
$geo_params = '';
$vacancy = '';
if (isset($arr['vacancy']) && !empty($arr['vacancy'])) {
$sql = "\n SELECT `translit`\n FROM ru_eyezeek.translitted_values\n WHERE `origin`='{$arr['vacancy']}'\n LIMIT 1\n ";
if ($result = $mysqli->query($sql)) {
$position = $result->fetch_assoc();
if ($position['translit']) {
$vacancy = trim($position['translit']);
} else {
return array();
}
} else {
return array();
}
}
if (isset($arr['geo']) && !empty($arr['geo'])) {
$sql = "\n SELECT `id`,`translit`,`subdomain`\n FROM ru_geo.kladr\n WHERE `name`='{$arr['geo']}' AND `socr`='г' AND SUBSTRING(`code`,12,2)='00'\n ORDER BY SUBSTRING(`code`,3,3)\n LIMIT 1\n ";
if ($result = $mysqli->query($sql)) {
$kladr = $result->fetch_assoc();
if (!empty($kladr)) {
$subdomain = $kladr['subdomain'] == '' ? $kladr['subdomain'] : $kladr['subdomain'] . '.';
if ($kladr['subdomain'] != $kladr['translit']) {
$geo_params = '?region=' . $kladr['translit'] . '®ion_id=' . $kladr['id'];
}
} else {
return array();
}
}
}
$arr['url'] = str_replace('%subdomain%', $subdomain, $arr['url']);
$arr['url'] = str_replace('%geo_params%', $geo_params, $arr['url']);
$arr['url'] = str_replace('%vacancy%', $vacancy, $arr['url']);
$arr['id'] = crc32('jobs_' . $arr['url']);
$arr['target'] = getTarget(str_replace('.', '', $subdomain));
return $arr;
}
$defScoreH = ($pdf->GetPageHeight() - $pdf->getSideMargin() * 3) / 2;
$NumEnd = 10;
$subRule = '';
//$MyQuery = "SELECT TtNumEnds FROM Tournament INNER JOIN Tournament*Type AS tt ON ToType=TtId WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$MyQuery = "SELECT ToNumEnds AS TtNumEnds, ToTypeSubRule as subRule FROM Tournament WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) == 1) {
$r = safe_fetch($Rs);
$NumEnd = $r->TtNumEnds;
$subRule = $r->subRule == 'Set1Dist1Arrow';
}
if (!empty($_REQUEST["ScoreBarcode"])) {
$pdf->PrintBarcode = true;
}
// gets the default target face for this tournament
$Target = getTarget($_SESSION['TourId']);
if (!(isset($_REQUEST["ScoreHeader"]) && $_REQUEST["ScoreHeader"] == 1)) {
$pdf->HideHeader();
}
if (!(isset($_REQUEST["ScoreLogos"]) && $_REQUEST["ScoreLogos"] == 1)) {
$pdf->HideLogo();
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST["ScoreDraw"] == "Data") {
$pdf->NoDrawing();
}
if (!empty($_REQUEST['QRCode'])) {
$QRCodeX = 0;
$QRCodeY = 0;
$defScoreH -= 11;
$defScoreY2 += 11;
$quanti = count($_REQUEST['QRCode']);
function prepareSmallCitiesItems($items)
{
$result = array();
foreach ($items as &$item) {
$url = getUrl($item['cityId'], $item);
$offer = array('id' => crc32('realty_' . $url), 'target' => getTarget($item['subdomain']), 'dealType' => $item['dealType'], 'assetType' => $item['assetType'], 'region' => $item['region'], 'geo' => $item['geo'], 'metro' => '', 'neighborhood' => '', 'rooms' => $item['rooms'], 'num' => $item['num'], 'promoted' => $item['promoted'], 'calc' => $item['calc'], 'link' => $url);
array_push($result, $offer);
}
return $result;
}
