<?php

include_once __DIR__ . "/ConstructionCompanyTable.php";

class TerralUnits extends ConstructionCompanyTable {

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

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

        $data['entry'] = $line[5];
        $data['installment'] = $line[8];
        $data['financing'] = $line[9];
        $data['enterprise_id'] = $enterprise_id;

        if (!$data['parking_spaces']) {
          $parking_spaces = '';
          if($this->isSingleCell($csv[$line_count-1], 1)) {
            $parking_spaces = $parking_spaces . preg_replace('/[" ,]/', '', $csv[$line_count-1]);
          }
          if($this->isSingleCell($csv[$line_count+1], 1)) {
            $parking_spaces = $parking_spaces . preg_replace('/[" ,]/', '', $csv[$line_count+1]);
          }
          $data['parking_spaces'] = $parking_spaces;
          $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        }
      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function nestVinteETres($csv, $enterprise_id) {
    $this->defaultMethod($csv, $enterprise_id);
  }

  public function fullBueno($csv, $enterprise_id) {
    $this->defaultMethod($csv, $enterprise_id);
  }

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

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

        $data['entry'] = $line[5];
        $data['installment'] = $line[6];
        $data['financing'] = $line[10];
        $data['enterprise_id'] = $enterprise_id;

        if (!$data['parking_spaces']) {
          $parking_spaces = '';
          if($this->isSingleCell($csv[$line_count-1], 1)) {
            $parking_spaces = $parking_spaces . preg_replace('/[" ,]/', '', $csv[$line_count-1]);
          }
          if($this->isSingleCell($csv[$line_count+1], 1)) {
            $parking_spaces = $parking_spaces . preg_replace('/[" ,]/', '', $csv[$line_count+1]);
          }
          $data['parking_spaces'] = $parking_spaces;
          $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        }
      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function dinastiaLivingDesire($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    foreach($csv as $line) {
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {

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

        $data['entry'] = $line[7];
        $data['installment'] = null;
        $data['financing'] = $line[6];
        $data['enterprise_id'] = $enterprise_id;

      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function victorianLivingDesire($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    foreach($csv as $line) {
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {

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

        $data['entry'] = $line[6];
        $data['installment'] = null;
        $data['financing'] = $line[7];
        $data['enterprise_id'] = $enterprise_id;

      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

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

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

        $data['entry'] = $line[6];
        $data['installment'] = $line[9];
        $data['financing'] = $line[11];
        $data['enterprise_id'] = $enterprise_id;

        if (!$data['parking_spaces']) {
          $parking_spaces = '';
          if($this->isSingleCell($csv[$line_count-1], 1)) {
            $parking_spaces = $parking_spaces . preg_replace('/[" ,]/', '', $csv[$line_count-1]);
          }
          if($this->isSingleCell($csv[$line_count+1], 1)) {
            $parking_spaces = $parking_spaces . preg_replace('/[" ,]/', '', $csv[$line_count+1]);
          }
          $data['parking_spaces'] = $parking_spaces;
          $data['parking_spaces_count'] = $this->countParkingSpaces($data['parking_spaces']);
        }
      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function hitMarista($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    foreach($csv as $line) {
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {

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

        $data['entry'] = $line[6];
        $data['installment'] = null;
        $data['financing'] = $line[5];
        $data['enterprise_id'] = $enterprise_id;

      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  public function veredaAreiao($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    foreach($csv as $line) {
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {

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

        $data['entry'] = $line[7];
        $data['installment'] = $line[9];
        $data['financing'] = $line[12];
        $data['enterprise_id'] = $enterprise_id;

      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  private function defaultMethod($csv, $enterprise_id) {
    $csv = explode("\n", $csv);
    $result_data = array();
    foreach($csv as $line) {
      $data = array();
      $line = str_getcsv($line);
      if ($this->isUnitNum($line[0])) {

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

        $data['entry'] = $line[8];
        $data['installment'] = $line[10];
        $data['financing'] = $line[13];
        $data['enterprise_id'] = $enterprise_id;

      }else{
        continue;
      }
      array_push($result_data, $data);
    }
    $this->units_helper->batchOfUnits($result_data);
  }

  private function isSingleCell($line, $column) {
    $values = array_count_values($line);
    if (count($values) > 1) { //if more than one item in line
      return false;
    }

    if (!$line[$column]) { //is this one item is not in specified position
      return false;
    }
    return true;
  }
}