PHP code example of lany / mingdaoyun

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

lany / mingdaoyun example snippets

MINGDAOYUN_APP_KEY=xxx
MINGDAOYUN_SIGN=xxx
MINGDAOYUN_HOST=http://xxx.com
  

use Lany\MingDaoYun\MingDaoYun;
 class IndexController extends Controller 
{
    //依赖注入方式
    public function index(MingDaoYun $mdy)
    {
        $data = $mdy->table('60efbf797b786d8a492bfcee')->get();
        dd($data);
    }
    //实例化服务方式
    public function index1()
    {
         $data = app('mdy')->table('60efbf797b786d8a492bfcee')->get();
         dd($data);
    }
}
   
 

 MINGDAOYUN_APP_KEY=xxx
 MINGDAOYUN_SIGN=xxx
 MINGDAOYUN_HOST=http://xxx.com
   

class Index extends BaseController
{

    public function hello($name = 'ThinkPHP6')
    {
        $data = app('mdy')->table('60efbf797b786d8a492bfcee')->get();
        var_dump($data);
    }
}

use Lany\MingDaoYun\Facade\MingDaoYun;

$appKey = "APPKEY"; //明道云APPKEY
$sign = "SIGN"; //明道云SIGN
$host = "http://xxx.xxx.com"; //私有部署域名
$mdy = MingDaoYun::init($appKey, $sign, $host);
$data = $mdy->table('worksheetId')->get();

$mdy = MingDaoYun::init('APPKEY', 'SIGN', '部署域名');

$mdy->table('worksheetId');

$mdy->table('worksheetId')->limit(5);

$mdy->table('worksheetId')->page(5);

$mdy->table('worksheetId')->fieldMap();

$mdy->table('worksheetId')->with('rowId', 'controlId');

$mdy->table('worksheetId')->with('rowId', 'controlId')->relations();

$mdy->table('worksheetId')->sort('field', $bool);

$mdy->table('worksheetId')->whereOr('field', '=', '123');

$mdy->table('worksheetId')->where('field', '!=', '123');

$mdy->table('worksheetId')->whereIn('field', ['Lany', 'Todd', 'Dom']);

$mdy->table('worksheetId')->whereNull('field');

$mdy->table('worksheetId')->whereNotNull('field');

$mdy->table('worksheetId')->whereDate('field', '2022-02-22');

$mdy->table('worksheetId')->whereNotDate('field', '2022-02-22');

$mdy->table('worksheetId')->limit(1)->page(1)->get();

$mdy->table('worksheetId')->find('rowId');

$mdy->table('worksheetId')->view('view')->get();

$data = [
    ['controlId' => 'controlId', 'value' => 'value'],
    ['controlId' => 'controlId', 'value' => 'value'],
];
$mdy->table('worksheetId')->insert($data);

$data = [
    [
        ['controlId' => 'controlId', 'value' => 'value'],
        ['controlId' => 'controlId', 'value' => 'value'],
    ],

];
$mdy->table('worksheetId')->create($data);

$mdy->table('worksheetId')->delete('rowId');

$update = [
    ['controlId' => '60efbf797b786d8a492bfce2', 'value' => '波波波力'],
    ['controlId' => '60efbf797b786d8a492bfce5', 'value' => '波波波力力力力力'],
];
$mdy->table('worksheetId')->update('rowId', $update);

$rowIds = [
    'rowId1', 'rowId2'
];

$update = [
    'controlId' => 'controlId', 'value' => 'value'
];
$mdy->table('worksheetId')->updateRows($rowIds, $update);

$mdy->table('worksheetId')->all();

$mdy->table('worksheetId')->count($keyword);

$mdy->table('worksheetId')->dateRange('plan_date', 'Next14Day')->get();

$mdy->table('worksheetId')->notDateRange('plan_date', 'Next14Day')->get();

$customize = [
    "controlId" => "62d903e1347b8802573306d3",
    "dataType" => 30,
    "spliceType" => 1,
    "filterType" => 2,
    "value" => "Jinji"
]
$mdy->table('worksheetId')->customize($customize)->get();

$mdy->table('worksheetId')->workflow(false);

$mdy->table('worksheetId')->notGetTotal(true);

$mdy->table('worksheetId')->whereBetween('fq_time', ['2023-11-01 7:00:00', '2023-12-21 7:00:00']);

$mdy->table('worksheetId')->whereNotBetween('fq_time', ['2023-11-01 7:00:00', '2023-12-21 7:00:00']);

class ProductItem extends Model implements SyncAdapter
{
    //Laravel
    use LaravelAdapter;
    //ThinkPHP
    use ThinkPHPAdapter;
}

    $data = app('mdy')->table('60efbf797b786d8a492bfcee')->all();
    \App\Models\ProductItem::syncToDB($data);
    //或者传入MingDaoYun实例
     $data = app('mdy')->table('60efbf797b786d8a492bfcee')->limit(1);
    \App\Models\ProductItem::syncToDB($data);

$mdy->table('60f631095d106d99c054e0bd')->whereGroup(function(\Lany\MingDaoYun\MingDaoYun $mdy) {
    $mdy->whereOr('user', '=', 'Lany')->where('friend', '=', 'Dom');
})->where('desc', '=', 'test')

shell
$ php artisan vendor:publish --provider="Lany\MingDaoYun\Provider\ServiceProvider"