Esempio n. 1
0
 /**
  * Read a CSV File
  * @param  [String] $file
  * @return [Mixed]  $data
  */
 public function readCSVFile($file, $table = null)
 {
     $app = \Cobalt\Container::fetch('app');
     ini_set("auto_detect_line_endings", "1");
     $data = array();
     $line = 1;
     $headers = array();
     $i = -2;
     $db = JFactory::getDBO();
     $table = $db->getTableColumns("#__" . $app->input->get('import_type', $table));
     $special_headers = array('company_id', 'company_name', 'stage_name', 'source_name', 'status_name', 'primary_contact_name', 'assignee_name', 'type');
     if (($handle = fopen($file, "r")) !== false) {
         while (($read = fgetcsv($handle, 1000, ",")) !== false) {
             $i++;
             $num = count($read);
             if ($line == 1) {
                 $headers = $read;
                 $data['headers'] = $headers;
             } else {
                 $line_data = array();
                 for ($c = 0; $c < $num; $c++) {
                     $header_name = array_key_exists($c, $headers) ? $headers[$c] : false;
                     if ($header_name) {
                         if (in_array($header_name, $special_headers)) {
                             $read[$c] = utf8_encode($read[$c]);
                             switch ($header_name) {
                                 case "company_id":
                                     $model = new Company();
                                     $new_header = "company_id";
                                     $company_name = $model->getCompanyName($read[$c]);
                                     $name = "name=\"import_id[" . $i . "][" . $new_header . "]\"";
                                     if ($company_name != "") {
                                         $name = $company_name;
                                     } else {
                                         $name = "";
                                     }
                                     $special_data = array('label' => $read[$c], 'value' => $name);
                                     break;
                                 case "company_name":
                                     $model = new Company();
                                     $new_header = "company_id";
                                     $company_id = $model->getCompanyList($read[$c]);
                                     $name = "name=\"import_id[" . $i . "][" . $new_header . "]\"";
                                     if (count($company_id) > 0) {
                                         $name = $company_id[0]['name'];
                                     } else {
                                         $name = $read[$c];
                                     }
                                     $special_data = array('label' => $read[$c], 'value' => utf8_encode($name));
                                     break;
                                 case "stage_name":
                                     $new_header = "stage_id";
                                     $stage_id = DealHelper::getStages($read[$c]);
                                     $name = "name=\"import_id[" . $i . "][" . $new_header . "]\"";
                                     if (count($stage_id)) {
                                         $keys = array_keys($stage_id);
                                         $stage_id = $keys[0];
                                     }
                                     $special_data = array('dropdown' => DropdownHelper::generateDropdown('stage', $stage_id, $name));
                                     break;
                                 case "source_name":
                                     $new_header = "source_id";
                                     $source_id = DealHelper::getSources($read[$c]);
                                     $name = "name=\"import_id[" . $i . "][" . $new_header . "]\"";
                                     if (count($source_id)) {
                                         $keys = array_keys($source_id);
                                         $source_id = $keys[0];
                                     }
                                     $special_data = array('dropdown' => DropdownHelper::generateDropdown('source', $source_id, $name));
                                     break;
                                 case "status_name":
                                     $new_header = "status_id";
                                     $status_id = DealHelper::getStatuses($read[$c]);
                                     $name = "name=\"import_id[" . $i . "][" . $new_header . "]\"";
                                     if (count($status_id)) {
                                         $keys = array_keys($status_id);
                                         $status_id = $keys[0];
                                     }
                                     $special_data = array('dropdown' => DropdownHelper::generateDropdown('deal_status', $status_id, $name));
                                     break;
                                 case "primary_contact_name":
                                     $new_header = "primary_contact_id";
                                     $model = new People();
                                     $contact = $model->searchForContact($read[$c]);
                                     if ($contact) {
                                         $special_data = array('label' => $contact[0]->label, 'value' => $contact[0]->value);
                                     } else {
                                         $special_data = array();
                                     }
                                     break;
                                 case "assignee_name":
                                     $new_header = "assignee_id";
                                     $model = new People();
                                     $contact = $model->searchForContact($read[$c]);
                                     break;
                                 case "type":
                                     $new_header = "type";
                                     $special_data = array('dropdown' => ucwords(DropdownHelper::getContactTypes($read[$c])));
                                     break;
                             }
                             $line_data[$new_header] = $special_data;
                         } else {
                             if (array_key_exists($header_name, $table)) {
                                 $line_data[$header_name] = utf8_encode($read[$c]);
                             }
                         }
                     }
                 }
                 if (count($line_data) > 0) {
                     $data[] = $line_data;
                 }
             }
             $line++;
         }
         fclose($handle);
     }
     return $data;
 }