?> <pre><?php print_r(EasyCsv::GetHeader($csv)); // foreach (array_diff(EasyCsv::GetHeader($csv), array( // 'id', // 'Name', // 'LAT_Y', // 'LONG_X', // 'What happened?' // )) as $field) { // echo $field; // $u = EasyCsv::DistinctValues($csv, $field); // sort($u); // print_r($u); // } $icons = EasyCsv::DistinctValues($csv, '0'); sort($icons); print_r($icons); $iconMap = array('TV - private : new' => 'components/com_geolive/users_files/user_files_400/Uploads/Fxs_[G]_jHI_[ImAgE]_buK.png', 'TV - private : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/ga_wNP_K7a_[ImAgE]_[G].png', 'TV - private : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_lo2_phB_jMK_[ImAgE].png', 'TV - private : increase in service' => 'components/com_geolive/users_files/user_files_400/Uploads/VXX_LBi_BZ7_[G]_[ImAgE].png', 'TV - public : new' => 'components/com_geolive/users_files/user_files_400/Uploads/7j8_[ImAgE]_0W3_[G]_EKx.png', 'TV - public : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_fe3_DIh_m6r_[ImAgE].png', 'TV - public : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_Kva_[G]_KNi_GhP.png', 'TV - public : increase in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_Ti1_cfJ_[ImAgE]_AEg.png', 'community paper : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/5EY_bPb_9pu_[G]_[ImAgE].png', 'community paper : closed due to merger' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_ckm_cLL_[G]_dQ6.png', 'community paper : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_k1v_esb_cE_[ImAgE].png', 'community paper : increase in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_Drp_yoW_[ImAgE]_bO8.png', 'community paper : new' => 'components/com_geolive/users_files/user_files_400/Uploads/MzA_[G]_[ImAgE]_itZ_37m.png', 'community paper : new outlet produced by merger' => 'components/com_geolive/users_files/user_files_400/Uploads/Ffw_[G]_WO_A9_[ImAgE].png', 'community paper : shifted to online' => 'components/com_geolive/users_files/user_files_400/Uploads/A5b_[G]_PTW_[ImAgE]_jjt.png', 'daily paper - free : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/ESs_jwW_3d_[G]_[ImAgE].png', 'daily paper - free : new' => 'components/com_geolive/users_files/user_files_400/Uploads/qIw_uFv_[G]_bsm_[ImAgE].png', 'daily paper - free : increase in service' => 'components/com_geolive/users_files/user_files_400/Uploads/Xfp_DTl_[G]_avi_[ImAgE].png', 'daily paper - free : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_zrH_oVI_BtL_[G].png', 'daily paper - free : daily becomes a community paper' => 'components/com_geolive/users_files/user_files_400/Uploads/nPT_[ImAgE]_[G]_HnR_1gp.png', 'daily paper - paid : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/95V_k0J_[ImAgE]_EWi_[G].png', 'daily paper - paid : new' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_[G]_UWx_N5D_OhI.png', 'daily paper - paid : closed due to merger' => 'components/com_geolive/users_files/user_files_400/Uploads/Rs8_[G]_LGP_[ImAgE]_cQ5.png', 'daily paper - paid : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_[G]_mYW_wsV_Jte.png', 'daily paper - paid : new' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_[G]_UWx_N5D_OhI.png', 'daily paper - paid : new outlet produced by merger' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_ytA_531_[ImAgE]_04.png', 'daily paper - paid : daily becomes a community paper' => 'components/com_geolive/users_files/user_files_400/Uploads/PYa_[ImAgE]_kk8_[G]_lV6.png', 'online : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_L9q_GPZ_[ImAgE]_CSi.png', 'online : new' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_Qrd_6BY_[ImAgE]_FYG.png', 'online : increase in service' => 'components/com_geolive/users_files/user_files_400/Uploads/SPT_WE6_[ImAgE]_XPb_[G].png', 'online : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/08u_[G]_7Ze_[ImAgE]_e4x.png', 'radio - private : new' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_[G]_gB3_9Vv_ShV.png', 'radio - private : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_FB8_[ImAgE]_XxD_L0W.png', 'radio - private : increase in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_[ImAgE]_sbP_IWk_QIL.png', 'radio - private : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/qok_qWp_[G]_[ImAgE]_QvV.png', 'radio - public : new' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_hAM_[G]_Rs0_pRI.png', 'radio - public : decrease in service' => 'components/com_geolive/users_files/user_files_400/Uploads/[G]_[ImAgE]_YCD_BF5_H7l.png', 'radio - public : increase in service' => 'components/com_geolive/users_files/user_files_400/Uploads/XKD_[G]_[ImAgE]_e3z_Q48.png', 'radio - public : closed' => 'components/com_geolive/users_files/user_files_400/Uploads/[ImAgE]_[G]_CHO_gOM_tjn.png'); ?> <style> div { height: 30px; background-color: aliceblue; margin: 0; } img { height: 30px; vertical-align: middle; }
include_once dirname(__DIR__) . '/administrator/components/com_geolive/core.php'; include_once Core::LibDir() . DS . 'easycsv' . DS . 'EasyCsv.php'; $csv = EasyCsv::OpenCsv(__DIR__ . DS . 'sites.csv'); Core::LoadPlugin('Maps'); $layers = MapController::GetAllLayers(); $ShowNew = true; $ShowExisting = false; ?> <pre><?php foreach ($layers as $layer) { /* @var $layer Layer */ print_r(array($layer->getId(), $layer->getName())); } $layerMap = array('community paper' => 1, 'daily paper - free' => 1, 'daily paper - paid' => 1, 'online' => 4, 'TV - private' => 3, 'TV - public' => 3, 'radio - public' => 2, 'radio - private' => 2); if (!EasyCsv::DistinctValues($csv, 'Name')) { die('Expected \'Name\' field to contain unique values'); } EasyCsv::IterateRows_Assoc($csv, function ($row) use($layerMap, $ShowNew, $ShowExisting) { //$typeOfNews=$row['Type of news']; $typeOfNews = trim(array_shift(explode(':', $row['0']))); if (key_exists($typeOfNews, $layerMap)) { if (MapController::GetFeatureWithName($row['Name'])) { if ($ShowSkipped) { echo 'Existing Marker: ' . $row['Name'] . "\n"; } return; // skip. } else { } $marker = new Marker();