123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 |
- $table->string('copyright_detail_code')->nullable();
- $table->string('zip_code')->nullable();
- $table->string('update_key_no')->nullable();
- $table->string('action_code')->nullable();
- $table->string('record_type_code')->nullable();
- $table->string('carrier_route_id')->nullable();
- $table->string('street_pre_drctn_abbrev')->nullable();
- $table->string('street_name')->nullable();
- $table->string('street_suffix_abbrev')->nullable();
- $table->string('street_post_drctn_abbrev')->nullable();
- $table->string('addr_primary_low_no')->nullable();
- $table->string('addr_primary_high_no')->nullable();
- $table->string('addr_prmry_odd_even_code')->nullable();
- $table->string('building_or_firm_name')->nullable();
- $table->string('addr_secondary_abbrev')->nullable();
- $table->string('addr_secondary_low_no')->nullable();
- $table->string('addr_secondary_high_no')->nullable();
- $table->string('addr_secny_odd_even_code')->nullable();
- $table->string('low_no_zip_sector_no')->nullable();
- $table->string('low_no_zip_segment_no')->nullable();
- $table->string('high_no_zip_sector_no')->nullable();
- $table->string('high_no_zip_segment_no')->nullable();
- $table->string('base_alt_code')->nullable();
- $table->string('lacs_status_ind')->nullable();
- $table->string('govt_bldg_ind')->nullable();
- $table->string('finance_no')->nullable();
- $table->string('stusps')->nullable();
- $table->string('countyfp')->nullable();
- $table->string('congressional_dist_no')->nullable();
- $table->string('muncipality_ctyst_key')->nullable();
- $table->string('urbanization_ctyst_key')->nullable();
- $table->string('prefd_last_line_ctyst_key)->nullable();
- $positions = [
- [1,1,'copyright_detail_code'],
- [2,5,'zip_code'],
- [7,10,'update_key_no'],
- [17,1,'action_code'],
- [18,1,'record_type_code'],
- [19,4,'carrier_route_id'],
- [23,2,'street_pre_drctn_abbrev'],
- [25,28,'street_name'],
- [53,4,'street_suffix_abbrev'],
- [57,2,'street_post_drctn_abbrev'],
- [59,10,'addr_primary_low_no'],
- [69,10,'addr_primary_high_no'],
- [79,1,'addr_prmry_odd_even_code'],
- [80,40,'building_or_firm_name'],
- [120,4,'addr_secondary_abbrev'],
- [124,8,'addr_secondary_low_no'],
- [132,8,'addr_secondary_high_no'],
- [140,1,'addr_secny_odd_even_code'],
- [141,2,'low_no_zip_sector_no'],
- [143,2,'low_no_zip_segment_no'],
- [145,2,'high_no_zip_sector_no'],
- [147,2,'high_no_zip_segment_no'],
- [149,1,'base_alt_code'],
- [150,1,'lacs_status_ind'],
- [151,1,'govt_bldg_ind'],
- [152,6,'finance_no'],
- [158,2,'stusps'],
- [160,3,'countyfp'],
- [163,2,'congressional_dist_no'],
- [165,6,'muncipality_ctyst_key'],
- [171,6,'urbanization_ctyst_key'],
- [177,6,'prefd_last_line_ctyst_key]'
- ];
- $filePath = '/home/josh/output.txt';
- $handle = fopen($filePath, "r") or die("Couldn't get handle");
- if ($handle) {
- while (!feof($handle)) {
- $buffer = fgets($handle, 4096);
- $row = new Zip4Row();
- foreach($positions as $position){
- $row->{$position[2]} = substr($l, $position[0], $position[1]);
- }
- $row->save();
- }
- fclose($handle);
- }
|