/** * 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) {