Example #1
0
 public function getOfferOut($reseller_id, $offerout_id)
 {
     $collection = [];
     $offers = Model::Offerout()->where(['id', '=', $offerout_id])->exec();
     foreach ($offers as $offer) {
         $item = [];
         $articles = Model::Articleout()->where(['offerout_id', '=', $offer['id']])->exec();
         $item['id'] = $offer['id'];
         $item['status_id'] = $offer['status_id'];
         $item['date_creation'] = $offer['created_at'];
         $item['date_expiration_offerin'] = $offer['expiration_offerin'];
         $zip = isAke($offer, 'zip', false);
         if (false !== $zip) {
             $item['buyer']['zip'] = $zip;
             $company = Model::Company()->find($offer['company_id']);
             if ($company) {
                 $item['buyer']['city'] = $company->city;
                 $item['buyer']['is_pro'] = $company->is_pro;
                 $item['buyer']['is_pro'] = $company->is_pro;
                 $item['buyer']['name'] = $company->name;
             }
             $market = jmodel('segment')->find($offer['market']);
             if ($market) {
                 $item['market']['id'] = $market->id;
                 $item['market']['name'] = $market->name;
                 $data = repo('segment')->getData($market->id);
                 $icon = isAke($data, 'icon', null);
                 $item['market']['icon'] = $icon;
             }
             $item['category_id'] = $offer['category'];
             if ($offer['category'] > 0) {
                 $segCat = jmodel('segment')->find($offer['category']);
                 $item['category_name'] = $segCat->name;
                 $data = repo('segment')->getData($segCat->id);
                 $icon = isAke($data, 'icon', null);
                 $item['category_icon'] = $icon;
             } else {
                 $item['category_name'] = 'autre';
                 $item['category_icon'] = 'fa fa-cubes';
             }
             foreach ($articles as $article) {
                 $it = $article;
                 $seg = jmodel('segment')->find($article['item_id']);
                 if ($seg) {
                     $it['family'] = repo('segment')->getFamilyfromItem($article['item_id']);
                     $it['name'] = $seg->name;
                     $item['articles'][] = $it;
                 } else {
                     if ($article['item_id'] == 0) {
                         $item['articles'][] = $article;
                     }
                 }
             }
             array_push($collection, $item);
         }
     }
     return current($collection);
 }
Example #2
0
 public function consolidate($reseller_id = null)
 {
     $q = Model::Product();
     if (!is_null($reseller_id)) {
         $q->where(['reseller_id', '=', (int) $reseller_id]);
     }
     $products = $q->cursor();
     foreach ($products as $product) {
         if (isset($product['reseller_id']) && isset($product['segment_id']) && isset($product['sellzone_id'])) {
             $row = Model::Productdata()->firstOrCreate(['reseller_id' => (int) $product['reseller_id'], 'segment_id' => (int) $product['segment_id'], 'sellzone_id' => (int) $product['sellzone_id']]);
             unset($product['_id']);
             $row->product = $product;
             $family = repo('segment')->getFamilyfromItem((int) $product['segment_id']);
             if (!empty($family)) {
                 $market = current($family);
                 $market_id = (int) $market['id'];
             } else {
                 $market_id = $segment_id;
             }
             $company = Model::Company()->where(['reseller_id', '=', (int) $product['reseller_id']])->first(false);
             $reseller = Model::Reseller()->find((int) $product['reseller_id'], false);
             $segment = Model::Segment()->find((int) $product['segment_id'], false);
             $location = lib('utils')->remember('has.locations.companies.' . $product['reseller_id'], function ($reseller_id) {
                 $company = Model::Company()->where(['reseller_id', '=', (int) $reseller_id])->first(true);
                 if ($company) {
                     $coords = lib('geo')->getCoordsMap($company->address . ' ' . $company->zip . ' ' . $company->city);
                     $loc = ['lng' => $coords['lng'], 'lat' => $coords['lat']];
                 }
                 return $loc;
             }, Model::Company()->getAge(), [$product['reseller_id']]);
             $status = (int) lib('status')->getId('reseller', 'REGISTER') == $reseller['status_id'];
             $row->company = $company;
             $row->segment = $segment;
             $row->status = $status;
             $row->location = $location;
             $row->reseller = $reseller;
             $options = [];
             $resellerObj = Model::Reseller()->model($reseller);
             $hasAgenda = lib('option')->get('agenda.partage', $resellerObj, false);
             $distanceMaxReseller = (double) lib('option')->get('zone.intervention.' . $market_id, $resellerObj, 0);
             $delai_presta = lib('option')->get('delai.intervention.' . $market_id, $resellerObj, 0);
             $minAmount = lib('option')->get('montant.intervention.' . $market_id, $resellerObj, 0);
             $options['has_agenda'] = $hasAgenda;
             $options['distance_max'] = $distanceMaxReseller;
             $options['delai_min'] = $delai_presta;
             $options['amount_min'] = $minAmount;
             $options['languages'] = [];
             $languages = ['anglais', 'espagnol', 'allemand', 'italien', 'néerlandais', 'portugais', 'russe', 'japonais', 'chinois'];
             foreach ($languages as $language) {
                 $speak = lib('option')->get('langue.' . $market_id . '.' . $language, $resellerObj, false);
                 $options['languages'][$language] = $speak;
             }
             $row->options = $options;
             $row->save();
         }
     }
 }
Example #3
0
 public function fiche($reseller_id)
 {
     $user = session('user')->getUser();
     if (!$user) {
         $user = [];
     }
     $account_id = (int) isAke($user, 'id', 23);
     $fiche = Model::Restodata()->where(['reseller_id', '=', (int) $reseller_id])->first(true);
     /* c'est un restaurateur */
     if ($fiche) {
         $row = $fiche->toArray();
         $data = [];
         $options = $row['options'];
         $preferences_client_paiement_titre = isAke($options, 'preferences_client_paiement_titre', false);
         $data['paiement_cheque_montant_max'] = isAke($options, 'preferences_client_paiement_cheque_montant_max', 0);
         $data['paiement_carte'] = isAke($options, 'preferences_client_paiement_carte', -1);
         $data['paiement_titre_rendu_monnaie'] = isAke($options, 'preferences_client_paiement_titre_rendu_monnaie', $preferences_client_paiement_titre ? 0 : -1);
         $data['paiement_titre_max_accepte'] = isAke($options, 'preferences_client_paiement_titre_max_accepte', null);
         $data['company'] = $row['company'];
         $data['company']['siret'] = (string) isAke($row['company'], 'siret', '');
         $data['company']['tel'] = (string) str_replace([" ", ".", "-", "+"], ["", "", "", "00"], isAke($row['company'], 'tel', ''));
         if (fnmatch('0*', $data['company']['tel'])) {
             $data['company']['tel'] = strReplaceFirst('0', '+33', $data['company']['tel']);
         }
         $data['is_favorite'] = lib('favorite')->has('reseller', (int) $reseller_id, (int) $account_id);
         $data['is_resto'] = true;
         $data['nombre_places'] = $options['nombre_places'];
         $data['nombre_places_terrasse'] = $options['nombre_places_terrasse'];
         $horaires = [];
         $schedules = $row['schedules'];
         foreach ($schedules as $typeSchedule => $days) {
             if (!isset($horaires[$typeSchedule])) {
                 $horaires[$typeSchedule] = [];
             }
             foreach ($days as $day => $dataSchedule) {
                 if (!isset($horaires[$typeSchedule][$day])) {
                     $horaires[$typeSchedule][$day] = [];
                 }
                 foreach ($dataSchedule as $when => $hour) {
                     $hour = str_replace('_', 'h', $hour);
                     $horaires[$typeSchedule][$day][$when] = str_replace('h00', 'h', $hour);
                 }
             }
         }
         $data['horaires'] = $horaires;
         $prefsResto = array_keys(lib('resto')->extractPreferences($options));
         $activitesResto = array_keys(lib('resto')->extractActivites($options));
         $labelsResto = array_keys(lib('resto')->extractLabels($options));
         $thematiquesResto = array_keys(lib('resto')->extractThematiques($options));
         $guidesResto = array_keys(lib('resto')->extractGuides($options));
         $optionsMacro = (include APPLICATION_PATH . DS . 'models/options/413.php');
         $valuesGuides = array_get($optionsMacro, 'guides.values');
         $valuesActivities = array_get($optionsMacro, 'activites.values');
         $themes_affil = array_get($optionsMacro, 'activites.types_affil');
         $valuesThematiques = [];
         $valuesThematiques = array_merge($valuesThematiques, array_get($optionsMacro, 'thematiques.values_0'));
         $valuesThematiques = array_merge($valuesThematiques, array_get($optionsMacro, 'thematiques.values_1'));
         $valuesThematiques = array_merge($valuesThematiques, array_get($optionsMacro, 'thematiques.values_2'));
         $valuesThematiques = array_merge($valuesThematiques, array_get($optionsMacro, 'thematiques.values_3'));
         $valuesLabels = [];
         $valuesLabels = array_merge($valuesLabels, array_get($optionsMacro, 'labels.values_0'));
         $valuesLabels = array_merge($valuesLabels, array_get($optionsMacro, 'labels.values_1'));
         $acts = $themes = $lbls = $prefs = $guides = [];
         foreach ($guidesResto as $guidesId) {
             $guides[] = $valuesGuides[(int) str_replace('guides_', '', $guidesId)];
         }
         foreach ($activitesResto as $activiteId) {
             if (fnmatch('*_*_*', $activiteId)) {
                 continue;
             }
             $acts[] = $valuesActivities[(int) str_replace('activites_', '', $activiteId)];
         }
         foreach ($thematiquesResto as $thematiquesId) {
             $ind = str_replace('thematiques_', 'thematiques.values_', $thematiquesId);
             $last = Arrays::end(explode('_', $ind));
             $ind = str_replace('_' . $last, '.' . $last, $ind);
             $ind = str_replace('thematiques.values.', 'thematiques.values_', $ind);
             $val = array_get($optionsMacro, $ind);
             $themes[] = $val;
         }
         foreach ($labelsResto as $labelsId) {
             $ind = str_replace('labels_', 'labels.values_', $labelsId);
             $last = Arrays::end(explode('_', $ind));
             $ind = str_replace('_' . $last, '.' . $last, $ind);
             $ind = str_replace('labels.values.', 'labels.values_', $ind);
             $val = array_get($optionsMacro, $ind);
             $lbls[] = $val;
         }
         // foreach ($labelsResto as $labelsId) {
         //     $lbls[] = $valuesLabels[(int) str_replace('thematiques_', '', $labelsId)];
         // }
         foreach ($prefsResto as $index) {
             $tab = explode('_', $index);
             if (is_numeric(end($tab))) {
                 if (!isset($prefs[str_replace(['preferences_client_', '_' . end($tab)], '', $index)])) {
                     $prefs[str_replace(['preferences_client_', '_' . end($tab)], '', $index)] = [];
                 }
                 $values = array_get($optionsMacro, str_replace('_' . end($tab), '', $index) . '.values');
                 $prefs[str_replace(['preferences_client_', '_' . end($tab)], '', $index)][] = $values[end($tab)];
             }
         }
         $prefs['paiement'] = array_merge(isset($prefs['paiement_carte']) ? $prefs['paiement_carte'] : [], isset($prefs['paiement_titre']) ? $prefs['paiement_titre'] : []);
         unset($prefs['paiement_carte']);
         unset($prefs['paiement_titre']);
         $prefs['prestations_de_reception'] = array_merge(isset($prefs['prestations_specifiques']) ? $prefs['prestations_specifiques'] : [], isset($prefs['prestations_de_reception']) ? $prefs['prestations_de_reception'] : [], isset($prefs['prestations_de_reception_langue']) ? $prefs['prestations_de_reception_langue'] : []);
         unset($prefs['prestations_specifiques']);
         // unset($prefs['prestations_de_reception']);
         unset($prefs['prestations_de_reception_langue']);
         $p = [];
         foreach ($prefs as $k => $v) {
             $p[] = ['name' => $k, 'data' => $v];
         }
         $prefs = $p;
         $data['activites'] = array_values(array_unique($acts));
         $data['thematiques'] = array_values(array_unique($themes));
         $data['labels'] = array_values(array_unique($lbls));
         $data['preferences'] = $prefs;
         $data['guides'] = array_values(array_unique($guides));
         $data['location'] = $row['loc'];
         $extras = Model::Extradata()->where(['reseller_id', '=', (int) $reseller_id])->cursor()->first();
         if (empty($extras)) {
             $extras = ['access' => 'Prendre Tram 1 descendre à l\'arrêt Godrans.'];
         }
         $data['extras'] = $extras;
         $myzelift = Model::Myzelift()->where(['reseller_id', '=', (int) $reseller_id])->cursor()->first();
         if (!isset($myzelift['general_intro_1'])) {
             $myzelift = ['general_intro_1' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis intro 1', 'general_intro_2' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis intro 2', 'general_1' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 1', 'general_2' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 2', 'general_3' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 3', 'general_4' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 4', 'plus_1' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 1', 'plus_2' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 1', 'plus_3' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 1', 'coeur_1' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 1', 'coeur_2' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 1', 'coeur_3' => 'Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis Lorem ipsum aequitis 1'];
         }
         if (isset($myzelift['images']) && isset($myzelift['data'])) {
             $zc = [];
             $zc['images'] = $myzelift['images'];
             $zc['data'] = $myzelift['data'];
             $myzelift = $zc;
         }
         $carte = $row['carte'];
         $nc = $c = [];
         $categories = Model::Catalogcategory()->cursor();
         foreach ($categories as $cat) {
             $nc[] = ['name' => $cat['name'], 'data' => $carte[$cat['id']]];
         }
         $data['carte'] = $nc;
         $data['myzelift'] = $myzelift;
         return $data;
     } else {
         /* ce n'est pas un restaurateur */
         $tab = Model::Company()->where(['reseller_id', '=', (int) $reseller_id])->first(false);
         $tab['rate'] = 0;
         $tab['is_resto'] = false;
         return $tab;
     }
 }
Example #4
0
 public function create($args)
 {
     return Model::Company()->create($args)->save();
 }
Example #5
0
 function consolidate($reseller_id = null)
 {
     Save::clean();
     // $szs = Model::Sellzone()->cursor();
     // foreach ($szs as $sz) {
     //     $coll = [];
     //     $zips = Model::Coveredcity()->where(['sellzone_id', '=', (int) $sz['id']])->cursor();
     //     foreach ($zips as $zip) {
     //         $cs = Model::City()->where(['zip', '=', (string) $zip['zip']])->cursor();
     //         foreach ($cs as $c) {
     //             $n      = str_replace(' ', '_', Inflector::unaccent(Inflector::lower($zip['name'])));
     //             $n2     = str_replace(' ', '_', Inflector::unaccent(Inflector::lower($c['name'])));
     //             if ($n == $n2) {
     //                 $coll[] = [
     //                     'insee' => $c['insee'],
     //                     'zip'   => $zip['zip'],
     //                     'name'  => $c['name'],
     //                 ];
     //             }
     //         }
     //     }
     //     $coll = array_values(array_unique($coll));
     //     redis()->set('insees.' . $sz['id'], serialize($coll));
     // }
     $plats = Model::Mealgeo()->cursor();
     $geos = [];
     foreach ($plats as $plat) {
         if (!isset($geos[$plat['resto_geo_id']])) {
             $geos[$plat['resto_geo_id']] = [];
         }
         $geos[$plat['resto_geo_id']][] = $plat['segment_id'];
     }
     foreach ($geos as $id => $tab) {
         redis()->set('geos.spes.' . $id, serialize($tab));
     }
     $ids = repo('segment')->getAllFamilyIds(1941);
     $names = [];
     $segs = Model::Segment()->where(['id', 'IN', implode(',', $ids)])->cursor();
     foreach ($segs as $seg) {
         $data = repo('segment')->getData((int) $seg['id']);
         $is_item = isAke($data, 'is_item', false);
         if (false !== $is_item) {
             $names[] = $seg['name'];
         }
     }
     asort($names);
     redis()->set('sucres', serialize(array_values($names)));
     $suggestIds = [];
     $segments = Model::Segment()->reset()->where(['segmenttype_id', '=', 9])->cursor();
     $collection = [];
     foreach ($segments as $segment) {
         $data = repo('segment')->getData((int) $segment['id']);
         $ordre = isAke($data, 'ordre', 1);
         $segment['ordre'] = $ordre;
         $collection[] = $segment;
     }
     $collection = lib('collection', [$collection]);
     $collection->sortBy('ordre');
     $segments = $collection->toArray();
     foreach ($segments as $segment) {
         $data = repo('segment')->getData((int) $segment['id']);
         $segmentsItem = isAke($data, 'segments', false);
         if (false !== $segmentsItem) {
             $tab = explode(',', $segmentsItem);
             $item = [];
             $item['segments'] = [];
             $item['plats'] = [];
             foreach ($tab as $itId) {
                 $seg = Model::Segment()->find($itId);
                 if ($seg) {
                     if (!in_array($itId, $suggestIds)) {
                         $suggestIds[] = $itId;
                     }
                     $s = [];
                     $s['id'] = (int) $itId;
                     $s['name'] = $seg->name;
                     unset($s['created_at']);
                     unset($s['updated_at']);
                     $type = Model::segmenttype()->find($seg->segmenttype_id);
                     if ($type) {
                         $s['type'] = $type->name;
                     }
                     if (fnmatch('*non*', $type->name)) {
                         $plats = Model::Mealnonauto()->where(['resto_nonauto_id', '=', (int) $itId])->cursor();
                         foreach ($plats as $plat) {
                             $cat = Model::Catalog()->find((int) $plat['catalog_id']);
                             if ($cat) {
                                 $item['plats'][] = $cat->segment_id . '::' . $cat->reseller_id;
                             }
                         }
                     }
                     if (fnmatch('*_type*', $type->name)) {
                         $plats = Model::Mealtype()->where(['resto_type_id', '=', (int) $itId])->cursor();
                         foreach ($plats as $plat) {
                             $item['plats'][] = $plat['segment_id'];
                         }
                     }
                     if (fnmatch('*geo*', $type->name)) {
                         $plats = Model::Mealgeo()->where(['resto_geo_id', '=', (int) $itId])->cursor();
                         foreach ($plats as $plat) {
                             $item['plats'][] = $plat['segment_id'];
                         }
                     }
                 }
                 $item['segments'][] = $s;
             }
             $row = Model::Suggestion()->firstOrCreate(['segment_id' => (int) $segment['id']])->setName($segment['name'])->setSegments($item['segments'])->setPlats($item['plats'])->save();
         }
     }
     $days = ['lundi', 'mardi', 'mercredi', 'jeudi', 'vendredi', 'samedi', 'dimanche'];
     $when = ['am_start', 'am_end', 'pm_start', 'pm_end'];
     $q = Model::Optionsrestaurant();
     if (!is_null($reseller_id)) {
         $q->where(['reseller_id', '=', (int) $reseller_id]);
     }
     $restos = $q->cursor();
     foreach ($restos as $resto) {
         $schedules = [];
         $schedules['sur_place'] = [];
         $schedules['a_emporter'] = [];
         $schedules['en_livraison'] = [];
         $row = Model::Restodata()->firstOrCreate(['reseller_id' => (int) $resto['reseller_id'], 'sellzone_id' => (int) $resto['sellzone_id']]);
         $reseller_id = $resto['reseller_id'];
         $loc = isAke($row->toArray(), 'loc', []);
         $lat = isAke($loc, 'lat', false);
         $lng = isAke($loc, 'lng', false);
         if (!$lat || !$lng) {
             $company = Model::Company()->refresh()->where(['reseller_id', '=', (int) $reseller_id])->first(true);
             $coords = lib('geo')->getCoords($company->address . ' ' . $company->zip . ' ' . $company->city);
             $locationReseller = ['lng' => $coords['lng'], 'lat' => $coords['lat']];
         } else {
             $locationReseller = ['lng' => floatval($lng), 'lat' => floatval($lat)];
         }
         $options = $resto;
         unset($options['_id']);
         unset($options['reseller_id']);
         unset($options['sellzone_id']);
         unset($options['created_at']);
         unset($options['updated_at']);
         $pattern = 'type_restauration_sur_place_horaires_services_##day##_##when##';
         foreach ($days as $day) {
             if (!isset($collection[$day])) {
                 $schedules['sur_place'][$day] = [];
             }
             foreach ($when as $moment) {
                 $key = str_replace(['##day##', '##when##'], [$day, $moment], $pattern);
                 $schedules['sur_place'][$day][$moment] = str_replace(':', '_', $options[$key]);
             }
         }
         $pattern = 'type_restauration_a_emporter_horaires_services_##day##_##when##';
         foreach ($days as $day) {
             if (!isset($collection[$day])) {
                 $schedules['a_emporter'][$day] = [];
             }
             foreach ($when as $moment) {
                 $key = str_replace(['##day##', '##when##'], [$day, $moment], $pattern);
                 $schedules['a_emporter'][$day][$moment] = str_replace(':', '_', $options[$key]);
             }
         }
         $pattern = 'type_restauration_en_livraison_horaires_services_##day##_##when##';
         foreach ($days as $day) {
             if (!isset($collection[$day])) {
                 $schedules['en_livraison'][$day] = [];
             }
             foreach ($when as $moment) {
                 $key = str_replace(['##day##', '##when##'], [$day, $moment], $pattern);
                 $schedules['en_livraison'][$day][$moment] = str_replace(':', '_', isAke($options, $key, ''));
             }
         }
         $catalog_names = $plats_names = $families_types_auto_dispo = $families_types_non_auto_dispo = $families_plats_dispo = $pois_dispo = $families_pois_dispo = $specialites_dispo = $families_specialites_dispo = $spe_plats = $auto_plats = $non_auto_plats = $types_auto_dispo = $types_non_auto_dispo = $allPlats = $restoPlats = $composed = $assocs = $families = $names = $fathers = $jours = $services = $contraintes = $orders = $carte = $descriptions = $accompagnements = $pricePlats = [];
         $catalagCategories = [1 => [402, 406], 2 => [519, 500, 518, 521, 525, 522, 696, 1538, 2100], 3 => [668, 526, 690, 1530], 4 => [1528], 5 => [1952, 1958, 1548], 6 => [2167, 2168], 7 => [1942]];
         $tuplesPlats = [];
         $carte[1] = $carte[2] = $carte[3] = $carte[4] = $carte[5] = $carte[6] = $carte[7] = [];
         if ($row->carte) {
             foreach ($row->carte as $t => $ps) {
                 $carte[$t] = $ps;
                 foreach ($ps as $platCarte) {
                     $tuplesPlats[] = $platCarte['id'];
                 }
             }
         }
         $cursor = Model::Catalog()->where(['reseller_id', '=', (int) $resto['reseller_id']])->where(['is_challenge', '=', 1])->cursor();
         $collection = [];
         foreach ($cursor as $plat) {
             $segId = isAke($plat, 'segment_id', 0);
             if ($segId < 1) {
                 continue;
             }
             $plats = isAke($plat, 'plats', []);
             $accompagnements[$plat['id']] = isAke($plat, 'accompagnement', null);
             $descriptions[$plat['id']] = isAke($plat, 'description', null);
             if (!empty($plats)) {
                 $composed[$plat['segment_id']] = $plats;
             }
             $data = repo('segment')->getData((int) $plat['segment_id']);
             $ordre = isAke($data, 'ordre', 1);
             $plat['ordre'] = $ordre;
             $collection[] = $plat;
             $fathers[$plat['segment_id']] = repo('segment')->getFather($plat['segment_id'])['id'];
             $family = repo('segment')->getFamily($plat['segment_id']);
             foreach ($catalagCategories as $idCat => $segsCat) {
                 foreach ($family as $child) {
                     if (!isset($families[$plat['segment_id']])) {
                         $families[$plat['segment_id']] = [];
                     }
                     $families[$plat['segment_id']][$child['id']] = $child;
                     if (!in_array($plat['id'], $tuplesPlats)) {
                         if (in_array($child['id'], $segsCat)) {
                             unset($plat['_id']);
                             if ($plat['segment_id'] == 1548) {
                                 $carte[5][] = $plat;
                                 $p = Model::Catalog()->find((int) $plat['id']);
                                 $p->catalogcategory_id = 5;
                                 $p->save();
                             } else {
                                 $carte[$idCat][] = $plat;
                                 $p = Model::Catalog()->find((int) $plat['id']);
                                 $p->catalogcategory_id = (int) $idCat;
                                 $p->save();
                             }
                         }
                     }
                 }
             }
         }
         $collection = lib('collection', [$collection]);
         $collection->sortBy('ordre');
         $cursor = array_values($collection->toArray());
         $contraintes['jours'] = [];
         $contraintes['services'] = [];
         foreach ($cursor as $plat) {
             $s = Model::Segment()->find((int) $plat['segment_id']);
             if (!$s) {
                 continue;
             }
             $jours[$plat['id']] = isAke($plat, 'jours', []);
             $services[$plat['id']] = isAke($plat, 'services', []);
             if (!isset($contraintes['jours'][$plat['segment_id']])) {
                 $contraintes['jours'][$plat['segment_id']] = [];
             }
             if (!isset($contraintes['services'][$plat['segment_id']])) {
                 $contraintes['services'][$plat['segment_id']] = [];
             }
             $contraintes['jours'][$plat['segment_id']][$plat['id']] = isAke($plat, 'jours', []);
             $contraintes['services'][$plat['segment_id']][$plat['id']] = isAke($plat, 'services', []);
             if (!isset($assocs[$plat['id']])) {
                 $assocs[$plat['id']] = [];
                 $assocs[$plat['id']]['family'] = [];
                 $assocs[$plat['id']]['geo'] = [];
                 $assocs[$plat['id']]['auto'] = [];
                 $assocs[$plat['id']]['non_auto'] = [];
             }
             if (!isset($allPlats[$plat['segment_id']])) {
                 $allPlats[$plat['segment_id']] = [];
             }
             $restoPlats[$plat['segment_id']] = (int) $plat['id'];
             $pricePlats[$plat['id']] = (double) $plat['price'];
             $plat['data'] = repo('segment')->getData((int) $plat['segment_id']);
             $allPlats[$plat['segment_id']][] = $plat;
             $names[$plat['segment_id']] = $plats_names[$plat['segment_id']] = Model::Segment()->find((int) $plat['segment_id'])->name;
             $orders[$plat['segment_id']] = $plat['ordre'];
             $catalog_names[$plat['id']] = $plat['name'];
             $family = repo('segment')->getFamily((int) $plat['segment_id']);
             $assocs[$plat['id']]['family'][] = $plat['segment_id'];
             foreach ($family as $seg) {
                 if (!in_array($seg['id'], $families_plats_dispo)) {
                     $families_plats_dispo[] = $assocs[$plat['id']]['family'][] = $seg['id'];
                     $names[$seg['id']] = $seg['name'];
                 }
             }
             $mgeos = Model::Mealgeo()->where(['segment_id', '=', (int) $plat['segment_id']])->models();
             if ($mgeos->count() > 0) {
                 foreach ($mgeos as $mgeo) {
                     $s = Model::Segment()->find((int) $mgeo->resto_geo_id);
                     if (!$s) {
                         continue;
                     }
                     // if (!in_array($mgeo->resto_geo_id, $specialites_dispo)) {
                     if (!isset($spe_plats[$mgeo->resto_geo_id])) {
                         $spe_plats[$mgeo->resto_geo_id] = [];
                     }
                     $specialites_dispo[] = (int) $mgeo->resto_geo_id;
                     $names[$mgeo->resto_geo_id] = Model::Segment()->find((int) $mgeo->resto_geo_id)->name;
                     $family = repo('segment')->getFamily($mgeo->resto_geo_id);
                     $assocs[$plat['id']]['geo'][] = $mgeo->resto_geo_id;
                     $spe_plats[$mgeo->resto_geo_id][] = $plat['segment_id'];
                     foreach ($family as $seg) {
                         if (!isset($spe_plats[$seg['id']])) {
                             $spe_plats[$seg['id']] = [];
                         }
                         // $spe_plats[$seg['id']][] = $plat['segment_id'];
                         // $spe_plats[$mgeo->resto_geo_id][] = $plat['segment_id'];
                         if (!in_array($seg['id'], $families_specialites_dispo)) {
                             $families_specialites_dispo[] = $assocs[$plat['id']]['geo'][] = $seg['id'];
                             $names[$seg['id']] = $seg['name'];
                         }
                     }
                     // }
                 }
             }
             $mtypeautos = Model::Mealtype()->where(['segment_id', '=', (int) $plat['segment_id']])->models();
             if ($mtypeautos->count() > 0) {
                 foreach ($mtypeautos as $mtypeauto) {
                     // if (!in_array($mtypeauto->resto_type_id, $types_auto_dispo)) {
                     if (!isset($auto_plats[$mtypeauto->resto_type_id])) {
                         $auto_plats[$mtypeauto->resto_type_id] = [];
                     }
                     $auto_plats[$mtypeauto->resto_type_id][] = $plat['segment_id'];
                     $types_auto_dispo[] = (int) $mtypeauto->resto_type_id;
                     $names[$mtypeauto->resto_type_id] = Model::Segment()->find((int) $mtypeauto->resto_type_id)->name;
                     $family = repo('segment')->getFamily($mtypeauto->resto_type_id);
                     $assocs[$plat['id']]['auto'][] = $mtypeauto->resto_type_id;
                     foreach ($family as $seg) {
                         if (!isset($auto_plats[$seg['id']])) {
                             $auto_plats[$seg['id']] = [];
                         }
                         $auto_plats[$seg['id']][] = $plat['segment_id'];
                         $auto_plats[$mtypeauto->resto_type_id][] = $plat['segment_id'];
                         if (!in_array($seg['id'], $families_types_auto_dispo)) {
                             $families_types_auto_dispo[] = $assocs[$plat['id']]['auto'][] = $seg['id'];
                             $names[$seg['id']] = $seg['name'];
                         }
                     }
                     // }
                 }
             }
             $mtypeautos = Model::Mealnonauto()->where(['catalog_id', '=', (int) $plat['id']])->models();
             if ($mtypeautos->count() > 0) {
                 foreach ($mtypeautos as $mtypeauto) {
                     // if (!in_array($mtypeauto->resto_nonauto_id, $types_non_auto_dispo)) {
                     if (!isset($non_auto_plats[$mtypeauto->resto_nonauto_id])) {
                         $non_auto_plats[$mtypeauto->resto_nonauto_id] = [];
                     }
                     $non_auto_plats[$mtypeauto->resto_nonauto_id][] = $plat['segment_id'];
                     $types_non_auto_dispo[] = (int) $mtypeauto->resto_nonauto_id;
                     $names[$mtypeauto->resto_nonauto_id] = Model::Segment()->find((int) $mtypeauto->resto_nonauto_id)->name;
                     $family = repo('segment')->getFamily($mtypeauto->resto_nonauto_id);
                     $assocs[$plat['id']]['non_auto'][] = $mtypeauto->resto_nonauto_id;
                     foreach ($family as $seg) {
                         if (!isset($non_auto_plats[$seg['id']])) {
                             $non_auto_plats[$seg['id']] = [];
                         }
                         $non_auto_plats[$seg['id']][] = $plat['segment_id'];
                         // $non_auto_plats[$mtypeauto->resto_nonauto_id][] = $plat['segment_id'];
                         if (!in_array($seg['id'], $families_types_non_auto_dispo)) {
                             $families_types_non_auto_dispo[] = $assocs[$plat['id']]['non_auto'][] = $seg['id'];
                             $names[$seg['id']] = $seg['name'];
                         }
                     }
                     // }
                 }
             }
             $assocs[$plat['id']]['family'] = array_values(array_unique($assocs[$plat['id']]['family']));
             $assocs[$plat['id']]['geo'] = array_values(array_unique($assocs[$plat['id']]['geo']));
             $assocs[$plat['id']]['auto'] = array_values(array_unique($assocs[$plat['id']]['auto']));
             $assocs[$plat['id']]['non_auto'] = array_values(array_unique($assocs[$plat['id']]['non_auto']));
         }
         $pois = Model::Restopoi()->where(['sellzone_id', '=', (int) $resto['sellzone_id']])->where(['reseller_id', '=', (int) $resto['reseller_id']])->cursor();
         $distances = [];
         foreach ($pois as $poi) {
             if (!in_array($poi['segment_id'], $pois_dispo)) {
                 $poiSeg = Model::Segment()->find((int) $poi['segment_id']);
                 if ($poiSeg && (double) $poi['distance'] <= 0.5) {
                     $distances[$poi['segment_id']] = (double) $poi['distance'];
                     $pois_dispo[] = $poi['segment_id'];
                     $names[$poi['segment_id']] = $poiSeg->name;
                     $family = repo('segment')->getFamily((int) $poi['segment_id']);
                     foreach ($family as $seg) {
                         if (!in_array($seg['id'], $families_pois_dispo) && !in_array($seg['id'], $pois_dispo)) {
                             $families_pois_dispo[] = $seg['id'];
                             $names[$seg['id']] = $seg['name'];
                         }
                     }
                 }
             }
         }
         $row->reseller = Model::Reseller()->find((int) $resto['reseller_id'], false);
         $row->company = Model::Company()->where(['reseller_id', '=', (int) $resto['reseller_id']])->first(false);
         $zc = Model::Zechallenge()->where(['reseller_id', '=', (int) $resto['reseller_id']])->cursor()->first(true);
         if ($zc) {
             $status_zechallenge = $zc->status;
         } else {
             $status_zechallenge = 'WAITING';
             // Model::Zechallenge()->firstOrCreate([
             //     'reseller_id'   => (int) $resto['reseller_id']
             // ])->setStatus('WAITING')->save();
         }
         $segmentDatas = [];
         foreach ($names as $key => $n) {
             $datasK = repo('segment')->getData((int) $key);
             $segmentDatas[$key] = $datasK;
         }
         $orders = $grandfathers = [];
         foreach ($families as $s => $fathers) {
             $f = 0;
             foreach ($fathers as $father) {
                 if ($f == 2) {
                     $orders[$s] = isAke($father['data'], 'ordre', 1);
                     $grandfathers[$s] = $father;
                 }
                 $f++;
             }
         }
         $row->composed = $composed;
         $row->grandfathers = $grandfathers;
         $row->orders = $orders;
         $row->datas = $segmentDatas;
         $row->families = $families;
         $row->names = $names;
         $row->all_plats = $allPlats;
         $row->loc = $locationReseller;
         $row->options = $options;
         $row->schedules = $schedules;
         $row->status_zechallenge = $status_zechallenge;
         $q = Model::Zenews()->where(['status', '=', 'ACTIVE'])->where(['context', '=', 'resto'])->where(['reseller_id', '=', (int) $resto['reseller_id']])->cursor()->count();
         $hmz = Model::Myzelift()->where(['reseller_id', '=', (int) $resto['reseller_id']])->where(['status', '=', 'ACTIVE'])->first(true);
         if (!$hmz) {
             $hmz = false;
         } else {
             $hmz = true;
         }
         $row->has_myzelift = $hmz;
         $row->has_news = $q > 0 ? true : false;
         $row->pois = ['dispos' => $pois_dispo, 'distances' => $distances, 'families' => $families_pois_dispo];
         $row->specialites = ['dispos' => $specialites_dispo, 'families' => $families_specialites_dispo, 'plats' => $spe_plats];
         $row->auto = ['dispos' => $types_auto_dispo, 'families' => $families_types_auto_dispo, 'plats' => $auto_plats];
         $row->non_auto = ['dispos' => $types_non_auto_dispo, 'families' => $families_types_non_auto_dispo, 'plats' => $non_auto_plats];
         /* Rating */
         $rates = Model::Rating()->where(['reseller_id', '=', (int) $resto['reseller_id']])->cursor();
         $totalRate = 0;
         if ($rates->count() == 0) {
             $row->rate = 0;
         } else {
             foreach ($rates as $rateRow) {
                 $totalRate += (double) $rateRow['rate'];
             }
             $row->rate = (double) $totalRate / $rates->count();
         }
         $row->plats = ['ordre' => $orders, 'prices' => $pricePlats, 'segments' => array_keys($pricePlats), 'catalog' => $restoPlats, 'families' => $families_plats_dispo, 'names' => $plats_names, 'catalog_names' => $catalog_names, 'fathers' => $fathers];
         $resas = [];
         $customers = [];
         $old = Model::Restoreservation()->where(['reseller_id', '=', (int) $resto['reseller_id']])->where(['updated_at', '>=', strtotime('-6 month')])->cursor();
         foreach ($old as $resa) {
             $resas[] = ['account_id' => $resa['account_id'], 'date' => $resa['updated_at'], 'filter' => $resa['filter']];
             if (!isset($customers[$resa['account_id']])) {
                 $customers[$resa['account_id']] = 1;
             } else {
                 $customers[$resa['account_id']]++;
             }
         }
         $row->assocs = $assocs;
         $row->resas = $resas;
         $row->customers = $customers;
         $row->carte = $carte;
         $nc = $c = [];
         $categories = Model::Catalogcategory()->cursor();
         foreach ($categories as $cat) {
             $collection = lib('collection', [$carte[$cat['id']]])->sortBy('ordre')->toArray();
             $nc[$cat['name']] = array_values($collection);
         }
         $row->plats_ranges = $nc;
         $row->themes = lib('myzelift')->getThemesAffil($resto['reseller_id']);
         $extras = Model::Extradata()->where(['reseller_id', '=', (int) $resto['reseller_id']])->cursor()->first();
         if (empty($extras)) {
             $extras = ['access' => 'Prendre Tram 1 descendre à l\'arrêt Godrans.'];
         }
         $row->extras = $extras;
         $ups = [];
         $uplifts = Model::Uplift()->where(['status', '=', 'ACTIVE'])->where(['start', '<=', time()])->where(['reseller_id', '=', (int) $resto['reseller_id']])->cursor();
         foreach ($uplifts as $uplift) {
             unset($uplift['_id']);
             unset($uplift['created_at']);
             unset($uplift['updated_at']);
             // unset($uplift['reseller_id']);
             $type = Model::Uplifttype()->find($uplift['uplifttype_id'], false);
             unset($type['created_at']);
             unset($type['updated_at']);
             unset($type['id']);
             $uplift['type'] = $type;
             if (!isset($uplift['duration']) && isset($uplift['upliftduration_id'])) {
                 $duration = Model::Upliftduration()->find($uplift['upliftduration_id'], false);
                 unset($duration['created_at']);
                 unset($duration['updated_at']);
                 unset($duration['id']);
                 $uplift['duration'] = $duration;
             }
             $views = isset($uplift['views']) ? $uplift['views'] : 0;
             if (100 >= $views) {
                 $ups[] = $uplift;
             } else {
                 if ($uplift['end'] > time()) {
                     $ups[] = $uplift;
                 }
             }
         }
         $row->uplifts = $ups;
         $row->jours = $jours;
         $row->services = $services;
         $row->contraintes = $contraintes;
         $row->accompagnements = $accompagnements;
         $row->descriptions = $descriptions;
         $row->contraintes = $contraintes;
         $row->save();
     }
 }