/**
* Obtiene el listado de usuarios por cada sesion
* @return json
*/
function getUserSession()
{
$sco_id = $_GET['sco_id'];
$date_record_ini = $_GET['date_record_ini'];
$date_record_fin = $_GET['date_record_fin'];
$sesiones = $this->cliente->getReportSessions($sco_id);
foreach ($sesiones['report-meeting-sessions']['row'] as $value) {
$attendance = $this->cliente->getReportMeetingSessionUser($sco_id, $value['@attributes']['asset-id']);
$filtrado = unique_multidim_array($attendance['report-meeting-session-users']['row'], "principal-name", $date_record_ini, $date_record_fin);
if ($filtrado != null) {
$considerar = $filtrado;
}
}
$json->usuarios = $considerar;
echo json_encode($json);
}
echo json_encode($response);
exit;
}
//SELECT busMap.id as map_id, busMap.bus_id, busMap.cat_id, businesses.name as bus_name, Categories.name as cat_name FROM busMap INNER JOIN businesses on businesses.id = busMap.bus_id INNER JOIN Categories on Categories.id = busMap.cat_id
$stmt = $mysqli->prepare('SELECT busMap.id as map_id, busMap.bus_id, busMap.cat_id, businesses.name as bus_name, Categories.name as cat_name FROM busMap INNER JOIN businesses on businesses.id = busMap.bus_id INNER JOIN Categories on Categories.id = busMap.cat_id WHERE cat_id = ? AND businesses.type = "repair"');
$stmt->bind_param('i', $data['cat_id']);
if ($stmt->execute()) {
$result = get_result($stmt);
//$items = $result->fetch_all(MYSQLI_ASSOC);
}
function unique_multidim_array($array, $key)
{
$temp_array = array();
$i = 0;
$key_array = array();
foreach ($array as $val) {
if (!in_array($val[$key], $key_array)) {
$key_array[$i] = $val[$key];
$temp_array[$i] = $val;
}
$i++;
}
return $temp_array;
}
$result = unique_multidim_array($result, "cat_name");
$stmt->close();
$mysqli->close();
// If we make it this far then we'll simply return a successful response
http_response_code(200);
//header('Content-Type: application/json');
echo json_encode($result);
function showResults()
{
global $Actual_link;
global $Lang;
$Actual_link = "http://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}";
if (strpos($Actual_link, '/en/') !== false) {
$Lang = 'en/';
} else {
if (strpos($Actual_link, '/el/') !== false) {
$Lang = 'el/';
} else {
$Lang = '';
}
}
global $prefix;
global $Results;
$source = ' ';
$double = array();
//make array unique
$uniqueResults = unique_multidim_array($Results, 'link');
////////check for diaugeiaKhmdhs////////
////////////////////////////////////////
//////////////////////////////////////////
foreach ($uniqueResults as $key => $row) {
$id[$key] = $row['id'];
}
//print_r($id);
array_multisort($id, SORT_ASC, $uniqueResults);
$uniqueResults = array_reverse($uniqueResults);
//print_r ($uniqueResults);
$last_item = NULL;
$last_item_2 = NULL;
$last_item_3 = NULL;
$last_item_4 = NULL;
$numItems = count($uniqueResults);
$c = 0;
foreach ($uniqueResults as $key => &$row) {
//diaygeia + khmdhs (2 records) become diaygeiakhmdhs (1 record) for buyer and one for seller if exist
echo $c . 'for<br>';
if (strpos($row['link'], 'diaugeia/organization-hybrid') !== false) {
$row['link'] = str_replace('diaugeia/organization-hybrid', 'zdiaugeia/diaugeia-hybrids', $row['link']);
}
if (strpos($row['link'], 'organization-beneficiary') !== false) {
$row['link'] = str_replace('organization-beneficiary', 'zorganization-beneficiary', $row['link']);
}
echo 'r=' . $row['link'] . '<br>';
echo 'l2=' . $last_item_2['link'] . '<br>';
//echo substr($row['link'],strpos($row['link'], "?=") );
if ($last_item['id'] === $row['id']) {
//if (($last_item['id'] === $row['id']) || (substr($row['link'],strpos($row['link'], "?=") ) == substr($last_item['link'],strpos($last_item['link'], "?=") ) )) {
//if ((substr($row['id'],strpos($row['id'], "?=") )) == (substr($last_item['id'],strpos($last_item['id'], "?=") ))) {
$double[] = $last_item;
//copy doubles to other table
//echo $last_item['id'].'/deleted<br>';
if (strpos($row['link'], '/diaugeia/') !== false) {
//DIAUGEIA
$row['dk_flag'] = 'd';
$row['link'] = str_replace('diaugeia', 'diaugeiakhmdhs', $row['link']);
$row['lastUpdate_2'] = $last_item['lastUpdate'];
$row['contractAmountPrev_2'] = $last_item['contractAmountPrev'];
$row['contractAmountCur_2'] = $last_item['contractAmountCur'];
$row['paymentAmountPrev_2'] = $last_item['paymentAmountPrev'];
$row['paymentAmountCur_2'] = $last_item['paymentAmountCur'];
$row['contractItemsNo_2'] = $last_item['contractItemsNo'];
$row['paymentItemsNo_2'] = $last_item['paymentItemsNo'];
} else {
if (strpos($row['link'], '/khmdhs/') !== false) {
//KHMDHS
$row['dk_flag'] = 'k';
$row['link'] = str_replace('khmdhs', 'diaugeiakhmdhs', $row['link']);
$row['address'] = $last_item['address'];
$row['pc'] = $last_item['pc'];
$row['city'] = $last_item['city'];
$row['lastUpdate_2'] = $last_item['lastUpdate'];
//echo $row['lastUpdate_2'];
$row['award0_2'] = $last_item['award0'];
$row['award1_2'] = $last_item['award1'];
$row['award2_2'] = $last_item['award2'];
$row['awardCnt0_2'] = $last_item['awardCnt0'];
$row['awardCnt1_2'] = $last_item['awardCnt1'];
$row['awardCnt2_2'] = $last_item['awardCnt2'];
$row['spend0_2'] = $last_item['spend0'];
$row['spend1_2'] = $last_item['spend1'];
$row['spend2_2'] = $last_item['spend2'];
$row['spendCnt0_2'] = $last_item['spendCnt0'];
$row['spendCnt1_2'] = $last_item['spendCnt1'];
$row['spendCnt2_2'] = $last_item['spendCnt2'];
}
}
$row['score'] = $row['score'] + $last_item['score'];
}
if (substr($row['id'], strpos($row['id'], "?=")) == substr($last_item['id'], strpos($last_item['id'], "?=")) && substr($last_item_2['id'], strpos($last_item_2['id'], "?=")) == substr($last_item['id'], strpos($last_item['id'], "?="))) {
echo 'found:' . substr($row['id'], strpos($row['id'], "?="));
echo 'found:' . substr($last_item_2['id'], strpos($last_item_2['id'], "?="));
$double[] = $last_item_2;
echo $last_item_2['link'] . 'ok!<br>';
}
//echo 'current '.$row['id'].'<br>';
//echo 'prev '.$last_item['id'].'<br>';
if (++$c !== $numItems) {
//echo "not last index!";
$last_item = $row;
$last_item_2 = $last_item;
}
}
//print_r($double);
$c = 0;
$toMerge = 0;
//$sort = array();
/////////////////hybrid///////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////
foreach ($uniqueResults as $key => &$row) {
$sort['id'][$key] = substr($row['id'], strpos($row['id'], "?="));
$sort['link'][$key] = $row['link'];
}
array_multisort($sort['id'], SORT_ASC, $sort['link'], SORT_ASC, $uniqueResults);
foreach ($uniqueResults as $key => &$row) {
//echo $row['link'].'<br>';
if (strpos($row['link'], 'zdiaugeia') !== false) {
if (substr($row['id'], strpos($row['id'], "?=")) == substr($last_item['id'], strpos($last_item['id'], "?="))) {
//echo $last_item['id'].'<br>';
if (strpos($last_item['link'], '/diaugeia/') !== false || strpos($last_item['link'], '/diaugeiakhmdhs/') !== false) {
$double[] = $last_item;
}
if (strpos($last_item['link'], '/khmdhs/') !== false) {
$double[] = $last_item;
if (strpos($last_item['link'], 'seller') !== false) {
$row['linkHKS'] = $last_item['link'];
$row['contractAmountPrevHKS'] = $last_item['contractAmountPrev'];
$row['contractAmountCurHKS'] = $last_item['contractAmountCur'];
$row['paymentAmountPrevHKS'] = $last_item['paymentAmountPrev'];
$row['paymentAmountCurHKS'] = $last_item['paymentAmountCur'];
$row['contractItemsNoHKS'] = $last_item['contractItemsNo'];
$row['paymentItemsNoHKS'] = $last_item['paymentItemsNo'];
$row['lastUpdateHKS'] = $last_item['lastUpdate'];
} else {
$row['linkHKB'] = $last_item['link'];
$row['contractAmountPrevHKB'] = $last_item['contractAmountPrev'];
$row['contractAmountCurHKB'] = $last_item['contractAmountCur'];
$row['paymentAmountPrevHKB'] = $last_item['paymentAmountPrev'];
$row['paymentAmountCurHKB'] = $last_item['paymentAmountCur'];
$row['contractItemsNoHKB'] = $last_item['contractItemsNo'];
$row['paymentItemsNoHKB'] = $last_item['paymentItemsNo'];
$row['lastUpdateHKB'] = $last_item['lastUpdate'];
}
}
if (substr($last_item_2['id'], strpos($last_item_2['id'], "?=")) == substr($last_item['id'], strpos($last_item['id'], "?="))) {
//echo $last_item_2['id'].'<br>';
if (strpos($last_item_2['link'], '/diaugeia/') !== false || strpos($last_item_2['link'], '/diaugeiakhmdhs/') !== false) {
$double[] = $last_item_2;
}
if (strpos($last_item_2['link'], '/khmdhs/') !== false) {
$double[] = $last_item_2;
if (strpos($last_item_2['link'], 'seller') !== false) {
$row['linkHKS'] = $last_item_2['link'];
$row['contractAmountPrevHKS'] = $last_item_2['contractAmountPrev'];
$row['contractAmountCurHKS'] = $last_item_2['contractAmountCur'];
$row['paymentAmountPrevHKS'] = $last_item_2['paymentAmountPrev'];
$row['paymentAmountCurHKS'] = $last_item_2['paymentAmountCur'];
$row['contractItemsNoHKS'] = $last_item_2['contractItemsNo'];
$row['paymentItemsNoHKS'] = $last_item_2['paymentItemsNo'];
$row['lastUpdateHKS'] = $last_item_2['lastUpdate'];
} else {
$row['linkHKB'] = $last_item_2['link'];
$row['contractAmountPrevHKB'] = $last_item_2['contractAmountPrev'];
$row['contractAmountCurHKB'] = $last_item_2['contractAmountCur'];
$row['paymentAmountPrevHKB'] = $last_item_2['paymentAmountPrev'];
$row['paymentAmountCurHKB'] = $last_item_2['paymentAmountCur'];
$row['contractItemsNoHKB'] = $last_item_2['contractItemsNo'];
$row['paymentItemsNoHKB'] = $last_item_2['paymentItemsNo'];
$row['lastUpdateHKB'] = $last_item_2['lastUpdate'];
}
}
if (substr($last_item_3['id'], strpos($last_item_3['id'], "?=")) == substr($last_item_2['id'], strpos($last_item_2['id'], "?="))) {
// echo $last_item_3['id'].'<br>';
if (strpos($last_item_3['link'], '/diaugeia/') !== false || strpos($last_item_3['link'], '/diaugeiakhmdhs/') !== false) {
$double[] = $last_item_3;
}
if (strpos($last_item_3['link'], '/khmdhs/') !== false) {
$double[] = $last_item_3;
if (strpos($last_item_3['link'], 'seller') !== false) {
$row['linkHKS'] = $last_item_3['link'];
$row['contractAmountPrevHKS'] = $last_item_3['contractAmountPrev'];
$row['contractAmountCurHKS'] = $last_item_3['contractAmountCur'];
$row['paymentAmountPrevHKS'] = $last_item_3['paymentAmountPrev'];
$row['paymentAmountCurHKS'] = $last_item_3['paymentAmountCur'];
$row['contractItemsNoHKS'] = $last_item_3['contractItemsNo'];
$row['paymentItemsNoHKS'] = $last_item_3['paymentItemsNo'];
$row['lastUpdateHKS'] = $last_item_3['lastUpdate'];
} else {
$row['linkHKB'] = $last_item_3['link'];
$row['contractAmountPrevHKB'] = $last_item_3['contractAmountPrev'];
$row['contractAmountCurHKB'] = $last_item_3['contractAmountCur'];
$row['paymentAmountPrevHKB'] = $last_item_3['paymentAmountPrev'];
$row['paymentAmountCurHKB'] = $last_item_3['paymentAmountCur'];
$row['contractItemsNoHKB'] = $last_item_3['contractItemsNo'];
$row['paymentItemsNoHKB'] = $last_item_3['paymentItemsNo'];
$row['lastUpdateHKB'] = $last_item_3['lastUpdate'];
}
}
if (substr($last_item_4['id'], strpos($last_item_4['id'], "?=")) == substr($last_item_3['id'], strpos($last_item_3['id'], "?="))) {
//echo $last_item_4['id'].'<br>';
if (strpos($last_item_4['link'], '/diaugeia/') !== false || strpos($last_item_4['link'], '/diaugeiakhmdhs/') !== false) {
$double[] = $last_item_4;
}
if (strpos($last_item_4['link'], '/khmdhs/') !== false) {
$double[] = $last_item_4;
if (strpos($last_item_4['link'], 'seller') !== false) {
$row['linkHKS'] = $last_item_4['link'];
$row['contractAmountPrevHKS'] = $last_item_4['contractAmountPrev'];
$row['contractAmountCurHKS'] = $last_item_4['contractAmountCur'];
$row['paymentAmountPrevHKS'] = $last_item_4['paymentAmountPrev'];
$row['paymentAmountCurHKS'] = $last_item_4['paymentAmountCur'];
$row['contractItemsNoHKS'] = $last_item_4['contractItemsNo'];
$row['paymentItemsNoHKS'] = $last_item_4['paymentItemsNo'];
$row['lastUpdateHKS'] = $last_item_4['lastUpdate'];
} else {
$row['linkHKB'] = $last_item_4['link'];
$row['contractAmountPrevHKB'] = $last_item_4['contractAmountPrev'];
$row['contractAmountCurHKB'] = $last_item_4['contractAmountCur'];
$row['paymentAmountPrevHKB'] = $last_item_4['paymentAmountPrev'];
$row['paymentAmountCurHKB'] = $last_item_4['paymentAmountCur'];
$row['contractItemsNoHKB'] = $last_item_4['contractItemsNo'];
$row['paymentItemsNoHKB'] = $last_item_4['paymentItemsNo'];
$row['lastUpdateHKB'] = $last_item_4['lastUpdate'];
}
}
}
}
}
}
}
if (++$c !== $numItems) {
//echo "not last index!";
$last_item_4 = $last_item_3;
$last_item_3 = $last_item_2;
$last_item_2 = $last_item;
$last_item = $row;
}
}
/////////Espa///////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////
foreach ($uniqueResults as $key => &$row) {
$sort['id'][$key] = substr($row['id'], strpos($row['id'], "?="));
$sort['link'][$key] = $row['link'];
}
array_multisort($sort['id'], SORT_ASC, $sort['link'], SORT_ASC, $uniqueResults);
foreach ($uniqueResults as $key => &$row) {
//echo 'r='.$row['link'].'<br>';
//echo 'l='.$last_item['link'].'<br>';
//echo 'l2='.$last_item_2['link'].'<br>';
//echo 'l3='.$last_item_3['link'].'<br>';
//echo 'l4='.$last_item_4['link'].'<br>';
if (strpos($row['link'], 'espa') !== false || strpos($row['link'], 'beneficiary') !== false) {
if (substr($row['id'], strpos($row['id'], "?=")) == substr($last_item['id'], strpos($last_item['id'], "?="))) {
//echo '1'.$last_item['link'].'<br>';
if (strpos($last_item['link'], '/diaugeia/') !== false || strpos($last_item['link'], '/diaugeiakhmdhs/') !== false || strpos($last_item['link'], 'hybrid') !== false) {
$double[] = $last_item;
//for hide
if (strpos($last_item['link'], 'seller') !== false) {
$row['linkEDS'] = $last_item['link'];
$row['award0EDS'] = $last_item['award0'];
$row['award1EDS'] = $last_item['award1'];
$row['award2EDS'] = $last_item['award2'];
$row['awardCnt0EDS'] = $last_item['awardCnt0'];
$row['awardCnt1EDS'] = $last_item['awardCnt1'];
$row['awardCnt2EDS'] = $last_item['awardCnt2'];
$row['spend0EDS'] = $last_item['spend0'];
$row['spend1EDS'] = $last_item['spend1'];
$row['spend2EDS'] = $last_item['spend2'];
$row['spendCnt0EDS'] = $last_item['spendCnt0'];
$row['spendCnt1EDS'] = $last_item['spendCnt1'];
$row['spendCnt2EDS'] = $last_item['spendCnt2'];
$row['lastUpdateEDS'] = $last_item['lastUpdate'];
} else {
$row['linkEDB'] = $last_item['link'];
$row['award0EDB'] = $last_item['award0'];
$row['award1EDB'] = $last_item['award1'];
$row['award2EDB'] = $last_item['award2'];
$row['awardCnt0EDB'] = $last_item['awardCnt0'];
$row['awardCnt1EDB'] = $last_item['awardCnt1'];
$row['awardCnt2EDB'] = $last_item['awardCnt2'];
$row['spend0EDB'] = $last_item['spend0'];
$row['spend1EDB'] = $last_item['spend1'];
$row['spend2EDB'] = $last_item['spend2'];
$row['spendCnt0EDB'] = $last_item['spendCnt0'];
$row['spendCnt1EDB'] = $last_item['spendCnt1'];
$row['spendCnt2EDB'] = $last_item['spendCnt2'];
$row['lastUpdateEDB'] = $last_item['lastUpdate'];
}
}
if (strpos($last_item['link'], '/khmdhs/') !== false) {
$double[] = $last_item;
// for hide
if (strpos($last_item['link'], 'seller') !== false) {
$row['linkEKS'] = $last_item['link'];
$row['contractAmountPrevEKS'] = $last_item['contractAmountPrev'];
$row['contractAmountCurEKS'] = $last_item['contractAmountCur'];
$row['paymentAmountPrevEKS'] = $last_item['paymentAmountPrev'];
$row['paymentAmountCurEKS'] = $last_item['paymentAmountCur'];
$row['contractItemsNoEKS'] = $last_item['contractItemsNo'];
$row['paymentItemsNoEKS'] = $last_item['paymentItemsNo'];
$row['lastUpdateEKS'] = $last_item['lastUpdate'];
} else {
$row['linkEKB'] = $last_item['link'];
$row['contractAmountPrevEKB'] = $last_item['contractAmountPrev'];
$row['contractAmountCurEKB'] = $last_item['contractAmountCur'];
$row['paymentAmountPrevEKB'] = $last_item['paymentAmountPrev'];
$row['paymentAmountCurEKB'] = $last_item['paymentAmountCur'];
$row['contractItemsNoEKB'] = $last_item['contractItemsNo'];
$row['paymentItemsNoEKB'] = $last_item['paymentItemsNo'];
$row['lastUpdateEKB'] = $last_item['lastUpdate'];
}
}
if (substr($last_item_2['id'], strpos($last_item_2['id'], "?=")) == substr($last_item['id'], strpos($last_item['id'], "?="))) {
//echo '2'.$last_item_2['link'].'<br>';
if (strpos($last_item_2['link'], '/diaugeia/') !== false || strpos($last_item_2['link'], '/diaugeiakhmdhs/') !== false || strpos($last_item_2['link'], 'hybrid') !== false) {
$double[] = $last_item_2;
//for hide
if (strpos($last_item_2['link'], 'seller') !== false) {
$row['linkEDS'] = $last_item_2['link'];
$row['award0EDS'] = $last_item_2['award0'];
$row['award1EDS'] = $last_item_2['award1'];
$row['award2EDS'] = $last_item_2['award2'];
$row['awardCnt0EDS'] = $last_item_2['awardCnt0'];
$row['awardCnt1EDS'] = $last_item_2['awardCnt1'];
$row['awardCnt2EDS'] = $last_item_2['awardCnt2'];
$row['spend0EDS'] = $last_item_2['spend0'];
$row['spend1EDS'] = $last_item_2['spend1'];
$row['spend2EDS'] = $last_item_2['spend2'];
$row['spendCnt0EDS'] = $last_item_2['spendCnt0'];
$row['spendCnt1EDS'] = $last_item_2['spendCnt1'];
$row['spendCnt2EDS'] = $last_item_2['spendCnt2'];
$row['lastUpdateEDS'] = $last_item_2['lastUpdate'];
} else {
$row['linkEDB'] = $last_item_2['link'];
$row['award0EDB'] = $last_item_2['award0'];
$row['award1EDB'] = $last_item_2['award1'];
$row['award2EDB'] = $last_item_2['award2'];
$row['awardCnt0EDB'] = $last_item_2['awardCnt0'];
$row['awardCnt1EDB'] = $last_item_2['awardCnt1'];
$row['awardCnt2EDB'] = $last_item_2['awardCnt2'];
$row['spend0EDB'] = $last_item_2['spend0'];
$row['spend1EDB'] = $last_item_2['spend1'];
$row['spend2EDB'] = $last_item_2['spend2'];
$row['spendCnt0EDB'] = $last_item_2['spendCnt0'];
$row['spendCnt1EDB'] = $last_item_2['spendCnt1'];
$row['spendCnt2EDB'] = $last_item_2['spendCnt2'];
$row['lastUpdateEDB'] = $last_item_2['lastUpdate'];
}
}
if (strpos($last_item_2['link'], '/khmdhs/') !== false) {
$double[] = $last_item_2;
if (strpos($last_item_2['link'], 'seller') !== false) {
$row['linkEKS'] = $last_item_2['link'];
$row['contractAmountPrevEKS'] = $last_item_2['contractAmountPrev'];
$row['contractAmountCurEKS'] = $last_item_2['contractAmountCur'];
$row['paymentAmountPrevEKS'] = $last_item_2['paymentAmountPrev'];
$row['paymentAmountCurEKS'] = $last_item_2['paymentAmountCur'];
$row['contractItemsNoEKS'] = $last_item_2['contractItemsNo'];
$row['paymentItemsNoEKS'] = $last_item_2['paymentItemsNo'];
$row['lastUpdateEKS'] = $last_item_2['lastUpdate'];
} else {
$row['linkEKB'] = $last_item_2['link'];
$row['contractAmountPrevEKB'] = $last_item_2['contractAmountPrev'];
$row['contractAmountCurEKB'] = $last_item_2['contractAmountCur'];
$row['paymentAmountPrevEKB'] = $last_item_2['paymentAmountPrev'];
$row['paymentAmountCurEKB'] = $last_item_2['paymentAmountCur'];
$row['contractItemsNoEKB'] = $last_item_2['contractItemsNo'];
$row['paymentItemsNoEKB'] = $last_item_2['paymentItemsNo'];
$row['lastUpdateEKB'] = $last_item_2['lastUpdate'];
}
}
if (substr($last_item_3['id'], strpos($last_item_3['id'], "?=")) == substr($last_item_2['id'], strpos($last_item_2['id'], "?="))) {
//echo '3'.$last_item_3['link'].'<br>';
if (strpos($last_item_3['link'], '/diaugeia/') !== false || strpos($last_item_3['link'], '/diaugeiakhmdhs/') !== false || strpos($last_item_3['link'], 'hybrid') !== false) {
$double[] = $last_item_3;
if (strpos($last_item_3['link'], 'seller') !== false) {
$row['linkEDS'] = $last_item_3['link'];
$row['award0EDS'] = $last_item_3['award0'];
$row['award1EDS'] = $last_item_3['award1'];
$row['award2EDS'] = $last_item_3['award2'];
$row['awardCnt0EDS'] = $last_item_3['awardCnt0'];
$row['awardCnt1EDS'] = $last_item_3['awardCnt1'];
$row['awardCnt2EDS'] = $last_item_3['awardCnt2'];
$row['spend0EDS'] = $last_item_3['spend0'];
$row['spend1EDS'] = $last_item_3['spend1'];
$row['spend2EDS'] = $last_item_3['spend2'];
$row['spendCnt0EDS'] = $last_item_3['spendCnt0'];
$row['spendCnt1EDS'] = $last_item_3['spendCnt1'];
$row['spendCnt2EDS'] = $last_item_3['spendCnt2'];
$row['lastUpdateEDS'] = $last_item_3['lastUpdate'];
} else {
$row['linkEDB'] = $last_item_3['link'];
$row['award0EDB'] = $last_item_3['award0'];
$row['award1EDB'] = $last_item_3['award1'];
$row['award2EDB'] = $last_item_3['award2'];
$row['awardCnt0EDB'] = $last_item_3['awardCnt0'];
$row['awardCnt1EDB'] = $last_item_3['awardCnt1'];
$row['awardCnt2EDB'] = $last_item_3['awardCnt2'];
$row['spend0EDB'] = $last_item_3['spend0'];
$row['spend1EDB'] = $last_item_3['spend1'];
$row['spend2EDB'] = $last_item_3['spend2'];
$row['spendCnt0EDB'] = $last_item_3['spendCnt0'];
$row['spendCnt1EDB'] = $last_item_3['spendCnt1'];
$row['spendCnt2EDB'] = $last_item_3['spendCnt2'];
$row['lastUpdateEDB'] = $last_item_3['lastUpdate'];
}
}
if (strpos($last_item_3['link'], '/khmdhs/') !== false) {
$double[] = $last_item_3;
if (strpos($last_item_3['link'], 'seller') !== false) {
$row['linkEKS'] = $last_item_3['link'];
$row['contractAmountPrevEKS'] = $last_item_3['contractAmountPrev'];
$row['contractAmountCurEKS'] = $last_item_3['contractAmountCur'];
$row['paymentAmountPrevEKS'] = $last_item_3['paymentAmountPrev'];
$row['paymentAmountCurEKS'] = $last_item_3['paymentAmountCur'];
$row['contractItemsNoEKS'] = $last_item_3['contractItemsNo'];
$row['paymentItemsNoEKS'] = $last_item_3['paymentItemsNo'];
$row['lastUpdateEKS'] = $last_item_3['lastUpdate'];
} else {
$row['linkEKB'] = $last_item_3['link'];
$row['contractAmountPrevEKB'] = $last_item_3['contractAmountPrev'];
$row['contractAmountCurEKB'] = $last_item_3['contractAmountCur'];
$row['paymentAmountPrevEKB'] = $last_item_3['paymentAmountPrev'];
$row['paymentAmountCurEKB'] = $last_item_3['paymentAmountCur'];
$row['contractItemsNoEKB'] = $last_item_3['contractItemsNo'];
$row['paymentItemsNoEKB'] = $last_item_3['paymentItemsNo'];
$row['lastUpdateEKB'] = $last_item_3['lastUpdate'];
}
}
if (substr($last_item_4['id'], strpos($last_item_4['id'], "?=")) == substr($last_item_3['id'], strpos($last_item_3['id'], "?="))) {
// echo '4'.$last_item_4['link'].'<br>';
if (strpos($last_item_4['link'], '/diaugeia/') !== false || strpos($last_item_4['link'], '/diaugeiakhmdhs/') !== false || strpos($last_item_4['link'], 'hybrid') !== false) {
$double[] = $last_item_4;
if (strpos($last_item_4['link'], 'seller') !== false) {
$row['linkEDS'] = $last_item_4['link'];
$row['award0EDS'] = $last_item_4['award0'];
$row['award1EDS'] = $last_item_4['award1'];
$row['award2EDS'] = $last_item_4['award2'];
$row['awardCnt0EDS'] = $last_item_4['awardCnt0'];
$row['awardCnt1EDS'] = $last_item_4['awardCnt1'];
$row['awardCnt2EDS'] = $last_item_4['awardCnt2'];
$row['spend0EDS'] = $last_item_4['spend0'];
$row['spend1EDS'] = $last_item_4['spend1'];
$row['spend2EDS'] = $last_item_4['spend2'];
$row['spendCnt0EDS'] = $last_item_4['spendCnt0'];
$row['spendCnt1EDS'] = $last_item_4['spendCnt1'];
$row['spendCnt2EDS'] = $last_item_4['spendCnt2'];
$row['lastUpdateEDS'] = $last_item_4['lastUpdate'];
} else {
$row['linkEDB'] = $last_item_4['link'];
$row['award0EDB'] = $last_item_4['award0'];
$row['award1EDB'] = $last_item_4['award1'];
$row['award2EDB'] = $last_item_4['award2'];
$row['awardCnt0EDB'] = $last_item_4['awardCnt0'];
$row['awardCnt1EDB'] = $last_item_4['awardCnt1'];
$row['awardCnt2EDB'] = $last_item_4['awardCnt2'];
$row['spend0EDB'] = $last_item_4['spend0'];
$row['spend1EDB'] = $last_item_4['spend1'];
$row['spend2EDB'] = $last_item_4['spend2'];
$row['spendCnt0EDB'] = $last_item_4['spendCnt0'];
$row['spendCnt1EDB'] = $last_item_4['spendCnt1'];
$row['spendCnt2EDB'] = $last_item_4['spendCnt2'];
$row['lastUpdateEDB'] = $last_item_4['lastUpdate'];
}
}
if (strpos($last_item_4['link'], '/khmdhs/') !== false) {
$double[] = $last_item_4;
if (strpos($last_item_4['link'], 'seller') !== false) {
$row['linkEKS'] = $last_item_4['link'];
$row['contractAmountPrevEKS'] = $last_item_4['contractAmountPrev'];
$row['contractAmountCurEKS'] = $last_item_4['contractAmountCur'];
$row['paymentAmountPrevEKS'] = $last_item_4['paymentAmountPrev'];
$row['paymentAmountCurEKS'] = $last_item_4['paymentAmountCur'];
$row['contractItemsNoEKS'] = $last_item_4['contractItemsNo'];
$row['paymentItemsNoEKS'] = $last_item_4['paymentItemsNo'];
$row['lastUpdateEKS'] = $last_item_4['lastUpdate'];
} else {
$row['linkEKB'] = $last_item_4['link'];
$row['contractAmountPrevEKB'] = $last_item_4['contractAmountPrev'];
$row['contractAmountCurEKB'] = $last_item_4['contractAmountCur'];
$row['paymentAmountPrevEKB'] = $last_item_4['paymentAmountPrev'];
$row['paymentAmountCurEKB'] = $last_item_4['paymentAmountCur'];
$row['contractItemsNoEKB'] = $last_item_4['contractItemsNo'];
$row['paymentItemsNoEKB'] = $last_item_4['paymentItemsNo'];
$row['lastUpdateEKB'] = $last_item_4['lastUpdate'];
}
}
}
}
//end of last item3, 4
}
}
}
if (++$c !== $numItems) {
//echo "not last index!";
$last_item_4 = $last_item_3;
$last_item_3 = $last_item_2;
$last_item_2 = $last_item;
$last_item = $row;
}
}
//print_r($double);
$i = 0;
$sumResults = count($uniqueResults);
$sumSpend = 0;
$sumAward = 0;
$sumContracts = 0;
$sumPayments = 0;
$counterContracts = 0;
$sumAwardSel = 0;
$sumSpendSel = 0;
echo "<table id='searchResults' class='display' ><thead><tr><th></th><th></th></thead>";
//<th>Score</th><th>id</th></tr>
echo "<tbody>";
while ($i < $sumResults) {
if (isset($uniqueResults[$i]['link']) && strpos($uniqueResults[$i]['link'], 'person') == false && hideDuplicate($double, $uniqueResults[$i]['link']) != 1) {
$link = $uniqueResults[$i]['link'];
//fix hybrid link
if (strpos($link, 'zdiaugeia/diaugeia-hybrids') !== false) {
$link = str_replace('zdiaugeia/', 'diaugeia/', $link);
}
//generate espa link http://83.212.86.158:5984/elod_espa_beneficiaries/_design/all/_view/all
if ($uniqueResults[$i]['pageKind'] == 'sellerBoth') {
$link = str_replace('zorganization-beneficiary', 'espa-both-organization-seller', $link);
} else {
if ($uniqueResults[$i]['pageKind'] == 'buyerBoth') {
$link = str_replace('zorganization-beneficiary', 'espa-both-organization-buyer', $link);
} else {
if ($uniqueResults[$i]['pageKind'] == 'sellerDiavgeia') {
$link = str_replace('zorganization-beneficiary', 'espa-diavgeia-organization-seller', $link);
} else {
if ($uniqueResults[$i]['pageKind'] == 'buyerDiavgeia') {
$link = str_replace('zorganization-beneficiary', 'espa-diavgeia-organization-buyer', $link);
} else {
if ($uniqueResults[$i]['pageKind'] == 'sellerKhmdhs') {
$link = str_replace('zorganization-beneficiary', 'espa-khmdhs-organization-seller', $link);
} else {
if ($uniqueResults[$i]['pageKind'] == 'buyerKhmdhs') {
$link = str_replace('zorganization-beneficiary', 'espa-khmdhs-organization-buyer', $link);
} else {
if ($uniqueResults[$i]['pageKind'] == '' || $uniqueResults[$i]['pageKind'] == 'general') {
$link = str_replace('zorganization-beneficiary', 'organization-beneficiary', $link);
}
}
}
}
}
}
}
$nameLink = $link;
$name = $uniqueResults[$i]['name'];
$psName = $uniqueResults[$i]['psName'];
if (strpos($link, 'seller') !== false && strpos($link, 'espa') == false) {
$property = 'ΑΝΑΔΟΧΟΣ';
} else {
if (strpos($link, 'buyer') !== false && strpos($link, 'espa') == false) {
$property = 'ΦΟΡΕΑΣ';
} else {
if (strpos($link, 'hybrid') !== false) {
$property = 'ΥΒΡΙΔΙΚΟΣ';
} else {
if (strpos($link, 'espa') !== false || strpos($link, 'beneficiary') !== false) {
$property = 'ΔΙΚΑΙΟΥΧΟΣ';
} else {
$property = ' ';
}
}
}
}
echo "<tr>";
if (strpos($link, 'diaugeia/org') !== false) {
//διαυγεια 035970655
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo "<a href='".$nameLink."'target='_blank' >$name</a> </br>";
//echo '<B>'.$name.'</B><br>';
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
//echo "<FONT COLOR='#006621 '>$link</FONT></br>";
echo '<I>';
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'Α.Φ.Μ. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '</I>';
//echo '<B>'.(getSource($link,'d')).'<sup><font size="1">'.$property.'</font></sup> : </B>';
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>";
//echo '<B>';
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
echo ' <font color="#FFA500" size="1">' . $property . '</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0']) + fromTextToNumber($uniqueResults[$i]['spend1']) + fromTextToNumber($uniqueResults[$i]['spend2']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0'] + $uniqueResults[$i]['spendCnt1'] + $uniqueResults[$i]['spendCnt2'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0']) + fromTextToNumber($uniqueResults[$i]['award1']) + fromTextToNumber($uniqueResults[$i]['award2']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0'] + $uniqueResults[$i]['awardCnt1'] + $uniqueResults[$i]['awardCnt2'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
echo "</td>";
} else {
if (strpos($link, 'espa') !== false || strpos($link, 'beneficiary') !== false) {
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo '<B>'.$name.'</B><br>';
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
echo '<I>';
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'Α.Φ.Μ. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '</I>';
if ($uniqueResults[$i]['pageKind'] == 'sellerBoth') {
//eg 999243471 099360290 fixed 099360290 double problem
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>"; //use namelink for superprofile
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
$link4 = $uniqueResults[$i]['linkEDB'];
if (isset($link4) && $link4 !== ' ') {
//missing buyer for 099360290
//echo $link4."</br>";
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>"; //use namelink for superprofile
//echo "<a href='".$link4."'target='_blank' fontcolor='#FFA500' size='1' > <B>Φορέας </B></a> ";
echo "<a href='" . $link4 . "'target='_blank' style='font-size: 10px; color: #FFA500;' <B>ΦΟΡΕΑΣ</B> </a> ";
//echo ' <font color="#FFA500" size="1">Ανάδοχος</font> ';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDB']) + fromTextToNumber($uniqueResults[$i]['spend1EDB']) + fromTextToNumber($uniqueResults[$i]['spend2EDB']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDB'] + $uniqueResults[$i]['spendCnt1EDB'] + $uniqueResults[$i]['spendCnt2EDB'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDB']) + fromTextToNumber($uniqueResults[$i]['award1EDB']) + fromTextToNumber($uniqueResults[$i]['award2EDB']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDB'] + $uniqueResults[$i]['awardCnt1EDB'] + $uniqueResults[$i]['awardCnt2EDB'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDB'] . ']</br>';
}
$link2 = $uniqueResults[$i]['linkEDS'];
//must be diaugeiakhmdhs
if (isset($link2) && $link2 !== ' ') {
//echo $link2."</br>";
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΑΝΑΔΟΧΟΣ</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDS']) + fromTextToNumber($uniqueResults[$i]['spend1EDS']) + fromTextToNumber($uniqueResults[$i]['spend2EDS']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDS'] + $uniqueResults[$i]['spendCnt1EDS'] + $uniqueResults[$i]['spendCnt2EDS'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDS']) + fromTextToNumber($uniqueResults[$i]['award1EDS']) + fromTextToNumber($uniqueResults[$i]['award2EDS']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDS'] + $uniqueResults[$i]['awardCnt1EDS'] + $uniqueResults[$i]['awardCnt2EDS'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDS'] . ']</br>';
}
$link3 = $uniqueResults[$i]['linkEKS'];
if (isset($link3) && $link3 !== ' ') {
//echo $link3."</br>";
//echo "<a href='".$nameLink."'target='_blank' > <B>Στo ΚΗΜΔΗΣ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΑΝΑΔΟΧΟΣ</font> ';
//echo '</B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrevEKS']) + fromTextToNumber($uniqueResults[$i]['contractAmountCurEKS']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNoEKS'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrevEKS']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCurEKS']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNoEKS'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEKS'] . ']</br>';
}
} else {
if ($uniqueResults[$i]['pageKind'] == 'buyerBoth') {
//eg 090050779 χάνουμε τον πιθανο seller -fixed 090050779 double problem
$link2 = $uniqueResults[$i]['linkEDB'];
if (isset($link2) && $link2 !== ' ') {
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>"; //use namelink for superprofile
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΦΟΡΕΑΣ</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDB']) + fromTextToNumber($uniqueResults[$i]['spend1EDB']) + fromTextToNumber($uniqueResults[$i]['spend2EDB']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDB'] + $uniqueResults[$i]['spendCnt1EDB'] + $uniqueResults[$i]['spendCnt2EDB'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDB']) + fromTextToNumber($uniqueResults[$i]['award1EDB']) + fromTextToNumber($uniqueResults[$i]['award2EDB']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDB'] + $uniqueResults[$i]['awardCnt1EDB'] + $uniqueResults[$i]['awardCnt2EDB'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDB'] . ']</br>';
}
$link4 = $uniqueResults[$i]['linkEDS'];
if (isset($link4) && $link4 !== ' ') {
//test for missing seller, works
//echo $link4."</br>";
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>"; //use namelink for superprofile
echo "<a href='" . $link4 . "'target='_blank' style='font-size: 10px; color: #FFA500;' <B>ΑΝΑΔΟΧΟΣ</B> </a> ";
//echo ' <font color="#FFA500" size="1">Ανάδοχος</font> ';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDS']) + fromTextToNumber($uniqueResults[$i]['spend1EDS']) + fromTextToNumber($uniqueResults[$i]['spend2EDS']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDS'] + $uniqueResults[$i]['spendCnt1EDS'] + $uniqueResults[$i]['spendCnt2EDS'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDS']) + fromTextToNumber($uniqueResults[$i]['award1EDS']) + fromTextToNumber($uniqueResults[$i]['award2EDS']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDS'] + $uniqueResults[$i]['awardCnt1EDS'] + $uniqueResults[$i]['awardCnt2EDS'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDS'] . ']</br>';
}
$link3 = $uniqueResults[$i]['linkEKB'];
if (isset($link3) && $link3 !== ' ') {
//echo $link4."</br>";
//echo "<a href='".$nameLink."'target='_blank' > <B>Στo ΚΗΜΔΗΣ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΦΟΡΕΑΣ</font> ';
//echo '</B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrevEKB']) + fromTextToNumber($uniqueResults[$i]['contractAmountCurEKB']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNoEKB'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrevEKB']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCurEKB']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNoEKB'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEKB'] . ']</br>';
}
} else {
if ($uniqueResults[$i]['pageKind'] == 'sellerDiavgeia') {
//eg 004322968 012377598
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>"; //use namelink for superprofile
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΑΝΑΔΟΧΟΣ</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDS']) + fromTextToNumber($uniqueResults[$i]['spend1EDS']) + fromTextToNumber($uniqueResults[$i]['spend2EDS']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDS'] + $uniqueResults[$i]['spendCnt1EDS'] + $uniqueResults[$i]['spendCnt2EDS'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDS']) + fromTextToNumber($uniqueResults[$i]['award1EDS']) + fromTextToNumber($uniqueResults[$i]['award2EDS']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDS'] + $uniqueResults[$i]['awardCnt1EDS'] + $uniqueResults[$i]['awardCnt2EDS'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDS'] . ']</br>';
} else {
if ($uniqueResults[$i]['pageKind'] == 'buyerDiavgeia') {
//eg 017130241 χανουμε τον seller (buyerdiaugeia ενω εχει seller) δεν δουλεύει 018133333 + double problem
// echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>"; //use namelink for superprofile
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΦΟΡΕΑΣ</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDB']) + fromTextToNumber($uniqueResults[$i]['spend1EDB']) + fromTextToNumber($uniqueResults[$i]['spend2EDB']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDB'] + $uniqueResults[$i]['spendCnt1EDB'] + $uniqueResults[$i]['spendCnt2EDB'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDB']) + fromTextToNumber($uniqueResults[$i]['award1EDB']) + fromTextToNumber($uniqueResults[$i]['award2EDB']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDB'] + $uniqueResults[$i]['awardCnt1EDB'] + $uniqueResults[$i]['awardCnt2EDB'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDB'] . ']</br>';
$link2 = $uniqueResults[$i]['linkEDS'];
if (isset($link2) && $link2 !== ' ') {
//
//echo $link4."</br>";
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>"; //use namelink for superprofile
echo "<a href='" . $link2 . "'target='_blank' style='font-size: 10px; color: #FFA500;' <B>ΑΝΑΔΟΧΟΣ</B> </a> ";
//echo ' <font color="#FFA500" size="1">Ανάδοχος</font> ';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDS']) + fromTextToNumber($uniqueResults[$i]['spend1EDS']) + fromTextToNumber($uniqueResults[$i]['spend2EDS']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDS'] + $uniqueResults[$i]['spendCnt1EDS'] + $uniqueResults[$i]['spendCnt2EDS'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDS']) + fromTextToNumber($uniqueResults[$i]['award1EDS']) + fromTextToNumber($uniqueResults[$i]['award2EDS']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDS'] + $uniqueResults[$i]['awardCnt1EDS'] + $uniqueResults[$i]['awardCnt2EDS'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDS'] . ']</br>';
}
} else {
if ($uniqueResults[$i]['pageKind'] == 'sellerKhmdhs') {
//echo "<a href='".$nameLink."'target='_blank' > <B>Στo ΚΗΜΔΗΣ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΑΝΑΔΟΧΟΣ</font> ';
//echo '</B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrevEKS']) + fromTextToNumber($uniqueResults[$i]['contractAmountCurEKS']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNoEKS'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrevEKS']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCurEKS']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNoEKS'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEKS'] . ']</br>';
}
}
}
}
}
if ($uniqueResults[$i]['pageKind'] == 'buyerKhmdhs') {
//eg 090034024 buyerKhmdhs αλλα έχει και διαυγεια fixed
$link2 = $uniqueResults[$i]['linkEDB'];
if (isset($link2) && $link2 !== ' ') {
if (strpos($link2, 'diaugeiakhmdhs') !== false) {
$link2 = str_replace('diaugeiakhmdhs', 'diaugeia', $link2);
}
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
//echo "<a href='".$link2."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>";
//echo '<B>';
echo ' <font color="#FFA500" size="1">ΦΟΡΕΑΣ</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0EDB']) + fromTextToNumber($uniqueResults[$i]['spend1EDB']) + fromTextToNumber($uniqueResults[$i]['spend2EDB']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0EDB'] + $uniqueResults[$i]['spendCnt1EDB'] + $uniqueResults[$i]['spendCnt2EDB'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0EDB']) + fromTextToNumber($uniqueResults[$i]['award1EDB']) + fromTextToNumber($uniqueResults[$i]['award2EDB']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0EDB'] + $uniqueResults[$i]['awardCnt1EDB'] + $uniqueResults[$i]['awardCnt2EDB'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEDB'] . ']</br>';
}
//echo "<a href='".$nameLink."'target='_blank' > <B>Στo ΚΗΜΔΗΣ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
// echo '<B>';
echo ' <font color="#FFA500" size="1">ΦΟΡΕΑΣ</font> ';
//echo '<B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrevEKB']) + fromTextToNumber($uniqueResults[$i]['contractAmountCurEKB']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNoEKB'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrevEKB']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCurEKB']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNoEKB'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateEKB'] . ']</br>';
}
//only espa
//echo "<a href='".$nameLink."'target='_blank' > <B>Στις ΕΠΙΔΟΤΗΣΕΙΣ ΕΣΠΑ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">Επιδοτήσεις ΕΣΠΑ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">' . $property . '</font> ';
//echo '</B>';
echo 'Συμβάσεις: ';
//$sumContracts=fromTextToNumber($uniqueResults[$i]['contractAmountPrev']) + fromTextToNumber($uniqueResults[$i]['contractAmountCur']) ;
echo '<B>' . $uniqueResults[$i]['SubsContractsAmount'] . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['SubsContractsCounter'], 0) . '</B>) ';
echo 'Πληρωμές: ';
//$sumPayments=fromTextToNumber($uniqueResults[$i]['paymentAmountPrev']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCur']) ;
echo '<B>' . $uniqueResults[$i]['SubsPaymentsAmount'] . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['SubsPaymentsCounter'], 0) . '</B>) ';
echo '   [έως ' . convertDate($uniqueResults[$i]['lastUpdate']) . ']</br>';
echo "</td>";
} else {
if (strpos($link, 'diaugeia/dia') !== false) {
//υβριδικος Διαύγεια + ελεγχος Κημδης 090166291
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo "<a href='".$nameLink."'target='_blank' >$name</a> </br>";
//echo '<B>'.$name.'</B><br>';
//echo "<FONT COLOR='#006621 '>$link</FONT></br>";
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
echo '<I>';
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'Α.Φ.Μ. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '</I>';
//echo '<B>ΣΤΗ ΔΙΑΥΓΕΙΑ<sup><font size="1">ΦΟΡΕΑΣ</font></sup> : </B>';
//echo '<B>ΣΤΗ ΔΙΑΥΓΕΙΑ : </B>';
//echo 'Στη ';
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
//echo '<B> ';
echo ' <font color="#FFA500" size="1">ΦΟΡΕΑΣ  </font> ';
// echo '</B> ';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0']) + fromTextToNumber($uniqueResults[$i]['spend1']) + fromTextToNumber($uniqueResults[$i]['spend2']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0'] + $uniqueResults[$i]['spendCnt1'] + $uniqueResults[$i]['spendCnt2'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0']) + fromTextToNumber($uniqueResults[$i]['award1']) + fromTextToNumber($uniqueResults[$i]['award2']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0'] + $uniqueResults[$i]['awardCnt1'] + $uniqueResults[$i]['awardCnt2'], 0) . '</B>)';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']<BR>';
// echo '<sup><font size="2">ΑΝΑΔΟΧΟΣ: </font></sup>';
//echo '<B> ';
echo ' <font color="#FFA500" size="1">ΑΝΑΔΟΧΟΣ  </font> ';
//echo ' <font color="#006621" font size="1">ΑΝΑΔΟΧΟΣ  </font> ';
//echo '</B> ';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpendSel = fromTextToNumber($uniqueResults[$i]['spendSel0']) + fromTextToNumber($uniqueResults[$i]['spendSel1']) + fromTextToNumber($uniqueResults[$i]['spendSel2']);
echo '<B> ' . fromNumberToText($sumSpendSel, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCntSel0'] + $uniqueResults[$i]['spendCntSel1'] + $uniqueResults[$i]['spendCntSel2'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAwardSel = fromTextToNumber($uniqueResults[$i]['awardSel0']) + fromTextToNumber($uniqueResults[$i]['awardSel1']) + fromTextToNumber($uniqueResults[$i]['awardSel2']);
echo '<B> ' . fromNumberToText($sumAwardSel, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0'] + $uniqueResults[$i]['awardCnt1'] + $uniqueResults[$i]['awardCnt2'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']<br>';
//echo substr($nameLink,strpos($nameLink, "?="));
//$link2=fromHidden($hidden,(substr($nameLink,strpos($nameLink, "?="))));
$link2 = $uniqueResults[$i]['linkHKB'];
if (isset($link2) && $link2 !== ' ') {
//echo "<a href='".$link2."'target='_blank' <FONT COLOR='#006621' >$link2</FONT></a> </br>";
//echo "<a href='".$link2."'target='_blank' > <font <B>Στο ΚΗΜΔΗΣ</B></font> </a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
//echo '<sup><font size="2">ΦΟΡΕΑΣ: </font></sup>';
//echo '<B> ';
echo ' <font color="#FFA500" size="1">ΦΟΡΕΑΣ  </font> ';
//echo ' <font color="#006621" size="1">ΦΟΡΕΑΣ  </font> ';
//echo '</B> ';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrevHKB']) + fromTextToNumber($uniqueResults[$i]['contractAmountCurHKB']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNoHKB'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrevHKB']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCurHKB']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNoHKB'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateHKB'] . ']<br>';
}
$link3 = $uniqueResults[$i]['linkHKS'];
if (isset($link3) && $link3 !== ' ') {
//$link3=fromHidden($hidden,(substr($nameLink,strpos($nameLink, "?="))));
//echo "<a href='".$link3."'target='_blank' <FONT COLOR='#006621' >$link3</FONT></a> </br>";
//echo 'Στο ';
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
//echo "<a href='".$link3."'target='_blank' > <B>Στο ΚΗΜΔΗΣ</B></a> </br>";
//echo '<B> ';
echo ' <font color="#FFA500" size="1">ΑΝΑΔΟΧΟΣ  </font> ';
//echo ' <font color="#006621" size="1">ΑΝΑΔΟΧΟΣ  </font> ';
//echo '</B> ';
//echo '<B>ΚΗΜΔΗΣ<sup><font size="1">ΑΝΑΔΟΧΟΣ</font></sup> : </B>';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrevHKS']) + fromTextToNumber($uniqueResults[$i]['contractAmountCurHKS']);
echo 'Συμβάσεις: ';
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNoHKS'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrevHKS']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCurHKS']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNoHKS'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdateHKS'] . ']<br>';
}
//echo '<B>ΚΗΜΔΗΣ<sup><font size="1">ΑΝΑΔΟΧΟΣ</font></sup> : </B><br>';
echo "</td>";
} else {
if (strpos($link, 'diaugeiakhmdhs') !== false) {
//και Διαυγεια και κημδης 998154476
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
//echo '<B>'.$name.'</B><br>';
//echo "<FONT COLOR='#006621 '>$link</FONT></br>";
echo '<I>';
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'Α.Φ.Μ. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '</I>';
//echo '<B>'.(getSource($link,'d')).'<sup><font size="1">'.$property.'</font></sup> : </B>'; //DIAVGEIA
if ($uniqueResults[$i]['dk_flag'] == 'd') {
//αν δηλαδή η τρέχουσα γραμμή είναι όντως απο διαύγεια
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ - ΚΗΜΔΗΣ</B></a> </br>";
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">' . $property . '</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0']) + fromTextToNumber($uniqueResults[$i]['spend1']) + fromTextToNumber($uniqueResults[$i]['spend2']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0'] + $uniqueResults[$i]['spendCnt1'] + $uniqueResults[$i]['spendCnt2'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0']) + fromTextToNumber($uniqueResults[$i]['award1']) + fromTextToNumber($uniqueResults[$i]['award2']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0'] + $uniqueResults[$i]['awardCnt1'] + $uniqueResults[$i]['awardCnt2'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']<br>';
} else {
//η τρέχουσα γραμμή είναι απο κημδης
//echo "<a href='".$nameLink."'target='_blank' > <font <B>Στο ΚΗΜΔΗΣ</B></font> </a> </br>";
//echo ' <font color="#FFA500" size="1">'.$property.'</font> ';
//echo "<a href='".$nameLink."'target='_blank' > <B>Στη ΔΙΑΥΓΕΙΑ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΔΙΑΥΓΕΙΑ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">' . $property . '</font> ';
//echo '</B>';
echo 'Οριστικοποίηση Πληρωμών: ';
$sumSpend = fromTextToNumber($uniqueResults[$i]['spend0_2']) + fromTextToNumber($uniqueResults[$i]['spend1_2']) + fromTextToNumber($uniqueResults[$i]['spend2_2']);
echo '<B> ' . fromNumberToText($sumSpend, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['spendCnt0_2'] + $uniqueResults[$i]['spendCnt1_2'] + $uniqueResults[$i]['spendCnt2_2'], 0) . '</B>) ';
echo 'Κατακυρώσεις: ';
$sumAward = fromTextToNumber($uniqueResults[$i]['award0_2']) + fromTextToNumber($uniqueResults[$i]['award1_2']) + fromTextToNumber($uniqueResults[$i]['award2_2']);
echo '<B> ' . fromNumberToText($sumAward, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['awardCnt0_2'] + $uniqueResults[$i]['awardCnt1_2'] + $uniqueResults[$i]['awardCnt2_2'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate_2'] . ']<br>';
}
//echo '<B>'.(getSource($link,'k')).'<sup><font size="1">'.$property.'</font></sup> : </B>'; //KHMDHS
// echo "<a href='".$nameLink."'target='_blank' > <B>Στo ΚΗΜΔΗΣ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">' . $property . '</font> ';
//echo '</B>';
if ($uniqueResults[$i]['dk_flag'] == 'k') {
//αν δηλαδή η τρέχουσα γραμμή είναι όντως απο κημδης
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrev']) + fromTextToNumber($uniqueResults[$i]['contractAmountCur']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNo'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrev']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCur']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNo'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
} else {
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrev_2']) + fromTextToNumber($uniqueResults[$i]['contractAmountCur_2']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNo_2'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrev_2']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCur_2']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNo_2'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate_2'] . ']';
echo "</td>";
}
} else {
if (strpos($link, '/australia/') !== false) {
//australia
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
echo "<a href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
echo "<FONT COLOR='#006621 '>{$link}</FONT></br>";
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'V.A.T. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '<B>' . getSource($link, 'all') . '<sup><font size="1">' . $property . '</font></sup> : </B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmount0']) + fromTextToNumber($uniqueResults[$i]['contractAmount1']) + fromTextToNumber($uniqueResults[$i]['contractAmount2']);
echo '<B>' . fromNumberToText($sumContracts, '$') . '</B>';
$counterContracts = $uniqueResults[$i]['contractCounter0'] + $uniqueResults[$i]['contractCounter1'] + $uniqueResults[$i]['contractCounter2'];
echo ' (<B>' . round($counterContracts, 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
echo "</td>";
} else {
if (strpos($link, '/london/') !== false) {
//Λονδίνο
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
echo "<a href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
echo "<FONT COLOR='#006621 '>{$link}</FONT></br>";
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'V.A.T. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '<B>' . getSource($link, 'all') . '<sup><font size="1">' . $property . '</font></sup> : </B>';
if (strpos($link, 'buyer') !== false) {
echo 'Συμβάσεις: ';
} else {
echo 'Πληρωμές: ';
}
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmount0']) + fromTextToNumber($uniqueResults[$i]['contractAmount1']) + fromTextToNumber($uniqueResults[$i]['contractAmount2']) + fromTextToNumber($uniqueResults[$i]['contractAmount3']);
echo '<B>' . fromNumberToText($sumContracts, '£') . '</B>';
$counterContracts = $uniqueResults[$i]['contractCounter0'] + $uniqueResults[$i]['contractCounter1'] + $uniqueResults[$i]['contractCounter2'] + $uniqueResults[$i]['contractCounter3'];
echo ' (<B>' . round($counterContracts, 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
echo "</td>";
} else {
if (strpos($link, '/eu/') !== false) {
//ευρώπη
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo $name;
echo "<a href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
echo "<FONT COLOR='#006621 '>{$link}</FONT></br>";
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'V.A.T. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '<B>' . getSource($link, 'all') . '<sup><font size="1">' . $property . '</font></sup> : </B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmount0']) + fromTextToNumber($uniqueResults[$i]['contractAmount1']) + fromTextToNumber($uniqueResults[$i]['contractAmount2']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
$counterContracts = $uniqueResults[$i]['contractCounter0'] + $uniqueResults[$i]['contractCounter1'] + $uniqueResults[$i]['contractCounter2'];
echo ' (<B>' . round($counterContracts, 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
echo "</td>";
} else {
if (strpos($link, '/newyork/') !== false) {
//Νέα Υόρκη-πόλη
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
echo "<a href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
echo "<FONT COLOR='#006621 '>{$link}</FONT></br>";
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'V.A.T. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '<B>' . getSource($link, 'all') . '<sup><font size="1">' . $property . '</font></sup> : </B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmount0']) + fromTextToNumber($uniqueResults[$i]['contractAmount1']) + fromTextToNumber($uniqueResults[$i]['contractAmount2']);
echo '<B>' . fromNumberToText($sumContracts, '$') . '</B>';
$counterContracts = $uniqueResults[$i]['contractCounter0'] + $uniqueResults[$i]['contractCounter1'] + $uniqueResults[$i]['contractCounter2'];
echo ' (<B>' . round($counterContracts, 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
echo "</td>";
} else {
if (strpos($link, '/newyorkstate/') !== false) {
//Νέα Υόρκη-πόλιτεία
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
echo "<a href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
echo "<FONT COLOR='#006621 '>{$link}</FONT></br>";
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'V.A.T. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '<B>' . getSource($link, 'all') . '<sup><font size="1">' . $property . '</font></sup> : </B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmount0']) + fromTextToNumber($uniqueResults[$i]['contractAmount1']) + fromTextToNumber($uniqueResults[$i]['contractAmount2']);
echo '<B>' . fromNumberToText($sumContracts, '$') . '</B>';
$counterContracts = $uniqueResults[$i]['contractCounter0'] + $uniqueResults[$i]['contractCounter1'] + $uniqueResults[$i]['contractCounter2'];
echo ' (<B>' . round($counterContracts, 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
echo "</td>";
} else {
if (strpos($link, 'product') !== false && strpos($link, 'eprices') !== false) {
//φασόλια
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo '<B>'.$psName.'</B><br>';
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$psName}</a> </br>";
//echo '<B>';
//echo "<a href='".$nameLink."'target='_blank' >Στο ΠΑΡΑΤΗΡΗΤΗΡΙΟ ΤΙΜΩΝ</a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.75em">ΠΑΡΑΤΗΡΗΤΗΡΙΟ ΤΙΜΩΝ-Προϊόν</font></br> ';
//echo '</B>';
//echo '<B>';
//echo ' <font color="#FFA500" size="1">ΠΡΟΙΟΝ</font></br> ';
//echo '</B>';
echo '<font color="#FFA500" style="font-size: 0.80em">Μέση 2015 </font> ';
echo '<B>';
echo $uniqueResults[$i]['average'];
echo '</B>';
echo ' ';
echo '<font color="#FFA500" style="font-size: 0.80em">Διαφορά Τιμής 2015 </font> ';
echo '<B>';
echo $uniqueResults[$i]['variationPrice'];
echo '</B>';
echo '</br>';
echo '<font color="#FFA500" style="font-size: 0.80em">Χαμηλότερη τιμή 2015 </font> ';
echo '<B>';
echo $uniqueResults[$i]['minPrice'] . '/' . $uniqueResults[$i]['unitOfMeasurement'];
echo '</B>';
echo ' ';
$locMin = $uniqueResults[$i]['locMin'];
echo "<FONT size='2'>{$locMin}</FONT>";
echo '</br>';
echo '<font color="#FFA500" style="font-size: 0.80em">Υψηλότερη τιμή 2015 </font> ';
echo '<B>';
echo $uniqueResults[$i]['maxPrice'] . '/' . $uniqueResults[$i]['unitOfMeasurement'];
echo '</B>';
echo ' ';
$locMax = $uniqueResults[$i]['locMax'];
echo "<FONT size='2'>{$locMax}</FONT>";
echo '</br>';
echo '[';
echo '<font style="font-size: 0.80em">Τελευταία ενημέρωση </font> ';
echo $uniqueResults[$i]['lastUpdate'];
echo ']';
echo "</td>";
echo "</td>";
} else {
if (strpos($link, 'product') !== false && strpos($link, 'kath') !== false) {
//Αγγουράκια
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo '<B>'.mb_strtoupper($psName, "UTF-8").'</B><br>';
$psName = mb_strtoupper($psName, "UTF-8");
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$psName}</a> </br>";
//echo '<B>';
//echo "<a href='".$nameLink."'target='_blank' >Στην ΚΕΝΤΡΙΚΗ ΑΓΟΡΑ ΘΕΣ/ΝΙΚΗΣ</a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.75em">ΚΕΝΤΡΙΚΗ ΑΓΟΡΑ ΘΕΣ/ΝΙΚΗΣ-Προϊόν</font></br> ';
//echo '</B>';
//echo '<B>';
//echo ' <font color="#FFA500" size="1">ΠΡΟΙΟΝ</font></br> ';
//echo '</B>';
echo '<font color="#FFA500" style="font-size: 0.80em">Επικρατέστερη τιμή </font> ';
echo ' ';
echo '<B>';
echo $uniqueResults[$i]['dominantPriceDetails'] . ' €/' . $uniqueResults[$i]['unitOfMeasurement'];
echo '</B>';
echo ' ';
echo '<font color="#FFA500" style="font-size: 0.80em">Επικρατέστερη εβδομάδας </font> ';
echo ' ';
echo '<B>';
echo $uniqueResults[$i]['weekDominantPriceDetails'] . ' €/' . $uniqueResults[$i]['unitOfMeasurement'];
echo '</B>';
echo '</br>';
echo '<font color="#FFA500" style="font-size: 0.80em">Επικρατέστερη έτους </font> ';
echo ' ';
echo '<B>';
echo $uniqueResults[$i]['yearDominantPriceDetails'] . ' €/' . $uniqueResults[$i]['unitOfMeasurement'];
echo '</B>';
echo ' ';
echo '<font color="#FFA500" style="font-size: 0.80em">Ποσότητα προς διάθεση </font> ';
echo ' ';
echo '<B>';
echo $uniqueResults[$i]['quantityDetails'] . ' κιλά';
echo '</br>';
echo '</B>';
echo '[';
echo '<font style="font-size: 0.80em">Τελευταία ενημέρωση </font> ';
echo $uniqueResults[$i]['lastUpdate'];
echo ']';
echo "</td>";
} else {
if (strpos($link, 'shop') !== false && strpos($link, 'eprices') !== false) {
//ΣΚΛΑΒΕΝΙΤΗΣ ΒΑΡΗΣ
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo '<B>'.$name.'</B><br>';
//echo "<FONT COLOR='#006621 '>$link</FONT></br>";
//echo '<B>'.$psName.'</B><br>';
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$psName}</a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΠΑΡΑΤΗΡΗΤΗΡΙΟ ΤΙΜΩΝ-Σημείο Πώλησης</font></br> ';
//echo '<B>';
//echo "<a href='".$nameLink."'target='_blank' >Στο ΠΑΡΑΤΗΡΗΤΗΡΙΟ ΤΙΜΩΝ</a> </br>";
//echo '</B>';
//echo '<B>';
//echo ' <font color="#FFA500" size="1">ΣΗΜΕΙΟ ΠΩΛΗΣΗΣ</font></br> ';
//echo '</B>';
//echo 'Πλήθος Ειδών ';
echo '<font color="#FFA500" style="font-size: 0.80em">Προϊόντα </font> ';
echo '<B>';
echo $uniqueResults[$i]['countOfProducts'];
echo '</B>';
echo ' ';
echo '<font color="#FFA500" style="font-size: 0.80em">Κατηγορίες </font> ';
echo '<B>';
echo $uniqueResults[$i]['countOfCategories'];
echo '</B>';
echo '</br>';
echo '<font color="#FFA500" style="font-size: 0.80em">Υψηλότερη τιμή </font> ';
echo '<B>';
echo $uniqueResults[$i]['maxPrice'] . '/' . $uniqueResults[$i]['unitOfMeasurementMax'];
echo '</B>';
echo ' ';
$maxProdName = $uniqueResults[$i]['maxProdName'];
echo "<FONT size='2'>{$maxProdName}</FONT>";
echo '</br>';
echo '<font color="#FFA500" style="font-size: 0.80em">Χαμηλότερη τιμή </font> ';
echo '<B>';
echo $uniqueResults[$i]['minPrice'] . '/' . $uniqueResults[$i]['unitOfMeasurementMin'];
echo '</B>';
echo ' ';
$minProdName = $uniqueResults[$i]['minProdName'];
echo "<FONT size='2'>{$minProdName}</FONT>";
echo '</br>';
echo '[';
echo '<font style="font-size: 0.80em">Τελευταία ενημέρωση </font> ';
echo $uniqueResults[$i]['lastUpdate'];
echo ']';
echo "</td>";
} else {
//κημδης και τα αλλα 023199666
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:400px;\">";
//echo "<a href='".$nameLink."'target='_blank' >$name</a> </br>";
//echo '<B>'.$name.'</B><br>';
echo "<a class='nameLink' href='" . $nameLink . "'target='_blank' >{$name}</a> </br>";
//echo "<FONT COLOR='#006621 '>$link</FONT></br>";
echo '<I>';
echo hide_not_avail($uniqueResults[$i]['address']);
echo ' ';
echo hide_not_avail($uniqueResults[$i]['pc']);
echo ' ';
echo hide_not_avail_space($uniqueResults[$i]['city']);
echo ' ';
echo 'Α.Φ.Μ. ' . hide_not_avail($uniqueResults[$i]['vat'] . "</br>");
echo '</I>';
//echo "<a href='".$nameLink."'target='_blank' > <B>Στo ΚΗΜΔΗΣ</B></a> </br>";
echo ' <font class="dataset" color="#006621" style="font-size: 0.77em">ΚΗΜΔΗΣ</font></br> ';
//echo '<B>';
echo ' <font color="#FFA500" size="1">' . $property . '</font> ';
//echo '<B>';
//echo '<B>'.(getSource($link,'all')).'<sup><font size="1">'.$property.'</font></sup> : </B>';
echo 'Συμβάσεις: ';
$sumContracts = fromTextToNumber($uniqueResults[$i]['contractAmountPrev']) + fromTextToNumber($uniqueResults[$i]['contractAmountCur']);
echo '<B>' . fromNumberToText($sumContracts, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['contractItemsNo'], 0) . '</B>) ';
echo 'Πληρωμές: ';
$sumPayments = fromTextToNumber($uniqueResults[$i]['paymentAmountPrev']) + fromTextToNumber($uniqueResults[$i]['paymentAmountCur']);
echo '<B>' . fromNumberToText($sumPayments, '€') . '</B>';
echo ' (<B>' . round($uniqueResults[$i]['paymentItemsNo'], 0) . '</B>) ';
echo '   [έως ' . $uniqueResults[$i]['lastUpdate'] . ']';
echo "</td>";
}
}
}
}
}
}
}
}
}
}
}
}
/*echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:200px;\">";
if(empty($uniqueResults[$i]['vat']) || ((strpos($link,'newyorkstate') !== false) && (strpos($link,'seller') !== false)) ) {
echo "-";
}
else
echo $uniqueResults[$i]['vat']; //HIDDEN
echo "</td>";
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:200px;\">";
//echo getSource($link);
echo "</td>";
*/
echo "<td style=\" text-align:left; border-left: 0px solid #ccc; font-size:15px; padding-right:0px; width:80px;\">";
echo $uniqueResults[$i]['score'];
//hidden
echo "</td>";
echo "</tr>";
}
$i++;
}
echo "</tbody>";
echo "</table>";
}
$noUsefull = array(".", ",", "-", "_", "'", '"', "?", "!", "@", "/");
if (!isset($_GET['search'])) {
$searchWords = ' ';
} else {
$searchWords = $_GET['search'];
}
$search = explode(" ", strtolower(str_replace($noUsefull, " ", $searchWords)));
$result = array();
foreach ($search as $word) {
$word = str_replace(" ", "", $word);
if ($word == "") {
continue;
}
array_push($result, $eshop->searchInItems($word));
$result = unique_multidim_array($result, 'id');
}
if (isset($result[0])) {
$AllItems = $result[0];
$items = array();
$i = 0;
foreach ($AllItems as $item) {
$items[$i] = $item;
$i++;
}
} else {
$items = array();
}
$itemsOnPage = array(6, 12, 21, 45, 60, 90);
$itemOnPageOptions = '';
foreach ($itemsOnPage as $item) {
