承接 mya-zaki/csvert 相关项目开发

从需求分析到上线部署,全程专人跟进,保证项目质量与交付效率

邮箱:yvsm@zunyunkeji.com | QQ:316430983 | 微信:yvsm316

mya-zaki/csvert

Composer 安装命令:

composer require mya-zaki/csvert

包简介

Import and Export CSV.

关键字:

README 文档

README

Configure Record Object

<?php
namespace App;

use MyaZaki\Csvert\Record;

class PostalCode extends Record
{
    public $delimiter = ',';
    public $enclosure = '"';
    public $escape = '\\';

    public $charset = 'SJIS-win';

    public $header = true;

    public $columns = [
        'Code',
        'Street',
        'City',
        'State',
    ];

    public function getAddress()
    {
        return $this->attributes['Street'] . ', ' . $this->attributes['City'] . ', ' . $this->attributes['State'];
    }
}

columns Header fields of CSV. This fields are keys of Record object.

header External source has header fields. default=true

charset
Encoding of the external source.
default=UTF-8

delimiter: The optional delimiter parameter sets the field delimiter (one character only).
default=','

enclosure: The optional enclosure parameter sets the field enclosure character (one character only).
default='"'

escape: The optional escape parameter sets the escape character (at most one character). An empty string ("") disables the proprietary escape mechanism.
default='\'

Please refer to https://www.php.net/manual/en/function.fgetcsv.php

Parse CSV

postal.csv

Code,Street,City,State
640941,"旭ケ丘","札幌市中央区","北海道"
600041,"大通東","札幌市中央区","北海道"
・・・

parse file

$parser = PostalCode::parse($filepath);
$address_list = [];
$parser->walk(function ($record) use (&$address_list) { // Call user function each line
    // Given Record instance
    $address_list[] = $record['Code'] . ' ' . $record->getAddress();
});

parse string

$parser = PostalCode::parseString($csv_content);
$records = $parser->get(); // Get Collection
$address = $records->where('State', '北海道')->first();
var_dump($address['Code']);

Save CSV

$writer = RecordSample::getWriter();

$collection = collect();
$collection->push(new PostalCode(['Code' => '600042', 'State' => '北海道', 'City' => '札幌市中央区', 'Street' => '大通西(1~19丁目)']));
$collection->push(new PostalCode(['Code' => '640820', 'State' => '北海道', 'City' => '札幌市中央区', 'Street' => '大通西(20~28丁目)']));

$writer->setRecords($collection);

$writer->save($filepath);

统计信息

  • 总下载量: 4
  • 月度下载量: 0
  • 日度下载量: 0
  • 收藏数: 0
  • 点击次数: 1
  • 依赖项目数: 0
  • 推荐数: 0

GitHub 信息

  • Stars: 0
  • Watchers: 1
  • Forks: 0
  • 开发语言: PHP

其他信息

  • 授权协议: MIT
  • 更新时间: 2019-04-12

承接程序开发

PHP开发

VUE

Vue开发

前端开发

小程序开发

公众号开发

系统定制

数据库设计

云部署

网站建设

安全加固