<?php

include_once __DIR__ . "/ConstructionCompanyTable.php";

class EBMUnits extends ConstructionCompanyTable{

  public function vidaMilao($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    $line_count = -1;
    $parking_spaces = '';
    foreach($csv as $line) {
      $line_count++;
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {
        if (strpos($line[0], 'Q')) {
          continue;
        }

        $data['unit_number'] = $line[0];
        //$data['area'] = $line[4];
        $data['parking_spaces'] = $parking_spaces . ' ' . $line[1];
        $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        $data['availability'] = 1;
        $data['crawler_type_id'] = 4;
        $data['verified'] = 1;

        $data['entry'] = $line[9];
        $data['installment'] = $line[10];
        $data['financing'] = $line[11];
        $data['price'] = $line[14];
        $data['enterprise_id'] = $enterprise_id;

        for($i=2;$i < 6;$i++) {
          if (preg_match("/\d+,\d+/", $line[$i])){
            $data['area'] = $line[$i];
          }else{continue;}
        }

        //multiline parking space info
        if (in_array($line[1][strlen($line[1])-1], ['e', ','])
            || !(strpos($line[1], 'e'))) {
          $extra = preg_replace('/[",]/', '', $csv[$line_count+1]);
          $data['parking_spaces'] = $data['parking_spaces'] . ' ' . $extra;
          $data['parking_spaces'] = preg_replace("/\).+/", ')', $data['parking_spaces']);
          $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        }
        $parking_spaces = '';
      }else{
        if (preg_match("/[A-Z]\d|\d+,|\d+[A-Z]/",$line[1])) { // is line contains only numbers, commas and quotes
          $parking_spaces = $line[1];
        }
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function wishAeroporto($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    $line_count = -1;
    $parking_spaces = '';
    foreach($csv as $line) {
      $line_count++;
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {
        if (strpos($line[0], 'Q')) {
          continue;
        }

        $data['unit_number'] = $line[0];
        //$data['area'] = $line[4];
        $data['parking_spaces'] = $parking_spaces . ' ' . $line[1];
        $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        $data['availability'] = 1;
        $data['crawler_type_id'] = 4;
        $data['verified'] = 1;

        $data['entry'] = $line[6];
        $data['installment'] = $line[7];
        $data['financing'] = $line[10];
        $data['price'] = $line[11];
        $data['enterprise_id'] = $enterprise_id;

        for($i=2;$i < 6;$i++) {
          if (preg_match("/\d+,\d+/", $line[$i])){
            $data['area'] = $line[$i];
          }else{continue;}
        }

        //multiline parking space info
        $parking_spaces = '';
      }else{
        if (preg_match("/[A-Z]\d|\d+,|\d+[A-Z]/",$line[1])) { // if line contains only numbers, commas and quotes
          $parking_spaces = $line[1];
        }
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function wishCoimbra($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    $line_count = -1;
    $parking_spaces = '';
    foreach($csv as $line) {
      $line_count++;
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {
        if (strpos($line[0], 'Q')) {
          continue;
        }

        $data['unit_number'] = $line[0];
        //$data['area'] = $line[4];
        $data['parking_spaces'] = $parking_spaces . ' ' . $line[1];
        $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        $data['availability'] = 1;
        $data['crawler_type_id'] = 4;
        $data['verified'] = 1;

        $data['entry'] = $line[6];
        $data['installment'] = $line[7];
        $data['financing'] = $line[10];
        $data['price'] = $line[11];
        $data['enterprise_id'] = $enterprise_id;

        for($i=2;$i < 6;$i++) {
          if (preg_match("/\d+,\d+/", $line[$i])){
            $data['area'] = $line[$i];
          }else{continue;}
        }

        //multiline parking space info
        $parking_spaces = '';
      }else{
        if (preg_match("/[A-Z]\d|\d+,|\d+[A-Z]/",$line[1])) { // if line contains only numbers, commas and quotes
          $parking_spaces = $line[1];
        }
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function eko($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    $line_count = -1;
    $parking_spaces = '';
    foreach($csv as $line) {
      $line_count++;
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {
        if (strpos($line[0], 'Q')) {
          continue;
        }

        $data['unit_number'] = $line[0];
        //$data['area'] = $line[4];
        $data['parking_spaces'] = $parking_spaces . ' ' . $line[1];
        $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        $data['availability'] = 1;
        $data['crawler_type_id'] = 4;
        $data['verified'] = 1;

        $data['entry'] = preg_match("/\d+/", $line[5]) ? $line[5] : $line[6];
        $data['installment'] = $line[6];
        $data['financing'] = $line[9];
        $data['price'] = $line[10];
        $data['enterprise_id'] = $enterprise_id;

        for($i=2;$i < 5;$i++) {
          if (preg_match("/\d+,\d+/", $line[$i])){
            $data['area'] = $line[$i];
          }else{continue;}
        }

        //multiline parking space info
        $parking_spaces = '';
      }else{
        if (preg_match("/[A-Z]\d|\d+,|\d+[A-Z]/",$line[1])) { // if line contains only numbers, commas and quotes
          $parking_spaces = $line[1];
        }
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function trezentosESessentaOeste($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    $line_count = -1;
    $parking_spaces = '';
    foreach($csv as $line) {
      $line_count++;
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {
        if (strpos($line[0], 'Q')) {
          continue;
        }

        $data['unit_number'] = $line[0];
        //$data['area'] = $line[4];
        $data['parking_spaces'] = $parking_spaces . ' ' . $line[1];
        $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        $data['availability'] = 1;
        $data['crawler_type_id'] = 4;
        $data['verified'] = 1;

        $data['entry'] = $line[9];
        $data['installment'] = null;
        $data['financing'] = $line[10];
        $data['price'] = $line[11];
        $data['enterprise_id'] = $enterprise_id;

        for($i=3;$i < 6;$i++) {
          if (preg_match("/\d+,\d+/", $line[$i])){
            $data['area'] = $line[$i];
          }else{continue;}
        }

        //multiline parking space info
        $parking_spaces = '';
      }else{
        if (preg_match("/[A-Z]\d|\d+,|\d+[A-Z]/",$line[1])) { // if line contains only numbers, commas and quotes
          $parking_spaces = $line[1];
        }
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }
}